Loading...
5.b May Treasurer's ReportBeginning Balance 5/1/2017 Receipts Expenditures Payroll Adjustments: Ending Balance 5/31/2017 City of Scandia Treasurer's Report 5/31/2017 Ending Balance includes the following Investments: Checking *102 Money Market *105 - Rate .25% CD *3138 — Rate 1.20% 18 mo., 7/24/2018 CD *3136 — Rate .70% 6 mo., 7/24/2017 CD *2920 — Rate 1.00% 12 mo., 1/24/2018 CD *4420 — Rate 1.00% 12 mo., 3/21/2018 Total Undesignated Funds Scandia EDA *6301 Total Designated Funds Checks in Transit Deposits in Transit Total Funds Submitted by: Colleen Firkus, Treasurer $ 2,955,532.92 $38,837.09 $ 167,107.66 $ 32,914.26 $ (200,021.92) $ 2,794,348.09 $ 12,210.75 $ 276,326.13 $ 1,103,254.79 $ 400,000.00 $ 501,232.88 $ 500,000.00 $ 2,793,024.55 $ 4,754.47 $ 4,745.47 $ (3,421.93) S $ 2,794,348.09 City of Scandia Expenditure Summary May 2017 2017 YTD Budget % of YTD GENERAL FUND 2017 YTD Budget 2017 YTD Amount 2017 MTD Amount Balance Budget Administration & Finance $342,600.00 $149,153.84 $49,242.98 $193,446.16 43.54% City Council $18,90000 $5,846.59 $000 $13,053.41 30.93% Elections $1,30000 $83000 $0.00 $470.00 63.85% Planning & Building $149,000.00 $54,303.24 $15 711 79 $94,69676 3645% Police $120,500.00 $309.36 $0.00 $120,190.64 026% Fire Department $244,490.00 $61,317.23 $9,890.09 $183,172.77 25.08% Public Works $1,371,800.00 $703,720.99 $42,273.38 $668,079.01 51.30% Parks & Recreation $60,900.00 $26,062.49 $5,817.74 $34,837.51 42.80% Community Center $40,20000 $13,712.74 $3,49501 $26,48726 34.11% Total General Fund $2,349,690.00 $1,015,256.48 $126,430.99 $1,334,433.52 43.21% PUBLIC HOUSING $000 $0.00 0.00% EDA $000 $32500 $0.00 -$325.00 0.00% - DEBT 2007 ROAD PROJECT BOND $77,000.00 $79,317.56 $0.00 -$2,317.56 0.00% 2010 EQUIPMENT CERTIFICATES $10,060.00 $10,177.13 $0.00 -$117.13 101.16% 2011 EQUIPMENT CERTIFICATES $8,29400 $8,311.93 $0.00 -$17.93 100.22% 2013 EQUIPMENT CERTIFICATES $65,063.00 $60,917.50 $60,482.50 $4,145.50 93.63% 2015 EQUIPMENT CERTIFICATE $46,36400 $1,709.25 $0.00 $44,654.75 369% $206,781.00 $160,433.37 $60,482.50 $46,347.63 77.59% CAPITAL IMPROVEMENTS $266,700.00 $0.00 $0.00 $266,70000 0.00% PARK CAPITAL IMPROVEMENTS $44,900.00 $0.00 $000 $44,900.00 0.00% EQUIPMENT REPLACEMENT $438,000.00 $000 $0.00 $438,000.00 0.00% LOCAL ROAD IMPROVEMENT FUP $50,000.00 $0.00 $0.00 $50,000.00 0.00% 201 SEWER FUND $62,00000 $22,088.50 $8,895 19 $39,911.50 35.63% UPTOWN SEWER $15,40000 $4,901.22 $1,023.52 $10,498.78 31.83% Report Total $3,433,471.00 $1,203,004.57 $196,832.20 $2,230,466.43 35.04% CASH BALANCES 2017 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL MAY 101 GENERAL $1,797,435 $1,628,261 $1,036,162 $994,496 $893,533 213 PUBIC HOUSING $0 $0 $0 $0 $0 225 EDA $5,070 $5,091 $5,091 $4,766 $4,766 307 BLACKTOP 2007 $79,092 $2,318 $0 $0 $0 311 EQUIPMENT CERTIFICATES $10,060 $117 $0 $0 $0 312 EQUIPMENT CERTIFICATES $8,284 $28 $0 $0 $0 313 EQUIPMENT CERTIFICATES $13,296 $13,341 $13,341 $13,341 -$47,142 315 EQUIPMENT CERTIFICATES $326 $331 $10,507 $10,507 $10,507 401 CAPITAL IMPR $322,660 $326,803 $326,803 $326,803 $326,803 404 PARK CAP IMPR $20,380 $17,441 $17,441 $18,641 $19,391 406 EQUIPMENT REPLACEMENT $499,258 $501,061 $509,373 $509,373 $509,373 408 LOCAL ROAD IMPROVEMENT $373,833 $469,363 $976,537 $976,537 $976,537 602 201 SEWER $70,915 $67,025 $74,466 $76,884 $76,668 612 UPTOWN SEWER $5,226 $4,602 $3,530 $4,952 $5,477 801 ESCROW $35,342 $24,079 $19,963 $19,233 $18,435 TOTAL $3,241,177 $3,059,861 $2,993,213 $2,955,533 $2,794,348