Question: Use the sales data provided in the Excel Sheet to find the sales forecasting as follows: 1 - 3 months and 5 months moving average

Use the sales data provided in the Excel Sheet to find the sales forecasting as follows:
1-3 months and 5 months moving average forecasting.
2-3 months and 5 months weighted moving average forecasting considering the following weights (0.2,0.3,0.5) for the 3 months weighted moving average and (0.2,0.3,0.4,0.5,0.6) for the 5 months weighted moving average. (note highest weight is given to the recent value)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!