Skip to content

Block · BLQ-004 · v1.0

Price-cost-volume-mix variances

Margin variance by price, cost, volume and mix.

PaidGlobal standardStandard 2026.10Controls 4/4DOCXXLSXPPTX
Meridian Coffee Co. (Demo) · Price-cost-volume-mix variances · October 2026BLQ-004 · Block
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 4/4 · BLQ-004 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 4/4
BLQ-004 · Price-cost-volume-mix variances · October 2026 · illustrative example with fictitious data
  • One-page Word (.docx) section
  • Excel (.xlsx) with Data, Calculation (each effect as a visible formula) and Control = 0
  • puente.json ready for chart GRF-001
  • Optional PowerPoint (.pptx) slide with table and bridge

Instructions for your AI; check sections, output files and controls before copying.

What it includes

5 sections, in this order

  1. 01Action title with the total figure and the two largest effects
  2. 02Table by line: Δ margin, price, cost, volume, mix and Δ %
  3. 03Gross profit mini-bridge
  4. 04What happened, why and what to do (3 to 5 bullets)
  5. 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.

On failure, instructions require a stop and an explanation.

What the prompt contains, block by block

Prompt outline

  1. 0Before you paste your filesFixed456
  2. 1Role, audience and business context646
  3. 2Parameters700
  4. 3Repporti standard549
  5. 4Data contract797
  6. 5Questions first316
  7. 6Validation with a hard stop437
  8. 7Calculation by code224
  9. 7-bisNo-code modeFixed325
  10. 8Formulas706
  11. 9Structure1,077
  12. 10Writing without «AI slop» and without invention461
  13. 11Notation (IBCS / ISO 24896:2026, theme TEM-001) and accessibility540
  14. 12QA, traceability and seal695
The licensed prompt is provided when copied.≈ 30,014 characters + cuadre.py (439 lines)

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 Standard

How to use it

From the trial balance to the report in three steps

  1. 01Configure and copyCheck profile and period before copying.
  2. 02Paste into your AIPaste the prompt and attach anonymized files in your AI.
  3. 03Review and deliverCheck controls and seal before sharing.

Anonymize before pasting

  • Company → alias; tax identifier → ID-XX.
  • People → codes. Keep the mapping on your device.
  • Use business AI, API or disable training.

Files and figures go to your AI; Repporti does not receive them.

Made for whoever delivers the report

Who it is for

Finance manager / CFOAccountant / firm
Area
Profitability and costs
Frequency
Whenever you need it
Industry
Retail and wholesale, Manufacturing, Agriculture and food

Which AI it works with

Compatibility

LevelAI
With code executionChatGPT · ClaudeRequires file analysis and Python execution for cuadre.py.
No-code modeCopilot · GeminiExcel 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.