Please include step by step instructions for Excel. Fast is moving some employees into a newly renovated floor in one of their buildings. There are $14$ employees involved and there are $10$ offices on the renovated floor, four of which seat two people. The Fast HR $($Human Resources$)$ director knows happy employees are productive employees and let the $14$ staff members visit the new space and give their preference by a rank of $10($first choice$)$ to $1($last choice$).-$ How should the HR manager assign the offices to maximize the preference of all $14$ employees?

Hints:

$-$ The decision variables are the employee office assignments.

$-$ The objective function would be to maximize the sum of preferences the employees get, e$.$g$.$ if employee $1$ gets office $1,$ and employee $3$ gets office $2,$ the sum of their preferences would be $\backslash (3+8=11\backslash ).$

$-$ Assignments must be binary.

$-$ Employees and rankings are integers.

$-$ No employee can have more than $1$ office assignment.

$-$ Every employee must have an assignment.

$-$ Every office must be used to capacity, i$.$e$.$ a $2-$person office must have $2$ employees assigned and $1-$person offices can only have $1$ employee assigned.

$-$ Some of the hints are constraints. $-$ Task $3$a$\mathrm{.}1$: State the objective function as a mathematical formula.

$-$ Task $3$a$\mathrm{.}2$: Identify all constraints.

$-$ Task $3$a$\mathrm{.}3$: Build an appropriate decision model in Excel.

$-$ Task $3$a$\mathrm{.}4$: Set up constraints with "left side" and "right side".

$-$ Task $3$a$\mathrm{.}5$: Binary constraints connected to model?

$-$ Task $3$a$\mathrm{.}6$: Solver dialog set up properly?

$-$ Task $3$a$\mathrm{.}6\mathrm{.}1$: $-$objective cell

$-$ Task $3$a$\mathrm{.}6\mathrm{.}2$: $-$constraints

$-$ Task $3$a$\mathrm{.}6\mathrm{.}3$: $-$correct engine

$-$ Task $3$a$\mathrm{.}7$: Solution stated or clearly identified. Problem $3$b: Office Allocation with Seniority

The HR manager has decided to include consideration of the employees' seniority in the decision. Revise your decision model to include using the Employee Seniority Ranking to weight their preference scores. An employee's Preference Score with a higher Seniority Rank is worth more than an employee's Preference Score with a lower Seniority Rank. Rerun Solver to find a new solution.

$-$ Task $3$b$\mathrm{.}1$: State the objective function as a mathematical formula.

$-$ Task $3$b$\mathrm{.}2$: Identify all constraints.

$-$ Task $3$b$\mathrm{.}3$: Build an appropriate decision model in Excel.

$-$ Task $3$b$\mathrm{.}4$: Set up constraints with "left side" and "right side".

$-$ Task $3$b$\mathrm{.}5$: Binary constraints connected to model?

$-$ Task $3$b$\mathrm{.}6$: Solver dialog set up properly?

$-$ Task $3$b$\mathrm{.}6\mathrm{.}1$: $-$objective cell

$-$ Task $3$b$\mathrm{.}6\mathrm{.}2$: $-$constraints

$-$ Task $3$b$\mathrm{.}6\mathrm{.}3$: $-$correct engine

$-$ Task $3$b$\mathrm{.}7$: Solution stated or clearly identified.