Cape Town Asphalt Demand Pressure Monitor
A procurement-pipeline model that classifies road tenders and awards to estimate future asphalt demand pressure in Cape Town and the Western Cape without claiming supplier inventory.
- Decision
- Anticipate procurement pressure early enough to review programme sequencing, supply strategy and escalation risk.
- Source
- National Treasury eTender OCDS API + City of Cape Town tender portal + Stats SA construction materials data
- Period
- May 2021 onward for eTender OCDS
- Created by
- Nyashadzashe Munyati
The analytical result is shown before the technical method.
What I did in this project
Defined the question.
Prepared the data.
Built the analysis.
Validated and documented the result.
Anticipate procurement pressure early enough to review programme sequencing, supply strategy and escalation risk.
Clients, contractors and suppliers benefit from knowing whether many asphalt-intensive road projects are likely to enter construction at the same time. Public procurement data can provide an early demand signal even when plant inventory and production capacity are private.
Source data
National Treasury eTender OCDS API + City of Cape Town tender portal + Stats SA construction materials data
What I changed before calculating anything
Worked calculations — not black-box KPIs
What the drill-down adds
The headline chart gives the decision signal. These additional views show whether the same conclusion survives when the data is sliced another way.
The question and method are documented, but unfinished results are not presented as completed analysis.
What I would say in the management meeting
What I would do next
Public procurement coverage is incomplete. Tender descriptions do not provide asphalt tonnage consistently.