Two workers were hired by Charleston Construction to perform 3 tasks. The Charleston project is to renovate the master bathroom of a luxurious condominium in New York. The workers, Jose and Marco, are asked to do the following tasks: plumbing, electrical, and painting. The estimated time (in hours) and the cost ($/ hour) to finish each task are given in the following table.Number of hours to perform each ask Plumbing Electrical Painting Jose 36 20 30 Marco 3018 32Cost (per hour) to perform each task Plumbing Electrical Painting Jose 20 25 28 Marco 25 20 20 Charleston Construction is considering two objectives.a. The first objective is to minimize the total time to finish the project. Formulate algebraically the LP problem by defining the decision variables, the objective function and all the constraints. Then formulate in Solver to find the optimal solution and the minimum time to finish the project. The company may assign each laborer to at least one, but not more than two tasks to accomplish the objective.b. Similar to (a) above but the objective is to minimize the total cost of finishing the project.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]