Tienda La Económica.
1- Para el mes de Enero se pronostica Ventas de 600 Unidades con un aumento del 15%
para los meses siguientes. Periodo Enero a Junio 2024
2- El Precio de Venta es de Cs 700,00
3- El Cobro de las Ventas es 60% de Contado, 30% a 1 Mes y 10% a 2 Meses
4- Se esperan compras de Productos para el mes de Enero por 700 Unidades con un aumento
del 10% en relacion al Mes Anterior. Periodo Enero a Junio 2024
5- El precio de Compra es de Cs 350,00 por cada Unidad.
6- Las Compras se Pagan el 50% de Contado y el Resto a 1 Mes de Plazo.
7- Las Cuentas por Cobrar al 31 12 2023 son:
A 30 Dias/ Cs 5000,00
A 60 Dias/ Cs 2500,00
8- Las Cuentas por Pagar por compra de Productos al 31 12 2023 son: Cs 6,000,00
Tienda La Economica
Presupuesto de Ventas
Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24
Unidades a Vender 600 690 794 913 1049 1207
Precio de Venta C$700.00 C$700.00 C$700.00 C$700.00 C$700.00 C$700.00
Total Ventas C$420,000.00 C$483,000.00 C$555,450.00 C$638,764.00 C$734,573.00 C$844,753.00
Tienda La Economica
Presupuesto de Cobro
Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24
Contado 60% C$252,000.00 C$289,800.00 C$333,270.00 C$383,258.40 C$440,743.80 C$506,851.80
Credito 30 Dias 30% C$5,000.00 C$126,000.00 C$144,900.00 C$166,635.00 C$191,629.20 C$220,371.90
Credito 60 Dias 10%
C$2,500.00 C$42,000.00 C$48,300.00 C$55,545.00 C$63,876.40
Total Cuentas x Cobrar C$257,000.00 C$418,300.00 C$520,170.00 C$598,193.40 C$687,918.00 C$791,100.10
C$555,450.00
C$638,764.00
Jul-24 Aug-24
C$253,425.90
C$73,457.30 C$84,475.30
C$326,883.20 C$84,475.30
Tienda La Economica
Presupuesto de Compras
Jan-24 Feb-24 Mar Apr-24 May-24 Jun-24
Unidades a Comprar 700 770 847 932 1025 1127
Precio de Compra C$350.00 C$350.00 C$350.00 C$350.00 C$350.00 C$350.00
Total Compras C$245,000.00 C$269,500.00 C$296,450.00 C$326,095.00 C$358,704.50 C$394,574.95
Tienda La Economica
Presupuesto de Pago.
Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24
Contado 50% C$122,500.00 C$134,750.00 C$148,225.00 C$163,047.50 C$179,352.25 C$197,287.48
Credito 30 Dias 50% C$6,000.00 C$122,500.00 C$134,750.00 C$148,225.00 C$163,047.50 C$179,352.25 C$197,287.48
Total Cuentas x Pagar C$128,500.00 C$257,250.00 C$282,975.00 C$311,272.50 C$342,399.75 C$376,639.73 C$197,287.48
Aug-24
C$0.00
Tienda La Economica. TC BCN 36.6243
PAGO DE PLANILLA 01- 31 Enero 2024.
INGRESOS
Numero Patronal
Salario Ordinario Salario Ordinario Feriado 01
No. INSS Nombres y apellidos CARGO Salario Diario Total Devengado Inss Laboral IR Salarios Total Deduccion Neto a Recibir InssPatronal Inatec
$ Cs Enero 24
Amador Cantillano Scarleth Vanessa $400.00 C$14,649.72 C$488.32 C$976.65 C$15,626.37 C$1,093.85 C$929.88 C$2,023.72 C$13,602.64 C$3,359.67 C$312.53
Amador Morales Francis Anneth $500.00 C$18,312.15 C$610.41 C$1,220.81 C$19,532.96 C$1,367.31 C$1,549.80 C$2,917.10 C$16,615.86 C$4,199.59 C$390.66
Baldelomar Incer Ashly Gisselle $600.00 C$21,974.58 C$732.49 C$1,464.97 C$23,439.55 C$1,640.77 C$2,276.42 C$3,917.19 C$19,522.36 C$5,039.50 C$468.79
Baldelomar Jiménez Mauricio José $700.00 C$25,637.01 C$854.57 C$1,709.13 C$27,346.14 C$1,914.23 C$3,003.05 C$4,917.28 C$22,428.86 C$5,879.42 C$546.92
Baldelomar Mendoza Robin Daniel $800.00 C$29,299.44 C$976.65 C$1,953.30 C$31,252.74 C$2,187.69 C$3,729.68 C$5,917.37 C$25,335.37 C$6,719.34 C$625.05
Bustos Cano David Jose $900.00 C$32,961.87 C$1,098.73 C$2,197.46 C$35,159.33 C$2,461.15 C$4,632.88 C$7,094.03 C$28,065.30 C$7,559.26 C$703.19
Centeno Valle Eddy José $1,000.00 C$36,624.30 C$1,220.81 C$2,441.62 C$39,065.92 C$2,734.61 C$5,541.16 C$8,275.77 C$30,790.15 C$8,399.17 C$781.32
Cerda Pereira Jorge Luis $1,100.00 C$40,286.73 C$1,342.89 C$2,685.78 C$42,972.51 C$3,008.08 C$6,449.44 C$9,457.52 C$33,514.99 C$9,239.09 C$859.45
TOTAL A INSS $6,000.00 $219,745.80 $7,324.86 $14,649.72 $234,395.52 $16,407.69 $28,112.30 $44,519.99 $189,875.53 $50,395.04 $4,687.91
OTROS PAGOS
TOTALES
Nota: Se Paga Feriado 01 Enero 2024 a Todo el Personal , Calcular y Pagar.
Elaborado: Autorizado:
Tienda La Economica. TC BCN 36.6243
PAGO DE PLANILLA 01- 29 Febrero 2024.
INGRESOS
Numero Patronal
Salario Ordinario Salario Ordinario
No. INSS Nombres y apellidos CARGO Salario Diario Horas Extras Total Devengado Inss Laboral IR Salarios Total Deduccion Neto a Recibir InssPatronal Inatec
$ Cs
Amador Cantillano Scarleth Vanessa $400.00 C$14,649.72 C$488.32 C$1,220.81 C$15,870.53 C$1,110.94 C$963.94 C$2,074.88 C$13,795.65 C$3,412.16 C$317.41
Amador Morales Francis Anneth $500.00 C$18,312.15 C$610.41 C$1,526.01 C$19,838.16 C$1,388.67 C$1,606.56 C$2,995.24 C$16,842.93 C$4,265.20 C$396.76
Baldelomar Incer Ashly Gisselle $600.00 C$21,974.58 C$732.49 C$1,831.22 C$23,805.80 C$1,666.41 C$2,344.54 C$4,010.95 C$19,794.84 C$5,118.25 C$476.12
Baldelomar Jiménez Mauricio José $700.00 C$25,637.01 C$854.57 C$2,136.42 C$27,773.43 C$1,944.14 C$3,082.52 C$5,026.66 C$22,746.76 C$5,971.29 C$555.47
Baldelomar Mendoza Robin Daniel $800.00 C$29,299.44 C$976.65 C$2,441.62 C$31,741.06 C$2,221.87 C$3,838.13 C$6,060.00 C$25,681.06 C$6,824.33 C$634.82
Bustos Cano David Jose $900.00 C$32,961.87 C$1,098.73 C$2,746.82 C$35,708.69 C$2,499.61 C$4,760.60 C$7,260.21 C$28,448.48 C$7,677.37 C$714.17
Centeno Valle Eddy José $1,000.00 C$36,624.30 C$1,220.81 C$3,052.02 C$39,676.33 C$2,777.34 C$5,683.08 C$8,460.42 C$31,215.90 C$8,530.41 C$793.53
Cerda Pereira Jorge Luis $1,100.00 C$40,286.73 C$1,342.89 C$3,357.23 C$43,643.96 C$3,055.08 C$6,605.55 C$9,660.63 C$33,983.33 C$9,383.45 C$872.88
TOTAL A INSS $6,000.00 $219,745.80 $7,324.86 $18,312.15 $238,057.95 $16,664.06 $28,884.94 $45,549.00 $192,508.95 $51,182.46 $4,761.16
OTROS PAGOS
TOTALES
Nota: Se Paga 10 Horas Extras a Cada Trabajador.
Elaborado: Autorizado:
Tienda La Economica. TC BCN 36.6243
PAGO DE PLANILLA 01- 31 Marzo 2024.
INGRESOS
Numero Patronal
Salario Ordinario Salario Ordinario Feriado J + V
No. INSS Nombres y apellidos CARGO Salario Diario Total Devengado Inss Laboral IR Salarios Total Deduccion Neto a Recibir InssPatronal Inatec
$ Cs Santos
Amador Cantillano Scarleth Vanessa $400.00 C$14,649.72 C$488.32 C$1,953.30 C$16,603.02 C$1,162.21 C$1,066.12 C$2,228.33 C$14,374.68 C$3,569.65 C$332.06
Amador Morales Francis Anneth $500.00 C$18,312.15 C$610.41 C$2,441.62 C$20,753.77 C$1,452.76 C$1,776.87 C$3,229.63 C$17,524.14 C$4,462.06 C$415.08
Baldelomar Incer Ashly Gisselle $600.00 C$21,974.58 C$732.49 C$2,929.94 C$24,904.52 C$1,743.32 C$2,548.91 C$4,292.22 C$20,612.30 C$5,354.47 C$498.09
Baldelomar Jiménez Mauricio José $700.00 C$25,637.01 C$854.57 C$3,418.27 C$29,055.28 C$2,033.87 C$3,320.95 C$5,354.82 C$23,700.46 C$6,246.88 C$581.11
Baldelomar Mendoza Robin Daniel $800.00 C$29,299.44 C$976.65 C$3,906.59 C$33,206.03 C$2,324.42 C$4,178.74 C$6,503.16 C$26,702.87 C$7,139.30 C$664.12
Bustos Cano David Jose $900.00 C$32,961.87 C$1,098.73 C$4,394.92 C$37,356.79 C$2,614.98 C$5,143.79 C$7,758.76 C$29,598.02 C$8,031.71 C$747.14
Centeno Valle Eddy José $1,000.00 C$36,624.30 C$1,220.81 C$4,883.24 C$41,507.54 C$2,905.53 C$6,108.84 C$9,014.36 C$32,493.18 C$8,924.12 C$830.15
Cerda Pereira Jorge Luis $1,100.00 C$40,286.73 C$1,342.89 C$5,371.56 C$45,658.29 C$3,196.08 C$7,113.66 C$10,309.74 C$35,348.55 C$9,816.53 C$913.17
TOTAL A INSS $6,000.00 $219,745.80 $7,324.86 $29,299.44 $249,045.24 $17,433.17 $31,257.87 $48,691.03 $200,354.21 $53,544.73 $4,980.90
OTROS PAGOS
TOTALES
Nota: Se Pagan a todo el Personal Feriado Jueves y Viernes Santos
Elaborado: Autorizado:
Tienda La Economica. TC BCN 36.6243
PAGO DE PLANILLA 01- 30 Abril 2024.
INGRESOS
Numero Patronal
Salario Ordinario Salario Ordinario
No. INSS Nombres y apellidos CARGO Salario Diario Total Devengado Inss Laboral IR Salarios Total Deduccion Neto a Recibir InssPatronal Inatec
$ Cs
Amador Cantillano Scarleth Vanessa $400.00 C$14,649.72 C$488.32 C$14,649.72 C$1,025.48 C$793.64 C$1,819.12 C$12,830.60 C$3,149.69 C$292.99
Amador Morales Francis Anneth $500.00 C$18,312.15 C$610.41 C$18,312.15 C$1,281.85 C$1,322.73 C$2,604.58 C$15,707.57 C$3,937.11 C$366.24
Baldelomar Incer Ashly Gisselle $600.00 C$21,974.58 C$732.49 C$21,974.58 C$1,538.22 C$2,003.94 C$3,542.16 C$18,432.42 C$4,724.53 C$439.49
Baldelomar Jiménez Mauricio José $700.00 C$25,637.01 C$854.57 C$25,637.01 C$1,794.59 C$2,685.15 C$4,479.74 C$21,157.27 C$5,511.96 C$512.74
Baldelomar Mendoza Robin Daniel $800.00 C$29,299.44 C$976.65 C$29,299.44 C$2,050.96 C$3,366.36 C$5,417.32 C$23,882.12 C$6,299.38 C$585.99
Bustos Cano David Jose $900.00 C$32,961.87 C$1,098.73 C$32,961.87 C$2,307.33 C$4,121.97 C$6,429.30 C$26,532.57 C$7,086.80 C$659.24
Centeno Valle Eddy José $1,000.00 C$36,624.30 C$1,220.81 C$36,624.30 C$2,563.70 C$4,973.48 C$7,537.18 C$29,087.12 C$7,874.22 C$732.49
Cerda Pereira Jorge Luis $1,100.00 C$40,286.73 C$1,342.89 C$40,286.73 C$2,820.07 C$5,825.00 C$8,645.07 C$31,641.66 C$8,661.65 C$805.73
TOTAL A INSS $6,000.00 $219,745.80 $7,324.86 $0.00 $219,745.80 $15,382.21 $25,092.26 $40,474.47 $179,271.33 $47,245.35 $4,394.92
OTROS PAGOS
TOTALES
Nota: No hay Pagos Adicionales
Elaborado: Autorizado:
Tienda La Economica. TC BCN 36.6243
PAGO DE PLANILLA 01- 31 Mayo 2024.
INGRESOS
Numero Patronal
Salario Ordinario Salario Ordinario Feriado 01
No. INSS Nombres y apellidos CARGO Salario Diario Total Devengado Inss Laboral IR Salarios Total Deduccion Neto a Recibir InssPatronal Inatec
$ Cs Mayo 24
Amador Cantillano Scarleth Vanessa $500.00 C$18,312.15 C$610.41 C$1,220.81 C$19,532.96 C$1,367.31 C$1,549.80 C$2,917.10 C$16,615.86 C$4,199.59 C$390.66
Amador Morales Francis Anneth $600.00 C$21,974.58 C$732.49 C$1,464.97 C$23,439.55 C$1,640.77 C$2,276.42 C$3,917.19 C$19,522.36 C$5,039.50 C$468.79
Baldelomar Incer Ashly Gisselle $700.00 C$25,637.01 C$854.57 C$1,709.13 C$27,346.14 C$1,914.23 C$3,003.05 C$4,917.28 C$22,428.86 C$5,879.42 C$546.92
Baldelomar Jiménez Mauricio José $800.00 C$29,299.44 C$976.65 C$1,953.30 C$31,252.74 C$2,187.69 C$3,729.68 C$5,917.37 C$25,335.37 C$6,719.34 C$625.05
Baldelomar Mendoza Robin Daniel $900.00 C$32,961.87 C$1,098.73 C$32,961.87 C$2,307.33 C$4,047.57 C$6,354.91 C$26,606.96 C$7,086.80 C$659.24
Bustos Cano David Jose $1,000.00 C$36,624.30 C$1,220.81 C$2,441.62 C$39,065.92 C$2,734.61 C$5,182.93 C$7,917.54 C$31,148.38 C$8,399.17 C$781.32
Centeno Valle Eddy José $1,100.00 C$40,286.73 C$1,342.89 C$40,286.73 C$2,820.07 C$5,410.00 C$8,230.07 C$32,056.66 C$8,661.65 C$805.73
Cerda Pereira Jorge Luis $1,200.00 C$43,949.16 C$1,464.97 C$2,929.94 C$46,879.10 C$3,281.54 C$7,454.27 C$10,735.81 C$36,143.30 C$10,079.01 C$937.58
TOTAL A INSS $6,800.00 $249,045.24 $8,301.51 $11,719.78 $260,765.02 $18,253.55 $32,653.72 $50,907.27 $209,857.75 $56,064.48 $5,215.30
OTROS PAGOS
TOTALES
Nota: Se Paga al Personal Feriado 01 Mayo, Excepto a Centeno Valle Eddy y a Baldelomar Robin
Elaborado: Autorizado:
Tienda La Economica. TC BCN 36.6243
PAGO DE PLANILLA 01- 30 Junio 2024.
INGRESOS
Numero Patronal
Salario Ordinario Salario Ordinario
No. INSS Nombres y apellidos CARGO Salario Diario Vacaciones Total Devengado Inss Laboral IR Salarios Total Deduccion Neto a Recibir InssPatronal Inatec
$ Cs
Amador Cantillano Scarleth Vanessa $500.00 C$18,312.15 C$610.41 C$6,104.05 C$24,416.20 C$1,709.13 C$2,458.08 C$4,167.21 C$20,248.99 C$5,249.48 C$488.32
Amador Morales Francis Anneth $600.00 C$21,974.58 C$732.49 C$7,324.86 C$29,299.44 C$2,050.96 C$3,366.36 C$5,417.32 C$23,882.12 C$6,299.38 C$585.99
Baldelomar Incer Ashly Gisselle $700.00 C$25,637.01 C$854.57 C$11,109.37 C$36,746.38 C$2,572.25 C$5,001.87 C$7,574.11 C$29,172.27 C$7,900.47 C$734.93
Baldelomar Jiménez Mauricio José $800.00 C$29,299.44 C$976.65 C$10,743.13 C$40,042.57 C$2,802.98 C$5,768.23 C$8,571.21 C$31,471.36 C$8,609.15 C$800.85
Baldelomar Mendoza Robin Daniel $900.00 C$32,961.87 C$1,098.73 C$16,480.93 C$49,442.80 C$3,461.00 C$7,953.79 C$11,414.78 C$38,028.02 C$10,630.20 C$988.86
Bustos Cano David Jose $1,000.00 C$36,624.30 C$1,220.81 C$9,766.48 C$46,390.78 C$3,247.35 C$7,244.19 C$10,491.54 C$35,899.24 C$9,974.02 C$927.82
Centeno Valle Eddy José $1,100.00 C$40,286.73 C$1,342.89 C$12,086.02 C$52,372.75 C$3,666.09 C$8,635.00 C$12,301.09 C$40,071.66 C$11,260.14 C$1,047.45
Cerda Pereira Jorge Luis $1,200.00 C$43,949.16 C$1,464.97 C$17,579.66 C$61,528.82 C$4,307.02 C$11,541.54 C$15,848.56 C$45,680.26 C$13,228.70 C$1,230.58
TOTAL A INSS $6,800.00 $249,045.24 $8,301.51 $91,194.51 $340,239.75 $23,816.78 $51,969.05 $75,785.84 $264,453.91 $73,151.55 $6,804.79
OTROS PAGOS
TOTALES
Nota: Se Paga al Personal sus Vacaciones Según lo Indicado por RRHH
Elaborado: Autorizado:
Calculo IR
C$174,390.27
C$217,987.83
C$261,585.40
C$305,182.97
C$348,780.53
C$392,378.10
C$435,975.67
C$479,573.23
Calculo IR
C$177,115.11
C$221,393.89
C$265,672.67
C$309,951.45
C$354,230.23
C$398,509.01
C$442,787.79
C$487,066.57
Cálculo IR
C$185,289.66
C$231,612.07
C$277,934.49
C$324,256.90
C$370,579.32
C$416,901.73
C$463,224.15
C$509,546.56
Cálculo IR
C$163,490.88
C$204,363.59
C$245,236.31
C$286,109.03
C$326,981.75
C$367,854.47
C$408,727.19
C$449,599.91
Cálculo IR
C$217,987.83
C$261,585.40
C$305,182.97
C$348,780.53
C$367,854.47
C$435,975.67
C$449,599.91
C$523,170.80
Dias
Vacaciones
10
10
13
11
15
8
9
12
