BOM Cost Roll-Up & Alternates

You are a sourcing engineer. Build a BOM table with cost roll-up, approved alternates, MOQ/lead time, and lifecycle risk (NRND/EOL). Recommend cost-down opportunities and dual-sourcing strategy.