Elep

Envelope-to: brodriguez@ifprc.com.pe
Delivery-date: Fri, 30 Jun 2023 08:29:30 -0400
Message-ID: <a8753c974dfcd6f7d47e367f4b8e4d6dae60@web41.arionsystem.com>
Reply-To: =?utf-8?Q?Promo_3x2_=C3=BAltimos_cupos?= <cativa_excel@arionsystem.com>
From: =?utf-8?Q?Promo_3x2_=C3=BAltimos_cupos?= <correo@web41.arionsystem.com>
To: brodriguez@ifprc.com.pe
Subject: Costos y Presupuestos en Excel.
Date: Fri, 30 Jun 2023 07:28:39 -0500
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0aa9e04b91200a2b08a2eaa3975291e032f1"

--0aa9e04b91200a2b08a2eaa3975291e032f1
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

TALLER - ONLINE=20
COSTOS, PUNTO
DE EQUILIBRIO Y PRESUPUESTOS EN EXCEL

V=C3=ADa Zoom en vivo. Incluye grabaciones, materiales y certificado.=C2=A0=
=20

MARTES 04 Y JUEVES 06 DE JULIO
Horario de 7:00 pm a 10:00 pm
(horario GMT-5: Colombia, Ecuador, Panam=C3=A1, Per=C3=BA)
Duraci=C3=B3n 6 horas.

Solicita Informaci=C3=B3n CLICK AQU=C3=8D=C2=A0

OBJETIVOS GENERALES
El objetivo del Seminario =E2=80=93 Taller es desarrollar la capacidad de=
 los participantes en el an=C3=A1lisis, evaluaci=C3=B3n y gesti=C3=B3n de=
 los costos para gestionar el presupuesto de su empresa.

DIRIGIDO
Profesionales, que deban tomar decisiones relacionadas con la planificaci=
=C3=B3n y control de ingresos y gastos.

CONTENIDO:=20

1. Gesti=C3=B3n de costos
1.1. Concepto de costos para gestores
1.2. Diferencia entre costo y gasto
1.3. Clasificaciones de costos
1.4. Asignaci=C3=B3n de costos indirectos
1.5. An=C3=A1lisis de punto de equilibrio
1.6. Apalancamiento operativo

2. Gesti=C3=B3n de presupuestos
2.1. Definici=C3=B3n de presupuestos
2.2. Caracter=C3=ADsticas
2.3. Tipos de presupuestos

3. Presupuesto de ventas
3.1. Uso de tendencias en Excel
3.2. Promedios m=C3=B3viles
3.3. Modelo de regresi=C3=B3n lineal simple

4. Presupuestos operativos
4.1. C=C3=A1lculo de inventarios
4.2. Presupuesto de mano de obra directa
4.3. Presupuesto de compra de materiales directos
4.4. Presupuesto de costos indirectos de fabricaci=C3=B3n
4.5. Presupuesto de costos de producci=C3=B3n
4.6. Presupuesto de costo de ventas
4.7. Presupuesto gastos operativos
4.8. Estado de ganancias y p=C3=A9rdidas
4.9. Ejemplo pr=C3=A1ctico

5. Estados financieros presupuestados
5.1. Conceptos contables
5.2. Presupuesto de efectivo
5.3. Estado de ganancias y p=C3=A9rdidas
5.4. Balance general

I N F O R M E S:

Solicita Informaci=C3=B3n CLICK AQU=C3=8D=C2=A0

O comun=C3=ADquese al:=C2=A0=C2=A0 + 5 1 9 6 0 4 0 8 7 1 7

E=C2=A0L=C2=A0C=C2=A0 -=C2=A0 E s c u e l a=C2=A0=C2=A0 L a t i n o a m e=
 r i c a n a=C2=A0=C2=A0 d e=C2=A0=C2=A0 C a p a c i t a c i o n

brodriguez@ifprc.com.pe |=C2=A0 30/06/2023 07:28:39
Salir Aqu=C3=AC

--0aa9e04b91200a2b08a2eaa3975291e032f1
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3Durn:schemas-microsoft-com:office:office><head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dutf-8">
</head>
<body bgColor=3D"#ffffff"><font size=3D2 face=3DArial>
<div align=3Dleft>
<table class=3DContenedor height=3D696 cellSpacing=3D5 cellPadding=3D0 wi=
dth=3D520 align=3Dcenter border=3D0>
<tbody>
<tr>
<td style=3D"BORDER-TOP: 0px; FONT-FAMILY: Montserrat,Arial,Helvetica,'sa=
ns-serif'; BORDER-RIGHT: 0px; BORDER-BOTTOM: 0px; PADDING-BOTTOM: 0px; PA=
DDING-TOP: 0px; PADDING-LEFT: 0px; BORDER-LEFT: 0px; MARGIN: 0px; PADDING=
-RIGHT: 0px; BACKGROUND-COLOR: #fff" width=3D575 align=3Dleft>
<div align=3Dcenter><font size=3D2><font size=3D6><font color=3D"#0000ff"=
><b><span style=3D'FONT-SIZE: 26pt; FONT-FAMILY: "Arial",sans-serif; COLO=
R: black; mso-fareast-font-family: "Times New Roman"; mso-color-alt: wind=
owtext; mso-fareast-language: ES-PE'><font color=3D"#c0c0c0"><font size=3D=
5>TALLER - ONLINE</font> <br></font><font color=3D"#000000">COSTOS, PUNTO=
<br><font color=3D"#008040">DE EQUILIBRIO Y</font> </font><em><font color=
=3D"#00b000">PRESUPUESTOS EN <u>EXCEL</u></font></em></span></b></font></=
font></div>
<div class=3DMsoNormal style=3D"BACKGROUND: white; TEXT-ALIGN: center; MA=
RGIN: 0cm; LINE-HEIGHT: normal; mso-outline-level: 3" align=3Dcenter><i><=
span style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; COLOR: bl=
ack; mso-fareast-font-family: "Times New Roman"; mso-color-alt: windowtex=
t; mso-fareast-language: ES-PE'>V=C3=ADa Zoom en vivo. Incluye grabacione=
s, materiales y certificado.</span></i><i><span style=3D'FONT-SIZE: 15pt;=
 FONT-FAMILY: "Arial",sans-serif; mso-fareast-font-family: "Times New Rom=
an"; mso-fareast-language: ES-PE'><o:p>&nbsp;</o:p> </span></i></div>
<div class=3DMsoNormal style=3D"TEXT-ALIGN: center; MARGIN: 0cm 0cm 8pt; =
tab-stops: 150.75pt" align=3Dcenter><span style=3D'FONT-SIZE: 14pt; FONT-=
FAMILY: "Arial",sans-serif; LINE-HEIGHT: 107%; mso-bidi-font-style: itali=
c; mso-bidi-font-size: 9.0pt'><font color=3D"#00b000">MARTES 04 Y JUEVES =
06 DE JULIO<br></font></span><span style=3D'FONT-SIZE: 10pt; FONT-FAMILY:=
 "Arial",sans-serif; LINE-HEIGHT: 107%; mso-bidi-font-style: italic; mso-=
bidi-font-size: 6.0pt'>Horario de 7:00 pm a 10:00 pm<br>(horario GMT-5: C=
olombia, Ecuador, Panam=C3=A1, Per=C3=BA)<br>Duraci=C3=B3n 6 horas</span>=
<span style=3D'FONT-FAMILY: "Arial",sans-serif; LINE-HEIGHT: 107%; mso-bi=
di-font-style: italic; mso-bidi-font-size: 7.0pt'>.</span></div>
<table class=3DContenedor height=3D23 cellSpacing=3D0 cellPadding=3D0 wid=
th=3D407 align=3Dcenter border=3D0>
<tbody>
<tr>
<td style=3D"BORDER-TOP: 0px; FONT-FAMILY: Montserrat,Arial,Helvetica,'sa=
ns-serif'; BORDER-RIGHT: 0px; BORDER-BOTTOM: 0px; PADDING-BOTTOM: 0px; PA=
DDING-TOP: 0px; PADDING-LEFT: 0px; BORDER-LEFT: 0px; MARGIN: 0px; PADDING=
-RIGHT: 0px; BACKGROUND-COLOR: #fff" bgColor=3D"#396af0" align=3Dcenter>
<div><a style=3D"FONT-SIZE: 20px; TEXT-DECORATION: none; HEIGHT: 20px; FO=
NT-FAMILY: Arial; WIDTH: 396px; MIN-WIDTH: 100px; COLOR: #ffffff; PADDING=
-BOTTOM: 10px; PADDING-TOP: 10px; PADDING-LEFT: 20px; DISPLAY: inline-blo=
ck; LINE-HEIGHT: 20px; PADDING-RIGHT: 20px; BACKGROUND-COLOR: #00b000; bo=
rder-radius: 35px" href=3D"https://wa.link/e9wfoj" target=3D_blank><font =
color=3D"#fff">&nbsp;</font><font color=3D"#ffffff"><strong><em>Solicita =
Informaci=C3=B3n <font color=3D"#ffff00"><u>CLICK</u> <u>AQU=C3=8D</u></f=
ont></em></strong></font><font color=3D"#ffff00">&nbsp;</font></a></div><=
/td></tr></tbody></table><span style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Ar=
ial",sans-serif; COLOR: black; mso-fareast-font-family: "Times New Roman"=
; mso-color-alt: windowtext; mso-fareast-language: ES-PE'><span style=3D'=
FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: black; mso-farea=
st-font-family: "Times New Roman"; mso-color-alt: windowtext; mso-fareast=
-language: ES-PE'>
<div class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 6pt; LINE-HEIGHT: normal;=
 mso-outline-level: 3" align=3Djustify><strong><br>OBJETIVOS GENERALES<br=
></strong><font color=3D"#404040">El objetivo del Seminario =E2=80=93 Tal=
ler es desarrollar la capacidad de los participantes en el an=C3=A1lisis,=
 evaluaci=C3=B3n y gesti=C3=B3n de los costos para gestionar el presupues=
to de su empresa.</font></div>
<div align=3Djustify><span style=3D'FONT-SIZE: 10pt; FONT-FAMILY: "Arial"=
,sans-serif; COLOR: black; mso-fareast-font-family: "Times New Roman"; ms=
o-color-alt: windowtext; mso-fareast-language: ES-PE'><strong>DIRIGIDO</s=
trong><br><font color=3D"#404040">Profesionales, que deban tomar decision=
es relacionadas con la planificaci=C3=B3n y control de ingresos y gastos.=
</font></span></div>
<div>&nbsp;</div>
<div class=3DMsoListParagraphCxSpFirst style=3D"BACKGROUND: white; MARGIN=
: 0cm 0cm 0cm 21.3pt; LINE-HEIGHT: normal; TEXT-INDENT: -18pt; mso-outlin=
e-level: 3; mso-add-space: auto; mso-list: l1 level1 lfo3" align=3Djustif=
y><span style=3D'FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR:=
 black; mso-fareast-font-family: "Times New Roman"; mso-color-alt: window=
text; mso-fareast-language: ES-PE'><strong>CONTENIDO:</strong> </span></d=
iv>
<div class=3DMsoListParagraphCxSpFirst style=3D"BACKGROUND: white; MARGIN=
: 0cm 0cm 0cm 21.3pt; LINE-HEIGHT: normal; TEXT-INDENT: -18pt; mso-outlin=
e-level: 3; mso-add-space: auto; mso-list: l1 level1 lfo3" align=3Djustif=
y><span style=3D'FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR:=
 black; mso-fareast-font-family: "Times New Roman"; mso-color-alt: window=
text; mso-fareast-language: ES-PE'><strong>1. Gesti=C3=B3n de costos</str=
ong><br><font color=3D"#404040">1.1. Concepto de costos para gestores<br>=
1.2. Diferencia entre costo y gasto<br>1.3. Clasificaciones de costos<br>=
1.4. Asignaci=C3=B3n de costos indirectos<br>1.5. An=C3=A1lisis de punto =
de equilibrio<br>1.6. Apalancamiento operativo</font></span></div>
<div>&nbsp;</div>
<div class=3DMsoListParagraphCxSpFirst style=3D"BACKGROUND: white; MARGIN=
: 0cm 0cm 0cm 21.3pt; LINE-HEIGHT: normal; TEXT-INDENT: -18pt; mso-outlin=
e-level: 3; mso-add-space: auto; mso-list: l1 level1 lfo3" align=3Djustif=
y><span style=3D'FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR:=
 black; mso-fareast-font-family: "Times New Roman"; mso-color-alt: window=
text; mso-fareast-language: ES-PE'><strong>2. Gesti=C3=B3n de presupuesto=
s</strong><br><font color=3D"#404040">2.1. Definici=C3=B3n de presupuesto=
s<br>2.2. Caracter=C3=ADsticas<br>2.3. Tipos de presupuestos</font></span=
></div>
<div>&nbsp;</div>
<div class=3DMsoListParagraphCxSpFirst style=3D"BACKGROUND: white; MARGIN=
: 0cm 0cm 0cm 21.3pt; LINE-HEIGHT: normal; TEXT-INDENT: -18pt; mso-outlin=
e-level: 3; mso-add-space: auto; mso-list: l1 level1 lfo3" align=3Djustif=
y><span style=3D'FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR:=
 black; mso-fareast-font-family: "Times New Roman"; mso-color-alt: window=
text; mso-fareast-language: ES-PE'><strong>3. Presupuesto de ventas</stro=
ng><br><font color=3D"#404040">3.1. Uso de tendencias en Excel<br>3.2. Pr=
omedios m=C3=B3viles<br>3.3. Modelo de regresi=C3=B3n lineal simple</font=
></span></div>
<div>&nbsp;</div>
<div class=3DMsoListParagraphCxSpFirst style=3D"BACKGROUND: white; MARGIN=
: 0cm 0cm 0cm 21.3pt; LINE-HEIGHT: normal; TEXT-INDENT: -18pt; mso-outlin=
e-level: 3; mso-add-space: auto; mso-list: l1 level1 lfo3" align=3Djustif=
y><span style=3D'FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR:=
 black; mso-fareast-font-family: "Times New Roman"; mso-color-alt: window=
text; mso-fareast-language: ES-PE'><strong>4. Presupuestos operativos</st=
rong><br><font color=3D"#404040">4.1. C=C3=A1lculo de inventarios<br>4.2.=
 Presupuesto de mano de obra directa<br>4.3. Presupuesto de compra de mat=
eriales directos<br>4.4. Presupuesto de costos indirectos de fabricaci=C3=
=B3n<br>4.5. Presupuesto de costos de producci=C3=B3n<br>4.6. Presupuesto=
 de costo de ventas<br>4.7. Presupuesto gastos operativos<br>4.8. Estado =
de ganancias y p=C3=A9rdidas<br>4.9. Ejemplo pr=C3=A1ctico</font></span><=
/div>
<div>&nbsp;</div>
<div class=3DMsoListParagraphCxSpFirst style=3D"BACKGROUND: white; MARGIN=
: 0cm 0cm 0cm 21.3pt; LINE-HEIGHT: normal; TEXT-INDENT: -18pt; mso-outlin=
e-level: 3; mso-add-space: auto; mso-list: l1 level1 lfo3" align=3Djustif=
y><span style=3D'FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR:=
 black; mso-fareast-font-family: "Times New Roman"; mso-color-alt: window=
text; mso-fareast-language: ES-PE'><strong>5. Estados financieros presupu=
estados</strong><br><font color=3D"#404040">5.1. Conceptos contables<br>5=
.2. Presupuesto de efectivo<br>5.3. Estado de ganancias y p=C3=A9rdidas<b=
r>5.4. Balance general<br></font></span></div>
<div class=3DMsoNormal style=3D"BACKGROUND: white; MARGIN: 0cm; LINE-HEIG=
HT: normal; mso-outline-level: 3" align=3Djustify><span style=3D'FONT-SIZ=
E: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: black; mso-fareast-font-=
family: "Times New Roman"; mso-color-alt: windowtext; mso-fareast-languag=
e: ES-PE'></span><span style=3D'FONT-SIZE: 10pt; FONT-FAMILY: "Arial",san=
s-serif; mso-fareast-font-family: "Times New Roman"; mso-fareast-language=
: ES-PE'><o:p></o:p></span></div>
<div class=3DMsoNormal style=3D"BACKGROUND: white; MARGIN: 0cm; LINE-HEIG=
HT: normal; mso-outline-level: 3"><span style=3D'FONT-SIZE: 10pt; FONT-FA=
MILY: "Arial",sans-serif; mso-fareast-font-family: "Times New Roman"; mso=
-fareast-language: ES-PE'><o:p>&nbsp;</o:p></span></div>
<div class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 8pt"><span style=3D'FONT-=
FAMILY: "Arial",sans-serif'><font size=3D3>I N F O R M E S:</font></span>=
</div>
<div align=3Djustify>
<table class=3DContenedor height=3D23 cellSpacing=3D0 cellPadding=3D0 wid=
th=3D407 align=3Dcenter border=3D0>
<tbody>
<tr>
<td style=3D"BORDER-TOP: 0px; FONT-FAMILY: Montserrat,Arial,Helvetica,'sa=
ns-serif'; BORDER-RIGHT: 0px; BORDER-BOTTOM: 0px; PADDING-BOTTOM: 0px; PA=
DDING-TOP: 0px; PADDING-LEFT: 0px; BORDER-LEFT: 0px; MARGIN: 0px; PADDING=
-RIGHT: 0px; BACKGROUND-COLOR: #fff" bgColor=3D"#396af0" align=3Dcenter>
<div><a style=3D"FONT-SIZE: 20px; TEXT-DECORATION: none; HEIGHT: 20px; FO=
NT-FAMILY: Arial; WIDTH: 396px; MIN-WIDTH: 100px; COLOR: #ffffff; PADDING=
-BOTTOM: 10px; PADDING-TOP: 10px; PADDING-LEFT: 20px; DISPLAY: inline-blo=
ck; LINE-HEIGHT: 20px; PADDING-RIGHT: 20px; BACKGROUND-COLOR: #00b000; bo=
rder-radius: 35px" href=3D"https://wa.link/85wiif" target=3D_blank><font =
color=3D"#fff">&nbsp;</font><font color=3D"#ffffff"><strong><em>Solicita =
Informaci=C3=B3n <font color=3D"#ffff00"><u>CLICK</u> <u>AQU=C3=8D</u></f=
ont></em></strong></font><font color=3D"#ffff00">&nbsp;</font></a></div><=
/td></tr></tbody></table><br><span style=3D'FONT-FAMILY: "Arial",sans-ser=
if'><font size=3D3>O comun=C3=ADquese al:<span style=3D"mso-spacerun: yes=
">&nbsp;&nbsp; </span>+ 5 1 9 6 0 4 0 8 7 1 7<o:p></o:p></font></span></d=
iv>
<div align=3Dcenter><strong><font size=3D5></font></strong><br><font colo=
r=3D"#4b4b4b"><span style=3D'FONT-FAMILY: "Arial",sans-serif'><font size=3D=
3><font color=3D"#000000">E<span style=3D"mso-spacerun: yes">&nbsp;</span=
>L<span style=3D"mso-spacerun: yes">&nbsp;</span>C<span style=3D"mso-spac=
erun: yes">&nbsp; </span>-<span style=3D"mso-spacerun: yes">&nbsp; </span=
>E s c u e l a<span style=3D"mso-spacerun: yes">&nbsp;&nbsp; </span>L a t=
 i n o a m e r i c a n a<span style=3D"mso-spacerun: yes">&nbsp;&nbsp; </=
span>d e<span style=3D"mso-spacerun: yes">&nbsp;&nbsp; </span>C a p a c i=
 t a c i o n</font><o:p></o:p></font></span></font></div></span></span></=
font></td></tr>
<tr></tr></tbody></table></div>
<div align=3Dleft>&nbsp;</div>
<div align=3Dleft>&nbsp;</div>
<div align=3Dleft>&nbsp;</div>
<div align=3Dleft>&nbsp;</div>
<div align=3Dcenter><font color=3D"#808080" size=3D1 face=3DArial>brodrig=
uez@ifprc.com.pe |&nbsp; 30/06/2023 07:28:39<br>&nbsp;</font><a href=3D"m=
ailto:salir@arionsystem.com?subject=3DDesuscribir%20correo%20brodriguez@i=
fprc.com.pe"><font color=3D"#808080" size=3D1 face=3DArial><em>Salir Aqu=C3=
=AC</em></font></a></div></font></body></html>

--0aa9e04b91200a2b08a2eaa3975291e032f1--