Flujo De Caja Panaderia

7.1. FLUJO DE CAJA MENSUAL DE LA PANADERIA

Flujo de caja para Proyecto de Panadería

(expresado en dólares)

Detalle sep-01 oct-01 nov-01 dic-01 ene-02 feb-02 mar-02 abr-02 may-02 jun-02 jul-02 ago-02 sep-02 oct-02 nov-02 dic-02 ene-03 feb-03 mar-03 abr-03 may-03 jun-03 Total

Ventas pan corriente 1,920.90 2,305.07 2,305.07 2,301.64 2,298.21 2,294.80 2,291.39 2,288.00 2,284.62 2,281.24 2,277.88 2,274.52 2,271.18 2,267.84 2,264.52 2,261.20 2,257.89 2,254.60 2,251.31 2,248.03 2,244.77 47,444.69

Ventas pan bagget 931.34 931.34 931.34 929.96 928.57 927.19 925.82 924.44 923.08 921.71 920.35 919.00 917.65 916.30 914.96 913.62 912.28 910.95 909.62 908.30 906.98 19,324.79

Ventas Queque 3,104.48 3,104.48 3,104.48 3,099.85 3,095.24 3,090.64 3,086.05 3,081.48 3,076.92 3,072.38 3,067.85 3,063.33 3,058.82 3,054.33 3,049.85 3,045.39 3,040.94 3,036.50 3,032.07 3,027.66 3,023.26 64,415.98

Ventas Rollo/Queso 2,173.13 2,173.13 2,173.13 2,169.90 2,166.67 2,163.45 2,160.24 2,157.04 2,153.85 2,150.66 2,147.49 2,144.33 2,141.18 2,138.03 2,134.90 2,131.77 2,128.65 2,125.55 2,122.45 2,119.36 2,116.28 45,091.19

Total Ingresos 8,129.85 8,514.03 8,514.03 8,501.34 8,488.69 8,476.08 8,463.50 8,450.96 8,438.46 8,426.00 8,413.57 8,401.18 8,388.82 8,376.51 8,364.22 8,351.98 8,339.77 8,327.59 8,315.45 8,303.35 8,291.28 176,276.65

Costo Prod. Pan Corr 1,214.72 1,214.72 1,214.72 1,214.72 1,214.72 1,214.72 1,214.72 1,214.72 1,214.72 1,214.72 1,214.72 1,214.72 1,214.72 1,214.72 1,214.72 1,214.72 1,214.72 1,214.72 1,214.72 1,214.72 1,214.72 25,509.12

Costo pan largo 477.10 477.10 477.10 477.10 477.10 477.10 477.10 477.10 477.10 477.10 477.10 477.10 477.10 477.10 477.10 477.10 477.10 477.10 477.10 477.10 477.10 10,019.10

Costo Prod. Queque 1,040.00 1,040.00 1,040.00 1,040.00 1,040.00 1,040.00 1,040.00 1,040.00 1,040.00 1,040.00 1,040.00 1,040.00 1,040.00 1,040.00 1,040.00 1,040.00 1,040.00 1,040.00 1,040.00 1,040.00 1,040.00 21,840.00

Costo Prod Rollo 728.00 728.00 728.00 728.00 728.00 728.00 728.00 728.00 728.00 728.00 728.00 728.00 728.00 728.00 728.00 728.00 728.00 728.00 728.00 728.00 728.00 15,288.00

Alquiler 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 5,250.00

Servicios 100.00 100.00 100.00 201.19 200.89 200.59 200.30 200.00 199.70 199.41 199.12 198.82 198.53 198.24 197.95 197.66 197.37 197.08 196.79 196.51 196.22 3,876.37

Sueldos 400.00 400.00 500.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 1,200.00 600.00 600.00 600.00 600.00 600.00 600.00 12,700.00

Sueldo Administrador 700.00 700.00 875.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 2,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 21,275.00

Impuestos Transacc 0.00 243.90 255.42 255.42 255.04 254.66 254.28 253.91 253.53 253.15 252.78 252.41 251.66 251.30 250.93 250.56 250.19 249.83 249.46 249.10 248.74 5,036.26

Impuesto IVA 0.00 1,056.88 1,106.82 1,106.82 1,105.17 1,103.53 1,101.89 1,100.26 1,098.63 1,097.00 1,095.38 1,093.76 1,092.15 1,090.55 1,088.95 1,087.35 1,085.76 1,084.17 1,082.59 1,081.01 1,079.44 21,838.10

Inversión en equipos 10,225.00

Inversión Diferida 1,485.00

Inversión en local 5,000.00

Inv.Cap.de Trabajo 2,769.62

Total Gastos -19,479.62 4,909.82 6,210.60 6,547.06 6,873.26 6,870.93 6,868.60 6,866.29 6,863.98 6,861.68 6,859.38 6,857.09 6,854.81 6,852.17 6,849.90 8,447.64 6,845.39 6,843.14 6,840.90 6,838.66 6,836.44 6,834.21 142,631.95

Efectivo

...