Budgets & Costs
A Global VP of Engineering is presenting the FY2027 capital plan to the CFO. The portfolio includes $340M in CAPEX across fourteen projects: three facility builds, four equipment qualifications, five packaging line upgrades, and two digital plant initiatives. The CFO asks a simple question: "What is the CAPEX versus OPEX split for the biologics site, and how does actual spend compare to the approved baseline?" In most organizations, answering that question requires two weeks of data extraction from SAP, reconciliation against project spreadsheets, and manual aggregation. In ProBeya, it takes one click.
The Budgets and Costs module provides fiscal budget period management, per-project budget lines with versioning and baselines, individual cost entry tracking with approval workflows, and aggregated summaries by WBS element and cost category. It is designed to speak the language of pharmaceutical finance: equipment qualification, validation labor, commissioning services, and regulatory submission fees all map naturally to the cost model.
Understanding Pharma Capital Cost Structures
Pharmaceutical capital projects have cost structures that differ significantly from IT or commercial construction projects. ProBeya's nine cost categories are designed to capture this complexity:
| Cost Category | CAPEX/OPEX | Pharma Examples |
|---|---|---|
| Internal Labor | Typically OPEX | Project engineers, validation specialists, quality reviewers |
| External Labor | CAPEX or OPEX | Contract engineers, EPCM firms, commissioning contractors |
| Materials | CAPEX | Construction materials, piping, HVAC ductwork, cleanroom panels |
| Equipment | CAPEX | Bioreactors, filling machines, autoclaves, CIP/SIP systems |
| Software License | CAPEX or OPEX | MES, DCS/SCADA, historian, serialization software |
| Travel | OPEX | FAT attendance, vendor site visits, inter-site coordination |
| Overhead | OPEX | Project management office, allocated corporate services |
| Contingency | CAPEX | Management reserve (typically 10-15% for pharma capital) |
| Other | Varies | Regulatory filing fees, training programs, insurance |
The CAPEX/OPEX classification matters enormously for pharma companies. CAPEX flows through the balance sheet and is depreciated over the asset's useful life. OPEX hits the P&L immediately. A $100M facility build might be 70% CAPEX (equipment, construction, qualification) and 30% OPEX (project management, travel, training). Getting this split right in the budget model prevents painful reclassifications during year-end close.
Budget Periods
Budget periods represent fiscal envelopes at the portfolio level. Each period has:
- Fiscal year and optional quarter (null quarter means annual period)
- CAPEX and OPEX portfolio-level budget amounts (numeric, precision 15, scale 2)
- Status:
planning→approved→locked
Status transitions are validated server-side. Only planning periods can be approved, and locked periods cannot be modified. The approvePeriod shortcut transitions directly from planning to approved.
Worked Example: FY2027 Budget Period
- Planning: The PMO creates the FY2027 annual period with CAPEX envelope of $340M and OPEX envelope of $95M.
- Approved: After the steering committee signs off in November, the period transitions to approved. Project-level budget lines can now be created against it.
- Locked: At the end of Q1 FY2027, the period is locked to prevent further changes. Any mid-year adjustments require a new period or a formal change request.
Project Budget Lines
Each project has budget lines that specify:
- Cost type: CAPEX or OPEX
- Cost category: one of the nine categories above
- Planned amount, committed amount, actual amount, and forecast-to-complete
- Phase or WBS reference for traceability to specific work packages
- Version number and baseline flag for tracking budget evolution
- Currency (multi-currency support for global portfolios)
Budget lines can be filtered by version and baseline status, enabling side-by-side comparison of the original approved budget against the current working budget.
Budget Baselines
The baselineProjectBudget procedure creates a point-in-time snapshot of all current budget lines:
- Fetches all active (non-baseline) budget lines for the project
- Determines the next version number (auto-incremented or manually specified)
- Copies each line with
isBaseline = trueand abaselinedAttimestamp
Create budget baselines at each major gate review. A typical pharma capital project will have three to four baselines: Gate 1 (concept estimate, +/- 30%), Gate 2 (detailed estimate, +/- 15%), Gate 3 (firm estimate, +/- 5%), and post-completion (final actual). This progression documents estimate maturation and provides the data for organizational estimating benchmarks.
Budget Summary and Variance
The summary view aggregates budget lines by cost type and category, computing:
- Total planned, committed, actual, and forecast amounts
- Variance: planned minus (actual + forecast)
- Positive variance means under budget; negative means over budget
For a pharmaceutical filling suite project budgeted at $45M:
| Category | Planned | Committed | Actual | Forecast | Variance |
|---|---|---|---|---|---|
| Equipment (CAPEX) | $18,000,000 | $17,500,000 | $12,200,000 | $5,800,000 | -$500,000 |
| External Labor (CAPEX) | $8,000,000 | $7,200,000 | $4,100,000 | $3,500,000 | $400,000 |
| Materials (CAPEX) | $6,500,000 | $6,500,000 | $3,900,000 | $2,600,000 | $0 |
| Internal Labor (OPEX) | $4,200,000 | $4,200,000 | $2,800,000 | $1,600,000 | -$200,000 |
| Contingency (CAPEX) | $4,500,000 | $0 | $0 | $2,000,000 | $2,500,000 |
The PMO reads this table and immediately sees that equipment costs are trending $500K over budget (vendor change orders), while contingency still holds $2.5M in reserve. Net position: manageable.
Phased Budget Distribution
The phaseBudget procedure spreads the total planned budget across a date range using a linear phasing engine. This produces a month-by-month planned spend curve for cash flow forecasting.
For pharma capital projects, the actual spend curve is rarely linear. Equipment procurement creates large step-function payments (30% at order, 30% at FAT, 30% at delivery, 10% at SAT). ProBeya's linear phasing provides a baseline that finance teams can adjust with manual overrides for known milestone payments.
Cost Entries
Individual cost entries record actual expenditures:
- Linked to a project and optionally to a specific WBS element
- Cost type (CAPEX/OPEX) and category
- Amount and optional hours (for labor entries)
- Entry date, vendor name, and description
- Approval status:
draft→pending→approved/rejected
Approved entries cannot be edited. Only draft entries can be deleted. This immutability after approval is critical for GxP environments where cost records may be subject to financial audit.
Approval Workflow
The approval workflow supports both individual and batch operations:
- Approve/Reject: single entry, with reviewer ID and timestamp
- Batch Approve: up to 100 entries in a single operation for month-end processing
Use the by WBS cost summary to identify which work packages are consuming the most budget. In pharma capital projects, qualification and validation work packages frequently overrun because the scope of testing expands during execution. Early identification through WBS-level cost tracking allows the PMO to trigger contingency release before the overrun compounds.
Sync Project Total
The syncProjectTotalBudget procedure sums all active (non-baseline) budget lines and writes the total to the project's custom fields, keeping the project-level budget figure synchronized. This ensures the portfolio summary always reflects the latest approved budget, not a stale figure from the last planning cycle.
Permissions
| Action | Required Role |
|---|---|
| Create/edit budget periods | Finance Controller or Admin |
| Approve budget periods | Finance Controller or Admin |
| Create project budget lines | Project Manager or Admin |
| Baseline budgets | PMO or Admin |
| Record cost entries | Any project member |
| Approve/reject costs | Finance Controller, PMO, or Admin |
Once a budget period is locked, no further changes are allowed. Ensure all project-level budget lines are finalized, and the CAPEX/OPEX totals reconcile with corporate finance's approved appropriation, before locking the period. Unlocking requires Admin intervention and creates an audit trail entry.
Related Features
- Projects -- Budget lines are linked to PPM projects
- WBS -- Cost entries reference specific WBS elements for granular tracking
- EVM -- Approved cost entries feed into Actual Cost (AC) for earned value calculations
- Scoring & Optimization -- Budget data drives portfolio optimization constraints and efficient frontier computation