1. Solve the following problem to find the maximum profit by creating a spreadsheet and using Solver. 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 sota 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, Then, run a sensitivity report. In the comments section of your submission, please list the allowable range for the profit of sofas and the profit of love seats, Case Review (answer on a Word document) Company guidelines state that a project should not move forward if profit is less than $125,000 Based on the results of your excel calculations, should you go forward with this project? a. Not going forward with the project means that 15 employees will be laid off for up to 6 months. The cost of unemployment, rehiring or hiring and training new replacement employees is app tely $7.000 per position. Does this information change your decision to move forward with this project? b. What financial and ethical considerations should be made? 1. Solve the following problem to find the maximum profit by creating a spreadsheet and using Solver. 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 sota 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, Then, run a sensitivity report. In the comments section of your submission, please list the allowable range for the profit of sofas and the profit of love seats, Case Review (answer on a Word document) Company guidelines state that a project should not move forward if profit is less than $125,000 Based on the results of your excel calculations, should you go forward with this project? a. Not going forward with the project means that 15 employees will be laid off for up to 6 months. The cost of unemployment, rehiring or hiring and training new replacement employees is app tely $7.000 per position. Does this information change your decision to move forward with this project? b. What financial and ethical considerations should be made
