How is Owed $ calculated?
If Deal Item has Semi-Actual Cases entered:
We use (Semi-Actual Cases * Case Rate) – (sum of Pending Deductions) – Actual Dollars to get remaining Owed Dollars.
Else If, Deal is Expired or Deal Item has more Actual Cases than Estimated Cases:
We use (Actual Cases * Case Rate) – (sum of Pending Deductions) – Actual Dollars to get remaining Owed Dollars.
Else,
We use (Est. Cases * Case Rate)– (sum of Pending Deductions) – Actual Dollars to get remaining Owed Dollars.
Note: If the Deal is using a Rate per Unit tactic, the Case Rate value should be calculated as Rate * Units per Count.
Why are the Estimated Cases so much higher than the Actual Cases?
This could be that the proper Start/End Dates were not entered to determine what Actual Volume should be applied as Actual Cases on the Deal. Or not all the ACT(Invoiced) Volume is being sent to Flamingo.
Potential ways to correct Owed $ if it does not align with expectations...
- Deals can be moved back to Pending Approval and update Start/End Dates on Deals so the Deal could potentially pick up more Actual Cases from Volume on the next Nightly Batch.
- Semi-Actual Cases can also be used to manipulate the Owed Dollars to what the assumed value should be.
- Process any Deductions in CL-PE (Closed-Pending) status that are applied to the Deal but are waiting for authorization.