Quote worksheet calculator
Estimate an Australian electrical quote worksheet total from entered material cost, labour hours, labour rate, margin and GST.
labour cost = labour hours x labour rate; cost subtotal = material cost + labour cost + other cost; margin amount = cost subtotal x margin percent; subtotal ex GST = cost subtotal + margin amount; GST amount = subtotal ex GST x GST percent; total inc GST = subtotal ex GST + GST amount- Material cost, labour hours, labour rate, other cost, margin and GST are entered assumptions.
- Margin is applied to the cost subtotal before GST.
- GST is calculated from the entered percentage.
- A margin below the review threshold is flagged for checking.
| Variable | Meaning | Unit | Use |
|---|---|---|---|
| M | Material cost | AUD | Entered material cost before GST. |
| H | Labour hours | h | Entered labour-hours value for the worksheet. |
| R | Labour rate | AUD/h | Entered labour rate for the worksheet. |
| L | Labour cost | AUD | Labour hours times labour rate. |
| O | Other cost | AUD | Entered allowance such as plant, freight or small items before GST. |
| Csub | Cost subtotal | AUD | Material cost plus labour cost plus other cost. |
| Pmargin | Margin percent | % | Entered margin percentage. |
| Margin | Margin amount | AUD | Cost subtotal times margin percent. |
| GSTpct | GST percent | % | Entered GST percentage. |
| Total | Total inc GST | AUD | Subtotal ex GST plus GST amount. |
More
Quote worksheet calculator technical guide
Estimate an Australian electrical quote worksheet total from entered material cost, labour hours, labour rate, margin and GST.
Quote worksheet calculator technical guide
Use this calculator when the estimating task is to combine material cost, labour hours, labour rate, other cost, margin and GST into one worksheet total. It keeps each row visible so a reviewer can see whether the result is driven by material, labour, margin or the GST setting.
This page is intentionally a worksheet. It does not decide scope, tax treatment, supplier validity, productivity or business policy. The calculator uses the numbers entered on screen and returns a subtotal, margin amount, subtotal ex GST, GST amount and total inc GST.
Quote Worksheet Use Cases
| Work setting | Useful input | Output to record |
|---|---|---|
| Small variation | Material cost, labour hours and margin. | Total inc GST and margin amount. |
| Service work estimate | Labour hours, labour rate and small-item allowance. | Cost subtotal and GST row. |
| Tender row check | Material, labour and other cost split. | Subtotal ex GST before review. |
| Low-margin review | Tight margin percentage and current costs. | Review state before the figure is used. |
A strong worksheet separates material, labour and other cost. A weak worksheet hides everything inside one lump sum and makes it hard to see whether the labour basis, material cost or margin is the real driver.
Input Responsibility
| Input | Calculator treatment | Outside the calculator |
|---|---|---|
| Quote reference | Carried into the result record. | Scope naming and document control. |
| Material cost | Added to the cost subtotal before margin. | Product selection, supplier validity and delivery terms. |
| Labour hours | Multiplied by the entered labour rate. | Productivity estimate and site conditions. |
| Labour rate | Used only for this worksheet. | Business rate policy and award or contract settings. |
| Other cost | Added before margin. | Plant, freight, permits, small items and project-specific allowances. |
| Margin | Applied to the cost subtotal. | Commercial policy and management review. |
| GST | Applied from the entered percentage. | Current tax treatment and professional advice where needed. |
The calculator does not know whether a supplier price has expired, whether the scope changed, or whether a labour allowance reflects current access conditions. Those assumptions belong with the estimate basis.
Review Workflow
- Enter a quote reference that matches the estimate or variation row.
- Enter material cost before GST.
- Enter labour hours and the labour rate used for this worksheet.
- Add other cost allowances that should sit in the same row.
- Enter the margin percentage and GST percentage.
- Review the cost subtotal, margin amount, GST amount and total inc GST.
- If the margin review state appears, check the material, labour and overhead basis before using the total.
This workflow keeps the arithmetic clear without turning the page into a full estimating workflow. Use the labour-hours calculator first when the labour quantity itself needs its own calculation.
Worked Australian Examples
| Situation | Inputs | Output reading | Practical note |
|---|---|---|---|
| Small commercial variation | $4,200 material, 36.5 h at $95/h, $650 other cost, 18% margin and 10% GST. | $10,796.12 inc GST. | Good for a clear variation row before review. |
| Low-margin review | $9,800 material, 52 h at $92/h, $1,100 other cost, 4% margin and 10% GST. | Margin review state. | Check material validity, labour basis and overhead allowance. |
| Ex GST worksheet | GST entered as 0%. | Total equals subtotal ex GST. | Keep the ex GST basis visible in the estimate record. |
The examples use Australian dollars, GST language and metric project estimating context. They do not replace project scope review or tax advice.
Boundary With Related Tools
Use the material markup and GST calculator when the question is one material line rather than a whole worksheet. Use the labour-hours calculator when labour hours are not yet known. Use the cable cost and quantity calculator when material quantity still needs a takeoff row.
| Task | Use this page? | Better route when not this page |
|---|---|---|
| Combine material, labour, other cost, margin and GST rows. | Yes. | Not applicable. |
| Calculate labour hours and crew-days first. | No. | Labour hours calculator. |
| Calculate cable material quantity and cost. | No. | Cable cost and quantity calculator. |
| Check one material markup and GST row. | No. | Material markup and GST calculator. |
Australian Estimating Boundary
Electrical estimating can be affected by drawing revisions, supplier validity, freight, site access, supervision, commissioning, shutdown windows, tax treatment and business margin policy. This calculator does not judge those inputs. It calculates from the values entered and gives a review prompt when the margin is below the worksheet threshold.
Keep the exported record with the estimate basis. Recalculate when labour hours, material pricing, GST treatment, project scope or margin policy changes.
Stop Points
- Material cost is copied from an old supplier value.
- Labour hours are entered without a documented productivity basis.
- Other cost hides major freight, plant or access constraints.
- Margin is below the review threshold and has not been checked.
- GST treatment is uncertain for the way the estimate will be used.
- Scope, drawings or site conditions changed after the worksheet was prepared.
Small commercial variation
A variation row combines entered cable material cost, labour hours, other cost, margin and GST.
- Reference
- QUOTE-1
- Material
- $4,200
- Labour
- 36.5 h at $95/h
- Margin
- 18%
- Labour cost$3,467.5
- Cost subtotal$8,317.5
- Margin$1,497.15
- GST$981.47
quote-estimate from entered worksheet values.
The result is a transparent worksheet total that keeps material, labour, other cost, margin and GST separate for review.
- Material cost is entered from the current estimate basis.
- Labour hours and labour rate are entered estimating values.
- GST percentage and margin are entered assumptions.
Low-margin review
A tight worksheet is checked before the estimate basis is carried forward.
- Reference
- QUOTE-REVIEW
- Material
- $9,800
- Labour
- 52 h at $92/h
- Margin
- 4%
- Labour cost$4,784
- Cost subtotal$15,684
- Margin$627.36
- GST$1,631.14
margin-review from entered worksheet values.
The low-margin review state keeps the commercial assumption visible before the worksheet number is used.
- Supplier validity and labour productivity remain external inputs.
- Other cost is entered as a worksheet allowance.
- Competent review can override the margin threshold.