SSF worksheets by SOT05zu8

VIEWS: 3 PAGES: 4

									                                                                                                                         SSF Worksheet 1

                                                           Specialized Service Facilities
                                                         Summary of Revenues and Expenses
                                                            Calculation of Billing Rates

       Facility Name
       Account Number
       Fund Number
       Budget Year

                                                                                  (a)            (b)            (c)          (d)           (e)
                                                                                                           YTD as of     Projected
                                                                              Actual for      Actual for     _______     Actual for   Budget for
                                                                             Fiscal Year    Fiscal Year    Current FY    Current FY   Fiscal Year
                                                                                ______         ______        ______       ______         ______
    REVENUES
  1 External (Class 11, Budget 72)
  2 Internal (Class 12, Budget 81xx)

  3 TOTAL REVENUE (1 + 2)                                                               -              -           -           -                 -


      EXPENSES
        DIRECT COSTS
  4    Salaries and Wages (Budgets 10 - 19, 26-27, 53)
  5    Fringe Benefits (Budgets 20-25, 27-29)
  6    Materials and Services (See note 1)
  7    Travel (Budget 36)
  8    Equipment (Budget 60-64)
  9    Allocations/Prorations (Budgets 9x)
 10    Other

 11 SUBTOTAL DIRECT EXPENSES (Sum line 4-10) (See note 2)                               -              -           -           -                 -

       EXCLUSIONS FROM RATE CALCULATION OF BILLING RATES
 12    Equipment (Line 8)                                                               -              -           -           -                 -
 13    Unallowable Budget/Object Codes (See note 3)
 14    Allocations/Prorations (Line 9)                                                  -              -           -           -                 -
 15    TOTAL EXCLUSIONS (Sum Lines 12-14)                                               -              -           -           -                 -

 16 DIRECT EXPENSES LESS EXCLUSIONS (Line 11 less Line 15)                              -              -           -           -                 -

       INDIRECT COSTS
 17    Equipment Depreciation (use worksheet 4)
 18    Building Depreciation
 19    Building Interest Expense
 20    Operations and Maintenance (O&M)
 21
 22    TOTAL INDIRECT COSTS (Sum lines 17-21)                                           -              -           -           -                 -


 23 TOTAL EXPENSES INCLUDED IN BILLING RATES (Line 16 + 22)                             -              -           -           -                 -


 24 OVER/(UNDER) RECOVERY (Line 3 less Line 22)                                         -              -           -           -                 -


       Submitted by:
                                 Name, Title and Date

       Approved by:
                                Name, Title and Date
Notes:
     1 Materials and services = Budgets 30, 34, 35, 4x, etc.
     2 Total direct costs must agree with FIS. Facilities including multiple funds should attach supporting worksheets
     3 Unallowable costs include budget/object codes:
       Dependent Tuition        29-03
       Consultants              30-20,30-87
       Supplies                 34-43,34-52,34-87
       Services                 35-50,35-51,35-53,35-54,35-69,35-74,35-87,35-88
       Travel                   36-47,36-87
                                           Specialized Service Facilities                                                SSF Worksheet 2
                                         Transfer of Surplus/Deficit to Fund Balance
                                                  Centers over $1,000,000

       Facility Name
       Account Number
       Fund Number
                                                                                                 (a)                              (b)
                                                                                          Actual for most                  University reserve
                                                                                        recently completed                     account #
                                                                                          FY _________                      ____________

FIVE YEAR F&A CUMULATIVE BALANCE
BEGINNING FUND BALANCE, JULY 1, _______

    REVENUES
  1 External (Class 11, Budget 72)                                                                                                         -
  2 Internal (Class 12, Budget 81xx)                                                                                                       -

  3 TOTAL REVENUE (1 + 2)                                                                                    -                             -


      EXPENSES
        DIRECT COSTS
  4    Salaries and Wages (Budgets 10 - 19, 26-27, 53)                                                                                     -
  5    Fringe Benefits (Budgets 20-25, 27-29)                                                                                              -
  6    Materials and Services (See note 1)                                                                                                 -
  7    Travel (Budget 36)                                                                                                                  -
  8    Equipment (Budget 60-64)                                                                                                            -
  9    Allocations/Prorations (Budgets 9x)                                                                                                 -
 10    Other                                                                                                                               -

 11 SUBTOTAL DIRECT EXPENSES (Sum line 4-10) (See note 2)                                                    -                             -

       CHANGES TO ENDING BALANCE
 12    Equipment cash purchase (Line 8)                                                                      -
 13    Unallowable Budget/Object Codes (See note 3)
 14    Changes in encumbrances
 15    Allocations/Prorations (Line 9)                                                                       -
 16    TOTAL EXCLUSION FROM CALCULATION (Lines 12-15)                                                        -                             -

 17 DIRECT EXPENSES LESS EXCLUSIONS (Line 11 less Line 16)                                                   -                             -

       INDIRECT COSTS
 18    Equipment Depreciation
 19    Building Depreciation
 20    Building Interest Expense
 21    Operations and Maintenance (O&M)
 22
 23    TOTAL INDIRECT COSTS (Sum lines 18-22)                                                                -                             -

 24 TOTAL EXPENSE                                                                                            -                             -

 25 OVER/(UNDER) RECOVERY (Line 3 less Line 24)                                                              -                             -

 26 TRANSFERRED TO FUND/RESERVE BALANCE                                                                                                    -

ENDING FUND BALANCE AS OF JUNE 30, _______________                                                                                         -
UPDATED FIVE YEAR F&A CUMULATIVE BALANCE

       Submitted by:
                                 Name, Title and Date

       Approved by:
                                 Name, Title and Date

Notes:
     1 Materials and services = Budgets 30, 34, 35, 4x, etc.
     2 Total direct costs must agree with FIS. Facilities including multiple funds should attach supporting worksheets
     3 Unallowable costs include budget/object codes:
       Dependent Tuition         29-03
       Consultants               30-20,30-87
       Supplies                  34-43,34-52,34-87
       Services                  35-50,35-51,35-53,35-54,35-69,35-74,35-87,35-88
       Travel                    36-47,36-87
                        SPECIALIZED SERVICE FACILITY QUESTIONNAIRE
                                        Worksheet 3



1 Facility Name:

2 Account Number:

3 Director/Manager:

4 Telephone Number:

5 Box:

6 Description of Service:




7 Affiliated Centers:




8 External Customers:




9 Location of Center:
                                  Building Name      Room Numbers    Square Feet
                                                                               Specialized Service Facility Analysis
                                                                                               Asset Listing
                                                                                        Calculation of Depreciation
                                                                                               Worksheet 4

Facility Name
Account Number
Fund Number


                                                                                                                              REVISED              DEPRECIATION AMOUNT
                                                    LOCATION                        ASSET     FY        ACQ       FED/PRIV.    ACQ        USEFUL
       EQ NO       DESCRIPTION                   BLDG N0  ROOM          DEPT         TYPE    ACQ        COST        AMT        COST        LIFE      FY       FY   FY    FY           Total

 1                                                                                                                                    0                                                       0
 2                                                                                                                                    0                                                       0
 3                                                                                                                                    0                                                       0
 4                                                                                                                                    0                                                       0
 5                                                                                                                                    0                                                       0
 6                                                                                                                                    0                                                       0
 7                                                                                                                                    0                                                       0
 8                                                                                                                                    0                                                       0
 9                                                                                                                                    0                                                       0
 10                                                                                                                                   0                                                       0
 11                                                                                                                                   0                                                       0
 12                                                                                                                                   0                                                       0
 13                                                                                                                                   0                                                       0
 14                                                                                                                                   0                                                       0
 15                                                                                                                                   0                                                       0
 16                                                                                                                                   0                                                       0
 17                                                                                                                                   0                                                       0
 18                                                                                                                                   0                                                       0
 19                                                                                                                                   0                                                       0
 20                                                                                                                                   0                                                       0
 21                                                                                                                                   0                                                       0
 22                                                                                                                                   0                                                       0
 23                                                                                                                                   0                                                       0
 24                                                                                                                                   0                                                       0
 25                                                                                                                                   0                                                       0


       TOTAL DEPRECIATION                                                                                                                                 0




      C:\Docstoc\Working\pdf\c39918cf-b0ee-44ca-8e8d-6b9575e8967c.xls Worksheet 4                                                                                             6/25/2012

								
To top