Signature Assignment: Project Plan WK 6

profilecoreygarrett123
CMGT545Wk3Group1CostBenefitAnalysis.xlsx
Home>Information Systems homework help>Signature Assignment: Project Plan WK 6

Simple Cost Benefit Analysis

SIMPLE COST BENEFIT ANALYSIS TEMPLATE
COMPANY NAME Intuit Inc DATE CONDUCTED 1/27/21
PROPOSED PRODUCT/INITIATIVE/SERVICE Cloud-Based Applications Project COMPLETED BY Team 1
QUANTITATIVE ANALYSIS YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 TOTAL
NON-RECURRING COSTS
Hardware $ 150,000.00 $ 150,000.00
Servers $ 30,000.00 $ 30,000.00
Desktop $ 18,500.00 $ 18,500.00
Telecommunication Equipment $ 10,000.00 $ 10,000.00
Software (Packaged or Custom) $ 100,000.00 $ 100,000.00
Computer Room Upgrades $ 3,200.00 $ 3,200.00
Furniture and Fixtures $ 2,000.00 $ 2,000.00
Project Organizational/Support Costs $ 2,500.00 $ 2,500.00
Planning (upon Approval) $ 1,000.00 $ 1,000.00
Procurement $ 25,000.00 $ 25,000.00
Contract Negotiations $ 2,500.00 $ 2,500.00
Labor $ 80,000.00 $ 80,000.00
Infrastructure $ 11,000.00 $ 11,000.00
Development $ 6,500.00 $ 6,500.00
Business Process Owners (Users) $ 5,000.00 $ 5,000.00
Management $ 8,000.00 $ 8,000.00
Training of Employees (Pre-Implementation) $ 50,000.00 $ 2,000.00 $ 2,000.00 $ 2,000.00 $ 2,000.00 $ 58,000.00
Transition Costs (Parallel Systems) $ 6,200.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 10,200.00
Post-Implementation Reviews $ 10,000.00 $ 10,000.00
TOTAL NON-RECURRING COSTS $ 521,400.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 533,400.00
RECURRING COSTS
Hardware/Software $ 11,000.00 $ 11,000.00 $ 11,000.00 $ 11,000.00 $ 11,000.00 $ 55,000.00
Software Maintenance and Upgrades $ 6,500.00 $ 6,500.00 $ 6,500.00 $ 6,500.00 $ 6,500.00 $ 32,500.00
Computer Supplies $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 5,000.00
Desktops (Incremental to the Project) $ 2,000.00 $ 2,000.00 $ 2,000.00 $ 2,000.00 $ 2,000.00 $ 10,000.00
Help Desk Support $ 8,500.00 $ 8,500.00 $ 8,500.00 $ 8,500.00 $ 8,500.00 $ 42,500.00
Ongoing Additional Labor $ 2,200.00 $ 2,200.00 $ 2,200.00 $ 2,200.00 $ 2,200.00 $ 11,000.00
IT Staff Costs (including Benefits) $ 55,000.00 $ 55,000.00 $ 55,000.00 $ 55,000.00 $ 55,000.00 $ 275,000.00
User Training $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 15,000.00
Other $ 600.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 2,600.00
Telecommunications $ 2,100.00 $ 2,100.00 $ 2,100.00 $ 2,100.00 $ 2,100.00 $ 10,500.00
Office Leases $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 7,500.00
TOTAL RECURRING COSTS $ 93,400.00 $ 93,300.00 $ 93,300.00 $ 93,300.00 $ 93,300.00 $ 466,600.00
TOTAL COSTS $ 614,800.00 $ 96,300.00 $ 96,300.00 $ 96,300.00 $ 96,300.00 $ 1,000,000.00
QUANTITATIVE BENEFITS YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 TOTAL
REVENUES
Sales $ 152,000.00 $ 173,000.00 $ 190,000.00 $ 215,000.00 $ 270,000.00 $ 1,000,000.00
$ - 0
$ - 0
TOTAL REVENUES $ 152,000.00 $ 173,000.00 $ 190,000.00 $ 215,000.00 $ 270,000.00 $ 1,000,000.00
COST SAVINGS
Decreased Cost of Services Provided $ 1,000.00 $ 1,300.00 $ 1,500.00 $ 1,800.00 $ 2,400.00 $ 8,000.00
Savings from Business Process Improvements $ 1,500.00 $ 2,100.00 $ 3,200.00 $ 4,300.00 $ 5,400.00 $ 16,500.00
Productivity Gains $ 1,200.00 $ 1,500.00 $ 2,100.00 $ 2,600.00 $ 3,200.00 $ 10,600.00
Savings from Structural Changes $ 1,300.00 $ 2,200.00 $ 3,200.00 $ 4,500.00 $ 6,000.00 $ 17,200.00
Savings from Optimized Information (or Flow) $ 2,000.00 $ 3,500.00 $ 4,800.00 $ 6,000.00 $ 8,000.00 $ 24,300.00
Decreased Information Publishing Cost $ 1,000.00 $ 1,500.00 $ 2,225.00 $ 3,500.00 $ 5,000.00 $ 13,225.00
Reduced Staffing Cost (including Overtime) $ 1,500.00 $ 1,800.00 $ 2,200.00 $ 2,800.00 $ 3,300.00 $ 11,600.00
Reduced Staff Turnover Costs $ 2,500.00 $ 3,500.00 $ 4,500.00 $ 5,500.00 $ 6,600.00 $ 22,600.00
TOTAL COST SAVINGS $ 12,000.00 $ 17,400.00 $ 23,725.00 $ 31,000.00 $ 39,900.00 $ 124,025.00
COST AVOIDANCE
Data Breach/Loss $ 25,000.00 $ 25,000.00 $ 25,000.00 $ 25,000.00 $ 25,000.00 $ 125,000.00
Server Hardware/Software Upgrades $ 32,000.00 $ 30,000.00 $ 30,000.00 $ 30,000.00 $ 30,000.00 $ 152,000.00
TOTAL COST AVOIDANCE $ 57,000.00 $ 55,000.00 $ 55,000.00 $ 55,000.00 $ 55,000.00 $ 277,000.00
OTHER BENEFITS
Data Security $ 23,000.00 $ 20,000.00 $ 20,000.00 $ 20,000.00 $ 20,000.00 $ 103,000.00
System Maintance $ 12,000.00 $ 15,000.00 $ 15,000.00 $ 15,000.00 $ 15,000.00 $ 72,000.00
TOTAL OTHER BENEFITS $ 35,000.00 $ 35,000.00 $ 35,000.00 $ 35,000.00 $ 35,000.00 $ 175,000.00
TOTAL BENEFITS $ 256,000.00 $ 280,400.00 $ 303,725.00 $ 336,000.00 $ 399,900.00 $ 1,576,025.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 $ 12,000.00 $ 17,400.00 $ 23,725.00 $ 31,000.00 $ 39,900.00 $ 124,025.00
COST AVOIDANCE $ 57,000.00 $ 55,000.00 $ 55,000.00 $ 55,000.00 $ 55,000.00 $ 277,000.00
REVENUE $ 152,000.00 $ 173,000.00 $ 190,000.00 $ 215,000.00 $ 270,000.00 $ 1,000,000.00
OTHER $ 35,000.00 $ 35,000.00 $ 35,000.00 $ 35,000.00 $ 35,000.00 $ 175,000.00
TOTAL BENEFITS $ 256,000.00 $ 280,400.00 $ 303,725.00 $ 336,000.00 $ 399,900.00 $ 1,576,025.00
ACCUMULATED BENEFITS $ 256,000.00 $ 536,400.00 $ 840,125.00 $ 1,176,125.00 $ 1,576,025.00
COSTS
NON-RECURRING $ 521,400.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 533,400.00
RECURRING $ 93,400.00 $ 93,300.00 $ 93,300.00 $ 93,300.00 $ 93,300.00 $ 466,600.00
TOTAL COSTS $ 614,800.00 $ 96,300.00 $ 96,300.00 $ 96,300.00 $ 96,300.00 $ 1,000,000.00
ACCUMULATED COSTS $ 614,800.00 $ 711,100.00 $ 807,400.00 $ 903,700.00 $ 1,000,000.00
NET BENEFIT OR COST $ (358,800.00) $ 184,100.00 $ 207,425.00 $ 239,700.00 $ 303,600.00 $ 576,025.00

Cost Benefit Analysis

ACCUMULATED BENEFITS 256000 536400 840125 1176125 1576025 ACCUMULATED COSTS 614800 711100 807400 903700 1000000