Edition 01 · Worksheet
Shift Ledger
What one overtime day is worth, from a monthly stub.
KT
01
A one-page worksheet for people who are paid by the period and still work overtime. It keeps four numbers from the stub and turns them into an honest day rate, without a spreadsheet religion.
Two questions from one stub: what an hour paid, and what an overtime day is worth. The file is the worksheet and a worked example you overwrite.
In the file
- The four numbers to copy off a stub
- Straight day versus overtime day
- A worked 12.25-hour example
- A second pass for a rough keep-rate
Try a piece
The sample prices one day. The file is the full worksheet, including how not to average a stub.
- Straight day
- $343.00
- Overtime day
- $514.50
- Three overtime days
- $1,543.50