KPIs

Row

Quarterly Vendor Report for Q2

YESCO

Row

KPIs

Work Orders Assigned

13

Work Orders Closed

10

Open Work Orders | Breached Limits

0

Vendor Check In %

80.00%

Time to Close All Tickets

358.72

P1 Tickets Time to Close

44.88

Fixed First Trip

38.46%

Contract Status

Current

Row

Large Tier

Ratings

2nd

2nd

1st

1st

2nd

1st

Incomplete

Row

Invoices

Invoice Total - 2024

$0.00

Invoice Total - 2025

$18,403.60

Labor Rate

135 - 420

Mileage Rate

Inf - -Inf

Travel Rate

175 - 175

Outstanding Invoice Inquiries

0

Average Invoice Response Time

NaN

Number of Billing Discrepencies

0

Billing Discrepancies $$

$0.00

Missing Invoices

9

Row

Invoice $$$ Breakdown

Top 10 Part List

Items Description Occurrences Min_Cost Max_Cost
Misc MiscServiceMaterial 9 236.25 1737.5
Disposal Fee DisposalFee 7 4 4
355-0009SLOANS-100-24VPOWERSUPPLY 355-0009SLOANS-100-24VPOWERSUPPLY 5 126 126
390-001196C8F96T12/CW/HO800MACOOLWHITELAMP 390-001196C8F96T12/CW/HO800MACOOLWHITELAMP 2 45 45
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
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 No 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

Missing Invoices

Outstanding Invoice Inquiries

Closed Invoice Inquiries

Cancelled Work Orders

Warranty 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

`

Row

2025 Closed Work Order Data