The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Restaurant Food Cost & Menu Profitability Management System
I created a complete Excel-based management system for restaurants, cafés, bakeries, food trucks, and catering businesses to understand food costs, menu profitability, waste, labor allocation, and operating performance.
The system includes a professional executive dashboard, recipe costing, ingredient cost tracking, sales analysis, waste monitoring, monthly performance reporting, data-quality checks, and menu engineering using the STAR, PLOWHORSE, PUZZLE, and DOG framework.
It includes realistic synthetic data for 100 menu items, 300 ingredients, 2,000 sales records, and 12 months of historical activity. The workbook transforms operational data into clear recommendations such as Promote, Increase Price, Reduce Cost, Review Recipe, Keep, and Consider Removing.
Built for practical restaurant decision-making, the goal is to help operators identify which items drive profit, where food costs are eroding margins, and what actions should be prioritized next.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Trending
retrofuturism
Share your favorite designs from the past exploring the distant future. Or your own take on the aesthetic 🚀
halftone
Dots. Texture. Grain. Let's see your designs using the halftone technique.
Midjourney
Creatives are showing off what they're making with Midjourney.
colorgrade
Video editors sound off: How do you enhance the mood of your video in color grading?
Related posts
🚀 My First AI Automation Project with n8n
I recently built my first automation project — an AI-Powered Invoice Extraction & Tracking System.
The problem I wanted to solve was simple:
Imagine a business receiving dozens of invoices or cash memos every week. Someone has to open each file, read the information, and manually enter the vendor name, date, items, total amount, and category into a spreadsheet.
That’s repetitive, time-consuming, and easy to get wrong.
So I built a workflow where:
📂 An invoice is uploaded to Google Drive
→ 🤖 Gemini AI reads and extracts the invoice data
→ ⚙️ n8n processes and validates the information
→ 📊 The data is automatically added to Google Sheets
The best part?
No manual data entry. Just upload the invoice and the rest happens automatically.
While building it, I also worked with things like workflow triggers, loop control, API errors/retries, and handling multiple files.
For me, this project was less about simply “building an n8n workflow” and more about learning how AI + automation + data workflows can solve real business problems.
This is just my first step into AI automation, and I’m excited to build more practical systems like this.
If your business has a repetitive process that could be automated with AI, n8n, or data workflows, feel free to DM me. I’d be happy to discuss it.
#AIAutomation #n8n #Automation #ArtificialIntelligence #DataAnalytics #DataAnalyst #WorkflowAutomation #GenerativeAI #BusinessAutomation #AI
Smart pipeline! Have you added strict JSON schema validation after Gemini extracts the invoice fields? Found that it stops edge case hallucinations before the data ever hits Sheets.
Title:
Youth Skills Training Programme — Excel M&E Dashboard
Excel-based M&E analysis project covering data cleaning, formulas, PivotTables, charts and dashboard development.
Full Description:
Analysed a simulated youth training dataset using Excel to clean, structure and interpret programme data. Built PivotTables, charts, KPI summaries and an interactive monitoring dashboard to present attendance and assessment performance.
One thing I’ve learned from working with data is that the numbers are only the beginning. The real value comes from understanding the story behind them and turning that into action.