Kit and Component Parts: How to show correct quantity variance via Formula

[ashleyinman]

I would like to figure out how to correctly show the variance of a item that is in a kit. 

Qty 1 I receive from one source and Qty 2 comes from another source.  I'm unsure what type of formula would be needed to show the variance like below. 

[Joe_Mako · Accepted solution]

How about something like the attached?

Depending on your logic and real data structure, this may need to be adapted to fit your situation. I assumed the the way to identify a sub-part was the Part starting with a space.