ejercicio-alumnos-20_04_15-para-que-trabajen.xlsx

8/16/2019 ejercicio-alumnos-20_04_15-para-que-trabajen.xlsx

1/22


2/22

A,ANCE &EA+ E!ECUADO

Se(%1" Oct%1" No%1"

A,ANCE *ENSUA+ 82$00.00 1027$0.00 "72470.00

A,ANCE ACU*U+ADO 82$00.00 192"$0.00 4627"0.00

CA+CU+O DE &EA!USES

NO*ENC+AU&A IU Coecente atc(ac5n

Inc:enca ; Se(%1"

.1 ." .3

! 47 0.193 100.00; 100.00

)*A 38 0.0$3 1$.10; 103."6

43 39.60; 10$.86

4 4$.30; 103."6

A $ 0.143 100.00; 99.09

C "1 0.1$1 100.00; 106.94

EE 48 0."60 66.90; 110.$9

49 33.10; 111.47

#U 39 0."00 100.00; 10$.$"

NO&*AS A&A O-&AS A&ASADAS D.S. N° 011%79%,C

Valoriz. Ejecutadas Valoriz. !ro"ra#adas

$ei%te"ro . Ejecutado $ei%te"ro. !ro"ra#ado


3/22

$ 48 38 "1 4 43

0.143 0.168 0.008 0.1$1 0.019 0.0"0

IU Coef. Inc. atc(ac5n ; Nomenclatu

38 0.008 1$.10;

43 0.0"1 39.60;

4 0.0"4 4$.30;

0.0$3 100.00; )*A

IU Coef. Inc. atc(ac5n ; Nomenclatu

49 0.086 33.10;

48 0.174 66.90;

0."60 100.00; EE

Ar / Ao + 0.151 &r / &o + 0.'(0 EE r / EE o + 0.'00

Oct%9" No%9" Dec%9" !an%93 Fe%93 *a%93

100.83 101.38 10$.3$ 110.94 110.7$ 110.38

104.06 103."9 106.77 11".90 1"".87 1"3."1

108.01 110."" 114.90 1"".$6 130.$1 13"."8

104."$ 103."9 113.6$ 1"0.17 1"4.41 119.78

100.03 106.67 113."7 1"1.70 1"1.70 1"1.30

1"1.89 1"3.$7 1"$.67 131.3$ 137.46 141.89

1"6.0$ 131.04 13".19 13$.47 140.18 148.83

1"6.01 130.86 13".$7 13".3" 14".06 148.64

109.36 113."3 117.$9 1"3."9 1"6.90 13"."8

Dec%1" !an%13 Fe%13"0286$.00 9290".40 )*A, E-*- AVA)&E- -*

67 471 00 77 373 40 77 373 40


4/22

Dec%1" !an%13 Fe%13

192800.00 72830.00 320"3.40

662$"0.00 7423$0.00 772373.40

o Seteme 1" 1 ,al 01 % Seteme 1" "

!ul%1" Oct. 1" !ul%1" No. 1"

.4 .$ .6 .7

100.00 0.193 100.83 100.00 0.19$ 101.38

100.00 0.0$$ 104.06 100.00 0.0$6 103."9

100.00 108.01 100.00 110.""

100.00 104."$ 100.00 103."9

100.00 0.14" 100.03 100.00 0.143 106.67

100.00 0.161 1"1.89 100.00 0.184 1"3.$7

100.00 0."88 1"6.0$ 100.00 0.3"8 131.04

100.00 1"6.01 100.00 130.86

100.00 0."11 109.36 100.00 0."19 113."3

1.0$

< 1 = 1.1"$0< " =

1 > Σ " > 3 1 > Σ " > $

Σ " > 4 Σ " > 6


5/22


6/22

,al 0" % Octue 1" 3 ,al 03 % Noeme 1" 4

!ul%1" Dc. 1" !ul%1" Ene. 13

.8 .9 .10 .10

100.00 0.196 10$.3$ 100.00 0."03 110.94

100.00 0.0$6 106.77 100.00 0.06 11".90

100.00 114.90 100.00 1"".$6

100.00 113.6$ 100.00 1"0.17

100.00 0.1$3 113."7 100.00 0.163 1"1.70

100.00 0.187 1"$.67 100.00 0.171 131.3$

100.00 0.341 13".19 100.00 0.344 13$.47

100.00 13".$7 100.00 13".3"

100.00 0.""6 117.$9 100.00 0."6$ 1"3."9

1.1$9 < 3 = 1."06< 4 =

1 > Σ " > 7 1 > Σ " > 9

Σ " > 8 Σ " > 10


7/22


8/22

,al 04 % Dceme 1" $ ,al 0$ % Eneo 13

!ul%1" Fe. 13 !ul%1"

.11 .1" .13

100.00 0."14 110.7$ 100.00 0."14

100.00 0.064 1"".87 100.00 0.06$

100.00 130.$1 100.00 0

100.00 1"4.41 100.00 0

100.00 0.174 1"1.70 100.00 0.174

100.00 0.198 137.46 100.00 0."08

100.00 0.3$ 140.18 100.00 0.364

100.00 14".06 100.00 0

100.00 0."47 1"6.90 100.00 0."$4

1."47 < $ =

1 > Σ " > 10 1 > Σ " > 1"

Σ " > 11 Σ " > 13


9/22


10/22

6 ,al 06 % Feeo 13

*a. 13 !ul%1"

.14 .1$

110.38 100.00

1"3."1 100.00

13"."8 100.00

119.78 100.00

1"1.30 100.00

141.89 100.00

148.83 100.00

148.64 100.00

13"."8 100.00

< 6 =

1 > Σ " > 14

Σ " > 1$


11/22

VA*$2A&*) 0?n a:elanto

CA+CU+O DE+ COEFICIENE DE &EA!USE < SE%1"

+a alo@ac5n ?e eau?ta con el < :e Octue 1"

1° ,alo@ac5n -uta ,o = 82$00.00

"° ,alo@ac5n eau?ta:a , 82$00.00> 1.1"$ =

,ecac5n ? la oa e?tB ata?a:a o (emanentemente a:

Detemna el eau?te a econoce (o la Ent:a: contatan

a Com(aac5n :e Aance?

Aance o'ama:o Acumula:o AA = 1069'0.00

Aance &eal Acumula:o A&A = 76500.00

CBlculo :e lo? eau?te? eale?2 (o'ama:o? econoc:o?

,al N° ,eal , (o'ama:o %1

.1 ." .3

1 76500.00 1069'0.00 8 0.1'5

1 82$00.00 1029"0.00 0.1"$

3°

,alo@ac5n Neta a (a'a

, n = , o &

, n = 92$6".$0

VA*$2A&*)?n a:elanto



1° ,alo@ac5n -uta ,o = 1027$0.00

Σ & =


12/22

"° ,alo@ac5n eau?ta:a , 1027$0.00> 1.1$9 =




Aance o'ama:o Acumula:o AA = ''6('1.00Aance &eal Acumula:o A&A = 196'50.00



.1 ." .3

1 76500.00 1069'0.00 8 0.1'5

" 1027$0.00 112701.00 0.1$9

3°


, n = , o &

, n = 1"24$9."$

VA*$2A&*) 0?n a:elanto



1° ,alo@ac5n -uta ,o = "72470.00

"° ,alo@ac5n eau?ta:a , "72470.00> 1."06 =



Σ & =


13/22


Aance o'ama:o Acumula:o AA = 4(6(0(.00

Aance &eal Acumula:o A&A = 4(6:'0.00



.1 ." .3

1 76500.00 1069'0.00 8 0.1'5

" 106:50.00 116:01.00 0.1$9

3 "72470.00 "3298$.00 0."06

3°


, n = , o &

, n = 3"2864.6"

VA*$2A&*) 0

?n a:elantoCA+CU+O DE+ COEFICIENE DE &EA!USE < SE%1"


1° ,alo@ac5n -uta ,o = 0.00

"° ,alo@ac5n eau?ta:a , 0.00 > 0 =




Aance o'ama:o Acumula:o AA = 0.00

Aance &eal Acumula:o A&A = 0.00



Σ & =


14/22

.1 ." .3

1 76500.00 1069'0.00 8 0.1'5

" 0.00 0.00 %1

3°


, n = , o &

, n = 0.00

Σ & =


15/22

-etie#re 1'

9$6".$0

elanta:a

e

1029"0.00 MA;*$

82$00.00 A$A-AA

&eau?te &eau?te &eau?te ,

&eal o'ama:o &econoc:o

4 = 1 > 3 $ = " > 3 .6 7 = 1 6

10('.5 13(5 10('.50 95('.50

106".$0 136$.00 106".$0 92$6".$0

106".$0 136$.00

' *cture 1'

Como AA A&A

Oa Ata?a:a

Se :ee calcula lo? eau?te? eale? (o'ama:o? acu

Σ &( =


16/22

1"4$9."$

elanta:a

e

0.00 MA;*$0.00 A$A-AA



4 = 1 > 3 $ = " > 3 .6 7 = 1 6

10('.5 13(5 '::1.:5 11':1.:5

1709."$ 1860.46 1709."$ 1"24$9."$

"771.7$ 3""$.46

%oie#re 1'

331"8.8"

elanta:a

e

Como AA A&AOa Ata?a:a


Σ &( =


17/22

0.00 #e%or

0.00 adela%tada



4 = 1 > 3 $ = " > 3 .6 7 = 1 6

10('.5 13(5 '::1.:5 11':1.:5

1709."$ 1860.46 1709."$ 1"24$9."$

$6$8.8" 4940.91 $394.6" 3"2864.6"

8430.$7 8166.37meno

$394.619

dicie#re 1'

0.00

elanta:a

e

0.00 MA;*$

0.00 A$A-AA


Como AA A&A

Oa Ata?a:a


Σ &( =

Como AA A&A

Oa Ata?a:a



18/22


4 = 1 > 3 $ = " > 3 .6 7 = 1 6

10('.5 13(5 10('.50 95('.50

0.00 0.00 0.00 0.00

106".$0 136$.00

Σ &( =


19/22

ulados


20/22


21/22

ulados

ulados


22/22

ejercicio-alumnos-20_04_15-para-que-trabajen.xlsx

Documents