Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 320 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 4000 person-hours available for painting the products. The number of person-hours required for painting products Aand B are 3 and 4 respectively. ProductA contributes 82.50 to the company's profits while product B contributes $3.50 to the companys profits. Required: :1. State the objective function and the constraints related to the above conditions. (4 marks] 3. Graph the constraints. determine the points that make the feasible region and the optimal number ofA and B. Show all calculations. (5 marks) b. Use Excel Solver to find the solution to this linear programming problem and provide a copy of the Excel solution with your answer. (1 mark)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started