Inventory tracking is required for the DHS grants. Inventory must be maintained from the initial purchase through 3 years following the close of the grant period. 

 

Arkansas Department of Emergency Management

Your Partner in Preparedness

To download a copy of the inventory click on this link.

·  Save the inventory somewhere easily accessible to your computer

1. When the form has opened click on file

2. Click “save as”

3. Close the web browser

4. Open the inventory you just saved to your computer

The first page seen on the spreadsheet is called the totals page.

1. The first task is to add your grant amount to the Total Allocated row under the proper grant name (this can be found on your award letter)

2. You now can navigate to each spreadsheet by either clicking the grant name above the allocated amount or clicking on the appropriate tab at the bottom, (if you do not see any tabs you will need to maximize the window)

All of the spreadsheets are similar but are not identical, to better help you with filling in the proper information each column header has a help section at the top, simply run your curser over the red triangle and a help message will appear

To standardize the process some columns can only be filled in by the drop down box, you can active this by clicking on the cell and then clicking the down arrow on the right side and selecting the proper item.

 

As spreadsheets are filled out you will be able to see your progress on the Totals table, in which all the amounts for each grant will automatically add together. You should match the amounts to your own accounting recorded to ensure that your inventory matches up with your paper work

Updated inventory spreadsheets will need to be submitted to ADEM at least bi-annually (by July 31 and January 31); however you may submit more often as changes occur.  Please submit these spreadsheets to ADEM via email.   This will provide for duplicate records of your inventory, your copy to be maintained at the county level and ours maintained for all jurisdictions here at ADEM.

 

When sending this document to ADEM please put “Inventory for (your jurisdiction)” in the subject line and send it to kathy.hedrick@adem.arkansas.gov Any questions concerning the inventory may be directed to Kathy Hedrick at (501) 683-6700.

 

Thank you

When updates to the inventory are made we will send out an email informing all Grant Points of Contact of the change.

1. You will need to open the updating spreadsheet by clicking the update button below, (Enable Macros) and follow the directions

 

· Any request for password will be “ADEM”

· When the version update has completed you will see the header on the Totals page change to match the new version number indicated at the top of this page