Addendum Rental Agreement Template - Excel

Document Sample
Addendum Rental Agreement Template - Excel Powered By Docstoc
					         2009 COSTING SPREADSHEET TEMPLATE                                                          5/5/2009

                                        TAFE DIVISION
                                         Project Title :
Use this template to calculate minimum price required for delivery
                   Please enter amounts in column D only
     These entries will automatically update the Budget 2008 Proforma

                                                   Enter Fund Type
                                                                                                   $
                                                            Natural
DIRECT PROJECT COSTS                                        Account                             Total
Salaries
Teaching Ordinary                                             70111
Sessional Teaching                                            70122
Author                                                        70572
Project Manager                                               70578
Administration Staff                                          70500
Casual - Agency Staff                                         70545
                                                                                                        -
On-Costs (Using FFS on-cost rate) *
Annual Leave Load/LSL                             1.34%       70902                                      -
Superannuation                                    9.40%       70910                                      -
Payroll Tax                                       5.89%       70924                                      -
LSL Expense                                       7.17%       70930                                      -
Workcover                                         1.20%       70948                                      -
                                                 25.00%                                                 -
Total Salaries                                                                                          -

Goods & Services

Teaching Materials                                            80140
Travel (within AUST)                                          81111
Travel (Overseas)                                             81211
Motor Vehicles                                                81320
Equipment                                                     82150
Consumables                                                   82599
Repair & Maintenance                                          83110
Communications                                                83514
Computing                                                     83932
Fees (External Consultants)                                   85519
Staff Development                                             86054
Promotional Expenses                                          86211
Other Payments                                                86309
Swinburne Press                                               89023



Total Goods & Services                                                                                  -

Total Direct Project Costs                                                                              -

Central Overheads **                                           Set           Calc.            Central
                                                              Rates          Rates           Overheads
Competitive Neutrality Infrastructure Charge                  0.0%           0.0%             #DIV/0!


Minimum Price                                                 0.0%           0.0%             #DIV/0!


* On-costs using Fee For Service on-cost rate

** Central overheads are listed as "Set Rates" and "Calc. Rates". The "Calc.
Rates" may be manually adjusted where agreement reached at divisional
level. The infrastructure contribution rate cannot be altered.
                          12/6/2010 11:54 AM D:\Docstoc\Working\pdf\f2057d00-9a61-4edc-9a62-c5cf652fd9b4.xls Costing Template
TAFE Budget Proforma 2009                                                  Account No:                                              5/5/2009
                                                 ***Please enter in ALL the coloured fields only***
PROGRAM TITLE:
CLIENT NAME:                                                                                   SCH: (If applicable)
ADDRESS:                                                                                           Tender or Grant
CONTACT NAME:                                                                               Contract/MOU Attached
START DATE:                                                                                 COMPLETION DATE :
CONSULTANT NAME:                                                                                 Acquittal required: YES           / NO
INCOME              Please use correct Income code for reporting purposes                                  $                        $
                    Carry Forward                                                                                                     $0        A
            Fund 39 FFS Government                                    60218
            Fund 39 Addendum Income                                   60260
            Fund 45 FFS IS Activity                                   60219
            Fund 46 FFS Department activity                           60219
            Fund 49 Short Courses                                     60228
            Fund 55 International Income - Projects                   60261
            Fund 56 International Income - Transnational              60252
            Fund 59 International Income - Students                   60240
            Fund 65 Fee Paying course Income                          60254
            Fund 85 Extraneous activity                               60399
                    Federal Grants                                    60399
                    Internal Funding                                  69020
                    OTTE Funding - current year                       69095

                                                 TOTAL INCOME                                                                             $0    B

                                             Central Support Costs Enter FUND Type

                   Competitive Neutrality Infrastructure Charge                0.00%                                 $0
                                                                                                                                          $0    C

            TOTAL FUNDS AVAILABLE for Salaries & Goods /Services D=(A+B-C)                                                                $0    D
EXPENDITURE
Salaries & Wages     Teaching Ordinary                   70111                                                   $0.00
                     Sessional Teaching                  70122                                                   $0.00
                     Author                              70572                                                   $0.00
                     Project Manager                     70578                                                   $0.00

                              Administration Staff                             70500                             $0.00
                              Casual - Agency Staff                            70545                             $0.00

                                                                             Sub-total                                                    $0
(including on costs)          On Costs (Using FFS on-cost rate)
                    1.34%     Annual Leave Load/LSL                           70902                              $0.00
                    9.40%     Superannuation                                  70910                              $0.00
                    5.89%     Payroll Tax                                     70924                              $0.00
                    7.17%     LSL Expense                                     70930                              $0.00
                    1.20%     Workcover                                       70948                              $0.00
                  25.00%                                                  Total Oncosts
                                                                            Sub-total                                                     $0
                                                       Total Salaries                                                                     $0    E
Goods & Services
                              Teaching Materials                               80140                             $0.00
                              Travel (within AUST)                             81111                             $0.00
                              Travel (Overseas)                                81211                             $0.00
                              Motor Vehicles                                   81320                             $0.00
                              Equipment                                        82150                             $0.00
                              Consumables                                      82599                             $0.00
                              Repair & Maintenance                             83110                             $0.00
                              Communications                                   83514                             $0.00
                              Computing                                        83932                             $0.00
                              Fees (External Consultants)                      85519                             $0.00
                              Staff Development                                86054                             $0.00
                              Promotional Expenses                             86211                             $0.00
                              Other Payments                                   86309                             $0.00
                              Swinburne Press                                  89023                             $0.00
                                                                      0          0                               $0.00
                                                                      0          0                               $0.00
                                                                      0          0                               $0.00
                              Total G & S                                                                                                 $0    F

                              TOTAL Salaries & GOODS & SERVICES                                     G= (E + F)                            $0    G
                               Balance must be zero (break even) or greater (profit)                H = ( D - G)                          $0    H
N.B Any Variation to Salary oncosts and Infrastructure Costs should be authorised by the Manager of TAFE Finances

                                                           Additional Invoice amount - levy exempt                        $
Authorised Signature(s):

*Date Audit to be arranged by Finance:




                                                                               12/6/2010 11:54 AM D:\Docstoc\Working\pdf\f2057d00-9a61-4edc-9a62-c5cf652fd9b4.xls Budget 2009
                                                                                                      Budget Import



Business Unit                          0                                   JAN     FEB       MAR        APR           MAY      JUN      JUL     AUG     SEP      OCT      NOV     DEC
Department to complete                 Income Split        % per month                                                                                                                      0.00%
Department to complete                 Goods & Services    % per month                                                                                                                      0.00%
                                  MECA Teaching Salaries   % per month     8.33%    8.33%     8.33%       8.33%        8.33%    8.33%   8.33%   8.33%    8.33%    8.33%   8.33%   8.33%   100.00%
                                  HEW Admin Salaries       % per month     8.33%    8.33%     8.33%       8.33%        8.33%    8.33%   8.33%   8.33%    8.33%    8.33%   8.33%   8.33%   100.00%

                                   70902   A/L Loading         1.34%
                                   70910   Super               9.40%
                                   70924   Payroll Tax         5.89%
                                   70930   LSL Expense         7.17%
                                   70948   Workcover           1.20%
                                                              25.00%
                                Natural Acct               Amount
Balance per month                  10001 010001                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Income                               0    00                           -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Comp Neutrality Infrs. Charge      89090 089090                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Teaching Ordinary                  70111 070111                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Sessional Teaching                 70122 070122                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Author                             70572 070572                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Project Manager                    70578 070578                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Administration Staff               70500 070500                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Casual - Agency Staff              70545 070545                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Annual Leave Load/LSL              70902 070902                        -     -           -     -            -           -        -        -       -                                 -        -      -
Superannuation                     70910 070910                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Payroll Tax                        70924 070924                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
LSL Expense                        70930 070930                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Workcover                          70948 070948                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Teaching Materials                 80140 080140                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Travel (within AUST)               81111 081111                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Travel (Overseas)                  81211 081211                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Motor Vehicles                     81320 081320                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Equipment                          82150 082150                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Consumables                        82599 082599                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Repair & Maintenance               83110 083110                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Communications                     83514 083514                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Computing                          83932 083932                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Fees (External Consultants)        85519 085519                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Staff Development                  86054 086054                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Promotional Expenses               86211 086211                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Other Payments                     86309 086309                        -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
Swinburne Press                    89023 089023                        -
                                0    0    00                           -     -           -     -            -           -        -        -       -       -        -        -       -        -      -
                                                                       -     -           -     -            -           -        -        -       -       -        -        -       -        -      -




                                                                                                         Page 3
FUND CODE CLASSIFICATION BY ACTIVITY - 2009                                                                           Updated: 25/11/08



Confidential                         Costing Pro-Forma by Fund

                                                                        Other Rec. Grant &                WELL Grant &
          Funds                      Recurrent                15
                                                                          contracts      39             contracts    39.1
                                      Profile Grant                   CAFÉ                             WELL Project
                                     Apprenticeship                   FYA
                                     Enrolment Fee                    Other Gov't contracts
                                     Interest                         Training packages
                                     Govt Tendered Profile            Curriculum
                                     Class Materials
                                     exempted as per
                                     Ministerial guidelines           Framing the Futures
                                                                      PETE, ANTA, DETYA
                                                                      AMES, CGEA
                                                                      AMEP
                                                                      Non Profit Organizations
University Corporate Service 89090                      29.70%                           15.0%                              12.00%
Competitive Neutrality       89091                       0.00%                             2.5%                              2.50%
Profit Levy                  89052                                                         10.0%                            10.00%
TAFE Levy                    89083                            0%                            7.5%                             0.50%
            Competitive Neutrality
             Infrastructure Charge                      29.70%                             35.0%                              25.0%

                                                                          Other Training &
          Funds                        SIS Consulting        45
                                                                           Industry 46
                                                                                                       SIS Short Course 49.1
                                     FFS Non Government               FFS Non Government               SIS Generated
                                     SIS Generated                    Department Generated
                                                                      Teaching industry (FFS)
                                                                      License
                                                                      Small Business

University Corporate Service 89090                      15.00%                             15.0%                            15.00%
Competitive Neutrality       89091                       2.50%                              2.5%                             2.50%
Profit Levy                 89052                       10.00%                             10.0%                            10.00%
TAFE Levy                   89083                           8%                              7.5%                             7.50%
          Competitive Neutrality
           Infrastructure Charge                         35.0%                             35.0%                              35.0%

          Funds                        Short Courses         49           International 55                 Transnational 56
                                     S/Courses Depts                           Projects                   International offshore
                                     COHS / NSITC                                                                projects



University Corporate Service 89090                      15.00%                             12.5%                            10.00%
Competitive Neutrality      89091                        2.50%                               0.0%                             0.00%
Profit Levy                 89052                       10.00%                             10.0%                            10.00%
TAFE Levy                   89083                           8%                             17.5%                             0.00%
          Competitive Neutrality
           Infrastructure Charge                         35.0%                             40.0%                              20.0%

          Funds                          International 59                International 59.1               International 59.2
                                              Students                         ELICOS                      Swinburne College
                                               Unilink
                                             Foundation


University Corporate Service 89090                      45.00%                             40.0%                            45.00%
Competitive Neutrality      89091                        0.00%                               0.0%                             0.00%
Profit Levy                  89052                      10.00%                             10.0%                            10.00%
TAFE Levy                    89083                          9%                              0.0%                             0.00%
            Competitive Neutrality
             Infrastructure Charge                       64.4%                               50%                                 55%

                                                                                                          Extraneous Carry
          Funds                           Full Fee      65             TAFE Extraneous         85
                                                                                                          forwards        84
                                     Grad Certificate                 Sale of Materials, Notes          Approved carry forwards
                                                                      Flowers,
                                                                      Cubbyhouse
                                                                      catering
                                                                      Sale of assets
                                                                      Childcare
                                                                      Training by product
                                                                       Rental/ Lease of Assets
                                                                      Vineyard
                                                                      VET & Pathways
                                                                      ** Note below
University Corporate Service 89090                      32.50%                            15.0%                               0.00%
Competitive Neutrality       89091                       2.50%                             2.5%                               0.00%
Profit Levy                  89052                      10.00%                             10.0%                              0.00%
TAFE Levy                    89083                          0%                              7.5%                              0.00%
            Competitive Neutrality
             Infrastructure Charge                       45.0%                             35.0%                                0.0%

**** Any verifications to the above rate is only by Levy Application Form




                                                              12/6/2010 11:54 AM D:\Docstoc\Working\pdf\f2057d00-9a61-4edc-9a62-c5cf652fd9b4.xls Fund Codes

				
DOCUMENT INFO
Description: Addendum Rental Agreement Template document sample