spreadsheet1 - Employees JaySly JoeGood TedFree KatWill...

Info icon This preview shows pages 1–4. Sign up to view the full content.

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 
Image of page 1

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

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  $200.00  $2,000.00  $400.00  $650.00  $1,100.00  $1,330.00  $445.00  $700.00  $865.00  $784.00  $300.00  $1,244.00  $550.00  $0  $950.00  $11,004.00  $8,900.00 $17,464.00 
Image of page 2
CS170 Spreadsheet Assignment 1 Section 10 Cap City Inc. Sales Staff Payroll Data for Last Month Employees 
Image of page 3

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

Image of page 4
This is the end of the preview. Sign up to access the rest of the document.
  • Spring '09
  • Ganu
  • Harshad number, spreadsheet assignment, Jon Doe Tito Fox Hec Tig, Fox Hec Tig, Hec Tig Column, Tig Column Totals

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern