Inventory Management Guide for Distributors

Why Inventory Management Matters for Distributors

For distribution companies, inventory is simultaneously your largest asset and your largest liability. Too much inventory ties up cash, increases storage costs, and creates obsolescence risk. Too little inventory means stockouts, lost sales, and unhappy clients.

Brazilian distributors face additional challenges:

Long and variable lead times from international suppliers
High cost of capital making excess inventory expensive
Tax complexity with ICMS credit and debit across states
Seasonal demand influenced by Brazilian economic cycles
Infrastructure challenges in logistics and warehousing

The companies that manage inventory well consistently outperform those that do not — in cash flow, margins, and client satisfaction.

ABC Analysis: Classifying Your Inventory

ABC analysis is the foundation of inventory management. It applies the Pareto principle (80/20 rule) to classify items by their importance to the business.

How to Run an ABC Analysis

Pull 12 months of sales data by SKU
Calculate annual revenue for each SKU
Sort by revenue (highest to lowest)
Calculate cumulative percentage of total revenue
Classify:

Class	Revenue Share	Typical % of SKUs	Management Approach
A	Top 80% of revenue	15-20% of SKUs	Tight control, frequent counts, optimized reorder points
B	Next 15% of revenue	25-35% of SKUs	Moderate control, monthly review, standard reorder
C	Bottom 5% of revenue	50-60% of SKUs	Minimal control, quarterly review, consider elimination

Beyond Revenue: Multi-Criteria ABC

Revenue alone can be misleading. We recommend a multi-criteria classification:

Criterion	Weight	Why It Matters
Revenue contribution	40%	Business impact
Gross margin contribution	30%	Profitability
Sales frequency	15%	Operational complexity
Client criticality	15%	Strategic importance (do key clients need this item?)

An item might be C-class by revenue but A-class by margin or client criticality. Your classification should reflect total business impact, not just top-line revenue.

Action Items by Class

Action	A Items	B Items	C Items
Count frequency	Weekly or cycle count	Monthly	Quarterly
Forecast method	Quantitative (statistical)	Simple average	Min/max
Safety stock	Calculated per SKU	Category standard	Minimal or zero
Reorder review	Daily or weekly	Weekly	Monthly
Storage location	Prime picking locations	Secondary locations	Remote storage
Supplier management	Regular communication, SLAs	Periodic review	As needed

Safety Stock Calculation

Safety stock is the extra inventory you hold to protect against demand uncertainty and supply variability. Too little means stockouts. Too much means waste.

The Practical Formula

For most SMB distributors, this formula works well:

Safety Stock = (Max Daily Sales × Max Lead Time) - (Avg Daily Sales × Avg Lead Time)

Example:

Maximum daily sales: 50 units
Maximum lead time: 15 days
Average daily sales: 30 units
Average lead time: 10 days

Safety Stock = (50 × 15) - (30 × 10) = 750 - 300 = 450 units

Service Level Approach

For more sophisticated management, tie safety stock to desired service levels:

Service Level	Z-Score	Meaning
90%	1.28	Fill 90% of orders from stock
95%	1.65	Fill 95% of orders from stock
97.5%	1.96	Fill 97.5% of orders from stock
99%	2.33	Fill 99% of orders from stock

Formula: Safety Stock = Z × σd × √L

Where:

Z = service level factor (from table above)
σd = standard deviation of daily demand
L = average lead time in days

Apply different service levels by ABC class:

A items: 97.5% service level
B items: 95% service level
C items: 90% service level

Reorder Points

The reorder point tells you when to place a new order. It accounts for lead time demand plus safety stock.

Reorder Point = (Average Daily Demand × Lead Time) + Safety Stock

Example (continuing from above):

Average daily demand: 30 units
Lead time: 10 days
Safety stock: 450 units

Reorder Point = (30 × 10) + 450 = 750 units

When inventory drops to 750 units, place a new order.

Economic Order Quantity (EOQ)

How much to order each time? The EOQ formula balances ordering costs against carrying costs:

EOQ = √(2DS / H)

Where:

D = annual demand (units)
S = ordering cost per order (R$)
H = annual holding cost per unit (R$)

Example:

Annual demand: 10,000 units
Ordering cost: R$150 per order
Holding cost: R$12 per unit per year

EOQ = √(2 × 10,000 × 150 / 12) = √250,000 = 500 units per order

Reorder Parameters by ABC Class

Parameter	A Items	B Items	C Items
Review frequency	Continuous (system-driven)	Weekly	Monthly
Order method	EOQ with safety stock	Fixed order quantity	Min/max with periodic review
Lead time buffer	Yes (max lead time)	Moderate	Average lead time only

Inventory Valuation in Brazil

Legal Requirements

Brazilian accounting standards (CPC 16 / IAS 2) permit two methods for inventory valuation:

Method	Portuguese Name	How It Works	When to Use
FIFO	PEPS (Primeiro que Entra, Primeiro que Sai)	Oldest items are sold first	When prices are rising (lower COGS, higher taxes)
Weighted Average	Custo Médio Ponderado	Average cost recalculated with each purchase	Simpler to administer, most common for distributors

Important: LIFO (UEPS) is NOT permitted under Brazilian accounting standards. If your ERP offers LIFO, do not use it for official reporting.

Practical Considerations

Most Brazilian distributors use Custo Médio Ponderado (weighted average) because:

Simpler to calculate and maintain
Smooths out price fluctuations
Most ERPs default to this method
Acceptable for Lucro Real, Lucro Presumido, and Simples Nacional

ICMS implications: Track ICMS credits and debits separately from inventory valuation. Each purchase adds ICMS credit; each sale creates ICMS debit. The net is your tax obligation. Ensure your ERP handles this correctly.

Write-Off Procedures

Dead and obsolete inventory is a cash drain. Brazilian SMBs tend to hold onto inventory far too long, hoping it will sell eventually. It usually does not.

Inventory Aging Analysis

Run this report monthly. Classify all inventory by last movement date:

Age Category	Action	Financial Treatment
0-90 days	Active — normal management	Full value
91-180 days	Watch — investigate why not moving	Consider 10-20% provision
181-365 days	Action required — discount, bundle, or return	30-50% provision
365+ days	Write off or liquidate	80-100% provision or write-off

Write-Off Options

Option	When to Use	Financial Impact
Discount sale	Product is still saleable but slow	Recovers partial value, frees space
Bundle with fast movers	Product complements A-class items	Recovers value, moves through existing channels
Return to supplier	Supplier accepts returns (negotiate this upfront)	Full or partial credit
Donate	Tax-deductible charitable donation (for applicable products)	Tax benefit, goodwill
Scrap/Destroy	No resale value, hazardous, or expired	Document thoroughly for tax deduction

The Cost of Holding Dead Stock

Many SMB owners underestimate the cost of keeping unsold inventory. The true annual cost of holding inventory:

Cost Component	Typical Range
Cost of capital (opportunity cost)	12–18%
Storage and warehousing	3–5%
Insurance	1–2%
Obsolescence and shrinkage	3–8%
Handling and administration	1–2%
Total holding cost	20–35% of inventory value per year

That means a R$500,000 pile of dead stock costs you R$100,000–R$175,000 per year just to keep it sitting there. Write it off and redeploy the capital.

Inventory Turnover Benchmarks

Inventory turnover measures how many times you sell and replace your inventory per year. Higher is generally better (within reason — too high means frequent stockouts).

Formula: Inventory Turnover = COGS / Average Inventory

Benchmarks by Distributor Type

Distributor Type	Target Turnover	Warning Zone
FMCG / Consumer goods	10–20x	Below 8x
Food and beverage	15–30x	Below 12x
Industrial supplies	4–8x	Below 3x
Construction materials	4–8x	Below 3x
Auto parts	5–10x	Below 4x
Pharmaceutical	8–15x	Below 6x
Electronics	6–12x	Below 5x

Days of Inventory (DOI)

A more intuitive metric: how many days of sales does your current inventory represent?

Formula: DOI = 365 / Inventory Turnover

Turnover	Days of Inventory	Assessment
15x	24 days	Excellent for FMCG
10x	37 days	Good for general distribution
6x	61 days	Acceptable for specialty
4x	91 days	Watch — consider optimization
2x	183 days	Problem — significant capital tied up

Technology Solutions

ERP Inventory Modules

Your ERP system should handle:

Real-time stock levels by location
Automatic reorder point alerts
ABC classification
Inventory aging reports
Batch/lot tracking (if required)
ICMS credit/debit tracking
Multi-warehouse management

Warehouse Management System (WMS)

For distributors above R$15M with significant inventory operations, consider a dedicated WMS:

WMS	Best For	Integration
TOTVS WMS	TOTVS Protheus users	Native
Sênior WMS	Senior ERP users	Native
Intelipost	E-commerce fulfillment	API-based
GTI Plug	Small-to-mid distributors	Multiple ERP integrations

Barcode and Mobile Solutions

At minimum, implement barcode scanning for:

Receiving — verify quantities against purchase order
Picking — confirm correct items pulled
Shipping — validate against sales order
Cycle counting — speed up physical counts

Handheld scanners (Zebra, Honeywell) or smartphone apps (Scandit, Orca Scan) cost R$500–R$3,000 per device. The ROI from reduced errors and faster processing pays for itself within months.

Building the Monthly Inventory Review

Add these metrics to your monthly management review:

Metric	Frequency	Owner
Inventory turnover (overall and by ABC class)	Monthly	Operations manager
Days of inventory	Monthly	Operations manager
Stockout rate (% of orders with stockouts)	Weekly	Supply chain lead
Dead stock value (180+ days)	Monthly	Operations manager
Inventory accuracy (cycle count results)	Monthly	Warehouse lead
Carrying cost as % of inventory value	Quarterly	Finance

The goal is continuous improvement — not perfection on day one. Track these metrics monthly, identify the biggest gap, focus improvement efforts there, and repeat.

Want to benchmark your supply chain performance? Take our free diagnostic — it evaluates inventory management alongside financial health, team capabilities, and growth readiness.