Budget & Forecast
Build multi-year budget plans and rolling forecasts for standard product portfolios. Plan BasePrice, Surcharges, and Quantity across customers, products, and plants — with four dedicated roles, budget versioning, and PowerQuery connectivity for Power BI reporting.
Why Budget & Forecast with ORAGO
Revenue Formula Engine
Revenue is always computed from three drivers: BasePrice + Surcharges × Quantity. Never entered directly. Every budget line is auditable down to the individual driver that changed.
Rolling Forecasts
Copy-and-adjust workflow: take the last budget version, update only what changed. Historical months are locked automatically. Forward-looking months can be re-planned freely.
3-Year Planning Horizon
Current year forecast + Budget Year 1 + Budget Year 2. Monthly granularity across the full horizon. Version-level exchange rates for multi-currency consolidation.
Multi-Plant Consolidation
Plan across 2 to 20 production sites. Each plant enters data independently. Automatic roll-up to business unit or group level — no manual consolidation required.
RBAC by Dimension
Four roles: Controller (full access), Sales (assigned customers/products), Plant Manager (assigned plant), Finance (read-only + approval). Enforced at the data layer, not just the UI.
PowerQuery Reporting
Connect Power BI or Excel directly to the planning database. Schema is stable and documented. No CSV exports needed — live data connection for board-ready reporting.
From Budget Line to Revenue Plan
The budget entry screen uses a three-panel layout: article list (left), monthly data entry (centre), and article info (right). Each budget line represents one Product × Customer × Plant × Month combination with three commercial drivers.
- Article list with completion status and filtering by entity/customer
- Monthly data grid: Net Price, Surcharges, Quantity, Sales columns
- Currency toggle: Document Currency, Local Currency, or Euro
- Historical months locked; editable months highlighted
- Completed toggle per article for workflow tracking
From Three Drivers to a Complete Budget
ORAGO Planning structures every budget line around three commercial drivers: BasePrice, Surcharges, and Quantity. Revenue is always derived — never entered manually. This means when actuals deviate from plan, you know immediately whether the cause was price, volume, or surcharge.
- Copy-and-adjust workflow: start from last version, update what changed
- Version-level exchange rates for multi-currency consolidation
- Configurable surcharge types: material, energy, logistics, tooling
- Idempotent actuals import from SAP exchange tables or Excel
- Full audit trail: user, timestamp, old and new values
Plan Once a Year, or Continuously.
Budget versions are immutable after publication. When you need to re-forecast, copy the last version and adjust only the lines that changed. Historical months are locked at the data layer. Current year auto-updates with ERP actuals. All versions retained for comparison.
- Named budget versions with copy-and-adjust workflow
- Copy granularity: full budget, by plant, by customer, by product family
- Plan vs. actual comparison at any aggregation level
- Price, volume, and surcharge variance decomposition
Coming Soon: Deeper Analysis and Reconciliation
Phase 2 brings top-down/bottom-up reconciliation, profitability reporting, and capacity planning — all currently in development.
Plan with Real Numbers
See how ORAGO Planning gives your entire budget team a shared live workspace — no exports, no spreadsheets, no version conflicts.