Excel needed back asap

Pro.xlsx

Sheet1

Team	Good qty	Total Qty	demand rate
A	46	222	40.73
B	257	1141	76.04
C	710	3316	272.65
TOTAL	1013	4679	389.42
		22%
percentage of good quantity to Total qty is currently 22% which is bad. I need the percentage to get to 50%. Show ways in which the total percentage of Good qty can get to 50% 52% and 53%
This should be spread out between A, B,C