Calculate Predicted Service Levels

Objective

After completing this lesson, you will be able to understand how to predict service levels.

Calculate Predicted Service Levels

Service levels are essential for inventory planning. On the one hand, this concerns the inputs, because planners need to specify the level of uncertainty to be covered by a safety buffer. On the other hand, inventory planning also results in an actual service level.

Knowing what actual service level can be achieved with a given level of stock will help the planner to make decisions during the planning process.

For this reason, the Planning Operator Service Level Prediction gives planners the ability to predict a service level for a given inventory plan.

For example, it is possible to estimate the impact of a manual adjustment on the service level that can actually be achieved.

Inventory Target as Input for Service Level Prediction

The input key figure Inventory Target can be used to adjust the inventory levels to your needs. After adjusting this key figure, you can run Service Level Prediction planning operator to calculate the output key figure Predicted Service Level based on this input. Beside Inventory Target, there are various other inputs used to calculate the resulting service level:

Overview Service Level Prediction Operator

Predict Service Levels

ExerciseStart Exercise

As inventory planner you would like to predict the resulting service levels. To do that we will work during this exercise with the connectionZIOUNIFIED within the Planning Area ZIOUNIFIED.

Prerequisites

Planning View used for this exercise: IO 220 Min Max Safety Stock ##
All previous exercises are prerequisites.
For this exercise we will work with the planning filter FG1##.
Use the filters within the planning view based on Macros to activate the Graphs.

Steps

Open favorite IO 220 Min Max Safety Stock ##. Add key figure IO Inventory Target to tab Detailed Results.
1. Log on into the SAP IBP, add-in for Microsoft Excel.
2. Open the planning view IO 220 Min Max Safety Stock ##.
3. In the section Planning View, use the option Edit View in the upper part of the Excel Window, and click on Edit Planning View... in the drop-down.
4. Filter by Planning Unit ## in the workbook filter section on the left.
5. Go to the Detailed Results tab.
6. Add the key figure IO Inventory Target Input to the tab Detailed Results. Please be aware that the planning area also contains the key figure inventory target. Here please select explicitly the key figure related to IO.
7. Confirm your changes by clicking on OK in the lower right corner of the Edit Planning View popup.
Run the Copy Operator Copy to Inventory Target.
1. Click on Copy Operator in the application jobs group.
2. Select Copy Recommended Safety Stock to Inventory Target.
3. A filter is not needed. Click on Next.
4. Choose EA in the Target UoM field.
5. Click on Run and click on OK to confirm that you have scheduled a job.
6. Select optionally a Reason Code and add a comment. Click on Run
7. Control the status of the copy operator to verify that the job is Finished.
8. Click on Refresh in the data input group.
9. Observe that the values from Recommended Safety Stock were copied to IO Inventory Target.
In favorite IO 220 Min Max Safety Stock ##, add key figure Predicted Service Level to tab HighLevel Results.
1. Edit the planning view by using the option Edit View in the upper part of the excel window.
2. Add the key figure Predicted Service Level to the tab HighLevel Results.
3. Confirm your changes by clicking on OK in the lower right corner of the Edit Planning View popup.
Execute planning operator Service Level Prediction.
1. Under Inventory Planning (Advanced), click on Run. Confirm all popups with OK if needed.
2. Select Service Level Prediction as Function and Planning Operator INVPROF_MINMAXSAFSTOCK_##
3. Select all planning units which correspond to your number ## with Planning Units: Brasil##, Europe##, India##, US## and Venezuela##.
4. Select Scenarios: Baseline, Versions: Base Version.
5. A filter is not needed. Click on Next.
6. Select as Reason Code: Inventory and add a comment Running Service Level Prediction if a reason code is requested.
7. Click on Run and click on OK to confirm that you have scheduled a job.
8. Watch the progress in the dialog box. When the run is finished, choose Navigate to Status to view the list of logs. Close to return to planning view.
9. Choose Refresh in the Data Input section.
10. Go to the current period.
11. Verify that Predicted Service Level contains values.
Change the format of key figure Predicted Service Level to enable visibility of decimal numbers.
1. Edit the planning view formatting by using the option Edit View → View Format in the upper part of the excel window.
2. Navigate to the tab IBPFormattingSheet.
3. Under Dimension Member/Property Formatting, click on Add Member/Property for rows.
4. Click on Condition, switch to tab Properties, select Key Figuresand choose in the drop down belowProperty the option ID.
5. Choose OperatorIs Equal To (=) and ValuePREDICTEDSERVICELEVEL and choose OK twice.
6. Right-click on the column Data for the entry created for predicted service level and choose option Format Cells....
7. Choose Category Number and select 3 decimal places.
8. Confirm your changes with OK.
9. Return to tab HighLevel Results and refresh using the Refresh option in the upper part of the excel window.
10. Validate that the number of decimal places is shown now properly for the key figure Predicted Service Level.
11. Optionally, you can hide the IBPFormattingsheet tab again by righ-clicking on it and choose Hide in the drop-down.
  Result
  Now you have seen how you can utilize the planning operator for service level predictions.

Next lesson

Calculate Predicted Service Levels