The URL can be used to link to this page

2021-04-29 Work SessionPage Kodiak Island Borough Assembly Work Session Thursday, April 29, 2021, 6:30 p.m. Bayside Volunteer Fire Department - 4606 East Rezanof Drive For public participation this meeting will be livestreamed through KIB UstreamTV (https://video.ibm.com/channel/kodiakislandborough) Work Sessions are informal meetings of the Assembly where Assembly members review the upcoming regular meeting agenda packet and seek or receive information from staff. Although additional items not listed on the work session agenda are discussed when introduced by the Mayor, Assembly, or staff, no formal action is taken at work sessions and items that require formal Assembly action are placed on regular Assembly meeting agenda. Citizen's comments at work sessions are NOT considered part of the official record. Citizen's comments intended for the "official record" should be made at a regularAssembly meeting. 1. Citizens' Comments. 1-907-486-3231 or Toll Free 1-855-492-9202. (Limited To Three Minutes Per Speaker) 2. Agenda items a. COVID-19 Relief Bill - Stimulus Bill b. Presentation, Alaska Aerospace, Mark Lester, President & CEO C. Discussion On Election Code Amendments 3-96 d. FY2022 Borough Manager Budget and School District Funding Discussion FY22 School District Budget Request Fiscal Year 2022 Borough Manager s Budget 3. Manager's Comments 4. Clerk's Comments 5. Packet Review for the Regular Meeting of May 6, 2021 Items may be added during the work session for inclusion on the Regular Meeting agenda. For noticing requirements the item may be brought up and noticed to the Clerk to add the item. You may NOT enter into a substantive conversation. Awards and presentations. • Recognizing The Month Of May 2021 As National Historic Preservation Month. Public hearing. Visit our website at@ www.facebook.com/Kodiakislandborough 0@KodiakBorough www.kodiakak.us Page 1 of 96 • New Distillery License Application From Alcohol and Marijuana Control Office. Licensee: Kodiak Island Brewing Company, LLC, Doing Business As: Kodiak Island Still. • Ordinance No. FY2021-35 Writing Off The Personal, Lease And Mobile Home Property Delinquent Taxes, Penalties, Interest, And Fees Of Those Non - Collectable Tax Accounts. Consideration of the calendar - Unfinished Business. • None Consideration of the calendar - New Business. Contracts. • Contract No. FY2021-20 Procurement Of Type 6 Wildland Engine For Womens Bay Volunteer Fire Department. • Contract No. FY2021-22 Borough Building Boiler Room Upgrades Resolutions. • Resolution No. FY2021-37 Establishing The City Of Kodiak And Kodiak Island Borough Cooperative Relations Committee. • Resolution No. FY2021-38 Rescinding Resolution No. FY2018-21 And Documenting The Kodiak Fisheries Work Group's Scope And Authority. • Resolution No. FY2021-40 Re -Establishing The Fees Of The Kodiak Island Borough. Ordinances for introduction. • Ordinance No. FY2021-01 H Of The Assembly Of The Kodiak Island Borough Amending Ordinance No. FY2021-01, Fiscal Year 2021 Budget, By Amending Budgets To Account For Various Revenues That Are Over Budget, Providing For Additional Expenditures And Moving Funds Between Projects. • Ordinance No. FY2021-41 Reestablishing Boards, Committees, And Commissions As Established In The Kodiak Island Borough Code Of Ordinances Title 2 Administration And Personnel Chapter 2.100 Boards, Committees, And Commissions. Other items. • Confirmation Of Board Appointments to the Planning and Zoning Commission, Mr. Paul VanDyke and Andrew Kenneson. • Confirmation Of Board Appointment to the Bay View Road Service Area Board, Mr. Lucas Baxter. • Confirmation Of Board Appointments to the City Of Kodiak and Kodiak Island Borough Cooperative Relations Committee, Assembly Member Julie Kavanaugh, Assembly Member Geoffrey Smith, and Assembly Member Aimee Williams. Executive Session. • Continued Discussion Of The Borough Manager, Michael Powers, Evaluation. 6. Assembly Member' Comments 7. Mayor Comments Visit our website at@ www.facebook.com/Kodiakislandborough www.kodiakak.us 0 @KodiakBorough Page 2 of 96 AGENDA ITEM #2.d. Kodiak Island Borough School District 722 Mill Bay Road Kodiak, Alaska 99615 Office of the Superintendent (907)486-7550 April 23, 2021 Michael Powers, Manager Kodiak Island Borough 710 Mill Bay Road Kodiak, AK 99615 Dear Mr. Powers, On April 19, 2021 the Kodiak Island Borough School Board (KIBSD) approved their budget. The local request is for $11,090,089 for the FY22 School District Budget. We have had the following FY22 Budget Presentations and Discussions: December 14, 2020 -Preliminary budget projects presented January 11, 2021 -Update on open positions for FY22 and presentation on COVID needs February 1, 2021 -Presented balanced budget March 2, 2021-FY22 Budget presentation by Principals/Directors March 11, 2021 -Joint KIB/KIBSD work session April 19, 2021-FY22 Budget Approved Should you have any questions regarding the budget information, please contact our Chief Financial Officer Sandy Daws at (907)486-7557. Sincerely, L eDoux KIBSD Superintendent Page 3 of 96 FY2022 Borough Manager Budget and School District Funding Discussion AGENDA ITEM #2.d. Kodiak Island Borough OFFICE of the MANAGER 710 Mill Bay Road Kodiak, Alaska 99615 Phone (907) 486-9301 Fax (907) 486-9374 E-mail: mpowers@kodiakak.us DATE: April 1, 2021 TO: Mayor William Roberts and Borough Assembly FROM: Michael Powers, Borough Manager SUBJECT: FY2022 Manager's Budget Attached, via electronic and paper copy, is the proposed Manager's Budget for FY2022. The budget is based upon input received to date and the March 31St submission by Special Districts. Because of the change in timing on the Manager's Budget recently enacted by the Assembly, staff has not reviewed the budgets submitted by the Special Districts. Bear in mind that the change in the timing has resulted in four less weeks of Assembly input into the Manager's Budget. The Budget has been crafted with the intent to maintain the level of services except in regard to building repairs, renewal, and renovations. We have reached a critical junction where we own numerous building that have not had adequate funding for a number of years and given the known deficiencies, including use ending type problems, we must focus and fund capital items. Staff has presented the deficiencies, the Renewal and Replacement lists and additionally the Assembly has approved numerous Capital Improvement Lists for some of the Renewal and Replacement projects along with other projects. However, to accomplish this work, funding must be allocated. Below I will touch on the significant issues in the various funds General Fund We are proposing a relatively flat General Fund with a few exceptions. On the revenue side, we expect to see diminished taxes due to Covidl9. The State continues to deal with their own budget problems, and we expect a continued decline in existing sources such as CAP (which is driven by funding formula headed downwards) and potential pull back or elimination of some local funding. Fishery revenues remain complex and difficult to predict. We have included a .84 mill rate for funding operations (down from 2.75 last year). Regarding expenditures, we are removing the Human Resource position but are proposing to add one (1) position to Assessing (Assessing Technician) and one position (1) to Engineering and Facilities (Maintenance Coordinator). Assessing has been working with a reduced staff for the past year and considering the changes in available imagery, adding the position is warranted. The Maintenance Coordinator is a long overdue position to be funding to continue to address the lack of maintenance, repairs and renovation that has existed for years. The position will be funded across multiple departments and funds. We also continue to fund the replacement of the PACS software (Assessing). We are budgeting $250,000 this year as part of the multiyear funding strategy for conversion. We have not included funding for non -profits in the budget. Other expenses remain relatively flat with inflationary factors (labor, supplies) driving increases. Page 4 of 96 FY2022 Borough Manager Budget and School District Funding Discussion AGENDA ITEM #2.d. School Funding Debt -The Governor has proposed funding at 50% which we have included in our budget. While there is discussion in the Legislature about potentially higher funding, no serious discussions on the topic have occurred. School Operations -Staff has included the funding as requested by the School District in this proposal. The total request for schools is 10.71 mills of the 12.5 total which is up 2.71 mills from last year. Special Revenue and Enterprise Renewal and Replacement -The emphasis is on capital repairs both for this fiscal year and future years. The Mill rate is proposed at .93 mills (0 Mills last year) and it is proposed that the allowable expenditures of the Facilities Fund go to Renewal and Replacement. Staff has presented numerous needs across all of the buildings we own. Special Districts -We have provided the budgets provided by the districts without commentary. We have prepared the budgets for those without boards. Tourism -We are proposing to fund Discover Kodiak at $60,000. If revenue is not offset by Stimulus 3 funds, we will use up most of the fund balance in FY2022. We will return with appropriate budget amendments once the funding becomes available. Solid Waste Disposal We continue to work on solutions to the leachate problem while operating the landfill. We are proposing to purchase a bulldozer, to do additional shot rock development and to work on drainage and leachate issues. Hospital -We continue to work with Providence on both the Renewal and Replacement issues as well as other needed capital work. Further, we continue to explore what to do with the 1968/1978 building. The fund is undercapitalized. Long Term Care Center -We are working with our fourth CEO on the lease of the facility and to address preventative maintenance issues. Kodiak Fish Research Center -We have included $2.5M in building Renewal and Replacement for siding and roofing, ventilation, and other issues. Apartments -No significant changes although we continue to see demand. Overall a Mill Rate of 12.50 is proposed as follows: General Fund (Borough Operations) 0.84 Renewal and Replacement 0.93 School Bond Debt 3.39 School Operations 7.34 12.5u Page 5 of 96 FY2022 Borough Manager Budget and School District Funding Discussion K�diak Island Borough dic ItWormation for FY2022 Budget General Fund Expenses 0 As of 03/31/21 0 C: 2018 2019 2020 2021 2021 2022 �spartment Actual Actual Actual (Budget) Actual (Mgr Budget) 100-100 Legislative Personnel Services $ 31,800 $ 31,500 $ 32,104 $ 32,100 $ 16,846 $ 32,100 Employee Benefits $ 3,926 $ 2,924 $ 3,383 $ 3,597 $ 1,090 $ 4,761 W Professional Services $ 72,931 $ 72,954 $ 72,184 $ 85,500 $ 46,500 $ 89,500 Support Goods & Services $ 38,774 $ 37,077 $ 36,551 $ 39,850 $ 44,049 $ 35,300 Total $ 147,431 $ 144,455 $ 144,222 $ 161,047 $ 108,485 $ 161,661 v a 100-105 Borough Management � Personnel Services $ 347,178 $ 392,194 $ 421,771 $ 404,431 $ 266,862 $ 303,768 3 0 Employee Benefits $ 213,188 $ 229,913 $ 249,404 $ 253,301 $ 171,479 $ 196,029 0 Professional Services $ - $ - $ - $ - $ - $ 45,000 0 Support Goods & Services $ 64,223 $ 76,215 $ 59,721 $ 49,000 $ 39,758 $ 50,774 Allocated $ (32,000) $ (37,000) $ (42,000) $ (42,000) $ (42,000) $ (42,000) -n Total $ 592,589 $ 661,322 $ 688,896 $ 664,732 $ 436,099 $ 553,571 C: L1 100-110 Borough Clerk D Personnel Services $ 254,649 $ 274,088 $ 210,513 $ 219,126 $ 127,871 $ 230,430 cc p Employee Benefits $ 152,267 $ 160,728 $ 147,289 $ 150,862 $ 86,067 $ 167,718 En Professional Services $ - $ - $ - $ - $ 3,248 $ - Cn Support Goods & Services $ 129,539 $ 118,148 $ 97,081 $ 113,372 $ 93,177 $ 123,322 0 Allocated $ - $ - $ - $ - $ - $ - Total $ 536,455 $ 552,964 $ 454,883 $ 483,360 $ 310,363 $ 521,470 100-115 Borough Attorney Professional Services $ 89,553 $ 62,455 $ 73,911 $ 100,000 $ 30,022 $ 100,000 Support Goods & Services $ 15,294 $ 24,439 $ 14,465 $ 9,500 $ 14,442 $ 9,500 Total $ 104,847 $ 86,894 $ 88,376 $ 109,500 $ 44,464 $ 109,500 100-120 Finance Department Personnel Services $ 420,271 $ 426,275 $ 453,432 $ 442,408 $ 317,148 $ 437,218 Employee Benefits $ 268,749 $ 278,740 $ 314,089 $ 335,016 $ 236,265 $ 346,657 CD M Professional Services $ - $ - $ - $ - $ - 0 � Support Goods & Services $ 112,145 $ 99,064 $ 91,326 $ 90,881 $ 70,105 $ 88,481 Allocated $ (43,000) $ (48,319) $ (47,319) $ (48,319) $ (48,319) $ (48,319) Total $ 758,165 $ 755,760 $ 811,528 $ 819,986 $ 575,199 $ 824,037 K�Idiak Island Borough dic ItWormation for FY2022 Budget General Fund Expenses p As of 03/31/21 0 C: 2018 2019 2020 2021 2021 2022 �spartment Actual Actual Actual (Budget) Actual (Mgr Budget) 100-125 Information Technology Personnel Services $ 273,862 $ 278,941 $ 314,901 $ 282,927 $ 207,581 $ 275,147 Employee Benefits $ 165,684 $ 172,401 $ 193,719 $ 185,519 $ 139,771 $ 190,271 W Professional Services $ 6,680 $ 9,286 $ 1,000 $ 15,000 $ 3,484 $ 15,000 Support Goods & Services $ 347,531 $ 406,491 $ 340,248 $ 343,394 $ 308,383 $ 369,202 CD Capital Outlay $ 18,726 $ 83,625 $ 13,921 $ 25,000 $ - $ 70,000 v a Allocated Salaries $ (6,000) $ - $ - $ - $ - � Operating Transfers $ - $ 200,000 $ 100,000 $ - $ - $ 250,000 o Total $ 806,483 $ 1,150,744 $ 963,789 $ 851,840 $ 659,219 $ 1,169,620 ° 100-130 Assessing Department c Personnel Services $ 460,871 $ 260,574 $ 347,201 $ 333,465 $ 252,055 $ 449,930 Employee Benefits $ 272,680 $ 184,847 $ 237,961 $ 231,863 $ 173,255 $ 350,109 -n Professional Services $ - $ 18,470 $ 7,260 $ 76,430 $ 20,903 $ 25,000 c Support Goods & Services $ 59,928 $ 62,483 $ 64,188 $ 91,058 $ 71,036 $ 83,940 n Allocated Salaries $ (4,000) $ (4,000) $ (1,500) $ (1,500) $ (1,500) $ (1,500) cD p Total $ 789,479 $ 522,374 $ 655,110 $ 731,316 $ 515,749 $ 907,479 c 100-135 Engineering / Facilities Cn Personnel Services $ 234,475 $ 232,915 $ 204,429 $ 175,369 $ 155,003 $ 206,642 Employee Benefits $ 149,305 $ 155,503 $ 157,719 $ 129,302 $ 131,355 $ 150,830 Professional Services $ - $ - $ - $ - $ - $ - Support Goods & Services $ 81,398 $ 74,589 $ 68,896 $ 81,000 $ 48,399 $ 82,082 Allocated Salaries $ - $ - $ - $ - $ - Total $ 465,178 $ 463,007 $ 431,044 $ 385,671 $ 334,757 $ 439,554 100-140 Community Development Personnel Services $ 438,592 $ 364,544 $ 261,668 $ 354,793 $ 221,132 $ 380,305 Employee Benefits $ 285,084 $ 255,130 $ 173,949 $ 247,545 $ 167,406 $ 279,210 Professional Services $ 32,726 $ 33,407 $ 44,220 $ 17,000 $ 19,406 $ 25,000 CD � Support Goods & Services $ 124,339 $ 253,418 $ 112,740 $ 107,583 $ 83,541 $ 109,532 CD Allocated Salaries $ (500) $ (500) $ - $ - $ - 6' Operating Transfers $ - $ 65,200 $ - $ - $ - Total $ 880,241 $ 971,199 $ 592,577 $ 726,921 $ 491,485 $ 794,047 K�diak Island Borough ItWormation for FY2022 Budget Croneral Fund Expenses 00 $ 2019 O 2020 Actual O C: Actual $ lNipartment $ 142,231 $ 167,430 100-142 Building Official v $ Professional Services $ 20,491 $ Support Goods & Services W 188,072 Total 184,664 $ 100-160 Economic Development CD $ Professional Services v $ Support Goods & Services a 600 $ n � Total 0 100-165 General Administration Personnel Services 0 Employee Benefits Professional Services TI Support Goods & Services c Capital Outlay D Total cc p 100-172 Parks & Recreation 0 Personnel Services C: Cn Employee Benefits O Professional Services Support Goods & Services Capital Outlay Total 100-175 Emergency Preparedness Personnel Services Employee Benefits Professional Services v CD Support Goods & Services o Total 0h CD rn 2018 $ 2019 $ 2020 Actual $ Actual $ Actual $ 142,231 $ 167,430 $ 164,173 $ $ 24,220 $ 20,642 $ 20,491 $ $ 166,451 $ 188,072 $ 184,664 $ $ 33,336 $ - $ 20,000 $ $ 600 $ 600 $ 600 $ $ 33,936 $ 600 $ 20,600 $ $ 833 $ 1,433 $ 773 $ $ 2,880 $ 3,250 $ 8,119 $ $ 98,555 $ 107,308 $ 89,159 $ $ 92,591 $ 237,627 $ 214,475 $ $ 9,035 $ - $ - $ $ 194,859 $ 349,618 $ 312,526 $ $ 17,414 $ 11,570 $ 12,289 $ $ 4,304 $ 3,219 $ 3,030 $ $ 8,431 $ 1,055 $ 1,350 $ $ 38,003 $ 41,252 $ 15,893 $ $ 9,035 $ - $ - $ $ 77,187 $ 57,096 $ 32,562 $ $ 4,204 $ 5,028 $ 423 $ $ 2,443 $ 2,637 $ 251 $ $ 21,917 $ 400 $ - $ $ 14,473 $ 6,241 $ 3,804 $ $ 43,037 $ 14,306 $ 4,478 $ dlc As of 03/31/21 2021 $ 2021 $ 2022 (Budget) $ Actual (Mgr Budget) 140,000 $ 72,408 $ 140,000 20,491 $ 15,368 $ 20,491 160,491 $ 87,776 $ 160,491 13,570 $ - $ 13,570 - $ 600 4,399 $ 13,570 $ 600 $ 13,570 1,500 $ 380 $ 42,496 3,665 $ (163) $ 35,508 108,125 $ 101,130 $ 103,125 652,959 $ 124,715 $ 74,500 - $ - $ 75,000 766,249 $ 226,062 $ 330,629 29,500 $ 6,411 $ 29,965 6,272 $ 2,494 $ 20,081 10,000 $ 3,500 $ 10,000 26,000 $ 1,141 $ 27,000 $ 2,303 $ 17,200 Z 71,772 $ 13,546 $ 87,046 - $ 1,277 $ 9,300 - $ 718 $ 7,495 n 19,000 $ 101 $ 15,000 rn 20,950 $ 2,303 $ 17,200 Z 39,950 $ 4,399 $ 48,995 n rn N a K�diak Island Borough dig ItWormation for FY2022 Budget Croneral Fund Expenses p As of 03/31/21 0 C: 2018 2019 2020 2021 2021 2022 �spartment Actual Actual Actual (Budget) Actual (Mgr Budget) 100-186 Animal Control Professional Services $ 114,015 $ 115,800 $ 118,700 $ 118,715 $ 118,700 $ 121,000 Total $ 114,015 $ 115,800 $ 118,700 $ 118,715 $ 118,700 $ 121,000 W 100-190 Education / Culture / Recreation Support Goods & Services $ 4,665 $ 20,472 $ 20,447 $ 20,800 $ 18,852 $ 20,589 Total $ 4,665 $ 20,472 $ 20,447 $ 20,800 $ 18,852 $ 20,589 v 100-191 Kodiak College & Libraries CL � Contributions $ 72,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ - o Total $ 72,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ - ° 100-192 - 110 Non -Profit Funding: Health & Social Services Contributions $ 179,500 $ 158,300 $ 133,800 $ 92,400 $ 92,400 Total $ 179,500 $ 158,300 $ 133,800 $ 92,400 $ 92,400 $ - -n 100-192 - 120 Non -Profit Funding: Education, Culture & Recreation C: I Contributions $ 28,000 $ 24,600 $ 23,700 $ 35,350 $ 35,350 n Total $ 28,000 $ 24,600 $ 23,700 $ 35,350 $ 35,350 $ - cD 0 100-195 Transfers Out c Operating Transfers $ 403,958 $ - $ 13,000 $ 3,026,148 $ 3,026,148 $ - Cn Total $ 403,958 $ - $ 13,000 $ 3,026,148 $ 3,026,148 $ - 0' K�diak Island Borough dic ItWormation for FY2022 Budget Croneral Fund Expenses p As of 03/31/21 0 2018 2019 2020 2021 2021 2022 C: �spartment Actual Actual Actual (Budget) Actual (Mgr Budget) o_ p Non Recurring Items 55 Operating Transfers Non -Profit COVID-19 Funding c Health & Social Services Q- Education, business & general cc 0 $ 403,958 $ 265,200 $ 113,000 $ 3,026,148 $ 3,026,148 $ 250,000 $ 1,122,500 $ 839,525 $ 4,183,679 $ 4,289,906 E Grand Total $ 6,398,476 $ 6,287,583 $ 5,744,902 $ 14,635,997 $ 12,279,084 $ 6,263,259 0 C Cn o' CD 0 0 v Category Personnel Services $ 2,484,149 $ 2,279,062 $ 2,259,504 $ 2,275,619 $ 1,572,566 $ 2,397,301 Employee Benefits $ 1,520,510 $ 1,449,292 $ 1,488,913 $ 1,546,942 $ 1,109,737 $ 1,748,669 W Professional Services $ 620,375 $ 588,565 $ 591,957 $ 703,340 $ 419,402 $ 702,195 Support Goods & Services $ 1,147,723 $ 1,478,758 $ 1,160,926 $ 1,666,838 $ 935,869 $ 1,111,913 CD Capital Outlay $ 27,761 $ 83,625 $ 13,921 $ 25,000 $ - $ 145,000 a Allocated Salaries $ (85,500) $ (89,819) $ (90,819) $ (91,819) $ (91,819) $ (91,819) Cn Non -Profit Contributions $ 279,500 $ 232,900 $ 207,500 $ 177,750 $ 177,750 $ - o Subtotal $ 5,994,518 $ 6,022,383 $ 5,631,902 $ 6,303,670 $ 4,123,505 $ 6,013,259 o_ p Non Recurring Items 55 Operating Transfers Non -Profit COVID-19 Funding c Health & Social Services Q- Education, business & general cc 0 $ 403,958 $ 265,200 $ 113,000 $ 3,026,148 $ 3,026,148 $ 250,000 $ 1,122,500 $ 839,525 $ 4,183,679 $ 4,289,906 E Grand Total $ 6,398,476 $ 6,287,583 $ 5,744,902 $ 14,635,997 $ 12,279,084 $ 6,263,259 0 C Cn o' CD 0 0 N Budget Worksheet Report CD N SODIAS I, IAD DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : 100 - General Fund WDepartment 000 - Fund Revenues C Property Tax 017-000 311.100 Real Property Tax 159,796.02 737,825.22 1,448,181.84 710,067.92 3,432,842.00 3,561,834.91 1,125,773.00 29-000 311.200 Personal Property Tax 21,507.82 84,827.35 152,397.94 86,754.06 381,427.00 432,924.46 136,832.00 � Property Tax Totals $181,303.84 $822,652.57 $1,600,579.78 $796,821.98 $3,814,269.00 $3,994,759.37 $1,262,605.00 C- Non Ad valorem Taxes W000 313.100 Boat Tax 190-000 313.120 Aircraft Tax O Non Ad Valorem Taxes Totals Payment in Lieu of Taxes (64.00) .00 .00 .00 .00 .00 .00 26,500.00 30,000.00 30,200.00 29,100.00 28,000.00 23,100.00 23,100.00 $26,436.00 $30,000.00 $30,200.00 $29,100.00 $28,000.00 $23,100.00 $23,100.00 120-000 314.100 PILT - Federal 1,546,288.00 1,578,030.00 1,542,393.00 1,614,634.00 1,300,000.00 .00 1,300,000.00 a-000 314.200 PILT - KIHA 31,579.34 27,601.54 22,227.38 18,583.38 23,000.00 16,870.58 20,000.00 0-000 314.210 PILT - Alaska Housing 14,245.14 15,834.11 17,417.08 18,573.77 15,000.00 .00 15,000.00 Q Payment in Lieu of Taxes Totals $1,592,112.48 $1,621,465.65 $1,582,037.46 $1,651,791.15 $1,338,000.00 $16,870.58 $1,335,000.00 Severance Taxes (Q 9&-000 316.100 Sea Products 1,182,923.51 1,660,842.06 1,163,238.06 1,170,360.02 1,100,000.00 605,619.15 1,100,000.00 JR -000 316.200 Mining - Gravel 73,495.53 53,618.33 5,182.78 12,564.33 4,000.00 4,150.34 4,000.00 :g0-000 316.300 Timber 50,087.78 101,463.04 38,276.51 40,996.71 20,000.00 26,281.49 20,000.00 Severance Taxes Totals $1,306,506.82 $1,815,923.43 $1,206,697.35 $1,223,921.06 $1,124,000.00 $636,050.98 $1,124,000.00 0 M Penalties & Interest Tax 100-000 319.100 Penalties & Interest 213,373.11 219,086.29 288,818.29 227,075.78 210,000.00 263,082.26 210,000.00 Penalties & Interest Tax Totals $213,373.11 $219,086.29 $288,818.29 $227,075.78 $210,000.00 $263,082.26 $210,000.00 Licenses & Permits 100-000 322.110 Building Permits 57,928.33 42,465.65 99,553.45 78,274.10 52,000.00 35,091.23 52,000.00 100-000 322.120 Subdivision 6,490.00 4,200.00 6,765.00 1,900.00 4,000.00 3,650.00 4,000.00 100-000 322.130 Conditional Use Permit 1,000.00 250.00 900.00 .00 500.00 500.00 500.00 100-000 322.140 Zoning Compliance Permit 6,840.00 6,180.00 6,190.00 5,790.00 7,000.00 3,690.00 5,000.00 n 100 -Ob 322.150 Exception Permits .00 .00 100.00 .00 .00 .00 .00 100 -*0 322.160 Variance Fee 2,455.00 650.00 1,750.00 500.00 500.00 1,900.00 1,000.00 Z 100-& 322.170 Zoning Change Fee .00 .00 .00 .00 .00 30.00 .00 v 100-W 322.180 Electric Permit 3,450.75 3,872.85 4,445.50 4,060.30 4,000.00 4,666.55 4,000.00 n 100-JJ0 322.190 Plumbing Permit 2,254.00 2,513.80 5,629.40 2,061.80 2,400.00 1,972.00 2,400.00 100-000 322.200 P & Z Review Fee 450.00 600.00 900.00 1,450.00 1,000.00 .00 1,000.00 m 100-000 322.210 Special Land Use 1,050.00 .00 .00 .00 .00 .00 .00 Run by Dora Cross on 03/31/2021 16:26:25 PM Page 1 of!;6 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh R, A -i- Amni inh R1 irinat - I : 100 - General Fund Department 000 - Fund Revenues W Licenses & Permits 00-000 322.230 Dog Licenses 1,628.00 1,467.00 1,608.00 1,079.00 1,000.00 .00 1,000.00 29-000 322.239 Business License - Tobacco .00 .00 400.00 300.00 300.00 300.00 300.00 1%0-000 322.240 Business License - Marijuana .00 .00 2,200.00 1,000.00 .00 1,200.00 1,000.00 1&-000 322.250 Site Plan Review .00 150.00 .00 .00 .00 .00 .00 c7 3 Licenses & Permits Totals $83,546.08 $62,349.30 $130,441.35 $96,415.20 $72,700.00 $52,999.78 $72,200.00 O Excise Tax O rM-000 323.100 Tobacco Excise Tax .00 310,482.25 423,979.28 388,276.23 400,000.00 314,463.42 350,000.00 0 Jn0-000 323.110 Marijuana Excise Tax .00 .00 1,465.36 1,449.35 2,500.00 1,306.92 1,000.00 Excise Tax Totals $0.00 $310,482.25 $425,444.64 $389,725.58 $402,500.00 $315,770.34 $351,000.00 0• " Federal Grants 11-000 331.119 CORONAVIRUS Relief Fund (CARES ACT) .00 .00 .00 173,632.99 5,792,501.00 5,435,013.05 .00 O Q Federal Grants Totals $0.00 $0.00 $0.00 $173,632.99 $5,792,501.00 $5,435,013.05 $0.00 Federal Shared Revenue (Q J6-000 332.100 National Wildlife Refuge 230,082.00 191,973.00 222,000.00 193,149.00 190,000.00 .00 180,000.00 Federal Shared Revenue Totals $230,082.00 $191,973.00 $222,000.00 $193,149.00 $190,000.00 $0.00 $180,000.00 C: State Shared Revenues 90-000 335.110 State Community Assistance (formally 461,512.00 465,942.00 443,210.80 408,022.08 316,986.00 317,746.33 344,454.00 O State Revenue Sharing) a0-000 335.130 Fisheries Business Tax 1,270,403.28 1,103,101.42 1,816,530.38 718,306.93 900,000.00 1,023,974.69 1,000,000.00 100-000 335.132 Business Fisheries & Landing Tax 60,422.12 14,867.52 184,559.55 210,076.14 150,000.00 38,655.02 100,000.00 100-000 335.150 Telephone & Electric 16,480.87 17,320.57 16,560.89 16,197.62 17,000.00 .00 16,000.00 100-000 335.170 Liquor License .00 .00 .00 174.00 .00 .00 .00 100-000 335.175 Marijuana Licenses .00 500.00 1,000.00 300.00 500.00 300.00 300.00 100-000 335.190 PERS on Behalf Payment 107,144.56 82,920.34 137,142.18 151,656.82 155,541.00 126,889.77 194,400.00 100-000 335.191 PERS Forfeiture .00 .00 .00 10,520.95 1,000.00 .00 .00 n -�y0 State Shared Revenues Totals $1,915,962.83 $1,684,651.85 $2,599,003.80 $1,515,254.54 $1,541,027.00 $1,507,565.81 $1,655,154.00 &es m 100-010 351.100 Animal Control 491.00 441.00 .00 55.00 .00 .00 .00 Z N o Fines Totals $491.00 $441.00 $0.00 $55.00 $0.00 $0.00 $0.00 n Brest EarnIngs 100-CDO 361.100 Interest Earnings 30,077.94 60,667.70 121,585.52 137,371.08 100,000.00 30,329.58 50,000.00 y 100-000 361.300 Change in Fair Market Value (19,019.07) (49,837.69) 90,043.57 15,432.55 .00 (9,543.28) .00 m Interest Earnings Totals $11,058.87 $10,830.01 $211,629.09 $152,803.63 $100,000.00 $20,786.30 $50,000.00 Run by Dora Cross on 03/31/2021 16:26:25 PM Page 2 of!;6 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh RI irinat - I : 100 - General Fund . Department 000 - Fund Revenues n �' `° rn z W v WMiscellaneous - Classified n C rn _ y &-000 380.110 Jury Duty 175.00 250.00 300.00 300.00 200.00 200.00 200.00 20-000 380.120 Sale of Copies 67.40 95.25 .00 691.25 500.00 25.25 .00 a-000 380.122 Sale of Maps 837.00 1,969.04 1,458.32 828.92 1,200.00 118.99 .00 Q J&-000 380.130 Dishonored Check Fee 361.00 219.00 245.00 75.00 100.00 40.00 .00 J90-000 380.170 Other 1,784.10 3,740.19 13,206.58 11,987.61 10,000.00 3,721.19 .00 :80-000 380.260 Legal & Collection Fee Reimbursement .00 .00 .00 13,006.70 .00 .00 .00 Jij-000 380.280 IBEW Reimbursement .00 .00 .00 2,393.64 .00 396.76 .00 Miscellaneous - Classified Totals $3,224.50 $6,273.48 $15,209.90 $29,283.12 $12,000.00 $4,502.19 $200.00 n' Operating Transfers In IW -000 391.300 Debt Service .00 492,936.00 142,177.00 .00 .00 .00 .00 C: Operating Transfers In Totals $0.00 $492,936.00 $142,177.00 $0.00 $0.00 $0.00 $0.00 Q Sale of Fixed Assets J]0-000 392.100 Sale / General Fixed Assets .00 1,240.00 4,815.00 .00 .00 .00 .00 0 Sale of Fixed Assets Totals $0.00 $1,240.00 $4,815.00 $0.00 $0.00 $0.00 $0.00 n Department 000 - Fund Revenues Totals $5,564,097.53 $7,270,304.83 $8,459,053.66 $6,479,029.03 $14,624,997.00 $12,270,500.66 $6,263,259.00 C REVENUE TOTALS to $5,564,097.53 $7,270,304.83 $8,459,053.66 $6,479,029.03 $14,624,997.00 $12,270,500.66 $6,263,259.00 O n �' `° rn z W v 0 n C rn _ y Run by Dora Cross on 03/31/2021 16:26:25 PM Page 3 of96 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh R, A -i- Amni inh R1 irinat - I : 100 - General Fund WDepartment 100 - Legislative C: Personnel Services 8-100 410.106 Mayoral Stipend 6,500.00 6,000.00 6,000.00 6,500.00 6,000.00 3,000.00 6,000.00 20-100 410.108 Assembly Stipend 24,900.00 25,800.00 25,500.00 25,603.66 26,100.00 13,846.34 26,100.00 j Personnel Services Totals $31,400.00 $31,800.00 $31,500.00 $32,103.66 $32,100.00 $16,846.34 $32,100.00 Q Employee Benefits *-100 420.120 FICA Taxes 2,451.84 2,486.26 2,409.75 2,448.00 2,567.00 1,239.30 2,456.00 0-100 420.130 Group Insurance .00 .00 .00 .00 .00 .00 1,083.00 O M-100 420.140 Retirement 1,593.57 1,205.59 296.70 747.73 1,030.00 (225.72) 1,084.00 19-100 420.150 Workers Compensation 189.90 233.75 216.93 186.46 .00 76.80 138.00 n• Employee Benefits Totals $4,235.31 $3,925.60 $2,923.38 $3,382.19 $3,597.00 $1,090.38 $4,761.00 'T�S7I Professional Services 0-100 430.100 Political Lobbyist 72,000.00 72,000.00 72,000.00 72,000.00 84,000.00 46,500.00 84,000.00 =-100 430.101 Lobbying Expense .00 .00 .00 .00 1,500.00 .00 500.00 &-100 430.102 Consolidation Expenses .00 931.18 954.46 184.39 .00 .00 5,000.00 Professional Services Totals $72,000.00 $72,931.18 $72,954.46 $72,184.39 $85,500.00 $46,500.00 $89,500.00 _0 (n Legal Services 0 ]E0-100 431.120 Legal Fees 826.50 .00 .00 .00 .00 .00 .00 LA. Legal Services Totals $826.50 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 = Support Goods & Services 100-100 450.100 Office Supplies 18.45 86.14 402.71 642.49 500.00 633.78 200.00 100-100 450.115 Computer Software <$5000 .00 .00 .00 .00 .00 .00 1,000.00 100-100 450.120 Printing / Binding .00 .00 .00 17.12 200.00 .00 100.00 100-100 450.140 Dues / Books / Periodicals 19,028.85 18,475.00 18,289.20 16,611.25 19,150.00 18,470.81 19,000.00 100-100 450.160 Furniture / Fixtures .00 .00 .00 .00 .00 724.68 .00 100-100 450.170 Machinery / Equipment <$5000 .00 .00 .00 .00 .00 19,886.43 .00 100-100 450.200 Honorarium / Amenities 1,708.97 4,136.93 200.56 1,336.60 2,500.00 2,860.00 1,500.00 100-,R0 450.210 Food / Business Lunch/Meeting Rooms 1,641.67 1,163.12 1,011.58 456.30 1,500.00 150.78 500.00 m 100-%0 450.220 Insurance & Bonding 211.30 .00 .00 .00 .00 .00 .00 Z 100-14C0 450.222 General Liablity Insurance Coverage .00 462.77 471.19 .00 .00 .00 .00 n 100-;;0 450.224 Insurance Coverage Discounts .00 (123.00) (123.63) .00 .00 .00 .00 100-RO 450.300 Travel / Per Diem 16,971.65 13,392.73 16,097.91 16,297.91 11,000.00 942.08 10,000.00 y 100-100 450.301 Mayor Travel / Per Diem .00 873.33 380.00 715.53 4,000.00 .00 2,000.00 m 100-100 450.340 Telephone 670.12 306.91 347.06 474.24 500.00 380.12 500.00 Run by Dora Cross on 03/31/2021 16:26:25 PM Page 4 of!;6 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am—nh Am—nh Ri A—i- Amni inh RI irinat - I : 100 - General Fund W Department 100 - Legislative C: Support Goods & Services k0-100 450.485 Town Meeting Costs 857.65 .00 .00 .00 500.00 .00 500.00 C(D Support Goods & Services Totals $41,108.66 $38,773.93 $37,076.58 $36,551.44 $39,850.00 $44,048.68 $35,300.00 Iv Department 100 - Legislative Totals $149,570.47 $147,430.71 $144,454.42 $144,221.68 $161,047.00 $108,485.40 $161,661.00 Q X cn n -1 C D 0a �W to n C Cn O n �' `° rn z v 0 n rn y Run by Dora Cross on 03/31/2021 16:26:25 PM Page 5 of96 N Budget Worksheet Report CD .# . 117� TAT ilT7� K'OD R' l l._7-LA H Y D N 6. Budget Year 2022 BOOH 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's L Account Account Description Amount Amount Amount Amount Budget Amount Budget - L2 E5�d 100 - General Fund (&XPENSE WDepartment 105 - Borough Management C Personnel Services 00-105 410.110 Salaries 314,141.46 344,572.04 387,896.23 412,237.85 403,231.00 262,150.56 298,568.00 29-105 410.130 Overtime 5,281.20 2,605.85 3,098.18 8,333.45 .00 3,811.75 4,000.00 &-105 410.152 Cell Phone Stipend .00 .00 1,200.00 1,200.00 1,200.00 900.00 1,200.00 0- C/) Personnel Services Totals $319,422.66 $347,177.89 $392,194.41 $421,771.30 $404,431.00 $266,862.31 $303,768.00 0 Employee Benefits 190-105 420.110 Unemployment Taxes 30.90 34.45 37.62 39.05 40.00 26.64 30.00 O TOO-105 420.120 FICA Taxes 24,092.31 25,983.10 28,573.78 29,628.57 30,579.00 19,960.31 23,252.00 JCA0-105 420.130 Group Insurance 71,529.71 96,172.15 100,926.97 103,890.92 106,320.00 67,592.29 79,920.00 IR0-105 420.140 Retirement 81,851.42 88,380.98 97,811.64 113,590.16 114,403.00 82,677.04 91,520.00 1JY-105 420.150 Workers Compensation 2,114.04 2,617.38 2,562.98 2,255.57 1,959.00 1,222.81 1,307.00 � Employee Benefits Totals $179,618.38 $213,188.06 $229,912.99 $249,404.27 $253,301.00 $171,479.09 $196,029.00 Professional Services &-105 430.140 Contracted Services .00 175.00 .00 .00 .00 .00 45,000.00 0 Professional Services Totals $0.00 $175.00 $0.00 $0.00 $0.00 $0.00 $45,000.00 nsupport Goods & Services ]E0-105 450.100 Office Supplies 328.99 772.92 933.57 1,653.05 750.00 850.68 1,750.00 80-105 450.119 COVID-19 Expenditures .00 .00 .00 352.91 .00 .00 .00 1:90-105 450.120 Printing / Binding 3,079.76 4,560.16 2,744.37 1,618.15 1,500.00 661.95 1,500.00 100-105 450.130 Postage .00 68.45 8.03 .00 50.00 .00 .00 100-105 450.140 Dues / Books / Periodicals 1,776.48 3,641.45 4,399.68 3,444.00 2,200.00 1,847.55 3,450.00 100-105 450.160 Furniture / Fixtures 163.39 3,914.14 1,914.31 .00 500.00 .00 500.00 100-105 450.170 Machinery / Equipment <$5000 .00 .00 .00 .00 .00 1,944.57 .00 100-105 450.200 Honorarium / Amenities .00 .00 2,472.77 2,305.09 500.00 2,844.30 .00 100-105 450.210 Food / Business Lunch/Meeting Rooms 952.02 269.38 1,522.99 2,557.41 1,500.00 1,018.74 1,000.00 n 100-iffi 450.220 Insurance & Bonding 2,454.04 .00 .00 .00 .00 .00 .00 ^ 100<05 450.222 General Liablity Insurance Coverage .00 3,539.65 3,768.57 .00 .00 .00 .00 m 100-105 450.224 Insurance Coverage Discounts .00 (939.00) (923.15) .00 .00 .00 .00 v 100-k95 450.270 Continuing Education 2,509.80 4,591.67 11,167.59 541.09 .00 .00 .00% n 10040 450.290 Recruit / Relocation 357.85 894.45 .00 .00 .00 299.50 .00 100-105 450.300 Travel / Per Diem 6,315.30 6,631.65 7,747.66 6,428.48 1,000.00 .00 2,500.00 m 100-105 450.330 Rent 29,712.00 35,402.00 39,850.00 39,849.00 40,000.00 30,000.01 39,849.00 Run by Dora Cross on 03/31/2021 16:26:25 PM Page 6 of!;6 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am—nh Am—nh Ri A—i- Amni inh RI irinat - I : 100 - General Fund WDepartment 105 - Borough Management n �' `° rn z v C Support Goods & Services n C rn _ y 80-105 450.340 Telephone 1,562.71 701.27 608.41 971.60 1,000.00 290.30 225.00 20-105 450.430 Maint & Repairs 207.00 .00 .00 .00 .00 .00 .00 j Support Goods & Services Totals $49,419.34 $64,048.19 $76,214.80 $59,720.78 $49,000.00 $39,757.60 $50,774.00 Q- Allocated to Projects *-105 492.530 Allocated to Solid Waste (10,000.00) (10,000.00) (10,000.00) (15,000.00) (15,000.00) (15,000.00) (15,000.00) 9-105 492.540 Allocated to Hospital (10,000.00) (10,000.00) (15,000.00) (15,000.00) (15,000.00) (15,000.00) (15,000.00) O tM-105 492.555 Allocated to KFRC (12,000.00) (12,000.00) (12,000.00) (12,000.00) (12,000.00) (12,000.00) (12,000.00) c Allocated to Projects Totals ($32,000.00) ($32,000.00) ($37,000.00) ($42,000.00) ($42,000.00) ($42,000.00) ($42,000.00) Department 105 - Borough Management Totals $516,460.38 $592,589.14 $661,322.20 $688,896.35 $664,732.00 $436,099.00 $553,571.00 n -1 C D C n C Cn O n �' `° rn z v O n C rn _ y Run by Dora Cross on 03/31/2021 16:26:25 PM Page 7 of96 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : 100 - General Fund WDepartment 110 - Borough Clerk C: Personnel Services t&-110 410.110 Salaries 238,649.74 249,075.27 265,816.21 203,120.34 209,926.00 107,788.15 212,444.00 20-110 410.120 Temporary Help .00 .00 .00 .00 .00 15,779.78 10,708.00 &110 410.130 Overtime 10,250.66 5,573.59 7,071.95 6,221.50 8,000.00 3,403.23 6,678.00 CL ]f-110 410.152 Cell Phone Stipend .00 .00 1,200.00 1,170.97 1,200.00 900.00 600.00 n Personnel Services Totals $248,900.40 $254,648.86 $274,088.16 $210,512.81 $219,126.00 $127,871.16 $230,430.00 3 0 Employee Benefits M-110 420.110 Unemployment Taxes 24.32 24.31 23.75 19.57 22.00 11.93 23.00 19-110 420.120 FICA Taxes 17,036.13 18,320.52 19,505.34 15,400.03 16,671.00 9,906.72 17,582.00 1�0-110 420.130 Group Insurance 62,553.09 70,171.29 78,264.16 74,040.58 76,440.00 39,109.75 79,920.00 A-110 420.140 Retirement 64,096.43 62,105.26 61,329.28 56,701.13 56,661.00 36,382.29 69,202.00 {0-110 420.150 Workers Compensation 1,662.88 1,645.15 1,605.21 1,127.21 1,068.00 656.09 991.00 Employee Benefits Totals $145,372.85 $152,266.53 $160,727.74 $147,288.52 $150,862.00 $86,066.78 $167,718.00 (Q Professional Services JM -110 430.140 Contracted Services .00 .00 .00 .00 .00 3,247.60 .00 F5, Professional Services Totals $0.00 $0.00 $0.00 $0.00 $0.00 $3,247.60 $0.00 (n Support Goods & Services 80-110 450.100 Office Supplies 348.50 784.59 799.86 416.16 1,000.00 613.19 500.00 1:90-110 450.110 Operating Supplies 466.18 .00 169.00 50.97 500.00 .00 100.00 100-110 450.115 Computer Software <$5000 .00 .00 .00 720.00 .00 .00 .00 100-110 450.119 COVID-19 Expenditures .00 .00 .00 99.90 .00 .00 .00 100-110 450.120 Printing / Binding 8,475.97 9,912.43 4,563.65 7,370.20 6,000.00 2,000.59 .00 100-110 450.130 Postage .00 .00 31.40 48.15 100.00 11.90 .00 100-110 450.140 Dues / Books / Periodicals 825.00 955.00 1,485.00 356.00 1,000.00 746.00 500.00 100-110 450.160 Furniture / Fixtures 40.00 .00 .00 .00 .00 5,334.27 500.00 n 1004M 450.170 Machinery / Equipment <$5000 860.85 968.00 3,768.51 .00 .00 .00 500.00 ^ 1000 450.200 Honorarium / Amenities .00 .00 .00 .00 225.00 .00 .00 m 100-110 450.210 Food / Business Lunch/Meeting Rooms .00 .00 .00 116.49 75.00 92.28 100.00 v 00 100-kj0 450.230 Advertising / Hearings 26,154.40 18,745.76 6,591.59 6,243.84 7,000.00 4,656.25 9,750.00 n 100 -LO 450.232 Advertising - APOC to Advertising - Ballot .00 .00 .00 .00 1,000.00 .00 .00 Propositions 100-110 450.270 Continuing Education 10,433.91 9,836.94 13,403.62 5,863.78 13,000.00 7,240.00 15,000.00 111 ! 1 ?l 100-110 450.290 Recruit / Relocation 1,057.40 .00 10,827.63 1,199.42 .00 1,449.68 .00 Run by Dora Cross on 03/31/2021 16:26:25 PM Page 8 of!;6 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am—nh Am—nh Ri Ai i. Amni inh RI irinat - I : 100 - General Fund WDepartment 110 - Borough Clerk �' `° rn z C v O C: Support Goods & Services C rn _ y 9-110 450.300 Travel / Per Diem 2,545.98 2,412.50 172.93 .00 1,000.00 .00 .00 20-110 450.330 Rent 49,220.00 58,634.00 49,772.00 49,772.00 49,772.00 37,329.02 49,772.00 110-110 450.340 Telephone 1,069.85 1,184.21 1,795.86 1,311.89 2,200.00 152.98 300.00 CL ]&-110 450.470 Election Local 22,210.45 23,631.60 21,505.53 21,813.25 25,000.00 32,244.27 40,000.00 JBD-110 450.480 Boards & Committees 427.33 200.00 1,956.55 1,700.00 2,000.00 .00 1,300.00 :80-110 450.530 Records Management 643.15 2,273.75 710.22 .00 2,500.00 1,306.67 5,000.00 ]&-110 450.531 Transcription / Record Restoration Fee 369.40 .00 594.70 .00 1,000.00 .00 .00 Support Goods& Services Totals $125,148.37 $129,538.78 $118,148.05 $97,082.05 $113,372.00 $93,177.10 $123,322.00 Department 110 -Borough Clerk Totals $519,421.62 $536,454.17 $552,963.95 $454,883.38 $483,360.00 $310,362.64 $521,470.00 -1 C D c n C Cn O n �' `° rn z C v O n C rn _ y Run by Dora Cross on 03/31/2021 16:26:25 PM Page 9 of96 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am—nh Am—nh Ri A—i- Amni inh RI irinat - I : 100 - General Fund . Department 115 - Borough Attorney C `°z rn N C) ° �. n WLegal Services _ y Run by Dora Cross on 03/31/2021 16:26:25 PM 9-115 431.110 Litigation Expenses 31,750.47 36,902.91 15,459.23 1,360.00 .00 .00 .00 20-115 431.120 Legal Fees 60,877.04 52,650.55 46,996.24 72,550.90 100,000.00 30,021.69 100,000.00 j Legal Services Totals $92,627.51 $89,553.46 $62,455.47 $73,910.90 $100,000.00 $30,021.69 $100,000.00 Q- Support Goods & Services -115 450.230 Advertising / Hearings 7,845.46 9,021.79 10,811.98 11,082.11 4,000.00 3,228.76 4,000.00 9-115 450.240 Filing / Record Fees 2,017.00 1,522.00 4,376.95 3,383.00 3,000.00 3,525.75 3,000.00 O t00-115 450.245 Title Search Fees 5,000.00 4,750.00 9,250.00 .00 2,500.00 4,500.00 2,500.00 t0-115 450.323 Collection Expense .00 .00 .00 .00 .00 3,187.00 .00 1RO-115 450.340 Telephone (2.78) .00 .00 .00 .00 .00 .00 Support Goods & Services Totals $14,859.68 $15,293.79 $24,438.93 $14,465.11 $9,500.00 $14,441.51 $9,500.00 Department 115 - Borough Attorney Totals $107,487.19 $104,847.25 $86,894.40 $88,376.01 $109,500.00 $44,463.20 $109,500.00 D c n C Cn O n C `°z rn N C) ° �. n C rn _ y Run by Dora Cross on 03/31/2021 16:26:25 PM Page 10 of.96 N Budget Worksheet Report CD N SS I, I ODIAAD DH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : 100 - General Fund WDepartment 120 - Finance Department C: Personnel Services 8-120 410.110 Salaries 389,375.10 394,681.53 404,369.43 421,071.96 414,008.00 290,610.44 409,768.00 20-120 410.120 Temporary Help 8,419.58 23,916.97 19,789.59 30,340.11 26,000.00 25,595.86 25,800.00 a-120 410.130 Overtime 4,825.22 1,672.76 1,215.81 1,119.58 1,200.00 304.20 1,200.00 Q ]f-120 410.152 Cell Phone Stipend .00 .00 900.00 900.00 1,200.00 637.50 450.00 n 3 Personnel Services Totals $402,619.90 $420,271.26 $426,274.83 $453,431.65 $442,408.00 $317,148.00 $437,218.00 0 Employee Benefits M-120 420.110 Unemployment Taxes 38.76 39.65 40.33 40.32 44.00 30.67 44.00 19-120 420.120 FICA Taxes 29,794.28 31,178.79 31,455.54 32,083.75 33,752.00 24,507.60 33,413.00 1�0-120 420.130 Group Insurance 126,199.01 133,243.97 140,390.85 162,723.42 171,990.00 116,129.63 179,820.00 A-120 420.140 Retirement 102,590.03 100,819.08 103,917.98 116,797.74 126,274.00 94,165.97 131,500.00 {0-120 420.150 Workers Compensation 2,730.72 3,467.99 2,935.65 2,443.88 2,956.00 1,431.62 1,880.00 Employee Benefits Totals $261,352.80 $268,749.48 $278,740.35 $314,089.11 $335,016.00 $236,265.49 $346,657.00 7 (Q support Goods & Services JO -120 450.100 Office Supplies 1,745.86 2,719.69 2,044.82 1,986.93 2,000.00 1,758.29 2,000.00 ND -120 450.119 COVID-19 Expenditures .00 .00 .00 73.23 .00 1,024.67 .00 C 1a0-120 450.120 Printing / Binding 9,820.10 8,951.41 8,026.36 9,206.36 9,500.00 6,940.59 9,500.00 56-120 450.140 Dues / Books / Periodicals 3,232.57 3,126.41 2,714.24 3,562.95 3,500.00 3,161.03 3,000.00 100-120 450.160 Furniture / Fixtures .00 4,278.47 635.97 .00 500.00 .00 .00 100-120 450.170 Machinery / Equipment <$5000 .00 .00 .00 496.23 .00 .00 .00 100-120 450.210 Food / Business Lunch/Meeting Rooms .00 .00 8.43 117.84 .00 136.46 .00 100-120 450.220 Insurance & Bonding 9,460.26 .00 .00 .00 .00 2,750.00 .00 100-120 450.222 General Liablity Insurance Coverage .00 4,613.82 4,755.59 .00 .00 .00 .00 100-120 450.224 Insurance Coverage Discounts .00 (1,224.00) (1,245.76) .00 .00 .00 .00 100-120 450.270 Continuing Education 4,874.32 5,679.48 8,324.50 2,177.25 4,000.00 1,642.00 4,000.00 n 100 0 450.290 Recruit / Relocation 3,010.51 1,424.51 2,154.75 2,358.52 500.00 .00 .00 100-'50 450.330 Rent 65,819.00 78,408.00 66,556.00 66,556.00 66,556.00 49,917.01 66,556.00 Z 100-U0 450.340 Telephone 1,018.35 1,080.41 1,363.04 1,865.96 1,400.00 308.36 500.00 v 100-W 450.430 Maint & Repairs .00 162.04 3,092.37 .00 .00 .00 .00 n 100-1'?0 493.130 Bond Insurance Coverage .00 2,925.00 633.40 2,925.00 2,925.00 2,466.60 2,925.00 Support Goods &Services Totals $98,980.97 $112,145.24 $99,063.71 $91,326.27 $90,881.00 $70,105.01 $88,481.00 Run by Dora Cross on 03/31/2021 16:26:25 PM Page 11 ofPb K'ODK'ID BO OU H 100 - General Fund . Department W 120 - Finance Department Allocated to Projects k1-120 492.210 Allocated to Land Sales 20-120 492.530 Allocated to Solid Waste 110-120 492.540 Allocated to Hospital Q 1&-120 492.555 Allocated to KFRC n Allocated to Projects Totals 3 O Department 120 - Finance Department Totals O 0 Budget Worksheet Report Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am—nh Am—nh Ri A—i- Amni inh RI irinat - I : (1,000.00) (1,000.00) (1,000.00) .00 (1,000.00) (1,000.00) (1,000.00) (6,000.00) (6,000.00) (10,000.00) (10,000.00) (10,000.00) (10,000.00) (10,000.00) (24,000.00) (24,000.00) (25,319.00) (25,319.00) (25,319.00) (25,319.00) (25,319.00) (12,000.00) (12,000.00) (12,000.00) (12,000.00) (12,000.00) (12,000.00) (12,000.00) ($43,000.00) ($43,000.00) ($48,319.00) ($47,319.00) ($48,319.00) ($48,319.00) ($48,319.00) $719,953.67 $758,165.98 $755,759.89 $811,528.03 $819,986.00 $575,199.50 $824,037.00 n �' `°z rn N N v O n C rn _ y Run by Dora Cross on 03/31/2021 16:26:25 PM Page 12 of96 N Budget Worksheet Report o N � *�. SODIAS I,IA1D Budget Year 2022 a -4j BOWOUOU 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : 100 - General Fund WDepartment 125 - Information Technology C: Personnel Services 8-125 410.110 Salaries 262,607.75 262,863.88 264,854.45 291,222.47 272,327.00 191,552.69 264,397.00 20-125 410.120 Temporary Help .00 49.39 .00 .00 .00 .00 .00 a-125 410.130 Overtime 5,395.22 10,949.15 10,186.05 19,778.62 7,000.00 13,115.34 7,000.00 Q ]f-125 410.152 Cell Phone Stipend .00 .00 3,900.00 3,900.00 3,600.00 2,912.50 3,750.00 n Personnel Services Totals $268,002.97 $273,862.42 $278,940.50 $314,901.09 $282,927.00 $207,580.53 $275,147.00 3 0 Employee Benefits M-125 420.110 Unemployment Taxes 26.37 26.86 27.39 30.06 28.00 21.49 27.00 19-125 420.120 FICA Taxes 20,021.50 20,464.62 20,804.36 22,748.51 21,369.00 16,266.11 20,762.00 1�0-125 420.130 Group Insurance 72,317.66 73,464.15 77,458.37 82,131.12 82,810.00 55,899.69 86,580.00 A-125 420.140 Retirement 70,047.34 69,456.54 72,189.59 87,106.25 79,943.00 66,646.50 81,718.00 {0-125 420.150 Workers Compensation 1,827.36 2,272.19 1,921.06 1,703.38 1,369.00 937.22 1,184.00 Employee Benefits Totals $164,240.23 $165,684.36 $172,400.77 $193,719.32 $185,519.00 $139,771.01 $190,271.00 (Q Professional Services JO -125 430.140 Contracted Services 3,075.00 6,679.70 9,286.29 1,000.00 15,000.00 3,484.42 15,000.00 F0, Professional Services Totals $3,075.00 $6,679.70 $9,286.29 $1,000.00 $15,000.00 $3,484.42 $15,000.00 (n Support Goods & Services 80-125 450.100 Office Supplies 372.51 2,194.76 454.26 325.01 1,200.00 53.08 1,000.00 1:90-125 450.110 Operating Supplies 4,740.51 1,166.83 3,893.18 5,953.59 8,500.00 1,232.25 6,000.00 100-125 450.115 Computer Software <$5000 4,705.23 9,549.79 3,630.56 5,286.80 5,000.00 599.88 6,000.00 100-125 450.119 COVID-19 Expenditures .00 .00 .00 12,323.41 .00 8,751.61 .00 100-125 450.120 Printing / Binding 2,388.79 2,103.37 844.20 1,335.88 2,220.00 433.44 1,800.00 100-125 450.140 Dues / Books / Periodicals 510.00 .00 .00 .00 300.00 .00 300.00 100-125 450.160 Furniture / Fixtures 963.09 435.83 806.80 83.99 1,000.00 .00 1,000.00 100-125 450.170 Machinery/ Equipment <$5000 22,534.56 28,576.73 67,953.18 16,358.39 14,800.00 2,549.36 14,200.00 n 100-i§5 450.210 Food / Business Lunch/Meeting Rooms .00 .00 52.10 22.00 .00 181.57 .00 1005 450.220 Insurance & Bonding 2,770.48 .00 .00 .00 .00 .00 .00CD m 100-$Z5 450.222 General Liablity Insurance Coverage .00 3,335.51 3,629.89 .00 .00 .00 .00 W v 100-65 450.224 Insurance Coverage Discounts .00 (885.00) (951.13) .00 .00 .00 .00 n 100-L 450.270 Continuing Education .00 4,790.65 12,567.06 .00 4,000.00 .00 6,000.00 100-125 450.300 Travel / Per Diem 455.79 4,353.09 427.24 10.37 1,000.00 6.90 .00 m 100-125 450.330 Rent 60,358.00 71,914.00 70,174.00 70,174.00 70,174.00 52,630.51 70,174.00 Run by Dora Cross on 03/31/2021 16:26:25 PM Page 13 of!;b N Budget Worksheet Report o N � *�. SODIAS I,IA1D Budget Year 2022 a -4J BOWOUOU 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh R, A -i- Amni inh R1 irinat - I : 100 - General Fund WDepartment 125 - Information Technology C Support Goods & Services 80-125 450.340 Telephone 2,980.89 3,351.99 3,962.68 4,453.92 5,200.00 5,025.97 4,600.00 29-125 450.430 Maint & Repairs 7,808.64 5,542.33 4,238.24 4,107.91 10,000.00 3,427.53 5,000.00 90-125450.435 Maint Agreements 195,708.83 211,101.31 234,808.40 219,813.21 220,000.00 233,491.23 253,128.00 0- n v C `° m Z N -0 n U) Support Goods & Services Totals $306,297.32 $347,531.19 $406,490.66 $340,248.48 $343,394.00 $308,383.33 $369,202.00 n Capital Outlay 190-125 470.100 Machinery/ Equipment >$5000 55,004.45 7,311.41 83,624.74 13,920.94 25,000.00 .00 70,000.00 O T00-125 470.115 Computer Software >$5000 39,879.71 11,414.79 .00 .00 .00 .00 .00 CCn capital Outlay Totals $94,884.16 $18,726.20 $83,624.74 $13,920.94 $25,000.00 $0.00 $70,000.00 Allocated to Projects Q-125 492.210 Allocated to Land Sales (20,000.00) .00 .00 .00 .00 .00 .00 0-125 492.530 Allocated to Solid Waste (6,000.00) (6,000.00) .00 .00 .00 .00 .00 O Allocated to Projects Totals ($26,000.00) ($6,000.00) $0.00 $0.00 $0.00 $0.00 $0.00 _Q Z) Operating Transfers CQ J&-125 494.410 Capital Project - KIB .00 .00 200,000.00 .00 .00 .00 .00 Y-�00-125 494.415 Capital Projects (Borough) .00 .00 .00 100,000.00 .00 .00 250,000.00 Operating Transfers Totals $0.00 $0.00 $200,000.00 $100,000.00 $0.00 $0.00 $250,000.00 U) cnDepartment 125 - Information Technology Totals $810,499.68 $806,483.87 $1,150,742.96 $963,789.83 $851,840.00 $659,219.29 $1,169,620.00 O 73 n v C `° m Z N -0 n M y Run by Dora Cross on 03/31/2021 16:26:25 PM Page 14 of!;b N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : 100 - General Fund WDepartment 130 - Assessing Department Q Personnel Services 8-130 410.110 Salaries 420,965.77 460,047.01 250,216.78 330,872.45 326,888.00 227,662.30 430,340.00 20-130 410.120 Temporary Help .00 .00 3,243.14 13,190.38 .00 20,971.49 13,190.00 &-130 410.130 Overtime 1,488.79 823.74 5,914.12 1,138.01 4,177.00 1,621.16 4,000.00 Q - ]f -130 410.152 Cell Phone Stipend .00 .00 1,200.00 2,000.00 2,400.00 1,800.00 2,400.00 n Personnel Services Totals $422,454.56 $460,870.75 $260,574.04 $347,200.84 $333,465.00 $252,054.95 $449,930.00 3 0 Employee Benefits M-130 420.110 Unemployment Taxes 41.71 42.34 25.37 32.11 33.00 23.56 45.00 19-130 420.120 FICA Taxes 29,679.49 33,099.05 19,451.00 25,126.00 25,326.00 20,346.54 34,236.00 1�0-130 420.130 Group Insurance 115,600.34 117,392.33 85,578.89 102,642.30 101,920.00 68,044.15 159,840.00 A-130 420.140 Retirement 110,994.21 108,744.47 65,731.64 92,646.39 86,077.00 72,401.28 134,751.00 {0-130 420.150 Workers Compensation 13,128.37 13,401.12 14,060.45 17,514.63 18,507.00 12,439.50 21,237.00 Employee Benefits Totals $269,444.12 $272,679.31 $184,847.35 $237,961.43 $231,863.00 $173,255.03 $350,109.00 (Q Professional Services JO -130 430.140 Contracted Services .00 .00 18,470.00 7,260.00 76,430.00 250.00 .00 F0, Professional Services Totals $0.00 $0.00 $18,470.00 $7,260.00 $76,430.00 $250.00 $0.00 (n Legal Services 80-130 431.120 Legal Fees .00 .00 .00 .00 .00 20,653.00 25,000.00 Q Legal Services Totals $0.00 $0.00 $0.00 $0.00 $0.00 $20,653.00 $25,000.00 Support Goods & Services 100-130 450.100 Office Supplies 565.45 388.69 1,779.87 1,387.24 500.00 1,139.80 1,000.00 100-130 450.115 Computer Software <$5000 .00 .00 .00 .00 1,000.00 .00 1,000.00 100-130 450.120 Printing / Binding 4,664.52 4,389.84 4,773.19 4,279.79 4,000.00 2,967.47 4,000.00 100-130 450.130 Postage 1,000.00 725.00 725.60 1,040.00 1,000.00 245.00 1,000.00 100-130 450.140 Dues / Books / Periodicals 1,892.95 1,689.20 1,249.20 1,215.90 1,800.00 1,376.92 1,800.00 100-11330 450.160 Furniture / Fixtures .00 .00 142.99 709.47 1,000.00 239.05 2,012.00 100-,R0 450.210 Food / Business Lunch/Meeting Rooms .00 193.26 71.75 .00 .00 .00 .00 m 100 -NO 450.230 Advertising / Hearings .00 216.16 .00 454.08 200.00 82.56 200.00 Z 100-9b 450.250 Data Services 500.00 1,000.00 .00 500.00 .00 .00 .00 n O �p 100 -LD- 450.270 Continuing Education 5,845.21 748.33 4,647.58 10,256.52 8,000.00 .00 8,000.00 100-90 450.290 Recruit / Relocation .00 372.75 8,526.69 .00 .00 7,839.83 .00 y 100-130 450.300 Travel / Per Diem 1,266.70 2,802.37 .00 3,665.06 30,000.00 25,005.42 22,000.00 m 100-130 450.330 Rent 39,125.00 46,622.00 39,560.00 39,560.00 42,558.00 31,918.50 42,528.00 Run by Dora Cross on 03/31/2021 16:26:26 PM Page 15 of!;b Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am—nh Am—nh Ri A—i- Amni inh RI irinat - I : 100 - General Fund CO Department 130 - Assessing Department n C `°z rn N o ° C Support Goods & Services n rn y 8-130 450.340 Telephone 721.16 780.36 1,006.34 1,119.78 1,000.00 221.54 400.00 O-� Support Goods & Services Totals $55,580.99 $59,927.96 $62,483.21 $64,187.84 $91,058.00 $71,036.09 $83,940.00 0) Allocated to Projects 141-130 492.210 Allocated to Land Sales (2,500.00) (2,500.00) (2,500.00) .00 .00 .00 .00 -130 492.560 Allocated to 911 Services (1,500.00) (1,500.00) (1,500.00) (1,500.00) (1,500.00) (1,500.00) (1,500.00) p Allocated to Projects Totals ($4,000.00) ($4,000.00) ($4,000.00) ($1,500.00) ($1,500.00) ($1,500.00) ($1,500.00) 0 Department 130 - Assessing Department Totals $743,479.67 $789,478.02 $522,374.60 $655,110.11 $731,316.00 $515,749.07 $907,479.00 0 cn n -1 C Z3 E n C En O n C `°z rn N o ° �. n rn y Run by Dora Cross on 03/31/2021 16:26:26 PM Page 16 of96 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : 100 - General Fund WDepartment 135 - Engineering / Facilities C: Personnel Services 8-135 410.110 Salaries 143,979.21 233,837.63 227,556.89 200,850.49 174,169.00 150,993.55 203,602.00 10-135 410.120 Temporary Help 1,275.91 .00 532.12 .00 .00 .00 .00 &-135 410.130 Overtime 1,455.26 636.96 1,626.13 1,008.69 .00 1,903.88 .00 Q ]f-135 410.152 Cell Phone Stipend .00 .00 3,200.00 2,570.00 1,200.00 2,106.00 3,040.00 n Personnel Services Totals $146,710.38 $234,474.59 $232,915.14 $204,429.18 $175,369.00 $155,003.43 $206,642.00 3 0 Employee Benefits M-135 420.110 Unemployment Taxes 14.42 20.63 21.72 18.88 19.00 16.59 20.00 19-135 420.120 FICA Taxes 10,793.17 17,585.19 17,475.60 14,214.53 14,165.00 12,444.12 15,576.00 1�0-135 420.130 Group Insurance 55,378.02 65,461.45 62,707.90 69,003.04 56,056.00 54,928.77 67,932.00 A-135 420.140 Retirement 35,271.82 56,434.77 62,492.11 66,845.38 52,995.00 59,920.48 61,304.00 {0-135 420.150 Workers Compensation 3,618.12 9,802.53 12,805.18 7,637.03 6,067.00 4,045.40 5,998.00 Employee Benefits Totals $105,075.55 $149,304.57 $155,502.51 $157,718.86 $129,302.00 $131,355.36 $150,830.00 (Q Support Goods & Services JM -135 450.100 Office Supplies 492.17 952.19 843.11 1,277.70 1,000.00 338.91 1,200.00 ND -135 450.110 Operating Supplies 371.17 378.86 1,033.77 820.21 1,000.00 58.20 1,000.00 C VO -135 450.119 COVID-19 Expenditures .00 .00 .00 200.90 .00 .00 .00 06-135 450.120 Printing / Binding 3,014.94 2,581.75 1,264.69 2,157.78 1,500.00 1,178.05 2,500.00 100-135 450.140 Dues / Books / Periodicals 159.50 120.00 713.00 223.00 500.00 156.00 500.00 100-135 450.160 Furniture / Fixtures .00 443.20 .00 581.92 3,000.00 .00 3,000.00 100-135 450.170 Machinery / Equipment <$5000 .00 .00 .00 1,658.69 250.00 1,876.00 1,500.00 100-135 450.210 Food / Business Lunch/Meeting Rooms 197.78 164.45 328.09 255.23 250.00 123.08 300.00 100-135 450.220 Insurance & Bonding 562.83 .00 .00 .00 .00 .00 .00 100-135 450.222 General Liablity Insurance Coverage .00 1,516.14 1,674.99 .00 .00 .00 .00 100-135 450.224 Insurance Coverage Discounts .00 (402.00) (438.49) .00 .00 .00 .00 n 100-5 450.230 Advertising /Hearings .00 1,533.41 1,741.73 .00 2,000.00 .00 2,000.00 100-'$5 450.270 Continuing Education 4,821.36 3,394.77 4,039.05 818.00 2,500.00 389.00 4,500.00 Z 100-N5 450.290 Recruit / Relocation .00 3,367.40 2,567.65 970.47 5,000.00 684.00 5,000.00 v 100-25 450.300 Travel / Per Diem (68.25) 113.17 1,484.51 1,342.00 5,000.00 .00 2,500.00 n 100 -JR5 450.330 Rent 56,334.00 65,981.00 56,882.00 56,882.00 57,000.00 42,750.00 56,882.00 100-135 450.340 Telephone 1,297.36 1,253.97 2,169.65 1,708.12 2,000.00 845.43 1,200.00 m 100-135 450.430 Maint & Repairs 61.99 .00 .00 .00 .00 .00 .00 Run by Dora Cross on 03/31/2021 16:26:26 PM Page 17 of!;6 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am—nh Am—nh Ri A—i- Amni inh RI irinat - I : 100 - General Fund W Department 135 - Engineering / Facilities C Support Goods & Services g0-135 450.540 Clothing Allowance .00 .00 285.00 .00 .00 .00 .00 C(D Support Goods & Services Totals $67,244.85 $81,398.31 $74,588.75 $68,896.02 $81,000.00 $48,398.67 $82,082.00 lv Department 135 - Engineering / Facilities Totals $319,030.78 $465,177.47 $463,006.40 $431,044.06 $385,671.00 $334,757.46 $439,554.00 Q X cn n -1 C D 0a �W to n C Cn O n �' `°z rn N 00 v 0 n rn y Run by Dora Cross on 03/31/2021 16:26:26 PM Page 18 of.96 N W - } BO OU H d 100 - General Fund WDepartment 140 - Community Development O Personnel Services k I -140 410.110 Salaries 29-140 410.130 Overtime a-140 410.152 Cell Phone Stipend O_ ct) Personnel Services Totals 0 Employee Benefits Budget Worksheet Report Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : 403,232.03 432,332.53 352,177.41 253,267.00 350,293.00 217,108.75 374,805.00 10,762.20 6,259.76 7,982.70 6,404.11 2,100.00 2,323.13 3,100.00 .00 .00 4,383.41 1,996.78 2,400.00 1,700.00 2,400.00 $413,994.23 $438,592.29 $364,543.52 $261,667.89 $354,793.00 $221,131.88 $380,305.00 &-140 420.110 Unemployment Taxes 40.04 43.33 35.56 5,413.54 38.00 22.12 38.00 O 73 Legal Services Totals $18,364.56 $19,508.50 $11,984.00 $7,053.00 $7,000.00 $10,123.00 M-140 420.120 FICA Taxes 31,976.37 33,642.30 28,557.32 19,297.15 28,794.00 18,360.87 28,673.00 100-140 450.100 Office Supplies 2,795.16 708.47 978.41 808.02 19-140 420.130 Group Insurance 125,720.10 132,774.31 127,891.26 76,477.85 127,400.00 77,477.25 133,200.00 1�0-140 420.140 Retirement 107,495.63 112,152.86 93,243.21 71,021.23 87,712.00 68,683.45 112,854.00 i-140 420.150 Workers Compensation 5,860.93 6,470.82 5,402.73 1,739.68 3,601.00 2,862.61 4,445.00 � :3$167,406.30 Employee Benefits Totals $271,093.07 $285,083.62 $255,130.08 $173,949.45 $247,545.00 100-140 450.170 $279,210.00 Q Professional Services &-140 430.140 Contracted Services 13-140 430.145 Junk Removal Services nProfessional Services Totals U) Legal Services 875.00 235.00 2,115.30 20,972.07 .00 .00 .00 8,692.48 12,981.71 19,307.37 16,194.70 10,000.00 9,283.05 15,000.00 $9,567.48 $13,216.71 $21,422.67 $37,166.77 $10,000.00 $9,283.05 $15,000.00 �i)-140 431.120 Legal Fees 18,364.56 19,508.50 11,984.00 7,053.00 7,000.00 10,123.00 10,000.00 73 Legal Services Totals $18,364.56 $19,508.50 $11,984.00 $7,053.00 $7,000.00 $10,123.00 $10,000.00 Support Goods & Services 100-140 450.100 Office Supplies 2,795.16 708.47 978.41 808.02 750.00 235.77 1,250.00 100-140 450.120 Printing / Binding 11,080.99 9,381.54 6,403.37 5,584.15 6,000.00 4,937.84 6,000.00 100-140 450.140 Dues/ Books/ Periodicals 2,014.00 1,792.55 790.00 1,003.62 1,000.00 1,141.00 1,000.00 100-140 450.160 Furniture / Fixtures 11,454.58 20.00 .00 697.51 500.00 380.98 500.00 100-140 450.170 Machinery / Equipment <$5000 2,119.64 .00 917.49 358.00 .00 .00 .00 n 100-11440 450.191 GIS Data 17,692.65 .00 137,900.00 6,951.79 .00 2,288.68 .00 100 -(FO 450.210 Food / Business Lunch/Meeting Rooms .00 .00 .00 61.72 150.00 120.10 150.00 m 100 -NO 450.230 Advertising / Hearings 8,007.10 7,460.10 7,646.21 3,754.20 5,000.00 2,726.64 5,500.00 Z 100-140 450.240 Filing / Record Fees .00 .00 .00 25.00 .00 165.85 .00 n O 100-aO 450.270 Continuing Education 11,191.54 4,827.31 4,637.26 1,727.12 2,000.00 632.50 3,000.00 100-1R0 450.290 Recruit / Relocation 1,426.04 .00 7,590.21 7,693.46 .00 11,782.50 .00 y 100-140 450.300 Travel / Per Diem 2,995.90 5,870.25 .00 691.79 2,000.00 .00 2,500.00 m 100-140 450.302 Commission Travel 5,351.07 6,279.44 .00 3,536.60 4,000.00 .00 4,000.00 Run by Dora Cross on 03/31/2021 16:26:26 PM Page 19 of!;b Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh RI irinat - I : 100 - General Fund WDepartment 140 - Community Development n �' `°z rn W 0 v C: Support Goods & Services n C rn _ y k0-140 450.330 Rent 56,154.00 73,894.00 71,440.00 71,440.00 68,533.00 51,399.76 68,472.00 20-140 450.340 Telephone 958.37 880.76 2,115.50 1,807.26 850.00 215.60 360.00 a-140 450.430 Maint & Repairs .00 424.99 .00 .00 .00 298.56 .00 CL 1&-140 450.480 Boards & Committees 14,400.00 12,800.00 13,000.00 6,600.00 16,800.00 7,215.55 16,800.00 n Support Goods & Services Totals 3 $147,641.04 $124,339.41 $253,418.45 $112,740.24 $107,583.00 $83,541.33 $109,532.00 0 Allocated to Projects M-140 492.210 Allocated to Land Sales (500.00) (500.00) (500.00) .00 .00 .00 .00 c Allocated to Projects Totals ($500.00) ($500.00) ($500.00) $0.00 $0.00 $0.00 $0.00 m. Operating Transfers 99-140 494.410 Capital Project - KIB .00 .00 25,200.00 .00 .00 .00 .00 ]T-140 494.415 Capital Projects (Borough) .00 .00 40,000.00 .00 .00 .00 .00 7 CL Operating Transfers Totals $0.00 $0.00 $65,200.00 $0.00 $0.00 $0.00 $0.00 ( 1 Department 140 - Community Development Totals $860,160.38 $880,240.53 $971,198.72 $592,577.35 $726,921.00 $491,485.56 $794,047.00 c n C Cn O n �' `°z rn W 0 v 0 n C rn _ y Run by Dora Cross on 03/31/2021 16:26:26 PM Page 20 of.96 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am—nh Am—nh Ri A—i- Amni inh RI irinat - I : 100 - General Fund W Department 142 - Building Official n C `° rn z v C: Professional Services n rn y 90-142 430.140 Contracted Services 76,632.53 142,231.18 167,430.04 164,173.42 140,000.00 72,407.65 140,000.00 (�D Professional Services Totals $76,632.53 $142,231.18 $167,430.04 $164,173.42 $140,000.00 $72,407.65 $140,000.00 Iv Support Goods & Services 141-142 450.330 Rent 20,263.00 24,130.00 20,490.00 20,491.00 20,491.00 15,368.26 20,491.00 -142 450.340 Telephone 83.95 90.02 151.66 .00 .00 .00 .00 p Support Goods & Services Totals $20,346.95 $24,220.02 $20,641.66 $20,491.00 $20,491.00 $15,368.26 $20,491.00 0 Department 142 - Building Official Totals $96,979.48 $166,451.20 $188,071.70 $184,664.42 $160,491.00 $87,775.91 $160,491.00 0 cn n -1 C CZ D c n C cn O n C `° rn z v O n rn y Run by Dora Cross on 03/31/2021 16:26:26 PM Page 21 of96 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am—nh Am—nh Ri A—i- Amni inh RI irinat - I : 100 - General Fund CO Department 160 - Economic Development n �' `°z rn W N v 0 C: Professional Services C rn _ y &-160 430.140 Contracted Services 29,168.00 33,336.00 .00 20,000.00 13,570.00 .00 13,570.00 (�D Professional Services Totals $29,168.00 $33,336.00 $0.00 $20,000.00 $13,570.00 $0.00 $13,570.00 Iv Support Goods & Services 141-160 450.140 Dues / Books / Periodicals 1,100.00 600.00 600.00 600.00 .00 600.00 .00 n Support Goods & Services Tota/s $1,100.00 $600.00 $600.00 $600.00 $0.00 $600.00 $0.00 p Department 160 - Economic Development Totals $30,268.00 $33,936.00 $600.00 $20,600.00 $13,570.00 $600.00 $13,570.00 O 0 cn n -1 C O O c n C O O O n �' `°z rn W N v 0 n C rn _ y Run by Dora Cross on 03/31/2021 16:26:26 PM Page 22 of96 o`s -. �. SODIAS I,IA1D POo 4j BOWOUO�U 3 100 - General Fund WDepartment 165 - General Administration C Personnel Services 00-165 410.110 Salaries 29-165 410.120 Temporary Help &-165 410.130 Overtime O_ CD Personnel Services Totals n Employee Benefits Budget Worksheet Report Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : 813.87 833.01 1,156.35 705.33 1,500.00 379.61 40,758.00 .00 .00 241.12 66.85 .00 .00 1,738.00 .00 .00 35.24 .00 .00 .00 .00 $813.87 $833.01 $1,432.71 $772.18 $1,500.00 $379.61 $42,496.00 W-165 420.110 Unemployment Taxes .06 .06 .10 .05 .00 .03 4.00 O 100-165 450.100 Office Supplies 3,342.86 1,576.85 2,330.73 2,215.36 3,000.00 3,064.56 M-165 420.120 FICA Taxes 60.76 61.59 105.70 (1,211.70) 115.00 28.11 3,251.00 78,316.38 .00 100-165 450.120 Printing / Binding 15,310.04 7,412.92 9,116.90 4,943.35 19-165 420.130 Group Insurance 2,580.11 2,571.49 2,770.16 2,720.64 3,000.00 2,594.26 18,648.00 1�0-165 420.140 Retirement 176.91 180.10 257.94 6,543.16 430.00 (2,812.10) 12,795.00 i-165 420.150 Workers Compensation 68.36 66.98 116.31 67.61 120.00 26.66 810.00 � Employee Benefits Totals $2,886.20 $2,880.22 $3,250.21 $8,119.76 $3,665.00 ($163.04) $35,508.00 Audit Expense 100-,ff5 450.200 &-165 432.100 Professional Services 67,980.59 85,152.96 94,735.34 80,350.29 95,000.00 93,229.10 90,000.00 JM -165 432.110 Out of Pocket Expenses 8,216.15 13,402.04 12,465.22 8,699.65 13,000.00 7,800.90 13,000.00 &-165 432.120 Contracted Services .00 .00 107.79 108.96 125.00 99.70 125.00 C n O (n Audit Expense Totals $76,196.74 $98,555.00 $107,308.35 $89,158.90 $108,125.00 $101,129.70 $103,125.00 100,000.00 12,102.77 20,000.00 100-95 450.223 Crime Protection Insurance Coverage .00 400.00 400.00 0Contributions .00 400.00 400.00 _ y 100-165 450.224 Insurance Coverage Discounts .00 (4,198.00) 1:90-165 448.902 Donated Trash Disposal 15 168.57 35 102.97 103 931.39 130 575.86 .00 .00 .00 Contributions Totals $15,168.57 $35,102.97 $103,931.39 $130,575.86 $0.00 $0.00 $0.00 support Goods & Services 100-165 450.100 Office Supplies 3,342.86 1,576.85 2,330.73 2,215.36 3,000.00 3,064.56 3,000.00 100-165 450.119 COVID-19 Expenditures .00 .00 .00 11,157.72 486,322.00 78,316.38 .00 100-165 450.120 Printing / Binding 15,310.04 7,412.92 9,116.90 4,943.35 10,000.00 9,851.12 8,000.00 100-165 450.130 Postage 9,387.58 8,451.08 8,140.55 3,845.45 10,000.00 7,153.81 8,000.00 n 100-11665 450.180 Equipment Rental 1,695.96 1,695.96 1,695.96 1,695.96 2,000.00 1,271.97 2,000.00 100-,ff5 450.200 Honorarium / Amenities 1,300.99 1,914.42 .00 35.62 .00 152.82 .00 m 100-%5 450.210 Food / Business Lunch/Meeting Rooms 31.63 460.24 763.09 261.26 600.00 .00 .00 Z 1004195 450.220 Insurance & Bonding 16,148.93 .00 .00 .00 .00 .00 .00 n O 100-�"S 450.222 General Liablity Insurance Coverage .00 10,068.95 11,983.18 14,246.83 100,000.00 12,102.77 20,000.00 100-95 450.223 Crime Protection Insurance Coverage .00 400.00 400.00 400.00 .00 400.00 400.00 _ y 100-165 450.224 Insurance Coverage Discounts .00 (4,198.00) (4,360.10) (4,721.00) .00 (4,170.00) .00 m 100-165 450.225 Insurance Deductible 6,800.00 .00 .00 .00 .00 .00 .00 Run by Dora Cross on 03/31/2021 16:26:26 PM Page 23 of!;6 N Budget Worksheet Report o`s N � *�. -. SODIAS I,IA1D Budget Year 2022 00 4j BOWOUO�U a- 3 100 - General Fund 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh R, A -i- Amni inh R1 irinat - I : WDepartment 165 - General Administration C: Support Goods & Services 8-165 450.230 Advertising / Hearings 1,116.71 578.25 570.71 .00 1,000.00 .00 500.00 20-165 450.251 Miscellaneous .00 .00 .00 216.85 .00 11.37 .00 S0-165 450.280 Staff Training 138.60 162.60 .00 .00 .00 .00 .00 Q ]f-165 450.290 Recruit / Relocation 299.50 299.50 823.00 357.05 .00 .00 .00 1B0-165 450.320 Bad Debt Expense 642.44 44.30 55,405.67 21,486.64 3,000.00 19.76 3,000.00 120-165 450.323 Collection Expense 55.10 44.10 11.00 5.50 50.00 .00 .00 ]&-165 450.327 Fines .00 .00 2,564.27 32.12 .00 .00 .00 f7QO-165 450.340 Telephone 848.36 897.65 1,210.27 529.12 1,000.00 42.71 100.00 100-165 450.365 Fuel - Vehicle 4,681.23 5,033.39 6,140.13 3,744.14 6,500.00 2,754.22 4,000.00 f�D>D-165 450.440 Auto Maint & Repairs 6,919.08 4,762.41 7,938.77 6,259.77 10,000.00 1,121.91 10,000.00 a-165 450.450 Contingencies .00 .00 .00 .00 1,987.00 .00 .00 ]00-165 450.461 Safety Supplies 7,883.72 4,554.92 5,742.53 3,068.53 7,000.00 2,100.00 7,000.00 (Q ]-165 450.495 Bank Fees 6,314.85 7,648.30 17,803.79 8,794.12 5,000.00 5,767.30 3,000.00 n Support Goods & Services Totals $82,917.58 $51,807.84 $128,280.45 $78,574.39 $647,459.00 $119,960.70 $69,000.00 C Travel Jc�bO-165 461.220 Travel Insurance Coverage .00 1,000.00 950.00 950.00 1,000.00 950.00 1,000.00 73 Travel Totals $0.00 $1,000.00 $950.00 $950.00 $1,000.00 $950.00 $1,000.00 Equipment 100-165 466.220 Auto Liability Insurance Equipment Totals .00 4,679.96 4,465.87 4,375.00 4,500.00 3,804.46 4,500.00 $0.00 $4,679.96 $4,465.87 $4,375.00 $4,500.00 $3,804.46 $4,500.00 Capital Outlay 100-165 470.100 Machinery / Equipment >$5000 .00 .00 .00 .00 .00 .00 75,000.00 Capital Outlay Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $75,000.00 Department 165 - General Administration Totals $177,982.96 $194,859.00 $349,618.98 $312,526.09 $766,249.00 $226,061.43 $330,629.00 n `° Z W v 0 n rn y Run by Dora Cross on 03/31/2021 16:26:27 PM Page 24 of!;6 N Budget Worksheet Report CD K'ODrAR'r D N _ } Budget Year 2022 W 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : d 100 - General Fund WDepartment 172 - Parks & Recreation C: Personnel Services 80-172 410.110 Salaries 3,558.04 3,335.57 2,845.42 2,513.85 4,000.00 703.93 7,371.00 29-172 410.120 Temporary Help 4,095.14 13,963.64 8,513.13 9,751.06 25,000.00 5,706.59 22,594.00 a-172 410.130 Overtime 843.63 114.46 211.88 23.82 500.00 .00 .00 0- C/) Personnel Services Totals $8,496.81 $17,413.67 $11,570.43 $12,288.73 $29,500.00 $6,410.52 $29,965.00 0 Employee Benefits 190-172 420.110 Unemployment Taxes .44 .33 .31 .23 3.00 .06 3.00 O T00-172 420.120 FICA Taxes 650.09 1,323.80 875.62 906.48 2,269.00 508.42 2,292.00 0 JCA0-172 420.130 Group Insurance 1,883.06 1,369.21 833.09 559.25 1,200.00 1,329.10 6,660.00 IR0-172 420.140 Retirement 969.66 749.21 663.33 520.33 1,200.00 182.08 9,022.00 M-172 420.150 Workers Compensation 570.05 861.32 846.58 1,044.08 1,600.00 474.23 2,104.00 C Employee Benefits Totals $4,073.30 $4,303.87 $3,218.93 $3,030.37 $6,272.00 $2,493.89 $20,081.00 Q Professional Services &-172 430.140 Contracted Services .00 8,430.60 1,055.00 1,350.00 10,000.00 3,500.00 10,000.00 0 Professional Services Totals $0.00 $8,430.60 $1,055.00 $1,350.00 $10,000.00 $3,500.00 $10,000.00 In Support Goods & Services fi0-172 450.119 COVID-19 Expenditures .00 .00 .00 381.00 .00 .00 .00 M0-172 450.170 Machinery / Equipment <$5000 .00 65.50 13,685.97 .00 2,000.00 .00 2,000.00 190-172 450.230 Advertising / Hearings .00 286.45 .00 .00 .00 .00 .00 100-172 450.380 Snow Removal / Sanding 2,470.00 1,559.20 453.00 1,295.00 5,000.00 1,050.00 5,000.00 100-172 450.430 Maint & Repairs 15,132.06 36,092.11 27,112.74 14,217.22 19,000.00 90.60 20,000.00 Support Goods & Services Totals $17,602.06 $38,003.26 $41,251.71 $15,893.22 $26,000.00 $1,140.60 $27,000.00 Capital Outlay 100-172 470.100 Machinery / Equipment >$5000 .00 9,034.94 .00 .00 .00 .00 .00 Capital Outlay Totals $0.00 $9,034.94 $0.00 $0.00 $0.00 $0.00 $0.00 Department 172 - Parks & Recreation Totals $30,172.17 $77,186.34 $57,096.07 $32,562.32 $71,772.00 $13,545.01 $87,046.00 v m `° Z W ° o rn y Run by Dora Cross on 03/31/2021 16:26:27 PM Page 25 of!;6 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh R, A -i- Amni inh R1 irinat - I : 100 - General Fund WDepartment 175 - Emergency Preparedness C Personnel Services 00-175 410.110 Salaries 2,301.21 4,072.36 4,832.41 423.18 .00 608.68 9,300.00 29-175 410.120 Temporary Help 233.67 .00 .00 .00 .00 559.83 .00 110-175 410.130 Overtime .00 131.82 195.82 .00 .00 109.14 .00 0- C/) Personnel Services Totals $2,534.88 $4,204.18 $5,028.23 $423.18 $0.00 $1,277.65 $9,300.00 0 Employee Benefits 190-175 420.110 Unemployment Taxes .23 .42 .51 .03 .00 .06 1.00 O T00-175 420.120 FICA Taxes 193.74 314.66 370.94 31.03 .00 95.13 711.00 JCA0-175 420.130 Group Insurance 754.18 1,195.95 923.05 94.69 .00 382.37 3,330.00 IR0-175 420.140 Retirement 305.21 762.14 1,101.54 91.89 .00 157.17 2,800.00 1JY-175 420.150 Workers Compensation 171.77 170.31 241.27 33.73 .00 83.19 653.00 Employee Benefits Totals $1,425.13 $2,443.48 $2,637.31 $251.37 $0.00 $717.92 $7,495.00 Professional Services a-175 430.140 Contracted Services 12,888.50 21,917.08 400.00 .00 19,000.00 101.00 15,000.00 0 Professional Services Totals $12,888.50 $21,917.08 $400.00 $0.00 $19,000.00 $101.00 $15,000.00 nSupport Goods & Services ]E0-175 450.120 Printing / Binding .00 .00 .00 .00 .00 .00 2,500.00 80-175 450.170 Machinery / Equipment <$5000 1,589.58 .00 .00 .00 5,000.00 .00 .00 00-175 450.220 Insurance & Bonding 1,518.00 .00 .00 .00 .00 .00 .00 100-175 450.224 Insurance Coverage Discounts .00 (462.00) .00 .00 .00 .00 .00 100-175 450.226 Mobile Equipment Insurance .00 211.44 .00 .00 .00 .00 .00 100-175 450.230 Advertising / Hearings 968.25 723.64 .00 .00 .00 .00 .00 100-175 450.270 Continuing Education 1,930.74 .00 1,358.69 .00 6,000.00 .00 6,000.00 100-175 450.300 Travel / Per Diem 203.98 .00 1,063.57 .00 2,500.00 .00 2,500.00 100-175 450.340 Telephone 575.87 632.78 .00 .00 1,250.00 1,062.44 .00 n 100-iffi 450.350 Electricity 1,179.36 1,184.96 1,184.40 1,193.04 1,200.00 791.12 1,200.00 1005 450.360 Fuel - Heating .00 .00 654.74 1,217.96 .00 449.60 .00CD m 100-� 450.430 Maint & Repairs 11,046.22 12,182.52 1,979.66 1,393.02 5,000.00 .00 5,000.00 n p Support Goods & Services Totals $19,012.00 $14,473.34 $6,241.06 $3,804.02 $20,950.00 $2,303.16 $17,200.00 f0 Department 175 - Emergency Preparedness Totals $35,860.51 $43,038.08 $14,306.60 $4,478.57 $39,950.00 $4,399.73 $48,995.00 _ m 3 Run by Dora Cross on 03/31/2021 16:26:27 PM Page 26 of!;6 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am—nh Am—nh Ri A—i- Amni inh RI irinat - I : 100 - General Fund WDepartment 186 - Animal Control C: Contracted Services 80-186 444.110 Animal Control 109,415.00 114,015.00 115,800.00 118,700.00 118,715.00 118,700.00 121,000.00 C(D Contracted Services Totals $109,415.00 $114,015.00 $115,800.00 $118,700.00 $118,715.00 $118,700.00 $121,000.00 Iv Department 186 - Animal Control Totals $109,415.00 $114,015.00 $115,800.00 $118,700.00 $118,715.00 $118,700.00 $121,000.00 CL X �W n �' `° rn z 4 v O n rn y Run by Dora Cross on 03/31/2021 16:26:27 PM Page 27 of96 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am—nh Am—nh Ri A—i- Amni inh R1 irinat - I : 100 - General Fund WDepartment 190 - Education / Culture / Recreation n C CD rn z W o C: Contributions �. n rn 9-190 448.351 North Star PTA (Street Lights) 4,662.41 4,665.06 4,683.04 4,657.81 4,800.00 3,063.07 4,800.00 20-190 448.358 Karluk IRA Council 12,900.00 .00 15,789.00 15,789.00 16,000.00 15,789.00 15,789.00 j Contributions Totals $17,562.41 $4,665.06 $20,472.04 $20,446.81 $20,800.00 $18,852.07 $20,589.00 IL Department 190 - Education / Culture / Recreation $17,562.41 $4,665.06 $20,472.04 $20,446.81 $20,800.00 $18,852.07 $20,589.00 n Totals 3 O O 0 cn n -1 C D O C n C cn O n C CD rn z W o ° �. n rn Run by Dora Cross on 03/31/2021 16:26:27 PM Page 28 of96 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am—nh Am—nh Ri A—i- Amni inh RI irinat - I : 100 - General Fund W Department 191 - Kodiak College & Libraries n �' `°z rn W CO v C: Contributions n C rn _ y 86-191448.350 Kodiak College 84,000.00 60,000.00 50,000.00 50,000.00 50,000.00 50,000.00 .00 20-191448.900 Public Libraries 12,000.00 12,000.00 .00 .00 .00 .00 .00 j Contributions Totals $96,000.00 $72,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00 $0.00 CL Department 191 - Kodiak College & Libraries Totals $96,000.00 $72,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00 $0.00 n 3 O O 0 cn n -1 C CZ D O c n C to O n �' `°z rn W CO v O n C rn _ y Run by Dora Cross on 03/31/2021 16:26:27 PM Page 29 of.96 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri Ai i. Amni inh RI irinat - I : 100 - General Fund W Department 192 - Non Profit Funding C CD rn C v0 O C Sub -Department 110 - Health & Social Services rn Contributions Page 30 of96 $P-192-110 448.303 Providence / Safe Harbor 21,984.00 17,000.00 4,100.00 .00 .00 .00 .00 1�0-192-110 448.307 Humane Society .00 4,000.00 4,100.00 3,100.00 3,100.00 3,100.00 .00 a-192-110 448.308 Womens Resource Center 52,762.00 47,500.00 47,500.00 47,500.00 20,000.00 20,000.00 .00 }30-192-110 448.310 American Red Cross .00 .00 4,100.00 3,100.00 3,100.00 3,100.00 .00 180-192-1 10 448.314 Kodiak Baptist Mission 39,677.00 34,000.00 27,200.00 .00 .00 .00 .00 3&-192-110 448.319 Hospice of Kodiak .00 4,000.00 4,100.00 3,100.00 3,100.00 3,100.00 .00 56-192-110 448.322 Senior Citizen Support 30,778.00 26,000.00 20,800.00 21,000.00 20,000.00 20,000.00 .00 JRO-192-110 448.324 Hope Community Resources .00 4,000.00 .00 .00 3,100.00 3,100.00 .00 17"-192-110 448.380 Salvation Army 7,035.00 .00 12,000.00 20,000.00 20,000.00 20,000.00 .00 C 3D0-192-110 448.382 Brother Francis Shelter 49,403.00 43,000.00 34,400.00 36,000.00 20,000.00 20,000.00 .00 Contributions Totals $201,639.00 $179,500.00 $158,300.00 $133,800.00 $92,400.00 $92,400.00 $0.00 Support Goods & Services Q-192-110 450.119 COVID-19 Expenditures .00 .00 .00 .00 1,122,500.00 839,525.00 .00 Support Goods & Services Totals $0.00 $0.00 $0.00 $0.00 $1,122,500.00 $839,525.00 $0.00 C to Sub -Department to 110 - Health & Social Services $201,639.00 $179,500.00 $158,300.00 $133,800.00 $1,214,900.00 $931,925.00 $0.00 p' Totals n C CD rn C v0 O n CD rn Run by Dora Cross on 03/31/2021 16:26:27 PM Page 30 of96 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh R, Ai i- Amni inh RI irinat - I : 100 - General Fund WDepartment 192 - Non Profit Funding C Sub -Department 120 - Education / Culture & Recreation Contributions *-192-120 448.309 Alutiiq Museum & Archaeological .00 .00 .00 .00 4,000.00 4,000.00 .00 0) Repository ]K0-192-120 448.319 Hospice of Kodiak 9,673.00 .00 .00 .00 .00 .00 .00 W-192-120 448.325 Women's Bay Community Council .00 .00 .00 .00 1,000.00 1,000.00 .00 n D -192-120 448.330 KMXT Public Radio 7,123.00 4,000.00 4,100.00 3,700.00 4,000.00 4,000.00 .00 Q9-192-120 448.340 Kodiak Art Council .00 4,000.00 4,100.00 3,100.00 3,100.00 3,100.00 .00 1M-192-120 448.348 Head Start 6,331.00 .00 .00 .00 .00 .00 .00 UP -192-120 448.361 Kodiak Area Mentor Program .00 4,000.00 4,100.00 4,500.00 4,750.00 4,750.00 .00 20-192-120 448.366 KANA Family Center 9,233.00 4,000.00 4,100.00 3,100.00 3,100.00 3,100.00 .00 0-192-120 448.371 Kodiak Soil & Water Conservation .00 4,000.00 .00 3,100.00 3,100.00 3,100.00 .00 IW -192-120 448.381 Native Village of Port Lions .00 4,000.00 .00 .00 .00 .00 .00 430-192-120 448.400 Kodiak Rodeo & State Fair .00 4,000.00 .00 .00 4,000.00 4,000.00 .00 448.405 Kodiak Teen Court .00 .00 4,100.00 3,100.00 .00 .00 .00 ND -192-120 448.406 Kodiak Maritime Museum ND -192-120 .00 .00 .00 .00 4,000.00 4,000.00 .00 C W-192-120 448.409 Rural Alaska Community Action Program .00 .00 4,100.00 3,100.00 3,100.00 3,100.00 .00 56-192-120 448.410 St. Paul Preschool .00 .00 .00 .00 1,200.00 1,200.00 .00 100-192-120 448.910 Funding / Non -Profits .00 .00 .00 .00 1,000.00 .00 .00 Contributions Totals $32,360.00 $28,000.00 $24,600.00 $23,700.00 $36,350.00 $35,350.00 $0.00 support Goods & Services 100-192-120 450.119 COVID-19 Expenditures .00 .00 .00 .00 4,183,679.00 4,289,906.12 .00 Support Goods & Services Totals $0.00 $0.00 $0.00 $0.00 $4,183,679.00 $4,289,906.12 $0.00 Sub -Department 120 - Education / Culture & $32,360.00 $28,000.00 $24,600.00 $23,700.00 $4,220,029.00 $4,325,256.12 $0.00 Recreation Totals Department 192 - Non Profit Funding Totals $233,999.00 $207,500.00 $182,900.00 $157,500.00 $5,434,929.00 $5,257,181.12 $0.00 v m Z 41, 0 n rn y Run by Dora Cross on 03/31/2021 16:26:27 PM Page 31 of!;6 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am—nh Am—nh Ri A—i- Amni inh RI irinat - I : 100 - General Fund WDepartment 195 - Transfers Out C CD rn N v O n C Operating Transfers y Run by Dora Cross on 03/31/2021 16:26:27 PM 9-195 494.234 LEPC 18,337.65 .00 .00 13,000.00 10,072.00 10,072.00 .00 20-195 494.300 Transfer to Debt Service 635,113.00 .00 .00 .00 3,016,076.00 3,016,076.00 .00 110-195 494.450 Transfers to Capital Projects .00 403,958.00 .00 .00 .00 .00 .00 Q ]&-195 494.540 Hospital 305,000.00 .00 .00 .00 .00 .00 .00 n 3 Operating Transfers Totals $958,450.65 $403,958.00 $0.00 $13,000.00 $3,026,148.00 $3,026,148.00 $0.00 O O Department 195 - Transfers Out Totals $958,450.65 $403,958.00 $0.00 $13,000.00 $3,026,148.00 $3,026,148.00 $0.00 EXPENSE TOTALS $6,532,754.02 $6,398,475.82 $6,287,582.93 $5,744,905.01 $14,636,997.00 $12,279,084.39 $6,263,259.00 O c Fund 100 - General Fund Totals n REVENUE TOTALS -1 EXPENSE TOTALS C O Fund 100 - General Fund Totals D 00 c n C O O O $5,564,097.53 $7,270,304.83 $8,459,053.66 $6,479,029.03 $14,624,997.00 $12,270,500.66 $6,263,259.00 $6,532,754.02 $6,398,475.82 $6,287,582.93 $5,744,905.01 $14,636,997.00 $12,279,084.39 $6,263,259.00 ($968,656.49) $871,829.01 $2,171,470.73 $734,124.02 ($12,000.00) ($8,583.73) $0.00 n C CD rn N v O n rn y Run by Dora Cross on 03/31/2021 16:26:27 PM Page 32 of96 BOWOUOU Budget Worksheet Report Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Wed 201 - Education Support Fund (&EVENUE WDepartment 000 - Fund Revenues C Property Tax 01-000 311.100 Real Property Tax 8,892,817.69 8,152,773.08 8,819,222.59 9,408,641.49 8,451,080.00 8,354,304.45 9,878,334.00 24-000 311.200 Personal Property Tax 1,095,559.79 928,258.90 976,732.82 1,154,138.82 939,009.00 1,015,377.47 1,211,755.00 � Property Tax Totals $9,988,377.48 $9,081,031.98 $9,795,955.41 $10,562,780.31 $9,390,089.00 $9,369,681.92 $11,090,089.00 O- Non -Ad Valorem Taxes -000 313.110 O O AW Motor Vehicle Tax 235,176.84 237,894.52 220,392.44 .00 .00 .00 .00 Non Ad Valorem Taxes Totals $235,176.84 $237,894.52 $220,392.44 $0.00 $0.00 $0.00 $0.00 Department 000 - Fund Revenues Totals $10,223,554.32 $9,318,926.50 $10,016,347.85 $10,562,780.31 $9,390,089.00 $9,369,681.92 $11,090,089.00 REVENUE TOTALS $10,223,554.32 $9,318,926.50 $10,016,347.85 $10,562,780.31 $9,390,089.00 $9,369,681.92 $11,090,089.00 n `° Z W v 0 n rn y Run by Dora Cross on 03/31/2021 16:26:27 PM Page 33 of!;6 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 c 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : 201 - Education Support Fund WDepartment 201 - Education Support C Professional Services 01-201430.165 Providence Mental Health Services 400,000.00 .00 .00 .00 .00 .00 .00 (1) Professional Services Totals $400,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Audit Expense =-201 432.000 Audit Expenses 39,646.23 38,641.39 35,964.24 .00 42,500.00 6,600.00 42,500.00 vftii'-201432.100 Professional Services .00 .00 .00 44,637.56 .00 40,900.82 .00 �1-201 432.110 Out of Pocket Expenses 7,275.77 7,198.61 5,035.76 4,612.44 7,500.00 3,519.18 7,500.00 O Audit Expense Totals $46,922.00 $45,840.00 $41,000.00 $49,250.00 $50,000.00 $51,020.00 $50,000.00 �0. Support Goods &Services 2Q1-201 450.220 Insurance & Bonding 140,623.65 .00 .00 .00 .00 .00 .00 J1-201 450.221 Property Insurance 141,497.00 151,464.83 169,799.51 223,739.00 145,000.00 271,998.00 145,000.00 Z1-201 450.222 General Liablity Insurance Coverage .00 120,262.41 130,984.00 126,178.24 140,000.00 178,574.24 140,000.00 MI -201 450.224 Insurance Coverage Discounts .00 (38,292.00) (11,976.00) (12,180.00) .00 (32,245.00) .00 01-201450.226 Mobile Equipment Insurance .00 912.00 987.00 987.00 .00 987.00 .00 EI -201 450.320 Bad Debt Expense 48.13 .00 30,332.37 17,299.58 .00 38.90 .00 :81-201450.380 Snow Removal / Sanding 31,232.50 29,015.00 13,867.50 138,417.50 70,000.00 33,829.50 70,000.00 C N1-201 450.430 Maint & Repairs 10,587.61 9,901.00 20,770.00 29,374.77 25,000.00 2,060.00 25,000.00 O Support Goods & Services Totals $323,988.89 $273,263.24 $354,764.38 $523,816.09 $380,000.00 $455,242.64 $380,000.00 = Equipment 201-201466.220 Auto Liability Insurance .00 18,376.20 18,286.00 17,956.27 .00 19,743.18 .00 Equipment Totals $0.00 $18,376.20 $18,286.00 $17,956.27 $0.00 $19,743.18 $0.00 Operating Transfers 201-201494.290 KIBSD 9,506,637.24 9,040,020.56 9,506,525.99 9,880,420.98 8,960,089.00 6,720,066.76 10,660,089.00 Operating Transfers Totals $9,506,637.24 $9,040,020.56 $9,506,525.99 $9,880,420.98 $8,960,089.00 $6,720,066.76 $10,660,089.00 Department 201 - Education Support Totals $10,277,548.13 $9,377,500.00 $9,920,576.37 $10,471,443.34 $9,390,089.00 $7,246,072.58 $11,090,089.00 EXPENSE TOTALS $10,277,548.13 $9,377,500.00 $9,920,576.37 $10,471,443.34 $9,390,089.00 $7,246,072.58 $11,090,089.00 Fund 201 - Education Support Fund Totals m ( REVENUE TOTALS $10,223,554.32 $9,318,926.50 $10,016,347.85 $10,562,780.31 $9,390,089.00 $9,369,681.92 $11,090,089.00-1:11 Z � EXPENSE TOTALS $10,277,548.13 $9,377,500.00 $9,920,576.37 $10,471,443.34 $9,390,089.00 $7,246,072.58 $11,090,089.00 v O Fund 201 - Education Support Fund Totals ($53,993.81) ($58,573.50) $95,771.48 $91,336.97 $0.00 $2,123,609.34 $0.00 rn � m 3 Run by Dora Cross on 03/31/2021 16:26:27 PM Page 34 of!;6 210 - Land Sales BOWOUOU Department 000 - Fund Revenues W Licenses & Permits 80-000 322.100 Annual Use Permit RO-000 322.180 Electric Permit 12,879.44 Licenses & Permits Totals State Shared Revenues _C(/)-, fo-000 335.190 PERS on Behalf Payment 0 State Shared Revenues Totals a Interest Earnings 0-000 361.100 Interest Earnings F5 2* -000 361.300 Change in Fair Market Value Interest Earnings Totals - Rents & Royalties Budget Worksheet Report Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh R, A -i- Amni inh R1 irinat - I : 4,800.00 7,210.00 6,000.00 6,000.00 6,000.00 7,200.00 6,000.00 1,000.00 .00 .00 .00 .00 .00 .00 $5,800.00 $7,210.00 $6,000.00 $6,000.00 $6,000.00 $7,200.00 $6,000.00 3,780.12 2,466.95 3,311.55 .00 .00 .00 .00 $3,780.12 $2,466.95 $3,311.55 $0.00 $0.00 $0.00 $0.00 17,229.97 28,127.06 31,147.86 32,587.40 25,000.00 15,140.74 18,000.00 (9,056.98) (20,954.02) 21,013.20 5,175.93 .00 (11,501.53) .00 $8,172.99 $7,173.04 $52,161.06 $37,763.33 $25,000.00 $3,639.21 $18,000.00 D -000 363.500 Gravel Sales 24,487.94 12,879.44 11,048.80 85,775.40 8,000.00 .00 8,000.00 D Rents & Royalties Totals $24,487.94 $12,879.44 $11,048.80 $85,775.40 $8,000.00 $0.00 $8,000.00 CQ Land Sales Activity -000 371.100 Land Sale - Principal 127,456.97 196,946.93 58,725.40 16,762.41 17,907.00 14,275.46 21,100.00 371.110 Land Sale - Interest 18,363.16 27,954.71 17,950.16 12,139.59 10,557.00 8,056.54 8,500.00 ��@0-000 PhD -000 371.120 Land Sale - Fees & Penalties 1,350.70 .00 .00 .00 .00 .00 .00 C73 ) Land Sales Activity Totals $147,170.83 $224,901.64 $76,675.56 $28,902.00 $28,464.00 $22,332.00 $29,600.00 Miscellaneous - Classified 210-000 380.170 Other 2,091,923.70 2,500.00 225.00 1,217.00 .00 .00 .00 210-000 380.190 Land Leases 90.00 80.00 80.00 90.00 80.00 110.00 80.00 Miscellaneous - Classified Totals $2,092,013.70 $2,580.00 $305.00 $1,307.00 $80.00 $110.00 $80.00 Other Financing Sources 210-000 389.100 Use of Fund Balance .00 .00 .00 .00 238,623.00 .00 .00 Other Financing Sources Totals $0.00 $0.00 $0.00 $0.00 $238,623.00 $0.00 $0.00 Department 000 - Fund Revenues Totals $2,281,425.58 $257,211.07 $149,501.97 $159,747.73 $306,167.00 $33,281.21 $61,680.00 n REVENUE TOTALS $2,281,425.58 $257,211.07 $149,501.97 $159,747.73 $306,167.00 $33,281.21 $61,680.00 m co Z cri v O n rn y Run by Dora Cross on 03/31/2021 16:26:27 PM Page 35 of!;6 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : 210 - Land Sales WDepartment 231 - Resource Management C: Personnel Services &-231410.110 Salaries 86,891.48 80,829.87 63,874.56 753.43 .00 .00 .00 a-231 410.120 Temporary Help .00 .00 133.69 476.28 .00 .00 .00 &-231410.130 Overtime 5,032.10 2,656.25 1,294.68 .00 .00 .00 .00 Q 2&-231410.140 Allocated Salaries 24,000.00 4,000.00 4,000.00 .00 1,000.00 1,000.00 1,000.00 g0-231 410.152 Cell Phone Stipend .00 .00 848.39 .00 .00 .00 .00 O Personnel Services Totals O_ $115,923.58 $87,486.12 $70,151.32 $1,229.71 $1,000.00 $1,000.00 $1,000.00 Employee Benefits 3-231420.110 Unemployment Taxes 8.54 8.20 6.30 .07 .00 .00 .00 g0-231 420.120 FICA Taxes 6,912.66 6,157.08 4,866.67 101.27 .00 .00 .00 -231420.130 Group Insurance 21,591.82 26,205.97 20,588.57 261.46 .00 .00 .00 0-231420.140 Retirement 22,506.18 20,858.91 15,966.12 165.20 .00 .00 .00 99-231420.150 Workers Compensation 5,014.72 798.19 4,097.18 87.22 .00 .00 .00 (Q Employee Benefits Totals $56,033.92 $54,028.35 $45,524.84 $615.22 $0.00 $0.00 $0.00 9Professional Services &-231 430.140 Contracted Services 319,111.15 176,655.10 22,502.64 2,905.00 .00 .00 .00 C U) Professional Services Totals $319,111.15 $176,655.10 $22,502.64 $2,905.00 $0.00 $0.00 $0.00 p' Support Goods & Services a-231 450.100 Office Supplies 112.80 55.64 .00 .00 .00 .00 .00 210-231450.110 Operating Supplies 1,102.22 191.04 134.53 .00 .00 .00 .00 210-231450.120 Printing / Binding 1,709.75 61.79 .00 .00 .00 .00 .00 210-231450.140 Dues / Books / Periodicals .00 .00 147.50 .00 .00 .00 .00 210-231450.160 Furniture / Fixtures 3,450.37 .00 .00 .00 .00 .00 .00 210-231450.220 Insurance & Bonding 2,763.83 .00 .00 .00 .00 .00 .00 210-231450.222 General Liablity Insurance Coverage .00 1,284.26 1,115.35 341.02 .00 445.06 .00 n 210-21 450.224 Insurance Coverage Discounts .00 (341.00) (292.45) (87.00) .00 (114.00) .00 ^ 2101 450.230 Advertising / Hearings 2,120.25 81.00 .00 .00 .00 .00 .00CD m 210-d31 450.240 Filing / Record Fees 5,935.50 600.00 1,065.00 350.00 .00 .00 .00 v 210-�3, 1 450.251 Miscellaneous .00 .00 28,140.00 .00 .00 .00 .00% n 210-1450.260 Surveys 28,785.00 6,555.00 .00 13,725.00 45,000.00 .00 .00 210-231450.263 Real Property Cleanup 5,375.00 5,182.50 8,500.00 00 .00 4,713.95 .00 m 210-231450.270 Continuing Education 24.99 .00 .00 .00 .00 .00 .00 Run by Dora Cross on 03/31/2021 16:26:27 PM Page 36 of!;6 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh RI irinat - I : 210 - Land Sales WDepartment 231 - Resource Management C Support Goods & Services 8-231450.290 Recruit / Relocation 354.17 6,135.42 .00 .00 .00 .00 .00 99-231450.330 Rent 9,700.00 11,986.00 10,168.00 10,168.00 10,167.00 7,625.25 10,168.00 &-231450.340 Telephone 153.84 90.00 116.07 8.19 .00 .00 .00 Q 2d6-231 450.430 Maint & Repairs .00 245.00 7,040.50 189.79 .00 .00 .00 ;S0-231450.450 Contingencies .00 .00 .00 .00 .00 .00 50,512.00 $0-231450.485 n Town Meeting Costs .00 192.02 .00 .00 .00 .00 .00 0 y Support Goods& Services Totals $61,587.72 $32,318.67 $56,134.50 $24,695.00 $55,167.00 $12,670.26 $60,680.00 cOperating Transfers g9-231 494.410 Capital Project - KIB .00 .00 .00 .00 250,000.00 .00 .00 *-231494.455 Transfer to Fund 455 .00 .00 .00 100,000.00 .00 .00 .00 ;g0-231494.540 Hospital 650,000.00 .00 .00 .00 .00 .00 .00 Operating Transfers Totals $650,000.00 $0.00 $0.00 $100,000.00 $250,000.00 $0.00 $0.00 7 Department 231 - Resource Management Totals $1,202,656.37 $350,488.24 $194,313.30 $129,444.93 $306,167.00 $13,670.26 $61,680.00 EXPENSE TOTALS $1,202,656.37 $350,488.24 $194,313.30 $129,444.93 $306,167.00 $13,670.26 $61,680.00 W 0 C Fund 210 - Land Sales Totals 0) REVENUE TOTALS $2,281,425.58 $257,211.07 $149,501.97 $159,747.73 $306,167.00 $33,281.21 $61,680.00 0 EXPENSE TOTALS $1,202,656.37 $350,488.24 $194,313.30 $129,444.93 $306,167.00 $13,670.26 $61,680.00 Fund 210 - Land Sales Totals $1,078,769.21 ($93,277.17) ($44,811.33) $30,302.80 $0.00 $19,610.95 $0.00 n v `° m Z o ° rn y Run by Dora Cross on 03/31/2021 16:26:27 PM Page 37 of!;6 BOWOUOU 220 - Building & Grounds Department 000 - Fund Revenues W Federal Grants Budget Worksheet Report Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh R, A -i- Amni inh R1 irinat - I : 26-000 331.119 CORONAVIRUS Relief Fund (CARES ACT) .00 .00 .00 12,666.58 .00 46,985.63 .00 (1) Federal Grants Totals $0.00 $0.00 $0.00 $12,666.58 $0.00 $46,985.63 $0.00 �State Shared Revenues 220-000 335.190 PERS on Behalf Payment 2,744.66 2,120.72 4,165.16 5,087.22 6,974.00 4,496.62 6,266.00 C/) State Shared Revenues Totals $2,744.66 $2,120.72 $4,165.16 $5,087.22 $6,974.00 $4,496.62 $6,266.00 0 Interest Earnings Z-000 361.100 Interest Earnings 8,902.52 15,350.15 29,241.67 31,718.72 10,000.00 15,763.46 5,000.00 M-000 361.300 Change in Fair Market Value (5,270.95) (10,714.89) 22,444.82 5,067.61 .00 (12,218.50) .00 Interest Earnings Totals $3,631.57 $4,635.26 $51,686.49 $36,786.33 $10,000.00 $3,544.96 $5,000.00 On Rents & Royalties Z21-000 363.100 KIB 376,985.00 454,985.00 414,724.00 414,724.00 414,724.00 311,313.07 414,724.00 C Z70-000 363.110 City of Kodiak 143,760.70 152,988.00 152,988.00 172,840.80 172,836.00 149,929.34 190,125.00 220-000 363.120 KIBSD 221,232.00 221,232.00 221,232.00 205,320.00 202,137.00 151,603.20 202,128.00 2&-000 363.140 Borough Building - Annex .00 7,198.80 18,792.00 13,837.60 13,387.00 9,442.40 13,387.00 50-000 363.210 Land Sale Fund 9,700.00 11,986.00 10,168.00 10,168.00 10,167.00 7,625.25 10,167.00 U) Rents & Royalties Totals $751,677.70 $848,389.80 $817,904.00 $816,890.40 $813,251.00 $629,913.26 $830,531.00 T. Miscellaneous - Classified -90-000 380.170 Other .00 .00 .00 .00 .00 24,735.00 .00 220-000 380.261 Other 120.00 122.00 4,215.10 594.82 .00 .00 .00 Miscellaneous - Classified Totals $120.00 $122.00 $4,215.10 $594.82 $0.00 $24,735.00 $0.00 Other Financing Sources 220-000 389.100 Use of Fund Balance .00 .00 .00 .00 403,157.00 .00 846,596.00 Other Financing Sources Totals $0.00 $0.00 $0.00 $0.00 $403,157.00 $0.00 $846,596.00 Operating Transfers In 220-000 391.276 Facilities Fund .00 10,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 n 220-BbO 391.469 Transfer from Renewal & Replacement .00 .00 336,370.00 .00 .00 .00 .00 Operating Transfers In Totals $0.00 $10,000.00 $341,370.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00CD m Department 000 - Fund Revenues Totals $758,173.93 $865,267.78 $1,219,340.75 $877,025.35 $1,238,382.00 $714,675.47 $1,693,393.00 ao REVENUE TOTALS $758,173.93 $865,267.78 $1,219,340.75 $877,025.35 $1,238,382.00 $714,675.47 $1,693,393.00 o n rn y Run by Dora Cross on 03/31/2021 16:26:27 PM Page 38 of!;6 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh R, A -i- Amni inh R1 irinat - I : 220 - Building & Grounds WDepartment 232 - Borough Building C Personnel Services 20-232 410.110 Salaries 153,414.64 66,361.90 55,489.77 55,803.29 105,350.00 43,431.07 53,221.00 20-232 410.120 Temporary Help 6,433.65 6,107.80 22,872.11 26,391.49 .00 20,878.43 22,594.00 2%0-232 410.130 Overtime 1,260.67 639.57 1,518.29 2,157.96 .00 866.87 .00 Q- 2CW-232 410.152 Cell Phone Stipend .00 .00 1,200.00 1,200.00 1,200.00 900.00 1,440.00 vn Personnel Services Totals $161,108.96 $73,109.27 $81,080.17 $85,552.74 $106,550.00 $66,076.37 $77,255.00 3 0 Employee Benefits 220-232 420.110 Unemployment Taxes 14.96 6.45 5.65 5.73 11.00 4.38 8.00 0 :M5-232 420.120 FICA Taxes 12,055.30 5,417.33 6,044.64 6,440.32 8,059.00 4,883.74 5,800.00 R9-232 420.130 Group Insurance 40,436.11 21,833.13 20,514.28 19,219.57 44,590.00 22,616.46 3,330.00 *-232 420.140 Retirement 36,732.64 14,752.46 15,233.00 17,213.71 30,151.00 13,749.68 22,828.00 *-232 420.150 Workers Compensation 10,417.08 6,693.01 7,547.36 7,668.57 5,889.00 4,618.70 4,962.00 Employee Benefits Totals $99,656.09 $48,702.38 $49,344.93 $50,547.90 $88,700.00 $45,872.96 $36,928.00 7 (Q Professional Services M-232 430.140 Contracted Services 32,627.43 10,235.00 78,464.69 34,580.98 .00 1,712.75 50,000.00 n Professional Services Totals $32,627.43 $10,235.00 $78,464.69 $34,580.98 $0.00 $1,712.75 $50,000.00 (n Support Goods & Services 490-232 450.100 Office Supplies 170.94 259.31 234.54 124.58 250.00 645.29 250.00 2z0-232 450.119 COVID-19 Expenditures .00 .00 .00 6,938.24 .00 43,336.87 .00 220-232 450.120 Printing / Binding .00 .00 3.00 .00 .00 .00 .00 220-232 450.160 Furniture / Fixtures 792.83 .00 .00 .00 500.00 95.16 5,000.00 220-232 450.170 Machinery / Equipment <$5000 805.60 2,915.90 1,399.37 666.96 2,500.00 655.22 2,500.00 220-232 450.220 Insurance & Bonding (12,623.07) .00 .00 .00 .00 .00 .00 220-232 450.221 Property Insurance .00 8,474.00 9,215.00 12,413.00 9,500.00 15,250.00 9,500.00 220-232 450.222 General Liablity Insurance Coverage .00 1,890.72 1,707.43 1,291.27 1,900.00 1,173.80 1,900.00 n 220-2�12 450.224 Insurance Coverage Discounts .00 (2,730.00) (2,783.74) (3,478.00) .00 (3,995.00) .00 2202 450.230 Advertising / Hearings 266.22 .00 .00 .00 350.00 .00 350.00 m 220-d32 450.270 Continuing Education .00 76.50 50.00 2,000.00 2,000.00 294.50 3,500.00 v co 220-42 450.300 Travel / Per Diem .00 .00 .00 .00 1,500.00 .00 .00% n 220-W2 450.340 Telephone 559.00 2.86 88.06 210.77 600.00 45.38 60.00 220-232 450.350 Electricity 42,554.06 51,042.52 50,689.41 51,000.83 45,000.00 33,730.40 52,000.00 m 220-232 450.360 Fuel - Heating 31,828.45 45,810.63 47,860.59 42,549.65 50,000.00 24,576.88 35,000.00 Run by Dora Cross on 03/31/2021 16:26:28 PM Page 39 of!;b Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh RI irinat - I : 220 - Building & Grounds W Department 232 - Borough Building C: Support Goods & Services ge-232 450.365 Fuel - Vehicle 1,989.77 1,140.18 1,622.32 1,650.39 1,500.00 1,084.96 1,500.00 20-232 450.370 Water & Sewer 11,989.48 12,522.69 13,060.43 13,515.10 15,000.00 8,201.18 15,000.00 ;%0-232 450.380 Snow Removal / Sanding 19,894.96 7,084.75 1,400.00 12,104.50 25,000.00 3,750.00 25,000.00 Q 2&-232 450.390 Refuse Collection - Disposal 6,033.60 6,930.25 7,330.92 7,498.80 8,000.00 4,934.15 8,000.00 4-232 450.410 Janitorial Services 50,160.00 50,585.00 53,271.50 54,017.96 55,000.00 35,946.64 65,000.00 �0 232 450.430 Maint & Repairs 63,174.11 34,817.72 29,075.80 29,376.47 913.00 4,650.65 75,000.00 z�-232 450.440 Auto Maint & Repairs 1,899.03 4,022.86 447.19 2,242.33 5,000.00 204.87 5,000.00 -232 450.450 Contingencies .00 .00 .00 .00 40,032.00 .00 .00 220-232 450.461 Safety Supplies 2,574.52 62.46 1,086.81 1,873.60 2,000.00 591.82 2,000.00 2M-232 450.510 Recycling Services 2,200.00 2,080.00 2,350.00 2,550.00 3,000.00 1,700.00 3,000.00 TO -232 450.540 Clothing Allowance .00 .00 285.00 475.00 1,500.00 940.23 1,500.00 -T Support Goods & Services Totals $224,269.50 $226,988.35 $218,393.63 $239,021.45 $271,045.00 $177,813.00 $311,060.00 (a Capital Projects 2F-232 452.110 Administration .00 .00 1,456.81 6.10 .00 .00 .00 n C Capital Projects Totals $0.00 $0.00 $1,456.81 $6.10 $0.00 $0.00 $0.00 In Capital Outlay 230-232 470.100 Machinery / Equipment >$5000 .00 .00 .00 .00 150,000.00 3,695.00 .00 220-232 470.110 Furniture / Fixtures .00 .00 807.87 69.03 .00 .00 .00 220-232 470.140 Remodel / Renovation 6,288.23 .00 3,500.00 .00 150,000.00 .00 50,000.00 Capital Outlay Totals $6,288.23 $0.00 $4,307.87 $69.03 $300,000.00 $3,695.00 $50,000.00 Operating Transfers 220-232 494.450 Transfers to Capital Projects .00 137,000.00 115,000.00 100,000.00 .00 .00 500,000.00 220-232 494.469 Renewal & Replacement Projects 336,370.00 .00 .00 50,000.00 .00 .00 .00 Operating Transfers Totals $336,370.00 $137,000.00 $115,000.00 $150,000.00 $0.00 $0.00 $500,000.00 Department 232 - Borough Building Totals $860,320.21 $496,035.00 $548,048.10 $559,778.20 $766,295.00 $295,170.08 $1,025,243.00 ^ C rn `° z C) ° �. n rn y Run by Dora Cross on 03/31/2021 16:26:28 PM Page 40 of.96 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh R, A -i- Amni inh R1 irinat - I : 220 - Building & Grounds WDepartment 233 - Mental Health Center C: Personnel Services jf�-233 410.110 Salaries 84.83 123.42 1,031.85 203.44 2,000.00 24.42 .00 a-233 410.120 Temporary Help .00 .00 .00 .00 1,000.00 .00 .00 3 Personnel Services Totals $84.83 $123.42 $1,031.85 $203.44 $3,000.00 $24.42 $0.00 CL Employee Benefits -233 420.110 Unemployment Taxes .01 .01 .11 .02 .00 .00 .00 �0-233 420.120 FICA Taxes 6.32 8.99 76.00 14.89 .00 1.80 .00 O 220-233 420.130 Group Insurance 41.63 85.28 183.01 .00 .00 18.61 .00 -233 420.140 Retirement 18.68 26.59 224.12 44.76 .00 5.24 .00 g0-233 420.150 Workers Compensation 7.06 8.39 103.58 16.21 .00 1.71 .00 Employee Benefits Totals $73.70 $129.26 $586.82 $75.88 $0.00 $27.36 $0.00 Professional Services Sap -233 430.140 Contracted Services .00 .00 .00 .00 15,000.00 .00 15,000.00 (Q Professional Services Totals $0.00 $0.00 $0.00 $0.00 $15,000.00 $0.00 $15,000.00 0 Support Goods & Services a6-233 450.220 Insurance & Bonding 2,889.81 .00 .00 .00 .00 .00 .00 f0-233 450.221 Property Insurance .00 3,319.00 3,615.00 4,931.00 3,700.00 6,073.00 3,700.00 491-233 450.222 General Liablity Insurance Coverage .00 112.97 59.20 144.41 100.00 157.67 150.00 2z0-233 450.224 Insurance Coverage Discounts .00 (903.00) (931.78) (1,288.00) .00 (1,509.00) .00 220-233 450.380 Snow Removal / Sanding .00 .00 .00 480.00 .00 .00 .00 220-233 450.430 Maint & Repairs 3,558.60 21,590.00 24,855.00 .00 25,000.00 .00 25,000.00 Support Goods & Services Totals $6,448.41 $24,118.97 $27,597.42 $4,267.41 $28,800.00 $4,721.67 $28,850.00 Department 233 - Mental Health Center Totals $6,606.94 $24,371.65 $29,216.09 $4,546.73 $46,800.00 $4,773.45 $43,850.00 n v m `° Z 0 y rn y Run by Dora Cross on 03/31/2021 16:26:28 PM Page 41 ofPb Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri Ai i. Amni inh R1 irinat - I : 220 - Building & Grounds W Department 234 - School Buildings - KIB n C CD rn o ° C Sub -Department 215 - Larsen Bay Closed School n CD rn support Goods & Services Run by Dora Cross on 03/31/2021 16:26:28 PM Page 42 of96 (a a-234-215 450.222 General Liablity Insurance Coverage .00 .00 .00 215.67 .00 191.17 .00 :�0-234-215 450.224 Insurance Coverage Discounts .00 .00 .00 (55.00) .00 (48.00) .00 R0-234-215 450.350 Electricity .00 .00 15,334.96 27,279.44 15,000.00 9,763.91 25,000.00 230-234-215 450.360 Fuel- Heating .00 .00 3,620.18 12,032.76 5,000.00 7,182.62 15,000.00 2010-234-215 450.370 Water & Sewer .00 .00 389.75 1,433.75 1,000.00 860.25 2,000.00 2&-234-215 450.430 Maint & Repairs .00 .00 5,537.42 25,161.84 50,000.00 10,521.23 50,000.00 support Goods & Services Totals $0.00 $0.00 $24,882.31 $66,068.46 $71,000.00 $28,471.18 $92,000.00 n• Other 2,b-234-215 468.110 Contracted Services .00 .00 .00 .00 10,000.00 .00 10,000.00 Other Totals $0.00 $0.00 $0.00 $0.00 $10,000.00 $0.00 $10,000.00 Q- Sub -Department 215 - Larsen Bay Closed School $0.00 $0.00 $24,882.31 $66,068.46 $81,000.00 $28,471.18 $102,000.00 D Totals c 0 C to O n C CD rn o ° �. n CD rn Run by Dora Cross on 03/31/2021 16:26:28 PM Page 42 of96 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh R, Ai i. Amni inh R1 irinat - I : 220 - Building & Grounds W Department 234 - School Buildings - KIB C Sub -Department 225 - Karluk Closed School C ( Personnel Services a-234-225 410.110 Salaries .00 .00 .00 .00 .00 266.90 .00 lv 3 Personnel Services Totals $0.00 $0.00 $0.00 $0.00 $0.00 $266.90 $0.00 C2 Employee Benefits $0.00 $0.00 $50,000.00 $0.00 $0.00 $0.00 $0.00 -M-234-225 420.110 Unemployment Taxes .00 .00 .00 .00 .00 .03 .00 7$0-234-225 420.120 FICA Taxes .00 .00 .00 .00 .00 19.67 .00 R0-234-225 420.130 Group Insurance .00 .00 .00 .00 .00 60.92 .00 ;F-234-225 420.140 Retirement .00 .00 .00 .00 .00 57.66 .00 a-234-225 420.150 Workers Compensation .00 .00 .00 .00 .00 18.74 .00 n n rn Employee Benefits Totals $0.00 $0.00 $0.00 $0.00 $0.00 $157.02 $0.00 � Support Goods & Services 7�0-234-225 450.222 General Liablity Insurance Coverage .00 .00 71.28 239.68 .00 308.30 .00 80-234-225 450.224 Insurance Coverage Discounts .00 .00 (18.67) (61.00) .00 (78.00) .00 2D-234-225 450.350 Electricity .00 .00 42,114.36 49,039.20 40,000.00 34,934.90 55,000.00 ;R0-234-225 450.360 Fuel - Heating .00 .00 33,537.50 39,244.75 45,000.00 25,781.25 50,000.00 f50-234-225 450.370 Water & Sewer .00 .00 800.00 1,200.00 1,200.00 800.00 2,000.00 cn B0-234-225 450.430 Maint & Repairs .00 .00 .00 4,813.16 75,000.00 2,996.85 75,000.00 73 Support Goods & Services Totals $0.00 $0.00 $76,504.47 $94,475.79 $161,200.00 $64,743.30 $182,000.00 Other 220-234-225 468.110 Contracted Services .00 .00 .00 .00 25,000.00 .00 25,000.00 Other Totals $0.00 $0.00 $0.00 $0.00 $25,000.00 $0.00 $25,000.00 Operating Transfers 220-234-225 494.469 Renewal & Replacement Projects .00 .00 50,000.00 .00 .00 .00 .00 Operating Transfers Totals $0.00 $0.00 $50,000.00 $0.00 $0.00 $0.00 $0.00 Sub -Department 225 - Karluk Closed School Totals $0.00 $0.00 $126,504.47 $94,475.79 $186,200.00 $65,167.22 $207,000.00 v Department 234 - School Buildings - KIB Totals $0.00 $0.00 $151,386.78 $160,544.25 $267,200.00 $93,638.40 $309,000.00 m `°cri Z W n rn y Run by Dora Cross on 03/31/2021 16:26:28 PM Page 43 of!;b Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : 220 - Building & Grounds W Department 235 - School Buildings - Major Repairs n �' `° rn Z v C Personnel Services n C rn _ y 20-235 410.110 Salaries .00 .00 .00 .00 3,000.00 .00 .00 ((D Personnel Services Totals $0.00 $0.00 $0.00 $0.00 $3,000.00 $0.00 $0.00 0) Professional Services 2M-235 430.140 Contracted Services 2,431.00 31,062.44 7,650.00 510.00 20,000.00 12,080.10 125,000.00 0 Professional Services Totals n $2,431.00 $31,062.44 $7,650.00 $510.00 $20,000.00 $12,080.10 $125,000.00 = Support Goods & Services &-235 450.220 Insurance & Bonding 71.03 .00 .00 .00 .00 .00 .00 -235 450.222 General Liablity Insurance Coverage .00 109.00 91.74 167.93 .00 160.56 200.00 F 2210-235 450.224 Insurance Coverage Discounts .00 (29.00) (24.17) (43.00) .00 (40.00) .00 90-235 450.430 Maint & Repairs 3,590.00 .00 32,000.00 8,988.00 25,000.00 .00 55,000.00 Support Goods & Services Totals $3,661.03 $80.00 $32,067.57 $9,112.93 $25,000.00 $120.56 $55,200.00 Q Department 235 - School Buildings - Major Repairs $6,092.03 $31,142.44 $39,717.57 $9,622.93 $48,000.00 $12,200.66 $180,200.00 7 Totals c n C Cn O n �' `° rn Z v 0 n C rn _ y Run by Dora Cross on 03/31/2021 16:26:28 PM Page 44 of.96 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : 220 - Building & Grounds W Department 237 - Chiniak School n �' `° rn ZCn Cn v C Professional Services n C rn _ y 20-237 430.140 Contracted Services .00 .00 .00 .00 .00 .00 25,000.00 (�D Professional Services Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $25,000.00 iv Support Goods & Services =-237 450.220 Insurance & Bonding .00 .00 .00 191.67 .00 191.00 .00 *-237 450.224 Insurance Coverage Discounts .00 .00 .00 (49.00) .00 (46.00) .00 90-237 450.430 Maint & Repairs 535.00 .00 .00 .00 75,000.00 .00 75,000.00 O Support Goods & Services Totals $535.00 $0.00 $0.00 $142.67 $75,000.00 $145.00 $75,000.00 Operating Transfers 2210-237 494.455 Transfer to Fund 455 .00 .00 .00 75,000.00 .00 .00 .00 Operating Transfers Tota/s $0.00 $0.00 $0.00 $75,000.00 $0.00 $0.00 $0.00 Department 237 - Chiniak School Totals $535.00 $0.00 $0.00 $75,142.67 $75,000.00 $145.00 $100,000.00 CZ D 0� c n C Cn O n �' `° rn ZCn Cn v 0 n C rn _ y Run by Dora Cross on 03/31/2021 16:26:28 PM Page 45 of.96 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : 220 - Building & Grounds WDepartment 238 - Various Borough Buildings C: Personnel Services jf�-238 410.110 Salaries .00 .00 63.52 608.16 1,000.00 90.14 .00 a-238 410.120 Temporary Help .00 .00 66.85 522.23 .00 4,261.37 .00 O Personnel Services Totals $0.00 $0.00 $130.37 $1,130.39 $1,000.00 $4,351.51 $0.00 Q Employee Benefits Fund 220 - Building & Grounds Totals ($119,446.33) $310,534.12 $443,064.31 $61,622.39 ($913.00) $295,174.28 $0.00 n -238 420.110 Unemployment Taxes .00 .00 .01 .04 .00 .00 .00 �0-238 420.120 FICA Taxes .00 .00 9.76 76.08 .00 334.40 .00 O Run by Dora Cross on 03/31/2021 16:26:28 PM Page 46 of!;6 220-238 420.130 Group Insurance .00 .00 46.71 172.82 .00 1,178.38 .00 -238 420.140 Retirement .00 .00 13.99 131.70 .00 19.70 .00 g0-238 420.150 Workers Compensation .00 .00 13.09 79.95 .00 313.24 .00 Employee Benefits Totals $0.00 $0.00 $83.56 $460.59 $0.00 $1,845.72 $0.00 q Support Goods & Services 2ap-238 450.222 General Liablity Insurance Coverage .00 .00 23.45 117.46 .00 135.52 100.00 j20-238 450.224 Insurance Coverage Discounts .00 .00 (6.14) (30.00) .00 (35.00) .00 gy.@-238 450.330 Rent .00 .00 1,400.00 .00 .00 (800.00) .00 SO -238 450.430 Maint & Repairs 4,066.08 3,184.57 6,276.66 4,089.74 35,000.00 8,075.85 35,000.00 C (n Support Goods& Services Totals $4,066.08 $3,184.57 $7,693.97 $4,177.20 $35,000.00 $7,376.37 $35,100.00 O Department 238 - Various Borough Buildings Totals $4,066.08 $3,184.57 $7,907.90 $5,768.18 $36,000.00 $13,573.60 $35,100.00 -S EXPENSE TOTALS $877,620.26 $554,733.66 $776,276.44 $815,402.96 $1,239,295.00 $419,501.19 $1,693,393.00 Fund 220 - Building & Grounds Totals REVENUE TOTALS $758,173.93 $865,267.78 $1,219,340.75 $877,025.35 $1,238,382.00 $714,675.47 $1,693,393.00 EXPENSE TOTALS $877,620.26 $554,733.66 $776,276.44 $815,402.96 $1,239,295.00 $419,501.19 $1,693,393.00 Fund 220 - Building & Grounds Totals ($119,446.33) $310,534.12 $443,064.31 $61,622.39 ($913.00) $295,174.28 $0.00 n v m `°cri Z 0') ° rn y Run by Dora Cross on 03/31/2021 16:26:28 PM Page 46 of!;6 K'0DK'ID BO OU H Budget Worksheet Report Budget Year 2022 S 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's 9k Account Account Description Amount Amount Amount Amount Budoet Amount Budoet - L2 i Wd 234 - LEPC n �' `°Z rn `4 v ja2EVENUE n C rn _ y I Department 000 - Fund Revenues Run by Dora Cross on 03/31/2021 16:26:28 PM Page 47 of.96 WFederal Grants ,24-000 331.119 CORONAVIRUS Relief Fund (CARES ACT) .00 .00 .00 .00 .00 2,665.82 .00 (�D Federal Grants Totals $0.00 $0.00 $0.00 $0.00 $0.00 $2,665.82 $0.00 State of Alaska Grants D4-000 334.124 LEPC Grant 13,755.67 15,500.00 16,144.09 .00 .00 211.00 .00 0 State of Alaska Grants Totals n $13,755.67 $15,500.00 $16,144.09 $0.00 $0.00 $211.00 $0.00 �Other Financing Sources a4-000 389.100 Use of Fund Balance .00 .00 .00 .00 .00 .00 3,000.00 0 Other Financing Sources Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,000.00 cn Operating Transfers In 34-000 391.100 General Fund 18,337.65 .00 .00 13,000.00 10,072.00 10,072.00 .00 - Operating Transfers In Totals $18,337.65 $0.00 $0.00 $13,000.00 $10,072.00 $10,072.00 $0.00 Q Department 000 - Fund Revenues Totals $32,093.32 $15,500.00 $16,144.09 $13,000.00 $10,072.00 $12,948.82 $3,000.00 REVENUE TOTALS $32,093.32 $15,500.00 $16,144.09 $13,000.00 $10,072.00 $12,948.82 $3,000.00 D• c n C Cn O n �' `°Z rn `4 v O n C rn _ y Run by Dora Cross on 03/31/2021 16:26:28 PM Page 47 of.96 234 - LEPC Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : WDepartment 242 - Emergency Planning Committee C: Personnel Services ,24-242 410.110 Salaries 6,458.96 5,546.17 4,566.82 .00 .00 .00 .00 :1-242 410.120 Temporary Help .00 .00 71.02 .00 .00 2,409.39 .00 ,j4-242 410.130 Overtime 839.84 827.91 23.82 .00 .00 .00 .00 CL U) Personnel Services Totals $7,298.80 $6,374.08 $4,661.66 $0.00 $0.00 $2,409.39 $0.00 n Employee Benefits �4-242 420.110 Unemployment Taxes .73 .63 .43 .00 .00 .00 .00 O 234-242 420.120 FICA Taxes 546.45 476.98 348.17 .00 .00 184.31 .00 3W4-242 420.130 Group Insurance 2,593.37 2,482.25 2,215.24 .00 .00 .00 .00 :R4-242 420.140 Retirement 1,587.01 1,384.07 994.86 .00 .00 .00 .00 44-242 420.150 Workers Compensation 67.59 129.83 130.04 .00 .00 72.12 .00 C Employee Benefits Totals $4,795.15 $4,473.76 $3,688.74 $0.00 $0.00 $256.43 $0.00 Q Support Goods & Services j24-242 450.120 Printing / Binding .00 1,500.00 392.94 .00 .00 .00 .00 M-242 450.170 Machinery / Equipment <$5000 471.00 .00 .00 .00 .00 .00 .00 84-242 450.230 Advertising / Hearings .00 3,152.16 7,400.75 .00 1,072.00 247.68 1,500.00 C W-242 450.270 Continuing Education .00 .00 .00 .00 2,000.00 .00 .00 334-242 450.300 Travel / Per Diem 1,190.72 .00 .00 .00 2,000.00 .00 1,500.00 234-242 450.450 Contingencies .00 .00 .00 .00 5,000.00 .00 .00 Support Goods & Services Totals $1,661.72 $4,652.16 $7,793.69 $0.00 $10,072.00 $247.68 $3,000.00 Department 242 - Emergency Planning Committee $13,755.67 $15,500.00 $16,144.09 $0.00 $10,072.00 $2,913.50 $3,000.00 Totals EXPENSE TOTALS $13,755.67 $15,500.00 $16,144.09 $0.00 $10,072.00 $2,913.50 $3,000.00 Fund 234 - LEPC Totals REVENUE TOTALS $32,093.32 $15,500.00 $16,144.09 $13,000.00 $10,072.00 $12,948.82 $3,000.00 EXPENSE TOTALS $13,755.67 $15,500.00 $16,144.09 $0.00 $10,072.00 $2,913.50 $3,000.00 - n Fund 234 - LEPC Totals $18,337.65 $0.00 $0.00 $13,000.00 $0.00 $10,035.32 $0.00CD rn 0 00 v 0 n C rn _ y Run by Dora Cross on 03/31/2021 16:26:28 PM Page 48 of.96 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am—nh Am—nh Ri A—i- Amni inh R1 irinat - I : 254 - KIB Airport Fire District WDepartment 000 - Fund Revenues �' `° rn z `0 v 0 n C rn _ y C Property Tax Run by Dora Cross on 03/31/2021 16:26:28 PM Page 49 of.96 ,24-000 311.100 Real Property Tax 11,203.79 12,485.55 13,784.80 13,709.91 13,595.00 13,269.08 13,270.00 :1-000 311.200 Personal Property Tax 4,161.74 4,214.96 4,327.52 4,834.26 4,834.00 5,436.29 5,400.00 j Property Tax Totals $15,365.53 $16,700.51 $18,112.32 $18,544.17 $18,429.00 $18,705.37 $18,670.00 Q- Interest Earnings 000 361.100 Interest Earnings 563.87 737.07 968.58 1,166.03 .00 642.58 280.00 �4-000 361.300 Change in Fair Market Value (353.08) (545.29) 583.21 182.97 .00 (477.65) .00 O Interest Earnings Totals $210.79 $191.78 $1,551.79 $1,349.00 $0.00 $164.93 $280.00 c Department 000 - Fund Revenues Totals $15,576.32 $16,892.29 $19,664.11 $19,893.17 $18,429.00 $18,870.30 $18,950.00 cn REVENUE TOTALS $15,576.32 $16,892.29 $19,664.11 $19,893.17 $18,429.00 $18,870.30 $18,950.00 n �' `° rn z `0 v 0 n C rn _ y Run by Dora Cross on 03/31/2021 16:26:28 PM Page 49 of.96 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : 254 - KIB Airport Fire District WDepartment 216 - Airport Protection C `° rn z C) ° �. C Contracted Services C rn _ y &-216 444.360 Fire Protection Services 14,716.08 15,365.53 16,700.51 8,733.70 14,200.00 18,657.34 18,700.00 O-� Contracted Services Totals $14,716.08 $15,365.53 $16,700.51 $8,733.70 $14,200.00 $18,657.34 $18,700.00 Support Goods & Services SM -216 450.220 Insurance & Bonding 19.92 .00 .00 .00 250.00 .00 .00 OM -216 450.222 General Liablity Insurance Coverage 00 .00 26.48 121.83 .00 120.45 250.00 g4-216 450.224 Insurance Coverage Discounts .00 .00 (6.94) (31.00) .00 (30.00) .00 O 254-216 450.450 Contingencies .00 .00 .00 .00 3,979.00 .00 .00 Support Goods & Services Totals $19.92 $0.00 $19.54 $90.83 $4,229.00 $90.45 $250.00 Department 216 - Airport Protection Totals $14,736.00 $15,365.53 $16,720.05 $8,824.53 $18,429.00 $18,747.79 $18,950.00 EXPENSE TOTALS $14,736.00 $15,365.53 $16,720.05 $8,824.53 $18,429.00 $18,747.79 $18,950.00 -1 Fund 254 - KIB Airport Fire District Totals Q REVENUE TOTALS $15,576.32 $16,892.29 $19,664.11 $19,893.17 $18,429.00 $18,870.30 $18,950.00 (Z3 EXPENSE TOTALS $14,736.00 $15,365.53 $16,720.05 $8,824.53 $18,429.00 $18,747.79 $18,950.00 Fund 254 - KIB Airport Fire District Totals $840.32 $1,526.76 $2,944.06 $11,068.64 $0.00 $122.51 $0.00 n C Cn O n C `° rn z C) ° �. n C rn _ y Run by Dora Cross on 03/31/2021 16:26:28 PM Page 50 of.96 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am—nh Am—nh Ri A—i- Amni inh R1 irinat - I : 260 - Woodland Acres Lights WDepartment 000 - Fund Revenues �' `° rn z v O C: Property Tax rn y 90-000 311.100 Real Property Tax 5,115.36 5,202.13 5,532.46 5,537.30 5,500.00 5,579.27 5,500.00 20-000 311.200 Personal Property Tax 39.77 38.52 43.64 41.25 40.00 50.03 40.00 j Property Tax Totals $5,155.13 $5,240.65 $5,576.10 $5,578.55 $5,540.00 $5,629.30 $5,540.00 Q- Interest Earnings 000 361.100 Interest Earnings 402.14 662.19 843.66 630.91 .00 253.09 .00 90-000 361.300 Change in Fair Market Value (249.30) (502.00) 562.60 93.45 .00 (191.38) .00 O Interest Earnings Totals $152.84 $160.19 $1,406.26 $724.36 $0.00 $61.71 $0.00 cn c Department 000 - Fund Revenues Totals $5,307.97 $5,400.84 $6,982.36 $6,302.91 $5,540.00 $5,691.01 $5,540.00 REVENUE TOTALS $5,307.97 $5,400.84 $6,982.36 $6,302.91 $5,540.00 $5,691.01 $5,540.00 n �' `° rn z v O n rn y Run by Dora Cross on 03/31/2021 16:26:28 PM Page 51 of.96 C:) K'0DLAK'IS-LA1VD PO a D O O UH 260 - Woodland Acres Lights WDepartment 230 - Woodland Acres Street Lights C: Support Goods & Services 20-230 450.220 Insurance & Bonding 20-230 450.222 General Liablity Insurance Coverage g0-230 450.224 Insurance Coverage Discounts CL 2LW-230 450.320 Bad Debt Expense 230-230 450.350 Electricity O O Support Goods & Services Totals 0 Capital Outlay Budget Worksheet Report Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh R, A -i- Amni inh R1 irinat - I : 6.63 .00 .00 .00 .00 .00 .00 .00 .00 8.47 106.55 250.00 106.53 250.00 .00 .00 (2.22) (27.00) .00 (26.00) .00 .00 .00 .00 .50 .00 .02 .00 4,809.33 4,671.60 4,537.95 4,791.01 5,290.00 3,656.08 5,290.00 $4,815.96 $4,671.60 $4,544.20 $4,871.06 $5,540.00 $3,736.63 $5,540.00 2,A0-230 470.100 Machinery / Equipment >$5000 .00 .00 .00 14,629.47 .00 .00 .00 n- Capital Outlay Totals $0.00 $0.00 $0.00 $14,629.47 $0.00 $0.00 $0.00 n rn y Run by Dora Cross on 03/31/2021 16:26:28 PM Page 52 of!;6 Department 230 - Woodland Acres Street Lights Totals $4,815.96 $4,671.60 $4,544.20 $19,500.53 $5,540.00 $3,736.63 $5,540.00 EXPENSE TOTALS $4,815.96 $4,671.60 $4,544.20 $19,500.53 $5,540.00 $3,736.63 $5,540.00 Fund 260 - Woodland Acres Lights Totals D REVENUE TOTALS $5,307.97 $5,400.84 $6,982.36 $6,302.91 $5,540.00 $5,691.01 $5,540.00 EXPENSE TOTALS $4,815.96 $4,671.60 $4,544.20 $19,500.53 $5,540.00 $3,736.63 $5,540.00 U n C Fund 260 -Woodland Acres Lights Totals $492.01 $729.24 $2,438.16 ($13,197.62) $0.00 $1,954.38 $0.00 n v (D `° m Z o n rn y Run by Dora Cross on 03/31/2021 16:26:28 PM Page 52 of!;6 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am—nh Am—nh Ri A—i- Amni inh R1 irinat - I : 261 - Trinity Islands Light District WDepartment 000 - Fund Revenues �' `° rn z W v 0 C: Property Tax rn y 9-000 311.100 Real Property Tax 2,445.78 2,498.20 1,942.22 1,873.08 1,897.00 1,874.42 1,875.00 :1-000 311.200 Personal Property Tax .00 .00 .00 .00 .00 1.62 .00 j Property Tax Totals $2,445.78 $2,498.20 $1,942.22 $1,873.08 $1,897.00 $1,876.04 $1,875.00 Q- Interest Earnings XA -000 361.100 Interest Earnings 355.14 589.76 738.18 757.50 .00 355.82 .00 91-000 361.300 Change in Fair Market Value (219.21) (443.12) 485.58 121.28 .00 (269.64) .00 O Interest Earnings Totals $135.93 $146.64 $1,223.76 $878.78 $0.00 $86.18 $0.00 cn c Department 000 - Fund Revenues Totals $2,581.71 $2,644.84 $3,165.98 $2,751.86 $1,897.00 $1,962.22 $1,875.00 REVENUE TOTALS $2,581.71 $2,644.84 $3,165.98 $2,751.86 $1,897.00 $1,962.22 $1,875.00 n �' `° rn z W v 0 n rn y Run by Dora Cross on 03/31/2021 16:26:28 PM Page 53 of.96 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am—nh Am—nh Ri A—i- Amni inh R1 irinat - I : 261 - Trinity Islands Light District WDepartment 261 - Trinity Island Lighting C Support Goods & Services 01-261450.220 Insurance & Bonding 2.83 .00 .00 .00 .00 .00 .00 9.4-261450.222 General Liablity Insurance Coverage .00 .00 3.11 102.18 250.00 101.86 250.00 211-261450.224 Insurance Coverage Discounts .00 .00 (.82) (26.00) .00 (25.00) .00 O - 2M -261450.350 Electricity 1,790.10 1,795.55 1,727.84 1,668.27 1,647.00 1,000.56 1,625.00 c7 3 Support Goods & Services Totals $1,792.93 $1,795.55 $1,730.13 $1,744.45 $1,897.00 $1,077.42 $1,875.00 0 Department 261 - Trinity Island Lighting Totals $1,792.93 $1,795.55 $1,730.13 $1,744.45 $1,897.00 $1,077.42 $1,875.00 EXPENSE TOTALS $1,792.93 $1,795.55 $1,730.13 $1,744.45 $1,897.00 $1,077.42 $1,875.00 U Fund 261 - Trinity Islands Light District Totals n REVENUE TOTALS $2,581.71 $2,644.84 $3,165.98 $2,751.86 $1,897.00 $1,962.22 $1,875.00 -1 EXPENSE TOTALS $1,792.93 $1,795.55 $1,730.13 $1,744.45 $1,897.00 $1,077.42 $1,875.00 C Q Fund 261 - Trinity Islands Light District Totals $788.78 $849.29 $1,435.85 $1,007.41 $0.00 $884.80 $0.00 Z3 (Q OWA rn n C U) N O I n `° Z O n rn y Run by Dora Cross on 03/31/2021 16:26:28 PM Page 54 of!;b K'0DK'ID BO OU H 276 - Facilities Fund Budget Worksheet Report Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's . Department 000 - Fund Revenues n �' `° rn z v WInterest Earnings n rn y j26-000 361.100 Interest Earnings 497,367.17 797,605.63 982,577.70 975,743.97 750,000.00 449,990.17 340,000.00 :6-000 361.300 Change in Fair Market Value (305,976.15) (594,176.34) 642,499.87 155,157.56 .00 (340,447.73) .00 j Interest Earnings Totals $191,391.02 $203,429.29 $1,625,077.57 $1,130,901.53 $750,000.00 $109,542.44 $340,000.00 Q- Other Financing Sources -000 389.100 Use of Fund Balance .00 .00 .00 .00 82,316.00 .00 204,389.00 p Other Financing Sources Totals $0.00 $0.00 $0.00 $0.00 $82,316.00 $0.00 $204,389.00 Operating Transfers In -000 391.469 Transfer from Renewal & Replacement .00 .00 110,017.00 .00 .00 .00 .00 Operating Transfers In Totals $0.00 $0.00 $110,017.00 $0.00 $0.00 $0.00 $0.00 Department 000 -Fund Revenues Totals $191,391.02 $203,429.29 $1,735,094.57 $1,130,901.53 $832,316.00 $109,542.44 $544,389.00 - REVENUE TOTALS $191,391.02 $203,429.29 $1,735,094.57 $1,130,901.53 $832,316.00 $109,542.44 $544,389.00 D 0� c n C cn O n �' `° rn z v 0 n rn y Run by Dora Cross on 03/31/2021 16:26:28 PM Page 55 of.96 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am—nh Am—nh Ri A—i- Amni inh RI irinat - I : 276 - Facilities Fund W Department 286 - Facilities �' `° rn z v O n C Operating Transfers _ y Run by Dora Cross on 03/31/2021 16:26:28 PM ,26-286 494.220 Building & Grounds .00 10,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 26-286 494.300 Transfer to Debt Service 151,858.00 65,105.00 338,982.00 830,105.00 827,316.00 827,316.00 .00 ;N6-286 494.469 Renewal & Replacement Projects 286,455.00 55,105.00 444,000.00 86.00 .00 .00 539,389.00 Q Cn Operating Transfers Totals $438,313.00 $130,210.00 $787,982.00 $835,191.00 $832,316.00 $832,316.00 $544,389.00 n Department 286 - Facilities Totals $438,313.00 $130,210.00 $787,982.00 $835,191.00 $832,316.00 $832,316.00 $544,389.00 3 O EXPENSE TOTALS $438,313.00 $130,210.00 $787,982.00 $835,191.00 $832,316.00 $832,316.00 $544,389.00 O_ 0 Fund 276 - Facilities Fund Totals c REVENUE TOTALS $191,391.02 $203,429.29 $1,735,094.57 $1,130,901.53 $832,316.00 $109,542.44 $544,389.00 n EXPENSE TOTALS $438,313.00 $130,210.00 $787,982.00 $835,191.00 $832,316.00 $832,316.00 $544,389.00 -1 Fund 276 - Facilities Fund Totals ($246,921.98) $73,219.29 $947,112.57 $295,710.53 $0.00 ($722,773.56) $0.00 C O S? D cc �W rn n C O O O n �' `° rn z v O n C rn _ y Run by Dora Cross on 03/31/2021 16:26:28 PM Page 56 of.96 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : 277 - Tourism Development WDepartment 000 - Fund Revenues C: Sales Taxes jf�-000 317.100 Bed Tax Revenues 617.80 (300.00) (200.00) .00 20,000.00 .00 15,200.00 A7-000 317.110 Bed Tax Revenue - On Road System 75,941.56 79,009.72 52,915.92 43,651.54 .00 14,149.07 .00 2i 7-000 317.120 Bed Tax Revenue - Off Road System 26,299.92 30,587.73 23,964.66 19,177.02 .00 15,856.85 .00 Q 27�-000 317.130 Bed Tax Revenue - Larsen Bay 5,190.40 4,187.80 1,890.00 .00 .00 600.00 .00 c7 Sales Taxes Totals 3 $108,049.68 $113,485.25 $78,570.58 $62,828.56 $20,000.00 $30,605.92 $15,200.00 O Penalties & Interest Tax n rn y O Page 57 of!;b 279-000 319.100 Penalties & Interest .00 .00 400.00 .00 .00 .00 .00 CCn Penalties & Interest Tax Totals $0.00 $0.00 $400.00 $0.00 $0.00 $0.00 $0.00 State Shared Revenues P7-000 335.180 Commercial Passenger Vessel Tax 30,887.50 37,625.00 .00 .00 .00 .00 .00 State Shared Revenues Totals $30,887.50 $37,625.00 $0.00 $0.00 $0.00 $0.00 $0.00 QInterest Earnings 2:37-000 361.100 Interest Earnings 2,569.66 4,108.82 4,129.52 2,582.09 .00 986.09 .00 (Q -000 361.300 Change in Fair Market Value (1,621.53) (3,133.00) 2,453.19 436.50 .00 (702.65) .00 Interest Earnings Totals $948.13 $975.82 $6,582.71 $3,018.59 $0.00 $283.44 $0.00 n. C Other Financing Sources 97-000 389.100 Use of Fund Balance .00 .00 .00 .00 55,000.00 .00 60,000.00 O Other Financing Sources Totals $0.00 $0.00 $0.00 $0.00 $55,000.00 $0.00 $60,000.00 Department 000 - Fund Revenues Totals $139,885.31 $152,086.07 $85,553.29 $65,847.15 $75,000.00 $30,889.36 $75,200.00 REVENUE TOTALS $139,885.31 $152,086.07 $85,553.29 $65,847.15 $75,000.00 $30,889.36 $75,200.00 n `° Z O n rn y Run by Dora Cross on 03/31/2021 16:26:28 PM Page 57 of!;b BOWOUOU 277 - Tourism Development WDepartment 287 - Tourism Development C: Contributions jf�-287 448.309 Alutiiq Museum & Archaeological CD Repository W-287 448.313 City of Larsen Bay �7-287 448.332 Historical Society 91-287 448.364 Kodiak Convention Bureau 2iT7-287 448.406 Kodiak Maritime Museum 0 Contributions Totals g Support Goods & Services 3* -287 450.130 Postage 9,7-287 450.222 General Liablity Insurance Coverage Budget Worksheet Report Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh R, A -i- Amni inh R1 irinat - I : 5,585.00 4,000.00 4,000.00 4,000.00 .00 .00 .00 .00 9,500.70 1,890.00 .00 .00 .00 .00 5,585.00 4,000.00 4,000.00 4,000.00 .00 .00 .00 95,000.00 75,000.00 75,000.00 75,000.00 75,000.00 75,000.00 75,000.00 3,351.00 4,000.00 4,000.00 4,000.00 .00 .00 .00 $109,521.00 $96,500.70 $88,890.00 $87,000.00 $75,000.00 $75,000.00 $75,000.00 .00 68.65 86.93 30.87 .00 .00 50.00 .00 .00 206.33 261.51 .00 184.68 150.00 2LT-287 450.224 Insurance Coverage Discounts .00 .00 (54.05) (66.00) .00 (46.00) .00 Q Q Support Goods & Services Totals $0.00 $68.65 $239.21 $226.38 $0.00 $138.68 $200.00 = Operating Transfers $141,569.35 $134,129.21 $132,226.38 $75,000.00 $75,138.68 $75,200.00 Fund 277 - Tourism Development Totals ($14,635.69) 9-287494.555 KFRC 45,000.00 45,000.00 45,000.00 45,000.00 .00 .00 .00 W' Operating Transfers Totals $45,000.00 $45,000.00 $45,000.00 $45,000.00 $0.00 $0.00 $0.00 C Department 287 - Tourism Development Totals $154,521.00 $141,569.35 $134,129.21 $132,226.38 $75,000.00 $75,138.68 $75,200.00 to to EXPENSE TOTALS $154,521.00 $141,569.35 $134,129.21 $132,226.38 $75,000.00 $75,138.68 $75,200.00 SFund 277 - Tourism Development Totals REVENUE TOTALS $139,885.31 $152,086.07 $85,553.29 $65,847.15 $75,000.00 $30,889.36 $75,200.00 EXPENSE TOTALS $154,521.00 $141,569.35 $134,129.21 $132,226.38 $75,000.00 $75,138.68 $75,200.00 Fund 277 - Tourism Development Totals ($14,635.69) $10,516.72 ($48,575.92) ($66,379.23) $0.00 ($44,249.32) $0.00 n v `' m Z o ° rn y Run by Dora Cross on 03/31/2021 16:26:28 PM Page 58 of!;6 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : 278 - Commercial Passenger Vessel . Department 000 - Fund Revenues n �' `° rn z v WState Shared Revenues n C rn _ y &-000 335.180 Commercial Passenger Vessel Tax .00 .00 42,752.50 54,220.00 .00 .00 .00 (�D State Shared Revenues Totals $0.00 $0.00 $42,752.50 $54,220.00 $0.00 $0.00 $0.00 0) Interest Earnings =-000 361.100 Interest Earnings .00 .00 273.72 1,471.30 .00 1,104.03 .00 -000 361.300 Change in Fair Market Value .00 .00 261.02 172.09 .00 (837.89) .00 p Interest Earnings Totals $0.00 $0.00 $534.74 $1,643.39 $0.00 $266.14 $0.00 O Department 000 - Fund Revenues Totals $0.00 $0.00 $43,287.24 $55,863.39 $0.00 $266.14 $0.00 0 REVENUE TOTALS $0.00 $0.00 $43,287.24 $55,863.39 $0.00 $266.14 $0.00 cn n -1 C D 00 O c n C to O n �' `° rn z v 0 n C rn _ y Run by Dora Cross on 03/31/2021 16:26:28 PM Page 59 of.96 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : 278 - Commercial Passenger Vessel WDepartment 288 - Passenger Vessels C `° rn z C) ° �. C: Support Goods & Services C rn _ y a8-288 450.222 General Liablity Insurance Coverage .00 .00 .00 148.02 .00 100.00 .00 28-288 450.224 Insurance Coverage Discounts .00 .00 .00 (38.00) .00 (24.00) .00 j Support Goods & Services Totals $0.00 $0.00 $0.00 $110.02 $0.00 $76.00 $0.00 CL Department 288 - Passenger Vessels Totals $0.00 $0.00 $0.00 $110.02 $0.00 $76.00 $0.00 n EXPENSE TOTALS $0.00 $0.00 $0.00 $110.02 $0.00 $76.00 $0.00 3 O Fund O_ 278 - Commercial Passenger Vessel Totals 0 REVENUE TOTALS $0.00 $0.00 $43,287.24 $55,863.39 $0.00 $266.14 $0.00 cn EXPENSE TOTALS $0.00 $0.00 $0.00 $110.02 $0.00 $76.00 $0.00 0 Fund 278 - Commercial Passenger Vessel Totals $0.00 $0.00 $43,287.24 $55,753.37 $0.00 $190.14 $0.00 -1 C C_Z D O c n C cn O n C `° rn z C) ° �. n C rn _ y Run by Dora Cross on 03/31/2021 16:26:28 PM Page 60 of96 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh R, A -i- Amni inh R1 irinat - I : 300 - Debt Service WDepartment 000 - Fund Revenues C Property Tax ,g0-000 311.100 Real Property Tax 2,228,918.18 2,433,590.84 2,339,243.00 2,262,212.43 2,201,212.00 2,007,639.15 4,612,270.00 �&-000 311.200 Personal Property Tax 274,672.03 277,522.97 259,076.66 277,303.10 244,579.00 244,004.92 512,474.00 � Property Tax Totals $2,503,590.21 $2,711,113.81 $2,598,319.66 $2,539,515.53 $2,445,791.00 $2,251,644.07 $5,124,744.00 C- Non Ad Valorem Taxes .00 .00 .00 .00 .00 .00 Proceeds of Long Term Debt Totals *000 313.110 Motor Vehicle Tax $0.00 .00 .00 .00 215,537.60 210,000.00 106,054.84 200,000.00 p Non Ad Valorem Taxes Totals $0.00 $0.00 $0.00 $215,537.60 $210,000.00 $106,054.84 $200,000.00 2 Penalties & Interest Tax $8,073,670.00 $7,775,577.91 $8,054,807.00 Z j 8U-000 319.100 Penalties & Interest 16.61 .00 .00 .00 .00 .00 .00 n rn Penalties & Interest Tax Totals $16.61 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 State Shared Revenues 30m-000 335.200 School Debt Reimbursement - Current 3,840,763.00 4,985,040.00 5,226,069.00 2,552,052.00 .00 .00 2,730,063.00 C Page 61 of!;6 I State Shared Revenues Totals $3,840,763.00 $4,985,040.00 $5,226,069.00 $2,552,052.00 $0.00 $0.00 $2,730,063.00 Q Z' Interest Earnings 00-000 361.100 Interest Earnings 1,511.14 5,085.55 711.44 .00 .00 .00 .00 Y-000 361.300 Change in Fair Market Value (2,118.90) (6,832.36) 501.35 .00 .00 .00 .00 n C Interest Earnings Totals ($607.76) ($1,746.81) $1,212.79 $0.00 $0.00 $0.00 $0.00 � Operating Transfers In 300-000 391.100 General Fund 73 300-000 391.201 Education Support Fund 300-000 391.276 Facilities Fund 300-000 391.420 300-000 391.469 Capital Project - School Bonds 635,113.00 .00 .00 .00 .00 .00 .00 1,632,815.00 151,858.00 65,105.00 338,982.00 830,105.00 272,409.00 .00 .00 .00 3,016,076.00 3,016,076.00 .00 .00 .00 .00 827,316.00 827,316.00 .00 .00 .00 .00 Transfer from Renewal & Replacement .00 .00 .00 .00 1,574,487.00 1,574,487.00 .00 Operating Transfers In Totals $1,059,380.00 $65,105.00 $338,982.00 $2,462,920.00 $5,417,879.00 $5,417,879.00 $0.00 Proceeds of Long Term Debt 300-000 393.600 Premium on Bonds 806,205.00 .00 .00 .00 .00 .00 .00 Proceeds of Long Term Debt Totals $806,205.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 r1 cQ Department 000 - Fund Revenues Totals $8,209,347.06 $7,759,512.00 $8,164,583.45 $7,770,025.13 $8,073,670.00 $7,775,577.91 $8,054,807.00 T m REVENUE TOTALS $8,209,347.06 $7,759,512.00 $8,164,583.45 $7,770,025.13 $8,073,670.00 $7,775,577.91 $8,054,807.00 Z j v 0 n rn y Run by Dora Cross on 03/31/2021 16:26:29 PM Page 61 of!;6 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am—nh Am—nh Ri A—i- Amni inh RI irinat - I : 300 - Debt Service WDepartment 165 - General Administration C Support Goods & Services 00-165 450.320 Bad Debt Expense .65 1.21 .00 3.24 .00 1.23 .00 C(D Support Goods & Services Totals $0.65 $1.21 $0.00 $3.24 $0.00 $1.23 $0.00 Iv Department 165 - General Administration Totals $0.65 $1.21 $0.00 $3.24 $0.00 $1.23 $0.00 Q X cn n -1 C Z3 Ba �W to n C Cn O n �' `° rn z -' N v O n rn y Run by Dora Cross on 03/31/2021 16:26:29 PM Page 62 of96 N Budget Worksheet Report CD `s -. N SODIAS I, I� D DH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : 300 - Debt Service WDepartment 300 - Debt Service - School C Professional Services ,g0-300 430.130 Consultants .00 16,050.00 3,150.00 .00 6,301.00 3,150.00 12,600.00 (1) Professional Services Totals $0.00 $16,050.00 $3,150.00 $0.00 $6,301.00 $3,150.00 $12,600.00 0) Support Goods & Services 390-300 450.320 Bad Debt Expense 11.16 7.37 4,577.41 4,184.44 .00 8.43 .00 0 n Support Goods & Services Totals $11.16 $7.37 $4,577.41 $4,184.44 $0.00 $8.43 $0.00 '::r Debt Service - Princlp l aD-300 475.237 GO 2008A JR -300 475.239 2011 Bond Issue 3CP-300 475.241 2012A Refunding Bond Issue ,Q0-300 475.242 2012B Refunding Bond Issue 0-300 475.243 GO 2013 - Principal 380-300 475.245 2014 GO Bond j20-300 475.246 2015 GO HS Bond 1D-300 475.247 � 2015 GO R & R Bond JO -300 475.248 2016 GO HS Bond C 460,000.00 V-300 475.249 2016 GO R & R Bond -Z6-300 475.252 2016 GO Series 3 - Principal 545,000.00 550,000.00 300-300 475.253 2018 AMBBA DL - HS Reno Principal 300-300 475.254 GO 2020 One Series A - Principal 300-300 475.255 GO 2020 One Series B - Principal Debt Service - Principal Totals Debt Service - Interest 300-300 476.237 GO 2008A 5,620,000.00 .00 .00 .00 .00 .00 .00 320,000.00 330,000.00 340,000.00 355,000.00 370,000.00 370,000.00 385,000.00 455,000.00 460,000.00 480,000.00 495,000.00 525,000.00 525,000.00 545,000.00 550,000.00 565,000.00 585,000.00 610,000.00 640,000.00 640,000.00 665,000.00 790,000.00 820,000.00 855,000.00 895,000.00 935,000.00 935,000.00 970,000.00 810,000.00 840,000.00 880,000.00 900,000.00 915,000.00 915,000.00 965,000.00 195,000.00 200,000.00 205,000.00 215,000.00 225,000.00 225,000.00 240,000.00 145, 000.00 150, 000.00 155, 000.00 160, 000.00 170, 000.00 170, 000.00 180, 000.00 30,000.00 65,000.00 65,000.00 70,000.00 75,000.00 75,000.00 80,000.00 235,000.00 440,000.00 465,000.00 490,000.00 515,000.00 515,000.00 540,000.00 .00 .00 395,000.00 415,000.00 430,000.00 430,000.00 450,000.00 .00 .00 .00 50,000.00 50,000.00 50,000.00 50,000.00 .00 .00 .00 .00 .00 .00 25,000.00 .00 .00 .00 .00 .00 .00 145,000.00 $9,150,000.00 $3,870,000.00 $4,425,000.00 $4,655,000.00 $4,850,000.00 $4,850,000.00 $5,240,000.00 441,781.00 .00 .00 .00 .00 .00 .00 300-300 476.239 2011 Bond Issue 302,550.00 292,950.00 281,400.00 267,800.00 253,600.00 253,600.00 238,800.00 n 300-3®0 476.241 2012A Refunding Bond Issue 200,300.00 186,600.00 172,400.00 150,425.00 124,925.00 124,925.00 100,900.00 300{0 476.242 20128 Refunding Bond Issue 244,550.00 227,900.00 210,550.00 183,600.00 152,350.00 152,350.00 123,050.00 m 300-3Q0 476.243 GO 2013 - Interest 899,740.00 868,140.00 835,340.00 792,590.00 756,790.00 756,790.00 719,390.00 W v 300-60 476.245 2014 GO Bond Issue 967,112.50 934,712.50 892,712.50 875,112.50 857,112.00 857,112.50 811,363.00% n 300-300 476.246 2015 GO HS Bond 296,362.50 292,412.50 286,312.50 276,837.50 265,837.00 265,837.50 254,213.00 300-300 476.247 2015 GO R & R Bond 77,148.15 74,200.00 69,600.00 62,500.00 54,250.00 54,250.00 45,500.00 m 300-300 476.248 2016 GO HS Bond 70,968.98 68,793.76 65,543.76 62,168.76 58,543.00 58,543.76 54,669.00 Run by Dora Cross on 03/31/2021 16:26:29 PM Page 63 of!;6 C:) SODIAS I, IAD D O O UH 300 - Debt Service Department 300 - Debt Service - School W Debt Service - Interest 00-300 476.249 2016 GO R & R Bond 29-300 476.252 2016 GO Series 3 - Interest 3%0-300 476.253 2018 AMBBA DL - HS Reno Interest O0: 3V)D. -300 476.254 GO 2020 One Series A - Interest :90-300 476.255 GO 2020 One Series B - Interest O Debt Service - Interest Totals O 0 Refunded Bond Uses Budget Worksheet Report Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : 250,411.11 234,250.00 211,625.00 187,750.00 162,625.00 162,625.00 136,250.00 131,935.56 228,350.00 220,450.00 204,250.00 187,350.00 97,975.00 169,750.00 .00 .00 7,479.03 15,359.00 13,987.00 7,345.75 12,572.00 .00 .00 .00 .00 .00 6,900.00 16,625.00 .00 .00 .00 .00 .00 37,100.00 89,125.00 $3,882,859.80 $3,408,308.76 $3,253,412.79 $3,078,392.76 $2,887,369.00 $2,835,354.51 $2,772,207.00 ?80-300 493.140 Bond Issuance Costs 64,313.00 .00 10,000.00 .00 30,000.00 37,595.39 30,000.00 3R0-300 493.160 Other .00 .00 .00 .00 300,000.00 .00 .00 EXPENSE TOTALS $13,097,184.61 $7,787,303.34 $7,838,317.20 $7,737,580.44 $8,073,670.00 $7,726,109.56 $8,054,807.00 Fund 300 - Debt Service Totals ($4,887,837.55) ($27,791.34) $326,266.25 $32,444.69 $0.00 $49,468.35 $0.00 Refunded Bond Uses Totals $64,313.00 $0.00 $10,000.00 $0.00 $330,000.00 $37,595.39 $30,000.00 Operating Transfers y Run by Dora Cross on 03/31/2021 16:26:29 PM Page 64 of!;6 310-300 494.100 General Fund .00 492,936.00 142,177.00 .00 .00 .00 .00 Operating Transfers Totals $0.00 $492,936.00 $142,177.00 $0.00 $0.00 $0.00 $0.00 O Department 300 - Debt Service - School Totals $13,097,183.96 $7,787,302.13 $7,838,317.20 $7,737,577.20 $8,073,670.00 $7,726,108.33 $8,054,807.00 U) EXPENSE TOTALS $13,097,184.61 $7,787,303.34 $7,838,317.20 $7,737,580.44 $8,073,670.00 $7,726,109.56 $8,054,807.00 C cn Fund 300 - Debt Service Totals N 0' REVENUE TOTALS $8,209,347.06 $7,759,512.00 $8,164,583.45 $7,770,025.13 $8,073,670.00 $7,775,577.91 $8,054,807.00 3 EXPENSE TOTALS $13,097,184.61 $7,787,303.34 $7,838,317.20 $7,737,580.44 $8,073,670.00 $7,726,109.56 $8,054,807.00 Fund 300 - Debt Service Totals ($4,887,837.55) ($27,791.34) $326,266.25 $32,444.69 $0.00 $49,468.35 $0.00 n v CD `- m Z -0. ° rn y Run by Dora Cross on 03/31/2021 16:26:29 PM Page 64 of!;6 BOWOUOU 530 - Solid Waste Disposal Department 000 - Fund Revenues W Penalties & Interest Tax '@5-000 319.100 Penalties & Interest 992,695.71 Penalties & Interest Tax Totals 0) Federal Grants 345,208.45 4M-000 331.119 CORONAVIRUS Relief Fund (CARES ACT) U) Federal Grants Totals 0 State Shared Revenues 29-000 335.190 PERS on Behalf Payment 3,000,000.00 State Shared Revenues Totals Charges for Services 372,774.85 06-000 340.160 Dump Fee - Customer 5331-000 340.170 Dump Fee - Alaska Waste 16,958.34 20,055.07 510-000 340.171 Dump Fee - USCG X96-000 340.172 Waste Screenings (Q 55,919.23 3&-000 340.173 Metals 63,130.40 Charges for Services Totals n. C Interest Earnings 50,000.00 &-000 361.100 Interest Earnings 520-000 361.300 Change in Fair Market Value Budget Worksheet Report Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh R, A -i- Amni inh R1 irinat - I : 5,790.47 524.55 4,911.86 1,796.67 4,000.00 2,215.95 2,000.00 $5,790.47 $524.55 $4,911.86 $1,796.67 $4,000.00 $2,215.95 $2,000.00 .00 .00 .00 627.53 .00 102.67 .00 $0.00 $0.00 $0.00 $627.53 $0.00 $102.67 $0.00 20,887.36 35,503.35 21,847.27 (17,839.76) 47,797.00 38,770.76 64,400.00 $20,887.36 $35,503.35 $21,847.27 ($17,839.76) $47,797.00 $38,770.76 $64,400.00 452,166.21 518,969.31 992,695.71 668,234.53 1,100,000.00 345,208.45 750,000.00 2,292,463.54 2,850,203.96 3,000,793.70 2,994,266.55 2,950,000.00 1,971,908.85 3,000,000.00 252,238.86 320,910.19 372,774.85 375,409.80 360,000.00 246,915.20 380,000.00 16,958.34 20,055.07 22,485.70 21,998.55 23,000.00 15,330.00 23,000.00 55,919.23 41,466.92 47,021.70 63,130.40 40,000.00 26,787.35 50,000.00 $3,069,746.18 $3,751,605.45 $4,435,771.66 $4,123,039.83 $4,473,000.00 $2,606,149.85 $4,203,000.00 79,022.26 150,376.98 187,415.26 219,991.22 110,000.00 88,221.06 100,000.00 (48,445.77) (117,942.48) 119,498.83 20,277.17 .00 (66,864.62) .00 Interest Earnings Totals $30,576.49 $32,434.50 $306,914.09 $240,268.39 $110,000.00 $21,356.44 $100,000.00 Miscellaneous - Classified 530-000 380.170 Other 5,599.69 .00 .00 .00 .00 1,000.00 .00 530-000 380.220 Recycle Metals 35,533.00 61,374.56 29,464.40 28,577.60 25,000.00 30,513.05 30,000.00 530-000 380.224 Recycling Rebate 280.47 363.03 149.77 .00 .00 .00 .00 Miscellaneous - Classified Totals $41,413.16 $61,737.59 $29,614.17 $28,577.60 $25,000.00 $31,513.05 $30,000.00 Other Financing Sources n 530-9®0 389.100 Use of Fund Balance .00 .00 .00 .00 910,850.00 .00 612,998.00 c0 Other Financing Sources Totals $0.00 $0.00 $0.00 $0.00 $910,850.00 $0.00 $612,998.00 m �,ceeds of Long Term Debt Z 530-6M 393.600 Premium on Bonds 27,211.00 27,211.00 27,211.00 27,210.20 27,211.00 27,211.00 27,211.00 Q Proceeds of Long Term Debt Totals $27,211.00 $27,211.00 $27,211.00 $27,210.20 $27,211.00 $27,211.00 $27,211.00 Department 000 - Fund Revenues Totals $3,195,624.66 $3,909,016.44 $4,826,270.05 $4,403,680.46 $5,597,858.00 $2,727,319.72 $5,039,609.00 REVENUE TOTALS $3,195,624.66 $3,909,016.44 $4,826,270.05 $4,403,680.46 $5,597,858.00 $2,727,319.72 $5,039,609.00 Run by Dora Cross on 03/31/2021 16:26:29 PM Page 65 of!;6 BOWOUOU 530 - Solid Waste Disposal Budget Worksheet Report Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh R, Ai i. Amni inh R1 irinat - I : WDepartment 731 - Waste Disposal Unemployment Taxes n M-731-701 420.120 FICA Taxes n 34.25 g0-731-701 420.130 Group Insurance 190-731-701420.140 C Sub -Department 701 - Landfill 40,876.00 930-731-701420.145 OPEB & Pension Expense ,9-731-701420.150 Workers Compensation cn 161,551.06 199,254.00 Personnel Services 189,810.00 125,630.97 125,026.88 122,109.17 123,366.19 152,925.00 105,254.38 164,429.00 206,711.00 (30,609.00) (73,461.00) (216,487.00) .00 .00 .00 31,138.94 37,971.58 33,030.46 22,742.83 40-731-701410.110 Salaries 502,926.01 510,227.43 501,037.60 452,753.29 514,129.00 $431,923.00 345,444.18 516,519.00 5�0-731-701 410.120 Temporary Help 9,637.78 11,126.88 19,157.07 8,700.99 13,200.00 136,262.42 11,685.14 13,904.00 RO-731-701 410.130 Overtime 7,314.17 7,681.79 8,279.14 8,703.30 7,000.00 3,895.33 15,672.00 530,81-701431.120 Legal Fees 30,018.49 14,897.02 7,133.50 3,160.00 5,000.00 19,349.00 10,000.00 30-731-701 410.140 Allocated Salaries 22,000.00 22,000.00 20,000.00 25,000.00 25,000.00 $5,000.00 25,000.00 25,000.00 @�ntributions 300-731-701 410.152 Cell Phone Stipend .00 .00 200.00 865.00 .00 40,000.00 497.00 1,840.00 n Personnel Services Totals $541,877.96 $551,036.10 $548,673.81 $496,022.58 $559,329.00 $386,521.65 $572,935.00 E' Employee Benefits 0-731-701 420.110 Unemployment Taxes n M-731-701 420.120 FICA Taxes n 34.25 g0-731-701 420.130 Group Insurance 190-731-701420.140 Retirement Z3 40,876.00 930-731-701420.145 OPEB & Pension Expense ,9-731-701420.150 Workers Compensation cn 161,551.06 n Employee Benefits Totals C U) Professional Services U) Z0-731-701430.130 Consultants 530-731-701430.140 Contracted Services 50.57 50.50 47.73 656.29 53.00 34.25 55.00 38,814.11 38,887.24 41,525.78 33,263.25 40,876.00 26,872.65 41,776.00 151,490.72 156,102.78 156,319.84 161,551.06 199,254.00 117,158.65 189,810.00 125,630.97 125,026.88 122,109.17 123,366.19 152,925.00 105,254.38 164,429.00 206,711.00 (30,609.00) (73,461.00) (216,487.00) .00 .00 .00 31,138.94 37,971.58 33,030.46 22,742.83 38,815.00 17,568.69 25,992.00 $553,836.31 $327,429.98 $279,571.98 $125,092.62 $431,923.00 $266,888.62 $422,062.00 30,498.75 .00 64,129.85 36,787.95 85,809.00 39,322.25 85,000.00 136,262.42 122,379.39 129,723.40 123,488.31 65,000.00 63,739.54 65,000.00 530-731-701430.144 Design Services .00 9,600.00 60,023.00 995.00 10,000.00 .00 10,000.00 530-731-701430.145 Junk Removal Services .00 .00 .00 .00 5,000.00 .00 5,000.00 530-731-701430.146 Metals Processing 54,517.58 44,631.22 38,440.14 49,997.13 45,000.00 35,250.99 50,000.00 530-731-701430.147 Litter Pickup 6,000.00 7,000.00 7,000.00 6,000.00 7,000.00 .00 7,000.00 530-731-701430.164 Construction Services .00 .00 .00 .00 150,000.00 .00 100,000.00 Professional Services Totals $227,278.75 $183,610.61 $299,316.39 $217,268.39 $367,809.00 $138,312.78 $322,000.00 n tUgal Services 530,81-701431.120 Legal Fees 30,018.49 14,897.02 7,133.50 3,160.00 5,000.00 19,349.00 10,000.00 m CD v Legal Services Totals $30,018.49 $14,897.02 $7,133.50 $3,160.00 $5,000.00 $19,349.00 $10,000.00 @�ntributions 530-191-701448.322 Senior Citizen Support 35,880.10 36,382.75 37,040.37 37,904.04 40,000.00 .00 40,000.00 n (0 530-q1-701 448.902 Donated Trash Disposal .00 .00 .00 .00 140,000.00 104,536.00 140,000.00 y Contributions Totals $35,880.10 $36,382.75 $37,040.37 $37,904.04 $180,000.00 $104,536.00 $180,000.00 Run by Dora Cross on 03/31/2021 16:26:29 PM Page 66 of!;6 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri Ai i. Amni inh R1 irinat - I : 530 - Solid Waste Disposal WDepartment 731 - Waste Disposal C Sub -Department 701 - Landfill Support Goods & Services CQ 4Q-731-701 450.110 Operating Supplies 31,062.24 54,662.20 60,145.38 57,336.94 60,000.00 51,507.58 60,000.00 5�0-731-701 450.112 Hazardous Waste Material 36,117.35 31,847.77 24,536.75 26,174.26 75,000.00 .00 75,000.00 RO-731-701 450.119 COVID-19 Expenditures .00 .00 .00 480.13 .00 .00 .00 30-731-701 450.120 Printing / Binding .00 .00 .00 31.85 500.00 .00 500.00 300-731-701450.130 Postage 287.06 312.48 425.13 355.20 300.00 235.00 400.00 !6-731-701450.140 Dues / Books / Periodicals 1,596.00 1,596.00 480.00 100.00 1,500.00 646.00 1,500.00 -qbb-731-701 450.170 Machinery / Equipment <$5000 7,733.12 630.19 1,586.79 19,625.52 10,000.00 14,791.52 20,000.00 �g0 731 701 450.180 Equipment Rental 12,892.50 175.00 811.00 1,005.00 10,000.00 583.00 10,000.00 53#-731-701 450.220 Insurance & Bonding 12,713.33 .00 .00 .00 .00 .00 .00 C 530-731-701450.221 Property Insurance .00 1,387.00 1,511.00 1,989.00 1,500.00 2,458.00 2,000.00 0- 530-731-701450.222 530-731-701450.222 General Liablity Insurance Coverage .00 9,590.33 8,305.00 6,127.46 9,200.00 6,258.42 10,000.00 W731-701 450.224 Insurance Coverage Discounts .00 (3,917.00) (3,020.33) (2,523.00) .00 (2,660.00) .00 50-731-701450.230 Advertising / Hearings 4,735.20 6,180.33 6,816.74 1,677.70 5,000.00 825.60 5,000.00 n IUO-731-701 450.231 Outreach (SWAB/Public Education) 2,190.00 4,325.50 10,735.00 6,282.42 10,000.00 5,348.78 10,000.00 O -731-701 450.266 Mercury Collection & Reporting 4,956.83 21,629.01 20,525.20 774.93 .00 .00 .00 5U0-731-701 450.270 Continuing Education 143.46 6,316.78 400.00 2,243.00 10,000.00 3,274.01 15,000.00 530-731-701450.280 Staff Training .00 700.82 .00 .00 5,000.00 .00 5,000.00 530-731-701450.290 Recruit / Relocation 2,740.35 2,328.73 116.93 1,277.15 .00 .00 .00 530-731-701450.300 Travel / Per Diem .00 597.45 70.76 151.91 3,000.00 64.21 1,500.00 530-731-701450.320 Bad Debt Expense 51,278.24 216.64 157.26 .00 .00 45.48 .00 530-731-701450.327 Fines .00 .00 .00 .00 .00 20,013.18 .00 530-731-701450.340 Telephone 13,461.37 7,160.69 1,017.94 1,080.42 2,500.00 374.36 750.00 n 530-7�1-701450.350 Electricity 27,367.02 27,423.58 29,697.42 21,280.32 25,000.00 15,110.34 25,000.00 5301-701 450.360 Fuel - Heating 24,236.31 26,008.64 11,719.65 24,814.08 25,000.00 16,803.63 25,000.00 m CD 530-7.�1-701 450.365 Fuel - Vehicle 20,819.04 22,750.72 24,790.08 19,182.99 25,000.00 9,223.57 25,000.00 v 530-U1-701 450.380 Snow Removal / Sanding 2,147.00 5,479.50 2,200.00 3,735.00 10,000.00 4,029.00 10,000.00 n 530-761-701450.390 Refuse Collection - Disposal 425.00 .00 .00 .00 .00 .00 .00 rn 530-731-701450.430 Maint & Repairs 59,840.50 53,970.11 40,033.13 43,847.92 50,000.00 20,474.62 50,000.00 y m 530-731-701450.432 Baler Maint 30,571.78 21,569.50 3,636.00 25,027.29 75,000.00 3,763.50 75,000.00 530-731-701450.435 Maint Agreements .00 .00 7,136.65 24,481.03 25,000.00 4,447.37 25,000.00 Run by Dora Cross on 03/31/2021 16:26:29 PM Page 67 of!;6 BOWOUOU 530 - Solid Waste Disposal WDepartment 731 - Waste Disposal C Sub -Department 701 - Landfill CQ Support Goods & Services a-731-701 450.440 Auto Maint & Repairs 9-731-701450.450 Contingencies Q _Vg -731-701 450.461 Safety Supplies 190-731-701450.496 Credit Card Fees Budget Worksheet Report Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh R, Ai i. Amni inh R1 irinat - I : 1,669.10 4,611.69 15,006.65 .00 .00 183.08 .00 .00 1,072.14 674.14 5,000.00 5,540.00 .00 539,000.00 576.16 1,458.31 4,000.00 .00 .00 .00 4,107.80 7,500.00 .00 .00 672.65 7,500.00 79.92 .00 1�v0-731-701 450.510 Recycling Services 252,960.00 259,824.00 270,588.00 283,176.00 260,000.00 198,223.36 300,000.00 0-731-701450.540 Clothing Allowance .00 .00 1,487.70 1,934.18 5,000.00 3,092.23 7,500.00 $gyp -731-701 450.541 Protective Equipment .00 .00 .00 .00 2,500.00 .00 .00 Support Goods & Services Totals $616,949.45 $567,560.74 $533,097.48 $573,801.15 $1,254,000.00 $383,793.13 $774,150.00 TI Equipment *-731-701466.220 Auto Liability Insurance .00 1,822.38 1,823.00 1,823.00 2,000.00 1,823.00 2,000.00 Equipment Totals $0.00 $1,822.38 $1,823.00 $1,823.00 $2,000.00 $1,823.00 $2,000.00 �• (Q Capital Outlay M-731-701 470.100 Machinery / Equipment >$5000 .00 7,000.00 .00 267,870.00 15,000.00 10,665.46 750,000.00 0 Capital Outlay Totals $0.00 $7,000.00 $0.00 $267,870.00 $15,000.00 $10,665.46 $750,000.00 (n Depreciation 9@-731-701472.020 Depr -Buildings 42,055.08 42,055.07 42,055.08 42,055.07 42,055.00 .00 42,055.00 !90-731-701472.030 Depr- Site Improvement 176,062.36 176,011.14 176,126.09 176,126.47 180,000.00 .00 176,127.00 530-731-701472.120 Depr-Machinery / Equipment 75,908.35 75,682.87 70,052.38 62,301.93 450,000.00 .00 62,302.00 Depreciation Totals $294,025.79 $293,749.08 $288,233.55 $280,483.47 $672,055.00 $0.00 $280,484.00 Debt Service - Interest 530-731-701476.105 Loan -Interest 218,994.00 17,230.00 15,738.00 15,058.00 19,500.00 16,500.00 18,000.00 530-731-701476.277 Revenue Bond 2011 Three - Interest 115,475.00 105,975.00 95,975.00 86,550.00 96,000.00 76,625.00 65,125.00 Debt Service - Interest Totals $334,469.00 $123,205.00 $111,713.00 $101,608.00 $115,500.00 $93,125.00 $83,125.00 Operating Transfers n 530-g1-701494.490 Landfill .00 205,000.00 150,000.00 160,000.00 150,000.00 150,000.00 150,000.00 m Operating Transfers Totals $0.00 $205,000.00 $150,000.00 $160,000.00 $150,000.00 $150,000.00 $150,000.00 �gndfill Property Costs v 530-51-701450.395 Closure / Post -Closure 154,010.20 367,702.59 295,000.00 149,000.00 750,000.00 .00 .00 n Land) -N Property Costs Totals $154,010.20 $367,702.59 $295,000.00 $149,000.00 $750,000.00 $0.00 $0.00 Sub -Department 701 - Landfill Totals $2,788,346.05 $2,679,396.25 $2,551,603.08 $2,414,033.25 $4,502,616.00 $1,555,014.64 $3,546,756.00 m Run by Dora Cross on 03/31/2021 16:26:29 PM Page 68 of!;6 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri Ai i. Amni inh R1 irinat - I : 530 - Solid Waste Disposal WDepartment 731 - Waste Disposal C Sub -Department 702 - Leachate Plant Personnel Services 4I? -731-702 410.110 Salaries 123,493.40 131,732.00 127,924.48 168,286.41 178,676.00 133,789.39 213,554.00 5�0-731-702 410.120 Temporary Help 1,604.08 518.59 2,878.72 810.49 2,000.00 693.51 869.00 RO-731-702 410.130 Overtime 5,181.00 7,643.42 10,718.21 6,436.03 9,000.00 2,802.85 9,435.00 30-731-702 410.152 Cell Phone Stipend .00 .00 2,200.00 1,765.00 .00 2,097.00 3,040.00 0 Personnel Services Totals $130,278.48 $139,894.01 $143,721.41 $177,297.93 $189,676.00 $139,382.75 $226,898.00 - Employee Benefits _ -731-702 420.110 Unemployment Taxes 12.81 13.77 14.40 17.07 19.00 13.67 22.00 S0-731-702 420.120 FICA Taxes 9,478.11 10,006.53 10,882.52 12,609.51 14,357.00 10,159.47 17,125.00 n 0-731-702 420.130 Group Insurance 45,145.41 48,117.70 49,054.11 62,795.79 59,368.00 43,863.37 78,588.00 !g0-731-702 420.140 Retirement 31,330.98 32,268.30 36,505.11 47,782.12 53,713.00 41,068.70 67,404.00 !&-731-702 420.150 Workers Compensation 7,848.22 10,229.56 10,327.43 11,086.80 12,918.00 6,829.64 10,675.00 7 (Q Employee Benefits Totals $93,815.53 $100,635.86 $106,783.57 $134,291.29 $140,375.00 $101,934.85 $173,814.00 0 Professional Services !R0-731-702 430.130 Consultants 3,807.50 42,776.31 1,630.01 16,344.66 45,000.00 27,190.02 65,000.00 &-731-702 430.140 Contracted Services 15,659.83 29,743.98 12,260.53 15,889.00 25,000.00 10,525.50 25,000.00 W-731-702 430.144 Design Services .00 .00 .00 .00 20,000.00 15,000.00 .00 530-731-702 430.166 Laboratory Services 27,082.12 28,788.26 68,990.08 46,022.66 70,000.00 11,174.19 75,000.00 Professional Services Totals $46,549.45 $101,308.55 $82,880.62 $78,256.32 $160,000.00 $63,889.71 $165,000.00 Support Goods & Services 530-731-702 450.110 Operating Supplies 71,582.26 93,907.18 8,695.70 11,197.56 25,000.00 6,858.62 25,000.00 530-731-702 450.111 Chemicals .00 .00 124,746.89 11,340.00 125,000.00 55,078.48 125,000.00 530-731-702 450.130 Postage .00 6.70 .00 .00 .00 .00 .00 530-731-702 450.140 Dues / Books / Periodicals .00 300.00 .00 .00 500.00 375.00 500.00 n 530-7�1-702 450.170 Machinery / Equipment <$5000 8,222.24 12,738.25 18,518.89 9,858.64 50,000.00 7,494.87 50,000.00 5301-702 450.180 Equipment Rental .00 1,195.00 8,454.00 22,160.00 10,000.00 .00 10,000.00CD m 530-7,, 1-702 450.220 Insurance & Bonding 2,394.22 .00 .00 .00 .00 .00 .00 Z 530-g1-702 450.221 Property Insurance .00 1,291.00 1,407.00 1,753.00 1,500.00 2,170.00 2,000.00 n 530-Za1-702 450.222 General Liablity Insurance Coverage .00 2,810.31 3,624.65 1,851.62 4,000.00 1,736.57 1,000.00 _ 530-731-702 450.224 Insurance Coverage Discounts .00 (1,269.00) (1,498.30) (1,107.00) .00 (1,157.00) .00 m 530-731-702 450.230 Advertising / Hearings .00 393.60 .00 211.69 500.00 .00 .00 530-731-702 450.270 Continuing Education .00 820.96 2,449.28 700.00 5,000.00 302.25 7,500.00 Run by Dora Cross on 03/31/2021 16:26:29 PM Page 69 of!;6 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh R, Ai i. Amni inh R1 irinat - I : 530 - Solid Waste Disposal WDepartment 731 - Waste Disposal C Sub -Department 702 - Leachate Plant CQ Support Goods & Services 20-731-702 450.290 Recruit / Relocation 121.50 113.03 .00 89.59 .00 .00 .00 9-731-702 450.300 Travel / Per Diem 544.32 .00 .00 22.56 5,000.00 59.83 .00 CL 212,325.78 200,696.69 220,000.00 192,176.61 180,641.00 m CD Debt Service -Interest Totals $59,899.58 $223,171.18 _Vg -731-702 450.327 Fines .00 .00 .00 .00 .00 91,657.73 .00 190-731-702 450.340 Telephone 1,377.82 738.76 1,046.12 1,067.06 1,200.00 692.68 1,200.00 -90-731-702 450.350 Electricity 90,994.69 81,359.28 81,075.95 77,922.65 80,000.00 53,598.79 80,000.00 -0-731-702 450.365 Fuel - Vehicle 367.94 1,859.72 2,003.36 1,685.50 3,500.00 668.65 1,500.00 $gyp -731-702 450.380 Snow Removal / Sanding 4,394.80 1,775.00 2,492.50 3,180.00 7,500.00 470.00 7,500.00 3R0-731-702 450.392 Septic Tank Disposal 3,007.00 1,453.00 .00 .00 3,000.00 .00 3,000.00 5n-731-702 450.430 Maint & Repairs 13,976.16 21,043.50 20,056.51 3,153.58 50,000.00 11,015.73 50,000.00 5R0-731-702 450.434 Building Maint & Repairs .00 232.60 .00 .00 10,000.00 .00 10,000.00 -731-702 450.461 Safety Supplies 7,537.28 139.65 485.76 1,950.09 5,000.00 557.95 5,000.00 3d-731-702 450.540 Clothing Allowance .00 .00 570.00 380.00 1,500.00 268.71 1,500.00 n Support Goods& Services Totals $204,520.23 $220,908.54 $274,128.31 $147,416.54 $388,200.00 $231,848.86 $380,700.00 Equipment � 3b0-731-702 466.220 Auto Liability Insurance .00 756.00 756.00 756.00 800.00 756.00 800.00 S Equipment Totals $0.00 $756.00 $756.00 $756.00 $800.00 $756.00 $800.00 Capital outlay 530-731-702 470.100 Machinery / Equipment >$5000 .00 10,756.35 92,714.00 112,233.72 25,000.00 4,730.00 365,000.00 530-731-702 470.120 Automotive 620.20 .00 .00 .00 2,000.00 .00 .00 Capital Outlay Totals Depreciation 530-731-702 472.120 Depr-Machinery / Equipment $620.20 $10,756.35 $92,714.00 $112,233.72 $27,000.00 $4,730.00 $365,000.00 00 .00 .00 119.60 .00 .00 .00 Depreciation Totals $0.00 $0.00 $0.00 $119.60 $0.00 $0.00 $0.00 L�Fbt Service -Interest ^ 530-,21-702 476.105 Loan - Interest 59,899.58 223,171.18 212,325.78 200,696.69 220,000.00 192,176.61 180,641.00 m CD Debt Service -Interest Totals $59,899.58 $223,171.18 $212,325.78 $200,696.69 $220,000.00 $192,176.61 $180,641.0000 Z Cperating Transfers Q 5304,1-702 494.490 Landfill .00 .00 28,000.00 .00 .00 .00 .00 n Operating Transfers Totals $0.00 $0.00 $28,000.00 $0.00 $0.00 $0.00 $0.00 Sub -Department 702 - Leachate Plant Totals $535,683.47 $797,430.49 $941,309.69 $851,068.09 $1,126,051.00 $734,718.78 $1,492,853.00 Department 731 - Waste Disposal Totals $3,324,029.52 $3,476,826.74 $3,492,912.77 $3,265,101.34 $5,628,667.00 $2,289,733.42 $5,039,609.00 EXPENSE TOTALS $3,324,029.52 $3,476,826.74 $3,492,912.77 $3,265,101.34 $5,628,667.00 $2,289,733.42 $5,039,609.00 Run by Dora Cross on 03/31/2021 16:26:29 PM Page 70 of!;6 K* `'Z ` S0DIAS I, IA1 D BOO r�U 0) W C Q (O (D Q fA n 3 O O 0 cn n -Tl C Z3 cc 0 C n C 67 O Budget Worksheet Report Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am—nh Am—nh Ri A—i- Amni inh RI irinat - I : Fund 530 - Solid Waste Disposal Totals REVENUE TOTALS $3,195,624.66 $3,909,016.44 $4,826,270.05 $4,403,680.46 $5,597,858.00 $2,727,319.72 $5,039,609.00 EXPENSE TOTALS $3,324,029.52 $3,476,826.74 $3,492,912.77 $3,265,101.34 $5,628,667.00 $2,289,733.42 $5,039,609.00 Fund 530 - Solid Waste Disposal Totals ($128,404.86) $432,189.70 $1,333,357.28 $1,138,579.12 ($30,809.00) $437,586.30 $0.00 n C `° rn z 00 v O n C rn _ y Run by Dora Cross on 03/31/2021 16:26:29 PM Page 71 of.96 Budget Worksheet Report �� '� B O O UH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : 540 - Hospital Fund Department 000 - Fund Revenues WInterest Earnings 80-000 361.100 Interest Earnings 166,214.36 47,612.86 57,927.41 41,831.86 30,000.00 46,910.46 .00 5Q0-000 361.300 Change in Fair Market Value (29,385.75) (23,763.08) 43,567.19 8,221.10 .00 (61,167.43) .00 j Interest Earnings Totals $136,828.61 $23,849.78 $101,494.60 $50,052.96 $30,000.00 ($14,256.97) $0.00 CL Miscellaneous - Classified -000 380.916 Providence Lease 660,000.00 1,384,272.00 1,384,272.00 1,384,272.00 1,384,272.00 1,038,204.00 1,384,272.00 p Miscellaneous - Classified Totals $660,000.00 $1,384,272.00 $1,384,272.00 $1,384,272.00 $1,384,272.00 $1,038,204.00 $1,384,272.00 O Other Financing Sources n rn y -Q-000 389.100 Use of Fund Balance .00 .00 .00 .00 115,000.00 .00 718,368.00 in Other Financing Sources Totals $0.00 $0.00 $0.00 $0.00 $115,000.00 $0.00 $718,368.00 Operating Transfers In 5n-000 391.100 General Fund 305,000.00 .00 .00 .00 .00 .00 .00 C Q-000 391.210 Land Sale Fund 650,000.00 .00 .00 .00 .00 .00 .00 a-000 391.290 Fern Fuller Trust 134,372.00 .00 .00 .00 .00 .00 .00 Operating Transfers In Totals $1,089,372.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 n Department 000 - Fund Revenues Totals $1,886,200.61 $1,408,121.78 $1,485,766.60 $1,434,324.96 $1,529,272.00 $1,023,947.03 $2,102,640.00 C REVENUE TOTALS $1,886,200.61 $1,408,121.78 $1,485,766.60 $1,434,324.96 $1,529,272.00 $1,023,947.03 $2,102,640.00 n �' u� `° rn z °° N v O n rn y Run by Dora Cross on 03/31/2021 16:26:29 PM Page 72 of96 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri Ai i. Amni inh R1 irinat - I : 540 - Hospital Fund WDepartment 740 - Hospital Enterprise Fund C Personnel Services IR0-740 410.110 Salaries .00 .00 2,876.56 28,820.33 .00 (10,173.65) .00 120-740 410.120 Temporary Help .00 .00 12.53 2,165.28 .00 (1,336.90) .00 -90-740 410.130 Overtime .00 .00 178.63 1,156.05 .00 (982.53) .00 O4D -740410.140 Allocated Salaries �V)_ 34,000.00 34,000.00 40,319.00 40,319.00 40,319.00 40,319.00 40,319.00 c7 Personnel Services Totals 3 $34,000.00 $34,000.00 $43,386.72 $72,460.66 $40,319.00 $27,825.92 $40,319.00 0 Employee Benefits SIM -740 420.110 Unemployment Taxes .00 .00 .30 2.98 .00 (1.10) .00 W-740 420.120 FICA Taxes .00 .00 229.32 2,397.06 .00 (928.24) .00 SRO -740 420.130 Group Insurance .00 .00 1,665.11 7,685.41 .00 (3,877.90) .00 740 420.140 Retirement .00 .00 672.13 6,527.87 .00 (2,426.54) .00 .90-740 420.150 Workers Compensation .00 .00 221.56 2,180.46 .00 (852.95) .00 Employee Benefits Totals $0.00 $0.00 $2,788.42 $18,793.78 $0.00 ($8,086.73) $0.00 (Q Professional Services M-740 430.140 Contracted Services 8,436.05 .00 .00 5,759.50 .00 (5,717.50) .00 F5, Professional Services Totals $8,436.05 $0.00 $0.00 $5,759.50 $0.00 ($5,717.50) $0.00 (n Support Goods & Services 590-740 450.120 Printing / Binding .00 .00 .00 3.89 .00 .00 .00 P13-740 450.170 Machinery/ Equipment <$5000 .00 .00 .00 4,921.46 .00 (4,921.46) .00 540-740 450.210 Food / Business Lunch/Meeting Rooms 188.39 .00 .00 .00 .00 .00 .00 540-740 450.220 Insurance & Bonding 180.01 .00 .00 (66.00) .00 66.00 .00 540-740 450.350 Electricity .00 .00 .00 29.62 .00 .00 .00 540-740 450.360 Fuel - Heating .00 .00 .00 17.30 .00 .00 .00 540-740 450.370 Water & Sewer .00 .00 .00 72.29 .00 .00 .00 540-740 450.430 Maint & Repairs .00 22,818.00 21,146.66 165,211.47 325,838.00 (12,160.17) .00 n 540 -?M 450.436 R&R Repairs and Maintenance .00 .00 70,167.65 420.00 .00 .00 .00 N (O Support Goods & Services Totals $368.40 $22,818.00 $91,314.31 $170,610.03 $325,838.00 ($17,015.63) $0.00 &pital Projects Z 540440 452.110 Administration .00 .00 .00 30.72 .00 .00 .00 C) O CO Capital Projects Totals $0.00 $0.00 $0.00 $30.72 $0.00 $0.00 $0.00 Mpreciation _ y 540-740 472.020 Depr -Buildings 1,086,065.83 1,083,982.48 762,603.78 762,603.77 750,044.00 .00 762,603.00 m 540-740 472.030 Depr- Site Improvement .00 .00 298,462.03 298,462.03 311,022.00 .00 298,463.00 Run by Dora Cross on 03/31/2021 16:26:30 PM Page 73 of!;6 BOWOUOU Budget Worksheet Report Budget Year 2022 S Contributions to Other Governments Totals 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's 94 Account Account Description Amount Amount Amount Amount Budget Amount Budget - L2 rD�d 540 - Hospital Fund EXPENSE TOTALS $5,801,672.22 $2,145,048.35 $1,299,796.11 $1,779,975.72 $1,543,249.00 ($37,993.94) (&XPENSE WDepartment 740 - Hospital Enterprise Fund Fund 540 - Hospital Fund Totals C Depreciation U) REVENUE TOTALS $1,886,200.61 $1,408,121.78 $1,485,766.60 $1,434,324.96 $1,529,272.00 $1,023,947.03 9-740 472.120 Depr-Machinery / Equipment 35,645.44 1,240.87 1,240.85 1,255.23 1,026.00 .00 1,255.00 $2,102,640.00 0 Depreciation Totals $1,121,711.27 $1,085,223.35 $1,062,306.66 $1,062,321.03 $1,062,092.00 $0.00 $1,062,321.00 jMiscellaneous 90-740 486.150 Other .00 277,007.00 .00 .00 .00 .00 .00 U) n Miscellaneous Totals $0.00 $277,007.00 $0.00 $0.00 $0.00 $0.00 $0.00 pOperating Transfers Q9-740 494.495 Capital Improvements -Hospital 1Q-740 494.545 Long term Care Operating Transfers Totals Contributions to Other Governments T-740 495.802 Contribution to Hospital .00 726,000.00 100,000.00 450,000.00 115,000.00 (35,000.00) 1,000,000.00 4,529,156.50 .00 .00 .00 .00 .00 .00 $4,529,156.50 $726,000.00 $100,000.00 $450,000.00 $115,000.00 ($35,000.00) $1,000,000.00 108,000.00 .00 .00 .00 .00 .00 .00 Contributions to Other Governments Totals $108,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 _Q D Department 740 - Hospital Enterprise Fund Totals $5,801,672.22 $2,145,048.35 $1,299,796.11 $1,779,975.72 $1,543,249.00 ($37,993.94) $2,102,640.00 EXPENSE TOTALS $5,801,672.22 $2,145,048.35 $1,299,796.11 $1,779,975.72 $1,543,249.00 ($37,993.94) $2,102,640.00 U7 n Fund 540 - Hospital Fund Totals U) REVENUE TOTALS $1,886,200.61 $1,408,121.78 $1,485,766.60 $1,434,324.96 $1,529,272.00 $1,023,947.03 $2,102,640.00 EXPENSE TOTALS $5,801,672.22 $2,145,048.35 $1,299,796.11 $1,779,975.72 $1,543,249.00 ($37,993.94) $2,102,640.00 0 3 Fund 540 - Hospital Fund Totals ($3,915,471.61) ($736,926.57) $185,970.49 ($345,650.76) ($13,977.00) $1,061,940.97 $0.00 n v `° m Z -0. ° rn y Run by Dora Cross on 03/31/2021 16:26:30 PM Page 74 of!;b N O,i . N AW Na + BOWOUOU 545 - Long Term Care Center Department 000 - Fund Revenues W Interest Earnings Budget Worksheet Report Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's 85-000 361.100 Interest Earnings 74.51 45,636.49 82,754.98 83,283.26 32,000.00 30,927.55 .00 -e5-000 361.300 Change in Fair Market Value .00 (42,882.53) 41,506.64 11,868.23 .00 (23,847.50) .00 � Interest Earnings Totals $74.51 $2,753.96 $124,261.62 $95,151.49 $32,000.00 $7,080.05 $0.00 O- Rents & Royalties 11 -000 380.918 LTC Lease 1,119,929.28 1,093,475.28 1,043,628.00 1,043,628.00 1,043,628.00 782,721.00 1,043,628.00 p Rents & Royalties Totals $1,119,929.28 $1,093,475.28 $1,043,628.00 $1,043,628.00 $1,043,628.00 $782,721.00 $1,043,628.00 Other Financing Sources _4Q,-000 393.521 Proceeds from Advanced Refunding 16,622.67 .00 .00 .00 .00 .00 .00 En Other Financing Sources Totals $16,622.67 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0. Operating Transfers In n rn y 543-000 391.540 Hospital 4,529,156.50 .00 .00 .00 .00 .00 .00 C Operating Transfers In Totals $4,529,156.50 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Q D' Proceeds of Long Term Debt P5-000 393.600 Premium on Bonds 57,804.47 57,804.47 57,804.00 57,804.47 57,804.00 57,804.50 57,804.00 0 Proceeds of Long Term Debt Totals $57,804.47 $57,804.47 $57,804.00 $57,804.47 $57,804.00 $57,804.50 $57,804.00 U) n Department 000 - Fund Revenues Totals C $5,723,587.43 $1,154,033.71 $1,225,693.62 $1,196,583.96 $1,133,432.00 $847,605.55 $1,101,432.00 N REVENUE TOTALS $5,723,587.43 $1,154,033.71 $1,225,693.62 $1,196,583.96 $1,133,432.00 $847,605.55 $1,101,432.00 O I n `° Zcriv °° 0 n rn y Run by Dora Cross on 03/31/2021 16:26:30 PM Page 75 of!;6 N Budget Worksheet Report CD `s -. N SODIAS I, I� D DH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri Ai i. Amni inh R1 irinat - I : 545 - Long Term Care Center WDepartment 742 - Elder Care C Professional Services 85-742 430.140 Contracted Services .00 .00 3,150.00 .00 .00 .00 75,000.00 (1) Professional Services Totals $0.00 $0.00 $3,150.00 $0.00 $0.00 $0.00 $75,000.00 Le gal 34-5-742 431.120 Legal Fees 112.00 .00 .00 .00 .00 520.00 .00 C/) Legal Services Totals $112.00 $0.00 $0.00 $0.00 $0.00 $520.00 $0.00 = Support Goods & Services 25-742 450.220 Insurance & Bonding 43,536.48 .00 .00 .00 .00 .00 .00 Q-742 450.221 Property Insurance .00 21,765.00 23,692.00 29,519.00 20,000.00 36,288.00 30,000.00 M-742 450.222 General Liablity Insurance Coverage .00 .00 1,681.76 1,490.25 .00 1,373.46 .00 5Q5-742 450.224 Insurance Coverage Discounts .00 (5,723.00) (6,446.53) (7,869.00) .00 (9,141.00) .00 -742 450.450 Contingencies .00 .00 .00 .00 152,224.00 .00 56,824.00 1 CL EXPENSE TOTALS Support Goods & Services Totals $43,536.48 $16,042.00 $18,927.23 $23,140.25 $172,224.00 $28,520.46 $86,824.00 cQ Depreciation �J-742 472.020 Depr -Buildings 518,933.00 518,933.00 518,933.00 518,932.87 518,933.00 .00 518,933.00 n Depreciation Totals $518,933.00 $518,933.00 $518,933.00 $518,932.87 $518,933.00 $0.00 $518,933.00 c: Debt Service - Interest -45-742 476.244 Revenue Bond 2013B - Interest 611,781.25 530,863.00 476,802.00 461,421.00 442,275.00 221,137.50 420,675.00 73 Debt Service - Interest Totals $611,781.25 $530,863.00 $476,802.00 $461,421.00 $442,275.00 $221,137.50 $420,675.00 Other $1,133,432.00 $847,605.55 $1,101,432.00 Z o EXPENSE TOTALS $1,240,452.64 $1,065,838.00 545-742 493.170 Loss On Extinguishment Of Debt 54,589.91 .00 .00 .00 .00 .00 .00 Other Totals $54,589.91 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Refunded Bond Uses 545-742 493.140 Bond Issuance Costs 11,500.00 .00 .00 .00 .00 .00 .00 Refunded Bond Uses Totals $11,500.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Fund 545 - Long Term Care Center Totals $4,483,134.79 $88,195.71 $207,881.39 $193,089.84 $0.00 $597,427.59 $0.00 _ m 3 Run by Dora Cross on 03/31/2021 16:26:30 PM Page 76 of!;6 Department 742 - Elder Care Totals $1,240,452.64 $1,065,838.00 $1,017,812.23 $1,003,494.12 $1,133,432.00 $250,177.96 $1,101,432.00 EXPENSE TOTALS $1,240,452.64 $1,065,838.00 $1,017,812.23 $1,003,494.12 $1,133,432.00 $250,177.96 $1,101,432.00 cQ Fund 545 - Long Term Care Center Totals m m 00 REVENUE TOTALS $5,723,587.43 $1,154,033.71 $1,225,693.62 $1,196,583.96 $1,133,432.00 $847,605.55 $1,101,432.00 Z o EXPENSE TOTALS $1,240,452.64 $1,065,838.00 $1,017,812.23 $1,003,494.12 $1,133,432.00 $250,177.96 $1,101,432.00 0 Fund 545 - Long Term Care Center Totals $4,483,134.79 $88,195.71 $207,881.39 $193,089.84 $0.00 $597,427.59 $0.00 _ m 3 Run by Dora Cross on 03/31/2021 16:26:30 PM Page 76 of!;6 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh R, A -i- Amni inh R1 irinat - I : 555 - KFRC Department 000 - Fund Revenues W Federal Grants 05-000 331.119 CORONAVIRUS Relief Fund (CARES ACT) .00 .00 .00 1,257.42 .00 7,132.08 .00 CD Federal Grants Totals $0.00 $0.00 $0.00 $1,257.42 $0.00 $7,132.08 $0.00 State Shared Revenues 3D-5-000 335.190 PERS on Behalf Payment 6,911.81 9,005.52 5,513.07 (4,534.71) 10,221.00 9,307.00 10,838.00 WState Shared Revenues Totals $6,911.81 $9,005.52 $5,513.07 ($4,534.71) $10,221.00 $9,307.00 $10,838.00 = Interest Earnings -5-000 361.100 Interest Earnings 27,622.61 41,433.90 54,398.03 50,242.77 25,000.00 26,385.81 .00 -000 361.104 Loan Interest 59,134.47 55,214.43 51,154.99 46,951.20 42,597.00 32,364.91 38,090.00 3Z-000 361.300 Change in Fair Market Value (17,250.91) (30,601.34) 35,187.27 7,886.64 .00 (20,623.31) .00 Interest Earnings Totals $69,506.17 $66,046.99 $140,740.29 $105,080.61 $67,597.00 $38,127.41 $38,090.00 - Rents & Royalties 5&5-000 363.300 NOAA Lease (through GSA) 685,315.24 699,427.68 699,427.69 699,427.68 600,000.00 509,081.85 602,475.00 &-000 363.303 Natural Resources Conservation (through .00 8,144.24 24,432.72 24,432.72 25,000.00 18,324.54 26,311.00 (Q GSA) 49-000 363.304 NOAA COVID-19 Revenue (through GSA) .00 .00 .00 .00 .00 6,148.94 .00 to 495-000 363.312 KIBSD Lease for Office & Lab 24,840.00 .00 .00 .00 .00 .00 .00 -V5-000 363.320 Fish & Game Lease 58,840.00 58,840.00 60,566.00 45,396.00 60,000.00 60,940.50 61,628.00 5 000 363.321 Apartment Rent .00 .00 6,194.75 .00 .00 .00 .00 555-000 363.330 University of Alaska 66,053.84 39,870.05 8,082.33 .00 .00 .00 .00 555-000 363.340 KFRC Reception Revenue 950.00 1,075.00 693.26 438.70 750.00 .00 .00 555-000 363.350 Kodiak Regional Aquaculture Association 11,642.71 18,924.72 20,501.78 17,347.66 15,000.00 15,770.60 18,924.00 Rents & Royalties Totals $847,641.79 $826,281.69 $819,898.53 $787,042.76 $700,750.00 $610,266.43 $709,338.00 Miscellaneous - Classified 555-000 380.170 Other .00 .00 .00 .00 .00 12,950.00 .00 555-000 380.294 Contributions .00 365.00 268.00 251.94 .00 .00 .00 n Miscellaneous - Classified Totals $0.00 $365.00 $268.00 $251.94 $0.00 $12,950.00 $0.00 (Q ger Financing Sources m 555-g0 389.100 Use of Fund Balance .00 .00 .00 .00 1,447,407.00 .00 3,306,926.00 Z v Other Financing Sources Totals O $0.00 $0.00 $0.00 $0.00 $1,447,407.00 $0.00 $3,306,926.00 n derating Transfers In 555-900 391.277 Transfer in Tourism Development 45,000.00 45,000.00 45,000.00 45,000.00 .00 .00 .00 555-000 391.426 KRFC Building 19,179.97 .00 .00 .00 .00 .00 .00 m Operating Transfers In Totals $64,179.97 $45,000.00 $45,000.00 $45,000.00 $0.00 $0.00 $0.00 Run by Dora Cross on 03/31/2021 16:26:30 PM Page 77 of!;6 -' n �' `° Budget Worksheet Report * 14 K'ODLAR'IS-LAMD O n C rn _ y N Run by Dora Cross on 03/31/2021 16:26:30 PM Page 78 of.96 Budget Year 2022 B00H UgW 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's ($L Account Account Description Amount Amount Amount Amount Budget Amount Budget - L2 FQDnd 555 - KFRC N2EVENUE I Department 000 - Fund Revenues Totals $988,239.74 $946,699.20 $1,011,419.89 $934,098.02 $2,225,975.00 $677,782.92 $4,065,192.00 W REVENUE TOTALS C $988,239.74 $946,699.20 $1,011,419.89 $934,098.02 $2,225,975.00 $677,782.92 $4,065,192.00 CL (C! CD 0) CL fA n 3 O O 0 cn n -1 C CL D O c n C cn O n �' `° rn z 0000 v O n C rn _ y Run by Dora Cross on 03/31/2021 16:26:30 PM Page 78 of.96 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri Ai i. Amni inh R1 irinat - I : 555 - KFRC WDepartment 758 - Research Facility C Personnel Services ct-758 410.110 Salaries 159,109.34 156,112.22 135,863.56 148,214.51 154,393.00 88,429.86 126,688.00 �L-758 410.120 Temporary Help 1,196.47 2,650.11 7,455.12 5,456.27 .00 8,216.80 6,952.00 5 758 410.130 Overtime 1,637.34 2,210.63 3,973.09 3,407.11 .00 1,579.24 .00 CL !6-5-758 410.140 Allocated Salaries 24,000.00 24,000.00 24,000.00 24,000.00 24,000.00 24,000.00 24,000.00 !g5-758 410.152 Cell Phone Stipend .00 .00 1,200.00 1,200.00 .00 900.00 1,440.00 O O_ Personnel Services Totals $185,943.15 $184,972.96 $172,491.77 $182,277.89 $178,393.00 $123,125.90 $159,080.00 Employee Benefits !R-758 420.110 Unemployment Taxes 15.00 14.91 13.63 282.50 15.00 8.95 13.00 T-758 420.120 FICA Taxes 13,399.33 11,496.10 10,765.82 11,491.22 11,811.00 7,410.80 10,223.00 5!6-758 420.130 Group Insurance 49,594.55 48,999.44 47,593.82 46,535.84 52,234.00 25,039.93 52,614.00 !§5-758 420.140 Retirement 39,502.29 38,282.45 35,715.18 42,331.03 44,187.00 30,052.51 40,239.00 _§5-758 420.145 OPEB & Pension Expense 75,460.00 (7,496.00) (18,546.00) (55,260.00) .00 .00 .00 05-758 420.150 Workers Compensation 9,508.25 9,600.38 9,487.36 10,110.32 6,335.00 5,986.85 8,023.00 Employee Benefits Totals $187,479.42 $100,897.28 $85,029.81 $55,490.91 $114,582.00 $68,499.04 $111,112.00 0 Support Goods & Services C 15-758 450.100 Office Supplies 499.67 471.92 613.40 403.86 600.00 196.89 600.00 'i95-758 450.110 Operating Supplies 3,977.53 362.30 2,641.01 1,615.83 2,000.00 315.29 2,000.00 C 555-758 450.119 COVID-19 Expenditures .00 .00 .00 113.34 .00 13,281.02 .00 555-758 450.160 Furniture / Fixtures .00 .00 1,929.29 .00 4,000.00 .00 4,000.00 555-758 450.220 Insurance & Bonding .00 .00 .00 (217.00) .00 .00 .00 555-758 450.270 Continuing Education .00 124.32 .00 500.00 1,000.00 147.25 2,000.00 555-758 450.300 Travel / Per Diem .00 .00 13.92 9.24 1,000.00 11.29 .00 555-758 450.340 Telephone 529.65 618.48 1,211.08 1,655.23 1,800.00 1,379.15 2,000.00 555-758 450.365 Fuel - Vehicle 675.11 783.04 1,063.98 1,130.70 1,200.00 392.83 1,200.00 n 555-§ 450.435 Maint Agreements 4,590.00 4,200.00 5,904.94 6,762.66 59,700.00 7,226.92 15,000.00 555-'98 450.440 Auto Maint & Repairs 597.30 204.62 180.97 33.48 1,500.00 10.00 1,500.00 Z 555-%8 450.461 Safety Supplies 658.95 3,586.98 383.42 699.02 5,000.00 281.50 3,000.00 v 555-9a8 450.540 Clothing Allowance .00 .00 285.00 471.60 700.00 579.38 700.00 n M Support Goods& Services Totals $11,528.21 $10,351.66 $14,227.01 $13,177.96 $78,500.00 $23,821.52 $32,000.00 Depreciation m 555-758 472.020 Depr -Buildings 594,680.33 594,680.33 594,680.34 594,680.33 595,000.00 .00 595,000.00 Run by Dora Cross on 03/31/2021 16:26:30 PM Page 79 of!;b N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : 555 - KFRC WDepartment 758 - Research Facility C: Depreciation ct-758 472.030 Depr- Site Improvement 101,792.90 101,792.90 101,795.57 67,729.04 102,000.00 .00 102,000.00 a-758 472.120 Depr-Machinery / Equipment 6,027.59 2,538.19 .00 .00 .00 .00 .00 O Depreciation Totals $702,500.82 $699,011.42 $696,475.91 $662,409.37 $697,000.00 170,000.00 $0.00 $697,000.00 CL Cleaning/Janitor/Etc Electrical 5,000.00 5&-758 482.110 Electrical - Light & Power 3-085-758 482.120 Replacement Parts 7,961.38 4,083.86 14-758 480.120 Supplies 66.94 .00 .00 .00 .00 $128,430.41 .00 1,000.00 .5-758 480.130 Contracted Services 53,249.99 60,783.94 53,980.50 53,843.77 75,000.00 12,316.52 43,065.47 75,000.00 O .00 .00 3,000.00 .00 3,000.00 9,254.91 9,809.60 2,084.90 -758480.140 Aquarium Cleaning 77.60 .00 42.90 .00 500.00 5,278.70 .00 500.00 � 75,000.00 $46,972.27 $57,593.68 $40,613.35 $46,049.05 $258,000.00 $17,618.59 $118,000.00 (' Cleaning/Janitor/Etc Totals $53,394.53 $60,783.94 $54,023.40 $53,843.77 $75,500.00 $43,065.47 $76,500.00 m. Heating 132,462.63 ,QS -758 481.120 Fuel 0-758 481.130 System Maint & Repair 170,000.00 1,476.57 CL .00 Electrical 5,000.00 5&-758 482.110 Electrical - Light & Power 3-085-758 482.120 Replacement Parts 7,961.38 4,083.86 gS5-758 482.140 System Maint & Repair 72,309.23 74,727.92 68,160.10 57,844.31 75,000.00 9,005.66 25,000.00 3,693.50 3,176.68 240.55 4,747.54 10,000.00 207.24 10,000.00 Heating Totals $76,002.73 $77,904.60 $68,400.65 $62,591.85 $85,000.00 $9,212.90 $35,000.00 L Electrical Totals O :3 Plumbing 555-758 483.110 Water 555-758 483.120 555-758 483.130 555-758 483.140 Air Conditioning 555-758 484.110 555 -VB 484.120 u] (D Rvators 555-58 485.120 Supplies System Maint & Repair Sea Water Pump Repairs Plumbing Totals 137,456.60 132,462.63 138,060.51 124,346.55 145,000.00 95,575.42 170,000.00 1,476.57 .00 .00 .00 5,000.00 1,093.55 5,000.00 3,706.93 176.00 7,961.38 4,083.86 10,000.00 1,757.07 10,000.00 $142,640.10 $132,638.63 $146,021.89 $128,430.41 $160,000.00 $98,426.04 $185,000.00 26,447.12 27,806.60 33,249.75 24,443.76 30,000.00 12,316.52 30,000.00 154.80 .00 .00 .00 3,000.00 .00 3,000.00 9,254.91 9,809.60 2,084.90 8,636.28 150,000.00 565.31 10,000.00 11,115.44 19,977.48 5,278.70 12,969.01 75,000.00 4,736.76 75,000.00 $46,972.27 $57,593.68 $40,613.35 $46,049.05 $258,000.00 $17,618.59 $118,000.00 Utilities - Ventilate .00 921.00 2,750.00 3,250.00 1,500.00 .00 4,000.00 n System Maint & Repair 42.18 60.00 .00 41.21 10,000.00 190.97 10,000.00 Air Conditioning Totals $42.18 $981.00 $2,750.00 $3,291.21 $11,500.00 $190.97 $14,000.00 System Maint & Repair 1,800.00 2,250.00 2,362.50 900.00 2,700.00 16,484.15 20,000.00 CD Elevators Totals $1,800.00 $2,250.00 $2,362.50 $900.00 $2,700.00 $16,484.15 $20,000.00 � Rscellaneous m 555-758 486.140 Lawn / Landscape Maint 17,729.35 384.00 402.00 .00 5,000.00 32.85 5,000.00 555-758 486.150 Other 484.00 100.00 260.00 158.27 500.00 107.00 .00 Run by Dora Cross on 03/31/2021 16:26:30 PM Page 80 of!;6 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am—nh Am—nh Ri A—i- Amni inh R1 irinat - I : 555 - KFRC WDepartment 758 - Research Facility C: Miscellaneous ct-758 486.170 Machinery / Equipment .00 2,836.97 2,747.08 .00 25,000.00 .00 25,000.00 �L-758 486.220 Insurance & Bonding 11,281.92 9,477.16 10,186.88 12,525.62 18,000.00 14,237.58 18,000.00 'N5-758 486.340 Telephone 7,609.65 7,627.166,693.28 7,166.96 8,000.00 4,046.92 6,000.00 CL !6-5-758 486.380 Snow Removal / Disposal 1,929.15 3,560.86 1,300.00 10,546.00 15,000.00 5,610.00 15,000.00 !g5-758 486.390 Refuse Collection 6,513.60 7,443.80 7,930.92 8,098.80 8,000.00 5,184.15 8,500.00 -85-758 486.430 Maint & Repairs 4,129.75 2,189.47 1,520.76 4,245.78 15,000.00 4,975.20 15,000.00 .0-758 486.436 R&R Repair and Maintenance .00 .00 144,993.24 80,051.59 350,000.00 32,636.09 .00 Miscellaneous Totals $49,677.42 $33,619.42 $176,034.16 $122,793.02 $444,500.00 $66,829.79 $92,500.00 n' Building Repairs 'i -758 487.430 Building Maint & Repairs 7,868.44 21,050.36 30,916.72 3,685.07 25,000.00 240.80 25,000.00 C Building airs Re Totals p $7,868.44 $21,050.36 $30,916.72 $3,685.07 $25,000.00 $240.80 $25,000.00 Q Operating Transfers v m `° Z 0 a-758 494.276 Transfer Out - Fund 276 .00 .00 .00 .00 .00 .00 2,500,000.00 -$-758 494.426 KRFC .00 .00 180,000.00 210,000.00 .00 120,000.00 .00 .*-758 494.428 Capital Projects - KFRC .00 .00 .00 .00 120,000.00 .00 .00 C (n Operating Transfers Totals $0.00 $0.00 $180,000.00 $210,000.00 $120,000.00 $120,000.00 $2,500,000.00 W. O Department 758 - Research Facility Totals $1,465,849.27 $1,382,054.95 $1,669,347.17 $1,544,940.51 $2,250,675.00 $587,515.17 $4,065,192.00 —S EXPENSE TOTALS $1,465,849.27 $1,382,054.95 $1,669,347.17 $1,544,940.51 $2,250,675.00 $587,515.17 $4,065,192.00 Fund 555 - KFRC Totals REVENUE TOTALS $988,239.74 $946,699.20 $1,011,419.89 $934,098.02 $2,225,975.00 $677,782.92 $4,065,192.00 EXPENSE TOTALS $1,465,849.27 $1,382,054.95 $1,669,347.17 $1,544,940.51 $2,250,675.00 $587,515.17 $4,065,192.00 Fund 555 - KFRC Totals ($477,609.53) ($435,355.75) ($657,927.28) ($610,842.49) ($24,700.00) $90,267.75 $0.00 n v m `° Z 0 y rn y Run by Dora Cross on 03/31/2021 16:26:30 PM Page 81 of!;b K'0DK'ID BO OU H 556 - Research Court Apartments Department 000 - Fund Revenues WState Shared Revenues 1@6-000 335.190 PERS on Behalf Payment (�D State Shared Revenues Totals Interest Earnings 3SC-000 361.100 Interest Earnings -000 361.300 Change in Fair Market Value 3 O Interest Earnings Totals O Rents & Royalties J5;-000 363.321 Apartment Rent in Rents & Royalties Totals Miscellaneous - Classified 59•6-000 380.170 Other C QMiscellaneous - Classified Totals Other Financing Sources �@6-000 389.100 Use of Fund Balance Budget Worksheet Report Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh Ri A -i- Amni inh R1 irinat - I : .00 .00 .00 .00 .00 .00 684.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $684.00 00 .00 .00 256.96 .00 267.40 .00 .00 .00 .00 25.91 .00 (212.07) .00 $0.00 $0.00 $0.00 $282.87 $0.00 $55.33 $0.00 .00 .00 .00 49,560.06 30,000.00 53,283.50 73,800.00 $0.00 $0.00 $0.00 $49,560.06 $30,000.00 $53,283.50 $73,800.00 .00 .00 .00 .00 .00 200.00 .00 $0.00 $0.00 $0.00 $0.00 $0.00 $200.00 $0.00 .00 .00 .00 .00 27,483.00 .00 5,150.00 c• Other Financing Sources Totals $0.00 $0.00 $0.00 $0.00 $27,483.00 $0.00 $5,150.00 n Department 000 - Fund Revenues Totals $0.00 $0.00 $0.00 $49,842.93 $57,483.00 $53,538.83 $79,634.00 C Cn REVENUE TOTALS $0.00 $0.00 $0.00 $49,842.93 $57,483.00 $53,538.83 $79,634.00 O n �' `° rn z N O n C rn _ y Run by Dora Cross on 03/31/2021 16:26:30 PM Page 82 of96 C:) K'0DLAK'IS-LA1VD PO a D O O UH 556 - Research Court Apartments WDepartment 759 - Apartments C Personnel Services cg6-759 410.110 Salaries 26-759 410.120 Temporary Help a-759 410.130 Overtime C- U) Personnel Services Totals n Employee Benefits Budget Worksheet Report Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am-nh Am-nh R, A -i- Amni inh R1 irinat - I : .00 .00 .00 5,981.46 4,165.00 4,908.20 7,560.00 .00 .00 .00 108.62 .00 211.58 870.00 .00 .00 .00 189.86 .00 237.95 .00 $0.00 $0.00 $0.00 $6,279.94 $4,165.00 $5,357.73 $8,430.00 Z6-759 420.110 Unemployment Taxes .00 .00 .00 .62 .00 .54 1.00 O $0.00 $0.00 $0.00 $34,066.60 $0.00 $0.00 $0.00 456-759 420.120 FICA Taxes .00 .00 .00 457.84 319.00 397.16 645.00 J'6-759 420.130 Group Insurance .00 .00 .00 1,837.76 1,274.00 1,577.23 3,330.00 R6-759 420.140 Retirement .00 .00 .00 1,346.94 1,192.00 1,125.97 2,538.00 -759 420.150 Workers Compensation .00 .00 .00 493.80 233.00 292.39 390.00 C C Employee Benefits Totals $0.00 $0.00 $0.00 $4,136.96 $3,018.00 $3,393.29 $6,904.00 Q Support Goods & Services 06-759 450.224 Insurance Coverage Discounts M-759 450.340 Telephone nSupport Goods & Services Totals U) Depreciation 00 .00 .00 (742.00) .00 .00 .00 00 .00 .00 1,136.48 .00 1,033.33 .00 $0.00 $0.00 $0.00 $394.48 $0.00 $1,033.33 $0.00 �6-759 472.030 Depr- Site Improvement .00 .00 .00 34,066.60 .00 .00 .00 73 Depreciation Totals $0.00 $0.00 $0.00 $34,066.60 $0.00 $0.00 $0.00 Cleaning / Janitor / Etc 556-759 480.130 Contracted Services .00 .00 .00 4,037.04 5,000.00 5,456.36 5,000.00 Cleaning/Janitor/Etc Totals $0.00 $0.00 $0.00 $4,037.04 $5,000.00 $5,456.36 $5,000.00 Heating 556-759 481.120 Fuel .00 .00 .00 4,688.61 10,000.00 3,704.67 10,000.00 556-759 481.130 System Maint & Repair .00 .00 .00 344.64 1,500.00 .00 1,500.00 Heating Totals $0.00 $0.00 $0.00 $5,033.25 $11,500.00 $3,704.67 $11,500.00 n Mctrical 556,A9 482.110 Electrical - Light & Power .00 .00 .00 4,643.14 4,500.00 3,868.78 5,000.00 m CD 556-7&9 482.120 Replacement Parts .00 .00 .00 91.42 500.00 .00 500.00 v 556-59 482.140 System Maint & Repair .00 .00 .00 .00 5,000.00 .00 5,000.00 n ro Electrical Totals $0.00 $0.00 $0.00 $4,734.56 $10,000.00 $3,868.78 $10,500.00 Rumbing m 556-759 483.110 Water .00 .00 .00 9,937.59 6,500.00 4,526.81 10,000.00 556-759 483.120 Supplies .00 .00 .00 919.79 500.00 28.42 500.00 Run by Dora Cross on 03/31/2021 16:26:30 PM Page 83 of!;b K'0DK'ID BO OU H RWd 556 - Research Court Apartments ISEXPENSE I Department 759 - Apartments W Plumbing 9-759 483.130 System Maint & Repair (D Budget Worksheet Report Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amount Amount Amount Amount Budget Amount Budget - L, 00 .00 .00 231.84 5,000.00 .00 5,000.00 Fund 556 - Research Court Apartments Totals $0.00 $0.00 $0.00 ($24,982.83) $0.00 $22,493.81 $0.00 Plumbing Totals $0.00 $0.00 $0.00 $11,089.22 o $12,000.00 �. $4,555.23 $15,500.00 _ y jMiscellaneous Run by Dora Cross on 03/31/2021 16:26:30 PM Page 84 of.96 596-759 486.140 Lawn / Landscape Maint .00 .00 .00 .00 5,000.00 .00 5,000.00 U) 56-759 486.150 Other .00 .00 .00 1,822.74 .00 1,348.86 .00 386-759 486.220 Insurance & Bonding .00 .00 .00 2,923.76 1,800.00 2,250.47 1,800.00 13-759 486.390 Refuse Collection .00 .00 .00 .00 5,000.00 .00 5,000.00 EM -759 486.430 Maint & Repairs .00 .00 .00 58.00 .00 76.30 10,000.00 n' Miscellaneous Totals $0.00 $0.00 $0.00 $4,804.50 $11,800.00 $3,675.63 $21,800.00 1l Building Repairs -Z6-759 487.430 Building Maint & Repairs .00 .00 .00 249.21 .00 .00 .00 Q Building Repairs Totais $0.00 $0.00 $0.00 $249.21 $0.00 $0.00 $0.00 (� Department 759 - Apartments Totals $0.00 $0.00 $0.00 $74,825.76 $57,483.00 $31,045.02 $79,634.00 EXPENSE TOTALS $0.00 $0.00 $0.00 $74,825.76 $57,483.00 $31,045.02 $79,634.00 c Fund 556 - Research Court Apartments Totals C Cn REVENUE TOTALS $0.00 $0.00 $0.00 $49,842.93 $57,483.00 $53,538.83 $79,634.00 p' EXPENSE TOTALS $0.00 $0.00 $0.00 $74,825.76 $57,483.00 $31,045.02 $79,634.00 Fund 556 - Research Court Apartments Totals $0.00 $0.00 $0.00 ($24,982.83) $0.00 $22,493.81 $0.00 n CD `. rn Z o ° �. n C rn _ y Run by Dora Cross on 03/31/2021 16:26:30 PM Page 84 of.96 560 - 911 Service K'0DK'ID BO OU H Budget Worksheet Report Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's . Department 000 - Fund Revenues �' `. rn Z ` n v 0 WMiscellaneous - Classified y C90-000 380.215 Customer Charges 28,408.94 255,616.76 300,078.01 295,447.17 300,000.00 186,559.15 295,000.00 C(D Miscellaneous - Classified Totals $28,408.94 $255,616.76 $300,078.01 $295,447.17 $300,000.00 $186,559.15 $295,000.00 v Department 000 - Fund Revenues Totals $28,408.94 $255,616.76 $300,078.01 $295,447.17 $300,000.00 $186,559.15 $295,000.00 Q- REVENUE TOTALS $28,408.94 $255,616.76 $300,078.01 $295,447.17 $300,000.00 $186,559.15 $295,000.00 fA n 3 O O X cn n -1 C D E n C En O n �' `. rn Z ` n v 0 n rn y Run by Dora Cross on 03/31/2021 16:26:30 PM Page 85 of.96 N Budget Worksheet Report CD `s -. N SS I, I ODIAAD PO DOOH Budget Year 2022 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended 2021 Actual 2022 Manager's Amni inh Amnunh Am—nh Am—nh Ri A—i- Amni inh R1 irinat - I : 560 - 911 Service WDepartment 760 - NIRF or 911 Service `° Z O C Personnel Services rn y Run by Dora Cross on 03/31/2021 16:26:30 PM Page 86 of!;6 00-760 410.140 Allocated Salaries 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 (1) Personnel Services Totals $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 0) Contracted Services 5W-760 444.115 Telephone Services 26,855.91 253,983.42 298,264.81 293,657.61 298,200.00 110,565.15 293,200.00 C/) Contracted Services Totals $26,855.91 $253,983.42 $298,264.81 $293,657.61 $298,200.00 $110,565.15 $293,200.00 = Support Goods & Services aQ-760 450.220 Insurance & Bonding 53.03 .00 .00 .00 .00 .00 .00 -760 450.222 General Liablity Insurance Coverage .00 181.34 400.44 411.14 400.00 440.52 300.00 3M-760 450.224 Insurance Coverage Discounts Support Goods & Services Totals Department 760 - NIRF or 911 Service Totals _Q EXPENSE TOTALS Fund 560 - 911 Service Totals .00 (48.00) (104.82) (104.00) (100.00) (113.00) .00 $53.03 $133.34 $295.62 $307.14 $300.00 $327.52 $300.00 $28,408.94 $255,616.76 $300,060.43 $295,464.75 $300,000.00 $112,392.67 $295,000.00 $28,408.94 $255,616.76 $300,060.43 $295,464.75 $300,000.00 $112,392.67 $295,000.00 Q p REVENUE TOTALS $28,408.94 $255,616.76 $300,078.01 $295,447.17 $300,000.00 $186,559.15 $295,000.00 U) EXPENSE TOTALS $28,408.94 $255,616.76 $300,060.43 $295,464.75 $300,000.00 $112,392.67 $295,000.00 C cn Fund 560 - 911 Service Totals $0.00 $0.00 $17.58 ($17.58) $0.00 $74,166.48 $0.00 N O Net Grand Totals REVENUE GRAND TOTALS $39,245,495.45 $33,540,663.40 $38,767,947.49 $35,457,145.06 $45,420,579.00 $35,860,640.66 $40,495,689.00 EXPENSE GRAND TOTALS $44,476,110.54 $33,102,997.89 $33,758,244.63 $33,860,175.79 $45,502,978.00 $31,851,314.30 $40,495,689.00 Net Grand Totals ($5,230,615.09) $437,665.51 $5,009,702.86 $1,596,969.27 ($82,399.00) $4,009,326.36 $0.00 n `° Z O n rn y Run by Dora Cross on 03/31/2021 16:26:30 PM Page 86 of!;6 KOIDIAK ISLAND BOROUGH Meeting Type: . �SS�m h�� Nere ,SeSS%v Date: Please 13RINT your name legibly Please PRINT your name legibly --ram_ L- i� y Borough Assembly Work Session Attendance Date: Arndt vorak Kavanaugh Smith 1 Symmons Turner t Williams )