| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Committee Responsible | 2012 budget | Change 2011->2012 | 2009 | 2010 | 2011 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | ||||||||
2 | INCOME | JAN Budget | January Actual | FEB | MARCH | APRIL | MAY | JUNE | JULY | AUG | SEPT | OCT | NOV | DEC | ||||||||||||
3 | MEMBERSHIP FEES | Total Membership | $340,525 | 32% | $167,072 | $251,766 | $257,681 | |||||||||||||||||||
4 | CORPORATE MEMBERSHIP | Membership Committee | $260,000 | 30% | $135,863 | $214,331 | $199,301 | $21,000.00 | $8,000.00 | $21,000.00 | $21,000.00 | $21,000.00 | $21,000.00 | $21,000.00 | $21,000.00 | $21,000.00 | $21,000.00 | $21,000.00 | $21,000.00 | $21,000.00 | ||||||
5 | INDIVIDUAL MEMBERSHIP | Membership Committee | $80,525 | 38% | $31,209 | $37,435 | $58,380 | $6,130.00 | $6,965.22 | $6,130.00 | $6,130.00 | $6,130.00 | $6,130.00 | $6,130.00 | $6,130.00 | $6,130.00 | $6,130.00 | $6,130.00 | $6,130.00 | $6,130.00 | ||||||
6 | DONATIONS | Membership Committee | $1,581 | 47% | $2,835 | $2,342 | $1,076 | $100.00 | $381.29 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | ||||||
7 | TRAINING | Education Committee | $50,000 | #DIV/0! | $5,000.00 | $5,000.00 | $5,000.00 | $5,000.00 | $5,000.00 | $5,000.00 | $5,000.00 | $5,000.00 | $5,000.00 | $5,000.00 | ||||||||||||
8 | ||||||||||||||||||||||||||
9 | CONFERENCE PROFITS | Conference Committee | ||||||||||||||||||||||||
10 | USA | Conference Committee | $100,000 | 18% | $31,880 | $86,450 | $85,062 | $100,000.00 | ||||||||||||||||||
11 | EU | Conference Committee | $75,000 | $26,307 | $58,958 | $49,727 | $75,000.00 | |||||||||||||||||||
12 | ASIAPAC | Conference Committee | $25,000 | -$25,194 | $25,000.00 | |||||||||||||||||||||
13 | LATIN AMERICA | Conference Committee | $25,000 | $25,000.00 | ||||||||||||||||||||||
14 | REGIONAL EVENTS | Conference Committee | $69,000 | $27,678 | $25,096 | $5,750.00 | $5,750.00 | $5,750.00 | $5,750.00 | $5,750.00 | $5,750.00 | $5,750.00 | $5,750.00 | $5,750.00 | $5,750.00 | $5,750.00 | $5,750.00 | |||||||||
15 | LOCAL EVENTS | Conference Committee | $2,000 | $166.00 | $166.00 | $166.00 | $166.00 | $166.00 | $166.00 | $166.00 | $166.00 | $166.00 | $174.00 | $166.00 | $166.00 | |||||||||||
16 | Conferences Total Budget Estimate | $175,000 | 30% | $60,671 | $170,504 | $134,789 | ||||||||||||||||||||
17 | ADVERTISING REVENUE | $24,000 | -17% | $5,470 | $3,025 | $28,999 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | ||||||||
18 | INTEREST INCOME | $168 | $981 | $262 | $14.00 | $14.00 | $14.00 | $14.00 | $14.00 | $14.00 | $14.00 | $14.00 | $14.00 | $14.00 | $14.00 | $14.00 | ||||||||||
19 | TOTAL INCOME: | $591,275 | 40% | $237,029 | $427,899 | $422,545 | $35,160.00 | $35,160.00 | $65,160.00 | $40,160.00 | $40,160.00 | $40,160.00 | $115,160.00 | $40,160.00 | $140,160.00 | $40,168.00 | $65,160.00 | $40,160.00 | ||||||||
20 | ||||||||||||||||||||||||||
21 | EXPENSES | 2012 | 2012 | |||||||||||||||||||||||
22 | EXPENDITURES - OPERATIONAL | $397,860 | 14% | $227,839 | $342,856 | $347,598 | JAN | FEB | MARCH | APRIL | MAY | JUNE | JULY | AUG | SEPT | OCT | NOV | DEC | ||||||||
23 | PAYROLL | $194,000 | 128% | $132,656 | $137,051 | $85,063 | $15,000.00 | $15,000.00 | $15,000.00 | $15,000.00 | $15,000.00 | $17,000.00 | $17,000.00 | $17,000.00 | $17,000.00 | $17,000.00 | $17,000.00 | $17,000.00 | ||||||||
24 | BUSINESS OWNERS INS | $2,516 | 0% | $4,804 | $2,472 | $2,516 | $0.00 | $0.00 | $0.00 | $629.00 | $629.00 | $629.00 | $629.00 | |||||||||||||
25 | LIABILITY INS | $3,300 | 0% | $3,300 | $3,300 | $0.00 | $0.00 | $0.00 | $3,300.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||
26 | WORKERS COMPENSATION INS | $437 | 0% | $358 | $437 | $0.00 | $0.00 | $0.00 | $344.00 | $0.00 | $93.00 | $0.00 | ||||||||||||||
27 | TRAVEL ACCOMMODATIONS FOUNDATION (Operational Support) | $20,000 | 131% | $8,320 | $43,574 | $8,647 | $2,092.93 | $6,000.00 | $14,000.00 | $14,000.00 | $6,000.00 | |||||||||||||||
28 | TRAVEL ACCOMMODATIONS FOUNDATION (Board Travel to Global Conferences) | $20,000 | #DIV/0! | $2,508.37 | ||||||||||||||||||||||
29 | IT SUPPORT | Removed 12,000 accounted for in payroll | $0 | #DIV/0! | $21,861 | $18,054 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | ||||||||
30 | BANK SERVICE CHARGES | $3,307 | 24% | $2,584 | $2,361 | $2,676 | $258.95 | $258.95 | $258.95 | $458.95 | $258.95 | $258.95 | $258.95 | $258.95 | $258.95 | $258.95 | $258.95 | $258.95 | ||||||||
31 | OFFICE RENT | $5,400 | -25% | $5,400 | $10,800 | $7,200 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | ||||||||
32 | REGISTRATION | $20,400 | -34% | $30,743 | $1,700.00 | $1,700.00 | $1,700.00 | $1,700.00 | $1,700.00 | $1,700.00 | $1,700.00 | $1,700.00 | $1,700.00 | $1,700.00 | $1,700.00 | $1,700.00 | ||||||||||
33 | MEETING/CONFERENCING/TELEPHONE | $4,200 | -14% | $4,535 | $3,960 | $4,860 | $350.00 | $350.00 | $350.00 | $350.00 | $350.00 | $350.00 | $350.00 | $350.00 | $350.00 | $350.00 | $350.00 | $350.00 | ||||||||
34 | T.R. KLEIN (AUDIT) | $4,500 | -50% | $2,524 | $4,021 | $9,024 | $0.00 | $4,500.00 | ||||||||||||||||||
35 | EISNER (INT'L ACCOUNTING) | $5,000 | 0% | $5,000 | $0.00 | $5,000.00 | ||||||||||||||||||||
36 | SHIPPING | $14,400 | 33% | $16,095 | $16,082 | $10,789 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | ||||||||
37 | OFFICE SUPPLIES | $400 | -52% | $15 | $457 | $837 | $0.00 | $100.00 | $100.00 | $100.00 | $100.00 | |||||||||||||||
38 | OTHER PROFESSIONAL SERVICES | -100% | $9,996 | $367 | $955 | |||||||||||||||||||||
39 | SUMMIT (2013 Planning) | $100,000 | -43% | $19,048 | $100,000 | $175,550 | ||||||||||||||||||||
40 | ||||||||||||||||||||||||||
41 | Chapter Funding Expenses | $85,131 | 35% | $46,243 | $59,726 | $62,834 | ||||||||||||||||||||
42 | Chapter Allocated Funds (40/60 membership split) | $85,131 | 35% | $46,243 | $59,726 | $62,834 | $1,028.17 | |||||||||||||||||||
43 | Percent Allocated to chapter (not all members/ corp supporters pick local chapters) | 25% | 28% | 24% | 24% | 12% | ||||||||||||||||||||
44 | COMMITTEE EXPENSES | Previous Amounts | $130,500 | 64% | $63,159 | $27,035 | $79,417 | |||||||||||||||||||
45 | Projects | 62510 | $40,000 | 198% | $26,079 | $15,809 | $13,441 | $3,173.00 | $2,667.00 | $2,667.00 | $2,667.00 | $2,667.00 | $2,667.00 | $17,667.00 | $2,667.00 | $17,667.00 | $2,667.00 | $2,667.00 | $2,667.00 | |||||||
46 | Conferences | 101000 | $40,000 | 65% | $26,782 | $4,347 | $24,225 | $1,835.00 | $835.00 | $10,833.00 | $10,143.00 | $3,888.00 | $7,888.00 | $21,138.00 | $6,388.00 | $26,638.00 | $2,388.00 | $4,638.00 | $4,388.00 | |||||||
47 | Industry | 44020 | $8,000 | -20% | $9,948 | $335.00 | $335.00 | $10,335.00 | $335.00 | $335.00 | $335.00 | $10,335.00 | $335.00 | $10,335.00 | $335.00 | $10,335.00 | $335.00 | |||||||||
48 | Education | 40000 | $10,000 | #DIV/0! | $0.00 | $0.00 | $5,000.00 | $0.00 | $0.00 | $0.00 | $15,000.00 | $0.00 | $10,000.00 | $0.00 | $10,000.00 | $0.00 | ||||||||||
49 | Membership | 24000 | $5,000 | 26% | $7,322 | $2,845 | $3,983 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | |||||||
50 | Chapter | 26000 | $25,000 | -2% | $3,434 | $25,385 | $1,660.00 | $1,660.00 | $7,660.00 | $1,660.00 | $1,670.00 | $1,670.00 | $7,670.00 | $1,670.00 | $7,670.00 | $1,670.00 | $7,670.00 | $1,670.00 | ||||||||
51 | Connections | 21200 | $2,500 | 3% | $2,976 | $600 | $2,435 | $1,500.00 | $1,400.00 | $2,400.00 | $1,500.00 | $1,500.00 | $2,400.00 | $1,400.00 | $1,400.00 | $2,400.00 | $1,500.00 | $1,400.00 | $2,400.00 | |||||||
52 | ||||||||||||||||||||||||||
53 | ||||||||||||||||||||||||||
54 | TOTAL EXPENSES | $613,491 | 25% | $337,241 | $429,616 | $489,849 | $28,662 | $27,056 | $65,154 | $40,937 | $35,348 | $42,941 | $109,998 | $34,619 | $110,969 | $30,719 | $64,869 | $33,719 | ||||||||
55 | ||||||||||||||||||||||||||
56 | NET | -$22,217 | -67% | -$100,212 | -$1,717 | -$67,304 | ||||||||||||||||||||
57 | ||||||||||||||||||||||||||
58 | Net Percentage of Total Revenue | 4% | ||||||||||||||||||||||||
59 | ||||||||||||||||||||||||||
60 | ||||||||||||||||||||||||||
61 | ||||||||||||||||||||||||||
62 | ||||||||||||||||||||||||||
63 | ||||||||||||||||||||||||||
64 | ||||||||||||||||||||||||||
65 | ||||||||||||||||||||||||||
66 | ||||||||||||||||||||||||||
67 | ||||||||||||||||||||||||||
68 | ||||||||||||||||||||||||||
69 | ||||||||||||||||||||||||||
70 | ||||||||||||||||||||||||||
71 | ||||||||||||||||||||||||||
72 | ||||||||||||||||||||||||||
73 | ||||||||||||||||||||||||||
74 | ||||||||||||||||||||||||||
75 | ||||||||||||||||||||||||||
76 | ||||||||||||||||||||||||||
77 | ||||||||||||||||||||||||||
78 | ||||||||||||||||||||||||||
79 | ||||||||||||||||||||||||||
80 | ||||||||||||||||||||||||||
81 | ||||||||||||||||||||||||||
82 | ||||||||||||||||||||||||||
83 | ||||||||||||||||||||||||||
84 | ||||||||||||||||||||||||||
85 | ||||||||||||||||||||||||||
86 | ||||||||||||||||||||||||||
87 | ||||||||||||||||||||||||||
88 | ||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 |