A company owns three production centers P1, P2, and P3, whose production capacity is of units 5, 7, and 3, respectively. These products have to be shipped in three depositary centers D1, D2, and D3 which have demanded units 7, 3, and 5, respectively. The matrix of transportation costs is as given in (Table 8), where in each cell we have the transportation cost from the production center i to the depositary center j

The figurative amounts of 1000 indicate that the shipping is not possible. Determine the best transportation policy that minimizes the total cost using a linear program in Excel.

Transcribed Image Text:

TABLE 8 D1 D2 D3 H2R P1 3 1 1,000 P2 4 P3 1,000 23 4 3