School Inventory Management: Stop Losing Track of Supplies
I visited a school with 15 boxes of printer paper in storage. They had been ordering paper every month because nobody knew how much they already had. They had enough to last 8 months — Rs 15,000 sitting in boxes while spending Rs 2,500/month on paper they did not need.
This is a small example of a big problem. Most schools have no system for tracking supplies, equipment, and materials.
Why inventory matters
- Cost savings: Avoid duplicate purchases and negotiate better prices
- Operational efficiency: Staff always have the supplies they need
- Reduced waste: Track expiration dates and usage
- Asset protection: Know where expensive equipment is
- Budget planning: Accurate data helps forecast next year's needs
What to track
Category A: High-value (track individually)
- Computers, laptops, tablets
- Projectors and screens
- Laboratory equipment
- Sports equipment
- Library books
- Furniture
Category B: Medium-value (track by quantity)
- Office supplies
- Cleaning supplies
- Printer cartridges
- Teaching materials
- Art supplies
Category C: Low-value (track loosely)
- Chalk, markers, dusters
- Cleaning rags
- Small stationery
Simple spreadsheet system
Sheet 1: Item master list | Item | Category | Location | Quantity | Reorder Level | Unit Cost | Last Ordered |
Sheet 2: Purchase log | Date | Item | Quantity | Cost | Supplier | Received By |
Sheet 3: Usage log | Date | Item | Quantity | Used By | Purpose |
Process: Add to purchase log when purchased, update master list. Add to usage log when used, update master list. When quantity drops below reorder level, trigger purchase. Takes 30 minutes per week.
Reorder system
Step 1: Set reorder levels — Minimum quantity that triggers reorder based on usage rate and lead time.
Step 2: Set par levels — Maximum quantity to prevent over-ordering.
Step 3: Assign responsibility — One person monitors inventory and places orders.
Physical counts
Full count: Once per semester — count every item, compare with records, investigate discrepancies.
Spot checks: Monthly — count 5-10 random items, verify accuracy.
Annual audit: Complete audit with documentation, report to management, plan next year's budget.
Real results
School profile: 300 students, annual supply budget Rs 600,000
Before: Duplicate purchases Rs 40,000/year, emergency purchases Rs 25,000/year, lost items Rs 15,000/year. Total waste: Rs 80,000/year (13%)
After: Duplicates Rs 5,000/year, emergency Rs 8,000/year, lost Rs 3,000/year. Total waste: Rs 16,000/year (2.7%)
Annual savings: Rs 64,000 — system cost Rs 36,000/year, net savings Rs 28,000.
Starting small
1. List everything you have — one afternoon walking through your school 2. Set reorder levels for top 20 items — the ones you use regularly 3. Assign one person to manage inventory
The bottom line
Inventory management saves real money. Schools that track supplies avoid waste, reduce costs, and ensure staff always have what they need. Start with a spreadsheet, assign responsibility, count regularly, and watch your budget stretch further.
