Question: PLEASE UPLOAD CLOUD LINK TO EXCEL SHEET TO BETTER UNDERSTAND EQUATIONS USED C12 A B C Period Demand 1 2 3 1 138 2 145

PLEASE UPLOAD CLOUD LINK TO EXCEL SHEET TO BETTER UNDERSTAND EQUATIONS USED
C12 A B C Period Demand 1 2 3 1 138 2 145 4 3 144 4 146 i LO 143 5 6 128 7 8 7 150 9 8 139 10 9 142 11 10 147 12 11 13 14 Time-series forecast 1. Forecast for period 11 using exponential smoothing using an alpha of 0.05 and assuming your forecast for the first period was 131 [2] 2. 3-month moving average [2] 3. Compute a weighted average forecast using a weight of .40 for the most recent period, .30 for the next most recent .20 for the next, and 10 for the next. [3] 4. CFE for the 3 forecast techniques in 1-3 above [3] 5. TS for the 3 forecast techniques in 1-3 above [3] 6. MAD for the 3 forecast techniques in 1-3 above [3] 7. MSE for the 3 forecast techniques in 1-3 above [3] 8. MAPE for the 3 forecast techniques in 1-3 above (3)Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
