- #1
mrcleanhands
Firstly, I'm not even sure how to frame this mathematically, but I'd be curious to know what kind of problem it is and what kind of subjects within maths it requires to be able to solve it.
Here's my problem--
I've set it up in excel to help you visualise it.
There is a different amount of money owed to different people (Amounts Owed). There is a fund which'll be used to pay out those people (Pooled funds). The pooled funds do not equal the total amount owed. If I divide the amount of pooled funds by 4 and hand it out to each person evenly, the dollar loss amounts will be uneven (since each person is owed a different amount). What I'm trying to do is solve for values highlighted green (how much money is given to each person) such that the total dollar losses for each person will equal (that red column).
Is there some way to do this on paper very efficiently, or is it only a problem for the computer?
Here's my problem--
I've set it up in excel to help you visualise it.
There is a different amount of money owed to different people (Amounts Owed). There is a fund which'll be used to pay out those people (Pooled funds). The pooled funds do not equal the total amount owed. If I divide the amount of pooled funds by 4 and hand it out to each person evenly, the dollar loss amounts will be uneven (since each person is owed a different amount). What I'm trying to do is solve for values highlighted green (how much money is given to each person) such that the total dollar losses for each person will equal (that red column).
Is there some way to do this on paper very efficiently, or is it only a problem for the computer?