Liabilities / Assets
97th percentile
Higher debt load relative to assets than 97% of similar nonprofits.
Constellation Schools Elyria Community Elementary
990 • Fiscal year 2017 • EIN 34-1932960
Siviq Scores
Precomputed percentiles for this filing year versus similar nonprofits in the same peer cohort.
1.47x
Liabilities / Revenue
87th percentile
Higher debt load relative to revenue than 87% of similar nonprofits.
Net Margin
32nd percentile
Higher net margin than 32% of similar nonprofits.
Top Officer Pay
Score unavailable
This filing does not contain officer compensation rows.
Asset Growth
83rd percentile
Faster asset growth than 83% of similar nonprofits.
Revenue Growth
44th percentile
Faster revenue growth than 44% of similar nonprofits.
Balance Sheet
Assets
Up$5,711,414
Up $1,008,015 (+21%) from 2016
Net Assets
Down-$2,671,175
Down $881,613 (-49%) from 2016
Liabilities
Up$8,382,589
Up $1,889,628 (+29%) from 2016
Revenue And Expenses
Revenue
Up$4,495,007
Up $112,864 (+2.6%) from 2016
Expenses
Up$4,556,374
Up $303,477 (+7.1%) from 2016
Net Income
Down-$61,367
Down $190,613 (-147%) 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
- $4,495,007
Mission and Program Overview
Mission
Constellation schools: elyria community elementary 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: elyria community elementary 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 | |||
| Land, Buildings, and Equipment, Net | $2,796,955 | $2,895,659 | ▲ $98,704 |
| Prepaid Expenses and Deferred Charges | $759,494 | $1,914,821 | ▲ $1,155,327 |
| Cash and Non-Interest-Bearing Accounts | $961,823 | $756,818 | ▼ $205,005 |
| Pledges and Grants Receivable | $143,792 | $114,389 | ▼ $29,403 |
| Accounts Receivable | $390 | $50 | ▼ $340 |
| Total Assets | $4,703,399 | $5,711,414 | ▲ $1,008,015 |
| Other Assets Total | $40,945 | $29,677 | ▼ $11,268 |
| Liabilities | |||
| Other Liabilities | $4,564,201 | $6,758,057 | ▲ $2,193,856 |
| Mortgage Notes Payable Secured by Investment Property | $1,545,524 | $1,398,171 | ▼ $147,353 |
| Accounts Payable and Accrued Expenses | $94,515 | $154,309 | ▲ $59,794 |
| Grants Payable | $0 | $53,348 | ▲ $53,348 |
| Deferred Revenue | $288,721 | $18,704 | ▼ $270,017 |
| Total Liabilities | $6,492,961 | $8,382,589 | ▲ $1,889,628 |
| Net Assets / Fund Balance | |||
| Unrestricted Net Assets | $-1,789,562 | $-2,671,175 | ▼ $881,613 |
| Total Net Assets Fund Balance | $-1,789,562 | $-2,671,175 | ▼ $881,613 |
| Total Liabilities and Net Assets / Fund Balance | $4,703,399 | $5,711,414 | ▲ $1,008,015 |
Asset Categories
| Asset | Book Value | Depreciation | Basis |
|---|---|---|---|
| Buildings | $2,330,286 | $556,154 | $2,886,440 |
| Land | $422,900 | - | $422,900 |
| Equipment | $142,473 | $165,101 | $307,574 |
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 |
| Jerome Bednar | Board Member | $375 | - | $375 |
| John Noga | Board President | $375 | - | $375 |
| Mark Stypczynski | Board Secretary | $375 | - | $375 |
| Leo Tischer | Board Member | $344 | - | $344 |
| Bert Butts | Board Member June 2017 | $31 | - | $31 |
Highest Paid Contractors
| Contractor | Services | Location | Compensation |
|---|---|---|---|
| Constellation Schools LLC | Management Services & Staffing | 5730 BROADVIEW ROAD, Parma, OH 44134 | $579,000 |
| Jl Reichert INC | Garage Construction & Parking Lot Paving | PO BOX 1266, Elyria, OH 44036 | $160,400 |
Revenue and Support
Revenue Composition
- Contributions and Grants
- $4,286,159
- Program Service Revenue
- $207,137
- Investment Income
- $0
- Other Revenue
- $1,711
- Change in Net Assets
- $-61,367
Audited Revenue Reconciliation
- Revenue per Audited Statements
- $4,495,007
- Revenue Not Reported on Financial Statements
- $0
- Revenue Not Reported on Form 990
- $0
- Total Revenue per Audited Statements
- $4,495,007
- Total Revenue per Form 990
- $4,495,007
Expenses and Functional Allocation
Major Expense Lines
| Line Item | Amount |
|---|---|
| Salaries, Compensation, and Employee Benefits | $2,956,924 |
| Other Expenses | $1,599,450 |
| Grants and Similar Amounts Paid | $0 |
| Professional Fundraising Fees | $0 |
| Total Fundraising Expense | $0 |
Functional Expense Allocation
| Line Item | Program | Management | Fundraising | Total |
|---|---|---|---|---|
| Other Salaries and Wages | $1,989,475 | $244,073 | - | $2,233,548 |
| Fees for Services Management | - | $461,167 | - | $461,167 |
| Other Employee Benefits | $293,384 | $47,413 | - | $340,797 |
| Pension Plan Contributions | $276,499 | $34,596 | - | $311,095 |
| Office Expenses | $198,313 | $39,352 | - | $237,665 |
| Occupancy | $166,253 | $18,473 | - | $184,726 |
| Fees for Services Other | $170,708 | - | - | $170,708 |
| Depreciation Depletion | $130,202 | $14,467 | - | $144,669 |
| Information Technology | $93,712 | $10,412 | - | $104,124 |
| Interest | $65,775 | $7,308 | - | $73,083 |
| Payroll Taxes | $47,668 | $5,503 | - | $53,171 |
| Conferences and Meetings | $37,724 | $4,192 | - | $41,916 |
| Insurance | $21,558 | $4,857 | - | $26,415 |
| Advertising | - | $21,845 | - | $21,845 |
| Current Officers, Directors, Trustees, and Key Employees | - | $18,313 | - | $18,313 |
| Fees for Services Accounting | - | $17,584 | - | $17,584 |
| Travel | $4,453 | $1,577 | - | $6,030 |
| Fees for Services Legal | - | $2,970 | - | $2,970 |
| Other Expenses | $0 | $2,348 | - | $2,348 |
| All Other Expenses | $1,799 | - | - | $1,799 |
| Total Functional Expenses | $3,497,729 | $1,058,645 | $0 | $4,556,374 |
Audited Expense Reconciliation
| Line Item | Amount |
|---|---|
| Total Expenses per Audited Statements | $4,959,495 |
| Expenses per Audited Statements | $4,556,374 |
| Total Expenses per Form 990 | $4,556,374 |
| Expenses Not Reported on Form 990 | $403,121 |
| 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 | $579,000 |
Debt and Bond Financing
Other Reported Liabilities
| Liability | Amount |
|---|---|
| Net Pension LIABILITY | $6,678,541 |
| Capital Lease Equipment Payable | $79,516 |
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: elyria community elementary entered into 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: ELYRIA COMMUNITY ELEMENTARY 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 Elyria
- EIN
- 34-1932960
- 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
- 2000
- Legal Domicile
- Oh
- Voting Board Members
- 5
- Independent Board Members
- 5
- Employees
- 79
- Volunteers
- 75
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 61,794. Management and general expenses 0. Fundraising expenses 0. Total expenses 61,794. HEALTH SERVICES: Program service expenses 24,000. Management and general expenses 0. Fundraising expenses 0. Total expenses 24,000. FOOD SERVICE: Program service expenses 84,914. Management and general expenses 0. Fundraising expenses 0. Total expenses 84,914.”
Form 990, Part XI, line 9:
“Current period adjustment due to adoption of gasb 68. -403,121. Prior period adjustment due to adoption of gasb 68. -417,125.”
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 403,121.”
Raw XML AppendixShowing 400 of 546 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 | 94515 |
| IRS990/AccountsPayableAccrExpnssGrp/EOYAmt | 0 | 154309 |
| IRS990/AccountsReceivableGrp/BOYAmt | 0 | 390 |
| IRS990/AccountsReceivableGrp/EOYAmt | 0 | 50 |
| IRS990/ActivitiesConductedPrtshpInd | 0 | 0 |
| IRS990/ActivityOrMissionDesc | 0 | CONSTELLATION SCHOOLS: ELYRIA COMMUNITY ELEMENTARY 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 | 21845 |
| IRS990/AdvertisingGrp/TotalAmt | 0 | 21845 |
| IRS990/AllOtherExpensesGrp/ProgramServicesAmt | 0 | 1799 |
| IRS990/AllOtherExpensesGrp/TotalAmt | 0 | 1799 |
| IRS990/AnnualDisclosureCoveredPrsnInd | 0 | 1 |
| IRS990/AuditCommitteeInd | 0 | 1 |
| IRS990/BackupWthldComplianceInd | 0 | 1 |
| IRS990/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt | 0 | CONSTELLATION SCHOOLSLLC |
| 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 | 961823 |
| IRS990/CashNonInterestBearingGrp/EOYAmt | 0 | 756818 |
| IRS990/ChangeToOrgDocumentsInd | 0 | 0 |
| IRS990/CntrctRcvdGreaterThan100KCnt | 0 | 2 |
| IRS990/CollectionsOfArtInd | 0 | 0 |
| IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt | 0 | 18313 |
| IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt | 0 | 18313 |
| IRS990/CompensationFromOtherSrcsInd | 0 | 0 |
| IRS990/CompensationProcessCEOInd | 0 | 1 |
| IRS990/CompensationProcessOtherInd | 0 | 1 |
| IRS990/ConferencesMeetingsGrp/ManagementAndGeneralAmt | 0 | 4192 |
| IRS990/ConferencesMeetingsGrp/ProgramServicesAmt | 0 | 37724 |
| IRS990/ConferencesMeetingsGrp/TotalAmt | 0 | 41916 |
| IRS990/ConflictOfInterestPolicyInd | 0 | 1 |
| IRS990/ConservationEasementsInd | 0 | 0 |
| IRS990/ConsolidatedAuditFinclStmtInd | 0 | 0 |
| IRS990/ContractorCompensationGrp/CompensationAmt | 0 | 579000 |
| IRS990/ContractorCompensationGrp/CompensationAmt | 1 | 160400 |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt | 0 | 5730 BROADVIEW ROAD |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt | 1 | PO BOX 1266 |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm | 0 | PARMA |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm | 1 | ELYRIA |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd | 0 | OH |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd | 1 | OH |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd | 0 | 44134 |
| IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd | 1 | 44036 |
| IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt | 0 | CONSTELLATION SCHOOLS LLC |
| IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt | 1 | JL REICHERT INC |
| IRS990/ContractorCompensationGrp/ServicesDesc | 0 | MANAGEMENT SERVICES & STAFFING |
| IRS990/ContractorCompensationGrp/ServicesDesc | 1 | GARAGE CONSTRUCTION & PARKING LOT PAVING |
| IRS990/CreditCounselingInd | 0 | 0 |
| IRS990/CYBenefitsPaidToMembersAmt | 0 | 0 |
| IRS990/CYContributionsGrantsAmt | 0 | 4286159 |
| IRS990/CYGrantsAndSimilarPaidAmt | 0 | 0 |
| IRS990/CYInvestmentIncomeAmt | 0 | 0 |
| IRS990/CYOtherExpensesAmt | 0 | 1599450 |
| IRS990/CYOtherRevenueAmt | 0 | 1711 |
| IRS990/CYProgramServiceRevenueAmt | 0 | 207137 |
| IRS990/CYRevenuesLessExpensesAmt | 0 | -61367 |
| IRS990/CYSalariesCompEmpBnftPaidAmt | 0 | 2956924 |
| IRS990/CYTotalExpensesAmt | 0 | 4556374 |
| IRS990/CYTotalFundraisingExpenseAmt | 0 | 0 |
| IRS990/CYTotalProfFndrsngExpnsAmt | 0 | 0 |
| IRS990/CYTotalRevenueAmt | 0 | 4495007 |
| IRS990/DecisionsSubjectToApprovaInd | 0 | 0 |
| IRS990/DeductibleArtContributionInd | 0 | 0 |
| IRS990/DeductibleNonCashContriInd | 0 | 0 |
| IRS990/DeferredRevenueGrp/BOYAmt | 0 | 288721 |
| IRS990/DeferredRevenueGrp/EOYAmt | 0 | 18704 |
| IRS990/DelegationOfMgmtDutiesInd | 0 | 1 |
| IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt | 0 | 14467 |
| IRS990/DepreciationDepletionGrp/ProgramServicesAmt | 0 | 130202 |
| IRS990/DepreciationDepletionGrp/TotalAmt | 0 | 144669 |
| IRS990/Desc | 0 | PRIMARY EDUCATION - SERVED 508 STUDENTS IN KINDERGARTEN THROUGH 8TH GRADE. |
| IRS990/DescribedInSection501c3Ind | 0 | 1 |
| IRS990/DisregardedEntityInd | 0 | 0 |
| IRS990/DocumentRetentionPolicyInd | 0 | 1 |
| IRS990/DonorAdvisedFundInd | 0 | 0 |
| IRS990/ElectionOfBoardMembersInd | 0 | 0 |
| IRS990/EmployeeCnt | 0 | 79 |
| IRS990/EmploymentTaxReturnsFiledInd | 0 | 1 |
| IRS990/EngagedInExcessBenefitTransInd | 0 | 0 |
| IRS990/ExpenseAmt | 0 | 3497729 |
| IRS990/FamilyOrBusinessRlnInd | 0 | 1 |
| IRS990/FederalGrantAuditRequiredInd | 0 | 0 |
| IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt | 0 | 17584 |
| IRS990/FeesForServicesAccountingGrp/TotalAmt | 0 | 17584 |
| IRS990/FeesForServicesLegalGrp/ManagementAndGeneralAmt | 0 | 2970 |
| IRS990/FeesForServicesLegalGrp/TotalAmt | 0 | 2970 |
| IRS990/FeesForServicesManagementGrp/ManagementAndGeneralAmt | 0 | 461167 |
| IRS990/FeesForServicesManagementGrp/TotalAmt | 0 | 461167 |
| IRS990/FeesForServicesOtherGrp/ProgramServicesAmt | 0 | 170708 |
| IRS990/FeesForServicesOtherGrp/TotalAmt | 0 | 170708 |
| IRS990/ForeignActivitiesInd | 0 | 0 |
| IRS990/ForeignFinancialAccountInd | 0 | 0 |
| IRS990/ForeignOfficeInd | 0 | 0 |
| IRS990/Form8282PropertyDisposedOfInd | 0 | 0 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt | 0 | 0.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt | 1 | 0.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt | 2 | 0.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt | 3 | 0.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt | 4 | 0.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt | 5 | 0.00 |
| IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt | 6 | 0.00 |
| 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 | BERT BUTTS |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 1 | JEROME BEDNAR |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 2 | LEO TISCHER |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 3 | MARK STYPCZYNSKI |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 4 | JOHN NOGA |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 5 | THOMAS BABB |
| IRS990/Form990PartVIISectionAGrp/PersonNm | 6 | REBECCA KEENEY |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 0 | 31 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 1 | 375 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 2 | 344 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 3 | 375 |
| IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt | 4 | 375 |
| 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 JUNE 2017 |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 1 | BOARD MEMBER |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 2 | BOARD MEMBER |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 3 | BOARD SECRETARY |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 4 | BOARD PRESIDENT |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 5 | CFO |
| IRS990/Form990PartVIISectionAGrp/TitleTxt | 6 | EXECUTIVE DIRECTOR |
| IRS990/Form990ProvidedToGvrnBodyInd | 0 | 1 |
| IRS990/FormationYr | 0 | 2000 |
| 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 | 4286159 |
| IRS990/GrantAmt | 0 | 0 |
| IRS990/GrantsPayableGrp/BOYAmt | 0 | 0 |
| IRS990/GrantsPayableGrp/EOYAmt | 0 | 53348 |
| IRS990/GrantsToIndividualsInd | 0 | 0 |
| IRS990/GrantsToOrganizationsInd | 0 | 0 |
| IRS990/GrantToRelatedPersonInd | 0 | 0 |
| IRS990/GrossReceiptsAmt | 0 | 4495007 |
| 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 | 10412 |
| IRS990/InformationTechnologyGrp/ProgramServicesAmt | 0 | 93712 |
| IRS990/InformationTechnologyGrp/TotalAmt | 0 | 104124 |
| IRS990/InsuranceGrp/ManagementAndGeneralAmt | 0 | 4857 |
| IRS990/InsuranceGrp/ProgramServicesAmt | 0 | 21558 |
| IRS990/InsuranceGrp/TotalAmt | 0 | 26415 |
| IRS990/InterestGrp/ManagementAndGeneralAmt | 0 | 7308 |
| IRS990/InterestGrp/ProgramServicesAmt | 0 | 65775 |
| IRS990/InterestGrp/TotalAmt | 0 | 73083 |
| IRS990/InvestmentInJointVentureInd | 0 | 0 |
| IRS990/IRPDocumentCnt | 0 | 2 |
| IRS990/IRPDocumentW2GCnt | 0 | 0 |
| IRS990/LandBldgEquipAccumDeprecAmt | 0 | 721255 |
| IRS990/LandBldgEquipBasisNetGrp/BOYAmt | 0 | 2796955 |
| IRS990/LandBldgEquipBasisNetGrp/EOYAmt | 0 | 2895659 |
| IRS990/LandBldgEquipCostOrOtherBssAmt | 0 | 3616914 |
| 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: ELYRIA COMMUNITY ELEMENTARY 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/MortgNotesPyblScrdInvstPropGrp/BOYAmt | 0 | 1545524 |
| IRS990/MortgNotesPyblScrdInvstPropGrp/EOYAmt | 0 | 1398171 |
| IRS990/NetAssetsOrFundBalancesBOYAmt | 0 | -1789562 |
| IRS990/NetAssetsOrFundBalancesEOYAmt | 0 | -2671175 |
| IRS990/NetUnrelatedBusTxblIncmAmt | 0 | 0 |
| IRS990/NondeductibleContributionsInd | 0 | 0 |
| IRS990/OccupancyGrp/ManagementAndGeneralAmt | 0 | 18473 |
| IRS990/OccupancyGrp/ProgramServicesAmt | 0 | 166253 |
| IRS990/OccupancyGrp/TotalAmt | 0 | 184726 |
| IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt | 0 | 39352 |
| IRS990/OfficeExpensesGrp/ProgramServicesAmt | 0 | 198313 |
| IRS990/OfficeExpensesGrp/TotalAmt | 0 | 237665 |
| IRS990/OfficerMailingAddressInd | 0 | 0 |
| IRS990/OperateHospitalInd | 0 | 0 |
| IRS990/Organization501c3Ind | 0 | X |
| IRS990/OrganizationFollowsSFAS117Ind | 0 | X |
| IRS990/OtherAssetsTotalGrp/BOYAmt | 0 | 40945 |
| IRS990/OtherAssetsTotalGrp/EOYAmt | 0 | 29677 |
| IRS990/OtherChangesInNetAssetsAmt | 0 | -820246 |
| IRS990/OtherEmployeeBenefitsGrp/ManagementAndGeneralAmt | 0 | 47413 |
| IRS990/OtherEmployeeBenefitsGrp/ProgramServicesAmt | 0 | 293384 |
| IRS990/OtherEmployeeBenefitsGrp/TotalAmt | 0 | 340797 |
| IRS990/OtherExpensesGrp/Desc | 0 | SPONSOR FEES |
| IRS990/OtherExpensesGrp/Desc | 1 | MISCELLANEOUS EXPENSES |
| IRS990/OtherExpensesGrp/Desc | 2 | bank service charges |
| IRS990/OtherExpensesGrp/Desc | 3 | DUES AND SUBSCRIPTIONS |
| IRS990/OtherExpensesGrp/ManagementAndGeneralAmt | 0 | 81172 |
| IRS990/OtherExpensesGrp/ManagementAndGeneralAmt | 1 | 12586 |
| IRS990/OtherExpensesGrp/ManagementAndGeneralAmt | 2 | 8437 |
| IRS990/OtherExpensesGrp/ManagementAndGeneralAmt | 3 | 2348 |
| IRS990/OtherExpensesGrp/ProgramServicesAmt | 0 | 0 |
| IRS990/OtherExpensesGrp/ProgramServicesAmt | 1 | 206 |
| IRS990/OtherExpensesGrp/ProgramServicesAmt | 2 | 0 |
| IRS990/OtherExpensesGrp/ProgramServicesAmt | 3 | 0 |
| IRS990/OtherExpensesGrp/TotalAmt | 0 | 81172 |
| IRS990/OtherExpensesGrp/TotalAmt | 1 | 12792 |
| IRS990/OtherExpensesGrp/TotalAmt | 2 | 8437 |
| IRS990/OtherExpensesGrp/TotalAmt | 3 | 2348 |
| IRS990/OtherLiabilitiesGrp/BOYAmt | 0 | 4564201 |
| IRS990/OtherLiabilitiesGrp/EOYAmt | 0 | 6758057 |
| IRS990/OtherRevenueMiscGrp/BusinessCd | 0 | 611110 |
| IRS990/OtherRevenueMiscGrp/Desc | 0 | MISCELLANEOUS REVENUE |
| IRS990/OtherRevenueMiscGrp/RelatedOrExemptFuncIncomeAmt | 0 | 1711 |
| IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt | 0 | 1711 |
| IRS990/OtherRevenueTotalAmt | 0 | 1711 |
| IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt | 0 | 244073 |
| IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt | 0 | 1989475 |
| IRS990/OtherSalariesAndWagesGrp/TotalAmt | 0 | 2233548 |
| IRS990/OtherWebsiteInd | 0 | X |
| IRS990/PartialLiquidationInd | 0 | 0 |
| IRS990/PayPremiumsPrsnlBnftCntrctInd | 0 | 0 |
| IRS990/PayrollTaxesGrp/ManagementAndGeneralAmt | 0 | 5503 |
| IRS990/PayrollTaxesGrp/ProgramServicesAmt | 0 | 47668 |
| IRS990/PayrollTaxesGrp/TotalAmt | 0 | 53171 |
| IRS990/PensionPlanContributionsGrp/ManagementAndGeneralAmt | 0 | 34596 |
| IRS990/PensionPlanContributionsGrp/ProgramServicesAmt | 0 | 276499 |
| IRS990/PensionPlanContributionsGrp/TotalAmt | 0 | 311095 |
| IRS990/PledgesAndGrantsReceivableGrp/BOYAmt | 0 | 143792 |
| IRS990/PledgesAndGrantsReceivableGrp/EOYAmt | 0 | 114389 |
| IRS990/PoliticalCampaignActyInd | 0 | 0 |
| IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt | 0 | 759494 |
| IRS990/PrepaidExpensesDefrdChargesGrp/EOYAmt | 0 | 1914821 |
| IRS990/PrincipalOfficerNm | 0 | THOMAS BABB |
| IRS990/ProfessionalFundraisingInd | 0 | 0 |
| IRS990/ProgramServiceRevenueGrp/BusinessCd | 0 | 611110 |
| IRS990/ProgramServiceRevenueGrp/BusinessCd | 1 | 611110 |
| IRS990/ProgramServiceRevenueGrp/BusinessCd | 2 | 611110 |
| IRS990/ProgramServiceRevenueGrp/BusinessCd | 3 | 611110 |
| IRS990/ProgramServiceRevenueGrp/Desc | 0 | SERVICES- OTHER SCHOOL |
| IRS990/ProgramServiceRevenueGrp/Desc | 1 | MATERIALS FEES |
| IRS990/ProgramServiceRevenueGrp/Desc | 2 | BREAKFAST/LUNCH PROGRA |
| IRS990/ProgramServiceRevenueGrp/Desc | 3 | field trip fees |
| IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt | 0 | 103500 |
| IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt | 1 | 84573 |
| IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt | 2 | 14969 |
| IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt | 3 | 4095 |
| IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt | 0 | 103500 |
| IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt | 1 | 84573 |
| IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt | 2 | 14969 |
| IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt | 3 | 4095 |
| IRS990/ProhibitedTaxShelterTransInd | 0 | 0 |
| IRS990/PYBenefitsPaidToMembersAmt | 0 | 0 |
| IRS990/PYContributionsGrantsAmt | 0 | 4241375 |
| IRS990/PYExcessBenefitTransInd | 0 | 0 |
| IRS990/PYGrantsAndSimilarPaidAmt | 0 | 0 |
| IRS990/PYInvestmentIncomeAmt | 0 | 0 |
| IRS990/PYOtherExpensesAmt | 0 | 1653031 |
| IRS990/PYOtherRevenueAmt | 0 | 32975 |
| IRS990/PYProgramServiceRevenueAmt | 0 | 107793 |
| IRS990/PYRevenuesLessExpensesAmt | 0 | 129246 |
| IRS990/PYSalariesCompEmpBnftPaidAmt | 0 | 2599866 |
| IRS990/PYTotalExpensesAmt | 0 | 4252897 |
| IRS990/PYTotalProfFndrsngExpnsAmt | 0 | 0 |
| IRS990/PYTotalRevenueAmt | 0 | 4382143 |
| IRS990/QuidProQuoContributionsInd | 0 | 0 |
| IRS990/RcvFndsToPayPrsnlBnftCntrctInd | 0 | 0 |
| IRS990/ReconcilationRevenueExpnssAmt | 0 | -61367 |
| 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 | 208848 |
| IRS990ScheduleA/SchoolInd | 0 | X |
| IRS990/ScheduleBRequiredInd | 0 | 0 |
| IRS990ScheduleD/BuildingsGrp/BookValueAmt | 0 | 2330286 |
| IRS990ScheduleD/BuildingsGrp/DepreciationAmt | 0 | 556154 |
| IRS990ScheduleD/BuildingsGrp/OtherCostOrOtherBasisAmt | 0 | 2886440 |
| IRS990ScheduleD/EquipmentGrp/BookValueAmt | 0 | 142473 |
| IRS990ScheduleD/EquipmentGrp/DepreciationAmt | 0 | 165101 |
| IRS990ScheduleD/EquipmentGrp/OtherCostOrOtherBasisAmt | 0 | 307574 |
| IRS990ScheduleD/ExpensesNotReportedAmt | 0 | 403121 |
| IRS990ScheduleD/ExpensesNotRptFinclStmtAmt | 0 | 0 |
| IRS990ScheduleD/ExpensesSubtotalAmt | 0 | 4556374 |
| IRS990ScheduleD/FootnoteTextInd | 0 | X |
| IRS990ScheduleD/LandGrp/BookValueAmt | 0 | 422900 |
| IRS990ScheduleD/LandGrp/OtherCostOrOtherBasisAmt | 0 | 422900 |
| IRS990ScheduleD/OtherExpensesIncludedAmt | 0 | 403121 |
| IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt | 0 | 79516 |
| IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt | 1 | 6678541 |
| IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc | 0 | CAPITAL LEASE EQUIPMENT PAYABLE |
| IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc | 1 | Net Pension LIABILITY |
| IRS990ScheduleD/RevenueNotReportedAmt | 0 | 0 |
| IRS990ScheduleD/RevenueNotReportedFinclStmtAmt | 0 | 0 |
| IRS990ScheduleD/RevenueSubtotalAmt | 0 | 4495007 |
| 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 403,121. |
| IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc | 0 | Part X, Line 2: |
| IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc | 1 | Part XII, Line 2d - Other Adjustments: |
| IRS990ScheduleD/TotalBookValueLandBuildingsAmt | 0 | 2895659 |
| IRS990ScheduleD/TotalExpensesPerForm990Amt | 0 | 4556374 |
| IRS990ScheduleD/TotalLiabilityAmt | 0 | 6758057 |
| IRS990ScheduleD/TotalRevenuePerForm990Amt | 0 | 4495007 |
| IRS990ScheduleD/TotalRevEtcAuditedFinclStmtAmt | 0 | 4495007 |
| IRS990ScheduleD/TotExpnsEtcAuditedFinclStmtAmt | 0 | 4959495 |
| 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 NONDISCRIMINATION 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. THERE IS THEREFORE NO NEED TO OFFER SCHOLARSHIPS OR FINANCIAL ASSISTANCE. |
| IRS990ScheduleE/SupplementalInformationDetail/ExplanationTxt | 2 | THE SCHOOL RECEIVES US 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 | 579000 |
| 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: ELYRIA COMMUNITY ELEMENTARY ENTERED INTO 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: ELYRIA COMMUNITY ELEMENTARY 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 61,794. Management and general expenses 0. Fundraising expenses 0. Total expenses 61,794. HEALTH SERVICES: Program service expenses 24,000. Management and general expenses 0. Fundraising expenses 0. Total expenses 24,000. FOOD SERVICE: Program service expenses 84,914. Management and general expenses 0. Fundraising expenses 0. Total expenses 84,914. |
| IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt | 8 | CURRENT PERIOD ADJUSTMENT DUE TO ADOPTION OF GASB 68. -403,121. PRIOR PERIOD ADJUSTMENT DUE TO ADOPTION OF GASB 68. -417,125. |
| 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 |
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
- $5,711,414
- Liabilities
- $8,382,589
- Net assets
- -$2,671,175
- Revenue
- $4,495,007
- Expenses
- $4,556,374
- Net income
- -$61,367