View
215
Download
0
Category
Preview:
Citation preview
8/20/2019 LIFE CICLE COST
1/73
Life Cycle Cost Tool
This workbook forms part of AKMX's approach to Advanced Life Cycle Asset Management.
Background:
Aim: Assist the evaluation of project options by the typical asset manager by facilitating li
Available Workshe This spreadsheet provides si types of worksheets based !pon !ser inp!ts and associated o!tp!ts"
Instruction: #. $elect The %ro&ect asics sheet( complete the details for the pro&ect and for each option being consi
). Complete the relevant sections of the Costs sections for each option( on the respective sheet.
*. +eview the s!mmary data at the bottom of each option sheet.
,. +eview the $!mmary Analysis( Average Costs Chart( and LCC Comparison Chart sheets to review all
-. +ecommend activities which can be !ndertaken to provide the greatest improvement.
Denitions:
This spreadsheet provides a framework within which life cycle costs associated with a pro&ect can be davailable thro!gh this Tool has been set at level )( meaning that it is more than a basic framework moaltho!gh it can accomodate an !nlimited level of detail sho!ld the !ser with to modify the layo!t by a
HELP 0 1isc!sses and o!tlines the ma&or components of this spreadsheet
Project Basics 0 Characteri2es the pro&ect and options being analy2ed( incl!ding epected start date
Options 0 A standardi2ed sheet is available for each pro&ect option to doc!ment costs note" the !ser
Project Analysis Summary 0 a s!mmary presentation of the vario!s options developed in the Tool
Average Annual Costs Chart 0 a s!mmary graphic depiction of the average ann!ali2ed and ann!iti2
LCC Comparison Chart 0 4!tlines the life cycle costs derived for this option
against each other. life of treatments considered for an option.
LCC 0 Life Cycle Cost
8/20/2019 LIFE CICLE COST
2/73
Life Cycle Cost Tool
PROEC! "E!A#LS
roject !itle: 6ew 7ltrasonic 8elding Machine
roject "o:
Analyst#s$: 9es!s :eli( 9!an %ere2(
Date: $eptember );( )
8/20/2019 LIFE CICLE COST
3/73
Life Cycle Cost Tool
PROEC! "E!A#LS
roject !itle: 6ew 7ltrasonic 8elding Machine
roject "o: <
Analyst#s$: 9es!s :eli( 9!an %ere2(
Date: $eptember );( )
8/20/2019 LIFE CICLE COST
4/73
OP!#O% "E!A#LS
Description: $h!nk
%ption "umber: #
B'( La7or Associate
B') La7or 0 Overtime
B'* "irect Supplies Tooling replacement after #
8/20/2019 LIFE CICLE COST
5/73
OP!#O% "E!A#LS
Description: $h!nk
%ption "umber: #
$pares
Labor technician
1owntime
$pares :il ters/
Labor technician
Dibration Analysys
Labor technician
D. *ene?al 0osts
"'( ;ajor repair Change Eenerator
"') Re,ur7ishment
. a n enance0osts
The maintenance costs cover all the costs associated with ongoinInclude basic rehabilitation costs in this item.
C'( Corrective ;aintenance
C') Preventativemaintenance
C'* Predictive maintenance
Include anticipated major repair ( repair not funded through Maintcosts in this item if relevant to the analysis show in t he year e!pdebt service as relevant.
8/20/2019 LIFE CICLE COST
6/73
OP!#O% "E!A#LS
Description: $h!nk
%ption "umber: #
(. Disposal 0osts "osts associated with disposal of the asset at the end of the desiE'( Cost o, Asset "isposal
E') Salvage
8/20/2019 LIFE CICLE COST
7/73
OP!#O% "E!A#LS
Description: $h!nk
%ption "umber: #
!otal 0osts:
@ !otal 0osts:
0umulative 0osts:ears of Analysis: 6!mber of years of analysis.
Total Costs G 6!mber of years of an
Annuiti/ed 0ost 1tream: Ann!ity of %D disco!nt rate is !se
CHAR! "A!A
S8;;AR= CHAR!
Average Annuali/ed 0osts#+ndiscounted$:
Average Annuali/ed 0osts#Discounted$:
%D of Total Costs G 6!mber of years
)
8/20/2019 LIFE CICLE COST
8/73
NA NA NA NA NA NA NA NA NA
0 0 0 0 0 0 0 0 0
8/20/2019 LIFE CICLE COST
9/73
8/20/2019 LIFE CICLE COST
10/73
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
8/20/2019 LIFE CICLE COST
11/73
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
8/20/2019 LIFE CICLE COST
12/73
0 0 0 0 0 0
0 0 0 0 0 0
0 -,
8/20/2019 LIFE CICLE COST
13/73
Life Cycle Cost Tool
PROEC! "E!A#LS
roject !itle: 6ew 7ltrasonic 8elding Machine
roject "o: <
Analyst#s$: 9es!s :eli( 9!an %ere2(
Date: $eptember );( )
8/20/2019 LIFE CICLE COST
14/73
OP!#O% "E!A#LS
Description: Telsonic
%ption "umber: )
B'( La7or Associate
B') La7or 0 Overtime
B'* "irect Supplies Tool ing replacement after #
8/20/2019 LIFE CICLE COST
15/73
OP!#O% "E!A#LS
Description: Telsonic
%ption "umber: )
$pares
Labor technician
1owntime
$pares :il ters/
Labor technician
Dibration Analysys
Labor technician
D. *ene?al 0osts
"'( ;ajor repair
"') Re,ur7ishment
.0osts
The maintenance costs cover all the costs associated with ongoinInclude basic r ehabilitation and renewal costs in this item.
C'( Corrective ;aintenance
C') Preventativemaintenance
C'* Predictive maintenance
Include anticipated major repair ( repair not funded through Maintcosts in this item if relevant to the analysis ( seeTool, $tep % &o! %e!pected if s ingle di sbursement or as debt service as relevant.
8/20/2019 LIFE CICLE COST
16/73
OP!#O% "E!A#LS
Description: Telsonic
%ption "umber: )
(. Disposal 0osts "osts associated with disposal of the asset at the end of the desiE'( Cost o, Asset "isposal
E') Salvage
8/20/2019 LIFE CICLE COST
17/73
OP!#O% "E!A#LS
Description: Telsonic
%ption "umber: )
!otal 0osts:
@ !otal 0osts:
0umulative 0osts:ears of Analysis: 6!mber of years of analysis.
Total Costs G 6!mber of years of an
Annuiti/ed 0ost 1tream: Ann!ity of %D disco!nt rate is !se
CHAR! "A!A
S8;;AR= CHAR!
Average Annuali/ed 0osts#+ndiscounted$:
Average Annuali/ed 0osts#Discounted$:
%D of Total Costs G 6!mber of years
)
8/20/2019 LIFE CICLE COST
18/73
NA NA NA NA NA NA NA NA NA
0 0 0 0 0 0 0 0 0
8/20/2019 LIFE CICLE COST
19/73
8/20/2019 LIFE CICLE COST
20/73
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
8/20/2019 LIFE CICLE COST
21/73
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
8/20/2019 LIFE CICLE COST
22/73
0 0 0 0 0 0
0 0 0 0 0 0
0 -**(,
8/20/2019 LIFE CICLE COST
23/73
Life Cycle Cost Tool
PROEC! "E!A#LS
roject !itle: 6ew 7ltrasonic 8elding Machine
roject "o: <
Analyst#s$: 9es!s :eli( 9!an %ere2(
Date: $eptember );( )
8/20/2019 LIFE CICLE COST
24/73
OP!#O% "E!A#LS
Description: ranson
%ption "umber: *
B'( La7or Associate
B') La7or 0 Overtime
B'* "irect Supplies Tool ing replacement after -
8/20/2019 LIFE CICLE COST
25/73
OP!#O% "E!A#LS
Description: ranson
%ption "umber: *
$pares
Labor technician
1owntime
$pares :il ters/
Labor technician
Dibration Analysys
Labor technician
D. *ene?al 0osts
"'( ;ajor repair
"') Re,ur7ishment
.0osts
The maintenance costs cover all the costs associated with ongoinInclude basic rehabilitation and renewal costs in this item.
C'( Corrective ;aintenance
C') Preventativemaintenance
C'* Predictive maintenance
Include anticipated major repair ( repair not funded through Maintcosts in this item if relevant to the analysis ( seeTool, $tep % &o! e!pected if s ingle disbursement or as debt service as relevant.
8/20/2019 LIFE CICLE COST
26/73
OP!#O% "E!A#LS
Description: ranson
%ption "umber: *
(. Disposal 0osts "osts associated with disposal of the asset at the end of the desiE'( Cost o, Asset "isposal
E') Salvage
8/20/2019 LIFE CICLE COST
27/73
OP!#O% "E!A#LS
Description: ranson
%ption "umber: *
!otal 0osts:
@ !otal 0osts:
0umulative 0osts:ears of Analysis: 6!mber of years of analysis.
Total Costs G 6!mber of years of an
Annuiti/ed 0ost 1tream: Ann!ity of %D disco!nt rate is !se
CHAR! "A!A
S8;;AR= CHAR!
Average Annuali/ed 0osts#+ndiscounted$:
Average Annuali/ed 0osts#Discounted$:
%D of Total Costs G 6!mber of years
)
8/20/2019 LIFE CICLE COST
28/73
NA NA NA NA NA NA NA NA NA
0 0 0 0 0 0 0 0 0
8/20/2019 LIFE CICLE COST
29/73
8/20/2019 LIFE CICLE COST
30/73
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
8/20/2019 LIFE CICLE COST
31/73
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
8/20/2019 LIFE CICLE COST
32/73
0 0 0 0 0 0
0 0 0 0 0 0
0 ?**(F
8/20/2019 LIFE CICLE COST
33/73
Life Cycle Cost Tool
PROEC! "E!A#LS
roject !itle: 6ew 7ltrasonic 8elding Machine
roject "o: <
Analyst#s$: 9es!s :eli( 9!an %ere2(
Date: $eptember );( )
8/20/2019 LIFE CICLE COST
34/73
OP!#O% "E!A#LS
Description: <
%ption "umber: <
B'( La7or
B') La7or 0 Overtime
B'* "irect Supplies
B'+ "irect 8tilities
B'. La7or 0 Outsource
B'/ Other Operating Costs
B. %perating 0ostsThe operating costs include all costs associated with the ongoingcommissioned.
8/20/2019 LIFE CICLE COST
35/73
OP!#O% "E!A#LS
Description: <
%ption "umber: <
D. *ene?al 0osts
"'( ;ajor repair
"') Re,ur7ishment
. a n enance0osts
The maintenance costs cover al l the costs associated with ongoinInclude basic r ehabilitation and renewal costs in this item.
C'( Corrective ;aintenance
C') Preventativemaintenance
C'* Predictive maintenance
Include anticipated major repair (repair not funded through Maintcosts in this item if relevant to the analysis ( seeTool, $tep % &o! %e!pected if s ingle disbursement or as debt service as relevant.
8/20/2019 LIFE CICLE COST
36/73
OP!#O% "E!A#LS
Description: <
%ption "umber: <
(. Disposal 0osts "osts associated with disposal of the asset at the end of the desiE'( Cost o, Asset "isposal
E') Salvage
8/20/2019 LIFE CICLE COST
37/73
OP!#O% "E!A#LS
Description: <
%ption "umber: <
!otal 0osts:
@ !otal 0osts:
0umulative 0osts:ears of Analysis: 6!mber of years of analysis.
Total Costs G 6!mber of years of ana
Annuiti/ed 0ost 1tream: Ann!ity of %D disco!nt rate is !sed
CHAR! "A!A
S8;;AR= CHAR!
Average Annuali/ed 0osts#+ndiscounted$:
Average Annuali/ed 0osts#Discounted$:
%D of Total Costs G 6!mber of years
@#
@#
@#
@#
4> 4
8/20/2019 LIFE CICLE COST
38/73
NA NA NA NA NA NA NA NA NA
0 0 0 0 0 0 0 0 0
8/20/2019 LIFE CICLE COST
39/73
8/20/2019 LIFE CICLE COST
40/73
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
8/20/2019 LIFE CICLE COST
41/73
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
8/20/2019 LIFE CICLE COST
42/73
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
F F; FF #
8/20/2019 LIFE CICLE COST
43/73
Life Cycle Cost Tool
PROEC! "E!A#LS
roject !itle: 6ew 7ltrasonic 8elding Machine
roject "o: <
Analyst#s$: 9es!s :eli( 9!an %ere2(
Date: $eptember );( )
8/20/2019 LIFE CICLE COST
44/73
OP!#O% "E!A#LS
Description: <
%ption "umber: <
B'( La7or
B') La7or 0 Overtime
B'* "irect Supplies
B'+ "irect 8tilities
B'. La7or 0 Outsource
B'/ Other Operating Costs
B. %perating 0ostsThe operating costs include all costs associated with the ongoingcommissioned.
8/20/2019 LIFE CICLE COST
45/73
OP!#O% "E!A#LS
Description: <
%ption "umber: <
D. *ene?al 0osts
"'( ;ajor repair
"') Re,ur7ishment
. a n enance0osts
The maintenance costs cover al l the costs associated with ongoinInclude basic r ehabilitation and renewal costs in this item.
C'( Corrective ;aintenance
C') Preventativemaintenance
C'* Predictive maintenance
Include anticipated major repair (repair not funded through Maintcosts in this item if relevant to the analysis ( seeTool, $tep % &o! %e!pected if s ingle disbursement or as debt service as relevant.
8/20/2019 LIFE CICLE COST
46/73
OP!#O% "E!A#LS
Description: <
%ption "umber: <
(. Disposal 0osts "osts associated with disposal of the asset at the end of the desiE'( Cost o, Asset "isposal
E') Salvage
8/20/2019 LIFE CICLE COST
47/73
OP!#O% "E!A#LS
Description: <
%ption "umber: <
!otal 0osts:
@ !otal 0osts:
0umulative 0osts:ears of Analysis: 6!mber of years of analysis.
Total Costs G 6!mber of years of ana
Annuiti/ed 0ost 1tream: Ann!ity of %D disco!nt rate is !sed
S8;;AR= CHAR!
S8;;AR= CHAR!
Average Annuali/ed 0osts#+ndiscounted$:
Average Annuali/ed 0osts#Discounted$:
%D of Total Costs G 6!mber of years
@#
@#
@#
@#
4> 4
8/20/2019 LIFE CICLE COST
48/73
NA NA NA NA NA NA NA NA NA
0 0 0 0 0 0 0 0 0
8/20/2019 LIFE CICLE COST
49/73
8/20/2019 LIFE CICLE COST
50/73
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
8/20/2019 LIFE CICLE COST
51/73
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
8/20/2019 LIFE CICLE COST
52/73
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
F F; FF #
8/20/2019 LIFE CICLE COST
53/73
Life Cycle Cost Tool
PROEC! "E!A#LS
roject !itle: 6ew 7ltrasonic 8elding Machine
roject "o: <
Analyst#s$: 9es!s :eli( 9!an %ere2(
Date: $eptember );( )
8/20/2019 LIFE CICLE COST
54/73
Shun? !elsonic Branson 4 4
0@F
8/20/2019 LIFE CICLE COST
55/73
)
8/20/2019 LIFE CICLE COST
56/73
Costo del Tiempo Muerto Anual
MTBF -(
8/20/2019 LIFE CICLE COST
57/73
4ption# )
8/20/2019 LIFE CICLE COST
58/73
)
8/20/2019 LIFE CICLE COST
59/73
H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA
8/20/2019 LIFE CICLE COST
60/73
H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA
8/20/2019 LIFE CICLE COST
61/73
H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA
8/20/2019 LIFE CICLE COST
62/73
H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA
8/20/2019 LIFE CICLE COST
63/73
H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA
8/20/2019 LIFE CICLE COST
64/73
H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA
8/20/2019 LIFE CICLE COST
65/73
H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA
8/20/2019 LIFE CICLE COST
66/73
H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA
8/20/2019 LIFE CICLE COST
67/73
H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA
8/20/2019 LIFE CICLE COST
68/73
H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA
8/20/2019 LIFE CICLE COST
69/73
H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA
8/20/2019 LIFE CICLE COST
70/73
H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA
8/20/2019 LIFE CICLE COST
71/73
H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA
8/20/2019 LIFE CICLE COST
72/73
H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA H6GA
8/20/2019 LIFE CICLE COST
73/73
#
#
#
#
#
#
#H6GA H6GA H6GA H6GA
Recommended