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

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

Planning Exercise

Sales Planning Exercise
•Company Growth 10%
•Stonewash skinny jeans are a major trend for next season; markdown TY driven by product failure on a dark wash
•Growth in skinny likely to take some sales from straight jeans
•More opportunity in bootleg/wideleg with growth on wideleg
•Boyfriend jeans have had a good couple of years but there is more competition coming into the market
•Embellished had good sales growth but with high markdown and increase in cover; trend forecasts suggests that new category, distressed finish, will split sales between Embellished/Distressed
Next Year Actual Sales Markdown Stock
Target Sales Value Mix Var Value % to Sales Cover
Category Value Mix Var TY% TY LY TY LY TY:LY% TY LY TY LY TY LY
Straight 230 220 23.7% 25.9% 4.50% 16 12 7.00% 5.50% 9 7
Bootleg /Wideleg 340 300 35.1% 35.3% 13.30% 16 30 4.70% 10.00% 7 8
Skinny 180 150 18.6% 17.6% 20.00% 19 12 10.60% 8.00% 7 7.5
Boy friend 100 80 10.3% 9.4% 25.00% 7 10 7.00% 12.50% 8 8.5
Embellished 120 100 12.4% 11.8% 20.00% 19 17 15.80% 17.00% 12 11.5
Distressed Finish 0 0 0.0% 0.0% 0.00% 0 0 0.00% 0.00% 0 0
Total 1070 100% 10.3% 970 850 100.0% 100.0% 14.10% 77 81 7.90% 9.50% 8.2 8.2

Planning Answer

Sales Planning Exercise: Suggested Answer
•Company Growth 10%
•Stonewash skinny jeans are a major trend for next season; markdown TY driven by product failure on a dark wash
•Growth in skinny likely to take some sales from straight jeans
•More opportunity in bootleg/wideleg with growth on wideleg
•Boyfriend jeans have had a good couple of years but there is more competition coming into the market
•Embellished had good sales growth but with high markdown and increase in cover; trend forecasts suggests that new category, distessed finish, will split sales between Embellished/Distressed
Next Year Actual Sales Markdown Stock
Target Sales Value Mix Var Value % to Sales Cover
Category Value Mix Var TY% TY LY TY LY TY:LY% TY LY TY LY TY LY
Straight 220 21% -4.3% 230 220 23.7% 25.9% 4.50% 16 12 7.00% 5.50% 9 7
Bootleg /Wideleg 390 36% 14.7% 340 300 35.1% 35.3% 13.30% 16 30 4.70% 10.00% 7 8
Skinny 220 21% 22.2% 180 150 18.6% 17.6% 20.00% 19 12 10.60% 8.00% 7 7.5
Boy friend 110 10% 10.0% 100 80 10.3% 9.4% 25.00% 7 10 7.00% 12.50% 8 8.5
Embellished 65 6% -45.8% 120 100 12.4% 11.8% 20.00% 19 17 15.80% 17.00% 12 11.5
Distressed Finish 65 6% 0.0% 0 0 0.0% 0.0% 0.00% 0 0 0.00% 0.00% 0 0
Total 1070 100% 10.3% 970 850 100.0% 100.0% 14.10% 77 81 7.90% 9.50% 8.2 8.2

Phasing Exercise

Sales Phasing Exercise
Instructions
1) Only key in where the cell is yellow
2) Follow the step as explained at the head of each column
1,070.0
Working Columns Sales £K Weekly Mix Markdowns Calendar
Week Date Monthly Mix Calculated Monthly Sales Variance 2017 Weekly Mix Calculated Weekly Sales Variance 2017 2018 Var 2017% 2017 2016 2018 2017 2016 2017 2016 2018 2017 2016
1 7-Jan-18 0.0 -100.0% -100.0% 22.7 20.4 0.0% 2.3% 2.4% 0.0
2 14-Jan-18 0.0 -100.0% -100.0% 27.2 24.8 0.0% 2.8% 2.9% 0.0
3 21-Jan-18 0.0 -100.0% -100.0% 35.2 23.2 0.0% 3.6% 2.7% 0.0 Chinese NY 2017 Jan 28th-Feb 2nd
4 28-Jan-18 0.0 -100.0% -100.0% 40.8 25.9 0.0% 4.2% 3.0% 0.0
Jan 0.0 -100.0% 0.0% 0.0 -100.0% 0.0 -100.0% 125.9 94.3 0.0% 13.0% 11.1% 0.0 0.0
5 4-Feb-18 0.0 -100.0% -100.0% 37.6 30.3 0.0% 3.9% 3.6% 0.0 Chinese NY 2016 Feb 8th-22nd
6 11-Feb-18 0.0 -100.0% -100.0% 32.1 36.4 0.0% 3.3% 4.3% 0.0
7 18-Feb-18 0.0 -100.0% -100.0% 35.4 37.6 0.0% 3.6% 4.4% 0.0 Chinese NY 2018 Feb 12th-16th
8 25-Feb-18 0.0 -100.0% -100.0% 45.3 42.6 0.0% 4.7% 5.0% 11.7 10.5 Clearance Event Clearance Event
Feb 0.0 -100.0% 0.0% 0.0 -100.0% 0.0 -100.0% 150.4 146.9 0.0% 15.5% 17.3% 11.7 10.5
9 4-Mar-18 0.0 -100.0% -100.0% 40.8 38.6 0.0% 4.2% 4.5% 0.0
10 11-Mar-18 0.0 -100.0% -100.0% 38.1 32.9 0.0% 3.9% 3.9% 0.0
11 18-Mar-18 0.0 -100.0% -100.0% 37.6 38.3 0.0% 3.9% 4.5% 4.1 Easter Offers
12 25-Mar-18 0.0 -100.0% -100.0% 38.7 40.2 0.0% 4.0% 4.7% 4.5 4.4 Easter Offers Easter Sunday March 27th 2016
13 1-Apr-18 0.0 -100.0% -100.0% 40.2 33.6 0.0% 4.1% 4.0% 0.0 5.1 Easter Sunday April 1st 2018
Mar 0.0 -100.0% 0.0% 0.0 -100.0% 0.0 -100.0% 195.4 183.6 0.0% 20.1% 21.6% 8.6 9.5
Cum 0.0% 0.0 -100.0% 0.0% 0.0 -100.0% 0.0 -100.0% 471.7 424.8 0.0% 48.6% 50.0% 20.3 20.0
14 8-Apr-18 0.0 -100.0% -100.0% 44.4 34.0 0.0% 4.6% 4.0% 0.0 Easter Offers
15 15-Apr-18 0.0 -100.0% -100.0% 47.1 34.9 0.0% 4.9% 4.1% 0.0 Easter Sunday April 16th 2017
16 22-Apr-18 0.0 -100.0% -100.0% 40.2 35.7 0.0% 4.1% 4.2% 0.0
17 29-Apr-18 0.0 -100.0% -100.0% 38.1 33.2 0.0% 3.9% 3.9% 0.0
Apr 0.0 -100.0% 0.0% 0.0 -100.0% 0.0 -100.0% 169.8 137.8 0.0% 17.5% 16.2% 0.0 0.0
18 6-May-18 0.0 -100.0% -100.0% 33.5 28.9 0.0% 3.5% 3.4% 0.0
19 13-May-18 0.0 -100.0% -100.0% 30.8 24.7 0.0% 3.2% 2.9% 0.0
20 20-May-18 0.0 -100.0% -100.0% 48.6 42.5 0.0% 5.0% 5.0% 30.0 27.8 Planned Sale Sale Sale
21 27-May-18 0.0 -100.0% -100.0% 43.5 38.3 0.0% 4.5% 4.5% 29.9 24.3 Planned Sale Sale Sale
May 0.0 -100.0% 0.0% 0.0 -100.0% 0.0 -100.0% 156.4 134.4 0.0% 16.1% 15.8% 59.9 52.1
22 3-Jun-18 0.0 -100.0% -100.0% 41.4 37.4 0.0% 4.3% 4.4% 38.4 32.0 Planned Sale Sale Sale
23 10-Jun-18 0.0 -100.0% -100.0% 40.0 33.2 0.0% 4.1% 3.9% 50.1 46.9 Planned Sale Sale Sale
24 17-Jun-18 0.0 -100.0% -100.0% 46.2 39.1 0.0% 4.8% 4.6% 32.9 33.3 Father's Day 17th June 2018 Father's Day 18th June 2017 Father's Day 19th June 2016
25 24-Jun-18 0.0 -100.0% -100.0% 27.2 23.8 0.0% 2.8% 2.8% 0.0
26 1-Jul-18 0.0 -100.0% -100.0% 17.3 19.5 0.0% 1.8% 2.3% 0.0 Heavy Rain
Jun 0.0 -100.0% 0.0% 0.0 -100.0% 0.0 -100.0% 172.1 153.0 0.0% 17.7% 18.0% 121.4 112.2
Cum 0.0% 0.0 -100.0% 0.0% 0.0 -100.0% 0.0 -100.0% 970.0 850.0 0.0% 100.0% 100.0% 201.6 184.3

1) Review the monthly mix for 2017 and 2016 (in bold red text) and key in a suggested monthly figure for 2018 in the column below (yellow cells) 2) Check the monthly mixes add up to 100% 3) Review the monthly calculated sales value (column D) and the variance to 2017 (column E)

4) When you are happy with the monthly sales, key in a suggested weekly mix 5) Check that the calculated month total comes back to your keyed in monthly total (column C) and to 100% overal 6) Review the weekly calculated sales value (column G) and the variance to 2017 (column H)

7) Usually, sales targets are dones as whole numbers, with no decimal places so, when you are fairly happy with your weekly sales, key in the numbers rounded to whole numbers −For example, if the calculated fiugure is 41.8, key in 42 8) Check that the total adds up to 1070

Phasing Ex 2

Monthly Phasing Sheet
Cat # Description Jan % Feb % Mar % Apr % May % Jun % Total %
1 Straight Monthly Sales/Mix 32 14.5% 40 18.2% 47 21.4% 33 15.0% 31 14.1% 37 16.8% 220 100.0%
Cat Mix of Total 25.0% 21.4% 19.8% 18.9% 18.6% 21.0% 20.6%
2 Bootleg/ Wideleg Monthly Sales/Mix 43 11.0% 65 16.7% 85 21.8% 64 16.4% 63 16.2% 70 17.9% 390 100.0%
Cat Mix of Total 33.6% 34.8% 35.9% 36.6% 37.7% 39.8% 36.4%
3 Skinny Monthly Sales/Mix 30 13.6% 48 21.8% 48 21.8% 35 15.9% 31 14.1% 28 12.7% 220 100.0%
Cat Mix of Total 23.4% 25.7% 20.3% 20.0% 18.6% 15.9% 20.6%
4 Boyfriend Monthly Sales/Mix 11 10.0% 17 15.5% 25 22.7% 18 16.4% 20 18.2% 19 17.3% 110 100.0%
Cat Mix of Total 8.6% 9.1% 10.5% 10.3% 12.0% 10.8% 10.3%
5 Embellished Monthly Sales/Mix 5 7.7% 9 13.8% 17 26.2% 13 20.0% 10 15.4% 11 16.9% 65 100.0%
Cat Mix of Total 3.9% 4.8% 7.2% 7.4% 6.0% 6.3% 6.1%
6 Distressed Monthly Sales/Mix 7 10.8% 8 12.3% 15 23.1% 12 18.5% 12 18.5% 11 16.9% 65 100.0%
Cat Mix of Total 5.5% 4.3% 6.3% 6.9% 7.2% 6.3% 6.1%
Bottom Up Total Monthly Sales/Mix 128 12.0% 187 17.5% 237 22.1% 175 16.4% 167 15.6% 176 16.4% 1070 100.0%
Cat Mix of Total 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%
Top Down Total Monthly Sales/Mix 119 11.1% 179 16.7% 234 21.9% 174 16.3% 171 16.0% 193 18.0% 1070 100.0%