Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Period Month Demand Level Trend Forecast Error ABS % Error Sq. Error 1 Jan 86 2 Feb 85 3 Mar 96 4 Apr 112 5
Period | Month | Demand | Level | Trend | Forecast | Error | ABS % Error | Sq. Error |
1 | Jan | 86 | ||||||
2 | Feb | 85 | ||||||
3 | Mar | 96 | ||||||
4 | Apr | 112 | ||||||
5 | May | 148 | ||||||
6 | Jun | 131 | ||||||
7 | Jul | 131 | ||||||
8 | Aug | 138 | ||||||
9 | Sep | 146 | ||||||
10 | Oct | 162 | ||||||
11 | Nov | 144 | ||||||
12 | Dec | 180 | ||||||
13 | Jan | 144 | ||||||
14 | Feb | 190 | ||||||
15 | Mar | 176 | ||||||
16 | Apr | 174 | ||||||
17 | May | 193 | ||||||
18 | Jun | 201 | ||||||
19 | Jul | 218 | ||||||
20 | Aug | 194 | ||||||
21 | Sep | 221 | ||||||
22 | Oct | 191 | ||||||
23 | Nov | 191 |
ME: | |
MAPE: | |
MSE: |
For the forecasting part, please use exponential smoothing with the following initalization values: trended=80
alpha value of 0.1
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