Loading...
5.b Treasurer's Reporta Lfg. SCANDIA Beginning Balance 10/01/2016 Receipts Expenditures Payroll Adjustments: duplicate receipt entry Ending Balance 10/31/2016 City of Scandia Treasurer's Report 10/31/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 $ 2,582,920.51 $ 30,970.20 $ 75,961.81 $ 25,150.18 $ (101,111.99) $ 2,512,778.72 $ 37,898.13 $ 1,847,007.40 $ 307,134.91 $ 318,420.25 $ 2,510,460.69 $ 5,070.47 $ 5,070.47 $ (2,752.44) S $ 2,512,778.72 SCANDIA City of Scandia Expenditure Summary Oct -16 2016 YTD Budget % of YTD GENERAL FUND 2016 YTD Budget 2016 YTD Amount 2016 MTD Amount Balance Budget Administration & Finance $324,84800 $258,734.87 $21,51762 $66,11313 79.65% City Council $26,976.00 $13,211 28 $4,384.76 $13,764.72 4897% Elections $6,150.00 $2,558.28 $0.00 $3,591.72 4160% Planning & Building $96,206.00 $82,989.74 $11,171.59 $13,21626 86.26% Police $116,197.00 $57,158.18 $000 $59,03882 49.19% Fire Department $240,576.00 $118,23781 $15,890.23 $122,338.19 49.15% Public Works $1,197,153.00 $853,04321 $29,41251 $344,10979 7126% Parks & Recreation $60,879.00 $42,484.09 $2,466.01 $18,39491 6978% Community Center $40,261.00 $26,972.53 _ $2,86892 $13,288.47 6699% Total General Fund $2,109,246.00 $1,455,389.99 $87,711.64 $653,856.01 6900% EDA $0.00 $32500 $0.00 -$325.00 0.00% DEBT 2010 EQUIPMENT CERTIFICATES $43,010.00 $40,71000 $000 $2,300.00 94.65% 2011 EQUIPMENT CERTIFICATES $31,185.00 $592.50 $0.00 $30,592.50 1.90% 2013 EQUIPMENT CERTIFICATES $65,823.00 $60,895.00 $0.00 $4,92800 9251% 2015 EQUIPMENT CERTIFICATE $46,72000 $47,02050 $0.00 -$300.50 100.64% $186,738.00 $149,218.00 $0.00 $37,520.00 79.91% CAPITAL IMPROVEMENTS $40,000.00 $2,370.00 $0.00 $37,63000 5.93% PARK CAPITAL IMPROVEMENTS $38,50000 $0.00 $000 $38,50000 000% EQUIPMENT REPLACEMENT $315,00000 $0.00 $0.00 $315,000.00 0.00% LOCAL ROAD IMPROVEMENT FUP $1,250,000.00 $917,239.36 $2,383.50 $332,76064 73.38% 201 SEWER FUND $50,730.00 $46,735.26 $5,033.38 $3,994.74 9213% UPTOWN SEWER $16,035.00 $11,67412 $1,118.54 $4,36088 7280%. Report Total $4,006,249.00 $2,582,951.73 $96,247.06 $1,423,297.27 64.47% SCANDI:• �a 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 602201 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,79B $83,597 $3,191,766 $3,026,576 MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER OCTOBER $1,548,904 $1,483,118 $1,429,801 $1,344,311 1,776,519 $1,602,522 $1,432,269 1,367,763 $5,396 $5,070 $5,070 $5,070 5,070 $5,070 $5,070 5,070 $42,934 $57,829 $58,187 $58,187 67,914 $67,914 $67,914 67,914 $12,360 $12,360 $12,360 $12,360 12,360 $12,360 $12,360 12,360 $6,735 $6,735 $6,143 $6,143 22,510 $22,510 $22,510 22,510 $10,086 $10,086 $10,086 -$50,809 -15,828 $15,828 -$15,828 -15,828 -$2,010 -$2,010 -$2,010 $47,021 -23,643 -$23,643 423,643 -23,643 $289,270 $289,270 $287,020 $287,020 307,660 $307,660 $307,660 307,660 $15,280 $16,030 $20,230 $20,380 17,380 $17,380 $17,360 20,380 $499,258 $499,258 $499,258 $499,258 499,258 $499,258 $499,258 499,258 $395,563 $392,240 $389,808 $97,790 227,821 $144,949 $133,640 131,256 $51,642 $56,707 $52,283 $57,774 65,817 $59,736 $67,812 66,877 $1,101 -$957 $1,717 $680 2,110 $2,091 $1,295 176 $74,737 $66,746 $62,945 $60,808 61,947 $57,185 $55,225 51,026 $2,951,256 $2,892,481 $2,832,698 $2,351,951 $3,026,895 $2,759,162 $2,582,921 2,512,779