Reverse engineer to create unknown numbers based on known percentage allocations

[raynerfredrick]

I'm trying to reverse engineer hours based on a team with various %s totaling 100%. In the end, hours X each individuals known Rate will all sum to be $175,000. I have a program that does this but I'm trying to replicate in excel. First table below is completed in the program and every time I modify the %, it reallocates hours to total 100%. Second table is emptyAny help appreciated.

TYPE	%	HRS	RATE	AMOUNT
A	5	23.52	$750	$17,641
B	5	23.52	$430	$10,114
C	15	70.56	$365	$25,756
D	15	70.56	$295	$20,817
E	10	47.04	$300	$14,113
F	20	94.09	$500	$47,043
G	15	70.56	$280	$19,758
H	15	70.56	$280	$19,758
	100%	470.41	$372	$175,000
TYPE	%	HRS	RATE	AMOUNT
A			$750
B			$430
C			$365
D			$295
E			$300
F			$500
G			$280
H			$280
	0%		$372	$175,000

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[sheetspread]

Solver will do this, hang on I'll post an example

 

[sheetspread]

goal seek works too here, and is easier

 

[raynerfredrick]

Worked perfectly. Thanks so much for your help.