For Appropriation/Expenditure Report pursuant to 5 GCA §10306
Government of Guam
(2017 2nd Qtr) Appropriation/Expenditure Report
(Run Date July 25, 2017)
 
DEPARTMENT OF PUBLIC WORKS
Fund Object Category Appropriations YTD Allotment Expenditures Outstanding Encumbrances Funds Available Unalloted Balance
GENERAL FUND REGULAR SALARY 4,682,429.00 2,341,209.00 1,875,088.48 0.00 466,120.52 2,341,220.00
OVERTIME SALARY 0.00 0.00 1,173.25 0.00 -1,173.25 0.00
FRINGE 1,897,815.00 952,406.00 677,778.77 0.00 274,627.23 945,409.00
TRAVEL 18,716.00 18,716.00 12,755.95 1,729.00 4,231.05 0.00
CONTRACT 382,024.41 245,229.39 42,630.49 121,072.69 81,526.21 136,795.02
SUPPLIES 126,992.38 74,465.07 26,267.61 37,355.02 10,842.44 52,527.31
EQUIPMENT 86,738.00 37,046.00 37,046.00 0.00 0.00 49,692.00
DRUG TESTING CHARGES 40.00 40.00 40.00 0.00 0.00 0.00
POWER UTILITY 141,549.62 121,328.62 44,687.74 66,202.75 10,438.13 20,221.00
WATER UTILITY 194,991.57 173,076.57 57,875.10 66,308.90 48,892.57 21,915.00
TELEPHONE 36,801.42 31,536.42 13,970.80 2,112.50 15,453.12 5,265.00
CAPITAL 449,529.98 420,475.53 36,675.53 383,800.00 0.00 29,054.45
GENERAL FUND Fund Totals: 8,017,627.38 4,415,528.60 2,825,989.72 678,580.86 910,958.02 3,602,098.78
FEDERAL GRANT FUND REGULAR SALARY 1,878,760.59 1,877,754.42 438,236.10 0.00 1,439,518.32 1,006.17
OVERTIME SALARY 67,732.84 62,168.39 13,354.56 0.00 48,813.83 5,564.45
FRINGE 640,498.08 638,485.26 161,323.03 0.00 477,162.23 2,012.82
TRAVEL 202,168.38 202,168.38 61,870.99 19,050.06 121,247.33 0.00
CONTRACT 123,386,951.16 123,386,177.03 4,635,313.68 31,502,074.43 87,248,788.92 774.13
CONTRACT SV 0.00 0.00 0.00 0.00 0.00 0.00
SUPPLIES 313,697.13 313,697.13 1,746.80 28,811.44 283,138.89 0.00
EQUIPMENT 178,221.30 178,221.30 6,490.90 16,748.52 154,981.88 0.00
DRUG TESTING CHARGES 60.00 60.00 0.00 0.00 60.00 0.00
SUB-RECIPIENT/GRANTS 4,482.54 4,482.54 0.00 4,482.54 0.00 0.00
MISCELLANEOUS 6,741,450.00 6,741,450.00 6,665,250.00 76,200.00 0.00 0.00
TELEPHONE 48,277.10 48,164.25 1,671.45 13,325.97 33,166.83 112.85
CAPITAL 4,826,850.77 4,826,850.77 2,015,744.48 0.00 2,811,106.29 0.00
FORCE EQUIPMENT ALLOWANCE-FEMA 4,087.00 0.00 0.00 0.00 0.00 4,087.00
FEDERAL GRANT FUND Fund Totals: 138,293,236.89 138,279,679.47 14,001,001.99 31,660,692.96 92,617,984.52 13,557.42
STREET LIGHT FUND REGULAR SALARY 0.00 0.00 0.00 0.00 0.00 0.00
OVERTIME SALARY 0.00 0.00 0.00 0.00 0.00 0.00
FRINGE 0.00 0.00 0.00 0.00 0.00 0.00
CONTRACT 8,207.31 8,207.31 0.00 0.00 8,207.31 0.00
SUPPLIES 0.00 0.00 0.00 0.00 0.00 0.00
EQUIPMENT 0.00 0.00 0.00 0.00 0.00 0.00
CAPITAL 0.00 0.00 0.00 0.00 0.00 0.00
STREET LIGHT FUND Fund Totals: 8,207.31 8,207.31 0.00 0.00 8,207.31 0.00
TERRITORIAL EDUCATION FACILITY REGULAR SALARY 0.00 0.00 0.00 0.00 0.00 0.00
OVERTIME SALARY 30,000.00 0.00 0.00 0.00 0.00 30,000.00
FRINGE 9,009.00 0.00 0.00 0.00 0.00 9,009.00
SUPPLIES 65,000.00 0.00 0.00 0.00 0.00 65,000.00
EQUIPMENT 12,433.34 0.00 0.00 0.00 0.00 12,433.34
TERRITORIAL EDUCATION FACILITY Fund Totals: 116,442.34 0.00 0.00 0.00 0.00 116,442.34
TOURIST ATTRACTION REGULAR SALARY 53,307.91 53,307.91 0.00 0.00 53,307.91 0.00
OVERTIME SALARY 8,002.32 8,002.32 0.00 0.00 8,002.32 0.00
FRINGE 6,952.82 6,952.82 0.00 0.00 6,952.82 0.00
SUPPLIES 726.83 726.83 0.00 0.00 726.83 0.00
POWER UTILITY 0.51 0.51 0.00 0.00 0.51 0.00
TOURIST ATTRACTION Fund Totals: 68,990.39 68,990.39 0.00 0.00 68,990.39 0.00
TERRITORIAL HIGHWY REGULAR SALARY 6,159,042.01 3,100,407.01 2,635,019.37 0.00 465,387.64 3,058,635.00
OVERTIME SALARY 289,347.45 236,696.45 74,282.31 0.00 162,414.14 52,651.00
FRINGE 2,746,954.95 1,410,371.95 1,014,726.90 0.00 395,645.05 1,336,583.00
TRAVEL 44,400.94 44,400.94 8,354.90 2,727.30 33,318.74 0.00
CONTRACT 3,633,492.79 3,618,492.79 204,170.54 693,693.32 2,720,628.93 15,000.00
SUPPLIES 1,782,472.94 1,228,543.15 534,907.33 269,380.18 424,255.64 553,929.79
EQUIPMENT 62,667.78 25,799.38 3,349.99 16,985.93 5,463.46 36,868.40
WORKERS COMP BENEFITS 1,500.00 1,387.00 0.00 0.00 1,387.00 113.00
DRUG TESTING CHARGES 1,395.00 1,357.00 200.00 0.00 1,157.00 38.00
POWER UTILITY 448,323.93 401,823.93 96,260.38 167,239.62 138,323.93 46,500.00
TELEPHONE 27,304.62 25,459.62 5,430.55 431.17 19,597.90 1,845.00
CAPITAL 1,222,449.00 1,172,648.00 180,967.00 512,850.00 478,831.00 49,801.00
TERRITORIAL HIGHWY Fund Totals: 16,419,351.41 11,267,387.22 4,757,669.27 1,663,307.52 4,846,410.43 5,151,964.19
GUAM CONTRACTORS REGULAR SALARY 403,345.00 197,483.00 166,803.48 0.00 30,679.52 205,862.00
FRINGE 146,207.00 72,891.00 60,513.86 0.00 12,377.14 73,316.00
TRAVEL 20,704.00 0.00 0.00 0.00 0.00 20,704.00
CONTRACT 171,408.88 171,408.88 6,446.64 60,479.02 104,483.22 0.00
SUPPLIES 99,249.14 21,197.14 2,694.77 2,938.29 15,564.08 78,052.00
EQUIPMENT 45,186.10 1,786.10 1,786.10 0.00 0.00 43,400.00
DRUG TESTING CHARGES 400.00 400.00 0.00 0.00 400.00 0.00
MISCELLANEOUS 11,016.08 11,016.08 369.53 2,846.55 7,800.00 0.00
POWER UTILITY 25,000.00 25,000.00 4,636.84 0.00 20,363.16 0.00
TELEPHONE 10,106.62 10,106.62 2,351.43 1,969.29 5,785.90 0.00
CAPITAL 0.00 0.00 0.00 0.00 0.00 0.00
GUAM CONTRACTORS Fund Totals: 932,622.82 511,288.82 245,602.65 68,233.15 197,453.02 421,334.00
P.E.A.L.S. FUND REGULAR SALARY 141,536.00 70,169.00 64,644.40 0.00 5,524.60 71,367.00
FRINGE 51,766.00 25,883.00 22,547.91 0.00 3,335.09 25,883.00
CONTRACT 121,702.86 103,191.86 14,112.08 40,859.45 48,220.33 18,511.00
BLDG RENT 34,469.00 19,519.00 10,488.33 9,030.00 0.67 14,950.00
SUPPLIES 1,638.34 1,638.34 417.19 900.00 321.15 0.00
EQUIPMENT 2,543.00 2,543.00 2,543.00 0.00 0.00 0.00
DRUG TESTING CHARGES 120.00 120.00 0.00 0.00 120.00 0.00
MISCELLANEOUS 2,403.54 2,003.54 649.57 500.43 853.54 400.00
TELEPHONE 2,500.00 2,100.00 1,053.06 312.71 734.23 400.00
P.E.A.L.S. FUND Fund Totals: 358,678.74 227,167.74 116,455.54 51,602.59 59,109.61 131,511.00
DPW BUILDING & DESIGN FUND REGULAR SALARY 584,842.72 584,842.72 190,508.30 0.00 394,334.42 0.00
OVERTIME SALARY 0.00 0.00 0.00 0.00 0.00 0.00
FRINGE 178,635.90 178,635.90 35,147.99 0.00 143,487.91 0.00
TRAVEL 11,000.00 11,000.00 0.00 0.00 11,000.00 0.00
CONTRACT 53,657.77 53,657.77 4,949.04 17,127.29 31,581.44 0.00
SUPPLIES 28,121.04 28,121.04 4,654.54 2,925.00 20,541.50 0.00
EQUIPMENT 3,013.03 3,013.03 312.00 434.00 2,267.03 0.00
WORKERS COMP BENEFITS 0.00 0.00 0.00 0.00 0.00 0.00
DRUG TESTING CHARGES 320.00 320.00 0.00 0.00 320.00 0.00
POWER UTILITY 15,000.00 15,000.00 4,296.77 10,703.23 0.00 0.00
TELEPHONE 8,781.22 8,781.22 1,177.53 730.55 6,873.14 0.00
CAPITAL 36,970.00 36,970.00 36,970.00 0.00 0.00 0.00
DPW BUILDING & DESIGN FUND Fund Totals: 920,341.68 920,341.68 278,016.17 31,920.07 610,405.44 0.00
INFRAST IMPRVMT BOND '97 - CPF CONTRACT 91,948.59 91,948.59 0.00 91,948.59 0.00 0.00
INFRAST IMPRVMT BOND '97 - CPF Fund Totals: 91,948.59 91,948.59 0.00 91,948.59 0.00 0.00
LANDFILL CLOSING/OPENING COSTS CONTRACT 1,962,200.00 1,962,200.00 245,702.09 1,915,598.96 -199,101.05 0.00
SUPPLIES 1,340,414.62 1,340,414.62 0.00 0.00 1,340,414.62 0.00
EQUIPMENT 40,000.00 40,000.00 0.00 0.00 40,000.00 0.00
CAPITAL 189,624.75 189,624.75 152,800.00 0.00 36,824.75 0.00
LANDFILL CLOSING/OPENING COSTS Fund Totals: 3,532,239.37 3,532,239.37 398,502.09 1,915,598.96 1,218,138.32 0.00
SOLID WASTE OPERATIONS FUND CONTRACT 0.00 0.00 2,907,329.21 2,628,228.88 -5,535,558.09 0.00
SUPPLIES 0.00 0.00 0.00 90,090.00 -90,090.00 0.00
EQUIPMENT 0.00 0.00 0.00 0.00 0.00 0.00
CAPITAL 0.00 0.00 0.00 121,800.00 -121,800.00 0.00
SOLID WASTE OPERATIONS FUND Fund Totals: 0.00 0.00 2,907,329.21 2,840,118.88 -5,747,448.09 0.00
RECYCLING REVOLVING FUND CONTRACT 50,452.00 50,452.00 0.00 18,006.00 32,446.00 0.00
RECYCLING REVOLVING FUND Fund Totals: 50,452.00 50,452.00 0.00 18,006.00 32,446.00 0.00
SAR-SUPPLEMENTL APPROP REVENUE CONTRACT 0.00 0.00 0.00 0.00 0.00 0.00
SAR-SUPPLEMENTL APPROP REVENUE Fund Totals: 0.00 0.00 0.00 0.00 0.00 0.00
HOTEL OCCUPANCY TAX SURPLUS REGULAR SALARY 0.00 0.00 0.00 0.00 0.00 0.00
OVERTIME SALARY 0.00 0.00 0.00 0.00 0.00 0.00
FRINGE 0.00 0.00 0.00 0.00 0.00 0.00
SUPPLIES 0.00 0.00 0.00 0.00 0.00 0.00
POWER UTILITY 0.00 0.00 0.00 0.00 0.00 0.00
HOTEL OCCUPANCY TAX SURPLUS Fund Totals: 0.00 0.00 0.00 0.00 0.00 0.00
DEPARTMENT OF PUBLIC WORKS TOTALS: 168,810,138.92 159,373,231.19 25,530,566.64 39,020,009.58 94,822,654.97 9,436,907.73
 
 
  Appropriations YTD Allotment Expenditures Outstanding Encumbrances Funds Available Unalloted Balance
GRAND TOTALS: 168,810,138.92 159,373,231.19 25,530,566.64 39,020,009.58 94,822,654.97 9,436,907.73


*** Data contained herein are subject to change, as additional reconciliations are performed. ***