Septiembre

download Septiembre

of 25

description

se utiliza para el control de inventario de una gasolinera, para registrar los litros vendidos y restantes por mes.

Transcript of Septiembre

VERIFICARESUMEN GENERAL DE VENTAS DEL MES DE SEPTIEMBRE 2015 COMBUSTIBLES LIQUIDOSPRECIOMAGSEP.CONSDEVOL.INV. INICIAL21,529INVENTARIODIFER.IngresoPRECIOPRESEP.CONSDEV.INV. INICIAL1,676INVENTARIODIFER.IngresoPRECIODIESELSEP.CONSDEVOLINV. INICIAL1,665INVENTARDIFER.INGRESOIngresoventaIngresoDIFDIAentradasINT.TANQlitros vendidosveed/finalinv. TeoricoINVENTAR.magnaDIAENTRADASINTERTANQlitros vendidosinveederootTEORICOINVENTAR.premiumDIAentradasINTERTANQlitros vendidosinveederootTEORICOinventariosDIESELCombust.ACEITESFALTANTESOBRANTEno comb.TOTAL INGRESOSDEPOSITOSCREDITOtotal13.5712,91618,33218,613-28139,570.1214.381001676-16760.0014.2011665-16650.0039,570.12117.000.120.00117.0039,687.0038,487.001,200.000.0113.5722,49615,83015,836-633,870.7214.382000.0014.202000.0033,870.7265.0014.720.0065.0033,921.0031,221.002,700.000.0213.5733,05812,79812,7722641,497.0614.383000.0014.203000.0041,497.0652.004.060.0052.0041,545.0037,700.003,845.000.0313.5743,0339,7269,765-3941,157.8114.384000.0014.204000.0041,157.8198.000.003.1998.0041,259.0041,059.00200.000.0413.5754,5995,0755,127-5262,408.4314.385000.0014.205000.0062,408.43103.0049.430.00103.0062,462.0055,862.006,600.000.0513.5763,3251,8971,75014745,120.2514.386000.0014.206000.0045,120.2594.000.0017.7594.0045,232.0045,232.000.000.0613.5770.001,8971,89700.0014.387000.0014.207000.000.000.000.000.000.000.000.000.000.0713.5782000050921,52921,3881416,907.1314.388000.0014.208000.006,907.1370.0013.130.0070.006,964.006,964.000.000.0813.5792,45018,96719,079-11233,246.5014.389000.0014.209000.0033,246.50195.00189.330.00195.0033,252.1729,272.003,980.170.0913.57102,37716,65716,5906732,255.8914.3810000.0014.2010000.0032,255.8929.0089.890.0029.0032,195.0032,195.000.000.01013.57113,14613,59413,5118342,691.2214.3811000.0014.2011000.0042,691.2229.0076.220.0029.0042,644.0042,644.000.000.01113.57122,84610,47510,748-27338,620.2214.3812000.0014.2012000.0038,620.22188.0074.220.00188.0038,734.0035,584.003,150.000.01213.57132,6127,9137,8635035,444.8414.3813000.0014.2013000.0035,444.8464.00210.840.0064.0035,298.0035,298.000.00$0.001313.57142,3035,5505,610-6031,251.7114.3814000.0014.2014000.0031,251.710.000.008.790.0031,260.5025,860.505,400.000.01413.57152,9382,7652,61215339,868.6614.3815000.0014.2015000.0039,868.6665.0052.590.0065.0039,881.0737,723.002,158.07$0.001513.5716200002,70020,45720,06539236,639.0014.3816000.0014.2016000.0036,639.0032.000.070.0032.0036,670.9336,185.50485.430.01613.57172,67317,70117,784-8336,272.6114.3817000.0014.2017000.0036,272.6158.000.003.3958.0036,334.0033,334.003,000.000.01713.57181,98815,41815,713-29526,977.1614.3818000.0014.2018000.0026,977.1633.0043.160.0033.0026,967.0026,967.000.000.01813.57193,85411,62411,5646052,298.7814.3819000.0014.2019000.0052,298.7832.0024.1326.4032.0052,333.0546,728.005,605.050.01913.57202,8788,8088,7466239,054.4614.3820000.0014.2020000.0039,054.460.0012.5027.540.0039,069.5039,069.500.000.02013.57212,9736,0375,83520240,343.6114.3821000.0014.2021000.0040,343.61182.00130.1743.56182.0040,439.0036,794.003,645.000.02113.57222,2843,8593,75310630,993.8814.3822000.0014.2022000.0030,993.88135.0031.9511.07135.0031,108.0029,188.001,920.000.02213.5723200002,30721,95921,55240731,305.9914.3823000.0014.2023000.0031,305.9984.0056.850.0084.0031,333.1429,890.001,443.14$0.002313.57242,32919,60419,630-2631,604.5314.3824000.0014.2024000.0031,604.5394.0097.128.1694.0031,609.5728,962.002,647.570.02413.57252,09517,49217,509-1728,429.1514.3825000.0014.2025000.0028,429.1561.0085.620.4761.0028,405.0028,405.000.00$0.002513.57263,50413,39413,988-59447,549.2814.3826000.0014.2026000.0047,549.2832.00162.6525.6832.0047,444.3142,484.004,960.310.02613.57273,17010,47510,22425143,016.9014.3827000.0014.2027000.0043,016.9033.00130.1510.2533.0042,930.0041,230.001,700.000.02713.57283,0097,5627,4669640,832.1314.3828000.0014.2028000.0040,832.1398.0098.5613.4398.0040,845.0032,245.008,600.000.02813.57292,7254,9194,8378236,978.2514.3829000.0014.2029000.0036,978.25186.0045.591.34186.0037,120.0035,020.002,100.000.02913.57302,7422,2572,1778037,208.9414.3830000.0014.2030000.0037,208.9465.0059.336.0365.0037,220.6434,697.002,523.640.03013.57310.02,2572,25700.0014.3831000.0014.2031000.000.000.000.000.000.000.000.03160,000.000.000.0079,839.00346,828.00-17,582.00567.001,083,415.23TOTALES000001676-16760TOTALES0.000.01,665.00(1,665.00)0.01,083,415.232,294.001,733.50207.052,294.001,084,163.881,016,300.5067,863.380.00PROM. X DIA2,661.30PROMEDIO GENERAL GASOLINA2,661.30PROM. X DIA0.0PROM. X DIA0.0VENTA TOTAL DE LITROS79,839.003,326.63RESUMEN GENERAL DE VENTAS DEL MES DE OCTUBRE 2015 COMBUSTIBLES LIQUIDOSPRECIOMAGSEP.CONSDEVOL.INV. INICIAL2,257INVENTARIODIFER.IngresoPRECIOPRESEP.CONSDEV.INV. INICIAL1,512INVENTARIODIFER.IngresoPRECIODIESELSEP.CONSDEVOLINV. INICIAL0.0INVENTARDIFER.INGRESOIngresoventaIngresoDIFDIAentradasINT.TANQlitros vendidosveed/finalinv. TeoricoINVENTAR.magnaDIAENTRADASINTERTANQlitros vendidosinveederootTEORICOINVENTAR.premiumDIAentradasINTERTANQlitros vendidosinveederootTEORICOinventariosDIESELCombust.ACEITESFALTANTESOBRANTEno comb.TOTAL INGRESOSDEPOSITOSCREDITOtotal13.5713201,8971,937-404,342.4014.38101512151200.0014.20100000.004,342.4065.000.400.0065.004,407.004,207.00200.000.0113.5720.01,8971,89700.0014.38201512151200.0014.20200000.000.000.000.000.000.000.000.000.000.0213.573100013,1548,8088,7446442,799.7814.3831000131151311510343.1414.20300000.0042,842.92128.00211.1817.37128.0042,777.1138,434.004,343.110.0313.5742,2256,5356,583-4830,193.2514.38401125611513-2570.0014.20400000.0030,193.2565.0028.249.9965.0030,240.0030,190.0050.000.0413.5753,9062,6352,629653,004.4214.38521125611254228.7614.20500000.0053,033.1833.000.0025.2033.0053,091.3846,930.506,160.880.0513.5768071,8971,8286910,950.9914.3861086102971017012715,616.6814.20600000.0026,567.6771.0034.7124.0971.0026,628.0519,997.006,625.97$5.08613.5770.001,8971,89700.0014.3871927842383705327,710.2614.20700000.0027,710.26195.0095.160.00195.0027,810.1025,188.002,622.100.0713.5782000044221,52921,455745,997.9414.388143669226987-6520,649.6814.20800000.0026,647.620.0023.573.150.0026,627.2025,817.13810.07$0.00813.57921,529-215290.0014.3896922-69220.0014.20900000.000.000.000.000.0913.57100.000.0014.3810000.0014.201000000.000.000.000.000.01013.57110.000.0014.3811000.0014.201100000.000.000.000.000.01113.57120.000.0014.3812000.0014.201200000.000.000.000.000.01213.57130.000.0014.3813000.0014.201300000.000.000.000.000.01313.57140.000.0014.3814000.0014.201400000.000.000.000.000.01413.57150.000.0014.3815000.0014.201500000.000.000.000.000.01513.57160.000.0014.3816000.0014.201600000.000.000.000.000.01613.57170.000.0014.3817000.0014.201700000.000.000.000.000.01713.57180.000.0014.3818000.0014.201800000.000.000.000.000.01813.57190.000.0014.3819000.0014.201900000.000.000.000.000.01913.57200.000.0014.3820000.0014.202000000.000.000.000.000.02013.57210.000.0014.3821000.0014.202100000.000.000.000.000.02113.57220.000.0014.3822000.0014.202200000.000.000.000.000.02213.57230.000.0014.3823000.0014.202300000.000.000.000.000.02313.57240.000.0014.3824000.0014.202400000.000.000.000.000.02413.57250.000.0014.3825000.0014.202500000.000.000.000.000.02513.57260.000.0014.3826000.0014.202600000.000.000.000.000.02613.57270.000.0014.3827000.0014.202700000.000.000.000.000.02713.57280.000.0014.3828000.0014.202800000.000.000.000.000.02813.57290.000.0014.3829000.0014.202900000.000.000.000.000.02913.57300.000.0014.3830000.0014.203000000.000.000.000.000.03013.57310.000.0014.3831000.0014.203100000.000.000.000.000.03130,001.000.000.0010,854.0047,095.0019,147.00-21,404.00147,288.78TOTALES100010044546269169750-705964,048.52TOTALES0.000.00.00.00.0211,337.30557.00181.6862.43557.00211,580.84190,763.6320,812.135.08PROM. X DIA361.80PROMEDIO GENERAL GASOLINA510.27PROM. X DIA148.47PROM. X DIA0.0VENTA TOTAL DE LITROS15,308.00637.83

VENTA ACEITESCOMBISTILES LIQUIDOSRESUMEN DE VENTAS DE LUBRICANTES Y TARJETASAug-15VENTASINV.INVPROMEDIOVENTA EN $CODIGOSDESCRIPCION12345678910111213141516171819202122232425262728293031TOTALINICIALFINALX CAJABARDAHL11051SAE 20W60 API CAM00.00000.00NANOX LIMP INYEC21111170.2917336.0020010TOP OIL11215913211271.12501,296.0012052NANOX OCTANAGE00.00000.00MEXLUB DIESEL SAE 4021311123212190.7917874.0012072BARDHAL 110.00000.0013211BARDHAL200.00000.00BITAL00.00000.0013113BARDHAL OCTANO BOOSTER00.00000.0013811MOTOS 2 TIEMPOS3140.1667120.0025041ATF PIPETA00.00000.0014300DIRECCION HIDRAULICA111112112212112200.8333360.0014211LIMPIA PARABRISAS00.00000.0015011LIQUIDO P/BATERIAS00.00000.0017221ANTICONGELANTE COOLANT00.00000.00LIQUIDO P/FRENO LF311222124111180.75001,098.00RACING OIL SAE 403250.2083305.00RACING OIL 20W502113180.3333400.00TOP OIL LIMPIEZA PROFUNDA00.00000.00ADITIVO P/ DIESEL00.00000.00ADITIVO TRANS AUTOMATICA00.00000.00BARDHAL RADIADOR00.00000.00INFLALLANTE1120.083368.00ARRANCADOR1120.083390.00BARDHAL W-5000.00000.00CERA LIQUIDA00.00000.00SOLUCION TOTAL00.00000.00BRILLANTA00.00000.00QUITA MANCHAS00.00000.00TOP IOL PREMIUM110.041735.00LIQUIDO FRENOS DOT400.00000.00SUPER RACIN OIL ALTO KILM00.00000.00ANTICONGELANTE CUNCENTRADO00.00000.00SINTETICO SL SAE00.00000.00MEXLUB SAE 406455331294466351044930.00005,952.00MEXLUB ATF DEXRON431113124311250.00001,600.0000DEPOSITO 1 GAL0DEPOSITO 2 GAL0BARDAHL LIMPIADOR DE INYECTORE00.00000.00BARDAHL TOP OIL GASOLINA00.00000.00QUALITAS 8 DIA00.00000.00TOTALES DIARIOS170092100111001602223139140010171515811000000231004.708333333312534PRODUCTOAKRONACEITE PARA MOTOR AKRON00.00000.00SUPER TRATAMIENTO00.00000.00TOTALES DIARIOS0000000000000000000000000000002310.0000TELCEL 50000.00000.00BATERA PARA CARRO00.00000.00PINOS AROMATIZANTES5141110.0000330.00RECIPENTE DE GASOLINA I GALON00.00000.00RECIPIENTES DE GASOLINA 2 GALON00.00000.00BATERIA LTH L-35-57500.00000.00BATERIA LTH L-24-53000.00000.00BATERIA LTH L-58-57500.00000.00BATERIA LTH L-42-40000.00000.00BATERIAS ATLAS A75/8600.00000.00BATERIAS ATLAS A-22F00.00000.00RECARGA TELCEL 2064534624445344582.416738,280.00RECARGA TELCEL 3022424112112525341.416729,920.00RECARGA TELCEL 501213324122210.8750630.00RECARGA TELCEL 100123RECARGA TELCEL 2001TOTALES DIARIOS80070001150401047700149160711000000127004.708381,694.00COMBUSTIBLES LIQUIDOSRESUMEN DE COMPRAS DE LUBRICANTES Y TARJETASENTRADAS NOVIEMBRE 2013TOTALCODIGOSDESCRIPCION12345678910111213141516171819202122232425262728293031COMPRASBARDAHL11051SAE 20W60 API CAM0NANOX LIMP INYEC020010NANOX TOP IOL012052NANOX OCTANAGE012062MEXLUB DIESEL SAE 40012072BARDHAL 1013211BARDHAL20BITAL013113BARDHAL OCTANO BOOSTER013811MOTOS 2 TIEMPOS025041ATF PIPETA014300DIRECCION HIDRAULICA014211LIMPIA PARABRISAS015011LIQUIDO P/BATERIAS017221ANTICONGELANTE COOLANT017398LIQUIDO P/FRENO0RACING OIL SAE 400RACING OIL 20W500DIESEL OIL CF2S0ADITIVICO P/ DIESEL0ADITIVO TRANS AUTOMATICA0BARDHAL RADIADOR0INFLALLANTE0ARRANCADOR0BARDHAL W-500CERA LIQUIDA0SOLUCION TOTAL0BRILLANTA0QUITA MANCHAS0TOP IOL PREMIUM0LIQUIDO FRENOS DOT40SUPER RACIN OIL ALTO KILM0ANTICONGELANTE INTELIGENTE0SINTETICO SL SAE0MEXLUB SAE 400MEXLUB ATF DEXRON00DEPOSITO 1 GAL0DEPOSITO 2 GAL0BARDAHL LIMPIADOR DE INYECTORE0BARDAHL TOP OIL GASOLINA0QUALITAS 8 DIA0TOTALES DIARIOS00000000000000000000000000000000PRODUCTOAKRONACEITE PARA MOTOR AKRON0SUPER TRATAMIENTO0TOTALES DIARIOS0000000000000000000000000000000TELCEL 5000BATERA PARA CARRO0PINOS AROMATIZANTES0RECIPENTE DE GASOLINA I GALON0RECIPIENTES DE GASOLINA 2 GALON0BATERIA LTH L-42-4000BATERIA LTH L-24-4200BATERIA LTH L-34/78-7500BATERIA LTH L-65-8000BATERIAS ATLAS A75/860BATERIAS ATLAS A-22F0BATERIAS ATLAS A2420BOLETO ECOWASH SUPREMO0BOLETO ECOWASH EXPRESS00TOTALES DIARIOS0000000000000000000000000000000

CLIENTES DE VTA ANTICIPADACOMBUSTIBLES LIQUIDOSECO-PO-OP-OO3-FO1CARGOS AGOSTO 2015TOTALSALDOCLIENTESSaldo inicial1-Jul2-Jul3-Jul4-Jul5-Jul6-Jul7-Jul8-Jul9-Jul10-Jul11-Jul12-Jul13-Jul14-Jul15-Jul16-Jul17-Jul18-Jul19-Jul20-Jul21-Jul22-Jul23-Jul24-Jul25-Jul26-Jul27-Jul28-Jul29-Jul30-Jul31-JulCOMSUMOCARTERAAccor0.000.000.00Servibono0.000.000.00Efectivale0.000.000.00P.mexicanas0.000.000.00TOTAL EXTERNOTOTAL0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00$0.00$0.00VENTA ANTICIPADA.RUBEN RAFAELCERVANTES0.000.00JORGE ECHEVERRIA CALDERON0.000.00VALE EDENRED INSURGENTES0.000.00DECOPRA0.000.00FEARI CONSTRUCTORA0.000.00FERRETERIA FENIX (RAFAEL)0.000.00Moreno Freig Pedro0.000.00Armando Antonio Moreno Mtz0.000.00Jose E. Pujol Manriquez0.000.00Grupo PUMAN de Nogales0.000.00JUAN A NAVARRO LOPEZ0.000.00LUIS EDUARDO FELIX RAMIREZ0.000.00SERDI S A DE C V0.00SVR PLASTICS S DE RL0.000.00MADERAS CAMINO CANANEA0.000.00PROYDES0.000.00TOTAL INTERNOS$0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00Eco Comercializadora$0.00$0.00$0.00SALDO ENERCARDEnergeticos En Red Electronica$5,702,929.749,330.898,797.825,163.192,012.3516,379.3610,390.268,213.965,713.325,165.5831,269.235,134.607,863.5710,434.6911,722.855,459.25$143,050.92$5,845,980.66SALDO ENER$5,845,980.66TOTAL$5,702,929.74$143,050.92$5,845,980.66PAGOSTOTALABONOS NOV 20141-Jul2-Jul3-Jul4-Jul5-Jul6-Jul7-Jul8-Jul9-Jul10-Jul11-Jul12-Jul13-Jul14-Jul15-Jul16-Jul17-Jul18-Jul19-Jul20-Jul21-Jul22-Jul23-Jul24-Jul25-Jul26-Jul27-Jul28-Jul29-Jul30-Jul31-JulABONOSDECOPRA0.000.00MADERAS CAMINO A CANANEA0.000.00SVR PLASTICS S DE RL0.000.00Moreno Freig Pedro0.000.00ARMANDO ANTONIO MORENO0.000.00TOTAL EXTERNOS0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00$0.000.00VENTA ANTICIPADA1.002.003.0045678910111213141516171819202122232425262728293031TOTALGLOBAL INTEGRAL0.000.00JORGE ECHEVERRIA CALDERON0.000.00VALE EDENRED INSURGENTES0.000.00DECOPRA0.000.00FEARI CONSTRUCTORA0.000.00FERRETERIA FENIX (RAFAEL)0.000.00Moreno Freig Pedro0.000.00Armando Antonio Moreno Mtz0.000.00Jose E. Pujol Manriquez0.000.00Grupo PUMAN de Nogales0.000.00JUAN A NAVARRO LOPEZ0.000.00JAVIER ALONSO GARCIA DU0.000.00LUIS EDUARDO FELIX RAMIREZ0.000.00SVR PLASTICS S DE RL0.000.00PROYDES0.000.00TOTAL INTERNOS$0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00Eco Comercializadora0.00$0.00Energeticos En Red Electronica0.00$0.00

INV-FIN-MESRESUMEN DE INVENTARIO FINAL DE LA ESTACIONESTADO DOCUMENTACIONPRODUCTOSCVEBODEGAISL1ISL2ISL3ISL4TotalApr-14SUPER TRATAMIENTO0Bardahl 1300010Bardahl 2300020Bardhal Bital Mr.473 ml.300030VALORDELALUNIDADESMONTOTop Oil Limpiador para todo tipo de gasolina3000401002030111,100.00Top Oil Octane Booster 0-100300050Top Oil Limpiador de Inyectores300060Bardahl Direccion Hidraulica300110Bardahl ATF300100Bardahl Aditivo Para Diesel300190Bardahl Aditivo Transmision300200Bardahl Limpiaparabrisas300120MagnaPremiumDIESELBardahl Liquido para Bateria3001306,73316,70322,100Bardahl Anticongelante Coolant300140Bardahl Liquido para Frenos LF-3300150Bardahl Racing Oil SF/CC SAE 40300160CreditosReembolsosAnticiposBardahl Racing Oil SF/CC SAE 20W50300170Bardahl Racing Oil alto km0Bardahl Diesel Oil CF-2 SAE 40300180ConsumosConsumosExistenciasBerdahl Radiador300260Bardahal Motos 2T 250 ml0Bardahal Nautico 2T 950 ml0Bardahl Arrancador300280Bardahl WB-50300290Bardahal Bital0Bardhal Cera Liquida 250m300320Bardhal Solucion Total 60300330Bardhal Brillanta 600ml300340Bardhal Quita Mancha 600300350Bardhal Top Oil. Premium 4300370Mexlub Aceite Motor400020CobrosCobrosVentasMexlub Aceite ATF400030ConsumosTarjeta telcel de 5000Recipiente para Gasolina 1 Gls.0TotalesTotalesTotalesRecipiente para Gasolina 2 Gls.800040Pilas para carro0Paqute expres800190Paqute supremo800180PINOS AROMATIZANTES0Inflallanta0David QuezadaRICARDO PEAECO-PO-OP-002-F02JEFE ESTACIONGERENTE DE ZONA

Se obtuvo cartera y consumos de reporte SAC. Se requieren comprobantes de consumos para corte de mes.Comparar con acumulado hasta el dia 31 de Julio de 2004