Question: 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

Case - 2 Scheduling Model A post office requires

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. TABLE4 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 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. 3. Develop the mathematical linear model of the problem. (Format: Use Equation Editor in MSWord) 4. Solve the problem in MSExcel Solver. Provide results both in Excel and Word files

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!