Solve the following problem to find the maximum profit by creating a spreadsheet and using Solver.

Due to increased demand, a company is planning on making sanitizing wipes and hand sanitizer. The sanitizing wipes unit profit is $7.00 and the hand sanitizer unit profit is $10.00.

There are 2 factories available to make the products.

Factory 1 requires 10 minutes to make a unit of sanitizing wipes and 6 minutes to make a unit of hand sanitizer. It has 36 hours available.

Factory 2 requires 8 minutes to make a unit of sanitizing wipes and 14 minutes to make a unit of hand sanitizer. It has 48 hours available.

Factory 1 needs at least 10 employees to produce sanitizing wipes and 14 employees for hand sanitizer. The total minimum employees required is 42.

Factory 2 needs at least 12 employees to produce sanitizing wipes and 14 employees for hand sanitizer. 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 unit of sanitizing wipes and $1.75 off per unit of hand sanitizer. The total redemption of the coupons equals $500.

Answer rating: 100% (QA)

To tal no al awaiable houas for fachooy 36 hovos hand Gnitize aG minules T0 A ... View the full answer