Question: help me solve using the excel solve using that excel sheet ( A transportation problem ) There are three warehouses at different cities: Detroit, Pittsburgh

help me solve using the excel solve using that excel sheet
(A transportation problem) There are three warehouses at different cities: Detroit, Pittsburgh and Buffalo. They have 250,130 and 235 tons of paper accordingly. There are four publishers in Boston, New York, Chicago and Indianapolis. They ordered 75,230,240 and 70 tons of paper to publish new books. The costs of transportation for one ton of paper are listed as follows:
From \\ To Boston (BS)
New York (NY)
Chicago (CH)
Indianapolis (IN)
Detroit (DT)15201621
Pittsburgh (PT)
2513511 Buffalo (BF)1515717
Please find the optimal plan of transportation that satisfies all orders and minimizes the total transportation cost (10 pts).
help me solve using the excel solve using that

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!