Thank you for posting a workbook. This allows community members to assist much quicker. I am having a an issue trying to determine how the 8,442.26 was determined. is this the total of the column for each MRF ingredient item type? i broke out the calculation to look a bit more at the details and the first thing that comes to mind is the order of operations for Variance Qty (inc scrap) is not clearly defined and may be the root of the problem but I would need to see your Excel examples to verify.
It looks like you're using Aggregate Calculations
in your calculated Measures -- like SUM([Some Measure]) --
but your data allows to make most of them as Row-Level ones.
Then all your aggregations become easy.
As an example I've made a couple of them as such.
Please find the attached. Hope it could help.
Material Usage Variances_YF.twbx 442.3 KB