2.26 fashion management

duty13
rangebuildmixes1.xlsx

Sheet2

Example of menswear range build mixes
TOTAL BUDGET FOR SS23 = £1.7m
Quantity Selling Price Total Sales
SS22 qty SS23 qty SS22 retail price SS23 retail price SS22 Total sales SS23 Total sales
Crew neck tees 80,000 90,000 [$£]4.00 [$£]4.50 [$£]320,000 [$£]405,000
Polo shirts 210,000 220,000 [$£]5.00 [$£]5.00 [$£]1,050,000 [$£]1,100,000
V necks 50,000 45,000 [$£]4.00 [$£]4.00 [$£]200,000 [$£]180,000
Printed 10,000 [$£]4.50 [$£]4.50 [$£]0 [$£]45,000
TOTAL 340,000 365,000 [$£]1,570,000 [$£]1,730,000

SS22 qty and SS23 qty

90000 220000 45000 10000 80000 210000 50000

image1.png