Block · BLQ-004 · v1.0
Price-cost-volume-mix variances
Margin variance by price, cost, volume and mix.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
5 sections, in this order
- 01Action title with the total figure and the two largest effects
- 02Table by line: Δ margin, price, cost, volume, mix and Δ %
- 03Gross profit mini-bridge
- 04What happened, why and what to do (3 to 5 bullets)
- 05Methodology note
Controls 4/4
What it checks before writing a single figure
C1Complete data: columns, no duplicate lines, budget greater than zero and a single unit of measure (or no-mix mode).
C2Reconciliation: the sum of the lines' margins is actual and budget gross profit in the income statement (N/A if not given).
C3The breakdown ties: price + cost + volume + mix = Δ margin, by line and in total.
C4Traceable figures: every figure in the text exists in calculo.json with the same rounding.
If the script ran
Repporti controls 4/4 · BLQ-004 v1.0 · RS2026.10 · {fecha} · fingerprint {hash}
If it did not run
UNVERIFIED: code not run. Review Control in Excel.
What the prompt contains, block by block
Prompt outline
- 0Before you paste your filesFixed456
- 1Role, audience and business context646
- 2Parameters700
- 3Repporti standard549
- 4Data contract797
- 5Questions first316
- 6Validation with a hard stop437
- 7Calculation by code224
- 7-bisNo-code modeFixed325
- 8Formulas706
- 9Structure1,077
- 10Writing without «AI slop» and without invention461
- 11Notation (IBCS / ISO 24896:2026, theme TEM-001) and accessibility540
- 12QA, traceability and seal695
Core available in: Spanish · English
It comes out adapted to your report profile
Repporti Standard
Your profile sets country, framework, language, currency, scale and year-end.
See the Repporti StandardHow to use it
From the trial balance to the report in three steps
- 01Configure and copy
- 02Paste into your AI
- 03Review and deliver
Anonymize before pasting
- Company → alias; tax identifier → ID-XX.
- People → codes. Keep the mapping on your device.
- Use business AI, API or disable training.
Made for whoever delivers the report
Who it is for
- Area
- Profitability and costs
- Frequency
- Whenever you need it
- Industry
- Retail and wholesale, Manufacturing, Agriculture and food
Which AI it works with
Compatibility
| Level | AI | |
|---|---|---|
| With code execution | ChatGPT · Claude | Requires file analysis and Python execution for cuadre.py. |
| No-code mode | Copilot · Gemini | Excel with Control sheet; UNVERIFIED until cuadre.py runs. |
Questions
About this block
What data do I need?
By line: actual and budgeted units, actual and budgeted unit price and unit cost. If you don't have unit figures, total revenue and costs work: the script divides them and says so.
What if my lines use different units (kg and cases)?
Mix is meaningless across different units: the script combines volume and mix into one effect and the methodology note explains it.
Does it connect to the EBITDA bridge?
Yes. The calculation writes puente.json with price, cost, volume and mix; chart GRF-001 adds the expenses and draws the bridge down to EBITDA.
Profitability and costs