Loading...
5.b Treasurer's June 2018 Reportiial SCAN DIA Beginning Balance 6/1/2018 Receipts Expenditures Payroll Adjustments: Ending Balance 6/30/2018 City of Scandia Treasurer's Report 6/30/2018 Ending Balance includes the following Investments: Checking *102 Money Market *105 - Rate .25% CD *3138 — Rate 1.20% 18 mo., 7/24/2018 CD *2920 — Rate 1.00% 12 mo., 1/24/2019 CD *4420/4422 — Rate 1.00% 12 mo., 3/21/2019 CD *4421/2921— Rate 1.35% 9 mo., 9/19/2018 Total Undesignated Funds Scandia EDA *6301 Total Designated Funds Checks in Transit Deposits in Transit Total Funds $ 669,485.43 $ 23,088.20 $ 116,472.81 $ 4,340,594.87 $ 1,116,553.54 $ 507,238.10 $ 301,436.71 $ 402,496.98 $ 25,564.07 $ 3,572,532.09 $ 3,822,132.61 $ (692,573.63) $ 6,702,091.07 $ 6,784,793.01 $ 25,564.07 $ (108,266.01) S $ 6,702,091.07 t M City of Scandia SCADIA Expenditure Summary June 2018 LOCAL ROAD IMPROVEMENT FUl' $6,500,000.00 201 SEWER FUND $64,450.00 $568,211.39 $33,848.58 $365,322.04 $5,931,788.61 8.74% $2,253.16 $30,601.42 52.52% UPTOWN SEWER $21,70000 $7,222.38 $1,888.69 $14,477.62 33.28% Report Total $9,220,852.00 2018 YTD Budget % of YTD GENERAL FUND 2018 YTD Budget 2018 YTD Amount 2018 MTD Amount Balance Budget Administration & Finance $360,000.00 $196,160.96 $23,573.17 $163,839.04 54.49% City Council $19,500.00 $4,787.30 $20.00 $14,712.70 24.55% Elections $6,200.00 $830.00 $0.00 $5,370.00 13.39% Planning & Building $126,300.00 $78,120.45 $14,668.86 $48,179.55 61.85% Police $127,200.00 $309.36 $0.00 $126,890.64 0.24% Fire Department $271,500.00 $71,365.11 $16,066.96 $200,134.89 26.29% Public Works $1,130,500.00 $634,646.89 $41,427.40 $495,853.11 56.14% Parks & Recreation $72,800.00 $35,934.15 $4,308.17 $36,865.85 49.36% Community Center $48,600,00 $23,926.11 $5,348.61 $24,673.89 49.23% Total General Fund $2,162,600.00 $1,046,080.33 $105,413.17 $1,116,519.67 48.37% EDA $800.00 $4,181.40 $356.40 -$3,381.40 0.00% CABLE TV $7,300.00 $1,868.75 $1,868.75 $5,43125 0.00% DEBT 2007 ROAD PROJECT BOND $14,208.00 $18,14986 $0.00 -$3,941.86 0.00% 2013 EQUIPMENT CERTIFICATES $64,503.00 $60,07000 $0.00 $4,433.00 9313% 2015 EQUIPMENT CERTIFICATE $45,801.00 $45,70900 $44,354.50 $92.00 99.80% 2017 EQUIPMENT CERTIFICATE $36,580.00 $1,881.34 $0.00 $34,698.66 5.14% $161,092.00 $125,810.20 $44,354.50 $35,281.80 78.10% CAPITAL IMPROVEMENTS $159,650.00 $133,285.00 $0.00 $26,365.00 83.49% ROAD CONSTRUCTION $0.00 $30,465.00 $30,465.00 -$30,465.00 #DIV/0! PARK CAPITAL IMPROVEMENTS $18,220.00 $39421 $249.33 $17,825.79 2.16% EQUIPMENT REPLACEMENT $125,040.00 $203,488.02 $166,613.15 -$78,448.02 162.74% LOCAL ROAD IMPROVEMENT FUl' $6,500,000.00 201 SEWER FUND $64,450.00 $568,211.39 $33,848.58 $365,322.04 $5,931,788.61 8.74% $2,253.16 $30,601.42 52.52% UPTOWN SEWER $21,70000 $7,222.38 $1,888.69 $14,477.62 33.28% Report Total $9,220,852.00 $2,154,855.26 $718,784.19 $7,065,996.74 23.37% . IA SCANDIA 2018 FUND 101 GENERAL 225 EDA 226 CABLE TV 230 RESTRICTED DONATIONS 307 BLACKTOP 2007 313 EQUIPMENT CERTIFICATES 315 EQUIPMENT CERTIFICATES 317 EQUIPMENT CERTIFICATES 401 CAPITAL IMPR 402 ROAD CONSTRUCTION 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,723,333 $1,505,745 $9,745 $29,745 $0 $0 $0 $3,450 $18,150 $18,150 $16,374 $16,374 $13,230 $13,230 -$4,381 -$4,381 $351,214 $317,929 $0 $0 $16,255 $19,805 $447,501 $447,501 $1,486,837 $1,474,864 $80,690 $75,782 $5,740 $5,948 $12,750 $17,456 $4,177,438 $3,941,597 MARCH APRIL MAY JUNE $1,145,669 $1,024,689 $951,411 $895,700 $29,745 $25,920 $25,564 $25,564 $0 $0 $0 -$1,869 $4,100 $4,175 $4,175 $4,175 $0 $0 $0 $0 $16,374 $16,374 -$43,696 -$43,696 $13,230 $13,230 $13,230 -$31,125 -$4,381 -$4,381 -$4,381 -$4,381 $623,569 $623,569 $623,569 $623,569 $0 $0 $0 $3,817,306 $117,523 $117,823 $118,728 $118,779 $447,501 $441,401 $440,927 $283,854 $1,436,808 $1,357,919 $1,348,096 $904,974 $82,156 $80,280 $72,137 $81,662 $2,473 $1,281 $4,923 $3,150 $16,466 $16,796 $17,848 $24,428 $3,931,233 $3,719,077 $3,572,532 $6,702,091