The Rutgers Camden Starbucks store has a worker scheduling challenge. From among the four different roles at the store during the busy lunchtime schedule (11am-2pm) the Starbucks manager must decide how many workers to schedule. This Starbucks Manager has two different work teams from which to choose: Team A and Team B. Consult the file in Canvas entitled, "Chapter 5 test 2 problem sensitivity analysis.xisx". This file includes a table that shows different service volumes per hour handled by Team A and Team B. This is the second of three questions that you will answer using the sensitivity analysis file. (a) You must use Excel Solver and ensure that the file is set up to "max" (maximize) the objective function (total profit). The Starbucks Manager has been informed that one of the workers who excels at Cleanup now has COVID and can't work for a week. This reduces the number of minutes of Cleanup available (cell B8) from 540 to 300 . The Manager might be able to hire a temporary new Cleanup worker and pay them additional \$ per hour to work for just one week. Using the Solver Sensitivity Report function, how much $ per hour of Cleanup worker should the Manager be willing to pay? This can be determined by the Shadow Price for Cleanup Minutes used. (Note, after you develop your answer, be sure that the values in cell B17 and C17 are cleared, and cell D8 is returned to 540 before attempting any further questions) The Rutgers Camden Starbucks store has a worker scheduling challenge. From among the four different roles at the store during the busy lunchtime schedule (11am-2pm) the Starbucks manager must decide how many workers to schedule. This Starbucks Manager has two different work teams from which to choose: Team A and Team B. Consult the file in Canvas entitled, "Chapter 5 test 2 problem sensitivity analysis.xisx". This file includes a table that shows different service volumes per hour handled by Team A and Team B. This is the second of three questions that you will answer using the sensitivity analysis file. (a) You must use Excel Solver and ensure that the file is set up to "max" (maximize) the objective function (total profit). The Starbucks Manager has been informed that one of the workers who excels at Cleanup now has COVID and can't work for a week. This reduces the number of minutes of Cleanup available (cell B8) from 540 to 300 . The Manager might be able to hire a temporary new Cleanup worker and pay them additional \$ per hour to work for just one week. Using the Solver Sensitivity Report function, how much $ per hour of Cleanup worker should the Manager be willing to pay? This can be determined by the Shadow Price for Cleanup Minutes used. (Note, after you develop your answer, be sure that the values in cell B17 and C17 are cleared, and cell D8 is returned to 540 before attempting any further questions)