Coffee Shop Owner Bundle: Site Selection Scorecard + Menu Pricing Calculator

Two tools for drive-thru coffee and small-QSR owners in one download. The Site Selection Scorecard helps you choose where to open. The Menu Pricing Calculator helps you make money once you're open.

1) Drive-Thru Site Selection Scorecard

• 0-100 score across 7 weighted categories: traffic + side of road (25), access + stacking (20), economics (15), demographics (15), visibility (10), competition / neighbors (10), zoning risk (5)
• 4 automatic dealbreakers: can't fit stacking, wrong side with no left access, drive-thru not allowed, exclusive coffee rights
• Compare and rank up to 3 sites side by side, with red flags and warnings
• Sales forecast from your own comps, with a foot-traffic adjustment and a capture-rate check
• Rent-to-sales calculator (8-10% target, 12% ceiling) with a sales sensitivity table
• 7-tab Excel workbook + 12-page owner's guide (PDF)

2) Coffee & Drive-Thru Menu Pricing Calculator

• Ingredient cost library with unit conversions (lb, gal, fl oz, mL, pumps) and yield / waste %
• House batch recipes (cold brew, sweet cream, simple syrup)
• Cost per cup for every drink at 4 sizes (12 / 16 / 20 / 24 oz, rename to fit your menu)
• Packaging kits by size, plus drive-thru and delivery add-ons
• Modifiers and milk alternatives, with cost, suggested upcharge and money-losing flags
• Suggested prices from your target margin, with your rounding rules
• Drive-thru vs in-store vs delivery app, net of card fees and commission %
• Menu engineering: Star / Plowhorse / Puzzle / Dog, with food-cost % flags
• What-if for supplier price increases: new cost per cup, monthly profit hit, price to hold your margin
• 13-tab Excel workbook + 5-page quick-start guide (PDF)

Who It'S For

• Opening your next drive-thru: score the site before you sign
• Already open: know your cost per cup by size
• Adding delivery apps: price for the commission
• A supplier just raised prices: see the hit before it lands

What You Get

• scorecard.xlsx + 12-page guide (PDF)
• calculator.xlsx + 5-page quick-start guide (PDF)
• Standard formulas and dropdowns, no macros. Excel, and Google Sheets compatible.

Please Note

• Both workbooks come with clearly labeled example data: hypothetical sites in the scorecard and made-up EXAMPLE costs and prices in the calculator. None of it is a benchmark or a recommendation. Replace it with your own numbers.
• This is a digital download. Nothing will be shipped.
• Planning tools only. Not financial, tax, legal or real estate advice. Confirm zoning, lease and utility terms with the right professionals.

Buy on Etsy