Spreadsheet 3

Spreadsheet 3 - Employee Bill William Amrita Obama...

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

View Full Document Right Arrow Icon
CS170 Spreadsheet 3 Section 22 Sharath Chirupati Eric Hammer Eric's Burgerland Payroll Spring 2011 Data for Last Quarter Employee Hours Base Pay Rate Total Base Pay Sales Commission Rate Commission Pay Advances Bonus Bill 360 $30.00 $10,800.00 $15,000.00 1.00% $150.00 $2,500.00 $150.00 William 420 $30.00 $12,600.00 $100,000.00 5.00% $5,000.00 $1,250.00 $1,000.00 Amrita 700 $49.25 $34,475.00 $320,000.00 10.00% $32,000.00 $3,000.00 $12,800.00 Obama 300 $30.00 $9,000.00 $200,000.00 10.00% $20,000.00 $1,000.00 $2,000.00 Voldemort 280 $30.00 $8,400.00 $150,000.00 5.00% $7,500.00 $750.00 $1,500.00 Scuz 560 $30.00 $16,800.00 $75,000.00 4.00% $3,000.00 $2,000.00 $1,875.00 Cyprus 480 $30.00 $14,400.00 $300,000.00 10.00% $30,000.00 $1,750.00 $3,000.00 Homeboy 400 $30.00 $12,000.00 $260,000.00 10.00% $26,000.00 $2,080.00 $2,600.00 Sunshine 540 $30.00 $16,200.00 $180,000.00 5.00% $9,000.00 $1,170.00 $1,800.00 Smalls 600 $30.00 $18,000.00 $240,000.00 10.00% $24,000.00 $1,200.00 $2,400.00 Column Totals 4640 $319.25 $152,675.00 $1,840,000.00 7.00% $156,650.00 $16,700.00 $29,125.00 Sales Commission $0.00 0.00% $10,000.00 1.00% $20,000.00 2.00% $40,000.00 3.00% $75,000.00 4.00% $100,000.00 5.00% $200,000.00 10.00% Cells with values 12 20 22 12 12 12 12 12 Cells with just text 1 2 4 1 1 1 1 1 Largest value 4640 $200,000.00 $152,675.00 $1,840,000.00 10.00% $156,650.00 $16,700.00 $29,125.00 Smallest value 280 $0.00 $0.00 $15,000.00 1.00% $150.00 $750.00 $150.00 Average value 843.64 $24,757.69 $16,963.90 $334,545.45
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 09/27/2011 for the course ECON 101 taught by Professor Gottlieb during the Spring '08 term at Rutgers.

Page1 / 12

Spreadsheet 3 - Employee Bill William Amrita Obama...

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