Unit 6

Assignment Details

This assignment has two parts. Part 1 has questions about forecasting. You will submit your answers for the first part using the 

Unit 6 Assignment template

for Part 1.

Part 2 requires you to analyze a case. For this, you will prepare a PowerPoint presentation to present your findings.

The data you need for Part 2 is provided in an Excel file in the course. Make sure to use that file. Do not type anything manually from the case or use other sources for the data.

View the assignment rubric for full assignment details.

Unit 6 Assignment Rubric

Use this spreadsheet to complete Part 2 of this assignment.

kimwood kim woods

Unit 6 Assignment.html

  

Assignment Details

This assignment has two parts. Part 1 has questions about forecasting. You will submit your answers for the first part using the Unit 6 Assignment template for Part 1.

Part 2 requires you to analyze a case. For this, you will prepare a PowerPoint presentation to present your findings.

The data you need for Part 2 is provided in an Excel file in the course. Make sure to use that file. Do not type anything manually from the case or use other sources for the data.

View the assignment rubric for full assignment details.

Unit 6 Assignment Rubric

Use this spreadsheet to complete Part 2 of this assignment.

2

>Sheet

1

MA

error |error|

1

.

2

.2

3

7

.9

4

5

5.7

6

193.18

7

.92

213.92

2857143

176.964

8

3.48

103.48

4285714

51.971

9

160.54

3.6285714286

10

87.22

4285714

34.771

11

180.84

12

521.66

13

							year	factory orders		5		error		|error|	5WMA
25	12	7
27	3	9
2	8	4
2934.1
28	6
2978.5	2785.32	–	193.18	2852.3071428571	-126.1928571429	126.193
3092.4	2878.48	–	2	13	2915.4357142857	–	176.964
3052.6	2949.12	–		10	3000.6285714286	–	51.971
3145.2	2984.66	–	160.54	3031.5714285714	–	11	113.629
3114.1	3026.88	–	87.22	3079.3285714286	–	34.771
3257.4	3076.56	–	180.84	3102.9642857143	-154.4357142857	154.436
3654	3132.34	–	521.66	3174.0142857143	-479.9857142857	479.986
3244.66	3384.2571428571
MAD	208.6914285714	MAD	162.564

Sheet1

t

s

2

0

1

11

1

19 19

9

1

12 12

3 3 9

3 9

174

8

17

15

9

21

16

												value	foreca	s	error	|error|	sqrd errors
2	0
		1		9	202		11			12
	17			3	192	361
	16	1	8	144
171		174
175	172	-3
182	-8	64
196	179	-17	289
204	189	–	15	225
	21	198	-21	441
227	211	-16	256
MAD	12.5	MSE	191.9