Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.b Treasurer's Report
aUg .. .` : A Beginning Balance 2/1/2018 Receipts Expenditures Payroll Adjustments: Ending Balance 2/28/2018 City of Scandia Treasurer's Report 2/28/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/2018 CD *4420 — Rate 1.00% 12 mo., 3/21/2018 CD *4421/2921— Rate 1.35% 9 mo., 9/19/2018 Total Undesignated Funds Scandia EDA *6301 Checks in Transit Total Designated Funds Total Funds Submitted by: Colleen Firkus, Treasurer $ 4,177,437.84 $ 45,264.10 $ 252,396.30 $ 28,708.36 $ (281,104.66) $ 45,642.77 $ 1,375,503.81 $ 1,113,259.51 $ 505,018.78 $ 503,776.59 $ 402,496.98 $ 9,391.89 $ 3,941,597.28 $ 3,945,698.44 $ 9,391.89 $ (13,493.05) $ 3,941,597.28 r FG1 City of Scandia S( N r 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,00000 $66,727.36 $50,457.91 $297,272.64 18.33% City Council $19,50000 $56.98 $57.00 $19,443.02 0.29% Elections $6,200.00 $830.00 $830.00 $5,370.00 1339% Planning & Building $126,300.00 $16,975.79 $15,69236 $109,324.21 1344% Police $127,200.00 $30936 $64,909.90 $126,89064 0.24% Fire Department $271,500.00 $22,996.41 $28,705.35 $248,503.59 847% Public Works $1,130,500.00 $86,163.56 $59,30610 $1,044,336.44 7.62% Parks & Recreation $69,300.00 $17,68846 $12,853.41 $51,611.54 25.52% Community Center $46,300.00 $6,85744 $6,168.44 $39,442.56 14.81% Total General Fund $2,160,800.00 $218,605.36 $238,980.47 $1,942,194.64 10.12% EDA $800.00 $000 $0.00 $800.00 0.00% DEBT 2007 ROAD PROJECT BOND $14,208.00 $000 $0.00 $14,208.00 000% 2013 EQUIPMENT CERTIFICATES $64,503.00 $0.00 $0.00 $64,50300 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,892.00 $3,235.84 $0.00 $158,656.16 2.00% CAPITAL IMPROVEMENTS $139,300.00 $33,285.00 $33,285.00 $106,01500 23.89% PARK CAPITAL IMPROVEMENTS $18,220.00 $0.00 $0.00 $18,220.00 0.00% EQUIPMENT REPLACEMENT $115,500.00 $30,301.00 $85,199.00 26.23% LOCAL ROAD IMPROVEMENT FUP $6,500,000.00 $30.00 $11,973.50 $6,499,970 00 0.00% 201 SEWER FUND $64,450.00 $7,803.11 $5,742.04 $56,646.89 12.11% UPTOWN SEWER $21,700.00 $2,455.98 $1,208.86 $19,244 02 11.32% Report Total $9,182,662.00 $295,716.29 $291,189.87 $8,886,945.71 3.22% ,tSCANDILA CASH BALANCES 2018 END OF MONTH FUND JANUARY FEBRUARY 101 GENERAL $1,723,333 $1,505,745 225 EDA $9,745 $29,745 230 RESTRICTED DONATIONS $0 $3,450 307 BLACKTOP 2007 $18,150 $18,150 313 EQUIPMENT CERTIFICATES $16,374 $16,374 315 EQUIPMENT CERTIFICATES $13,230 $13,230 317 EQUIPMENT CERTIFICATES -$4,381 -$4,381 401 CAPITAL IMPR $351,214 $317,929 404 PARK CAP IMPR $16,255 $19,805 406 EQUIPMENT REPLACEMENT $447,501 $447,501 408 LOCAL ROAD IMPROVEMENT $1,486,837 $1,474,864 602 201 SEWER $80,690 $75,782 612 UPTOWN SEWER $5,740 $5,948 801 ESCROW $12,750 $17,456 TOTAL $4,177,438 $3,941,597