INE$541$: SC Modeling & Design

LINGO$-$ Homework

Solve the CPL case study of $f$ TelecomOne and HighOptic $($TelecomOptic$)$ using LINGO. The book used Excel solver to solve the case study as shown below. Your homework is to solve this problem using LINGO optimization software. Can you find a better solution?

Note:

I found a better solution using LINGO with Min Total cost $=$$$27751.$ This information is encourage you!

This is a real$-$life application problem for CPL$,$ take it seriously and show your engineering skills in the homework.

You must show the value of Objective function & Decision variables organized in one Table once you obtain the answer from LINGO.

PDF file with results along with your LINGO Code should be submitted to Bb$.$

FIGURE $5-11$ Solver Dialog Box for TelecomOptic

$\backslash$table$[[,$A$,$B$,$C$,$D$,$E$,F,$G$,H,1],[1,$Inputs $-$ Costs, Capacities, Demands $($for TelecomOptic$)],[2,$Supgly City,$\backslash$table$[[$Demand Cly$],[$Production and Transportation Cost per $1000$ Units$]],\backslash$table$[[$Fixed$],[$Cost $(5)]],$Capacity$],[3,$Atianta,Boston,Chicago,Denver,Omaha,Portiand$],[4,$Baltimore,$1\mathrm{.}675,400,685,1,630,1,160,2,800,7,650,18],[5,$Cheyenne,$1,460,1,940,970,100,495,1\mathrm{.}200,3,500,24],[6,$Salt Lake,$1,925,2,400,1,425,500,950,800,5\mathrm{.}000,27],[7,$Memphis,$380,1,355,543,1\mathrm{.}045,665,2,321,4,100,22],[8,$Wichita,$922,1,646,700,508,311,1,797,2,200,31],[9,$Demand,$10,8,14,6,7,11,,]]$

$11$ Decision Variables

$\backslash$table$[[12,$Suggly City,Demand Cly $-$ Production Allocation $(1000$ Units$),\backslash$table$[[$Plants$],[$ pen