AFE Cost Tracker — Budget vs Actual, S-Curve, Earned Value Analysis (CPI/SPI/EAC)
Real-time AFE tracking with automatic over-budget flags, S-curve planned vs actual, and full Earned Value Analysis — CPI, SPI, EAC, VAC, and forecast final cost.
TITLE
AFE Cost Tracker — Budget vs Actual, S-Curve, Earned Value Analysis (CPI/SPI/EAC)
PRICE
$79 USD — one-time purchase
TAGLINE
Real-time AFE tracking with automatic over-budget flags, S-curve planned vs actual, and full Earned Value Analysis — CPI, SPI, EAC, VAC, and forecast final cost.
WHO IT'S FOR
Drilling engineers, completions engineers, and operations supervisors who need to track well costs against AFE budget, report variance to management, and forecast final cost at completion.
WHAT IT DOES
Organises your AFE into 17 line items. Automatically calculates variance ($ and %), colour-codes over-budget items, tracks status (Complete/In Progress/Planned/On Hold), plots a cumulative S-curve (planned vs actual spend), and runs a full Earned Value Analysis to forecast cost at completion, cost performance index, and schedule performance index.
TABS INCLUDED (10)
• Instructions • AFE Line Items — description, code, budget, actual, committed, variance • Cost vs Budget — % consumed by cost category • Variance Flags — only over-budget items listed with severity • AFE Summary — total budget, actual, committed, remaining, % spent • Variance Analysis — budget vs actual bar chart data • S-Curve & Cash Flow — cumulative planned vs actual spend line chart • Change Orders — 10-row register with description, cost, status, approval • Cost Allocation — cost by phase (drill/case/cement/complete/facilities) • Earned Value Analysis — EV, PV, AC, CV, SV, CPI, SPI, EAC, ETC, VAC with status flags
KEY FEATURES
• EVA: CPI = EV/AC (>1 = under budget); SPI = EV/PV (>1 = ahead of schedule) • EAC = BAC/CPI (revised final cost forecast); VAC = BAC−EAC (saving or overrun) • S-curve: cumulative % of AFE by milestone • Change order: each approved change auto-updates total AFE
TECHNICAL SPECS
• Excel 2016+ compatible • 375 formulas across 10 tabs • Sample AFE: $3.35MM 17-line drilling and completions well • MDT color scheme
SHOP COPY
10-tab AFE tracking workbook: 17 line items, over-budget flags, S-curve, change order register, and full Earned Value Analysis (CPI, SPI, EAC, ETC, VAC).
SUGGESTED TAGS
AFE tracker, well cost, budget variance, earned value analysis, CPI SPI EAC, S-curve, drilling costs, completions costs, Excel template, petroleum engineering
ABOUT RESERVOIR RISK SOLUTIONS
Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. reservoirrisksolutions.com
What you get
- Instant workbook access after payment in your Excel Library
- Formula-driven worksheet designed for petroleum workflows
- No recurring fees and no plugin requirements
FAQ
Is this a one-time purchase?
Yes. Each workbook is sold as a one-time purchase with no recurring subscription.
How do I access purchased files?
After checkout, your file appears in Excel Library under your account for download.
Do these templates require macros or plugins?
No. Templates are designed for Excel 2016+ and do not require VBA macros or external add-ins.
