T"M
21
22
23
24
Figura 2.13
Gráfica de tendencia
300 ,---------------------------------,
310
360
350
340
y
=
3.3347x
+
325.74
R
2
=
0.9809
• •
• •
• •
3W+-------__------__------__
----~
o
10
15
I__
Serie1
lineal (Serie1 )
lineal (Serie1 )
1
Tabla
2.23
Cálculo del factor estacional ajustado
A
TRlM 1
TRlM 2 TRlM 3 TRlM4
1
117.25
89.39
2
79.65
112.06
119.23
88.88
3
83.59
108.48
117.68
91 .14
80.73
110.63
119.87
88.98
5
80.61
109.09
FE
80.67
109.86
118.46
89.18
FEA
81.04
110.37
119.00
89.59
FA=
1.0046
Tabla
2.24
CÁLCULO
DEl.
PRONOsTICO PARA. AAo 6
VENTAS
....
FTA
S(Txl)
.1"2
feA
S(TxlxC)
310
81 .04
395.77
320.n
114.99 98.48
315.86
....
110.37
399.10
440.48
56.58
97.50
429.46
497
119.00
402.44
476.91
327.18 98.96
473.93
370
89.59
405.77
363.54
41.71 100.45
365.16
540.46
MOe-
135.12
88
.1"2
34.32
343.82
532.03
23.43
933.59
233.40
1...,86,87,88,89,90,91,92,93,94,95 97,98,99,100,101,102,103,104,105,106,...270