Print Variance

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.

  1. 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.

  2. 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.

  3. 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.