Question: I need help solving questions 2 and 3. A sales manager wants to forecast monthly sales of the machines the company makes using the following

I need help solving questions 2 and 3.I need help solving questions 2 and 3. A sales

A sales manager wants to forecast monthly sales of the machines the company makes using the following monthly sales data. Month 1 2 4 5 Balance $3,803 $2,558 $3,469 $3,442 $2,682 $3,469 $4,442 $3,728 6 | 7 8 1. Use the information in the table above. Forecast the monthly sales of the machine for month 9, using the three-month moving-average method. 3 month moving average for month 9: = (Month 6 + Month 7 + Month 8)/3 (3469+4442+3728)/3 11639/3 = 3879.67 Monthly sales for Month 9 = $3,880 2. Use the information in the table above. Use the 3-month weighted moving average method to calculate the forecast for month 9. The weights are 0.60, 0.30, and 0.10, where 0.60 refers to the most recent demand. Month January February March April May Demand 480 520 535 550 590 630 June 3. Use the information in the table above. Use an exponential smoothing model with a smoothing parameter of 0.30 and an April forecast of 525 to determine what the forecast sales would have been for June

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!