Show TOC

 Warehouse Space Savings Calculation

Use

During the cost-benefit analysis of the inventory balancing service, the system calculates the warehouse space savings (WSS) of a potential stock transfer for the issuing location. The WSS arise from the savings from the free-up of bins following a stock transfer of the inventory balancing quantity.

Prerequisites

You have assigned a WSS storage type to the location product in the location product master data. For more information, see the Implementation Guide (IMG), under Start of the navigation path Advanced Planning and Optimization Next navigation step Supply Chain Planning Next navigation step Service Parts Planning (SPP) Next navigation step Inventory Balancing Next navigation step Define Warehouse Space Savings Storage Type End of the navigation path .

Features

The system calculates the WSS according to the following formula:

WSS = S x savings per free-up of a bin x number of free-ups of a bin

  • The factor S depends on the warehouse utilization as follows:

    • If the warehouse utilization is less than or equal to X, S = 0.

    • If the warehouse utilization is greater than X but less than or equal to Y, S = V.

    • If the warehouse utilization is greater than Y, S = Z.

      X and Y are the WSS factor limits 1 and 2.You can enter these WSS factor limits in percentages on the SAP Easy Access menu, by choosing Start of the navigation path Advanced Planning and Optimization Next navigation step Service Parts Planning (SPP) Next navigation step Planning Next navigation step Deployment and Inventory Balancing Next navigation step Warehouse Space Savings Profile End of the navigation path .

      V and Z are the WSS factors 1 and 2. You can also enter these WSS factors on the Warehouse Space Savings Profile screen.

      The system chooses the WSS profile that is assigned to the excess location of the relevant location product in the location product master data on the SPP tab page in the Warehouse Space Savings (WSS) Profile field.

  • You enter the warehouse utilization and the savings per free-up of a bin on the SAP Easy Access menu, by choosing Start of the navigation path Advanced Planning and Optimization Next navigation step Service Parts Planning Next navigation step Planning Next navigation step Deployment and Inventory Balancing Next navigation step WSS Storage Types per Location End of the navigation path . The system chooses the WSS storage type that you specified for the product and the excess location of the corresponding location product in the location product master data on the SPP Inv. Balancing/Surplus tab page in the WSS Storage Type field.

    Importing Data

    You can also import data from a spreadsheet table ( Microsoft Excel for example). To do this you create a spreadsheet table with columns like those that are specified on the WSS Storage Type per Location screen.

    Note Note

    For the system to import the data correctly, it is important that you create the columns in the same sequence as in the table on the WSS Storage Type per Location screen. Furthermore, the system can only completely import the data if you fill all fields.

    End of the note.

    If you want to add a product to the selection, you must enter i (for include) in the indicator for selection change in the spreadsheet table. If you want to remove a product from the selection, you must enter e (for exclude). The system cannot import other entries.

    Save the table as a CSV file. You can now import this CSV file from the WSS Storage Type per Location screen. So that the system can import your table, you must make the following settings on this screen:

    • Choose whether you want to import the table in simulation mode. You can see the results of the import in the simulation mode but you cannot make any changes.

    • In the CSV File Column Separator field specify the sign that separates the values in the CSV file; this is often a semicolon (;).

    • In the CSV File: First Data Row specify which row of your table contains the first import-relevant data. If, for example, you have entered titles in the first row of your table, specify 2 in this field, so that the system imports all data as of the second row.

    • In the CSV File: First Data Column specify which column of your table contains the first import-relevant data.

    • In the Change Mode field, choose between A, R and D .

      If you choose A , the system only overwrites the selections that already existed before the import, and adds new combinations that did not exist before the import.

      If you choose R , the system overwrites all your previous entries with the imported table.

      If you choose D, the system deletes all entries with the same key. Note that in this case only the columns in the tables that contain the key fields can be filled.

  • The system calculates the number of free-ups of a bin as follows:

    The system checks your entry in the location product master data on the SPP Inv.Bal./Surpl. tab page in the Prod./St.Bin field for the average quantity of product per storage bin.

    • If you have not made an entry in the Prod./St.Bin field or if your entry is zero, the system checks whether the stock transfer has reduced the entire stock to zero. If this is the case, the system sets the number of free-ups of a bin to 1. If this is not the case, the system sets the number of free-ups of a bin to zero.

    • If the entry in the Prod./St.Bin field is greater than zero, the system calculates the number of free-ups of a bin according to the following formula:

      Number of free-ups of a bin = inventory balancing quantity / average quantity of product per storage bin.