Example: Days of Supply Calculation

For the days of supply calculations, the system uses the data in the Planning Details Supply/Demand Worktable table (F34X200W). For supply information, the F34X200W table is populated with data from the Purchase Order Detail File table (F4311) or the Work Order Master File table (F4801), starting with the oldest active order. The system retrieves inventory information from the Item Location File table (F41021) or the Lot Master table (F4108), and demand information from the Sales Order Detail File table (F4211), starting with the oldest active order. Calculations for the number of days until the first receipt and number of days until the second receipt of material start on the planned start date that you define as part of the Planning Console program (P34X200) processing options.

Note: The system uses calendar dates for the days of supply calculations. For calendar dates, a week starts on Sunday and ends on Saturday, and a month ends on the last day of the month.

The following examples show how the system calculates the number of days of supply based on whether past due supply is included in or excluded from the on-hand quantity.

Example 1

This example uses the following data:

The Past Due Supply Quantity processing option for the Planning Console program (P34X200) is set to 1 to include past due supply in the on-hand quantity.
The planning start date is February 18.

Day	On Hand	Demand	Inventory On Hand	Days of Supply - Current	Days Until 1st Receipt	Days After 1st Receipt	Days Until 2nd Receipt	Days After 2nd Receipt
	250		green circle	2	1 - green circle	5	5 - yellow triangle	25
Feb 18		100		150		150		150
Feb 19		100		50	280	330		330
Feb 20		100		-50		230		230
Feb 21		100				130		130
Feb 22		100				30		30
Feb 23		100				-70	830	760
Feb 25		300						460
Feb 28		250						210
Mar 1		75						135
Mar 8		100						35
Mar 15		100						-65
Mar 22		100
Mar 29		100

Example 2

This example uses the following data:

The Past Due Supply Quantity processing option for the Planning Console program (P34X200) is set to 1 to include past due supply in the on-hand quantity.
The planning start date is February 25.

Day	On Hand	Demand	Inventory On Hand	Days of Supply - Current	Days Until 1st Receipt	Days After 1st Receipt	Days Until 2nd Receipt	Days After 2nd Receipt
	250 + 1110		green circle	18	-6 - green circle	-2	-2 - yellow triangle	18
Feb 18		100		1260		150		150
Feb 19		100		1160	280	330		330
Feb 20		100		1060		230		230
Feb 21		100		960		130		130
Feb 22		100		860		30		30
Feb 23		100		760		-70	830	760
Feb 25		300		460				460
Feb 28		250		210				210
Mar 1		75		135				135
Mar 8		100		35				35
Mar 15		100		-65				-65
Mar 22		100
Mar 29		100

Example 3

This example uses the following data:

The Past Due Supply Quantity processing option for the Planning Console program (P34X200) is set to 1 to include past due supply in the on-hand quantity.
The planning start date is February 21.

Day	On Hand	Demand	Inventory On Hand	Days of Supply - Current	Days Until 1st Receipt	Days After 1st Receipt	Days Until 2nd Receipt	Days After 2nd Receipt
	250 + 280		green circle	2	-2 - green circle	2	2 - yellow triangle	22
Feb 18		100		430		150		150
Feb 19		100		330	280	330		330
Feb 20		100		230		230		230
Feb 21		100		130		130		130
Feb 22		100		30		30		30
Feb 23		100		-70		-70	830	760
Feb 25		300						460
Feb 28		250						210
Mar 1		75						135
Mar 8		100						35
Mar 15		100						-65
Mar 22		100
Mar 29		100

Example 4

This example uses the following data:

The Past Due Supply Quantity processing option for the Planning Console program (P34X200) is blank to exclude past due supply from the on-hand quantity.
The planning start date is February 18.

Day	On Hand	Demand	Inventory On Hand	Days of Supply - Current	Days Until 1st Receipt	Days After 1st Receipt	Days Until 2nd Receipt	Days After 2nd Receipt
	250		green circle	2	1 - green circle	5	5 - yellow triangle	25
Feb 18		100		150		150		150
Feb 19		100		50	280	330		330
Feb 20		100		-50		230		230
Feb 21		100				130		130
Feb 22		100				30		30
Feb 23		100				-70	830	760
Feb 25		900						460
Feb 28		250						210
Mar 1		75						135
Mar 8		100						35
Mar 15		100						-65
Mar 22		100
Mar 29		100

Example 5

This example uses the following data:

The Past Due Supply Quantity processing option for the Planning Console program (P34X200) is blank to exclude past due supply from the on-hand quantity.
The planning start date is February 25.

Day	On Hand	Demand	Inventory On Hand	Days of Supply - Current	Days Until 1st Receipt	Days After 1st Receipt	Days Until 2nd Receipt	Days After 2nd Receipt
	250		red square	0	no receipt	0	no receipt	0
Feb 18		100		150		150		150
Feb 19		100		50	280	50		50
Feb 20		100		-50		-50		-50
Feb 21		100
Feb 22		100
Feb 23		100					830
Feb 25		300
Feb 28		250
Mar 1		75
Mar 8		100
Mar 15		100
Mar 22		100
Mar 29		100

Example 6

This example uses the following data:

The Past Due Supply Quantity processing option for the Planning Console program (P34X200) is blank to exclude past due supply from the on-hand quantity.
The planning start date is February 21.

Day	On Hand	Demand	Inventory On Hand	Days of Supply - Current	Days Until 1st Receipt	Days After 1st Receipt	Days Until 2nd Receipt	Days After 2nd Receipt
	250		red square	0	2 - red square	7	no receipt	7
Feb 18		100		150		150		150
Feb 19		100		50		50		50
Feb 20		100		-50		-50		-50
Feb 21		100				-150		-150
Feb 22		100				-250		-250
Feb 23		100			830	480		480
Feb 25		300				180		180
Feb 28		250				-70		-70
Mar 1		75
Mar 8		100
Mar 15		100
Mar 22		100
Mar 29		100