Please Help with Deliverables a, b and c!! (Please Post Excel Answers/Explanations)

Thank you!

Scheduling a Call Center Century Bank has received many complaints from its customers about long waiting times on the phone before they can talk to an agent. The calls usually concern making inquiries about the bank or making requests on customer accounts. All the calls to all the phone lines of the bank are directed to a centralized call center. The bank is trying to hire enough agents to be able to answer the calls in a timely manner. Several months ago, the bank hired a management consulting firm to estimate the number of calls the bank receives each hour of the day across all its phone lines. The consultants monitored the calls closely for several weeks and accounted for all the missed calls and/or repeat calls. The consultant team eventually determined the average number of calls the airline should expect during each hour of a weekday. The following table provides the estimates. Century bank has many Spanish speaking customers as well as English speaking customers. To improve customer experience, the company wants to hire employees with skills in each language to be able to answer all the calls. The consultant company does some further research and finds out that 20 percent of the calls are in Spanish and the rest are in English. The consultants observe that an operator can process an average of five calls per hour. The bank has both full-time and part-time employees available to staff the phone lines. A full-time employee works eight hours per day but needs to work on paperwork for four hours each day, so they can only answer calls for 4 hours each day. To balance the schedule, the employee alternates shift between answering phones and completing paperwork. Full-time employees can start their day either by answering phones or by completing paperwork on the first shift. Full-time employees speak either Spanish or English, but none of them are bilingual. Both Spanish-speaking and Englishspeaking employees are paid $15 per hour for work before 5PM and $18 per hour for work after 5 PM. Full-time employees can begin work at 7AM, or 9AM, or 11AM, or 1 PM. Part-time employees work for four hours, only answer calls, and only speak English. They can start work at 3 PM or 5 PM, and, like the full-time employees, they are paid $15 per hour for work before 5 PM and $18 per hour for work after 5 PM. For the following analysis, consider only the labor cost for the time employees spend answering phones. The cost for paperwork time is charged to other cost centers. Deliverables: Deliverables are one Excel file that includes the sheets that you work on and a Word file that includes explanations. The specific deliverables for each step are listed in the relevant step description. Deliverables should be uploaded by one group member but should include the names of all group members. Please also indicate each group member's percentage of contribution to the assignment. a. Formulate a linear programming model to determine how many full-time employees who speak Spanish, full-time employees who speak English, and part-time employees to start work in each shift the bank should hire to minimize operating costs while answering all calls. Write the algebraic formulation of the linear programming problem in the Word file. b. Obtain an optimal solution for the linear programming model formulated in part b using Excel Solver (Show your work in Excel and please write an explanation in the Word file). c. Because many full-time workers do not want to work late into the evening, the bank can find only one qualified English-speaking operator willing to begin work at 1 PM. Given this new