Spreadsheet: 2ad6c3c3-ef7b-496b-b726-216c528a5f3f
Sheet: Instructions

Average Weekly Earnings Calculator
 | INSTRUCTIONS  (NOTE this spreadsheet must be saved locally and opened in Excel.)
 | The calculator is useful when a worker has earned different amounts each week and it is necessary to determine a weekly rate that reflects an average over the preceding 12 months, or lesser period if appropriate.
 | Before using the calculator it is necessary to identify what amounts are included and excluded from the calculation of AWE.
 | 1.Enter the following details at the top of the sheet:    -  Claim number    -  Employer name     -  Worker name     -  Worker birth date (dd/mm/yyyy)    -  The end date of the last full pay period (dd/mm/yyyy)    -  The start date of the first full pay period (dd/mm/yyyy) i.e. the day after the last pay day.    -  The date of injury (dd/mm/yyyy)    -  Completed by    -  GST input tax credit    -  Pay frequency (weekly, fortnightly, monthly, four weekly)
 | 2. Enter the base wage, allowances, overtime and non-cash benefit values.
 | Please note:  A value must be entered for each pay period, even if the value is $0 (nil). The results from this calculator should be used as guide only.  The AWE calculator contains macros and a full installation of Microsoft Excel is needed. To use the calculator, macros must be enabled.
 | 3. Once completed, save the file.
 | HELPFUL DEFINITIONS
 | The start date of the first full pay period | This is the first day of a full pay period. For example if payed weekly on a Friday this date would be a Saturday regardless of the number of days a week they work.
 | Average weekly  earnings | The amount that the worker earned during the period of 12 months preceding the date of injury (or lesser period if appropriate). Chapter 8a of the Injury and Case Management Manual provides further information on how to identify the components to be included and excluded when calculating the AWE.
 | Base Wage: | The Gross (before tax) Weekly Salary - including  - any amount paid while the worker was on annual, sick or other leave  - and any amount that has been the subject of a voluntary salary sacrifice, by the worker, including   salary sacrifice for superannuation purposes.  - shift allowance   - Penalty rates  - leave loading  Please note: this does not include any contribution paid or payable by the employer to a superannuation scheme for the benefit of the worker.
 | Allowances: | Any allowances paid by the employer to the worker, e.g uniform allowance or working at height allowance.  Please note: the Case Manager will need evidence of the payment of any allowance for the period relevant to the calculation of Average Weekly Earnings.
 | Overtime: | Overtime is the time worked in addition to a worker's usual hours of employment (refer to section 4(12) of the Workers Rehabilitation and Compensation Act). For example: a worker might work a full 7.6 hour day, then continue to work for a further two hours. The additional two hours may be classed as overtime, depending on the terms of any relevant award or industrial agreement.
 |  | Overtime is to be included in the AWE calculation if the worker worked overtime during the 12 months preceding the injury (or lesser period if appropriate) and the worker has reasonable expectation that it would continue in the foreseeable future.
 | Non cash benefit: | Any non-cash benefit received by the worker as part of remuneration, eg, a company vehicle or mobile phone.  Please note:  a non-cash benefit will not be included in Average Weekly Earnings if the benefit is retained.  Evidence of the benefit and the equivalent weekly monetary value must be provided to the Case Manager.
 | Average weekly earnings do not include:
 |  | - employer contributions to a scheme for superannuation benefits (other than contributions made from money payable to the worker)
 |  | - overtime if it was not reasonably expected to continue.
 |  | - non Cash Benefits that are retained by the worker
 | 7