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

Which selection criteria do you think would be most valuable, Which selecti...

Which selection criteria (personal interview, employment test, assessment center) do you think would be most valuable for predicting effective job performance for a college profess

Structural adjustment - factor affecting productivity, Structural Adjustmen...

Structural Adjustments - Factors Affecting Productivity Improvement Structural adjustment relates to the composition of society, the industries in which people work, fashions

What are the disadvantages of ethical relativism, What are some of the adva...

What are some of the advantages and disadvantages of ethical relativism as an ethical philosophy for business managers? Do you agree with the basic "relativism" rationale justifyin

Explain implementing a relational database, What benefits would Bill get fo...

What benefits would Bill get for his business from implementing a relational database? Your response must be tied directly to Bill's pizza stores.

Thoroughly explain two major threats united airlines, Thoroughly describe t...

Thoroughly describe two major threats united airlines is facing

What are generally accepted accounting principles, Yvon, an accountant, is ...

Yvon, an accountant, is charged with negligence by Zesty Sauce, Inc., a client. Yvon may successfully defend against the claim if she can show that (Points : 2) scienter was lackin

Explain the first stage in the new-product process is, The first stage in t...

The first stage in the new-product process is idea generation. screening and evaluation. business analysis. new-product strategy development. concept testing.

Upper and lower control limits, Clerks at Lotsa Data Systems key in thousan...

Clerks at Lotsa Data Systems key in thousands of insurance records each day for a variety of client firms.  The process is in control but CEO Donna Lotsa wants to be sure that at

Ch 6, I-mart is a discount optical shop that can fill most prescription ord...

I-mart is a discount optical shop that can fill most prescription orders in around 1 hour. The management is analyzing the processes at the store. There currently is one person ass

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