spreadsheet 2

spreadsheet 2 - 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
1 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 $430,000.00 10.00% $43,000.00 $723.00 $8,000.00 $61,323.00 Jenny 450 $30.00 $13,500.00 $400,000.00 10.00% $40,000.00 $400.00 $2,000.00 $55,900.00 James 700 $30.00 $21,000.00 $230,000.00 10.00% $23,000.00 $900.00 $4,000.00 $48,900.00 Howard 350 $30.00 $10,500.00 $230,000.00 10.00% $23,000.00 $1,200.00 $12,000.00 $46,700.00 Ilya 570 $49.25 $28,072.50 $200,000.00 10.00% $20,000.00 $450.00 $2,300.00 $50,822.50 Louis 680 $30.00 $20,400.00 $110,000.00 5.00% $5,500.00 $290.00 $3,400.00 $29,590.00 Yanni 320 $30.00 $9,600.00 $99,000.00 4.00% $3,960.00 $200.00 $980.00 $14,740.00 Will 540 $30.00 $16,200.00 $31,000.00 2.00% $620.00 $1,800.00 $450.00 $19,070.00 kevin 660 $30.00 $19,800.00 $22,000.00 2.00% $440.00 $2,900.00 $120.00 $23,260.00 Cindy 390
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.

Page1 / 4

spreadsheet 2 - 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