2020 Comprehensive Annual Financial Report

Schedule 2 4 Page 2 of 3

State and Federal Grants Fund Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual From Project Inception and For the Fiscal Year Ended June 30, 2020

Actual Current

Project

Prior Years

Total

Authorization

Year

To Date

Expenditures: (Continued) Public Safety (continued):

Safe Guilford Traffic Grant - FY 14

$

1,500 42,920 225,000 56,670 880,557 69,000 69,000 69,000 25,000 34,020 30,000 45,000

$

1,036

$

$ $

1,036 42,920 217,654 44,834 829,555 68,997 68,739 69,000 25,000 16,593 30,000 485,651 565,135 675,655 48,687 989,097 176,000 171,534 120,141 320,675 163,626 159,708 3,028 5,430,895

CFAT Grant FY 19 Colonial Pipeline-Bldg

42,920

217,654 44,834 712,466 68,997 68,739

DNA Cold Case Grant - FY 14

Metro Medical Response System - FY 03 RRT Homeland Security Grant - FY 17 RRT Homeland Security Grant - FY 18 RRT Homeland Security Grant - FY 19

117,089

69,000 25,000

Duke Energy Foundation Grant

AFG Grant - FY 17

16,593 30,000

Homeland Security Grant - FY17 Homeland Security Grant - FY18

3,028

Total Public Safety

6,583,277

3,581,050

1,849,845

Transportation: State Planning & Research/PL 104(f) - FY 18 State Planning & Research/PL 104(f) - FY 19 State Planning & Research/PL 104(f) - FY 20 Eckerson US 29 Environmental Study Section 5303 Metro Planning - FY 18 Section 5303 Metro Planning - FY 19 Section 5303 Metro Planning - FY 20 NCDOT Advanced Technology Grant FY 20 Safe Routes to School Grant Travel Survey Grant

486,789 565,135 808,691 300,000 721,000

485,651 565,135

675,655 48,687

1,050,000 176,000 176,000 176,000 320,705 163,626 186,817

989,097 176,000 171,534

120,141 320,675 163,626

Clean Fuel Technology Grant GDOT(Signal) Master Arm Project Greenway Phase 3A-Corner Park Randleman Road FYA Installation Streets Improvement - U-5306-A Streets Improvement - U-5306-B Streets Improvement - U-5306-C Streets Improvement - U-5306-D

159,708

NCDOT Project - Market Street-Fanta SC Driveway

32,621 34,690 12,000

78,199

(43,508)

34,691

4,836,025 12,959,788 1,580,000

4,372,467 2,337,612 1,474,713 319,672 11,129,788

252,582 2,608,203

4,625,049 4,945,815 1,414,270 319,672 15,215,406

(60,443)

325,000

Total Transportation

24,910,887

4,085,618

Environmental Services: Piedmont Triad Water Quality - Yr 14 Piedmont Triad Water Quality - Yr 15 NC Clean Water Management Phase III NC Clean Water Management Phase IV NC Clean Water Management Phase II - South Buffalo Community Waste Reduction and Recycling Program 2019

83,990 53,000 786,127 665,200 695,000 33,465

83,990 52,850 424,431 538,912 306,150

83,990 53,000 424,431 538,912 306,150 32,465

150

32,465 32,615

Total Environmental Services

2,316,782

1,406,333

1,438,948

(continued) -7 7 -