Inventory Performance, Cost and Value Measures
Animated publication
RightChain™ Metrics for Inventory Inventory Performance, Cost, and Value Measures
RightChain™ School of Inventory Planning and Management RightChain™ Institute
© RightChain Incorporated | All Rights Reserved
1
RightChain™ Inventory Performance Measures Outline
Financial Performance Measures Efficiency Performance Measures Quality Performance Measures Cycle Time Performance Measures
Page 2
RightChain™ Incorporated
RightChain™ Inventory Scoreboard
FINANCIALS I
FINANCIALS II
EFFICIENCY
SERVICE & QUALITY
PRODUCTIVITY & CYCLES
INVENTORY INVESTMENT • Average (AIV) • Snapshot (OHIV) • Cube on Hand (COH)
INVENTORY CARRYING RATE Warehousing, Storage, …
INVENTORY TURN RATE Turns at Retail, Turns at Cost, Unit Turns
FILL RATE Unit Fill Rate, Line Fill Rate Order Fill Rate
PLANNER PRODUCTIVITY SKUs per FTE $s per FTE Sources per FTE POs per FTE
INVENTORY CARRYING COST ICC = AIV x ICR
. GROSS MARGIN (GM) Revenue (REV) less Cost of Goods Sold (COGS)
FORECAST BIAS & ACCURACY
ON HAND INVENTORY Days, Leadtimes Cube
CYCLE TIMES Planning Cycle Time PO Cycle Time
INVENTORY VALUE ADDED IVA = GM less ICC
INVENTORY ACCURACIES Fiscal Accuracy, Physical Accuracy
GROSS MARGIN PERCENT GM/Revenue
DC OCCUPANCY Locations Cube
LOST SALES COST LSC = (1 – Fill Rate) x GM
INVENTORY QUALITY RATIO
GROSS MARGIN RETURN ON INVENTORY (GMROI) GM/AIV
ACTIVE SKU RATIO
INVENTORY POLICY COST IPC = ICC + LSC
GROSS MARGIN RETURN ON CUBE
RightChain™ Incorporated
3
Copyright and Confidential | All Rights Reserved
Inventory Investment • Average Inventory Investment • Snapshot Inventory Investment • Inventory as a Percent of Sales Margin Based Metrics • Gross Margin • Gross Margin Percent • Gross Margin Return on Inventory • Gross Margin Return on Cube Cost Based Metrics
Financial Performance of Inventory
• Inventory Carrying Rate • Inventory Carrying Cost • Lost Sales Cost • Inventory Policy Cost Value Based Metrics • Inventory Value Added™
Page 4
RightChain™ Incorporated
Supply Chain Financial Statement
RightChain™ Incorporated
5
Copyright and Confidential | All Rights Reserved
Supply Chain Financial Statement
RightChain™ Incorporated
6
Copyright and Confidential | All Rights Reserved
Inventory as a Percent of Sales
Page 7
RightChain™ Incorporated
Gross Margin Return on Inventory (GMROI)
If you were a bank, which company would you invest in?
Company A
Company B
Sales$ 1,000,000.00 $
1,000,000.00 200,000.00 800,000.00
Profit $
200,000.00 $ 400,000.00 $
Average Inventory Value $
Return on Inventory
50%
25%
GMROI(i) = [{USP(i) – UIV(i)} x AD(i)] / AIV(i) USP(i) = Unit Selling Price of Item i UIV(i) = Unit Inventory Value of Item i AD(i) = Annual Demand of Item i AIV(i) = Average Inventory Value of Item i
Return on Inventory = Margin / Average Inventory Value
RightChain™ Incorporated
Copyright and Confidential | All Rights Reserved
8
• Inventory Value Added™ is one of RightChain’s proprietary inventory performance measures. Like GMROI, it takes into account revenue, expense and capital charges. • Inventory Value Added™ = Revenue – Expense – Inventory Carrying Cost = Margin – Inventory Carrying Cost = [ AD x (USP – UIV)] – (AIV x ICR)
Inventory Value Added
Page 9
RightChain™ Incorporated
RightChain™ Inventory Financials
RightChain™ Incorporated
Copyright and Confidential | All Rights Reserved
10
RightChain ™ Inventory Optimization Model
RightChain™ Incorporated
Copyright and Confidential | All Rights Reserved
11
RightChain™ Inventory Optimization Model
RightChain™ Incorporated
12
Copyright and Confidential | All Rights Reserved
Inventory Turn Rates • Turns at Cost • Turns at Retail • Turns at Throughput Inventory On Hands • Dollars on Hand • Days on Hand • Leadtimes on Hand • Cube on Hand
Inventory Efficiency Measures
Page 13
RightChain™ Incorporated
Inventory Turn Rate Computations
Turns at Retail = (Annual Sales at Retail)/(Average Inventory Value) If the annual sales for a corporation is $200,000,000 per year and the average inventory value is $50,000,000 then the turn ratio at retail is $200,000,000/$50,000,000 = 4.0. Turns at Cost = (Annual Sales at Cost)/(Average Inventory Value) If the annual sales at cost (cost of goods sold) for a corporation is $100,000,000 per year and the average inventory value is $50,000,000 then the turn ratio at cost is $100,000,000/$50,000,000 = 2.0. Unit Inventory Turns = (Annual Units Shipped)/(Average Units in Inventory) If the annual number of units shipped from a warehouse is 2,000,000 and the average number of units in inventory is 400,000 then the unit inventory turn ratio is 2,000,000/400,000 = 5.0.
RightChain™ Incorporated
14
Copyright and Confidential | All Rights Reserved
Inventory Turn Rate Computations
Turn Measure
Ratio
Global Inventory Turnover Regional Inventory Turnover Country Inventory Turnover Local Inventory Turnover Facility Inventory Turnover Category Inventory Turnover Vendor Inventory Turnover Item Inventory Turnover
Global Sales at Cost / Global Average Inventory Value Regional Sales at Cost / Regional Average Inventory Value Country Sales at Cost / Country Average Inventory Value Local Sales at Cost / Local Average Inventory Value Facility Sales at Cost / Facility Average Inventory Value Category Sales at Cost / Category Average Inventory Value Vendor Sales at Cost / Vendor Average Inventory Value Item Sales at Cost / Item Average Inventory Value
RightChain™ Incorporated
15
Copyright and Confidential | All Rights Reserved
Inventory Turns in Various Industries
Inventory Turn Rate Inventory Days of Supply
45
140
40
120
35
100
30
80
25
20
60
15
Inventory Turn Rate
40
Inventory Days of Supply
10
20
5
0
0
Drug Stores
Liquor Stores Other Retail Stores
Grocery Stores
Hardware Stores
Other Food Stores New & Used Car Dealers
Apparel & Accessories Furniture & home furnishings
Gas stations & mini-marts
Auto parts & Accessories
Lumber & building materials
Wholesale - Furniture & fixtures Wholesale - lumber & construction Wholesale - sporting goods & related Wholesale - electrical goods
General Merchandise Stores
Wholesale - Drug store items
Wholesale - apparel & related
Wholesale - misc non-durable
Wholesale - chemical & related
Wholesale - petroleum & related
Wholesale - Groceries & related Wholesale - Machinery & Equipment
Wholesale - other durable goods Wholesale - paper & related products
Wholesale - alcoholic beverages
Retail Nurseries & Garden Supply
Wholesale - hardware & plumbing
Wholesale - Vehicles & automotive
Source:BizStats.com
RightChain™ Incorporated
Copyright and Confidential | All Rights Reserved
16
Retail Industry Turns & GMROIs
1 1.5 2 2.5 3 3.5 4 4.5 5
10 12 14 16
4.87
Turn Rate GMROI
13.7 4.12
3.48
9.2 2.9
8.7
2 4 6 8
2.61
2.513571429
GMROI
2.37
2.24
2.22
5.4
1.93
5.1
4.87
1.78 1.68
1.72
1.71
Inventory Turn Rate
1.56
3.8 3.4
2.8 2.9 3
2.8
2.8
2.3
2.3
AVERAGE
Book Stores
Shoe Stores
Home Centers
Grocery Stores
Hardware Stores
Women's Clothing
Mail Order Houses
Office Supply Stores
Family Clothing Stores
Sporting Goods Stores
Auto Parts & Accessories
Pharmacies & Drug Stores
Hobby, Toy & Game Stores
Gift, Novelty and Souvenir Stores
Source: The Retail Owners Institute
RightChain™ Incorporated
Copyright and Confidential | All Rights Reserved
17
Inventory Comparables Benchmarks
Premier Parks The GAP IMRA Best Practice The Limited Hardlines Retailer Discount Department Store TJX Mass Merchant J.C. Penney Venator Group Hardlines Retailer Pier 1 Imports Top 20 Retailer Hardlines Retailer ABC Company Specialty Apparel Retailer Toy Retailer Hardlines Retailer Top 50 Specialty Store Sport Shoe Retailer Shoe Retailer
1.54
2.05
2.13
2.4 2.4
Much like a real estate agent looks at comparable homes to determine the appropriate selling price for a home, we use companies with comparable logistics profiles to compute appropriate benchmarks for logistics performance.
2.5
2.4
2.8
3.41
4.24 4.2 4.2
4.31
4.8
5.21
5.87
6.3
6.65
7
7.35
21.11
0
1
2
3
4
5
6
7
8
9
10
RightChain™ Incorporated
Copyright and Confidential | All Rights Reserved
18
Manufacturing Industry Raw Materials
Source: Manufacturing Pulsemark
Page 19
RightChain™ Incorporated
Manufacturing Industry Work in Process
Source: Manufacturing Pulsemark
Page 20
RightChain™ Incorporated
Manufacturing Industry Finished Goods
Source: Manufacturing Pulsemark
Page 21
RightChain™ Incorporated
Total Inventory Cost Example
RightChain™ Incorporated
22
Copyright and Confidential | All Rights Reserved
Inventory Management Productivity Measures
• SKUs per FTE • $s per FTE • Suppliers per FTE • Purchase Orders per Man-Hour • Planner Effectiveness
Page 23
RightChain™ Incorporated
Purchase Operating Expense as a % of Purchase Dollars
Purchase Spend per Purchasing Employee ($millions)
% of Active Suppliers Representing 80% of Purchase Spend
Industry
Aerospace/Defense
2.69% 0.78% 0.72% 0.76% 0.34% 0.58% 1.71% 0.99% 0.63% 0.69% 0.23% 0.63%
$ $ $ $ $ $ $ $ $ $ $ $
5.29 14.05 24.61 31.20 36.64 20.16 22.15 14.30 24.59 18.05 47.05 21.27
4.67% 5.41% 4.79% 8.98% 9.49% 17.81% 19.94% 4.13% 3.37% 2.09% 3.60% 5.92%
Supply Productivity
Chemical
Computer Hardware Consumer Products Food & Beverage Industrial Manufacturing
Media
Petroleum
Pharmaceuticals Semiconductor Telecommunications
Utilities
Source: Center for Advanced Purchasing
Page 24
RightChain™ Incorporated
Purchase Order Processing Costs
Source: ApparelSearch
Page 25
RightChain™ Incorporated
Inventory Service and Quality Measures
• Fill Rate • Forecast Accuracy • Inventory Accuracy • Warehouse Occupancy % • Active SKU % • Inventory Quality Ratio
Page 26
RightChain™ Incorporated
Fill Rate Measures
Measure
Definition
Conversion
Unit Fill Rate (UFR) Line Fill Rate (LFR) Order Fill Rate (OFR)
units shipped units requested
Facing vs Global Fill
lines shipped complete lines requested orders shipped complete orders requested
LFR = UFR upl
Initial vs Final Fill
OFR = LFR lpo
Quantity Requested
Quantity Shipped 50 units 20 units 10 units 80 units
Quantity Requested
Quantity Shipped 70 units 20 units
ORDER 1 3 lines requested, 2 lines filled complete 100 units requested, 80 units filled
ORDER 2 3 lines requested, 2 lines filled complete 100 units requested, 90 units filled
Item
Item
Shampoo 50 units Conditioner 40 units Hair Spray 10 units
Comb
70 units 20 units
Brushes
Hair Spray 10 units
0 units
TOTALS
100 units
TOTALS
100 units 90 units
Unit Fill Rate = 170/200 = 85%, Line Fill Rate = 4/6 = 67%, Order Fill Rate = 0/2 = 0% UFR > LFR > OFR
OOS Probability
Out of Stock Probability vs Number of SKUs
Fill Rate
Number of SKUs
Page 28
RightChain™ Incorporated
Fill Rate Benchmarks Retail Shelf Outages
Source: Prism Partners
RightChain™ Incorporated
Copyright and Confidential | All Rights Reserved
29
Fill Rate Benchmarks Retail Shelf Outages
Source: Prism Partners
RightChain™ Incorporated
Copyright and Confidential | All Rights Reserved
30
Fill Rate Performance in Various Industries
Source: Herb Davis Associates
Page 31
RightChain™ Incorporated
Honda Parts DCs Turn and Fill Rate Internal Benchmarking
Page 32
RightChain™ Incorporated
Turn & Fill Rate Benchmarks
80 82 84 86 88 90 92 94 96 98 100
Lanier
Fill Rate
0
2
4
6
8
10
Turns
RightChain™ Incorporated
Copyright and Confidential | All Rights Reserved
33
Forecast Accuracy Metrics
• Algebraic Deviation • Absolute Deviation • Mean Absolute Deviation (MAD) • Mean Absolute Percent Error (MAPE) • Forecast Bias
Page 34
RightChain™ Incorporated
• Location Inventory Accuracy (LIA) = % of Locations without Discrepancies • Item Inventory Accuracy (IIA) = % of Items without Discrepancies • Net Value Discrepancy (NVD)
Inventory Accuracy Metrics
Page 35
RightChain™ Incorporated
Warehouse Inventory Accuracy Benchmarks
Client = 99.2%
RightChain™ Incorporated
Copyright and Confidential | All Rights Reserved
36
Example Inventory Accuracy Report
Page 37
RightChain™ Incorporated
Inventory Counting Methods
RightChain™ Incorporated
Copyright and Confidential | All Rights Reserved
38
Part Number Co-Location
Occupancy Levels at Normal and Peak Inventory
2.9%
99%+
33.5%
7.6%
95% to 99%
25.3%
11.0%
90% to 95%
16.5%
23.3%
85% to 90%
11.8%
Normal Peak
The “average” warehouse in the survey is 82% full at “normal” inventory levels and 96% full at “peak” inventory levels.
15.7%
80% to 85%
7.1%
% Occupancy
16.9%
75% to 80%
4.1%
10.5%
70% to 75%
1.8%
12.2%
Less than 70%
0.0%
0.0% 5.0% 10.0% 15.0% 20.0% 25.0% 30.0% 35.0% 40.0%
% of Warehouses in Range
Productivity Loss Due to Excessive Occupancy
The average expected productivity loss due to excessive occupancy is 9%.
Source: Edward H. Frazelle, Ph.D., The Logistics Institute at Georgia Tech, WERC
Active SKU Percentage
Median: 83.1% Average: 73.4%
Page 42
RightChain™ Incorporated
Inventory Quality Ratio
Inventory Quality Ratio (IQR) = Inventory Investment in Active SKUs Total Inventory Investment
Page 43
RightChain™ Incorporated
Example Inventory Scoreboard
RightChain™ Incorporated
Page 44
Copyright and Confidential | All Rights Reserved
Exercises • Choose an organization in your group. Develop a mission statement for the inventory management activity, an optimization statement for the activity, and seven key performance metrics for inventory management. There should be at least one metric in each of the following categories – finance, productivity, quality, and cycle time. Assign weights to each metric such that the weights add to 100. • What inventory performance measures are currently not being measured that should be? • Develop seven key inventory performance indicators that meet the criteria for effective performance measurement systems established earlier. Present them in dashboard format. • Develop an inventory performance measurement dashboard.
Financial Metrics Calculations • The annual retail sales for an item is $3,200,000, the COGS is $1,200,000, the UIV is $5.00, and the AIL is 500,000.
• What is the retail turn rate? • What is the turn rate at cost? • What is the GMROI? • If the ICR is 30% per year, what is the IVA™?
• If the unit fill rate for the all the items in a warehouse is 97%, the average units per line is 3, and the average lines per order is 2; what is the expected line fill rate and order fill rate out of that warehouse?
Made with FlippingBook - Online Brochure Maker