I have a target sum to achieve with some constrains such as - individual numbers have a constant divisor, variable must be of 2 decimals only and sum target for 2 out of 5 data.
The grand total of the row totals must be 62,185.
I tried to use solver, but got stuck.
Divisor Hours Row Total (2 decimals only)
74.03 variable of 2 decimals Product of Divisor & Hours
74.03 variable of 2 decimals Product of Divisor & Hours
74.03 variable of 2 decimals Product of Divisor & Hours
74.03 variable of 2 decimals Product of Divisor & Hours
74.03 variable of 2 decimals Product of Divisor & Hours
94.08 variable of 2 decimals Product of Divisor & Hours