Logistics homework.

hat Font Tools Table Window Help HOMEWORK 4 (6) (1).docx IL AaBbCD ABBODE AaBbc Head ADVANCED LOGISTICS, LSM 340 Homework 4, due on January 30, 2020 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 your 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 Indianapolis Phoenix New York Atlanta Supply 15 6 Warehouse Columbus St. Louis Denver Los Angeles Demand 10 12 15 9 11 From Indianapolis phoenix New York Atlanta To Columbus 25 55 40 30 Shipping Costs per case (In Dollars To St. Louis To Denver, 35 36 30 2 5 50 80 140 66 To Los Angeles 60 25 90 75 . Tetamine on nntimal chinnina chadela Sec 1 Pages: 1 of 2 Words of 377 mat font Tools Table Window Help HOMEWORK 4 (6) (1).docx 20 1 503 ents Tables Charts SantArt Review - E- E a a Albcode Ode AaBCCD Aalbod AaBbc 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. 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. From / To D E FS G Supply | A $9 $8 $ 6S$ 5 50 98 80 40 3310 75 Demand 50 Tatamine the minim et mauris enhetle for the enanarin Sesi Pages 12 Words 0 of 177 LN MacBook Air Font Tools Table Window Help HOMEWORK 4 (6) (1).docx 9. Tables 1 0 Charts 156 SmartArt Review bode See AaBBCCD ABCDd6 AaBbc A E DES Heading F 6 G $5 Supply From / To D E $ 9 58 98 5 0 40 75 10 Demand a. Determine the minimum-cost moving schedule for this scenario. b. What would you do to assure that A always sends a car to D as part of the optimal solution. Determine a shipping schedule. c. Determine a shipping schedule if the road from B to G is blocked. Sec 1 Pages1012 Words of 377 MacBook Air