Question: Please answer the following ASAP (data shown in screenshot):1. For Product A, what would you predict in period 31 using the Exponential Smoothing (alpha =0.1)
Please answer the following ASAP (data shown in screenshot):1. For Product A, what would you predict in period 31 using the Exponential Smoothing (alpha =0.1) Forecast?2. For Product B, what would you predict in period 31 using the Exponential Smoothing (alpha =0.2) Forecast?3. For Product C, what would you predict in period 31 using the Exponential Smoothing (alpha =0.3) Forecast?4. For Product D, what would you predict in period 31 using the Exponential Smoothing (alpha =0.4) Forecast?5. For Product E, what would you predict in period 31 using the Exponential Smoothing (alpha =0.5) Forecast?6. What is the mean absolute percent error for the exponential smoothing forecast (alpha =0.1) for Product A?(format x.xx)7. What is the mean squared error for the exponential smoothing forecast (alpha =0.2) for Product B?(format xx.xx)8. What is the mean absolute percent error for the exponential smoothing forecast (alpha =0.3) for Product C?(format x.xx)9. What is the mean absolute percent error for the exponential smoothing forecast (alpha =0.4) for Product D?(format x.xx)10. What is the mean absolute percent error for the exponential smoothing forecast (alpha =0.5) for Product E?(format x.x)Period Product A Product B Product C Product D Product E 19610716416821729894156200190310398161194184497100155177196510495152172185696106155195208710310215319319681031041501911999103951511822191010390158181204119910715916121512103103154189182131009015917121214105104155174196159610315416318116971031621952001710392158190210181009416417821319102108158198209201001041541662082197100162187191229994159166216239593152186199249910616316718825102102150172183261051021531822192710094154176217289693153169205291019315216621930989715018720231There are five products for which you have to create a forecast. Start by creating an exponential smoothing forecast with the following initialization and alpha values:Product A Product B Product C Product D Product E Initialization 96107164168217 alpha 0.10.20.30.40.5In addition, you must apply the calculations for mean error, mean absolute percent error, and mean squared error for each of the five products (from the second period to the 30th period).
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
