Question: Can you include the excel sheet work and formulas please! Thank you Problem 3: (30) A contractor wishes to maximize his profits and is faced

Can you include the excel sheet work and formulas please! Thank you
Problem 3: (30) A contractor wishes to maximize his profits and is faced with assigning three projects amongst four (4) different subcontractors. The profit/person (p) between the subcontractors and the projects, and the available/required staffing are shown below. Projects/ ($/p) Available Subcontractor ABC (p) 1 50 35 15 3 2 25 40 20 3 35 30 50 5 4 25 25 25 2 Required (p) 5 5 2 N Find: a) Formulate the above problem as a LP optimization model with Network Diagram, Objectives, Decision Variables, Constraints and solve using Excel Solver. (20) b) Optimal assignments of subcontractor and persons (p) to each project to maximize total profit using Excel Solver. (10) Problem 3: (30) A contractor wishes to maximize his profits and is faced with assigning three projects amongst four (4) different subcontractors. The profit/person (p) between the subcontractors and the projects, and the available/required staffing are shown below. Projects/ ($/p) Available Subcontractor ABC (p) 1 50 35 15 3 2 25 40 20 3 35 30 50 5 4 25 25 25 2 Required (p) 5 5 2 N Find: a) Formulate the above problem as a LP optimization model with Network Diagram, Objectives, Decision Variables, Constraints and solve using Excel Solver. (20) b) Optimal assignments of subcontractor and persons (p) to each project to maximize total profit using Excel Solver
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
