Hello!
I'm looking for a currency / payout spreadsheet where you list the total number of bills and coins you have (example, 5x$100 bills, 3x$50 bills, 20xquarters, 10xdimes, 5xnickels) and then calculates how many of each should be given to 30 employees based upon a payout amount.
So for example, I have $2537.82 to split between 30 employees, I denominations of bills and coins. Each employee receives a different percentage of this money based upon weightings that were previously calculated on another spreadsheet. Let's say the top payout is $161.42 all he way down to $12.11. I need a spreadsheet that will tell me how many of each bill and coin each employee should get, ensuring the highest paud employees get more hundreds, fifties, twenties, etc, and keeping the payouts fair so that all employees receive a fair amount of bills and someone doesn't get all coins. Does this make sense?
In case you haven't figured it out, this is meant for a tip pool calculation at a restaurant that divides cash to 30 employees, and I'm tired of having to spend an hour manually splitting and dispursing the cash every two weeks. Thanks!
Bookmarks