EOM Economics
Written by Brandy Burch
Updated at March 24th, 2025
CT-1 thru CT-4
These reports will show what is set up in your Costs and Tariffs Maintenance menus so you can easily review them.
All of the reports basically work the same way.
- Enter the date range
- Next will take you into the Grid View
- Click the insert/hide columns to customize your view (see Grid View)
- Click the insert/hide columns to customize your view (see Grid View)
- Save at the bottom of the screen will remember your layout and allow you to select it the next time you come back
- Options will give you an option to Export to Excel.
- List will show the Print Preview
- PDF will allow you to save this report as a PDF
EOM-1 Economic Analysis
Overview
There is a new Sales Reporting sub-tab in Property Maintenance that captures information needed to summarize the Sales revenue from Run Ticket information. This included Sales Contract Number and Price Base Code. This information then feeds into the EOM-1 Economics Analysis - Economics by Destination Detail report.
Setup
There is no setup to turn on this feature. However, there is setup to be done in Property Maintenance.
Property > Price Contract > Sales Reporting tab #
Fill in the Product, Effective Date, Sales Contract Number, Price Base Code, and Station.
Using the green “+” and red “- “, lines can be added or removed. More than one station can be set per property.
There is also a Sales Reporting option on the Property Import feature. Using this feature found in Property > Utility > Import from Excel, you can easily update your Properties.
The Sales information will be captured when Run Tickets are entered for a specific Property/Lease/Station and the corresponding Station is used on the Offload tab.
Report: EOM-1 Economics Analysis
This report will bring in information from Run Tickets, Sales Reporting, and also Costs & Tariff rate information (if applicable) for a more complete financial overview. This allows you to better see your margin.
Cost of sales (offloads) captured from the run tickets will summarize all tickets from the destination location from the Offload tab and Sales Contract information.
| Cycle Month/Year or Ticket Effective Dates | This report allows you to filter your results by either Cycle Month/Year -OR- Ticket Effective Dates. |
| Operator | Filter report down to a single Operator |
| Property | Filter report down to a single Property |
| Destination | Filter report down to a single Destination (Offload Station) |
| Marketer | This field will include employees with type "Marketer" from Payroll - Employee Maintenance. |
| Price Contract (Exclude) | This field and corresponding Exclude check box allows you to either filter by or exclude a specific Price Contract. This populates from the Other Transportation cost table (ability to include a contract) |
| Well Region | This is based on the Well Region set on a property. However, the information itself pulls from Internal Trucking Costs. |
| Customer (Purchase Contract) | This will be an Operator record. |
| Sort By (Property #, Operator #, Marketer, County, Customer) | Select how the report will be sorted when printed/viewed/exported. |
| Reports (Detail, Summary, Recap) |
Detail – Property detail will include purchase, sale, and cost breakouts. Summary – one line per property Recap – this report will show more detailed information via columns instead of rows. |
NOTES:
- Split Loads will appear together in the destination
- Gatherer information will be segregated when a property is hauled by both a third party and an internal driver. This way margins are reported accurately.
- External Truck fee will populate/group from the tickets. If the rest of the criteria have NO match, then NO fee will display,
- If Driver # is blank on the ticket, then the Gatherer will also be blank.
- The Economics reports will correctly handle volumes and prices when contracts change on a property.
For example: When choosing cycle date range for a given property and one contract expires in January and a new contract takes over in February - The report excludes a few types of tickets
- Sales tickets (Product OSC on the Price Contract)
- Rejected tickets
- Allocated tickets (Only pull Commingled and Normal)
- Records in Daily Tank Gauge
Detail Report
| Destination Name including Property # with Destination Name | Volumes for all tickets for a destination location at the lease will be summarized. This information pulls from the Run Ticket Grid View. There is one line per contract. This will included Destination Name, Lease number, Lease name, and Description text (Sales Contract information including Contract Number, Contract name, Price Base Code, Price Index Code, Product) |
| Volume | This pulls from the Run Ticket Grid View for corresponding contracts for that destination. Volume is only recorded at the lease level. |
| Ref |
Indicates the detail line item:
|
| Avg Grav |
|
| Price |
|
| Gross | This field calculates the Volume (adjusted for average gravity) times Price. This should be a positive number as this is revenue. |
| Totals | Each section (depending on Sort By option) will have a total line. Also, the last page of the report will have totals for each Ref Type. |
Summary Report
Example of the Sort By being Property Number. In this case the Header Record will be the Destination Name.
Example of the Sort By being Operator Number. In this case the Header Record will be the Operator Name.
| Header Record | The header record will be determined by the Sort By option selected. Each line under the header line contains the Lease number and Lease name. Volumes for all tickets for a destination at the lease will be summarized. |
| Volume | This is the summary of all volumes for the lease |
| Price |
|
| Gross | This field calculates the Volume (adjusted for average gravity) times Price. This should be a positive number as this is revenue. |
| Totals for… | Each section (depending on Sort By option) will have a total line. |
| Grand Total | The Grand Total will include all previous section totals. |
Recap Report
Pulled from the Detail Report, this is a summary of all the tickets for each lease/destination combination
| MKTR - Marketer | This field will include employees with type "Marketer" (from Payroll - Employee Maintenance) on the Run Ticket for the Lease at the Destination location. |
| Customer | Run Statement Operator name |
| Gatherer |
|
| Lease number | Lease Number from Property Maintenance |
| Lease name | Lease Name from Property Maintenance |
| Destination Location | Destination Location corresponding on the Run Ticket for the Lease. |
| Miles | For certain Recap Report Ref cost types - otherwise its blank |
| Volume | This is the summary of all volumes for the lease |
| Gravity |
|
| Purchaser contract number | Pulled from the purchaser’s Property Maintenance – Price Contract tab. |
| Purchaser posting prem | Average for the contract number |
| Purchaser price | Average Purchase Price |
| PBT | Average Pipeline Barge Tariff rate |
| OTH | Average Other Transportation rate |
| INT | Average Internal Trucking rate. |
| EXT | Average External Trucking rate. |
| Total Costs | sum of PBT + OTH + INT + EXT |
| Sales contract number | Pulled from the purchaser’s Property Maintenance – Price Contract tab – Sales Reporting sub-tab. |
| Sales posting premium | Average Price Adjustment. |
| Price | Average Sales Price. |
| Margin | Sales – Purchases – Total Costs for the lease/destination location. This is a summary of fields in the Recap Ref columns. All of the detail lines are a price/bbl. |
| Profit (Loss) | Margin times Volume |
EOM-2 Inventory Historical
Used with the Sales and Inventory Feature.
After the First Purchaser Cycle is closed (Close Out Month), Inventory for that cycle will be considered final and will be available in the Inventory Historical report. Ending Inventory will be used for Opening Inventory for the next cycle.
EOM-3 Inventory Current
Used with the Sales and Inventory Feature.
Most of the columns are on this grid view on any given day. However, there are a few new ones that need to be highlighted for Inventory.
NOTE: If you would like more information on the other columns, please see the F1 Help.
| Receipts | Populated from the Run Ticket, shows BBLs delivered from the property to the station. |
| Deliveries | Populated from Sales Tickets from the station entered into Run Tickets. |
| Line Loss and Line Loss % | When adjustments are made in #12 Transfer/Adjustment Ticket, the information will show in these columns |
| Ending Inventory | Opening Inventory plus Receipts, Prior Periods, and Adjustments minus Deliveries equals ending inventory |
| Purchase Price | Weighted average purchase price received at Inventory Location |
| Price Index Code | This field will show the Price Index Code if it was set up on the Property Maintenance—Pricing Contract tab—Inventory Reporting sub-tab. This is an optional setup. If not set up, a weighted average will be used. |
| Market Price | This field will show the Market Price based on the Price Index Code, if it was setup. |
| Ending Inv Value | Ending Inventory value based on weighted average in the Purchase Price column. |
| Market Inv Value | Ending Inventory value based on the price in the Market Price column. |