A company makes smart telephones at facilities in Waterloo (Canada), Cambridge England), and Mumbai (India). These plants can make 1200, 900, and 2400 telephones per week beyond the demand in the "local" markets of Canada/USA, Europe, and Western Asia respectively. All three plants can ship to markets elsewhere: Latin America, Africa, and Eastern Asia. The demands per week in these three markets are for 500, 1400, and 2500 telephones per week respectively. Phones are shipped in boxes of 100. The shipping costs per box are as follows:

From/To

Latin America

Africa

Eastern Asia

Water

200

340

270

Cambridge

290

250

310

Mumbai

300

240

250

Formulate a model and solve using Excel to determine how much should be shipped from the factories

to the markets.