Civic Intelligence

Public Works Industry Improvement Program Inc

990EZ • Fiscal year 2016 • EIN 39-6127164

Dec 01, 2015 to Nov 30, 2016 • Filed on May 23, 2017

Organization ProfileN/A
N16 W23250 Stone Ridge DriveWaukesha, WI 53188

(414) 778-1050

Siviq Scores

Precomputed percentiles for this filing year versus similar nonprofits in the same peer cohort.

Liabilities / Assets

51st percentile

0.01x

Higher debt load relative to assets than 51% of similar nonprofits.

2016 filings • 501(c)6 • <$500k nonprofits • Source year 2016

Liabilities / Revenue

55th percentile

0.01x

Higher debt load relative to revenue than 55% of similar nonprofits.

2016 filings • 501(c)6 • <$500k nonprofits • Source year 2016

Net Margin

9th percentile

-31%

Higher net margin than 9% of similar nonprofits.

2016 filings • 501(c)6 • <$500k nonprofits • Source year 2016

Top Officer Pay

94th percentile

$85,374

Higher top officer pay than 94% of similar nonprofits.

Top officer pay equals 67.1% of source-year revenue.

2016 filings • 501(c)6 • <$500k nonprofits • Source year 2016

Asset Growth

20th percentile

-16%

Faster asset growth than 20% of similar nonprofits.

2016 filings • 501(c)6 • <$500k nonprofits • Annualized from 2015 to 2016

Revenue Growth

23rd percentile

-14%

Faster revenue growth than 23% of similar nonprofits.

2016 filings • 501(c)6 • <$500k nonprofits • Annualized from 2015 to 2016

Balance Sheet
Liabilities / Assets51st percentile

Assets

Down

$215,555

Down $40,665 (-16%) from 2015

Net Assets

Down

$214,337

Down $38,876 (-15%) from 2015

Liabilities

Down

$1,218

Down $1,789 (-59%) from 2015

Revenue And Expenses
Liabilities / Revenue55th percentileNet Margin9th percentile

Revenue

Down

$127,186

Down $20,162 (-14%) from 2015

Expenses

Up

$166,062

Up $35,495 (+27%) from 2015

Net Income

Down

-$38,876

Down $55,657 (-332%) from 2015

Historical Trend

Balance Sheet Trend

Asset Growth20th percentile

The highlighted filing sits inside the broader history for assets, liabilities, and net assets.

$400K$300K$200K$100K$0Assets 2010: $270,751Liabilities 2010: $8,776Net Assets 2010: $261,9752010Assets 2011: $231,187Liabilities 2011: $2,9452011Assets 2012: $230,643Liabilities 2012: $21,036Net Assets 2012: $209,6072012Assets 2013: $235,937Liabilities 2013: $1,128Net Assets 2013: $234,8092013Assets 2014: $236,627Liabilities 2014: $195Net Assets 2014: $236,4322014Assets 2015: $256,220Liabilities 2015: $3,007Net Assets 2015: $253,2132015Assets 2016: $215,555Liabilities 2016: $1,218Net Assets 2016: $214,3372016Assets 2017: $195,057Liabilities 2017: $20,601Net Assets 2017: $174,4562017Assets 2018: $225,287Liabilities 2018: $32,0032018Assets 2019: $246,419Liabilities 2019: $52,229Net Assets 2019: $194,1902019Assets 2020: $255,133Liabilities 2020: $57,044Net Assets 2020: $198,0892020Assets 2021: $321,580Liabilities 2021: $107,2872021Assets 2022: $323,201Liabilities 2022: $98,280Net Assets 2022: $224,9212022Assets 2023: $285,820Liabilities 2023: $68,0032023

Highlighted filing

2016

Assets$215,555
Liabilities$1,218
Net Assets$214,337
Open 2016 Filing

Operations Trend

Revenue Growth23rd percentile

Revenue, expenses, and net income across loaded years, with this filing highlighted.

$300K$200K$100K$0-$100KRevenue 2010: $154,472Expenses 2010: $232,849Net Income 2010: -$78,3772010Revenue 2011: $126,992Expenses 2011: $160,725Net Income 2011: -$33,7332011Revenue 2012: $135,355Expenses 2012: $153,990Net Income 2012: -$18,6352012Revenue 2013: $160,276Expenses 2013: $135,074Net Income 2013: $25,2022013Revenue 2014: $148,634Expenses 2014: $147,011Net Income 2014: $1,6232014Revenue 2015: $147,348Expenses 2015: $130,567Net Income 2015: $16,7812015Revenue 2016: $127,186Expenses 2016: $166,062Net Income 2016: -$38,8762016Revenue 2017: $108,879Expenses 2017: $148,760Net Income 2017: -$39,8812017Revenue 2018: $160,476Expenses 2018: $141,649Net Income 2018: $18,8272018Revenue 2019: $138,135Expenses 2019: $137,229Net Income 2019: $9062019Revenue 2020: $144,226Expenses 2020: $140,327Net Income 2020: $3,8992020Revenue 2021: $158,108Expenses 2021: $141,904Net Income 2021: $16,2042021Revenue 2022: $150,535Expenses 2022: $139,907Net Income 2022: $10,6282022Revenue 2023: $148,125Expenses 2023: $155,229Net Income 2023: -$7,1042023

Highlighted filing

2016

Revenue$127,186
Expenses$166,062
Net Income-$38,876
Open 2016 Filing
Jump To
Filing Snapshot
Filing Period
Dec 1, 2015 to Nov 30, 2016
Signed
May 23, 2017
Return Version
2015v3.0
Gross Receipts
$127,186
Mission and Program Overview

Mission

Provide the leadership and financial support to promote the advancement of the public works and utility construction industries in se wisconsin.

Provide the leadership and financial support to promote the advancement of the public works and utility construction industries in southeast wisconsin.

Program Services

DescriptionGrantsExpenses
INDUSTRY IMPROVEMENT & PROMOTION, CLEAN WATER CONSTRUCTION COALITION AND BID PREFERENCE ORDINANCE$0$2,006
Compensation and Service Providers
Top Officer Pay94th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
ROBERT BARTELExecutive DirectorPT$73,642$11,732$85,374
CW PURPERODirector-$0--
THOMAS SCHAITELVice President-$0--
PETER SCHRAUFNAGELPresident-$0--
JOHN WANASEKDirector-$0--
PHIL PURPERODirector-$0--
ROBERT OLSONSec/Treasurer-$0--
Filing and Contact Details

Filer

Filer Name
Public Works Industry Improvement
EIN
39-6127164
Phone
4147781050
Address
N16 W23250 STONE RIDGE DRIVE, WAUKESHA, WI 53188

Signing Officer

Name
Robert Bartel
Title
Executive Director
Phone
4147781050
Signed
2017-05-23
Discuss with paid preparer
Yes

Preparer

Firm
Freyberg Hinkle Ashland Powers & Stowell
Address
15420 W CAPITOL DR, BROOKFIELD, WI 53005-2621
Preparer
Thomas M Powers CPA
Phone
2627846210
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 4 - Other Investment Income

“Description: interest income. Amount: 76.”

Form 990-ez, Part I, Line 16 - Other Expenses

“Description: auto expense. Amount: 3706. Description: office supplies and expense. Amount: 2978. Description: insurance. Amount: 3945. Description: depreciation . Amount: 118. Description: miscellaneous - programs. Amount: 1162. Description: conventions, meetings & seminars. Amount: 314. Description: dues and subscriptions. Amount: 817. Description: scholarships awarded. Amount: 1000. Description: payroll taxes. Amount: 7397. Total to form 990-ez, line 16: 21437.”

Form 990-ez, Part II, Line 24 - Other Assets

“Description: accounts receivable. Beg. Of year amount: 58840. End of year amount: 37587. Description: specification books. Beg. Of year amount: 8575. End of year amount: 7951.”

Form 990-ez, Part II, Line 26 - Other Liabilities

“Description: accounts payable. Beg. Of year amount: 2836. End of year amount: 980. Description: accrued expenses & other liabilities. Beg. Of year amount: 171. End of year amount: 238.”

Raw XML Appendix139 raw XML fields

This appendix keeps the raw XML leaves available for debugging and edge-case review. The human report above is the primary experience.

Path#Value
IRS990EZ/ActivitiesNotPreviouslyRptInd00
IRS990EZ/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt0ROBERT BARTEL
IRS990EZ/BooksInCareOfDetail/PhoneNum04147781050
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0N16 W23250 STONE RIDGE DRIVE
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0WAUKESHA
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0WI
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd053188
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0188411
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0169741
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd00
IRS990EZ/DirectIndirectPltclExpendAmt00
IRS990EZ/DonorAdvisedFndsInd00
IRS990EZ/ExcessOrDeficitForYearAmt0-38876
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt05275
IRS990EZ/ForeignFinancialAccountInd00
IRS990EZ/ForeignOfficeInd00
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0256220
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0215555
IRS990EZ/GrossReceiptsAmt0127186
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt076
IRS990EZ/LandAndBuildingsGrp/BOYAmt0394
IRS990EZ/LandAndBuildingsGrp/EOYAmt0276
IRS990EZ/MadeLoansToFromOfficersInd00
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0253213
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0214337
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0253213
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0214337
IRS990EZ/OccupancyRentUtltsAndMaintAmt011300
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt024.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt10.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt20.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt30.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt40.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt50.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt60.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt073642
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt011732
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0ROBERT BARTEL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1CW PURPERO
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2THOMAS SCHAITEL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3PETER SCHRAUFNAGEL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4JOHN WANASEK
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5PHIL PURPERO
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm6ROBERT OLSON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0EXECUTIVE DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2VICE PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6SEC/TREASURER
IRS990EZ/OperateHospitalInd00
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd00
IRS990EZ/OrganizationHadUBIInd00
IRS990EZ/OtherAssetsTotalDetail/BOYAmt067415
IRS990EZ/OtherAssetsTotalDetail/EOYAmt045538
IRS990EZ/OtherChangesInNetAssetsAmt00
IRS990EZ/OtherExpensesTotalAmt021437
IRS990EZ/PoliticalCampaignActyInd00
IRS990EZ/PrimaryExemptPurposeTxt0PROVIDE THE LEADERSHIP AND FINANCIAL SUPPORT TO PROMOTE THE ADVANCEMENT OF THE PUBLIC WORKS AND UTILITY CONSTRUCTION INDUSTRIES IN SOUTHEAST WISCONSIN.
IRS990EZ/PrintingPublicationsPostageAmt02392
IRS990EZ/ProgramServiceRevenueAmt0127110
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0INDUSTRY IMPROVEMENT & PROMOTION, CLEAN WATER CONSTRUCTION COALITION AND BID PREFERENCE ORDINANCE
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt00
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt02006
IRS990EZ/ProhibitedTaxShelterTransInd00
IRS990EZ/RelatedOrganizationCtrlEntInd00
IRS990EZ/SalariesOtherCompEmplBnftAmt0125658
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SubjectToProxyTaxInd00
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt03007
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt01218
IRS990EZ/TanningServicesProvidedInd00
IRS990EZ/TotalExpensesAmt0166062
IRS990EZ/TotalProgramServiceExpensesAmt02006
IRS990EZ/TotalRevenueAmt0127186
IRS990EZ/TypeOfOrganizationOtherDesc0PROGRAM
IRS990EZ/TypeOfOrganizationOtherInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0DESCRIPTION: INTEREST INCOME. AMOUNT: 76.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1DESCRIPTION: AUTO EXPENSE. AMOUNT: 3706. DESCRIPTION: OFFICE SUPPLIES AND EXPENSE. AMOUNT: 2978. DESCRIPTION: INSURANCE. AMOUNT: 3945. DESCRIPTION: DEPRECIATION . AMOUNT: 118. DESCRIPTION: MISCELLANEOUS - PROGRAMS. AMOUNT: 1162. DESCRIPTION: CONVENTIONS, MEETINGS & SEMINARS. AMOUNT: 314. DESCRIPTION: DUES AND SUBSCRIPTIONS. AMOUNT: 817. DESCRIPTION: SCHOLARSHIPS AWARDED. AMOUNT: 1000. DESCRIPTION: PAYROLL TAXES. AMOUNT: 7397. TOTAL TO FORM 990-EZ, LINE 16: 21437.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2DESCRIPTION: ACCOUNTS RECEIVABLE. BEG. OF YEAR AMOUNT: 58840. END OF YEAR AMOUNT: 37587. DESCRIPTION: SPECIFICATION BOOKS. BEG. OF YEAR AMOUNT: 8575. END OF YEAR AMOUNT: 7951.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3DESCRIPTION: ACCOUNTS PAYABLE. BEG. OF YEAR AMOUNT: 2836. END OF YEAR AMOUNT: 980. DESCRIPTION: ACCRUED EXPENSES & OTHER LIABILITIES. BEG. OF YEAR AMOUNT: 171. END OF YEAR AMOUNT: 238.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 4 - OTHER INVESTMENT INCOME
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART I, LINE 16 - OTHER EXPENSES
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART II, LINE 24 - OTHER ASSETS
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990-EZ, PART II, LINE 26 - OTHER LIABILITIES
ReturnHeader/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0ROBERT BARTEL
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0EXECUTIVE DIRECTOR
ReturnHeader/BusinessOfficerGrp/PhoneNum04147781050
ReturnHeader/BusinessOfficerGrp/SignatureDt02017-05-23
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0PUBLIC WORKS INDUSTRY IMPROVEMENT
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0PROGRAM INC
ReturnHeader/Filer/BusinessNameControlTxt0PUBL
ReturnHeader/Filer/EIN0396127164
ReturnHeader/Filer/PhoneNum04147781050
ReturnHeader/Filer/USAddress/AddressLine1Txt0N16 W23250 STONE RIDGE DRIVE
ReturnHeader/Filer/USAddress/CityNm0WAUKESHA
ReturnHeader/Filer/USAddress/StateAbbreviationCd0WI
ReturnHeader/Filer/USAddress/ZIPCd053188
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0391531945
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0FREYBERG HINKLE ASHLAND POWERS & STOWELL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt015420 W CAPITOL DR
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0BROOKFIELD
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0WI
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0530052621
ReturnHeader/PreparerPersonGrp/PhoneNum02627846210
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0THOMAS M POWERS CPA
ReturnHeader/ReturnTs02017-05-24T15:00:11-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02015-12-01
ReturnHeader/TaxPeriodEndDt02016-11-30
ReturnHeader/TaxYr02015

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2016 • Form 990EZDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$215,555
Liabilities
$1,218
Net assets
$214,337
Revenue
$127,186
Expenses
$166,062
Net income
-$38,876
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.86$0.68$1.48$1.55$0.07
2022Detailed filing. Detailed filing data is available for this year.$3.23$0.98$2.25$1.51$1.40$0.11
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$3.22$1.07$1.58$1.42$0.16
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.55$0.57$1.98$1.44$1.40$0.04
2019Detailed filing. Detailed filing data is available for this year.$2.46$0.52$1.94$1.38$1.37$0.01
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.25$0.32$1.60$1.42$0.19
2017Detailed filing. Detailed filing data is available for this year.$1.95$0.21$1.74$1.09$1.49$0.40
2016Detailed filing. Detailed filing data is available for this year.$2.16$0.01$2.14$1.27$1.66$0.39
2015XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.56$0.03$2.53$1.47$1.31$0.17
2014Detailed filing. Detailed filing data is available for this year.$2.37$0.00$2.36$1.49$1.47$0.02
2013Import issue. A filing source exists for this year, but detailed import did not complete cleanly.$2.36$0.01$2.35$1.60$1.35$0.25
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$2.31$0.21$2.10$1.35$1.54$0.19
2011Summary only. Only limited summary data is available for this year.$2.31$0.03$1.27$1.61$0.34
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$2.71$0.09$2.62$1.54$2.33$0.78