Actividad Excel

  • October 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Actividad Excel as PDF for free.

More details

  • Words: 222
  • Pages: 2
AS &

DAM

A R T I C U L O S

COMPRAS

OS

LER

AL CAB

CAMISA SPORT MEDIAS TENNIS BLUSAS PANTALON DAMA PANTALON HOMBRE VESTIDO NIÑA VESTIDO DAMA TOTALES PROMEDIO MAXIMOS MINIMOS CATEGORIAS DE ARTICULOS

CANTIDAD EXISTENTE 10 11 12 13 14 15 16 17 108 14 17 10 8

PRECIO TOTAL COMPRA COMPRA $ 42,000 $ 420,000 $ 4,500 $ 49,500 $ 60,000 $ 720,000 $ 45,000 $ 585,000 $ 75,000 $ 1,050,000 $ 65,000 $ 975,000 $ 30,000 $ 480,000 $ 80,000 $ 1,360,000 401500 5639500 50188 704938 80000 1360000 4500 49500 8 8

VENTAS CANTIDAD VENDIDA 7 4 5 2 3 3 9 8 41 5 9 2 8

PRECIO TOTAL SALDO VENTA VENTA ACTUAL $ 67,200 $ 470,400 3 $ 7,200 $ 28,800 7 $ 96,000 $ 480,000 7 $ 72,000 $ 144,000 11 $ 120,000 $ 360,000 11 $ 104,000 $ 312,000 12 $ 48,000 $ 432,000 7 $ 128,000 $ 1,024,000 9 642400 3251200 67 80300 406400 8 128000 1024000 12 7200 28800 3 8 8 8

UTILIDADES UTILIDAD UNITARIA $ 25,200 $ 2,700 $ 36,000 $ 27,000 $ 45,000 $ 39,000 $ 18,000 $ 48,000 240900 30113 48000 2700 8

TOTAL UTILIDADES $ 176,400 $ 10,800 $ 180,000 $ 54,000 $ 135,000 $ 117,000 $ 162,000 $ 384,000 1219200 152400 384000 10800 8

Related Documents