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

Requirements 1. The report is at least five pages long, and please follow APA formatting. 2. Include your name, section, and student ID on the title page. 3. In the report, you should include the...

CASE STUDY Seven-Eleven Japan Co. Established by Ito Yokado in 1973, Seven-Eleven Japan As a result, detailed financial results for Seven-Eleven set up its first store in Koto-ku, Tokyo, in May 1974....

Answer question 5&6 7-Eleven Japan' Established in 1973, 7-Eleven Japan set up its first store in Koto-ku, Tokyo, in May 1974. The company was first listed on the Tokyo Stock Exchange in October...

1. - Expain the motivations of Unilever in acquiring Inmarko. - Identify the risks Unilever faces in using acquisition as a mode for growth, as opposed to other modes discussed in the chapter. 2....

By MARK@ (Ruska, Markevichus, Naniev, Grachev) Emerging russian ice-cream market is good area for different producers as it has great potential 1. Currently Russian ice-cream market is the 4th...

Avail- het.mckinsey.com/html/ knowledge/article/20101213_apparel_supply chain asp Dyckman, Thomas R. Robert P. Magee, and Glenn M. Pfeiffer. Financial Accounting. Westmont, IL: Cambridge Business in...

O Avail- het.mckinsey.com/html/ knowledge/article/20101213_apparel_supply chain asp Dyckman, Thomas R. Robert P. Magee, and Glenn M. Pfeiffer. Financial Accounting. Westmont, IL: Cambridge Business...

Side Agreements Business Law Individual Assignment I. Introduction The Commercial Companies Law of the United Arab Emirates (Federal Law No. 8 of 1984, as amended) provides for seven types of...

For each of the following (separately) explain how you would interpret the market reaction if the differing !me windows had the following different results: B. Suppose a study showed a stronger...

Suppose a knowledge base contains just one sentence x As High As (x, Everest). Which of the following arc legitimate results of applying Existential Instantiation? a. As High As (Everest, Everest)....

is a scientific selection, measurement and collection of all environmental and socio- economic activities and condition. Group of answer choices Financial accounting Environmental Accounting...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...