Two independent methods of forecasting based on judgment and experience have been prepared each month for...

90.2K

Verified Solution

Question

Advance Math

Two independent methods of forecasting based on judgment andexperience have been prepared each month for the past 10 months.The forecasts and actual sales are as follows:

MonthSalesForecast 1Forecast 2
1845815820
2835835825
3795820825
4820830795
5795785780
6835785771
7805810785
8850780785
9840805830
10805815825

     

a. Compute the MSE and MAD for each forecast.(Round your answers to 2 decimalplaces.)

MSEMAD
Forecast 1??
Forecast 2??

   

b. Compute MAPE for each forecast.(Round your intermediate calculations to 5 decimal placesand final answers to 4 decimal places.)

MAPE F1  ?   %
MAPE F2?    %

c. Prepare a naive forecast for periods 2through 11 using the given sales data. Compute each of thefollowing; (1) MSE, (2) MAD, (3) tracking signal at month 10, and(4) 2s control limits. (Round your answers to 2decimal places.)

MSE?
MAD?
Tracking signal?
Control limits0 ± ?

Answer & Explanation Solved by verified expert
4.3 Ratings (986 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students