Question: Please answer this question using LINGO and run it to make sure it is right before you post it ! ! Here is the table

Please answer this question using LINGO and run it to make sure it is right before you post it!! Here is the table if you cannot make it out: Cost(Jobs, Crews)=[30,44,38,47,31,
25,32,45,44,25,
23,40,37,39,29,
26,38,37,45,28,
26,34,44,43,28];
Consdier using this to help; @for(note(j): @sum(edge(i,j): inflow(i,j))=@sum(edge(j,k): outflow(j,k))
);
CarpetPlus sells and installs floor covering for commercial buildings. Brad Sweeney, a
CarpetPlus account executive, was just awarded the contract for five jobs. Brad must now
assign a CarpetPlus installation crew to each of the five jobs. Because the commission
Brad will earn depends on the profit CarpetPlus makes, Brad would like to determine an
assignment that will minimize total installation costs. Currently, five installation crews are
available for assignment. Each crew is identified by a color code, which aids in tracking of
job progress on a large white board. The following table shows the costs (in hundreds of
dollars) for each crew to complete each of the five jobs:
Client
Project Leader 123
Jackson 101632
Ellis 142240
Smith 222434
Job
Crew 12345
Red 3044384731
White 2532454425
Blue 2340373929
Green 2638374528
Brown 2634444328
a. Develop a network representation of the problem.
b. Formulate and solve a linear programming model to determine the minimum cost
assignment.

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 General Management Questions!