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

Small organizations or large organizations differ in design, How do small o...

How do small organizations and large organizations differ in design?

Principles and Practices of Management, How will you influence people to st...

How will you influence people to strive willingly for group objectives in your organization (target based industry)? Apply your interpersonal influence through communication proces

Explain the aspects of the proposed new business, Using the information pro...

Using the information provided, prepare the report that Vicky Roberts requested, assuming that the project will begin immediately. Assume 45 working days are available to complete

Supply chain operation, Please diagram a supply chain.  I prefer that you d...

Please diagram a supply chain.  I prefer that you diagram the supply chain of your company.  However, some of you may wish to select another supply chain with which you are familia

Describe the value chain, Question 1: Describe the main growth strategi...

Question 1: Describe the main growth strategies that a firm can pursue and discuss conditions that favour each strategic option. Support your answer with suitable examples.

Determine the layout decision, Determine the Layout Decision Consider ...

Determine the Layout Decision Consider a layout decision which has been made in your own organisation. How was the layout devised? What were the key issues?

Explain counteract prejudice, Counteracting Prejudice One of the simplest a...

Counteracting Prejudice One of the simplest and most powerful ways to counteract prejudice and discrimination is to articulate and share stereotypes and preconceived notions. How c

Explain net income, Scott Equipment Organization is investigating various c...

Scott Equipment Organization is investigating various combinations of short- and long-term debt in financing assets. Assume the organization has decided to employ $10 million in cu

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

Sink and tuttle strategic matrix - performance measures, Sink and Tuttle st...

Sink and Tuttle strategic matrix  Sink and Tuttle (1989) conducted a review of literature and identified several criteria for measuring a company. Their framework builds on th

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