ࡱ>  \pKim Charles (x5021) Ba= =JL,!8@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1 Arial1$Arial1QTahoma1QTahoma1Arial1Arial1Arial1Arial"$"#,##0;\-"$"#,##0"$"#,##0;[Red]\-"$"#,##0"$"#,##0.00;\-"$"#,##0.00#"$"#,##0.00;[Red]\-"$"#,##0.005*0_-"$"* #,##0_-;\-"$"* #,##0_-;_-"$"* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-"$"* #,##0.00_-;\-"$"* #,##0.00_-;_-"$"* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\) "$"#,##0.00'""$"#,##0.0000;[Red]\-"$"#,##0.00000.00_ ;[Red]\-0.00\  [$$-C09]#,##0[$$-C09]#,##0.00 "$"#,##0 0.0%[$$-C09]#,##0.0                + ) , *    <@ @    "@  " @   x @ @      |@ @ + |@ @ + \+ |@ @ /  L/ @ @ @ @ |@ @ ) |@ @ ) @ @ <@ @  @ @ <@ @      8""@ @  8" @  x +  x / 8" @ < 8 x   X  |@ @ /  |@ @ ,   ,  |@ @  |@ @   \   | @ @ @ @  <@ @  <@ @  < <@ @ @ @ @ @ @ @  <@ @  @ @ <@ @ @ @   |         L-  (\-  x"@@ +  x " @ +  x"@@ /  x " @ /  X    |@ @-  |@ -  |@ -  |@ @ ,  |@ @ -  <@ @  \-  h"@@   h""@ @   ` $NOTESGGuidance FinancialsoComparative Cost+ Planned Cost oInitial Costs - HR Costs=,  ;(   ;/$ valid_area;. valid_benefit_impact;( valid_category; ( valid_controls; * valid_likelihood;1 valid_likelihood_factor;+ valid_risk_impact;+ valid_risk_rating;"ffd@@  3 A@@  pYear 1Year 2Year 3CapitalHardware & facilitiesVendor/supplier contract costsExpenseTravel & accommodationEducation & training Subtotals ContingencyYear 4Year 5Financial CostsNet Financial Cost of Project Cummulative Year by YearAnnual discount rate Initial CostsRecurring Costs FinancialQuantitative BenefitsTotal Project Costs.This workbook contains a number of worksheets.OSome of these should be completed and inserted into the business case template.@Others provide guidance as to how the tables should be filled ingNote that the risk categories, consequence areas and consequences are defined in Risk Management policy/Refer to this document for further information.#Total Quantitative Project BenefitsBusiness Analyst Senior Business Analyst AdministratorProject ManagerProgram Manager DeveloperSpecialist DeveloperTesterDatabase AdministratorRoleTechnical WriterSubject Matter Expert Data Entry Daily rate $Basis of costing ContractorSwinburne staff Labour hire Expense - HRExpense - otherProject/Program managersSubject matter expert Data entry*Based on 20% per year of the initial costs!Financial Costs - Human ResourceshCalculate the cost per year for each of the roles required, based on the daily rates in the table below.The default recurring cost is estimated to be 20% per annum of the total initial costs of the projects, based on a typical project. However, if this is not representative of the project option being costed, then a more appropriate figure should be costed and inserted here instead.Contingency - risk budgetContingency - change budgetThe purpose of the risk budget is to allow for any errors in estimating the initial costs of the project. A default figure of 10% should be added for the year(s) when the project is in the delivery phase, unless another value is more appropriateThe purpose of the risk budget is to allow for any costs incurred as a result agreed changes in scope of the project. A default figure of 10% should be added for the year(s) when the project is in the delivery phase, unless another value is more appropriate+Risk Budget (for cost estimating tolerance)-Change Budget (for potential change in scope) Net Present Value of the project! (costs shown as +, returns as -)#Point at which project breaks event$Ongoing cost of data synchronisation!Administration of retired systems*Licence and maintenance of retired systemsHGuidance for completing the Planned Cost and Comparative Cost financials Planned CostComparative costComparative CostSwinburne or agency staff%Financial Costs on planned cost basis)Financial Costs on comparative cost basis daily rateentire projectmandays requiredBusiness Analysts DevelopersTestersDBATechnical writers * Swinburne staff * Labour hire* the rates shown for these roles on a planned cost apply, unless the role can be absorbed by existing staff ie no additonal resource is requiredFinancial Analysis +Net Financial Cost of Project, Year by YearSummary for project proposal9Financial Analysis over 5 years on comparative cost basis5Financial Analysis over 5 years on planned cost basis1Total Project Costs ie project budget requirementJSeek guidance from Project Office about comparative cost and planned cost Decomissioning Blank Stagetotal over 5 year period-Software purchases & licenses (RE Enterprise)0Software purchases & licenses (RE Net Community) in year 2 HR componentStage 1Stage 2Stage 3Pcomplete and copy into the project proposal (pulls in HR costs from other sheet) in year ?*_these are the sheets you need in order to prepare the financial analysis for a Project ProposalWorksheet nameActionMenter the man-days for each role for each stage of project to derive HR costsGuidance FinancialsInitial Costs - HR Costsrr v)XA^c  C d " #cc  DF  dMbP?_*+%&L&AM*\\SWINNET\SPS1-241HPLAJET4200NLC 4dXXA4DINU"`m-SMTJHP LaserJet 4200 PCL 6InputBinFORMSOURCERESDLLUniresDLLResolution600dpiFastResTrueOrientationPORTRAITHPOrientRotate180FalseHPCoversFirst_PagePaperSizeA4MediaTypeAutoTextAsBlackFalseDuplexNONEHPFontInstallerTRUEHPPJLEncodingUTF8OutputBinAutoStaplingNoneHPStaplingOpposedFalseStaplingCmdCallbackStaplingCmdCbCollateOFFJRConstraintsJRCHDPartialJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffTTAsBitmapsSettingTTModeOutlineRETChoiceTrueHPLpiSelectionNoneHPPCL6PassThroughTrueJRCmdCallbackJRHPColorModeMONOCHROME_MODEHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpc42006.xmlHPPDLTypePDL_PCL6PrintQualityGroupPQGroup_3EconomodeFalseHPJobAccountingHPJOBACCT_JOBACNTAlternateLetterHeadFalseHPDocPropResourceDatahpzhl3xy.cabHPSmartDuplexSinglePageJobTrueHPSmartDuplexOddPageJobTrueHPConsumerCustomPaperTrueHPEnableRAWSpoolingTruePSAlignmentFileHPZLS3xyPSServicesOptionPrnStat_SID_242_BID_497_HID_15521HPPreAnalysisTrueHPPaperSizeALMConstraintsENV_10HPMediaTypeDuplexConstraintsCARDSTOCK`IUPH dA4 [none] [none]Arial4P d?KCHARLES<Automatic>0dEXCEL.EXEC:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" PXX??U} } I} $T          ik jl i n D i F g i E g i o m   i j****>@<d7bbggD  sgn  dMbP?_*+%,&L&AM*\\SWINNET\SPS1-241HPLAJET4200NLC 4dXXA4DINU"`m-SMTJHP LaserJet 4200 PCL 6InputBinFORMSOURCERESDLLUniresDLLResolution600dpiFastResTrueOrientationPORTRAITHPOrientRotate180FalseHPCoversFirst_PagePaperSizeA4MediaTypeAutoTextAsBlackFalseDuplexNONEHPFontInstallerTRUEHPPJLEncodingUTF8OutputBinAutoStaplingNoneHPStaplingOpposedFalseStaplingCmdCallbackStaplingCmdCbCollateOFFJRConstraintsJRCHDPartialJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffTTAsBitmapsSettingTTModeOutlineRETChoiceTrueHPLpiSelectionNoneHPPCL6PassThroughTrueJRCmdCallbackJRHPColorModeMONOCHROME_MODEHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpc42006.xmlHPPDLTypePDL_PCL6PrintQualityGroupPQGroup_3EconomodeFalseHPJobAccountingHPJOBACCT_JOBACNTAlternateLetterHeadFalseHPDocPropResourceDatahpzhl3xy.cabHPSmartDuplexSinglePageJobTrueHPSmartDuplexOddPageJobTrueHPConsumerCustomPaperTrueHPEnableRAWSpoolingTruePSAlignmentFileHPZLS3xyPSServicesOptionPrnStat_SID_242_BID_497_HID_15521HPPreAnalysisTrueHPPaperSizeALMConstraintsENV_10HPMediaTypeDuplexConstraintsCARDSTOCK`IUPH dA4 [none] [none]Arial4P d?KCHARLES<Automatic>0dEXCEL.EXEC:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" MXX??U} <} $ <} I=} $ <} <} $ <,w2w2 " " " " " "  "  "  "  "  " " " " "",*2,>,u> 5 26333333 2\3333334 \G] ^E_ 5& 6* 6+ 7* 7+ 8~ 9@@ :,~ :@@ :H 8~ 9@ :,~ :@ :H 8 ~ 9@ :,~ :@ :H 8!~ 9@ :,~ :@ :H 8"~ 9@@ :,~ :@@ :H 8#~ 9@ :,~ :@ :H 8$~ 9@@ :,~ :@@ :H 8%~ 9@ :,~ :@ :H 8'~ :@ :,~ :y@ :H 8(~ :y@ :-~ :y@ :S 8~ :@o@ :.~ :@o@ :T 8)~ :@o@ :.~ :@o@ :T ;U  a7aaaaaa 8 `:`````` 9 `;``````6$$:FFFFFFFFFFFFF$$>@<d*7ggD  )ďʞ  dMbP?_*+%;&CFinancial Analysis: &A&~?'~?(~?)~?M*\\SWINNET\SPS1-241HPLAJET4200NLC 4dXXA4DINU"`m-SMTJHP LaserJet 4200 PCL 6InputBinFORMSOURCERESDLLUniresDLLResolution600dpiFastResTrueOrientationPORTRAITHPOrientRotate180FalseHPCoversFirst_PagePaperSizeA4MediaTypeAutoTextAsBlackFalseDuplexNONEHPFontInstallerTRUEHPPJLEncodingUTF8OutputBinAutoStaplingNoneHPStaplingOpposedFalseStaplingCmdCallbackStaplingCmdCbCollateOFFJRConstraintsJRCHDPartialJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffTTAsBitmapsSettingTTModeOutlineRETChoiceTrueHPLpiSelectionNoneHPPCL6PassThroughTrueJRCmdCallbackJRHPColorModeMONOCHROME_MODEHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpc42006.xmlHPPDLTypePDL_PCL6PrintQualityGroupPQGroup_3EconomodeFalseHPJobAccountingHPJOBACCT_JOBACNTAlternateLetterHeadFalseHPDocPropResourceDatahpzhl3xy.cabHPSmartDuplexSinglePageJobTrueHPSmartDuplexOddPageJobTrueHPConsumerCustomPaperTrueHPEnableRAWSpoolingTruePSAlignmentFileHPZLS3xyPSServicesOptionPrnStat_SID_242_BID_497_HID_15521HPPreAnalysisTrueHPPaperSizeALMConstraintsENV_10HPMediaTypeDuplexConstraintsCARDSTOCK`IUPH dA4 [none] [none]Arial4P d?KCHARLES<Automatic>0dEXCEL.EXEC:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" D"XX `? `?U} B"} I*B"} mB"} IB"} $ C"} $ B")  ;@ ;F ;@ ;@ ;@ ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ee A A A A A DDEEEEEG H IAIIIII H IBIIIII H ICIIIIIJ J#K" %#K" %#K" %#K" %#K" %M e e A A A A A M ggNNNNNM H O PPPPP M H O` PPPPP M H Oa PPPPP M H O PPPPP M H/ ON% P ZZ PPPP MQ O1%P ZZPPPPMQ OO%P ZZPPPPMQ OPP ZPPPPMQ OQP ZPPPPMQ ORP ZPPPPMQ O2P ZPPPPMQ OP ZPPPPMQ O3P ZPPPPM H0 O~ PPPPPMQ O~ PPPPPMR K #N  % !#N % !#N % !#N % !#N % !#M  % Y  Lc ggNNNNNMS O4P-P ?%-P ?%-P ?%-P ?%M g gNNNNNMT O<-P ?%UUUUMT O=-P ?%UUUUMK K #N  %!#N %!#N %!#N %!#N %!MJ J)K $$$B)K $$$B)K $$$B)K $$$B)K $$$BMBX^.000h.:666a]]UUUUUUFB..ee! ;@" ;L# ;L% ;@& ;@' ;@( ;@ !e!e !A !A !A !A !A "J "J!"K  DD!"K  DD!"K  DD!"K  DD!"K ' DD"M#J #J#K #D"!#K # D"D#!#K # D"D#!#K # D"D#!#K r D"D##M %fY%fVVVVV &bX &W~ &X @'c 'W>.'B #D"D&%""B  'B?(d (W@ (Bh(Ypx^$*Xx  (   B  0    ! 4'# @8(  8 8 Bpu XPP?U]4@pu\# k?5Fڿǃ ;<<Spreadsheet defaults to 20% of 5-year costs for each year. Enter values for each year when recurring costs occur eg if recurring costs kick in at year 2, put 0 in year 1. If there is additional information available about the make up and level of recurring costs, it may be appropriate to to enter different values.< ;  8 Bu XPP?]4@u# ,Pc8H\q0 <To accommodate cost estimating tolerance. Spreadsheet defaults to 5% of 5-year costs for the project, and it is shown in year 1. Dependent upon the nature of the project, it may be appropriate to enter a different value.< ,', 8 B8v XPP?[ U]4@8v$ ˂[)8B F <To accommodate variations in scope. Spreadsheet defaults to 5% of 5-year costs for the project, and it is shown in year 1. Dependent upon the nature of the project, it may be appropriate to enter a different value.<   Swinburnea Swinburnea Swinburnea>@<d B&(!!%%7gg\F  .d  dMbP?_*+%;&CFinancial Analysis: &A&~?'~?(~?)~?M*\\SWINNET\SPS1-241HPLAJET4200NLC 4dXXA4DINU"`m-SMTJHP LaserJet 4200 PCL 6InputBinFORMSOURCERESDLLUniresDLLResolution600dpiFastResTrueOrientationPORTRAITHPOrientRotate180FalseHPCoversFirst_PagePaperSizeA4MediaTypeAutoTextAsBlackFalseDuplexNONEHPFontInstallerTRUEHPPJLEncodingUTF8OutputBinAutoStaplingNoneHPStaplingOpposedFalseStaplingCmdCallbackStaplingCmdCbCollateOFFJRConstraintsJRCHDPartialJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffTTAsBitmapsSettingTTModeOutlineRETChoiceTrueHPLpiSelectionNoneHPPCL6PassThroughTrueJRCmdCallbackJRHPColorModeMONOCHROME_MODEHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpc42006.xmlHPPDLTypePDL_PCL6PrintQualityGroupPQGroup_3EconomodeFalseHPJobAccountingHPJOBACCT_JOBACNTAlternateLetterHeadFalseHPDocPropResourceDatahpzhl3xy.cabHPSmartDuplexSinglePageJobTrueHPSmartDuplexOddPageJobTrueHPConsumerCustomPaperTrueHPEnableRAWSpoolingTruePSAlignmentFileHPZLS3xyPSServicesOptionPrnStat_SID_242_BID_497_HID_15521HPPreAnalysisTrueHPPaperSizeALMConstraintsENV_10HPMediaTypeDuplexConstraintsCARDSTOCK`IUPH dA4 [none] [none]Arial4P d?KCHARLES<Automatic>0dEXCEL.EXEC:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" @"XX `? `?U} B"} I*B"} mB"} m B"} $ B"} $ C"} $ B".  ;@ ;F ;@ ;@ ;@ ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ;L ee A A A A A DDEEEEEG HIP Z'$Ongoing cost of data synchronisationII ZI ZI ZI Z HI Z$!Administration of retired systemsII ZI ZI ZI Z HI Z-*Licence and maintenance of retired systemsII ZI ZI ZI ZJ J#K" %#K " %#K " %#K " %#K " %M e e A A A A A M ggNNNNNM H O$ PPPPP M H O8 Z 0-Software purchases & licenses (RE Enterprise) P Z  PPPP M H O Z 30Software purchases & licenses (RE Net Community) P Z  PPPP M H O$ PPPPP M H/ ON% P ZZ  PPPP MQ O1%P Z!Z"PPPPMQ OO%P Z#Z$PPPPMQ OPP Z%PPPPMQ OQP Z&PPPPMQ ORP Z'PPPPMQ O2P Z(PPPPMQ OP Z)PPPPMQ O3P Z*PPPPM H0 O$PPPPPMQ O$PPPPPMR K #N  % !#N % !#N % !#N % !#N % !#M  % Y  Lc ggNNNNNMS O4P-P ?%-P ?%-P ?%-P ?%M g gNNNNNMT O<-P ?%UUUUMT O=-P ?%UUUUMK K #N  %!#N %!#N %!#N %!#N %!MJ J)K $$$B)K $$$B)K $$$B)K $$$B)K $$$BMBX^.h.NJa]]UUUUUUNJ..ee! ;@" ;L# ;L% ;@& ;@' ;@( ;@* X@+ ;@, ;@- ;@ !e!e !A !A !A !A !A "J "J!"K - DD!"K - DD!"K - DD!"K - DD!"K - DD"M#J #J#K #D"!#K # D"D#!#K # D"D#!#K # D"D#!#K r D"D##M %fZ%fVVVVV &bX &W~ &X @'c 'W>.'B #D"D&%""B  'B?(d (W@ (Bb(Y *hX *ZV *Z *Z *Z *Z *Z *[_+h +W[+B +D+B +D+B +D+B +D+B +D#+B ' %++ ,h ,W,B,D,B ,D,B ,D,B ,D,B ,D#,B + %,, -h -WW-B D"-B D"-B D"-B D"-B -D"#-B , %-- ^$*X0pl#  ( % & B ' 0) *   + 4P (     Bآ XPP?+]4 @آ& +@<d J &(*-!!%%7gg\F  0 "/  dMbP?_*+%;&C&A&~?'~?(\(\?)Q?M*\\SWINNET\SPS1-241HPLAJET4200NLC 4dXXA4DINU"`m-SMTJHP LaserJet 4200 PCL 6InputBinFORMSOURCERESDLLUniresDLLResolution600dpiFastResTrueOrientationPORTRAITHPOrientRotate180FalseHPCoversFirst_PagePaperSizeA4MediaTypeAutoTextAsBlackFalseDuplexNONEHPFontInstallerTRUEHPPJLEncodingUTF8OutputBinAutoStaplingNoneHPStaplingOpposedFalseStaplingCmdCallbackStaplingCmdCbCollateOFFJRConstraintsJRCHDPartialJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffTTAsBitmapsSettingTTModeOutlineRETChoiceTrueHPLpiSelectionNoneHPPCL6PassThroughTrueJRCmdCallbackJRHPColorModeMONOCHROME_MODEHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpc42006.xmlHPPDLTypePDL_PCL6PrintQualityGroupPQGroup_3EconomodeFalseHPJobAccountingHPJOBACCT_JOBACNTAlternateLetterHeadFalseHPDocPropResourceDatahpzhl3xy.cabHPSmartDuplexSinglePageJobTrueHPSmartDuplexOddPageJobTrueHPConsumerCustomPaperTrueHPEnableRAWSpoolingTruePSAlignmentFileHPZLS3xyPSServicesOptionPrnStat_SID_242_BID_497_HID_15521HPPreAnalysisTrueHPPaperSizeALMConstraintsENV_10HPMediaTypeDuplexConstraintsCARDSTOCK`IUPH dA4 [none] [none]Arial4P d?KCHARLES<Automatic>0dEXCEL.EXEC:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" A XXQ?p= ף?U} $ }   } m } m! }  m  } $  0 *@;@;@;@;@;@;@;@;@ ;@ ;@ ;@ ;@ ;!*% ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;. ' ;@ *M* +d +e +f +] +^ +L (((((#/ % (((((/  -  (((((/ !(((((/ "(((((/ #(((((/ $(((((/ %(((((/  ' ((((( / ( ((((( /   ((((( /  ) ((((( /    0    -! 0   0   0   0|4r  0  #J #K$D Stage 1$ D Stage 2$ D Stage 3$( DDecomissioning$H D Blank Stage $L @@ Z)(< LL)()()()(#,  % @ Z)()()()()(,( -  @ Z)()()()()(,( !@ Z)()()()()(,(+ "@@ Z )()()()()(,(1 #@ Z )()()()()(,(1 $@@ Z )()()()()(,(1 %@ Z )()()()()(,(1 '@ Z )()()()()(,(1 (y@ Z)()()()()(,( @o@ Z)()()()()(,( )@o@ Z)()()()()(,(!  -(  -!-(-(-(-(,(  @I&`  D daily rate&x L Stage 1&  Stage 2&  Stage 3& Decomissioning&  Blank Stage& entire project @@ Z)(*< LL)()()()(#,  %@DlK^CCCCCCCCCC q ;@! ;@" ;@# ;@$ ;@% ;@& ;@' ;@( ;@) ;@* ;@+ ;!- ;@. ;@/ ;@  @ Z )(  )(  )(  )(  )(  ,(#  * - ! !@ "Z!)(!!)(!!)(!!)(!!)(!!,("  "!"@ #Z")("")("")("")("")("",((  #"#@@ $Z #)(##)(##)(##)(##)(##,($ #1 $#$@ %Z $)($$)($$)($$)($$)($$,(% $1 %$%@@ &Z %)(%%)(%%)(%%)(%%)(%%,(& %1 &%&@ 'Z &)(&&)(&&)(&&)(&&)(&&,(' &1 '''y@ (Z ')('')('')('')('')('',( '1 (((y@ )Z()((()((()((()((()(((,()  ))@o@ *Z))()))()))()))()))()),(*  *)*@o@ Z*)(**)(**)(**)(**)(**,(  + ++-(+++ -!+-(+++-(+++-(+++-(+++,(++-?.?/"    /    J 0     4   " $ % & ' ( ) * U"PH`<0(  <>@<d A @7gg\F Oh+'0l `h ( @ L Xd0v1.0 Project Proposal Costing Template Vvv.rr$Project Proposal Costing TemplateLiz Sidebotham For medium or major projectsKim Charles (x5021)Microsoft Excel@Y@r@՜.+,0 X`x  Matthew Smith$Swinburne University of Technology' NOTESGuidance FinancialsComparative Cost Planned CostInitial Costs - HR Costs'Comparative Cost'!Print_Area&'Initial Costs - HR Costs'!Print_Area  Worksheets Named Ranges  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry F oWorkbook1SummaryInformation(DocumentSummaryInformation8