please use lingo

2. (a) (15 marks) A company makes mobile telephones at facilities in Singapore, Ti- juana (Mexico), and Budapest (Hungary). These plants can make 2000, 2800, and 2100 mobile telephones per week beyond the demand in the "local" mar- kets of Eastern Asia, North America, and Eastern Europe, respectively. All three plants can ship to markets elsewhere: Western Asia, Central/South Amer- ica, Western Europe, and Africa. The demands per week in these four markets are for 1300, 800, 3100, and 900 mobile telephones per week respectively. Mo- bile telephones are shipped in boxes of 20. The shipping costs per box are as follows: From/To Western Asia Central/South America Western Europe Africa Singapore 180 250 185 190 Tijuana 220 165 175 180 Budapest 170 150 155 160 (1) 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. (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 al- ready being made along these routes and they can take advantage of economies of scale. The costs per box are: From/To Singapore Tijuana Budapest Singapore 15 14 Tijuana 16 12 Budapest 10 (i) Taking advantage of the transhipment possibilities, re-solve this model using LINGO or the Excel Solver. (ii) State the solution in words. 11