KR102669893B1 - Automatic calculation system for profit and loss by IT project using smart work log - Google Patents

Abstract

The present invention relates to a system for automatically calculating the profit and loss amount for each IT project using a smart work log. The present invention is to provide a smart work log that automatically checks work hours for each project and a system that automatically calculates the input amount for each project through this. will be.
The present invention automatically checks the work hours of project participants and tracks the profit and loss amount of the project in real time, allowing immediate tracking of projects that are experiencing problems, and then strategically implementing appropriate estimates and resource input when receiving new project orders. By enabling this, it has the effect of providing a system that can greatly contribute to the outsourcing company's net sales increase strategy.

Description

Automatic calculation system for profit and loss by IT project using smart work log}

The present invention relates to a system for automatically calculating the profit and loss amount for each IT project using a smart work log. The present invention is to provide a smart work log that automatically checks work hours for each project and a system that automatically calculates the input amount for each project through this. will be.

Existing IT projects are managed by manually entering tasks and times. As a tool, projects are managed through task management solutions such as Jira, Asana, and Notion, but they do not provide a function to measure the actual time invested and convert it into money. In other words, to record the actual time invested, it must be entered one by one, so management must be added, and even if a complex formula is defined and calculated in Excel, it is difficult to automatically measure the actual work period without entering it one by one. .

In particular, in small companies or companies that do not have time to even manage tasks, work tracking is not done properly, and in the case of outsourcing companies carrying out projects, labor costs are often the production cost, so it is difficult to know exactly how much a worker will spend on each project. There is a problem in determining whether resources have been invested without recording them one by one. If the exact level of resource commitment by practitioners cannot be determined, it is impossible to accurately measure the outsourcing company's project production costs. Due to the lack of proper profit and loss calculation for each project, estimates for new projects cannot be accurately calculated and sales strategies cannot be improved, a vicious cycle is being repeated.

Korean Patent Publication No. 10-2376755 (2022.03.16) Korean Patent Publication No. 10-1847946 (2018.04.05)

The purpose of the present invention is to automatically check the work hours of project participants and track the profit and loss amount of the project in real time, so that projects that are experiencing problems can be immediately tracked, and when receiving a new project order, appropriate estimates and resource input can be strategically provided. This is to ensure that it can be implemented.

In order to solve the above problems, the present invention includes a project input unit 110 for registering a plurality of project information in the company's network, and an active data collection unit ( 120) and an active time for classifying the access time data of the accessor for each project by comparing the access time data of the accessor collected through the active data collection unit 120 with the project information registered through the project input unit 110. An expected input and profit amount calculation unit 140 for calculating the expected investment amount and expected profit amount for each project based on the project information entered into the calculation unit 130 and the project input unit 110, and an active time calculation unit ( The access time of the working-level staff for each project is provided through 130), the expected investment amount and expected profit amount are provided through the expected investment and profit amount calculation department (140), and the actual investment amount is provided through the project-specific investment amount calculation department (170). A smart work log system to receive the input amount and actual profit amount, and to receive information on whether profit or loss is judged, whether profit or loss is judged compared to expected, and the amount of profit compared to expected is calculated through the profit and loss judgment department for each project (170) in a smart work log. The access time of the worker for each project is provided through the study unit 150 and the active time calculation unit 130, and the salary information for each worker among the project information is provided through the project input unit 110. The access time of the provided worker and the worker are provided. Based on the annual salary information, the estimated input amount is calculated through the project-specific input amount calculation unit 160 and the expected input and profit amount calculation unit 140 to calculate the actual investment amount for each project, including the actual labor costs incurred for each project. , the expected profit amount is provided, and the actual investment amount for each project is provided through the project-specific investment amount calculation unit 160. Whether to judge profit or loss based on the expected investment amount, expected profit amount, and actual investment amount for each project, and whether to judge profit or loss compared to the expectation. , Provides an automatic profit and loss amount calculation system for each IT project using a smart work log that includes a profit and loss judgment unit 170 for each project to calculate the profit amount compared to expected.

The present invention automatically checks the work hours of project participants and tracks the profit and loss amount of the project in real time, allowing immediate tracking of projects that are experiencing problems, and then strategically implementing appropriate estimates and resource input when receiving new project orders. By enabling this, it has the effect of providing a system that can greatly contribute to the outsourcing company's net sales increase strategy.

Figure 1 is a diagram showing the overall configuration of an automatic calculation system for profit and loss amounts for each IT project using the smart work log of the present invention.
Figure 2 is an example diagram showing a screen for inputting resource information for each project of the present invention.
Figure 3 is an example diagram of project information of the present invention.
Figure 4 is an example diagram showing that work hours are automatically checked through the smart work log of the present invention.
Figure 5 is an example diagram of profit and loss judgment for each project of the present invention.
Figure 6 is an example diagram showing the implementation process of the automatic calculation system for profit and loss amount for each IT project using the smart work log of the present invention.

Terms or words used in this specification and claims should not be construed as limited to their usual or dictionary meanings, and the inventor may appropriately define the concept of terms to explain his or her invention in the best way. It must be interpreted as meaning and concept consistent with the technical idea of the present invention based on principles.

Hereinafter, preferred embodiments of the present invention will be described in detail with reference to the attached drawings.

The present invention relates to a system for automatically calculating the profit and loss amount for each IT project using a smart work log. The present invention is to provide a smart work log that automatically checks work hours for each project and a system that automatically calculates the input amount for each project through this. will be.

Figure 1 is a diagram showing the overall configuration of the present invention. The system for automatically calculating the profit and loss amount for each IT project using the smart work log of the present invention includes a project input unit 110, an active data collection unit 120, and an active time calculation unit 130. ), the expected input and profit amount calculation department (140), the smart work schedule department (150), the investment amount calculation department by project (160), and the profit and loss judgment department by project (170).

Each component is described in detail as follows.

The project input unit 110 is used to register multiple project information in the company's network.

The project information includes the project contract amount, the name of the practitioners participating in the project, the project input schedule for each practitioner, the input rate for each practitioner, salary information for each practitioner, and resource information for each practitioner for each project.

Resource information may be information related to the results of projects carried out in the past by the executing entity or works acquired from the project. In this case, the resource information may include all types of information that can evaluate the expertise of the performing entity, and information that can evaluate the expertise of the performing entity refers to a correlation between the performing entity's expertise in a specific field and a predetermined standard value or more. It can mean information having .

Figure 2 is an example diagram showing a screen for inputting resource information for each project of the present invention, and Figure 3 is an example diagram of a screen of a smart work log into which project information of the present invention is input.

In addition, the project input unit 110 may further include a project personnel recommendation unit 111, wherein the project personnel recommendation unit 111 learns resource information about practitioners for each project and newly registered information based on the learned resource information. This is to select and recommend practitioners who correspond to the project information. Among the information registered as the project information, the practitioner-designated annual salary, required job information, values for job congruence, and worker's resource information are used through [Equation 1]. It is intended to recommend practitioners based on the practitioner selection index calculated by calculating the practitioner selection index.

The worker's resource information is information that includes the results of projects carried out in the past by the performing entity, information related to works acquired from the project, the worker's salary information, and the worker's career information.

(Here, K is the practitioner selection index, J1 is the practitioner-designated annual salary registered in the project information, J2 is the annual salary included in the practitioner's resource information, P1 is the weight for (J1-J2), and Rn is the nth resource information. P2 is the weight corresponding to the variable of resource information, W is the job matching value of the worker corresponding to the project, and P3 means the weight of the job of the project.)

In the case of the variable value of resource information, if qualifications such as experience required for the project are included among the values provided as resource information, it will be a value of +5, and if not, it can be set to a value of +1. The value can be arbitrarily adjusted by the administrator.

In the case of P1, which is the weight for (J1-J2), if the annual salary (J2) included in the worker's resource information is lower than the worker's designated annual salary (J1) registered in the project information, the weight can be set to have a higher value. The criteria for assigning can be arbitrarily set by the administrator, and a value between 0-1 is preferable.

In addition, for the convenience of calculation, values less than 10,000 Won can be omitted from the value for the annual salary. For example, if the annual salary is 50 million Won, it is desirable to display only 5,000.

The job match value of the worker corresponding to the project is determined by the degree of similarity between the project information and the worker's resource information, and has a value between 1 and 10. The higher the similarity, the larger the value is, and is arbitrarily set by the manager. This is a possible value.

The weight for the project job is a value entered together when registering project information. The higher the importance of the project job, the larger the value. This is a value that can be adjusted by the manager, and a value between 1 and 10 is desirable.

For example, the designated annual salary of a worker registered in the project information is 5000, the annual salary included in the worker's resource information is 4500, the weight P1 for (J1-J2) is 0.2, and the value corresponding to the variable for the first resource information is It is 5 and the corresponding weight is 3. The value corresponding to the variable for the second resource information is 7 and the corresponding weight is 4. When the job matching value of the worker corresponding to the project is 8 and the weight for the project job is 2

The value of the calculated practitioner selection index is compared with the practitioner selection index for practitioners who participated in existing projects to determine whether the calculated practitioner selection index is within the preset error range, and if it is within the error range, a suitable practitioner is selected. Allows you to judge.

The active data collection unit 120 is used to collect access time data of users connected to the provided company network.

The accessor connects to the network within the company through the accessor terminal, and the accessor terminal can be a PC, mobile terminal, tablet, etc.

Additionally, the company's network is a network provided by the company and can be provided by accessible servers, programs, etc.

The active time calculation unit 130 compares the user's access time data collected through the active data collection unit 120 with the project information registered through the project input unit 110 and classifies the user's access time data for each project. This is to transmit it to the smart work log provision unit (150).

Figure 4 is a smart work log provided through the smart work log providing unit 150 of the present invention, and is an example diagram showing the access time of the worker for each project provided in the smart work log.

The expected input and profit amount calculation unit 140 is used to calculate the expected investment amount and expected profit amount for each project based on the project information entered into the project input unit 110.

That is, the expected investment amount and expected profit amount for each project based on the project contract amount in the project information, the name of the project participant, project input schedule for each worker, input rate for each worker, salary information for each worker, and resource information for each worker for each project. can be calculated.

The expected input and profit amount calculation unit 140 may calculate the expected investment amount and expected profit amount for each project using an artificial intelligence original model.

In other words, whenever a project is completed, each project information, access time of each project worker, expected investment amount, expected profit, actual investment amount, actual profit amount, whether profit or loss is judged, whether profit or loss is judged compared to expected, profit amount compared to expected, etc. Information related to this is learned using an artificial intelligence-based model, and the expected investment amount and expected profit amount are calculated through the learned model.

The smart work log providing unit 150 receives the access time of workers for each project through the active time calculation unit 130, and provides the expected investment amount and expected profit amount through the expected investment and profit amount calculation unit 140. The actual investment amount and actual profit amount are provided through the project-specific investment amount estimation department (170), and the profit and loss judgment by project (170) calculates whether profit or loss is judged, whether profit or loss is judged compared to expected, and the profit amount compared to expected. This is to receive information as a smart work log.

The smart work log providing unit 150 can collect information on practitioners who participated in the project, create a database, and provide an employee sincerity evaluation index through [Equation 2] based on the frequency of participation in the project. The provided employee sincerity The provincial evaluation index is evaluated relative to each employee and can be used as data to reward or provide benefits to employees with a high integrity evaluation index.

(Here, V is the employee sincerity evaluation index, G is the number of projects that participated as the main project (high contribution to the project) among participating projects, L is the number of projects that participated as an auxiliary project among participating projects, and H is the number of projects that participated as an auxiliary project among participating projects whose contribution is less than the set value. refers to the number of projects)

Here, if the number of projects whose contribution is less than the set value is 2 or less, H-1 is substituted as 1.

In other words, the employee integrity evaluation index classifies projects into main participating projects, auxiliary participating projects, and projects in which each employee participated but whose contribution is below the set value (deemed to be low contribution) according to the contribution level of the project in which each employee participated within the set period. , the employee sincerity evaluation index can be calculated through the classified projects, and the larger the calculated value, the more faithfully the work can be judged to have been performed. The manager can input whether each project an employee participates in is a main project, an auxiliary project, or a low-contribution project, and can be automatically classified based on information provided in the smart work log according to preset standards.

Basically, the higher the overall participation frequency in a project, the higher the employee integrity evaluation index can be calculated. In addition, the hyperbolic tangent of Equation 1 means that the variable has a value between 0 and 1, and as the variable increases, it has a value closer to 1. Even if the value of the variable increases, the amount of increase becomes smaller when it exceeds a certain value, resulting in a meaningless result. You can prevent the value from increasing.

For example, among the projects in which employee Q participated, there were 5 projects in which he participated as the main project, 4 projects in which he participated as an auxiliary project, and 2 projects with low contribution (lower than the set value).

It is calculated to be approximately 24.

It can be used as an indicator that can be reflected in personnel evaluations to provide benefits, such as calculating the employee integrity evaluation index of all employees who participated in work and providing rewards in order of employees with the highest employee integrity evaluation index based on the calculated value.

The project-specific input amount calculation unit 160 receives the access time of the worker for each project through the active time calculation unit 130, and receives salary information for each worker among the project information through the project input unit 110. This is to calculate the actual investment amount for each project, including the actual labor costs incurred for each project, based on access time and salary information for each worker.

The profit and loss judgment unit 170 for each project receives the expected input amount and expected profit amount through the expected input and profit amount calculation unit 140, and receives the actual input amount for each project through the project input amount calculation unit 160. This is to calculate the profit or loss judgment, whether to judge profit or loss compared to expected value, and the amount of profit compared to expected value based on the expected investment amount, expected profit amount, and actual investment amount for each project.

Referring to Figure 6, the flow for executing the system of the present invention is as follows.

First, when a project A participant connects to the company's network and executes a program related to project A (S1), active (or active window) data is collected by the active data collection unit 120 (S2). The collected active data is stored on a server provided within the company network (S3), and the collected active data is classified into active time by project through the active time calculation unit 130, and since the participant is a participant in Project A, he or she participates as Project A. The log of the active time is classified, and the classification method may be classified by a pre-trained artificial intelligence model (S4, S5). The classified information is delivered to the smart work log provision unit 150 to be linked to the smart work log (S7). In addition, project information including resource information is input by the network manager within the company (S6), and the input information is transmitted to the smart work log providing unit 150 and linked to the smart work log (S7). The information linked to the smart work journal receives the expected investment amount and expected profit amount through the expected investment and profit amount calculation unit (140) after object verification is completed (S8).

Afterwards, the actual input amount and actual profit amount are provided through the project-specific input amount estimation department (170), and the profit and loss judgment by project (170) is used to calculate profit or loss, whether profit or loss is judged compared to expected, and the profit amount compared to expected. By receiving information, the profit and loss for each project can be judged (S9).

The embodiments described in the present specification and the configurations shown in the drawings are only one of the most preferred embodiments of the present invention and do not represent the entire technical idea of the present invention, so various equivalents and modifications can be substituted for them. It should be understood that there may be examples.

110 Project input unit
120 Active data collection department
130 Active time calculator
140 Expected input and profit amount calculation book
150 Smart work log provision department
160 Calculation of investment amount by project
170 Project-specific profit and loss judgment department

Claims (3)

A project input unit 110 for registering multiple project information in the company's network,
An active data collection unit 120 for collecting access time data of users connected to the company's network,
An active time calculation unit (130) for classifying the access time data of the user for each project by comparing the access time data of the user collected through the active data collection unit 120 with the project information registered through the project input unit 110. )and,
An expected input and profit amount calculation unit 140 for calculating the expected investment amount and expected profit amount for each project based on the project information entered into the project input unit 110;
The access time of the worker for each project is provided through the active time calculation unit 130, the expected investment amount and expected profit amount are provided through the expected input and profit amount calculation unit 140, and the investment amount amount for each project is provided ( Receive the actual investment amount and actual profit amount through 170), and receive information on whether profit or loss is judged, whether profit or loss is judged compared to expected, and the amount of profit compared to expected is calculated through the profit and loss judgment department for each project (170) in a smart work log. A smart work log provision unit (150) for
The access time of the worker for each project is provided through the active time calculation unit 130, and the salary information for each worker is provided among the project information through the project input unit 110. Based on the provided access time and salary information for each worker, each A project-specific input amount calculation unit 160 for calculating the actual project-specific input amount including labor costs actually incurred for each project,
The expected investment amount and expected profit amount are provided through the expected input and profit amount calculation unit 140, and the actual investment amount for each project is provided through the project-specific investment amount calculation unit 160, and the expected investment amount, expected profit amount, and actual amount are provided. It includes a profit and loss judgment unit 170 for each project to determine whether to determine profit or loss based on the investment amount for each project, whether to judge profit or loss compared to expectations, and calculate the amount of profit compared to expected,

The project information of the project input unit 110 includes the project contract amount, the name of the project participant, the project input schedule for each worker, the input rate for each worker, salary information for each worker, and resource information for each worker for each project,

The project input unit 110 is
It further includes a project human resource recommendation unit 111 for learning resource information about practitioners for each carried out project and selecting and recommending practitioners corresponding to newly registered project information based on the learned resource information,

The project personnel recommendation department (111) is
Among the information registered as project information, the practitioner selection index is calculated by calculating the practitioner selection index through [Equation 1] based on the practitioner-designated annual salary, required job information, job congruence value, and practitioner resource information, and the practitioner selection index is selected. Recommended,
The worker's resource information is information that includes the results of projects carried out in the past by the performing entity, information related to works acquired from the project, the worker's salary information, and the worker's career information,

[Equation 1] is

(Here, K is the practitioner selection index, J1 is the practitioner-designated annual salary registered in the project information, J2 is the annual salary included in the practitioner's resource information, P1 is the weight for (J1-J2), and Rn is the nth resource information. is a value corresponding to a variable, P2 is a weight corresponding to a variable of resource information, W is a job match value of a practitioner corresponding to the project, and P3 is a weight for the job of the project.) An automatic calculation system for profit and loss amounts for each IT project using a smart work log. delete delete