There are three Tasks and Please Make sure Task 2 is veri important. We need actual excel file's screenshot with formulars and asnwers.Thanks

Task 1. Describe the problem, then formulate the problem into a Linear Programming model.

Task 2. Use the Solver from Excel Spreadsheet to solve the formulated LP model formulated. (Show actual excel file's screenshot with formulars and asnwers.)

Task 3. Summarize solver solution results and use the solver sensitivity outputs report to answer questions asked at the end of the project.

Mexico City Bank of Commerce and Industry at a specific location is a busy bank branch. Due to different number of customers need services at different times, the branch manager would like to assign different numbers of tellers at the counter to optimize the overall daily operation costs. The table below indicates the number of bank tellers needed at different hours of the day at one of its branches. . Employees. The branch will use two different types of tellers: Full-time Tellers and Part-time Tellers. The following is a summary of the info. * Full-time Employees: - Full-time tellers work from 9 a.m. to 5 p.m. Each Full-time Employee will be paid $100 per day on average. - The bank branch currently has employed 18 Full-time Employees and will not hire more in the near future. However, the manager may use only a portion of the Full-Time Employees in the Branch and relocate the rest to other branches. Relocation of each employee will cost the branch $10 per day. That is, the cost of each relocated employee to the branch is $10 a day, instead of $100 a day. - Each Full-time employee will have one-hour lunchtime break. To effectively use the workforce, the manager will divide the Full-time employees in this branch into 2 groups. Group 1 will be assigned lunchtime between 11 am-noon, and the reminding Group 2 will be assigned lunchtime between noon-1 pm. * Part-time Employee: The bank branch will hire Part-time Employees, many are available, to cover part of the tellers needed. Each part-time employee will work for one of the 4-hour shifts with the shift starting time from 9am,10am,11am,12pm, and 1pm. - Each part-timer will be paid $48 per 4-hour shift (\$12 per hour) on average. - There is no lunchtime for part-timers. * In addition, the bank limits part-time hours to a maximum of 40% of the daily labor hours. In addition, the bank limits part-time hours to a maximum of 40% of the daily labor hours. The bank manager needs to make the best decisions on (i) The number of full-time employees to be used in the branch; (ii) The lunch schedule for the full-time employees working in the bank branch; (iii) The number of part-time employees to hire for Each 4-hour shift, so that the total operating costs are minimized. You can use the Linear Programming method learned to help the manager to make the optimal decision. More specifically, we need to complete the following Part 1. Formulate the problem into a Linear Programming model. Note: In order to answer questions in Part 3b i) and b ii), you need to define the Number of Full time Employees to relocate to the other branches as a decision variable. Part 2. Solve the Linear Programming using Excel Solver. Mexico City Bank of Commerce and Industry at a specific location is a busy bank branch. Due to different number of customers need services at different times, the branch manager would like to assign different numbers of tellers at the counter to optimize the overall daily operation costs. The table below indicates the number of bank tellers needed at different hours of the day at one of its branches. . Employees. The branch will use two different types of tellers: Full-time Tellers and Part-time Tellers. The following is a summary of the info. * Full-time Employees: - Full-time tellers work from 9 a.m. to 5 p.m. Each Full-time Employee will be paid $100 per day on average. - The bank branch currently has employed 18 Full-time Employees and will not hire more in the near future. However, the manager may use only a portion of the Full-Time Employees in the Branch and relocate the rest to other branches. Relocation of each employee will cost the branch $10 per day. That is, the cost of each relocated employee to the branch is $10 a day, instead of $100 a day. - Each Full-time employee will have one-hour lunchtime break. To effectively use the workforce, the manager will divide the Full-time employees in this branch into 2 groups. Group 1 will be assigned lunchtime between 11 am-noon, and the reminding Group 2 will be assigned lunchtime between noon-1 pm. * Part-time Employee: The bank branch will hire Part-time Employees, many are available, to cover part of the tellers needed. Each part-time employee will work for one of the 4-hour shifts with the shift starting time from 9am,10am,11am,12pm, and 1pm. - Each part-timer will be paid $48 per 4-hour shift (\$12 per hour) on average. - There is no lunchtime for part-timers. * In addition, the bank limits part-time hours to a maximum of 40% of the daily labor hours. In addition, the bank limits part-time hours to a maximum of 40% of the daily labor hours. The bank manager needs to make the best decisions on (i) The number of full-time employees to be used in the branch; (ii) The lunch schedule for the full-time employees working in the bank branch; (iii) The number of part-time employees to hire for Each 4-hour shift, so that the total operating costs are minimized. You can use the Linear Programming method learned to help the manager to make the optimal decision. More specifically, we need to complete the following Part 1. Formulate the problem into a Linear Programming model. Note: In order to answer questions in Part 3b i) and b ii), you need to define the Number of Full time Employees to relocate to the other branches as a decision variable. Part 2. Solve the Linear Programming using Excel Solver