Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need to know how I can complete the MAF in the table #2, The Moving Average Forecast= of demandsprevious n periods, The WMA 2013

I need to know how I can complete the MAF in the table #2, The Moving Average Forecast= of demandsprevious n periods, The WMA 2013 in the table 3, and table 4. The work is completed in the button, but they have digits like 3543.5 I attached for reference;

The course instruction are this;

  • Using the seven steps of the quantitative analysis approach, model the need for a projection of supermarket sales. You choose the name and location.
  • Also make the projections with the following in the table. Data is in millions of dollars. The student will assume that this data comes from the company. Carry out at least three projection methods discussed in the textbook and compare your results.
  • Table: alpha and beta = .5

Table #1

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Mes 2009 2010 2011 2012 Julio 2165 2046 2075 2032 Agosto 2213 2109 2097 2107 Septiembre 2103 1956 2021 2012 Octubre 2133 2016 2082 2029 Noviembre 1966 1849 1906 1826 Diciembre 1937 1818 1950 1795 Enero 1856 1791 1817 1762 Febrero 1758 1629 1738 1629 Marzo 1864 1720 1993 1814 Abril 1889 1814 1895 1793 Mayo 2032 1897 2009 1890 Junio 2014 1961 1990 1938\fMoving Average Forecast (MAF) Mes 2009 2010 2011 2012 WMA 2013 Julio 2165 2046 2075 2032 Agosto 2213 2109 2097 2107 Septiembre 2103 1956 2021 2012 Octubre 2133 2016 2082 2029 Noviembre 1966 1849 1906 1826 Diciembre 1937 1818 1950 1795 Enero 1856 1791 1817 1762 Febrero 1758 1629 1738 1629 Marzo 1864 1720 1993 1814 Abril 1889 1814 1895 1793 Mayo 2032 1897 2009 1890 Junio 2014 1961 1990 1938Month E Anos MAF Absolut e WMA Absolut e Error Error Julio Agosto Septiembre Octubre Noviembre Diciembre Enero Febrero Marzo Abril Mayo Junio MAD= MAD=Moving Average Forecast= _of demandsEprevious n periods Weighted Moving Average (WMA) Julio: Moving Average Forecast= 2165+2046.6+2075.3+2032.3 =2079.8 Meses 2009 2010 2011 2012 WMA 2013 Agosto: Moving Average Forecast= 2213.5+2109.2+2097.7+2107.4 =2131.95 Juli 2165 2046.6 2075.3 2032.3 2061.33 Agosto 2213.5 2109.2 2097.7 2107.4 2115.4 Septiembre 2103.1 1956.7 2021 2012.8 2013.07 Septiembre: Moving Average Forecast= 2103.1+1956.7+2021+2012.8 =2023.4 Octubre 2133.6 2016.7 2082.8 2029. 2053.18 Noviembre 1966 1849.5 1906.9 1826 1868.97 Diciembre 1937.5 1818.3 1950.3 1795 1860.5 Octubre: Moving Average Forecast= 2133.6+2016.7+2082.8+2029.1 =2065.55 Enero 1856.8 1791.9 1817. 1762.3 1794.32 Febrero 1758.4 629 1738.3 1629.4 1674.89 Marzo 1864.3 1720.2 1993.4 1814.5 1854.29 Noviembre: Moving Average Forecast= 1966+1849.5+1906.9+1826 =1887.1 Abril 1889. 1814.3 1895.8 1793.3 1837.89 May 2032.8 1897.4 2009.1 1890.7 1941.77 Junio 2014.5 1961.1 1990.3 1938.3 1966.08 Diciembre: Moving Average Forecast= 1937.5+1818.3+1950.3+1795 =1875.275 Enero: Moving Average Forecast= 1856.8+1791.9+1817.8+1762.3 =1807.2 Febrero: Moving Average Forecast= 1758.4+1629+1738.3+1629.4 =1688.775 Mes Z Anos MAF Absolut WMA Absolut e Error e Error Marzo: Moving Average Forecast= 1864.3+1720.2+1993.4+1814.5 =1848.1 Julio 8319.2 2079.8 6239.4 2061.33 6257.87 Agosto 3527.8 2131.95 6395.85 2115.46 6412.34 Septiembre 8093.6 2023.4 6070.2 2013.07 6080.53 Abril: Moving Average Forecast= 1889.7+1814.6+1895.8+1793.3 =1848.275 Octubre 8262.2 2065.55 6196.65 2053.18 6209.02 Noviembre 7548.4 1887.1 5661.3 1868.97 5679.43 4 Diciembre 7501.1 1875.275 5625.825 1860.5 5640.6 Mayo: Moving Average Forecast= 2032.8+1897.4+2009.1+1890.7 =1957.5 Enero 7228.8 1807.2 5421.6 794.32 5434.48 Febrero 6755.1 1688.775 5066.325 674.89 5080.21 Marzo 7392.4 1848.1 5544.3 1854.29 6538.11 Junio: Moving Average Forecast= 2014.5+1961.1+1990.3+1938.3 =1976.05 Abril 7393.1 1848.275 5544.825 1837.89 5555.21 Mayo 830 1957. 5872.5 941.77 5888.23 Junio 7904.2 1976.05 5928.15 966.08 5938.12 MAD= 69566.93 MAD= =5797.244 69714.15=5809.513

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Variational Inequalities And Frictional Contact Problems

Authors: Anca Capatina

1st Edition

3319101633, 9783319101637

More Books

Students also viewed these Mathematics questions

Question

2. How do I perform this role?

Answered: 1 week ago