Project. Workforce Planning Mexico City Bank of Commerce and Industry is a busy bank that needs a different number of tellers depending on the time of day due to a different number of customers needed service. The table below indicates the number of workers needed at different time periods of the day when the bank is open. Employees the bank can hire two types of employees: Full time employees and Part time employees. Where . Full-time Employees: full-time tellers that work from 9 a.m. to 5 p.m. (8 hours). Each full-timer will be paid $120 per day in salary # of and benefits on average Time Period Tellers Needed . Part-time Employee: part-time employee will work on a 3-hours shift, and can be hired to cover shifts starting at any hour between 19.1.-10a.m. 10 9am and 2 pm. Each part-timer will be paid $40 per 3-hour shift on 10a.m.-17 a.m. 12 average. 11 a.m.-Noon We assume there is unlimited number of both Full time and part time Noon-1 p.m. available to be hired. 1 p.1.-2p.m. 18 2 p.M.-3p.m. 16 Lunchtime: Full-timers have 1-hour lunchtime, but there is no lunchtime for part- 3p.m.4 p.m. timers. Due the lunchroom size limitation, the manager needs to divide ..-Sp.mm. 10 the Full-timer employees' lunchtime into 2 groups. Half of the Full-timers will have lunch between 11- noon, and the rest (the 2nd group) will have lunch between noon-1pm. + Corporate policy: when making decision, the manager should also need to satisfy a corporate policy that limits part-time employees to cover a maximum of 40% of the total daily labor hour requirements. The bank manager needs to make decisions on the number of full-time employees to use, and the number of part- time employees in each 3-hour shift to hire so that the total work-force related costs are minimized. Use Linear Programming to help the bank manager to make the best part time hiring decision, i.e. to complete the taskl and task2 listed at the beginning of this guideline. Then, use the solver Sensitivity Report to answer the following questions (Task3) a) If the pay for a Full-time employee is Reduced by $10, will the optimal decision remain the same? What will be the optimal workforce-related costs now? Explain. b) Will the optimal total costs change if each Full-time employee payment is Reduced by $65 a day? Explain. c) If the required number of employees in period 10:00-11:00am is Increased to 16, How much more the bank needs to spend on workforce-related costs? Will this increase in the required number of employees leads to a change in the optimal decision on Full-time and/or Part-time employees? d) If the required number of employees in period 11:00-12:00am is Increased by 3, what will be the optimal total cost? e) If the required number of employees in period 1:00-2:00pm is reduced by 1, will the optimal total cost remain same? Repeat Again: the above questions should be answered ONLY use the information from the Sensitivity Report. It is Not Allowed to answer the questions by Re-solving the LP models with the updated parameters again and again. It is required that you explain where you come with your answer by referencing to the exact location in the Reports. Project. Workforce Planning Mexico City Bank of Commerce and Industry is a busy bank that needs a different number of tellers depending on the time of day due to a different number of customers needed service. The table below indicates the number of workers needed at different time periods of the day when the bank is open. Employees the bank can hire two types of employees: Full time employees and Part time employees. Where . Full-time Employees: full-time tellers that work from 9 a.m. to 5 p.m. (8 hours). Each full-timer will be paid $120 per day in salary # of and benefits on average Time Period Tellers Needed . Part-time Employee: part-time employee will work on a 3-hours shift, and can be hired to cover shifts starting at any hour between 19.1.-10a.m. 10 9am and 2 pm. Each part-timer will be paid $40 per 3-hour shift on 10a.m.-17 a.m. 12 average. 11 a.m.-Noon We assume there is unlimited number of both Full time and part time Noon-1 p.m. available to be hired. 1 p.1.-2p.m. 18 2 p.M.-3p.m. 16 Lunchtime: Full-timers have 1-hour lunchtime, but there is no lunchtime for part- 3p.m.4 p.m. timers. Due the lunchroom size limitation, the manager needs to divide ..-Sp.mm. 10 the Full-timer employees' lunchtime into 2 groups. Half of the Full-timers will have lunch between 11- noon, and the rest (the 2nd group) will have lunch between noon-1pm. + Corporate policy: when making decision, the manager should also need to satisfy a corporate policy that limits part-time employees to cover a maximum of 40% of the total daily labor hour requirements. The bank manager needs to make decisions on the number of full-time employees to use, and the number of part- time employees in each 3-hour shift to hire so that the total work-force related costs are minimized. Use Linear Programming to help the bank manager to make the best part time hiring decision, i.e. to complete the taskl and task2 listed at the beginning of this guideline. Then, use the solver Sensitivity Report to answer the following questions (Task3) a) If the pay for a Full-time employee is Reduced by $10, will the optimal decision remain the same? What will be the optimal workforce-related costs now? Explain. b) Will the optimal total costs change if each Full-time employee payment is Reduced by $65 a day? Explain. c) If the required number of employees in period 10:00-11:00am is Increased to 16, How much more the bank needs to spend on workforce-related costs? Will this increase in the required number of employees leads to a change in the optimal decision on Full-time and/or Part-time employees? d) If the required number of employees in period 11:00-12:00am is Increased by 3, what will be the optimal total cost? e) If the required number of employees in period 1:00-2:00pm is reduced by 1, will the optimal total cost remain same? Repeat Again: the above questions should be answered ONLY use the information from the Sensitivity Report. It is Not Allowed to answer the questions by Re-solving the LP models with the updated parameters again and again. It is required that you explain where you come with your answer by referencing to the exact location in the Reports