Evaluate different forecasting models

Assignment Help Operation Management

Reference no: EM131919664

Question: Use the Excel spreadsheet that accompanies this chapter to evaluate different forecasting models using the ice cream sales data. Try the following parameters for the moving average and simple exponential smoothing models: n = 1, 4, 8; alpha = 0.1, 0.5, 0.9. Which parameters yield the best forecasting model for the periods under evaluation?

Reference no: EM131919664

Questions Cloud

Five years using the straight-line method : The company fully depreciates all its rental cars over five years using the straight-line method.

Compare the effectiveness of weeks moving averages : Compare the effectiveness of two-week, four-week, and six-week moving averages. Which should you use to forecast copier paper use during the next week?

Your approximate real rate of return on investment : You sold your shares for $73.20 a share. What is your approximate real rate of return on this investment?

In measuring gross domestic product-market value refers : A growing economy is important in order to. In measuring Gross Domestic Product, market value refers to: Automatic stabilizers are:

Evaluate different forecasting models : Use the Excel spreadsheet that accompanies this chapter to evaluate different forecasting models using the ice cream sales data.

Calculate the forecasts for periods : Assume you are forecasting with an exponential smoothing model using a = 0.6. How much weight is placed on the most recent actual demand?

Determine which forecasting model fits the data better : Suppose that an electronics company has the monthly sales shown below. They want to develop forecasts using a time series regression model.

Identify a suitable forecasting model to estimate demand : Vinod Malhotra is trying to decide how many wait staff he will need to support his restaurant operations for the next month.

Describe the effects of the business trends on demand : What arguments would you use in order to justify tightening the limits used on a tracking signal control chart? How about for loosening the limits?

User Account

All Pages