140,872 views
9 votes
9 votes
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.

User Derrick Mar
by
3.0k points

1 Answer

9 votes
9 votes

Answer:

Step-by-step explanation:

We are asked to compute and use the solver in Excel.

From the three images attached below, we will see clear pictures showing how the data sets are being computed in the Excel interface. The second indicates how the values are being inputted in the solver by using the Simplex LP method and lastly, the solution is being revealed in the third image.

Please, carefully go through the Excel screenshot files.

A company is making Sofas and Love Seats. The sofa’s profit is $1,000 and the love-example-1
A company is making Sofas and Love Seats. The sofa’s profit is $1,000 and the love-example-2
A company is making Sofas and Love Seats. The sofa’s profit is $1,000 and the love-example-3
User Gpeche
by
2.6k points