| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | 2012 budget | January - September 2012 Budget | January - September 2012 Actual | Percent Over/Under Budget | ||
2 | INCOME | |||||
3 | CORPORATE MEMBERSHIP | $195,000.00 | $146,250.00 | $169,658.00 | 16% | |
4 | INDIVIDUAL MEMBERSHIP | $60,000.00 | $45,000.00 | $49,988.00 | 11% | |
5 | LOCAL CHAPTER MEMBERSHIP | $2,000.00 | $1,500.00 | $1,320.00 | -12% | |
6 | DONATIONS | $1,581.00 | $1,185.75 | $1,116.00 | -6% | |
7 | TRAINING | $50,000.00 | $37,500.00 | $2,800.00 | -93% | |
8 | PROJECT REBOOT | $6,613.00 | ||||
9 | CONFERENCE PROFITS | |||||
10 | USA | $100,000.00 | $75,000.00 | $298,541.00 | 298% | |
11 | EU | $75,000.00 | $56,250.00 | $25,538.00 | -55% | |
12 | ASIAPAC | $25,000.00 | $18,750.00 | -$22,431.00 | -220% | |
13 | LATIN AMERICA | $25,000.00 | $18,750.00 | $5,036.00 | -73% | |
14 | REGIONAL EVENTS | $69,000.00 | $51,750.00 | $31,451.00 | -39% | |
15 | LOCAL EVENTS | $2,000.00 | $1,500.00 | $3,492.00 | 133% | |
16 | Conferences Total Budget Estimate | $175,000.00 | $131,250.00 | $341,627.00 | 160% | |
17 | ADVERTISING REVENUE | $24,000.00 | $18,000.00 | $14,959.00 | -17% | |
18 | INTEREST INCOME | $168.00 | $126.00 | $210.00 | 67% | |
19 | ||||||
20 | TOTAL INCOME: | $591,275.00 | $443,456.25 | $588,291.00 | 33% | |
21 | ||||||
22 | ||||||
23 | EXPENSES | |||||
24 | PAYROLL | $194,000.00 | $145,500.00 | $132,114.00 | -9% | |
25 | BUSINESS OWNERS INS | $2,516.00 | $1,887.00 | $1,967.00 | 4% | |
26 | LIABILITY INS | $3,300.00 | $2,475.00 | $4,015.00 | 62% | |
27 | WORKERS COMPENSATION INS | $437.00 | $327.75 | $638.00 | 95% | |
28 | TRAVEL ACCOMMODATIONS - STAFF | $20,000.00 | $15,000.00 | $19,606.00 | 31% | |
29 | TRAVEL ACCOMMODATIONS - BOARD | $20,000.00 | $15,000.00 | $13,960.00 | -7% | |
30 | TRAVEL ACCOMMODATIONS - FEES | $0.00 | $1,955.00 | |||
31 | BANK SERVICE CHARGES | $3,307.00 | $2,480.25 | $2,803.00 | 13% | |
32 | OFFICE RENT | $5,400.00 | $4,050.00 | $3,150.00 | -22% | |
33 | REGISTRATION | $20,400.00 | $15,300.00 | $25,539.00 | 67% | |
34 | MEETING/CONFERENCING/TELEPHONE | $4,200.00 | $3,150.00 | $6,839.00 | 117% | |
35 | T.R. KLEIN (AUDIT) | $4,500.00 | $3,375.00 | $0.00 | ||
36 | EISNER (INT'L ACCOUNTING) | $5,000.00 | $3,750.00 | $0.00 | ||
37 | SHIPPING | $14,400.00 | $10,800.00 | $2,128.00 | -80% | |
38 | OFFICE SUPPLIES | $400.00 | $300.00 | $1,360.00 | 353% | |
39 | OTHER PROFESSIONAL SERVICES | $0.00 | $2,740.00 | |||
40 | SUMMIT (2013 Planning) | $85,000.00 | $63,750.00 | $0.00 | ||
41 | INTERNET EXPENSES | $2,953.00 | ||||
42 | MARKETING/COMMUNICATIONS | $13,304.00 | ||||
43 | EXTRA MERCHANDISE | $312.00 | ||||
44 | GIFTS | $404.00 | ||||
45 | PROJECT REBOOT | $30,000.00 | $22,500.00 | $0.00 | ||
46 | PROJECT SUPPORT | $1,000.00 | ||||
47 | COMMITTEE EXPENSES | |||||
48 | Projects | $25,000.00 | $18,750.00 | $341.00 | -98% | |
49 | Conferences | $40,000.00 | $30,000.00 | $17,107.00 | -43% | |
50 | Industry | $8,000.00 | $6,000.00 | $0.00 | ||
51 | Education | $10,000.00 | $7,500.00 | $2,625.00 | -65% | |
52 | Membership | $5,000.00 | $3,750.00 | $444.00 | -88% | |
53 | Chapter | $25,000.00 | $18,750.00 | $17,539.00 | -6% | |
54 | Connections | $2,500.00 | $1,875.00 | $1,000.00 | -47% | |
55 | ||||||
56 | TOTAL EXPENSES | $613,491.00 | $460,118.25 | $275,943.00 | -40% | |
57 | ||||||
58 | NET | -$22,217.00 | -$16,662.75 | $312,348.00 |