MS Excel as system of support of decision-making

D. А. Vlasov, A. V. Sinchukov

Abstract


Possibilities of MS Excel in realization of various economic-mathematical methods united by the general problem of definition of an optimal solution are shown. First, Pareto's great number and optimization according to Pareto in the conditions of existence of two criteria of decision-making (the expected income and the expected risk; use of the built-in functions and visualization tools of "Chart"). Secondly, model in the form of the matrix antagonistic game having the decision in clean strategy and also the possible mixed expansion (use "Search of the decision"). Thirdly, model in the form of the statistical game meaning use of the integrated Hodge-Lehman's criterion (use of the built-in functions). It is shown that use of opportunities of MS of Excel allows it is multidimensional to consider the modelled economic situation. In particular, in the course of making decision on the choice of optimum production strategy of small enterprise the economic-mathematical methods supplementing each other were used. Considering applied orientation of mathematical training of future bachelor of economy in REU of G.V. Plekhanov the special attention in practice of teaching to mathematical disciplines is given to practical questions of support of decision-making. In particular, in the conditions of informatization of all types of activity, efforts are aimed at finding the optimum information technologies providing full support of all stages of decision-making. Within this article experience of use of MS of Excel as the systems of support of decision-making is presented, at the same time in didactic aspect we came to need to state receptions, methods and models of the theory of decision-making against the background of key problems of subject domain "Economy", but not in abstract to a form. Realization of applied orientation of training in mathematics is connected, on the one hand, with the integrative nature of tasks. On the other hand, the integrative nature of the information systems allowing to understand more deeply the problems arising in the social and economic environment and also to receive more evident and extremely concrete interpretations of results

Full Text:

PDF (Russian)

References


KHalin V. G., CHernova G. V. Sistemy podderzhki prinyatiya reshenij. – M.: Izdatel'stvo YUrajt, 2016. – 494 s.

Tikhomirov N. P., Tikhomirova T. M. Risk analiz v ehkonomike. Monografiya. – M.: EHkonomika, 2010. – 317 s.

Аslanov R .M., Ignatova O. G. EHlektronnoe obuchenie vchera, segodnya, zavtra. problemy i perspektivy // Continuum. Matematika. Informatika. Obrazovanie. – 2018. – № 1 (9). – S. 28-35.

Vlasov D. А. K voprosu ob informatizatsii uchebnogo protsessa po distsipline «Teoriya prinyatiya reshenij» // Continuum. Matematika. Informatika. Obrazovanie. – 2018. – № 2 (10). – S. 115-121.

Mukhanov S. А. Primenenie informatsionnykh tekhnologij pri prepodavanii matematiki studentam gumanitarnykh spetsial'nostej // Pedagogicheskaya informatika. – 2006. – № 1. – S. 60-62.

Vlasov D. А., Monakhov N. V., Monakhov V. M. Matematicheskie modeli i metody vnutrimodel'nykh issledovanij. M.: Аl'fa, 2007. – 365 s.

Sinchukov А. V. Osobennosti formirovaniya veroyatnostnykh predstavlenij u budushhikh bakalavrov ehkonomiki // Vestnik po pedagogike i psikhologii YUzhnoj Sibiri. – 2017. – № 2. – S. 47-58.

Sinchukov А. V. Problema kachestva prinimaemykh reshenij (kontekst professional'noj podgotovki budushhikh bakalavrov ehkonomiki) // Gumanitarnoe prostranstvo. – 2018. – T. 7. – № 1. – S. 167-171.

Mukhanov S. А., Nizhnikov А. I. Proektirovanie uchebnogo kursa // Pedagogicheskaya informatika. – 2014. – № 4. – S. 39-46.

Zi-Xin ZhangLiang WangYing-Ming Wang An Emergency Decision Making Method Based on Prospect Theory for Different Emergency Situations // International Journal of Disaster Risk Science, September 2018, Volume 9, Issue 3, pp 407–420

Liu Zhiyuan, Liu Qing Can group decision-making mitigate propensity of escalating commitment? Frontiers of Business Research in ChinaSelected Publications from Chinese Universities, 2007, (4): 13–20 https://doi.org/10.1007/s11782-008-0003-x

Pandian Pitchipoo, Ponnusamy Venkumar Modeling and development of a decision support system for supplier selection in the process industry. Journal of Industrial Engineering International December 2013, 9:23 doi: 10.1186/2251-712X-9-23

Razmi J, Rafiei H, Hashemi M: Designing a decision support system to evaluate and select suppliers using fuzzy analytic network process. Comput Ind Engg 2009,57(4):1282–1290. 10.1016/j.cie.2009.06.008

Lace M. Padilla, Sarah H. Creem-Regehr Decision making with visualizations: a cognitive framework across disciplines. Cognitive Research: Principles and Implications 2018 https://doi.org/10.1186/s41235-018-0120-9

Thierry Madiès, Grégoire Rota-Grasiozi The economics of secession: a review of legal, theoretical, and empirical aspects. Swiss Journal of Economics and Statistics 2018 154:19 https://doi.org/10.1186/s41937-017-0015-6

Hilton, Denis J. 2010. The psychology of financial decision-making: Applications to trading, dealing, and investment analysis. Journal of Psychology and Financial Markets 2 (1): 37–53. https://doi.org/10.1207/S15327760JPFM0201_4.

Misuraca, Raffaella, and Ursina Teuscher. 2013. Time flies when you maximize-maximizers and satisficers perceive time differently when making decisions. Acta Psychologica 143 (2): 176–180. https://doi.org/10.1016/j.actpsy.2013.03.004.

Karasev P. А., SHklyaev А. E. Razvitie chelovecheskogo kapitala v usloviyakh chetvertoj promyshlennoj revolyutsii // Drukerovskij vestnik. 2018. № 5 (25). S. 48-61.

Karasev P. А., CHajkovskaya L. А. Sovershenstvovanie programm vysshego obrazovaniya v kontekste sovremennykh trebovanij rynkov obrazovatel'nykh uslug i professional'nogo soobshhestva // EHkonomika i upravlenie: problemy, resheniya. 2017. T. 3. № 2. S. 3-9.

Kulapov M. N., Varfolomeev V. P., Karasev P. А. Tekhnologicheskie aspekty teorii upravleniya innovatsionnymi protsessami: sistemnyj analiz i podkhody k modelirovaniyu // Drukerovskij vestnik. 2018. № 3 (23). S. 82-100.

Sukhorukova I. V., Savina O. I., Lavrinenko T. А., Аrtyushina T. G. Vysshaya matematika (dlya gumanitarnykh spetsial'nostej) uchebnoe posobie / Rossijskij ehkonomicheskij universitet im. G. V. Plekhanova. – Moskva, 2018. – 112 s.

Kochkarov А .А. Metody prinyatiya upravlencheskikh reshenij: kolichestvennyj podkhod. – M.: KNORUS, 2016. – 146 s.

Konrad Karlberg Biznes-analiz s ispol'zovaniem Excel M.: Vil'yams, 2015 g – 576 s.

Sdvizhkov O. А. Diskretnaya matematika i matematicheskie metody ehkonomiki s primeneniem VBA Excel M.: DMK-Press, 2016 g. – 212 s.

Vlasov D. А. Osobennosti organizatsii samostoyatel'noj raboty studentov ehkonomicheskogo bakalavriata v ramkakh uchebnoj distsipliny «Teoriya igr» // Vestnik gumanitarnogo obrazovaniya. – 2017. – № 4. – S. 27-30.


Refbacks

  • There are currently no refbacks.


Abava   FRUCT 2019

ISSN: 2307-8162