A company owns three production centers P1, P2, and P3, whose production capacity is of units 61, 49, and 90, respectively. These products have to be shipped in three depositary centers D1, D2, and D3 which have demanded units 52, 68, and 80, respectively. The matrix of transportation costs is given in (Table 7), where in each cell we have the transportation cost from the production center i to the depositary center j. Determine the best transportation policy that minimizes the total cost using a linear program in Excel.

Transcribed Image Text:

TABLE 7 D1 D2 D3 P1 26 23 10 P2 14 13 21 P3 16 17 29