Civic Intelligence

Public Works Industry Improvement Program Inc

990EZ • Fiscal year 2017 • EIN 39-6127164

Dec 01, 2016 to Nov 30, 2017 • Filed on Jun 26, 2018

Organization ProfileN/A
N16w23250 Stone Ridge DrWaukesha, WI 53188-1194

(414) 778-1050

Siviq Scores

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

Liabilities / Assets

74th percentile

0.11x

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

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

Liabilities / Revenue

84th percentile

0.19x

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

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

Net Margin

7th percentile

-37%

Higher net margin than 7% of similar nonprofits.

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

Top Officer Pay

96th percentile

$93,906

Higher top officer pay than 96% of similar nonprofits.

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

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

Asset Growth

27th percentile

-9.5%

Faster asset growth than 27% of similar nonprofits.

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

Revenue Growth

22nd percentile

-14%

Faster revenue growth than 22% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets74th percentile

Assets

Down

$195,057

Down $20,498 (-9.5%) from 2016

Net Assets

Down

$174,456

Down $39,881 (-19%) from 2016

Liabilities

Up

$20,601

Up $19,383 (+1591%) from 2016

Revenue And Expenses
Liabilities / Revenue84th percentileNet Margin7th percentile

Revenue

Down

$108,879

Down $18,307 (-14%) from 2016

Expenses

Down

$148,760

Down $17,302 (-10%) from 2016

Net Income

Down

-$39,881

Down $1,005 (-2.6%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth27th 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

2017

Assets$195,057
Liabilities$20,601
Net Assets$174,456
Open 2017 Filing

Operations Trend

Revenue Growth22nd 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

2017

Revenue$108,879
Expenses$148,760
Net Income-$39,881
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Dec 1, 2016 to Nov 30, 2017
Signed
Jun 26, 2018
Return Version
2016v3.1
Gross Receipts
$108,879
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-$3,242
Compensation and Service Providers
Top Officer Pay96th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
ROBERT BARTELExecutive DiPT$84,000$9,906$93,906
CW PURPERODirector-$0--
THOMAS SCHAITELVice Preside-$0--
PETER SCHRAUFNAGELPresident-$0--
JOHN WANASEKDirector-$0--
PHIL PURPERODirector-$0--
ROBERT OLSONSec/Treasure-$0--
Filing and Contact Details

Filer

Filer Name
Public Works Industry Improvement
EIN
39-6127164
Phone
4147781050
Address
N16W23250 STONE RIDGE DR, WAUKESHA, WI 53188-1194

Signing Officer

Name
Robert Bartel
Title
Executive Director
Phone
4147781050
Signed
2018-06-26
Discuss with paid preparer
Yes

Preparer

Firm
Betters & Associates Sc
Address
21095 WATERTOWN RD, WAUKESHA, WI 53186-1806
Preparer
Michael P Betters Ea
Phone
2627988160
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 16

“Expenses office supplies & software 1,050 taxes & licenses 10 general meetings 476 interest 218 insurance 2,260 auto expense 3,251 bank charges 60 dues & subscriptions 915 programs 1,200 standard spec book 379 non-investment depreciation 79 total 9,898”

Form 990-ez, Part II, Line 24

“Accounts receivable 37,587 11,314 inventories for sale or use 7,951 7,832 office furniture & equipment 2,241 2,241 less accumulated depreciation 1,965 2,043 total 45,814 19,344”

Form 990-ez, Part II, Line 26

“Accounts payable and accrued expenses 1,218 0 accrued sales tax 0 36 due to wuca 0 20,565”

Form 990-ez, Part III

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

Raw XML Appendix126 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/ActivitiesNotPreviouslyRptInd0false
IRS990EZ/BooksInCareOfDetail/PersonNm0ROBERT BARTEL
IRS990EZ/BooksInCareOfDetail/PhoneNum04147781050
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0N16W23250 STONE RIDGE DR
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0WAUKESHA
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0WI
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd053188
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0169741
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0175713
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-39881
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt04782
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0215555
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0195057
IRS990EZ/GrossReceiptsAmt0108879
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt076
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0214337
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0174456
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0214337
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0174456
IRS990EZ/OccupancyRentUtltsAndMaintAmt011104
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/CompensationAmt084000
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt09906
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 DI
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2VICE PRESIDE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6SEC/TREASURE
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt045814
IRS990EZ/OtherAssetsTotalDetail/EOYAmt019344
IRS990EZ/OtherExpensesTotalAmt09898
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0PROVIDE THE LEADERSHIP AND FINANCIAL SUPPORT TO PROMOTE THE ADVANCEMENT OF THE PUBLIC WORKS AND UTILITY CONSTRUCTION INDUSTRIES IN SOUTHEAST WISCONSIN.
IRS990EZ/PrintingPublicationsPostageAmt02709
IRS990EZ/ProgramServiceRevenueAmt0108803
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0INDUSTRY IMPROVEMENT & PROMOTION, CLEAN WATER CONSTRUCTION COALITION AND BID PREFERENCE ORDINANCE
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt03242
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt0120267
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt01218
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt020601
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt0148760
IRS990EZ/TotalProgramServiceExpensesAmt03242
IRS990EZ/TotalRevenueAmt0108879
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationOtherDesc0PROGRAM
IRS990EZ/TypeOfOrganizationOtherInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES OFFICE SUPPLIES & SOFTWARE 1,050 TAXES & LICENSES 10 GENERAL MEETINGS 476 INTEREST 218 INSURANCE 2,260 AUTO EXPENSE 3,251 BANK CHARGES 60 DUES & SUBSCRIPTIONS 915 PROGRAMS 1,200 STANDARD SPEC BOOK 379 NON-INVESTMENT DEPRECIATION 79 TOTAL 9,898
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1ACCOUNTS RECEIVABLE 37,587 11,314 INVENTORIES FOR SALE OR USE 7,951 7,832 OFFICE FURNITURE & EQUIPMENT 2,241 2,241 LESS ACCUMULATED DEPRECIATION 1,965 2,043 TOTAL 45,814 19,344
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2ACCOUNTS PAYABLE AND ACCRUED EXPENSES 1,218 0 ACCRUED SALES TAX 0 36 DUE TO WUCA 0 20,565
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3PROVIDE THE LEADERSHIP AND FINANCIAL SUPPORT TO PROMOTE THE ADVANCEMENT OF THE PUBLIC WORKS AND UTILITY CONSTRUCTION INDUSTRIES IN SOUTHEAST WISCONSIN.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART II, LINE 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART II, LINE 26
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990-EZ, PART III
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0ROBERT BARTEL
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0EXECUTIVE DIRECTOR
ReturnHeader/BusinessOfficerGrp/PhoneNum04147781050
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-06-26
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0PUBLIC WORKS INDUSTRY IMPROVEMENT
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0PROGRAM INC
ReturnHeader/Filer/BusinessNameControlTxt0PUBL
ReturnHeader/Filer/EIN0396127164
ReturnHeader/Filer/PhoneNum04147781050
ReturnHeader/Filer/USAddress/AddressLine1Txt0N16W23250 STONE RIDGE DR
ReturnHeader/Filer/USAddress/CityNm0WAUKESHA
ReturnHeader/Filer/USAddress/StateAbbreviationCd0WI
ReturnHeader/Filer/USAddress/ZIPCd0531881194
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0886BD7E1B304B7F578E42A90F7434D17866976C0
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0886BD7E1B304B7F578E42A90F7434D17866976C0
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0391783820
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0BETTERS & ASSOCIATES SC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt021095 WATERTOWN RD
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0WAUKESHA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0WI
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0531861806
ReturnHeader/PreparerPersonGrp/PhoneNum02627988160
ReturnHeader/PreparerPersonGrp/PreparationDt02018-06-25
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0MICHAEL P BETTERS EA
ReturnHeader/ReturnTs02018-06-26T12:56:40-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02016-12-01
ReturnHeader/TaxPeriodEndDt02017-11-30
ReturnHeader/TaxYr02016

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$195,057
Liabilities
$20,601
Net assets
$174,456
Revenue
$108,879
Expenses
$148,760
Net income
-$39,881
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
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$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