Budget Comparison Spreadsheet - PDF

Document Sample

```					                                    Lehigh Valley Premier Soccer Club
Lehigh Valley Golden Lions U18 Girls Premier Soccer

2010/2011 Estimated Team and Player Budgets

Attached you will find a spreadsheet that lays out the estimated team and individual player budgets for
2010/2011,compares this year’s budget to last years, provides explanation for increases, and provides some
ideas where expenses could be reduced. The budget presents a realistic assessment of the costs to operate the
team where the ultimate objective for the players is to be able to play intercollegiate soccer. My realistic
assessment of our currently rostered players at this moment in time is that assuming continued development at
the current pace, all of our players will be able to play intercollegiate soccer at some level should they choose to
do so.

•   What the spreadsheet shows

There are really two spreadsheets: The one at the top of the page shows a comparison between last year’s and
this year’s team budgets. The one at the bottom shows the same data but for the individual player share.

•   What the spreadsheet columns mean

09/10 Budget                        The budget for operations for 2009/2010.
% of 09/10 Budget                   The percentage of the total 09/10 budget represented by
each line item
10/11 Budget                        The budget for operations for coming year, 2010/2011.
% of 10/11 Budget                   The percentage of the total 10/11 budget represented by
each line item
Amount of Increase (Decrease)       The amount that line item has increased from 09/10 to
from 09/10                          10/11
Item % Increase/Decrease            The increase/decrease of that line item as a percentage
from 09/10                          of the same line item in 09/10

As you are aware, given the state of the economy and the fact that the recession has affected all team families,
my intent this year was to keep the team’s budget as close to flat as possible. This was made quite a bit more
complicated by LVU’s doubling for direct fees its players are charged from \$100 per player to \$200. The initial
budget that I had developed for 10/11 came out to \$38,569.95, a 7.7% increase over 09/10. Based on cuts
totaling \$3,357.50, this year’s budget is projected to be \$35,212.45, an actual decrease of 1.7%

The 2010/2011 line time detail budget, which includes the attached spreadsheets, has been posted to the
team’s website on the Forms & Documents page.

•   Coaching & Training

While the projected expenses for coaching and training have increased 2.4% from 09/10, the overall increase
has been limited through the following:

1. Sharing goalkeeper coach with team that will be sharing Saucon Park C with us.
2. Reducing trainer services through the following:
a. reducing game day services from 5 games to 3;
b. reducing tournament game day services from 6 days to 4;
c. reduction in trainer conducted weekly sessions in the Fall from 14 to 12; and
d. elimination of most indoor training and the trainer services to support them.

•   Outdoor Tournaments & League Play

While absolute tournament, referee, and field use fees have increased, overall, these expenses have been
reduced 16% from 09/10 through the following:

1. sharing Saucon Park C with another team; the single biggest source of reduced costs.
2. eliminate Triangle Friendlies tournament
1
Lehigh Valley Premier Soccer Club
Lehigh Valley Golden Lions U18 Girls Premier Soccer

3. minor reductions in referee fees and PAGS registration due to a probable PAGS league schedule of 9
rather than 10 games
4. possible additional reductions through elimination of either or both the Futures in Soccer Showcase or
MAPS/MSSL Summer Showcase tournaments.

•   Areas Where Additional Money Could be Saved

This is a really bare-bones budget and I don’t see where we can make many or any additional cuts and still
meet the team’s Mission and Vision.

•   Caveats

1. The budget is based on a roster of 18 players. While we now have 16 players rostered for next year, my
intention is to find two additional players during the high school season and carry a full roster. The per
player cost will increase if we end up with less than 18 or if a player drops off the roster.

2. Savings are projected through sharing our goalkeeper coach and sharing Saucon Park C with what will
be the LVU U15 girls team. Right now, this looks as though it will be a reality. If it does not, the per
player costs will increase.

3. Trainer travel expenses – travel, lodging, meals - for tournament game services are difficult to project
and have not been included in the budget. These will be added to a player’s monthly fees in the month
the expenses occur.

•   Making Some Money/Fundraising

A number of you have presented ideas for fundraising. I don’t believe that fundraising is a coaching issue and
have, in the past, tended to shy away from conversations about it. On the other hand, it is a team management
issue, particularly so now because we have had to cut our budget. I’ve had some experience in the past with
team fundraising, some good, some not so good. A fundraising effort can be and incredible team building
experience for all concerned if it is done properly or it can be a disaster. For me to agree to support it, as a
team, everyone needs to agree on the following:

1. The organization and management of the effort must come from players and families. I will certainly
participate in the discussions of it and may be able to provide some fundraising myself (e.g., from
corporate sponsorships) but I will not manage or lead the effort. That must come from you.

2. The fundraising effort must have a concrete objective or goal. I.e., why are we doing this and how will
the money we raise be spent.

3. Everyone, all players and families must agree to participate.

4. Everyone must agree on how the money raised will be distributed to players.

5. Someone must agree to be responsible for the bookkeeping associated with the fundraising effort.

I’ve carried on here probably for longer than I should. However, the team’s budget is a very important item.
Nothing happens without it. My personal philosophy for these things is that transparency is vital and I hope this
contributes to that. Please let me know if you have questions.

Mike McNeish, Coach
LV Golden Lions U17 Girls Premier
Lehigh Valley United FC

2
LehighValley United FC - LV Golden Lions U18 Girls Premier                      3/25/2010
Comparison Between 09/10 and 10/11 Budgets
Team Budget Comparison
Item %
% of                      % of  Amount of Increase
09/10         09/10    10/11            10/11    Increase     from
Budget Item                            Notes           Budget         Budget  Budget            Budget from 09/10    09/10
1.   Coaching & Training                   10,11,12,13     \$16,480.00       46.0% \$16,877.50          47.9%     \$397.50       2.4%
2.   Outdoor Tournaments & League Play      5,6,7,8        \$12,865.00       35.9% \$10,810.00          30.7% (\$2,055.00)    -16.0%
3.   Indoor Tournaments & League Play         14            \$3,335.00        9.3% \$2,600.00            7.4%    (\$735.00)   -22.0%
4.   Uniform                                   4                \$0.00        0.0%      \$0.00           0.0%        \$0.00      0.0%
5.   Miscellaneous                                          \$1,024.95        2.9% \$1,024.95            2.9%        \$0.00      0.0%
6.   Registration                              2              \$300.00        0.8%    \$300.00           0.9%        \$0.00      0.0%
7.   Lehigh Valley United Player Fee           3            \$1,800.00        5.0% \$1,800.00            5.1%        \$0.00      0.0%
7.   Lehigh Valley United Admin Fee                             \$0.00        0.0% \$1,800.00            5.1% \$1,800.00     100.0%
Estimated Total for Team                 \$35,804.95        100% \$35,212.45           100%    (\$592.50)     -1.7%

Individual Player Share Comparison
Item %
% of                      % of    Amount of Increase
09/10         09/10         10/11       10/11      Increase     from
Budget Item                            Notes           Budget         Budget       Budget       Budget   from 09/10    09/10
1.   Coaching & Training                   10,11,12,13        \$915.56       46.0%         \$937.64     47.9%        \$22.08       2.4%
2.   Outdoor Tournaments & League Play      5,6,7,8           \$714.72       35.9%         \$600.56     30.7%      (\$114.17)   -16.0%
3.   Indoor Tournaments & League Play         14              \$185.28        9.3%         \$144.44      7.4%       (\$40.83)   -22.0%
4.   Uniform                                   4                \$0.00        0.0%            \$0.00     0.0%          \$0.00      0.0%
5.   Miscellaneous                                             \$56.94        2.9%           \$56.94     2.9%          \$0.00      0.0%
6.   Registration                              2               \$16.67        0.8%           \$16.67     0.9%          \$0.00      0.0%
7.   Lehigh Valley United Player Fee           3              \$100.00        5.0%         \$100.00      5.1%          \$0.00      0.0%
7.   Lehigh Valley United Admin Fee            3                \$0.00        0.0%         \$100.00      5.1%       \$100.00   100.0%
Estimated Individual Player Share                  \$1,989.16        100%       \$1,956.25      100%       (\$32.92)     -1.7%
Please see notes, attached.                                                                                    Page 1 of 1
Lehigh Valley United FC – LV Golden Lions U18 Girls Premier
09/10 - 10/11 Budget Comparison Notes

1.   Coaching & Training: Fees associated with our trainer, Mark Stone, and our goalkeeper coach, Terry Konawalik,
have increased. Even so, the overall increase in these costs has been limited to 2.4%.

•   We expect to share the goalkeeper coach’s services with the team that will be sharing Saucon Park C with us.
•   Trainer fee increases have been limited by (a) reducing game day services from 5 games to 3; (b) reducing
tournament game day services from 6 days to 4; (3) reduction in trainer conducted weekly sessions in the Fall
from 14 to 12; and (4) elimination of most indoor training and the trainer services to support them.

Ways to increase trainer services that have been cut:

•   Eliminate attendance at one or more tournaments. (See below.)

Caveats

•   Trainer travel, lodging, and meal expenses for tournament attendance are not directly budgeted because of the
difficulty of projecting what the amount may be. These costs will be added to player statements in the month
they occur.
•   While we expect to be able to share the services of our goalkeeping coach and thus reduce costs, if that does
not pan out, the projected goalkeeping expenses will double.

2.   Outdoor Tournaments & League Play: While tournament, referee, and field use fees have increased, these
expenses have been reduced 16% from 09/10 to 10/11 through the following:

•   Sharing Saucon Park C with another team; the single biggest source of reduced costs.
•   Eliminate Triangle Friendlies tournament
•   Some minor reductions in referee fees and PAGS registration due to a probable PAGS league schedule of 9
rather than 10 games
•   Possible additional reductions through elimination of either or both the Futures in Soccer Showcase or
MAPS/MSSL Summer Showcase tournaments.

Caveats

•   As with the goalkeeping coach expenses, we expect to share the expenses of using Saucon Park C. If that
does not pan out, the projected Fall field use fees will double.

3.   Indoor Tournaments and League Play: While costs have increased for league, tournament, indoor cup, indoor
field use for training, and referee fees, our overall costs have ben reduced 22% by elimination of indoor
tournaments and trainer services of indoor training sessions.

4.   Uniform: The uniform has been eliminated as a line item in this year’s budget since all uniform clothing is now
sponsored by K-12 Systems. Note though that players needing replacement or additional items beyond their initial
issue are responsible for those expenses

5.   Miscellaneous: Includes OneCallNow mass calling system, GotSoccer player profile system, field equipment, and
first aid supplies. The costs for this area are projected to be flat.

6.   Registration: EPYSA registration and insurance. The costs for this area are projected to be flat.

7.   Lehigh Valley United Fees: The addition of the LVU Administration Fee to the already existing Player Fee
represents a 100% increase in LVU fees from 09/10 to 10/11.

4

```
DOCUMENT INFO
Shared By:
Categories:
Stats:
 views: 73 posted: 1/10/2011 language: English pages: 4
Description: Budget Comparison Spreadsheet document sample
How are you planning on using Docstoc?