06-30-06 PCIE Katrina Master template.xls

All Other Agenc 10th PCIE Hurricane Katrina Report: To Date As of 06-30-06 DOE(3) TREAS TOTAL TIGTA CNCS USDA NASA USPS Section 01. OIG STAFF ASSIGNED A. Full-Time Equivalent 1. Administrative 2. Auditors 3. Consultants/Contractors 4. Inspectors 5. Investigators 6. Other (e.g. Technical, Specialists) 0.50 Total 0.50 5.00 58.00 4.00 28.00 95.00 1.00 1.00 127.00 3.00 9.00 136.00 3.00 6.50 1.25 7.75 3.50 0.50 4.00 20.00 68.00 14.00 102.00 8.00 24.50 2.00 1.00 10.00 25.50 3.50 4.00 7.50 4.75 1.00 5.75 19.00 8.00 27.00 2.00 5.00 9.00 6.00 22.00 1.00 8.00 9.00 2.00 1.00 11.00 10.00 3.00 27.00 2.00 8.00 11.00 27.00 2.00 45.00 5.00 50.00 28.00 7.00 3.00 38.00 8.00 1.00 9.00 6.50 383.75 3.00 8.00 70.75 9.00 481.00 5.00 58.00 4.00 28.00 95.00 1.50 325.75 (1.00) 8.00 42.75 9.00 386.00 6.50 383.75 3.00 8.00 70.75 9.00 481.00 Section 02. CONTRACT: AGENCY ACTIONS A. # Contracts Awarded 1. <= $500K 2. > $500K (1) a. Full and Open Competition b. "Limited" Competition c. No Bid/Sole Source d. Other Sub-Total of > $500K (1) Total # Contracts Awarded B. $ Value Contracts Awarded (in thousands) - 3,203 160 1 391 218 770 3,973 - - - 670 11 2 11 24 694 - 50 3 3 6 56 4 56 7 2 6 15 71 - 191 76 13 89 280 1,592 42 19 151 12 224 1,816 161 22 7 29 190 - 11 26 6 2 8 34 - 13 1 1 14 - 19 - 403 51 1 4 56 459 24 2 3 5 29 - 6,419 378 31 592 236 1,237 7,662 see DoD comments - 2 2 6 4 3 3 10 21 19 3,203 0 160 1 391 218 770 3,973 3,216 0 218 30 201 18 467 3,689 (in thousands) 1. <= $500K 2. > $500K (1) $$Total $ Value of Contracts Awarded $ - $ 256,657 $ 6,109,893 $ 6,366,550 $ 5,300 $ 1,200 $ 6,500 $ $ $ 94,568 2,460,066 2,554,634 $$$- $ 17,330 $ 28,616 $ 45,946 $ 2,383 $ 9,991 $ 12,374 $ 2,712 $ 2,048 $ 4,760 $ 7,592 $ 355,616 $ 363,208 $ $ $ - $ 14,161 $ 261,194 $ 275,355 $ 80,713 $ 548,474 $ 629,187 $ 14,061 $ 82,160 $ 96,221 $ 1,060 $ 18,325 $ 19,385 $ 4,596 $ 127,015 $ 131,611 $$$- $ 1,454 $ 600 $ 2,054 $ 356 $ $ 356 $$$- $ 42,798 $ 83,605 $ 126,403 $ 2,176 $ 6,173 $ 8,349 $ $ $ - $ 547,917 $ 10,094,976 $ 10,642,893 256,657 291,260 547,917 6,109,893 3,985,083 10,094,976 6,366,550 4,276,343 10,642,893 Section 03. CONTRACT: OIG REVIEWS A. # Of Contract Reviews 1. In-Process 2. Completed Total B. $ Value of Reviews (in thousands) 1. In-Process 2. Completed 63 105 168 1 1 10 1 11 1 1 6 6 1 1 2 134 136 182 182 63 9 72 2 1 3 11 22 33 3 3 1 1 341 277 618 (in thousands) 63 105 168 278 172 450 Total 6,419 0 378 31 592 236 1,237 7,662 341 277 618 5,562,128 2,792,224 8,354,352 83,740 0 20 5 0 22 12 0 55 24 0 42 26 0 24 12 0 71 30 33 83 DOC DOD GSA HUD DOL DOT DHS HHS $$Total $ - $ 2,472,995 $ 1,218,558 $ 3,691,553 $ 6,500 $ $ 6,500 $ $ $ 2,438,733 249,000 2,687,733 $$$- $ $ $ - $ $ 5,180 $ 5,180 $ 4,760 $ $ 4,760 $ $ 238,036 $ 238,036 $ $ $ - $ 981 $ 258,428 $ 259,409 $ 542,550 $ $ 542,550 $ 66,466 $ 26,216 $ 92,682 $ 17,900 $ 1,100 $ 19,000 $ 11,243 $ 77,917 $ 89,160 $$$- $ $ $ - $ $ $ - $$$- $ $ $ - $ $ 8,349 $ 8,349 $ $ 709,440 $ 709,440 $ $ $ 5,562,128 2,792,224 8,354,352 2,472,995 3,089,133 1,218,558 1,573,666 3,691,553 4,662,799 Section 04. PURCHASE CARD: AGENCY TRANSACTIONS (in thousands) A. Total $ spent to date (in thousands) $- $ 22,687 $ 289 see DoD comments $- $ 24,475 $ 8,228 $ 488 $ 816 $ - $ 1,480 $ 107 $ 2,201 $ - $ 135 $- $ 224 $ 79 $- $ 20,601 $ 1,930 $ - $ 83,740 22,687 DHS SBA DOJ EPA SSA DOI ED VA 61,053 Section 05. PURCHASE CARD: OIG REVIEWS A. % of PCard Transaction $s reviewed to date 0% 100% 0% see DoD comments - 0% 46% 0% 0% 0% 50% 0% 0% 0% 91% 0% 0% 0% 0% 0% 100% 0% Section 06. NON-CONTRACT: OIG REVIEWS A. # Grant Reviews 1. In-Process 2. Completed B. # Mission Assignment Reviews 1. In-Process 2. Completed C. # Other Non- Contract Reviews 1. In-Process 2. Completed 1 22 21 2 16 6 1 3 12 1 1 1 1 10 3 3 4 4 2 4 1 1 10 1 3 1 1 1 3 5 5 4 1 2 8 2 1 9 4 12 1 1 7 3 42 26 24 12 71 30 0 22 21 0 2 0 0 16 6 Section 07. OIG REPORTING A. # Reports Issued 44 1 2 7 3 4 2 9 5 77 50 All Other Agenc 10th PCIE Hurricane Katrina Report: To Date As of 06-30-06 DOE(3) TREAS TOTAL TIGTA CNCS USDA NASA USPS B. Reported $ Value (in thousands) 1. Questioned Costs (a). Unsupported Costs 2. Funds Put to Better Use (in thousands) $$$- $ $ $ 13,966 75,670 $ $ $ - $ $ $ - $$$- $ $ $ - $ $ $ - $ $ $ - $ $ 33,292 $ - $ $ $ - $ $ $ - $ $ $ - $ $ $ - $ $ $ 79 - $ $ $ - $$$- $ $ $ - $ $ $ - $$$- $ $ $ - $ $ $ - $ $ $ - $ $ $ 14,045 33,292 75,670 13,966 0 75,670 79 33,292 0 14,045 33,292 75,670 Section 08. OIG CONGRESSIONAL RESPONSES A. # Congressionals Received B. # OIG Congressional Responses 1. In-Process 2. Completed 23 7 16 9 5 1 1 1 1 1 1 1 1 1 1 37 13 20 23 7 16 14 6 4 37 13 20 Section 09. OIG INVESTIGATIVE STATISTICS A. # Hotline Complaints (2) B. # Cases Opened C. # Arrests D. # Indictments E. # Convictions 6,205 979 189 223 60 2 1 9,664 7 1 2 2 1 6 13 234 22 29 9 1 18 2 3 1 7 8 2 4 17 89 40 6 6 2 11 5 2 15 8 25 44 9 14 3 3 1 1 1 2 2 1 1 5 11 2 4 1 50 3 16,082 1,395 239 283 80 6,205 979 189 223 60 9,877 416 50 60 20 16,082 1,395 239 283 80 LEGEND: ( 1 ) DOD = over $1 million ( 2 ) DOD = # complaints received on Katrina Hotline; ( 3 ) DOE = To date, DOE has received only a small portion of the funds allocated for hurricane relief-related activities. Future efforts of the OIG will Total DOC DOD GSA HUD DOL DOT DHS HHS DHS SBA DOJ EPA SSA DOI ED VA