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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started