{"product_id":"ice-cream-shop-profitability-dashboard-daily-sales-waste-labor-tracker-for-scoop-shops-excel-google-sheets-template-with-weekly-p-l","title":"Ice Cream Shop Profitability Dashboard — Daily Sales, Waste \u0026 Labor Tracker for Scoop Shops | Excel \u0026 Google Sheets Template with Weekly P\u0026L","description":"\u003ch3 class=\"text-text-100 mt-2 -mb-1 text-base font-bold\"\u003eStop forcing a restaurant template to fit your scoop shop.\u003c\/h3\u003e\n\u003cp class=\"font-claude-response-body break-words whitespace-normal leading-[1.7]\"\u003eIf you've ever tried to track ice cream shop profitability in a generic restaurant spreadsheet, you already know the problem: nothing accounts for \u003cstrong\u003escoop count per container\u003c\/strong\u003e, \u003cstrong\u003eflavor velocity\u003c\/strong\u003e, or \u003cstrong\u003efreezer waste\u003c\/strong\u003e the way it actually happens behind the counter.\u003c\/p\u003e\n\u003cp class=\"font-claude-response-body break-words whitespace-normal leading-[1.7]\"\u003eYou end up averaging your costs, ignoring your top-sellers, and finding out your labor was 38% three weeks too late.\u003c\/p\u003e\n\u003cp class=\"font-claude-response-body break-words whitespace-normal leading-[1.7]\"\u003eThis dashboard fixes that.\u003c\/p\u003e\n\u003ch3 class=\"text-text-100 mt-2 -mb-1 text-base font-bold\"\u003eBuilt for one location. Built for scoops.\u003c\/h3\u003e\n\u003cp class=\"font-claude-response-body break-words whitespace-normal leading-[1.7]\"\u003eThe \u003cstrong\u003eIce Cream Shop Profitability Dashboard\u003c\/strong\u003e is a fully formula-driven Excel and Google Sheets workbook designed for \u003cstrong\u003esingle-location scoop shops, gelato bars, and frozen dessert cafés\u003c\/strong\u003e. It tracks every dollar that goes through your freezer case — from container cost to net margin — and gives you a weekly P\u0026amp;L that actually reflects how an ice cream business runs.\u003c\/p\u003e\n\u003cp class=\"font-claude-response-body break-words whitespace-normal leading-[1.7]\"\u003eNo more generic \"food cost %.\" No more guessing which flavors pay the rent. No more discovering waste at the end of the month.\u003c\/p\u003e\n\u003ch3 class=\"text-text-100 mt-2 -mb-1 text-base font-bold\"\u003eWhat's inside the workbook\u003c\/h3\u003e\n\u003cp class=\"font-claude-response-body break-words whitespace-normal leading-[1.7]\"\u003e\u003cstrong\u003e🔧 Setup Tab\u003c\/strong\u003e — Enter your shop name, week start date, and 10 cost assumptions in one place: container cost, scoops per container, single\/double\/pint\/quart pricing, target labor %, target waste %, fixed overhead per day, and sales tax rate. Build a catalog of up to 18 named flavors with categories. Every other tab pulls from here automatically.\u003c\/p\u003e\n\u003cp class=\"font-claude-response-body break-words whitespace-normal leading-[1.7]\"\u003e\u003cstrong\u003e📅 Daily Log\u003c\/strong\u003e — Log every flavor sold, every day. Enter single scoops, double scoops, pints, and quarts — the dashboard auto-converts to scoop equivalents (1 pint = 6 scoops, 1 quart = 12 scoops) and calculates revenue, COGS, gross profit, labor cost, labor %, and net margin per row. Pre-loaded with sample data from a 7-day week so you can see exactly how it works before you start typing.\u003c\/p\u003e\n\u003cp class=\"font-claude-response-body break-words whitespace-normal leading-[1.7]\"\u003e\u003cstrong\u003e📆 Day Summary\u003c\/strong\u003e — Aggregates every flavor by day so you can spot weekday vs. weekend patterns at a glance. Total scoops, total revenue, gross margin %, labor, fixed costs, and net profit by date.\u003c\/p\u003e\n\u003cp class=\"font-claude-response-body break-words whitespace-normal leading-[1.7]\"\u003e\u003cstrong\u003e🏆 Flavor Velocity Tab\u003c\/strong\u003e — The feature generic templates don't have. Ranks all 18 flavors by total weekly revenue, total scoops sold, waste cost, waste % of output, and revenue per scoop. Instantly shows which flavors are pulling their weight — and which are taking up freezer space without earning it.\u003c\/p\u003e\n\u003cp class=\"font-claude-response-body break-words whitespace-normal leading-[1.7]\"\u003e\u003cstrong\u003e🗑️ Waste Tracker\u003c\/strong\u003e — Auto-flags every flavor as ✅ Within Target, ⚠️ Watch, or 🚨 High Waste based on your target waste % from Setup. Built around the reality that ice cream waste isn't generic food waste — it's batch-specific, flavor-specific, and tied to container yield.\u003c\/p\u003e\n\u003cp class=\"font-claude-response-body break-words whitespace-normal leading-[1.7]\"\u003e\u003cstrong\u003e📊 Weekly P\u0026amp;L Summary\u003c\/strong\u003e — A complete profit-and-loss statement formatted the way an accountant actually wants to see it: revenue, COGS broken into product cost and waste, gross profit, gross margin %, labor cost, labor %, fixed overhead, net operating profit, and net margin %. Every line includes a Budget\/Target column you fill in once and a Variance column that updates automatically. KPI scorecard at the bottom surfaces top flavor, highest-waste flavor, revenue per labor hour, and daily averages.\u003c\/p\u003e\n\u003ch3 class=\"text-text-100 mt-2 -mb-1 text-base font-bold\"\u003eWhy this beats a generic restaurant template\u003c\/h3\u003e\n\u003cdiv class=\"overflow-x-auto w-full px-2 mb-6\"\u003e\n\u003ctable class=\"min-w-full border-collapse text-sm leading-[1.7] whitespace-normal\"\u003e\n\u003cthead class=\"text-left\"\u003e\n\u003ctr\u003e\n\u003cth scope=\"col\" class=\"text-text-100 border-b-0.5 border-border-300\/60 py-2 pr-4 align-top font-bold\"\u003eGeneric Restaurant Template\u003c\/th\u003e\n\u003cth scope=\"col\" class=\"text-text-100 border-b-0.5 border-border-300\/60 py-2 pr-4 align-top font-bold\"\u003eThis Dashboard\u003c\/th\u003e\n\u003c\/tr\u003e\n\u003c\/thead\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003ctd class=\"border-b-0.5 border-border-300\/30 py-2 pr-4 align-top\"\u003eTracks \"food cost %\"\u003c\/td\u003e\n\u003ctd class=\"border-b-0.5 border-border-300\/30 py-2 pr-4 align-top\"\u003eTracks cost per scoop based on container yield\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd class=\"border-b-0.5 border-border-300\/30 py-2 pr-4 align-top\"\u003eSales by menu item\u003c\/td\u003e\n\u003ctd class=\"border-b-0.5 border-border-300\/30 py-2 pr-4 align-top\"\u003eSales by flavor with velocity ranking\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd class=\"border-b-0.5 border-border-300\/30 py-2 pr-4 align-top\"\u003eGeneric waste line\u003c\/td\u003e\n\u003ctd class=\"border-b-0.5 border-border-300\/30 py-2 pr-4 align-top\"\u003eWaste flagged by flavor against your target %\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd class=\"border-b-0.5 border-border-300\/30 py-2 pr-4 align-top\"\u003eSingle revenue line\u003c\/td\u003e\n\u003ctd class=\"border-b-0.5 border-border-300\/30 py-2 pr-4 align-top\"\u003eSingle, double, pint, quart pricing tiers\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd class=\"border-b-0.5 border-border-300\/30 py-2 pr-4 align-top\"\u003eMonthly P\u0026amp;L\u003c\/td\u003e\n\u003ctd class=\"border-b-0.5 border-border-300\/30 py-2 pr-4 align-top\"\u003eDaily log + weekly P\u0026amp;L + day-of-week patterns\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd class=\"border-b-0.5 border-border-300\/30 py-2 pr-4 align-top\"\u003eBuilt for table-service restaurants\u003c\/td\u003e\n\u003ctd class=\"border-b-0.5 border-border-300\/30 py-2 pr-4 align-top\"\u003eBuilt for one-counter scoop shops\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003c\/div\u003e\n\u003ch3 class=\"text-text-100 mt-2 -mb-1 text-base font-bold\"\u003eWho this is for\u003c\/h3\u003e\n\u003cul class=\"[li_\u0026amp;]:mb-0 [li_\u0026amp;]:mt-1 [li_\u0026amp;]:gap-1 [\u0026amp;:not(:last-child)_ul]:pb-1 [\u0026amp;:not(:last-child)_ol]:pb-1 list-disc flex flex-col gap-1 pl-8 mb-3\"\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eSingle-location scoop shop owners\u003c\/strong\u003e who want to know their numbers without hiring a bookkeeper\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eNew ice cream shop operators\u003c\/strong\u003e opening their first location and trying to set targets\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eGelato bars, frozen yogurt shops, and frozen dessert cafés\u003c\/strong\u003e that scoop and serve from containers\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eMulti-flavor counter-service businesses\u003c\/strong\u003e that need to track velocity and waste by SKU\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eOwners with seasonal swings\u003c\/strong\u003e who need a weekly dashboard, not a quarterly one\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3 class=\"text-text-100 mt-2 -mb-1 text-base font-bold\"\u003eWhat this is \u003cem\u003enot\u003c\/em\u003e\n\u003c\/h3\u003e\n\u003cp class=\"font-claude-response-body break-words whitespace-normal leading-[1.7]\"\u003eThis dashboard is built for \u003cstrong\u003esingle-location, container-served scoop shops\u003c\/strong\u003e. It is not designed for:\u003c\/p\u003e\n\u003cul class=\"[li_\u0026amp;]:mb-0 [li_\u0026amp;]:mt-1 [li_\u0026amp;]:gap-1 [\u0026amp;:not(:last-child)_ul]:pb-1 [\u0026amp;:not(:last-child)_ol]:pb-1 list-disc flex flex-col gap-1 pl-8 mb-3\"\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003eMulti-unit franchises (no roll-up tab)\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003eManufacturers selling pints to retail (use a wholesale margin calculator)\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003eSoft-serve operations without flavor-by-flavor tracking\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003eCatering or events businesses (use an events pricing calculator)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3 class=\"text-text-100 mt-2 -mb-1 text-base font-bold\"\u003eFormat \u0026amp; delivery\u003c\/h3\u003e\n\u003cul class=\"[li_\u0026amp;]:mb-0 [li_\u0026amp;]:mt-1 [li_\u0026amp;]:gap-1 [\u0026amp;:not(:last-child)_ul]:pb-1 [\u0026amp;:not(:last-child)_ol]:pb-1 list-disc flex flex-col gap-1 pl-8 mb-3\"\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eExcel (.xlsx)\u003c\/strong\u003e — opens in Microsoft Excel, Numbers, or Google Sheets (just upload the file)\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003ePre-loaded sample data\u003c\/strong\u003e so you can test it before clearing it\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003e1,393 working formulas\u003c\/strong\u003e — zero errors, fully editable\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eColor-coded inputs\u003c\/strong\u003e (blue cells = type your numbers; everything else calculates automatically)\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003e6 tabs\u003c\/strong\u003e, fully cross-linked\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eInstant download\u003c\/strong\u003e after purchase\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3 class=\"text-text-100 mt-2 -mb-1 text-base font-bold\"\u003eWhat you get\u003c\/h3\u003e\n\u003cp class=\"font-claude-response-body break-words whitespace-pre-wrap leading-[1.7]\"\u003e✓ The full Excel workbook (.xlsx) ✓ Quick-start guide explaining each tab in one page ✓ Sample data already populated for a 7-day demo week ✓ Lifetime use — no subscription, no expiration ✓ Free updates if the template is revised\u003c\/p\u003e\n\u003ch3 class=\"text-text-100 mt-2 -mb-1 text-base font-bold\"\u003eAbout the build\u003c\/h3\u003e\n\u003cp class=\"font-claude-response-body break-words whitespace-normal leading-[1.7]\"\u003eEvery formula was tested. Every tab is cross-linked. Every cost assumption flows from one Setup sheet, so you change your container cost in \u003cstrong\u003eone place\u003c\/strong\u003e and the entire workbook updates. No copy-pasting numbers across tabs. No broken references. No spreadsheet headaches.\u003c\/p\u003e\n\u003cp class=\"font-claude-response-body break-words whitespace-normal leading-[1.7]\"\u003eThis is the dashboard we wish existed when generic templates kept missing the point.\u003c\/p\u003e","brand":"Secret Creamery","offers":[{"title":"Default Title","offer_id":46366871617686,"sku":null,"price":7176.0,"currency_code":"JPY","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0424\/4452\/1622\/files\/AdobeStock_777886097_1_e088cc53-98c4-43a0-aab5-9bb6de51fc00.jpg?v=1777584117","url":"https:\/\/secretcreamery.jp\/products\/ice-cream-shop-profitability-dashboard-daily-sales-waste-labor-tracker-for-scoop-shops-excel-google-sheets-template-with-weekly-p-l","provider":"Secret Creamery","version":"1.0","type":"link"}