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

Case study, After working for 30 years, Ramjee Somjee Dutt opted for VRS an...

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 busin

Explain competitive bidding, Why do some firms no longer rely only on compe...

Why do some firms no longer rely only on competitive bidding when awarding purchase contracts?

LINE BALANCING, . What do you understand by “line balancing”? What happens ...

. What do you understand by “line balancing”? What happens if balance doesn’t exist?

Describe the impact that batch size has on flow, Explain the impact that ba...

Explain the impact that batch size has on flow. Explain why the EOQ formula works.

Qualitative and quantitative justification, 1.  Maggie Company produces a l...

1.  Maggie Company produces a light fixture with the following unit costs:   Direct Materials: $2 Direct Labour: $2 Variable Cost: $3 Fixed Cost: $2 UNIT TOTAL COST: $9   The

Identify issues management wants to address, Identify issues management nee...

Identify issues management needs to address. Analyze and evaluate the issues identified and a set of actions management should take to address the issues identified.

Explain the common grounds for discharge, Describe the common grounds for d...

Describe the common grounds for discharge and the procedural requirements that are outlined in many collective bargaining agreements. State why the following are important when the

Explain a computer-supply mail order house has a memory chip, A computer-su...

A computer-supply mail order house has a memory chip in inventory that it sells to customers around the country. A Japanese manufacturer supplies the item using airfreight. It has

Explain a wealthy farmer owns fifty acres of land, A wealthy farmer owns fi...

A wealthy farmer owns fifty acres of land. He is going to plant each acre with sugarcane or corn. Each acre planted with sugarcane yields Rs 16,000 profit; each with corn yields Rs

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