Feasibility
Study Guidelines
|
|
| Policy No: 202-G1 | Also See: 106-P1, 200-P1, 201-S1 |
| Supersedes No: N/A | |
| Effective Date: May 28, 1992 | |
| Revision Date: January 2000 | Definitions |

Maintenance
Technological advances and changes in the business requirements of agencies
will necessitate periodic revisions to policies, standards, and guidelines.
The Department of Information Services is responsible for routine maintenance
of these to keep them current. Major policy changes will require the approval
of the ISB.
Appendix: Cost/Benefit Analysis (CBA) Forms
The Electronic Version:
A Microsoft Excel spreadsheet, 203R.XLS is available through the Internet at:
http://isb.wa.gov/policies/portfolio/203R.xls
The five electronic forms are stored as worksheets in 203R.XLS. The worksheet
function is not available in prior versions of Microsoft Excel and other spreadsheets,
and may be unreadable. Call MOSTD if assistance is needed.
In Microsoft Excel, navigate between sheets by clicking on the Forms tabs in
the lower left of the spreadsheet display. You may need to customize printed
output for your computer configuration. Data input cells in the electronic spreadsheet
are displayed in blue.
(It is strongly recommended that agencies use the Excel spreadsheet provided
by MOSTD. However, if necessary, the forms can be completed manually by carrying
forward the total amounts as instructed below. The last step requires calculation
of the net present value and internal rate of return for the net cash flow of
the proposed project option under analysis. These usually require an automated
tool.)
Forms:
In the Microsoft® Excel version, Form 1 requires entering the fiscal years,
the agency name, the project/option title, and the Cost of Capital (see (7 )
below for accessing the Cost of Capital). Form 2, Form 4, and Form 5 require
input. Form 3 requires no data input. The form labeled Instructions provides
directions on completing the forms.
The forms used to create the CBA are:
Repeat steps 1-8 above for each viable alternative considered to the
current way of doing business.
|
Form 1/ Summary, Cost Benefit and Cash Flow Analysis |
Agency |
Agency Name |
|
Project Title &
Option
|
|
FY |
FY |
FY |
FY |
FY |
FY |
FY |
FY |
FY |
FY |
GRAND |
||
|
2000 |
2001 |
2002 |
2003 |
2004 |
2005 |
2006 |
2007 |
2008 |
2009 |
TOTAL |
||
|
TOTAL OUTFLOWS |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
TOTAL |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
NET CASH |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
||
|
INCREMENTAL NPV |
NA |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
||
|
Cumulative |
NA |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
||
|
Cumulative Benefits |
NA |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
||
|
Cost of Capital
|
Breakeven Period - yrs.*
|
NPV
$ |
IRR %
|
||
|
Non- Discounted
|
Discounted
|
||||
|
6.25%
|
0
|
#NUM!
|
|||
| * - "Non-Discounted" represents breakeven period for cumulative costs and benefits (no consideration of time value of money). | |||||
| * - "Discounted" considers effect of time value of money through incremental Net Present Value. | |||||
|
Form 2/ Project Detail Cost Flow Analysis |
Agency |
Agency Name |
|
Project Title &
Option
|
|
FISCAL COSTS, PROJECT DEVELOPMENT
|
OFM Object Codes |
FY 1997 |
FY 1998 |
FY 1999 |
DEVELOPMENT PHASES |
FY 2003 |
FY 2004 |
FY 2005 |
FY 2006 |
GRAND TOTAL
|
|||
|
FY 2000 |
FY 2001 |
FY 2002 |
|||||||||||
| Salaries and Wages Employee Benefits Personal Service Contracts Communications Hardware Rent/Lease Hardware Maintenance Software Rent/Lease Software Maintenance & Upgrade DP Goods/Services Goods/Services NotListed Travel Hardware Purchase Capitalized Software Purchase Capitalized Hardware Purchase - Non. Cap Software Purchase - Non. Cap Hardware Lease/Purchase Software Lease/Purchase Other (specify) |
(A) |
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|||||
|
TOTAL DEVELOPMENT |
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
Form 3 / Summary, Operations Incremental Cost of Project |
Agency |
Agency Name |
|
Project Title &
Option
|
|
|
FY
2000 |
FY
2001 |
FY
2002 |
FY
2003 |
FY
2004 |
FY
2005 |
FY
2006 |
FY
2007 |
FY
2008 |
FY
2009 |
GRAND
TOTAL |
||||
|
OPERATIONS INCREMENTAL COSTS OF PROJECT (Per Form 4 - Column C) |
|
|
|
|
|
|
|
||||||||
| Salaries and Wages Employee Benefits Personal Service Contracts Communications Hardware Rent/Lease Hardware Maintenance Software Rent/Lease Software Maintenance &Upgrade DP Goods/Services Goods/Services Not Listed Travel Hardware Purchase Capitalized Software Purchase Capitalized Hardware Purchase - Non. Cap Software Purchase - Non. Cap Hardware Lease/Purchase Software Lease/Purchase Other (specify) TOTAL OPERATIONS |
(A) (B) (CA) (EB) (ED) (EE) (ED) (EE) (EL) (E) (G) (JC) (JC) (KA) (KA) (P) (P) ( ) |
0
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|||
|
TOTAL OUTFLOWS CUMULATIVE COSTS |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
||||
|
(1) Total Outflows the sum of Fiscal Total Operations and Total Development from Form 2. |
|
|
|
|
|
|
|
||||||||
|
(2) Total Outflows carried to Form 1 |
|||||||||||||||
|
Form 4/ Current versus Proposed Method Operations Costs |
Agency |
Agency Name |
Project Title &
Option
|
|
|
FY |
1997 |
FY
|
1998 |
FY |
1999 |
FY |
2000 |
FY |
2001 |
|||||||
|
(c) = (b)-(a) Incremental Effect
of Project
|
(c) = (b)-(a) |
(c) = (b)-(a) |
(c) = (b)-(a) |
(c) = (b)-(a) |
||||||||||||
|
(a) |
(b) |
(a) |
(b) |
(a) |
(b) |
(a) |
(b) |
(a) |
(b) |
|||||||
|
OPERATIONS COSTS |
Obj. Codes |
Current |
Project |
(to summary) |
Current |
Project |
(to summary) |
Current |
Project |
(to summary) |
Current |
Project |
(to summary) |
Current |
Project |
(to summary) |
|
Salaries and Wages |
(A) |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Employee Benefits |
(B) |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Personal Service Contracts |
(CA) |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Communications |
(EB) |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Hardware Rent/Lease |
(ED) |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Hardware Maintenance |
(EE) |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Software Rent/Lease |
(ED) |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Software Maintenance & Upgrade |
(EE) |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
DP Goods/Services |
(EL) |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Goods/Services Not Listed |
(E) |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Travel |
(G) |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
||