JP3410939B2 - Commission management system and recording medium storing a program for causing a computer to perform processing in the system - Google Patents

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a commission management system for calculating a commission to be paid to an employee who receives a salary according to a commission system, and more specifically,
The present invention relates to a commission management system capable of obtaining an appropriate commission for the performance record of services (services) and the sales record of products.

[0002]

2. Description of the Related Art For example, in the so-called aesthetics industry, for example, a salary payment system based on a commission is often adopted. In this case, daily employee product sales status and services (face, hair loss, slimming, etc.) For example, the commission rate according to the implementation status is calculated on a monthly basis and added to the basic salary.

[0003]

However, in the conventional method of calculating the commission, since the accounting staff mainly manually calculates the commission of each employee, each sales item (including goods and services) is sold. The reality is that it is not possible to manage the commission rate finely for each service and each service. Therefore, a first object of the present invention is to provide a commission management system capable of appropriately managing commission according to the sales record of each sale item and the execution record of each service.

A second object of the present invention is to provide a recording medium storing a program for causing a computer to perform the processing in the above system.

[0005]

In order to solve the above-mentioned first problem, the commission management system according to the present invention is set forth in claim 1.
As described in, the first management means for managing the basic amount of sales commission, which is the basis of the commission calculation for each sale item, and the implementation of the commission calculation for the performance of each service. A second management means for managing the basic amount of commission, a third management means for managing the commission rate according to the sales amount rank, at least for each employee or department, and for each sale item based on the sales record of the sale item. Commission
Sales items that are judged to be eligible and are judged to be commissioned
About the sales record of the sale item, the basic amount of sales commission of the sale item managed by the first managing means, and the first commission for calculating the first commission rate related to the sales record based on the commission. A second calculation for calculating the second commission salary related to the performance record based on the salary calculation means, the performance record of the service, the basic amount of the commission to carry out the service managed by the second management means, and the commission. Commission calculation means, and the first
The first commission calculated by the commission calculation means, the second step
The second commission calculated by the salary calculating means, and the third
Based on the commission rate managed by
Also a commission calculation method that calculates the commission for each employee or department
And with.

In such a commission management system, the sales commission basic amount which is the basis of the commission calculation for the sale of each sale item and the commission commission which is the basis of the commission calculation for the execution of the service for each service. The amount of money and is managed. Then, the sales record of the sale item, the basic amount of sales commission managed corresponding to the sale item, and the first commission rate calculated based on the commission, the performance record of the service, and the management result corresponding to the service. There are obtained two types of commission salary, which are the second commission salary calculated on the basis of the implemented commission basic amount and the commission .

[0007] The above-mentioned items for sale include merchandise, and when the service is sold, the service is also included in the item for sale. A service is a service provided to a customer. Furthermore, from the viewpoint that the commission relating to the sales record can be managed for each employee or department , the present invention provides the system as described in claim 2, wherein the first commission calculating means is: The amount of commission paid for each employee or department is the sales performance of the item for sale for that employee or department ,
The basic amount of sales commission of the sale item and the employee or
Calculated based on the commission for each department, and the second commission
The calculation method is based on the amount of commission payment for each employee or department.
Performance of service by employee or department, actual performance of the service
The basic amount of commission and the percentage of each employee or department
It can be configured to calculate based on .

In such a commission management system, the first commission associated with the sales record and the second commission associated with the implementation record are calculated using the commission determined for each employee or department. In other words, to what can be described as managing the commission about the employee individual, also, each individual belongs to the group (department, division) but it may also be one to manage the commission for each.

In order to solve the above-mentioned second problem, according to the present invention, as described in claim 3, the first aspect manages the sales commission basic amount which is the basis of the commission calculation for the sale for each sale item. Management table means, a second management table means for managing the basic amount of the earned commission, which is the basis of the commission calculation for the performance of each service , and at least the employee
Commission according to rank of sales amount for each employee or department
A recording medium that stores a program for causing a computer to perform processing in a commission management system that calculates a commission using a third management unit that manages a rate , and sells an item for sale. Steps for each sales item based on actual results
Sales that determine whether it is a target for salary
About the item, the sales record of the item, the first pipe above
Sales rate of the sale item managed by the management table means
Based on the basic amount and the commission concerned
The first commission calculation step to calculate the commission of the
The actual results of implementation of the
Based on the basic amount of commission and the commission
Second commission to calculate the second commission based on the actual performance
The pay calculation step and the first commission calculation means
The first commission, calculated by the second commission calculation means
Managed by the second commission and the third management means
At least by employee or department based on the commission rate
And a program for calculating a commission .

[0010]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of the present invention will be described below with reference to the drawings. FIG. 1 shows a hardware configuration example of a computer system in which a commission management system according to an embodiment of the present invention is realized. This commission management system manages commissions for employees of an esthetic salon, for example.

In FIG. 1, this system includes a CPU (Central Processing Unit) 10 for controlling the entire system,
It has a memory unit 11, a display unit 12, an input unit 13, a disk unit 14 and a CD-ROM drive unit 15. These respective units are connected to each other by a bus. The memory unit 11 is
It has a ROM (Read Only Memory) and a RAM (Random Access Memory), and stores programs executed by the CPU 10, necessary data obtained in the course of processing by the CPU 10, and the like. The display unit 12 displays an input screen for inputting various data based on a command from the CPU 10. The input unit 13 includes a keyboard, a mouse, etc., and is used for products (cosmetics, etc.)
It is used for inputting information on sales performance of services such as hair removal and slimming, information on the implementation status of services, and further setting information necessary for calculating a commission. The disk unit 14 stores programs that can be executed in the system, and also stores various files and tables described below.

A program for processing relating to commission management is provided to the computer system by, for example, the CD-ROM 100. That is, with the CD-ROM 100 storing the program of the process related to the calculation of commission, set in the CD-ROM drive unit 15, the CD-ROM 1
The processing program related to the calculation of the commission, which is read from 00, is installed in the disk unit 14. Then, when the system is started up, a program for processing related to the calculation of the commission is read from the disk unit 14 and set in the memory unit 11. In this state, the CPU 10 executes processing related to calculation of commission in accordance with the program in the memory unit 11.

The operation of this commission management system is performed, for example, according to the procedure shown in FIG. First, information on each product (cosmetics, etc.) and each service handled in the esthetic salon (product name (product name, service course name), unit price, amount to be commissioned, etc.) is registered in the system (S1). Set the condition of the commission (by department, individual, amount rank, period, etc.) and commission (rate) (S
2). Then, the information described in the purchase slip of the product created by the employee every day is input (S3), and the information described in the daily service report is input (S4). Based on the information registered in the above quotient master, the condition of commission, the commission (rate), the purchase slip and the information (service implementation record) described in the daily service report, the commission calculation has a predetermined cycle (for example, every month). (S5).

In the system operated as described above, various information is registered and set as follows. Information on each product and each service handled in the esthetic salon is registered on an input screen (product master registration screen) as shown in FIG. 3, for example. That is, product, product code that identifies service, product name (product, service), supplier, unit price, cost, content of service (course unit, number of courses, time), commission sales amount (sales that are subject to commission calculation) The unit price amount) and the service execution unit price (commission unit price related to the service execution) are registered on the product master registration screen using the input unit 13.

The information about the employee who is the target of the commission addition, the payment method, etc. is set on an input screen (commission target setting screen) as shown in FIG. 4, for example. That is, according to the classification of members (continuation classification: "new" member, "continuation" member, "carry forward" member), the classification of employees (introducer, person in charge, counselor) and commission calculation target The payment category (cash, credit, ticket) by the target member and the action of the employee who is the target of the commission calculation (employee A, part-time job C) are set on the commission target setting screen using the input unit 13. Will be performed. In the case of this example, for new members, the introducer, the person in charge, for continuing members, the counselor so far is the target of commission calculation, the service paid in cash and credit, Implementation and sale of merchandise are subject to commission calculation. Further, the employee A's product sales act and the service execution act are the targets of the commission calculation, and the part-time job C's service execution action is the target of the commission calculation.

Information regarding the rate (rate), condition, etc. for each department for which the commission is calculated is set on, for example, an input screen (compartment-based commission setting screen) as shown in FIG. That is, for each department, the setting of the commission (rate) corresponding to the rank (lower limit value, upper limit value) of the sales amount and the applicable period (period start date, period end date) is set by using the input unit 13. This is done on the setting screen.

The setting of the yield (rate), condition, etc. for each employee who is the target of the commission calculation is performed on an input screen (personal commission setting screen) as shown in FIG. 6, for example. That is, for each employee, the setting of the commission (rate) corresponding to the rank (lower limit value, upper limit value) of the sales amount and the applicable period (period start date, period end date) is set by using the input unit 13. It is performed on another commission setting screen.

The information registered and set as described above is stored in the disk unit 14 as files and tables as shown in FIGS. 7 to 12, for example. Figure 7
Shows a commission table for each department. In this table, information (proportion (rate) and application period for each price rank of each department) set on the department-specific commission setting screen (see FIG. 5) is described. FIG. 8 shows a personalized commission table. In this table, the information (proportion (rate) for each amount rank of each employee, applicable period) set on the personalized commission setting screen (see FIG. 6) is described. FIG. 9 shows a continuation classification table. This table has a commission setting screen (see FIG. 4).
The suitability of the target of the commission calculation for each continuation section set in (3) is described (Y: target, N: non-target). Figure 10
Indicates a payment classification table. In this table, the suitability of the target of the commission calculation for the payment category set on the commission target setting screen (see FIG. 4) is described (Y: target,
N: non-target).

FIG. 11 shows an employee master file. In this employee master file, the department to which each employee (employee, part-time job, etc.) belongs, the adequacy of the target of commission calculation for product sales (target of commission sales), and the target of commission calculation for service execution (target of commission execution) Information about the suitability of is described. The information on the suitability of the commission sale target and the commission execution target is based on the information of the commission target person set on the commission target setting screen (see FIG. 4).

FIG. 12 shows a product master file. In this product master file, the unit price of each product and service, product cost, the number of service executions, the amount to be calculated for the commission of each product and service (product alloy amount), and the basic unit price of the commission related to each service (once or once The commission paid: the amount of service commission alloy paid by the performance of the service of time) is described. The information described in this product master file is the product master registration screen (see FIG. 3).
It is based on the information registered in (Reference).

In daily business, a purchase slip is created and information is input to the system each time a product is sold, a new service is contracted, or a contract is continued (see S3 in FIG. 2). The information of the purchase slip thus input is stored in the disk unit 14 as a purchase slip file as shown in FIGS. 13 (a), 13 (b) and 13 (c), for example.
That is, the purchase slip, the application member, the introducer, the person in charge, and the counselor are described in the purchase slip for each purchase application (FIG. 13A). As for the product, the product code, the quantity, the continuation category (see FIG. 4) and the information regarding the payment category (FIG. 13B) are input for each purchase application. As for the service, the service code, the number or time of the service, information on the continuation category and the payment category (FIG. 13C) are input for each purchase application.

Each time a service is performed, a daily service report is created and the information described in the daily service report is input to the system (see S4 in FIG. 2). The information of the daily service report input in this way is stored in the disk unit 14 as a daily service report file as shown in FIG. 14, for example. That is, the service code, the date of execution, the person in charge of execution, the number of times of execution, and the time of execution are input for the application (application number) for each service.

Using the files and tables created as described above, the system (CPU 10) executes processing related to commission calculation according to the procedure shown in FIGS. 15 and 16, for example (see FIG. 2). Corresponding to S5 in operation). First, the commission calculation for the sales record of products and services for each employee is performed according to the procedure shown in FIG. In FIG. 15, whether or not the employee is the target person of the commission calculation based on the sales record is an employee master file (see FIG. 11).
It is determined by checking the item "commission sales target" (S11). When it is determined that the employee (employee) is the target person of the commission calculation based on the sales record, the purchase slip file (see FIG. 13A) is searched, and the employee is referred to as an introducer, a person in charge, or a person in charge. Obtain the application number of the purchase application that is the counselor (S12). For example, employee A (J
In the case of 006), the application number “0001” is obtained.

The purchase slip file (see FIGS. 13 (b) and 13 (c): table relating to purchased product service) is searched by using the thus obtained application number as a key, and the corresponding product code and service code are obtained. Yes (S13). Application number "0
In the case of "001", product codes "0001" and "000"
2 "and the service code" 2001 "are obtained. Then
It is determined whether or not the obtained product or service is a product or service targeted for commissioning (S14). That is, referring to the purchase slip file (see FIGS. 13B and 13C), the continuation classification and the payment classification of the product (service) are acquired, and the continuation classification table (see FIG. 9) and the payment classification are acquired. Table (Fig. 10
It is determined whether or not the product (service) in the continuation category and the payment category obtained from the reference) is the target of the commission calculation. For example, as described above, product codes “0001” and “00”
02 ”and the service code“ 2001 ”are obtained, the product code“ 0002 ”is excluded from the target of the commission calculation because the payment classification is“ S03 (ticket) ”(see FIG. 10). The code “0001” and the service code “2001” are targets for the commission calculation.

When the product (product code) and service (service code) which are the objects of commission calculation are determined as described above,
The product master file (see FIG. 12) is searched to obtain the unit price (product alloy amount) that is the target of the commission calculation of the corresponding product and service, and the cumulative total is calculated according to (product alloy amount) × quantity. . For example, items in the case of "0001", as of 2500 yen × 1 = 2500 yen, also, services "2001" case of 4000 yen × 25 = 10000 of the amounts each of which is made the subject of commissions calculated as 0 yen The cumulative total is calculated.

As described above, the cumulative calculation of the amount of money for the commission calculation is executed for all the commodities (services) sold by the employee described in the purchase slip file (S16, S17). As described above, when the cumulative calculation of the amount of money for which the commission is calculated for all the products (services) sold by the employee, the department-specific commission table (see FIG. 7) and the personal-specific commission table (FIG. 8). The commission (rate) of the employee is acquired by referring to (reference). And
A commission payment amount is calculated based on the acquired commission (rate) and the accumulated amount (S18). When the commission (rate) for the employee is set in the individual commission table, the commission (rate) is used, and when the commission (rate) is not set in the individual commission table, The commission (rate) set in the commission table for each department is used for the department to which the employee belongs.

[0027] For example, for products where the employee A (J006) has sold "0001" and services "2001", according to the sales (2500 yen +10000 0 yen) × 5% = 5125 yen the product (service) commission It is calculated as the amount paid. The commission calculation for the performance record of the service to each employee is performed according to the procedure shown in FIG. In FIG. 16, an employee master file (see FIG. 11) is used to determine whether the employee is the target person for the commission calculation based on the performance of the service.
It is determined by checking the item "commission target" in step S21. If it is determined that the employee (employee) is the target of the commission calculation based on the performance of the service,
The daily service report table (see Fig. 14) is searched, and the service (service code) that the employee was in charge of implementing in the relevant month.
Is acquired and the number of times (time) is totaled (S2
2). For example, in the example of the daily service table shown in FIG. 14, for example, the service (service code) and the number of times (time) that the employee A was in charge of performing in June are: service 2001 ... 3 times service 2003 ... 1 Counted like time.

Next, with reference to the product master file (see FIG. 12), the basic unit rate of commission (payment is provided once or for a unit time for the execution of the service (service code) acquired as described above. The commission) is obtained from the item “service fee alloy amount” (S23). In the example of the employee A described above, the basic unit rate of the services 2001 and 2003 is obtained as services 2001 ... 150 yen Services 2003 ... 300 yen.

Then, using the number of times (hours) each service is performed and the basic unit price of the commission obtained as described above, the commission payment to be paid for the performance of each service is calculated. It In the example of the employee A, the service 2001 ... 150 yen × 3 (times) = 450 yen, the service 2003 ... 300 yen × 1 (time) = 300 yen, the total is calculated as 750 yen.

The above-mentioned processing is performed by the daily service report file (see FIG. 1).
This is performed for all the implementation services of the employee in the month described in 4) (S25), and the total is the commission for performing the services of the employee in the month. And further,
The commission for product sales and the commission for performing the service calculated by the procedure shown in FIG. 15 are summed up to obtain the total amount of commission payment for the employee in the month.

In the commission management system as described above, various files and tables shown in FIGS. 7 to 14 (compartment ratio table, individual ratio table, continuation classification table, payment classification table, employee master file, product master). File, purchase slip file, daily service report file) are used to calculate the commission rate for each employee's monthly sales performance and the commission rate for service performance results separately, so more detailed management of individual commission rates Is possible. In addition, by changing the contents of the department-specific commission table, individual commission table, continuation classification table, supply classification table, employee master file, and product master file, the commission compensation that suits the actual situation of each company to which the system is applied Can be managed.

In the above-mentioned system, the product master file (FIG. 12) corresponds to the first management means, and the item "commodity coupon amount" in the product master file corresponds to the sales commission basic amount. This product master file also corresponds to the second management means, and the item "service step alloy amount" of the product master file corresponds to the basic rate of execution commission.

The process of the procedure shown in FIG. 15 corresponds to the first commission calculating means, and the process of the procedure shown in FIG. 16 corresponds to the second commission calculating means. Further, the department-based commission management table (see FIG. 5) and the individual commission management table (FIG. 6) correspond to the employee commission management means.

[0034]

As described above, according to claims 1 to
According to the present invention described in No. 3, the sales record of the sales item, the basic sales commission amount and the step amount managed corresponding to the sales item.
First commissions which is calculated on the basis of the case, and exemplary performance of services, implementation percentage basis the money amount managed in correspondence with the service
Also , two types of commissions, the second commission calculated based on the commission, are obtained, and it is possible to appropriately manage the commission according to the sales record of each sale item and the execution record of each service. A commission management system can be provided.

According to the present invention as set forth in claim 3, it is possible to provide a recording medium storing a program for causing a computer to perform the processing in the commission management system.

[Brief description of drawings]

FIG. 1 is a block diagram showing a hardware configuration example of a computer system in which a commission management system according to an embodiment of the present invention is realized.

FIG. 2 is a flowchart showing a procedure for operating a commission management system.

FIG. 3 is a diagram showing a configuration example of a product master registration screen.

FIG. 4 is a diagram showing a configuration example of a commission target setting screen.

FIG. 5 is a diagram showing a configuration example of a department commission setting screen.

FIG. 6 is a diagram showing a configuration example of a personalized commission setting screen.

FIG. 7 is a diagram showing a configuration example of a department-based commission table.

FIG. 8 is a diagram showing a configuration example of a personalized commission table.

FIG. 9 is a diagram showing a configuration example of a continuation classification table.

FIG. 10 is a diagram showing a configuration example of a payment classification table.

FIG. 11 is a diagram showing a configuration example of an employee master file.

FIG. 12 is a diagram showing a configuration example of a product master file.

FIG. 13 is a diagram showing a configuration example of a purchase slip file.

FIG. 14 is a diagram showing a configuration example of a daily service report file.

FIG. 15 is a flowchart showing a procedure for calculating a commission based on the sales record of products and services for each employee.

FIG. 16 is a flowchart showing a procedure for calculating a commission based on the performance record of the service to each employee.

[Explanation of symbols]

10 CPU 11 memory unit 12 Display unit 13 Input unit 14 disk units 15 CD-ROM drive unit 100 CD-ROM

─────────────────────────────────────────────────── ─── Continuation of the front page (72) Inventor Seishichiro Otani 1-12-11 Shimodori, Kumamoto-shi, Kumamoto Minouchi Co., Ltd. (72) Inventor Miya ▲ Saki ▼ Naoki 2081, Tahara, Mashiki-machi, Kamimashiki-gun, Kumamoto No. 27 in Fujitsu Minami Kyushu System Engineering Co., Ltd. (72) Inventor Hiroyuki Ogata No. 2081 Tahara, Mashiki-machi, Kamimashiki-gun, Kumamoto Prefecture No. 27 No. 27 in Fujitsu Minami-Kyushu System Engineering Co., Ltd. (56) Reference JP-A-61-286997 (JP, A) JP-A-8-129595 (JP, A) JP-A-5-120568 (JP, A) (58) Fields investigated (Int.Cl. ⁷ , DB name) G06F 17/60 160 G06F 17 / 60 124 JIST file (JOIS)

Claims (3)

(57) [Claims] 1.Sell the commission payable to employees
1st commission related to actual results and 2nd step related to actual results
A commission management system that manages according to the salary, It is the basis for the commission calculation for each sale item
The first management means for managing the basic amount of sales commission, It is the basis of the commission calculation for each service
A second management means for managing the basic rate of execution, At least by employee or department
Third management means for managing the commission rate according toTarget commission for each sale item based on the sales record of the sale item
To determine which sales items are eligible for commission.
And the relevant Sales record of sales items, as the first management method above
Managed by the
Calculate the first commission based on sales results based on the commission
A first commission calculation means, The performance record of the service, which is managed by the second management means above.
Based on the basic amount of commission to carry out the service and the commission
The second commission performance to calculate the second commission related to the actual performance
Arithmetic means, The first commission calculated by the first commission calculating means,
The second commission calculated by the second commission calculation means, and
And the commission rate managed by the third management means
And at least calculate commission for each employee or department
With the rate calculation means Commission management system with. 2. The commission management system according to claim 1, wherein the first commission calculation means calculates a commission payment amount for each employee or department, and a sales record of a sales item for each employee or department, Calculated based on the basic amount of sales commission of the item to be sold and the commission of each employee or department, and the second commission calculation means calculates the commission payment amount of each employee or department for each employee or department. Is a commission management system that is calculated based on the performance record of the service, the basic amount of the commission of the service, and the commission of the employee or department. 3. Claim-based salary calculation for each sale item
First management te to manage the sale Ayumu case basis amount of money to be the basis
Table means and commission rate meter for each service
The second management that manages the basic amount of the implementation rate that is the basis of calculation
Table means and at least by employee or department,
The third tube that manages the commission rate according to the sales amount rank
A commission to calculate the commission using
To let the computer perform the processing in the management system
It is a recording medium that stores the program and is subject to commission for each sale item based on the sales record of the sale item.
To determine which sales items are eligible for commission.
And the sales record of the item for sale, the first management table mentioned above.
Basic amount of sales commission of the sale item managed by
And the first commission based on sales results based on the commission
The first commission calculation step for calculating
Achievement, the role managed by the second management table means
Implementation of duties Performed based on the basic amount of commission and the relevant commission
A second commission calculation system that calculates the second commission for the actual results
And the first rate calculated by the first commission calculation means.
Commission, the second step calculated by the second commission calculation means
Ratio of commission and commission rate managed by the third management means
Based on at least a percentage by employee or department
Storing a program having a step of calculating a commission
Recording medium.