Loading...
HomeMy WebLinkAbout20123344.tiff RESOLUTION RE: APROVE BUDGET MODIFICATION TO COVERDELL FORENSIC SCIENCE IMPROVEMENT PROGRAM 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 Budget Modification to the Coverdell Forensic Science Improvement Program Grant from the County of Weld, State of Colorado, by and through the Board of County Commissioners of Weld County, on behalf of the Sheriff's Office, to the U.S. Department of Justice, commencing October 1, 2011, and ending December 31, 2012, with further terms and conditions being as stated in said budget modification, and WHEREAS, after review, the board deems it advisable to approve said budget modification, 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 Budget Modification to the Coverdell Forensic Science Improvement Grant from the County of Weld, State of Colorado by and through the Board of County Commissioners of Weld County, on behalf of the Sheriff's Office, to the U.S. Department of Justice, 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 budget modification. The above and foregoing Resolution was, on motion duly made and seconded, adopted by the following vote on the 28 ember, A.D., 2012, nunc pro tunc October 1, 2011. BOARD OF COUNTY COMMISSIONERS ELD COUNTY, COLORADO ATTEST:\-i finV.W, ♦ �� _ 691• Ca i Sean P. Co ay, Chair Weld County Clerk to the Bo- : i s�v' PV 0.ifim . Garcia, ro-Tem BY: Deputy Cle o the Board EXCUSED Barbara Kirkmeyer APP I. TcC RM: EXCUSED David E. Long n n torney �a f,,, 4g Plai.I4-9"-1--) I� �� Douglat Rademac}er ate of signature: 12- QonPr I a—le 2012-3344 SO0033 Modify Budget GAN Page 1 of 2 [01 Modify Budget GAN [o,] All Active US DEPARTMENT OF JUSTICE 0OFFICE OF JUSTICE PROGRAMS Change Requested GRANT ADJUSTMENT NOTICE Approved Grantee Information 10/01/2011 - Denied Grantee Name: Weld County Project Period: 12/31/2012 Draft Grantee Address: 915 Tenth Street Greeley, 80631 Program Office: NI) Create Grant N DUNS 07-575-7955 Grant Manager: Alan Spanbauer Nuumm eberr: Adj_ustm_ent Grantee EIN: 84-6000813 Application 2011-91563-CO-CD Number(s): Help/Freequently_Asked Vendor it: 846000813 Award Number: 2011-CD-BX-0070 Questions Project Title: Capacity enhancment-LIMS,digital media and Award Amount: $130,900.00 footwear and tire treads. Budget Modification * All editable Budget fields must contain a numeric value. Requested Changes to Categories Approved Budget Revised Budget Budget A. Personnel $10 $0 $10 B. Fringe Benefits $10 $0 $10 C. Travel $10 $0 1$10 D. Equipment $136450 $-11981 $124469 E. Supplies $149010 $6335 $155345 F. Construction $10 $0 sjo G. Contractual $10 $0 $10 H. Other $145440 $5646 $151086 TOTAL DIRECT COST $1130900 $10 $1130900 Total Direct Costs = (Sum of lines A-H) INDIRECT COST $10 $0 $10 TOTAL PROJECT COST $1130900 1d0 $1130900 Total Project Costs = Total Direct Costs + Indirect Cost Total Project Costs = Federal Funds Approved + Non-Federal Funds + Program Income FEDERAL FUNDS $1130900 $1130900 APPROVED NON-FEDERAL FUNDS $10 $0 $10 APPROVED PROGRAM INCOME $10 $0 $10 *Required Justification for Budget Modification See attached. We have reduced the equipment cost by finding cost savings on one item and purchasing components rather than purchasing a package from one vendor. Attachments: Filename: User: Timestamp: Action: 2012-3344 https://grants.ojp.usdoj.gov/gmsexternal/gan/ganFileAttachment.st 11/26/2012 Modify Budget GAN Page 2 of 2 Coverdell Competitive Grant eudaet Modification 11/26/2012 3:13 Narrative Nov 26 2012.pdf MLJorgen PM L Delete Attachment 1 Coverdell 2011 modified budget detail worksheet MLJorgen 11/26/2012 3:17 f Delete Attachment 1126z012.xlsx PM L Add Attachment Actions: Save ] Submit Delete Cancel Audit Trail: Description: Role: User: Timestamp: Note: i Draft EXTERNAL-External User MLJorgen 11/26/2012 3:12 PM View Note https://grants.ojp.usdoj.gov/gmsexternal/gan/ganFileAttachment.st 11/26/2012 2011-CD-BX-0070 Coverdell Competitive Grant Budget Modification Narrative 14 November 2012 Coverdell Competitive Grant: The majority of the funds have been spent as requested in the August of 2012. At that time the details of the new lab facility's design had not been completed. With that design now complete there is a better understanding of the laboratories layout and consequently changes to the Laboratory Information Management System are required. In order to optimize the workflow in the lab and reduce the number of PCs needed in the lab area the decision was made to secure tablets for the lab are and provide tablet docking stations at different locations in the laboratory area. These tablets will be used in the non-office areas where the analytical work is begin performed. The request is to purchase 21 Desktop PCs to be located in offices and in the evidence reception areas. In addition, the request is to purchase 10 Tablets to be placed in the 4 lab disciplines (Chemistry, Biological Sciences. Firearms, Latent prints) along with 27 docking stations and associated key boards. This will optimize the workflow within the analytical laboratory areas, improving efficiencies and reducing the turn-around on case work. In the August request we sought funds for an AVID system ($18,000). In seeking to obtain a quote and reviewing the components of the quote we determined that we would be better served to parse out the specific items needed and create a system that would be more effective at the same cost. As a result we have further optimized the options that will be available for the audio/visual examiner. These modifications will not alter the scope of the grant (capacity enhancement) but it will require changing the fund amounts on three categories: Equipment, Supplies, and Other. Finally, as the result of obtaining quotes and optimizing cost we have funds remaining on the grant. We are requesting to be allowed to purchase 4 carriers for the laptops we use in the execution of search warrants. They are designed for this type of work and allow the examiners to protect the laptops and carry them safely to and from the vehicles into the scene area. In Summary we are seeking the following changes: Salary: N/A Fringes: N/A Travel: N/A Equipment: Purchases: AudioNisual forensic station - $ 6,095.05 This is the key component in the AVID system that was part of the original request in August 2012. Supplies: Oakley Pack- $ 400 (4 packs x $100) These are to be used by the digital media examiners to transport their laptops into and out of their search warrant scenes. Desktop Computer-Monitor-keyboard - (21 x $918.22) $ 19,282.62: These workstations are to be used by the examiners and in the evidence area as part of the LIMS. Tablets - (10 x 750) $ 7,500: These tablets are to be used by the examiners within the analytical areas of the lab. Docking stations /Keyboard - (27 x $227) $ 6,129: These are to set up within the analytical areas to allow for use by the examiners as they move from station to station within the lab areas. Speaker system - $ 99.96 —The next five items are part of the A/V system to be used by the DME A/V examiner in their work. They are part of the redistribution of components from the original AVID workstation that was optimized by the DME staff. Apple TV adaptor - $ 99: See above Matroox MXOMINI - $ 499: See above MacPro Core—$ 4,599: See above Monitors - (2 x 449) $ 898: See above Angled eyepiece - $ 275: This is an additional item that will be used by the firearms examiner in his work. IT was not originally requested but as the result of savings can be purchased. Other (Software): Starwitness (Avid system substitute) - $ 4,950: The next four software packages are part of the A/V system to be used by the DME A/V examiner in their work. They are part of the redistribution of components from the original AVID workstation that was optimized by the DME staff. Microsoft window 7 - $ 315.20: See above Quicktime Pro - $ 30: See above AVID express - $ 599.00: See above Indirect Cost: N/A See Budget modification spreadsheet for details on all purchases and requested items. Northern Colorado Regional Forensic Laboratory Original 2011 Paul Coverdell Forensic Science Improvement Request Budget Worksheet PERSONNEL $0 SO Not requesting on this grant FRINGE BENEFITS $0 $0 Not requesting on this grant TRAVEL $0 $0 Not requesting on this grant TRAINING $0 $0 Not requesting on this grant EQUIPMENT Quantity Cost Total $65,000 FRED-C 1 65,000 $65,000 SUPPLIES Quantity Cost Total $50,900 Computers-Tablet 15 2,100 $31,500 Computer desktop 4 1,150 $4,600 Docking stations Port Replicator 24 200 $4,800 Scanner 4 500 $2,000 Monitors 20 350 $7,000 Bar code reader 4 250 $1,000 CONSTRUCTION $0 $0 $0 Not requesting on this grant CONSULTANT/CONTRACTORS $0 $0 Not requesting on this grant OTHER $0 $0 $15,000 SICAR 6-Shoe and Tire Software 1 15,000 $15,000 Original Request INDIRECT COSTS $0 $0 $0 None TOTAL $130,900 $130,900 SUMMARY PERSONNEL $0 FRINGE BENEFITS $0 TRAVEL $0 TRAINING $0 EQUIPMENT $65,000 SUPPLIES $50,900 CONSTRUCTION $0 CONSULTANT/CONTRACTORS $0 OTHER $15,000 INDIRECT COSTS $0 TOTAL $130,900 Budget Modification 09/2012 PERSONNEL $0 $0 Not requesting on this grant FRINGE BENEFITS $0 $0 Not requesting on this grant TRAVEL $0 $0 Not requesting on this grant TRAINING $0 $0 Not requesting on this grant EQUIPMENT Quantity Cost Total $36,450 FRED-C 0 $65,000.00 SO Audio/Visual forensic station 1 $18,000.00 $18,000 FRED-Id 1 $8,000.00 $8,000 Ninhydrin Acceleration Chamber I $10,450.00 $10,450 SUPPLIES Quantity Cost Total $49,010 Computers-"1ahlet 0 $2,100.00 $0 Computer workstations 27 $1,200.00 $32,400 Docking stations Port Replicator 0 $200.00 $0 Scanner 6 $500.00 $3,000 Monitors 0 $350.00 SO [3ar code reader 0 $250.00 $0 Macbook Pro and accessories for field work 3 $3,087.00 $9,261 Tableau USB write Blocker and reader I $354.00 $354 RAID 5 Subsystem 1 $1,500.00 $1,500 Forensic closure device STE3000FAV 1 $2,495.00 $2,495 CONSTRUCTION $0 SO $0 Not requesting on this grant CONSULTANT/CONTRACTORS $0 $0 $0 Not requesting on this grant OTHER SO $45,440 SIC'Alt 6- 'hoc and l ire Softozrc 0 $15,000.00 $0 FTK MPE 2 $7,000.00 $14,000 Win 7 for the Macbook Pro 2 $180.00 $360 Norton Security 2 $80.00 $160 Encase portable 2 $360.00 $720 CSlpix 1 $10,000.00 $10,000 VizX processing Server,twin match 4 clients I yr 1 $20,200.00 $20,200 Budget Modification 09/2012 INDIRECT COSTS $0 $0 $0 None TOTAL $130,900 $130,900 No longer seeking to purchase SUMMARY PERSONNEL $0 FRINGE BENEFITS $0 TRAVEL $0 TRAINING $0 EQUIPMENT $36,450 SUPPLIES $49,010 CONSTRUCTION $0 CONSULTANT/CONTRACTORS $0 OTHER $45,440 INDIRECT COSTS $0 TOTAL $130,900 Budget Modification 11/2012 CHANGE PERSONNEL $0 $0 Not requesting on this grant FRINGE BENEFITS $0 $0 Not requesting on this grant TRAVEL $0 $0 Not requesting on this grant TRAINING $0 $0 Not requesting on this grant EQUIPMENT Quantity Cost Total $24,469 -$11,981 FRED-C 0 $65,000.00 $0 ;Audio/Visual livensic station First request I $6.095.05 56,095 -$11,905 FRED-D 1 $7,924.00 $7,924 -$76 Ninhydrin Acceleration Chamber I $10,450.00 $10,450 $0 SUPPLIES Quantity Cost Total $55,345 $6,335 Computers-1 ahlet 10 5750.00 $7,500 Computer workstations 21 $918.22 $19,283 Docking stations Pots Replicator keyboard 27 $227.00 $6,129 Scanner 5 $522.99 $2,615 -$385 Monitors 0 $350.00 $0 liar code reader 0 $250.00 $0 Macbook Pro and accessories for field work 3 $2,922.92 $8,769 -$492 Tableau USB write Blocker and reader 1 $299.00 $299 -$55 RAID 5 Subsystem 1 $1,385.62 $1,386 -$114 Forensic closure device STE3000FAV 1 $2,495.00 $2,495 $0 Speaker system I $99.96 5100 $100 MacPRo Core 1 $4,599.00 $4.599 $4,599 Apple TV adaptor I $99.00 $99 $99 Matroox MX0MINI I $499.00 $499 $499 Monitors 2 $449.00 $898 $898 Borescope lens angled eyepiece I $275.00 5275 $275 Oakley Pack Computer carrying cases for Macbook Pro 4 $100.00 5400 $400 CONSTRUCTION $0 $0 $0 Not requesting on this grant CONSULTANT/CONTRACTORS $0 $0 $0 Not requesting on this grant OTHER $0 $51,086 $5,646 SWAP.6-Shoe and Tire Solis+are 0 $15,000.00 $0 $0 FTK MPE 2 $7,048.00 $14,096 $96 Win 7 for the Macbook Pro 2 $179.99 $360 $0 Norton Security 2 $65.82 $132 -$28 Encase portable 2 $304.22 $608 -$112 CSlpix I $9,996.00 $9,996 -$4 VizX processing Server,twin match 4 clients l yr 1 $20,000.00 $20,000 -$200 Starwitness FreezeFrame Software 1 $4.950.00 $4950 $4,950 Microsoft window 7 I 5315.23 $315 $315 Quicktime Pro 1 $29.99 $30 $30 Upgrade AVID express I 5599.00 S599 $599 Budget Modificationll/2012 INDIRECT COSTS $0 $0 $0 None TOTAL $130,900 $130,900 $0 No longer seeking to purchase $1,799.00 SUMMARY Sep-12 Nov-12 Difference PERSONNEL $0 $0 $0 FRINGE BENEFITS $0 $0 $0 TRAVEL SO $0 $0 TRAINING $0 $0 $0 EQUIPMENT $36,450 $24,469 -$11,981 SUPPLIES $49,010 $55,345 $6,335 CONSTRUCTION $0 $0 $0 CONSULTANT/CONTRACTORS $0 $0 $0 OTHER $45,440 $51,086 $5,646 INDIRECT COSTS $0 $0 $0 TOTAL $130,900 $130,900 $0 Grant Adjustments - All Active GANs Page 1 of 1 [ Grant Adjustments -All Active GANs a All Active GAN Multiple Program Project Date Change Requested ID Type Awards Office Status Award Number Title Submitted Approved Capacity enhancment- Denied LIMS, digital 349331 Bud o No ND Submitted 2011-CD-BX-0070 dmedia and 11/29/2012 MDraft — footwear and tire treads. Create Grant Adiustment R Recovery Act Help/Frequently Asked Questions 6C�A.c>7i" /,Lind-6- _ GMS Home _y., v- 'c.1 or— 7/49/2.:1/4-2_ Loci Off https://grants.ojp.usdoj.gov/gmsexternal/gan/budgetModifyGAN.st 11/29/2012 Esther Gesick From: Ronald Arndt Sent: Friday, November 30, 2012 12:55 PM To: Esther Gesick Subject: FW: Budget Modification GAN has been Approved FYI That was a quick response back from them. Thanks for your help Ronald Arndt NCRFL Director Weld County Sheriff 1950 "0" Street Greeley, CO 80631 970.356.4015 x 3638 CP 970.590.1902 Fax 970.304.6447 Confidentiality Notice: This electronic transmission and any attached documents or other writings are intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. If you have received this communication in error, please immediately notify sender by return e-mail and destroy the communication. Any disclosure, copying, distribution or the taking of any action concerning the contents of this communication or any attachments by anyone other than the named recipient is strictly prohibited. Original Message From: donot-replyOoip.usdoj.gov [mailto:donot-reply(toip.usdoj.gov] Sent: Friday, November 30, 2012 11:52 AM To: Ronald Arndt Subject: Budget Modification GAN has been Approved The request for Budget Modification GAN for 2011-CD-BX-0070 has been approved. Please access GMS for more information regarding GAN Number 005. 1 Hello