- Questions Question Set 1. A manager has tracked days worked and Donuts sold as given below. Seasons Autumn Winter Winter Jan Feb Days Worked Summer Jun Jul Aug 12 Spring Apr 20 Mar Sep Oct NOV Dec May 2 31 29 8 13 Cashier Linda Bob Gene 28 12 19 18 15 19 15 6 19 24 20 19 Tina 26 11 21 17 26 31 19 23 Louise Teddy 23 12 15 22 Winter Jan Feb 378 Seasons Cashier Linda Bob Spring Mar Apr 124 572 Winter Dec Jul May 23 Autumn Sep Oct Nov 162 294 Donuts Sold Summer Jun Aug 215 388 414 72 701 136 289 38 545 276 Gene 276 27 447 Tina 434 412 139 264 345 396 296 278 Louise Teddy 572 264 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)