Loading...
HomeMy WebLinkAbout20170801.tiffUS DEPARTMENT OF JUSTICE OFFICE OF JUSTICE PROGRAMS Standard C Grantee Name: Weld County Award Number: 2009-D1-BX-0263 Award Amount: $500,000.00 Project Period Begin Date: 10/01/2009 Project Period End Date: 12/31/2016 Grant Manager: Kathy Mason OJP Vendor Number: 846000813 loseout Package Status Expenditure/Obligation End Date: 12/31/2016 Liquidation End Date: 03/31/2017 Submit Your Closeout Package By Date: 03/31/2017 Closeout Status: Draft Status Date: 02/13/2017 [Original Award Amount I $500,000.00 ] De -Obligation Amount $0.00 Adjusted Award Amount $500,000.00 [Disbursed Amount I ($500,000.00) I Requirement II Status I Last Submission Date [Final Progress Report I Complete 03/02/2017 [Final Financial Status Report [ Complete 02/24/2017 [Special Condition Compliance fl Complete 11 05/02/2016 [Financial Reconciliation I Complete 02/24/2017 [Programmatic Requirements Certification r Complete II 02/13/2017 [[The grant has met all financial reporting and programmatic requirements. Closeout Text I User Attachments: Alone Role Closeout Documents Document Date Actions: Close Print 'Audit Trail: (. 2amrYkui(ia(„CYDO 020/7 -O8O/ LSD 003g Reference 2009 COngresional Select grant All Special Ccnditicns have been met US DEPARTMENT OF JUSTICE OFFICE OF JUSTICE PROGRAMS Programmatic Requirements Grantee Name: Weld County Award Number: 2009-D1-BX-0263 Award Amount: $500,000.00 Project Period Begin Date: 10/01/2009 Project Period End Date: 12/31/2016 Grant Manager: Kathy Mason OJP Vendor Number: 846000813 Expenditure/Obligation End Date: 12/31/2016 Liquidation End Date: 03/31/2017 Submit Your Closeout Package By Date: 03/31/2017 Closeout Status: Draft - Grantee Status Date: 02/13/2017 Date Submitted (mm/dd/yyyy) N/A File Technical Report Data Sets Proto-type Software Forensic Technique Subgrant Reports Other Actions: Close Print US DEPARTMENT OF JUSTICE OFFICE OF JUSTICE PROGRAMS Final Financial Status Report FEDERAL FINANCIAL REPORT (Follow form instructions) 1. Federal Agency and Organizational Element to Which Report is Submitted U.S. Department of Justice 2. Federal Grant or Other Identifying Number Assigned by Federal Agency (To report multiple grants, use FFR attachment) 2009-D1-BX-0263 3. Recipient Organization (Name and complete address including Zip code) Weld County 1950 "O" Street Greeley, CO 80631 -9503 4a. DUNS Number 075757955 4b. EIN 84-6000813 5. Recipient Account Number or Identifying Number (To report multiple grants, use FFR attachment) 6. Final Report Yes 7. Basis of Accounting Cash 8. Project/Grant Period From: (Month, Day, Year) 10/01/2009 To: (Month, Day, Year) 12/31/2016 9. Reporting Period End Date (Month, Day, Year) 12/31/2016 10. Transactions Previously Reported This Period Cumulative (Use lines a -c for single or multiple grant reporting) Federal Cash (To report multiple grants, also use FFR Attachment): a. Cash Receipts b. Cash Disbursements c. Cash on Hand (line a minus b) (Use lines d -o for single grant reporting) Federal Expenditures and Unobligated Balance: d. Total Federal funds authorized $500000.00 e. Federal share of expenditures $464927.07 $35072.93 $500000.00 I. Federal share of unliquidated obligations $0.00 g. Total Federal share (sum of lines e and 1) $500000.00 h. Unobligated balance of Federal funds (line d minus g) $0.00 Recipient Share: i. Total recipient share required $0.00 j. Recipient share of expenditures $0.00 $0.00 $0.00 k. Remaining recipient share to be provided (line i minus j) $0.00 Program Income: I. Total Federal program income earned $0.00 m. Program income expended in accordance with the deduction alternative $0.00 n. Program income expended in accordance with the addition alternative a. Unexpended program income (line I minus line rn or line n) $0.00 11.. Indirect Expense a. Type of Rate b. Rate c. Period d. Base e. Amount Charged f. Federal Share From I To g. Totals $0.00 $0.00 $0,00 12, Remarks: Attach any explanations deemed necessary or information required by Federal sponsoring agency in compliance with governing legislation, 13. Certification: By signing this report, 1 certify that it is true, complete, and accurate to the best of my knowledge. 1 am aware that any false, fictitious, or fraudulent information may subject me to criminal, civil, or administrative penalties. (U.S. Code, Title 18, Section 1001) Prefix Ms. Prefix (Other) First Name Barb Middle Initial Last Name Connolly Suffix Suffix (Other) CPA Title Controller Telephone (Area code, number and extension) (970) 356-4000 Ext. 4445 E-mail Address bconnolly@co.weld.co.us Date Report Last Submitted 02/24/2017 14. Agency use only OJP Vendor Number 1846000813 Print US DEPARTMENT OF JUSTICE OFFICE OF JUSTICE PROGRAMS Financial Reconciliation Grantee Name: Weld County Award Number: 2009-D1-BX-0263 Award Amount: $500,000.00 Project Period Begin Date: 10/01/2009 Project Period End Date: 12/31/2016 Grant Manager: Kathy Mason OJP Vendor Number: 846000813 1. Federal Award (a) Award Amount (b) Total Federal Share of Outlay (SF -425 10e) (c) Remaining Federal Funds 2. Non -Federal Match Expenditure/Obligation End Date: 12/31/2016 Liquidation End Date: 03/31/2017 Submit Your Closeout Package By Date: 03/31/2017 Closeout Status: Draft - Grantee Status Date: 02/13/2017 $500,000.00 $500,000.00 $0.00 Note:Non-Federal Match is not Required for this Award, however, at the time of application submission, you included a match. (a) Required $0.00 Override: $ (b) Recipients Share of Outlays (SF -425 10j) $0.00 (c) Difference $0.00 3. Total Project Budget & Costs (a) Total Approved Project Costs (la + 2a) Budget $500,000.00 (b) Total Actual Project Costs (lb + 2b) Actual $500,000.00 4. Total Federal Share of Outlays & Drawdowns (a) Total Federal Share of Outlays (SF -425 10e) $500,000.00 (b) Total Drawdowns $500,000.00 (c) Difference $0.00 5. Total Program Income (a) Program Income (SF -425 101) $0.00 (b) Program Income Spent (SF -425 10n) $0.00 (c) Balance (Due From) Grantee (SF -425 100) $0.00 6. Closeout Balance (4c + 5c) (a) Funds Due OJP [(4c + 5c) < 0] (b) Funds to Drawdown [(4c + 5c) > 0] $0.00 $0.00 *If you override Non -Federal match in 2(a), you are required to enter a justification. Actions: Close Print RESOLUTION RE: APPROVE GRANT CLOSEOUT AND FINANCIAL RECONCILIATION FOR 2009 CONGRESSIONAL SELECT GRANT AND AUTHORIZE ELECTRONIC SUBMITTAL WHEREAS, the Board of County Commissioners of Weld County, Colorado, pursuant to Colorado statute and the Weld County Home Rule Charter, is vested with the authority of administering the affairs of Weld County, Colorado, and WHEREAS, the Board has been presented with a Grant Closeout and Financial Reconciliation for the 2009 Congressional Select Grant (Grant #2009-D1-BX-0263) from the County of Weld, State of Colorado, by and through the Board of County Commissioners of Weld County, on behalf of the Northern Colorado Regional Crime Laboratory, to the U.S. Department of Justice, Office of Justice Programs, and WHEREAS, after review, the Board deems it advisable to approve said grant closeout, a copy of which is attached hereto and incorporated herein by reference. NOW, THEREFORE, BE IT RESOLVED by the Board of County Commissioners of Weld County, Colorado, that the Grant Closeout and Financial Reconciliation for the 2009 Congressional Select Grant (#2009-D1-BX-0263) from the County of Weld, State of Colorado, by and through the Board of County Commissioners of Weld County, on behalf of the Northern Colorado Regional Crime Laboratory, to the U.S. Department of Justice, Office of Justice Programs, be, and hereby is, approved. BE IT FURTHER RESOLVED by the Board that the Clerk to the Board be, and hereby is, authorized to electronically submit said grant closeout. The above and foregoing Resolution was, on motion duly made and seconded, adopted by the following vote on the 20th day of March, A.D., 2017. BOARD OF COUNTY COMMISSIONERS WELD COUNTY, COLORADO ATTEST: ) Jeito;ok Weld County Clerk to the Board BY: D ounty Attorney Date of signature: 9 (511"7 Eti c Cozad, Chair Mertswer- Steve Moreno, Pro - Sean P. Conway rbara Kirkmeyer CC: SO C. Ras! To) aC TC (3C) 2017-0801 SO0038 BOARD OF COUNTY COMMISSIONERS PASS -AROUND REVIEW RE: Authorization to submit close out report for the 2009 Congressional Grant through electronic portal. DEPARTMENT: Sheriff's Office DATE: 02/16/2017 PERSON REQUESTING: Ronald Arndt, Crime Lab Director Brief description of the problem/issue: In 2009 we were awarded a $500,000 Congressional Select grant earmarked to provide Weld County with funds to start up a Forensic Laboratory in Weld County. The funds were approved to pay the Operation and Maintenance costs for the regional lab once the building was built. In 2013 having met of the conditions specified in the grant, coupled with the completion of the facility we began to draw down funds from this grant. Over the course of the past 7 years we have submitted quarterly financial reports and semi-annual project narratives. We have also been able to spend down $500,000 of the $500,000 granted. At this time we have completed the last quarterly financial report and submitted a final draw down from the grant. (We had to submitted an adjustment today 2/24/17 so the attached financial reconciliation is still ongoing) In addition, the final semi-annual report and metrics have been submitted to GMS. It appears as though all we need to do is complete the required fields in GMS and hit submit. The Grant Management System does not require a physical signature to submit, just authorization from the Governing Body Head, which would be Commissioner Cozad. Director Don Warden, Controller Barb Connolly and Attorney Frank Haug have reviewed the attached report as well. We are asking for authorization to submit the annual certification as required by the deadline of March 30, 2017. What options exist for the Board? (Include consequences, impacts, costs, etc. of options) Authorize the submission of the required grant close out report, maintaining compliance with federal regulations. Deny authorization to file, which could lead to repayment of expenditures and loss of future revenues. Schedule a work session to further discuss the grant close out report. Recommendation: Authorize submission of final required documents if any remain for submission to close out of this grant. Approve Recommendation Sean P. Conway Julie A. Cozad, Chair Mike Freeman Barbara Kirkmeyer Steve Moreno, Pro-Tem Schedule Work Session Other/Comments: 2017-0801 Closeout Ala N Closeout Package Status Final Progress Report Final SF -269 Financial Report Special Condition Compliance Financial Reconciliation Programmatic Requirements Closeout Instructions Complete 'No Cost Extension' CAN Grant Contact Information Help/Frequently Asked Questions CMS Home Log Off Closeout Page 1 of 1 US DEPARTMENT OF JUSTICE OFFICE OF JUSTICE PROGRAMS Standard Closeout Grantee Name: Weld County Award Number: 2009-D1-BX-0263 Award Amount: $500,000.00 Project Period Begin Date: 10/01/2009 Project Period End Date: 12/31/2016 Grant Manager. Kathy Mason OJP Vendor Number: 846000813 Package Status Expenditure/Obligation End Date: 12/31/2016 Liquidation End Date: 03/31/2017 Submit Your Closeout Package By Date: 03/31/2017 Closeout Status: Draft Status Date: 02/13/2017 Original Award Amount Disbursed Amount 1$500,000.00 ($496,179.21) De -Obligation Amount f$0.00 Adjusted Award Amount $500,000.00 [Final Progress Report Requirement Final Financial Status Report Special Condition Compliance Financial Reconcilation Programmatic Requirements Certification Status Incomplete Complete Complete Incomplete Complete Last Submission Date 02/24/2017 02/24/2017 05/02/2016 02/24/2017 02/13/2017 Closeout Documents User Role Document Date Attachments: None ctions: Save Print Cancel 'Audit Trail: Description: Role: User: � Timestamp: 1� Note: 4 O#J LirJF5- Vt OEo View co https://grants.oj p. usdoj .gov/gmsexternal/closeout/closeoutPackageStatus.st?awardNumber... 2/24/2017 1) Ct a. 2009-D1-BX-0263 BJA FY 09 Congressionally Selected V O a) a) Ct O C/) $. C U O` O CO Financial Status Re v ra U C C O a) C v o L Cr) cn C 2.2 o o O'1 U p Q L 0 O1 L O a? v CM v L O1 C a J C 4C E a) v a E O O (1) 3 cr) O L. o (O Y O O . O C 'c (O a) - V (n a) L a) cm (O Q Semi -Annual Semi -Annual Pro For questions about what to submit click here. IStatus Last Edited I Action 3 a) > ri; 5 3 a) > 3 a0 > 3 a) > 3 a) > 3 0) > 3 a) > 3 a) > 3 a) > 3 0 5 3 a) 5 3 0 5 3 a0 5 3 a0 5 o .-r O NJ C 03 n 0C) N 04 -Oct -2010 -( -4 O NJ C 03 n .-1 N -4 --1 O N ' J n N N 26 -Jan -2012 19 -Jul -2012 23 -Jan -2013 M el ( O ' J n I el M 27 -Jan -2014 v te N a' J C N r-( O N C n OM tl7 O NI ' n N 27 -Jan -2016 29 -Jul -2016 24 -Feb -2017 V a) > O L. a a C V a) > O L a a C V a) > O L a a Q V v > O L a a C panoJddv V a) > O L a a C Approved V a) > O L a a C V a) > O L a a Q V a, > O L a a C V a) > O L a a C V v > O L a a C O v > O L a a C V a) > O L a a C 15 I 01 -Jul -2016 - 31 -Dec -2016 Final Submitted Report I 411 a III. Regular Regular Regular (U j al Ce Regular Regular Regular Regular Regular Regular L ro cm Ca) Regular 1 L to en Ce Regular Reporting Period I01 -Oct -2009 - 31 -Dec -2009 O •""r O N C J n o M c O N C n I .--I O O .-1 O N U 0) O M O '' O N ' J n .-1 O --( -1 O N C =CU n o M "'r el O N , C co n .-1 O . .--4 .-( o N v O f l „� .--r O N ' J n .--1 O N el O N r n o el N O N C (p n I .-1 O r .. (y .-4 O N .)ai O I f 1 N 'l O N ' J en I el O en el O N > n o r+ 1 M O N , C ro n I e1 O 01 -Jul -2013 - 31 -Dec -2013 V -4 O N > n o M I c el O N C r0 n I el O . --1 o ry U a O M el O N ' J n I e( O in .--r O N C O n o M I tt1 el N C (0 n I e1 O in O N a a O en -~ O N ' J n .--1 O LO .--( O N C J n o M , 1,D O N C rp n e1 O Report Number -� 4'''l N M Cr III _ CO N. CO _ CT O •--r M .-4 f It 4 j) L es D a) S VI L Q t O O O CU a a CC CD C (Q a) v It _ �c uN) co N c C o o L1 u v C C in L O Q` - O v u Q Q� L o c a ( E coar = MC () tn L orts Home GMS Home O U O BJA FY 09 Congressionally Selected Page 1 of 1 BJA FY 09 Congressionally Selected 2009-D1-BX-0263 Award Financial Status Reports Semi -Annual Progress Reports Correspondence Semi -Annual Progress Report Handbook Report Overview Point of Contact Performance Metrics Narratives Attachments Certification Submit Report Help/Frequently Asked Questions Semi -Annual Progress Reports Home GMS Home Log Off Report Overview Federal Award Number 2009-D1-BX-0263 Award Amount $500,000.00 Grantee WELD COUNTY OF Project Title Northern Colorado Regional Forensic Laboratory Report Number 15 Reporting Period From 01 -Jul -2016 Reporting Period To 31 -Dec -2016 Implementing Sub Grantee • Report Type: Final Report Continue https://grants.ojp.usdoj.gov/gmsexternal/progressOverview.do 2/24/2017 BJA FY 09 Congressionally Selected BJA FY 09 Congressionally Selected 2009-D1-BX-0263 Page 1 of 1 Award Financial Status Reports Semi -Annual Progress Reports Correspondence Semi -Annual Progress Report Handbook Report Overview Point of Contact Performance Metrics Narratives Attachments Certification Submit Report Help/Frequently Asked Questions Semi -Annual Progress Reports Home GMS Home Log Off Point of Contact *Prefix: Mr. Prefix (Other): * First Name: Ronald Middle Initial: E Last Name: Arndt Suffix Suffix (Other): *Title: Laboratory Director Address Line 1: 1950 O Street Address Line 2: *City: Greeley County: State: Colorado 'Zip Code: 80631-9503 Phone: 970-356-4015 Ext : 3638 Fax: -- *E-mail: rarndt@co.weld.co.us Continue https://grants.ojp.usdoj.gov/gmsexternal/progressPOC.do 2/24/2017 BJA FY 09 Congressionally Selected Page 1 of 2 BJA FY 09 Congressionally Selected 2009-D1-BX-0263 Award Financial Status Reports Semi -Annual Progress Reports Correspondence Semi -Annual Progress Report Handbook Report Overview Point of Contact Performance Metrics Narratives Attachments Certification Submit Report Help/Frequently Asked Questions Semi -Annual Progress Reports Home GMS Home Log Off Performance Metrics What were your accomplishments within this reporting period? We had asked for an extension to December 31st. All of the local agencies participating in this lab have a fiscal year of January to December. As a result we able to provide the additional time to get everyone set to start payments on the O & M costs January 1 2017. We have reached a point where the local agencies are prepared to keep the lab in the region and continue to provide quality service to the region. This extension was helpful in establishing a sustainable lab in this region. Specifically within the lab CODIS was installed and we are uploading profiles to CODIS weekly. NIBIN Matchpoint is installed and we are using it to do correlations on NIBIN entries. What goals were accomplished, as they relate to your grant application? All the goals we had set relative to this grant application were accomplished. The biggest accomplishment directly linked to this grant is the sustainability created for this lab because of the funds. Having the funds available put us on target to build a facility to house all lab analysts. The prior arrangement, housing each discipline in a separate building in different cities, while functional short-term would not work over time. Housing all examiners in one building not only gave an air of credibility but also gave each agency a landmark they could point to and say "we have a lab that serves our needs". The funds also provided the time necessary to get the lab ISO/IEC: 17025 accredited. Thanks to our partnership with the state crime lab we were able to achieve that critical goal for all disciplines in the Northern Colorado Regional Forensic Laboratory. That did include our DME unit, and that unit is being looked at nationally as an example of how a local DME unit can attain ISO/IEC:17025 accreditation. Finally, having the forensic databases: NIBIN, CODIS and AFIS within our laboratory have provided us with access to information to serve our agencies and share with other agencies state-wide and nationally. The addition of DNA gave us access to CODIS so we not only are processing DNA cases in the lab but all CODIS eligible profiles are being entered and searched: locally, state-wide and nationally. We have also partnered with the state lab to provide NIBIN services and are working with the state and ATF to involve the lab a state-wide program to rapidly enter fired shell casings into NIBIN so as to link weapons and individuals to gun related criminal activity. As one of our commissioners noted, these funds gave us the time to build the foundation we needed to have a viable and sustainable quality forensic lab. What problems/barriers did you encounter, if any, within the reporting period that prevented you from reaching your goals or milestones? none Is there any assistance that BJA can provide to address any problems/barriers identified in question #3 above? (Please answer YES or NO only.) NO Are you on track to fiscally and programmatically complete your program as outlined in your grant application? (Please answer YES or NO. If no, please explain.) YES What major activities are planned for the next 6 months? The grant closed December 31, 2016. All goals planned relative to this grant were accomplished. We plan to continue to serve this community, offering the current services and working here locally to expand NIBIN service to this area. Based on your knowledge of the criminal justice field, are there any innovative programs/accomplishments that you would like to share with BJA? See # 2 above. This concept of a regional lab is not unique, but the fact we have been able to successfully partner with city, county, state and federal agencies to work together to provide forensic services to this region is quite an accomplishment. Politics and egos were set aside in order to create this lab and facility and we have been able to do what we were expected to do, serve the public by providing services to this regional area. Number of tasks* that were completed during the reporting period that are directly linked to Congressionally selected funding. 1 https://grants.ojp.usdoj.gov/gmsexternal/progressMetrics.do 2/24/2017 BJA FY 09 Congressionally Selected Page 2 of 2 Number of total tasks (complete or incomplete) that are directly linked to Congressionally selected funding. 26 Number of tasks that were completed during the reporting period that build capacity** in your agency and are directly linked to Congressionally selected funding. 1 Continue https://grants.ojp.usdoj.gov/gmsexternal/progressMetrics.do 2/24/2017 BJA FY 09 Congressionally Selected BJA FY 09 Congressionally Selected 2009-D1-BX-0263 Award Financial Status Reports Semi -Annual Progress Reports Correspondence Semi -Annual Progress Report Handbook Report Overview Point of Contact Narratives Page 1 of l Use the narratives to enter any additional information you would like you provide. Commence Report Here See attached narrative report. Performance Continue Metrics Narratives Attachments Certification Submit Report Help/Frequently Asked Questions Semi -Annual Progress Reports Home GMS Home Log Off https://grants.ojp.usdoj.gov/gmsexternal/progressNarrative.do 2/24/2017 BJA FY 09 Congressionally Selected Page 1 of l BJA FY 09 Congressionally Selected 2009-D1-BX-0263 Award Financial Status Reports Semi -Annual Progress Reports Correspondence Semi -Annual Progress Report Handbook Report Overview Point of Contact Attachments Use attachments for any additional information you would like you provide. Semi -Annual Progress Report Attachments Jul to Dec 2016 narrative CONG 2009[1].pdf Performance Continue Metrics Narratives Attachments Certification Submit Report Help/Frequently Asked Questions Semi -Annual Progress Reports Home GMS Home Log Off https://grants.ojp.usdoj.gov/gmsexternal/progressAttachments.do 2/24/2017 Weld County Sheriff's Office Congressional Select Grant # 2009- DI-BX-0263 24 February 2017 Final Report NARRATIVE: For period: July to December 2016 PROGRESS TOWARDS GOALS/OBJECTIVES GOAL 1: The first step of this project was to bring together all of the resources that each agency currently possesses into their respective disciplines and have them work together as a functional group. Goal Outcome Measures: This goal has been accomplished. We have been operational for almost 3 years and have brought a full service, ISO: IEC 17025 laboratory to the northern Colorado region. GOAL2: The second goal of this project will be to design, build, and sustain a state-of- the-art facility to place all of the analysts and equipment that the multiple agencies have less than one roof to enhance the local service deliverables. Objective One: To refine the Facilities Program and to implement and develop the Schematic Design/Design Development through consultation to come up with: 1) Preliminary Space Plan, 2) Concept Sketches/Renderings of Exterior of Building (2 drawings), and 3) Preliminary LEED/High Performance Build Study. a. Activities implemented: We sought and received permission to move the funds that were not spent on this objective to pay for the Operation and Maintenance of the building. All funds from the "Consultant/Contracts" category were transferred to the "Other" category. They have been used to make payments to keep the building operational from July to Dec 2016. b. Problems encountered: None at this time. Goal Outcome Measures: a. Indicators: The building has been occupied and all disciplines are processing evidence in the regional lab. Forensic DNA began processing evidence January 20, 2016. CODIS was installed and is now operational. NIBIN has also been incorporated into the lab system. At this point we have the ability to do the correlation phase of NIBIN. . We are seeking funding to obtain the equipment for the acquisition phase of NIBIN. b. Funds expended: See objective # 2. c. Significant changes: None d. Changes being proposed to improve the program: We have submitted a budget modification to allow for the funds from this category to be used in the "Other" category consistent with the spending approved in that category. This budget modification was approved. Objective Two: Once the facility is built, to provide operational costs for the first two years. This will give each agency involved in this collaboration the requisite time to begin budgeting for the sustainability of this project. c. Activities implemented: A request for a no cost extension was made and approved to extend to December 31, 2016. That extension was approved and the grant closed December 31, 2016. d. Problems encountered: None Goal Outcome Measures: a. Indicators: The building has been occupied and all disciplines are processing evidence in the regional lab. CODIS eligible samples are being processed and profiles have been uploaded. NIB IN correlations are being done in the lab. b. Funds expended: As of December 31, 2016: $ 500,000. c. Significant changes: None d. Changes being proposed to improve the program: None at this time. BJA FY 09 Congressionally Selected Page 1 of 2 BJA FY 09 Congressionally Selected 2009-D1-BX-0263 Award Financial Status Reports Semi -Annual Progress Report Handbook Report Overview Point of Contact Performance Metrics Narratives Attachments Certification Submit Report Help/Frequently Asked Questions Semi -Annual Progress Reports Home GMS Home Log Off Semi -Annual Progress Reports Correspondence Certification To the best of my knowledge and belief, all data in this progress report that I have provided is true and correct, the document has been duly authorized by the governing body of the grantee and the applicant will comply with the attached certifications. Your typed name, in lieu of your signature represents your legal binding acceptance of the terms of your grant and your statement of the veracity of the representations made in this progress report. The document has been duly authorized by the governing body of the grantee and the grantee will comply with the following: * Prefix: Mr. Prefix (Other): *First Name: Mike Middle Initial: '` Last Name: Freeman Suffix Suffix (Other): 'Title: Chairman 'Address Line 1: 1150 O Street Address Line 2: *City: Greeley County: *State: Colorado *Zip Code: 80631-9596 *Phone: 970-356-7204 Ext : 4208 Fax: 970-336-7233 *E-mail: mfreeman@co.weld.co.us U.S. DEPARTMENT OF JUSTICE OFFICE OF JUSTICE PROGRAMS OFFICE OF THE CHIEF FINANCIAL OFFICER A. The grantee certifies that the appropriated funds were spent for the purpose or purposes of the grant and only such purpose or purposes, httpsJ/grants.ojp.usdoj.gov/gmsexternal/progressCertification.do 2/24/2017 BJA FY 09 Congressionally Selected BJA FY 09 Congressionally Selected 2009-D1-BX-0263 Award Financial Status Reports Semi -Annual Progress Report Handbook Report Overview Point of Contact Performance Metrics Narratives Attachments Certification Submit Report Help/Frequently Asked Questions Semi -Annual Progress Reports Home GMS Home Log Off Page 1 of 1 Semi -Annual Progress Reports Correspondence Submit Report Your report has been submitted. hops://grants.ojp.usdoj.gov/gmsexternal/progressSubmit.do 2/24/2017 Closeout - Final Financial Status Report Page 1 of 2 US DEPARTMENT OF JUSTICE OFFICE OF JUSTICE PROGRAMS Final Financial Status Report FEDERAL FINANCIAL REPORT (Follow form instructions) 1. Federal Agency and Organizational Element to Which Report is Submitted U.S. Department of Justice 2. Federal Grant or Other Identifying Number Assigned by Federal Agency 2009-D1-BX-0263 (To report multiple grants, use FFR attachment) 3. Recipient Organization (Name and complete address including Zip code) Weld County 1950 "O" Street Greeley, CO 80631 -9503 4a. DUNS Number 075757955 4b. EIN 84-6000813 5. Recipient Account Number or Identifying Number (To report multiple grants, use FFR attachment) 6. Final Report Yes 7. Basis of Accounting Cash 8. Project/Grant Period From: (Month, Day, Year) 10/01/2009 To: (Month, Day, Year) 12/31/2016 9. Reporting Period End Date (Month, Day, Year) 12/31/2016 10. Transactions Previously Reported This Period Cumulative (Use lines a -c for single or multiple grant reporting) Federal Cash (To report multiple grants, also use FFR Attachment): a. Cash Receipts b. Cash Disbursements c. Cash on Hand (line a minus b) (Use lines d -o for single grant reporting) Federal Expenditures and Unobligated Balance: d. Total Federal funds authorized $500000.00 e. Federal share of expenditures $464927.07 $35072.93 $500000.00 f. Federal share of unliquidated obligations $0.00 g. Total Federal share (sum of lines e and f) $500000.00 h. Unobligated balance of Federal funds (line d minus g) A $0.00 Recipient Share: i. Total recipient share required $0.00 j. Recipient share of expenditures $0.00 $0.00 $0.00 k. Remaining recipient share to be provided (line i minus j) $0.00 Program Income: I. Total Federal program income earned $0.00 m. Program income expended in accordance with the deduction alternative https://grants.ojp.usdoj.gov/gmsexternal/closeout/loadSf269.st?awardNumber=2009-D 1-B... 2/24/2017 Closeout - Final Financial Status Report n. Program income expended in accordance with the addition alternative o. Unexpended program income (line I minus line m or line n) Page 2 of 2 $0.00 $0.00 11. Indirect Expense a. Type of Rate I b. Rate c. Period e. Amount Charged 1. Federal Share From I To d. Base g. Totals $0.00 $0.00 $0.00 12. Remarks: Attach any explanations deemed necessary or information required by Federal sponsoring agency in compliance with governing legislation. 13. Certification: By signing this report, I certify that it is true, complete, and accurate to the best of my knowledge. I am aware that any false, fictitious, fraudulent administrative penalties. (U.S. Code, Title or Information may subject me to criminal, civil, or 18, Section 1001) Prefix Ms. Prefix (Other) First Name Barb , Middle Initial Last Name Connolly Suffix Suffix (Other) CPA Title Controller Telephone (Area code, number and extension) (970) 356-4000 Ext. 4445 E-mail Address bconnolly@co.weld.co.us Date Report Last Submitted 02/24/2017 14. Agency use only OJP Vendor Number 846000813 Print https://grants.ojp.usdoj.gov/gmsexternal/closeout/loadSf269.st?awardNumber2009-D 1-B... 2/24/2017 Message from webpage All Special Conditions have been met it OK Closeout - Financial Reconciliation Page 1 of 1 US DEPARTMENT OF JUSTICE OFFICE OF JUSTICE PROGRAMS Financial Reconciliation Grantee Name: Weld County Award Number: 2009-D1-BX-0263 Award Amount: $500,000.00 Project Period Begin Date: 10/01/2009 Project Period End Date: 12/31/2016 Grant Manager: Kathy Mason OJP Vendor Number: 846000813 1. Federal Award (a) Award Amount (b) Total Federal Share of Outlay (SF -425 10e) (c) Remaining Federal Funds 2. Non -Federal Match Note:Non-Federal Match is not Required for this Award, however, at the time of application submission, you included a match. (a) Required $0.00 Override: $ Expenditure/Obligation End Date: 12/31/2016 Liquidation End Date: 03/31/2017 Submit Your Closeout Package By Date: 03/31/2017 Closeout Status: Draft - Grantee Status Date: 02/13/2017 $500,000.00 $500,000.00 $0.00 (b) Recipients Share of Outlays (SF -425 10j) $0.00 (c) Difference $0.00 3. Total Project Budget & Costs (a) Total Approved Project Costs (la + 2a) Budget $500,000.00 (b) Total Actual Project Costs (lb + 2b) Actual $500,000.00 4. Total Federal Share of Outlays & Drawdowns (a) Total Federal Share of Outlays (SF -425 10e) $500,000.00 (b) Total Drawdowns $496,179.21 (c) Difference $3,820.79 5. Total Program Income (a) Program Income (SF -425 101) $0.00 (b) Program Income Spent (SF -425 10n) $0.00 (c) Balance (Due From) Grantee (SF -425 10o) $0.00 6. Closeout Balance (4c + 5c) (a) Funds Due OJP [(4c + 5c) < 0] $0.00 (b) Funds to Drawdown [(4c + 5c) > 0] $3,820.79 Please go to OJP's payment system and drawdown funds. The closeout package cannot be submitted until the drawdown is posted on the financial reconciliation form. This usually takes 1-2 business days. *If you override Non -Federal match in 2(a), you are required to enter a justification. Actions: Close Print https://grants.ojp.usdoj.gov/gmsexternal/closeout/loadFinancial Recon.st?awardNumber=2... 2/24/2017 Closeout - Programmatic Requirements Page 1 of 1 Closeout Package Status Final Progress Report Final Financial Status Report Special Condition Compliance Financial Reconciliation Programmatic Requirements Closeout Instructions Complete 'No Cost Extension' GAN Grant Contact Information Help/Frequently Asked Questions GMS Home Log Off Award Amount: $500,000.00 Project Period Begin Date: 10/01/2009 Project Period End Date: 12/31/2016 Grant Manager: Kathy Mason OJP Vendor Number: 846000813 Closeout US DEPARTMENT OF JUSTICE OFFICE OF JUSTICE PROGRAMS Programmatic Requirements Grantee Name: Weld County Award Number: 2009-D1-BX-0263 Expenditure/Obligation End Date: 12/31/2016 Liquidation End Date: 03/31/2017 Submit Your Closeout Package By Date: 03/31/2017 Closeout Status: Draft - Grantee Status Date: 02/13/2017 Date Submitted (mm/dd/yyyy) N/A File Technical Report NM Data Sets Ed Proto-type Software 5 Forensic Technique 5 Subgrant Reports Other fActions: Save Rrint Cancel https://grants.ojp.usdoj.gov/gmsexternal/closeout/loadProgrammaticReq.st?awardNumber... 2/24/2017 C O 4t w z tti U a U D O a w Us! v Win- u C • O n a ww ♦+ O U V d DII o • C V) tV O L U O €.0 a a nO S U rd a 4-4 a) In 0 U U) Grantee Name: Weld County Award Number: 2009-D1-BX-0263 O ro a) a) et) tri a) C.) (0 L c o L C a LL C_ C_ LL LL t a v Expenditure/Obligation End Date: Award Amount: $500,000.00 Liquidation End Date: 03/31/2017 Project Period Begin Date: C 0 O -C u C C o .r° U n E 0 V U 03/31/2017 Submit Your Closeout Package By Date: Project Period End Date: 12/31/2016 Draft - Grantee Closeout Status: Grant Manager: Kathy Mason rn u C rp C LL C 0 3J u C 0 a) Status Date: 02/13/2017 OJP Vendor Number: 846000813 Grant Manager Contact Information 1 Kathy Mason I :aagwnN 2698-bTS (Z0Z) auoyd > 0 0 -o 0 Q 0 OCFO Financial Contact Information For information concerning any financial aspect of your grant, contact the Office of the Chief Financial Officer, Customer Service Center by phone at 1-800-458-0786 (press 2) - Monday - Friday from 8:30 a.m. to 6:00 p.m. by email at ask.ocfo@usdol.gov C 0 in rD S > -c mra Y .. .) a) .. - E it z o W U 4-1 rti uirements Closeout Instructions in 0 U 0 a) a) O U Q c 0 C a) 4-0 X LU 4-1 U ft C 0 4i C /L V C 0 47, rp E 0 C GMS Home O a 0 J Hello