Tablas. Descripción general Introducción a las tablas Creación de tablas Uso de tablas.
Tablas
3
CIA Posicionamiento mercado empresas medianas D E Nivel A B C Banda Mediana Q2 Mp Minimo Maximo 10 1 Ger General 600,000 549,000 549,000 439,200$ 658,800$ 9 2 Gerente Finanzas 350,000 305,000 305,000 244,000$ 366,000$ 8 Gerente comercia 300,000 248,000 286,707 229,366$ 344,049$ 7 2.5 Gerente RRHH 200,000 261,000 261,000 208,800$ 313,200$ 6 3 Sub Grt Finanzas 180,000 163,540 163,540 130,832$ 196,248$ 5 3.5 Sub Grt RRHH 150,000 112,000 112,000 89,600$ 134,400$ Sub Grt Operacio 160,000 112,000 112,000 89,600$ 134,400$ 4 4 Jefe Especialist 100,000 93,285 93,285 74,628$ 111,942$ 3 5 Jefe nómina 80,000 85,000 85,000 68,000$ 102,000$ 2 6 Analista 30,000 46,000 46,000 36,800$ 55,200$ 10 549,000 9 305,000 8 286,707 7 261,000 6 163,540 5 112,000 4 93,285 3 85,000 2 46,000 30352 286707.466 Salario actual anual y = 30352e 0,280x 1 2 3 0 100,000 200,000 300,000 400,000 500,000 600,000 f(x) R² =
-
Upload
alonso-del-castillo -
Category
Documents
-
view
217 -
download
0
description
Tablas de conversion
Transcript of Tablas
Hoja1CIAPosicionamiento mercado empresas medianasDENivelABCBandaA/B(A-D)/(e-d) Poner porcentajeSalario actual anualMediana Q2MpMinimoMaximoCompa ratioPER penetracion en rango% Dispersion101Ger General600,000549,000549,000439,200$658,800$10973.22%Banda92Gerente Finanzas350,000305,000305,000244,000$366,000$11586.89%Banda8Gerente comercial300,000248,000286,707229,366$344,049$12161.59%Banda72.5Gerente RRHH200,000261,000261,000208,800$313,200$77-8.43%Bajo* esta muy por debajo de la banda y del mercado, se le deberia de llevar como por lo menos al minimo de la banda..63Sub Grt Finanzas180,000163,540163,540130,832$196,248$11075.16%Banda53.5Sub Grt RRHH150,000112,000112,00089,600$134,400$134134.82%SobreSub Grt Operaciones160,000112,000112,00089,600$134,400$143157.14%Sobre44Jefe Especialista100,00093,28593,28574,628$111,942$10768.00%Banda35Jefe nmina80,00085,00085,00068,000$102,000$9435.29%Banda26Analista30,00046,00046,00036,800$55,200$65-36.96%Bajo
10549,0009305,0008286,7077261,0006163,5405112,000493,285385,000246,000y = 30352e0,280x30352286707.465852172
