Bill Of Material Exploder!

I remember a bit back someone posted about a bill of material exploder, 
sorry I forget who did.

What we are trying to do is establish baselines for the demands for raw 
materials for our work centers so that we can calculate proper 
"mathematical" kanbans for those work centers.

But here is what I am looking to do... (And it might be a tad complicated)


Step 1:
        Query the IMHIST file for SA transactions for items in a specific 
workcenter from date x to date y.
        Item            SA Qty
        ITEMA           100

Step 2:
        Using the data is Step 1, explode the bill of materials for the 
items and compute the component requirements for the sold product
        Item                                            Unit Per Quantity
        ITEMA                                           1 100
                - L1SUB1                                1 100
                - L1SUB2                                .5              50
                        -L2SUB1                 1               50
                        -L2SUB2                 3               150
                -L1SUB3                         2               200
                        -L2SUB1                 5               1000
                                -L3SUB1         4               4000
                                -L3SUB2         1               1000

The report or the file would contain this information, from the top level 
all the way down to the 1st place that component is used.


Any feedback would be appreciated.

-----------------------------------------------------------------------------
Michael K. Huber
System Administrator
Pentair Filtration, Inc
502 Indiana Ave - Sheboygan, WI 53081
Phone: (920) 451-9417      FAX: (920) 803-3541 

Confidentiality Note: This e-mail message and all attachments to it are 
intended only for the named recipients and may contain confidential 
information. If you are not one of the intended recipients, please do not 
duplicate or forward this e-mail message and immediately delete it from 
your computer. 



______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________