I need an excel expert-Linear programming
Budget: $30 – $250 USD
This exercise shows a different application of network models based on a distribution problem. A firm has 12 contractor plants to meet the demand of 14 customers. The unit production plus delivery costs of each plant to each customer are included in the table. In addition, the last column of the table shows the maximum capacity for each plant, while the last row shows the demand that must be sastisfied for each customer. You would like to obtain the optimal production plan.
Questions:
1. (1 point) Formulate this problem in Excel. Identify the decision variables, constraints and objective function
2. (1 point) Solve the problem using Solver to find the optimal solution that minimizes total costs.
3. (0.5 points) At the optimal solution, who is the most expensive customer to service at the per unit cost? what is that per unit cost?
Answer question 3 here - >
4. (0.5 points) Suppose that you pay your contractor the same fixed overhead cost at each of the plant. If you had to terminate two contracts, which ones would you choose? Why? Hint: Use the sensitivity report
Answer question 4 here - >
Questions:
1. (1 point) Formulate this problem in Excel. Identify the decision variables, constraints and objective function
2. (1 point) Solve the problem using Solver to find the optimal solution that minimizes total costs.
3. (0.5 points) At the optimal solution, who is the most expensive customer to service at the per unit cost? what is that per unit cost?
Answer question 3 here - >
4. (0.5 points) Suppose that you pay your contractor the same fixed overhead cost at each of the plant. If you had to terminate two contracts, which ones would you choose? Why? Hint: Use the sensitivity report
Answer question 4 here - >