{"success":true,"data":{"_id":510191312,"filings":[{"Organization":{"value":null,"Person":["BYRON STOLBA","JOSH JENSEN","TODD BELL","BRUCE HAMILTON","MARK DERYCKE","RANDY SCONYERS","SCOT GEISLER","ERIK LEWIS","MIKE MCCULLOUGH"],"Title":["Union Member","Union Member","Union Member","Contractor Memb","Contractor Memb","BUSINESS MGR","Contractor Memb","Contractor Memb","COORDINATOR/SEC"],"Hours":[0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,40.0],"Total Compensation":[0,0,0,0,0,0,0,0,82763],"Direct compensation":[0,0,0,0,0,0,0,0,82763],"Other compensation":[0,0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide individuals with the instruction and training that provides them with the sheetmetal working skills to join the work force.","year":2015,"name":"LOCAL 263 CEDAR RAPIDS SHEET METAL WORKERS JOINT APPRENTICE COMMITTEE","phone":null,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":null,"year_formation":1976,"state_legal_domicile":"IA","total_volunteers":null,"tax_period_begin":"2015-10-01T00:00:00","tax_period_end":"2016-09-30T00:00:00","address":"500 66TH AVE SW, CEDAR RAPIDS, IA, 52406, USA","city":"CEDAR RAPIDS","state":"IA","country":"USA","zip_code":52406},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":8,"Number of independent voting members":8,"Number of employees total":10,"Total Gross UBI":0,"Net unrelated business taxable income":null,"Number of employees":10,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":362888,"Contributions":{"value":0,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":352364,"Total revenue":352364,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":3513,"Investment income total":1913,"Net investment gain":1600,"Income from invest bond proceeds":0},"Other revenues":{"value":7011,"Other total":7011,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":396826,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":214446,"Current officers":89530,"Disqualified persons":0,"Other salaries and wages":65388,"Pension plan contributions":24206,"Other employee benefits":23449,"Payroll taxes":11873},"Other expenses":{"value":182380,"Management services":0,"Legal":1403,"Accounting":7138,"Lobbying services":0,"Investment management fees":0,"Other services":175,"Advertising":0,"Office expenses":1714,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":9232,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":47277,"Insurance":8923,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":100188,"SCHOOL MATERIALS":41602,"REPAIRS & MAINTENANCE":32735,"UTILITIES":13792,"INTERNET":12059},"All other expenses":6330},"Functional Expenses":{"value":null,"Program Service Expenses":396826,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":1217463,"Non-interest bearing cash":98553,"Savings and temp cash investments":289496,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":829414,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":6134,"Sum of Total Liabilities":0,"Accounts payable, accrued":6134,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":1211329,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":1211329,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":1.0,"percentile":0.9996999186356569},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-0.09352196821057737,"percentile":0.22989643300488988},"Liabilities to Assets Ratio":{"score":0.005038346134543719,"percentile":0.528841237691177},"Operating Reserve Ratio":{"score":3.068002096636813,"percentile":0.7171393009137154},"Officer Compensation Ratio":{"score":0.20856244298508667,"percentile":0.2999936021004646},"Program Expense Growth":{"score":0.15309034515699038,"percentile":0.758997207371716},"Revenue Growth":{"score":0.1580293159769417,"percentile":0.8578112580843937},"Asset Growth":{"score":0.023691377727982122,"percentile":0.41947170412245954},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.7186001168876667,"percentile":0.8777269661143956}},"source_xml":"201732269349300108_public.xml"},{"Organization":{"value":null,"Person":["MIKE MCCULLOUGH","RANDY SCONYERS","RUSS JAEGER","TODD BELL","MATT PARMAN","MARK DERYCKE","SCOT GEISLER","ERIK LEWIS","TODD VLASEK","MIKE PALUMBO"],"Title":["COORDINATOR","BUS MANAGER","SECRETARY/TREAS","Union Member","UNION MEMBER","Chairman","Contractor Memb","Contractor Memb","UNION MEMBER","UNION MEMBER"],"Hours":[48.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0],"Total Compensation":[97796,0,0,0,0,0,0,0,0,0],"Direct compensation":[97796,0,0,0,0,0,0,0,0,0],"Other compensation":[0,0,0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide individuals with the instruction and training that provides them with the sheetmetal working skills to join the work force.","year":2020,"name":"LOCAL 263 CEDAR RAPIDS SHEET METAL WORKERS JOINT APPRENTICE COMMITTEE","phone":null,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":null,"year_formation":1976,"state_legal_domicile":"IA","total_volunteers":null,"tax_period_begin":"2020-10-01T00:00:00","tax_period_end":"2021-09-30T00:00:00","address":"500 66TH AVE SW 3, CEDAR RAPIDS, IA, 52404, USA","city":"CEDAR RAPIDS","state":"IA","country":"USA","zip_code":52404},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":9,"Number of independent voting members":9,"Number of employees total":13,"Total Gross UBI":0,"Net unrelated business taxable income":null,"Number of employees":13,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":661994,"Contributions":{"value":288365,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":288365,"Related organizations":0},"Program revenue":{"value":366120,"Total revenue":366120,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":3931,"Investment income total":3931,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":3578,"Other total":3578,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":477039,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":270059,"Current officers":99311,"Disqualified persons":0,"Other salaries and wages":96747,"Pension plan contributions":27426,"Other employee benefits":31560,"Payroll taxes":15015},"Other expenses":{"value":206980,"Management services":0,"Legal":0,"Accounting":7603,"Lobbying services":0,"Investment management fees":0,"Other services":575,"Advertising":0,"Office expenses":2471,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":121,"Conferences and meetings":2202,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":77881,"Insurance":10402,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":102181,"REPAIRS & MAINTENANCE":47318,"SCHOOL MATERIALS":31274,"UTILITIES":13397,"TELEPHONE/INTERNET":10192},"All other expenses":3544},"Functional Expenses":{"value":null,"Program Service Expenses":477039,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":1377641,"Non-interest bearing cash":383330,"Savings and temp cash investments":115524,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":878787,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":10885,"Sum of Total Liabilities":0,"Accounts payable, accrued":10885,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":1366756,"Net assets without donor restriction":1366756,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":1.0,"percentile":0.9996999186356569},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.2793907497651036,"percentile":0.8220519418531352},"Liabilities to Assets Ratio":{"score":0.007901187609834492,"percentile":0.5098898699349265},"Operating Reserve Ratio":{"score":2.8879001507214297,"percentile":0.7040896606260909},"Officer Compensation Ratio":{"score":0.2050062992753213,"percentile":0.3057751543676409},"Program Expense Growth":{"score":0.05365900892561821,"percentile":0.5448949915210013},"Revenue Growth":{"score":0.08164221399968917,"percentile":0.7172620022503738},"Asset Growth":{"score":0.011947185320633985,"percentile":0.369855056048415},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.7767971825353407,"percentile":0.942632194373911}},"source_xml":"202222279349304162_public.xml"},{"Organization":{"value":null,"Person":["BYRON STOLBA","JOSH JENSEN","TODD BELL","BRUCE HAMILTON","MARK DERYCKE","MATT PARMAN","RANDY SCONYERS","SCOT GEISLER","ERIK LEWIS","TODD VLASEK","MIKE PALUMBO","MIKE MCCULLOUGH"],"Title":["Union Member","Union Member","Union Member","Contractor Memb","Contractor Memb","CONTRACTOR MEMB","SEC/TREASURER","Contractor Memb","Contractor Memb","UNION MEMBER","UNION MEMBER","COORDINATOR"],"Hours":[1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,40.0],"Total Compensation":[0,0,0,0,0,0,0,0,0,0,0,93633],"Direct compensation":[0,0,0,0,0,0,0,0,0,0,0,93633],"Other compensation":[0,0,0,0,0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide individuals with the instruction and training that provides them with the sheetmetal working skills to join the work force.","year":2018,"name":"LOCAL 263 CEDAR RAPIDS SHEET METAL WORKERS JOINT APPRENTICE COMMITTEE","phone":null,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":null,"year_formation":1976,"state_legal_domicile":"IA","total_volunteers":null,"tax_period_begin":"2018-10-01T00:00:00","tax_period_end":"2019-09-30T00:00:00","address":"500 66TH AVE SW, CEDAR RAPIDS, IA, 52406, USA","city":"CEDAR RAPIDS","state":"IA","country":"USA","zip_code":52406},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":8,"Number of independent voting members":8,"Number of employees total":14,"Total Gross UBI":0,"Net unrelated business taxable income":null,"Number of employees":14,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":399637,"Contributions":{"value":31985,"Other contributions":7781,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":24204,"Related organizations":0},"Program revenue":{"value":342925,"Total revenue":342925,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":5645,"Investment income total":5645,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":19082,"Other total":19082,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":430430,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":251673,"Current officers":93933,"Disqualified persons":0,"Other salaries and wages":90750,"Pension plan contributions":25262,"Other employee benefits":27454,"Payroll taxes":14274},"Other expenses":{"value":178757,"Management services":0,"Legal":7153,"Accounting":8045,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":2217,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":5518,"Conferences and meetings":2958,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":44836,"Insurance":6262,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":90397,"SCHOOL MATERIALS":51284,"REPAIRS & MAINTENANCE":14550,"UTILITIES":14416,"TELEPHONE/INTERNET":10147},"All other expenses":11371},"Functional Expenses":{"value":null,"Program Service Expenses":430430,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":1201914,"Non-interest bearing cash":117349,"Savings and temp cash investments":342848,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":741717,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":8251,"Sum of Total Liabilities":0,"Accounts payable, accrued":8251,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":1193663,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":1193663,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":1.0,"percentile":0.9996999186356569},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-0.07705242507575624,"percentile":0.24851085632461387},"Liabilities to Assets Ratio":{"score":0.006864883843602787,"percentile":0.516236626010065},"Operating Reserve Ratio":{"score":2.7923564807285737,"percentile":0.6966921092853062},"Officer Compensation Ratio":{"score":0.21753362916153615,"percentile":0.28589868755149456},"Program Expense Growth":{"score":0.06933729469795931,"percentile":0.5972861205774459},"Revenue Growth":{"score":0.0533288754461127,"percentile":0.6200449010890992},"Asset Growth":{"score":0.004063973032357415,"percentile":0.3369630767065518},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6753967602156534,"percentile":0.8009922439941101}},"source_xml":"202022309349302867_public.xml"},{"Organization":{"value":null,"Person":["BYRON STOLBA","JOSH JENSEN","TODD BELL","BRUCE HAMILTON","MARK DERYCKE","RANDY SCONYERS","SCOTT GEISLER","ERIK LEWIS","DEREK JENSEN"],"Title":["Union Member","Union Member","Union Member","Contractor Memb","Contractor Memb","BUSINESS MGR","Contractor Memb","Contractor Memb","COORDINATOR/SEC"],"Hours":[0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,40.0],"Total Compensation":[0,0,0,0,0,0,0,0,63980],"Direct compensation":[0,0,0,0,0,0,0,0,63980],"Other compensation":[0,0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide individuals with the instruction and training that provides them with the sheetmetal working skills to join the work force.","year":2013,"name":"LOCAL 263 CEDAR RAPIDS SHEET METAL WORKERS JOINT APPRENTICE COMMITTEE","phone":null,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":null,"year_formation":1976,"state_legal_domicile":"IA","total_volunteers":null,"tax_period_begin":"2013-10-01T00:00:00","tax_period_end":"2014-09-30T00:00:00","address":"500 66TH AVE SW, CEDAR RAPIDS, IA, 52406, USA","city":"CEDAR RAPIDS","state":"IA","country":"USA","zip_code":52406},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":8,"Number of independent voting members":8,"Number of employees total":1,"Total Gross UBI":0,"Net unrelated business taxable income":null,"Number of employees":1,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":255846,"Contributions":{"value":0,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":255138,"Total revenue":255138,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":708,"Investment income total":708,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":0,"Other total":0,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":294688,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":105422,"Current officers":64593,"Disqualified persons":0,"Other salaries and wages":0,"Pension plan contributions":35888,"Other employee benefits":0,"Payroll taxes":4941},"Other expenses":{"value":189266,"Management services":0,"Legal":2200,"Accounting":10259,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":4751,"Information technology":0,"Royalties":0,"Occupancy":17358,"Travel":3543,"Conferences and meetings":446,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":34767,"Insurance":9613,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":101243,"INSTRUCTION":56972,"SCHOOL MATERIALS":28822,"REPAIRS & MAINTENANCE":10317,"TELEPHONE":5132},"All other expenses":5086},"Functional Expenses":{"value":null,"Program Service Expenses":294688,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":1160173,"Non-interest bearing cash":5601,"Savings and temp cash investments":286362,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":868210,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":3457,"Sum of Total Liabilities":0,"Accounts payable, accrued":3457,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":1156716,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":1156716,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":1.0,"percentile":0.9996999186356569},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-0.15181789044972366,"percentile":0.1797769937670673},"Liabilities to Assets Ratio":{"score":0.00297972802332066,"percentile":0.5462298826841551},"Operating Reserve Ratio":{"score":3.936953659463568,"percentile":0.7658578502054966},"Officer Compensation Ratio":{"score":0.21711097839070476,"percentile":0.2865272445516513},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":null,"percentile":null},"Asset Growth":{"score":null,"percentile":null},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.7109791411342954,"percentile":0.8662644441435786}},"source_xml":"201530209349300808_public.xml"},{"Organization":{"value":null,"Person":["BYRON STOLBA","JOSH JENSEN","TODD BELL","BRUCE HAMILTON","MARK DERYCKE","RANDY SCONYERS","SCOT GEISLER","ERIK LEWIS","MIKE MCCULLOUGH"],"Title":["Union Member","Union Member","Union Member","Contractor Memb","Contractor Memb","BUSINESS MGR","Contractor Memb","Contractor Memb","COORDINATOR/SEC"],"Hours":[0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,40.0],"Total Compensation":[0,0,0,0,0,0,0,0,89496],"Direct compensation":[0,0,0,0,0,0,0,0,89496],"Other compensation":[0,0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide individuals with the instruction and training that provides them with the sheetmetal working skills to join the work force.","year":2016,"name":"LOCAL 263 CEDAR RAPIDS SHEET METAL WORKERS JOINT APPRENTICE COMMITTEE","phone":null,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":null,"year_formation":1976,"state_legal_domicile":"IA","total_volunteers":null,"tax_period_begin":"2016-10-01T00:00:00","tax_period_end":"2017-09-30T00:00:00","address":"500 66TH AVE SW, CEDAR RAPIDS, IA, 52406, USA","city":"CEDAR RAPIDS","state":"IA","country":"USA","zip_code":52406},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":8,"Number of independent voting members":8,"Number of employees total":12,"Total Gross UBI":0,"Net unrelated business taxable income":null,"Number of employees":12,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":422786,"Contributions":{"value":62342,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":62342,"Related organizations":0},"Program revenue":{"value":343224,"Total revenue":343224,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":2051,"Investment income total":2051,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":15169,"Other total":15169,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":397738,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":239080,"Current officers":89518,"Disqualified persons":0,"Other salaries and wages":87263,"Pension plan contributions":24075,"Other employee benefits":24448,"Payroll taxes":13776},"Other expenses":{"value":158658,"Management services":0,"Legal":1222,"Accounting":7021,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":4134,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":2064,"Conferences and meetings":3681,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":48124,"Insurance":10089,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":73270,"SCHOOL MATERIALS":27724,"REPAIRS & MAINTENANCE":23074,"UTILITIES":11892,"INTERNET":10580},"All other expenses":9053},"Functional Expenses":{"value":null,"Program Service Expenses":397738,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":1244916,"Non-interest bearing cash":258016,"Savings and temp cash investments":204868,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":782032,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":9126,"Sum of Total Liabilities":0,"Accounts payable, accrued":9126,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":1235790,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":1235790,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":1.0,"percentile":0.9996999186356569},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.05924510272336359,"percentile":0.54514550472937},"Liabilities to Assets Ratio":{"score":0.007330615077643793,"percentile":0.5133614947077592},"Operating Reserve Ratio":{"score":3.129990093981465,"percentile":0.7212884370038027},"Officer Compensation Ratio":{"score":0.22501244537861606,"percentile":0.2747048053109404},"Program Expense Growth":{"score":0.1134724347515195,"percentile":0.7012063400117052},"Revenue Growth":{"score":0.12966439837116414,"percentile":0.819978212976969},"Asset Growth":{"score":0.01823075273209043,"percentile":0.39639348922726},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.7580409496489715,"percentile":0.92536931671034}},"source_xml":"201822279349302687_public.xml"},{"Organization":{"value":null,"Person":["MIKE MCCULLOUGH","MATTHEW MUTERT","MIKE PALUMBO","RUSS JAEGER","TODD VLASEK","TODD BELL","SCOT GEISLER","MARK DERYCKE","ERIK LEWIS","ZEB ZARUBA"],"Title":["PREV COORD.","COORDINATOR","UNION MEMBER","BUS MANAGER","UNION MEMBER","UNION MEMBER","CONTRACTOR MEMB","Chairman","CONTRACTOR MEMB","UNION MEMBER"],"Hours":[48.0,48.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0],"Total Compensation":[105130,87608,0,0,0,0,0,0,0,0],"Direct compensation":[105130,87608,0,0,0,0,0,0,0,0],"Other compensation":[0,0,0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide individuals with the instruction and training that provides them with the sheetmetal working skills to join the work force.","year":2023,"name":"LOCAL 263 CEDAR RAPIDS SHEET METAL WORKERS JOINT APPRENTICE COMMITTEE","phone":null,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":null,"year_formation":1976,"state_legal_domicile":"IA","total_volunteers":null,"tax_period_begin":"2023-10-01T00:00:00","tax_period_end":"2024-09-30T00:00:00","address":"500 66TH AVE SW 3, CEDAR RAPIDS, IA, 52404, USA","city":"CEDAR RAPIDS","state":"IA","country":"USA","zip_code":52404},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":8,"Number of independent voting members":8,"Number of employees total":5,"Total Gross UBI":0,"Net unrelated business taxable income":null,"Number of employees":5,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":702252,"Contributions":{"value":81549,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":81549,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":606859,"Total revenue":606859,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":10511,"Investment income total":10511,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":3333,"Other total":3333,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":720356,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":405900,"Current officers":176240,"Disqualified persons":0,"Other salaries and wages":70187,"Pension plan contributions":153984,"Other employee benefits":0,"Payroll taxes":5489},"Other expenses":{"value":314456,"Management services":0,"Legal":0,"Accounting":3425,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":2740,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":4603,"Conferences and meetings":4915,"Interest":3,"Payments to affiliates":0,"Depreciation and depletion":102887,"Insurance":13172,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":164844,"STUDENT STIPEND":109410,"REPAIRS & MAINTENANCE":22837,"SCHOOL MATERIALS":18609,"UTILITIES":13988},"All other expenses":17867},"Functional Expenses":{"value":null,"Program Service Expenses":720356,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":1247240,"Non-interest bearing cash":195937,"Savings and temp cash investments":328753,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":722550,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":0,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":1247240,"Net assets without donor restriction":1247240,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":1.0,"percentile":0.9996999186356569},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-0.025779919459111542,"percentile":0.3270207812656993},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":1.731421685944172,"percentile":0.5777304704543558},"Officer Compensation Ratio":{"score":0.2675593734209197,"percentile":0.2202962862390949},"Program Expense Growth":{"score":0.08769921892414563,"percentile":0.6471905336842042},"Revenue Growth":{"score":0.08444148509543901,"percentile":0.7250733583231775},"Asset Growth":{"score":0.006501412100081212,"percentile":0.347114115711247},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.7204261147110262,"percentile":0.8803177676589973}},"source_xml":"202531609349301268_public.xml"},{"Organization":{"value":null,"Person":["BYRON STOLBA","JOSH JENSEN","TODD BELL","BRUCE HAMILTON","MARK DERYCKE","RANDY SCONYERS","SCOTT GEISLER","ERIK LEWIS","DEREK JENSEN","MIKE MCCULLOUGH"],"Title":["Union Member","Union Member","Union Member","Contractor Memb","Contractor Memb","BUSINESS MGR","Contractor Memb","Contractor Memb","FORMER COORD","COORDINATOR/SEC"],"Hours":[0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,40.0,40.0],"Total Compensation":[0,0,0,0,0,0,0,0,66137,8000],"Direct compensation":[0,0,0,0,0,0,0,0,66137,8000],"Other compensation":[0,0,0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide individuals with the instruction and training that provides them with the sheetmetal working skills to join the work force.","year":2014,"name":"LOCAL 263 CEDAR RAPIDS SHEET METAL WORKERS JOINT APPRENTICE COMMITTEE","phone":null,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":null,"year_formation":1976,"state_legal_domicile":"IA","total_volunteers":null,"tax_period_begin":"2014-10-01T00:00:00","tax_period_end":"2015-09-30T00:00:00","address":"500 66TH AVE SW, CEDAR RAPIDS, IA, 52406, USA","city":"CEDAR RAPIDS","state":"IA","country":"USA","zip_code":52406},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":8,"Number of independent voting members":8,"Number of employees total":8,"Total Gross UBI":0,"Net unrelated business taxable income":null,"Number of employees":8,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":397299,"Contributions":{"value":55896,"Other contributions":55896,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":334879,"Total revenue":334879,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":722,"Investment income total":722,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":5802,"Other total":5802,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":309248,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":186868,"Current officers":83185,"Disqualified persons":0,"Other salaries and wages":43773,"Pension plan contributions":50192,"Other employee benefits":0,"Payroll taxes":9718},"Other expenses":{"value":122380,"Management services":0,"Legal":1429,"Accounting":6159,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":2189,"Information technology":0,"Royalties":0,"Occupancy":11735,"Travel":7033,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":41820,"Insurance":9281,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":40477,"SCHOOL MATERIALS":15868,"REPAIRS & MAINTENANCE":15069,"TELEPHONE":6100,"INSTRUCTION":3440},"All other expenses":2257},"Functional Expenses":{"value":null,"Program Service Expenses":309248,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":1249633,"Non-interest bearing cash":72268,"Savings and temp cash investments":287140,"Pledges and grants receivable":0,"Accounts receivable":24693,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":865532,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":4810,"Sum of Total Liabilities":0,"Accounts payable, accrued":4810,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":1244823,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":1244823,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":1.0,"percentile":0.9996999186356569},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.2216240161691824,"percentile":0.7769228433325269},"Liabilities to Assets Ratio":{"score":0.00384913010459871,"percentile":0.5383974236070485},"Operating Reserve Ratio":{"score":4.040876578021523,"percentile":0.7705884029110036},"Officer Compensation Ratio":{"score":0.239733159147351,"percentile":0.25420564216596736},"Program Expense Growth":{"score":null,"percentile":null},"Revenue Growth":{"score":null,"percentile":null},"Asset Growth":{"score":null,"percentile":null},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.8420249650103474,"percentile":0.9786348365715186}},"source_xml":"201622229349300932_public.xml"},{"Organization":{"value":null,"Person":["MIKE MCCULLOUGH","MIKE PALUMBO","RUSS JAEGER","TODD VLASEK","TODD BELL","SCOT GEISLER","MARK DERYCKE","ERIK LEWIS","ZEB ZARUBA"],"Title":["COORDINATOR","UNION MEMBER","BUS MANAGER","UNION MEMBER","UNION MEMBER","CONTRACTOR MEMB","Chairman","CONTRACTOR MEMB","UNION MEMBER"],"Hours":[48.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0],"Total Compensation":[101755,0,0,0,0,0,0,0,0],"Direct compensation":[101755,0,0,0,0,0,0,0,0],"Other compensation":[0,0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide individuals with the instruction and training that provides them with the sheetmetal working skills to join the work force.","year":2022,"name":"LOCAL 263 CEDAR RAPIDS SHEET METAL WORKERS JOINT APPRENTICE COMMITTEE","phone":null,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":null,"year_formation":1976,"state_legal_domicile":"IA","total_volunteers":null,"tax_period_begin":"2022-10-01T00:00:00","tax_period_end":"2023-09-30T00:00:00","address":"500 66TH AVE SW 3, CEDAR RAPIDS, IA, 52404, USA","city":"CEDAR RAPIDS","state":"IA","country":"USA","zip_code":52404},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":8,"Number of independent voting members":8,"Number of employees total":6,"Total Gross UBI":0,"Net unrelated business taxable income":null,"Number of employees":6,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":701454,"Contributions":{"value":136526,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":136526,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":545180,"Total revenue":545180,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":11133,"Investment income total":11133,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":8615,"Other total":8615,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":698185,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":385376,"Current officers":104213,"Disqualified persons":0,"Other salaries and wages":124037,"Pension plan contributions":88093,"Other employee benefits":51185,"Payroll taxes":17848},"Other expenses":{"value":312809,"Management services":0,"Legal":0,"Accounting":15253,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":2495,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":4989,"Conferences and meetings":2915,"Interest":1,"Payments to affiliates":0,"Depreciation and depletion":97223,"Insurance":17312,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":160216,"STUDENT STIPEND":86569,"SCHOOL MATERIALS":38996,"REPAIRS & MAINTENANCE":18521,"UTILITIES":16130},"All other expenses":12405},"Functional Expenses":{"value":null,"Program Service Expenses":698185,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":1265224,"Non-interest bearing cash":192571,"Savings and temp cash investments":277848,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":794805,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":9429,"Sum of Total Liabilities":0,"Accounts payable, accrued":9429,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":1255795,"Net assets without donor restriction":1255795,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":1.0,"percentile":0.9996999186356569},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.004660319849911755,"percentile":0.409541565690358},"Liabilities to Assets Ratio":{"score":0.007452435299994309,"percentile":0.5126099375156702},"Operating Reserve Ratio":{"score":1.8121615331180132,"percentile":0.5899525469463098},"Officer Compensation Ratio":{"score":0.14574217435207001,"percentile":0.4221514817486485},"Program Expense Growth":{"score":0.0845550004013284,"percentile":0.6393863415712583},"Revenue Growth":{"score":0.08330441227026077,"percentile":0.7219626462582006},"Asset Growth":{"score":0.008407576504523074,"percentile":0.35504581523017514},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.7184151071180316,"percentile":0.8774531870858692}},"source_xml":"202422279349303102_public.xml"},{"Organization":{"value":null,"Person":["MIKE MCCULLOUGH","MIKE PALUMBO","RUSS JAEGER","TODD VLASEK","TODD BELL","SCOT GEISLER","MARK DERYCKE","ERIK LEWIS","MATT PARMAN","ZEB ZARUBA"],"Title":["COORDINATOR","UNION MEMBER","BUS MANAGER","UNION MEMBER","UNION MEMBER","CONTRACTOR MEMB","Chairman","CONTRACTOR MEMB","UNION MEMBER","UNION MEMBER"],"Hours":[48.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0],"Total Compensation":[99729,0,0,0,0,0,0,0,0,0],"Direct compensation":[99729,0,0,0,0,0,0,0,0,0],"Other compensation":[0,0,0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide individuals with the instruction and training that provides them with the sheetmetal working skills to join the work force.","year":2021,"name":"LOCAL 263 CEDAR RAPIDS SHEET METAL WORKERS JOINT APPRENTICE COMMITTEE","phone":null,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":null,"year_formation":1976,"state_legal_domicile":"IA","total_volunteers":null,"tax_period_begin":"2021-10-01T00:00:00","tax_period_end":"2022-09-30T00:00:00","address":"500 66TH AVE SW 3, CEDAR RAPIDS, IA, 52404, USA","city":"CEDAR RAPIDS","state":"IA","country":"USA","zip_code":52404},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":9,"Number of independent voting members":9,"Number of employees total":12,"Total Gross UBI":0,"Net unrelated business taxable income":null,"Number of employees":12,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":499092,"Contributions":{"value":46669,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":46669,"Related organizations":0},"Program revenue":{"value":441263,"Total revenue":441263,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":4289,"Investment income total":4289,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":6871,"Other total":6871,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":603584,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":381785,"Current officers":101446,"Disqualified persons":0,"Other salaries and wages":124093,"Pension plan contributions":88968,"Other employee benefits":49993,"Payroll taxes":17285},"Other expenses":{"value":221799,"Management services":0,"Legal":0,"Accounting":7214,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":2231,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":2579,"Conferences and meetings":4515,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":93651,"Insurance":12332,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":87804,"SCHOOL MATERIALS":45591,"UTILITIES":16475,"REPAIRS & MAINTENANCE":13621,"TELEPHONE/INTERNET":12117},"All other expenses":11473},"Functional Expenses":{"value":null,"Program Service Expenses":603584,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":1266836,"Non-interest bearing cash":79086,"Savings and temp cash investments":370654,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":817096,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":16385,"Sum of Total Liabilities":0,"Accounts payable, accrued":16385,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":1250451,"Net assets without donor restriction":1250451,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":1.0,"percentile":0.9996999186356569},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-0.20936420539700096,"percentile":0.14679032396453895},"Liabilities to Assets Ratio":{"score":0.01293379727131215,"percentile":0.48437625464371803},"Operating Reserve Ratio":{"score":2.0988561658360725,"percentile":0.6286010897974419},"Officer Compensation Ratio":{"score":0.16522803785388612,"percentile":0.3788396554511325},"Program Expense Growth":{"score":0.07122721587942336,"percentile":0.6029754901666751},"Revenue Growth":{"score":0.07080514971049526,"percentile":0.6841212021442103},"Asset Growth":{"score":0.010010985387068124,"percentile":0.3616920585158742},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6657555259179402,"percentile":0.7791677157529733}},"source_xml":"202332279349303453_public.xml"},{"Organization":{"value":null,"Person":["MIKE MCCULLOUGH","TODD BELL","MARK DERYCKE","MATT PARMAN","RANDY SCONYERS","SCOT GEISLER","ERIK LEWIS","TODD VLASEK","MIKE PALUMBO"],"Title":["COORDINATOR","Union Member","Chairman","CONTRACTOR MEMB","BUS MANAGER","Contractor Memb","Contractor Memb","UNION MEMBER","UNION MEMBER"],"Hours":[48.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0],"Total Compensation":[94401,0,0,0,0,0,0,0,0],"Direct compensation":[94401,0,0,0,0,0,0,0,0],"Other compensation":[0,0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide individuals with the instruction and training that provides them with the sheetmetal working skills to join the work force.","year":2019,"name":"LOCAL 263 CEDAR RAPIDS SHEET METAL WORKERS JOINT APPRENTICE COMMITTEE","phone":null,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":null,"year_formation":1976,"state_legal_domicile":"IA","total_volunteers":null,"tax_period_begin":"2019-10-01T00:00:00","tax_period_end":"2020-09-30T00:00:00","address":"500 66TH AVE SW, CEDAR RAPIDS, IA, 52404, USA","city":"CEDAR RAPIDS","state":"IA","country":"USA","zip_code":52404},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":8,"Number of independent voting members":8,"Number of employees total":12,"Total Gross UBI":0,"Net unrelated business taxable income":null,"Number of employees":12,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":373471,"Contributions":{"value":26119,"Other contributions":1745,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":24374,"Related organizations":0},"Program revenue":{"value":333355,"Total revenue":333355,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":8239,"Investment income total":8239,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":5758,"Other total":5758,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":383127,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":228603,"Current officers":96883,"Disqualified persons":0,"Other salaries and wages":65487,"Pension plan contributions":25388,"Other employee benefits":28424,"Payroll taxes":12421},"Other expenses":{"value":154524,"Management services":0,"Legal":3297,"Accounting":2500,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":1879,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":2100,"Conferences and meetings":2685,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":46271,"Insurance":9611,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":82412,"SCHOOL MATERIALS":47847,"UTILITIES":12990,"REPAIRS & MAINTENANCE":12204,"TELEPHONE/INTERNET":9371},"All other expenses":3769},"Functional Expenses":{"value":null,"Program Service Expenses":383127,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":1205801,"Non-interest bearing cash":315655,"Savings and temp cash investments":188535,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":701611,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":20989,"Sum of Total Liabilities":0,"Accounts payable, accrued":20989,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":1184812,"Net assets without donor restriction":1184812,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":1.0,"percentile":0.9996999186356569},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-0.025854751774568842,"percentile":0.32687709956163835},"Liabilities to Assets Ratio":{"score":0.017406686509631356,"percentile":0.46663282713324256},"Operating Reserve Ratio":{"score":3.147261874000005,"percentile":0.7224324757455097},"Officer Compensation Ratio":{"score":0.2463961036418733,"percentile":0.2456280612850401},"Program Expense Growth":{"score":0.047389282585947476,"percentile":0.5214472823930743},"Revenue Growth":{"score":0.03500142151731168,"percentile":0.5388657029646533},"Asset Growth":{"score":0.001545627024955336,"percentile":0.3265414891162369},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6686733541084218,"percentile":0.7860753866253845}},"source_xml":"202142249349302124_public.xml"},{"Organization":{"value":null,"Person":["BYRON STOLBA","JOSH JENSEN","TODD BELL","BRUCE HAMILTON","MARK DERYCKE","RANDY SCONYERS","SCOT GEISLER","ERIK LEWIS","MIKE MCCULLOUGH"],"Title":["Union Member","Union Member","Union Member","Contractor Memb","Contractor Memb","BUSINESS MGR","Contractor Memb","Contractor Memb","COORDINATOR/SEC"],"Hours":[0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,40.0],"Total Compensation":[0,0,0,0,0,0,0,0,88824],"Direct compensation":[0,0,0,0,0,0,0,0,88824],"Other compensation":[0,0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide individuals with the instruction and training that provides them with the sheetmetal working skills to join the work force.","year":2017,"name":"LOCAL 263 CEDAR RAPIDS SHEET METAL WORKERS JOINT APPRENTICE COMMITTEE","phone":null,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":null,"year_formation":1976,"state_legal_domicile":"IA","total_volunteers":null,"tax_period_begin":"2017-10-01T00:00:00","tax_period_end":"2018-09-30T00:00:00","address":"500 66TH AVE SW, CEDAR RAPIDS, IA, 52406, USA","city":"CEDAR RAPIDS","state":"IA","country":"USA","zip_code":52406},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":8,"Number of independent voting members":8,"Number of employees total":15,"Total Gross UBI":0,"Net unrelated business taxable income":null,"Number of employees":15,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":366304,"Contributions":{"value":21642,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":21642,"Related organizations":0},"Program revenue":{"value":331438,"Total revenue":331438,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":3263,"Investment income total":3263,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":9961,"Other total":9961,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":380602,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":233591,"Current officers":91771,"Disqualified persons":0,"Other salaries and wages":77079,"Pension plan contributions":25231,"Other employee benefits":26329,"Payroll taxes":13181},"Other expenses":{"value":147011,"Management services":0,"Legal":1058,"Accounting":7948,"Lobbying services":0,"Investment management fees":0,"Other services":336,"Advertising":0,"Office expenses":3767,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":3990,"Conferences and meetings":3118,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":46859,"Insurance":5865,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":71399,"REPAIRS & MAINTENANCE":24516,"SCHOOL MATERIALS":23450,"UTILITIES":12448,"TELEPHONE/INTERNET":10985},"All other expenses":2671},"Functional Expenses":{"value":null,"Program Service Expenses":380602,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":1228621,"Non-interest bearing cash":339880,"Savings and temp cash investments":153568,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":735173,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":8445,"Sum of Total Liabilities":0,"Accounts payable, accrued":8445,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":1220176,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":1220176,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":1.0,"percentile":0.9996999186356569},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-0.03903315279112431,"percentile":0.30297457812096534},"Liabilities to Assets Ratio":{"score":0.006873559869154116,"percentile":0.5161864402613427},"Operating Reserve Ratio":{"score":3.2280991692108816,"percentile":0.7276587583632951},"Officer Compensation Ratio":{"score":0.23337764909275305,"percentile":0.26280129345016257},"Program Expense Growth":{"score":0.07315994248783937,"percentile":0.6085924519344885},"Revenue Growth":{"score":0.06825102776929884,"percentile":0.6755788525333224},"Asset Growth":{"score":0.01083291289708278,"percentile":0.3651424641565178},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6926665717207533,"percentile":0.8362197455674896}},"source_xml":"201942279349303654_public.xml"}],"Latest":{"Organization":{"value":null,"Person":["MIKE MCCULLOUGH","MATTHEW MUTERT","MIKE PALUMBO","RUSS JAEGER","TODD VLASEK","TODD BELL","SCOT GEISLER","MARK DERYCKE","ERIK LEWIS","ZEB ZARUBA"],"Title":["PREV COORD.","COORDINATOR","UNION MEMBER","BUS MANAGER","UNION MEMBER","UNION MEMBER","CONTRACTOR MEMB","Chairman","CONTRACTOR MEMB","UNION MEMBER"],"Hours":[48.0,48.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0],"Total Compensation":[105130,87608,0,0,0,0,0,0,0,0],"Direct compensation":[105130,87608,0,0,0,0,0,0,0,0],"Other compensation":[0,0,0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"To provide individuals with the instruction and training that provides them with the sheetmetal working skills to join the work force.","year":2023,"name":"LOCAL 263 CEDAR RAPIDS SHEET METAL WORKERS JOINT APPRENTICE COMMITTEE","phone":null,"website":null,"type":"990","affiliation":null,"foreign_countries":null,"principal_officer":null,"year_formation":1976,"state_legal_domicile":"IA","total_volunteers":null,"tax_period_begin":"2023-10-01T00:00:00","tax_period_end":"2024-09-30T00:00:00","address":"500 66TH AVE SW 3, CEDAR RAPIDS, IA, 52404, USA","city":"CEDAR RAPIDS","state":"IA","country":"USA","zip_code":52404},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":8,"Number of independent voting members":8,"Number of employees total":5,"Total Gross UBI":0,"Net unrelated business taxable income":null,"Number of employees":5,"Prohibited tax shelter transactions":true,"Taxable party notification":true,"Funds to pay premiums":true,"Premiums Paid":true,"Family or business relationship":true,"Delegation of management duties":true,"Conflict of interest policy":true,"Whistle blower policy":true,"Compensation process for CEO":true,"Compensation process for other employees":true,"Changes to organizing documents":true,"Material diversion or misuse":true,"Members or stockholders":true,"Election of board members":true,"Decisions subject to approval":true,"Minutes of governing body":true,"Local chapters":true,"Form 990 provided to governing body":true,"Document retention policy":true,"Investment in joint venture":true,"Independent audit financial statements":true,"Consolidated audit financial statements":true,"Accountant compile or review":true,"Political activities":true,"Donor advised funds":true,"Conservation easements":true,"Collections of art":true,"School":true,"Hospital":true,"Foreign activities":true,"Foreign office":true,"Gaming":true,"Fundraising activities":true,"Professional fundraising":true,"Loan to officer or DQP":true,"Grant to related person":true,"Business relationship through family member":true,"Business relationship with organization":true},"Revenues":{"value":702252,"Contributions":{"value":81549,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":81549,"Campaigns":0,"Grant revenue":0,"Related organizations":0},"Program revenue":{"value":606859,"Total revenue":606859,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":10511,"Investment income total":10511,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":3333,"Other total":3333,"Royalties revenue":0,"Net rental income":0,"Net income from fundraising events":0,"Net income from gaming":0,"Net income":0,"Gross profit from sales of inventory":0,"Gain from sale of assets":0}},"Expenses":{"value":720356,"Grant expense":{"value":0,"Grants to domestic orgs":0,"Grants to domestic individuals":0,"Grants and similar":0,"Foreign grants":0},"Total professional fundraising expense":{"value":0,"Fundraising professional":0,"Fees to independent contractors":0},"Benefits paid to members":{"value":0,"Benefits paid to members Total":0},"Salaries":{"value":405900,"Current officers":176240,"Disqualified persons":0,"Other salaries and wages":70187,"Pension plan contributions":153984,"Other employee benefits":0,"Payroll taxes":5489},"Other expenses":{"value":314456,"Management services":0,"Legal":0,"Accounting":3425,"Lobbying services":0,"Investment management fees":0,"Other services":0,"Advertising":0,"Office expenses":2740,"Information technology":0,"Royalties":0,"Occupancy":0,"Travel":4603,"Conferences and meetings":4915,"Interest":3,"Payments to affiliates":0,"Depreciation and depletion":102887,"Insurance":13172,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":164844,"STUDENT STIPEND":109410,"REPAIRS & MAINTENANCE":22837,"SCHOOL MATERIALS":18609,"UTILITIES":13988},"All other expenses":17867},"Functional Expenses":{"value":null,"Program Service Expenses":720356,"Management And General Expenses":0,"Fundraising Expenses":0}},"Assets":{"value":1247240,"Non-interest bearing cash":195937,"Savings and temp cash investments":328753,"Pledges and grants receivable":0,"Accounts receivable":0,"Receivables from officers":0,"Receivables from disqual persons":0,"Other net note and loans":0,"Inventories for sale or use":0,"Prepaid expenses deferred charges":0,"Land, building, equipment":722550,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":0},"Liabilities":{"value":0,"Sum of Total Liabilities":0,"Accounts payable, accrued":0,"Grants payable":0,"Deferred, revenue":0,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":0,"Unsecured notes loans payable":0,"Other liabilities":0},"Fund balance":{"value":1247240,"Net assets without donor restriction":1247240,"Net assets with donor restriction":0,"Unrestricted net assets":0,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":1.0,"percentile":0.9996999186356569},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":-0.025779919459111542,"percentile":0.3270207812656993},"Liabilities to Assets Ratio":{"score":0.0,"percentile":0.9977938754541298},"Operating Reserve Ratio":{"score":1.731421685944172,"percentile":0.5777304704543558},"Officer Compensation Ratio":{"score":0.2675593734209197,"percentile":0.2202962862390949},"Program Expense Growth":{"score":0.08769921892414563,"percentile":0.6471905336842042},"Revenue Growth":{"score":0.08444148509543901,"percentile":0.7250733583231775},"Asset Growth":{"score":0.006501412100081212,"percentile":0.347114115711247},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.7204261147110262,"percentile":0.8803177676589973}},"source_xml":"202531609349301268_public.xml"},"sector":"Human Services","donation_categories":[],"zakat_policy":null},"error":null}