Article
Made2Manage BOM and costing reports
Costed and exploded BOMs, a cost estimating system we built for quoting, and part availability across on hand, committed and on order.
John Pereira · PresidentNovember 2026
We built these reports for manufacturers running Made2Manage and SQL Server Reporting Services, and they are part of the reports library we draw on for every client. Each one is a starting point: we tailor the parameters, columns and layout to how your business actually runs.
Costed Indented BOMs
We rebuilt the indented bill of materials in SQL Server Reporting Services, easily customized to show whatever information you need.
Exploded BOM with Lead Time
Our Exploded BOM with Lead Time report categorizes each part number by BOM and lead time in days.
Cost Estimating
We built a Cost Estimating system for determining historical costs for all the parts needed to produce a collection of end items. It includes three SQL Server Reporting Services reports at different levels of detail, an Access front end for setting up and naming collections of parts, and the SQL tables, stored procedures and functions behind it. It was designed to simplify quoting large numbers of related parts, and works for individual parts as well.
Part Availability
Our Part Availability report tracks each part number across quantity on hand, committed, on order and in process, to show what is actually available.
Takeaways
- Indented BOMs you can customize column by column.
- Historical costs for quoting large sets of parts.
- Availability across on hand, committed and on order.
More articles
Why your month-end report disagrees with the floor
Four common places a manufacturing close drifts from what the shop actually produced, and how to tell which one you have.
Map the process before you automate it
Automating a workaround just makes it permanent. A short argument for documentation first.
Customizations that survive an upgrade
The difference between a change that costs you once and one that costs you every release.
Made2Manage tools we built
Communication Center, Workflow Management and Sales Order Import: three products we built to fill gaps in Made2Manage.
Made2Manage production reports
Four reports we built to show what the floor is building, where it is scheduled, who worked on it, and how the plant is performing.
Made2Manage quality reports
Two reports we built: one finds everywhere else a defect could be, the other shows which vendors deliver when they promised.
Made2Manage sales reports
Backlog, net bookings, commission liability and gross margin by order, including a bookings system we built for ERPs that cannot track bookings on their own.
Skills, tools, and your ERP: where AI should actually touch the data
AI gets useful in a shop when it is given the right things in the right order: written know-how first, live data through controlled tools second, and the power to change anything last.