XYZ store has a merchandise budget of $120,000 for girl's tops for the spring selling period. You work as a merchandiser at the XYZ store and are planning to develop an assortment plan with a model stock of eight styles, six colors, and six sizes for girl's tops for the spring selling period. The average retail price for the tops is $30. According to the above information, please answer the following questions. Please attach this sheet with your answer sheet, if you have any 1. How many SKUs are in this assortment? Please show your work. 2. What would the assortment volume be given the merchandise budget? Please show your work I 3. Based on the assortment distribution for styles/colors/sizes (see Table 1). please develop a "volume-per- assortment factor" plan for these tops by filling in all the blank cells in Table 1 except for the crossed ones. 4. Based on Table 1, please develop a "volume per SKU" plan for style #4 (see Table 2). Please fill in all the blank cells in Table 2 5. What is the VSA of this assortment? Please show your work. Also, please interpret the number of VSA. Table 1. Plan for volume-per-assortment factor for girl's tops for spring. + Volume per style Volume per color Volume per size 2 13 4 5 6 7 8 Total Style % 5 10 10 15 20 5 15 20 100% Color% 20 15 15 30 10 10 600 Size % 5 25 40 20 5 5 100% 100% Table 2. Volume per SKU plan for style #4. Size #2 Size #14 Size #6 Total Color #1 #2 #3 #4 #5 #6 Total Size #1 6 4.5 4.5 9 3 3 30 Size #3 48 36 36 72 24 24 240 Size #5 6 4.5 4.5 9 3 3 30 600 XYZ store has a merchandise budget of $120,000 for girl's tops for the spring selling period. You work as a merchandiser at the XYZ store and are planning to develop an assortment plan with a model stock of eight styles, six colors, and six sizes for girl's tops for the spring selling period. The average retail price for the tops is $30. According to the above information, please answer the following questions. Please attach this sheet with your answer sheet, if you have any 1. How many SKUs are in this assortment? Please show your work. 2. What would the assortment volume be given the merchandise budget? Please show your work I 3. Based on the assortment distribution for styles/colors/sizes (see Table 1). please develop a "volume-per- assortment factor" plan for these tops by filling in all the blank cells in Table 1 except for the crossed ones. 4. Based on Table 1, please develop a "volume per SKU" plan for style #4 (see Table 2). Please fill in all the blank cells in Table 2 5. What is the VSA of this assortment? Please show your work. Also, please interpret the number of VSA. Table 1. Plan for volume-per-assortment factor for girl's tops for spring. + Volume per style Volume per color Volume per size 2 13 4 5 6 7 8 Total Style % 5 10 10 15 20 5 15 20 100% Color% 20 15 15 30 10 10 600 Size % 5 25 40 20 5 5 100% 100% Table 2. Volume per SKU plan for style #4. Size #2 Size #14 Size #6 Total Color #1 #2 #3 #4 #5 #6 Total Size #1 6 4.5 4.5 9 3 3 30 Size #3 48 36 36 72 24 24 240 Size #5 6 4.5 4.5 9 3 3 30 600
