Excel3 - KATO Payroll-Spring 2010 Data for Last Quarter Employee Hours Base Pay Rate Kevin 245 $49.25 Peter 295 $30.00 Dave 320 $30.00 Joe 375

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

View Full Document Right Arrow Icon
1 Kevin Cuddihy KATO Payroll -Spring 2010 Data for Last Quarter Employee Hours Base Pay Rate Total Base Pay Sales Commision Rate Commission Pay Advances Bonus Total Pay Kevin 245 $49.25 $21,000.00 $10,000.00 #NAME? #NAME? $2,000.00 $150.00 #NAME? Peter 295 $30.00 $18,750.00 $9,500.00 #NAME? #NAME? $2,000.00 $150.00 #NAME? Dave 320 $30.00 $18,000.00 $11,000.00 #NAME? #NAME? $2,000.00 $150.00 #NAME? Joe 375 $30.00 $15,000.00 $12,000.00 #NAME? #NAME? $2,000.00 $150.00 #NAME? Dan 400 $30.00 $12,066.25 $13,000.00 #NAME? #NAME? $2,000.00 $150.00 #NAME? Ryan 500 $30.00 $12,000.00 $14,000.00 #NAME? #NAME? $2,000.00 $150.00 #NAME? Casey 600 $30.00 $11,250.00 $15,000.00 #NAME? #NAME? $2,000.00 $150.00 #NAME? Jordan 700 $30.00 $9,600.00 $16,000.00 #NAME? #NAME? $2,000.00 $150.00 #NAME? Connor 275 $30.00 $8,850.00 $17,000.00 #NAME? #NAME? $2,000.00 $150.00 #NAME? Sean 625 $30.00 $8,250.00 $18,000.00 #NAME? #NAME? $2,000.00 $150.00 #NAME? 4335 $319.25 $24.00 $135,500.00 #NAME? #NAME? $20,000.00 $1,500.00 #NAME? Sales Commission $- 0% $10,000.00 1% $20,000.00 2% $40,000.00 3% $75,000.00 4% $100,000.00 5% $200,000.00 10% 11 12 20 22 12 12 12 12 12 12 11 1 2 4 1 12 12 1 1 12 0 4335 200000 21000 135500 #NAME? #NAME? 20000 1500 #NAME? 0 245
Background image of page 1

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

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

This note was uploaded on 10/17/2011 for the course COMP APPS CS 170 taught by Professor Appenzeller during the Spring '11 term at Rutgers.

Page1 / 6

Excel3 - KATO Payroll-Spring 2010 Data for Last Quarter Employee Hours Base Pay Rate Kevin 245 $49.25 Peter 295 $30.00 Dave 320 $30.00 Joe 375

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