Upload
cruz-vargas
View
217
Download
0
Embed Size (px)
Citation preview
7/27/2019 PROYECTO ECOLODGE
1/50
EQUIPOS CANTIDAD MEDIDAPRECIO
UNITARIOPRECIO TOTAL
CONGELADORA 2 UNIDADES 1,399.00S/. 2,798.00S/.
FRIGIDER 2 UNIDADES 1,199.00S/. 2,398.00S/.JUEGO DE OLLAS 3 JUEGOS 300.00S/. 900.00S/.
HORNO MICROONDAS 2 UNIDADES 360.00S/. 720.00S/.
UTENSILIOS 6 DOCENAS 110.00S/. 660.00S/.
JUEGO DE PLATOS 5 DOCENAS 45.00S/. 225.00S/.
JUEGO DE TASAS 5 DOCENAS 32.00S/. 160.00S/.
JUEGO DE MESAS 20 UNIDADES 120.00S/. 2,400.00S/.
JUEGO DE SILLAS 90 UNIDADES 30.00S/. 2,700.00S/.
COLADORES 5 UNIDADES 8.00S/. 40.00S/.
CRISTALERIA 4 DOCENAS 50.00S/. 200.00S/.
TABLA DE PICADO 5 UNIDADES 25.00S/. 125.00S/.CARRITOS 2 UNIDADES 120.00S/. 240.00S/.
PORTA SERVILLETAS 25 UNIDADES 5.00S/. 125.00S/.
LICUADORA 3 UNIDADES 180.00S/. 540.00S/.
HERVIDORA 3 UNIDADES 40.00S/. 120.00S/.
COCINA INDUSTRIAL 1 UNIDADES 1,500.00S/. 1,500.00S/.
TERMOS 3 UNIDADES 80.00S/. 240.00S/.
TETERA 2 UNIDADES 45.00S/. 90.00S/.
SECADORES 6 UNIDADES 5.00S/. 30.00S/.
ALCOHOL 1 LITRO 5.00S/. 5.00S/.
GORROS 10 UNIDADES 5.00S/. 50.00S/.
GUANTES 100 UNIDADES 0.50S/. 50.00S/.
AZAFATES 8 UNIDADES 30.00S/. 240.00S/.
16,556.00S/.
MAQUINARIA Y EQUIPOS
TOTAL DE INVERSION
7/27/2019 PROYECTO ECOLODGE
2/50
EQUIPOS CANTIDAD MEDIDAS PRECIO UNITARIO
Cuadros En Varias Piezas 6 UNIDADES 50.00S/.
Floreros 4 UNIDADES 70.00S/.
Iluminacion/Foco 6 UNIDADES 35.00S/.
Telefono 1 UNIDADES 18.00S/.Televisor 42" 2 UNIDADES 1,800.00S/.
Escritorio 1 UNIDADES 300.00S/.
PAPELERA 2 UNIDADES 10.00S/.
Equipo de cmputo 1 UNIDADES 1,600.00S/.
Equipo de Sonido 1 UNIDADES 1,400.00S/.
Caja Registradora 1 UNIDADES 800.00S/.
Camara de Seguridad 3 UNIDADES 600.00S/.
Manteleria 20 UNIDADES 22.00S/.
Vidrios para mesa 20 UNIDADES 15.00S/.
Espejos 4 UNIDADES 20.00S/.
Ventilador 2 UNIDADES 180.00S/.
MATERIALES DE LIMPIEZA CANTIDAD MEDIDA COSTO UNITARIO
TRAPEADORES 3 UNIDADES 5.00S/.
LEJIA 1 GALON 8.00S/.
DETERGENTE 2 BOLSAS 4KG 30.00S/.
ESCOBAS 3 UNIDADES 10.00S/.
RECOGEDORES 3 UNIDADES 7.00S/.
AMBIENTADORES 1 BIDONES 50.00S/.
DESINFECTANTES 1 BIDONES 50.00S/.
ESCOBILLAS 3 UNIDADES 5.00S/.
DESATORADORES 3 UNIDADES 3.00S/.
JABON LIQUIDO 1 GALON 30.00S/.
PAPEL 2 PLANCHA 10.00S/.
TACHOS DE BASURA 6 UNIDADES 8.00S/.
PAPEL TOALLA 2 UNIDADES 5.00S/.
BALDES 3 UNIDADES 10.00S/.
LIMPIA VIDRIOS 1 GALON 15.00S/.
DECORACIN Y AMBIENTE
TOTAL
MATERIALES DE LIMPIEZA
TOTAL
7/27/2019 PROYECTO ECOLODGE
3/50
PRECIO TOTAL
300.00S/.
280.00S/.
210.00S/.
18.00S/.3,600.00S/.
300.00S/.
20.00S/.
1,600.00S/.
1,400.00S/.
800.00S/.
1,800.00S/.
440.00S/.
300.00S/.
80.00S/.
360.00S/.
11,508.00S/.
COSTO TOTAL
15.00S/.
8.00S/.
60.00S/.
30.00S/.
21.00S/.
50.00S/.
50.00S/.
15.00S/.
9.00S/.
30.00S/.
20.00S/.
48.00S/.
10.00S/.
30.00S/.
15.00S/.
411.00S/.
7/27/2019 PROYECTO ECOLODGE
4/50
GASTOS DE CONSTITUCION 1,114.00S/.TOTAL DE LA INVERSION 29,589.00S/.
FINANCIAMIENTO/INVERSION TOTALMAQUINARIA Y EQUIPO 16,556.00S/.
DECORACION Y AMBIENTE
MATERIALES DE LIMPIEZA 411.00S/.
11,508.00S/.
7/27/2019 PROYECTO ECOLODGE
5/50
X
X
X
X
COSTOS
FIJOS
7/27/2019 PROYECTO ECOLODGE
6/50
INSUMOS Cantidad MedidaCosto
UnitarioCosto Total
COSTOS
VARIABLES
COSTOS
FIJOS
Camarn 4 KILOS 20.00S/. 80.00S/. X
Papas 25 KILOS 1.00S/. 25.00S/. XCarne de Res 6 KILOS 9.00S/. 54.00S/. XMariscos 5 KILOS 18.00S/. 90.00S/. XCabrito 4 KILOS 12.00S/. 48.00S/. XPato 6 KILOS 15.00S/. 90.00S/. XCamote 20 KILOS 0.50S/. 10.00S/. XYuca 18 KILOS 1.50S/. 27.00S/. X
Maiz/Cancha 5 KILOS 3.50S/. 17.50S/. X
Choclo 20 UNIDAD 0.50S/. 10.00S/. XPollo 10 KILOS 6.50S/. 65.00S/. X
Verduras VARIEDAD 40.00S/. 40.00S/. X
Gas 1 BIDON 37.00S/. 37.00S/. X
Aceite 1 GALON 32.00S/. 32.00S/. XArroz 1 SACO 90.00S/. 90.00S/. X
Frutas VARIEDAD 90.00S/. 90.00S/. XInca Kola 250 ml 48 UNIDADES 1.50S/. 72.00S/. X
Inca Kola 500 ml 48 UNIDADES 2.00S/. 96.00S/. XInca Kola 2500 ml 24 UNIDADES 6.00S/. 144.00S/. XGodita Inca Kola 60 UNIDADES 2.50S/. 150.00S/. XInca Kola 1500 ml 30 UNIDADES 5.00S/. 150.00S/. XCoca Cola 1500 ml 30 UNIDADES 5.00S/. 150.00S/. XCoca Cola 2500 ml 24 UNIDADES 6.00S/. 144.00S/. XCoca Cola 500 ml 48 UNIDADES 2.00S/. 96.00S/. XCoca Cola 1 Lt. 36 UNIDADES 4.00S/. 144.00S/. X
Agua sin gas 24 UNIDADES 1.50S/. 36.00S/. X
REPORTE DE COMPRAS SEMANAL
7/27/2019 PROYECTO ECOLODGE
7/50
Agua con gas 24 UNIDADES 1.50S/. 36.00S/. XAzcar 25 KILOS 2.80S/. 70.00S/. XAlios VARIEDAD 10.00S/. 10.00S/. XSal 2 KILOS 1.50S/. 3.00S/. XCerveza Negra 10 UNIDADES 5.00S/. 50.00S/. XLimon 150 UNIDADES 0.03S/. 4.50S/. XHuevos 120 UNIDADES 0.30S/. 36.00S/. X
Loche 3 UNIDADES 6.00S/. 18.00S/. XCulantro 4 MANOJOS 0.80S/. 3.20S/. XCebolla 10 KILOS 1.50S/. 15.00S/. XTomate 8 KILOS 2.00S/. 16.00S/. XLeche 12 TARROS 2.80S/. 33.60S/. XPulpo 5 KILOS 15.00S/. 75.00S/. XPota 4 KILOS 10.00S/. 40.00S/. XConchas 3 KILOS 6.00S/. 18.00S/. XHarina 3 KILOS 4.00S/. 12.00S/. XAji panca 1 KILOS 6.00S/. 6.00S/. XAji Escaveche 2 KILOS 3.50S/. 7.00S/. XAjos 5 KILOS 5.00S/. 25.00S/. XArvejas 5 KILOS 2.50S/. 12.50S/. XZanahoria 6 KILOS 2.00S/. 12.00S/. X
Sillao 2 BOTELLAS 5.00S/. 10.00S/. XFilete de Pesacado 6 KILOS 15.00S/. 90.00S/. XLangostino 5 KILOS 16.00S/. 80.00S/. XPavita 8 KILOS 12.00S/. 96.00S/. XRaya 4 KILOS 18.00S/. 72.00S/. XBatea 6 KILOS 15.00S/. 90.00S/. XCarne de Chancho 8 KILOS 15.00S/. 120.00S/. XGallina 10 KILOS 15.00S/. 150.00S/. XPellejito 8 KILOS 10.00S/. 80.00S/. XPavo 10 KILOS 20.00S/. 200.00S/. X
TOTAL DE COMPRAS 3,478.30S/.
7/27/2019 PROYECTO ECOLODGE
8/50
PLATOS A OFRECERCOSTO DE
VENTASLUNES MARTES MIRCOLES JUEVES VIERNES SBADO DOMINGO
TOTAL DE PLATOS
VENDIDOS
ARROZ CON POLLO 10.00S/. 8 6 8 11 10 9 13 65
SECO DE CABRITO 15.00S/. 7 6 7 9 8 10 14 61
ARROZ CON PATO 12.00S/. 5 8 5 7 7 12 13 57PEPIAN DE PAVA 10.00S/. 4 5 6 4 5 7 8 39
CAUSA MONSEFUANA 13.00S/. 6 8 6 10 10 15 13 68
HORNADO DE PAVO 17.00S/. 7 6 4 6 4 7 8 42
ESPESADO 8.00S/. 9 12 7 10 10 12 23 83
TALLARINES ROJOS 8.00S/. 5 7 6 5 7 8 10 48
FRITO DE CHANCHO 10.00S/. 9 8 6 11 10 9 16 69
PARIHUELAS 24.00S/. 16 10 14 8 14 14 20 96
CHICHARON DE PESCADO 24.00S/. 9 9 7 6 11 13 17 72
ARROZ CON MARISCOS 15.00S/. 10 10 9 5 16 14 18 82
CEVICHE MIXTO 24.00S/. 14 12 14 8 14 15 16 93
BISTEK 8.00S/. 3 7 9 5 6 12 14 56
SUDADO 10.00S/. 15 13 16 7 12 19 14 96
TORTILLA DE RAYA 15.00S/. 13 12 14 15 10 25 24 113
CHINGUIRITO 20.00S/. 7 10 12 14 8 15 16 82CARNE SECA 8.00S/. 13 12 14 13 12 14 17 95
BATEA EN ZARZA 13.00S/. 15 11 14 15 16 13 17 101
PELLEJITO EN ZARZA 13.00S/. 16 13 13 12 14 15 20 103
AJI DE GALLINA 7.00S/. 9 8 8 12 13 14 14 78
SOPA A LA MINUTA 8.00S/. 12 8 6 7 9 12 14 68
212 201TOTAL DE PERSONAS ATENDIDAS
REPORTE DE VENTAS SEMANALES
205 200 226 284 339TOTAL DE
VENTAS
7/27/2019 PROYECTO ECOLODGE
9/50
7/27/2019 PROYECTO ECOLODGE
10/50
TOTAL DE
VENTASSEMANA 1 SEMANA 2 SEMANA 3 SEMANA 4
650.00S/. 22,714.00S/. 23,168.28S/. 23,631.65S/. 24,104.28S/.
915.00S/.
684.00S/.390.00S/.
884.00S/.
714.00S/.
664.00S/.
384.00S/. AO 1 93,618.20S/. AO BASE
690.00S/. AO 2 95,490.56S/.
2,304.00S/. AO 3 97,400.38S/.
1,728.00S/. AO 4 100,322.39S/.
1,230.00S/. AO 5 103,332.06S/.
2,232.00S/. AO 6 106,432.02S/.448.00S/. AO 7 111,753.62S/.
960.00S/. AO 8 117,341.30S/.
1,695.00S/. AO 9 123,208.37S/.
1,640.00S/. AO 10 129,368.79S/.760.00S/.
1,313.00S/.
1,339.00S/.
546.00S/.
544.00S/.
S/. 22,714.00
PROYECCION DE VENTAS MENSUAL EN 2%
TOTAL DE VENTAS AL MES 93,618.20S/.
2%
3%
5%
PROYECCION DE VENTAS DURANTE 10 AOS
7/27/2019 PROYECTO ECOLODGE
11/50
CANTIDADPAGO
UNITARIOPAGO TOTAL
1 900.00S/. 900.00S/.
2 750.00S/. 1,500.00S/.
4 750.00S/. 3,000.00S/.
1 750.00S/. 750.00S/.
1 750.00S/. 750.00S/.
2 750.00S/. 1,500.00S/.
CANTIDADPAGO
UNITARIOPAGO TOTAL
1 1,500.00S/. 1,500.00S/.
1 100.00S/. 100.00S/.
250.00S/.
200.00S/.
90.00S/.
90.00S/.
630.00S/.
1,300.00S/.
2,000.00S/.
3,300.00S/.
COSTOS FIJOS
X
X
X
X
SEGURIDAD
PAGOS A LOS TRABAJADORES MENSUAL
CHEF
AYUDANTE DE COCINA
PERSONAL
AZAFATAS
CAJA
LIMPIEZA
PAGOS ADMINISTRATIVOS
ADMINISTRADOR
CONTADOR
TOTAL 8,400.00S/.
PERSONAL
MENSUAL
MENSUAL
MENSUAL
TOTAL 1,600.00S/.
TOTAL
SERVICIOS PUBLICOS
CABLE
INTERNET/TELEFONO
AGUA
LUZ MENSUAL
OTROS PAGOSSEGUROS
ALQUILER MENSUAL
MENSUAL
TOTAL
13,930.00S/.TOTAL DE PAGOS MENSUALES
TOTAL DE PAGOS MENSUALESTRABAJADORES
ADMINISTRATIVOS
SERVICIOS PUBLICOS
OTROS PAGOS 3,300.00S/.
630.00S/.
1,600.00S/.
8,400.00S/.
7/27/2019 PROYECTO ECOLODGE
12/50
EQUIPOS CANTIDAD MEDIDAPRECIO
UNITARIOPRECIO TOTAL AO 1 AO 2 AO 3
CAMAS 2 UNIDADES 1,399.00S/. 2,798.00S/. -2,518.20S/. 2,266.38S/. -2,039.74S/.
TELEVISORES 2 UNIDADES 1,199.00S/. 2,398.00S/. -2,158.20S/. 1,942.38S/. -1,748.14S/.
COMPUTADORAS 3 JUEGOS 300.00S/. 900.00S/. -810.00S/. 729.00S/. -656.10S/.
ESCRITORIO 2 UNIDADES 360.00S/. 720.00S/. -648.00S/. 583.20S/. -524.88S/.ZABANAS 6 DOCENAS 110.00S/. 660.00S/. -594.00S/. 534.60S/. -481.14S/.
COLCHONES 5 DOCENAS 45.00S/. 225.00S/. -202.50S/. 182.25S/. -164.03S/.
HEDREDONES 5 DOCENAS 32.00S/. 160.00S/. -144.00S/. 129.60S/. -116.64S/.
TOALLAS 20 UNIDADES 120.00S/. 2,400.00S/. -2,160.00S/. 1,944.00S/. -1,749.60S/.
MESA DE NOCHE 90 UNIDADES 30.00S/. 2,700.00S/. -2,430.00S/. 2,187.00S/. -1,968.30S/.
LAMPARAS 4 DOCENAS 50.00S/. 200.00S/. -180.00S/. 162.00S/. -145.80S/.
FOCOS 5 UNIDADES 25.00S/. 125.00S/. -112.50S/. 101.25S/. -91.13S/.
PLANCHAS DE ROPA
EQUIPAMIENTO DE EQUIPOS DEL ECOLODGE DEPRECIACION DEL 1
7/27/2019 PROYECTO ECOLODGE
13/50
DEPRECIACION DE EQUIPOS
y = -2281.x + 8665.
R = 0.088
S/. -
S/. 0.20
S/. 0.40
S/. 0.60
S/. 0.80
S/. 1.00
S/. 1.20
0 1 2 3 4 5 6 7
7/27/2019 PROYECTO ECOLODGE
14/50
AO 4 AO 5
1,835.77S/. -1,652.19S/.
1,573.33S/. -1,416.00S/.
590.49S/. -531.44S/.
472.39S/. -425.15S/.433.03S/. -389.72S/.
147.62S/. -132.86S/.
104.98S/. -94.48S/.
1,574.64S/. -1,417.18S/.
1,771.47S/. -1,594.32S/.
131.22S/. -118.10S/.
82.01S/. -73.81S/.
% ANUAL
7/27/2019 PROYECTO ECOLODGE
15/50
DERECHO COSTO
Pago de Derecho de Trmite S/. 40.00
Solicitud valorada de Autorizacin Municipal S/. 42.00
Cartn de licencia municipal S/. 150.00
Pago de derecho de apertura S/. 260.00
Formato de evolucin, higiene y saneamiento ambiental S/. 30.00
Formato de tasa S/. 12.00
Certificado de fumigacin S/. 120.00
Ficha tcnica de inspeccin defensa civil S/. 140.00
Certificado de salubridad S/. 220.00
Talonario de facturas y boletas(10 c/u) S/. 100.00
TOTAL S/. 1,114.00
GASTOS DE CONSTITUCION
7/27/2019 PROYECTO ECOLODGE
16/50
AO 1 93,618.20S/. AO BASE
AO 2 95,490.56S/.
AO 3 97,400.38S/.AO 4 100,322.39S/.
AO 5 103,332.06S/.
AO 6 106,432.02S/.
AO 7 111,753.62S/.
AO 8 117,341.30S/.
AO 9 123,208.37S/.
AO 10 129,368.79S/.
PROYECCION DE VENTAS DURANTE 10 AOS
2%
3%
5%
7/27/2019 PROYECTO ECOLODGE
17/50
HABITACIONESNUMERO DE
HABITACIONES
MEDIDA DE LAS
HABITACIONES
HABITACIONES SIMPLES 8 14M2
HABITACIONES DOBLES 6 20M2
HABITACIONES TRIPLES 4 30M2
HABITACIONES MATRIMONIALES 4 22M2
SALON DE EVENTOS 1 60M2
PISCINA 1 80M2
CAMPO DEPORTIVO 1 45M2
RESTAURANTE 1 60
pre
ECOLODGE LA C
presupuesto o
7/27/2019 PROYECTO ECOLODGE
18/50
CANTIDAD DE
M2
PRECIO
POR M2
PRECIO POR
HABITACION
PRECIO TOTALPOR
HABITACIONES
112 M2 500.00S/. 7,000.00S/. 56,000.00S/.
120 M2 500.00S/. 10,000.00S/. 60,000.00S/.
120 M2 500.00S/. 15,000.00S/. 60,000.00S/.
88 M2 500.00S/. 11,000.00S/. 44,000.00S/.
60M2
80M2
40M2
12O
OMARCA
bras civiles
7/27/2019 PROYECTO ECOLODGE
19/50
|
7/27/2019 PROYECTO ECOLODGE
20/50
500
MATERIALEs DE CONSTRUCCION CANTIDAD PREC. UNITARIO
GUAYAQUIL 200 25.00S/.
VIGAS DE MADERA 80 85.00S/.
MADERA MEDREMBRADA 40 65.00S/.TEJAS (ETERNIT) 80 20.00S/.
horcones para muros 20 100.00S/.
ECOLODGE LA
7/27/2019 PROYECTO ECOLODGE
21/50
PRECIO TOTAL
5,000.00S/.
6,800.00S/.
2,600.00S/.1,600.00S/.
2,000.00S/.
COMARCA
7/27/2019 PROYECTO ECOLODGE
22/50
INVERSION FIJA
A.- BIENES TANGIBLES 630,125.05S/.
TERRENO 250,000.00S/.
INFRAESTRUCTURA 220,000.00S/.
EQUIPO DE IMPLEMENTACION 99,060.00S/.EQUIPO DE OFICINA 6,000.00S/.
VEHICULO 55,065.05S/.
B.- BIENES INTANGIBLES 6,114.00S/.
CAPACITACION AL PERSONAL 5,000.00S/.
GASTOS DE CONSTITUCION 1,114.00S/.
C. IMPREVISTOS
5% A+B 31,811.95S/.
CAPITAL DE TRABAJO 23,509.00S/.
REMUNERACIONES 13,000.00S/.
SERVICIOS PUBLICOS 420.00S/.
SEGUROS 10,089.00S/.OTROS GASTOS 2,350.90S/.
691,560.00S/.
691,560.00S/.
INVERSION DEL ECOLODGE LA COMARCA
TOTAL DE INVERSION
7/27/2019 PROYECTO ECOLODGE
23/50
7/27/2019 PROYECTO ECOLODGE
24/50
HABITACIONESNUMERO DE
HABITACIONESCAMAS
HABITACIONES SIMPLES 8 8
HABITACIONES DOBLES 6 12
HABITACIONES TRIPLES 4 12
HABITACIONES MATRIMONIALES 4 4
ECOLODGE LA COMARCA
7/27/2019 PROYECTO ECOLODGE
25/50
MEDIDA DE CAMAS COLCHONES
1 1/2 PL 1,5 PL ParasoColchn Per
2 1/2 PL 2,5 PLParasoColchn Tropical
1 PL Paraso Colchn Edn
1 1/2 PL
2 1/2 PL
COLCHONES DE RESERVA
1,5 PL ParasoColchn Per
2,5 PLParasoColchn Tropical
1 PL Paraso Colchn Edn
7/27/2019 PROYECTO ECOLODGE
26/50
CANTIDAD DECOLCHONES
PRECIO UNITARIOCOLCHONES
PARAISO
PRECIO TOTALCOLCHONES
PARAISO20 329.00S/. 6,580.00S/.
16 469.00S/. 7,504.00S/.
4 269.00S/. 1,076.00S/.
PRECIO TOTAL ENCOLCHONES
15,160.00S/.18,690.00S/.
CANTIDAD DE
COLCHONES
PRECIO UNITARIOCOLCHONES
PARAISO
PRECIO TOTALCOLCHONES
PARAISO4 329.00S/. 1,316.00S/.
3 469.00S/. 1,407.00S/.
3 269.00S/. 807.00S/.
3,530.00S/.
ECOLODGE LA COMARCA
ECOLODGE LA COMARCA
7/27/2019 PROYECTO ECOLODGE
27/50
SABANAS Y ALMOHADASCANTIDAD DEHABITACIONES
SABANAS Y ALMOHADAS MOD. GRIS0932 22
CUBRECAMASCANTIDAD DEHABITACIONES
CUBRECAMAS Roberta Allen Quilt Patch 22
TOALLASCANTIDAD DEHABITACIONES
TOALLAS Benetton 22
ECOLODGE LA COMARCA
ECOLODGE LA COMARCA
ECOLODGE LA COMARCA
7/27/2019 PROYECTO ECOLODGE
28/50
SABANAS YALMOHADAS
PRECIOUNITARIO
PRECIOTOTAL
2 JUEGOS 69.00S/. 3,036.00S/.
SABANAS YALMOHADAS
PRECIOUNITARIO
PRECIOTOTAL
2 JUEGOS 99.00S/. 4,356.00S/.
SABANAS YALMOHADAS
PRECIOUNITARIO
PRECIOTOTAL
2 JUEGOS 19.90S/. 875.60S/.
7/27/2019 PROYECTO ECOLODGE
29/50
OBRA
terreno
HAB. SIMPLE
HAB. DOBLE
HAB . TRIPLE
HAB MATRIMONIALES
SALON DE EVENTOS
PISCINA
CAMPO DEPORTIVO
RESTAURANTE
PRESUPUESTO DE OBRAS
T0TAL DE INVERSION DEL
EQUIPAMIENTO
7/27/2019 PROYECTO ECOLODGE
30/50
7/27/2019 PROYECTO ECOLODGE
31/50
PERSONAL
ADNINISTRADOR
CONTADOR
RECEPCIONISTAS
BOTONES
CAMAREROS
AMA DE LLAVES
CHEF
AYUDANTE DE COCINA
MOSOAZAFATAS
ZZ personal de limpieza
NUMERO DE CUETAS
1
2
3
4
5
67
8
9
10
11
12
13
14
RE
7/27/2019 PROYECTO ECOLODGE
32/50
15
INGRESOSAPORTE PROPIO
PRESTAMO
VENTAS
EGRESOSCAPITAL DE YTRABAJO
IGV
FLUJO DE CAJA
INVERSIONES
FLUJO NETO ECOINTERESES
AMORTIZACION
FLUJO FINANCIER
FLUJO DE CAJA A
7/27/2019 PROYECTO ECOLODGE
33/50
7/27/2019 PROYECTO ECOLODGE
34/50
7/27/2019 PROYECTO ECOLODGE
35/50
PRESUPUESTO OBRAS CIVILESAREA CONSTRUIDA VALOR M2 COSTO TOTAL
1 5000 250,000.00S/.
8 14M2 56,000.00S/.6 20M2 60,000.00S/.4 30M2 60,000.00S/.4 22M2 44,000.00S/.1 60M2 30,000.00S/.1 80M2 40,000.00S/.1 45M2 22,500.00S/.1 60M2 30,000.00S/.
TOTAL 592,500.00S/.
99,060.00S/.
IVILES 592,500.00S/.
PROYECTO 345,780.00S/.
EQUIPO CANTIDAD VALOR UNITARIO TOTALEQUIPOS ELECTRICOS
TV PLASMA 24 1,500.00S/. 36,000.00S/.
COSINA INDUSTRIAL 1 1,600.00S/. 1,600.00S/.
REFRIGIDER 1 1,200.00S/. 1,200.00S/.
ORNO MICROONDAS 1 120.00S/. 120.00S/.
CONJELADORA 1 1,600.00S/. 1,600.00S/.
FRIOBAR 1 450.00S/. 450.00S/.VENTILADORES 24 80.00S/. 1,920.00S/.
LICUADORA 2 50.00S/. 100.00S/.
PLANCHAS 3 55.00S/. 165.00S/.COMPUTADORAS 2 1,500.00S/. 3,000.00S/.
LAMPARAS 44 75.00S/. 3,300.00S/.
TOTAL 49,455.00S/.
PRESUPUESTO DE EQUIPAMIENTO ECOLODGE LA COMARCA
7/27/2019 PROYECTO ECOLODGE
36/50
EQUIPAMIENTO
COLCHONES 50 18,690.00S/.
MESAS DE NOCHE 25 48.00S/. 1,200.00S/.
SABANAS POR JUEGO 80 80.00S/. 6,400.00S/.
ALMOADAS 100 12.00S/. 1,200.00S/.
TOALLAS 100 18.00S/. 1,800.00S/.
EDREDONES 55 75.00S/. 4,125.00S/.TOTAL 33,415.00S/.
EQUIPOS DE OFICINA
COMPUTADORA 1 1,500.00S/. 1,500.00S/.
IMPRESORA HP 1 250.00S/. 250.00S/.
ESCANEADOTA HP 1 300.00S/. 300.00S/.
ESCRITORIO 1 500.00S/. 500.00S/.
PORTA DOCUMENTOS 5 50.00S/. 250.00S/.
PAPEL BOND 100 15.00S/. 1,500.00S/.
CuADERNOS 8 20.00S/. 160.00S/.LAPICEROS 20 25.00S/. 500.00S/.
PLUMONES 20 30.00S/. 600.00S/.
TOTAL 5,560.00S/.
ADORNOS
CUADROS 120 25.00S/. 3,000.00S/.
Espejos 50 20.00S/. 1,000.00S/.
Manteleria 20 22.00S/. 440.00S/.
Floreros 25 35.00S/. 875.00S/.
Iluminacion/Foco 30 23.00S/. 5,315.00S/.total 187,490.00S/.
7/27/2019 PROYECTO ECOLODGE
37/50
CANTIDAD SUELDO MENSUAL SUELDO ANUAL BENEFICIOS
1 1,200.00S/. 14,400.00S/. 1,500.00S/.
1 150.00S/. 1,800.00S/. -S/.
2 1,500.00S/. 18,000.00S/. 3,000.00S/.
2 1,200.00S/. 14,400.00S/. 3,000.00S/.
4 1,000.00S/. 12,000.00S/. 3,000.00S/.
2 1,100.00S/. 13,200.00S/. 1,500.00S/.
1 850.00S/. 10,200.00S/. 750.00S/.
2 600.00S/. 7,200.00S/. 1,000.00S/.
2 600.00S/. 7,200.00S/. 1,000.00S/.2 1,200.00S/. 14,400.00S/. 1,000.00S/.
2 400.00S/. 4,800.00S/. 800.00S/.
SALDO DEUDOR INTERESES AMORTIZACION SERVICIO DE DEUDA
485625
UNERACION DE PERSONAL
AMORTIZACION DEL PRESTAMO
7/27/2019 PROYECTO ECOLODGE
38/50
AO 0 AO 1 AO 2 AO 3
OMICO
O
UMULADO
FLUJO DE CAJA PROYECTADO
7/27/2019 PROYECTO ECOLODGE
39/50
depreciscion de equipos
7/27/2019 PROYECTO ECOLODGE
40/50
7/27/2019 PROYECTO ECOLODGE
41/50
BENEFICIOSVACACIONES
GRATIFICACIONES
CTS
ESSSALUD 18 DEL SUELDO ANUAL
7/27/2019 PROYECTO ECOLODGE
42/50
7/27/2019 PROYECTO ECOLODGE
43/50
TOTAL
17,100.00S/.
1,950.00S/.
22,500.00S/.
18,600.00S/.
16,000.00S/.
15,800.00S/.
11,800.00S/.
8,800.00S/.
8,800.00S/. 16,600.00S/.
6,000.00S/.
143,950.00S/.
977292666943829401
7/27/2019 PROYECTO ECOLODGE
44/50
AO 4 AO 5
7/27/2019 PROYECTO ECOLODGE
45/50
7/27/2019 PROYECTO ECOLODGE
46/50
EQUIPO CANTIDAD VALOR UNITARIO TOTAL AO 1
EQUIPOS ELECTRICOS
TV PLASMA 24 1,500.00S/. 36,000.00S/. -32,400.00S/.
COSINA INDUSTRIAL 1 1,600.00S/. 1,600.00S/. -1,440.00S/.
REFRIGIDER 1 1,200.00S/. 1,200.00S/. -1,080.00S/.ORNO MICROONDAS 1 120.00S/. 120.00S/. -108.00S/.
CONJELADORA 1 1,600.00S/. 1,600.00S/. -1,440.00S/.
FRIOBAR 1 450.00S/. 450.00S/. -405.00S/.
VENTILADORES 24 80.00S/. 1,920.00S/. -1,728.00S/.
LICUADORA 2 50.00S/. 100.00S/. -90.00S/.
PLANCHAS 3 55.00S/. 165.00S/. -148.50S/.
COMPUTADORAS 2 1,500.00S/. 3,000.00S/. -2,700.00S/.
LAMPARAS 44 75.00S/. 3,300.00S/. -2,970.00S/.
TOTAL -S/.
EQUIPAMIENTO
COLCHONES 50 18,690.00S/. -15,886.50S/.
MESAS DE NOCHE 25 48.00S/. 1,200.00S/. -1,020.00S/.
SABANAS POR JUEGO 80 80.00S/. 6,400.00S/. -5,440.00S/.
ALMOADAS 100 12.00S/. 1,200.00S/. -1,020.00S/.
TOALLAS 100 18.00S/. 1,800.00S/. -1,530.00S/.
EDREDONES 55 75.00S/. 4,125.00S/. -3,506.25S/.
TOTAL -S/.
EQUIPOS DE OFICINA
COMPUTADORA 1 1,500.00S/. 1,500.00S/. -1,350.00S/.
IMPRESORA HP 1 250.00S/. 250.00S/. -225.00S/.
ESCANEADOTA HP 1 300.00S/. 300.00S/. -270.00S/.
ESCRITORIO 1 500.00S/. 500.00S/. -450.00S/.
PORTA DOCUMENTOS 5 50.00S/. 250.00S/. -225.00S/.
PAPEL BOND 100 15.00S/. 1,500.00S/. -1,350.00S/.
CuADERNOS 8 20.00S/. 160.00S/. -144.00S/.
LAPICEROS 20 25.00S/. 500.00S/. -450.00S/.
PLUMONES 20 30.00S/. 600.00S/. -540.00S/.
TOTAL -S/.
ADORNOS
CUADROS 120 25.00S/. 3,000.00S/. -2,700.00S/.
Espejos 50 20.00S/. 1,000.00S/. -900.00S/.
Manteleria 20 22.00S/. 440.00S/. -396.00S/.
Floreros 25 35.00S/. 875.00S/. -787.50S/.
Iluminacion/Foco 30 23.00S/. 5,315.00S/. -4,783.50S/.
total -S/.
99,060.00S/.TOTAL DE INVERSION
PRESUPUESTO DE EQUIPAMIENTO ECOLODGE LA COMARCA
7/27/2019 PROYECTO ECOLODGE
47/50
AO 2 AO 2 AO 3 AO 4 AO 5
29,160.00S/. -26,244.00S/. 23,619.60S/. -21,257.64S/. 19,131.88S/.
1,296.00S/. -1,166.40S/. 1,049.76S/. -944.78S/. 850.31S/.
972.00S/. -874.80S/. 787.32S/. -708.59S/. 637.73S/.
97.20S/. -87.48S/. 78.73S/. -70.86S/. 63.77S/.
1,296.00S/. -1,166.40S/. 1,049.76S/. -944.78S/. 850.31S/.
364.50S/. -328.05S/. 295.25S/. -265.72S/. 239.15S/.
1,555.20S/. -1,399.68S/. 1,259.71S/. -1,133.74S/. 1,020.37S/.
81.00S/. -72.90S/. 65.61S/. -59.05S/. 53.14S/.
133.65S/. -120.29S/. 108.26S/. -97.43S/. 87.69S/.
2,430.00S/. -2,187.00S/. 1,968.30S/. -1,771.47S/. 1,594.32S/.
2,673.00S/. -2,405.70S/. 2,165.13S/. -1,948.62S/. 1,753.76S/.
-S/. -S/. -S/. -S/. -S/.
13,503.53S/. -11,478.00S/. 9,756.30S/. -8,292.85S/. 7,048.92S/.
867.00S/. -736.95S/. 626.41S/. -532.45S/. 452.58S/.
4,624.00S/. -3,930.40S/. 3,340.84S/. -2,839.71S/. 2,413.76S/.
867.00S/. -736.95S/. 626.41S/. -532.45S/. 452.58S/.
1,300.50S/. -1,105.43S/. 939.61S/. -798.67S/. 678.87S/.
2,980.31S/. -2,533.27S/. 2,153.28S/. -1,830.28S/. 1,555.74S/.
-S/. -S/. -S/. -S/. -S/.
1,215.00S/. -1,093.50S/. 984.15S/. -885.74S/. 797.16S/.
202.50S/. -182.25S/. 164.03S/. -147.62S/. 132.86S/.
243.00S/. -218.70S/. 196.83S/. -177.15S/. 159.43S/.
405.00S/. -364.50S/. 328.05S/. -295.25S/. 265.72S/.
202.50S/. -182.25S/. 164.03S/. -147.62S/. 132.86S/.
1,215.00S/. -1,093.50S/. 984.15S/. -885.74S/. 797.16S/.
129.60S/. -116.64S/. 104.98S/. -94.48S/. 85.03S/.
405.00S/. -364.50S/. 328.05S/. -295.25S/. 265.72S/.
486.00S/. -437.40S/. 393.66S/. -354.29S/. 318.86S/.
-S/. -S/. -S/. -S/. -S/.
2,430.00S/. -2,187.00S/. 1,968.30S/. -1,771.47S/. 1,594.32S/.
810.00S/. -729.00S/. 656.10S/. -590.49S/. 531.44S/.
356.40S/. -320.76S/. 288.68S/. -259.82S/. 233.83S/.
708.75S/. -637.88S/. 574.09S/. -516.68S/. 465.01S/.
4,305.15S/. -3,874.64S/. 3,487.17S/. -3,138.45S/. 2,824.61S/.
-S/. -S/. -S/. -S/. -S/.
DEPRESIACION DE EQUIPOS ECOLOGDE LA COMARCA
EQIPOS ELECTRONICOS DEPRECIACION DEL 10 %
EQUIPAMIENTO DEPRESIACION DEL 15 %
EQUIPOS DE OFICINA DEPRECIACION DEL 10 %
ADORNOS DEPRECIACION 10 %
7/27/2019 PROYECTO ECOLODGE
48/50
N CUOTA SALDO DEUDOR INTERES AMORTIZACION
1 350,000.00S/. 30,625.00S/. ..
2 350,000.00S/. 30,625.00S/. ..
3 350,000.00S/. 30,625.00S/. ..
4 350,000.00S/. 30,625.00S/...
5 350,000.00S/. 30,625.00S/. 10,850.00S/.
6 339,150.00S/. 29,675.63S/. 11,799.38S/.
7 327,350.63S/. 28,643.18S/. 12,831.82S/.
8 314,518.80S/. 27,520.40S/. 13,954.60S/.
9 300,564.20S/. 26,299.37S/. 15,175.63S/.
10 285,388.57S/. 24,971.50S/. 16,503.50S/.
11 268,885.07S/. 23,527.44S/. 17,947.56S/.
12 250,937.51S/. 21,957.03S/. 19,517.97S/.
13 231,419.54S/. 20,249.21S/. 21,225.79S/.
14 210,193.75S/. 18,391.95S/. 23,083.05S/.
15 187,110.71S/. 16,372.19S/. 25,102.81S/.16 162,007.89S/. 14,175.69S/. 27,299.31S/.
17 134,708.58S/. 11,787.00S/. 29,688.00S/.
18 105,020.58S/. 9,189.30S/. 32,285.70S/.
19 72,734.89S/. 6,364.30S/. 35,110.70S/.
20 37,624.19S/. 3,292.12S/. 37,624.18S/.
350,000.00S/.
AMORTIZACION DE DEUDA ECOLODGE LA COMARCA
7/27/2019 PROYECTO ECOLODGE
49/50
SERVICIO DE DEUDA
30,625.00S/.
30,625.00S/.
30,625.00S/.
30,625.00S/.41,475.00S/.
41,475.00S/.
41,475.00S/. 134,708.58S/.
41,475.00S/.
41,475.00S/.
41,475.00S/.
41,475.00S/.
41,475.00S/.
41,475.00S/.
41,475.00S/.
41,475.00S/.41,475.00S/.
41,475.00S/.
41,475.00S/.
41,475.00S/.
41,475.00S/. 558.70S/.
7/27/2019 PROYECTO ECOLODGE
50/50
PROYECCION DE VENTAS ECOLODGE LA COMARCA