Jan-17	Feb-17	Mar-17	Apr-17	May-17	Jun-17	Jul-17	Aug-17	Sep-17	Oct-17	Nov-17	Dec-17	Jan-18	Feb-18	Mar-18	Apr-18	May-18	Jun-18	Jul-18	Aug-18	Sep-18	Oct-18	Sum
209074	169047	170352	208084	169313	179235	179037	160861	164830	221990	170104	172839	208234	163251	175600	222587	171614	175285	178366	176539	165027	226060	4037329
110000	127501	97000	118000	115250	114730	153900	136255	80760	170480	110330	140400	133480	178960	101750	184200	134500	209359	166050	142840	194586	169679	3090010
51338	125779	19484	129097	109474	103933	30053	88291	162614	0	45543	131357	202718	94436	47559	326017	63476	36773	135686	43214	98679	86080	2131601
87049	77237	71798	93997	71052	79017	87722	71557	73936	95154	74134	75036	86271	75455	76692	95353	69622	72771	96848	90155	79083	96903	1796842

With the data above can you assist with the following questions? With excel a graph should be used to show the demand trend for all four parts

1. What is the trend of demand for Part-2 (show and label the trend on the demand graph.

2. Calculate and graph the forecast for months November 2018 to August 2019 using 10 month moving average for Part-3. show calculatons.

3.Calculate the mean and std deviation of Part-4 demand? Show calculations.