Cookie Box Pricing Calculator & Gift Order Planner, Bake Plan Spreadsheet (Google Sheets, Excel)

Seller's description

Price every cookie box from its true cost, then plan the baking and the packaging. Add your cookies and packaging once, build your gift boxes, and this planner shows the box cost, a suggested price at your target margin and the profit on every box. Confirmed orders turn into a bake plan by pickup date and a packaging shopping list.

Made for home bakers, cottage bakeries and small bakeries selling Christmas cookie boxes, holiday gift boxes, corporate gifts and market boxes. Works in Google Sheets and Excel.

WHAT'S INSIDE (10 tabs)
• Settings: currency, hourly rate, overhead %, target margin, price rounding (.90, .99, .50, whole or next 5), deposit % and order cutoff date
• Cookies: up to 40 cookies with batch yield, batch cost, cost per piece and allergens
• Packaging: up to 30 items such as boxes, tins, cookie cups, ribbon and labels, with pack price, units per pack and stock on hand
• Box Builder: up to 12 box types. Pick up to 10 cookies and 5 packaging items per box and the minutes to pack it. See cookie, packaging, labor and overhead cost, the suggested price, your own price, profit, margin and a warning when a box is below your target
• Price Ladder: profit and margin for every box at three price points, to help you set your tiers
• Orders: one row per box ordered, with pickup date, status (Inquiry, Confirmed, Paid, Picked up, Cancelled), deposit, line total and balance due
• Bake Plan: confirmed orders turned into cookies by type and by pickup date, with a breakage allowance and batches to bake
• Shopping List: packaging needed for confirmed orders, minus stock on hand, with packs to buy and their cost
• Dashboard: boxes, revenue, costs, profit, deposits, still to collect, cookies to bake, days to your cutoff and a Contains line for each box type
• Start Here: a step-by-step guide

WHY IT'S DIFFERENT
• Your time is part of the cost: the minutes to finish and pack each box, at your hourly rate
• Change one cookie or packaging price and every box, price and margin updates
• Inquiries and cancelled orders don't count toward what you bake or buy
• Built-in checks tell you exactly what's missing in a row
• Built by a professional cook

WHAT YOU GET
• A PDF with your "Make a copy" link for Google Sheets
• The Excel file (.xlsx) in a ZIP
Works in Google Sheets (free), Excel 2010+ (Windows and Mac) and LibreOffice. Example Christmas boxes and orders included. Use any currency.

GOOD TO KNOW
• Digital download. Nothing is shipped.
• Up to 40 cookies, 30 packaging items, 12 box types, 300 order lines and 14 pickup dates in the Bake Plan.
• Allergen lines are based only on what you enter. They don't cover cross-contact. Always check your ingredient labels and your local labeling rules.
• Results are estimates to support your pricing decisions, not financial, tax or legal advice.
• For use in your own bakery or food business. Please don't resell or share the file.

Need to cost each cookie recipe first? See the Recipe Cost Calculator for Home Bakers in my shop. Taking holiday pre-orders by pickup day? See the Holiday Bakery Pre-Order Tracker.

Questions? Send me a message and I'll help you get set up.

This template was created with the help of AI tools. Every formula and example was tested before release.