Spreadsheet 2

Spreadsheet 2 - $16,504.00 $33,805.00 $41,773.50 #N/A #N/A...

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

View Full Document Right Arrow Icon
1 CS170 Spreadsheet 2 Section 22 Sharath Cirupati Eric Hammer Eric's Burgerland Sales Performance 2010 Data for last Quarter Employee Hours Base Pay Rate Total Base Pay Sales Comission Rate Comission Pay Advance Bonus Bill 240 $30.00 $7,200.00 $9,000.00 0.00% $0.00 $0.00 $0.00 Amrita 250 $30.00 $7,500.00 $10,000.00 1.00% $100.00 $50.00 $1.00 William 250 $30.00 $7,500.00 $50,000.00 3.00% $1,500.00 $100.00 $2.00 Scuz 270 $30.00 $8,100.00 $100,000.00 5.00% $5,000.00 $200.00 $3.00 Homeboy 290 $30.00 $8,700.00 $150,000.00 5.00% $7,500.00 $300.00 $4.00 Cyprus 280 $30.00 $8,400.00 $250,000.00 10.00% $25,000.00 $400.00 $5.00 Obama 310 $49.25 $15,267.50 $260,000.00 10.00% $26,000.00 $500.00 $6.00 Carmelo 280 $30.00 $8,400.00 $200,000.00 #N/A #N/A $600.00 $7.00 Voldemort 260 $30.00 $7,800.00 $300,000.00 #N/A #N/A $1,000.00 $8.00 Fez 280 $30.00 $8,400.00 $400,000.00 #N/A #N/A $2,000.00 $9.00 Total 2710 319.25 87267.5 1729000 #N/A #N/A 5150 45 SALES COMMISSION $- 0% $10,000.00 1% $20,000.00 2% $40,000.00 3% $75,000.00 4% $100,000.00 5% $200,000.00 10%
Background image of page 1

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

View Full DocumentRight Arrow Icon
1 CS170 Spreadsheet 2 Section 22 Sharath Cirupati Eric Hammer Total Pay $7,200.00 $7,651.00 $9,102.00 $13,303.00
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $16,504.00 $33,805.00 $41,773.50 #N/A #N/A #N/A #N/A 1 CS170 Spreadsheet 2 Section 22 Sharath Cirupati Eric Hammer c's Burgerland Payroll Spring 20 Data for last Quarter Hours Sales Bonus Total Pay Bill 240 $30.00 $7,200.00 ### 2.00% $180.00 $0.00 $0.00 $7,380.00 Amrita 250 $30.00 $7,500.00 ### 2.00% $200.00 $50.00 $1.00 $7,651.00 William 260 $30.00 $7,800.00 ### 2.00% ### $100.00 $2.00 $8,702.00 Scuz 270 $30.00 $8,100.00 ### 2.00% ### $200.00 $3.00 $9,903.00 Homeb 280 $30.00 $8,400.00 ### 2.00% ### $300.00 $4.00 $11,104.00 Cyprus 290 $30.00 $8,700.00 ### 2.00% ### $400.00 $5.00 $13,305.00 Obama 300 $30.00 $9,000.00 ### 2.00% ### $500.00 $6.00 $13,706.00 Carme 400 $30.00 ### ### 2.00% ### $600.00 $7.00 $16,807.00 Voldem 500 $30.00 ### ### 5.00% ### ### $8.00 $29,008.00 Fez 600 $49.25 ### ### 8.00% ### ### $9.00 $59,559.00 Total 3390 ### 113250 1799000 2.90% 68980 5150 45 177125 oyee Rate Base Pay n Rate on e...
View Full 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 / 3

Spreadsheet 2 - $16,504.00 $33,805.00 $41,773.50 #N/A #N/A...

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