Get documents about "HSB udgetworksheet
Document Sample
PARISH ACCOUNTING REPORTING
MANAGEMENT SERVICES
ARCHDIOCESE OF NEW YORK
PARISH HIGH SCHOOL BUDGET
WORKSHEET
For the Fiscal Year
SEPTEMBER 1, 2010 - AUGUST 31, 2011
SCHOOL NO. Entity Code
PASTOR:
PRINCIPAL
SCHOOL NAME
ADDRESS:
CITY
STATE, ZIP NY
1/31/10
855a0add-9ba5-4a0b-b117-167924786adc.xls Cover Page 1 of 17 Parish ARMS 8/31/2012 8:18 AM
School Name 0 Number 0 Schedule 1
Personnel Costs
Clergy - Administration Auto Trvl Med Pens Edu Retr Travel Priest Continuing
Position Name Stipends Insurance Car Ref Ref Ref Ref Ref Allowance Medical Domicile Retirement Education Retreats Total
| - - - - See below - - - - |
Principal - - - - - -
Vice Principal - - - - - -
- - - - - -
- - - - - -
- - - - - - - - -
7101.000 7108.000 7102.000 7103.000 7104.000 7105.000 7106.000 7107.000
Clergy Med Ref C
Clergy Car Ref Enter Y if Priests has car, N if Priests does not have a car
Clergy Retirement Ref Enter Y if Priests has Retirement, N if Priests does not have a retirement
Clergy Contiuning Education Enter Y if Priests has Continuing Ed, N if Priests does not have Continuing Ed
Clergy Retreats Enter Y if Priests has Retreats, N if Priests does not have Retreats
Religious Personnel - Administration Trvl Med Dom Pens Travel Domicile
Position Name Stipends Ref Ref Ref Ref Allowance Medical Expense Pension Total
| - - See below - - |
Principal - - - - -
Vice Principal - - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - - -
7201.000 7202.000 7203.000 7204.000 7205.000
Religious Med Ref R=Medical plus dental 1, R2=Medicare, R3=Medical plus dental 2
Religious Travel Ref Enter Y if Religious has Travel, N if Religious does not have Travel
Religious Domicile Ref Enter Y if Religious has Domicile, N if Religious does not have Domicile
Religious Pension Ref Enter Y if Religious has Pension, N if Religious does not have Pension
Page 2 of 17
School Name 0 Number 0 Schedule 1
Personnel Costs
Lay - Administration Degree U/I Hr / Med Pens FICA & Unemploy. Short Term NYS Life,
Position Name and Step Salary Wk Ref Ref Medicare Insurance Disability MCTMT Medical AD&D, LTD Pension Total
| - - See below - - |
Principal - - - - - - - -
Vice Principal - - - - - - - -
Secretary - - - - - - - -
Bookkeeper - - - - - - - -
Development - - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - - -
7310.000 7320.000 7330.000 7340.000 7325.000 7350.000 7350.000 7360.000
Lay Med Ref - Non Bargaining NB1=Single, NB2=Two Persons, NB3=Family, N1=No Medical
Lay Med Ref - Bargaining B1=Single, B2=Two Persons, B3=Family, N2=No Medical
Lay Unemployment (U/I) Enter Y/N - If yes, All Employees have Unemployment Insurance per NYS Law
Lay S.T. Disability Ref Enter Y if Lay has Short Term Disability, N if Lay does not have Short Term Disability
Lay Pension Ref Enter Y if Lay has Pension, N if Lay does not have Pension
Religious Personnel - Instruction Trvl Med Dom Pens Travel Domicile
Position Name Stipends Ref Ref Ref Ref Allowance Medical Expense Pension Total
| - - See below - - |
- - - - -
- - - - -
- - - - -
- - - - -
- - - - - -
7201.000 7202.000 7203.000 7204.000 7205.000
Religious Med Ref R=Medical plus dental 1, R2=Medicare, R3=Medical plus dental 2
Religious Travel Ref Enter Y if Religious has Travel, N if Religious does not have Travel
Religious Domicile Ref Enter Y if Religious has Domicile, N if Religious does not have Domicile
Religious Pension Ref Enter Y if Religious has Pension, N if Religious does not have Pension
Page 3 of 17
School Name 0 Number 0 Schedule 1
Personnel Costs
Lay - Instruction 9/1-2/28 3/1-8/31 Annual Lump Sum U/I Hr / Med Pens Union FICA & Unemploy. Short Term NYS Life, Annuity Retirement
Position Name Degree Step Salary Salary Salary Bonus Wk Ref Ref Ref Medicare Insurance Disability MCTMT Medical AD&D, LTD Pension Match Bonus Total
| - - - - See below - - - - |
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
- - - - - - - - - - - -
7301.000 7320.000 7330.000 7340.000 7325.000 7350.000 7350.000 7360.000 7370.000 7380.000
Lay Med Ref - Non Bargaining NB1=Single, NB2=Two Persons, NB3=Family, N1=No Medical
Lay Med Ref - Bargaining B1=Single, B2=Two Persons, B3=Family, N2=No Medical
Lay Unemployment (U/I) Enter Y/N - If yes, All Employees have Unemployment Insurance per NYS Law
Lay S.T. Disability Ref Enter Y if Lay has Short Term Disability, N if Lay does not have Short Term Disability
Lay Pension Ref Enter Y if Lay has Pension, N if Lay does not have Pension
Page 4 of 17
School Name 0 Number 0 Schedule 1
Personnel Costs
Lay - Full Time Special Subject Degree U/I Hr / Med Pens Union FICA & Unemploy. Short Term NYS Life, Annuity Retirement
Position Name and Step Salary Wk Ref Ref Ref Medicare Insurance Disability MCTMT Medical AD&D, LTD Pension Match Bonus Total
| - - - - See below - - - - |
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - - - - -
7302.000 7320.000 7330.000 7340.000 7325.000 7350.000 7350.000 7360.000 7370.000 7380.000
Lay Med Ref - Non Bargaining NB1=Single, NB2=Two Persons, NB3=Family, N1=No Medical
Lay Med Ref - Bargaining B1=Single, B2=Two Persons, B3=Family, N2=No Medical
Lay Unemployment (U/I) Enter Y/N - If yes, All Employees have Unemployment Insurance per NYS Law
Lay S.T. Disability Ref Enter Y if Lay has Short Term Disability, N if Lay does not have Short Term Disability
Lay Pension Ref Enter Y if Lay has Pension, N if Lay does not have Pension
Lay - Part Time Special Subject U/I Hr / Med Pens Union FICA & Unemploy. Short Term NYS Life,
Position Name Salary Wk Ref Ref Ref Medicare Insurance Disability MCTMT Medical AD&D, LTD Pension Total
| - - - - See below - - - - |
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - - -
7303.000 7320.000 7330.000 7340.000 7325.000 7350.000 7350.000 7360.000
Lay Med Ref - Non Bargaining NB1=Single, NB2=Two Persons, NB3=Family, N1=No Medical
Lay Med Ref - Bargaining B1=Single, B2=Two Persons, B3=Family, N2=No Medical
Lay Unemployment (U/I) Enter Y/N - If yes, All Employees have Unemployment Insurance per NYS Law
Lay S.T. Disability Ref Enter Y if Lay has Short Term Disability, N if Lay does not have Short Term Disability
Lay Pension Ref Enter Y if Lay has Pension, N if Lay does not have Pension
Lay - Full Time Aides U/I Hr / Med Pens Union FICA & Unemploy. Short Term NYS Life,
Position Name Salary Wk Ref Ref Ref Medicare Insurance Disability MCTMT Medical AD&D, LTD Pension Total
| - - - - See below - - - - |
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - - -
7304.000 7320.000 7330.000 7340.000 7325.000 7350.000 7350.000 7360.000
Lay Med Ref - Non Bargaining NB1=Single, NB2=Two Persons, NB3=Family, N1=No Medical
Lay Med Ref - Bargaining B1=Single, B2=Two Persons, B3=Family, N2=No Medical
Lay Unemployment (U/I) Enter Y/N - If yes, All Employees have Unemployment Insurance per NYS Law
Lay S.T. Disability Ref Enter Y if Lay has Short Term Disability, N if Lay does not have Short Term Disability
Lay Pension Ref Enter Y if Lay has Pension, N if Lay does not have Pension
Page 5 of 17
School Name 0 Number 0 Schedule 1
Personnel Costs
Lay - Part Time Aides U/I Hr / Med Pens Union FICA & Unemploy. Short Term NYS Life,
Position Name Salary Wk Ref Ref Ref Medicare Insurance Disability MCTMT Medical AD&D, LTD Pension Total
| - - - - See below - - - - |
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - - -
7305.000 7320.000 7330.000 7340.000 7325.000 7350.000 7350.000 7360.000
Lay Med Ref - Non Bargaining NB1=Single, NB2=Two Persons, NB3=Family, N1=No Medical
Lay Med Ref - Bargaining B1=Single, B2=Two Persons, B3=Family, N2=No Medical
Lay Unemployment (U/I) Enter Y/N - If yes, All Employees have Unemployment Insurance per NYS Law
Lay S.T. Disability Ref Enter Y if Lay has Short Term Disability, N if Lay does not have Short Term Disability
Lay Pension Ref Enter Y if Lay has Pension, N if Lay does not have Pension
Lay - Cafeteria U/I Hr / Med Pens FICA & Unemploy. Short Term NYS Life,
Position Name Salary Wk Ref Ref Medicare Insurance Disability MCTMT Medical AD&D, LTD Pension Total
| - - See below - - |
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - - -
7310.000 7320.000 7330.000 7340.000 7325.000 7350.000 7350.000 7360.000
Lay Med Ref - Non Bargaining NB1=Single, NB2=Two Persons, NB3=Family, N1=No Medical
Lay Med Ref - Bargaining B1=Single, B2=Two Persons, B3=Family, N2=No Medical
Lay Unemployment (U/I) Enter Y/N - If yes, All Employees have Unemployment Insurance per NYS Law
Lay S.T. Disability Ref Enter Y if Lay has Short Term Disability, N if Lay does not have Short Term Disability
Lay Pension Ref Enter Y if Lay has Pension, N if Lay does not have Pension
Lay - Maintenance U/I Hr / Med Pens FICA & Unemploy. Short Term NYS Life,
Position Name Salary Wk Ref Ref Medicare Insurance Disability MCTMT Medical AD&D, LTD Pension Total
| - - See below - - |
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - -
- - - - - - - - -
7310.000 7320.000 7330.000 7340.000 7325.000 7350.000 7350.000 7360.000
Lay Med Ref - Non Bargaining NB1=Single, NB2=Two Persons, NB3=Family, N1=No Medical
Lay Med Ref - Bargaining B1=Single, B2=Two Persons, B3=Family, N2=No Medical
Lay Unemployment (U/I) Enter Y/N - If yes, All Employees have Unemployment Insurance per NYS Law
Lay S.T. Disability Ref Enter Y if Lay has Short Term Disability, N if Lay does not have Short Term Disability
Lay Pension Ref Enter Y if Lay has Pension, N if Lay does not have Pension
Page 6 of 17
Adjustments to Salary Scale
Lay - Instruction:
Salary
Position Name Adjustment
0
7301.000
Explanation
High School 0 Number 0
EXPECTED TUITION REVENUES
Grades Freshman through Senior
Number of Class Annual
Families Students Levels Rate
Freshmen
Sophmores
Juniors
Seniors
Scholarships*
*Must agree to GL Acct. # 5505
- - Total Families, Students and Expected Tuition
Per Capita Tuition
Schedule 2
Expected
Revenue
-
-
-
-
-
5301.000
#DIV/0!
School Name 0 School No.
Schedule No. 2A
Account Selected Budget Statistics
Fiscal Year September 1, 2010 - August 31, 2011
STATISTICS - STUDENTS
0503.000 Total Number of Students
STATISTICS - TEACHERS
0524.000 Number of Administrative - Religious Professionals
0525.000 Number of Administrative - Religious Non-Professionals
0526.000 Number of Administrative - Lay Professionals
0527.000 Number of Administrative - Lay Non-Professionals
0528.000 Number of Teachers - Religious Professionals*
0529.000 Number of Teachers - Religious Non-Professionals**
0530.000 Number of Teachers - Lay Professionals*
0531.000 Number of Teachers - Lay Non-Professionals**
0532.000 Number of Teachers - Part Time Professionals*
0536.000 Total Staff
0537.000 Total Administrative Positions
0538.000 *Total Number of Teaching Professionals
0539.000 **Total Number of Teaching Non Professionals
STATISTICS - OTHER
0550.000 Number of Families
0551.000 Student / Teacher Ration (# Prof. Teachers/ # Students)
0552.000 Average Class Size
TUITION RATES
0560.100 Tuition - Freshman
0560.200 Tuition - Sophomore
0560.300 Tuition - Junior
0560.400 Tuition - Senior
0
Budget
2010-2011
-
-
-
-
-
-
0.00
0.00
-
-
-
-
School Name 0 School No. 0 Schedule 2B
Total Income and Expenses Per Grade
Formulas for Flag Determination
Core Ratio (80% Rule)
Core Income Core Expense
Total Tuition and Fees
Acct. 5505 - Scholarships
Lay Personnel Costs - Admin
Lay Personnel Costs - Instruct 1
2
Acct. 7203 - Religious Medical
2
Acct. 7205 - Religious Pension
Total Office & Clerical Expenses
Total Educational Dept Expenses
Total Utilities - Maintenance
Acct. 7705 - Contract Services
Acct. 7801 - Prop & Gen Insur.
Acct. 8101 - Consumables
Total Program Exp - Admin
Budget 2009 - - 0.00%
Core Income Core Expense Ratio
Income Over Expense Ratio
Total Income Total Expense Ratio
Budget 2009 0.00%
Actual 2006 0.00%
Per Capita Ratio
(Positive = Surplus / Negative = Deficit)
Per Capita Inc. 3 Per Capita Exp. 4 Net Per Capita
Budget 2009 - - -
Actual 2006 - - -
Archdiocesan Support Ratio
CIPF Support Total Income Ratio
Budget 2009 0.00%
Actual 2006 0.00%
Parish Support Ratio
Parish Support Total Income Ratio
Budget 2009 0.00%
Actual 2006 0.00%
1 Lay Personnel Costs includes all Instructional employees
2 Religious expenses include Administration and Instructional only for Clergy
and Religious Personnel.
3 Per Capita Income = Total Income / # Stud. K - 8
4 Per Capita Expense = Total Expense / # Stud. K - 8
Sch 2B optional Ratios 13 of 17 8/31/2012, 8:18 AM
School Name Number: -
Account Account Description LOGOS Budget Final Budget
Number GL Number 2010-2011 Adjustments 2010-2011
Personnel Cost Totals
7100.000 Clergy Personnel Costs - Administration
7101.000 Clergy - Salary and Stipends 7101000504500 - -
7102.000 Clergy - Travel Allowance 7102000504500 - -
7103.000 Clergy - Medical Insurance 7103000504500 - -
7104.000 Clergy - Domicile Expenditures 7104000504500 - -
7105.000 Clergy - Priests Retirement 7105000504500 - -
7106.000 Clergy - Continuing Education 7106000504500 - -
7107.000 Clergy - Retreats 7107000504500 - -
7108.000 Clergy - Auto Insurance 7108000504500 - -
Total Lay Personnel Costs-Administration - - -
7200.000 Religious Personnel Costs-Administration
7201.000 Religious- Stipends 7201000504500 - -
7202.000 Religious- Travel Allowance 7202000504500 - -
7203.000 Religious- Medical & Life Insurance 7203000504500 - -
7204.000 Religious- Domicile 7204000504500 - -
7205.000 Religious- Pension Contribution 7205000504500 - -
Total Religious Personnel Costs-Administration - - -
7300.000 Lay Personnel Costs-Administration
7310.000 Lay- Salaries 7310000504500 - -
7320.000 Lay- FICA and Medicare 7320000504500 - -
7325.000 Lay- NYS MCTMT 7325000504500 - -
7330.000 Lay- Unemployment Insurance 7330000504500 - -
7340.000 Lay- Short Term Disability 7340000504500 - -
7350.000 Lay- Medical/Life/AD&D/LTD 7350000504500 - -
7360.000 Lay- Pension Contribution 7360000504500 - -
Total Lay Personnel Costs-Administration - - -
7200.000 Religious Personnel Costs-Instruction
7201.000 Religious- Stipends 7201000505000 - -
7202.000 Religious- Travel Allowance 7202000505000 - -
7203.000 Religious- Medical & Life Insurance 7203000505000 - -
7204.000 Religious- Domicile 7204000505000 - -
7205.000 Religious- Pension Contribution 7205000505000 - -
Total Religious Personnel Costs-Instruction - - -
7301.000 Lay Personnel Costs-Instruction
7301.000 Lay- Salaries 7301000505000 - - -
7320.000 Lay- FICA and Medicare 7320000505000 - - -
7325.000 Lay- NYS MCTMT 7325000505000 - -
7330.000 Lay- Unemployment Insurance 7330000505000 - -
7340.000 Lay- Short Term Disability 7340000505000 - -
7350.000 Lay- Medical/Life/AD&D/LTD 7350000505000 - -
7360.000 Lay- Pension Contribution 7360000505000 - -
7370.000 Lay- Annuity Match 7370000505000 - -
7380.000 Lay- Retirement Bonus 7380000505000 - -
Total Lay Personnel Costs-Instruction - - -
855a0add-9ba5-4a0b-b117-167924786adc.xls Total Personnel Cost recap Page 14 of 17 Parish ARMS 8/31/2012 8:18 AM
School Name Number: -
Account Account Description LOGOS Budget Final Budget
Number GL Number 2010-2011 Adjustments 2010-2011
7300.000 Lay Personnel Costs-Cafeteria
7310.000 Lay- Salaries 7310000505500 - -
7320.000 Lay- FICA and Medicare 7320000505500 - -
7325.000 Lay- NYS MCTMT 7325000505500 - -
7330.000 Lay- Unemployment Insurance 7330000505500 - -
7340.000 Lay- Short Term Disability 7340000505500 - -
7350.000 Lay- Medical/Life/AD&D/LTD 7350000505500 - -
7360.000 Lay- Pension Contribution 7360000505500 - -
Total Lay Personnel Costs-Cafeteria - - -
7300.000 Lay Personnel Costs-Maintenance
7310.000 Lay- Salaries 7310000506500 - -
7320.000 Lay- FICA and Medicare 7320000506500 - -
7325.000 Lay- NYS MCTMT 7325000506500 - -
7330.000 Lay- Unemployment Insurance 7330000506500 - -
7340.000 Lay- Short Term Disability 7340000506500 - -
7350.000 Lay- Medical/Life/AD&D/LTD 7350000506500 - -
7360.000 Lay- Pension Contribution 7360000506500 - -
Total Lay Personnel Costs-Maintenance - - -
7302.000 Lay Personnel Costs-Full Time Special Subject
7302.000 Lay- Salaries 7302000505000 - -
7320.000 Lay- FICA and Medicare 7320000505000 - -
7325.000 Lay- NYS MCTMT 7325000505000 - -
7330.000 Lay- Unemployment Insurance 7330000505000 - -
7340.000 Lay- Short Term Disability 7340000505000 - -
7350.000 Lay- Medical/Life/AD&D/LTD 7350000505000 - -
7360.000 Lay- Pension Contribution 7360000505000 - -
7370.000 Lay- Annuity Match 7370000505000 - -
7380.000 Lay- Retirement Bonus 7380000505000 - -
Total Lay Personnel Costs-Full Time Special Subject - - -
7303.000 Lay Personnel Costs-Part Time Special Subject
7303.000 Lay- Salaries 7303000505000 - -
7320.000 Lay- FICA and Medicare 7320000505000 - -
7325.000 Lay- NYS MCTMT 7325000505000 - -
7330.000 Lay- Unemployment Insurance 7330000505000 - -
7340.000 Lay- Short Term Disability 7340000505000 - -
7350.000 Lay- Medical/Life/AD&D/LTD 7350000505000 - -
7360.000 Lay- Pension Contribution 7360000505000 - -
Total Lay Personnel Costs-P. T. Special Subject - - -
7304.000 Lay Personnel Costs-Full Time Aides
7304.000 Lay- Salaries 7304000505000 - -
7320.000 Lay- FICA and Medicare 7320000505000 - -
7325.000 Lay- NYS MCTMT 7325000505000 - -
7330.000 Lay- Unemployment Insurance 7330000505000 - -
7340.000 Lay- Short Term Disability 7340000505000 - -
7350.000 Lay- Medical/Life/AD&D/LTD 7350000505000 - -
7360.000 Lay- Pension Contribution 7360000505000 - -
Total Lay Personnel Costs-Full Time Aides - - -
7305.000 Lay Personnel Costs-Part Time Aides
7305.000 Lay- Salaries 7305000505000 - -
7320.000 Lay- FICA and Medicare 7320000505000 - -
7325.000 Lay- NYS MCTMT 7325000505000 - -
7330.000 Lay- Unemployment Insurance 7330000505000 - -
7340.000 Lay- Short Term Disability 7340000505000 - -
7350.000 Lay- Medical/Life/AD&D/LTD 7350000505000 - -
7360.000 Lay- Pension Contribution 7360000505000 - -
Total Lay Personnel Costs-Part Time Aides - - -
Total Personnel Cost - - -
SINGATURE SECTION
Reviewed and approved by pastor: Date
Signed:
Reviewed and approved by principal Date
Signed:
Prepared by: Date
Signed:
Phone:
Address:
City/State/Zip: Fax:
E-mail Address:
Be sure to save this worksheet to a location on your computer (for example, desktop or my documents) then:
855a0add-9ba5-4a0b-b117-167924786adc.xls Total Personnel Cost recap Page 15 of 17 Parish ARMS 8/31/2012 8:18 AM
School Name Number: -
Account Account Description LOGOS Budget Final Budget
Number GL Number 2010-2011 Adjustments 2010-2011
When Worksheet is signed and completed click on the corresponding disk to the
right, this will save the worksheet in:
c\logoswin\gl\chs or c\logoswin\gl\bhs or c\logoswin\gl\ghs
If your program path or data directory is different, CHS
please see the Budget Manual, page 13
BHS GHS
In order for this to save correctly macros need to be enabled.
855a0add-9ba5-4a0b-b117-167924786adc.xls Total Personnel Cost recap Page 16 of 17 Parish ARMS 8/31/2012 8:18 AM
High school
Parish finance
DOE
