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