Compare the accuracy of forecast 1 and forecast 2

Assignment Help Business Management

Reference no: EM131801575

The table below shows the results of two methods (Forecast 1 and Forecast 2) of forecasting for frozen prepared dinners, as well as the demand for the eight periods. PREDICTED DEMAND Period Demand F1 F2 1 68 67 65 2 75 67 66 3 70 73 70 4 74 69 69 5 69 72 72 6 72 66 73 7 80 70 75 8 78 77 81

a. Compare the accuracy of Forecast 1 and Forecast 2 by calculating the Mean Absolute Deviation for each one. Which is more accurate? (Round your answers to 2 decimal places.) MAD F1 MAD F2 appears to be more accurate.

b. Compare the accuracy of Forecast 1 and Forecast 2 by calculating the Mean Squared Error for each one. Which is more accurate? (Round your answers to 2 decimal places.) MSE A MSE B appears to be more accurate.

c. Managers can use either of these error methods to compare forecasts. In what situation would someone use MAD? MSE? (Hint: MSE goes with control charts; MAD goes with tracking signals). Either one might already be in use, familiar to users, and have past values for comparison. If are used, MSE would be natural; if are used, MAD would be more natural.

d. Compare the accuracy of Forecast 1 and Forecast 2 by calculating the Mean Absolute Percent Error for each one. Which is more accurate? (Round your intermediate calculations to 2 decimal places and and final answers to 2 decimal places.) MAPE F1 MAPE F2 appears to be more accurate.

Reference no: EM131801575

Questions Cloud

How does a conflict checker operate : Padding a bill or double-billing a client for the same charges are serious errors, which may result in disciplinary action and penalties.

Find the linear equation that is the best for the given data : Use linear regression to find the linear equation that is the best for these data, with x representing the earnings for males and y representing.

National average for the math portion of the college board : Suppose that the national average for the math portion of the College Board's SAT is 527. The College Board periodically rescales the test scores

Solution of the transportation table : How would you do it? What other factors are important but will not be considered in the solution of the transportation table?

Compare the accuracy of forecast 1 and forecast 2 : Compare the accuracy of Forecast 1 and Forecast 2 by calculating the Mean Absolute Deviation for each one. Which is more accurate?

Find the expected annual retirement benefits of service : Retirement benefits the table gives the approximate benefits for PepsiCo executives who earned an average of $250,000 per year during the last 5 years.

Determining the aggresiveness and assertiveness : As it is aptly said there is a very thin line between aggresiveness and assertiveness. Hence the leader has to tread wisely with a well balanced approach.

What is the net operating income earned by product : What is the net operating income earned by product F275 according to the company's accounting system? Show your work!

The variance between the actual results and flexible budget : Determine whether each variance between the actual results and flexible budget is favorable or unfavorable

User Account

All Pages