QUESTION 1

a) Develop the mathematical linear model of the problem. (Format: Use Equation Editor in MSWord)

b) Solve the problem in MSExcel Solver.

QUESTION 2

Consider the problem named Case 2: Scheduling Model with the following assumptions and relaxations:

-Assume that you have 25 candidate employees.

-You want to determine the number of employees to hire.

-Thus, each employee either will work for you or will not work for you.

-If an employee is hired, than s/he needs to work at least 3 and at most 5 days in a week.

-The days s/he works do not need to be consecutive.

a) Develop the mathematical linear model of the problem. (Format: Use Equation Editor in MSWord)

b) Solve the problem in MSExcel Solver.

Case 2 Scheduling Model A post office requires different numbers of full-time employees on different days of the week. The number of full-time employees required on each day is given in Table 4. Union rules state that each full-time employee must work five consecutive days and then receive two days off. For example, an employee who works Monday to Friday must be off on Sat- urday and Sunday. The post office wants to meet its daily requirements using only full- time employees. Formulate an LP that the post office can use to minimize the number of full-time employees who must be hired. TABLE 4 Requirements for Post Office Number of Full-time Employees Required Day 1 = Monday 2 = Tuesday 3 = Wednesday 4 = Thursday 5 = Friday 6 = Saturday 7 = Sunday 17 13 15 19 14 16 11