Need a Weight% to Reach Goal Formula

[lsantana]

Hello All,

Please find attach my problem.

I need to fill column B with a weight percentage, but my "Volume Item" and "Bonus Per Item" columns must stay the same to achieve the weighted average goal of $38.81. My "Weight %" must equal to 100% and "Total Bonus" will equal "Total Bonus Goal" of $1,048,929.84 if "Weight %" are correct. I know there will be variable answers, but any answer will be fine.

Pleaseee any help with this will be truly appreciated.

Thank you,