Question: please use Excel!!!!! Question Set 1. A manager has tracked days worked and Pizzas sold as given below. Winter Jan Feb Spring Mar 22 20
please use Excel!!!!!
Question Set 1. A manager has tracked days worked and Pizzas sold as given below. Winter Jan Feb Spring Mar 22 20 Winter Dec Apr Days Worked Summer Jun Jul Aug 12 19 19 24 20 24 18 Seasons Cashier April Ron Andy Leslie Ann Tom May 13 19 9 11 Autumn Sep Oct Nov 9 16 18 12 21 17 14 15 17 15 25 26 28 13 25 12 15 22 Winter Jan Feb 378 Spring Apr 572 Winter Dec Mar May 3 Pizzas Sold Summer Jun Jul Aug 285 388 437 414 72 24 761 289 Seasons Cashier April Ron Andy Leslie Ann Tom 36 Autumn Sep Oct Nov 132 494 545 276 139 264 296 252 276 27 8 414 412 345 396 378 572 264 25 1. For each cashier, compute his or her overall productivity (in Pizzas 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 Pizzas 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 Pizzas 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) Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
