Does this validate supplier pricing?

No. Supplier price, stock, freight and validity remain outside the calculator.

Can GST be set to zero?

Yes. Use 0 for an ex-GST row and keep that basis visible in the estimate record.

How is markup applied?

Markup is applied to the material cost before GST is calculated.

Why does low markup trigger review?

Low markup can hide freight, waste, cost movement or overhead gaps, so the worksheet flags the line before it is used.

When should I use the quote worksheet instead?

Use the quote worksheet when material, labour, other cost, margin and GST need to be combined.

Material markup and GST calculator

material cost = unit cost x quantity; markup amount = material cost x markup percent; sell price ex GST = material cost + markup amount; GST amount = sell price ex GST x GST percent; total inc GST = sell price ex GST + GST amount

Unit cost, quantity, markup and GST are entered assumptions.
Markup is applied to material cost before GST.
GST is calculated from the entered percentage.
A markup below the review threshold is flagged for checking.

Formula variables
Variable	Meaning	Unit	Use
U	Unit cost	AUD	Entered material unit cost before GST.
Q	Quantity	units	Entered quantity for the material row.
Cmat	Material cost	AUD	Unit cost times quantity.
Pmarkup	Markup percent	%	Entered markup percentage.
Markup	Markup amount	AUD	Material cost times markup percent.
SellEx	Sell price ex GST	AUD	Material cost plus markup amount.
GSTpct	GST percent	%	Entered GST percentage.
Total	Total inc GST	AUD	Sell price ex GST plus GST amount.

Material markup and GST calculator technical guide

Estimate an Australian material line sell price from entered unit cost, quantity, markup and GST assumptions.

Material markup and GST calculator technical guide

Use this calculator when one material line needs a transparent sell-price record. It starts with entered unit cost and quantity, applies entered markup, then applies the entered GST percentage. The result is a material-line worksheet, not a supplier price source or tax advice tool.

The calculator is useful for Australian electrical estimates where a material row needs to be checked before it is carried into a broader quote worksheet. It keeps the markup amount, ex-GST sell price, GST amount and inc-GST total visible so a reviewer can see how the line was built.

Material Line Use Cases

Material markup use cases
Work setting	Useful input	Output to record
Material row check	Supplier unit cost and quantity.	Material cost, markup and GST.
Quote preparation	A priced material row before labour is added.	Ex-GST and inc-GST sell price.
Low-margin review	Tight markup on a known cost.	Review state before the line is used.
Variation estimate	Changed quantity or unit price.	Updated material-line total.

A strong material line keeps cost, quantity, markup and GST separate. A weak line hides all assumptions in one sell price and makes it hard to review freight, waste, validity or cost movement.

Input Responsibility

Values to confirm before calculating
Input	Calculator treatment	Outside the calculator
Line reference	Carried into the result record.	Scope naming and document control.
Unit cost	Multiplied by quantity before markup.	Supplier validity, stock, freight and price expiry.
Quantity	Multiplied by unit cost.	Takeoff accuracy and waste allowance.
Markup	Applied to material cost before GST.	Business policy, overhead and commercial review.
GST	Applied from the entered percentage.	Tax treatment and accounting advice.

The calculator does not know whether freight, waste, small items or supplier expiry are already included in the unit cost. Keep those assumptions in the estimate record.

Review Workflow

Name the material line or estimate reference.
Enter the unit cost before GST.
Enter the material quantity for the row.
Enter the markup percentage used for the estimate.
Enter the GST percentage that applies to the worksheet.
Review material cost, markup amount, ex-GST sell price, GST and total inc GST together.
Move to the quote worksheet only when the material line needs to be combined with labour and other cost rows.

This workflow keeps one material line narrow and traceable.

Worked Australian Examples

Material markup examples
Situation	Inputs	Output reading	Practical note
Switchgear material line	24 units at 48.50 AUD with 22% markup and 10% GST.	1562.09 AUD inc GST.	Markup and GST are visible separately.
Low-markup review	8 units at 125 AUD with 3% markup.	Markup review state.	Check freight, waste and business policy.
Ex-GST row	GST entered as 0.	Ex-GST total only.	Keep the tax basis clear in the estimate.

These examples use AUD and Australian estimating language. They do not validate supplier pricing, tax treatment, product suitability or final commercial terms.

Boundary With Related Tools

Use the quote worksheet when the next task is a full material, labour, other cost, margin and GST worksheet. Use cable cost and quantity when the material line starts from route lengths, waste and unit cost. Use the labour and material notes guide when the issue is how to document estimating assumptions.

Route boundary matrix
Task	Use this page?	Better route when not this page
Calculate one material line with markup and GST.	Yes.	Not applicable.
Combine material and labour into a quote total.	No.	Quote worksheet calculator.
Build cable quantity from route lengths.	No.	Cable cost and quantity calculator.
Explain estimate documentation boundaries.	No.	Electrical labour and material notes guide.

Australian Estimating Boundary

Material markup and GST is a business arithmetic worksheet. Supplier price validity, freight, waste, tax treatment, product suitability, scope control and competent review can override the row. Keep the exported record with the supplier basis and estimate reference.

Stop Points

The unit cost source is unclear or expired.
Quantity is not tied to a current takeoff.
Freight, waste or small items are missing from the basis.
GST treatment is uncertain.
The line is being used as supplier validation or tax advice.
Markup is below the review threshold and has not been checked.

Reference: MAT-1
Unit cost: 48.5 AUD
Quantity: 24
Markup: 22%
GST: 10%

Markup amount256.08 AUD
Total inc GST1562.09 AUD
Statusmarkup-estimate

Total inc GST1562.09 AUD

Markup amount 256.08 AUD.

The result gives ex-GST and inc-GST sell prices for one material line.

Unit cost is before GST.
Markup is applied before GST.
GST uses the entered percentage.

Reference: MAT-REVIEW
Unit cost: 125 AUD
Quantity: 8
Markup: 3%
GST: 10%

Markup amount30 AUD
Total inc GST1133 AUD
Statusmarkup-review

Total inc GST1133 AUD

Markup amount 30 AUD.

The low markup state keeps review visible before the material line is used.

Supplier price remains an entered value.
Freight and waste are outside this line unless included in unit cost.
Business policy can override the worksheet.