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 how to create a living, What would you suggest to companies on how ...

What would you suggest to companies on how to create a living, adapting marketing plan?

What are complexities and risks involved with supply chains, Given the comp...

Given the complexities and risks involved with supply chains, might it make sense for a business organization to vertically integrate and be its own supply chain? Why or why not?

Explain formulate and solve a linear optimization model, Klein Industries m...

Klein Industries manufactures three air compressors: small, medium, and large, which have unit profits of $20.50, $34, and $42 respectively. The monthly projected sales of small ar

Explain what measures has he taken to extend the brand, What did Roy Choi d...

What did Roy Choi do to build the Kogi BBq band? What measures has he taken to extend the brand? What would further expansion hurt Roy Choi'sefforts? Why?

Vertically integrated or virtual organisation, Vertically Integrated or Vir...

Vertically Integrated or Virtual Organisation An organisation might decide not to source goods or services externally but to own the supplier company itself. For instance a

What is utility of computer- wide systems, Q. What is utility of computer- ...

Q. What is utility of computer- wide systems to manufacturing operations? Enterprise-wide systems (ERP systems) also considered as enterprise computing or enterprise resource p

Compute the productivity in sales revenue/labour expense, Sailmaster makes ...

Sailmaster makes high-performance sails for competitive windsurfers. Below is information about the inputs and outputs for one model, the Windy 2000. Units sold 1,217 Sale price ea

Complete the below table using rationale, Complete the below table. Which o...

Complete the below table. Which one of these techniques would you recommend to use and indicate your rationale? Technique Ave Bias Ave MAD MSE Ave MAPE Naïve

I need to describe forecasting, I need to explain forecasting, also how it ...

I need to explain forecasting, also how it is performed at St. Arnold's Brewery (Houston, TX) also what forecasting error is and if there has been any in the past.

What are some instances that would explain strategic groups, What are some ...

What are some examples that would explain strategic groups?

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