Loading...
5.b Treasurer's Report,PGN-, SCALY DIA Beginning Balance 5/1/2018 Receipts Expenditures Payroll Adjustments: Ending Balance 5/31/2018 City of Scandia Treasurer's Report 5/31/2018 Ending Balance includes the following Investments: $ 240,121.77 $ 32,978.67 Checking *102 $ 22,809.56 Money Market *105 - Rate .25% $ 1,217,187.84 CD *3138 — Rate 1.20% 18 mo., 7/24/2018 $ 1,116,553.54 CD *2920 — Rate 1.00% 12 mo., 1/24/2019 $ 507,238.10 CD *4420/4422 — Rate 1.00% 12 mo., 3/21/2019 $ 300,000.00 CD *4421/2921— Rate 1.35% 9 mo., 9/19/2018 $ 402,496.98 Total Undesignated Funds Scandia EDA *6301 $ 25,564.07 Checks in Transit Deposits in Transit Total Designated Funds Total Funds Submitted by: Colleen Firkus, Treasurer $ 3,719,076.69 $126,555.84 $ (273,100.44) $ 3,572,532.09 $ 3,566,286.02 $ 25,564.07 $ (19,318.00) S $ 3,572,532.09 City of Scandia SCAN DIA Expenditure Summary May 2018 2018 YTD Budget % of YTD GENERAL FUND 2018 YTD Budget 2018 YTD Amount 2018 MTD Amount Balance Budget Administration & Finance $364,000.00 $172,587.79 $50,707.95 $191,412.21 47.41% City Council $19,500.00 $4,767.30 $0.00 $14,732.70 24.45% Elections $6,200.00 $830.00 $0.00 $5,370.00 13.39% Planning & Building $126,300.00 $63,451.59 $10,519.23 $62,848,41 50.24% Police $127,200.00 $309.36 $0.00 $126,890.64 0.24% Fire Department $271,500.00 $55,298.15 $9,044,72 $216,201.85 20.37% Public Works $1,130,500.00 $593,219.49 $33,326.81 $537,280.51 52.47% Parks & Recreation $69,300.00 $31,625.98 $5,57009 $37,674.02 45.64% Community Center $46.,300.00 516,577.50 $2,835.64 $27,722.50 40.12% Total General Fund $2,160,800.00 $940,667.16 $112,004.44 $1,220,132.84 43.53% EDA $800.00 $4,181 40 $356.40 -$3,381 40 000% CABLE TV $7,300.00 $000 $0.00 $7,300.00 000% DEBT 2007 ROAD PROJECT BOND $14,208,00 $18,149.86 $0.00 -$3,941.86 000% 2013 EQUIPMENT CERTIFICATES $64,503.00 $60,070.00 $60,070.00 $4,433.00 93.13% 2015 EQUIPMENT CERTIFICATE $45,801.00 $1,35450 $000 $44,446.50 2.96% 2017 EQUIPMENT CERTIFICATE $36,580.00 $1,881.34 $000 $34,698.66 5.14% $161,092.00 $81,455.70 $60,070.00 $79,636.30 50.56% CAPITAL IMPROVEMENTS $139,300.00 $133,285.00 $0.00 $6,015.00 95.68% PARK CAPITAL IMPROVEMENTS $18,220.00 $14488 $144.88 $18,075.12 0.80% EQUIPMENT REPLACEMENT $115,500.00 $36,874.87 $473.87 $78,625.13 31.93% LOCAL ROAD IMPROVEMENT FUl` $6,500,000.00 $202,889.35 $87,622.50 $6,297,110.65 3.12% 201 SEWER FUND $64,450.00 $31,595,42 $11,047.78 $32,854.58 49.02% UPTOWN SEWER $21,700.00 $5.333.69 $850.58 $16,366.31 24.58% Report Total $9,189,162.00 $1,436,427.47 $272,570.45 $7,752,734.53 15.63%