Liabilities / Assets
99th percentile
Higher debt load relative to assets than 99% of similar nonprofits.
Constellation Schools Lorain Community Schools
990 • Fiscal year 2017 • EIN 41-2118105
Refreshing map…
Siviq Scores
Precomputed percentiles for this filing year versus similar nonprofits in the same peer cohort.
2.51x
Liabilities / Revenue
90th percentile
Higher debt load relative to revenue than 90% of similar nonprofits.
Net Margin
23rd percentile
Higher net margin than 23% of similar nonprofits.
Top Officer Pay
37th percentile
Higher top officer pay than 37% of similar nonprofits.
Top officer pay equals 0.7% of source-year revenue.
Asset Growth
87th percentile
Faster asset growth than 87% of similar nonprofits.
Revenue Growth
28th percentile
Faster revenue growth than 28% of similar nonprofits.
Balance Sheet
Assets
Up$858,267
Up $209,740 (+32%) from 2016
Net Assets
Down-$1,297,485
Down $601,091 (-86%) from 2016
Liabilities
Up$2,155,752
Up $810,831 (+60%) from 2016
Revenue And Expenses
Revenue
Down$1,229,934
Down $51,196 (-4.0%) from 2016
Expenses
Up$1,324,156
Up $177,192 (+15%) from 2016
Net Income
Down-$94,222
Down $228,388 (-170%) from 2016
Historical Trend
Jump To
Filing Snapshot
- Filing Period
- Jul 1, 2016 to Jun 30, 2017
- Signed
- Feb 11, 2018
- Return Version
- 2016v3.0
- Gross Receipts
- $1,229,934
Mission and Program Overview
Mission
Constellation schools: lorain community middle creates and provides diverse superior educational opportunities for a community of learners, built on a foundation of character education in a safe environment, ensuring the success of all children in our advancing ....technological society.
Constellation schools: lorain 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.
Balance Sheet Detail
| Line | Beginning | End | Change |
|---|---|---|---|
| Assets | |||
| Prepaid Expenses and Deferred Charges | $253,203 | $516,081 | ▲ $262,878 |
| Cash and Non-Interest-Bearing Accounts | $264,121 | $274,631 | ▲ $10,510 |
| Pledges and Grants Receivable | $63,348 | $20,815 | ▼ $42,533 |
| Land, Buildings, and Equipment, Net | $40,315 | $19,220 | ▼ $21,095 |
| Accounts Receivable | $20 | - | - |
| Total Assets | $648,527 | $858,267 | ▲ $209,740 |
| Other Assets Total | $27,520 | $27,520 | → $0 |
| Liabilities | |||
| Other Liabilities | $1,263,171 | $2,045,737 | ▲ $782,566 |
| Accounts Payable and Accrued Expenses | $8,667 | $65,238 | ▲ $56,571 |
| Deferred Revenue | $71,018 | $40,131 | ▼ $30,887 |
| Grants Payable | $184 | $3,470 | ▲ $3,286 |
| Unsecured Notes Loans Payable | $1,881 | $1,176 | ▼ $705 |
| Total Liabilities | $1,344,921 | $2,155,752 | ▲ $810,831 |
| Net Assets / Fund Balance | |||
| Unrestricted Net Assets | $-696,394 | $-1,297,485 | ▼ $601,091 |
| Total Net Assets Fund Balance | $-696,394 | $-1,297,485 | ▼ $601,091 |
| Total Liabilities and Net Assets / Fund Balance | $648,527 | $858,267 | ▲ $209,740 |
Asset Categories
| Asset | Book Value | Depreciation | Basis |
|---|---|---|---|
| Equipment | $19,220 | $239,298 | $258,518 |
Compensation and Service Providers
Employees
| Name | Title | Base | Other | Total |
|---|---|---|---|---|
| Thomas Babb | CFO | $7,550 | $1,006 | $8,556 |
| rebecca keeney | executive director | $7,550 | $707 | $8,257 |
| Donna Reindel | BOard MEMBER | $300 | - | $300 |
| james tortelli | Board President | $275 | - | $275 |
| Gregory Kozarik | Board Member | $250 | - | $250 |
| Lori Hoefs | Board Secretary | $225 | - | $225 |
| deborah callen | BOard MEMBER | $175 | - | $175 |
Highest Paid Contractors
| Contractor | Services | Location | Compensation |
|---|---|---|---|
| Constellation Schools Lorain Community | Facilities Rent And Staffing | 5730 BROADVIEW ROAD, Parma, OH 44134 | $177,463 |
Revenue and Support
Revenue Composition
- Contributions and Grants
- $1,206,790
- Program Service Revenue
- $7,405
- Investment Income
- $0
- Other Revenue
- $15,739
- Change in Net Assets
- $-94,222
Audited Revenue Reconciliation
- Revenue per Audited Statements
- $1,229,934
- Revenue Not Reported on Financial Statements
- $0
- Revenue Not Reported on Form 990
- $0
- Total Revenue per Audited Statements
- $1,229,934
- Total Revenue per Form 990
- $1,229,934
Expenses and Functional Allocation
Major Expense Lines
| Line Item | Amount |
|---|---|
| Salaries, Compensation, and Employee Benefits | $748,793 |
| Other Expenses | $575,363 |
| Total Fundraising Expense | $332 |
| Grants and Similar Amounts Paid | $0 |
| Professional Fundraising Fees | $0 |
Functional Expense Allocation
| Line Item | Program | Management | Fundraising | Total |
|---|---|---|---|---|
| Other Salaries and Wages | $533,006 | $26,424 | - | $559,430 |
| Fees for Services Other | $151,288 | $50,000 | - | $201,288 |
| Office Expenses | $103,627 | $10,863 | - | $114,490 |
| Other Employee Benefits | $72,260 | $5,427 | - | $77,687 |
| Pension Plan Contributions | $71,816 | $4,933 | - | $76,749 |
| Occupancy | $65,161 | $7,240 | - | $72,401 |
| Information Technology | $32,342 | $3,594 | - | $35,936 |
| Conferences and Meetings | $27,783 | $3,087 | - | $30,870 |
| Depreciation Depletion | $27,661 | $3,073 | - | $30,734 |
| Fees for Services Management | - | $28,083 | - | $28,083 |
| Current Officers, Directors, Trustees, and Key Employees | - | $18,038 | - | $18,038 |
| Payroll Taxes | $16,175 | $714 | - | $16,889 |
| Fees for Services Accounting | - | $11,555 | - | $11,555 |
| Insurance | $6,162 | $1,350 | - | $7,512 |
| Advertising | - | $5,384 | - | $5,384 |
| Fees for Services Legal | - | $1,333 | - | $1,333 |
| Other Expenses | $2,331 | $974 | - | $974 |
| Travel | $866 | $52 | - | $918 |
| All Other Expenses | - | - | $332 | $332 |
| Interest | $61 | $7 | - | $68 |
| Total Functional Expenses | $1,110,539 | $213,285 | $332 | $1,324,156 |
Audited Expense Reconciliation
| Line Item | Amount |
|---|---|
| Total Expenses per Audited Statements | $1,436,667 |
| Expenses per Audited Statements | $1,324,156 |
| Total Expenses per Form 990 | $1,324,156 |
| Expenses Not Reported on Form 990 | $112,511 |
| Expenses Not Reported on Financial Statements | $0 |
Fundraising, Events, and Gaming
- Fundraising activities
- No
- Gaming activities
- No
- Professional fundraiser used
- No
Fundraising and Gaming Totals
| Line Item | Amount |
|---|---|
| Professional Fundraising Fees | $0 |
Political and Lobbying Activity
- Political campaign activity
- No
- Lobbying activity
- No
- Subject to proxy tax
- No
Insider Transactions and Loans
Interested-Person Transactions
| Interested Party | Relationship | Description | Shared Revenue | Amount |
|---|---|---|---|---|
| - | ENTITY OWNED MORE THEN 35% BY EXECUTIVE DIRECTOR AND CFO OF FILING ORG | Management Services and Staffing of Primary Education. | No | $177,463 |
Debt and Bond Financing
Other Reported Liabilities
| Liability | Amount |
|---|---|
| Net Pension Liability | $2,045,737 |
Governance and Compliance
Governance Checklist
- Compiled or reviewed by an accountant
- No
- Annual disclosure for covered persons
- Yes
- Audit committee
- Yes
- Backup withholding compliance
- Yes
- Business relationship with family members
- No
- Business relationship with organization members
- No
- Material changes to governing documents
- No
- Compensation from other sources disclosed
- No
- CEO compensation reviewed
- Yes
- Other officer compensation reviewed
- Yes
- Conflict-of-interest policy
- Yes
- Audited financial statements prepared
- No
- Key decisions subject to board approval
- No
- Management duties delegated
- Yes
Governance Explanations
Form 990, Part VI, Section A, line 2
“BUSINESS RELATIONSHIP”
Form 990, Part VI, Section A, line 3
“Constellation schools: lorain community middle had a contract with constellation schools llc to provide legal, financial, and business management services for fiscal year 2017. The school's board members do retain the responsibilities regarding state mandated provisions of student population, curriculum, academic goals, performance standards, and qualification of the school's faculty and staff.”
Form 990, Part VI, Section B, line 11B
“The organization's information is submitted to an independent accountant for audit at the end of the fiscal year. Once the financial statements have been prepared and reviewed, the tax return is prepared by the accounting firm. Before submission to the tax authorities, it is presented to the treasurer for review and approval. It is submitted to the appropriate tax authorities once no corrections are needed.”
Form 990, Part VI, Section B, line 12C
“The organization has a written conflict of interest policy that must be signed each year. This is monitored by the board president, executive director, and hr director.”
Form 990, Part VI, Section B, line 15
“A committee within constellation schools management group is made up of board members from some of the schools and non-board members. This committee reviews compensation for the organization's top management and key employees. Salaries are established using comparable data from compensation paid for similar positions held in the public school districts and other charter schools in ohio.”
Form 990, Part VI, Section C, line 19
“THE ORGANIZATION SUMMARIZES ITS FINANCIAL INFORMATION AND MAKES THAT AVAILABLE THROUGH ITS WEB PAGE. THE WEB PAGE IS AVAILABLE THROUGH A LINK FROM THE FOLLOWING WEBSITE: <www.constellationschools.com>. CONSTELLATION SCHOOLS: LORAIN COMMUNITY MIDDLE ALSO GIVES INFORMATION ON ITS STAFF AND BOARD MEMBERS, AND ITS STUDENT ATTENDANCE, ENROLLMENT, PLANS/PROGRAMS, TESTING RESULTS, AND MUCH MORE AT THIS WEB PAGE. THE MOST RECENT FILED TAX-EXEMPT RETURNS ARE ALSO GENERALLY AVAILABLE TO THE PUBLIC THROUGH THE FOLLOWING WEBSITE: <www.guidestar.org>.”
FORM 990, PART VII, SECTION A, LINE 1B
“Compensation of board members and top management officers is provided by contract through a management agreement with constellation schools llc as a common pay master.”
Filing and Contact Details
Filer
- Filer Name
- Constellation Schools Lorain Community
- EIN
- 41-2118105
- Phone
- 2167127600
- Address
- 5730 BROADVIEW RD, PARMA, OH 44134
Signing Officer
- Name
- Thomas Babb
- Title
- CFO
- Phone
- 2167127600
- Signed
- 2018-02-11
- Discuss with paid preparer
- Yes
Organization Details
- Principal Officer
- Thomas Babb
- Formed
- 2003
- Legal Domicile
- Oh
- Voting Board Members
- 5
- Independent Board Members
- 5
- Employees
- 34
- Volunteers
- 28
Preparer
- Firm
- Rea & Associates Inc
- Address
- 941 Steubenville Ave PO Box 820, Cambridge, OH 43725-0820
- Preparer
- Mary Elizabeth Wright CPA
- Phone
- 7404325658
Supplemental Narrative
Additional Explanations
Form 990, Part IX, line 11G
“SPECIALIZED EDUCATIONAL SERVICES: Program service expenses 96,714. Management and general expenses 50,000. Fundraising expenses 0. Total expenses 146,714. HEALTH SERVICES: Program service expenses 18,000. Management and general expenses 0. Fundraising expenses 0. Total expenses 18,000. FOOD SERVICES: Program service expenses 36,574. Management and general expenses 0. Fundraising expenses 0. Total expenses 36,574.”
Form 990, Part XI, line 9:
“Current period adjustment due to adoption of gasb 68. -112,510. Prior period adjustment due to adoption of gasb 68 -394,358. Rounding -1.”
Form 990, Part XI, Line 2C
“The organization does have a committee that assumes oversight responsibility of audit, review of its financial statements, and selection of an independent accountant. This has not changed since the prior year.”
Financial Statement Notes
Part X, Line 2:
“"this is a governmental enterprise- fin 48 does not apply."”
Part XII, Line 2D - Other Adjustments:
“Current period adjustment due to adoption of gasb 68 112,510. Rounding 1.”
Raw XML AppendixShowing 400 of 508 raw XML fields
This appendix keeps the raw XML leaves available for debugging and edge-case review. The human report above is the primary experience.
| Path | # | Value |
|---|---|---|
| IRS990/AccountantCompileOrReviewInd | 0 | 0 |
| IRS990/AccountsPayableAccrExpnssGrp/BOYAmt | 0 | 8667 |
| IRS990/AccountsPayableAccrExpnssGrp/EOYAmt | 0 | 65238 |
| IRS990/AccountsReceivableGrp/BOYAmt | 0 | 20 |
| IRS990/ActivitiesConductedPrtshpInd | 0 | 0 |
| IRS990/ActivityOrMissionDesc | 0 | CONSTELLATION SCHOOLS: LORAIN 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. |
| IRS990/AdvertisingGrp/ManagementAndGeneralAmt | 0 | 5384 |
| IRS990/AdvertisingGrp/TotalAmt | 0 | 5384 |
| IRS990/AllOtherExpensesGrp/FundraisingAmt | 0 | 332 |
| IRS990/AllOtherExpensesGrp/TotalAmt | 0 | 332 |
| IRS990/AnnualDisclosureCoveredPrsnInd | 0 | 1 |
| IRS990/AuditCommitteeInd | 0 | 1 |
| IRS990/BackupWthldComplianceInd | 0 | 1 |
| IRS990/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt | 0 | CONSTELLATION SCHOOLS LLC |
| IRS990/BooksInCareOfDetail/PhoneNum | 0 | 2167127600 |
| IRS990/BooksInCareOfDetail/USAddress/AddressLine1Txt | 0 | 5730 BROADVIEW RD |
| IRS990/BooksInCareOfDetail/USAddress/CityNm | 0 | PARMA |
| IRS990/BooksInCareOfDetail/USAddress/StateAbbreviationCd | 0 | OH |
| IRS990/BooksInCareOfDetail/USAddress/ZIPCd | 0 | 44134 |
| IRS990/BusinessRlnWithFamMemInd | 0 | 0 |
| IRS990/BusinessRlnWithOfficerEntInd | 0 | 1 |
| IRS990/BusinessRlnWithOrgMemInd | 0 | 0 |
| IRS990/CashNonInterestBearingGrp/BOYAmt | 0 | 264121 |
| IRS990/CashNonInterestBearingGrp/EOYAmt | 0 | 274631 |
| IRS990/ChangeToOrgDocumentsInd | 0 | 0 |
| IRS990/CntrctRcvdGreaterThan100KCnt | 0 | 1 |
| IRS990/CollectionsOfArtInd | 0 | 0 |
| IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt | 0 | 18038 |
| IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt | 0 | 18038 |
| IRS990/CompensationFromOtherSrcsInd | 0 | 0 |
| IRS990/CompensationProcessCEOInd | 0 | 1 |
| IRS990/CompensationProcessOtherInd | 0 | 1 |
| IRS990/ConferencesMeetingsGrp/ManagementAndGeneralAmt | 0 | 3087 |
| IRS990/ConferencesMeetingsGrp/ProgramServicesAmt | 0 | 27783 |
| IRS990/ConferencesMeetingsGrp/TotalAmt | 0 | 30870 |
| IRS990/ConflictOfInterestPolicyInd | 0 | 1 |
| IRS990/ConservationEasementsInd | 0 | 0 |
| IRS990/ConsolidatedAuditFinclStmtInd | 0 | 0 |
| IRS990/ContractorCompensationGrp/CompensationAmt | 0 | 177463 |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt | 0 | 5730 BROADVIEW ROAD |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm | 0 | PARMA |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd | 0 | OH |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd | 0 | 44134 |
| IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt | 0 | CONSTELLATION SCHOOLS LORAIN COMMUNITY |
| IRS990/ContractorCompensationGrp/ServicesDesc | 0 | FACILITIES RENT AND STAFFING |
| IRS990/CreditCounselingInd | 0 | 0 |
| IRS990/CYBenefitsPaidToMembersAmt | 0 | 0 |
| IRS990/CYContributionsGrantsAmt | 0 | 1206790 |
| IRS990/CYGrantsAndSimilarPaidAmt | 0 | 0 |
| IRS990/CYInvestmentIncomeAmt | 0 | 0 |
| IRS990/CYOtherExpensesAmt | 0 | 575363 |
| IRS990/CYOtherRevenueAmt | 0 | 15739 |
| IRS990/CYProgramServiceRevenueAmt | 0 | 7405 |
| IRS990/CYRevenuesLessExpensesAmt | 0 | -94222 |
| IRS990/CYSalariesCompEmpBnftPaidAmt | 0 | 748793 |
| IRS990/CYTotalExpensesAmt | 0 | 1324156 |
| IRS990/CYTotalFundraisingExpenseAmt | 0 | 332 |
| IRS990/CYTotalProfFndrsngExpnsAmt | 0 | 0 |
| IRS990/CYTotalRevenueAmt | 0 | 1229934 |
| IRS990/DecisionsSubjectToApprovaInd | 0 | 0 |
| IRS990/DeductibleArtContributionInd | 0 | 0 |
| IRS990/DeductibleNonCashContriInd | 0 | 0 |
| IRS990/DeferredRevenueGrp/BOYAmt | 0 | 71018 |
| IRS990/DeferredRevenueGrp/EOYAmt | 0 | 40131 |
| IRS990/DelegationOfMgmtDutiesInd | 0 | 1 |
| IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt | 0 | 3073 |
| IRS990/DepreciationDepletionGrp/ProgramServicesAmt | 0 | 27661 |
| IRS990/DepreciationDepletionGrp/TotalAmt | 0 | 30734 |
| IRS990/Desc | 0 | PRIMARY EDUCATION- SERVED 118 STUDENTS IN FIFTH THROUGH EIGHTH GRADE. |
| IRS990/DescribedInSection501c3Ind | 0 | 1 |
| IRS990/DisregardedEntityInd | 0 | 0 |
| IRS990/DocumentRetentionPolicyInd | 0 | 1 |
| IRS990/DonorAdvisedFundInd | 0 | 0 |
| IRS990/ElectionOfBoardMembersInd | 0 | 0 |
| IRS990/EmployeeCnt | 0 | 34 |
| IRS990/EmploymentTaxReturnsFiledInd | 0 | 1 |
| IRS990/EngagedInExcessBenefitTransInd | 0 | 0 |
| IRS990/ExpenseAmt | 0 | 1110539 |
| IRS990/FamilyOrBusinessRlnInd | 0 | 1 |
| IRS990/FederalGrantAuditRequiredInd | 0 | 0 |
| IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt | 0 | 11555 |
| IRS990/FeesForServicesAccountingGrp/TotalAmt | 0 | 11555 |
| IRS990/FeesForServicesLegalGrp/ManagementAndGeneralAmt | 0 | 1333 |
| IRS990/FeesForServicesLegalGrp/TotalAmt | 0 | 1333 |
| IRS990/FeesForServicesManagementGrp/ManagementAndGeneralAmt | 0 | 28083 |
| IRS990/FeesForServicesManagementGrp/TotalAmt | 0 | 28083 |
| IRS990/FeesForServicesOtherGrp/ManagementAndGeneralAmt | 0 | 50000 |
| IRS990/FeesForServicesOtherGrp/ProgramServicesAmt | 0 | 151288 |
| IRS990/FeesForServicesOtherGrp/TotalAmt | 0 | 201288 |
| IRS990/ForeignActivitiesInd | 0 | 0 |
| IRS990/ForeignFinancialAccountInd | 0 | 0 |
| IRS990/ForeignOfficeInd | 0 | 0 |
| IRS990/Form8282PropertyDisposedOfInd | 0 | 0 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 0 | 1.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 1 | 1.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 2 | 1.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 3 | 1.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 4 | 1.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 5 | 2.50 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt | 6 | 2.50 |
| IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd | 0 | X |
| IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd | 1 | X |
| IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd | 2 | X |
| IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd | 3 | X |
| IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd | 4 | X |
| IRS990/Form990PartVIISectionAGrp/OfficerInd | 0 | X |
| IRS990/Form990PartVIISectionAGrp/OfficerInd | 1 | X |
| IRS990/Form990PartVIISectionAGrp/OfficerInd | 2 | X |
| IRS990/Form990PartVIISectionAGrp/OfficerInd | 3 | X |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 0 | 0 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 1 | 0 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 2 | 0 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 3 | 0 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 4 | 0 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 5 | 1006 |
| IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt | 6 | 707 |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 0 | deborah callen |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 1 | james tortelli |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 2 | DONNA REINDEL |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 3 | GREGORY KOZARIK |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 4 | LORI HOEFS |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 5 | THOMAS BABB |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 6 | rebecca keeney |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 0 | 175 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 1 | 275 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 2 | 300 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 3 | 250 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 4 | 225 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 5 | 7550 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 6 | 7550 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 0 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 1 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 2 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 3 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 4 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 5 | 0 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt | 6 | 0 |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 0 | BOard MEMBER |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 1 | BOARD PRESIDENT |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 2 | BOard MEMBER |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 3 | BOARD MEMBER |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 4 | BOARD SECRETARY |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 5 | CFO |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 6 | executive director |
| IRS990/Form990ProvidedToGvrnBodyInd | 0 | 1 |
| IRS990/FormationYr | 0 | 2003 |
| IRS990/FormerOfcrEmployeesListedInd | 0 | 0 |
| IRS990/FSAuditedBasisGrp/SeparateBasisFinclStmtInd | 0 | X |
| IRS990/FSAuditedInd | 0 | 1 |
| IRS990/FundraisingActivitiesInd | 0 | 0 |
| IRS990/GamingActivitiesInd | 0 | 0 |
| IRS990/GoverningBodyVotingMembersCnt | 0 | 5 |
| IRS990/GovernmentGrantsAmt | 0 | 1206790 |
| IRS990/GrantsPayableGrp/BOYAmt | 0 | 184 |
| IRS990/GrantsPayableGrp/EOYAmt | 0 | 3470 |
| IRS990/GrantsToIndividualsInd | 0 | 0 |
| IRS990/GrantsToOrganizationsInd | 0 | 0 |
| IRS990/GrantToRelatedPersonInd | 0 | 0 |
| IRS990/GrossReceiptsAmt | 0 | 1229934 |
| IRS990/GroupReturnForAffiliatesInd | 0 | 0 |
| IRS990/IncludeFIN48FootnoteInd | 0 | 0 |
| IRS990/IndependentAuditFinclStmtInd | 0 | 1 |
| IRS990/IndependentVotingMemberCnt | 0 | 5 |
| IRS990/IndivRcvdGreaterThan100KCnt | 0 | 0 |
| IRS990/IndoorTanningServicesInd | 0 | 0 |
| IRS990/InfoInScheduleOPartIIIInd | 0 | X |
| IRS990/InfoInScheduleOPartIXInd | 0 | X |
| IRS990/InfoInScheduleOPartVIIInd | 0 | X |
| IRS990/InfoInScheduleOPartVIInd | 0 | X |
| IRS990/InfoInScheduleOPartXIIInd | 0 | X |
| IRS990/InfoInScheduleOPartXIInd | 0 | X |
| IRS990/InformationTechnologyGrp/ManagementAndGeneralAmt | 0 | 3594 |
| IRS990/InformationTechnologyGrp/ProgramServicesAmt | 0 | 32342 |
| IRS990/InformationTechnologyGrp/TotalAmt | 0 | 35936 |
| IRS990/InsuranceGrp/ManagementAndGeneralAmt | 0 | 1350 |
| IRS990/InsuranceGrp/ProgramServicesAmt | 0 | 6162 |
| IRS990/InsuranceGrp/TotalAmt | 0 | 7512 |
| IRS990/InterestGrp/ManagementAndGeneralAmt | 0 | 7 |
| IRS990/InterestGrp/ProgramServicesAmt | 0 | 61 |
| IRS990/InterestGrp/TotalAmt | 0 | 68 |
| IRS990/InvestmentInJointVentureInd | 0 | 0 |
| IRS990/IRPDocumentCnt | 0 | 0 |
| IRS990/IRPDocumentW2GCnt | 0 | 0 |
| IRS990/LandBldgEquipAccumDeprecAmt | 0 | 239298 |
| IRS990/LandBldgEquipBasisNetGrp/BOYAmt | 0 | 40315 |
| IRS990/LandBldgEquipBasisNetGrp/EOYAmt | 0 | 19220 |
| IRS990/LandBldgEquipCostOrOtherBssAmt | 0 | 258518 |
| IRS990/LegalDomicileStateCd | 0 | OH |
| IRS990/LoanOutstandingInd | 0 | 0 |
| IRS990/LobbyingActivitiesInd | 0 | 0 |
| IRS990/LocalChaptersInd | 0 | 0 |
| IRS990/MaterialDiversionOrMisuseInd | 0 | 0 |
| IRS990/MembersOrStockholdersInd | 0 | 0 |
| IRS990/MethodOfAccountingAccrualInd | 0 | X |
| IRS990/MinutesOfCommitteesInd | 0 | 1 |
| IRS990/MinutesOfGoverningBodyInd | 0 | 1 |
| IRS990/MissionDesc | 0 | CONSTELLATION SCHOOLS: LORAIN COMMUNITY MIDDLE CREATES AND PROVIDES DIVERSE SUPERIOR EDUCATIONAL OPPORTUNITIES FOR A COMMUNITY OF LEARNERS, BUILT ON A FOUNDATION OF CHARACTER EDUCATION IN A SAFE ENVIRONMENT, ENSURING THE SUCCESS OF ALL CHILDREN IN OUR ADVANCING ....TECHNOLOGICAL SOCIETY. |
| IRS990/MoreThan5000KToIndividualsInd | 0 | 0 |
| IRS990/MoreThan5000KToOrgInd | 0 | 0 |
| IRS990/NetAssetsOrFundBalancesBOYAmt | 0 | -696394 |
| IRS990/NetAssetsOrFundBalancesEOYAmt | 0 | -1297485 |
| IRS990/NetUnrelatedBusTxblIncmAmt | 0 | 0 |
| IRS990/NondeductibleContributionsInd | 0 | 0 |
| IRS990/OccupancyGrp/ManagementAndGeneralAmt | 0 | 7240 |
| IRS990/OccupancyGrp/ProgramServicesAmt | 0 | 65161 |
| IRS990/OccupancyGrp/TotalAmt | 0 | 72401 |
| IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt | 0 | 10863 |
| IRS990/OfficeExpensesGrp/ProgramServicesAmt | 0 | 103627 |
| IRS990/OfficeExpensesGrp/TotalAmt | 0 | 114490 |
| IRS990/OfficerMailingAddressInd | 0 | 0 |
| IRS990/OperateHospitalInd | 0 | 0 |
| IRS990/Organization501c3Ind | 0 | X |
| IRS990/OrganizationFollowsSFAS117Ind | 0 | X |
| IRS990/OtherAssetsTotalGrp/BOYAmt | 0 | 27520 |
| IRS990/OtherAssetsTotalGrp/EOYAmt | 0 | 27520 |
| IRS990/OtherChangesInNetAssetsAmt | 0 | -506869 |
| IRS990/OtherEmployeeBenefitsGrp/ManagementAndGeneralAmt | 0 | 5427 |
| IRS990/OtherEmployeeBenefitsGrp/ProgramServicesAmt | 0 | 72260 |
| IRS990/OtherEmployeeBenefitsGrp/TotalAmt | 0 | 77687 |
| IRS990/OtherExpensesGrp/Desc | 0 | SPONSOR FEE |
| IRS990/OtherExpensesGrp/Desc | 1 | student activities |
| IRS990/OtherExpensesGrp/Desc | 2 | DUES & SUBSCRIPTIONS |
| IRS990/OtherExpensesGrp/Desc | 3 | all other expenses |
| IRS990/OtherExpensesGrp/ManagementAndGeneralAmt | 0 | 29927 |
| IRS990/OtherExpensesGrp/ManagementAndGeneralAmt | 1 | 1227 |
| IRS990/OtherExpensesGrp/ManagementAndGeneralAmt | 2 | 974 |
| IRS990/OtherExpensesGrp/ProgramServicesAmt | 0 | 2331 |
| IRS990/OtherExpensesGrp/TotalAmt | 0 | 29927 |
| IRS990/OtherExpensesGrp/TotalAmt | 1 | 2331 |
| IRS990/OtherExpensesGrp/TotalAmt | 2 | 1227 |
| IRS990/OtherExpensesGrp/TotalAmt | 3 | 974 |
| IRS990/OtherLiabilitiesGrp/BOYAmt | 0 | 1263171 |
| IRS990/OtherLiabilitiesGrp/EOYAmt | 0 | 2045737 |
| IRS990/OtherRevenueMiscGrp/BusinessCd | 0 | 611110 |
| IRS990/OtherRevenueMiscGrp/Desc | 0 | miscellaneous |
| IRS990/OtherRevenueMiscGrp/RelatedOrExemptFuncIncomeAmt | 0 | 15739 |
| IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt | 0 | 15739 |
| IRS990/OtherRevenueTotalAmt | 0 | 15739 |
| IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt | 0 | 26424 |
| IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt | 0 | 533006 |
| IRS990/OtherSalariesAndWagesGrp/TotalAmt | 0 | 559430 |
| IRS990/OtherWebsiteInd | 0 | X |
| IRS990/PartialLiquidationInd | 0 | 0 |
| IRS990/PayPremiumsPrsnlBnftCntrctInd | 0 | 0 |
| IRS990/PayrollTaxesGrp/ManagementAndGeneralAmt | 0 | 714 |
| IRS990/PayrollTaxesGrp/ProgramServicesAmt | 0 | 16175 |
| IRS990/PayrollTaxesGrp/TotalAmt | 0 | 16889 |
| IRS990/PensionPlanContributionsGrp/ManagementAndGeneralAmt | 0 | 4933 |
| IRS990/PensionPlanContributionsGrp/ProgramServicesAmt | 0 | 71816 |
| IRS990/PensionPlanContributionsGrp/TotalAmt | 0 | 76749 |
| IRS990/PledgesAndGrantsReceivableGrp/BOYAmt | 0 | 63348 |
| IRS990/PledgesAndGrantsReceivableGrp/EOYAmt | 0 | 20815 |
| IRS990/PoliticalCampaignActyInd | 0 | 0 |
| IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt | 0 | 253203 |
| IRS990/PrepaidExpensesDefrdChargesGrp/EOYAmt | 0 | 516081 |
| IRS990/PrincipalOfficerNm | 0 | THOMAS BABB |
| IRS990/ProfessionalFundraisingInd | 0 | 0 |
| IRS990/ProgramServiceRevenueGrp/BusinessCd | 0 | 611110 |
| IRS990/ProgramServiceRevenueGrp/Desc | 0 | MATERIAL FEES |
| IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt | 0 | 7405 |
| IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt | 0 | 7405 |
| IRS990/ProhibitedTaxShelterTransInd | 0 | 0 |
| IRS990/PYBenefitsPaidToMembersAmt | 0 | 0 |
| IRS990/PYContributionsGrantsAmt | 0 | 1234174 |
| IRS990/PYExcessBenefitTransInd | 0 | 0 |
| IRS990/PYGrantsAndSimilarPaidAmt | 0 | 0 |
| IRS990/PYInvestmentIncomeAmt | 0 | 0 |
| IRS990/PYOtherExpensesAmt | 0 | 519254 |
| IRS990/PYOtherRevenueAmt | 0 | 23941 |
| IRS990/PYProgramServiceRevenueAmt | 0 | 23015 |
| IRS990/PYRevenuesLessExpensesAmt | 0 | 134166 |
| IRS990/PYSalariesCompEmpBnftPaidAmt | 0 | 627710 |
| IRS990/PYTotalExpensesAmt | 0 | 1146964 |
| IRS990/PYTotalProfFndrsngExpnsAmt | 0 | 0 |
| IRS990/PYTotalRevenueAmt | 0 | 1281130 |
| IRS990/QuidProQuoContributionsInd | 0 | 0 |
| IRS990/RcvFndsToPayPrsnlBnftCntrctInd | 0 | 0 |
| IRS990/ReconcilationRevenueExpnssAmt | 0 | -94222 |
| IRS990/RegularMonitoringEnfrcInd | 0 | 1 |
| IRS990/RelatedEntityInd | 0 | 1 |
| IRS990/RelatedOrganizationCtrlEntInd | 0 | 0 |
| IRS990/ReportInvestmentsOtherSecInd | 0 | 0 |
| IRS990/ReportLandBuildingEquipmentInd | 0 | 1 |
| IRS990/ReportOtherAssetsInd | 0 | 0 |
| IRS990/ReportOtherLiabilitiesInd | 0 | 1 |
| IRS990/ReportProgramRelatedInvstInd | 0 | 0 |
| IRS990/RevenueAmt | 0 | 23144 |
| IRS990ScheduleA/SchoolInd | 0 | X |
| IRS990/ScheduleBRequiredInd | 0 | 0 |
| IRS990ScheduleD/EquipmentGrp/BookValueAmt | 0 | 19220 |
| IRS990ScheduleD/EquipmentGrp/DepreciationAmt | 0 | 239298 |
| IRS990ScheduleD/EquipmentGrp/OtherCostOrOtherBasisAmt | 0 | 258518 |
| IRS990ScheduleD/ExpensesNotReportedAmt | 0 | 112511 |
| IRS990ScheduleD/ExpensesNotRptFinclStmtAmt | 0 | 0 |
| IRS990ScheduleD/ExpensesSubtotalAmt | 0 | 1324156 |
| IRS990ScheduleD/FootnoteTextInd | 0 | X |
| IRS990ScheduleD/OtherExpensesIncludedAmt | 0 | 112511 |
| IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt | 0 | 2045737 |
| IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc | 0 | NET PENSION LIABILITY |
| IRS990ScheduleD/RevenueNotReportedAmt | 0 | 0 |
| IRS990ScheduleD/RevenueNotReportedFinclStmtAmt | 0 | 0 |
| IRS990ScheduleD/RevenueSubtotalAmt | 0 | 1229934 |
| IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt | 0 | "THIS IS A GOVERNMENTAL ENTERPRISE- FIN 48 DOES NOT APPLY." |
| IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt | 1 | CURRENT PERIOD ADJUSTMENT DUE TO ADOPTION OF GASB 68 112,510. ROUNDING 1. |
| IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc | 0 | Part X, Line 2: |
| IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc | 1 | Part XII, Line 2d - Other Adjustments: |
| IRS990ScheduleD/TotalBookValueLandBuildingsAmt | 0 | 19220 |
| IRS990ScheduleD/TotalExpensesPerForm990Amt | 0 | 1324156 |
| IRS990ScheduleD/TotalLiabilityAmt | 0 | 2045737 |
| IRS990ScheduleD/TotalRevenuePerForm990Amt | 0 | 1229934 |
| IRS990ScheduleD/TotalRevEtcAuditedFinclStmtAmt | 0 | 1229934 |
| IRS990ScheduleD/TotExpnsEtcAuditedFinclStmtAmt | 0 | 1436667 |
| IRS990ScheduleE/ComplianceWithRevProc7550Ind | 0 | 1 |
| IRS990ScheduleE/DiscriminateRaceAdmissPlcyInd | 0 | 0 |
| IRS990ScheduleE/DiscriminateRaceAthltProgInd | 0 | 0 |
| IRS990ScheduleE/DiscriminateRaceEducPlcyInd | 0 | 0 |
| IRS990ScheduleE/DiscriminateRaceEmplmFcultyInd | 0 | 0 |
| IRS990ScheduleE/DiscriminateRaceOtherActyInd | 0 | 0 |
| IRS990ScheduleE/DiscriminateRaceSchsInd | 0 | 0 |
| IRS990ScheduleE/DiscriminateRaceStdntsRghtsInd | 0 | 0 |
| IRS990ScheduleE/DiscriminateRaceUseOfFcltsInd | 0 | 0 |
| IRS990ScheduleE/GovernmentFinancialAidRcvdInd | 0 | 1 |
| IRS990ScheduleE/GovernmentFinancialAidRvkdInd | 0 | 0 |
| IRS990ScheduleE/MaintainCpyOfAllSolInd | 0 | 1 |
| IRS990ScheduleE/MaintainCpyOfBrochuresEtcInd | 0 | 1 |
| IRS990ScheduleE/MaintainRacialCompRecsInd | 0 | 1 |
| IRS990ScheduleE/MaintainScholarshipsRecsInd | 0 | 0 |
| IRS990ScheduleE/NondiscriminatoryPolicyStmtInd | 0 | 1 |
| IRS990ScheduleE/PlcyPblczdViaBroadcastMediaInd | 0 | 1 |
| IRS990ScheduleE/PolicyStmtInBrochuresEtcInd | 0 | 1 |
| IRS990ScheduleE/SupplementalInformationDetail/ExplanationTxt | 0 | OUR NONDISCRIMINATTION POLICY IS STATED ON OFFICIAL FORMS AND COMMUNICATIONS. |
| IRS990ScheduleE/SupplementalInformationDetail/ExplanationTxt | 1 | THE SCHOOL IS A CHARTER SCHOOL SUPPORTED BY OHIO TAXES AND BY LAW, CANNOT CHARGE ANY TUITION, THEREFORE THERE IS NO NEED TO OFFER SCHOLARSHIPS OR FINANCIAL ASSISTANCE. |
| IRS990ScheduleE/SupplementalInformationDetail/ExplanationTxt | 2 | THE SCHOOL RECEIVES U.S. DEPARTMENT OF EDUCATION TITLE FUNDING THROUGH THE OHIO DEPARTMENT OF EDUCATION TO SUPPLEMENT EDUCATIONAL PROGRAMS, PROVIDE ASSISTANCE TO STUDENTS IN NEED AND TO PROVIDE A SCHOOL LUNCH PROGRAM. THE STATE OF OHIO ALSO PROVIDES FUNDING FOR PROFESSIONAL DEVELOPMENT, DATA REPORTING AND COMMUNICATIONS. ALL SUCH FUNDS RECEIVED HAVE BEEN REPORTED AS GOVERNMENT CONTRIBUTIONS ON FORM 990 PART VIII, LINE 1e. |
| IRS990ScheduleE/SupplementalInformationDetail/FormAndLineReferenceDesc | 0 | Schedule E, Part I, Line 3 |
| IRS990ScheduleE/SupplementalInformationDetail/FormAndLineReferenceDesc | 1 | Schedule E, Part I, Line 4 |
| IRS990ScheduleE/SupplementalInformationDetail/FormAndLineReferenceDesc | 2 | Schedule E, Part I, Line 6 |
| IRS990/ScheduleJRequiredInd | 0 | 0 |
| IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/NameOfInterested/BusinessName/BusinessNameLine1Txt | 0 | CONSTELLATION SCHOOLS LLC |
| IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/RelationshipDescriptionTxt | 0 | ENTITY OWNED MORE THEN 35% BY EXECUTIVE DIRECTOR AND CFO OF FILING ORG |
| IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/SharingOfRevenuesInd | 0 | 0 |
| IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/TransactionAmt | 0 | 177463 |
| IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/TransactionDesc | 0 | MANAGEMENT SERVICES AND STAFFING OF PRIMARY EDUCATION. |
| IRS990/ScheduleORequiredInd | 0 | 1 |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 0 | BUSINESS RELATIONSHIP |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 1 | CONSTELLATION SCHOOLS: LORAIN COMMUNITY MIDDLE HAD A CONTRACT WITH CONSTELLATION SCHOOLS LLC TO PROVIDE LEGAL, FINANCIAL, AND BUSINESS MANAGEMENT SERVICES FOR FISCAL YEAR 2017. THE SCHOOL'S BOARD MEMBERS DO RETAIN THE RESPONSIBILITIES REGARDING STATE MANDATED PROVISIONS OF STUDENT POPULATION, CURRICULUM, ACADEMIC GOALS, PERFORMANCE STANDARDS, AND QUALIFICATION OF THE SCHOOL'S FACULTY AND STAFF. |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 2 | THE ORGANIZATION'S INFORMATION IS SUBMITTED TO AN INDEPENDENT ACCOUNTANT FOR AUDIT AT THE END OF THE FISCAL YEAR. ONCE THE FINANCIAL STATEMENTS HAVE BEEN PREPARED AND REVIEWED, THE TAX RETURN IS PREPARED BY THE ACCOUNTING FIRM. BEFORE SUBMISSION TO THE TAX AUTHORITIES, IT IS PRESENTED TO THE TREASURER FOR REVIEW AND APPROVAL. IT IS SUBMITTED TO THE APPROPRIATE TAX AUTHORITIES ONCE NO CORRECTIONS ARE NEEDED. |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 3 | THE ORGANIZATION HAS A WRITTEN CONFLICT OF INTEREST POLICY THAT MUST BE SIGNED EACH YEAR. THIS IS MONITORED BY THE BOARD PRESIDENT, EXECUTIVE DIRECTOR, AND HR DIRECTOR. |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 4 | A COMMITTEE WITHIN CONSTELLATION SCHOOLS MANAGEMENT GROUP IS MADE UP OF BOARD MEMBERS FROM SOME OF THE SCHOOLS AND NON-BOARD MEMBERS. THIS COMMITTEE REVIEWS COMPENSATION FOR THE ORGANIZATION'S TOP MANAGEMENT AND KEY EMPLOYEES. SALARIES ARE ESTABLISHED USING COMPARABLE DATA FROM COMPENSATION PAID FOR SIMILAR POSITIONS HELD IN THE PUBLIC SCHOOL DISTRICTS AND OTHER CHARTER SCHOOLS IN OHIO. |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 5 | THE ORGANIZATION SUMMARIZES ITS FINANCIAL INFORMATION AND MAKES THAT AVAILABLE THROUGH ITS WEB PAGE. THE WEB PAGE IS AVAILABLE THROUGH A LINK FROM THE FOLLOWING WEBSITE: <www.constellationschools.com>. CONSTELLATION SCHOOLS: LORAIN COMMUNITY MIDDLE ALSO GIVES INFORMATION ON ITS STAFF AND BOARD MEMBERS, AND ITS STUDENT ATTENDANCE, ENROLLMENT, PLANS/PROGRAMS, TESTING RESULTS, AND MUCH MORE AT THIS WEB PAGE. THE MOST RECENT FILED TAX-EXEMPT RETURNS ARE ALSO GENERALLY AVAILABLE TO THE PUBLIC THROUGH THE FOLLOWING WEBSITE: <www.guidestar.org>. |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 6 | COMPENSATION OF BOARD MEMBERS AND TOP MANAGEMENT OFFICERS IS PROVIDED BY CONTRACT THROUGH A MANAGEMENT AGREEMENT WITH CONSTELLATION SCHOOLS LLC AS A COMMON PAY MASTER. |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 7 | SPECIALIZED EDUCATIONAL SERVICES: Program service expenses 96,714. Management and general expenses 50,000. Fundraising expenses 0. Total expenses 146,714. HEALTH SERVICES: Program service expenses 18,000. Management and general expenses 0. Fundraising expenses 0. Total expenses 18,000. FOOD SERVICES: Program service expenses 36,574. Management and general expenses 0. Fundraising expenses 0. Total expenses 36,574. |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 8 | CURRENT PERIOD ADJUSTMENT DUE TO ADOPTION OF GASB 68. -112,510. PRIOR PERIOD ADJUSTMENT DUE TO ADOPTION OF GASB 68 -394,358. ROUNDING -1. |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 9 | THE ORGANIZATION DOES HAVE A COMMITTEE THAT ASSUMES OVERSIGHT RESPONSIBILITY OF AUDIT, REVIEW OF ITS FINANCIAL STATEMENTS, AND SELECTION OF AN INDEPENDENT ACCOUNTANT. THIS HAS NOT CHANGED SINCE THE PRIOR YEAR. |
| IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc | 0 | Form 990, Part VI, Section A, line 2 |
| IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc | 1 | Form 990, Part VI, Section A, line 3 |
| IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc | 2 | Form 990, Part VI, Section B, line 11b |
| IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc | 3 | Form 990, Part VI, Section B, line 12c |
| IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc | 4 | Form 990, Part VI, Section B, line 15 |
| IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc | 5 | Form 990, Part VI, Section C, line 19 |
| IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc | 6 | FORM 990, PART VII, SECTION A, LINE 1b |
| IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc | 7 | Form 990, Part IX, line 11g |
| IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc | 8 | Form 990, Part XI, line 9: |
| IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc | 9 | FORM 990, PART XI, LINE 2C |
| IRS990ScheduleR/AssetExchangeInd | 0 | 0 |
| IRS990ScheduleR/AssetPurchaseFromOtherOrgInd | 0 | 0 |
| IRS990ScheduleR/AssetSaleToOtherOrgInd | 0 | 0 |
| IRS990ScheduleR/DivRelatedOrganizationInd | 0 | 0 |
| IRS990ScheduleR/GiftGrntCapContriFromOthOrgInd | 0 | 0 |
| IRS990ScheduleR/GiftGrntOrCapContriToOthOrgInd | 0 | 0 |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ControlledOrganizationInd | 0 | 0 |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ControlledOrganizationInd | 1 | 0 |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ControlledOrganizationInd | 2 | 0 |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/DisregardedEntityName/BusinessNameLine1Txt | 0 | CONSTELLATION SCHOOLS OLD BROOKLYN COMMUNITY MIDDLE |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/DisregardedEntityName/BusinessNameLine1Txt | 1 | CONSTELLATION SCHOOLS WESTPARK |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/DisregardedEntityName/BusinessNameLine1Txt | 2 | CONSTELLATION SCHOOLS OUTREACH ACADEMY |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/EIN | 0 | 200453321 |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/EIN | 1 | 341932957 |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/EIN | 2 | 341996940 |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ExemptCodeSectionTxt | 0 | 501(C)(3) |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ExemptCodeSectionTxt | 1 | 501(C)(3) |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ExemptCodeSectionTxt | 2 | 501(C)(3) |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/LegalDomicileStateCd | 0 | OH |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/LegalDomicileStateCd | 1 | OH |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/LegalDomicileStateCd | 2 | OH |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/PrimaryActivitiesTxt | 0 | TO OPERATE AS AN EDUCATIONAL INSTITUTION |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/PrimaryActivitiesTxt | 1 | TO OPERATE AS AN EDUCATIONAL INSTITUTION |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/PrimaryActivitiesTxt | 2 | TO OPERATE AS AN EDUCATIONAL INSTITUTION |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/PublicCharityStatusTxt | 0 | 170(b)(1)(A)(ii) |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/PublicCharityStatusTxt | 1 | 170(b)(1)(A)(ii) |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/PublicCharityStatusTxt | 2 | 170(b)(1)(A)(ii) |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/AddressLine1Txt | 0 | 5730 BROADVIEW RD |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/AddressLine1Txt | 1 | 5730 BROADVIEW RD |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/AddressLine1Txt | 2 | 5730 BROADVIEW RD |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/CityNm | 0 | PARMA |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/CityNm | 1 | PARMA |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/CityNm | 2 | PARMA |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/StateAbbreviationCd | 0 | OH |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/StateAbbreviationCd | 1 | OH |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/StateAbbreviationCd | 2 | OH |
| IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/ZIPCd | 0 | 44134 |
Document Assets
No mirrored PDF or thumbnail assets are attached yet.
Filings
Displayed year
2017 • Form 990Detailed filing. Detailed filing data is available for this year.
- Assets
- $858,267
- Liabilities
- $2,155,752
- Net assets
- -$1,297,485
- Revenue
- $1,229,934
- Expenses
- $1,324,156
- Net income
- -$94,222