A Sweet Morsel Co.
Operations Dashboard
Bakery Ops
Operations Dashboard
?
—
—
bakery_recipes.xlsx · 23 tabs loaded
Overview
Products
20
active recipes
Avg retail margin
62%
blended across catalog
Unique ingredients
54
across all recipes
Stock alerts
4
ingredients low
Finished goods — cost
$0
total cost in inventory
Potential retail revenue
$0
if sold at retail prices
Potential wholesale revenue
$0
if sold at wholesale prices
Products in stock
0
distinct products on hand
Top products by retail margin
ProductBatch sizeMargin
PB Saucepan Squares35 dz81%
Lemon Biscotti24 dz77%
Buckeyes (56 dz)56 dz74%
LadyLocks216 dz73%
Salted Caramel Blondies32 dz73%
Coconut Macaroons28 dz72%
Products needing attention
Carrot Cake38% margin
Cake Pops47% margin
Custom Sugar Cookies20 labor hrs
Pecan Tassies18% wholesale
Caramel Tassies27% wholesale
Nut Rolls (original tab)Outdated pricing
Shared ingredients — bulk purchasing leverage
Butter
14 recipesSam's / RD
Vanilla
13 recipesRD
Flour
11 recipesSam's
Powdered Sugar
10 recipesRD
Cream Cheese
6 recipesSam's / RD
Paragon Chocolate
6 recipesStovers — buy full bucket
Data issues to resolve
⚠
Paragon Blonde Chocolate pricing conflict — priced at $40/bucket in some tabs, $25.99 in others. Standardize before next costing run.
⚠
Old Fashioned Nut Rolls has two tabs — the updated 88-roll version (Dec 2018) should be treated as active. The 60-roll original has outdated pricing.

Set current stock levels to see what you can produce today. Reorder points are starting estimates — adjust to match your operation.

Ingredient stock levels
IngredientOn handUnitReorder pointStatusLevel
Production constraints
40 hrs
$13
50%
Locked orders — always included
Additional products
Gross profit
—
this run
Ingredient cost
—
total
Labor cost
—
at $13/hr
Labor utilization
Hours used0 of 40 hrs
Gross profit per labor hour
Green = in plan  ·  Gray = not selected
Optimized production plan
ProductBatchesIng. costLabor costTotal costRevenueGross profitMargin
Week total batches
0
across all days
Week gross profit
$0
retail pricing
Week labor cost
$0
blended staff rate
hrs (e.g. 15 staff × 8 hrs = 120)
Week summary — batches scheduled
ProductMonTueWedThuFriSatSunTotal batchesTotal dozensLabor costGross profit
Add product

Changes are saved automatically and apply across all tabs. Stored locally in your browser.

Employee roster
▾

Salaried employees enter annual salary; daily cost = salary ÷ 260 working days.

Ingredient unit costs
▾
New ingredient
Ingredient Unit cost ($) Unit Supplier
Recipe settings — batch size & labor hours
▾
New recipe
Product Dozens/batch Labor hrs Ing. cost Cost/dozen
Wholesale orders

Orders from wholesale customers. Due date drives production scheduling.

New wholesale order

No wholesale orders yet. Click "+ New order" to add one.

Shopify retail orders

Live orders from your Shopify store. Requires API credentials to connect.

Not connected

Create a Custom App in your Shopify Admin → Apps → Develop apps. Grant read access to Orders. Paste the Admin API access token above.

Connect your Shopify store to see retail orders here.

Manage wholesale customer profiles, contact info, and per-product pricing.

New customer

Tracks finished product on hand. Auto-populated when batches are marked complete in the weekly schedule. Adjust manually as needed.

Total cost in inventory
$0
ingredient + labor + packaging
Potential retail revenue
$0
at retail pricing
Potential wholesale revenue
$0
at wholesale pricing
Total dozens on hand
0
across all products
Finished goods on hand
Add finished product
Product Batches Dozens Cost Retail value Wholesale value Adjust
Recent fulfillments
DateCustomerProductDozensValue

Consolidated ingredient needs based on current stock levels and batch plan. Set quantities in the Batch Planner to populate purchase quantities.

Purchase order — ingredients below reorder point
IngredientOn handReorder pointOrder qtyUnitEst. costSupplier
Estimated total: $0.00