Question: 03 (Total 28 marks) Given a supply chain network which originates at three suppliers (R1, R2 and R3) and terminates at location T, where the

03 (Total 28 marks) Given a supply chain network

03 (Total 28 marks) Given a supply chain network which originates at three suppliers (R1, R2 and R3) and terminates at location T, where the other nodes (A-E) are transhipment points. Table Q3 shows the maximum amount of raw materials (in thousands) flow through each node per month. A De 402 Table Q3. Maximum amount of raw materials (in thousand unit) flow through each node To e Te From Rie 100 65e R2e 100 R32 120 802 Ae 60 70e Be 602 110 45e 120e De 452 20 50 50e 180 Ee 902 602 220 In addition to the maximum amount of raw materials allowed between each node, a minimum transporting requirement is also imposed between some transhipment points. For instance, Point D and E need to deliver at least 10 units and 5 units to Point C and D respectively. (a) Formulate the problem to determine the maximum amount of raw materials that can be transported per month. (20 Marks) (b) [EXCEL] Solve this problem using solver. (8 Marks) 03 (Total 28 marks) Given a supply chain network which originates at three suppliers (R1, R2 and R3) and terminates at location T, where the other nodes (A-E) are transhipment points. Table Q3 shows the maximum amount of raw materials (in thousands) flow through each node per month. A De 402 Table Q3. Maximum amount of raw materials (in thousand unit) flow through each node To e Te From Rie 100 65e R2e 100 R32 120 802 Ae 60 70e Be 602 110 45e 120e De 452 20 50 50e 180 Ee 902 602 220 In addition to the maximum amount of raw materials allowed between each node, a minimum transporting requirement is also imposed between some transhipment points. For instance, Point D and E need to deliver at least 10 units and 5 units to Point C and D respectively. (a) Formulate the problem to determine the maximum amount of raw materials that can be transported per month. (20 Marks) (b) [EXCEL] Solve this problem using solver. (8 Marks)

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!

Given a supply chain network which originates at three suppliers (R1, R2 and R3) and terminates at location T, where the other nodes (A-E) are transhipment points. Table Q3 shows the maximum amount...

The IEEE 14 Bus Test system, shown in Fig. I represents a portion of the American Electric Power System (in the Midwestern US) as of February, 1962. The actual model is modified slightly to fit the...

Lecture Notes DL MGT 5100 - Distribution Management Spring 2017 1.0. Day one, Monday, Monday, 9 Jan 17 1.1. Reading Assignments: Chapters 1 and 2 1.1.1. I intend to follow the book so as to provide a...

Exercise one. 1. Let the market demand curve be P=1000 - 10Q. Assume the market is controlled by a monopolist. Let fixed cost be $10,000 and Marginal Costs (MC)=20Q. a) What is the profit maximizing...

Explain the questions well. 1). The market demand function for a good is given by Q = D(p) = 800 50p. For each firm that produces the good the total cost function is TC(Q) = 4Q+( Q2/2) . Recall that...

i. Explain all the questions well. 1). The market demand function for a good is given by Q = D(p) = 800 50p. For each firm that produces the good the total cost function is TC(Q) = 4Q+( Q2/2) ....

Section A. 5. One key difference between traditional economics and behavioral economics is a) b) c) d) A. Traditional economics does not argue that markets are efficient while behavioral economics...

Adidas AG (Adidas ) is engaged in the design, development, manufacture and marketing of a broad range of athletic and sports lifestyle products such as footwear, apparel, hardware (bags and balls)...

Blood flow rates can be found by measuring the Doppler shift in frequency of ultrasound reflected by red blood cells (known as angiodynography). If the speed of the red blood cells is v, the speed of...

Discuss how each of the following investment constraints has changed for Alonso: time horizon liquidity needs E. i. ii. (4 minutes) Alonso has a buy-and-hold portfolio of individual securities,...

complete the statement Chemical Dependency Context : Financial stress can be magnified in families affected by addiction. Substance dependency often leads to significant financial drain due to the...

The national disease control authority has hired your team to help manage influenza (flu) vaccine production. Key facts: . The problem is serious. Even in a year without vaccine shortages, ~36,000...