IVIAN6596 - supply Chain IVlanagement Due: November 12 at 11:59pm Mini-Assignment 3 - Cargo assignment via linear programming A pharmaceutical supplier with warehouses in Manchester, Madrid, and Rotterdam must meet market demand in Amsterdam, Vienna, Zurich and Lisbon. The following table summarize data relevant to this week's distribution problem. The numbers in the first three rows and the first four columns are the transportation costs per unit from each distribution center to each market. Find the optimal allocation of inventory. 1. What is the objective (maximize or minimize)? 2. Solve the problem using Solver in Excel (review the LP video in the course module) 3. Submit your solved Excel sheet to me via Canvas a. I will be looking for the exact dollar amount and b. The allocation of inventory to each of the 4 sites Note: The transportations costs are in dollars (we are a USA based company). Please submit the answers in dollars like the chart above. Hint: Is the chart above enough to solve the problem? No...there is 1 other step (see the LP example video) IVIAN6596 - supply Chain IVlanagement Due: November 12 at 11:59pm Mini-Assignment 3 - Cargo assignment via linear programming A pharmaceutical supplier with warehouses in Manchester, Madrid, and Rotterdam must meet market demand in Amsterdam, Vienna, Zurich and Lisbon. The following table summarize data relevant to this week's distribution problem. The numbers in the first three rows and the first four columns are the transportation costs per unit from each distribution center to each market. Find the optimal allocation of inventory. 1. What is the objective (maximize or minimize)? 2. Solve the problem using Solver in Excel (review the LP video in the course module) 3. Submit your solved Excel sheet to me via Canvas a. I will be looking for the exact dollar amount and b. The allocation of inventory to each of the 4 sites Note: The transportations costs are in dollars (we are a USA based company). Please submit the answers in dollars like the chart above. Hint: Is the chart above enough to solve the problem? No...there is 1 other step (see the LP example video)