Allocated Values
Allocated Values represent the value from each Allocatable Fee on a Vendor Invoice that's been allocated towards a given Service Charge on the invoice. These Allocated Values contain an All in Cost field that represents the sum total of the Service Charge + the sum total amounts allocated to that charge from each Allocatable Fee.
Key Attributes
- Vendor Invoice : This is the Vendor Invoice under audit.
- Service Charge: An Extraneous or Commercial Service charge line item associated with the allocated value.
- Allocatable Fee: The Allocatable Fee that whose value was Allocated across the Service Charge.
- Type: A string that represents the type of fee allocation. This can be either "unit" for unit-based fees, "percentage" for percentage-based fees, or "fixed" for fixed value fees.
- Amount: The monetary that was allocated from the Allocatable Fee to the Service Charge.
How does this work?
When allocating a Vendor Invoice, Discovery will roll the Allocatable Fees on the invoice into the Charges (Roll Off, Commercial, and Extraneous) in order to arrive at the All in Cost for each charge. The All in Cost represents the true cost of the service charge (what the customer is actually paying for each service) on the invoice. It's this value that is used when auditing a Service Charge against the contractual rate (base charge, roll off per haul rate, or roll off tonnage rate) defined on the Service.
Example
Let's assume we have a Vendor Invoice with a total of $4,656.90
We also have the following line item on it:
Commercial Service Charges
DESCRIPTION | PRICE | QTY |
1.5 Yard Dumpster Service | $2,353.38 | 1 |
2 Yard Dumpster Service - Recycle Materials | $280.53 | 1 |
Extraneous Charges
DESCRIPTION | PRICE | QTY |
Recycling rejected for contamination 2YD contaminated | $154.00 | 1 |
Overage Service Yards Incident# 36905604 | $175.00 | 1 |
Allocatable Fees
Regulatory Cost Recovery Charge | $155.50 | 1 |
Administrative Charge | $8.50 | 1 |
Recyclable Material Offset | $8.96 | 1 |
Lock Recycle | $10.50 | 1 |
Lock | $10.50 | 1 |
Fuel / Environmental Charge | $1,500.03 | 1 |
We transition this invoice from Matched to Allocated by clicking the Allocated Target on the Invoice Progress controls:
We would expect to have the following Allocated Values generated by Discovery:
1.5 Yard Dumpster Service Amount: $2,353.38
ALLOCATABLE FEE | ALLOCATED AMOUNT | ALLOCATED PERCENTAGE |
Regulatory Cost Recovery Charge | $123.51 | 5.25% |
Administrative Charge | $6.75 | 0.29% |
Recyclable Material Offset | $7.12 | 0.30% |
Lock Recycle | $8.34 | 0.35% |
Lock | $8.34 | 0.35% |
Fuel / Environmental Charge | $1,191.44 | 50.63% |
All in Cost | $3,698.88 |
2 Yard Dumpster Service - Recycle Materials: $280.53
ALLOCATABLE FEE | ALLOCATED AMOUNT | ALLOCATED PERCENTAGE |
Regulatory Cost Recovery Charge | $14.72 | 5.25% |
Administrative Charge | $0.81 | 0.29% |
Recyclable Material Offset | $0.85 | 0.30% |
Lock Recycle | $0.99 | 0.35% |
Lock | $0.99 | 0.35% |
Fuel / Environmental Charge | $142.02 | 50.63% |
All in Cost | $440.91 |
Overage Service Yards Incident# 36905604
ALLOCATABLE FEE | ALLOCATED AMOUNT | ALLOCATED PERCENTAGE |
Regulatory Cost Recovery Charge | $9.19 | 5.25% |
Administrative Charge | $0.50 | 0.29% |
Recyclable Material Offset | $0.53 | 0.30% |
Lock Recycle | $0.62 | 0.35% |
Lock | $0.62 | 0.35% |
Fuel / Environmental Charge | $88.60 | 50.63% |
All in Cost | $275.06 |
Recycling rejected for contamination 2YD contaminated
ALLOCATABLE FEE | ALLOCATED AMOUNT | ALLOCATED PERCENTAGE |
Regulatory Cost Recovery Charge | $8.08 | 5.25% |
Administrative Charge | $0.44 | 0.29% |
Recyclable Material Offset | $0.46 | 0.30% |
Lock Recycle | $0.55 | 0.35% |
Lock | $0.55 | 0.35% |
Fuel / Environmental Charge | $77.97 | 50.63% |
All in Cost | $242.05 |
In Discovery, we would see the following table of Allocated Values:
At this point, your invoice has now been allocated and is ready for auditing.