Bill of Materials (BOM) Inventory Tracker
A common Reddit question: "If I sell 1 Burger, how do I automatically deduct 2 Buns and 1 Meat patty?"
This page provides the exact matrix math formula and a downloadable Excel/Google Sheets template to solve complex raw material deductions automatically.
BOM Dynamic Deduction Formula
Calculate raw materials consumed (e.g., 2 buns, 1 meat) from finished goods sold (e.g., 1 Burger).
The MMULT approach
Instead of writing hundreds of VLOOKUP or SUMIFS combinations, the most powerful way to deduct raw materials based on a Bill of Materials (BOM) is matrix multiplication (MMULT).
=MMULT(TRANSPOSE(SalesQtyRange), BOMMatrixRange)Download the Full Template
SheetMaster BOM Inventory Tracker
Includes the exact Matrix Multiplication setup, safety stock alerts, and finished goods inputs.