{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

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

View Full Document Right Arrow Icon
1 CS170 Spreadsheets 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
Image of page 1

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

View Full Document Right Arrow Icon
2 CS170 Spreadsheets 1 Section 4, Tinglin Liu Kevin Cuddihy KATO Payroll -Spring 2010 Data for Last Quarter Hours Base Pay Rate
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern