Integrated Informational and Analytical System of Calculating Economic Indices at Enterprises of Public Catering
https://doi.org/10.21686/2413-2829-2019-1-215-222
Abstract
The article provides a review of existing software for calculation of calorie content and food value of culinary dishes. A relevant sub-system was designed for market research and sociological survey. Based on analysis of existing software an integrated informational and analytical system was developed meant for calculating prime cost and price of culinary dishes depending on the norms of ingredients’ putting and for calculating economic indices. The structural and parametric analysis of data includes correlation and regressive analysis and the matrix of abnormal conditions. The sub-system of structural and parametric modeling and identification is used for the calculation. The sub-system of calculating economic indices automation was developed by MS Excel and Visual Basic For Application. It provides calculation of the number of sold culinary dishes and database for calculation and technical and technological cards, which are accompanied by visual screen forms. Importing data from MS Excel to the imitation system AnyLogic gives an opportunity to analyze dynamics of economic indices, forecast finance situation at the public catering enterprise. The integrated informational and analytical system could be useful for enterprises, executives, technologists, managers in restaurant business and could be introduced not only in the catering system of the Russian Plekhanov University of Economics but in other public catering enterprises.
About the Authors
M. A. Belyaeva
Plekhanov Russian University of Economics
Russian Federation
Russian Federation
Marina A. Belyaeva - Doctor of Thechnics, Professor of the Department for Restaurant Business of the PRUE.
36 Stremyanny Lane, Moscow, 117997.
A. A. Gazhur
Plekhanov Russian University of Economics
Russian Federation
Russian Federation
Alexander A. Gazhur - Doctor of Thechnics, Professor of the Department for Restaurant Business of the PRUE.
36 Stremyanny Lane, Moscow, 117997.
V. I. Perov
Plekhanov Russian University of Economics
Russian Federation
Russian Federation
Vitaliy I. Perov - Doctor of Economics, Professor, the Head of the Department for Restaurant Business of the PRUE.
36 Stremyanny Lane, Moscow, 117997.
O. K. Bezotosova
LLC "PepsiCo Holdings"
Russian Federation
Russian Federation
Olga K. Bezotosova - Expert on Transport Expenditure And Payments.
1 Territory of Free Economic Zone Sherrizon, Solnechnogorsk District, Moscow Region, 141580.
References
1. Belousova S. N., Bessonova I. A. Osnovnye printsipy i kontseptsii programmirovaniya na yazyke VBA v Excel [Key Principles and Concepts of Programming in VBA Language in Excel]. Moscow, Internet-University of Information Technologies, Binom, 2010. (In Russ.).
2. Belyaeva M. A. Sovremennye metody integratsii obrabotki informatsii v tekhniko - ekonomicheskikh sistemakh dlya prinyatiya optimal'nykh upravlencheskikh resheniy [Advanced Methods of Integrating Information Processing in Technical and Economic Systems in Order to Make Optimal Managerial Decisions]. Vestnik Rossiyskogo ekonomicheskogo universiteta imeni G. V. Plekhanova [Vestnik of the Plekhanov Russian University of Economics], 2016, No. 3 (87), pp. 120–128. (In Russ.).
3. Belyaeva M. A., Bezotosova O. K. Etapy razrabotki integrirovannoy informatsionno - analiticheskoy sistemy obrabotki ekonomicheskoy informatsii v organizatsiyakh [Stages of Developing the Integrated Informational and Analytical System of Economic Information Processing in Organizations]. Programmnye produkty i sistemy [Program Products and Systems], 2016, No. 3-1, pp. 142–148. (In Russ.).
4. Boev V. D. Modelirovanie v srede ANYLOGIC [Modeling in ANYLOGIC]. Moscow, Yurayt, 2017. (In Russ.).
5. Borshchev A. Imitatsionnoe modelirovanie kak instrument prinyatiya resheniy [Imitation Modeling as a Tool of Decision-Making]. Moscow, 2012. (In Russ.).
6. Katalevskiy D. Yu. Osnovy imitatsionnogo modelirovaniya i sistemnogo analiza v upravlenii [Principles of Imitation Modeling and System Analysis in Management]. Moscow, Public House of the Moscow University, 2013. (In Russ.).
7. Kuz'menko V. G. VBA. Effektivnoe ispol'zovanie [VBA. Efficient Use]. Moscow, Binom-Press, 2012. (In Russ.).
8. Perov V. I., Belyaeva M. A., Gazhur A. A., Shishkin A. V., Sokolov A. Yu., Bezotosova O. K. Tendentsii razvitiya zdorovogo pitaniya v vysshikh uchebnykh zavedeniyakh [Trends of Developing Healthy Catering in Universities]. Plekhanovskiy nauchnyy byulleten' [Plekhanov Academic Bulletin], 2018, No. 1 (13), pp. 75–81. (In Russ.).
9. Savitskaya G. V. Kompleksnyy analiz khozyaystvennoy deyatel'nosti predpriyatiya [Complex Analysis of Economic Activity in Enterprises]. Moscow, Infra-M, 2017. (In Russ.).
10. Titorenko G. A. Informatsionnye sistemy i tekhnologii upravleniya [Informational Systems and Technologies of Management]. Moscow, YUNITI-DANA, 2012. (In Russ.).
11. Walkerbach G. Excel 2016. Bibliya pol'zovatelya [Excel 2016. The Bible of the User]. Moscow, Williams, 2017. (In Russ.).
Review
For citations:
Belyaeva M.A., Gazhur A.A., Perov V.I., Bezotosova O.K. Integrated Informational and Analytical System of Calculating Economic Indices at Enterprises of Public Catering. Vestnik of the Plekhanov Russian University of Economics. 2019;(1):215-222. (In Russ.) https://doi.org/10.21686/2413-2829-2019-1-215-222
Views:
421
Email this article 