talleer presupuesto completo estudiantes jueves

8/19/2019 Talleer Presupuesto Completo Estudiantes Jueves

1/34

TALLER PRESUPUESTO.La empresa LACTEOS DUITAMA LTDA se encuentra en el mercado con tres productos A, B y C el precountaro de cada producto es!

A " #$%B " &'%C " ()%

Los datos *storcos +ue se muestran son!

AÑO PRODUCTO B PRODUCTO C

) #% ')% &%& #& '' $'$ #'' '(% '# #(% '- -%' #-) #)( -# #% / /)' $,(- &,-$) &,&-

Real0ar la proyeccon para el a1o # por el metodo de mnmos cuadrados

La empresa LACTEOS DUITAMA LTDA tene una partcpacon en cudades! Tun2a, Dutama, So3amoso y papa

PRODUCTO/PERIODO

1 2 3ZONA A B C A B C A BTunja #4 (4 $4 &4 4 )'4 (4 $4

Duitama )%4 -4 '4 $4 #4 4 )&4 4Sogamoso '4 4 -4 )%4 )%4 (4 -4 '4

Paipa 4 ))4 4 '4 '4 4 -4 $4TOTAL $%4 $'4 &'4 &%4 &'4 $'4 $'4 )'4

Se requiere Presupuesto de entas ! unidades para e" a#o $%Los productos consumen tpos de materales

MP ) MP & MP $ MP

LT LT PIE5AS U6D A ' # $

B ( $ C & $ ' '

MP ) MP & MP $ MP LT LT PIE5AS U6D

COSTO U&'TAR'O )%.( ).' )$. )#.'

Cada trmestre los costos untaros ncrementan

) MP ) " )&4& MP & " #4$ MP $ " -4 MP " 4

Proyeccon 7entas a1o #, de producc8n de materales re+uerdos dada en mles

A B CIn7entaro I $' $) &-

PRODUCT A


2/34

PRODUCTO/PERIODO 1ZONA U6D A U6D

Tunja #%.# ). #$.#Duitama #%.# #.%# #$.#

Sogamoso #%.# $.'$ #$.#Paipa #%.# #&.)' #$.#

TOTAL &%(.)- &'(.%

PRODUCTO/PERIODO 1ZONA U6D A U6D

Tunja $'.%(- ; .)% )#%.%%Duitama $'.%(- ; $.'%- )#%.%%

Sogamoso $'.%(- ; &).(' )#%.%%Paipa $'.%(- ; $.)'( )#%.%%

TOTAL )$%.'&$ #$.#%%

P


3/34

2B U6D C A B

'.%' ')-.)% )'.' )$.-) &'.(

'). ')-.)% &'.) &%.(& $-.#&

'(.& ')-.)% ).' #.%# #.$#

(%.-% ')-.)% #.#$ $.'$ $&.)-

&&'. &%(&.% )&.'$ )$-.)& )#%.%

2B U6D C A B

; )).$ $#(.-') ; )).%$# -.(%& ; #.$#

; )&.-(& $#(.-') ; )-.$$ )$.%'& ; .#'

; ).-) $#(.-') ; &.&- $.'%- ; )#.%%

; )(.# $#(.-') ; $$.)%( &).(' ; -.%'

'#.$)' )().% ).#$ -(.%)# %.&&'


4/34

3C A B C A

((.(& -.$ ).$%- )%.$# #.)

&%.(& -&.-( &'.( )'.' -.$

$#.&( ''.&' $&.)- &'.) &%.(&

#.#$ ''.&' ).$%- &'.) &(.#&

)-).$ &).() #.' ((.(& )%$.'

3C A B C A

; ''.)(- ; $%.'' ; .-&( ; (.$'( ; .$')

; ).() ; '&.&% ; #.$# ; )).%$# ; $%.''

; &'.('% ; $.-%# ; -.%' ; )-.$$ ; )$.%'&

; $$.)%( ; $.-%# ; .-&( ; )-.$$ ; )(.%$

)&-.(- )'&.&(( &.)$' ''.)(- #'.&


5/34

4 TOTAL A TOTAL B TOTAL C

B C

).$) ').-) 110.50 109.41 155.43

'). $#.&( 220.99 167.34 98.44

(%.-% )'.' 179.56 225.26 119.16

).$) &'.) 179.56 141.59 145.07

)#%.% )&.'$ #%.#% #$.#% ')-.)%

4 TOTAL A TOTAL B TOTAL C

B C

; .-&( ; $#.(-' ; #.#)& ; &(.$'$ ; ))%.$''

; )&.-(& ; &'.('% ; )$.&&' ; ).-$ ; #.-&

; )(.# ; )).%$# ; ))$.)&% ; '#.$)' ; -.#%#

; .-&( ; )-.$$ ; ))$.)&% ; $'.$- ; )%&.-

%.&&' ).#$ $'.%(- )#%.%% $#(.-')


6/34

1 2

A B C A B

()&TAR'O '&'C'A $'.%% $).%% &-.%% &(.#& $&.)-

U&D A ()&D)R &%(.)- &&'. )&.'$ )$-.)& )#%.%

&()&TAR'O +'&A &(.#& $&.)- $#.&( -.$ ).$)

AD)S D'SPO&'B &$.-% &'(. )#'.( )-#.# )-%.&)IDADES A PRODU ).-% &. )$(.( )'-.- )-.%$


7/34

3 4

C A B C A B

$#.&( -.$ ).$) )'.' &%.(& $&.)-

)-).$ &).() #.' ((.(& )%$.' )#%.%

)'.' &%.(& $&.)- &'.) &(.%% $$.%%

)#.-- &.$ )&-.(& )%$.#& )$%.' )$.%)#%.#) &).% )%.) --.%- )%.-( )#).(&


8/34

C

&'.)

)&.'$

&'.%%

)'.'$)&-.#&


9/34

SALARIO

CARGO MENSUAL

PRODUCCION

OP)RAR'O D1 650,000.00

OP)RAR'O D1 650,000.00

OP)RAR'O D2 700,000.00

SUP)R('SOR D3 750,000.00

OP)RAR'O D4 650,000.00

OP)RAR'O D4 650,000.00

SUPERVISOR D5 850,000.00

TOTAL NOMINA 4,900,000.00

TOTAL PARA PRESUPUESTO 4,900,000.00

CARGO TOTAL DEVENGADO

PRODUCCION

OP)RAR'O D1 $ 724,000.00OP)RAR'O D1 $ 724,000.00

OP)RAR'O D2 $ 774,000.00

SUP)R('SOR D3 $ 824,000.00

OP)RAR'O D4 $ 724,000.00

OP)RAR'O D4 $ 724,000.00

SUPERVISOR D5 $ 924,000.00

TOTAL NOMINA $ 5,418,000.00


10/34

INTERESES

AUILIO TOTAL CESANTIAS CESANTIAS

TRANSPORTE DEVENGADO !

74,000.00 724,000.00 60,333.33 7,240.00

74,000.00 724,000.00 60,333.33 7,240.00

74,000.00 774,000.00 64,500.00 7,740.00

74,000.00 824,000.00 68,666.67 8,240.00

74,000.00 724,000.00 60,333.33 7,240.00

74,000.00 724,000.00 60,333.33 7,240.00

74,000.00 924,000.00 77,000.00 9,240.00

!

518,000.00 5,418,000.00 451,500.00 54,180.00

518,000.00 5,418,000.00 451,500.00 54,180.00

VALOR "ORA

353,093.00 $ 1,077,093.00 4,487.89353,093.00 $ 1,077,093.00 4,487.89

379,020.67 $ 1,153,020.67 4,804.25

404,948.33 $ 1,228,948.33 5,120.62

353,093.00 $ 1,077,093.00 4,487.89

353,093.00 $ 1,077,093.00 4,487.89

456,803.67 $ 1,380,803.67 5,753.35

$ 2,653,144.67 $ 8,071,144.67 $ 33,629.77

TOTALAPROPIACIONES #

PROVICIONESCOSTOS MANO DE

OBRA


11/34

PRIMA APORTES APORTES

SERVICIOS VACACIONES SALUD PENSION

60,333.33 27,083.33 55,250.00 78,000.00

60,333.33 27,083.33 55,250.00 78,000.00

64,500.00 29,166.67 59,500.00 84,000.00

68,666.67 31,250.00 63,750.00 90,000.00

60,333.33 27,083.33 55,250.00 78,000.00

60,333.33 27,083.33 55,250.00 78,000.00

77,000.00 35,416.67 72,250.00 102,000.00

451,500.00 204,166.67 ### 588,000.00

451,500.00 204,166.67 ### 588,000.00


12/34

APORTES APORTES APORTES APORTES

ARP CAA COMP ICB% SENA

-

3,393.00 28,960.00 19,500.00 13,000.00

3,393.00 28,960.00 19,500.00 13,000.00

3,654.00 30,960.00 21,000.00 14,000.00

3,915.00 32,960.00 22,500.00 15,000.00

3,393.00 28,960.00 19,500.00 13,000.00

3,393.00 28,960.00 19,500.00 13,000.00

4,437.00 36,960.00 25,500.00 17,000.00

25,578.00 216,720.00 147,000.00 98,000.00

25,578.00 216,720.00 147,000.00 98,000.00


13/34

PRESUPUESTO MANO

DEPARTAMENTO TIEMPO POR UNIDAD

DEPARTAMENTO 01

A 0.30

B 0.60

C 0.60

DEPARTAMENTO 02

A 0.40

B 0.50

C 0.50

DEPARTAMENTO 03

A 0.50

B 0.70

C 0.40

DEPARTAMENTO 04

A 0.70

B 0.60

C 0.90

DEPARTAMENTO 05A 0.50

B 0.90

C 0.80

DEPARTAMENTO VALOR "ORA

DEPARTAMENTO 01

A 4488

B 4488

C 4488

DEPARTAMENTO 02

A 4804

B 4804

C 4804

DEPARTAMENTO 03

A 5121

B 5121


14/34

C 5121

DEPARTAMENTO 04

A 4488

B 4488

C 4488

DEPARTAMENTO 05A 5753B 5753

C 5753


15/34

DE OBRA

PERIODO UNO PERIODO DOS

TIEMPO TOTAL199.80 59.94 0.30 158.84

226.44 135.86 0.60 148.03

137.79 82.68 0.60 160.61

199.80 79.92 0.40 158.84

226.44 113.22 0.50 148.03

137.79 68.90 0.50 160.61

199.80 99.90 0.50 158.84

226.44 158.51 0.70 148.03

137.79 55.12 0.40 160.61

199.80 139.86 0.70 158.84

226.44 135.86 0.60 148.03

137.79 124.01 0.90 160.61

199.80 99.90 0.50 158.84

226.44 203.80 0.90 148.03

137.79 110.23 0.80 160.61

PERIODO UNO PERIODO DOS

CANTIDAD DE TIEMPO VALOR TOTAL

59.94 269,009.36 4487.89 47.65

135.86 609,742.35 4487.89 88.82

82.68 371,037.00 4487.89 96.37

79.92 383,963.57 4804.25 63.54

113.22 543,937.50 4804.25 74.01

68.90 330,993.80 4804.25 80.31

99.90 511,559.98 5120.62 79.42

158.51 811,658.93 5120.62 103.62

UNIDADES A

PRODUCIR

TIEMPO POR

UNIDAD

UNIDADES A

PRODUCIR

TIEMPO PORUNIDAD

UNIDADES APRODUCIR


16/34

55.12 282,232.08 5120.62 64.24

139.86 627,688.51 4487.89 111.19

135.86 609,742.35 4487.89 88.82

124.01 556,555.49 4487.89 144.55

99.90 574,771.03 5753.35 79.42203.80 1,172,509.43 5753.35 133.23

110.23 634,212.33 5753.35 128.49

8,289,613.72


17/34

PERIODO TRES

TIEMPO TOTAL TIEMPO POR UNIDAD TIEMPO TOTAL47.65 0.30 214.09 64.23

88.82 0.60 109.41 65.65

96.37 0.60 88.08 52.85

63.54 0.40 214.09 85.63

74.01 0.50 109.41 54.71

80.31 0.50 88.08 44.04

79.42 0.50 214.09 107.04

103.62 0.70 109.41 76.59

64.24 0.40 88.08 35.23

111.19 0.70 214.09 149.86

88.82 0.60 109.41 65.65

144.55 0.90 88.08 79.27

79.42 0.50 214.09 107.04

133.23 0.90 109.41 98.47

128.49 0.80 88.08 70.46

PERIODO TRES

TIEMPO TOTAL TIEMPO POR UNIDAD TIEMPO TOTAL

213,854.12 4487.89 64.23 288,238.16

398,599.81 4487.89 65.65 294,617.25

432,482.46 4487.89 52.85 237,167.80

305,239.16 4804.25 85.63 411,409.30

355,581.97 4804.25 54.71 262,821.45

385,807.92 4804.25 44.04 211,572.09

406,674.37 5120.62 107.04 548,126.32

530,596.39 5120.62 76.59 392,179.94

UNIDADES A

PRODUCIR

UNIDADES APRODUCIR


18/34

328,971.03 5120.62 35.23 180,403.47

498,992.95 4487.89 149.86 672,555.72

398,599.81 4487.89 65.65 294,617.25

648,723.69 4487.89 79.27 355,751.70

456,925.19 5753.35 107.04 615,855.70766,491.02 5753.35 98.47 566,536.84

739,240.86 5753.35 70.46 405,390.15

6,866,780.75 5,737,243.14


19/34

PERIODO CUATRO

TIEMPO TOTAL0.30 109.87 32.96 204.78

0.60 161.72 97.03 387.36

0.60 128.62 77.17 309.06

0.40 109.87 43.95 273.04

0.50 161.72 80.86 322.80

0.50 128.62 64.31 257.55

0.50 109.87 54.94 341.30

0.70 161.72 113.20 451.92

0.40 128.62 51.45 206.04

0.70 109.87 76.91 477.82

0.60 161.72 97.03 387.36

0.90 128.62 115.76 463.59

0.50 109.87 54.94 341.30

0.90 161.72 145.55 581.04

0.80 128.62 102.90 412.08

PERIODO CUATRO

TIEMPO TOTAL

4487.89 32.96 147,927.95 919,029.60

4487.89 97.03 435,468.70 1,738,428.10

4487.89 77.17 346,339.25 1,387,026.51

4804.25 43.95 211,141.14 1,311,753.18

4804.25 80.86 388,471.88 1,550,812.80

4804.25 64.31 308,961.50 1,237,335.30

5120.62 54.94 281,306.27 1,747,666.94

5120.62 113.20 579,674.45 2,314,109.71

TIEMPO POR

UNIDAD

UNIDADES A

PRODUCIR

TIEMPO PORUNIDAD

UNIDADES APRODUCIR


20/34

5120.62 51.45 263,445.56 1,055,052.14

4487.89 76.91 345,165.22 2,144,402.41

4487.89 97.03 435,468.70 1,738,428.10

4487.89 115.76 519,508.88 2,080,539.77

5753.35 54.94 316,065.96 1,963,617.885753.35 145.55 837,388.38 3,342,925.68

5753.35 102.90 591,996.56 2,370,839.90

6,008,330.41 26,901,968.02


21/34

PRESUPUESTO DE MATERIALES A USAR

MATE

DEPARTAMENTO

PERIODO 1A 199.80 4.00B 226.44 7.00

C 137.79 2.00

PERIODO 2

A 158.84 4.00

B 148.03 7.00

C 160.61 2.00

PERIODO 3

A 214.09 4.00

B 109.41 7.00

C 88.08 2.00

PERIODO 4

A 109.87 4.00

B 161.72 7.00

C 128.62 2.00

UNIDADES

A

PRODUCIR

CANTIDADUNITARIA


22/34

RIAL 1 MATERIAL 2 MATERIAL 3 MATE

799.22 5.00 999.02 6.00 1198.82 3.001585.08 3.00 679.32 4.00 905.76 4.00

275.58 3.00 413.376 5.00 688.96 5.00

635.35 5.00 794.19 6.00 953.03 3.00

1036.20 3.00 444.084 4.00 592.11 4.00

321.22 3.00 481.833 5.00 803.06 5.00

856.34 5.00 1070.43 6.00 1284.52 3.00

765.88 3.00 328.236 4.00 437.65 4.00

176.15 3.00 264.231 5.00 440.39 5.00

439.49 5.00 549.36 6.00 659.23 3.00

1132.04 3.00 485.16 4.00 646.88 4.00

257.24 3.00 385.86 5.00 643.10 5.00

$ 8,279.80 $ 6,895.10 $ 9,253.50

CANTIDAD TOTAL

CANTIDADUNITARIA

CANTIDAD TOTAL

CANTIDADUNITARIA

CANTIDAD TOTAL

CANTIDADUNITARIA


23/34

RIAL 4

599.412 $ 3,596.47905.76 $ 4,075.92

688.96 $ 2,066.88

476.514 $ 2,859.08

592.112 $ 2,664.50

803.055 $ 2,409.17

642.258 $ 3,853.55

437.648 $ 1,969.42

440.385 $ 1,321.16

329.616 $ 1,977.70

646.88 $ 2,910.96

643.1 $ 1,929.30

$ 31,634.10

$ 7,205.70 $ 31,634.10

CANTIDAD TOTAL


24/34

PRESUPUESTO DE COSTOS DE MATERIALES

MATERIAL 1

DEPARTAMENTO CANTIDAD

1 10.70 799.22

2 11.98 635.353 13.42 856.34

4 15.03 439.49

1 10.70 1585.08

2 11.98 1036.20

3 13.42 765.88

4 15.03 1132.04

1 10.70 275.582 11.98 321.22

3 13.42 176.15

4 15.03 257.24

VALORUNITARIO

PRODUCTOA

PRODUCTOB

PRODUCTOC


25/34

MATERIAL 2

VALOR TOTAL CANTIDAD VALOR TOTAL

8,551.61 14.50 999.02 14,485.79 13.90

7,614.06 15.37 794.19 12,206.70 15.01 11,493.92 16.29 1070.43 17,439.66 16.21

6,606.70 17.27 549.36 9,487.30 17.51

16,960.36 14.50 679.32 9,850.14 13.90

12,417.77 15.37 444.084 6,825.57 15.01

10,279.76 16.29 328.236 5,347.69 16.21

17,017.65 17.27 485.16 8,378.58 17.51

2,948.75 14.50 413.376 5,993.95 13.90 3,849.52 15.37 481.833 7,405.77 15.01

2,364.35 16.29 264.231 4,304.90 16.21

3,867.02 17.27 385.86 6,663.70 17.51

$ 103,971.47 $ 108,389.76

VALORUNITARIO

VALORUNITARIO


26/34

MATERIAL 3 MATERIAL 4

CANTIDAD VALOR TOTAL CANTIDAD VALOR TOTAL

1198.82 16,663.65 16.50 599.412 9,890.30

953.03 14,306.86 17.99 476.514 8,570.101284.52 20,825.81 19.60 642.258 12,590.60

659.23 11,543.15 21.37 329.616 7,043.23

905.76 12,590.06 16.50 905.76 14,945.04

592.11 8,888.79 17.99 592.112 10,649.13

437.65 7,095.57 19.60 437.648 8,579.50

646.88 11,326.87 21.37 646.88 13,822.52

688.96 9,576.54 16.50 688.96 11,367.84803.06 12,055.46 17.99 803.055 14,442.94

440.39 7,139.94 19.60 440.385 8,633.15

643.10 11,260.68 21.37 643.1 13,741.75

$ 143,273.38 $ 134,276.11

VALORUNITARIO


27/34

$ 49,591.35

$ 42,697.72$ 62,349.98

$ 34,680.38

$ 54,345.60

$ 38,781.26

$ 31,302.51

$ 50,545.62

$ 29,887.08$ 37,753.70

$ 22,442.36

$ 35,533.14

$ 489,910.72

$ 489,910.72


28/34

PRESUPUESTO DE COMPRAS

1

INVENTARIO %INAL 249.10

& MATERIAL USADO 2,659.88

' TOTAL NECESIDAD 2,908.98! INVENATRIO INICIAL 23.60

' MATERIAL RE(UERIDO 2,885.38

& PRECIO UNITARIO 10.70

' COSTO DE MATERIAL AD(UIRIDO 30,873.53


29/34

MATERIAL 1 U MATERIAL 2 U

2 3 4 1 2 3

224.80 228.60 21.80 215.01 207.86 177.55

1,992.77 1,798.38 1,828.77 2,091.72 1,720.11 1,662.90

2,217.57 2,026.98 1,850.57 2,306.73 1,927.97 1,840.44249.10 224.80 228.60 28.98 215.01 207.86

1,968.47 1,802.18 1,621.97 2,277.75 1,712.96 1,632.58

11.98 13.42 15.03 14.50 15.37 16.29

23,590.16 24,189.01 24,382.67 33,027.37 26,328.13 26,598.36


30/34

MATERIAL 3 U

4 1 2 3 4

26.09 293.52 270.32 243.65 24.30

1,420.38 2,793.54 2,348.20 2,162.55 1,949.21

1,446.47 3,087.07 2,618.51 2,406.20 1,973.51177.55 35.20 293.52 270.32 243.65

1,268.92 3,051.87 2,324.99 2,135.88 1,729.86

17.27 13.90 15.01 16.21 17.51

21,913.93 42,420.97 34,902.74 34,628.97 30,289.85


31/34

MATERIAL 3 U

1 2 3 4

233.96 190.04 202.45 34.68

2,194.13 1,871.68 1,520.29 1,619.60

2,428.09 2,061.72 1,722.74 1,654.2842.00 233.96 190.04 202.45

2,386.09 1,827.76 1,532.70 1,451.83

16.50 17.99 19.60 21.37

39,370.52 32,872.21 30,046.60 31,022.60


32/34

PRESUPUESTOS DE COSTOS INDIRECTOS

DEPARTAMENTO CI% GENERALES

D1 &$,-'%,%%%D2 )-,#%,%%%D3 )#,('%,%%%D4 -,$&',%%%D5 #,(&,%%%TOTALES 74,407,000

A 15 )%,$'B 13 -,$#(C 16 -,&%

2,%-1.

DPT

D1 15

D2 13

D3 16

HORAS DE

REPARACION


33/34

DE %ABRICACION

DEPRESACION REPARACIONES

#,)#%,%%% 672,000 2,681,600 648

','%%,%%% 600,000 1,508,400 443

(,(%%,%%% 840,000 2,095,000 568

),'%,%%% 168,000 1,257,000 !

),)%%,%%% 120,000 838,000 !22,000,000 2,400,000 8,380,000 1,659

)' ECCIO6 A?O # = )%%%)$ ECCIO6 A?O # = )%%%

)# ECCIO6 A?O # = )%%%,,1%/3- TASA PREDETERMINADA POR "ORA

ALOR

43.23 648.40

34.07 442.95

35.48 567.69

IMPUESTOPREDIAL

SERVICIOSGENERALES

ASI!NACION DE

COSTO DE

REPARACION


34/34

33,364,248

26,298,843

27,385,568

11,290,000

8,850,000

107,188,659

TOTAL COSTO

INDIRECTO PORDEPARTAMENTO

talleer presupuesto completo estudiantes jueves

Documents