Sales result management device, sales result management method, and sales result management program

Abstract

To provide a sales result management device and the like that can manage a sales result for each customer in a manner that distinguishes whether the sales result is made by a dedicated staff or not.SOLUTION: According to an embodiment, a sales result management device refers to a customer master that manages a staff for each customer, extracts a staff associated with a customer set on a sales input screen, determines whether or not the extracted staff matches the staff set on the sales input screen, and generates, if determining that there is a mismatch, sales data including the customer set on the sales input screen, the staff set on the sales input screen, a non-exclusive classification for identifying that the staff is a non-exclusive staff, a product set on the sales input screen, and a sales amount set on the sales input screen.SELECTED DRAWING: Figure 3

Description

[Technical field]

[0001] The present invention relates to a sales record management device, a sales record management method, and a sales record management program. [Background technology]

[0002] Patent Document 1 discloses a business performance management system that appropriately evaluates and manages business performance. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] JP 2011-100284 A Summary of the Invention [Problem to be solved by the invention]

[0004] In chemical trading companies, the basic rule is to assign a dedicated person to each customer because of the large volume of transactions and the large number of stakeholders (interested parties) involved in direct shipping. However, there are cases where sales to a customer are made by a different person other than the dedicated person. However, until now, the sales performance of the different person has not been managed, and the data on sales performance by customer for each dedicated person, which includes the sales performance of the different person as that of the dedicated person, was the subject of management's analysis. As a result, it was not possible to determine whether the sales performance was due to the dedicated person or a different person, and it was difficult to determine whether the sales performance of the different person would continue to be sales performance in the next fiscal year and beyond.

[0005] The present invention has been made in consideration of the above, and aims to provide a sales record management device, a sales record management method, and a sales record management program that can manage sales records for each customer in a manner that distinguishes whether or not they are made by a dedicated staff member. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the objective, the sales performance management device of the present invention is characterized by comprising an extraction unit that extracts a staff member linked to a customer set on a sales input screen by referring to a first master that manages staff members by customer, a judgment unit that determines whether the staff member extracted by the extraction unit matches or does not match the staff member set on the sales input screen, and, if the judgment unit determines that there is a mismatch, a sales data generation unit that generates sales data including the customer set on the sales input screen, the staff member set on the sales input screen, a non-exclusive classification for identifying that the staff member is not a dedicated staff member, the products set on the sales input screen, and the sales amount set on the sales input screen.

[0007] In addition, in the sales performance management device of the present invention, if the determination unit determines that there is a match, the sales data generation unit may generate sales data including the customer set on the sales input screen, the person in charge set on the sales input screen, an exclusive classification for identifying the person in charge as a dedicated person, the product set on the sales input screen, and the sales amount set on the sales input screen.

[0008] In addition, the sales performance management device of the present invention may further include an aggregation unit that aggregates sales amounts linked to non-exclusive categories and sales amounts linked to exclusive categories for each customer based on the sales data, an acquisition unit that acquires sales target amounts linked to each customer included in the sales data by referring to a second master that manages sales target amounts in association with customers, and a sales analysis data generation unit that generates sales analysis data including the sales amounts of the non-exclusive category and the sales amounts of the exclusive category aggregated by the aggregation unit, as well as the sales target amounts acquired by the acquisition unit, for each customer.

[0009] In addition, the sales performance management method of the present invention is characterized by including an extraction step in which an extraction unit refers to a first master that manages staff members by customer and extracts a staff member linked to the customer set on the sales input screen, a determination step in which a determination unit determines whether the staff member extracted in the extraction step matches or does not match the staff member set on the sales input screen, and a sales data generation step in which, if a mismatch is determined in the determination step, a sales data generation unit generates sales data including the customer set on the sales input screen, the staff member set on the sales input screen, a non-exclusive classification for identifying that the staff member is not a dedicated staff member, the products set on the sales input screen, and the sales amount set on the sales input screen.

[0010] In addition, the sales performance management program of the present invention causes an information processing device to function as an extraction means for extracting a staff member linked to a customer set on the sales input screen by referring to a first master that manages staff members by customer, a judgment means for determining whether the staff member extracted by the extraction means matches or does not match the staff member set on the sales input screen, and, if the judgment means determines that there is a mismatch, a sales data generation means for generating sales data including the customer set on the sales input screen, the staff member set on the sales input screen, a non-exclusive classification for identifying that the staff member is not a dedicated staff member, the products set on the sales input screen, and the sales amount set on the sales input screen. Effect of the Invention

[0011] The present invention has an effect of enabling management of sales results by customer in a manner that distinguishes whether or not the sales results were made by a dedicated person in charge. [Brief description of the drawings]

[0012] [Figure 1] FIG. 1 is a diagram showing an example of the configuration of a task support device according to the present embodiment. [Diagram 2] FIG. 2 is a diagram illustrating an example of various masters and various data. [Diagram 3] FIG. 3 is a diagram showing an example of a screen, an example of master data, and an example of data for explaining a specific example of processing in this embodiment. [Figure 4] FIG. 4 is a diagram showing an example of a screen, an example of master data, and an example of data for explaining a specific example of processing in this embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0013] Hereinafter, an embodiment of a sales record management device, a sales record management method, and a sales record management program according to the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to the embodiment.

[0014] [1. Configuration] An example of the configuration of a business support device 100 according to this embodiment (including the sales performance management device of the present invention) will be described with reference to Fig. 1 etc. Fig. 1 is a block diagram showing an example of the configuration of the business support device 100.

[0015] The business support device 100 is constructed based on a commercially available desktop personal computer. The business support device 100 is not limited to being constructed based on a stationary information processing device such as a desktop personal computer, but may be constructed based on a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.

[0016] The business support device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the business support device 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0017] The communication interface unit 104 communicatively connects the task assistance device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the task assistance device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). The data stored in the memory unit 106 may be stored in the server 200, for example.

[0018] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0019] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used as the storage unit 106.

[0020] The memory unit 106 stores a customer master 106a (corresponding to the first master of the present invention), a business establishment master 106b, a department master 106c, a person in charge master 106d, a customer-specific target master 106e (corresponding to the second master of the present invention), sales data 106f (corresponding to the sales data of the present invention), and customer-specific performance table data 106g (corresponding to the sales analysis data of the present invention), etc.

[0021] An example of the various masters and the various data will be described below with reference to FIG.

[0022] The customer master 106a is for managing customers and staff members. The customer master 106a stores customer identification information (e.g., customer code, customer name, etc.) and staff member identification information (e.g., staff member code, staff member name, etc.). For a certain customer, a staff member managed in the customer master 106a is recognized as a dedicated staff member (normal staff member), and a staff member not managed in the customer master 106a is recognized as a spot staff member (temporary staff member).

[0023] The establishment master 106b is for managing establishments, and stores establishment identification information (for example, establishment code, establishment name, etc.), revision date, abolition date, etc.

[0024] The department master 106c is for managing departments, and stores department identification information (for example, department code, department name, etc.), revision date, establishment identification information, and abolition date, etc.

[0025] The person in charge master 106d is for managing the person in charge, and stores person in charge identification information, revision date, department identification information, and the like.

[0026] The customer-specific target master 106e is for managing sales targets. The customer-specific target master 106e stores business establishment identification information, department identification information, customer identification information, accounting year and month, sales targets, and the like.

[0027] The sales data 106f is for managing sales. The sales data 106f stores sales identification information (e.g., sales number, etc.), line number, sales category, business establishment identification information, sales date, person in charge identification information, person in charge category for distinguishing between dedicated person in charge and spot person in charge (e.g., category code, etc.), customer identification information, delivery destination identification information (e.g., delivery destination code, etc.), supplier identification information (e.g., supplier code, etc.), product identification information (e.g., product code, product name, etc.), quantity, sales price, sales amount, etc.

[0028] The customer performance data 106g is for managing the sales performance table. The customer performance data 106g stores business establishment identification information, department identification information, customer identification information, accounting year / month, sales target, person in charge identification information, sales performance, and person in charge category, etc. The sales performance is the sales amount calculated based on the sales data 106f for the same business establishment code, department code, customer code, accounting year / month, and person in charge category.

[0029] 1, the control unit 102 is a CPU or the like that performs overall control of the business support device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, and the like, and executes various information processing based on these stored programs.

[0030] In terms of functional concept, the control unit 102 comprises a sales input unit 102a (including the extraction unit, judgment unit, and sales data generation unit of the present invention) and a customer performance table data output unit 102b (including the aggregation unit, acquisition unit, and sales analysis data generation unit of the present invention).

[0031] The sales input unit 102a stores various information set on the sales input screen MA as records in the sales data 106f (see FIG. 3). In particular, the sales input unit 102a refers to the customer master 106a, extracts a staff member code linked to the customer code set in the input area MA5, and determines whether the extracted staff member code matches or does not match the staff member code set in the input area MA6. If it determines that there is a mismatch, it stores "1" as the value of the "spot staff member classification," and if it determines that there is a match, it stores "0" as the value of the "spot staff member classification." The value "1" means that the staff member is a spot staff member, and the value "0" means that the staff member is a dedicated staff member.

[0032] The customer-specific performance table data output unit 102b uses the "office CD, department CD, customer CD, accounting year and month" set in the customer-specific target master 106e as key information to match the customer-specific target master 106e with the sales data 106f to tally up sales amounts for each "spot staff category," creates a customer-specific performance table including the tallying results, and outputs the created customer-specific performance table to the customer-specific performance table display screen MB (see FIG. 4). After that, when the operator or the like presses the register button MB2, the information in the output customer-specific performance table is stored as a record in the customer-specific performance table data 106g. The key matching of the accounting year and month may be performed using the year, month, and date (YYYY / MM / DD).

[0033] [2. Specific examples of processing] A specific example of the process executed by the business support device 100 configured as described above will be described in detail with reference to Fig. 3 and Fig. 4. Note that the sales input screen MA and the customer performance table display screen MB are only a part of each screen.

[0034] First, a specific example of the process executed by the sales input unit 102a will be described with reference to FIG.

[0035] The operator or the like sets the following data in each area of ​​the sales input screen MA displayed in advance on the monitor 114, and issues an instruction for registration. Area MA2: Business establishment code "J1010" Area MA3: Sales date "2021 / 4 / 10" Area MA4: Purchase date "2021 / 4 / 09" Area MA5: Customer code "T002" Area MA6: Personnel code "TA003" Area MA7: Delivery code “NOU01” Area MA8: Supplier code "SR001" Area containing row number "1" in area MA9: Order type "Direct delivery order", quantity "2", product "SH01 (Ammonia)" and unit price "1,300" Area containing row number "2" in area MA9: Order type "Direct order", quantity "1", product "SH02 (nitric acid)", and unit price "350"

[0036] Then, the sales input unit 102a stores the information set in the sales input screen MA in the sales data 106f, dividing it into two records as shown in FIG. 3. In particular, the sales input unit 102a stores the amount obtained by multiplying the sales unit price by the quantity as the sales amount. The sales input unit 102a also refers to the customer master 106a, extracts a person in charge linked to the set customer code "T002", and judges whether the extracted person in charge matches or does not match the set person in charge code "TA003". If it judges that there is a match, it stores "0 (normal person in charge)" as the value of the "spot person in charge classification", and if it judges that there is a mismatch, it stores "1 (spot person in charge)" as the value of the "spot person in charge classification". In this description, since the extracted person in charge is "TA002", it is judged that there is a mismatch, and therefore "1 (spot person in charge)" is stored as the value of the "spot person in charge classification". If a match is found, "0 (regular staff member)" is stored as the value of the "spot staff member category," as shown in the record for sales number "U002" in the sales data 106f shown in FIG.

[0037] Next, a specific example of the process executed by the customer performance table data output unit 102b will be described with reference to FIG.

[0038] First, the customer-specific performance table data output unit 102b compares the customer-specific target master 106e with the sales data 106f using the "business establishment CD, department CD, customer CD, accounting year and month" set in the customer-specific target master 106e as key information, calculates sales amounts for each "spot staff category," creates a customer-specific performance table including the calculation results, and outputs the created customer-specific performance table to area MB1 of the customer-specific performance table display screen MB. Regarding the matching and aggregation process, for example, if we focus on the record in the second row from the top included in the customer-specific target master 106e (business establishment code "J1010", department code "B0102", customer code "T002", fiscal year and month "2021 / 4", and sales target "6,750"), the three sales records from the second to fourth rows from the top included in the sales data 106f (see the thick frame in Figure 4) will be matched, and the sales amount for the "spot staff classification" value "0 (regular staff)" will be aggregated as "2,000" based on the sales record in the second row, and the sales amount for the "spot staff classification" value "1 (spot staff)" will be aggregated as "5,950" based on the sales records in the third and fourth rows.

[0039] Next, the operator or the like presses the registration button MB2 on the customer-specific performance table display screen MB.

[0040] Then, the customer-specific performance table data output unit 102b stores the information of the customer-specific performance table displayed on the customer-specific performance table display screen MB in the customer-specific performance table data 106g as shown in FIG.

[0041] As described above, according to this embodiment, by creating sales data separately for regular staff and spot staff, it is possible to create the customer-specific performance table data 106g separately for regular staff and spot staff. And, by using the customer-specific performance table data 106g created separately for regular staff and spot staff, the field organization head and department head can easily check the sales performance of the spot staff and can check whether the sales performance can be recorded from the mid- to long-term perspective. That is, by implementing a function to determine whether "sales recorded by spot staff" is recorded in the sales performance table by customer by staff, it becomes a judgment material that can be used when making mid- to long-term sales forecasts. Furthermore, it can also be used to judge the transfer of staff and the change of customer staff at the time of the next organizational change.

[0042] For example, in chemical trading companies, due to the nature of the large number of products handled, each person in charge often handles different products. For example, as shown in the second and third records from the top of the customer performance table data 106g in Figure 4, the sales performance of the dedicated person in charge is 2,000 yen, while the sales performance of the spot person in charge is 5,950 yen, so it can be confirmed that the performance of the spot person in charge is higher, but this result suggests that the products that are popular with customers are changing. Therefore, the customer performance table can be used to find products that are expected to be in demand for customers who handle the same main trading products, and can also be used as a basis for deciding whether to change the person in charge for customers who handle the same main trading products.

[0043] [3. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to goals 8 and 9 of the SDGs.

[0044] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0045] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

[0046] [4. Other embodiments] The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0047] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

[0048] In addition, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.

[0049] Moreover, with regard to the task support device 100, each of the components shown in the figures is a functional concept, and does not necessarily have to be physically configured as shown in the figures.

[0050] For example, the processing functions of the business support device 100, particularly the processing functions performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium including programmed instructions for causing the information processing device to execute the processes described in the present embodiment, and is mechanically read by the business support device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form a control unit.

[0051] In addition, this computer program may be stored in an application program server connected to the task support device 100 via any network, and it is also possible to download all or a part of it as necessary.

[0052] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.

[0053] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, may use well-known configurations and procedures.

[0054] The various databases etc. stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files etc. used for various processes and providing websites.

[0055] The business support device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as the information processing device to which any peripheral device is connected. The business support device 100 may be realized by installing software (including programs or data) that causes the device to realize the processing described in this embodiment.

[0056] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]

[0057] The present invention is useful in industries where dedicated personnel deal with clients, including chemical trading companies. [Explanation of symbols]

[0058] 100 Business support equipment 102 Control section 102a Sales input section 102b Customer performance table data output section 104 Communication interface section 106 Storage section 106a Customer Master 106b Business establishment master 106c Department Master 106d Personnel Master 106e Customer-specific target master 106f Sales Data 106g Customer performance data 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

1. an extraction unit that refers to a first master that manages the person in charge by customer and extracts the person in charge associated with the customer set in the sales input screen; a determination unit that determines whether the person in charge extracted by the extraction unit matches or does not match the person in charge set on the sales input screen; a sales data generation unit which generates sales data including, when the determination unit determines that there is a mismatch, the customer set on the sales input screen, the person in charge set on the sales input screen, a non-exclusive classification for identifying that the person is not an exclusive person in charge, the product set on the sales input screen, and the sales amount set on the sales input screen; A sales performance management device comprising:

2. when the determination unit determines that there is a match, the sales data generation unit generates sales data including the customer set on the sales input screen, the person in charge set on the sales input screen, an exclusive classification for identifying the person in charge as an exclusive person in charge, the product set on the sales input screen, and the sales amount set on the sales input screen; 2. The sales performance management device according to claim 1,

3. a counting unit that counts the sales amount associated with the non-exclusive category and the sales amount associated with the exclusive category for each customer based on the sales data; an acquisition unit that acquires a sales target amount associated with each customer included in the sales data by referring to a second master that manages sales target amounts in association with the customers; a sales analysis data generating unit that generates sales analysis data including the sales amounts of the non-exclusive category and the sales amounts of the exclusive category aggregated by the aggregation unit and the sales target amounts acquired by the acquisition unit, for each customer; The sales performance management device according to claim 2, further comprising:

4. An extraction step in which an extraction unit refers to a first master that manages the person in charge by customer and extracts a person in charge associated with the customer set in the sales input screen; a determination step in which a determination unit determines whether the person in charge extracted in the extraction step matches or does not match the person in charge set on the sales input screen; a sales data generation step in which, if a mismatch is determined in the determination step, the sales data generation unit generates sales data including the customer set on the sales input screen, the person in charge set on the sales input screen, a non-exclusive classification for identifying that the person is not a dedicated person in charge, the product set on the sales input screen, and the sales amount set on the sales input screen; A sales performance management method comprising:

5. An information processing device, An extraction means for extracting a person in charge associated with a customer set in the sales input screen by referring to a first master that manages a person in charge by customer; a determination means for determining whether the person in charge extracted by the extraction means matches or does not match the person in charge set on the sales input screen; a sales data generating means for generating sales data including, when the determining means determines that there is a mismatch, the customer set on the sales input screen, the person in charge set on the sales input screen, a non-exclusive classification for identifying that the person in charge is not an exclusive person in charge, the product set on the sales input screen, and the sales amount set on the sales input screen; A sales performance management program to function as a.

Images