KPIs
Row
Quarterly Vendor Report for Q2
Midwest PetroleumRow
KPIs
Work Orders Assigned
241Work Orders Closed
233Open Work Orders | Breached Limits
8Vendor Check In %
88.89%Time to Close All Tickets
89.28P1 Tickets Time to Close
83.51Fixed First Trip
87.97%Contract Status
CurrentRow
Large Tier
Ratings
6th
6th
7th
7th
8th
9th
Incomplete
Row
Invoices
Invoice Total - 2024
$0.00Invoice Total - 2025
$311,306.38Labor Rate
0 - 187.5Mileage Rate
0 - 312.5Travel Rate
0 - 200Outstanding Invoice Inquiries
2Average Invoice Response Time
9.27Number of Billing Discrepencies
3Billing Discrepancies $$
$649.93Missing Invoices
36Row
Invoice $$$ Breakdown
Top 10 Part List
| Items | Description | Occurrences | Min_Cost | Max_Cost |
|---|---|---|---|---|
| 70034 | 70034/ELEMENT/10/MICRON | 81 | 13.04 | 13.04 |
| M14330A001 | M14330A001/Verifone/UX300/Card/Reader | 61 | 0 | 1316.98 |
| 70020 | 70020/800-30/Filter | 44 | 22.95 | 22.95 |
| M14794K001 | M14794K001/-/Kit,/Combined/Pulser/or/M05840B002. | 42 | 16.93 | 16.93 |
| 70016 | 70016/400-30/Filter/(Diesel) | 27 | 10 | 10 |
| 70898 | 70898/CIM-TEK/MICROGLASS/FILTER/400HA-10 | 17 | 27.52 | 27.52 |
| 45-5075 | 45-5075/SWIVEL/2-PLANE/1”Mx1/“F/NPT | 15 | 78.13 | 78.13 |
| M04219A001 | M04219A001 R USB Thermal Printer w/out chute, Rebuilt | 9 | 314.12 | 550 |
| 11BP-0300-11BP | 11BP-0300-11BP 3/4” Nozzle, Red | 9 | 87.04 | 87.04 |
| 21 GU-SSB | 21 GU-SSB DEF Swivel Breakaway | 8 | 177.35 | 182.66 |
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 | Midwest Petroleum | DeForest | 4334 Hawk Trail | DeForest | WI | Service Department - service@mwpetroleum.com EJ Maruska - ej.maruska@mwpetroleum.com - Director of Service Operations Melinda Lawrence - melinda.lawrence@mwpetroleum.com - Billing Manager | Yes | 2024-02-13 | 2026-02-13 | 0.185 | 1.25 | 89 | 133.5 | 178 | 0 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | Midwest Petroleum | Midwest Petroleum - Des Moines | 6365 NE 14th St Des Moines IA 50313 | Des Moines | IA | Service Department - service@mwpetroleum.com EJ Maruska - ej.maruska@mwpetroleum.com - Director of Service Operations Melinda Lawrence - melinda.lawrence@mwpetroleum.com - Billing Manager | Yes | 2024-02-13 | 2026-02-13 | 0.185 | 1.25 | 89 | 133.5 | 178 | 0 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | Midwest Petroleum | Midwest Petroleum - Geneseo | 118 N Williams St | Geneseo | IL | Service Department - service@mwpetroleum.com EJ Maruska - ej.maruska@mwpetroleum.com - Director of Service Operations Melinda Lawrence - melinda.lawrence@mwpetroleum.com - Billing Manager | Yes | 2024-02-13 | 2026-02-13 | 0.185 | 1.25 | 89 | 133.5 | 178 | 0 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | Midwest Petroleum | Midwest Petroleum - Grand Island | 3733 Arch Ave, Grand Island, NE 68803 | Grand Island | NE | Service Department - service@mwpetroleum.com EJ Maruska - ej.maruska@mwpetroleum.com - Director of Service Operations Melinda Lawrence - melinda.lawrence@mwpetroleum.com - Billing Manager | Yes | 2024-02-13 | 2026-02-13 | 0.185 | 1.25 | 89 | 133.5 | 178 | 0 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | Midwest Petroleum | Midwest Petroleum - Lincoln | 2255 S 7th St, Lincoln, NE 68502 | Lincoln | NE | Service Department - service@mwpetroleum.com EJ Maruska - ej.maruska@mwpetroleum.com - Director of Service Operations Melinda Lawrence - melinda.lawrence@mwpetroleum.com - Billing Manager | Yes | 2024-02-13 | 2026-02-13 | 0.185 | 1.25 | 89 | 133.5 | 178 | 0 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | Midwest Petroleum | Midwest Petroleum - North Platte | 3220 Detco Cir, North Platte, NE 69101 | North Platte | NE | Service Department - service@mwpetroleum.com EJ Maruska - ej.maruska@mwpetroleum.com - Director of Service Operations Melinda Lawrence - melinda.lawrence@mwpetroleum.com - Billing Manager | Yes | 2024-02-13 | 2026-02-13 | 0.185 | 1.25 | 89 | 133.5 | 178 | 0 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | Midwest Petroleum | Midwest Petroleum - Omaha | 5641 S 85th Cir, Omaha, NE 68127 | Omaha | NE | Service Department - service@mwpetroleum.com EJ Maruska - ej.maruska@mwpetroleum.com - Director of Service Operations Melinda Lawrence - melinda.lawrence@mwpetroleum.com - Billing Manager | Yes | 2024-02-13 | 2026-02-13 | 0.185 | 1.25 | 89 | 133.5 | 178 | 0 | 4 | 24 | 72 | Yes | NA | NA | We have one contrat for Midwest Petroleum for Nebraska, SD, Iowa, Minnesota & Eastern Wyoming. Same question as will O’day |
| Fuel | Midwest Petroleum | Midwest Petroleum - Sioux Falls | 1310 E 39th St N, Sioux Falls, SD 57104 | Sioux Falls | SD | Service Department - service@mwpetroleum.com EJ Maruska - ej.maruska@mwpetroleum.com - Director of Service Operations Melinda Lawrence - melinda.lawrence@mwpetroleum.com - Billing Manager | Yes | 2024-02-13 | 2026-02-13 | 0.185 | 1.25 | 89 | 133.5 | 178 | 0 | 4 | 24 | 72 | Yes | NA | NA | NA |
| Fuel | Midwest Petroleum | Midwest Petroleum - Rapid City | 3010 Cambell Street Rapid City SD 57701 | Rapid City | SD | Service Department - service@mwpetroleum.com EJ Maruska - ej.maruska@mwpetroleum.com - Director of Service Operations Melinda Lawrence - melinda.lawrence@mwpetroleum.com - Billing Manager | Yes | 2024-02-13 | 2026-02-13 | 0.185 | 1.25 | 89 | 133.5 | 178 | 0 | 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 |
|---|---|---|---|
| midwest petroleum - des moines | 41.67612 | -93.59778 | 6365 NE 14th St Des Moines IA 50313 |
| midwest petroleum - geneseo | 41.45060 | -90.15450 | 118 N Williams St Geneseo IL 61254 |
| midwest petroleum - grand island | 40.91700 | -98.37640 | 3733 Arch Ave, Grand Island, NE 68803 |
| midwest petroleum - lincoln | 40.79040 | -96.68130 | 2255 S 7th St, Lincoln, NE 68502 |
| midwest petroleum - north platte | 41.13870 | -100.77040 | 3220 Detco Cir, North Platte, NE 69101 |
| midwest petroleum - omaha | 41.19900 | -96.09920 | 5641 S 85th Cir, Omaha, NE 68127 |
| midwest petroleum - sioux falls | 43.58780 | -96.67830 | 1310 E 39th St N, Sioux Falls, SD 57104 |
| midwest petroleum - rapid city | 44.05740 | -103.19130 | 3010 Cambell Street Rapid City SD 57701 |
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
`