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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!