| A | R | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|
1 | VISIONSERVE ALLIANCE | ||||||||
2 | Budget vs. Actuals: FY2023 - FY23 P&L | ||||||||
3 | January - September, 2023 | ||||||||
4 | |||||||||
6 | Sept 2023 Actual | YTD Actual | YTD Budget | Annual Budget Revised May 2023 | Annual Projected | Notes | |||
7 | Revenue | ||||||||
8 | AVLNC Revenue | 15,000.00 | 0.00 | 1,000.00 | 15,000.00 | ||||
9 | Big Data Project Revenue | 150,000.00 | 150,000.03 | 430,000.00 | 430,000.00 | $175K invoiced in Oct; will sell/invoice another $105K+ by FYE | |||
10 | Conference Fee Income | 58,220.00 | 45,000.00 | 60,000.00 | 58,220.00 | ||||
11 | Conference Sponsorships | 51,500.00 | 45,000.00 | 60,000.00 | 51,500.00 | ||||
12 | Consulting Income | 91,438.02 | 74,999.97 | 100,000.00 | 100,000.00 | ||||
13 | Donations | 1,608.03 | 6,495.81 | 18,749.97 | 25,000.00 | 10,000.00 | running yr end campaign; most Bod gifts received at Year End | ||
14 | Grant Income | 0.00 | 74,999.97 | 100,000.00 | 5,000.00 | *$200K in grants dedicated to WAA BDP in BDP line item | |||
15 | Interest Income | 0.00 | 0.98 | 0.00 | - | - | |||
16 | Medicare Exploration Project (MEP) Revenue | 23,000.00 | 42,500.00 | 0.00 | 50,000.00 | 45,000.00 | |||
17 | Membership Dues | 4,502.74 | 287,888.70 | 225,000.00 | 300,000.00 | 290,000.00 | |||
18 | Net Investment Income | 618.48 | 3,150.64 | 0.00 | 3,150.00 | ||||
19 | Survey Income | 300.00 | 1,200.00 | 0.00 | 1,200.00 | ||||
20 | Total Revenue | $ 30,029.25 | $ 707,394.15 | $ 633,749.94 | 1,126,000.00 | 1,009,070.00 | |||
21 | Gross Profit | $ 30,029.25 | $ 707,394.15 | $ 633,749.94 | |||||
22 | Expenditures | ||||||||
23 | Advertising Expense | 0.00 | 1,874.97 | - | - | ||||
24 | AVLNC Programming | 20,152.07 | 9,375.03 | 20,152.07 | 25,000.00 | ||||
25 | Bank Fees | 693.29 | 7,201.50 | 11,250.00 | 10,000.00 | 12,000.00 | |||
26 | Benefits/Retirement | 1,026.42 | 9,308.03 | 11,250.00 | 13,000.00 | 13,000.00 | |||
27 | Big Data Project Expenses | 1,470.00 | 78,750.00 | 174,000.00 | 159,000.00 | WAA$159K | |||
28 | Board of Directors | 242.79 | 3,750.03 | 2,500.00 | 2,500.00 | ||||
29 | Collaborative Initiatives | 1,000.00 | 0.00 | 1,000.00 | |||||
30 | Conferences | 96,477.50 | 67,500.00 | 96,477.50 | 96,500.00 | ||||
31 | Consulting Expense | 21,806.87 | 11,250.00 | 25,000.00 | 25,000.00 | ||||
32 | Corporate Expenses | 644.33 | 766.74 | 375.03 | 1,000.00 | 1,000.00 | |||
33 | Depreciation Expense | 1,813.19 | 16,318.78 | 13,500.00 | 18,000.00 | 18,000.00 | |||
34 | Employee Health & Life Insurance | 25.54 | 430.32 | 1,125.00 | 600.00 | 600.00 | |||
35 | Insurance (D&O) | 247.75 | 2,195.25 | 1,874.97 | 2,500.00 | 2,500.00 | |||
36 | IT Subscriptions | 561.93 | 13,433.22 | 7,499.97 | 15,000.00 | 15,000.00 | |||
37 | Marketing, Branding, Website Refresh | 977.94 | 14,325.03 | 977.94 | 5,000.00 | ||||
38 | Member Engagement (CREPE/NPC Mtg) | 132.89 | 170.89 | 7,499.97 | 5,000.00 | 5,000.00 | PAB, APH, Policy Reset In Person Mtg@NIB; NIB Conference | ||
39 | Office Supplies | 84.55 | 704.32 | 37.53 | 1,000.00 | 1,000.00 | |||
40 | Professional Fees | 10,712.58 | 111,303.42 | 131,699.97 | 205,000.00 | 240,000.00 | inc Powers Law $40K; Lit Review w/April? | ||
41 | Salaries | 26,757.82 | 242,428.81 | 228,750.03 | 325,000.00 | 325,000.00 | |||
42 | Staff Professional Development | 0.00 | 1,874.97 | - | 500.00 | ||||
43 | Subscriptions/Memberships | 3,249.30 | 3,750.03 | 5,000.00 | 7,500.00 | ||||
44 | Telephone/Internet | 76.00 | 684.00 | 749.97 | 1,000.00 | 1,000.00 | |||
45 | Travel, Staff Training and Conferences | 1,105.16 | 13,564.91 | 15,000.03 | 20,000.00 | 25,000.00 | |||
46 | Website/Tech Support by LW | 89.88 | 362.73 | 5,625.00 | 1,000.00 | 6,000.00 | |||
47 | Total Expenditures | $ 43,971.33 | $ 564,249.39 | $ 628,687.53 | 942,207.51 | 987,100.00 | |||
48 | Net Operating Revenue | $ (13,942.08) | $ 143,144.76 | $ 5,062.41 | 183,792.49 | 21,970.00 | |||
49 | Other Revenue | ||||||||
50 | Unrealized Gains (Losses) | (10,413.90) | 8,418.10 | 0.00 | |||||
51 | Total Other Revenue | $ (10,413.90) | $ 8,418.10 | $ - | |||||
52 | Net Other Revenue | $ (10,413.90) | $ 8,418.10 | $ - | |||||
53 | Net Revenue | $ (24,355.98) | $ 151,562.86 | $ 5,062.41 | |||||
54 | |||||||||
55 | |||||||||
56 | |||||||||
57 | Monday, Oct 09, 2023 07:49:03 AM GMT-7 - Accrual Basis | ||||||||
58 | |||||||||
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 | |||||||||
101 | |||||||||