Procurement Weekly Analysis

ALERT

Exception desk

Issues requiring attention before the next procurement cycle.

active flags

EMPTY

No data loaded

Refresh the Domestic LPO data source to see flags.

Recommended actions this week

Load data to generate action items.

Jefferson Murage — Buyer Compliance Check

Did Jefferson buy from the assigned vendor and at the expected price?

Load data to see Jefferson's compliance record.

Filing requirements for Jefferson

How to supply data and when to upload.

How to Supply

The dashboard reads the committed Domestic LPO CSV automatically. Keep completed and pending orders, dates, prices, and supplier names current in that source file.

When to Upload

Replace the source CSV whenever the Domestic LPO export changes, then use Refresh data to load the latest version.

Deadline

All LPO data must be uploaded within 5 days of the original request date. Late filings will be flagged for review.

Total Spend

KES 0

0 orders

Procurement Speed

0 days

Median 0 days

Vendor Efficiency

Fastest: --

Slowest: --

Avg Unit Price

KES 0

vs previous period: --

Price Deviations

orders with ≥10% deviation

Paid / Completed Orders

Click column headers to sort. Red rows = price over budget ≥10%.

Item	Qty	Assigned Supplier	Budget Price	Actual Price	Deviation	1yr Benchmark	8wk Benchmark	Total	Completed	Duration

Vendor Performance Summary

Supplier	Total Spend	Orders	Avg Unit Price	Avg Duration	Overpriced

Vendor Classification

High Total Value

High Unit Price

Core Vendors

High-Value Items (Total Spend)

Item	Total Spend	Qty	Avg Unit Price	1yr Benchmark	8wk Benchmark	Trend	Orders

High-Value Items (Unit Price)

Item	Avg Unit Price	Total Spend	Orders

Spend by Vendor

Duration by Vendor

Pending Count

Suppliers pending: 0

Average Wait Time

0 days

Median 0 days

Oldest Request

Requested / In Progress

Items requested but not yet procured. Expected Price = trailing 12-month and 8-week averages for that item.

Item	Qty	Requested By	Assigned Supplier	Date Requested	Days Waiting	Expected Price (1yr avg)	Expected Price (8wk avg)

Longest Pending Requests

Item	Supplier	Requested By	Requested	Duration

Pending Duration Distribution

Item Price History & Benchmarks

Trailing 12-month average = your expected/benchmark price. Use this when reviewing any new order.

Load data to see item price histories.

Item Compliance Checklist

For each item — is pricing trending OK? Is duration normal? Is quality feedback being recorded?

Filter:

Item	Orders	Avg Price	1yr Benchmark	Price Trend	Avg Duration	Duration OK?	Quality Logged?	Compliant?

Vendor Compliance Review

Did buyers use the assigned vendor? Were actual prices within budget? "Any" = no vendor assigned.

Item	Requested By	Assigned Supplier	Actual Supplier	Used Assigned?	Budget Price	Actual Price	Price OK?	Date

Buyer Scorecards

Per-requester compliance across all completed orders in the selected period.

Load data to see buyer scorecards.

Vendor Benchmarks by Item

Historical price range and average per item per vendor. Use as benchmark for future orders.

Item	Vendor	Orders	Min Price	Max Price	Avg Price (Benchmark)	Avg Duration	Overpriced?

Find the orders that need a decision.