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 what are the tradeoffs between profitability, What are the tradeoff...

What are the tradeoffs between profitability, risk, and control that should be considered when choosing between debt and equity?

Ramjee Somjee Dutt, After working for 30 years, Ramjee Somjee Dutt opted fo...

After working for 30 years, Ramjee Somjee Dutt opted for VRS and started a courier company and did very well in the first four years. He was now looking for expansion of his busine

Explain team overcome resistance to the new ownership, You are the internal...

You are the internal relations manager for Elan, an Irish biotech firm, when it is acquired by Johnson and Johnson. How will you help the top management team overcome resistance to

Calculate the old and new ratios for energy, Angies Bakeries is wooried abo...

Angies Bakeries is wooried about increased costs. The company invested an additional $3000 to make the baker's oven more energy efficient. The ovens are supposed to be 15% more ene

How to implement new hr strategic objectives, Identify and describe a curre...

Identify and describe a current situation, within your current or former organization, where the challenges of the process of change, due to a competitive global environment, has

Explain the liability of each party, Upon graduation from college, Bob, Car...

Upon graduation from college, Bob, Carol, Ted, and Alice formed Kotaku, LP, a limited partnership, to distribute video gaming software over the Internet. Bob and Carol each contrib

Decision making approaches, Decision Making Approaches General Framewo...

Decision Making Approaches General Framework Outline the meaning of Rationality, Bounded Rationality and Intuitive approaches to decision making. Individual Components

Computer the reorder point, (b) Suppose Norwitch has worked out a new contr...

(b) Suppose Norwitch has worked out a new contract, accepted by all its customers, of being allowed up to one week to satisfy each demand. Norwitch still uses a 99% "fill rate" as

Discuss the fundamental role of managers and leaders, In organizations ther...

In organizations there are supervisors, managers and leaders. What makes them different? Define each role and discuss the fundamental differences of each. Give position specific ex

Statistical process control, Statistical Process Control Quality Plann...

Statistical Process Control Quality Planning is a key feature of TQM is the prevention of non-conformance. Two of the pioneers of TQM, Edwards Deming and Joseph Juran, strongl

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