KPIs

Row

Quarterly Vendor Report for Q4

YESCO

Row

KPIs

Work Orders Assigned

27

Work Orders Closed

20

Open Work Orders | Breached Limits

6

Vendor Check In %

45.00%

Time to Close All Tickets

387.94

P1 Tickets Time to Close

0

Fixed First Trip

95%

Contract Status

Missing

Row

Large Tier

Ratings

1st

1st

5th

1st

5th

1st

Incomplete

Row

Invoices

Invoice Total - Year to Date

$0.00

Labor Rate

Inf - -Inf

Mileage Rate

Inf - -Inf

Travel Rate

Inf - -Inf

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
Claude Neon Federal Signs Inc Large
Lashier Partners Large
Springfield Sign & Graphics 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_Rewal_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

Active u_store.u_address u_store.u_city u_store.u_state address latitude longitude Remote.Tech Vendor_Name Parent_Company
133 1176 W 500 S Salt Lake City UT 1176 W 500 S, Salt Lake City, UT 84101 40.76042 -111.8966 YESCO YESCO

Row

Vendor Assignment Table

Billing Discrepancies

Row

Invoice Data

Row

Raw Invoice Data

Store Summary Invoice Data

Per State Performance

Row

State Time to Close Performance

Per Store Performance

Row

Quarterly Time to Close Performance

Yearly Time to Close Performance

Service Rating

`

Row

2024 Closed Work Order Data