using excel simplex solution

The Nimble Digit Division of Block C Enterprises ships parts from four manufacturing plants to 10 assembly plants. Shipments are currently by truck at a cost of $0.02 per part mile. The distances from manufacturing plant to assembly plant are given in the following table: Assembly Plant Manufacturing Plants M2 M3 M1 M4 A1 A2 A3 A4 A5 A6 AZ A8 A9 A10 350 550 750 400 950 600 600 300 450 500 650 700 450 500 650 550 750 450 600 700 400 450 600 1000 500 250 200 400 750 600 850 550 400 750 350 300 450 350 550 800 The capacity of the four manufacturing plants are 155, 245, 325 and 175 parts respectively and the assemblies required by the assembly plants are 75, 155, 120, 130, 75, 95, 115,55, 145 and 95 parts. Determine a transportation plan that will minimize the total cost of shipping. Nimble Digits is considering changing the method of shipment from truck to rail for distances greater than 600 miles. The cost of rail shipment is $0.01 per part mile. Determine the impact on cost and schedule if rail shipments are implemented