ARTÍCULO
TITULO

MS Excel as system of support of decision-making

D. ?. Vlasov    
A. V. Sinchukov    

Resumen

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

 Artículos similares

       
 
Nelito Calixto and João Ferreira    
Performance Evaluation is a process that occurs multiple times per year on a company. During this process, the manager and the salesperson evaluate how the salesperson performed on numerous Key Performance Indicators (KPIs). To prepare the evaluation mee... ver más
Revista: Applied Sciences

 
Valerii Kyrylovych,Lubomir Dimitrov,Petro Melnychuk,Anatolii Bohdanets,Andrii Shostachuk     Pág. 6 - 18
A new method for the automated selection of robotic mechanic-assembly technologies according to technical and economic criteria was proposed. The choice is made on the known set of robotized mechanic assembly technologies, components of the system of tec... ver más

 
Qiang Fu, Linqi Li, Mo Li, Tianxiao Li, Dong Liu and Song Cui    
The potential influence of natural variations in a climate system on global warming can change the hydrological cycle and threaten current strategies of water management. A simulation-based linear fractional programming (SLFP) model, which integrates a r... ver más
Revista: Water

 
Stefan Kudlac, Jozef Majercak, Peter Majercak     Pág. 45 - 50
To ensure sustainable system of freight transport is necessary to provide efficient transport services with significant focus on level of customer service. The air transport system is very often the part of logistics chain in intermodal freight transport... ver más

 
Travis R. Stroth, Brian P. Bledsoe, Peter A. Nelson     Pág. 1 - 17
Analytical channel design tools have not advanced appreciably in the last decades, and continue to produce designs based upon a single representative discharge that may not lead to overall sediment continuity. It is beneficial for designers to know when ... ver más
Revista: Water