39
2010 2011 2010 Días = 365 365 0.0% 60 Jornada = 3 3 0.0% x TP [h]= 8760 8760 0.0% 525600 Ao = 1.0000 1.0000 0.0% x P = 1.0000 1.0000 0.0% % C = 1.0000 1.0000 0.0% 525600 OEE = 1.0000 1.0000 0.0% 1.05 VP(SIS) [u/h]= PN [u]= PR [u]= CVU = 0 100000 200000 300000 400000 5 0.00 200000.00 400000.00 600000.00 800000.00 1000000.00 1200000.00

Costos-de-Mantenimiento.xlsx

Embed Size (px)

Citation preview

Page 1: Costos-de-Mantenimiento.xlsx

2010 2011 2010 2011Días = 365 365 0.0% 60 60 0.0%

Jornada = 3 3 0.0% xTP [h]= 8760 8760 0.0%

525600 525600 0.0%Ao = 1.0000 1.0000 0.0% x

P = 1.0000 1.0000 0.0% x % C = 1.0000 1.0000 0.0% 525600 525600 0.0%OEE = 1.0000 1.0000 0.0% x

1.05 1.05 0.0%

+

VP(SIS) [u/h]=

PN [u]=

PR [u]=

CVU =

0 100000 200000 300000 400000 500000 6000000.00

200000.00

400000.00

600000.00

800000.00

1000000.00

1200000.00

Page 2: Costos-de-Mantenimiento.xlsx

0 2010 2011 0 2010 2011PEQ = 342236 342236 0.0%PE$ = 650248.40 650248.40 0.0% 1.05 1.05 0.0%

- 1.90 1.90 0.0% 0.85 0.85 0.0%

VT = 998640.00 998640.00 0.0%

CV = 551880.00 551880.00 0.0% -

MC = 446760.00 446760.00 0.0%

CDM = 120000.00 120000.00 0.0% -OCF = 170900.00 170900.00 0.0% UTL = 155860.00 155860.00 0.0%

CF = 290900.00 290900.00 0.0% 998640.00 0.000.00

CT = 842780.00 842780.00 0.0%

CVU =

PVU = MCU =

Page 3: Costos-de-Mantenimiento.xlsx

0 100000 200000 300000 400000 500000 6000000.00

200000.00

400000.00

600000.00

800000.00

1000000.00

1200000.00

CT = CF = VT = CV =

Page 4: Costos-de-Mantenimiento.xlsx

0 100000 200000 300000 400000 500000 6000000.00

200000.00

400000.00

600000.00

800000.00

1000000.00

1200000.00

CT = CF = VT = CV =

Page 5: Costos-de-Mantenimiento.xlsx

2010 2011 2010 2011Días = 365 365 0.0% 60 60 0.0%

Jornada = 3 3 0.0% xTP [h]= 8760 8760 0.0%

525600 525600 0.0%Ao = 1.0000 1.0000 0.0% x

P = 1.0000 1.0000 0.0% x % C = 1.0000 1.0000 0.0% 525600 525600 0.0%OEE = 1.0000 1.0000 0.0% x

1.05 1.05 0.0%

+

VP(SIS) [u/h]=

PN [u]=

PR [u]=

CVU =

0 100000 200000 300000 400000 500000 6000000.00

200000.00

400000.00

600000.00

800000.00

1000000.00

1200000.00

CT = CT = CF =CF = VT = VT =CV = CV = PEQ =PEQ = PE$ = PE$ =998640.00 998640.00

Page 6: Costos-de-Mantenimiento.xlsx

0 2010 2011 0 2010 2011PEQ = 239730 239730 0.0%PE$ = 455487.00 455487.00 0.0% 1.05 1.05 0.0%

- 1.90 1.90 0.0% 0.85 0.85 0.0%

VT = 998640.00 998640.00 0.0%

CV = 551880.00 551880.00 0.0% -

MC = 446760.00 446760.00 0.0%

CDM = 32870.00 32870.00 0.0% -OCF = 170900.00 170900.00 0.0% UTL = 242990.00 242990.00 0.0%

CF = 203770.00 203770.00 0.0% 998640.00 0.000.00

CT = 755650.00 755650.00 0.0%

CVU =

PVU = MCU =

Page 7: Costos-de-Mantenimiento.xlsx

2011 2012 2011 2012Días = 365 365 0.0% 60 60 0.0%

Jornada = 3 3 0.0% xTP [h]= 8760 8760 0.0%

525600 525600 0.0%Ao = 0.80 0.90 12.5%

P = 0.95 0.95 0.0% x x % C = 0.90 0.90 0.0% 359510 404449 12.5%OEE = 0.68 0.77 12.5% x

1.05 1.05 0.0%

+

VP(SIS) [u/h]=

PN [u]=

PR [u]=

CVU =

0 100000 200000 300000 400000 500000 6000000.00

200000.00

400000.00

600000.00

800000.00

1000000.00

1200000.00

1 2

0.7757 0.7821

0.1224 0.0845

0.1020 0.1334

OCN/VTN= CTM/VTN = UTL/VTN =

Page 8: Costos-de-Mantenimiento.xlsx

0 2011 2012 0 2011 2012PEQ = 239730 247742 3.3%PE$ = 455487.00 470709.80 3.3% 1.05 1.05 0.0%

- 1.90 1.90 0.0% 0.85 0.85 0.0%

CMP = 15870.00 22680.00 42.9%4.81% 5.16% 7.30% CMNP = 106352.00 61676.00 -42.0%

VT = 683069.00 768453.10 12.5% CTM = 122222.00 84356.00 -31.0%998640.00 998640.00 0.0% 0.0159 0.0227 42.9%

CV = 377485.50 424671.45 12.5% 0.1065 0.0618 -42.0%551880.00 551880.00 0.0% - 0.1224 0.0845 -31.0%

MC = 305583.50 343781.65 12.5% 0.7757 0.7821 0.8%446760.00 446760.00 0.0% 0.1020 0.1334 30.8%

CDM = 32870.00 39680.00 20.7% - 0.0068 RM = 3.79%OCF = 170900.00 170900.00 0.0% -0.0447 TTR = 31.0%

CF = 203770.00 210580.00 3.3% -0.0379 -0.0379344946.16 313558.18 -9.1% UTL = 101813.50 133201.65 30.8%

CT = 581255.50 635251.45 9.3% 737064.95 31388.15896826.16 865438.18 -3.5% UTL = 101813.84 133201.82 30.8%

CVU =

PVU = MCU =

VTN = CMP/VTN =CMNP/VTN =

CVN = CTM/VTN =OCN/VTN=

MCN = UTL/VTN = CMP' =

CMNP' =CTM' =

CFN =

CTN =

1 20.0000

0.0200

0.0400

0.0600

0.0800

0.1000

0.1200

0.1400

CMP/VTN = CMNP/VTN = CTM/VTN =

1 2

0.7757 0.7821

0.1224 0.0845

0.1020 0.1334

OCN/VTN= CTM/VTN = UTL/VTN =

Page 9: Costos-de-Mantenimiento.xlsx

2011 2012 2011 2012CMNP = 106352.00 61676.00 TP = 8760 8760 0.0%MOD = 2246.40 148.20 1.95 1.95 0.0%

HE = t = 1752 876 -50.0%MR = 12753.60 14851.80 tP = 600 800 33.3%

SE = 2000.00 2000.00 tNP = 1152 76 -93.4%PP = 89352.00 44676.00 TP-tNP = 7608 8684 14.1%

37866.00 PMP =PC =PA =

MDA =6478.02 PVE =

CD = 2011 2012 + CDM = 32870.00 39680.00 20.7%

CMP = 15870.00 22680.0037866.00 MOD = 14835.60 16933.80

HE =31387.98 MR = 1034.40 746.2031387.98 SE =31387.98 MEH =

DEH =AR =

CAP = 5000.00SEG =CD =

h/hM =

UTLM =

1 20.0000

0.0200

0.0400

0.0600

0.0800

0.1000

0.1200

0.1400

CMP/VTN = CMNP/VTN = CTM/VTN =

Page 10: Costos-de-Mantenimiento.xlsx

2010 2011 2010 2011Días = 365 365 0.0% 60 60 0.0%

Jornada = 3 3 0.0% xTP [h]= 8760 8760 0.0%

525600 525600 0.0%Ao = 0.80 0.90 12.5%

P = 0.95 0.97 2.1% x x % C = 0.90 0.94 4.4% 359510 431317 20.0%OEE = 0.68 0.82 20.0% x

1.05 1.05 0.0%

+

VP(SIS) [u/h]=

PN [u]=

PR [u]=

CVU =

0 100000 200000 300000 400000 500000 6000000.00

200000.00

400000.00

600000.00

800000.00

1000000.00

1200000.00

1 2

0.7757 0.7593

0.1224 0.0845

0.1020 0.1563

OCN/VTN= CTM/VTN = UTL/VTN =

Page 11: Costos-de-Mantenimiento.xlsx

0 2010 2011 0 2010 2011PEQ = 239730 247742 3.3%PE$ = 455487.00 470709.80 3.3% 1.05 1.05 0.0%

- 1.90 1.90 0.0% 0.85 0.85 0.0%

CMP = 15870.00 22680.00 42.9%CMNP = 106352.00 61676.00 -42.0%

VT = 683069.00 819502.30 20.0% CTM = 122222.00 84356.00 -31.0%998640.00 998640.00 0.0% 0.0159 0.0227 42.9%

CV = 377485.50 452882.85 20.0% 0.1065 0.0618 -42.0%551880.00 551880.00 0.0% - 0.1224 0.0845 -31.0%

MC = 305583.50 366619.45 20.0% 0.7757 0.7593 -2.1%446760.00 446760.00 0.0% 0.1020 0.1563 53.3%

CDM = 32870.00 39680.00 20.7% - 0.0068 RM = 3.79%OCF = 170900.00 170900.00 0.0% -0.0447 TTR = 31.0%

CF = 203770.00 210580.00 3.3% -0.0379 -0.0379344946.16 290719.81 -15.7% UTL = 101813.50 156039.45 53.3%

CT = 581255.50 663462.85 14.1% 765276.35 54225.95896826.16 842599.81 -6.0% UTL = 101813.84 156040.19 53.3%

CVU =

PVU = MCU =

VTN = CMP/VTN =CMNP/VTN =

CVN = CTM/VTN =OCN/VTN=

MCN = UTL/VTN = CMP' =

CMNP' =CTM' =

CFN =

CTN =

1 20.0000

0.0200

0.0400

0.0600

0.0800

0.1000

0.1200

0.1400

CMP/VTN = CMNP/VTN = CTM/VTN =

1 2

0.7757 0.7593

0.1224 0.0845

0.1020 0.1563

OCN/VTN= CTM/VTN = UTL/VTN =

Page 12: Costos-de-Mantenimiento.xlsx

2010 2011 2010 2011CMNP = 106352.00 61676.00 TP = 8760 8760 0.0%MOD = 2246.40 148.20 1.95 1.95 0.0%

HE = t = 1752 876 -50.0%MR = 12753.60 14851.80 tP = 600 800 33.3%

SE = 2000.00 2000.00 tNP = 1152 76 -93.4%PP = 89352.00 44676.00 TP-tNP = 7608 8684 14.1%

37866.00 PMP =PC =PA =

MDA =-16360.35 PVE =

CD = 2010 2011 + CDM = 32870.00 39680.00 20.7%

CMP = 15870.00 22680.00MOD = 14835.60 16933.80

HE =54226.35 MR = 1034.40 746.2054226.35 SE =54226.35 MEH =

DEH =AR =

CAP = 5000.00SEG =CD =

h/hM =

UTLM =

1 20.0000

0.0200

0.0400

0.0600

0.0800

0.1000

0.1200

0.1400

CMP/VTN = CMNP/VTN = CTM/VTN =

Page 13: Costos-de-Mantenimiento.xlsx

2011 2012 2011 2012Días = 365 365 0.0% 60 65 8.3%

Jornada = 3 3 0.0% xTP [h]= 8760 8760 0.0%

525600 569400 8.3%Ao = 0.80 0.90 12.5%

P = 0.95 0.97 2.1% x x % C = 0.90 0.94 4.4% 359510 467261 30.0%OEE = 0.68 0.82 20.0% x

1.05 1.05 0.0%

+

VP(SIS) [u/h]=

PN [u]=

PR [u]=

CVU =

0 100000 200000 300000 400000 500000 6000000.00

200000.00

400000.00

600000.00

800000.00

1000000.00

1200000.00

1 2

0.7757 0.7461

0.12240.0814

0.1020 0.1725

OCN/VTN= CTM/VTN = UTL/VTN =

Page 14: Costos-de-Mantenimiento.xlsx

0 2011 2012 0 2011 2012PEQ = 239730 247742 3.3%PE$ = 455487.00 470709.80 3.3% 1.05 1.05 0.0%

- 1.90 1.90 0.0% 0.85 0.85 0.0%

CMP = 15870.00 22680.00 42.9%CMNP = 106352.00 65399.00 -38.5%

VT = 683069.00 887795.90 30.0% CTM = 122222.00 88079.00 -27.9%998640.00 1081860.00 8.3% 0.0159 0.0210 31.9%

CV = 377485.50 490624.05 30.0% 0.1065 0.0605 -43.2%551880.00 597870.00 8.3% - 0.1224 0.0814 -33.5%

MC = 305583.50 397171.85 30.0% 0.7757 0.7461 -3.8%446760.00 483990.00 8.3% 0.1020 0.1725 69.2%

CDM = 32870.00 39680.00 20.7% - 0.0051 RM = 4.10%OCF = 170900.00 170900.00 0.0% -0.0460 TTR = 33.5%

CF = 203770.00 210580.00 3.3% -0.0410 -0.0410344946.16 297398.13 -13.8% UTL = 101813.50 186591.85 83.3%

CT = 581255.50 701204.05 20.6% 803017.55 84778.35896826.16 895268.13 -0.2% UTL = 101813.84 186591.87 83.3%774604.16 807189.13 4.2%

CVU =

PVU = MCU =

VTN = CMP/VTN =CMNP/VTN =

CVN = CTM/VTN =OCN/VTN=

MCN = UTL/VTN = CMP' =

CMNP' =CTM' =

CFN =

CTN =OCN =

1 20.0000

0.0200

0.0400

0.0600

0.0800

0.1000

0.1200

0.1400

CMP/VTN = CMNP/VTN = CTM/VTN =

1 2

0.7757 0.7461

0.12240.0814

0.1020 0.1725

OCN/VTN= CTM/VTN = UTL/VTN =

Page 15: Costos-de-Mantenimiento.xlsx

2011 2012 2011 2012CMNP = 106352.00 65399.00 TP = 8760 8760 0.0%MOD = 2246.40 148.20 1.95 1.95 0.0%

HE = t = 1752 876 -50.0%MR = 12753.60 14851.80 tP = 600 800 33.3%

SE = 2000.00 2000.00 tNP = 1152 76 -93.4%PP = 89352.00 48399.00 TP-tNP = 7608 8684 14.1%

34143.00 PMP =PC =PA =

MDA =32584.97 PVE =32584.97 CD = 2011 2012

+ CDM = 32870.00 39680.00 20.7%CMP = 15870.00 22680.00

MOD = 14835.60 16933.80HE =

84778.03 MR = 1034.40 746.2084778.03 SE =84778.03 MEH =

DEH =AR =

CAP = 5000.00SEG =CD =

h/hM =

UTLM =

1 20.0000

0.0200

0.0400

0.0600

0.0800

0.1000

0.1200

0.1400

CMP/VTN = CMNP/VTN = CTM/VTN =

Page 16: Costos-de-Mantenimiento.xlsx

2011 2012 2011 2012Días = 365 365 0.0% 60 60 0.0%

Jornada = 3 3 0.0% xTP [h]= 8760 8760 0.0%

525600 525600 0.0%Ao = 0.80 0.90 12.5%

P = 0.95 0.97 2.1% x x % C = 0.90 0.94 4.4% 359510 431317 20.0%OEE = 0.68 0.82 20.0% x

1.05 1.10 4.8%

+

VP(SIS) [u/h]=

PN [u]=

PR [u]=

CVU =

0 100000 200000 300000 400000 500000 6000000.00

200000.00

400000.00

600000.00

800000.00

1000000.00

1200000.00

1 2

0.7757 0.7483

0.1224 0.0827

0.1020 0.1690

OCN/VTN= CTM/VTN = UTL/VTN =

Page 17: Costos-de-Mantenimiento.xlsx

0 2011 2012 0 2011 2012PEQ = 239730 233978 -2.4%PE$ = 455487.00 467956.00 2.7% 1.05 1.10 4.8%

- 1.90 2.00 5.3% 0.85 0.90 5.9%

CMP = 15870.00 22680.00 42.9%CMNP = 106352.00 64304.00 -39.5%

VT = 683069.00 862634.00 26.3% CTM = 122222.00 86984.00 -28.8%998640.00 1051200.00 5.3% 0.0159 0.0216 35.8%

CV = 377485.50 474448.70 25.7% 0.1065 0.0612 -42.6%551880.00 578160.00 4.8% - 0.1224 0.0827 -32.4%

MC = 305583.50 388185.30 27.0% 0.7757 0.7483 -3.5%446760.00 473040.00 5.9% 0.1020 0.1690 65.7%

CDM = 32870.00 39680.00 20.7% - 0.0057 RM = 3.96%OCF = 170900.00 170900.00 0.0% -0.0453 TTR = 32.4%

CF = 203770.00 210580.00 3.3% -0.0396 -0.0396344946.16 295433.92 -14.4% UTL = 101813.50 177605.30 74.4%

CT = 581255.50 685028.70 17.9% 786842.20 75791.80896826.16 873593.92 -2.6% UTL = 101813.84 177606.08 74.4%774604.16 786609.92 1.5%

CVU =

PVU = MCU =

VTN = CMP/VTN =CMNP/VTN =

CVN = CTM/VTN =OCN/VTN=

MCN = UTL/VTN = CMP' =

CMNP' =CTM' =

CFN =

CTN =OCN =

1 20.0000

0.0200

0.0400

0.0600

0.0800

0.1000

0.1200

0.1400

CMP/VTN = CMNP/VTN = CTM/VTN =

1 2

0.7757 0.7483

0.1224 0.0827

0.1020 0.1690

OCN/VTN= CTM/VTN = UTL/VTN =

Page 18: Costos-de-Mantenimiento.xlsx

2011 2012 2011 2012CMNP = 106352.00 64304.00 TP = 8760 8760 0.0%MOD = 2246.40 148.20 1.95 1.95 0.0%

HE = t = 1752 876 -50.0%MR = 12753.60 14851.80 tP = 600 800 33.3%

SE = 2000.00 2000.00 tNP = 1152 76 -93.4%PP = 89352.00 47304.00 TP-tNP = 7608 8684 14.1%

35238.00 PMP =PC =PA =

MDA =12005.76 PVE =12005.76 CD = 2011 2012

+ CDM = 32870.00 39680.00 20.7%CMP = 15870.00 22680.00

MOD = 14835.60 16933.80HE =

49512.24 MR = 1034.40 746.2075792.24 SE =49512.24 MEH =

DEH =AR =

CAP = 5000.00SEG =CD =

h/hM =

UTLM =

1 20.0000

0.0200

0.0400

0.0600

0.0800

0.1000

0.1200

0.1400

CMP/VTN = CMNP/VTN = CTM/VTN =

Page 19: Costos-de-Mantenimiento.xlsx

2011 2012 2011 2012Días = 365 365 0.0% 60 65 8.3%

Jornada = 3 3 0.0% xTP [h]= 8760 8760 0.0%

525600 569400 8.3%Ao = 0.80 0.83 3.7%

P = 0.95 0.96 1.1% x x % C = 0.90 0.92 2.2% 359510 417402 16.1%OEE = 0.68 0.73 7.2% x

1.05 1.10 4.8%

+

VP(SIS) [u/h]=

PN [u]=

PR [u]=

CVU =

0 100000 200000 300000 400000 500000 6000000.00

200000.00

400000.00

600000.00

800000.00

1000000.00

1200000.00

1 2

0.7757 0.7437

0.1224 0.1113

0.1020 0.1450

OCN/VTN= CTM/VTN = UTL/VTN =

Page 20: Costos-de-Mantenimiento.xlsx

0 2011 2012 0 2011 2012PEQ = 239730 233978 -2.4%PE$ = 455487.00 467956.00 2.7% 1.05 1.10 4.8%

- 1.90 2.00 5.3% 0.85 0.90 5.9%

CMP = 15870.00 22680.00 42.9%CMNP = 106352.00 104118.20 -2.1%

VT = 683069.00 834804.00 22.2% CTM = 122222.00 126798.20 3.7%998640.00 1138800.00 14.0% 0.0159 0.0199 25.3%

CV = 377485.50 459142.20 21.6% 0.1065 0.0914 -14.1%551880.00 626340.00 13.5% - 0.1224 0.1113 -9.0%

MC = 305583.50 375661.80 22.9% 0.7757 0.7437 -4.1%446760.00 512460.00 14.7% 0.1020 0.1450 42.2%

CDM = 32870.00 39680.00 20.7% - 0.0040 RM = 1.10%OCF = 170900.00 170900.00 0.0% -0.0151 TTR = 9.0%

CF = 203770.00 210580.00 3.3% -0.0110 -0.0110344946.16 347378.12 0.7% UTL = 101813.50 165081.80 62.1%

CT = 581255.50 669722.20 15.2% 771535.70 63268.30896826.16 973718.12 8.6% UTL = 101813.84 165081.88 62.1%774604.16 846919.92 9.3%

CVU =

PVU = MCU =

VTN = CMP/VTN =CMNP/VTN =

CVN = CTM/VTN =OCN/VTN=

MCN = UTL/VTN = CMP' =

CMNP' =CTM' =

CFN =

CTN =OCN =

1 20.0000

0.0200

0.0400

0.0600

0.0800

0.1000

0.1200

0.1400

CMP/VTN = CMNP/VTN = CTM/VTN =

1 2

0.7757 0.7437

0.1224 0.1113

0.1020 0.1450

OCN/VTN= CTM/VTN = UTL/VTN =

Page 21: Costos-de-Mantenimiento.xlsx

2011 2012 2011 2012CMNP = 106352.00 104118.20 TP = 8760 8760 0.0%MOD = 2246.40 1343.94 1.95 1.95 0.0%

HE = t = 1752 1489.2 -15.0%MR = 12753.60 13656.06 tP = 600 800 33.3%

SE = 2000.00 2000.00 tNP = 1152 689.2 -40.2%PP = 89352.00 87118.20 TP-tNP = 7608 8070.8 6.1%

-4576.20 PMP =PC =PA =

MDA =72315.76 PVE =72315.76 CD = 2011 2012

12577.76 + CDM = 32870.00 39680.00 20.7%CMP = 15870.00 22680.00

MOD = 14835.60 15738.06HE =

36988.04 MR = 1034.40 1941.9463268.04 SE =36988.04 MEH =

DEH =AR =

CAP = 5000.00SEG =CD =

h/hM =

UTLM =

1 20.0000

0.0200

0.0400

0.0600

0.0800

0.1000

0.1200

0.1400

CMP/VTN = CMNP/VTN = CTM/VTN =

Page 22: Costos-de-Mantenimiento.xlsx

2011 2012 2011 2012Días = 365 365 0.0% 65 65 0.0%

Jornada = 3 3 0.0% xTP [h]= 8760 8760 0.0%

569400 569400 0.0%Ao = 0.74 0.83 12.4% 0.738461

P = 0.95 0.96 1.1% x 359510 x % C = 0.90 0.92 2.2% 359510 417402 16.1%OEE = 0.63 0.73 16.1% x

1.05 1.10 4.8%

+

VP(SIS) [u/h]=

PN [u]=

PR [u]=

CVU =

0 100000 200000 300000 400000 500000 6000000.00

200000.00

400000.00

600000.00

800000.00

1000000.00

1200000.00

1 2

0.7585 0.7437

0.1474 0.1113

0.0941 0.1450

OCN/VTN= CTM/VTN = UTL/VTN =

Page 23: Costos-de-Mantenimiento.xlsx

0 2011 2012 0 2011 2012PEQ = 239730 233978 -2.4%PE$ = 455487.00 467956.00 2.7% 1.05 1.10 4.8%

- 1.90 2.00 5.3% 0.85 0.90 5.9%

CMP = 15870.00 22680.00 42.9%CMNP = 143582.40 104118.20 -27.5%

VT = 683069.00 834804.00 22.2% CTM = 159452.40 126798.20 -20.5%1081860.00 1138800.00 5.3% 0.0147 0.0199 35.8%

CV = 377485.50 459142.20 21.6% 0.1327 0.0914 -31.1%597870.00 626340.00 4.8% - 0.1474 0.1113 -24.5%

MC = 305583.50 375661.80 22.9% 0.7585 0.7437 -2.0%483990.00 512460.00 5.9% 0.0941 0.1450 54.0%

CDM = 32870.00 39680.00 20.7% - 0.0052 RM = 3.60%OCF = 170900.00 170900.00 0.0% -0.0413 TTR = 24.5%

CF = 203770.00 210580.00 3.3% -0.0360 -0.0360382176.50 347378.12 -9.1% UTL = 101813.50 165081.80 62.1%

CT = 581255.50 669722.20 15.2% 771535.70 63268.30980046.50 973718.12 -0.6% UTL = 101813.50 165081.88 62.1%820594.10 846919.92 3.2%

CVU =

PVU = MCU =

VTN = CMP/VTN =CMNP/VTN =

CVN = CTM/VTN =OCN/VTN=

MCN = UTL/VTN = CMP' =

CMNP' =CTM' =

CFN =

CTN =OCN =

1 20.0000

0.0200

0.0400

0.0600

0.0800

0.1000

0.1200

0.1400

0.1600

CMP/VTN = CMNP/VTN = CTM/VTN =

1 2

0.7585 0.7437

0.1474 0.1113

0.0941 0.1450

OCN/VTN= CTM/VTN = UTL/VTN =

Page 24: Costos-de-Mantenimiento.xlsx

2011 2012 2011 2012CMNP = 143582.40 104118.20 TP = 8760 8760 0.0%MOD = 3297.61 1343.94 1.95 1.95 0.0%

HE = t = 2291.08412 1489.2 -35.0%MR = 11702.39 13656.06 tP = 600 800 33.3%

SE = 2000.00 2000.00 tNP = 1691.08412 689.2 -59.2%PP = 126582.40 87118.20 TP-tNP = 7068.91588 8070.8 14.2%

32654.20 PMP =PC =PA =

MDA =26325.82 PVE =26325.82 CD = 2011 2012

41046.43 + CDM = 32870.00 39680.00 20.7%CMP = 15870.00 22680.00 -6810.00

MOD = 13784.39 15738.06HE =

34798.38 MR = 2085.61 1941.9463268.38 SE =34798.38 MEH =

DEH =AR =

CAP = 5000.00SEG =CD =

h/hM =

UTLM =

1 20.0000

0.0200

0.0400

0.0600

0.0800

0.1000

0.1200

0.1400

0.1600

CMP/VTN = CMNP/VTN = CTM/VTN =

Page 25: Costos-de-Mantenimiento.xlsx

2011 2012 2011 2012Días = 365 365 0.0% 65 65 0.0%

Jornada = 3 3 0.0% xTP [h]= 8760 8760 0.0%

569400 569400 0.0%Ao = 0.90 0.92 2.1% 0.631384

P = 1.00 1.00 0.0% x 359510 x % C = 1.00 1.00 0.0% 512460 523190 2.1%OEE = 0.90 0.92 2.1% x

1.05 1.10 4.8%

+

VP(SIS) [u/h]=

PN [u]=

PR [u]=

CVU =

0 100000 200000 300000 400000 500000 6000000.00

200000.00

400000.00

600000.00

800000.00

1000000.00

1200000.00

1 2

0.7106 0.7001

0.0751 0.0714

0.2143 0.2286

OCN/VTN= CTM/VTN = UTL/VTN =

Page 26: Costos-de-Mantenimiento.xlsx

0 2011 2012 0 2011 2012PEQ = 239730 233978 -2.4%PE$ = 455487.00 467956.00 2.7% 1.05 1.10 4.8%

- 1.90 2.00 5.3% 0.85 0.90 5.9%

CMP = 15870.00 22680.00 42.9%CMNP = 65399.00 58589.00 -10.4%

VT = 973674.00 1046380.00 7.5% CTM = 81269.00 81269.00 0.0%1081860.00 1138800.00 5.3% 0.0147 0.0199 35.8%

CV = 538083.00 575509.00 7.0% 0.0605 0.0514 -14.9%597870.00 626340.00 4.8% - 0.0751 0.0714 -5.0%

MC = 435591.00 470871.00 8.1% 0.7106 0.7001 -1.5%483990.00 512460.00 5.9% 0.2143 0.2286 6.7%

CDM = 32870.00 39680.00 20.7% - 0.0052 RM = 0.38%OCF = 170900.00 170900.00 0.0% -0.0090 TTR =

CF = 203770.00 210580.00 3.3% -0.0038 -0.0038252169.00 252169.00 0.0% UTL = 231821.00 260291.00 12.3%

CT = 741853.00 786089.00 6.0% 1017910.00 28470.00850039.00 878509.00 3.3% UTL = 231821.00 260291.00 12.3%768770.00 797240.00 3.7%

CVU =

PVU = MCU =

VTN = CMP/VTN =CMNP/VTN =

CVN = CTM/VTN =OCN/VTN=

MCN = UTL/VTN = CMP' =

CMNP' =CTM' =

CFN =

CTN =OCN =

1 20.0000

0.0100

0.0200

0.0300

0.0400

0.0500

0.0600

0.0700

0.0800

CMP/VTN = CMNP/VTN = CTM/VTN =

1 2

0.7106 0.7001

0.0751 0.0714

0.2143 0.2286

OCN/VTN= CTM/VTN = UTL/VTN =

Page 27: Costos-de-Mantenimiento.xlsx

2011 2012 2011 2012CMNP = 65399.00 58589.00 TP = 8760 8760 0.0%MOD = 538.20 -173.70 1.95 1.95 0.0%

HE = t = 876 710.923056 -18.8%MR = 14461.80 15173.70 tP = 600 800 33.3%

SE = 2000.00 2000.00 tNP = 276 -89.076944 -132.3%PP = 48399.00 41589.00 TP-tNP = 8484 8849.07694 4.3%

0.00 PMP =PC =PA =

MDA =28470.00 PVE =28470.00 CD = 2011 20124277.32 + CDM = 32870.00 39680.00 20.7%

CMP = 15870.00 22680.00 -6810.00MOD = 16543.80 17255.70

HE =28470.00 MR = -673.80 424.3028470.00 SE =28470.00 MEH =

DEH =AR =

CAP = 5000.00SEG =CD =

h/hM =

UTLM =

1 20.0000

0.0100

0.0200

0.0300

0.0400

0.0500

0.0600

0.0700

0.0800

CMP/VTN = CMNP/VTN = CTM/VTN =

Page 28: Costos-de-Mantenimiento.xlsx

2011 2012 2011 2012Días = 365 365 0.0% 65 65 0.0%

Jornada = 3 3 0.0% xTP [h]= 8760 8760 0.0%

569400 569400 0.0%Ao = 0.90 0.92 2.1% 0.631384

P = 1.00 1.00 0.0% x 359510 x % C = 1.00 1.00 0.0% 512460 523190 2.1%OEE = 0.90 0.92 2.1% x

1.05 1.10 4.8%

+

VP(SIS) [u/h]=

PN [u]=

PR [u]=

CVU =

0 100000 200000 300000 400000 500000 6000000.00

200000.00

400000.00

600000.00

800000.00

1000000.00

1200000.00

1 2

1.3501 1.4001

0.1427 0.14270.4071 0.4571

OCN/VTN= CTM/VTN = UTL/VTN =

Page 29: Costos-de-Mantenimiento.xlsx

0 2011 2012 0 2011 2012PEQ = 239730 233978 -2.4%PE$ = 455487.00 467956.00 2.7% 1.05 1.10 4.8%

- 1.90 2.00 5.3% 0.85 0.90 5.9%

CMP = 15870.00 22680.00 42.9%CMNP = 65399.00 58589.00 -10.4%

VT = 973674.00 1046380.00 7.5% CTM = 81269.00 81269.00 0.0%1081860.00 1138800.00 5.3% 0.0279 0.0398 42.9%

CV = 538083.00 575509.00 7.0% 0.1149 0.1029 -10.4%597870.00 626340.00 4.8% - 0.1427 0.1427 0.0%

MC = 435591.00 470871.00 8.1% 1.3501 1.4001 3.7%483990.00 512460.00 5.9% 0.4071 0.4571 12.3%

CDM = 32870.00 39680.00 20.7% - 0.0120 RM = 0.00%OCF = 170900.00 170900.00 0.0% -0.0120 TTR = 0.0%

CF = 203770.00 210580.00 3.3% 0.0000 0.0000252169.00 252169.00 0.0% UTL = 231821.00 260291.00 12.3%

CT = 741853.00 786089.00 6.0% 1017910.00 28470.00850039.00 878509.00 3.3% UTL = 231821.00 260291.00 12.3%768770.00 797240.00 3.7%

CVU =

PVU = MCU =

VTN = CMP/VTN =CMNP/VTN =

CVN = CTM/VTN =OCN/VTN=

MCN = UTL/VTN = CMP' =

CMNP' =CTM' =

CFN =

CTN =OCN =

1 20.0000

0.0200

0.0400

0.0600

0.0800

0.1000

0.1200

0.1400

0.1600

CMP/VTN = CMNP/VTN = CTM/VTN =

1 2

1.3501 1.4001

0.1427 0.14270.4071 0.4571

OCN/VTN= CTM/VTN = UTL/VTN =

Page 30: Costos-de-Mantenimiento.xlsx

2011 2012 2011 2012CMNP = 65399.00 58589.00 TP = 8760 8760 0.0%MOD = 538.20 -173.70 1.95 1.95 0.0%

HE = t = 876 710.923056 -18.8%MR = 14461.80 15173.70 tP = 600 800 33.3%

SE = 2000.00 2000.00 tNP = 276 -89.076944 -132.3%PP = 48399.00 41589.00 TP-tNP = 8484 8849.07694 4.3%

0.00 PMP =PC =PA =

MDA =28470.00 PVE =28470.00 CD = 2011 2012

0.00 + CDM = 32870.00 39680.00 20.7%CMP = 15870.00 22680.00 -6810.00

MOD = 16543.80 17255.70HE =

0.00 MR = -673.80 424.3028470.00 SE =

0.00 MEH =28470.00 DEH =

AR =CAP = 5000.00SEG =CD =

h/hM =

UTLM =

1 20.0000

0.0200

0.0400

0.0600

0.0800

0.1000

0.1200

0.1400

0.1600

CMP/VTN = CMNP/VTN = CTM/VTN =