A manufacturing company is closing three of its existing plants, and intends to transfer some of its

employees to four other plants that will remain open. The number of employees available for

transfer from each closing plant is as follows:

Closing Plant Transferable Employees

Total $210$

According to profit estimates by management, the transferred employees will increase profit per

day $$1000$ at each plant, as shown in the following table:

The company wants to decide on the number of transferred employees from plants $\{1,2,3\}$ to

plants $\{A,B,C,D\},$ to ensure the maximum increase in profits at the plants that remain open.

$3\mathrm{.}1$ Formulate an optimization model for this problem.

$3\mathrm{.}2$ Solve your model using its Excel implementation. Name the corresponding worksheet tab

"Relocation".

$**$PLEASE MAKE SURE YOU SHOW EXCEL CALCULATIONS AND ANSWERS