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

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.

You can leave a response, or trackback from your own site.
error: Content is protected !!