4 Replies Latest reply: Apr 16, 2012 5:51 PM by Erica Whalley RSS

    manufacturing breakdown to lowest level

      Here a new challenge for you all ...

      I hope you can find a way to solve my problem.


      Here are the data I have:


      End-product (M)

           Part List:

                2x component A (M)

                5x component B (M)

                3x product C (P)

           Working Hours :

                10 hours on machine 1

                5 hours on machine 2


      Component A:

           Part List:

                20x product J (P)

                15x product I (P)

           Working Hours :

                3 hours on machine 5

                1 hour on machine 6


      Component B:

           Part List:

                10x product K (P)

                10x product L (P)

           Working Hours :

                2 hours on machine 7


      (M) refers to Manufactured products

      (P) refers to Purchased products       


      The part lists for all products are to be found in 1 data table and the routings (how many hours on which machine) are to be found in another data table.


      In this example you see only 2 levels, but some of my actual products have more levels. Does anyone know how I get the breakdown of the end product to the lowest level? The result should be something like this :

      End product contains :

           - 40x product J (P)

           - 30x product I (P)

           - 50x product K (P)

           - 50x product l (P)

           - 3x  product C (P)

           - 10 hours on machine 1

           - 5 hours on machine 2

           - 6 hours on machine 5

           - 2 hour on machine 6

           - 10 hours on machine 7


      Kind regards,