Spreadsheet Assignment 3 part 1 Joleen Martis

Spreadsheet - BasePay TotalBase Commissio Commissio Employee George JohnA TomJ James JohnQ Abigail Ben TomP Column totals 280.45 $165.75 $5,833.25

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

View Full Document Right Arrow Icon
Joleen Martis CS170 Spreadsheet Assignment3 Section [09] Page 1 Mood Swings Stock Brokerage May Payroll Information Employee Hours Sales Expenses Total George 28.2 $20.00 $564.00 $144,000.00 10.00% $14,400.00 $225.00 $15,189.00 John A. 34 $20.00 $680.00 $126,000.00 10.00% $12,600.00 $360.00 $13,640.00 Tom J. 40 $20.00 $800.00 $102,000.00 10.00% $10,200.00 $740.00 $11,740.00 James 20 $20.00 $400.00 $70,000.00 5.00% $3,500.00 $450.00 $4,350.00 John Q. 39 $25.75 $1,004.25 $68,000.00 5.00% $3,400.00 $570.00 $4,974.25 Abigail 41.5 $20.00 $830.00 $57,000.00 5.00% $2,850.00 $900.00 $4,580.00 Ben 44 $20.00 $880.00 $52,000.00 5.00% $2,600.00 $1,100.00 $4,580.00 Tom P. 33.75 $20.00 $675.00 $3,000.00 1.00% $30.00 $125.00 $830.00 280.45 $165.75 $5,833.25 $622,000.00 6.38% $49,580.00 $4,470.00 $59,883.25 Sales Commission 0 0.00% 1000 1.00% 5000 2.00% 10000 3.00% 20000 5.00% 100000 10.00% 10 10 17 19 10 10 10 10 10 0 0 0 0 0 0 0 0 0 0 280.45 100000 5833.25 622000 10.00% 49580 4470 59883.25 0 20 0 0 3000 1.00% 30 125 830 0 62.32 9088.77 777.78 138222.22 0.06 11017.78 993.33 13307.39 Base Pay  Rate Total Base  Pay Commissio n Rate Commissio n Column  totals
Background image of page 1

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

View Full DocumentRight Arrow Icon
Joleen Martis CS170 Spreadsheet Assignment3 Section [09] Page 2 Mood Swings Stock Brokerage May Payroll Information
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/02/2011 for the course COMP SCIEN 170 taught by Professor Kristianstout during the Spring '09 term at Rutgers.

Page1 / 6

Spreadsheet - BasePay TotalBase Commissio Commissio Employee George JohnA TomJ James JohnQ Abigail Ben TomP Column totals 280.45 $165.75 $5,833.25

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online