Question: I need help in this question. Please do it correctly in excel and show me all the steps. Please show me all the methods clearly

I need help in this question. Please do it correctly in excel and show me all the steps. Please show me all the methods clearly so i can do it myself. Please do not make any mistake.

I need help in this question. Please do it

I need help in this question. Please do itI need help in this question. Please do it

A small business requires different numbers of full-time employees on different days of the week. The number of full-time employees required each day is given as follows. Company policy states 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 Saturday and Sunday. The company wants to meet its daily requirements using only full-time employees. Its objective is to minimize the number of full-time employees on its payroll. Please build a integer programming model (number of employess must be integer) to solve this problem and find the minimum total number of employees that should be hired. M N 0 P B D E F G H 1 J K L 16 Employee scheduling model 17 18 Decision variables: number of employees starting their five-day shift on various days 19 Mon 20 Tue 21 Wed 22 Thu 23 Fri 24 Sat 25 Sun 26 27 Result of decisions: number of employees working on various days (along top) who started their shift on various days (along side) 28 Mon Tue Wed Thu Fri Sat Sun 29 Mon 30 Tue 31 Wed 32 Thu 33 Fri 34 Sat 35 Sun 36 36 37 Constraint on employee availabilities 38 Employees available 39 40 Employees required 16 41 42 Objective to maximize 73 Total employees 74 17 19 25 24 15 25

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!