In the spreadsheet this lived on a tab with a 2024 block underneath it marked "do not use", and one downlight appeared twice at two different prices. Here every quote and every job line references a code, so changing a price changes it everywhere it is used from that point on.
| Code | Description | Unit | Cost | Sell | Margin | Used on |
|---|
| ORANGE-16 | Orange circular conduit 16mm, 4m length | len | $6.40 | $14.50 | 56% | 83 jobs |
| TPS-1.5 | TPS twin & earth 1.5mm, 100m roll | roll | $78.00 | $142.00 | 45% | 150 jobs |
| TPS-2.5 | TPS twin & earth 2.5mm, 100m roll | roll | $112.00 | $195.00 | 43% | 212 jobs |
| TPS-6 | TPS twin & earth 6mm, 50m roll | roll | $186.00 | $305.00 | 39% | 119 jobs |
| Code | Description | Unit | Cost | Sell | Margin | Used on |
|---|
| CAT6-305 | Cat6 UTP cable, 305m box | box | $168.00 | $285.00 | 41% | 21 jobs |
| RJ45-WP | Cat6 wall plate and jack | ea | $18.00 | $42.00 | 57% | 21 jobs |
| Code | Description | Unit | Cost | Sell | Margin | Used on |
|---|
| EV-22KW | EV charger 22kW, three phase | ea | $1,420.00 | $2,050.00 | 31% | 22 jobs |
| EV-7KW | EV charger 7kW, single phase, OCPP | ea | $985.00 | $1,450.00 | 32% | 50 jobs |
| EV-CT-CLAMP | Load management CT clamp kit | ea | $96.00 | $175.00 | 45% | 72 jobs |
| Code | Description | Unit | Cost | Sell | Margin | Used on |
|---|
| EMERG-LT | Emergency light, LED spitfire | ea | $68.00 | $142.00 | 52% | 40 jobs |
| EXIT-LED | Exit sign, LED, maintained | ea | $74.00 | $155.00 | 52% | 39 jobs |
| LED-BATT-4 | LED batten 1200mm 36W | ea | $38.00 | $82.00 | 54% | 23 jobs |
| SW-DIM | LED compatible dimmer | ea | $38.00 | $86.00 | 56% | 71 jobs |
| LED-DL-10 | LED downlight 10W, dimmable, tri-colour | ea | $21.50 | $52.00 | 59% | 98 jobs |
| LED-DL-13 | LED downlight 13W, IC-4 rated | ea | $27.00 | $64.00 | 58% | — |
| LED-FLOOD-50 | LED floodlight 50W with sensor | ea | $62.00 | $128.00 | 52% | 38 jobs |
| SEN-PIR | PIR motion sensor, 360 degree | ea | $42.00 | $95.00 | 56% | 49 jobs |
| Code | Description | Unit | Cost | Sell | Margin | Used on |
|---|
| CEIL-FAN-DC | DC ceiling fan with remote | ea | $189.00 | $320.00 | 41% | 11 jobs |
| GPO-D | Double power point 10A, white | ea | $6.80 | $24.00 | 72% | 165 jobs |
| GPO-D-USB | Double power point with USB-A/C | ea | $34.00 | $78.00 | 56% | 16 jobs |
| EXH-FAN-250 | Inline exhaust fan kit, 250mm | ea | $142.00 | $265.00 | 46% | 26 jobs |
| SW-1G | Light switch, 1 gang | ea | $4.20 | $16.00 | 74% | 28 jobs |
| HWS-TIMER | Off-peak hot water timer and contactor | ea | $88.00 | $168.00 | 48% | 11 jobs |
| GPO-WP | Weatherproof double power point, IP54 | ea | $28.00 | $68.00 | 59% | 37 jobs |
| Code | Description | Unit | Cost | Sell | Margin | Used on |
|---|
| MCB-16 | Circuit breaker 16A | ea | $9.20 | $22.00 | 58% | 16 jobs |
| RCBO-16 | RCBO 16A 30mA, single pole | ea | $32.50 | $62.00 | 48% | 110 jobs |
| RCBO-20 | RCBO 20A 30mA, single pole | ea | $34.00 | $65.00 | 48% | 267 jobs |
| RCBO-32 | RCBO 32A 30mA, double pole | ea | $58.00 | $105.00 | 45% | 115 jobs |
| SPD-T2 | Surge protection device, Type 2 | ea | $148.00 | $245.00 | 40% | 69 jobs |
| Code | Description | Unit | Cost | Sell | Margin | Used on |
|---|
| SMOKE-240 | Smoke alarm 240V photoelectric, 10yr battery | ea | $46.00 | $98.00 | 53% | 49 jobs |
| Code | Description | Unit | Cost | Sell | Margin | Used on |
|---|
| SOL-INV-5 | Solar inverter 5kW hybrid | ea | $1,180.00 | $1,780.00 | 34% | 6 jobs |
| SOL-RAIL-4 | Solar mounting rail 4.2m | ea | $34.00 | $62.00 | 45% | 6 jobs |
| SOL-PANEL-440 | Solar panel 440W mono | ea | $148.00 | $235.00 | 37% | 6 jobs |
| Code | Description | Unit | Cost | Sell | Margin | Used on |
|---|
| SWB-3PH-36 | Distribution board, three phase, 36 pole | ea | $420.00 | $690.00 | 39% | 20 jobs |
| MAIN-SW-63 | Main switch, 63A double pole | ea | $44.00 | $88.00 | 50% | 109 jobs |
| SWB-MTR-1P | Meter panel upgrade kit, single phase | ea | $240.00 | $410.00 | 41% | 29 jobs |
| SWB-CLIP-24 | Switchboard enclosure, 24 pole, flush mount | ea | $168.00 | $285.00 | 41% | 79 jobs |
| Code | Description | Unit | Cost | Sell | Margin | Used on |
|---|
| LAB-AH | After hours / weekend electrician | hr | $93.00 | $195.00 | 52% | 21 jobs |
| LAB-APP | Apprentice | hr | $32.00 | $68.00 | 53% | 323 jobs |
| LAB-CALL | Call out (first hour included) | ea | $62.00 | $145.00 | 57% | 129 jobs |
| LAB-COMP | Compliance certificate and paperwork | ea | $0.00 | $55.00 | 100% | 358 jobs |
| LAB-ELEC | Electrician | hr | $62.00 | $125.00 | 50% | 557 jobs |
| LAB-EWP | Elevated work platform hire and operator | day | $420.00 | $680.00 | 38% | 12 jobs |
| LAB-L2 | Level 2 authorised service work | hr | $88.00 | $185.00 | 52% | 41 jobs |
| LAB-SNR | Senior electrician / A-grade | hr | $74.00 | $145.00 | 49% | 177 jobs |
| LAB-TEST | Test and tag, per item | ea | $1.10 | $4.50 | 76% | 19 jobs |