Administracion Financiera 22-11-2017
Administracion Financiera 22-11-2017
Administracion Financiera 22-11-2017
PROYECCION DE VENTAS
¿Cuánto podré vender?
N° Producto / Servicio Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 TOTAL
1 ARROZ X KG 500 510 515 520 525 530 535 540 545 550 555 560 6385
2 AZUCAR X KG 450 455 460 465 470 475 480 485 490 495 500 510 5735
3 FRUGOS 350 355 360 365 370 375 380 385 390 395 300 410 4435
4 GASEOSAS 350 415 420 425 430 435 440 45 300 290 300 250 4100
5 LECHE CHICA 200 215 220 230 235 240 245 253 258 200 278 230 2804
6 LECHE GRANDE 200 210 215 220 225 230 235 245 250 198 270 220 2718
7 AGUA CHICA 200 250 200 220 180 310 230 260 210 206 245 249 2760
8 AGUA GRANDE 150 175 189 197 210 220 230 240 256 264 274 250 2655
9 ACEITE X 500ML 80 85 89 90 92 95 99 105 110 120 125 130 1220
10 ATUN 60 76 82 86 94 112 135 153 160 206 228 242 1634
11 CERVEZA 150 170 180 190 200 150 223 234 243 250 260 240 2490
12 LAVAVAJILLA 150 120 125 132 145 100 154 159 160 168 178 185 1776
13 JABON 50 60 65 70 80 85 90 95 100 110 120 130 1055
14 SHAMPOO 95 100 124 135 145 155 165 175 185 195 200 230 1904
15 MANTEQUILLA 80 95 100 115 123 132 142 152 164 178 189 198 1668
16 PASTA DENTAL 93 120 136 157 164 178 184 197 200 216 220 224 2089
17 PAPEL HIGIENICO 125 115 132 145 156 165 178 186 195 210 215 226 2048
18 HUEVO XKG 300 320 325 330 340 200 350 355 350 365 210 210 3655
19 PAÑALES 350 220 230 250 260 210 280 290 300 310 250 200 3150
20 CHOCOLATES 100 90 100 115 125 134 142 152 164 174 182 192 1670
21 DETERGENTES DE 1 KG 150 110 120 130 135 145 150 160 182 193 200 210 1885
22 CONSERVAS 180 132 142 152 162 170 178 185 190 195 197 215 2098
23 GALLETAS 110 120 135 145 155 160 165 170 178 182 192 200 1912
24 HARINA 150 132 142 152 162 172 184 192 198 200 210 220 2114
25 CAFÉ 200 120 130 140 150 160 170 180 190 200 215 220 2075
26 LEJIAS 300 320 315 320 325 240 35 340 345 200 220 250 3210
27 DETERGENTES 360GR 320 330 340 356 360 230 380 390 400 410 300 430 4246
28 YOGURT 200 210 215 220 225 220 235 240 245 250 255 200 2715
29 FIDEOS TALLARINES 250 260 265 270 275 250 285 290 295 300 315 220 3275
30 FIDEOS DE SOPA 300 320 345 350 355 300 365 370 380 390 320 200 3995
TOTAL DE UNIDADES VENDIDAS 6193 6210 6416 6692 6873 6578 7064 7223 7633 7620 7523 7451 83476
Producto / Servicio Precio Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 TOTAL
ARROZ X KG 3.50 1,750.00 1,785.00 1,802.50 1,820.00 1,837.50 1,855.00 1,872.50 1,890.00 1,907.50 1,925.00 1,942.50 1,960.00 22,347.50
AZUCAR X KG 2.90 1,305.00 1,319.50 1,334.00 1,348.50 1,363.00 1,377.50 1,392.00 1,406.50 1,421.00 1,435.50 1,450.00 1,479.00 16,631.50
FRUGOS 3.50 1,225.00 1,242.50 1,260.00 1,277.50 1,295.00 1,312.50 1,330.00 1,347.50 1,365.00 1,382.50 1,050.00 1,435.00 15,522.50
GASEOSAS 5.00 1,750.00 2,075.00 2,100.00 2,125.00 2,150.00 2,175.00 2,200.00 225.00 1,500.00 1,450.00 1,500.00 1,250.00 20,500.00
LECHE CHICA 3.00 600.00 1,075.00 1,100.00 1,150.00 1,175.00 1,200.00 1,225.00 1,265.00 1,290.00 1,000.00 1,390.00 1,150.00 13,620.00
LECHE GRANDE 3.50 700.00 735.00 752.50 770.00 787.50 805.00 822.50 857.50 875.00 693.00 945.00 770.00 9,513.00
AGUA CHICA 2.00 400.00 500.00 400.00 440.00 360.00 620.00 460.00 520.00 420.00 412.00 490.00 498.00 5,520.00
AGUA GRANDE 3.00 450.00 525.00 567.00 591.00 630.00 660.00 690.00 720.00 768.00 792.00 822.00 750.00 7,965.00
ACEITE X 500ML 7.00 1,400.00 1,505.00 1,540.00 1,610.00 1,645.00 1,680.00 1,715.00 1,771.00 1,806.00 1,400.00 1,946.00 1,610.00 19,628.00
ATUN 5.00 1,000.00 1,050.00 1,075.00 1,100.00 1,125.00 1,150.00 1,175.00 1,225.00 1,250.00 990.00 1,350.00 1,100.00 13,590.00
CERVEZA 5.00 1,000.00 1,250.00 1,000.00 1,100.00 900.00 1,550.00 1,150.00 1,300.00 1,050.00 1,030.00 1,225.00 1,245.00 13,800.00
LAVAVAJILLA 2.00 300.00 350.00 378.00 394.00 420.00 440.00 460.00 480.00 512.00 528.00 548.00 500.00 5,310.00
JABON 2.00 160.00 170.00 178.00 180.00 184.00 190.00 198.00 210.00 220.00 240.00 250.00 260.00 2,440.00
SHAMPOO 14.00 840.00 1,064.00 1,148.00 1,204.00 1,316.00 1,568.00 1,890.00 2,142.00 2,240.00 2,884.00 3,192.00 3,388.00 22,876.00
MANTEQUILLA 4.50 675.00 765.00 810.00 855.00 900.00 675.00 1,003.50 1,053.00 1,093.50 1,125.00 1,170.00 1,080.00 11,205.00
PASTA DENTAL 2.50 375.00 300.00 312.50 330.00 362.50 250.00 385.00 397.50 400.00 420.00 445.00 462.50 4,440.00
PAPEL HIGIENICO 1.30 65.00 78.00 84.50 91.00 104.00 110.50 117.00 123.50 130.00 143.00 156.00 169.00 1,371.50
HUEVO XKG 4.00 380.00 400.00 496.00 540.00 580.00 620.00 660.00 700.00 740.00 780.00 800.00 920.00 7,616.00
PAÑALES 1.50 120.00 142.50 150.00 172.50 184.50 198.00 213.00 228.00 246.00 267.00 283.50 297.00 2,502.00
CHOCOLATES 2.00 186.00 240.00 272.00 314.00 328.00 356.00 368.00 394.00 400.00 432.00 440.00 448.00 4,178.00
DETERGENTES DE 1 KG 4.00 500.00 460.00 528.00 580.00 624.00 660.00 712.00 744.00 780.00 840.00 860.00 904.00 8,192.00
CONSERVAS 5.00 1,500.00 1,600.00 1,625.00 1,650.00 1,700.00 1,000.00 1,750.00 1,775.00 1,750.00 1,825.00 1,050.00 1,050.00 18,275.00
GALLETAS 2.00 700.00 440.00 460.00 500.00 520.00 420.00 560.00 580.00 600.00 620.00 500.00 400.00 6,300.00
HARINA 3.50 350.00 315.00 350.00 402.50 437.50 469.00 497.00 532.00 574.00 609.00 637.00 672.00 5,845.00
CAFÉ 2.00 300.00 220.00 240.00 260.00 270.00 290.00 300.00 320.00 364.00 386.00 400.00 420.00 3,770.00
LEJIAS 2.00 360.00 264.00 284.00 304.00 324.00 340.00 356.00 370.00 380.00 390.00 394.00 430.00 4,196.00
DETERGENTES 360GR 1.20 132.00 144.00 162.00 174.00 186.00 192.00 198.00 204.00 213.60 218.40 230.40 240.00 2,294.40
YOGURT 2.00 300.00 264.00 284.00 304.00 324.00 344.00 368.00 384.00 396.00 400.00 420.00 440.00 4,228.00
FIDEOS TALLARINES 4.50 900.00 540.00 585.00 630.00 675.00 720.00 765.00 810.00 855.00 900.00 967.50 990.00 9,337.50
FIDEOS DE SOPA 4.00 1,200.00 1,280.00 1,260.00 1,280.00 1,300.00 960.00 140.00 1,360.00 1,380.00 800.00 880.00 1,000.00 12,840.00
TOTAL DE INGRESOS POR VENTAS 20,923.00 22,098.50 22,538.00 23,497.00 24,007.50 24,187.50 24,972.50 25,334.50 26,926.60 26,317.40 27,733.90 27,317.50 295,853.90
(1) El nivel de precio debe estar de acuerdo con la estrategia comercial planteada en el acápite anterior.
Producto / Servicio Precio Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 TOTAL
ARROZ X KG 3.20 1,600.00 1,632.00 1,648.00 1,664.00 1,680.00 1,696.00 1,712.00 1,728.00 1,744.00 1,760.00 1,776.00 1,792.00 20,432.00
AZUCAR X KG 2.60 1,170.00 1,183.00 1,196.00 1,209.00 1,222.00 1,235.00 1,248.00 1,261.00 1,274.00 1,287.00 1,300.00 1,326.00 14,911.00
FRUGOS 3.00 1,050.00 1,065.00 1,080.00 1,095.00 1,110.00 1,125.00 1,140.00 1,155.00 1,170.00 1,185.00 900.00 1,230.00 13,305.00
GASEOSAS 4.00 1,400.00 1,660.00 1,680.00 1,700.00 1,720.00 1,740.00 1,760.00 180.00 1,200.00 1,160.00 1,200.00 1,000.00 16,400.00
LECHE CHICA 2.00 400.00 430.00 440.00 460.00 470.00 480.00 490.00 506.00 516.00 400.00 556.00 460.00 5,608.00
LECHE GRANDE 3.20 640.00 672.00 688.00 704.00 720.00 736.00 752.00 784.00 800.00 633.60 864.00 704.00 8,697.60
AGUA CHICA 1.00 200.00 250.00 200.00 220.00 180.00 310.00 230.00 260.00 210.00 206.00 245.00 249.00 2,760.00
AGUA GRANDE 2.00 300.00 350.00 378.00 394.00 420.00 440.00 460.00 480.00 512.00 528.00 548.00 500.00 5,310.00
ACEITE X 500ML 5.00 400.00 425.00 445.00 450.00 460.00 475.00 495.00 525.00 550.00 600.00 625.00 650.00 6,100.00
ATUN 3.60 216.00 273.60 295.20 309.60 338.40 403.20 486.00 550.80 576.00 741.60 820.80 871.20 5,882.40
CERVEZA 4.00 600.00 680.00 720.00 760.00 800.00 600.00 892.00 936.00 972.00 1,000.00 1,040.00 960.00 9,960.00
LAVAVAJILLA 1.50 225.00 180.00 187.50 198.00 217.50 150.00 231.00 238.50 240.00 252.00 267.00 277.50 2,664.00
JABON 1.50 75.00 90.00 97.50 105.00 120.00 127.50 135.00 142.50 150.00 165.00 180.00 195.00 1,582.50
SHAMPOO 10.00 950.00 1,000.00 1,240.00 1,350.00 1,450.00 1,550.00 1,650.00 1,750.00 1,850.00 1,950.00 2,000.00 2,300.00 19,040.00
MANTEQUILLA 4.00 320.00 380.00 400.00 460.00 492.00 528.00 568.00 608.00 656.00 712.00 756.00 792.00 6,672.00
PASTA DENTAL 2.00 186.00 240.00 272.00 314.00 328.00 356.00 368.00 394.00 400.00 432.00 440.00 448.00 4,178.00
PAPEL HIGIENICO 1.00 125.00 115.00 132.00 145.00 156.00 165.00 178.00 186.00 195.00 210.00 215.00 226.00 2,048.00
HUEVO XKG 3.20 960.00 1,024.00 1,040.00 1,056.00 1,088.00 640.00 1,120.00 1,136.00 1,120.00 1,168.00 672.00 672.00 11,696.00
PAÑALES 0.60 210.00 132.00 138.00 150.00 156.00 126.00 168.00 174.00 180.00 186.00 150.00 120.00 1,890.00
CHOCOLATES 1.50 150.00 135.00 150.00 172.50 187.50 201.00 213.00 228.00 246.00 261.00 273.00 288.00 2,505.00
DETERGENTES DE 1 KG 4.00 600.00 440.00 480.00 520.00 540.00 580.00 600.00 640.00 728.00 772.00 800.00 840.00 7,540.00
CONSERVAS 4.50 810.00 594.00 639.00 684.00 729.00 765.00 801.00 832.50 855.00 877.50 886.50 967.50 9,441.00
GALLETAS 3.50 385.00 420.00 472.50 507.50 542.50 560.00 577.50 595.00 623.00 637.00 672.00 700.00 6,692.00
HARINA 2.00 300.00 264.00 284.00 304.00 324.00 344.00 368.00 384.00 396.00 400.00 420.00 440.00 4,228.00
CAFÉ 1.50 300.00 180.00 195.00 210.00 225.00 240.00 255.00 270.00 285.00 300.00 322.50 330.00 3,112.50
LEJIAS 1.50 450.00 480.00 472.50 480.00 487.50 360.00 52.50 510.00 517.50 300.00 330.00 375.00 4,815.00
DETERGENTES 360GR 0.80 256.00 264.00 272.00 284.80 288.00 184.00 304.00 312.00 320.00 328.00 240.00 344.00 3,396.80
YOGURT 1.00 200.00 210.00 215.00 220.00 225.00 220.00 235.00 240.00 245.00 250.00 255.00 200.00 2,715.00
FIDEOS TALLARINES 4.00 1,000.00 1,040.00 1,060.00 1,080.00 1,100.00 1,000.00 1,140.00 1,160.00 1,180.00 1,200.00 1,260.00 880.00 13,100.00
FIDEOS DE SOPA 3.50 1,050.00 1,120.00 1,207.50 1,225.00 1,242.50 1,050.00 1,277.50 1,295.00 1,330.00 1,365.00 1,120.00 700.00 13,982.50
TOTAL DE COSTOS 16,528.00 16,928.60 17,724.70 18,431.40 19,018.90 18,386.70 19,906.50 19,461.30 21,040.50 21,266.70 21,133.80 20,837.20 230,664.30
(2) El nivel de costo debe estar de acuerdo a la realidad del negocio y la zona donde se desarrolla el negocio; en el caso de comercio considerar el precio de compra de los productos.
8. GASTOS
¿Cuánto gastaré?
EGRESOS Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 TOTAL
Materia Prima y Mercadería 16,528.00 16,928.60 17,724.70 18,431.40 19,018.90 18,386.70 19,906.50 19,461.30 21,040.50 21,266.70 21,133.80 20,837.20 230,664.30
Mano de Obra* 1,550.00 1,550.00 1,550.00 1,550.00 1,550.00 1,550.00 1,550.00 1,550.00 1,550.00 1,550.00 1,550.00 1,550.00 18,600.00
Costos Indirectos 630.00 630.00 630.00 630.00 630.00 630.00 630.00 630.00 630.00 630.00 630.00 630.00 7,560.00
Gastos de Ventas 75.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00 900.00
Gastos Administrativos 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 15,000.00
TOTAL DE EGRESOS 20,033.00 20,433.60 21,229.70 21,936.40 22,523.90 21,891.70 23,411.50 22,966.30 24,545.50 24,771.70 24,638.80 24,342.20 272,724.30
PRODUCTO VARIOS
ARROZ X KG
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
ARROZ KG 3.20 200 640.00
PRODUCTO VARIOS
AZUCAR X KG
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
AZUCAR KG 2.60 200 520.00
PRODUCTO VARIOS
GASEOSAS
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
GASEOSAS UND 4.50 300 1,350.00
PRODUCTO VARIOS
ACEITE X 500ML
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
LECHE CHICA UND 2.00 300 600.00
PRODUCTO VARIOS
FIDEOS TALLARINES
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
LECHE GRANDE UND 3.50 300 1,050.00
-
-
-
-
Costo Total de MATERIA PRIMA 1050.00
N° de productos costeados 1
Costo Variable Unitario 1050.00
Mano de obra
PRODUCTO VARIOS
LAVAVAJILLA
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
AGUA CHICA UND 1.00 250 250.00
-
-
-
-
Costo Total de MATERIA PRIMA 250.00
N° de productos costeados 1
Costo Variable Unitario 250.00
Mano de obra
-
-
-
-
Costo Total de MATERIA PRIMA 500.00
N° de productos costeados 1
Costo Variable Unitario 500.00
Mano de obra
PRODUCTO VARIOS
0
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
ACEITE X 500ML UND 4.50 100 450.00
PRODUCTO VARIOS
0
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
ATUN UND 3.60 200 720.00
-
-
-
-
Costo Total de MATERIA PRIMA 720.00
N° de productos costeados 1
Costo Variable Unitario 720.00
Mano de obra
PRODUCTO VARIOS
0
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
CERVEZA UND 4.00 250 1,000.00
PRODUCTO VARIOS
0
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
LAVAVAJILLA UND 1.50 100 150.00
-
-
-
-
Costo Total de MATERIA PRIMA 150.00
N° de productos costeados 1
Costo Variable Unitario 150.00
Mano de obra
PRODUCTO VARIOS
0
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
JABON UND 1.50 70 105.00
PRODUCTO VARIOS
0
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
SHAMPOO UND 11.00 80 880.00
PRODUCTO VARIOS
0
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
MANTEQUILLA UND 4.50 40 180.00
PRODUCTO VARIOS
0
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
PASTA DENTAL UND 2.00 60 120.00
-
-
-
-
Costo Total de MATERIA PRIMA 120.00
N° de productos costeados 1
Costo Variable Unitario 120.00
Mano de obra
PRODUCTO VARIOS
0
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
PAPEL HIGIENCIO UND 1.00 150 150.00
-
-
-
-
Costo Total de MATERIA PRIMA 150.00
N° de productos costeados 1
Costo Variable Unitario 150.00
Mano de obra
PRODUCTO VARIOS
0
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
HUEVO X KG KG 3.50 50 175.00
-
-
-
-
Costo Total de MATERIA PRIMA 175.00
N° de productos costeados 1
Costo Variable Unitario 175.00
Mano de obra
PRODUCTO VARIOS
0
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
PAÑALES UND 0.60 90 54.00
-
-
-
-
Costo Total de MATERIA PRIMA 54.00
N° de productos costeados 1
Costo Variable Unitario 54.00
Mano de obra
Costo Total de MANO DE OBRA -
COSTO VARIABLE UNITARIO - PRODUCTO 1 54.00
PRODUCTO VARIOS
0
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
CHOCOLATES UND 1.50 100 150.00
-
-
-
-
Costo Total de MATERIA PRIMA 150.00
N° de productos costeados 1
Costo Variable Unitario 150.00
Mano de obra
PRODUCTO VARIOS
0
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
DETERGENTES X 1 KG UND 4.00 100 400.00
-
-
-
-
Costo Total de MATERIA PRIMA 400.00
N° de productos costeados 1
Costo Variable Unitario 400.00
Mano de obra
-
-
-
-
Costo Total de MATERIA PRIMA 440.00
N° de productos costeados 1
Costo Variable Unitario 440.00
Mano de obra
PRODUCTO VARIOS
0
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
GALLETAS UND 1.50 100 150.00
-
-
-
-
Costo Total de MATERIA PRIMA 150.00
N° de productos costeados 1
Costo Variable Unitario 150.00
Mano de obra
PRODUCTO VARIOS
0
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
HARINA UND 2.00 40 80.00
-
-
-
-
Costo Total de MATERIA PRIMA 80.00
N° de productos costeados 1
Costo Variable Unitario 80.00
Mano de obra
PRODUCTO VARIOS
0
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
CAFÉ UND 1.50 40 60.00
-
-
-
-
Costo Total de MATERIA PRIMA 60.00
N° de productos costeados 1
Costo Variable Unitario 60.00
Mano de obra
PRODUCTO VARIOS
0
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
LEJIAS UND 1.50 40 60.00
-
-
-
-
Costo Total de MATERIA PRIMA 60.00
N° de productos costeados 1
Costo Variable Unitario 60.00
Mano de obra
PRODUCTO VARIOS
0
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
DETERGENTES X 360 GR UND 0.80 40 32.00
-
-
-
-
Costo Total de MATERIA PRIMA 32.00
N° de productos costeados 1
Costo Variable Unitario 32.00
Mano de obra
PRODUCTO VARIOS
0
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
YOGURT UND 1.00 150 150.00
-
-
-
-
Costo Total de MATERIA PRIMA 150.00
N° de productos costeados 1
Costo Variable Unitario 150.00
Mano de obra
PRODUCTO VARIOS
0
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
FIDEOS TALLARINES UND 4.00 100 400.00
-
-
-
-
Costo Total de MATERIA PRIMA 400.00
N° de productos costeados 1
Costo Variable Unitario 400.00
Mano de obra
PRODUCTO VARIOS
0
Cantidad a Costear: 1
PRECIO CANTIDAD
Materia Prima / Mercadería Unidad de Medida TOTAL
UNITARIO REQUERIDA
FIDEOS DE SOPA UND 3.50 40 140.00
-
-
-
-
Costo Total de MATERIA PRIMA 140.00
N° de productos costeados 1
Costo Variable Unitario 140.00
Mano de obra
ACTIVO FIJO S/. 10,462.00 S/. 2,553.00 S/. 3,234.00 S/. - S/. 2,700.00 S/. -
Terrenos / Infraestructura S/. 1,700.00 S/. 1,100.00 S/. - S/. - S/. - S/. -
PINTURA 350.00 1 350.00 350.00 0.00 0.00 0.00 0.00
SISTEMA DE SEGURIDAD 600.00 1 600.00 0.00 0.00 0.00 0.00 0.00
CAMARAS 250.00 3 750.00 750.00 0.00 0.00 0.00 0.00
Maquinarias y Equipos S/. 2,000.00 S/. - S/. 1,000.00 S/. - S/. - S/. -
GAVETAS 300.00
2.00 1 300.00 0.00 300.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
CONGELADOR 1000.00 1 1000.00 0.00 0.00 0.00 0.00 0.00
LECTOR CODIGO DE BARRA 300.00 1 300.00 0.00 300.00 0.00 0.00 0.00
MOSTRADOR 300.00 2 600.00 0.00 600.00 0.00 0.00
ANAQUELES 100.00 2 200.00 0.00 0.00 0.00 200.00 0.00
GASTOS PRE-OPERATIVOS S/. 1,165.00 S/. 1,165.00 S/. - S/. - S/. - S/. -
GASTOS DE TRAMITES EXTRAS 100.00 1 100.00 100.00 0.00 0.00 0.00 0.00
LICENCIA DE FUNCIONAMIENTO 1000.00 1 1000.00 1000.00 0.00 0.00 0.00 0.00
PLAN DE NEGOCIOS 15.00 1 15.00 15.00 0.00 0.00 0.00 0.00
TRAMITE DE LA SUNAT 50.00 1 50.00 50.00 0.00 0.00 0.00 0.00
CAPITAL DE TRABAJO S/. 12,931.00 S/. 10,881.00 S/. - S/. - S/. 1,565.00 S/. -
Materia Prima / Mercadería S/. 9,426.00 S/. 9,426.00 S/. - S/. - S/. - S/. -
ARROZ X KG 3.20 100 320.00 320.00 0.00 0.00 0.00 0.00
AZUCAR X KG 2.60 100 260.00 260.00 0.00 0.00 0.00 0.00
FRUGOS X CJA 3.00 10 30.00 30.00 0.00 0.00 0.00 0.00
GASEOSAS 4.50 100 450.00 450.00 0.00 0.00 0.00 0.00
LECHE CHICA 2.00 100 200.00 200.00 0.00 0.00 0.00 0.00
LECHE GRANDE 3.50 100 350.00 350.00 0.00 0.00 0.00 0.00
AGUA CHICA 1.00 150 150.00 150.00 0.00 0.00 0.00 0.00
AGUA GRANDE 2.00 130 260.00 260.00 0.00 0.00 0.00 0.00
ACEITE X 500 ML 4.50 140 630.00 630.00 0.00 0.00 0.00 0.00
ATUN 3.60 140 504.00 504.00 0.00 0.00 0.00 0.00
CERVEZA 4.00 150 600.00 600.00 0.00 0.00 0.00 0.00
LAVAVAJILLA 1.50 100 150.00 150.00 0.00 0.00 0.00 0.00
JABON 1.50 50 75.00 75.00 0.00 0.00 0.00 0.00
SHAMPOO 11.00 100 1100.00 1100.00 0.00 0.00 0.00 0.00
MANTEQUILLA 4.50 80 360.00 360.00 0.00 0.00 0.00 0.00
PASTA DENTAL 2.00 90 180.00 180.00 0.00 0.00 0.00 0.00
PAPEL HIGIENICOS 1.00 100 100.00 100.00 0.00 0.00 0.00 0.00
HUEVO X KG 3.50 140 490.00 490.00 0.00 0.00 0.00 0.00
PAÑALES 0.60 120 72.00 72.00 0.00 0.00 0.00 0.00
CHOCOLATES 1.50 110 165.00 165.00 0.00 0.00 0.00 0.00
DETERGENTES X 1 KG 4.00 200 800.00 800.00 0.00 0.00 0.00 0.00
CONSERVAS 5.50 70 385.00 385.00 0.00 0.00 0.00 0.00
GALLETAS 1.50 60 90.00 90.00 0.00 0.00 0.00 0.00
HARINA 2.00 50 100.00 100.00 0.00 0.00 0.00 0.00
CAFÉ 1.50 95 142.50 142.50 0.00 0.00 0.00 0.00
LEJIAS 1.50 85 127.50 127.50 0.00 0.00 0.00 0.00
DETERGENTES X 360 GR 0.80 100 80.00 80.00 0.00 0.00 0.00 0.00
YOGURT 1.00 130 130.00 130.00 0.00 0.00 0.00 0.00
FIDEOS TALLARINES 4.00 150 600.00 600.00 0.00 0.00 0.00 0.00
FIDEOS DE SOPA 3.50 150 525.00 525.00 0.00 0.00 0.00 0.00
Mano de Obra S/. 1,550.00 S/. 750.00 S/. - S/. - S/. - S/. -
CAJERO 750.00 1 750.00 750.00 0.00 0.00 0.00 0.00
ADMINISTRADOR 800.00 1 800.00 800.00 0.00 0.00 0.00 0.00
Costos Indirectos S/. 630.00 S/. 630.00 S/. - S/. - S/. 315.00 S/. -
LUZ 200.00 1 200.00 200.00 0.00 0.00 10.00 0.00
AGUA 180.00 1 180.00 180.00 0.00 0.00 5.00 0.00
SERVICIOS 250.00 1 250.00 250.00 0.00 0.00 300.00 0.00
Gastos de Ventas S/. 75.00 S/. 75.00 S/. - S/. - S/. - S/. -
VOLANTES X MILLAR 30.00 1 30.00 30.00 0.00 0.00 0.00 0.00
BOLSAS PLASTICAS X ROLLO 15.00 3 45.00 45.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
Gastos Administrativos S/. 1,250.00 S/. - S/. - S/. - S/. 1,250.00 S/. -
UTILES DE OFICINA 250.00 1 250.00 0.00 0.00 0.00 250.00 0.00
SUELDO DEL DUEÑO 1000.00 1 1000.00 0.00 0.00 0.00 1000.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
TOTAL 24,558.00 14,599.00 3,234.00 0.00 4,265.00 0.00
17,833.00
10. INVERSION REQUERIDA
¿Cuánto debo invertir?
CONCEPTO MES 0 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 TOTAL
INGRESOS
Ventas 20,923.00 22,098.50 22,538.00 23,497.00 24,007.50 24,187.50 24,972.50 25,334.50 26,926.60 26,317.40 27,733.90 27,317.50 295,853.90
TOTAL INGRESOS (A) 20,923.00 22,098.50 22,538.00 23,497.00 24,007.50 24,187.50 24,972.50 25,334.50 26,926.60 26,317.40 27,733.90 27,317.50 295,853.90
EGRESOS
Terreno y/o Infraestructura 1,700.00 1,700.00
Maquinaria y Equipo 2,000.00 2,000.00
Herramientas 312.00 312.00
Muebles y Enseres 6,450.00 6,450.00
Gastos Pre - Operativos 1,165.00 1,165.00
Materia Prima / Mercadería 16,528.00 16,928.60 17,724.70 18,431.40 19,018.90 18,386.70 19,906.50 19,461.30 21,040.50 21,266.70 21,133.80 20,837.20 230,664.30
Mano de Obra 1,550.00 1,550.00 1,550.00 1,550.00 1,550.00 1,550.00 1,550.00 1,550.00 1,550.00 1,550.00 1,550.00 1,550.00 18,600.00
Costos Indirectos 630.00 630.00 630.00 630.00 630.00 630.00 630.00 630.00 630.00 630.00 630.00 630.00 7,560.00
Gastos de Ventas 75.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00 900.00
Gastos Administrativos 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 15,000.00
Impuestos RUS / RER / RG 313.85 331.48 338.07 352.46 360.11 362.81 374.59 380.02 403.90 394.76 416.01 409.76 4,437.81
TOTAL EGRESOS (B) 11,627.00 20,346.85 20,765.08 21,567.77 22,288.86 22,884.01 22,254.51 23,786.09 23,346.32 24,949.40 25,166.46 25,054.81 24,751.96 288,789.11
Saldo Económico (A) - (B) = C -11,627.00 576.15 1,333.42 970.23 1,208.15 1,123.49 1,932.99 1,186.41 1,988.18 1,977.20 1,150.94 2,679.09 2,565.54 7,064.79
Prestamo 4,666.02
Amortizacion S/. 366.67 S/. 370.56 S/. 374.49 S/. 378.46 S/. 382.47 S/. 386.53 S/. 390.63 S/. 394.78 S/. 398.96 S/. 403.20 S/. 407.47 S/. 411.80
Interes S/. 49.50 S/. 45.61 S/. 41.68 S/. 37.71 S/. 33.69 S/. 29.63 S/. 25.53 S/. 21.39 S/. 17.20 S/. 12.97 S/. 8.69 S/. 4.37
Fujo de caja Financiero -6,960.98 S/. 159.99 S/. 917.26 S/. 554.06 S/. 791.98 S/. 707.32 S/. 1,516.82 S/. 770.25 S/. 1,572.02 S/. 1,561.03 S/. 734.77 S/. 2,262.93 S/. 2,149.37
SALDO ACUMULADO -6,960.98 -6,800.99 -5,883.73 -5,329.67 -4,537.69 -3,830.37 -2,313.55 -1,543.30 28.71 1,589.75 2,324.52 4,587.45 6,736.82
12. UTILIDAD
¿Podré ganar? ¿Cuánto? ¿En cuánto tiempo?
§ A cuántos meses de iniciado el negocio los ingresos superan los egresos: 7 mes / o a partir de qué mes puedo comenzar a cobrar un sueldo?
13. RENTABILIDAD
¿Será rentable mi proyecto?¿Cuán rentable será?
Rentabilidad = 58%
COK 7.5%
FINANCIERO ECONOMICO
VNA S/. 7,897.32 VNA S/. 11,116.48
VAN S/. 936.34 VAN S/. -510.52
TIR 9% TIR 6.79%
B/C 0.68 B/C S/. 0.96
BENEFICIOS COSTO
CUOTA
CUOTA
INVERSION 24,558.00
S/. 416.17 Financiamiento Bancario 4666.02
S/. 416.17 Financiamiento de Accionistas 19891.98
S/. 416.17 Plazo 12
S/. 416.17 TEA 13.50%
S/. 416.17 TEM 1.06%
S/. 416.17 MI BANCO
S/. 416.17 TIEA 0.20
S/. 416.17
S/. 416.17
S/. 416.17
S/. 416.17
S/. 416.17
S/. 4,993.99
100%
19%
81%
MESES
ANUAL
MENSUAL
TEAM 1.06%