excel1 - 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 $12,066.25 $10,000.00 8.00% $800.00 $2,000.00 $150.00 $11,016.25 Peter 295 $30.00 $8,850.00 $9,500.00 2.00% $190.00 $2,000.00 $150.00 $7,190.00 Dave 320 $30.00 $9,600.00 $11,000.00 2.00% $220.00 $2,000.00 $150.00 $7,970.00 Joe 375 $30.00 $11,250.00 $12,000.00 2.00% $240.00 $2,000.00 $150.00 $9,640.00 Dan 400 $30.00 $12,000.00 $13,000.00 2.00% $260.00 $2,000.00 $150.00 $10,410.00 Ryan 500 $30.00 $15,000.00 $14,000.00 2.00% $280.00 $2,000.00 $150.00 $13,430.00 Casey 600 $30.00 $18,000.00 $15,000.00 2.00% $300.00 $2,000.00 $150.00 $16,450.00 Jordan 700 $30.00 $21,000.00 $16,000.00 2.00% $320.00 $2,000.00 $150.00 $19,470.00 Connor 275 $30.00 $8,250.00 $17,000.00 2.00% $340.00 $2,000.00 $150.00 $6,740.00 Sean 625 $30.00 $18,750.00 $18,000.00 5.00% $900.00 $2,000.00 $150.00 $17,800.00 4335 319.25 134766.25 135500 0.029 3850 20000 1500 120116.25
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 / 2

excel1 - 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