Scribd Logo
Cargar

¡Te damos la bienvenida a Scribd!

  • 9 vistas

    Cía. Importadora La Tarapotina S.A

    Cargado por

    Johana Cruzado
    .

    Copyright:

    © All Rights Reserved
    Descargue como XLSX, PDF, TXT o lea en línea desde Scribd

    Cía. Importadora La Tarapotina S.A

    Cargado por

    Johana Cruzado
    9 vistas9 páginas
    .

    Título original

    TS09.S2

    Derechos de autor

    © © All Rights Reserved

    Formatos disponibles

    XLSX, PDF, TXT o lea en línea desde Scribd

    ¿Le pareció útil este documento?

    ¿Este contenido es inapropiado?

    .

    Copyright:

    © All Rights Reserved
    Descargue como XLSX, PDF, TXT o lea en línea desde Scribd
    Descargar como xlsx, pdf o txt
    9 vistas9 páginas

    Cía. Importadora La Tarapotina S.A

    Cargado por

    Johana Cruzado
    .

    Copyright:

    © All Rights Reserved
    Descargue como XLSX, PDF, TXT o lea en línea desde Scribd
    Descargar como xlsx, pdf o txt
    de 9

    Cía. Importadora La Tarapotina S.A.

    Con los datos que se mencionan a continuación, determine usted el costo de


    ventas mensual y comparar mes a mes con el costo de ventas determinado
    por el sistma de información Oracle. De hallar diferencias, explicarlas

    Costo Ventas
    Compras 60 20 28 SIOracle
    12/31/2020 5,619,318.40 1,212,162.20
    Enero 1,292,331.69 5,753,499.57 2,013,835.73 760,770.60
    Febrero 2,416,557.09 5,034,042.80 3,769,906.19 975,649.98
    Marzo 430,077.28 5,565,490.53 2,919,754.14 748,781.59
    Abril 695,295.57 6,417,366.65 1,910,869.07 1,107,713.52
    Mayo 403,727.91 6,892,158.62 444,213.67 1,140,182.93
    Junio 1,164,694.76 5,429,522.23 1,600,008.48 1,471,536.63
    Julio 102,724.11 5,307,102.22 525,822.12 1,303,257.57
    Agosto 717,592.45 4,136,283.48 756,523.77 1,653,782.53
    Setiembre 886,016.29 3,394,307.53 843,790.23 1,540,725.73
    Octubre 147,767.74 2,133,199.48 951,529.07 1,301,137.04
    Noviembre 134,490.78 1,442,829.19 933,266.33 843,123.68
    Diciembre 3,470.46 1,218,092.89 0.00 1,161,472.04
    Total 8,394,746.13 14,008,133.84

    Enero Febrero Marzo Abril Mayo


    Saldo inicial
    20 5,619,318.40 5,753,499.57 5,034,042.80 5,565,490.53 6,417,366.65
    28 1,212,162.20 2,013,835.73 3,769,906.19 2,919,754.14 1,910,869.07
    6,831,480.60 7,767,335.30 8,803,948.99 8,485,244.67 8,328,235.72

    Compras 1,292,331.69 2,416,557.09 430,077.28 695,295.57 403,727.91


    Saldo final
    20 -5,753,499.57 -5,034,042.80 -5,565,490.53 -6,417,366.65 -6,892,158.62
    28 -2,013,835.73 -3,769,906.19 -2,919,754.14 -1,910,869.07 -444,213.67
    -7,767,335.30 -8,803,948.99 -8,485,244.67 -8,328,235.72 -7,336,372.29

    Costo de ventas 356,476.99 1,379,943.40 748,781.60 852,304.52 1,395,591.34


    CV Oracle 760,770.60 975,649.98 748,781.59 1,107,713.52 1,140,182.93
    Diferencias -404,293.61 404,293.42 0.01 -255,409.00 255,408.41
    Diferencias
    Junio Julio Agosto Setiembre Octubre Noviembre Diciembre

    6,892,158.62 5,429,522.23 5,307,102.22 4,136,283.48 3,394,307.53 2,133,199.48 1,442,829.19


    444,213.67 1,600,008.48 525,822.12 756,523.77 843,790.23 951,529.07 933,266.33
    7,336,372.29 7,029,530.71 5,832,924.34 4,892,807.25 4,238,097.76 3,084,728.55 2,376,095.52

    1,164,694.76 102,724.11 717,592.45 886,016.29 147,767.74 134,490.78 3,470.46

    -5,429,522.23 -5,307,102.22 -4,136,283.48 -3,394,307.53 -2,133,199.48 -1,442,829.19 -1,218,092.89


    -1,600,008.48 -525,822.12 -756,523.77 -843,790.23 -951,529.07 -933,266.33 0.00
    -7,029,530.71 -5,832,924.34 -4,892,807.25 -4,238,097.76 -3,084,728.55 -2,376,095.52 -1,218,092.89

    1,471,536.34 1,299,330.48 1,657,709.54 1,540,725.78 1,301,136.95 843,123.81 1,161,473.09


    1,471,536.63 1,303,257.57 1,653,782.53 1,540,725.73 1,301,137.04 843,123.68 1,161,472.04
    -0.29 -3,927.09 3,927.01 0.05 -0.09 0.13 1.05
    Total

    5,619,318.40
    1,212,162.20
    6,831,480.60

    8,394,746.13

    -1,218,092.89
    0.00
    -1,218,092.89

    14,008,133.84
    14,008,133.84
    0.00
    Cía. Importadora La Loretana S.A.

    Con los datos que se mencionan a continuación, determine usted el costo de


    ventas mensual y comparar mes a mes con el costo de ventas determinado por
    el sistema de información Oracle. De hallar diferencias, explicarlas

    Costo Ventas
    Compras 60 20 28 SIOracle
    12/31/2020 11,792,912.79 2,634,392.14
    Enero 55,651.95 11,991,618.00 1,666,237.44 825,101.40
    Febrero 1,722,443.39 11,617,705.08 2,650,730.48 1,031,626.19
    Marzo 1,624,459.70 11,925,462.63 2,562,145.32 1,408,226.75
    Abril 1,188,545.69 11,381,698.84 3,469,585.04 914,496.85
    Mayo 862,917.88 11,821,184.48 1,951,946.25 1,885,377.48
    Junio 1,158,140.13 11,574,116.27 1,636,322.58 1,718,994.45
    Julio 961,109.24 10,304,376.35 2,000,349.19 1,868,150.64
    Agosto 844,414.03 9,156,146.49 1,895,538.02 2,095,318.62
    Setiembre 3,650,047.94 8,968,572.94 3,974,999.59 1,759,008.47
    Octubre 1,658,932.39 8,980,690.42 4,554,833.13 1,081,074.09
    Noviembre 5,940,284.23 10,662,085.10 6,695,293.40 2,113,603.40
    Diciembre 2,229,356.39 11,014,167.68 7,269,827.47 1,294,296.45
    Total 21,896,302.96 17,995,274.79

    Enero Febrero Marzo Abril


    Saldo inicial
    20 11,792,912.79 11,991,618.00 11,617,705.08 11,925,462.63
    28 2,634,392.14 1,666,237.44 2,650,730.48 2,562,145.32
    14,427,304.93 13,657,855.44 14,268,435.56 14,487,607.95

    Compras 55,651.95 1,722,443.39 1,624,459.70 1,188,545.69


    Saldo final
    20 -11,991,618.00 -11,617,705.08 -11,925,462.63 -11,381,698.84
    28 -1,666,237.44 -2,650,730.48 -2,562,145.32 -3,469,585.04
    -13,657,855.44 -14,268,435.56 -14,487,607.95 -14,851,283.88

    Costo de vent 825,101.44 1,111,863.27 1,405,287.31 824,869.76


    CV Oracle 825,101.40 1,031,626.19 1,408,226.75 914,496.85
    Diferencias 0.04 80,237.08 -2,939.44 -89,627.09
    Diferencias
    Mayo Junio Julio Agosto Setiembre Octubre

    11,381,698.84 11,821,184.48 11,574,116.27 10,304,376.35 9,156,146.49 8,968,572.94


    3,469,585.04 1,951,946.25 1,636,322.58 2,000,349.19 1,895,538.02 3,974,999.59
    14,851,283.88 13,773,130.73 13,210,438.85 12,304,725.54 11,051,684.51 12,943,572.53

    862,917.88 1,158,140.13 961,109.24 844,414.03 3,650,047.94 1,658,932.39

    -11,821,184.48 -11,574,116.27 -10,304,376.35 -9,156,146.49 -8,968,572.94 -8,980,690.42


    -1,951,946.25 -1,636,322.58 -2,000,349.19 -1,895,538.02 -3,974,999.59 -4,554,833.13
    -13,773,130.73 -13,210,438.85 -12,304,725.54 -11,051,684.51 -12,943,572.53 -13,535,523.55

    1,941,071.03 1,720,832.01 1,866,822.55 2,097,455.06 1,758,159.92 1,066,981.37


    1,885,377.48 1,718,994.45 1,868,150.64 2,095,318.62 1,759,008.47 1,081,074.09
    55,693.55 1,837.56 -1,328.09 2,136.44 -848.55 -14,092.72
    Noviembre Diciembre Total

    8,980,690.42 10,662,085.10 11,792,912.79


    4,554,833.13 6,695,293.40 2,634,392.14
    13,535,523.55 17,357,378.50 14,427,304.93

    5,940,284.23 2,229,356.39 21,896,302.96

    -10,662,085.10 -11,014,167.68 -11,014,167.68


    -6,695,293.40 -7,269,827.47 -7,269,827.47
    -17,357,378.50 -18,283,995.15 -18,283,995.15

    2,118,429.28 1,302,739.74 18,039,612.74


    2,113,603.40 1,294,296.45 17,995,274.79
    4,825.88 8,443.29 44,337.95
    Comercial Quispe S.A.C.

    Con los datos que se mencionan a continuación, determine usted el costo de ventas
    mensual y comparar mes a mes con el costo de ventas determinado por el sistema de
    información Oracle. De hallar diferencias, explicarlas

    Compras 60 20 28 Costo Ventas P&S


    12/31/2020 38,285,720.14 2,904,652.97
    Enero 6,559,631.71 36,460,016.79 1,587,583.18 9,702,404.86
    Febrero 6,408,094.46 34,280,630.01 2,054,724.39 8,120,340.02
    Marzo 7,505,026.75 33,259,159.58 2,612,493.81 7,968,727.76
    Abril 7,078,339.47 33,184,983.67 3,195,955.25 6,569,053.94
    Mayo 10,727,755.64 32,928,549.15 3,856,584.80 10,323,560.61
    Junio 14,355,201.10 34,357,420.85 5,400,951.58 11,381,962.62
    Julio 8,899,297.55 33,477,858.71 4,061,458.65 11,118,352.62
    Agosto 12,512,028.45 31,337,841.79 5,075,163.18 13,638,340.84
    Setiembre 18,409,499.00 31,711,419.11 8,592,409.35 14,518,675.51
    Octubre 11,150,294.54 31,919,328.63 5,509,883.47 14,024,910.90
    Noviembre 8,824,993.07 31,222,906.93 3,934,001.87 11,097,296.37
    Diciembre 7,919,088.19 30,552,404.22 3,977,472.74 8,546,120.03
    Total 120,349,249.93 127,009,746.08

    Enero Febrero Marzo Abril


    Saldo inicial
    20 38,285,720.14 36,460,016.79 34,280,630.01 33,259,159.58
    28 2,904,652.97 1,587,583.18 2,054,724.39 2,612,493.81
    41,190,373.11 38,047,599.96 36,335,354.40 35,871,653.39

    Compras 6,559,631.71 6,408,094.46 7,505,026.75 7,078,339.47


    Saldo final
    20 -36,460,016.79 -34,280,630.01 -33,259,159.58 -33,184,983.67
    28 -1,587,583.18 -2,054,724.39 -2,612,493.81 -3,195,955.25
    -38,047,599.96 -36,335,354.40 -35,871,653.39 -36,380,938.92

    Costo de ventas 9,702,404.86 8,120,340.02 7,968,727.76 6,569,053.94


    CV Oracle 9,702,404.86 8,120,340.02 7,968,727.76 6,569,053.94
    Diferencias 0.00 0.00 0.00 0.00
    Diferencias
    Mayo Junio Julio Agosto Setiembre Octubre

    33,184,983.67 32,928,549.15 34,357,420.85 33,477,858.71 31,337,841.79 31,711,419.11


    3,195,955.25 3,856,584.80 5,400,951.58 4,061,458.65 5,075,163.18 8,592,409.35
    36,380,938.92 36,785,133.95 39,758,372.43 37,539,317.36 36,413,004.97 40,303,828.46

    10,727,755.64 14,355,201.10 8,899,297.55 12,512,028.45 18,409,499.00 11,150,294.54

    -32,928,549.15 -34,357,420.85 -33,477,858.71 -31,337,841.79 -31,711,419.11 -31,919,328.63


    -3,856,584.80 -5,400,951.58 -4,061,458.65 -5,075,163.18 -8,592,409.35 -5,509,883.47
    -36,785,133.95 -39,758,372.43 -37,539,317.36 -36,413,004.97 -40,303,828.46 -37,429,212.10

    10,323,560.61 11,381,962.62 11,118,352.62 13,638,340.84 14,518,675.51 14,024,910.90


    10,323,560.61 11,381,962.62 11,118,352.62 13,638,340.84 14,518,675.51 14,024,910.90
    0.00 0.00 0.00 0.00 0.00 0.00
    Noviembre Diciembre Total

    31,919,328.63 31,222,906.93 38,285,720.14


    5,509,883.47 3,934,001.87 2,904,652.97
    37,429,212.10 35,156,908.80 41,190,373.11

    8,824,993.07 7,919,088.19 120,349,249.93

    -31,222,906.93 -30,552,404.22 -30,552,404.22


    -3,934,001.87 -3,977,472.74 -3,977,472.74
    -35,156,908.80 -34,529,876.96 -34,529,876.96

    11,097,296.37 8,546,120.03 127,009,746.08


    11,097,296.37 8,546,120.03 127,009,746.08
    0.00 0.00 0.00

    También podría gustarte