Question: ANSWER USING LINGO WILL DOWNVOTE FOR ANSWER USING EXCEL SOLVER!!! 2. (a) (15 marks) A company makes mobile telephones at facilities in Singapore, Ti- juana

ANSWER USING LINGO WILL DOWNVOTE FOR ANSWER USING EXCEL SOLVER!!!

ANSWER USING LINGO WILL DOWNVOTE FOR ANSWER USINGANSWER USING LINGO WILL DOWNVOTE FOR ANSWER USING

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 (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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!