2. A company makes calculators at facilities in Shanghai (China), Bonn (Germany), and Cape Town (South...

Transcribed Image Text:

2. 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 Shanghai Bonn Cape Town Canada/USA Latin America Europe 180 205 230 80 200 185 270 250 210 Western Asia 120 190 220 (a) Formulate a model in Excel (there is no need to give the algebraic model) and solve it to determine how much should be shipped from the factories to the markets. State the solution in words. (b) Now suppose that calculators can be shipped from Cape Town to Bonn at a cost of $15 per box. For legal reasons, Shanghai cannot transship to Bonn. Formulate a model in Excel and solve it, and state the solution in words. 2. 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 Shanghai Bonn Cape Town Canada/USA Latin America Europe 180 205 230 80 200 185 270 250 210 Western Asia 120 190 220 (a) Formulate a model in Excel (there is no need to give the algebraic model) and solve it to determine how much should be shipped from the factories to the markets. State the solution in words. (b) Now suppose that calculators can be shipped from Cape Town to Bonn at a cost of $15 per box. For legal reasons, Shanghai cannot transship to Bonn. Formulate a model in Excel and solve it, and state the solution in words.