Question $1)$ Zudo Furniture manufactures cabinets and meets the demands of four stores by its

three manufacturing facilities. The capacities of facilities and the demand of each store are given

below.

The below table shows the shipping cost of a cabinet from each facility to each store.

a$)$ Formulate a model to create a transportation plan that minimizes shipping costs of meeting

demand. Solve it using Excel.