Loading...
5.b Treasurer's Report March 2018al:g r� SCAN DIA Beginning Balance 3/1/2018 Receipts Expenditures Payroll Adjustments: City of Scandia Treasurer's Report 3/31/2018 $ 93,885.42 $ 26,081.11 $ 3,941,597.28 $ 109,602.21 $ (119,966.53) Ending Balance 3/31/2018 $ 3,931,232.96 Ending Balance includes the following Investments: Checking *102 $ 11,941.29 Money Market *105 - Rate .25% $ 1,569,768.32 CD *3138 — Rate 1.20% 18 mo., 7/24/2018 $ 1,113,259.51 CD *2920 — Rate 1.00% 12 mo., 1/24/2018 $ 505,018.78 CD *4422 — Rate 1.90% 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 $ 3,902,484.88 Scandia EDA *6301 $ 29,391.89 Total Designated Funds $ 29,391.89 Checks in Transit $ (643.81) Deposits in Transit S Total Funds $ 3,931,232.96 Submitted by: Colleen Firkus, Treasurer tm City of Scandia SC ANDIA Expenditure Summary February 2018 2018 YTD Budget % of YTD GENERAL FUND 2018 YTD Budget 2018 YTD Amount 2018 MTD Amount Balance Budget Administration & Finance $364,000.00 $90,843.87 $24,116.51 $273,156.13 24.96% City Council $19,500.00 $285.98 $229.00 $19,214.02 1.47% Elections $6,200.00 $830.00 $0.00 $5,370.00 13.39% Planning & Building $126,300.00 $24,141.62 $7,165.83 $102,158.38 19.11% Police $127,200.00 $309.36 $0.00 $126,890.64 0.24% Fire Department $271,500.00 $29,74924 $6,752.83 $241,750.76 10.96% Public Works $1,130,500.00 $514,767.51 $428,603.95 $615,732,49 45.53% Parks & Recreation $69,300.00 $21,687.81 $3,999.35 $47,612.19 31.30% Community Center $46,300.00 $9,639.75 $2,782.31 $36.660.25 20.92% Total General Fund $2,160,800.00 $692,255.14 $473,649.78 $1,468,544.86 32.04% EDA $800.00 $0.00 $000 $80000 000% DEBT 2007 ROAD PROJECT BOND $14,208.00 $18,149.86 $18,149.86 -$3,941.86 0.00% 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,681.34 57.00 $34,698.66 5.14% $161,892.00 $21,385.70 $18,149.86 $140,506.30 13.21% CAPITAL IMPROVEMENTS $139,300.00 $133,28500 $100,00000 $6,015.00 95.68% PARK CAPITAL IMPROVEMENTS $18,220.00 $0.00 $000 $18,220.00 0.00% EQUIPMENT REPLACEMENT $115,500.00 $30,301.00 $85,19900 26.23% LOCAL ROAD IMPROVEMENT FUP $6,500,000.00 $36,37750 $36,347.50 $6,463,622.50 0.56% 201 SEWER FUND $64,450.00 $11,281.74 $3,478.63 $53,168.26 17.50% UPTOWN SEWER $21,700.00 $3,291 55 $83557 $18,408.45 1517% Report Total $9,181,862.00 $928,177.63 $632,461.34 $8,254,484.37 10.11% SCANDIA CASH BALANCES 2018 END OF MONTH FUND JANUARY FEBRUARY MARCH 101 GENERAL $1,723,333 $1,505,745 $1,145,669 225 EDA $9,745 $29,745 $29,745 230 RESTRICTED DONATIONS $0 $3,450 $4,100 307 BLACKTOP 2007 $18,150 $18,150 $0 313 EQUIPMENT CERTIFICATES $16,374 $16,374 $16,374 315 EQUIPMENT CERTIFICATES $13,230 $13,230 $13,230 317 EQUIPMENT CERTIFICATES -$4,381 -$4,381 -$4,381 401 CAPITAL IMPR $351,214 $317,929 $623,569 404 PARK CAP IMPR $16,255 $19,805 $117,523 406 EQUIPMENT REPLACEMENT $447,501 $447,501 $447,501 408 LOCAL ROAD IMPROVEMENT $1,486,837 $1,474,864 $1,436,808 602 201 SEWER $80,690 $75,782 $82,156 612 UPTOWN SEWER $5,740 $5,948 $2,473 801 ESCROW $12,750 $17,456 $16,466 TOTAL $4,177,438 $3,941,597 $3,931,233