Bob makes blouses and he's good at it$.$ Bob would rather make profit and be good at that. With that in mind, Bob wants you to find the best use of his available resources in order to maximize his profits. Material requirements, additional labor costs, and selling prices for each inventory item are included in the table to the right. Additional considerations are listed below.

Bob has a the following resources available to him: $45000$ Wool, $28000$ Acetate, $9000$ Cashmere, $18000$ Silk, $30000$ Rayon, $20000$ Velvet, $30000$ Cotton. Extra material can be saved and used in future months at no additional cost.

Bob also has some ideas regarding demand and knows he wants to produce subject to the following constraints.

At least:

$4200$ Itchy Pants

$3000$ Wool Blazers

$2800$ Tailored Skirts

No more than:

$5500$ Velvet Pants

$6000$ Velvet Vests

$4000$ Cashmere Sweaters

$12000$ Silk Shirts

$15000$ Silk Skirts

Your profit calculations should consider $$3,000,000$ in fixed expenses. Develop a spreadsheet model and solve for the optimal solution to maximize profit. Then adjust and use your model to answer the questions on the next sheet.