chap5_ho2_hremployee_solution

chap5_ho2_hremployee_solution - Title Service Hire Date...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
TripID MarktingRep Passengers Catering Customs ContractStatus Amount 1 Kenny 100 Snack TRUE Signed 25000 2 Frank 125 Breakfast FALSE Proposal 75000 3 Diane 50 Snack TRUE Signed 55000 4 Kenny 120 Lunch TRUE Proposal 45000 5 Kenny 100 Dinner TRUE Proposal 30000 6 Patty 75 Lunch TRUE Signed 65000 7 Frank 90 Dinner FALSE Signed 35000 8 Peter 100 Dinner FALSE Signed 39000 9 Bob 120 Snack FALSE Signed 45000 10 Peter 128 Snack FALSE Proposal 50000 11 Patty 105 Snack TRUE Signed 65000 12 Frank 110 Dinner TRUE Signed 78000 13 Diane 90 Breakfast TRUE Signed 100000 14 Diane 75 Lunch FALSE Signed 95000 15 Frank 100 Dinner TRUE Signed 48000 16 Frank 128 Lunch FALSE Signed 32000 17 Peter 128 Dinner TRUE Proposal 85000 18 Patty 110 Snack FALSE Proposal 92000 19 Bob 105 Snack FALSE Proposal 110000 20 Frank 115 Snack FALSE Proposal 56000 21 Kenny 104 Breakfast TRUE Signed 76000 22 Diane 100 Breakfast TRUE Signed 45000 23 Patty 90 Dinner TRUE Signed 37000 24 Peter 85 Lunch FALSE Proposal 76000 25 Peter 50 Dinner FALSE Signed 45000 26 Bob 100 Dinner FALSE Signed 67000 27 Bob 120 Dinner TRUE Signed 95000
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Name Location
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Title Service Hire Date Salary Range Names Adams Atlanta Trainee 10.9 11/24/2000 $29,500 Database =Sheet1!$A$1:$F$14 Frank Miami Manager 10.6 3/18/2001 $75,000 Milgrom Boston Manager 6.0 10/31/2005 $57,500 Smith Atlanta Account Re 5.5 4/22/2006 $65,000 Adamson Chicago Manager 10.9 11/24/2000 $52,000 Brown Atlanta Account Re 10.9 11/24/2000 $40,000 Charles Boston Account Re 10.6 3/16/2001 $40,000 Coulter Atlanta Manager 10.6 3/17/2001 $100,000 James Chicago Account Re 10.6 3/19/2001 $42,500 Johnson Chicago Account Re 10.6 3/20/2001 $47,500 Manin Boston Account Re 11.0 10/31/2000 $49,500 Marder Chicago Account Re 10.0 10/31/2001 $38,500 Rubin Boston Account Re 5.0 10/31/2006 $45,000 Name Location Title Service Hire Date Salary Smith Summary Statistics for Managers Average Salary 65000 Maximun Salary 65000 Minumun Salary 65000 Total Salary 65000 Number of Employees 1...
View Full Document

This note was uploaded on 10/19/2011 for the course BIS 155 taught by Professor Sasha during the Spring '11 term at DeVry NJ.

Page1 / 2

chap5_ho2_hremployee_solution - Title Service Hire Date...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online