Loading...
5.b Treasurer's May 2019 Report■ , A Beginning Balance 5/1/2019 Receipts Expenditures Payroll City of Scandia Treasurer's Report 5/31/2019 Adjustments: Correct Midco receipt 5/10/19 Ending Balance 5/31/2019 Ending Balance includes the following Investments: Checking *102 Money Market *105 - Rate 1.25% CD *2920/4426 - Rate 2.50% 12 mo., 1/29/2020 CD *4422 - Rate 1.90% 12 mo., 3/21/2019 CD *4424 - Rate 2.40% 12 mo., 7/25/20198 CD *4425 - Rate 2.50% 12 mo., 9/28/2019 Total Undesignated Funds Checks in Transit *3102 Transfer EDA cash to separate account Deposit in transit Scandia EDA *6301 Receipts Expenditures Checks in Transit Total Designated Funds Total Funds Submitted by: Colleen Firkus, Treasurer $ 4,026,129.37 $80,577.62 $ 311,777.94 $ 27,092.74 $ (338,870.68) $ 0.20 $ 3,767,836.51 $ 26,025.84 $ 1,783,762.24 $ 517,317.64 $ 305,740.74 $ 427,504.54 $ 708,704.97 $ 3,769,055.97 $ 20,793.34 $ (2,645.96) $ (21,313.34) $ 1,946.50 $ 20,793.34 $ 3,767,836.51 City of Scandia W +> Expenditure Summary SCANDIA May -19 2019 YTD Budget % of YTD GENERAL FUND 2019 YTD Budget 2019 YTD Amount 2019 MTD Amount Balance Budget Administration & Finance— $791,862.00 $149,834.91 $44,05874 $642,027.09 18.92% City Council $31,00000 $14,69507 $4,500.00 $16,304.93 47.40% Elections $2,200.00 $830.00 $0.00 $1,37000 3773% Planning & Building $119,20000 $36,15558 $7,215.03 $83,04442 3033% Police $136,000.00 $309.36 $0.00 $135,690.64 0.23% Fire Department $262,400.00 $98,50879 $14,007.05 $163,891 21 3754% Public Works $661,000.00 $231,95822 $36,587.99 $429,041.78 35.09% Parks & Recreation $85,10000 $30,83926 $4,051.96 $54,26074 3624% Community Center $49,80000 $17,67569 $2,10275 $32.12431 35.49% Total General Fund $2,138,562.00 $580,806.88 $112,523.52 $1,557,755.12 27.16% EDA $800.00 $520.00 $000 $280.00 0.00% CABLE TV $17,500.00 $1,559.76 $1,55976 $15,94024 GATEWAY DONATIONS $000 $0.00 $0.00 $000 0.00% DEBT 2007 ROAD PROJECT BOND $000 $0.00 $0.00 $0.00 000% 2013 EQUIPMENT CERTIFICATI $62,91800 $59,492.50 $59,492.50 $3,425.50 94.56% 2015 EQUIPMENT CERTIFICATI $44,941 00 $0.00 $000 $44,941.00 0.00% 2017 EQUIPMENT CERTIFICATI $35,63600 $1,66400 $0.00 $33,972.00 467% 2018 BLACKTOP $329,638.00 $116,320.00 $116,320.00 $213,31800 35.29% $473,133.00 $177,476.50 $175,812.50 $295,656.50 37.51% CAPITAL IMPROVEMENTS $224,20000 $80,09311 $34,002.24 $144,106.89 3572% ROAD CONSTRUCTION $0.00 $000 $0.00 $0.00 #DIV/0! PARK CAPITAL IMPROVEMENT $207,239.00 $100,25678 $13937 $106,98222 48.38% EQUIPMENT REPLACEMENT $73,000.00 $0.00 $000 $73,000.00 0.00% LOCAL ROAD IMPROVEMENT F $66,000.00 $4,416.00 $86450 $61,58400 6.69% 201 SEWER FUND $137,52500 $34,063 14 $7,22243 $103,461.86 2477% UPTOWN SEWER $21,39700 $5,511 20 $1,600.15 $15,88580 2576% Report Total $3,359,356.00 $984,703.37 $333,724.47 $2,374,652.63 *"Note Administration Budget increased by approved transfer of $438,962, but transfer will be in June report. SCANDIA CASH BALANCES 2019 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL MAY 101 GENERAL $1,620,605 $1,452,297 $1,355,921 $1,260,238 $1,216,414 225 EDA $14,839 $21,313 $21,313 $20,793 $20,793 226 CABLE TV $6,302 $6,666 $8,167 $9,655 $9,588 230 RESTRICTED DONATIONS $175 $175 $175 $175 $175 307 BLACKTOP 2007 $164 $164 $172 $172 $172 313 EQUIPMENT CERTIFICATES $19,059 $19,059 $19,059 $19,059 -$40,434 315 EQUIPMENT CERTIFICATES $15,495 $15,495 $15,495 $15,495 $15,495 317 EQUIPMENT CERTIFICATES -$2,201 -$2,201 -$2,201 -$2,201 -$2,201 318 BLACKTOP PROJECT -$116,320 401 CAPITAL IMPR $581,181 $568,810 $575,410 $676,096 $642,094 402 ROAD CONSTRUCTION $0 $0 $0 $0 $0 404 PARK CAP IMPR $118,585 $251,594 $251,564 $153,492 $153,803 406 EQUIPMENT REPLACEMENT $275,777 $276,977 $276,977 $276,977 $276,977 408 LOCAL ROAD IMPROVEMENT $1,449,555 $1,447,207 $1,444,363 $1,443,648 $1,442,783 602 201 SEWER $108,142 $104,598 $115,480 $104,513 $97,954 612 UPTOWN SEWER $8,131 $12,893 $12,281 $8,567 $11,598 801 ESCROW $31,058 $59,389 $61,170 $60,244 $59,738 TOTAL $4,246,868 $4,234,437 $4,155,346 $4,046,923 $3,788,630