Loading...
Resolution - 16-21 - Adopt 2017 General Fund BudgetCITY OF SPRING PARK SPRING PARK, MINNESOTA RESOLUTION 16 - 21 A RESOLUTION ADOPTING THE 2017 GENERAL FUND BUDGET BE IT RESOLVED, by the Spring Park City Council, County of Hennepin, Minnesota, that the final 2017 General Fund Budget be accepted as follows: (Per attached final 2017 Budget) Total General Fund Budget is $1,270,858. Adopted by the City Council of the City of Spring Park, Minnesota on December 19, 2016. Approved: ce W-illiafnson, Mayor Attest: 4a��t�- Th esa Schyma, City lerk APPROVED 2017 SUMMARY BUDGET GENERAL FUND Revenue Property Tax Levy $1,027,143 Payments in Lieu of Taxes a37,000 Licenses & Permits $25,076 Zoning & Building Fees $24,500 Grants & Aid $3,700 Recycling Fees $10,000 Fines $15,000 Special Assessments $8,000 Miscellaneous $13,500 Transfer from Reserves $106,939 Total $1,270,858 Expenditures Police $448,000 Fire $140,000 Public Works $197,400 Administration $179,625 Contracted Services (Planner, Attorney, Assessor & Building Official) $95,600 Parks & Recreation $44,350 Waste Services $37,000 Debt Service $128,883 Total $1,270,858 WATER & SEWER FUNDS Revenue Charges for Service $732,000 Miscellaneous $125000 Transfer from Reserves $242,238 Total $986,238 Expenditures Contracted Services (PeopleService) $671-200 Operations & Maintenance $382,700 Depreciation $190,000 Met Council Sewer Charges $205500 Debt Service $140,838 Total $9861,238 CITY OF SPRING PARK 2017 Revenue Budget Worksheet - SP w/Utilities December 2016 12/15/16 12:36 PM Page 1 2016 2016 2016 YTD 2016 % 2017 Account Descr 2015 Amt Budget YTD Amt Balance of Budget Budget Underline FUND 101 GENERAL FUND Dept R 101-31010 Current Ad Valorem Taxes $974,586.91 $1,007,992.00 $1,007,779.32 $212.68 99.98% $1,027,143.00 R 101-31020 Delinquent Ad Valorem Taxes $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 101-31040 Fiscal Disparities $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 101-31090 In Lieu of Taxes $35,749.50 $37,000.00 $35,365.50 $1,634.50 95.58% $37,000.00 R 101-32000 Dock Licenses $1,000.00 $1,000.00 $1,000.00 $0.00 100.00% $1,000.00 R 101-32100 Business Licenses/Permits $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 101-32105 Cigarette Permits $50.00 $50.00 $50.00 $0.00 100.00% $50.00 R 101-32110 Alchoholic Beverages $12,046.00 $12,046.00 $14,146.00 -$2,100.00 117.43% $14,226.00 R 101-32120 Sign Permits $500.00 $500.00 $410.10 $89.90 82.02% $500.00 R 101-32150 Dog Licenses $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 101-32160 Garbage Haulers $975.00 $1,000.00 $1,000.00 $0.00 100.00% $1,000.00 R 101-32170 Amusements $1,800.00 $1,700.00 $2,090.00 -$390.00 122.94% $1,700.00 R 101-32180 Other Licenses/Permits/Mech/PI $3,523.99 $4,000.00 $4,612.48 -$612.48 115.31% $4,000.00 R 101-32210 Building Permits $20,336.16 $16,000.00 $16,946.42 -$946.42 105.92% $15,000.00 R 101-32215 Building Permit - Surcharge $88.37 $0.00 $93.32 -$93.32 0.00% $0.00 R 101-33100 Grants and Aids $19,337.37 $0.00 $2,150.00 -$2,150.00 0.00% $0.00 R 101-33130 CDBG $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 101-33401 Local Government Aid $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 101-33402 Homestead Credit $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 101-33404 PERA Aid $701.00 $700.00 $350.50 $349.50 50.07% $700.00 R 101-33409 Housing Aid $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 101-33610 County Grants/Aid for Hwy $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 101-33620 Recycling $3,150.50 $2,500.00 $4,627.50 -$2,127.50 185.10% $3,000.00 R 101-34103 Variance/CUP Requests $550.00 $500.00 $1,550.00 -$1,050.00 310.00% $500.00 R 101-34104 Plan Check Fee $12,485.56 $9,500.00 $12,217.79 -$2,717.79 128.61% $9,000.00 R 101-34105 Dance & Police Fees $2,658.50 $2,600.00 $2,658.50 -$58.50 102.25% $2,600.00 R 101-34112 Fire False Alarm Fee $150.00 $0.00 $0.00 $0.00 0.00% $0.00 R 101-34401 Recycling Apartments $10,080.54 $10,000.00 $10,800.74 -$800.74 108.01% $10,000.00 R 101-35100 Court Fines $17,091.84 $14,000.00 $12,801.59 $1,198.41 91.44% $15,000.00 R 101-35110 Dog Fines $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 101-35120 Liquor Violation Fines $0.00 $0.00 $600.00 -$600.00 0.00% $0.00 R 101-36100 Special Assessments $0.00 $8,000.00 $31,814.87 -$23,814.87 397.69% $8,000.00 R 101-36210 Interest Earnings -$686.42 $3,500.00 $2,969.42 $530.58 84.84% $3,500.00 R 101-36230 Contributions and Donations $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 101-39101 Refunds & Abatements $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 101-39102 LMCIT Dividend $6,837.00 $5,000.00 $8,384.00 -$3,384.00 167.68% $5,000.00 12/15/16 12:36 PM Page 2 2016 2016 2016 YTD 2016 % 2017 Account Descr 2015 Amt Budget YTD Amt Balance of Budoet Budget Underline R 101-39103 Gambling Revenue $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 101-39104 Other Revenue $4,775.00 $0.00 $17,847.52 -$17,847.52 0.00% $5,000.00 R 101-39106 Reimb.of Devlp.-2009 Presby $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 101-39203 Trsfr from General Fund Balanc $0.00 $32,484.00 $0.00 $32,484.00 0.00% $106,939.00 R 101-39310 Proceeds -Gen Obligation Bond _ _ $0.00 $0.00 ___ $0.00 $0.00 0.00% $0.00 Dept $1,127,786.82 $1,170,072.00 $1,192,265.57 _ -$22,193.57 101.90% $1,270,858.00 FUND 101 GENERAL FUND $1,127,786.82 $1,170,072.00 $1,192,265.57 -$22,193.57 101.90% $1,270,858.00 FUND 201 PUBLIC IMPROV REVOLVIING FUND Dept R 201-31010 Current Ad Valorem Taxes R 201-31050 Tax Increments R 201-31099 Excess TIF Distribution R 201-33610 County Grants/Aid for Hwy R 201-34110 Street Vacation R 201-36210 Interest Earnings R 201-39106 Reimb.of Devlp.-2009 Presby R 201-39203 Trsfr from General Fund Balanc R 201-39310 Proceeds -Gen Obligation Bond Dept FUND 201 PUBLIC IMPROV REVOLVIING FUND FUND 202 HOUSING DEV PRO] FUND (TIF) Dept R 202-31050 Tax Increments R 202-31060 TIF Deficiency Payment R 202-36210 Interest Earnings Dept FUND 202 HOUSING DEV PROJ FUND (TIF) FUND 203 CAPITAL SPEC REV FUND Dept R 203-31010 Current Ad Valorem Taxes R 203-31050 Tax Increments R 203-31060 TIF Deficiency Payment R 203-33402 Homestead Credit R 203-36210 Interest Earnings Dept FUND 203 CAPITAL SPEC REV FUND $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $1,642.67 $1,500.00 $3,969.98 -$2,469.98 264.67% $1,500.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 - $520,000.00 $0.00 _ $0.00 $0.00 0.00% $0.00 $521,642.67 $1,500.00 $3,969.98 - -$2,469.98 264.67% $1,500.00 $521,642.67 $1,500.00 $3,969.98 - - -$2,469.98 - 264.67% $1,500.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 - $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 0.00% $494.14 $3,000.00 $3,700.96 -$700.96 123.37% $494.14 $3,000.00 $3,700.96 -$700.96 123.37% $494.14 $3,000.00 $3,700.96 -$700.96 123.37% $0.00 $0.00 $0.00 $0.00 $3,000.00 $3,000.00 $3,000.00 12/15/16 12:36 PM Page 3 2016 2016 2016 YTD 2016 % 2017 Account Descr 2015 Amt Budget YTD Amt Balance of Budget Budget Underline FUND 204 TIF LAKEVIEW LOFTS Dept R 204-31050 Tax Increments R 204-33402 Homestead Credit R 204-36210 Interest Earnings Dept FUND 204 TIF LAKEVIEW LOFTS FUND 301 TIF DEBT SERVICE Dept R 301-31050 Tax Increments R 301-31060 TIF Deficiency Payment R 301-33402 Homestead Credit R 301-36210 Interest Earnings R 301-39203 Trsfr from General Fund Balanc R 301-39310 Proceeds -Gen Obligation Bond Dept FUND 301 TIF DEBT SERVICE FUND 302 2010A GO Bonds Dept R 302-31010 Current Ad Valorem Taxes R 302-36100 Special Assessments R 302-36210 Interest Earnings Dept FUND 302 2010A GO Bonds FUND 303 2015 GO BONDS Dept R 303-36100 Special Assessments R 303-36210 Interest Earnings R 303-39200 Trsfr from Capital Fund Dept FUND 303 2015 GO BONDS FUND 400 EQUIPMENT REPLACEMENT Dept $91,145.81 $70,000.00 $0.00 $0.00 $223.44 $1,500.00 $91,369.25 $71,500.00 $91,369.25 $71,500.00 $107,965.55 -$37,965.55 154.24% $1,719.38 -$1,719.38 0.00% $2,121.80 -$621.80 141.45% $111,806.73 -$40,306.73 156.37% $111,806.73 -$40,306.73 156.37% $0.00 $0.00 $0.00 $0.00 �P_­ $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $663.50 -$663.50 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 - $0.00 - $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $663.50 -$663.50 0.00% _ $0.00 $0.00 $0.00 $663.50 -$663.50 0.00% $0.00 $18,558.00 $0.00 $0.00 $0.00 0.00% $0.00 $3,113.90 $0.00 $0.00 $0.00 0.00% $0.00 $45.63 $0.00 $174.69 -$174.69 0.00% $0.00 $21,717.53 $0.00 $174.69 _ -$174.69 0.00% $0.00 $21,717.53 $0.00 $174.69 -$174.69 0.00% $0.00 $11,449.35 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $161.48 -$161.48 0.00% $0.00 $26,149.83 $0.00 $0.00 $0.00 0.00% $0.00 $37,599.18 $0.00 $161.48 -$161.48 0.00% $0.00 $0.00 $161.48 $161.48 0.00% $0.00 R 400-36210 Interest Earnings $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 400-39203 Trsfr from General Fund Balanc $0.00 $0.00 $0.00 $0.00 0.00% $0.00 12/15/16 12:36 PM Page 4 2016 2016 2016 YTD 2016 % 2017 Account Descr _ 2015 Amt Budget YTD Amt Balance of Budget Budget Underline R 400-39311 Trsfr from Water Fund Balance $0.00 $0.00 $0.00 Dept $0.00 $0.00 $0.00 $0.00 0.00% $0.00 FUND 400 EQUIPMENT REPLACEMENT $0.00 $0.00 $0.00 $0.00 0.00% $0.00 FUND 401 CHANNEL ROAD Dept R 401-36100 Special Assessments R 401-36210 Interest Earnings R 401-39202 Contribution -Enterprise Fund R 401-39310 Proceeds -Gen Obligation Bond Dept FUND 401 CHANNEL ROAD FUND 402 KINGS RD/WARREN DRAINAGE IMPRV Dept R 402-36210 Interest Earnings R 402-39310 Proceeds -Gen Obligation Bond Dept FUND 402 KINGS RD/WARREN DRAINAGE IMPR FUND 403 WEST ARM RD EAST IMPRV PROJECT Dept R 403-36210 Interest Earnings R 403-39310 Proceeds -Gen Obligation Bond Dept FUND 403 WEST ARM RD EAST IMPRV PROJEC FUND 404 WEST ARM CENTRAL DRAIN/IMPROV Dept R 404-36210 Interest Earnings R 404-39310 Proceeds -Gen Obligation Bond Dept FUND 404 WEST ARM CENTRAL DRAIN/IMPROV FUND 405 LIFT STATION NO. 5 UPGRADE Dept R 405-39310 Proceeds -Gen Obligation Bond Dept FUND 405 LIFT STATION NO. 5 UPGRADE $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 -- $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $315.34 $260,000.00 $0.00 $0.00 -$82.50 $0.00 $82.50 0.00% $0.00 0.00% $0.00 $0.00 $260,315.34 $0.00 -$82.50 $82.50 0.00% $0.00 $260,315.34 $0.00 -$82.50 $82.50 0.00% $0.00 $779.30 $0.00 -$528.82 $528.82 0.00% $0.00 $246,472.24 $0.00 $0.00 $0.00 0.00% $0.00 $247,251.54 $0.00 -$528.82 $528.82 0.00% $0.00 $247,251.54 $0.00 -$528.82 $528.82 0.00% $0.00 -$9.37 $0.00 $0.00 $0.00 0.00% $0.00 $13,527.63 $0.00 $0.00 $0.00 -- 0.00% $0.00 $13,518.26 $0.00 $0.00 $0.00 - - - 0.0% 0% $0.00 $13,518.26 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 12/15/16 12:36 PM Page 5 2016 2016 2016 YTD 2016 % 2017 Account Descr 2015 Amt Budget YTD Amt Balance of Budget Budget Underline FUND 601 WATER FUND Dept R 601-31010 Current Ad Valorem Taxes $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 601-36210 Interest Earnings $931.23 $6,000.00 $8,200.10 -$2,200.10 136.67% $6,000.00 R 601-37100 Water Sales $263,664.07 $275,000.00 $276,377.34 -$1,377.34 100.50% $275,000.00 R 601-37150 Meter Deposit & Permits $732.49 $500.00 $0.00 $500.00 0.00% $500.00 R 601-37151 Connect/ReconnectFees $410.00 $500.00 $550.24 -$50.24 110.05% $500.00 R 601-37160 Water Penalty $1,005.29 $1,000.00 $1,401.31 -$401.31 140.13% $1,000.00 R 601-37175 Equalization Col.Fees 09 Presb $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 601-39100 Testing Fees $2,093.96 $2,000.00 $2,141.80 -$141.80 107.09% $2,000.00 R 601-39104 Other Revenue $50,414.04 $45,000.00 $48,835.69 -$3,835.69 108.52% $45,000.00 R 601-39107 Gain on Sale of Capital Asset $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 601-39202 Contribution -Enterprise Fund $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 601-39310 Proceeds -Gen Obligation Bond $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 601-39311 Trsfr from Water Fund Balance _$0.00 $76_,306.00 $0.00_ $76,306.00 0.00_% $70,438.0.0 Dept $319,251.08 $406,306.00 $337,506.48 $68,799.52 0 83.07 /o $400,438.00 FUND 601 WATER FUND $319,251.08 $406,306.00 $337,506.48 $68,799.52 83.07% $400,438.00 FUND 602 SEWER FUND Dept R 602-31010 Current Ad Valorem Taxes $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 602-34108 Admin Charges $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 602-36210 Interest Earnings $982.51 $3,000.00 $3,872.17 -$872.17 129.07% $3,000.00 R 602-37200 Sewer Sales $363,888.72 $410,000.00 $363,925.42 $46,074.58 88.76% $410,000.00 R 602-37250 Sewer Connect/ Reconnect Fee $50.00 $0.00 $100.50 -$100.50 0.00% $0.00 R 602-37260 Swr Penalty $1,476.22 $1,000.00 $2,019.32 -$1,019.32 201.93% $1,000.00 R 602-37275 Equalization Col.Fees 09 Presb $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 602-37400 Reserve Replacement Charge $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 602-39104 Other Revenue $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 602-39107 Gain on Sale of Capital Asset $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 602-39202 Contribution -Enterprise Fund $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 602-39310 Proceeds -Gen Obligation Bond $0.00 $0.00 $0.00 $0.00 0.00% $0.00 R 602-39312 Trsfr from Sewer Fund Balance _ $0.00 $154,182.00 $0.00 --_-- $154 182.00 0.00% $171 .800.00 Dept $366,397.45 $568,182.00 --- $369,917.41 -� --- $198,264.59 - -- - 65.11% __ $585,800.00 FUND 602 SEWER FUND $366,397.45 $568,182.00 $369,917.41 $198,264.59 65.11% $585,800.00 FUND 999 CONVERSION FUND Dept R 999-31010 Current Ad Valorem Taxes $60,027.21 $0.00 $0.00 $0.00 0.00% $0.00 12/15/16 12:36 PM Page 6 2016 2016 2016 YTD 2016 % 2017 Account Descr 2015 Amt Budget YTD Amt Balance of Budget Budget UnderLine R 999-39310 Proceeds -Gen Obligation Bond-$1,040,000.00 $0.00 $0.00 Dept-$979,972.79 $0.00 $0.00 $0.00 - - - 0.00% - --- $0.00 FUND 999 CONVERSION FUND-$979,972.79 $0.00 $0.00 $0.00 -- - - - 0.00% - $0.00 $2,027,370.47 $2,220,560.00 $2,019,555.48 $201,004.52 90.95% $2,261,596.00 CITY OF SPRING PARK 2017 Expenditure Budget Worksheet - SP w/Utilities Current Period: December 2016 2016 2016 2016 2016 YTD % of 2017 Account Descr 2015 Amt Budget YTD Amt Balance Budget Budget UnderLine FUND 101 GENERAL FUND Dept 41100 Mayor/Council/PI. Comm. E 101-41100-105 Salary/Part-time E 101-41100-121 PERA/FICA/HospIns E 101-41100-437 Other Miscellaneous Dept 41100 Mayor/Council/PI. Comm. Dept 41410 Elections E 101-41410-105 Salary/Part-time E 101-41410-200 Office Supplies E 101-41410-351 Legal Notices Publishing E 101-41410-437 Other Miscellaneous Dept 41410 Elections Dept 41500 Administration E 101-41500-101 Administrator E 101-41500-102 Clerk E 101-41500-103 People Service E 101-41500-107 Office Assistant E 101-41500-119 Ordinance Codification E 101-41500-121 PERA/FICA/HospIns E 101-41500-200 Office Supplies E 101-41500-207 Computer Support/Supplies E 101-41500-299 Admin Expenses E 101-41500-301 Auditing Services E 101-41500-302 Accounting Services E 101-41500-310 Contracted Services E 101-41500-321 Telephone and Mtce Agreement E 101-41500-322 Postage & Meter E 101-41500-323 Web Host E 101-41500-324 Cable Service E 101-41500-330 Technology Support E 101-41500-350 Print/Binding E 101-41500-361 Liability/Prop Ins/WC E 101-41500-404 Repairs/Existing Equip E 101-41500-413 Office Equipment/Rental E 101-41500-433 Membership/Dues/Edu E 101-41500-437 Other Miscellaneous E 101-41500-439 Other -TIF E 101-41500-560 Furniture and Fixtures $18,300.00 $9,600.00 $16,008.76 -$6,408.76 166.76% $19,600.00 $1,399.95 $1,500.00 $1,224.00 $276.00 81.60% $1,500.00 $3,776_.56 $2,000.00 $471.07 $1,528.93 23.55% $2,000.00 $23,476.51 $13,100.00 $17,703.83 -$4,603.83 135.14% $23,100.00 $0.00 $2,500.00 $3,412.52 -$912.52 136.50% $500.00 $162.07 $1,500.00 $219.97 $1,280.03 14.66% $100.00 $0.00 $150.00 $100.24 $49.76 66.83% $0.00 $757.44 $750.00 $1,572.30 -$822.30 209.64% $100.00 $919.51 $4,900.00 $5,305.03 -$405.03 108.27% $700.00 $44,557.68 $47,500.00 $49,834.80 -$2,334.80 104.92% $48,500.00 $20,259.99 $23,000.00 $27,329.81 -$4,329.81 118.83% $23,500.00 $0.00 $0.00 $57.27 -$57.27 0.00% $0.00 $12,443.25 $12,750.00 $12,320.69 $429.31 96.63% $13,000.00 $500.00 $2,000.00 $500.00 $1,500.00 25.00% $2,000.00 $25,152.20 $27,000.00 $28,100.14 -$1,100.14 104.07% $29,000.00 $639.93 $1,000.00 $495.03 $504.97 49.50% $750.00 $838.00 $1,500.00 $858.00 $642.00 57.20% $1,000.00 $832.45 $1,000.00 $202.25 $797.75 20.23% $1,000.00 $1,843.20 $2,200.00 $1,983.90 $216.10 90.18% $2,000.00 $281.84 $500.00 $458.00 $42.00 91.60% $500.00 $3,191.67 $1,500.00 $1,840.83 -$340.83 122.72% $1,500.00 $121.36 $200.00 $104.01 $95.99 52.01% $200.00 $301.50 $400.00 $349.89 $50.11 87.47% $300.00 $150.00 $2,000.00 $150.00 $1,850.00 7.50% $2,000.00 $222.93 $350.00 $201.93 $148.07 57.69% $350.00 $1,241.65 $1,500.00 $1,560.96 -$60.96 104.06% $1,500.00 $348.00 $400.00 $736.15 -$336.15 184.04% $750.00 $8,725.90 $9,500.00 $8,284.50 $1,215.50 87.21% $9,000.00 $0.00 $250.00 $0.00 $250.00 0.00% $250.00 $1,728.47 $1,750.00 $1,596.98 $153.02 91.26% $1,750.00 $5,607.44 $5,000.00 $6,016.45 -$1,016.45 120.33% $6,000.00 $5,175.72 $3,500.00 $9,986.67 -$6,486.67 285.33% $6,000.00 $1,312.50 $1,300.00 $1,035.00 $265.00 79.62% $1,300.00 $0.00 $0.00 $494.30 -$494.30 0.00% $0.00 12/15/16 12:37 PM Page 1 CITY OF SPRING PARK 2017 Expenditure Budget Worksheet - SP w/Utilities Current Period: December 2016 12/15/16 12:37 PM Page 2 2016 2016 2016 2016 YTD % of 2017 Account Descr 2015_ Amt Budget YTD Amt Balance Budget Budget UnderLine E 101-41500-581 Historical Society Support $3,000.00 $3,000.00 $3,000.00 $0.00 100.00% $3,000.00 Dept 41500 Administration $138,475.68 $149,100.00 $157,497.56 -$8,397.56 105.63% $155,150.00 Dept 41510 Public Works E 101-41510-310 Contracted Services $0.00 $0.00 -$2,328.34 0.00% $16,800.00 Dept 41510 Public Works _ $0.00 _ _ $0.00 _$2,328.34_ _ $2,328.34 _ -$2,328.34 0.00% $16,800.00 Dept 41550 Assessing E 101-41550-310 Contracted Services $16,113.56 $17,000.00 $18,117.69 -$1,117.69 106.57% $19,000.00 E 101-41550-437 Other Miscellaneous _ _ $9.0_0 $_0.00 $25.00 -$25.00 0.00% $0.00 Dept41550 Assessing $16,122.56 $17,000.00 $18,142.69 -$1,142.69 106.72% $19,000.00 Dept 41600 Law/Legal Services E 101-41600-304 Legal Fees $14,272.39 $17,000.00 $10,802.31 $6,197.69 63.54% $15,000.00 E 101-41600-351 Legal Notices Publishing $530.35 $1,000.00 $717.49 $282.51 71.75% $1,000.00 E 101-41600-353 Ordinance Publication _ $458.76 $600.00 $312.27 $287.73 52.05%_ $600.00 Dept 41600 Law/Legal Services $15,261.50 $18,600.00 _ $11,832.07 $6,767.93 63.61% $16,600.00 Dept 41900 Bldg.& Grounds E 101-41900-103 People Service $3,493.71 $6,000.00 $1,718.22 $4,281.78 28.64% $0.00 E 101-41900-105 Salary/Part-time $3,613.00 $3,300.00 $3,336.09 -$36.09 101.09% $3,500.00 E 101-41900-121 PERA/FICA/HospIns $1,224.76 $1,700.00 $901.66 $798.34 53.04% $1,700.00 E 101-41900-212 Gas and Oil/Truck R and M $1,136.95 $1,200.00 $535.06 $664.94 44.59% $0.00 E 101-41900-215 Shop Supplies $172.80 $1,500.00 $381.68 $1,118.32 25.45% $1,000.00 E 101-41900-220 Repair/Maint Supply $98.37 $0.00 $250.50 -$250.50 0.00% $250.00 E 101-41900-303 Engineering Fees $796.00 $500.00 $9.00 $491.00 1.80% $500.00 E 101-41900-310 Contracted Services $3,450.50 $4,500.00 $4,715.82 -$215.82 104.80% $4,500.00 E 101-41900-316 Tree Maintenance $667.50 $1,500.00 $219.17 $1,280.83 14.61% $1,500.00 E 101-41900-317 Trees New/Replace $0.00 $500.00 $0.00 $500.00 0.00% $500.00 E 101-41900-361 Liability/Prop Ins/WC $4,237.95 $4,500.00 $4,142.25 $357.75 92.05% $4,500.00 E 101-41900-381 Utilities/Electric/Gas $5,195.87 $6,000.00 $8,782.30 -$2,782.30 146.37% $6,000.00 E 101-41900-384 Refuse/Garbage Disposal $295.46 $400.00 $326.63 $73.37 81.66% $400.00 E 101-41900-401 Repairs/Maint Buildings $1,969.36 $3,000.00 $292.23 $2,707.77 9.74% $2,000.00 E 101-41900-404 Repairs/Existing Equip $587.20 $2,000.00 $13.98 $1,986.02 0.70% $1,500.00 E 101-41900-410 Facility Lease $4,352.56 $4,000.00 $2,793.70 $1,206.30 69.84% $4,000.00 E 101-41900-437 Other Miscellaneous $550.00 $500.00 $114.43 $385.57 22.89% $500.00 E 101-41900-520 Buildings/Improvements $0.00 $1,000.00 $0.00 $1,000.00 0.00% $1,000.00 E 101-41900-580 New Equipment $548.11 $0.00 $85.75 -$85.75 0.00% $0.00 Dept41900 Bldg.& Grounds $32,390.10 $42,100.00 $28,618.47 $13,481.53 67.98% $33,350.00 Dept 41910 Planning and Zoning E 101-41910-303 Engineering Fees $6,429.34 $6,000.00 $4,649.30 $1,350.70 77.49% $7,000.00 CITY OF SPRING PARK 2017 Expenditure Budget Worksheet - SP w/Utilities Current Period: December 2016 12/15/16 12:37 PM Page 3 2016 2016 2016 2016 YTD % of 2017 Account Descr 2015 Amt Budget YTD Amt Balance Budget Budget Underline E 101-41910-304 Legal Fees $2,186.58 $2,000.00 $1,654.95 $345.05 82.75% $1,000.00 E 101-41910-310 Contracted Services $25,036.55 $24,000.00 $28,864.78 ° -$4,864.78 120.27 /o $24,000.00 E 101-41910-381 Utilities/Electric/Gas $358.93 $0.00 $532.56 -$532.56 0.00% $0.00 Dept 41910 Planning and Zoning $34,011.40 $32,000.00 $35,701.59 -$3,701.59 111.57% $32,000.00 Dept 41940 City Beautification E 101-41940-103 People Service $1,284.52 $1,500.00 $447.51 $1,052.49 29.83% $0.00 E 101-41940-105 Salary/Part-time $0.00 $0.00 $45.00 -$45.00 0.00% $0.00 E 101-41940-121 PERA/FICA/Hosp Ins $342.14 $250.00 $114.99 $135.01 46.00% $0.00 E 101-41940-212 Gas and Oil/Truck R and M $966.75 $1,000.00 $488.55 $511.45 48.86% $750.00 E 101-41940-431 Flags/Banners/Maint/Labor $20,994.16 $17,000.00 $11,334.01 $5,665.99 66.67% $15,000.00 E 101-41940-432 Landscaping/Gardens/Maint $29,728.75 $36,000.00 $25,287.15 $10,712.85 70.24% $30,000.00 E 101-41940-530 Improvements Other Than Bldgs _ $250.00 $0.00 $0.00 $0.00 0.00% $0.00 Dept 41940 City Beautification $53,566.32 $55,750.00 $37,717.21 $18,032.79 67.65% _ $45,750.00 Dept 42000 Public Safety & Welfare E 101-42000-301 Auditing Services $1,843.20 $2,000.00 $1,983.90 $16.10 99.20% $2,000.00 E 101-42000-302 Accounting Services $281.84 $400.00 $458.00 -$58.00 114.50% $400.00 E 101-42000-304 Legal Fees $14,534.75 $15,000.00 $14,326.94 $673.06 95.51% $15,000.00 E 101-42000-310 Contracted Services $378,529.00 $403,000.00 $402,746.04 $253.96 99.94% $423,750.00 E 101-42000-312 Workhouse Exp Room & Board $586.00 $2,000.00 $2,474.50 -$474.50 123.73% $3,000.00 E 101-42000-313 Booking Per Diem/Jail Charges $894.42 $1,700.00 $1,991.49 -$291.49 117.15% $2,500.00 E 101-42000-321 Telephone and Mtce Agreement $949.92 $1,000.00 $998.86 $1.14 99.89% $1,000.00 E 101-42000-324 Cable Service $222.93 $350.00 $201.93 $148.07 57.69% $350.00 E 101-42000-580 New Equipment $0.00 $0.00 $4,647.64 -$4,647.64 0.00% $0.00 Dept 42000 Public Safety & Welfare $397,842.06 $425,450.00 $429,829.30 _ -$4,379.30 101.03% $448,000.00 Dept 42100 Lake Mtka Conservation Dist. E 101-42100-310 Contracted Services $5,545.00 $4,750.00 $4,728.00 $22.00 99.54% $5,000.00 Dept 42100 Lake Mtka Conservation Dist. $5,545.00 $4,750.00 $4,728.00 $22.00 99.54% _ $5,000.00 Dept 42260 Fire Services E 101-42260-310 Contracted Services $95,176.08 $100,000.00 $104,011.60 -$4,011.60 104.01% $100,000.00 E 101-42260-520 Buildings/Improvements $37,012.92 $35,000.00 $31 068.40 $3 931.60 88.77% $40 000.00 Dept 42260 Fire Services $132,189.00 $135,000.00 $135,080.00 -$80.00 100.06% $140,000.00 Dept 42400 Building Inspection E 101-42400-305 Plan Check Fees $5,264.68 $6,000.00 $7,239.84 -$1,239.84 120.66% $8,000.00 E 101-42400-310 Contracted Services $14,509.53 $12,000.00 $13,975.79 -$1,975.79 116.46_% $15,000.0_0 Dept 42400 Building Inspection $19,774.21 $18,000.00 _ $21,215.63 -$3,215.63 117.86% $23,000.00 Dept 42500 Civil Defense CITY OF SPRING PARK 2017 Expenditure Budget Worksheet - SP w/Utilities Current Period: December 2016 12/15/16 12:37 PM Page 4 2016 2016 2016 2016 YTD % of 2017 Account Descr 2015 Amt Budget YTD Amt Balance Budget Budget Underline E 101-42500-220 Repair/Maint Supply $254.52 $250.00 $222.94 $27.06 89.18% $250.00 Dept 42500 Civil Defense $254.52 $250.00 $222.94 $27.06 89.18% $250.00 Dept 42800 Spring Fall Cleanup E 101-42800-310 Contracted Services $13 976.51 � _- - $14 000.00 -__ , _ 14 501.75 , -$501.75 ° 103.58 /o $14,000.00 Dept 42800 Spring Fall Cleanup $13,976.51 _ $14,000.00 -_$ -_ $14,501.75 _ _ -$501.75 103.58% $14,000.00 Dept 42900 Recycling E 101-42900-310 Contracted Services $22,719.40 $24,000.00 $21,257.19 $2,74_2.81 88.57% $23,000.00 Dept 42900 Recycling $22,719.40 $24,000.00 $21,257.19 _ $2,742.81 88.57% $23,000.00 Dept 43100 Streets & Sidewalks E 101-43100-103 People Service $10,420.89 $7,250.00 $2,650.00 $4,600.00 36.55% $0.00 E 101-43100-105 Salary/Part-time $59.94 $250.00 $350.86 -$100.86 140.34% $250.00 E 101-43100-121 PERA/FICA/Hosp Ins $2,791.07 $2,250.00 $960.49 $1,289.51 42.69% $0.00 E 101-43100-212 Gas and Oil/Truck R and M $1,052.23 $1,500.00 $1,469.11 $30.89 97.94% $500.00 E 101-43100-226 Sign Repair Materials $930.69 $0.00 $243.32 -$243.32 0.00% $500.00 E 101-43100-227 Street Light Repairs $7,544.53 $750.00 $0.00 $750.00 0.00% $750.00 E 101-43100-301 Auditing Services $737.28 $900.00 $793.56 $106.44 88.17% $900.00 E 101-43100-302 Accounting Services $120.49 $200.00 $183.20 $16.80 91.60% $200.00 E 101-43100-303 Engineering Fees $702.42 $0.00 $9.00 -$9.00 0.00% $0.00 E 101-43100-304 Legal Fees $854.75 $1,000.00 $646.94 $353.06 64.69% $1,000.00 E 101-43100-308 Street Sweeping $2,049.00 $2,500.00 $1,701.50 $798.50 68.06% $2,500.00 E 101-43100-310 Contracted Services $2,310.00 $1,750.00 $1,081.20 $668.80 61.78% $1,750.00 E 101-43100-315 Sidewalk Repair $3,420.00 $3,000.00 $0.00 $3,000.00 0.00% $3,000.00 E 101-43100-316 Tree Maintenance $2,803.50 $3,000.00 $739.80 $2,260.20 24.66% $3,000.00 E 101-43100-317 Trees New/Replace $626.00 $1,500.00 $2,800.00 -$1,300.00 186.67% $1,500.00 E 101-43100-361 Liability/Prop Ins/WC $2,825.30 $3,100.00 $2,761.50 $338.50 89.08% $3,000.00 E 101-43100-381 Utilities/Electric/Gas $12,566.71 $16,000.00 $8,582.93 $7,417.07 53.64% $14,000.00 E 101-43100-399 Storm Damage $5,419.00 $3,000.00 $825.00 $2,175.00 27.50% $3,000.00 E 101-43100-402 Repairs/Maint Streets/Strm Sew $8,800.00 $7,500.00 $0.00 $7,500.00 0.00% $7,500.00 E 101-43100-404 Repairs/Existing Equip $1,066.23 $1,000.00 $0.00 $1,000.00 0.00% $1,000.00 E 101-43100-410 Facility Lease $3,096.82 $3,700.00 $4,174.58 -$474.58 112.83% $3,700.00 E 101-43100-437 Other Miscellaneous $189.30 $500.00 $0.00 $500.00 0.00% $500.00 E 101-43100-520 Buildings/Improvements $6,702.95 $0.00 $0.00 $0.00 0.00% $0.00 E 101-43100-580 New Equipment -$229.11 $0.00 $85.75 -$85.75 0.00% $0.00 Dept 43100 Streets & Sidewalks $77,318.21 $60,650.00 $30,058.74 $30,591.26 49.56% $48,550.00 Dept 43101 Snow Removal E 101-43101-307 Snow Removal - Sidewalks $4,777.50 $15,000.00 $2,754.00 $12,246.00 18.36% $12,500.00 E 101-43101-309 Snow Plowing - Streets $5,719.50 $25,000.00 $4,595.50 $20,404.50 18.38% $22,500.00 CITY OF SPRING PARK 2017 Expenditure Budget Worksheet - SP w/Utilities Current Period: December 2016 12/15/16 12:37 PM Page 5 2016 2016 2016 2016 YTD % of 2017 Account Descr 2015 Amt Budget YTD Amt Balance Budget Budget UnderLine E 101-43101-318 Street Salt -Sanding _ $9,886.80 _ $10,000.00 $6,125.00 $3,875.00 Dept 43101 Snow Removal $20,383.80 $50,000.00 $13,474.50 $36,525.50 _61.25% 0 26.95 /o _$10,000.00 $45,000.00 Dept 43150 Surface Water Management E 101-43150-206 GIS $0.00 $1,000.00 $0.00 $1,000.00 0.00% $1,000.00 E 101-43150-303 Engineering Fees $5,692.50 $7,500.00 $1,890.00 $5,610.00 25.20% $6,000.00 E 101-43150-402 Repairs/Maint Streets/Strm Sew $5,139.48 $10,000.00 $0.00 $10,000.00 0.00% $7,500.00 Dept 43150 Surface Water Management $10,831.98 $18,500.00 $1,890.00 $16,610.00 10.22% $14,500.00 Dept 45180 Senior Center E 101-45180-310 Contracted Services Dept 45180 Senior Center Dept 45200 Parks E 101-45200-103 People Service E 101-45200-105 Salary/Part-time E 101-45200-121 PERA/FICA/HospIns E 101-45200-212 Gas and Oil/Truck R and M E 101-45200-301 Auditing Services E 101-45200-302 Accounting Services E 101-45200-303 Engineering Fees E 101-45200-310 Contracted Services E 101-45200-316 Tree Maintenance E 101-45200-361 Liability/Prop Ins/WC E 101-45200-381 Utilities/Electric/Gas E 101-45200-384 Refuse/Garbage Disposal E 101-45200-400 Repairs/Maint General E 101-45200-404 Repairs/Existing Equip E 101-45200-410 Facility Lease E 101-45200-520 Buildings/Improvements E 101-45200-580 New Equipment Dept 45200 Parks Dept 46000 Suburban Rate Authority E 101-46000-310 Contracted Services Dept 46000 Suburban Rate Authority Dept 47500 Debt Service E 101-47500-601 Debt Sry Bond Principal E 101-47500-611 Bond Interest E 101-47500-620 Fiscal Agent s Fees Dept 47500 Debt Service $11,750.00 $11,750.00 $1,100.81 $3,611.06 $516.02 $1,052.44 $737.28 $120.49 $702.42 $2,119.50 $1,000.00 $1,412.65 $484.85 $1,257.91 $145.89 -$6,566.12 $3,096.82 $1,335.00 -$2,020.00 $10,107.02 $11,000.00 $16,500.00 -$5,500.00 150.00% $11,000.00 $16,500.00 -$5,500.00 150.00% _$11,000_.00 $11,000.00 $1,500.00 $869.07 $630.93 57.94% $0.00 $2,750.00 $4,225.55 -$1,475.55 153.66% $4,000.00 $500.00 $583.49 -$83.49 116.70% $0.00 $1,400.00 $536.94 $863.06 38.35% $1,000.00 $800.00 $793.56 $6.44 99.20% $800.00 $150.00 $183.20 -$33.20 122.13% $200.00 $0.00 $9.00 -$9.00 0.00% $0.00 $3,000.00 $2,557.07 $442.93 85.24% $3,000.00 $1,000.00 $5,289.06 -$4,289.06 528.91% $2,000.00 $1,600.00 $1,380.75 $219.25 86.30% $1,500.00 $1,500.00 $32.20 $1,467.80 2.15% $1,000.00 $1,000.00 $1,229.37 -$229.37 122.94% $1,000.00 $0.00 $0.00 $0.00 0.00% $500.00 $2,500.00 $6,029.89 -$3,529.89 241.20% $3,000.00 $3,800.00 $4,174.58 -$374.58 109.86% $3,800.00 $2,500.00 $2,185.19 $314.81 87.41% $2,500.00 $2,500.00 $783.01 _ $1,716.99 31.32% $2,500.00 $26,500.00 $30,861.93 -$4,361.93 116.46% $26,800.00 $400.00 ----------- $400.00 $4.25.00 $400.00 $400.00 $425.00 $0.00 $31,250.00 $31,250.00 $0.00 $17,322.00 $23,396.25 $900.00 $450.00 $900.00 $900.00 $49,022.00 $55,546.25 -$25.00 106.25% $425.00 -$25.00 106.25% $425.00 $0.00 100.00% $111,250.00 -$6,074.25 135.07% $16,733.00 -$450.00 200.00% _ $900.00 -$6,524.25 113.31% $128,883.00 CITY OF SPRING PARK 2017 Expenditure Budget Worksheet - SP w/Utilities Current Period: December 2016 12/15/16 12:37 PM Page 6 2016 2016 2016 2016 YTD % of 2017 Account Descr 2015 Amt Budget YTD Amt Balance Budget Budget Underline Dept 49999 Operating Transfers E 101-49999-720 Operating Transfers $54,424.00 $0.00 $0.00 $0.00 0.00% $0.00 Dept 49999 Operating Transfers $54,424.00 $0.00 $0.00 $0.00 0.00% $0.00 FUND 101 GENERAL FUND $1,092,639.29 $1,170,072.00 $1,090,438.02 $79,633.98 93.19% ,270,858.00 FUND 201 PUBLIC IMPROV REVOLVIING FUND Dept 41900 Bldg.& Grounds E 201-41900-520 Buildings/Improvements $8,912.50 $20,000.00 $27,538.45 -$7,538.45 137.69% $0.00 E 201-41900-522 Entrance Signs $0.00 _ $20,000.00 $0.00 $20,000.00 0.00% $0.00_ Dept41900 Bldg.& Grounds $8,912.50 $40,000.00 $27,538.45 $12,461.55 68.85% $0.00 Dept 41940 City Beautification E 201-41940-432 Landscaping/Gardens/Maint $9,204.00 $0.00 $0.00 $0.00 0.00% $0.00 Dept 41940 City Beautification $9,204.00 $0.00 _ $0.00 $0.00 0.00% $0.00 Dept 43100 Streets & Sidewalks E 201-43100-407 Seal Coating $0.00 $40,000.00 $64,743.33 -$24,743.33 161.86% $0.00 E 201-43100-530 Improvements Other Than Bldgs $10,500.00 $0.00 $0.00 $0.00 0.00% $0.00 E 201-43100-722 Asset Management Plan _ $0.00 _ _ $0.00 $2,835.00 -$_2,835.00 0.00% $0.00 Dept 43100 Streets & Sidewalks $10,500.00 $40,000.00 _ $67,578.33 -$27,578.33 168.95% $0.00 Dept 43150 Surface Water Management E 201-43150-209 West Arm Road East Drainage Pr $0.00 $0.00 $102,139.74 -$102,139.74 0.00% $0.00 Dept 43150 Surface Water Management $0.00 $0.00 $102,139.74 -$102,139.74 0.00% $0.00 Dept 43200 Water & Sewer Infrastructure E 201-43200-599 Water & Sewer Infrastructure $15,021.53 $0.00 $85,125.70 -$85,125.70 0.00% $0.00 E 201-43200-722 Asset Management Plan $0.00 - $0.00 $2,835.00 -$2,835.00 0.00% $0.00 Dept 43200 Water & Sewer Infrastructure $15,021.53 $0.00 $87,960.70 -$87,960.70 0-.00% $0.00 Dept 45200 Parks E 201-45200-518 Thor Thompson Park Impr.Projec $11,824.74 $0.00 $0.00 $0.00 0.00% $0.00 Dept 45200 Parks $11,824.74 $0.00 $0.00 $0.00 0.00% $0.00 Dept 47500 Debt Service E 201-47500-620 Fiscal Agent s Fees Dept 47500 Debt Service Dept 49999 Operating Transfers E 201-49999-720 Operating Transfers Dept 49999 Operating Transfers FUND 201 PUBLIC IMPROV REVOLVIING FUND 17,082.16 $0.00 $0.00 0.00% $17,082.16 $0.00 _ $0.00 _$_0.00 $0.00 0.00% $26,149.83 - $0.00 $0._00 0.00% $26,149.83 $0.00 _ $0.00 _ __$0.00_ $0.00 0.00% $98,694.76 $80,000.00 $285,217.22 -$205,217.22 356.52% $0.00 $0.00 $0.00 $0.00 $0.00 CITY OF SPRING PARK 2017 Expenditure Budget Worksheet - SP w/Utilities Current Period: December 2016 12/15/16 12:37 PM Page 7 2016 2016 2016 2016 YTD % of 2017 Account Descr 2015 Amt Budget YTD Amt Balance Budget Budget UnderLine FUND 204 TIF LAKEVIEW LOFTS Dept 46500 Economic Development E 204-46500-439 Other - TIF - - $2,696.57 $0.00 $502.37 -$502.37 0.00% $0.00 Dept 46500 Economic Development $2,696.57 $0.00 $502.37 -$502.37 0.00% $0.00 FUND 204 TIF LAKEVIEW LOFTS $2,696.57 $0.00 $502.37 -$502.37 0.00% $0.00 FUND 302 2010A GO Bonds Dept 47500 Debt Service E 302-47500-601 Debt Sry Bond Principal $15,000.00 $0.00 $0.00 $0.00 0.00% $0.00 E 302-47500-611 Bond Interest _ $3,557.49 $0.00 $0.00 $0.00 0.00% $0.00 Dept 47500 Debt Service $18,557.49 $0.00 $0.00 $0.00 0.00% $0.00 FUND 302 2010A GO Bonds $18,557.49 $0.00 $0.00 $0.00 0.00% $0.00 FUND 303 2015 GO BONDS Dept 47500 Debt Service E 303-47500-611 Bond Interest $5,449.00 - $0.00 $0.00 $0.00 0.00% $0.00 Dept 47500 Debt Service $5,449.00 $0.00 $0.00 $0.00 0.00% $0.00 FUND 303 2015 GO BONDS $5,449.00 --------------------- $0.00 - $0.00 - $0.00 0.00% $0.00 FUND 402 KINGS RD/WARREN DRAINAGE IMPRV Dept 47500 Debt Service E 402-47500-620 Fiscal Agent s Fees $8,541.09 $0.00 $0.00 $0.00 0.00% $0.00 Dept 47500 Debt Service $8,541.09 $0.00 $0.00 $0.00 0.00% $0.00 Dept 49500 Kings Rd & Warren Drainage Imp E 402-49500-519 Kings Rd&Warren Drainage Impr $200,846.20 $0.00 $3_1,144.25 -$31,144.25 0.00% $0.00 Dept 49500 Kings Rd & Warren Drainage Imp $200,846.20 $0.00 $31,144.25 -$31,144.25 0.00% $0.00 FUND 402 KINGS RD/WARREN DRAINAGE IMPRV $209,387.29 $0.00 $31,144.25 $31,144.25 0.00% $0.00 FUND 403 WEST ARM RD EAST IMPRV PROJECT Dept 47500 Debt Service E 403-47500-620 Fiscal Agent s Fees $8,107.34 $0.00 $0.00 $0.00 0.00% $0.00 Dept 47500 Debt Service $8,107.34 $0.00 $0.00 $0.00 _ 0.00% _ $0.00 Dept 49501 West Arm Rd East Improv.Projec E 403-49501-121 PERA/FICA/HospIns $75.91 $0.00 $26.68 -$26.68 0.00% $0.00 E 403-49501-524 West Arm Rd East Improv.Projec $194,161.19 $0.00 $72,011.09 -$72,011.09 0.00% $0.00 Dept 49501 West Arm Rd East Improv.Projec $194,237.10 $0.00 $72,037.77 -$72,037.77 0.00% $0.00 CITY OF SPRING PARK 2017 Expenditure Budget Worksheet - SP w/Utilities Current Period: December 2016 2016 2016 2016 2016 YTD % of 2017 Account Descr 2015 Amt Budget YTD Amt Balance Budget Budget Underline FUND 403 WEST ARM RD EAST IMPRV PROJECT $202,344.44 $0.00 $72,037.77-$72,037.77 0.00% $0.00 FUND 404 WEST ARM CENTRAL DRAIN/IMPROV Dept 47500 Debt Service E 404-47500-620 Fiscal Agent s Fees Dept 47500 Debt Service Dept 49501 West Arm Rd East Improv.Projec E 404-49501-525 West Arm Rd Centrl Drain& Impr Dept 49501 West Arm Rd East Improv.Projec FUND 404 WEST ARM CENTRAL DRAIN/IMPROV FUND 601 WATER FUND Dept 47500 Debt Service E 601-47500-601 Debt Sry Bond Principal E 601-47500-611 Bond Interest E 601-47500-620 Fiscal Agent s Fees Dept 47500 Debt Service Dept 49400 Water Utilities E 601-49400-101 Administrator E 601-49400-102 Clerk E 601-49400-103 People Service E 601-49400-104 Standby- Orono E 601-49400-105 Salary/Part-time E 601-49400-107 Office Assistant E 601-49400-121 PERA/FICA/HospIns E 601-49400-129 Pension Expense E 601-49400-200 Office Supplies E 601-49400-201 Meters & Supplies E 601-49400-206 GIS E 601-49400-207 Computer Support/Supplies E 601-49400-212 Gas and Oil/Truck R and M E 601-49400-215 Shop Supplies E 601-49400-216 Chemicals and Chem Products E 601-49400-220 Repair/Maint Supply E 601-49400-299 Admin Expenses E 601-49400-301 Auditing Services E 601-49400-302 Accounting Services E 601-49400-303 Engineering Fees $433.61 $433.61 $189.00 -- $189.00 - $622.61 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $51,250.00 $51,250.00 $0.00 100.00% $51,250.00 $16,607.17 $16,956.00 $19,272.51 -$2,316.51 113.66% $16,088.00 $8,541.09 $0.00 $0.00 $0.00 0.00% $0.00_ $25,148.26 $68,206.00 $70,522.51 _ -$2,316.51 103.40% $67,338.00 $14,822.81 $16,000.00 $16,611.60 -$611.60 103.82% $17,000.00 $17,745.96 $21,000.00 $24,550.02 -$3,550.02 116.90% $22,000.00 $32,489.24 $35,000.00 $43,141.39 -$8,141.39 123.26% $33,600.00 $175.36 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $1,000.00 $90.00 $910.00 9.00% $1,000.00 $11,983.17 $12,000.00 $11,958.34 $41.66 99.65% $12,500.00 $25,155.60 $29,000.00 $23,999.00 $5,001.00 82.76% $25,000.00 $4,088.00 $0.00 $0.00 $0.00 0.00% $0.00 $478.04 $500.00 $458.82 $41.18 91.76% $500.00 $3,036.75 $5,000.00 $1,845.65 $3,154.35 36.91% $5,000.00 $689.25 $1,000.00 $0.00 $1,000.00 0.00% $1,000.00 $1,738.93 $1,500.00 $5,758.00 -$4,258.00 383.87% $2,000.00 $1,048.89 $1,500.00 $1,473.36 $26.64 98.22% $1,000.00 $41.14 $500.00 $177.49 $322.51 35.50% $500.00 $1,411.61 $2,500.00 $2,649.50 -$149.50 105.98% $2,500.00 $1,679.57 $2,000.00 $2,401.83 -$401.83 120.09% $2,000.00 $348.68 $400.00 $501.64 -$101.64 125.41% $500.00 $6,635.52 $7,000.00 $7,142.04 -$142.04 102.03% $7,500.00 $980.99 $1,400.00 $1,648.80 -$248.80 117.77% $1,750.00 $8,233.41 $9,000.00 $41.40 $8,958.60 0.46% $9,000.00 12/15/16 12:37 PM Page 8 CITY OF SPRING PARK 2017 Expenditure Budget Worksheet - SP w/Utilities Current Period: December 2016 12/15/16 12:37 PM Page 9 2016 2016 2016 2016 YTD % of 2017 Account Descr 2015 Amt Budget YTD Amt Balance Budget Budget Underline E 601-49400-304 Legal Fees $1,567.25 $1,000.00 $646.93 $353.07 64.69% $1,000.00 E 601-49400-306 Testing Fees $2,502.34 $3,000.00 $2,590.63 $409.37 86.35% $3,000.00 E 601-49400-310 Contracted Services $7,654.07 $3,000.00 $3,102.98 -$102.98 103.43% $4,000.00 E 601-49400-321 Telephone and Mtce Agreement $1,623.38 $1,700.00 $1,448.88 $251.12 85.23% $1,700.00 E 601-49400-322 Postage & Meter $301.50 $500.00 $264.80 $235.20 52.96% $500.00 E 601-49400-323 Web Host $150.00 $400.00 $150.00 $250.00 37.50% $400.00 E 601-49400-324 Cable Service $222.81 $350.00 $227.16 $122.84 64.90% $350.00 E 601-49400-330 Technology Support $2,384.14 $2,000.00 $1,798.46 $201.54 89.92% $2,000.00 E 601-49400-361 Liability/Prop Ins/WC $6,215.66 $6,800.00 $6,075.30 $724.70 89.34% $6,800.00 E 601-49400-381 Utilities/Electric/Gas $21,193.41 $25,000.00 $22,424.25 $2,575.75 89.70% $23,000.00 E 601-49400-401 Repairs/Maint Buildings $120.27 $1,000.00 $131.12 $868.88 13.11% $1,000.00 E 601-49400-404 Repairs/Existing Equip $1,848.28 $5,000.00 $3,993.08 $1,006.92 79.86% $5,000.00 E 601-49400-405 Depreciation $88,245.16 $90,000.00 $0.00 $90,000.00 0.00% $90,000.00 E 601-49400-410 Facility Lease $8,481.58 $7,500.00 $8,317.19 -$817.19 110.90% $9,000.00 E 601-49400-411 Repairs / Breaks $2,576.50 $35,000.00 $13,651.66 $21,348.34 39.00% $30,000.00 E 601-49400-413 Office Equipment/Rental $1,366.35 $1,500.00 $1,596.94 -$96.94 106.46% $1,500.00 E 601-49400-417 Uniform Rentals $841.45 $1,250.00 $421.24 $828.76 33.70% $0.00 E 601-49400-433 Membership/Dues/Edu $1,110.95 $1,500.00 $1,810.00 -$310.00 120.67% $0.00 E 601-49400-437 Other Miscellaneous $209.82 $4 800.00 $2,209.00 $2,591.00 46.02% $3,000.00 E 601-49400-481 Well 1 Repair/Maint $4,268.24 $0.00 $18.81 -$18.81 0.00% $1,000.00 E 601-49400-482 Well 2 Repair/Maint $4,268.23 $0.00 $118.81 -$118.81 0.00% $1,000.00 E 601-49400-483 Well #3 Rehab $6,606.00 $0.00 $7,220.50 -$7,220.50 0.00% $1,000.00 E 601-49400-486 HS Pumps $0.00 $0.00 $4,446.01 -$4,446.01 0.00% $3,000.00 E 601-49400-580 New Equipment $439.52 $500.00 $540.00 -$40.00 108.00% $500.00 E 601-49400-590 Water Tower Improvement $24,901.04 $0.00 $0.00 $0.00 0.00% $0.00 Dept 49400 Water Utilities $321,880.87 _ $338,100.00 $227,652.63 $110,447.37 67.33% $3 33,100. 00 Dept 49499 Water Tower Improvements E 601-49499-590 Water Tower Improvement _ $1,775.00 $0.00 $0.00 Dept 49499 Water Tower Improvements $1,775.00 _ $0.00 $0.00 FUND 601 WATER FUND $348,804.13 $406,306.00 $298,175.14 FUND 602 SEWER FUND Dept 47500 Debt Service E 602-47500-601 Debt Sry Bond Principal $0.00 $52,500.00 $52,500.00 E 602-47500-611 Bond Interest $15,316.94 $16,632.00 $8,248.75 Dept 47500 Debt Service $15,316.94 $69,132.00 $60,748.75 Dept 49450 Sewer Utilities E 602-49450-101 Administrator $14,810.18 $16,000.00 $16,611.60 $0.00 0.00% $0.00 $0.00 0.00% $0.00 $108,130.86 73.39% $400,438.00 $0.00 100.00% $8,383.25 49.60% $8,383.25 87.87% $57,500.00 $16,000.00 $73,500.00 -$611.60 103.82% $16,750.00 CITY OF SPRING PARK 2017 Expenditure Budget Worksheet - SP w/Utilities Current Period: December 2016 12/15/16 12:37 PM Page 10 2016 Account Descr 2015 Amt 2016 Budget 2016 YTD Amt 2016 YTD % of Balance Budget 2017 Budget Underline E 602-49450-102 Clerk $17,544.91 $19,000.00 $24,549.92 -$5,549.92 1:9.21% $21,000.00 E 602-49450-103 People Service $25,273.37 $28,000.00 $41,672.25 -$13,672.25 148.83% $33,600.00 E 602-49450-107 Office Assistant $11,864.54 $12,000.00 $11,958.28 $41.72 99.65% $12,500.00 E 602-49450-121 PERA/FICA/HospIns $22,933.26 $27,000.00 $23,435.85 $3,564.15 86.80% $22,000.00 E 602-49450-129 Pension Expense -$5,293.00 $0.00 $0.00 $0.00 0.00% $0.00 E 602-49450-200 Office Supplies $478.06 $500.00 $450.82 $49.18 90.16% $500.00 E 602-49450-206 GIS $689.25 $1,000.00 $0.00 $1,000.00 0.00% $1,000.00 E 602-49450-207 Computer Support/Supplies $838.00 $1,000.00 $2,958.00 -$1,958.00 295.80% $1,500.00 E 602-49450-212 Gas and Oil/Truck R and M $1,048.87 $1,500.00 $1,473.37 $26.63 98.22% $1,000.00 E 602-49450-215 Shop Supplies $41.15 $500.00 $33.91 $466.09 6.78% $500.00 E 602-49450-220 Repair/Maint Supply $288.87 $400.00 $738.81 -$338.81 184.70% $500.00 E 602-49450-301 Auditing Services $6,635.52 $7,000.00 $7,142.04 -$142.04 102.03% $7 200.00 E 602-49450-302 Accounting Services $980.98 $1,400.00 $1,648.80 -$248.80 117.77% $1,700.00 E 602-49450-303 Engineering Fees $702.41 $500.00 $1,841.30 -$1,341.30 368.26% $1,000.00 E 602-49450-304 Legal Fees $854.78 $500.00 $646.93 -$146.93 129.39% $500.00 E 602-49450-310 Contracted Services $1,719.91 $2,000.00 $2,439.59 -$439.59 121.98% $2,500.00 E 602-49450-321 Telephone and Mtce Agreement $1,610.37 $1,700.00 $1,448.90 $251.10 85.23% $1,700.00 E 602-49450-322 Postage & Meter $301.50 $500.00 $264.80 $235.20 52.96% $500.00 E 602-49450-323 Web Host $150.00 $500.00 $150.00 $350.00 30.00% $500.00 E 602-49450-324 Cable Service $222.81 $350.00 $227.16 $122.84 64.90% $350.00 E 602-49450-327 MCES Sewer Service Chg $190,929.00 $200,000.00 $166,368.10 $33,631.90 83.18% $205,500.00 E 602-49450-330 Technology Support $2,384.21 $2,000.00 $1,798.58 $201.42 89.93% $2,000.00 E 602-49450-361 Liability/Prop Ins/WC $5,085.54 $6,000.00 $5,220.70 $779.30 87.01% $6,000.00 E 602-49450-381 Utilities/Electric/Gas $253.43 $500.00 $3,859.52 -$3,359.52 771.90% $1,000.00 E 602-49450-400 Repairs/Maint General $0.00 $5,000.00 $530.00 $4,470.00 10.60% $2,500.00 E 602-49450-403 Cleaning -Televising $20,778.25 $10,000.00 $24,452.08 -$14,452.08 244.52% $20,000.00 E 602-49450-404 Repairs/Existing Equip $81.40 $5,000.00 $45.43 $4,954.57 0.91% $2,500.00 E 602-49450-405 Depreciation $68,448.36 $100,000.00 $0.00 $100,000.00 0.00% $100,000.00 E 602-49450-410 Facility Lease $8,481.56 $7,500.00 $8,317.18 -$817.18 110.90% $9,000.00 E 602-49450-411 Repairs / Breaks $192.50 $15,000.00 $3,080.00 $11,920.00 20.53% $15,000.00 E 602-49450-413 Office Equipment/Rental $1,366.37 $1,500.00 $1,596.94 -$96.94 106.46% $1,500.00 E 602-49450-417 Uniform Rentals $920.25 $1,400.00 $516.46 $883.54 36.89% $0.00 E 602-49450-433 Membership/Dues/Edu $943.97 $1,000.00 $1,809.98 -$809.98 181.00% $0.00 E 602-49450-437 Other Miscellaneous $0.00 $4,800.00 $495.00 $4,305.00 10.31% $2,500.00 E 602-49450-491 LS Repair/Maint $3,712.65 $3,000.00 $4,193.61 -$1,193.61 139.79% $3,000,00 E 602-49450-492 LS Repair/Maint $5,266.29 $3,000.00 $2,885.37 $114.63 96.18% $3,000.00 E 602-49450-493 LS Repair/Maint $2,296.92 $3,000.00 $4,603.85 -$1,603.85 153.46% $3,000.00 E 602-49450-494 LS Repair/Maint $5,431.93 $3,000.00 $703.33 $2,296.67 23.44% $3,000.00 E 602-49450-495 LS Repair/Maint $2,270.26 $3,000.00 $1,616.97 $1,383.03 53.90% $3,000.00 CITY OF SPRING PARK 2017 Expenditure Budget Worksheet - SP w/Utilities Current Period: December 2016 12/15/16 12:37 PM Page 11 2016 2016 2016 2016 YTD % of 2017 Account Descr 2015 Amt Budget YTD Amt Balance Budget Budget Underline E 602-49450-496 LS Repair/Maint $9,893.37 $3,000.00 $11,639.31 -$8,639.31 387.98% $3,000.00 E 602-49450-580 New Equipment $439.51 $0.00 $0.00 $0.00 0.00% $0.00 E 602-49450-620 Fiscal Agent s Fees $17,082.17 $0.00 $0.00 $0.00 0.00% Dept 49450 Sewer Utilities $449,953.68 $499,050.00 $383,424.74 $115,625.26 76.83% $512,300.00 Dept 49456 Lift Station No.5 Replacement E 602-49456-121 PERA/FICA/HospIns $0.00 $0.00 $37.69 -$37.69 0.00% $0.00 E 602-49456-598 Lift Station No.5 Replacement $76.00 _ $0.00 $11,770.12 -$11,770.12 0.00% $0.00 Dept 49456 Lift Station No.5 Replacement $76.00 $0.00 $11,807.81 -$11,807.81 0.00% $0.00 FUND 602 SEWER FUND $465,346.62 $568,182.00 $455,981.30 $112,200.70 80.25% $585,800.00 FUND 999 CONVERSION FUND Dept 49999 Operating Transfers E 999-49999-100 Wage E 999-49999-129 Pension Expense E 999-49999-405 Depreciation E 999-49999-500 Capital Outlay E 999-49999-601 Debt Sry Bond Principal E 999-49999-611 Bond Interest Dept 49999 Operating Transfers FUND 999 CONVERSION FUND -$2,916.00 $0.00 $0.00 $0.00 0.00% $0.00 $1,813.00 $0.00 $0.00 $0.00 0.00% $0.00 $97,490.14 $0.00 $0.00 $0.00 0.00% $0.00 -$381,799.81 $0.00 $0.00 $0.00 0.00% $0.00 -$15,000.00 $0.00 $0.00 $0.00 0.00% $0.00 $5,755.00 - - $0.00 $0.00 0.00 0.00% -$294,657.67 $0.00 $0.00 - $0.00 0.00% $0.00 -$294,657.67 $0.00 - - $0.00 0.00% $0.00 $2,149,884.53 $2,224,560.00 $2,233,496.07-$8,936.07 100.40% '.,257,096.00