Calculate the simple three month moving average

Assignment Help Operation Management

Reference no: EM13101878

Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and specify what method you prefer and why.

MONTH	ACTUAL DEMAND
1	450
2	500
3	550
4	600
5	650
6	700
7	500
8	550
9	400
10	500
11	675
12	600

a. Calculate the simple three-month moving average and Mean Absolute Deviation for periods 4-12.

b. Calculate the weighted three-month moving average and Mean Absolute Deviation using weights of 0.50, 0.30, and 0.20 for periods 4-12.

c. Calculate the single exponential smoothing forecast and Mean Absolute Deviation for periods 2-12 using an initial forecast (F1) of 61 and an alpha of 0.30.

d. Which of the above forecasting methods do you prefer? Please explain why?

Reference no: EM13101878

Questions Cloud

Introduction to treadmill endurance test : A researcher is interested in the effect of an electrolytic sports drink on the endurance of adolescent boys. A group of 30 boys is selected and half are given a treadmill endurance test while consuming the sports drink and the other half take the..

Compute the number of mol of s : Compute the number of mol of S represented by 1.810 x 10 -27 atoms of S, also determine the number of atoms of sulfur in 5.22 x 10 -7 kilograms of sulfur.

Expected profit for ski resort : Ski resort profits $1,500,000 during a good winter with lots of snow. The resort has a loss of $500,000 otherwise. The resort's historical climate data suggests that the probability of a good winter with lots of snow during any given year is 40%.

Peregrine corporation and an accrual method : Peregrine Corporation and an accrual method, calendar year taxpayer accrued a performance bonus of $100,000 to Charles a cash basis, calendar year taxpayer.

Calculate the simple three month moving average : Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and specify what method you prefer and why.

Determine the concentration of ch3cooh : You have pure beta-D-glucopyranose of 100 grams nearly, it was dissolved in an ethanol/water combination with the intention to recrystallize the sugar. You get pure beta-D-glucopyranose crystals 60 grams back why this 40% loss was to happen.

Explain what are the key success factors for this industry : Explain what are the fundamental of shearwater adventures' strategy? Explain what are the key success factors for this industry?

Bar graph depicting business travelers impression : USA snapshot presented a bar graph depicting business travelers' impression of wait times in airport security lines over the past 12 months. Statistics were derived from Travel Industry Association of American Business Traveler Survey of 2034 resp..

Company is forecasting a percent increase in sales : Orange & Sons recently reported sales of $100 million as well as net income equal to $5 million. The company has $70 million in total assets. Over the next year the company is forecasting a 20 percent increase in sales

User Account

All Pages