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

Week12WC14thJanuarySeminar-20190120.zip

Home >Business & Finance homework help >Management homework help >Fashion Merchandising and Trading, and assignment will need excel sheets.

blank line details MPAT.xlsx

Line Buy Plan

OTB RANGE PLAN LINE DETAILS	THESE COLUMNS CAN BE WHATEVER YOU WANT TO ANALYSE…
Style description	Colour	Selling Price	Category	FABRIC	END USE	Risk	ROS	No. of stores	Weeks in store	Total unit buy	Total buy Selling Value
1	LOW	0	0.0
2	MEDIUM	0	0.0
3	HIGH	0	0.0
4	0	0.0
5	0	0.0
6	0	0.0
7	0	0.0
8	0	0.0
9	0	0.0
10	0	0.0
0	0.0
0	0.0
0	0.0
0	0.0
0	0.0
0	0.0
0	0.0
WEIGHTED AVERAGE AND SUB TOTALS	ERROR:#DIV/0!	0	0.0
option count	0

MPT Make the Grade.pptx

BA Hons Fashion Buying & Merchandising

Merchandising Planning & Trading

Make the Grade

Teaching Team

Lois Baile, Katie de Ley, Jonathan Baker, Holly Wadsworth

Lecture Topics by Week

Intro to Unit – Recap

Planning Process

Sales and Space Planning

VM – Surveying the Space

VM – What is Visual Merchandising?

Activities Week

VM Drawing the Plan of Space

VM Fixtures, Props and Lighting

Trading for Success – Recap Of Merch

Changes to the Retail Landscape – Formative Assessment

Numeracy/Excel Sessions

Xmas Break

Numeracy/Excel Sessions

Tutorials

Seminars – Guidance for Submission

The UHB

In this unit you will be operating as a Junior Merchandiser.

You will plan and trade a department and demonstrate that your range fulfils customer choice and balance across 2 sizes of store space

You have been asked to maximise your product offer ensuring your department delivers the key objectives of sales and profitability

From this analysis you will need to make recommendations to maximise the performance of the department through the use of in-season OTB through reforecasting of WSSI, promotions (promotional calendar), and range selection.

You will be expected to show great commercial awareness, optimise trading opportunities, and analyse category, colour price, story, best and worst sellers and core lines, as well as having a thorough understanding of the brand and the relevant trends/products and competitive offer for the core customer.

The Report

Your individual report should contain the following elements:

SUMMATIVE ASSESSMENT

An individual report with appropriate appendices and supporting visual material (2,500 words) (100%)

 2500 word report, plus accompanying data and visual images.

You have been tasked to present a report of your planning proposal and trading initiatives to the senior B&M team. You will be allocated a Brand/Product Category/Customer Profile for your report in week 1.

In your report you will need to show evidence of your ability to research, analyse and evaluate the performance of your allocated product category, looking in detail at sales opportunity within your trading space and demonstrating your financial acumen.

You will be expected to show great commercial awareness, optimise trading opportunities, and analyse category, colour, price,,best and worst sellers and core lines aligned to your brand of choice and the relevant trends/products and competitive offer for the core customer.

New Opportunity identified – Product/Promotion

Topshop - Coats

WSSI to 16m

Market Observation

The Report (cont)

Your individual report should contain the following elements to satisfy the Buying and Merchandising requirements

 A summary of your market opportunity to include the rationale behind your range selection including trend influences and competitor activity for Topshop (500 words)

 Identification of a minimum of four key KPIs (Key Performance Indicators) used by a product merchandiser to effectively plan an ‘in store’ product range. Explain the business relevance of these KPIs using worked examples (250 - 500 words) – Using the option plan – Wk 2 Lecture

 Identification of the four key KPIs (Key Performance Indicators) used by a product merchandiser to monitor performance on a weekly basis. Explain how these KPIs are calculated using worked examples and demonstrate the potential impact to the product category and departmental sales revenue. (250-500 words) Using Interpretation of the WSSI and Rebalancing of Categories of Choice

 Analyse trade within given scenarios to identify the opportunities and risk within the current trading performance. Use data mining sources (EDITED) as well as your commercial awareness to make effective tactical decisions on price, cut, colour, size and fashionability. (750-1000 words)

Using your current knowledge of the market – Competitor activity!

The Report (cont)

 Re-forecast the WSSI as guided in class to identify the in season OTB.

Please note the WSSI should also be submitted as a separate Excel document, to Part 2 of the Turnitin submission.

 Use your OTB to fill the gaps in the range to create a positive trading performance for the remainder of the season. (500 words) ( Using top down option plans to provide solutions for a large store and a small store)

Your individual report should contain the following elements to satisfy the Visual Merchandising Requirements - Review of the Coat Department in TopShop and Visual Presentation to supplement the range with your new OTB Spend

 Space and Zone plans of selected spaces

 Visual Audit of existing brand concept

 Identification and application of fixtures

 Mood Board of concept

All of your decision making must be thoroughly underpinned by research to make sure that your planning is viable.

Learning Outcomes & Marking Criteria

Analysis of the financial aspects of merchandise planning such as forecasting, initial sales plans, intake plans, allocation and stock control using your Excel skills (analysis, subject knowledge, experimentation, technical competence, collaborative and/or independent professional working);

Apply knowledge of retail space management and brand communication to communicate your ideas using your visual creative skills (experimentation, technical competence, research, subject knowledge, communication and presentation);

An understanding of the factors that may affect the profitability and the success of the in- store assortments. (experimentation, research, analysis, subject knowledge, communication and presentation).

Analysis of weekly sales performance reports and the implications of trading decisions to optimise profit by the application of innovative, agile, creative and consumer-centric approaches to contemporary trading. (experimentation, research, analysis, subject knowledge, technical competence).

This unit is designed to build your planning and trading skills and knowledge.

ACTION PLAN – Lecture 1

Brand – TOPSHOP

Department – Outerwear

Research Outerwear Market – SWOT

Plan Product Categories Relevant to Key Customer

Plan Product Categories Relevant to Trends and Decide on Financial Structure

Plan the instore presentation – What store size gets which product?

Recognise a trading situation – React with solutions

Create an OTB proposal to deliver business objectives

Reforecast and submit a WSSI to highlight the OTB

Activities to prepare for the Assignment

Comp shop the High Street regularly to spot the changes which are happening to ranging and pricing within outerwear for Top Shop and its competitors

Look for product opportunity within outerwear

Research the market – what value is outerwear in the UK? How is it trending up or down? – look for category data to support your category matrix

You have seen how cash is translated to options using the graded option plan

You have seen how option frameworks are calculated with assumptions of grade % participations, average sales for individual stores within grades, average price decisions, rate of sale decisions and product lifecycle decisions.

You have been shown how stores are graded in actual situations to provide complex option frameworks although you just need to demonstrate a small and large store using a basic 3 grade model.

You will learn to interpret a working WSSI and provide solutions to recover the trading situation back to the original 16m plan

You will propose a buy based on your reforecasted WSSI to reflect your research of the high street and missing opportunity/trends – this could be a new product category (Could be a sportswear range of Outerwear for example)

You will incorporate this within a visual statement (VRP element of the unit) and demonstrate this for a small space store and large store

You will provide a reworked WSSI and option plan to support your decisions

You can demonstrate your buy on a line detail – this is not essential but confirms your understanding of this document

MPAT Checklist 10th October

MPAT CHECKLIST – RESEARCH AND ANALYSIS WKS 1-3 MERCHANDISING

Comp shop high street to assess product mix, fashionability, price points, sizes available, units etc

Cat planning % mixes – analyse and justify

Cat phasing sheet – analyse and justify – ensure timely and considered

Price architecture – analyse and justify

Market analysis – consumer, trends, comp shop, market place – analyse and justify

Option planning – understanding

Grading – understanding

KPI’s planning – evidence understanding, examples

KPI’s trading – evidence understanding, examples

WSSI sales phasing – interpret, provide solutions, summarise BTA sheet

Line details – from OTB

Target WSSI
Dept:		Outerwear															Season:		AW 2018
Cat:		All															Current Week		Planning

		Sales £K				Stock & Cover					Intake			Markdown			Last Year				Phasing
Week	Date	Act/ Fcst	Target	Var Tgt%	Var LY%	Act/ Fcst Opening Stk	Target Stk	TY Opening Cover	LY Opening Cover	Tgt Opening Cover	Total	Orders/ Act Intake	OTB	Total	POS	Clearance	Sales	Total MD	POS	Opening Stock	Sales Mix	Calendar
1	27-Aug-18	393	393	0.0%	6.2%	3,800	3,800	8.2	7.0	9.7	403		403	10	10		370	12	12	2,574	2.5%
2	03-Sep-18	489	489	0.0%	9.2%	3,800	3,800	7.8	7.0	7.8	500		500	11	11		448	14	14	3,156	3.1%
3	10-Sep-18	543	543	0.0%	15.5%	3,800	3,800	7.0	8.5	7.0	561		561	18	18		470	17	17	4,017	3.4%
4	17-Sep-18	687	687	0.0%	16.2%	3,800	3,800	5.5	8.2	5.5	3,408		3,408	21	21		591	22	22	4,841	4.3%
Sept		2,112	2,112	0.0%	12.4%	15,200	15,200				4,872	0	4,872	60	60	0	1,879	65	65	14,588	13.2%
5	24-Sep-18	1,093	1,093	0.0%	2.4%	6,500	6,500	5.9	5.6	5.9	1,127		1,127	34	34		1,067	46	46	6,028	6.8%
6	01-Oct-18	905	905	0.0%	0.1%	6,500	6,500	7.2	6.7	7.2	957		957	52	52		904	45	45	6,016	5.7%
7	08-Oct-18	780	780	0.0%	21.5%	6,500	6,500	8.3	9.5	8.3	827		827	47	47		642	32	32	6,125	4.9%
8	15-Oct-18	948	948	0.0%	30.4%	6,500	6,500	6.9	9.1	6.9	2,213		2,213	195	34	161	727	93	28	6,587	5.9%
Oct		3,726	3,726	0.0%	11.6%	26,000	26,000				5,124	0	5,124	328	167	161	3,340	216	151	24,756	23.3%
9	22-Oct-18	1,204	1,204	0.0%	-1.2%	7,570	7,570	6.3	6.3	6.3	1,236		1,236	32	32		1,219	57	57	7,640	7.5%
10	29-Oct-18	870	870	0.0%	9.8%	7,570	7,570	8.7	9.4	8.7	914		914	44	44		792	55	55	7,475	5.4%
11	05-Nov-18	824	824	0.0%	26.0%	7,570	7,570	9.2	11.1	9.2	862		862	38	38		654	47	47	7,287	5.2%
12	12-Nov-18	831	831	0.0%	27.3%	7,570	7,570	9.1	11.2	9.1	878		878	47	47		653	64	64	7,287	5.2%
13	19-Nov-18	711	711	0.0%	2.2%	7,570	7,570	10.6	10.5	10.6	183		183	42	42		696	57	57	7,291	4.4%
Nov		4,440	4,440	0.0%	10.6%	37,850	37,850				4,073	0	4,073	203	203	0	4,014	280	280	36,980	27.8%
Cum		10,278	10,278	0.0%	11.3%	79,050	79,050				14,069	0	14,069	591	430	161	9,233	561	496	76,324	64.2%
14	26-Nov-18	766	766	0.0%	-2.9%	7,000	7,000	9.1	9.4	9.1	827	0	827	61	61		789	73	73	7,379	4.8%
15	03-Dec-18	804	804	0.0%	16.4%	7,000	7,000	8.7	10.7	8.7	569	0	569	65	65		691	53	53	7,377	5.0%
16	10-Dec-18	912	912	0.0%	40.5%	6,700	6,700	7.3	11.3	7.3	284	0	284	72	72		649	54	54	7,323	5.7%
17	17-Dec-18	912	912	0.0%	15.4%	6,000	6,000	6.6	8.7	6.6	88	0	88	978	38	940	790	1,032	53	6,867	5.7%
Dec		3,394	3,394	0.0%	16.3%	26,700	26,700				1,768	0	1,768	1,176	236	940	2,919	1,212	233	28,946	21.2%
18	24-Dec-18	625	625	0.0%	-11.6%	4,198	4,200	6.7	7.4	6.7	0	0	0	33	33		707	76	30	5,250	3.9%
19	31-Dec-18	333	333	0.0%	-4.0%	3,540	3,500	10.6	12.9	10.5	0	0	0	15	15		347	18	18	4,467	2.1%
20	07-Jan-19	290	290	0.0%	6.6%	3,192	3,200	11.0	15.1	11.0	0	0	0	260	15	245	272	237	18	4,102	1.8%
21	14-Jan-19	263	263	0.0%	7.3%	2,642	2,650	10.0	14.7	10.1	0	0	0	12	12		245	14	14	3,593	1.6%
Jan		1,511	1,511	0.0%	-3.8%	13,572	13,550				0	0	0	320	75	245	1,571	345	80	17,412	9.4%
22	21-Jan-19	209	209	0.0%	19.4%	2,367	2,370	11.3	19.1	11.3	0	0	0	9	9		175	9	9	3,334	1.3%
23	28-Jan-19	156	156	0.0%	5.4%	2,149	2,150	13.8	21.3	13.8	0	0	0	7	7	0	148	6	6	3,150	1.0%
24	04-Feb-19	177	177	0.0%	-8.8%	1,986	2,000	11.2	15.4	11.3	0	0	0	322	7	315	194	244	11	2,996	1.1%
25	11-Feb-19	150	150	0.0%	8.7%	1,487	1,480	9.9	18.5	9.9	0	0	0	6	6	0	138	9	9	2,558	0.9%
26	18-Feb-19	125	125	0.0%	5.9%	1,331	1,330	10.6	20.4	10.6	0	0	0	6	6		118	6	6	2,411	0.8%
Feb		817	817	0.0%	5.7%	9,320	9,330				0	0	0	350	35	315	773	274	41	14,449	5.1%
Cum		16,000	16,000	0.0%	10.4%	128,642	128,630	8.0	9.5	8.0	15,837	0	15,837	2,437	776	1,661	14,496	2,392	850	137,131	100.0%
27	25-Feb-19					1,200	1,200													2,287
						Stockturn		3.2	2.7

Actual WSSI Monday Week 6
Dept:		Outerwear															Season:		AW 2018
Cat:		All															Current Week		Planning

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

Financial Understanding

Planning Activity

Created Category Planning Sheet

Rebalanced to your Department WSSI

Trading Activity

Interpreted WSSI

Reforecast Sales to bring back to plan

Provide product solutions with the OTB created

Use the Option Plan to drive options for ‘large store’ and ‘small store’

Nominate product opportunity to fill the options and define through trend / theme/ colour/ fabric/ pricing suggestions

Provide Rationale to your suggestions

VRP

Provide the Visual Proposition for the Brand

Provide in store creative solutions for the OTB generated using

Space and Zone plans

Visual Audit of existing Brand Concept

Identification and Application of Fixtures

Mood Board of Concept

Structure

TITLE PAGE – INCLUDING PLAIGIARISM STATEMENT

Introduction

What Brand

What Product group

What Customer

What Process

Market Opportunity and Planning Rationale

Trend information

Competitor offer and trading activity

Initial Category structure and phasing – Doc included

Structure

Planning Process & 4 KPIs

Option Plan ( discuss theory and metrics)

Demonstrate use and define KPIs

Trading Process & 4KPIs

WSSI ( discuss theory and metrics)

Demonstrate use and define KPIs

Structure

Trading Actions

Risk and opportunity shown through market observation

Include reforecasted WSSI – Doc included

Show new OTB

Generate new option plan/s and discuss – Doc included

Complete simple line detail OR demonstrate on simple range pyramid

RANGE PLAN LINE DETAILS

	Style description	Colour	Selling Price	Category	FABRIC	END USE	Risk	ROS	No. of stores	Weeks in store	Total unit buy	Total buy Selling Value
							LOW				0	0.0
							MEDIUM				0	0.0
							HIGH				0	0.0
											0	0.0
											0	0.0
											0	0.0
											0	0.0
											0	0.0
											0	0.0
											0	0.0
											0	0.0
											0	0.0
											0	0.0
											0	0.0
											0	0.0
											0	0.0
											0	0.0
	WEIGHTED AVERAGE AND SUB TOTALS		#DIV/0!								0	0.0
							option count	0

Structure

VRP

Space and Zone plans of selected spaces

Visual Audit of existing brand concept

Identification and application of Fixtures

Mood Board of Concept

Space and Zone Plans

With upbeat music, industrial settings – the use of metal and brickwork in store design and fixtures – and also the freshness of the air conditioning creating a feeling of being outside. It has been chosen to keep the brand identity when this collection shows in store and therefore not change too many elements. A palette of greys, white and the signature orange to complement the iconic shoe boxes will be incorporated in store design. Also textures such as brickwork or concrete will be used to give that contemporary industrial urban feel with possibly some metal mesh features of fixtures. Also the use of suggested walkways was favoured when visiting store and therefore this could be included but in cooler colours than shown in store audit, like grey

Visual Merchandising Mood Board

Structure

Conclusion

Initial market observations

Identify trading Issues

Your action to recovery

REFERENCES – alphabetically listed (only what has been cited in text)

BIBLIOGRAPHY – what you have read but not cited (optional)

APPENDICES

NB – Academic style – 3rd person please

Any Questions?