¡Descarga Optimización de la Rentabilidad de Computadoras Personales Kayo y más Tesis en PDF de Sistemas de Información Gerencial solo en Docsity!
Apex Manufacturing Cantidad TCI Precio Unitario ($)
<= 2000 200
2000 160
TCI Electronics Diseño de Ingeniería ($) Precio Unitario ($) 100000 120
Kayo Computer
Materia Prima 1500000
Montaje Unitario 450 PVP Computador 1000
Proveedor Número vendidos PVP Computador ($) Appex 1000 1000
TCI 4000 1000
Productos Ganancia Total ($) Costos Adicionales TCI ($)
Appex 350000 0
TCI 1720000 100000
Total ( - ) Costos Fijos Ganancia Neta
En una hoja de cálculo electrónica construya un modelo que muestre la rentabilidad de las computadoras personales Kayo durante el próximo año. Para empezar, suponga que será posible vender 5000 computadoras el año próximo y que sólo se comprarán 1000 TCI de Apex (el resto será suministrado por la TCI).
Apex Manufacturing Datos Pregunta 2 Cantidad TCI Precio Unitario ($) Ventas Totales 5000
<= 2000 200.
2000 160.
TCI Electronics Precio Unitario ($) 100,000.00 120.
Kayo Computer
Materia Prima 1,500,000.
Montaje Unitario 450. PVP Computador 1,000.
Situación Óptima
Productos Número vendidos PVP Computador Apex 0 1,000. TCI 5,000 1,000.
Productos Ganancia Apex - - TCI 2,150,000.00 100,000.
Total ( - ) Costos Fijos Ganancia Neta
Cantidad TCI Costo Unitario ($) (^) Precio Total por los TCI
Apex TCI Electronics Apex TCI Electronics Apex
0 5,000 200.00 120.00 - 100 4,900 200.00 120.00 20,000. 200 4,800 200.00 120.00 40,000. 300 4,700 200.00 120.00 60,000. 400 4,600 200.00 120.00 80,000. 500 4,500 200.00 120.00 100,000. 600 4,400 200.00 120.00 120,000. 700 4,300 200.00 120.00 140,000. 800 4,200 200.00 120.00 160,000. 900 4,100 200.00 120.00 180,000.
Si las ventas totales fueran 5000 unidades,¿cuántosTCI le re- comendaría usted a Kayo que le comprara a Apex y cuántos a la TCI, para maximizar las ganancias del año entrante? (Use una Tabla de datos como ayuda para encontrar la recomendación de su preferencia.)
Diseño de Ingeniería ($)
Costos Adicionales TCI
Costo Total Ventas Totales Ganancia Neta
Apex Manufacturing Datos Pregunta 3 Cantidad TCI Precio Unitario ($) Ventas Totales
<= 2000 200. Indemnizació n Apex
2000 160.
TCI Electronics Diseño de Ingeniería ($) Precio Unitario ($) 100,000.00 120.
Kayo Computer Materia Prima 1,500,000.
Montaje Unitario 450.
PVP Computador 1,000.
Cantidad TCI Costo Unitario ($)
Apex TCI Electronics Apex TCI Electronics
0 5,000 200.00 120. 100 4,900 200.00 120. 200 4,800 200.00 120. 300 4,700 200.00 120. 400 4,600 200.00 120. 500 4,500 200.00 120. 600 4,400 200.00 120. 700 4,300 200.00 120. 800 4,200 200.00 120. 900 4,100 200.00 120. 1,000 4,000 200.00 120. 1,100 3,900 200.00 120. 1,200 3,800 200.00 120. 1,300 3,700 200.00 120. 1,400 3,600 200.00 120. 1,500 3,500 200.00 120. 1,600 3,400 200.00 120. 1,700 3,300 200.00 120. 1,800 3,200 200.00 120. 1,900 3,100 200.00 120. 2,000 3,000 200.00 120. 2,100 2,900 160.00 120. 2,200 2,800 160.00 120. 2,300 2,700 160.00 120. 2,400 2,600 160.00 120. 2,500 2,500 160.00 120. 2,600 2,400 160.00 120. 2,700 2,300 160.00 120.
Al revisar el contrato de Apex, observa usted que Kayo está obligada a comprarle a esa firma por lo menos 20% de los TC en las computadoras Kayo que venda (pero no po- drán ser menos de 1000 TCI). El contrato incluye también una cláusul establece una indemnización por daños si Kayo no paga los $100,000 convenidos. En caso de que fuera posible vende computadoras Kayo el año próximo, ¿cuál sería el efecto económico si Kayo no cumpliera con la disposición de compra mínim contratada, de 20%/1000, por cambios imprevistos (que la obligaran a usar más tableros de la TCI)? Suponiendo que Ape dispuesta a renegociar el contrato, ¿qué nuevas condiciones y/o qué monto de ajuste máximo le recomendaría usted a Silk p negociaciones con Apex? Justifique su recomendación con los anexos pertinentes en hojas de cálculo.
Datos Pregunta 3 otales 5, Cantidad Multa < 20% 5000 = 1000 100,000.
Precio Total por los TCI ($) Costo Total TCI ($)^ Costo Montaje ($) Apex TCI Electronics
- 600,000.00 100,000.00 700,000.00 2,250,000. 20,000.00 588,000.00 100,000.00 708,000.00 2,250,000. 40,000.00 576,000.00 100,000.00 716,000.00 2,250,000. 60,000.00 564,000.00 100,000.00 724,000.00 2,250,000. 80,000.00 552,000.00 100,000.00 732,000.00 2,250,000. 100,000.00 540,000.00 100,000.00 740,000.00 2,250,000. 120,000.00 528,000.00 100,000.00 748,000.00 2,250,000. 140,000.00 516,000.00 100,000.00 756,000.00 2,250,000. 160,000.00 504,000.00 100,000.00 764,000.00 2,250,000. 180,000.00 492,000.00 100,000.00 772,000.00 2,250,000. 200,000.00 480,000.00 100,000.00 780,000.00 2,250,000. 220,000.00 468,000.00 100,000.00 788,000.00 2,250,000. 240,000.00 456,000.00 100,000.00 796,000.00 2,250,000. 260,000.00 444,000.00 100,000.00 804,000.00 2,250,000. 280,000.00 432,000.00 100,000.00 812,000.00 2,250,000. 300,000.00 420,000.00 100,000.00 820,000.00 2,250,000. 320,000.00 408,000.00 100,000.00 828,000.00 2,250,000. 340,000.00 396,000.00 100,000.00 836,000.00 2,250,000. 360,000.00 384,000.00 100,000.00 844,000.00 2,250,000. 380,000.00 372,000.00 100,000.00 852,000.00 2,250,000. 400,000.00 360,000.00 100,000.00 860,000.00 2,250,000. 336,000.00 348,000.00 100,000.00 784,000.00 2,250,000. 352,000.00 336,000.00 100,000.00 788,000.00 2,250,000. 368,000.00 324,000.00 100,000.00 792,000.00 2,250,000. 384,000.00 312,000.00 100,000.00 796,000.00 2,250,000. 400,000.00 300,000.00 100,000.00 800,000.00 2,250,000. 416,000.00 288,000.00 100,000.00 804,000.00 2,250,000. 432,000.00 276,000.00 100,000.00 808,000.00 2,250,000.
á e a esa firma por lo menos 20% de los TCI incluidos á CI). El contrato incluye también una cláusula que óñ dos. En caso de que fuera posible vender 5000 ñ ó á íó mpliera con la disposición de compra mínima á tableros de la TCI)? Suponiendo que Apex estuviera éé uste máximo le recomendaría usted a Silk para sus ó exos pertinentes en hojas de cálculo.
Costos Adicionales TCI ($)
- 1,000 4,000 200.00 120.00 200,000.
- 1,100 3,900 200.00 120.00 220,000.
- 1,200 3,800 200.00 120.00 240,000.
- 1,300 3,700 200.00 120.00 260,000.
- 1,400 3,600 200.00 120.00 280,000.
- 1,500 3,500 200.00 120.00 300,000.
- 1,600 3,400 200.00 120.00 320,000.
- 1,700 3,300 200.00 120.00 340,000.
- 1,800 3,200 200.00 120.00 360,000.
- 1,900 3,100 200.00 120.00 380,000.
- 2,000 3,000 200.00 120.00 400,000.
- 2,100 2,900 160.00 120.00 336,000.
- 2,200 2,800 160.00 120.00 352,000.
- 2,300 2,700 160.00 120.00 368,000.
- 2,400 2,600 160.00 120.00 384,000.
- 2,500 2,500 160.00 120.00 400,000.
- 2,600 2,400 160.00 120.00 416,000.
- 2,700 2,300 160.00 120.00 432,000.
- 2,800 2,200 160.00 120.00 448,000.
- 2,900 2,100 160.00 120.00 464,000.
- 3,000 2,000 160.00 120.00 480,000.
- 3,100 1,900 160.00 120.00 496,000.
- 3,200 1,800 160.00 120.00 512,000.
- 3,300 1,700 160.00 120.00 528,000.
- 3,400 1,600 160.00 120.00 544,000.
- 3,500 1,500 160.00 120.00 560,000.
- 3,600 1,400 160.00 120.00 576,000.
- 3,700 1,300 160.00 120.00 592,000.
- 3,800 1,200 160.00 120.00 608,000.
- 3,900 1,100 160.00 120.00 624,000.
- 4,000 1,000 160.00 120.00 640,000.
- 4,100 900 160.00 120.00 656,000.
- 4,200 800 160.00 120.00 672,000.
- 4,300 700 160.00 120.00 688,000.
- 4,400 600 160.00 120.00 704,000.
- 4,500 500 160.00 120.00 720,000.
- 4,600 400 160.00 120.00 736,000.
- 4,700 300 160.00 120.00 752,000.
- 4,800 200 160.00 120.00 768,000.
- 4,900 100 160.00 120.00 784,000.
- 5,000 0 160.00 120.00 800,000.
- 480,000.00 100,000.00 780,000.00 2,250,000.00 1,500,000.
- 468,000.00 100,000.00 788,000.00 2,250,000.00 1,500,000.
- 456,000.00 100,000.00 796,000.00 2,250,000.00 1,500,000.
- 444,000.00 100,000.00 804,000.00 2,250,000.00 1,500,000.
- 432,000.00 100,000.00 812,000.00 2,250,000.00 1,500,000.
- 420,000.00 100,000.00 820,000.00 2,250,000.00 1,500,000.
- 408,000.00 100,000.00 828,000.00 2,250,000.00 1,500,000.
- 396,000.00 100,000.00 836,000.00 2,250,000.00 1,500,000.
- 384,000.00 100,000.00 844,000.00 2,250,000.00 1,500,000.
- 372,000.00 100,000.00 852,000.00 2,250,000.00 1,500,000.
- 360,000.00 100,000.00 860,000.00 2,250,000.00 1,500,000.
- 348,000.00 100,000.00 784,000.00 2,250,000.00 1,500,000.
- 336,000.00 100,000.00 788,000.00 2,250,000.00 1,500,000.
- 324,000.00 100,000.00 792,000.00 2,250,000.00 1,500,000.
- 312,000.00 100,000.00 796,000.00 2,250,000.00 1,500,000.
- 300,000.00 100,000.00 800,000.00 2,250,000.00 1,500,000.
- 288,000.00 100,000.00 804,000.00 2,250,000.00 1,500,000.
- 276,000.00 100,000.00 808,000.00 2,250,000.00 1,500,000.
- 264,000.00 100,000.00 812,000.00 2,250,000.00 1,500,000.
- 252,000.00 100,000.00 816,000.00 2,250,000.00 1,500,000.
- 240,000.00 100,000.00 820,000.00 2,250,000.00 1,500,000.
- 228,000.00 100,000.00 824,000.00 2,250,000.00 1,500,000.
- 216,000.00 100,000.00 828,000.00 2,250,000.00 1,500,000.
- 204,000.00 100,000.00 832,000.00 2,250,000.00 1,500,000.
- 192,000.00 100,000.00 836,000.00 2,250,000.00 1,500,000.
- 180,000.00 100,000.00 840,000.00 2,250,000.00 1,500,000.
- 168,000.00 100,000.00 844,000.00 2,250,000.00 1,500,000.
- 156,000.00 100,000.00 848,000.00 2,250,000.00 1,500,000.
- 144,000.00 100,000.00 852,000.00 2,250,000.00 1,500,000.
- 132,000.00 100,000.00 856,000.00 2,250,000.00 1,500,000.
- 120,000.00 100,000.00 860,000.00 2,250,000.00 1,500,000.
- 108,000.00 100,000.00 864,000.00 2,250,000.00 1,500,000.
- 96,000.00 100,000.00 868,000.00 2,250,000.00 1,500,000.
- 84,000.00 100,000.00 872,000.00 2,250,000.00 1,500,000.
- 72,000.00 100,000.00 876,000.00 2,250,000.00 1,500,000.
- 60,000.00 100,000.00 880,000.00 2,250,000.00 1,500,000.
- 48,000.00 100,000.00 884,000.00 2,250,000.00 1,500,000.
- 36,000.00 100,000.00 888,000.00 2,250,000.00 1,500,000.
- 24,000.00 100,000.00 892,000.00 2,250,000.00 1,500,000.
- 12,000.00 100,000.00 896,000.00 2,250,000.00 1,500,000.
- 800,000.00 2,250,000.00 1,500,000.
- 4,450,000.00 5,000,000.00 550,000. Computador ($) 5000 Unidades ($) ($)
- 4,458,000.00 5,000,000.00 542,000.
- 4,466,000.00 5,000,000.00 534,000.
- 4,474,000.00 5,000,000.00 526,000.
- 4,482,000.00 5,000,000.00 518,000.
- 4,490,000.00 5,000,000.00 510,000.
- 4,498,000.00 5,000,000.00 502,000.
- 4,506,000.00 5,000,000.00 494,000.
- 4,514,000.00 5,000,000.00 486,000.
- 4,522,000.00 5,000,000.00 478,000.
- 4,530,000.00 5,000,000.00 470,000.
- 4,538,000.00 5,000,000.00 462,000.
- 4,546,000.00 5,000,000.00 454,000.
- 4,554,000.00 5,000,000.00 446,000.
- 4,562,000.00 5,000,000.00 438,000.
- 4,570,000.00 5,000,000.00 430,000.
- 4,578,000.00 5,000,000.00 422,000.
- 4,586,000.00 5,000,000.00 414,000.
- 4,594,000.00 5,000,000.00 406,000.
- 4,602,000.00 5,000,000.00 398,000.
- 4,610,000.00 5,000,000.00 390,000.
- 4,534,000.00 5,000,000.00 466,000.
- 4,538,000.00 5,000,000.00 462,000.
- 4,542,000.00 5,000,000.00 458,000.
- 4,546,000.00 5,000,000.00 454,000.
- 4,550,000.00 5,000,000.00 450,000.
- 4,554,000.00 5,000,000.00 446,000.
- 4,558,000.00 5,000,000.00 442,000.
- 4,562,000.00 5,000,000.00 438,000.
- 4,566,000.00 5,000,000.00 434,000.
- 4,570,000.00 5,000,000.00 430,000.
- 4,574,000.00 5,000,000.00 426,000.
- 4,578,000.00 5,000,000.00 422,000.
- 4,582,000.00 5,000,000.00 418,000.
- 4,586,000.00 5,000,000.00 414,000.
- 4,590,000.00 5,000,000.00 410,000.
- 4,594,000.00 5,000,000.00 406,000.
- 4,598,000.00 5,000,000.00 402,000.
- 4,602,000.00 5,000,000.00 398,000.
- 4,606,000.00 5,000,000.00 394,000.
- 4,610,000.00 5,000,000.00 390,000.
- 4,614,000.00 5,000,000.00 386,000.
- 4,618,000.00 5,000,000.00 382,000.
- 4,622,000.00 5,000,000.00 378,000.
- 4,626,000.00 5,000,000.00 374,000.
- 4,630,000.00 5,000,000.00 370,000.
- 4,634,000.00 5,000,000.00 366,000.
- 4,638,000.00 5,000,000.00 362,000.
- 4,642,000.00 5,000,000.00 358,000.
- 4,646,000.00 5,000,000.00 354,000.
- 4,550,000.00 5,000,000.00 450,000.
- MAX. Utilidad 550,000.
- 2,800 2,200 160.00 120.
- 2,900 2,100 160.00 120.
- 3,000 2,000 160.00 120.
- 3,100 1,900 160.00 120.
- 3,200 1,800 160.00 120.
- 3,300 1,700 160.00 120.
- 3,400 1,600 160.00 120.
- 3,500 1,500 160.00 120.
- 3,600 1,400 160.00 120.
- 3,700 1,300 160.00 120.
- 3,800 1,200 160.00 120.
- 3,900 1,100 160.00 120.
- 4,000 1,000 160.00 120.
- 4,100 900 160.00 120.
- 4,200 800 160.00 120.
- 4,300 700 160.00 120.
- 4,400 600 160.00 120.
- 4,500 500 160.00 120.
- 4,600 400 160.00 120.
- 4,700 300 160.00 120.
- 4,800 200 160.00 120.
- 4,900 100 160.00 120.
- 5,000 0 160.00 120.
- 448,000.00 264,000.00 100,000.00 812,000.00 2,250,000.
- 464,000.00 252,000.00 100,000.00 816,000.00 2,250,000.
- 480,000.00 240,000.00 100,000.00 820,000.00 2,250,000.
- 496,000.00 228,000.00 100,000.00 824,000.00 2,250,000.
- 512,000.00 216,000.00 100,000.00 828,000.00 2,250,000.
- 528,000.00 204,000.00 100,000.00 832,000.00 2,250,000.
- 544,000.00 192,000.00 100,000.00 836,000.00 2,250,000.
- 560,000.00 180,000.00 100,000.00 840,000.00 2,250,000.
- 576,000.00 168,000.00 100,000.00 844,000.00 2,250,000.
- 592,000.00 156,000.00 100,000.00 848,000.00 2,250,000.
- 608,000.00 144,000.00 100,000.00 852,000.00 2,250,000.
- 624,000.00 132,000.00 100,000.00 856,000.00 2,250,000.
- 640,000.00 120,000.00 100,000.00 860,000.00 2,250,000.
- 656,000.00 108,000.00 100,000.00 864,000.00 2,250,000.
- 672,000.00 96,000.00 100,000.00 868,000.00 2,250,000.
- 688,000.00 84,000.00 100,000.00 872,000.00 2,250,000.
- 704,000.00 72,000.00 100,000.00 876,000.00 2,250,000.
- 720,000.00 60,000.00 100,000.00 880,000.00 2,250,000.
- 736,000.00 48,000.00 100,000.00 884,000.00 2,250,000.
- 752,000.00 36,000.00 100,000.00 888,000.00 2,250,000.
- 768,000.00 24,000.00 100,000.00 892,000.00 2,250,000.
- 784,000.00 - 100,000.00 884,000.00 2,250,000.
- 800,000.00 - - 800,000.00 2,250,000.
- 1,500,000.00 4,450,000.00 5,000,000.00 100,000.00 450,000. Prima ($) Computador ($) 5000 Unidades ($) Apex ($) ($)
- 1,500,000.00 4,458,000.00 5,000,000.00 100,000.00 442,000.
- 1,500,000.00 4,466,000.00 5,000,000.00 100,000.00 434,000.
- 1,500,000.00 4,474,000.00 5,000,000.00 100,000.00 426,000.
- 1,500,000.00 4,482,000.00 5,000,000.00 100,000.00 418,000.
- 1,500,000.00 4,490,000.00 5,000,000.00 100,000.00 410,000.
- 1,500,000.00 4,498,000.00 5,000,000.00 100,000.00 402,000.
- 1,500,000.00 4,506,000.00 5,000,000.00 100,000.00 394,000.
- 1,500,000.00 4,514,000.00 5,000,000.00 100,000.00 386,000.
- 1,500,000.00 4,522,000.00 5,000,000.00 100,000.00 378,000.
- 1,500,000.00 4,530,000.00 5,000,000.00 - 470,000.
- 1,500,000.00 4,538,000.00 5,000,000.00 - 462,000.
- 1,500,000.00 4,546,000.00 5,000,000.00 - 454,000.
- 1,500,000.00 4,554,000.00 5,000,000.00 - 446,000.
- 1,500,000.00 4,562,000.00 5,000,000.00 - 438,000.
- 1,500,000.00 4,570,000.00 5,000,000.00 - 430,000.
- 1,500,000.00 4,578,000.00 5,000,000.00 - 422,000.
- 1,500,000.00 4,586,000.00 5,000,000.00 - 414,000.
- 1,500,000.00 4,594,000.00 5,000,000.00 - 406,000.
- 1,500,000.00 4,602,000.00 5,000,000.00 - 398,000.
- 1,500,000.00 4,610,000.00 5,000,000.00 - 390,000.
- 1,500,000.00 4,534,000.00 5,000,000.00 - 466,000.
- 1,500,000.00 4,538,000.00 5,000,000.00 - 462,000.
- 1,500,000.00 4,542,000.00 5,000,000.00 - 458,000.
- 1,500,000.00 4,546,000.00 5,000,000.00 - 454,000.
- 1,500,000.00 4,550,000.00 5,000,000.00 - 450,000.
- 1,500,000.00 4,554,000.00 5,000,000.00 - 446,000.
- 1,500,000.00 4,558,000.00 5,000,000.00 - 442,000.
- 1,500,000.00 4,562,000.00 5,000,000.00 - 438,000.
- 1,500,000.00 4,566,000.00 5,000,000.00 - 434,000.
- 1,500,000.00 4,570,000.00 5,000,000.00 - 430,000.
- 1,500,000.00 4,574,000.00 5,000,000.00 - 426,000.
- 1,500,000.00 4,578,000.00 5,000,000.00 - 422,000.
- 1,500,000.00 4,582,000.00 5,000,000.00 - 418,000.
- 1,500,000.00 4,586,000.00 5,000,000.00 - 414,000.
- 1,500,000.00 4,590,000.00 5,000,000.00 - 410,000.
- 1,500,000.00 4,594,000.00 5,000,000.00 - 406,000.
- 1,500,000.00 4,598,000.00 5,000,000.00 - 402,000.
- 1,500,000.00 4,602,000.00 5,000,000.00 - 398,000.
- 1,500,000.00 4,606,000.00 5,000,000.00 - 394,000.
- 1,500,000.00 4,610,000.00 5,000,000.00 - 390,000.
- 1,500,000.00 4,614,000.00 5,000,000.00 - 386,000.
- 1,500,000.00 4,618,000.00 5,000,000.00 - 382,000.
- 1,500,000.00 4,622,000.00 5,000,000.00 - 378,000.
- 1,500,000.00 4,626,000.00 5,000,000.00 - 374,000.
- 1,500,000.00 4,630,000.00 5,000,000.00 - 370,000.
- 1,500,000.00 4,634,000.00 5,000,000.00 - 366,000.
- 1,500,000.00 4,638,000.00 5,000,000.00 - 362,000.
- 1,500,000.00 4,642,000.00 5,000,000.00 - 358,000.
- 1,500,000.00 4,634,000.00 5,000,000.00 - 366,000.
- 1,500,000.00 4,550,000.00 5,000,000.00 - 450,000.
- MAX. Utilidad 470,000.