Docstoc

cost-benefit-analysis-template-project

Document Sample
cost-benefit-analysis-template-project Powered By Docstoc
					                                                                 Enterprise Performance:
                                                            Cost Benefit Assessment Framework
                                                                  Cost Benefit Template
                                                                                  Project Title:              Balanced Scorecard
                     Forecasted Financials                                        Project Sponsor:            Annie Clark, ACF-1
                                                                                  Project Manager:            Annie Clark, ACF-1
                                                                                  Funding Requested:          $125,000
    Summary of Costs and Benefits:
                            Cost Description                              2003           2004          2005          2006          2007       Total Cost
    Costs of New Proposed Project
    Total Capital Costs (Capital_Cost tab)                              $4,000             $0            $0            $0           $0              $4,000
    Total Non-Recurring Costs (non_recurring tab)                      $80,000             $0            $0            $0           $0             $80,000
    Total Recurring Costs (recurring_tab)                             $753,000       $776,343      $800,410      $825,222     $850,804          $4,005,779
    Total Intangible Total Recurring Costs (intangible_costs tab)           $0             $0            $0            $0           $0                  $0
      Total Costs of Proposed Project                                 $837,000       $776,343      $800,410      $825,222     $850,804          $4,089,779

    Benefits
    Business Benefits (benefits_detail tab)                           $750,500       $773,766      $797,752      $822,483     $847,980          $3,992,480
    Business Benefits (intangible_benefits_tab)                             $0             $0            $0            $0           $0                  $0
     Net Business Benefits                                            $750,500       $773,766      $797,752      $822,483     $847,980          $3,992,480

    Revenue (benefits_detail tab)                                    $1,500,000     $1,500,000   $1,500,000    $1,500,000   $1,500,000          $7,500,000
    Cost Avoidance (benefit_detail tab)                                      $0             $0           $0            $0           $0                  $0
    Other Savings (benefit_detail tab)                                       $0             $0           $0            $0           $0                  $0
     Total Benefits - Cash Inflows                                   $2,250,500     $2,273,766   $2,297,752    $2,322,483   $2,347,980         $11,492,480
     Cumulative Benefits                                             $2,250,500     $4,524,266   $6,822,018    $9,144,500 $11,492,480

    Net Benefits                                                    $1,413,500     $1,497,423    $1,497,343    $1,497,260   $1,497,175    $      7,402,701

    Net Present Value (NPV) - annual                                $1,369,671     $1,405,999    $1,362,329    $1,320,014   $1,279,011
                          - discount rate                                                                                                            3.20%
                          - accumulative                            $1,369,671     $2,775,669    $4,137,999    $5,458,013   $6,737,023

    IRR                                                                269.51%
    ROI                                                                   181%
    Payback (In years)                                                      2.8




8/10/2012                                                 7b028159-1903-43a1-a855-73a8a5ea1871.xls                                            8/10/2012 4:51 AM
                                          Information Technology:
                                    Cost Benefit Assessment Framework
                                           Cost Benefit Template

Balanced Scorecard                                                                 Inflation Index:       3.10%
Capital Costs
                 Cost Description                 2003       2004       2005       2006       2007    Total Cost
Data Processing Equipment
 Desktops                                      $ 1,500                                                $      1,500
 Laptops                                       $ 2,500                                                $      2,500
 Other (specify)                                                                                      $          -
                                                                                                      $          -
Software                                                                                              $          -
 Application                                                                                          $          -
 Systems                                                                                              $          -
                                                                                                      $          -
Equipment                                                                                             $          -
 Specify details                                                                                      $          -
                                                                                                      $          -
                                                                                                      $          -
                                                                                                      $          -
                                                                                                      $          -
                                                                                                      $          -
Total Capital Costs                            $ 4,000   $   -      $   -      $   -      $    -      $      4,000
Balanced Scorecard                                                        Inflation Index:      3.10%
Tangible Costs - Non Recurring
                  Cost Description       2003       2004       2005       2006       2007     Total Cost
Salaries and Benefits                                                                        $        -
Contracting                          $ 50,000                                                $     50,000
 Studies                             $ 5,000                                                 $      5,000
Data Collection                                                                              $        -
Hardware (non capital)                                                                       $        -
Software (non capital)                                                                       $        -
Travel                               $ 10,000                                                $     10,000
Training                             $ 10,000                                                $     10,000
Incidental Expenses and Overhead     $ 5,000                                                 $      5,000
Facility Costs                                                                               $        -
Other                                                                                        $        -
  Specify details                                                                            $        -
                                                                                             $        -
                                                                                             $        -
                                                                                             $        -
                                                                                             $        -
                                                                                             $        -
                                                                                             $        -
                                                                                             $        -
Total Non-Recurring Costs            $ 80,000   $   -      $   -      $   -      $    -      $     80,000
Balanced Scorecard                                                                    Inflation Index:      3.10%
Tangible Costs - Recurring
                  Cost Description          2003        2004          2005          2006          2007    Total Cost
Salaries and Benefits                $   500,000 $   515,500   $   531,481   $   547,956   $   564,943   $ 2,659,880
Contracting                                      $       -     $       -     $       -     $       -     $        -
Data Collection                      $   250,000 $   257,750   $   265,740   $   273,978   $   282,472   $ 1,329,940
Software                             $     1,000 $     1,031   $     1,063   $     1,096   $     1,130   $      5,320
  Software leases                    $       500 $       516   $       531   $       548   $       565   $      2,660
Travel                               $     1,000 $     1,031   $     1,063   $     1,096   $     1,130   $      5,320
Training                                         $       -     $       -     $       -     $       -     $        -
Supplies                             $       500 $       516   $       531   $       548   $       565   $      2,660
Incidental Expenses                              $       -     $       -     $       -     $       -     $        -
Accommodation Rentals & Utilities                $       -     $       -     $       -     $       -     $        -
Other                                            $       -     $       -     $       -     $       -     $        -
  Specify details                                $       -     $       -     $       -     $       -     $        -
                                                 $       -     $       -     $       -     $       -     $        -
                                                 $       -     $       -     $       -     $       -     $        -
                                                 $       -     $       -     $       -     $       -     $        -
                                                 $       -     $       -     $       -     $       -     $        -
                                                 $       -     $       -     $       -     $       -     $        -
                                                 $       -     $       -     $       -     $       -     $        -
Total Recurring Costs                $   753,000 $   776,343   $   800,410   $   825,222   $   850,804   $ 4,005,779
Balanced Scorecard                                                                           Inflation Index:
Intangible Costs
                 Cost Description                     2003        2004        2005       2006

Note: for each cost item listed below, provide
      an attachment, explaining the calculation

Productivity Loss                                             $   -       $   -      $   -
Opportunity Costs                                             $   -       $   -      $   -
Corporate Overhead and Management time                        $   -       $   -      $   -
Other (specify details)                                       $   -       $   -      $   -
                                                              $   -       $   -      $   -
                                                              $   -       $   -      $   -
                                                              $   -       $   -      $   -
                                                              $   -       $   -      $   -
                                                              $   -       $   -      $   -
                                                              $   -       $   -      $   -
                                                              $   -       $   -      $   -
                                                              $   -       $   -      $   -
                                                              $   -       $   -      $   -
                                                              $   -       $   -      $   -
                                                  $   -       $   -       $   -      $   -




Total Intangible Costs                                    0           0
Inflation Index:       3.10%

           2007    Total Cost




    $       -      $       -
    $       -      $       -
    $       -      $       -
    $       -      $       -
    $       -      $       -
    $       -      $       -
    $       -      $       -
    $       -      $       -
    $       -      $       -
    $       -      $       -
    $       -      $       -
    $       -      $       -
    $       -      $       -
    $       -      $       -
    $       -      $       -




                                        0
                                0   0   0
Balanced Scorecard                                                                          Inflation Index:       3.10%
Details of Expected Benefits
                  Cost Description                 2003        2004        2005          2006          2007    Total Cost

Tangible Benefits
Reduced staffing costs                      $      500    $     516   $     531   $       548   $       565    $     2,660
Reduced non-staff operational costs                       $     -     $     -     $       -     $       -      $       -
More effective use of staff resources       $   250,000   $ 257,750   $ 265,740   $   273,978   $   282,472    $ 1,329,940
Saving from business process improvements   $   500,000   $ 515,500   $ 531,481   $   547,956   $   564,943    $ 2,659,880
Decreased cost of services provided                       $     -     $     -     $       -     $       -      $       -
Increased services                                        $     -     $     -     $       -     $       -      $       -
Other (specify details)                                   $     -     $     -     $       -     $       -      $       -



Total Tangible Benefits                     $   750,500   $ 773,766   $ 797,752   $   822,483   $   847,980    $ 3,992,480


Revenues (specify)                          $ 1,500,000   ######### $ 1,500,000   $ 1,500,000   $ 1,500,000    $ 7,500,000

Cost Avoidance (specify)                                                                                       $       -

Other (specify)                                                                                                $       -
Balanced Scorecard                                                                     Inflation Index:       3.10%
Intangible Benefits
                      Cost Description                2003       2004       2005       2006       2007    Total Cost
Note: In addition to the intangible costs there
      will be a number of intangible benefits.
      List the intangible benefits
      below and explain the cost savings.
      Attach the details if necessary.
                                                             $   -      $   -      $   -      $    -      $       -
                                                             $   -      $   -      $   -      $    -      $       -
                                                             $   -      $   -      $   -      $    -      $       -
                                                             $   -      $   -      $   -      $    -      $       -
                                                             $   -      $   -      $   -      $    -      $       -
                                                             $   -      $   -      $   -      $    -      $       -
                                                             $   -      $   -      $   -      $    -      $       -
                                                             $   -      $   -      $   -      $    -      $       -
Total Intangible Benefits                         $   -      $   -      $   -      $   -      $    -      $       -

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:805
posted:8/10/2012
language:English
pages:8