JPH08202780A - Wage table preparing method - Google Patents

Abstract

PURPOSE: To easily prepare a wage table even without detailed knowledge. CONSTITUTION: A CPU 2 stores a standard age, standard wage and parameter containing the constitutive ratio of age salary and ability salary corresponding to this standard wage in a parameter memory 6 by the respective qualifications of plural qualifications (step S1). Next, the age wages by ages corresponding to qualification difference are calculated from wage difference and age difference in the age salary items among the respective qualification and stored in a hard disk 7 as an age salary table corresponding to the respective correspondent ages (step S2). Besides, ability wages by the respective ranking values of ability salary items in those qualifications are calculated from the wage difference in the ability salary items among the respective qualification, age difference and the number of ranks peculiar for those ability salary items and stored in the hard disk 7 as an ability salary table corresponding to the respective correspondent ranking values (step S3).

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a wage table preparation method for automatically generating various wage tables used for determining the amount of payment of each individual for salaries to be paid by general companies.

[0002]

2. Description of the Related Art In a company, the amount of salary for each individual is determined based on some system, and the system itself is generally reviewed and redesigned every few years.

[0003] The amount of salary is determined as a total amount according to the world standard and the performance of the company, and how to distribute it is the amount corresponding to the age, the in-house qualification, the position, etc. It is usually determined by a pay scale that defines How to classify and accumulate the total salary is determined by the "salary system".

The salary system is based on the policy of the company, and how the salary system is combined and how the seniority element and the ability element are combined to make a consistent design. The current situation is that trial calculation and verification are repeated, and trial and error are used to create them.

The salary system is designed in the following procedure.

(1) Create a framework for the qualification system.

(2) A model wage is determined for each qualification.

(3) Determine the salary system.

(4) The distribution ratio is determined for each qualification.

(5) Create various wage tables.

FIG. 8 shows an example of the framework of the qualification system. Although it is simplified here, it represents the in-house qualification name and the standard age to be adopted for the qualification.

Further, FIG. 9A shows a salary system. Here, "work-based salary" which constitutes the basic salary,
“Qualifications”, etc. shall be determined by the wage table.

FIG. 9B shows an example of an age pay table. In this age pay table, the age and the amount of money simply correspond.

On the other hand, FIG. 9C shows an example of a job performance table. In this job list, 1 for each qualification
The amount is decided for each of a plurality of "ranks" such as 2, 3, .... The amount of increase in this rank will be determined according to the personnel evaluation at the time of promotion.

As described above, the salary is usually determined by accumulating a plurality of wage tables, but since various factors such as what the ratio of the seniority element to the ability element is to be dealt with depending on the qualification, these various wages are also involved. Designing a table is not easy.

In the past, a person in charge made a pay table by making full use of an electronic desk calculator or spreadsheet software on a computer system.

[0017]

Generally, when a wage table is created using spreadsheet software, some kind of formula is defined and numerical values based on the formula are sequentially generated to fill the table. Be the way. The wage table is not limited to one type, but the salary amount is determined by a combination of multiple wage tables, which is a combination of tables with different meanings, such as seniority factors and job factors.

The method of combining these reflects the idea and policy of the company (manager). For example, there are cases in which the ratio of functional elements is reduced during the period just before joining the company, and the ratio of functional elements is increased as the qualification increases and the veteran becomes more active, thereby enhancing the merit principle.

In order to reflect such a policy, the composition ratio of each wage in the total salary will change depending on the qualification and age, and designing such a wage table is a spreadsheet calculation. Making full use of software is not easy.

Further, it is difficult to design a wage table unless one is familiar with the functions of spreadsheet software and has sufficient knowledge about the mechanism and theory of wage design.

[0021] The object of the present invention is to solve the problems without detailed knowledge.
It is to be able to easily create a pay scale.

[0022]

The means of the invention of claim 1 is as follows. A wage table preparation method for each salary item in a salary system that determines the amount of salary to be paid based on the sum of wages in multiple salary items including age salary items and ability salary items. , The standard age of the qualification, the standard wage of the qualification, and the composition ratio of each salary item to the standard wage.
Next, the wage difference in the above age wage items between each qualification,
Based on the age difference between the qualifications, age-based wages for each age according to the qualification difference are calculated. Then, an age wage table is created by associating the age wages calculated for each age with the corresponding individual ages. In addition, from the wage difference in the above-mentioned ability pay item between each qualification, the age difference between the qualifications and the number of peculiar increments of the ability pay item, the ability pay for each tick value of the above-mentioned ability pay item in the qualification. Calculate wages. Then, a capacity wage table is created by associating the above capacity wages calculated for each unit value with the corresponding individual unit values.

The means of the invention of claim 2 is as follows.
A wage table preparation method for a salary system that determines the amount of salary to be paid based on the sum of wages in a plurality of salary items. First, for each qualification of a plurality of qualifications, the standard age of the qualification, the standard wage of the qualification, and The composition ratio of each salary item to this standard wage is arbitrarily set. Also, one of the plurality of salary items is designated. Next, for the specified salary item, from the wage difference in the salary item among the qualifications, the age difference between the qualifications and the predetermined number of steps, the wage at each step value of the above salary item in the qualification. To calculate. Then, a wage table is created by associating the calculated wages at the respective increments with the respective increments in the designated salary item.

[0024]

The operation of the means of the present invention is as follows. When creating a wage table for each salary item in a salary system that determines the amount of salary to be paid based on the sum of wages in multiple salary items including age salary items and ability salary items, each qualification of a plurality of qualifications must be created in advance. , The standard age of the qualification, the standard wage of the qualification, and the composition ratio of each salary item to the standard wage are set arbitrarily. Then, for example, the CPU or the like calculates age-based wages according to the qualification difference from the wage difference between the qualifications according to the age wage item and the age difference between the qualifications. An age wage table that associates the specified age wages with the corresponding individual ages is created. In addition, from the wage difference in the above-mentioned ability pay item between each qualification, the age difference between the qualifications and the number of peculiar increments of the ability pay item, the ability pay for each tick value of the above-mentioned ability pay item in the qualification. A wage is calculated, and a capacity wage table is created by associating the above-mentioned capacity wage calculated for each unit value with the corresponding individual unit value.

The means of the invention of claim 2 is as follows.
In a salary system that determines the amount of salary to be paid based on the sum of wages in multiple salary items, when creating a wage table, the standard age of that qualification, the standard wage of that qualification, and this The composition ratio of each salary item with respect to the standard wage is arbitrarily set, and one salary item among the plurality of salary items is designated. Then, for example, the CPU or the like, for the specified salary item, the wage difference in the salary item between the respective qualifications,
From the age difference between the qualifications and the predetermined number of ticks,
The wage at each tick value of the salary item in the qualification is calculated, and a wage table in which the calculated wage at each tick value is associated with each of the tick values of the designated pay item is created.

[0026]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described below with reference to FIGS.

FIG. 1B is a block diagram of the main blocks of a computer system 1 for carrying out the wage table preparation method of one embodiment. In FIG. 1, reference numeral 2 is a CPU for controlling the whole. . Reference numeral 3 is an input / display device for inputting parameters for creating a pay scale, and 4 is a RAM used as a work area of the CPU 2.
Reference numeral 5 is a wage table preparation software memory storing a wage table preparation program, and 6 is a wage table parameter memory storing parameters input from the input / display device 3.
Reference numeral 7 denotes a hard disk that stores wage table data created as a result of the CPU 2 executing the wage table creating program stored in the wage table creating software memory 8,
Is a printer that prints the data of the created pay scale. Of course, the created pay scale can be displayed not only on the printer 8 but also on the screen of the input / display device 3. The created wage table is stored in the hard disk 7 for the purpose of passing it as data to an operation program such as a salary calculation system thereafter.

FIG. 2A is a diagram specifically showing the parameters shown in the wage parameter memory 6. These parameter values are variables that should be specified when creating a pay scale. Therefore, in the following description, as shown in (B) of the same figure, the number of qualifications is n, the standard age is n1 to n5, the amount of model wage is c1 to c5, and the model wage is , Ws1 to ws5, wn1 to wn5 of age wages in the model wage, and p is the standard promotion rank of the functional wage. Here, the standard promotion rank means that a person who has received a standard evaluation will be improved by p rank on the job performance table in one year. Furthermore, it is assumed that the functional salary from 1 to the upper limit imax is obtained as the number of positions to be generated in the functional salary table.

FIG. 1A, FIG. 3 and FIG. 4 show operation flowcharts of the wage table preparation program stored in the wage preparation software memory 5. When this creating program is started by the CPU 2, the above-mentioned parameters are read, each designated pay scale is generated, the result is stored in the hard disk 7, and the process ends when all the pay scales are generated. In this embodiment, for convenience,
The types of wage tables to be generated are "age pay table" and "job pay table".
The description will be limited to two types.

First, as shown in FIG. 1 (A), after starting, a new input or correction input of the above-mentioned parameters is received from the input / display device 3 and stored in the wage parameter memory 6 (step S1). Next, for details, age generation table generation processing as shown in FIG. 3 is performed (step S2). Then, for details, a process for generating a job performance salary as shown in FIG. 4 is executed (step S3), and the process ends.

Next, the age pay table generating process executed in step S2 will be described.

The age salary table is a table defining the absolute amount of age salary corresponding to the age in units of one year. First, the model wage of the lowest qualification is calculated from the parameters, and the age wage of the minimum age, which is the standard, is calculated from the ratio of the age wage.

Xn1 = c1 × wn1 / 100 Here, xn1 is the age salary of the standard age to be assigned to the lowest qualification (in this case, a general job).

Next, the age salary of the standard age to be promoted to the qualification one above (in this case, the planning job) is as follows.

Xn2 = c2 × wn2 / 100 Therefore, the age wage of n1 is xn1, and the age wage of n2 is x.
Since it is n2, the pitch of the age salary for each year during this period is
It is calculated as follows.

Np = (xn2-xn1) / (n2-n1) Therefore, the n1 age wage is xn1, the n1 + 1 age wage is xn1 + np, and the n1 + 2 age wage is xn1 + np ×.
You can ask for something like 2, ...

FIG. 5A and FIG. 5B are shown based on the above example. Further qualifications can be requested in the same way.

Now, the age pay table preparation process will be described with reference to the flowchart of FIG.

First, the number of qualifications is read from the wage parameter memory 6 and stored in the register n provided in the RAM 4 (step S201). Then, the lowest qualification is stored in the current qualification register R provided in the RAM 4 as a processing target (step S202).

Here, from the wage parameter memory 6, the model wage of the current qualification, the ratio of the age wage to the model wage,
The standard age of the current qualification is read and stored in the registers provided in the RAM 4 (step S203). For example,
If the current qualification is the lowest qualification, c1, wn1, n1
Will be stored.

Further, the model wage of one qualification higher than the current qualification, the ratio of the age wage to the model wage, and the standard age of the current qualification are read and stored in the registers provided in the RAM 4 (step S204). For example, if the current qualification is the lowest qualification, c2, wn2, n2 will be stored.

Next, using these, the age wage and age wage pitch of the current qualification are obtained (step S205). That is,
The age salary at the standard age of the current qualification and the age salary at the standard age of the qualification higher than the current qualification are obtained and stored in registers provided in the RAM 4. For example, when the current qualification is the lowest qualification, xn1 = c1 × wn1 / 100 xn2 = c2 × wn2 / 100 Age wage xn1 at the standard age of the lowest qualification
And the age salary xn2 at the standard age of the qualification one above are obtained and stored in the register. Then, the pitch of the age salary in the current qualification (amount of money for each year) is obtained and stored in the register provided in the RAM 4. For example, when the current qualification is the lowest qualification, the age salary pitch is obtained by np = (xn2-xn1) / (n2-n1) and stored in the register.

Next, a calculation for obtaining a value for each year is performed.

First, for repetitive control, the standard age of the current qualification is stored in the variable register i provided in the RAM 4,
Further, the age wage at the standard age of the current qualification is stored in the register xn (step S206). For example, when the current qualification is the lowest qualification, n1 is stored in the register i and xn1 is stored in the register xn.

Further, the current age and the age salary are paired and stored in the hard disk 7 (step S207). For example, when the current qualification is the lowest qualification and is stored for the first time, the standard age n1 of the lowest qualification and its age salary xn1 are stored in the hard disk 7.

Then, "1" is added to the content of the variable register i (step S208), and it is checked whether or not it has reached the standard age of the next qualification (step S209). For example, if the current qualification is the lowest qualification, the variable register i
It will be checked whether the content of has reached n2.

If the content of the variable register i is smaller than the standard age of the next qualification, the register x of the RAM 4
After np, which is the age wage pitch, is added to the age wage stored in n (step S210), the process returns to step S207 and the above process is repeated.

In this way, the age salary is made to correspond to each year, and this value is stored in the hard disk 7 as a pair with the age.

When the content of the register i reaches the standard age of the next qualification, the calculation loop for that qualification ends.

Next, it is judged whether the qualification one level higher than the current qualification is the highest qualification (step S211), and if it is not the highest qualification, the current qualification is made one level higher. (Step S212), the process is repeated from step S203. For example, when the current qualification is the lowest qualification, the qualification R2 one level higher is stored in the current qualification register R.
Therefore, after that, when each parameter is read again in step S203, the register provided in the RAM 4 stores c
2, wn2, n2 will be stored.

In this way, the value for each year for each qualification is obtained and stored in the hard disk 7, and step S21
When it is determined that the qualification one level higher than the current qualification is the highest qualification in 1, the age salary pitch np is added to the age salary stored in the register xn of the RAM 4, The age wage in the standard age of the highest qualification is calculated (step S213). Then, this is paired with the current age, that is, the standard age of the highest qualification, and stored in the hard disk 7 (step S214), and the generation process of this age pay table is finished.

Next, a description will be given of the process for generating a job performance table executed in step S3.

The job function salary is a table that defines the absolute amount corresponding to each rank from No. 1 to No. X for each qualification. The first rank is the rank at the time when it was first rated for the qualification, and each year the number of ranks is decided by the personnel evaluation. Here, the standard promotion rank is the p rank.

First, the model wage of the lowest qualification from the parameters and the first-ranked work ability as a reference from the ratio of work ability are obtained as follows.

Xs1 = c1 × ws1 / 100 where xs1 is the lowest qualification (in this case, a general job)
It is the first-ranked occupational salary.

Next, the first-ranked work ability of the qualification (planned work in this case) above is as follows.

Xs2 = c2 × ws2 / 100 The standard number of years required during this period is (n2-n1), and the p number, for example, the 5th number, is increased every year, so 1
The pitch per rank is calculated as follows.

Sp = (xs2−xs1) / ((n2−n1) × p) From this, the lowest rank qualification (in this case, a general job) is the first rank of the work function is xs1 and the second rank is the work function salary. xs1 + sp, the third-ranked occupational salary can be obtained as xs1 + sp × 2, ....

FIG. 5A and FIG. 6 are illustrated based on the above example. Further qualifications can be requested in the same way.

Now, this job performance salary table generation processing will be described with reference to the flowchart of FIG.

First, the number of qualifications is read from the wage parameter stored in the wage table parameter memory 6 and stored in the register n of the RAM 4. Further, the standard promotion number for one year is stored in the register p, and the maximum value of the number obtained as a job performance table is stored in the register imax (step S301).

Then, the lowest qualification is processed as R
It is stored in the current qualification register R provided in AM4 (step S302).

Here, from the wage parameter memory 6, the model wage of the current qualification, the ratio of the work ability to the model wage,
The standard age of the current qualification is read and stored in the registers provided in the RAM 4 (step S303). For example,
If the current qualification is the lowest qualification, c1, ws1, n1
Will be stored.

Further, the model wage of one qualification higher than the current qualification, the ratio of the work wage to the model wage, and the standard age of the current qualification are read and stored in the registers provided in the RAM 4 (step S304). For example, if the current qualification is the lowest qualification, c2, ws2, n2 will be stored.

Next, by using these, the work ability salary and the work ability salary pitch of the current qualification are obtained (step S305). That is,
The work ability salary at the standard age of the current qualification and the work ability salary at the standard age of the qualification one higher are obtained and stored in the registers provided in the RAM 4, respectively. For example, when the current qualification is the lowest qualification, xs1 = c1 × ws1 / 100 xs2 = c2 × ws2 / 100
And the work ability salary xs2 at the standard age of the qualification one level above are obtained and stored in the register. This x
s1 represents the first-ranked work ability in the current qualification, and xs2 represents the first-ranked work ability in the higher qualification. In other words, the number of people who receive a standard evaluation rises by p number every year,
When the standard age reaches n2, the work allowance table is designed so that the work allowance under the current qualification becomes equal to the work pay for the first rank of the next qualification.

Then, the pitch of the first place in the performance-based salary in the current qualification is obtained and stored in the register provided in the RAM 4. For example, when the current qualification is the lowest qualification, the skill-based salary pitch is obtained by sp = (xs2-xs1) / ((n2-n1) * p) and stored in the register.

Next, the calculation for obtaining the value for each unit is performed.

First, for repetitive control, "1" is stored in the variable register i provided in the RAM 4 and the work salary at the standard age of the current qualification is stored in the register xs (step S306). For example, when the current qualification is the lowest qualification, xs1 is stored in the register xs.

Further, the current position number and its professional salary are paired and stored in the hard disk 7 (step S307). For example, when the current qualification is the lowest qualification and the first storage is performed, data indicating the first rank of the lowest qualification and its professional salary x
s1 will be stored in the hard disk 7.

Then, "1" is added to the content of the variable register i (step S308), which is the maximum value im of the orders.
It is checked whether or not it has reached ax (step S309).
If the content of the variable register i is smaller than the maximum value imax, after adding sp, which is the work ability pitch, to the work ability xs stored in the register of the RAM 4 (step S310), the above step S307 is performed. Then, the above process is repeated.

In this way, the work salary is made to correspond to each first rank, and this value is stored in the hard disk 7 as a pair of the qualification name and the number of ranks.

Then, the content of the register i is the maximum value ima.
If x is reached, the loop of computations for that qualification ends.

Next, it is judged whether the qualification one level higher than the current qualification is the highest qualification (step S311), and if it is not the highest qualification, the current qualification is made one level higher. (Step S312), the process is repeated from step S303. For example, when the current qualification is the lowest qualification, the qualification R2 one level higher is stored in the current qualification register R.
Therefore, after that, when each parameter is read again in step S303, the register provided in the RAM 4 stores c
2, ws2, n2 will be stored.

In this way, the value for each rank in each qualification is obtained and stored in the hard disk 7, and step S3
When it is determined in 11 that the qualification one level higher than the current qualification is the highest qualification, sp is the professional salary pitch sp for the professional salary stored in the register xs of the RAM 4.
In addition, the work ability at the standard age of the highest qualification is calculated (step S313). Then, it is paired with the highest qualified name and stored in the hard disk 7 (step S314), and the process of generating this job performance table is completed.

By such generation processing, for example, as shown in FIG.
An age salary table and a job performance salary table are created as shown in (A) and (B).

As described above, in the salary calculation system, which has a wage system that determines the amount of salary to be paid based on the total of a plurality of salary items and is premised on determining each salary item by the "wage table", Individual wages can be set by setting general parameters such as standard age for each qualification, model wages as a guideline, and the composition ratio of each wage to model wages, without registering each individual value in the wages. Each value in the table is calculated automatically without human intervention,
Can be set.

That is, since the necessary pay scale can be generated by setting simple parameters, the optimum pay scale can be created by changing the set value as many times as necessary without worrying about rewriting. it can.

Since the created wage table is stored in the disk as data, it can be linked to an operation system such as a payroll calculation system.

In the above example, for convenience of explanation, the wage table is limited to two types and simplified, but in addition to this, a "qualification salary table" corresponding to qualifications and qualifications and evaluation points are also supported. Of course, it is possible to generate by the same mechanism even if a "grade evaluation table" is added.

Further, in the above embodiment, a plurality of pay scales are continuously generated, but it is also possible to generate only a specific pay scale designated by the operation of the input / display device 3. .

[0081]

According to the first and second aspects of the present invention, the necessary wage table is automatically generated based on the simple parameter setting. Therefore, even if there is no detailed knowledge, the wage table can be easily created. You will be able to create a pay scale.

[Brief description of drawings]

1A and 1B are an operation flowchart and a block configuration diagram of an embodiment, respectively.

FIGS. 2A and 2B are diagrams showing stored contents of a pay scale parameter memory, respectively.

FIG. 3 is a detailed flowchart of age pay table generation processing.

FIG. 4 is a detailed flowchart of job performance salary generation processing.

FIG. 5A is a diagram showing the relationship between the age and the amount of model wages, and FIG. 5B is a diagram showing the principle of age wage calculation.

FIG. 6 is a diagram showing the principle of job performance calculation.

7A and 7B are diagrams showing an age salary table and a job performance salary table, respectively.

FIG. 8 is a diagram showing a framework of a qualification system.

9A is a salary chart, FIG. 9B is an age salary table, and FIG. 9C is a job salary table.

[Explanation of symbols]

1 ... Computer system, 2 ... CPU, 3 ... Input / display device, 4 ... RAM, 5 ... Wage table preparation software memory, 6
… Wage table parameter memory, 7… Hard disk, 8…
Printer.

Claims (2)

[Claims] 1. A method of creating a wage table for each salary item in a salary system that determines the amount of salary to be paid based on the sum of wages in a plurality of salary items including age salary items and ability salary items. For each qualification, the standard age of the qualification, the standard wage of the qualification, and the composition ratio of each salary item to this standard wage are set arbitrarily, and the wage difference in the above age salary item between each qualification and its Age differences between qualifications and age-specific wages according to the qualifications are calculated, and age wages calculated for each age are associated with the corresponding individual ages to create an age wage table. However, based on the wage difference in the above-mentioned ability pay items between each qualification, the age difference between the qualifications and the number of peculiar increments of the ability pay item, the ability pay by each tick value of the above-mentioned ability pay items in the qualification. Wage Is calculated, the performance-wage calculated for each step value, to create a corresponding performance-pay tables associated with individual step value, as pay table creation method characterized in that the. 2. A method of creating a wage table in a salary system that determines the amount of salary to be paid based on the sum of wages in a plurality of salary items, the standard age of the qualifications and the standard of the qualifications for each qualification of a plurality of qualifications. Wages and the composition ratio of each salary item to this standard wage are arbitrarily set, one salary item among the plurality of salary items is specified, and the specified salary item From the wage difference in the salary item, the age difference between the qualifications and the predetermined number of steps, the wage at each step value of the above salary item in the qualification is calculated, and the wage at each calculated step value is A wage scale preparation method, characterized in that a wage scale corresponding to each of the above increments for a specified salary item is created.