spreadsheet3 - Employees JaySly JoeGood TedFree KatWill...

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

View Full Document Right Arrow Icon
CS170 Spreadsheet Assignment 2 Section: 10  Employees  Hours Base Pay Rate Jay Sly 50 $20.00  Joe Good 70 $20.00  Ted Free 85 $20.00  Kat Will 100 $20.00  Jen Ace 150 $20.00  Dan Rather 110 $20.00  Mad Hat 89 $20.00  Jon Doe 56 $20.00  Tito Fox 38 $20.00  Hec Tig 20 $20.00  Column Totals $768.00  $200.00  Sales $0.00 $1,000.00 $5,000.00 $10,000.00 $20,000.00 $100,000.00 Number of Cells with Values 10 10 Number of Cells with just text 0 0 Maximum 150 $20.00 Minimum 20 $20.00 Average 76.80 $20.00 Jay Sly; $1,000.00 Joe Good; $1,400.00 Ted Free; $1,700.00 Kat Will; $2,000.00 Dan Rather; $2,200.00 Mad Hat; $1,780.00 Jon Doe; $1,120.00 Tito Fox; $760.00 Hec Tig; $400.00
Image of page 1

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

View Full Document Right Arrow Icon
CS170 Spreadsheet Assignment 2 Section: 10  Jen Ace; $3,000.00
Image of page 2
CS170 Spreadsheet Assignment 2 Section: 10  Cap City Inc. Sales Staff Payroll Data for Last Month Total Base Pay Sales  Commisision Rate $1,000.00  $3,000.00  1.00% $1,400.00  $4,500.00  1.00% $1,700.00  $100,000.00  10.00% $2,000.00  $10,000.00  3.00% $3,000.00  $50,000.00  5.00% $2,200.00  $4,000.00  1.00% $1,780.00  $6,500.00  2.00% $1,120.00  $8,900.00  2.00% $760.00  $9,800.00  2.00% $400.00  $11,000.00  3.00% $15,360.00  $207,700.00  Commision 0% 1% 2% 3% 5% 10% 10 10 10 0 0 0 $3,000.00 $100,000.00 10% $400.00 $3,000.00 1% $1,536.00 $20,770.00 3%
Image of page 3

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

View Full Document Right Arrow Icon
CS170 Spreadsheet Assignment 2 Section: 10 
Image of page 4
CS170 Spreadsheet Assignment 2 Section: 10  Commission Pay Advances Total Pay $30.00  $500.00 $530.00  $45.00  $1,000.00  $445.00  $10,000.00  $1,200.00 
Image of page 5

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

View Full Document Right Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

{[ 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