Bill Of Materials

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
 
O

Otto Moehrbach

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top