I uploaded an edited sheet laid out with how it works presently with the formula and how I'd like the formula to eventually work.
The second table has the formulas knocked out of the planned goal that has actual units next to it.

Hopefully it clears things up!

Planned Vs Actual.xlsx