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 what difference does it make, Use a dystopian narrative within Mart...

Use a dystopian narrative within Martin Luther King's speech. What difference does it make?

Explain what would you recommend the company, What would you recommend the ...

What would you recommend the company (Rochem Ltd) should do?

Explain what will her total variable cost be, Gina Fox has started her own ...

Gina Fox has started her own company, Foxy Shirts, which manufactures imprinted shirts for special occasions. Since she has just begun this operation, she rents the equipment from

Find annual sales is thousands of bottles, Problem 3-5 A cosmetics manufact...

Problem 3-5 A cosmetics manufacturer's marketing department has developed a linear trend equation that can be used to predict annual sales of its popular Hand & Foot Cream. Ft = 80

Explain human resource role, A program that provides employee relocation an...

A program that provides employee relocation and trailing spouse employment assistance is an example of which human resource role: Answer A) counsellor B) employee advocate C) strat

Compute number of workers needed for each department, Calculate number of w...

Calculate number of workers needed for each department to produce 2000 units per day and complete the table below to assist you in answering questions e.)è?j.). (e) What is the tot

Explain what price would you try to negotiate, You have just received 10 un...

You have just received 10 units of a special sub assembly from an electronics manufacturer at a price of $250 per unit. A new order has also just come in for your computer's produc

Explain what will be the percent increase or decrease, Refer to problems 1....

Refer to problems 1.13 and 1.14. If Charles lackey's utility costs remain constant at $500 per month, labour at $8 per hour, and cost of ingredients at $0.35 per loaf, but Charles

Explain providing detailed project management methodologies, Portfolio alig...

Portfolio alignment helps an organization achieve its goals by A. Adopting highly similar project to insure against failure B. Including a complement of projects with differe

Describe the problems of homelessness, Explain the problems of homelessness...

Explain the problems of homelessness based upon the developmental, situational, and human needs perspectives, what make a person become homeless, when they are well educated and no

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