Questions

PLEASE USE EXCEL

Questions Question Set 1. A manager has tracked days worked and Donuts sold as given below. Winter Jan Feb 35 28 Spring Apr 16 Winter Dec Mar 29 May 2 Autumn Sep Oct 9 Days Worked Summer Jun Jul Aug 13 22 21 21 21 NOV 12 19 Seasons Cashier Larry Brenda Gene Tim George Karen 13 12 7 22 15 20 26 11 26 14 26 34 20 22 2B 12 60 24 Donuts Sold Winter Feb Winter Jan 478 601 Spring Mar Apr 124 472 Dec May 23 289 Autumn Sep Oct Nov 162 274 565 Summer Jun Jul Aug 235 288 547 414 72 Seasons Cashier Larry Brenda Gene Tim George Karen 156 376 127 38 276 534 412 159 264 345 396 266 298 572 364 45 252 1. For each cashier, compute his or her overall productivity (in Donuts sold per day) for Spring and Summer. You should have one number per cashier. (3pts) 2. For each cashier, compute his or her productivity (in Donuts sold per day) for Autumn. Using the MAX function, find the highest productive cashier for the Autumn among the cashiers. (3pts) 3. Compute the overall productivity for each cashier (in Donuts sold per day) for the entire year. Use the MIN function to find the lowest productive cashier for the year among the cashiers. (3 pts) 4. Which month has the lowest overall productivity? (2 pts) Questions Question Set 1. A manager has tracked days worked and Donuts sold as given below. Winter Jan Feb 35 28 Spring Apr 16 Winter Dec Mar 29 May 2 Autumn Sep Oct 9 Days Worked Summer Jun Jul Aug 13 22 21 21 21 NOV 12 19 Seasons Cashier Larry Brenda Gene Tim George Karen 13 12 7 22 15 20 26 11 26 14 26 34 20 22 2B 12 60 24 Donuts Sold Winter Feb Winter Jan 478 601 Spring Mar Apr 124 472 Dec May 23 289 Autumn Sep Oct Nov 162 274 565 Summer Jun Jul Aug 235 288 547 414 72 Seasons Cashier Larry Brenda Gene Tim George Karen 156 376 127 38 276 534 412 159 264 345 396 266 298 572 364 45 252 1. For each cashier, compute his or her overall productivity (in Donuts sold per day) for Spring and Summer. You should have one number per cashier. (3pts) 2. For each cashier, compute his or her productivity (in Donuts sold per day) for Autumn. Using the MAX function, find the highest productive cashier for the Autumn among the cashiers. (3pts) 3. Compute the overall productivity for each cashier (in Donuts sold per day) for the entire year. Use the MIN function to find the lowest productive cashier for the year among the cashiers. (3 pts) 4. Which month has the lowest overall productivity? (2 pts)