BD Administrator Tank Calculations Report overview
Function acronym: BDAC
Use this report to recalculate your bulk tank values to determine daily usage, current tank level, estimated empty date, and other values.
We recommend you set this up as a stored report to run nightly.
BD Administrator Tank Calculations Report uses the values updated during Sales Shipping Feedback Entry.
If a tank matches the criteria specified for the report, it and all other active tanks at the same ship to location are processed by the report. The report output consists of summary totals for the tanks that are reviewed and the tank records that are updated.
These values are calculated when you run BD Administrator Tank Calculations Report:
Daily Usage
Bulk product Daily Usage is calculated as:
(Tank Level Amount from Last Delivery - Tank Level Amount from Oldest Delivery + Total Quantity Delivered In That Period) / (Last Delivery Date - Oldest Delivery Date)
Example:
Tank level recorded by driver on last delivery (3/01/21): 190 gallons
Tank level recorded by driver from oldest delivery (6/15/20): 187 gallons
Total quantity delivered between 6/15/20 and 3/1/21: 1300 gallons
Daily Usage = (190 - 187 + 1300) / 258 days = 5 gallons
Daily usage is not calculated for a tank if the Daily Usage Override option in BD Tank Master Setup is selected.
Daily Usage is calculated based on transaction history. The number of transaction history records used is specified in the Number of Deliveries you specify when you run BD Administrator Tank Calculations Report. For example, if you set this value to 5, then the “Oldest Delivery" is the 5th one back.
Current Tank Level %
The Current Tank Level % is calculated after determining these values:
- Days Elapsed: Current Date - Last Delivery Date
- Estimated Use-To-Date: Daily Usage * Days Elapsed
- Estimated Remaining: Tank Level Amount At Last Delivery - Estimated Use-To-Date
Current Tank Level % = (Estimated Remaining / Tank Size) * 100
Example:
Days Elapsed: 31
Estimated Use-To-Date: 5 * 31 = 155
Estimated Remaining: 190-155 = 35
Current Tank Level % = (35 / 200) * 100 = 17.5%
Estimated Empty Date
Estimated Empty Date is calculated after determining these values:
- Days Until Empty: (Tank Level Amount At Last Delivery - Unusable Capacity) /
Daily Usage
Unusable Capacity is defined in BD Tank Master Setup.
- Convert Days Until Empty to an integer (no rounding is done, just dropping the decimal)
Estimated Empty Date = Current Date + Days Until Empty
Example:
Days Until Empty: (190 - 5) / 5 = 37
Estimated Empty Date = 3/8/21 + 37 = 4/14/21
Delivery Due Date
The Delivery Due Date is calculated for tanks set up in BD Tank Master Setup with a Service Type of Keep Fill or Fill Cycle only. A different calculation is used for each type.
The Delivery Due Date is calculated for Keep Fill tanks after determining these values:
- Amount Over Safety: Tank Level Amount At Last Delivery - Safety
Allowance
Safety Allowance is specified in BD Tank Master Setup.
- Days Until Safety: Amount Over Safety / Daily Usage
Delivery Due Date = Last Delivery Date + Days Until Safety
Example:
Amount Over Safety: 190 - 14 = 176
Days Until Safety: 176 / 5 = 35
Delivery Due Date = 2/2/21 + 35 = 3/9/21
The Delivery Due Date is calculated for Fill Cycle tanks as:
Delivery Due Date = Last Delivery Date + Fill Cycle Days
Fill Cycle Days is defined for each Fill Cycle in SA Administrator Table Code Value Setup-Bulk Delivery Fill Cycle. The Fill Cycle is assigned to a tank in BD Tank Master Setup.
Example:
Fill Cycle Days: 30
Delivery Due Date = 2/2/21 + 30 = 3/4/21
Order Point / Minimum
Order Point/Minimum is calculated after determining these values:
- Projected Lead Time: Delivery Due Date - Current Date
- Lead Time Demand: Daily Usage * Projected Lead Time
Order Point/Minimum = Lead Time Demand + Safety Allowance
Order Point is not calculated for Will Call tanks, as no Delivery Due Date is assigned to this tank type.
Line Point / Maximum
Line Point/Maximum is calculated as:
Order Point/Minimum + Lead Time Demand
Line Point is not calculated for Will Call tanks, as no Delivery Due Date is assigned to this tank type.