Example of linear progression

LN uses the linear progression method to compute the average projected inventory levels. For this method, LN assumes that the inventory level changes from one plan period to the next in a linear fashion.

Example

Inventory on hand = 10

Plan period123
Length of plan period (days)225
Projected inventory level (at end of period)203099

 

In this example, LN assumes the following projected inventory figures for (the end) of the day:

Plan period123
Day123456789
Projected inventory1520253043.857.671.485.299

 

The starting point is the inventory on hand, which in this context assumes the role of projected inventory at the beginning of plan period 1 (that is, the plan period in which the current date falls). In this example, the quantity on hand is 10. In two days, this value rises to 20 (the projected inventory at the end of plan period 1). The assumption of linearity implies that the inventory at the end of day 1 lies halfway between 10 and 20.

In plan period 2, the situation is similar.

In plan period 3, there is a rise of 69 in 5 days. In this period, linearity implies that each day a rise of 13.8 is assumed.