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

, What happens if balance doesn’t exis

What happens if balance doesn’t exist

Compute the holding period return for an investor, The prices for company A...

The prices for company A for the first quarter of 2007 are given below. The price of the stock on January 1, 2007 was $120. Find the holding period return for an investor who purch

Describe three issues that can deter high performance, Discuss three issues...

Discuss three issues that can deter high performance when outsourcing a project. Discuss ways that these issues can be reduced or eliminated ahead of time or during the project dur

Explain six sigma principles to health care organizations, Type two savings...

Type two savings are the least likely to occur when applying Six Sigma principles to health care organizations

Explain problem of industrial marketing in india, Explain problem of indust...

Explain problem of industrial marketing in india.   Industrial market has all individuals and organisations which acquire goods and services into the production of other product

What are the common barriers to team progress, Question 1: W. E. Deming...

Question 1: W. E. Deming is credited with providing the foundation of Japanese Quality and resurgence as an economic power. Deming is the best known quality expert in the worl

Explain decision alternatices and various levels of demand, The following p...

The following payoff table provides profits based on various possible decision alternatices and various levels of demand at Amber Gardner's software firm

Explain reducing the project duration increases the risk, Take a position o...

Take a position on the following statement from the textbook author: "Reducing the project duration increases the risk of being late." Support your position

Explain which depreciation method is preferable, 1. Your firm is considerin...

1. Your firm is considering an investment in a wind farm. Assume that the farm will cost $1 million per MW of installed capacity. The plan under consideration would deploy 10 GE 1.

Summarize the key points of the performance improvement, Briefly summarize ...

Briefly summarize the main points of the Performance Improvement article. Discuss one item that you have learned from the reading and how you might benefit from the information. (I

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