The manager wants to forecast the month 6’s sales using the following historical data: Months Sales Month 1 20 Month 2 2
Posted: Sun Jul 03, 2022 1:31 pm
The manager wants to forecast the month 6’s sales usingthe following historical data:
Months
Sales
Month 1
20
Month 2
25
Month 3
32
Month 4
35
Month 5
38
Please use the weight 0.45 for Month 5, weight 0.25 for Month 4,weight 0.2 for Month 3, and weight 0.1 for Month 2 to use theweighted moving average to forecast the demand of Month5.
Please answer and show work.
Months
Sales
Month 1
20
Month 2
25
Month 3
32
Month 4
35
Month 5
38
Please use the weight 0.45 for Month 5, weight 0.25 for Month 4,weight 0.2 for Month 3, and weight 0.1 for Month 2 to use theweighted moving average to forecast the demand of Month5.
Please answer and show work.