View
224
Download
0
Category
Tags:
Preview:
DESCRIPTION
todo computo basico
Citation preview
DATOS 01CUADRO 01CUADRO 02ALUMNONOTA 1NOTA 2NOTA 3PUNTAJE03:00:00 AM11:45:003:25:00 PM16:50:0022:05:00Alumno - 0115131745Alumno - 02121410360.152.25%1200.00%20%0.200%Alum - 03108112925/562/95/170.9/0.25
CUADRO 03230.5445.00 $1,250.00
CUADRO 04fechaFECHAFe C h AfechaFECHAFe C h A06/09/201107/09/11Thursday, September 08, 201109-09-112011-09-1040797.0CUADRO 05
NALIMENTOSCOMPOSICINCALORASVITAMINASFECHA DE PRUEBA
mcg x 100CALHCH2OB1B21Huevo entero1551 1/574.03%138.00340.0019-09-112Clara de huevo1002/387.87%25.00250.0020-09-113Yema de huevo3523 1/252.09%350.00420.0021-09-114Huevo escalfado1543/574.72%80.00250.0022-09-115Huevo frito2201 1/864.30%60.00270.0023-09-11
Hoja2
CUADRO 06CUADRO 07AlejandroCarolinaGuillermoEstefanaTOTALESDESCRIPCINENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOTOTALESLibros3502503151501065INGRESOS$15,550.50$16,589.00$12,456.00$10,990.00$7,650.99$4,806.50$3,450.50$11,358.00$82,851.49Cuadernos75452520165EGRESOS$3,456.80$16,790.00$17,024.99$8,633.00$3,456.78$2,450.50$5,750.00$8,157.50$65,719.57Bolgrafos101215845UTILIDAD$12,093.70-$201.00-$4,568.99$2,357.00$4,194.21$2,356.00-$2,299.50$3,200.50$17,131.92TOTALES4353073551781275MES DE MAYOR UTILIDAD Y MONTOENERO$12,093.70MES DE MENOR UTILIDAD Y MONTOJUNIO$2,356.00MES DE MAYOR PERDIDA Y MONTOMARZO-$4,568.99TOTAL DE SLO UTILIDADES$24,201.41TOTAL DE SOLO PERDIDAS-$7,069.49TOTAL DE INGRESOS$82,851.49TOTAL DE EGRESOS$65,719.57TOTAL DE UTILIDADES$17,131.92
Hoja3VENDEDORVENTASCOMISINSUELDO TOTAL
Lulu Bejar950017102460Roco Castro560010081758Ada Gonzales52009361686Luz Llajarana659011861936Elena Serrano48908801630TOTAL9470
Sueldo Bsico750Tasa Comisin18%
Hoja4
CDIGOARTCULOPRECIO UNIDADUNIDADES VENDIDASPRECIO TOTALA-001TV LCD 32 SAMSUNG149934497A-002TV LED 40SAMSUNG199947996A-003TV LCD 32" LG159957995A-004TV LED 42" LG2599615594A-005TV LED 50" SONY4999734993A-006TV PLASMA 32" AOC99987992
TOTAL3379067
Hoja5LIBRERA " I.E.S.T.P. TRUJILLO"R.U.C
20354595029NOMBRES:FECHA:
CODCANTIDADDESCRIPCINPRECIO UNITARIOPRECIO SUBTOTAL
17Millares de papel Bond A4 de 80 mg28.00196.00213Cuadernos de 200 hoja A4 color35.00455.00324Lapiceros Azul Pilot B10 tinta lquida6.50156.0048Plumn acrlico Pilot color negro4.8038.40520Libros Santillana MATEMATIC 5 ao95.001,900.00SUBTOTAL2,745.40I.G.V494.17FACTURA N1TOTAL3,239.57
Hoja6CUADRO 11
LISTA DE PRECIOSARTEFACTOPRECIO COSTO( DLAR)PRECIO COSTO (SOLES)GANANCIAIGVPRECIO VENTA
TV LED 32" SONY$500.0013752062851866TV LED 42" SONY$750.0020623094272799TV LED 50" SONY$950.0026123925413545TV 3D 32" SONY$650.0017882683702426TV 3D 42" SONY$950.0026123925413545TV 3D 50" SONY$1,550.0042626398825784
DLAR3GANANCIA15%IGV18%
Hoja7
REGISTRO DE NOTAS - OFIMTICA
N ORDENALUMNONOTASPUNTAJEPROMEDIO
TRABAJOPRCTICAEVALUACINN%LETRAS1ABANTO RODRGUEZ, CSAR JEAN141853712.333333333362%DOCE2ARANA AGUILAR, JUAN CARLOS138103110.333333333352%DIEZ3ARQUEROS CASTILLO, LUZ ANGLICA1816154916.333333333382%DIECISEIS4AVALOS FLORES, YULIANA201612481680%DIECISEIS5AZABACHE CHINCHAYAN, YESSICA1298299.666666666748%DIEZ6CASTAEDA PELAEZ, AZUCENA1456258.333333333342%OCHO7CASTILLO QUIONEZ, LEYDI205103511.666666666758%DOCE8CORREA RODRGUEZ, LOIDA12165331155%ONCE9CRESPN VELZQUEZ, ALEX MARTN1712144314.333333333372%CATORCE10CRUZ ZRATE, DANY VANESA6186301050%DIEZ11CHAVEZ SILVA, CAROL MARA121512391365%TRECE12DIAZ DEZA, PERLA AZUCENA141615451575%QUINCE13FIGUEROA MARCHENA, ELIZABETH1617144715.666666666778%DIECISEIS14GRAUS MINZN, JORGE LUIS1010153511.666666666758%DOCE15LEN ORTIZ, DIANA1161027945%NUEVEPROMEDIO13.933333333312.466666666710.466666666736.866666666712.2888888889
Hoja8
INVENTARIO
FECHAARTCULOCANTIDADPRECIO X UNIDADVALOR MONETARIO
STOCKVENTASALDOSTOCKVENTASALDO (S/.)SALDO ($)DLAR3.120/09/2011Producto-001103730021009002100$677.4221/09/2011Producto-002251510350350052503500$1,129.0322/09/2011Producto-003301218150270018002700$870.9723/09/2011Producto-004401030220660022006600$2,129.0324/09/2011Producto-005501337160592020805920$1,909.6825/09/2011Producto-0062021810018002001800$580.6526/09/2011Producto-00714861358101080810$261.2927/09/2011Producto-008106480320480320$103.23TOTAL19969130-----------------2375013990237507661.2903225806
Hoja9
Calcula para cada coche el descuento correspondiente segn el importe
PRODUCTOIMPORTEDTO. MINDTO. MEDDTO. MAXIMP. LUJO
IBIZA5,980.07 59.80 598.01 657.81 1,076.41 FIESTA6,911.64 69.12 691.16 760.28 1,244.10 GOLF8,714.68 87.15 871.47 958.61 1,568.64 MONDEO9,523.00 95.23 952.30 1,047.53 1,714.14 TOTAL311.29 3,112.94 3,424.23 5,603.29 PORCENTAJES1%10%11%18%
Hoja10
CONCEPTOCANTIDAD10%TOTAL15%TOTAL20%TOTALSUMA FINALVAJILLAS901.52 90.15 991.67 135.23 1,036.75 180.30 1,081.82 3,110.24 LMPARAS1,382.33 138.23 1,520.56 207.35 1,589.68 276.47 1,658.80 4,769.04 CONSERVAS1,262.13 126.21 1,388.34 189.32 1,451.45 252.43 1,514.56 4,354.35 VINOS102.17 10.22 112.39 15.33 117.50 20.43 122.60 352.49 ACEITE1,322.23 132.22 1,454.45 198.33 1,520.56 264.45 1,586.68 4,561.69 DETERGENTES3,245.47 324.55 3,570.02 486.82 3,732.29 649.09 3,894.56 11,196.87
SUMAS8,215.85 821.59 9,037.44 1,232.38 9,448.23 1,643.17 9,859.02 28,344.68
PROMEDIOS1,369.31 136.93 1,506.24 205.40 1,574.70 273.86 1,643.17 4,724.11
Hoja11
CDIGO VENDEDORPRODUCTOUNIDADES VENDIDASVENTAS TOTALES ($)VENTAS TOTALES(S/.)COMISINREMUNERACIN FINALREMUNERACIN FINAL ($)
V-01Laptop Core i55$4,000.001040052010920FALSEV-02Laptop Core i510$8,000.0020800104021840$8,400.00V-03Laptop Core i58$6,400.001664083217472$6,720.00V-04Laptop Core i57$5,600.001456072815288$5,880.00V-05Laptop Core i56$4,800.001248062413104$5,040.00V-06Laptop Core i59$7,200.001872093619656$7,560.00V-07Laptop Core i512$9,600.0024960124826208$10,080.00V-08Laptop Core i514$11,200.0029120145630576$11,760.00TOTAL71568001476807384155064$55,440.00
PRECIO UNITARIO$800.00TASA DE COMISIN5%SUELDO BASE550TIPO DE CAMBIO3
Hoja12
FARMACIA "ANDERSON"
REPORTE DE VENTAS DIARIASFECHA
CDIGOARTCULOPRESENTACINPRECIOCANTIDADIMPORTEV2VICK VAPORUPFRASCO8542T5TALCO AMENFRASCO12450M3MERTHIOLATEFRASCO7321H6HORODOIDPOMADA22245C4CLERASILCREMA10766A1APIRINAPASTILLA (10)2914M2MOCODILATFJARABE196112SUBTOTAL351IGV63TOTAL414
Recommended