Need step-by-step solution via Excel Solver. From Chapter 5 of Introduction to Management Science: A Modeling and Case Studies Approach with Spreadsheets (Fredrick Hillier, 6th Edition.). (Formulate and solve a spreadsheet model for a minimum-cost flow problem, a maximum flow problem, or a shortest path problem from a description of the problem.) Please do not respond just to say you cannot solve this, which delays others from answering. Many thanks.

XYZ Corporation operates two plants, each of which has a capacity of 170 units per day. Each day, XYZ must ship their product to each of four customers. Customers A, B, and C each have a demand of 15 units per day while customer D has a demand of 295 units per day. The cost of shipping one unit of each product from each of the two plants to each of the customers is shown in the table below. Customer A 16 19 Plant 1 Plant 2 Customer B 17 20 Customer 12 20 Customer D 24 12 a. How many units should XYZ ship from each plant to each customer? (Leave no cells blank-be certain to enter "O" wherever required. Round your answer to the nearest whole number.) Customer A Customer B Customer C Customer D Plant 1 Plant 2 b. What is the least XYZ will spend on shipping each day? (Round your answers to 2 decimal places.) Least XYZ