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:

Figure 1. Transition the Vendor Invoice to Allocated status.

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.