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

Total 50 points -with 25 points for each Style assortment. You are to submit an Excel file. Your Excel submission should be fully formulated to receive credit.

Hint: Before submit your assignment, you should test your spreadsheet by changing your OTB amount to a different amount (for example, to $90,000 instead of $80,000), or any of the %s for style, color and size, the unit assortment should change AUTOMATICALLY. If you have to recalculate the units for each style and size, then your paper is not properly and or fully formulated.

Below is the historical information that you will use to plan the unit assortment plan:

*Cost information: Hooded style each costs $9; Zip style each costs $8.

*Style selling information: 38% of the sweatshirts sold are hooded styles, and the remainder are zip 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 18% of the total sales, Medium is 30% of the sales, Large is 28% of the sales and X-Large is 24% of the sales.

Help would be much appreciated, thanks!