OTB: What to Plan (SAP Library)

OTB: What to Plan

Each line in a planning type represents a key figure. Planning types OTB_VP, OTB_VPOM, and OTB_EPOM have the key figures explained below. Planning types OTB_%, OTB_%_VPOM, and OTB_%_EPOM have the same key figures, the only difference being that you enter planned closing stock, planned mark-downs, and planned inventory differences as percentages.

Note

Many of the key figures are calculated automatically by a predefined macro.

· Invoiced sales

You can forecast values for this key figure on the basis of actual data. Alternatively, you can enter values manually. Actual invoiced sales are displayed in the line below.

· Sales volume margin

You enter the desired margin for planning purposes here.

· Closing stock

Opening stock levels can be calculated automatically (see OTB: Opening Stock ). Whether they are calculated automatically or entered manually, you can display them in the zero column. You enter the other planning values on this line yourself.

If you want to build up stock before the selling commences, the planning horizon must contain periods in which only the key figure "closing stock" is planned.

A predefined macro calculates the percentage key figure for closing stock automatically on the basis of the sales price values you have entered.

Note

The opening stock level for a particular season (for example, spring 1997) is the closing stock level from the previous year’s season (spring 1996).

· Mark-downs

Here you enter the value of goods marked for selling at a reduced price. Actual mark-downs are displayed in the line below.

The percentage key figure for mark-downs is calculated automatically on the basis of the sales price values you have entered.

· Inventory differences

The planning values you enter for this key figure might include stock adjustments made for deterioration and theft. Actual inventory differences are displayed in the line below.

The percentage key figures for inventory differences is calculated automatically on the basis of the sales price values you have entered.

· Seasonal budget

A predefined macro calculates this planning value as follows in each period:

planned closing stock - planned opening stock + planned invoiced sales
+ planned inventory differences + planned markdowns

· Initial purchasing quota

Here you enter the percentage of the seasonal budget that is to be available for immediate use.

· Released budget

This is the budget that is immediately available. The system calculates it automatically on the basis of the initial purchasing quota you have entered.

· Reserve budget

A predefined macro calculates this planning value as follows in each period:

seasonal budget - released budget

· Open-to-buy for seasonal budget

This is the difference between the seasonal budget and actual commitments or data.

– A predefined macro calculates this planning value in each future period as follows:

planned closing stock - planned opening stock + planned invoiced sales
+ planned inventory differences + planned markdowns
- actual open purchase orders
- actual open stock transfer orders (receiving site)
+ actual open stock transfer orders (delivering site)

– A predefined macro calculates this planning value in each current period as follows:

planned closing stock - actual opening stock ** + planned invoiced sales
+ planned inventory differences + planned markdowns
- actual open purchase orders
- actual open stock transfer orders (receiving site)
+ actual open stock transfer orders (delivering site)
+ (extrapolated invoiced sales* - planned invoiced sales)
+ max. (actual inventory differences - planned inventory differences, 0)
+ max. (actual mark-downs - planned mark-downs, 0)
+ (actual goods issues - actual invoiced sales - actual price reductions - actual inventory differences - actual mark-downs)
- actual goods receipts

* A predefined macro calculates extrapolated invoiced sales in the current period as follows, where the number of sales days is calculated with reference to the factory calendar defined for the site:

actual invoiced sales x (number of sales days/number of past sales days)

A user exit is available for you to define your own calculation for extrapolated invoices sales.

** A predefined macro calculates the actual closing stock for the previous periods as follows:

actual opening stock + actual goods receipts - actual goods issues.

– Open-to-buy for a period in the past is 0.

· Open-to-buy for budget already released

This is the difference between the budget already released and actual commitments or data.

A predefined macro calculates this planning value in each future period as follows:

(planned closing stock - planned opening stock + planned invoiced sales
+ planned inventory differences + planned markdowns) x initial purchasing quota
- actual open purchase orders
- actual open stock transfer orders (receiving site)
+ actual open stock transfer orders (delivering site)

A predefined macro calculates this planning value in each current period as follows:

(planned closing stock - actual opening stock + planned invoiced sales
+ planned inventory differences + planned markdowns) x initial purchasing quota
- actual open purchase orders
- actual open stock transfer orders (receiving site)
+ actual open stock transfer orders (delivering site)
+ (extrapolated invoiced sales - planned invoiced sales)
+ max. (actual inventory differences - planned inventory differences, 0)
+ max. (actual mark-downs - planned mark-downs, 0)
+ (actual goods issues - actual invoiced sales - actual price reductions - actual inventory differences - actual mark-downs)
- actual goods receipts

Open-to-buy for a period in the past is 0.

· Average price band price

This is the average price in a particular price band. It is defined in Customizing and is one of the operands in a predefined macro that automatically converts the sales price key figures into quantities. For more information, see OTB: Average Price Band Prices .