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?