Carta Gantt Inicial y Costos Generales 14-05-2013

17
ITEM Unida Total 6 Pago cuota mensual 5 150,000 750,000 1 Formación empresa 1 400,000 400,000 SII - iniciación de activiades 1 50,000 50,000 Permiso construcción municipal 1 200,000 200,000 Patente comercial 1 200,000 200,000 Compra terreno 1 10,000,000 10,000,000 TOTAL ETAPA 0 10,850,000 Contrucción etapa 1 Cierre parcela 1 2,000,000 2,000,000 Diseño de plano de distribución 1 250,000 250,000 Diseño de pisina y cabaña y otos 1 500,000 500,000 TOTAL ETAPA 1 2,750,000 Contrucción etapa 2 Agua, alcantarillado, posos etapa 1 1 3,000,000 3,000,000 Cabaña para 4 3 11,000,000 33,000,000 Cabaña para 6 2 17,000,000 34,000,000 Cabaña para 8 1 22,000,000 22,000,000 Adminitración 1 1 4,000,000 4,000,000 Picina niño 1 3,000,000 3,000,000 Picina Adulto 1 6,000,000 6,000,000 Cabaña de entretencion 1 4,000,000 4,000,000 TOTAL ETAPA 2 ### Contrucción etapa 3 Presup 2016 21,720 Agua, alcantarillado, posos etapa 2 1 3,000,000 3,000,000 Cabaña para 4 2 11,000,000 22,000,000 Cabaña para 6 1 17,000,000 17,000,000 Cabaña para 8 0 22,000,000 - Adminitración 2 1 5,000,000 5,000,000 TOTAL ETAPA 3 47,000,000 Ingresos arriendo etapa 2 Cabaña para 4 3 45,000 Cabaña para 6 2 55,000 Cabaña para 8 1 70,000 Total Ingresos Etapa 2 Ingresos arriendo etapa 3 Cabaña para 4 1 45,000 Cabaña para 6 0 55,000 Cabaña para 8 0 70,000 Total Ingresos Etapa 3 DISTRIBUCION DE GASTOS Formación empresa 1 400,000 400,000 SII - iniciación de activiades 1 50,000 50,000 Permiso construcción municipal 1 200,000 200,000 Patente comercial 1 200,000 200,000 Compra terreno 1 10,000,000 10,000,000 TOTAL ETAPA 0 - Contrucción etapa 1 - Cierre parcela 1 2,000,000 3,000,000 Diseño de plano de distribución 1 250,000 350,000 Diseño de pisina y cabaña y otos 1 500,000 750,000 TOTAL ETAPA 1 - Contrucción etapa 2 - Agua, alcantarillado, posos etapa 1 1 3,000,000 3,000 Valor unitario

description

Carta Gantt Inicial y Costos Generales

Transcript of Carta Gantt Inicial y Costos Generales 14-05-2013

Hoja1

AO 2013AO 2014AO 2015AO 2016AO 2017ITEMUnidaValor unitarioTotal6789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960Pago cuota mensual5150,000750,000111111111111111111111111111111111111111111111111Formacin empresa1400,000400,0001111SII - iniciacin de activiades150,00050,000111Permiso construccin municipal1200,000200,000111Patente comercial1200,000200,000Compra terreno110,000,00010,000,00011TOTAL ETAPA 010,850,000Contruccin etapa 1Cierre parcela12,000,0002,000,0001Diseo de plano de distribucin1250,000250,000111Diseo de pisina y cabaa y otos1500,000500,000111TOTAL ETAPA 12,750,000Contruccin etapa 2Agua, alcantarillado, posos etapa 113,000,0003,000,00011Cabaa para 4311,000,00033,000,0001111111Cabaa para 6217,000,00034,000,0001111111Cabaa para 8122,000,00022,000,0001111111Adminitracin 114,000,0004,000,0001111111Picina nio13,000,0003,000,0001111111Picina Adulto16,000,0006,000,0001111111Cabaa de entretencion14,000,0004,000,0001111TOTAL ETAPA 2105,000,000Contruccin etapa 3Presup 201621,720Agua, alcantarillado, posos etapa 213,000,0003,000,00011111111Cabaa para 4211,000,00022,000,0001111111111Cabaa para 6117,000,00017,000,0001111111111Cabaa para 8022,000,0000.01111Adminitracin 215,000,0005,000,0001111111111TOTAL ETAPA 347,000,000Ingresos arriendo etapa 2Cabaa para 4345,000606060601515151515151515606060601515151515151515606060601515151515151515Cabaa para 6255,000404040400000000040404040000000004040404000000000Cabaa para 8170,000202020200000000020202020000000002020202000000000Total Ingresos Etapa 26,3006,3006,3006,3006756756756756756756756756,3006,3006,3006,3006756756756756756756756756,3006,3006,3006,300675675675675675675675675Ingresos arriendo etapa 3Cabaa para 4145,00020202020555555552020202055555555Cabaa para 6055,000000000000000000000000000Cabaa para 8070,000000000000000000000000000Total Ingresos Etapa 390090020202252252252252252252252259009002020225225225225225225225225DISTRIBUCION DE GASTOSFormacin empresa1400,000400,000200200SII - iniciacin de activiades150,00050,00050Permiso construccin municipal1200,000200,0001005050Patente comercial1200,000200,000200Compra terreno110,000,00010,000,00010,000TOTAL ETAPA 00.0Contruccin etapa 10.0Cierre parcela12,000,0003,000,0003,000Diseo de plano de distribucin1250,000350,000100100150Diseo de pisina y cabaa y otos1500,000750,000250250250TOTAL ETAPA 10.0Contruccin etapa 20.0Agua, alcantarillado, posos etapa 113,000,0003,0001,5001,500Cabaa para 4311,000,00033,00013,2003,3003,3003,3003,3003,3003,300Cabaa para 6217,000,00034,00013,6003,4003,4003,4003,4003,4003,400Cabaa para 8122,000,00022,0008,8002,2002,2002,2002,2002,2002,200Adminitracin 114,000,0004,0001,600400400400400400400Picina nio13,000,0003,0000.00.00.00.01,5001,500Picina Adulto16,000,0006,0003,0003,000Cabaa de entretencion14,000,0004,0002,0001,0001,000TOTAL ETAPA 2123,950,0000.00.02000.00.020010,5004003,4501,7001,50037,2009,3009,3009,30011,30014,80014,8000.00.00.00.0Contruccin etapa 30.0Agua, alcantarillado, posos etapa 213,000,0003,0001,5001,500Cabaa para 4111,000,00011,0005,5002,2002,2001,100Cabaa para 6017,000,0000.00.00.00.00.0Cabaa para 8022,000,0000.00.00.00.00.0Adminitracin 215,000,0005,0002,5001,0001,000500TOTAL ETAPA 319,0001,5009,5003,2003,2001,600

Costos operacionalLuz1200242424243333333328282828444444442828.0028.0028.004.004.004.004.004.004.004.004.00Agua cabaas1400484848486666666656565656888888885656.0056.0056.008.008.008.008.008.008.008.008.00Agua Picina125,000252525252525252525252525252525252525252525252525252525252525252525252525Gas1400484848486666666656565656888888885656.0056.0056.008.008.008.008.008.008.008.008.00TV - Cable125,000150150150150150150150150150150150150175175175175175175175175175175175175175175175175175175175175175175175175Basura125,000252525252525252525252525252525252525252525252525252525252525252525252525Persona aseo 11250,000250250250250250250250250250250250250250250250250250250250250250250250250250250250250Mantencin y jardinero1250,000250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250Nochero 11250,0000.00.00.00.00.00.00.00.00.00.00.00.00.0250250250250250250250250250250250250250250250250250250250250250250250250Administrativo ingreso1250,0000.00.00.00.00.00.00.00.00.00.00.00.00.0250250250250250250250250250250250250250250250250250250250250250250250250Administativo contable1250,000250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250

TOTAL de GASTOS1070107010701070715715715715715715715715161516151615161514951495149514951495149514951495161516151615161514951495149514951495149514951495Ingresos M$Banco M$120,000Arriendo Cabaa6,3006,3006,3006,3006756756756756756756756757,2007,2006,3206,3209009009009009009009009007,2007,2006,3206,3209009009009009009009009000.0Cuota mensual750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750750Total Efectivo750750750120,750121,500122,250123,000123,750124,500125,250126,000126,750127,500128,250129,000129,750130,500131,250138,300145,350152,400159,450160,875162,300163,725165,150166,575168,000169,425170,850178,800186,750193,820200,890202,540204,190205,840207,490209,140210,790212,440214,090222,040229,990237,060244,130245,780247,430249,080250,730252,380254,030255,680257,330258,080Egresos M$Etapa 0 y 1 y 20.00.02000.00.020010,5004003,4501,7001,50037,2009,3009,3009,30011,30014,80014,8000.00.00.00.00.00.00.01,5009,5003,2003,2001,6000.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0Costo operacional0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.01,0701,0701,0701,0707157157157157157157157151,6151,6151,6151,6151,4951,4951,4951,4951,4951,4951,4951,4951,6151,6151,6151,6151,4951,4951,4951,4951,4951,4951,4951,4950.0Cuota prestamo banco500180,000500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500Total Costo Oper5001,0001,7002,2002,7003,40014,40015,30019,25021,45023,45061,15070,95080,75090,550102,350117,650132,950134,520136,090137,660139,230140,445141,660142,875145,590156,305160,720165,135167,950170,065172,180174,295176,410178,405180,400182,395184,390186,385188,380190,375192,370194,485196,600198,715200,830202,825204,820206,815208,810210,805212,800214,795216,790217,290Fujo Caja M$250(250)(950)118,550118,800118,850108,600108,450105,250103,800102,55065,60056,55047,50038,45027,40012,850(1,700)3,7809,26014,74020,22020,43020,64020,85019,56010,2707,2804,2902,9008,73514,57019,52524,48024,13523,79023,44523,10022,75522,41022,06521,72027,55533,39038,34543,30042,95542,61042,26541,92041,57541,23040,88540,54040,790Costo contruccinTerreno110,000,00010,000,000Cierre Parcela12,000,0002,000,000Diseo de plano de distribucin1250,000250,000Diseo de pisina y cabaa y otos1500,000500,000Agua, luz, alcantarillado, posos etapa23,000,0006,000,000Cabaa para 4611,000,00066,000,000Cabaa para 6417,000,00068,000,000Cabaa para 8222,000,00044,000,000Picina nio13,000,0003,000,000Picina Adulto16,000,0006,000,000Administracin 114,000,0004,000,00020Administracin 215,000,0005,000,000Cabaa de entretencion24,000,0008,000,000TOTAL EGRESOS222,750,000Ingresos Banco1120,000,000120,000,000Ingresos mensual48150,00036,000,000

ParametrosTotal Socios familia5Monto mensual150000750,000Valor arriendoCabaa para 4 das arriendo verano2045,000Cabaa para 6 arriendo verano2055,000Cabaa para 8 arriendo verano2070,000Cabaa para 4 arriendo invierno525,000Cabaa para 6 arriendo invierno035,000Cabaa para 8 arriendo invierno045,000

Hoja2

Hoja3