0% encontró este documento útil (0 votos)
4 vistas15 páginas

Ingresos Diarios y Remuneraciones 2025

El documento presenta un cuadro de ingresos diarios por la venta de boletos en diferentes salas y localidades, con un total de ingresos de S/. 154,643.70. Además, incluye un desglose de remuneraciones y descuentos para trabajadores, calculando asignaciones familiares, incentivos y otros beneficios. Se detalla también un sistema de descuentos aplicables a trabajadores en función de su proyecto y riesgo asociado.

Cargado por

Omar Macha
Derechos de autor
© All Rights Reserved
Nos tomamos en serio los derechos de los contenidos. Si sospechas que se trata de tu contenido, reclámalo aquí.
Formatos disponibles
Descarga como XLSX, PDF, TXT o lee en línea desde Scribd
0% encontró este documento útil (0 votos)
4 vistas15 páginas

Ingresos Diarios y Remuneraciones 2025

El documento presenta un cuadro de ingresos diarios por la venta de boletos en diferentes salas y localidades, con un total de ingresos de S/. 154,643.70. Además, incluye un desglose de remuneraciones y descuentos para trabajadores, calculando asignaciones familiares, incentivos y otros beneficios. Se detalla también un sistema de descuentos aplicables a trabajadores en función de su proyecto y riesgo asociado.

Cargado por

Omar Macha
Derechos de autor
© All Rights Reserved
Nos tomamos en serio los derechos de los contenidos. Si sospechas que se trata de tu contenido, reclámalo aquí.
Formatos disponibles
Descarga como XLSX, PDF, TXT o lee en línea desde Scribd

CUADRO DE INGRESOS DIARIOS

Precio del Boleto


Fecha: 18 de June de 2025 Niños
S/. 11.50

Sala 1 Sala 2 Sala 3 Total


Local
Niños Adultos Niños Adultos Niños Adultos Niños
Larcomar 138 231 179 92 136 465 453
Monterrico 99 143 119 645 99 448 317
San Miguel 128 125 85 212 166 283 379
Los Olivos 126 487 81 94 33 89 240
El Callao 152 568 45 104 105 220 302
Totales 643 1554 509 1147 539 1505 1691

Sala 4 Sala 5 Sala 6 Total


Local
Niños Adultos Niños Adultos Niños Adultos Niños
Larcomar 96 200 80 200 120 200 296
Monterrico 80 150 65 258 110 159 255
San Miguel 65 168 58 361 120 156 243
Los Olivos 91 152 59 158 120 145 270
El Callao 36 146 69 581 100 159 205
Totales 368 816 331 1558 570 819 1269

Total 1011 2370 840 2705 1109 2324 2960


IOS

Precio del Boleto


Adultos
S/. 16.30

Total Total de
Ingresos
Adultos Personas
788 1241 S/. 18,053.90
1236 1553 S/. 23,792.30
620 999 S/. 14,464.50
670 910 S/. 13,681.00
892 1194 S/. 18,012.60
4206 5897 S/. 88,004.30

Total Total de
Ingresos
Adultos Personas
600 896 S/. 13,184.00
567 822 S/. 12,174.60
685 928 S/. 13,960.00
455 725 S/. 10,521.50
886 1091 S/. 16,799.30
3193 4462 S/. 66,639.40

7399 10359 S/. 154,643.70 0


REMU

Minutos
T_Serv.

Tardzs
Apellido Apellido Asign.

Hijos
ID Trab. Nombres Básico
Paterno Materno Fam.

97031 Aguirre Alzamora Brian 5 0 10 $ 700.00 $ -


97012 Lengua Balbin Armando 3 2 10 $ 500.00 $ 40.00
97054 Alvarez Bolivar Carlos 3 1 50 $ 1,200.00 $ 96.00
97038 Perez Buendia Kelly 6 0 100 $ 750.00 $ -
97035 Cruz Camino Janeth 3 2 120 $ 500.00 $ 40.00
97045 Romero Cardenas Wendy 14 1 30 $ 900.00 $ 72.00
97004 Acevedo Carhuas David 12 2 30 $ 1,000.00 $ 80.00
97011 Cisneros Carreño Carlos 12 1 40 $ 780.00 $ 62.40
97013 Mori Castro Edward 2 0 102 $ 480.00 $ -
97007 Carpio Conde Lesly 7 2 0 $ 650.00 $ 52.00
97029 Santander Cruz Milagros 8 2 0 $ 950.00 $ 76.00
97030 Izaguirre Cruz Lady 7 1 18 $ 980.00 $ 78.40
97044 Espino Davalos Marcela 14 0 0 $ 600.00 $ -
97057 Ortega Davila Fernando 5 1 10 $ 1,200.00 $ 96.00
97002 Salvador Diaz Jenny 7 2 0 $ 900.00 $ 72.00
97047 Rocca Duran Luis 8 0 0 $ 1,000.00 $ -
97015 Santos Falen Elizabeth 6 1 16 $ 780.00 $ 62.40
97005 Martinez Farias Jose 13 3 0 $ 650.00 $ 52.00

REALIZAR:
En la hoja de calculo Planilla deberá realizar los cálculos de remuneraciones, descuentos y totales, de la siguien
Asignación Familiar: es el 8% del básico SI tiene hijos.
Tiempo de Servicio: es el 20% del básico SI tiene a partir de 10 años, en caso contrario será 10% del básico.
Incentivos: es el 15% del básico para todos.
Movilidad. SI tiene menos de 10 años recibirá 9% del básico de lo contrario, si es mas antiguo recibirá el 18% d
Refrigerio: SI tiene de 10 años a mas recibirá el 20% del básico, sino recibirá el 14% del básico.
TOTAL REMUNERACION: Es la suma de todas las remuneraciones.
AFP: es el 13.8% del básico para todos por estar en la misma AFP.
Adelanto: SI el tiempo de servicio es mayor igual a 12 será del 20% del básico.
Tardanzas: SI tiene mas de 99 minutos es el 15% del básico.
TOTAL DESCUENTO: es la suma de todos los descuentos.
NETO PAGAR: es el TOTAL REMUNERACION – TOTAL DESCUENTO.
REMUNERACIONES DESCUENTO

Tiemp TOTAL
Incentivos Movilidad Refrigerio AFP
Serv. REMUN.

$ 70.00 $ 105.00 $ 63.00 $ 98.00 $ 1,036.00 $ 96.60


$ 50.00 $ 75.00 $ 45.00 $ 70.00 $ 780.00 $ 69.00
$ 120.00 $ 180.00 $ 108.00 $ 168.00 $ 1,872.00 $ 165.60
$ 75.00 $ 112.50 $ 67.50 $ 105.00 $ 1,110.00 $ 103.50
$ 50.00 $ 75.00 $ 45.00 $ 70.00 $ 780.00 $ 69.00
$ 180.00 $ 135.00 $ 162.00 $ 180.00 $ 1,629.00 $ 124.20
$ 200.00 $ 150.00 $ 180.00 $ 200.00 $ 1,810.00 $ 138.00
$ 156.00 $ 117.00 $ 140.40 $ 156.00 $ 1,411.80 $ 107.64
$ 48.00 $ 72.00 $ 43.20 $ 67.20 $ 710.40 $ 66.24
$ 65.00 $ 97.50 $ 58.50 $ 91.00 $ 1,014.00 $ 89.70
$ 95.00 $ 142.50 $ 85.50 $ 133.00 $ 1,482.00 $ 131.10
$ 98.00 $ 147.00 $ 88.20 $ 137.20 $ 1,528.80 $ 135.24
$ 120.00 $ 90.00 $ 108.00 $ 120.00 $ 1,038.00 $ 82.80
$ 120.00 $ 180.00 $ 108.00 $ 168.00 $ 1,872.00 $ 165.60
$ 90.00 $ 135.00 $ 81.00 $ 126.00 $ 1,404.00 $ 124.20
$ 100.00 $ 150.00 $ 90.00 $ 140.00 $ 1,480.00 $ 138.00
$ 78.00 $ 117.00 $ 70.20 $ 109.20 $ 1,216.80 $ 107.64
$ 130.00 $ 97.50 $ 117.00 $ 130.00 $ 1,176.50 $ 89.70

entos y totales, de la siguiente manera:

ario será 10% del básico.

mas antiguo recibirá el 18% del básico.


% del básico.
DESCUENTOS

TOTAL NETO
Adelanto Tardanzas
DESCTO PAGAR

$ - $ - $ 96.60 $ 939.40
$ - $ - $ 69.00 $ 711.00
$ - $ - $ 165.60 $ 1,706.40
$ - $ 112.50 $ 216.00 $ 894.00
$ - $ 75.00 $ 144.00 $ 636.00
$ 180.00 $ - $ 304.20 $ 1,324.80
$ 200.00 $ - $ 338.00 $ 1,472.00
$ 156.00 $ - $ 263.64 $ 1,148.16
$ - $ 72.00 $ 138.24 $ 572.16
$ - $ - $ 89.70 $ 924.30
$ - $ - $ 131.10 $ 1,350.90
$ - $ - $ 135.24 $ 1,393.56
$ 120.00 $ - $ 202.80 $ 835.20
$ - $ - $ 165.60 $ 1,706.40
$ - $ - $ 124.20 $ 1,279.80
$ - $ - $ 138.00 $ 1,342.00
$ - $ - $ 107.64 $ 1,109.16
$ 130.00 $ - $ 219.70 $ 956.80
Venta Mensuales por Vendedor

Código Categ Zona Tipo Monto MOVILIDAD


Cq-001 A Callao E S/. 14,800.00 S/. 2,960.00
Cq-002 D Callao E S/. 14,800.00 SIN MOVILIDAD
Cq-003 A Callao C S/. 15,260.00 S/. 3,052.00
Cq-004 C Lima E S/. 16,520.00 SIN MOVILIDAD
Cq-005 D Lima E S/. 16,520.00 SIN MOVILIDAD
Cq-006 A Callao E S/. 17,850.00 S/. 3,570.00
Cq-007 C Lima C S/. 17,960.00 SIN MOVILIDAD
Cq-008 B Lima E S/. 18,960.00 SIN MOVILIDAD
Cq-009 A Callao E S/. 19,850.00 S/. 3,970.00
Cq-010 A Callao C S/. 21,650.00 S/. 4,330.00
Cq-011 B Callao C S/. 21,690.00 SIN MOVILIDAD
Cq-012 D Callao C S/. 21,690.00 SIN MOVILIDAD
Cq-013 A Lima C S/. 25,600.00 SIN MOVILIDAD
Cq-014 D Lima C S/. 25,600.00 SIN MOVILIDAD
BONIFICACIÓN La Movilidad será del 20% del Monto para
S/. 20.00 los vendedora cuya categoría es A y
S/. 20.00 La Zona es Callao
S/. 20.00 para el resto mostrar SIN MOVILIDAD
S/. 50.00
S/. 20.00
S/. 20.00 Para las categ B o C le corresponde
S/. 50.00 50 soles de bonificacion para el resto 20
S/. 50.00
S/. 20.00
S/. 20.00
S/. 50.00
S/. 20.00
S/. 20.00
S/. 20.00
Use la funcion si con Y
Se desea calcular el descuento para los trabajadores de una compañía que laboran en d
El descuento se aplica con el 8% de su Sueldo solo a los trabajadores que se encuentren trab
el Proyectos CerroVial y que ademas el riesgo sea baja

Cod Apel Proyecto Riesgo Sueldo Descuento


X01 Gonzales SolTrans Alta $ 4,500.00 $ -
X02 Quispe CerroVial Baja $ 3,500.00 $ 280.00
X03 Quilla Parinas Media $ 4,800.00 $ -
X04 Salinas CerroVial Baja $ 4,600.00 $ 368.00
X05 Rosales CerroVial Baja $ 4,500.00 $ 360.00
X06 Cordero Parinas Baja $ 4,580.00 $ -
X07 Ramirez Putumayo Media $ 1,450.00 $ -
X08 Sanchez CerroVial Media $ 4,568.00 $ -
X09 Samaniego CerroVial Baja $ 3,568.00 $ 285.44
X10 Diaz Parinas Baja $ 1,456.00 $ -
añía que laboran en distintos proyectos.
ue se encuentren trabajando en:
Estado Tipo
Código Apellidos Nombres Sexo
Civil de seguro
MCONP1980 SALAZAR ALTA DANIEL M C ONP
MSONP1978 BORJA HARO OSCAR M S ONP
FSAFP1975 EUSEBIO CARRASCO ROSARIO F S AFP
MSAFP1980 FACHO INGA GUILLERMO M S AFP
MCAFP1970 VÁSQUEZ REGALADO ERICK M C AFP
FCONP1979 MARCELO DEXTRE BEATRIZ F C ONP
MDAFP1981 VALDIVIA GAMBOA MARCO M D AFP
FCAFP1988 REYES AYALA ADELA F C AFP
FDONP1963 SÁNCHEZ VILLAFANA MARÍA F D ONP
MVONP1980 PISFIL CAMPOJO EDWIN M V ONP
FCAFP1993 MAYTA CALLA ROXANA F C AFP
FVONP1980 HUAMÁN ACURIO MARIBEL F V ONP
MDONP1970 ELERA GAMARA JOSÉ M D ONP
FDAFP1979 RAMOS RAMÍREZ YESENIA F D AFP
FCONP1981 NEYRA SÁNCHEZ SOFÍA F C ONP

OBSERVACIÓN:
Utilice el Código para determinar el Sexo, Estado Civil, Tipo de seguro, Año de nacimiento
Año
Completar:
de nacimiento
1980
1978 CANTIDAD DE VARONES: 7
1975 CANTIDAD DE MUJERES: 8
1980 CANTIDAD DE SOLTEROS: 3
1970 CANTIDAD DE CASADOS: 6
1979 CANTIDAD DE VIUDOS: 2
1981 CANTIDAD DE DIVORCIADOS: 4
1988 CANTIDAD CON AFP: 7
1963
1980
1993
1980
1970
1979
1981

, Año de nacimiento
Utilizando los datos de la tabla, diseñar el siguiente gráfico:

Mes Ventas
Jan XDR 2,000.00
Feb XDR 3,000.00
Mar XDR 1,000.00
Apr XDR 1,500.00
May XDR 1,000.00
Jun XDR 1,500.00
Jul XDR 2,000.00
Aug XDR 2,500.00
Sep XDR 3,000.00
Oct XDR 2,800.00
Nov XDR 3,000.00
Dec XDR 3,500.00

Ventas
XDR4,000.00

XDR3,500.00

XDR3,000.00 XDR3,000.00

XDR2,500.00

XDR2,000.00 XDR2,000.00 XD

XDR1,500.00 XDR1,500.00 XDR1,500.0

XDR1,000.00 XDR1,000.00 XDR1,000.00

XDR500.00

XDR-
1 2 3 4 5 6 7
Ventas

XDR3,500.00

XDR3,000.00 XDR3,000.00
XDR2,800.00

XDR2,500.00

Ventas
XDR2,000.00

XDR1,500.00 XDR1,500.00

.00 XDR1,000.00

5 6 7 8 9 10 11 12

Common questions

Con tecnología de IA

Eligibility for discounts for employees on the CerroVial project is determined by both project involvement and the assessed risk level. Employees involved in projects labeled as CerroVial and classified with low risk receive a discount of 8% off their base salary. For example, employees like Quispe and Salinas engaged in CerroVial with low risk qualify for their salary to be discounted by this percentage, resulting in monetary discounts of $280.00 and $368.00 respectively .

The family allowance for employees with children is calculated as 8% of the basic salary, which subsequently enhances their total earnings. This allowance affects employees' take-home pay by increasing the amount added to their salary, reflecting in the total remuneration figures such as those for employees like Acevedo Carhuas, David, who receive $80.00 as family allowance due to having two children, augmenting his total earnings .

Sales figures are closely correlated with mobility and bonus allocations based on both sales performance and zone-specific factors. For instance, employees in high-performing zones like Callao and Lima receive variable bonuses based on their sales category. In Callao, representative Cq-010 earns increased bonuses due to higher sales, directly boosting this mobility-focused incentive which is set at 20%, creating economic motivation and rewarding sales efficacy and zone-specific excellence .

Attendance-related deductions, such as tardiness, are significant as they are applied when an employee accumulates over 99 minutes of tardiness, resulting in a deduction of 15% from their basic salary. This deduction reduces the employee's net pay by directly affecting the total earnings after all remuneration components are accounted for. Such deductions reinforce punctuality and attendance fidelity as seen in the treatment of Perez Buendia, Kelly, where tardiness impacts final calculations .

The net payment for an employee is determined by subtracting total discounts from the total remuneration. Total remuneration includes basic salary, family allocation, incentives, mobility, and refreshments. Discounts may include APS (Administrative Processing System) deductions, tardy deductions, and any other applicable reductions like project-specific discount clauses. For instance, Aguirre Alzamora, Brian's total remuneration is calculated by adding incentives and service allotments to his basic salary, then subtracting discounts such as AFP deductions which are standard at 13.8% for all employees.

An employee’s transportation benefits are influenced by their length of service. Those with less than 10 years of service receive mobility benefits equivalent to 9% of their basic salary. Conversely, employees with longer service, over 10 years or more, receive enhanced benefits calculated at 18% of their basic salary. This policy is designed to reward employee loyalty and tenure, thus impacting their overall benefit package and net income .

The total remuneration of an employee such as Aguirre Alzamora, Brian, is influenced by several factors including their basic salary, family allowance, incentives, service time, and benefits such as mobility and refreshments. Brian receives a basic salary of $700.00, no family allowance due to having no children, and professional incentives at 15% of the basic salary. If the employee has more than 10 years of service, they receive 20% of their basic salary for their service time. In terms of mobility, employees with less than 10 years of service receive 9% of their basic, and refreshments are calculated at 14% unless they have more than 10 years of service .

In the remuneration structure, incentives play a pivotal role by providing additional monetary compensation pegged at 15% of the basic salary for all employees, irrespective of their service duration or position. This amount is integrated with other compensation components, such as salary, family allocation, and service time bonuses, to enhance overall earnings. Incentives align personal performance and organization goals, encouraging higher productivity, as seen with professionals like Alvarez Bolivar, Carlos, who receives $180.00 in incentives .

The total income from children's tickets at the 'Larcomar' location on June 18, 2025, is calculated by multiplying the number of children tickets sold by the price per ticket. Specifically for 'Larcomar,' the tickets sold were: 138 in Sala 1, 179 in Sala 2, 136 in Sala 3, 96 in Sala 4, 80 in Sala 5, and 120 in Sala 6. The total number of children's tickets sold is 296 (sum of all salas). At a ticket price of S/. 11.50 each, the total income from children's tickets at 'Larcomar' is S/. 3,404.00 .

The bonus received by sales representatives is contingent on the intersection of their category and operational zone. Representatives categorized as 'A' within the 'Callao' zone, such as Cq-001, receive a bonus calculated as 20% of their sales amount. All other representatives, regardless of zone, receive a flat bonus of 50 soles if they fall under categories B or C. Otherwise, the standard bonus is at 20 soles. This distinction underscores how category and zone directly dictate the monetary incentive for salespersons .

También podría gustarte