Practice Exam 2

Practice Exam 2 - $72,375 $87,261 Year 2005 Total Employee...

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

View Full Document Right Arrow Icon
Employees Page 1 Employee Data Date Sales Performance: Projected: SSN Last Name First Name Division Position 2003 2004 2005 2006 Base Pay Bonus Total Pay Income Tax Table 987-31-4524 Fernandez Jeff A Manager $85,356 $91,246 $99,067 Tax Rate: 987-50-1388 Nelson Jack C Sales Rep $70,594 $76,576 $87,045 Income 2003 2004 2005 2006 987-68-8252 Beaumont Ryan A Sales Rep $70,343 $75,378 $80,856 $0 15% 17% 18% 20% 987-87-5116 Volmer Steve B Manager $47,643 $53,467 $56,543 $10,000 20% 22% 24% 27% 988-06-1980 Alexander George B Sales Rep $45,245 $45,876 $48,457 $20,000 24% 26% 29% 32% 988-24-8844 Jones Jessica A Sales Rep $59,876 $65,478 $70,077 $30,000 29% 32% 35% 39% 988-43-5708 Smith Harold C Sales Rep $101,234 $121,345 $123,238 $40,000 33% 36% 40% 44% 988-62-2572 Long Anne C Manager $83,457 $85,678 $102,456 $50,000 35% 39% 42% 47% 988-80-9436 Red Phil C Sales Rep $69,876
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $72,375 $87,261 Year: 2005 Total: Employee Base Pay Column Number: 4 Average: Manager Sales Rep 2005 Division A Summary Maximum: 2003 $41,000 $33,000 Days until Taxes Due: Number of Employees: Minimum: 2004 $43,050 $34,650 Sales by Managers: Stand. Dev.: 2005 $45,203 $36,383 Sales by Reps: # over $80,000: 2006 $47,463 $38,202 Total Sales: Average Managers: 2005 Division B Summary Average Reps: Number of Employees: Sales by Managers: Sales by Reps: SSN Last Name First NameDivision Position 2003 2004 2005 2006 Base Pay Bonus Total Pay Total Sales: 2005 Division C Summary Number of Employees: Sales by Managers: Sales by Reps: Total Sales: Marketing Loan Yearly Cost: Loan Amount: Interest Rate:...
View Full Document

This note was uploaded on 10/25/2011 for the course I SYS 101 taught by Professor Mckell,l during the Fall '08 term at BYU.

Ask a homework question - tutors are online