AFE Cost Tracker: Budget vs Actual, S-Curve, Earned Value Analysis (CPI/SPI/EAC)
Track a well AFE line by line: budget vs actual and committed, a flag and severity on every line, forecast at completion, a revised AFE that includes approved change orders, and live earned value (CPI, SPI, EAC, ETC, VAC).
TAGLINE
Track a well AFE line by line: budget vs actual and committed, a flag and severity on every line, forecast at completion, a revised AFE that includes approved change orders, and live earned value (CPI, SPI, EAC, ETC, VAC).
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 20 line items, with contingency calculated as 10% of the other lines. Calculates variance ($ and %) and a forecast at completion for each line, colour-codes over-budget lines, and validates status (Complete/In Progress/Planned/On Hold) and cost category with drop-downs. Approved change orders roll into a revised AFE. Plots a cumulative S-curve (planned vs actual spend by milestone) and runs a live Earned Value Analysis from your physical and planned % complete: CPI, SPI, EAC, ETC and VAC.
TABS INCLUDED (10)
• Instructions • AFE Line Items — description, code, budget, actual, committed, variance, % spent, status, category, forecast at completion • Cost vs Budget — % consumed and forecast by cost category • Variance Flags — all 20 lines with a live flag (OVER / AT RISK / UNDER / ON BUDGET / WITHIN AFE) and severity • AFE Summary — total budget, actual, committed, % spent, flag counts, approved change orders, revised AFE, projected final cost • Variance Analysis — budget vs actual bar chart data ($K) • S-Curve & Cash Flow — cumulative planned vs actual spend over 20 milestones • Change Orders — 10-row register with description, cost, approval drop-down, cumulative approved • Cost Allocation — cost by category (drilling, casing & cement, completion/frac, surface facilities, G&A/other) • Earned Value Analysis — EV, PV, AC, CV, SV, CPI, SPI, EAC, ETC, VAC with live 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); ETC = EAC−AC; VAC = BAC−EAC (saving or overrun) • BAC = revised AFE (original AFE plus approved change orders) • Forecast at completion per line: actual for complete lines, else the larger of budget, actual and committed • S-curve: cumulative % of AFE by milestone • Change orders: each approved change updates the revised AFE
TECHNICAL SPECS
• Excel 2016+ compatible • 750+ formulas across 10 tabs • Sample AFE: $3.69MM 20-line drilling and completions well • MDT color scheme
ABOUT RESERVOIR RISK SOLUTIONS
Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. www.reservoir-risk-solutions.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
Licence
Single-user licence: the purchaser may use and modify this workbook for their own work, including work for their employer and clients. It may not be resold, shared publicly or redistributed as a template. Results are engineering estimates for screening and must be checked by a qualified professional before they are relied on.
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.
