ALUMNO: JESUS ASMETH PEREZ CAMACHO ING.

SISTEMAS COMPUTACIONALES

GAUSS-SEIDEL

1.- Una compañía de electrónica produce transistores, resistores y chips de computadora. Cada
resistor requiere cuatro unidades de cobre, una de zinc y dos de vidrio. Cada resistor requiere tres,
tres y una unidades de dichos materiales respectivamente y cada chip de computadora requiere
dos, una y tres respectivamente. En forma de tabla, esta información queda así;

Componente Cobre Zinc Vidrio

Transistores 4 1 2
Resistores 3 3 1
Chips de computadora 2 1 3

Los suministros de estos materiales varían de una semana a la otra, de modo que la compañía
necesita determinar una corrida de producción diferente cada semana. Por ejemplo las cantidades
disponibles de materiales son 960 unidades de cobre, 510 unidades de zinc y 610 unidades de
vidrio. Plantee el sistema de ecuaciones que modela la corrida de producción y utilice Excel y la
información que se da en este capítulo sobre la solución de ecuaciones algebraicas lineales con
Excel pera resolver cual es el número de transistores, resistores y chips de computadora por
manufacturar esta semana.

GAUSS-SEIDEL
DEFINIMOS LAS ECUACIONES:
4t+3r+2c=960
t+3r+c=510
2t+r+3c=610

DESPEJAMOS LAS VARIABLES

960−3 r −2 c
t=
4

510−t−c
r=
3

610−2t−r
c=
3
ALUMNO: JESUS ASMETH PEREZ CAMACHO [Link] COMPUTACIONALES

ITERACION t r c Error
1 100 100 100
2 115 103.333333 103.333333 13.04%
3 110.8333333 97.2222222 92.2222222 -3.76%
4 120.9722222 102.314815 97.037037 8.38%
5 114.7453704 97.3302469 88.5802469 -5.43%
6 122.7121914 102.224794 94.3930041 6.49%
7 116.1349023 97.6316015 87.4502743 -5.66%
8 123.0511617 102.138274 93.366198 5.62%
9 116.7131952 97.8608801 87.253134 -5.43%
10 122.9777729 102.011224 92.9042432 5.09%
11 117.0394607 98.039328 87.3444102 -5.07%
12 122.7982989 101.872043 92.6272502 4.69%
13 117.2823426 98.1914836 87.510453 -4.70%
14 122.6011608 101.735735 92.4146104 4.34%
15 117.4908937 98.3280763 87.6873146 -4.35%
16 122.4102855 101.607264 92.2300454 4.02%
17 117.6795294 98.453223 87.8573884 -4.02%
18 122.2313885 101.487694 92.0625727 3.72%
19 117.8529431 98.5686796 88.0165096 -3.72%
20 122.0652355 101.376849 91.9084781 3.45%
21 118.0131241 98.6754288 88.1642266 -3.43%
22 121.9113151 101.274216 91.7661077 3.20%
23 118.1612839 98.7741924 88.3010511 -3.17%
24 121.7688301 101.179222 91.6344133 2.96%
25 118.2983771 98.8655855 88.427706 -2.93%
26 121.6369578 101.091306 91.5125534 2.74%
27 118.4252441 98.9501629 88.5449262 -2.71%
28 121.5149147 101.009943 91.399783 2.54%
29 118.5426511 99.0284341 88.6534091 -2.51%
30 121.4019699 100.934647 91.2954212 2.36%
31 118.6513044 99.1008696 88.7538046 -2.32%
32 121.2974455 100.864964 91.1988405 2.18%
33 118.751857 99.1679047 88.8467151 -2.14%
34 121.2007139 100.800476 91.1094604 2.02%
35 118.8449128 99.2299419 88.9326987 -1.98%
36 121.1111942 100.740796 91.0267442 1.87%
37 118.9310308 99.2873539 89.0122718 -1.83%
38 121.0283487 100.685566 90.9501949 1.73%
39 119.0107282 99.3404855 89.0859123 -1.70%
40 120.9516798 100.634453 90.8793527 1.60%
41 119.0844838 99.3896558 89.1540624 -1.57%
ALUMNO: JESUS ASMETH PEREZ CAMACHO [Link] COMPUTACIONALES

42 120.8807269 100.587151 90.8137922 1.49%

43 119.1527405 99.4351603 89.2171316 -1.45%
44 120.815064 100.543376 90.7531196 1.38%
45 119.2159082 99.4772721 89.2754987 -1.34%
46 120.7542965 100.502864 90.6969705 1.27%
47 119.2743665 99.5162443 89.3295142 -1.24%
48 120.6980597 100.465373 90.6450076 1.18%
49 119.3284664 99.5523109 89.3795025 -1.15%
50 120.6460155 100.430677 90.5969188 1.09%
51 119.3785329 99.5856886 89.425764 -1.06%
52 120.5978516 100.398568 90.5524152 1.01%
53 119.4248666 99.6165777 89.4685764 -0.98%
54 120.5532785 100.368852 90.5112297 0.94%
55 119.4677459 99.6451639 89.5081969 -0.91%
56 120.5120286 100.341352 90.4731148 0.87%
57 119.5074283 99.6716189 89.5448634 -0.84%
58 120.4738541 100.315903 90.4378415 0.80%
59 119.5441522 99.6961015 89.5787963 -0.78%
60 120.4385257 100.29235 90.4051981 0.74%
61 119.5781381 99.7187587 89.6101993 -0.72%
62 120.4058313 100.270554 90.3749884 0.69%
63 119.6095902 99.7397268 89.6392611 -0.67%
64 120.3755744 100.250383 90.3470309 0.64%
65 119.6386973 99.7591316 89.6661561 -0.62%
66 120.3475733 100.231716 90.3211579 0.59%
67 119.6656344 99.7770896 89.691046 -0.57%
68 120.3216598 100.21444 90.2972139 0.55%
69 119.6905632 99.7937088 89.7140802 -0.53%
70 120.2976783 100.198452 90.275055 0.50%
71 119.7136334 99.8090889 89.735397 -0.49%
72 120.2754848 100.183657 90.2545481 0.47%
73 119.7349835 99.8233224 89.7551246 -0.45%
74 120.2549459 100.169964 90.2355702 0.43%
75 119.7547419 99.8364946 89.7733814 -0.42%
76 120.2359383 100.157292 90.2180072 0.40%
77 119.7730273 99.8486848 89.790277 -0.39%
78 120.2183479 100.145565 90.2017536 0.37%
79 119.7899493 99.8599662 89.805913 -0.36%
80 120.2020688 100.134713 90.1867117 0.34%
81 119.8056097 99.8704065 89.8203833 -0.33%
82 120.1870035 100.124669 90.1727914 0.32%
83 119.8201026 99.8800684 89.8337747 -0.31%
84 120.1730614 100.115374 90.1599088 0.29%
ALUMNO: JESUS ASMETH PEREZ CAMACHO [Link] COMPUTACIONALES

85 119.8335149 99.8890099 89.8461676 -0.28%

86 120.1601587 100.106772 90.1479868 0.27%
87 119.8459272 99.8972848 89.8576367 -0.26%
88 120.148218 100.098812 90.1369536 0.25%
89 119.8574142 99.9049428 89.8682506 -0.24%
90 120.1371676 100.091445 90.1267429 0.23%
91 119.8680447 99.9120298 89.8780733 -0.22%
92 120.126941 100.084627 90.1172936 0.22%
93 119.8778827 99.9185885 89.8871636 -0.21%
94 120.1174769 100.078318 90.1085487 0.20%
95 119.8869872 99.9246581 89.8955761 -0.19%
96 120.1087183 100.072479 90.1004558 0.18%
97 119.8954129 99.9302753 89.9033615 -0.18%
98 120.1006128 100.067075 90.0929663 0.17%
99 119.9032105 99.9354736 89.9105664 -0.16%
100 120.0931116 100.062074 90.0860351 0.16%
101 119.9104266 99.9402844 89.9172342 -0.15%
102 120.0861696 100.057446 90.0796208 0.15%
103 119.9171048 99.9447366 89.9234048 -0.14%
104 120.0797452 100.053163 90.0736846 0.14%
105 119.9232851 99.9488567 89.9291154 -0.13%
106 120.0737997 100.0492 90.068191 0.13%
107 119.9290046 99.9526697 89.9344002 -0.12%
108 120.0682976 100.045532 90.063107 0.12%
109 119.9342977 99.9561985 89.939291 -0.11%
110 120.0632056 100.042137 90.058402 0.11%
111 119.9391962 99.9594641 89.9438172 -0.10%
112 120.0584933 100.038996 90.0540479 0.10%
113 119.9437294 99.9624863 89.948006 -0.10%
114 120.0541323 100.036088 90.0500183 0.09%
115 119.9479247 99.9652831 89.9518824 -0.09%
116 120.0500965 100.033398 90.0462892 0.09%
117 119.9518072 99.9678715 89.9554698 -0.08%
118 120.0463615 100.030908 90.0428381 0.08%
119 119.9554002 99.9702668 89.9587898 -0.08%
120 120.042905 100.028603 90.0396442 0.07%
121 119.9587254 99.9724836 89.9618622 -0.07%
122 120.0397062 100.026471 90.0366886 0.07%
123 119.9618026 99.9745351 89.9647056 -0.06%
124 120.0367459 100.024497 90.0339532 0.06%
125 119.9646504 99.9764336 89.967337 -0.06%
126 120.0340063 100.022671 90.0314218 0.06%
127 119.9672859 99.9781906 89.9697722 -0.06%
ALUMNO: JESUS ASMETH PEREZ CAMACHO [Link] COMPUTACIONALES

128 120.0314709 100.020981 90.0290792 0.05%

129 119.969725 99.9798166 89.9720258 -0.05%

La iteracion 120 es la que mas se aproxima a 0%

es decir:
Numero de transistores ≈ 120.031471 ≈ 120 transistores
Numero de resistores ≈ 100.020981 ≈ 100 resistores
Numero de chips ≈ 90.0290792 ≈ 90 chips

GAUSS SIMPLE

2.- Un ingeniero eléctrico supervisa la producción de tres tipos de componentes eléctricos. Para
ello se requieren tres clases de material: metal, plástico y caucho. A continuación se presentan las
cantidades necesarias para producir cada componente.

Componente Metal g/componente Plástico Hule g/componente

g/componente
1 15 .30 1.0
2 17 .40 1.2
3 19 .55 1.5

Si cada día se dispone de un total de 3.89, 0.095 y 0.282 Kg. de metal, plástico y caucho,
respectivamente, ¿Cuántos componentes produce por día?

1kg=1000g

3.89kg=3890g

0.095kg=95g

0.282kg=282g

GAUSS SIMPLE
ALUMNO: JESUS ASMETH PEREZ CAMACHO [Link] COMPUTACIONALES

X Y Z

( )
15 17 19 3890
0.3 0.4 0.55 95
1 1.2 1.5 282

( )
1 1.2 1.5 282
0.3 0.4 0.55 95 R2=-.3*R1+R2
15 17 19 3890 R3=-15*R1+R3

1 1.2 1.5 282

( 0

0
0.04

-1
0.1

-3.5
10.4

-340
) R3=1/.04*R2+R
3

( )
1 1.2 1.5 282
0 0.04 0.1 10.4
0 0 -1 -80
SUSTITUCIONES:
-Z=-80
Z=80

0.04Y+0.1(80)=10.4
0.04Y+8=10.4
10.4−8
Y= =60
0.04

X+1.2(60)+1.5(80)=282
X+192=282
X=282-192
X=90
RESPUESTA
ALUMNO: JESUS ASMETH PEREZ CAMACHO [Link] COMPUTACIONALES

COMPONENTE 1 = 90
COMPONENTE 2= 60
COMPONENTE 3= 80

COMPONENTE AL DIA 230