ANALISISFIN

10
n Periodo (semanas) Ingresos 0 1-Aug 0 1 8-Aug $25,400.00 2 15-Aug $28,000.00 3 22-Aug $27,280.00 4 29-Aug $26,430.00 5 5-Sep $25,366.00 6 12-Sep $24,400.00 7 19-Sep $26,004.00 8 26-Sep $24,789.00 9 3-Oct $25,480.00 10 10-Oct $23,655.00 11 17-Oct $25,678.00 12 31-Oct $27,450.00 n 1 Periodo (SEMANAL) 1-Aug 8-Aug INGRESOS TOTALES $25,400.00 Mano de obra -$ 3,250.00 Materias primas (comida) -$ 2,875.00 Electricidad $ - Gas $ - Transporte -$ 500.00 Agua $ - Telefono -$ 60.00 Renta -$ 1,500.00 Prestamos -$ 2,100.00 Proveedores -$ 8,000.00 EGRESOS TOTALES -$ 30,000.00 -$18,285.00 41852 41859 41866 41873 41880 41887 41894 41901 41908 41915 41922 4192 0 1 2 3 4 5 6 7 8 9 10 11 -$30,000.00 -$25,000.00 -$20,000.00 -$15,000.00 -$10,000.00 -$5,000.00 $- $5,000.00 $10,000.00 $15,000.00 Flujo neto Flujo neto

description

analisis de una cafeteria

Transcript of ANALISISFIN

Hoja1nPeriodo (semanas)IngresosEgresosFlujo neto01-Aug0-$30,000.00-$30,000.0018-Aug$25,400.00-$18,285.00$7,115.00215-Aug$28,000.00-$17,530.00$10,470.00322-Aug$27,280.00-$16,425.00$10,855.00429-Aug$26,430.00-$17,940.00$8,490.0055-Sep$25,366.00-$16,670.00$8,696.00612-Sep$24,400.00-$16,960.00$7,440.00719-Sep$26,004.00-$17,656.00$8,348.00826-Sep$24,789.00-$19,614.00$5,175.0093-Oct$25,480.00-$17,289.00$8,191.001010-Oct$23,655.00-$17,834.00$5,821.001117-Oct$25,678.00-$18,065.00$7,613.001231-Oct$27,450.00-$17,748.00$9,702.00n123456789101112Periodo (SEMANAL)1-Aug8-Aug15-Aug22-Aug29-Aug5-Sep12-Sep19-Sep26-Sep3-Oct10-Oct17-Oct31-OctINGRESOS TOTALES$25,400.00$28,000.00$27,280.00$26,430.00$25,366.00$24,400.00$26,004.00$24,789.00$25,480.00$23,655.00$25,678.00$27,450.00Mano de obra-$3,250.00-$3,250.00-$3,250.00-$3,250.00-$3,250.00-$3,250.00-$3,250.00-$3,250.00-$3,250.00-$3,250.00-$3,250.00-$3,250.00Materias primas (comida)-$2,875.00-$2,560.00-$2,100.00-$2,150.00-$1,860.00-$1,915.00-$2,356.00-$2,524.00-$1,844.00-$2,744.00-$2,755.00-$2,323.00Electricidad0.00.00.00.0--$1,500.00Gas0.00.0-$435.000.00.0-$435.000.00.0-$435.000.00.0-$435.00Transporte-$500.00-$500.00-$500.00-$500.00-$500.00-$500.00-$500.00-$500.00-$500.00-$500.00-$500.00-$500.00Agua0.00.00.0-$180.000.00.00.0-$180.000.00.00.0-$180.00Telefono-$60.00-$60.00-$60.00-$60.00-$60.00-$60.00-$60.00-$60.00-$60.00-$60.00-$60.00-$60.00Renta-$1,500.00-$1,500.00-$1,500.00-$1,500.00-$1,500.00-$1,500.00-$1,500.00-$1,500.00-$1,500.00-$1,500.00-$1,500.00-$1,500.00Prestamos-$2,100.00-$2,100.00-$2,100.00-$2,100.00-$2,100.00-$2,100.00-$2,100.00-$2,100.00-$2,100.00-$2,100.00-$2,100.00-$2,100.00Proveedores-$8,000.00-$7,560.00-$6,480.00-$8,200.00-$7,400.00-$7,200.00-$7,890.00-$8,000.00-$7,600.00-$7,680.00-$7,900.00-$7,400.00EGRESOS TOTALES-$30,000.00-$18,285.00-$17,530.00-$16,425.00-$17,940.00-$16,670.00-$16,960.00-$17,656.00-$19,614.00-$17,289.00-$17,834.00-$18,065.00-$17,748.00

Hoja2PersonalCantidadSueldo por jornadaSueldo por semanaCocinera1$200.00$1,000.00Ayudantes de cocina2$150.00$750.00Vendedores2$150.00$750.00Limpieza1$150.00$750.00TOTAL6$650.00$3,250.00

Hoja3AoABB-A0-6150-6678-5281 al 8-3450-289655482767.5-2537.64-5305.14-6832.5-12111.64-5279.14Vpi-826.963-674.544-537.95-416.216-210.758-124.379-47.311021.031181.312181.9614

Hoja40.1139AoDtL.R.AoDtSD.066780066781517.5456160.4551760.62425917.37582517.5455642.912673.989103625243.386696383517.5455125.3653597.22174471774646.16495166234517.5454607.824529.19818799434116.9667636685517.5454090.2755468.92251438183648.04424928626517.5453572.736415.51223999373232.53200929257517.5453055.1857368.18539585842864.34661343418517.5452537.648326.24907927012538.0975341639AoDtSDD.0066782537.6411669.55008.521252.1253756.3753939.093752817.281254704.32031252112.96093755528.2402343751584.7207031256396.18017578121188.54052734387297.1351318359891.40539550788222.851348877668.5540466309AoDtSMARC00667811669.55008.521252.1253756.3753939.093752817.281254704.32031252112.96093755528.2402343751584.7207031256396.18017578121188.54052734387297.1351318359891.40539550788222.851348877668.5540466309