BIMESTRAL ANUAL

LECHE 240,000 1,440,000

QUESO 12,000 72,000
CREMA 4,500 27,000

1 2 3 4
LECHE 180 144 270 126
QUESO 120 96 149
CREMA 60 54 72

1 2 3 4
LECHE 0.18 0.14 0.27 0.13
QUESO 0.60 0.48 0.75 -
CREMA 0.80 0.72 0.96 -

1 2 3 4
LECHE 4,320 3,456 6,480 3,024
QUESO 720 576 894 -
CREMA 360 324 432 -

$ 1,160 $ 1,080 $ 1,250 $ 1,050

1 2 3 4
LECHE $ 5,011,200 $ 3,732,480 $ 8,100,000 $ 3,175,200
QUESO $ 835,200 $ 622,080 $ 1,117,500 $ -
CREMA $ 417,600 $ 349,920 $ 540,000 $ -
$ 6,264,000 $ 4,704,480 $ 9,757,500 $ 3,175,200
 5 6 7 8
1000
40 80 200
14 40 75

5 6 7 8
- - - -
0.20 0.40 - -
- - 0.19 0.53

5 6 7 8
- - - -
240 480 - -
- - 84 240

$ 1,180 $ 1,200 $ 1,150 $ 1,250

5 6 7 8 TOTAL
$ - $ - $ - $ - $ 20,018,880
$ 283,200 $ 576,000 $ - $ - $ 3,433,980
$ - $ - $ 96,600 $ 300,000 $ 1,704,120
$ 283,200 $ 576,000 $ 96,600 $ 300,000 $ 25,156,980
Bimestre Ensueño Ambición Paraiso
1 20,000 10,000 15,000
2 8,000 4,000 6,000
3 12,000 6,000 9,000
4 8,000 4,000 6,000
5 8,000 4,000 6,000
6 24,000 12,000 18,000
80,000 40,000 60,000

Inventarios iniciales

Ensueño 32,000
Ambición 12,600
Paraiso 18,000

Inventario final

Ensueño 1 mes de las ventas

Ambición 1,5 mes de las ventas
Paraiso 25% de las ventas
ENSUEÑO

QV II IF QP QP
1 20,000 32,000 25,667 13,667 25%
2 8,000 25,667 23,134 5,467 10%
3 12,000 23,134 19,334 8,200 15%
4 8,000 19,334 16,801 5,467 10%
5 8,000 16,801 14,268 5,467 10%
6 24,000 14,268 6,667 16,399 30%
80,000 54,667

AMBICION

QV II IF QP
1 10,000 12,600 10,700 8,100 25% QP
2 4,000 10,700 9,940 3,240 10%
3 6,000 9,940 8,800 4,860 15%
4 4,000 8,800 8,040 3,240 10%
5 4,000 8,040 7,280 3,240 10%
6 12,000 7,280 5,000 9,720 30%
40,000 32,400

PARAISO

QV II IF QP
1 15,000 18,000 17,250 14,250 25% QP
2 6,000 17,250 16,950 5,700 10%
3 9,000 16,950 16,500 8,550 15%
4 6,000 16,500 16,200 5,700 10%
5 6,000 16,200 15,900 5,700 10%
6 18,000 15,900 15,000 17,100 30%
60,000 57,000
54,667

32,400

57000
M PRIMAS U MEDIDA Precios Ensueño Ambición Paraiso
A Libras 180 0.25 0.15 0.1
B Litros 280 0.125 0.1 0.05
C Libras 300 0.2 0.15 0.1

Ensueño
0.25 0.125 0.2
QP A B C
1 13,667 3,416.75 1,708.38 2,733.40
2 5,467 1,366.75 683.38 1,093.40
3 8,200 2,050.00 1,025.00 1,640.00
4 5,467 1,366.75 683.38 1,093.40
5 5,467 1,366.75 683.38 1,093.40
6 16,399 4,099.75 2,049.88 3,279.80
54,667 13,666.75 6,833.38 10,933.40

Ambición
0.15 0.1 0.15
QP A B C
1 8100 1,215.00 810.00 1,215.00
2 3240 486.00 324.00 486.00
3 4860 729.00 486.00 729.00
4 3240 486.00 324.00 486.00
5 3240 486.00 324.00 486.00
6 9720 1,458.00 972.00 1,458.00
4,860.00 3,240.00 4,860.00

Paraiso 0.1 0.05 0.1

QP A B C
1 14250 1,425.00 712.50 1,425.00
2 5700 570.00 285.00 570.00
3 8550 855.00 427.50 855.00
4 5700 570.00 285.00 570.00
5 5700 570.00 285.00 570.00
6 17100 1,710.00 855.00 1,710.00
5,700.00 2,850.00 5,700.00

TOTAL A B C
1 6,056.75 3,230.88 5,373.40
2 2,422.75 1,292.38 2,149.40
3 3,634.00 1,938.50 3,224.00
4 2,422.75 1,292.38 2,149.40
5 2,422.75 1,292.38 2,149.40
6 7,267.75 3,876.88 6,447.80
 II C/U
A 5,950 $ 144
B 3,350 $ 230
C 3,950 $ 240

INVENTARIO FINAL

PP
Ensueño 10,800
Ambición 9,600
Paraiso 10,000

Ensueño

A 0.25 2700
B 0.125 1350
C 0.2 2160
Ambicion

A 0.15 1440
B 0.1 960
C 0.15 1440
Paraiso

A 0.1 1000
B 0.05 500
C 0.1 1000

Ensueño Ambicion Paraiso total

A 2700 1440 1000 5140
B 1350 960 500 2810
C 2160 1440 1000 4600
material A
CONSUMOS II IF Q COMPRAR
1 6,056.75 5,950.00 5,747.25 5,854 25.00%
2 2,422.75 5,747.25 5,666.50 2,342 10.00%
3 3,634.00 5,666.50 5,545.50 3,513 15.00%
4 2,422.75 5,545.50 5,464.75 2,342 10.00%
5 2,422.75 5,464.75 5,384.00 2,342 10.00%
6 7,267.75 5,384.00 5,140.00 7,024 30.00%
24,226.75 23,417

material B

CONSUMOS II IF Q COMPRAR
1 3,230.88 3,350.00 3,215.13 3,096 25%
2 1,292.38 3,215.13 3,160.75 1,238 10%
3 1,938.50 3,160.75 3,079.25 1,857 15%
4 1,292.38 3,079.25 3,024.88 1,238 10%
5 1,292.38 3,024.88 2,970.50 1,238 10%
6 3,876.88 2,970.50 2,810.00 3,716 30%
12,923.38 12,383

material C

CONSUMOS II IF Q COMPRAR
1 5,373.40 3,950.00 4,112.60 5,536 25%
2 2,149.40 4,112.60 4,177.20 2,214 10%
3 3,224.00 4,177.20 4,274.20 3,321 15%
4 2,149.40 4,274.20 4,338.80 2,214 10%
5 2,149.40 4,338.80 4,403.40 2,214 10%
6 6,447.80 4,403.40 4,600.00 6,644 30%
21,493.40 22,143

$ 180.00 $ 280.00

Q
Q COMPRAR A $ COMPRA A Q COMPRAR B $ COMPRA B
COMPRAR C

1 5,854 1,053,720.00 3,096 866,880.00 5,536

2 2,342 421,560.00 1,238 346,640.00 2,214
3 3,513 632,340.00 1,857 519,960.00 3,321
4 2,342 421,560.00 1,238 346,640.00 2,214
5 2,342 421,560.00 1,238 346,640.00 2,214
6 7,024 1,264,320.00 3,716 1,040,480.00 6,644

MATERIAL A
 QII $II Q COMPRADA $ COMPRA C/U

1 5,950 $ 856,800 5,854 1,053,720 162

2 5,747 930,213 2,342 421,560 167
3 5,667 946,914 3,513 632,340 172
4 5,546 954,055 2,342 421,560 174
5 5,465 953,077 2,342 421,560 176
6 5,384 948,032 7,024 1,264,320 178
4,215,060

MATERIAL B

QII $II Q COMPRADA $ COMPRA C/U

1 3,350 $ 770,500 3,096 866,880 254

2 3,215 816,690 1,238 346,640 261
3 3,161 825,711 1,857 519,960 268
4 3,079 825,800 1,238 346,640 272
5 3,025 821,468 1,238 346,640 274
6 2,971 813,973 3,716 1,040,480 277
3,467,240

MATERIAL C

QII $II Q COMPRADA $ COMPRA C/U

1 3,950 $ 948,000 5,536 1,660,800 275

2 4,113 1,131,030 2,214 664,200 284
3 4,177 1,185,318 3,321 996,300 291
4 4,274 1,243,588 2,214 664,200 294
5 4,339 1,275,779 2,214 664,200 296
6 4,403 1,303,642 6,644 1,993,200 298
6,642,900

RESUMEN

QII $II Q COMPRADA $ COMPRA C/U

1 $ 2,575,300 $ 3,581,400
 2 $ 2,877,933 $ 1,432,400
3 $ 2,957,943 $ 2,148,600
4 $ 3,023,444 $ 1,432,400
5 $ 3,050,325 $ 1,432,400
6 $ 3,065,647 $ 4,298,000
14,325,200

COSTO ENSUEÑO

QA $A QB $B QC
1 3,416.75 553,013 1,708.38 433,953 2,733.40
2 1,366.75 228,394 683.38 178,524 1,093.40
3 2,050.00 352,685 1,025.00 274,887 1,640.00
4 1,366.75 238,367 683.38 185,585 1,093.40
5 1,366.75 240,662 683.38 187,258 1,093.40
6 4,099.75 730,987 2,049.88 568,518 3,279.80

COSTO AMBICION

QA $A QB $B QC
1 1,215.00 196,652 810.00 205,752 1,215.00
2 486.00 81,214 324.00 84,641 486.00
3 729.00 125,418 486.00 130,337 729.00
4 486.00 84,761 324.00 87,989 486.00
5 486.00 85,576 324.00 88,782 486.00
6 1,458.00 259,962 972.00 269,577 1,458.00

COSTO PARAISO

QA $A QB $B QC
1 1,425.00 230,641 712.50 180,986 1,425.00
2 570.00 95,251 285.00 74,453 570.00
3 855.00 147,095 427.50 114,648 855.00
4 570.00 99,411 285.00 77,398 570.00
5 570.00 100,367 285.00 78,095 570.00
6 1,710.00 304,894 855.00 237,128 1,710.00

ENSUEÑO AMBICION PARAISO TOTAL

1 1,738,694 736,548 803,525 3,278,767
2 717,180 303,762 331,447 1,352,390
3 1,104,733 467,859 510,507 2,083,100
4 745,455 315,653 344,411 1,405,519
5 751,624 318,241 347,213 1,417,078
6 2,278,286 964,646 1,052,332 4,295,264
7,335,973 3,106,709 3,389,435 13,832,117 -
Q COMPRAR 23,417

Q COMPRAR 12,383.00

Q COMPRAR 22,143.00

$ 300.00

$ COMPRA C TOTAL

1,660,800.00 3,581,400
664,200.00 1,432,400
996,300.00 2,148,600
664,200.00 1,432,400
664,200.00 1,432,400
1,993,200.00 4,298,000
Q CONSUMIDA $ CONSUMO QIF $IF

6,056.75 980,307 5,747.25 930,213

2,422.75 404,859 5,666.50 946,914
3,634.00 625,198 5,545.50 954,055
2,422.75 422,538 5,464.75 953,077
2,422.75 426,605 5,384.00 948,032
7,267.75 1,295,843 5,140.00 916,464
4,155,351

Q CONSUMIDA $ CONSUMO QIF $IF

3,230.88 820,690 3,215.13 816,690

1,292.38 337,619 3,160.75 825,711
1,938.50 519,871 3,079.25 825,800
1,292.38 350,972 3,024.88 821,468
1,292.38 354,135 2,970.50 813,973
3,876.88 1,075,224 2,810.00 779,333
3,458,511

Q CONSUMIDA $ CONSUMO QIF $IF

5,373.40 1,477,770 4,112.60 1,131,030

2,149.40 609,912 4,177.20 1,185,318
3,224.00 938,030 4,274.20 1,243,588
2,149.40 632,009 4,338.80 1,275,779
2,149.40 636,337 4,403.40 1,303,642
6,447.80 1,924,197 4,600.00 1,372,764
6,218,255

Q CONSUMIDA $ CONSUMO QIF $IF

$ 3,278,767 $ 2,877,933
 $ 1,352,390 $ 2,957,943
$ 2,083,100 $ 3,023,444
$ 1,405,519 $ 3,050,325
$ 1,417,078 $ 3,065,647
$ 4,295,264 $ 3,068,562
13,832,117

$C TOTAL
751,728 1,738,694
310,262 717,180
477,162 1,104,733
321,503 745,455
323,705 751,624
978,781 2,278,286

$C TOTAL
334,144 736,548
137,907 303,762
212,104 467,859
142,903 315,653
143,882 318,241
435,107 964,646

$C TOTAL
391,898 803,525
161,743 331,447
248,764 510,507
167,603 344,411
168,750 347,213
510,310 1,052,332
 $ HH ENSUEÑO AMBICIONPARAISO
X 960 32 21 ###
Y 920 24 16 8
Z 840 14 9 5

ENSUEÑO AMBICION PARAISO

X 0.032 0.021 0.011
Y 0.024 0.016 0.008
Z 0.014 0.009 0.005

ENSUEÑO
0.032 0.024 0.014
QP X Y Z
1 13,667 437.344 328.008 191.338
2 5,467 174.944 131.208 76.538
3 8,200 262.4 196.8 114.8
4 5,467 174.944 131.208 76.538
5 5,467 174.944 131.208 76.538
6 16,399 524.768 393.576 229.586

AMBICION

0.021 0.016 0.009

QP X Y Z
1 8,100 170.1 129.6 72.9
2 3,240 68.04 51.84 29.16
3 4,860 102.06 77.76 43.74
4 3,240 68.04 51.84 29.16
5 3,240 68.04 51.84 29.16
6 9,720 204.12 155.52 87.48

PARAISO
 0.011 0.008 0.005
QP X Y Z
1 14,250 156.75 114 71.25
2 5,700 62.7 45.6 28.5
3 8,550 94.05 68.4 42.75
4 5,700 62.7 45.6 28.5
5 5,700 62.7 45.6 28.5
6 17,100 188.1 136.8 85.5

ENSUEÑO AMBICION PARAISO TOTAL

1 $ 882,342 $ 343,764 $ 315,210 $ 1,541,316
2 $ 352,950 $ 137,506 $ 126,084 $ 616,539
3 $ 529,392 $ 206,258 $ 189,126 $ 924,776
4 $ 352,950 $ 137,506 $ 126,084 $ 616,539
5 $ 352,950 $ 137,506 $ 126,084 $ 616,539
6 $ 1,058,719 $ 412,517 $ 378,252 $ 1,849,488
$ 3,529,302 $ 1,375,056 $ 1,260,840 $ 6,165,198

TOTAL HH
ENSUEÑO AMBICION PARAISO TOTAL
1 957 373 342 1671
2 383 149 137 669
3 574 224 205 1003
4 383 149 137 669
5 383 149 137 669
6 1148 447 410 2005
PARAISO

$ 960 $ 920 $ 840

X Y Z TOTAL
$ 419,850 $ 301,767 $ 160,724 $ 882,342
$ 167,946 $ 120,711 $ 64,292 $ 352,950
$ 251,904 $ 181,056 $ 96,432 $ 529,392
$ 167,946 $ 120,711 $ 64,292 $ 352,950
$ 167,946 $ 120,711 $ 64,292 $ 352,950
$ 503,777 $ 362,090 $ 192,852 $ 1,058,719

$ 960 $ 920 $ 840

X Y Z TOTAL
$ 163,296 $ 119,232 $ 61,236 $ 343,764
$ 65,318 $ 47,693 $ 24,494 $ 137,506
$ 97,978 $ 71,539 $ 36,742 $ 206,258
$ 65,318 $ 47,693 $ 24,494 $ 137,506
$ 65,318 $ 47,693 $ 24,494 $ 137,506
$ 195,955 $ 143,078 $ 73,483 $ 412,517
$ 960 $ 920 $ 840
X Y Z TOTAL
$ 150,480 $ 104,880 $ 59,850 $ 315,210
$ 60,192 $ 41,952 $ 23,940 $ 126,084
$ 90,288 $ 62,928 $ 35,910 $ 189,126
$ 60,192 $ 41,952 $ 23,940 $ 126,084
$ 60,192 $ 41,952 $ 23,940 $ 126,084
$ 180,576 $ 125,856 $ 71,820 $ 378,252
 CIF 7,200,000

CIF BIMESTRAL HH TASA ENSUEÑO AMBICIONPARAISO TOTAL

1 1,200,000 1671 718 686,911 267,530 245,559 1,200,000
2 1,200,000 669 1,795 686,922 267,524 245,554 1,200,000
3 1,200,000 1003 1,197 686,904 267,534 245,562 1,200,000
4 1,200,000 669 1,795 686,922 267,524 245,554 1,200,000
5 1,200,000 669 1,795 686,922 267,524 245,554 1,200,000
6 1,200,000 2005 598 686,886 267,543 245,571 1,200,000
ENSUEÑO
M PRIMA MOD CIF TOTAL
1 1,738,694 882,342 686,911 3,307,947
2 717,180 352,950 686,922 1,757,052
3 1,104,733 529,392 686,904 2,321,029
4 745,455 352,950 686,922 1,785,327
5 751,624 352,950 686,922 1,791,496
6 2,278,286 1,058,719 686,886 4,023,892

AMBICION
M PRIMA MOD CIF TOTAL
1 736,548 343,764 267,530 1,347,842
2 303,762 137,506 267,524 708,792
3 467,859 206,258 267,534 941,651
4 315,653 137,506 267,524 720,683
5 318,241 137,506 267,524 723,270
6 964,646 412,517 267,543 1,644,706

PARAISO
M PRIMA MOD CIF TOTAL
1 803,525 315,210 245,559 1,364,293
2 331,447 126,084 245,554 703,085
3 510,507 189,126 245,562 945,196
4 344,411 126,084 245,554 716,049
5 347,213 126,084 245,554 718,851
6 1,052,332 378,252 245,571 1,676,155

ENSUEÑO AMBICION PARAISO TOTAL

1 3,307,947 1,347,842 1,364,293 6,020,083
2 1,757,052 708,792 703,085 3,168,929
3 2,321,029 941,651 945,196 4,207,876
4 1,785,327 720,683 716,049 3,222,058
5 1,791,496 723,270 718,851 3,233,617
6 4,023,892 1,644,706 1,676,155 7,344,752

14,986,743 6,086,944 6,123,628 27,197,315