Cost Benefits Analysis_CBA_ Template

State of Florida FY 2007-08 Schedule IV-B IT Project Cost Benefits Analysis CBAForm 1 -Tangible Changes File version 1c Agency: Agency Name or Acronym Project: Project Name Program(s) Title: Program Title or Acronym Project Sponsor: Name of Project Sponsor Tangible Changes in Program Operations resulting from Project Implementation --CBAForm 1-A Program Operational Cost Elements FY FY FY FY FY Changes in Program Operational Costs (Nnegative Values = Decreased Costs) 2008-09 2009-10 2010-11 2011-12 2012-13 TOTAL A. Personnel --Operational Costs $0 $0 $0 $0 $0 $0 A-1.a. State FTEs (Salaries & Benefits) $0 $0 $0 $0 $0 $0 A-1.b. State FTEs (# FTEs) 0.00 0.00 0.00 0.00 0.00 0.00 A-2.a. OPS FTEs (Salaries) $0 $0 $0 $0 $0 $0 A-2.b. OPS FTEs (# FTEs) 0.00 0.00 0.00 0.00 0.00 0.00 A-3.a. Staff Augmentation (Contract Cost) $0 $0 $0 $0 $0 $0 A-3.b. Staff Augmentation (# of Contract FTEs) 0.00 0.00 0.00 0.00 0.00 0.00 B. Plant & Facility --Operational Costs $0 $0 $0 $0 $0 $0 C. External Service Provider --Operational Costs $0 $0 $0 $0 $0 $0 C-1. Contractor Services $0 $0 $0 $0 $0 $0 C-2. Maintenance & Support Services $0 $0 $0 $0 $0 $0 C-3. Network /Hosting Services $0 $0 $0 $0 $0 $0 C-4. Data Communications Services $0 $0 $0 $0 $0 $0 C-6. Other Specify $0 $0 $0 $0 $0 $0 D. Data Processing --Operational Costs $0 $0 $0 $0 $0 $0 D-1. Hardware $0 $0 $0 $0 $0 $0 D-2. Software $0 $0 $0 $0 $0 $0 D-4. Other Specify $0 $0 $0 $0 $0 $0 E. Others --Operational Costs $0 $0 $0 $0 $0 $0 E-1. Training $0 $0 $0 $0 $0 $0 E-2. Travel $0 $0 $0 $0 $0 $0 E-4. Other Specify $0 $0 $0 $0 $0 $0 Subtotal of Operational Costs ( Rows A through E) $0 $0 $0 $0 $0 $0 F. Revenues /External Contribution /Fiscal Offsets $0 $0 $0 $0 $0 $0 F-1. Revenues Specify $0 $0 $0 $0 $0 $0 F-2. Federal Participation Specify $0 $0 $0 $0 $0 $0 F-3. Grants Specify $0 $0 $0 $0 $0 $0 Total Costs of Program to State (Sum of Rows A through E minus Row F) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Character of Program Cost Change Estimate -CBAForm 1-B Choose Type Confidence Level Enter % (+/-) Detailed/Rigorous Not to Exceed Order of Magnitude Placeholder 10% Negative Values indicate decreased Costs (i.e., Tangible Benefits). FY Totals are carried forward to CBAForm2 and CBAForm3 for investment summary calculations Cumulative Change File: $ASQCost Benefits Analysis_CBA_ Template.xls.xls Tab: CBAForm1 -TangibleChanges Path: C:\Docstoc\Working\ActivePDF\Input\ Page 1 of 3SState of Florida FY 2007-08 Schedule IV-B IT Project Cost Benefits Analysis Agency: Agency Name or Acronym Project: Project Name File version 1c CBAForm 2 -Costs Program(s) Title: Program Title or Acronym Project Sponsor: Name of Project Sponsor Project Cost Elements Project Cost Table --CBAForm 2-A Character of Project Costs Estimate -CBAForm 2-B (Project Planning,Development & Implementation Only -FY FY FY FY FY TOTAL Choose Type Confidence Level Enter % (+/-) No Operational Costs) 2008-09 2009-10 2010-11 2011-12 2012-13 Detailed/Rigorous State FTEs (Salaries & Benefits) $0 $0 $0 $0 $0 $0 Not to Exceed OPS FTEs (Salaries) $0 $0 $0 $0 $0 $0 Order of Magnitude Staff Augmentation (Contract Cost) $0 $0 $0 $0 $0 $0 Placeholder Consultant Services $0 $0 $0 $0 $0 $0 Hardware $0 $0 $0 $0 $0 $0 Software $0 $0 $0 $0 $0 $0 Network Infrastructure $0 $0 $0 $0 $0 $0 Training $0 $0 $0 $0 $0 $0 Travel $0 $0 $0 $0 $0 $0 Other Specify $0 $0 $0 $0 $0 $0 Total Project Costs (*) $0 $0 $0 $0 $0 $0 Cumulative Project Costs $0 $0 $0 $0 $0 Total Project Costs are carried forward to CBAForm3 for investment summary calculations. Program(s) Costs for Current Operations versus Proposed Operations as a Result of the Project --CBAForm 2-C FY 2008-09 FY 2009-10 FY 2010-11 FY 2011-12 FY 2012-13 (b) (c) = (a) + (b) (b) (c) = (a) + (b) (b) (c) = (a) + (b) (b) (c) = (a) + (b) (b) (c) = (a) + (b) Agency Program Cost Elements (a) Operational New Program (a) Operational New Program (a) Operational New Program (a) Operational New Program (a) Operational New Program Existing Cost Change Costs resulting Existing Cost Change Costs resulting Existing Cost Change Costs resulting Existing Cost Change Costs resulting Existing Cost Change Costs resulting Program (Benefits from from Proposed Program (Benefits from from Proposed Program (Benefits from from Proposed Program (Benefits from from Proposed Program (Benefits from from Proposed Costs CBA Form1-A Project Costs CBA Form1-A Project Costs CBA Form1-A Project Costs CBA Form1-A Project Costs CBA Form1-A Project A. Personnel --Costs $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 A-1.a. State FTEs (Salaries & Benefits) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 A-1.b. State FTEs (# FTEs) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 A-2.a. OPS FTEs (Salaries) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 A-2.b. OPS FTEs (# FTEs) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 A-3.a. Staff Augmentation (Contract Cost) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 A-3.b. Staff Augmentation (# of Contract FTEs) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 B. Plant & Facility --Costs $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 C. External Service Provider --Costs $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 C-1. Contractor Services $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 C-2. Maintenance & Support Services $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 C-3. Network /Hosting Services $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 C-4. Data Communications Services $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 C-6. Other Specify $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 D. Data Processing --Costs $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 D-1. Hardware $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 D-2. Software $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 D-4. Other Specify $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 E. Others --Costs $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 E-1. Training $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 E-2. Travel $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 E-4. Other Specify $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Subtotal of Operational Costs ( Rows A through E) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 F. Revenues /External Contribution /Fiscal Offsets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 F-1. Revenues Specify $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 F-2. Federal Participation Specify $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 F-3. Grants Specify $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Total (Sum of Rows A through E minus Row F) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Cumulative Program/Operational Costs $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Character of Existing Program Costs Estimate -CBAForm 2-D Choose Type Confidence Level Enter % (+/-) Detailed/Rigorous Not to Exceed Order of Magnitude Placeholder 10% 10% (Operations Only --No Project Costs) File: $ASQCost Benefits Analysis_CBA_ Template.xls.xls Tab: CBAForm2-Costs Path: C:\Docstoc\Working\ActivePDF\Input\ Page 2 of 3State of Florida FY 2007-08 Schedule IV-B IT Project Cost Benefits Analysis CBAForm 3 Project Investment Summary File version 1c Agency: Agency Name or Acronym Project: Project Name Program(s) Title: Program Title or Acronym Project Sponsor: Name of Project Sponsor Investment Summary --CBAForm 3-A FY FY FY FY FY 2008-09 2009-10 2010-11 2011-12 2012-13 Cost of Capital (as published by State CFO) 4.24% 4.36% 4.22% 4.19% 4.39% Cost Benefit Analysis I $0 $0 $0 $0 $0 $0 II Total Project Cost (CBAForm 2-A) $0 $0 $0 $0 $0 $0 III 0.00 0.00 0.00 0.00 0.00 0.00 IV Return on Investment (Row I minus Row II) $0 $0 $0 $0 $0 $0 V Payback Period (years) NO PAYBACK Payback Period is the time required to recover the investment costs of the project. VI Breakeven Fiscal Year NO PAYBACK Fiscal Year during which the project's investment costs are recovered. VII Net Present Value (NPV) $0 NPV is the present-day value of the project's benefits less costs over the project's lifecycle. VIII Internal Rate of Return (IRR) NO IRR IRR is the project's rate of return. Proposed Funding Sources for Project Costs by Fiscal Year --CBAForm 3-B FY FY FY FY FY 2008-09 2009-10 2010-11 2011-12 2012-13 IX $0 $0 $0 $0 $0 $0 X Trust Fund Specify $0 $0 $0 $0 $0 $0 XI Federal Match Specify $0 $0 $0 $0 $0 $0 XII Grants Specify $0 $0 $0 $0 $0 $0 XIII Other Specify $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Project Funding Totals General Revenue TOTAL Year to Year Change in Program(s) Staffing (calculated fromCBAForm 2-C) TOTAL Prospective Source(s) of Project Funding Investment Summary Net Savings Resulting from the Project (CBAForm 1-A) Return on Investment Analysis File: $ASQCost Benefits Analysis_CBA_ Template.xls.xls Tab: CBAForm3-InvestmentSummary Path: C:\Docstoc\Working\ActivePDF\Input\ Page 3 of 3