Question: Need it in Excel form if possible. Please provide an Excel link so I can see it. Formulate the following problems by writing objective functions

Need it in Excel form if possible. Please provide an Excel link so I can see it. Need it in Excel form if possible. Please provide
Formulate the following problems by writing objective functions and constraints, type or write by hand. For each problem, create an initial Exoel worksheet, print it, print Solver parameters, and print the final Excel worksbeet 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. 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: & 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 Indianapolis Phoenix New York Atlanta Supply (in thousands) 15 6 14 11 Warehouse Columbus St. Louis Denver Los Angeles Demand (in thousands) 10 12 15 9 From Indianapolis phoenix New York Atlanta To Columbus 25 55 40 Shipping Costs per case (In Dollars) To St. Louis To Denver 35 36 30 25 SO 80 40 66 To Los Angeles 60 25 90 30 75 a. Determine an optimal shipping schedule. (50 points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!