R
Realm Studios Pty Ltd
Total Contract Value
$4.82M
23 contracts · 6 agencies
Currently Active
5
$1.24M in active value
Expiring ≤90 days
2
$380K at risk of lapse
YoY Growth (FY25)
+31%
$1.31M vs $1.00M FY24
Annual Contract Value Won
Sourced from
contracts.award_date grouped by FY contracts · agencies · jurisdictions — grouped by extract(year from award_date)
Contract Value by Agency
Sourced from
mv_supplier_agency_wins mv_supplier_agency_wins — total_value per agency_id
Services Provided (by UNSPSC category)
From
mv_supplier_agency_wins.unspsc_code → unspsc_categories mv_supplier_agency_wins · unspsc_categories — aggregated total_value per category segment
Agency Relationships
From
mv_supplier_agency_wins| Agency | Contracts | Total Value | Active | Latest Expiry |
|---|
mv_supplier_agency_wins · agencies
Concentration Risk
Top agency share
58%
APRA — $2.8M of $4.82M total
Top 3 agency share
88%
High dependency — 3 of 6 agencies = 88% of lifetime value
⚠ High concentration. A single agency relationship accounts for over half of all awarded contract value. Disruption to APRA relationship would significantly affect revenue.
Procurement Pathways
contracts.procurement_method + procurement_method_details
Active Contracts
5
is_active = true
Active Value (Total)
$1.24M
sum(value_amount) where is_active
Avg Days Remaining
184 days
avg(days_to_expiry) active contracts
Current Contracts
From
api_contract_details_v where is_active = true and supplier_id = {id}| Contract Notice | Agency | Description / Category | Value | Start | End Date | Max Extent | Days Left | Method |
|---|
api_contract_details_v · contract_cn_metadata (extension_options, max_extent_date) · mv_expiry_monitor (expiry_band)
Expiry Timeline — All Contracts
mv_expiry_monitor filtered by supplier ABN
Expiry Band Summary
mv_expiry_monitor.expiry_band — critical/imminent/upcoming/watch/future
Contracts by Expiry Date
Critical ≤30 days
Imminent ≤90 days
Upcoming ≤180 days
Watch ≤365 days
Future 365+ days
api_expiring_contracts_v · contract_cn_metadata.max_end_date, extension_options
Incumbency Map
Where this supplier is the current incumbent — from
mv_incumbents| Agency | Category | Contract Value | End Date | Status |
|---|
mv_incumbents — DISTINCT ON (agency_id, unspsc_code) ordered by is_active DESC, start_date DESC
Competitive Landscape
Top suppliers in same UNSPSC segments at same agencies
api_top_suppliers_v — value_rank_in_agency for shared agency_id + unspsc_code
Forward Pipeline Opportunities
Upcoming procurement at agencies this supplier works with — from
forward_pipeline forward_pipeline WHERE agency_id IN (supplier's agencies) AND unspsc_code overlaps supplier's categories
Rebid Signal Analysis
Extension options used
3 / 5
CN metadata: extension_options_raw
Rebid success rate
80%
Retained incumbent in 4 of 5 rebids
Avg contract duration
22 months
contracts.duration_days ÷ 30.4
contract_cn_metadata.extension_options · contracts.duration_days · derived incumbency rebid match
ABR Registry Record
ABN
12 345 678 901
ABN Status
Active
Legal Name
Realm Studios Pty Ltd
Trading Names
Realm Studios, Realm Design
Entity Type
Proprietary Limited Company
ACN
345 678 901
GST Status
Registered
State / Postcode
ACT / 2600
ANZSIC Code
7420 — Design services
SME Classification
SME
ABR Last Updated
2026-01-14
Imported At
2026-04-01
abr_lookup JOIN suppliers ON suppliers.abn = abr_lookup.abn
Known Aliases
All aliases are resolved to this canonical supplier record. Contract counts and spend totals are aggregated across all alias variants.
supplier_aliases WHERE supplier_id = {id}
Data Health
Contracts with UNSPSC22 / 23
CN pages scraped18 / 23
Embeddings generated23 / 23
ABN verified✓ Verified
contract_embedding_queue · contract_cn_metadata · abn_enrichment_queue