Reports
Worked out from the rows every time this page is opened — the invoices, the order lines, the shipment lines and the batches. Margin is taken against landed cost wherever a part has one, so the freight and the duty are inside the number rather than sitting in an expense code.
Invoiced ▼ 0.1%
$907,566
50 invoices, ex GST
Gross margin
$429,528
47.3% against landed and standing cost
Win rate
75.0%
6 won of 8 decided · 8 still live
Paid for, still at sea
$174,842
of $199,551 in transit across 4 shipments
Invoiced and margin by month
Ex GST · dashed line is gross margin Invoiced by range
Attributed to the part on each line Margin against revenue, by range
Pale is invoiced, solid is margin On the water, by stage
Solid is paid for in full Stock at cost, Hawker
$404,885 on the shelf $404,885at cost, Hawker
Units built per month
3,380 units off the bench Margin per part code
32 sold ·
0 under 25%
| Part code | Name | Range | Units | Invoiced | Unit cost | Margin | Margin % | Costed against |
|---|---|---|---|---|---|---|---|---|
| EBG | Electronic Break Glass — flush mount | Electronic Break Glass | 520 | $116,670 | $116.94 | $55,861 | 47.9% | Landed cost |
| SCP-A | Safety Call Point — Assistance | Safety Call Point | 515 | $100,742 | $117.18 | $40,394 | 40.1% | Landed cost |
| PP10HD | Power Port 10HD — compact power distribution module | Power Port | 445 | $70,978 | $87.90 | $31,862 | 44.9% | Landed cost |
| PP5FR-UNI | Power Port 5FR-UNI — versatile power distribution module | Power Port | 450 | $64,980 | $75.65 | $30,938 | 47.6% | Landed cost |
| ADI | ADI — automatic door & gate interface | Specialty Products | 445 | $63,235 | $73.09 | $30,709 | 48.6% | Landed cost |
| SCP-L | Safety Call Point — Lockdown | Safety Call Point | 360 | $70,992 | $117.18 | $28,807 | 40.6% | Landed cost |
| LODESTAR | Lodestar — versatile alarm indicator | Lodestar | 525 | $50,045 | $47.23 | $25,249 | 50.5% | Landed cost |
| EBG-SB | Electronic Break Glass — with surface mount box | Electronic Break Glass | 220 | $55,506 | $137.89 | $25,170 | 45.3% | Landed cost |
| SCP-D | Safety Call Point — Duress | Safety Call Point | 265 | $51,771 | $117.18 | $20,719 | 40.0% | Landed cost |
| ATMOD10 | ATMOD 10K/10K — Red | ATMOD | 2720 | $28,249 | $2.95 | $20,225 | 71.6% | Landed cost |
| PP8FR | Power Port 8FR — fire tripped power distribution module | Power Port | 200 | $35,802 | $91.56 | $17,490 | 48.9% | Landed cost |
| SCAR-C | SCAR — dress plate, classic switch plate size | Specialty Products | 1990 | $32,338 | $8.36 | $15,701 | 48.6% | Landed cost |
| ATMOD47 | ATMOD 4K7/4K7 — Yellow | ATMOD | 1430 | $15,373 | $2.95 | $11,154 | 72.6% | Landed cost |
| PP8PTC | Power Port 8PTC — self healing power distribution module | Power Port | 120 | $20,532 | $85.14 | $10,315 | 50.2% | Landed cost |
| FAST-R6J | FAST-R6J — Wiegand joiner | FAST Connector System | 3170 | $23,032 | $5.25 | $6,390 | 27.7% | Landed cost |
| ARK | ARK — ATMOD Ruggedisation Kit | ATMOD | 760 | $10,289 | $5.36 | $6,215 | 60.4% | Landed cost |
| PP10MG | Power Port 10MG — modular power distribution | Power Port | 55 | $10,687 | $93.45 | $5,547 | 51.9% | Landed cost |
| ATMOD01 | ATMOD 1K/1K — Black | ATMOD | 710 | $7,633 | $2.95 | $5,538 | 72.6% | Landed cost |
| HSMA | HSMA — high security mounting adaptor | Specialty Products | 670 | $14,774 | $14.63 | $4,971 | 33.7% | Landed cost |
| ATMOD18 | ATMOD 180Ω/300Ω — White | ATMOD | 570 | $6,128 | $2.95 | $4,446 | 72.6% | Landed cost |
| ATMOD22 | ATMOD 2K2/2K2 — Green | ATMOD | 520 | $5,590 | $2.95 | $4,056 | 72.6% | Landed cost |
| DRMK | DIN Rail Mount Kit | Specialty Products | 730 | $9,308 | $7.55 | $3,796 | 40.8% | Landed cost |
| MINI-FRI | Mini-FRI — field relay interface | Specialty Products | 100 | $6,670 | $32.39 | $3,431 | 51.4% | Landed cost |
| ATMOD68 | ATMOD 2K2/6K8 — Blue | ATMOD | 410 | $4,408 | $2.95 | $3,198 | 72.6% | Landed cost |
| PP2FR-HC | Power Port 2FR-HC — high current power distribution module | Power Port | 50 | $6,235 | $62.18 | $3,126 | 50.1% | Landed cost |
| ATMOD680 | ATMOD 680Ω/680Ω — Grey | ATMOD | 380 | $4,085 | $2.95 | $2,964 | 72.6% | Landed cost |
| ATMOD2R | ATMOD 22K/22K — Orange | ATMOD | 290 | $3,118 | $2.95 | $2,262 | 72.6% | Landed cost |
| FAST-R4T-330 | FAST-R4T-330 — RS485 termination 330Ω | FAST Connector System | 750 | $5,323 | $4.54 | $1,918 | 36.0% | Landed cost |
| FAST-L2J | FAST-L2J — power joiner | FAST Connector System | 730 | $4,599 | $3.71 | $1,891 | 41.1% | Landed cost |
| FAST-R4J | FAST-R4J — RS485 joiner | FAST Connector System | 630 | $4,190 | $4.51 | $1,348 | 32.2% | Landed cost |
| FAST-R4T-120 | FAST-R4T-120 — RS485 termination 120Ω | FAST Connector System | 250 | $1,813 | $4.54 | $678 | 37.4% | Landed cost |
| FAST-R4S | FAST-R4S — RS485 splitter | FAST Connector System | 110 | $924 | $5.25 | $347 | 37.5% | Landed cost |
Nothing matches that.
Revenue by distributor
Top three are 33.3% of the book | Distributor | Tier | State | Invoices | Invoiced | Margin | Margin % | Outstanding |
|---|---|---|---|---|---|---|---|
| Sprint Intercom & Security | Distributor | SA | 6 | $106,644 | $51,147 | 48.0% | — |
| Central Security Distribution — Mulgrave | Distributor | VIC | 5 | $100,038 | $46,313 | 46.3% | $54,243 |
| Hills Limited | Distributor | NSW | 7 | $95,439 | $47,263 | 49.5% | $14,788 |
| Central Security Distribution — Eagle Farm | Distributor | QLD | 4 | $86,744 | $40,827 | 47.1% | $59,342 |
| BGW Technologies | Distributor | NSW | 5 | $86,205 | $42,114 | 48.9% | — |
| Seadan Security & Electronics | Distributor | VIC | 4 | $79,204 | $36,352 | 45.9% | — |
| WESCO Anixter Australia | Distributor | NSW | 4 | $74,165 | $35,728 | 48.2% | — |
| APOL Security Distribution | Distributor | WA | 3 | $70,186 | $31,987 | 45.6% | — |
| GSA Systems | Distributor | QLD | 3 | $57,005 | $26,870 | 47.1% | $24,010 |
| LSC Security Supplies | Distributor | VIC | 4 | $51,406 | $26,304 | 51.2% | $10,112 |
| Consolidated Security Merchants On hold | Distributor | VIC | 2 | $43,951 | $19,429 | 44.2% | $27,953 |
| Loktronic Limited | Export | NZ | 2 | $35,295 | $15,269 | 43.3% | — |
| Ness Corporation | Distributor | NSW | 1 | $21,285 | $9,927 | 46.6% | — |
Quotations
Won $116,516
Lost $25,793
Still live $110,616
Why the lost ones went
Project deferred to next FY 1 · $15,748
Went with the incumbent's own-brand module 1 · $10,045
Off the bench
Replenishment
Under reorder point 29
Already covered by water 6
6 of the shortfalls are on a ship that has been paid for, so a requirements run will not raise a second order for them.
Run requirements