FORMATO FINANZAS 2012
INDICESECRETARIA DE AGRICULTURA, GANADERA, DESARROLLO RURAL, PESCA Y ALIMENTACINFORMATO: CORRIDA FINANCIERA PROGRAMAS FAPPA Y PROMETENOMBRE DEL PROYECTO:0VI. Anlisis FinancieroAPRESUPUESTO DE INVERSINBCLCULOS TCNICOSB.I.MEMORIAS DE CLCULOB. II.COSTOS DE OPERACINCPROYECCIN FINANCIERA MINIMA A 5 AOS.C.I.PROYECCIN DE COSTOS TOTALES DE PRODUCCINC.II.PROYECCIN DE INGRESOSC.III.ESTADO DE RESULTADOSC.IV.FLUJO DE EFECTIVODANLISIS DE RENTABILIDADD.I.PUNTO DE EQUILIBRIOD.lI.VAN, TIR Y B/C
PRESUPUESTO DE INVERSINMEMORIAS DE CLCULOCOSTOS DE OPERACINPROYECCIN DE INGRESOSFLUJO DE EFECTIVOESTADO DE RESULTADOSVAN, TIR Y B/CPROYECCIN DE COSTOS TOTALES DE PRODUCCINPUNTO DE EQUILIBRIO
A. PRESUPUESTO DE INVERSION00CONCEPTOSUNIDADCANTIDADCOSTO UNITARIOMONTOSPROGRAMASOCIOSTOTALACTIVO FIJOLOCAL COMERCIAL DE 5X6M230$1,500.00$45,000.00$45,000.00$45,000.00$114,872.26ANAQUEL DE ACERO INOXIDABLEPIEZA10$1,200.00$12,000.00$12,000.00$12,000.00MOSTRADOR DE MADERA DE 1X2.5PIEZA1$5,783.73$5,783.73$5,783.73$5,783.73REFRIGERADOR DE 10 PIESPIEZA2$10,500.00$21,000.00$21,000.00$21,000.00VITRINA EXIBIDORAPIEZA1$27,800.00$27,800.00$27,800.00$27,800.00BASCULAPIEZA1$3,288.53$3,288.53$3,288.53$3,288.53ACTIVO DIFERIDOACONDICIONAMIENTO DEL LOCALSERV.1$22,500.00$22,500.00$22,500.00$22,500.00ELABORACION Y ASISTENCIA TECNICASERV.1$18,000.00$18,000.00$18,000.00$18,000.00$45,750.00LICENCIA DE FUNCIONAMIENTOSERV.1$250.00$250.00$250.00$250.00CONSTITUCION EN FIGURA JURIDICASERV.1$5,000.00$5,000.00$5,000.00$5,000.00CAPITAL DE TRABAJO0.00.0LOTE DE MERCANCIASLOTE1$87,627.74$87,627.74$87,627.74$87,627.74INSUMOSSERV1$228.00$228.00$228.00$228.00MANO DE OBRAJORNAL42$70.00$2,940.00$2,940.00$2,940.00GASTOS DE ABMINISTRACIONSERV1$750.00$750.00$750.00$750.00$93,745.74FLETESSERV1$750.00$750.00$750.00$750.00PUBLICIDADSERV1$600.00$600.00$600.00$600.00AGUASERV1$50.00$50.00$50.00$50.00LUZSERV1$800.00$800.00$800.00$800.00TOTAL$198,000.00$56,368.00$254,368.00
ENLISTARAN TODOS LOS ARTICULOS A ADQUIRIR CON EL RECURSO DEL PROGRAMA.BIENES DURADEROS PARA EL FUNCIONAMIENTO DEL PROYECTOMEDIDA DE COMPRA DE LOS ARTICULOSCANTIDAD DE ARTICULOS ADQUIRIR = A SOLICITADOS EN ANEXO ACOSTO DE COMPRA DE LOS ARTICULOS A ADQUIRIRSON GASTOS PAGADOS POR ANTICIPADO PERO NECESARIOS PARA LA APERTURA DEL PROYECTOINSUMOS DE PRONTA UTILIZACION INDISPENSABLES PARA LA OPERACIN DEL PROYECTO
C.I. PROYECCION COSTOS TOTALES00COSTOS FIJOSAO 1AO 2AO 3AO 4AO 5LUZ$4,800.00$5,280.00$5,808.00$6,388.80$7,027.68AGUA$600.00$660.00$726.00$798.60$878.46MANO DE OBRA$141,120.00$155,232.00$170,755.20$187,830.72$206,613.79GASTOS DE ABMINISTRACION$9,000.00$9,900.00$10,890.00$11,979.00$13,176.90RENOVACION DE LICENCIA$250.00$275.00$302.50$332.75$366.03INSUMOS$2,736.00$3,009.60$3,310.56$3,641.62$4,005.78TOTAL$158,506.00$174,356.60$191,792.26$210,971.49$232,068.63COSTOS VARIABLESAO 1AO 2AO 3AO 4AO 5FLETES$36,000.00$39,600.00$43,560.00$47,916.00$52,707.60PUBLICIDAD$600.00$660.00$726.00$798.60$878.46LOTE DE MERCANCIAS$1,342,235.66$1,476,459.22$1,624,105.15$1,786,515.66$1,965,167.23TOTAL$1,378,835.66$1,516,719.22$1,668,391.15$1,835,230.26$2,018,753.29AO 1AO 2AO 3AO 4AO 5COSTOS FIJOS$158,506.00$174,356.60$191,792.26$210,971.49$232,068.63COSTOS VARIABLES$1,378,835.66$1,516,719.22$1,668,391.15$1,835,230.26$2,018,753.29COSTOS TOTALES$1,537,341.66$1,691,075.82$1,860,183.41$2,046,201.75$2,250,821.92
B.I. MEMORIAS DE CALCULO0MEMORIAS DE CALCULO DE COSTOS Y VENTASPRODUCCIONDISTRIBUCIONVENTASADMINISTRATIVOSMANTENIMIENTOAbarrotesCantidadPrecio unitario50 KG AZUCAR ESTANDAR1$403.0050 KG AZUCCAR REFINADA1$449.0010/1KG AZUCAR REFINADA1$104.0010/1KG AZUCAR ESTANDAR1$94.0044KG HARINA DE TRIGO ALTA PROTEINA1$327.0044KG HARINA DE TRIGO ARTESANAL1$314.002/800G HARINA P/HOT CAKES PRONTO1$52.924/1KG HARINA DE TRIGO SAN BLAS1$37NESCAFE CAF SOLUBLE REGULAR 300 GR1$71.00CAF GOURMET SOLUBLE DESCAFEINADO MM1$109.00CAF DESCAFEINADO TOSTADO Y MOLIDO 1.21$99.906/50 NESCAFE CLASICO1$134.006/100 NESCAFE CAF SOLUBLE REGULAR1$209BC CAF REGULAR TOSTADO Y MOLIDO1$129.001KG CAF SOLUBLE REGULAR BC1$199.0012/1LT NUTRILECHE-PRODUCTO LACTEO1$139.0012/1L ALPURA DESLACTOSADA LIGHT1$168.0012/1L ALPURA ESPECIALIZADA (MUJER)1$169.0012/10 LECHE ESPECIAIZADA EXTRACALCIO1$168.0012/1L LALA DESLACTOSADA1$168.0012/1 LECHE ALPURA SEMIDESCREMADA1$162.8212/1 LECHE LALA SEMIDESCREMADA1$159.5012/1LT LECHE LALA ENTERA1$162.0012/1 LT LECHE ALPURA SELECTA1$163.0012/1LT LECHE LALA LIGTH1$162.0012/1LT BC PRODUCTO LACTEO1$119.001.6KG NIDO 1+1$169.001.6KG NIDO 3+1$169.001.8KG LECHE EN POLVO ALPURA KIDS1$159.001.8KG LECHE ENTERA EN POLVO ALPURA1$144.001.8KG SVELTY DIGEST1$169.004/380 GR NIDO FORTIFICADA1$9.906/1LT LECHE DE SOYA OGANICA MM1$89.0027/250ML ALPURA SABOR CHOCOLATE1$138.0016/190 ML NESQUIK SABOR CHOCOLATE1$80.0027/236 ML HERSHEYS SABOR CHOCOLATE1$169.0012/946 ML ADES NATURAL BEBIDA DE SOYA1$195.008/397GR LA LECHERA LECHE CONDENSADA1$119.008/378 GR LECHE EVAPORADA CARNETION1$84.8925/378 GR CARNATION LECHE EVAPORADA1$269.0024/397 LECHE CONDENSADA LA LECHERA1$344.008/225 GR NESTLE MEDIA CREMA1$64,9010/240 ML YOGURTH DE FRESA BEBIDA LALA1$45.4012/90 GR CHOCOLATE DE MESA ABUELITA1$96.1240/22 GR CHOCOMILK CHOCOLATE EN POLVO1$99.005/375 GR CHOCOMILK CHOCOLATE EN POLVO1$119.0080/170 GALLETAS MARIAS1$108.18EMPERADOR SURTIDO1$70.2914 PZAS PAKETINES GAMESA1$85.01PEKEPAKES GAMESA 1.17 KG1$71.01MARIAS MINI ROLLOS 25/60 GRS1$71.74SURTIDO RICO MEGA PACK1$70.7412/1LT ACEITE COMESTIBLE 1231$270.0024/500 ML ACEITE COMESTIBLE CORONA1$210.0012/1 ACEITE COMESTIBLE BC1$210.0012/1 ACEITE COMESTIBLE MARAVI1$262.003/946 ML ACEITE DE SOY NUTRIOLI1$79.903/945 ML ACEITE CAPULLO1$75.003/1 LT ACEITE PATRONA TRIPACK1$62.002/946 ACEITE OLEICO1$77.0050/2 PZ KNORR CUBOS1$119.003/24 KNORR CUBOS CONSOME DE POLLO1$79.901KG KNORR SUIZA CALDO DE POLLO1$79.0010/8 PZ KNORR CUBOS CALDO DE POLLO1$94.003/12 KNORR TOMATE CONSOME1$39.906/1 KG ARROZ SUPER EXTRA SCHETTINO1$69.606/1 KG ARROZ SUPER EXTRA LA MERCED1$64.005/1 FRIJOL NEGRO SCHETTINO1$74.0012 PZS SOPA INSTANTANEA MARUCHAN POLLO1$59.9012 PZ SOPA INSTANTANEA MARUCHAN HABANERO1$59,4012 PZ SOPA INSTANTANEA MARUCHAN CAMARON1$59.9012 PZ SOPA INSTANTANEA MARUCHAN CAMARON C/CHILE1$59.403.4 KG MAYONESA-LIMON MCCORMICK1$119.581730 GR MAYONESA C/LIMON MCCORMICK1$83.006/190 GR MAYONESA CON LIMON MCCORMICK1$71.433/390 GR MAYONESA CON LIMON MCCORMICK1$72.006/425 GR SARDINA OVAL TOMATE GUAYMEX1$11548/140 GR ATUN ACEITE DOLORES1$499.0048/140 GR ATUN EN AGUA DOLORES1$499.008/140 ATUN EN ACEITE TUNY1$74.908/PACK ENSALADA ATUN TUNY LIGHT1$89.003/380 GR RAJAS VERDES LA COSTEA1$33.203/380 JALAPEOS LA COSTEA1$28.506/220 RAJAS VERDES LA COSTEA1$39.0010/105 RAJAS VERDES LA COSTEA134.66/220G CHIPOTLES LA COSTEA1$71.0010/105 CHIPOTLES LA COSTEA1$55.706/370 MML SALSA PICANTE VALENTINA1$40.8012 PZS VELA SEMANARIA ECOLOGICA1$231.0012 PZS VELA 3.5 DIAS ECOLOGICA1$132.018 PZS VELADORA #151$239.9120/500 FOCA DETERGENTE EN POLVO1$234.6340/250 FOCA DETERGENTE EN POLVO1$229.1210/1 KG FOCA DETERGENTE EN POLVO1$238.8720/500 BLANCA NIEVES DETERGENTE EN POLVO1$219.9040/250 BLANCA NIEVES DETERGENTE EN POLVO1$219.9010/1 KG BLANCA NIEVES DETERGENTE EN POLVO1$219.3725/400GR JABON ZOTE ROSA1$252.4550/200 GR ZOTE ROSA1$265.008/950ML CLORALEX BLANQUEADOR1$64.9915/500 ML CLORALEX BLANQUEADOR1$69.508/1 LT PINOL LIMPIADOR1$132.6015/500 ML PINOL LIMPIADPR1$139.008/850 ML ENSUEO SUAVIZANTE1$96.009/1 KG ARIEL DETERGENTE EN POLVO1$259.0024/500 ARIEL DETERGENTE EN POLVO1$341.5548/250 ARIEL DETERGENTE EN POLVO11$369.0024/500 ARIEL DOWNY1$386.009/1 KG ACE REGULAR DETERGENTE EN POLVO1$210.5424/500 GR ACE DETERGENTE EN POLVO1$295.0048/250G ACE REGULAR DETERGENTE EN POLVO1$319.0024/500 ACE NATURALS DETERGENTE EN POLVO1$291.3710/1 KG ROMA DETERGENTE EN POLVO1$229.008/1.2 KG MAESTRO LIMPIO DETERGENTE EN POLVO1$145.0024/500 SALVO LIMON LAVATRASTES EN POLVO1$238.9924/600 COCA COLA PET1$181.2012/355 COCA COLA LATA1$84.7024/600 COCA COLA LIGHT PET1$209.9924/237ML COCA COLA1$114.0012/335 ML COCA COLA LIGHT LATA1$79.5112/600 YOLIPET1$72.0024/355 ML YOLI LATA1$143.004/2LT REFRESCO SABORES VARIOS1$62.0015/600 MULTI SABBOR PEPSI, MIRINDA, MANZANA, 7UP1$97.5415/400 MILTI SABOR PEPSI, MIRINDA, MANZANA 7UP1$65.9524/355 ML ,MULTISABOR PEPSI, MIRINDA, MANZANA, 7UP1$109.018/2 LT PEAFIEL SABORES SURTIDOS1$115.0012/600 PEAFIEL SABORES SURTIDOS1$62.206/3 JARRITOS SABORES SURTIDOS1$92.788/2LT SQUIRT1$134.4612/330 ML PUREZA VITAL SABORES SURTIDOS1$43.0024/330 ML KIDS BONAFON SABORES SURTIDOS1$86.0024/500ML AGUA LEVITE SABORES SURTIDOS1$134.0024/500ML BONAFON CON JUGO SABORES SURTIDO1$140.0012/1.5LT BONAFON CON JUGO SABORES SURTIDOS1$125.006/3LT BIG CITRUS SABOR NARANJA1$110.0024/250 PAU PAU SABORES SURTIDOS1$53.0024/250ML FRUTSI SABORES SURTIDOS1$72.0024/473ML BEBERE NARANJA1$101.4012/1.5LT AGUA BONAFONT1$74.6812/1LT AGUA BONAFONT1$60.0024/600ML AGUA BONAFONT1$83.1924/250 ML AGUA BONAFONT1$54.00MM 12/1.5 L AGUA1$52.00MM12/1L AGUA1$45.50MM 24/500 LT AGUA1$46.00RG 24/250 ML BEBIDA SABORIZADA1$38.00AbarrotesCantidadCOSTO TOTALPRECIO U.PRECIO V.LUNESMARTESMIERCOLESJUEVESVIERNESSABADODOMINGOTOTALEGRE.TOTALESINGRE. TOTAL50 KG AZUCAR ESTANDAR1$403.00$8.06$12.0011214211$88.66$132.0050 KG AZUCCAR REFINADA1$449.00$8.98$13.0001111015$44.90$65.0010/1KG AZUCAR REFINADA1$104.00$10.40$13.0021001206$62.40$78.0010/1KG AZUCAR ESTANDAR1$94.00$9.40$12.502231215025$235.00$312.5044KG HARINA DE TRIGO ALTA PROTEINA1$327.00$7.43$10.0010001103$22.30$30.0044KG HARINA DE TRIGO ARTESANAL1$314.00$7.14$9.0010220117$49.95$63.002/800G HARINA P/HOT CAKES PRONTO1$52.92$26.46$30.0011112017$185.22$210.004/1KG HARINA DE TRIGO SAN BLAS1$37$37.00$43.00117101011$407.00$473.00NESCAFE CAF SOLUBLE REGULAR 300 GR1$71.00$71.00$85.0010101115$355.00$425.00CAF GOURMET SOLUBLE DESCAFEINADO MM1$109.00$109.00$120.0010111105$545.00$600.00CAF DESCAFEINADO TOSTADO Y MOLIDO 1.21$99.90$99.90$115.0011001115$499.50$575.006/50GR NESCAFE CLASICO1$134.00$22.33$25.0011011105$111.67$125.006/100 NESCAFE CAF SOLUBLE REGULAR1$209$34.83$40.0002111106$209.00$240.00BC CAF REGULAR TOSTADO Y MOLIDO1$129.00$129.00$145.0010010103$387.00$435.001KG CAF SOLUBLE REGULAR BC1$199.00$199.00$220.0011001003$597.00$660.0012/1LT NUTRILECHE-PRODUCTO LACTEO1$139.00$11.58$14.5012111107$81.08$101.5012/1L ALPURA DESLACTOSADA LIGHT1$168.00$14.00$17.5011211118$112.00$140.0012/1L ALPURA ESPECIALIZADA (MUJER)1$169.00$14.08$17.5011121129$126.75$157.5012/10 LECHE ESPECIAIZADA EXTRACALCIO1$168.00$14.00$17.5012200005$70.00$87.5012/1L LALA DESLACTOSADA1$168.00$14.00$17.50113231011$154.00$192.5012/1 LECHE ALPURA SEMIDESCREMADA1$162.82$13.57$17.0011211219$122.12$153.0012/1 LECHE LALA SEMIDESCREMADA1$159.50$13.29$16.50111212311$146.21$181.5012/1LT LECHE LALA ENTERA1$162.00$13.50$17.00311211110$135.00$170.0012/1 LT LECHE ALPURA SELECTA1$163.00$13.58$17.00346442225$339.58$425.0012/1LT LECHE LALA LIGTH1$162.00$13.50$16.50557243127$364.50$445.5012/1LT BC PRODUCTO LACTEO1$119.00$9.92$12.50224213115$148.75$187.501.6KG NIDO 1+1$169.00$169.00$189.0000111115$845.00$945.001.6KG NIDO 3+1$169.00$169.00$170.0010110014$676.00$680.001.8KG LECHE EN POLVO ALPURA KIDS1$159.00$159.00$180.0001001013$477.00$540.001.8KG LECHE ENTERA EN POLVO ALPURA1$144.00$144.00$170.0001010013$432.00$510.001.8KG SVELTY DIGEST1$169.00$169.00$189.00101013$507.00$567.004/380 GR NIDO FORTIFICADA1$9.90$2.48$7.0012111118$19.80$56.006/1LT LECHE DE SOYA OGANICA MM1$89.00$14.83$18.00121211210$148.33$180.0027/250ML ALPURA SABOR CHOCOLATE1$138.00$5.11$8.00112211210$51.11$80.0016/190 ML NESQUIK SABOR CHOCOLATE1$80.00$5.00$7.5011111016$30.00$45.0027/236 ML HERSHEYS SABOR CHOCOLATE1$169.00$6.26$8.0001111116$37.56$48.0012/946 ML ADES NATURAL BEBIDA DE SOYA1$195.00$16.25$20.0001111015$81.25$100.008/397GR LA LECHERA LECHE CONDENSADA1$119.00$14.88$18.5010101115$74.38$92.508/378 GR LECHE EVAPORADA CARNETION1$84.89$10.61$13.0011110015$53.06$65.0025/378 GR CARNATION LECHE EVAPORADA1$269.00$10.76$13.50122122212$129.12$162.0024/397 LECHE CONDENSADA LA LECHERA1$344.00$14.33$18.001201105$71.67$90.008/225 GR NESTLE MEDIA CREMA1$64.90$8.11$10.5011111117$56.79$73.5010/240 ML YOGURTH DE FRESA BEBIDA LALA1$45.40$4.54$6.003873102134$154.36$204.0012/90 GR CHOCOLATE DE MESA ABUELITA1$96.12$8.01$10.0010111026$48.06$60.0040/22 GR CHOCOMILK CHOCOLATE EN POLVO1$99.00$2.48$3.50113121211$27.23$38.505/375 GR CHOCOMILK CHOCOLATE EN POLVO1$119.00$23.80$27.0001111015$119.00$135.0080/170 GALLETAS MARIAS1$108.18$1.35$4.50123446222$29.75$99.00EMPERADOR SURTIDO1$70.29$70.29$85.0011011015$351.45$425.0014 PZAS PAKETINES GAMESA1$85.01$7.08$8.50138275026$184.19$221.00PEKEPAKES GAMESA 1.17 KG1$71.01$71.01$78.0011010104$284.04$312.00MARIAS MINI ROLLOS 25/60 GRS1$71.74$2.87$4.00332333017$48.78$68.00SURTIDO RICO MEGA PACK1$70.74$70.74$75.0001101003$212.22$225.0012/1LT ACEITE COMESTIBLE 1231$270.00$22.50$28.0002011206$135.00$168.0024/500 ML ACEITE COMESTIBLE CORONA1$210.00$8.75$11.00344432222$192.50$242.0012/1 ACEITE COMESTIBLE BC1$210.00$17.50$20.0010111105$87.50$100.0012/1 ACEITE COMESTIBLE MARAVI1$262.00$21.83$24.0001111015$109.17$120.003/946 ML ACEITE DE SOY NUTRIOLI1$79.90$26.63$31.0011011004$106.53$124.003/945 ML ACEITE CAPULLO1$75.00$25.00$29.0011011015$125.00$145.003/1 LT ACEITE PATRONA TRIPACK1$62.00$20.67$24.0011111117$144.67$168.002/946 ACEITE OLEICO1$77.00$38.50$45.0010210116$231.00$270.0050/2 PZ KNORR CUBOS1$119.00$2.38$3.00222233216$38.08$48.003/24 KNORR CUBOS CONSOME DE POLLO1$79.90$26.63$30.0011111128$213.07$240.001KG KNORR SUIZA CALDO DE POLLO1$79.00$79.00$85.0001010114$316.00$340.0010/8 PZ KNORR CUBOS CALDO DE POLLO1$94.00$9.40$11.00411541117$159.80$187.003/12 KNORR TOMATE CONSOME1$39.90$13.30$16.00612121114$186.20$224.006/1 KG ARROZ SUPER EXTRA SCHETTINO1$69.60$11.60$14.002481457242$487.20$588.006/1 KG ARROZ SUPER EXTRA LA MERCED1$64.00$10.67$13.00462559334$362.67$442.005/1 FRIJOL NEGRO SCHETTINO1$74.00$14.80$17.001087789251$754.80$867.0012 PZS SOPA INSTANTANEA MARUCHAN POLLO1$59.90$4.99$6.00453364025$124.79$150.0012 PZ SOPA INSTANTANEA MARUCHAN HABANERO1$59.40$4.95$6.00132121111$54.45$66.0012 PZ SOPA INSTANTANEA MARUCHAN CAMARON1$59.90$4.99$6.0001122118$39.93$48.0012 PZ SOPA INSTANTANEA MARUCHAN CAMARON C/CHILE1$59.40$4.95$6.00212122111$54.45$66.003.4 KG MAYONESA-LIMON MCCORMICK1$119.58$119.58$123.0011111128$956.64$984.001730 GR MAYONESA C/LIMON MCCORMICK1$83.00$83.00$96.0011100104$332.00$384.006/190 GR MAYONESA CON LIMON MCCORMICK1$71.43$11.91$14.0022110028$95.24$112.003/390 GR MAYONESA CON LIMON MCCORMICK1$72.00$24.00$27.0011010317$168.00$189.006/425 GR SARDINA OVAL TOMATE GUAYMEX1$115$19.17$22.00122111210$191.67$220.0048/140 GR ATUN ACEITE DOLORES1$499.00$10.40$12.00246375431$322.27$372.0048/140 GR ATUN EN AGUA DOLORES1$499.00$10.40$12.00215002111$114.35$132.008/140 ATUN EN ACEITE TUNY1$74.90$9.36$11.50253425324$224.70$276.008/PACK ENSALADA ATUN TUNY LIGHT1$89.00$11.13$14.00212112211$122.38$154.003/380 GR RAJAS VERDES LA COSTEA1$33.20$9.50$12.0000111115$47.50$60.003/380 JALAPEOS LA COSTEA1$28.50$9.50$12.0011122119$85.50$108.006/220 RAJAS VERDES LA COSTEA1$39.00$6.50$8.00323332218$117.00$144.0010/105 RAJAS VERDES LA COSTEA134.6$3.46$5.0011111229$31.14$45.006/220G CHIPOTLES LA COSTEA1$71.00$11.83$14.00111222211$130.17$154.0010/105 CHIPOTLES LA COSTEA1$55.70$5.57$7.0088911136762$345.34$434.006/370 MML SALSA PICANTE VALENTINA1$40.80$6.80$8.50446911833$224.40$280.5012 PZS VELA SEMANARIA ECOLOGICA1$231.00$19.25$24.0012111118$154.00$192.0012 PZS VELA 3.5 DIAS ECOLOGICA1$132.01$11.00$13.001011101115$165.01$195.008 PZS VELADORA #151$239.91$29.99$35.0010112016$179.93$210.0020/500 FOCA DETERGENTE EN POLVO1$234.63$11.73$14.00811689101567$786.01$938.0040/250 FOCA DETERGENTE EN POLVO1$229.12$5.73$7.00146857435$200.48$245.0010/1 KG FOCA DETERGENTE EN POLVO1$238.87$23.89$29.0010101126$143.32$174.0020/500 BLANCA NIEVES DETERGENTE EN POLVO1$219.90$11.00$13.50135322319$208.91$256.5040/250 BLANCA NIEVES DETERGENTE EN POLVO1$219.90$5.50$6.50255353427$148.43$175.5010/1 KG BLANCA NIEVES DETERGENTE EN POLVO1$219.37$21.94$26.00332322217$372.93$442.0025/400GR JABON ZOTE ROSA1$252.45$10.10$12.0030111118$80.78$96.0050/200 GR ZOTE ROSA1$265.00$5.30$6.50455674940$212.00$260.008/950ML CLORALEX BLANQUEADOR1$64.99$8.12$10.50313111010$81.24$105.0015/500 ML CLORALEX BLANQUEADOR1$69.50$4.63$6.00232211112$55.60$72.008/1 LT PINOL LIMPIADOR1$132.60$16.58$20.00111041311$182.33$220.0015/500 ML PINOL LIMPIADPR1$139.00$9.27$12.0011121017$64.87$84.008/850 ML ENSUEO SUAVIZANTE1$96.00$12.00$15.0011101206$72.00$90.009/1 KG ARIEL DETERGENTE EN POLVO1$259.00$28.78$33.0000110103$86.33$99.0024/500 ARIEL DETERGENTE EN POLVO1$341.55$14.23$17.00011013511$156.54$187.0048/250 ARIEL DETERGENTE EN POLVO11$369.00$7.69$9.50112121412$92.25$114.0024/500 ARIEL DOWNY1$386.00$16.08$20.0011011116$96.50$120.009/1 KG ACE REGULAR DETERGENTE EN POLVO1$210.54$23.39$29.0010100125$116.97$145.0024/500 GR ACE DETERGENTE EN POLVO1$295.00$12.29$15.00121121210$122.92$150.0048/250G ACE REGULAR DETERGENTE EN POLVO1$319.00$6.65$8.50322323520$132.92$170.0024/500 ACE NATURALS DETERGENTE EN POLVO1$291.37$12.14$15.00121212211$133.54$165.0010/1 KG ROMA DETERGENTE EN POLVO1$229.00$22.90$28.0001000124$91.60$112.008/1.2 KG MAESTRO LIMPIO DETERGENTE EN POLVO1$145.00$18.13$22.5010000102$36.25$45.0024/500 SALVO LIMON LAVATRASTES EN POLVO1$238.99$9.96$12.50152721927$268.86$337.5024/600 COCA COLA PET1$181.20$7.55$9.00468101381059$445.45$531.0012/355 COCA COLA LATA1$84.70$7.06$8.0057911108858$409.38$464.0024/600 COCA COLA LIGHT PET1$209.99$8.75$9.50483645434$297.49$323.0024/237ML COCA COLA1$114.00$4.75$6.00778685647$223.25$282.0012/335 ML COCA COLA LIGHT LATA1$79.51$6.63$8.50565443431$205.40$263.5012/600 YOLIPET1$72.00$6.00$8.005469118952$312.00$416.0024/355 ML YOLI LATA1$143.00$5.96$7.0021021219$53.63$63.004/2LT REFRESCO SABORES VARIOS1$62.00$15.50$19.0012111208$124.00$152.0015/600 MULTI SABBOR PEPSI, MIRINDA, MANZANA, 7UP1$97.54$6.50$8.0057689101358$377.15$464.0015/400 MILTI SABOR PEPSI, MIRINDA, MANZANA 7UP1$65.95$4.40$6.0066791241054$237.42$324.0024/355 ML ,MULTISABOR PEPSI, MIRINDA, MANZANA, 7UP1$109.01$4.54$6.00666975746$208.94$276.008/2 LT PEAFIEL SABORES SURTIDOS1$115.00$14.38$18.0011001227$100.63$126.0012/600 PEAFIEL SABORES SURTIDOS1$62.20$5.18$7.0067791091361$316.18$427.006/3 JARRITOS SABORES SURTIDOS1$92.78$15.46$19.00322122113$201.02$247.008/2LT SQUIRT1$134.46$16.81$20.00131311111$184.88$220.0012/330 ML PUREZA VITAL SABORES SURTIDOS1$43.00$3.58$5.00330203415$53.75$75.0024/330 ML KIDS BONAFON SABORES SURTIDOS1$86.00$3.58$5.00554533631$111.08$155.0024/500ML AGUA LEVITE SABORES SURTIDOS1$134.00$5.58$7.00344223119$106.08$133.0024/500ML BONAFON CON JUGO SABORES SURTIDO1$140.00$5.83$7.50442332119$110.83$142.5012/1.5LT BONAFON CON JUGO SABORES SURTIDOS1$125.00$10.42$13.00113000510$104.17$130.006/3LT BIG CITRUS SABOR NARANJA1$110.00$18.33$22.0010111206$110.00$132.0024/250 PAU PAU SABORES SURTIDOS1$53.00$2.21$3.00223414319$41.96$57.0024/250ML FRUTSI SABORES SURTIDOS1$72.00$3.00$3.50344656533$99.00$115.5024/473ML BEBERE NARANJA1$101.40$3.11$5.00532435830$93.35$150.0012/1.5LT AGUA BONAFONT1$74.68$6.22$8.00697855545$280.05$360.0012/1LT AGUA BONAFONT1$60.00$5.00$8.00454653734$170.00$272.0024/600ML AGUA BONAFONT1$83.19$3.47$6.00334222218$62.39$108.0024/250 ML AGUA BONAFONT1$54.00$2.25$4.00112122211$24.75$44.00MM 12/1.5 L AGUA1$52.00$4.33$6.00334221419$82.33$114.00MM12/1L AGUA1$45.50$3.79$7.00443434426$98.58$182.00MM 24/500 LT AGUA1$46.00$1.92$4.00434335426$49.83$104.00RG 24/250 ML BEBIDA SABORIZADA1$38.00$1.58$3.00334345729$45.92$87.00$27,963.24$33,677.00CONCEPTOPERIODICIDADCOST UTOTAL ANUALLUZBIMENSUAL8004800AGUAMENSUAL50600GASOLINA PARA FLETESSEMANAL10019200FLETESSEMANAL75036000MANO OBRASEMANAL2940141120GASTOS DE ABMINISTRACIONMENSUAL7509000PUBLICIDADANUAL600600211320INSUMOS(BOLSAS)CONCEPTOSCANTIDADU.M.P. UNITARIOCTO. TOTALRAFIA1ROLLO$75.00$75.00BOLSAS/ASAS1KILOS$68.00$68.00BOLSAS/KILO1KILOS$45.00$45.00BOLSAS POLIPAPEL1ROLLO$40.00$40.00TOTAL$228.00ACONDICIONAMIENTO DEL LOCALCONCEPTOSU.M.CANTIDADP. UNITARIOCTO. TOTALTINACO/ROTOPLAS/1100 LTS.PIEZAS1$1,400.00$1,400.00ARENAVOLTEO1$1,200.00$1,200.00GRAVAVOLTEO1$1,350.00$1,350.00CEMENTOBULTOS10$210.00$2,100.00MANO DE OBRAJORNAL6$500.00$3,000.00CORTINA METALICA 2X2.5PIEZAS1$5,950.00$5,950.00SUBTOTAL$15,000.00
B. II. PROYECCION DE OPERACION00COSTOS DEL PROYECTOCOSTOSAOAOAOAOAOCONCEPTOSEMANA/MES/CICLO12345LOTE DE MERCANCIAS$27,963.24$1,342,235.66$1,476,459.22$1,624,105.15$1,786,515.66$1,965,167.23MANO DE OBRA$2,940.00$141,120.00$155,232.00$170,755.20$187,830.72$206,613.79FLETES$750.00$36,000.00$39,600.00$43,560.00$47,916.00$52,707.60PUBLICIDAD$600.00$600.00$660.00$726.00$798.60$878.46LUZ$800.00$4,800.00$5,280.00$5,808.00$6,388.80$7,027.68AGUA$50.00$600.00$660.00$726.00$798.60$878.46ABMINISTRACION$750.00$9,000.00$9,900.00$10,890.00$11,979.00$13,176.90RENOVACION DE LICENCIA$250.00$250.00$275.00$302.50$332.75$366.03INSUMOS$228.00$2,736.00$3,009.60$3,310.56$3,641.62$4,005.78TOTAL$34,331.24$1,537,341.66$1,691,075.82$1,860,183.41$2,046,201.75$2,250,821.92
C.I.I. PROYECCION DE INGRESOS0PROYECCION DE INGRESOSVOLUMENPRECIOVENTASAOAOAOAOAOCONCEPTOUNITARIOSEM/MES/CICLO1234550 KG AZUCAR ESTANDAR1112$132.00$6,336.00$6,969.60$7,666.56$8,433.22$9,276.5450 KG AZUCCAR REFINADA513$65.00$3,120.00$3,432.00$3,775.20$4,152.72$4,567.9910/1KG AZUCAR REFINADA613$78.00$3,744.00$4,118.40$4,530.24$4,983.26$5,481.5910/1KG AZUCAR ESTANDAR2512.5$312.50$15,000.00$16,500.00$18,150.00$19,965.00$21,961.5044KG HARINA DE TRIGO ALTA PROTEINA310$30.00$1,440.00$1,584.00$1,742.40$1,916.64$2,108.3044KG HARINA DE TRIGO ARTESANAL79$63.00$3,024.00$3,326.40$3,659.04$4,024.94$4,427.442/800G HARINA P/HOT CAKES PRONTO730$210.00$10,080.00$11,088.00$12,196.80$13,416.48$14,758.134/1KG HARINA DE TRIGO SAN BLAS1143$473.00$22,704.00$24,974.40$27,471.84$30,219.02$33,240.93NESCAFE CAF SOLUBLE REGULAR 300 GR585$425.00$20,400.00$22,440.00$24,684.00$27,152.40$29,867.64CAF GOURMET SOLUBLE DESCAFEINADO MM5120$600.00$28,800.00$31,680.00$34,848.00$38,332.80$42,166.08CAF DESCAFEINADO TOSTADO Y MOLIDO 1.25115$575.00$27,600.00$30,360.00$33,396.00$36,735.60$40,409.166/50GR NESCAFE CLASICO525$125.00$6,000.00$6,600.00$7,260.00$7,986.00$8,784.606/100 NESCAFE CAF SOLUBLE REGULAR640$240.00$11,520.00$12,672.00$13,939.20$15,333.12$16,866.43BC CAF REGULAR TOSTADO Y MOLIDO3145$435.00$20,880.00$22,968.00$25,264.80$27,791.28$30,570.411KG CAF SOLUBLE REGULAR BC3220$660.00$31,680.00$34,848.00$38,332.80$42,166.08$46,382.6912/1LT NUTRILECHE-PRODUCTO LACTEO714.5$101.50$4,872.00$5,359.20$5,895.12$6,484.63$7,133.1012/1L ALPURA DESLACTOSADA LIGHT817.5$140.00$6,720.00$7,392.00$8,131.20$8,944.32$9,838.7512/1L ALPURA ESPECIALIZADA (MUJER)917.5$157.50$7,560.00$8,316.00$9,147.60$10,062.36$11,068.6012/10 LECHE ESPECIAIZADA EXTRACALCIO517.5$87.50$4,200.00$4,620.00$5,082.00$5,590.20$6,149.2212/1L LALA DESLACTOSADA1117.5$192.50$9,240.00$10,164.00$11,180.40$12,298.44$13,528.2812/1 LECHE ALPURA SEMIDESCREMADA917$153.00$7,344.00$8,078.40$8,886.24$9,774.86$10,752.3512/1 LECHE LALA SEMIDESCREMADA1116.5$181.50$8,712.00$9,583.20$10,541.52$11,595.67$12,755.2412/1LT LECHE LALA ENTERA1017$170.00$8,160.00$8,976.00$9,873.60$10,860.96$11,947.0612/1 LT LECHE ALPURA SELECTA2517$425.00$20,400.00$22,440.00$24,684.00$27,152.40$29,867.6412/1LT LECHE LALA LIGTH2716.5$445.50$21,384.00$23,522.40$25,874.64$28,462.10$31,308.3112/1LT BC PRODUCTO LACTEO1512.5$187.50$9,000.00$9,900.00$10,890.00$11,979.00$13,176.901.6KG NIDO 1+5189$945.00$45,360.00$49,896.00$54,885.60$60,374.16$66,411.581.6KG NIDO 3+4170$680.00$32,640.00$35,904.00$39,494.40$43,443.84$47,788.221.8KG LECHE EN POLVO ALPURA KIDS3180$540.00$25,920.00$28,512.00$31,363.20$34,499.52$37,949.471.8KG LECHE ENTERA EN POLVO ALPURA3170$510.00$24,480.00$26,928.00$29,620.80$32,582.88$35,841.171.8KG SVELTY DIGEST3189$567.00$27,216.00$29,937.60$32,931.36$36,224.50$39,846.954/380 GR NIDO FORTIFICADA87$56.00$2,688.00$2,956.80$3,252.48$3,577.73$3,935.506/1LT LECHE DE SOYA OGANICA MM1018$180.00$8,640.00$9,504.00$10,454.40$11,499.84$12,649.8227/250ML ALPURA SABOR CHOCOLATE108$80.00$3,840.00$4,224.00$4,646.40$5,111.04$5,622.1416/190 ML NESQUIK SABOR CHOCOLATE67.5$45.00$2,160.00$2,376.00$2,613.60$2,874.96$3,162.4627/236 ML HERSHEYS SABOR CHOCOLATE68$48.00$2,304.00$2,534.40$2,787.84$3,066.62$3,373.2912/946 ML ADES NATURAL BEBIDA DE SOYA520$100.00$4,800.00$5,280.00$5,808.00$6,388.80$7,027.688/397GR LA LECHERA LECHE CONDENSADA518.5$92.50$4,440.00$4,884.00$5,372.40$5,909.64$6,500.608/378 GR LECHE EVAPORADA CARNETION513$65.00$3,120.00$3,432.00$3,775.20$4,152.72$4,567.9925/378 GR CARNATION LECHE EVAPORADA1213.5$162.00$7,776.00$8,553.60$9,408.96$10,349.86$11,384.8424/397 LECHE CONDENSADA LA LECHERA518$90.00$4,320.00$4,752.00$5,227.20$5,749.92$6,324.918/225 GR NESTLE MEDIA CREMA710.5$73.50$3,528.00$3,880.80$4,268.88$4,695.77$5,165.3410/240 ML YOGURTH DE FRESA BEBIDA LALA346$204.00$9,792.00$10,771.20$11,848.32$13,033.15$14,336.4712/90 GR CHOCOLATE DE MESA ABUELITA610$60.00$2,880.00$3,168.00$3,484.80$3,833.28$4,216.6140/22 GR CHOCOMILK CHOCOLATE EN POLVO113.5$38.50$1,848.00$2,032.80$2,236.08$2,459.69$2,705.665/375 GR CHOCOMILK CHOCOLATE EN POLVO527$135.00$6,480.00$7,128.00$7,840.80$8,624.88$9,487.3780/170 GALLETAS MARIAS224.5$99.00$4,752.00$5,227.20$5,749.92$6,324.91$6,957.40EMPERADOR SURTIDO585$425.00$20,400.00$22,440.00$24,684.00$27,152.40$29,867.6414 PZAS PAKETINES GAMESA268.5$221.00$10,608.00$11,668.80$12,835.68$14,119.25$15,531.17PEKEPAKES GAMESA 1.17 KG478$312.00$14,976.00$16,473.60$18,120.96$19,933.06$21,926.36MARIAS MINI ROLLOS 25/60 GRS174$68.00$3,264.00$3,590.40$3,949.44$4,344.38$4,778.82SURTIDO RICO MEGA PACK375$225.00$10,800.00$11,880.00$13,068.00$14,374.80$15,812.2812/1LT ACEITE COMESTIBLE 123628$168.00$8,064.00$8,870.40$9,757.44$10,733.18$11,806.5024/500 ML ACEITE COMESTIBLE CORONA2211$242.00$11,616.00$12,777.60$14,055.36$15,460.90$17,006.9912/1 ACEITE COMESTIBLE BC520$100.00$4,800.00$5,280.00$5,808.00$6,388.80$7,027.6812/1 ACEITE COMESTIBLE MARAVI524$120.00$5,760.00$6,336.00$6,969.60$7,666.56$8,433.223/946 ML ACEITE DE SOY NUTRIOLI431$124.00$5,952.00$6,547.20$7,201.92$7,922.11$8,714.323/945 ML ACEITE CAPULLO529$145.00$6,960.00$7,656.00$8,421.60$9,263.76$10,190.143/1 LT ACEITE PATRONA TRIPACK724$168.00$8,064.00$8,870.40$9,757.44$10,733.18$11,806.502/946 ACEITE OLEICO645$270.00$12,960.00$14,256.00$15,681.60$17,249.76$18,974.7450/2 PZ KNORR CUBOS163$48.00$2,304.00$2,534.40$2,787.84$3,066.62$3,373.293/24 KNORR CUBOS CONSOME DE POLLO830$240.00$11,520.00$12,672.00$13,939.20$15,333.12$16,866.431KG KNORR SUIZA CALDO DE POLLO485$340.00$16,320.00$17,952.00$19,747.20$21,721.92$23,894.1110/8 PZ KNORR CUBOS CALDO DE POLLO1711$187.00$8,976.00$9,873.60$10,860.96$11,947.06$13,141.763/12 KNORR TOMATE CONSOME1416$224.00$10,752.00$11,827.20$13,009.92$14,310.91$15,742.006/1 KG ARROZ SUPER EXTRA SCHETTINO4214$588.00$28,224.00$31,046.40$34,151.04$37,566.14$41,322.766/1 KG ARROZ SUPER EXTRA LA MERCED3413$442.00$21,216.00$23,337.60$25,671.36$28,238.50$31,062.355/1 FRIJOL NEGRO SCHETTINO5117$867.00$41,616.00$45,777.60$50,355.36$55,390.90$60,929.9912 PZS SOPA INSTANTANEA MARUCHAN POLLO256$150.00$7,200.00$7,920.00$8,712.00$9,583.20$10,541.5212 PZ SOPA INSTANTANEA MARUCHAN HABANERO116$66.00$3,168.00$3,484.80$3,833.28$4,216.61$4,638.2712 PZ SOPA INSTANTANEA MARUCHAN CAMARON86$48.00$2,304.00$2,534.40$2,787.84$3,066.62$3,373.2912 PZ SOPA INSTANTANEA MARUCHAN CAMARON C/CHILE116$66.00$3,168.00$3,484.80$3,833.28$4,216.61$4,638.273.4 KG MAYONESA-LIMON MCCORMICK8123$984.00$47,232.00$51,955.20$57,150.72$62,865.79$69,152.371730 GR MAYONESA C/LIMON MCCORMICK496$384.00$18,432.00$20,275.20$22,302.72$24,532.99$26,986.296/190 GR MAYONESA CON LIMON MCCORMICK814$112.00$5,376.00$5,913.60$6,504.96$7,155.46$7,871.003/390 GR MAYONESA CON LIMON MCCORMICK727$189.00$9,072.00$9,979.20$10,977.12$12,074.83$13,282.326/425 GR SARDINA OVAL TOMATE GUAYMEX1022$220.00$10,560.00$11,616.00$12,777.60$14,055.36$15,460.9048/140 GR ATUN ACEITE DOLORES3112$372.00$17,856.00$19,641.60$21,605.76$23,766.34$26,142.9748/140 GR ATUN EN AGUA DOLORES1112$132.00$6,336.00$6,969.60$7,666.56$8,433.22$9,276.548/140 ATUN EN ACEITE TUNY2411.5$276.00$13,248.00$14,572.80$16,030.08$17,633.09$19,396.408/PACK ENSALADA ATUN TUNY LIGHT1114$154.00$7,392.00$8,131.20$8,944.32$9,838.75$10,822.633/380 GR RAJAS VERDES LA COSTEA512$60.00$2,880.00$3,168.00$3,484.80$3,833.28$4,216.613/380 JALAPEOS LA COSTEA912$108.00$5,184.00$5,702.40$6,272.64$6,899.90$7,589.896/220 RAJAS VERDES LA COSTEA188$144.00$6,912.00$7,603.20$8,363.52$9,199.87$10,119.8610/105 RAJAS VERDES LA COSTEA95$45.00$2,160.00$2,376.00$2,613.60$2,874.96$3,162.466/220G CHIPOTLES LA COSTEA1114$154.00$7,392.00$8,131.20$8,944.32$9,838.75$10,822.6310/105 CHIPOTLES LA COSTEA627$434.00$20,832.00$22,915.20$25,206.72$27,727.39$30,500.136/370 MML SALSA PICANTE VALENTINA338.5$280.50$13,464.00$14,810.40$16,291.44$17,920.58$19,712.6412 PZS VELA SEMANARIA ECOLOGICA824$192.00$9,216.00$10,137.60$11,151.36$12,266.50$13,493.1512 PZS VELA 3.5 DIAS ECOLOGICA1513$195.00$9,360.00$10,296.00$11,325.60$12,458.16$13,703.988 PZS VELADORA #15635$210.00$10,080.00$11,088.00$12,196.80$13,416.48$14,758.1320/500 FOCA DETERGENTE EN POLVO6714$938.00$45,024.00$49,526.40$54,479.04$59,926.94$65,919.6440/250 FOCA DETERGENTE EN POLVO35$7.00$245.00$11,760.00$12,936.00$14,229.60$15,652.56$17,217.8210/1 KG FOCA DETERGENTE EN POLVO6$29.00$174.00$8,352.00$9,187.20$10,105.92$11,116.51$12,228.1620/500 BLANCA NIEVES DETERGENTE EN POLVO19$13.50$256.50$12,312.00$13,543.20$14,897.52$16,387.27$18,026.0040/250 BLANCA NIEVES DETERGENTE EN POLVO27$6.50$175.50$8,424.00$9,266.40$10,193.04$11,212.34$12,333.5810/1 KG BLANCA NIEVES DETERGENTE EN POLVO17$26.00$442.00$21,216.00$23,337.60$25,671.36$28,238.50$31,062.3525/400GR JABON ZOTE ROSA8$12.00$96.00$4,608.00$5,068.80$5,575.68$6,133.25$6,746.5750/200 GR ZOTE ROSA40$6.50$260.00$12,480.00$13,728.00$15,100.80$16,610.88$18,271.978/950ML CLORALEX BLANQUEADOR10$10.50$105.00$5,040.00$5,544.00$6,098.40$6,708.24$7,379.0615/500 ML CLORALEX BLANQUEADOR12$6.00$72.00$3,456.00$3,801.60$4,181.76$4,599.94$5,059.938/1 LT PINOL LIMPIADOR11$20.00$220.00$10,560.00$11,616.00$12,777.60$14,055.36$15,460.9015/500 ML PINOL LIMPIADPR7$12.00$84.00$4,032.00$4,435.20$4,878.72$5,366.59$5,903.258/850 ML ENSUEO SUAVIZANTE6$15.00$90.00$4,320.00$4,752.00$5,227.20$5,749.92$6,324.919/1 KG ARIEL DETERGENTE EN POLVO3$33.00$99.00$4,752.00$5,227.20$5,749.92$6,324.91$6,957.4024/500 ARIEL DETERGENTE EN POLVO11$17.00$187.00$8,976.00$9,873.60$10,860.96$11,947.06$13,141.7648/250 ARIEL DETERGENTE EN POLVO112$9.50$114.00$5,472.00$6,019.20$6,621.12$7,283.23$8,011.5624/500 ARIEL DOWNY6$20.00$120.00$5,760.00$6,336.00$6,969.60$7,666.56$8,433.229/1 KG ACE REGULAR DETERGENTE EN POLVO5$29.00$145.00$6,960.00$7,656.00$8,421.60$9,263.76$10,190.1424/500 GR ACE DETERGENTE EN POLVO10$15.00$150.00$7,200.00$7,920.00$8,712.00$9,583.20$10,541.5248/250G ACE REGULAR DETERGENTE EN POLVO20$8.50$170.00$8,160.00$8,976.00$9,873.60$10,860.96$11,947.0624/500 ACE NATURALS DETERGENTE EN POLVO11$15.00$165.00$7,920.00$8,712.00$9,583.20$10,541.52$11,595.6710/1 KG ROMA DETERGENTE EN POLVO4$28.00$112.00$5,376.00$5,913.60$6,504.96$7,155.46$7,871.008/1.2 KG MAESTRO LIMPIO DETERGENTE EN POLVO2$22.50$45.00$2,160.00$2,376.00$2,613.60$2,874.96$3,162.4624/500 SALVO LIMON LAVATRASTES EN POLVO27$12.50$337.50$16,200.00$17,820.00$19,602.00$21,562.20$23,718.4224/600 COCA COLA PET59$9.00$531.00$25,488.00$28,036.80$30,840.48$33,924.53$37,316.9812/355 COCA COLA LATA58$8.00$464.00$22,272.00$24,499.20$26,949.12$29,644.03$32,608.4424/600 COCA COLA LIGHT PET34$9.50$323.00$15,504.00$17,054.40$18,759.84$20,635.82$22,699.4124/237ML COCA COLA47$6.00$282.00$13,536.00$14,889.60$16,378.56$18,016.42$19,818.0612/335 ML COCA COLA LIGHT LATA31$8.50$263.50$12,648.00$13,912.80$15,304.08$16,834.49$18,517.9412/600 YOLIPET52$8.00$416.00$19,968.00$21,964.80$24,161.28$26,577.41$29,235.1524/355 ML YOLI LATA9$7.00$63.00$3,024.00$3,326.40$3,659.04$4,024.94$4,427.444/2LT REFRESCO SABORES VARIOS8$19.00$152.00$7,296.00$8,025.60$8,828.16$9,710.98$10,682.0715/600 MULTI SABBOR PEPSI, MIRINDA, MANZANA, 7UP58$8.00$464.00$22,272.00$24,499.20$26,949.12$29,644.03$32,608.4415/400 MILTI SABOR PEPSI, MIRINDA, MANZANA 7UP54$6.00$324.00$15,552.00$17,107.20$18,817.92$20,699.71$22,769.6824/355 ML ,MULTISABOR PEPSI, MIRINDA, MANZANA, 7UP46$6.00$276.00$13,248.00$14,572.80$16,030.08$17,633.09$19,396.408/2 LT PEAFIEL SABORES SURTIDOS7$18.00$126.00$6,048.00$6,652.80$7,318.08$8,049.89$8,854.8812/600 PEAFIEL SABORES SURTIDOS61$7.00$427.00$20,496.00$22,545.60$24,800.16$27,280.18$30,008.196/3 JARRITOS SABORES SURTIDOS13$19.00$247.00$11,856.00$13,041.60$14,345.76$15,780.34$17,358.378/2LT SQUIRT11$20.00$220.00$10,560.00$11,616.00$12,777.60$14,055.36$15,460.9012/330 ML PUREZA VITAL SABORES SURTIDOS15$5.00$75.00$3,600.00$3,960.00$4,356.00$4,791.60$5,270.7624/330 ML KIDS BONAFON SABORES SURTIDOS31$5.00$155.00$7,440.00$8,184.00$9,002.40$9,902.64$10,892.9024/500ML AGUA LEVITE SABORES SURTIDOS19$7.00$133.00$6,384.00$7,022.40$7,724.64$8,497.10$9,346.8124/500ML BONAFON CON JUGO SABORES SURTIDO19$7.50$142.50$6,840.00$7,524.00$8,276.40$9,104.04$10,014.4412/1.5LT BONAFON CON JUGO SABORES SURTIDOS10$13.00$130.00$6,240.00$6,864.00$7,550.40$8,305.44$9,135.986/3LT BIG CITRUS SABOR NARANJA6$22.00$132.00$6,336.00$6,969.60$7,666.56$8,433.22$9,276.5424/250 PAU PAU SABORES SURTIDOS19$3.00$57.00$2,736.00$3,009.60$3,310.56$3,641.62$4,005.7824/250ML FRUTSI SABORES SURTIDOS33$3.50$115.50$5,544.00$6,098.40$6,708.24$7,379.06$8,116.9724/473ML BEBERE NARANJA30$5.00$150.00$7,200.00$7,920.00$8,712.00$9,583.20$10,541.5212/1.5LT AGUA BONAFONT45$8.00$360.00$17,280.00$19,008.00$20,908.80$22,999.68$25,299.6512/1LT AGUA BONAFONT34$8.00$272.00$13,056.00$14,361.60$15,797.76$17,377.54$19,115.2924/600ML AGUA BONAFONT18$6.00$108.00$5,184.00$5,702.40$6,272.64$6,899.90$7,589.8924/250 ML AGUA BONAFONT11$4.00$44.00$2,112.00$2,323.20$2,555.52$2,811.07$3,092.18MM 12/1.5 L AGUA19$6.00$114.00$5,472.00$6,019.20$6,621.12$7,283.23$8,011.56MM12/1L AGUA26$7.00$182.00$8,736.00$9,609.60$10,570.56$11,627.62$12,790.38MM 24/500 LT AGUA26$4.00$104.00$4,992.00$5,491.20$6,040.32$6,644.35$7,308.79RG 24/250 ML BEBIDA SABORIZADA29$3.00$87.00$4,176.00$4,593.60$5,052.96$5,558.26$6,114.080.0total$3,974.00$33,677.00$1,616,496.00$1,778,145.60$1,955,960.16$2,151,556.18$2,366,711.79
C. III.ESTADO DE RESULTADOS00CONCEPTOSAO 1AO 2AO 3AO 4AO 5( + ) VENTAS$1,616,496.00$1,778,145.60$1,955,960.16$2,151,556.18$2,366,711.79COSTOS FIJOS$158,506.00$174,356.60$191,792.26$210,971.49$232,068.63COSTOS VARIABLES$1,378,835.66$1,516,719.22$1,668,391.15$1,835,230.26$2,018,753.29( - ) COSTOS TOTALES$1,537,341.66$1,691,075.82$1,860,183.41$2,046,201.75$2,250,821.92( = ) UTILIDAD BRUTA$79,154.34$87,069.78$95,776.75$105,354.43$115,889.87( - ) DEPRECIACION$9,387.23$10,325.95$11,358.54$12,494.40$13,743.84( = ) UTILIDAD ANTES DE IMPUESTOS$69,767.12$76,743.83$84,418.21$92,860.03$102,146.04( - ) IMPUESTOS$11,162.74$12,279.01$13,506.91$14,857.61$16,343.37( = ) UTILIDAD DEL EJERCICIO$58,604.38$64,464.82$70,911.30$78,002.43$85,802.67COSTOS DE DEPRECIACIONESACTIVO FIJOVALOR ORIGINALTASAAOSDEP ANUALVALOR RESCATELOCAL COMERCIAL$45,000.0010%$5.00$4,500.00$22,500.00ANAQUELES DE ACERO INOXIDABLE$12,000.0010%$5.00$1,200.00$6,000.00MOSTRADOR DE MADERA$5,783.7310%$5.00$578.37$2,891.87VITRINA EXIBIDORA$27,800.0010%$5.00$2,780.00$13,900.00BASCULA$3,288.5310%$5.00$328.85$1,644.27refrigerador$21,000.00TOTAL$114,872.26$9,387.23$46,936.13
DOCUMENTO REFLEJADO A 5 AOS, CONSIDERANDO LA FORMULA ESTABLECIDA.BIENES DURADEROS PARA EL FUNCIONAMIENTO DEL PROYECTO
C.V FLUJO DE EFECTIVO00CONCEPTOS / AOAO 0AO 1AO 2AO 3AO 4AO 5( + ) VENTAS$1,616,496.00$1,778,145.60$1,955,960.16$2,151,556.18$2,366,711.79( + ) VALOR DE RESCATE0.00.0$46,936.13( = ) INGRESOS TOTALES$1,616,496.00$1,778,145.60$1,955,960.16$2,151,556.18$2,413,647.92COSTOS FIJOS$158,506.00$174,356.60$191,792.26$210,971.49$232,068.63COSTOS VARIABLES$1,378,835.66$1,516,719.22$1,668,391.15$1,835,230.26$2,018,753.29( = ) COSTOS TOTALES$1,537,341.66$1,691,075.82$1,860,183.41$2,046,201.75$2,250,821.92COMPRA ACTIVO FIJO$114,872.26COMPRA ACTIVO DIFERIDO$45,750.00COMPRA CAPITAL DE TRABAJO$93,745.74( = ) SALDO FINAL$254,368.00$79,154.34$87,069.78$95,776.75$105,354.43$162,826.00
DOCUMENTO QUE MUESTRA ENTRADAS Y SALIDAS DE EFECTIVO EN UN PERIODO DETERMINADO.
D.I. PUNTO DE EQUILIBRIO00CONCEPTOS / AOAO 1AO 2AO 3AO 4AO 5VENTAS$1,616,496.00$1,778,145.60$1,955,960.16$2,151,556.18$2,413,647.92COSTOS FIJOS$158,506.00$174,356.60$191,792.26$210,971.49$232,068.63COSTOS VARIABLES$1,378,835.66$1,516,719.22$1,668,391.15$1,835,230.26$2,018,753.29COSTOS TOTALES$1,537,341.66$1,691,075.82$1,860,183.41$2,046,201.75$2,250,821.92PUNTO DE EQUILIBRIO $$1,078,111.36$1,185,922.50$1,304,514.75$1,434,966.22$1,418,434.00PUNTO DE EQUILIBRIO %$0.67$0.67$0.67$0.67$0.59INTERPRETACIONel punto de equilibrio establece las ventas minimas que el negocio debe vender para no perder ni ganary en el presente la empreza debe vender la cantidad minima de 1078111.36 para no tener perdidas ni ganancias___________________________________________________________________________________________________________________
CALCULAR EL PUNTO DE EQUILIBRIO EN PORCENTAJE DE VENTAS CON LA FORMULA ESTUDIADA.
D. II VAN.TRI. Y. BC00TASA DE ACTUALIZACION10%AOINGRESOSCOSTOSFLUJO DETASAINGRESOSEGRESOSEFECTIVO(1+t)-nACTUALIZADOSACTUALIZADOS0$254,368.00-$254,368.00$1.000.02543681$1,616,496.00$1,537,341.66$79,154.34$0.89$1,436,885.331366525.917866672$1,778,145.60$1,691,075.82$87,069.78$0.25$444,536.40422768.955843$1,955,960.16$1,860,183.41$95,776.75$0.13$244,495.02232522.9257124$2,151,556.18$2,046,201.75$105,354.43$1.00$2,151,556.182046201.74626565$2,413,647.92$2,250,821.92$162,826.00$1.00$2,413,647.922250821.92089216TOTAL$9,915,805.86$9,639,992.55$275,813.31$6,691,120.856573209.46657643VAN$117,911.39TIR27%B/C$1.02CRITERIO DE DECISINEl presente proyecto se encuentra dentro de los rangos aceptables para los programas fappa y promete con unauna VAN mayor a cero, y una TIR mayor al diez porciento, lo cual no arroja una relacion beneficio costo superior a uno________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
VALOR ACTUAL NETOTASA INTERNA DE RETORNORELACION BENEFICIO-COSTO
D.III ECA00De acuerdo a reglas de Operacin 10% como minimo y de hasta el 50% de lo solicitadoPORCENTAJEAOPAGOSMONTO DE AHORRO12345
Recommended