Lesson 2 of 8 · 18 min
Wages, salaries and overtime
Convert an annual salary to weekly, fortnightly and monthly pay, and calculate wages from an hourly rate with overtime, penalty rates and allowances, including on a spreadsheet wage sheet.
What you will be able to do
- Convert an annual salary to weekly, fortnightly or monthly pay.
- Calculate wages from an hourly rate, including overtime and penalty rates.
- Add allowances to find gross pay.
- Compare a salary with an hourly wage.
- Read and write the formulas in a spreadsheet wage sheet.
People in paid work are usually paid in one of two ways. A salary is a fixed amount for a year's work, paid in equal instalments, so the pay is the same whether the week was busy or quiet. A wage is paid by the hour, so the pay depends on how many hours were worked, and when.
Definition
The language of pay
- Gross pay is total earnings before tax and other deductions. Net pay is what reaches your bank account.
- Ordinary hours are the standard hours of a full-time week, usually 38 in Australia.
- Overtime is work beyond the ordinary hours, paid at a higher rate: time-and-a-half is the ordinary rate and double time is the ordinary rate.
- Penalty rates are higher rates for work at unsociable times, such as weekends, public holidays and nights. The award or agreement sets them.
- Allowances are extra payments for particular conditions or costs, such as tools, travel or meals.
| Pay period | Number in a year | From an annual salary |
|---|---|---|
| Weekly | 52 | divide by 52 |
| Fortnightly | 26 | divide by 26 |
| Monthly | 12 | divide by 12 |
Worked example
Weekly, fortnightly and monthly pay from a salary
Hana is a graduate engineer on an annual salary of $78 650. Calculate her pay (a) per week, (b) per fortnight and (c) per month. Give each answer correct to the nearest cent.
Step 1: Divide by 52 for weekly pay
A year is taken as 52 weeks.
Step 2: Divide by 26 for fortnightly pay
. As a check, this is exactly double the weekly pay.
There are 26 fortnights in 52 weeks.
Step 3: Divide by 12 for monthly pay
Try it yourself first, then check the working one step at a time.
Answer
(a) $1512.50 per week (b) $3025.00 per fortnight (c) $6554.17 per month.
Method
Weekly pay is the annual salary divided by 52.
Fortnightly pay is the annual salary divided by 26.
Monthly pay is the annual salary divided by 12.
Watch out for
Finding monthly pay as four times the weekly pay (). A month is about 4.33 weeks, so always go through the annual amount.
Ben earns an annual salary of $91 260. What is his fortnightly pay?
Common mistake
A month is not four weeks
To turn monthly pay into weekly pay, go through the year. $5200 a month is a year, which is a week. Dividing by 4 gives $1300, which overstates the weekly pay, because a month is about 4.33 weeks.
For a wage earner, gross pay is the hours worked times the hourly rate. Hours beyond the ordinary 38, or at unsociable times, earn more for each hour. The multiplier is always applied to the ordinary hourly rate: at $30 an hour, time-and-a-half is an hour and double time is $60 an hour.
Drag the slider to change the ordinary rate, and watch the graph bend at 38 hours.
Hours worked run across and gross pay runs up. Up to 38 hours the pay rises by the ordinary rate for each hour. After that the line is steeper, because each overtime hour pays 1.5 times as much.
Key idea
Gross pay from an hourly rate
Pay each band of hours at its own rate, then add any allowances:
Liam earns $27.60 an hour. One week he works 38 ordinary hours and 5 hours at time-and-a-half. Calculate his gross pay for the week.
Worked example
A week with overtime, a Sunday shift and an allowance
Tom is a cook paid $29.40 an hour. His award pays:
- 38 ordinary hours, Monday to Friday, at the ordinary rate
- weekday overtime at time-and-a-half for the first 2 hours each day, then double time
- all Sunday hours at double time
- a meal allowance of $17.85 on any weekday he works more than 2 hours of overtime.
This week Tom works his 38 ordinary hours, 3 hours of overtime on Thursday and 5 hours on Sunday. Calculate his gross pay for the week.
Step 1: Pay for the ordinary hours
Step 2: Work out the overtime rates
Time-and-a-half: an hour. Double time: an hour.
Overtime and penalty rates are multiples of the ordinary hourly rate.
Step 3: Pay for Thursday's overtime
The first 2 hours are at time-and-a-half and the third is at double time:
Step 4: Pay for the Sunday hours
Step 5: Add the allowance and total
Thursday had more than 2 hours of overtime, so the meal allowance is paid once:
An allowance is a flat amount. It is added on, not multiplied by an overtime rate.
Step 6: Check with equivalent ordinary hours
Tom was paid for ordinary-rate hours. , and . The two methods agree.
Try it yourself first, then check the working one step at a time.
Answer
Tom's gross pay for the week is $1576.05.
Method
Pay the ordinary hours at the ordinary rate.
Find each overtime or penalty rate as a multiple of the ordinary rate.
Pay each band of hours at its own rate.
Add any allowances as flat amounts, then total.
Watch out for
Paying all 3 overtime hours at the same rate. Read where each band starts and stops.
Multiplying the meal allowance by an overtime rate. Allowances are flat amounts.
Allowances are paid on top of wages for particular conditions or expenses: a tool allowance for a tradesperson who supplies their own tools, a vehicle allowance per kilometre for using your own car for work, a meal allowance when overtime runs late, or a first-aid allowance. They are flat amounts, or amounts per kilometre or per day, and they are not multiplied by overtime rates.
A plumber receives a tool allowance of $21.40 a week and a vehicle allowance of 98 cents per kilometre. One week she drives 186 km for work. Calculate her total allowances for the week.
To compare a salary with a wage, put them in the same period. A job paying $34.20 an hour for 38 hours a week pays a year, a little less than a $68 000 salary.
Pay is not the only difference. Permanent employees get paid annual leave and sick leave. Casual employees usually receive a casual loading on their hourly rate instead (25% under most awards), but their hours can change from week to week and they are not paid when they don't work.
An employer with many workers keeps a wage sheet: a spreadsheet with one row per employee. Each formula is written once, in the first row, and filled down. Filling down updates the row numbers automatically, so =B2*C2 in row 2 becomes =B3*C3 in row 3.
=B2*C2+1.5*B2*D2, filled down from row 2, and E6 holds =SUM(E2:E5).| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Employee | Rate ($/h) | Ordinary hours | Overtime hours (×1.5) | Gross pay ($) |
| 2 | A. Nguyen | 28.40 | 38 | 4 | 1249.60 |
| 3 | B. Wilson | 31.15 | 38 | 0 | 1183.70 |
| 4 | C. Patel | 26.80 | 30 | 0 | 804.00 |
| 5 | D. Okafor | 28.40 | 38 | 6.5 | 1356.10 |
| 6 | Total | 4593.40 |
Tip
Spreadsheet formulas
- Every formula starts with
=and uses*to multiply and/to divide. - Use cell references such as
B2, not typed numbers, so a result updates when an input changes. =SUM(E2:E5)adds a column. In the wage sheet it gives the total wage bill, $4593.40.- To keep one cell fixed while you fill down, such as an overtime multiplier stored in cell H1, write it as
$H$1.
In a wage sheet, cell B2 holds an employee's ordinary hourly rate and cell D2 holds their hours at time-and-a-half. Which formula gives their overtime pay?
Exam tip
In the exam
Set out each band of hours on its own line with its rate, such as "", so a marker can award method marks even if a later step slips. Penalty and overtime multipliers apply to the ordinary hourly rate, never to the whole week's pay.
Summary
Salary to pay period: divide by 52 (weekly), 26 (fortnightly) or 12 (monthly). Monthly to weekly goes through the year: .
Time-and-a-half is the ordinary rate and double time is ; pay each band of hours at its own rate.
Allowances are flat amounts (or per km or per day) added to gross pay.
Compare a salary and a wage in the same period, and remember leave, casual loading and job security.
A wage sheet writes each formula once and fills it down;
=SUM(...)totals a column.
Finished the lesson?
Try the 4 quick checks above and the lesson completes itself, or mark it complete now.