supplemental budget summary - north plains

SupplementalBudgetSummaryExplanations

[1] Anadditional$4,000inFranchiseFeesareexpectedduetoincreasedpopulation. Anadditional$13,000inLandUseFeesareexpectedduetocontinuedbuildingintheCity.[2] AreductioninState-sharedrevenuesisduetolaginreportingpopulationincreasestoPortland

StateUniversityandtheremovalofWCCLSPool2sinceitisnotguaranteed,andtheamountisunknown.

[3] ThisisadditionalCOPSgrantrevenue–theCityhasappliedforthisgrant,buttheofficerwillnotbehiredunlessthegrantisapproved.

[4] Budgetstructuralchange–afewyearsagothebudgetwaschangedsothatallpersonnelexpendituresandmostmaterialsandserviceswererecordedintheGeneralFundwithanegativelineitemshowingthereimbursementfromotherfunds.The“bestpractice”wouldbetorecordthecostofthegoodsorservicesinthefundsthatareusingthegoodsorservices.Inthecaseofonefundreimbursinganother,thatshouldbereflectedasarevenueinthefundreceivingthereimbursement.Thisdoesnotaffectendingfundbalanceinanyofthefunds,butinsteadpresentsaclearerpictureoftheactualtransactions.

[5] TheincreaseinthePoliceDepartmentbudgetistobuy2newpolicecarsthisyearandreflecttheadditionalcostoftheCOPSgrantpoliceofficer.Asnotedabove,ifthegrantisnotapprovedtheofficerwillnotbehired.

[6] Theincreaseisforadditionallibrarymaterialstokeepupwithpopulationgrowth.TheLibraryDirectoralsorestructuredhisdepartment,decreasingthenumberofpart-timeemployeesandincreasingthenumberoffull-timeemployees.Thisresultedinaslightdecreaseinsalariesandbenefitscomparedtotheadoptedbudget.

[7] Thisincreasereflectsanadditional$1,500ConcertsinthePark(wasnotintheoriginalbudget)and$200additionaltoIceCreamSocial(was$350,butincreasedto$550).

[8] NotethatParksmovedfromCityemployeestoacontractforParkMaintenance.TheemployeetimehasbeenmovedtotheStreetsandWaterFunds.

[9] TheincreaseisduetoadditionalservicesasmorebuildingisplannedwithintheCity.[10] PolicetransfertoVehicle/EquipmentReplacementFundwasremovedastwonewvehiclesare

beingpurchasedthisyearfromtheGeneralFund.ItisanticipatedthatcontributionstotheReplacementFundwillresumenextyear.

[11] StreetPersonnelServicesincreasedoverallasformerPublicWorks-Parksemployeeswerereallocated.

[12] WaterFundallocationswerereviewedandadditionalcostwasallocatedtotheWaterFund.

GENERALFUNDSUMMARYFY2017-18

Description Adopted Change Supplemental

ReservedforGarlicFestival 3,738 - 3,738Unreserved 1,096,262 - 1,096,262

OPENINGFUNDBALANCE 1,100,000 - 1,100,000

REVENUESPropertyTaxes 499,643 - 499,643Licenses,Permits,Fees 492,634 17,217 509,851 [1]Intergovernmental 325,073 (96,792) 228,281 [2]FinesandForfeitures 20,500 - 20,500GrantsandDonations 43,089 60,837 103,926 [3]OtherRevenue 33,705 157,951 191,656 [4]

TOTALREVENUES 1,414,644 139,213 1,553,857

EXPENDITURESGeneralGovernment 215,401 158,483 373,884 [4]Police 437,651 131,396 569,047 [5]PublicWorks 25,675 6,210 31,885 [4]Library 341,500 14,202 355,702 [6]CultureandRecreation 4,900 1,700 6,600 [7]Parks 75,964 0 75,964 [8]Planning 193,580 11,463 205,043 [9]Transfers 19,847 (4,729) 15,118 [10]

TOTALEXPENDITURES 1,314,518 318,725 1,633,243

NETBEFORECONTINGENCY 100,126 (179,512) (79,386)

Contingency 100,000 - 100,000

CHANGEINFUNDBALANCE 126 (179,512) (179,386)

UNAPPROPRIATED:RESERVEFORFUTUREEXPENDITURE 353,430 (179,512) 173,918ENDINGFUNDBALANCE 746,696 - 746,696

1,100,126 (179,512) 920,614ReservedforGarlicFestival 4,964 200 5,164Unreserved 1,095,162 (179,712) 915,450

SupplementalBudgetSummary

STREETFUND111-433FY2017-18

Acct Description Adopted Change Supplemental

StreetFeeinLieu 20,000 - 20,000RecologyFund 30,000 - 30,000SDCsforTransSystemPlan 194,525 - 194,525Operations 113,475 - 113,475

OPENINGFUNDBALANCE 358,000 - 358,000

REVENUES

435003 TUF 27,000 - 27,000445000 SDCs 38,280 - 38,280

LICENSES,PERMITS,FEES 65,280 - 65,280

435001 GasTax-State 155,602 - 155,602435002 GasTax-County 9,932 - 9,932

INTERGOVERNMENTAL 165,534 - 165,534

431110 Grants - - -461000 Interest 1,485 - 1,485

OTHERREVENUES 1,485 - 1,485

820110 TransfersIn-GenFund 10,000 - 10,000TRANSFERS 10,000 - 10,000

TOTALREVENUES 242,299 - 242,299

EXPENDITURES

110000 Salaries - 72,506 72,506 [4]120000 Hourly - - - [4]210000 EmployeeBenefits - 12,235 12,235 [4]220000 PayrollTaxes - 10,250 10,250 [4]230000 Retirement - 14,645 14,645 [4]810001 GeneralGovernmentAllocation 30,000 (30,000) - [4]810002 PublicWorksAllocation 59,206 (59,206) - [4]

PersonnelServices 89,206 20,430 109,636 [11]FTE

330000 ProfessionalServices 2,000 - 2,000610000 Supplies 3,000 - 3,000640000 StreetLights 35,750 - 35,750810003 GeneralGovernmentAllocation 20,155 951 21,106 [4]810004 PublicWorksAllocation 4,356 - 4,356

MaterialsandServices 65,261 951 66,211

770103 StreetProjects 87,100 - 87,100StreetLightReplacement - - -CapitalOutlay 87,100 - 87,100

STREETDEPTTOTAL 241,567 21,381 262,948

810009 TransfersOut-VehRes 640 - 640Transfers 640 - 640

TOTALEXPENDITURES 242,207 21,381 263,588

NETBEFORECONTINGENCY 92 (21,381) (21,289)

Contingency

CHANGEINFUNDBALANCE 92 (21,381) (21,289)

UNAPPROPRIATED:RESERVEFORFUTUREEXPENDITURE 358,092 (21,381) 336,711

StreetFeeinLieu 20,000 - 20,000RecologyFund 50,000 - 50,000SDCsforTransSystemPlan 232,805 - 232,805Operations 55,287 (21,381) 33,906


WATERFUND210-433FY2017-18

Acct Description Adopted Change Supplemental

CommittedtoCapitalProjects 886,852 - 886,852Operations 1,913,148 - 1,913,148

OPENINGFUNDBALANCE 2,800,000 - 2,800,000

REVENUES

444000 Charges,Fees,Fines 1,200,000 - 1,200,000445000 SDCs(Capital) 296,160 197,440 493,600446000 SDCs-PassthruJWC - - -461000 Interest 11,070 - 11,070

TOTALREVENUES 1,507,230 197,440 1,704,670

EXPENDITURES

110000 Salaries - 288,607 288,607 [4]210000 EmployeeBenefits - 41,162 41,162 [4]220000 PayrollTaxes - 35,944 35,944 [4]230000 Retirement - 56,449 56,449 [4]810001 GeneralGovernmentAllocation 293,311 (293,311) - [4]810002 PublicWorksAllocation 136,455 (136,455) - [4]

PersonnelServices 429,766 (7,604) 422,162FTE

300000 EducationandTraining 1,200 - 1,200310000 Utilities 9,360 - 9,360330000 ProfessionalServices 38,000 - 38,000330104 ProfSrv-Printing 7,200 - 7,200330111 ProfSrv-MeterReading 10,800 - 10,800330112 ProfSrv-WaterAnalysis 2,250 - 2,250330113 ProfSrv-TankCleaning - 2,700 2,700330114 ProfSrv-LeakDetection - - -330116 ProfSrv-ValveReplacement - - -340000 RepairsandMaintenance 10,000 - 10,000350000 AgencyMemberships 775 - 775610000 Supplies 7,500 - 7,500610600 WaterPurchase 171,829 - 171,829630000 NewWaterServiceMaterials 20,000 - 20,000

FranchiseFee-Water - - -800000 Baddebt(senttocollections) 2,000 - 2,000810003 GeneralGovernmentAllocation 80,550 14,425 94,975 [4]810004 PublicWorksAllocation 14,700 10,300 25,000 [4]

MaterialsandServices 376,164 27,425 403,589 [12]

770001 CapitalProjects 750,000 - 750,000CapitalOutlay 750,000 - 750,000

WATERDEPTTOTAL 1,555,930 19,821 1,575,751

500500 DebtService-SDWLoan 134,332 - 134,332DebtService 134,332 - 134,332

810009 TransfersOut-VehRes 2,725 - 2,725Transfers 2,725 - 2,725

TOTALEXPENDITURES 1,692,987 19,821 1,712,808

NETBEFORECONTINGENCY (185,757) 177,619 (8,138)

Contingency 151,000 - 151,000

CHANGEINFUNDBALANCE (336,757) 177,619 (159,138)

UNAPPROPRIATED:RESERVEFORFUTUREEXPENDITURE 2,463,243 177,619 2,640,862

CommittedtoCapitalProjects 433,012 197,440 630,452Operations 2,030,231 (19,821) 2,010,410


GENERALFUNDSUMMARYACTUAL ACTUAL Unaudited

Acct Description 2014-15 2015-16 Actuals Proposed Approved Adopted NewRequest Supplemental1

ReservedforGarlicFestival 935 2,361 3,738 3,738 3,738 3,738 -Unreserved 855,336 904,443 1,096,262 1,096,262 1,096,262 1,096,262 -

OPENINGFUNDBALANCE 842,549 856,271 906,804 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000

REVENUESPropertyTaxes 385,891 376,512 415,924 499,643 499,643 499,643 499,643 -Licenses,Permits,Fees 409,056 506,163 573,823 492,634 492,634 492,634 509,851 17,217Intergovernmental 151,974 172,534 268,941 325,073 325,073 325,073 228,281 (96,792)FinesandForfeitures 23,876 22,507 19,735 20,500 20,500 20,500 20,500 -GrantsandDonations 40,167 39,798 25,290 43,089 43,089 43,089 103,926 60,837OtherRevenue 35,132 31,501 43,416 33,705 33,705 33,705 191,656 157,951

TOTALREVENUES 1,046,096 1,149,015 1,347,129 1,414,644 1,414,644 1,414,644 1,553,857

EXPENDITURESGeneralGovernment 243,482 197,141 212,742 215,401 215,401 215,401 373,884 158,483Police 344,534 351,311 304,195 437,651 437,651 437,651 569,047 131,396PublicWorks 128,800 13,775 14,479 25,675 25,675 25,675 31,885 6,210Library 204,655 228,499 314,514 341,500 341,500 341,500 355,702 14,202CultureandRecreation 30,946 20,907 4,032 4,900 4,900 4,900 6,600 1,700Parks 11,270 62,325 77,420 75,964 75,964 75,964 75,964 0Planning 46,358 205,156 233,979 193,580 193,580 193,580 205,043 11,463Transfers 22,328 19,368 19,847 19,847 19,847 19,847 15,118 (4,729)

TOTALEXPENDITURES 1,032,373 1,098,482 1,181,208 1,314,518 1,314,518 1,314,518 1,633,243 318,725

NETBEFORECONTINGENCY 13,723 50,533 165,921 100,126 100,126 100,126 (79,386) (318,725)

Contingency - - - 100,000 100,000 100,000 100,000 -

CHANGEINFUNDBALANCE 13,723 50,533 165,921 126 126 126 (179,386) (318,725)

UNAPPROPRIATED:RESERVEFORFUTUREEXPENDITURE - 572,725 353,430 353,430 353,430 173,918 173,918ENDINGFUNDBALANCE 856,272 906,804 500,000 746,696 746,696 746,696 746,696 746,696

1,072,725 1,100,126 1,100,126 1,100,126 920,614 920,614ReservedforGarlicFestival 935 2,361 3,809 4,964 4,964 4,964 5,164 5,164Unreserved 855,336 904,443 1,068,916 1,095,162 1,095,162 1,095,162 915,450 915,450

HISTORICALDATA 2016-17 BUDGET2017-18

GENERALFUNDREV110ACTUAL ACTUAL Unaudited


411000 373,092 412,644 496,640 496,640 496,640 496,640 -411001 3,418 3,277 3,000 3,000 3,000 3,000 -411002 2 3 3 3 3 3 -411000 PropertyTaxes 385,891 376,512 415,924 499,643 499,643 499,643 499,643 -

WaterFranchise 46,173 - - - - - - -418102 CWSFranchise 27,297 28,598 33,728 30,382 30,382 30,382 37,101 6,719418103 CenturyLinkFranchise 4,573 4,161 3,831 4,000 4,000 4,000 4,000 -418104 ComcastFranchise 6,212 6,425 6,856 6,658 6,658 6,658 6,858 200418105 GarbageFranchise 11,417 11,986 13,674 12,705 12,705 12,705 15,041 2,336418107 PGEFranchise 99,300 103,142 87,443 108,556 108,556 108,556 104,500 (4,056)418108 NWNaturalGasFranchise 40,313 47,203 43,913 53,529 53,529 53,529 48,304 (5,225)418109 MiscFranchise 4,070 1,579 12,236 2,163 2,163 2,163 2,163 -418110 MACCFranchise 15,615 17,174 24,814 16,907 16,907 16,907 21,000 4,093421000 BusinessFees 6,808 6,131 7,857 6,000 6,000 6,000 7,857 1,857422000 RecologyFund 47,014 46,211 48,530 47,597 47,597 47,597 48,530 933440000 MiscellaneousFees 6,524 18,117 6,862 9,500 9,500 9,500 7,000 (2,500)441419 LandUsePermits 35,138 88,037 71,304 52,140 52,140 52,140 65,000 12,860441420 EngineeringPlanReview 21,726 56,371 180,915 71,750 71,750 71,750 71,750 -450455 LibraryFinesandFees 9,622 9,281 8,981 9,500 9,500 9,500 9,500 -450465 LandUsePlanningFees 20,370 53,676 16,784 54,247 54,247 54,247 54,247 -462000 Rentals 6,884 8,071 6,095 7,000 7,000 7,000 7,000 -

LICENSES,PERMITS,FEES 409,056 506,163 573,823 492,634 492,634 492,634 509,851 17,217

436000 LiquorTax 29,024 31,262 28,001 56,070 56,070 56,070 30,900 (25,170)437000 CigaretteTax 2,701 2,677 2,514 3,003 3,003 3,003 3,003 -438000 StateRevenueSharing 18,359 18,911 18,808 30,000 30,000 30,000 20,600 (9,400)439000 WCCLS-PoolOne 101,890 104,437 168,717 184,000 184,000 184,000 173,778 (10,222)439001 WCCLS-PoolTwo - 15,247 50,901 52,000 52,000 52,000 - (52,000)

INTERGOVERNMENTAL 151,974 172,534 268,941 325,073 325,073 325,073 228,281 (96,792)

450421 PoliceCitations 23,876 22,507 19,735 20,500 20,500 20,500 20,500 -FINESANDFORFEITURES 23,876 22,507 19,735 20,500 20,500 20,500 20,500 -

431000 Grants-General 8,000 13,838 12,663 12,663 12,663 12,663 6,500 (6,163)431001 Grants-Police 9,181 1,273 - 8,000 8,000 8,000 75,000 67,000431002 Grants-Library 1,000 3,500 1,000 1,000 1,000 1,000 1,000 -


GENERALFUNDREV110ACTUAL ACTUAL Unaudited



431003 Grants-Planning(DLCD) - 1,000 - 12,000 12,000 12,000 12,000 -464000 Donations-General - 72 - - - - -464100 CommEventsRev 3,516 - - - - - -464101 4thofJulyRev 5,684 6,063 - - - - - -464102 ConcertsintheParkRev 1,350 1,500 - - - - - -464116 GarlicFestRev 935 1,426 1,448 1,426 1,426 1,426 1,426 -464421 Donations-Police - - - - - - - -464455 Donations-Library 10,501 11,198 10,107 8,000 8,000 8,000 8,000 -

GRANTSANDDONATIONS 40,167 39,798 25,290 43,089 43,089 43,089 103,926 60,837

461000 Interest 11,148 10,335 18,909 13,498 13,498 13,498 17,904 4,406445000 Saleofasset 6,200 4,695 7,500 3,200 3,200 3,200 3,200 -

Interfundreimbursements - - - - - - 152,993 152,993Transferin 1,831 - - - - - - -

820113 RepaymentofURALoan 15,953 16,471 17,007 17,007 17,007 17,007 17,559 552OTHERREVENUE 35,132 31,501 43,416 33,705 33,705 33,705 191,656 157,951

TOTALREVENUES 1,046,096 1,149,015 1,347,129 1,414,644 1,414,644 1,414,644 1,553,857 139,213

GENERALGOVERNMENT110-419ACTUAL ACTUAL Unaudited


110000 Salaries 231,428 133,070 117,824 143,372 143,372 143,372 81,628 (61,744)120000 Hourly - 65,416 70,943 71,525 71,525 71,525 - (71,525)210000 EmployeeBenefits 32,650 29,904 21,529 31,748 31,748 31,748 10,802 (20,946)220000 PayrollTaxes 17,160 14,775 14,945 18,970 18,970 18,970 7,450 (11,520)230000 Retirement 33,345 31,997 29,253 35,129 35,129 35,129 14,017 (21,112)

Subtotal 314,583 275,162 254,494 300,744 300,744 300,744 113,897 (186,847)810001 Allocatedtootherfunds (195,041) (163,037) (140,381) (165,892) (165,892) (165,892) - 165,892

PERSONNELSERVICES 119,542 112,125 114,113 134,852 134,852 134,852 113,897 (20,955)FTE 5.6

300000 EducationandTraining 2,476 3,345 2,919 4,000 4,000 4,000 4,000 -300010 BUGConnection 7,830 7,262 4,474 6,600 6,600 6,600 6,600 -300105 Donations - - - 1,500 1,500 1,500 5,500 4,000310000 Utilities 15,385 15,412 13,621 14,700 14,700 14,700 14,700 -330000 ProfessionalServices 2,909 2,647 19,465 2,000 2,000 2,000 27,000 25,000330100 ProfSrv-Attorney 44,050 36,631 40,740 30,000 30,000 30,000 40,000 10,000330101 ProfSrv-Audit 7,222 7,222 7,222 7,500 7,500 7,500 7,500 -330102 ProfSrv-Software 11,883 18,399 14,051 15,068 15,068 15,068 15,068 -330103 ProfSrv-IT 14,264 13,611 15,851 15,000 15,000 15,000 15,000 -330104 ProfSrv-Printing 6,419 5,889 6,656 6,600 6,600 6,600 6,600 -330105 ProfSrv-Payroll 5,492 5,747 7,975 5,590 5,590 5,590 8,000 2,410330106 ProfSrv-Janitorial 2,340 1,475 1,675 1,475 1,475 1,475 17,000 15,525330107 ProfSrv-Security 2,888 2,725 3,456 2,755 2,755 2,755 3,500 745330115 ProfSrv-HR 1,493 840 1,661 1,000 1,000 1,000 8,000 7,000340000 RepairsandMaintenance 1,869 2,996 4,523 3,000 3,000 3,000 3,000 -340100 R&M-Copier 11,426 10,887 10,344 12,218 12,218 12,218 12,218 -340101 R&M-HVAC 3,708 1,910 3,514 1,950 1,950 1,950 1,950 -350000 AgencyMemberships 4,119 3,761 4,635 4,000 4,000 4,000 4,000 -500000 EmployeeRecognition 1,590 1,412 1,258 2,100 2,100 2,100 2,100 -540000 Advertising 658 835 1,055 500 500 500 500 -610000 Supplies 8,221 6,526 14,372 7,500 7,500 7,500 7,500 -621000 Insurance 34,394 34,376 35,240 35,000 35,000 35,000 38,000 3,000621002 Workers'Compensation 15,983 18,225 - - - - - -

Subtotal 206,619 202,133 214,707 180,056 180,056 180,056 247,736 67,680810003 Allocatedtootherfunds (82,679) (117,118) (116,078) (99,507) (99,507) (99,507) - 99,507


GENERALGOVERNMENT110-419ACTUAL ACTUAL Unaudited



MATERIALSANDSERVICES 123,940 85,015 98,629 80,549 80,549 80,549 247,736 167,187

810009 TransfersOut-EquipRes 3,000 2,047 2,251 2,251 2,251 2,251 2,251 -810111 TransfersOut-Street 10,000 10,000 10,000 10,000 10,000 10,000 10,000 -

TRANSFERSOUT 13,000 12,047 12,251 12,251 12,251 12,251 12,251 -

GENERALGOVERNMENTDEPTTOTAL 256,482 209,187 224,993 227,652 227,652 227,652 (1) 373,884 146,232

POLICE110-421ACTUAL ACTUAL Unaudited


110000 Salaries 129,820 159,439 119,505 124,091 124,091 124,091 143,657 19,566120000 Hourly 30,255 37,328 27,959 97,024 97,024 97,024 97,024 -125000 Reserves 20,571 4,942 12,212 9,168 9,168 9,168 9,168 -210000 EmployeeBenefits 20,236 21,820 20,094 38,641 38,641 38,641 21,719 (16,922)220000 PayrollTaxes 13,921 15,360 20,073 30,894 30,894 30,894 48,435 17,541230000 Retirement 29,447 35,704 16,391 43,832 43,832 43,832 55,866 12,034

PERSONNELSERVICES 244,250 274,593 216,234 343,650 343,650 343,650 375,869 32,219FTE 4.6 4.6

300000 EducationandTraining 2,314 888 1,367 3,000 3,000 3,000 5,000 2,000300105 Donations 5,000 5,000330000 ProfessionalServices 3,706 3,328 6,670 7,000 7,000 7,000 7,000 -330102 ProfSrv-Software 9,939 5,066 6,809 10,000 10,000 10,000 12,000 2,000330108 ProfSrv-Wireless 6,214 5,035 6,005 5,640 5,640 5,640 6,000 360330109 ProfSrv-EvidStorage 2,547 2,629 2,603 2,600 2,600 2,600 3,000 400330912 WACountyDispatch 12,420 12,796 13,278 13,178 13,178 13,178 13,178 -340000 RepairsandMain-Vehicles 11,171 8,123 8,258 10,000 10,000 10,000 10,000 -340102 RepairsandMain-Equip - 569 1,766 1,000 1,000 1,000 2,500 1,500350000 AgencyMemberships 956 881 318 1,000 1,000 1,000 1,000 -370000 RentalsandLeases 21,040 21,041 9,583 9,583 9,583 9,583 - (9,583)610000 Supplies 14,429 3,361 12,490 13,000 13,000 13,000 13,000 -610100 Uniforms 3,042 3,632 6,253 6,000 6,000 6,000 6,500 500610224 Fuel 12,295 9,369 12,561 12,000 12,000 12,000 12,000 -630000 Equipment(non-capital) 1,275 4,671 - - - - 9,000 9,000


770000 Equipment(vehicles) - - - - - - 88,000 88,000CAPITALOUTLAY - - - - - - 88,000 88,000

810009 TransfersOut-EquipRes 6,400 - 4,729 4,729 4,729 4,729 - (4,729)TRANSFERSOUT 6,400 - 4,729 4,729 4,729 4,729 - (4,729)

POLICEDEPARTMENTTOTAL 351,998 355,982 308,924 442,380 442,380 442,380 (1) 569,047 126,667


PUBLICWORKS110-433ACTUAL ACTUAL Unaudited


110000 Salaries 214,755 157,321 151,554 162,631 162,631 162,631 - (162,631)120000 Hourly - 14,536 5,637 9,526 9,526 9,526 - (9,526)210000 EmployeeBenefits 26,439 23,982 30,138 24,799 24,799 24,799 - (24,799)220000 PayrollTaxes 16,135 12,995 21,281 24,310 24,310 24,310 - (24,310)230000 Retirement 41,003 34,358 31,499 35,384 35,384 35,384 - (35,384)

Subtotal 298,332 243,192 240,109 256,650 256,650 256,650 - (256,650)810001 Allocatedtootherfunds (193,916) (230,462) (222,012) (237,306) (237,306) (237,306) - 237,306

PERSONNELSERVICES 104,416 12,730 18,097 19,344 19,344 19,344 - (19,344)FTE 0.0 1.1

300000 EducationandTraining 929 162 597 1,000 1,000 1,000 1,000 -310000 Utilities 1,288 1,287 1,609 1,440 1,440 1,440 1,440 -330000 ProfessionalServices - - 2,240 500 500 500 500 -330110 CityEngineerPlanReview 5,211 - - - - - - -340000 RepairsandMaintenance 8,131 9,191 17,214 12,245 12,245 12,245 12,245 -350000 AgencyMemberships - - 200 100 100 100 100 -610000 Supplies 5,569 1,956 4,480 7,500 7,500 7,500 7,500 -610090 Uniforms 214 100 765 600 600 600 600 -610224 Fuel 8,691 6,311 5,895 8,500 8,500 8,500 8,500 -

Subtotal 30,033 19,007 33,000 31,885 31,885 31,885 31,885 -810004 Allocatedtootherfunds (5,649) (17,962) (36,618) (25,554) (25,554) (25,554) - 25,554

MATERIALSANDSERVICES 24,384 1,045 (3,618) 6,331 6,331 6,331 31,885 25,554

810009 TransfersOut-EquipRes 328 58 263 263 263 263 263 -TRANSFERSOUT 328 58 263 263 263 263 263 -

PUBLICWORKSDEPARTMENTTOTAL 129,128 13,833 14,742 25,938 25,938 25,938 (1) 32,148 6,210


LIBRARY110-455ACTUAL ACTUAL Unaudited


110000 Salaries - 99,356 103,000 103,000 103,000 94,823 (8,177)120000 Hourly 132,962 135,315 87,009 94,662 94,662 94,662 94,682 20210000 EmployeeBenefits - 6,932 12,727 20,623 20,623 20,623 19,529 (1,094)220000 PayrollTaxes 10,893 11,038 15,651 17,378 17,378 17,378 17,583 205230000 Retirement 14,252 13,688 24,464 31,482 31,482 31,482 33,330 1,848

PERSONNELSERVICES 158,107 166,973 239,207 267,145 267,145 267,145 259,947 (7,198)FTE 4.6 4.6

300000 EducationandTraining 503 320 1,004 1,400 1,400 1,400 1,400 -300100 Donations 100 102 - 100 100 100 100 -310000 Utilities 8,512 8,407 8,365 9,090 9,090 9,090 9,090 -310001 Utilities-FNNPL/YellowHouse - - 2,576 3,930 3,930 3,930 3,930 -330000 ProfessionalServices 1,693 3,908 2,155 3,560 3,560 3,560 3,560 -330102 ProfSrv-Software 2,913 1,760 2,162 3,500 3,500 3,500 3,500 -330106 ProfSrv-Janitorial 2,100 5,795 5,760 6,300 6,300 6,300 6,300 -330107 ProfSrv-Security 1,043 671 881 1,000 1,000 1,000 1,000 -340000 RepairsandMaintenance 1,740 2,045 1,306 2,200 2,200 2,200 2,200 -340100 R&M-Copier 3,143 3,189 3,574 4,000 4,000 4,000 4,000 -340101 R&M-HVAC - 3,406 8,602 6,000 6,000 6,000 6,000 -610000 Supplies 8,506 15,046 11,113 12,875 12,875 12,875 12,875 -621000 Insurance - - 1,603 1,800 1,800 1,800 1,800 -640000 LibraryMaterials 16,295 16,878 13,649 15,500 15,500 15,500 30,000 14,500650000 Programming - - - - - - 10,000 10,000750000 PoolTwoExpense - - 9,239 - - - - -


700000 Equipment - - 3,318 3,100 3,100 3,100 - (3,100)CAPITALOUTLAY - - 3,318 3,100 3,100 3,100 - (3,100)

810009 TransfersOut-EquipRes 2,600 2,593 2,604 2,604 2,604 2,604 2,604 -TRANSFERSOUT 2,600 2,593 2,604 2,604 2,604 2,604 2,604 -

LIBRARYDEPARTMENTTOTAL 207,255 231,093 317,118 344,104 344,104 344,104 (1) 358,306 14,202


CULTUREANDRECREATION110-411ACTUAL ACTUAL Unaudited


PERSONNELSERVICES 3,094 - - - - - - --

Dances 344 - - - - - -PumpkinRun 1,998 - - - - - -

300101 FourthofJuly 20,822 16,930 143 - - - - -300102 ConcertsinthePark 1,832 1,735 - - - - 1,500 1,500300107 ChiliCookoff 634 682 563 700 700 700 700 -300108 NationalNightOut 699 340 458 500 500 500 500 -300110 VolunteerRecognition 527 519 279 600 600 600 600 -300111 IceCreamSocial 333 196 371 350 350 350 550 200300116 GarlicFestival 133 - 71 200 200 200 200 -300117 CleanUpDay 228 127 327 250 250 250 250 -300118 City-wideGarageSale 302 378 - 350 350 350 350 -300119 Jingle - - 70 200 200 200 200 -300120 NorthPlainsEventAssociation - - 1,750 1,750 1,750 1,750 1,750 -


CULTUREANDRECREATIONDEPTTOTAL 30,946 20,907 4,032 4,900 4,900 4,900 (1) 6,600 1,700


PARKS110-452ACTUAL ACTUAL Unaudited


810002 PublicWorksAllocation - - 52,824 56,463 56,463 56,463 7,500 (48,963)PERSONNELSERVICES - - 52,824 56,463 56,463 56,463 7,500 (48,963)

FTE 714200.3

310000 Utilities 5,046 5,460 5,970 5,970 5,970 5,970 -330000 ProfessionalServices - - 600 600 600 49,563 48,963340000 RepairsandMaintenance 4,635 9,964 4,000 4,000 4,000 4,000 -610000 Supplies 1,589 458 2,850 2,850 2,850 2,850 -810004 PublicWorksAllocation - 8,714 6,081 6,081 6,081 6,081 -

MATERIALSANDSERVICES 11,270 - 24,596 19,501 19,501 19,501 68,464 48,963

PARKSDEPARTMENTTOTAL 11,270 - 77,420 75,964 75,964 75,964 (1) 75,964 0


PLANNING110-465ACTUAL ACTUAL Unaudited


110000 Salaries - - - - - - 11,592 11,592120000 Hourly - - - - - - - -210000 EmployeeBenefits - - - - - - 1,524 1,524220000 PayrollTaxes - - - - - - 1,217 1,217230000 Retirement - - - - - - 2,159 2,159810001 GeneralGovernmentAllocation - - 908 1,073 1,073 1,073 - (1,073)810002 PublicWorksAllocation - - 3,703 3,957 3,957 3,957 - (3,957)

PERSONNELSERVICES - - 4,611 5,030 5,030 5,030 16,493 11,463FTE 0.0

330000 ProfessionalServices 25,034 69,173 79,036 45,000 45,000 45,000 45,000 -330100 ProfSvc-Attorney - 12,118 20,532 10,000 10,000 10,000 10,000 -330110 ProfSvc-Engineering - 19,787 35,201 45,000 45,000 45,000 45,000 -330117 ProfSvc-CompPlan 20,424 73,198 91,540 86,075 86,075 86,075 86,075 -360000 Advertising 901 790 1,227 1,000 1,000 1,000 1,000 -810003 GeneralGovernmentAllocation - 28,739 1,234 1,058 1,058 1,058 1,058 -810004 PublicWorksAllocation - 1,351 598 417 417 417 417 -

MATERIALSANDSERVICES 46,359 205,156 229,368 188,550 188,550 188,550 188,550 -

PLANNINGDEPARTMENTTOTAL 46,359 205,156 233,979 193,580 193,580 193,580 (1) 205,043 11,463


STREETFUND111-433ACTUAL ACTUAL Unaudited


StreetFeeinLieu 141,154 141,154 20,000 20,000 20,000 20,000 20,000 -RecologyFund 10,000 20,000 30,000 30,000 30,000 30,000 30,000 -SDCsforTransSystemPlan 84,347 114,153 194,525 194,525 194,525 194,525 194,525 -Operations (54,445) (49,024) 77,105 113,475 113,475 113,475 113,475 -

OPENINGFUNDBALANCE 181,056 226,283 321,630 358,000 358,000 358,000 358,000 -

REVENUES

435003 TUF 25,681 26,693 25,729 27,000 27,000 27,000 27,000 -445000 SDCs 29,806 80,372 71,528 38,280 38,280 38,280 38,280 -

LICENSES,PERMITS,FEES 55,487 107,065 97,257 65,280 65,280 65,280 65,280 -

435001 GasTax-State 114,597 119,464 120,741 155,602 155,602 155,602 155,602 -435002 GasTax-County 7,461 7,617 7,530 9,932 9,932 9,932 9,932 -

INTERGOVERNMENTAL 122,058 127,081 128,271 165,534 165,534 165,534 165,534 -

431110 Grants 49,644 - - - - - - -461000 Interest 979 1,993 4,090 1,485 1,485 1,485 1,485 -

OTHERREVENUES 50,623 1,993 4,090 1,485 1,485 1,485 1,485 -

820110 TransfersIn-GenFund 10,000 10,000 10,000 10,000 10,000 10,000 10,000 -TRANSFERS 10,000 10,000 10,000 10,000 10,000 10,000 10,000 -

TOTALREVENUES 238,168 246,139 239,618 242,299 242,299 242,299 242,299 -

EXPENDITURES

110000 Salaries - - - - - - 72,506 72,506210000 EmployeeBenefits - - - - - - 12,235 12,235220000 PayrollTaxes - - - - - - 10,250 10,250230000 Retirement - - - - - - 14,645 14,645810001 GeneralGovernmentAllocation 47,187 27,347 25,359 30,000 30,000 30,000 - (30,000)810002 PublicWorksAllocation 44,750 48,795 37,825 59,206 59,206 59,206 - (59,206)

PersonnelServices 91,937 76,142 63,184 89,206 89,206 89,206 109,636 20,430


STREETFUND111-433ACTUAL ACTUAL Unaudited


330000 ProfessionalServices 1,376 649 3,280 2,000 2,000 2,000 2,000 -610000 Supplies 3,965 2,340 2,949 3,000 3,000 3,000 3,000 -640000 StreetLights 23,884 30,470 32,239 35,750 35,750 35,750 35,750 -810003 GeneralGovernmentAllocation 20,003 19,793 20,881 20,155 20,155 20,155 21,106 951810004 PublicWorksAllocation 1,304 4,011 6,242 4,356 4,356 4,356 4,356 -

MaterialsandServices 50,532 57,263 65,591 65,261 65,261 65,261 66,211 951

770103 StreetProjects 49,644 16,840 21,000 87,100 87,100 87,100 87,100 -StreetLightReplacement 47,100 -CapitalOutlay 49,644 16,840 68,100 87,100 87,100 87,100 87,100 -

STREETDEPTTOTAL 192,113 150,245 196,875 241,567 241,567 241,567 (1) 262,948 21,381

810009 TransfersOut-VehRes 828 547 640 640 640 640 640 -Transfers 828 547 640 640 640 640 (1) 640 -

TOTALEXPENDITURES 192,941 150,792 197,515 242,207 242,207 242,207 263,588 21,381

NETBEFORECONTINGENCY 45,227 95,347 42,103 92 92 92 (21,289) (21,381)

Contingency - - - - - - (1) - -

CHANGEINFUNDBALANCE 45,227 95,347 42,103 92 92 92 (21,289) (21,381)

UNAPPROPRIATED:RESERVEFORFUTUREEXPENDITURE 226,283 321,630 363,733 358,092 358,092 358,092 336,711 (21,381)

StreetFeeinLieu 141,154 157,994 20,000 20,000 20,000 20,000 20,000 -RecologyFund 20,000 30,000 40,000 50,000 50,000 50,000 50,000 -SDCsforTransSystemPlan 114,153 194,525 185,681 232,805 232,805 232,805 232,805 -Operations (49,024) (60,889) 118,052 55,287 55,287 55,287 33,906 (21,381)


WATERFUND210-433ACTUAL ACTUAL Unaudited


CommittedtoCapitalProjects 194,419 421,824 1,058,568 886,852 886,852 886,852 886,852 -Operations 848,318 1,046,306 1,410,040 1,913,148 1,913,148 1,913,148 1,913,148 -

OPENINGFUNDBALANCE 1,042,737 1,468,130 2,468,608 2,800,000 2,800,000 2,800,000 2,800,000 -

REVENUES

444000 Charges,Fees,Fines 923,461 1,070,955 1,087,069 1,200,000 1,200,000 1,200,000 1,200,000 -445000 SDCs(Capital) 261,737 636,744 545,426 296,160 296,160 296,160 493,600 197,440446000 SDCs-PassthruJWC 153,306 - - - - - - -461000 Interest 5,697 13,856 22,394 11,070 11,070 11,070 11,070 -

TOTALREVENUES 1,344,201 1,721,555 1,654,889 1,507,230 1,507,230 1,507,230 1,704,670 197,440

EXPENDITURES

110000 Salaries - - - - - - 288,607 288,607120000 Hourly - - - - - - - -210000 EmployeeBenefits - - - - - - 41,162 41,162220000 PayrollTaxes - - - - - - 35,944 35,944230000 Retirement - - - - - - 56,449 56,449810001 GeneralGovernmentAllocation 147,854 134,001 114,114 293,311 293,311 293,311 - (293,311)810002 PublicWorksAllocation 149,166 103,955 127,660 136,455 136,455 136,455 - (136,455)

PersonnelServices 297,020 237,956 241,774 429,766 429,766 429,766 422,162 (7,604)FTE 3.6

300000 EducationandTraining - 890 765 1,200 1,200 1,200 1,200 -310000 Utilities 8,963 6,943 6,889 9,360 9,360 9,360 9,360 -330000 ProfessionalServices 1,865 29,502 37,847 38,000 38,000 38,000 38,000 -330104 ProfSrv-Printing 5,367 7,111 6,624 7,200 7,200 7,200 7,200 -330111 ProfSrv-MeterReading 8,727 9,626 10,984 10,800 10,800 10,800 10,800 -330112 ProfSrv-WaterAnalysis 1,068 1,961 1,571 2,250 2,250 2,250 2,250 -330113 ProfSrv-TankCleaning 2,700 - 58 - - - 2,700 2,700330114 ProfSrv-LeakDetection 3,450 - - - - - - -330116 ProfSrv-ValveReplacement - 4,636 - - - - - -340000 RepairsandMaintenance 3,087 9,793 7,775 10,000 10,000 10,000 10,000 -350000 AgencyMemberships - 805 345 775 775 775 775 -

HISTORICALDATA FY2016-17 BUDGET2017-18

WATERFUND210-433ACTUAL ACTUAL Unaudited


HISTORICALDATA FY2016-17 BUDGET2017-18

610000 Supplies 4,394 12 5,389 7,500 7,500 7,500 7,500 -610600 WaterPurchase 136,195 142,357 166,136 171,829 171,829 171,829 171,829 -630000 NewWaterServiceMaterials 5,645 27,073 10,417 20,000 20,000 20,000 20,000 -

FranchiseFee-Water 46,173 - - - - - - -800000 Baddebt(senttocollections) 3,005 - - 2,000 2,000 2,000 2,000 -810003 GeneralGovernmentAllocation 62,677 96,986 93,963 80,550 80,550 80,550 94,975 14,425810004 PublicWorksAllocation 4,346 8,545 21,064 14,700 14,700 14,700 25,000 10,300

MaterialsandServices 297,662 346,240 369,827 376,164 376,164 376,164 403,589 27,425

770001 CapitalProjects 34,332 - 717,142 750,000 750,000 750,000 750,000 -CapitalOutlay 34,332 - 717,491 750,000 750,000 750,000 750,000 -

WATERDEPTTOTAL 629,014 584,196 1,329,092 1,555,930 1,555,930 1,555,930 (1) 1,575,751 19,821

820000 SDCPassThruJWC 153,306 - - - - - - -SpecialPayments 153,306 - - - - - (1) - -

500500 DebtService-SDWLoan 134,332 134,332 134,332 134,332 134,332 134,332 134,332 -DebtService 134,332 134,332 134,332 134,332 134,332 134,332 (1) 134,332 -

810009 TransfersOut-VehRes 2,156 2,549 2,725 2,725 2,725 2,725 2,725 -Transfers 2,156 2,549 2,725 2,725 2,725 2,725 (1) 2,725 -

TOTALEXPENDITURES 918,808 721,077 1,466,149 1,692,987 1,692,987 1,692,987 1,712,808 19,821

NETBEFORECONTINGENCY 425,393 1,000,478 188,740 (185,757) (185,757) (185,757) (8,138) 177,619

Contingency - - - 151,000 151,000 151,000 151,000 -

CHANGEINFUNDBALANCE 425,393 1,000,478 188,740 (336,757) (336,757) (336,757) (159,138) 177,619

UNAPPROPRIATED:RESERVEFORFUTUREEXPENDITURE 1,468,130 2,468,608 2,657,348 2,463,243 2,463,243 2,463,243 2,640,862 177,619

CommittedtoCapitalProjects 421,824 1,058,568 886,852 433,012 433,012 433,012 630,452 197,440Operations 1,046,306 1,410,040 1,770,496 2,030,231 2,030,231 2,030,231 2,010,410 (19,821)

supplemental budget summary - north plains

Documents