Reference no: EM13884690
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.
|
A company which is a producer of telephone systems
: A company which is a producer of telephone systems for small businesses has current sales of $ 43 million and variable operating costs of $ 27.95 million. The company expects to increase sales in the coming year by 15% while keeping fixed costs const..
|
|
Project x has following cash flows
: Q. Project X has following cash flows,
|
|
An acute care hospital with 300 beds
: Fairbanks Memorial Hospital, an acute care hospital with 300 beds and 160 staff physicians, is one of 75 hospitals owned and operated by Health Services of America, a for-profit, publicly owned company. Although there are two other acute care hospita..
|
|
When is an infant ready to start eating solid foods
: Why are solid foods not recommended for an infant during the first few months of life? When is an infant ready to start eating solid foods?
|
|
Calculate opening stock forward requirement and otb
: 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
|
|
Southwest physician, a medical group practice in oklahoma
: Southwest Physician, a medical group practice in Oklahoma City, is just being formed. It will need $2 million of total assets to generate $3 million in revenues. Furthermore, the group expects to have a total margin of 5 percent. The group is conside..
|
|
How the transactions below would affect the balance sheet
: General Hospital has a current ratio of 0.5. Which of the following actions would improve (increase) this ratio? (Hint: Create a simple balance sheet that has a current ratio of 0.5. Then, Judge how the transactions below would affect the balance she..
|
|
Identify the accounting concept that applies
: For each of these cases, identify the accounting concept that applies, state whether or not the treatment is in accord with the concept, and briefly explain why.
|
|
Kasus dari operating lisses dan financial lisses
: kasus dari operating lisses dan financial lisses
|