BD Administrator Tank Calculations Report overview

Bulk Delivery > Administration > BDA Reports > BDAC

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.