{"success":true,"data":{"_id":200453321,"filings":[{"Organization":{"value":null,"Person":["DEBBIE CALLEN","JAMES TORTELLI","DONNA REINDEL","GREGORY KOZARIK","LORI HOEFS","REBECCA KEENEY","THOMAS BABB","JEAN SANDLER"],"Title":["BOARD PRESIDENT","BOARD MEMBER","BOARD MEMBER","BOARD MEMBER","BOARD MEMBER","EXECUTIVE DIRECTOR","CFO","TREASURER"],"Hours":[1.0,1.0,1.0,1.0,1.0,2.5,2.5,2.5],"Total Compensation":[300,250,300,250,275,8636,8334,3223],"Direct compensation":[300,250,300,250,275,7975,7395,3221],"Other compensation":[0,0,0,0,0,661,939,2]},"Basic":{"value":null,"mission":"Constellation schools: old brooklyn community middle strives to provide an atmosphere of caring and concern for the well being of each student, to assist with learning difficulties by offering individual attention, to limit class sizes, to provide a sense of growth through special activities,and to offer areas of enrichment for its students.","year":2015,"name":"CONSTELLATION SCHOOLS OLD BROOKLYN COMMUNITY MIDDLE","phone":2167127600,"website":"WWW.CONSTELLATIONSCHOOL.COM","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"THOMAS BABB","year_formation":2003,"state_legal_domicile":"OH","total_volunteers":42,"tax_period_begin":"2015-07-01T00:00:00","tax_period_end":"2016-06-30T00:00:00","address":"5730 BROADVIEW RD, PARMA, OH, 44134, USA","city":"PARMA","state":"OH","country":"USA","zip_code":44134},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":5,"Number of independent voting members":5,"Number of employees total":35,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":35,"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":2094364,"Contributions":{"value":1982191,"Other contributions":100000,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":1882191,"Related organizations":0},"Program revenue":{"value":88484,"Total revenue":{"value":88484,"MATERIAL FEES":38151,"FIELD TRIPS":29904,"SERVICES FEES-OTHER SC":16500,"BREAKFAST/LUNCH":3929},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":0,"Investment income total":0,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":23689,"Other total":23689,"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":1958826,"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":900922,"Current officers":21568,"Disqualified persons":0,"Other salaries and wages":691042,"Pension plan contributions":97222,"Other employee benefits":75414,"Payroll taxes":15676},"Other expenses":{"value":1057904,"Management services":204990,"Legal":0,"Accounting":9584,"Lobbying services":0,"Investment management fees":0,"Other services":263552,"Advertising":3693,"Office expenses":114234,"Information technology":43912,"Royalties":0,"Occupancy":264419,"Travel":610,"Conferences and meetings":21039,"Interest":1406,"Payments to affiliates":0,"Depreciation and depletion":42963,"Insurance":10449,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":75203,"SPONSOR FEES":50592,"FUNDRAISING":10216,"STUDENT ACTIVITIES":7402,"MISCELLANEOUS EXPENSES":6993},"All other expenses":1850},"Functional Expenses":{"value":null,"Program Service Expenses":1518550,"Management And General Expenses":430060,"Fundraising Expenses":10216}},"Assets":{"value":611414,"Non-interest bearing cash":295188,"Savings and temp cash investments":0,"Pledges and grants receivable":42776,"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":185257,"Land, building, equipment":60764,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":27429},"Liabilities":{"value":1884129,"Sum of Total Liabilities":0,"Accounts payable, accrued":11559,"Grants payable":96,"Deferred, revenue":160440,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":10397,"Unsecured notes loans payable":0,"Other liabilities":1701637},"Fund balance":{"value":-1272715,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":-1272715,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.7752347579621671,"percentile":0.5971953469262807},"Fundraising Efficiency":{"score":194.0280931871574,"percentile":0.9181785277799379},"Operating Margin":{"score":0.06471558907620643,"percentile":0.5565717667693363},"Liabilities to Assets Ratio":{"score":3.0815928323525466,"percentile":0.011879069142442312},"Operating Reserve Ratio":{"score":0.3121328795921639,"percentile":0.16834466425463987},"Officer Compensation Ratio":{"score":0.011010676803350578,"percentile":0.9560425230776143},"Program Expense Growth":{"score":0.04706327073608414,"percentile":0.5201679347318469},"Revenue Growth":{"score":0.05658919556797123,"percentile":0.6330784794774474},"Asset Growth":{"score":0.35569949195685757,"percentile":0.9419988690228037},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6507125295951585,"percentile":0.7434010554791503}},"source_xml":"201741329349304719_public.xml"},{"Organization":{"value":null,"Person":["DEBBIE CALLEN","JAMES TORTELLI","DONNA REINDEL","GREGORY KOZARIK","LORI HOEFS","REBECCA KEENEY","CAROLINE ZITO","RICK LUKICH"],"Title":["BOARD MEMBER","BOARD PRESIDENT","BOARD MEMBER","BOARD MEMBER","BOARD SECRETARY","EXECUTIVE DIRECTOR","TREASURER","LEGAL COUNCIL"],"Hours":[1.0,1.0,1.0,1.0,1.0,2.5,2.5,2.5],"Total Compensation":[294,325,325,325,325,17086,8359,9300],"Direct compensation":[294,325,325,325,325,15206,7388,8639],"Other compensation":[0,0,0,0,0,1880,971,661]},"Basic":{"value":null,"mission":"Constellation schools: old brooklyn community middle strives to provide an atmosphere of caring and concern for the well being of each student, to assist with learning difficulties by offering individual attention, to limit class sizes, to provide a sense of growth through special activities,and to offer areas of enrichment for its students.","year":2020,"name":"CONSTELLATION SCHOOLS OLD BROOKLYN COMMUNITY MIDDLE","phone":2167127600,"website":"WWW.CONSTELLATIONSCHOOL.COM","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"REBECCA KEENEY","year_formation":2003,"state_legal_domicile":"OH","total_volunteers":13,"tax_period_begin":"2020-07-01T00:00:00","tax_period_end":"2021-06-30T00:00:00","address":"5730 BROADVIEW RD, PARMA, OH, 44134, USA","city":"PARMA","state":"OH","country":"USA","zip_code":44134},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":5,"Number of independent voting members":5,"Number of employees total":37,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":37,"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":2920883,"Contributions":{"value":2864799,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":2864799,"Related organizations":0},"Program revenue":{"value":46275,"Total revenue":{"value":46275,"SERVICES - OTHER SCHOO":42900,"MATERIAL FEES":3375},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":91,"Investment income total":91,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":9718,"Other total":9718,"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":2641351,"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":1419686,"Current officers":33487,"Disqualified persons":0,"Other salaries and wages":958458,"Pension plan contributions":131673,"Other employee benefits":275491,"Payroll taxes":20577},"Other expenses":{"value":1221665,"Management services":228118,"Legal":421,"Accounting":16150,"Lobbying services":0,"Investment management fees":0,"Other services":367438,"Advertising":3414,"Office expenses":110925,"Information technology":39309,"Royalties":0,"Occupancy":293619,"Travel":0,"Conferences and meetings":45088,"Interest":482,"Payments to affiliates":0,"Depreciation and depletion":9646,"Insurance":9768,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":97026,"SPONSOR FEES":59248,"ALL OTHER EXPENSES":33559,"FUNDRAISING EXPENSE":2781,"STUDENT ACTIVITIES":1438},"All other expenses":261},"Functional Expenses":{"value":null,"Program Service Expenses":2090536,"Management And General Expenses":548034,"Fundraising Expenses":2781}},"Assets":{"value":1888867,"Non-interest bearing cash":1029236,"Savings and temp cash investments":0,"Pledges and grants receivable":276095,"Accounts receivable":4290,"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":9531,"Land, building, equipment":31778,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":537937},"Liabilities":{"value":2510067,"Sum of Total Liabilities":0,"Accounts payable, accrued":112525,"Grants payable":0,"Deferred, revenue":294191,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":12907,"Unsecured notes loans payable":0,"Other liabilities":2090444},"Fund balance":{"value":-621200,"Net assets without donor restriction":-621200,"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":0.7914646709202979,"percentile":0.6147126469190304},"Fundraising Efficiency":{"score":1030.1326860841425,"percentile":0.9773549655000926},"Operating Margin":{"score":0.0957011972064612,"percentile":0.615710137141639},"Liabilities to Assets Ratio":{"score":1.3288743993092156,"percentile":0.03219712798226251},"Operating Reserve Ratio":{"score":0.7151139700857629,"percentile":0.33386490076610786},"Officer Compensation Ratio":{"score":0.013757732311987313,"percentile":0.943587131333249},"Program Expense Growth":{"score":0.0571496769185341,"percentile":0.5574009790908491},"Revenue Growth":{"score":0.0600405362025367,"percentile":0.6462657596859444},"Asset Growth":{"score":0.21524076861481478,"percentile":0.8618107914961953},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6793182820778023,"percentile":0.8096523806276439}},"source_xml":"202221369349303217_public.xml"},{"Organization":{"value":null,"Person":["LAURENE PERKINS","JAMES TORTELLI","JOSEPH SGRO","DEBBIE CALLEN","GREGORY KOZARIK","REBECCA KEENEY TERM ENDED OCT '21","DAVE MASSA","RICK LUKICH TERM ENDED OCT ' 21"],"Title":["BOARD MEMBER","BOARD PRESIDENT","BOARD MEMBER","BOARD SECRETARY","BOARD VICE PRESIDENT","EXECUTIVE DIRECTOR","TREASURER","LEGAL COUNCIL"],"Hours":[1.0,1.0,1.0,1.0,1.0,2.5,2.5,2.5],"Total Compensation":[0,0,0,0,0,0,0,0],"Direct compensation":[0,0,0,0,0,0,0,0],"Other compensation":[0,0,0,0,0,0,0,0]},"Basic":{"value":null,"mission":"Constellation schools: old brooklyn community middle strives to provide an atmosphere of caring and concern for the well being of each student, to assist with learning difficulties by offering individual attention, to limit class sizes, to provide a sense of growth through special activities,and to offer areas of enrichment for its students.","year":2021,"name":"CONSTELLATION SCHOOLS OLD BROOKLYN COMMUNITY MIDDLE","phone":2167127600,"website":"WWW.CONSTELLATIONSCHOOL.COM","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"DAVE MASSA","year_formation":2003,"state_legal_domicile":"OH","total_volunteers":0,"tax_period_begin":"2021-07-01T00:00:00","tax_period_end":"2022-06-30T00:00:00","address":"5730 BROADVIEW RD, PARMA, OH, 44134, USA","city":"PARMA","state":"OH","country":"USA","zip_code":44134},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":5,"Number of independent voting members":5,"Number of employees total":37,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":37,"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":2594798,"Contributions":{"value":2585590,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":2585590,"Related organizations":0},"Program revenue":{"value":2175,"Total revenue":2175,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":55,"Investment income total":55,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":6978,"Other total":6978,"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":1914236,"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":820494,"Current officers":0,"Disqualified persons":0,"Other salaries and wages":825894,"Pension plan contributions":0,"Other employee benefits":-5400,"Payroll taxes":0},"Other expenses":{"value":1093742,"Management services":318746,"Legal":514,"Accounting":19669,"Lobbying services":0,"Investment management fees":0,"Other services":239844,"Advertising":2351,"Office expenses":44012,"Information technology":55116,"Royalties":0,"Occupancy":309482,"Travel":13870,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":8978,"Insurance":8392,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":72768,"SPONSOR FEES":54363,"STUDENT ACTIVITIES":12274,"ALL OTHER EXPENSES":6131},"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":1387516,"Management And General Expenses":526720,"Fundraising Expenses":0}},"Assets":{"value":2360617,"Non-interest bearing cash":1578960,"Savings and temp cash investments":0,"Pledges and grants receivable":131755,"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":41122,"Land, building, equipment":36543,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":572237},"Liabilities":{"value":2301255,"Sum of Total Liabilities":0,"Accounts payable, accrued":74856,"Grants payable":0,"Deferred, revenue":1105048,"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":1121351},"Fund balance":{"value":59362,"Net assets without donor restriction":59362,"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":0.7248406152637397,"percentile":0.5533027075797733},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.26227937588976097,"percentile":0.8100466731163787},"Liabilities to Assets Ratio":{"score":0.9748531845699663,"percentile":0.05495421420998209},"Operating Reserve Ratio":{"score":1.2331901604608837,"percentile":0.48317782072442045},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":0.02988370434669672,"percentile":0.4483946457629428},"Revenue Growth":{"score":0.05103618713306087,"percentile":0.6106433331065602},"Asset Growth":{"score":0.19536859825060268,"percentile":0.8418358950406061},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6377126500587155,"percentile":0.7105443723010817}},"source_xml":"202341319349305309_public.xml"},{"Organization":{"value":null,"Person":["JAMES TORTELLI","RANDOLPH RAND LAYCOCK","DEBBIE CALLEN","ROBERT ANZALONE","LAURA TRIVISON","GERALD PRESEREN","THOMAS BABB","REBECCA KEENEY"],"Title":["BOARD MEMBER","BOARD MEMBER","BOARD PRESIDENT","BOARD MEMBER","SECRETARY","FORMER EXECUTIVE DIRECTOR","TREASURER/CFO","EXECUTIVE DIRECTOR"],"Hours":[1.0,1.0,1.0,1.0,1.0,2.5,2.5,2.5],"Total Compensation":[300,225,275,300,300,5883,7492,577],"Direct compensation":[300,225,275,300,300,5446,6741,575],"Other compensation":[0,0,0,0,0,437,751,2]},"Basic":{"value":null,"mission":"Constellation schools: old brooklyn community middle strives to provide an atmosphere of caring and concern for the well being of each student, to assist with learning difficulties by offering individual attention, to limit class sizes, to provide a sense of growth through special activities,and to offer areas of enrichment for its students.","year":2013,"name":"CONSTELLATION SCHOOLS OLD BROOKLYN COMMUNITY MIDDLE","phone":2167127600,"website":"WWW.CONSTELLATIONSCHOOL.COM","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"THOMAS BABB","year_formation":2003,"state_legal_domicile":"OH","total_volunteers":40,"tax_period_begin":"2013-07-01T00:00:00","tax_period_end":"2014-06-30T00:00:00","address":"5730 BROADVIEW RD, PARMA, OH, 44134, USA","city":"PARMA","state":"OH","country":"USA","zip_code":44134},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":5,"Number of independent voting members":5,"Number of employees total":28,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":28,"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":1876909,"Contributions":{"value":1748822,"Other contributions":200000,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":1548822,"Related organizations":0},"Program revenue":{"value":63366,"Total revenue":{"value":63366,"MATERIAL FEES":34008,"FIELD TRIPS":25492,"BREAKFAST/LUNCH":3866},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":0,"Investment income total":0,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":64721,"Other total":64721,"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":1808738,"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":835441,"Current officers":15351,"Disqualified persons":0,"Other salaries and wages":633516,"Pension plan contributions":89976,"Other employee benefits":80879,"Payroll taxes":15719},"Other expenses":{"value":973297,"Management services":188270,"Legal":0,"Accounting":8238,"Lobbying services":0,"Investment management fees":0,"Other services":289757,"Advertising":2243,"Office expenses":82718,"Information technology":17999,"Royalties":0,"Occupancy":264133,"Travel":1311,"Conferences and meetings":15151,"Interest":271,"Payments to affiliates":0,"Depreciation and depletion":26191,"Insurance":8365,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":67585,"SPONSOR FEES":41075,"FUNDRAISING EXPENSE":21212,"STUDENT ACTIVITIES":3549,"DUES & SUBSCRIPTIONS":1749},"All other expenses":1065},"Functional Expenses":{"value":null,"Program Service Expenses":1385250,"Management And General Expenses":402276,"Fundraising Expenses":21212}},"Assets":{"value":294859,"Non-interest bearing cash":154662,"Savings and temp cash investments":0,"Pledges and grants receivable":10664,"Accounts receivable":9776,"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":92799,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":26958},"Liabilities":{"value":66552,"Sum of Total Liabilities":0,"Accounts payable, accrued":2435,"Grants payable":0,"Deferred, revenue":7800,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":1802,"Unsecured notes loans payable":0,"Other liabilities":54515},"Fund balance":{"value":228307,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":228307,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.7658654818995344,"percentile":0.5879848630098362},"Fundraising Efficiency":{"score":82.44493682821044,"percentile":0.8470848130322955},"Operating Margin":{"score":0.03632088716075207,"percentile":0.49331227903842906},"Liabilities to Assets Ratio":{"score":0.2257078807158676,"percentile":0.23684334508294372},"Operating Reserve Ratio":{"score":0.16301918796420486,"percentile":0.09786694673823662},"Officer Compensation Ratio":{"score":0.008487685889277495,"percentile":0.9670205372575086},"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.6367815939341894,"percentile":0.708135756801029}},"source_xml":"201531319349302918_public.xml"},{"Organization":{"value":null,"Person":["DONNA REINDEL","JAMES TORTELLI","LORI HOEFS","DEBBIE CALLEN","GREGORY KOZARIK","DAVE MASSA"],"Title":["BOARD VICE PRESIDENT","BOARD PRESIDENT","BOARD SECRETARY","BOARD MEMBER","BOARD MEMBER","TREASURER"],"Hours":[1.0,1.0,1.0,1.0,1.0,2.5],"Total Compensation":[0,0,0,0,0,0],"Direct compensation":[0,0,0,0,0,0],"Other compensation":[0,0,0,0,0,0]},"Basic":{"value":null,"mission":"Constellation schools: old brooklyn community middle strives to provide an atmosphere of caring and concern for the well being of each student, to assist with learning difficulties by offering individual attention, to limit class sizes, to provide a sense of growth through special activities, and to offer areas of enrichment for its students.","year":2023,"name":"CONSTELLATION SCHOOLS OLD BROOKLYN COMMUNITY MIDDLE","phone":2167127600,"website":"WWW.CONSTELLATIONSCHOOL.COM","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"DAVE MASSA","year_formation":2003,"state_legal_domicile":"OH","total_volunteers":5,"tax_period_begin":"2023-07-01T00:00:00","tax_period_end":"2024-06-30T00:00:00","address":"5730 BROADVIEW RD, PARMA, OH, 44134, USA","city":"PARMA","state":"OH","country":"USA","zip_code":44134},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":5,"Number of independent voting members":5,"Number of employees total":33,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":33,"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":3531667,"Contributions":{"value":3408235,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":3408235,"Related organizations":0},"Program revenue":{"value":1750,"Total revenue":1750,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":113922,"Investment income total":113922,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":7760,"Other total":7760,"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":2948570,"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":775547,"Current officers":0,"Disqualified persons":0,"Other salaries and wages":712092,"Pension plan contributions":0,"Other employee benefits":63455,"Payroll taxes":0},"Other expenses":{"value":2173023,"Management services":349726,"Legal":144,"Accounting":27876,"Lobbying services":0,"Investment management fees":0,"Other services":1196757,"Advertising":17059,"Office expenses":147614,"Information technology":0,"Royalties":0,"Occupancy":322028,"Travel":0,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":31213,"Insurance":9157,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":71449,"START UP":44246,"STUDENT ACTIVITIES":27203},"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":2304886,"Management And General Expenses":643684,"Fundraising Expenses":0}},"Assets":{"value":3278856,"Non-interest bearing cash":26038,"Savings and temp cash investments":2577382,"Pledges and grants receivable":61833,"Accounts receivable":65933,"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":43577,"Land, building, equipment":91297,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":412796},"Liabilities":{"value":2157945,"Sum of Total Liabilities":0,"Accounts payable, accrued":306909,"Grants payable":0,"Deferred, revenue":481017,"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":1370019},"Fund balance":{"value":1120911,"Net assets without donor restriction":1120911,"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":0.7816962120621183,"percentile":0.6039665117253269},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.16510531712078177,"percentile":0.7177243508287378},"Liabilities to Assets Ratio":{"score":0.6581396072288628,"percentile":0.10089383891071116},"Operating Reserve Ratio":{"score":1.1120156550463445,"percentile":0.4538135534134329},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":0.04282621647665348,"percentile":0.5033997400173608},"Revenue Growth":{"score":0.06056301493127961,"percentile":0.6482056502356901},"Asset Growth":{"score":0.17462323959586762,"percentile":0.8173020446464042},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6458599122219995,"percentile":0.7313343797865084}},"source_xml":"202531269349302273_public.xml"},{"Organization":{"value":null,"Person":["DEBBIE CALLEN","JAMES TORTELLI","DONNA REINDEL","GREGORY KOZARIK","LORI HOEFS","REBECCA KEENEY","THOMAS BABB"],"Title":["BOARD MEMBER","BOARD PRESIDENT","BOARD MEMBER","BOARD MEMBER","BOARD SECRETARY","EXECUTIVE DIRECTOR","CFO"],"Hours":[1.0,1.0,1.0,1.0,1.0,2.5,2.5],"Total Compensation":[175,275,300,250,225,8257,8556],"Direct compensation":[175,275,300,250,225,7550,7550],"Other compensation":[0,0,0,0,0,707,1006]},"Basic":{"value":null,"mission":"Constellation schools: old brooklyn community middle strives to provide an atmosphere of caring and concern for the well being of each student, to assist with learning difficulties by offering individual attention, to limit class sizes, to provide a sense of growth through special activities,and to offer areas of enrichment for its students.","year":2016,"name":"CONSTELLATION SCHOOLS OLD BROOKLYN COMMUNITY MIDDLE","phone":2167127600,"website":"WWW.CONSTELLATIONSCHOOL.COM","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"THOMAS BABB","year_formation":2003,"state_legal_domicile":"OH","total_volunteers":23,"tax_period_begin":"2016-07-01T00:00:00","tax_period_end":"2017-06-30T00:00:00","address":"5730 BROADVIEW RD, PARMA, OH, 44134, USA","city":"PARMA","state":"OH","country":"USA","zip_code":44134},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":5,"Number of independent voting members":5,"Number of employees total":30,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":30,"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":2237263,"Contributions":{"value":2092500,"Other contributions":25000,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":2067500,"Related organizations":0},"Program revenue":{"value":116227,"Total revenue":{"value":116227,"field trips":42406,"MATERIAL FEES":40676,"SERVICES FEES-OTHER SC":30500,"Breakfast/Lunch":2645},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":23,"Investment income total":23,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":28513,"Other total":28513,"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":2103355,"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":1072909,"Current officers":18038,"Disqualified persons":0,"Other salaries and wages":799799,"Pension plan contributions":120235,"Other employee benefits":116881,"Payroll taxes":17956},"Other expenses":{"value":1030446,"Management services":216996,"Legal":5969,"Accounting":12499,"Lobbying services":0,"Investment management fees":0,"Other services":224041,"Advertising":1125,"Office expenses":113308,"Information technology":25430,"Royalties":0,"Occupancy":288124,"Travel":1491,"Conferences and meetings":29600,"Interest":1074,"Payments to affiliates":0,"Depreciation and depletion":38047,"Insurance":12915,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":58599,"SPONSOR FEES":51223,"STUDENT ACTIVITIES":3924,"MISCELLANEOUS EXPENSES":1971,"DUES & SUBSCRIPTIONS":1481},"All other expenses":1228},"Functional Expenses":{"value":null,"Program Service Expenses":1616550,"Management And General Expenses":485577,"Fundraising Expenses":1228}},"Assets":{"value":1275105,"Non-interest bearing cash":484895,"Savings and temp cash investments":0,"Pledges and grants receivable":38017,"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":667246,"Land, building, equipment":57518,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":27429},"Liabilities":{"value":2915050,"Sum of Total Liabilities":0,"Accounts payable, accrued":56322,"Grants payable":9053,"Deferred, revenue":23380,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":6223,"Unsecured notes loans payable":0,"Other liabilities":2820072},"Fund balance":{"value":-1639945,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":-1639945,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.7685578516227646,"percentile":0.5906066477085062},"Fundraising Efficiency":{"score":1703.9902280130293,"percentile":0.9849365925593103},"Operating Margin":{"score":0.05985349062671666,"percentile":0.5464088847059284},"Liabilities to Assets Ratio":{"score":2.2861254563349687,"percentile":0.015934487318778237},"Operating Reserve Ratio":{"score":0.6062243415876065,"percentile":0.2936269099899581},"Officer Compensation Ratio":{"score":0.008575822911491403,"percentile":0.9666391052317724},"Program Expense Growth":{"score":0.05917826268873124,"percentile":0.5644232524222345},"Revenue Growth":{"score":0.06912157454315265,"percentile":0.6785504210561975},"Asset Growth":{"score":0.4786914791433512,"percentile":0.9697176229741448},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6706626660553373,"percentile":0.7905408445713058}},"source_xml":"201830439349301203_public.xml"},{"Organization":{"value":null,"Person":["LAURENE PERKINS","JAMES TORTELLI","JOSEPH SGRO","DEBBIE CALLEN","DAVE MASSA"],"Title":["BOARD MEMBER","BOARD PRESIDENT","BOARD MEMBER","BOARD SECRETARY","TREASURER"],"Hours":[1.0,1.0,1.0,1.0,2.5],"Total Compensation":[0,0,0,0,0],"Direct compensation":[0,0,0,0,0],"Other compensation":[0,0,0,0,0]},"Basic":{"value":null,"mission":"Constellation schools: old brooklyn community middle strives to provide an atmosphere of caring and concern for the well being of each student, to assist with learning difficulties by offering individual attention, to limit class sizes, to provide a sense of growth through special activities,and to offer areas of enrichment for its students.","year":2022,"name":"CONSTELLATION SCHOOLS OLD BROOKLYN COMMUNITY MIDDLE","phone":2167127600,"website":"WWW.CONSTELLATIONSCHOOL.COM","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"DAVE MASSA","year_formation":2003,"state_legal_domicile":"OH","total_volunteers":0,"tax_period_begin":"2022-07-01T00:00:00","tax_period_end":"2023-06-30T00:00:00","address":"5730 BROADVIEW RD, PARMA, OH, 44134, USA","city":"PARMA","state":"OH","country":"USA","zip_code":44134},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":4,"Number of independent voting members":4,"Number of employees total":34,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":34,"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":3137966,"Contributions":{"value":3089577,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":3089577,"Related organizations":0},"Program revenue":{"value":2096,"Total revenue":2096,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":32524,"Investment income total":32524,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":13769,"Other total":13769,"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":2659514,"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":1017519,"Current officers":0,"Disqualified persons":0,"Other salaries and wages":897621,"Pension plan contributions":0,"Other employee benefits":119898,"Payroll taxes":0},"Other expenses":{"value":1641995,"Management services":323320,"Legal":3609,"Accounting":23524,"Lobbying services":0,"Investment management fees":0,"Other services":660955,"Advertising":16181,"Office expenses":138676,"Information technology":37316,"Royalties":0,"Occupancy":291660,"Travel":26101,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":14563,"Insurance":1555,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":104535,"SPONSOR FEES":62763,"STUDENT ACTIVITIES":34929,"ALL OTHER EXPENSES":6843},"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":2073120,"Management And General Expenses":586394,"Fundraising Expenses":0}},"Assets":{"value":2844900,"Non-interest bearing cash":1870801,"Savings and temp cash investments":0,"Pledges and grants receivable":351517,"Accounts receivable":4144,"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":50605,"Land, building, equipment":39316,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":528517},"Liabilities":{"value":2307086,"Sum of Total Liabilities":0,"Accounts payable, accrued":225413,"Grants payable":0,"Deferred, revenue":562198,"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":1519475},"Fund balance":{"value":537814,"Net assets without donor restriction":537814,"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":0.7795108429585255,"percentile":0.6015807641803549},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.15247201531182938,"percentile":0.7018160348374124},"Liabilities to Assets Ratio":{"score":0.8109550423564976,"percentile":0.07745955233492781},"Operating Reserve Ratio":{"score":1.0697067208520052,"percentile":0.44277734855835155},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":0.035903757079203874,"percentile":0.47443618300241386},"Revenue Growth":{"score":0.055042545769324956,"percentile":0.6269491644528286},"Asset Growth":{"score":0.18415168236759133,"percentile":0.8290606749360145},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.635606792332437,"percentile":0.7050741913169452}},"source_xml":"202411329349300231_public.xml"},{"Organization":{"value":null,"Person":["DEBBIE CALLEN","LAURA TRIVISON","JAMES TORTELLI","RANDOLPH RAND LAYCOCK","ROBERT ANZALONE","REBECCA KEENEY","THOMAS BABB","JEAN SANDLER"],"Title":["BOARD PRESIDENT","BOARD SECRETARY","BOARD MEMBER","BOARD MEMBER","BOARD MEMBER","EXECUTIVE DIRECTOR","CFO","TREASURER"],"Hours":[1.0,1.0,1.0,1.0,1.0,2.5,2.5,2.5],"Total Compensation":[300,175,300,175,275,7192,7445,2843],"Direct compensation":[300,175,300,175,275,6591,6591,2841],"Other compensation":[0,0,0,0,0,601,854,2]},"Basic":{"value":null,"mission":"Constellation schools: old brooklyn community middle strives to provide an atmosphere of caring and concern for the well being of each student, to assist with learning difficulties by offering individual attention, to limit class sizes, to provide a sense of growth through special activities,and to offer areas of enrichment for its students.","year":2014,"name":"CONSTELLATION SCHOOLS OLD BROOKLYN COMMUNITY MIDDLE","phone":2167127600,"website":"WWW.CONSTELLATIONSCHOOL.COM","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"THOMAS BABB","year_formation":2003,"state_legal_domicile":"OH","total_volunteers":42,"tax_period_begin":"2014-07-01T00:00:00","tax_period_end":"2015-06-30T00:00:00","address":"5730 BROADVIEW RD, PARMA, OH, 44134, USA","city":"PARMA","state":"OH","country":"USA","zip_code":44134},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":5,"Number of independent voting members":5,"Number of employees total":31,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":31,"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":1792769,"Contributions":{"value":1662325,"Other contributions":75000,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":1587325,"Related organizations":0},"Program revenue":{"value":97056,"Total revenue":{"value":97056,"SERVICES FEES-OTHER SC":49500,"MATERIAL FEES":33550,"FIELD TRIPS":10864,"BREAKFAST/LUNCH":3142},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":0,"Investment income total":0,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":33388,"Other total":33388,"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":1773941,"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":842702,"Current officers":18704,"Disqualified persons":0,"Other salaries and wages":632176,"Pension plan contributions":89085,"Other employee benefits":87977,"Payroll taxes":14760},"Other expenses":{"value":931239,"Management services":187021,"Legal":0,"Accounting":8414,"Lobbying services":0,"Investment management fees":0,"Other services":220245,"Advertising":1470,"Office expenses":90396,"Information technology":12260,"Royalties":0,"Occupancy":264169,"Travel":3489,"Conferences and meetings":27759,"Interest":1876,"Payments to affiliates":0,"Depreciation and depletion":37024,"Insurance":9203,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":67913,"SPONSOR FEES":42162,"MISCELLANEOUS EXPENSES":20892,"STUDENT ACTIVITIES":2794,"DUES & SUBSCRIPTIONS":2065},"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":1344736,"Management And General Expenses":411405,"Fundraising Expenses":17800}},"Assets":{"value":428653,"Non-interest bearing cash":176056,"Savings and temp cash investments":0,"Pledges and grants receivable":22360,"Accounts receivable":7218,"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":106235,"Land, building, equipment":89355,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":27429},"Liabilities":{"value":1863558,"Sum of Total Liabilities":0,"Accounts payable, accrued":18033,"Grants payable":0,"Deferred, revenue":285619,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":14405,"Unsecured notes loans payable":0,"Other liabilities":1545501},"Fund balance":{"value":-1434905,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":-1434905,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.7580500140647293,"percentile":0.5806391128869841},"Fundraising Efficiency":{"score":93.38904494382022,"percentile":0.8599919162593594},"Operating Margin":{"score":0.010502189629561868,"percentile":0.4264297705229953},"Liabilities to Assets Ratio":{"score":4.347474530680993,"percentile":0.008812822315410671},"Operating Reserve Ratio":{"score":0.2416388143686853,"percentile":0.13515056507753534},"Officer Compensation Ratio":{"score":0.010544319117715865,"percentile":0.9581157355606489},"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.6100794006983761,"percentile":0.6347093812613954}},"source_xml":"201641349349302894_public.xml"},{"Organization":{"value":null,"Person":["DEBBIE CALLEN","JAMES TORTELLI","DONNA REINDEL","GREGORY KOZARIK","LORI HOEFS","REBECCA KEENEY","THOMAS BABB","CAROLINE ZITO","RICK LUKICH"],"Title":["BOARD MEMBER","BOARD PRESIDENT","BOARD MEMBER","BOARD MEMBER","BOARD SECRETARY","EXECUTIVE DIRECTOR","CFO TIL 06/19","TREASURER","LEGAL COUNCIL"],"Hours":[1.0,1.0,1.0,1.0,1.0,2.5,2.5,2.5,2.5],"Total Compensation":[313,281,344,344,313,14546,506,8228,8614],"Direct compensation":[313,281,344,344,313,11574,506,6572,8000],"Other compensation":[0,0,0,0,0,2972,0,1656,614]},"Basic":{"value":null,"mission":"Constellation schools: old brooklyn community middle strives to provide an atmosphere of caring and concern for the well being of each student, to assist with learning difficulties by offering individual attention, to limit class sizes, to provide a sense of growth through special activities,and to offer areas of enrichment for its students.","year":2019,"name":"CONSTELLATION SCHOOLS OLD BROOKLYN COMMUNITY MIDDLE","phone":2167127600,"website":"WWW.CONSTELLATIONSCHOOL.COM","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"REBECCA KEENEY","year_formation":2003,"state_legal_domicile":"OH","total_volunteers":13,"tax_period_begin":"2019-07-01T00:00:00","tax_period_end":"2020-06-30T00:00:00","address":"5730 BROADVIEW RD, PARMA, OH, 44134, USA","city":"PARMA","state":"OH","country":"USA","zip_code":44134},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":5,"Number of independent voting members":5,"Number of employees total":39,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":39,"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":2389817,"Contributions":{"value":2298027,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":2298027,"Related organizations":0},"Program revenue":{"value":77871,"Total revenue":{"value":77871,"SERVICES FEES-OTHER SC":67575,"MATERIAL FEES":7527,"BREAKFAST/LUNCH":2644,"FIELD TRIPS":125},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":554,"Investment income total":554,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":13365,"Other total":13365,"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":2323683,"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":1232566,"Current officers":33487,"Disqualified persons":0,"Other salaries and wages":923721,"Pension plan contributions":131673,"Other employee benefits":123108,"Payroll taxes":20577},"Other expenses":{"value":1091117,"Management services":228118,"Legal":421,"Accounting":16150,"Lobbying services":0,"Investment management fees":0,"Other services":236889,"Advertising":3414,"Office expenses":110925,"Information technology":39309,"Royalties":0,"Occupancy":293619,"Travel":0,"Conferences and meetings":45088,"Interest":482,"Payments to affiliates":0,"Depreciation and depletion":9646,"Insurance":9768,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":97027,"SPONSOR FEES":59248,"ALL OTHER EXPENSES":33559,"FUNDRAISING EXPENSE":2781,"STUDENT ACTIVITIES":1439},"All other expenses":261},"Functional Expenses":{"value":null,"Program Service Expenses":1772868,"Management And General Expenses":548034,"Fundraising Expenses":2781}},"Assets":{"value":1813552,"Non-interest bearing cash":1162326,"Savings and temp cash investments":0,"Pledges and grants receivable":9756,"Accounts receivable":725,"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":470518,"Land, building, equipment":33190,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":137037},"Liabilities":{"value":2714284,"Sum of Total Liabilities":0,"Accounts payable, accrued":92549,"Grants payable":22617,"Deferred, revenue":385711,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":25814,"Unsecured notes loans payable":0,"Other liabilities":2187593},"Fund balance":{"value":-900732,"Net assets without donor restriction":-900732,"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":0.7629560486520752,"percentile":0.5852053845472195},"Fundraising Efficiency":{"score":826.3311758360302,"percentile":0.9730471573938865},"Operating Margin":{"score":0.02767324862112873,"percentile":0.4720143706160521},"Liabilities to Assets Ratio":{"score":1.496667313647472,"percentile":0.027161551407413234},"Operating Reserve Ratio":{"score":0.7804644609441133,"percentile":0.35635038505462224},"Officer Compensation Ratio":{"score":0.014412034688036191,"percentile":0.9404462998895752},"Program Expense Growth":{"score":0.049617012747087685,"percentile":0.5299271380230179},"Revenue Growth":{"score":0.05046433582036706,"percentile":0.6083067294800371},"Asset Growth":{"score":0.2598758375681122,"percentile":0.8967701545379129},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6466356361377208,"percentile":0.7332946296313703}},"source_xml":"202141309349301424_public.xml"},{"Organization":{"value":null,"Person":["DEBBIE CALLEN","JAMES TORTELLI","DONNA REINDEL","GREGORY KOZARIK","LORI HOEFS","REBECCA KEENEY","THOMAS BABB","CAROLINE ZITO"],"Title":["BOARD MEMBER","BOARD PRESIDENT","BOARD MEMBER","BOARD MEMBER","BOARD SECRETARY","EXECUTIVE DIRECTOR","CFO","TREASURER"],"Hours":[1.0,1.0,1.0,1.0,1.0,2.5,2.5,2.5],"Total Compensation":[281,281,313,313,406,8817,9158,4345],"Direct compensation":[281,281,313,313,406,8105,8105,3532],"Other compensation":[0,0,0,0,0,712,1053,813]},"Basic":{"value":null,"mission":"Constellation schools: old brooklyn community middle strives to provide an atmosphere of caring and concern for the well being of each student, to assist with learning difficulties by offering individual attention, to limit class sizes, to provide a sense of growth through special activities,and to offer areas of enrichment for its students.","year":2017,"name":"CONSTELLATION SCHOOLS OLD BROOKLYN COMMUNITY MIDDLE","phone":2167127600,"website":"WWW.CONSTELLATIONSCHOOL.COM","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"THOMAS BABB","year_formation":2003,"state_legal_domicile":"OH","total_volunteers":23,"tax_period_begin":"2017-07-01T00:00:00","tax_period_end":"2018-06-30T00:00:00","address":"5730 BROADVIEW RD, PARMA, OH, 44134, USA","city":"PARMA","state":"OH","country":"USA","zip_code":44134},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":5,"Number of independent voting members":5,"Number of employees total":36,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":36,"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":2347918,"Contributions":{"value":2195891,"Other contributions":1473,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":2194418,"Related organizations":0},"Program revenue":{"value":123755,"Total revenue":{"value":123755,"SERVICES FEES-OTHER SC":49100,"MATERIAL FEES":42733,"FIELD TRIPS":29095,"BREAKFAST/LUNCH":2827},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":96,"Investment income total":96,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":28176,"Other total":28176,"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":2213466,"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":1125133,"Current officers":23914,"Disqualified persons":0,"Other salaries and wages":847128,"Pension plan contributions":118635,"Other employee benefits":117242,"Payroll taxes":18214},"Other expenses":{"value":1088333,"Management services":221997,"Legal":1075,"Accounting":12191,"Lobbying services":0,"Investment management fees":0,"Other services":263566,"Advertising":2815,"Office expenses":109369,"Information technology":46940,"Royalties":0,"Occupancy":287650,"Travel":1308,"Conferences and meetings":32903,"Interest":1618,"Payments to affiliates":0,"Depreciation and depletion":21992,"Insurance":12638,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":70515,"SPONSOR FEES":56946,"FUNDRAISING":7681,"MISCELLANEOUS EXPENSES":3026,"STUDENT ACTIVITIES":2862},"All other expenses":1756},"Functional Expenses":{"value":null,"Program Service Expenses":1712579,"Management And General Expenses":493206,"Fundraising Expenses":7681}},"Assets":{"value":1521599,"Non-interest bearing cash":669712,"Savings and temp cash investments":0,"Pledges and grants receivable":33593,"Accounts receivable":2111,"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":752763,"Land, building, equipment":35526,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":27894},"Liabilities":{"value":2736783,"Sum of Total Liabilities":0,"Accounts payable, accrued":91706,"Grants payable":4236,"Deferred, revenue":369605,"Tax exempt bond liabilities":0,"Escrow account liability":0,"Loans from officers, directors":0,"Secured mortgages and notes payable":2267,"Unsecured notes loans payable":0,"Other liabilities":2268969},"Fund balance":{"value":-1215184,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":-1215184,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.7737091963463636,"percentile":0.595661508221021},"Fundraising Efficiency":{"score":285.8860825413358,"percentile":0.9386816590293559},"Operating Margin":{"score":0.05726435079930389,"percentile":0.5408947681313573},"Liabilities to Assets Ratio":{"score":1.7986230274862167,"percentile":0.02113311636702702},"Operating Reserve Ratio":{"score":0.6874282234287764,"percentile":0.32395858826306384},"Officer Compensation Ratio":{"score":0.010803870490895274,"percentile":0.956970951094163},"Program Expense Growth":{"score":0.06113176024540542,"percentile":0.5711181909869829},"Revenue Growth":{"score":0.06698628486409076,"percentile":0.6712444052117515},"Asset Growth":{"score":0.39934989338348303,"percentile":0.9544323287897059},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6670876258831694,"percentile":0.7825464569413982}},"source_xml":"201941339349305789_public.xml"},{"Organization":{"value":null,"Person":["DEBBIE CALLEN","JAMES TORTELLI","DONNA REINDEL","GREGORY KOZARIK","LORI HOEFS","REBECCA KEENEY","THOMAS BABB","CAROLINE ZITO"],"Title":["BOARD MEMBER","BOARD PRESIDENT","BOARD MEMBER","BOARD MEMBER","BOARD SECRETARY","EXECUTIVE DIRECTOR","CFO","TREASURER"],"Hours":[1.0,1.0,1.0,1.0,1.0,2.5,2.5,2.5],"Total Compensation":[313,344,375,281,344,8619,8487,5672],"Direct compensation":[313,344,375,281,344,7821,7505,4533],"Other compensation":[0,0,0,0,0,798,982,1139]},"Basic":{"value":null,"mission":"Constellation schools: old brooklyn community middle strives to provide an atmosphere of caring and concern for the well being of each student, to assist with learning difficulties by offering individual attention, to limit class sizes, to provide a sense of growth through special activities,and to offer areas of enrichment for its students.","year":2018,"name":"CONSTELLATION SCHOOLS OLD BROOKLYN COMMUNITY MIDDLE","phone":2167127600,"website":"WWW.CONSTELLATIONSCHOOL.COM","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"REBECCA KEENEY","year_formation":2003,"state_legal_domicile":"OH","total_volunteers":0,"tax_period_begin":"2018-07-01T00:00:00","tax_period_end":"2019-06-30T00:00:00","address":"5730 BROADVIEW RD, PARMA, OH, 44134, USA","city":"PARMA","state":"OH","country":"USA","zip_code":44134},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":5,"Number of independent voting members":5,"Number of employees total":39,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":39,"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":2427354,"Contributions":{"value":2302506,"Other contributions":1300,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":2301206,"Related organizations":0},"Program revenue":{"value":102395,"Total revenue":{"value":102395,"SERVICES FEES-OTHER SC":57600,"FIELD TRIPS":30003,"MATERIAL FEES":11760,"BREAKFAST/LUNCH":3032},"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":198,"Investment income total":198,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":22255,"Other total":22255,"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":2271249,"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":1181610,"Current officers":24433,"Disqualified persons":0,"Other salaries and wages":896899,"Pension plan contributions":125961,"Other employee benefits":113877,"Payroll taxes":20440},"Other expenses":{"value":1089639,"Management services":222223,"Legal":991,"Accounting":12596,"Lobbying services":0,"Investment management fees":0,"Other services":274980,"Advertising":4305,"Office expenses":94014,"Information technology":39600,"Royalties":0,"Occupancy":291494,"Travel":434,"Conferences and meetings":49813,"Interest":873,"Payments to affiliates":0,"Depreciation and depletion":14087,"Insurance":13011,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":70122,"SPONSOR FEES":59859,"FUNDRAISING":6553,"MISCELLANEOUS EXPENSES":1882,"STUDENT ACTIVITIES":1828},"All other expenses":1096},"Functional Expenses":{"value":null,"Program Service Expenses":1769811,"Management And General Expenses":494885,"Fundraising Expenses":6553}},"Assets":{"value":1635694,"Non-interest bearing cash":834594,"Savings and temp cash investments":0,"Pledges and grants receivable":29353,"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":595367,"Land, building, equipment":42835,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":133545},"Liabilities":{"value":2503338,"Sum of Total Liabilities":0,"Accounts payable, accrued":107056,"Grants payable":11139,"Deferred, revenue":474718,"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":1910425},"Fund balance":{"value":-867644,"Net assets without donor restriction":0,"Net assets with donor restriction":0,"Unrestricted net assets":-867644,"Temporarily restricted net assets":0,"Permanently restricted net assets":0},"Ratings":{"Program Expense Ratio":{"score":0.7792236782492805,"percentile":0.6012893428822311},"Fundraising Efficiency":{"score":351.3667022737677,"percentile":0.9474960085330507},"Operating Margin":{"score":0.06431076802147524,"percentile":0.5557335215937297},"Liabilities to Assets Ratio":{"score":1.5304439583442868,"percentile":0.02631822598908941},"Operating Reserve Ratio":{"score":0.7201737898398635,"percentile":0.3356649278059212},"Officer Compensation Ratio":{"score":0.010758397692194912,"percentile":0.9571750978121626},"Program Expense Growth":{"score":0.057298902322478744,"percentile":0.5579155459164131},"Revenue Growth":{"score":0.06119105073515163,"percentile":0.6505078179352947},"Asset Growth":{"score":0.31646379796641516,"percentile":0.9271820584513911},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6681149073062539,"percentile":0.784851280391922}},"source_xml":"202001359349302815_public.xml"}],"Latest":{"Organization":{"value":null,"Person":["DONNA REINDEL","JAMES TORTELLI","LORI HOEFS","DEBBIE CALLEN","GREGORY KOZARIK","DAVE MASSA"],"Title":["BOARD VICE PRESIDENT","BOARD PRESIDENT","BOARD SECRETARY","BOARD MEMBER","BOARD MEMBER","TREASURER"],"Hours":[1.0,1.0,1.0,1.0,1.0,2.5],"Total Compensation":[0,0,0,0,0,0],"Direct compensation":[0,0,0,0,0,0],"Other compensation":[0,0,0,0,0,0]},"Basic":{"value":null,"mission":"Constellation schools: old brooklyn community middle strives to provide an atmosphere of caring and concern for the well being of each student, to assist with learning difficulties by offering individual attention, to limit class sizes, to provide a sense of growth through special activities, and to offer areas of enrichment for its students.","year":2023,"name":"CONSTELLATION SCHOOLS OLD BROOKLYN COMMUNITY MIDDLE","phone":2167127600,"website":"WWW.CONSTELLATIONSCHOOL.COM","type":"990","affiliation":null,"foreign_countries":null,"principal_officer":"DAVE MASSA","year_formation":2003,"state_legal_domicile":"OH","total_volunteers":5,"tax_period_begin":"2023-07-01T00:00:00","tax_period_end":"2024-06-30T00:00:00","address":"5730 BROADVIEW RD, PARMA, OH, 44134, USA","city":"PARMA","state":"OH","country":"USA","zip_code":44134},"Governance":{"value":null,"501c3 determination":true,"501c determination":false,"Number of voting members":5,"Number of independent voting members":5,"Number of employees total":33,"Total Gross UBI":0,"Net unrelated business taxable income":0,"Number of employees":33,"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":3531667,"Contributions":{"value":3408235,"Other contributions":0,"Contributions from gifts and grants":0,"Fundraising revenue":0,"Dues":0,"Campaigns":0,"Grant revenue":3408235,"Related organizations":0},"Program revenue":{"value":1750,"Total revenue":1750,"Total other revenue":0,"Unrelated business revenue":0},"Investment income":{"value":113922,"Investment income total":113922,"Net investment gain":0,"Income from invest bond proceeds":0},"Other revenues":{"value":7760,"Other total":7760,"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":2948570,"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":775547,"Current officers":0,"Disqualified persons":0,"Other salaries and wages":712092,"Pension plan contributions":0,"Other employee benefits":63455,"Payroll taxes":0},"Other expenses":{"value":2173023,"Management services":349726,"Legal":144,"Accounting":27876,"Lobbying services":0,"Investment management fees":0,"Other services":1196757,"Advertising":17059,"Office expenses":147614,"Information technology":0,"Royalties":0,"Occupancy":322028,"Travel":0,"Conferences and meetings":0,"Interest":0,"Payments to affiliates":0,"Depreciation and depletion":31213,"Insurance":9157,"Travel entertainment public officials":0,"Travel entertainment payments":0,"Printing, publications, postage":0,"Itemized Expenses":{"value":71449,"START UP":44246,"STUDENT ACTIVITIES":27203},"All other expenses":0},"Functional Expenses":{"value":null,"Program Service Expenses":2304886,"Management And General Expenses":643684,"Fundraising Expenses":0}},"Assets":{"value":3278856,"Non-interest bearing cash":26038,"Savings and temp cash investments":2577382,"Pledges and grants receivable":61833,"Accounts receivable":65933,"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":43577,"Land, building, equipment":91297,"Investments publicly traded":0,"Investments other":0,"Investments program related":0,"Intangible assets":0,"Other assets":412796},"Liabilities":{"value":2157945,"Sum of Total Liabilities":0,"Accounts payable, accrued":306909,"Grants payable":0,"Deferred, revenue":481017,"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":1370019},"Fund balance":{"value":1120911,"Net assets without donor restriction":1120911,"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":0.7816962120621183,"percentile":0.6039665117253269},"Fundraising Efficiency":{"score":null,"percentile":null},"Operating Margin":{"score":0.16510531712078177,"percentile":0.7177243508287378},"Liabilities to Assets Ratio":{"score":0.6581396072288628,"percentile":0.10089383891071116},"Operating Reserve Ratio":{"score":1.1120156550463445,"percentile":0.4538135534134329},"Officer Compensation Ratio":{"score":null,"percentile":null},"Program Expense Growth":{"score":0.04282621647665348,"percentile":0.5033997400173608},"Revenue Growth":{"score":0.06056301493127961,"percentile":0.6482056502356901},"Asset Growth":{"score":0.17462323959586762,"percentile":0.8173020446464042},"Independent Voting Board Pct":{"score":1.0,"percentile":0.9933392423419786},"Governance Policy Score":{"score":6.0,"percentile":1.0},"Overall Score":{"score":0.6458599122219995,"percentile":0.7313343797865084}},"source_xml":"202531269349302273_public.xml"},"sector":"Education","donation_categories":[],"zakat_policy":null},"error":null}