Tutorial

COMPANY NAME

TeamOne

PROPOSED PRODUCT/INITIATIVE/SERVICE

Cloud Migration, Legacy items

QUANTITATIVE ANALYSIS

YEAR 1

YEAR 2

NON-RECURRING COSTS

Hardware

$15,000.00

$7,000.00

Servers

$ 24,720.72

$ 3,002.77

Desktop

$15,500.82

$ 3,150.63

Telecommunication Equipment

$ 6,653.94

$ -

Software (Packaged or Custom)

Computer Room Upgrades

$ -

$ -

Furniture and Fixtures

$ -

$ -

Project Organizational/Support Costs

$ 35,000.00

$ -

Planning (upon Approval)

$ 25,000.00

$ -

Procurement

$ 40,000.00

$ -

Contract Negotiations

$ 30,000.00

$ -

Labor

$ 300,000.00

$ -

Infrastructure

$ 100,000.00

$ -

Development

$ 80,000.00

$ -

Business Process Owners (Users)

$ 70,000.00

$ -

Management

$ 75,000.00

$ -

Training of Employees (Pre-Implementation)

$ 10,016.00

$ -

Transition Costs (Parallel Systems)

$ 27,400.00

$ -

Post-Implementation Reviews

$ -

$ 10,000.00

TOTAL NON-RECURRING COSTS

$ 854,291.48

$ 23,153.40

RECURRING COSTS

Hardware/Software

$ 18,987.24

Software Maintenance and Upgrades

$ 2,400.00

$ 2,400.00

Computer Supplies

Desktops (Incremental to the Project)

Help Desk Support

$ 5,340.00

Ongoing Additional Labor

IT Staff Costs (including Benefits)

$ 25,000.00

$ 13,500.00

User Training

$ 10,000.00

$ 2,500.00

Other

Telecommunications

$ 5,000.00

$ 5,000.00

Office Leases

TOTAL RECURRING COSTS

$ 66,727.24

$ 23,400.00

TOTAL COSTS

$ 921,018.72

$ 46,553.40

QUANTITATIVE BENEFITS

YEAR 1

YEAR 2

REVENUES

Reduced processing errors

$ 20,000.00

$ 40,000.00

Streamlined business process

$ 45,000.00

$ 55,000.00

TOTAL REVENUES

$ 65,000.00

$ 95,000.00

COST SAVINGS

Decreased Cost of Services Provided

$ -

$ 8,250.00

Savings from Business Process Improvements

$ -

$ 17,250.00

Productivity Gains

$ -

$ 4,128.00

Savings from Structural Changes

$ -

$ 5,712.00

Savings from Optimized Information (or Flow)

$ -

Decreased Information Publishing Cost

$ -

Reduced Staffing Cost (including Overtime)

$ -

$ 100,000.00

Reduced Staff Turnover Costs

$ -

$ 31,000.00

TOTAL COST SAVINGS

$ -

$ 166,340.00

COST AVOIDANCE

Procurement Cost Avoidance

$ 15,000.00

$ -

TOTAL COST AVOIDANCE

$ 15,000.00

$ -

OTHER BENEFITS

(Enter Other Benefits Here)

TOTAL OTHER BENEFITS

$ -

$ -

TOTAL BENEFITS

$ 80,000.00

$ 261,340.00

DATE CONDUCTE

12/2/2020

COMPLETED BY

Jay P, Connor S

YEAR 3

YEAR 4

YEAR 5

TOTAL

$5,500.00

$2,200.00

$2,200.00

$ 31,900.00

$ 3,002.77

$ 3,002.77

$ 3,002.77

$ 36,731.80

$ 3,150.63

$ 3,150.63

$ 3,150.63

$ 28,103.34

$ -

$ -

$ -

$ 6,653.94

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ -

$ 35,000.00

$ -

$ -

$ -

$ 25,000.00

$ -

$ -

$ -

$ 40,000.00

$ -

$ -

$ -

$ 30,000.00

$ -

$ -

$ -

$ 300,000.00

$ -

$ -

$ -

$ 100,000.00

$ -

$ -

$ -

$ 80,000.00

$ -

$ -

$ -

$ 70,000.00

$ -

$ -

$ -

$ 75,000.00

$ -

$ -

$ -

$ 10,016.00

$ -

$ -

$ -

$ 27,400.00

$ -

$ -

$ -

$ 10,000.00

$ 11,653.40

$ 8,353.40

$ 8,353.40

$ 905,805.08

$ 18,987.24

$ 2,400.00

$ 2,400.00

$ 2,400.00

$ 12,000.00

$ 50,000.00

$ 50,000.00

$ -

$ 5,340.00

$ -

$ 7,500.00

$ 5,000.00

$ 2,500.00

$ 53,500.00

$ 2,500.00

$ 2,500.00

$ 2,500.00

$ 20,000.00

$ -

$ 5,000.00

$ 5,000.00

$ 5,000.00

$ 25,000.00

$ -

$ 67,400.00

$ 14,900.00

$ 12,400.00

$ 184,827.24

$ 79,053.40

$ 23,253.40

$ 20,753.40

$ 1,090,632.32

YEAR 3

YEAR 4

YEAR 5

TOTAL

$ 50,000.00

$ 50,000.00

$ 50,000.00

$ 210,000.00

$ 60,000.00

$ 60,000.00

$ 60,000.00

$ 280,000.00

$ -

$ 110,000.00

$ 110,000.00

$ 110,000.00

$ 490,000.00

$ 3,730.00

$ 3,100.00

$ 3,100.00

$ 18,180.00

$ 10,250.00

$ 7,250.00

$ 7,250.00

$ 42,000.00

$ 4,829.00

$ 5,374.00

$ 5,926.00

$ 20,257.00

$ 5,712.00

$ 5,712.00

$ 5,712.00

$ 22,848.00

$ -

$ -

$ 110,000.00

$ 120,000.00

$ 130,000.00

$ 460,000.00

$ 15,000.00

$ 7,500.00

$ 7,500.00

$ 61,000.00

$ 149,521.00

$ 148,936.00

$ 159,488.00

$ 624,285.00

$ -

$ -

$ -

$ 15,000.00

$ -

$ -

$ -

$ -

$ 15,000.00

$ -

$ -

$ -

$ -

$ -

$ -

$ 259,521.00

$ 258,936.00

$ 269,488.00

$ 1,129,285.00

QUANTITATIVE ANALYSIS

YEAR 1

YEAR 2

YEAR 3

BENEFITS

COST SAVINGS

$ -

$ 166,340.00

$ 149,521.00

COST AVOIDANCE

$ 15,000.00

$ -

$ -

REVENUE

$ 65,000.00

$ 95,000.00

$ 110,000.00

OTHER

$ -

$ -

$ -

TOTAL BENEFITS

$ 80,000.00

$ 261,340.00

$ 259,521.00

ACCUMULATED BENEFITS

$ 80,000.00

$ 341,340.00

$ 600,861.00

COSTS

NON-RECURRING

$ 854,291.48

$ 23,153.40

$ 11,653.40

RECURRING

$ 66,727.24

$ 23,400.00

$ 67,400.00

TOTAL COSTS

$ 921,018.72

$ 46,553.40

$ 79,053.40

ACCUMULATED COSTS

$ 921,018.72

$ 967,572.12

$ 1,046,625.52

NET BENEFIT OR COST

$ (841,018.72)

$ 214,786.60

$ 180,467.60

YEAR 4

YEAR 5

TOTAL

$ 148,936.00

$ 159,488.00

$ 624,285.00

$ -

$ -

$ 15,000.00

$ 110,000.00

$ 110,000.00

$ 490,000.00

$ -

$ -

$ -

$ 258,936.00

$ 269,488.00

$ 1,129,285.00

$ 859,797.00

$ 1,129,285.00

$ 8,353.40

$ 8,353.40

$ 905,805.08

$ 14,900.00

$ 12,400.00

$ 184,827.24

$ 23,253.40

$ 20,753.40

$ 1,090,632.32

$ 1,069,878.92

$ 1,090,632.32

$ 235,682.60

$ 248,734.60

$ 38,652.68