Development information system of quotas and purchases to replenish the stocks by example of Limited Liability Company «Kompel»

1.

Russian State Agrarian University –
Moscow Timiryazev Agricultural Academy
Institute of Economics and management
Department of Applied Computer Science
Masters work:
Development information system of quotas and purchases to replenish
the stocks by example of Limited Liability Company «Kompel»
Student: Kosyrev Ivan Vadimovich
Group: DE-123
Direction : Applied informatics (09.04.03)
Moscow 2022

2.

Tasks of the masters work
1.
2.
3.
4.
5.
6.
Analyze the activities company LLC Kompel.
Analyze the existing quota and purchase process for stock
replenishment.
Set tasks for information system design.
Plan the development time and cost of implementation.
Create a prototype IS.
Test IS prototype and make instructions for its operation.

3.

Setting task for IS development
User roles:
1.Admin.
2.MPK.
3.SPOD.
4.MPO.
5.SPZ.
Database will hold:
1.Nomenclatures of products.
2. Quantity of products in stock.
3. Suppliers, purchasers, employees.
4. Offers from suppliers.
5. Requests and purchase orders.
System functionality:
• purchase of electronic components;
• product accounting;
• file storage;
• report generation;
• sales prognosis calculation;
• data analysis.

4.

Process model AS IS

5.

Process model TO BE

6.

Physical model of the database in ER Win

7.

Mathematical support
Formulas for calculating products in stock:
Formula for calculating the sales forecast :
Formula for calculating amount product, to the purchase:

8.

Information system

9.

The total cost of the project
Total cost:
1 162 903 Rub

10.

Result
The tasks in this master's work have been successfully solved - developed
information system of quotas and purchases to replenish the stock in the company
LLC «Kompel».
The projected information system will:
• Automated purchase of necessary products;
• Reduce the time of supply department employees to complete processes;
• Centralize the collection of necessary documents and reports in a single
database;
• Reduce errors.