APU (unit price analysis) and budgets
APU and construction budgets that add up and show where every price comes from
You build the unit price analysis (APU) with materials, labor, equipment and transport. The engine recalculates everything and warns you when a declared figure doesn't match what comes out of the math.
The problem
A spreadsheet budget fails silently
A broken formula, a productivity rate copied from another project or a price with no date make no noise: the total comes out and everyone believes it. You only find out when the project has already lost money.
And when the client asks where the concrete price came from, nobody knows whether it was from the company's price bank, a list from two years ago or an assumption.
How it works
From the input to the total, with the math in view
You build the APU
By blocks: materials, labor, equipment and tools, and transport. You can also import a BC3 file (FIEBDC-3) or ask for a draft from a description.
The engine recalculates
Partials, subtotals, minor tools, direct cost, AIU (administration, contingencies and profit) and total. If what you declared doesn't match, the line is marked "doesn't add up" with the difference in pesos.
You check the origin
Each price shows whether it comes from your price bank, a reference list, an assumption or the document, and each productivity rate whether it is assumed or backed.
You save versions and export
You save a version with its total, compare two and set the current one; that is the one that goes to the quoting tool. You export to Excel or BC3.
What sets it apart
What you can check, not just take on faith
- No price, no zero
- If a price is missing, the APU is flagged as incomplete and the direct cost does not include what is missing. It is not filled in with a zero that looks like data.
- Traffic light against your own price bank
- It compares each price with the range of your previous purchases, as long as there is a minimum number of samples for the comparison to be meaningful.
- Adjustment with the DANE index
- You upload the ICOCED index file (DANE, Colombia) and the adjustment is applied as a new version. The result is approximate and the platform says so.
- Calculation with exact decimals
- The engine uses decimal arithmetic, not floating point, so cents are not lost when adding up thousands of lines.
- Prices and suppliers with location
- Look up IDU input prices and compare supplier options with country, city or area where available. These are references to review, not guaranteed prices for your project.
- API to cross-check a unit price analysis
- The forward API rebuilds the total; reverse tests a target total by adjusting prices within available bands without changing quantities; eval cross-checks feasibility in both evaluations. It does not modify the saved analysis.
What it doesn't do
The limits, stated up front
- It does not include a base of regionalized APU from public entities: commercial use without authorization is not permitted. You load your own prices or import them.
- The AI draft generator proposes; the productivity rate stays marked as assumed until you back it up.
- The ICOCED adjustment does not bring the indices on its own: you upload the DANE file.
- It is a calculation tool; it does not replace the estimator who answers for the budget.
Compared with what you use today
Compared with the spreadsheet and the classic budgeting program
- Spreadsheets
- Formulas break without warning. Here, what doesn't add up is flagged and what has no price is not summed.
- Desktop budgeting programs
- They save the file, not the history. Here there are comparable versions and the origin of each price.
- Generic ERP
- The ERP handles inventory and accounting, not productivity rates or AIU. The APU is the center of the module.
Frequently asked questions
What people usually ask before trying it
Can I import my current APU?
Yes, from BC3 files (FIEBDC-3). What is imported goes into your draft, not into the reference bank. Here we only claim BC3 import.
Is the AIU a fixed percentage?
The engine calculates the AIU together with the direct cost and the total. To estimate it before quoting you can use the free AIU calculator.
What happens if a price is missing?
The APU is marked incomplete and the direct cost does not include that line. Zero is not assumed.
Next step
Let's upload one of your budgets and see what doesn't add up
Tell us about your project and we'll show you this module with your own data, no commitment.
On the same topic
Other platform modules