Our $1,845 quote-scope audit
We wrote this hypothetical case to separate arithmetic from assumptions. It is not a supplier offer, an average installation price, a customer invoice or advice about any jurisdiction. The quote record has twenty tile boxes at $25 per box, 160 installed square feet at $8 per square foot, and $40 fixed delivery. Those entered lines produce $500, $1,280 and $40. Before tax, the visible subtotal is therefore $1,820.
Next, the worksheet asks for an entered taxable subtotal. That field is deliberately not a checkbox that decides a rule. In version A of our hypothetical quote, the writer explicitly places only the $500 tile subtotal in scope. Five percent of $500 is $25, and the total is $1,845. The formula is transparent: 500 + 1,280 + 40 + 25. Every dollar in that expression comes from one of the selected inputs.
Version B changes only the stated tax base. Suppose the same hypothetical quote explicitly includes tiles and delivery in its entered taxable subtotal: $500 + $40 = $540. Five percent of $540 is $27. The total becomes $1,847. The two-dollar difference does not prove that either scope is correct anywhere; it only shows why a calculator must retain the source of the tax base rather than applying the percentage blindly to every displayed line.
Installed area belongs to labor in this example, while box count belongs to tile materials. They should not be silently converted into one another. The twenty boxes are already a quoted quantity, so this page does not run a tile-waste calculation or estimate replacement boxes. Likewise, $8 per square foot is an entered labor rate for the demonstration, not a recommendation. The earlier labor minimum worksheet is a different gap: it tests whether a stated minimum replaces a lower labor subtotal. It does not add tile, delivery or tax lines.
Now test omissions. If a quote contains no removal, preparation, trim, grout, permit, hauling or delivery amount, leave it unknown rather than entering a typical number. A visible subtotal can still be useful for reconciling listed lines, but it is not a whole-project budget. Entering zero says the quote explicitly says zero; leaving the field blank stops the worksheet. That distinction helps keep a missing line from looking like a verified free line.
To reproduce the arithmetic, load the example and calculate. The ledger displays the tile, labor and delivery subtotals independently. Replace the entered taxable subtotal with 540, leaving every other value unchanged, and calculate again. Then try 0 as the entered tax rate to inspect the pre-tax total. The calculator clears a result when an input changes, so it cannot quietly present a total for an earlier scope.
How to use the worksheet
Copy the line items from your quote exactly: quantity, unit and price basis. Use installed area only when the quote itself uses an area rate. Record a fixed charge as a separate amount. Ask the quote issuer what an unclear line covers. Enter the taxable subtotal only when your record identifies the chosen scope; this page cannot determine legal taxability or interpret a vague quote.
Questions answered
Can this estimate the average cost to install tile?
No. It has no market-rate database and does not fill missing lines. It adds values you enter.
Why not tax the whole displayed subtotal automatically?
The displayed subtotal can contain different line types. Our calculator requires an entered tax base so it does not present an assumption as a rule.
What if my quote has a tile price per square foot instead of per box?
Keep the original quote basis in your record. This worksheet's tile line is boxes × box price; do not force another unit into it. You can audit other identified lines separately without claiming an equivalent box price.
Method record and limits
CountMyTiles authored this worked case, questions and diagrams on October 12, 2026. We reviewed the fixed three comparison sites' existing tile and cost-calculator material; their pages show tools and general cost discussions, while this page contributes a reproducible distinction between entered line-item arithmetic and an asserted tax scope. No third-party quote or person is represented. Use the main tile calculator to calculate a measured tile quantity before you obtain a quote. This page neither recommends prices nor gives tax, contract or installation advice.