KPIs
Row
Quarterly Vendor Report for Q3
NWESTCORow
KPIs
Work Orders Assigned
122Work Orders Closed
122Open Work Orders | Breached Limits
0Vendor Check In %
96.67%Time to Close All Tickets
27.49P1 Tickets Time to Close
5.51Fixed First Trip
91.8%Contract Status
CurrentRow
Large Tier
Ratings
4th
3rd
1st
3rd
2nd
5th
Pass
Row
Invoices
Invoice Total - 2024
$369,958.50Invoice Total - 2025
$411,487.92Labor Rate
90 - 125Mileage Rate
1.25 - 1.75Travel Rate
90 - 125Outstanding Invoice Inquiries
0Average Invoice Response Time
10.32Number of Billing Discrepencies
6Billing Discrepancies $$
$2448.80Missing Invoices
8Row
Invoice $$$ Breakdown
Top 10 Part List
| Items | Description | Occurrences | Min_Cost | Max_Cost |
|---|---|---|---|---|
| MISC | Miscellaneous Supplies | 557 | 2.95 | 3224.08 |
| 70020 | Cim-Tek CEN 800 Series 30mic 800-30 | 70 | 20.43 | 42.2 |
| M14330A001 | Gilbarco FlexPay EMV card reader UX300 1 | 67 | 1271.41 | 1949.78 |
| 70016 | Cim-Tek Filter 400-30 | 64 | 9.08 | 18.76 |
| M06139A001 | Gil Encore Grade Button Assy | 53 | 47.97 | 75.15 |
| MiscSale | RDM D2470 controller pn 6476 1 | 52 | 2.56 | 4384.4 |
| 70065 | FILTER CEN 400HS-30, Gil | 40 | 13.28 | 21.54 |
| TariffSurcharge | TariffSurcharge | 32 | 0.29 | 93.48 |
| M13888K901 | KIT UPM | 29 | 1590.85 | 2476.22 |
| 21GUSSB | OPW DEF SS RECONNECTABLE BREAKAWAY/ 1 | 21 | 173.8 | 279 |
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 | NWESTCO | Hooten Equipment - Bethel Heights | 4725 N Oak St, Bethel Heights, AR 72764 | Bethel Heights | AR | Jeff Tanner - jefft@nwestco.com - Manager Adam Sigle - adams@nwestco.com - Service Manager Derek Thomas - derekt@nwestco.com - Branch Manager | Yes | 2024-08-01 | 2025-08-01 | 0.1 | 1.50 | 105 | 157.5 | 210 | 250 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | NWESTCO | NWESTCO - Boise | 106 S 43rd Ave suite 4, Caldwell, ID 83605 | Caldwell | ID | Jeff Tanner - jefft@nwestco.com - Manager Roy Wade - royw@nwestco.com - Service Manager | Yes | 2024-08-01 | 2025-08-01 | 0.1 | 1.50 | 105 | 157.5 | 210 | 250 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | NWESTCO | NWESTCO - Billings | 923 2nd Ave N, Billings, MT 59101 | Billings | MT | Jeff Tanner - jefft@nwestco.com - Manager Daniel Leonard - daniel.leonard@nwestco.com | Yes | 2024-08-01 | 2025-08-01 | 0.1 | 1.25 | 96 | 144 | 192 | 235 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | NWESTCO | NWESTCO - Burlington | 418 Husky Ave Burlington WY | Burlington | WY | Jeff Tanner - jefft@nwestco.com - Manager Daniel Leonard - daniel.leonard@nwestco.com | Yes | 2024-08-01 | 2025-08-01 | 0.1 | 1.25 | 96 | 144 | 192 | 235 | 4 | 24 | 72 | Yes | NA | NA | Remote Tech |
| Fuel | NWESTCO | NWESTCO - Cheyenne | 2611 Nationway, Cheyenne, WY 82001 | Cheyenne | WY | Jeff Tanner - jefft@nwestco.com - Manager Daniel Leonard - daniel.leonard@nwestco.com | Yes | 2024-08-01 | 2025-08-01 | 0.1 | 1.25 | 96 | 144 | 192 | 235 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | NWESTCO | NWESTCO - Dublin | 6805 Sierra Ct, Dublin, CA 94568 | Dublin | CA | Jeff Tanner - jefft@nwestco.com - Manager Kelvin Cruz - kelvin.cruz@nwestco.com - Service Mangaer | Yes | 2024-08-01 | 2025-08-01 | 0.1 | 1.25 | 96 | 144 | 192 | 235 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | NWESTCO | NWESTCO - Fort Smith | 3201 Wheeler Av | Fort Smith | AR | Jeff Tanner - jefft@nwestco.com - Service Manager Brent Loyd - brent.loyd@nwestco.com - Branch Manager | Yes | 2024-08-01 | 2025-08-01 | 0.1 | NA | NA | NA | NA | NA | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | NWESTCO | NWESTCO - Kalispell | 115 Industrial Ct, Kalispell, MT 59901 | Kalispell | MT | Jeff Tanner - jefft@nwestco.com - Manager Daniel Leonard - daniel.leonard@nwestco.com | Yes | 2024-08-01 | 2025-08-01 | 0.1 | 1.25 | 96 | 144 | 192 | 235 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | NWESTCO | NWESTCO - Pasco | 9335 Sandfur Pkwy | Pasco | WA | Jeff Tanner - jefft@nwestco.com - Manager Daniel Mitchell - daniel.mitchell@nwestco.com - Service Mangaer | Yes | 2024-08-01 | 2025-08-01 | 0.1 | 1.50 | 105 | 157.5 | 210 | 250 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | NWESTCO | NWESTCO - Spokane | 16115 E Trent Ave, Spokane Valley, WA 99216 | Spokane Valley | WA | Jeff Tanner - jefft@nwestco.com - Manager Daniel Mitchell - daniel.mitchell@nwestco.com - Service Mangaer | Yes | 2024-08-01 | 2025-08-01 | 0.1 | 1.50 | 105 | 157.5 | 210 | 250 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | NWESTCO | NWESTCO - Lakewood | 10025 S Tacoma Way | Lakewood | WA | Jeff Tanner - jefft@nwestco.com - Manager Misael Aguiliar - misaela@nwestco.com - Service Manager | Yes | 2024-08-01 | 2025-08-01 | 0.1 | 1.50 | 105 | 157.5 | 210 | 250 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | NWESTCO | NWESTCO - Seattle | 837 Industry Dr | Tukwila | WA | Jeff Tanner - jefft@nwestco.com - Manager Misael Aguiliar - misaela@nwestco.com - Service Manager | Yes | 2024-08-01 | 2025-08-01 | 0.1 | 1.50 | 105 | 157.5 | 210 | 250 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | NWESTCO | NWESTCO - Laramie | 1720 South 13th Street | Laramie | WY | Jeff Tanner - jefft@nwestco.com - Manager Daniel Leonard - daniel.leonard@nwestco.com | Yes | 2024-08-01 | 2025-08-01 | 0.1 | 1.50 | 105 | 157.5 | 210 | 250 | 4 | 24 | 72 | Yes | NA | NA | Remote Tech |
| Fuel | NWESTCO | NWESTCO - Portland | 6150 NE 92nd Drive | Portland | OR | Jeff Tanner - jefft@nwestco.com - Manager Jessie Spino - jesses@nwestco.com - Service Manager | Yes | 2024-08-01 | 2025-08-01 | 0.1 | 1.50 | 105 | 157.5 | 210 | 250 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | NWESTCO | NWESTCO - Fresno | 2403 E Belmont Ave | Fresno | CA | Jeff Tanner - jefft@nwestco.com - Manager Laurence Griego - laurence.griego@nwestco.com - Service Manager | Yes | 2024-08-01 | 2025-08-01 | 0.1 | 1.50 | 105 | 157.5 | 210 | 250 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | NWESTCO | NWESTCO - Bakersfield | 2209 Zuess Ct | Bakersfield | CA | Jeff Tanner - jefft@nwestco.com - Manager Dustin Reese - dustin.reese@nwestco.com - Service Manager | Yes | 2024-08-01 | 2025-08-01 | 0.1 | 1.50 | 105 | 157.5 | 210 | 250 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | NWESTCO | NWESTCO - San Jose | 6292 San Ignacio | San Jose | CA | Jeff Tanner - jefft@nwestco.com - Manager Dustin Reese - dustin.reese@nwestco.com - Service Manager | Yes | 2024-08-01 | 2025-08-01 | 0.1 | 1.50 | 105 | 157.5 | 210 | 250 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | NWESTCO | NWESTCO - Denver | 4995 York St | Denver | CO | Jeff Tanner - jefft@nwestco.com - Manager Masud Bahramand - masud.bahramand@nwestco.com - Service Manager | Yes | 2024-08-01 | 2025-08-01 | 0.1 | 1.50 | 105 | 157.5 | 210 | 250 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | NWESTCO | NWESTCO - Springdale | 4994 N Oak St | Springdale | AR | Jeff Tanner - jefft@nwestco.com - Manager Adam Sigle - adams@nwestco.com - Service Manager Derek Thomas - derekt@nwestco.com - Branch Manager | Yes | 2024-08-01 | 2025-08-01 | 0.1 | 1.50 | 105 | 157.5 | 210 | 250 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | NWESTCO | NWESTCO - Twin Falls | 2458 Warren Ave | Twin Falls | ID | Jeff Tanner - jefft@nwestco.com - Manager Roy Wade - royw@nwestco.com - Service Manager | Yes | 2024-08-01 | 2025-08-01 | 0.1 | 1.50 | 105 | 157.5 | 210 | 250 | 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 (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 |
|---|---|---|---|
| hooten equipment - bethel heights | 36.21980 | -94.13080 | 4725 N Oak St, Bethel Heights, AR 72764 |
| nwestco - billings | 45.78850 | -108.49514 | 923 2nd Ave N, Billings, MT 59101 |
| nwestco - boise | 43.64115 | -116.65105 | 106 S 43rd Ave suite 4, Caldwell, ID 83605 |
| nwestco - burlington | 44.44450 | -108.42780 | 418 Husky Ave Burlington WY |
| nwestco - cheyenne | 41.13240 | -104.78878 | 2611 Nationway, Cheyenne, WY 82001 |
| nwestco - dublin | 37.70957 | -121.91376 | 6805 Sierra Ct, Dublin, CA |
| nwestco - fort smith | 35.36890 | -94.40640 | 3201 Wheeler Ave, Fort Smith, AR 72901 |
| nwestco - kalispell | 48.12002 | -114.25597 | 115 Industrial Ct, Kalispell, MT 59901 |
| nwestco - pasco | 46.23820 | -119.21970 | 9335 Sandfur Pkwy Pasco WA 99301 |
| nwestco - spokane | 47.69592 | -117.19379 | 16115 E Trent Ave, Spokane Valley, WA 99216 |
| nwestco - lakewood | 47.16624 | -122.48351 | 10025 S Tacoma Way, Lakewood, WA |
| nwestco - seattle | 47.45510 | -122.26180 | 837 Industry Dr Tukwila WA |
| nwestco - laramie | 41.29860 | -105.57690 | 1720 South 13th Street Laramie WY |
| nwestco - fresno | 36.75264 | -119.77819 | 2403 E Belmont Ave, Fresno, CA |
| nwestco - bakersfield | 35.39044 | -119.04079 | 2209 Zuess Ct, Bakersfield, CA |
| nwestco - san jose | 37.24053 | -121.77182 | 6292 San Ignacio, San Jose, CA |
| nwestco - denver | 39.78075 | -104.96601 | 4995 York St, Denver, CO |
| nwestco - springdale | 36.17727 | -94.13496 | 4994 N Oak St, Springdale, AR |
| nwestco - twin falls | 42.56297 | -114.46080 | 2458 Warren Ave Twin Falls ID 83301 |
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
`