Upload
ivan-y-gomez-villalba
View
4
Download
1
Embed Size (px)
DESCRIPTION
Analisis de como realizar un pronostico movil simple en la materia de cadena de suministros
Citation preview
PROBLEMA 1IVAN YSEL GOMEZ VILLALBANo. Cta. 160024699
SOLUCION DEL PROBLEMA 1
PeriodoVenta RealPronostico Error (Ei)Error Abs |Ei|Error % (Ep)Error Cuad Med(Ei)MADEMCPEMAMES(i)(Xi)(Fi)(Xi - Fi)|Xi - Fi|(|Xi - Fi|/Xi)*100(Xi - Fi)|Xi - Fi|/n(Ei / n)(Ep / n)Enero119502600-65065033.33422500.00650.00422500.0033.33Febrero224303240-81081033.33656100.00730.00328050.0033.33Marzo330304040-1010101033.331020100.00823.33699566.6733.33Abril440005333-1333133333.331777777.78950.83969119.4433.33Mayo542325643-1411141133.331989980.441042.801173291.6433.33Junio640825443-1361136133.331851413.781095.781286312.0033.33Julio742935724-1431143133.332047761.001143.671395090.4333.33Agosto838905187-1297129733.331681344.441162.791430872.1833.33Septiembre936834911-1228122833.331507165.441170.001439349.2133.33Octubre1020932791-69869833.33486738.781122.771344088.1733.33Noviembre1115322043-51151133.33260780.441067.121245605.6533.33Diciembre1219312575-64464433.33414306.781031.831176330.7433.33
RESULTADOSMAD = 1031.83EMC = 1176330.74PEMA = 33.33La grafica nos muestra un patrn estacional en el pronostico,ya que se repite as mismo periodo tras periodo.
PARA MANTENER VENTAS 10% ARRIBA DEL ERROR ABSOLUTO
PeriodoVenta RealPronostico Error (Ei)Error Abs |Ei|Error % (Ep)Error Cuad Med(Ei)MADEMCPEMAMES(i)(Xi)(Fi)(Xi - Fi)|Xi - Fi|(|Xi - Fi|/Xi)*100(Xi - Fi)|Xi - Fi|/n(Ei / n)(Ep / n)Enero12889260028928910.0083521.00289.0083521.0010.00Febrero23600324036036010.00129600.00324.5064800.0010.00Marzo34490404045045010.02202500.00366.33138540.3310.01Abril4592553335925929.99350464.00422.75191521.2510.00Mayo56270564362762710.00393129.00463.60231842.8010.00Junio6604554436026029.96362404.00486.67253603.0010.00Julio76360572463663610.00404496.00508.00275159.1410.00Agosto85765518757857810.03334084.00516.75282524.7510.00Septiembre9545549115445449.97295936.00519.78284014.8910.00Octubre103102279131131110.0396721.00498.90265285.5010.00Noviembre112270204322722710.0051529.00474.18245853.0910.00Diciembre12286025752852859.9781225.00458.42232134.0810.00
PROBLEMA 2IVAN YSEL GOMEZ VILLALBANo. Cta. 160024699
SOLUCION DEL PROBLEMA 2
PeriodoVenta RealPronostico Error (Ei)Error Abs |Ei|Error % (Ep)Error Cuad Med(Ei)MADEMCPEMAMES(i)(Xi)(Fi)(Xi - Fi)|Xi - Fi|(|Xi - Fi|/Xi)*100(Xi - Fi)|Xi - Fi|/n(Ei / n)(Ep / n)AO 12678AO 22731.56267854541.962868.6726.781434.340.98AO 32785.12273254541.922868.6735.711912.451.29AO 42892.2427851071073.7011474.6953.564303.011.90AO 53106.4828922142146.9045898.7885.7012622.162.90AO 63534.96310642842812.12183595.11142.8341117.654.43AO 74391.92353585785719.51734380.44244.85140155.206.59
RESULTADOSMAD = 244.85EMC = 140155.20PEMA = 6.59Esta grafica tiene un patron de tendenciaya que representa el crecimiento a largo plazo.