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

Explain generating positive organizational behaviour, One of the constants ...

One of the constants in organizations is the presence of change. In almost all change scenarios, human behaviour is impacted. However, organizational members often resist change. W

Explain performance appraisals are they necessary, 1.What purpose do they s...

1.What purpose do they serve under a performance management system? 2.Performance appraisals are they necessary or not? 3.What to do if an performance appraisal is unsatisfac

Explain how many machines should be purchased, Up, up, and away is a produc...

Up, up, and away is a producer of kites and wind socks. Relevant data on a bottleneck operation in the shop for the upcoming fiscal year are given in the following table: Item Kite

Develop a hypothesis test that can be used to what, According to a study, t...

According to a study, the mean price of a gallon of unleaded gasoline in the United States is 4.15. a sample of 25 Chicago area gas station shows the mean price of 4.95. the standa

The ability to rapidly as inexpensively switch production, The ability to r...

The ability to rapidly and inexpensively switch production from one product to another enables which of the following

Explain different models of organizational change, There are many different...

There are many different models of organizational change. Each has advantages and disadvantages. It is up to the organizational development specialist to match the specific model t

Number of shiments and number of defective shiments, The quesstion is to de...

The quesstion is to develop a scattr diagram using total number of shiments and number of defective shiments. This is for Project management mgmt. can some one help me with this

Describe the steps accuracy of the information, Rate, from the best to the ...

Rate, from the best to the worst, each of the sources you indicated in #1 above as being sources you will use in your analysis in terms of its probable reliability. Discuss the ste

Explain functions in which industrial manager is involved, Explain function...

Explain functions in which industrial manager is involved? The Industrial Manager is occupied in the given functions:- (i) Design products which will find acceptance in comp

The best alternative is to build large wing, Chris Suit is administrator fo...

Chris Suit is administrator for Lowell Hospital. She is trying to determine whether to build a large wing on the existing hospital, a small wing or no wing at all. POPULATION TR

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