Clase2_Ejercicios_resultos
-
Upload
llercin-gomez-vargas -
Category
Documents
-
view
225 -
download
0
Transcript of Clase2_Ejercicios_resultos
-
8/18/2019 Clase2_Ejercicios_resultos
1/11
Descuento: 14%
Empleado Sueldo Bruto Descuento
Juan Pérez S/. 12,345.00 S/. 1,728.30
Susana Gómez S/. 1,250.00 S/. 175.00
Alicia Dorrego S/. 1,542.00 S/. 215.88
Carlos Martínez S/. 745.00 S/. 104.30
Ana Santos S/. 1,238.00 S/. 173.32José Díaz S/. 678.00 S/. 94.92
TOTAL S/. 17,798.00 S/. 2,491.72
Mes Ventas Costo
Enero S/. 1,000.00 S/. 700.00
Febrero S/. 1,150.00 S/. 805.00
Marzo S/. 1,380.00 S/. 966.00
Abril S/. 1,518.00 S/. 1,062.60
Mayo S/. 1,669.80 S/. 1,168.86 Junio S/. 1,836.78 S/. 1,285.75
Julio S/. 2,020.46 S/. 1,414.32
Ao!"o S/. 2,222.50 S/. 1,555.75
Se#"ie$bre S/. 2,444.75 S/. 1,711.33
%&"ubre S/. 2,689.23 S/. 1,882.46
'o(ie$bre S/. 2,958.15 S/. 2,070.71
)i&ie$bre S/. 3,253.97 S/. 2,277.78
SueldosSe re*uiere ob"ener la! &olu$na! +e +e!&uen"o! y !ue
+e!&uen"o #ara &a+a e$#lea+o e! +e 14 +el Suel+o -
"o"al +e &a+a &olu$na.
PronósticoSe re*uiere #re#arar una #lan"illa &on la !iui
en"a! Enero 1000, en"a! Febrero in&re$en"o +e 15
in&re$en"o +e 20 !obre Febrero. A #ar"ir +e Abril, &a+ael an"erior.o!"o 70 +e la! (en"a! Maren +ieren&ia
-
8/18/2019 Clase2_Ejercicios_resultos
2/11
-
8/18/2019 Clase2_Ejercicios_resultos
3/11
IGV 18%
Cantidad rt!culo
Sueldo "eto 23a$i!a
S/. 10,616.70 42 Sa&o
S/. 1,075.00 51 Fal+a
S/. 1,326.12 39 an"aln
S/. 640.70 #$#
S/. 1,064.68S/. 583.08
S/. 15,306.28
Producto
A S/. 10.00
Mar&en - S/. 20.00
S/. 300.00 S/. 30.00
S/. 345.00 ) S/. 40.00
S/. 414.00 E S/. 25.00
S/. 455.40 #$#ES
S/. 500.94S/. 551.03
S/. 606.14
S/. 666.75
S/. 733.43
S/. 806.77
S/. 887.45
S/. 976.19
Precio DeVenta
l+o ne"o, !abien+o *ue elu"o. Se !oli&i"a, a+e$!, el
Com%b"ener el "o"al ne"o, el "o"al a #aar y el "o"al +e
n"e inor$a&in !obre Enero, en"a! Marzo
$e! in&re$en"a 10 !obre
en"re (en"a! y &o!"o
D
Se re*uiere la &one&&in +e una #lan"illa *ue li!+e!&uen"o , el i$#or"e ne"o y la #ar"i
-
8/18/2019 Clase2_Ejercicios_resultos
4/11
-
8/18/2019 Clase2_Ejercicios_resultos
5/11
Precio 'nitario #otal "eto IGV #otal a Pa&ar
54 S/. 1,242.00 S/. 223.56 S/. 1,465.56
33 S/. 1,386.00 S/. 249.48 S/. 1,635.48
215 S/. 10,965.00 S/. 1,973.70 S/. 12,938.70
128 S/. 4,992.00 S/. 898.56 S/. 5,890.56
430 S/. 18,585.00 S/. 3,345.30 S/. 21,930.30
Cantidad #otal Descuento "eto Participación
1000 S/. 10,000.00 S/. 1,500.00 S/. 8,500.00 4
2000 S/. 40,000.00 S/. 6,000.00 S/. 34,000.00 16
1500 S/. 45,000.00 S/. 6,750.00 S/. 38,250.00 18
2600 S/. 104,000.00 S/. 15,600.00 S/. 88,400.00 43
1800 S/. 45,000.00 S/. 6,750.00 S/. 38,250.00 18
8900 S/. 244,000.00 S/. 36,600.00 S/. 207,400.00 100
pras #or ar"&ulo y lo! "o"ale! +e e!a! "re! &olu$na!.
scuentos
e +e lo! #ro+u&"o! !u #re&io, &an"i+a+ e i$#or"e "o"al, eli&i#a&in +e &a+a #ro+u&"o en el "o"al (en+i+o.
-
8/18/2019 Clase2_Ejercicios_resultos
6/11
-
8/18/2019 Clase2_Ejercicios_resultos
7/11
Nº de encuesta Sexo Edad Gaseosa Tipo
0001357 15 Coca Cola Com!n
0001"5# M 1# Coca Cola Com!n
0001"77 M $" Pe%si Cola Com!n
00017"7 M 3$ Coca Cola Com!n
00017"& $# Coca Cola Dietética
000175$ 1# Pe%si Cola Com!n
0001753 M 17 Pe%si Cola Com!n
0001#$" $5 Coca Cola Com!n
0001##1 $$ Pe%si Cola Dietética
0001#&3 M $$ Coca Cola Com!n0001&01 $1 Coca Cola Dietética
0001&1& M 17 Coca Cola Dietética
0001&$' $" Pe%si Cola Com!n
0001&50 $7 Coca Cola Com!n
an"i+a+ +e #er!ona! +e #reeren o&a ola
an"i+a+ +e #er!ona! +e #reeren e#!i olaan"i+a+ +e $u:ere! *ue #reeren o&a ola
an"i+a+ "o"al +e en&ue!"a+o!
!u$a
!u$ar.!i
!u$ar.!i.&on:un"o
#ro$e+io
#ro$e+io.!i#ro$e+io.!i.&on:un"o
&on"ara
&on"ar.!i
&on"ar.!i.&on:un"o
an"i+a+ +e #er!ona! *ue #reeren Coca Cola Dietética
an"i+a+ +e #er!ona! *ue #reeren Pe%si Cola Com!n
-
8/18/2019 Clase2_Ejercicios_resultos
8/11
"(1($013
"(1($013
"(1($013
"(1($013
"($($013
"($($013
"($($013
"($($013
"($($013
"($($013"(3($013
"(3($013
"(3($013
"(3($013
&on"ar.!i.&on:un"o (
&on"ar.!i.&on:un"o 4
&on"ar.!i )
&on"ar.!i *&on"ar.!i.&on:un"o *
&on"ara 14
Fecha de laEncuesta
-
8/18/2019 Clase2_Ejercicios_resultos
9/11
)AS Mé*ico A 1000 3($1($013
)AS35 +rasil + 500 3($1($013
)AS Mé*ico A 500 3($1($013
CD,5# +rasil A $00 3($1($013
-./7' +rasil + $000 3($1($013
CD,5# +rasil + 1000 3($1($013
),1$ Mé*ico A 100 3($$($013
),1$ Mé*ico A 300 3($$($013
)P&7 +rasil A 100 3($3($013
J.-'' Mé*ico A $00 3($3($013 AS,1" +rasil + $00 3($3($013
/211 +rasil A "00 3($3($013
4&3 Mé*ico A 100 3($3($013
Mon"o "o"al (en+i+o #or la e$#re!a
Mon"o (en+i+o a M;ni+a+e! (en+i+a! a M;
-
8/18/2019 Clase2_Ejercicios_resultos
10/11
$%porte Apellido
S( $5600000
S( 15600000 8
S( 1$650000 P
S( "600000 )
S( '0600000 /
S( 30600000 S
S( $650000 .
S( 7650000 4
S( $600000 9
S( 5600000 , S( '600000 2
S( #600000 -
S( $650000 :
!u$a S+, 18-.---,--
!u$ar.!i.&on:un"o S+, **.---,--
!u$ar.!i.&on:un"o S+, 111.---,--
!u$ar.!i //--!u$ar.!i 44--
!u$ar.!i S+, 0).---,--
-
8/18/2019 Clase2_Ejercicios_resultos
11/11
No%&re Sexo Edad Estado Ci#il
A M 1& C 3($$($013
+ $0 D 3($$($013
C 1" C 3($$($013
D 15 S 3($$($013
M 17 S 3($$($013
M 15 S 3($$($013
G 1' S 3($$($013
1$ S 3($$($013
; M 1# S 3($$($013
J 13 C 3($$($013< 1& D 3($$($013
M $$ C 3($$($013
M $1 C 3($$($013
an"i+a+ +e Mu:ere! $enore! +e 15 a?o! 4
an"i+a+ +e @o$bre! $ayore! +e 18 a?o! /
an"i+a+ +e Mu:ere! &a!a+a! $enore! +e 15 a?o! 1
an"i+a+ +e Mu:ere! $ayore! +e 18 a?o! *an"i+a+ +e @o$bre! !ol"ero! (
an"i+a+ +e Mu:ere! !ol"era! (
Fecha de laEncuesta