Loading...
5.b Treasurer's ReportaL:g . ANDILA� Beginning Balance 4/1/2018 Receipts Expenditures Payroll Adjustments: City of Scandia Treasurer's Report 4/30/2018 $ 207,169.69 $ 30,022.80 $ 3,931,232.96 $ 25,036.22 $ (237,192.49) Ending Balance 4/30/2018 $ 3,719,076.69 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/2018 CD *4421/2921— Rate 1.35% 9 mo., 9/19/2018 CD *4422 — Rate 1.90% 9 mo., 3/21/2019 Total Undesignated Funds $ 43,438.70 $ 1,333,258.32 $ 1,116,553.54 $ 507,238.10 $ 402,496.98 $ 300,000.00 $ 3,702,985.64 Scandia EDA *6301 $ 29,391.89 Receipts $ 353.58 Expenditures $ (3,825.00) Total Designated Funds $ 25,920.47 Checks in Transit Total Funds Submitted by: Colleen Firkus, Treasurer $ (9,829.42) $ 3,719,076.69 1914 City of Scandia ►7CA DIA Expenditure Summary April 2018 2018 YTD Budget % of YTD GENERAL FUND 2018 YTD Budget 2018 YTD Amount 2018 MTD Amount Balance Budget Administration & Finance $364,000.00 $121,879.84 $31,035.97 $242,120.16 33.48% City Council $19,500.00 $4,767.30 $4,481.32 $14,732.70 24.45% Elections $6,200.00 $830.00 $0.00 $5,370.00 13.39% Planning & Building $126,300.00 $52,932.36 $28,790.74 $73,367.64 41.91% Police $127,200.00 $309.36 $0.00 $126,890.64 0.24% Fire Department $271,500.00 $46,253.43 $16,504.19 $225,246.57 17.04% Public Works $1,130,500.00 $559,892.68 $45,125.17 $570,607.32 49.53% Parks & Recreation $69,300.00 $26,055.89 $4,368.08 $43,244.11 37.60% Community Center $46,300.00 $15,741.86 $6,102.11 $30,558.14 34.00% Total General Fund $2,160,800.00 $828,662.72 $136,407.58 $1,332,137.28 38.35% EDA $800.00 $3,82500 $3,825.00 -$3,025.00 0.00% DEBT 2007 ROAD PROJECT BOND $14,208.00 $18,149.86 $000 -$3,941.86 000% 2013 EQUIPMENT CERTIFICATES $64,503.00 $0.00 $0,00 $64,503.00 0.00% 2015 EQUIPMENT CERTIFICATE $45,801.00 $1,354.50 $0.00 $44,446.50 2.96% 2017 EQUIPMENT CERTIFICATE $36,580.00 $1,881.34 $0.00 $34,698.66 5.14% $161,092.00 $21,385.70 $0.00 $139,706.30 13.28% CAPITAL IMPROVEMENTS $139,300.00 $133,285.00 $0.00 $6,015.00 95.68% PARK CAPITAL IMPROVEMENTS $18,22000 $0.00 $0.00 $18,22000 000% EQUIPMENT REPLACEMENT $115,50000 $36,401.00 $6,100.00 $79,09900 31.52% LOCAL ROAD IMPROVEMENT FUP $6,500,000.00 $115,266.85 $78,889.35 $6,384,733.15 1.77% 201 SEWER FUND $64,45000 $20,547.64 $9,265.90 $43,902.36 31.88% UPTOWN SEWER $21,700.00 $4,483.11 $1,191.56 $17,216.89 20.66% Report Total $9,181,862.00 $1,163,857.02 $235,679.39 $8,018,004.98 12.68% CASH BALANCES 2018 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL 101 GENERAL $1,723,333 $1,505,745 $1,145,669 $1,024,689 225 EDA $9,745 $29,745 $29,745 $25,920 230 RESTRICTED DONATIONS $0 $3,450 $4,100 $4,175 307 BLACKTOP 2007 $18,150 $18,150 $0 $0 313 EQUIPMENT CERTIFICATES $16,374 $16,374 $16,374 $16,374 315 EQUIPMENT CERTIFICATES $13,230 $13,230 $13,230 $13,230 317 EQUIPMENT CERTIFICATES -$4,381 -$4,381 -$4,381 -$4,381 401 CAPITAL IMPR $351,214 $317,929 $623,569 $623,569 404 PARK CAP IMPR $16,255 $19,805 $117,523 $117,823 406 EQUIPMENT REPLACEMENT $447,501 $447,501 $447,501 $441,401 408 LOCAL ROAD IMPROVEMENT $1,486,837 $1,474,864 $1,436,808 $1,357,919 602 201 SEWER $80,690 $75,782 $82,156 $80,280 612 UPTOWN SEWER $5,740 $5,948 $2,473 $1,281 801 ESCROW $12,750 $17,456 $16,466 $16,796 TOTAL $4,177,438 $3,941,597 $3,931,233 $3,719,077