Hello! I'm working for a small company which manufactures electrical accessories. We've been tracking our scrap products qty and cost associated with it through our SAP system. Since i have all the data, I'd like to set a realistic scrap cost target or scrap qty target based on the record of previous months data. I tried using "forecast by one period" by adding linear trendline in excel sheet but it doesn't help me much in setting a target for following month. Does anyone here have any suggestions for me in order to set realistic goals?
Sent from my Pixel 2 using Tapatalk
Sent from my Pixel 2 using Tapatalk