Meter Group Base Billing Examples
The following examples illustrate how the system allocates a Meter Group Base Amount to individual meters within a meter group. Example 1 shows the calculations when no estimated monthly volumes are specified. Example 2 shows the calculations when estimated monthly volumes are specified.
The following table identifies the source of each of the numbers and/or the calculations for arriving at the numbers in the main Contract Profitability report's Contract Detail.
|
Item Label |
Calculations |
|
The amount recorded in the Base amount __ per base billing cycle field under the Bill meter group base amount checkbox on the Add/Edit Meter Group window for a meter group listed on the Meter groups tab of a Contract record. For the contract represented in the sample image, the Meter Group Base Amount is $600.00 (Cell E1). |
|
|
The amount recorded in the Expected monthly volume field on the Expected Monthly Volume window that can be accessed by right-clicking a meter from the Selected meters list on the Add Meter Group window. For the contract represented in the sample image, this amount is 0 (zero) for each meter in Example 1; this amount is 5,000 for BW1 (Cell B10) and 1,000 for BW2 (Cell B11) in Example 2. |
|
|
The Estimated Monthly Volume Total is the sum of the Expected monthly volume amounts for each meter in a meter group. For the contract represented in the sample image, the Meter Group Base Amount is $600.00 (Cell E1).
Calculations: Estimated Monthly Volume Total = Sum(Estimated Monthly Volume for Each Meter in Meter Group)
Example1: This amount is not calculated for Example 1 because no Estimated Monthly Volume amounts are specified for this meter group; Cells B5 and B6 are set to 0 (zero).
Example2: Estimated Monthly Volume Total (Cell B12) = 5,000 Estimated Monthly Volume for BW1 (Cell B10) + 1,000 Estimated Monthly Volume Amounts for BW2 (Cell B 11) = 6,000 |
|
|
The Contract Begin Meter is the meter count on a meter in a meter group at the beginning of the contract. For the contract represented in the sample image, all meters have a beginning meter of 0 (zero) (Cells C5, C6, C10, and C11). |
|
|
For the first month only, if no estimated monthly volume is specified (Example 1), the Meter Group Base Amount is divided evenly among the number of meters in the meter group; if an estimated monthly volume is specified (Example 2), the Meter Group Base Amount is divided in proportion to the Estimated Monthly Volume assigned to each meter in the meter group.
Calculations: Meter Group Base Amount Allocation Per Meter (No Estimated Monthly Volume) = Meter Group Base Amount/Meters in Meter Group Meter Group Base Amount Allocation Per Meter (Estimated Monthly Volume) = (Estimated Monthly Volume per Meter/Estimated Monthly Volume Total) * Meter Group Base Amount
Example1: Meter Group Base Amount Allocation for BW1 (Cell E5) = $600.00 Meter Group Base Amount/ 2 Meters in Meter Group = $300.00 Meter Group Base Amount Allocation for BW2 (Cell E6) = $600.00 Meter Group Base Amount/ 2 Meters in Meter Group = $300.00 Note: The sum of these amounts (Cell E5: $300.00 + Cell E6: $300.00) equals the Meter Group Base Amount for the month (Cell E7: $600.00)
Example2: Meter Group Base Amount Allocation for BW1 (Cell E10) = (5,000 Estimated Monthly Volume for BW1/6,000 Estimated Monthly Volume Total for Meter Group) * $600.00 Meter Group Base Amount = $500.00 Meter Group Base Amount Allocation for BW2 (Cell E11) = (1,000 Estimated Monthly Volume for BW2/6,000 Estimated Monthly Volume Total for Meter Group) * $600.00 Meter Group Base Amount = $100.00 Note: The sum of these amounts (Cell E10: $500.00 + Cell E11: $100.00) equals the Meter Group Base Amount for the month (Cell E12: $600.00)
|
|
|
Each Meter Read represents the actual meter reading recorded each month for a meter in the meter group. These values appear in black font in the sample image because these amounts are not system-calculated amounts. Each Meter Read minus the Contract Begin Meter represents the total usage for the meter since the beginning of the contract. Since the Contract Begin Meter is zero (0) in the sample image, each Meter Read in the sample image (F5, F6, I5, I6, L5, and L6 for Example 1; and F10, F11, I10, I11, L10, and L11 for Example 2) represents—at the time the meter read was recorded—the total usage for the meter since the beginning of the contract. |
|
|
Meter Read Totals are the sum of the meter reads for the meter group. Since each Meter Read Total in the sample image represents—at the time the meter read was recorded—the total usage for each meter since the beginning of the contract, each Meter Read Total represents—at the time the meter reads were recorded—the total usage for the Meter Group since the beginning of the contract.
Calculation: Meter Read Total = Sum(Meter Reads in Meter Group)
Example 1: Meter Read Total for Month 2 (Cell F7) = 3,000 Meter Read for BW1 (Cell F5) + 9,000 Meter Read for BW2 (Cell F6) = 12,000 Meter Read Total for Month 3 (Cell I7) = 9,000 Meter Read for BW1 (Cell I5) + 12,000 Meter Read for BW2 (Cell I6) = 21,000 Meter Read Total for Month 4 (Cell L7) = 12,000 Meter Read for BW1 (Cell L5) + 15,000 Meter Read for BW2 (Cell L6) = 27,000
Example 2: Meter Read Total for Month 2 (Cell G12) = 4,000 Meter Read for BW1 (Cell G10) + 9,000 Meter Read for BW2 (Cell G11) = 13,000 Meter Read Total for Month 3 (Cell I12) = 9,000 Meter Read for BW1 (Cell I10) + 12,000 Meter Read for BW2 (Cell I11) = 21,000 Meter Read Total for Month 4 (Cell L12) = 12,000 Meter Read for BW1 (Cell L10) + 15,000 Meter Read for BW2 (Cell L11) = 27,000 |
|
|
Actual Average Monthly Volume represents the total usage recorded for a meter since the beginning of the contract divided by the number of months of usage since the beginning of the contract.
Calculation: Meter Read Total = (Current Meter Read - Begin Meter Read)/Months of Usage
Example 1: Actual Average Monthly Volume for BW1 in Month 2 (Cell G5) = 3,000 Meter Read for BW1 (Cell F5) - 0 Contract Begin for BW1 (Cell C5)/1 Month of Usage = 3,000 Actual Average Monthly Volume for BW2 in Month 2 (Cell G6) = 9,000 Meter Read for BW2 (Cell F6) - 0 Contract Begin for BW2 (Cell C6)/1 Month of Usage = 9,000 Actual Average Monthly Volume for BW1 in Month 3 (Cell J5) = 9,000 Meter Read for BW1 (Cell I5) - 0 Contract Begin for BW1 (Cell C5)/2 Month of Usage = 4,500 Actual Average Monthly Volume for BW2 in Month 3 (Cell J6) = 12,000 Meter Read for BW2 (Cell I6) - 0 Contract Begin for BW2 (Cell C6)/2 Month of Usage = 6,000 Actual Average Monthly Volume for BW1 in Month 4 (Cell M5) = 12,000 Meter Read for BW1 (Cell L5) - 0 Contract Begin for BW1 (Cell C5)/3 Month of Usage = 4,000 Actual Average Monthly Volume for BW2 in Month 4 (Cell M6) = 15,000 Meter Read for BW2 (Cell L6) - 0 Contract Begin for BW2 (Cell C6)/3 Month of Usage = 5,000
Example 2: Actual Average Monthly Volume for BW1 in Month 2 (Cell G10) = 4,000 Meter Read for BW1 (Cell F10) - 0 Contract Begin for BW1 (Cell C10)/1 Month of Usage = 4,000 Actual Average Monthly Volume for BW2 in Month 2 (Cell G11) = 9,000 Meter Read for BW2 (Cell F11) - 0 Contract Begin for BW2 (Cell C11)/1 Month of Usage = 9,000 Actual Average Monthly Volume for BW1 in Month 3 (Cell J10) = 9,000 Meter Read for BW1 (Cell I10) - 0 Contract Begin for BW1 (Cell C10)/2 Month of Usage = 4,500 Actual Average Monthly Volume for BW2 in Month 3 (Cell J11) = 12,000 Meter Read for BW2 (Cell I11) - 0 Contract Begin for BW2 (Cell C11)/2 Month of Usage = 6,000 Actual Average Monthly Volume for BW1 in Month 4 (Cell M10) = 12,000 Meter Read for BW1 (Cell L10) - 0 Contract Begin for BW1 (Cell C10)/3 Month of Usage = 4,000 Actual Average Monthly Volume for BW2 in Month 4 (Cell M11) = 15,000 Meter Read for BW2 (Cell L11) - 0 Contract Begin for BW2 (Cell C11)/3 Month of Usage = 5,000 |
|
|
Actual Average Monthly Volume Totals are the sum of the average monthly usage amounts recorded for each meter in the meter group.
Calculation: Actual Average Monthly Volume Total = Sum(Actual Average Monthly Volume for Each Meter in Meter Group)
Example 1: Actual Average Monthly Volume Total for Month 2 (Cell G7) = 3,000 Actual Average Monthly Volume for BW1 (Cell G5) + 9,000 Actual Average Monthly Volume for BW2 (Cell G6) = 12,000 Actual Average Monthly Volume Total for Month 3 (Cell J7) = 4,500 Actual Average Monthly Volume for BW1 (Cell J5) + 6,000 Actual Average Monthly Volume for BW2 (Cell J6) = 10,500 Actual Average Monthly Volume Total for Month 4 (Cell M7) = 4,000 Actual Average Monthly Volume for BW1 (Cell M5) + 5,000 Actual Average Monthly Volume for BW2 (Cell M6) = 9,000
Example 2: Actual Average Monthly Volume Total for Month 2 (Cell G12) = 4,000 Actual Average Monthly Volume for BW1 (Cell G10) + 9,000 Actual Average Monthly Volume for BW2 (Cell G11) = 13,000 Actual Average Monthly Volume Total for Month 3 (Cell J12) = 4,500 Actual Average Monthly Volume for BW1 (Cell J10) + 6,000 Actual Average Monthly Volume for BW2 (Cell J11) = 10,500 Actual Average Monthly Volume Total for Month 4 (Cell M12) = 4,000 Actual Average Monthly Volume for BW1 (Cell M10) + 5,000 Actual Average Monthly Volume for BW2 (Cell M11) = 9,000 |
|
|
After usage is recorded, the Meter Group Base Amount is allocated to each meter in a meter group based on the meter's percentage of the usage since the beginning of the contract. At this point, any estimated monthly volume amounts used to determine the allocation when no usage was present are no longer used.
Calculations: Meter Group Base Amount Allocation per Meter = (Actual Average Monthly Volume per Meter/Actual Average Monthly Volume Total per Meter Group) *Meter Group Base Amount
Example 1: Meter Group Base Amount Allocation for BW1 in Month 2 (Cell H5) = (3,000 Actual Average Monthly Volume for BW1 for Month 2 from Cell G5 / 12,000 Actual Average Monthly Volume Total for Meter Group or Month 2 from Cell G7) * $600 Meter Group Base Amount from Cell E1 = $150.00 Meter Group Base Amount Allocation for BW2 in Month 2 (Cell H6) = (9,000 Actual Average Monthly Volume for BW1 for Month 2 from Cell G6 / 12,000 Actual Average Monthly Volume Total for Meter Group or Month 2 from Cell G7) * $600 Meter Group Base Amount from Cell E1 = $450.00 Meter Group Base Amount Allocation for BW1 in Month 3 (Cell K5) = (4,500 Actual Average Monthly Volume for BW1 for Month 2 from Cell J5 / 21,000 Actual Average Monthly Volume Total for Meter Group or Month 2 from Cell J7) * $600 Meter Group Base Amount from Cell E1 = $257.14286 Meter Group Base Amount Allocation for BW2 in Month 3 (Cell K6) = (9,000 Actual Average Monthly Volume for BW1 for Month 2 from Cell J6 / 12,000 Actual Average Monthly Volume Total for Meter Group or Month 2 from Cell J7) * $600 Meter Group Base Amount from Cell E1 = $342.85714 Meter Group Base Amount Allocation for BW1 in Month 4 (Cell N5) = (3,000 Actual Average Monthly Volume for BW1 for Month 2 from Cell M5 / 12,000 Actual Average Monthly Volume Total for Meter Group or Month 2 from Cell M7) * $600 Meter Group Base Amount from Cell E1 = $266.666667 Meter Group Base Amount Allocation for BW2 in Month 4 (Cell N6) = (9,000 Actual Average Monthly Volume for BW1 for Month 2 from Cell M6 / 12,000 Actual Average Monthly Volume Total for Meter Group or Month 2 from Cell M7) * $600 Meter Group Base Amount from Cell E1 = $333.333333
Example 2: Meter Group Base Amount Allocation for BW1 in Month 2 (Cell H10) = (4,000 Actual Average Monthly Volume for BW1 for Month 2 from Cell G10 / 13,000 Actual Average Monthly Volume Total for Meter Group or Month 2 from Cell G7) * $600 Meter Group Base Amount from Cell E1 = $184.61538 Meter Group Base Amount Allocation for BW2 in Month 2 (Cell H11) = (9,000 Actual Average Monthly Volume for BW1 for Month 2 from Cell G11 / 12,000 Actual Average Monthly Volume Total for Meter Group or Month 2 from Cell G12) * $600 Meter Group Base Amount from Cell E1 = $415.38462 Meter Group Base Amount Allocation for BW1 in Month 3 (Cell K10) = (4,500 Actual Average Monthly Volume for BW1 for Month 2 from Cell J10 / 21,000 Actual Average Monthly Volume Total for Meter Group or Month 2 from Cell J12) * $600 Meter Group Base Amount from Cell E1 = $257.14286 Meter Group Base Amount Allocation for BW2 in Month 3 (Cell K11) = (9,000 Actual Average Monthly Volume for BW1 for Month 2 from Cell J11 / 12,000 Actual Average Monthly Volume Total for Meter Group or Month 2 from Cell J12) * $600 Meter Group Base Amount from Cell E1 = $342.85714 Meter Group Base Amount Allocation for BW1 in Month 4 (Cell N10) = (3,000 Actual Average Monthly Volume for BW1 for Month 2 from Cell M10 / 12,000 Actual Average Monthly Volume Total for Meter Group or Month 2 from Cell M12) * $600 Meter Group Base Amount from Cell E1 = $266.666667 Meter Group Base Amount Allocation for BW2 in Month 4 (Cell N11) = (9,000 Actual Average Monthly Volume for BW1 for Month 2 from Cell M11 / 12,000 Actual Average Monthly Volume Total for Meter Group or Month 2 from Cell M12) * $600 Meter Group Base Amount from Cell E1 = $333.333333 |
|
|
The sum of the allocations for all meters in a meter group should equal the Meter Group Base Amount.
Calculations: Allocation Total = Sum(Allocation for Each Meter in Meter Group)
Example 1: Allocation Total for Month 1 (Cell E7) = $300.00 for BW1 from Cell E5 + $300.00 for BW2 from Cell E6 = $600.00 Allocation Total for Month 2 (Cell H7) = $150.00 for BW1 from Cell H5 + $450.00 for BW2 from Cell H6 = $600.00 Allocation Total for Month 3 (Cell K7) = $257.14286 for BW1 from Cell K5 + $342.85714 for BW2 from Cell K6 = $600.00 Allocation Total for Month 4 (Cell N7) = $266.666667 for BW1 from Cell N5 + $$333.333333 for BW2 from Cell N6 = $600.00
Example 2: Allocation Total for Month 1 (Cell E12) = $500.00 for BW1 from Cell E10 + $100.00 for BW2 from Cell E11 = $600.00 Allocation Total for Month 2 (Cell H12) = $184.61538 for BW1 from Cell H10 + $415.38462 for BW2 from Cell H11 = $600.00 Allocation Total for Month 3 (Cell K12) = $257.14286 for BW1 from Cell K10 + $342.85714 for BW2 from Cell K11 = $600.00 Allocation Total for Month 4 (Cell N12) = $266.666667 for BW1 from Cell N10 + $$333.333333 for BW2 from Cell N11 = $600.00 |
Non-supported ReleaseNon-supported Release
©2024 ECI and the ECI logo are registered trademarks of ECI Software Solutions, Inc. All rights reserved.