What is forecast for period-exponential smoothing average

Assignment Help Operation Management
Reference no: EM131035957

The Tiger Hardware store is trying to forecast demand for 50 Watt LED bulbs. The bulbs cost $15 each, but they have an extended lifetime and they consume much less electricity over there lifetime than florescent bulbs. The last 12 months of demand data are provided in the Excel file HW#6.xlsx. Use Excel formulas to do the calculations and summarize your answers below. You need to turn in your excel spreadsheet on BB in order to receive credits!

(a) What is the forecast for period 13 using a 3-month simple moving average?

(b) What is the forecast for period 13 using a 3-month weighted moving average, where the weights are: last-month=0.6, 2-months-ago=0.3, and 3-months-ago=0.1.

(c) What is the forecast for period 13 using the exponential smoothing average, with alpha=0.6?

(d) What is the forecast for period 13 using the exponential smoothing average, with alpha=0.7?

(e) Calculate the MAD for each of the four forecasts above.

(f) Based on the data above, state which forecasting method you would use and why.

(g) Please attach a print out of your excel work and submit your excel spreadsheet on BB.

Reference no: EM131035957

Automated carwash service

Bob’s Automated Carwash can service 10 cars per hour. On average, 12 cars show up every hour. Determine (a) the waiting model to be used, (b) average cars in the system, and (

Environmental responsibility in product development process

You are the new product development manager for a new, improved version of a motorized scooter. Your company has made social responsibility a key initiative. How would you inc

Elucidate market value and maturity year

Bonds have a 10% annual coupon, $1,000 face value, $1,050 market value also 10-year maturity. Beta on stock is 1.30 also its price per share is $40. Riskless return is 6%, e

Determine the producers risk

A medical supplies company buys its supplies in bulk and redistributes them to doctor’s offices and clinics. The receive thermometers in lots of 15,000 from the vendor. They a

Important for operation managers

Explain why it is important for operation s managers to understand the local culture and practices of the countries in which a firm does business. what are some of the pote

Would the two locations yield same profit at certain volume

A manager must decide between two location alternatives, Boston and Chicago. Boston would have annual fixed costs of $70,000, transportation costs of $60 per unit, and labor a

Assignment on strategic management and project selection

Strategically, what must Pan-Europa do to keep from becoming the victim of a hostile takeover? What should· Pan-Europa do now that they have won the price war? Who sho

Does subliminal advertising work

Does subliminal advertising work? Support your view. Assuming that some forms of subliminal persuasion can influence consumers; do you think the use of these techniques is eth


Write a Review

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