Loading...
5.b Treasurer's August 2018 ReportaL;g City of Scandia Treasurer's Report 8/31/2018 Beginning Balance 8/1/2018 Receipts Expenditures Payroll Adjustments: Ending Balance 8/31/2018 Ending Balance includes the following Investments: Checking *102 Money Market *105 - Rate .25% CD *2920 — Rate 1.80% 12 mo., 1/24/2019 CD *4421/2921— Rate 1.35% 9 mo., 9/19/2018 CD *4420/4422 — Rate 1.00% 12 mo., 3/21/2019 CD *4423 - Rate 1.20% 2 mo., 9/23/2018 CD *4424 - Rate 2.40% 12 mo., 7/25/2019 Total Undesignated Funds Scandia EDA *6301 Total Designated Funds Checks in Transit Deposits in Transit Total Funds Submitted by: Colleen Firkus, Treasurer $ 7,289,980.66 $ 63,152.45 $ 1,233,894.42 $ 29,391.19 $ (1,263,285.61) $ 67,891.60 $ 3,666,518.15 $ 509,514.42 $ 402,496.98 $ 301,436.71 $ 700,000.00 $ 419,894.02 $ 25,564.07 $ 6,089,847.50 $ 6,067,751.88 $ 25,564.07 $ (3,468.45) S $ 6,089,847.50 City of Scandia SCANDIA Expenditure Summary August 2018 2018 YTD Budget % of YTD GENERAL FUND 2018 YTD Budget 2018 YTD Amount 2018 MTD Amount Balance Budget Administration & Finance $364,000.00 $242,953,65 $22,796.38 $121,046.35 66.75% City Council $19,500.00 $9,268.62 $0.00 $10,231,38 47.53% Elections $6,200.00 $2,832.73 $2,002.73 $3,367.27 45.69% Planning & Building $126,300.00 $101,699.34 $6,050.95 $24,600.66 80.52% Police $127,200.00 $71,889.96 $71,580.60 $55,310.04 56.52% Fire Department $271,500.00 $102,268.14 $16,286.50 $169,231.86 37.67% Public Works $1,130,500-00 $749,135.03 $58,071.12 $381,364.97 66.27% Parks & Recreation $69,300.00 $45,754.31 $5,834.85 $23,545,69 66.02% Community Center $48.600-00 $28,448.65 $2,143.41 $20,151,35 58.54% Total General Fund $2,163,100.00 $1,354,250.43 $184,766.54 $808,849.57 62.61% EDA $800.00 $4,181,40 $0.00 -$3,381.40 0.00% GATEWAY DONATIONS $0.00 $5,000.00 $5,000.00 -$5,000.00 0.00% CABLE TV $7,300.00 $2,018.75 $000 $5,281.25 0.00% DEBT 2007 ROAD PROJECT BOND $14,208.00 $18,149.86 $0.00 -$3,941.86 0.00% 2013 EQUIPMENT CERTIFICATES $64,503.00 $60,070.00 $0.00 $4,433.00 93.13% 2015 EQUIPMENT CERTIFICATE $45,801.00 $45,709.00 $0.00 $92.00 99.80% 2017 EQUIPMENT CERTIFICATE $36,580.00 $35,921.34 $0.00 $658.66 98.20% $161,092.00 $159,850.20 $0.00 $1,241.80 99.23% CAPITAL IMPROVEMENTS $139,300,00 $180,72000 $47,435.00 -$41,420.00 12973% ROAD CONSTRUCTION $0.00 $1,856,723 53 $953,373.37 -$1,856,723.53 #DIV/0! PARK CAPITAL IMPROVEMENTS $18,220.00 $846.94 $290.92 $17,373.06 4.65% EQUIPMENT REPLACEMENT $155,040.00 $229,837.23 $26,349.21 -$74,797.23 14824% LOCAL ROAD IMPROVEMENT FUl' $6,500,000.00 $2,150,408.13 $1,864,107.68 $4,349,591.87 33.08% 201 SEWER FUND $64,450.00 $39,975.77 $4,555.27 $24,474.23 62.03% UPTOWN SEWER $21.70000 $8,661.19 $617.05 $13,038.81 39.91% Report Total $9,231,002.00 $5,992,473.57 $3,086,495.04 $3,238,528.43 64.92% v; FA 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 JULY AUGUST $1,145,669 $1,024,689 $951,411 $895,700 $1,605,964 $1,462,641 $29,745 $25,920 $25,564 $25,564 $25,999 $25,999 $0 $0 $0 -$1,869 -$2,019 -$806 $4,100 $4,175 $4,175 $4,175 $5,175 $175 $0 $0 $0 $0 -$8 -$8 $16,374 $16,374 -$43,696 -$43,696 -$7,365 -$7,365 $13,230 $13,230 $13,230 -$31,125 -$5,236 -$5,236 -$4,381 -$4,381 -$4,381 -$4,381 -$17,802 -$17,802 $623,569 $623,569 $623,569 $623,569 $628,757 $585,922 $0 $0 $0 $3,817,306 $2,944,421 $1,991,048 $117,523 $117,823 $118,728 $118,779 $118,617 $118,326 $447,501 $441,401 $440,927 $283,854 $300,182 $273,833 $1,436,808 $1,357,919 $1,348,096 $904,974 $1,581,507 $1,543,658 $82,156 $80,280 $72,137 $81,662 $89,450 $85,114 $2,473 $1,281 $4,923 $3,150 $2,328 $6,716 $16,466 $16,796 $17,848 $24,428 $20,010 $27,631 $3,931,233 $3,719,077 $3,572,532 $6,702,091 $7,289,981 $6,089,848