Practica casa 1ver
2
Porcentaje Incremento 1.00 1.00 1.50 1.50 1.50 1.00 Total Remuneración 2010 ene-11 feb-11 mar-11 abr-11 may-11 jun-11 2,500.00 S/. 2,500.00 S/. 2,500.00 S/. 3,750.00 S/. 5,625.00 S/. 8,437.50 S/. 8,437.50 S/. 3,500.00 S/. 3,500.00 S/. 3,500.00 S/. 5,250.00 S/. 7,875.00 S/. 11,812.50 S/. 11,812.50 S/. 1,850.00 S/. 1,850.00 S/. 1,850.00 S/. 2,775.00 S/. 4,162.50 S/. 6,243.75 S/. 6,243.75 S/. 1,225.00 S/. 1,225.00 S/. 1,225.00 S/. 1,837.50 S/. 2,756.25 S/. 4,134.38 S/. 4,134.38 S/. 859.00 S/. 859.00 S/. 859.00 S/. 1,288.50 S/. 1,932.75 S/. 2,899.13 S/. 2,899.13 S/. 955.00 S/. 955.00 S/. 955.00 S/. 1,432.50 S/. 2,148.75 S/. 3,223.13 S/. 3,223.13 S/. 1,287.00 S/. 1,287.00 S/. 1,287.00 S/. 1,930.50 S/. 2,895.75 S/. 4,343.63 S/. 4,343.63 S/. 1,987.00 S/. 1,987.00 S/. 1,987.00 S/. 2,980.50 S/. 4,470.75 S/. 6,706.13 S/. 6,706.13 S/. 2,000.00 S/. 2,000.00 S/. 2,000.00 S/. 3,000.00 S/. 4,500.00 S/. 6,750.00 S/. 6,750.00 S/. 3,000.00 S/. 3,000.00 S/. 3,000.00 S/. 4,500.00 S/. 6,750.00 S/. 10,125.00 S/. 10,125.00 S/. PROYECCIÓN DE REM INSTRUCCIONES: Calcular la proyección de renumeración para cada trabajador según el porcentaje de incremento ubic Todos los resultados se deben encontrar apartir de una única fórmula colocada en la celda C13.
-
Upload
jhon-saman-caceres -
Category
Education
-
view
37 -
download
0
Transcript of Practica casa 1ver
Porcentaje
Incremento1.00 1.00 1.50 1.50 1.50 1.00
Total
Remuneración
2010
ene-11 feb-11 mar-11 abr-11 may-11 jun-11
2,500.00S/. 2,500.00S/. 2,500.00S/. 3,750.00S/. 5,625.00S/. 8,437.50S/. 8,437.50S/.
3,500.00S/. 3,500.00S/. 3,500.00S/. 5,250.00S/. 7,875.00S/. 11,812.50S/. 11,812.50S/.
1,850.00S/. 1,850.00S/. 1,850.00S/. 2,775.00S/. 4,162.50S/. 6,243.75S/. 6,243.75S/.
1,225.00S/. 1,225.00S/. 1,225.00S/. 1,837.50S/. 2,756.25S/. 4,134.38S/. 4,134.38S/.
859.00S/. 859.00S/. 859.00S/. 1,288.50S/. 1,932.75S/. 2,899.13S/. 2,899.13S/.
955.00S/. 955.00S/. 955.00S/. 1,432.50S/. 2,148.75S/. 3,223.13S/. 3,223.13S/.
1,287.00S/. 1,287.00S/. 1,287.00S/. 1,930.50S/. 2,895.75S/. 4,343.63S/. 4,343.63S/.
1,987.00S/. 1,987.00S/. 1,987.00S/. 2,980.50S/. 4,470.75S/. 6,706.13S/. 6,706.13S/.
2,000.00S/. 2,000.00S/. 2,000.00S/. 3,000.00S/. 4,500.00S/. 6,750.00S/. 6,750.00S/.
3,000.00S/. 3,000.00S/. 3,000.00S/. 4,500.00S/. 6,750.00S/. 10,125.00S/. 10,125.00S/.
PROYECCIÓN DE REMUNERACIONES 2011
INSTRUCCIONES: Calcular la proyección de renumeración para cada trabajador según el porcentaje de incremento ubicado en la fila 10. Todos los resultados se deben encontrar apartir de una única fórmula colocada en la celda C13.
1.00 1.50 1.50 1.30 1.30 1.30
jul-11 ago-11 sep-11 oct-11 nov-11 dic-11 TOTAL
8,437.50S/. 12,656.25S/. 18,984.38S/. 24,679.69S/. 32,083.59S/. 41,708.67S/. 169,800.08S/.
11,812.50S/. 17,718.75S/. 26,578.13S/. 34,551.56S/. 44,917.03S/. 58,392.14S/. 237,720.11S/.
6,243.75S/. 9,365.63S/. 14,048.44S/. 18,262.97S/. 23,741.86S/. 30,864.42S/. 125,652.06S/.
4,134.38S/. 6,201.56S/. 9,302.34S/. 12,093.05S/. 15,720.96S/. 20,437.25S/. 83,202.04S/.
2,899.13S/. 4,348.69S/. 6,523.03S/. 8,479.94S/. 11,023.92S/. 14,331.10S/. 58,343.31S/.
3,223.13S/. 4,834.69S/. 7,252.03S/. 9,427.64S/. 12,255.93S/. 15,932.71S/. 64,863.63S/.
4,343.63S/. 6,515.44S/. 9,773.16S/. 12,705.10S/. 16,516.63S/. 21,471.62S/. 87,413.08S/.
6,706.13S/. 10,059.19S/. 15,088.78S/. 19,615.42S/. 25,500.04S/. 33,150.05S/. 134,957.10S/.
6,750.00S/. 10,125.00S/. 15,187.50S/. 19,743.75S/. 25,666.88S/. 33,366.94S/. 135,840.06S/.
10,125.00S/. 15,187.50S/. 22,781.25S/. 29,615.63S/. 38,500.31S/. 50,050.41S/. 203,760.09S/.
PROYECCIÓN DE REMUNERACIONES 2011
para cada trabajador según el porcentaje de incremento ubicado en la fila 10.
