| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Use case ID | Indicators document | Indicator | Use case | Use case subcategory | Fields needed | Methodology notes | ||||||||||||||||||
2 | UC003 | yes | Percent of tenders awarded by means of competitive procedures | Market Opportunity | Competition | ocid, tender/procurementMethod, awards/status | Number procedures awarded by competitive procedures/ all procedures *Consider ony tenders with tender/procurementMethod = open and exclude cancelled or unseccessful awards. | ||||||||||||||||||
3 | UC004 | yes | Total awarded value of tenders awarded by means of competitive procedures | Market Opportunity | Competition | ocid, tender/procurementMethod, awards/status, awards/value/amount, awards/value/currency | Procurement value awarded by competitive procedures/ all procurement value awarded *Consider ony tenders with tender/procurementMethod = open and exclude cancelled or unseccessful awards. | ||||||||||||||||||
4 | UC005 | yes | Proportion of single bid tenders | Market Opportunity | Competition | ocid, tender/procurementMethod, tender/numberOfTenderers OR tender/tenderers/id OR bids/details/tenderers/id | Count of tenders with a single bid / Total number of competitive tenders *Consider ony tenders with tender/procurementMethod = open. This indicator can be calculated using the tender/numberOfTenderers field or counting the number of unique tendereres by tender using the tenderers id. | ||||||||||||||||||
5 | UC006 | Proportion of value awarded in single bid tenders vs competitive tenders | Market Opportunity | Competition | ocid, tender/procurementMethod, tender/numberOfTenderers OR tender/tenderers/id OR bids/details/tenderers/id, awards/status, awards/value/amount, awards/value/currency | Value awarded in tenders with a single bid / Total value awarded in competitive tenders *Consider ony tenders with tender/procurementMethod = open and exclude cancelled or unseccessful awards. | |||||||||||||||||||
6 | UC007 | yes | Mean number of bidders per tender | Market Opportunity | Competition | ocid, tender/procurementMethod, tender/numberOfTenderers OR tender/tenderers/id OR bids/details/tenderers/id | Sum of the number of bidders/Total number of tenders or lots *Consider ony tenders with tender/procurementMethod = open | ||||||||||||||||||
7 | UC008 | yes | Median number of bidders per tender | Market Opportunity | Competition | ocid, tender/procurementMethod, tender/numberOfTenderers OR tender/tenderers/id OR bids/details/tenderers/id | Median count of all bidders / Total number of tenders *Consider ony tenders with tender/procurementMethod = open | ||||||||||||||||||
8 | UC009 | Mean number of bidders by item type | Market Opportunity | Competition | ocid, tender/procurementMethod, tender/numberOfTenderers OR tender/tenderers/id OR bids/details/tenderers/id, tender/items/classification/id, tender/items/classification/scheme, tender/items/description | For each item: Sum of the Number of bidders / Total tenders *Consider ony tenders with tender/procurementMethod = open | |||||||||||||||||||
9 | UC010 | yes | Number of suppliers by item type | Market Opportunity | Competition | awards/suppliers/id, awards/suppliers/name, awards/items/classification/id, awards/items/description, awards/items/classification/scheme | Count of unique suppliers by item | ||||||||||||||||||
10 | UC016 | yes | Mean number of unique suppliers per buyer | Market Opportunity | Competition | ocid, tender/procuringEntity OR buyer/name OR parties/identifier/id with parties/roles=buyer, awards/suppliers/id, awards/suppliers/name | Unique count of suppliers/ total number of procuring entities or buyers | ||||||||||||||||||
11 | UC025 | yes | Market concentration | Market Opportunity | Competition | awards/suppliers/id, awards/suppliers/name, awards/value/amount, awards/value/currency, awards/items/classification/id, awards/items/classification/scheme, awards/status | Market share = total value awarded to a supplier / total value awarded for the whole market HHI= Sum(market share^2) Markets can be segmented using the items classification ids. Exclude cancelled or unseccessful awards. | ||||||||||||||||||
12 | UC040 | yes | Average duration of tendering period (days) | Internal Efficiency | tender/id, tender/tenderPeriod/startDate, tender/tenderPeriod/endDate | For each tender calculate the Number of days between the tender start date and the end date. Then calculate the average duration. *this can be calculated separately for each procurement method and procuring entity | |||||||||||||||||||
13 | UC041 | yes | Average duration of decision period (days) | Internal Efficiency | ocid, tender/tenderPeriod/endDate, awards/date | For each tender calulate the number of days between the tender end date and the award date. Then calculate the average duration. *this can be calculated separately for each procurement method and procuring entity | |||||||||||||||||||
14 | UC042 | Average days from award date to start of implementation | Internal Efficiency | awards/id, awards/date, contracts/period/startDate, contracts/awardID | For each tender calulate the number of days between the award date and the contract start date. Then calculate the average duration. *this can be calculated separately for each procurement method and procuring entity | ||||||||||||||||||||
15 | UC043 | Days between award date and tender start date | Internal Efficiency | ocid, tender/tenderPeriod/startDate, awards/date | For each tender calulate the number of days between the award date and the tender start date. Then calculate the average duration. *this can be calculated separately for each procurement method and procuring entity | ||||||||||||||||||||
16 | UC044 | yes | Percent of canceled tenders | Internal Efficiency | tender/id, tender/status | Total number of cancelled tenders / Total number of awarded tenders | |||||||||||||||||||
17 | UC045 | Percent of canceled contracts | Internal Efficiency | contracts/id, contracts/status | Total number of cancelled contracts/ Total number of contracts | ||||||||||||||||||||
18 | UC051 | Percent of contracts completed on time | Internal Efficiency | contracts/id, contracts/period/endDate, contracts/status | Count of contracts completed on time / all contracts A contract is considered on time if it was terminated by the endDate. *Exclude cancelled contracts | ||||||||||||||||||||
19 | UC052 | Share of contracts whose milestones completed on time | Internal Efficiency | contracts/id, contracts/implementation/milestones/dueDate, contracts/implementation/milestones/dateMet | Count of contracts with milestones completed on time / all contracts A contract is considered on time if it was completed if the dateMet is <= that the due Date. | ||||||||||||||||||||
20 | Total number of unique bidders | Market Opportunity | Market Description | ocid, tender/tenderers/id OR bids/details/tenderers/id | Count of the total number of unique bidders. | ||||||||||||||||||||
21 | UC002 | yes | Total contracted value awarded under each procedure type | Market Opportunity | Market Description | ocid, tender/procurementMethod, contracts/id, contracts/status, contracts/value/amount, contracts/value/currency | Total value awarded by procedure /Total value awarded *Exclude cancelled contracts, calculate for local currency and USD. In case the contract value is not published, this indicator can be calculated using the 'awards/value/amount', 'awards/value/currency' fields. | ||||||||||||||||||
22 | yes | Total number of awarded suppliers | Market Opportunity | Market Description | awards/id, awards/suppliers/id, awards/suppliers/name, awards/status | Count of the total number of awarded suppliers. The count should exclude cancelled or unseccessful awards. The count should be made using the supplier id and name, however if there are typos in the name (different supplier names with the same id), the id should be prefered. | |||||||||||||||||||
23 | yes | Number of tenders by procedure type | Market Opportunity | Market Description | ocid, tender/procurementMethod | Total number of contracts by each pocurement method / Total of total contracts *Exclude cancelled contracts | |||||||||||||||||||
24 | Total value awarded | Market Opportunity | Market Description | awards/status, awards/value/amount, awards/value/currency | Sum of the total value awarded (local currency and USD). *exclude cancelled or unseccessful awards. | ||||||||||||||||||||
25 | yes | Total number of procedures | Market Opportunity | Market Description | ocid | Count of the total number of procedures | |||||||||||||||||||
26 | yes | Total number of procuring entities | Market Opportunity | Market Description | ocid, tender/procuringEntity OR buyer/name OR parties/identifier/id and parties/identifier/name with parties/roles=buyer | Count of the total number of procuring entities or buyers. | |||||||||||||||||||
27 | yes | Total number of procedures by year or month | Market Opportunity | Market Description | ocid, date | Count of the total number of procedures segmented by year and month. | |||||||||||||||||||
28 | Share of tenders by status | Market Opportunity | Market Description | ocid, tender/status | Total number of tenders by status / Total number of tenders | ||||||||||||||||||||
29 | yes | Number of procedures by item type | Market Opportunity | Market Description | ocid, tender/items/classification/id, tender/items/classification/scheme | Count of the total number of procedures by item type (using the item classification id) | |||||||||||||||||||
30 | yes | Number of tenders by procurement category | Market Opportunity | Market Description | tender/mainProcurementCategory | Count of the total number of procedures by procurement category | |||||||||||||||||||
31 | UC023 | yes | Success rate of bidders | Market Opportunity | Supplier performance | awards/suppliers/id, awards/suppliers/name, tender/tenderers/id OR bids/details/tenderers/id, tender/tenderers/name OR bids/details/tenderers/name | Calculated for each supplier: Count of number of awarded contracts of a supplier/ Count of total number of bids of a supplier | ||||||||||||||||||
32 | yes | Proportion of contracts awarded by supplier by non competitive procedures | Market Opportunity | Supplier performance | ocid, tender/procurementMethod, awards/status, awards/suppliers/id, awards/suppliers/name | This is calculated for each supplier: Total number of contracts awarded by open procurement methods / Total of total contracts awarded *Exclude cancelled contracts | |||||||||||||||||||
33 | Region of the supplier | Market Opportunity | Supplier performance | parties/roles, parties/identifier/id, parties/address/region OR parties/address/addressDetails/region | Calculated for each supplier: Region of the supplier | ||||||||||||||||||||
34 | Number of bids submitted by supplier | Market Opportunity | Supplier performance | awards/suppliers/id, tender/tenderers/id OR bids/details/tenderers/id | Calculated for each supplier: Sum of the total number of bids a supplier submitted | ||||||||||||||||||||
35 | Number of unique items classifications awarded by supplier | Market Opportunity | Supplier performance | awards/id, awards/suppliers/id, awards/suppliers/name, awards/items/classification/id, awards/items/classification/scheme | Calculated for each supplier: Count of the unique number of items awarded *Exclude cancelled or unseccessful awards. | ||||||||||||||||||||
36 | yes | Total value awarded by supplier | Market Opportunity | Supplier performance | awards/id, awards/suppliers/id, awards/suppliers/name, awards/status, contracts/id, contracts/awardID, contracts/value/amount, contracts/value/currency | Calculated for each supplier: Sum of the total value awarded (local currency and USD). *Exclude cancelled or unseccessful awards. | |||||||||||||||||||
37 | Share of total value awarded by supplier | Market Opportunity | Supplier performance | awards/id, awards/suppliers/id, awards/suppliers/name, awards/status, contracts/id, contracts/awardID, contracts/value/amount, contracts/value/currency | Calculated for each supplier: Sum of the total value awarded to a supplier/ Sum of the total value awarded (local currency and USD). *Exclude cancelled or unseccessful awards. | ||||||||||||||||||||
38 | yes | Total number of contracts awarded by supplier | Market Opportunity | Supplier performance | awards/id, awards/suppliers/id, awards/suppliers/name, contracts/status, contracts/id, contracts/awardID | Calculated for each supplier: Total number of contracts awarded *Exclude cancelled contracts | |||||||||||||||||||
39 | Number of procuring entities by supplier | Market Opportunity | Supplier performance | ocid, awards/suppliers/id, awards/suppliers/name, tender/procuringEntity OR buyer/name OR parties/identifier/id with parties/roles=buyer | Calculated for each supplier: Count of the total number of procuring entities or buyers for which a supplier won an award. | ||||||||||||||||||||
40 | yes | Share of single bid awards by supplier | Market Opportunity | Supplier performance | ocid, awards/suppliers/id, awards/suppliers/name, awards/status, tender/procurementMethod, tender/numberOfTenderers OR tender/tenderers/id | This is calculated for each supplier: Total number of awards awarded that received a single bid / Total number of competitive awards *Exclude cancelled awards, consider only open procurement method | |||||||||||||||||||
41 | UC046 | Price variation of same item across all awards | Value for Money | awards/id, awards/value/amount, awards/value/currency, awards/items/classification/id, awards/items/classification/scheme, awards/items/quantity, awards/items/unit | For the same item, unit and quantity calculate the unit price. Calculate the average and median price. Identify outliers | ||||||||||||||||||||
42 | UC047 | yes | Percent of contracts that exceed budget | Value for Money | ocid, contracts/status, contracts/value/amount, contracts/value/currency, planning/budget/amount/amount OR tender/value/amount, planning/budget/amount/currency OR tender/value/currency, awards/value/amount, awards/value/currency | Contracts with contract value > budget value / Total number of contracts *Exclude cancelled contracts | |||||||||||||||||||
43 | UC048 | yes | Mean percent overrun of contracts that exceed budget | Value for Money | ocid, contracts/status, contracts/value/amount, contracts/value/currency, planning/budget/amount/amount OR tender/value/amount, planning/budget/amount/currency OR tender/value/currency, awards/value/amount, awards/value/currency | Average total value overrun across all contracts with overruns *Exclude cancelled contracts | |||||||||||||||||||
44 | UC049 | Total percent savings (difference between budget and contract value) | Value for Money | ocid, planning/budget/amount/amount, planning/budget/amount/currency, contracts/id, contracts/status, contracts/value/amount, contracts/value/currency | Difference between budget value and contract value / Budget value *Exclude cancelled contracts | ||||||||||||||||||||
45 | UC050 | Total percent savings (difference between tender value estimate and contract value) | Value for Money | ocid, tender/value/amount, tender/value/currency, contracts/id, contracts/status, contracts/value/amount, contracts/value/currency | Difference between tender value and contract value / tender value *Exclude cancelled contracts | ||||||||||||||||||||
46 | |||||||||||||||||||||||||
47 | |||||||||||||||||||||||||
48 | |||||||||||||||||||||||||
49 | |||||||||||||||||||||||||
50 | |||||||||||||||||||||||||
51 | |||||||||||||||||||||||||
52 | |||||||||||||||||||||||||
53 | |||||||||||||||||||||||||
54 | |||||||||||||||||||||||||
55 | |||||||||||||||||||||||||
56 | |||||||||||||||||||||||||
57 | |||||||||||||||||||||||||
58 | |||||||||||||||||||||||||
59 | |||||||||||||||||||||||||
60 | |||||||||||||||||||||||||
61 | |||||||||||||||||||||||||
62 | |||||||||||||||||||||||||
63 | |||||||||||||||||||||||||
64 | |||||||||||||||||||||||||
65 | |||||||||||||||||||||||||
66 | |||||||||||||||||||||||||
67 | |||||||||||||||||||||||||
68 | |||||||||||||||||||||||||
69 | |||||||||||||||||||||||||
70 | |||||||||||||||||||||||||
71 | |||||||||||||||||||||||||
72 | |||||||||||||||||||||||||
73 | |||||||||||||||||||||||||
74 | |||||||||||||||||||||||||
75 | |||||||||||||||||||||||||
76 | |||||||||||||||||||||||||
77 | |||||||||||||||||||||||||
78 | |||||||||||||||||||||||||
79 | |||||||||||||||||||||||||
80 | |||||||||||||||||||||||||
81 | |||||||||||||||||||||||||
82 | |||||||||||||||||||||||||
83 | |||||||||||||||||||||||||
84 | |||||||||||||||||||||||||
85 | |||||||||||||||||||||||||
86 | |||||||||||||||||||||||||
87 | |||||||||||||||||||||||||
88 | |||||||||||||||||||||||||
89 | |||||||||||||||||||||||||
90 | |||||||||||||||||||||||||
91 | |||||||||||||||||||||||||
92 | |||||||||||||||||||||||||
93 | |||||||||||||||||||||||||
94 | |||||||||||||||||||||||||
95 | |||||||||||||||||||||||||
96 | |||||||||||||||||||||||||
97 | |||||||||||||||||||||||||
98 | |||||||||||||||||||||||||
99 | |||||||||||||||||||||||||
100 |