Buying Patterns in Volumes/Trade Spends Planning 

Use

You can use volumes/trade spends planning to include a customer's buying pattern. A buying pattern determines how much a customer typically buys over a particular period of time. It is described in the section Marketing-Specific Customer Defaults.

 

If you do not make any settings for customer defaults, the buying pattern is distributed equally.

Prerequisites

In Customizing for Marketing Planning and Campaign Management, you have entered a period type and set the buying pattern indicator by choosing Basic Data ® Define Additional Date Ranges. The additional dates that you defined are then included in the buying pattern and transferred to Business Planning and Simulation (BPS) together with the plan dates.

Example

As a default, a buying pattern starts on a Monday. In the following example, however, the buying pattern starts on a Wednesday. The table below shows how this affects planning.

The example is based on a working week of seven days and a buying pattern of two weeks. In the first week, the customer wants to buy 40%, in the second week 60%, the total number of items being 100. If the buying pattern started on a Monday, that would be 40 items in the first week and 60 in the second.

If the buying pattern starts on a Wednesday, the planning is as follows for the same amounts:

Calendar Week	Formula for Calculating Buying Pattern	Comments
CW1	4/7 x 40% x 100	As the buying pattern starts on a Wednesday, this is not a full week, and the system only calculates 4/7 of the total.
CW2	3/7 x 40% x 100 4/7 x 60% x 100	The system takes the remainder of the calendar week that already started followed by the first part of the following calendar week.
CW3	3/7 x 60% x 100	The system calculates the remainder.