Equal Food — Pricing Engine Dashboard

Week 12, 2026 · Last cost update: Thu 19/03/2026 · Internal use only
Workflow
Pricing Output
Automation Roadmap

Weekly Pricing Workflow

Thursday PM → Friday PM cycle. Steps flagged by automation status.

Total Steps
8
Automated
1
Formula-based
To Automate
4
PDF, Slack, Email, Log
Manual / Semi
3
Cost input, Review, Confirm
1
Update cost prices Manual → API
Thu PM · Owner: Procurement
Import from supplier invoices or ERP
2
Pricing Engine recalculates Auto (formulas)
Thu PM · Owner: System
Excel formulas run instantly on cost change
3
Review flagged items (>5% change) Semi-auto
Fri AM · Owner: João / Pricing
Filter ⚠ flags in Pricing_Engine tab
4
Generate PDF price lists per client To Automate
Fri AM · Owner: System
Python script: Excel → PDF per group
5
Send Slack notification for approval To Automate
Fri AM · Owner: System
Slack API: post to #pricing-approvals
6
Team confirms in Slack Manual (click)
Fri AM–PM · Owner: Sales / Management
React with ✓ or request changes
7
Send confirmed PDFs via email To Automate
Fri PM · Owner: System
Gmail API: triggered by Slack confirmation
8
Log sent prices to history To Automate
Fri PM · Owner: System
Append to Price_History sheet
Automated Semi-automated Manual To automate

Price Changes by Restaurant Group

Week 12 vs. previous week. Items flagged ⚠ have price swings >5%.

Price Change % by Product

Cost vs Client Price

Detailed Price Table

Product Category Cost (€) Margin % Client Price (€) Prev Price (€) Δ (€) Δ % Flag

Automation Roadmap

Technical specification and timeline for pricing automation.

P0
Margin Analysis
Calculate current % and nominal margins per client × product from historical orders
Week 1
P0
Pricing Model
Excel engine with formula-based price calc (this file)
Week 1
P1
Cost Price Feed
Script/API to update Cost_Prices tab from ERP / supplier data
Week 1
P1
PDF Generator
Python script: read Pricing_Engine → generate branded PDF per client
Week 2
P1
Slack Integration
Bot posts to #pricing channel with client name + PDF + approve/reject buttons
Week 2
P2
Email Automation
On Slack approval → send email with PDF to client contact list
Week 2
P2
Price History Log
Append weekly prices to historical sheet for trend analysis
Week 2
P3
Dashboard
Summary view: margin health per client, price change trends
Week 3+
Equal Food · Internal Pricing Dashboard · Generated from pricing_engine_v1.xlsx