---
id: po.wb.econ.workover-economics
title: Workover Economics and Budget Screening
summary: "Which workover candidates a budget should fund, from the rate each gains by removing skin, valued and risked against a decline and price deck."
category: Economics
requires:
  - po-addin
  - excel-365
tags:
  - economics
  - workover
  - skin
  - NPV
  - risk
---

## Description

Which workovers should the budget fund? You enter a shared IPR well and, for each candidate, its permeability, current and target skin, cost and chance of success, with a decline, price deck and costs to value the gain. You read off each candidate's incremental rate, its success, failure and risked NPV, and which jobs the budget funds in order of risked NPV per dollar.

**How to use it:** Enter the reservoir, fluid and common flowing pressure, and each candidate's permeability, skins, cost and chance of success, on the Candidates sheet. Set the economics deck, the well's age and the incremental decline on the Workover Cash Flows sheet, and the budget on the Programme sheet. Check the input and horizon checks first, then each candidate's uplift against its own IPR base and its post-workover rate against the type curve's initial rate. Read the ranking, the funded jobs and the spend on the Programme sheet and the Summary. Replace every illustrative input with field data before a decision.

**Method:** Each candidate's productivity index is the pseudo-steady-state vertical-well index for today's skin and for the target skin, J = k h/(141.2 Bo μo (ln(re/rw) − 0.75 + S)), and its rate at the common flowing pressure is Vogel's composite IPR, q = J (Pr − Pb) + J Pb/1.8 (1 − 0.2 (Pwf/Pb) − 0.8 (Pwf/Pb)^2). The uplift is the target-skin rate less today's. The incremental rate then declines exponentially, sampled at mid-month, until the base well's economic life ends, with the nominal decline −ln(1 − D) from the effective. The incremental barrels earn the net operating margin; the workover's WI-adjusted cost falls in month one. Fixed LOE is not incremental. The success NPV discounts the monthly net cash at the month ends. The failure NPV is the negative discounted cost; the risked NPV is Pc × success NPV + (1 − Pc) × failure NPV.

Eligible jobs have positive uplift, cost and risked NPV. They are ranked by risked NPV over the undiscounted WI-adjusted capex, ties in input order. The walk goes down the ranks once, funding each affordable job and skipping an unaffordable one while continuing to the next; the budget counts the same WI-adjusted cost. This is a greedy heuristic for indivisible projects, not an optimal knapsack; shared constraints, interactions between jobs and scheduling are left out.

**Example:** Three synthetic variations of the IPR reference well (k = 0.5 mD, skins 1, 2 and 3 to −2, Pwf = 2,000 psi) gain about 48.24, 57.61 and 65.22 STB/d. Their success NPVs are about $654,206, $700,044 and −$134,137, and their risked NPVs about $453,919, $460,827 and −$404,937. At the $1,000,000 budget the ranking by risked NPV per dollar funds A, then B, spends $850,000 and leaves $150,000. The economics are the shared decline, price deck and costs of the economics family's well; beside the candidates sit the original IPR reference well, an independent 60 STB/d workover and the full-well NPV and IRR, which is not a workover. These rounded numbers are illustrations; each blueprint gives its own on the same inputs.

## Validity

The workover cash flows run for at most 360 months and the full-well reference for at most 400 months. If either requested horizon exceeds its limit, its check and the overall verdict fail; the bounded values shown are invalid previews, and the programme excludes every candidate when the workover horizon is invalid. The IPR geometry, fluid properties, pressures, each candidate's permeability, the skin term, the cost and the chance must pass the input check. Do not decide on an invalid case.

The IPR and the economic type curve are independent examples, not a calibrated well. Both base rates are shown, with separate checks on the IPR uplift against its own base and on the post-workover type-curve rate against its initial rate. No rate is silently scaled or capped. The model ignores a workover's life extension, changing fixed costs and production acceleration. Replace every illustrative input with supported field data before a decision.

## References

- Vogel, J.V. (1968). Inflow Performance Relationships for Solution-Gas Drive Wells. *JPT* 20(1), 83-92.
- Petroleum Office blueprints `po.bp.ipr.skin.sensitivity`, `po.bp.econ.workover.decision` and `po.bp.econ.npv.irr`.

## Inputs

| Input | Unit | Default | Name |
|---|---|---|---|
| Net pay | ft | 50 | `WEC_h` |
| Oil formation volume factor | rb/STB | 1.467 | `WEC_Bo` |
| Oil viscosity | cp | 0.302 | `WEC_Uo` |
| Drainage radius | ft | 1,490 | `WEC_re` |
| Wellbore radius | ft | 0.354 | `WEC_rw` |
| Reservoir pressure | psi | 4,000 | `WEC_Pr` |
| Bubble point | psi | 2,620 | `WEC_Pb` |
| Common flowing pressure | psi | 2,000 | `WEC_Pwf` |
| Permeability (candidates A, B, C) | mD | 0.5, 0.5, 0.5 | `WEC_A_k`, `WEC_B_k`, `WEC_C_k` |
| Current skin | — | 1, 2, 3 | `WEC_A_Skin`, `WEC_B_Skin`, `WEC_C_Skin` |
| Target skin | — | −2, −2, −2 | `WEC_A_Target`, `WEC_B_Target`, `WEC_C_Target` |
| Workover cost | $ | 350,000, 500,000, 1,500,000 | `WEC_A_Cost`, `WEC_B_Cost`, `WEC_C_Cost` |
| Chance of success | % | 80 % each | `WEC_A_Pc`, `WEC_B_Pc`, `WEC_C_Pc` |
| Economics deck: the shared well's life cap, type curve, prices, interests, Texas taxes, operating costs and discount rate | various | the economics family's well (800 STB/d, $70/STB oil, 10 %) | `WEV_*` |
| Months the well has produced before the workover | months | 36 | `WEV_Age` |
| Decline of the incremental rate, effective (exponential) | %/yr | 50 % | `WEV_UpDecl` |
| Incremental oil rate the workover adds at the start (60 STB/d reference) | STB/d | 60 | `WEV_Reference_Uplift` |
| Workover cost, paid in the first month (reference) | $ | 350,000 | `WEV_Reference_Cost` |
| Chance the workover succeeds (reference) | % | 80 % | `WEV_Reference_Pc` |
| Longest acceptable payout, from the workover | months | 12 | `WEV_PayoutMax` |
| Full-well reference: the same well's inputs | various | the economics family's well | `WEN_*` |
| Available budget | $ | 1,000,000 | `WEP_Budget` |

## Sheets

- `Guide` — what the workbook screens, how success, failure and risk are valued, and the limits of the greedy programme.
- `Candidates` — the shared IPR inputs, candidates A, B and C with their permeability, skins, cost and chance, each one's productivity index and IPR rate before and after treatment, the skin-derived uplift, the original IPR reference and the candidate checks.
- `Workover Cash Flows` — the economics deck, the base decline and remaining life, each candidate's and the 60 STB/d reference's incremental rate, success, failure and risked NPV, payout, PV/I, break-even chance and uplift, the monthly incremental cash flows and a chart of their first 60 months.
- `Well Reference` — the independent full-well NPV, IRR, payout, PV/I, EUR and net cash from a monthly cash flow, with its horizon check.
- `Programme` — the budget, each candidate's eligibility, risked NPV per dollar and rank, the greedy walk funding or skipping each rank, and the spend, headroom and funded NPVs.
- `Summary` — the programme's spend, headroom, NPVs and selected candidates, and every check under one verdict.
- `Test Cases` — the worked example and other cases, with expected and computed results.

The add-in supplies the IPR functions; Excel 365 supplies dynamic arrays.

## Functions used

`PO.IPR.VW.PSS.PI`, `PO.IPR.VW.PSS.Rate.ByVogel`, `PO.ECON.NPV.Monthly`, `PO.ECON.IRR.Monthly`, `PO.ECON.Payout`.
