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

What is really being marketed in golf equipment, What is really being marke...

What is really being marketed (want satisfied), and who is the target market? 1. Golf equipment 2. College textbook 3. Beauty salon 4. Mouthwash

Forcasting, what are types of forcasting?

what are types of forcasting?

Explain what is the current multifactor productivity, Question 1 of 6. Ambe...

Question 1 of 6. Amber Patel operates a delicatessen store in South Lambert, Nevada. Currently, the store has 4 employees, each one working 160 hours per month. Because of its exce

Explain strategic business plan, You have been working for some time at Uni...

You have been working for some time at Unique Shoes, a local shoe store that specializes in unusual shoe designs and custom fitting. Currently, customers come to the store to selec

Explain what is the average utilization, Spalding Doughnuts wants to know a...

Spalding Doughnuts wants to know about its waiting line. Currently, Spalding Doughnuts uses a single-server, single-phase system when serving customers. Based on historical evidenc

Explain how much clout does your boss really have, Describe how to negotiat...

Describe how to negotiate for more compensation. Explain why one must be assertive to earn what he or she deserves. Relate four things not to do when asking for a raise. How much c

Merits of continuous or flow production, Merits of Continuous or Flow Produ...

Merits of Continuous or Flow Production 1.The direct labor content will be reduced since the comprehensive pre planning which is necessary will often produce economies in time.

Master production scheduling, Master Production Scheduling The master s...

Master Production Scheduling The master schedule ( or master production schedule of MPS) sets the quantity of each end item (finished product) to be completed in each time peri

How to find the optimum number of units, A manufacturing company sells its ...

A manufacturing company sells its products directly to customers and operates 5 days a week, 52 weeks a year. The production department of this company can produce at the rate of 6

Write formal company e-mails to employees, Acting as supervisor for a compa...

Acting as supervisor for a company of your choice, draft two examples of formal company e-mails to employees. The first email will be good-news message delivering information

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