ABC Manufacturing has the following data for their Shampoo sales. Use the following data to answer the Questions in ONE SHEET: Copy these two columns vertically for every answer (for Q 1 to 5) FOR ME TO VERIFY. All answers to 3 Decimal Places

2015	Actual
JAN	2000
FEB	1800
MARC	3250
APRIL	1599
MAY	3425
JUNE	3555
JULY	3750

QuestionsAll Ans to 3 Decimal Places 1. Use the Naiive method to forecast for Feb - Aug 2016 2. Calculate a 2-period moving average forecast for periods-Mar to Aug 3. Calulate a weighted forecast for periods-Mar to Aug with 0.65, 0.2,0.15 4. Calculate the Exponential Smoothing Forecast for Feb to Aug with a smoothing constant = 0.25 and the Forecast for FEB = 2800 5. Calculate the MAD, MSE and the MAPE for the exponential Forecast Values

In another sheet, Comment in a medium paragraph on the usefulness of these measures and as to how the company can benefit by sticking to these forecasts. Please be very organized with the answers - Have each answer vertically done and NOT as one big table that makes it hard for me to mark- Marks are allocated for Verifiable Calculations/formulas/Organization, Neatness of data and accuracy of Calculations 5% for Accuracy of answers, 5% for visibility of Excel Calculations, 2% for Neatness and Organization of Answer Formats, 3% for the (Ans 6)