Electrician Labour Rate Calculator

I need a clean, well-structured Excel workbook that lets me plug in every expense tied to an electrician and instantly see the true labour recharge rate we should be billing.

Core costs to be captured
• Labour and wages (hourly rates only)
• Overhead and administrative costs, specifically the software and tools we use to run the business
• Insurance premiums
• Vehicle hire fees and ongoing vehicle costs

Functionality
The sheet must let me update each of these figures quickly, apply any on-cost percentages I specify (super, holiday pay, etc.), roll everything into an annual total, then divide back to an accurate hourly charge-out rate. A separate section should let me add a profit margin so I can test different mark-ups without touching the underlying cost model.

Deliverables
• An unlocked Excel workbook with formulas and cell protection where appropriate
• A brief “how-to” tab explaining where to enter figures and where results appear
• Formulas that are transparent and easy to audit—no hidden macros unless absolutely necessary

Acceptance criteria
The final spreadsheet must reproduce the correct hourly rate when I benchmark it with my own sample numbers and let me alter any individual cost without breaking downstream calculations.