projectcostingschedule_20070607

1
Page 1 Sample Project Costing Schedule *See notes at end for assistance to ensure accuracy of calculations. NOTES % Rate Position 1 Position 2 Position 3 Position 4 Position 5 Position 6 Position 7 Position 8 Position 9 Position 10 Position 11 Position 12 TOTAL Employee Benefits Salary Rate 1 - $ - Rec Leave Loading 2 1.40% - - - - - - - - - - - - $ - Superannuation 3 17.00% - - - - - - - - - - - - $ - Work Cover 4 0.50% - - - - - - - - - - - - $ - LSL Levy 5 1.50% - - - - - - - - - - - - $ - Payroll Tax 6 4.75% - - - - - - - - - - - - $ - Total - Employee Benefits 25.96% - - - - - - - - - - - - $ - Other Expenditure Staff Development 7 2.50% $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Telephones 8 - $ 750.00 $ 750.00 $ 750.00 $ 750.00 $ 750.00 $ 750.00 $ 750.00 $ 750.00 $ 750.00 $ 750.00 $ 750.00 $ 750.00 $ 9,000.00 Software 9 - $ 118.00 $ 118.00 $ 118.00 $ 118.00 $ 118.00 $ 118.00 $ 118.00 $ 118.00 $ 118.00 $ 118.00 $ 118.00 $ 118.00 $ 1,416.00 General Overheads 10 - $ 250.00 $ 250.00 $ 250.00 $ 250.00 $ 250.00 $ 250.00 $ 250.00 $ 250.00 $ 250.00 $ 250.00 $ 250.00 $ 250.00 $ 3,000.00 Specific Unit Costs 11 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Total - Other Expenditure $ 1,118.00 $ 1,118.00 $ 1,118.00 $ 1,118.00 $ 1,118.00 $ 1,118.00 $ 1,118.00 $ 1,118.00 $ 1,118.00 $ 1,118.00 $ 1,118.00 $ 1,118.00 $ 13,416.00 COST PER PERSON PER ANNUM $ 1,118.00 $ 1,118.00 $ 1,118.00 $ 1,118.00 $ 1,118.00 $ 1,118.00 $ 1,118.00 $ 1,118.00 $ 1,118.00 $ 1,118.00 $ 1,118.00 $ 1,118.00 $ 13,416.00 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 TOTAL PROJECT-SPECIFIC COSTS Total Employee Benefits 12,15 $ - $ - Supplies and Services: Consultants, Contractors & Temp. staff $ - Maintenance - Hardware $ - Maintenance - Software $ - Other 13 $ 13,416.00 $13,416.00 Total Supplies and Services 15,16 $ 13,416.00 $ - $ - $ - $ - $ - $ - $13,416.00 Capital Expenditure: 17 Project Equipment $ - Total Capital Expenditure 15 $ - $ - $ - $ - $ - $ - $ - $ - Contingency 14,15 $ - TOTAL PROJECT COSTS 15,16 $ 13,416.00 $ - $ - $ - $ - $ - $ - $13,416.00 *NOTES: 1 Obtain the relevant annual salary rate for the budgetted position. Ensure salary increments and any EB components are allowed for. If the position is less than a full year, the annual rate should be multiplied by the appropriate percentage allocated to the proj 2 Allow 1.4% (of salary component) for annual leave provision representing 17.5% loading on four weeks recreation leave per annum. 3 Insert the relevant employer superannuation contribution for each employee, normally 17%(default) of salary cost, 9% for those employees who do not contribute themselves. 4 Allow 0.5% of salary costs for Work Cover provision. 5 Allow 1.5%of salary costs for long service leave provision. 6 Payroll Tax (4.75%) is calculated on the salary plus superannuation contribution. Percentages used in salary on-cost calculations (notes 2 to 6) may change as a result of legislation, industrial agreements and/or administrative decisions. Ensure Long Service Leave provision is made where appropriate. 7 8 Telephone costs may require adjustment dependent upon the specific needs of the respective business unit. 9 Software costs are based on an estimated Standard Operating Environment cost of $118 per person per annum. 10 11 Specific unit costs that may need to be added at the discretion of the operating unit. 12 Projects greater than one year need to ensure future year Employee Benefits take account of annual salary increments and any EB increases. This can be done by recalculating the cost per person per annum section of the spreadsheet for each additional year. 13 These are project costs in addition to those identified under "other expenditure" category such as training and marketing expenditure, publications and printing and acquisition of equipment (computers) specific to the project. 14 An amount provided for unforeseen expenditure throughout the project. 15 These totals should align with those shown in each project proposal and project plan. 16 No provision has been made for depreciation of project purchased equipment and accommodation costs in the above calculations. 17 The asset threshold is $5000. Any item of property plant and equipment costing in excess of this threshold must be recorded as an asset. Staff development costs are based upon 2.5% of the salary rate. May require adjustment dependent upon the specific needs of the business unit. General overheads include an allowance for general operating expenses - lunches etc and includes an allowance of $150 per annum for Internet access usage. A total of $250 per annum is estimated for each person. This will require adjustment dependent upon the s

Upload: ilkerkozturk

Post on 08-Nov-2015

222 views

Category:

Documents


1 download

DESCRIPTION

PMP

TRANSCRIPT

Project CostsSample Project Costing Schedule*See notes at end for assistance to ensure accuracy of calculations.NOTES% RatePosition 1Position 2Position 3Position 4Position 5Position 6Position 7Position 8Position 9Position 10Position 11Position 12TOTALEmployee BenefitsSalary Rate1-0.0Rec Leave Loading21.40%0.00.00.00.00.00.00.00.00.00.00.00.00.0Superannuation317.00%0.00.00.00.00.00.00.00.00.00.00.00.00.0Work Cover40.50%0.00.00.00.00.00.00.00.00.00.00.00.00.0LSL Levy51.50%0.00.00.00.00.00.00.00.00.00.00.00.00.0Payroll Tax64.75%0.00.00.00.00.00.00.00.00.00.00.00.00.0Total - Employee Benefits25.96%0.00.00.00.00.00.00.00.00.00.00.00.00.0Other ExpenditureStaff Development72.50%0.00.00.00.00.00.00.00.00.00.00.00.00.0Telephones8-$750.00$750.00$750.00$750.00$750.00$750.00$750.00$750.00$750.00$750.00$750.00$750.00$9,000.00Software9-$118.00$118.00$118.00$118.00$118.00$118.00$118.00$118.00$118.00$118.00$118.00$118.00$1,416.00General Overheads10-$250.00$250.00$250.00$250.00$250.00$250.00$250.00$250.00$250.00$250.00$250.00$250.00$3,000.00Specific Unit Costs110.00.00.00.00.00.00.00.00.00.00.00.0Total - Other Expenditure$1,118.00$1,118.00$1,118.00$1,118.00$1,118.00$1,118.00$1,118.00$1,118.00$1,118.00$1,118.00$1,118.00$1,118.00$13,416.00COST PER PERSON PER ANNUM$1,118.00$1,118.00$1,118.00$1,118.00$1,118.00$1,118.00$1,118.00$1,118.00$1,118.00$1,118.00$1,118.00$1,118.00$13,416.00Year 1Year 2Year 3Year 4Year 5Year 6Year 7TOTALPROJECT-SPECIFIC COSTSTotal Employee Benefits12,150.00.0Supplies and Services:Consultants, Contractors & Temp. staff0.0Maintenance - Hardware0.0Maintenance - Software0.0Other13$13,416.00$13,416.00Total Supplies and Services15,16$13,416.000.00.00.00.00.00.0$13,416.00Capital Expenditure:17Project Equipment0.0Total Capital Expenditure150.00.00.00.00.00.00.00.0Contingency14,150.0TOTAL PROJECT COSTS15,16$13,416.000.00.00.00.00.00.0$13,416.00Utilising AO5 as a base (60%)0.000.000.000.001.000.000.000.000.000.000.000.000.00*NOTES:1Obtain the relevant annual salary rate for the budgetted position. Ensure salary increments and any EB components are allowed for. If the position is less than a full year, the annual rate should be multiplied by the appropriate percentage allocated to the project.2Allow 1.4% (of salary component) for annual leave provision representing 17.5% loading on four weeks recreation leave per annum.3Insert the relevant employer superannuation contribution for each employee, normally 17%(default) of salary cost, 9% for those employees who do not contribute themselves.4Allow 0.5% of salary costs for Work Cover provision.5Allow 1.5%of salary costs for long service leave provision.6Payroll Tax (4.75%) is calculated on the salary plus superannuation contribution.Percentages used in salary on-cost calculations (notes 2 to 6) may change as a result of legislation, industrial agreements and/or administrative decisions. Ensure Long Service Leave provision is made where appropriate.7Staff development costs are based upon 2.5% of the salary rate. May require adjustment dependent upon the specific needs of the business unit.8Telephone costs may require adjustment dependent upon the specific needs of the respective business unit.9Software costs are based on an estimated Standard Operating Environment cost of $118 per person per annum.10General overheads include an allowance for general operating expenses - lunches etc and includes an allowance of $150 per annum for Internet access usage. A total of $250 per annum is estimated for each person. This will require adjustment dependent upon the specific needs of the project.11Specific unit costs that may need to be added at the discretion of the operating unit.12Projects greater than one year need to ensure future year Employee Benefits take account of annual salary increments and any EB increases. This can be done by recalculating the cost per person per annum section of the spreadsheet for each additional year.13These are project costs in addition to those identified under "other expenditure" category such as training and marketing expenditure, publications and printing and acquisition of equipment (computers) specific to the project.14An amount provided for unforeseen expenditure throughout the project.15These totals should align with those shown in each project proposal and project plan.16No provision has been made for depreciation of project purchased equipment and accommodation costs in the above calculations.17The asset threshold is $5000. Any item of property plant and equipment costing in excess of this threshold must be recorded as an asset.

&R&GPage &P&R