Synthetic housing portfolio
Every repair, tied to its property and its price
Housing teams often read repairs, assets and contract cost from separate lists. This demo links them: one record per property, with its requests, priority, status and what the contract says it costs.
Properties
24
invented, seeded
Open requests
104
of 175 logged
Past target
52
open longer than priority target
Open contract cost
£102,140
sum of priced open requests
Try it: a flat repairs list, or the property view?
| Request | Title | Status |
|---|---|---|
| RQ-4002 | Leak under sink | scheduled |
| RQ-4003 | Heat pump fault | scheduled |
| RQ-4004 | Window reveal mould | scheduled |
| RQ-4005 | Consumer unit check | scheduled |
| RQ-4006 | No heating in communal hall | Awaiting parts |
Which building? How old? What does it cost? The list cannot say.
What the linked view answers
Where is the backlog?
Rank properties by open repairs, requests past their priority target and oldest open item.
What is it costing?
Each request carries its contract cost, so open cost rolls up by property, category and contract.
What is urgent?
Emergency, urgent, routine and planned requests keep their targets, so ageing is judged against the right clock.
Priority targets used in this demo
- Emergency
- Urgent
- Routine
- Planned
Emergency 24 hours · Urgent 5 days · Routine 28 days · Planned 90 days. Targets are invented for illustration.