taller copy
TRANSCRIPT
-
7/25/2019 Taller Copy
1/29
Datos para elaborar el plan agregado
Costos
Concepto Costo
$ 238$ 50
$ 39
$ 980
$ 1,010
Qrh = Mano de obra requerida/unidad $ 3
$ 72
$ 12
$ 3,200
Cantidad de unidades producidas por persona al mes 1,000
Tiempo de fabricacin und / hr (Valor promedio) 104
! de horas e"tras permitidas por persona al d#a 3
$n%entario inicial al momento de la planeacin 4,500
$n%entario final al &' mes 5,200
Cantidad de personas al inicio 20
recio de %enta del producto $ 230
Cm = Materiales/unidadCi= Costo de mantener el in%entario/unidad/mes
Cf= Costo por agotados/unidad/mes
Cc = Costos Contratacin entrenamiento/traba*ador
Cd = Costos de despido/traba*ador
Crh = Costo del tiempo ordinario/hora
Che = Costo de horas e"tra/hora
Csb = Costo de subcontratacin/unidad
-
7/25/2019 Taller Copy
2/29
ronstico de la demanda
eriodo ronstico demanda
1 2,900
GRUPO
2 2,700 Grupo 1 20,0003 1,500 Grupo 2 11,5004 2,700 Grupo 3 8,5005 3,600 Grupo 4 8,6506 3,300 Grupo 5 5,1007 2,850 Grupo 6 5,5008 3,200
9 3,000
10 2,900
11 3,600
12 3,950
CAP PRODMES
-
7/25/2019 Taller Copy
3/29
TOTAL H. EXTRA 5544HR/DA 8DAS MES 24
! PSO"S U"D/HR
4,500 5,200 20 1,000 104 1,4402,800 3,200 11 1,045 60 #$21,200 1,500 10 850 44 #201,$50 2,400 $ $61 45 6481,400 1,800 12 425 2# 8642,100 2,600 15 366 2$ 1,080
"%E"TARO"CAL
"%E"TARO&"AL
U"D PROD /PSO"A 'MES(
TEMPOEXTRA MAX
POR MES
-
7/25/2019 Taller Copy
4/29
PLAN AGREGADO
Tabla variables de decisin
!C')( !D')( !RH')( !HR')( !&')( !&')( !*+')(
PERIODO
CONTRATACI
DESPIDO
RECHUMANO
TIEMPO
EXTR
INVENTARIO
AGOTADOS
S.
CONTATACI
20 4,5001 0 20 0 0 1,600 0 02 0 0 1 0 0 0 03 0 0 2 0 0 0 04 0 0 3 0 0 0 05 0 0 4 0 0 0 06 0 0 3 0 0 0 0# 0 0 3 0 0 0 08 0 0 3 0 0 0 0$ 0 0 3 0 0 0 0
10 0 0 3 0 0 0 0
11 0 0 4 0 0 0 012 0 0 4 0 0 0 0
-
7/25/2019 Taller Copy
5/29
!P')( C+ C
Q.
PRODUCCI
DEMANDA
PRECIO
PERIODO
CONTRATACI
DESPIDO
0 2,$00 -221.3 1 -0.0 -20,200.01,100 2,#00 -221.3 2 -0.0 -0.01,500 1,500 -221.3 3 -0.0 -0.02,#00 2,#00 -221.3 4 -0.0 -0.03,600 3,600 -221.3 5 -0.0 -0.03,300 3,300 -221.3 6 -0.0 -303.02,850 2,850 -221.3 # -0.0 -454.53,200 3,200 -221.3 8 -0.0 -0.03,000 3,000 -221.3 $ -0.0 -202.02,$00 2,$00 -221.3 10 -0.0 -101.0
3,600 3,600 -221.3 11 -0.0 -0.03,$50 3,$50 -221.3 12 -0.0 -0.0
-
7/25/2019 Taller Copy
6/29
Tabla de costos del plan agregado
Cr C) C C
RECHUMANO
TIEMPO
EXTR
INVENTARIO
AGOTADOS
-0.0 -0.0 -80,000.0 -0.0-12,6#2.0 -0.0 -0.0 -0.0-1#,280.0 -0.0 -0.0 -0.0-31,104.0 -0.0 -0.0 -0.0-41,4#2.0 -0.0 -0.0 -0.0-38,016.0 -0.0 -0.0 -0.0-32,832.0 -0.0 -0.0 -0.0-36,864.0 -0.0 -0.0 -0.0-34,560.0 -0.0 -0.0 -0.0-33,408.0 -0.0 -0.0 -0.0
-41,4#2.0 -0.0 -0.0 -0.0-45,504.0 -0.0 -0.0 -0.0
-
7/25/2019 Taller Copy
7/29
TABLA RESTRI
C* C
MATERIALES
PERIODO
-0.0 -0.0 1 0 0-0.0 -261,800.0 2 1 0-0.0 -35#,000.0 3 0 0-0.0 -642,600.0 4 1 0-0.0 -856,800.0 5 1 0-0.0 -#85,400.0 6 0 0-0.0 -6#8,300.0 # 0 0-0.0 -#61,600.0 8 0 0-0.0 -#14,000.0 $ 0 0-0.0 -6$0,200.0 10 0 0
-0.0 -856,800.0 11 1 0-0.0 -$40,100.0 12 0 0
S.CONTATACIO
N RECURSO
HUMANO
CAPACIDAD
PLANTA
-
7/25/2019 Taller Copy
8/29
CIONES
INVENTARIO
TIEMPO
EXTR
0 0 Co*)o )o) -8,011,044.50 3 7r*o* -8,011,060.00 5 U)* -15.50 80 110 100 $0 100 $0 $
0 110 12
-
7/25/2019 Taller Copy
9/29
Cp+ prou++ 2,900
eriodo
1 2,900 2,900 2,900
2 2,700 5,600 5,800
3 1,500 7,100 8,700
4 2,700 9,800 11,600
5 3,600 13,400 14,500
6 3,300 16,700 17,400
7 2,850 19,550 20,300
8 3,200 22,750 23,200
9 3,000 25,750 26,100
10 2,900 28,650 29,000
11 3,600 32,250 31,900
12 3,950 36,200 34,800
Demandapronosticada
Demandapronosticada
Acum
CapacidadProduccin
19
5,000
10,000
15,000
20,000
25,000
30,000
35,000
40,000
-
7/25/2019 Taller Copy
10/29
2 3 4 5 6 # 8 $ 10 11 12
D
Cp
-
7/25/2019 Taller Copy
11/29
proo*)+ A+u
+ Prou++
-
7/25/2019 Taller Copy
12/29
DESCRPCO" 9 9
D)A:O Su 9 E"ERO Su 9 &E;RERO Su 9 MAR
-
7/25/2019 Taller Copy
13/29
Su 9 A;RL Su 9 MA=O Su 9 >U"O Su 9 >ULO10,51$ #,$52 $,4#2 10,66612,35$ 10,$55 11,6#2 13,$$815,#26 12,2#5 13,$2$ 15,#$$1$,#36 14,603 14,860 1#,4$#22,123 1$,131 1$,3#6 22,48521,04$ 22,355 21,516 26,32$24,3$0 26,100 26,226 2$,$5430,#8$ 32,055 28,30# 30,#0132,635 40,124 34,#30 3$,5#638,$28 52,803 38,43$ 4#,4#8
22&,2# 2'&,'#' 21&,#2" 2#,&'
-
7/25/2019 Taller Copy
14/29
Su 9 AGOSTO Su 9 SEPTEM;RE Su 9 OCTU;RE8,#86 3,$31 4,636
11,666 4,8$0 5,25212,#01 5,8$2 6,46014,032 #,000 #,$031#,36$ 8,084 8,85521,226 8,384 10,5#026,466 10,46$ 13,4#330,062 14,0$6 16,05432,458 1#,$51 18,53043,155 1$,545 21,84#
21",%21 1$$,22 11',#&$
-
7/25/2019 Taller Copy
15/29
Su 9 "O%EM;RE Su 9 DCEM;RE4,$52 #,1$35,#06 #,#2##,561 $,603$,254 11,536
11,#43 15,85115,88$ 16,5$620,0#4 1$,4$420,#54 25,44324,4#6 30,83830,105 34,40#
1#$,#1 1"&,!&&
-
7/25/2019 Taller Copy
16/29
+,- C-D$.- D0C1$C$- 1- 2311- M+14- +31$5 M+6- 78$-
2010 10103010 GRUPO 1 4,445 12,273 13,375 15,271 24,577 10,702
2010 10103020 GRUPO 2 6,381 6,404 8,656 7,120 7,805 4,353
2010 10103110 GRUPO 3 1,927 5,558 2,834 4,576 5,815 8,059
2010 10103120 GRUPO 4 1,674 6,503 2,143 4,716 6,889 6,116
2010 10103210 GRUPO 5 3,510 1,180 3,970 3,376 4,104 4,391
2010 10103310 GRUPO 6 4,873 1,072 4,911 3,869 3,613 4,8182009 10103010 GRUPO 1 4,357 10,713 10,211 13,726 16,773 11,953
2009 10103020 GRUPO 2 6,031 4,347 9,640 4,935 7,447 3,270
2009 10103110 GRUPO 3 1,669 4,268 1,767 3,694 4,568 6,023
2009 10103120 GRUPO 4 1,570 4,086 2,217 4,037 4,784 6,079
2009 10103210 GRUPO 5 4,325 877 2,720 3,004 3,518 3,436
2009 10103310 GRUPO 6 2,528 1,291 3,246 3,239 3,034 3,969
2008 10103010 GRUPO 1 3,468 10,936 9,359 14,694 13,136 7,710
2008 10103020 GRUPO 2 4,331 3,985 7,739 3,401 4,459 2,627
2008 10103110 GRUPO 3 1,330 2,690 1,415 2,600 3,792 5,596
2008 10103120 GRUPO 4 1,372 3,206 2,473 3,436 4,332 5,128
2008 10103210 GRUPO 5 3,141 752 2,421 2,550 3,041 3,2162008 10103310 GRUPO 6 2,020 968 2,427 4,108 3,295 4,030
2007 10103010 GRUPO 1 2,747 11,207 6,825 10,015 10,936 7,194
2007 10103020 GRUPO 2 4,738 3,797 8,808 4,226 4,271 1,972
2007 10103110 GRUPO 3 987 2,830 1,463 2,720 2,601 5,993
2007 10103120 GRUPO 4 962 1,984 1,355 2,851 3,824 4,800
2007 10103210 GRUPO 5 2,284 708 2,379 1,602 1,757 2,551
2007 10103310 GRUPO 6 1,835 823 1,774 2,976 2,711 3,716
2006 10103010 GRUPO 1 2,512 8,518 6,611 9,405 10,605 4,703
2006 10103020 GRUPO 2 3,517 2,573 6,198 3,121 2,882 2,079
2006 10103110 GRUPO 3 942 2,707 980 1,994 2,454 5,097
2006 10103120 GRUPO 4 874 1,862 1,238 2,481 2,989 4,115
2006 10103210 GRUPO 5 2,630 558 1,792 1,473 1,500 2,506
2006 10103310 GRUPO 6 1,547 988 1,943 2,575 1,925 3,016
2005 10103010 GRUPO 1 2,135 6,654 4,720 11,068 9,206 4,459
2005 10103020 GRUPO 2 2,534 2,276 5,884 3,057 2,775 1,765
2005 10103110 GRUPO 3 934 1,685 989 2,108 1,924 4,334
2005 10103120 GRUPO 4 729 1,382 1,162 2,781 2,480 4,209
2005 10103210 GRUPO 5 2,087 530 1,426 1,212 1,353 1,981
2005 10103310 GRUPO 6 1,175 880 1,691 1,897 1,393 2,628
2004 10103010 GRUPO 1 2,285 4,533 4,285 10,133 6,326 2,848
2004 10103020 GRUPO 2 2,357 1,973 4,913 2,774 2,975 1,592
2004 10103110 GRUPO 3 852 1,301 858 1,339 1,445 4,192
2004 10103120 GRUPO 4 540 1,514 875 2,077 1,563 2,885
2004 10103210 GRUPO 5 2,036 381 1,427 1,252 983 1,449
2004 10103310 GRUPO 6 973 743 1,047 2,161 1,311 1,894
2003 10103010 GRUPO 1 1,380 4,238 4,376 8,397 5,514 2,721
2003 10103020 GRUPO 2 3,038 1,703 4,822 2,060 1,744 1,727
2003 10103110 GRUPO 3 733 1,330 630 1,157 1,237 3,740
2003 10103120 GRUPO 4 493 1,042 627 1,991 1,385 3,188
2003 10103210 GRUPO 5 1,581 378 1,244 850 1,223 1,301
-
7/25/2019 Taller Copy
17/29
2003 10103310 GRUPO 6 766 559 730 1,271 1,172 1,252
2002 10103010 GRUPO 1 1,234 3,929 2,950 5,205 5,815 1,885
2002 10103020 GRUPO 2 1,669 1,596 3,798 1,643 1,534 1,792
2002 10103110 GRUPO 3 542 1,029 542 1,007 748 2,499
2002 10103120 GRUPO 4 461 829 564 2,177 1,204 3,021
2002 10103210 GRUPO 5 1,112 304 918 767 1,010 1,156
2002 10103310 GRUPO 6 709 447 634 1,560 644 1,319
2001 10103010 GRUPO 1 920 3,077 2,513 4,362 3,894 1,791
2001 10103020 GRUPO 2 1,447 1,445 4,162 1,363 934 1,322
2001 10103110 GRUPO 3 559 880 514 969 733 2,412
2001 10103120 GRUPO 4 415 636 414 1,851 1,086 2,172
2001 10103210 GRUPO 5 724 261 733 644 770 720
2001 10103310 GRUPO 6 519 451 621 1,330 535 1,055
-
7/25/2019 Taller Copy
18/29
785$- +.-0T- 0T$M31 -CT831 -V$M31 D$C$M31
13,965 10,109 3,149 4,120 12,721 8,642
10,691 11,006 4,635 4,909 9,405 8,899
7,423 6,878 3,320 3,957 1,902 4,885
6,615 6,500 2,617 4,266 2,394 5,397
4,449 4,456 2,912 2,045 1,860 3,077
4,335 4,206 2,912 2,550 1,823 3,50711,061 7,583 3,299 3,318 7,786 7,167
8,789 6,028 3,678 4,635 8,604 9,210
5,447 5,695 2,775 3,241 2,082 4,746
6,845 5,636 2,286 3,148 1,986 4,573
3,673 4,188 2,840 1,958 2,051 2,138
3,761 3,328 3,073 2,230 1,967 3,004
7,975 6,188 2,657 3,080 8,091 8,340
7,173 6,803 2,545 3,302 5,943 7,156
5,720 5,175 1,689 3,378 1,736 2,856
5,031 4,671 1,862 2,672 1,647 2,645
2,378 2,965 2,333 1,846 1,728 2,0012,424 4,260 3,010 1,776 1,609 2,445
9,573 6,149 1,499 2,403 8,739 5,490
5,127 6,464 2,503 2,436 5,706 5,790
5,186 3,600 1,941 3,153 1,402 2,246
5,464 5,190 1,327 2,519 1,637 2,910
2,006 2,781 1,315 1,326 1,238 1,338
2,598 2,282 1,884 1,636 1,352 1,720
8,253 5,022 1,365 2,430 6,947 4,118
5,144 5,549 1,757 1,969 4,265 4,835
4,835 2,547 1,065 2,309 973 2,246
4,450 4,375 1,101 1,461 1,533 2,829
1,322 1,982 1,364 999 1,201 1,119
2,325 1,751 1,732 1,402 970 1,449
7,371 4,420 1,425 1,875 3,899 4,091
4,373 4,556 1,824 1,847 4,052 4,429
4,054 1,857 1,210 1,458 867 2,042
3,670 3,863 1,122 1,161 1,160 2,695
1,417 1,489 1,209 941 926 1,216
1,600 1,184 1,294 1,573 839 1,378
4,638 2,850 1,013 1,471 3,246 3,090
4,980 4,006 1,572 1,497 2,777 3,511
3,113 1,426 769 1,306 888 1,454
2,090 3,571 935 1,347 983 1,554
993 1,348 1,167 857 624 824
1,683 831 1,544 1,425 736 1,103
4,935 2,334 974 1,649 2,548 2,910
4,333 3,522 1,287 1,143 2,707 2,758
2,468 1,177 664 1,050 577 1,280
1,690 3,428 775 1,022 677 1,043
875 1,306 906 550 594 653
-
7/25/2019 Taller Copy
19/29
-
7/25/2019 Taller Copy
20/29
D)DESCRPCO" A:O Su 9 E"ERO Su 9 &E;REROGRUPO 1 8,802 22,$86
200$ 4,35# 10,#132010 4,445 12,2#3
GRUPO 2 12,412 10,#51200$ 6,031 4,34#2010 6,381 6,404
GRUPO 3 3,5$6 $,826200$ 1,66$ 4,2682010 1,$2# 5,558
GRUPO 4 3,244 10,58$200$ 1,5#0 4,0862010 1,6#4 6,503
GRUPO 5 #,835 2,05#200$ 4,325 8##
2010 3,510 1,180GRUPO 6 #,401 2,363
200$ 2,528 1,2$12010 4,8#3 1,0#2
Total Result ',2%$ #&,#"2
"CGRUPO PROMEDIO DESV ESTANDAR ESTABILIDAD
1 10,054 5,108 4$.2?
2 6,$53 2,300 66.$?
3 4,2$6 1,842 5#.1?4 4,2$5 1,851 56.$?
5 3,086 1,053 65.$?
6 3,215 1,060 6#.0?
"CGRUPO PROMEDIO DESV ESTANDAR ESTABILIDAD
1 10,054 503 $5.0?
2 6,$53 348 $5.0?
3 4,2$6 215 $5.0?
4 4,2$5 215 $5.0?5 3,086 154 $5.0?
6 3,215 161 $5.0?
-
7/25/2019 Taller Copy
21/29
-
7/25/2019 Taller Copy
22/29
Su 9 MARU"O23,586 28,$$# 41,350 22,65510,211 13,#26 16,##3 11,$5313,3#5 15,2#1 24,5## 10,#0218,2$6 12,055 15,252 #,623
$,640 4,$35 #,44# 3,2#08,656 #,120 #,805 4,3534,601 8,2#0 10,383 14,0821,#6# 3,6$4 4,568 6,0232,834 4,5#6 5,815 8,05$4,360 8,#53 11,6#3 12,1$52,21# 4,03# 4,#84 6,0#$2,143 4,#16 6,88$ 6,1166,6$0 6,380 #,622 #,82#2,#20 3,004 3,518 3,436
3,$#0 3,3#6 4,104 4,3$18,15# #,108 6,64# 8,#8#3,246 3,23$ 3,034 3,$6$4,$11 3,86$ 3,613 4,818
!#,!%$ "1,#!' %2,%2" "',1!%
$5? 1.64POT CAP PROD INST Cr UTIL
18,455 20,000 0.$2 50.3?10,#3# 11,500 0.$3 60.5?
#,325 8,500 0.86 50.5?#,340 8,650 0.85 4$.#?4,818 5,100 0.$4 60.5?4,$5$ 5,500 0.$0 58.5?
$5? 1.64POT CAPACIDAD Cr UTIL
10,881 22,500 0.48 44.#?#,525 11,250 0.6# 61.8?4,650 8,500 0.55 50.5?
4,648 8,650 0.54 4$.#?3,340 5,100 0.65 60.5?3,4#$ 5,500 0.63 58.5?
-
7/25/2019 Taller Copy
23/29
-
7/25/2019 Taller Copy
24/29
Su 9 >ULO Su 9 AGOSTO Su 9 SEPTEM;RE25,026 1#,6$2 6,44811,061 #,583 3,2$$13,$65 10,10$ 3,14$1$,480 1#,034 8,3138,#8$ 6,028 3,6#8
10,6$1 11,006 4,63512,8#0 12,5#3 6,0$55,44# 5,6$5 2,##5#,423 6,8#8 3,320
13,460 12,136 4,$036,845 5,636 2,2866,615 6,500 2,61#8,122 8,644 5,#523,6#3 4,188 2,840
4,44$ 4,456 2,$128,0$6 #,534 5,$853,#61 3,328 3,0#34,335 4,206 2,$12
&",$# "#,!1' '",%!
PROM AJUST LS LI
10,054 18,455 1,653
6,$53 10,#3# 3,1#0
4,2$6 #,325 1,26#4,2$5 #,340 1,250
3,086 4,818 1,354
3,215 4,$5$ 1,4#1
PROM AJUST LS LI
10,054 10,881 $,22#
6,$53 #,525 6,381
4,2$6 4,650 3,$43
4,2$5 4,648 3,$423,086 3,340 2,832
3,215 3,4#$ 2,$51
-
7/25/2019 Taller Copy
25/29
-
7/25/2019 Taller Copy
26/29
Su 9 OCTU;RE Su 9 "O%EM;RE Su 9 DCEM;RE#,438 20,50# 15,80$3,318 #,#86 #,16#4,120 12,#21 8,642$,544 18,00$ 18,10$4,635 8,604 $,2104,$0$ $,405 8,8$$#,1$8 3,$84 $,6313,241 2,082 4,#463,$5# 1,$02 4,885#,414 4,380 $,$#03,148 1,$86 4,5#34,266 2,3$4 5,3$#4,003 3,$11 5,2151,$58 2,051 2,138
2,045 1,860 3,0##4,#80 3,#$0 6,5112,230 1,$6# 3,0042,550 1,823 3,50#
$,'"" #,#&1 !#,2#
ICP
0.548 16,8030.548 #,56#
0.548 6,0580.548 6,0$00.548 3,4640.548 3,48#
ICP
0.548 1,6540.548 1,1440.548 #0#
0.548 #060.548 5080.548 52$
-
7/25/2019 Taller Copy
27/29
-
7/25/2019 Taller Copy
28/29
GRUPO 1 GRUPO 2 GRUPO 3 GRUPO 4E"ERO 430$ 5686 154$ 1510&E;RERO 11068 4635 4885 4542MARU"O 11348 32$2 65$4 6481>ULO 12#12 $11# 64$0 5362AGOSTO 10123 #681 4548 5065SEPTEM;RE 2854 4124 2#$3 2283OCTU;RE 3$68 4#21 341# 36$5"O%EM;RE 1062$ 6333 1621 1888DCEM;RE $148 #443 4541 4534
$65$.33333 6184.6666# 3$60.25 3$$$.1666# 4500 2800 1200 1$50& 5400 3360 1440 2340
-
7/25/2019 Taller Copy
29/29
GRUPO 5 GRUPO 62824 34641034 11063452 36812638 35843444 31$3
3421 400$338# 368535$1 3#832165 301$2331 22131#21 15$22$20 285$2#44 3015.6666#1400 21001680 2520