Multi level Bill of material

please see the attached file i tried to explain:
I have 2 sheets:
Formulas include 2 fixed formulas (white base; varnish)
Combined formulas: where I need to list the ingredients of a mix between white base formula and varnish formula and that depending on the % of each of them.
If I take 60% white and 40%& varnish, I need to list the ingredients with their percentages
60/40 may change than the ingredients % will change accordingly.