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, print Solver parameters, 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. You may use my worksheet as a guidance to create yours but do not use it. 1. ABC pharmaceutical Company has four factories supplying four warehouses. The company's management hires you as consultant to determine a minimum-cost shipping schedule for its monthly output to the warehouses. Factory supply, warehouse demands, and shipping cost per case are shown below. Factory Supply Warehouse Demand Indianapolis 15 Columbus 10 Phoenix 6 St. Louis 12 New York 14 Denver 15 Atlanta 11 Los Angeles 9 Shipping Costs per case (In Dollars From To Columbus To St. Louis To Denver To Los Angeles Indianapolis 25 60 phoenix 55 30 25 New York 40 50 80 90 Atlanta 30 40 66 75 a. Determine an optimal shipping schedule. b. Determine a shipping schedule if you definitely want to ship from New York to Denver. c. Determine a shipping schedule if you the highway from Indianapolis to Columbus is broken