BOM+Inventory Tool

This is a tool for creating a Bill of Materials, as well as managing inventory, calculating costs, revenue, time, and profits for a given number of modules produced.

To use it you can add components, their individual costs, the quantity in the module, and your personal inventory of them. You then specify a desired production quantity, the sale price of your module, among other parameters. The spreadsheet then calculates the overall cost of the desired production run, the cost of the components you do not have in inventory, how many of which components you need based on your personal inventory for a desired production run, and many other useful numbers.

Input fields are in yellow, output ones are in white. To add components add rows above the statistics bar at the bottom. In those rows list the components, their quantities, their individual cost, and how many you have. Then drag the white formula fields down to the new row to make those calculations.