The following table contains the demand from the last 10 months
The following table contains the demand from the last 10 months:
Month (M) 1- Actual Demand (AD)-31; M2-AD34; M3-AD33; M4-AD35; M5-AD37; M6-AD36; M7-AD38; M8-AD40; M9-AD40; M10=AD41.
STEP ONE: Calculate the single exponential smoothing forecast for these data using a alpha of .30, and an initial forecast of (F1) of 31.
STEP TWO: Calculate the exponential smoothing with trend forecast for these data using a alpha of .30 a delta of .30, and an initial trend forecast (T1) of 1, and an initial exponentially smoothed forecast (F1) of 30.
STEP THREE: Calculate the mean absolute deviation (MAD) for each forecast.
STEP FOUR: Which is best and explain why?
We are allowed to use excel, but it must be done by hand and not using excel functions. Please indicate Step 1, 2, 3, 4 and indicate (highlight) the final answer for each.
How it Works
1
It only takes a couple of minutes to fill in your details, select the type of paper you need (essay, term paper, etc.), give us all necessary information regarding your assignment.
2
Once we receive your request, one of our customer support representatives will contact you within 24 hours with more specific information about how much it'll cost for this particular project.
3
After receiving payment confirmation via PayPal or credit card – we begin working on your detailed outline, which is based on the requirements given by yourself upon ordering.
4
Once approved, your order is complete and will be emailed directly to the email address provided before payment was made!