by commish3 » Mon Oct 18, 2004 4:41 pm
A couple of thoughts. It looks like you have many of the income and expense items figured out, You might recalculate the cost of advancement depending on your program. A nit that uses New Scout Patrl and First Class Emphasis will usually spend more on advancement in the first 12 months of a scouts membership than in any other single year.
You might also consider future equipment needs, repair and replacement. For instance our family budget includes a new roof that we won't need for several years but we know that we will need one so we wett a portion aside each year for it.
You have tents that will need replacement at some point. We figure in 1/8 the estimated cost of a tent per boy each year so that in 4 years each pair of scouts has paid for a new tent.
Structurally Excel will do a lot more for your project than you are incorporating now. For instance yuou are retyping amounts into the lower portion that you could have being filled in automatically as the calculations are completed above.
Also just from ease of reading you might consider putting income in a different column from expenses. (One technicallity, The cost of registration is now $10)
I hope this was the kind of feedback you were looking for.