Percentage split to existing rows.

Hi please assist.

I have a table as follows:

Some values need to be split by percentage, so I have the following table:

I would like the result to show the split value added to their appropriate products and removed from the existing rows. The result would be:

I'd prefer Dax, but will revert to Query editor if that is the suggested option.

Thanks

Kevin