Microsimulation model of national economy MSMNE-02

Dr. Danylo Kozub
assistant professor, chair of general economic theory
National Technical University "KhPI", Kharkiv, Ukraine


Multi-agent microsimulation modeling is a promising approach that represents economy by constructing virtual economic world with independent intelligent agents (households, firms, markets, etc)  which behave like their real-life counterparts. Macroeconomic variables, such as CPI or GDP, are formed by aggregation of all transactions in the virtual economy.

MSMNE-02 was developed as MS Excel program, so that all interested researchers can "play" with the model and easily integrate their own statistical data. The model is free for download and use.   

MSMNE-02 is the result of redevelopment of the microsimulation model used in my thesis "Transition processes in industrial economy: content and methods of structuring". Special thanks to Prof. M. Gurevichov (NTU "KhPI", Kharkiv, Ukraine), Prof. Dr. G. Schwödiauer (Otto-von-Guericke-Universitaet, Magdeburg, Germany) and Prof. A.Wörgötter, (Institute for Advanced Studies, Vienna, Austria) for their support and ideas.

General structure of the model


There are three branches in the model: agriculture, industry and services. Each branch contains one or several firms. Each firm consumes four resources (labour and output of three branches) and produces one output resource according to the branch it belongs to.

Households consume three types of resources and "produce" labour force as an output.

Exporters represent consumption of foreign countries. Exporters consume three types of resources and  "produce" foreign currency as an output resource. Importers "consume" foreign currency and "produce" three types of resources.

Resources can be bought or sold on the appropriate market. Market (as an agent) maintains some reserve of resource and adjusts price to balance demand and supply.

State collects taxes as a share of firm's output and distributes tax revenue as transfers to households and intervention into foreign currency market to keep exchange rate stable when import does not equal export.

Input-output model

Initial conditions of the microsimulation model are derived from the static input-output balance model. Input-output balance model has the following structure:

The core of this input-output model is the matrix of intermediate consumption (matrix XA). The row of this matrix defines consumption of the "row-branch" resource by the "column-branch" firms. The column of this matrix shows which "row-branches" consume output resource of the "column-branch" firms. In fact, matrix XA on the chart is a result of multiplication of transposed vector X (total output) by matrix A (input-output coefficients). Multiplication of matrix A by vector X gives vector AX (intermediate consumption).

Sum of intermediate consumption (AX) and final consumption (C+I+Ex+Im) equals to the total output (X)

Vertical structure of the model (XA, W, T, D) represent the structure of the value, produced by the firm of the "column-branch". Total value (X) is a sum of resource costs (XA) and value added ( (W)ages, (T)axes, (D)epreciation).

Depreciation (D) of each "column-branch" is transformed by investment matrix (B) into investment demand (I) for resources of "row-branches". Total depreciation equals total investment.

Taxes (T) are used to balance import and export. Remainder of the taxes via transfers to households together with wages (W) forms private consumption (C). The following rule should hold:
Taxes (T) + Wages (W) = Private consumption (C) + Export (Ex) + Import (Im)

It is not a trivial task to create balanced input-output model that meets all the above requirements. Special computer algorithm based on the multicriterion optimization was developed to transform available statistics and assumptions into balanced IO model. This algorithm in form of MS Excel program is freely available upon request.

Microsimulation model

IO model is used as a starting point of the microsimulation model. The values from the IO model define initial output of firms, structure of intermediate and investment demand of the firms, structure of private consumption of households, etc. Balanced IO model is static and rigid: none of the numbers can be changed without changes in all other coefficients. The microsimulation model, on the contrary, is elastic: IO model defines only stationary equilibrium state which can be disturbed by external shocks.

To make microsimulation model elastic, each agent (firm, household, market) has its own elasticity coefficient for demand and supply. Therefore, demand structure derived from IO model is not rigid, it only determines some "optimal", equilibrium structure.


User interface description and features

The model is realized a MS Excel workbook and imbedded macros  (Visual Basic). The interface of the model looks like this:

There are tree buttons to control simulation process: start, pause, stop. Control parameters can be changed during simulation. It is also possible to dynamically change time scope of the diagrams from 2 to 16 years.

User can change the following control parameters of the model:

Two upper diagrams allow to observe  two of the following parameters, each for 5 main resources (3 resources + labour force + foreign currency):

Each of the two lower diagrams displays changes in up to three aggregated parameters, chosen by user from:

Download and start-up notes

Follow these steps to run simulation:

  1. Download MSMNE-02 model as MS Excel file (~500Kb). Or download zip archive (~150Kb)  and unpack it.
  2. Open MSMNE-02_v100.xls. Note that macros should be enabled to start simulation.
  3. Use buttons "start", "pause", "stop" to control simulation process.
  4. Change control parameter by selecting parameter (e.g."Tax Level"), its value (e.g. "=Initial Value +10%") and by pressing "set" button.
  5. Chose the diagram contents by selecting from the indicator lists near the diagrams.

Contact information

The model is still under development. If you are interested in updates or you have suggestions, comments, questions I would be glad to hear from you. Please contact me by mail msmne@dankozub.com or via ICQ (DanKozub:99815266).



Models that include general equilibrium simulation

Models that do NOT include general equilibrium simulation

Models that MAYBE include general equilibrium simulation