spreadsheet1

spreadsheet1 - Employees JaySly JoeGood TedFree KatWill...

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

View Full Document Right Arrow Icon
CS170 Spreadsheet Assignment Section: 10  Cap City Inc. Sales Staff Payroll Data for Last Month Employees  Hours Base Pay Rate Total Base Pay Sales  Commisision Rate Jay Sly 50 $20.00  $1,000.00  $3,000.00  5.00% Joe Good 70 $20.00  $1,400.00  $4,500.00  5.00% Ted Free 85 $20.00  $1,700.00  $100,000.00  5.00% Kat Will 100 $20.00  $2,000.00  $10,000.00  5.00% Jen Ace 150 $20.00  $3,000.00  $50,000.00  5.00% Dan Rather 110 $20.00  $2,200.00  $4,000.00  5.00% Mad Hat 89 $20.00  $1,780.00  $6,500.00  10.00% Jon Doe 56 $20.00  $1,120.00  $8,900.00  5.00% Tito Fox 38 $20.00  $760.00  $9,800.00  8.00% Hec Tig 20 $20.00  $400.00  $11,000.00  5.00% Column Totals 768 $200.00  $15,360.00  $207,700.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
CS170 Spreadsheet Assignment Section: 10  Commission Pay Advances Total Pay $150.00  $500.00 $650.00  $225.00  $1,000.00  $625.00  $5,000.00  $1,200.00  $5,500.00  $500.00  $600.00  $1,900.00  $2,500.00  $1,500.00  $4,000.00 
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.

Page1 / 4

spreadsheet1 - Employees JaySly JoeGood TedFree KatWill...

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