KPIs

Row

Quarterly Vendor Report for Q2

Guardian

Row

KPIs

Work Orders Assigned

215

Work Orders Closed

215

Open Work Orders | Breached Limits

0

Vendor Check In %

84.43%

Time to Close All Tickets

118.51

P1 Tickets Time to Close

29.42

Fixed First Trip

88.37%

Contract Status

Current

Row

Large Tier

Ratings

7th

7th

1st

9th

9th

8th

Incomplete

Row

Invoices

Invoice Total - 2024

$0.00

Invoice Total - 2025

$253,349.40

Labor Rate

90 - 135

Mileage Rate

1.25 - 1.25

Travel Rate

Inf - -Inf

Outstanding Invoice Inquiries

0

Average Invoice Response Time

NaN

Number of Billing Discrepencies

2

Billing Discrepancies $$

$227.16

Missing Invoices

41

Row

Invoice $$$ Breakdown

Top 10 Part List

Items Description Occurrences Min_Cost Max_Cost
Environmental Fee 119 10 10
GILM14330A001 CARD READER, EMV, UX300 443-288-215 46 1517.02 1577.71
GILM06139A001 ASSY, GRADE SELECT BUTTON, ENC 41 58.47 60.78
CIM70097 FILTER, 475XL-10 MIC, PARTICULATE, EXT. 37 15.66 16.29
CIM70034 FILTER, 450-10 MIC, 1”, PARTICULATE, LONG 28 11.56 12.03
CIM70898 FILTER, 400HA-10 MIC, 1”, MICROGLASS 18 24.39 24.39
OPW11 BP-8400 KIT, NOZZLE & FILLGUARD, 11 BP, BLACK 16 105.81 105.81
GILM12893A001 R PPU DISPLAY, ENCS, SINGLE 11 91.35 127.85
GILES5005-91 LB OVERLAY, ENC 5005, 91, LIGHT BLUE 8 7.51 7.65
GILM13888A901 UPM, UNIV PYMNT MOD, M13888K901 04509581 8 1926.63 1963.33

Vendor Tier

Vendor Tier
CSESCO Large
CSU Large
D&H Large
Eaton Metal Large
Guardian Fueling Technologies Large
Leonards Large
Midwest Petroleum Large
NWESTCO Large
Petro West Large

Work Order Data

Row

Acceptable Ranges for Critical Work Orders in Hours

Acceptable Ranges for High Work Orders in Hours

Acceptable Ranges for Normal Work Orders in Hours

Row

Assigned Work Orders

Closed Work Orders

P1 Closed Work Orders

Quarter Open Work Orders - Breached Acceptable Ranges

Year Open Work Orders - Breached Acceptable Ranges

Work Orders - Checked In

Work Orders - Not Checked In

Repeat Trips

Excluded Work Orders

Contract Info

Column

Contract Details

Area Parent_Company Vendor_Name Address City State Vendor_Point_of_Contact Under_Contract Effective_Contract_Date Proposed_Renewal_Date Part_Markup Mileage Hourly After Hours/Weekend Holiday Per Diem P1 P2 P3 Gilbarco Certified Wayne Certified Bennett Certified Notes
Fuel Guardian Fueling Technologies Guardian Fueling Technologies NA NA NA NA Yes 2024-01-30 2026-01-30 0.25 1.25 110 165 220 200 4 24 72 Yes NA NA NA
Fuel Guardian Fueling Technologies Guardian - Central Texas 2461 Loop 337 New Braunfels TX 78130 New Braunfels TX NA Yes 2024-01-30 2026-01-30 0.25 NA NA NA NA NA 4 24 72 Yes NA NA NA
Fuel Guardian Fueling Technologies Guardian - Colorado Springs 8551 Dry Needle Place Colorado Springs CO 80908 Colorado Springs CO Branch Manager - Frank Hubbard - Service Manager - Wes Carara - Dispatch Email - Yes 2024-01-30 2026-01-30 0.25 1.25 110 165 220 200 4 24 72 Yes NA NA NA
Fuel Guardian Fueling Technologies Guardian - Denver 4275 S Navajo St Englewood CO 80110 Englewood CO Branch Manager - Frank Hubbard - Service Manager - Wes Carara - Dispatch Email - Yes 2024-01-30 2026-01-30 0.25 1.25 110 165 220 200 4 24 72 Yes NA NA NA
Fuel Guardian Fueling Technologies Guardian - Houston 2255 Randon Dyer Road Rosenberg TX 77471 Rosenberg TX NA Yes 2024-01-30 2026-01-30 0.25 NA NA NA NA NA 4 24 72 Yes NA NA NA
Fuel Guardian Fueling Technologies Guardian - Oklahoma City 400 NE 145th Place Edmond OK 73013 Edmond OK SVP - Darin Gingrich - Service Manager - Matt Cogswell - Yes 2024-01-30 2026-01-30 0.25 1.25 90 135 180 200 4 24 72 Yes NA NA NA
Fuel Guardian Fueling Technologies Guardian - Pueblo 3241 Oneal Ave Pueblo CO 81005 Pueblo CO Branch Manager - Frank Hubbard - Service Manager - Wes Carara - Dispatch Email - Yes 2024-01-30 2026-01-30 0.25 1.25 110 165 220 200 4 24 72 Yes NA NA NA
Fuel Guardian Fueling Technologies Guardian - Tulsa 1515 West 36th Place Tulsa OK 74107 Tulsa OK SVP - Darin Gingrich - Branch Manager - Aaron Stanley - Service Manager - Kyle Shafter - Yes 2024-01-30 2026-01-30 0.25 1.25 90 135 180 200 4 24 72 Yes NA NA NA

Row

Contract Table Key

Green = Contract on file, less than one year old
Red = No contract on file or expired (over one year old)

For resolution of red-flagged items, please contact Heidi Allred (), our Procurement Manager, who can initiate the creation of a Master Services Agreement (MSA) or the renewal of existing contracts.

Vendor Assignments

Row

Vendor Assignment Map

Vendor Addresses

Vendor_Name vend_lat vend_lon address
guardian - central texas 29.6991 -98.1076 2461 Loop 337 New Braunfels TX 78130
guardian - colorado springs 38.9583 -104.6987 8551 Dry Needle Place Colorado Springs CO 80908
guardian - denver 39.6450 -104.9915 4275 S Navajo St Englewood CO 80110
guardian - houston 29.5375 -95.8083 2255 Randon Dyer Road Rosenberg TX 77471
guardian - oklahoma city 35.6123 -97.4781 400 NE 145th Place Edmond OK 73013
guardian - pueblo 38.2350 -104.6540 3241 Oneal Ave Pueblo CO 81005
guardian - tulsa 36.1085 -96.0111 1515 West 36th Place Tulsa OK 74107

Row

Vendor Assignment Table

Billing Discrepancies

Row

Invoice Data

Row

Missing Invoices

Outstanding Invoice Inquiries

Closed Invoice Inquiries

Invoices Currently Being Processed

Cancelled Work Orders

Warranty Work Orders

Combined Work Orders on One Invoice

Enviornmental Work Orders

Row

Raw Invoice Data

Store Summary Invoice Data

Per State Performance

Row

State Time to Close Performance

Per Dispatch Location Performance

Row

Dispatch Location Time to Close Performance

Store Information / Performance

Row

Store Dispenser Information

Top 50 Fuel Volume

Service Rating

`

Row

2025 Closed Work Order Data