Procurement Efficiency Calculator
PEC v1.0
$1,000,000
$10K
$100K
$1M
$5M
$10M
500
1
100
500
1000
2500
5000
50
1
10
50
100
250
500
5
1
5
10
15
20
30
5
1
5
10
20
35
50
Overall Efficiency
85.0%
Cost per Order
$250.00
Orders per Staff
100
📊
Efficiency Analysis
0%
25%
50%
75%
100%
Efficiency Score:
85.0%
Level:
Excellent
Average Order Value
$2,000
Supplier Concentration
10.0%
Cost per Staff
$200,000
Spend per Supplier
$20,000
📋
Efficiency Benchmarks
Score
Level
> 85%
Excellent
70% - 85%
Good
50% - 70%
Average
< 50%
Needs Improvement
📐
Formula
Cost per Order = Total Spend / Number of Orders
Cost efficiency metric
Orders per Staff = Orders / Staff
Efficiency = (Cost/Order Score + Orders/Staff Score + Cycle Time Score + Supplier Score) / 4
Higher efficiency = better procurement performance
📋
Efficiency Guide
- 1 Enter total spend and orders
- 2 Set suppliers and cycle time
- 3 Enter procurement staff
- 4 Calculate efficiency metrics