Assignment Topic: Forecasting

	PRODUCT A	PRODUCT B	PRODUCT C	PRODUCT D
DATE	Daily Sales	Daily Sales	Daily Sales	Daily Sales
3-Jan-11	210	702	18	516
4-Jan-11	10,294	402	-	324
5-Jan-11	3,395	438	-	3,618
6-Jan-11	432	19	-	414
7-Jan-11	106	-	-	72
10-Jan-11	-	216	-	546
11-Jan-11	13,344	-	-	186
12-Jan-11	5,066	444	18	3,954
13-Jan-11	1,283	402	-	396
14-Jan-11	343	-	-	78
17-Jan-11	2,989	354	-	468
18-Jan-11	9,631	546	-	1,218
19-Jan-11	3,758	396	19	2,844
20-Jan-11	1,552	-	-	618
21-Jan-11	124	-	-	54
24-Jan-11	2,591	396	-	246
25-Jan-11	5,514	132	-	1,842
26-Jan-11	4,572	372	17	2,712
27-Jan-11	280	36	-	408
28-Jan-11	-	-	-	48
31-Jan-11	2,926	360	-	396
1-Feb-11	5,309	348	-	168
2-Feb-11	5,038	444	-	4,200
3-Feb-11	1,446	14	18	444
4-Feb-11	200	-	-	108
7-Feb-11	2,219	504	-	342
8-Feb-11	7,254	546	-	1,290
9-Feb-11	6,398	390	13	3,780
########	1,363	18	-	540
########	225	-	-	90
########	2,474	342	-	294
########	10,196	392	-	1,620
########	4,123	-	18	2,826
########	1,998	-	-	702
########	3,434	-	-	48
########	6,684	18	-	-
########	5,806	414	17	-
########	69	-	-	-
########	302	-	-	-
########	1,326	429	-	900
1-Mar-11	8,444	-	-	-
2-Mar-11	3,273	2,229	16	-
3-Mar-11	1,342	19	-	422
4-Mar-11	400	-	-	9,036
7-Mar-11	2,011	417	-	24
8-Mar-11	6,826	516	-	-
9-Mar-11	5,860	702	16	-
########	1,368	43	-	5
########	253	-	-	-
########	3,008	474	-	-
########	1,960	642	-	1,104
########	11,312	594	16	-
########	814	-	-	-
########	1,072	-	-	-
########	1,982	324	-	3
########	10,992	482	-	-
########	3,865	492	16	-
########	1,402	30	-	2
########	150	-	-	2,615
########	2,143	356	-	4,812
########	11,240	464	-	-
########	4,000	498	16	168
########	1,475	24	-	18
1-Apr-11	253	-	-	-
4-Apr-11	3,090	594	-	-
5-Apr-11	6,772	517	-	2
6-Apr-11	5,869	444	21	5
7-Apr-11	1,412	36	-	2
8-Apr-11	162	-	-	-
11-Apr-11	2,088	396	-	4,932
12-Apr-11	5,864	30	-	11,534
13-Apr-11	6,467	-	21	2,357
14-Apr-11	1,307	24	-	310
15-Apr-11	240	-	-	186
18-Apr-11	2,148	-	-	517
19-Apr-11	5,424	420	-	648
20-Apr-11	5,664	1,328	19	5,226
21-Apr-11	1,096	42	-	306
22-Apr-11	276	-	-	54
25-Apr-11	1,824	234	-	294
26-Apr-11	4,150	378	-	2,448
27-Apr-11	5,379	457	19	9,966
28-Apr-11	1,579	18	-	312
29-Apr-11	275	-	-	42
2-May-11	1,258	354	-	456
3-May-11	8,602	396	-	168
4-May-11	3,760	528	21	102
5-May-11	1,266	6	-	336
6-May-11	370	-	-	114
9-May-11	2,346	312	-	432
########	5,819	432	-	54
########	6,369	396	21	-
########	1,066	6	-	-
########	250	-	-	-
########	2,188	240	-	-
########	7,649	414	-	6
########	4,255	684	24	6,858
########	1,276	-	-	384
########	186	-	-	2,190
########	2,272	366	-	5,628
########	9,426	432	-	1,338
########	3,963	606	19	2,748
########	2,404	30	-	762
########	1,365	-	-	108
########	4,000	708	-	-
1-Jun-11	5,886	342	17	3,858
2-Jun-11	596	12	-	288
3-Jun-11	306	-	-	18
6-Jun-11	622	468	-	144
7-Jun-11	8,484	420	-	222
8-Jun-11	5,320	432	21	3,834
9-Jun-11	1,480	12	-	288
10-Jun-11	261	-	-	114
13-Jun-11	2,018	336	-	270
14-Jun-11	5,795	180	-	318
15-Jun-11	6,358	414	2	2,628
16-Jun-11	1,394	-	30	720
17-Jun-11	355	-	-	30
20-Jun-11	324	354	-	216
21-Jun-11	9,660	498	-	1,476
22-Jun-11	3,690	630	6	2,838
23-Jun-11	1,140	12	-	342
24-Jun-11	450	-	-	318
27-Jun-11	716	336	-	186
28-Jun-11	8,094	462	-	1,650
29-Jun-11	5,305	295	-	936
30-Jun-11	1,199	24	-	318
1-Jul-11	120	-	21	12
5-Jul-11	12,099	654	20	1,956
6-Jul-11	4,782	750	-	4,776
7-Jul-11	251	18	-	60
8-Jul-11	200	-	-	72
11-Jul-11	3,617	264	-	114
12-Jul-11	6,661	426	-	354
13-Jul-11	5,620	456	21	3,996
14-Jul-11	1,382	12	-	324
15-Jul-11	250	-	-	60
18-Jul-11	1,983	510	-	222
19-Jul-11	3,748	366	-	372
20-Jul-11	6,542	453	20	3,642
21-Jul-11	1,262	32	-	636
22-Jul-11	100	-	-	24
25-Jul-11	2,053	312	-	444
26-Jul-11	7,234	294	-	288
27-Jul-11	3,250	384	15	5,460
28-Jul-11	1,297	36	-	438
29-Jul-11	611	-	-	216
1-Aug-11	2,215	422	-	294
2-Aug-11	3,910	438	-	2,292
3-Aug-11	5,062	516	21	1,878
4-Aug-11	790	1	-	558
5-Aug-11	200	-	-	66
8-Aug-11	2,082	288	-	360
9-Aug-11	5,476	12	-	294
########	6,014	510	20	5,814
########	1,323	451	-	612
########	200	-	-	162
########	2,404	310	-	390
########	6,114	462	-	252
########	5,613	462	21	5,694
########	1,061	-	-	686
########	150	-	-	78
########	2,143	318	-	480
########	7,288	642	-	4,134
########	3,858	432	20	3,606
########	1,365	18	-	756
########	250	-	-	114
########	2,595	366	-	312
########	5,368	492	-	576
########	7,188	510	20	5,586
1-Sep-11	2,231	-	-	1,158
2-Sep-11	2,948	-	-	354
6-Sep-11	5,621	925	-	132
7-Sep-11	5,686	342	25	6,240
8-Sep-11	702	12	-	390
9-Sep-11	10	-	-	210
########	1,960	391	25	366
########	6,410	432	-	5,562
########	3,208	504	-	3,708
########	1,302	18	-	810
########	253	-	-	120
########	2,748	260	-	522
########	8,870	434	-	4,860
########	3,819	474	25	4,638
########	1,484	-	-	522
########	208	-	-	204
########	2,558	498	-	858
########	7,802	498	-	3,780
########	4,202	522	25	5,436
########	1,313	-	-	864
########	250	-	-	138
3-Oct-11	3,678	445	-	732
4-Oct-11	9,481	522	-	3,240
5-Oct-11	4,158	531	23	4,644
6-Oct-11	754	-	-	468
7-Oct-11	187	-	-	168
########	2,474	344	-	720
########	4,174	559	-	486
########	4,955	540	25	7,290
########	1,143	304	-	846
########	211	-	-	192
########	3,022	348	-	600
########	5,700	1,002	-	9,684
########	1,264	24	1	264
########	1,191	3	22	1,830
########	250	-	-	186
########	2,374	343	-	570
########	4,650	488	-	438
########	4,078	234	2	7,116
########	985	24	24	690
########	660	-	-	510
########	670	498	-	-
1-Nov-11	3,154	468	-	534
2-Nov-11	5,708	540	-	7,464
3-Nov-11	1,237	-	25	336
4-Nov-11	275	-	-	156
7-Nov-11	2,912	504	-	450
8-Nov-11	6,850	504	-	252
9-Nov-11	3,708	432	-	7,560
########	1,078	18	31	816
########	200	-	-	168
########	2,718	306	-	750
########	5,117	420	-	3,600
########	4,716	759	1	7,338
########	1,452	72	29	876
########	2,138	-	-	372
########	600	42	-	276
########	7,989	1,322	-	6,264
########	150	-	-	156
########	1,979	327	-	498
########	4,912	486	29	3,834
########	2,404	372	-	60
1-Dec-11	1,160	6	-	636
2-Dec-11	641	-	-	756
5-Dec-11	1,898	362	-	444
6-Dec-11	5,008	504	-	-
7-Dec-11	4,714	582	-	3,798
8-Dec-11	1,064	50	38	6,800
9-Dec-11	121	-	-	120
########	2,655	684	-	3,870
########	8,036	510	-	444
########	5,234	570	5	3,780
########	882	-	30	702
########	3,188	-	-	744
########	1,010	360	36	600
########	5,582	588	-	522
########	7,427	648	-	6,606
########	2,580	88	-	4,188
########	1,420	-	-	1,074
########	5,287	362	5	324
########	3,129	24	-	6,090
########	-	2	6	102
########	52	-	-	90
3-Jan-12	1,147	1,164	62	558
4-Jan-12	5,100	510	-	10,092
5-Jan-12	776	36	-	642
6-Jan-12	156	-	-	258
9-Jan-12	5,823	354	-	402
10-Jan-12	2,010	42	-	132
11-Jan-12	3,920	1,098	-	6,306
12-Jan-12	1,303	24	-	876
13-Jan-12	357	-	-	174
16-Jan-12	1,992	222	-	420
17-Jan-12	3,351	390	-	138
18-Jan-12	4,976	396	2	13,200
19-Jan-12	-	-	23	72
20-Jan-12	850	-	-	528
23-Jan-12	1,944	456	-	516
24-Jan-12	6,034	432	-	3,690
25-Jan-12	2,227	396	-	10,836
26-Jan-12	2,254	12	26	1,164
27-Jan-12	64	-	-	156
30-Jan-12	2,057	393	-	456
31-Jan-12	4,465	504	-	3,456
1-Feb-12	3,714	546	3	5,082
2-Feb-12	789	24	26	744
3-Feb-12	226	-	-	168
6-Feb-12	2,488	240	-	624
7-Feb-12	5,010	450	-	3,906
8-Feb-12	3,292	444	1	6,366
9-Feb-12	992	42	28	1,014
########	255	-	-	96
########	4,580	716	-	648
########	3,958	866	-	4,212
########	3,469	13	-	3,750
########	2,595	-	36	1,344
########	130	-	-	264
########	-	6	-	-
########	6,898	770	-	3,390
########	2,958	522	2	7,236
########	1,144	6	27	846
########	50	-	-	18
########	2,220	408	29	666
########	4,692	264	-	3,396
########	3,782	390	-	3,762
1-Mar-12	1,360	216	-	726
2-Mar-12	250	-	-	102
5-Mar-12	2,340	372	-	330
6-Mar-12	5,103	480	-	3,666
7-Mar-12	3,582	534	39	4,578
8-Mar-12	1,531	24	-	1,392
9-Mar-12	255	-	-	66
########	2,824	270	-	792
########	6,267	550	-	3,438
########	3,252	546	2	2,730
########	1,361	24	32	738
########	200	-	-	204
########	2,906	278	-	516
########	5,886	456	-	4,062
########	3,892	408	3	2,754
########	707	18	38	660
########	50	-	-	144
########	1,100	450	-	432
########	8,160	465	-	3,648
########	2,041	480	-	1,956
########	3,582	31	44	768
########	705	-	-	384
2-Apr-12	1,938	324	-	570
3-Apr-12	9,366	470	-	252
4-Apr-12	5,004	482	3	7,212
5-Apr-12	1,306	234	35	768
6-Apr-12	1,108	-	-	12
9-Apr-12	1,914	348	-	786
10-Apr-12	5,248	498	-	3,828
11-Apr-12	2,517	420	3	4,704
12-Apr-12	1,043	30	35	864
13-Apr-12	200	-	-	78
16-Apr-12	2,140	300	-	906
17-Apr-12	2,196	264	-	3,828
18-Apr-12	3,175	384	38	4,518
19-Apr-12	1,100	12	-	720
20-Apr-12	100	-	-	84
23-Apr-12	1,434	350	39	444
24-Apr-12	4,741	450	-	3,402
25-Apr-12	3,398	12	-	4,788
26-Apr-12	289	445	-	1,470
27-Apr-12	-	-	-	30
30-Apr-12	550	-	-	210
1-May-12	4,820	716	1	3,642
2-May-12	3,622	577	37	4,566
3-May-12	1,029	224	-	948
4-May-12	312	-	-	432
7-May-12	2,192	432	-	636
8-May-12	4,551	486	7	312
9-May-12	5,530	510	39	7,044
########	1,485	32	-	570
########	206	-	-	186
########	1,878	276	-	600
########	4,892	432	3	3,474
########	4,950	900	35	6,396
########	1,349	18	-	1,350
########	229	-	-	492
########	2,072	405	-	612
########	7,720	480	3	3,714
########	1,314	594	36	4,728
########	1,364	24	-	210
########	1,088	-	-	1,152
########	4,497	-	-	4,536
########	5,332	-	41	2,190
########	-	-	-	840
1-Jun-12	463	-	-	114
4-Jun-12	1,397	698	-	624
5-Jun-12	4,046	840	3	3,852
6-Jun-12	3,170	954	38	3,714
7-Jun-12	1,233	46	-	996
8-Jun-12	158	-	-	192
11-Jun-12	2,654	252	-	210
12-Jun-12	5,506	480	-	4,362
13-Jun-12	2,990	612	43	4,542
14-Jun-12	1,196	6	-	1,032
15-Jun-12	307	-	-	168
18-Jun-12	1,588	342	-	438
19-Jun-12	4,639	540	-	4,026
20-Jun-12	3,559	588	42	4,632
21-Jun-12	1,015	30	-	1,032
22-Jun-12	207	-	-	120
25-Jun-12	5,036	338	-	708
26-Jun-12	7,454	492	-	702
27-Jun-12	5,668	388	42	9,720
28-Jun-12	1,219	31	-	678
29-Jun-12	52	-	-	54
2-Jul-12	6,959	391	8	426
3-Jul-12	4,963	480	33	4,560
5-Jul-12	2,176	480	-	6,894
6-Jul-12	50	-	-	282
9-Jul-12	1,432	111	-	618
10-Jul-12	3,352	546	-	330
11-Jul-12	4,383	578	40	6,384
12-Jul-12	982	-	-	996
13-Jul-12	256	-	-	162
16-Jul-12	1,683	368	-	570
17-Jul-12	50	1,213	-	48
18-Jul-12	4,453	12	42	4,872
19-Jul-12	1,163	24	-	3,942
20-Jul-12	1,300	-	-	2,220
23-Jul-12	1,937	258	-	588
24-Jul-12	4,333	482	-	3,654
25-Jul-12	2,844	396	55	6,432
26-Jul-12	2,085	28	-	3,018
27-Jul-12	50	-	-	42
30-Jul-12	2,206	463	-	960
31-Jul-12	3,282	-	-	564
1-Aug-12	3,892	915	54	2,532
2-Aug-12	1,030	-	-	6,276
3-Aug-12	102	-	-	144
6-Aug-12	1,651	228	-	222
7-Aug-12	2,610	270	-	426
8-Aug-12	2,641	666	70	5,478
9-Aug-12	1,002	24	-	798
########	113	-	-	138
########	2,038	294	-	342
########	4,156	440	-	648
########	3,483	528	52	3,666
########	1,317	12	-	1,206
########	200	-	-	192
########	2,657	360	-	750
########	3,510	164	-	2,556
########	3,524	493	52	6,978
########	992	12	-	1,542
########	464	-	-	1,722
########	2,898	435	-	1,338
########	4,814	138	-	516
########	2,961	492	52	3,720
########	2,180	42	-	1,470
########	137	-	-	78
4-Sep-12	5,148	702	-	2,856
5-Sep-12	3,374	800	53	3,708
6-Sep-12	889	4	-	378
7-Sep-12	60	-	-	162
########	2,266	144	-	810
########	3,073	492	-	3,600
########	4,458	464	53	6,528
########	1,220	12	-	732
########	250	-	-	126
########	1,640	516	-	648
########	5,618	456	8	246
########	3,942	516	51	3,888
########	1,311	6	-	660
########	150	-	-	126
########	5,476	360	-	354
########	5,724	456	8	552
########	3,058	504	56	2,724
########	2,304	24	-	576
########	210	-	-	102
1-Oct-12	3,194	541	-	474
2-Oct-12	7,383	462	-	234
3-Oct-12	2,484	374	62	2,856
4-Oct-12	1,162	48	-	828
5-Oct-12	326	-	-	84
8-Oct-12	1,290	337	-	264
9-Oct-12	3,434	553	-	2,316
########	3,329	358	62	2,790
########	1,000	37	-	708
########	251	-	-	252
########	1,809	979	-	474
########	2,265	469	10	426
########	4,410	36	52	4,848
########	884	6	-	558
########	200	-	-	600
########	1,848	458	-	1,542
########	5,001	534	-	2,526
########	2,819	476	62	1,152
########	1,720	6	-	858
########	50	-	-	78
########	8,541	1,418	-	8,556
1-Nov-12	1,368	18	72	612
2-Nov-12	100	-	-	138
5-Nov-12	1,644	301	-	408
6-Nov-12	4,118	438	-	3,084
7-Nov-12	2,826	30	63	4,494
8-Nov-12	1,100	432	-	594
9-Nov-12	207	-	-	84
########	2,567	660	-	234
########	5,634	504	-	3,234
########	2,823	510	65	2,946
########	905	51	-	720
########	211	-	-	114
########	5,032	458	-	768
########	8,079	1,110	65	8,664
########	154	-	-	156
########	2,216	260	-	90
########	2,736	468	-	324
########	3,783	306	66	2,322
########	784	6	-	564
########	254	-	-	162
3-Dec-12	2,817	312	-	222
4-Dec-12	4,230	492	-	2,550
5-Dec-12	2,944	301	5	2,946
6-Dec-12	1,288	-	-	654
7-Dec-12	250	-	70	132
########	3,844	699	-	414
########	4,707	576	-	2,616
########	5,890	528	101	3,924
########	1,010	6	-	294
########	210	-	-	42
########	4,022	427	-	468
########	7,156	530	-	2,850
########	3,569	924	121	6,870
########	3,182	-	-	552
########	2,202	-	-	726
########	1	-	-	12
########	1,506	24	-	2,304
########	2,272	12	-	510
########	14	-	-	84
########	2,500	-	-	12
2-Jan-13	10,320	2,058	15	4,320
3-Jan-13	629	60	52	318
4-Jan-13	204	-	-	96
7-Jan-13	740	539	-	180
8-Jan-13	3,202	624	-	2,076
9-Jan-13	2,818	246	67	2,754
10-Jan-13	1,068	30	-	702
11-Jan-13	252	-	-	72
14-Jan-13	1,025	450	-	312
15-Jan-13	2,201	37	-	2,130
16-Jan-13	2,041	396	67	3,720
17-Jan-13	1,097	6	-	588
18-Jan-13	150	-	-	168
21-Jan-13	669	468	-	120
22-Jan-13	4,914	404	-	2,076
23-Jan-13	1,606	576	66	1,902
24-Jan-13	840	42	-	324
25-Jan-13	100	-	-	60
28-Jan-13	981	566	-	378
29-Jan-13	2,153	756	5	1,836
30-Jan-13	1,470	204	75	1,848
31-Jan-13	759	-	-	54
1-Feb-13	156	-	-	732
4-Feb-13	647	516	-	264
5-Feb-13	1,130	72	5	66
6-Feb-13	1,530	-	62	1,878
7-Feb-13	1,299	283	-	342
8-Feb-13	180	-	-	120
########	615	352	-	354
########	4,112	360	8	2,100
########	2,409	324	59	2,790
########	1,013	75	-	474
########	200	-	-	114
########	871	414	-	114
########	2,648	342	-	78
########	5,978	12	67	1,878
########	1,079	16	-	414
########	157	-	-	108
########	1,321	450	-	366
########	2,500	42	-	1,434
########	2,640	150	81	2,802
########	1,632	9	-	654
1-Mar-13	100	-	-	48
4-Mar-13	1,492	582	-	264
5-Mar-13	191	289	-	2,100
6-Mar-13	2,874	73	68	2,004
7-Mar-13	938	10	-	186
8-Mar-13	244	-	-	48
########	263	308	-	336
########	1,720	432	-	2,004
########	1,405	117	70	3,018
########	933	6	-	378
########	256	-	-	72
########	-	4	-	12
########	1,021	1,158	-	2,184
########	1,424	168	68	2,148
########	416	1	-	336
########	160	-	-	48
########	648	354	-	168
########	500	265	-	1,848
########	136	162	89	1,914
########	647	1	-	672
########	1	-	-	96

It contains actual demand data for four real products (A, B, C, and D). I cannot tell you what the product are, but the industry is pharmaceuticals.

How to submit:

• Analyze the data contained, applying any forecasting method you believe will produce an accurate forecast.
• You will be required to submit your assignment using any statistics, graphs, and interpretations you produced from analyzing the data.
• Make sure to include any relevant statistics that are necessary to showcase your forecast.
• There is no need to include the actual forecasted values or any of the data.

QUESTION:

1/ Which forecasting methods did you try for each product? Why did you choose those forecasting methods?

2/For each one of the four products, what patterns do you see and what does it mean for the forecast?

3/ What is your conclusion of the results? Do the forecasting methods work well?

Do you have any thoughts on how could you possibly improve them?

Enter text here

4/Now that you have forecasts for these products, what next? Please outline the next steps in how you would use the forecast to create a Supply Chain Plan.