To Retrieve data, do the following:

• Choose a Producer at the top of the window.
• Choose a Prod Mth at the top of the window. The production months in the dropdown list are from BC08 invoices and submission files that have been imported or from data entered previously on this window.
• Click the Retrieve button on the toolbar. If there is data for this producer and production month, it will be displayed.

To add Gas estimate data, do the following:

• The data you see on this window is the data from the BC08 Submission file.
• There are 7 columns that have been added to the BC08 Submission data that we need to calculate the estimate
  and these columns show up in white and are the only editable columns on this window. They are:
  
  Producer Price, Posted Minimum Price, Crown Land Percentage, Production Volume, Production Hours,
  Cost Center, and Base Royalty Rate Code.
  
  
• The Import Estimate Data button is designed to import data from one of your other databases (eg. Production Accounting).
  You need to contact us if you want to do this so we can verify it can be done in your office.
  
• The Update Estimate Data button can update some of these columns from master file data you already have set up.
  Click it and you will see:
  
  
  Click Yes to update 5 columns with master file data. The Production Volume and Hours will not be updated at this time. They will have
  to be entered manually. There will be a spreadsheet upload available to import this data.
  
  Below is an example of how this data needs to be populated before you can create an estimate.

• 
  
• You cannot add or delete rows here. These are UWI's that are linked to submission files you have imported.
  Any time you import a submission file with new UWI's, they will automatically show up on this window.

   

To add Oil estimate data, do the following:

• The data you see on this window is the data from the BC09 Submission file.
• There are 4 columns that have been added to the Submission data that we need to calculate the estimate
  and these columns show up in white and are the only editable columns on this window. They are:
  
  Average Net Value, Royalty Payor Interest, Vintage Type and Vintage Percent.
  
  
• The 'Import Oil Non PE Estimate Data' button is designed to import data from one of your other databases (eg. Production Accounting).
  You need to contact us if you want to do this so we can verify it can be done in your office.
  
• The 'Update Oil Non PE Estimate Data' button can update some of these columns from oil master file data you already have set up. The Average Net Value column is populated by data from the 'Oil Average Net Value by Facilty' window.
  

  Click it and you will see:

  
  
  
  Click Yes to update 4 columns with data.
  
  
• You cannot add or delete rows here. These are UWI's that are linked to submission files you have imported.
  Any time you import a submission file with new UWI's, they will automatically show up on this window.

   

To Sort, click on the headings. To sort by Plant, click on the Plant heading and the Plants will be sorted in ascending order. Clicking on the Plant heading again will sort the Plants in descending order. This can be done for any column by clicking on the heading.

Clicking on the Sort toolbar button gives you the option to sort by multiple columns at once.

Calculation of the royalty or tax due is done in the following steps:

(1) The Royalty/Tax rate for a month is calculated for each well and producer or for each tract in a Production Entity.

(2) The full Royalty/Tax Share for a month is calculated for each well that has production or for each tract in a Production Entity that has production allocated to it in the month.

(3) Each producer’s share of the Royalty/Tax Share is calculated for each well that has production or tract in a Production Entity that has production allocated to it in the month. This is determined in accordance with each producer’s ownership of production from each well or production allocated to each tract.

(4) Each producer’s portion of the Royalty/Tax Shares is valued using the weighted average net selling price at the point of production from all sales during the month by that producer to determine the gross royalty/tax payable.