tommy1234
11-16-2014, 01:36 AM
Hello
i'm trying to create a macro (preferred) or a formula that will calculate my BOM levels automatically.
I have a BOM with 5 levels (can be more) with prices for each item and total price that is accumulated price refer to the BOM levels.
When i addend a new columns named "Target price" i wanted to define my price and update the BOM levels that are below and above with the new price.
columns H, I and J are examples for the calculation should be used and column K is the "new Bom Price" (the percentage on the item by its level multiplied with the accumulated price) according to the percentages in the BOM.
Thanks
Avi
i'm trying to create a macro (preferred) or a formula that will calculate my BOM levels automatically.
I have a BOM with 5 levels (can be more) with prices for each item and total price that is accumulated price refer to the BOM levels.
When i addend a new columns named "Target price" i wanted to define my price and update the BOM levels that are below and above with the new price.
columns H, I and J are examples for the calculation should be used and column K is the "new Bom Price" (the percentage on the item by its level multiplied with the accumulated price) according to the percentages in the BOM.
Thanks
Avi