# Bill Of Materials

nick masonn
Guest
Posts: n/a

 22nd Sep 2009
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

Otto Moehrbach
Guest
Posts: n/a

 24th Sep 2009
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
<nick masonn> wrote in message news:(E-Mail Removed)...
>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

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post JaY Microsoft Access Queries 1 29th Mar 2005 10:35 PM =?Utf-8?B?dmVkZXJzdGVpbg==?= Microsoft Access 3 7th Feb 2005 11:09 PM =?Utf-8?B?U2hlbGRvbiAtIEhlbHAgd2l0aCBCLk8uTS4ncw== Microsoft Access 3 3rd Nov 2004 09:33 PM =?Utf-8?B?U3RhcjE5NTc=?= Microsoft Excel Misc 0 26th Aug 2004 04:13 AM Mike Microsoft Access Queries 3 26th Mar 2004 09:11 PM

Features