What is included
- Products, materials and bills of materials connect unit costs with finished-goods and material stock.
- Stock movements include production, sales, receipts, returns and waste; production consumes recipe materials.
- Purchase orders and supplier reorder views combine pack sizes, lead times and available stock.
- Includes sample/blank .xlsx files for Excel 2019, 2021 or Microsoft 365; no macros, and Google Sheets is not supported.
Based on the Etsy listing reviewed October 28, 2026. Check the current listing for any later changes.
What to prepare
For the workflow this product is designed around, gather:
- A materials list for each product
- Material quantities and purchase costs
- Stock counts and reorder information
A practical way to use your records
Build a bill of materials for one product before expanding to the rest of your range. Keep quantities and units consistent and review the pricing inputs when material costs change. Compare planned production with stock and reorder records before committing to a batch.
A worked example
Fictional example: a maker checks the material requirements and direct material cost for a batch of candles.
- Batch size
- 20 candles
- Wax per candle
- 0.2 kg at an illustrative $8 per kg
- Other materials per candle
- $0.30 wick and $1.10 container
- List each material and its quantity per finished item before extending the bill of materials to the batch.
- Compare the required quantities with stock on hand and review missing materials separately from the cost calculation.
Result: The batch needs 4 kg of wax. Direct materials cost $3 per candle, or $60 for 20 candles. Labor, overhead, selling fees and profit are excluded, so the material total is not a finished selling price.
Fictional figures explain the workflow; they do not represent customer results or guarantee particular template fields. See the included features above and the current Etsy listing.
A closer look at Excel Inventory & Product Cost Spreadsheet with Bill of Materials
Additional previews from this product's Etsy listing. Open any image for a larger view.
Questions about this product
Does this product include a bill of materials?
Yes. A bill of materials, pricing calculator and stock and reorder tracking are included.
Is this listing an Excel product?
Yes. This item is for Excel. Check its software requirements before buying; Google Sheets versions of other products do not apply automatically.
Which software is specified for this template?
This listing specifies Microsoft Excel. Review its current version and compatibility requirements, included files and download instructions on Etsy.
