KPIs

Row

Quarterly Vendor Report for Q2

Seneca

Row

KPIs

Work Orders Assigned

142

Work Orders Closed

142

Open Work Orders | Breached Limits

0

Vendor Check In %

83.33%

Time to Close All Tickets

113.37

P1 Tickets Time to Close

3.17

Fixed First Trip

97.18%

Contract Status

Current

Row

Inactive Tier

Ratings

NA

NA

NA

1st

NA

1st

Incomplete

Row

Invoices

Invoice Total - 2024

$497,670.00

Invoice Total - 2025

$732,604.24

Labor Rate

100 - 115

Mileage Rate

1.2 - 1.5

Travel Rate

100 - 220

Outstanding Invoice Inquiries

8

Average Invoice Response Time

18.55

Number of Billing Discrepencies

48

Billing Discrepancies $$

$145296.83

Missing Invoices

34

Row

Invoice $$$ Breakdown

Top 10 Part List

Items Description Occurrences Min_Cost Max_Cost
LG-SERVICE TECH Phone save 189 105 200
M14330A001 GIL UX300 VER Card Reader 173 1265.81 1812.32
70015 CIM 40010 1” Filter 58 19.04 19.04
70020 CIM 80030 1” Filter 42 17.32 42.2
M06139A001 PER Grade Select Button 5005 40 20.34 40.92
MISC PARTS Misc. Supplies 27 10 2136.12
M04119A001RF RDM GIL Rblt 5005 Crnd Printer 26 176.54 568
0350 HUS 3/4” MxF Swivel 25 24.32 58.95
11B-0100 OPW Green Lead Nozzle 19 83.67 89.43
MISC. CHARGE MISC Truck Supplies 18 19.5 110

Vendor Tier

Vendor Tier
seneca Inactive

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 Seneca Seneca - Boise 621 Main St Boise ID 83702 Boise ID Paul Royall - - Director of Field Service Tyson Royall - - Service Manager (SLC, ID, MT) Yes 2025-02-14 2026-02-14 0.122 1.5 115 172.5 230 200 4 24 72 No Yes ? Remote tech
Fuel Seneca Seneca - Casper 200 S David St Casper WY 82601 Casper WY Paul Royall - - Director of Field Service Tyson Royall - - Service Manager (SLC, ID, MT) Yes 2025-02-14 2026-02-14 0.122 1.5 115 172.5 230 200 4 24 72 No Yes ? Remote tech
Fuel Seneca Seneca - Cheyenne 121 W 15th St Cheyenne WY 82001 Cheyenne WY Paul Royall - - Director of Field Service Tyson Royall - - Service Manager (SLC, ID, MT) Yes 2025-02-14 2026-02-14 0.122 1.5 115 172.5 230 200 4 24 72 No Yes ? Remote tech
Fuel Seneca Seneca - Chippewa Falls 3912 E Melby St, Chippewa Falls, WI 54729 Chippewa Falls WI Paul Royall - - Director of Field Service Yes 2025-02-14 2026-02-14 0.122 1.5 115 172.5 230 200 4 24 72 No Yes ? NA
Fuel Seneca Seneca - Colorado Springs NA NA NA Paul Royall - - Director of Field Service Yes 2025-02-14 2026-02-14 0.122 1.5 115 172.5 230 200 4 24 72 No NA NA NA
Fuel Seneca Seneca - Davenport 7241 Gaines St Ct, Davenport, IA 52806 Davenport IA Paul Royall - - Director of Field Service John Glasgow - - Service Manager IA Davenport Yes 2025-02-14 2026-02-14 0.122 1.5 110 165 220 20 4 24 72 No Yes ? NA
Fuel Seneca Seneca - Denver 200 S Raritan St, Denver, CO 80223 Denver CO Paul Royall - - Director of Field Service Kevin Cook - - Service Manager CO Yes 2025-02-14 2026-02-14 0.122 1.5 115 172.5 230 200 4 24 72 No Yes ? NA
Fuel Seneca Seneca - Des Moines 4140 E 14th St, Des Moines, IA 50313 Des Moines IA Paul Royall - - Director of Field Service Jon Matula - - Service Manager IA Des Moines Yes 2025-02-14 2026-02-14 0.122 1.5 110 165 220 20 4 24 72 No Yes ? NA
Fuel Seneca Seneca - Kansas City 900 Vista Ave, Independence, MO 64056 Independence MO Paul Royall - - Director of Field Service Yes 2025-02-14 2026-02-14 0.122 1.5 110 165 220 20 4 24 72 No Yes ? NA
Fuel Seneca Seneca - Grand Junction 550 Warrior Way Grand Junction CO Paul Royall - - Director of Field Service Yes 2025-02-14 2026-02-14 0.122 1.5 115 172.5 230 200 4 24 72 No Yes NA NA
Fuel Seneca Seneca - Oklahoma City 3901 S Thomas Rd, Oklahoma City, OK 73179 Oklahoma City OK Paul Royall - - Director of Field Service Bryan Sabatino - - Service Manager OKC OK Yes 2025-02-14 2026-02-14 0.122 1.5 110 165 220 20 4 24 72 No Yes ? NA
Fuel Seneca Seneca - Omaha 10415 J St suite 200, Omaha, NE 68127 Omaha NE Paul Royall - - Director of Field Service Bryce Lander - - Service Manager NE Yes 2025-02-14 2026-02-14 0.122 1.5 110 165 220 20 4 24 72 No Yes ? NA
Fuel Seneca Seneca - Oreana 458 IL-48, Oreana, IL 62554 Oreana IL Paul Royall - - Director of Field Service Gerry Ford - - Service Manager IL Yes 2025-02-14 2026-02-14 0.122 1.5 110 165 220 20 4 24 72 No Yes ? NA
Fuel Seneca Seneca - Salt Lake City 475 W 3600 S ste d, South Salt Lake, UT 84115 South Salt Lake UT Paul Royall - - Director of Field Service Chris Tabor - Yes 2025-02-14 2026-02-14 0.122 1.5 115 172.5 230 200 4 24 72 No Yes ? NA
Fuel Seneca Seneca - Springdale 589 US-412 Springdale AR NA Yes 2025-02-14 2026-02-14 0.122 1.5 110 165 220 20 4 24 72 No NA NA NA
Fuel Seneca Seneca - Springfield 1838 S Scenic Ave Springfield MO NA Yes 2025-02-14 2026-02-14 0.122 1.5 110 165 220 20 4 24 72 No NA NA NA
Fuel Seneca Seneca - Tulsa 6947 E 13th St, Tulsa, OK 74112 Tulsa OK Paul Royall - - Director of Field Service Curt Brookman - - Service Manager Tulsa OK Yes 2025-02-14 2026-02-14 0.122 1.5 110 165 220 20 4 24 72 No Yes Yes 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
seneca - billings 45.78328 -108.50774 2310 Montana Ave Billings MT 59101
seneca - boise 43.61794 -116.20225 621 Main St Boise ID 83702
seneca - casper 42.84831 -106.32690 200 S David St Casper WY 82601
seneca - cheyenne 41.13133 -104.81311 121 W 15th St Cheyenne WY 82001
seneca - chippewa falls 44.86528 -91.44707 3912 E Melby St, Chippewa Falls, WI 54729
seneca - colorado springs 38.83277 -104.78444 2500 Pikes Peak Ave Colorado Springs CO
seneca - davenport 41.59458 -90.58042 7241 Gaines St Ct, Davenport, IA 52806
seneca - denver 39.71282 -105.00826 200 S Raritan St, Denver, CO 80223
seneca - des moines 41.63630 -93.60128 4140 E 14th St, Des Moines, IA 50313
seneca - grand junction 39.07952 -108.51121 550 Warrior Way Grand Junction CO
seneca - jonesboro 35.80870 -90.70430 2809 Browns Ln Jonesboro AR
seneca - kansas city 39.09577 -94.36558 900 Vista Ave, Independence, MO 64056
seneca - little rock 34.73650 -92.29010 1371 S Battery St Little Rock AR
seneca - oklahoma city 35.42549 -97.61693 3901 S Thomas Rd, Oklahoma City, OK 73179
seneca - omaha 41.21379 -96.07584 10415 J St suite 200, Omaha, NE 68127
seneca - salt lake city 40.69326 -111.90488 475 W 3600 S ste d, South Salt Lake, UT 84115
seneca - springdale 36.18470 -94.14560 589 US 412 Springdale AR
seneca - springfield 37.18720 -93.30610 1838 S Scenic Ave Springfield MO
seneca - tulsa 36.14479 -95.89811 6947 E 13th St, Tulsa, OK 74112

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