You are the buyer at a local apparel store. You have $68,000 budget (OTB) to purchase sweatshirts for Fall season. Build a sweatshirt unit assortment using Microsoft Excel based on the following historical information. Basically, you are to determine how many units to purchase by style/color/size.

Historical information to based on your assortment plan on:

*Cost information: hooded style each costs $10, non-hooded style each costs $8.

*Style selling information: 38% of the sweatshirts sold are hooded styles, and the remainder are non hooded styles.

*Color selling information: Sweater shirts comes in four colors with 35% sales from color gray, 20% from color black, 30% from color red, and 15% from color white.

*Size selling information: Small represents 20% of the total sales, Medium is 40% of the sales, Large is 20% of the sales and X-Large is 20% of the sales.