Forecasting, Operation Management

Assignment Help:
The cafeteria supervisor at CarWash is interested in developing a forecast model for the number of meals to be prepared each day. The following daily data from the cafeteria’s register were collected. Using the data, the supervisor had already computed forecast values using a regression model. However, s/he would like to assess the regression model’s accuracy to a base model called “exponential smoothing.”

WORKING AREA FOR THE PROBLEM
Exponential Regression
Day Meals Forecast Error Forecast Error
1 37 36.94
2 40 38.66
3 41 40.38
4 37 42.11
5 45 43.83
6 50 45.55
7 43 47.28
8 47 49.00
9 56 50.73
10 52 52.45
11 55 54.17
12 54 55.90

a) Your job is to compute forecasts using exponential smoothing technique with alpha of 0.3. Assume the initial forecast for day 1is 37. Show details for at least three calculations


b) Is the regression model a better fit to the data? Explain why. Use CFE and MAD as accuracy measurements.


c) Regardless of your decision in part (b), assume now that CarWash had been using the regression model in forecasting. What would you conclude about its performance? Show details for updated MAD calculations, at least for three periods. Use action limits that correspond to 3s control limits, and plot the corresponding tracking signal values. (HINT: 1sigma = 1.25 MAD, action limit is plus and minus and counts for how many MAD we have in specified number of sigma.)

Related Discussions:- Forecasting

Management of change projects, Choose an Operations Management problem rela...

Choose an Operations Management problem relating to an organisation with which you are familiar and undertake a critical review. This should include (indicative marks provided):

Explain current managerial ranks or be sought from outside, Should the plan...

Should the plant manager come from inside the current managerial ranks or be sought from outside?

Explain quality is considered to be a structural element, Quality is consid...

Quality is considered to be a structural element of the strategic service concept.

Visual basic 2010 problems, Are the practice questions at the end of the ch...

Are the practice questions at the end of the chapters in starting out with Visual Basic 2010 5th edition a good representation of the questions in the Test Bank?

Explain measurements used in the selection process, Briefly, identify and d...

Briefly, identify and describe, in your own words, the different measurements used in the selection process. What are the advantages and disadvantages of each?

How conduct an analysis of american apparel, Conduct an analysis of America...

Conduct an analysis of American Apparel. Assess American Apparel's vertical integration, global strategy, and diversification. Compare American Apparel's approach to Google's

Explain some of the near-term and long-term results, As the industry watche...

As the industry watches to see how United Airlines' strategy performs against American Airlines' strategy, management at United Airlines is anxiously monitoring market signs to det

Explain the quantitative, 1.   Explain the quantitative foundation of Six S...

1.   Explain the quantitative foundation of Six Sigma, and discuss how following the phases of the DMAIC improvement lifecycle ensures that the quantitative aspect of the approach

Linear trend equation, A cosmetics manufacturers marketing department has d...

A cosmetics manufacturers marketing department has developed a linear trend equation that can be used to predict annual sales of its popular Hand and Foot Cream. We are given F sub

Potential advantages, Book Edition Company Book Edition Company p...

Book Edition Company Book Edition Company produces very rare cover pages for history books. Reader habits change a lot and they change their mind a lot. The cover pages a

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd