1. Suppose, we are producing a specific medicine and shipping the medicine from three warehouses we have. Besides, we have four major customers demanding the product. The table summarizes the shipping costs, supply capacities and demands. Warehouse Customer 1 Customer 2 Customer 3 Customer 4 Supply 1 20 18 25 20 500 2 17 30 20 18 600 3 15 20 16 18 400 Demand 500 250 300 250 1) Formulnte a linear programming model that minimizes the cost distribution. (15 points) b) Solve the linear programming model formulated in part (a) by using Excel. State the optimal distribution and the optimal objective value Include the excel file you generated (sensitivity report, answer report, excel model). (35 point)