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 path for data between two points on a network, Name 3 factors that ...

Name 3 factors that a router must consider when determining the best path for data between two points on a network?

What are long-term, What are long-term, departmental and Non-Economic decis...

What are long-term, departmental and Non-Economic decisions? If long term decisions, the time period covered is long and the risk included is more. Departmental decisions rela

Explain judges selected based on the courts system, What are six ways judge...

What are six ways judges selected based on the courts system?

Explain what decision should be made by the optimist, Company must decide h...

Company must decide how many lots of chocolate muffin premix to order for its three stores. Information on pricing, sales, and inventory costs has led to the following payoff table

Explain setup cost is independent of order size, 1. A stock out occurs when...

1. A stock out occurs when an item that is typically stocked is not available to satisfy a demand the moment it occurs. 2. A backorder occurs when a customer order cannot be fil

Flexible work schedules in their organizations describe, What can HR manage...

What can HR managers do to help facilitate flexible work schedules in their organizations?

Explain los angeles court syestem, I need Los Angeles Court Syestem. I need...

I need Los Angeles Court Syestem. I need orginal thought no plagerism or won't award points. Assignment Complete the following, placing it in a single Word document. You h

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.

Rationalize your compensation as well benefits package, Rationalize your co...

Rationalize your compensation and benefits package. Be sure to indicate the research and considerations that went into the design of the compensation and benefits package.

Explain what is the optimal stocking level, Henrique's Correa's bakery prep...

Henrique's Correa's bakery prepares all its cakes between 4am and 6am so they will be fresh when customers arrive. Day-old cakes are virtually always sold but at a 50% discount off

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