BOM Bill of Material based on Line Items

Ok I’m trying to work through what seems to be a complicated database. So I have these data types; (Order) (Line Items) & (Inventory) Just trying to gain some ideas on how to make this function?

Let’s say you have a [cart]
In the cart you have [Line Items]
-Pie
-Bread
-Cake
These line items are made up of qty’s of [Inventory]
-Pie

  • 2 Cups of Flour
  • 3 Cups of Sugar
  • 1 Tbs of Soda
    -Bread
  • 3 Cups of Flour
    …And So On.

Now I want to display a Bill of Material (BOM) for the line items to show me how much flour, sugar and soda I need.

So would my [Line Items] have a list of many [Inventory] ?

@mikebhobbs - did you solve this? Could you share your solution?

I think this becomes like a super easy one minute solution using this plugin: