Shorts Assortment

Page 1

Tribe

ASSORTMENTS:Shorts

August NYC

Chicago

Miami

TTL

total cost

total retail

# of strs color Dark Rinse Light Wash Gray Wash

1

1

1

3

COST RETAIL $ 18.85 $ 58.00 $ 18.85 $ 58.00 $ 18.85 $ 58.00

MU% 68% 68% 68%

300 100 80

100 70 60

200 100 300

600 270 440 total

$ 11,310.00 $ 5,089.50 $ 8,294.00 $ 24,693.50

$ 34,800.00 $ 15,660.00 $ 25,520.00 $ 75,980.00

Key Items High Waist Short SKU:4002 3 colors 3sizes

White Black Gray

$ 16.00 $ 48.00 $ 16.00 $ 48.00 $ 16.00 $ 48.00

67% 67% 67%

100 200 80

70 80 50

300 50 70

470 330 200 total

$ 7,520.00 $ 5,280.00 $ 3,200.00 $ 16,000.00

$ 22,560.00 $ 15,840.00 $ 9,600.00 $ 48,000.00

Fashion Midi Short SKU:4003 2 colors 3 sizes

Vintage blue Black

68% 68%

200 90

70 40

200 0

470 130

$ 6,110.00 $ 1,690.00 $ -­‐ $ 7,800.00

$ 18,800.00 $ 5,200.00 $ -­‐ $ 24,000.00

style Replinishment Denim Plain Short SKU:4001 3 Colors 3 sizes

$13.00 $13.00

$ 40.00 $ 40.00

total Trend Broadie Trim Short SKU:4004 2 colors 3 sizes

Orange Red

$ 15.00 $ 40.00 $ 15.00 $ 40.00

63% 63%

50 20

15 10

90 70

155 100

$ 2,325.00 $ 6,200.00 $ 1,500.00 $ 4,000.00 $ 3,825.00 $ 10,200.00

Units by class

1220

565

1380

grand total mu%

$ 52,318.50 $ 158,180.00 67%

NYC

Chicago

Miami

TTL

BUILDING ASSORTMENTS BASED ON PYRMIDS September

total cost

total retail

# of stores Color Dark Light Black

1

1

1

3

COST RETAIL $ 16.00 $ 48.00 $ 16.00 $ 48.00 $ 16.00 $ 48.00

MU% 67% 67% 67%

100 60 60

50 70 40

80 300 0

230 430 100

$ 3,680.00 $ 6,880.00 $ 1,600.00 $ 12,160.00

$ 11,040.00 $ 20,640.00 $ 4,800.00 $ 36,480.00

Key Item Cotton Short SKU:4006 3 colors 3 sizes

Navy Black Hazy Brown

$ 18.00 $ 58.00 $ 18.00 $ 58.00 $ 18.00 $ 58.00

69% 69% 69%

60 100 50

40 60 30

40 60 100

140 220 180

$ 2,520.00 $ 3,960.00 $ 3,240.00 $ 9,720.00

$ 8,120.00 $ 12,760.00 $ 10,440.00 $ 31,320.00

Fashion Paperbag short SKU:4007 1 color 3 sizes

Hazy Brown

$ 22.85 $ 68.00

66%

100

50

40

190

$ 4,341.50 $ 12,920.00

Style Replinishment Denim Hotpants SKU:4005 3 Colors 3 sizes

$ 4,341.50 $ 12,920.00 Trend Scalloped hem trim shorts SKU:4008 1 color 3 sizes

October

Mint

$ 12.00 $ 38.00

68%

80

40

100

220

Units by class

610

380

720

mu%

NYC

Chicago

Miami

TTL

$ 2,640.00 $ 8,360.00 $ -­‐ $ -­‐

$ 26,221.50 $ 80,720.00 68%

total cost

total retail


# of stores Color Gray Black Hazy Brown

1

1

1

COST RETAIL $ 18.00 $ 58.00 $ 18.00 $ 58.00 $ 18.00 $ 58.00

MU% 69% 69% 69%

90 150 200

70 50 60

80 0 200

3 0.0% 240 200 460

Key Item Men's Waistband Short SKU:4010 3 colors 3 sizes

Rust Wine Black

$ 15.00 $ 45.00 $ 15.00 $ 45.00 $ 15.00 $ 45.00

67% 67% 67%

80 100 200

70 60 90

50 0 50

Fashion Pleat Front Short SKU:4011 3 colors 3 sizes

Hazy Brown Black Nude

$ 16.00 $ 48.00 $ 16.00 $ 48.00 $ 16.00 $ 48.00

67% 67% 67%

30 50 20

10 10 10

Black Blue

$ 15.00 $ 45.00 $ 15.00 $ 45.00

67% 67%

20 20

10 10

Style Replinishment Belted Culotte SKU:4009 3 colors 3 sizes

Trend Scallop Hem Short SKU:4012 2 colors 3 sizes

$ 4,320.00 $ 3,600.00 $ 8,280.00 $ 16,200.00

$ 13,920.00 $ 11,600.00 $ 26,680.00 $ 52,200.00

200 160 290

$ 3,000.00 $ 2,400.00 $ 4,350.00 $ 9,750.00

$ 9,000.00 $ 7,200.00 $ 13,050.00 $ 29,250.00

0 0 20

40 60 50

$ 640.00 $ 960.00 $ 800.00 $ 2,400.00

$ 1,920.00 $ 2,880.00 $ 2,400.00 $ 7,200.00

0 30

30 30

$ 450.00 $ 1,350.00 $ 450.00 $ 1,350.00 $ 900.00 $ 2,700.00

Units by class

November

960

450

430

mu%

NYC

Chicago

Miami

TTL

# of stores Color Hazy Brown Black Gray

1

1

1

Style Replinishment Pleated Short SKU:4013 3 colors 3 sizes

COST RETAIL $ 30.00 $ 78.00 $ 30.00 $ 78.00 $ 30.00 $ 78.00

MU% 62% 62% 62%

50 20 10

30 40 20

60 0 90

3 0.0% 140 60 30

Key Item Twill Short SKU:4014 2 colors 3 sizes

Black Hazy Brown

$ 20.00 $ 58.00 $ 20.00 $ 58.00

66% 66%

90 70

50 40

0 40

140 110

$ 29,250.00 $ 91,350.00 68% total cost

total retail

$ 4,200.00 $ 1,800.00 $ 900.00 $ 6,900.00

$ 10,920.00 $ 4,680.00 $ 2,340.00 $ 17,940.00

$ 2,800.00 $ 8,120.00 $ 2,200.00 $ 6,380.00 $ 5,000.00 $ 14,500.00

Fashion Wrap Front Short SKU:4015 3 colors 3 sizes

Trend Printed Short SKU:4016 1 color 3 sizes

Navy Black Hazy Brown

$ 19.00 $ 55.00 $ 19.00 $ 55.00 $ 19.00 $ 55.00

65% 65% 65%

40 50 20

10 15 10

0 0 20

50 65 50

$ 950.00 $ 1,235.00 $ 950.00 $ 3,135.00

$ 2,750.00 $ 3,575.00 $ 2,750.00 $ 9,075.00

Polka Dot

$ 15.00 $ 48.00

69%

20

10

15

45

$ 675.00 $ 2,160.00

$ 675.00 $ 2,160.00 Units by class

December

Style

# of stores Color

COST

RETAIL

MU%

370

225

225

mu%

NYC

Chicago

Miami

TTL

1

1

1

3 0.0%

$ 15,710.00 $ 43,675.00 64%

total cost

total retail


Replinishment Wool Plain Short SKU:4017 3 colors 3 sizes

Black Gray Brown

$ 30.00 $ 85.00 $ 30.00 $ 85.00 $ 30.00 $ 85.00

65% 65% 65%

70 50 20

50 30 15

0 0 0

120 80 35

$ 3,600.00 $ 2,400.00 $ 1,050.00 $ 7,050.00

$ 10,200.00 $ 6,800.00 $ 2,975.00 $ 19,975.00

Key Item Twill High Waist Short SKU:4018 2 colors 3 sizes

Black Gray

$ 24.00 $ 68.00 $ 24.00 $ 68.00

65% 65%

40 20

30 20

20 30

90 70

$ 2,160.00 $ 6,120.00 $ 1,680.00 $ 4,760.00 $ 3,840.00 $ 10,880.00

Fashion Lace Trim Short SKU:4019 2 colors 3 sizes

Ivory Black

$ 18.00 $ 50.00 $ 18.00 $ 50.00

64% 64%

40 50

15 20

50 0

105 70

$ 1,890.00 $ 5,250.00 $ 1,260.00 $ 3,500.00 $ 3,150.00 $ 8,750.00

Trend Folk Short SKU:4020 1 color 3 sizes

Black

$ 15.00 $ 49.00

69%

40

20

50

110

$ 1,650.00 $ 5,390.00

$ 1,650.00 $ 5,390.00 Units by class

January

Style Replinishment Twill Plain Short SKU:4021 3 colors 3 sizes

# of stores Color Black Navy

COST RETAIL $ 20.00 $ 60.00 $ 20.00 $ 60.00

MU% 67% 67%

330

200

150

mu%

NYC

Chicago

Miami

TTL

1

1

1

15 10

10 8

0 0

3 0.0% 25 18

$ 5,070.00 $ 15,010.00 66%

total cost

total retail

$ 500.00 $ 1,500.00 $ 360.00 $ 1,080.00


Key Item Cotton Pleated Short SKU 1 color 3 sizes

Gray

$ 20.00 $ 60.00

67%

15

8

0

23

$ 460.00 $ 1,380.00 $ 1,320.00 $ 3,960.00

Black

$ 15.00 $ 48.00

69%

15

10

15

40

$ 600.00 $ 1,920.00 $ 1,050.00 $ 3,360.00

Fashion High Waist Paperbag

Hazy Brown

$ 16.85 $ 48.00

65%

10

10

10

30

$ 505.50 $ 1,440.00


SKU:4022 3 colors 3 sizes

Trend Suiting Tap Short SKU:4023 2 colors 3 sizes

Style Replinishment

Gray

Black

$ 16.85 $ 48.00 $ 16.85 $ 48.00

65% 65%

15 10

10 5

0 0

25 15

$ 421.25 $ 1,200.00 $ 252.75 $ 720.00 $ 1,179.50 $ 3,360.00

Gray Black

$ 18.85 $ 58.00 $ 18.85 $ 58.00

68% 68% #DIV/0!

10 10

5 5

0 0

15 15

$ 282.75 $ 870.00 $ 282.75 $ 870.00 $ 565.50 $ 1,740.00

Units by class

120

71

45

mu%

Color

COST

RETAIL

MU%

$ 4,680.50 $ 14,160.00 67%

0.0% $ 67,003.50 $ 202,575.00

key item

$ 45,360.00 $ 137,310.00

fashion

$ 27,384.50 $ 83,705.00

trend

$ 10,255.50 $ 30,550.00 $ -­‐ $ -­‐ $ 150,003.50 $ 454,140.00


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.