Management Vendor Service Levels 
Use
Use this program to calculate and manage vendor service levels. This includes:
· Display of vendor service levels on the database and those calculated by the system
· Deletion of existing vendor service levels
· Calculation of new vendor service levels
The vendor service level indicates the percentage of the maximum potential sales (forecast) that a goods recipient (a plant or a store) can achieve with the quantity of material available from the vendor. This figure is an important criterion in the load building functions. It defines which articles and quantities are included by the system in the purchase order.
The vendor service level is calculated by the system using the vendor service level for individual articles.
Procedure
...
Start the vendor service level tool by selecting Purchasing ® Purchase Order ® Environment ® Service Level by Vendor. You can enter the following parameters:
Vendor (multiple vendors can be selected)
In addition to selecting the vendor, you can limit the selection of vendors for load building. Do this by selecting Vendors for Load Building Only. This limitation only influences the calculation of new data. A vendor for load building is a vendor for which a restriction profile has been created in the system.
Purchasing organization (multiple organizations can be selected)
Site (multiple sites can be selected)
Actions to be run by the system
The program can be run directly or in the background.
The vendor service level tool runs the following actions in the following sequence:
Display existing data (if selected in step 1)
The system displays all data that is valid within the date interval entered in step 1. If the interval limits do not contain any data, the system selects the largest possible interval (01.01.0000 to 31.12.9999.)
Deletion of existing data and display deleted data (if selected in step 1)
The system deletes all data that is older than the date entered on the selection screen. The check is run based on the to-date in the validity period.
Calculation of the new vendor service levels and store/display (if selected in step 1)
Data is calculated for each load building combination, consisting of one vendor and an appropriate site. Before a load building combination can be created, the same purchasing organization must be valid for both the vendor and the site concerned.
The system enters all messages generated during the program run in a message list.
The system displays the results using the ABAP List Viewer.
Data is always processed in the sequence detailed in step 3. It may be the case that existing data is displayed although the data was previously deleted in step 2 or that data has been deleted that has been recalculated in the following step.
If you want to see the messages that were displayed when data was last processed, select Message List in the selection screen or in the output screen.
Example
|
|
Article 1 |
Article 2 |
Article 3 |
Total |
|
Price |
EUR 4.00 |
EUR 4.00 |
EUR 0.40 |
|
|
Warehouse stock |
200 |
400 |
0 |
|
|
Forecast value |
400 |
800 |
0 |
|
|
Date ordered |
08.10. |
08.10. |
08.10. |
|
|
Delivery date |
11.10. |
11.10. |
11.10. |
|
|
Number of working days |
1 |
1 |
1 |
|
|
Available stock (M) |
1200 |
400 |
0 |
|
|
Sales quantity (V) |
400 |
800 |
0 |
|
|
Lost future business volume (EU) |
EUR 0.00 |
EUR 1600.00 |
EUR 0.00 |
EUR 1600.00 |
|
Future business volume (U) |
EUR 1600.00 |
EUR 3200.00 |
EUR 0.00 |
EUR 4800.00 |
|
Possible business volume (MU) |
|
|
|
EUR 3200.00 |
|
Vendor service level |
|
|
|
66,7% |
The individual values can be calculated as follows:
· Delivery date:
Order data plus the planned delivery time estimated by the vendor. This is one working day.
· Available stock (M):
Total warehouse stock and on-order stock.
· Sales quantity (V):
Result of forecast values and number of working days.
· Lost future business volume (EU):
If V – M < 0:
EU = 0
If this is not the case:
EU = (V – M) ´ price
· Future business volume (U):
Result of sales quantity and the price.
· Possible business volume (MU):
Difference of future sales (U) and lost future business volume (EU).
· Vendor service level:
Quotient from possible business volume (MU) and future sales (U).