Loading...
5.b treasurer's report - june 2016CA DIA Beginning Balance 06/01/2016 Receipts Expenditures Payroll Adjustments: Ending Balance 6/30/2016 City of Scandia Treasurer's Report 6/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 Checks in Transit Deposits in Transit Total Funds Submitted by: Colleen Firkus, Treasurer $ 495,078.28 $ 23,663.32 $ 74,926.61 $ 1,700,363.97 $ 306,439.75 $ 317,146.91 $ 5,070.47 $ 2,832,898.28 $ 37,794.39 $ (518,741.60) $ 2,351,951.07 $ 2,398,877.24 $ 5,070.47 $ (51,996.64) $ 2,351,951.07 City of Scandia SC,AN I� to Expenditure Summary June 2016 PARK CAPITAL IMPROVEMENTS EQUIPMENT REPLACEMENT LOCAL ROAD IMPROVEMENT FUP 201 SEWER FUND UPTOWN SEWER $38,500.00 $315,00000 $1,250,000-00 $0.00 $0.00 $305,896.98 $0.00 $0.00 $292,01848 $38,500.00 0.00% $315,00000 000% $944,103.02 2447% $50,730.00 $16,035.00 $29,15615 $8,305.79 $4,377.78 $1,036.82 $21,57385 $7,729.21 2016 YTD Budget % of YTD GENERAL FUND 2016 YTD Budget 2016 YTD Amount 2016 MTD Amount Balance Budget Administration & Finance $324,84800 $168,487.64 $21,346.86 $156,360.36 51.87% City Council $26,97600 $4,441 76 $000 $22,53424 16.47% Elections $6,150.00 $600.00 $0.00 $5,55000 9.76% Planning & Building $96,20600 $41,948.88 $9,939.54 $54,25712 43.60% Police $116,197.00 $30936 $000 $115,88764 027% Fire Department $240,57600 $65,548.83 $11,62394 $175,027.17 2725% Public Works $1,197,153.00 $223,221.69 $56,01546 $973,93131 18.65% Parks & Recreation $60,879.00 $25,640.89 $4,25978 $35,23811 4212% Community Center $40,261.00 $16,447.06 $1,738.45 $23,813.94 40.85% Total General Fund $2,109,246.00 $546,646.11 $104,924.03 $1,562,599.89 2592% EDA $000 $325.00 $000 -$325.00 000% DEBT 2010 EQUIPMENT CERTIFICATES $43,010.00 $40,710.00 $0.00 $2,300.00 9465% 2011 EQUIPMENT CERTIFICATES $31,18500 $592.50 $000 $30,592.50 190% 2013 EQUIPMENT CERTIFICATES $65,823.00 $61,330.00 $60,895.00 $4,49300 93.17% 2015 EQUIPMENT CERTIFICATE $46,720.00 $47.020.50 $45.010.25 -$30050 100.64% $186,738.00 $149,653.00 $105,905.25 $37,085.00 80.14% CAPITAL IMPROVEMENTS $40,000.00 $2,370.00 $0.00 $37,630.00 5.93% PARK CAPITAL IMPROVEMENTS EQUIPMENT REPLACEMENT LOCAL ROAD IMPROVEMENT FUP 201 SEWER FUND UPTOWN SEWER $38,500.00 $315,00000 $1,250,000-00 $0.00 $0.00 $305,896.98 $0.00 $0.00 $292,01848 $38,500.00 0.00% $315,00000 000% $944,103.02 2447% $50,730.00 $16,035.00 $29,15615 $8,305.79 $4,377.78 $1,036.82 $21,57385 $7,729.21 57.47% 51.80% Report Total $4,006,249.00 $1,042,353.03 $508,262.36 $2,963,895.97 26.02% 2016 FUND 101 GENERAL 225 EDA 307 BLACKTOP 2007 311 EQUIPMENT CERTIFICATES 312 EQUIPMENT CERTIFICATES 313 EQUIPMENT CERTIFICATES 315 EQUIPMENT CERTIFICATES 401 CAPITAL IMPR 404 PARK CAP IMPR 406 EQUIPMENT REPLACEMENT 408 LOCAL ROAD IMPROVEMENT 602 201 SEWER 612 UPTOWN SEWER 801 ESCROW TOTAL CASH BALANCES APRIL END OF MONTH JUNE JANUARY FEBRUARY $1,737,452 $1,639,251 $5,395 $5,395 $42,934 $42,934 $12,360 $12,360 $6,735 $6,735 $10,521 $10,086 $0 -$2,010 $290,627 $289,390 $15,188 $15,188 $470,608 $470,608 $444,981 $402,956 $58,473 $47,447 -$5,307 $2,640 $101,798 $83,597 $3,191,766 $3,026,576 MARCH APRIL MAY JUNE $1,548,904 $1,483,118 $1,429,801 $1,344,311 $5,396 $5,070 $5,070 $5,070 $42,934 $57,829 $58,187 $58,187 $12,360 $12,360 $12,360 $12,360 $6,735 $6,735 $6,143 $6,143 $10,086 $10,086 $10,086 -$50,809 -$2,010 -$2,010 -$2,010 -$47,021 $289,270 $289,270 $287,020 $287,020 $15,280 $16,030 $20,230 $20,380 $499,258 $499,258 $499,258 $499,258 $395,563 $392,240 $389,808 $97,790 $51,642 $56,707 $52,283 $57,774 $1,101 -$957 $1,717 $680 $74,737 $66,746 $62,945 $60,808 $2,951,256 $2,892,481 $2,832,898 $2,351,951