Does anyone have a report or way to do a what if scenario for finished good cost changes due to possible supplier price increases? We are looking for a way to plug in a price increase for a purchased part and run a what if scenario through all the top level BOM’s that part goes into so that we can justify our sales price increase with our customers during contract negotiations. We want to easily be able to compare the current cost to produce the top level with the future cost if the purchase part price increased.
We know we can use the opportunity/quote entry to manipulate it material by material but that means doing it manually one by one for every top level part we have that we sell to that customer. We would like to plug in the purchase part price change once and have it applied to all the top levels that part is used in for comparison.