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 advantage most likely to endure over time, 1).What are the primary ...

1).What are the primary implications of the material discussed in this chapter for strategy formulation? 2). When is a company's competitive advantage most likely to endure over ti

Accounting, describe the element that makeup TQM as amoderv philosophy and...

describe the element that makeup TQM as amoderv philosophy and quality mangementsamodern

Explain what will be the total costs for each alternative, Ergonomics Inc. ...

Ergonomics Inc. sells ergonomically designed office chairs. The company has the following information: Average demand = 54 units per day Average lead time = 30 days Item u

Describe two methods for allocating cost analysis, Explain two methods for ...

Explain two methods for allocating costs. Justify why you selected them and how you would make the most use of them in cost analysis.

Financial executives helped by hr department, How might an HR department he...

How might an HR department help to develop financial executives who are ethical leaders and mentors?

Explain null and alternative hypotheses to be tested, TRUE or FALSE. The Se...

TRUE or FALSE. The Sergio Lumber Company manufacturers plywood. One step in the process is the one where the veneer is dried by passing through a huge dryer (similar to an oven) wh

General model of the operations function, General Model of the Operations F...

General Model of the Operations Function This figure illustrates the basic concept of the operations function. Firstly inputs are transformed (converted) to outputs with the m

Explain manufacturing and service processes using queuing, Briefly compare ...

Briefly compare and contrast the manufacturing and service processes using queuing and assembly lines as your items to compare and contrast

Explain establishing team operating principles, Team operating principles a...

Team operating principles are sometimes included in a project charter to enhance team functioning. Which of the following statements accurately describes the value of establishing

Explain why is km extremely valuable in areas of research, Why is KM extrem...

Why is KM extremely valuable in areas of research and development? How do the different components of MITRE's KM system assist in spreading knowledge throughout its labs and in sto

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