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

Perseverance and job related knowledge, (Emotional intelligence; a key fact...

(Emotional intelligence; a key factor to success) I want a 20 question survey for this topic, based on these 5 factors Ethic and integrity, Leadership, Perseverance, Job related kn

Maximum product exposure - facility layout, Maximum Product Exposure - Faci...

Maximum Product Exposure - Facility Layout  In layout of retail stores, basic purchases and check-out stations are often positioned remote from the shop entrance, obliging the

Break Even Sales, K Ltd a multi product company, furnishes you the followin...

K Ltd a multi product company, furnishes you the following data relating to the year 2000. First half sales Second half sales Sales Rs.45000 Rs.50000 Total cost Rs.40000 Rs.43000

Question 2, Exercise 2: Use of a Grid Analysis (Weighted Scoring Model) to ...

Exercise 2: Use of a Grid Analysis (Weighted Scoring Model) to Help Make the North American Plant Location Decision for the RX 330 This exercise illustrates how when deciding among

Describe the topic of joint versus separate preference, Explain the topic o...

Explain the topic of joint versus separate preference reversal.

Explain various types of media that attracted your attention, List five adv...

List five advertisements from various types of media that attracted your attention. Discuss the characteristics that determined your selection

Give a specific definition of time study, Give a specific definition of tim...

Give a specific definition of time study. Time study It is defined as a work measurement technique for recording the times and rate of working for the component of a speci

Explain how survey have been more useful, 1. Using a cause and effect diagr...

1. Using a cause and effect diagram (Fish-bone chart), Scatter Diagram, flowchart or Statistical Process control chart, analyze the data and present conclusions. 2. How could th

Explain what does business intelligence mean to a business, What does busin...

What does business intelligence really mean to a business? What are the negative impacts of business intelligence? How does a database and data warehouse support business intellige

Explain carpet cleaning machine, Gabriela Manufacturing must decide whether...

Gabriela Manufacturing must decide whether to insource or outsource a new toxic-free miracle carpet cleaner that works with its Miracle Carpet Cleaning Machine. If it decides to in

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