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.

Maximum supply

Facility $135$ Facility $250$ Facility $340$

Demand Store $145$

Store $220$ Store $330$ Store $430$

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

Store $1$ Store $2$ Facility$186$

Facility$2912$ Facility$3149$

Store $310$

$13$

$16$

Store $49$

$7$

$5$

a$)$ Formulate a model to create a transportation plan that minimizes shipping costs of meeting demand. Solve it using Excel.