HELP: Calculate percentage of time worked with employees of different pay rates

[metsmjl]

I need a formula to help me calculate the following:

FACTS:
Total budget = $200,000
Employee 1 - $25/hr - 50% of total budget
Employee 2 - $20/hr - 30% of total budget
Employee 3 - $30/hr - 20% of total budget

How many hours will each employee work so that they each work their allocated percentage of the total budget and the total cost is $200,000?

PLEASE HELP! If you would like me to clarify anything, please let me know. The only way I can figure out how to do this now is just guessing and checking. It's 2019, there's got to be a better way!

Thanks!

[tim201110]

=sum(n(offset(b1,row(1:3),))*c1/a2:a4)

[metsmjl]

=sum(n(offset(b1,row(1:3),))*c1/a2:a4)

Thank you so much!