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

Define what behavioural predictions might you make, What behavioural predic...

What behavioural predictions might you make if you know that an employee had an external locus of control? If an employee had a high need for achievement? If an employee had a low

Explain what impact did this have on team performance, In 100 words or less...

In 100 words or less, please describe a team situation, which has included the type of people you find it difficult to work with. What impact did this have on team performance? How

Explain statistical cost estimation technique, The technique that estimates...

The technique that estimates long-run costs and the minimum efficient scale by determining the scale of operation at which most firms in an industry are concentrated is called the-

Explain simple to state and very difficult to execute, The Assignment is at...

The Assignment is at the same time very simple to state and very difficult to execute. It is designed to allow you to use all the tools of strategy and analysis that you have learn

What are the ways in which corporations can demonstrate, What are three way...

What are three ways in which corporations can demonstrate a sense of social responsibility?

Find range of annual volume, A firm plans to begin production of a new smal...

A firm plans to begin production of a new small appliance. The manager must decide whether to purchase the motors for the appliance from a vendor at $7 each or to produce them in-h

How meet small towns daily requirement, Determine how to minimize the numbe...

Determine how to minimize the number needed to meet small towns daily requirement

Explain the categories of problems in six sigma methodology, Describe the c...

Describe the categories of problems that have been found to be approached by Six Sigma methodology Type your question here

Explain inquiring minds want to know, On companion website Read Case Stu...

On companion website Read Case Study: Inquiring Minds Want to Know 1 Build the management-research question hierarchy. 2 What ethical issues are relevant to this study?

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