Summary/Use Case
Report Summary
The Fuel Variance Report delivers an in-depth analysis of fuel usage and variance by pump, tank, and fuel type. This report is valuable for fleet managers to track discrepancies, manage inventory, and monitor fuel consumption costs across various facilities. By evaluating these variances, fleet managers can identify areas of fuel loss or discrepancies that may need further investigation.
Use Case
Monitor fuel usage and detect discrepancies by pump and tank for efficient inventory management.
Track fuel costs and variances to identify potential savings or losses across facilities.
Assist in identifying specific fuel types that contribute to higher costs, aiding in budgeting and cost control.
Use fuel data to plan for optimal fuel reordering and inventory levels.
Ensure accountability by assessing pump and tank variances in fuel usage across facilities.
Location: Where to Find It
Reports > RTA Standard Reports > Fuel > Print Variance (Print Variance Sub-Reports > Fuel Pump Variance, Fuel Type Totals, Tank Variance)
Data Filter Prompts
You will be prompted for filtering of the Data to specify and narrow down the data that will be pulled. See Data Filter List Below for Options.
Data Filter List
Filter Name | Recommended Filter Condition(s) | Value (Options) | Value (Default |
|---|
) | |
|---|---|
Facility | Is Between |
1 to 99999 |
1 |
to |
99999 |
Report Output and Data Elements
Report Output
The Fuel Variance Report includes three main sections: Fuel Pump Variance, Tank Variance, and Fuel Type Totals.
Fuel Pump Variance: This section breaks down the fuel readings per pump, highlighting the differences between current and previous readings, pumped fuel, charges posted, and the resulting variances in both volume and cost.
Tank Variance: This section provides data on the beginning inventory, charged and pumped gallons, calculated variances, and total tank values. It also shows computed inventory variances, aiding in detecting any discrepancies at the tank level.
Fuel Type Totals: This section summarizes fuel usage by type, showing beginning inventory, fuel drops, total inventory, and value. It also provides cost per gallon, helping to understand the cost distribution across fuel types.
Report Data Elements
Fuel Pump Variance
Column Number | Column Title | Data Notes |
|---|---|---|
1 | Pump Number | Unique identifier for each fuel pump in the report. |
2 | Facility | Facility associated with the pump. |
3 | Tank Number | Tank number linked to each pump. |
4 | Tank Capacity | Maximum fuel capacity of the tank. |
5 | Fuel Type | Type of fuel dispensed (e.g., Diesel). |
Tank Variance
Column Number | Column Title | Data Notes |
|---|---|---|
1 | Tank | Identifier for each tank. |
2 | Fuel Type | Type of fuel contained in the tank. |
3 | Capacity | Total capacity of the tank in gallons. |
4 | Begin Inventory | Inventory at the start of the period. |
5 | Tank Drops | Number of drops in fuel level, if any. |
6 | Charged Gallons | Amount of fuel charged. |
7 | Pumped Gallons | Gallons dispensed from the tank. |
8 | Charge/Pump Variance | Difference in charged versus pumped gallons. |
9 | Computed Inventory | Calculated inventory based on initial inventory and changes. |
10 | Last Stick Reading | Most recent physical measurement of the tank level. |
11 | Computed/Actual Variance | Difference between computed inventory and last stick reading. |
12 | Average Cost/Gallon | Average cost for each gallon. |
13 | Tank Value | Total value of fuel in the tank. |
14 | Stick Diff Month | Difference in stick readings within the month. |
15 | Stick Diff Year | Difference in stick readings within the year. |
Fuel Type Totals
Column Number | Column Title | Data Notes |
|---|---|---|
1 | Code | Code representing each fuel type. |
2 | Description | Description of the fuel type (e.g., Diesel, Unleaded). |
3 | Beginning Inventory | Starting inventory for the fuel type. |
4 | Fuel Drop | Amount of fuel added (dropped) into inventory. |
5 | Fuel Used | Total fuel used. |
6 | Default Price | Default price per gallon for the fuel type. |
7 | Avg Cost/Gallon | Average cost per gallon, considering all transactions. |
8 | Total Inventory | Final inventory amount after accounting for usage and drops. |
9 | Total Value | Monetary value of the total inventory for each fuel type. |
...