DEVELOP ASSORTMENT PLAN FOR AN ACTIVE WEAR RETAILER 1. The five categories of: shoes, tops, pants,...

 

Transcribed Image Text:

DEVELOP ASSORTMENT PLAN FOR AN ACTIVE WEAR RETAILER 1. The five categories of: shoes, tops, pants, jackets and skirts. 2. Total Sales for the department 1,572,920$ 3. Total planned purchases for the season (for the department) 1,620,100 $ ASSORTMENT DISTRIBUTION BY CLASSIFICATION Percentage Allocation Per Classification. classification % Shoes Tops Pants Jackets dresses Total seasonal sales class sales 40% $1,572,920.00 $ 629,168.00 20% $ 1,572,920.00 $ 314,584.00 15% $ 1,572,920.00 $ 235,938.00 15% $ 1,572,920.00 $ 235,938.00 10% $ 1,572,920.00 $ 157,292.00 $ 1,572,920.00 100% MONTHLY SALES DISTRIBUTION BY CLASSIFICATION Monthly Sales Distribution by Classification classification % Aug 16.02% Sep 15.89% Shoes Tops Pants 15% $ 40% $ 100,800.00 $ 20% $ 50,400.00 $ 37,800.00 $ 100,000.00 $ 50,000.00 $ 37,500.00 $ Oct 17.02% 107,068.00 $ 53,534.00 $ 40,150.50 $ Nov 18.02% Dec Jackets 15% $ 37,800.00 $ 37,500.00 $ 40,150.50 $ dresses Total 10% $ 100% $ 25,200.00 $ 25,000.00 $ 26,767.00 $ 252,000.00 $ 250,000.00 $ 267,670.00 $ 19.03% 113,400.00 $ 119,700.00 $ 56,700.00 $ 59,850.00 $ 42,525.00 $ 42,525.00 $ 28,350.00 $ 283,500.00 $ 44,887.50 $ Jan 14.02% 100.00% 88,200.00 $629,168.00 44,100.00 $314,584.00 33,075.00 $ 235,938.00 Total 44,887.50 $ 33,075.00 $ 235,938.00 29,925.00 $ 22,050.00 $ 157,292.00 299,250.00 $ 220,500.00 $1,572,920.00 Table 2 Monthly Sales Distribution by Classification MONTHLY DISTRIBUTION OF PLANNED PURCHASES BY CLASSIFICATION Monthly Distribution of Planned Purchases by Classification classification Shoes Aug Sep % 16.00% 16.00% 40% $103,686 $103,686 Oct Nov Dec Jan Total 17.00% 18.00% 19.00% 14.00% 100.00% $110,167 $116,647 $123,128 $90,726 $648,040 Tops 20% $51,843 $51,843 $55,083 $58,324 $61,564 $45,363 $324,020 Pants 15% $38,882 $38,882 $41,313 $43,743 $46,173 $34,022 $243,015 Jackets 15% $38,882 $38,882 $41,313 $43,743 $46,173 $34,022 $243,015 dresses 10% $25,922 Total 100% $259,216 $25,922 $259,216 $27,542 $29,162 $30,782 $22,681 $162,010 $275,417 $291,618 $307,819 $226,814 $1,620,100 DEVELOP ASSORTMENT PLAN FOR AN ACTIVE WEAR RETAILER 1. The five categories of: shoes, tops, pants, jackets and skirts. 2. Total Sales for the department 1,572,920$ 3. Total planned purchases for the season (for the department) 1,620,100 $ ASSORTMENT DISTRIBUTION BY CLASSIFICATION Percentage Allocation Per Classification. classification % Shoes Tops Pants Jackets dresses Total seasonal sales class sales 40% $1,572,920.00 $ 629,168.00 20% $ 1,572,920.00 $ 314,584.00 15% $ 1,572,920.00 $ 235,938.00 15% $ 1,572,920.00 $ 235,938.00 10% $ 1,572,920.00 $ 157,292.00 $ 1,572,920.00 100% MONTHLY SALES DISTRIBUTION BY CLASSIFICATION Monthly Sales Distribution by Classification classification % Aug 16.02% Sep 15.89% Shoes Tops Pants 15% $ 40% $ 100,800.00 $ 20% $ 50,400.00 $ 37,800.00 $ 100,000.00 $ 50,000.00 $ 37,500.00 $ Oct 17.02% 107,068.00 $ 53,534.00 $ 40,150.50 $ Nov 18.02% Dec Jackets 15% $ 37,800.00 $ 37,500.00 $ 40,150.50 $ dresses Total 10% $ 100% $ 25,200.00 $ 25,000.00 $ 26,767.00 $ 252,000.00 $ 250,000.00 $ 267,670.00 $ 19.03% 113,400.00 $ 119,700.00 $ 56,700.00 $ 59,850.00 $ 42,525.00 $ 42,525.00 $ 28,350.00 $ 283,500.00 $ 44,887.50 $ Jan 14.02% 100.00% 88,200.00 $629,168.00 44,100.00 $314,584.00 33,075.00 $ 235,938.00 Total 44,887.50 $ 33,075.00 $ 235,938.00 29,925.00 $ 22,050.00 $ 157,292.00 299,250.00 $ 220,500.00 $1,572,920.00 Table 2 Monthly Sales Distribution by Classification MONTHLY DISTRIBUTION OF PLANNED PURCHASES BY CLASSIFICATION Monthly Distribution of Planned Purchases by Classification classification Shoes Aug Sep % 16.00% 16.00% 40% $103,686 $103,686 Oct Nov Dec Jan Total 17.00% 18.00% 19.00% 14.00% 100.00% $110,167 $116,647 $123,128 $90,726 $648,040 Tops 20% $51,843 $51,843 $55,083 $58,324 $61,564 $45,363 $324,020 Pants 15% $38,882 $38,882 $41,313 $43,743 $46,173 $34,022 $243,015 Jackets 15% $38,882 $38,882 $41,313 $43,743 $46,173 $34,022 $243,015 dresses 10% $25,922 Total 100% $259,216 $25,922 $259,216 $27,542 $29,162 $30,782 $22,681 $162,010 $275,417 $291,618 $307,819 $226,814 $1,620,100