Baixe o app para aproveitar ainda mais
Prévia do material em texto
Hoja1 PRONÓSTICOS DE VENTAS 1. MEDIANTE TASA DE CRECIMIENTO "g" 2017 2018 2019 2020 2021 2022 VENTAS $ 12,383,903.00 $ 12,496,554.00 $ 10,413,352.00 $ 11,556,153.00 $ 12,877,360.000 $ 14,320,095.16 0.91% -16.67% 10.97% 11.43% 11.20% 1.1. MÉTODO # 1 $ 1,142,801.00 $ 1,321,207.00 $ 1,442,735.164 TASA DE VARIACIÓN PROMEDIO PORCENTUAL MEDIA ARITMÉTICA 11.20% MEDIA GEOMÉTRICA 1.2. MÉTODO # 2 INCREMENTO PROMEDIO PORCENTUAL ANUAL 11.43% 2017 2018 2019 2020 2021 2022 VENTAS $ 12,383,903.00 $ 12,496,554.00 $ 10,413,352.00 $ 11,556,153.00 $ 12,877,360.000 $ 14,320,095.16 PRECIO 6.89 7 7 UNIDADES 1,677,236 1,839,623 2,045,728 PRONÓSTICOS DE VENTAS BASADOS EN VARIABLES INFLUYENTES PARA SU DETERMINACIÓN 2017 2018 2019 2020 2021 2022 y = 7,6718x + 1E+07 VENTAS $ 12,383,903.00 $ 12,496,554.00 $ 10,413,352.00 $ 11,556,153.00 $ 12,877,360.000 $ 13,068,720.00 Y=7,6718X+10000000 PUBLICIDAD $ 230,000.00 $ 235,000.00 $ 185,000.00 $ 320,000.00 $ 360,000.00 $ 400,000.00 F(PUBLICIDAD) = Y PUBLICIDAD VENTAS $ 230,000.00 $ 12,383,903.00 $ 235,000.00 $ 12,496,554.00 $ 185,000.00 $ 10,413,352.00 $ 10,000,000.00 $ 320,000.00 $ 11,556,153.00 $ 360,000.00 $ 12,877,360.00 AÑO PUBLICIDAD VENTAS 2018 $ 1,400.00 $ 350,000.00 Y=168,05X+147301 2019 $ 1,800.00 $ 420,000.00 2020 $ 2,450.00 $ 650,000.00 2021 $ 4,322.00 $ 845,000.00 2022 $ 7,600.00 $ 1,424,481.00 230000 235000 185000 320000 360000 12383903 12496554 10413352 11556153 12877360 1400 1800 2450 4322 350000 420000 650000 845000 Hoja2 2010 2011 2012 2013 2014 2015 2016 $ 230,000.00 $ 340,000.00 $ 450,000.00 $ 621,300.00 $ 712,300.00 $ 893,200.00 $ 1,232,000.00 PUBLICIDAD VENTAS 2010 $ 4,500.00 $ 230,000.00 2011 $ 5,400.00 $ 340,000.00 2012 $ 5,500.00 $ 450,000.00 2013 $ 7,500.00 $ 621,300.00 2014 $ 9,000.00 $ 712,300.00 2015 $ 9,400.00 $ 893,200.00 2016 $ 12,000.00 $ 1,232,000.00
Compartilhar