Download docx - Pronostico de Venta

Transcript

PRONOSTICO DE VENTA

AosXY (Ingresos)XYXY

20100 $ 595,000.00 00 $ 354,025,000,000.00

20111 $ 624,750.00 $ 624,750.00 1 $ 390,312,562,500.00

20122 $ 655,987.50 $ 1,311,975.00 4 $ 430,319,600,156.25

20133 $ 688,786.88 $ 2,066,360.63 9 $ 474,427,359,172.27

20144 $ 723,226.22 $ 2,892,904.88 16 $ 523,056,163,487.42

=10 $ 3,287,750.59 $ 6,895,990.50 30 $ 2,172,140,685,315.94

A=XY-XXY= $ 29,672,612.81 = $ 593,452.26

nx-(x)50

B=nxy-xy= $ 1,602,446.56 = $ 32,048.93

nx-(x)50

ERROR ESTANDAR

Se=Y-ay-bxy

\n-2

Se= $ 8,552,032.57 = $ 2,850,677.52 =1688.39

\3

AO 6

Y=a+bx

Y= 593452.26+32048.93(6)

Y= $ 785,745.84

ySez

785745.841688.39(2)

+ $ 789,122.62

- $ 782,369.06

AO 7

Y=a+bx

Y= 593452.26+32048.93(7)

Y= $ 817,794.78

ySez

817794.781688.39(2)

+ $ 821,171.56

- $ 814,418.00

AO 8

Y=a+bx

Y= 593452.26+32048.93(8)

Y= $ 849,843.71

ySez

849843.711688.39(2)

+ $ 853,220.49

- $ 846,466.93

AO 9

Y=a+bx

Y= 593452.26+32048.93(9)

Y= $ 881,892.64

ySez

881892.641688.39(2)

+ $ 885,269.42

- $ 878,515.86

AO 10

Y=a+bx

Y= 593452.26+32048.93(10)

Y= $ 913,941.57

ySez

913941.571688.39(2)

+ $ 917,318.35

- $ 910,564.79

AosPesimistaNormalOptimista

6 $ 782,369.06 $ 785,745.84 $ 789,122.62

7 $ 814,418.00 $ 817,794.78 $ 821,171.56

8 $ 846,466.93 $ 849,843.71 $ 853,220.49

9 $ 878,515.86 $ 881,892.64 $ 885,269.42

10 $ 910,564.79 $ 913,941.57 $ 917,318.35