1
CALCULO DE COMISIONES MES NOVIEMBRE COMISION BASE 3.5% VENDEDOR VENTA PORCENTJE COMISION SUPLEM. SUMA ADICIONAL PESOS PESOS COMISIONES OSCAR 120,000,000 0.5% 60,000 120,060,005 EDUARDO 5,696,000,000 0.5% 569,000 5,696,569,005 TERESA 6,064,000,000 1.0% 3,032,000 6,067,032,010 BEATRIZ 8,960,000,000 2.0% 4,320,000 8,964,320,020 VICTORIA 8,640,000,000 2.05 8,640,000,020 TOTALES 29,480,000,000 6.00% 7,981,000

Practica 5 excel

Embed Size (px)

Citation preview

Page 1: Practica 5 excel

CALCULO DE COMISIONES

MES NOVIEMBRE

COMISION BASE 3.5%

VENDEDOR VENTA PORCENTJE COMISION SUPLEM. SUMA

ADICIONAL PESOS PESOS COMISIONES

OSCAR 120,000,000 0.5% 60,000 120,060,005

EDUARDO 5,696,000,000 0.5% 569,000 5,696,569,005

TERESA 6,064,000,000 1.0% 3,032,000 6,067,032,010

BEATRIZ 8,960,000,000 2.0% 4,320,000 8,964,320,020

VICTORIA 8,640,000,000 2.05 8,640,000,020

TOTALES 29,480,000,000 6.00% 7,981,000