akeDataAnalyst/specialty-coffee-pricing-analyzer

Coffee Pricing & Differential Analyzer that calculates fair purchase prices and suggested differentials for Ethiopian coffee lots. # Specialty Pricing & Differential Analyzer Data-Driven Pricing Intelligence for Ethiopian Specialty Coffee --- ## Project Description This is a professional Specialty Coffee Pricing & Differential Analyzer that calculates fair purchase prices and suggested differentials for Ethiopian coffee lots. --- ## Problem Statement - Specialty coffee pricing is often subjective and inconsistent. - Sourcing teams struggle to determine fair premiums for quality, traceability, sustainability, and origin. - Lack of standardized tools leads to overpaying or missing high-value lots. - Difficulty in justifying pricing decisions to suppliers and internal stakeholders. --- ## Solution An interactive Pricing & Differential Intelligence System that: - Calculates realistic differentials over NY ‘C’ futures - Factors in SCA score, region, traceability, certification, and EUDR compliance - Provides clear Buy / Negotiate / Pass recommendations - Offers detailed breakdown of each pricing component - Supports data-driven negotiation and sourcing strategy --- ## Tech Stack - **Language**: Python 3.9+ - **Core Libraries**: Pandas, NumPy - **Dashboard**: Streamlit - **Visualization**: Plotly Express - **Project Structure**: Clean modular `src/` architecture - **Pricing Engine**: Custom rule-based model with realistic market weights --- ## Developed by **Aklilu Abera** | **E2E Data Analyst**