Step 1: Determine Inventory on Hand Below is what we have in inventory at the present time according to the system. Company policy is to consider certain "Subinventaries" to be not-usable, so please include only 3 of them: CWIP, WSTR, INTRANSIT. Add together "On Hand" for those 3 "Subinventaries". Inventory On Hand: 10,502|| Locator Rec... Ini Org POS P09 POS P09 P09 Sub SALVAGE CWIP WSTR CYCOUNT INTRANSIT Item Item Description ... 12345 01 SHAFT-ECCENTRIC 12345-01 SHAFT-ECCENTRIC 12345-01 SHAFT-ECCENTRIC 12345-01 SHAFT-ECCENTRIC 12345 01 SHAFT-ECCENTRIC Pri... EA EA EA EA On-hand 5 1560 8778 18 164 EA Attributes Status Availability Step 2: Calculate Average Weekly Usage, based on forward-looking requirements "Gross Requirements" are how many of this item are needed to produce finished goods that use the item. Note that the time buckets are weeks. Suggestion: include 4 full weeks of data in the average. Average Weekly Usage: Horizontal Plan (FLR:P09 ) HP:0:ECT_AMR Current Preference: Default 11-SEP- * 12-SEP-2020:P:1 2020:P:0 12-SEP- 14-SEP- 21-SEP- . 2020:W:1 2020:W:2 2020:W:3 *28-SEP-2020:P:2 28-SEP. 05-OCT- 2020:W:4 2020:W:5 12-OCT- 2020:W:6 19-OCT- 2020:W:7 0 0 0 0 FLR P09 0 0 10-Spezi 0 4,849.0 0 0 Sales orders 0 Forecast 0 0 Gross requirements 0 Purchase orders 0 Requisitions 0 0 In Transit 0 Planned orders 0 Beginning on hand lo Projected available b... 0.0 b Safety stock 0.0 Current scheduled re... 0 Projected on hand 0.0 EMR B2B Forecast o 0 3,179.0 0 0 0 418.0 0 0 3,391.0 0 0 0 0 0 0 0 90.0 0 0 0 0 0 10.502.0 10,4120 9,000.0 0 10,4120 0 2,074.0 0 0 0 0 0 0 2.090.0 0 7,667,0 9.000.0 0 5.159.0 0 2.944.0 1.672.0 0 0 3,344.0 0 9.739.0 9.000.0 1,672.0 3,8870 0 0 0 2,890.0 0 0 0 2,926.0 0 9,059.0 9.000.0 0 -7.243.0 0 5,016.0 O 9.906.0 9.000.0 0 -962.0 0 7,651.0 9,000.0 0 2,508.0 0 9.023.0 9.000.0 0 -4,353.0 0 7.233.0 0 0 0 Pegging for 007-0464-00/FLR:P09 Qty 8778 on 12-SEP-2020 00:00:00 (On Hand) Step 3: Convert Average Weekly Usage to Average Daily Usage Assumption: The plant is working 5 days per week. Average Daily Usage: Step 4: Calculate Days On Hand for 12345-01 Inventory On Hand: Divided by Average Daily Usage: = Days on Hand: Step 1: Determine Inventory on Hand Below is what we have in inventory at the present time according to the system. Company policy is to consider certain "Subinventaries" to be not-usable, so please include only 3 of them: CWIP, WSTR, INTRANSIT. Add together "On Hand" for those 3 "Subinventaries". Inventory On Hand: 10,502|| Locator Rec... Ini Org POS P09 POS P09 P09 Sub SALVAGE CWIP WSTR CYCOUNT INTRANSIT Item Item Description ... 12345 01 SHAFT-ECCENTRIC 12345-01 SHAFT-ECCENTRIC 12345-01 SHAFT-ECCENTRIC 12345-01 SHAFT-ECCENTRIC 12345 01 SHAFT-ECCENTRIC Pri... EA EA EA EA On-hand 5 1560 8778 18 164 EA Attributes Status Availability Step 2: Calculate Average Weekly Usage, based on forward-looking requirements "Gross Requirements" are how many of this item are needed to produce finished goods that use the item. Note that the time buckets are weeks. Suggestion: include 4 full weeks of data in the average. Average Weekly Usage: Horizontal Plan (FLR:P09 ) HP:0:ECT_AMR Current Preference: Default 11-SEP- * 12-SEP-2020:P:1 2020:P:0 12-SEP- 14-SEP- 21-SEP- . 2020:W:1 2020:W:2 2020:W:3 *28-SEP-2020:P:2 28-SEP. 05-OCT- 2020:W:4 2020:W:5 12-OCT- 2020:W:6 19-OCT- 2020:W:7 0 0 0 0 FLR P09 0 0 10-Spezi 0 4,849.0 0 0 Sales orders 0 Forecast 0 0 Gross requirements 0 Purchase orders 0 Requisitions 0 0 In Transit 0 Planned orders 0 Beginning on hand lo Projected available b... 0.0 b Safety stock 0.0 Current scheduled re... 0 Projected on hand 0.0 EMR B2B Forecast o 0 3,179.0 0 0 0 418.0 0 0 3,391.0 0 0 0 0 0 0 0 90.0 0 0 0 0 0 10.502.0 10,4120 9,000.0 0 10,4120 0 2,074.0 0 0 0 0 0 0 2.090.0 0 7,667,0 9.000.0 0 5.159.0 0 2.944.0 1.672.0 0 0 3,344.0 0 9.739.0 9.000.0 1,672.0 3,8870 0 0 0 2,890.0 0 0 0 2,926.0 0 9,059.0 9.000.0 0 -7.243.0 0 5,016.0 O 9.906.0 9.000.0 0 -962.0 0 7,651.0 9,000.0 0 2,508.0 0 9.023.0 9.000.0 0 -4,353.0 0 7.233.0 0 0 0 Pegging for 007-0464-00/FLR:P09 Qty 8778 on 12-SEP-2020 00:00:00 (On Hand) Step 3: Convert Average Weekly Usage to Average Daily Usage Assumption: The plant is working 5 days per week. Average Daily Usage: Step 4: Calculate Days On Hand for 12345-01 Inventory On Hand: Divided by Average Daily Usage: = Days on Hand
