Project plan - Risk assessment - Cost-Benefit Analysis

profileSHAN10
CostBenefitAnalysisTemplate.xlsx
Home>Information Systems homework help>Project plan - Risk assessment - Cost-Benefit Analysis

Simple Cost Benefit Analysis

SIMPLE COST BENEFIT ANALYSIS TEMPLATE
COMPANY NAME DATE CONDUCTED
PROPOSED PRODUCT/INITIATIVE/SERVICE COMPLETED BY
QUANTITATIVE ANALYSIS YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 TOTAL
NON-RECURRING COSTS
Hardware $ 100,000.00 $ 20,000.00 $ 20,000.00 $ 20,000.00 $ 20,000.00 $ 180,000.00
Servers $ 15,000.00 $ 15,000.00
Desktop $ 20,000.00 $ 20,000.00
Telecommunication Equipment $ 10,000.00 $ 10,000.00
Software (Packaged or Custom) $ 50,000.00 $ 50,000.00
Computer Room Upgrades $ 2,000.00 $ 2,000.00
Furniture and Fixtures $ - 0
Project Organizational/Support Costs $ - 0
Planning (upon Approval) $ - 0
Procurement $ - 0
Contract Negotiations $ - 0
Labor $ - 0
Infrastructure $ - 0
Development $ - 0
Business Process Owners (Users) $ - 0
Management $ - 0
Training of Employees (Pre-Implementation) $ - 0
Transition Costs (Parallel Systems) $ - 0
Post-Implementation Reviews $ - 0
TOTAL NON-RECURRING COSTS $ 197,000.00 $ 20,000.00 $ 20,000.00 $ 20,000.00 $ 20,000.00 $ 277,000.00
RECURRING COSTS
Hardware/Software $ - 0
Software Maintenance and Upgrades $ - 0
Computer Supplies $ - 0
Desktops (Incremental to the Project) $ - 0
Help Desk Support $ - 0
Ongoing Additional Labor $ - 0
IT Staff Costs (including Benefits) $ - 0
User Training $ - 0
Other $ - 0
Telecommunications $ - 0
Office Leases $ - 0
TOTAL RECURRING COSTS $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
TOTAL COSTS $ 197,000.00 $ 20,000.00 $ 20,000.00 $ 20,000.00 $ 20,000.00 $ 277,000.00
QUANTITATIVE BENEFITS YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 TOTAL
REVENUES
(Enter Revenue Sources Here) $ 20,000.00 $ 40,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 210,000.00
$ - 0
$ - 0
TOTAL REVENUES $ 20,000.00 $ 40,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 210,000.00
COST SAVINGS
Decreased Cost of Services Provided $ - 0
Savings from Business Process Improvements $ - 0
Productivity Gains $ - 0
Savings from Structural Changes $ - 0
Savings from Optimized Information (or Flow) $ - 0
Decreased Information Publishing Cost $ - 0
Reduced Staffing Cost (including Overtime) $ - 0
Reduced Staff Turnover Costs $ - 0
TOTAL COST SAVINGS $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
COST AVOIDANCE
(Enter Cost Avoidance Here) $ - 0
$ - 0
TOTAL COST AVOIDANCE $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
OTHER BENEFITS
(Enter Other Benefits Here) $ - 0
$ - 0
TOTAL OTHER BENEFITS $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
TOTAL BENEFITS $ 20,000.00 $ 40,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 210,000.00
CLICK HERE TO CREATE SIMPLE COST BENEFIT ANALYSIS TEMPLATES IN SMARTSHEET
https://goo.gl/pht2iA

Analysis Summary

SIMPLE COST BENEFIT ANALYSIS TEMPLATE
QUANTITATIVE ANALYSIS YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 TOTAL
BENEFITS
COST SAVINGS $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
COST AVOIDANCE $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
REVENUE $ 20,000.00 $ 40,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 210,000.00
OTHER $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
TOTAL BENEFITS $ 20,000.00 $ 40,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 210,000.00
ACCUMULATED BENEFITS $ 20,000.00 $ 60,000.00 $ 110,000.00 $ 160,000.00 $ 210,000.00
COSTS
NON-RECURRING $ 197,000.00 $ 20,000.00 $ 20,000.00 $ 20,000.00 $ 20,000.00 $ 277,000.00
RECURRING $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
TOTAL COSTS $ 197,000.00 $ 20,000.00 $ 20,000.00 $ 20,000.00 $ 20,000.00 $ 277,000.00
ACCUMULATED COSTS $ 197,000.00 $ 217,000.00 $ 237,000.00 $ 257,000.00 $ 277,000.00
NET BENEFIT OR COST $ (177,000.00) $ 20,000.00 $ 30,000.00 $ 30,000.00 $ 30,000.00 $ (67,000.00)

Cost Benefit Analysis

ACCUMULATED BENEFITS 20000 60000 110000 160000 210000 ACCUMULATED COSTS 197000 217000 237000 257000 277000