supplier evaluation 20061019

Bensberg GmbHSupplier Evaluation


Bensberg Enhancement Components

� EDI

� DELINS

� Deadline Splitting EDI

� External Service Agent (ESA)

� Orders / MAIS

� Credit Memo Procedure

� Payment Advice

� Application

� Supplier Evaluation MM

� Production Process Evaluation PP

� Delivery Performance SD

� Requirements Analysis MD04

� Open Quantities


Logistics Chain

Supplier Evaluation MM Production Process Evaluation PP Delivery Performance SD

MM =Material ManagementPP =Production & PlanningSD =Sales & Delivery


The Bensberg GmbH welcomes you to the

Presentation of the Enhancement Component

Supplier Evaluation

Welcome!


Overview

Evaluation

BacklogSpecial

evaluationoptions Quality

Defectiveparts

in PPM

Time/Quantity VDA and Percent

Service criterion

Goodsreceipts(GR)

Data pool with basis data and evaluation results

Analyses with active user interface:- Global analyses- Individual analyses

Modifications:- Revaluation- Evaluation‘Legacy data’

Totalevaluation

Data export forexternal systems

(SAP-BW)

Internetinterface(WEBGUI)

Modules are selectable


Evaluation of GR items according to time / quantity

� Starting point: Goods receipt posting in SAP-R/3

� automated saving of the information relevant for the evaluation by the

message determination (SAP-standard)

� According to VDA 5001 and Percent, separate evaluation of deadline and

quantity reliability, customer-specific solutions

� Flexible setting options of evaluation parameters

� e.g. according to supplier, plant, document type, MRP controller

� tolerances for deadline and quantity

� treatment of over- and underdeliveries

� Local service evaluations in respect to delivery performance

� Special treatment of delivery schedules

� Smoothing

GR items


Evaluation according to VDA

� Mutual evaluation of deadline and quantity:

GR items

29.3. 10010.4. 100

29.3. 120 29.3. 100 on time10.4. 20 7 days too early

� Determination of the VDA-key figure according to supplied schedule line

with simultaneous consideration of the proportional quantity and time

difference

� The higher the VDA-key figure the worse the delivery performance

Purchase document Delivery Assignment of the delivered quantity to the open quantities


Evaluation separately according to deadline and quantity reliability

� Deadline and quantity reliability are determined separately by considering

tolerances and afterwards a weighted, consolidated result is calculated.

Example:

GR-items

29.3. 10010.4. 100 29.3. 120

Purchase document Delivery Quantity evaluation in case of deviations of:

0% 100%1% - 10% 80%11% - 20% 60%from 21% 0%

Delivery reliability 100% Quantity reliability 60%

Delivery performance 80%Variable

weighting, here 50% / 50%



GRposting

real time

Saving of all relevant data

Data extraction and evaluation

Material document

Purchasing document

Repeat-Job

Evaluation GRaccording totime/quantity

Basis data

Evaluationparameters

Database tables

Evaluation results

Analysisprograms

Data export

Advantage: good performance, repeatability of the evaluation

GR items




� saving of environment data upon the goods receipt

� asynchronous evaluation

� According to VDA 5001 and Percent







� Smoothing

GR items


Supplier

Delivery

Delivery performance evaluation

Goods receipt:Thrusday 100 St.

Local service evaluations in respect to delivery performance

Goods receipts

GR items

Delivery

Delivery

Delivery

Supplier

Shipping instructions

VMI

Local service-criterion

Total result‘Delivery performance‘













� Smoothing

GR items


Delivery schedule (DS) treatment

Ship-to Party

Goods receiptThursday 100

Sold-to Party

Delivery schedule:Thursday 100

Supplier

Supply

Delivery schedule:Friday 80

on timedue to change:

on timeaccording tofirst DS

Evaluation

Monday:

changed on Wednesday:


VDA

0

DS 1 DS 2 DS 3 DS 4

Monday

DS 5

Wednesday

Time window

Goods receipt Thursday

VDA

2,00

VDA

0

Used delivery schedule

Delivery schedule treatment

� Definition of time windows (e.g. 1 week, 1 month,

number of days)

� Parallel evaluation of all delivery schedules within the

time window

� Usage of the most favorable delivery schedule for the

supplier

Punishment of the supplier will be avoided,

Further evaluation option:delivery schedule flexibility

Positive result, as the supplier was able to react on the last delivery schedule.













� Smoothing

GR items


Smoothing

GR items

Monday100 pcs.

Tuesday 100 pcs.

Schedule line

Goods receiptThursday 80 pcs.

Punishment due to underdelivery

Goods receiptMonday 120 pcs.

Punishment due to overdelivery

Offsetting of quantity deviations by means of time windows (number days),

alternatively with simulation

Time window

Goods receipt200 pcs.

Smoothing

Reliable in respect to time and quantity


Overview

Evaluation

Specialevaluationoptions Quality

Defectiveparts

in PPM


Service criterion

Goodsreceipts(GR)




Totalevaluation


(SAP-BW)


Backlog


Evaluation of backlog

� Determination of backlog at a defined point of time

� schedule lines of orders and scheduling agreements with schedule

line date < current date

� leads to a complete backlog view

� Evaluation like 'normal' GR

� regularly executed (optimal: daily) backlog evaluations

show the dynamical deterioration

� Histories of complete backlog viewsin preparation: Analysis of the backlog development of a supplier, with monitoring (alarm system)

and evaluation option

� Consideration of backlog evaluations in the analyses is selectable

Backlog


Evaluation of backlogs

Backlogcollector

Completebacklog view

Data extraction and evaluation

Purchasingdocument

Evaluation backlog according to time and quantity

Basis data

Evaluationparameters

Data base tables

Evaluationresult

Analysisprograms

Data export

Repeat Job

Backlog


Specialevaluationoptions

Overview

Evaluation

QualityDefective

partsin PPM


Service criterion

Goodsreceipts(GR)




Totalevaluation


(SAP-BW)


Backlog


Special evaluation options

� Evaluation of VMI, if necessary with data transfer from SupplyOn

� Evaluation of consignation goods with stock limits or determination of range

of coverage (according to requirements)

� Manual evaluations without goods receipt, e.g. external data. Posting with

independent user interface or by means of a released function module

� Customer-specific solutions, e.g. for the evaluation of KANBAN

(in hours in consideration of shift-times)

� Consideration of special evaluations in the analyses is selectable

Manual GR postings / KANBAN


Overview

Evaluation


Defectiveparts

in PPM

Service criterion

Goodsreceipts(GR)




Totalevaluation


(SAP-BW)


QualityBacklog



Evaluation of quality

� Starting point:

� Quality key figure of the usage decision

� Coding indicated in the quality message (with evaluation)

� At the moment of the analyses

� Independent key figure in %

� Local service evaluations for quality (analogous to delivery performance)

� Upload option from external systems (scheduled)

Quality


Overview

Evaluation


Service criterion

Goodsreceipts(GR)




Totalevaluation


(SAP-BW)


Backlog


Defectiveparts

in PPMQuality


Evaluation of defective parts in PPM (Parts per Million)

� Defective parts * 1.000.000 / total parts

� Control

� Quality message with filter options according to message type,

status, coding...

� Movement type / Movement reason

� Result as

� PPM figure – independent of the quantity unit

� PPM figure – according to quantity unit

� PPM figure in %

� PPM figure according to material

� PPM analysis with monitoring of target agreements

Defective parts


Delivery Return delivery Date Quantity PPM figure

Percentage target agreement

Evaluation of the defective parts in PPM (Parts per Million)

� Evaluation of the PPM figure for each movement (delivery/and return delivery)

(Defective parts* 1.000.000 / total parts at certain a particular time)


Overview

Evaluation


Goodsreceipts(GR)




Totalevaluation


(SAP-BW)


Backlog


QualityServicecriterion

Defectivepartsin PPM


Service criterion

Service criterion

� Evaluation according to free-definable criterion, as e.g.

� Certification

� Flexibility

� Friendliness (subjective criterion)

� Individual weighting of each criterion, global or e.g. definable according to

supplier (0-weighting � information)

� Evaluation in percent or according to a point system with internal conversion

into %

� Evaluation of a

� Supplier

� Supplier according to delivery plant

� Material document


Service criterion

Service criterion

� Evaluation by means of:

� Released function modules

Target: to use as far as possible the information existing in the R/3 or

external systems

� Independent user interface (also customer-specific) with maintenance

dialogue

� Monitoring of

� Authorizations

� Evaluation limits (Min-, Max- or fixed values)

� Number of evaluations (e.g. at most 2 but at least 1, with monitoring)

� Moment of evaluation (e.g. at the latest at 3rd working day, with monitoring)

� Independent key figure in %


Service criterion

Service criterion

� Bensberg function modules for

� Shipping instructions

� Price reliability

� Delivery schedule flexibility

� VMI if necessary with data transfer from SupplyOn

� Consignation with stock limits

� Consignation with range of coverage

� PPM costs (individual)

� Number of quality notifications (total and open)

� Global und local


Global and local service evaluations

GR items

Goods receipts

local Service evaluations

for delivery performance

Total result

Deliveryperformance

Total result

Supplier

Usage decisionsQuality notifications

localService evaluations

for quality

Total result

Quality

Total result

Service

globalService evaluations

Weighting

Shipping instructions

VMI

Reaction time toQuality notifications

Certification

Flexibility

Friendliness

The assignment GLOBAL or LOCAL can be changed dynamically at any time


Overview

Evaluation


Service criterion

Goodsreceipts(GR)





(SAP-BW)


Backlog


QualityTotal

evaluation

Defective partsin PPM


Total evaluationin %

Deliveryperformance

in %

A, B, C

e.g. weighting 5

Qualityin %

A, B, C

e.g. weighting 3

PPMin %

A, B, C

e.g. weighting 2

A, B, C - Classification

Total evaluation

Standard classification:A-classification, if >= 90%B-classification, if >= 75%C-classification, if < 75%

Servicein %

A, B, C

e.g. weighting 2

Recoding of evaluations- before total evaluation- after total evaluation


Overview

Evaluation


Service criterion

Goodsreceipts(GR)




(SAP-BW)


Backlog


QualityDefective

partsin PPM

Analyses with active interface:- global analyses- individual analyses

Totalevaluation


Analyses

� Individual analyses of each goods receipt position with all evaluation

bases

� Analysis according to supplier and month (cross table)

� Analysis according to supplier and material with ranking

� Analysis according to quantity and time

� ALV-analysis

� Information of the supplier by post, fax or E-Mail

� WEB-GUI-interface for the internet connection


Individual analysis

Analysis – Individual analysis


Individual analysis

Selection and sort keys

Further selection options can be activated

Only strategic suppliers

Choose sort key


Total evaluation for each sort key (here: supplier) within the selected period

Individual analysis

itemsinvolvedSort key

next slide

S-Kf = ServiceQ-Kf = QualityVDA = Delivery

performance


Overdelivery

Total evaluation (as before) with individual evaluation of all items involved

Document numbers (material, purchasing) + supplier are interactive (Hyperlinks to SAP-Standard)

GR

Manual

Backlog

Underdelivery

Evaluationbasisnext slide

Individual analysis

Analysis Service

Analysis PPM

VMI


VDA evaluation basis according to settings

Time difference in working days

2 = too late1 = too early

Individual analysis


Evaluation basis in case of separate evaluation of deadline and quantity

Individual analysis


Evaluation parameters and calculation

Individual analysis


open quantity prior to GR

Purchasing deadlines at the moment of the GR posting (basis deadline)

Individual analysis

open quantity after GR

red = overdelivered


green = most favorable DS

Activation can be changed (with immediate effect)

orange = active DS

Parallel evaluated delivery schedules within the time window

Individual analysis


Total evaluation (as before) with service analysis

next slide

Individual analysis

Service analysis


Service analysis – total overview

next slide

Individual analysis

Details for criterion


Service analysis - Detail for criterion

Individual analysis

Details for the result


Possibilityto enter comments

andto modify the evaluation

Individual analysis

Possibility to modify evaluations


Individual analysis

Only comment

Evaluation has been modified

Possibility to modify evaluations

Possibilityto enter comments

andto modify the evaluation

Upon clicking on a single result field, the dialog is

started


Total evaluation with individual evaluation of the items involved

Individual analysis

Filter-Download

change

changePossibility to enter comments +interactive option to change key figures (if so marked)

� Download / Excel

� Filter

� Graph

� Sort methods

� Remarks/Changes

� Hyperlinks

� User profile

Document number (material, purchasing department) + supplier are interactive (Hyperlinks)

Start chart


Cross table

ALV - Analyses (Advanced List Viewer)


Cross table

Analysis - Cross table


Global analysis

'Cross table':

Analysis per calendar yearand supplier according to month or week


'Cross table': Analysis according to calendar year and supplier

Globale Analyse

Goods receipts

context-depending individual analysis

nächste Folie

VDA-key figure

blank = no GR

Analysis options:

Example: Delivery performance according to VDA

Under preparation: 2 additional columns for the supplier

- Target value per month 'supplier development' per month- Deviation from target value with colored indication


Individual analysis based on cross table

Global analysis

items involved


Cross table

Analysis - Supplier and Material


to supplier

Parameters: Post, Fax, E-Mail

Management ordispatch filter

Objective:

� Information for the supplier

� Ranking Information for the

Management

Analysis according to supplier and material


Sort keys with ranking



next but one slide

Detailnext slide


Individual analysis


Analysis accordingto supplier and material


Dispatch to the supplier by Mail, Fax, or E-Mail

Dispatch by form:- Bensberg form- customer-specific form

When clicking on the magnifying glass in line 'Total' the weighted individual evaluations are displayed:


Supplier print out

This standard print out can be replaced by an own form.

A further standard print out is under preparation



Cross table

Analysis - Quantity and Time


Analysis according to quantity and time


Over-/and underdeliveries either in % or in quantity units

Objective target:

Presentation of quantity and

time deviations

Limit quantities, from which the display will be marked colored


Analysis quantity

Additional break down + evaluation according to material

individualanalysis



Analysis times

Sum of the schedule lines may exceed the sum of GR.



Analysis times with break down

Purchasing documents (orange)


Material documents (blue)


Alarm system

� Definition of limit values, e.g.:

� The percent evaluation of the supplier for delivery performance

falls below the limit value

� Supplier exceeds the PPM-target agreement

� Certification of the supplier expires

� Backlog has not been reduced as expected

� Development of the supplier is not satisfying.......

� The alarm system verifies the limit values and notifies the determined user by

internal SAP-Mail, by adding the respective analysis.


Overview

Evaluation

Manualevaluation

KANBANService criterion

Goodsreceipts(GR)



(SAP-BW)


Backlog


QualityDefective

partsin PPM

Totalevaluation

Modifications:- Revaluation- Evaluation‚Legacy data'

Analysis withactive interface:- Global analysis- Individual analysis


Modification of data pool

� Possibility to revaluate already evaluated items with modified

evaluation parameters

� Immediate adjustment of the evaluations in the individual analysis

� Post-evaluation of orders and scheduling agreements with delivery

schedules (old ones or imported data)

Modifications


Overview

Evaluation

Manualevaluation


Goodsreceipts(GR)



(SAP-BW)

Backlog


QualityDefective

partsin PPM

Totalevaluation



Modifications:-- Revaluation- Evaluation‚Legacy data'


Internet interface (WEBGUI)

� Independent WEBGUI interface

� Internet profile for supplier:

� Definition of the selection options

� Definition of possible evaluations (Delivery performance, Quality,

PPM, Service)

� Limitation of the period

� Application of the material number of the supplier so far maintained

Internet


Overview

Evaluation

Manualevaluation


Goodsreceipts(GR)


Backlog


QualityDefective

partsin PPM

Totalevaluation


Modifications:-- Revaluation- Evaluation‚Legacy data'


(SAP-BW)



Data export external systems as e.g. SAP-BW

� Provision of all analysis results in one separate extract transfer table

� For each evaluated item one data record (master data,

evaluation data with timestamp)

� Timestamps for topicality comparison

� Data extract report:

� Check, if new evaluations or modifications of evaluations are

available

� Storage of extract data with new timestamp in extract table

� Download or direct access

� Analysis 'classical' and ALV

Data export to external systems


Evaluation data:

TablesBensberg

Repeat-Job

Extractreport

withModification

check

Master data:

TablesSAP

Table'Extract'

withTimestamp

List

Download / Excel

SAP-BW

Data export for external systems as e.g. SAP-BW

Overview

Data export to external systems


Embedding of the Bensberg component in the SAP R/3

� Add-on to R/3

� Programmed in "ABAP" (Advanced Business and Application

Programming)

� Own, name range (/BEE/) assigned from SAP

� Thus no no interventions in R/3, but access on R/3-data

� Able to run under R/3-Releases 4.0 - 4.7 with or without

Automotive

� Automatic generation via SAP standard transport

� Language versions: D, E, F, ES


Posthof 2

D-53783 Eitorf

Germany

Bensberg Consulting GmbH

Phone:

Fax:

0049 (0)2243 83822

0049 (0)2243 80502

www.bensberg.de

[email protected]

We thank very much you for your time and interest.

If you still have questions and/or need further information

please don't hesitate to contact us.

supplier evaluation 20061019

Documents