$4-$ A furniture company wants to transfer furniture from plants to storage houses. The supply and demand are listed in Table $1.$ Table $2$ shows the costs of transportation. To overcome the supply shortage, the company decided to add another plant. Cost and options are shown in table $3.$

Table $1$

Production Plants

Quebec $1190$

Montreal $14000$

Toronto $16000$

Warehouse

House $11300$

House $21490$

House $31620$

Table $2$

From$/$To House $1$ House $2$ House $3$ House $4$

Quebec $25554058$

Montreal $36285040$

Toronto $37452665$

Table $3.$

From$/$To House $1$ House $2$ House $3$ House $4$

Brampton $50406528$

Hamilton $35294050$

Answer the following:

What should be the production capacity of the plant. What is the total cost of each plant?

Use excel to find the plant with the least cost and choose that plant

Construct the transportation problem with the chosen plant