Inventory & Purchasing
Ingredient On Hand
Quantity on hand against your threshold, and a shop list of what is low or out.
$11.00
Inventory & Purchasing
Ingredient shopping list for cake orders: what to buy this week
Order Ingredient List makes an ingredient shopping list for cake orders from the cakes you have ordered, each recipe’s quantities and what is in your kitchen. The sheet works out what you still need to buy.
$11.00Order Ingredient List
- Editable .xlsx for Excel and Google Sheets
- Files arrive by email after checkout
Need more than one sheet? All twelve are $77.00. One by one they add up to $83.91.
Sample data shown
One page of two, whole. The file has more.
You type hereLocked formula
How it works
How does Order Ingredient List work?
Order Ingredient List turns this week’s cake orders into a buy list. You type the cakes ordered, each recipe’s quantities and what is in your kitchen. The sheet multiplies each recipe by the number of cakes, subtracts what you have and shows what is still needed. Zero means you have enough.
Type the orders
Pick Order, then the cake and the count. Zero cakes buys nothing, and it is not an error.
Type the recipes and what you have
Recipe rows hold cake, item, unit and quantity per cake. On hand rows hold the item and the quantity you have, zero allowed.
Read what to buy
Qty required and Qty to buy are locked formulas. Zero means you have enough.
The sample in the file
Two cardamom honey layer cakes and three lemon olive oil loaves: eight ingredients on the list, and honey is already covered.
From cakes to a buy list
Say which cakes are ordered and how many. The sheet multiplies each recipe, subtracts what you have and lists only what is still needed.
Good to know before you buy
- You type each recipe’s quantities once. The sheet does not know your recipes until you do.
- Type each item the same way every time, because the buy list matches on the name.
Opens in the app you use
Excel opens the .xlsx file as it is. For Google Sheets, upload the file to Google Drive and open it with Google Sheets. There is a How to use tab in the file.
Pairs well with
Sheets that sit next to this one
Each file stands alone. These three are the ones bakers open side by side.
Inventory & Purchasing
Supplier Reorder
Supplier, item, last price and packs to reorder, with the line cost worked out.
$11.00
Jobs & Work Orders
Orders Due This Week
Type the week start. Every cake due in that week is flagged and counted.
$4.99
Questions
Questions about this sheet
What supplies do I need for a bakery?
For cake, the first month usually means boxes, boards and liners plus a steady list of ingredients. Order Ingredient List shows the ingredients this week’s cake orders need, and what is still left to buy.
How do I make my own inventory list?
Ingredient On Hand is the sheet for that: it lists each ingredient with its quantity, unit and location. Order Ingredient List is different: it works backwards from this week’s orders to what you still need to buy.
What should an inventory list include?
For a baker, an inventory list includes the item, how much you have, the unit, where it is kept, what a pack costs, when it expires and the level where you reorder. Order Ingredient List only needs the item and the quantity you have, with zero allowed.
How to make a food cost spreadsheet in Excel?
List each ingredient with the pack price, the pack amount and the amount you use, then add the lines. Batch Recipe Cost does that. Order Ingredient List is for buying, not for cost: it shows what to buy for this week’s orders.
What is the easiest way to calculate food cost?
Cost each ingredient for the amount you use and add the lines. Batch Recipe Cost does this for a recipe and shows the cost per cake. Order Ingredient List does not calculate cost.
Where can I get Excel templates for free?
Order Ingredient List is not a free template: it costs $11.00 and is an editable .xlsx file. It opens in Excel, and in Google Sheets after you upload it to Google Drive.
Order Ingredient List$11.00