The Motor Trade Association of Western Australia (MTA WA) in conjunction with the Australian Motor Body Repairers Association (AMBRA) has developed this cost calculator tool to assist motor body repair businesses transparently identify their costs and a charge out hourly rate for their business.

This calculator has been independently analysed by national business advisory and accountancy firm BDO and examined by the Australian Tax Office (ATO).

It enables motor body repair business owners/management to capture all of the costs associated in running their businesses.

The tool also includes helpful worksheets for Profit and Loss, Tradespersons costs, and has the added potential of highlighting areas of business operations where further efficiencies can be made and/or improvements to productivity.

The use of the calculator tool is voluntary and is not a prerequisite of membership of MTA WA. It is designed to assist motor body repair business owners with an essential foundation tool in determining a reasonable ‘shop’ or ‘business’ rate by identifying the actual costs of the business.

How to use the calculator

Yellow boxes

On each page, please fill in the relevant yellow boxes on the spreadsheet and the formulas will automatically complete the totals. DO NOT enter any figures into white boxes, as these are formula cells.

Direct costs page

This page is used to determine the Total Annual Wages, Superannuation and Chargeable Hours for the business.

  • Enter the names and employment arrangements for all current staff and management in the business against the appropriate job title.
  • If there are more staff than lines, then please add additional lines as required. Please check that the formula in the TOTAL cells are correct.
  • The CLASS is a reference, refer to the green Productivity Table for the appropriate code to use.
  • The percentage (%) ON FLOOR is important as this directly affects the Total Chargeable Hours of the business. Staff may be shown under several roles, for example, 60% panel 30% workshop supervisor 10% car mover.
  • OVERTIME is calculated at time and a half. If you have staff on an Enterprise Agreement or Contract of Employment which includes an overtime component, then those hours will be included in the hours per week.
  • No SUPERANNUATION is payable on overtime.
  • For PRODUCTIVITY, please refer to the green Productivity Table for the applicable productive rate. The rate takes into account the tradeperson's skill level & learnt efficiencies, smoko, lunch & toilet breaks, moving vehicles in and out of the work bay, etc.

Indirect costs page

This page is used to determine the Indirect Costs, Parts & Subcontractor Margin, Profit to be obtain your Shop Hourly Rate.

INDIRECT COSTS - Enter the details of the future expenses of the business. You may consider using the previous year's expenses as a guide.

PARTS & SUBCONTRACTOR MARGIN - Enter the annual totals to determine the total margin.

PROFIT - Enter the profit the business requires to re-invest in the following year. You may wish to consult with your Accountant.

SHOP HOURLY RATE - This cell automatically calculates the shop rate.

REAL HOURS AVAILABLE - This cell confirms how many real hours the business has to complete a job for every $1,000 in labour charged.

If the job is completed faster the business will make more profit and if it takes longer, then the business will make less profit. This area is your recovery rate.

Profit and loss statement

This page is an example of a Profit & Loss Statement for a smash repair business.

Note:

  1. The figures used are not a true reflection of any business.
  2. Figures on this page are not linked to any other page.

Real cost of your tradesperson

This page gives you the ability to see the real cost of employing a tradesperson per hour.

Note - the figures on this page are not linked to any other page.

Adjust the information in the yellow boxes to reflect the tradespersons package to see the true cost of the tradesperson per hour.

Business and individual - performance reports

These pages show you how your business and individuals are performing on a monthly and weekly basis.
Note - they are linked to the Direct Costs page, so most fields will already have populated.

Get the calculator

Please ensure that you download and read all of the 'Guidelines" prior to using the calculator. Click on the 'Calculator' button to get the calculator, you must be logged in to the website to access the calculator. Don't know how to log in? Download login instructions HERE.

Guidelines

Caculatorv2

Liability disclaimer

This Cost Calculator tool has been developed and provided to assist Motor Body Repairer Members of State and Territory Motor Trades / Traders Associations and Automobile Chambers of Commerce, who are Member organisations of the Motor Trades Association of Australia Limited (MTAA). The Australian Motor Body Repairers Association (AMBRA) is an unincorporated industry sector organisation that operates within the MTAA for Motor Body Repair Members.

The Cost Calculator tool is provided recognising additional information and data, unknown to the MTAA, its Member and affiliated organisations, contractors and suppliers, is provided / supplied / inputted by the user, and that the user is aware of this disclaimer as a condition of its use.

All information, software, calculations, models, examples, graphical material, and any other matter included in this tool may include inaccuracies or typographical errors. MTAA and its Member and affiliated organisations, contractors and suppliers, may make improvements and / or changes to the Cost Calculator tool at any time. Advice, information, software, calculations, models, examples , graphical material, and any other matter including outcomes derived from the use of the Cost Calculator tool, should not be relied upon for personal, medical, business, legal, or financial decisions. Any users of this Cost Calculator tool should consult with and obtain information and advice from appropriate professional accountants, financial, business or other advisers for specific advice tailored for your situation.

MTAA, its Member and affiliated organisations, contractors and suppliers, make no representations about the suitability, reliability, availability, timeliness, and accuracy of the Cost Calculator tool. To the maximum extent permitted by applicable law, all information, software, calculations, models, examples, graphical material, and any other matter are provided 'as is' without warranty or condition of any kind. MTAA its Member and affiliated organisations, contractors and suppliers, hereby disclaim all warranties and conditions with regard to this information, software, calculations, models, examples, graphical material, and any other matter , including all implied warranties or conditions of fitness for a particular purpose, title and non-infringement.

To the maximum extent permitted by applicable law, in no event shall MTAA, its Member and affiliated organisations, contractors and suppliers, be liable for any direct, indirect, punitive, incidental, special, consequential, damages whatsoever including, without limitation, damages for loss of use, data or profit, arising out of, or in any way connected with the use or performance of the Cost Calculator tool. As some jurisdictions do not allow the exclusion or limitation of liability for consequential or incidental damages, the above limitation may not apply to you. If you are dissatisfied with any aspect of the Cost Calculator tool or with any of these Terms of Use, your sole and exclusive remedy to discontinue using the Cost Calculator Tool. 

MTAWA is proudly supported by