COG Comprehensive Annual Financial Report

Schedule 29 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, 2018

Actual Current

Project

Prior Years

Total

Authorization

Year

To Date

Expenditures: (Continued) Public Safety (continued): Community Oriented Policing Services-MINI Grant

$

49,648 785,000 225,000 56,670 880,557 69,000 69,000 29,850 45,000 5,000 99,450 34,020 6,000 8,000 63,415 30,000 1,500 1,119,648 7,194,588

$

47,606

$

$

47,606

FF Office Upgrades

Safe Guilford Traffic Grant - FY 14

944

92

1,036

Colonial Pipeline-Bldg

217,654 24,850 630,599 68,425 29,850 44,983 844,745 5,000 52,985

217,654 34,079 630,599 68,425 68,997 29,850 44,983 5,000 57,632 16,593 6,000 8,000 63,415 628,806 409,885 486,938 441,229 485,651 989,097 98,072 176,000 176,000 159,708 1,119,648 4,991,299

DNA Cold Case Grant - FY 14

9,229

Metro Medical Response System - FY 03

RRT Grant - FY 16 RRT Grant - FY 17

68,997

RRT Homeland Security Grant - FY 14 RRT Homeland Security Grant - FY 15

Safer Grant - FY 14

274,903

ADT Life Saver Award - FY 14

AFG Grant - FY 13

4,647 16,593

PSTP - FY 17

Crime Stoppers Gun Project - Yr 1 Crime Stoppers Gun Project - Yr 2

6,000

8,000

HMGP Generator

63,415

Homeland Security Grant - FY17

Total Public Safety

3,687,553

1,303,746

Transportation: Transportation Planning - FY 14 Transportation Planning - FY 15 Transportation Planning - FY 16 Transportation Planning - FY 17 Transportation Planning - FY 18 Eckerson US 29 Environmental Study Section 5303 Metro Planning - FY 16 Section 5303 Metro Planning - FY 17 Section 5303 Metro Planning - FY 18 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

691,511 581,661 496,863 556,426 486,789

628,806 409,885 486,938 441,229 975,278 98,072 176,000

485,651 13,819

1,050,000 176,700 176,000 176,000 186,817

176,000 66,175

93,533

NCDOT Project - Market Street-Fanta SC Driveway

32,621 34,690 12,000

78,199

78,199

2,545,850 1,302,652 1,190,506 319,672 9,488,265

4,400,000 3,530,000 1,580,000 325,000 14,493,078

1,462,305 1,255,953 509,648 319,672 6,857,319

1,083,545 46,699 680,858

Total Transportation

2,630,946

Environmental Services: Waste Reduction & Recycling Grant - FY 15 Piedmont Triad Water Quality - Yr 13 Piedmont Triad Water Quality - Yr 14 Piedmont Triad Water Quality - Yr 15 NC Clean Water Management Phase II - South Buffalo

32,900 41,724 83,990 53,000 786,127 665,200 695,000

25,548 41,723 47,539

1,224

26,772 41,723 62,581 36,506 424,431 538,912 136,324

15,042 36,506

424,431 538,912 87,685 1,165,838

NC Clean Water Management Phase III NC Clean Water Management Phase IV

48,639 101,411

Total Environmental Services

2,357,941

1,267,249

(continued) -85-