Loading...
HomeMy WebLinkAbout08-22-2017 Council Handouts City of Oak Park Heights Bills Presented for Payment August 22, 2017 Payroll Gross Payroll with PERA, FICA, and Medicare City Administration: 8-31-17 11,007.74 Finance: Full-Time 8-31-17 8,149.38 Police Department: Full-Time 8-31-17 45,631.81 Building Inspection Department: 8-31-17 4,020.40 Public Works-Street Maint. Department: Full-Time 8-31-17 1,560.70 Park and Recreation Department: Full-Time 8-31-17 1,235.81 Part-Time 8-16-17 2,693.32 UTILITY FUNDS Water Department Full-Time 8-31-17 7,813.17 Sewer Department Full-Time 8-31-17 5,067.96 Storm Sewer Full-Time 8-31-17 973.99 Total Utility Funds 13,855.12 Total Payroll $ 88,154.28 — I > / 0 \ z § » > cli } / } ( \ § § § \ G a k \ \ \ } \ \ \ 2 \ ` / E — — E ` 3 3 — k ® \ \ \ \ \ \ \ \ � e 4 Q ) } . w 0 } ( D CL } / - co § § } § z / Cl) w < z \ 9 G o g \ / } § 0: 6 § > ( ) §\ & ± z E - ® } a ) co 5 CO S § � 2 U. A \ 3 § 2 f k 6 { § g g \ ( / z § §§ 3 3 o A k k ° ~ z i § ) z § § § § § § $ a ■ 2 z / n ° ° w z z CL 0 o a w w § ) G ( § y § ) £ k E n n LO LO § a 2 co $ k | a r 9 E � a z 2 — 0 � « \ x a) E co co e o co \ } � m 22 co � � CL cok — — — ° 0 ) Q k C11� w � A Q A , A , ) ( 3 , , , / CN C4 C4 Q I o ) o o w o ° G m o w o � > aq jz ƒ / cli CA / \ 4 a \ C2k C j \ § § \ \ \ \ \ e \ = Cl)7 / _ cli n _ m o } } \ \ lo \ \ j } co ODƒ z LLJ§ 0- & ± 2 i 2 ( 7- z ) § uj % \ f ) § = G < n w / ( § } § § LU uj u2 u = a B k \ § co 2 ) e ± ± < CL a. ) [§ ) � z f z Ma b 2 £ L LU■> ° [ L R J 04g g cc § co § § ) ) o t § / z R/ /_ = ° \ § ■pM o o S F- F- u) \ z z L) §CL E ( k z § \o / E § & z/ } § m§ \ \ < & 5 & q >- < < c co co ca co m f E — � o « n v n a z p / | o t n 4 ® G \ 2 ( k k ( < 7 LU o CN ro } 0: $ k clj ( a _ o m > ± q k co OD \ — — — — — _N CN clj 04 04 CN j / a a »y a \ » # & CN / w § § o , $ § § § ( Q , , , , \ ) o > f CD m § } z of § < < G § § J a 7 ( § e 3LO £ m 04 04 m 04 C — E ® « > \ \ \ � 84 04 C \\ / Go 00 � n \ - co § i S © ' 2 & / S o uj \ / LUA ( 2 0 § » < M § § o ) /� co ( § 2 4L0zU 2 2 / \ § / § 3 § § § It { / 0 2 § C) CO LU ) / \ > a: LLI af k < < z ° w 0 a:C.) } \ \ w § 2 z ƒ k / K§ ) \ 2 n u § k § c ± L 2 f co co IT k - Cl) LO - - « > k / z \ 0 cli LO 0 0 04 04 CN Cl) / o ` / ) k k c c G _ \ I ° 2 / ) — — — — _ _ m LL C> a a \ 0 f 0 \ » \ 0 / ) ) ° ~ Q F- Q ® m § ° § 'D § � § d ( , , , £ C14o 2 > f 6q j /CL 04 CY j § / } \ / C? \ \ / / / \ 7 § k C) \ \ / \ \ oq ak 04 _ co / / - _ ° m m © / \ \ \ \ \ \ \ / \ \ Sco � » § t n co 0 \ / f§ ( $ § r a. Z it ƒ 2 7 ) LU G $ a_ LU b ° § / CO ± ) G o z o [ c o@ ® [ § § § x \ \ § 2 § $ k ui 2 = 2 ° d 3 R 2 o E § 2 3 2 ) F 5 \ ) o $ § CL / / Ix / k B 2 ( ( f o � < < \ \ A k k CL o- ) /0 0 E S ( ( \ \ \ Cl) \ \ LL LL } j E f ( } \ \ \ \ ) oD oou�f n m LO n a2 pk | ° G n | E G m 0 00 § £ 2 2- - k ® 04 LO � c _ (D em > } klid ai \ co - - - - - 3 / 2 \ » / \ \ ® ° » 2 m b m Q a Q a § 7 q 2 \ ) k / o o ] ( - C;N- v G 2 /CII N G / ) © ) / £ o o o _ 0 'a o w % o o / o o a u rn N M 0. m o O z n 0 N N N �poU 7 U r C r M M N O �O M 0 ¢ ¢ f7 M M M M N N OOD v N N J W) O O O O O 00 O v 00 O O N _ Q7 h O O O O O U v v v ONOO OV V W N O C O O O O O O O n r � � O O n � 0r O N O O O h N O O O O O O V R n n O M M C1 0 O O O O fV 0 m v M ' O V n n (NO N N M v v r N N N M LO n n O N O C ¢ O O N N V R m 0 0 0 0 0 0 CD N N N " 0 0 0 m m OA O O M OD o3 aD W aD ,- ch C 0 0 0 0 0 O O O O O p n O COF z J LL W J m S w W o U n ¢ z z w H N 0 W a U Z W O r wO O N w CO W d W = PO N U U) W W J W a LLI n U = W j a w W 5 w C0 2 ~ U LL n _ (7 W O Z O w V N z 3 Q F ¢ 3 LL F tCL - :? iri U ui O W y aF m U F a? F m a ¢ C7 w m S Z f- J LLof Y N V N N L N U � d U h >. > Z U a w w w w w z p Z z C ¢ ¢ Q ¢ ¢ - - w 3 3 3 3 > z z J J J J J J J J J J W p Q Q w a. co LL x 0 0 0 co 0 S h W W O LL Ir w Ix w W Z Z Z Z Z Z OU W W W S OF W W W W W W 0 J J ZZ S g 2 z 0 N 0 0 0 01 0 v M M!2 m M h d E a > z m u7 M m O M M N N 0 007 .O E m ^ m N 0 My N m N N H C Z r r r Cl) N W N - U 0 O N -7 v u7 w 0 O 'o m n O 'p w v v v v v m m rn 2 Y d r n r n r `r �n > Y a r S y E 10 (o co co co co. co m co (O �p > dU z v v rn o �e Y m 00000 ss r O N O N N O O O O O O C 7 Y N N N N N N ~ a} N ~ N N ~ a N ~ m N ~ N ~ F- N N m ao m m m n n U 0 0 0 0 0 0 0 0 o o to o to o CD t:m n o ° � / \ 6 § j / / / Im< } / } ) \ \CN \ \ / o a V R � 2co co ( i { } r- r m p p ° U') / k \\\ \ / \C \ § § o < ( ) ( j » § ca % G ) G 3 r § § 0 / \ \ 2 § n / j e = c q § ƒ \ / A ƒ ƒ § § C0 E ILLI � § S 2 g CL � e ) ƒ kQ) CO § \ \ \ § t § / ) o . E $ ƒ j / / 2 / 2 2 z M w ) § / § § k% ) _/ ) LU< / } \ § LU G 2 X ( ( § § 2 % 3 CO o � 2 - -W - - E - - a2 p / 04 0 V) e e 2 CV C14 \ 2 1 q ( k k j / § § 6 2 / - - - - - L) a > \ a » \ 2 \ ° - § a Q ( Q _ § / « � § § ( 3 Q , , ~ ' £ 0 / 2 n a n O N Q a7 L o O z n 0 N N oU O U O N p Q Q N M N O� N N .- M O O O p O' 'cf C? O O O O 0 C14 CN t2 et M V O 'R a O Cl? M 0) O O C O O O O M aJ U1 r r O O O O O O V co M M N U) � O O V7 co O O N (y C N M po O N N M M O O Q co a010 V7 v7 n n n n p o 0 0 o r N N N N N N N O � N C co O O 00 O O co O O O W O QJ n W J N a� Z _ CY u) O co z ZZ N W N > C L O Q a0 co CO Q N 0 M co w F aIL r Q X� " F n 0 L ¢ LLJ W O Lij O c�� p N W V W O F U tL U U Z w > d 0 m [L- E: > a N w w o Q 0 0 ~ F- O O N n Q Y 7 N N L N U a) U Q) CL ~ T = a z z a 0 cn z Y Z z O O O O 0 z O CO a ca = U U w W LU C0 LU Y O J J Q Q R >- LL W > > 3 w z = IL a 0 U) co y y co C/) H N O (� a1 O W v° d °r0' r r O O O Ln N j M M O > Z N co n C-4 In In CD (n > E � M M 0 N O = C O O N N Z ccoo O_ co C..) Z U N O a OO S d <O (O a) cN0 cM0 coo c00 t0 > Y Y L r r n r r n nco II aa) E m m co to to coco > Q L 7 n V Z O CV Cl) a i(i f0 Y Y n r r r n n co coami L Q co co co m m co co U r n r r n m r :° m .O-. F N O N N O N O F O O O O O O O F N N N F C n N 10 N N iN0 N O N to N F b _N O N F a0 U O O O r 0 n 0 n O r a0 r W 11 aD 10 w to O !; 0 LL u Oco (V 0 Q N = a o O z r O N N C N (M O O O O O O ^ M Q O O M M M y Q O ( N (h 0 O O O O O O O O O O O V O p 0 (D O N M O V O V) Q) N N G N LO (D V N N N N N N R O (OD (OD O V O O .O N N C O O O O O O O O O O O O O O O W O O O O O O O O O O O 0 0 0 0 0 0 O O er eJ D) D) N N O O O (n (n0 0 0 O O O D) D) C O O ^ M ID O O O n n O O O (n Dj Dj jE 00 00 OD M (n (n O OD OD (n O O N ^ .�- N N N N (D O 'Q C Q •- � (p (p T � n d n n n n n n n n n n n n n n r p o 0 0 0 0 0 0 0 N N N N N N N N N N N N N N N V O) (A w N u) N_ N � (n N (n t2 O M _ � aoco ao 8 ao rao ao aD m ao w 8 0 r 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O J Cl) n w � s 0 3 a J O. O = J o ayi H J U OLL N O N LU w W U W g U U U U U C7 > > > > > > U w w w w w w Q w W w W w W = O N Q. (D a. Q. Q' O (n (n (n !n (Q fn 00 W 0 C9 U' U' C7 Q ~ v o = = i = a z z z z z z v z U U U U = U) z z z z z z ` N LL U U U U U Z Z Z Z Z Z Z = d U U U U n d d IL a d CL j � o Y d � L � U � N U U U U U U U J J J J J J F T J J J J J J N LL J J J J J Z Z Z Z Z Z 3 J ZO J J J J J Q Q Q Q Q Q a (L a a a a (n 2 2 2 2 2 L4 < O O O O O 0 0 0 0 0 0 J U Q Q Q Q Q w U U U U U U F y Z F F F F F Z z Z Z Z Z Z w w Z Z Z Z Z Z F (a N N vQi y z z z z z z Z 0 0 a o w U N U U D g g g g U) 2 z z z z z m a a m a m a Y Z Z Z Z Z w w W w W w w Q O Q w W w w w = 2 = = = = = _ F F F F F F F F F F F F F- F- F D) n r n n n co 01 0 01 D) D) D) 0) o a n (o u) n (n (n (n ao m ao ro w ro ro n v v v v v v v c v v v v v °' ri Z N N O O N M v 1n 0 N V L N (MD (MD (MD (�D O N (D (O w (D w 0 D) V co j O (n U7 �n In J v V v V v v U) N L _ � Z o rn rn rn rn ' OD M U 0 0 a0 v w m co m (°DD m o n no on N > n n n n n n n n n n n n In. n II y U iD (0 1 aU Z m CC) n n y _ n n n L co mQO (o (o (o U n m n n n n n m n § r n n n n n n m r n N NNN (pN � NNN CD NNO O NO 7 N N N O C op N N N ) F @ co N N N N N N N N N N A N N N e0 w w OD Go n a0 n W II (� O (D O O O O O aD O t0 O 0 0 0 0 0 O O I ' \ � j � g z / \ 04 /cli 04 § \ § o e e 7 \ ( 0 OD ® kc. cq 04 « k £ ~ - - - ° a - « - - 2 > \ \ C. \ \ \ \ \ \ R CO ( cn \ 04 ° \ \ _ § CO e$ e CO / f / § \ c6 w 2 C/) £ 2 % o z CO § W n / \ y p ? m 2 § } 3 / j b � CL 2 5 2 ] ) § 2 § § § . / / q / { § z z 8 0 L) L CL � L z k CO ca ca z ( § # 2 ca caz to n 2 r e LU g (L § j ) x F _ z § � { 3 cn z § ( ( \ 0 k z z z $ z w 2 G ¢ § § > § \ E aoo 2 E - - - o « m pm 04 C14 C14 Lo U | E ¥ \ = 2 . \ k } ( ) } } \ § LU / ) f 2 § m ° ° ° ° = m = m \ # CD /0 2 » # / » / ( \ ) f - } £ ) ) ( , ¢CD § m $ Q $ Q / / 3 n Ln B m o o m o cc)o % / / � 0.cli ' \ cli k < < G § A k§ § 0 / \ § § \ a \ m $ £ — « ® \ k k \ \ \ \ \ 2 _ \ 0 k / ) I ( ( :3 ) ) g g / \ \ g( § \ $ B w LU LU LIJ _ J@ @) It \ ) o t § / & / < Of & ) ) § co ( wuw / w m m a « R y y Q % f EIn a 2 pI | QCq CN 04 § kOD ) \ m U) U� o k ` co co co 00 > ± 22 k / � e / § \ \ [ CD / [ / / \ o — e _ q e _ , e C w o ( 3Q , _ , , co o a M N N N O a n 0 N N N I Q n 0 � N d M Q' r 'U n C � O O N U � N fq _y •� f0 Q. 0 U � N y L U CYi z U n 0 N N CD ,\ O r O N � � W O O Y O U LU Q C U Y n d L d Y iu a U L m A U O �° U U y m m r U C II U U 0 g CITY OF OAK PARK HEIGHTS Journals-Council Report(2) Page: 1 CASH DISBURSEMENTS(CD) Aug 22,2017 03:25PM Period:7/31/2017(07/17) Report Criteria: Journal Code.Journal Code=CD Transaction.GL Account(3 Characters)_{c>}"990" Reference Account Debit Credit Date Number Payee or Description Number Account Title Amount Amount CD 2 07/01/2017 2 RECORD HEALTHPARTNERS PREMIU 101-20970-000 COBRA INS PREMIUM PAYABLE 418.04 RECORD HEALTHPARTNERS PREMIU 101-40690-415 EMPLOYEE HEALTH LIFE&DENTAL 629.98 07/01/2017 2 RECORD HEALTHPARTNERS PREMIU 10140690-415 EMPLOYEE HEALTH LIFE&DENTAL .01- 3 07/01/2017 3 RECORD DELTA DENTAL PREMIUM 101-20970-000 COBRA INS PREMIUM PAYABLE 88.20 1 07/03/2017 1 PSN FEES-JUN 705-48100-212 OTHER CONTRACTUAL SERVICES 41.81 PSN FEES-JUN 70648200-212 OTHER CONTRACTUAL SERVICES 41.80 4 07/20/2017 4 BANK WIRE FEE 101-40600-212 OTHER CONTRACTUAL SERVICES 5.00 Grand Totals: 1,224.83 .01- CITY OF OAK PARK HEIGHTS Journals-TREASURER'S REPORT(2) Page: 1 JOURNAL ENTRIES(JE) Aug 22,2017 03:26PM Period:7/31/2017(07/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 07/31/2017 5 TAX DISTRIBUTION-JUL 901-10900-000 INVESTMENTS-AT PAR 2,885,544.04 07/05/2017 6 WF 16-24 INV Matured-Beal-Plano 901-10900-000 INVESTMENTS-AT PAR 248,000.00- 07/05/2017 6 WF Purchase WF MM 901-10900-000 INVESTMENTS-AT PAR 249,854.90 07/19/2017 6 WF 17-11 Purchase INV FHLM 901-10900-000 INVESTMENTS-AT PAR 500,000.00 07/19/2017 6 WF 17-09 Purchase INV Iberiabank 901-10900-000 INVESTMENTS-AT PAR 245,000.00 07/19/2017 6 WF 17-10 Purchase INV Celtic Bank 901-10900-000 INVESTMENTS-AT PAR 245,000.00 07/20/2017 6 WF 16-30 INV Matured-Mizuho 901-10900-000 INVESTMENTS-AT PAR 245,000.00- 07/20/2017 6 WF Purchase WF MM 901-10900-000 INVESTMENTS-AT PAR 246,715.00 07/20/2017 6 WF 17-12 Purchase INV LCA Bank 901-10900-000 INVESTMENTS-AT PAR 245,000.00 07/21/2017 6 WF 17-13 Purchase INV First Financial 901-10900-000 INVESTMENTS-AT PAR 245,000.00 07/21/2017 6 WF 17-14 Purchase INV United Iowa 901-10900-000 INVESTMENTS-AT PAR 245,000.00 07/21/2017 6 WF Sale of WF MM 901-10900-000 INVESTMENTS-AT PAR 2,225,000.00- 07/24/2017 6 WF 15-23 INV Matured-Synovus 901-10900-000 INVESTMENTS-AT PAR 248,000.00- 07/24/2017 6 WF Purchase WF MM 901-10900-000 INVESTMENTS-AT PAR 249,236.60 07/27/2017 6 WF 17-15 Purchase INV FHLM 901-10900-000 INVESTMENTS-AT PAR 500,000.00 07/31/2017 6 SB Purchase SB MM 901-10900-000 INVESTMENTS-AT PAR 1,987.91 07/31/2017 6 WF Purchase WF MM 901-10900-000 INVESTMENTS-AT PAR 9,601.86 07/31/2017 6 UBS Purchase UBS MM 901-10900-000 INVESTMENTS-AT PAR 1,982.79 07/31/2017 6 Interest on MM 901-10900-000 INVESTMENTS-AT PAR 2,037.43 Grand Totals: 5,871,960.53 2,966,000.00-