Formula for proportionaly share a value based on criteria

Dear users,


I come in requesting your support in finding an excel formula to proportionally share a value of 33 to a couple of members based of their fulfilled contribution considering the following:

"A" has a yearly quota of 44 from which it covered 17;
"B" has a quota of 17 from which it covered 10;
"C" has a yearly quota of 55, from which it covered 25.

I have to mention that the value of 33 has to be proportionally shared to A, B, and C.

Is there any formula for this?

Thanks in advance! All the best!

Total contribution is 52.
The share of A's/B's/C's contribution is: 33%, 19% and 48%.
Multiply that each by 33, A gets (depending on how you round) 11, B 6 and C 16.

Dear RaulSerg,

Thanks a lot for your imput. I appreciate it!
Your response brings me closer to the desired method of calculation.
Just one kind remark that I've missed to add.
The value of 33 have to be shared based on the yearly quota coverage of each of them, not to the total contribution of 52. namely,
A's coverage contribution is 39% (44 quota and 17 contribution), B's 59% and C's 45%.
Do you think you cand find a solution of this?
Thanks in advance!

What he says (:

Thanks JohnTopley for the proposed solutions!
Thanks RausSerg for clarifications.

The only remaining problem is that assigning the value of 14 to the already provided contribution to B will result in a total contribution of 24 (with 7 units above his quota), which means a total coverage of 141% which means additional contribution above the extablished quota. Is it possible to share the value of 33 proportionally but without exceeding the initially assigned quota?