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 authority to make such an agreement, White, Fring, and Pinkman are ...

White, Fring, and Pinkman are partners in the operation of the A1A car wash. Without Fring's knowledge, White and Pinkman sold 10 percent of their interest in the business and its

Modern global business environment, Describe briefly, major opportunities f...

Describe briefly, major opportunities for an organisation operating in a modern global business environment.   There are several significant opportunities for an organisation o

How motivate the successful salesperson, 1. The chapter mentions the theory...

1. The chapter mentions the theory of transaction cost analysis (TCA). What role does TCA play in the decision to use a company sales force rather than independent manufacturers' a

Explain should wang take the quantity discount, Wang Distributors has an an...

Wang Distributors has an annual demand for an airport metal detector of 1,400 units. The cost of a typical detector to Wang is $400. Carrying cost is estimated to be 20% of the uni

What are the steps in the method study procedure, 1. What are the steps in ...

1. What are the steps in the method study procedure?  Answer: Select, record, examine, develop, install, maintain.

Define what unions unionization does southwest airlines have, What unions /...

What unions / unionization does Southwest Airlines have?

Describe porter''s five forces model, You have been working for some time a...

You have been working for some time at UMUC Pizza, a pizza restaurant located near the UMUC campus. The owner, Bill, is very interested in expanding his successful business. He h

Define the upper and lower control limits, The overall average on a process...

The overall average on a process you are attempting to monitor is 50 units. the process standard deviation is 1.72. Determine the upper and lower control limits for a mean chart, i

Explain methods of quantitative analysis, Name four methods of quantitative...

Name four methods of quantitative analysis that are useful in informing the facility location decision. How can each of the methods assist you in location decisions? Provide exampl

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