Excel Tutorial 1 - Hours Worked Hourly Rate Regular Pay...

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

View Full Document Right Arrow Icon
Advanced Payroll Spreadsheet Employee Hours Worked Hourly Rate Regular Pay Overtime Pay Mary Ann Bailey 45 9.5  $380.00   $71.25  George Crockett 36 7.25  $261.00   $-    David Zimmer 25 8.35  $208.75   $-    TOTAL 106  $849.75   $71.25  Assumptions Regular Hours 40 Overtime Rate 1.5
Background image of page 1

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

View Full DocumentRight Arrow Icon
Total Gross Pay  $451.25   $261.00   $208.75   $921.00 
Background image of page 2
Advanced Payroll Spreadsheet Employee
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Hours Worked Hourly Rate Regular Pay Mary Ann Bailey 45 9.5 $380.00 George Crockett 36 7.25 $261.00 David Zimmer 25 8.35 $208.75 TOTAL 106 $849.75 Assumptions Regular Hours 40 Overtime Rate 1.5 Overtime Pay Total Gross Pay $71.25 $451.25 $- $261.00 $- $208.75 $71.25 $921.00...
View Full Document

Page1 / 4

Excel Tutorial 1 - Hours Worked Hourly Rate Regular Pay...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online