# Inventory Management for Nigerian Retailers: Stop Losing Money to Bad Stock "I threw away ₦85,000 worth of expired drinks last month." "Thieves stole ₦120,000 from my shop." "My bestseller was out-of-stock for 2 weeks - lost ₦200K in sales!" Sound familiar? Bad inventory management is the **silent profit killer** in Nigerian retail. This guide shows you how to fix it. ## The Hidden Cost of Bad Inventory Most retailers focus on sales. But profit leaks happen in the **stockroom**: ### Typical Inventory Losses: ``` Expiries/Spoilage: 5-15% of inventory Theft (staff/customers): 3-8% Overstocking slow items: 10-20%% Stock-outs (lost sales): 15-25% TOTAL LOSS: 33-68% potential profit! ``` **Example:** ``` Monthly Revenue: ₦1,000,000 Expected Profit (30%): ₦300,000 But losses: Expiries: ₦50,000 Theft: ₦30,000 Overstock: ₦40,000 Stock-outs: ₦80,000 ACTUAL PROFIT: ₦100,000 (60% less!) ``` ## The 5 Inventory Problems (And Solutions) ### Problem 1: Not Knowing What You Have **Symptoms:** - Customer asks for product - you search for 10 minutes - You buy stock you already have - Can't remember what's running low **Real Story:** Chibuzor's phone shop, Aba. Bought 50 phone chargers because he "thought stock was low." Found 80 chargers in backroom. Wasted ₦120K on excess stock he couldn't sell fast. **Solution: Physical Stock Count** **Weekly Quick Count (30 minutes):** 1. Count fast-moving items only (top 20 products) 2. Write down numbers 3. Compare with last week **Monthly Full Count (2-3 hours):** 1. Count EVERYTHING 2. Check for damages/expiries 3. Update records **Use BosApp:** Scan products, instant inventory count, know exactly what you have! ### Problem 2: Expired/Damaged Goods **The Nightmare:** You discover ₦150K worth of expired drinks hiding behind fresh stock. Total loss. **Why It Happens:** - New stock placed in front (old stock hidden at back) - No expiry tracking system - Staff doesn't rotate stock **Solution: FIFO System (First In, First Out)** ``` WRONG WAY: New stock → Front of shelf Old stock → Stays at back → EXPIRES! RIGHT WAY: New stock → Behind old stock Old stock → Front (sells first) ``` **Daily Check:** - Products with under 3 months expiry → FRONT + Discount sticker (10-20% off) - Products with under 1 month expiry → AGGRESSIVE DISCOUNT (30-50% off) - Expired → Throw away (or return to supplier if possible) **Pro Tip:** Check expiry dates BEFORE buying from supplier! ### Problem 3: Theft **Reality Check:** 30% of inventory theft is by **STAFF**, not customers. **Common Theft Methods:** **Staff:** - Selling products, pocketing cash (no record) - Fake "damages" (mark good items as damaged, take home) - Shortchanging customers, keeping difference **Customers:** - Shoplifting small items - Switching price tags - Distracting staff, grabbing goods **Solution: 7 Anti-Theft Measures** 1. **CCTV (₦15K-₦50K):** Even fake camera reduces theft 60%! 2. **Daily Cash Reconciliation:** ``` Morning: Count cash + inventory value = ₦500,000 Evening: Count cash + inventory value = Should be ₦500,000 + profit If doesn't match → INVESTIGATE! ``` 3. **Random Bag Checks:** Staff knows you check bags = Less tempted 4. **Mirrors:** ₦2,000 corner mirrors show blind spots 5. **Track "Damages":** No product damaged more than 1-2/month (suspicious if more) 6. **Two-Person Receiving:** One counts, one records (prevents fake shortage claims) 7. **POS/Record Everything:** Every sale recorded = Harder to steal **Hard Truth from Traders:** "After installing CCTV, my monthly 'shortage' dropped from ₦40K to ₦5K. It was my own sales girl!" ### Problem 4: Overstocking Slow Items **The Trap:** Supplier offers discount: "Buy 100, get 10% off!" You buy... product doesn't sell fast... capital stuck! **Danger Signs:** - Item sitting for 3+ months - Dust on packaging - Can't remember last time it sold **Solution: ABC Inventory System** **Category A (Fast-Moving - 20% of products, 80% of sales):** - Examples: Bread, soft drinks, rice, detergent - **Stock Level:** 2-3 weeks supply - **Reorder:** When 50% remaining - **Capital:** 60-70% of inventory budget **Category B (Medium - 30% of products, 15% of sales):** - Examples: Canned foods, toiletries, noodles - **Stock Level:** 3-4 weeks supply - **Reorder:** When 30% remaining - **Capital:** 20-25% of budget **Category C (Slow-Moving - 50% of products, 5% of sales):** - Examples: Specialized items, seasonal goods - **Stock Level:** 1-2 units only - **Reorder:** After sale - **Capital:** 5-10% of budget **Example:** ``` Bad Inventory (Equal stock of all): Fast Item A: 20 units (sells 5/day) = 4 days supply → Stock-outs! Slow Item C: 20 units (sells 1/week) = 20 weeks supply → ₦50K stuck! Smart Inventory: Fast Item A: 50 units = 10 days supply → Never out of stock Slow Item C: 2 units = 2 weeks supply → Capital free! ``` ### Problem 5: Stock-Outs (Running Out) **The Pain:** Customer: "Do you have Peak Milk?" You: "Finished! Come tomorrow." Customer: Goes elsewhere. You lose ₦500 sale. Multiply by 10 customers/day = ₦5k lost. Monthly: ₦150K! **Why It Happens:** - Forgot to reorder - Reordered too late (waiting for stock to finish completely) - Supplier delays **Solution: Reorder Point System** **Formula:** ``` Reorder Point = (Daily Sales × Lead Time) + Safety Stock Example: Peak Milk Daily Sales: 10 tins Supplier Lead Time: 3 days (order Monday, arrives Thursday) Safety Stock: 5 tins (buffer) REORDER POINT: (10 × 3) + 5 = 35 tins When stock hits 35 tins → REORDER IMMEDIATELY! ``` **BosApp Feature:** Automatic low-stock alerts! App notifies you when items hit reorder point. ## The 30-Minute Daily Inventory Routine ✅ **8:00 AM - Opening Check (10 mins):** - Count cash - Quick scan for tampering/theft - Note any damaged items ✅ **Throughout Day - Recording (ongoing):** - Every sale recorded (POS or BosApp) - Every new stock received noted ✅ **7:30 PM - Closing Check (15 mins):** - Count cash - Compare with records -Check fast-moving items (need reorder?) - Rotate stock (FIFO) ✅ **End of Day - Analysis (5 mins):** - Which items sold most? - Any unusual shortages? - Tomorrow's restock needs? **Total Time:** 30 minutes **Result:** Zero surprises, maximum control! ## Real Business Transformation ### Before Good Inventory System: ``` Monthly Revenue: ₦800,000 Losses: Expiries: ₦60,000 Theft: ₦40,000 Stock-outs (Lost sales): ₦120,000 Over stock (Capital stuck): ₦100,000 NET PROFIT: ₦180,000 (22.5%) ``` ### After Implementing System: ``` Monthly Revenue: ₦950,000 (fewer stock-outs!) Losses: Expiries: ₦8,000 (FIFO system) Theft: ₦12,000 (CCTV + checks) Stock-outs: ₦20,000 (Reorder points) Overstock: ₦15,000 (ABC system) NET PROFIT: ₦345,000 (36.3%) PROFIT INCREASED: 92%! ``` ## Tools for Inventory Management ### Option 1: The Notebook (Free) **Setup:** - One notebook for inventory - Columns: Item | Opening | Added | Sold | Closing | Reorder Point **Daily:** - Record sales - Update closing balance **Pro:** Free, simple **Con:** Slow, mistakes, hard to analyze ### Option 2: Excel (Free) **Setup:** - Create spreadsheet - Formulas auto-calculate **Pro:** Automatic calculations **Con:** Requires computer, time-consuming data entry ### Option 3: BosApp (₦1,500-₦5,000/month) **Setup:** - Add products once - Scan/click to record sales **Pro:** - Automatic tracking - Low-stock alerts - Expiry reminders - Theft detection (spot discrepancies) - Reports (best/worst sellers) **Con:** Small monthly cost **ROI:** If BosApp costs ₦3K/month but stops ₦50K in losses → Saves ₦47K! ## Common Mistakes to Avoid ❌ **"I'll count stock when I have time"** → Time never comes. Schedule weekly! ❌ **"I trust my staff completely"** → Trust, but verify. Even honest people tempted sometimes. ❌ **"I buy what supplier offers (discount!)"** → Only buy what SELLS. Discount meaningless if stock sits! ❌ **"Customers will understand if out of stock"** → They'll understand... by going elsewhere! ❌ **"Small items don't matter"** → ₦100 sweets × 500/month + theft = ₦50K loss! ## Advanced: Inventory Turnover Ratio **What It Measures:** How fast you sell inventory **Formula:** ``` Inventory Turnover = Cost of Goods Sold ÷ Average Inventory Example: Monthly COGS: ₦600,000 Average Inventory Value: ₦200,000 Turnover = ₦600K ÷ ₦200K = 3× per month You sell entire inventory 3 times/month. ``` **What's Good?** - Groceries/Food: 8-12× per month (fast spoilage) - General provisions: 4-6× per month - Electronics: 2-3× per month - Clothing: 2-4× per month **Low turnover?** You're overstocking! **High turnover?** You might be under-stocking (missing sales). ## Action Plan ### This Week: - [ ] Do full inventory count (know your starting point) - [ ] Identify your top 10 bestsellers (Category A) - [ ] Check all products for expiry dates (front-position anything under 3 months) - [ ] Set reorder points for top 10 items ### This Month: - [ ] Implement daily 30-minute routine - [ ] Install anti-theft measures (at least mirrors + daily reconciliation) - [ ] Start using inventory tool (notebook minimum, BosApp recommended) - [ ] Review slow-moving items (discount or stop restocking) ### This Quarter: - [ ] Reduce expiry waste by 80% - [ ] Eliminate stock-outs on bestsellers - [ ] Increase inventory turnover ratio - [ ] Free up ₦50K+ capital from slow-stock ## Final Thought "You can't manage what you don't measure." Every ₦1 wasted on bad inventory is ₦1 stolen from your profit. Get control of your inventory. Watch profit soar. --- **Ready to eliminate inventory waste?** BosApp tracks stock automatically, alerts you on low inventory, and shows exactly what's selling. **Try Free for 30 Days:** [https://bosapp.ng/register](https://bosapp.ng/register)