Question: Consider the hypothetical transportation problem shown in Table 1 below. Table 1: Hypothetical Transportation Problem from to to to supply A 100 150 120 1000

Consider the hypothetical transportation problem shown in Table 1 below. Table 1: Hypothetical Transportation Problem

from to to to supply
A 100 150 120 1000
B 120 80 75 700
C 90 70 100 800
Demand 700 900 900

a) Formulate the transportation problem as a linear programming model. Clearly present details of the formulation, state and justify your assumptions. b) Use Microsoft Excel to solve the problem. c) Present your findings, including a critical discussion of the results.

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!