Cost_benefit_analysis.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Cost_benefit_analysis.xlsx as PDF for free.
More details
- Words: 216
- Pages: 1
Cost Benefit Analysis
You need only to fill the white and yellow cells (start with the yellow cells). Cost/Benefit Project/solution title C Implementation costs (one time) O 1 S 2 Description T S 3 4 Sponsor Ongoing costs (monthly) 1 Financial analyst
First year months (maximum 12)
Assumptions/Comments 1 2 3 4 5 6 7
E.g.: $/unit Entry/Quantity
$
Final/Total 0
Year-1 / partial year Description
Year-2
Year-3
0
2 3 4
Analysis horizon (in months)
Average labor cost (hourly or daily)
$, hours or units Unit
B E N E F I T S
>>>Total Costs (monthly) Hard and soft savings (monthly)
0
Savings (one time)
0
1 2 3 4 1 2 3 4
>>>Total benefits (monthly) Benefit-cost ratio Monthly payback period
Monthly payback
Net cash flow
0
Net gains ROI
Guidelines: This worksheet allows to comparing among several solutions or projects to select the one that offers the greatest return against the cost of implementation. 1st: Select only those projects that show the greatest potential.
2nd: Brainstorm the costs and benefits of each project.
3rd: Fill out the details in a worksheet per alternative including the analysis horizon that you think appropriate. Continuous Improvement Toolkit . www.citoolkit.com
4th: Compare the alternatives using either the payback period or the benefits-cost ratio.
You need only to fill the white and yellow cells (start with the yellow cells). Cost/Benefit Project/solution title C Implementation costs (one time) O 1 S 2 Description T S 3 4 Sponsor Ongoing costs (monthly) 1 Financial analyst
First year months (maximum 12)
Assumptions/Comments 1 2 3 4 5 6 7
E.g.: $/unit Entry/Quantity
$
Final/Total 0
Year-1 / partial year Description
Year-2
Year-3
0
2 3 4
Analysis horizon (in months)
Average labor cost (hourly or daily)
$, hours or units Unit
B E N E F I T S
>>>Total Costs (monthly) Hard and soft savings (monthly)
0
Savings (one time)
0
1 2 3 4 1 2 3 4
>>>Total benefits (monthly) Benefit-cost ratio Monthly payback period
Monthly payback
Net cash flow
0
Net gains ROI
Guidelines: This worksheet allows to comparing among several solutions or projects to select the one that offers the greatest return against the cost of implementation. 1st: Select only those projects that show the greatest potential.
2nd: Brainstorm the costs and benefits of each project.
3rd: Fill out the details in a worksheet per alternative including the analysis horizon that you think appropriate. Continuous Improvement Toolkit . www.citoolkit.com
4th: Compare the alternatives using either the payback period or the benefits-cost ratio.
More Documents from "vanessa adriano"
Views Of A Person...
June 2020 6
Cost_benefit_analysis.xlsx
December 2019 5
Tarea-1-de- Auditoria -2.docx
June 2020 10
S Clemente Maria Hofbauer
May 2020 7