spreadsheet 1

spreadsheet 1 - Employee Jack Jenny James Howard Ilya Louis...

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

View Full Document Right Arrow Icon
CS170 SPEADSHEETS 1 SECTION 5 TINGLIN LIU CHENHAO MICHAEL MAI Data for Last Quarter Employee Hours Base Pay rate Total Base Pay Sales Commission Rate Commission Pay Advances Bonus Total Pay Jack 320 $30.00 $9,600.00 $99,000.00 2.00% $1,980.00 $200.00 $980.00 $12,760.00 Jenny 450 $30.00 $13,500.00 $400,000.00 2.00% $8,000.00 $400.00 $2,000.00 $23,900.00 James 390 $30.00 $11,700.00 $10,000.00 2.00% $200.00 $2,300.00 $100.00 $14,300.00 Howard 680 $30.00 $20,400.00 $110,000.00 5.00% $5,500.00 $290.00 $3,400.00 $29,590.00 Ilya 570 $49.25 $28,072.50 $200,000.00 2.00% $4,000.00 $450.00 $2,300.00 $34,822.50 Louis 700 $30.00 $21,000.00 $230,000.00 2.00% $4,600.00 $900.00 $4,000.00 $30,500.00 Yanni 320 $30.00 $9,600.00 $430,000.00 2.00% $8,600.00 $723.00 $8,000.00 $26,923.00 Will 350 $30.00 $10,500.00 $230,000.00 8.00% $18,400.00 $1,200.00 $12,000.00 $42,100.00 kevin 540 $30.00 $16,200.00 $31,000.00 2.00% $620.00 $1,800.00 $450.00 $19,070.00 Cindy 660 $30.00 $19,800.00
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 12/28/2011 for the course 198 170 taught by Professor Kristianstout during the Spring '10 term at Rutgers.

Page1 / 2

spreadsheet 1 - Employee Jack Jenny James Howard Ilya Louis...

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