1. Use Excel and Solver to find the maximum profit.

An office supply store is going to contract a manufacturer to make generic pens and pencils to sell in their store. The profit for each box of pens is $11.00 and the profit for each box of pencils is $9.00.

The products are made in 2 factories.

Factory 1 needs 10 minutes to make the number of pens that go into 1 box and 6 minutes to make the number of pencils that go into 1 box. It has 36 hours available.

The products then move to factory 2 to be boxed.

Factory 2 needs 1 minutes to finish a box of pens and 1.5 minutes to finish a box of pencils. It has 48 hours available.

Factory 1 needs at least 10 employees to produce pens and 14 employees for pencils. The total minimum employees required is 42.

Factory 2 needs at least 12 employees to produce pens and 13 employees for pencils. The total minimum employees required is 65.

The company is also willing to offer coupons to customers. The coupons can be redeemed for $2 off per box of pens and $1.75 off per box of pencils. The total redemption of the coupons equals $250.

2. Run a sensitivity report through Solver.