Transcription
OMAHA-COUNCIL BLUFFS METROPOLITAN AREA PLANNING AGENCY2222 Cuming Street, Omaha, NE 68102-4328(402) 444-6866FINANCE COMMITTEEAugust 17, 2016 - 8:30 a.m.AGENDAA. MONTHLY FINANCIAL STATEMENTS1.2.3.4.5.(June)Bank Reconciliation (American National Bank) and Statements on InvestmentsReceipts and ExpendituresPreliminary: Schedule of Accounts Receivable/Accounts PayablePreliminary: Consolidated Balance SheetPreliminary: Program Status Report/Line Item Status ReportB. FOR FINANCE COMMITTEE APPROVAL1. Contract Payments:a. Benesch – PMT #45 - 4,721.30b. Benesch – PMT #46 - 2,802.74c. Heartland Family Services – PMT #29 - 2,407.33d. Metro – PMT #4 - 53,256.32e. HDR – PMT #6 - 648.81f. Lovgren – PMT #4 - 3,115.50g. Lovgren – PMT #5 - 34,960.63h. Live Well Omaha – CMAQ – PMT #1 revision - additional 228.16i. Live Well Omaha – CMAQ – PMT #2 - 232.83j. Live Well Omaha – CMAQ – PMT #3 - 803.662. Contract Payments with exceptions:a. Live Well Omaha – Bike Ed – PMT #21 – not to exceed 8,123.17b. Live Well Omaha – Bike Ed – PMT #22 – not to exceed 1,756.403. Contract Amendment:a. Exis Design Group – Extension of Time4. Travela. TRB Tools of the Trade Conference – Charleston, SC – September 11-14, 2016 – 1,431.00 –Josh Corriganb. 2016 NARC Executive Directors Conference – South Bend, INi. Greg Youell – Sept 18-20, 2016 - 1,522.00ii. Rita Sanders – Sept 20-21, 2016 - 868.00
C. RECOMMENDATIONS TO THE BOARD1. Final Payments:a. Douglas County GIS – 21,453.27b. Sarpy County Sewer Study – 10,000.00c. The New BLK – 7,560.00d. TripSpark – 13,536.002. Final Payments with exceptions:a. Metro – not to exceed 22,422.90b. Black Hills Works – not to exceed 8,729.003. Contract Amendments:a. Black Hills Works – increase to 56,166 (a 5,000 increase)4. Travela. Salt Lake City , UT – H2050 Visit – 2 staff, 18 team members – Sept or Oct 30,000.005.Conflict of Interesta. The finance committee will review NDOR’s Conflict of Interest Guidance Document forLPA Officials, Employees & Agents for Local Federal-Aid Transportation Projects and makea recommendation for each board member and MAPA employee to read and sign theConflict of Interest Disclosure Form for LPAs annually.6. Procurement Policya. The finance committee will consider changes to the Procurement Policy and recommendapproval to the board of directors.D. DISCUSSION/INFORMATIONE. OTHERF. ADJOURNMENT
METROPOLITAN AREA PLANNING AGENCYBANK RECONCILIATION STATEMENTJune 2016AMERICAN NATIONAL BANKBalance per bank, June 30, 2016Less: Checks Outstanding (6/30/16) 392,564.8773.69 (73.69)Cash in bank June 30, 2016 392,491.18General Ledger Balance, May 31, 2016 759,564.29Cash Receipts 118,806.45 485,879.56General Ledger Balances, June 30, 2016 392,491.18Less deposits held for other jurisdictions (55,271.91)Available Cash Balance 337,219.27Less:Checks (6/2016)ACH Payroll (6/2016)ACH Federal Payroll TaxesNationwide Payroll ContributionBlue Cross Blue Shield of NE Health Ins.Nebraska State withholding TaxPostaliaBank ChargesQuarterly SUTANebraska Sales taxPay Flex (6/2016)ACH VISA card (6/2016)Auto - Gas/MaintenanceData ProcessingAdobe creative cloud - May 6,2016 - May 5, 2017Blue host - LSBI siteOtherForumsCreighton - H2050 Summit depositOtherSuppliesTelephoneTravel & ConferencesSan Francisco - KarnaCreighton - H2050 Summit depositKeirseyRegistration - American Society of EngineersHilton Kansas City - JeffOtherTransfer to NPAIT-Special ProjectsTransfer to NPAIT-Capitol ReserveWithdrawal to replenish Petty Cash 579,490.99 67,267.19 22,783.36 11,097.68 18,511.00 3,214.71 100.00 33.86 1,006.44 3,866.17 80.78 1,012.76 641.87287.7683.13 550.006.99 556.99 42.28 26.76 2,791.60 1,606.03 137.50 323.04 300.00 266.84 158.19 (222,147.62) 600.00 55.78
STATEMENT ON INVESTMENTTreasury BillsEquityCDDeferred PayrollMoney MarketDeferred PayrollCD9/4/2018Deferred itiesAmerica 100,399.00 100,000.001.350% 7,316.000.010% 101,397.00 100,000.001.650% 1,050.002.100% 106,513.41 103,950.002.100% 1.750%7,316.001,075.8950,804.00Accrued Interest50,000.002,073.23Total 369,578.53NPAIT INVESTMENTSAcct #4/30/16 Beg BalanceGeneralCapitolOrtho hoto)Loan 91.9446,251.63358,126.27City of Blair5/2016 Sponsor Fees5/2016 .0686.55Transfer from Generalchecking NIROCTransfer from Generalchecking JLUSTransfer from Generalchecking Little Steps BigImpact-Transfer from Generalchecking Platte View RdLocal Match--Transfer from GeneralcheckingTransfer from Generalchecking Bike PedAvailable for the Agency(221,547.62)-310,022.28Less Reserve for 4,146.3657,997.7046,256.22136,019.71594,442.27
Metropolitan Area Planning AgencyCash Receipts ReportJune olitan Utilities District592Number432Number 5,000.00Amount6/3/2016CheckCity of Omaha593432 3,703.706/3/2016CheckSaunders County594432 14,809.006/3/2016CheckCass County595432 17,687.676/3/2016Received EFTFEDERAL TRANSIT ADMINISTRATION596433 2,652.006/3/2016Received EFTENVIRONMENTAL PROTECTION AGENCY597433 29,857.666/8/2016CheckNebraska Ethanol Industry Coalition599435 2,200.006/8/2016CheckCity of Fremont600435 10,032.676/8/2016CheckKarna Loewenstein300436 177.686/13/2016Received EFTIOWA DEPARTMENT OF TRANSPORTATION598434 18,937.006/17/2016CheckMetro Transit602438 10.006/17/2016CheckKevin Stratman299441 10.006/22/2016Received EFTNDOR- Bike Education (Live Well)601437 11,222.046/24/2016CheckMetro Transit603439 2,297.036/24/2016CheckPapio - Missouri River NRD297440 10.006/24/2016CheckCity of Ashland298440 200.00 118,806.45Account IDAccount DescriptionGrants10-1100Accounts Receivable No Grants Total Credits10-4350Heartland 2050 Local Revenue16DUES01 200.0010-4500Forums/Annual Dinner16DUES01 20.0010-5900Travel & Conferences16DUES01 88.8410-5900Travel & Conferences16NDOR02 88.84 118,408.77 118,806.45
Metropolitan Area Planning AgencyBank Register Report - Operating AccountJune 6/2/2016AFLAC155986/2/2016Alfred Benesch & Co.155996/2/2016All Makes Office Equipment Co.156006/2/2016CenturyLink 54.16156016/2/2016Christina Brownell 72.25156026/2/2016City of Omaha Cashier156036/2/2016Digital Express156046/2/2016Douglas County GIS156056/2/2016Francotyp-Postalia, Inc.156066/2/2016HDR Engineering Inc. 5,295.90156076/2/2016Heartland Family Services 2,651.99156086/2/2016Matt Roth156096/2/2016Michael Helgerson156106/2/2016One Source The Background Check Co156116/2/2016Payless Office Products, Inc.156126/2/2016PLIC-SBD Grand Island156136/2/2016Sarpy County GIS 5,580.13156146/2/2016Sarpy County Planning 7,920.69156156/2/2016The Daily Record156166/2/2016Toshiba Financial Services156176/2/2016United Healthcare156186/17/2016All Makes Office Equipment Co.156196/17/2016Amanda Morales 36.55156206/17/2016Bishop Business 200.00156216/17/2016Daily Nonpareil 56.50156226/17/2016DAS State Accounting - Central Finance 18.64156236/17/2016Douglas County Treasurer 6266/17/2016First Nebr. Educators Credit U 200.00156286/17/2016Kissel/ E&S Associates L.L.C. 833.33156296/17/2016Matt Roth156306/17/2016Melissa Engel156316/17/2016Metro156326/17/2016Omaha Douglas Public Bldg.Comm156336/17/2016Payless Office Products, Inc.156346/17/2016Pictometry International Corp.156356/17/2016The Daily Record156366/17/2016The Hartford156376/17/2016United Way156386/23/2016Live Well OmahaPayments 292.50 29,857.66 2,129.24 11,073.77 239.12 16,808.67 77.85 33.23 596.90 31.00 86.45 983.27 74.90 592.00 92.86 549.90 25.27 717.09 33.59 28.62 6,990.00 4.00 102.11 462,233.00 40.10 11,518.00 116.25 11,222.04579,490.99
Metropolitan Area Planning AgencyBank Register Report - Operating AccountJune 2016Check Disbursement DetailAdvertisingAuto - Gas/MaintenanceCapital OutlaysContractsCopier Lease/ChargesData ProcessingEmployee Benefits/WithholdingEquipment MaintenanceOffice RentPostagePrepaid InsurancePrintingProfessional ServicesSuppliesTelephoneTravel & 31,470.5672.80705.82579,490.99
Metropolitan Area Planning AgencyPayroll RegisterJune 2016Pay Types/BenefitsHoursAmountER H.I.0.00ER H.I. CH0.00 883.16ER H.I. FA0.00 7,969.68ER H.I. SP 5,652.200.00 2,063.08Hourly687.50 10,185.72Hourly - Reg368.00 7,176.00Life & Dis0.00 388.04Salary0.00 80,502.00Gross PayDeductions/Employee Taxes 97,863.72Gross Benefits 16,956.16Gross Pay/Benefits 114,819.88Adj. GrossAmount457- N/A 700.00457-%N/A 839.82457-Roth N/A 100.00457-Roth%N/A 954.74AFLACN/A 292.52Credit UnionN/A 400.00Dental InsN/A 595.42Flex Plan 16N/A 1,723.44Health InsN/A 1,942.90Life Ins.N/A 4.50Pension LoanN/A 92.78Pension PlanN/A 3,481.72RetirementN/A 141.16United WayN/A 232.50VISIONN/A 92.90Federal86,371.00 8,521.34Medicare93,216.54 1,351.59Soc Security93,216.54 5,779.42State - NEEmployer ExpensesER Pension88,195.00 3,349.78Deductions/Employee Taxes: 30,596.53Adj. GrossN/AAmount 4,787.46Medicare93,216.54 1,351.59Soc Security93,216.54 5,779.42SUTA7,152.60 57.22Additional Employer Expenses: 11,975.69GRAND TOTAL NET PAY: 67,267.19GRAND TOTAL EXPENSE: 126,795.57
Metropolitan Area Planning AgencyAged Accounts Receivable ReportPremilinary-June 30, 2016Aging Balance ForLast Paidcurrent31-6061-90over 90BalanceArchdiocese of OmahaArchdiocese of Omaha7/29/2016 3,396.00 0.00 0.00 0.00 3,396.00 3,396.00 0.00 0.00 0.00 3,396.00City of Ashland 0.00 0.00 5,424.00 0.00 5,424.00Totals for City of Ashland: 0.00 0.00 5,424.00 0.00 5,424.00City of Glenwood 0.00 0.00 0.00 1,000.00 1,000.00Totals for City of Glenwood: 0.00 0.00 0.00 1,000.00 1,000.00Totals for Archdiocese of Omaha:City of AshlandCity of GlenwoodCity of HendersonCity of Henderson7/29/2016Totals for City of Henderson: 1,000.00 0.00 0.00 0.00 1,000.00 1,000.00 0.00 0.00 0.00 1,000.00City of MacedoniaCity of Macedonia3/11/2016Totals for City of Macedonia: 1,499.48 0.00 0.00 0.00 1,499.48 1,499.48 0.00 0.00 0.00 1,499.48 0.00 0.00 0.00 6,000.00 6,000.00 0.00 0.00 0.00 6,000.00 6,000.00 0.00 0.00 12.00 0.00 12.00 0.00 0.00 12.00 0.00 12.00 15,000.00 0.00 0.00 0.00 15,000.00 15,000.00 0.00 0.00 0.00 15,000.00City of OmahaCity of Omaha7/1/2016Totals for City of Omaha:City of PapillionCity of Papillion2/11/2016Totals for City of Papillion:ECONOMIC DEVELOPMENT ADMINISTRATIONECONOMIC DEVELOPMENT ADMINISTRATION8/1/2016Totals for ECONOMIC DEVELOPMENT ADMINISTRATION:ENVIRONMENTAL PROTECTION AGENCYENVIRONMENTAL PROTECTION AGENCY7/1/2016Totals for ENVIRONMENTAL PROTECTION AGENCY: 5,274.42 0.00 0.00 0.00 5,274.42 5,274.42 0.00 0.00 0.00 5,274.42FEDERAL TRANSIT ADMINISTRATIONFEDERAL TRANSIT ADMINISTRATION8/1/2016Totals for FEDERAL TRANSIT ADMINISTRATION: 144,462.00 0.00 131,019.47 44,671.63 320,153.10 144,462.00 0.00 131,019.47 44,671.63 320,153.10 82,345.00 0.00 0.00 1.00 82,346.00 82,345.00 0.00 0.00 1.00 82,346.00IOWA DEPARTMENT OF TRANSPORTATIONIOWA DEPARTMENT OF TRANSPORTATION6/13/2016Totals for IOWA DEPARTMENT OF TRANSPORTATION:Metro TransitMetro Transit8/5/2016 2,484.32 0.00 0.00 0.00 2,484.32 2,484.32 0.00 0.00 0.00 2,484.32Michael Felschow 14.36 0.00 0.00 0.00 14.36Totals for Michael Felschow: 14.36 0.00 0.00 0.00 14.36 0.00 0.00 17,961.67 0.00 17,961.67 0.00 0.00 17,961.67 0.00 17,961.67Totals for Metro Transit:Michael FelschowMills CountyMills County7/22/2016Totals for Mills County:NDOR- Bike Education (Live Well)NDOR- Bike Education (Live Well)Totals for NDOR- Bike Education (Live Well):7/12/2016 1,329.51 0.00 0.00 0.00 1,329.51 1,329.51 0.00 0.00 0.00 1,329.51
Metropolitan Area Planning AgencyAged Accounts Receivable ReportPremilinary-June 30, 2016Aging Balance ForLast Paidcurrent31-6061-901/11/2016over 90Balance 0.00 0.00 0.00 399.70 399.70 0.00 0.00 0.00 399.70 399.70NDOR- STPNDOR- STPTotals for NDOR- STP:NDORNDOR7/12/2016Totals for NDOR: 145,653.64 0.00 267,997.56 0.00 413,651.20 145,653.64 0.00 267,997.56 0.00 413,651.20 50,000.00 0.00 0.00 0.00 50,000.00 50,000.00 0.00 0.00 0.00 50,000.00Peter Kiewit FoundationPeter Kiewit Foundation7/14/2016Totals for Peter Kiewit Foundation:Pottawattamie County, IowaPottawattamie County, Iowa7/1/2016Totals for Pottawattamie County, Iowa: 1,684.88 0.00 0.00 0.00 1,684.88 1,684.88 0.00 0.00 0.00 1,684.88 427.70 0.00 0.00 0.00 427.70 427.70 0.00 0.00 0.00 427.70 0.00 0.00 35,000.00 0.00 35,000.00 0.00 0.00 35,000.00 0.00 35,000.00 454,571.31 0.00 457,414.70 52,072.33 964,058.34Ron KohnRon Kohn7/29/2016Totals for Ron Kohn:Sarpy CountySarpy CountyTotals for Sarpy County:7/14/2016
Metropolitan Area Planning AgencyAged Accounts Payable ReportPreliminary - June 30, 2016Vendor NameTrans. No.Description711343Monthly Premiumscurrent31-6061-90over 90Net DueAFLACAFLACTotals for AFLAC: 292.50 0.00 0.00 0.00 292.50 292.50 0.00 0.00 0.00 292.50Alfred Benesch & Co.Alfred Benesch & Co.93508 0.00 127.15 0.00 0.00 127.15Alfred Benesch & Co.93509 0.00 5,147.27 0.00 0.00 5,147.27Alfred Benesch & Co.94561 339.24 0.00 0.00 0.00 339.24Alfred Benesch & Co.94564 4,382.06 0.00 0.00 0.00 4,382.06Alfred Benesch & Co.95455Totals for Alfred Benesch & Co.: 2,802.74 0.00 0.00 0.00 2,802.74 7,524.04 5,274.42 0.00 0.00 12,798.46Amanda MoralesAmanda Morales072116Lunch - Payroll SeminarTotals for Amanda Morales: 30.31 0.00 0.00 0.00 30.31 30.31 0.00 0.00 0.00 30.31BenefitPlansInc.BenefitPlansInc.12911Deferred CompensationBenefitPlansInc.12912Pension PlanTotals for BenefitPlansInc.: 87.50 0.00 0.00 0.00 87.50 552.50 0.00 0.00 0.00 552.50 640.00 0.00 0.00 0.00 640.00 2,712.77Bishop BusinessBishop Business344551 2,712.77 0.00 0.00 0.00Bishop Business345959 300.00 0.00 0.00 0.00 300.00Totals for Bishop Business: 3,012.77 0.00 0.00 0.00 3,012.77 0.00 10,063.00 0.00 0.00 10,063.00Totals for Black Hills Works Inc: 0.00 10,063.00 0.00 0.00 10,063.00 471.90 0.00 0.00 0.00 471.90Totals for Caring People Sudan: 471.90 0.00 0.00 0.00 471.90 54.16 0.00 0.00 0.00 54.16Totals for CenturyLink: 54.16 0.00 0.00 0.00 54.16Black Hills Works IncBlack Hills Works IncAR 3130Caring People SudanCaring People Sudan061616Translation ServicesCenturyLinkCenturyLink06072016
Metropolitan Area Planning AgencyAged Accounts Payable ReportPreliminary - June 30, 2016Vendor NameTrans. No.Descriptioncurrent31-6061-90over 90Net DueCity of Omaha CashierCity of Omaha Cashier16-9 0.00 6,113.46 0.00 0.00 6,113.46City of Omaha Cashier16-10 0.00 13,272.35 0.00 0.00 13,272.35 0.00 19,385.81 0.00 0.00 19,385.81Totals for City of Omaha Cashier:Court BarberCourt Barber063016Title VI Training Expenses - moved to FY2016 88.23 0.00 0.00 0.00 88.23 0.00 0.00 0.00 88.23Totals for Court Barber: 88.23 11,555.36 0.00 0.00 0.00 11,555.36Totals for Court Barber: 11,555.36 0.00 0.00 0.00 11,555.36 21.75Credit Card PayableCredit Card Payable063016Cross Dillion Tire OmahaCross Dillion Tire Omaha6379972Flat Repair 0.00 21.75 0.00 0.00Cross Dillion Tire Omaha6381382Flat Repair 21.75 0.00 0.00 0.00 21.75Totals for Cross Dillion Tire Omaha: 21.75 21.75 0.00 0.00 43.50 54.80 0.00 0.00 0.00 54.80Totals for Daily Nonpareil: 54.80 0.00 0.00 0.00 54.80 23.25 0.00 0.00 0.00 23.25Totals for DAS State Accounting - Central Finance: 23.25 0.00 0.00 0.00 23.25Daily NonpareilDaily Nonpareil062616DAS State Accounting - Central FinanceDAS State Accounting - Central Finance1015889DearBorn National Life Insurance CompanyDearBorn National Life Insurance Company7-1-16 - 9-30-16 13.50 0.00 0.00 0.00 13.50Totals for DearBorn National Life Insurance Company:061716 13.50 0.00 0.00 0.00 13.50Douglas County TreasurerDouglas County Treasurer2192FuelDouglas County Treasurer33293Printing 109.50 0.00 0.00 0.00 109.50 30.00 0.00 0.00 0.00 30.00Douglas County TreasurerDouglas County Treasurer4447 397.48 0.00 0.00 0.00 397.482233 105.51 0.00 0.00 0.00 105.51 642.49 0.00 0.00 0.00 642.49Totals for Douglas County Treasurer:
Metropolitan Area Planning AgencyAged Accounts Payable ReportPreliminary - June 30, 2016Vendor NameDescriptionTrans. No.current31-6061-90over 90Net DueFedExFedEx5-480-01306Totals for FedEx: 25.67 0.00 0.00 0.00 25.67 25.67 0.00 0.00 0.00 25.67FirespringFirespring199277Chuck's Business CardsTotals for Firespring: 33.00 0.00 0.00 0.00 33.00 33.00 0.00 0.00 0.00 33.00First Nebr. Educators Credit UFirst Nebr. Educators Credit U0615166-15-16 Payroll ContributionTotals for First Nebr. Educators Credit U: 200.00 0.00 0.00 0.00 200.00 200.00 0.00 0.00 0.00 200.00Greg YouellGreg Youell7-7-16Greg Youell070716Totals for Greg Youell: 51.99 0.00 0.00 0.00 51.99 1,172.35 0.00 0.00 0.00 1,172.35 1,224.34 0.00 0.00 0.00 1,224.34 2,530.90Heartland Family ServicesHeartland Family ServicesAPR2016 0.00 0.00 2,530.90 0.00Heartland Family ServicesMAY2016 2,406.97 0.00 0.00 0.00 2,406.97Heartland Family ServicesJUN2016 2,407.33 0.00 0.00 0.00 2,407.33 4,814.30 0.00 2,530.90 0.00 7,345.20Totals for Heartland Family Services:Intercultural Senior CenterIntercultural Senior Center040116 0.00 0.00 3,280.62 0.00 3,280.62Intercultural Senior Center063016 5,196.20 0.00 0.00 0.00 5,196.20 5,196.20 0.00 3,280.62 0.00 8,476.82Totals for Intercultural Senior Center:Jeff SpiehsJeff Spiehs062316Kansas City TripTotals for Jeff Spiehs: 99.99 0.00 0.00 0.00 99.99 99.99 0.00 0.00 0.00 99.99 56.64 0.00 0.00 0.00 56.64 56.64 0.00 0.00 0.00 56.64Karna LoewensteinKarna Loewenstein072116Staff retreat materials and mileageTotals for Karna Loewenstein:
Metropolitan Area Planning AgencyAged Accounts Payable ReportPreliminary - June 30, 2016Vendor NameTrans. No.Descriptioncurrent31-6061-90over 90Net DueLilia FrancisconyLilia FrancisconyMAPA-2016-03Totals for Lilia Franciscony: 0.00 124.96 0.00 0.00 124.96 0.00 124.96 0.00 0.00 124.96Live Well OmahaLive Well Omaha16 0.00 1,329.51 0.00 0.00 1,329.51Live Well Omaha17 1,300.96 0.00 0.00 0.00 1,300.96 1,300.96 1,329.51 0.00 0.00 2,630.47Totals for Live Well Omaha:Lovgren Marketing GroupLovgren Marketing Group18398 0.00 4,341.94 0.00 0.00 4,341.94Lovgren Marketing Group18445 0.00 4,136.20 0.00 0.00 4,136.20Lovgren Marketing Group18445-BLovgren Marketing Group18700Transposed NumbersTotals for Lovgren Marketing Group: 0.00 27.00 0.00 0.00 27.00 15,965.00 0.00 0.00 0.00 15,965.00 15,965.00 8,505.14 0.00 0.00 24,470.14Mahoney State ParkMahoney State Park325280687Parking 25.00 0.00 0.00 0.00 25.00Totals for Mahoney State Park: 25.00 0.00 0.00 0.00 25.00 52.42 0.00 0.00 0.00 52.42Totals for Matt Roth: 52.42 0.00 0.00 0.00 52.42 9.52 0.00 0.00 0.00 9.52Totals for Megan Walker: 9.52 0.00 0.00 0.00 9.52Matt RothMatt Roth062316Megan WalkerMegan Walker062816Meineke Car Care CenterMeineke Car Care Center329026 54.89 0.00 0.00 0.00 54.89Meineke Car Care Center329129 28.95 0.00 0.00 0.00 28.95Totals for Meineke Car Care Center: 83.84 0.00 0.00 0.00 83.84 0.00 0.00 0.00 44,671.53 44,671.53Totals for Metro: 0.00 0.00 0.00 44,671.53 44,671.53MetroMetro31344
Metropolitan Area Planning AgencyAged Accounts Payable ReportPreliminary - June 30, 2016Vendor NameTrans. No.Descriptioncurrent31-6061-90over 90Net DueOlsson AssociatesOlsson Associates252964Totals for Olsson Associates: 0.00 14,677.16 0.00 0.00 14,677.16 0.00 14,677.16 0.00 0.00 14,677.16Pictometry International Corp.Pictometry International Corp.SI036566Training for Lincoln PersonelTotals for Pictometry International Corp.: 4,330.00 0.00 0.00 0.00 4,330.00 4,330.00 0.00 0.00 0.00 4,330.00Pottawattamie County GISPottawattamie County GIS20160407Pottawattamie County GIS063016Totals for Pottawattamie County GIS: 0.00 0.00 14,787.16 0.00 14,787.16 3,820.03 0.00 0.00 0.00 3,820.03 3,820.03 0.00 14,787.16 0.00 18,607.19Rita SandersRita Sanders072216NARC expensesTotals for Rita Sanders: 106.99 0.00 0.00 0.00 106.99 106.99 0.00 0.00 0.00 106.99River City GlassRiver City Glass43039Rock Chip RepairTotals for River City Glass: 0.00 0.00 0.00 69.95 69.95 0.00 0.00 0.00 69.95 69.95Ron KohnRon Kohn072616NARC expenses 152.16 0.00 0.00 0.00 152.16Totals for Ron Kohn: 152.16 0.00 0.00 0.00 152.16 6,589.92 0.00 0.00 0.00 6,589.92Totals for Sarpy County Planning: 6,589.92 0.00 0.00 0.00 6,589.92 750.00 0.00 0.00 0.00 750.00 750.00 0.00 0.00 0.00 750.00Sarpy County PlanningSarpy County Planning2016-4Somali Bantu Association of NebraskaSomali Bantu Association of Nebraska2Translation ServicesTotals for Somali Bantu Association of Nebraska:Standard Printing CompanyStandard Printing Company86490Totals for Standard Printing Company: 331.40 0.00 0.00 0.00 331.40 331.40 0.00 0.00 0.00 331.40
Metropolitan Area Planning AgencyAged Accounts Payable ReportPreliminary - June 30, 2016Vendor NameTrans. No.Descriptioncurrent31-6061-90over 90Net DueSteve JensenSteve Jensen143 0.00 3,737.50 0.00 0.00 3,737.50Steve Jensen156 1,625.00 0.00 0.00 0.00 1,625.00 1,625.00 3,737.50 0.00 0.00 5,362.50Totals for Steve Jensen:Steve PlattSteve Platt1028Phone system expansionTotals for Steve Platt: 1,289.00 0.00 0.00 0.00 1,289.00 1,289.00 0.00 0.00 0.00 1,289.00The Daily RecordThe Daily Record140604Meeting Notice 19.10 0.00 0.00 0.00 19.10The Daily Record140502CTC/TTAC Meeting Notice 25.70 0.00 0.00 0.00 25.70The Daily Record140882 20.30 0.00 0.00 0.00 20.30Totals for The Daily Record: 65.10 0.00 0.00 0.00 65.10 592.00 0.00 0.00 0.00 592.00Totals for Toshiba Financial Services: 592.00 0.00 0.00 0.00 592.00Toshiba Financial ServicesToshiba Financial Services65023344United States Postal ServiceUnited States Postal Service062316Bulk Mail Account ReplenishmentTotals for United States Postal Service: 342.73 0.00 0.00 0.00 342.73 342.73 0.00 0.00 0.00 342.73United WayUnited Way0615166-15-16 Payroll Contribution 116.25 0.00 0.00 0.00 116.25Totals for United Way: 116.25 0.00 0.00 0.00 116.25 83.94 0.00 0.00 0.00 83.94Totals for Verizon: 83.94 0.00 0.00 0.00 83.94GRAND TOTALS: 73,706.46 63,119.25 20,598.68 44,741.48 202,165.87VerizonVerizon9767259668A total of 72 transaction(s) listed
Metropolitan Area Planning AgencyBalance SheetPreliminay - June 30, 2016ActualAssets10-1000Petty Cash 87.5810-1005Paypal Account 20.7610-1007Undeposited Funds10-1010Cash - American National Bank10-1030Treasury Bills 369,578.5310-1040NPAIT Investments General 306,133.2810-1045NPAIT Investments Capitol Reserve10-1050NPAIT Investments Ortho Quads10-1100Accounts Receivable 964,058.3410-1110Due To/Due From Funds( 40,191.64)10-1300Prepaid Expenses 17,167.0310-1310Prepaid Insurance 11,741.0911-1110Due To/Due From Funds( 5,559.87)12-1055NPAIT Investments Revolving Loan13-1200Furniture, Fixtures & Equipment 117,949.6213-1220Less: Accumulated Depreciation 51,373.7615-1040NPAIT Investments General15-1045NPAIT Investments Special Projects15-1110Due To/Due From Funds 42,209.4920-1020Cash - ANB Foundation 47,920.1520-1060NPAIT Investments Foundation20-1065NPAIT Investments FD NDO 109,146.2320-1070NPAIT Investments FD Washington County Revolving Loan Fund 158,837.1120-1110Due To/Due From Funds20-1410Note Receivable Grapel20-1425Note Receivable KB Quality MeatsTotal Assets 19,933.24 392,491.18 44,146.36 57,997.70 46,256.22 3,889.00 136,019.71 32,870.42 3,542.02 235,997.62 19,636.00 3,040,503.41Liabilities and Fund BalanceLiabilities10-2000Accounts Payable10-2105Nebraska Withholding10-2130Flex W/H Payable10-2160SUTA Tax10-2200Accrued Payroll 43,038.5410-2210Accrued Compensated Absences 78,228.2510-2220Accrued Audit Fees10-2400Deferred Revenue( 10,000.00)10-2420Deferred Ortho. Photography 214,124.9920-2000Accounts Payable20-2430Deferred Revolving Loan 287,619.3420-2500Note Payable Invest NE 235,997.62Total Liabilities 201,884.64 3,349.78( 520.62) 121.65 10,600.00 281.03 1,064,725.22
Metropolitan Area Planning AgencyBalance SheetPreliminay - June 30, 2016Fund Balance10-3000Fund Balance Undesignated10-3010Fund Balance Assigned10-3020Fund Balance Committed11-3000Fund Balance Undesignated( 5,559.87)12-3100Fund Balance Restricted 46,256.2213-3005Invested in Capital Assets15-3010Fund Balance Assigned20-3000Fund Balance UndesignatedTotal Fund BalanceTotal Liabilities and Fund Balance 1,176,233.15 71,103.07 355,000.00 66,575.86 182,118.20 84,051.56 1,975,778.19 3,040,503.41
Metropolitan Area Planning AgencyIncome StatementPreliminary - June 30, 20166/1/16-6/30/167/1/15-6/30/16% toAdjustedActualBudgetActual YTDFY 2016AdjustedYTDVariance toAdjustedBudget YTDBudgetYTD BudgetBudgetRevenues10-4100Federal Revenue 371,874.05 866,367.50 1,966,781.03 3,403,005.0057.80% 1,436,223.9710-4200State Revenue 0.00 0.00 11,764.71 12,000.0098.04% 235.2910-4300Local Revenue 0.00 0.00 403,599.00 358,352.00112.63%10-4310Match Contributions10-4350Heartland 2050 Local Revenue10-4400Contracts10-4410Pass Through Contracts - Planning 0.0010-4420Pass Through Contracts - STP 0.0010-4500Forums/Annual Dinner 22.0010-4510In-Kind Revenue10-4520Investment Earnings10-4530( 45,247.00) 3,403,005.00 12,000.00 358,352.00 0.00 3,693.90 0.00 60,875.000.00% 60,875.00 60,875.00 200.00 0.00 31,700.00 157,000.0020.19% 125,300.00 157,000.00 14,862.05 494,652.00 93,126.55 659,536.0014.12% 566,409.45 659,536.00 64,091.00 0.00 256,364.000.00% 256,364.00 256,364.00 15,720.00 0.00 62,880.000.00% 62,880.00 62,880.00 0.00 4,891.09 22,000.0022.23% 17,108.91 22,000.00 14,536.62 68,470.25 231,809.27 273,881.0084.64% 42,071.73 273,881.00 847.94 0.00 11,857.98 0.000.00%( 11,857.98) 0.00Misc. Cash Sales 1,000.00 0.00 3,860.70 0.000.00%( 3,860.70) 0.0010-4540Miscellaneous 1,007.64 0.00 4,420.76 0.000.00%( 4,420.76) 0.0015-4300Local Revenue 466,563.00 0.00 497,563.00 0.000.00%( 497,563.00) 0.0015-4520Investment Earnings 41.06 0.00 93.26 0.000.00%( 93.26) 0.0015-4540MiscellaneousTotal Revenues 50,000.00 0.00 128,450.00 0.000.00% 920,954.36 1,512,994.65 3,389,917.35 5,265,893.0064.38% 1,875,975.65( 128,450.00) 5,265,893.00 0.00 131,180.05 85,533.75 946,561.22 1,026,405.0092.22% 79,843.78 1,026,405.00 0.00 416.67 0.00 5,000.000.00% 5,000.00 5,000.00 7,131.01 6,750.54 78,411.98 81,000.0096.80% 2,588.02 81,000.00Expenses10-5000Salaries10-5010Outside Office Help10-5100FICA10-5105Unemployment Taxes10-5110Health Insurance10-5115Life & Disability Insurance10-5120Retirement Contributions10-5125Accrued Salaries & Compensated Absences10-5200Advertising10-5210Membership - Reference Materials10-5220Printing10-5300Business Insurance Expense10-5310Data Processing10-5320Professional Services10-5400Contracts 63.67 0.00 1,545.47 3,000.0051.52% 1,454.53 3,000.00 24,581.41 18,333.34 191,602.34 220,000.0087.09% 28,397.66 220,000.00 581.43 416.67 4,687.68 5,000.0093.75% 312.32 5,000.00 4,787.46 5,000.00 50,252.48 60,000.0083.75% 9,747.52 60,000.00 18,321.46 15,411.09 169,951.82 184,933.0091.90% 14,981.18 184,933.00 160.00 2,125.00 3,323.05 8,500.0039.09% 5,176.95 8,500.00 718.02 641.20 16,441.01 20,000.0082.21% 3,558.99 20,000.00 2,716.24 2,296.14 32,522.18 33,000.0098.55% 477.82 33,000.00 820.94 1,250.00 10,733.99 15,000.0071.56% 4,266.01 15,000.00 5,250.63 2,916.67 32,917.10 35,000.0094.05% 2,082.90 35,000.00 2,952.98 1,700.00 28,921.04 34,000.0085.06% 5,078.96 34,000.00 46,824.57 317,804.75 853,680.50 1,257,469.0067.89% 403,788.50 1,257,469.00
Metropolitan Area Planning AgencyIncome StatementPreliminary - June 30, 20166/1/16-6/30/167/1/15-6/30/16% toAdjustedActualBudgetActual YTDFY 2016AdjustedYTDVariance toBudget YTDBudgetYTD BudgetAdjustedBudget10-5420Pass Through Contracts - Planning 0.00 428,943.75 0.00 1,740,775.000.00% 1,740,775.00 1,740,775.0010-5440In-Kind Expense10-5500Equipment Maintenance 14,536.62 68,470.25 231,809.27 273,881.0084.64% 42,071.73 273,881.00 352.21 729.17 3,252.03 8,750.0037.17% 5,497.9710-5600Forums 8,750.00 667.67 7,423.60 19,202.74 40,000.0048.01% 20,797.26 40,000.0010-5650Miscellaneous Expenses 0.00 125.00 744.26 1,500.0049.62% 755.74 1,500.0010-5700Postage 235.21 416.67 3,449.75 5,000.0069.00% 1,550.25 5,000.0010-5710Supplies 684.20 1,541.67 9,205.11 18,500.0049.76% 9,294.89 18,500.0010-5730Bank Charges 33.86 41.67 437.38 500.0087.48% 62.62 500.0010-5800Office Rent 5,640.00 5,640.00 67,680.00 67,680.00100.00% 0.00 67,680.0010-5810Telephone 128.33 208.34 1,235.82 2,500.0049.43% 1,264.18 2,500.0010-5900Travel & Conferences 6,694.59 4,583.34 57,835.85 55,000.00105.16%( 2,835.85) 55,000.0010-5950Capital Outlays 2,678.89 3,791.67 31,977.10 45,500.0070.28% 13,522.90 45,500.0010-8000Transfers 0.00 1,500.00 0.00 18,000.000.00% 18,000.00 18,000.0015-5400Contracts 466,563.00 0.00 466,563.00 0.000.00%Total Expenses 744,304.45 984,010.95 3,314,944.17 5,265,893.0062.95%NET SURPLUS/(DEFICIT) 176,649.91 528,983.70 74,973.18 0.000.00%( 466,563.00) 1,950,948.83( 74,973.18) 0.00 5,265,893.00 0.00
METROPOLITAN AREA PLANNING AGENCY2222 Cuming StreetOmaha, Nebraska 68102Subcontractors Payment AuthorizationContractor:Heartland Family ServicesContract Approved by Board of Directors: May 2014Contract Amount of: 161,350Payment # 291.Computation of PaymentBill to DateLess Previous Payments 150,554.99148,147.66Payment Due this Date2. 2,407.33Payment ApprovedRECOMMENDED PAYMENT BY:Responsible Charge/Staff MemberProgram DirectorExecutive DirectorPayment approved by Finance CommitteeTreasurer
Progress ReportTitle: Heartland Family Service- Ways to WorkDate: 06/1/2016 –06/30/2016Title: MAPA bill 2,407.33out of 161,3501. Work Completed for Current Bill.ng Period:a. The Ways to Work program saw 1 loan paid in full during this cycle. We continue to see thebenefits both in employment as well as financial stability with the payment in full of theautomotive loan.2. Anticipated Work for Next Billing Period:a. Same as prior month3. Information Needed from FTA/MAPA:a. No information is needed.4. Percent of Work Completed to Date:a. 93% of grant utilized5. Outstanding Issues:Data1. Number of repossessions in the month (bought back loans)a. 02. Number of new closed loans in the montha. 03. Number of loa
OMAHA-COUNCIL BLUFFS METROPOLITAN AREA PLANNING AGENCY 2222 Cuming Street, Omaha, NE 68102-4328 . Hilton Kansas City - Jeff 266.84 Other 158.19 Transfer to NPAIT-Capitol Reserve 600.00 . America Deferred Payroll Money Market Securities America Deferred Payroll CD 9/4/2018 Securities America Deferred Payroll CD 7/23/2019 Securities .
