| 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 | 2020 Budget | 2021 Budget | 2021 Actual | 2022 Budget | 2022 Actual | 2023 Budget | Actual | Budget to Actual | 2024 Budget | ||||||||||||||||
2 | Income | ||||||||||||||||||||||||
3 | |||||||||||||||||||||||||
4 | Total District/Board Meeting Sponsors | $8,000.00 | $0.00 | $1,500.00 | $2,000.00 | $2,000.00 | 0.00% | $2,000.00 | |||||||||||||||||
5 | |||||||||||||||||||||||||
6 | Investment Income | $13,000.00 | $10,000.00 | $59,504.00 | $10,000.00 | $49,267.00 | $30,000.00 | $21,416.00 | 71.39% | unknown until Paul | |||||||||||||||
7 | |||||||||||||||||||||||||
8 | Seminar Income | ||||||||||||||||||||||||
9 | 43021 · Sponsored Seminars | $3,379.00 | $3,000.00 | ||||||||||||||||||||||
10 | 43062 · Online Co-Sponsor Seminar | $2,026.98 | $2,000.00 | ||||||||||||||||||||||
11 | Xray Certification | $60,054.13 | $60,000.00 | (19500+22,000+15,750) - I changed it to match 2023 | |||||||||||||||||||||
12 | Xray Recert | $19,527.00 | $10,000.00 | unsure due to first year with consecutive Xray out of two | |||||||||||||||||||||
13 | CA Certification | $100,385.00 | $100,000.00 | (32,550+14,725+19,255+28,940) | |||||||||||||||||||||
14 | CCA Recert | $24,219.17 | $16,000.00 | ||||||||||||||||||||||
15 | DC Educations | ||||||||||||||||||||||||
16 | Total Seminar Income | $188,000.00 | $154,000.00 | $202,267.00 | $170,000.00 | $192,649.00 | $222,000.00 | $209,591.28 | 94.41% | $191,500.00 | |||||||||||||||
17 | |||||||||||||||||||||||||
18 | Membership Dues | $385,000.00 | $375,000.00 | $376,499.00 | $375,000.00 | $368,186.00 | $375,000.00 | $365,515.13 | 97.47% | $375,000.00 | |||||||||||||||
19 | |||||||||||||||||||||||||
20 | Advertising/Newletter Income | $17,000.00 | $27,000.00 | $30,254.00 | $17,000.00 | $31,415.00 | $30,000.00 | $8,480.00 | 107.18% | $8,750.00 | |||||||||||||||
21 | Partners | $23,675.00 | $24,000.00 | ||||||||||||||||||||||
22 | Affiliate Income | $10,000.00 | $10,000.00 | $9,097.00 | $8,000.00 | $7,788.00 | $7,000.00 | $7,009.83 | 100.14% | $7,000.00 | |||||||||||||||
23 | Spring Conference | $85,000.00 | $75,000.00 | $71,340.00 | $48,000.00 | $74,230.00 | $85,000.00 | $98,050.80 | 115.35% | $91,000.00 | |||||||||||||||
24 | Fall Convention | $85,000.00 | $75,000.00 | $74,515.00 | $83,000.00 | $113,224.00 | $70,000.00 | $69,326.00 | 99.04% | $91,000.00 | |||||||||||||||
25 | Annual Education Event | $3,000.00 | $2,685.00 | 89.50% | $0.00 | ||||||||||||||||||||
26 | |||||||||||||||||||||||||
27 | Health Insurance | $7,000.00 | $0.00 | $690.00 | $420.00 | ||||||||||||||||||||
28 | PPP Loan | $50,662.00 | |||||||||||||||||||||||
29 | |||||||||||||||||||||||||
30 | Total Income | $798,000.00 | $726,000.00 | $876,328.00 | $713,000.00 | $836,759.00 | $824,000.00 | $806,169.04 | 97.84% | $790,250.00 | |||||||||||||||
31 | |||||||||||||||||||||||||
32 | |||||||||||||||||||||||||
33 | |||||||||||||||||||||||||
34 | |||||||||||||||||||||||||
35 | Expense | ||||||||||||||||||||||||
36 | Payroll & Taxes | $280,000.00 | $290,000.00 | $297,407.00 | $306,000.00 | $304,112.00 | $339,000.00 | $327,541.58 | 96.62% | $350,000.00 | |||||||||||||||
37 | Staff Development | $5,000.00 | $5,000.00 | $1,317.00 | $5,000.00 | $3,799.00 | $2,000.00 | $4,379.84 | 218.99% | $4,000.00 | |||||||||||||||
38 | Insurance/Retirement | $30,000.00 | $30,000.00 | $30,290.00 | $31,000.00 | $30,897.00 | $32,000.00 | $34,400.20 | 107.50% | $35,500.00 | |||||||||||||||
39 | Seminar Expenses | ||||||||||||||||||||||||
40 | Xray Certification | $18,568.18 | $10,000.00 | 7500 less due to digital creation | |||||||||||||||||||||
41 | Xray Recert | $0.00 | $0.00 | ||||||||||||||||||||||
42 | CA Certification | $7,990.27 | $8,500.00 | ||||||||||||||||||||||
43 | Dry Needling | $59.50 | $400.00 | ||||||||||||||||||||||
44 | CCA Recert | $0.00 | $0.00 | ||||||||||||||||||||||
45 | Tax for Digital Programs | $3,059.78 | |||||||||||||||||||||||
46 | Total Seminar Expenses | $33,000.00 | $30,000.00 | $31,779.00 | $30,000.00 | $31,316.00 | $30,000.00 | $29,677.73 | 98.93% | $18,900.00 | |||||||||||||||
47 | Vehicle and Lease Expense | ||||||||||||||||||||||||
48 | 50017 · Vehicle Expenses | $2,671.00 | included $1345 insurance. Need to get with Paul | ||||||||||||||||||||||
49 | 50042 · Vehicle Lease Payments | $5,748.60 | |||||||||||||||||||||||
50 | Total Vehicle and Lease Expense | $10,000.00 | $8,000.00 | $6,121.00 | $6,500.00 | $6,637.00 | $7,000.00 | $8,419.60 | 120.28% | $7,000.00 | Will be doing a new lease so this is estimate | ||||||||||||||
51 | |||||||||||||||||||||||||
52 | 50008 · Insurance - Prop. & WC | $4,000.00 | $4,000.00 | $2,883.00 | $3,000.00 | $2,952.00 | $3,000.00 | $3,816.00 | 127.20% | $4,000.00 | moved car 1345 here but need to fix in quickbooks | ||||||||||||||
53 | 50009 · Insurance - D&O | $2,000.00 | $2,000.00 | $2,684.00 | $2,000.00 | $2,762.00 | $3,000.00 | $2,169.00 | 72.30% | $3,000.00 | |||||||||||||||
54 | Building Expenses & Maintenance | $10,000.00 | $10,000.00 | $10,519.00 | $10,000.00 | $8,243.00 | $10,000.00 | $10,008.32 | 100.08% | $10,000.00 | this will be higher for 2024 so will adjust official budget. Roof had to be replaced. | ||||||||||||||
55 | 50012 · Copier Lease | $9,000.00 | $9,000.00 | $9,083.00 | $9,000.00 | $9,434.00 | $9,000.00 | $7,431.24 | 82.57% | $7,500.00 | lower copier cost due to renegotiated contract | ||||||||||||||
56 | 50013 · Postage | $6,000.00 | $4,000.00 | $1,571.00 | $1,500.00 | $1,502.00 | $1,000.00 | $1,661.25 | 166.13% | $1,000.00 | |||||||||||||||
57 | 50014 · Communications | $10,000.00 | $8,000.00 | $9,308.00 | $9,000.00 | $8,214.00 | $9,000.00 | $8,390.00 | 93.22% | $9,000.00 | |||||||||||||||
58 | 50015 · Legal Fees | $15,000.00 | $10,000.00 | $12,882.00 | $5,000.00 | $1,138.00 | $10,000.00 | $5,744.50 | 57.45% | $4,600.00 | |||||||||||||||
59 | 50016 · Lobbyist/Legislative | $55,000.00 | $55,000.00 | $54,752.00 | $55,000.00 | $54,506.00 | $55,000.00 | $54,753.00 | 99.55% | $63,000.00 | |||||||||||||||
60 | 50019 · District Meetings | $5,000.00 | $3,000.00 | $1,005.00 | $3,000.00 | $3,384.00 | $3,000.00 | $2,887.03 | 96.23% | $3,000.00 | |||||||||||||||
61 | 50020 · Accounting | $13,000.00 | $14,000.00 | $14,000.00 | $15,000.00 | $15,000.00 | $16,000.00 | $16,000.00 | 100.00% | $16,000.00 | |||||||||||||||
62 | 50023 · Membership Development | $3,000.00 | $2,000.00 | $7,100.00 | $2,000.00 | $973.00 | $35,000.00 | $29,738.65 | 84.97% | $28,000.00 | student & nonmember marketing campaign | May be $31844.47 depending on 2024 expense | |||||||||||||
63 | 50025 · General Office Expense | $7,000.00 | $8,000.00 | $9,702.00 | $6,000.00 | $6,731.00 | $7,000.00 | $4,280.78 | 61.15% | $6,000.00 | removed payroll expense fee & added to payroll | ||||||||||||||
64 | 50028 · Credit Card Fees & Bank Charges | $27,000.00 | $27,000.00 | $25,425.00 | $26,000.00 | $24,834.00 | $25,000.00 | $23,424.63 | 93.70% | $25,000.00 | |||||||||||||||
65 | 50029 · Technology Expenses | $18,000.00 | $22,000.00 | $16,518.00 | $32,000.00 | $33,320.00 | $22,000.00 | $24,865.86 | 113.03% | $22,000.00 | higher in 2023 due to Sasha new computer and Heather laptop | ||||||||||||||
66 | 50034 · Dues & Subscriptions | $2,000.00 | $2,000.00 | $2,220.00 | $2,000.00 | $2,160.00 | $2,000.00 | $2,450.00 | 122.50% | $2,500.00 | |||||||||||||||
67 | 50035 · Taxes & Licensures | $5,000.00 | $5,000.00 | $3,769.00 | $4,000.00 | $4,656.00 | $5,000.00 | $6,641.17 | 132.82% | $5,000.00 | Includes $1108.10 in tax penalty. Paul planning to request waiver | ||||||||||||||
68 | 50039 · Postage Machine Lease | $3,000.00 | $3,000.00 | $1,820.00 | $2,000.00 | $1,394.00 | $2,000.00 | $2,160.95 | 108.05% | $2,000.00 | |||||||||||||||
69 | 50048 · Depreciation | $12,000.00 | $10,000.00 | $11,662.00 | $10,000.00 | $10,764.00 | $10,000.00 | 0.00% | unknown until Paul | ||||||||||||||||
70 | 55001 · Public Relations | $65,000.00 | $60,000.00 | $60,978.00 | $40,000.00 | $29,524.00 | $20,000.00 | $15,112.95 | 75.56% | $9,500.00 | can flex down to 5000 | ||||||||||||||
71 | 55020 · Board & Officer Meetings | $25,000.00 | $20,000.00 | $20,427.00 | $19,000.00 | $27,610.00 | $25,000.00 | $16,611.15 | 66.44% | $16,500.00 | |||||||||||||||
72 | 55021 · NCLC Meeting | $5,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1,000.00 | |||||||||||||||||
73 | 55022 · COCSA Meeting | $7,000.00 | $16,000.00 | $7,114.00 | $7,000.00 | $5,668.00 | $12,000.00 | $5,254.12 | 43.78% | $5,000.00 | Need to add Debra Bell reimbrusment for 2023 | ||||||||||||||
74 | Fall Convention | $55,000.00 | $60,000.00 | $27,756.00 | $27,000.00 | $59,923.00 | $7,000.00 | $150.00 | 2.14% | $50,000.00 | |||||||||||||||
75 | Spring Conference | $65,000.00 | $8,000.00 | $2,435.00 | $45,000.00 | $66,844.00 | $70,000.00 | $89,032.12 | 127.19% | $70,000.00 | |||||||||||||||
76 | Charitable Donations | $4,000.00 | $35,190.00 | $7,161.00 | $7,000.00 | $3,000.00 | 42.86% | $3,750.00 | need to add nieland expenses to 2023 | ||||||||||||||||
77 | Annual Education Event | $6,000.00 | $0.00 | $20,000.00 | $15,579.69 | 77.90% | $0.00 | ||||||||||||||||||
78 | Legislative | $2,000.00 | $1,000.00 | $303.00 | $2,000.00 | $956.37 | 47.82% | $2,000.00 | |||||||||||||||||
79 | Social Media Investment & F4CP | $26,000.00 | $29,344.00 | $24,000.00 | $18,514.68 | 77.14% | $5,500.00 | Doesn't include December payment | Christie is not included for 2024but is $15,000 | ||||||||||||||||
80 | |||||||||||||||||||||||||
81 | TOTAL EXPENSES | 798,000.00 | 726,000.00 | 743,717.00 | 713,000.00 | 795,105.00 | 824,000.00 | $775,052.41 | 94.06% | $790,250.00 | |||||||||||||||
82 | |||||||||||||||||||||||||
83 | |||||||||||||||||||||||||
84 | Profit | 132,611.00 | 132,611.00 | $31,116.63 | $0.00 | ||||||||||||||||||||
85 | |||||||||||||||||||||||||
86 | |||||||||||||||||||||||||
87 | |||||||||||||||||||||||||
88 | |||||||||||||||||||||||||
89 | |||||||||||||||||||||||||
90 | |||||||||||||||||||||||||
91 | |||||||||||||||||||||||||
92 | |||||||||||||||||||||||||
93 | |||||||||||||||||||||||||
94 | |||||||||||||||||||||||||
95 | |||||||||||||||||||||||||
96 | |||||||||||||||||||||||||
97 | |||||||||||||||||||||||||
98 | |||||||||||||||||||||||||
99 | |||||||||||||||||||||||||
100 |