Using the dress data above, calculate the

following

a. Using the above data forecast year 3

using a simple 3 period moving

average

b. Using years 1 and 2 data forecast

year 3, using weighted moving

average, with weights of 0.6, 0.25,

and 0.15 from the most recent the

oldest period.

c. Using the above data forecast year 3

Calculate a forecast using the

exponential smoothing method.

Assume a = 0.20

d. Using the information you have

for years 1 & 2, calculate a monthly

index. And then, using year 1 and

2 data Determine the slope and

intercept of line equation using linear

regression. Then calculate the new

annual demand and forecast the

monthly demand

e. Using the actual Year-3 numbers to

check your forecast accuracy, by

using the forecasting error to

calculate CFE. MSE. MAD. MAPE

f. Determine which forecasting

method is best for this problem.

Using the actual Year-3 numbers to

check your forecast accuracy.

Pricilla Phranklin opened her new clothing store, Pricilla Phashions, in downtown Dover. Pants, skirts, blouses, and shirts have fairly consistent sales, while things like shorts, sweater and outerwear are highly seasonal. On the other hand, dresses are a little harder to predict. Pricilla is hiring you to arrive at the best forecasting method for dresses. The following table contains three years of dress sales data