Docstoc

OCS_Budget_Calculator_2012

Document Sample
OCS_Budget_Calculator_2012 Powered By Docstoc
					INSTRUCTIONS, INFORMATION AND POINTS TO NOTE
Please note - while every effort has been made to test this spreadsheet, please do perform a sanity
check on the outputs and email ocs_pso@qut.edu.au if you find any errors or wish to provide
constructive feedback
TERMINOLOGY
ONCOSTS = Real salary expenses paid by the project account for superannuation, workers compensation, long
service leave provision, maternity leave provision, etc. QUT has standard rates for various appointment types. CRCs,
for example, may use a higher standard rate.
OVERHEADS = Indirect costs borne by QUT through provision of systems, infrastructure, IT, reputation and
branding, electricity, equipment, and more.
SALARY MARKUP = A % markup to be applied to the salary cost to arrive at a price to be charged to the client. A
manual override of the price to be charged for an individual is available.
COMMERCIAL MARKUP = A flat % markup to be applied to the total project cost, including any overheads and
contingencies. Essentially a profit/ sustainability markup to enable the research group/ school/ faculty to facilitate
ongoing research, provide research scholarships or pursue new commercial or competitive opportunities.

CONTINGENCY = a % markup on the total value of the project, included in the total personnel figure in the
client view of the project budget
PROJECT TYPE = Commercial Research projects must be able to meet the HERDC Definition of Research
(link below); if only a % of the project is research, it is required to be classified as Consultancy/ Outside
Work. The research % is captured for recording and reporting.
                                                                                  Link to Definition of research
REIMBURSABLE EXPENSES = expenses such as airfares to be reimbursed by the client where the contract
expressly states that no overhead charges will apply. In reality, processing of these expenses does incur
an indirect cost (QUT finance systems, corporate card charges, processing, etc), so overheads should be
included where possible.

COSTING AND PRICING
GUIDE TO MINIMUM CHARGE OUT RATE = Suggested minimum hourly rate (before overheads) that personnel
should be charged out at to comply with competitive neutrality requirements below.
Competitive Neutrality
QUT is required to comply with the principles of Competitive Neutrality (link to policy)
While cost is an important consideration in pricing, pricing policies should
also fully reflect additional market and competitive considerations as well as
the need to achieve a rate of return on equity invested.
“Government businesses should not enjoy any net competitive advantage
 over their competitors simply as a result of their public sector ownership.”
“Under full cost pricing, indirect costs and overheads are fully absorbed
 into the costs of the activities.”
Termination/ Severance Pay
Please note that when you employ fixed term staff on a project, they may be eligible for or be
carrying a termination pay liability from previous contracts. Please refer to the QUT Enterprise
Bargaining Agreements for termination costs applicable to staff on fixed term appointments.
Your project should allocate a pro rata allowance towards this payment
                                                                                                Link to Agreements
  Period of continuous service - Professional & Academic Fixed Term @ 01/12/2011
  Up to the completion of 2 years - 4 weeks
  Over 2 years and up to the completion of 3 years - 6 weeks
  Over 3 years and up to the completion of 4 years - 7 weeks
  Over 4 years - 8 weeks


LINKS TO RELEVANT POLICIES
Financial Procedures Ch 2(H) - Outside Work – Indirect Cost Charges and Surplus Accounts
Financial Procedures Ch 3(C) - Travel Approval and Bookings (inc link to allowances)
Financial Procedures Ch 3(D) - Hospitality and Catering
Financial Procedures Ch 4(D) - Engagement of Consultants
MOPP Chapter B/7.9 Policy on Outside employment - professional staff
MOPP Chapter D/ 7.1 Policy on Outside work - academic staff
MOPP Chapter D/2.6 QUT Code of Conduct for Research
MOPP Chapter D/3.1 Intellectual property policy
MOPP Chapter G/5.5 Travel Policy
MOPP Chapter G/8.1 User Charging Policy 8.1.4 (c)
QUT User Charges
Schedule of Authorities & Delegations - scroll to Contracts and Agreements - for WHO CAN SIGN


GUIDE TO DISTRIBUTION OF PROJECT PROFIT
Please note - this is a guide - refer to Faculty specific policies on these matters.
Overheads are treated AUTOMATICALLY - and disbursed to the account nominated by the Faculty in the central
finance system. Overheads are calculated on gross invoice value.
An adjusting journal is processed to external income lines at the end of each month.
Academic salary
Commercial activities undertaken in-load return academic salary to salary source
Other staff costs
Use of other ongoing personnel, outside the scope of normal assigned duties,
return salary to the salary source account
Operating costs
Costs for staff appointed to the project, consumables and equipment, maintenance to be
charged to the project account where possible. Expenses not captured in the project
account to be reimbursed to the appropriate account (eg. equipment maintenance).
Consultant Fee
If approved, academic may receive a consultant fee into their surplus account.
Project surplus or profit is distributed as agreed by Head of School/ ADR/ Executive Dean (faculty specific)
after all payments are received and all other expenses have been recognised.
Other project profit
Eg. Seed funding for business development to be allocated to appropriate account with approval as above.
Fully costed project, ex
Contents - Click to jump to section

Terminology

Costing and Pricing

Links to Relevant Policies


Guide to Distribution of Project Surplus




Top of page




Top of page
Top of page




Top of page
Fully costed project, excl GST
OCS BUDGET CALCULATOR - BASIC INSTRUCTIONS

Complete all relevant details in "Budget Input - CI" (blue text cells and green drop down selections)
Start with Faculty, School and Dates.

Then start entering personnel details to see how the sheet populates and assists with cost calculations.
Use comments and guides to inform decisions.

  Note - if the sheet feels "BUSY" note that the information on the right is summarised and aligned
  with the cells it relates to and it should provide valuable context to the input.
Use "Planner" Sheet for initial calcualtions if required
See "Information" Sheet for additional information and links

"Budget Summary - Approval" Sheet populates and is formatted for Head of School/ ADR approval
"Budget - Client View" Sheet populates and is formatted for presentation to the Client

Option - Copy any of the sheets to adjust to client preferred view to preserve original calculations.

* Enter Project Summary below for display on approval and client view budgets

Project Summary - short - will appear on Approval and Client versions of Budget




Please note - while every effort has been made to test this spreadsheet, please do perform a sanity check on
the outputs and email ocs_pso@qut.edu.au if you find any errors or wish to provide constructive feedback
Fully costed proj
Fully costed project, excl GST
        Start adding information - it all starts to make sense once you see the data flowing through the sheet!        This sheet prints on 3 pages
        Feedback and error reporting to ocs_pso@qut.edu.au                                           ENTER PROJECT SUMMARY ON "Start Here" Sheet
        EXTERNAL PROJECT BUDGET PREPARATION
                                                                                                                                  Fields marked with * mandatory
        Project Title
        Chief Investigator/
        Project Director
        Client Name
        Lead Faculty/ Institute *                                                Other Faculty/ Institute
        School/Centre                                                               Other School/Centre
        Project Type                                                             Commercial research projects must meet           the HERDC Definition of research
        For multi-year/ multi-phase projects, please use Multi Template.
        Project Start Date *                                                                        Project End Date * .
        # Weeks                                      0.00                                      Time before EBA increase           100%

        Salary oncosts                             0.00%    ONLY CHANGE IF DIFFERENT TO QUT STANDARD RATES
        Contingency                                0.00%    SUGGEST MINIMUM OF 5%
        Salary markup                              0.00%    MARKUP ON SALARY COSTS TO SUIT MARKET COMMERCIAL RATES - ALTERNATIVE:
        Profit mark up                             0.00%                                      USE MANUAL CHARGEOUT RATE IN G44 & BELOW
        Overhead - Salaries                          25%    FACULTY SPECIFIC
        Overhead - Other                             25%    FACULTY SPECIFIC
        Contract Price inc GST                                                    $ for personnel + direct expenses after GST, overheads, contingency:

        Personnel Details and Time Allocation:                                  Position                                                         Units
                                                            % Time Out of                    Contract       Hourly Rate    Hourly Rate
                                                                                Level or                                                       (Hour, Day,
                                                                load                          Type          IF MANUAL      ex oncosts         F/night, Year)
        Name                            Role                                   "Manual"
x   *
x
x
x
x
x
x
x


                                                                                 Hourly
                                                                                               Guide to      OPTIONAL:
                                                             Total Direct       CHARGE                                   Total Project Total Project
                                       Hourly rate                              OUT rate       Minimum        Manual
          Personnel Costs                                     Personnel                                                Personnel Price Personnel
                                         (current)                             using salary recommended       Hourly
        and Charge Out Rates                                   COST for                       charge out               (Charge) before Price (Charge)
                                    including oncosts                            markup                     CHARGE OUT
                                                                Project          entered         rate                     overheads    inc overheads
                                                                                                               rate
                                                                                  above
x   *
x
x
x
x
x
x
x


        Severance Pay Allocation
        Personnel Details                 Weeks                  Cost          Charge out                     Manual         Charge          Inc overheads
        Name
        Name
        Name

        Sub-Totals Personnel - COST                                     0.00                                   PRICE                  0.00               0.00
                                                                     Enter Direct
                                                                                         Unit                     Charge out       Total Price      Total Price
               General Expenditure                                      Cost if                      Number of
 Admin                                                                                hours, days,
  Use                                                                different to                                    rate            before          including
               (Overtype descriptions - Do Not Insert Rows)                             each etc       Units
                                                                      charge out       (Ref only)                 Price/unit       overheads        overheads
                                                                         rate
Equipment    Equipment (Scientific and medical)
Equipment    Equipment (IT)
Equipment Provision for maintenance and repairs

             G
Consumables eneral supplies

Printing etc Printing, report production

Rental, Hire   QUT Laboratory usage/ bench fee
Rental, Hire   Hire of facilities & services (inc car hire)
Travel & Dev   International Travel (eg airfares,accom,food)
Travel & Dev   Domestic Travel (inc airfare, taxis, accom)
Travel & DevCatering and Hospitality
Travel & DevTraining or Other (describe)
            E
Miscellaneous xternal Consultants

            F
Miscellaneous reight, courier and postage

            O
Miscellaneous ther (describe)

            O
Miscellaneous ther (describe)

            Reimbursable expenses - Overheads not applicable:                                         # Units       Price                   0.00            0.00
            [Describe]
            [Describe]
               [Describe]
               [Describe]

               Sub Totals General COSTS                                       0.00                                  Price                   0.00            0.00

               SUB TOTAL                              Costs                   0.00                                  Price                   0.00            0.00

               Contingency                                     0%                     Note: all of the profit and all of                                    0.00
                                                                                      the contingency will be bundled
               Commercial markup                               0% [Profit]            into the Personnel line in the                                        0.00
                                                                                     " Budget - Client View" sheet
               SUB TOTAL                                                             UNLESS THERE ARE NO PERSONNEL -                                        0.00
                                                                                     IN WHICH CASE, THESE WILL BE ADDED
               GST *                         Yes                                     TO THE EXPENSE ITEMS                                                  $0.00

               TOTAL PRICE TO CLIENT                                                                                                                       $0.00


                                                       Rate
               Overheads                                       25%                  Show overheads to client? No                                            0.00

                                                                                          Choose % split or $ split                         OFFICE USE
               Distribution of Surplus Balance                               $0.00     % split  $ from %         $ split             OLD_BEE Auto           0.00
               [Name account]           [Account code]                               %                       $                     OLD_BEE Manual           0.00
               [Name account]           [Account code]                               %                       $
               [Name account]           [Account code]                               %                       $
               [Name account]           [Account code]                               %                       $
               [Name account]           [Account code]                               %                       $

               Check Totals - Surplus Unallocated                                        100.00%           0.00             0.00
Commercial projects do not normally include inkind contributions. If this project involves inkind contribution or
cash contributions from QUT they must be described and fully costed below.
Approval for inkind or cash contributions is at the discretion of the appropriate delegate in the Faculty
and may or may not be granted. Please discuss if you need to provide information to support your case.
Value of inkind contribution should be at commercial rates appropriate to project

Do you want to show in-kind to client?            Yes             NOTE: Client will see Charge Out Price, not Cost

Personnel Details and Time Allocation:                          Position                                                     Units
                                             % Time Out of                   Contract      Hourly Rate     Hourly Rate
                                                                Level or                                                   (Hour, Day,
                                                 load                         Type         IF MANUAL       ex oncosts     F/night, Year)
Name                        Role                               "Manual"




                                                                Hourly                      OPTIONAL:
                                              Total Direct                     Guide to                               Total Project
                            Hourly rate                        CHARGE                        Manual    Total Project
                                                                               Minimum
 Personnel Costs and                           Personnel       OUT rate                                                Personnel
                             (current)                                      recommended      Hourly   Personnel Price
     Charge outs                                COST for        using         charge out                                Price inc
                            inc oncosts                                                    CHARGE OUT inc markups
                                                 Project        salary           rate                                  overheads
                                                                                              rate
                                                               markup




Sub-Totals Personnel COST                               0.00                                  Price                0.00              0.00

Descriptions of other in-kind                  Cost/Unit       Price/Unit     # Units       Total Price
[Describe]                                                                                          0.00
[Describe]                                                                                          0.00
[Describe]                                                                                          0.00
[Describe]                                                                                          0.00

Other in-kind expenses COST                             0.00                       Price           0.00

Total QUT Contribution                                                                                                             $0.00


Fully costed project, excluding GST                                                                                                $0.00
       This sheet prints on 3 pages    INFORMATION
CT SUMMARY ON "Start Here" Sheet       Most cells in this worksheet are protected
                                       Add information to blue cells
    Fields marked with * mandatory     Choose from drop down menus in green cells
                                       Beige squares update automatically - no input required


                                       ONCOSTS = Real salary expenses paid by the project account for superannuation,                                                       ScienceandTechnology
                                       workers compensation, long service leave provision, maternity leave provision, etc.
                                       OVERHEADS = Indirect costs borne by QUT through systems, infrastructure,
    the HERDC Definition of research   electricity, equipment, IT, branding, reputation and more.
                                       =IF(AND(C8='[TEM_BGT_OCS_20120203.xlsx]Internal Use - Admin'!A10,C10='[TEM_BGT_OCS_20120203.xlsx]Internal Use - Admin'!A46),60%,0)




                                       Fraction of project before next advertised QUT pay increase - FYI
                                       Project # of weeks - to assist with other data entry below
                                       ONLY if funding scheme stipulates a specific salary oncost allowance (eg. CRC)

                                       If selected, will be in addition to QUT's standard overhead rates

                                       If selected, will be applied to the total project value, including the overheads.
                                       This is a basic profit multiplier.                             See below re: pricing
                                0.00   Use this as an aid if trying to match budget to funds available

                                       If number of units is a % of time, select Units = Year and enter fraction of time in
                          Number
                                       Number of Units; eg 50% = 0.5, 10% = 0.1.         (Note: 20% = 1 day a week = 0.2)
                          of Units
                                       Project start and end dates will be factored into calculations for project costs
                                       For reference: Cell C13 shows number of weeks in project

                                       If up to 6 additional staff are required UNHIDE Rows 28-33 and again in the
                                       beige section directly below at Rows 50-55
                                       If up to 12 additional staff are required also UNHIDE Rows 35-40 and again in the
                                       beige section directly below at Rows 57-62

                                       IF(ISBLANK(B24),"",(1-(EBA_Inc*$H$13)+EBA_Inc)*IF(I24="year",J24*($C$13/52.4)*(72.5*365.25/14)*C46,IF(I24="Day",J24*7.25*C46,IF(
                                                               GUIDE TO CHARGE OUT RATES OR PRICE
                                       The pricing policy should include recovery of all costs of producing the good / service. These include:
                                       The actual cost of the good / service; Direct costs (see G/8.1.5(a) ); Indirect costs (see G/8.1.5(b) ); A profit
                                       margin in line with the market rate.
                                       QUT is required to adhere to the requirements and principles of the National Competition Policy in terms of
                                       competitive neutrality through full cost pricing of the good / service offered on a competitive basis. Inclusion of
                                       all costs will ensure the price is comparable to external providers of a similar good / service.
                                       MOPP Chapter G/8.1 User Charging Policy 8.1.4 (c)
                                         QUT is required to comply with the principles of Competitive Neutrality
                                       “Government businesses should not enjoy any net competitive advantage
                                        over their competitors simply as a result of their public sector ownership.”
                                       “Under full cost pricing, indirect costs and overheads are fully absorbed
                                        into the costs of the activities.”



                                                Please refer to Faculty HR to check prior appointments for fixed term staff
                                                            Professional & Academic Fixed Term @ 01/12/2011
                                            Period of continuous service                            Severance pay
                                            Up to the completion of 2 years                         4 weeks' pay
                                            Over 2 years and up to the completion of 3 years        6 weeks' pay
                                            Over 3 years and up to the completion of 4 years        7 weeks' pay
                                            Over 4 years                                            8 weeks' pay
                                0.00   Please refer to the QUT Enterprise Bargaining Agreements for termination costs
                                       applicable to staff on fixed term appointments.          Link to Agreements
       Useful Links for General Expenditure

       MOPP Chapter G/8.1 User Charging Policy 8.1.4 (c)           AEMF Charges                 0
       QUT IT Service Catalogue                                                                 0
                                                                                                0
                                                                                                0
       QUT Printing Services                                                                    0
       QUT User Charges                                            QUT Room Hire Rates          0
       Travel Policy - MOPP Chapter G/5.5                          Travel Allowance Rates       0
       Financial Procedures 3(C)-Travel Approval & Bookings                                     0
       QUT Fleet Vehicles                                          Taxi rate calculator         0
       Financial Procedures 3(D)-Hospitality and Catering                                       0
                                                                                                0
       Financial Procedures 4(D)-Engagement of Consultants                                      0
       QUT mail room                                               QUT Teleconferencing         0
                                                                                                0
                                                                                                0

       Faculty Specific Instructions:                                                           0
                                                                                                0
                                                                                                0
                                                                                                0

0.00


0.00




0.00


       Policy on Outside work - academic staff - MOPP Chapter D/ 7.1
       Outside Work – Indirect Cost Charges and Surplus Accounts
       GUIDE TO DISBURSEMENT OF PROJECT FUNDS - SEE LINKS ABOVE
           This is a guide only - please refer to Faculty specific policies on these matters.
       Overheads are treated AUTOMATICALLY
       Academic salary
       Commercial activities undertaken in-load return academic salary to salary source
       Other staff costs
       Use of other ongoing personnel, outside the scope of normal assigned duties,
       return salary to the salary source account
       Operating costs
       Costs for staff appointed to the project, consumables and equipment
       maintenance to be charged to the project account where possible.
           Expenses not captured in the project account to be reimbursed to
           the appropriate account (eg. equipment maintenance).
           Consultant Fee
           If approved, academic may receive a consultant fee into their surplus account.
           Project surplus or profit is distributed as agreed by Head of School/
           ADR/ Executive Dean (faculty specific) after all payments are received and all
           other expenses have been recognised.
           Other project profit
           Eg. Seed funding for business development to be allocated to appropriate account with
Number
           approval as above.
of Units
4="year",J24*($C$13/52.4)*(72.5*365.25/14)*C46,IF(I24="Day",J24*7.25*C46,IF(I24="Fortnight",J24*72.5*C46,J24*C46))))
PROJECT BUDGET SUMMARY
Project Title
Chief Investigator/ PM
Client Name
Faculty
School/Centre/ Domain
Project Start Date
Project End Date                                                Project Type

                                  % Time                                         Charge Out
                                                Direct Costs
                                 out of load                                   inc overheads
Personnel




Severance Pay Allowance
Sub Total Personnel                                     $0.00                          $0.00
Other
Equipment (Scientific and medical)
Equipment (IT)
Provision for maintenance and repairs
General supplies
Printing, report production
QUT Laboratory usage/ bench fee
Hire of facilities & services (inc car hire)
International Travel (eg airfares,accom,food)
Domestic Travel (inc airfare, taxis, accom)
Catering and Hospitality
Training or Other (describe)
External Consultants
Freight, courier and postage
Other (describe)
Other (describe)
Sub Total Other Expenses                                $0.00                          $0.00
Reimbursable Expenses
[Describe]
[Describe]
[Describe]
[Describe]
Sub Total Reimbursable Expenses                         $0.00                          $0.00

Sub Total                                               $0.00                          $0.00
Contingency                                                                            $0.00
Commercial markup (profit)                                                             $0.00
Sub Total ex GST                                                                       $0.00
GST                                                                                    $0.00
Total Cost to Client inc GST                                                           $0.00

Summary
Direct Costs                                            $0.00
Faculty Overheads                                       $0.00
Profit (Distribution in table below)                    $0.00
In-Kind Contribution (Details below)                    $0.00
SEE BELOW FOR LINKS TO RELEVANT MOPP & FINANCIAL PROCEDURES ON OUTSIDE WORK & SURPLUS
Distribution of Profit                                         $0.00        % split            $ from %                 $ split
[Name account]                   [Account code]                        %                                          $
[Name account]                   [Account code]                        %                                          $
[Name account]                   [Account code]                        %                                          $
[Name account]                   [Account code]                        %                                          $
[Name account]                   [Account code]                        %                                          $
Check Totals - Surplus Unallocated                                              100.00%                   0.00                    0.00




In Kind Details

        Personnel Details             % Time           Units                # Units           Total Cost              Total Price
                                     out of load                                              including                including
                                                                                               oncosts                Overheads




Total                                                                                     $               -       $               -

Descriptions of other in-kind                         Cost/Unit            Price/Unit          # Units                Total Cost
[Describe]                                                                                                                            0
[Describe]                                                                                                                            0
[Describe]                                                                                                                            0
[Describe]                                                                                                                            0

Other in-kind expenses                       Cost $             -                                        Price $                  -

Total                                        Cost $             -                                        Price $                  -

Fully costed project, excluding GST                                                                               $               -

Project Summary - Enter on "Start Here" sheet
                                                                                                              0




LINKS TO RELEVANT POLICIES
Schedule of Authorities & Delegations - scroll to Contracts and Agreements - for WHO CAN SIGN
Policy on Outside work - academic staff - MOPP Chapter D/ 7.1
QUT Code of Conduct for Research - MOPP Chapter D/2.6
Intellectual property policy - MOPP Chapter D/3.1
Policy on Outside employment - professional staff - MOPP Chapter B/7.9
Financial Procedures Ch 2(H) - Outside Work – Indirect Cost Charges and Surplus Accounts
This is an unprotected worksheet



See links to relevant policies at end of page




If up to 6 additional staff were added UNHIDE Rows 18-23
If up to 12 additional staff are added UNHIDE Rows 25-30




Hide zero rows if required
QUT PROJECT BUDGET SUMMARY                                                This is an unprotected worksheet

Project Title
Client Name
QUT Project Director
QUT Project Group
Project Start Date
Project End Date


ITEM                                              AMOUNT    TOTALS
 Personnel                                          $0.00     $0.00       Hide rows or overtype descriptions as required
 Other
  Equipment (Scientific and medical)
  Equipment (IT)
  Provision for maintenance and repairs
  General supplies
  Printing, report production
  QUT Laboratory usage/ bench fee
  Hire of facilities & services (inc car hire)
  International Travel (eg airfares,accom,food)
  Domestic Travel (inc airfare, taxis, accom)
  Catering and Hospitality
  Training or Other (describe)
  External Consultants
  Freight, courier and postage
  Other (describe)
  Other (describe)
  Sub-Total Other
Reimbursable Supplies
  [Describe]
  [Describe]
  [Describe]
  [Describe]
  Sub-Total Expenses


SUB TOTAL EX GST                                             $0.00
GST                                                          $0.00
TOTAL INC GST                                                $0.00




Project Summary:
                                                                      0
Free text worksheet - no automatic data flow to other sheets - adapt to suit and to assist with planning process
Copy and paste personnel details into Budget Input - CI if required

Time Commitment Plan        Stage 1                                                Stage 2                                          Total
                          Task 1        Task 2        Task 3        Task 4       Task 1        Task 2        Task 3        Task 4
Task Description

Personnel Details         Enter days required per person per task                Enter days required per person per task            Days
                                                                                                                                            0
                                                                                                                                            0
                                                                                                                                            0
                                                                                                                                            0
                                                                                                                                            0
                                                                                                                                            0
                                                                                                                                            0
                                                                                                                                            0
                                                                                                                                            0
                                                                                                                                            0
                                                                                                                                            0
                                                                                                                                            0
                                                                                                                                            0
                                                                                                                                            0
                                                                                                                                            0
                                                                                                                                            0
                                                                                                                                            0
                                                                                                                                            0
                                                                                                                                            0
                                                                                                                                            0

Other expenses per task
This is an unprotected worksheet
                 Academic
AcademicLevels   Classification   Step Salary Year Salary FN Daily         Hourly     Casual hrly
MANUAL
LEVA1            LEVA                1    54,988.38   2,107.70    210.77   29.07172    36.339593
LEVA2                                2    58,129.27   2,228.08   222.808   30.73214    38.415107
LEVA3                                3    61,267.03   2,348.36   234.836   32.39117    40.488896
LEVA4                                4    64,416.27   2,469.06   246.906     34.056    42.569927
LEVA5                                5    66,961.54   2,566.63   256.663   35.40179    44.252166
LEVA6                                6    69,518.03   2,664.62   266.462   36.75338    45.941645
LEVA7                                7    72,063.30   2,762.17   276.217    38.0989    47.623539
LEVA8                                8    74,614.05   2,859.95   285.995   39.44759    49.309398
LEVB1            LEVB                1    78,542.05   3,010.50    301.05   41.52414    51.905083
LEVB2                                2    81,496.66   3,123.76   312.376   43.08634    53.857839
LEVB3                                3    84,436.92   3,236.45   323.645   44.64069    55.800766
LEVB4                                4    87,388.67   3,349.60    334.96   46.20138    57.751625
LEVB5                                5    90,328.93   3,462.29   346.229   47.75572    59.694553
LEVB6                                6    93,277.80   3,575.32   357.532   49.31476    61.643343
LEVC1            LEVC                1    96,218.06   3,688.02   368.802   50.86924    63.586443
LEVC2                                2    99,169.54   3,801.15   380.115   52.42966    65.536957
LEVC3                                3   102,104.33   3,913.64   391.364   53.98124    67.476436
LEVC4                                4   105,056.07   4,026.78   402.678   55.54179    69.427122
LEVC5                                5   107,993.46   4,139.37   413.937   57.09476    71.368326
LEVC6                                6   110,959.03   4,253.05   425.305   58.66276    73.328323
LEVD1            LEVD                1   115,849.47   4,440.49   444.049   61.24814    76.560041
LEVD2                                2   119,777.21   4,591.05   459.105   63.32483    79.155899
LEVD3                                3   123,708.34   4,741.72   474.172   65.40303    81.753653
LEVD4                                4   127,638.96   4,892.39   489.239   67.48124    84.351407
LEVE1            LEVE                1   149,240.10   5,720.35   572.035   78.90138    98.626555
HEW3.1           HEW3                1    44,133.15   1,691.61              23.3326      29.1657
HEW3.2                               2    45,349.17   1,738.22              23.9754      29.9693
HEW3.3                               3    46,559.98   1,784.63              24.6156      30.7695
HEW3.4                               4    47,787.22   1,831.67              25.2644      31.5805
HEW3.5                               5    49,090.90   1,881.64              25.9537      32.4421
HEW4.1           HEW4                1    50,400.32   1,931.83              26.6459      33.3074
HEW4.2                               2    51,709.74   1,982.02              27.3382      34.1728
HEW4.3                               3    53,024.64   2,032.42              28.0334      35.0417
HEW5.1           HEW5                1    54,782.54   2,099.81              28.9629      36.2036
HEW5.2                               2    56,546.17   2,167.40              29.8952        37.369
HEW5.3                               3    58,289.98   2,234.24              30.8171      38.5214
HEW5.4                               4    60,039.53   2,301.31              31.7422      39.6778
HEW5.5                               5    61,789.08   2,368.37              32.6672        40.834
HEW6.1           HEW6                1    63,549.84   2,435.85              33.5979      41.9974
HEW6.2                               2    65,305.13   2,503.13              34.5259      43.1574
HEW6.3                               3    67,048.94   2,569.98               35.448         44.31
HEW6.4                               4    68,809.96   2,637.48               36.379      45.4738
HEW7.1           HEW7                1    70,119.12   2,687.66              37.0712        46.339
HEW7.2                               2    72,311.67   2,771.70              38.2303      47.7879
HEW7.3                               3    74,507.08   2,855.84              39.3909      49.2386
HEW7.4                               4    76,702.23   2,939.98              40.5514      50.6893
HEW8.1           HEW8                1    78,875.21   3,023.27              41.7003      52.1253
HEW8.2            2 81,508.14    3,124.19   43.0923   53.8653
HEW8.3            3 84,137.68    3,224.99   44.4826   55.6033
HEW8.4            4 86,770.87    3,325.91   45.8746   57.3433
HEW8.5            5 89,400.41    3,426.70   47.2648    59.081
HEW9.1    HEW9    1 92,030.47    3,527.51   48.6553   60.8191
HEW9.2            2 94,225.89    3,611.67   49.8161   62.2702
HEW9.3            3 96,412.69    3,695.48   50.9721   63.7152
HEW10.1   HEW10   1 98,605.23    3,779.52   52.1313   65.1641
HEW10.2           2 102,499.32   3,928.78   54.1901   67.7376
HEW10.3           3 106,393.41   4,078.05    56.249   70.3112
HEW10.4           4 110,287.49   4,227.31   58.3077   72.8847
Fully costed project, excl GST
1.249998 YesNo
         Yes                               Inserting new salary rates each
         No                                year: Insert in B2 for academic
                                           levels. Immediately underneath.
        WorkingPeriods                     Delete blank rows by highlighting
        Hour                               cells in rows A-G (not entire row)
        Day                                and shift cells up. Beneath this
        Fortnight                          table insert professional salaries
        Year                               from web. Delete headings
        ContractLength
        < 1 year
        >= 1 year                          InternalConsultants
        Casual                             Lecturer        $150.00
                                           Senior Lecturer $180.00
                                           Head of School $225.00
        In-load
        Out of load                        Cost
                                           Price

        Delete rows HEC15.1 to Hew2.2      RecommendedCharges
        moving cells up. Also delete       Lecturer         150
        column headings for professional   Senior Lecturer 1820
        classification                     Head of School   225
                                           Technician        80
                                           Other
Faculties                                          Commercial Research    Consultancy
Business                                                             0.16          0.25
Caboolture                                                           0.16          0.25
Creative Industries                                                  0.16          0.40
Education                                                            0.16          0.40
Health                                                               0.16          0.25
Law and Justice                                                      0.35          0.35
Science and Engineering                                              0.16          0.25
OLD_Science and Technology                                           0.16          0.25
OLD_Built Environment and Engineering                                0.16          0.25
Institute of Health and Biomedical Innovation                        0.16          0.25
Institute for Future Environments                                    0.16          0.25
Sugar Research                                                       0.16          0.25
Institute for Creative Industries and Innovation                     0.16          0.25
Institute for Sustainable Resources                                  0.16          0.25
Information Security Institute                                       0.16          0.25

Markup figures
Faculties                                          Commercial Research   Consultancy
Business                                                          0.1905       0.3333
Creative Industries                                               0.1905       0.6667
Education                                                         0.1905       0.6667
Health                                                            0.1905       0.3333
Law and Justice                                                   0.5385       0.5385
Science and Engineering                                           0.1905       0.3333
OLD_IT, Mathematics and Science                                   0.1905       0.3333
OLD_Built Environment and Engineering                             0.1905       0.3333
Institute of Health and Biomedical Innovation                     0.1905       0.3333
Institute for Creative Industries and Innovation                  0.1905       0.3333
Institute for Sustainable Resources                               0.1905       0.3333
Information Security Institute                                    0.1905       0.3333
Institute for Future Environments                                 0.1905       0.3333
Sugar Research                                                    0.1905       0.3333

GST                                                                  10%

Salary oncosts
contract < 1 year                                               0.185775
contract >= 1 year                                              0.269575
Casual                                                          0.146775
Annual pay increase                                                  0.04
Annual pay date increase                                      11/30/2012 NOTE:
BEE salary oncost                                                     0.6

Research Options
Commercial Research
Consultancy
CRC

Chargeout rates
Tech ($80/hr)      80
A,B ($120/hr)     120
  C ($180/hr)     180
D-E ($225/hr)     225


      Round
          1         1
         10        10
        100       100
       1000      1000
      10000     10000
Fully costed project, excl GST
CRC           BuiltEnvironmentandEngineering               Faculty
       0.00   Business                                     Design
       0.00   Caboolture                                   Engineering Systems
       0.00   CreativeIndustries                           Urban Development
       0.00   Education
       0.00   Health
       0.00   LawandJustice
       0.00   ScienceandTechnology
       0.00   ScienceandEngineering
       0.00
       0.00   ScienceandTechnology
       0.00                                                and correpsonding names "Health" etc
       0.00   If new schools or faculties are created
       0.00   add them somewhere in the middle of
       0.00   the faculty list on the left as well as in
       0.00   the school columns to the right. Then
              the worksheet should update properly.




              To update salary scales each year go to
              the tab "Salaries" and follow directions
              there. It is simply updating the table
              from the web link and then pushing the
              last two columns of the second table to
              the right as directed




              If updating formulae, Excel is being
              weird and only referencing properly if
              the first cell of a merged cell is
              referenced not the whole merged cell.
              Which means when clicking on cells to
              reference you may need to manually
              delete the merged reference and leave
              the first part. E.g. If the reference is
              F19:G19 change to F19




LEVA
LEVB
LEVC
LEVD
LEVE
                   Faculty                                       Faculty    Faculty
                   Accountancy                                   Caboolture Creative Writing, Drama, Film & TV
                   Advertising, Marketing and Public Relations              Fashion, Journalism, Media & Comms
                   Economics and Finance                                    Art, Design, Dance, Music, Sound
                   Management
                   QUT Graduate School of Business
                   Corporate Education




sonding names "Health" etc
Faculty                                         Faculty
Early Childhood                                 Exercise and Nutrition Sciences
Cultural and Language Studies in Education      Nursing
Learning and Professional Studies               Optometry and Vision Science
Mathematics, Science and Technology Education   Psychology and Counselling
                                                CARRS-Q
                                                Public Health and Social Work
                                                Social Work and Human Services
                                                Clinical Sciences
                                                Biomedical Sciences
Faculty                           Faculty
Law                               Biogeoscience
Justice                           Cell and Molecular Biosciences
Legal Practice Unit               Chemistry
Law and Justice Research Centre   Computer Science
                                  Information Systems
                                  Mathematical Sciences
                                  Medical Radiation Sciences
                                  Medical Sciences
                                  Pharmacy
                                  Physics
Faculty
Chemistry, Physics, & Mechanical Engineering
Civil Engineering and the Built Environment
Earth, Environmental & Biological Sciences
Electrical Engineering & Computer Science
Information Systems
Mathematical Science

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:10
posted:9/17/2012
language:Unknown
pages:55