Company, which manufactures makes hockey sticks and chess sets. Each hockey stick yields an incremental profit of $5, and each chess set, $5.

A hockey stick requires 6 hours of processing at Machine Center A and two hours at Machine Center B.

A chess set requires 6 hours at Machine Center A, 8 hours at Machine Center B, and 2 hours at MachineCenter C.

Machine Center A has a maximum of 60 hours of available capacity per day, Machine Center B has 36 hours, and Machine Center C has 10 hours.

If the company wishes to maximize profit, how many hockey sticks and chess sets should be
produced per day?

Answer the following:

Formulate the linear programming model to determine the optimal solution

Use Excel solver to generate the sensitivity report and Interpret the sensitivity report.

Use Solvertable to investigate further the sensitivity due to change in profits (discuss)