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

Describe concentrate on one source of competitive advantage, Do you think i...

Do you think it is better to concentrate on one source of competitive advantage (cost versus differentiation versus speed) or to nurture all three in a firm's operation?

Organizing process flows, Organizing Process Flows Five types of proc...

Organizing Process Flows Five types of process are distinguished. They are Project Production System Job Shop Production system Batch Production system

Explain the new optimal solution, Consider the following linear program: Ma...

Consider the following linear program: Max 1A + 1B s.t. 5A + 3B ?15 3A + 5B ? 15 A, B ? 0 a. What is the optimal solution for this problem? b. Suppose that the objective function i

Explain exceed the amount invested in auto loans, A bank is attempting to d...

A bank is attempting to determine where its assets should be invested during the current year. At present, $500,000 is available for investment in bonds, home loans, auto loans, an

Explain collective bargaining and grievance procedure, When a union negotia...

When a union negotiates, with management, on behalf of its members to define and interpret employment contracts, it is known as: Answer (1) mediation. (2) Collective bargaining. (3

Explain risks associated with the globalization, Are there any risks associ...

Are there any risks associated with the globalization of health care? Can these risks be mitigated? How

Explain the industry life cycle affect business strategy, How does the indu...

How does the industry life cycle affect business strategy? Detail your answer based on each stage: introduction, growth, maturity, and decline. (Please provide example(s) were appl

Activities relating to production system designing, Activities Relating to ...

Activities Relating to Production System Designing Decision relating to the production system design is the firm and foremost activity of the production management. This activi

Explain the replace with similar, Describe the four options highlighted in ...

Describe the four options highlighted in the case study in terms of their feasibility, acceptability and vulnerability. The four options at Chatworth -the adventure playground deci

Explain what is the purpose of drug courts, What is the purpose of drug cou...

What is the purpose of drug courts? What do you think will be their future? Do you think drug courts are a good idea? Why or why not?

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