Bill of Materials Cost Comparison
Compares part costs across product models from a grouped bill of materials. Raw data is imported and a results matrix shows quantity, cost and platform for every model side by side.
- Industry
- Manufacturing
- Deliverable
- BOM Comparison.xlsm
- Built with
- Excel VBA
Before
Part costs across models were compared by filtering the bill of materials manually.
After
A results matrix shows quantity, cost and platform for every model side by side after one import.
More like this
Related projects
Multi-Company Invoicing System
Security Services
Recurring service invoicing for several companies from one file. Invoices are saved to a database, PDFs are generated individually or for a whole month, and summary…
View project
Health Plan Quote Builder (Excel to Word)
Insurance
Builds self-funded health plan quotes. Premiums, claims forecasts and fees are calculated in Excel and a single click exports the finished quote into a formatted Word…
View project
Team Resource Planner
IT / Project Management
A weekly capacity planner for a team. Members and tasks are added through forms, hours are planned week by week and the planner shows available FTE,…
View project