Loading...
5.b Treasurer's reportlb- SCANDIA Beginning Balance 04/01/2016 Receipts Expenditures Payroll Adjustments: Ending Balance 4/31/2016 City of Scandia Treasurer's Report 4/30/2016 Ending Balance includes the following Investments: Checking *102 Money Market *105 - Rate .25% CD *3136 — Rate .90%, 24 mo., 3/21/2017 CD *3137 — Rate .80% 18 mo., 1/21/2017 Total Undesignated Funds Scandia EDA *6301 Total Designated Funds Total Funds Submitted by: Colleen Firkus, Treasurer $ 121,574.34 $ 25,955.47 $ 24,619.65 $ 2,251,194.01 $ 305,746.17 $ 317,146.91 $ 5,070.47 $ 2,951,256.10 $ 88,754.69 $ (147,529.81) $ 2,892,480.98 $ 2,898,706.74 $ 5,070.47 $ 2,903,777.21 City of Scandia Expenditure Summary April 2016 2016 YTD Budget % of YTD GENERAL FUND 2016 YTD Budget 2016 YTD Amount 2016 MTD Amount Balance Budget Administration & Finance $324,848.00 $114,095.87 $41,481 04 $210,752.13 35.12% City Council $26,976.00 $4,435.76 $4,38476 $22,540.24 16.44% Elections $6,150.00 $60000 $000 $5,550.00 9.76% Planning & Building $96,206.00 $19,098.03 $4,413.20 $77,107.97 19.85% Police $116,197.00 $309.36 $0.00 $115.88764 027% Fire Department $240,576.00 $46,730.67 $21,918.78 $193,84533 19.42% Public Works $1,202,153 00 $134,014.66 $38,145.80 $1,068,138.34 11.15% Parks & Recreation $60,879.00 $18,206.13 $7,143.59 $42,67287 29.91% Community Center $40,261.00 $13,021.75 $7,092.32 $27.23925 3234% Total General Fund $2,114,246.00 $350,512.23 $124,579.49 $1,763,733.77 16.58% EDA $0.00 $32500 $325.00 -$32500 DEBT 2010 EQUIPMENT CERTIFICATES $43,010.00 $40,71000 $0.00 $2,30000 94.65% 2011 EQUIPMENT CERTIFICATES $31,185.00 $000 $0.00 $31,18500 0.00% 2013 EQUIPMENT CERTIFICATES $65,823.00 $43500 $0.00 $65,38800 0.66% 2015 EQUIPMENT CERTIFICATE $46,720.00 $2,01025 $0.00 $44,70975 4.30% $186,738.00 $43,155.25 $0.00 $143,582.75 23.11% CAPITAL IMPROVEMENTS $40,000.00 $12000 $0.00 $39,88000 0.30% PARK CAPITAL IMPROVEMENTS $38,500.00 -$500.00 $38,500.00 0.00% EQUIPMENT REPLACEMENT $315,000.00 $0.00 $0.00 $315,000.00 0.00% LOCAL ROAD IMPROVEMENT FUl' $1,250,000.00 $11,447.00 $4,054.50 $1,238,553 00 0.92% 201 SEWER FUND $50,730.00 $20,182.17 $5,131.75 $30,54783 39.78% UPTOWN SEWER $16,03500 $5,20803 $2,057.22 $10,82697 32-48% Report Total $4,011,249.00 $430,949.68 $135,647.96 $3,580,299.32 10.74% SC ANDLA CASH BALANCES 2016 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL 101 GENERAL $1,737,452 $1,639,251 $1,548,904 $1,483,118 225 EDA $5,395 $5,395 $5,396 $5,070 307 BLACKTOP 2007 $42,934 $42,934 $42,934 $57,829 311 EQUIPMENT CERTIFICATES $12,360 $12,360 $12,360 $12,360 312 EQUIPMENT CERTIFICATES $6,735 $6,735 $6,735 $6,735 313 EQUIPMENT CERTIFICATES $10,521 $10,086 $10,086 $10,086 315 EQUIPMENT CERTIFICATES $0 -$2,010 -$2,010 -$2,010 401 CAPITAL IMPR $290,627 $289,390 $289,270 $289,270 404 PARK CAP IMPR $15,188 $15,188 $15,280 $16,030 406 EQUIPMENT REPLACEMENT $470,608 $470,608 $499,258 $499,258 408 LOCAL ROAD IMPROVEMENT $444,981 $402,956 $395,563 $392,240 602 201 SEWER $58,473 $47,447 $51,642 $56,707 612 UPTOWN SEWER -$5,307 $2,640 $1,101 -$957 801 ESCROW $101,798 $83,597 $74,737 $66,746 TOTAL $3,191,766 $3,026,576 $2,951,256 $2,892,481