Fashion Merchandising and Trading, and assignment will need excel sheets.

Actual Monday Week 6

Actual WSSI Monday Week 6
Dept:	Outerwear	Season:	AW 2018
Cat:	All	Hide	Current Week	Planning
*7.5 Weeks	Hide	Hide
Sales £K	Stock & Cover	Intake	Markdown	Last Year	Phasing
Week	Date	Act/ Fcst	Target	Var Tgt%	Var LY%	Act/ Fcst Opening Stk	Fwd Req Stk*	Target Stk	TY Opening Cover	LY Opening Cover	Tgt Opening Cover	Total	Orders/ Act Intake	OTB	Calc OTB	Total	POS	Clearance	Target	Sales	Total MD	POS	Opening Stock	Sales Mix	Calendar	LY Intake
1	27-Aug-18	294	393	-25.2%	-20.5%	3,665	4470	3,800	8.2	7.0	9.7	552	552	1,086	10	10	0	370	12	12	2,574	2.0%	964
2	3-Sep-18	300	489	-38.7%	-33.0%	3,913	4999	3,800	13.0	7.0	7.8	1,659	1,659	223	11	11	0	448	14	14	3,156	2.0%	1,323
3	10-Sep-18	464	543	-14.5%	-1.3%	5,261	5484	3,800	11.3	8.5	7.0	1,388	1,388	-370	18	18	0	470	17	17	4,017	3.1%	1,311
4	17-Sep-18	474	687	-31.0%	-19.8%	6,167	5797	3,800	13.0	8.2	5.5	1,260	1,260	-914	21	21	591	22	22	4,841	3.2%	1,800
Sept	1,532	2,112	-27.5%	-18.5%	19,006	20750	15,200	4,859	4,859	0	25	60	60	0	0	1,879	65	65	14,588	10.3%	5,398
5	24-Sep-18	686	1,093	-37.2%	-35.7%	6,932	6019	6,500	10.1	5.6	5.9	1,156	1,156	-1,382	34	34	1,067	46	46	6,028	4.6%	1,101
6	1-Oct-18	919	905	1.5%	1.7%	7,368	5987	6,500	8.0	6.7	7.2	1,237	1,237	-1,801	52	52	904	45	45	6,016	6.2%	1,058
7	8-Oct-18	902	780	15.6%	40.5%	7,634	5833	6,500	8.5	9.5	8.3	1,144	1,144	-2,036	47	47	0	642	32	32	6,125	6.1%	1,136
8	15-Oct-18	862	948	-9.1%	18.6%	7,829	5793	6,500	9.1	9.1	6.9	1,095	1,095	-2,025	195	34	161	0	727	93	28	6,587	5.8%	1,873
Oct	3,369	3,726	-9.6%	0.9%	29,763	23631	26,000	4,632	4,632	0	-7,244	328	167	161	0	3,340	216	151	24,756	22.8%	5,168
9	22-Oct-18	784	1,204	-34.9%	-35.7%	7,867	5842	7,570	10.0	6.3	6.3	683	683	-1,737	32	32	0	1,219	57	57	7,640	5.3%	1,111
10	29-Oct-18	785	870	-9.8%	-0.9%	7,734	5998	7,570	9.9	9.4	8.7	850	850	-1,754	44	44	0	792	55	55	7,475	5.3%	659
11	5-Nov-18	770	824	-6.6%	17.7%	7,755	6001	7,570	10.1	11.1	9.2	503	503	-1,576	38	38	0	654	47	47	7,287	5.2%	701
12	12-Nov-18	621	831	-25.3%	-4.9%	7,450	5874	7,570	12.0	11.2	9.1	810	810	-1,871	47	47	0	653	64	64	7,287	4.2%	721
13	19-Nov-18	687	711	-3.4%	-1.3%	7,592	5721	7,570	11.1	10.5	10.6	448	448	-2,001	42	42	0	696	57	57	7,291	4.6%	841
Nov	3,647	4,440	-17.9%	-9.1%	38,398	29436	37,850	3,294	3,294	0	-8,938	203	203	0	0	4,014	280	280	36,980	24.6%	4,033
Cum	8,548	10,278	-16.8%	-7.4%	87,167	73816	79,050	12,785	12,785	0	-16,157	591	430	161	0	9,233	561	496	76,324	57.7%	14,599
14	26-Nov-18	844	766	10.2%	7.0%	7,311	5311	7,000	8.7	9.4	9.1	3,215	0	3,215	-4,919	61	61	0	789	73	73	7,379	5.7%	860
15	3-Dec-18	880	804	9.5%	27.4%	9,621	4703	7,000	10.9	10.7	8.7	0	0	-1,221	65	65	0	691	53	53	7,377	5.9%	690
16	10-Dec-18	942	912	3.3%	45.1%	8,676	7455	6,700	9.2	11.3	7.3	0	0	-1,221	72	72	0	649	54	54	7,323	6.4%	247
17	17-Dec-18	937	912	2.7%	18.6%	7,662	6441	6,000	8.2	8.7	6.6	0	0	-1,221	978	38	940	0	790	1,032	53	6,867	6.3%	205
Dec	3,603	3,394	6.2%	23.4%	33,270	23909	26,700	3,215	0	3,215	-8,582	1,176	236	940	0	2,919	1,212	233	28,946	24.3%	2,002
18	24-Dec-18	640	625	2.4%	-9.5%	5,747	4526	4,200	9.0	7.4	6.7	0	0	0	-1,221	33	33	0	707	76	30	5,250	4.3%	0
19	31-Dec-18	646	333	94.0%	86.2%	5,074	3853	3,500	7.9	12.9	10.5	0	0	0	-1,221	15	15	0	347	18	18	4,467	4.4%	0
20	7-Jan-19	290	290	0.0%	6.6%	4,413	3192	3,200	15.2	15.1	11.0	0	0	0	-1,221	260	15	245	0	272	237	18	4,102	2.0%	0
21	14-Jan-19	263	263	0.0%	7.3%	3,863	2642	2,650	14.7	14.7	10.1	0	0	0	-1,221	12	12	0	245	14	14	3,593	1.8%	0
Jan	1,839	1,511	21.7%	17.1%	19,097	14213	13,550	0	0	0	-4,884	320	75	245	0	1,571	345	80	17,412	12.4%	0
22	21-Jan-19	209	209	0.0%	19.4%	3,588	2367	2,370	17.2	19.1	11.3	0	0	0	-1,221	9	9	0	175	9	9	3,334	1.4%	0
23	28-Jan-19	156	156	0.0%	5.4%	3,370	2149	2,150	21.6	21.3	13.8	0	0	0	-1,221	7	7	0	0	148	6	6	3,150	1.1%	0
24	4-Feb-19	177	177	0.0%	-8.8%	3,207	1986	2,000	18.1	15.4	11.3	0	0	0	-1,221	322	7	315	0	194	244	11	2,996	1.2%	0
25	11-Feb-19	150	150	0.0%	8.7%	2,708	1487	1,480	18.1	18.5	9.9	0	0	0	-1,221	6	6	0	0	138	9	9	2,558	1.0%	0
26	18-Feb-19	125	125	0.0%	5.9%	2,552	1331	1,330	20.4	20.4	10.6	0	0	0	-1,221	6	6	0	118	6	6	2,411	0.8%	0
Feb	817	817	0.0%	5.7%	15,425	9320	9,330	0	0	0	-6,105	350	35	315	0	773	274	41	14,449	5.5%	0
Cum	14,807	16,000	-7.5%	2.1%	154,959	121258	128,630	10.5	9.5	8.0	16,000	12,785	3,215	-35,727	2,437	776	1,661	0	14,496	2,392	850	137,131	100.0%	16,601
27	25-Feb-19	2,421	1200	1,200	2,287
Stockturn	2.5	2.7
8.5

Target

Target WSSI
Dept:	Outerwear	Season:	AW 2018
Cat:	All	Hide	Current Week	Planning
*7.5 Weeks	Hide	Hide
Sales £K	Stock & Cover	Intake	Markdown	Last Year	Phasing
Week	Date	Act/ Fcst	Target	Var Tgt%	Var LY%	Act/ Fcst Opening Stk	Fwd Req Stk*	Target Stk	TY Opening Cover	LY Opening Cover	Tgt Opening Cover	Total	Orders/ Act Intake	OTB	Calc OTB	Total	POS	Clearance	Target	Sales	Total MD	POS	Opening Stock	Sales Mix	Calendar	LY Intake
1	27-Aug-18	393	393	0.0%	6.2%	3,800	5364	3,800	8.2	7.0	9.7	403	403	2,247	10	10	0	370	12	12	2,574	2.5%	964
2	3-Sep-18	489	489	0.0%	9.2%	3,800	6047	3,800	7.8	7.0	7.8	500	500	2,795	11	11	0	448	14	14	3,156	3.1%	1,323
3	10-Sep-18	543	543	0.0%	15.5%	3,800	6595	3,800	7.0	8.5	7.0	561	561	3,099	18	18	0	470	17	17	4,017	3.4%	1,311
4	17-Sep-18	687	687	0.0%	16.2%	3,800	6899	3,800	5.5	8.2	5.5	3,408	3,408	540	21	21	591	22	22	4,841	4.3%	1,800
Sept	2,112	2,112	0.0%	12.4%	15,200	24905	15,200	4,872	0	4,872	8,681	60	60	0	0	1,879	65	65	14,588	13.2%	5,398
5	24-Sep-18	1,093	1,093	0.0%	2.4%	6,500	7040	6,500	5.9	5.6	5.9	1,127	1,127	218	34	34	1,067	46	46	6,028	6.8%	1,101
6	1-Oct-18	905	905	0.0%	0.1%	6,500	6718	6,500	7.2	6.7	7.2	957	957	51	52	52	904	45	45	6,016	5.7%	1,058
7	8-Oct-18	780	780	0.0%	21.5%	6,500	6551	6,500	8.3	9.5	8.3	827	827	56	47	47	0	642	32	32	6,125	4.9%	1,136
8	15-Oct-18	948	948	0.0%	30.4%	6,500	6556	6,500	6.9	9.1	6.9	2,213	2,213	-1,104	195	34	161	0	727	93	28	6,587	5.9%	1,873
Oct	3,726	3,726	0.0%	11.6%	26,000	26864	26,000	5,124	0	5,124	-780	328	167	161	0	3,340	216	151	24,756	23.3%	5,168
9	22-Oct-18	1,204	1,204	0.0%	-1.2%	7,570	6466	7,570	6.3	6.3	6.3	1,236	1,236	-1,396	32	32	0	1,219	57	57	7,640	7.5%	1,111
10	29-Oct-18	870	870	0.0%	9.8%	7,570	6174	7,570	8.7	9.4	8.7	914	914	-1,498	44	44	0	792	55	55	7,475	5.4%	659
11	5-Nov-18	824	824	0.0%	26.0%	7,570	6073	7,570	9.2	11.1	9.2	862	862	-1,843	38	38	0	654	47	47	7,287	5.2%	701
12	12-Nov-18	831	831	0.0%	27.3%	7,570	5728	7,570	9.1	11.2	9.1	878	878	-2,362	47	47	0	653	64	64	7,287	5.2%	721
13	19-Nov-18	711	711	0.0%	2.2%	7,570	5208	7,570	10.6	10.5	10.6	183	183	-2,227	42	42	0	696	57	57	7,291	4.4%	841
Nov	4,440	4,440	0.0%	10.6%	37,850	29648	37,850	4,073	0	4,073	-9,325	203	203	0	0	4,014	280	280	36,980	27.8%	4,033
Cum	10,278	10,278	0.0%	11.3%	79,050	81417	79,050	14,069	0	14,069	-1,424	591	430	161	0	9,233	561	496	76,324	64.2%	14,599
14	26-Nov-18	766	766	0.0%	-2.9%	7,000	4774	7,000	9.1	9.4	9.1	827	0	827	-2,757	61	61	0	789	73	73	7,379	4.8%	860
15	3-Dec-18	804	804	0.0%	16.4%	7,000	4244	7,000	8.7	10.7	8.7	569	0	569	372	65	65	0	691	53	53	7,377	5.0%	690
16	10-Dec-18	912	912	0.0%	40.5%	6,700	7072	6,700	7.3	11.3	7.3	284	0	284	88	72	72	0	649	54	54	7,323	5.7%	247
17	17-Dec-18	912	912	0.0%	15.4%	6,000	6088	6,000	6.6	8.7	6.6	88	0	88	0	978	38	940	0	790	1,032	53	6,867	5.7%	205
Dec	3,394	3,394	0.0%	16.3%	26,700	22177	26,700	1,768	0	1,768	-2,297	1,176	236	940	0	2,919	1,212	233	28,946	21.2%	2,002
18	24-Dec-18	625	625	0.0%	-11.6%	4,198	4198	4,200	6.7	7.4	6.7	0	0	0	0	33	33	0	707	76	30	5,250	3.9%	0
19	31-Dec-18	333	333	0.0%	-4.0%	3,540	3540	3,500	10.6	12.9	10.5	0	0	0	0	15	15	0	347	18	18	4,467	2.1%	0
20	7-Jan-19	290	290	0.0%	6.6%	3,192	3192	3,200	11.0	15.1	11.0	0	0	0	0	260	15	245	0	272	237	18	4,102	1.8%	0
21	14-Jan-19	263	263	0.0%	7.3%	2,642	2642	2,650	10.0	14.7	10.1	0	0	0	0	12	12	0	245	14	14	3,593	1.6%	0
Jan	1,511	1,511	0.0%	-3.8%	13,572	13572	13,550	0	0	0	0	320	75	245	0	1,571	345	80	17,412	9.4%	0
22	21-Jan-19	209	209	0.0%	19.4%	2,367	2367	2,370	11.3	19.1	11.3	0	0	0	0	9	9	0	175	9	9	3,334	1.3%	0
23	28-Jan-19	156	156	0.0%	5.4%	2,149	2149	2,150	13.8	21.3	13.8	0	0	0	0	7	7	0	0	148	6	6	3,150	1.0%	0
24	4-Feb-19	177	177	0.0%	-8.8%	1,986	1986	2,000	11.2	15.4	11.3	0	0	0	0	322	7	315	0	194	244	11	2,996	1.1%	0
25	11-Feb-19	150	150	0.0%	8.7%	1,487	1487	1,480	9.9	18.5	9.9	0	0	0	0	6	6	0	0	138	9	9	2,558	0.9%	0
26	18-Feb-19	125	125	0.0%	5.9%	1,331	1331	1,330	10.6	20.4	10.6	0	0	0	0	6	6	0	118	6	6	2,411	0.8%	0
Feb	817	817	0.0%	5.7%	9,320	9320	9,330	0	0	0	0	350	35	315	0	773	274	41	14,449	5.1%	0
Cum	16,000	16,000	0.0%	10.4%	128,642	126486	128,630	8.0	9.5	8.0	15,837	0	15,837	-3,720	2,437	776	1,661	0	14,496	2,392	850	137,131	100.0%	16,601
27	25-Feb-19	1,200	1200	1,200	2,287
Stockturn	3.2	2.7

Original

Total WSSI
Dept:	Outerwear	Season:	AW 2018
Cat:	All	Hide	Current Week	Planning
*8 Weeks	Hide	aa hidden
Sales £K	Stock & Cover	Intake	Markdown	Last Year	Phasing
Week	Date	Act/ Fcst	Target	Var Tgt%	Var LY%	Act/ Fcst Opening Stk	Fwd Req Stk*	Target Stk	TY Opening Cover	LY Opening Cover	Tgt Opening Cover	Total	Orders/ Act Intake	OTB	Target	Total	POS	Clearance	Target	Sales	Total MD	POS	Opening Stock	Sales Mix	Calendar
1	27-Aug-18	294	393	-25.2%	-20.5%	3,665	4901	3,800	8.2	7.0	8.0	552	552	0	-60,975	10	10	0	370	0	13	2,574	2.0%	180,000
2	3-Sep-18	300	489	-38.7%	-33.0%	3,913	5391	3,800	13.0	7.0	7.8	1,659	1,659	0	21,025	11	11	0	448	0	16	3,155	2.0%	0
3	10-Sep-18	464	543	-14.5%	-1.3%	5,261	5876	3,800	11.3	8.5	7.0	1,388	1,388	0	-139,760	18	18	0	470	0	19	4,017	3.1%	100,000
4	17-Sep-18	474	687	-31.0%	-19.8%	6,167	6182	3,800	13.0	8.2	5.5	1,260	1,260	0	40,165	21	21	591	0	24	4,841	3.2%	100,000
Sept	1,532	2,112	-27.5%	-18.5%	4,859	4,859	0	-139,545	60	60	0	0	1,879	0	72	14,587	10.3%	380,000
5	24-Sep-18	686	1,093	-37.2%	-35.7%	6,932	6329	6,500	10.1	5.1	5.9	1,156	1,156	0	120,165	34	34	1,067	0	49	5,426	4.6%	100,000
6	1-Oct-18	919	905	1.5%	1.7%	7,368	6330	6,500	8.0	5.7	7.2	1,237	1,237	0	34,040	52	52	904	0	48	5,130	6.2%	100,000
7	8-Oct-18	902	780	15.6%	40.5%	7,634	6255	6,500	8.5	8.6	8.3	1,144	1,144	0	132,540	47	47	0	642	0	34	5,536	6.1%	100,000
8	15-Oct-18	862	948	-9.1%	18.6%	7,829	6233	6,500	9.1	8.2	6.9	1,095	1,095	0	3,990	195	34	161	0	727	63	30	5,996	5.8%	100,000
Oct	3,369	3,726	-9.6%	0.9%	4,632	4,632	0	290,735	328	167	161	0	3,340	63	161	22,088	22.8%	400,000
9	22-Oct-18	784	1,204	-34.9%	-35.7%	7,867	6313	8,220	10.0	5.3	6.8	683	683	0	-10	32	32	0	1,219	0	64	6,512	5.3%	85,000
10	29-Oct-18	785	870	-9.8%	-0.9%	7,734	6466	8,220	9.9	8.0	9.4	850	850	0	-10,760	44	44	0	792	0	62	6,340	5.3%	85,000
11	5-Nov-18	770	824	-6.6%	17.7%	7,755	6321	8,220	10.1	9.4	10.0	503	503	42,240	38	38	0	654	0	52	6,145	5.2%	85,000
12	12-Nov-18	621	831	-25.3%	-4.9%	7,450	6197	8,220	12.0	10.0	9.9	810	810	-260	47	47	0	653	0	71	6,540	4.2%	85,000
13	19-Nov-18	687	711	-3.4%	-1.3%	7,592	6671	8,220	11.1	9.4	11.6	448	448	0	-260	42	42	0	696	0	64	6,537	4.6%	30,000
Nov	3,647	4,440	-17.9%	-9.1%	3,294	3,294	0	30,950	203	203	0	0	4,014	0	313	32,074	24.6%	370,000
Cum	8,548	10,278	-16.8%	-7.4%	12,785	12,785	0	182,140	591	430	161	0	9,233	63	546	68,749	57.7%	1,150,000
14	26-Nov-18	844	766	10.2%	7.0%	7,311	6134	7,100	8.7	8.6	9.3	3,215	0	3,215	-99,610	61	61	0	789	0	92	6,818	5.7%	30,000
15	3-Dec-18	880	804	9.5%	27.4%	9,621	5415	7,100	10.9	9.4	8.8	0	0	0	-52,610	65	65	0	691	0	67	6,497	5.9%	30,000
16	10-Dec-18	942	912	3.3%	45.1%	8,676	7455	7,100	9.2	9.9	7.8	0	0	0	-610	72	72	0	649	5	68	6,429	6.4%	30,000
17	17-Dec-18	937	912	2.7%	18.6%	7,662	6441	7,100	8.2	7.8	7.8	0	0	0	-610	978	38	940	0	790	1,395	67	6,186	6.3%	60,000
Dec	3,603	3,394	6.2%	23.4%	3,215	0	3,215	-153,440	1,176	236	940	0	2,919	1,400	294	25,930	24.3%	150,000
18	24-Dec-18	640	625	2.4%	-9.5%	5,747	4526	3,050	9.0	6.2	4.9	0	0	0	-610	33	33	0	707	149	43	4,409	4.3%	50,000
19	31-Dec-18	646	333	94.0%	86.2%	5,074	3853	3,050	7.9	11.4	9.2	0	0	390	15	15	0	347	0	25	3,957	4.4%	50,000
20	7-Jan-19	290	290	0.0%	6.6%	4,413	3192	3,050	15.2	13.8	10.5	0	0	-610	260	15	245	0	272	410	22	3,765	2.0%	50,000
21	14-Jan-19	263	263	0.0%	7.3%	3,863	2642	3,050	14.7	13.0	11.6	0	0	0	-610	12	12	0	245	0	18	3,193	1.8%	50,000
Jan	1,839	1,511	21.7%	17.1%	0	0	0	-1,440	320	75	245	0	1,571	559	108	15,324	12.4%	200,000
22	21-Jan-19	209	209	0.0%	19.4%	3,588	2367	1,610	17.2	18.4	7.7	0	0	0	-610	9	9	0	175	0	11	3,221	1.4%	40,000
23	28-Jan-19	156	156	0.0%	5.4%	3,370	2149	1,610	21.6	19.6	10.3	0	0	0	57,390	7	7	0	0	148	0	8	2,900	1.1%	40,000
24	4-Feb-19	177	177	0.0%	-8.8%	3,207	1986	1,610	18.1	13.6	9.1	0	0	0	91,390	322	7	315	0	194	370	14	2,645	1.2%	0
25	11-Feb-19	150	150	0.0%	8.7%	2,708	1487	1,610	18.1	15.3	10.7	0	0	0	83,390	6	6	0	0	138	0	11	2,114	1.0%	0
26	18-Feb-19	125	125	0.0%	5.9%	2,552	1331	1,610	20.4	17.6	12.9	0	0	0	-3,610	6	6	0	118	0	7	2,082	0.8%	0
Feb	817	817	0.0%	5.7%	0	0	0	227,950	350	35	315	0	773	370	51	12,962	5.5%	80,000
Cum	14,807	16,000	-7.5%	2.1%	149,302	16,000	12,785	3,215	255,210	2,437	776	1,661	0	14,496	2,392	999	122,965	100.0%	1,580,000
27	25-Feb-19	2,421	1200	1,200	2,287
Stockturn	2.6	3.1	5.2%	6.9%

This is not possible - wk 25, if your opening stock is 1610, with a target sales of Wk25 150, wk 26 125 and target md of wk 25 and 26 6, then you can only get down to 1323 closing stock

This is not possible - if you buy to a target stock of 8220 in Nov then you need a negative OTB week 13 of -367 to get to the next month's target stock of 7100

This is not possible - if you buy to a target stock of 7100 in Nov then you need a negative OTB week 17 of -2160 to get to the next month's target stock of 3050

LY Total MD ignores weekly POS

LY Stock figures would mean negative intake