Loading...
HomeMy WebLinkAboutCOM 0871.000 2018-2020 Harry Kim. ••oJ�!`.Y°,`~'!!rte Deanna S. Sako Mayor •" ,4,14'�' Director Steven A. Hunt Deputy Director qtE Op MP'� •'• County of Hawai 1 Finance Department 25 Aupuni Street,Suite 2103 • Hilo,Hawaii 96720 (808)961-8234 • Fax(808)961-8569 April 2,2020 -, - Aaron Chung, Council Chair and Members of the Hawai`i County Council f4-,) Hawai`i County Council 25 Aupuni Street =+_ Hilo, Hawaii 96720 Re: Resolution Transferring Funds Enclosed is a resolution transferring the remaining $4,158,221 out and from the Finance Admin& Budget Salaries and Wages account and crediting it to various Department's Salaries and Wages accounts. Ordinance 19-73 approved appropriations for overtime salary and wages for various County Departments within the Finance Admin& Budget Salaries and Wages account. The enclosed resolution is for overtime costs associated with the third and fourth quarters of FY 2019-20. We request that this resolution be waived from the Finance Committee and be placed on the April 22, 2020 Council agenda in order to expedite the transfer of these funds. If there are any questions, please do not hesitate to call me at 961-8092. Deanna S. Sako Director of Finance Enc. c: All County Departments and Agencies ,e 5. s �- .o Comm. No. . o D Ref.To:k•L. . 117 0111 Ref. Date FA Hawai'i County is an Equal Opportunity Employer and Provider Funds Moved Transfer-1 Transfer-2 Transfer-3 3rd Dept Total Variance From Depts to 1/4 Allotment 1st Quarter 2nd Quarter 3rd Quarter TOTAL OT First Second &4th Funds Transferred vs Department Account No. Account Description `"- ce Amount OT Expended OT Expended OT Expended Expended\"TD Quarter Quarter Quarters Transferred Expended Balance Clerk-Council 010.101.5101.01 021 Clerk-CouncifSvc S&W,Overtime S&W (20,(9 5,000.00 1,593.15 989.09 1,442.79 4,025.03 5,000.00 5,000.00 10,000.00 20,000.00 15,974.97 0.00 010.107.5107.01 021 Election Division-S&W,Overtime S&W i 6,; 16,875.00 3,382.01 1,419.18 5,058.19 9,859.38 16,875.00 16,875.00 33,750.00 67,500.00 57,640.62 0.00 Information Tech S&W 010.118.5118.01 021 Information Tech S&W,Overtime S&W (12.000) 3,000.00 3,391.18 1,502.08 9,267.31 14,160.57 3,000.00 3,000.00 6,000.00 12,000.00 -2,160.57 0.00 Finance S&W *RES()not needed for Finance transfers-Complete Request to Transfer Funds 010.121.5122.01 021 Accounts-S&W,Overtime S&W (9,000) 2,250.00 5,590.36 3,737.80 3,857.42 13,185.58 2,250.00 2,250.00 4,500.00 9,000.00 -4,185.58 0.00 010.121.5123.01 021 Purchasing S&W,Overtime S&W (100) 25.00 287.45 0.00 0.00 287.45 25.00 25.00 50.00 100.00 -187.45 0.00 010.121.5124.01 021 Treasury-S&W,Overtime S&W (1.000) 250.00 1,790.25 870.72 5,558.64 8,219.61 250.00 250.00 500.00 1,000.00 -7,219.61 0.00 010.121.5125.01 021 Real Property Tax-S&W,Overtime S&W (3,000) 750.00 1,720.00 1,030.11 4,769.73 7,519.84 750.00 750.00 1,500.00 3,000.00 -4,519.84 0.00 010.121.5127.11 021 Vehicle Regist S&W,Overtime S&W (3,832) 958.00 3,088.07 2,181.14 3,246.88 8,516.09 958.00 958.00 1,916.00 3,832.00 -4,684.09 0.00 010.121.5127.21 021 Driver License S&W,Overtime S&W (3,833) 958.25 0.00 7.85 56.52 64.37 958.25 958.25 1,916.50 3,833.00 3,768.63 0.00 010.121.5127.31 021 PMVI Pgm S&W,Overtime S&W (200) 50.00 452.53 0.00 0.00 452.53 50.00 50.00 100.00 200.00 -252.53 0.00 010.121.5127.41 021 Comm Driv Lic Prog S&W,Overtime S&W (2,000) 500.00 0.00 414.41 12.90 427.31 500.00 500.00 1,000.00 2,000.00 1,572.69 0.00 010.121.5128.01 021 Risk Management S&W,Overtime S&W (100) 25.00 0.00 0.00 0.00 0.00 25.00 25.00 50.00 100.00 100.00 0.00 010.121.5129.01 021 Property Mgmt S&W,Overtime S&W (100) 25.00 0.00 0.00 0.00 0.00 25.00 25.00 50.00 100.00 100.00 0.00 Corporation Counsel S&W 010.131.5131.01 021 Corporation Counsel S&W,Overtime S&W (1,500) 375.00 0.00 0.00 258.79 258.79 375.00 375.00 750.00 1,500.00 1,241.21 0.00 Planning S&W 010.141.5141.01 021 Planning S&W,Overtime S&W (32,000) 8,000.00 62,203.31 90,743.68 72,116.01 225,063.00 8,000.00 8,000.00 16,000.00 32,000.00 -193,063.00 0.00 010.141.5141.34 021 Coastal Zone Mgmt,Overtime S&W (19,320) 4,830.00 3,028.29 3,888.11 1,448.03 8,364.43 4,830.00 4,830.00 9,660.00 19,320.00 10,955.57 0.00 Human Resources S&W 010.151.5151.01 021 Human Resources S&W,Overtime S&W (3.075) 768.75 762.06 799.59 1,122.13 2,683.78 768.75 768.75 1,537.50 3,075.00 391.22 0.00 Public Works S&W 010.171.5171.01 021 General Services S&W,Overtime S&W (1,425) 356.25 2,341.26 21.36 2,838.54 5,201.16 356.25 356.25 712.50 1,425.00 -3,776.16 0.00 010.171.5171.21 021 Building R&M S&W,Overtime S&W (475) 118.75 0.00 0.00 148.86 148.86 118.75 118.75 237.50 475.00 326.14 0.00 010.173.5173.01 021 Public Works Admin S&W,Overtime S&W (1,000) 250.00 0.00 6,125.54 257.94 6,383.48 250.00 250.00 500.00 1,000.00 -5,383.48 0.00 010.181.5181.51 021 Automotive Division S&W,Overtime S&W (6,100) 1,525.00 11,405.65 2,569.24 8,933.35 22,908.24 1,525.00 1,525.00 3,050.00 6,100.00 -16,808.24 0.00 010.183.5183.01 021 Engineering Division S&W,Overtime S&W (1,000) 250.00 21,550.03 3,728.28 2,468.80 27,747.11 250.00 250.00 500.00 1,000.00 -26,747.11 0.00 010.231.5231.01 021 Constr Inspectn S&W,Overtime S&W (20,600) 5,150.00 1,269.84 339.36 1,404.52 3,013.72 5,150.00 5,150.00 10,300.00 20,600.00 17,586.28 0.00 010.231.5232.01 021 Bldg Inspctn S&W,Overtime S&W (6,650) 1,662.50 6,391.30_ 14,376.81 2,280.46 23,048.57 1,662.50 1,662.50 3,325.00 6,650.00 -16,398.57 0.00 Funds Moved Transfer-1 Transfer-2 Transfer-3 3rd Dept Total Variance From Depts to 1/4 Allotment 1st Quarter 2nd Quarter 3rd Quarter TOTAL OT First Second &4th Funds Transferred vs Department Account No. Account Description Finance Amount OT Expended OT Expended OT Expended Expended YTD Quarter Quarter Quarters Transferred Expended Balance Police S&W 010.201.5201.01 021 Police Commission S&W,Overtime S&W (1,000) 250.00 101.92 159.00 248.70 509.62 250.00 250.00 500.00 1,000.00 490.38 0.00 010.201.5202.01 021 Police Hdqtrs.-S&W,Overtime S&W (800) 200.00 0.00 67.02 0.00 67.02 200.00 200.00 400.00 800.00 732.98 0.00 010.201.5203.51 021 Admin Sew S&W,Overtime S&W (137,950) 34,487.50 224,629.12 84,862.99 48,007.95 357,500.06 34,487.50 34,487.50 68,975.00 137,950.00 -219,550.06 0.00 010.201.5203.61 021 Technical Sery S&W,Overtime S&W (64,970) 16,242.50 9,518.85 12,721.18 9,664.46 31,904.49 16,242.50 16,242.50 32,485.00 64,970.00 33,065.51 0.00 010.201.5203.71 021 Traf Svc S&W,Overtime S&W (979) 244.75 0.00 0.00 0.00 0.00 244.75 244.75 489.50 979.00 979.00 0.00 010.201.5203.81 021 Dispatch S&W,Overtime S&W (311,945) 77,986.25 173,410.99 150,834.39 118,134.98 442,380.36 77,986.25 77,986.25 155,972.50 311,945.00 -130,435.36 0.00 010.201.5205.01 021 Criminal Intell Unit S&W,Overtime S&W (12,460) 3,115.00 88,821.24 28,734.59 1,735.65 119,291.48 3,115.00 3,115.00 6,230.00 12,460.00 -106,831.48 0.00 010.201.5206.01 021 C1D-JAB-VICE-S&W,Overtime S&W (174,555) 43,638.75 328,370.66 122,117.84 100,826.18 551,314.68 43,638.75 43,638.75 87,277.50 174,555.00 -376,759.68 0.00 010.201.5207.01 021 So Hilo Police-S&W,Overtime S&W (349,566) 87,391.50 1,111,049.35 439,445.01 376,116.82 1,926,611.18 87,391.50 87,391.50 174,783.00 349,566.00 -1,577,045.18 0.00 010.201.5209.01 021 Hamakua Police-S&W,Overtime S&W (115,530) 28,882.50 324,036.27 116,235.97 124,443.83 564,716.07 28,882.50 28,882.50 57,765.00 115,530.00 -449,186.07 0.00 010.201.5210.01 021 Waimea Police-S&W,Overtime S&W (149,100) 37,275.00 308,546.98 110,723.32 75,574.13 494,844.43 37,275.00 37,275.00 74,550.00 149,100.00 -345,744.43 0.00 010.201.5211.01 021 Kohala Police S&W,Overtime S&W (59,540) 14,885.00 137,171.81 61,540.25 50,268.46 248,980.52 14,885.00 14,885.00 29,770.00 59,540.00 -189,440.52 0.00 010.201.5212.01 021 Kona Police-S&W,Overtime S&W (336,012) 84,003.00 635,774.19 280,507.24 318,492.95 1,234,774.38 84,003.00 84,003.00 168,006.00 336,012.00 -898,762.38 0.00 010.201.5212.21 021 Kona Police CID-S&W,Overtime S&W (103,500) 25,875.00 393,522.99 113,969.39 52,415.40 559,907.78 25,875.00 25,875.00 51,750.00 103,500.00 -456,407.78 0.00 010.201.5213.01 021 Ka'u Police S&W,Overtime S&W (92,560) 23,140.00 158,179.97 47,437.40 33,366.80 238,984.17 23,140.00 23,140.00 46,280.00 92,560.00 -146,424.17 0.00 010.201.5214.01 021 Puna Police-S&W,Overtime S&W (294,408) 73,602.00 613,258.27 267,401.61 244,314.38 1,124,974.26 73,602.00 73,602.00 147,204.00 294,408.00 -830,566.26 0.00 010.201.5215.61 021 H I P A L S&W,Overtime S&W (4,005) 1,001.25 454.96 170.61 325.71 951.28 1,001.25 1,001.25 2,002.50 4,005.00 3,053.72 0.00 010.201.5215.81 021 Special Duty S&W,Overtime S&W (1,500) 375.00 0.00 0.00 0.00 0.00 375.00 375.00 750.00 1,500.00 1,500.00 0.00 Fire S&W 010.221.5221.01 021 Fire Protection-S&W,Overtime S&W (3,396,745) 849,186.25 1,594,096.04 1,198,829.17 1,365,126.27 4,158,051.48 849,186.25 849,186.25 1,698,372.50 3,396,745.00 -761,306.48 0.00 010.221.5221.51 021 Fire EMS-S&W,Overtime S&W (1,874,190) 468,547.50 738,374.91 579,165.10 582,318.81 1,899,858.82 468,547.50 468,547.50 937,095.00 1,874,190.00 -25,668.82 0.00 010.221.5223.01 021 Ocean Safety S&W,Overtime S&W (71,987) 17,996.75 50,500.16 16,272.75 28,753.01 95,525.92 17,996.75 17,996.75 35,993.50 71,987.00 -23,538.92 0.00 010.221.5223.31 021 W.HI Ocean Safety S&W,Overtime S&W (9,000) 2,250.00 10,828.76 2,965.37 6,221.24 20,015.37 2,250.00 2,250.00 4,500.00 9,000.00 -11,015.37 0.00 010.221.5224.01 021 Fire Prevention-S&W,Overtime S&W (44,500) 11,125.00 26,104.32 20,631.87 20,809.48 67,545.67 11,125.00 11,125.00 22,250.00 44,500.00 -23,045.67 0.00 010.221.5225.01 021 Equip Maint-S&W,Overtime S&W (16,287) 4,071.75 3,124.23 2,796.32 2,619.47 8,540.02 4,071.75 4,071.75 8,143.50 16,287.00 7,746.98 0.00 010.221.5225.51 021 EMS Equip Maint-S&W,Overtime S&W (2,000) 500.00 1,452.06 1,575.68 1,348.85 4,376.59 500.00 500.00 1,000.00 2,000.00 -2,376.59 0.00 010.221.5226.01 021 Tmg&Voluntr Fire S&W,Overtime S&W (11,570) 2,892.50 13,569.96 8,649.47 17,444.29 39,663.72 2,892.50 2,892.50 5,785.00 11,570.00 -28,093.72 0.00 Civil Defense Agc S&W 010.241.5241.01 021 Civil Defense Agc S&W,Overtime S&W (64,186) 16,046.50 32,381.76 6,156.02 38,929.85 77,467.63 16,046.50 16,046.50 32,093.00 64,186.00 -13,281.63 0.00 Liquor Control S&W 010.251.5251.01 021 Liquor Control S&W,Overtime S&W (6,000) 1,500.00 906.48 6,622.92 -5,304.59 2,224.81 1,500.00 1,500.00 3,000.00 6,000.00 3,775.19 0.00 2 Funds Moved Transfer-1 Transfer-2 Transfer-3 3rd Dept Total Variance rom Depts to 1/4 Allotment 1st Quarter 2nd Quarter 3rd Quarter TOTAL OT First Second &4th Funds Transferred vs Department Account No. Account Description r-inance Amount OT Expended OT Expended OT Expended Expended YTD Quarter Quarter Quarters Transferred Expended Balance Prosecuting Atty S&W 010.271.5271.01 021 Prosecuting Atty S&W,Overtime S&W (8,000) 2,000.00 36,899.09 45,158.71 40,481.70 122,539.50 2,000.00 2,000.00 4,000.00 8,000.00 -114,539.50 0.00 010.271.5271.13 021 Kona Pros Atty S&W,Overtime S&W (5,380) 1,345.00 3,879.56 4,261.86 3,826.50 11,967.92 1,345.00 1,345.00 2,690.00 5,380.00 -6,587.92 0.00 Office of Aging S&W 010.411.5411.01 021 Office of Aging S&W,Overtime S&W (143) 35.75 0.00 1,267.53 0.00 1,267.53 35.75 35.75 71.50 143.00 -1,124.5 0.00 010.411.5411.09 021 Area Plan on Aging S&W,Overtime S&W (12,000) 3,000.00 0.00 0.00 0.00 0.00 3,000.00 3,000.00 6,000.00 12,000.00 12,000.00 0.00 Parks&Recreation S&W 010.423.5421.01 021 Alae Cemetery S&W,Overtime S&W (10,800) 2,700.00 1,783.59 1,232.85 1,126.46 4,142.90 2,700.00 2,700.00 5,400.00 10,800.00 6,657.10 0.00 010.481.5481.01 021 Coordinated Services S&W,Overtime S&W (1,500) 375.00 2,144.37 1,623.99 77.68 3,846.04 375.00 375.00 750.00 1,500.00 -2,346.0 0.00 010.481.5482.01 021 R S V P-S&W,Overtime S&W (300) 75.00 0.00 0.00 0.00 0.00 75.00 75.00 150.00 300.00 300.00 0.00 010.481.5483.01 021 Nutrition Program-S&W,Overtime S&W (100) 25.00 309.20 4,599.01 170.64 5,078.85 25.00 25.00 50.00 100.00 -4,978.f. 0.00 010.500.5501.01 021 Hawaii County Band S&W,Overtime S&W (16,089) 4,022.25 6,297.68 4,025.50 1,251.43 11,574.61 4,022.25 4,022.25 8,044.50 16,089.00 4,514.39 0.00 010.500.5503.01 021 P&R Adm S&W,Overtime S&W (5,000) 1,250.00 10,305.24 12,715.39 4,890.40 27,911.03 1,250.00 1,250.00 2,500.00 _ 5,000.00 -22,911.0 0.00 010.500.5505.01 021 Parks Maint S&W,Overtime S&W (205,000) 51,250.00 92,556.30 61,442.51 55,430.72 209,429.53 51,250.00 51,250.00 102,500.00 205,000.00 -4,429.53 0.00 010.500.5507.01 021 Recreation Div S&W,Overtime S&W (60,000) 15,000.00 8,334.92 7,980.05 29,061.59 45,376.56 15,000.00 15,000.00 30,000.00 60,000.00 14,623.44 0.00 010.500.5511.01 021 Hoolulu Complex S&W,Overtime S&W (41,000) 10,250.00 8,837.16 8,296.05 8,335.68 25,468.89 10,250.00 10,250.00 20,500.00 41,000.00 15,531.11 0.00 010.500.5513.51 021 Aquatics Admin S&W,Overtime S&W (5,600) 1,400.00 4,552.33 440.64 391.92 5,384.89 1,400.00 1,400.00 2,800.00 5,600.00 215.11 0.00 010.500.5513.61 021 Aquatics Pools S&W,Overtime S&W (12,150) 3,037.50 4,746.78 5,871.77 4,500.16 15,118.71 3,037.50 3,037.50 6,075.00 12,150.00 -2,968.7 I 0.00 010.500.5517.01 021 Culture&Ed S&W,Overtime S&W (500) 125.00 2,067.80 930.51 1,654.02 4,652.33 125.00 125.00 250.00 500.00 -4,152.3: 0.00 010.500.5519.11 021 Ead Admin S&W,Overtime S&W (200) 50.00 177.48 74.17 102.93 354.58 50.00 50.00 100.00 200.00 -154.5,`, 0.00 010.500.5519.71 021 Ead Recreation S&W,Overtime S&W (1,190) 297.50 979.84 0.00 1,508.79 2,488.63 297.50 297.50 595.00 1,190.00 -1,298.6. 0.00 010.500.5523.01 021 Panaewa Zoo S&W,Overtime S&W (17,000) 4,250.00 9,773.08 3,333.24 5,394.53 18,500.85 4,250.00 4,250.00 8,500.00 17,000.00 -1,500.8 0.00 Environmental Mgmt S&W 010.671.5671.01 021 Environmental Mgmt S&W,Overtime S&W (15,000) 3,750.00 5,429.82 2,118.02 860.87 8,408.71 3,750.00 3,750.00 7,500.00 15,000.00 6,591.29 0.00 TOTAL (8,339,607)_ (2,084,90L75) 7,307,507.23 3,980,708.63 3,897,816.91 15,186,032.77 2,084,901.75 2,084,901.75 4,169,803.50 8,339,607.00 0.00 3 J��Y .......... AARON AARON S.Y.CHUNG ofi H,� ''�. MAILE MEDEIROS DAVID =o••• n' •�2.;.� •9� KAREN EOFF Chairperson 3 1L.„."�� MATT KANEALI`I-KLEINFELDER * .:.1`;,.7f ASHLEY L.KIERKIEWICZ HERBERT M."TIM"RICHARDS,III SUSAN L.K.LEE LOY Vice Chair '-, • VALERIE T.POINDEXTER - oF14P REBECCA VILLEGAS HAWAII COUNTY COUNCIL County of Hawai Hawai`i County Building 25 Aupuni Street Hilo, Hawai`i 96720 April 8, 2020 Aaron S.Y. Chung, Council Chair Hawai`i County Council 25 Aupuni Street Hilo, Hawai`i 96720 RE: Resolution No. 582-20 : A RESOLUTION TRANSFERRING/APPROPRIATING AN APPROPRIATION OUT AND FROM THE DESIGNATED FUND ACCOUNTS(S) AND CREDITING SAME TO A DESIGNATED FUND ACCOUNT(S). Pursuant to Section 2(g) of Rule 4 of the Rules of Procedure of the Council of the County of Hawai`i,this written request is submitted with my approval that the above-referenced matter be waived from the Committee on Finance to the full Council for immediate action. In reviewing this matter, timely approval is crucial. It is therefore advantageous that approval is granted and the matter be placed onto the next Council agenda for review. However, in the event this request is denied, for whatever reason, I understand the matter shall be referred to the Committee on Finance for placement on its future agenda. Sincerely, Maile David, Chairperson Committee on Finance Approve Date/Waive to Council: Disapproved/Date/Refer to FC: Aaron S.Y. Chung, Council Chir Aaron S.Y. Chung, Council Chair Hawai`i County Council 4/6120 Hawai`i County Council 1 MD/lm Hawai`i County is an Equal Opportunity Provider and Employer