excel3 - KATO Payroll -Spring 2010 Data for Last Quarter...

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 1.00% $100.00 $2,000.00 $150.00 $31,250.01 Peter 295 $30.00 $18,750.00 $9,500.00 0.00% $0.00 $2,000.00 $150.00 $28,400.00 Dave 320 $30.00 $18,000.00 $11,000.00 1.00% $110.00 $2,000.00 $150.00 $29,260.01 Joe 375 $30.00 $15,000.00 $12,000.00 1.00% $120.00 $2,000.00 $150.00 $27,270.01 Dan 400 $30.00 $12,066.25 $13,000.00 1.00% $130.00 $2,000.00 $150.00 $25,346.26 Ryan 500 $30.00 $12,000.00 $14,000.00 1.00% $140.00 $2,000.00 $150.00 $26,290.01 Casey 600 $30.00 $11,250.00 $15,000.00 1.00% $150.00 $2,000.00 $150.00 $26,550.01 Jordan 700 $30.00 $9,600.00 $16,000.00 1.00% $160.00 $2,000.00 $150.00 $25,910.01 Connor 275 $30.00 $8,850.00 $17,000.00 1.00% $170.00 $2,000.00 $150.00 $26,170.01 Sean 625 $30.00 $8,250.00 $18,000.00 1.00% $180.00 $2,000.00 $150.00 $26,580.01 4335 $319.25 $13.00 $135,500.00 0.90% $1,260.00 $20,000.00 $1,500.00 $273,026.34 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 1 1 1 1 1 0 4335 200000 21000 135500 1.00% 1260 20000 1500 273026.34 0 245 0 0 9500 0.00% 0 2000 150 25346.26 n/a 788.18 24757.69
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...

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