Guess Jeans: Merchandizing Plan
GUESS JEANS ASSIGNMENT DAVID DIEZ MAFED 2012
Sales (units) Mens Collection Kni ts Pa nts Swea ters Ja cket Shi rts Acces s ori es Total % sales
Initial % cumulativ Styles e 39% 75% 88% 94% 99% 100% 69 78 33 42 32 11 265 SKUs
Production Styles SKUs % on total Cancellation Cancelled Cancelled Units sold/ Units sold/ SKUs rate-SKUs styles SKUs style sku offered (%) 38% 26% 16% 9% 8% 3% 100% 15 24 7 19 11 3 79 133 264 57 142 100 22 718 27% 51% 27% 63% 58% 47% 43% 2294 2069 1605 718 762 509 1688 338 443 276 197 219 163 330
123,852 111,752 41,742 16,518 16,005 4,071 313,940
39% 36% 13% 5% 5% 1% 100% Sales
499 516 208 226 173 47 1669
54 54 26 23 21 8 186
366 252 151 84 73 25 951
Initial % cumulativ Styles e 44% 76% 82% 89% 94% 100% 100% 100% 89 87 36 48 48 40 7 3 358 SKUs
Production Styles SKUs % on total Cancellation Cancelled Cancelled Units sold/ Units sold/ SKUs rate-SKUs styles SKUs style sku offered (%) 42% 20% 9% 12% 8% 8% 1% 0% 100% 15 21 12 8 17 13 3 3 92 160 130 82 99 106 63 15 9 664 25% 36% 45% 41% 54% 40% 71% 100% 37% 3862 3134 1808 1064 1194 1351 80 2453 608 903 434 304 407 384 53 577
(units) Womens Collection Kni ts Pa nts Shi rts Swea ters Ja cket Ski rts Acces s ori es Dres s es Total
% sales
285,791 206,837 43,397 42,577 37,021 36,466 319 0 652,408
44% 32% 7% 7% 6% 6% 0% 0% 100%
630 359 182 239 197 158 21 9 1795
74 66 24 40 31 27 4 0 266
470 229 100 140 91 95 6 0 1131
TABLE 1: GUESS? JEANS SEASONAL SUMMARY
Total Sales %
Key Collection 90%
Delivery 1 % 4%
Delivery 2 % 6%
TABLE 2: WOMEN COLLECTION ANALYSIS
KEY COLLECTION No. Of Fabrics
Pants Skirts Jacket Shirts Dresses Knits Sweaters Accessories Total
DELIVERY 1 No. Of Fabrics 4 3 2 6 0 6 3 29% 24 25 Cancellatio Cancelled Cancelled n rate of styles SKUs SKUs (%) 5 8 2 2 3 4 1 19 24 21 16 9 37 15 141 42% 67% 78% 39% 100% 48% 38% 51% No. Of Fabrics 2 0 2 2 0 3 4 3 16
DELIVERY 2 Cancelled Cancelled styles SKUs 7 4 8 5 4 3 31 3 36
Sales (units) Mens Collection Kni ts Pa nts Swea ters Ja cket Shi rts Acces s ori es Total % sales
Initial % cumulativ Styles e 39% 75% 88% 94% 99% 100% 69 78 33 42 32 11 265 SKUs
Production Styles SKUs % on total Cancellation Cancelled Cancelled Units sold/ Units sold/ SKUs rate-SKUs styles SKUs style sku offered (%) 38% 26% 16% 9% 8% 3% 100% 15 24 7 19 11 3 79 133 264 57 142 100 22 718 27% 51% 27% 63% 58% 47% 43% 2294 2069 1605 718 762 509 1688 338 443 276 197 219 163 330
123,852 111,752 41,742 16,518 16,005 4,071 313,940
39% 36% 13% 5% 5% 1% 100% Sales
499 516 208 226 173 47 1669
54 54 26 23 21 8 186
366 252 151 84 73 25 951
Initial % cumulativ Styles e 44% 76% 82% 89% 94% 100% 100% 100% 89 87 36 48 48 40 7 3 358 SKUs
Production Styles SKUs % on total Cancellation Cancelled Cancelled Units sold/ Units sold/ SKUs rate-SKUs styles SKUs style sku offered (%) 42% 20% 9% 12% 8% 8% 1% 0% 100% 15 21 12 8 17 13 3 3 92 160 130 82 99 106 63 15 9 664 25% 36% 45% 41% 54% 40% 71% 100% 37% 3862 3134 1808 1064 1194 1351 80 2453 608 903 434 304 407 384 53 577
(units) Womens Collection Kni ts Pa nts Shi rts Swea ters Ja cket Ski rts Acces s ori es Dres s es Total
% sales
285,791 206,837 43,397 42,577 37,021 36,466 319 0 652,408
44% 32% 7% 7% 6% 6% 0% 0% 100%
630 359 182 239 197 158 21 9 1795
74 66 24 40 31 27 4 0 266
470 229 100 140 91 95 6 0 1131
TABLE 1: GUESS? JEANS SEASONAL SUMMARY
Total Sales %
Key Collection 90%
Delivery 1 % 4%
Delivery 2 % 6%
TABLE 2: WOMEN COLLECTION ANALYSIS
KEY COLLECTION No. Of Fabrics
Pants Skirts Jacket Shirts Dresses Knits Sweaters Accessories Total
DELIVERY 1 No. Of Fabrics 4 3 2 6 0 6 3 29% 24 25 Cancellatio Cancelled Cancelled n rate of styles SKUs SKUs (%) 5 8 2 2 3 4 1 19 24 21 16 9 37 15 141 42% 67% 78% 39% 100% 48% 38% 51% No. Of Fabrics 2 0 2 2 0 3 4 3 16
DELIVERY 2 Cancelled Cancelled styles SKUs 7 4 8 5 4 3 31 3 36