Page 6 - UNIDAD II

Ejercicio #2 Grafique
Margen de contribucion 1645.8664 0.691434058 69.1434058
Datos PE= 95.39048856 Unidades
PE= $ 227,064.31
P $ 2,052.04 MAS IVA $ 328.33 $ 2,380.37
CV $ 734.50 ESTADO DE RESULTADO CONDENSADO
CF $ 157,000.00 SEMANALES IT $ 227,064.31
CVT $ 70,064.31
MCT $ 157,000.00
CF $ 157,000.00
PE $ -
UNIDADES PERIODO INGRESO TOTAL CV TOTAL MARGEN DE CONTRIBUCION COSTOS FIJOS PERDIDA EQUILIBRIO UTILIDAD COSTOS TOTALES
88 SEMANA 1 $ 209,472.24 $ 64,636.00 $ 144,836.24 $ 157,000.00 -$ 12,163.76 $ 221,636.00
90 SEMANA 2 $ 214,232.98 $ 66,105.00 $ 148,127.98 $ 157,000.00 -$ 8,872.02 $ 223,105.00
93 SEMANA 3 $ 221,374.08 $ 68,308.50 $ 153,065.58 $ 157,000.00 -$ 3,934.42 $ 225,308.50
94 SEMANA 4 $ 223,754.44 $ 69,043.00 $ 154,711.44 $ 157,000.00 -$ 2,288.56 $ 226,043.00
95.39048856 EQUILIBRIO $ 227,064.31 $ 70,064.31 $ 157,000.00 $ 157,000.00 $ - $ 227,064.31
98 SEMANA 5 $ 233,275.91 $ 71,981.00 $ 161,294.91 $ 157,000.00 $ 4,294.91 $ 228,981.00
100 SEMANA 6 $ 238,036.64 $ 73,450.00 $ 164,586.64 $ 157,000.00 $ 7,586.64 $ 230,450.00
101 SEMANA 7 $ 240,417.01 $ 74,184.50 $ 166,232.51 $ 157,000.00 $ 9,232.51 $ 231,184.50
103 SEMANA 8 $ 245,177.74 $ 75,653.50 $ 169,524.24 $ 157,000.00 $ 12,524.24 $ 232,653.50
102 SEMANA 9 $ 242,797.37 $ 74,919.00 $ 167,878.37 $ 157,000.00 $ 10,878.37 $ 231,919.00
105 SEMANA 10 $ 249,938.47 $ 77,122.50 $ 172,815.97 $ 157,000.00 $ 15,815.97 $ 234,122.50
110 SEMANA 11 $ 261,840.30 $ 80,795.00 $ 181,045.30 $ 157,000.00 $ 24,045.30 $ 237,795.00
11 SEMANA 12 $ 26,184.03 $ 8,079.50 $ 18,104.53 $ 157,000.00 -$ 138,895.47 $ 165,079.50
112 SEMANA 13 $ 266,601.04 $ 82,264.00 $ 184,337.04 $ 157,000.00 $ 27,337.04 $ 239,264.00
115 SEMANA 14 $ 273,742.14 $ 84,467.50 $ 189,274.64 $ 157,000.00 $ 32,274.64 $ 241,467.50
120 SEMANA 15 $ 285,643.97 $ 88,140.00 $ 197,503.97 $ 157,000.00 $ 40,503.97 $ 245,140.00
123 SEMANA 16 $ 292,785.07 $ 90,343.50 $ 202,441.57 $ 157,000.00 $ 45,441.57 $ 247,343.50
127 SEMANA 17 $ 302,306.53 $ 93,281.50 $ 209,025.03 $ 157,000.00 $ 52,025.03 $ 250,281.50
130 SEMANA 18 $ 309,447.63 $ 95,485.00 $ 213,962.63 $ 157,000.00 $ 56,962.63 $ 252,485.00
131 SEMANA 19 $ 311,828.00 $ 96,219.50 $ 215,608.50 $ 157,000.00 $ 58,608.50 $ 253,219.50
135 SEMANA 20 $ 321,349.46 $ 99,157.50 $ 222,191.96 $ 157,000.00 $ 65,191.96 $ 256,157.50
138 SEMANA 21 $ 328,490.56 $ 101,361.00 $ 227,129.56 $ 157,000.00 $ 70,129.56 $ 258,361.00
140 SEMANA 22 $ 333,251.30 $ 102,830.00 $ 230,421.30 $ 157,000.00 $ 73,421.30 $ 259,830.00
144 SEMANA 23 $ 342,772.76 $ 105,768.00 $ 237,004.76 $ 157,000.00 $ 80,004.76 $ 262,768.00
147 SEMANA 24 $ 349,913.86 $ 107,971.50 $ 241,942.36 $ 157,000.00 $ 84,942.36 $ 264,971.50
149 SEMANA 25 $ 354,674.59 $ 109,440.50 $ 245,234.09 $ 157,000.00 $ 88,234.09 $ 266,440.50
142 SEMANA 26 $ 338,012.03 $ 104,299.00 $ 233,713.03 $ 157,000.00 $ 76,713.03 $ 261,299.00
143 SEMANA 27 $ 340,392.40 $ 105,033.50 $ 235,358.90 $ 157,000.00 $ 78,358.90 $ 262,033.50
144 SEMANA 28 $ 342,772.76 $ 105,768.00 $ 237,004.76 $ 157,000.00 $ 80,004.76 $ 262,768.00
149 SEMANA 29 $ 354,674.59 $ 109,440.50 $ 245,234.09 $ 157,000.00 $ 88,234.09 $ 266,440.50
148 SEMANA 30 $ 352,294.23 $ 108,706.00 $ 243,588.23 $ 157,000.00 $ 86,588.23 $ 265,706.00
150 SEMANA 31 $ 357,054.96 $ 110,175.00 $ 246,879.96 $ 157,000.00 $ 89,879.96 $ 267,175.00
151 SEMANA 32 $ 359,435.33 $ 110,909.50 $ 248,525.83 $ 157,000.00 $ 91,525.83 $ 267,909.50
152 SEMANA 33 $ 361,815.69 $ 111,644.00 $ 250,171.69 $ 157,000.00 $ 93,171.69 $ 268,644.00
160 SEMANA 34 $ 380,858.62 $ 117,520.00 $ 263,338.62 $ 157,000.00 $ 106,338.62 $ 274,520.00
168 SEMANA 35 $ 399,901.56 $ 123,396.00 $ 276,505.56 $ 157,000.00 $ 119,505.56 $ 280,396.00
170 SEMANA 36 $ 404,662.29 $ 124,865.00 $ 279,797.29 $ 157,000.00 $ 122,797.29 $ 281,865.00
176 SEMANA 37 $ 418,944.49 $ 129,272.00 $ 289,672.49 $ 157,000.00 $ 132,672.49 $ 286,272.00
177 SEMANA 38 $ 421,324.85 $ 130,006.50 $ 291,318.35 $ 157,000.00 $ 134,318.35 $ 287,006.50
179 SEMANA 39 $ 426,085.59 $ 131,475.50 $ 294,610.09 $ 157,000.00 $ 137,610.09 $ 288,475.50
180 SEMANA 40 $ 428,465.95 $ 132,210.00 $ 296,255.95 $ 157,000.00 $ 139,255.95 $ 289,210.00
190 SEMANA 41 $ 452,269.62 $ 139,555.00 $ 312,714.62 $ 157,000.00 $ 155,714.62 $ 296,555.00
191 SEMANA 42 $ 454,649.98 $ 140,289.50 $ 314,360.48 $ 157,000.00 $ 157,360.48 $ 297,289.50
193 SEMANA 43 $ 459,410.72 $ 141,758.50 $ 317,652.22 $ 157,000.00 $ 160,652.22 $ 298,758.50
195 SEMANA 44 $ 464,171.45 $ 143,227.50 $ 320,943.95 $ 157,000.00 $ 163,943.95 $ 300,227.50
193 SEMANA 45 $ 459,410.72 $ 141,758.50 $ 317,652.22 $ 157,000.00 $ 160,652.22 $ 298,758.50
192 SEMANA 46 $ 457,030.35 $ 141,024.00 $ 316,006.35 $ 157,000.00 $ 159,006.35 $ 298,024.00
190 SEMANA 47 $ 452,269.62 $ 139,555.00 $ 312,714.62 $ 157,000.00 $ 155,714.62 $ 296,555.00
196 SEMANA 48 $ 466,551.81 $ 143,962.00 $ 322,589.81 $ 157,000.00 $ 165,589.81 $ 300,962.00
193 SEMANA 49 $ 459,410.72 $ 141,758.50 $ 317,652.22 $ 157,000.00 $ 160,652.22 $ 298,758.50
198 SEMANA 50 $ 471,312.55 $ 145,431.00 $ 325,881.55 $ 157,000.00 $ 168,881.55 $ 302,431.00
199 SEMANA 51 $ 473,692.91 $ 146,165.50 $ 327,527.41 $ 157,000.00 $ 170,527.41 $ 303,165.50
200 SEMANA 52 $ 476,073.28 $ 146,900.00 $ 329,173.28 $ 157,000.00 $ 172,173.28 $ 303,900.00