Loading...
HomeMy WebLinkAbout04-24-2018 Council Handouts City of Oak Park Heights Bills Presented for Payment April 21, 2018 Payroll Gross Payroll with PERA, FICA, and Medicare City Administration: 4-30-18 11,205.28 Finance: Full-Time 4-30-18 8,373.76 Police Department: Full-Time 4-30-18 47,772.85 Building Inspection Department: 4-30-18 4,131.80 Public Works-Street Maint. Department: Full-Time 4-30-18 1,206.64 Park and Recreation Department: Full-Time 4-30-18 1,338.34 UTILITY FUNDS Water Department Full-Time 4-30-18 8,713.97 Sewer Department Full-Time 4-30-18 5,697.37 Storm Sewer Full-Time 4-30-18 1,049.72 Total Utility Funds 15,461.06 Total Payroll $ 89,489.73 - > / CL CL $ \ f k > 04 ) / \ } \ / § } / / ® oct °\ E e S 2 / § cc� r r CNI \ \ \ \ \ \ \ / \ E § § � I § < - z § t: § k \ § & J - G 2 5 b § / ( S LU § / ? \ \ \ ) D§ _ b < - $ \ § i \ \ \ / / / # A § F- a) \ o (D § to U) q q § § � n / & & EL z u j = / LL § / § § k § k § § / k Ir j j R § ) } §z \ \ < I 9 w e = w R w § § § } ) Ill Ill LLI < < < < - Cl) OD OD LO LO 2 E - G a k 4 04 0 OD OD co 2 > � o = 7 2 £ z § CID § > ) \E o = o o e o > 9 § z « / ] / \ } § § 3 » \ / \ \ a - t § / 2 a A , e , , w , , 2 2 [ / % w k w 0 § k _ % 94 4C%1 o k ^ I ~ \ cm k } / ® > § < < LO t2 Ln G § LO CO Cl 13 00 OD 10 U) C, ol 0 C, a $ a \ 04 � w OD - 2 E ° - - - « ` ` ^ kCD j \ \ } \ \ \ \ cn / § EE ) CD 2 � � C ° of $ q %ƒ LU ƒ § o g 5 2 Cl) A k § § } < \ \ / 2 § E / 3 / $ R) ° § ) § ®¥ m J ) b ¥ $ k 7 o = Q o IL \ k of § C) k / ; / ) q ) \ = o § < } z z ° � E k & L0§ ( / \ ( \ LU k « Im = 0 0 0 fE OD- ® ~ ± J ] k � Ico cq0404 \ ` z o ° o § o ° / co 00 / ) t k m o (D m CV to > n 22 / C-4 C14 cv � \ § ° k k / / - 6 ^ C44 0- , § k ( Q , , , ~ I u _ o o � o o C%lt o t 2 _ / (L ' \ L §04 z 7 a ] < \ k o 0 §k §\ k\ 0k 2 04 §CD 0 CD m 04 ( \ co \ a \ m CD 7 E ¥ « _ ^ k \ \ } \ \ \ Cl) \ \ Cl)\ ) \ / § § I d C) § 7 2 k # - < ` z w § ( > \ co § § > / § k k § a.§ $ / / k ƒ \ § } $ w ) ) R 00 2 = e - z o $ § o uLU 0 w _ . @ � k k w j ) § / / < j \ ) § \ / k / { � 6 C) w ® / / § / z § k k / / / ) k ( § k § w w w a. Z § 5 § § $ § >- (n o � o o » ) co CL a. CL m Q § § 2 w & A w w w w w w 3 2 c 04 E~ _cl) LO z LO a ) 2 � o / ) 0 0 00�2 ccoo \ n / clicq CN } ) D c e o co ( m � o m > D CD 04 f A \ j j / _ _ § § _ � 7 - [ 2 o \ , w \ , _ , , e , � / # ) G Bo 2 o 2 N\ CM Q 2 CL ' \ o \ / & § 2 A ) < « 04 Cl) C14 CV G § § § k04 k 0 0 9 ( § \ § § \ a o mOR CY) m co m a 2 ; _ n n 04 — < m J \ \ \ \ \ \ \ \ \ \ \ U.L e wcoo ca3 U) f / q ( f 0 ) a ( z r ° < E § o k _ § » w e U) S 0 U) U) � E z CO w ) k _ � z « z % / o E o ) § j E F] E ( E 6 S 6 @ ¥ ± E k 5: < � k § � / $ 2 # 0: S k S � M %e = « R 2 E $ E i k { § > § \ a. CO Ix z z z j / j 6 2 / m m ) LU / ji z z / / § LU \ \w \ j x0 & e w0: cc ) E § k ) U. LL o k 7 ¥ ) z k § § \ \ m 04 00 . 00 co k k k m pI | w OD � 2 9e 2 m a § I = C-4 m 0) r-- OaDo z e � � � U cliCNC14 \ ) / e m e m o o co m c04 04 o _ \ 0 2 < }° 2 COk f C-4 ) � — / / , { A o � o o _ / / 2CN CO . 2 ; ; � § a S a a 0 U d > II I I J N O 0 CL o O w 0 N N U0 U Cl) w � O O Q ¢ N O M N M M M M M M M M M M M M M M M •--) Ou9 U O O N O N O Un O U) N O O O O N Lo ON O U) O U) O N O N N N O N N LO N Ln O Lo O to )0 o N0 0 0 0 )0 LO V N O� W V) O N w � 'V u) h w N R LO N •0 N V to N N V V )fi C O O O O O O O O O O O O O O O O O O 0) .-- r r r r r � r .- — — 2 o w w w w y r r` o w w n n w v 0 w w co o O rn rn M O) V rn rn p rr m rn r*� rno rn rn j w w l0 OD w M Cl) Cl) N n w f� N r OD N n w U) N c-4 co •SO N n r- N N M .- N O N N V C Q N N w w 1 l6 O O O O O O O O O O O O O O O O O 0 N N N N o , N N N N N N N N N N N N N N N M C3 (o 0) 'V N t0 C" O_ O _ _ N _N M (2 t` O O O O j M V (coV C V <1 R K a V V O V' a 4 '7 C O O O O O O O O O O O O O O O O O O O F w Z W < Z ¢ O n F a > w O N O O 0 a U) m Z Ww F J w U W 0 O N > o g C7 O M to U O 0 W H m O Q Z CO W LLW W W N a0 J (n m U > W w d O N OJ j Q' Q(L a LL ca LL w O Z m y U J c+O W W Z coLL m = W w (n LU 0 U Q U 0 = w 0 y v O LL U CO) h- J J 0 Q w W F F _m 0 O d zC) vZi � � 3macowCD i3v�i m ( i, y N U :3 d N L W U L) d L U > 2 a O Ix Of Ix ir Of w w w0: of w w x Z 0 W W W W W W W W W W W W W W W U Q Q ¢ Q ¢ Q ¢ Q ¢ Q Q ¢ Q Q Q ¢ J J J J J J IX W J J J J J J J J J J J J J J J F' F U to to U N to N U N y U U N h rn QW y y w w w U 0 N w 0 U 0 w 0 0 N D 0 0 0 0 0 0 0 0 0 0 0 0 0 0 W (n J Y O ¢ Q Q ¢ Q ¢ Q Q Q ¢ ¢ Q Q Q ¢ Z Z Z Z Z Z Z Z Z Z Z Z Z Z w w w w o` m` w00 rn m rn rn rn rn w rn rn rn rn rn rn rn rn C N V 7 t a a V V d' sh V V N O O O O w O M M n O N w N w y N N N C O M O �_ M N N f0 r` b N O U O O w O w O m N N M M M M M w w N F C M l0 h N w w w w w w w w w w L = Z O p MO O O N N N N N N N N N N N N NN U U w n w 0) W o O 01 O D) O) O O O W . O O w w w w w w w w w w w w w w w w w w w w = y M N r CN r` N r'- of n 11 of a) N N N N N N N N N N N N N N N N N N w E w w w w CO w w CO CO w Co w w Co w w w co w > L OD n U z GD 000 000 ro Goo v Qco m m co ccli o V O m °D 6 w 6 w w w w w w w w w w w w w w w w w ) LL Y O N O O O O O O p O O O O O O O O O O O O O O O C U O F N F F N F N F N N N N N N N N N N N N N N N to V co T R a a V O V V V V 'Q V Vcc 0 ^ N_ n N ^ N coo N ap N N N N N N N N N N N N N N N N C, N V N N ^ < V C v V U w o �p O O O O o o O O O 0 0 0 0 0 0 0 0 > / aq / } / 7 a 04 ) < 2 ¥ § § OD k \ / \ \ k 04 \ } } S # £ « 'rCl)- E § k \ \ \ \ \ \ } \ \ \ § § o< LLI 0 § § I ® 3 2 y 5 § 2 § � § ƒ - n co m r \ \ \ z § \ CO LU ° ± § 3 < ) 3 § ƒ § / ) z � f { C ) z : k � A ® § G § E § \ ix Cl) S 0 / { co § k i 3 z L a o c + m L 2 \ E § # 2 5 LL a § § ƒ § LL ) £§ ui of ) u t § � � k � 3 k U) U)a. § z § 2 z « c < S 06 ® \ z n » S LU2 0 caw § LU LL z LL z k < / j \ \ / \ § § u o w < _ _ / z z z E 3 L § 3 2 § z 2 2 z f OD E - nCl) C14 cli . > 2 f �5 | r-- ° . n 2 e2 (D \ 2 0 D o a „ § LU ie k04 > ¥ � o o m m m cocli m > } 22 \ - - - co _ W CD - b 2 / a a § 4 , C k ( , , , , e , \ I 0 0co w co C' o r` g > a II II J o p ¢ a O 0 Q O N N a M O OD (p M O O ¢ ¢ N N � r N Cl) J 0 O O O OD ID O O O O O O (Op N OND OMD p .O ID a V > N (D n O N O O O (O O O (coD t00 O O (ND (ND T C .O 7 O ^ P7 OoD OoD O O m Cl) W a m 0) V t- o C EO N N M M c OM9 N O DD OO W DO W 00 OO ON N N O O p N N N N N U O O O O O (p ffl N r M j V O c3 V V R M O O Co O O O O O O S U U W O W n a Q y y co mLU U a 3 z ~ z a 0 ¢ ¢ w ¢ U O JLu m J C (n J LL ¢ S V W W O a ¢z LU U W O z W zLU OLL LL a ur N a. LL ^ n p O Q oD U d a' N N J LLL Y (D U � d y L U Y U N L U O U d z z z p z N a ov o� LU 0 z } LL S O U z L z z z_ U d p W LU 2 2 w (A U O 0 0 J J In co Z > > O z H J CL a La p w ¢ U D z g F U ° Ix ir O O W z LL v_ U U LL W Y O J co LLI z z o o a w � cr In ID O N Csj O O (D GD coOND cb O E v v v p> z' U M I to p O N U co M N x z clj N U v ID U OD W Y W O) o) O O O p > o N N N NN N N N II L E (o (o (o co co co m (o > n U z o) oo) rn m o 0 oN p v N n n co D7 OD OD N ¢ O CoN (ND (ND (ND (o co 04 04 W U DD O V V U o O O « ID O O O O jU- N ~ n V V ~ N H N H N H N F N N C F p A N N m N OI N O N C N O N O N („) O O co O N p N co p co p N < 11 to co w (D w O rL 00 a n 11 J O Q N a O 0 z 00 0 N C N mo M (h N N N N N J O O OO O V V V V V O C O O O O O O (� m O M O V V V V V V V V V N O O 1� M V V V V v V N V V O N N N N N 0) co V (D 00 V V V V V V lD V V V N N N N N O> C O O O O O O O O (0 O O O O O O O O O O O O O O O O O O O O O O O O O N N O co O h N N O O O O O O O O V N 0 0 0 N O OD V N N O W 0) t7 C O O N O w N OD V N (D 0) (O N O N N 0 O O (0 N M M V V h CD (0 h N M N N N N ' O O O N N � dD W V N M V r- O N N O � � 0) _N 40 N OD 00 N N N 00 00 OD 00 00 OD N W W OD Co OD N O O O O O O O O O O O O O O O O O O O O N N NQ N NQ N N N N N N N N N N N N N U O 0 0 W 0) 0) 0 0 W 0) 0) 0 0) 0) GD 00 N 00 aD N r — — — — r .- — — .- a-- — — V 4 V V a R O V a 4 4 V V V a a V M O C O O O O O O O O O O O O O O O O O O Q > p F- CL a w C7 wa ('fin Z O Q m ga z (n w F oa < o Q w g x g Q J W U ~ W a w ~ " J 1 M U O c CO ¢Q x O a ¢ z z w r uQ. It w > g (0 U . `n a) � N a = ai a OD N O C/) y ¢SW W W W w W W W W W W W tf N 0 N U _U U_ U_ > > > > > > > > > > > > a j LU w w w w w w w w w w w w d a W W W W W W W W W W W W W F z w w w N w w w w o u) O h w c� oo F O O O z U' z z z z z U' z w w w w IL z zzzzzc7t, ppx U N o U O 2 2 R R R R R R a z � W x W w w w w w w w w w w w w Q Q Q Q w w w w w w w w w z w w x x x x z x z z z z z z z z z W z z J U U U U N w iri t=i N C7 (7 (� C� C7UU (7 C7 C7 C7 C7 0000 N NLU Z z Z Z z z z z Z Z Z z W w W W OF W W W W W W W W W W w W F U U U U F Y � U � N N L N U CYi W U U z U U U U U U U U U U U U (n Z Z Z Z Z Z Z Z Z Z Z Z Z Z (n CO (n (n 4) CO CO (n CO U N N > > > > > > > > > > > > a@ U (n rn cn (n (n rn rn to N (n cn U Z (7 0 a 0 0 (7 0 (7 (7 0 (7 (7 J J J J J O Z Z Z Z Z Z Z Z Z Z Z Z J J J J J Z1-- J Z Z 2 2 Z O ~ F ~ ~ F F F F F F F O O_ O _O _O U J J J J J -:J) J J J J J -=J) J 7 7 7 > > > > > > 7 w x y y (nv) (n (nD) cncnc QQQQQ F- zzz U Z Z Z Z Z Z Z Z Z Z Z Z y W 0 0 0 0 0 0 0 0 0 0 0 0 p z Z Z Z z W w U U U U U U U U U U U U Q Q Q Q Q x U U U U U U U U U U U U F p W W W w W w w w W W W w y N N U F F- F F F F F F- F F F F w Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z 2 Z J O Q Q Q Q Q Q Q Q Q Q Q Q w z z z Z Z W F F F F F F F F F F F F F F w w W W W 0) h N (n N to N N U 0 0 0 0 N U F F F F F y N rp M M M M M M M M M M M M 0) � n ^ fi n 00 (O N N N N N N N N N N N N M N N N N N > Z 0I NN N 0) 1 .-- .- O Y U N 1� I� I� n n I� h 1� h f- f- O � N N N N N N N N N N N N 0) 0 O O O O (n > E xt 0) v v v v a v v v v c v v 00 0 U F C Z U -- — V -. M— V `M" v N m co m m (o (o m m m m (o m r• ao ao ao O O j W 0 O O o 0 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 = Y N 00 OD W N N N N w w 0 O w N N 00 a0 O O OD 00 11 C) M N N N N N N N N N N N N N N N N N N N N > d' D E N co w N w w 0 0 0 N N 0 0 0 (D N N N tD (0 a U z Y t 7 V N (0 r- O O O0 N N N N U Q CO (O N co O W � N � CO OD OD OD CD QD 00 00 N W 00 00 � OD � W N OD N OD � O p O0 O O O O O O O O O O O O p O p O O O O O 0 .�. N F N F N N N N N N N N N N N N F N �... N N N N N m } O O N O N O N N N N N N N N N N N N O N O N N N N N F N 'T O O V V V V V V V V V a V V O V O V V V V II U c O 4 O X 0 0 0 0 0 0 0 0 0 0 0 0 C4 O wO O O 0 0 � ' \ ` � 0z » a > § a ) . « J G / / \ \ OD\ \ \ / \ � e k ° co _ _ & _ — E » m m k \ , _ , � / \ \ \ CN \ \\ \ D \ § 0 3 F- 0_ � 0 § k / f § G § / j g m w ( ) z k § 3 z \ ( K \ ) } § } w LU IL w « z o w r ! k ) S CL z § 5 § a o § I F z z @ G w ° ƒ ( § § ) g m co m § 2 ( $ § w \ [ z § k w § / 6 E S z � 2 2 2 CLa S m m / k 7 > k ) ) k k co CD > z p # � ) CD LO k U) ` § OD o ` ° m £ 2 t00 co OD 00 QD 00 OD E o m m m mcli CD m > 2 62 { ( § § ( [ § ( ( f A 3 » 7 7 a ] [ R 3 , U. a , , e , # , /, / Q , 4 $ [ ° 00 3 3 w w w w 0 Zo 0 ° tL u M u Q o p ui z o' o O m IL � 0 N C V 77p N U r OO O Q Q C? C? N N N J O_ L 0 M O n O N N 00 > O O O O O C 1- O O c0 t00 G? cn0 1� MC, O VC N N V h s{ N W O 7 M M co O o) Lo O O O) rn t` n O N N Ll E '- a r N Cl) N N OD aD a0 aD aD i0 p N N N CD N N M M V Q O N O O O C O O O O O O a � N d � N p CL a J J J C w D D D o' N U U U U H F N « W W W W W p Y � v N d y L U v L U LL a w W N U z } } } ~U z 2 m W W W Q W LU LLJ LU �i X X X � rn co o 0 0 \ co in in Ln \ E v > z bY M N C', N U N N (n j E � O !9 c0 co L F C � .M U = z vii u> .n N r U m m eo co 3 WOD co OD CD CO 11 Y U L E co coN (No (No cN0 7 y Y c0 f� aD U Qa U z `.S o ac m O L Y N N N coF- .. - N (� Q co co co � � �U � U OD 6 m m V a2 T N V T 7 LL N y O U O N F N F N N N 10- (� Q V N p N r N co N N N NN N v R R V II U co o o 0 0 0 U g CITY OF OAK PARK HEIGHTS Journals-Council Report(2) Page: 1 CASH DISBURSEMENTS(CD) Apr 24,2018 01:08PM Period:2/28/2018(02/18) Report Criteria: Journal Code.Journal Code=CD Transaction.GL Account(3 Characters)_{<>}"990" Reference Account Debit Credit Date Number Payee or Description Number Account Title Amount Amount CD � I 02/28/2018 1 RECORD PSN FEES INVOICE#169131 705-48100-212 OTHER CONTRACTUAL SERVICES 84.87 i RECORD PSN FEES INVOICE#169131 70648200-212 OTHER CONTRACTUAL SERVICES 84.86 02/28/2018 1 HEALTHPARTNERS PREM-FEB 101-20970-000 COBRA INS PREMIUM PAYABLE 448.51 HEALTHPARTNERS PREM-FEB 101-40690415 EMPLOYEE HEALTH LIFE&DENTAL 670.10 02/28/2018 1 DELTA DENTAL PREMIUM-FEB 101-20970-000 COBRA INS PREMIUM PAYABLE 88.20 02/28/2018 1 PAYBACK HSA CROFT-FEB 101-14700-000 ACCOUNTS RECEIVABLE-MISC 250.00- 02/28/2018 1 PAYBACK HSA WYNIA-FEB 101-14700-000 ACCOUNTS RECEIVABLE-MISC 250.00- 02/28/2018 1 PAYBACK CITY FOR EE PORTION HEA 101-40690-415 EMPLOYEE HEALTH LIFE&DENTAL 845.59 02/28/2018 1 REV CORR BANK REC DEDUCT IN JA 10140690415 EMPLOYEE HEALTH LIFE&DENTAL 552.86 02/28/2018 1 CORR ER DENTAL PREMIUM-HICKS 10140690415 EMPLOYEE HEALTH LIFE&DENTAL 33.52 2 02/28/2018 2 END CODES-TASC 10140600-212 OTHER CONTRACTUAL SERVICES .04 Grand Totals: 2,808.55 500.00- 1 it CITY OF OAK PARK HEIGHTS Journals-Council Report(2) Page: 1 CASH DISBURSEMENTS(CD) Apr 24,2018 01:09PM Period:3/31/2018(03/18) Report Criteria: Journal Code.Journal Code=CD Transaction.GL Account(3 Characters)_(<>}"990" Reference Account Debit Credit Date Number Payee or Description Number Account Title Amount Amount CD 1 03/31/2018 1 RECORD PSN FEES INVOICE#170737 705-48100-212 OTHER CONTRACTUAL SERVICES 189.44 RECORD PSN FEES INVOICE#170737 706-48200-212 OTHER CONTRACTUAL SERVICES 189.44 2 03/31/2018 2 HEALTHPARTNERS PREM-MAR 101-20970-000 COBRA INS PREMIUM PAYABLE 448.51 HEALTHPARTNERS PREM-MAR 101-40690-415 EMPLOYEE HEALTH LIFE&DENTAL 670.10 3 03/31/2018 3 DELTA DENTAL PREMIUM-MAR 101-20970-000 COBRA INS PREMIUM PAYABLE 88.20 4 03/31/2018 4 PAYBACK HSA CROFT-MAR 101-14700-000 ACCOUNTS RECEIVABLE-MISC 250.00- 03/31/2018 4 PAYBACK HSA WYNIA-MAR 101-14700-000 ACCOUNTS RECEIVABLE-MISC 250.00- 5 03/31/2018 5 HEALTHPARTNERS EE OVERPAID TH 101-40690-415 EMPLOYEE HEALTH LIFE&DENTAL 11.88 03/31/2018 5 HEALTHPARTNERS ER OWES THRU F 101-40690-415 EMPLOYEE HEALTH LIFE&DENTAL 581.04- 6 03/31/2018 6 CORR ER DENTAL PREMIUM DUPLICA 10140690-415 EMPLOYEE HEALTH LIFE&DENTAL 33.52- 7 03/31/2018 7 BANK WIRE FEE 101-40600-212 OTHER CONTRACTUAL SERVICES 5.00 Grand Totals: 1,602.57 1,114.56- I CITY OF OAK PARK HEIGHTS Journals-TREASURER'S REPORT(2) Page: 1 JOURNAL ENTRIES(JE) Apr 24,2018 01:09PM Period:2/28/2018(02/18) Report Criteria: Journal Code.Journal Code=JE I Transaction.GL Account=90110900000 Reference Account Debit Credit Date Number Payee or Description Number Account Title Amount Amount JE 02/07/2018 4 SB 15-28 INV Matured-Compas 901-10900-000 INVESTMENTS-AT PAR 245,000.00- 02/20/2018 4 WF 16-04 INV Matured-Bank United 901-10900-000 INVESTMENTS-AT PAR 245,000.00- 02/28/2018 4 SB Purchase SB MM 901-10900-000 INVESTMENTS-AT PAR 247,872.20 02/28/2018 4 UBS 16-33 INV Matured-Washington Tr 901-10900-000 INVESTMENTS-AT PAR 240,000.00- 02/28/2018 4 SB Purchase UBS MM 901-10900-000 INVESTMENTS-AT PAR 242,346.74 02/28/2018 4 SB Purchase WF MM 901-10900-000 INVESTMENTS-AT PAR 249,587.53 02/28/2018 4 Interest on MM 901-10900-000 INVESTMENTS-AT PAR 1,260.34 Grand Totals: 741,066.81 730,000.00- CITY OF OAK PARK HEIGHTS Journals-TREASURER'S REPORT(2) Page: 1 JOURNAL ENTRIES(JE) Apr 24,2018 01:10PM Period:3/31/2018(03/18) Report Criteria: Journal Code.Journal Code=JE Transaction.GL Account=90110900000 Reference Account Debit Credit Date Number Payee or Description Number Account Title Amount Amount JE 03/02/2018 4 WF Inv Matured Comenity Bank 901-10900-000 INVESTMENTS-AT PAR 03/02/2018 4 WF Purchase WF MM100,000.00- 901-10900-000 INVESTMENTS-AT PAR 100,080.55 03/02/2018 4 UBS Purchase Inv Hapoalim 901-10900-000 INVESTMENTS-AT PAR 240,000.00 03/02/2018 4 UBS Sale of UBS MM 901-10900-000 INVESTMENTS-AT PAR 03/31/2018 4 SB Purchase SB MM240,000.00- 901-10900-000 INVESTMENTS-AT PAR 920.94 03/31/2018 4 UBS Purchase UBS MM 901-10900-000 INVESTMENTS-AT PAR 2,592.16 03/31/2018 4 WF Purchase WF MM 901-10900-000 INVESTMENTS-AT PAR 9,680.26 03/31/2018 4 Interest on MM 901-10900-000 INVESTMENTS-AT PAR 1,564.35 Grand Totals: 354,838.26 340,000.00-