1 / 37

Planning System requirements

Planning System requirements. Jon Ingham Business Development Manager Merak 27 th August 2004. Planning System requirements (1). Common database with single data repository for planning data Access to the planning system by all planning participants

haru
Download Presentation

Planning System requirements

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Planning System requirements Jon Ingham Business Development Manager Merak 27th August 2004

  2. Planning System requirements (1) • Common database with single data repository for planning data • Access to the planning system by all planning participants • Ability to provide scenario modelling / sensitivities using variable parameters (& not have to go back to all the participants in the plan) • Ability to hold guidance instructions and narratives with messaging updates • Control over template content and information to be submitted

  3. Planning System requirements (2) • Facilitates the process for the distribution, completion & collection of templates • Controls over access, data entry, data review of submissions, flow of planning process • Ability to hold actuals, budgets & forecasts and narratives for variance explanations • Consolidations & allocations processing functionality • Ability to have the functionality provided by the numerous Excel spreadsheets • Ability to handle volumetric data • Ability to provide resource & head count modelling

  4. Planning System requirements (3) • Ability to track status of data through various stages - draft, reviewed, validated, ILT approved, awaiting further input from other participants, etc • Provides confidence in accuracy of calculations • Enables changes to “templates” to be made centrally and in a timely manner • Ability to upload budgets to SAP and to receive actuals downloads from SAP • Provides enhanced central control in the running of the planning process • Provides a streamlined process

  5. Planning System requirements (4) • Transparency in the analysis of data - ability to look at a number and understand how created • Workflow management functionality as the planning co-ordination process is workflow driven

  6. Peep & Fiscal Model Library (1) • Single point of data entry • Prices, Production, Capex, Opex etc… • Can be linked to other data sources (Eclipse, Production dB) • User access control, all participants can use. • Scenarios and Sensitivities. • Warranty that fiscal models match published terms. • All models are fully auditable. • Fiscal terms easily modified by the user.

  7. Peep & Fiscal Model Library (2) • Head count and other resources can be included. • FML standards facilitate template collection and distribution. • Templates can be fully supported under subscription. • Template changes can be turn around quickly. • Planning cycle can be managed centrally. • Streamlined process for consolidation, roll up, ring fence etc. • Standard tool set and outputs.

  8. Additional Considerations • Reserves Management • Planning & Portfolio Optimisation • Financial (P&L & Bal Sheet forecast)

  9. Custom Solutions….. • Workflow management • Web portal options • SAP integration • Granularity • Synchronisation / workflow

  10. Merak Core Products + INTEGRATION Production dB Actuals Merak PEEP FML Merak CAPITAL PLANNING Merak PETROLEUM FINANCIALS Economic Results • Economic Model • Economic Calcs. • Financial Model • Financials Calcs. Merak Results Broker • Results DB • Economic Results • Financial Results SAP Merak VOLTS Reserves Reporting Systems

  11. Discussion

  12. PEEP, FML & ResBro • Utilise the input data provided by Opco’s • PEEP data transfer by pex • Excel import/export utility for PEEP • Excel data links directly to RESBRO • Calculate economic results consistent with Opco’s • Standardised economic models FML • Compare cases easily in PEEP

  13. Fiscal Model Library (FML) Regions North West Europe (6) North East Europe (2) United Kingdom (1) North America Frontier (3) Southern Europe (4) Central Asia (4) North Africa (7) Middle East (8) Southern Asia (5) West Africa (8) South China Sea (9) Central Africa (4) South America Atlantic (9) South America Andean (8) Australasia (4) Southern Africa (6)

  14. FML Standards • Input Standards - links to engineering data/systems • Modeling Standards - improve auditing capabilities and give every model the same look & feel • Output Standards - consistent reporting, easy consolidations, and comparison of opportunities worldwide • Enable all evaluations to be 100% compatible • Fiscal Regime Analysis Tool • Financial & Planning overlays can be fully supported

  15. FML Fiscal Terms Easily Modified

  16. FML Common Reporting Across All Regimes

  17. FML Common Reporting Across All Regimes

  18. FML Graphics Tool (Excel) • Visualize Results and Compare Regimes

  19. FML Graphics Tool (Excel) • Visualize Results and Compare Regimes

  20. PEEP & PEEP security • Provide flexibility, able to quickly recalculate scenarios based on latest information (premises) from company or external market. • Support re-calculation of forecast cash flow and taxes based on new price assumptions • Batch price or scenario updates in PEEP • PEEP database links • Allow a central group to manipulate scenarios (of price and investment) rather than having to go back to Opco’s. • PEEP security

  21. Batch Price Update

  22. PEEP security (option)

  23. PEEP security • Version control data sets • ResBro results sets • Assist the communication process between Opco’s, regions and controllers through the planning cycle CentraldB • Common data and tools • PEEP security • PEEP comments • ResBro results sets HQ Planning Opco’s

  24. PEEP data management options • Remote access OR File transfer OR Combination Central dB Planning dB HQ Planning UK dB Opco’s Egyp dB Lybia dB Using secure partitions

  25. PEEP data management • Track changes made at different stages of the planning process. • PEEP case comments • View data and results in hierarchy based on company structure • Move projects between hierarchy nodes • Manage targets at individual hierarchy and consolidated level • All Merak products support attributes • Supports flexible data management and workflows • View data in different units (ie currency), depending upon department (opco, asset, HQ) • Unit conversions in PEEP reports

  26. PEEP / CAPITAL PLANNING • Compare different versions and perform sensitivity • PEEP Batches, Consolidation & Roll Ups • Recalculate quickly based on new constraints or targets supplied. • Rules & Goals in CAPITAL PLANNING • Shift projects in time. • PEEP Batch and Schedule • Project shifting in CAPITAL PLANNING

  27. PEEP / PETROLEUM FINANCIALS • Calculate financials. • Calculate key indicators used as targets • PEEP can model simplified financial indicators • Full hierarchical computations in PETROLEUM FINANCIALS • Integration with existing planning system

  28. Corporate Tax DD&A Inter Country Tax ROCE PETROLEUM FINANCIALS – Hierarchy Driven Group Group Model Africa Africa Model Angola Angola Nigeria Nigeria Asset ASSET1 Model Asset ...... Model Asset Asset n Model Oman Oman N etc ETC W E S

  29. Petroleum Financials - Analyze Financial Results

  30. Petroleum Financials - Incremental or Sensitivity Analysis Incremental Analysis Price Sensitivities

  31. Merak Core Products + INTEGRATION Production dB Actuals Merak PEEP FML Merak CAPITAL PLANNING Merak PETROLEUM FINANCIALS Economic Results • Economic Model • Economic Calcs. • Financial Model • Financials Calcs. Merak Results Broker • Results DB • Economic Results • Financial Results SAP Merak VOLTS Reserves Reporting Systems

  32. Geo - Analysis Performance Opportunity Analysis OFM Eclipse Etc. 1 Project Audit Reserves VOLTS PEEP Economic Opportunity PLDB EOD Analysis Inventory Production Storage Forecast Actual Project Execution 3 Portfolio Analysis Corporate & BU Planning 2 CAPITAL PLANNING Project Initiation Budget Process Framework – The “Worktable” FDP Reserves Documentation Intranet Site Field/RMU

  33. Map Plots Reserves Production Forecast Actual F.D.P. Asset/Field Live link Field/Asset Opportunity Economic Inventory Analysis Reports Worktable Environment(Asset Team View) Intranet Site Documents

  34. MRMObjects.dll Merak Database Result Metadata Result Data Tables Result Validator Result Reader PeepDispatch.dll Result Writer Peep Object Peep Result Generator Result Request Results Provider Data Components Results Broker OCX Components MRMocx.dll Clients Peep Capital Planning Reporting …Others ResBro Design & Implementation Result Set Administrator (GUI) RMAdmin.exe Volts CapIT Business Objects Excel FinPlan SAP FinPlan

More Related