Formulate the following problems by writing objective functions and constraints, type or write by hand. For each problem, create an initial Excel worksheet, print it, and print the final Excel worksheet after solving the problem. In the final worksheet, write or type the final solution. All worksheet must have your name typed on the first row. 1. ABC pharmaceutical Company has three plants supplying to two distribution centers (DC) in Decatur and Ely (New Mexico) which further supply pharmaceutical products to four customer centers. The company's management hires you as a consultant to determine a minimum-cost shipping schedule for its monthly output to the warehouses and from warehouses to retail stores. Factory supply, retail demands, and shipping cost per case are shown below. Plants Monthly Capacity (boxes) Customer centers Demand (boxes) Indianapolis Columbus Phoenix St. Louis Atlanta Bismarck Fresno Shipping Costs in S amount From To Decatur To Ely Indianapolis $25 Phoenix 30 Atlanta 30 25 S40 55 Shipping Costs in S amount From To Columbus To St. Louis To Bismarck To Fresno Decatur 25 15 36 Ely 45 30 40 35 SO a. Draw a network showing plants, DCs, customer centers and shipping paths. b. Write a cost matrix, i.e., cost of each shipping path. c. Write the objective function and constraints. d. Create an Excel worksheet with formulas and determine an optimal shipping schedule