Optimization of Network Schedule of Set of Operations in Excel

Full article

N.V. Katargin, Financial University under the Government of Russian Federation, Moscow, Russia, Ph.D., assistant professor, e-mail: This email address is being protected from spambots. You need JavaScript enabled to view it.; This email address is being protected from spambots. You need JavaScript enabled to view it.

The method of optimization of the network schedule by time and number of employees using the Excel service and the method of building the density of the distribution of the project end time by Monte Carlo with Visual Basic method at any distribution of the probabilities of the work time are proposed.

Keywords: network, optimization, plan, Excel, VBA, stochastic process, method Monte Carlo.

References

1. Goroshnikova T.A., Sunchalin A.M. Matematicheskie metodi v upravlenii proektami [Mathematical Methods at the Project Management]. Moscow, Financial University, 2013, p. 46-94.
2. Issledovanie operatsii v ekonomike [Investigation of operations in economics]. Edited by N.Sh. Kremer. Moscow, Jurait, 2013. p. 315-356.
3. Ekonomiko-matematicheskoe modelirovanie [Economy-Mathematical Modelling]. Edited by I.N. Drogobitski. Moscow, Ekzamen, 2004, p. 347-354.

For citation: Katargin N. V. Optimization of Network Schedule of Set of Operations in Excel // Corporate governance and innovative economic development of the North: Bulletin of the Research Center of Corporate Law, Management and Venture Capital of Syktyvkar State University. 2018. № 2. P. 129-136.