Results 1 to 2 of 2

Math Help - combining different charges to equal particular sum

  1. #1
    Newbie
    Joined
    Oct 2010
    Posts
    1

    combining different charges to equal particular sum

    I work in Accounts Receivable. Often we receive checks for particular payments that don’t reflect total amount due on the statement. The example below shows a payment for $7871.38. Which is the sum of the following charges, $123.66, $2.36, & $7745.36. Now the challenge is figuring out what combination of charges equal what the check was made out for. Right now we are using trial & error. Needless to say that is very time consuming. Is there an equation that exists that I could plug in all the numbers, do some math and figure this out more logically than trial an error?

    Due $123.66;
    Due $6658.02
    Due $142.36
    Due $2.36;
    Due $1236.07
    Due $7745.36;
    Due $6554.00
    Total Due:$22,461.83

    Payment $7871.38
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor
    Joined
    Dec 2007
    From
    Ottawa, Canada
    Posts
    3,166
    Thanks
    71
    Well, I'm sure a "formula" is out of the question...a computer "search"
    would be fastest...but then you may get 2 or 3 combos that work for
    the same amount.
    I say phone Mary Jane from the payer's accounts payable dept. and
    ask her which amounts she intends to pay, and to please include the
    invoice numbers next time
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. charges
    Posted in the Math Topics Forum
    Replies: 2
    Last Post: April 5th 2011, 09:10 PM
  2. More on Charges
    Posted in the Advanced Applied Math Forum
    Replies: 5
    Last Post: January 15th 2009, 07:00 PM
  3. Finance Charges and Computers! Help!
    Posted in the Algebra Forum
    Replies: 1
    Last Post: March 7th 2008, 09:16 AM
  4. objects and charges-physics basically
    Posted in the Advanced Applied Math Forum
    Replies: 1
    Last Post: February 25th 2008, 06:01 PM
  5. charges with Columbs law.
    Posted in the Math Topics Forum
    Replies: 1
    Last Post: January 8th 2008, 07:57 PM

Search Tags


/mathhelpforum @mathhelpforum