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 the specific human resources concerns, Describe the specific human ...

Describe the specific human resources concerns (competencies, labour economics, legal & regulatory systems, labour relations & unionization, and cultural norms) for one chosen coun

Explain what is the status of the internet contract, Beth advertised her 20...

Beth advertised her 2005 Corvette for sale on the Internet. In her advertisement, she falsely stated that the vehicle had only been driven 60,000 miles when in fact it had been dri

Describe yelled at her in front of co-workers, Recall the case in which an ...

Recall the case in which an employee claimed harassment by her supervisor in which he altered her work hours with the knowledge that doing so would adversely affect her hypoglycaem

What are the primary external organizational considerations, Do you think t...

Do you think these primary external organizational considerations are the same across all industries, or do different industries (like manufacturing vs. health care) have different

Calculate the economic order quantity, A local nursery greens uses 1560 bag...

A local nursery greens uses 1560 bags of plant food annually. Green works 52 weeks per year. It costs $10 to place an order for plant food. The annual holding cost rate is $5 per b

Explain changing nature of work and the workplace, Effective human resource...

Effective human resources professionals have a solid understanding of the changing nature of work and the workplace. Compare and contrast the evolution of work and the workplace ov

Transportation method, Transportation  Method We  solve the transportati...

Transportation  Method We  solve the transportation  problem using the followings steps in order: a. Structuring the problem  into the  transportation  framework. b. Findi

Explain lower control limits for mean and range charts, Determine upper and...

Determine upper and lower control limits for mean and range charts.

Describe how you perceive personality, In this assignment, you will develop...

In this assignment, you will develop a ten item survey that will be given to all applicants at your company. The purpose of this survey is to determine whether the applicant is a p

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