The authors did apply the Leontief input-output model to analyze the inter-industry balance of one city with three main sectors of the economy. They did set a task is to create an inter-branch balance for 2017 based upon 2016 data, taking into account the export and import components, and to assess the changes in all urban sectors with varying demand in one segment. To solve the problem the authors used Microsoft Excel package. They have shown the way the Leontief model enables to plan inter-branch relations at the level of municipal economy, to forecast the budget on the basis of data from previous years and to account for various sectors’ queries. Computer calculations make it possible to recalculate the model repeatedly to find optimal solutions.
Keywords: inter-industry balance, gross output, planning, mathematical model.
References
- Revyakin A. M., Bardushkina I. V. Matematicheskie metody modelirovaniya v ekonomike (Mathematical Modeling Methods in Economics), M., MIET, 2013, 328 p.
- Bardushkin V. V., Bardushkina I. V. Ispol’zovanie proektnoi deyatel’nosti v samostoyatel’noi rabote studentov po vysshei matematike (Project Activities Use in Students’ Independent Work on Higher Mathematics), Aktual’nye problemy sovremennogo obrazovaniya: opyt i innovatsii, mat-ly Vseros. nauch.-prakt. konf. (zaochn.) (28—29 noyabrya 2016 g.), Tol’yattinskii GU, Ul’yanovsk, ZEBRA, 2016, pp. 291—295.
- Bardushkina I. V., Revyakin A. M. K voprosu o povyshenii kachestva samostoyatel’noi raboty studentov po vysshei matematike (To a Question of Improvement of Quality of Independent Work of Students on the Higher Mathematics), Ekonomicheskie i sotsial’no-gumanitarnye issledovaniya, 2015, No. 4 (8), pp. 57—62.
- Revyakin A. M., Bardushkina I. V., Tereshchenko A. M. Opyt provedeniya interaktivnykh zanyatii po kursu “Metody modelirovaniya ekonomiki” (The Experience in Interactive Lessons of “Economics Modeling Techniques” Course), Ekonomicheskie i sotsial’no-gumanitarnye issledovaniya, 2016, No. 3 (11), pp. 14—20.
- Bardushkina I. V. Ekonomicheski orientirovannye zadachi v modeli formirovaniya matematicheskoi kompetentnosti studentov (Economically Oriented Tasks in Model of Students’ Mathematical Competence Formation), Aktual’nye problemy sovremennogo obrazovaniya, opyt i innovatsii, Nauchno-prakt. konf. (zaochnaya) s mezhd. uchastiem (21—22 oktyabrya 2015 g.), Tol’yattinskii GU, Ul’yanovsk, ZEBRA, 2015, pp. 375—379.