A space in a building is leased for $5 per square foot per week. The space is 200 square feet. There are no other charges but for energy. The electricity bill for the building is invoiced based on the floor area, which is 10%. The rate varies and is determined by the electricity bill. Water is also invoiced. The space has its own water meter. Water is charged at $0.01 a gallon with a minimum of 2,000 gallons.
Define this contract as follows, but take into consideration that other ways may lead to the same result:
Charge Category |
Subcategory |
Charge Level |
Invoice |
Rate |
Min. Qty. |
Energy Related |
|
---|---|---|---|---|---|---|---|
Type |
Invoice % |
||||||
Usage Charges |
Weekly Rent |
Transaction |
Yes |
$5 |
|||
Energy Charges |
Electricity |
Transaction |
Yes |
Floor Area |
10 |
||
Energy Charges |
Water |
Transaction |
Yes |
$0.01 |
2,000 |
Submeter |
100 |
Make sure you enter the Usage Quantity (200) and related UOM (square foot) on the Contract Item tab for this space. Or alternatively you can convert the $5 to a $1,000 per month.
The invoice period is from March 10 to April 9, so there are 31 days in the invoice period. The space used 1900 gallons of water and the building used 20,000 kWh at $0.10 a kWh. The utility bill only covered the period until April 5.
The Invoice for this month will be $4,648.57:
Charge Category |
Subcategory |
Charge Level |
Amount |
---|---|---|---|
Energy Charges |
All |
Charge Category |
$220 |
Usage Charges |
All |
Charge Category |
$4,428.57 |
Energy Charges |
Water |
Charge Subcategory |
$20 |
Energy Charges |
Electricity |
Charge Subcategory |
$200 (until April 5) |
Usage Charges |
Weekly |
Charge Subcategory |
$4428.57 = $5*200*4.428571429 (periods) |
The second invoice period is from April 10 to May 9, so there are now 30 days in the invoice period. The space used 2,100 gallons of water and the building used 25000 kWh at $0.10 a kWh. The utility bill only covered the period until May 5. The Invoice for this month will be $4,556.71:
Charge Category |
Subcategory |
Charge Level |
Amount |
---|---|---|---|
Energy Charges |
All |
Charge Category |
$271 |
Usage Charges |
All |
Charge Category |
$4,285.71 |
Energy Charges |
Water |
Charge Subcategory |
$21 |
Energy Charges |
Electricity |
Charge Subcategory |
$250 (until May 5) |
Usage Charges |
Weekly |
Charge Subcategory |
$4285.71 = $5*200*4.285714286 (periods) |