Question: table {mso-displayed-decimal-separator:.; mso-displayed-thousand-separator:,;} tr {mso-height-source:auto;} col {mso-width-source:auto;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0;}
table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} tr {mso-height-source:auto;} col {mso-width-source:auto;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0;} .xl84 {font-weight:700; font-style:italic; font-family:Arial, sans-serif; mso-font-charset:0;} .xl85 {font-family:Arial, sans-serif; mso-font-charset:0;} .xl86 {font-family:Arial, sans-serif; mso-font-charset:0; border-top:1.0pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:none; border-left:1.0pt solid windowtext;} .xl87 {font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:right; border-top:1.0pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:none; border-left:.5pt solid windowtext;} .xl88 {font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:right; border-top:1.0pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:none; border-left:.5pt solid windowtext;} .xl89 {font-style:italic; font-family:Arial, sans-serif; mso-font-charset:0; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext;} .xl90 {font-family:Arial, sans-serif; mso-font-charset:0; text-align:right; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext;} .xl91 {font-family:Arial, sans-serif; mso-font-charset:0; text-align:right; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none;} .xl92 {font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:right; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext;} .xl93 {font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:right; border-top:none; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext;} .xl94 {font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:right; border-top:1.0pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:none; border-left:.5pt solid windowtext; white-space:normal;} .xl95 {font-family:Arial, sans-serif; mso-font-charset:0; text-align:right; border-top:none; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext;} .xl96 {font-style:italic; font-family:Arial, sans-serif; mso-font-charset:0; border-top:1.0pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:1.0pt solid windowtext;} .xl97 {font-style:italic; font-family:Arial, sans-serif; mso-font-charset:0; border-top:1.0pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext;} .xl98 {font-family:Arial, sans-serif; mso-font-charset:0; border-top:1.0pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:none;} .xl99 {font-family:Arial, sans-serif; mso-font-charset:0; border-top:1.0pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none;} .xl100 {font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0;} .xl103 {font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0;} .xl107 {font-family:Arial, sans-serif; mso-font-charset:0; border:.5pt solid windowtext;} .xl108 {font-family:Arial, sans-serif; mso-font-charset:0; border:.5pt solid windowtext;} .xl109 {font-style:italic; font-family:Arial, sans-serif; mso-font-charset:0; border:.5pt solid windowtext;} .xl110 {border:.5pt solid windowtext;} .xl112 {font-family:Arial, sans-serif; mso-font-charset:0; text-align:right; border:.5pt solid windowtext; background:#99CCFF; mso-pattern:black none;} .xl114 {font-style:italic; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; border:.5pt solid windowtext;} .xl115 {font-weight:700; font-style:italic; font-family:Arial, sans-serif; mso-font-charset:0; border:.5pt solid windowtext;} .xl116 {font-family:Arial, sans-serif; mso-font-charset:0; border:.5pt solid windowtext;} .xl117 {font-family:Arial, sans-serif; mso-font-charset:0; text-align:center; border:.5pt solid windowtext;} .xl143 {font-style:italic; font-family:Arial, sans-serif; mso-font-charset:0; text-align:center; border-top:1.0pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; white-space:normal;} .xl144 {font-style:italic; font-family:Arial, sans-serif; mso-font-charset:0; text-align:center; border-top:1.0pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; white-space:normal;} .xl145 {font-style:italic; font-family:Arial, sans-serif; mso-font-charset:0; text-align:center; border-top:1.0pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none; white-space:normal;}
| Inputs - Costs, Capacities, Demands (for TelecomOptic) | |||||||||
| Demand City Production and Transportation Cost per 1000 Units | Fixed | ||||||||
| Supply City | Atlanta | Boston | Chicago | Denver | Omaha | Portland | Cost ($) | Capacity | |
| Baltimore | 1,675 | 400 | 685 | 1,630 | 1,160 | 2,800 | 7,650 | 18 | |
| Cheyenne | 1,460 | 1,940 | 970 | 100 | 495 | 1,200 | 3,500 | 24 | |
| Salt Lake | 1,925 | 2,400 | 1,425 | 500 | 950 | 800 | 5,000 | 27 | |
| Memphis | 380 | 1,355 | 543 | 1,045 | 665 | 2,321 | 4,100 | 22 | |
| Wichita | 922 | 1,646 | 700 | 508 | 311 | 1,797 | 2,200 | 31 | |
| Demand | 10 | 8 | 14 | 6 | 7 | 11 | |||
| Decision Variables | |||||||||
| Demand City - Production Allocation (1000 Units) | Plants | ||||||||
| Supply City | Atlanta | Boston | Chicago | Denver | Omaha | Portland | (1=open) | ||
| Baltimore | |||||||||
| Cheyenne | |||||||||
| Salt Lake | |||||||||
| Memphis | |||||||||
| Wichita | |||||||||
| Constraints | |||||||||
| Supply City | Excess Capacity | ||||||||
| Baltimore | Total Available Capacity | ||||||||
| Cheyenne | |||||||||
| Salt Lake | |||||||||
| Memphis | |||||||||
| Wichita | |||||||||
| Atlanta | Boston | Chicago | Denver | Omaha | Portland | ||||
| Unmet Demand | |||||||||
| Objective Function | |||||||||
| Cost = | |||||||||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
