Join the Genealogy Revolution.
Search for your surname in the largest DNA database of its kind!

My Surname


Footnote.com

Banner - Family Tree Maker 2008

Domain Name Registration at GoDaddy.com 120x60


Family Reunion Forum

Re: Reunion Record-Keeping
In Response To: Re: Reunion Record-Keeping ()

Hello,
Are you familiar with spreadsheets? If so, e-mail me at melvinjcollier@gmail.com and I will e-mail you an example spreadsheet (Excel file).

For my reunions, family members pay for the events they are attending, whether than one set fee that takes care of the entire reunion. Family members prefer this payment method because some complain that they shouldn't have to pay for the events they are unable to attend. Therefore, this calls for more meticulous record-keeping.

Our costs are broken down to half price from children 5-12 and free for children under 5 for each event. This price structure did not apply to the Saturday tour. It was set on a per-person rate.

In the spreadsheet, I used formulas to calculate the fees. Let's say that for the Roy Smith Family, 3 of them are attending all events (Fri., Sat, and Sun.), and one can't make it in time to attend Fri. night's event, but will be there for Sat. and Sun. So, in one column, I enter the head of their household/family (Roy Smith), the total number in that family attending the reunion (4), the number attending on Fri. (3), the number attending the Saturday tour (4), the number attending the Saturday night banquet (4), and the number attending Sunday (4). At the end, there is a column that automatically spits out the fee they should be sending in. The next column after that, you will enter in the amount they paid (which should agree with the previous column), and the last column is "Amount Due", in case a family did not send in enough money to pay for the events they say that they were attending.

I must admit, setting one fee for the entire reunion is MUCH easier to keep record of. But since my family has been "spoiled" with this payment method, I would probably be 'cussed out' badly for trying to change it to one set fee! LOL!

Melvin


18 Dec 2002 :: 14 Nov 2008
Copyright © 2002-2008 by AfriGeneas. All rights reserved.
AfriGeneas ~ African Ancestored Genealogy