Supplier Delivery performance template

have you got any ideas or draft sheets you can provide

How are you capturing the data to summarise ?

whats important for you on supplier performance - make a list of metrics you would like to measure the suppliers against
then look at the information you have supplied and find if there are any gaps and what you can measure

if you setup the data sheet as a table
then you can add to the data and pivot
Also you can add formulas and automatically copy those down

so for

Quantity delivered is the quantity requested or is it a short delivery

you can add a formula for calculating a % performance - by adding a 1 if short delivery
then you can simply do a count and sum to calc a % in the sheet
or just a simple count

I also want to add thing like is it in correct packaging etc

same again - but you need to capture that information

Want to measure PPM (Parts per million)

can you explain ?

Also want to be able to give the supplier a score rating on performance i.e. 10 being excellent and 1 being poor

you could setup a table with the criteria for each value 1 - 10
and then use a lookup to add up points for each test and even weight those metrics if necessary

the data you have provided needs to be expanded to collect all the information you require
also you could use the received date as the criteria for reporting against or someother factor that indicates you have all the data received and can therefore report on that supplier

does that help

It is unclear what you mean by "Delivery Performance" but this is my best guess for now:
With the suppliers listed in L2:L6, Orders in M2:M6, Qty Due in N2:N6, Reveived in O2:O6, Performance in P2:P6 this is what I came up with
Orders:

Formula:

=COUNTIF($D$2:$D$18,L2)

Qty Due:

Formula:

=SUMIF($D$2:$D$18,L2,$H$2:$H$18)

Received:

Formula:

=SUMIF($D$2:$D$18,L2,$I$2:$I$18)

Performance:

Formula:

=O2/N2

All formulae entered in row 2 in the appropriate column and filled down:

Result:

	L	M	N	O	P
1		Orders	Qty Due	Received	Performance
2	Dayang	1	400000	0	0.00%
3	FDUK	4	160000	0	0.00%
4	Locksure	6	1018400	338400	33.23%
5	U-Chance	2	200000	0	0.00%
6	Wisdom	4	25000	7000	28.00%

Your workbook with calculations and a Pivot Table example.