Menu Margins -22pp: 28 Loss-Making Dishes Out of 72

Gabriele: “revenues +12%, looking good”. Dashboard: 28 dishes margin <8%. Drill down into granularity, adjust, recover +6pp.

---

November 2023. Office of Ristorante Riviera, Porto San Giorgio, Italy.

Gabriele Santini, 52, who has owned a family restaurant on the Marche coast for twenty-eight years, has two Excel files open on his monitor. The first shows raw material costs from 2021, before the widespread price increases that hit the Italian restaurant sector. The second contains data updated to 2023.

The mixed grilled fish cost €14.20 in 2021, when it was sold for €32 with a 56% margin. Today the cost has risen to €22.40, the selling price is €34, and the margin has shrunk to 34%. The ravioli with butter and sage went from €3.80 to €5.60 in cost, but the price remained at €12: the margin dropped from 68% to 53%. The Black Angus steak cost €11.50, today €16.80; sold at €28 instead of €26, the margin has collapsed from 56% to 40%.

Gabriele picks up the calculator and does the math. On the grilled fish, cost increased 58% while the selling price only 6%: twenty-two percentage points of margin evaporated. On the steak, cost up 46%, price up 8%: sixteen points lost.

He leans back in his chair and breathes. He increased menu prices 6-8% on average; costs rose between 35% and 58%. He’s losing between fifteen and twenty-two percentage points of margin on every dish sold. The next question comes naturally: how much am I losing in total per month? And most importantly, which of the seventy-two dishes on the menu are the worst performers? Which ones can I save immediately?

Excel responds with an aggregated number: restaurant’s overall margin at 7.2%. Gabriele reads it aloud, alone in the office: “Seven point two. In 2021 I was at eighteen percent. But this number doesn’t tell me where I’m losing. Which dishes are killing me?”

This is the silent frustration of 127,000 Italian restaurateurs in the post-pandemic period. They know margins have collapsed, but the aggregated spreadsheet doesn’t tell them which specific dishes are eroding profits. They continue serving twenty, thirty dishes that lose money every night, thinking a full summer season equals profitability, while margins drop from 18% to 7% without understanding why.

The Hidden Problem: Excel Says “Overall OK”, Dashboard Says “28 Dishes Below Eight Percent”

The situation is common in family restaurants with revenues between €800,000 and €2 million (~$870,000-$2.2M USD). The quarterly financial statement from the commercialista (Italian CPA and business advisor) shows third quarter 2023 revenues of €242,000, up 12% compared to 2022. Raw material costs amount to €134,000. The gross margin is 45%, apparently in line with the industry benchmark of 40%.

The hidden reality emerges when you drill down into granularity per individual dish. Eighteen preparations maintain margins between 55% and 68%, excellent levels comparable to 2021. Twenty-six dishes range between 35% and 50%, acceptable margins although compressed. But twenty-eight dishes show margins below 8%: these are the losers, the ones eroding overall profitability.

The concrete impact for Ristorante Riviera: twenty-eight loss-making dishes sold 380 times per month, with an average negative margin of €2.80 per dish, equals a hidden loss of €4,270 per month, €51,240 per year burned serving preparations that cost almost as much as they’re sold for.

Aggregated Excel says “overall margin 45%” because the eighteen profitable dishes at 65% mathematically compensate for the twenty-eight losers at 5%. But Gabriele doesn’t know which ones to eliminate or reprice, because the aggregated data hides the granularity needed to make operational decisions.

The second problem concerns the temporal misalignment between cost variations and price adjustments. Gabriele updated the printed menu in March 2023 with average increases of 6-8%. Raw materials continued rising in subsequent months: oil up 12% in April, fish up 8% in June, meat up 15% in September. Excel shows aggregated costs for the closed month. When Gabriele sees “September: raw materials up €8,200 compared to budget,” 1,240 covers have already been served at wrong prices.

A vicious cycle kicks in. Materials rise in April, Gabriele discovers it in May from the closed month’s financial statement. He decides to raise prices and schedules the menu reprint for June, which requires four weeks between graphics and printing. Materials rise again in June, Gabriele discovers it in July. The menu printed in June is already outdated before being distributed. The result is continuous chasing without ever recovering the gap. Margins erode by 1-2 percentage points each quarter.

The third problem is blindness regarding compliance indicators. Gabriele, like 94% of restaurateurs, doesn’t monitor the DSCR (Debt Service Coverage Ratio) or the indices required by the CCII, Codice della Crisi d’Impresa e dell’Insolvenza (Italian Corporate Crisis and Insolvency Code) under Article 2086 of the Italian Civil Code. In September 2023 the commercialista calls: “Gabriele, I calculated the DSCR for the second and third quarters. You’re at 0.87. Below one means operating cash flow doesn’t cover debts. If this continues, you risk crisis alert.”

Gabriele’s response: “But why didn’t you tell me earlier?” The commercialista explains that he prepares quarterly financial statements and is communicating third quarter data just closed. The time gap is evident: the problem started in April, Gabriele discovers it in October, six months later, when margins have already eroded €25,000. The legal obligation under Article 2086 requires the administrator to continuously monitor financial balances. Quarterly statements are insufficient by law. Gabriele risks personal liability on his assets.

The emotional impact is clear in his words: “I work fourteen hours a day. In August the dining room is full, ninety-two covers on Saturday night, satisfied customers. I think things are going well. Then the commercialista tells me margin at 7%, DSCR at 0.87, crisis risk. I feel powerless: I see the numbers too late to act.”

This is the recognizable pain of 68% of Italian restaurateurs: discovering problems when they’ve already exploded, not when they’re still solvable.

The Solution: Integrated Financial Intelligence Platform

November 2023. Gabriele searches online for “restaurant margin control software” and finds Mentally.ai Copilot, an integrated financial intelligence platform specialized for small and medium-sized businesses in the restaurant sector. The system promises dashboards with margins per individual dish updated nightly instead of quarterly, automatic import of supplier invoices from the Cassetto Fiscale dell’Agenzia delle Entrate (Italian Revenue Agency’s Tax Drawer portal) every twenty-four hours, predictive cash flow based on machine learning to anticipate raw material trends 3-6 months in advance, what-if scenarios to simulate pricing strategies, and automatic continuous monitoring of CCII-required indices for Article 2086 compliance.

The cost is €99 per month. Gabriele thinks: “Too good to be true, but I’ll try fifteen days for one euro.”

Multi-Source Real-Time Dashboard

The technical operation is straightforward. Gabriele delegates one-time access to the Agenzia delle Entrate’s Cassetto Fiscale to Mentally.ai. Every night at 3 AM the system automatically downloads all supplier invoices: fish, meat, produce, wine, oil. It extracts line items one by one. An invoice shows “Sea bass twelve kilograms €166”: the system calculates €13 per kilo. It automatically associates the data with menu dishes: “Baked sea bass uses 0.35 kilograms,” so the cost is €4.55. Zero manual work from Gabriele. The system syncs every night.

Monday morning Gabriele opens the dashboard and sees dishes ordered by margin, from worst. The mixed grill at €34 has a real cost detected the previous day of €31.20: 8% margin, sold forty-two times last week, hidden loss of €966 per week. The mixed fried seafood at €28 costs €26.30: 6% margin, thirty-eight sales, loss of €1,064. The Angus steak at €28 costs €25.50: 9% margin, thirty-one sales, loss of €775. Overall twenty-eight dishes below 8% margin, 380 weekly sales, hidden loss of €4,270 per week.

Gabriele sees the flashing number. He thinks: “I’m losing €4,270 every week serving these twenty-eight dishes? €17,080 per month? €204,000 per year?”

The contrast between the two approaches is sharp. With traditional Excel, Gabriele waits for the commercialista’s quarterly statement, sees the overall aggregated margin at 45% which seems acceptable, doesn’t know which twenty-eight specific dishes below 8% are eroding profitability, continues serving them for 3-6 months and loses between €51,000 and €102,000. With the financial intelligence dashboard, Gabriele drills down into granular margins every Monday morning, sees the twenty-eight specific dishes with name, cost, sales and loss, and can act immediately: twelve dishes are repriced with increases between €3 and €5, bringing margin from 8% to 18%; eight dishes see substitution of the most expensive ingredient, like switching from Angus to Chianina with a saving of €4 per kilo; eight dishes are eliminated from the menu because they have low sales and are unrecoverable.

The metaphor is clear. Excel is a quarterly thermometer that says “you have a fever of 38 degrees” but doesn’t specify when it started. The dashboard is a real-time sensor that warns “temperature is rising now, take the fever reducer immediately.”

Temporal urgency makes the difference. Without a dashboard, Gabriele discovers in November that overall margin is at 7%, but October and November have already seen 760 loss-making dishes served for €8,540 burned. Actions start in December and recover only 2024, while 2023 is lost. With the dashboard, Gabriele drills down Monday morning in November, finds the twenty-eight dishes below 8%, acts Tuesday with repricing, and recovers from Thursday itself, saving €4,270 per week for the subsequent forty-eight weeks: €204,000.

Acting now instead of later means recovering forty-eight weeks of margins versus losing another 3-6 months for a total between €51,000 and €102,000.

Predictive Cash Flow and Strategic Scenarios

The system analyzes the eighteen-month history of supplier invoices imported from the Cassetto Fiscale and automatically detects patterns. Extra virgin olive oil increases 2-3% every quarter consistently, following the inflationary trend. Fresh fish shows spikes of 8-12% in July-August for seasonality reasons, then drops 5% in October. Angus beef is volatile with fluctuations of plus/minus 10-15% without recognizable pattern, depending on the global market.

In December the dashboard shows a predictive alert: “Extra virgin olive oil: trend +12% in the next three months with 87% confidence. Oil-intensive dishes, twelve total, will become marginal in January if prices remain unchanged.”

Gabriele explores the scenario conversationally, taking thirty seconds. He asks: “If oil rises 12%, which dishes go below 10% margin?” The system responds listing seven dishes: bruschetta would go from 15% to 8% margin, spaghetti aglio-olio from 18% to 9%, Mediterranean salad from 22% to 12%. The automatic suggestion is to increase these seven dishes by €1.50-€2 or reduce the oil portion by 15%.

Gabriele decides in December, three months in advance: increases five dishes by €2, reduces oil in two dishes. In January oil effectively rises 11%. Gabriele is already protected. Margins remain stable.

The contrast is once again temporal. With Excel, Gabriele discovers the price increase in January from the statement, loses margin in January and February, adjusts prices in March after two months of loss. With the machine learning-based predictive dashboard, he foresees the increase in December, adjusts prices in December, and records zero losses in January-February.

To test 2024 pricing strategies, Gabriele uses the parallel scenario functionality. He asks the dashboard to simulate three options: general menu increase of 8%; increase only on the twenty-eight loss-making dishes of 12%; elimination of the eight worst dishes and 10% increase on the other twenty. The system generates the three scenarios in forty seconds.

The first scenario brings average margin to 12.5%, reduces revenues by €18,000, estimates a 2.5% customer loss, and generates €82,000 net margin. The second scenario brings margin to 11.8%, reduces revenues by €8,000, estimates 1.2% customer loss, and generates €96,000 net margin. The third scenario brings margin to 13.2%, reduces revenues by €12,000, estimates 1.8% customer loss, and generates €104,000 net margin.

The third scenario is best: €24,000 more than the current situation. Gabriele decides to eliminate the eight worst dishes, replacing them with less expensive variants of the mixed grill and fried seafood, and increases the other twenty by €2-3. The new menu is printed in January 2024.

The contrast is methodological. With Excel, Gabriele would try a strategy “by feel” and discover results after three months; if the strategy were wrong, he’d lose a quarter. With the dashboard, he simulates three parallel strategies in forty seconds, chooses the best before even printing the menu.

Automatic Monitoring of Adeguati Assetti

The dashboard automatically calculates weekly, not quarterly, the indicators required by Article 2086 of the Italian Civil Code. The DSCR results at 0.87, below the threshold of one signaling alert. Financial burden sustainability is at 8.2%, below 10% and therefore acceptable. The equity-to-assets ratio is at 18%, positive. Average delay in supplier payments is twelve days, within limits.

In October 2023 an automatic alert arrives: “DSCR dropped to 0.87, below threshold of one. Operating cash flow is insufficient to cover debts. Crisis alert risk under CCII. Suggested actions: increase menu margins by repricing loss-making dishes to generate additional flow of €4,270 per week; reduce short-term debts by €18,000 by negotiating deferrals with suppliers; monitor trend in the next sixty days.”

Gabriele sees the alert in October, not December as the commercialista would have communicated. He acts immediately: reprices the twenty-eight dishes as previously described, generating additional cash flow of €17,080 per month; negotiates deferrals with the three main suppliers from thirty to forty-five days, freeing €12,000 liquidity buffer. In December DSCR rises to 1.12, above the threshold of one, returning to healthy territory.

Compliance and Intelligence: Two Complementary Approaches

Many restaurateurs ask: “But doesn’t the commercialista already do these things?” The answer distinguishes between compliance and intelligence. The commercialista does compliance: certifies that the past was recorded correctly. Mentally.ai does intelligence: strategically predicts the future. The two approaches are complementary, not competing.

Compliance prepares certified quarterly and annual financial statements, prepares tax returns for IVA (Italian VAT), IRES (Italian corporate income tax) and IRAP (Italian regional production tax), produces reports validated according to standard accounting procedures, and certifies that historical data is correct. The question it answers is: “Do past financial statements comply with tax and accounting regulations?” The value is essential from a legal standpoint, mandatory by law, and guarantees accuracy. The limitation is it looks at the past: you discover problems after they’ve happened.

Intelligence produces real-time dashboards with granular margins, applies machine learning-based predictive cash flow with 3-6 months advance notice, generates what-if scenarios to test multiple strategies in parallel, sends automatic alerts on anomalous trends, and continuously monitors CCII indices. The question it answers is: “What will happen in the next 3-6 months if the trend continues? How can I act now?” The value is strategic and decisional, with a proactive and predictive approach. The limitation is it doesn’t replace the commercialista’s legal certification.

Gabriele’s concrete example clarifies the complementarity. In October 2023 margins collapse. The commercialista calculates the third quarter financial statement, July-September, and in November communicates: “Third quarter margin at 7.2%, DSCR at 0.87.” The certification is correct, but Gabriele discovers in November, sixty days after the end of September. Mentally.ai, with the dashboard updated every Monday, sends an alert in September: “Margin trending from 8% to 7%, DSCR toward values below one within thirty days.” Gabriele sees the data in September in real-time, acts in October by repricing dishes, and DSCR recovers. When the commercialista prepares November’s financial statement, he certifies a DSCR of 1.8, confirming that the actions taken worked.

Both are necessary. Mentally.ai predicts the problem in September, Gabriele acts in October. The commercialista certifies the results in November, producing correct financial statements for the bank and tax authorities. The automotive metaphor is effective: the commercialista is the annual car inspection, which certifies that brakes and tires were in order last year. Mentally.ai is the ABS system with real-time sensors that warn of an obstacle ahead and allow you to brake now. You don’t choose one or the other. You have both.

Transformation: From Blind to Complete Control

Before implementing the dashboard, Gabriele managed the restaurant with quarterly statements from the commercialista, overall aggregated margins without dish-level granularity, and discovered problems sixty-ninety days after they emerged, too late for effective interventions. In November 2023 overall margin was at 7.2%, DSCR at 0.87 in alert status, average collection days 110, hidden losses €204,000 per year due to twenty-eight dishes below threshold. Gabriele summarized the situation: “I feel like I’m losing money, but Excel says overall margin is 45% and seems ok.”

After implementing Mentally.ai, by February 2024 management changed. The dashboard shows real-time margins per individual dish, the Cassetto Fiscale is imported automatically every night, machine learning-based predictive cash flow anticipates trends by 3-6 months, what-if scenarios allow testing pricing strategies, and continuous weekly monitoring of CCII indices ensures compliance.

The actions implemented between November and January were five. Twelve dishes were repriced with increases between €2 and €4, bringing margin from 8% to 16%. Eight dishes were eliminated from the menu as unrecoverable. Eight dishes saw substitution of most expensive ingredients, like switching from Angus to Chianina with €4 per kilo savings. The menu was reduced from seventy-two to thirty-eight dishes, concentrating the offering on high-margin items. Preventive dynamic pricing on materials was introduced: the 12% oil increase was compensated in December before impacting January margins.

Results in February 2024 show overall margin risen to 13.8%, 6.6 percentage points higher than the starting 7.2%. DSCR is at 1.18, above the threshold of one and therefore in healthy territory. Average collection days dropped to fifty-two thanks to early payment discounts offered to corporate customers. Hidden losses of €204,000 per year were recovered: the twenty-eight formerly loss-making dishes are now profitable or have been eliminated. Gabriele summarizes: “I drill down into margins every Monday for ten minutes, adjust prices when necessary, predict price increases three months ahead. I have complete control.”

The return on investment over twelve months is quantifiable. Direct recoveries include €204,000 per year from margins of the twenty-eight optimized dishes, €18,000 from preventive pricing on materials that avoided losses from unforeseen trends, and €28,000 time value from reduction of collection days from 110 to fifty-two. Total recovered is €250,000 per year. The investment for Mentally.ai Copilot is €99 per month for twelve months, equal to €1,188 per year, plus initial setup for Cassetto delegation and data import, included in the service therefore zero cost. The ratio is €250,000 divided by €1,188: 210 times the investment. Considering only the margins of the twenty-eight dishes and excluding other benefits, the conservative calculation is €204,000 divided by €1,188: 172 times.

The incalculable value concerns the DSCR passage from 0.87 to 1.18, which equals having avoided the crisis risk and potential closure of a business with twenty-eight years of history. Automatic Article 2086 compliance protects Gabriele’s personal liability. And Gabriele sleeps soundly because he knows the situation in real-time, without waiting for the commercialista’s quarterly statement.

Conclusion: From Feeling to Knowing

Gabriele today, March 2024, describes the transformation in these terms: “Before November 2023 I felt I was losing money, but Excel said overall margin was 45% and seemed ok. I didn’t know where I was losing, how much I was losing, which dishes were responsible. I discovered problems a quarter later, too late. After Mentally.ai I drill down into the dashboard Monday morning for ten minutes, see exactly which are the twenty-eight dishes below 8% margin, adjust prices on Tuesday, recover €4,270 per week from Thursday. I investigate raw material trends, predict price increases three months ahead, protect margins preventively. I no longer wait for the commercialista’s quarterly statement. I know in advance what’s going wrong, act now when it’s still solvable, not after when the crisis has exploded. The difference is between feeling discomfort, which is negative and reactive, and knowing the numbers, which is positive and proactive. I have complete control of twenty-eight years of the family restaurant business.”

The status quo without action would have brought 2024 margins from 7% to 5%, because raw materials continue rising and prices chase. In 2025 DSCR would have dropped below 0.8, formally activating crisis alert under CCII. In 2026 the risk would have been closure of twenty-eight years of business. With Mentally.ai, in 2024 margins rise from 7% to 14% thanks to continuous dashboard optimization. In 2025 freed liquidity allows investing in a veranda that increases covers by 25%. In 2026 opening a second restaurant in a tourist location is planned, replicating the control model that worked. The cost of inertia would have been losing twenty-eight years of family history.

---

Note on Offering

Mentally.ai Copilot includes real-time dashboards, automatic Cassetto Fiscale import, predictive cash flow, what-if scenarios, CCII monitoring and automatic alerts. Setup requires twenty minutes: Agenzia delle Entrate Cassetto Fiscale delegation, bank account connection via PSD2 API, menu import from Excel. The following Monday morning the first granular margins are visible.