Cookie Business Planner Spreadsheet

COOKIE STUDIO: THE DECORATED COOKIE BUSINESS PLANNER FOR GOOGLE SHEETS

Are your cookies priced to pay you? Cookie Studio works out the true cost of every cookie, from the dough and royal icing to the bag and your decorating time, then shows a price that covers it.

It also plans your bake days from each due date, tells you exactly how much icing to mix in each color, builds your shopping list and tracks every order, deposit and dollar of profit. It's made for cookie decorators, by a small shop that loves spreadsheets.

━━━━━━━━━━━━━━━━━━━━
✦ ANSWERS EVERY COOKIER NEEDS
━━━━━━━━━━━━━━━━━━━━

✓ What does one cookie really cost me, with my time counted?
✓ What should I charge for each tier, and what does it pay me per hour?
✓ What do I bake, flood and pipe each day this week?
✓ How much icing do I mix, in which colors?
✓ What do I need to buy before my next orders?
✓ Who still owes me a balance?

━━━━━━━━━━━━━━━━━━━━
✦ HOW IT WORKS
━━━━━━━━━━━━━━━━━━━━

1. Add what you pay for your ingredients and packaging
2. Enter your sugar cookie dough and royal icing recipes
3. Set your hourly wage and pricing tiers
4. Add your orders. The bake calendar, icing planner and shopping list fill in on their own

━━━━━━━━━━━━━━━━━━━━
✦ WHAT'S INSIDE
━━━━━━━━━━━━━━━━━━━━

✓ Cookie dashboard: income, cookies sold, profit, hourly rate, this week's bake list, money owed and new inquiries
✓ Pricing calculator: dough, icing, packaging and time for every tier, with a suggested price
✓ Quick quote calculator for "how much for 2 dozen?"
✓ Orders with designs, tiers, cutters, icing colors, deposits, payments and balances
✓ Printable invoices
✓ Bake calendar that works back from each due date (bake, flood, details, package), with busy-day warnings
✓ Royal icing planner: ounces per color, flood vs. piping, batches, powdered sugar and meringue powder
✓ Shopping list for the next 3 to 30 days, minus what you have on hand
✓ Recipe and ingredient costs. Measure in cups, ounces, pounds or grams
✓ Presale and pop-up tracker: sets made and sold, sell-through, booth fees and profit
✓ Cutter and stencil library that shows how often you use each one
✓ Expenses with monthly or yearly repeats
✓ Money: profit by month, where your orders come from, and a tax set-aside
✓ Printable price list and blank order form, made from your own prices and policies
✓ Readable Google Sheet tabs: Orders, Order List, Bake Schedule, Monthly Summary and more
✓ Sample bakery to explore before you start
✓ Works on desktop, tablet and phone

━━━━━━━━━━━━━━━━━━━━
✦ YOU WILL RECEIVE
━━━━━━━━━━━━━━━━━━━━

This is an instant digital download with 2 PDFs:
1. How to Access: your link to make your own copy of the Cookie Studio Google Sheet
2. Setup Guide: the one-time Google permission step, setting up your ingredients, recipes and prices, a tour of every screen, and how to use it on your phone

━━━━━━━━━━━━━━━━━━━━
✦ GOOD TO KNOW
━━━━━━━━━━━━━━━━━━━━

• You need a free Google account. A computer is easiest for setup
• The first time you open it, Google shows a "Google hasn't verified this app" screen. This is normal for every Google Sheets script. Your guide shows exactly what to click
• Prices are in US dollars by default. Weights are in pounds and ounces, and you can switch to kilograms and grams with one click. You can also change the currency symbol in Settings
• Cookie Studio is a planning and bookkeeping tool, not tax or legal advice. Please check your local cottage food rules
• Selling general baked goods? Look for our Home Bakery Pricing spreadsheet in our shop
• Digital product only. No cookies or physical items will be shipped
• Because this is a digital download, returns and exchanges aren't accepted. If anything isn't working, please message us and we'll gladly help

For use in your own business. Please don't share, resell or redistribute the template link.

Questions? Message Muse & Make Co anytime. We're happy to help.

Thank you for supporting our small shop! ✦

Created by Muse & Make Co with the help of AI tools.