Skip Maine state header navigation

Agencies | Online Services | Help

Skip First Level Navigation | Skip All Navigation

Home > School Closing Information > Cost Analysis Report Instructions

SCHOOL CLOSING INFORMATION

Cost Analysis Report Instructions:

Pursuant to Chapter 26 Rules, Section 3 Paragraph A: "All costs shall be calculated from actual base year operating costs..."

Base Year is defined as "the 2nd year prior to the allocation year".

The base year is used because it is the most recent available audited financial data in the MEDMS system. If the school will be closed at the end of the 2011-12 school year, the financial data from the 2010-11 school year should be used for the cost analysis.

Step 1: Download the Budget to Actual Report for the Base Year from MEDMS Financial Reports

  1. Log in to MEDMS → Under Application click on "Financial" → Click "Go" → Under Action click on View → Click "Go"
  2. Under Menu click on "Reports" → Under Sub-Menu click on "Budget to Actual Report" → Click "Go"
  3. Report Style = Detailed
  4. Fiscal Year = Base Year (i.e. 2011 if the school will be closed at the end of the 2011-12 School Year)
  5. Submission Type = Expenditure
  6. SAU = SAU
  7. Report Format = Excel
  8. Click on "Show Report" at the top of the form - this will open in an excel spreadsheet to use for the analysis. File-Save As the spreadsheet and go to the next step.

Step 2: After saving the downloaded Budget to Actual Report in excel - Sort by Fund, Program, Function, Cost Center and then Object in order to get the accounts into the Budget Category Cost Centers needed for the analysis.

a. Regular Instructionexcel_sort

b. Special Education

c. CTE/Vocational

d. Other Instruction

e. Student and Staff Support

f. System Administration

g. Facilities Management

h. Debt Service

i. All Other Expenditures

Step 3: Remove all but Fund 1000 expenditures - unless food service is in a different category, such as Fund 6000. The new total for the Actual Expended amounts should be the total for Column A in the "Cost Analysis Expenditure Detail Report".

Step 4: Copy the "Actual Expended" amounts from the downloaded and sorted spreadsheet into Column A of the "Cost Analysis Expenditure Detail Template Spreadsheet".

Column B and Column C should all be zeros and Column D should be a formula to calculate the savings of Col (B) - Col (C). The last column labeled "Notes" should be used to provide explanations of assumptions and positions which will be either eliminated or maintained.

Calculations showing the Subtotal for each Budget Category should be entered into the spreadsheet. You may have to do some rearranging of the line items so the subtotals add up into the appropriate categories. You will also need to correct the sum and subtotal calculations to properly account for each line of your budget.

Step 5: Download and print the SAU Average Teacher Salary report from the MEDMS Website - Rules require the use of the average elementary teacher salary in the district when calculating the savings of a terminated position; a copy of this document should be printed and attached as supporting data.

Instructions: Go to the following website: https://www.medms.maine.gov/medms_public/ReportPortal/Portal.aspx?CurrentLocation=/Public+Reports

Click on "Professional Staff"; Click "Average Salary of Instructional Staff"; Select Base Year for Report; Select Appropriate SAU; Click "Show Report" and Print the Report for your records.

Note: Please be sure you are using the Average Classroom Teacher Elementary Salary (not by gender).

Step 6: Determine method for calculating Average Elementary Teacher Benefits to be used when calculating the benefit savings of a terminated position; include back up documentation on how the average was determined.

Step 7: Column A should be the District's Actual Expenditures for the Base Year and should match the last budget printout for the base year and reconcile with the audited financials exactly.

Note: Columns B, C, and D should reflect expenditures for the school that is being closed only.

Step 8: Column B should be the Actual Expenditures for the School that is closing:

Note: For Cost Centers 900 and 950, you will need to determine what portion, if any, are attributable to the school that is closing and provide backup documentation on how that was determined.

Step 9: Column C is the expenditures tha will continue even "IF" the school was closed for that year. This should not take into consideration changes that are current.

Note: You must use the Average Teacher Salary and Average Teacher Benefits for Column C and D. Although you may have an idea of what specific teacher may have left or will be leaving the district, you do not know that for a fact and the rules state you must assume it is a position not a specifc teacher being eliminated, therefore the average salary and benefits for the district must be used for these calculations.

Step 10: Column D should be a formula that calculates what the savings would be if the school were closed in the base year. The calcuation subtracts the continuing costs in Column C from the actual costs in Column B to determine the amount to be saved.

Step 11: Once the totals and subtotals have been verified on the "Cost Analysis Expenditure Detail Template Spreadsheet", you will need to transfer the "Subtotals" of each Budget Category from the spreadsheet to the Cost Analysis Summary spreadsheet including notes of positions being maintained or eliminated. (Click here for a Sample Cost Analsyis Summary Template)

Notes regarding Cost Analsyis:

  1. Cost Analysis data must be audited data as submitted to the Department of Education - data must be downloaded from MEDMS Financial, not from the Local Accounting System.
  2. Must include printed copies of the Cost Analysis Expenditure Detail Spreadsheet and the Cost Analysis Summary Spreadsheet with the submission.
  3. Calculation for the reduction of teaching staff - the amount of the reduction in salaries and benefits shall be computed as the number of reduced teaching positions time sthe average salary and benefit cost for elementary teachers in the SAU.
  4. Calculation for the reduction of staff (other than teachers) - the rules are silent on this, therefore the cost may be actual or based on averages - please provide detail on which is used.
  5. For any reduction in staff, please note the FTE and position type - examples; 1 FTE Teacher, .5 FTE Ed Tech, .8 FTE Nurse, etc.
  6. Class size statement - you must indicate that the class size would not exceed the maximum class size statutes, Department of Education Rules, and/or SAU policy in effect during the base year.

Please direct any questions to:

Paula Gravelle

Department of Education
23 State House Station, Augusta, Maine 04333
Phone: (207) 624-6790
Fax: (207) 624-6791