A real-world Python + SQLite business management system built for Chicken Brothers — a catering business specializing in chicken portions, wors rolls, and chips. Tracks inventory, catering events, sales, expenses, capital contributions, and profit reports.
- ✅ Event/Catering Management — create and track catering jobs
- ✅ Inventory Tracking — whole chickens, wors, spices, charcoal, chips, rolls
- ✅ Low Stock Alerts — notified on startup when stock is running low
- ✅ Sales Recording — ¼ chicken, ½ chicken, wors rolls, chips, combos
- ✅ Capital Contributions — log how much each of the 3 owners contributed
- ✅ Expense Tracking — per event or general business expenses
- ✅ Profit Reports — income vs expenses per event + overall summary
- ✅ SQLite Database — no server needed, data persists locally
- ✅ 7 Unit Tests — pytest test suite
git clone https://github.com/CodesbyNeo/chicken-brothers.git
cd chicken-brothers
python app/main.pyNo installation needed — uses Python standard library only!
python app/main.py- Create Event → enter name, date, location
- Log Contributions → each owner enters how much capital they put in
- Use Stock → record what ingredients were used
- Record Sales → enter quantities of each item sold
- View Profit Report → see income, expenses, and net profit
| Table | Purpose |
|---|---|
inventory |
Stock items with quantities and low-stock thresholds |
events |
Catering jobs with date, location, status |
contributions |
Capital contributed per owner per event |
sales |
Items sold per event with quantities and prices |
expenses |
Costs recorded per event or general |
stock_usage |
Ingredients used per event |
python -m pytest tests/ -v📊 PROFIT REPORT — Community Braai June 2024
═════════════════════════════════════════════
💵 Total Sales Income : R2,450.00
💸 Total Expenses : R1,100.00
─────────────────────────────────────────────
📈 Gross Profit : R1,350.00
💰 Owner Contributions : R900.00
─────────────────────────────────────────────
🏦 Net to Business Acct : R450.00 ✅
═════════════════════════════════════════════
MIT