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. Please make sure that your initial worksheet is formatted to be on one page and all cells containing numerical values are centered. Also print out answer report. List of attachments: a. Problem-Formulation: Define variables, write objective function and constraints. b. Initial worksheet, copy of Solver parameters, Final worksheet. c. Answer report and value of variables and objective functions written by your hand. 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 supply to the warehouses. Factory supply, warehouse demands, and shipping cost per case are shown below. Factory Supply in thousands) Warehouse Demand (in thousands) 15 Columbus Indianapolis Phoenix New York Los Angeles Atlanta 6 14 11 St. Louis Denver 10 12 IS 9 From Indianapolis phoenix New York Atlanta To Columbus 25 SS 40 Shipping Costs per case (In Dollars) To St. Louis To Denver To Los Angeles 35 36 60 30 25 25 50 80 90 40 66 75 30 a. Determine a shipping schedule if you definitely want to ship from New York to Denver b. Determine a shipping schedule if the highway from Indianapolis to Columbus is broken. 2. Rent'R Cars is a multisite car rental company in Huntsville/Madison area. It is trying out a new "return the car to the location most convenient for you" policy to improve customer service. But this means that the company has to constantly move cars around the city to maintain required levels of vehicle availability. The supply and demand for economy cars, cost of moving vehicles between sites per vehicle are shown below. 2. RtR Curs is a multisite car rental company in Huntsville/Madison area. It is trying out new return the car to the location most convenient for you" policy to improve customer service. But this means that the company has to constantly move can ground the city to maintain required levels of vehicle wilability. The supply and demand for concey, cost of moving vehicles between sites per vehicle are shown below. E ESTO $6 soby 50 0 D 59 9 A 3 3 10 Dam 150 What would you do tortas Always curto Desportohet Delia shipping schedule Determine hipping schedule if the road from Hacked 1 United States MacBook Air 0 BOB 90 - 9 A & 7 8 % 5 6 $ 4 # 3 0 Y T R E