EMPLOYEE SCHEDULING 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 in the table below. 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 fulltime employees. Its objective is to minimize the number of full-time employees on its payroll. Employee Requirements Day of Week Monday Tuesday Wednesday Thursday Friday Saturday Sunday Minimum Number of Employees Required 12 13 15 19 14 16 11 a) Suppose the company has 25 full-time employees and is not allowed to hire or fire any of them. Determine a schedule that maximizes the number of weekend days off received by these employees. b) Suppose that the company can require the employees to work one day of overtime each week on the day immediately following this five-day shift. For example, an employee whose regular shift is Monday to Friday can also be required to work on Saturday, Each employee is paid $100 per day for each of the first five days worked during a week and $124 for the overtime day (if any). Determine how the company can minimize the cost of meeting its weekly work requirements. forthe Model and solve the "a" and "b" options problem entitled "EmployeeScheduling" in Excel. 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 in the table below. Company policy states that each Vill-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 time employees. Its objective is to minimize the number of full-time employees on its payroll Employee Requirements Day of Week MA Min Number of Employees Required Wednesday Thursday Friday Saturday Sund 12 15 19 14 16 a) Develop a linear model that relates five-day shift schedules to dal numbers of employees available, and find a schedule that uses the fewest number of employees and meets all daily workforce requirements. b) Modify the employee scheduling model so that employees are paid $10 per hour on weekdays and $15 per hour on weekends. Change the objective so that you now minimize the weekly payroll (You can assume that each employee works eight hours per day) is the previous optimal solution still optimal? c) Suppose that each full-time employee works eight hours per day. Thus, Monday's requirement of 17 employees can be viewed as a requirement of (17) - 136 hours. The company can meet its daily labor requirements by using both full-time and part-time employees. During each week, a full-time employee works eight hours per day for five consecutive days, and a part-time employee works four hours per day for five consecutive days. A fil-time employee costs the company $15 per hour, whereas a part-time employee (with reduced fringe benefits) costs the company only $10 per hour. Company policy limits part-time labor to 25% of weekly labor requirements. Modify the model as necessary to minimize the company's weekly labor costs d) Suppose the employees want more flexibility in their schedules. They want to be allowed to work five consecutive days followed by two days off or to work three consecutive days followed by a day off, followed by two consecutive days followed by another day off. Modily the onginal model (with integer constraints) to allow this Tecility Might this be good deal for management as well as labor? Explain 1) Suppose the company has 25 full-time employees and is not allowed to hire or fire any of them. Determine a schedule that maximize the number of weekend days off received by these employees 9) Suppose that the company can require the employees to work one day of overtime each week on the day immediately following this five-day shift. For example, employee whose regular his Monday to Friday can also be required to work on Saturday. Each employee is paid $100 per day for each of the first five days worked during a week and $124 for the overtime day (if any). Determine how the company can minimize the cost of meeting its weekly work requirements EMPLOYEE SCHEDULING 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 in the table below. 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 fulltime employees. Its objective is to minimize the number of full-time employees on its payroll. Employee Requirements Day of Week Monday Tuesday Wednesday Thursday Friday Saturday Sunday Minimum Number of Employees Required 12 13 15 19 14 16 11 a) Suppose the company has 25 full-time employees and is not allowed to hire or fire any of them. Determine a schedule that maximizes the number of weekend days off received by these employees. b) Suppose that the company can require the employees to work one day of overtime each week on the day immediately following this five-day shift. For example, an employee whose regular shift is Monday to Friday can also be required to work on Saturday, Each employee is paid $100 per day for each of the first five days worked during a week and $124 for the overtime day (if any). Determine how the company can minimize the cost of meeting its weekly work requirements. forthe Model and solve the "a" and "b" options problem entitled "EmployeeScheduling" in Excel. 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 in the table below. Company policy states that each Vill-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 time employees. Its objective is to minimize the number of full-time employees on its payroll Employee Requirements Day of Week MA Min Number of Employees Required Wednesday Thursday Friday Saturday Sund 12 15 19 14 16 a) Develop a linear model that relates five-day shift schedules to dal numbers of employees available, and find a schedule that uses the fewest number of employees and meets all daily workforce requirements. b) Modify the employee scheduling model so that employees are paid $10 per hour on weekdays and $15 per hour on weekends. Change the objective so that you now minimize the weekly payroll (You can assume that each employee works eight hours per day) is the previous optimal solution still optimal? c) Suppose that each full-time employee works eight hours per day. Thus, Monday's requirement of 17 employees can be viewed as a requirement of (17) - 136 hours. The company can meet its daily labor requirements by using both full-time and part-time employees. During each week, a full-time employee works eight hours per day for five consecutive days, and a part-time employee works four hours per day for five consecutive days. A fil-time employee costs the company $15 per hour, whereas a part-time employee (with reduced fringe benefits) costs the company only $10 per hour. Company policy limits part-time labor to 25% of weekly labor requirements. Modify the model as necessary to minimize the company's weekly labor costs d) Suppose the employees want more flexibility in their schedules. They want to be allowed to work five consecutive days followed by two days off or to work three consecutive days followed by a day off, followed by two consecutive days followed by another day off. Modily the onginal model (with integer constraints) to allow this Tecility Might this be good deal for management as well as labor? Explain 1) Suppose the company has 25 full-time employees and is not allowed to hire or fire any of them. Determine a schedule that maximize the number of weekend days off received by these employees 9) Suppose that the company can require the employees to work one day of overtime each week on the day immediately following this five-day shift. For example, employee whose regular his Monday to Friday can also be required to work on Saturday. Each employee is paid $100 per day for each of the first five days worked during a week and $124 for the overtime day (if any). Determine how the company can minimize the cost of meeting its weekly work requirements