Ejemplo Simsist

Descargar como xlsx, pdf o txt
Descargar como xlsx, pdf o txt
Está en la página 1de 4

VENTA HISTORICAS ANUALES DE ESPARRAGO FRESCO A EUROPA (TONELADAS)

CANTIDAD TN FRECUENCIA COSTO POR TONELADA $400


1000 40 INGRESOS POR TONELADA VENDIDA $750
2000 100
3500 70 Si se atiende en el siguiente bimestre a 30 clientes,
5000 60 determinar la utilidad esperada
N° de pruebas de simulación: 10

CANTIDAD TN FRECUENCIA Prob ProbMin ProbMax CANTIDAD TN


1000 40 0.148 0 0.148 1,000
2000 100 0.370 0.148 0.519 2,000
3500 70 0.259 0.519 0.778 3,500
5000 60 0.222 0.778 1.000 5,000
total 270

Cliente Aleatorio Cantidad(TN) Costo TN PV TN Utilidad


1 0.0726912812 1000 $400,000 $750,000 $350,000
2 0.4767296755 2000 $800,000 $1,500,000 $700,000
3 0.1655160958 2000 $800,000 $1,500,000 $700,000
4 0.7933505765 5000 $2,000,000 $3,750,000 $1,750,000
5 0.6980047312 3500 $1,400,000 $2,625,000 $1,225,000
6 0.3225491054 2000 $800,000 $1,500,000 $700,000
7 0.399421359 2000 $800,000 $1,500,000 $700,000
8 0.4859010723 2000 $800,000 $1,500,000 $700,000
9 0.834603292 5000 $2,000,000 $3,750,000 $1,750,000
10 0.7478590799 3500 $1,400,000 $2,625,000 $1,225,000
11 0.3850501435 2000 $800,000 $1,500,000 $700,000
12 0.7534567654 3500 $1,400,000 $2,625,000 $1,225,000
13 0.8976068879 5000 $2,000,000 $3,750,000 $1,750,000
14 0.9824575923 5000 $2,000,000 $3,750,000 $1,750,000
15 0.6167959883 3500 $1,400,000 $2,625,000 $1,225,000
16 0.690720849 3500 $1,400,000 $2,625,000 $1,225,000
17 0.6431180019 3500 $1,400,000 $2,625,000 $1,225,000
18 0.6043230832 3500 $1,400,000 $2,625,000 $1,225,000
19 0.9560453872 5000 $2,000,000 $3,750,000 $1,750,000
20 0.7257394434 3500 $1,400,000 $2,625,000 $1,225,000
21 0.8063782825 5000 $2,000,000 $3,750,000 $1,750,000
22 0.6212676687 3500 $1,400,000 $2,625,000 $1,225,000
23 0.5938961011 3500 $1,400,000 $2,625,000 $1,225,000
24 0.8403024065 5000 $2,000,000 $3,750,000 $1,750,000
25 0.5618808442 3500 $1,400,000 $2,625,000 $1,225,000
26 0.7845083383 5000 $2,000,000 $3,750,000 $1,750,000
27 0.2595338047 2000 $800,000 $1,500,000 $700,000
28 0.5235392726 3500 $1,400,000 $2,625,000 $1,225,000
29 0.4484430853 2000 $800,000 $1,500,000 $700,000
30 0.0923135798 1000 $400,000 $750,000 $350,000
Utilidad S1 S2 S3 S4 S5 S6
$35,000,000 35,000,000 35,000,000 35,000,000 35,000,000 35,000,000 35,000,000
S7 S8 S9 S10 Promedio
35,000,000 35,000,000 35,000,000 35,000,000 35,000,000

También podría gustarte