TO BUILD A SIMPLE BUT COMPREHENSIVE WAGE BUDGET FOR YOUR BUSINESS

CAPTURING ALL THE COSTS ASSOCIATED WITH STAFF BEYOND JUST BASE RATE AND SUPER TO ADD INTO YOUR PRODUCT COSTINGS

TO BETTER DETERMINE YOUR PROFITABILITY

TO ALLOW BUSINESS OWNERS AT A HIGH LEVEL TO SEE WHAT THEIR WAGE COSTS ARE AND TAKE ACTION TO REDUCE THEM OR BETTER DEPLOY RESOURCES

STAFF COST INPUT TAB - REVIEW THIS FIRST

FILL IN DATA INTO YELLOW CELLS ONLY

BLUE CELLS INDICATE AN AUTO CALCULATION

GREEN CELLS INDICATE THAT YOU CAN CHANGE THIS DATA IF NEEDED, BUT WE HAVE PUT THE BASE INFO IN AND ADVISE NOT TO CHANGE UNLESS NEEDED

THEN MOVE TO THE STAFF COST TEMPLATE TOTAL COSTS TAB

COLUMN A - ENTER STAFF NAMES IF YOU WAN TO. YOU CAN ALSO REMOVE THIS COLUMN IF YOU WISH TO JUST FOCUS ON THE ROLE

COLUMN B - ENTER THE ROLE TITLE

COLUMN C - (DROP DOWN BOX) SELECT YOUR COST CENTRE THAT YOU HAVE POPULATED ON THE STAFF COSTS INPUT TAB

COLUMN D - SELECT FROM THE DROP DOWN THE TYPE OF CONTRACT THE ROLE OR EMPLOYEE HAS

COLUMN E- ENTER THE NUMBER OF HOURS THE EMPLOYEE IS REQUIRED TO WORK S PER THEIR CONTRACT. 38 HOURS IS THE MAX IN AUSTRALIA, BUT SOME EMPLOYEES ON HIGHER WAGES MAY BE REQUIRED TO WORK 40

COLUMN F -I - AUTO CALC DO NOT ENTER DATA

COLUMN J - ENTER THE EMPLOYEE'S BASE PAY RATE. NOTE, IF YOU WORK ON ANNUALISED FIGURES TO GET THEIR HOURLY RATE DIVIDE ANNUAL SALARY BY NUMBER OF HOURS WORKED DIVIDED BY 52

E.G., IF EMPLOYEE EARNS $80,000 BASE RATE AND WORKS 38 HOURS PER WEEK, 80,000/38 = 2,105.26 / 52 =40.486 PER HOUR

COLUMN K - IF SOMEONE IS PART TIME OR FT, SELECT YES. IF SOMONE IS CASUAL, SELECT NO. IF SOMEONE IS ON A CONTRACT, DETERMINE WHAT APPLIES AS PER THE CONTRACT YOU HAVE IN PLACE

COLUMN L-O - AUTOCALC DO NOT ENTER DATA

COLUMN P - DETERMINE IF ANNUAL LEAVE LOADING APPLIES TO THIS ROLE. SELECT FROM DROP DOWN

COLUMN Q-S - AUTOCALC DO NOT ENTER DATA

COLUMN T - DETERMINE IF ALLOWANCES APPLY TO ROLE. SELECT FROM DROPDOWN

COLUMN U-W - AUTOCALC NO DATA REQUIRED

COLUMN X - DETERMINE MOBILE PHONE ALLOWANCE THAT APPLIES AND SELECT FROM DROPDOWN

COLUMN Y - AUTOCALC DO NOT ENTER DATA

COLUMN Z - DETERMINE CAR ALLOWANCE THAT APPLIES AND SELECT FROM DROPDOWN

COLUMN AA - AUTOCALC DO NOT ENTER DATA

COLUMN AB - DETERMINE IF FIRST AID ALLOWANCE IS PAYABLE AND SELECT FROM DROP DOWN

COLUMN AC - AUTOCALC DO NOT ENTER DATA

COLUMN AE-AK - AUTOCALC DO NOT ENTER DATA

COLUMN AL - DETERMINE IF BENEFITS APPLY TO THIS ROLE AND SELECT FROM DROP DOWN

COLUMN AM-AP - AUTOCALC DO NOT ENTER DATA

COLUMN AQ - DETERMINE IF BONUSES APPLY TO THIS ROLE AND SELECT FROM DROP DOWN

COLUMN AR-AS - AUTOCALC DO NOT ENTER DATA

COLUMN AT - ENTER THE NUMBER OF EXPECTED HOURS OF OVERTIME FOR THIS ROLE PER WEEK

COLUMN AU- ENTER THE OVERTIME PENALTY AS A % (150% FOR TIME AND A HALF, 200% FOR DOUBLE TIME, 0% IF NO OVERTIME RATE)

COLUMN AW - ENTER THE RATE OF SUPERANNUATION THAT YOUR BUSINESS PAYS. FROM JULY 2025, THIS RATE WILL BE 12%. ADVISE TO WORK OFF THIS

COLUMN AX-BA - AUTOCALC DO NOT ENTER DATA

COLUMN AV- THIS IS THE TOTAL HOURLY COST OF THIS ROLE AND EMPLOYEE ADDING UP ALL ALLOWANCES, EXTRAS SUPER, LEAVE RATES ETC AS DETAILED IN THE SHEET

COLUMN AW - THIS IS THE TOTAL ANNUAL COST OF THIS ROLE AND EMPLOYEE ADDING UP ALL ALLOWANCES, EXTRAS SUPER, LEAVE RATES ETC AS DETAILED IN THE SHEET

COLUMN AX- THIS IS THE PERCENTAGE COST OF THIS ROLE AND EMPLOYEE ADDING UP ALL ALLOWANCES, EXTRAS SUPER, LEAVE RATES ETC AS DETAILED IN THE SHEET COMPARED TO ALL OF YOUR WAGE COSTS

NOTE - FOR THE BELOW CELLS ALIGN THE COLUMN NUMBER WITH THE TOTALS ROW (THE ACTUAL CELL LISTED BELOW MIGHT HAVE CHANGED IF YOU ADDED MORE STAFF IN)

CELL AV26- THIS IS THE TOTAL HOURLY COST OF TALL EMPLOYEES ADDING UP ALL ALLOWANCES, EXTRAS SUPER, LEAVE RATES ETC AS DETAILED IN THE SHEET

CELL AW26 - THIS IS THE TOTAL ANNUAL COST OF ALL EMPLOYEES ADDING UP ALL ALLOWANCES, EXTRAS SUPER, LEAVE RATES ETC AS DETAILED IN THE SHEET

CELL E26 - THIS IS THE TOTAL NUMBER OF HOURS WORKED BY YOUR TEAM PER WEEK BASED ON YOUR ASSUMPTION/AVERAGE AND CONTRACTS

CELL E26 - THIS IS THE TOTAL NUMBER OF HOURS WORKED BY YOUR TEAM PER YEAR BASED ON YOUR ASSUMPTION/AVERAGE AND CONTRACTS

CELL I26 - THIS IS TO TOTAL BASE WAGE COST (EX ADDITIONAL COSTS) TO YOUR BUSINESS EVERY YEAR

CELLBB26 - THIS IS THE AVERAGE TOTAL HOURLY RATE ADDING UP YOUR WAGE COSTS AND ALLOWANCES DIVIDED BY THE NUMBER OF STAFF YOU HAVE (CELL BD26)

THIS IS A SIMPLE TOOL THAT MAY REQUIRE AVERAGES OR ASSUMPTIONS. IT IS BETTER TO SLIGHTLY OVER ESTIMATE THAN UNDERESTIMATE

IN OUR OPINION, WHILE SOME O/T CANT BE AVOIDED IF WE ARE RELIANT ON O/T, IT SUGGESTS THE BUSINESS IS PLANNING POORLY, HAS POOR PROCESSES, IS NOT EFFICIENT OR NOT AS PRODUCTIVE AS POSSIBLE

THIS MAY NOT APPLY TO SOME BUSINESSES SUCH AS TRANSPORT WHERE O/T IS REQUIRED FOR THE BUSINESS TO FUNCTION

THIS TOOL ASSUMES THAT SUPER IS PAID ON ANY REGULAR ALLOWANCE SUCH AS CAR, PHONE, FIRST AID AND BONUS PAYMENTS

THIS TOOL ASSUMES THAT NO SUPER IS PAID ON OTHER BENEFITS

THIS TOOL ASSUMES THAT ALLOWANCES FOR PPE, TRAINING, AND UNIFORM ARE COSTS INCURRED BY THE BUSINESS NOT BY THE EMPLOYEE

IF YOU HAVE OTHER ALLOWANCES OR EXTRAS YOU PAY (E.G., ALLOWANCE FOR A GYM MEMBERSHIP, HEALTH INSURANCE ETC) ENTER THIS AS 'OTHER' AND AS THE TOTAL COST

THIS SHEET IS NOT LOCKED TO ALLOW FOR USERS WITH ADVANCED EXCEL USERS TO ADD DETAIL AS NEEDED. IF DATA IS DELETED OR OVERRIDDEN, MOSHIE IS NOT LIABLE FOR ANY DATA CORRECTION

IF DATA IS DELETED OR OVERRIDDEN OR AUTO CALCULATION CELLS ARE DELETED, MOSHIE IS NOT LIABLE FOR ANY DATA CORRECTION

THIS SHEET DOES NOT MAKE ALLOWANCES FOR ANY UNPAID LEAVE THAT MIGHT BE TAKEN

THIS SHEET DOES NOT MAKE ALLOWANCES FOR THE COST OF ANY LEAVE THAT MAY HAVE NOT BEEN TAKEN AND ROLLED OVER/ACCRUED FROM YEAR TO YEAR

THIS TOOL WAS DESIGNED FOR AUSTRALIAN BASED BUSINESSES AND MAY NOT BE APPLICABLE IN OTHER JURISDICTIONS

THIS TOOL WAS CREATED IN 2024 AND WILL REQUIRE UPDATES AS NEEDED AS PER ANY NEW INDUSTRIAL RELATIONS LEGISLATION CHANGES

IF YOU ARE WORKING OUT A COST FOR YOUR PRODUCTION LABOUR, ONLY USE THE ROLES THAT ARE INVOLVED IN PRODUCING OR GETTING YOUR PRODUCT OUT TO CUSTOMERS. NO ADMIN, SALES, OR TRUCK DRIVERS.

THIS SHEET HAS BEEN PRODUCED TO ASSIST BUSINESSES AND NOT AS A CERTIFIED FINANCIAL TOOL