Q1. Simple Moving Average Demand 3PMA 3PF Error Abs
Hello, How are you? Can you read over these pages and then there are question # 1-5 to take a look at please. It needs to be in excel. I have the file. I can email it to you or I
have attached here what I did. Is it correct? Thank You.
- Attachment 1
- Attachment 2
- Attachment 3
- Attachment 4
- Attachment 5
- Attachment 6
Q3. Exponential SmoothingDemandForecastErrorAbs Error Abs % errorJan10,6969,5001,196119611.2%alpha0.4Feb9,6659,978-3133133.2%beta0.6Mar10,1799,8533263263.2%Apr11,7609,9831,777177715.1%May9,15010,694-1,544154416.9%Jun9,57110,076-5055055.3%Jul8,3759,874-1,499149917.9%Aug11,8269,2752,551255121.6%Sep10,69610,2954014013.7%Oct11,21210,4557577576.7%Nov9,75010,758-1,008100810.3%Dec9,38010,355-97597510.4%%Total Demand122,260Avg. Demand10,188.33Total Bias1,162Ave. Bias97Absolute Dev12,852Mean Abs Dev1,071MAPE10.47
Show more