Aliyu-HaidarX11/PHL-Zero-Strategic-Business-Intelligence-for-Cold-Chain-Infrastructure-in-Nigeria

Project Overview This project serves as a comprehensive Investment Feasibility Study and data-driven analysis of Post-Harvest Loss (PHL) within the Nigerian agricultural sector. By leveraging data to model the impact of cold storage infrastructure, this repository demonstrates how structural inefficiencies can be converted into high-yield commercial opportunities while significantly reducing national food import dependency. The Economic Problem Nigeria loses approximately 40–50% of its perishable crops between the farm gate and the consumer. This creates a dual-crisis: Macro-Economic: The Federal Government spends billions in foreign exchange (FX) to import food to cover the "waste gap." Micro-Economic: Extreme price volatility where prices spike by 200-300% during the off-season. The "Big Three" Commodity Focus The analysis focuses on three specific crops, each representing a unique market dynamic: Tomatoes: High-volume, immediate-rot risk. Focus on waste mitigation. Onions: Long-term storage potential. Focus on seasonal price arbitrage. Irish Potatoes: Industrial processing potential. Focus on value-chain optimization. Deep Dive: The Irish Potato Value-Chain A centerpiece of this study is the Plateau State-to-Urban Market corridor (Lagos/Abuja). The Problem: Ambient temperatures ($25^{\circ}\text{C}+$) lead to rapid sprouting and weight loss, causing a 40% loss of marketable yield. The Solution: Implementation of modular 100-ton cold hubs maintained at $4^{\circ}\text{C}$. The Data Result: My model projects a reduction in wastage from 40% to 5%, effectively increasing marketable yield by 35% without increasing land use. This enables a consistent supply for the growing industrial "French Fry" and processing sectors. Key Insights & Dashboards Cost-Benefit Analysis (CBA): A dynamic model calculating the Break-Even Point (BEP) for cold storage investments based on energy costs (kWh) vs. seasonal price premiums. Supply-Demand Arbitrage: Time-series vi …