Question: please i need a detailed answer Topic 2 - Practice Problem 3 CementCo is a small dement distributor in the United Arab Emirates. They have

please i need a detailed answer Topic 2 -please i need a detailed answer
Topic 2 - Practice Problem 3 CementCo is a small dement distributor in the United Arab Emirates. They have two distribution centers (DCs), one in Dubai and one in Sharjah CementCo has just received a large order from a construction contractor and will be supplying cement to four construction projects in the Emirates: one in Abu Dhabi, one in Al Ain, one in Fujairah, and one in Ras Al Kheimah (RAK). The contractor has ordered the following amounts to be shipped each week: Abu Dhabi: 40,500 tons Al Ain: 22,230 tons Fujairah: 85,200 tons RAK 47.500 tons Both DCs can each handle an additional 100,000 tons of cement per week. The transport costs for a ton of cement for the different DC-construction site combinations are given in the table below. Al Ain 32 84 Abu Dhabi 52 45 Fujairah 11 76 RAK 69 15 Dubai Sharjah Build a transportation model in Excel and find the optimal product flow plan

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!