flujodecaja

Flujo de caja
Cálculo de ingresos por ventas:

ENE
FEB
MAR
ABR
MAY
JUN
Cant. vendidaSem. 1
1,025
1,100
1,000
1,050
1,300
1,300
Cant. vendidaSem. 2
1,100
1,100
1,200
1,000
1,2501,200
Cant. vendidaSem. 3
1,250
1,200
1,050
1,200
1,100
1,250
Cant. vendidaSem. 4
1,300
1,300
1,000
1,300
1,000
1,300
Cant. vendida x Mes
4,675
4,700
4,250
4,500
4,650
5,050Precio Venta
S/.5
S/.5
S/.5
S/.5
S/.5
S/.5
Ingreso por ventas
S/.23,375
S/.23,500
S/.21,250
S/.22,500
S/.23,250
S/.25,250



JUL
AGO
SET
OCT
NOV
DIC
Cant. vendidaSem. 1
1,2251,230
1,220
1,300
1,320
1,330
Cant. vendidaSem. 2
1,300
1,260
1,300
1,350
1,340
1,360
Cant. vendidaSem. 3
1,250
1,350
1,250
1,320
1,330
1,370
Cant. vendidaSem. 4
1,245
1,300
1,3201,330
1,340
1,390
Cant. vendida x Mes
5,020
5,140
5,090
5,300
5,330
5,450
Precio Venta
S/.6
S/.6
S/.6
S/.6
S/.5
S/.5
Ingreso por ventas
S/.30,120
S/.30,840
S/.30,540
S/.31,800S/.26,650
S/.27,250


Cálculo de los egresos totales en efectivo

ENE
FEB
MAR
ABR
MAYO
JUNIO
Insumos
S/.3,084.4
S/.3,084.4
S/.3,084.4
S/.3,084.4
S/.3,084.4
S/.3,084.4
SueldosS/.10,150
S/.10,150
S/.8,550
S/.8,550
S/.8,550
S/.8,550
Publicidad
S/.1,500
S/.1,500
S/.0
S/.0
S/.0
S/.0
Alquiler
S/.3,300
S/.3,300
S/.3,300
S/.3,300
S/.3,300
S/.3,300
Servicios BásicosS/.850
S/.850
S/.850
S/.850
S/.850
S/.850
Mantenimiento
S/.0
S/.0
S/.2,000
S/.0
S/.0
S/.2,000
Gratificaciones
S/.0
S/.0
S/.0
S/.0
S/.0
S/.0
Egreso total
S/.18,884.4
S/.18,884.4S/.17,784.4
S/.15,784.4
S/.15,784.4
S/.17,784.4



JUL
AGO
SET
OCT
NOV
DIC
Insumos
S/.3,084.4
S/.3,084.4
S/.3,084.4
S/.3,084.4
S/.3,084.4
S/.3,084.4
Sueldos
S/.10,150
S/.8,850S/.8,550
S/.10,150
S/.8,550
S/.10,150
Publicidad
S/.700
S/.0
S/.0
S/.1,000
S/.0
S/.700
Alquiler
S/.3,300
S/.3,300
S/.3,300
S/.3,300
S/.3,300
S/.3,300
Servicios Básicos
S/.850...