weighted average solution?

[brooksres]

I have following set up.

Is it possible to install a formula that will automatically calculate the weighted average in column I, that is necessary to achieve a new sum, that is greater than or equal to the value in L28? Lets say I have 67.80 in L28, I want the values in column I to automatically change to increase the weighted average in J28 to equal or greater value of L28 to the nearest Hundredths of a decimal or using only 2 decimal points.

Any help is always greatly appreciated.

DOE-CDM-ETEC RATES Final Revision 3 (2).xls
	H	I	J	K
23	$59.74	0.40	$23.90	$17.45
24	$70.00	0.60	$42.00	$30.66
25	$59.74	0.00	$0.00	$0.00
26	$49.45	0.00	$0.00	$0.00
27
28		1.00	$65.90	$48.11
Rate Development - T&M Yr2

 

[Jubjab]

Column L is missing from your picture, but seems vital for the solution to your problem.