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
Supplier reorder spreadsheet for the things you buy again
Supplier Reorder is a supplier reorder spreadsheet for the things a home bakery buys again. List each supplier, the item, the pack and the last price you paid. Type how many packs to reorder and the sheet totals the order.
$11.00Supplier Reorder
- 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 Supplier Reorder work?
Supplier Reorder keeps what you buy again in one place. You type the supplier, item, pack size, unit, last price and how many packs to reorder. The sheet multiplies the last price by the packs for each line and adds a Total row, so you know what the order costs before you place it.
Type the line
Supplier, item, pack size, unit, last price and how many packs to reorder.
Line cost follows
Last price is the price of one pack. Line cost is that price times the reorder quantity.
Read the total
The Total row adds every line, so you know what the order will cost.
The sample in the file
Seven sample lines across three suppliers, 56.55 dollars in total.
Last price, right where you reorder
Keep the last price you paid next to the pack and the supplier. Type how many packs to reorder and the line cost follows, so the total is known before you place the order.
Good to know before you buy
- It does not count what is on the shelf. Ingredient On Hand does that.
- Pack size is for reference. It is not used in the cost.
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
Order Ingredient List
This week’s cake orders turned into a buy list of ingredients.
$11.00
Startup & Launch
First Month Packaging
How many packs of boxes, boards and liners the first month needs.
$5.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. Supplier Reorder is where you keep what you buy again: the supplier, the item, the pack and the last price you paid.
How do I make a spreadsheet for my expenses?
List every purchase with its supplier, item and price, then total the column. Supplier Reorder does this for what you buy again: line cost is the last pack price times the packs you reorder, and a Total row adds every line. It covers what you buy from suppliers, not every expense a bakery has.
What are the typical monthly expenses for a bakery?
Typical monthly expenses vary from bakery to bakery, so the sheet does not guess. Supplier Reorder totals what you plan to spend with your suppliers on one order, which is one part of a bakery’s expenses.
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. Supplier Reorder is the buying side and does not count what is on the shelf.
How to calculate bakery cost?
Start with what you pay your suppliers for each ingredient, then add your time and the packaging. Supplier Reorder keeps the last pack price you paid, and you type it into Batch Recipe Cost, because the files do not read each other.
Where can I get Excel templates for free?
Supplier Reorder 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.
Supplier Reorder$11.00