a. Develop a transportation grid for this problem. Supply Minneapolis 24 From To Boulder Macon Gary Requirements 6 New York City 14 28 7 20.000 San Diego 20 15 22 80.000 Fort Worth 20 25 21 100.000 100,000 150,000 80,000 20 95.000 - b. Find the optimal solution using Microsoft Excel (Leave no cells blank - be certain to enter "o" wherever required.) 0 Candidate Solution Boulder Macon Gary Total supplied 95.000 0 0 80,000 20.000 Total Shipped 95.000 120.000 80,000 295,000 100,000 0 100,000 0 20,000 80,000 95,000 Profit 0 0 0 Boulder Macon 0 0 Olo Gary 0 0 0 Total profit Bindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd, Rinso manufactures the washers at four locations around the country: New York City, Fort Worth, San Diego, and Minneapolis. Plans call for the following numbers of washing machines to be produced at each location: New York City Fort Worth San Diego Minneapolis 20.000 100,000 80,000 95,000 Bindley has three plants that can produce the motors. The plants and production capacities are Boulder Macon 100,000 150,000 Gary 80,000 Due to varying production and transportation costs, the profit Bindley ears on each 1,000 units depends on where they were produced and where they were shipped. The following table gives the accounting department estimates of the dollar profit per unit (Shipment will be made in lots of 1,000.) PRODUCED A NEW YORK CITY Boulder 14 Macon 28 Gary 7 SHIPPED TO FORT WORTH SAN DIEGO 20 20 25 15 21 22 MINNEAPOLIS 24 6 20