Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Mathematics questions