Answered step by step
Verified Expert Solution
Question
1 Approved Answer
FabricSpace Manufacturing has the following data for their sales. Use the following data to answer the Questions in ONE SHEET: Copy these two columns for
FabricSpace Manufacturing has the following data for their sales. Use the following data to answer the Questions in ONE SHEET: Copy these two columns for every answer (for Q 1 to 5) in a vertical format for me to verify QUESTIONS ::: ALL answers to 3 Decimal places 2015 Actual 1 Use the Naiive method to forecast for FEB to Aug for 2016 JAN 1452 2 Calculate a 2-period moving average forecast FEB 2075 3 Calulate a weighted forecast for 2016 with 0.5, 0.3, 0.2 MARC 2345 4 Calculate all the Forecast for 2016 with a smoothing constant = 0.32 and the Forecast for Feb = 2150 APRIL 1500 5 Calculate the MAD, MSE and the MAPE for the Exponential Smoothing Forecasts MAY 2701 6 On the next sheet, Comment in a medium paragraph on the usefulness of these measures and in another medium paragraph as to how the company can benefit by sticking to these forecasts. JUNE 3000 JULY 3016
FabricSpace Manufacturing has the following data for their sales. | |||||||||||||||||||||||||||||||||||||||||
Use the following data to answer the Questions in ONE SHEET: | Copy these two columns for every answer (for Q 1 to 5) in a vertical format for me to verify | ||||||||||||||||||||||||||||||||||||||||
QUESTIONS ::: ALL answers to 3 Decimal places | |||||||||||||||||||||||||||||||||||||||||
2015 | Actual | 1 | Use the Naiive method to forecast for FEB to Aug for 2016 | ||||||||||||||||||||||||||||||||||||||
JAN | 1452 | 2 | Calculate a 2-period moving average forecast | ||||||||||||||||||||||||||||||||||||||
FEB | 2075 | 3 | Calulate a weighted forecast for 2016 with 0.5, 0.3, 0.2 | ||||||||||||||||||||||||||||||||||||||
MARC | 2345 | 4 | Calculate all the Forecast for 2016 with a smoothing constant = 0.32 and the Forecast for Feb = 2150 | ||||||||||||||||||||||||||||||||||||||
APRIL | 1500 | 5 | Calculate the MAD, MSE and the MAPE for the Exponential Smoothing Forecasts | ||||||||||||||||||||||||||||||||||||||
MAY | 2701 | 6 | On the next sheet, Comment in a medium paragraph on the usefulness of these measures and in another medium paragraph as to how the company can benefit by sticking to these forecasts. | ||||||||||||||||||||||||||||||||||||||
JUNE | 3000 | ||||||||||||||||||||||||||||||||||||||||
JULY | 3016 |
CAN I PLEASE GET ANSWER IN AN ECXEL SHEET.
THANK YOU
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started