Assignmentsolved

Assignment:
Formulate the OR model for the following problem:
The Executive Furniture Corporation
a) The North West Corner (NWC) rule determines the first possible solution as follows:
If there is enough demand or supply left in a particular row or column, we begin with
the Northwest Corner and allocate as much as possible there before moving on to the
next row or column. It is necessary to keep repeating this procedure until all of the
demand has been met.
To determine optimal solution, formulate Excel model as follows:
EXCEL FORMULA:
Set up Solver Parameters as follows:
Optimal solution shows the quantity to be shipped from each source to each destination
.
c)
Minimum total cost = 5,900
…