Question
Input formulas in the appropriate cells that will calculate Units Needed, Number of each size and color needed, Total Number of each size needed, and
Input formulas in the appropriate cells that will calculate Units Needed, Number of each size and color needed, Total Number of each size needed, and Total Number of each color needed.
1. You have a $1,000 budget to purchase 1sweatshirts for your store. All the sweatshirts will be purchased from Hanes for $10 each. The distribution of sizes will be as follows:
Small 20%
Medium 32%
Large 28%
X-Large 20%
Four colors will be represented in the assortment as follows:
Red 25%
Blue 25%
White 25%
Black 25%
2. Recalculate the assortment plan for the information presented in Problem 1 if the distribution in sizes were changed as follows:
Small 20%
Medium 32%
Large 32%
X-Large 16%
3. Recalculate the assortment plan for the information presented in Problem 1 if the distribution in colors were changed as follows:
Red 20%
Blue 20%
White 30%
Black 30%
4. Recalculate the assortment plan for the information presented in Problem 1 if the distribution in colors were changed as follows:
Red 50%
Blue 20%
White 30%
Black 0%
5. Recalculate the assortment plan for the information presented in Problem 1 if the distribution in sizes were changed as follows:
Small 28%
Medium 32%
Large 28%
X-Large 12%
Can you please show formula(s) needed to solve?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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