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.

(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

Questions Cloud

Determine the heat transfer per kmol of octane : if the combustion occurs in a steady-flow combustion chamber. Plot the percent theoretical air required for 0.1 percent CO in the products as a function of product pressures between 100 and 2300 kPa.

What are measures that show operating system is effective : If you joined the management team of an HCO, how would you evaluate the HCO's operating system? What are the measures that show the operating system is effective? How would you identify opportunities for improvement (OFIs) in the operating systems? H..

Principal objectives of punishment : Write a 700- to 1,050-word paper that analyzes the principal objectives of punishment within the U.S. corrections system.

Determine the final pressure in the tank : determine the final pressure in the tank

What is forecast for period-exponential smoothing average : 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. What is the forecast for period..

First new product the company : 1. Could he revitalize the iPad business, become a leader in payments, with Apple Pay, and replicate Apple's success in other device categories, such as the Apple Watch, the first new product the company had released since 2010?

Larsoncould utilize in his lawsuit : Edward Johnson III, the CEO and principal owner of the world's largest mutual fund company, Fidelity Investments, Inc., was a longtime tennis buddy of Richard Larson. In 1995, Johnson asked Larson, who had construction experience, to supervise the..

The first step in building a communication plan : The first step in building a communication plan is to identify your key stakeholders. How would you identify a key stakeholder? Then, once you have identified that key stakeholder, how would you determine which form of communication to use? Can (and ..

Tabulate the natural log of the equilibrium constant : Compare your results to those obtained by combining the ln KP values for the two equilibrium reactions CO2 = CO + O2 and H2O = H2 +O2 given in Table A-28. 0031

User Account

All Pages