answer all questions through excel with steps please

- customers Supply Five customers and three suppliers are in the buyer/seller market for cartons of baseballs. a. Find the optimal routing for the existing situation given that the route between Customer 1 and Supplier 1 is now prohibited. b. Two potential scenarios could arise that would change the situation. Keeping your original worksheet as solved in part a, create two new worksheets to consider these options. b1. Transport b1: Keeping all other conditions of part a, including the prohibited route, Customer 3 increases demand to 1400 . Find the cost minimizing solution. b2. Transport b2: Keeping the prohibited route as stated in part a, return Customer 3 's demand to the original value of 600 from part a. New Customer X will join the market with demand of 800 units. Shipping costs between Customer X and all 5 suppliers would be \$7/unit. Find the optimal solution