Now, we are considering a transportation plan with current existing automobiles. The marketing department divided a market into the five segments as follows: NY, Houston, Dallas, LA in USA and Toronto in Canada. Each segment has its own estimated demand (requirements). The capacities of all four facilities are described in the last column. We assume that all automobiles are transported by truck. The distance between facilities and market segments are computed as follows in terms of miles.
Develop the automobile transportation plan to minimize the total transportation cost in terms of the distance while satisfying all market demand. You may consider total travel distance as transportation cost. Provide the Excel Solver.