Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesOperations & Supply ChainSpecialized InventoryBill of Materials & Product Cost Sheet

SpreadsheetSpecialized InventoryFree

Bill of Materials & Product Cost Sheet

List every component of a product with quantity, waste and cost to get a true unit cost and margin.

Shown with sample data

Colour

Bill of Materials & Product Cost Sheet

List every component of a product with quantity, waste and cost to get a true unit cost and margin.

Cost per unit
$7.67
Gross margin
45%
Price for target margin
$19.17

How to use it

  1. 1List each component with the quantity used in one unit.
  2. 2Add a waste % for offcuts, spills or rejects.
  3. 3Enter your selling price and target margin on the Pricing sheet.
  4. 4Update costs when suppliers change prices.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

Know what one unit really costs. List materials, packaging and labour with the quantity per unit and a waste allowance; the sheet totals cost per unit by type and, with your selling price, shows gross margin and the price needed to hit a target margin.

Who it’s for

  • Pricing a new product
  • Checking margin after a supplier price rise
  • Quoting custom or batch work

What’s included

  • Bill of materials sheet: Everything that goes into one unit.
  • Pricing sheet: Margin at your price, and the price for the margin you want.

How to use it

  1. 1List each component with the quantity used in one unit.
  2. 2Add a waste % for offcuts, spills or rejects.
  3. 3Enter your selling price and target margin on the Pricing sheet.
  4. 4Update costs when suppliers change prices.
Related searchesbill of materialsbom templateproduct costingunit costcost of goods

Details

Format
Spreadsheet
Category
Specialized Inventory
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetSpecialized InventoryFree

Bill of Materials & Product Cost Sheet

List every component of a product with quantity, waste and cost to get a true unit cost and margin.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Specialized Inventory
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More specialized inventory templates

View all
Batch & Expiry Date Tracker2 sheets

Batches expiring in 14 days

3

Expired batches

1

Value at risk

$350

ABCD
1ProductCategoryLot numberReceived
2Greek yoghurt 500gChilledL2611ANov 4
3Oat milk 1LAmbientOM-0932Sep 10
4Chicken stock 1LAmbientCS-7741Jun 1
5Frozen berries 1kgFrozenFB-5510Aug 15
Batches
SpreadsheetSpecialized Inventory

Batch & Expiry Date Tracker

Track every lot with its expiry date, days left and what to use, discount or dispose of first.

10 min setupPreview
Tool & Equipment Checkout Log2 sheets

Items out now

3

Overdue

3

Returned needing attention

1

ABCD
1ItemAsset tagCategoryTaken by
2Hammer drillPT-014Power toolsMarco D.
3Laser levelTE-003Test equipmentAsha P.
4Torque wrenchHT-022Hand toolsSam K.
5Angle grinderPT-009Power toolsJordan L.
Checkout log
SpreadsheetSpecialized Inventory

Tool & Equipment Checkout Log

Sign tools and equipment out and back in, and see what is overdue and who has it.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ