Project 5 - Sales Rep List

Project 5 - Sales Rep List - 95.59% A Lopez, P M 23...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Sales Rep List c69ecca8eafb3e7af3aa3067d7447855c036eea6.xls Criteria Area Grade Table Criteria Name Gender Age Hire Date St Sales Area Quota YTD Sales % of Quota Grade % of Quota Grade Gender Gender Grade M >35 >C 0% F F M A 60% D Average Female Age =====> 29.20 70% C Average Male Age =======> 33.43 80% B Grade A Count ==========> 2 Soccer Gear Sales Rep List 93% A Name Gender Age Hire Date St Sales Area Quota YTD Sales % of Quota Grade Grade A YTD Sales Sum ===> 8,469,000 Daniel, K M 27 06/17/96 IL Outside 3,500,000 3,224,000 92.11% B Female Sales Rep Count ==> 5 Roberts, K F 32 12/15/96 FL Inside 2,525,000 1,853,000 73.39% C Madhu, D M 38 04/15/97 TX Outside 3,975,000 4,115,000 103.52% A Wells, A F 37 03/19/99 NY Inside 5,235,000 4,015,000 76.70% C Nadir, N M 42 08/12/99 TX Inside 3,325,000 1,963,000 59.04% F Bright, S F 33 02/20/00 CA Outside 4,555,000 4,354,000
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 95.59% A Lopez, P M 23 04/19/00 NY Outside 4,800,000 3,873,000 80.69% B Gilbert, C M 40 07/15/01 TN Inside 3,675,000 2,555,000 69.52% D Dresden, K M 39 10/22/01 IL Inside 4,623,000 1,856,000 40.15% F Jablonski, C F 22 12/15/02 FL Outside 3,125,000 2,150,000 68.80% D Lee, Y F 22 04/15/03 TN Outside 2,175,000 1,550,000 71.26% C Smith, R M 25 06/17/03 CA Inside 3,312,000 2,150,000 64.92% D Extract Area Name Gender Age Hire Date St Sales Area Quota YTD Sales % of Quota Grade Nadir, N M 42 08/12/99 TX Inside 3,325,000 1,963,000 59.04% F Dresden, K M 39 10/22/01 IL Inside 4,623,000 1,856,000 40.15% F Gilbert, C M 40 07/15/01 TN Inside 3,675,000 2,555,000 69.52% D...
View Full Document

Ask a homework question - tutors are online