Question: 1. Using the six steps in decision making, model a problem that requires the use of decision making related to the application of the use

1. Using the six steps in decision making, model a problem that requires the use of decision making related to the application of the use of a sales forecast for a supermarket. 2. Make the forecast with the data in the Table presented below. Data is in thousands of dollars.

Meses 2014 2015 2016 2017
Julio 2165 2046.6 2075.3 2032.3
Agosto 2213.5 2109.2 2097.7 2107.4
Septiembre 2103.1 1956.7 2021 2012.8
Octubre 2133.6 2016.7 2082.8 2029.1
Noviembre 1966 1849.5 1906.9 1826
Diciembre 1937.5 1818.3 1950.3 1795
Enero 1856.8 1791.9 1817.8 1762.3
Febrero 1758.4 1629 1738.3 1629.4
Marzo 1864.3 1720.2 1993.4 1814.5
Abril 1889.7 1814.3 1895.8 1793.3
Mayo 2032.8 1897.4 2009.1 1890.7
Junio 2014.5 1961.1 1990.3 1938.3

The methods that will be used are the following:

Trend plot for all 4 years (scatter plot), weighted moving average (for each separate year) Exponential smoothing with fitting trend (year 2017 only, alpha and beta is 0.5) Trend regression with graph (year 2017 only) Multiplicative decomposition method (year 2017 only; 4 series)

Step Description Definition of the problem Maintain the level of sales and avoid losses after external events such as earthquakes, the Covid-19 pandemic, population decline in the area and inflation. Development of a Model Data collection Development of a solution Solution test Analysis of the results Implementation Note: Next to this table, attach the results of the Excel Qm or QM for Windows programs that served as a support tool in decision-making for modeling a real scenario.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!