Issue #15: The Predictable Profit System" - How to use simple data systems to forecast sales, control costs, and guarantee profitability

Act as a top-tier restaurant CFO. I need to diagnose the health of my prime cost. Here is my data for the last month:
•Total Sales: [e.g., $85,000]
•Cost of Goods Sold (COGS): [e.g., $28,000]
•Total Labour Cost (including all taxes & benefits): [e.g., $25,000]
Now, perform the following analysis:
1. Calculate my Prime Cost as a percentage. Show the formula and the result.
2. Benchmark my performance. Based on the 2025 standard of 55%, tell me if I am on track, borderline, or in the danger zone. Calculate the exact number of dollars I am over or under the target.
3. Break down the components. Calculate my Food Cost Percentage and my Labour Cost Percentage separately.
4. Provide an initial diagnosis. Based on the breakdown, which area (Food Cost or Labour Cost) seems to be the bigger problem? Suggest the top 2 most likely reasons for the high cost in that area.

Act as a data scientist for my restaurant. I need a sales forecast for next week to help with my staff scheduling and food ordering. Here is my sales data for the last 4 weeks for the same day of the week:
•Day of the Week: [e.g., Friday]
•Week 1 Sales: [e.g., $4,500]
•Week 2 Sales: [e.g., $4,800]
•Week 3 Sales: [e.g., $4,700]
•Week 4 Sales: [e.g., $5,100]
Also, consider these external factors:
•Next Week's Weather Forecast: [e.g., Sunny and warm, 22°C]
•Local Events: [e.g., Major concert at the nearby arena]
•Holidays/Special Occasions: [e.g., None]
Now, provide a sales forecast for next [e.g., Friday]. Explain your reasoning, factoring in the historical trend and the external factors. Give me a single number forecast and a potential range (e.g., a conservative and optimistic estimate).

Act as a restaurant efficiency expert. I have been using a waste log for the past week. Here are the top 5 items we wasted, the Quantity, and the Reason:
1. Item: [e.g., Avocado], Quantity: [e.g., 12 units], Reason: [e.g., Over-ripened/Spoilage]
2. Item: [e.g., Salmon Fillet], Quantity: [e.g., 5 portions], Reason: [e.g., Cooked incorrectly/Mistake]
3. Item: [e.g., Sourdough Loaf], Quantity: [e.g., 8 loaves], Reason: [e.g., Over-prepped/Stale]
4. Item: [e.g., Chicken Wings], Quantity: [e.g., 3 portions], Reason: [e.g., Sent back by customer]
5. Item: [e.g., Milk], Quantity: [e.g., 4 litres], Reason: [e.g., Expired]
Analyse this data and provide me with a report that includes:
1. The Top 3 Waste Categories: Group the waste into categories (e.g., Spoilage, Kitchen Error, Over-preparation).
2. The Root Cause: For each category, suggest the most likely root cause of the problem.
3. Actionable Solutions: For each root cause, provide one simple, actionable step I can take this week to fix it.

Act as my AI-powered Director of Operations. I will provide you with daily data points from my restaurant. Your job is to synthesise them into a 3-point executive summary.
Today's data:
Sales vs. Labour Cost: [INSERT]
Customer Feedback: [INSERT: e.g., '3 positive reviews mentioning the new special, 1 negative review about slow service']
Staff Notes: [INSERT: e.g., 'Server C called in sick, Manager A covered the shift']
Inventory Alerts: [INSERT: e.g., 'Low on salmon for tonight's service']
Generate a summary that tells me:
One Big Win: What went right yesterday?
One Area for Attention: What potential issue needs my strategic input (not my direct intervention)?
One Proactive Question: What should I ask my manager today to empower them?
My goal is to stay informed without getting sucked into the operational weeds. Keep the summary high-level and strategic.

Act as my labour cost analyst. I want to understand how efficient my kitchen is. Here is the data for a specific hour of service:
•Time Period: [e.g., Friday, 7 PM - 8 PM]
•Food Sales During that Hour: [e.g., $900]
•Number of Kitchen Staff Working: [e.g., 4]
Calculate my Dollars Per Labour Hour (DPLH) for the kitchen. Then, tell me what this number means. Is it high or low? (Assume an industry benchmark of $150-$200 DPLH for an efficient kitchen). Suggest one Strategy to improve this number without simply cutting staff.

Act as my restaurant's financial planner. I need to create my first simple annual budget. My goal is to achieve a 15% net profit margin.
My projected annual sales are: [e.g., $1,000,000]
Create a simple percentage-based annual budget for me, breaking down the following categories:
•Prime Cost: (Target 55%)
•Cost of Goods Sold: [Suggest a split, e.g., 28%]
•Total Labour Cost: [Suggest a split, e.g., 27%]
•Operating Expenses: [Suggest a percentage, e.g., 25%]
•Marketing: [Suggest a percentage, e.g., 5%]
•Net Profit: (Target 15%)
For each category, provide a brief, one-sentence explanation of what is included in it."

Act as a business coach. I am a restaurant owner who tends to make decisions based on gut feel. I want to become more data-driven, but I find it overwhelming. I have a decision to make:
Decision: Should I launch a new lunch service?
My gut says: 'Yes, it could bring in more revenue.'
Coach me through this decision by asking me 5 powerful questions that force me to look for data to support my decision. The questions should help me calculate the potential costs, revenue, and break-even point for this new service.