KPIs
Row
Quarterly Vendor Report for Q2
CSESCORow
KPIs
Work Orders Assigned
358Work Orders Closed
358Open Work Orders | Breached Limits
0Vendor Check In %
97.92%Time to Close All Tickets
42.28P1 Tickets Time to Close
3.58Fixed First Trip
97.77%Contract Status
CurrentRow
Large Tier
Ratings
3rd
3rd
1st
4th
3rd
3rd
Pass
Row
Invoices
Invoice Total - 2024
$1,009,129.60Invoice Total - 2025
$842,009.03Labor Rate
0 - 142.5Mileage Rate
0 - 1.5Travel Rate
0 - 190Outstanding Invoice Inquiries
0Average Invoice Response Time
2.81Number of Billing Discrepencies
8Billing Discrepancies $$
$4256.91Missing Invoices
2Row
Invoice $$$ Breakdown
Top 10 Part List
| Items | Description | Occurrences | Min_Cost | Max_Cost |
|---|---|---|---|---|
| Environmental Fee | EF: ENVIRONMENTAL FEE | 608 | 0 | 3.5 |
| M14330A001 | M14330A001: UX300 (EMV CARD READER) .. FLEXPAY IV | 242 | 0 | 1355.79 |
| M06139A001 | M06139A001: GRADE SELECT BUTTON ENC500 | 130 | 49.27 | 75.15 |
| 66REC-1000 | 66REC-1000: BREAKAWAY 3/4” RECONNECTABLE OPW | 96 | 94.4 | 148.45 |
| 45-5075 | 45-5075: SWIVEL HOSE 1” OPW | 68 | 78.17 | 122.91 |
| M13832A001R | M13832A001R: USB PRINT HEAD, HENGSTLER .. (REBUILT) | 67 | 485 | 650 |
| 7HB-0100 | 7HB-0100: NEW 1” DIESEL NOZZLE - GREEN | 57 | 154.1 | 165 |
| 21GU-040G | 21GU-040G: DEF NOZZLE - OPW | 51 | 248.26 | 540.78 |
| 21GU-SSB | 21GU-SSB: DEF SST SWIVEL & RECONNECTABLE | 50 | 182.75 | 302.2 |
| M13888K901 | M13888K901: KIT, UPM (UNIVERSAL PAYMENT | 44 | 0 | 1721.85 |
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 | CSESCO | CSESCO - SLC | 830 N Pointe Cir, North Salt Lake, UT 84054 | North Salt Lake | UT | Darren Anderson - darren1@csesco.com - Owner Melanie Cooper - melanie@csesco.com - Billing / Invoices Garrett Cooper - garrett@csesco.com - Billing / Invoices | Yes | 2024-09-04 | 2025-09-04 | 0.1 | 1.5 | 95 | 142.5 | 190 | 325 | 4 | 24 | 72 | Yes | No | Yes | NA |
| Fuel | CSESCO | CSESCO - Hurricane | 230 Old Hwy 91 Hurricane UT | Hurricane | UT | Darren Anderson - darren1@csesco.com - Owner Melanie Cooper - melanie@csesco.com - Billing / Invoices Garrett Cooper - garrett@csesco.com - Billing / Invoices | Yes | 2024-09-04 | 2025-09-04 | 0.1 | 1.5 | 95 | 142.5 | 190 | 325 | 4 | 24 | 72 | Yes | No | Yes | Satelitte office |
| Fuel | CSESCO | CSESCO - Idaho Falls | 3821 Professional Way #13 Idaho Falls ID | Idaho Falls | ID | Darren Anderson - darren1@csesco.com - Owner Melanie Cooper - melanie@csesco.com - Billing / Invoices Garrett Cooper - garrett@csesco.com - Billing / Invoices | Yes | 2024-09-04 | 2025-09-04 | 0.1 | 1.5 | 95 | 142.5 | 190 | 325 | 4 | 24 | 72 | Yes | No | Yes | Satelitte office |
| Fuel | CSESCO | CSESCO - Mount Pleasant | 115 West Main | Mount Pleasant | UT | Darren Anderson - darren1@csesco.com - Owner Melanie Cooper - melanie@csesco.com - Billing / Invoices Garrett Cooper - garrett@csesco.com - Billing / Invoices | Yes | 2024-09-04 | 2025-09-04 | 0.1 | 1.5 | 95 | 142.5 | 190 | 325 | 4 | 24 | 72 | Yes | No | Yes | Satelitte office |
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 (heidi.allred@maverik.com), 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 |
|---|---|---|---|
| csesco - slc | 40.7886 | -111.9401 | 831 N Pointe Cir, North Salt Lake, UT 84054 |
| csesco - hurricane | 37.1790 | -113.3178 | 230 Old Hwy 91 Hurricane UT |
| csesco - idaho falls | 43.4884 | -112.0482 | 3821 Professional Way #13 Idaho Falls ID |
| csesco - mt pleasant | 39.5455 | -111.4563 | 115 West Main Mount Pleasant UT |
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
`