Ice Cream Menu Engineering Workbook | Excel Template for Scoop Shops, Gelato Cafés & Frozen Dessert Brands | Profit Analysis & Flavor Ranking Tool

Stop Guessing Which Flavors Actually Make You Money

You know your vanilla bean sells like crazy — but is it actually profitable after ingredient costs? Your pistachio has the highest margin on the menu — so why is it getting outsold 5-to-1 by cookie dough? And that lavender honey you're so proud of... is it earning its spot on the board, or eating into your profits?

Most scoop shop owners run their menus on gut feel. Restaurant operators have used menu engineering for decades to answer these exact questions — but until now, no one built it specifically for ice cream.

This workbook fixes that.

What You Get

A fully-built Excel workbook (.xlsx) with 7 interconnected tabs that turn your monthly sales data into a clear, color-coded action plan. Just enter how many scoops of each flavor you sold, your price, and your cost — the workbook does the rest.

Inside the workbook:

• 📋 Instructions Tab — Visual quick-start guide explaining the four flavor categories (Stars, Plowhorses, Puzzles, Dogs) and exactly how to use the workbook
• 📝 Data Entry Tab — Pre-formatted entry sheet for up to 25 flavors with auto-calculating contribution margin, revenue, and gross profit
• 📊 Analysis Engine — Automatically scores every flavor on popularity vs. margin, assigns its category, and ranks performance
• 🗺️ Matrix View — A dynamic 2x2 quadrant chart that populates your flavors into the correct box (Stars, Plowhorses, Puzzles, or Dogs) with category-specific action guidance
• 💡 Action Plan Tab — 24 specific, prioritized tactics covering all four categories (price increases, recipe re-engineering, board placement, seasonal rotation, etc.) with editable owner/deadline/status fields
• 📅 Trend Tracker — Log monthly results to see if your Star % is climbing and Dog % is dropping over time
• 💰 Pricing Toolkit — Target margin calculator + price sensitivity table to test "what if" scenarios before committing to a price change

Who This Is For

• ✅ Artisan ice cream and gelato scoop shops
• ✅ Frozen dessert cafés, frozen yogurt shops, and dessert bars
• ✅ Multi-location ice cream operators tracking flavor performance across stores
• ✅ Specialty CPG ice cream brands with retail-facing menus or tasting rooms
• ✅ New scoop shop owners building their first menu from scratch

Why This Workbook Beats Generic Templates

Generic restaurant menu engineering spreadsheets exist — but they don't account for how scoop shops actually work. This workbook is built around ice cream economics: per-scoop pricing, ingredient-driven COGS, seasonal flavor rotation, and the reality that 4-5 flavors typically drive most of the revenue while a long tail eats up freezer space.

Sample data, instructions, and action recommendations are all written in scoop shop language, by someone who understands the difference between a hero flavor and one you're keeping around because you "always have."

Specs

• Format: Microsoft Excel (.xlsx) — also opens in Google Sheets and Apple Numbers
• Compatibility: Excel 2016+, Office 365, Google Sheets, Numbers
• Tabs: 7 fully-formatted, color-coded sheets
• Sample Data: 20 pre-loaded sample flavors (easily replaced with yours)
• Delivery: Instant digital download after checkout

What You'll Be Able to Do Within 30 Minutes of Downloading

1. Know exactly which flavors are funding your business — and which are quietly costing you money
2. Identify 2-3 immediate price adjustments that could lift gross profit without hurting volume
3. Spot the "Puzzle" flavors that just need better positioning to become Stars
4. Build a defensible case for cutting underperforming flavors (with data, not gut feel)
5. Set up a monthly review rhythm to keep your menu optimized year-round

Instant Download — No Subscriptions, No Logins

One-time purchase. Yours forever. Use it on as many of your locations as you want.