Loading...
5.b Treasurer's Report Oct. 2018IP129. lMM Beginning Balance Receipts Expenditures Payroll Adjustments: City of Scandia Treasurer's Report 10/31/2018 10/1/2018 remove duplicate receipt entry $598,534.91 $39,509.94 $ 4,573,531.57 $ 99,841.82 $ (638,044.85) $ (403.44) Ending Balance 10/31/2018 $ 4,034,925.10 Ending Balance includes the following Investments: Checking *102 $ 28 143.05 Money Market *105 - Rate .25% $ 2,047,324.58 CD *2920 — Rate 1.80% 12 mo., 1/24/2019 $ 511,826.08 CD *4421/2921— Rate 1.35% 9 mo., 9/19/2018 $ - CD *4420/4422 — Rate 1.00% 12 mo., 3/21/2019 $ 302,880.30 CD *4423 - Rate 1.20% 2 mo., 9/23/2018 $ 700,000.00 CD *4424 - Rate 2.40% 12 mo., 7/25/2019 $ 422,434.09 Total Undesignated Funds Scandia EDA *6301 Checks in Transit Total Designated Funds Total Funds Submitted by: Colleen Firkus, Treasurer $ 25,564.07 $ 4,012,608.10 $ 25,564.07 $ (3,247.07) $ 4,034,925.10 City of Scandia Expenditure Summa . �,UA D rA p Summary October 2018 2018 YTD Budget % of YTD GENERAL FUND 2018 YTD Budget 2018 YTD Amount 2018 MTD Amount Balance Budget Administration & Finance $364,000.00 $300.86799 $27,851 65 $63.13201 82.66% City Council $19,500.00 $13,86994 $4,481.32 $5,630.06 71.13% Elections $6,200.00 $3,050.73 $000 $3,149.27 49.21% Planning & Building $126,300.00 $137,805.46 $21,41281 -$11,505.46 109.11% Police $127,200.00 $71,889.96 $0.00 $55,310.04 56.52% Fire Department $271,500.00 $172,924.16 $23,677.74 $98,575.84 63.69% Public Works $1,130,500.00 $844,210.55 $43,637.34 $286,289.45 74.68% Parks & Recreation $72,800.00 $54,973.29 $2,605.08 $17,826.71 75.51% Community Center $53,100.00 $35,490.62 $4,913.25 $17,609.38 66.84% Total General Fund $2,171,100.00 $1,635,082.70 $128,579.19 $536,017.30 75.31% EDA $800.00 $4,18140 $0.00 -$3,381.40 0.00% GATEWAY DONATIONS $0.00 $5,000.00 $0.00 $0.00 0.00% CABLE TV $7.30000 $2,018.75 $0.00 $5,281.25 0.00% DEBT 2007 ROAD PROJECT BOND $14,208.00 $18,149.86 $000 -$3,941.86 000% 2013 EQUIPMENT CERTIFICATES $64,503.00 $60,070.00 $000 $4,433.00 9313% 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 $259,650,00 $191,955.00 $0.00 $67,695.00 73.93% ROAD CONSTRUCTION $0.00 $3,744,837.19 $451,68563 -$3,744,837.19 #DIV/O! PARK CAPITAL IMPROVEMENTS $18,220.00 $1,318.29 $219.61 $16,901.71 7,24% EQUIPMENT REPLACEMENT $165,680.00 $229,837,23 $0.00 -$64,157.23 13872% LOCAL ROAD IMPROVEMENT FLIP $6,500,000.00 $4,113,771,74 $496,067.23 $2,386,228.26 6329% 201 SEWER FUND $64,450.00 $50,321,97 $7,085.59 $14,128.03 78.08% UPTOWN SEWER $21,700.00 $1.0.152.68 $91032 $11,547,32 46.79% Report Total $9,369,992.00 $10,148,327.15 $1,084,547.57 -$778,335.15 co m 0 A A A A A W W W W N N N T O O O O O O O O w N N O c N N m m A N V (n w J O m m z m C N r m m x n m m m m x 0 m 0 O to v O p D O D O O 0 � N m 0 z p m r- n n D v A m m z * , m y O m m m p m cZi) -Zi -Zi -zi N m0 < rQ 0 D M v C x x x of O O C7 T ?t ?t > K m Z -i --I Oz M m m m (1) Z m� zN o= O co A49969 n D EA 69 A A 69 W EA EA (A v Z 3 D V N (ten Co m v m A W O m O W C z Z A J J m co (l) N N w N W -+ J W D 0 v W A OAO NW =00 O o O O o O V) 69 T W EA m (D 69 (A A A (A (A (A EA vi N 69 J J A (A N O C J (Jt (n A J OJ J A W O m w (O N D D1 A (D J m Cn m (D w N w — A J J to Un A m O O O (n N m W J (n (n 69 A A V m m N A (n O (O O A O O O U) Un -� 69 (A (A W (A (A (A CD (A fA A A -+ O(A co fA J 69 m W A N (A (A N A T N N m J J W A W A (D (n D > N A A CO (n (n (n w N Cl) — J (7) M W D) J (n O O N 69 O m w J (A O 69 A m w W w m m w O (D -+ O A O O O (n O 2 :A (A (A P (A 69 69 (A (A co A � 0)69 (A (A O C. Cn(D m O J A J W A w D) A Dn A O V N N (D A m (n W N w �(D D) V (D m CO O N (A D) m W J fA J EA N m V m O m Cl) O (D O A O U) O O (D r 6A fA w 69 (A (A (A V (A -4 A A N A (A N CA N J A N 0o O -co W A W w A N (n m (D O co J (n W N (3) N A N co W v m J coo O (D co m O (Jn O A FA (A (A (A (A (.J (A V (A 69 w N m m (n M O N (A m O m N (A A (A 69 N (D L N A W A W m J w A Cl) A (n N C O A -� m 07 m J w (n W -� D) -+ m M J (D N(!t 0) V (J) V O m m N (D (A J O) D) O z m O N A A (D D) co N D) O V) (D A O m (A (A (A (A N (A (A m W w m 4 (A m 00 N (A m m O A N(A (A 69 69 N O (D O N (D O m A N J (n J c n N Un Cn L fD O W A (J) -+ O A V m N W O V7 O C 00 C, N N O m N N O co O) J (D m r O 0o O J N J -+ J N D) U) m U) (D O A P (A 69 (A 69 (A — (A D 69 00 N (A m A J -+ (OD 0�0 (A H) N m C fD J m Un W W m (n V (n J (n N G) 00 D)J_ �_ m m W O (D m N W m (D m C Cn 00 W m A coo W m co N N m (mn Deo N 60) (D A 1 N A' (A 69 (A (A -I V W 690J sin N) � N cn (n EA Hi N O m W m w N m m A O J (n J E9 69 N N com J (D O d) m m N w V J 7 W OD 0a) O (n O W cn J N J W (n (D (D W M A — — 0 W N (D a) v --� O 0mo w 0 A (D (Jt (Jt m d) V N O V (n �I N (Nn CND W tD (n N W A (D m co m m N co J (D A m N A N m O m (n w m O W D) J (D N N m (n (n m W (n A V N Q1 ut W (n m (D