Executive summary and one paragraph conclusion total is 1 and half paragraph

moving average

File name: best homes
Use this worksheet to analyze the best homes case study.
The data is entered into 60 rows. One row for each month.
The forecasting model can be entered into the columns.
1	Jan 11	840
2	Feb 11	880
3	Mar 11	1120
4	Apr 11	1200
5	May 11	1120
6	Jun 11	1120	12200	1016.7
7	July 11	1080	12280	1023.3
8	Aug 11	1000	12600	1050.0
9	Sept 11	960	12840	1070.0
10	Oct 11	1000	13000	1083.3
11	Nov 11	920	13280	1106.7
12	Dec 11	960	13520	1126.7
13	Jan 12	920	13760	1146.7
14	Feb 12	1200	14000	1166.7
15	Mar 12	1360	14240	1186.7
16	Apr 12	1360	14400	1200.0
17	May 12	1400	14600	1216.7
18	Jun 12	1360	14760	1230.0
19	July 12	1320	15120	1260.0
20	Aug 12	1240	15360	1280.0
21	Sept 12	1200	15640	1303.3
22	Oct 12	1160	16000	1333.3
23	Nov 12	1120	16200	1350.0
24	Dec 12	1120	16560	1380.0
25	Jan 13	1280	16560	1380.0
26	Feb 13	1440	16560	1380.0
27	Mar 13	1640	16600	1383.3
28	Apr 13	1720	16880	1406.7
29	May 13	1600	17040	1420.0
30	Jun 13	1720	17160	1430.0
31	July 13	1320	17200	1433.3
32	Aug 13	1240	17160	1430.0
33	Sept 13	1240	17080	1423.3
34	Oct 13	1440	16920	1410.0
35	Nov 13	1280	17040	1420.0
36	Dec 13	1240	16840	1403.3
37	Jan 14	1320	16920	1410.0
38	Feb 14	1400	17120	1426.7
39	Mar 14	1560	17360	1446.7
40	Apr 14	1560	17440	1453.3
41	May 14	1720	17400	1450.0
42	Jun 14	1520	17560	1463.3
43	July 14	1400	17800	1483.3
44	Aug 14	1440	18200	1516.7
45	Sept 14	1480	18480	1540.0
46	Oct 14	1520	18840	1570.0
47	Nov 14	1240	19000	1583.3
48	Dec 14	1400	19240	1603.3
49	Jan 15	1560	19560	Moving
50	Feb 15	1800	19760	1646.7
51	Mar 15	1840	19680	1640.0
52	Apr 15	1920	19720	1643.3
53	May 15	1880	19920	1660.0
54	Jun 15	1760	20040	1670.0
55	July 15	1720
56	Aug 15	1640
57	Sept 15	1400
58	Oct 15	1560
59	Nov 15	1440
60	Dec 15	1520
61	Jan 16
62	Feb 16
63	Mar 16
64	Apr 16
65	May 16
66	Jun 16
67	July 16
68	Aug 16
69	Sept 16
70	Oct 16
71	Nov 16
72	Dec 16

DATA 2

								2011		2012		2013		2014		2015
						1	Jan	840		920		1,280		1,320		1,560
						2	Feb	880		1,200		1,440		1,400		1,800
						3	Mar	1,120		1,360		1,640		1,560		1,840
						4	Apr	1,200		1,360		1,720		1,560		1,920
						5	May	1,120		1,400		1,600		1,720		1,880
						6	Jun	1,120		1,360		1,720		1,520		1,760
						7	July	1,080		1,320		1,320		1,400		1,720
						8	Aug	1,000		1,240		1,240		1,440		1,640
						9	Sept	960		1,200		1,240		1,480		1,400
						10	Oct	1,000		1,160		1,440		1,520		1,560
						11	Nov	920		1,120		1,280		1,240		1,440
						12	Dec	960		1,120		1,240		1,400		1,520
								12,200		14,760		17,160		17,560		20,040

DATA

						1	Jan 11	840	Jan 12	920	Jan 13	1280	Jan 14	1320	Jan 15	1560
						2	Feb 11	880	Feb 12	1200	Feb 13	1440	Feb 14	1400	Feb 15	1800
						3	Mar 11	1120	Mar 12	1360	Mar 13	1640	Mar 14	1560	Mar 15	1840
						4	Apr 11	1200	Apr 12	1360	Apr 13	1720	Apr 14	1560	Apr 15	1920
						5	May 11	1120	May 12	1400	May 13	1600	May 14	1720	May 15	1880
						6	Jun 11	1120	Jun 12	1360	Jun 13	1720	Jun 14	1520	Jun 15	1760
						7	July 11	1080	July 12	1320	July 13	1320	July 14	1400	July 15	1720
						8	Aug 11	1000	Aug 12	1240	Aug 13	1240	Aug 14	1440	Aug 15	1640
						9	Sept 11	960	Sept 12	1200	Sept 13	1240	Sept 14	1480	Sept 15	1400
						10	Oct 11	1000	Oct 12	1160	Oct 13	1440	Oct 14	1520	Oct 15	1560
						11	Nov 11	920	Nov 12	1120	Nov 13	1280	Nov 14	1240	Nov 15	1440
						12	Dec 11	960	Dec 12	1120	Dec 13	1240	Dec 14	1400	Dec 15	1520
						13	Jan 12	920
						14	Feb 12	1200
						15	Mar 12	1360
						16	Apr 12	1360
						17	May 12	1400
						18	Jun 12	1360
						19	July 12	1320
						20	Aug 12	1240
						21	Sept 12	1200
						22	Oct 12	1160
						23	Nov 12	1120
						24	Dec 12	1120
						25	Jan 13	1280
						26	Feb 13	1440
						27	Mar 13	1640
						28	Apr 13	1720
						29	May 13	1600
						30	Jun 13	1720
						31	July 13	1320
						32	Aug 13	1240
						33	Sept 13	1240
						34	Oct 13	1440
						35	Nov 13	1280
						36	Dec 13	1240
						37	Jan 14	1320
						38	Feb 14	1400
						39	Mar 14	1560
						40	Apr 14	1560
						41	May 14	1720
						42	Jun 14	1520
						43	July 14	1400
						44	Aug 14	1440
						45	Sept 14	1480
						46	Oct 14	1520
						47	Nov 14	1240
						48	Dec 14	1400
						49	Jan 15	1560
						50	Feb 15	1800
						51	Mar 15	1840
						52	Apr 15	1920
						53	May 15	1880
						54	Jun 15	1760
						55	July 15	1720
						56	Aug 15	1640
						57	Sept 15	1400
						58	Oct 15	1560
						59	Nov 15	1440
						60	Dec 15	1520

DATA AND MOV AVG & FORECAST

File name: best homes
Use this worksheet to analyze the best homes case study.
The worksheet provides only the data from the case study.
The data is entered into 60 rows. One row for each month.
The forecasting model can be entered into the columns.
													MONTH	SALES	MOV. AVG.	MOV AVG FCT	ADJ FCST			Seas fact.
1	Jan 11	840											1	840		937.8				0.96
2	Feb 11	880											2	880		950.3				1.10
3	Mar 11	1120											3	1120		962.7				1.20
4	Apr 11	1200											4	1200		975.2				1.22
5	May 11	1120											5	1120		987.6				1.21
6	Jun 11	1120											6	1120		1000.1				1.16
7	July 11	1080											7	1080		1012.5				1.04
8	Aug 11	1000											8	1000		1024.9				0.99
9	Sept 11	960											9	960		1037.4				0.97
10	Oct 11	1000											10	1000		1049.8				1.00
11	Nov 11	920											11	920		1062.3				0.89
12	Dec 11	960	12200	1017									12	960	1017	1074.7				0.91
13	Jan 12	920	12280	1023									13	920	1023	1087.1				0.96
14	Feb 12	1200	12600	1050									14	1200	1050	1099.6				1.10
15	Mar 12	1360	12840	1070									15	1360	1070	1112.0				1.20
16	Apr 12	1360	13000	1083									16	1360	1083	1124.5				1.22
17	May 12	1400	13280	1107									17	1400	1107	1136.9				1.21
18	Jun 12	1360	13520	1127									18	1360	1127	1149.4				1.16
19	July 12	1320	13760	1147									19	1320	1147	1161.8				1.04
20	Aug 12	1240	14000	1167									20	1240	1167	1174.2				0.99
21	Sept 12	1200	14240	1187									21	1200	1187	1186.7				0.97
22	Oct 12	1160	14400	1200									22	1160	1200	1199.1				1.00
23	Nov 12	1120	14600	1217									23	1120	1217	1211.6				0.89
24	Dec 12	1120	14760	1230									24	1120	1230	1224.0				0.91
25	Jan 13	1280	15120	1260									25	1280	1260	1236.5				0.96
26	Feb 13	1440	15360	1280									26	1440	1280	1248.9				1.10
27	Mar 13	1640	15640	1303									27	1640	1303	1261.3				1.20
28	Apr 13	1720	16000	1333									28	1720	1333	1273.8				1.22
29	May 13	1600	16200	1350									29	1600	1350	1286.2				1.21
30	Jun 13	1720	16560	1380									30	1720	1380	1298.7				1.16
31	July 13	1320	16560	1380									31	1320	1380	1311.1				1.04
32	Aug 13	1240	16560	1380									32	1240	1380	1323.5				0.99
33	Sept 13	1240	16600	1383									33	1240	1383	1336.0				0.97
34	Oct 13	1440	16880	1407									34	1440	1407	1348.4				1.00
35	Nov 13	1280	17040	1420									35	1280	1420	1360.9				0.89
36	Dec 13	1240	17160	1430									36	1240	1430	1373.3				0.91
37	Jan 14	1320	17200	1433									37	1320	1433	1385.8				0.96
38	Feb 14	1400	17160	1430									38	1400	1430	1398.2				1.10
39	Mar 14	1560	17080	1423									39	1560	1423	1410.6				1.20
40	Apr 14	1560	16920	1410									40	1560	1410	1423.1				1.22
41	May 14	1720	17040	1420									41	1720	1420	1435.5				1.21
42	Jun 14	1520	16840	1403									42	1520	1403	1448.0				1.16
43	July 14	1400	16920	1410									43	1400	1410	1460.4				1.04
44	Aug 14	1440	17120	1427									44	1440	1427	1472.8				0.99
45	Sept 14	1480	17360	1447									45	1480	1447	1485.3				0.97
46	Oct 14	1520	17440	1453									46	1520	1453	1497.7				1.00
47	Nov 14	1240	17400	1450									47	1240	1450	1510.2				0.89
48	Dec 14	1400	17560	1463									48	1400	1463	1522.6				0.91
49	Jan 15	1560	17800	1483									49	1560	1483	1535.1				0.96
50	Feb 15	1800	18200	1517									50	1800	1517	1547.5				1.10
51	Mar 15	1840	18480	1540									51	1840	1540	1559.9				1.20
52	Apr 15	1920	18840	1570									52	1920	1570	1572.4				1.22
53	May 15	1880	19000	1583									53	1880	1583	1584.8				1.21
54	Jun 15	1760	19240	1603									54	1760	1603	1597.3				1.16
55	July 15	1720	19560	1630									55	1720	1630	1609.7				1.04
56	Aug 15	1640	19760	1647									56	1640	1647	1622.2				0.99
57	Sept 15	1400	19680	1640									57	1400	1640	1634.6				0.97
58	Oct 15	1560	19720	1643									58	1560	1643	1647.0				1.00
59	Nov 15	1440	19920	1660									59	1440	1660	1659.5				0.89
60	Dec 15	1520	20040	1670									60	1520	1670	1671.9				0.91
61	Jan 16									61			61			1684.4	1599			0.95
62	Feb 16									62			62			1696.8	1810			1.07
63	Mar 16									63			63			1709.2	2042			1.19
64	Apr 16									64			64			1721.7	2103			1.22
65	May 16									65			65			1734.1	2079			1.20
66	Jun 16									66			66			1746.6	2019			1.16
67	July 16									67			67			1759.0	1842			1.05
68	Aug 16									68			68			1771.5	1756			0.99
69	Sept 16									69			69			1783.9	1683			0.94
70	Oct 16									70			70			1796.3	1778			0.99
71	Nov 16									71			71			1808.8	1599			0.88
72	Dec 16									72			72			1821.2	1654			0.91

DATA AND MOV AVG & FORECAST

MODEL WITH MOV AVG PAST 12 MONT

FCST CHART PRE 12 MOV AVG

FCST CHART PRE 12 MOV AVG

1	1
2	2
3	3
4	4
5	5
6	6
7	7
8	8
9	9
10	10
11	11
12	12
13	13
14	14
15	15
16	16
17	17
18	18
19	19
20	20
21	21
22	22
23	23
24	24
25	25
26	26
27	27
28	28
29	29
30	30
31	31
32	32
33	33
34	34
35	35
36	36
37	37
38	38
39	39
40	40
41	41
42	42
43	43
44	44
45	45
46	46
47	47
48	48
49	49
50	50
51	51
52	52
53	53
54	54
55	55
56	56
57	57
58	58
59	59
60	60

SEAS FACT PRE 12 MON

SEAS FACT PRE 12 MON

1	1	1	1
2	2	2	2
3	3	3	3
4	4	4	4
5	5	5	5
6	6	6	6
7	7	7	7
8	8	8	8
9	9	9	9
10	10	10	10
11	11	11	11
12	12	12	12
13	13	13	13
14	14	14	14
15	15	15	15
16	16	16	16
17	17	17	17
18	18	18	18
19	19	19	19
20	20	20	20
21	21	21	21
22	22	22	22
23	23	23	23
24	24	24	24
25	25	25	25
26	26	26	26
27	27	27	27
28	28	28	28
29	29	29	29
30	30	30	30
31	31	31	31
32	32	32	32
33	33	33	33
34	34	34	34
35	35	35	35
36	36	36	36
37	37	37	37
38	38	38	38
39	39	39	39
40	40	40	40
41	41	41	41
42	42	42	42
43	43	43	43
44	44	44	44
45	45	45	45
46	46	46	46
47	47	47	47
48	48	48	48
49	49	49	49
50	50	50	50
51	51	51	51
52	52	52	52
53	53	53	53
54	54	54	54
55	55	55	55
56	56	56	56
57	57	57	57
58	58	58	58
59	59	59	59
60	60	60	60
61	61	61	61
62	62	62	62
63	63	63	63
64	64	64	64
65	65	65	65
66	66	66	66
67	67	67	67
68	68	68	68
69	69	69	69
70	70	70	70
71	71	71	71
72	72	72	72

								Actual	MOV AVG			Actual	MOV AVG			Actual	MOV AVG			Actual	MOV AVG			Actual	MOV AVG				SEAS. FAC
									2011				2012				2013				2014				2015
														SEA FAC				SEA FAC				SEA FAC				SEA FAC
						1	Jan	840	938	0.90		920	1087.1	0.85		1,280	1,236.5	1.04		1,320	1,385.8	0.95		1,560	1,535	1.02		4.75	0.95
						2	Feb	880	950	0.93		1,200	1099.6	1.09		1,440	1,248.9	1.15		1,400	1,398.2	1.00		1,800	1,548	1.16		5.33	1.07
						3	Mar	1120	963	1.16		1,360	1112.0	1.22		1,640	1,261.3	1.30		1,560	1,410.6	1.11		1,840	1,560	1.18		5.97	1.19
						4	Apr	1200	975	1.23		1,360	1124.5	1.21		1,720	1,273.8	1.35		1,560	1,423.1	1.10		1,920	1,572	1.22		6.11	1.22
						5	May	1120	988	1.13		1,400	1136.9	1.23		1,600	1,286.2	1.24		1,720	1,435.5	1.20		1,880	1,585	1.19		5.99	1.20
						6	Jun	1120	1,000.1	1.12		1,360	1149.4	1.18		1,720	1,298.7	1.32		1,520	1,448.0	1.05		1,760	1,597	1.10		5.78	1.16
						7	July	1080	1,012.5	1.07		1,320	1161.8	1.14		1,320	1,311.1	1.01		1,400	1,460.4	0.96		1,720	1,610	1.07		5.24	1.05
						8	Aug	1000	1,024.9	0.98		1,240	1174.2	1.06		1,240	1,323.5	0.94		1,440	1,472.8	0.98		1,640	1,622	1.01		4.96	0.99
						9	Sept	960	1,037.4	0.93		1,200	1186.7	1.01		1,240	1,336.0	0.93		1,480	1,485.3	1.00		1,400	1,635	0.86		4.72	0.94
						10	Oct	1000	1,049.8	0.95		1,160	1199.1	0.97		1,440	1,348.4	1.07		1,520	1,497.7	1.01		1,560	1,647	0.95		4.95	0.99
						11	Nov	920	1,062.3	0.87		1,120	1211.6	0.92		1,280	1,360.9	0.94		1,240	1,510.2	0.82		1,440	1,659	0.87		4.42	0.88
						12	Dec	960	1,074.7	0.89		1,120	1224.0	0.92		1,240	1,373.3	0.90		1,400	1,522.6	0.92		1,520	1,672	0.91		4.54	0.91
									12,075				13,867				15,659				17,450				19,242