Adding 5% to an 18 m² measurement does not necessarily add another supply pack. In this example, both 0% and 5% round to eight packs, while 10% rounds to nine. Pack size changes the order as well as the percentage assumption.
The downloadable calculator separates measured quantity, reviewed allowance, usable stock and pack coverage. It calculates the whole packs needed and their purchase price, with a separate worksheet for the layout information behind the assumptions.
The example percentages are sensitivity inputs, not trade waste norms. Review the actual product, pattern, dimensions and usability of stock before ordering. The file does not optimise cuts, assess technical suitability or infer tax treatment.
Download the Jobsworth material-order calculator
One Excel file with a blank order model, an 18 m² example, allowance sensitivity, a usable-stock scenario and layout-review worksheet.
Establish the measurement and unit
Identify the material, work area and measurement basis on Layout review. The calculator expects one consistent unit across measured quantity, usable stock and per-pack supply. It does not convert metres, square metres, pieces or other units.
Use the quantity appropriate to the material being planned and retain its source. A drawing, checked measure and allowance describe different information. Record which is being used so a colleague can review the basis before ordering.
For a straightforward area model, dimensions may help establish the measured quantity, but the actual layout can add constraints. Openings, orientation, pattern or joint requirements need relevant assessment. A percentage alone cannot demonstrate that the physical arrangement works.
Keep the product specification alongside the unit choice. A supplier pack labelled with coverage needs to correspond to the selected product and actual intended use. Do not copy a familiar coverage figure from a different item.
Choose a reviewed allowance
Enter the allowance as a whole percentage, such as 10 for 10%. The required-quantity formula multiplies the measurement by one plus that percentage expressed as a decimal. With 18 and 10%, it produces 19.8 on the selected unit basis.
Establish why that assumption applies to the actual material and layout. The notes worksheet asks about planned cuts, constraints and potential usable offcuts. Use competent planning information rather than treat the sample as a recommended rate.
Avoid combining several unspecified allowances without understanding them. A quantity already adjusted during measurement and another percentage added in the calculator can count the same assumption twice. Keep each adjustment and its purpose explicit.
If a layout question remains unresolved, retain it as an open input before relying on an order. The workbook’s numerical precision cannot establish that the selected allowance will cover a pattern or cut arrangement nobody has assessed.
Confirm pack coverage and price
Enter the usable quantity per supply pack from the actual relevant information. The worked example uses 2.4 m² per pack. That figure is an illustrative input, not a claim about a particular manufacturer or product.
Divide the quantity still to purchase by the pack coverage and round up to a whole pack. A fractional result is not treated as a fractional supplier order under this model. Check the actual supply arrangement where another ordering unit applies.
Enter the corresponding pack price on a consistent basis. The example uses £42. The file performs no tax calculation or automatic supplier lookup, so confirm what the entered amount includes before comparing the result with another estimate.
Identify delivery, associated supply or other charges separately if they belong in your full cost estimate. The new-purchase output concerns the selected packs. It is not automatically the entire material cost or the whole Job price.
Follow the worked order
The worked tab starts with 18 m², a 10% illustrative allowance, no usable existing stock and packs covering 2.4 m². Required quantity including allowance is 19.8 m².
Dividing 19.8 by 2.4 gives 8.25 packs, which the model rounds up to nine. Those packs supply 21.6 m² and cost £378 at £42 each. The spare quantity above the allowance model is 1.8 m².
That spare figure is a result of pack rounding, not proof of what material will remain reusable after work. Actual use, cutting, condition and specifications determine that position. Keep the calculation’s assumption distinct from site records.
Review the difference between a measured quantity and an order quantity. Ordering 21.6 m² for an 18 m² measurement reflects both the allowance and the supply unit. It should not silently replace the measured scope quantity in another record.
Use the sensitivity table
The three sensitivity rows start at 0%, 5% and 10%, and can be edited to reviewed alternatives. They show required quantity, whole packs, purchase price and spare quantity above each model.
At 0%, 18 m² rounds to eight packs; at 5%, 18.9 m² also rounds to eight. Both buy 19.2 m² for £336. The 10% row moves to nine packs and £378.
This step change shows why a percentage comparison can be misleading without the pack calculation. A small change may have no effect on the order until a threshold is crossed. Inspect the actual quantity and supply basis alongside the chosen assumption.
Use sensitivity to understand the model, not to choose the smallest order regardless of the layout. The lowest purchase figure does not establish that the material will be sufficient or appropriate for the work.
Include only usable existing stock
If reviewed usable stock exceeds the modelled requirement, the quantity still to purchase and new pack count become zero. For instance, 24 m² of usable stock against the example’s 19.8 m² requirement leaves no new purchase under this arithmetic. It still requires the actual stock and layout review; the calculation cannot establish suitability merely from a recorded amount.
Keep stock allocated to this work distinguishable from material reserved for another Job. The same leftover quantity cannot support several orders independently if each assumes it is fully available. Record the actual reviewed quantity and any reservation in your normal stock or work records before treating it as an input to this order.
The stock field deducts quantity you have actually reviewed as usable for the selected work. Confirm identity, specification, condition and relevant layout needs through the appropriate process. A leftover amount recorded somewhere is not automatically compatible supply.
The stock example enters 2.4 m² already available. Required quantity remains 19.8 m², while 17.4 m² is left to purchase. Eight new packs provide 19.2 m², giving 21.6 m² available when stock is included.
The new purchase price falls to £336, but that does not assign zero value to the old stock or determine the full costing treatment. Keep its historical or allocated cost information where relevant to your actual estimate and accounts.
Complete the layout review
The additional sheet asks for material reference, work area, quantity source, layout constraints, planned cuts, stock review, pack information and the reason for the allowance. Use those notes to connect the arithmetic with the actual planning.
Name any information still needed and its reviewer rather than conceal it with a known-looking percentage. If a product or layout changes, review the affected inputs and retain the earlier basis with the estimate.
Choose one material order today and complete the blank model on a consistent unit basis. Check the pack information and layout questions, then inspect two allowance scenarios. The useful result is an explainable order quantity supported by reviewed assumptions.
Sources and further reading
Keep estimate inputs with the work
Explore Jobsworth costs and reporting alongside your reviewed estimating process.
Explore costs and reporting