2006 grant w. howard company infor, inc (sx screens only) 1 “best practices” inventory...
TRANSCRIPT
![Page 1: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/1.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
1
“Best Practices” Inventory Management
Grant W. Howard
(734) 428-0529
www.gwhco.org
ICSR
ICSPICSD
ICSL
ICAMM
ICAR
ICAI
ICSW
WTERR
POERA
POERR
ICAMUWTERAICRIS
ICRIG
Sx EnterpriseSetting it Up, Getting Good Data , How to Use it, and How to Get Results
ICRIR
ICRIF
ICRIT
![Page 2: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/2.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
2
Sx.e - Getting Results Overview of the Replenishment Process How to Set it up, How to Use it, How to Get Results - 10 Steps:
– The Numbers:» Step 1: Parameters/Set up 9» Step 2: Data Accuracy 33» Step 3: Forecasting - OP, LP and EOQ 38» Step 4 : Stock Level Accuracy 42
– The Tools:» Step 5: Replenishment 47» Step 6: Timeline (Too Late and Too Early) 59» Step 7: Excess/Surplus Inventory 63
– Getting Better Results:» Step 8: Proactive Maintenance 71» Step 9: Monitoring and Measuring Results 91» Step 10: Controlled Replenishment 97
Final Thoughts
Through Step 8 Today. Steps 9 & 10 and Final Thoughts are Self Explanatory.
![Page 3: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/3.jpg)
3
Order Point:•Usage Buckets•Usage Method•Trending•Path/Roll up•LT Buckets•LT Method•Safety Method•OP AdjustersLine Point:•Target & Type•RC/OC/XF•Calc. or ManualEOQ:•“K” and “R” Cost•Min and MaxSurplus Points:•Internal (LP+EOQ)•External (X months)Misc:•Status•Freeze•Usage Method, Path•Replenishment MethodLevel:•On-hand•Committed•Incoming
Parameter Set-Up
Data Collection, Accuracy and Proper Use of Data
Forecasting
Stock Level Accuracy
Replenishment: When, What and How Much
Time Line: Too Late and Too Early
External Surplus
Maintenance
Measurement
Controlled Replenishment
To Be a Profitable Company Forever
Availability, BO Handling, Accuracy, OTD
Sales, Cogs, Freight, C to C, C to P
When to Replenish?
![Page 4: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/4.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
4
Inventory Manager/Buyer’s Day “Smart” Continuos Parameter Set Up -
Daily Data Collection, Accuracy and Proper
Use of Data - Daily Forecasting: Safety, Order Point, Line
Point, EOQ - Daily/Monthly Stock Level/PNA Accuracy - Daily
Replenishment: Worthy Items Below Order Point - Daily
Timeline Analysis:– “Too Late” Report - 2X/Week– “Too Early” Report - 2X/Week
Surplus Inventory - 1X/Week Proactive Maintenance - Daily
– Good Proof Reports for Start Up– While doing Replenishment– Good Exception Control Center– Information from Other Sources (Internal,
Customers and Vendors)
Monitoring and Measurement - Continuos Improvement
Controlled Replenishment - Critical
![Page 5: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/5.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
5
Inventory Management10 Step Process
The Numbers:1. Parameters/Setup:
– “Smart” - ICSR
– Company/Warehouse - ICSD
– Product Line - ICSL
– Product Master - ICSP
– Product Warehouse - ICSW
2. Data Collection:– Usage - OE/WT
– Lead Time - WT/PO
– Level: On-hand and Paperfloat - BIIS
– Purchasing History
3. Forecasting:– Rank - ICAI
– Replenishment Cycle - ICAR
– Usage, LT, Safety, Order Point, Line Point, Surplus Point, Order Quantity - ICAMM
4. Stock Level Accuracy:– On-hand - CC’s
– Paperfloat - BIIS
The Tools - Inventory Management:5. Replenishment:
– Use Priority Reporting - POERA– Purchases - POERR, POEAR– Transfers - WTERR, WTERA
6. Timeline Analysis:– “Too Late” - ICRIG– “Too Early” - ICRIG
7. Excess/Surplus:– Prevention– Disposition - ICRIS
The Tools - Getting Results:8. Proactive Maintenance:
– Proofs– While Replenishing - POERA– Exceptions and Mass Updates - ICAMU
9. Measurement and Improvement:– Fill Rates, BO, OTD, Accuracy - ICRIF– Inventory Mix (Safety, Excess, Defective)– Turns and ROI (GMROI and/or T&E) - ICRIT/R
10. CONTROLLED REPLENISHMENT
![Page 6: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/6.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
6
Inventory Management is at the Time of Replenishment - the
“When, What, and How Much”, Everything Else is Inventory
Correction.
![Page 7: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/7.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
7
Data, Set up, and Generating the
Numbers
It All Starts Here
Better Numbers
![Page 8: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/8.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
8
Inventory Management10 Step Process
The Numbers:1. Parameters/Setup:
– “Smart”
– Company/Warehouse
– Product Line
– Product Master
– Product Warehouse
2. Data Collection:– Usage
– Lead Time
– Level: On-hand and Paperfloat
– Purchasing History
3. Forecasting:– Rank
– Replenishment Cycle
– Usage, LT, Safety, Order Point, Line Point, Surplus Point, Order Quantity
4. Stock Level Accuracy:– On-hand
– Paperfloat
The Tools - Inventory Management:5. Replenishment:
– Use Priority Reporting– Purchases– Transfers
6. Timeline Analysis:– “Too Late”– “Too Early”
7. Excess/Surplus:– Prevention– Disposition
The Tools - Getting Results:8. Proactive Maintenance:
– Proofs– While Replenishing– Exceptions and Mass Updates
9. Measurement and Improvement:– Fill Rates, BO, OTD, Accuracy– Inventory Mix (Safety, Excess, Defective)– Turns and ROI (GMROI and/or T&E)
10. CONTROLLED REPLENISHMENT
![Page 9: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/9.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
9
Step 1: The Set Up - Parameters “Smart” Parameters MaintenanceICSR Warehouse Maintenance ICSD Product Line Maintenance ICSL Product Maintenance ICSP/ICSW
At start up and as needed
![Page 10: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/10.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
10
ICSR - IC Setup Replenishment
![Page 11: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/11.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
11
ICSR - Ranking
![Page 12: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/12.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
12
ICSR - Ranking
![Page 13: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/13.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
13
ICSR - Usage Months
![Page 14: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/14.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
14
ICSR - Usage Monitoring and Adjusting
![Page 15: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/15.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
15
ICSR - Lead Time
![Page 16: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/16.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
16
ICSR - Safety Stock and Analysis
![Page 17: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/17.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
17
ICSR - Order Point Adjusters
![Page 18: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/18.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
18
ICSR - Exceptions
![Page 19: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/19.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
19
ICSR - BCC Priority
![Page 20: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/20.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
20
ICSR - Transfer “Smart” Rounding
![Page 21: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/21.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
21
ICSD - IC Setup Warehouse
![Page 22: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/22.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
22
ICSL - Prod. Line Maint. (Order)
![Page 23: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/23.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
23
ICSL - Prod. Line Maint. (Required)
![Page 24: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/24.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
24
ICSP - Prod. Maint. Master (Req’d)
6” Disney Princess
Doll - Belle
Belle 6” Doll
A1 Toys
![Page 25: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/25.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
25
ICSW - Required
![Page 26: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/26.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
26
ICSW - Ordering
![Page 27: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/27.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
27
ICSW (Ordering) - Usage and Hits
![Page 28: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/28.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
28
ICSW (Ordering) - Trending
![Page 29: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/29.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
29
ICSW (Ordering) - LT Maint
![Page 30: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/30.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
30
ICSW (Ordering) - ASQ
![Page 31: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/31.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
31
ICSW - Frozen
12” Aluminum Shovel
![Page 32: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/32.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
32
ICSW - Seasonality (Trending)
12” Aluminum Coated
![Page 33: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/33.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
33
Step 2: Data Collection Usage Buckets: Sales, Transfers, Lost Sales,
Exceptional Sales, and Manual/Automated Overrides
Lead Time Buckets: P/Os, Transfers, and Manual Overrides
Stock Level Accuracy: Onhands and Paperfloat - Will discuss in Step 4
Where Does Most of this Data Come From?
![Page 34: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/34.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
34
Usage LT Saf RCCtoP
EOQCtoP
EOQCtoC
On-hand
Paper-float
SurpPrev/Disp
BOHand-ling
OTD Acc-uracy
IM X X X X X X X X XSales X X X X X X XBrch/Ware X X X X X X X X X X XOffice X X X XIS/IT X X X X X X X X X X X XMgt X X X X X X X X X X X X
Who’s Involved? - TEAM
![Page 35: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/35.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
35
Usage/DemandThe Cornerstone
Sales/Transfer History
Lost Sales
Exceptional Sales/Xfer
Human Input
Usage/Demand
What is Demand Planning?
Lost Sales:– Ask what they want
– Canceled B/O’s
– Directs to fill in
– Substitutes
– Ship from another whse
Three Methods to Enter LS:1. While in Sales/Order Entry
2. Lost Sales open order
3. Sheet, then to LS open order
What about the fill rate report?
What is an Exceptional Sale/Transfer?
![Page 36: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/36.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
36
OEET- Lost & Exceptional Sales
![Page 37: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/37.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
37
Lost Sales Tracking- Usage Logging
![Page 38: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/38.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
38
Step 3: Forecasting
Rank (Rank and Class) ICAI Review/Order/Xfer Cycle ICAR Usage, Safety, OP, LP, OQ ICAMM Exception Reporting* ICAMU
Monthly and as needed
* Discussed With Maintenance Section
![Page 39: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/39.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
39
ICAI - Rank (and Class)
![Page 40: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/40.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
40
ICAR - Review Cycle Min, Max, Exception RC Analysis & Basis
![Page 41: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/41.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
41
ICAMM - Review Cycle Basis
![Page 42: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/42.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
42
Step 4: Stock Level/PNAThe Other Cornerstone
On-hand Integrity WMS, CC Paperfloat Control BIIS
Daily
![Page 43: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/43.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
43
Paperfloat Control - BIIS
![Page 44: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/44.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
44
Paperfloat Control - BIIS
![Page 45: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/45.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
45
Profitability, Asset Management, and
Efficiency
“Getting Results”
Better Tools
![Page 46: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/46.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
46
Inventory Management10 Step Process
The Numbers:1. Parameters/Setup:
– “Smart”
– Company/Warehouse
– Product Line
– Product Master
– Product Warehouse
2. Data Collection:– Usage
– Lead Time
– Level: On-hand and Paperfloat
– Purchasing History
3. Forecasting:– Rank
– Replenishment Cycle
– Usage, LT, Safety, Order Point, Line Point, Surplus Point, Order Quantity
4. Stock Level Accuracy:– On-hand
– Paperfloat
The Tools - Inventory Management:5. Replenishment:
– Use Priority Reporting– Purchases– Transfers
6. Timeline Analysis:– “Too Late”– “Too Early”
7. Excess/Surplus:– Prevention– Disposition
The Tools - Getting Results:8. Proactive Maintenance:
– Proofs– While Replenishing– Exceptions and Mass Updates
9. Measurement and Improvement:– Fill Rates, BO, OTD, Accuracy– Inventory Mix (Safety, Excess, Defective)– Turns and ROI (GMROI and/or T&E)
10. CONTROLLED REPLENISHMENT
![Page 47: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/47.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
47
Step 5: Replenishment “When” to Replenish - Order Point:
– Service: Below Order Point Trigger– Profits/Cost: Target and/or Timeframe Trigger
“What” to Replenish - Line Point:– Replenishment Options:
» Line Buy (Make Target/Review Cycle)» Fill In Transfer/Emergency Buy» Do Nothing
– Replenish all items that will go BOP before the next replenishment cycle (Balance the Line)
“How Much” to Replenish - Line Point/EOQ:– Up to Line Point/Remaining Cycle (Cycle Coverage - Freight/C
to P)– Compare to Suggested Order Quantity (EOQ/Class - CtoC and
CtoP)– Minimum Run– Vendor/Transfer Package Rounding
PNA/Level
Surplus Point
Line Point or Max/EOQ
Order Point or Min
EOQ
Order Cycle
Lead Time
Safety
![Page 48: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/48.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
48
ReplenishmentBuying and Transferring
Generate RARR’s/Report POERRMerge P/O POERMEdit P/O POET
Generate RARR’s POERR*Review/Accept/Merge P/O POERA (BCC)* Schedule to run nightly if using the POERA. Setup to run to a file.
ERR - Generate RRAR - Print (ERM)/Online(ERA)
ERA - Review/Acceptance/Merge - Online RRAR (BCC)
ERM - Merge - Printed RRAR
ET - Edit
Recommended Replenishment Action Report (RRAR)
Warehouse Transfers follow the same except “WT”
![Page 49: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/49.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
49
PO/WTERR
![Page 50: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/50.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
50
POERA- Line Summary(Buyer’s Control Center)
![Page 51: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/51.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
51
POERA - Item Summary (BLP/BOP/Suggest WT)
![Page 52: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/52.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
52
POERA - Item Detail (Drill Down/Maint)
![Page 53: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/53.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
53
Making Targets ProperlyGeneral rules of thumb: Days Dollars 1/2 way through OC/RC
Cost to Carry vs Freight, Price, and Service:
Key is Equal Days Supply Increase or Decrease Use for Meeting Targets and
Emergency Fill-ins
LinePoint
OrderPoint
Out ofStock
SafetyStock
xx
x
x
x
xx
x
x
x
x = Products in Product Line
New line pointafter adjustingreview cycle days
xx
xx
![Page 54: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/54.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
54
POERA - Making Target
Header Tab - Increase/Decrease Tab
![Page 55: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/55.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
55
$Dis
coun
t/In
crea
se$C
to C
$C to C
$Discount/Increase
Quantity
Negative
Positive
Break Even
Max. Potential
Discount/Price Increase versus C to C
Break Even (Days):(2 x Discount% / Monthly C to C) x 30
Maximum Potential Savings (Days):(Discount% / Monthly C to C) x 30
![Page 56: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/56.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
56
Discount/Increase: 5% (This could also be Freight)
Cost to Carry “K” cost: 24%
Break Even (Days): (2 x Disc% / Monthly C to C) x 30 = 150 days
Maximum Potential (Days): (Disc% / Monthly C to C) x 30 = 75 days
![Page 57: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/57.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
57
Price Increases/Discounts
Remember, this is total days supply to on the shelve, not necessarily buy. Use the “up to vendor target logic” (change order cycle days) to meet the days supply.**This method works well for periods less than 90 days supply (seasonal or large swing items - be careful).
Be aware of future freight, minimum considerations, fill ins, NS and OAN items. If targets are involved, be sure to fill in the entire line not just the fast movers or work a deal.
![Page 58: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/58.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
58
Vendor Performance and Negotiations - It’s not just Price
Lower COGS Lower Freight Minimums Multiple Drops for Freight Combined P/O’s for Minimum Freight Paid Fill-ins
Fill Rates Consistent Lead Times and OTD Accurate Shipping (Blanket
Receiving) - Product, Quantity, Price
Good Backorder Handling
EDI/VMI/2-Way Information Flow - B2B
Automated Product and Pricing Updates
RGA’s on New Items Excess Inventory Returns
Win/Win - Partnership
![Page 59: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/59.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
59
Step 6: Time Line Analysis
Identification and Prevention are the Key
Out
0-30 days
In Out
30/+ days
Too Early
Incoming and will be early or not needed
Out
Incoming and will be late
0/- days
Too Late
![Page 60: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/60.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
60
ICRIG - Time Line Analysis
![Page 61: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/61.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
61
ICRIG - “Too Late/Gap”
![Page 62: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/62.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
62
ICRIG - “Too Early”
![Page 63: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/63.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
63
Step 7: Excess/Surplus Inventory
Responsibility Coordination
Prevention
Identification
Disposition
Goals/Plan
CONTINUOUS
![Page 64: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/64.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
64
ICRIS - “Smart” Surplus
Short Term/Internal (EB, GAP):
Surplus = Available > LP + EOQ Long Term/External (Take Action, Gone):
Surplus = Available > X Months Usage*Smart Logic:
1. Frozen or LP + EOQ > X Month Usage: Surplus = Avail > LP + EOQ
2. Order as Needed, N/S, Discontinued: Surplus = Avail
3. New Items: No Surplus
Must have Visibility and Utilization Monitoring
![Page 65: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/65.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
65
ICRIS - Surplus
![Page 66: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/66.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
66
ICRIS - Long Term Surplus
![Page 67: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/67.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
67
Surplus Inventory Disposition
BOP/GAP - Put of the fire: Short or Long Term
BLP/Sugg Xfers - Use it where you can: Long TermTeach branches to use LT first. Don’t borrow stock and put branch in “need”.
1. Stock Balance: (“X” Months Supply) - With “To” branch approval/Before Buy
2. Sell Above Cost: Customer, Other Distributor
3. At Cost: Sell at cost, Return at cost with no charges (freight, restock)
4. Below Cost: Sell below cost, Return below cost and/or with charges
5. Sell Above “Write-off” Cost: Garage/Fire Sale, Flea Market, Auction House, Liquidation House
6. Dump at “Write-off” Cost: Donate, Scrap, Dump
![Page 68: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/68.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
68
PNA/Level
Surplus Point
Line Point or Max/EOQ
Order Point or Min
EOQ
Order Cycle
Lead Time
Safety
Inventory Reductions - The Proper Way to Turns
Understand the Impact Areas: Excess and Defective:
– No one wants or needs
– Control the Feelings
– Let it Roll, Let it Go
– Be Careful - C to C/Mix
– Cost of Disposition
Line Point and Order Quantity:– “What” and “How Much”
– Be Careful - C to P Departments
Order Point - Safety Stock:– “When”
– Be Careful - Customer Service
Low Risk
High Risk
![Page 69: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/69.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
69
Proactive Maintenance
Keeping it Working
![Page 70: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/70.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
70
Inventory Management10 Step Process
The Numbers:1. Parameters/Setup:
– “Smart”
– Company/Warehouse
– Product Line
– Product Master
– Product Warehouse
2. Data Collection:– Usage
– Lead Time
– Level: On-hand and Paperfloat
– Purchasing History
3. Forecasting:– Rank
– Replenishment Cycle
– Usage, LT, Safety, Order Point, Line Point, Surplus Point, Order Quantity
4. Stock Level Accuracy:– On-hand
– Paperfloat
The Tools - Inventory Management:5. Replenishment:
– Use Priority Reporting– Purchases– Transfers
6. Timeline Analysis:– “Too Late”– “Too Early”
7. Excess/Surplus:– Prevention– Disposition
The Tools - Getting Results:8. Proactive Maintenance:
– Proofs– While Replenishing– Exceptions and Mass Updates
9. Measurement and Improvement:– Fill Rates, BO, OTD, Accuracy– Inventory Mix (Safety, Excess, Defective)– Turns and ROI (GMROI and/or T&E)
10. CONTROLLED REPLENISHMENT
![Page 71: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/71.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
71
Step 8: Proactive Maintenance Good Proofing Reports (Pline, Product) - Get a Clean Start While doing the Inventory Management Functions:
– If Change a Quantity, Remove a Line, or Add a Line - Do the Maintenance
– If Items Go BOP or Gap Before Expected and Not an Exceptional Spike, Adjustment or PNA Change - Do the Maintenance
– If Items are Not at BOP or are on “Too Early” and Not a Return, Adjustment or PNA Change - Do the Maintenance
Good Exception Center/Reports are a Must! Good Company Understanding and Eyes and Ears with Communication Use Hits and Cost logic to Review, to Prioritize, and for Action
Order Point Line Point Stock Level Four More
1. AMD/U 4. OC/RC/XC 5. On-hands 7. SOQ/EOQ
2. ALT 6. Paperfloat 8. Status
3. Safety Stock 9. Paths
10. Freeze/Tmins
![Page 72: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/72.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
72
Service and Profit - A Quick Method
Hits H H L L
Cost L H L H
![Page 73: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/73.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
73
Spend your days reacting to the fires... you may be efficient, but
will you be effective?
Fire Prevention ...
![Page 74: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/74.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
74
Product Line Proof Report
![Page 75: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/75.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
75
Product Proof Report
![Page 76: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/76.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
76
POERAWhile Replenishing - Be Proactive!
![Page 77: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/77.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
77
How to Make it Work
Items Below Order Point Sooner then Expected Items Show on the “GAP”
Spike (customer or branch) - Teach Smart Selling/Transferring, Did you Expect to Cover (Safety, ASQ, 5HI, Tmin)
Stock Adjustment and/or Changed/Deleted Incoming (P/O or Transfer) Knocking Line Out of Cycle: Topping Truck Incorrectly, Special Buys on Fast Movers Not Putting Order/Transfer on when getting the Commitment Bad OP/LP/OQ/Level: Demand, Lead Time, Safety, Order/Review Cycle, Level Wrong Not Replenishing up to OP - Playing the Game Not Replenishing up to LP - Playing the Game
CHECK THE LEDGER INQUIRY - Spike or Adjustment
CHECK OLD P/O and TRANSFER - Changed Incoming
CHECK BAD DATA/PARAMETERS - Usage, LT or Safety Low
OTHERWISE - Playing the Game
![Page 78: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/78.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
78
ICAMU
![Page 79: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/79.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
79
ICAMU - Exception Selection
![Page 80: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/80.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
80
ICAMU - OAN Products with Hits
![Page 81: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/81.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
81
ICAMU - Tmin Low Activity
![Page 82: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/82.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
82
ICAMU - Trending Exception
![Page 83: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/83.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
83
ICAMU - Lead Time Exceptions
![Page 84: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/84.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
84
ICAMU - 5HI ASQ
![Page 85: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/85.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
85
ICAMU - Tmins to Expire
![Page 86: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/86.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
86
ICAMU - Value Change Inquiry
![Page 87: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/87.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
87
ICAMU - Mass Update
![Page 88: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/88.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
88
ICAMU - Mass Update
![Page 89: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/89.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
89
Monitoring and Measuring
Getting Results!
![Page 90: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/90.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
90
Inventory Management10 Step Process
The Numbers:1. Parameters/Setup:
– “Smart”
– Company/Warehouse
– Product Line
– Product Master
– Product Warehouse
2. Data Collection:– Usage
– Lead Time
– Level: On-hand and Paperfloat
– Purchasing History
3. Forecasting:– Rank
– Replenishment Cycle
– Usage, LT, Safety, Order Point, Line Point, Surplus Point, Order Quantity
4. Stock Level Accuracy:– On-hand
– Paperfloat
The Tools - Inventory Management:5. Replenishment:
– Use Priority Reporting– Purchases– Transfers
6. Timeline Analysis:– “Too Late”– “Too Early”
7. Excess/Surplus:– Prevention– Disposition
The Tools - Getting Results:8. Proactive Maintenance:
– Proofs– While Replenishing– Exceptions and Mass Updates
9. Measurement and Improvement:– Fill Rates, BO, OTD, Accuracy– Inventory Mix (Safety, Excess, Defective)– Turns and ROI (GMROI and/or T&E)
10. CONTROLLED REPLENISHMENT
![Page 91: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/91.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
91
Step 9: Measurement & Improvement
Customer Service: Fill Rates/Availability
(ICRIF) Accuracy - Product, Quantity,
Price (CM%) On-Time-Delivery - OTD Backorder Handling (ICRIN)
Profits and ROI: Surplus - Disposition (ICRIS)
and Prevention Safety Analysis (ICAMU) Review/Order Cycle:
– Freight Dollars - As Percentage of Sales
– Turns - Really CtoC and CtoP (ICRIT)
– Turn and Earn - ROI (ICRIR)
Replace Inventory with Information
Do better on both sides!
![Page 92: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/92.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
92
If there is no measurement, then it is all hearsay. Data-free
conversations and decisions will cause lots of frustrations, cost lots
of money and result in lots of disappointments...
![Page 93: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/93.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
93
Service - Fill Rates How well a business meets its customer’s needs - pulse of customer’s
happiness/loyalty. What to Measure:
Fill Rates = Shipped/Ordered
Quantity: 9 out of 10 = 90%
Line Item SC: 9 out of 10 = 0%
Order Ship Complete?
What Should Fill Rates Be? The Report is Broken - Look at “First Pass” Orders - EDI, Fax, Internet, etc for true
fill rates and backorder retention Only one way to better Fill Rates - The Right Inventory. Two ways to the Right
Inventory...
![Page 94: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/94.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
94
Profits - Turns? ROI?
Cost to Carry, Cost to Purchase and Freight
C to P Turns
80’s $10.00 2-3
90’s $5.00 3-6
00’s $2-3.00 6-10
EDI/VMI $0.13 ?Many companies are increasing the turns, but the infrastructure does not support it;
bottom line, longevity and growth are all suffering! Customer Service, GM Improvement, Efficiency, Accuracy, Asset Management
Pro
fita
bili
ty
Turns
![Page 95: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/95.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
95
Turns vs Bottom Line ContributionReturn
140
150
150
140
Turns
4
5
6
7
Margin
35
30
25
20
Customer Service Improvement - Availability, OTD, BO Handling
Gross Margin Improvement - Sell Service (Price) and COGS
Expense Reduction - Freight, Cost to Carry, Cost to Replenish
Inventory Management is Not Only Turns…
Inventory Management is Bottom Line, Longevity and Growth
7 Turns & 4% Bottom Line or 5 Turns & 7% Bottom Line
Velocity P
ricing?
![Page 96: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/96.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
96
Return on Investment
GMROI:
= Turns CGM%
= COGS GMAve Inv COGS
= Sls Turns GM%
= Sales GMAve Inv Sales
= GMAve Inv
x
x
x
xx
x
Turns:= COGS + $TransferredAve Inv
T&E:
= Turns GM%
= COGS GMAve Inv Sales
No Directs, Non-Stocks or Pass-Throughs
How to Use T&E/GMROI
![Page 97: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/97.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
97
Step 10:
CONTROLLED REPLENISHMENT
Uncontrolled Replenishment Leads to Uncontrolled
Results
![Page 98: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/98.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
98
Final Thoughts
AWOA W
![Page 99: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/99.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
99
“Better Numbers and Tools” Top 10
Better Numbers:1. Hits based Ranking
2. Smart Set-Up and Maintenance
3. Usage: Lost Sales and Exceptional Sales, Seasonal Trending, and Roll Up
4. Customer Buying Habits
5. RC and EOQ Control and Depth
Better Tools:1. Paperfloat Control
2. Buyer’s Priority, Targets Properly/Equal Days Supply, and One-Stop
3. Timeline Analysis “Too Late” and “Too Early”
4. Long Term Surplus
5. Exception Control Center and Mass Update
![Page 100: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/100.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
100
SX.enterprise Summary“Best Practices” Inventory Mgt
Better SKU Coverage - System and Buyers Improved Time Management Improved Priority Setting Balances Technology and Core Replace Inventory with Information Rifle Approach vs. Shotgun Approach Better Numbers and Better Tools Better Service and Better Profits Distributor of Choice: Owners, Customers, Employees
and Vendors
Now What? Go Back, Follow the 10 Steps, Execute and Get Results… The Door is Open!
![Page 101: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/101.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
101
Inventory Management10 Step to Results
The Numbers:1. Parameters/Setup:
– “Smart” - ICSR
– Company/Warehouse - ICSD
– Product Line - ICSL
– Product Master - ICSP
– Product Warehouse - ICSW
2. Data Collection:– Usage - OE/WT
– Lead Time - WT/PO
– Level: On-hand and Paperfloat - BIIS
– Purchasing History
3. Forecasting:– Rank - ICAI
– Replenishment Cycle - ICAR
– Usage, LT, Safety, Order Point, Line Point, Surplus Point, Order Quantity - ICAMM
4. Stock Level Accuracy:– On-hand - CC’s
– Paperfloat - BIIS
The Tools - Inventory Management:5. Replenishment:
– Use Priority Reporting - POERA– Purchases - POERR, POEAR– Transfers - WTERR, WTERA
6. Timeline Analysis:– “Too Late” - ICRIG– “Too Early” - ICRIG
7. Excess/Surplus:– Prevention– Disposition - ICRIS
The Tools - Getting Results:8. Proactive Maintenance:
– Proofs– While Replenishing - POERA– Exceptions and Mass Updates - ICAMU
9. Measurement and Improvement:– Fill Rates, BO, OTD, Accuracy - ICRIF– Inventory Mix (Safety, Excess, Defective)– Turns and ROI (GMROI and/or T&E) - ICRIT/R
10. CONTROLLED REPLENISHMENT
![Page 102: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/102.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
102
Back to Basics
Many distributors DON’T: Set the system up properly Feed the system good data Understand or Use the system properly Clean up bad processes and procedures Educate their people on the system or processes Help departments work together Help work towards common goals
Yet they think it will all just magically work
![Page 103: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/103.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
103
The FoundationPlan of Improvement
Back to BasicsProactive versus Reactive
Replace Inventory With Information
![Page 104: 2006 Grant W. Howard Company Infor, Inc (Sx screens only) 1 “Best Practices” Inventory Management Grant W. Howard (734) 428-0529 ghoward@gwhco.org](https://reader036.vdocuments.us/reader036/viewer/2022062511/551b7d00550346d6338b5486/html5/thumbnails/104.jpg)
2006 Grant W. Howard Company Infor, Inc (Sx screens only)
104
J D I
It’s too hard to log lost and exceptional sales
It’s too hard to keep the paper work clean
It’s too hard to keep the on-hand correct
It’s too hard to work excess inventory
It’s too hard ...
It’s too hard..., The system is broken or doesn’t have it…, We will never get them to do that…,
We don’t know how to do that… J D I !