System analysis and design

profilejackal
project1.xlsx

Sheet1

Benefits
Insurance Saving 200 200 200 200 200
Storage saving 8000 8000 8000 8000 8000
Satff Reduction 1000 1000 1000 1000 1000
Increased Business 2000 2120 2247 2382 2525
Faster Processing 1100 1100 1100 1100 1100
Total Benefits 12300 12420 12547 12682 12825
PV OF BENEFITS 11827 11483 11154 10841 10541
PV OF ALL BENEFITS 11827 23310 34464 45305 55846 55846
1 server 3000 0 0 0 0
2 New Workstation @1250 2500 0 0 0 0
1 Print / Fax / Copier Machine 1200 0 0 0 0
1 Server Software 300 0 0 0 0
2 Workstation Software @ 250 500 0 0 0 0
Development Labor 9000 0 0 0 0
TOTAL DEVELOPMENT COST 16500 0 0 0 0
HARDWARE 950 974 998 1023 1049
SOFTWARE 450 461 473 485 497
OPERATIONAL COST 1500 1538 1576 1615 1656
TOTAL OPERATIONAL COST 2900 2973 3047 3123 3201
TOTAL COST 19400 2973 3047 3123 3201
PV OF COSTS 18654 2748 2709 2670 2631
PV OF ALL COSTS 18654 21402 24111 26780 29411 29411
TOTAL PROJECT BENEFITS - COST (7100) 9448 9500 9559 9624
YEARLY NPV (6827) 8735 8446 8171 7910
CUMLATIVE NPV (6827) 1908 10354 18525 26435
RETURN ON INVESTMENT 89.88%
BREAK EVEN POINT 1.78
INTANGIBLE BENEFITS