Question: Can you help with the question attached ? Part 2: Using Excel Solver, solve the problem below and interpret your findings. Upload the Excel file
Can you help with the question attached ?

Part 2: Using Excel Solver, solve the problem below and interpret your findings. Upload the Excel file you used to solve the problem. - 30 pts Q) A company has 4 DCs and 12 customers. It wants to minimize the cost of shipping its product from the DCs to the customers. Unit transportation cost DC1 DC2 DC3 DC4 Customer 1 Customer 2 Customer 3 Customer 4 Customer 5 $ $ $ $ $ 1.54 2.29 1.29 1.79 1.29 $ $ $ $ $ 1.29 1.79 0.79 1.54 1.39 $ $ $ $ $ 1.69 1.79 1.04 1.59 1.14 $ $ $ $ $ 1.79 2.29 2.29 1.29 0.79 Customer 6 Customer 7 Customer 8 Customer 9 Customer 10 Customer 11 Customer 12 $ $ $ $ $ $ $ 1.04 1.74 0.99 2.29 1.29 1.79 1.29 $ $ $ $ $ $ $ 1.24 1.54 2.29 1.29 1.79 1.29 1.39 $ $ $ $ $ $ $ 2.29 1.29 1.79 0.79 1.54 1.39 1.14 $ $ $ $ $ $ $ 1.79 0.79 1.79 1.04 1.59 1.14 1.14 Capacity 150,000 200,000 150,000 Demand 70,200 61,400 94,700 66,300 22,400 86,500 22,500 32,600 65,300 85,800 66,100 76,200 250,000 How should the company distribute the products? Use Excel Solver to find the number of products from each DC to each customer to minimize their cost. Hint: This problem is similar to the transportation problem solved in the video on Canvas
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
