JP7620536B2 - Purchase price negotiation support device, purchase price negotiation support program, and purchase price negotiation support method - Google Patents

Description

The present invention relates to a purchase price negotiation support device, a purchase price negotiation support program, and a purchase price negotiation support method.

When purchasing goods in large quantities, the purchase price, cost price, gross profit, etc. can fluctuate significantly depending on the results of negotiations on the unit price of the goods.

Patent document 1 describes a purchasing unit price negotiation support method that supports unit price negotiations based on past purchase history with multiple suppliers.

JP 2014-206801 A

However, with conventional negotiation support, while it was possible to negotiate unit prices by referring to purchasing history, it was not possible to negotiate unit prices by referring to negotiation results.

The present invention has been made in consideration of the above, and aims to provide a purchase price negotiation support device, a purchase price negotiation support program, and a purchase price negotiation support method that can negotiate unit prices by referring to negotiation results.

In order to solve the above-mentioned problems and achieve the objective, the purchase price negotiation support device of the present invention is an information processing device having a control unit, the control unit being characterized by comprising: a unit price negotiation history data creation unit that creates unit price negotiation history data including the negotiation date when the unit price of the product was negotiated, the product supplier, product identification information for identifying the product, the negotiated unit price at which the unit price of the product was negotiated, and an adoption flag indicating whether the unit price was adopted; and a confirmation processing unit that, if the adoption flag indicates that the unit price was adopted, creates negotiation performance information indicating the negotiation performance during the target period and performs a confirmation process to confirm the adoption flag.

In addition, in the purchase price negotiation support device according to the present invention, the control unit can access purchase data including the purchase date of the product, the product supplier, product identification information for identifying the product, the purchased quantity of the product, and the unit price at which the product was purchased, and the negotiation performance information may include a target quantity obtained by tallying up the quantity of the product purchased within the target period in the purchase data, a target unit price which is the unit price during the target period in the purchase data, and a reduction price which represents the difference between the target unit price and the negotiated unit price.

In addition, in the purchase unit price negotiation support device according to the present invention, the control unit may have access to a unit price master that manages unit prices for each supplier and each product, and may be equipped with an analysis report creation unit that creates an analysis report including a current reduction unit price that represents the difference between the undetermined negotiated unit price in the unit price negotiation history data and the current unit price in the unit price master, and the reduction unit price.

In addition, in the purchase unit price negotiation support device according to the present invention, the confirmation processing unit may register the confirmed unit price in the unit price master when executing the confirmation process.

The purchase unit price negotiation support program according to the present invention includes a unit price negotiation history data creation step for creating unit price negotiation history data including the negotiation date when the unit price of the product was negotiated, the product supplier, product identification information for identifying the product, the negotiated unit price at which the unit price of the product was negotiated, and an adoption flag indicating whether the unit price was adopted, for execution by a control unit of a purchase unit price negotiation support device having a control unit, and a confirmation processing step for creating negotiation performance information indicating the negotiation performance during the target period and performing a confirmation processing for confirming the adoption flag if the adoption flag indicates that the unit price has been adopted.

The method of supporting purchase unit price negotiation according to the present invention includes a unit price negotiation history data creation step executed by a control unit of a purchase unit price negotiation support device having a control unit, which creates unit price negotiation history data including the negotiation date when the unit price of the product was negotiated, the product supplier, product identification information for identifying the product, the negotiated unit price at which the unit price of the product was negotiated, and an adoption flag indicating whether the unit price was adopted, and a confirmation processing step of creating negotiation performance information indicating the negotiation performance during the target period and performing a confirmation process to confirm the adoption flag if the adoption flag indicates that the unit price was adopted.

The present invention has the advantage that, when a customer is a company that belongs to a group, transactions can be restricted according to the limit for the entire group.

FIG. 1 is a diagram showing an example of the configuration of a purchase price negotiation support device. FIG. 2 is a diagram showing an example of purchase data. FIG. 3 is a diagram showing an example of unit price negotiation history data. FIG. 4 is a diagram illustrating an example of the product master. FIG. 5 is a diagram showing an example of the unit price master. FIG. 6 is a diagram showing an example of unit price negotiation history data. FIG. 7 is a diagram showing an example of the unit price master. FIG. 8 is a diagram showing an example of purchase data. FIG. 9 is a diagram showing an example of unit price negotiation history data. FIG. 10 is a diagram showing an example of the analysis form creation screen. FIG. 11 is a diagram showing an example of the analysis form. FIG. 12 is a diagram showing an example of unit price negotiation history data. FIG. 13 is a diagram showing an example of the setting screen. FIG. 14 is a diagram showing an example of unit price negotiation history data. FIG. 15 is a diagram illustrating an example of the unit price master.

Below, an embodiment of a purchase price negotiation support device, a purchase price negotiation support program, and a purchase price negotiation support method 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 present embodiment.

[1. Configuration]
An example of the configuration of the purchase price negotiation support device according to the present embodiment will be described with reference to Fig. 1 etc. Fig. 1 is a diagram showing an example of the configuration of the purchase price negotiation support device.

The purchase price negotiation support device 100 creates unit price negotiation history data that includes the negotiation date, the negotiated unit price, an adoption flag indicating whether the unit price was adopted, and negotiation performance information indicating the negotiation performance. As a result, the purchase price negotiation support device 100 can negotiate the unit price by referring to the negotiation performance.

The purchase price negotiation support device 100 is a commercially available desktop personal computer. The purchase price negotiation support device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be 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.

The purchase price negotiation support device 100 includes a control unit 102, a communication interface unit 104, a memory unit 106, and an input/output interface unit 108. Each unit included in the purchase price negotiation support device 100 is connected to each other so as to be able to communicate with each other via any communication path.

The communication interface unit 104 communicatively connects the purchase price negotiation support 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 purchase price negotiation support 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.

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 works with a mouse to provide 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.

The storage unit 106 stores various databases, tables, files, etc. The storage unit 106 records computer programs that work with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. The storage unit 106 can be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc.

The memory unit 106 stores, for example, purchasing data 106a, unit price negotiation history data 106b, product master data 106c, and unit price master data 106d.

Figure 2 is a diagram showing an example of purchasing data. The purchasing data 106a is data including, for example, the purchasing date of the product, the product supplier, product identification information (product code) for identifying the product, the purchased quantity of the product, and the unit price of the product. The purchasing data 106a stores the quantity, unit price, and amount of the product purchased for each purchasing date, each supplier, and each product, in association with each other.

Figure 3 is a diagram showing an example of unit price negotiation history data. Unit price negotiation history data 106b is data that includes, for example, the negotiation date when the unit price of the product was negotiated, the product supplier, product identification information (product code) for identifying the product, the negotiated unit price when the unit price of the product was negotiated, an adoption flag indicating whether the unit price was adopted, a target quantity obtained by tallying up the quantity of the product purchased within the target period in the purchasing data, a target unit price which is the unit price during the target period in the purchasing data, and a reduction price indicating the difference between the target unit price and the negotiated unit price. If the unit price has not been adopted, i.e., if the unit price is under negotiation or the unit price has not been adopted, a "0" is input to the adoption flag, and if the unit price has been adopted, a "1" is input.

Figure 4 shows an example of a product master. Product master 106c is a master that manages, for example, product identification information (product code) for identifying a product and product classification. Product classification indicates the nature of the product in sales (such as "low-margin, high-volume product" or "luxury product").

Figure 5 shows an example of unit price master. Unit price master 106d is a master that manages unit prices, for example, for each supplier and each product.

The control unit 102 is a CPU or the like that provides overall control of the purchase price negotiation 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, etc., and executes various information processing based on these stored programs. The control unit 102 can access the purchase data 106a to the unit price master 106d stored in the memory unit 106.

The control unit 102 conceptually includes a unit price negotiation history data creation unit 102a, a confirmation processing unit 102b, and an analysis report creation unit 102c.

The unit price negotiation history data creation unit 102a is an information processing means that creates unit price negotiation history data 106b.

The confirmation processing unit 102b is an information processing means that creates negotiation performance information that indicates the negotiation performance during the target period when the adoption flag in the unit price negotiation history data 106b is "1" indicating that the unit price has been adopted. The negotiation performance information includes, for example, a target quantity obtained by tallying up the quantity of goods purchased during the target period in the purchasing data, a target unit price that is the unit price during the target period in the purchasing data, and a markdown unit price that indicates the difference between the target unit price and the negotiated unit price. The confirmation processing unit 102b is also an information processing means that performs a confirmation process that confirms the adoption flag. When performing the confirmation process, the confirmation processing unit 102b registers the confirmed unit price in the unit price master 106d.

The analysis report creation unit 102c is an information processing means that creates an analysis report including the current discounted unit price, which represents the difference between the unconfirmed negotiated unit price in the unit price negotiation history data 106b and the current unit price in the unit price master 106d, and the discounted unit price.

2. Specific examples of processing
Here, a specific example of the processing executed by purchase price negotiation support device 100 will be described with reference to FIGS.

In this explanation, the purchase price negotiation support device 100 will register purchase data 106a every time a purchase is made, register unit price negotiation history data 106b every time a negotiation is made, and perform a confirmation process to create an analysis report according to the negotiation situation, based on the operator's input. Note that the product master 106c and unit price master 106d are assumed to be registered in advance in the storage unit 106.

[S1: Purchase data registration]
Based on the input from the operator, the control unit 102 registers the purchase data 106a in the storage unit 106. As shown in Fig. 2, the control unit 102 registers the quantity, unit price, and amount of the purchased goods for each purchase date, each supplier, and each product in the storage unit 106 based on the input from the operator.

[S2: Register unit price negotiation history data]
The unit price negotiation history data creation unit 102a registers unit price negotiation history data 106b based on the input of the operator. As shown in Fig. 3, the unit price negotiation history data creation unit 102a registers in the storage unit 106 the negotiation date when the unit price of the product was negotiated, the supplier of the product, product identification information (product code) for identifying the product, the negotiated unit price when the unit price of the product was negotiated, and an adoption flag indicating whether the unit price was adopted or not, based on the input of the operator.

[S3: Confirmation process]
The analysis document creation unit 102c executes a determination process to determine the adoption flag based on the operator's input. FIG. 6 is a diagram showing an example of unit price negotiation history data. As shown in FIG. 6, when the adoption flag of the unit price negotiation history data 106b is "1" indicating that the unit price has been adopted, the determination processing unit 102b refers to the purchase data 106a, and totals the target quantity, which is the total quantity of the product purchased within the target period in the purchase data, and registers it in the unit price negotiation history data 106b. Specifically, when "negotiated unit price: 124" is adopted for "product code: 12345" with "supplier: AAA" on "negotiation date: 7/21" and "adoption flag: 1" is input, the purchase quantity of "supplier: AAA" and "product code: 12345" whose "purchase date" is included in "target period: 4/1 to 6/30" in the purchase data 106a is totaled. That is, the "quantity: 10" on "purchase date: April 10th" and the "quantity: 20" on "purchase date: April 15th" are added together, and "target quantity: 30" is automatically entered into the unit price negotiation history data 106b in FIG.

The determination processing unit 102b further refers to the purchase data 106a, obtains the target unit price, which is the unit price for this target period, and registers it in the unit price negotiation history data 106b. Specifically, the determination processing unit 102b refers to "Unit Price: 150" for "Supplier: AAA" and "Product Code: 12345" for the target period in the purchase data 106a, and automatically inputs "Target Unit Price: 150" into the unit price negotiation history data 106b in FIG. 6.

In addition, the determination processing unit 102b calculates a markdown unit price that represents the difference between the acquired target unit price and the negotiated unit price, and registers this in the unit price negotiation history data 106b. Specifically, the determination processing unit 102b subtracts "negotiated unit price: 124" from "target unit price: 150" for "negotiation date 7/21", "supplier: AAA", and "product code: 12345" in the unit price negotiation history data 106b of FIG. 6, and automatically inputs "markdown unit price: 26".

Figure 7 is a diagram showing an example of the unit price master. When the operator presses a specified confirmation button, the confirmation processing unit 102b executes the confirmation process and confirms the adoption flag. At this time, as shown in Figure 7, the confirmation processing unit 102b registers the confirmed unit price in the unit price master 106d.

[S4: Purchase data registration]
8 is a diagram showing an example of purchase data. When a new purchase is made, the control unit 102 registers the purchase data 106a shown in FIG. 8 in the storage unit 106 based on an input by the operator, in the same manner as in step S1.

[S5: Register unit price negotiation history data]
9 is a diagram showing an example of unit price negotiation history data. When a new negotiation is performed, the unit price negotiation history data creating unit 102a registers unit price negotiation history data 106b shown in FIG. 9 based on an input by the operator, in the same manner as in step S2.

[S6: Analysis report creation process]
The analysis form creation unit 102c creates an analysis form based on the operator's input. FIG. 10 is a diagram showing an example of an analysis form creation screen. In the analysis form setting screen shown in FIG. 10, conditions for creating an analysis form are set. Here, an example of creating an analysis form by limiting the "supplier" to "AAA" as shown in FIG. 10 will be described. It is also possible to create an analysis form by specifying the "product classification", "product code", or "estimated price reduction amount" on the analysis form setting screen. The estimated price reduction amount is calculated by multiplying the price reduction unit price by the quantity to be purchased. In addition, by checking a check box on the analysis form setting screen, it is also possible to create an analysis form by displaying only "products with a smaller price reduction amount per quantity than the previous time". Similarly, it is also possible to create an analysis form by checking a check box on the analysis form setting screen and setting "sort by estimated price reduction amount". By using these functions, it is possible to negotiate by prioritizing items in order of the greatest impact on profits.

11 is a diagram showing an example of an analysis form. As shown in FIG. 11, the analysis form creation unit 102c creates an analysis form including a current reduction unit price, which represents the difference between the unconfirmed negotiated unit price in the unit price negotiation history data 106b and the current unit price in the unit price master 106d, and a reduction unit price (previous reduction unit price). Specifically, the analysis form creation unit 102c creates an analysis form including a "current reduction unit price: 2" obtained by subtracting the "negotiated unit price: 122" currently being negotiated and unconfirmed in the unit price negotiation history data 106b in FIG. 9 from the "unit price: 124" currently applied in the unit price master 106d in FIG. 7. Similarly, the analysis form creation unit 102c creates an analysis form including a "previous reduction unit price: 26" by referring to the "reduction unit price: 26" automatically input by the confirmation process in the unit price negotiation history data 106b in FIG. 9.

The analysis report creation unit 102c may also refer to the unit price master 106d to create an analysis report that includes "Product Code: 12345" and the "Product Category: Low-margin, high-volume product" that corresponds to this product code.

The analysis report creation unit 102c may also refer to the "negotiated unit price: 122" currently being negotiated and not yet determined in the unit price negotiation history data 106b in FIG. 9, and create an analysis report including "currently proposed unit price: 122". Similarly, the analysis report creation unit 102c may refer to the currently applied "unit price: 124" in the unit price master 106d in FIG. 7, and create an analysis report including "previously determined unit price: 124".

The analysis report creation unit 102c may also create an analysis report including the quantity planned to be purchased this time, "Current quantity: 25", based on the operator's input. Similarly, the analysis report creation unit 102c may refer to the unit price negotiation history data 106b in FIG. 9 and create an analysis report including the previous purchase quantity, "Previous quantity: 30".

The analysis report creation unit 102c may also divide the current markdown unit price by the current quantity to create an analysis report that includes "markdown unit price/quantity: 0.0800". Similarly, the analysis report creation unit 102c may divide the previous markdown unit price by the previous quantity to create an analysis report that includes "markdown unit price/quantity: 0.8667".

The analysis report creation unit 102c may also multiply the current markdown unit price by the current quantity to create an analysis report that includes "markdown amount: 50".

In addition, if "Market reduction price/quantity: 0.0800" is equal to or less than a threshold value (e.g., 1.0), the analysis report creation unit 102c may create an analysis report including "Market reduction price range: *" with "*" indicating an alert.

Here, we will explain what happens when you renegotiate the price because the "Price Reduction Range: *" alert is displayed on the analysis form in Figure 11.

[S7: Register unit price negotiation history data]
12 is a diagram showing an example of unit price negotiation history data. When a new negotiation is performed, the unit price negotiation history data creating unit 102a registers unit price negotiation history data 106b shown in FIG. 12 based on an input by the operator, in the same manner as in step S2.

[S8: Analysis report creation process]
The analysis form creation unit 102c creates an analysis form again based on the operator's input. Fig. 13 is a diagram showing an example of a setting screen. As shown in Fig. 13, the analysis form creation unit 102c creates an analysis form including "Current proposed unit price: 90", "Current markdown unit price: 34", and "Markdown unit price/quantity: 1.3600". At this time, the analysis form creation unit 102c does not display an alert of "*" for "Markdown unit price range" because "Markdown unit price/quantity: 1.3600" in the analysis form in Fig. 13 is greater than a threshold value (e.g., 1.0).

[S9: Confirmation process]
When the negotiation is completed, similarly to step S3, the analysis document creation unit 102c executes a confirmation process to confirm the adoption flag based on the operator's input. Fig. 14 is a diagram showing an example of unit price negotiation history data. As shown in Fig. 14, when the adoption flag of the unit price negotiation history data 106b is "1" indicating that the unit price has been adopted, the confirmation processing unit 102b automatically inputs "target quantity: 25", "target unit price: 124", and "reduced unit price: 34".

Figure 15 is a diagram showing an example of the unit price master. When the operator presses the specified confirmation button, the confirmation processing unit 102b executes the confirmation process and confirms the adoption flag. At this time, as shown in Figure 15, the confirmation processing unit 102b registers the confirmed unit price in the unit price master 106d.

As described above, according to this embodiment, the unit price negotiation history data creation unit 102a creates the unit price negotiation history data 106b, so that it is possible to negotiate the unit price by referring to the negotiation results. Furthermore, since the negotiation results are stored in the unit price negotiation history data 106b, they can be used in subsequent negotiations.

In addition, by negotiating unit prices using unit price negotiation history data 106b, the process and history of unit price negotiations become clear, and an unclear unit price determination process can be eliminated.

In addition, the analysis report creation unit 102c can display an alert such as "*" on the analysis report to prevent the unit price from being determined without sufficient unit price negotiation.

In addition, the analysis report creation unit 102c can display product classifications in the analysis report, allowing users to refer to the negotiation status and negotiation history for each product characteristic.

[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 making it possible to contribute to goals 8 and 9 of the SDGs.

In addition, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, which can contribute to the achievement of SDGs goals 12, 13, and 15.

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

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.

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 a known method.

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

In addition, with regard to the purchase price negotiation support device 100, each component shown in the figure is a functional concept, and does not necessarily have to be physically configured as shown in the figure.

For example, the processing functions of the purchase price negotiation 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 on a non-transient computer-readable recording medium that contains programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the purchase price negotiation support device 100 as needed. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to give instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM, and works with the CPU to form the control unit.

This computer program may also be stored in an application program server connected to the purchase price negotiation support device 100 via any network, and all or part of it may be downloaded as needed.

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

A "program" is a data processing method written in any language or description method, and may be in any format, 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 consisting of multiple modules or libraries, and a program that works in conjunction 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, can use well-known configurations and procedures.

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

The purchase price negotiation support 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 any peripheral device is connected. The purchase price negotiation support device 100 may be realized by implementing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the figures, and all or part of them can be functionally or physically distributed and integrated in any unit depending on 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.

The present invention is useful, for example, when negotiating the unit price for purchasing goods.

100 Purchase price negotiation support device 102 Control unit
102a Unit price negotiation history data creation section
102b Confirmation processing unit
102c Analysis report creation unit 104 Communication interface unit 106 Storage unit
106a Purchase data
106b Price negotiation history data
106c Product master
106d unit price master 108 input/output interface section 112 input device 114 output device 200 server 300 network

Claims (4)

An information processing device including a control unit,
The control unit is
Unit price master that manages unit prices for each supplier and each product,
Purchase data including the purchase date of the product, the supplier of the product, product identification information for identifying the product, the purchased quantity of the product, and the purchased unit price of the product;
is accessible to
a unit price negotiation history data creation unit that creates unit price negotiation history data that can be referenced by listing the negotiation date of the unit price of the product, the supplier of the product, product identification information for identifying the product, the negotiated unit price of the product, and an adoption flag indicating whether the unit price has been adopted;
a determination processing unit that, when the adoption flag indicates that the unit price has been adopted, creates negotiation performance information indicating negotiation performance during a target period, performs a determination process to determine the adoption flag, and registers the determined unit price in the unit price master;
Equipped with
the negotiation performance information includes a target quantity obtained by tallying up the quantity of the goods purchased during the target period in the purchase data, a target unit price which is the unit price during the target period in the purchase data, and a reduction price which represents the difference between the target unit price and the negotiated unit price;
A purchase price negotiation support device characterized by the above. The control unit is
a current discount unit price representing the difference between the undetermined negotiated unit price in the unit price negotiation history data and the current unit price in the unit price master, and an analysis form creation unit creating an analysis form including the discount unit price;
2. The purchase price negotiation support device according to claim 1, A control unit of a purchase price negotiation support device having a control unit that can access a unit price master that manages unit prices for each supplier and each product,
a purchase data creation step of creating purchase data including a purchase date of the product, a supplier of the product, product identification information for identifying the product, a purchased quantity of the product, and a purchased price of the product;
a unit price negotiation history data creation step for creating unit price negotiation history data that can be referenced by listing the negotiation date of the unit price of the product, the supplier of the product, product identification information for identifying the product, the negotiated unit price of the product, and an adoption flag indicating whether the unit price has been adopted;
a determination process step of creating negotiation performance information indicating negotiation performance during a target period when the adoption flag indicates that the unit price has been adopted, determining the adoption flag, and registering the determined unit price in the unit price master;
Including,
A purchase price negotiation support program, wherein the negotiation performance information includes a target quantity, which is the aggregated quantity of goods purchased within the target period in the purchasing data, a target unit price, which is the unit price during the target period in the purchasing data, and a reduction price, which represents the difference between the target unit price and the negotiated unit price. A control unit of a purchase price negotiation support device having a control unit that can access a unit price master that manages unit prices for each supplier and each product,
a purchase data creation step of creating purchase data including a purchase date of the product, a supplier of the product, product identification information for identifying the product, a purchased quantity of the product, and a purchased price of the product;
a unit price negotiation history data creation step for creating unit price negotiation history data that can be referenced by listing the negotiation date of the unit price of the product, the supplier of the product, product identification information for identifying the product, the negotiated unit price of the product, and an adoption flag indicating whether the unit price has been adopted;
a determination process step of creating negotiation performance information indicating negotiation performance during a target period when the adoption flag indicates that the unit price has been adopted, determining the adoption flag, and registering the determined unit price in the unit price master;
Including,
A method for supporting purchase price negotiation, wherein the negotiation performance information includes a target quantity, which is the aggregated quantity of goods purchased within the target period in the purchasing data, a target unit price, which is the unit price during the target period in the purchasing data, and a markdown price, which represents the difference between the target unit price and the negotiated unit price .

Images