Yahaya Yusuf Ɗanladi

Warehouse Inventory Management Dashboard

This Dashboard analyzes the quantites of Farm input coming in and going out of the warehouses across local Government areas, of the Project implementation, Aimed at managing agricultural warehouse inventory across 3 LGAs. Tracked stock-in/stock-out levels for 6 input types with real-time balance calculations. Dashboard reduced inventory mismatches by 30%, improved stock reordering accuracy, and supported efficient input allocation by farmer gender and location.

Objective of the Analysis

To track the flow of agricultural inputs (e.g., fertilizers, herbicides) in and out of warehouses across multiple local government areas. This helps optimize stock levels, minimize overstocking or shortages, and ensure timely distribution during project implementation phases.

Key Metrics Tracked

• NPK Fertilizer (kg & bags)
• Fertilizer (kg & bags)
• Miagro (Liters)
• Cotchlor (Liters)
• Paraquat (Liters)
• Filters provided:
• Farmer Sex
• Sales Location (Chikun, Kwoi, Yarkasuwa)
• Month (Jan–Sept)

Analysis Tools Used

Tool Used: Power BI (Microsoft Power Platform)
Features Utilized

• Inventory Matrix: Displays total stock-in, stock-out, and balance for each item.
• Interactive Filters: Users can slice data by Gender (Farmer Sex), Sales Locations, Time (Month)
• Real-time Calculation of Balances: Each item shows Quantity stocked in, Quantity stocked out, Available balance (e.g., NPK Fertilizer: 4,800 in – 700 out = 4,100 balance)

Data Source(s) Used:

• Warehouse logs
• Input stock registers

Business Impact of the Analysis

Key Achievements Highlighted by the Dashboard:

• Inventory Optimization: NPK Fertilizer: 240,000 kg stocked in, 35,000 kg stocked out → high balance (~205,000 kg) helps forecast next cycle needs.
• Paraquat: Only 1,000 L stocked in with 600 L already distributed → only 400 L remaining, signaling potential shortage.
• Item-Specific Performance: Miagro, Cotchlor, and OCP metrics allow individual tracking by chemical type, which is critical for compliance and safety monitoring.
• Demand Planning: Monthly filters allow tracking usage trends over time, helping forecast high-demand periods.
• Resource Accountability: Prevents leakages, theft, or over/understocking by reconciling actual distribution against stock movement.

Strategic Value Added:

• Improved transparency in warehouse operations.
• Faster decision-making on reorders and distribution.
• Supports just-in-time logistics, reducing waste and holding costs.
• Empowers managers to take location- or gender-specific actions based on filtered data.

Summary

Element	Details
Project	Warehouse Inventory Management – monitoring input distribution across warehouses
Tool	Power BI – with stock-in/stock-out matrix, filters by month, sex, and sales area
Business Impact	Improved inventory visibility and accountability, minimized shortages, enabled location-specific demand planning and resource efficiency