Trabajo

ESTUDIO FINANCIERO

Proyecciones de ventas. Colombia Soul iniciará una producción mensual de 300 prendas distribuidas asi: 100 Bermudas, 100 shorts, 50 camisetas bordadas y 50 estampadas.
CUADROPOYECCIONES

PROYECCION CAMISETAS |
  | | | | | | | |   |
CAMISETAS B Y E | 57228 | | COSTO/(1-0.5%) | V/COST. 28.614/0.5) | |   |
MARGEN BRUTO | 50% | | | | | | |   |VENTAS | 100 | | | | | | |   |
COSTOS FIJOS | 1637000 | | COSTOS FIJOS (ADM 12.253+IND 4.117 X 100) |   |
COSTOS PCION | 12244 | | | | | | |   |
  | | | | | | | |   |
INGRESOS |5722800 | | 2861400 | 20% | 35% | 40% | 45% | 50% |
COSTO PCION | 1224400 | | 10 | -1187160 | -1187160 | -1187160 | -1187160 | -1187160 |
UTILID BRUTA | 4498400 | | 35 | -62560 | -62560 |-62560 | -62560 | -62560 |
COST ADMI | 1637000 | | 45 | 387280 | 387280 | 387280 | 387280 | 387280 |
UTILIID NETA | 2861400 | | 65 | 1286960 | 1286960 | 1286960 | 1286960 | 1286960 |
  | | | 75| 1736800 | 1736800 | 1736800 | 1736800 | 1736800 |
  | | | 85 | 2186640 | 2186640 | 2186640 | 2186640 | 2186640 |
  | | | 90 | 2411560 | 2411560 | 2411560 | 2411560 | 2411560 |
  |   |   |100 | 2861400 | 2861400 | 2861400 | 2861400 | 2861400 |

PROYECCION SHORT |
  | | | | | | | |   |
SHORT | 38064 | | COSTO/(1-0.5%) | V/COST. 19.032 | |   |
MARGEN BRUTO | 50% | | || | | |   |
VENTAS | 100 | | | | | | |   |
COSTOS FIJOS | 1637000 | | COSTOS FIJOS (ADM 12.253+IND 4.117 X 100) |   |
COSTOS PCION | 2662 | | | | | | |   |
  | | | | | || |   |
INGRESOS | 3806400 | | 1903200 | 20% | 35% | 40% | 45% | 50% |
COSTO PCION | 266200 | | 10 | -1282980 | -1282980 | -1282980 | -1282980 | -1282980 |
UTILID BRUTA | 3540200 | | 35 |-397930 | -397930 | -397930 | -397930 | -397930 |
COST ADMI | 1637000 | | 45 | -43910 | -43910 | -43910 | -43910 | -43910 |
UTILIID NETA | 1903200 | | 55 | 310110 | 310110 | 310110 | 310110 |...