A1 (12.5%) FIRST NAME: Space Manufacturing has the following data for their sales. following data to answer the Questions: 2015 Actual JAN 1452 FEB 2050 MARC 2345 APRIL 1500 MAY 2701 JUNE 2932 JULY 3016 |USE ONLY EXCEL formulas for work - I will need to be able to verify every cell. You may answer all your answers ONLY on this ONE sheet in a logical manner.. BOLD your answers. Marks are allocated for Neat tables and Logical presentation of the file. I will have to be able to click the cell and verify your Excel calculations SUBMIT ONE Excel FILE called FINAL when done with all answers- Copy these two columns for every answer (for Q 1 to 5) and create additional columns to show your work relevant QUESTIONS: ALL answers to 3 Decimal places 1 Use the Naiive method to forecast for FEB to Aug for 2016 2 3 Calculate a 2-period moving average forecast Calulate a weighted forecast for 2016 with 0.5, 0.3, 0.2 4 Calculate the Forecast for 2016 with a smoothing constant = 0.35 and the Forecast for Feb Calculate the MAD, MSE and the MAPE for the Exponential Smoothing Forecasts 5 Please be very organized with the answers- Marks are allocated for Visibility of Formulas, Organization, 5% for Accuracy of answers, 5% for visibility of Calculations, 2.5% for Neatness and Organization of An