Versioned estimate worksheet
A synthetic illuminated-fascia calculation that keeps evidence, assumptions and revision triggers visible.
Scenario IF-118 · North Pier Cycles (fictional). These are synthetic teaching inputs, not market rates, a rate card, a supplier quotation or pricing guidance. Tax, approved terms and final rounding are not included.
Estimate basis
Version 2 · review only| Line | Synthetic evidence / formula | Amount |
|---|---|---|
| Materials | Illustrative supplier evidence dated 2026-09-20 | £720.00 |
| Illumination components | Illustrative bought-in input | £280.00 |
| Workshop labour | 20 hours × £38 fictional internal input | £760.00 |
| Installation / travel | Revised after the fictional access survey | £780.00 |
| Direct cost | Sum of lines above | £2,540.00 |
| Internal allocation | 12% fictional method × direct cost | £304.80 |
| Cost base | Direct cost + allocation | £2,844.80 |
| Selling basis | £2,844.80 ÷ (1 − 32% fictional gross-margin target) | £4,183.53 |
Revision and controls
Owner trail| Control | Completed example | Owner |
|---|---|---|
| Revision trigger | Access method changed after survey; v1 retained as superseded | Estimator |
| Unknown | Existing electrical condition; any remedial work remains excluded | Install coordinator |
| Assumption | One installation visit during agreed site hours | Account lead |
| Release state | Commercial review only; not production instruction | Commercial owner |
Revision note: version 1 used £460 for installation/travel and 18 workshop hours, producing a £3,531.29 selling basis. Version 2 records the changed access assumption, £780 installation/travel and 20 hours; version 1 remains superseded. Gross margin uses gross profit ÷ selling price and this fictional target is not a recommendation.