Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

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

blur-text-image

Get Instant Access with AI-Powered 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

Entrepreneurship

Authors: Andrew Zacharakis, William D Bygrave

5th Edition

1119563097, 9781119563099

Students also viewed these Mathematics questions

Question

Discuss the scope of Human Resource Management

Answered: 1 week ago

Question

Discuss the different types of leadership

Answered: 1 week ago

Question

Write a note on Organisation manuals

Answered: 1 week ago

Question

Define Scientific Management

Answered: 1 week ago

Question

Explain budgetary Control

Answered: 1 week ago