A company is making Sofas and Love Seats. The sofa’s 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 sofa’s that can be produced is 75.Please use Solver on Excel and provide steps and explanations.