Entering content frame

This graphic is explained in the accompanying text Values of Row 1 Shift by Offsets in Row 2 Locate the document in its SAP Library structure

A demand planner has finished planning demand for the finished product in the given horizon and is interested in finding the demand for dependent components. One unit of component 1 is required to make one unit of the finished product; and under normal circumstances the procurement lead time for component 1 is one month. In previous years, the supplier has been unable to meet the demand for component1 in May on time. Therefore, in order to meet the demand for the finished product in June, a lag of 2 months is required. The order for component1 must be placed in April.

In the macro, the month of April (column 4) for row 2 will contain a value of ‘2’ while other columns of this row will contain a value of ‘1’. The macro shows the demand planner the period-dependent demand for component1.

Example: Demand for Finished Product and Component 1

 

January

February

March

April

May

June

Demand for Finished Product
(Row 1)

-

10

20

30

40

50

Offsets
(Row 2)

-

1

1

1

1

2

Demand for Component 1
(Row 4)

10

20

30

90

   

 

Leaving content frame