Spreadsheet: 327990d1403757103-index-match-retrieve-data-across-unique-sheets-with-unique-column-identifiers-budget-example
Sheet: 7553

 |  | Business unit |  | 7553 |  |  | [NAME] number
 |  |  |  |  |  |  | IF(ISNUMBER)
 |  | Branch |  | 733C |  |  | Mapping
 |  |  |  |  |  |  | Mapping
Mapping
 | Biodiversity & Fire Information
 |  | This control sheet was last updated on: |  | 2014-05-09 00:00:00
 |  | Highlighted cells require updating
 |  |  |  |  |  |  |  |  |  | Business Plan and Oracle Code alignments (budgeted items) |  |  |  |  |  |  |  | Jul | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Total
 |  | APPROPRIATION EXPENDITURE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check FTE Balance (must balance to 0) | Monthly Cashflows |  |  |  |  |  |  |  |  |  |  |  |  |  | Check Phasing (must balance to 0)
 |  | Salary positions |  |  |  |  |  |  |  | Budgeted FTE | Budgeted FTE | Budgeted FTE | Budgeted FTE | Budgeted FTE | Budgeted FTE | TOTAL BUDGETED FTE |  | Jul | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Total
 |  |  |  |  |  |  |  |  |  | 23829 / 001 | 23943 / 222 | xxxx / xxx | xxxx / xxx | xxxx / xxx | xxxx / xxx
 |  | Name | Account Code | Current Budgeted FTE | Start Date | End Date |  | Effective FTE
 |  | [NAME] |  |  |  |  |  |  |  | 1
 |  | FionaHamilton |  | 0.8 |  |  |  |  |  |  | 0.8
 |  | LaurieFerns |  |  |  |  |  |  |  | 1
 |  | NevilAmos |  | 1 |  |  |  |  |  |  | 1 |  |  |  |  | 1
 |  | Select Name
 |  | Select Name
 |  | Select Name
 |  | Select Name
 |  | Select Name
 |  | Select Name
 |  | Select Name
 |  | Expand to add additional staff
Total FTE:
 |  | Operating Expenditure*
 |  |  |  |  |  |  | Budgeted $ | Requested  but not budgeted $ |  | Budget $ | Budget $ | Budget $ | Budget $ | Budget $ | Budget $ | TOTAL BUDGET $
 |  | Basic (standard formula):
 |  | - General Operating | 6572
 |  | - General Operating | 6572
 |  | - General Operating | 6572
 |  | - General Operating | 6572
 |  | - General Operating | 6572
 |  | - General Operating | 8037/8
TOTAL Basic: |  | TOTAL Basic:
 |  | Supplies and services:
 |  | Agency support for improving data flow to VBA |  |  |  |  |  |  |  | 30000
 |  | Updating VBA to include new species attribute fields ($ ??) |  |  |  |  |  |  |  | 40000
 |  | ARI Building Accommodation | 8038
 |  | ARI Building Accommodation | 8038
 |  | Grants & Transfer Payments
 |  | - Recipient of Grant
TOTAL Discretionary: |  | TOTAL Discretionary
TOTAL Opex: |  | TOTAL Opex
 |  | TOTAL Budget |  | Total
 |  | TRUST BUDGET - EXPAND AS REQUIRED
 |  | TRUST REVENUE & EXPENITURE |  |  |  |  |  |  |  | Chargecode Alignments |  |  |  |  |  |  |  | Monthly Cashflows
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL BUDGETED FTE |  | Jul | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Total
 |  | Expenditure* |  |  |  |  | Budgeted $ | Requested  but not budgeted $
 |  | Salary positions |  |  |  |  |  |  |  | Budgeted FTE | Budgeted FTE | Budgeted FTE | Budgeted FTE | Budgeted FTE | Budgeted FTE |  |  | Jul | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Total
 |  |  |  |  |  |  |  |  |  | xxxx / xxx | xxxx / xxx | 23829 / 425 | xxxx / xxx | xxxx / xxx | xxxx / xxx
 |  | Name | Account Code | Current Budgeted FTE | Start Date | End Date | Total Budgeted Cost | Effective FTE
 |  | Operating Expenditure*
 |  |  |  |  |  |  | Budgeted $ | Requested  but not budgeted $ |  | Budget $ | Budget $ | Budget $ | Budget $ | Budget $ | Budget $ | TOTAL BUDGET $
 |  | Basic (standard formula):
 |  | - General Operating | 6572
 |  | - General Operating | 6572
 |  | - General Operating | 6572
 |  | - General Operating | 6572
 |  | Supplies and services:
 |  | - Legal Fees | 6705
 |  | - Contract Services | 6711
 |  | - etc.
 |  | 23829 fire ecology trust account | 6711 |  |  |  |  |  |  |  |  | 55000 |  |  |  |  |  |  |  |  |  |  |  |  |  | 55000
 |  | Grants & Transfer Payments
 |  | - Recipient of Grant
 |  | Revenue*
 |  |  |  | Total
 |  | Notes:
 |  | * instruction:  use a separate line for each applicable project/fundsource combination
 |  | ** general operating - ie. fixed at $2,500 per FTE, to cover day to day expense requirements such as phone costs, personal expenses, travel and accomm, subscriptions, vehicle hire, non standard stationary etc etc. Training will be covered by 1% of total salary L&D levy, if require additional amount include under supplies and services in operating.
 |  | **** Workstation Charges will be centralised