/ HSQ ELECTRICAL

MATERIALS · STOCK · LABOUR SUPPLIER-FED WORK ORDER BUILDER · SOLOMON HAYEK

Postcon · iOS · Trade Partner expansion architecture

Solomon builds a work order against SC #4118 by pulling line items from three sources at once: live supplier catalogues (MIDDY's AWM, Voltex, Lawrence & Hanson, CNW, MMEM), his own stock (van · garage · over-ordered surplus from past Hillbrook jobs), and his labour rate book. The platform normalises every supplier behind a single product schema and inventory ledger — so onboarding the next trade (plumbers off Reece, carpenters off Bunnings Trade, HVAC off Beijer) is a new adapter, not a new product. See the architecture map.

MIDDY's AWM Voltex Lawrence & Hanson CNW MM Electrical My Stock Labour
14:18 5G
WORK ORDER · 73 PRINCES
HSQ

73 PRINCES HWY · STAGE 1

Rough-in WO

Auto-linked to Procore SC #4118

DRAFT
LINE ITEMS · 6
MID

Clipsal 56 series 15A WP switch

$252.84

MIDDY's AWM · SKU 56SW115 · in stock

QTY6@ $42.14
VTX

2.5mm² TPS cable · 100m drum

$184.00

Voltex · SKU TPS-2.5-100 · cheapest source

QTY2@ $92.00
OWN

25mm conduit · grey · 4m length

$48.60

Van · 12 lengths on hand · over-order ex 14 Park Rd

USE9@ $5.40 cost
OWN

GPO surrounds · clip-in white

$18.00

Garage · 24 on hand · over-order ex 88 Glen Iris

USE12@ $1.50 cost
CNW

HPM XL777 LED downlight kit

$348.00

CNW · SKU XL777-WW · 5 day lead

QTY8@ $43.50
LAB

Standard hour · A-grade sparky

$3,420.00

Solomon + 1 apprentice · 4 days

HRS36@ $95.00
SUPPLIER$784.84
MY STOCK · COGS$66.60
LABOUR$3,420.00
MARGIN · 28%$1,196.42
GST · 10%$546.79
TO HILLBROOK $6,014.65
WORK ORDER BUILDER6 mixed lines · margin · auto-linked to SC
14:21 5G
15A weatherproof
ALL · 47 MIDDY's · 12 VOLTEX · 9 L&H · 8 CNW · 7 MY STOCK · 3

47 RESULTS · LIVE PRICED · 16:21 SYNC

CLIPSAL · 56 SERIES

15A weatherproof switch · IP66

SKU 56SW115 · AS/NZS 3000

MID $42.14 VTX $44.05 L&H $43.80 CNW OOS

CHEAPEST IN STOCK

MIDDY's · $42.14 · 18 OH

CLIPSAL · 56 SERIES

15A weatherproof switch · IP66

SKU 56SW115 · 4 on hand · garage

YOU HAVE 4 OF THESE · USE OWN STOCK · SAVE $146.92

YOUR COGS

$5.40 ea · over-order ex 14 Park Rd

NHP · ISOLATOR

25A 3-pole WP isolator

SKU NHP-IS25-3P

MID $84.20 L&H $79.95 VTX $82.10

CHEAPEST IN STOCK

L&H · $79.95 · 22 OH

SUPPLIER SEARCHFederated price · OWN stock match
14:24 5G
INVENTORY · MY STOCK
HSQ

STOCK VALUE

$4,860

AT COGS · 142 SKUS

OVER-ORDER

$2,140

FROM 5 PAST JOBS

VAN · ON ME $1,920
OWN

25mm conduit · grey · 4m

12 OH

Last cost $5.40 · used last on 14 Park Rd

USE 9 ON 73 PRINCES →

OWN

Clipsal 56 15A WP switch

4 OH

Last cost $5.40 · over-order 14 Park Rd

USE 4 ON 73 PRINCES →

OWN

2.5mm² TPS · loose 18m

18 m

Cost basis $0.92/m · awkward offcut

GARAGE · WILLIAMSTOWN $2,940
OWN

GPO surrounds · clip-in white

24 OH

Last cost $1.50 · over-order 88 Glen Iris

USE 12 ON 73 PRINCES →

OWN

Hager 6-way RCBO board

1 OH

$420 · spare ex 21 Tyrrell Ave quote

OWN

Cable ties · 200mm · 1000 pk

3 PK

Bulk buy · keep as standing stock

PLATFORM HINT

Using your own stock on 73 Princes saves $214.92 of supplier spend and clears slow-moving inventory. Margin lift on this WO: +4.1pp.

MY STOCKVan · garage · over-order ledger
14:28 5G
LABOUR · RATE BOOK
HSQ

FOR 73 PRINCES HWY

Add labour

Pick a rate · enter hours · auto-adds to the work order

RATES · CHARGE TO HILLBROOK

A-GRADE SPARKY · STANDARD

Mon–Fri 07:00–17:00 · cost rate $58

$95/HR · 39% MGN

AFTER HOURS

17:00–07:00 weekdays · cost rate $87

$142/HR · 39% MGN

WEEKEND / PUB HOL

2× base · pre-approved by Drazen

$190/HR · 39% MGN

CALL OUT · MINIMUM

4 hr block · DLP / urgent defects

$420FLAT · 4HR

APPRENTICE · 3RD YR

Standard hours · supervised

$58/HR · 38% MGN

EXTRAS

TRAVEL

$1.10/KM

VEHICLE LOAD

$68 FLAT

QUICK ADD

Standard + apprentice

36 hrs sparky × $95 + 36 hrs apprentice × $58 = $5,508 charge

LABOUR RATESCharge book · cost vs charge · margin
14:34 5G
SEND TO HILLBROOK
HSQ

WORK ORDER · WO-2026-0731

73 Princes · Stage 1

TO HILLBROOK

$6,015

YOUR MARGIN

28%

SOURCE MIX
MIDDY's AWM$252.84
Voltex$184.00
CNW$348.00
My stock · COGS$66.60
Labour$3,420.00
WHEN SENT

Lines post as SC #4118 revision 2 in Procore for Caleb to accept

12 GPO surrounds + 9 conduits + 4 switches decremented from your stock ledger

MIDDY's + CNW orders queue overnight · pickup ETA 06:30 tomorrow

Drazen pinged · scheduled on his Mon site map

PRICES LOCKED · FEED 16:21 · GST INCLUSIVE

SEND TO HILLBROOKSource mix · downstream events

PLATFORM ARCHITECTURE

How we onboard trades + suppliers

The trade partner app is one mobile shell. Underneath it sits a layered platform with three load-bearing decisions: one normalised product schema that hides every supplier API behind it, per-vendor inventory + rate ledgers that travel with the trade partner across every Hillbrook job, and a single quote-assembly engine that mixes supplier · own stock · labour into one work order. Onboarding the next supplier is a new adapter. Onboarding the next trade is a new taxonomy file. Neither is a new product.

1 · UI

Trade-partner shell. Co-branded with each vendor. Same app, scoped per logged-in trade.

Mobile App

iOS + Android · offline queue · camera · geo · Hillbrook Trade Partner SSO

Back Office

Web dashboard for accounts/admin · pricing schedules · BAS reconciliation

Hillbrook Heroes UI

Drazen / Caleb / Mariana see the same data from the inside view

2 · ENGINE

Quote / WO assembler. Mixes supplier + own stock + labour, picks cheapest in-stock by default, calculates margin live.

Quote Builder

Line items from any source · margin engine · variation rules

Cheapest-Source Picker

Live price + stock + lead time → suggests source per SKU · pinnable

Stock-First Hint

Flags every line where the trade already owns enough · auto-prefers OWN at COGS

Margin Live

COGS + labour cost vs charge · per-line and overall · cap rules per client

3 · LEDGERS

Long-lived state per trade partner. The data that makes the next quote faster than the last.

Inventory · Locations

Van · garage · yard · job-site bin · over-order from past job · serialised items

Labour Rate Book

Standard · after-hours · weekend · callout · apprentice · per-client overrides

Travel + Vehicle

$/km · vehicle load · zone surcharges · per-postcode rules

Trade Skills Matrix

What this partner is allowed to quote · regulator licence scope · auto-cap on out-of-scope SKUs

4 · SCHEMA

One product shape. Every supplier API gets reshaped into this. The whole platform reads from here.

product

id · canonical_sku · brand · description · category · unit · pack_size · weight

compliance

AS/NZS std · WaterMark · RCM · GreenStar · MEPS · safety class

price_quote

vendor_id · price_ex · price_inc · trade_disc · stock_qty · lead_days · fetched_at

cross_ref

vendor_sku ↔ canonical_sku ↔ alt SKUs · supplier-equivalent fallback

5 · ADAPTERS

Per-supplier API client. One adapter → all trades that buy from that supplier get it.

MID
MIDDY's AWM

OAuth · trade login · catalogue + price + stock · order push

LIVE
VTX
Voltex

SOAP feed + scraped stock · trade pricing matrix

LIVE
L&H
Lawrence & Hanson

REST · trade discount tier · click-and-collect

LIVE
CNW
CNW

Punchout cXML · pickup branch routing

BETA
MM
MM Electrical

EDI · contract pricing per builder

BETA
REE
Reece

Plumbing · same adapter contract

NEXT
BUN
Bunnings Trade

Carpentry / fixings · trade card sync

NEXT
BEI
Beijer Ref

HVAC refrigerant · serial tracking

NEXT

6 · HANDOFFS

Where the WO lands in the rest of the Hillbrook stack. Same wires as the trade-partner integration map.

HOP · postcon

WO becomes vendor_jobs row · linked to site + programme + Drazen's calendar

Procore

Lines post as SC #4118 revision · Caleb approves in My Open Items

Stock ledger decrement

Own-stock lines decrement van/garage qty · COGS booked against the job

Supplier orders

Cheapest-source items queued as supplier POs · pickup branch + ETA

Xero · bills

Approved claim → bill against the SC · payment run pings vendor as PAID

Vendor performance

Stock-use % · margin · on-time · feeds back into trade partner score

NEW SUPPLIER · TIME TO LIVE

3 DAYS

Adapter to normalised schema. Reused by every trade.

NEW TRADE · TIME TO LIVE

1 DAY

Taxonomy + compliance scope. Reuses every existing supplier already wired.

MARGIN LIFT · OWN STOCK

+4.1 PP

Average margin lift per WO when the trade uses their own stock first.

Today: electrical trades + 5 wholesalers. Q4: plumbing (Reece, Tradelink) and carpentry (Bunnings Trade) on the same rails. The play is platform > product — Hillbrook becomes the marketplace its own subbies use, and every adapter we write earns again the next time a different trade needs that supplier.