BUS-470-RS-CostBenefitAnalysis-SolutionEvaluation.xlsx

Descriptors

Definitions:

Payback period – the period of time, expressed in months, that a project requires to recover the money invested in it (including the one-time savings which are often excluded by some calculators)

Benefit-cost ratio – an indicator that is often used to decide whether the benefits of a given project or solution outweigh the actual costs (the higher the ratio the better the investment)

Analysis horizon – the number of months the project is expected to be utilized before replacement or major upgrade

Implementation costs include capital costs (equipment, constructions, etc.), training, travel, outside professionals, lost of productivity during implementation & training, implementation costs such as installation, etc.

Ongoing costs include maintenance costs (monthly costs relating to the ongoing maintenance) and operational cost (internal labor, expendables, materials, supplies, etc.)

Hard savings – the direct benefits that affect the bottom line and can directly improve the financial performance of the organization (examples are: sales/price increase, cost reduction and productivity savings)

Soft savings – the indirect benefits which are difficult measure (they are mainly improved yield of a business process, the increased stakeholder satisfaction and the increased safety in the workplace)

One-time savings – examples are value of inventory reduction and sale of unneeded assets

Example

	Call Center
					$, hours, units	E.g.: $/unit	$	Year-1/partial year	Year-2	Year-3
				Cost/Benefit	Unit	Entry/Quantity	Final/Total	Description
	Project Title	COSTS		Implementation costs (one time)			8,000
	CRM Rules for CCR Quality		1	Update rules in CRM			8,000	Cost to update rules
	Solution Title/Description		2
			3
	Sponsor		4
	CC Manager			Ongoing costs (monthly)			0
	Project Manager		1
	J Doe		2
	Timeframe for CBA (in months)		3
	12		4
	Estimated cost/savings year one (maximum 12)			>>>Total Costs (monthly)			667	3,333	11,333	19,333
	5	BENEFITS		Hard and soft savings (monthly)			1,200
	Average labor cost (hourly / daily)		1	Saving from reduced calls	Calls	5000	1,000
	$23.00		2	Saving from reduced QC	QC	500	200
	Assumptions/Comments		3
1			4
2				Savings (one time)			0
3			1
4			2
5			3
6			4
7				>>>Total benefits (monthly)			1,200	6,000	20,400	34,800
Benefit-cost ratio		1.80		667	Monthly payback	Net cash flow	Net gains	2,667	9,067	15,467
Monthly payback period		6.7		0	6.7	1,200	ROI		80.0%

Cost Benefit Analysis

					$, hours, units	E.g.: $/unit	$	Year-1/partial year	Year-2	Year-3
				Cost/Benefit	Unit	Entry/Quantity	Final/Total	Description
	Project Title	COSTS		Implementation costs (one time)
			1
	Solution Title/Description		2
			3
	Sponsor		4
	CC Manager			Ongoing costs (monthly)			0
	Project Manager		1
	J Doe		2
	Timeframe for CBA (in months)		3
			4
	Estimated cost/savings year one (maximum 12)			>>>Total Costs (monthly)
	5	BENEFITS		Hard and soft savings (monthly)			0
	Average labor cost (hourly / daily)		1			5000
			2			500
	Assumptions/Comments		3
1			4
2				Savings (one time)			0
3			1
4			2
5			3
6			4
7				>>>Total benefits (monthly)
Benefit-cost ratio					Monthly payback	Net cash flow	Net gains
Monthly payback period						0	ROI

BUS-470-RS-CostBenefitAnalysis-SolutionEvaluation.xlsx

BUS-470-RS-CostBenefitAnalysis-SolutionEvaluation.xlsx

Descriptors

Example

Cost Benefit Analysis

Related posts

HW