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:
| 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 with AI-Powered 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
Managerial Accounting
Authors: Ray Garrison, Eric Noreen, Peter Brewer
15th edition
1259404781, 007802563X, 978-1259404788, 9780078025631, 978-0077522940
