I need help with question 3:

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 of10 (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 3+8=11.
• 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.

I do not know what constraints I am supposed to but using and I do not understand what my objective cell should be. I have no idea how to figure this solver problem please help!!!!