Family Data Implementation > Establishing Target Inventory Levels
  
Establishing Target Inventory Levels
Operations planning calculates global target inventory levels to support an item’s sales forecasts. In turn, it calculates production requirements based on target inventory levels.
If you do not specify otherwise, the system automatically sets each week’s target inventory level to zero. When set this way, you cannot build up inventory for future demands. You also cannot anticipate inventory shortages or surpluses.
To establish target inventory levels, define global weeks-of-coverage factors for minimum, average, and maximum target inventory levels. This method requires more implementation effort. However, it does support inventory buildup for upcoming sales forecasts.
Weeks of Coverage on Operations Plan illustrates how the system uses coverage factors on the family plan. In the example, the system uses an average cover factor of 2.0 to calculate the target inventory level.

Weeks of Coverage on Operations Plan
 
No.
Sales Forecast
Target Inventory
Production Due
Projected QOH
Coverage
1
0
500
500
500
2.0
2
300
700
500
700
2.0
3
200
500
0
500
1.0
4
500
0
0
0
0.0
When you change production due quantities on the plan, it uses the minimum (–) and maximum (+) factors to alert you to potential inventory shortages and surpluses relative to the average coverage level. This is illustrated in Weeks of Coverage on Operations Plan—Production Due Quantities Changed, which assumes a minimum coverage of 1.0 and a maximum of 3.0.

Weeks of Coverage on Operations Plan—Production Due Quantities Changed
 
No.
Sales Forecast
Target Inventory
Production Due
Projected QOH
Coverage
 
1
0
500
200
200
0.7
2
300
700
500
400
1.4
 
3
200
500
0
200
0.4
4
500
0
0
–300
0.0
Note: You can define coverage factors for either top-level family items or for end items. However, to prevent the system from inflating inventory, do not set up coverage factors for both levels or for intermediate subfamily levels.