CS
spreadsheet3

# spreadsheet3 - Employees JaySly JoeGood TedFree KatWill...

• Notes
• 17

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

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

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

CS170 Spreadsheet Assignment 2 Section: 10  Jen Ace; \$3,000.00
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%

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

CS170 Spreadsheet Assignment 2 Section: 10
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

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

This is the end of the preview. Sign up to access the rest of the document.
• Spring '09
• Ganu
• Harshad number, Dan Rather, spreadsheet assignment, Jon Doe Tito Fox Hec Tig, Jay Sly, Jen Ace Dan

{[ snackBarMessage ]}

### What students are saying

• 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.

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

• 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.

Dana University of Pennsylvania ‘17, Course Hero Intern

• 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.

Jill Tulane University ‘16, Course Hero Intern