Delivery Planning
Learn to use the Delivery Planning module to view and manage tank inventory projections.
Written by Jess Hamilton
Updated at January 2nd, 2025
Table of Contents
Delivery planning is a module used for projecting tanks’ inventory and using the projections to make informed decisions about when deliveries should be scheduled. This module also provides historical sales data and trending data and supports notifications when a tank is nearing runout.
Delivery Planning Page
Locate Delivery Planning
Click the nine dots in the top left corner to open the global menu. Under Fuel Management, select Delivery Planning.
Search/Filters
When the Delivery Planning page first loads, the user is presented with a search panel with several filters.
When filters are chosen, the search will take into account every filter that is selected and find the appropriate facilities.
Facility – A single facility can be selected in this field.
State/Province – Returns all facilities in the given state/provinces(s). Multiple items may be selected using Ctrl + click.
Facility – Returns all facilities in the given facility group(s). Multiple items may be selected using Ctrl + click.
Facility Statuses – Returns all facilities in the given status(es). Multiple items may be selected using Ctrl + click.
Product – This filter will not only select only those facilities with the given product(s) selected, it will show the selected tank as the parent row for the facility. This will be explained in further detail in the Results section. Multiple items may be selected using Ctrl + click.
Results
After selecting filter criteria, click Go to retrieve results.
Tip: By default, results are presented in order of projected runout time, with facilities most likely to run out first listed at the top.
The Delivery Planning grid contains all information regarding delivery planning including runout projections, sales data, current volumes, ullage, etc.
This grid utilizes all of the customization and filtering features detailed in the Grid FAQs article. Additionally, parent and child rows are utilized to group tanks for a given facility.
Each row presented when the grid first loads represent a facility and is the parent row for that facility. The primary facility row will also show information about a tank (or manifold if grouped by manifold) from that facility. By default, the tank nearest runout (as seen in the Runout Time columns) will be shown on the parent row. However, if a product filter is selected, that product will appear on the parent row instead.
To expand a parent row and display child rows, click the arrow in the far left column.
Each child row contains information about a single tank. If configured to display as a single unit, manifold tanks will be denoted with an asterisk.
Tip: The setting to display manifold tanks as a single unit is located is managed on the Tank Setup page.
Facility Demand
Facility Demand calculates fuel demand at the facility level. This feature can be leveraged to improve decision making and outcomes by better understanding factors such as your daily over and underperforming facilities, changes to demand trends impacting replenishment needs, or correlate demand to influencing factors at a facility or region (i.e., weather, promotions, local events, competitors’ business decisions).
To use Facility Demand, select the Facility Demand checkbox and expand one or more parent row. The Next 24 Hour Sales, Average Sales Per Hour, Rolling 24 Hour Demand, and Day to Hour Demand columns will show an aggregate value for the facility's tanks in the new Facility Demand row.
Next 24 Hour Sales: Sum of each product’s Next 24 Hour Sales at a facility.
Average Sales Per Hour: Sum of each product’s Average Sales Per Hour at a facility.
Rolling 24 Hour Demand: Weighted average based on the Next 24 Hour Sales of each product at the facility.
Day to Hour Demand: Weighted average based on the Next 24 Hour Sales of each product at the facility.
Facility Demand Calculation Notes:
- If one or more products is missing data (‘Insufficient Data’) for variables in the Facility Demand calculation, those product(s) will be excluded from the calculation.
- If all products have Insufficient Data, then Facility Demand will display as Insufficient Data.
- Facility Demand is recalculated each time the grid is refreshed, reflecting near real time demand.
Grid Columns
The Delivery Planning grid has a large variety of columns that may be displayed or hidden as needed.
| Column Name | Description |
|---|---|
| > (Expand) | This column contains the arrow for expanding/collapsing parent rows and cannot be hidden. |
| FacilityId | The internal Titan Cloud ID for the facility |
| Scheduled? | This row contains a checkbox for each parent and child row. If checked, it denotes that a delivery has been scheduled. The functionality is explained in full detail in the Delivery Schedule section below |
| Facility | Facility name |
| Address | Facility address |
| State | Facility state/province |
| Zip | Facility postal code |
| Product |
On the parent row, this represents the product that is currently being shown in that row. This will usually be the tank nearest runout, unless a Product filter is chosen. For child rows, this is the product of the tank/manifold of that row. |
| Tanks |
A visual representation of the amount of product in the tank.
Note: On the parent level row, each tank in the facility will be shown. On the child rows, only the given tank/manifold will be shown.
Clicking on the tank icon will open the Runout Projection dialog box. This is explained in further detail in the Runout Projection Graph section below. |
| ATG Inventory Date | The date and time of the latest inventory reading for the tank. |
| Volume | The current volume of the tank in gallons. |
| Runout Time (Hours) | The number of hours it will take this tank to hit the Runout or Deadstock value based on the current projection. If the tank is at or below this level Delivery Planning will show a Runout Time of zero. |
| Runout Time (Days) | The number of days it will take this tank to hit the Runout or Deadstock value based on the current projection. If the tank is at or below this level Delivery Planning will show a Runout Time of zero. |
| Delivery ETA | Enter the date/time that a delivery is expected to arrive to use this field to calculate Runout Risk. |
| Runout Risk | Color-coded indicator estimating how likely the tank will hit the Runout or Deadstock value before the Delivery ETA based on the current projection. |
| Capacity | The capacity of the tank. This number is polled from the ATG and displayed in the Tank profile. (Polling.dbo.TankSetup) |
| Safe Capacity | 90% of the tank capacity |
| Safe Ullage | How much volume in gallons the tank can receive before it hits the Safe Capacity (Safe Capacity – Volume) |
| Rolling 24 Hour Demand | This column shows a percentage that represents how far off the sales in the last 24 hours are from the projected sales. For example, if the tank was projected to have 1000 gallons sold in the past hour, but it actually sold 1100 gallons, this column would show 10%. If instead the tank only sold 900 gallons against the 1000 gallon projection, it would show -10%. |
| Avg Sales Per Hour | The average sales per hour over the past 24 hours for the tank. |
| Next 24 Hour Sales | Projected sales over the next 24 hours. |
| Next 24 Hours | Projected volume over the next 24 hours. |
| Potential Delivery | Text box that the user can enter in a value to simulate a delivery. Once a value has been entered, the Runout Time fields will adjust based on the value entered. This is explained in more detail in the Potential Delivery section below. |
| Deadstock |
The value at which the tank is considered to have run out of product. This value is used to calculate runout time.
This value is sourced from the Low Level (User Specified) field in the tank profile if provided. Otherwise it will be sourced from the ATG. ( |
| Runout Calc Level |
The value at which the tank is considered to be getting low on product.
This value appears on the projection graph (shown later) as a yellow line and is sourced from the Delivery Needed (user specified) field in the tank profile if provided. Otherwise it will be sourced from the ATG. ( |
| Delivery Needed (User Specified) | Runout Calc Level value as derived from the Delivery Needed (User Specified) field in the tank profile. |
| Delivery Needed (ATG) | Runout Calc Level value as polled from ATG. |
| Low Level (User Specified) | Deadstock value as derived from the Low Level (User Specified) field in the tank profile. |
| Low Level (ATG) | Deadstock value as polled from ATG. |
| Comments | Text box that the user can use to write quick notes/comments about the tank. This is persisted in the database. |
| Default Terminal | Static field that shows the default terminal for this tank/facility. This can be set in the Delivery Planning section of the tank's profile. |
| Terminal Area | Static field that shows the terminal area for this tank/facility. This can be set in the Delivery Planning section of the tank's profile. |
| Notes | Static field containing notes about the tank. This can be set in the Delivery Planning section of the tank's profile. |
| Last Calculated Date | Timestamp for when the grid values were most recently calculated. |
| ATG Tank # | The ATG Tank Number as configured in the tank's profile. |
| Trip Time | Static field to show how long a trip from the default terminal to the facility takes. This can be set in the Delivery Planning section of the tanks page. |
| Closest Terminal | Static field that shows the closest terminal for this tank/facility. This can be set in the Delivery Planning section of the tanks page. |
| Active Alarms | The number of active alarms for the tank. Clicking on the number in this field opens the alarms page in a separate tab. |
| Channel of Trade | Static field showing the channel of trade for the facility. This field is set on the facility info page and will be the same for each tank in the facility. |
| Gas Brand | Value derived from the facility profile. |
| Hauler | Static field showing the hauler for the facility. This field is set on the facility info page and will be the same for each tank in the facility. |
| Contact | Hover over the contact name for more details. Contacts listed in this column have the Contact Type(s) designated in the Delivery Planning Configuration Settings. |
Interactive Items & Dialogs
Runout Projection Graph
Clicking one of the tank icons will open the Runout Projection graph. This graph contains the past 2 days of actual inventory readings, as well as the next 5 days of projected inventory values.
A dotted vertical line shows the current time. The graph will be in local time to the facility, unless the time zone is not set in the facility profile. In that case, UTC will be used.
Trends Graph
Clicking the link in the Rolling 24 Hour Demand or the Day to Hour Demand column will open a trends graph. The trends graph breaks down sales for each hour in the given period. These hours are local to the facility.
The yellow line graph shows the projected sales in that hour, and the blue bar graph shows the actual sales in that hour. Hovering over an hour will show the projected sales, actual sales, and the percentage of the actual sales to the projected sales.
Historical Sales Graph
Clicking the link in the Next 24 Hour Sales column will open the historical sales graph. This chart shows sales for the given tank from the past 4 weeks, as well as the current week up to the previous day.
Days are defined as midnight to midnight local to facility, regardless of whether the time zone field is set.
Tip: Hover over a column to see details. You may also click the week labels to filter the graph.
Delivery Scheduled Checkbox
Users may click the Delivery Scheduled checkbox to indicate an upcoming delivery.
Checking or unchecking the box in a parent-level row will check/uncheck the box in each child-level row. Checking or unchecking the box in a child-level row will only apply the upcoming delivery to the specified tank.
Once a delivery is detected, based on the Volume Increase setting in account settings, all check marks for the facility are removed.
Potential Delivery
The potential delivery input box allows user to enter a value, which represents a number of gallons. The runout time columns will adjust according to the volume that is entered.