Cool Denim Company produces two items called Boot Jeans and Skinny Jackets. A unit of Boot Jeans requires 8 yards of denim and 2 pounds of R22 dye. A unit of Skinny Jackets requires 15 yards of denim and 3 pounds of R22 dye. The amount of cutting machine time needed on a unit of Boot Jeans is 1.5 hours, while the amount of cutting machine time needed on a unit of Skinny Jackets is 1 hour. The assembly time needed by a unit of Boot Jeans is 2.5 hours while the assembly time needed by a unit of Skinny Jackets is 1.75 hours. The amount of yards of denim available per production period is 280 yards. The company has secured 66 pounds of the special R22 dye for the production period. The company has three cutting machines which yield an effective combined time of 47 hours per production period. The total amount of assembly time available to the company per production period equals 130 hours. The company has received and accepted pre-production commitments of at least 5 units of Boot Jeans for the upcoming production period, and wants to keep production of Skinny Jackets to a maximum of 12 units in order not to overflow the market for the following period. The company cost accountants have determined that a single unit of Boot Jeans contributes $15 to profits, while a single unit of Skinny Jackets contributes $22 to profits. The company’s objective is to maximize profit. If you are the production manager, how many units of Boot Jeans and Skinny Jackets should you produce so that the profit is maximized?

What are the decision variables (specify the units)?

What is the objective function?

Are there any redundant constraint(s)? Which one(s), if any?

Identify the corner points of the feasibility region.

What is the optimal production mix?

What is the optimal profit level?

If the manager is able to secure an additional pound of special R22 dye for $5/lb, should it be bought? Why?

Using Excel Please show all work