Spreadsheet: 86396d1286384514-changing-value-of-one-cell-to-another-is-zero-2011-proposed-budget
Sheet: 2011 budget

 |  | 2009 Actual |  | 2010 Actual |  | 2010 Original |  | 2010 Revised |  | 2011 Proposed
 |  | Income & |  | Income & |  | Budgeted |  | Budgeted |  | Budgeted
 |  | Expenses |  | Expenses up to |  | Income & |  | Income & |  | Income &
 |  | full year |  | 2009-09-30 00:00:00 |  | Expenses |  | Expenses |  | Expenses
GENERAL FUND INCOME |  | 725696.01 |  |  |  | 789530 |  | 770617.49 |  | 777939
EXPENSES
CAPITAL IMPROVEMENTS
Building Improvements |  | 8000 |  | 0 |  | 8000 |  | 8000 |  | 8000 | 1
*Reflects capital improvements foreseen for parking lot sealing & other areas by trustees
Growth Fund |  | 18000 |  |  |  | 18000 |  | 18000 |  | 18000 | 2
Furniture & Equipment |  | 8217.21 |  |  |  | 8000 |  | 8000 |  | 8000 | 3
*Reflects new equipment or unbudgeted, unforeseen items including equipment that breaks & needs replaced.
TOTAL CAPITAL IMPROVEMENTS |  | 34217.21 |  | 0 |  | 34000 |  | 34000 |  | 34000
EDUCATIONAL
AWANA |  | 6743.41 |  |  |  | 7850 |  | 7850 | * | 7850
*Reflects reimbursements received for dues, uniforms, materials
CBF |  | 5514.91 |  |  |  | 4700 |  | 4700 | * | 4400
*Reflects participant's reimbursement of materials
Childrens Church |  | 7033.09 |  |  |  | 8475 |  | 8475 |  | 8475
Leadership Development |  | 3168.73 |  |  |  | 3000 |  | 3000 |  | 4000 | 4 | reevaluate wam general
Life Skills |  | 1995.61 |  |  |  | 2959 |  | 2959 | * | 2710
*Reflects participant's reimbursement of materials
Mens |  | 532.61 |  |  |  | 500 |  | 500 |  | 1000
New Beginnings |  | 268.05 |  |  |  | 350 |  | 350 |  | 350
Nursery |  | 16648.39 |  |  |  | 17000 |  | 17000 |  | 1500 |  | paid workers moved to salaries & wages
Single Focus |  | 0 |  |  |  |  |  | 1000 |  | 600
Teacher's Resource Center |  | 1562.76 |  |  |  | 2000 |  | 2000 |  | 1000
Transitions |  |  |  |  |  |  |  |  |  | 600
Womens |  | 1543.62 |  |  |  | 1880 |  | 1880 |  | 1880
Youth |  | 15777.42 |  |  |  | 15800 |  | 15800 |  | 15715
TOTAL EDUCATIONAL |  | 60788.60000000001 |  | 0 |  | 64514 |  | 65514 |  | 50080
OPERATIONS
Building & Van Insurance |  | 9422.02 |  |  |  | 9500 |  | 9500 |  | 9700 | 5
Communications/IT |  | 2464.54 |  |  |  | 3035 |  | 3200 |  | 3095
Custodial |  | 2990.48 |  |  |  | 4325 |  | 4325 |  | 4325
Church Flowers & Decorations |  | 819.35 |  |  |  | 800 |  | 800 |  | 800
Maintenance |  | 24999.35 |  |  |  | 25000 |  | 25000 | * | 25000
*Reflects repairs & maintenance of all equipment owned by church.
Office |  | 13354.17 |  |  |  | 12415 |  | 12415 |  | 11270
Public Relations |  | 1246.4 |  |  |  | 2000 |  | 2000 |  | 1000
Service Expenses |  | 11153.28 |  |  |  | 8825 |  | 8825 |  | 7275
Special Events |  | 0 |  |  |  | 2500 |  | 2500 |  | 2500 | 7
Utilities |  | 32184.41 |  |  |  | 33000 |  | 33000 |  | 34000 | 8
TOTAL OPERATIONS |  | 98634 |  | 0 |  | 101400 |  | 101565 |  | 98965
OUTREACH
Evangelism |  | 1480.15 |  |  |  | 2500 |  | 2500 |  | 2500 | 6
Kindness in Action |  | 1381.22 |  |  |  | 2500 |  | 2500 |  | 2500
Missions Support |  | 87083.52 |  |  |  | 94744 |  | 92474 | (12%) | 93353
Upward Basketball/Cheerleading |  | 77.99 |  |  |  | 500 |  | 500 |  | 500
TOTAL OUTREACH |  | 90022.88 |  | 0 |  | 100244 |  | 97974 |  | 98853
SALARIES & EXPENSES
Continuing Education |  | 6155.77 |  |  |  | 10750 |  | 10750 |  | 10750 | 14 | Can we bring down for one leader in childrens
FICA |  | 14873.33 |  |  |  | 20231 |  | 19791.77 |  | 21831 | 9
Mileage |  | 2937.44 |  |  |  | 3500 |  | 3500 |  | 3500
Retirement |  | 5000.04 |  |  |  | 6000 |  | 5333.33 |  | 6000
Salary & Wages |  | 276110.9 |  |  |  | 324212 |  | 319196.04 |  | 324189 | 10
Staff Insurance |  | 49430.97 |  |  |  | 78079 |  | 66393.35 |  | 98545 | 11
TOTAL SALARIES & EXPENSES |  | 354508.4500000001 |  | 0 |  | 442772 |  | 424964.49 | * | 464815
*Reflects raises & increased health insurance costs
SERVICE
ALMS |  | 2618.85 |  |  |  | 2865 |  | 2865 |  | 900
Connections |  | 839.95 |  |  |  | 1495 |  | 1495 |  | 1635 | 13
Flowers |  | 2906.61 |  |  |  | 3000 |  | 3000 |  | 2500
Hospitality |  | 4750.28 |  |  |  | 7430 |  | 7430 |  | 6640
*Reflects reimbursements received for donuts
Miscellaneous |  | 255.43 |  |  |  | 500 |  | 500 |  | 500
Prayer |  | 958.76 |  |  |  | 2740 |  | 2740 |  | 2740
SHARE |  | 400.27 |  |  |  | 500 |  | 500 |  | 500 | 12
Special Gifts |  | 2881.88 |  |  |  | 2200 |  | 2200 |  | 2200
TOTAL SERVICE |  | 15612.03 |  | 0 |  | 20730 |  | 20730 |  | 17615
WORSHIP ARTS MINISTRY
Children's Choir |  | 500 |  |  |  | 500 |  | 500 |  | 500 |  | reevaluate
Choir |  | 4206.75 |  |  |  | 4500 |  | 4500 |  | 4300
Drama |  | 800 |  |  |  | 700 |  | 700 |  | 700
Interpretive Movement |  | 137.98 |  |  |  | 400 |  | 400 |  | 500
Praise Band |  | 700 |  |  |  | 820 |  | 820 |  | 820
Production |  | 6000 |  |  |  | 6000 |  | 6000 |  | 6000
Sound/Audio/Video |  | 14992 |  |  |  | 4700 |  | 4700 |  | 4700
Youth Choir |  | 399.99 |  |  |  | 400 |  | 400 |  | 0
WAM General Expenses |  | 7865.01 |  |  |  | 7850 |  | 7850 |  | 1850 |  | need to reevaluate-discussed w/[NAME]
TOTAL WORSHIP ARTS MINISTRY |  | 35601.73 |  | 0 |  | 25870 |  | 25870 |  | 19370
TOTAL EXPENSES |  | 689384.9 |  | 0 |  | 789530 |  | 770617.49 |  | 783698
TOTAL SURPLUS (DEFICIT) |  | 36311.10999999999 |  | 0 |  | 0 |  | 0 | * | -5759
REQUIRED WEEKLY OFFERING |  | 13257 |  |  |  | 15183 |  | 14820 |  | 15071
INCREASE IN WEEKLY EXPENSES |  |  |  |  |  |  |  |  |  | 0.01693657219973009 |  | Which 2010 column do you want to use?
INCREASE IN WEEKLY EXPENSES |  |  |  |  |  |  |  |  |  | 251
CURRENT WEEKLY OFFERINGS |  |  |  |  |  |  |  |  | * | 13333 |  | 14000 | 5% increase |  | 40000-45000 decrease
*Based on average offerings from Jan-Sept 30, 2010.
INCREASE REQUIRED IN WEEKLY OFFERING |  |  |  |  |  |  |  |  |  | 0.1303532588314708
INCREASE REQUIRED IN WEEKLY OFFERING |  |  |  |  |  |  |  |  |  | 1738 | 15
Discussion Points:
1.  Expecting to seal and stripe at least front and side lot.  Marked up for other unexpected building improvements as well.
2.  monthly growth support
3.  Expecting to replace one projector this year for CBF classes.  $2500 estimated to be used for new senior chairs ($60-100/chair).  Youth/WAM Pastor may need a keyboard for estimate $1200 (youth using old one right now that is usually kept in WAM office).  Furniture/Computer for WAM Pastor will be needed.  Any replacement of items owned by church that break will need purchased.
4.  Upward leaders, Awana commanders college, Awana class leaders, [NAME], & comm/IT included in leadership development.  Leaders need to get prior approval.
5.  Auto 828+umbrella $798 + building $7942 (expect small increases)
6.  50 New Believer's kits $1500 added to existing $1000 in 2010
7.  Honorariums, speakers, lodging, transportation, any PR exp.  Used to be ran through whatever available (service, special gifts, [NAME])
8.  Used same % increase as last year of 2.8%
9.  See base number for calculation below
10.  See calculation below
11.  See calculation below
12.  Food for sick members, food for dinners, gift bags, cards, postage-all for elderly members
13.  Gatekeepers, Ushers, Greeters, Welcome Ctr share this line item
14.  Three pastors $2000 each plus $2000 youth pastor, $1250 life skills and $1500 childrens directors.
15.  WAM pastor
48300 | salary/bonus
3694.95 | fica
18096 | insurance
2000 | continuing education
600 | mileage-not really all for him-see the need to up this line item
1000 | retirement
73690.95 | yearly benefit
1417.133653846154 | weekly inc
320.8663461538463 | inc in overall budget w/o wam pastor
WAM pastor |  |  |  |  |  |  |  |  |  | 48000
[NAME] |  |  |  |  |  |  |  |  |  | 25942.19
jerica |  |  |  |  |  |  |  |  |  | 27003.6
[NAME] |  |  |  |  |  |  |  |  |  | 46071.9
[NAME] |  |  |  |  |  |  |  |  |  | 64004.89
mary |  |  |  |  |  |  |  |  |  | 31969.6
melinda |  |  |  |  |  |  |  |  |  | 22068.8
michelle |  |  |  |  |  |  |  |  |  | 44913
sherri |  |  |  |  |  |  |  |  |  | 14214.72
Current salaries |  |  |  |  |  |  |  |  |  | 324188.7000000001
raise |  |  |  |  |  |  |  |  |  | 0
total budgeted salaries |  |  |  |  |  |  |  |  |  | 324188.7000000001
christmas bonuses (300 for pastors, $250 for rest) |  |  |  |  |  |  |  |  |  | 2650
mowing payroll |  |  |  |  |  |  |  |  |  | 1900
nursery payroll |  |  |  |  |  |  |  |  |  | 15340
maintenance payroll |  |  |  |  |  |  |  |  |  | 5200 |  | can we get rid of?
fill in payroll |  |  |  |  |  |  |  |  |  | 400
accounting contract labor |  |  |  |  |  |  |  |  |  | 4800
total salaries & wages-rounded to nearest 100 |  |  |  |  |  |  |  |  |  | 354478.7000000001 | 9
Plus:
[NAME] not subject to fica |  |  |  |  |  |  |  |  |  | 64304.89
Less:
accounting contract labor |  |  |  |  |  |  |  |  |  | 4800
payroll subject to fica  7.65% |  |  |  |  |  |  |  |  |  | 285373.8100000001 | 10
WAM leader & family |  |  |  |  |  |  |  |  |  | 1450
scott & family |  |  |  |  |  |  |  |  |  | 1402
larry & family-will go down for no family-husband & spouse |  |  |  |  |  |  |  |  |  | 1472
Sherri only-Jan 1 60/40 |  |  |  |  |  |  |  |  |  | 515 |  | 857.34
michelle-will go up for 40 yrs old |  |  |  |  |  |  |  |  |  | 600
melinda |  |  |  |  |  |  |  |  |  | 567
[NAME] (80/20) |  |  |  |  |  |  |  |  |  | 474 |  | 591.94
total monthly |  |  |  |  |  |  |  |  |  | 6480
months |  |  |  |  |  |  |  |  |  | 12
total yearly |  |  |  |  |  |  |  |  |  | 77760
increase-agent says 25% & 2010 it increased 19% |  |  |  |  |  |  |  |  |  | 1.19
Total estimated health insurance |  |  |  |  |  |  |  |  |  | 92534.4 | 11
reimbursement of deductible (80% of $1000 for all empl) |  |  |  |  |  |  |  |  |  | 5600
life insurance paid quarterly ($102.60*4) |  |  |  |  |  |  |  |  |  | 410.4
Total insurance-rounded up to nearest 100 |  |  |  |  |  |  |  |  |  | 98544.79999999999