Loading...
HomeMy WebLinkAbout09-26-2017 Council Handouts � I > \ � § � < CL e z cli § 04 CO < k k GG v § v C4 9 \ S # m Cl) o - k £ \ ^ - - < ~ § § k k \ \ \ \ \ \ \ 0 co040304z k � $ [ § E Ir w 3 E o 7 w § $ & � \ 2 41) i k z k z � z ° z 2 z w & COR 22 = o u @ » R $ 3 £ < m g § § -a § a CO 0 @ U o u ( E 2 � w o ± 4 § A \ \ § } LU 2 LL I � - k { § } j § $ IL LL /z o b o ■ LU� z Cl) \ A § ® 0 � [ & k § z 5 E § u e § m § R / § \ w $ R ) B { { \ . o § < f < I I £ f ) n - n n � § \ z ka / | C4 04 o § § ( » 2 k } o < � ° IE v n cli� k w C) © 04 / 2 \ ) § z 04 0 # # / / G o $ £ o k j a § f _ # k ƒ k ' 04_ ) 0 w , , @ ( 3 , Q , 04 0 I o ƒ CN > f . 2 mC ) z cli \ ) � \ { G k \ k \ \ / } e # 04 CY) 0) / ) \ m v - k \\ \ \k }\ \ \ / § z Q n ® 5 t § \ k \ 2 ) ( n § LU M q \ & % w § w -j CL z w } w ® 3 w 0. w g o — k § / k E § z § § \ e z o n 2 ) § $ $ § / ) 5 � & o ƒ a k � o { § CL \ co B / R w ww m z 0 z k k co w § \ F- 2 ® in § \ w j § § § o 2 2 ( § S § § 0 5 8 E - - - - n m f- 00 m > z pm | 04 2 co 04 cok z o cli 04 o m o tou § / £ ) E ( m > E S 2 \ ) CD) — — — — cu / u b a w � w A � � a 7 w : & 3 , Q ,to , Z a / C I aCD 0 n a. > g CLC \ § / / 06 \ / j\ \ § § \) ® \ \ \ \ \ \Lo Lo \ a k Lf) - C14 U) ® 7 E ^ Lf) Ci - w - « - R R >0 04 04 } } \ \ \ \ � 04 ® LU ¢ LU > . IL 3 G z { n § ° IL (L 9 o S $ / §$ § 0OL S2 g Ix § 2 LU § [ / 2 O > e o o 0 2 & ui 3 w b - S o - c a_ CL $ g ¢§ )§ [ 2 9 [ LU LU LU \ $ - \ \ a- ƒ a JR � / { § / / CLLI k kLU / / § » R § LU o k E § / ƒ ■ o y N ) m S w § z ° s R w b \ \ \ \ LLI U. B o = 5 0 oD CO OD f t m C11 a 2 % $ �k OD cli C-4 t CO § § 'a) - C110 §$ co co w co f t E m c m co o > n f 2 § 3 1 f � 7 1 * 4 § , N A Q e , A , w � A , , A , ( ,ID _ , , � / o [ G 2 m t E 2 S 2 E 2 S t E i s v a. � a u o p j a o O z r 0 N C N CL r NQ c7 C? C? M l`7 q N N N ('7 l`O7 J O O O O u) O O O O O O O IVO) O O O O O O N M u7 (0 (0 (0 OD 00 O N h 00 N N O co O O IT IT IT i 0 W) N t- LO c o 0 0 0 0 0 0 0 0 0 0 0 n n n r r C u) r co O O 0) OO O O u') M oo N N v 01 M N r V7 (0 O O a) W O O n OR u7 O O O) W 01 C Cl) O n d) N n co (D to N 0) N h M co Cl) M r- =1 N r r (p O O N N It N n n n oo c0 .0 Q r r V n W N d r r r r n n n n n n n n m 0 0 0 0 0 0 0 0 0 0 0 0 a N N N N N N N N N N N N 8 � m v (O ao � v v m M M j W T 0) W a C) O) � ai 8 a � C O O O O O O O O O O O O W J_ f— p Q W W a O F9 a U to a 0 LU c aco Q c � J p O W n h p U W LIJ LU QF F N W NU) N p W U N U rn F O Q W r U W p D a U M J W n a a x Q a U a a W W J LU r C�7 z z OU Q QQ r a J ti LLJ V N Z O Fx J W N z r N ; d a' W 2 } J Z W Z N a J p Q W W U J a O z N 0 Q "v LL a tai U m a a � U � � NL U � L U LL m az O O O CL IW- IW- H IW- H w Z Z U Q Q Q Q Q 3 3 3 3 W O w U _ F F F F H LL ca m m H F y h N N N J W a s = a s Q _Y a CO a a a ~O � � � � 0 O p p p p p y 00 Q W W W a U U Z Z z Z z Z(0 hY LL LL W W W W W z O } } Q LL LL g g z z z O O O 'C'S a !9 O2 M M O V R R n (1 (0 c0 aD C It V z N O M O O O O O O O U M y N N r (V � O O C4r_ _r 4) co > j eM- ^ M M U N N H CM M = z O O O C) 0) 7 `1 �t et st )0 O n n CD O () W O O1 W W T 0) O) 0) 0) 0) W O) j Y d O 07 OD O aD co aD co Do O O O 11 Y N E O o (0 V1 DJ (0 (o (0 O O co o > Q U z 0) rn 0) 0) 0) 66 m a ro oD oo ao ao ao eD L Q (0 (o O (0 to O o) U LL p 0 0 0 0 0 p O p O p 0 0 p O p 0 0 O C O F N N N N N N N F N N r N N N (o (O CO CO CO (O N (0 c0 [0 r CO CO co (O 0) W W } p 0) N N N N N O) N 0) NN N w N T N N F� 0) O) m a) W CO 0) � O) 0) O) (D :! 0) 0 II V 0 0 0 0 0 O 0 Z 0 0 0 O 40 0 0 V) > g 0- u II J N O 0 M ' a o '2`S n 0 N C 04 7 N O Q N V O N N N N N N J O O O O OV N O O O Cl) O O V N O LO co (O R a0 R LO N N N V a ? � b n r n > n v N N 10 10 d' O O O O O O O M M Of d) n r M M O O O O O O O O O a0CD M M N N (0 fO v V n r Cl) Mu) cn r .> o N N r r N N Cli cl N u? C Q M cl a) r n n n r r n r n n N N N N N CD N N N N N 0 p cpM M O m a0 a0 as > O O O O O O O O O O C M W N Ca N 0 n Ir rn U = W n yM Z CO N J O O W > a J W 3 W Z J W W W c r W Z O O C9 U m G LU it a YC. F- W rvi 2 2 2 F- ao U Z U. U U U CO p LL J U O U U U dLU LU LU a U) 2 W N U U U U � d a) t � U U Z O Z Z U J F > j W Z U 4. ZJ J C) ? J J J O Q Z Z Z J O O O O y o O 2 a I F F F- LU F W O W z Q H H F v) LU7 2 CO O W Q Q Q VU LU 0 X U Q U y N Z g W O F CO v_) CO > J LL 2' U Q J Z Z Z CL I LLI U) v~) y (n F F M r V N M N n n n O N O) p M (O U a N N O O) N U) UO w 10 sT V V V V > 2 n MM M M LV d N 'D N> E V V M N I-- v O Z r N rn rn rn U 2 LU 0 0 0 0 0 0 0 0 0 0 > 2 d rn rn m rn rn rn F! rn rn rn n Y o E o co co co to co co co co co > Qa U Z rn rn rn m rn rn rn � YL Q co co co co co � � U O a) N F N N N N F N H N N N N O LO co N 8 M f0 v a7 N CO i0 ( n w 0 0 O O N O N O N ON O N O N O N O N N N p W O O) 07 0) O 0) O 0, Oa 0) O O O Of II a > II a II a m (L o Oj n 0 N C (0 7 N p O. 8 O OM O O O M M N N N 0 Q N N O _ O O N N M NU) N J O O O O O O O O O O O O l0 V7 40'1 N O '�Q O O N O N U N N O V7 O O O O O V O C. C O O O O O O O O O O O O O 0 0) 0) V O N N O 41 Cl 47 Cl Cl O Cl O Co Cl O O O O O O o W O n O n O O U� (17 O O N N O O O C v o O M O M o o n V' < O O O O N O O h -V 0 R o oW O 00 co co d' V N N N O O .-- N M N act Oct 47 v a O 41 N N N M M m n n n n n n n n n n n n n 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N N N N N N N N N N N N N co O> O) OD O) 0) T 01 (O O) O) O) Q o O O o 0 0 0 0 0 0 0 0 0 D Q O ° j m Q F Z } O g (n Z o W a z ? y n w 0 (7 C7 (7 a O IL n U Q Q ¢ Q Q U W w Z -iN N ° Q (0 N N N h U) �J J N CO U U U U U U 0 CO W 2 (n LU U W W W W w w Z OU °� Ucr U nO (0 CO (A (n y N O CO > w Z Z Z Z Z Z w F" O U) Z V 2 Z Z Z Z Z Z U M m Z N � LU 5gg � g3 w EL o a g w aoi o U F- (L a a a a a U) U F- U � O) y L U O J L J U J O w U � U U U U U U Z (D J J J J J J J J J J J J J O l0 } } } } } } Z J Z a. U U z z z z z z co J J Q Q Q Q Q Q OLU Ir z z 2 2 2 m 2 Q O O 0 0 0 0 0 0 Z LL F H U U U U U U wLLI y U z Z Z Z Z Z Z Z W Z W Q Q z Z Z z z z j Ld T) T gggggg LLJL ° 5 Y z z a a a a a a J O w 0 p U Z w w 2 2 2 2 2 2 O =i Q Q F- F- F- F- F- F- F- F- F- F- > > > n n d1 0) O) 01 0) 0) 01 O N M M 0 `y w w w w w w n n N N n O O O o 0 0 N v N n n 1 z O) N O co cli N M M V) M m M co o M O U O cli 4) E O V V V R 'Md' O) a0 O Il L H c Z °-1 Q °° rn LU U 2 p LU O O O O O O O O O O N M_ = Y d 0) 0) 0 0 0 0 O 0 0) 0) O O) O) II Y y O O O (0 (0 (0 m O O 0 co (0 0 > a' L Z O O O O fV U nQ. U 0 m 0 rn rn rn Q m (o w (o (o (o U O n n n 0( n n n n n p n y0 0 0 0 0 0 0 0 p On @ n p On p O U- p n C O co OD CO (O (O (O (O (0 N O N N N N P1 N g CD F- W O) O O) O) O) T O) O) O W p) 0) p) O) 0) p) II V 0 O 0 0 0 0 0 O O 0 o 0 0 a u a o O n 0 N C N 7 Np O, (� N N N N N Cl) O O O 0 (O (0 (O O Q M N N N N N N N N N N N N O O O a O O O N 0 0 0 0 0 0 0 0) i O O O N � R c q v a v q17 j N N 1n C O O O O O O O O O O O O O O v n n n O O O O (D m 0) O O u) O r W CO CO 0 _ O (h M (p r (o M O O O O O Co M v sf CD M N C )O R N co O O r ('i O )O LO O R n (D O T O O N O N Cl) N co N 0) N Cl) N N )O )O < (O r N )O C E r 0) a) n n n n n n n r n r n n n r 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N N N N N N N N N N N N N N N j 0) m 0) 0 0) m m m m m m 0) m m O O O O O O O O O O O O O O 0) O O N O O Z F Z Z W w W 2 .a O w W 2 r y > Q Q a 0 () > W } v~i vwi O N p �, Z W> F- = a `o = j Lo w } } } } } o a Q w F n ..] d w It d Cl) J J J J J J J H y 0 0Y a a > j > j > > > O N W_ U U _j U V r Q' N f0 N a. U Z x x x x Of x Of W = = 0 w -Q� z N N Q Cl) (n QO a> �J,j w LLI J J J J J J J 4D m U U 2' > J W W W W W W W I L N U � N U Z z O — > > V Q w w CL U) 0 0 a 0 0 U U U It O O O z z } } } } } } } 0 CD CD 0 CD C7 CD 0: 0: 0: w of x 00 z O O o w w w w w w w z z z z z z z w w L w w w w w w w F J J J J J J J co U) W W W W W W W U U U U U U U 3 X X X X X X X N (O (D O O N 0 0 0 0 0 0 0 )O WO )D w (O 'D W) D co r r M > 7 Z N O O O p r V m N r n N Y d N N N N w r l0 r (0 m r O (O O r0 � d r0 g r- N N w L F- c n (D r ao ao = z O O O co W )O N O r r m Of W O O O) m d) = Y 0) 0) 0) 0) 0) 0) 0) O O O 0 0 O O) II Y y (O (O (O (O (O (D (D f0 (O (O (O f0 (0 (0 > Q V m M v iri io r is d z rn rn rn rn rn rn Y L Q iO (O t0 f0 (O (O U @ n � 0 0 0 00 a 0 0 00 0 0 o 0000000 U F N F N N r N N N N N N N N N N N l0 O V (O w co (O (D (O r CO ( m CO T (O W 0 W (D (O (O O N N N N N N N N N N N N N N m 0 0 0) � m m � 0 � m m m m m m m II f..) O 0 0 O 0 0 0 0 0 0 0 0 0 0 ' OD Z) } 7 / / \ \ 0 f e \ k \ k « co � ) � CL m p ) \ / k / { a . [ a. y �. 114. > i r ] i am § $ 33 � ) \ � � - > ƒ 0 2 2 - \ _ ® k / / m ) ƒ ) ƒ \ ƒ i j ® # § o © 0 I CITY OF OAK PARK HEIGHTS Journals-Council Report(2) Page: 1 CASH DISBURSEMENTS(CD) Sep 26,2017 03:10PM Period:8/31/2017(08/17) 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 08/31/2017 1 PSN FEES-JUL 70548100-212 OTHER CONTRACTUAL SERVICES 125.35 PSN FEES-JUL 706-48200-212 OTHER CONTRACTUAL SERVICES 125.35 2 08/31/2017 2 HEALTHPARTNERS PREMIUM-AUG 101-20970-000 COBRA INS PREMIUM PAYABLE 418.04 HEALTHPARTNERS PREMIUM-AUG 101-40690-415 EMPLOYEE HEALTH LIFE&DENTAL 629.98 HEALTHPARTNERS PREMIUM-AUG 101-40690415 EMPLOYEE HEALTH LIFE&DENTAL ,01- 3 08/31/2017 3 DELTA DENTAL PREMIUM-AUG 101-20970-000 COBRA INS PREMIUM PAYABLE 88.20 4 08/31/2017 4 RECORD BANK CHARGES 101-40600-212 OTHER CONTRACTUAL SERVICES 5.00 Grand Totals: 1,391.92 .01- e - e CITY OF OAK PARK HEIGHTS Journals-TREASURER'S REPORT(2) Page: 1 JOURNAL ENTRIES(JE) Sep 26,2017 03:1oPM Period:8/31/2017(08/17) 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 08/24/2017 5 UBS 16-32 INV Matured Summit 901-10900-000 INVESTMENTS-AT PAR 240,000.00- 08/24/2017 5 UBS Purchase UBS MM 901-10900-000 INVESTMENTS-AT PAR 240,142.68 08/24/2017 5 WF Purchase WF MM 901-10900-000 INVESTMENTS-AT PAR 51,500.00 08/24/2017 5 4M Sale of 4M Fund 901-10900-000 INVESTMENTS-AT PAR 51,500.00- 08/25/2017 5 WF 17-20 Purchase INV Commerce 901-10900-000 INVESTMENTS-AT PAR 245,000.00 08/25/2017 5 WF Sold UBS MM 901-10900-000 INVESTMENTS-AT PAR 245,000.00- 08/31/2017 5 SB Purchase SB MM 901-10900-000 INVESTMENTS-AT PAR 3,056.03 08/31/2017 5 WF Purchase WF MM 901-10900-000 INVESTMENTS-AT PAR 3,910.61 08/31/2017 5 UBS Purchase UBS MM 901-10900-000 INVESTMENTS-AT PAR 2,346.74 08/31/2017 5 Interest on MM 901-10900-000 INVESTMENTS-AT PAR 1,103.67 Grand Totals: 547,059.73 536,500.00- • f t City of Oak Park Heights Bills Presented for Payment September 26,2017 Payroll Gross Payroll with PERA, FICA, and Medicare City Administration: 9-29-17 11,007.70 Finance: Full-Time 9-29-17 8,149.39 Police Department: Full-Time 9-29-17 46,504.15 Building Inspection Department: 9-29-17 4,020.41 Public Works-Street Maint. Department: Full-Time 9-29-17 1,098.07 Park and Recreation Department: Full-Time 9-29-17 1,235.81 Part-Time 9-18-17 2,029.66 UTILITY FUNDS Water Department Full-Time 9-29-17 8,081.31 Sewer Department Full-Time 9-29-17 5,336.12 Storm Sewer Full-Time 9-29-17 974.02 Total Utility Funds 14,391.45 Total Payroll $ 88,436.64