If you use functions in excel, please include a step$-$by$-$step so I can understand how to do the problem.

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. 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 facilitles, each factory must make dally 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.

Complete the table below to show the quantity shipped from each factory to each customer.

Note: Leave no cells blank $-$ be certaln to enter $"$O$"$ wherever required.

What is the total cost of meeting customer requirements each day?

Total cost

Shipping Costs $($$ $/$unit$)$

Factory$/$Capacity Customer $1$ Customer $2$ Customer $3$

A$/130$ units $101414$

B$/110$ units $8712$

C$/100$ units $597$

Requirement$170$ units Requirement$57$ units Requirement$113$ units

Complete the table below to show the quantity shipped from each factory to each customer.

Note: Leave no cells blank $-$ be certain to enter $"0"$ wherever required.

What is the total cost of meeting customer requirements each day?