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 1.5×1.5 \times the ordinary rate and double time is 2×2 \times 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 periods in a year
Pay periodNumber in a yearFrom an annual salary
Weekly52divide by 52
Fortnightly26divide by 26
Monthly12divide by 12

Worked example

Weekly, fortnightly and monthly pay from a salary

  • Simple familiar
  • Technology active

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.

3 steps

Try it yourself first, then check the working one step at a time.

Method

  1. Weekly pay is the annual salary divided by 52.

  2. Fortnightly pay is the annual salary divided by 26.

  3. Monthly pay is the annual salary divided by 12.

Watch out for

  • Finding monthly pay as four times the weekly pay (4×$1512.50=$60504 \times \$1512.50 = \$6050). 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?

Round to 2 decimal places.

Common mistake

A month is not four weeks

To turn monthly pay into weekly pay, go through the year. $5200 a month is $5200×12=$62 400\$5200 \times 12 = \$62\,400 a year, which is $62 400÷52=$1200\$62\,400 \div 52 = \$1200 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 1.5×$30=$451.5 \times \$30 = \$45 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.

Interactive

Weekly pay with overtime after 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:

gross pay=(ordinary hours×rate)+(overtime hours×rate×multiplier)+allowances\text{gross pay} = (\text{ordinary hours} \times \text{rate}) + (\text{overtime hours} \times \text{rate} \times \text{multiplier}) + \text{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.

Round to 2 decimal places.

Worked example

A week with overtime, a Sunday shift and an allowance

  • Complex familiar
  • Technology active

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.

6 steps

Try it yourself first, then check the working one step at a time.

Method

  1. Pay the ordinary hours at the ordinary rate.

  2. Find each overtime or penalty rate as a multiple of the ordinary rate.

  3. Pay each band of hours at its own rate.

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

Round to 2 decimal places.

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 $34.20×38×52=$67 579.20\$34.20 \times 38 \times 52 = \$67\,579.20 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.

A wage sheet. Each cell in column E holds the formula =B2*C2+1.5*B2*D2, filled down from row 2, and E6 holds =SUM(E2:E5).
RowABCDE
1EmployeeRate ($/h)Ordinary hoursOvertime hours (×1.5)Gross pay ($)
2A. Nguyen28.403841249.60
3B. Wilson31.153801183.70
4C. Patel26.80300804.00
5D. Okafor28.40386.51356.10
6Total4593.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?

Choose one answer

Exam tip

In the exam

Set out each band of hours on its own line with its rate, such as "5×1.5×$27.60=$207.005 \times 1.5 \times \$27.60 = \$207.00", 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: ×12÷52\times 12 \div 52.

  • Time-and-a-half is 1.5×1.5 \times the ordinary rate and double time is 2×2 \times; 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.

Lesson 2 of 80% read

Save your progress with a free account