In addition to updated actual figures, planned figures from flexible planning can also be included in the open-to-buy standard analysis.

This key figure is calculated as follows during execution of the standard analysis :

The opening stock for the first planning period is calculated using what is known as stock initialization. Stock initialization is performed by a report which helps to determine and establish the opening stocks for a specific key date.

The planned opening stock is used as the initial stock at the start of planning. When the opening stock is calculated, all receipts and issues which have occurred from the start of planning up to the current period are added to the planned opening stock.

Open order volume in stock transport orders.

This key figure refers to the supplying plant and with reference to the ordering plant. It is updated on the delivery date.

The planned opening stock for each period corresponds to planned closing stock of the previous period. The so-called ‘stock initialization’ is used to determine the planned opening stock for the first planning period. The ‘stock initialization’ is a report which helps to determine and establish the opening stocks for a specific key date.

Planned closing stock per period.

Percentage of the seasonal budget already released for purchasing. The rest of the budget is reserved for later purchases.

The seasonal budget (purchasing budget) is calculated from the following elements:

• Planned sales volume
• Planned stock
• Planned markdowns
• Planned inventory differences

This budget is subdivided into a budget already released and a reserve budget. This subdivision is controlled by the initial purchasing quota. On the basis of the purchasing or seasonal budget and the budget already released, the key figure ‘open-to-buy’ is calculated and expressed in terms of two values (see below). In the standard analysis, the initial purchasing quota is required to calculate the OTB for the budget already released.

This key figure represents the main scope of the standard analysis of the same name. It tells you whether it is still possible to make further purchases or whether the stipulated purchasing volume has already been reached for the respective period. The system also calculates the budget still available as the difference between the planned budget and the expenditure that has already been reached.

The entire purchasing budget is made up from the partial budgets of more detailed planning levels. It is therefore possible to specify, for example, which budget is available for each merchandise category, price band, store, and so on.

The total budget defined for a planning level is split into a budget that has already been released and a reserve budget.

The budget already released is available to buyers for future periods, while the reserve budget is withheld to enable the organization to react to unforeseen trends in the short term.

Seasonal budget = Planned closing stock - Planned opening stock + Planned sales

Pre-order budget = Seasonal budget * Pre-order quota

Reserve budget = Seasonal budget - Pre-order budget

Actual closing stock = Actual opening stock + Actual receipts - Actual issues

Extrapolated sales = Actual sales * (Number of sales days / Number of past sales days)

The key figure ‘open-to-buy’ is calculated for the budget already released and for the seasonal budget that is still available for purchases, and is displayed in the standard analyses. The key figure ‘open-to-buy’ is always zero for a period in the past.