| A | B | C | D | E | F | G | H | I | CZ | DA | DB | DC | DD | DE | DF | DG | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | TOTAL | |||||||||||||||||
2 | Jul 23 | 07/01/23 - 07/31/23 | Budget | $ Over Budget | % of Budget | |||||||||||||
3 | Ordinary Income/Expense | |||||||||||||||||
4 | Income | |||||||||||||||||
5 | 01 - MSD (BID Revenue) | |||||||||||||||||
6 | MSD | 0.00 | 0.00 | 1,190,549.00 | -1,190,549.00 | 0.0% | ||||||||||||
7 | Total 01 - MSD (BID Revenue) | 0.00 | 0.00 | 1,190,549.00 | -1,190,549.00 | 0.0% | ||||||||||||
8 | 02 - Public Support | |||||||||||||||||
9 | City Of Raleigh | 3,776.91 | 3,776.91 | 125,000.00 | -121,223.09 | 3.02% | ||||||||||||
10 | Friends of HSCSC Donations | 375.00 | 375.00 | 10,000.00 | -9,625.00 | 3.75% | ||||||||||||
11 | NCSU | 0.00 | 0.00 | 100,000.00 | -100,000.00 | 0.0% | ||||||||||||
12 | Total 02 - Public Support | 4,151.91 | 4,151.91 | 235,000.00 | -230,848.09 | 1.77% | ||||||||||||
13 | 03 - Program Income | |||||||||||||||||
14 | I - BRCA - Sub/Employee Reimb | 0.00 | 0.00 | 18,000.00 | -18,000.00 | 0.0% | ||||||||||||
15 | I - BRCA Mgmt Fees | 19,500.00 | 19,500.00 | 78,000.00 | -58,500.00 | 25.0% | ||||||||||||
16 | I - Program Income - Other | 0.00 | 0.00 | 6,000.00 | -6,000.00 | 0.0% | ||||||||||||
17 | Total 03 - Program Income | 19,500.00 | 19,500.00 | 102,000.00 | -82,500.00 | 19.12% | ||||||||||||
18 | 04 - Interest Income | 6.18 | 6.18 | 100.00 | -93.82 | 6.18% | ||||||||||||
19 | Total Income | 23,658.09 | 23,658.09 | 1,527,649.00 | -1,503,990.91 | 1.55% | ||||||||||||
20 | ||||||||||||||||||
21 | Prior Years Earnings | 100,000.00 | ||||||||||||||||
22 | Total Available Funds | 1,627,649.00 | ||||||||||||||||
23 | ||||||||||||||||||
24 | Gross Profit | 23,658.09 | 23,658.09 | 1,527,649.00 | -1,503,990.91 | 1.55% | ||||||||||||
25 | Expense | |||||||||||||||||
26 | Business & Economic Development | |||||||||||||||||
27 | General - Bus & Eco Dvlp | |||||||||||||||||
28 | Art & Sidewalk Furniture Grants | 0.00 | 0.00 | 10,000.00 | -10,000.00 | 0.0% | ||||||||||||
29 | General Bus & Eco Dvlp - Other | 0.00 | 0.00 | 50,000.00 | -50,000.00 | 0.0% | ||||||||||||
30 | Student Survey | 0.00 | 0.00 | 45,000.00 | -45,000.00 | 0.0% | ||||||||||||
31 | Total General - Bus & Eco Dvlp | 0.00 | 0.00 | 105,000.00 | -105,000.00 | 0.0% | ||||||||||||
32 | Parking/Pedestrian Programs | 0.00 | 0.00 | 10,000.00 | -10,000.00 | 0.0% | ||||||||||||
33 | Total Business & Economic Development | 0.00 | 0.00 | 115,000.00 | -115,000.00 | 0.0% | ||||||||||||
34 | Clean & Safe Initiative | |||||||||||||||||
35 | Clean & Safe Initiative-Other | 31,332.26 | 31,332.26 | 375,987.11 | -344,654.85 | 8.33% | ||||||||||||
36 | Landscaping/Beautification | 1,557.36 | 1,557.36 | 70,000.00 | -68,442.64 | 2.23% | ||||||||||||
37 | Maint/Misc | 111.71 | 111.71 | 18,000.00 | -17,888.29 | 0.62% | ||||||||||||
38 | Trash Cans | 0.00 | 0.00 | 10,000.00 | -10,000.00 | 0.0% | ||||||||||||
39 | Truck | 197.56 | 197.56 | 3,000.00 | -2,802.44 | 6.59% | ||||||||||||
40 | Total Clean & Safe Initiative | 33,198.89 | 33,198.89 | 476,987.11 | -443,788.22 | 6.96% | ||||||||||||
41 | Conflict Resolution | 0.00 | 0.00 | 20,000.00 | -20,000.00 | 0.0% | ||||||||||||
42 | Contingency Expenses | 0.00 | 0.00 | 16,000.00 | -16,000.00 | 0.0% | ||||||||||||
43 | Events | |||||||||||||||||
44 | General Events- | |||||||||||||||||
45 | General Events - Other | 0.00 | 0.00 | 100,000.00 | -100,000.00 | 0.0% | ||||||||||||
46 | ZZ - Food Walk | |||||||||||||||||
47 | Food Walk - 1 July-Dec | 7,568.58 | 7,568.58 | |||||||||||||||
48 | Total ZZ - Food Walk | 7,568.58 | 7,568.58 | |||||||||||||||
49 | Total General Events- | 7,568.58 | 7,568.58 | 100,000.00 | -92,431.42 | 7.57% | ||||||||||||
50 | Packapalooza | 0.00 | 0.00 | 55,000.00 | -55,000.00 | 0.0% | ||||||||||||
51 | Total Events | 7,568.58 | 7,568.58 | 155,000.00 | -147,431.42 | 4.88% | ||||||||||||
52 | Marketing | |||||||||||||||||
53 | Banners | |||||||||||||||||
54 | Banners - Other | 0.00 | 0.00 | 23,000.00 | -23,000.00 | 0.0% | ||||||||||||
55 | Maintenance/City Fees | 1,630.20 | 1,630.20 | 3,000.00 | -1,369.80 | 54.34% | ||||||||||||
56 | Total Banners | 1,630.20 | 1,630.20 | 26,000.00 | -24,369.80 | 6.27% | ||||||||||||
57 | Gift Card Program | 0.00 | 0.00 | 3,000.00 | -3,000.00 | 0.0% | ||||||||||||
58 | Marketing | 1,000.00 | 1,000.00 | 20,000.00 | -19,000.00 | 5.0% | ||||||||||||
59 | MWOB Promotion | |||||||||||||||||
60 | MWOB Promo Other | 0.00 | 0.00 | 20,000.00 | -20,000.00 | 0.0% | ||||||||||||
61 | Total MWOB Promotion | 0.00 | 0.00 | 20,000.00 | -20,000.00 | 0.0% | ||||||||||||
62 | Street Activation | 0.00 | 0.00 | 10,000.00 | -10,000.00 | 0.0% | ||||||||||||
63 | Website Redesign | 0.00 | 0.00 | 2,500.00 | -2,500.00 | 0.0% | ||||||||||||
64 | Website/Newsletter | 9.00 | 9.00 | 8,000.00 | -7,991.00 | 0.11% | ||||||||||||
65 | Total Marketing | 2,639.20 | 2,639.20 | 89,500.00 | -86,860.80 | 2.95% | ||||||||||||
66 | Misc. Expenses | |||||||||||||||||
67 | Board Retreat & Other Events | 0.00 | 0.00 | 6,000.00 | -6,000.00 | 0.0% | ||||||||||||
68 | Food & Beverage, Misc | 326.87 | 326.87 | 5,000.00 | -4,673.13 | 6.54% | ||||||||||||
69 | Interns | 0.00 | 0.00 | 3,000.00 | -3,000.00 | 0.0% | ||||||||||||
70 | Meetings | |||||||||||||||||
71 | Meetings - Other | 0.00 | 0.00 | 20,000.00 | -20,000.00 | 0.0% | ||||||||||||
72 | Partner Organization Events | 0.00 | 0.00 | 4,000.00 | -4,000.00 | 0.0% | ||||||||||||
73 | Total Meetings | 0.00 | 0.00 | 24,000.00 | -24,000.00 | 0.0% | ||||||||||||
74 | Professional Development | 0.00 | 0.00 | 7,000.00 | -7,000.00 | 0.0% | ||||||||||||
75 | Total Misc. Expenses | 326.87 | 326.87 | 45,000.00 | -44,673.13 | 0.73% | ||||||||||||
76 | Operations | |||||||||||||||||
77 | Bank Charges | 29.75 | 29.75 | 400.00 | -370.25 | 7.44% | ||||||||||||
78 | Equipment & Maintenance | 0.00 | 0.00 | 5,000.00 | -5,000.00 | 0.0% | ||||||||||||
79 | Insurance | 4,299.47 | 4,299.47 | 5,000.00 | -700.53 | 85.99% | ||||||||||||
80 | New Office Rent | 0.00 | 0.00 | 43,000.00 | -43,000.00 | 0.0% | ||||||||||||
81 | Ofc Move & Upfit | 0.00 | 0.00 | 20,000.00 | -20,000.00 | 0.0% | ||||||||||||
82 | Office Lease | |||||||||||||||||
83 | Office - Misc | 400.00 | 400.00 | 0.00 | 400.00 | 100.0% | ||||||||||||
84 | Office Lease | 4,050.00 | 4,050.00 | 36,000.00 | -31,950.00 | 11.25% | ||||||||||||
85 | Office Parking | 150.00 | 150.00 | 0.00 | 150.00 | 100.0% | ||||||||||||
86 | Office Trash | 125.00 | 125.00 | 0.00 | 125.00 | 100.0% | ||||||||||||
87 | Office Utilities - Electricity | 324.63 | 324.63 | 0.00 | 324.63 | 100.0% | ||||||||||||
88 | Office Utilities - Gas | 18.73 | 18.73 | 0.00 | 18.73 | 100.0% | ||||||||||||
89 | Water | 36.75 | 36.75 | 0.00 | 36.75 | 100.0% | ||||||||||||
90 | Total Office Lease | 5,105.11 | 5,105.11 | 36,000.00 | -30,894.89 | 14.18% | ||||||||||||
91 | Office Supplies | 340.58 | 340.58 | 6,000.00 | -5,659.42 | 5.68% | ||||||||||||
92 | Other - Operations | 0.00 | 0.00 | 1,000.00 | -1,000.00 | 0.0% | ||||||||||||
93 | Phone & Internet | 460.46 | 460.46 | 8,000.00 | -7,539.54 | 5.76% | ||||||||||||
94 | Postage | 0.00 | 0.00 | 200.00 | -200.00 | 0.0% | ||||||||||||
95 | Prof. Dues, Subscrip.& Develop | 0.00 | 0.00 | 10,000.00 | -10,000.00 | 0.0% | ||||||||||||
96 | Professional Fees | |||||||||||||||||
97 | Accounting | 3,202.50 | 3,202.50 | 32,000.00 | -28,797.50 | 10.01% | ||||||||||||
98 | Attorney | 0.00 | 0.00 | 5,000.00 | -5,000.00 | 0.0% | ||||||||||||
99 | Audit | 0.00 | 0.00 | 8,500.00 | -8,500.00 | 0.0% | ||||||||||||
100 | CAI - HR | 0.00 | 0.00 | 1,300.00 | -1,300.00 | 0.0% | ||||||||||||