Determines sales volumes for oil, gas, water, and plant products (NGLs) and calculates gross revenues based on sales volumes and commodity sales prices
Usage and Configuration
To perform the calculations run the workflows from this package starting with the workflow Economics - Gross Sales And Revenues. The schedules may be adapted to use different contexts.
Follow the steps given in How do I configure packages pulled from Datagration's package repository to change the configuration of the package.
Use the workspace values EconomicsEffectiveDate and EconomicsAnalysisMonths to specify the start and the duration of the scope Economics. This scope will be used during the calculations.
Use the workspace value EconomicsHierarchyName to define which hierarchy to use during the calculations. Make sure this hierarchy exists and contains all wells price forecasts shall be calculated for.
Use the workspace value EconomicsParentEntityType to define the entity type of the parents used for copying the price forecasts to well level.
Preparations
- Input all required static signals for parent entities using the data view Economics - Revenues Static. This data view stores the information in the scenario Economics - Revenues Base by default. These are values that will be applied for all wells of that parent in the specified hierarchy.
- Specify the scenarios used for pulling production forecasts, and sales price data in the scenario Economics - Revenues Base.
Details
Workflow Economics - Gross Sales And Revenues
The workflow consists of three steps:
DeleteReferenceTableData - Volumes
This step deletes existing data in the reference table Economics - Volumes. This table is used to store the calculated sales volumes for each processed entity and scenario.
DeleteReferenceTableData - Revenues
This step deletes existing data in the reference table Economics - Revenues. This table is used to store the calculated revenues for each processed entity and scenario.
Economics - Gross Sales Volumes And Revenues
This P# script determines sales volumes for oil, gas, water, and plant products (NGLs) and calculates gross revenues based on sales volumes and commodity sales prices. Sales prices and production forecasts are loaded from the configured scenarios.
Data Requirements
The following data is required on parent level:
basis for ngl yield
butane yield
condensate butane content
condensate ethane content
condensate methane content
condensate pentane+ content
condensate propane content
ethane yield
gas plant fuel shrink
gas plant process loss
pentane+ yield
propane yield
The following data is required on well level:
from the forecast scenario:
produced oil per time increment
produced gas per time increment
produced condensate per time increment
produced water per time increment
from the sales price scenario:
oil sales price
gas sales price
condensate sales price
ethane sales price
propane sales price
butane sales price
pentane+ sales price