Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started