1. Solve the following problem by creating a spreadsheet to find the maximum profit.

A company is making Rugs and Coffee Tables. The profits for rugs is $1,500 and the coffee tables profit is $350.

There are 2 factories available to make the products.

Factory 1 requires 55 hours to make a rug and 10 hours to make a coffee table. It has 3,000 hours available.

Factory 2 requires 60 hours to make a rug and 7 hours to make a coffee table. It has 5,000 hours available.

Factory 1 needs at least 2 employees for a rug and 1 employees for a coffee table. The total minimum required is 12.

Factory 2 needs at least 1 employees for a rug and 1 employees for a coffee table. The total minimum required is 10.

The company is also willing to offer coupons to customers. The coupons can be redeemed for $50 off a rug or $10 off a coffee table. The total redemption of the coupons equals $1,000.00

The maximum number of rugs that can be produced is 30.

Use Solver on an Excel spreadsheet.