please help me with this problem. I am really grateful if you help me all the questions. I extremely need question 3 answer.

please help me that is all information i have

2. Formulate the model to solve the optimization problem according to the case described below following the objective and constraints required (PLEASE USE LINGO PROGRAM) 3. DO AND PROPOSE THE SENSITIVITY ANALYSIS BY HAND. Here we have the case of a call center where the staff requirements vary by the hour. The minimum requirements of staff in each hour are given in Table 7.1. Staff can start work at the beginning of any hour. The staff works for 8 hours with a rest break of 2 hours after 4 hours of duty. How many staff should be scheduled to join at the beginning of each hour such that the requirements given in Table 7.1 are met with the minimum number of staff? Pre-break hours of duty Post-break hours of duty Time of joining duty 12:00 SA 1:00 SA 2:00 SA 3:00 SA Let us take the case of staff starting work at 1 am. They are able to take care of the requirements from 1 am to 5 am and 7 am to 11 am. We can find out similar duty hours for all staff joining at the beginning of each hour from 00 am to 11 pm as listed in Table 7.2. Let us define integer decision variables x as the number of staff joining duty at the beginning of hour 1 (with the hours in 24-hour clock format), where i = 1,2...., 24. Now, if we take the time period 00 am to 1 am, Table 7.2 indicates that the staff available during this period is the sum of staff who have joined duty at 3 pm, 4pm, 5pm, 6pm, 9 pm, 10 pm, 11 pm and 00 am. Minimum Period requirement 00 am to 3 am 20 Toble 71 3 am to 6 am 16 6 am to 9 am 25 9am to 12 noon 40 12 noon to 4 pm 60 4 pm to 8 pm 30 8 pm to 00 am 25 4:00 SA 5:00 SA 6:00 SA 7.00 SA 8:00 SA 9.00 SA 10:00 SA 11:00 SA 12 noon 1:00 CH 2.00 CH 3.00 CH 4:00 CH 5.00 CH 6.00 CH 7:00 CH 8.00 CH 9.00 CH 10.00 CH 11:00 CH 00 am to 4 am 1am to 5 am 2 am to 6 am 3 am to 7 am 4 am to 8 am 5 am to 9 am 6 am to 10 am 7 am to 11 am 8 am to 12 noon 9 am to 1pm 10 am to 2 pm 11 am to 3 pm 12 noon to 4 pm 1 pm to 5 pm 2 pm to 6pm 3 pm to 7 pm 4 pm to 8 pm 5 pm to 9pm 6 pm to 10 pm 7 pm to 11 pm Bpm to 00 am 9 pm to 1 am 10 pm to 2 am 11 pm to 3 am 6 am to 10 am 7 am to 11 am 8 am to 12 noon 9 am to 1 pm 10 am to 2 pm 11 am to 3 pm 12 noon to 4 pm 1 pm to 5 pm 2 pm to 6 pm 3 pm to 7pm 4 pm to 8 pm 5 pm to 9 pm 6 pm to 10 pm 17 pm to 11 pm 8 pm to 00 am 9 pm to 1 am 10 pm to 2 am 11 pm to 3 am 00 am to 4 am 1 am to 5 am 2 am to 6 am 3 am to 7 am 4 am to sam 5 am to 9 am Table 712 Background: ABC Company is a large manufacturing company producing several types of products with many departments. There are several optimization problems needed to be solved every day in each department such as Operation, Finance, Marketing, Manufacturing and Transportation,... As a member in Optimization department, your team has to apply knowledge in OR courses to solve several problems raised by other department in the company. Requirement: 1. Formulate the model to solve the optimization problem according to the case described below following the objective and constraints required 2. Solve the model by using LINGO or CPLEX and display the solution clearly 3. Do and propose the sensitivity analysis 7. Shift Staff planning Here we have the case of a call center where the staff requirements vary by the hour. The minimum requirements of staff in each hour are given in Table 71. Staff can start work at the beginning of any hour. The staff works for 8 hours with a rest break of 2 hours after 4 hours of duty. How many staff should be scheduled to join at the beginning of each hour such that the requirements given in Table 7.1 are met with the minimum number of staff? Let us take the case of staff starting work at 1 am. They are able to take care of the requirements from 1 am to 5 am and 7 am to 11 am. We can find out similar duty hours for all staff joining at the beginning of each hour from 00 am to 11 pm as listed in Table 7.2. Let us define integer decision variables, as the number of staff joining duty at the beginning of hour (with the hours in 24-hour clock format), wherei - 1.2... 24. Now, if we take the time period 00 am to 1 am, Table 72 indicates that the staff available during this period is the sum of staff who have joined duty at 3pm, 4 pm, 5pm, 6pm, 9 pm 10 pm, 21 pm, and 00 am Period 00 am to 3 am 3 am to 6 am 6 am to 9 am 9 am to 12 noon 12 noon to 4 pm 4 pm to 8pm 8 pm to 00 am Table 7.1 Minimum requirement 20 16 25 40 60 30 25 of Pre-break hours of duty 00 am to 4 am I am to 5 am 2 am to 6 am Jam to 7 am 4 am to 8 am 5 am to 9 am 6 am to 10 am 7 am to 11 am Post-break hours of duty 6 am to 10 am 7 am to 11 am 8am to 12 noon 9am to 1pm 10am to 2 pm 8am to 12 noon Time joining duty 12:00 SA 1:00 SA 2:00 SA 3:00 SA 4:00 SA 5.00 SA 6.00 SA 7:00 SA 8.00 SA 9.00 SA 10:00 SA 11:00 SA 12 noon 1:00 CH 2:00 CH 3:00 CH 4:00 CH 5:00 CH 6.00 CH 7:00 CH 8:00 CH 9.00 CH 10:00 CH 11:00 CH Table 7.2 9am to 1 pm 10 am to 2 pm 11 am to 3 pm 12 noon to 4 pm 1 pm to 5pm 2 pm to 6pm 3 pm to 7pm 4 pm to 8pm 5 pm to 9pm 6 pm to 10 pm 7 pm to 11 pm 8pm to 00 am 9 pm to 1 am 10 pm to 2 am 11 pm to 3 am 11 am to 3 pe 12 noon to 4 pm 1 pm to 5pm 2 pm to 6pm 3 pm to 7pm 4 pm to 8pm Spm to 9 pm 6 pm to 10 pm 7pm to 11 pm 8pm to 00 am 9 pm to 1 am 10 pm to 2 am 11 pm to 3 am 00 am to 4 am 1 am to Sam 2 am to 6am 3 am to 7 am 4 am to 8 am Sam to 9 am