KPIs

Row

Quarterly Vendor Report for Q1

YESCO

Row

KPIs

Work Orders Assigned

27

Work Orders Closed

21

Open Work Orders | Breached Limits

6

Vendor Check In %

76.19%

Time to Close All Tickets

329.83

P1 Tickets Time to Close

0

Fixed First Trip

95.24%

Contract Status

Missing

Row

Large Tier

Ratings

2nd

2nd

2nd

1st

2nd

1st

Incomplete

Row

Invoices

Invoice Total - 2024

$0.00

Invoice Total - 2025

$0.00

Labor Rate

Inf - -Inf

Mileage Rate

Inf - -Inf

Travel Rate

Inf - -Inf

Outstanding Invoice Inquiries

0

Average Invoice Response Time

NaN

Number of Billing Discrepencies

0

Billing Discrepancies $$

$0.00

Row

Invoice $$$ Breakdown

Top 10 Part List

Items Description Occurrences Min_Cost Max_Cost

Vendor Tier

Vendor Tier
Hawkeye Electric Cedar Rapids Large
Sunshine Large
YESCO 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 Notes
Price Sign YESCO YESCO 1176 W 500 S Salt Lake City UT NA NA NA NA NA NA NA NA NA NA NA 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 (), 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
yesco 40.76042 -111.8966 1176 W 500 S, Salt Lake City, UT 84101

Row

Vendor Assignment Table

Billing Discrepancies

Row

Invoice Data

Row

Outstanding Invoice Inquiries

Closed Invoice Inquiries

Row

Raw Invoice Data

Store Summary Invoice Data

Per State Performance

Row

State Time to Close Performance

Store Information / Performance

Row

Store Dispenser Information

Top 50 Fuel Volume

Service Rating

`

Row

2025 Closed Work Order Data