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. From the final worksheet, write or type the final solution.

PLEASE SHARE LINK TO EXCEL AND SOLVING PARAMETERS WHEN DONE!!!!

1. ABC pharmaceutical Company has four factories that ship supplies to four warehouses. The companys management hires you as a consultant to determine a minimum-cost shipping plan for its monthly output to the warehouses. Factory capacities, warehouse demands, and shipping cost per box are shown below.

Factory	Supply or capacity (boxes)	Warehouse	Demand (boxes)
Indianapolis	15	Columbus	10
Phoenix	6	St. Louis	12
New York	14	Denver	15
Atlanta	11	Los Angeles	9

	Shipping Costs per box (In Dollars)
From	To Columbus	To St. Louis	To Denver	To Los Angeles
Indianapolis	25	35	36	60
Phoenix	55	30	25	25
New York	40	50	80	90
Atlanta	30	40	66	75

1. Draw a diagram by showing factories, warehouses, and connecting arcs.
2. Define variables, write the objective function and constraints.
3. Prepare an initial Excel worksheet, check your formulas, and save it.
4. Complete solver parameters, copy it, and save as a file.
5. Solve the problem and determine the optimal shipping schedule.
6. Write the shipping schedule and the value of the objective function by hand or type it.