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, estimated fill 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 for Fill service type
Bulk product Daily Usage for Fill service type 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.
Daily Usage for Empty service type
The Daily Usage for bulk products in tanks configured with the Empty service type is calculated by the formula:
Daily Usage = (Tank Level from Last Pickup - Tank Level from Oldest Pickup + Total Quantity picked up during the period) / (Number of days between last and oldest pickup dates)
For example:
- Tank level recorded on last pickup (3/01/25): 0.33 gallon
- Tank level recorded on oldest pickup (6/15/24): 0.25 gallon
- Total quantity picked up between 6/15/24 and 3/01/25: 1300 gallons
- Daily Usage = (0.33 - 0.25 + 1300) / 258 days = 5 gallons
- Daily usage is not calculated, if the Daily Usage Override check box is selected for the tank on the BD Tank Master Setup screen.
- Daily Usage is calculated based on transaction history. The number of these records for used products is determined by the Number of Deliveries specified when the BD Administrator Tank Calculations Report is generated. For example, if the value is set to 5, the oldest pickup is the fifth one back.
Current Tank Level % for Fill service type
The Current Tank Level % for Fill service type 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%
Current Tank Level % for Empty service type
The Current Tank Level percentage for tanks configured with the Empty service type, is calculated after determining these values:
- Days Elapsed = Current Date - Last Pickup Date
- Estimated Fill-To-Date = Daily Usage * Days Elapsed
- Estimated Level Amt = Tank Level Amount On Last Pickup + Estimated Fill-To-Date
- Current Tank Level % = (Estimated Level Amt / Tank Size) * 100
For example:
- Days Elapsed: 31
- Daily Usage: 5 gallons
- Estimated Fill-To-Date: 5 * 31 = 155 gallons
- Estimated Level Amt = 0.33 + 155 = 155.33 gallons
- Tank Size: 200 gallons
- Current Tank Level % = (155.33 / 200) * 100 = 77.7%
Estimated Empty Date for Fill service type
Estimated Empty Date for Fill service type 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
Estimated Full Date for Empty service type
The Estimated Full Date for tanks configured with the Empty service type, is calculated after determining these values:
-
Days until Full: (Tank Size - Tank Level after last pickup) / Daily Usage
Note: This value is truncated to an integer (not rounding) - Estimated Full Date = Current Date + Days until Full
For example:
- Tank size: 200 gallons
- Tank level at last pickup: 0.33 gallon
- Daily Usage: 5 gallons
- Days until Full: (200 - 0.33) / 5 = 39
- Estimated Full Date = 9/21/25 + 39 = 10/30/25
Delivery Due Date for Fill service type
The Delivery Due Date for Fill service type 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
Pickup Due Date for Empty service type
The Pickup Due Date is calculated differently for tanks configured with the Keep Empty and Empty Cycle service types.
For Keep Empty tanks:
-
Amount Under Safety = Safety Allowance - Tank level after last pickup.
The Safety Allowance value is specified for the tank on the BD Tank Master Setup screen.
-
Days until Safety: Amount Under Safety / Daily Usage.
Note: This value is truncated to an integer (not rounding). - Pickup Due Date = Last Pickup Date + Days until Safety.
For example:
- Tank level at last pickup: 5 gallons
- Safety Allowance: 195 gallons
- Daily Usage: 5 gallons
- Days until Safety: (195 - 5) / 5 = 38
- Pickup Due Date = 9/21/25 + 38 days = 10/29/25
For Empty Cycle tanks, Pickup Due Date = Last Pickup Date + Empty Cycle Days, where the Empty Cycle Days are defined for each Empty Cycle on the SA Administrator Table Code Value Setup - Bulk Delivery Fill Cycle screen. The Empty Cycles are assigned to tanks on the BD Tank Master Setup screen.
For example:
- Empty Cycle Days: 30
- Last Pickup Date: 9/21/25
- Pickup Due Date = 9/21/25 + 30 = 10/21/25
Order Point / Minimum for Fill service type
Order Point/Minimum for Fill service type 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.
Order Point / Minimum for Empty service type
The Order Point/Minimum for tanks configured with Empty service types, is calculated as:
- Projected Lead Time = Pickup Due Date - Current Date
- Lead Time Demand = Daily Usage * Projected Lead Time
- Order Point/Minimum = Lead Time Demand + Safety Allowance
Line Point / Maximum
Line Point/Maximum is calculated as:
Order Point/Minimum + Lead Time Demand
Line Point is not calculated for Will Call and Empty Will Call tanks, as no Delivery Due Date or Pickup Due Date is assigned to this tank type.