gridmoo
Cafe Bean Costing Lab.xlsx
Avg Cup Cost $1.68
Milk Sensitivity +8%
Drinks Priced 24
Drink Beans g Milk ml Margin
Flat White18180$3.22
Latte18220$3.46
Mocha18200$3.94
Drink Costing Bean & Milk Master Margin Dashboard Price Card Print +17

Spreadsheet Preview

Drink Costing · 21 sheets

Fully Unlocked Decision-Ready
Audience: Cafe owners, coffee roasters, and operators running milk-based drink menus Purpose: See true cup cost, margin by drink, and where bean or milk price changes hit profitability first.
Drink Costing
Drink Beans g Milk ml Margin
Flat White 18 180 $3.22
Latte 18 220 $3.46
Mocha 18 200 $3.94
Drink Costing Bean & Milk Master Margin Dashboard Price Card Print Assumptions Lookup Tables

Preview of key cells included in this spreadsheet template.

Coffee Shop

Pro Deeper analytics + scenario intelligence

Cafe Bean Costing Lab

Specialty coffee costing system for espresso drinks, milk-heavy beverages, takeaway packaging, and blended menu pricing. See how a $0.50 cup price change or bean supplier switch affects monthly profit.

$11.00 Secure payment via Stripe. 7-day review window — not right for you? Contact us.
✓ Own it forever
No monthly fees. Buy once and it's yours — every formula, every dashboard. Works in Excel, Google Sheets, or Numbers.
✓ Decisions, not data entry
KPI dashboards, stats engine, traffic-light alerts, and 12-month forecasting — all formula-driven and connected.
✓ Your rules, your system
Every formula is unlocked. Every target is editable. Customise thresholds, KPIs, and workflows to match how you work.
✓ Ready from day one
Guided START HERE sheet, sample data, print-ready reports. If you can use Excel, you can run your business with this.

Included sheets

Drink Costing Bean & Milk Master Margin Dashboard Price Card Print Assumptions Lookup Tables Scenario Analysis Settings & Targets Weekly Review Forecast Engine Stats Engine What-If Solver Pareto & Trend Time Log Monthly Summary Goal Tracker Period Comparison Activity Journal Critical Issues Radar Deep Analytics Lab Daypart Throughput Optimizer

Professional standards included

Fully unlocked — edit every formula, layout, and target
KPI dashboard with traffic-light alerts linked to your targets
12-month forecast engine, stats engine, and what-if solver
Weekly review, goal tracker, activity journal, and Pareto analysis
Critical Issues Radar, Deep Analytics Lab, Scenario Analysis, and industry edge board

$11.00

Build My Starter Pack — bundle & save 15%

Secure payment via Stripe. 7-day review window — not right for you? Contact us.

How to Use This Template

1. Download & Open

Purchase and download the .xlsx file. Open it in Microsoft Excel, Google Sheets, or Apple Numbers.

2. Read the START HERE Sheet

The guided instruction sheet walks you through every tab, formula, and target — no training needed.

3. Replace Sample Data

Overwrite the pre-filled sample rows with your own numbers. Formulas, dashboards, and alerts update automatically.

4. Set Your Targets

Adjust KPI thresholds on the Settings & Targets sheet. Traffic-light alerts will flag when metrics drift.

5. Review Weekly

Use the Weekly Review and Goal Tracker sheets to spot trends, catch problems early, and stay on track.

Frequently Asked Questions

Can I edit the formulas?

Yes — every formula, cell, and layout is fully unlocked. Customize anything to fit your workflow.

Does it work in Google Sheets?

Yes. Open the .xlsx file directly in Google Sheets or Apple Numbers. All formulas and conditional formatting are compatible.

Is this a one-time purchase?

Yes — pay once and own it forever. No subscriptions, no monthly fees, no accounts required.

What if the template is not right for me?

We offer a 7-day review window. Contact support and we will sort it out.

How many sheets are included?

Each workbook includes 15–30+ sheets depending on tier — from data entry and dashboards to forecasting, analytics, and industry-specific playbooks.

Need help?