Answer to Question #201038 in Excel for Nana kofi

Question

Two plants supply three customers with medical supplies. The unit costs of shipping from the plants to the customers, along with the supplies and demands, are given in Table below.

The company’s goal is to minimize the cost of meeting customers’ demands.

From

To

Customer 1

Customer 2

Customer 3

Supply

Plant 1

55

65

80

35

Plant 2

10

15

25

50

Demand

10

10

10

a) Formulate a linear programming (LP) model for this problem.

b) Use solver to find the optimal transportation rule

c) As a management science student, the MD of the company seeks your expert advice on ways in which to determine the optimal transportation rule. Advise the MD, providing detailed explanation using your answer obtain in (b). Write your answer in a form of a report to the MD.

Answer 1

Dear Nana kofi, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order