---
id: po.wb.mbe.oil-material-balance
title: Oil Material Balance
summary: "Takes an oil reservoir from its history to OOIP, drive indices and an aquifer match, then forecasts recovery below the bubble point."
category: Reservoir
requires:
  - po-addin
  - excel-365
tags:
  - MBE
  - material-balance
  - oil
  - ooip
  - Havlena-Odeh
  - Campbell-plot
  - drive-indices
  - underground-withdrawal
  - expansion-term
  - compressibility
  - aquifer
  - water-influx
  - Fetkovich
  - veh
  - Tarner
  - Tracy
  - forecast
  - solution-gas-drive
  - recovery-factor
---

## Description

How much oil is in place, what drives the reservoir, and how much will it recover below the bubble point? You enter the initial PVT and one row a pressure survey (pressure, Np, Gp, Wp, Winj, We, Bo, Rs, Bg), the rock compressibility, an aquifer and the forecast's fluid and relative permeability. You read off the OOIP with its R2, the Havlena-Odeh and Campbell plots, the drive indices, which aquifer model gives a flat OOIP, and the oil and gas recovered from Pb to abandonment. Field units.

**How to use it:** On the Material Balance sheet, type volumetric-average pressures, cumulatives and the PVT at each pressure (below Pb, Gp, Rs and Bg too), then read N, the R2 and the Campbell plot: flat, the model holds all the energy; rising, an aquifer or a bigger gas cap. On the Compressibility sheet pick the rock type and porosity, or type a core-measured cf. For a water drive, replace the Aquifer history with the field's, adjust k and ra until the OOIP is flat, and type the matched influx into the We column of the Material Balance. On the Forecast sheet, paste lab PVT over the table and fit the Corey end points to core or the GOR history. The Summary gathers the answers and every check.

**Method:** F = Np[Bo + (Rp - Rs)Bg] + (Wp - Winj)Bw; Eo, Eg, Efw = (1 + m)Boi(cw Swc + cf)/(1 - Swc) dP and Et = Eo + m Eg + Efw; N = sum((F - We)Et)/sum(Et^2), the slope of F - We against Et through the origin, with R2 about that line, and the depletion, gas-cap, water and compaction drive indices (DDI, GDI, WDI, CDI) at every step. cf is Newman's for the rock type unless one is measured, and Efw takes it; co = (Bo - Boi)/(Boi dP), ce = co + (cw Swc + cf)/(1 - Swc), and ct follows; F/(Boi ce dP) at the last step is the undersaturated OOIP, the Campbell plot's last point and a cross-check on the line. Fetkovich steps Wei/pi (pa - p)(1 - exp(-J pi dt/Wei)); van Everdingen-Hurst superposes Dake's averaged steps on a bounded aquifer; both run over one boundary-pressure history, each step's OOIP is (F - We)/Et, set against the OOIP with no influx, and the spread is (max - min)/mean. The forecast is Tracy's form of Tarner's method from Pb to abandonment on the material balance's OOIP, three explicit passes a step: dNp = (N - Np Phio - Gp Phig)/(Phio + R Phig), the GOR from Corey curves and the PVT from Standing, DAK, Beggs-Robinson and Lee-Gonzalez-Eakin.

**Example:** Ahmed's Virginia Hills field, volumetric and undersaturated (3,685 psi, Pb 1,500 psi, Boi 1.3102 bbl/STB, Swc 24 %, cw 3.62E-06 and measured cf 4.95E-06 1/psi; Rsi 600 and Bgi 0.81 from the reference black oil cancel above Pb): twelve surveys to 3,188 psi and 2,575 MSTB. F is 3.400 MMrb and Et 0.01179 at the last step; N = 282.8 MMSTB with R2 0.992; depletion drives 56.6 % and rock and water 41.5 %, summing to 0.98. co is 1.044E-05, ce 1.81E-05, and the undersaturated form reads 288.5 MMSTB, 2.0 % above the line. The Aquifer sheet's made-up 30 MMSTB reservoir on a 360 degree aquifer (50 mD, 50 ft, 3,000 to 15,000 ft): Wei 33.8 MMbbl, J 41.2 bbl/D/psi; Fetkovich gives 4.48 MMbbl in six years and 30,027 MSTB flat to 0.8 %, where with no influx F/Et climbs from 158 to 307 MMSTB; van Everdingen-Hurst (U 705 rb/psi, reD 5) gives 4.42 MMbbl and 36,449 MSTB drifting 13.9 %. The forecast gives 12.07 MMSTB to Pb and 70.52 MMSTB, 24.9 %, and 136.9 Bscf at 300 psi; the GOR peaks at 7,953 scf/STB, and the third pass moves it 4.1 % at most.

## Validity

A tank model with one average pressure a survey. A rising Campbell plot means energy the model lacks (an aquifer, or a gas cap larger than m); early steps with a small pressure drop carry the most error. ce holds only above Pb. Fetkovich neglects the transient period; van Everdingen-Hurst assumes radial flow and short steps. The Aquifer sheet is its own example, and its We is typed into the Material Balance by hand. The forecast takes no gas cap, influx or segregation, gives oil against pressure, not time, and its krg/kro is the weakest input. Alternatives: the F/Eo against Eg/Eo form for an unknown gas cap, Carter-Tracy influx, Muskat's forecast, a black-oil simulation.

## References

- Havlena, D. and Odeh, A.S. (1963). The Material Balance as an Equation of a Straight Line. *JPT* 15(8), 896–900.
- Ahmed, T. (2006). *Reservoir Engineering Handbook*, 3rd ed. Gulf Professional Publishing, Ch. 4, 11 and 15.
- Dake, L.P. (1978). *Fundamentals of Reservoir Engineering*. Elsevier, Ch. 3 and 9.
- Fetkovich, M.J. (1971). A Simplified Approach to Water Influx Calculations — Finite Aquifer Systems. *JPT* 23(7), 814–828.
- van Everdingen, A.F. and Hurst, W. (1949). The Application of the Laplace Transformation to Flow Problems in Reservoirs. *Trans. AIME* 186, 305–324.
- Newman, G.H. (1973). Pore-Volume Compressibility of Consolidated, Friable, and Unconsolidated Reservoir Rocks Under Hydrostatic Loading. *JPT* 25(2), 129–134.
- Tracy, G.W. (1955). Simplified Form of the Material Balance Equation. *Trans. AIME* 204, 243–246.

## Inputs

| Input | Unit | Default | Name |
|---|---|---|---|
| Initial reservoir pressure, bubble-point pressure, initial oil FVF, initial solution GOR, initial gas FVF, water FVF | psi, bbl/STB, scf/STB, bbl/Mscf | 3685, 1500, 1.3102, 600, 0.81, 1 | `MBH_Pi`, `MBH_Pb`, `MBH_Boi`, `MBH_Rsi`, `MBH_Bgi`, `MBH_Bw` |
| Connate water saturation, water compressibility, gas-cap ratio m, R² accepted as a straight line, drive-index sum tolerance | —, 1/psi | 0.24, 3.62E-06, 0, 0.98, 0.02 | `MBH_Swc`, `MBH_cw`, `MBH_m`, `MBH_R2Min`, `MBH_SumTol` |
| Survey history: average pressure, Np, Gp, Wp, Winj, We, Bo, Rs, Bg | — | 12 surveys | `MBH_History` |
| Rock type for Newman's correlation (list), porosity, measured cf from core (0 uses Newman's) | —, 1/psi | Sandstone, 0.2, 4.95E-06 | `RCK_Rock`, `RCK_phi`, `RCK_cfMeasured` |
| Aquifer permeability, thickness, porosity, outer radius, reservoir radius, encroachment angle, aquifer total compressibility, water viscosity, initial pressure | mD, ft, °, 1/psi, cp, psi | 50, 50, 0.2, 15000, 3000, 360, 7E-06, 0.5, 4000 | `AQF_k`, `AQF_h`, `AQF_phi`, `AQF_ra`, `AQF_rr`, `AQF_theta`, `AQF_ct`, `AQF_Uw`, `AQF_Pi` |
| Aquifer model the match reads (list), OOIP spread accepted as a match | — | Fetkovich, 0.05 | `AQF_Model`, `AQF_SpreadMax` |
| Stock-tank oil gravity, solution gas specific gravity, reservoir temperature | °API, —, °F | 40, 0.8, 160 | `TTF_API`, `TTF_GasSG`, `TTF_T` |
| Critical gas saturation, residual oil saturation to gas, gas relative permeability at residual oil, Corey exponents for oil and gas | — | 0.05, 0.15, 0.8, 3, 2 | `TTF_Sgc`, `TTF_Sorg`, `TTF_KrgMax`, `TTF_NoExp`, `TTF_NgExp` |
| Abandonment reservoir pressure, producing GOR the wells and plant can handle, GOR change accepted as converged | psi, scf/STB | 300, 10000, 0.05 | `TTF_Pab`, `TTF_GorMax`, `TTF_MoveTol` |

## Sheets

- `Guide` — what the workbook answers, the order to work through its sheets and the examples it carries.
- `Material Balance` — the initial PVT and one row a survey, F and Eo, Eg, Efw and Et on every step, the OOIP as the slope of F - We against Et through the origin with its R2, the Havlena-Odeh and Campbell plots, and the drive indices at every step.
- `Compressibility` — Newman's cf for the rock type picked from a list, or a measured one, which Efw takes; co from the Bo history, ce, ct and the undersaturated OOIP cross-check.
- `Aquifer` — a Fetkovich and a van Everdingen-Hurst aquifer over one boundary-pressure history, the OOIP each implies at every step against none, and the model picked from a list checked for a flat OOIP.
- `Forecast` — Tracy's form of Tarner's method from Pb to abandonment on the material balance's OOIP, three passes a step, with pressure, GOR and recovery.
- `Summary` — the answers and every check under one verdict.
- `Test Cases` — the worked example and other cases, with expected and computed results.

Five charts: the Havlena-Odeh and Campbell plots, the OOIP at each step for no influx, Fetkovich and van Everdingen-Hurst, and the forecast's pressure and GOR against Np and recovery against pressure.

## Functions used

`PO.MBE.F.Oil`, `PO.MBE.Exp.Eo`, `.Eg`, `.Efw`, `.Et`, `PO.MBE.Oil.OOIP.Reg`, `PO.MBE.Oil.OOIP`, `PO.MBE.Oil.OOIP.We`, `PO.MBE.Drives.DDI`, `.GDI`, `.WDI`, `.CDI`, `PO.SCAL.Cf.Sand.ByNewman`, `PO.SCAL.Cf.Lime.ByNewman`, `PO.MBE.Ce.PoreVol`, `PO.MBE.Ce.UnSat.Oil`, `PO.MBE.Ce.Total`, `PO.MBE.Aq.Fet.Wi`, `.J`, `.Wei`, `.We`, `.Pa`, `PO.MBE.Aq.VEH.U`, `.reD`, `.tD`, `.We`, `PO.PVT.Rs.ByStanding`, `PO.PVT.Bo.Sat.ByStanding`, `PO.PVT.Uo.Dead.ByBeal`, `PO.PVT.Ppc.BySutton`, `PO.PVT.Tpc.BySutton`, `PO.PVT.Z.ByDAK`, `PO.PVT.Bg.ByDefinition`, `PO.PVT.Uo.Sat.ByBeggsRobinson` and `PO.PVT.Ug.ByLGE`.
