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 disney incorrectly from the day it opened its door, Business Case D...

Business Case Disneyland resort Paris: mickey goes to Europe I am confused about this case. These are the questions my teacher assigned for it. 1.) What Disney did incorrectl

Explain human resource management legal issues, Submit Apple, Inc.'s Human ...

Submit Apple, Inc.'s Human Resource Management Legal Issues related to Apple, Inc.'s HRM Strategic Workforce Improvement Plan project

Explain breakeven point in dollars of sales, A firm is selling two products...

A firm is selling two products, chairs and bar stools, each at $50 per unit. Chairs have a variable cost of $25 and bar stools $20 Fixed cost for the firm is $200 a. if the sales m

Explain function of operational leadership, Create a scenario that depicts ...

Create a scenario that depicts how the first line leader should act to fulfil the purpose and function of operational leadership in his or her area

Compute the expected monetary value, Superior Products Inc. is considering ...

Superior Products Inc. is considering two potential equipment alternatives for production of their best selling product line. Option 1 involves proven equipment: Fixed cost investm

Why the production manager is asked to reduce the safety, The annual demand...

The annual demand for a product is 15,600 units. The weekly demand is 300 units with a standard deviation of 90 units. The cost to place an order is $31.20, and the time from order

Explain what is modern management theory, What is modern management theory ...

What is modern management theory because are we not just working from the Scientific Management Theories of the 40s and 50? so what is more modern?

Compute what will be the value, Can you show me step by step how to solve t...

Can you show me step by step how to solve the following problem? Payments of $20,000 at 6% interest Compounding quarterly What will be the value in 12 years?

. Linear Programming Problem, A paper mill produces two grades of paper viz...

A paper mill produces two grades of paper viz., X & Y. Because of raw material restrictions, it cannot produce more 400 tons of grade X paper & 300 tons of grade Y paper in a week.

Compare the traditional and matrix organization, Compare and contrast the t...

Compare and contrast the traditional and matrix organization. What are its advantages and disadvantages of the matrix organization?

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