Optimization and spreadsheet modeling

A firm is attempting to minimize its shipping costs. The firm has 3 factories and must supply the needs of its 3 customers without shortages. Since the firm has no storage facilities, each factory must make daily shipments to its customers. The table below shows the capacity of each factory, the amount required by each customer, and the cost of shipping from each factory to each customer. Shipping costs $/unit) Tactory/capacity Customer Customer 2 W/190 units Customer 3 5 5/190 units c/150 units Requirement-265 unite Requirement-38 unita Requirement-177 units 10 6 14 10 11 15 Complete the table below to show the quantity shipped from each factory to each customer. (Leave no cells blank - be certain to enter "o" wherever required.) Factory Shipping Costs (unit) Customer Customer Customer 3 0 13 177 100 O 063 75 753 0 B o What is the total cost of meeting customer requirements each day? Total cost 1232