Quote worksheet calculator

Estimate an Australian electrical quote worksheet total from entered material cost, labour hours, labour rate, margin and GST.

  • Calculator
  • Estimating
  • Australia
Use the estimate, work package or variation reference.
AUD
Enter the material cost before GST.
h
Enter labour hours from a labour worksheet or estimate basis.
AUD/h
Enter the labour rate used for this worksheet.
AUD
Enter allowances such as plant, freight or small items before GST.
%
Enter the margin percentage applied to the cost subtotal.
%
Enter GST percentage. Use 0 if the worksheet is ex GST only.
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.
Formula variables
VariableMeaningUnitUse
MMaterial costAUDEntered material cost before GST.
HLabour hourshEntered labour-hours value for the worksheet.
RLabour rateAUD/hEntered labour rate for the worksheet.
LLabour costAUDLabour hours times labour rate.
OOther costAUDEntered allowance such as plant, freight or small items before GST.
CsubCost subtotalAUDMaterial cost plus labour cost plus other cost.
PmarginMargin percent%Entered margin percentage.
MarginMargin amountAUDCost subtotal times margin percent.
GSTpctGST percent%Entered GST percentage.
TotalTotal inc GSTAUDSubtotal 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

Quote worksheet use cases
Work settingUseful inputOutput to record
Small variationMaterial cost, labour hours and margin.Total inc GST and margin amount.
Service work estimateLabour hours, labour rate and small-item allowance.Cost subtotal and GST row.
Tender row checkMaterial, labour and other cost split.Subtotal ex GST before review.
Low-margin reviewTight 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

Values to confirm before calculating
InputCalculator treatmentOutside the calculator
Quote referenceCarried into the result record.Scope naming and document control.
Material costAdded to the cost subtotal before margin.Product selection, supplier validity and delivery terms.
Labour hoursMultiplied by the entered labour rate.Productivity estimate and site conditions.
Labour rateUsed only for this worksheet.Business rate policy and award or contract settings.
Other costAdded before margin.Plant, freight, permits, small items and project-specific allowances.
MarginApplied to the cost subtotal.Commercial policy and management review.
GSTApplied 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

  1. Enter a quote reference that matches the estimate or variation row.
  2. Enter material cost before GST.
  3. Enter labour hours and the labour rate used for this worksheet.
  4. Add other cost allowances that should sit in the same row.
  5. Enter the margin percentage and GST percentage.
  6. Review the cost subtotal, margin amount, GST amount and total inc GST.
  7. 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

Quote worksheet examples
SituationInputsOutput readingPractical 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 worksheetGST 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.

Route boundary matrix
TaskUse 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%
  1. Labour cost$3,467.5
  2. Cost subtotal$8,317.5
  3. Margin$1,497.15
  4. GST$981.47
Total inc GST$10,796.12

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%
  1. Labour cost$4,784
  2. Cost subtotal$15,684
  3. Margin$627.36
  4. GST$1,631.14
Total inc GST$17,942.5

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.

Questions

Does this create a final quote?

No. It creates a worksheet total from entered values. Project review, scope control and tax treatment remain separate.

Where should labour hours come from?

Use a documented labour-hours estimate or another recorded basis before entering the labour row.

How is margin applied?

Margin is applied to the cost subtotal before GST is calculated.

Can GST be set to zero?

Yes. Use 0 when the worksheet is intentionally ex GST, then keep that basis clear in the estimate record.

Why does low margin trigger review?

A low margin can hide material price movement, labour assumptions or overhead gaps, so the worksheet flags it before the number is used.