Question$-3($LP problem$)[20]$

You are an engineer in charge of ordering parts from a warehouse and sending them to different

distribution centres as needed.

Your warehouses are located in Windsor, Toronto, and London; each has $150,100,$ and

$100$ parts, respectively.

The distribution centres are located in Sarnia and Thunder Bay. They ordered $75$ and $215$

parts, respectively, for their distribution plants.

The cost in dollars per part to transport between plants is listed in the table below. Management

wants you to reduce shipping costs while meeting each plant's demands.

Formulate the problem mathematically. Solve the problem $($use excel or hand calculation to solve

this question$).$You are an engineer in charge of ordering parts from a warehouse and sending them to different

distribution centres as needed.

$$ Your warehouses are located in Windsor, Toronto, and London; each has $150,100,$ and

$100$ parts, respectively.

$$ The distribution centres are located in Sarnia and Thunder Bay. They ordered $75$ and $215$

parts, respectively, for their distribution plants.

The cost in dollars per part to transport between plants is listed in the table below. Management

wants you to reduce shipping costs while meeting each plant's demands.

From$/$To Sarnia $($S$)$ Thunder Bay $($TB$)$

Windsor $($W$)$ $$15$ $$20$

Toronto $($T$)$ $$25$ $$13$

London $($L$)$ $$15$ $$15$

Formulate the problem mathematically. Solve the problem $($use excel or hand calculation to solve

this question$).$