400 likes | 491 Views
Aim. Providing an introduction to the following systems/tools: TIPA – planning Performance Measures – reporting Buddy – finance Outcomes Better understanding of planning & report systems/tools
E N D
Aim Providingan introduction to the following systems/tools: • TIPA – planning • Performance Measures – reporting • Buddy – finance Outcomes • Better understanding of planning & report systems/tools • Able to use these systems/tools to obtain planning and performance data at teaching section level
TIPA – What data is important? • Delivery Planning • Get ASH & teaching hours correct • Staff Planning • Reflect the expected FT staffing • Budget Planning • ASH and $ • FT, PT hours, related duties, evening • Other Expenses
TIPA (TAFE Institute Planning Application) Tch hr – FT = PT Related Duties Evening work Excess Hrs Expenses Courses Classes/ Timetable ASH per class Teaching hrs Profile, ASH, $ (Annual Plan, Purchasing Agreement) Delivery Plan Budget ASH, Teaching Hrs Section teaching budget Section ASH Section Expenses Staff Plan FT cost, hours FT Staff Salaries Leave Adjustments HR staffing College Budget
TIPA Budget Delivery Plan ASH, Teaching Hrs FT cost, hours Staff Plan Teaching hours have no effect on ASH Teaching hours cost $$ Teaching hours impact $/ASH! ASH = Classes x Students / class xASH / student For efficiency: Student unit hours > Teaching hours/class Teaching hours = Teach hrs/class x No. Classes $/ASH important for Core = Total core $ / total core ASH Make sure fund codes are identified!
TIPA Class Planing Panning, Planning What could go wrong? • Assumes all enrolments go to all units (Credit??) • Assumes all enrolments choose all units (timetable, repeats?) • Assumes all units have viable classes • Have units changed nominal hours? (Check TP) • Assumes all ASH in current semester if % ASH not used
TIPA Budget Delivery Plan ASH, Teaching Hrs FT cost, hours Staff Plan Are these all correct? Award Salary 35hpw x 18 wks Total FT teaching cost and hours Per hour cost, teaching!
TIPA Budget Delivery Plan ASH, Teaching Hrs FT cost, hours $224, 329 on Staff Page? Staff Plan From Staff Plan From Class Plan Real FT teaching cost /hr = $279961/1458 = $192 per hour PT teaching hrs = Total Delivery plan – FT hrs here 3571 = 4352 + 677 - 1458 No effect on teaching hours but important for budget!
TIPA Summary • Delivery Planning • Get ASH & teaching hours correct • Staff Planning • Reflect the expected FT staffing • Budget Planning • ASH and $ • FT, PT hours, related duties, evening • Other Expenses
Exercise 1: Your teaching section enrolments & ASH VS target 2011 • Download the latest dataset sheet on desktop • Go to Dataset_TS sheet • Find out: • Course enrolments & ASH • Completions • By award level & type of fund • Compare the data with your targets
Exercise 2: Your teaching section RPL & ASH by course and RAM • Go back to the dataset sheet saved on desktop • Go to Dataset sheet ‘RPL_by_course’ • Find out: • RPL ASH & training hours ASH for a particular course • By award level • Compare the data with your allocated ASH
Exercise 3: Your teaching section unit/module completion rates • Go to Performance Measures • Go to ‘Other Data’ on the left hand panel • Download the sheet ‘Module completion rates and enrolments by college& faculty 2006-2010 • Find out enrolments & MCR 2006-2010 by • RAM • Field of study & course
Buddy and Financial Management • Funding sources • On-costs • Budgets, Expense, Transfers • Reading Buddy • Basic Financial Management
Fund Sources Commonwealth, State Agreement Contestable Funds Commercial International Core Funds Non-core Funds Core Budget College/Cluster Budget SAP / Buddy Delivery Plan (TIPA)
Buddy and SAP • Buddy is an interface to SAP Transfers Budgets SAP Buddy Tells us what is in SAP External Transactions Data Income
Buddy Exercise: • Change fund codes to see variations
On-costs On-costs are additional costs above the base salary paid by the employer as part of working conditions or regulatory requirement. On-costs add about 27% to FT salary costs and about 17% to PT salary costs. The real hourly cost of employment is thus the total costs / actual hours worked. TIPA budgets & Buddy budgets include on-costs. Payroll Tax Leave Loading Annual Leave Provision Workcover Insurance Extended Leave Provision Base Salary
Buddy Exercise: • Navigate to FT Payroll • Navigate to PT Payroll • Note non-teach payroll also in some sections • Why check this? WHO are you paying?? • Note Confidentiality: important to manage this information respectfully.
Expenditure & Budget - College Budget Expense Un-Balanced Budget Gives TROUBLE! Staff costs, expenses Commercial, International Balanced Budget Gives $ spent, $/ASH Other Expenses Core Core Budget Note: All salaries and expenses paid from Fund 001 (in Core) Staff Salaries Core
Expenditure & Budget - College Journal Transfer RTMS Budget Expense Other Expenses Non-Core Non-Core Income Staff Salaries Non-Core Core Budget Other Expenses Core Core Budget Core Budget Expense entered as a negative in core to move to non-core as expense against income Staff Salaries Core
Buddy Exercise: • Go to June 2011, core funds • Determine if there are any RTMS transfers • Click through to list the transfers • Note the amounts linked to what is selected
Buddy:Forecast 1 1 Quick Review: Actual / months to date = $ per month (approximately) $ per month x remaining months = funds required to end yr/sem Remaining funds – commitments – funds required = over/under? Quick Review: Actual / months to date = $ 1081949/10 = $108,000 $ 108000 x 2 = $ 216,000end yr/sem $144,000 – $46,000 – $216000 = -$118,000 ie overrun
Buddy Exercise: • Go to May 2011 Core, forecast June • How close was it? • Notice a problem with this exercise?
Buddy: Detailed Review • Section level variance, which are negative? • Click through to detail • Employees – Payroll, Transfers • Other Expenses – Purchases, printing, travel.... • What income / expenses are outstanding? • What future impacts are expected?
Buddy:Forecast Commitments? Negative Variances? Click Through for detail Current position = Buddy Variance – commitments + income
Buddy – What’s next? • Buddy can’t tell the whole story; it is a snapshot in time. • Some tracking of hours, expenses needed • What RTMS, journal transfers expected? • Current balance – adjusted to ‘now’ with local knowledge • Funds come in ‘chunks’ so reconciliation needs care