Will W Inc. makes two doors (A and B). The final product, in both instances, requires machining
Question:
Will W Inc. makes two doors (A and B). The final product, in both instances, requires machining and painting. The company has loyal customers who order 260 units of product A. There are only 3,800 machine hours available for making both products. Products A requires 2 hours per unit and product B requires 4 hours per unit at the machine stage. Similarly, there are 3500 person-hours available for painting the products. The number of person-hours required for painting products A and B are 2 and 3 respectively. Product A contributes $2.20 to the company's profits while product B contributes $3.30 to the company’s profits.
Required:
1. State the objective function and the constraints related to the above conditions.
2. Graph the constraints, and determine the points that make the feasible region and the optimal number of A and B. Show all calculations.
3. Use Excel Solver to find the solution to this linear programming problem and provide a copy of the Excel solution with your answer.
Advanced Accounting
ISBN: 9780132568968
11th Edition
Authors: Floyd A. Beams, Joseph H. Anthony, Bruce Bettinghaus, Kenneth Smith