dsci 5210 model based business intelligence

Hansen Controls has been awarded a contract for a large number of control panels. To meet this demand, it will use its existing plants in San Diego and Houston, and consider new plants in Tulsa, St. Louis, and Portland. Finished control panels are to be shipped to Seattle, Denver, and Kansas City. Pertinent information is given in the table. Shipping Cost to Destination: Kansas Construction Seattle Denver Sources Cost City Capacity 2 3 1- San Diego ---- 5 8 8,000 2- Houston 8 10 6 12,000 3- Tulsa 350,000 12 6 3 10,000 4- St. Louis 400,000 12 4 2 7,000 5- Portland 480,000 4 10 11 9,000 Demand 11,000 8,000 7,000We develop a transportation model as an LP that includes provisions for the xed costs (construction costs in this case) for the three new plants. The solution of this model would reveal which plants to build and the optimal shipping schedule. Let xi]- = the number of panels shipped from source i to destinationj vi = i if plant i is built, = Gotheiwise (i = 3, 4, 5} The constraint f0! supplyr from St. Louis is given as: 0 x41 4- x42 + x43 = 11.00054 0 x11 + x21 +x31 + x41 +x51