Disaggregation rules

The way in which Enterprise Planning disaggregates the selected master-plan data to master plans of lower level plan items depends, among other things, on the disaggregation rule you specify in the Disaggregate Channel, Plans & Orders (cprmp2260m000) session.

Enterprise Planning supports the following types of disaggregation rules:

  • Disaggregate Percentage
  • Inventory Level
  • Capable to Promise
  • Pro Rate

Disaggregation rule: Disaggregate Percentage

The volume by period of the parent item is distributed over the child items based on the planning percentages defined in the aggregation relationships. This can result in more than 100% in total.

Example

Demand forecast of item A = 100 This demand forecast is disaggregated from A to A1, A2, and A3.

- A1 A2 A3
Planning percentage 75 45 30
Disaggregated volume 75 45 30

Disaggregation rule: Inventory Level

The volume by period of the parent item is distributed over the child items in a proportionate fashion, based on the difference between the inventory plan and the projected inventory.

This rule is typically used for disaggregating planned supply. The largest part of the planned supply is moved to the place where the inventory is relatively low. This optimizes the inventory levels.

Example

Production plan of item A = 100 This production plan is disaggregated from A to A1, A2, and A3.

- A1 A2 A3
Inventory plan 100 100 100
Projected inventory 25 55 70
Difference 75 45 30
Disaggregated volume 50 30 20
Note: If the value of the difference for A1 is negative or equal to zero, LN does not disaggregate planned supply to A1

Disaggregation rule: Capable-To-Promise

The volume by period of the parent item is distributed over the child items on the basis of the capable-to-promise (CTP) of the child items. Note that all types of CTP are supported and taken into account here. Also see the Related topics for more information about the capable-to-promise functionality.

Example

Production plan of item A = 100 This production plan is disaggregated from A to A1, A2, and A3.

Item A1 A2 A3
Capable-to-promise 75 45 30
Disaggregated volume 50 30 20

Note: If the value of Capable-to-promise for A1 is negative or equal to zero, LN does not disaggregate CTP to A1.

Disaggregation rule: Pro Rate The volume by period of the parent item is distributed over the child items on the basis of the existing values for the child items.

Example Inventory plan of item A = 100 This inventory plan is disaggregated from A to A1, A2, and A3.

Item A1 A2 A3
Existing inv. plan 75 45 30
Disaggregated volume 50 30 20

Disaggregation Rule: Pro rate

LN disaggregates the planning quantities in a proportional way, based on the current values in the item master plan. If sub-item 1 has the most in the current situation he will have the most after disaggregation.

The Pro rate disaggregation rule allows you to split planning data of a family plan item based on the original quantities of the underlying (individual) plan items. In this way the forecast data at item level can follow different trends for different items, such as steady for item A, increasing for item B, decreasing for item C in the example below. If the forecast quantity of the family item is modified, you can disaggregate the modified aggregated forecast data at family level back to item level based on the original forecast quantities at item level, as demonstrated in the chart in the following table.

Note: When LN disaggregates planning quantities from a normal item to the corresponding channeled items, all plans (production, and purchase), orders (production, purchase and distribution) and receipts (production, purchase and distribution) are disaggregated to the Allowed Demand field in the Channel Master Plan (cpdsp5130m000) session.

Example

The following table shows the forecast quantities of a family item and the sub-plan items A. B, and C in plan periods 1 to 5.

Plan period 1 2 3 4 5
Item A 10 10 10 10 10
Item B 5 7 9 11 13
Item C 14 13 12 11 10
Family item (aggregated) 29 30 31 32 33

The following table shows how LN disaggregates the forecast quantities according to the pro rate disaggregation rule if the forecast values of the family item change in plan period 3 and 4.

Plan period 1 2 3 4 5
Family item (modified) 29 30 36 38 33
Item A (pro rate)     11.61 11.87  
Item A (rounded)     12 12  
Item B (pro rate)     10.45 13.06  
Item B (rounded)     10 13  
Item C (pro rate)     13.94 13.06  
Item C (rounded)     14 13