Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
6.b Treasurer's Report
aUg., �- t4 k7i,. SCANDIIA Beginning Balance 3/1/2017 Receipts Expenditures Payroll Adjustments: Ending Balance 3/31/2017 City of Scandia Treasurer's Report 3/31/2017 Ending Balance includes the following Investments: Checking *102 Money Market *105 - Rate .25% CD *3138 — Rate 1.20% 18 mo., 7/24/2018 CD *3139 — Rate .70% 6 mo., 7/24/2017 CD *2920 — Rate 1.00% 12 mo., 1/24/2018 CD *4420 — Rate 1.00% 12 mo., 3/21/2018 Total Undesignated Funds Scandia EDA *6301 $ 64,740.86 $ 23,357.43 $ 89,538.81 $ 411,635.18 $ 1,100,000.00 $ 400,000.00 $ 500,000.00 $ 500,000.00 $ 5,070.47 $ 3,059,860.29 $ 21,450.86 $ 2,993,212.86 $ 3,001,173.99 Total Designated Funds $ 5,070.47 Checks in Transit $ (13,031.60) Deposits in Transit S Total Funds $ 2,993,212.86 Submitted by: Colleen Firkus, Treasurer d, F SCANDIA City of Scandia Expenditure Summary March 2017 2017 YTD Budget % of YTD GENERAL FUND 2017 YTD Budget 2017 YTD Amount 2017 MTD Amount Balance Budget Administration & Finance $342,600.00 $71,27873 $21,66443 $271,321.27 20.81% City Council $18,90000 $1,36527 -$3,644.79 $17,53473 7.22% Elections $1,300.00 $830.00 $830.00 $47000 63.85% Planning & Building $149,000.00 $20,392.14 $14,071.64 $128,607.86 13.69% Police $120,500.00 $30936 $0.00 $120,19064 026% Fire Department $244,49000 $38,92405 -$11.24 $205,56595 1592% Public Works $1,371,800.00 $631,77227 $546,422.98 $740,027.73 46.05% Parks & Recreation $60,90000 $16,947.72 $1,646.11 $43,952.28 2783% Community Center $40,20000 $7,710.78 $2,721 86 $32,489.22 19.18% Total General Fund $2,349,690.00 $789,530.32 $583,700.99 $1,560,159.68 33.60% PUBLIC HOUSING $0.00 $0.00 000% EDA $0.00 $000 0.00% DEBT 2007 ROAD PROJECT BOND $77,000.00 $79,31756 $2,317.56 -$2,317.56 000% 2010 EQUIPMENT CERTIFICATES $10,060.00 $10,17713 $11739 -$11713 10116% 2011 EQUIPMENT CERTIFICATES $8,29400 $8,311.93 $2793 -$17.93 10022% 2013 EQUIPMENT CERTIFICATES $65,06300 $43500 $0.00 $64,628.00 0.67% 2015 EQUIPMENT CERTIFICATE $46,364.00 $1,709.25 $000 $44,654.75 369% $206,781.00 $99,950.87 $2,462.88 $106,830.13 48.34% CAPITAL IMPROVEMENTS $266,700.00 $000 $000 $266,700.00 0.00% PARK CAPITAL IMPROVEMENTS $44,900.00 $0.00 $0.00 $44,90000 0.00% EQUIPMENT REPLACEMENT $438,000.00 $0.00 $0.00 $438,000.00 000% LOCAL ROAD IMPROVEMENT FUP $50,000.00 $0.00 $000 $50,00000 000% 201 SEWER FUND $62,000.00 $9,192.62 $3,59460 $52,80738 14.83% UPTOWN SEWER $15,40D.00 $2,708.84 $981.43 $12,691.16 17.59% Report Total $3,433,471.00 $901,382.65 $590,739.90 $2,532,088.35 26.25% SC1i111 D A CASH BALANCES 2017 END OF MONTH FUND JANUARY FEBRUARY MARCH 101 GENERAL $1,797,435 $1,628,261 $1,036,162 213 PUBIC HOUSING $0 $0 $0 225 EDA $5,070 $5,091 $5,091 307 BLACKTOP 2007 $79,092 $2,318 $0 311 EQUIPMENT CERTIFICATES $10,060 $117 $0 312 EQUIPMENT CERTIFICATES $8,284 $28 $0 313 EQUIPMENT CERTIFICATES $13,296 $13,341 $13,341 315 EQUIPMENT CERTIFICATES $326 $331 $10,507 401 CAPITAL IMPR $322,660 $326,803 $326,803 404 PARK CAP IMPR $20,380 $17,441 $17,441 406 EQUIPMENT REPLACEMENT $499,258 $501,061 $509,373 408 LOCAL ROAD IMPROVEMENT $373,833 $469,363 $976,537 602 201 SEWER $70,915 $67,025 $74,466 612 UPTOWN SEWER $5,226 $4,602 $3,530 801 ESCROW $35,342 $24,079 $19,963 TOTAL $3,241,177 $3,059,861 $2,993,213