The management of the Executive Furniture Corporation decided to expand the production capacity at its Des Moines factory and to cut back production at its other factories. It also recognizes a shifting market for its desks and revises the requirements at its three warehouses: Albuquerque, Boston, and Cleveland. The table below provides the requirements at each of the warehouses, the capacities at each of the factories, and the shipping cost per unit to ship from each factory to each warehouse.

Find the least cost way to meet the requirements given the capacity at each factory. To do so, define decision variables, objective function, and constraints. Implement the optimization model in MS-Excel and solve it. Need complete answers please

From\To	Albuqueque	Boston	Cleveland	Capacity
Des Moines	5	4	3	300
Evansville	8	4	3	150
Fort Lauderdale	9	7	5	250
Requirements	200	200	300