a-1. Calculate the total cost for each supplier. (Rounc Supplier 1 Supplier 2 Total cost Relative to the U.S. distribution network, calculate the cost associated with running the existing system. Assume that 40 percent of the volume arrives in Seattle and 60 percent in Los Angeles and the port processing fee for federal processing at both locations is $8.00 per CBM. Assume that everything is transferred to the Kansas City distribution center by rail, where it is unloaded and quality checked. Assume that all volume is then transferred by truck to the nine existing warehouses in the United States. (Do not round intermediate calculations and round your answers to the nearest whole number.) K.C Distribution Center Only Port to DC Costs Distance Volume Pct CBM Port Processing Rail Costs to K.C. K.C. Unload and Q.C Total Costs Basic data 190,150 $ 8.00 $ 0.0017 $ 5.00 Seattle port % L.A. port % K.C Distribution Center Only DC to Warehouse Costs Truck Freight Costs Warehouse Kansas City Cleveland Newark Jacksonville Chicago Greenville Memphis Dallas Los Angeles Total Supplier 1 Supplier 2 Total cost Given profit maximization as a criterion, Bindley would like to determine how many motors should be produced at each plant and how many motors should be shipped from each plant to each destination. a. Develop a transportation grid for this problem. From/To New York City Fort Worth San Diego Minneapolis Supply Boulder Macon Gary Requirements b. Find the optimal solution using Microsoft Excel. (Leave no cells blank - be certain to enter "O" wherever required.) Candidate Solution Total Shipped Boulder Macon Gary Total supplied Profit Boulder Macon Gary Total profit