Every delivery of flour, butter and sugar is recorded with its weight, cost per pound, lot code and best-before date. The cultured butter carries its supplier batch code, DAIRY-1188, and a best-before date of 1 December.
Recipe
A 6-pack of Chocolate Chip Cookies uses 0.3 lb of flour, 0.2 lb of cultured butter, 0.1 lb each of cane sugar and brown sugar, a quarter pound of couverture chocolate, half an egg and 0.1 fl oz of vanilla, plus a pouch and a label.
Bake a batch
A bake of 180 cookie packs draws 54 lb of flour, 36 lb of butter and 45 lb of chocolate. It enters stock as lot BAKE-CCC-0716 at $3.84 a pack, $691.20 for the batch.
What needs you
The home screen lists what needs attention today: 2 materials under 7 days of stock, $25 to restock, $733 across 2 lots that pass their best-before date within 30 days, and 8 open orders, 7 waiting for lots and 1 ready to fulfil.
Sell
Stock deducts as Shopify orders come in. 8 orders are open: 7 need lots assigned and 1 is ready to fulfil in Shopify.
Margins
Margin across 29 fulfilled orders is 74% for the last 90 days. With the target set to 70%, two products fall below it: the Chocolate Chip Cookies at 57% and the Banana Bread Loaf just under 70%. Repricing the cookies from $9.00 to $12.80 recovers about $243.20 a month.
Recall
If the dairy recalls butter batch DAIRY-1188, the trace shows the 3 bakes it went into, the cookie, brownie and oatmeal cookie lots those bakes made, and the 19 orders they shipped in.
Old stock
$1,076 of the $3,539 in stock has sat for 90 days or more, mostly packaging: 360 bakery boxes bought 150 days ago, $216, and 490 pouches at 130 days, another $171.50. 32 bags of granola have sat unsold for 120 days.
Run production and know your margins, starting today.
14-day free trial. Installs from the Shopify App Store.