Exaen T1

BIMESTRE CHOCOLATE LECHE (en kilos) ANO

PRIMERO

SEGUNDO

TERCERO

CUARTO

QUINTO

SEXTO

2013 2014 2015 2016 2017

116700 122700 126900 144300 147000

116100 121500 126000 144900 148500

117900 123600 126300 145200 147600

118500 124500 127800 144600 147900

116370 124800 129000 145500 147600

116910 124200 129300 145800 148800

Ft

Et

Abs(Et)

Et^2

Et/Dt

Abs(Et/Dt)

2560000 1276900 462400 29593600 8065600 10432900 3610000 2560000 10000 5760000 490000 360000 1960000 5290000 2560000 243360000 114490000 32490000 40000 360000 490000 2890000 5760000 250000 40000 160000 1210000 160000 4444.44444

0.0135 -0.0097 -0.0058 0.0443 0.0234 0.0261 0.0153 0.0128 -0.0008 0.0189 0.0056 0.0048 0.0110 0.0178 0.0124 0.1081 0.0738 0.0393 -0.0014 0.0041 0.0048 0.0116 0.0162 0.0034 0.0014 -0.0027 0.0074 -0.0027 0.0005

0.0135 0.0097 0.0058 0.0443 0.0234 0.0261 0.0153 0.0128 0.0008 0.0189 0.0056 0.0048 0.0110 0.0178 0.0124 0.1081 0.0738 0.0393 0.0014 0.0041 0.0048 0.0116 0.0162 0.0034 0.0014 0.0027 0.0074 0.0027 0.0005

Promedio movil simple Bimestre 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32

Dt 116700 116100 117900 118500 116370 116910 122700 121500 123600 124500 124800 124200 126900 126000 126300 127800 129000 129300 144300 144900 145200 144600 145500 145800 147000 148500 147600 147900 147600 148800 147700 148100

116900 1600 1600 117500 -1130 1130 117590 -680 680 117260 5440 5440 118660 2840 2840 120370 3230 3230 122600 1900 1900 123200 1600 1600 124300 -100 100 124500 2400 2400 125300 700 700 125700 600 600 126400 1400 1400 126700 2300 2300 127700 1600 1600 128700 15600 15600 134200 10700 10700 139500 5700 5700 144800 -200 200 144900 600 600 145100 700 700 145300 1700 1700 146100 2400 2400 147100 500 500 147700 200 200 148000 -400 400 147700 1100 1100 148100 -400 400 148033.333 66.6666667 66.6666667

33 34 35 36

N

148033.333 148200 -166.66667 166.666667 27777.7778 -0.0011 0.0011 148200 147944.444 255.555556 255.555556 65308.642 0.0017 0.0017 147944.444 148111.111 -166.66667 166.666667 27777.7778 -0.0011 0.0011 148111.111 148059.259 51.8518519 51.8518519 2688.61454 0.0004 0.0004 Total 3553780 62300 67320 476531400 0.4553702 0.4962205

27

DAM

2493.33333

Promedio movil ponderado Bimestre 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32

Dt 116700 116100 117900 118500 116370 116910 122700 121500 123600 124500 124800 124200 126900 126000 126300 127800 129000 129300 144300 144900 145200 144600 145500 145800 147000 148500 147600 147900 147600 148800 147630 148590

Ft 0.1 0.1 0.8 117600 118200 116736 117015 121488 121161 123300 124110 124650 124290 126420 125910 126330 127470 128610 129120 141270 143280 145080 144690 145380 145650 146730 148080 147630 147930 147630 148590 147744

Et

Abs(Et)

Et^2

Et/Dt

900 -1830 174 5685 12 2439 1200 690 -450 2610 -420 390 1470 1530 690 15180 3630 1920 -480 810 420 1350 1770 -480 270 -330 1170 -960 846

900 1830 174 5685 12 2439 1200 690 450 2610 420 390 1470 1530 690 15180 3630 1920 480 810 420 1350 1770 480 270 330 1170 960 846

810000 3348900 30276 32319225 144 5948721 1440000 476100 202500 6812100 176400 152100 2160900 2340900 476100 230432400 13176900 3686400 230400 656100 176400 1822500 3132900 230400 72900 108900 1368900 921600 715716

0.0076 -0.0157 0.0015 0.0463 0.0001 0.0197 0.0096 0.0055 -0.0036 0.0206 -0.0033 0.0031 0.0115 0.0119 0.0053 0.1052 0.0251 0.0132 -0.0033 0.0056 0.0029 0.0092 0.0119 -0.0033 0.0018 -0.0022 0.0079 -0.0065 0.0057

33 34 35 36

N

147744 148515 147817.2 148445.4 Total

27

148515 147817.2 148445.4 147879.66 3575760

-771 697.8 -628.2 565.74 40320

DAM

771 697.8 628.2 565.74 48300

1788.88889

594441 -0.0052 486924.84 0.0047 394635.24 -0.0042 320061.748 0.0038 311789466 0.29399133

α Abs(et/dt)

0.0076 0.0157 0.0015 0.0463 0.0001 0.0197 0.0096 0.0055 0.0036 0.0206 0.0033 0.0031 0.0115 0.0119 0.0053 0.1052 0.0251 0.0132 0.0033 0.0056 0.0029 0.0092 0.0119 0.0033 0.0018 0.0022 0.0079 0.0065 0.0057

Bimestre 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32

Dt 116700 116100 117900 118500 116370 116910 122700 121500 123600 124500 124800 124200 126900 126000 126300 127800 129000 129300 144300 144900 145200 144600 145500 145800 147000 148500 147600 147900 147600 148800 145995.997 122719.199

0.2 Ft 116900 116740 116972 117277.6 117096.08 117058.864 118187.0912 118849.67296 119799.73837 120739.79069 121551.83256 122081.46604 123045.17284 123636.13827 124168.91061 124895.12849 125716.10279 126432.88223 130006.30579 132985.04463 135428.0357 137262.42856 138909.94285 140287.95428 141630.36342 143004.29074 143923.43259 144718.74607 145294.99686 145995.99749 122719.1995 117935.8399

Et -200 -640 928 1222.4 -726.08 -148.864 4512.9088 2650.32704 3800.26163 3760.20931 3248.16744 2118.53396 3854.82716 2363.86173 2131.08939 2904.87151 3283.89721 2867.11777 14293.6942 11914.9554 9771.9643 7337.57144 6590.05715 5512.04572 5369.63658 5495.70926 3676.56741 3181.25393 2305.00314 2804.00251 23276.798 4783.3596

Abs(Et) 200 640 928 1222.4 726.08 148.864 4512.9088 2650.32704 3800.26163 3760.20931 3248.16744 2118.53396 3854.82716 2363.86173 2131.08939 2904.87151 3283.89721 2867.11777 14293.6942 11914.9554 9771.9643 7337.57144 6590.05715 5512.04572 5369.63658 5495.70926 3676.56741 3181.25393 2305.00314 2804.00251 23276.798 4783.3596

Et^2 40000 409600 861184 1494261.76 527192.1664 22160.490496 20366345.83712 7024233.418955 14441988.47165 14139174.02192 10550591.74738 4488186.120962 14859692.46791 5587842.285999 4541541.967964 8438278.479194 10783980.86329 8220364.279827 204309694.2319 141966161.4634 95491286.19857 53839954.5879 43428853.23128 30382648.01336 28832996.95363 30202820.27541 13517147.90822 10120376.54607 5313039.481637 7862430.093363 541809324.6456 22880529.04289

0.0052 0.0047 0.0042 0.0038 0.35697039

33 34 35 36

N

117935.84 117164.768 117255.034 117127.871 Total

27

117164.76798 117255.0336 117127.87072 117072.66534 3499984.0101

771.07192 -90.265616 127.162877 55.2053754 116095.99

771.07192 90.2656161 127.162877 55.2053754 117845.878

DAM

4364.66215

594551.905167 8147.881446974 16170.39723179 3047.63346827 790753243.3639

Et/Dt -0.0017138 -0.0055125 0.00787108 0.0103 -0.0062 -0.0013 0.0368 0.0218 0.0307 0.0302 0.0260 0.0171 0.0304 0.0188 0.0169 0.0227 0.0255 0.0222 0.0991 0.0822 0.0673 0.0507 0.0453 0.0378 0.0365 0.0370 0.0249 0.0215 0.0156 0.0188 0.1594 0.0390

Abs(et/dt) 0.0017138 0.00551249 0.00787108 0.0103 0.0062 0.0013 0.0368 0.0218 0.0307 0.0302 0.0260 0.0171 0.0304 0.0188 0.0169 0.0227 0.0255 0.0222 0.0991 0.0822 0.0673 0.0507 0.0453 0.0378 0.0365 0.0370 0.0249 0.0215 0.0156 0.0188 0.1594 0.0390

0.0065 0.0065 -0.0008 0.0008 0.0011 0.0011 0.0005 0.0005 0.83864274 0.8536682

BIMESTRE BITTER (en kilos) ANO

PRIMERO

SEGUNDO

TERCERO

CUARTO

QUINTO

SEXTO

2013 2014 2015 2016 2017

118350 124950 130050 147900 150300

117750 123750 129150 148500 151800

119550 125850 129450 148800 150900

120150 126750 130950 148200 151200

118020 127050 132150 149100 150900

118560 126450 132450 149400 152100

Ft

Et

Abs(Et)

Et^2

Et/Dt

Abs(Et/Dt)

0.0133 -0.0096 -0.0057 0.0483 0.0262 0.0273 0.0150 0.0126 -0.0008 0.0254 0.0101 0.0070 0.0107 0.0174 0.0121 0.1085 0.0741 0.0393 -0.0013 0.0040 0.0047 0.0093 0.0145 0.0027 0.0013 -0.0027 0.0072 -0.0026 0.0004

0.0133 0.0096 0.0057 0.0483 0.0262 0.0273 0.0150 0.0126 0.0008 0.0254 0.0101 0.0070 0.0107 0.0174 0.0121 0.1085 0.0741 0.0393 0.0013 0.0040 0.0047 0.0093 0.0145 0.0027 0.0013 0.0027 0.0072 0.0026 0.0004

Promedio movil simple Bimestre 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32

Dt 118350 117750 119550 120150 118020 118560 124950 123750 125850 126750 127050 126450 130050 129150 129450 130950 132150 132450 147900 148500 148800 148200 149100 149400 150300 151800 150900 151200 150900 152100 151000 151400

118550 1600 1600 2560000 119150 -1130 1130 1276900 119240 -680 680 462400 118910 6040 6040 36481600 120510 3240 3240 10497600 122420 3430 3430 11764900 124850 1900 1900 3610000 125450 1600 1600 2560000 126550 -100 100 10000 126750 3300 3300 10890000 127850 1300 1300 1690000 128550 900 900 810000 129550 1400 1400 1960000 129850 2300 2300 5290000 130850 1600 1600 2560000 131850 16050 16050 257602500 137500 11000 11000 121000000 142950 5850 5850 34222500 148400 -200 200 40000 148500 600 600 360000 148700 700 700 490000 148900 1400 1400 1960000 149600 2200 2200 4840000 150500 400 400 160000 151000 200 200 40000 151300 -400 400 160000 151000 1100 1100 1210000 151400 -400 400 160000 151333.333 66.6666667 66.6666667 4444.4444444432

33 34 35 36

N

151333.333 151500 -166.66667 166.666667 151500 151244.444 255.555556 255.555556 151244.444 151411.111 -166.66667 166.666667 151411.111 151359.259 51.8518519 51.8518519 Total 3629230 65600 70620

27

DAM

2615.55556

27777.777777775 -0.0011 0.0011 65308.641975297 0.0017 0.0017 27777.777777775 -0.0011 0.0011 2688.6145404636 0.0003 0.0003 514508400 0.4707740864 0.5109766

Promedio movil ponderado Bimestre 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32

Dt 118350 117750 119550 120150 118020 118560 124950 123750 125850 126750 127050 126450 130050 129150 129450 130950 132150 132450 147900 148500 148800 148200 149100 149400 150300 151800 150900 151200 150900 152100 150930 151890

Ft 0.1 0.1 0.8 119250 119850 118386 118665 123618 123351 125550 126360 126900 126540 129390 128970 129480 130620 131760 132270 144780 146835 148680 148290 148980 149250 150090 151410 150930 151230 150930 151890 151044

Et

Abs(Et)

Et^2

Et/Dt

900 -1830 174 6285 132 2499 1200 690 -450 3510 -240 480 1470 1530 690 15630 3720 1965 -480 810 420 1050 1710 -510 270 -330 1170 -960 846

900 1830 174 6285 132 2499 1200 690 450 3510 240 480 1470 1530 690 15630 3720 1965 480 810 420 1050 1710 510 270 330 1170 960 846

810000 3348900 30276 39501225 17424 6245001 1440000 476100 202500 12320100 57600 230400 2160900 2340900 476100 244296900 13838400 3861225 230400 656100 176400 1102500 2924100 260100 72900 108900 1368900 921600 715716

0.0075 -0.0155 0.0015 0.0503 0.0011 0.0199 0.0095 0.0054 -0.0036 0.0270 -0.0019 0.0037 0.0112 0.0116 0.0052 0.1057 0.0251 0.0132 -0.0032 0.0054 0.0028 0.0070 0.0113 -0.0034 0.0018 -0.0022 0.0077 -0.0064 0.0056

33 34 35 36

N

151044 151815 151117.2 151745.4 Total

27

151815 151117.2 151745.4 151179.66 3652365

-771 697.8 -628.2 565.74 42465

DAM

771 697.8 628.2 565.74 50145

1857.22222

594441 -0.0051 486924.84 0.0046 394635.24 -0.0042 320061.748 0.0037 338554251 0.30397097

α Abs(et/dt)

0.0075 0.0155 0.0015 0.0503 0.0011 0.0199 0.0095 0.0054 0.0036 0.0270 0.0019 0.0037 0.0112 0.0116 0.0052 0.1057 0.0251 0.0132 0.0032 0.0054 0.0028 0.0070 0.0113 0.0034 0.0018 0.0022 0.0077 0.0064 0.0056

Bimestre 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32

Dt 118350 117750 119550 120150 118020 118560 124950 123750 125850 126750 127050 126450 130050 129150 129450 130950 132150 132450 147900 148500 148800 148200 149100 149400 150300 151800 150900 151200 150900 152100 149324.671 124704.934

0.2 Ft 118550 118390 118622 118927.6 118746.08 118708.864 119957.091 120715.673 121742.538 122744.031 123605.225 124174.18 125349.344 126109.475 126777.58 127612.064 128519.651 129305.721 133024.577 136119.661 138655.729 140564.583 142271.667 143697.333 145017.867 146374.293 147279.435 148063.548 148630.838 149324.671 124704.934 119652.987

Et -200 -640 928 1222.4 -726.08 -148.864 4992.9088 3034.32704 4107.46163 4005.96931 3444.77544 2275.82036 4700.65628 3040.52503 2672.42002 3337.93602 3630.34881 3144.27905 14875.4232 12380.3386 10144.2709 7635.4167 6828.33336 5702.66669 5282.13335 5425.70668 3620.56534 3136.45228 2269.16182 2775.32946 24619.7364 5051.94729

Abs(Et) 200 640 928 1222.4 726.08 148.864 4992.9088 3034.32704 4107.46163 4005.96931 3444.77544 2275.82036 4700.65628 3040.52503 2672.42002 3337.93602 3630.34881 3144.27905 14875.4232 12380.3386 10144.2709 7635.4167 6828.33336 5702.66669 5282.13335 5425.70668 3620.56534 3136.45228 2269.16182 2775.32946 24619.7364 5051.94729

Et^2 40000 409600 861184 1494261.76 527192.166 22160.4905 24929138.3 9207140.59 16871241.1 16047790.1 11866477.9 5179358.29 22096169.5 9244792.44 7141828.77 11141816.9 13179432.5 9886490.75 221278217 153272784 102906232 58299588.2 46626136.5 32520407.4 27900932.7 29438293 13108493.4 9837332.87 5149095.37 7702453.59 606131422 25522171.4

0.0051 0.0046 0.0042 0.0037 0.36342765

33 34 35 36

N

119652.987 118828.197 118907.719 118778.408 Total

27

118828.197 118907.719 118778.408 118722.773 3572019.32

824.789457 -79.522109 129.311578 55.6351157 122810.682

824.789457 79.5221085 129.311578 55.6351157 124560.57

DAM

4613.35445

680277.649 6323.76574 16721.4843 3095.26609 866875256

Et/Dt -0.0016899 -0.0054352 0.00776244 0.0102 -0.0062 -0.0013 0.0400 0.0245 0.0326 0.0316 0.0271 0.0180 0.0361 0.0235 0.0206 0.0255 0.0275 0.0237 0.1006 0.0834 0.0682 0.0515 0.0458 0.0382 0.0351 0.0357 0.0240 0.0207 0.0150 0.0182 0.1649 0.0405

Abs(et/dt) 0.0016899 0.00543524 0.00776244 0.0102 0.0062 0.0013 0.0400 0.0245 0.0326 0.0316 0.0271 0.0180 0.0361 0.0235 0.0206 0.0255 0.0275 0.0237 0.1006 0.0834 0.0682 0.0515 0.0458 0.0382 0.0351 0.0357 0.0240 0.0207 0.0150 0.0182 0.1649 0.0405

0.0069 0.0069 -0.0007 0.0007 0.0011 0.0011 0.0005 0.0005 0.87014931 0.88496486

Trabajadores Mes Horas mes Ano

Maquina 5 Maquina 4 Maquina 3

8 hr/dia 26 dias 624 7488 Kgs/hr 9.78 9.78 23.65

Kgs/dia 78.24 78.24 189.2

Kgs/mes 2034.24 2034.24 4919.2

Kgs/ano 24410.88 24410.88 59030.4

Maq. Chocolate 37.23 36.42 30.46

Maq. Real 38 37 31

CHOCOLATE LECHE Bimestre Dt 31 147630 32 148590 33 147744 34 148515 35 147817.2 36 148445.4 Total

CHOCOLATE BITTER Ft 148590 147744 148515 147817.2 148445.4 147879.66 888991.26

Bimestre Dt 31 150930 32 151890 33 151044 34 151815 35 151117.2 36 151745.4 Total

Ft 151890 151044 151815 151117.2 151745.4 151179.66 908791.26

Chocolate Bitter Nombre de material Azucar molida Licor de cacao bitter Manteca de cacao bitter Lecitina de soya Vainilla en polvo

Cantidad 0.475 0.370 0.150 0.004 0.001

Chocolate Leche Nombre de material Azucar molida Licor de cacao leche Manteca de cacao Lecitina de soya Vainilla en polvo Leche descremada en polvo Sal industrial

Cantidad 0.430 0.125 0.268 0.004 0.001 0.171 0.002

CHOCOLATE LECHE Bimestre 31 32 33 34 35 36 Total

CHOCOLATE BITTER

Dt 147630 148590 147744 148515 147817.2 148445.4

Chocolate bitter Unidad Anual Anual

0.475 1913244.75789 1913.24475789

Total azucar

Ft 148590 147744 148515 147817.2 148445.4 147879.66 888991.26

Bimestre Dt 31 150930 32 151890 33 151044 34 151815 35 151117.2 36 151745.4 Total

Chocolate Leche gr gr kg

2067.42153

Unidad Anual Anual

0.430 2067421.534884 2067.421534884

gr gr kg

Ft 151890 151044 151815 151117.2 151745.4 151179.66 908791.26