Problem-

You are one of the merchandisers working for a supermarket clothing business. You are responsible for the Accessory Division. You are required to complete fully the following planning pack for AW 2015:

Departmental KPIs

Category KPI plans for the Ladies Accessory department

Sales phasing for Ladies Accessory department

Colour Planning for Bags

WSSI Ladies Accessory Department

Enter calculations where shown

Where there is choice between 2 figures being a calculation (i.e. £sales or %mix) generally show percentages as the calculation

All numbers should be formatted appropriately to the column heading.

In addition to the spreadsheets you are required to complete a written summary of your planning proposals. The summary must be NO more than 1000 words & should highlight significant changes & your plans for key parts of the business.

You should focus on minimizing risk whilst achieving growth

Your summary should use as evidence both LY information & your plans contained in your spreadsheets. Use figures as relevant, % mix, variance, cash sales, asp etc

You may make reference to external factors - trends, trading conditions however this should NOT be a focus of your summary.

Your summary should be in word - you do not need to comment on all spreadsheets - focus on what is important. You do not require an introduction or a conclusion but ensure you set the scene by referencing total KPIs.

The following are the KPIs that you must adhere to:

Total Divisional Sales for AW 2015 : 11,800
Divisional Markdown for AW 2015: 11.65%

FOR WSSI:

The highlighted cells are the ones that should be completed

Opening stock, forward requirement and OTB should only be calculated for the first 3 months as indicated by the highlights.

Additional information-

This problem related to Accounting and it discusses computing opening stock and forward requirement for 3 months.