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

$)$

$=$

$[$

$3$

$0$

$,$

$4$

$4$

$,$

$3$

$8$

$,$

$4$

$7$

$,$

$3$

$1$

$,$

$2$

$5$

$,$

$3$

$2$

$,$

$4$

$5$

$,$

$4$

$4$

$,$

$2$

$5$

$,$

$2$

$3$

$,$

$4$

$0$

$,$

$3$

$7$

$,$

$3$

$9$

$,$

$2$

$9$

$,$

$2$

$6$

$,$

$3$

$8$

$,$

$3$

$7$

$,$

$4$

$5$

$,$

$2$

$8$

$,$

$2$

$6$

$,$

$3$

$4$

$,$

$4$

$4$

$,$

$4$

$3$

$,$

$2$

$8$

$]$

; 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

$1$

$2$

$3$

$$Jackson

$1$

$0$

$1$

$6$

$3$

$2$

$$Ellis

$1$

$4$

$2$

$2$

$4$

$0$

$$Smith

$2$

$2$

$2$

$4$

$3$

$4$

$$Job Crew

$1$

$2$

$3$

$4$

$5$

$$Red

$3$

$0$

$4$

$4$

$3$

$8$

$4$

$7$

$3$

$1$

$$White

$2$

$5$

$3$

$2$

$4$

$5$

$4$

$4$

$2$

$5$

$$Blue

$2$

$3$

$4$

$0$

$3$

$7$

$3$

$9$

$2$

$9$

$$Green

$2$

$6$

$3$

$8$

$3$

$7$

$4$

$5$

$2$

$8$

$$Brown

$2$

$6$

$3$

$4$

$4$

$4$

$4$

$3$

$2$

$8$

$$a

$.$

$$Develop a network representation of the problem. b

$.$

$$Formulate and solve a linear programming model to determine the minimum cost assignment.