Your Cart
Loading

Christmas Cookie Exchange & Baking Cost System — Batch Calculator, Cost Per Dozen & Exchange Planner Excel

On Sale
$19.00
$19.00
Added to cart

Your cookie exchange is set for December. Now the hard questions: How many batches do you bake? What does a dozen really cost? Who is bringing what — and who still owes their dozen?


Type in your guest count, the dozens you must bring, and your budget. The workbook does the rest.


WHAT YOU GET

- christmas-cookie-baking-system.xlsx — a working Excel workbook with real formulas. No macros. Works in Microsoft Excel and Google Sheets.

- christmas-cookie-baking-system-guide.pdf — a 4-page printable guide: setup, sheet-by-sheet help, a 5-step exchange plan, allergen-note guidance, storage tips, and a Nov 18 – party-day countdown.


THE FIVE SHEETS

1. Start Here — three yellow input cells: exchange guests, dozens to bring, baking budget. Quick answers update on the same page.

2. Recipe Batch Calculator — for each recipe: dozens wanted, yield per batch, batches needed (ROUNDUP formula — you cannot bake half a batch), ingredient scale factor, and total dozens made.

3. Ingredient Cost Sheet — 19 ingredient lines: package size, package price, amount used per batch, cost per batch (price ÷ size × amount used), and total cost across all batches. SUMIF subtotals give cost per recipe.

4. Exchange Planner — one row per guest: cookie type, a plain allergen-note column, dozens promised, dozens received, and dozens still owed. Totals count themselves.

5. Cost Summary — one dashboard: total bake cost, total dozens, cost per dozen, budget, budget left, on-budget status, cost by recipe, and exchange counts. All cells are live formulas.


SAMPLE PRE-LOADED: 12 guests, 6 dozen to bring, $50 budget → 3 recipes (Sugar Cookies, Gingerbread Cookies, Peanut Butter Blossoms), 2 batches each, 14 dozen baked, $33.61 total bake cost, $2.40 per dozen, $16.39 left in budget. Exchange list: 12 guests, 17 dozen promised, 15 dozen received. Change any yellow input and every number updates.


WHY NOT A PRINTABLE? Printables give you blank totals to fill in by hand. This workbook rounds your batches up for you, turns package prices into a true cost per dozen, and tracks who still owes cookies — live, as you type.


Instant download (.xlsx + .pdf). Digital product — no physical item ships. Personal use. Prices in the sample are example November 2026 US supermarket prices; type in your own store prices. The allergen-note column is a plain note field for what each guest reports. It is not a food-safety guarantee — ask each guest about allergies directly and read every ingredient label.

You will get the following files:
  • XLSX (13KB)
  • PDF (10KB)