Annual Troop Budget Spreadsheet

Administering the troop, solving problems, building on success, and using key program elements like the Patrol Method.

Moderators: Site Admin, Moderators

Annual Troop Budget Spreadsheet

Postby optimist » Mon Oct 18, 2004 1:32 pm

I was trying to put together a comprehensive budget for my troop so I looked around the web for resources. I took what I found out there and put together my own Excel spreadsheet. Please check it out and tell me what you think. It's in the Forms and Files section of MeritBadge.com at the end of the Boy Scout Forms area.
optimist
Adv Chair
 
Posts: 947
Joined: Tue Aug 10, 2004 8:25 pm
Location: Atlanta Area Council

Postby evmori » Mon Oct 18, 2004 1:55 pm

Not bad!
Ed Mori
1 Peter 4:10
evmori
Gold Palm
 
Posts: 1109
Joined: Thu Aug 12, 2004 3:24 pm
Location: Greater Pittsburgh Pittsburgh, PA

Postby 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.
commish3
 

excel

Postby cballman » Mon Oct 18, 2004 7:36 pm

Ok people to many people like my wife on this issues section. I am getting to hate organized people who make me look sick :shock: I just came back from woodbadge and to see the young critters there and their computer skill make me look like an old geezer :( :roll: :roll: Hold on maybe I am :shock: :shock: that goes to show everyone out there there is a place fo everyone in scouting even me :lol: :lol:
cballman
 

Postby wagionvigil » Mon Oct 18, 2004 7:46 pm

There is always a place for a Bear. WHos going to tell you any different?
NER Area 4 COPE/Climbing Chairman
NE Area 4 Venturing Chairman
"If You Ain't a Bear, You're a Meal!"
wagionvigil
Counselor
 
Posts: 5457
Joined: Wed Aug 11, 2004 7:01 am
Location: Westmoreland-Fayette Council BSA

Postby optimist » Wed Oct 20, 2004 8:06 am

Another budget spreadsheet was sent to me by Chief J. It is much more detailed than the one I came up with. I have posted it on MeritBadge.com as well. Check it out :)
optimist
Adv Chair
 
Posts: 947
Joined: Tue Aug 10, 2004 8:25 pm
Location: Atlanta Area Council

Postby Guneukitschik » Wed Oct 20, 2004 2:53 pm

I personally like the spreadsheet format because of the fact that you can easily modify it to fit your troop.

Each troop is different and a single spreadsheet to aid in preparing a budget would probably be impossible to meet the demands of EVERY troop.
Guneukitschik
 


Return to Troop Issues

Who is online

Users browsing this forum: No registered users and 2 guests