A company is making Sofas and Love Seats. The sofas profit is $1,000 and the love seats profit is $950.

There are 2 factories available to make the products.

Factory 1 requires 55 hours to make a sofa and 40 hours to make a love seat. It has 6,000 hours available.

Factory 2 requires 50 hours to make a sofa and 45 hours to make a love seat. It has 4,000 hours available.

Factory 1 needs at least 3 employees for a sofa and 2 employees for a love seat. The total minimum required is 80.

Factory 2 needs at least 2 employees for a sofa and 3 employees for a love seat. The total minimum required is 45.

The company is also willing to offer coupons to customers. The coupons can be redeemed for $25 off a sofa or $20 off a love seat. The total redemption of the coupons equals $1,800.

The maximum number of sofas that can be produced is 75.

Please use Solver on Excel and provide steps and explanations.