2007 Form W2 Template

Document Sample
2007 Form W2 Template Powered By Docstoc
					                  2008-09 Electronic Funding Determination Request
                         Form - Instructions for Submission

1. This application packet was developed to provide applicant schools with electronic tools that
   standardize the Charter School Nonclassroom-based Funding Determination process in a
   format that facilitates the review and analysis of the request. The Microsoft Excel formatted
   workbook includes a template version of the Funding Determination Request Form for 2008-
   09 (to be completed by applicants). It also includes integrated hidden worksheets for
   Funding Determination Calculations and analyses, and a template for use by the California
   Department of Education (CDE) staff to provide summary data, analysis, and comments to
   the Advisory Commission on Charter Schools (ACCS).


2. All applicant schools must complete the Funding Determination Request Form.
3. This is a spreadsheet report and as such should be completed using Microsoft Excel. The
   spreadsheet is protected to only allow data entry in the fields specifically identified by
   YELLOW shading (nonasterisk fields). GREEN shaded fields, which also have a single
   asterisk for accessability, are calculated by formulas included in the spreadsheet. The forms
   are also designed to auto-fill repetitive data.
4. Additional information is included that may be helpful in answering questions about what
   should be included in each cell. In specific cells identified by a small red triangle in the
   upper right corner of the cell, there are "cell comments". To review cell comments, place the
   cursor in any cells with a small red triangle in the upper right corner of the cell and a pop-up
   narrative box will appear with pertinent information.
5. In the Funding Determination Request Form there is a hyperlink to the CDE Web site with
   instructions and access to Education Code and the California Code of Regulations sections
   that affect Nonclassroom-based Funding Determinations. You must have an active Internet
   connection to be able to click and navigate to these pages that provide pertinent
   information.
6. Submission Instructions:
   a) E-mail the completed Microsoft Excel workbook with a school specific file name listing
   the Charter school number and name of the school:
   123ABCCharter Academy.xls to:
                                       Charters@cde.ca.gov
   b) In addition to the electronic file, a printed copy of the completed Funding Determination
   Request Form with appropriate signatures is also required. The form should be mailed to:


                       Attn: Nonclassroom-based Funding Determinations
                                     Charter School Division
                               California Department of Education
                                     1430 N Street, Suite 5401
                                      Sacramento, CA 95814
                                       Fax: (916) 322-1465
                                     2008-09 Nonclassroom-Based Funding Determination
                                                              (Based on prior year data. See Instructions for clarification.)

        Link to Instructions, Education
                                                                                       http://www.cde.ca.gov/49451
        Code , CA Code of Regulations:
                                                         To be completed by Charter School (unprotected)
                                                               Calculated by Software (protected) *


Section I. Charter Information

Charter School Name:                 Sacramento Academic & Vocational Academy                                   Charter #:                  878


CDS Code:                      34-76505-0114272                                                                   County:            Sacramento

Authorizing Entity:                         Twin Rivers Unified School District

Street Address:                                                                   5727 Perrin Avenue

City:                                      McClellan                   State: CA                    Zip:                        95652

Mailing Address:                                                                             Same
(if different)
City:                                                                  State: CA                    Zip:

Contact Name:                                 Jodi Retzloff                         Title:                               CFO

Phone #:                                  916-286-5129                            Fax # :                            916-924-3481

E-mail Address:                                                               jodi.retzloff@twinriversusd.org


% Funding Requested:                         100%                     Number of Years of Request:                       Five Year Request

Date Charter Granted:                       3/7/2007                          Date Charter Expires:                            6/30/2012
                                           mm/dd/yyyy                                                                          mm/dd/yyyy
                                                    Expiration of Current Funding Determination:                                2008-09
Specify Grade Levels Served and Enrollment:
           Grade Level:              7-12                                           ADA        465.46             ASAM:                     No

Section II. Certification
    I certify that:
                       1) The information provided is true and correct to the best of my ability and knowledge.

                          2) This charter school’s nonclassroom-based instruction is conducted for and substantially dedicated to the
                             instructional benefit of the school’s students.

                          3) This charter school’s governing board has adopted and implements conflict of interest policies.


                          4) All of the charter school’s transactions, contracts, and agreements are in the best interest of the school and
                             reflect a reasonable market rate for all goods, services, and considerations rendered for or supplied to the
                             school.




                                                        Signature of Authorized Individual Representing Charter School

                                         Superintendent/CEO
                                    Title of Authorized Individual                                                           Date




                                                                              2
                                     2008-09 Nonclassroom-Based Funding Determination
                                                                (Based on prior year data. See Instructions for clarification.)

        III. Financial Information
Section Link to Instructions, Education
                                                                                        http://www.cde.ca.gov/49451
       Code , CA Code of Regulations:
  A. Resources Available for Expenditure
                             1. Revenues and Other Financing Sources
                                        a. Federal Revenues
                                                      (i) Amount of start up, implementation and
                                                          dissemination grant(s) in 1a.

                                       b. State Revenues                                                                   $      2,861,633
                                       c. Local Revenues                                                                   $        620,160
                                                     (i) Amount in Lieu of Property Taxes in 1c.           $    620,160
                                       d. Other Financing Sources
                                       e. Subtotal All Financing Sources *                                                 $      3,481,793
                           2. Ending Balance from Prior Fiscal Year

                           3. Total Resources Available for Expenditure *                                                  $      3,481,793
  B. Expenditures and Other Financing Uses
                           1. Instruction and Related Services
                                       a. Salaries and Benefits
                                                      (i) Certificated                                                     $      2,125,746
                                                      (ii) Classified                                                      $        205,896
                                       b. Books, Supplies and Equipment                                                    $        392,384
                                       c. Services and Other Operating Costs
                                                      (i) Contracts for Instructional Services                             $         15,174
                                                      (ii) Contracts for Instructional Support                             $         19,522
                                                     (iii) All other Instruction Related Operating Costs                   $         47,141
                                       d Subtotal Instruction and Related Services *                                       $      2,805,863
                           2. Operations and Facilities
                                       a. Salaries and Benefits
                                                      (i) Certificated
                                                      (ii) Classified
                                       b. Books, Supplies and Equipment                                                    $         1,352
                                       c. Services and Other Operating Costs                                               $       235,653
                                       d. Facility Acquisition & Construction
                                       e. Subtotal Operations and Facilities *                                             $       237,005
                                       f. Allowable Facility Costs
                                                      (i) Provide Actual Square Footage occupied by
                                                          the charter school                                     12,249
                                                     (ii) Total Classroom-Based Average Daily
                                                          Attendance (if applicable) as reported at the
                                                          prior-year second apportionment (P2)
                                                     (iii) Total Student Hours attended by
                                                           nonclassroom-based pupils at the school site        21,600.00

                           3. Administration and All Other Activities
                                       a. Salaries and Benefits
                                                      (i) Certificated
                                                      (ii) Classified                                                      $        36,573
                                       b. Books, Supplies and Equipment
                                       c. Services and Other Operating Costs
                                                     (i) Contracts for Other Administrative Services
                                                     (ii) Supervisorial Oversight Fee                                      $        28,276
                                                    (iii) All Other Administration & Other Activities,
                                                          Services & Operating Costs                                       $           563
                                       d. Subtotal Administration and All Other Activities *                               $        65,412




                                                                                 3
                                          2008-09 Nonclassroom-Based Funding Determination
                                                                      (Based on prior year data. See Instructions for clarification.)

       Link to Instructions, Education
                                                                                              http://www.cde.ca.gov/49451
SectionCode , CA Code of Regulations:
        III. Financial Information (continued)
  B. Expenditures and Other Financing Uses (continued)
                                 4. Other Outgo and Other Financing Uses
                                            a. Debt Service
                                            b. Transfer to District or County                                                         $                            77,524
                                            c. All Other Outgo
                                            d. Subtotal Other Outgo and Other Financing Uses *                                        $                            77,524
                                 5. Total Expenditures/Other Uses *                                                                   $                        3,185,804
  C. Excess (Deficiency) of Revenues Over Expenditures
                          1. Total Excess Revenues *                                                                                  $                          295,989
                                            a. Reserve Designated for Economic Uncertainties                                          $                          159,290
                                            b. Reserve for Facilities Acquisition or Construction                                     $                           50,000
                                            c. Other Reserve                                                                          $                           86,699

Section IV. Additional Information
  1. Provide the charter school’s pupil-teacher ratio as calculated pursuant to Education Code Section 51745.6 and California Code of Regulations, Title 5,
     Section 11704.
                                          Pupil to teacher ratio does not exceed 25 to 1 or the pupil to teacher ratio of the charter school does not exceed that
               25            to 1         of the largest USD in county(s) served.
                                               Enter 25 to 1 or the pupil to teacher ratio of the largest unified school district in the county(ies) served by the charter.
                   25              to 1

                                               Enter the name of the largest unified school district in the county(ies) served by the charter school if not using 25 to 1
                  N/A                          as the comparison pupil to teacher ratio.
   2. Are any entities receiving $50,000 or 10% or more of the charter school's total expenditures reported in Section III,
      Lines B.1.c, B.2.c, and B.3.c?                                                                                                                   Yes

        Provide a listing of entities that received $50,000 or 10% or more of the charter school’s total expenditures reported in Section III, Lines B.1.c, B.2.c, and
        B.3.c, and the amount provided to each. Are each of the contract payments made by the charter school based on specific services rendered, clearly
        stating the fee per service rendered and invoiced accordingly? Are any of the contract payments based upon an amount per unit of average daily
        attendance or some other percentage of the charter school’s revenues, enrollment, etc.? If so, which ones?
                                                                                                                                       Payment Basis
                                                                                                                   Fee for Service
                        Entity                          Amount                     Purpose/Explanation
                                                                                                                     rendered -                    % per ADA
                                                                                                                      invoiced

   a Pletz Investment Company                   $                 79,261 Facilities Lease                                 No                           No
   b Jackson Properties                         $                 54,362 Facilities Lease                                 No                           No
    c Grant Joint Unfiied School District       $                286,604 MOU Services - Seet Attached                    Yes                           No
   d Grant Joint Unfiied School District        $                 28,276 Oversight Fee                                   Yes                           No
   e
                                                                                                                     Select one                    Select one
    f
                                                                                                                     Select one                    Select one
   g
                                                                                                                     Select one                    Select one
   h                                                                                                                 Select one                    Select one
    i
                                                                                                                     Select one                    Select one
    j                                                                                                                Select one                    Select one
    k
                                                                                                                     Select one                    Select one
    l
                                                                                                                     Select one                    Select one
   m
                                                                                                                     Select one                    Select one
   n                                                                                                                 Select one                    Select one
   o                                                                                                                 Select one                    Select one




                                                                                       4
                                        2008-09 Nonclassroom-Based Funding Determination
                                                                 (Based on prior year data. See Instructions for clarification.)

        IV Additional Information (continued)
Section Link to Instructions, Education
                                                                               http://www.cde.ca.gov/49451
       Code , CA Code of Regulations:
  3. Who are the members comprising the charter school’s CURRENT governing board (i.e. how many parents, teachers, etc)?
                                                                 Selection or Representative
                     Name                    Board Position                                      Start of Term     End of Term
                                                                          Authority
   a             Jason Sample                  President                                         1-Jul-06          30-Jun-10
   b             Kevin Spesert                Vice-Pres.                                         1-Jul-08          30-Jun-10
   c           Bruce Mangerich            Secretary/Treasurer                                    1-Jul-08          30-Jun-10
   d            Mark Anderson                   Director                                         1-Jul-08          30-Jun-10
   e              Jack Turner                   Director                                         1-Jul-06          30-Jun-10
    f           Ziggy Robeson                 Non-Voting        Twin Rivers Unified School       9-Jan-09          9-Dec-09
   g
   h

   a In the text box below describe how and when Board members are selected.
     The corporation has 5 directors (board members). All directors shall be designated by the existing Board of Directors. No teacher or staff
     member employed at the charter school shall serve as a director on the Board of Directors. In addition, one non-voting board member may be
     designated or assigned by the Twin Rivers Unified School District or its successor district on an annual basis.



   b Does the charter school’s governing board have adopted and implemented conflict of interest policies and
                                                                                                                                                 Yes
     procedures? If yes, please provide a copy.
   c Are any of the governing board members affiliated in any way with any of the entities reported as a response to
                                                                                                                                                  No
     question 2? If yes, please provide an explanation in the text box below.




  4. In the text box below explain the reasons for the expenditures (Transfers to "Districts or County") reported in Section
     III, Line B.4.b.

       The amount is for non-instructional administrative services for Business, Human Resources and Risk Management.


  5. List the “Other Reserves” and the amount of each reported on Line C.1.c (if applicable).
        Amount of Reserve                                                           Purpose of Reserve
      $               86,699 Cash flow reserve to fund cash shortfalls inherent to significant growth




  6. How many full-time equivalent employees are at your school?                                                                                               36.50
       How many full-time equivalent employees at your school possess a valid teaching certificate, permit, or other
       document equivalent to that which a teacher in other public schools would be required to hold issued by the
       Commission on Teacher Credentialing?                                                                                                                    29.00
       Do you request exclusion for one-time special purpose funds or special consideration for 2008-09 budget
  7.                                                                                                                                              No
       reductions?
       If yes, in the text box below list any one-time special purpose funds that you wish CDE staff to consider as a mitigating factor. Include a description of the
       program, the amount of one-time special purpose funds, and whether you request the funds to be excluded from the calculation for Certificated Staff
       Costs, Instruction and Related Services Costs, or both. If requesting special consideration for 2008-09 budget reductions, please explain special
       circumstances below.




                                                                                   5
                                   2008-09 Nonclassroom-Based Funding Determination
                                                             (Based on prior year data. See Instructions for clarification.)

8. In the space below, explain what steps are being taken to improve the academic performance of students at your school.
      Link to Instructions, Education
                                                                                  http://www.cde.ca.gov/49451
     Code , CA Code of Regulations:
   Sacramento Academic and Vocational Academy (SAVA) is serving a diverse population of 7th - 12th grade, primarily at risk, students across the
   greater Sacramento Region. SAVA provides both strong academics and a rich vocational/careers emphasis for its students. While SAVA did
   not perform to administrative expectations on API and AYP, it is important to note that the school was in its first year of operation and grew
   from approximately 300 students to approximately 800 students in one year. The need for this program in our area is great. During the current
   academic year many positive steps have been taken to build and increase on our academic program. 1. SAVA went through an initial WASC
   accreditation visit. 2. SAVA has almost doubled it's hiring of Core Specialists positions (Enlish, Math, Science and Social Science). 3. Tutoring
   labs and hours have been expanded. 4. Testing and assessment data has been converted to charts and figures and staff development has
   occurred regarding areas needing academic prescription. 5. SAVA has enrolled in a pilot project with the California Charter Schools Association
   regarding the use of a data system called ZOOM to further utilize the strength of data driven decision making.




9. In the text box below, feel free to provide any additional information or explanation you feel may have a material affect on our evaluation and
   recommendation. If more space is required, an additional Word document may be submitted with this form.
  Sacramento Academic & Vocational Academy (SAVA) is expected to grow substantially over the next 3 years. Due to the funding gap inherent
  in charter school funding, it is essential that the charter school maintain substantial cash reserves to cover short term cash shortfalls.
  Additionally, SAVA has a vocational emphasis which requires facilities far more extensive than typically required for an Independent Study
  charter school. Reserves are required to ensure that funds are available for procurement of adequate housing for the rapidly expanding
  vocational training programs that are paramount to the students educational program.




                                                                              6
                                                 2008-09 Nonclassroom-Based Funding Determination
                                                CDE Funding Recommendation and Summary Worksheet
                                                             (Based on prior year data.)
                                             To be completed by CDE Staff (unprotected)
                                 Filled From School Data Provided on the Request Form (protected)**
                                                 Calculated by Software (protected) *
Section I. Charter Information
**Charter School Name  Sacramento Academic & Vocational Academy                                                                 **Charter #               878

**CDS Code:                          34-76505-0114272                                                            **County:                  Sacramento

**Authorizing Entity:                       Twin Rivers Unified School District

Type of School:                      Continuing School                               Year of most recent prior funding determination:                  2007-08
**Years Requested:                   Five Year Request                          Duration of most recent prior funding determination:                      2 yr
**% Funding Requested:                           100%                            Percent of most recent prior funding determination:                     100%
                                                                            **Expiration of most recent prior funding determination:                   2008-09
Specify:
**Grade Levels Served:                                    7-12                                        **ADA:          465.46         **ASAM:                   No

**Date Charter Granted:                             3/7/2007                                                **Date Charter Expires:                    6/30/2012
                                                   mm/dd/yyyy                                                                                          mm/dd/yyyy
Section III. Funding Calculation
         61.05%       Percent Certificated Staff Costs*                                                                   B1a (certificated)
                                                                                                                      A1a - A1a(i) + A1b + A1c(i)
            80.59%                  Expenditures on Instruction and Related Services as a percentage of total revenue*                                         B1d
                                                                                                                                                               A1e
                                     Actual Allowable Facilities Costs*
               N/A                      The lesser of B2e or [(B2fii + (B2fiii /868)) * 1000]

                                     Percent Allowable Facilities Costs*
               N/A                      Actual divided by III.A.1.e.


               N/A                   Expenditures on Instruction and Related Services including Allowable Facilities Costs *


Section IV. Additional Required Information
1.         25        :1        **Pupil to teacher ratio at charter school.

                                                     **Pupil to teacher ratio does not exceed 25 to 1 or the pupil to teacher ratio of the charter
                25                 :1                school does not exceed that of the largest USD in county(ies) served.



               N/A                                **If using the ratio of largest USD, please specify the district .




2.             Yes                 **Are any entities identified who are receiving over $50,000 or 10% or more of the charter school's
                                    total expenditures? If “Yes”, please specify or list.
                                                                                                                                               Payment Basis

                                                                                                                                 Fee for Service
                        Entity                                   Amount                         Purpose/Explanation
                                                                                                                                   rendered -           % per ADA
                                                                                                                                    invoiced

2a.         Pletz Investment Company                  $                 79,261.00                 Facilities Lease                    No                   No
2b.             Jackson Properties                    $                 54,362.00                 Facilities Lease                    No                   No
2c.      Grant Joint Unfiied School District          $                286,604.00         MOU Services - Seet Attached                Yes                  No


                                                                                     7
3.           No             Are there any potential conflicts of interest or other concerns related to the governing board?
                            If “Yes”, please explain in CDE recommendation section.

4.        $295,989          **Total Excess Revenues Reported on Line C1.
           8.50%            Excess Revenue as a Percentage of Total Resources available*                              C1 / A3


5.          29.00           **Number of full-time equivalent employees at the charter school who possess a valid teaching
                            certificate, permit, or other document equivalent to that which a teacher in other public schools would be
                            required to hold issued by the Commission on Teacher Credentialing.


Calculated Funding Determination Eligibility per Regulatory Formula(s):
                              Certificated staff compensation equals or exceeds 40 percent of total public revenues and the
                              percentage calculated for Total Expenditures on Instruction and Related Services equals or exceeds
     Yes, Receive 100% if
                              80 percent of total revenues (100 percent funding) and the charter school’s pupil-teacher does not
      Ratio above is OK
                              exceed 25:1 or the equivalent pupil-teacher ratio of the largest unified school district in the county or
                              counties in which the charter school operates.*

                              Certificated staff compensation equals or exceeds 40% of total public revenues and the percentage
             No               calculated for Total Expenditures on Instruction and Related Services equals or exceeds 70% but is
                              less than 80% of total revenues (85% funding).*

                              Certificated staff compensation equals or exceeds 35% but is less than 40% of total public revenues
             No               and the percentage calculated for Total Expenditures on Instruction and Related Services equals or
                              exceeds 60% of total revenues (70% funding).*

                              Certificated staff compensation is less than 35% of total public revenues or the percentage calculated
             No               for Total Expenditures on Instruction and Related Services is less than 60% of total revenues (No
                              funding).*

Mitigating Factors to Consider in Funding Determination:
             No             The charter school is in its first year of operation.

             No             The charter school has less than 100 units of prior year, second-period average daily attendance.

             No             **The charter school requests exclusion of one-time special purpose funds.

                            2006 Base                     2006 Statewide                  2006 Similar
             N/A            API
                                               N/A        Rank
                                                                                    N/A   Schools Rank

                            2007 Base                     2007 Statewide                  2007 Similar Schools
             N/A            API
                                               N/A        Rank
                                                                                    N/A   Rank

                            2008 Growth                   2007 CAHSEE                     2007 CAHSEE
             468                                          ELA % Passed                    Math % Passed
                            API


                                                          2008 CAHSEE                     2008 CAHSEE
                                                          ELA % Passed                    Math % Passed


Summary of Review and Reasons for Recommendation
     CDE Recommendation:
            100%            Percent Funding Recommended by CDE Charter School Division
             4 yr           Number of Years




                                                                     8
Recommendation Notes, Additional Comments & Explanation:
This is a continuing school with 61.05% of the school’s total public revenues expended for salaries and
benefits for all employees who possess a valid teaching certificate, permit, or other document equivalent to
that which a teacher in other public schools would be required to hold issued by the Commission on
Teacher Credentialing; and, 80.59% of the school’s total revenues expended on instruction and related
services.

The school serves grades 7 through 12 and has a pupil to teacher ratio of 25:1 and a total enrollment as of
October 2008 of 392.

The SAVA: Sacramento Academic and Vocational Academy Charter School has an 2008 API Growth of 468.

The Independent Auditor reported the school has no negative audit findings.

CDE recommends 100% funding for 4 years.




                                                       9
                               Attachment A- Direct Services Revenues via allocation of Departmental Budgets
                                                              FY 2007-2008

                                                                      Attachment A -- Overview
The allocation methodology has been developed to provide a fair, straight forward approach to charging Grant Community Charters (GCC) with
the cost of a variety of direct service charges. This document will be utilized to provide projected revenues and expenses for both entities.
The actual amount will be reconciled at year-end by re-running the same reports with actual data and reconciling any dirrerence between the
budgeted amounts with the actual amounts.

All parties have agreed to the curent methodology described in the attached worksheets whereby the district will receive "Direct Service
Revenues" based upon various allocations of departmental budgets from the preceding year's 2nd Interim Comparative Budget reports
(Allocation Master Report). These revenues represent a reimbursement of departmental expenditures incurred providing these direct services.
GCC and District Business Office staff shall review and mutually agree to all applicable reports, allocation methodologies and departmental
costs.

The Direct Service contract costs are allocated to GCC based upon a combination of a pro-rata share of the departmental budgets (based on
various allocation methodologies) and an applicable "Use Factor". This "Use Factor" is a discounting of the allocated charges based upon
the fact that GCC staff or GCC expenditures are utilized for a pro-rata share of the specific activity.

The sum total of all departmental charges represents the total annual "Direct Service Revenues". This amount will be transferred internally by
District Budget Office staff in January (50%) and June (50%). In the event the CDE approves this allocation methodology for "Oversight
Charges", all parties agree that the attached spreadsheet and methodology shall be the basis for allocating revenues.

GCC and the District agree that this information may be re-formatted for the presentation of information to the CDE for reporting requests.
While the formatting may change, the total dollars will not.

                                                                                                               FY 07-08
                                                                                                               Adopted Allocation   Allocation     Use      Contract
Description: District Contracted Services Provided to Grant Community Charters                                  Budget    Method      Amount     Factor        Cost

Accounting & Finance

Financial Accounting -maintenance & posting of all financial transactions to ledger - Accounts receivable       163,967        7        5,606      20%           1,121
Finance                                                                                                         265,947        7        9,092      20%           1,818
Accounts Payable                                                                                                234,573        7        8,020      20%           1,604
Total Accounting & Finance                                                                                      664,487                22,718                    4,544




       10 of 14                                                c3b45b8f-09df-45ac-b27d-c5e2fe03ec6b.xls DS Summary                                   12/1/2010
                                                                                                                FY 07-08
                                                                                                                Adopted Allocation   Allocation     Use      Contract
Description: District Contracted Services Provided to Grant Community Charters                                   Budget    Method      Amount     Factor        Cost
Payroll & Benefits

Preparation of pay warrants
Distribution of payroll checks/direct deposits
Calculation & processing of tax, benefit, retirement & other withholding
Forwarding tax documentation to Federal & State authorities
Process W2's & W2C's
Create & process absence tracking groups & forms
Payroll and Benefit Support Services                                                                             498,701        5        4,519      20%             904
Total Payroll                                                                                                    498,701                 4,519                      904

Other Services
Curriculum Development                                                                                           333,044        4        9,592     25%             2,398
Educational Options                                                                                               55,521        4        1,599     25%               400
Educational Services                                                                                             491,111        4       14,145     25%             3,536
Pupil Testing and Assessment                                                                                     185,244        4        5,335     50%             2,668
Communications & Community Relations                                                                             162,550        4        4,682     20%               936
Legal Services Administration                                                                                    268,125        4        7,722     20%             1,544
Superintendent's Office Administration                                                                           246,475        4        7,099     20%             1,420
Psych Services                                                                                                   444,413        4       12,800     25%             3,200
Special Ed. Encroachment                                                                                       3,640,183        4      104,844     27%            28,320
Special Ed. Excess Costs                                                                                               0        4            0    100%                 0
Student Services                                                                                                 196,172        4        5,650     25%             1,413
Welfare and Attendance                                                                                           195,927        4        5,643     25%             1,411
Total Other Services                                                                                           6,218,764               179,112                    47,246

Business Operations

Purchasing Procurement                                                                                           260,532        7        8,907      20%            1,781
Mail Services                                                                                                    113,357        7        3,875      20%              775
Supply Management (Warehouse)                                                                                    301,876        7       10,321      20%            2,064


Total Business Operations                                                                                        675,765                23,103                     4,621

Budget & Fiscal Planning

Establishing a chart of accounts & account structure
Consulting assistance to assist in identifying revenues, comparing estimated revenues & actual revenues
Assistance in projecting & monitoring expenditures
Assistance with preparing & revising long-term financial projections & reports
Assistance in maintaining position control to reflect staffing obligations
Total Budget                                                                                                     276,532    7            9,454      20%            1,891




       11 of 14                                                 c3b45b8f-09df-45ac-b27d-c5e2fe03ec6b.xls DS Summary                                   12/1/2010
                                                                                                                FY 07-08
                                                                                                                Adopted Allocation   Allocation     Use      Contract
Description: District Contracted Services Provided to Grant Community Charters                                   Budget    Method      Amount     Factor        Cost
HR & Personnel Administrative Services

All HR & personnel administrative support provided to all other District schools                                 964,431        5        8,740      20%            1,748
Total HR & Personnel Administrative Services                                                                     964,431        5        8,740                     1,748

Risk Management

Drug / Alcohol Prevention Program                                                                                      0        5            0    100%                 0
Employee Assistance Program                                                                                            0        5            0    100%                 0
Risk Management Services                                                                                         193,843        5        1,757      0%                 0
Risk Management Insurance Liability (General Liability, Excess Liability,Student Insurance)                      370,875        4       10,682    100%            10,682
Risk Management Property Insurance Property (Property, Boiler and Machinery, Crime)                              287,593        4        8,283    100%             8,283
Risk Management Workers' Compensation Claims Administration and Assessment                                       135,457        5        1,228      0%                 0
Total Risk Management                                                                                            987,768                21,949                    18,965

Facilities Planning & Maintenance

Facilities and Planning Services                                                                                 528,036        6            0    100%                0
Maintenance                                                                                                    4,058,189        6            0    100%                0
Total Facilities and Planning                                                                                  4,586,224                     0                        0

Technology

Operations and Maintaining a network & telecom infrastructure for data & voice communication                      18,800        3       18,800    100%            18,800
Data processing
Computer Network
Operations
Systems & Programming
Telecommunications
Computer Services Operations
Student Information System
Admin Internet access
Employee E-mail
Administrative data storage
Anti-virus deployment
Content filtering
Spam & Spy ware suppression
Admin PC asset management, repair support, image creation
Technology / telephone SIS FIS helpdesk
Total Technology                                                                                                  18,800                18,800                    18,800

SUBTOTAL                                                                                                    14,891,473               288,395                  98,718




       12 of 14                                                 c3b45b8f-09df-45ac-b27d-c5e2fe03ec6b.xls DS Summary                                   12/1/2010
                                                                                                              FY 07-08
                                                                                                              Adopted Allocation     Allocation     Use      Contract
Description: District Contracted Services Provided to Grant Community Charters                                 Budget    Method        Amount     Factor        Cost

Charter School District Support Positions
Psychologist (.20) - Instructional                                                                              18,483      46.15%       8,529    100%             8,529
Accounting Coordinator (1.0)                                                                                   108,084      42.44%      45,866    100%            45,866
Custodians (1.90)                                                                                              110,237       0.00%           0    100%                 0
Receptionist (.10)                                                                                              28,445       5.00%       1,422    100%             1,422
Credentials Technician (1.0)                                                                                    33,797      33.00%      11,153    100%            11,153
Program Assistant (1.0)                                                                                         35,234      42.44%      14,952    100%            14,952
Teacher - RSP (1.0) - Instructional                                                                             69,924      42.44%      29,672    100%            29,672
Speech Therapist (0.50) - Instructional                                                                         29,676      42.44%      12,593    100%            12,593
Charter School Coordinator (1.0) - Instructional                                                               135,206      31.73%      42,904    100%            42,904

                                                   SUBTOTAL                                                    569,087                 167,090                167,090
Gina Velez-Balay Fiscal Analyst                                                                                 82,637       5.00%       4,132    100%          4,132
Randy Orzalli (Director, Ed Options - 50%) -Instructional                                                       80,339      10.00%       8,034    100%          8,034
Adam Berman (Director of Instruction) - Instructional                                                           15,425      50.00%       7,713    100%          7,713
Edna Shoemaker (BTSA 20% of 0.85 FTE) - Instructional                                                           18,349       5.00%         917    100%            917

Total Charter School District Direct Support Positions                                                         765,837                 187,886                187,886
Total                                                                                                     15,657,310                 476,282                286,604

Allocation Factor

3. SAVA computers in the network x $400/computer                                                                       0

4. SAVA enrollment / District enrollment
   Based on Projected Enrollment at adoption                                                                        2.88%

5. SAVA employees/District employees (Based on W-2's issued)                                                        0.91%

6. Number of Facilities                                                                                             0.00%

7. Number of PO's unavailable. Percentage of projected ADA is used                                                  3.42%




        13 of 14                                              c3b45b8f-09df-45ac-b27d-c5e2fe03ec6b.xls DS Summary                                     12/1/2010
                         Proposed "Oversight" allocation methodology -Operational Administration
All figures based upon the 2007-08 Adopted Budget

                                                                                                        07/08
                                                                                                      Adopted        Allocation       Use Factor GCC Amt (a)*(b)*(
   Dept Contact        Program #    Function   Resource                   Desc                DS / O Budget (a)    Methodology (b)        (c)          c)              Comments
   Mike McCoy            603          7400       0000     Assistant Superintendent, Human       O      184,871       4      5,325        100%            5,324.62
                                                          Resources (1.0 FTE)
    Pat Newsome          608         2100        0000     Associate Superintendent,            O        36,429       4      1,049        100%            1,049.22
                                                          Educational Services (1.0 FTE)
    Joan Polster         620         2100       Various   Associate Superintendent,            O        61,149       4      1,761        100%            1,761.19
                                                          Educational Options (0.33 FTE)
   Zenobia Gerald        604         7180        0000     Director, Communications and         O      135,274        4      3,896        100%            3,896.13
                                                          Community Relations (1.0 FTE)
   John Raymond          616         8700        0000     Assistant Superintendent,            O      188,703        4      5,435        100%            5,435.01
                                                          Facilities and Planning (1.0 FTE)
    Patty Paulsen        602         7300        0000     Assistant Superintendent,            O      198,437        4      5,715        100%            5,715.37
                                                          Business and Finance (1.0 FTE)
  Bruce Mangerich      602/636       7300        0000     Fiscal and Policy Advisor                    70,982        4      2,044        100%            2,044.40
  Linda Thompson         652         7110        0000     Board of Ed                          O      182,880        4      5,267        100%            5,267.28
   Larry Buchanan        601         7150        0000     Supt of Schools (1.0 FTE)            O      242,331        4      6,980        100%            6,979.58
  Jacques Whitfield      622         7160        0000     General Counsel (1.0 FTE)            O      217,916        4      6,276        100%            6,276.37
                                                                                                       1,518,971             43,749                       43,749     Total Oversight



Total CCCS Charter Revenue                                                                             2,827,612    1%                                    28,276     1% Maximum


Facilities Provided                                                   Address                        Revenue                                        Amount
                                                                                                             -      2%                                    -

  Total 2% Charge                                                                                                                                             -

   Grand Total                                                                                                                                            28,276

Allocation Factors
Allocation #3         SAVA computers on the network/Total District computers on network

Allocation #4         Projected enrollment / District Total CBEDs Enrollment including Adult Ed (Oct 1 Enrollment).
2.88%                 (500/(13,488 District + 2411 Adult Ed + 1,461 Total GCC) = 2.88% (Used 06-07 ADA for Adult Ed)
Allocation #5         SAVA employees/District employees
0.91%                 (26 positions / # of W-2's issued for 2006 (2597 District + 272 Total GCC)) = 0.91%
Allocation #6         Number of Facilities
0.00%                 (0 SAVA/15 District + 4 GCC) = 0%
Allocation #7         Number of PO's Issued -- unknown data as of adoption. % of ADA is being used
3.42%                 (460 SAVA/(10,975 District + 2,480 Total GCC)) = 3.42%

                                                     c3b45b8f-09df-45ac-b27d-c5e2fe03ec6b.xls Oversight charges                                                                12/1/2010

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:137
posted:12/1/2010
language:English
pages:14
Description: 2007 Form W2 Template document sample