Excel wssi example

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.

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,,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