mangament homework and excel

Solution Key

		Young Forever Boutique Spreadsheet
								Name:	Please write your name(s).
	Month	Year 1	Year 2	Year 3	Year 4	Year 5
	January		6381.07	11016.55	11965.68	10580.74
	February		4405.83	8264.14	12761.98	13420.87
	March	4566.4	9126.95	6843.95	18126.7	34476.27
	April	6941.89	10970.45	20109.68	19092.9	19108.79
	May	7047.23	10189.28	11148.64	15384.01	18109.54
	June	6784.37	7043.85	8365.4	12237	13743.6
	July	5814.23	6717.37	9469.08	13252.53	18339.25
	August	6906.38	9139.72	10221	13819.77
	September	8075.13	11315.19	15161.41	21755.64
	October	7913.56	10838.4	17731.08	24838.1
	November	9054.18	11150.94	17508.99	15955.6
	December	14114.58	17592.2	27566.89	19370.7
	Annual Totals	77217.95	114871.25	163406.81	198560.61	127779.06
		for 10 months				for 7 months
Question #1	40 points
	To do the time series calculations it is helpful to have all the data in a column:
				3-month moving		Absolute	3-month weighted		Absolute	Exponential		Absolute	Square
	Month	Data Number	Actual Demand	average	Error	Error	average	Error	Error	Smoothing	Error	Error	Error
	January
	February
	March	1	4566.4
	April	2	6941.89
	May	3	7047.23
	June	4	6784.37
	July	5	5814.23
	August	6	6906.38
	September	7	8075.13
	October	8	7913.56
	November	9	9054.18
	December	10	14114.58
	January	11	6381.07
	February	12	4405.83
	March	13	9126.95
	April	14	10970.45
	May	15	10189.28
	June	16	7043.85
	July	17	6717.37
	August	18	9139.72
	September	19	11315.19
	October	20	10838.4
	November	21	11150.94
	December	22	17592.2
	January	23	11016.55
	February	24	8264.14
	March	25	6843.95
	April	26	20109.68
	May	27	11148.64
	June	28	8365.4
	July	29	9469.08
	August	30	10221
	September	31	15161.41
	October	32	17731.08
	November	33	17508.99
	December	34	27566.89
	January	35	11965.68
	February	36	12761.98
	March	37	18126.7
	April	38	19092.9
	May	39	15384.01
	June	40	12237
	July	41	13252.53
	August	42	13819.77
	September	43	21755.64
	October	44	24838.1
	November	45	15955.6
	December	46	19370.7
	January	47	10580.74
	February	48	13420.87
	March	49	34476.27
	April	50	19108.79
	May	51	18109.54
	June	52	13743.6
	July	53	18339.25
	August
				Bias			Bias			Bias
				MAD			MAD			MAD
Question #2	20 points
Question #3	20 points
Question #4	20 points