Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello can I please get this question answered using an excel sheet Consider the monthly demand for the ABC corporation as shown in Table 7-3.
Hello can I please get this question answered using an excel sheet
Consider the monthly demand for the ABC corporation as shown in Table 7-3. Forecast the monthly demand for year 6 using the static method for forecasting. Evaluate the bias, TS, MAD, MAPE, and MSE and the quality of the forecast.
Sales | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
January | 2000 | 3000 | 2000 | 5000 | 5000 |
February | 3000 | 4000 | 5000 | 4000 | 2000 |
March | 3000 | 3000 | 6000 | 4000 | 3000 |
April | 5000 | 5000 | 3000 | 2000 | 2000 |
May | 4000 | 5000 | 4000 | 5000 | 7000 |
June | 6000 | 7000 | 6000 | 7000 | 6000 |
July | 7000 | 3000 | 7000 | 12000 | 8000 |
August | 6000 | 8000 | 10000 | 14000 | 10000 |
September | 10000 | 12000 | 15000 | 16000 | 18000 |
October | 12000 | 11000 | 15000 | 16000 | 20000 |
November | 14000 | 16000 | 18000 | 20000 | 22000 |
December | 8000 | 10000 | 8000 | 12000 | 8000 |
Total | 80000 | 87000 | 99000 | 117000 | 111000 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started