Question 4 (20 marks) (a) (10 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: (1) From/To Shanghai Bonn Cape Town (1) (ii) Canada/USA Latin America Europe Western Asia 180 205 230 80 200 185 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. State the solution in words. (ii) (b) (10 marks) Now the situation is similar to part (a), but it's also possible to ship between each pair of origins. The cost per box is low because shipments are already being made along these routes and they can take advantage of economies of scale. The costs per box are: From/To Shanghai 270 250 210 Bonn Cape Town Shanghai Bonn Cape Town 12 13 14 120 190 220 16 11 17 Taking advantage of the transhipment possibilities, re-solve this model using LINGO. State the solution in words