Billing Operations Forum 24 July 2007 RbD Overview

1 / 23

# Billing Operations Forum 24 July 2007 RbD Overview - PowerPoint PPT Presentation

Billing Operations Forum 24 July 2007 RbD Overview. Fiona Cottam. Agenda. Background Principles Inputs Sources Shares Sectors Calculations. The RbD Concept. Meter point reconciliation would not be cost effective for 20 million SSPs

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about 'Billing Operations Forum 24 July 2007 RbD Overview' - shawn

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

### Billing Operations Forum24 July 2007RbD Overview

Fiona Cottam

Agenda
• Background
• Principles
• Inputs
• Sources
• Shares
• Sectors
• Calculations
The RbD Concept
• Meter point reconciliation would not be cost effective for 20 million SSPs
• Larger Supply Points (AQ>73,200 kWh) are reconciled on actual meter reads
• Smaller Supply Points (AQ<73,200 kWh) are subject to Reconciliation by Difference
• Britain’s distribution Network is divided into 18 LDZs
• Total daily energy consumption in each of the LDZs is known
• Any reconciliation charge in one sector must have an equal and opposite effect on other sectors, so that total LDZ consumption is unchanged
• Reconciliation consists of a gas charge/credit and transportation charge/credit to User for both NTS and LDZ transportation
RbD Basic Concepts - 1
• If you know the RQ (Reconciliation Quantity) for Segments 1 to 4, from reading all the meters in them, then…
• The RQ for Segment 5 must be equal and opposite to the Sum of the RQs for Segments 1 to 4.
• Therefore, you don't need to read any meters in Segment 5 to calculate the total RQ for the Segment. Just apply the equal and opposite rule: Source Charges

LDZ

Input

Energy

Allocation of

Measured Energy

input into LDZ, after deducting Shrinkage and DM measurements, to all NDM Supply

Points in the LDZ

NDM

Large

NDM

Small

DM

Shrinkage

Energy Allocation - Summarised

The allocation process drives the shippers’ energy balancing imbalance and transportation commodity quantities

LDZ

Input

Energy

NDM

Large

DM

d

NDM

Small

DM

NDM Large

+

d

= -

NDM Small

d

Shrinkage

Reconciliation by Difference(Smaller Supply Points)
RbD Basic Concepts -2
• As all SSPs have:
• AQs calculated on the same basis
• Energy deemed to them on the same basis
• Comparable actual consumption patterns
• Then:
• They will have comparable RQs
• And:
• CSEP sites are no different to Directly Connected, they are affected by the same weather/social/economic factors, so their behaviour is comparable to directly connected
RbD Basic Concepts - 3
• If:
• All SSPs in an LDZ are comparable, and
• Their RQ is directly related to their AQ
• Then:
• Shipper's total SSP RQ is proportional to their total AQ in an LDZ
• Thus:
• We can allocate RQ on the basis of each Shipper's Share of the total AQs for an LDZ
• For this purpose, CSEP AQ ranks equally with Directly Connected
The Matching Concept
• Group LSP RQs by Meter Read Frequency
• RbD Sectors
• Give each Sector an Incurred Period of same length as Meter Read Frequency (specifically: Monthly, 6 Monthly, Annual)
• Slice RQ into equal amounts for each incurred month in the incurred period
• Apply appropriate shipper share to the RQ slice for each incurred month
1 Month Sector (M)

Sources:

DM Estimate to Actual

Reconciliation of LSPs on CSEPs

Adjustments to SSPs of <1 month duration

LDZ Measurement Sector (L)(Special case 1 month sector)

Sources:

LDZ Measurement Errors

6 Month Sector (6)

Sources:

Adjustments to SSPs of 1-4 months duration

12 Month Sector (A)

Sources:

DM Annual Resynchronisations

Adjustments to SSPs of >4 months duration

RbD Sectors and Sources
Apportionment of RbD sectors - 1

6 monthly sector

Monthly and LDZ errors sectors

12 monthly sector

Apportion

over last 12 months

Apportion

over last month

Apportion

over last 6 months

Apportionment of RbD sectors - 2
• Matching of RQ to Shipper Shares

Month

-11

Current Month

Sector A

Sector 6

Sector M

Sector L

RbD Charges – Which prices?
• Energy – daily System Average Price – no calculation required – inherit from “primary” reconciliation
• Transportation – applicable daily rates of:
• NTS Exit Commodity
• LDZ Commodity
• Customer Commodity (for applicable periods)
• CSEP sites
• Same energy prices
• Same NTS commodity prices
• LDZ commodity prices reduced to reflect average scheme SOQ in the LDZ
• No Customer Commodity charges
• Primary Reconciliation energy is broken down into periods of consistent transportation prices, and prices are applied to a single figure for each source
Calculation of Market Shares - Principles
• Market share is based on share of all the days in a particular month
• Live AQ on the day
• Isolated/isolated & withdrawn excluded (same as for allocation)
• CSEP sites count equally with Directly Connected sites for energy apportionment
Calculation of Market Shares - Example

Shipper market share for the month: 600,000 ÷ 1,000,000 = 60%

RbD Apportionment – Worked example
• Let's Assume:
• Reconciliation on a non-Monthly-Read meter, from 15/03/2006 to 15/10/2006
• Initially suppressed, approved in December 2006, to be included on December 2006 invoice (issued January 2007)
• Imaginary 3-Month Sector Applies
• Reconciliation values
• RQ: 120,000 kWh
• GRE: £9,000
• NRE: £200
• ZRE: £600
RbD Calculations - Cum AQs

Monthly Cumulative Daily Aggregate AQs

For an imaginary LDZ with four Shippers

Shipper

Month 1

Month 2

Month 3

ONE

600,000

700,000

800,000

TWO

250,000

200,000

150,000

THREE

0

50,000

50,000

FOUR

150,000

50,000

0

LDZ Total AQ

1,000,000

1,000,000

1,000,000

Sector QRbD Calculations – UARQ (User Aggregate RQ)

Sources

Incurred

Total

Month 1

Month 2

Month 3

RQ (kWh)

120,000

40,000

40,000

40,000

ARQ (kWh)

-120,000

-40,000

-40,000

-40,000

Shipper Share(AQ):

One

600,000

700,000

800,000

Two

250,000

200,000

150,000

Three

0

50,000

50,000

Four

150,000

50,000

LDZ Total AQ

1,000,000

1,000,000

1,000,000

RbD UARQ:

Total

One

-84,000

-24,000

-28,000

-32,000

Two

-24,000

-10,000

-8,000

-6,000

Three

-4,000

0

-2,000

-2,000

Four

-8,000

-6,000

-2,000

0

Total RbD UARQ

-120,000

-40,000

-40,000

-40,000

Sector QRbD Calculations - UARCV/RBG

Sources

Incurred

Total

Month 1

Month 2

Month 3

GRE

9,000

3,000

3,000

3,000

ARCV

-9,000

-3,000

-3,000

-3,000

Shipper Share (AQ):

One

600,000

700,000

800,000

Two

250,000

200,000

150,000

Three

0

50,000

50,000

Four

150,000

50,000

LDZ Total AQ

1,000,000

1,000,000

1,000,000

RBG Charges:

Total

One

-6,300

-1,800

-2,100

-2,400

Two

-1,800

-750

-600

-450

Three

-300

0

-150

-150

Four

-600

-450

-150

0

Total RBG Charges

-9,000

-3,000

-3,000

-3,000

RbD Calculations – contd.
• Identical process calculates:
• UARCV: User Aggregate Reconciliation Clearing Value
• Energy cost of Reconciliation Energy (“RBG”)
• UATCA: User Aggregate Transportation Charge Adjustments
• Commodity Transportation costs
• Since Sale of Networks, split between NTS, LDZ and Customer Commodity Reconciliation
RbD Supporting Information
• Breakout of Charges by:
• LDZ – Directly connected
• Energy – RBG
• Transportation – RBN/RBZ/RBC
• - Sector
• LDZ – CSEP
• Energy - RCG
• Transportation – RCN/RCZ
• - Sector
• Breakout of Shares by:
• LDZ
• Incurred Month
• - Calendar Day
Worked example for Shipper One for Dummy Sector Q
• Shipper One’s RBG records for Month 1,2 and 3:
• J13, 123456779, RBG, AB, 10, 2006, Q, 1000000, 600000, 60.0000000000000, -24000, -1800.00, 123456,
• J13, 123456780, RBG, AB, 11, 2006, Q, 1000000, 700000, 70.0000000000000, -28000, -2100.00, 123456,
• J13, 123456781, RBG, AB, 12, 2006, Q, 1000000, 800000, 80.0000000000000, -32000, -2400.00, 123456
• [record type, record no, chg type, LDZ, billing month, billing year, sector code, total LDZ AQ, Shipper total AQ, % market share, energy, financial value, invoice no]
• J14, AB, Q, RBG, -120000, -9000
• [record type, LDZ, sector code, total energy, total financial value]
Role of the RbD Audit
• Calculations are performed within mainframe systems
• Large volume of data
• 500,000 LSPs
• 20,000,000 SSPs
• Confidentiality of each Shipper’s LSP Reconciliation values
• SSP Shippers can’t check the whole calculation process
• RbD Audit checks the following:
• Aggregation of Primary Reconciliation sources and allocation into sectors
• Extraction of SSP aggregate AQs
• Allocation of RbD energy and charges to Shippers