Navigation:  Module 1 - Energy Accounting > Accounts & Invoices Tab > User Defined Components > Functions >

ProratedReprice

Previous page Next page
  rev. 2011-02-09        

ProratedReprice

Description:

Reprice functions are designed to simplify definition of tariffs to handle repricing.  Frequent repricing is very common and invoices often straddle the repricing date.  When that happens, the invoice component is prorated on number of days using the repricing date and the two rates.  ProratedReprice returns the prorated charge.

Use ProratedReprice where there is no need to see the separate values before and after the repricing date.  Many providers break out these values on invoices, and in those cases use BeforeReprice and AfterReprice to create the same level of visibility in the invoice records.

Syntax:

ProratedReprice(ReadingPeriod, RepricingDate, BeforeValue, AfterValue)

Type:

Double Precision Numeric

Arguments:

Argument

Type

Description

ReadingPeriod

DateRange


RepricingDate

DateTime


BeforeValue

Double

The value calculated as if ReadingPeriod occurred entirely before RepricingDate**

AfterValue

Double

The value calculated as if ReadingPeriod occurred entirely on or after RepricingDate**

** BeforeValue and AfterValue will typically be Qty x Unit Cost calculations, or SumOfTiers functions.

Examples:

Consider a natural gas meter component group NG1, a meter reading period of May 23 2010 to June 19 2010, and repricing as of June 1 2010.  The price of natural gas is $0.24 per therm before the repricing date and $0.28 per therm after the repricing date.  Gas consumption during the metering period is 10,000 therms.  There are 27 days in the metered period, 8 before the repricing and 19 after the repricing.

NG1 - Meter Component Group

[NG1].StartDate - May 23 2010

[NG1].EndDate - June 19 2010

RepriceDate - June 1 2010

NGCommodityBefore - 0.24

NGCommodityAfter - 0.28

NGConsumption - 10,000

 

Expression

Result

ProratedReprice([NG1].Period, [RepriceDate], [NGConsumption] * [NGCommodityBefore], [NGConsumption] * [NGCommodityAfter])

2681.48



S2_ProratedReprice         ©2014 Managing Energy Inc.