Cuadro de VentasCod Descrip Ao Color Origen Cant Precio Total

X001 Auto 1995 Rojo Alemania 120 18000 S/. 2,160,000.00 X002 Auto 1990 Azul Chile 60 18000 S/. 1,080,000.00 X003 Motocicleta 1980 Verde Japn 80 3500 S/. 280,000.00 X004 Auto 1995 Rojo Alemania 40 18000 S/. 720,000.00 X005 Deportivo 1998 Azul Japn 100 35000 S/. 3,500,000.00 X006 Camioneta 1990 Azul Alemania 150 38000 S/. 5,700,000.00 X007 Motocicleta 2000 Verde Japn 140 3500 S/. 490,000.00 X008 Motocicleta 1999 Rojo Chile 160 3500 S/. 560,000.00 X009 Deportivo 2001 Azul Japn 90 35000 S/. 3,150,000.00 X010 Auto 2002 Rojo Alemania 85 18000 S/. 1,530,000.00 X011 Camioneta 1999 Azul Japn 100 38000 S/. 3,800,000.00 X012 Motocicleta 2001 Verde Alemania 95 3500 S/. 332,500.00 X013 Deportivo 2002 Rojo Japn 85 35000 S/. 2,975,000.00 X014 Camioneta 1995 Azul Chile 120 38000 S/. 4,560,000.00 X015 Auto 1997 Azul Japn 150 18000 S/. 2,700,000.00 X016 Auto 1998 Verde Alemania 125 18000 S/. 2,250,000.00 X017 Deportivo 1997 Rojo Japn 130 35000 S/. 4,550,000.00 X018 Auto 2000 Azul Alemania 120 18000 S/. 2,160,000.00

Llenar el Cuadro de Ventas, respetando el formato original del cuadro.

Cuadro de VentasFlete Desc Venta Productos

216,000.00 324,000.00 S/. 1,620,000.00 Descrip Precio Flete 108,000.00 108,000.00 S/. 864,000.00 Auto 18000 10% 42,000.00 33,600.00 S/. 204,400.00 Camioneta 38000 20% 72,000.00 108,000.00 S/. 540,000.00 Deportivo 35000 5% 175,000.00 420,000.00 S/. 2,905,000.00 Motocicleta 3500 15% 1,140,000.00 855,000.00 S/. 3,705,000.00 73,500.00 58,800.00 S/. 357,700.00 84,000.00 56,000.00 S/. 420,000.00 Paises 157,500.00 378,000.00 S/. 2,614,500.00 Origen Desct 153,000.00 229,500.00 S/. 1,147,500.00 Alemania 15% 760,000.00 456,000.00 S/. 2,584,000.00 Japn 12% 49,875.00 49,875.00 S/. 232,750.00 Chile 10% 148,750.00 357,000.00 S/. 2,469,250.00 912,000.00 456,000.00 S/. 3,192,000.00 270,000.00 324,000.00 S/. 2,106,000.00 225,000.00 337,500.00 S/. 1,687,500.00 227,500.00 546,000.00 S/. 3,776,500.00 216,000.00 324,000.00 S/. 1,620,000.00

Agencia de Viajes 'Pichicata Tours S.A.C.'Cambio ($):

Datos del Vuelo

Vuelo: V001

Aereolnea: Lan Per

Origen: Brasil

Destino: Per

Pasajeros: 150

Ingresos (S/.): 26,460.00

Duracin: 7:30

En las celdas amarillas, ingresar las frmulas necesarias paraobtener los datos correspondientes al cdigo del Vuelo (azul).

Si cdigo de Vuelo est vaco, las celdas amarillas no debenmostrar nada.

Vuelo V001 V002 V003 V004 V0052.52 Aereolnea Lan Per Faucett Faucett Tans Lan Per

Origen Brasil Per Brasil Chile VenezuelaDestino Per Venezuela Chile Ecuador Brasil

Pasajeros 150 200 175 120 135Ingresos($) 10500 12000 11500 10300 9500Duracin 7:30 5:00 8:45 9:30 7:00

V006 V007 V008 V009 V010 V011 V012 V013Tans Faucett Tans Lan Per Lan Per Faucett Lan Per TansEcuador Venezuela Ecuador Per Brasil Chile Venezuela EcuadorPer Brasil Chile Venezuela Ecuador Venezuela Per Per

230 175 150 145 220 180 120 15014000 13500 12500 11700 15000 14550 15550 18000

6:30 8:20 5:45 9:40 8:20 6:50 9:35 9:50

V014 V015 V016 V017 V018 V019 V020Lan Per Tans Faucett Tans Lan Per Faucett Lan PerVenezuela Ecuador Chile Venezuela Ecuador Venezuela EcuadorBrasil Chile Venezuela Ecuador Brasil Ecuador Chile

170 150 200 180 250 250 23516000 7000 7500 9800 10000 12500 21200

8:20 7:00 8:00 9:00 9:20 8:40 7:35

V021 V022 V023 V024 V025 V026 V027Tans Faucett Tans Lan Per Faucett Lan Per TansEcuador Chile Venezuela Ecuador Venezuela Venezuela EcuadorChile Venezuela Ecuador Brasil Ecuador Chile Chile

150 200 180 105 250 250 2507000 7500 9800 10000 12500 21200 7000

7:00 8:00 9:00 9:20 8:40 7:35 7:00

V028 V029 V030 V031 V032 V033 V034Faucett Tans Lan Per Faucett Lan Per Tans FaucettChile Venezuela Ecuador Venezuela Ecuador Venezuela ChileVenezuela Ecuador Brasil Ecuador Chile Chile Venezuela

250 180 105 125 130 150 2507500 9800 10000 12500 21200 7000 7500

8:00 9:00 9:20 8:40 7:35 7:00 8:00

V035 V036 V037 V038Tans Lan Per Faucett Lan PerVenezuela Ecuador Venezuela VenezuelaEcuador Brasil Ecuador Chile

280 280 240 1309800 10000 12500 21200

9:00 9:20 8:40 7:35

Preg1Preg2