contabilidad animals care
DESCRIPTION
Excel sin macros de la empresa Animals CareTRANSCRIPT
![Page 1: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/1.jpg)
INVENTARIOINVENTARIO
RESUMENRESUMEN
![Page 2: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/2.jpg)
NÓMINANÓMINA
![Page 3: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/3.jpg)
ESTADÍSTICAESTADÍSTICA
FACTURAFACTURA
![Page 4: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/4.jpg)
000000 4
Por ti, por ellos, por el mundo.INVENTARIO
Código PRODUCTO
RC1 West Highland White Terrier Adult
RC2 German Sheperd Adult
RC3 Pug Adult
RC4 Indoor Adult 27
RC5 Urinary S/O Feline
NU1 Matisse Feline
NU2 Weigth control
OB1 Organic Guinea Pig
OB2 Hamsters and Gerbil Food
OB3 Chinchilla food
WA1 Goldfish Flakes
Tabla Unidades
Presentación Unidades
Animals Care
![Page 5: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/5.jpg)
000000 5
Bulto Kg
Paquete g
Tabla UnidadesPresentación Unidades
FRASCO ml
BOLSA g
CAJA Unidad
GRANEL Kg
![Page 6: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/6.jpg)
000000 6
![Page 7: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/7.jpg)
000000 7
![Page 8: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/8.jpg)
000000 8
Por ti, por ellos, por el mundo.INVENTARIO
Animal ESTANTES
Perro A
Perro A
Perro A
Gato B
Gato B
Gato B
Perro A
Guinea pig C
Hamster y Jerbo D
Chinchilla E
Pez Dorado F
Tabla de EstantesTipo
Animals Care
![Page 9: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/9.jpg)
000000 9
Perro
Gato
Guinea pig
Hamster y Jerbo
Chinchilla
Peces
Tabla de EstantesTipo
RC
UN Estante
OB A
B
![Page 10: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/10.jpg)
000000 10
C
![Page 11: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/11.jpg)
000000 11
![Page 12: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/12.jpg)
000000 12
Por ti, por ellos, por el mundo.INVENTARIO
EXISTENTE VENDIDOS PRECIO IVA
4 2 $ 1,869.00 $ 299.04
2 5 $ 1,869.00 $ 299.04
12 7 $ 654.00 $ 104.64
7 2 $ 560.00 $ 89.60
5 7 $ 679.00 $ 108.64
4 1 $ 670.00 $ 107.20
3 0 $ 1,975.00 $ 316.00
4 2 $ 232.00 $ 37.12
8 6 $ 143.00 $ 22.88
7 3 $ 235.00 $ 37.60
3 2 $ 260.00 $ 41.60
Ganancia total
Tabla de EstantesEstante
Animals Care
![Page 13: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/13.jpg)
000000 13
A
B
C
D
E
F
![Page 14: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/14.jpg)
000000 14
![Page 15: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/15.jpg)
000000 15
![Page 16: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/16.jpg)
000000 16
INVENTARIO
IMPORTE Total PRESENTACION
$ 2,168.04 $ 4,336.08 Bulto
$ 2,168.04 $ 10,840.20 Bulto
$ 758.64 $ 5,310.48 Bulto
$ 649.60 $ 1,299.20 Bulto
$ 787.64 $ 5,513.48 Bulto
$ 777.20 $ 777.20 Bulto
$ 2,291.00 $ - Paquete
$ 269.12 $ 538.24 Paquete
$ 165.88 $ 995.28 Paquete
$ 272.60 $ 817.80 Paquete
$ 301.60 $ 603.20 Paquete
Ganancia total $ 31,031.16
MENU
![Page 17: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/17.jpg)
000000 17
![Page 18: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/18.jpg)
000000 18
![Page 19: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/19.jpg)
000000 19
![Page 20: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/20.jpg)
000000 20
Unidades
Kg
Kg
Kg
Kg
Kg
Kg
g
g
g
g
g
![Page 21: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/21.jpg)
000000 21
![Page 22: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/22.jpg)
000000 22
![Page 23: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/23.jpg)
000000 23
![Page 24: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/24.jpg)
000000 24
![Page 25: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/25.jpg)
000000 25
![Page 26: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/26.jpg)
000000 26
PRECIOS
![Page 27: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/27.jpg)
000000 27
PRECIOS
![Page 28: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/28.jpg)
000000 28
![Page 29: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/29.jpg)
000000 29
![Page 30: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/30.jpg)
000000 30
PRECIOS
![Page 31: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/31.jpg)
000000 31
PRECIOS
![Page 32: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/32.jpg)
000000 32
![Page 33: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/33.jpg)
000000 33
![Page 34: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/34.jpg)
000000 34
West Highland White Terrier Adult
German Sheperd Adult
Pug Adult
Indoor Adult 27
Urinary S/O Feline
Matisse Feline
Weigth control
Organic Guinea Pig
Hamsters and Gerbil Food
Chinchilla food
Goldfish Flakes
Unidades
Kg g0
7.5
15
EXISTENCIAPRECIOS
![Page 35: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/35.jpg)
000000 35
West Highland White Terrier Adult
German Sheperd Adult
Pug Adult
Indoor Adult 27
Urinary S/O Feline
Matisse Feline
Weigth control
Organic Guinea Pig
Hamsters and Gerbil Food
Chinchilla food
Goldfish Flakes
Unidades
Kg g0
7.5
15
EXISTENCIAPRECIOS
![Page 36: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/36.jpg)
000000 36
![Page 37: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/37.jpg)
000000 37
![Page 38: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/38.jpg)
000000 38
West Highland White Terrier Adult
German Sheperd Adult
Pug Adult
Indoor Adult 27
Urinary S/O Feline
Matisse Feline
Weigth control
Organic Guinea Pig
Hamsters and Gerbil Food
Chinchilla food
Goldfish Flakes
Unidades
Kg g0
7.5
15
EXISTENCIA
![Page 39: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/39.jpg)
000000 39
West Highland White Terrier Adult
German Sheperd Adult
Pug Adult
Indoor Adult 27
Urinary S/O Feline
Matisse Feline
Weigth control
Organic Guinea Pig
Hamsters and Gerbil Food
Chinchilla food
Goldfish Flakes
Unidades
Kg g0
7.5
15
EXISTENCIA
![Page 40: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/40.jpg)
000000 40
![Page 41: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/41.jpg)
000000 41
![Page 42: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/42.jpg)
000000 42
West Highland White Terrier Adult
German Sheperd Adult
Pug Adult
Indoor Adult 27
Urinary S/O Feline
Matisse Feline
Weigth control
Organic Guinea Pig
Hamsters and Gerbil Food
Chinchilla food
Goldfish Flakes
Unidades
Kg g0
7.5
15
EXISTENCIA
![Page 43: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/43.jpg)
000000 43
West Highland White Terrier Adult
German Sheperd Adult
Pug Adult
Indoor Adult 27
Urinary S/O Feline
Matisse Feline
Weigth control
Organic Guinea Pig
Hamsters and Gerbil Food
Chinchilla food
Goldfish Flakes
Unidades
Kg g0
7.5
15
EXISTENCIA
![Page 44: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/44.jpg)
000000 44
Nombre del empleado
1 Yamertzin Romero González2 Clara del Carmen Lavín Esteban3 Carla de Lara Valerdi4 Victor Manuel Vázquez Juárez5 Carlos María Echeagaray Rodríguez6 Pablo Montes Ruiz7 José Sánchez Perez8 Luis Ángel Méndez González9 Juan Martínez Reyes
10 Ruben González Robles11 Karen Gutiérrez Morales12 Isacc Jiménez López13 Brenda Lozano Vivar14 Camila Silva Molina15 Olliver Campos Tapia
Clave del Empleado
![Page 45: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/45.jpg)
000000 45
PERIODO DE PAGO: Del:Al:
Puesto Horas extras Subtotal
Director 31 0 $ 5,580.00
Director 31 0 $ 5,580.00
Director 31 0 $ 5,580.00
Gerente 28 2 $ 5,110.00
Gerente 28 5 $ 5,215.00
Obrero 30 0 $ 4,200.00
Obrero 25 0 $ 3,500.00 Obrero 24 0 $ 3,360.00 Obrero 30 3 $ 4,305.00 Obrero 12 2 $ 1,750.00 Obrero 28 5 $ 4,095.00 Obrero 28 6 $ 4,130.00 Obrero 31 7 $ 4,585.00 Obrero 31 5 $ 4,515.00 Obrero 28 3 $ 4,025.00
Dias trabajadados
Animals Care
![Page 46: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/46.jpg)
000000 46
1 de Abril
2 de Mayo
2.5% 5.0%
Seguro Social Infonavit Sueldo neto
$ 139.50 $ 279.00 $ 5,161.50 Si $ 139.50 $ 279.00 $ 5,161.50 Si $ 139.50 $ 279.00 $ 5,161.50 Si $ 127.75 $ 255.50 $ 4,726.75 Si $ 130.38 $ 260.75 $ 4,823.88 Si $ 105.00 $ 210.00 $ 3,885.00 No $ 87.50 $ 175.00 $ 3,237.50 No $ 84.00 $ 168.00 $ 3,108.00 No $ 107.63 $ 215.25 $ 3,982.13 No $ 43.75 $ 87.50 $ 1,618.75 No $ 102.38 $ 204.75 $ 3,787.88 No $ 103.25 $ 206.50 $ 3,820.25 No $ 114.63 $ 229.25 $ 4,241.13 No $ 112.88 $ 225.75 $ 4,176.38 No $ 100.63 $ 201.25 $ 3,723.13 No
MENU
Seguro Gastos Médicos
Animals Care
![Page 47: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/47.jpg)
000000 47
Sueldo Base por día directivos $ 180.00 Sueldo base por día obreros: $ 140.00
Horas trabajadas 8Pago por hora extra: $ 35.00
![Page 48: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/48.jpg)
000000 48
Sueldo por hora $ 17.50
![Page 49: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/49.jpg)
000000 49
FACTURADÍA
5
NO
CLIENTE Marcos Parroquín y Medina
DIRECCION 9 Norte No. 465 fracc Bella Vista
CUIDAD PUEBLA PUEBLA
Código Cantidad Producto
RC1 3 West Highland White Terrier Adult
OB1 5 Organic Guinea Pig
NU1 1 Matisse Feline
RC3 2 Pug Adult
OB3 6 Chinchilla food
![Page 50: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/50.jpg)
000000 50
MES AÑO
4 2016
1
Marcos Parroquín y Medina
9 Norte No. 465 fracc Bella Vista
PUEBLA PUEBLA
PRECIO IMPORTE
$ 4,336.08 $ 13,008.24
$ 538.24 $ 2,691.20
$ 777.20 $ 777.20
$ 5,310.48 $ 10,620.96
$ 817.80 $ 4,906.80
SUBTOTAL $ 32,004.40
IVA $ 5,120.70
TOTAL $ 37,125.10
MENU
Facturación
![Page 51: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/51.jpg)
000000 51
Facturación
![Page 52: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/52.jpg)
FACTURA
SUBTOTAL IVA TOTAL $ 32,004.40 $ 5,120.70 $ 37,125.10 $ 32,004.40 $ 5,120.70 $ 37,125.10
MENU
![Page 53: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/53.jpg)
![Page 54: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/54.jpg)
Estadísticas
Número de obreros 15Máximo de Días trabajados: 31Mínimo de Días Trabajados: 12Máximo de Horas Extras: 7Pago Mínimo al Seguro Social: $ 43.75 Máximo Sueldo Neto: $ 5,161.50 Promedio de Horas Extras: 2.53 Promedio de Días Trabajados: 27.73
5Total del Seguro Social: $ 1,638.25 Total INFONAVIT: $ 3,276.50 Total de Horas Extras: 38Precio máximo $ 1,975.00 Precio mínimo $ 143.00
MENU
Empleados con Seguro de Gastos Médicos
![Page 55: Contabilidad Animals Care](https://reader031.vdocuments.us/reader031/viewer/2022020517/577c7e661a28abe054a0fc82/html5/thumbnails/55.jpg)