"you should develop two flow models" because NMC has sought "to build a new factory to expand its production capacity". in this assignment, upload the JPG outcome for the optimal solution. Your uploaded solution should have a similar 'look and feel' professionalism as the JPG file on the external site (figure TP-F8). Make sure to use solver so the pink cells are populated. Also, using this optimal site selection, provide the operating costs for Cincinnati, Kansas City, and Pittsburgh.

Figure TP-F8 example

E F Furniture (Transportation - Alternate Layout) 3 Shipments: 4 From 5 Des Moines 6 Evansville 7 Fort Lauderdale 8 Flow in To Flow balance equations Albuquerque Boston Cleveland Flow out Location Flow in Flow out Net flow Sign RHS 01 1-100 0 300 0 -300 0 300 01-1 200 01-1200 0.0 Des Moines 0.0 Evansville 0.0 Fort Lauderdale Albuquerque Boston Cleveland 0.0 0.0 0.0 10 Unit costs: 11 From 12 Des Moines 13 Evansville 14 Fort Lauderdale 15 16 Total cost= Albuquerque Boston Cleveland $5 $8 $9 $4 $7 $3 $3 $5 $0 E F Furniture (Transportation - Alternate Layout) 3 Shipments: 4 From 5 Des Moines 6 Evansville 7 Fort Lauderdale 8 Flow in To Flow balance equations Albuquerque Boston Cleveland Flow out Location Flow in Flow out Net flow Sign RHS 01 1-100 0 300 0 -300 0 300 01-1 200 01-1200 0.0 Des Moines 0.0 Evansville 0.0 Fort Lauderdale Albuquerque Boston Cleveland 0.0 0.0 0.0 10 Unit costs: 11 From 12 Des Moines 13 Evansville 14 Fort Lauderdale 15 16 Total cost= Albuquerque Boston Cleveland $5 $8 $9 $4 $7 $3 $3 $5 $0