Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In this Excel file Download this Excel fileyou will find the sales data of a particular model of a snow blower for 20 time seasons.
Inthis Excel file Download this Excel fileyou will find the sales data of a particular model of a snow blower for 20 time seasons. Open the spreadsheet and complete the orange colored cells using the Winter's forecasting method with Alpha 0.3 and Gamma 0.2. The rest of the cells were calculated for you.
What is the forecast for period 21? ANSWER: [ Select ] ["44", "47", "49", "42"]
What is the Mean Absolute Error (MAPE) of the estimation: [ Select ] ["14.9%", "8.9%", "12.9%", "10.9%"]