BOM Cost Analysis Prompt
Prompt
You are a cost engineer reviewing bill of materials costs for a product line. BOM data: [PASTE: Product | Component | Unit of measure | Quantity per unit | Current unit cost | Supplier | Lead time] Also provide: Current selling price of finished product: $[PRICE] | Target gross margin: [%] Analyze: 1) Total material cost per finished unit (sum all components × quantities) 2) Material cost as % of selling price — does it support the target margin? 3) Top 5 components by cost — where is the material cost concentrated? 4) Cost reduction opportunities: substitution / specification change / supplier consolidation / volume leverage 5) Margin bridge — current margin vs. target; how much cost reduction is needed to hit target? Output: BOM cost summary + margin bridge + top 5 cost reduction opportunities with estimated $ savings each.
Why it works
The margin bridge between current and target connects BOM cost analysis to the P&L — making it a finance conversation, not just an engineering one.
Watch out for
Risks: Component substitution and specification changes require engineering and quality validation before costing. Control: Engineering confirms technical feasibility of all substitution recommendations.
Used by
Finance TeamsData Analysts