JP2022155456A - Customer sales information management device, customer sales information management method, and customer sales information management program - Google Patents

Abstract

To provide a customer sales information management device, a customer sales information management method, and a customer sales information management program capable of creating sales information for each person in charge of a maker by holding, managing, and utilizing information sold to an end user by a customer viewed from a manufacturer.SOLUTION: A customer sales information management device acquires customer report information that is set by associating a customer end user identifier, an article, and an amount of money delivered to the end user and acquires, based on an end user master, a client end user conversion master, and a retail unit price master, customer sales information in which a person in charge of a maker, an article, and retail price are set by data conversion processing relative to the customer report information.SELECTED DRAWING: Figure 2

Description

The present invention relates to a customer sales information management device, a customer sales information management method, and a customer sales information management program.

In Patent Document 1, in the pharmaceutical industry, pharmaceutical manufacturers can receive wholesale sales data that includes sales dates from wholesalers to hospitals and pharmacies, product types, sales volumes, delivery destinations, etc., and pharmaceutical sales trends, etc. is disclosed.

Japanese Patent Application Laid-Open No. 2004-206700

However, in the invention described in Patent Document 1, it is not possible to create sales information for each manufacturer's person in charge by retaining, managing, and utilizing information sold by wholesalers to hospitals and pharmacies that are delivery destinations. There was a problem.

The present invention has been made in view of the above problems, and the sales information for each person in charge of the manufacturer is created by retaining, managing, and utilizing information on sales to the end user by the customer from the manufacturer's point of view. It is an object of the present invention to provide a customer sales information management device, a customer sales information management method, and a customer sales information management program that can

In order to solve the above-described problems and achieve the object, a customer sales information management device according to the present invention is a customer sales information management device comprising a storage unit and a control unit, wherein the storage unit comprises: A manufacturer's person in charge and an end-user master that is set by linking the end-user who is the customer's delivery destination of the manufacturer, the customer's end-user identifier that links the customer and the end-user, the customer, and a customer end-user conversion master in which the end user is linked and set, and a retail unit price master in which the product and the retail unit price are linked and set. , the customer report acquisition means for acquiring customer report information set by linking the product and the delivery amount to the end user, the end user master, the customer end user conversion master, and the retail unit price master data conversion means for acquiring customer sales information including the person in charge of the manufacturer, the product, and the retail price by data conversion processing for the customer report information based on do.

Further, in the customer sales information management device according to the present invention, the control unit is configured to: It is characterized by further comprising analysis acquisition means for acquiring analysis data for each product.

Further, in the customer sales information management device according to the present invention, the control unit stores products for each end user in which delivery quantities for each product from the customer to the end user are set based on the customer sales information. It is characterized by further comprising analysis acquisition means for acquiring another analysis data.

Further, in the customer sales information management device according to the present invention, the customer report information is further set in association with a delivery date, and the customer sales information is further set in association with a delivery date. , the control unit acquires demand analysis data obtained by comparing the delivery quantity of each product from the customer to the end user for each of the delivery dates and months based on the customer sales information; It is characterized by further comprising:

Further, in the customer sales information management device according to the present invention, the control unit controls the customer, the product, the sales volume of the product from the manufacturer to the customer, the sales unit price of the product, and the sales price of the product. sales acquisition means for acquiring sales information in which a cost unit price is set, wherein the data conversion means converts the sales information, the end-user master, the customer end-user conversion master, and the retail unit price master into The customer sales information in which the person in charge of the manufacturer, the product, the retail price, the customer's profit margin, and the manufacturer's gross profit are set is acquired by the data conversion processing for the customer report information.

Further, in the customer sales information management device according to the present invention, the control unit subtracts the customer profit margin from the manufacturer's gross profit for each customer and for each product based on the customer sales information. It is characterized by further comprising an analysis acquisition means for acquiring profit margin analysis data in which the difference is set.

In the customer sales information management device according to the present invention, the customer sales information further includes a sales amount obtained by multiplying the sales unit price by the sales quantity, and a sales amount obtained by multiplying the cost price unit by the sales quantity. A cost is set.

Further, in the customer sales information management device according to the present invention, the manufacturer's gross profit is the amount obtained by subtracting the cost price from the sales amount, and the customer profit margin is the amount obtained by subtracting the sales amount from the delivery amount. It is characterized by

Further, in the customer sales information management device according to the present invention, the retail unit price is a drug price.

Further, a customer sales information management method according to the present invention is a customer sales information management method to be executed by a customer sales information management device having a storage section and a control section, wherein the storage section comprises a manufacturer's and the end-user master that is set by linking the person in charge of the manufacturer and the end-user who is the delivery destination of the customer of the manufacturer, the customer end-user identifier that links the customer and the end-user, the customer, and , a customer end-user conversion master set by linking the end user, and a retail unit price master set by linking the product and the retail unit price, and executed by the control unit. a customer report acquisition step for acquiring customer report information set by linking the identifier, the product, and the delivery amount to the end user; the end user master, the customer end user conversion master, and the retail unit price; and a data conversion step of acquiring customer sales information including the person in charge of the manufacturer, the product, and the retail price by data conversion processing for the customer report information based on the master data. do.

Further, a customer sales information management program according to the present invention is a customer sales information management program to be executed by a customer sales information management device having a storage section and a control section, wherein the storage section comprises a manufacturer's and the end-user master that is set by linking the person in charge of the manufacturer and the end-user who is the delivery destination of the customer of the manufacturer, the customer end-user identifier that links the customer and the end-user, the customer, and , a customer end-user conversion master set in association with the end user, and a retail unit price master in which products and retail unit prices are associated with each other, and the control unit controls the customer end-user identifier, a customer report acquisition step for acquiring customer report information set by linking the product and the delivery amount to the end user; and a data conversion step of acquiring customer sales information including the person in charge of the manufacturer, the product, and the retail price by data conversion processing for the customer report information based on the data conversion process. .

ADVANTAGE OF THE INVENTION According to this invention, it is effective in the ability to give an appealing power to the industry which has commercial distribution through an agency. Moreover, according to the present invention, it is possible to efficiently conduct traceability, demand forecasting, understanding of profit margins of customers and the company, and discount negotiations. In addition, according to the present invention, since pharmaceutical manufacturers cannot directly conduct sales activities to hospitals, it is possible to acquire and analyze the necessary sales record information as a pharmaceutical manufacturer while observing this characteristic (regulations). Moreover, according to the present invention, it is possible to visualize the sales performance to the final delivery destination, which cannot be visualized originally, and to use it for the next product development and performance evaluation within the company. In addition, according to the present invention, by combining sales information to end users received from customers with information such as company sales information, wholesale unit price, MR in charge (Medical Representative), There is an effect that it is possible to ascertain the actual sales to end users for each MR in charge and product. Moreover, according to the present invention, there is an effect that it is possible to store and analyze customer sales information and final delivery destination information required by pharmaceutical manufacturers. In addition, according to the present invention, it is possible to determine sales performance of MR, traceability, demand analysis, profit margin confirmation to customers, and calculation of discount amount.

FIG. 1 is a diagram showing an example of a drug sales channel. FIG. 2 is a block diagram showing an example of the configuration of the customer sales information management device according to this embodiment. FIG. 3 is a diagram showing an end-user master in this embodiment. FIG. 4 is a diagram showing a customer end-user conversion master in this embodiment. FIG. 5 is a diagram showing a customer master in this embodiment. FIG. 6 is a diagram showing a product master in this embodiment. FIG. 7 is a diagram showing the sales unit price master in this embodiment. FIG. 8 is a diagram showing a retail unit price master in this embodiment. FIG. 9 is a flow chart showing an example of processing of the customer sales information management device in this embodiment. FIG. 10 is a diagram showing an example of customer sales information management processing in this embodiment. FIG. 11 is a diagram showing an example of customer sales information management processing in this embodiment. FIG. 12 is a diagram showing an example of analysis data in this embodiment. FIG. 13 is a diagram showing an example of analysis data in this embodiment. FIG. 14 is a diagram showing an example of analysis data in this embodiment. FIG. 15 is a diagram showing an example of analysis data in this embodiment.

An embodiment of the present invention will be described in detail based on the drawings. In addition, this invention is not limited by this embodiment.

[1. Overview]
First, the outline of the present invention will be described with reference to FIG. FIG. 1 is a diagram showing an example of a drug sales channel.

In the past, sales information for end users and sales information from the company to customers were managed separately. It was not possible to efficiently perform the analysis by linking the data, and it took time and effort.

Here, as shown in Fig. 1, in the sales of pharmaceuticals, pharmaceuticals are (1) delivered from the company, which is the manufacturer, to the customer, who is a pharmaceutical wholesaler, and (2) from the customer to the final delivery destination, which is a hospital or doctor. be delivered. Here, MRs, who are sales representatives of pharmaceutical manufacturers, only provide product information to final delivery destinations (hospitals, doctors, etc.), and sales activities are prohibited. However, the manufacturer needs the information shown in FIG. 1(2) because the extent to which the company's product is used by the final destination (hospital, doctor, etc.) determines the sales performance.

Therefore, in this embodiment, a master of customers, a master of end users, and a master of conversion between customers' business partners and end users are held, sales information of customers is held, and sales information of customers is stored. , the customer's sales destination information (end user information) is converted into company information, and the company's sales information and customer sales information are linked. For example, in this embodiment, a mechanism is provided in which the manufacturer holds the sales information shown in FIG. 1(2).

[2. Constitution]
An example of the configuration of the customer sales information management device 100 according to this embodiment will be described with reference to FIG. FIG. 2 is a block diagram showing an example of the configuration of the customer sales information management device 100 according to this embodiment.

As shown in FIG. 2, the customer sales information management device 100 is a commercially available desktop personal computer. The customer sales information management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a commercially available notebook personal computer, PDA (Personal Digital Assistant), smart phone, tablet personal computer, or the like. may be a portable information processing apparatus.

The customer sales information management device 100 includes a control section 102 , a communication interface section 104 , a storage section 106 and an input/output interface section 108 . Each part provided in the customer sales information management device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the customer sales information management 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 another device via a communication line. Here, the network 300 has a function of connecting the customer sales information management 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).

An input device 112 and an output device 114 are connected to the input/output interface section 108 . The output device 114 can be a monitor (including a touch panel), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that cooperates with the mouse to provide a pointing device function. Note that, hereinafter, the output device 114 may be referred to as the monitor 114 or the printer 114 and the input device 112 may be referred to as the keyboard 112 or the mouse 112 .

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for performing various processes by giving commands to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As 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. The storage unit 106 includes an end user master 106a, a customer end user conversion master 106b, a customer master 106c, a product master 106d, a sales unit price master 106e, and a retail unit price master 106f.

The end-user master 106a is a master in which the person in charge (MR) of the manufacturer and the end-user who is the delivery destination of the customer of the manufacturer are linked and set. Here, the end-user master 106a may be set with an end-user code, an end-user name, and a person-in-charge name associated with each other.

The end-user master 106a in this embodiment will now be described with reference to FIG. FIG. 3 is a diagram showing the end user master 106a in this embodiment.

As shown in FIG. 3, in the end-user master 106a in this embodiment, an end-user code, an end-user name, and the name of the MR in charge are linked and set.

Returning to FIG. 2, the customer end-user conversion master 106b is a master in which customers and end users are linked and set. Here, the customer end-user conversion master 106b may be set by linking the customer end-user identifier that links the customer and the end user, the customer, and the end user. Further, the customer end-user conversion master 106b may be set by linking the customer end-user code, the customer code, and the end-user code.

Here, the customer end-user conversion master 106b in this embodiment will be described with reference to FIG. FIG. 4 is a diagram showing the customer end-user conversion master 106b in this embodiment.

As shown in FIG. 4, in the customer end-user conversion master 106b in this embodiment, a customer code, a customer end-user code, and an end-user code are linked and set.

Returning to FIG. 2, the customer master 106c is a master in which customers are set. Here, in the customer master 106c, the customer code and the customer name may be linked and set.

Here, the customer master 106c in this embodiment will be described with reference to FIG. FIG. 5 is a diagram showing the customer master 106c in this embodiment.

As shown in FIG. 5, in the customer master 106c in this embodiment, customer codes and customer names are set in association with each other.

Returning to FIG. 2, the product master 106d is a master in which products are set. Here, in the product master 106d, product codes and product names may be set in association with each other.

Here, the product master 106d in this embodiment will be described with reference to FIG. FIG. 6 is a diagram showing the product master 106d in this embodiment.

As shown in FIG. 6, in the product master 106d in this embodiment, product codes and product names are set in association with each other.

Returning to FIG. 2, the sales unit price master 106e is a master in which products and sales unit prices are linked and set. Here, in the sales unit price master 106e, the product code and the sales unit price may be set in association with each other.

Here, the sales unit price master 106e in this embodiment will be described with reference to FIG. FIG. 7 is a diagram showing the sales unit price master 106e in this embodiment.

As shown in FIG. 7, in the sales unit price master 106e in this embodiment, the product code and the sales unit price are linked and set.

Returning to FIG. 2, the retail unit price master 106f is a master in which products and retail unit prices are linked and set. Here, the retail unit price may be a drug price. Also, the retail unit price master 106f may be set by linking the product code and the retail unit price.

Here, the retail unit price master 106f in this embodiment will be described with reference to FIG. FIG. 8 is a diagram showing the retail unit price master 106f in this embodiment.

As shown in FIG. 8, in the retail unit price master (pharmaceutical price master) 106f in this embodiment, product codes and drug prices are linked and set.

Returning to FIG. 2, the control unit 102 is a CPU or the like that controls the customer sales information management device 100 in an integrated manner. The control unit 102 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run. The control unit 102 functionally and conceptually includes a customer report acquisition unit 102a, a sales acquisition unit 102b, a data conversion unit 102c, and an analysis acquisition unit 102d.

The customer report acquisition unit 102a acquires customer report information regarding product delivery from the customer to the end user. Here, the customer report acquisition unit 102a may acquire customer report information set by linking the customer end user identifier, the product, and the amount of money delivered to the end user. Further, the customer report information may be set in association with the delivery date.

The sales acquisition unit 102b acquires product sales information from manufacturers to customers. Here, the sales acquisition unit 102b may acquire sales information in which the customer, the product, the sales volume of the product from the manufacturer to the customer, the sales unit price of the product, and the cost unit price of the product are set.

The data conversion unit 102c acquires customer sales information by performing data conversion processing on the customer report information. Here, based on the end-user master 106a, the customer end-user conversion master 106b, and the retail unit price master 106f, the data conversion unit 102c performs data conversion processing on the customer report information to convert the manufacturer's person in charge, product, and retail price. You may acquire the customer sales information which set the price. Further, the customer sales information may be set in association with the delivery date. In addition, the data conversion unit 102c performs data conversion processing on the customer report information based on the sales information, the end user master 106a, the customer end user conversion master 106b, and the retail unit price master 106f. You may acquire the customer sales information which set the price, the customer profit margin, and the manufacturer's gross profit. Further, the customer sales information may include a sales amount obtained by multiplying the sales unit price by the sales quantity, and a cost price obtained by multiplying the cost price by the sales quantity. Also, the manufacturer's gross profit may be an amount obtained by subtracting the cost price from the sales amount. Also, the customer profit margin may be the amount obtained by subtracting the sales amount from the delivery amount.

The analysis acquisition unit 102d acquires analysis data based on customer sales information. Here, based on the customer sales information, the analysis acquisition unit 102d may acquire analysis data by person in charge and by product, in which the quantity of products delivered to the end user by the person in charge of the manufacturer is set. Further, the analysis acquisition unit 102d may acquire end-user-by-product analysis data in which the delivery quantity of each product from the customer to the end-user is set based on the customer sales information. Further, the analysis acquisition unit 102d may acquire demand analysis data obtained by comparing the delivery quantity of each product from the customer to the end user for each delivery year and month based on the customer sales information. Further, the analysis acquisition unit 102d may acquire profit margin analysis data for each customer and for each product in which the difference obtained by subtracting the customer profit margin from the manufacturer's gross profit is set based on the customer sales information. Also, the analysis acquisition unit 102d may display the analysis data.

[3. Concrete example]
A specific example of this embodiment will be described with reference to FIGS. 9 to 15. FIG.

[Customer sales information management processing]
Here, an example of customer sales information management processing in this embodiment will be described with reference to FIG. FIG. 9 is a flow chart showing an example of processing of the customer sales information management device 100 in this embodiment.

As shown in FIG. 9, the customer report acquisition unit 102a acquires customer report information set by linking the customer end-user identifier, the delivery date, the product, and the delivery amount to the end user (step SA -1).

Then, based on the end-user master 106a, the customer end-user conversion master 106b, and the retail unit price master 106f, the data conversion unit 102c performs data conversion processing on the customer report information to convert the manufacturer's MR, delivery date, product, and Acquire customer sales information in which the retail price is set (step SA-2).

Based on the customer master 106c, the product master 106d, and the sales unit price master 106e, the sales acquisition unit 102b acquires the customer, the product, the sales quantity of the product from the manufacturer to the customer, the unit sales price of the product, and the cost of the product. Acquire sales information with a set unit price (step SA-3).

Then, the data conversion unit 102c sets and updates the customer profit margin and the manufacturer's gross profit in the customer sales information based on the sales information, the end user master 106a, the customer end user conversion master 106b, and the retail unit price master 106f. (Step SA-4).

Then, the analysis acquisition unit 102d acquires analysis data based on the customer sales information, the analysis data is displayed on the output device 114 (step SA-5), and the process ends.

Here, an example of customer sales information management processing according to the present embodiment will be described with reference to FIGS. 10 to 15. FIG. 10 to 11 are diagrams showing an example of customer sales information management processing in this embodiment. 12 to 15 are diagrams showing examples of analysis data in this embodiment.

As shown in FIG. 10, in this embodiment, based on the end-user master 106a, the customer end-user conversion master 106b, and the retail unit price master 106f, a transaction, which is a customer-to-customer-related transaction regarding product delivery from a customer to an end-user, is performed. Customer sales information is added by data conversion processing for report information.

As shown in FIG. 11, in this embodiment, based on the sales information from the company to the customer, the end user master 106a, the customer end user conversion master 106b, and the retail unit price master 106f, the customer sales information Sales unit price, sales amount, customer profit margin, cost price unit price, cost price, and manufacturer gross profit are given (additionally set). Here, "Sales amount" = "Sales unit price" x "Quantity", "Customer margin" = "Delivery amount" - "Sales amount", "Cost price" = "Cost unit price" x "Quantity", and "In-house Gross profit”=“sales amount”−“cost price” may be used.

In this embodiment, various data are extracted and analyzed from the accumulated results, and as shown in FIG. 12, analysis data for each person in charge and each product, which indicates the delivery quantity for each product for each MR, for each month and year, is acquired. , as shown in FIG. 13, end-user-by-product analysis data that enables grasping of delivery results by end-user for traceability is acquired, demand analysis data is acquired as shown in FIG. 14, and demand analysis data is acquired as shown in FIG. As shown, profit margin analysis data is obtained that enables the profit margin to be confirmed from the difference in transaction amount between the company and the customer, and between the customer and the end user.

[4. Contribution to the Sustainable Development Goals (SDGs) led by the United Nations]
Since this embodiment can contribute to improving operational efficiency and promoting appropriate management decisions of companies, it is possible to contribute to Goals 8 and 9 of the SDGs.

In addition, the present embodiment can contribute to the reduction of disposal loss and the promotion of paperless and computerization.

In addition, since this embodiment can contribute to strengthening control and governance, it is possible to contribute to Goal 16 of the SDGs.

[5. Other embodiments]
The present invention may be implemented in various different embodiments other than the embodiments described above within the scope of the technical idea described in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed can be manually performed, or all of the processes described as being manually performed Alternatively, some can be done automatically by known methods.

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

Further, regarding the customer sales information management device 100, each component shown in the figure is functionally conceptual, and does not necessarily need to be physically configured as shown in the figure.

For example, the processing functions of the customer sales information management device 100, particularly the processing functions performed by the control unit 102, are all or any part of the processing performed by the CPU and a program interpreted and executed by the CPU. It may be implemented as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing apparatus to execute the processing described in this embodiment, and is sold to customers as necessary. It is mechanically read by the information management device 100 . That is, a storage unit such as a ROM or HDD (Hard Disk Drive) stores a computer program for giving commands to the CPU in cooperation with the OS to perform various processes. This computer program is executed by being loaded into the RAM and constitutes a control section in cooperation with the CPU.

Also, this computer program may be stored in an application program server connected to the customer sales information management device 100 via any network, and may be downloaded in whole or in part as necessary. is also possible.

Also, the program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" refers to memory cards, USB (Universal Serial Bus) memories, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (registered (trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Disc (registered trademark) such as Blu- shall include any "portable physical medium".

A "program" is a data processing method written in any language or writing method, regardless of the format such as source code or binary code. In addition, the "program" is not necessarily limited to a single configuration, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the present embodiment, the installation procedure after reading, and the like.

The various databases and the like stored in the storage unit 106 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 are used for various processes and website provision. programs, tables, databases, and files for web pages.

Further, the customer sales information management device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which arbitrary peripheral devices are connected. . Further, the customer sales information management device 100 may be realized by installing software (including programs, data, etc.) for realizing the processing described in this embodiment.

Furthermore, the specific forms of distribution and integration of devices are not limited to those shown in the figures, and all or part of them can be functionally or physically arranged in arbitrary units according to various additions or functional loads. It can be distributed and integrated. In other words, the embodiments described above may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

INDUSTRIAL APPLICABILITY The present invention is useful in the pharmaceutical industry, the food industry, the manufacturing industry of miscellaneous goods, etc., and the wholesale industry having commercial distribution through agents.

100 Customer sales information management device 102 Control unit 102a Customer report acquisition unit 102b Sales acquisition unit 102c Data conversion unit 102d Analysis acquisition unit 104 Communication interface unit 106 Storage unit 106a End user master 106b Customer end user conversion master 106c Customer master 106d Merchandise master 106e Sales unit price master 106f Retail unit price master 108 Input/output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (11)

A customer sales information management device comprising a storage unit and a control unit,
The storage unit
An end-user master that is set by linking the manufacturer's person in charge and the end-user who is the delivery destination of the manufacturer's customer,
a customer end-user identifier that links the customer and the end user, the customer, and the customer end-user conversion master that is set by linking the end user;
Product and retail unit price master set by linking retail unit price,
with
The control unit
customer report acquisition means for acquiring customer report information set by linking the customer end user identifier, the product, and the amount of money delivered to the end user;
A customer who sets the person in charge of the manufacturer, the product, and the retail price by data conversion processing for the customer report information based on the end user master, the customer end user conversion master, and the retail unit price master. data conversion means for acquiring sales information;
A customer sales information management device comprising: The control unit
analysis acquisition means for acquiring analytical data by person in charge and by product, in which the delivery quantity of the product to the end user by the person in charge of the manufacturer is set based on the customer sales information;
2. The customer sales information management system according to claim 1, further comprising: The control unit
analysis acquisition means for acquiring analytical data by product by end user, in which the delivery quantity by product from the customer to the end user is set based on the customer sales information;
2. The customer sales information management system according to claim 1, further comprising: The customer report information includes:
Furthermore, the delivery date is linked and set,
The customer sales information is
In addition, the delivery date is linked and set,
The control unit
analysis acquisition means for acquiring demand analysis data obtained by comparing the delivery quantity of each product from the customer to the end user for each delivery month and year based on the customer sales information;
2. The customer sales information management system according to claim 1, further comprising: The control unit
sales acquisition means for acquiring sales information in which the customer, the product, the sales volume of the product to the customer from the manufacturer, the sales unit price of the product, and the cost unit price of the product are set;
further comprising
The data conversion means is
Based on the sales information, the end-user master, the customer end-user conversion master, and the retail unit price master, the data conversion processing for the customer report information enables the manufacturer's person in charge, the product, the retail price, 3. A customer sales information management system according to claim 1, wherein said customer sales information in which a customer profit margin and a manufacturer's gross profit are set is acquired. The control unit
Analysis acquisition means for acquiring, based on the customer sales information, profit margin analysis data for each customer and for each product, in which the difference obtained by subtracting the customer profit margin from the manufacturer's gross profit is set.
6. The customer sales information management system according to claim 5, further comprising: The customer sales information is
7. The customer sales according to claim 5 or 6, further comprising a sales amount obtained by multiplying the sales unit price by the sales quantity and a cost price obtained by multiplying the cost price unit by the sales quantity. Information management device. The manufacturer's gross profit is
The amount obtained by subtracting the cost price from the sales amount,
The customer profit margin is
8. A customer sales information management system according to claim 7, wherein said sales amount is subtracted from said delivery amount. The retail unit price is
9. The customer sales information management system according to any one of claims 1 to 8, wherein the information is drug prices. A customer sales information management method to be executed by a customer sales information management device having a storage unit and a control unit, comprising:
The storage unit
An end-user master that is set by linking the manufacturer's person in charge and the end-user who is the delivery destination of the manufacturer's customer,
a customer end-user identifier that links the customer and the end user, the customer, and the customer end-user conversion master that is set by linking the end user;
Product and retail unit price master set by linking retail unit price,
with
to be executed by the control unit;
a customer report acquisition step of acquiring customer report information set by linking the customer end user identifier, the product, and the amount of money delivered to the end user;
A customer who sets the person in charge of the manufacturer, the product, and the retail price by data conversion processing for the customer report information based on the end user master, the customer end user conversion master, and the retail unit price master. a data conversion step for acquiring sales information;
A customer sales information management method comprising: A customer sales information management program to be executed by a customer sales information management device having a storage unit and a control unit,
The storage unit
An end-user master that is set by linking the manufacturer's person in charge and the end-user who is the delivery destination of the manufacturer's customer,
a customer end-user identifier that links the customer and the end user, the customer, and the customer end-user conversion master that is set by linking the end user;
Product and retail unit price master set by linking retail unit price,
with
In the control unit,
a customer report acquisition step of acquiring customer report information set by linking the customer end user identifier, the product, and the amount of money delivered to the end user;
A customer who sets the person in charge of the manufacturer, the product, and the retail price by data conversion processing for the customer report information based on the end user master, the customer end user conversion master, and the retail unit price master. a data conversion step for acquiring sales information;
Customer sales information management program for executing

Images