solucion inventarios (1)
TRANSCRIPT
FECHA CONCEPTO Q VU VT Q VU VT Q
2 COMPRA 2200 43,000$ 94,600,000$ 2200
4 VENTA 1600 55,900$ 89,440,000$ 600
6 VENTA 500 55,900$ 27,950,000$ 100
8 COMPRA 2500 45,100$ 112,750,000$ 2500
10 VENTA 2400 58,500$ 140,400,000$ 100
16 COMPRA 3000 48,500$ 145,500,000$ 3000
20 VENTA 1000 63,050$ 63,050,000$ 2000
22 VENTA 1200 63,050$ 75,660,000$ 800
26 COMPRA 1000 50,000$ 50,000,000$ 1000
30 VENTA 950 63,050$ 59,897,500$ 50
FECHA CONCEPTO Q VU VT Q VU VT Q
2 COMPRA 2200 43,000$ 94,600,000$ 2200
4 VENTA 1600 55,900$ 89,440,000$ 600
6 VENTA 500 55,900$ 27,950,000$ 100
8 COMPRA 2500 45,100$ 112,750,000$ 2500
10 VENTA 100 55,900$ 5,590,000$
2300 58,630$ 134,849,000$ 200
16 COMPRA 3000 48,500$ 145,500,000$ 3000
20 VENTA 200 58,630$ 11,726,000$
800 63,050$ 50,440,000$ 2200
22 VENTA 1200 63,050$ 75,660,000$ 1000
26 COMPRA 1000 50,000$ 50,000,000$ 1000
30 VENTA 950 63,050$ 59897500 50
PROM PONDERADO
UEPS
PEPS
ENTRADAS SALIDAS SALDO
ENTRADAS SALIDAS SALDO
VU VT
43,000$ 94,600,000$
55,900$ 33,540,000$
55,900$ 5,590,000$
45,100$ 112,750,000$
58,500$ 5,850,000$
48,500$ 145,500,000$
63,050$ 126,100,000$
63,050$ 50,440,000$
50,000$ 50,000,000$
63,050$ 3,152,500$
VU VT
43,000$ 94,600,000$
55,900$ 33,540,000$
55,900$ 5,590,000$
45,100$ 112,750,000$
58,630$ 11,726,000$
48,500$ 145,500,000$
63,050$ 138,710,000$
63,050$ 63,050,000$
50,000$ 50,000,000$
63,050$ 3,152,500$
SALDO
SALDO
FECHA CONCEPTO Q VU VT Q VU VT
3 COMPRA 150 35,960$ 5,394,000$
5 VENTA 128 46,875$ 6,000,000$
7 COMPRA 180 37,004$ 6,660,720$
9 VENTA 20 48,500$ 970,000$
11 COMPRA 200 37,700$ 7,540,000$
15 VENTA 200 49,286$ 9,857,142$
80 49,286$ 3,942,880$
17 COMPRA 200 37,468$ 7,493,600$
19 VENTA 150 38,000$ 5,700,000$
27,088,320$ 26470022
26,470,022$
1,900,000$
28,370,022$
27,088,320$
UTILIDAD BRUTA 1,281,702$
PEPS
FECHA CONCEPTO Q VU VT Q VU VT
3 COMPRA 150 35,960$ 5,394,000$
5 VENTA 128 46,875$ 6,000,000$
7 COMPRA 180 37,004$ 6,660,720$
9 VENTA 20 48,500$ 970,000$
11 COMPRA 200 37,700$ 7,540,000$
15 VENTA 2 49,286$ 98,572$
180 49,286$ 8,871,480$
98 49,286$ 4,830,028$
17 COMPRA 200 37,468$ 7,493,600$
19 VENTA 102 38,000$ 3,876,000$
+ 48 38,000$ 1,824,000$
UEPS
ENTRADAS SALIDAS
ENTRADAS SALIDAS
27,088,320$ 26470080
26,470,080$
5,695,136$
32,165,216$
27,088,320$
5,076,896$
promedio ponderado
FECHA CONCEPTO Q VU VT Q VU VT
3 COMPRA 150 35,960$ 5,394,000$
5 VENTA 128 46,875$ 6,000,000$
7 COMPRA 180 37,004$ 6,660,720$
9 VENTA 20 48,500$ 970,000$
11 COMPRA 200 37,700$ 7,540,000$
15 VENTA 280 49,286$ 13,800,080$
17 COMPRA 200 37,468$ 7,493,600$
19 VENTA 150 38,000$ 5,700,000$
27,088,320$ 26470080
27,088,320$
5,666,484$
32,754,804$
26,470,080$
UTILIDAD BRUTA 6,284,724$
ENTRADAS SALIDAS
Q VU VT
150 35,960.0$ 5,394,000$
22 35,960.0$ 791,120$
180 37,004.0$ 6,660,720$
160 37,004.0$ 5,920,640$
200 327.826$ 65,565.200$
80 37,004$ 2,960,320$
200 37,468$ 7,493,600$
50 38,000$ 1,900,000$
Q VU VT
150 35,960.0$ 5,394,000$
22 35,960.0$ 791,120$
180 37,004.0$ 6,660,720$
2 35,960.0$ 71,920$
200 37,700$ 7,540,000$ 280
102 37,700$ 3,845,400$ 1.16%
200 37,468$ 7,493,600$
35,960.00$
152 37,468$ 5,695,136$ 5753.6
SALDO
SALDO
4800
30,206.40$
4833.024
35,039.42$
31000
4,960.00$
35,960.00$
4650000
744000
Q VU VT
150 35,960$ 5,394,000$
22 35,960$ 791,120$
202 36,482$ 7,369,364$
182 36,482$ 6,639,724$
382 37,091$ 14,168,762$
102 37,091$ 3,783,282$
302 37,280$ 11,258,409$
152 37,280$ 5,666,484$
SALDO
FECHA DETALLE CD UNIDADES VALOR +IVA
3
Compra Fra.
0587 a
crédito
6 150 $5´394.000.
5
Venta Fra.
02345 a
crédito
9 -128 6´000.000.
7
Compra Fra.
0657 a
crédito
12 180 6´660.720.
9
Venta Fra.
02350 a
crédito
17 -20 970.000.
11
Compra Fra.
0770 a
crédito
23 200 7´540.000.
15
Venta Fra.
02359 a
crédito
29 -280 13´800.000.
17
Compra Fra.
0788 a
crédito
30 200 7´493.600.
19
Venta Fra.
02366 a
crédito
32 -150 5´700.000.