Show TOC

BackgroundWorkbook: Strategic Planning for 0WM

 

You can use the delivered strategic planning workbook to plan required employees for each warehouse for the next two months, using delivery items from the past. The example planning is performed at the level of version, calendar month/year, and warehouse number, and takes into account the number of deliveries.

For its historical data, this example delivery extracts the number of deliveries per warehouse number of the last and current month from SAP Extended Warehouse Management (SAP EWM).

The data flow for loading the InfoCube containing the planning data is controlled by DataSource 0WM_PL_DLVI, which extracts delivery-item-related execution data from EWM. This data includes, for example, the storage types in which the deliveries were executed. Further on in the data flow, this data is enriched with other data from the delivery item.

You can create and perform your own plannings based on this data.

Prerequisites

  • You have loaded the data from the EWM system into InfoCube 0WM_C10.

  • You have switched InfoCube 0WM_C10, which contains the historical data, from loading mode to planning mode.

  • You have called the workbook for performing strategic planning.

Features

Start planning using the planning book: Initial Planning

After calling the planning book for the first time, choose Prepare Initial Data for Version 1. This fills the following values and displays them as planning data for version 1:

  • Number of Deliveries

  • Number of Deliveries per Employee

  • Number of Required Employees

Planning

  • The default value assumes that an employee processes 13 deliveries per month.

  • The required number of employees for a month is calculated using the formula Number of Deliveries / (Number of Deliveries per Employee). This formula is stored in the delivered planning functions. To calculate the required number of employees, you can also manually overwrite the number of deliveries per employee in the planning book, and calculate them as often as you require by choosing Calculate Number of Required Employees.

  • The following is displayed for each planning row:

    • Number of Deliveries

    • Number of Deliveries per Employee

    • Number of Required Employees

    You can perform simulations using the following fields:

    • Adjusted Number of Deliveries

    • Adjusted Number of Deliveries per Employee

    • Adjusted Number of Required Employees

  • You can use pushbutton Calculate Adjusted Number of Employees to calculate the adjusted number of employees as often as you require.

  • You can use the pushbutton Save All Data to save the displayed planning data in version 1.

  • To complete the planning, you can choose Copy Saved Data from Version 1 to Version 2 to copy the data saved in version 1 to version 2.

List of Planning Objects Delivered in the Standard System

  • InfoCube Strategic Planning — Planning Data (0WM_C10) with planning data

  • Aggregation level Aggregation for Planning (0WM_A10). This is delivered as a planning example for InfoCube (0WM_C10) that contains the planning data.

  • Filter 0WM Filter for Version 1 (0WM_A10_FIL01) and 0WM Filter for Version 2 (0WM_A10_FIL10)

The following planning functions:

  • 0WM Copy Version 0 to 1 for the Last 2 and Following 2 Months (0WM_A10_PF1)

  • 0WM Store Delivery Data in Adjused Delivery Data (0WM_A10_PF2)

  • 0WM Evaluate Number of Required Employees (0WM_A10_PF3)

  • 0WM Evaluate Number of Adjusted Required Employees (0WM_A10_PF4)

  • 0WM Copy Version 1 to Version 2 (0WM_A10_PF5)

Available planning sequences

0WM Prepare Initial Data for Version 1 (0WM_A10_PS1)

Workbook for planning

Strategic planning for 0WM

Available queries

Strategic Planning Results Version 1 (0WM_A10_Q001) and Strategic Planning Results Version 2 (0WM_A10_Q002)