GENERAL FUND Monthly Target Percentage 66.67% February 28 ...
GENERAL FUND February 28, 2017
Monthly Target Percentage
Department
Amended
YTD
Budget
Actual
Encumbrances
66.67%
Remaining Budget
% Budget Used
PY
(including encumbrances)
(includes encumbrances)
YTD Actuals
REVENUES Ad Valorem Taxes
$
23,641,085
23,211,393
-
67,395
42,894
-
24,501
63.65%
38,893
9,732,605
3,640,465
-
6,092,140
37.40%
3,480,669
Other Taxes Unrestricted Intergovernmental Restricted Governmental
$
$
429,692
98.18% $
22,576,873
927,980
927,978
-
2
100.00%
911,851
1,975,385
1,453,133
-
522,252
73.56%
1,343,525
Other Revenue
729,700
473,839
-
255,861
64.94%
556,974
Sales and Services
809,755
623,051
-
186,704
76.94%
338,303
50,000
51,645
-
3,238,135
149,760
-
3,088,375
41,172,040
30,574,158
-
10,597,882 Remaining Budget
% Budget Used
PY
Encumbrances
(including encumbrances)
(includes encumbrances)
YTD Actuals
$
$
Permits and Fees
Investment Earnings Other Financing Sources General Fund Total
$
Department
Amended
YTD
Budget
Actual
(1,645)
103.29%
9,702
4.62%
1,616,196
74.26% $
30,872,984
EXPENDITURES 410 Board of Commissioners
$
676,825
$
461,730
-
215,095
68.22% $
454,780
415 Economic Development
224,615
126,952
-
97,663
56.52%
-
420 Administration
634,070
293,784
6,954
333,332
47.43%
281,585
425 Communications
636,040
427,130
42,794
166,116
73.88%
364,995
430 Human Resources
521,175
337,809
9,000
174,366
66.54%
335,794
435 Downtown Development
271,715
138,301
-
133,414
50.90%
129,671
440 Finance
1,272,010
742,823
121,543
407,644
67.95%
886,320
445 Management Information Systems
1,095,935
533,573
158,321
404,042
63.13%
589,544
480 Building Inspections
1,514,525
885,148
25,605
603,772
60.13%
838,565
490 Planning
1,154,585
615,322
97,475
441,788
61.74%
568,605
500 Public Facilities
3,351,060
2,339,874
355,317
655,869
80.43%
2,208,000
15,014,795
9,428,527
823,577
4,762,691
68.28%
10,341,737
188,380
106,179
1,450
80,751
57.13%
104,491
1,538,545
671,570
248,340
618,635
59.79%
665,722
492,705
250,858
16,832
225,015
54.33%
348,201
3,777,315
2,193,669
29,707
1,553,938
58.86%
1,802,825
510 Public Safety 530 Public Works Administration 540 Engineering 550 Fleet Maintenance 560 Streets 570 Powell Bill 580 Environmental Services 620 Parks and Recreation General Fund Total
$
915,630
453,903
10,033
451,694
50.67%
395,055
3,420,580
1,594,563
198,880
1,627,137
52.43%
1,858,669
4,471,535
2,323,978
612,367
1,535,190
41,172,040
23,925,693
2,758,194
14,488,154
Personnel transfer - February General Fund - Net Gain (Loss)
65.67%
2,323,759
64.81% $
24,498,320
$
6,374,664
(17,989) $
6,630,476
DMSD Special Revenue Fund February 28, 2017
Monthly Target Percentage
Department
Amended
YTD
Budget
Actual
Encumbrances
66.67%
Remaining Budget
% Budget Used
PY
(including encumbrances)
(includes encumbrances)
YTD Actuals
REVENUES Ad Valorem Taxes
$
71,500 $
Investment Earnings $
Department
- $
3,221
785
-
35,500
-
-
35,500
107,500
69,064
-
38,436
Other Financing Sources DMSD Special Revenue Fund Total
68,279
500
Amended
YTD
Budget
Actual
Encumbrances
(285)
95.50% $
65,719
157.00%
233
0.00%
-
64.25% $
65,952
Remaining Budget
% Budget Used
PY
(including encumbrances)
(includes encumbrances)
YTD Actuals
EXPENDITURES Transfers In (Out) DMSD Special Revenue Fund Total Downtown District - Net Gain (Loss)
$
107,500 $
- $
- $
107,500
0.00% $
-
$
107,500
-
-
107,500
0.00% $
-
69,064
65,952
Wake Forest Renaissance Centre February 28, 2017
Monthly Target Percentage
Department
Amended
YTD
Budget
Actual
Encumbrances
66.67%
Remaining Budget
% Budget Used
PY
(including encumbrances)
(includes encumbrances)
YTD Actuals
REVENUES Sales and Services
120,500 $
61,059 $
- $
50.67% $
56,888
Other Revenue
140,555
39,698
-
100,857
28.24%
40,377
Other Financing Sources
271,120
130,559
-
140,561
48.16%
-
532,175
231,316
-
300,859
43.47% $
WFRC Fund Total
$
$
Department
Amended
YTD
Budget
Actual
Encumbrances
59,441
97,265
Remaining Budget
% Budget Used
PY
(including encumbrances)
(includes encumbrances)
YTD Actuals
EXPENDITURES 626 Wake Forest Renaissance Centre WFRC Fund Total
$
532,175 $
262,884 $
3,593 $
265,698
50.07% $
167,056
$
532,175
262,884
3,593
265,698
50.07% $
167,056
Personnel transfer - February (JE posted in March) WFRC Fund - Net Gain (Loss)
17,989 $
(13,580)
$
(69,791)
ELECTRIC FUND February 28, 2017
Monthly Target Percentage
Department
Amended
YTD
Budget
Actual
Encumbrances
66.67%
Remaining Budget
% Budget Used
PY
(including encumbrances)
(includes encumbrances)
YTD Actuals
REVENUES Charges for Services
$
Sales Tax - Utility Other Revenue
19,063,295 $
Electric Fund Total
$
Department
- $
910,662
-
195,000
204,627
-
Investment Earnings Other Financing Sources
12,928,933
1,317,765
6,134,362 407,103
67.82% $
12,150,718
69.11%
850,289
(9,627)
104.94%
58,892 2,337
12,000
9,896
-
2,104
82.47%
490,000
-
-
490,000
0.00%
21,078,060
14,054,118
-
7,023,942 Remaining Budget
% Budget Used
PY
Encumbrances
(including encumbrances)
(includes encumbrances)
YTD Actuals
Amended
YTD
Budget
Actual
66.68% $
13,062,236
EXPENDITURES 850 Electric - Operations
$
860 Electric - Tree Trimming Electric Fund Total Electric Fund - Net Gain (Loss)
$
20,760,290 $
12,841,682 $
1,021,586 $
317,770
129,749
52,644
135,377
21,078,060
12,971,431
1,074,230
7,032,399
1,082,687
6,897,021
66.78% $ 57.40% 66.64% $
11,666,209 144,167 11,810,376 1,251,860
Monthly Target Percentage
Department
Amended
YTD
Budget
Actual
Encumbrances
66.67%
Remaining Budget
% Budget Used
PY
(including encumbrances)
(includes encumbrances)
YTD Actuals
REVENUES Ad Valorem Taxes
$
23,641,085
23,211,393
-
67,395
42,894
-
24,501
63.65%
38,893
9,732,605
3,640,465
-
6,092,140
37.40%
3,480,669
Other Taxes Unrestricted Intergovernmental Restricted Governmental
$
$
429,692
98.18% $
22,576,873
927,980
927,978
-
2
100.00%
911,851
1,975,385
1,453,133
-
522,252
73.56%
1,343,525
Other Revenue
729,700
473,839
-
255,861
64.94%
556,974
Sales and Services
809,755
623,051
-
186,704
76.94%
338,303
50,000
51,645
-
3,238,135
149,760
-
3,088,375
41,172,040
30,574,158
-
10,597,882 Remaining Budget
% Budget Used
PY
Encumbrances
(including encumbrances)
(includes encumbrances)
YTD Actuals
$
$
Permits and Fees
Investment Earnings Other Financing Sources General Fund Total
$
Department
Amended
YTD
Budget
Actual
(1,645)
103.29%
9,702
4.62%
1,616,196
74.26% $
30,872,984
EXPENDITURES 410 Board of Commissioners
$
676,825
$
461,730
-
215,095
68.22% $
454,780
415 Economic Development
224,615
126,952
-
97,663
56.52%
-
420 Administration
634,070
293,784
6,954
333,332
47.43%
281,585
425 Communications
636,040
427,130
42,794
166,116
73.88%
364,995
430 Human Resources
521,175
337,809
9,000
174,366
66.54%
335,794
435 Downtown Development
271,715
138,301
-
133,414
50.90%
129,671
440 Finance
1,272,010
742,823
121,543
407,644
67.95%
886,320
445 Management Information Systems
1,095,935
533,573
158,321
404,042
63.13%
589,544
480 Building Inspections
1,514,525
885,148
25,605
603,772
60.13%
838,565
490 Planning
1,154,585
615,322
97,475
441,788
61.74%
568,605
500 Public Facilities
3,351,060
2,339,874
355,317
655,869
80.43%
2,208,000
15,014,795
9,428,527
823,577
4,762,691
68.28%
10,341,737
188,380
106,179
1,450
80,751
57.13%
104,491
1,538,545
671,570
248,340
618,635
59.79%
665,722
492,705
250,858
16,832
225,015
54.33%
348,201
3,777,315
2,193,669
29,707
1,553,938
58.86%
1,802,825
510 Public Safety 530 Public Works Administration 540 Engineering 550 Fleet Maintenance 560 Streets 570 Powell Bill 580 Environmental Services 620 Parks and Recreation General Fund Total
$
915,630
453,903
10,033
451,694
50.67%
395,055
3,420,580
1,594,563
198,880
1,627,137
52.43%
1,858,669
4,471,535
2,323,978
612,367
1,535,190
41,172,040
23,925,693
2,758,194
14,488,154
Personnel transfer - February General Fund - Net Gain (Loss)
65.67%
2,323,759
64.81% $
24,498,320
$
6,374,664
(17,989) $
6,630,476
DMSD Special Revenue Fund February 28, 2017
Monthly Target Percentage
Department
Amended
YTD
Budget
Actual
Encumbrances
66.67%
Remaining Budget
% Budget Used
PY
(including encumbrances)
(includes encumbrances)
YTD Actuals
REVENUES Ad Valorem Taxes
$
71,500 $
Investment Earnings $
Department
- $
3,221
785
-
35,500
-
-
35,500
107,500
69,064
-
38,436
Other Financing Sources DMSD Special Revenue Fund Total
68,279
500
Amended
YTD
Budget
Actual
Encumbrances
(285)
95.50% $
65,719
157.00%
233
0.00%
-
64.25% $
65,952
Remaining Budget
% Budget Used
PY
(including encumbrances)
(includes encumbrances)
YTD Actuals
EXPENDITURES Transfers In (Out) DMSD Special Revenue Fund Total Downtown District - Net Gain (Loss)
$
107,500 $
- $
- $
107,500
0.00% $
-
$
107,500
-
-
107,500
0.00% $
-
69,064
65,952
Wake Forest Renaissance Centre February 28, 2017
Monthly Target Percentage
Department
Amended
YTD
Budget
Actual
Encumbrances
66.67%
Remaining Budget
% Budget Used
PY
(including encumbrances)
(includes encumbrances)
YTD Actuals
REVENUES Sales and Services
120,500 $
61,059 $
- $
50.67% $
56,888
Other Revenue
140,555
39,698
-
100,857
28.24%
40,377
Other Financing Sources
271,120
130,559
-
140,561
48.16%
-
532,175
231,316
-
300,859
43.47% $
WFRC Fund Total
$
$
Department
Amended
YTD
Budget
Actual
Encumbrances
59,441
97,265
Remaining Budget
% Budget Used
PY
(including encumbrances)
(includes encumbrances)
YTD Actuals
EXPENDITURES 626 Wake Forest Renaissance Centre WFRC Fund Total
$
532,175 $
262,884 $
3,593 $
265,698
50.07% $
167,056
$
532,175
262,884
3,593
265,698
50.07% $
167,056
Personnel transfer - February (JE posted in March) WFRC Fund - Net Gain (Loss)
17,989 $
(13,580)
$
(69,791)
ELECTRIC FUND February 28, 2017
Monthly Target Percentage
Department
Amended
YTD
Budget
Actual
Encumbrances
66.67%
Remaining Budget
% Budget Used
PY
(including encumbrances)
(includes encumbrances)
YTD Actuals
REVENUES Charges for Services
$
Sales Tax - Utility Other Revenue
19,063,295 $
Electric Fund Total
$
Department
- $
910,662
-
195,000
204,627
-
Investment Earnings Other Financing Sources
12,928,933
1,317,765
6,134,362 407,103
67.82% $
12,150,718
69.11%
850,289
(9,627)
104.94%
58,892 2,337
12,000
9,896
-
2,104
82.47%
490,000
-
-
490,000
0.00%
21,078,060
14,054,118
-
7,023,942 Remaining Budget
% Budget Used
PY
Encumbrances
(including encumbrances)
(includes encumbrances)
YTD Actuals
Amended
YTD
Budget
Actual
66.68% $
13,062,236
EXPENDITURES 850 Electric - Operations
$
860 Electric - Tree Trimming Electric Fund Total Electric Fund - Net Gain (Loss)
$
20,760,290 $
12,841,682 $
1,021,586 $
317,770
129,749
52,644
135,377
21,078,060
12,971,431
1,074,230
7,032,399
1,082,687
6,897,021
66.78% $ 57.40% 66.64% $
11,666,209 144,167 11,810,376 1,251,860
