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 expected learning curve, A time standard was set as 0.20 hour per u...

A time standard was set as 0.20 hour per unit based on the 50th unit produced. If the task has a 90 percent learning curve, what would be the expected time of the 100th, 200th, and

Ultimate objective, Ultimate Objective 1. Manufacturing costs: The ...

Ultimate Objective 1. Manufacturing costs: The unit cost of the product should  be estimated carefully and every effort should be made to stick to the cost standards. For

Explain improving productivity, Explain Improving Productivity. Improv...

Explain Improving Productivity. Improving Productivity: The production essence is creation of goods, may be by the transformation of raw materials or through assembling vario

Explain what is the most that should be paid for forecast, Nick has plans t...

Nick has plans to open some pizza restaurants, but he is not sure how many to open. He has prepared a payoff table to help analyze the situation. States of Nature Alternatives Good

MBA, Q3. What do you understand by “line balancing”? What happens if balanc...

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

Explain team overcome resistance to the new ownership, You are the internal...

You are the internal relations manager for Elan, an Irish biotech firm, when it is acquired by Johnson and Johnson. How will you help the top management team overcome resistance to

Describe the idea that an information system, Discuss the idea that an info...

Discuss the idea that an information system by itself can rarely provide a sustainable competitive advantage?

Explain what will be the average tardiness of these orders, A single machin...

A single machine work center has five jobs assigned to it. They are labeled, in the order of their arrival in the shop, as jobs A, B, C, D and E. The work center may work on only o

Explain the companys core competencies, As the end of the year comes to a c...

As the end of the year comes to a close, the CEO is evaluating Motorola's strategic approach and its ability to produce desired results for the company in the future. The CEO has a

Explain lower foreign labour costs, Global expansion is fuelled by a (n): A...

Global expansion is fuelled by a (n): Answer (1) shrinking customer market, lower foreign labour costs, and advances in technology. (2) Expanding new customer market, lower foreign

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