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

tip

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

1. Planning: The PMO creates the FY2027 annual period with CAPEX envelope of $340M and OPEX envelope of $95M.
2. Approved: After the steering committee signs off in November, the period transitions to approved. Project-level budget lines can now be created against it.
3. 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:

1. Fetches all active (non-baseline) budget lines for the project
2. Determines the next version number (auto-incremented or manually specified)
3. Copies each line with isBaseline = true and a baselinedAt timestamp

tip

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

tip

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

caution

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