solve using excel by transportation method

Production Analysis Problem #9 The Nimble Digits Division of Block C Enterprises ships subassemblies from its manufacturing plants in Cincinnati, Salt Lake City and Pittsburgh to assembly plants in Detroit, Dallas, New York and Los Angeles. The Cincinnati plant has a capacity of 10000 unit and it cost $48 to produce each unit, the Salt Lake City plant has a capacity of 4000 unit and it cost $50 to produce each unit and the Pittsburgh plant has a capacity of 11000 units and it cost $52 to produce each unit. Demand for Detroit is 8000 units, demand for Dallas is 9000 units, demand for New York is 12000 units and demand for Los Angeles is 6000 units. Since the demand of the assembly plants exceeds the capacity of the manufacturing plants by 10000 units, Nimble Digits is planning to increase the manufacturing capacity. Three options are being considered to meet the demand: 1. Build a new plant in Seattle that would have an expected unit cost of $54. 2. Build a new plant in Birmingham that would have an expected unit cost of $46. 3. Expand the capacity of the Salt Lake City plant. The shipping costs per unit from the various manufacturing plants to the assembly plants are shown in the table below. from to Detroit Dallas New York Los Angeles Cincinnati $25 $55 $40 $60 Salt Lake $35 $30 $50 $40 Pittsburgh $36 $45 $26 $66 Seattle $60 $38 $65 $27 Birmingham $35 $30 $41 $50 Based upon the above information, which of the proposed sites would minimize the total cost of production plus transportation