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 the term organisation structure, Explain the term organisation stru...

Explain the term organisation structure. It is the systematic arrangement of the people doing work for the organisation so as to achieve predecided goals.  This structure is

Explain how many observations would be needed, To determine the standard wo...

To determine the standard working time for a special job, following observation data is collected: Observation 1 2 3 4 5 6 7 8 Time (in second) 17 18 15 14 13 15 16 13 a) If the pe

Describe limitations of the relational model, Write a 200- to 350- word sho...

Write a 200- to 350- word short-answer response to the following: • Identify and describe three limitations of the relational model and recommend strategies to overcome these li

Quality management., examples of internal and external failure cost

examples of internal and external failure cost

What is a quality management system, Question: (a) What is a Quality Ma...

Question: (a) What is a Quality Management System (QMS) and why should an organization implement a Quality Management System? (b) Explain the eight fundamental Quality Manag

Explain direct marketing association website, On the Direct Marketing Assoc...

On the Direct Marketing Association website, what is interesting, how can companies use the website, what information is surprising and why?

Describe the importance of the calculation, Discuss the importance of the c...

Discuss the importance of the calculation and interpretation of ratios, to complete an effective financial ratio analysis?

Explain disadvantages of marketing a global product, Many firms try to mark...

Many firms try to market the same product as is in many different markets. The product is essentially the same, the only differences may be in packaging and messaging. What are

Decribe an examination-taking work plan, 1 Page maximum for the whole quest...

1 Page maximum for the whole question] : College students are "invincible". They study on the floor, spread their materials on the floor and lean over to access them, slouch in a c

Formulate an integer programming model using excel solver, New fire station...

New fire stations are to be located in a city and the major of the city wants to decide where to locate the 2 fire stations. For planning purposes, the region has been divided into

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