Two vehicles are leased for a fixed price per month of $350. But you also charge an insurance fee of $50 per month that you do not want included in the lease fee. There are no charges for miles or any other usage charges, but there is a signup fee of $500 at contract signing. The customer can fill-up the vehicles at your gas station at 10% above cost with any appropriate fuel. Your promise is to never charge more than $60 for a full tank. Only if they use your gas station there is a monthly admin fee of $25, regardless of the gas they use. If they use Euro because of import costs you charge an extra $2 per gallon and there is no $60 maximum either.
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 |
Adjustments |
||
---|---|---|---|---|---|---|---|
% Before |
Max. |
Price |
|||||
Usage Charges |
Monthly Costs |
Transaction |
Yes |
$350 |
|||
Usage Charges |
Insurance Fee |
Transaction |
Yes |
$50 |
|||
Fuel Charges |
All Fuels |
Transaction |
Yes |
10% |
60 |
||
Fuel Charges |
Euro |
Transaction |
Yes |
10% |
$2 |
||
Fuel Charges |
All Fuels |
Charge Cat. |
Yes, Conditional |
$25* |
|||
One Time Charge. |
Signup Fee |
Transaction |
Yes |
$500 |
*On this Charge Level adjusting the price (Adjustment Price) is like adjusting the transaction (Transaction Adjustment) simply because the invoice quantity will be assumed 1.
They filled up one vehicle three times this month:
Fuel |
Trans. Qty. |
Trans. Price |
Invoice |
---|---|---|---|
Premium US |
10 |
$3.50 |
$38.50 |
Premium US |
15 |
$3.80 |
$60 (was $62.7, but $60 is the max) |
Euro |
5 |
$10.00 |
$65 ($50 +10% of $50 + 5*$2) |
The Invoice this month will be $1988.50:
Charge Category |
Subcategory |
Charge Level |
Amount |
---|---|---|---|
Usage Charges |
All |
Charge Category |
$400 (per vehicle) |
Fuel Charges |
All |
Charge Category |
$188.50 |
One Time Charges |
All |
Charge Category |
$500 (per vehicle) |
Usage Charges |
Monthly |
Charge Subcategory |
$350 + $50 (per vehicle) |
Fuel Charges |
Premium US |
Charge Subcategory |
$98.50 |
Fuel Charges |
Euro |
Charge Subcategory |
$65 |
One Time Charges |
Beginning of Contract |
Charge Subcategory |
$500 (per vehicle) |
The Invoice next month (no trips to our gas station) will be $800.00:
Charge Category |
Subcategory |
Charge Level |
Amount |
---|---|---|---|
Usage Charges |
All |
Charge Category |
$350 + $50 = $400 (per vehicle) |
Usage Charges |
Monthly Lease |
Charge Subcategory |
$350 (per vehicle) |
Usage Charges |
Monthly Insurance |
Charge Subcategory |
$50 (per vehicle) |