Compute mape for each forecast

Assignment Help Operation Management

Reference no: EM131632112

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

Month Sales Forecast 1 Forecast 2 1 770 771 769 2 789 785 787 3 794 790 792 4 780 784 798 5 768 770 774 6 772 768 770 7 760 761 759 8 775 771 775 9 786 784 788 10 790 788 788

a. Compute the MSE and MAD for each forecast. Does either forecast seem superior? Explain. b. Compute MAPE for each forecast. c. Prepare a naive forecast for periods 2 through 11 using the given sales data. Compute each of the following; (1) MSE, (2) MAD, (3) tracking signal at month 10, and (4) 2 s control limits. How do the naive results compare with the other two forecasts?

Reference no: EM131632112

Questions Cloud

Find the market expected treasury rate : The Wall Street Journal reports that the rate on four-year Treasury securities is 5.60 percent and the rate on five-year Treasury securities is 6.15 percent.

What are the expected one-year rates during given years : A recent edition of The Wall Street Journal reported interest rates of 2.25 percent, 2.60 percent, 2.98 percent, and 3.25 percent for three-year.

What should be the current rate for a treasury security : The current one-year Treasury-bill rate is 5.2 percent and the expected one-year rate 12 months from now is 5.8 percent.

What are the three types of measures for any process : What are the three types of measures for any process?

Compute mape for each forecast : Compute MAPE for each forecast. Prepare a naive forecast for periods 2 through 11 using the given sales data.

Long-life insurance has developed a linear model : Long-Life Insurance has developed a linear model that it uses to determine the amount of term life insurance a family of four should have,

Uses exponential smoothing to forecast equipment : A dry cleaner uses exponential smoothing to forecast equipment usage at its main plant. August usage was forecasted to be 88 percent of capacity;

Store budgets when they reclassified the asms as nonexempt : Why does the court consider it important that Starbucks did not increase store budgets when they reclassified the ASMs as nonexempt?

What is the largest number of daily shares traded on nyse : Go to the New York Stock Exchange Web site at www.nyse.com and find the latest figures for top NYSE volume days.

User Account

All Pages