KPIs
Row
Quarterly Vendor Report for Q2
SMERow
KPIs
Work Orders Assigned
61Work Orders Closed
60Open Work Orders | Breached Limits
1Vendor Check In %
91.67%Time to Close All Tickets
74.32P1 Tickets Time to Close
18.29Fixed First Trip
86.89%Contract Status
CurrentRow
Medium Tier
Ratings
5th
4th
2nd
3rd
4th
4th
Incomplete
Row
Invoices
Invoice Total - 2024
$0.00Invoice Total - 2025
$1.10Labor Rate
1 - 1Mileage Rate
Inf - -InfTravel Rate
Inf - -InfOutstanding Invoice Inquiries
22Average Invoice Response Time
29Number of Billing Discrepencies
1Billing Discrepancies $$
$799.76Missing Invoices
37Row
Invoice $$$ Breakdown
Top 10 Part List
| Items | Description | Occurrences | Min_Cost | Max_Cost |
|---|---|---|---|---|
| Test | Test | 1 | 0.1 | 0.1 |
| NA | NA | 0 | NA | NA |
| NA | NA | 0 | NA | NA |
| NA | NA | 0 | NA | NA |
| NA | NA | 0 | NA | NA |
| NA | NA | 0 | NA | NA |
| NA | NA | 0 | NA | NA |
| NA | NA | 0 | NA | NA |
| NA | NA | 0 | NA | NA |
| NA | NA | 0 | NA | NA |
Vendor Tier
| Vendor | Tier |
|---|---|
| American Petroleum | Medium |
| FMS | Medium |
| Neumayer Equipment | Medium |
| O’Day Equipment | Medium |
| PipeCo | Medium |
| RW Mercer | Medium |
| SME | Medium |
| Unified Contracting Service | Medium |
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 | SME | SME - Billings | 2502 Overland Ave | Billings | MT | Dispatch - SMEDispatch@sme-solutions.com Director of Service - Josh Hodges - josh@sme-solutions.com Service Manager - Jason Franke - jasonfr@sme-solutions.com Director of Billing - jaimeg@sme-solutions.com | Yes | 2025-05-22 | 2026-05-22 | 0.25 | 1.05 | 105 | 157.5 | 210 | 275 | 4 | 24 | 72 | Yes | Yes | Yes | One remote tech |
| Fuel | SME | SME - Kennewick | 6223 W Deschutes Ave #201, Kennewick, WA 99336 | Kennewick | WA | Dispatch - SMEDispatch@sme-solutions.com Director of Service - Josh Hodges - josh@sme-solutions.com Service Manager - Jason Franke - jasonfr@sme-solutions.com Director of Billing - jaimeg@sme-solutions.com | Yes | 2025-05-22 | 2026-05-22 | 0.25 | 1.05 | 105 | 157.5 | 210 | 275 | 4 | 24 | 72 | Yes | Yes | Yes | NA |
| Fuel | SME | SME - Lakewood | 10107 S Tacoma Way Suite A2 | Lakewood | WA | Dispatch - SMEDispatch@sme-solutions.com Director of Service - Josh Hodges - josh@sme-solutions.com Service Manager - Jason Franke - jasonfr@sme-solutions.com Director of Billing - jaimeg@sme-solutions.com | Yes | 2025-05-22 | 2026-05-22 | 0.25 | 1.05 | 105 | 157.5 | 210 | 275 | 4 | 24 | 72 | Yes | Yes | Yes | NA |
| Fuel | SME | SME - Portland | 2800 NW 31st Ave | Portland | OR | Dispatch - SMEDispatch@sme-solutions.com Director of Service - Josh Hodges - josh@sme-solutions.com Service Manager - Jason Franke - jasonfr@sme-solutions.com Director of Billing - jaimeg@sme-solutions.com | Yes | 2025-05-22 | 2026-05-22 | 0.25 | 1.05 | 105 | 157.5 | 210 | 275 | 4 | 24 | 72 | Yes | Yes | Yes | NA |
| Fuel | SME | SME - Spokane Valley | 6015 E Valleyway Ave, Spokane Valley, WA 99212 | Spokane Valley | WA | Dispatch - SMEDispatch@sme-solutions.com Director of Service - Josh Hodges - josh@sme-solutions.com Service Manager - Jason Franke - jasonfr@sme-solutions.com Director of Billing - jaimeg@sme-solutions.com | Yes | 2025-05-22 | 2026-05-22 | 0.25 | 1.05 | 105 | 157.5 | 210 | 275 | 4 | 24 | 72 | Yes | 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 (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 |
|---|---|---|---|
| sme - billings | 45.75530 | -108.5749 | 2502 Overland Ave Billings MT 59102 |
| sme - kennewick | 46.21511 | -119.2035 | 6223 W Deschutes Ave #201, Kennewick, WA 99336 |
| sme - lakewood | 47.16160 | -122.5007 | 10107 S Tacoma Way Suite A1, Lakewood WA 98499 |
| sme - portland | 45.54120 | -122.7135 | 2800 NW 31st Ave Portland OR 97210 |
| sme - spokane valley | 47.66125 | -117.3231 | 6015 E Valleyway Ave, Spokane Valley, WA 99212 |
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
`