Cost_Benefit_ClassExample.xlsx

Fig2_6

Benefit & Cost example
20152016201720182019Total
Benefits
Increased sales500,000530,000561,800595,508631,238
Reduction in Customer complaint calls70,00070,00070,00070,00070,000
Reduced inventory cost68,00068,00068,00068,00068,000
Total Benefits638,000668,000699,800733,508769,238
PV of Benefits$619,417.48$629,654.07$640,416.13$651,712.36$663,551.46$3,204,751.49
PV of all Benefits$619,417.48$1,249,071.54$1,889,487.68$2,541,200.03$3,204,751.49
Costs
Development Costs
2 servers@125,000250000
Printer100000
Software licenses34825
server software10945
Development labor1236525
Total Development costs16322950000
Operational Costs
Hardware5400081,26181,26181,26181,261
Software2000020,00020,00020,00020,000
Operational labor111788116,260120910125746130776
Total Operational Costs185788217521222171227007232037
Total Costs:1818083217521222171227007232037
PV of Costs$1,765,129.13$205,034.40$203,317.94$201,692.78$200,157.15
PV of all Costs$1,765,129.13$1,970,163.53$2,173,481.47$2,375,174.25$2,575,331.40
Benefit-Cost Analysis
Total Project Benefits and Costs($1,180,083.00)$450,479.00$477,629.00$506,501.00$537,201.00
Yearly NPV($1,145,711.65)$424,619.66$437,098.20$450,019.58$463,394.30$629,420.09
Cumulative NPV($1,145,711.65)($721,091.99)($283,993.79)$166,025.79$629,420.09
Return on Investment24.44%
Break-even point3.63in year 4
Intangible benefitThis service is currently provided by competitions
Improved customer satisfaction

Benefit-Cost

PV of all Benefits619417.475728155351249071.54302950321889487.67624484442541200.03378738563204751.4898694912PV of all Costs1765129.12621359221970163.53096427542173481.46856442652375174.2478506232575331.4023527713