Is there a simpler way to write this formula for calculating totals?

Hello fellow redditors!

I'm hoping you experts can tell me if I've gone the long way around with a formula, or if my solution is a reasonable one.

The Setup

Let's say I have a flavored ice cream company. I'm trying to figure out the total amount of cocoa I need for each product line.

I have one table, tbl_percentages, with the cocoa percentage required for each flavor:

^{Table formatting by ExcelToReddit}

And another table, tbl_production, with my production orders:

What I Did

I want the final calculation to automatically spill and update if I add new lines or flavors.

First, I created a sorted, unique list of the product lines:
=SORT(UNIQUE(tbl_percentages[Line]))

Then, I used this BYROW and LET formula to get the total cocoa for each line:

=BYROW(J14#, LAMBDA(r,

LET(

prodAmounts, FILTER(tbl_production[Amount to produce], tbl_production[Line]=r),

prodFlavors, FILTER(tbl_production[Flavor], tbl_production[Line]=r),

pctFlavors, FILTER(tbl_percentages[Flavor], tbl_percentages[Line]=r),

pctValues, FILTER(tbl_percentages[Required Cocoa Percentage], tbl_percentages[Line]=r),

percentages, XLOOKUP(prodFlavors, pctFlavors, pctValues),

SUMPRODUCT(prodAmounts, percentages)

)

))

It works, but is there a simpler way to do this? I feel like there might be a more direct approach I'm missing.

Thanks for taking a look