• Author / Uploaded
• YOLKATANIA

Citation preview

PROBLEMA Nº 01 : "DONOFRIO" Elaborar el registro de venta de la empresa D’Onofrio teniendo en consideración los sgtes. Datos: Descripción de los campos utilizados en su libro de venta Fecha: Día, mes, año en que se realizo la venta Datos del cliente: Nombre, N° de RUC Cantidad: Cantidad vendida del producto en mención Interés, descuentos: Se utiliza según la condición de venta: Contado, Crédito Valor de venta: Valor con el que se venderá nuestra mercadería IGV: Impuesto General a las ventas Precio de venta: Suma del valor de ventas mas IGV Formas de pago: Puede ser contado, crédito o contado y crédito Tipo de operación: C: Contado CR: Crédito *CL: Contado y Crédito Se acepta CL cuando el cliente paga 50% al contado y el otro 50% al crédito Formulas: Precio Mercadería: Cantidad*Precio Unitario DESCUENTOS: Si el interés de operación es al contado (C) se le otorga un 5% de descuento INTERES Si el tipo de operación es al crédito (CR) se le aplica un 10% de interés Si el tipo de operación es al contado y crédito (CL) se le aplica un 5% de interés Si el tipo de operación es al contado (C) se le cero % MONTO Es igual a precio de mercadería*porcentaje de interés VALOR DE VENTA Es igual a precio de mercadería + monto de interés - monto de descuento IGV Es igual a valor de venta por 19% PRECIO DE VENTA Valor de venta + IGV FORMAS DE PAGO a) Al contado: Si el tipo de operación es al contado (C), entonces que muestre su precio de venta.

b) Al crédito Si el tipo de operación es al crédito (CR), entonces que muestre su precio de venta, si el tipo de operación es al contado y a crédito (CL), entonces que muestre el 50% del precio de venta, de lo contrario 0 OBSERVACION Si el monto de la venta es mayor a 1000, entonces buena venta de lo contrario muy bien

DONOFRIO - REGISTRO D

CODIGO

XD1

PRODUCTO

PANETON DONOFRIO 1 KG

PRECIO

S/.

15.00 CONDICIONES

FECHA DE VENTA

RUC CLIENTE

CLIENTE

N° RECIBO

CANT

PRECIO MERCADERIA

INTERES %

MONTO

01/01/2008 BETA

24585178

95001

20

S/.

300.00

0.1 S/.

30.00

02/01/2008 SIGMA

24585179

95002

50

S/.

750.00

0.05 S/.

37.50

03/01/2008 NORKYS

24585180

95003

100

S/.

1,500.00

0.1 S/.

150.00

04/01/2008 TELEFONICA

24585181

95004

5000

S/.

75,000.00

0.00 S/.

05/01/2008 LUZ DEL SUR

24585182

95005

2000

S/.

30,000.00

06/01/2008 TIP TOP

24585183

95006

50

S/.

750.00

0.00 S/.

-

07/01/2008 LUZ DEL NORTE

24585184

95007

50

S/.

750.00

0.00 S/.

-

08/01/2008 TOPY TOP

24585185

95008

100

S/.

1,500.00

0.1 S/.

150.00

09/01/2008 MUNIC. LIMA

24585186

95009

500

S/.

7,500.00

0.1 S/.

750.00

10/01/2008 MUNIC. CALLAO

24585187

95010

500

S/.

7,500.00

0.00 S/.

-

11/01/2008 BANCO WIESSE

24585188

95011

1000

S/.

15,000.00

0.00 S/.

-

12/01/2008 SOUTHERN PERU

24585189

95012

1500

S/.

22,500.00

0.05 S/. 1,125.00

13/01/2008 ORION

24585190

95013

20

S/.

300.00

0.00 S/.

-

14/01/2008 BANCO LATINO

24585191

95014

300

S/.

4,500.00

0.00 S/.

-

15/01/2008 CESAR VALLEJO

24585192

95015

20

S/.

300.00

0.00 S/.

-

16/01/2008 NISSAN

24585193

95016

100

S/.

1,500.00

0.1 S/.

17/01/2008 ORTIZ DE ZEVALLOS

24585194

95017

30

S/.

450.00

0.00 S/.

-

18/01/2008 TOYOTA

24585195

95018

40

S/.

600.00

0.00 S/.

-

19/01/2008 IBM

24585196

95019

100

S/.

1,500.00

0.1 S/.

150.00

20/01/2008 DISKIT

24585197

95020

50

S/.

750.00

0.1 S/.

75.00

21/01/2008 PERU MERCANTIL

24585198

95021

25

S/.

375.00

0.1 S/.

37.50

22/01/2008 PERU SOFT

24585199

95022

50

S/.

750.00

0.1 S/.

75.00

23/01/2008 MICROCHIP

24585200

95023

25

S/.

375.00

0.05 S/.

18.75

24/01/2008 COSTA VERDE

24585201

95024

50

S/.

750.00

0.05 S/.

37.50

25/01/2008 OMEGA

24585202

95025

50

S/.

750.00

0.05 S/.

37.50

26/01/2008 CARSA

24585203

95026

100

S/.

1,500.00

0.00 S/.

TIPO DE OPERACION C CR CL IGV

DCTO

INTERES

CONTADO

5%

0%

CREDITO

0%

10%

0%

5%

CONTADO Y CREDITO

18%

-

0.1 S/. 3,000.00

150.00

-

"

po de operación es al contado y al

ONOFRIO - REGISTRO DE VENTA

CONDICIONES

FORMA DE PAGO VALOR VENTA

DESCUENTOS %

IGV

PRECIO VENTA

TIPO DE OPERACIÓN

MONTO

CONTADO

CREDITO FACTURA

CANT LETRAS

0.00 S/.

-

S/.

330.00 S/.

59.40 S/.

389.40

CR

0.00

389.40

3

0.00 S/.

-

S/.

787.50 S/.

141.75 S/.

929.25

CL

0.00

464.63

2

0.00 S/.

-

S/. 1,650.00 S/.

297.00 S/. 1,947.00

CR

0.00

1947.00

3

84075.00

0.00

0

0.00

38940.00

3

0.05 S/. 0.00 S/.

3,750.00 S/. 71,250.00 S/. 12,825.00 S/. 84,075.00 -

S/. 33,000.00 S/. 5,940.00 S/. 38,940.00

C CR

0.05 S/.

37.50 S/.

712.50 S/.

128.25 S/.

840.75

C

840.75

0.00

0

0.05 S/.

37.50 S/.

712.50 S/.

128.25 S/.

840.75

C

840.75

0.00

0

0.00 S/.

-

S/. 1,650.00 S/.

297.00 S/. 1,947.00

CR

0.00

1947.00

3

0.00 S/.

-

S/. 8,250.00 S/. 1,485.00 S/. 9,735.00

CR

0.00

9735.00

3

0.05 S/.

375.00 S/. 7,125.00 S/. 1,282.50 S/. 8,407.50

C

8407.50

0.00

0

0.05 S/.

750.00 S/. 14,250.00 S/. 2,565.00 S/. 16,815.00

C

16815.00

0.00

0

0.00 S/. 0.05 S/. 0.05 S/. 0.05 S/. 0.00 S/.

-

S/. 23,625.00 S/. 4,252.50 S/. 27,877.50

15.00 S/.

285.00 S/.

225.00 S/. 4,275.00 S/. 15.00 S/. -

285.00 S/.

S/. 1,650.00 S/.

CL

0.00

13938.75

2

336.30

C

336.30

0.00

0

769.50 S/. 5,044.50

C

5044.50

0.00

0

C

336.30

0.00

0

51.30 S/. 51.30 S/.

336.30

0.00

1947.00

3

0.05 S/.

22.50 S/.

427.50 S/.

297.00 S/. 1,947.00 76.95 S/.

504.45

CR C

504.45

0.00

0

0.05 S/.

30.00 S/.

570.00 S/.

102.60 S/.

672.60

C

672.60

0.00

0

0.00 S/.

-

S/. 1,650.00 S/.

297.00 S/. 1,947.00

CR

0.00

1947.00

2

0.00 S/.

-

S/.

825.00 S/.

148.50 S/.

973.50

CR

0.00

973.50

2

0.00 S/.

-

S/.

412.50 S/.

74.25 S/.

486.75

CR

0.00

486.75

2

0.00 S/.

-

S/.

825.00 S/.

148.50 S/.

973.50

CR

0.00

973.50

4

0.00 S/.

-

S/.

393.75 S/.

70.88 S/.

464.63

CL

0.00

232.31

5

0.00 S/.

-

S/.

787.50 S/.

141.75 S/.

929.25

CL

0.00

464.63

6

0.00 S/.

-

S/.

787.50 S/.

141.75 S/.

929.25

CL

0.00

464.63

2

256.50 S/. 1,681.50

C

1681.50

0.00

0

0.05 S/.

75.00 S/. 1,425.00 S/.

OBSV.

muy bien muy bien buena venta buena venta buena venta muy bien muy bien buena venta buena venta buena venta buena venta buena venta muy bien buena venta muy bien buena venta muy bien muy bien buena venta muy bien muy bien muy bien muy bien muy bien muy bien buena venta

PROBLEMA N° 02: CORPORACION EL CHAVO

Haciendo uso de referencias absolutas, relativas y mixtas asi como vinculacion de hojas, elabore el siguiente reporte de ventas tomando en consideración los datos de la pte. Hoja.

REPORTE DE VENTAS DEL AÑO 2016 N°

CODIGO

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34

K1001 K1002 K1003 K1004 K1005 K1006 K1007 K1008 K1009 K1010 K1011 K1012 K1013 K1014 K1015 K1016 K1017 K1018 K1019 K1020 L1001 L1002 L1003 L1004 L2001 L2002 L2003 L2004 L2005 L2006 A001 A002 A003 A004

MARCA

Inca Kola Inca Kola Inca Kola Inca Kola Inca Kola Inca Kola Inca Kola Inca Kola Inca Kola Inca Kola Inca Kola Inca Kola Inca Kola Inca Kola Diet Inca Kola Diet Inca Kola Diet Inca Kola Diet Inca Kola Diet Inca Kola Diet Inca Kola Diet Ref. Bimbo Ref. Bimbo Ref. Bimbo Ref. Bimbo Bimbo Break Bimbo Break Bimbo Break Bimbo Break Bimbo Break Bimbo Break Seltz Seltz Seltz Seltz TOTAL

TIPO

NR RE NR NR NR NR RE NR NR NR RE RE NR NR NR NR RE NR NR NR NR NR RE NR RE NR NR RE RE NR NR NR RE NR

TRIM1

TRIM2

TRIM3

TRIM4

TOTAL ANUAL $3,500.00 $11,900.00 $3,500.00 $11,800.00 $3,500.00 $11,700.00 $3,500.00 $11,600.00 $3,500.00 $11,500.00

$3,300.00 $3,000.00 $2,100.00 $3,300.00 $2,900.00 $2,100.00 $3,300.00 $2,800.00 $2,100.00 $3,300.00 $2,700.00 $2,100.00 $3,300.00 $2,600.00 $2,100.00 $3,300.00 $2,500.00 $2,100.00 $3,500.00 $11,400.00 $3,300.00 $2,400.00 $2,100.00 $3,500.00 $11,300.00 $3,300.00 $2,300.00 $2,100.00 $3,500.00 $11,200.00 $3,300.00 $2,200.00 $2,100.00 $3,500.00 $11,100.00 $3,300.00 $2,100.00 $2,100.00 $3,500.00 $11,000.00 $3,300.00 $2,000.00 $2,100.00 $3,500.00 $10,900.00 $3,300.00 $1,900.00 $2,100.00 $3,500.00 $10,800.00 $3,300.00 $1,800.00 $2,100.00 $3,500.00 $10,700.00 $2,600.00 $1,500.00 $1,750.00 $2,650.00 $8,500.00 $2,600.00 $1,500.00 $1,700.00 $2,650.00 $8,450.00 $2,600.00 $1,500.00 $1,650.00 $2,650.00 $8,400.00 $2,600.00 $1,500.00 $1,600.00 $2,650.00 $8,350.00 $2,600.00 $1,500.00 $1,550.00 $2,650.00 $8,300.00 $2,600.00 $1,500.00 $1,500.00 $2,650.00 $8,250.00 $2,600.00 $1,500.00 $1,450.00 $2,650.00 $8,200.00 $2,400.00 $1,400.00 $1,400.00 $2,500.00 $7,700.00 $2,400.00 $1,420.00 $1,350.00 $2,500.00 $7,670.00 $2,400.00 $1,440.00 $1,300.00 $2,500.00 $7,640.00 $2,400.00 $1,460.00 $1,250.00 $2,500.00 $7,610.00 $2,400.00 $1,480.00 $2,000.00 $2,500.00 $8,380.00 $2,400.00 $1,500.00 $2,000.00 $2,500.00 $8,400.00 $2,400.00 $1,520.00 $2,000.00 $2,500.00 $8,420.00 $2,400.00 $1,540.00 $2,000.00 $2,500.00 $8,440.00 $2,400.00 $1,560.00 $2,000.00 $2,500.00 $8,460.00 $2,400.00 $1,580.00 $2,000.00 $2,500.00 $8,480.00 $2,550.00 $1,600.00 $2,000.00 $2,500.00 $8,650.00 $2,550.00 $1,620.00 $2,000.00 $2,500.00 $8,670.00 $2,550.00 $1,640.00 $2,000.00 $2,500.00 $8,690.00 $2,550.00 $1,660.00 $2,000.00 $2,500.00 $8,710.00 $95,300.00 $31,200.00 $63,800.00 $99,050.00 $321,270.00

siguiente reporte de

%

3.70 3.67 3.64 3.61 3.58 3.55 3.52 3.49 3.46 3.42 3.39 3.36 3.33 2.65 2.63 2.61 2.60 2.58 2.57 2.55 2.40 2.39 2.38 2.37 2.61 2.61 2.62 2.63 2.63 2.64 2.69 2.70 2.70 2.71 100

RESUMEN ESTADISTICO DE VENTAS VENTAS POR MARCA (EN DOLARES) TIPO INKA KOLA INCA KOLA DIET REF. BIMBO BIMBO BREAK SELTZ TOTAL

TRIM1 $42,900.00

TRIM2

TRIM3

$18,200.00

$31,200.00 $10,500.00

$27,300.00 $11,200.00

$9,600.00

$5,720.00

$5,300.00

$14,400.00 $10,200.00 $95,300.00

$9,180.00 $6,520.00 $63,120.00

$12,000.00 $8,000.00 $63,800.00

TRIM4

TOTAL $45,500.00 $146,900.00 $18,550.00 $58,450.00 $10,000.00 $30,620.00 $15,000.00 $50,580.00 $10,000.00 $34,720.00 $99,050.00 $321,270.00

VENTAS POR MARCA (EN VALORES PORCENTUALES) TIPO INKA KOLA INCA KOLA DIET REF. BIMBO BIMBO BREAK SELTZ TOTAL

TIPO

TRIM1 13.35 5.67 2.99 4.48 3.17 29.66

TRIM2

TRIM3

9.71 3.27 1.78 2.86 2.03 19.65

8.50 3.49 1.65 3.74 2.49 19.86

VENTAS POR MARCA (EN NUEVO SOLES) TRIM1 TRIM2 TRIM3

TRIM4 14.16 5.77 3.11 4.67 3.11 30.83

TRIM4

INKA KOLA S/. 139,425.00 S/. 101,400.00 S/. 88,725.00 S/. 147,875.00 INCA KOLA DIET S/. 59,150.00 S/. 34,125.00 S/. 36,400.00 S/. 60,287.50 REF. BIMBO S/. 31,200.00 S/. 18,590.00 S/. 17,225.00 S/. 32,500.00 BIMBO BREAK S/. 46,800.00 S/. 29,835.00 S/. 39,000.00 S/. 48,750.00 SELTZ S/. 33,150.00 S/. 21,190.00 S/. 26,000.00 S/. 32,500.00 TOTAL S/. 309,725.00 S/. 205,140.00 S/. 207,350.00 S/. 321,912.50 3.25 TIPO DE CAMBIO S/.

VENTAS POR TIPO DE ENVASE TIPO RE NR TOTAL

TRIM1 27950

TRIM2 18360

TRIM3 19300

TRIM4 29150

67350 95300

44760 63120

44500 63800

69900 99050

TOTAL 45.72 18.19 9.53 15.74 10.81 100.00