Two workers were hired by Charleston Construction to perform 3 tasks. The Char

    0

    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
    30
    18

    32

    Cost (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.

                                                                                                                                      Order Now