Upload
brian
View
242
Download
4
Embed Size (px)
DESCRIPTION
base
Citation preview
7/17/2019 Practica Calificada SI.joel Gonzales
http://slidepdf.com/reader/full/practica-calificada-sijoel-gonzales 1/10
EMPLEADO SUELDO GRATIFICACION
Juan $147,852 $44,355.60 $147,852María $ 369,852 $73,970.40 Angel $ 159,753 $47,925.90Kiara $ 852,147 $85,214.70Tiare $ 963,258 $96,325.80 Aurora $ 987,456 $98,745.60Darian $ 985,632 $98,563.20Ini $ 145,236 $43,570.80 A!len $ 985,632 $98,563.20"i#olle $ 784,512 $78,451.20i#oria $ 987,321 $98,732.10
A%igne una grai&i#a#ion %eg'n lo% rango% (ue %e le enregan)RANGO % GRATIFICACION
enre 10000 ! 200000 30* 30*enre 200001 ! 499999 20* 20*enre 500000 ! 1000000 10* 10*
7/17/2019 Practica Calificada SI.joel Gonzales
http://slidepdf.com/reader/full/practica-calificada-sijoel-gonzales 2/10
EMPLEADO ISARPE SUELDO DESCUENTO
Juan +"-A/D $ 147,852 -. 17,742.24María -A"TA MAIA $ 369,852 -. 92,463.00
Angel "A-A $ 159,753 -. 11,182.71Kiara "A-A $ 852,147 -. 59,650.29Tiare "A-A $ 963,258 -. 67,428.06
Aurora -A"TA MAIA $ 987,456 -. 246,864.00Darian -A"TA MAIA $ 985,632 -. 246,408.00Ini +"-A/D $ 145,236 -. 17,428.32
A!len +"-A/D $ 985,632 -. 118,275.84"i#olle +"-A/D $ 784,512 -. 94,141.44i#oria "A-A $ 987,321 -. 69,112.47
eali#e lo% e%#ueno %eg'n la I%are)
+"-A/D 12%
-A"TA MAIA 25%
"A-A 7%
7/17/2019 Practica Calificada SI.joel Gonzales
http://slidepdf.com/reader/full/practica-calificada-sijoel-gonzales 3/10
IdPedido IdCliente Empleado Precio U R1 R2 R3 R4
10248 IMK -u!aa 2764 IMK 276.4 010257 TT/ Daolio 2892 TT/ 144.6 Daolio10248 IMK eerling 4108 IMK 010248 IMK ea#o# 2641 IMK 010248 IMK :u#;anan 3069 IMK 0
10256 </I+K eerling 3959 396410257 TT/ +alla;an 4976 TT/ +alla;an10260 </I+K Daolio 4123 206.15 412810254 A"K ea#o# 2264 A"K10256 </I+K -u!aa 2888 288.8 289310260 </I+K eerling 4710 471510254 A"K +alla;an 3838 A"K10251 ="-> Daolio 2114 105.7 010260 </I+K ea#o# 2584 258910254 A"K :u#;anan 3004 A"K10257 TT/ -u!aa 4762 TT/ 476.2 -u!aa10254 A"K -u!aa 2516 A"K 251.610254 A"K Daolio 2668 A"K 133.410248 IMK ea#o# 3523 IMK 010260 </I+K ea#o# 2304 2309
EJERCICIOS
10248 IMK10254 A"K10257 TT/
-u!aa 10*Daolio 5*
TT/ DaolioA"K</I+K / ? 5
1.- Si la IdPedid e! 1"24# , #olo(ue $ILM, Si e! 1"254 FRAN, Si e! 1"25& TORTU, lo% e@% eelo% Blan#o%.2.- Si el e'(lead e! S)*a'a+ de!,)ee al P/e,iU 1"%, Si e! Da0li ) 5%, e lo #onrario no e%#uene3.- Si el IdCliee e! TORTU, De0)el0a el '/e del e'(lead, Si e! FRAN dee e la,C Si e! UICC !)'e al P/e,i U 5 dla/e!, lo% e4.- Si la ,aidad e! 'a*/ )e 4" , Re6al, -i e! 'a*/ )e 3", De!,)e, Si e! 'a*/ )e 2"C Cliee P/e7e/e,ial, lo e@% =%[email protected] Si el P/e,i U e! 'a*/ )e 4"C Cdi61, Si e! 'a*/ )e 3"C C8di62, Si e! 'a*/ )e 2"C C8di63, lo% e@% -in +Eigo
7/17/2019 Practica Calificada SI.joel Gonzales
http://slidepdf.com/reader/full/practica-calificada-sijoel-gonzales 4/10
+A+/A A +/M"A D= M=DI F /=G -=GH" =-= =-/TAD)
=AIA +" A /"+I" -I /"A =A+I" D"D= ="T=G/= +M =-/=-TA
AA A- "TA- I"=I=- A 4 D=:= ="T=GA = T=T I"-/I+I="T=AA A- </= A" D= 4 A 5 -" -/I+I="T=, AA A- </= A" D= 5,1 A 6 =- :/="A
F AA D= 6,1 A 7 =- M/F :/="A
"oBre "oa "oa "oa roeio TeLoJuan ere 6.3 5.9 6.8 6.3 M/F :/="A
Anonio +a%ro 3.5 2.6 4 3.4 I"-/I+I="T=Mar#elo Jere 4.2 6.2 5.3 5.2 :/="AMiguel -oo 5.6 5.2 7 5.9 :/="A
>ugo +a%aNea 7 6.3 5.5 6.3 M/F :/="AGaBriel "uNe 2.1 3.5 3.6 3.1 I"-/I+I="T=
Mauri#io aaa 5.4 4.9 4.2 4.8 -/I+I="T= Angel Dono%o 6 7 6.1 6.4 M/F :/="A
O4 I"-/I+I="T=4 A 5 -/I+I="T=5.1 a 6 :/="A6.1 A 7 M/F :/="A
7/17/2019 Practica Calificada SI.joel Gonzales
http://slidepdf.com/reader/full/practica-calificada-sijoel-gonzales 5/10
Plailla de Pa6!N'/e S)eld AFP I!a(/e E!,ala7 G/ai7i,. S)eld I'(
Mario -oo -. 123,568.00 >aBia ona%a A -. 8,649.76 -. 132,217.76
origo e!e% -. 536,987.00 +uru roear + -. 53,698.70 -. 590,685.70ui% +a%illo -. 257,894.00 +uru +on%alu : -. 20,631.52 -. 278,525.52 Angela Pre -. 254,698.00lanial roear + -. 25,469.80 -. 280,167.80Jorge ri -. 236,984.00 >aBia ona%a + -. 23,698.40 -. 260,682.40=uaro ae -. 986,547.00 >aBia +on%alu : -. 78,923.76 -. 1,065,470.76Jaie Toro -. 563,241.00 lanial +on%alu A -. 39,426.87 -. 602,667.87María ee -. 235,689.00 >aBia ona%a A -. 16,498.23 -. 252,187.23
I!a(/e De!,. AFP De!,. E!,ala78
ona%a 6* >aBia 12* Aroear 8* lanial 10* :+on%alu 7* +uru 14* +
7/17/2019 Practica Calificada SI.joel Gonzales
http://slidepdf.com/reader/full/practica-calificada-sijoel-gonzales 6/10
"M:= "I= ="DIMI="T -= TGA :=+A Q=D 1 5.5 :=+AJ/A" 1 5 " :=+ADI=G 0 6.8 " :=+A
AA :T="= :=+A -= =</I==)"I= -=A MAF A += F="DIMI="T -=A MAF </= 5
"I= R0=DIMI="T R5
7/17/2019 Practica Calificada SI.joel Gonzales
http://slidepdf.com/reader/full/practica-calificada-sijoel-gonzales 7/10
/"A =-"A " /=D= TA +/A"D)1.S " =-TA I"-+ITA =" = -=I+I ==+TA2.S TI="= A"T=+=D="T=- ="A=-3.S TI="= MA- D= 70 A-
D= A+/=D A =-- DAT- DIGA </= =-"A- /=D=" TA F </I="=- "
"M:= A"T=+=D="T=- =-"A=- +"DI+I" =DAD -IT/A+I"JAI= -I" A"T=+=D="T=- I"-+IT 60 -IMA+A="A -I" A"T=+=D="T=- I"-+IT 35 -I A=JA"D +" A"T=+=D="T=- I"-+IT 20 "+I-TI"A -I" A"T=+=D="T=- " I"-+IT 75 "="A +" A"T=+=D="T=- I"-+IT 25 "/I- +" A"T=+=D="T=- " I"-+IT 30 "+A- -I" A"T=+=D="T=- I"-+IT 45 -IJG= -I" A"T=+=D="T=- I"-+IT 72 "-+A +" A"T=+=D="T=- " I"-+IT 44 ":IA"+A -I" A"T=+=D="T=- I"-+IT 41 -I
-I" A"T=+=D="T=-
I"-+IT"
60 -I
7/17/2019 Practica Calificada SI.joel Gonzales
http://slidepdf.com/reader/full/practica-calificada-sijoel-gonzales 8/10
"M:= +TA.I-A M"T A>AD IAJAQ=D -I $ 100,000 "J/A" " $ 100,000 "DI=G " $ 500,000 "
DA IAJA -I)IU -== +/="TA I-A IIU -/ A> =- MAF A $150.000
+TA.I-A M"T A>AD-I
R150000
"
-I
7/17/2019 Practica Calificada SI.joel Gonzales
http://slidepdf.com/reader/full/practica-calificada-sijoel-gonzales 9/10
-e (uiere %aBer (ue %eLo e lo% eBrione% (ue aare#en %aBieno (ue VMuer, FV>oBre
=Brion +roo%oa 1 +roo%oa 2 -eLo=Brion 1 F >oBre=Brion 2 Muer =Brion 3 Muer
=Brion 4 F >oBre=Brion 5 Muer =Brion 6 F >oBre=Brion 7 Muer =Brion 8 Muer =Brion 9 F >oBre=Brion 10 Muer
Muer 2F >oBre 1
7/17/2019 Practica Calificada SI.joel Gonzales
http://slidepdf.com/reader/full/practica-calificada-sijoel-gonzales 10/10
o% re(ui%io% ara o%ular a la aia#ion %on lo% %iguiene%)1.S Tener a% e 15 aNo%2.S "o ener roBlea% e %alu3.S a%ar el eLaen &i%i#o4.S -e #;ileno5.S Tener #ali&i#a#ione% %oBre 6<uiene% el li%ao ueen o%ularQ
"oBre =a =Laen Mei#o Te% &i%i#o "a#ionalia "oa% o%ulaQJo%P ero re!re 16 A:AD A:AD +>I=" 6 -I
Anonio Moreno 20 A:AD =:AD AG="TI" 6.5 "olan Menel 17 =:AD A:AD +>I=" 7 "Diego oel 18 A:AD A:AD +>I=" 6.4 -I;ili +raer 11 A:AD =:AD +>I=" 4.1 "ene ;illi% 18 =:AD =:AD AG="TI" 6.7 "Daniel Tonini 19 A:AD A:AD +>I=" 6.1 -IMi#;ael >ol 10 A:AD =:AD +>I=" 5.9 "
=a R15=Laen Mei#o A:AD -I
Te% &i%i#o A:AD ""a#ionalia +>I=""oa% 6