I want the solution in excel now please

The Hardgrave Machine Company produces computer components at its plants in Cincinnati, Salt Lake City, and Pittsburgh. These plants have not been able to keep up with demand for orders at Hardgrave's four warehouses in Detroit, Dallas, New York, and Los Angeles. As a result, the firm has decided to build a new plant to expand its productive capacity. The two sites being considered are Seattle and Birmingham; both cities are attractive in terms of labor supply, municipal services, and ease of factory financing. Below tables present the production costs and output requirements for each of the three existing plants, demand at each of the four warehouses, and estimated production costs of the new proposed plants, in addition to the Transportation costs from each plant to each warehouse. 48 50 MONTHLY DEMAND PRODUCTION MONTHLY COST TO PRODUCE WAREHOUSE (UNITS) PLANT SUPPLY ONE UNIT ($) Detroit 10,000 Cincinnati 15,000 Dallas 12,000 Salt Lake City 6,000 New York 15.000 Pittsburgh 14,000 52 Los Angeles 9,000 35,000 46,000 Supply needed from new plant = 46,000 35,000 = 11,000 units per month ESTIMATED PRODUCTION COST PER UNIT AT PROPOSED PLANTS Seattle $53 Birmingham $49 ESTIMATED PRODUCTION COST PER UNIT AT PROPOSED PLANTS Seattle S53 Birmingham $49 TO FROM NEW YORK DETROIT $25 DALLAS $55 30 LOS ANGELES $60 40 $40 35 50 CINCINNATI SALT LAKE CITY PITTSBURGH SEATTLE 36 45 26 66 60 38 65 27 35 30 41 50 BIRMINGHAM Which of the new locations will yield the lowest cost for the firm in combination with the existing plants and warehouses