guia#9 aplicación de formulas y referencia absoluta sebastian giraldo duque 8c

3
ORDEN 1 SALARIO 2 COMISIÓN 3 SUBSIDIO 4 PRESTAMO 1 MARIANO ### $ 106,027 $ 353,423 $ 466,519 2 ANDRÉS ### $ 75,500 $ 251,667 $ 332,200 3 JORGE ### $ 55,291 $ 184,303 $ 243,280 4 MARIO $ 993,027 $ 49,651 $ 165,505 $ 218,466 5 ANA $ 859,879 $ 42,994 $ 143,313 $ 189,173 TOTAL ### $ 329,463 ### $ 1,449,639 COMISIÓN 5% SUBSIDIO 6 PRESTAMO 22%

Upload: sebasgiraldo

Post on 22-Nov-2015

7 views

Category:

Documents


0 download

TRANSCRIPT

Hoja1ORDEN1 SALARIO2 COMISIN3 SUBSIDIO4 PRESTAMO5 TOTAL DE VENGADO

1MARIANO$ 2,120,540$ 106,027$ 353,423$ 466,519$ 2,113,4722ANDRS$ 1,510,000$ 75,500$ 251,667$ 332,200$ 1,504,9673JORGE$ 1,105,820$ 55,291$ 184,303$ 243,280$ 1,102,1344MARIO$ 993,027$ 49,651$ 165,505$ 218,466$ 989,7175ANA$ 859,879$ 42,994$ 143,313$ 189,173$ 857,013TOTAL$ 6,589,266$ 329,463$ 1,098,211$ 1,449,639$ 6,567,302COMISIN5%SUBSIDIO6PRESTAMO22%

Hoja2PROYECCIN DE AUMENTOS DE PRECIOS

2011DIFERENCIA EN PESOS2012DIFERENCIA DE PESOS2013DIFERENCIA DE PESOS2014$ 10,500$ 315$ 10,815$ 541$ 11,356$ 227$ 11,583$ 11,550$ 347$ 11,897$ 595$ 12,491$ 250$ 12,741$ 12,100$ 363$ 12,463$ 623$ 13,086$ 262$ 13,348$ 12,550$ 377$ 12,927$ 646$ 13,573$ 271$ 13,844$ 13,275$ 398$ 13,673$ 684$ 14,357$ 287$ 14,644$ 14,700$ 441$ 15,141$ 757$ 15,898$ 318$ 16,216$ 15,405$ 462$ 15,867$ 793$ 16,661$ 333$ 16,994$ 16,590$ 498$ 17,088$ 854$ 17,942$ 359$ 18,301$ 17,570$ 527$ 18,097$ 905$ 19,002$ 380$ 19,382$ 19,800$ 594$ 20,394$ 1,020$ 21,414$ 428$ 21,842$ 19,950$ 599$ 20,549$ 1,027$ 21,576$ 432$ 22,007$ 20,200$ 606$ 20,806$ 1,040$ 21,846$ 437$ 22,283$ 21,100$ 633$ 21,733$ 1,087$ 22,820$ 456$ 23,276$ 22,350$ 671$ 23,021$ 1,151$ 24,172$ 483$ 24,655$ 22,400$ 672$ 23,072$ 1,154$ 24,226$ 485$ 24,710

20113%20125%20132%

Hoja3