SP-5: Production Forecast & Workover Economic Justification
SP-1 through SP-4 have completed the pre-treatment skin audit: S′ = +14, confirmed as formation damage, with post-acid target Sd = +1.0. Now you answer the question every stakeholder is actually asking: how much oil will the well produce after treatment, and is the investment worth making?
Standing's Flow Efficiency translates the skin numbers into production rates through a single elegant formula. FE = 7/(7+S) gives the ratio of actual to ideal deliverability. By computing FE before and after treatment, then scaling the ideal PI, you obtain both IPR curves and all economic inputs. The dual IPR chart and NPV calculation produced in SP-5 form the core of the Final Report.
| Parameter | Symbol | Value | Units | Notes |
|---|---|---|---|---|
| Jideal (S = 0) | Jideal | 1.380 | stb/d/psi | SP-1 locked |
| Pre-treatment skin | Spre | +14.0 | — | SP-2 locked |
| Post-treatment skin (acid only) | Spost | +1.0 | — | SP-3 locked |
| Average reservoir pressure | p̄R | 4,200 | psia | Hub Data Pack |
| Operating pwf | pwf | 2,500 | psia | Hub Data Pack |
| Oil price (gross) | — | 75 | $/bbl | Base case economics |
| Lifting + operating cost | — | 5 | $/bbl | Net = $70/bbl |
| Acid treatment cost | — | 450,000 | USD | Coil-tubing acid, Niger Delta estimate |
| Benefit duration (conservative) | — | 24 | months | Agbada analogue well data |
| Discount rate | r | 10 | %/yr | Company hurdle rate |
- FE = Jactual/Jideal = 7/(7+S)
- q = J × (p̄R − pwf)
- NPV = PV(monthly revenues) − treatment cost
- Payback = cost / daily revenue gain
- FE at S=+14 and at S=+1?
- qpost at pwf = 2,500 psia?
- How many days payback on $450K?
- 24-month NPV at $75/bbl?
- Break-even oil price?
- FEpre = ________ | qpre = ________ stb/d
- FEpost = ________ | qpost = ________ stb/d
- Δq = ________ stb/d
- Payback = ________ days
- NPV (24 mo) = $________
Just-in-Time Resources
Pull these up as you work SP-5. Each maps to the Module 03 topic behind this sub-problem: read the topic page, watch the matching lectures, then reproduce your numbers with the verified calculator.
Lecture 3.5b — Constructing FE-Modified IPR Curves: Single-Phase and Two-Phase
Lecture 3.5c — Workover Economics: Using FE to Justify Treatment Investment
SP-5 Calculation Tasks
- Calculate FEpre and FEpost — two methods
Method A (7-approximation): FE = 7/(7+S) for S = +14 and S = +1
Method B (exact log): FE = ln(0.472·re/rw) / [ln(0.472·re/rw) + S] using ln(0.472×1650/0.35) = 7.707
Tabulate both results and note the percentage difference.Expected (7-approx): FEpre = 0.3333, FEpost = 0.8750. Expected (exact log): FEpre = 0.3551, FEpost = 0.8851. - Calculate J and q for both conditions at pwf = 2,500 psia
Jpre = FEpre × Jideal → qpre = Jpre × 1,700
Jpost = FEpost × Jideal → qpost = Jpost × 1,700
Verify qpre ≈ 782 stb/d (confirms internal consistency of skin audit chain from SP-1 through SP-4).Expected: Jpre = 0.460 stb/d/psi, qpre = 782 stb/d ✓. Jpost = 1.208 stb/d/psi, qpost ≈ 2,053 stb/d. Δq ≈ 1,271 stb/d. - 5-point dual IPR table and annotated chart
For pwf = 4,200 / 3,500 / 2,500 / 1,500 / 0 psia: calculate qpre, qpost, qideal (S=0).
Draw all three curves on the same axes. Label: current operating point (782 stb/d), post-acid operating point (~2,053 stb/d), AOF for each curve, shaded gain between pre- and post-acid curves. - Economic calculation — payback and NPV
Payback: Daily net revenue = Δq × ($75 − $5) = 1,271 × $70 = ?/day. Payback = $450,000 / daily revenue.
NPV (24-month benefit period, 10%/yr discount):
Monthly CF = Δq × 30.4 days × $70/bbl
Annuity factor A = (1 − (1+0.10/12)−24) / (0.10/12)
PV(revenues) = Monthly CF × A ÷ 12 (programme monthly-annuity convention)
NPV = PV(revenues) − $450,000
Report NPV to the nearest $100K. Also calculate NPV at $50/bbl and $100/bbl.Expected: daily gain ≈ $88,970/day. Payback ≈ 5.1 days. Monthly CF ≈ $2,705K. Annuity factor ≈ 21.67. PV ≈ $4.88M (Monthly CF × 21.67 ÷ 12). NPV ≈ $4.4M. This is a high-value treatment — 1,271 stb/d incremental production over 2 years at $70/bbl net. The treatment cost ($450K) is small vs the production value. - Sensitivity table — post-treatment skin vs economics
For Spost = 0, +1, +3, +5, +8, +14 (ideal to no benefit): compute FEpost, qpost, Δq, monthly CF, and 24-month NPV at $75/bbl. State: at what post-treatment skin does the NPV fall below the treatment cost ($450K)? (It will be very high Spost — near +14.) - Nodal analysis note (qualitative)
Explain why a full nodal analysis (IPR + tubing performance curve intersection) would give a higher Δq than the fixed pwf = 2,500 psia calculation. In which direction does this change the NPV? Does this affect the investment decision?The improved post-acid IPR intersects the TPC at a lower pwf, accessing additional drawdown that was unavailable pre-treatment. This increases Δq beyond the 1,271 stb/d estimated here. The fixed-pwf approach is therefore conservative — the true economic upside is larger than the NPV calculated above.
✅ SP-5 Checklist
- FE table: FEpre and FEpost by both methods. J and q for each.
- Verification: qpre (FE method) = 782 stb/d matches SP-1 DST ✓.
- 5-point IPR table: qpre, qpost, qideal at five pwf values.
- IPR chart: Annotated with operating points, AOF values, shaded gain area.
- Economics: Payback ~5.1 days; 24-month NPV ≈ $4.4M at $75/bbl. Calculations shown in full.
- Sensitivity table: Spost = 0 / +1 / +3 / +5 / +8 vs NPV.
- Nodal analysis note: Fixed pwf method is conservative; actual Δq and NPV higher.