Question 7: 15 points The customer support manager needs some assistance staffing the customer service phone center. They currently staff the center from 6am to 6pm Monday through Friday. They staff part-time people on shifts that are 3 consecutive days from either 6 am to noon or noon to 6 pm (they don't work the morning and afternoon on a single shift and don't switch between morning and afternoon.) They also have engineers staffed on shifts that are two consecutive days from 6 am to 6 pm. Part- timers who work the morning shift get $10.50 per hour, afternoon workers get $10.80 per hour and engineers get $24.80 per hour. The following table outlines the number of people required in the morning and afternoon. Monday 4 6 Morning Afternoon Tuesday 9 6 Wednesday 11 7 Thursday 7 Friday 7 4 4 Management wants to staff at least 1 engineer for every 3 part-time employees on any given morning or afternoon. The part-time people are staffed through a staffing agency that charges a fixed cost of $15 per person each week. Develop an Excel model to determine the optimum number of people to hire. Question 7: 15 points The customer support manager needs some assistance staffing the customer service phone center. They currently staff the center from 6am to 6pm Monday through Friday. They staff part-time people on shifts that are 3 consecutive days from either 6 am to noon or noon to 6 pm (they don't work the morning and afternoon on a single shift and don't switch between morning and afternoon.) They also have engineers staffed on shifts that are two consecutive days from 6 am to 6 pm. Part- timers who work the morning shift get $10.50 per hour, afternoon workers get $10.80 per hour and engineers get $24.80 per hour. The following table outlines the number of people required in the morning and afternoon. Monday 4 6 Morning Afternoon Tuesday 9 6 Wednesday 11 7 Thursday 7 Friday 7 4 4 Management wants to staff at least 1 engineer for every 3 part-time employees on any given morning or afternoon. The part-time people are staffed through a staffing agency that charges a fixed cost of $15 per person each week. Develop an Excel model to determine the optimum number of people to hire