Bill Of Materials

  • Thread starter Thread starter nick masonn
  • Start date Start date
N

nick masonn

I am not sure how many people here are familiar with Bill of Materials but here is my question.

I need to find out how to get the values in column cost.


Level
1 2 3 4 Part Number Qty Cost Extended Cost
1.0 A 2 =(6*1)+((10*2)+(4*3)+(3*6)*4)*5+(7*1) =((6*1)+((10*2)+(4*3)+(3*6)*4)*5+(7*1))*2
0.2 B 1 6 =6*1
0.2 C 5 =(10*2)+(4*3)+(3*6)*4 =((10*2)+(4*3)+(3*6)*4)*5
0.3 D 2 10 =10*2
0.3 E 3 4 =4*3
0.3 F 4 =3*6 =(3*6)*4
0.4 G 6 3 =3*6
0.2 H 1 7 =7*1
1.0 I 7 =(5*1)*2 =((5*1)*2)*7
0.3 J 2 =5*1 =(5*1)*2
0.4 K 1 5 =5*1


EggHeadCafe - Software Developer Portal of Choice
WPF And The Model View View Model Pattern
http://www.eggheadcafe.com/tutorial...b-7374d3da3425/wpf-and-the-model-view-vi.aspx
 
Nick
The people reading your post know Excel and most of us are quite
familiar with a bill of materials. What we don't know is your business, or
any part of it. Post back and explain what you have (in generic terms),
what you want to have, and how you would like to get from one to the other.
HTH Otto
 
Back
Top