10.1 - Overtime.xlsx - Q Reasoning Company Employee Last First Mon Ackers Jill Bartel Channing First Last Hill Jonah Jackson Five Yu Tu Daily Hours

10.1 - Overtime.xlsx - Q Reasoning Company Employee Last...

This preview shows page 1 - 2 out of 2 pages.

Q Reasoning Company Employee Daily Hours Worked Last First Mon Tue Wed Thu Fri Hourly Wage Total Hours Ackers Jill 4 4 4 4 4 $ 12.50 Bartel Channing 11 10 4 5 10 $ 10.00 First Last 9 7.5 6.5 7 13 $ 10.00 Hill Jonah 2 1 0 1.5 0.1 $ 2.25 Jackson Five 12 8 14 22 16 $ 45.00 Yu Tu 5 8 7 8 7 $ 150.00 Last First Hours Over 40 Ackers Jill Bartel Channing First Last Hill Jonah Jackson Five Yu Tu Last First Weekly Salary Ackers Jill Bartel Channing First Last Hill Jonah Jackson Five Yu Tu
Image of page 1
You run a company with 6 employees. Create a spreadsheet that keeps track of the hours each employee works and determines their weekly salary. If they work 40 hours or less they simply get their hourly wage times the number of hours worked.
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Spring '16
  • Salary, hourly wage, Jonah, Bartel

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture