ݺߣ

ݺߣShare a Scribd company logo

Practica 5 excel

•Download as XLSX, PDF•
•
K
Karla Nallely Ortiz

The document calculates commissions for salespeople in November. It shows each salesperson's name, sales amount, commission percentage rate which is a base of 3.5% plus an additional amount, their commission in pesos, any supplemental pay, and total commissions. It also provides totals at the bottom for overall sales, additional percentages paid, and supplemental pay for the month.

1 of 1
Download to read offline
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

More Related Content

Practica 5 excel

  • 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