Signature Assignment: Project Plan WK 6

SIMPLE COST BENEFIT ANALYSIS TEMPLATE

COMPANY NAME Intuit Inc

PROPOSED PRODUCT/INITIATIVE/SERVICE Cloud-Based Applications Project

QUANTITATIVE ANALYSIS YEAR 1 YEAR 2

NON-RECURRING COSTS

Hardware $ 150,000.00

Servers $ 30,000.00

Desktop $ 18,500.00

Telecommunication Equipment $ 10,000.00

Software (Packaged or Custom) $ 100,000.00

Computer Room Upgrades $ 3,200.00

Furniture and Fixtures $ 2,000.00

Project Organizational/Support Costs $ 2,500.00

Planning (upon Approval) $ 1,000.00

Procurement $ 25,000.00

Contract Negotiations $ 2,500.00

Labor $ 80,000.00

Infrastructure $ 11,000.00

Development $ 6,500.00

Business Process Owners (Users) $ 5,000.00

Management $ 8,000.00

Training of Employees (Pre-Implementation) $ 50,000.00 $ 2,000.00

Transition Costs (Parallel Systems) $ 6,200.00 $ 1,000.00

Post-Implementation Reviews $ 10,000.00

TOTAL NON-RECURRING COSTS $ 521,400.00 $ 3,000.00

RECURRING COSTS

Hardware/Software $ 11,000.00 $ 11,000.00

Software Maintenance and Upgrades $ 6,500.00 $ 6,500.00

Computer Supplies $ 1,000.00 $ 1,000.00

Desktops (Incremental to the Project) $ 2,000.00 $ 2,000.00

Help Desk Support $ 8,500.00 $ 8,500.00

Ongoing Additional Labor $ 2,200.00 $ 2,200.00

IT Staff Costs (including Benefits) $ 55,000.00 $ 55,000.00

User Training $ 3,000.00 $ 3,000.00

Other $ 600.00 $ 500.00

Telecommunications $ 2,100.00 $ 2,100.00

Office Leases $ 1,500.00 $ 1,500.00

TOTAL RECURRING COSTS $ 93,400.00 $ 93,300.00

TOTAL COSTS $ 614,800.00 $ 96,300.00

QUANTITATIVE BENEFITS YEAR 1 YEAR 2

REVENUES

Sales $ 152,000.00 $ 173,000.00

TOTAL REVENUES $ 152,000.00 $ 173,000.00

COST SAVINGS

Decreased Cost of Services Provided $ 1,000.00 $ 1,300.00

Savings from Business Process Improvements $ 1,500.00 $ 2,100.00

Productivity Gains $ 1,200.00 $ 1,500.00

Savings from Structural Changes $ 1,300.00 $ 2,200.00

Savings from Optimized Information (or Flow) $ 2,000.00 $ 3,500.00

Decreased Information Publishing Cost $ 1,000.00 $ 1,500.00

Reduced Staffing Cost (including Overtime) $ 1,500.00 $ 1,800.00

Reduced Staff Turnover Costs $ 2,500.00 $ 3,500.00

TOTAL COST SAVINGS $ 12,000.00 $ 17,400.00

COST AVOIDANCE

Data Breach/Loss $ 25,000.00 $ 25,000.00

Server Hardware/Software Upgrades $ 32,000.00 $ 30,000.00

TOTAL COST AVOIDANCE $ 57,000.00 $ 55,000.00

OTHER BENEFITS

Data Security $ 23,000.00 $ 20,000.00

System Maintance $ 12,000.00 $ 15,000.00

TOTAL OTHER BENEFITS $ 35,000.00 $ 35,000.00

TOTAL BENEFITS $ 256,000.00 $ 280,400.00

CLICK HERE TO CREATE SIMPLE COST BENEFIT ANALYSIS TEMPLATES IN SMARTSHEET

SIMPLE COST BENEFIT ANALYSIS TEMPLATE

Intuit Inc DATE CONDUCTE 1/27/2021

Cloud-Based Applications Project COMPLETED BY Team 1

YEAR 3 YEAR 4 YEAR 5 TOTAL

$ 150,000.00

$ 30,000.00

$ 18,500.00

$ 10,000.00

$ 100,000.00

$ 3,200.00

$ 2,000.00

$ 2,500.00

$ 1,000.00

$ 25,000.00

$ 2,500.00

$ 80,000.00

$ 11,000.00

$ 6,500.00

$ 5,000.00

$ 8,000.00

$ 2,000.00 $ 2,000.00 $ 2,000.00 $ 58,000.00

$ 1,000.00 $ 1,000.00 $ 1,000.00 $ 10,200.00

$ 10,000.00

$ 3,000.00 $ 3,000.00 $ 3,000.00 $ 533,400.00

$ 11,000.00 $ 11,000.00 $ 11,000.00 $ 55,000.00

$ 6,500.00 $ 6,500.00 $ 6,500.00 $ 32,500.00

$ 1,000.00 $ 1,000.00 $ 1,000.00 $ 5,000.00

$ 2,000.00 $ 2,000.00 $ 2,000.00 $ 10,000.00

$ 8,500.00 $ 8,500.00 $ 8,500.00 $ 42,500.00

$ 2,200.00 $ 2,200.00 $ 2,200.00 $ 11,000.00

$ 55,000.00 $ 55,000.00 $ 55,000.00 $ 275,000.00

$ 3,000.00 $ 3,000.00 $ 3,000.00 $ 15,000.00

$ 500.00 $ 500.00 $ 500.00 $ 2,600.00

$ 2,100.00 $ 2,100.00 $ 2,100.00 $ 10,500.00

$ 1,500.00 $ 1,500.00 $ 1,500.00 $ 7,500.00

$ 93,300.00 $ 93,300.00 $ 93,300.00 $ 466,600.00

$ 96,300.00 $ 96,300.00 $ 96,300.00 $ 1,000,000.00

YEAR 3 YEAR 4 YEAR 5 TOTAL

$ 190,000.00 $ 215,000.00 $ 270,000.00 $ 1,000,000.00

$ -

$ -

$ 190,000.00 $ 215,000.00 $ 270,000.00 $ 1,000,000.00

$ 1,500.00 $ 1,800.00 $ 2,400.00 $ 8,000.00

$ 3,200.00 $ 4,300.00 $ 5,400.00 $ 16,500.00

$ 2,100.00 $ 2,600.00 $ 3,200.00 $ 10,600.00

$ 3,200.00 $ 4,500.00 $ 6,000.00 $ 17,200.00

$ 4,800.00 $ 6,000.00 $ 8,000.00 $ 24,300.00

$ 2,225.00 $ 3,500.00 $ 5,000.00 $ 13,225.00

$ 2,200.00 $ 2,800.00 $ 3,300.00 $ 11,600.00

$ 4,500.00 $ 5,500.00 $ 6,600.00 $ 22,600.00

$ 23,725.00 $ 31,000.00 $ 39,900.00 $ 124,025.00

$ 25,000.00 $ 25,000.00 $ 25,000.00 $ 125,000.00

$ 30,000.00 $ 30,000.00 $ 30,000.00 $ 152,000.00

$ 55,000.00 $ 55,000.00 $ 55,000.00 $ 277,000.00

$ 20,000.00 $ 20,000.00 $ 20,000.00 $ 103,000.00

$ 15,000.00 $ 15,000.00 $ 15,000.00 $ 72,000.00

$ 35,000.00 $ 35,000.00 $ 35,000.00 $ 175,000.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

SIMPLE COST BENEFIT ANALYSIS TEMPLATE

QUANTITATIVE ANALYSIS YEAR 1 YEAR 2 YEAR 3

BENEFITS

COST SAVINGS $ 12,000.00 $ 17,400.00 $ 23,725.00

COST AVOIDANCE $ 57,000.00 $ 55,000.00 $ 55,000.00

REVENUE $ 152,000.00 $ 173,000.00 $ 190,000.00

OTHER $ 35,000.00 $ 35,000.00 $ 35,000.00

TOTAL BENEFITS $ 256,000.00 $ 280,400.00 $ 303,725.00

ACCUMULATED BENEFITS $ 256,000.00 $ 536,400.00 $ 840,125.00

COSTS

NON-RECURRING $ 521,400.00 $ 3,000.00 $ 3,000.00

RECURRING $ 93,400.00 $ 93,300.00 $ 93,300.00

TOTAL COSTS $ 614,800.00 $ 96,300.00 $ 96,300.00

ACCUMULATED COSTS $ 614,800.00 $ 711,100.00 $ 807,400.00

NET BENEFIT OR COST $ (358,800.00) $ 184,100.00 $ 207,425.00

1 2 3 4 5 $-

$200,000.00

$400,000.00

$600,000.00

$800,000.00

$1,000,000.00

$1,200,000.00

$1,400,000.00

$1,600,000.00

$1,800,000.00

Cost Benefit Analysis

ACCUMULATED BENEFITS ACCUMULATED COSTS

SIMPLE COST BENEFIT ANALYSIS TEMPLATE

YEAR 4 YEAR 5 TOTAL

$ 31,000.00 $ 39,900.00 $ 124,025.00

$ 55,000.00 $ 55,000.00 $ 277,000.00

$ 215,000.00 $ 270,000.00 $ 1,000,000.00

$ 35,000.00 $ 35,000.00 $ 175,000.00

$ 336,000.00 $ 399,900.00 $ 1,576,025.00

$ 1,176,125.00 $ 1,576,025.00

$ 3,000.00 $ 3,000.00 $ 533,400.00

$ 93,300.00 $ 93,300.00 $ 466,600.00

$ 96,300.00 $ 96,300.00 $ 1,000,000.00

$ 903,700.00 $ 1,000,000.00

$ 239,700.00 $ 303,600.00 $ 576,025.00

1 2 3 4 5 $-

$200,000.00

$400,000.00

$600,000.00

$800,000.00

$1,000,000.00

$1,200,000.00

$1,400,000.00

$1,600,000.00

$1,800,000.00

Cost Benefit Analysis

ACCUMULATED BENEFITS ACCUMULATED COSTS