Transportation problem

2. (a) (15 marks) A company makes calculators at facilities in Shanghai (China), Bonn (Germany), and Cape Town (South Africa). These plants can make 1800, 900. and 2700 calculators per week beyond the demand in the "local" markets of Eastern Asia, Germany, and Africa respectively. All three plants can ship to markets elsewhere: Canada/USA, Latin America, Europe, and Western Asia. The demands per week in these four markets are for 1500, 600, 750, and 2300 calculators per week respectively. Calculators are shipped in boxes of 50. The shipping costs per box are as follows:From/To Canada/USA Latin America Europe Western Asia Shanghai 180 270 205 120 Bonn 230 250 80 190 Cape Town 200 210 185 220 (i) The company wishes to determine how many boxes should be shipped from each of the factories to each of the markets. Solve this model using LINGO or the Excel Solver. (ii) State the solution in words