JP2023101271A - Supplier supplementary management apparatus, supplier supplementary management method, and supplier supplementary management program - Google Patents

Abstract

To provide a supplier supplementary management apparatus configured to allow for easy confirmation of a state of supplementary for each commodity, a supplier supplementary management method, and a supplier supplementary management program.SOLUTION: A supplier supplementary management apparatus refers to a supplementary salon list master, a supplementary condition master, a commodity master, and client sales achievement data to generate estimated supplementary achievement data including a result of calculating a cash supplementary amount and a commodity supplementary amount, and generates supplementary commodity data by determining the number of requested supplementary commodities for each supplier manufacturer and commodity code on the basis of the estimated supplementary achievement data.SELECTED DRAWING: Figure 1

Description

The present invention relates to a supplier compensation management device, a supplier compensation management method, and a supplier compensation management program.

In Patent Document 1, a calculation formula obtained based on rebate conditions for each supplier and target product, sales performance data for each supplier and target product registered in a sales data file, or purchase data file A technique is disclosed that introduces purchase performance data for each registered supplier and target product and calculates a rebate amount for each supplier and target product.

JP-A-2005-63378

By the way, in the beauty industry, there is a business practice in which a maker can receive compensation in the form of a product equivalent to the shipping amount or cash as a rebate in accordance with the shipment of the product.

However, in the above-mentioned Patent Document 1, no consideration is given to the status of reimbursement by products equivalent to the proportion of the shipping amount. was difficult to ascertain.

SUMMARY OF THE INVENTION The present invention has been made in view of the above, and provides a supplier compensation management device, a supplier compensation management method, and a supplier compensation management program capable of easily confirming the compensation status of each product. intended to

In order to solve the above-described problems and achieve the object, a supplier replenishment management device according to the present invention is a supplier replenishment management device comprising a control unit, wherein a customer code includes at least a fiscal month and , customer sales performance data for each customer in which the product code, supplier manufacturer, sales volume, sales unit price, and purchase unit price are associated with each other, and the customer code is associated with the first rebate group , a second rebate group, and applicable conditions, a supplementary salon list master in which at least the first rebate group, the second rebate group, the customer code, the supplier manufacturer, and the product Replenishment condition master in which code, replenishment type, cash replenishment rate, and product replenishment rate are associated, and product master in which at least product code, purchase unit price, and supplier maker are associated , and the control unit refers to the replenishment salon list master, the replenishment condition master, the product master, and the customer sales performance data, and calculates the cash reimbursement amount and the product reimbursement amount. a replenishment result calculation unit that generates reimbursement result schedule data including a replenishment result schedule data; and a generator.

Further, a supplier compensation management method according to the present invention is a supplier compensation management method executed by a supplier compensation management device having a control unit, wherein a customer code includes at least a fiscal month and a product Customer sales performance data for each customer in which a code, supplier manufacturer, number of sales, unit price of sales, and unit price of purchase are associated with each other; Compensation salon list master in which 2 rebate groups and applicable conditions are associated with each other, at least a first rebate group, a second rebate group, a customer code, a supplier manufacturer, and a product code , a replenishment condition master in which replenishment types, cash replenishment rates, and product replenishment rates are associated with each other; and a product master in which at least product codes, purchase unit prices, and supplier manufacturers are associated with each other; and is executed by the control unit, referring to the replenishment salon list master, the replenishment condition master, the product master and the customer sales performance data, and calculating the cash replenishment amount and the product replenishment amount A replenishment performance calculation step for generating reimbursement performance schedule data including results; and replenishment for generating replenishment product data in which the number of replenishment requests for reimbursement products is determined for each supplier manufacturer and product code based on the replenishment performance schedule data. and a product generation step.

Further, a supplier compensation management program according to the present invention is a supplier compensation management program to be executed by a supplier compensation management device having a control unit, wherein the customer code includes at least a fiscal month, Customer sales performance data for each customer in which the product code, supplier manufacturer, sales volume, sales unit price, and purchase unit price are associated with each other, a first rebate group for the customer code, Compensation salon list master in which a second rebate group and applicable conditions are associated, at least the first rebate group, the second rebate group, the customer code, the supplier manufacturer, and the product code , a replenishment condition master in which replenishment types, cash replenishment rates, and product replenishment rates are associated with each other, and a product master in which at least product codes, purchase unit prices, and supplier manufacturers are associated with each other. , and refers to the replenishment salon list master, the replenishment condition master, the product master, and the customer sales record data for execution by the control unit, and calculates the cash reimbursement amount and the product reimbursement amount. a replenishment performance calculation step for generating reimbursement performance schedule data including the calculated results; and replenishment product data in which the number of replenishment requests for reimbursement products is determined for each supplier manufacturer and product code based on the replenishment performance schedule data. and a compensating product generation step.

ADVANTAGE OF THE INVENTION According to this invention, there exists an effect that the compensation situation for every goods can be confirmed easily.

FIG. 1 is a schematic diagram showing an overview in a block diagram showing an example of the configuration of a supplier replenishment management device according to an embodiment. FIG. 2 is a diagram showing an example of an applicable condition master table in the applicable condition master of the supplier compensation management device according to the embodiment. FIG. 3 is a diagram showing an example of a replenishment salon list master table in the replenishment salon list master of the supplier replenishment management device according to the embodiment. FIG. 4 is a diagram showing an example of a replenishment condition master table in the replenishment condition master of the supplier replenishment management device according to the embodiment. FIG. 5 is a diagram showing an example of a basic information master table in the basic information master of the supplier compensation management device according to the embodiment. FIG. 6 is a diagram showing an example of a product master table in the product master of the supplier compensation management device according to the embodiment. FIG. 7 is a diagram showing an example of a customer sales performance data table in the customer sales performance data of the supplier replenishment management device according to the embodiment. FIG. 8 is a diagram showing an example of a customer sales performance data table in the customer sales performance data of the supplier replenishment management device according to the embodiment. FIG. 9 is a diagram showing an example of a sales performance data table in the sales performance data of the supplier compensation management device according to the embodiment. FIG. 10 is a diagram showing an example of a purchase performance data table in the purchase performance data of the supplier compensation management device according to the embodiment. FIG. 11 is a diagram schematically illustrating an outline of a supplementary product request using the supplier compensation management device of the supplier compensation management device according to the embodiment. FIG. 12 is a flowchart showing an outline of processing executed by the supplier compensation management device according to the embodiment. FIG. 13 is a diagram showing an example of the calculation target month screen. FIG. 14 is a diagram schematically illustrating an overview of a compensation schedule calculation method by the compensation performance calculation unit of the supplier compensation management device according to the embodiment. FIG. 15 is a diagram showing an example of a scheduled replenishment performance data table in the scheduled replenishment performance data generated by the replenishment performance calculation unit of the supplier replenishment management device according to the embodiment. FIG. 16 is a diagram showing an example of a monthly screen for calculation of compensation total results. FIG. 17 is a diagram showing an example of replenishment performance schedule data of a supplier. FIG. 18 is a diagram showing an example of replenishment performance schedule data of another supplier. FIG. 19 is a diagram schematically explaining an overview of the linking process by the linking unit of the supplier replenishment management device according to the embodiment. FIG. 20 is a diagram schematically explaining a calculation method of compensation product data by the compensation product generation unit of the supplier compensation management device according to the embodiment. FIG. 21 is a diagram showing an example of a compensation product data table calculated by the compensation product generation unit of the supplier compensation management device according to the embodiment.

BEST MODE FOR CARRYING OUT THE INVENTION An embodiment of a supplier compensation management device, a supplier compensation management method, and a supplier compensation management program according to the present invention will be described below in detail with reference to the drawings. It should be noted that the present invention is not limited by this embodiment.

[1. composition]
An example of the configuration of the supplier replenishment management device according to this embodiment will be described with reference to FIG. 1 and the like. FIG. 1 is a schematic diagram showing an overview in a block diagram showing an example of the configuration of a supplier replenishment management device.

The supplier replenishment management device 100 shown in FIG. 1 is a commercially available desktop personal computer. Note that the supplier compensation 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 Assistants), a smart phone, a tablet personal computer, or the like. may be a portable information processing apparatus.

The supplier compensation 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 unit included in the supplier replenishment management device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the supplier compensation 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 supplier replenishment 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). Note that the data stored in the storage 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 section 108 . The output device 114 can be a monitor (including a home television), 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 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. Storage unit 106 stores application condition master 106a, replenishment salon list master 106b, replenishment condition master 106c, basic information master 106d, product master 106e, customer sales performance data 106f, sales performance data 106g, and sales data 106g. It stores entry record data 106h.

The applicable condition master 106a stores applicable condition codes in association with applicable condition names.

FIG. 2 is a diagram showing an example of an applicable condition master table in the applicable condition master 106a. As shown in FIG. 2, in the first row of the applicable condition master table T1, the applicable condition code "0" is stored in association with the applicable condition name "group 2 common".

The compensation salon list master 106b stores a customer code in association with a first rebate group, a second rebate group, and application conditions.

FIG. 3 is a diagram showing an example of a complementary salon list master table in the complementary salon list master 106b. As shown in FIG. 3, in the first row of the complementary salon list master table T2, rebate group 2 (second rebate group) "00100020", rebate group 1 (first rebate group) "00100025", The customer code "10001085" and the applicable condition "1: common to group 1" are associated and stored. Any of the applicable conditions in the applicable condition master table T1 of the applicable condition master 106a can be selected as the applicable condition. Specifically, the settings of rebate group 1 and rebate group 2 are stored in the 1st to 3rd rows and the 8th to 10th rows of the complementary salon list master table T2. Therefore, in the 1st to 3rd rows and the 8th to 10th rows of the supplementary salon list master table T2, the application conditions are selected from group 2 common, group 1 common, and customer specific, and stored. are doing.

In addition, as shown in FIG. 3, since there is no rebate group 1 setting in the 4th row of the compensation salon list master table T2, group 1 common cannot be selected as the application condition, and 0: group 2 common is selected and stored.

Furthermore, as shown in FIG. 3, there is no rebate group 2 setting in the 5th and 6th rows in the supplementary salon list master table T2. Therefore, in the 5th and 6th rows of the supplementary salon list master table T2, it is not possible to select common to group 2 as the applicable condition, and 1: common to group 1 and 2: specific to customer are selected. It is remembered.

Furthermore, as shown in FIG. 3, rebate group 2 is not set in the 6th and 7th rows of the complementary salon list master table T2. Therefore, in the 6th and 7th rows of the complementary salon list master table T2, 2: unique to the customer is selected as the applicable condition and stored.

The compensation condition master 106c includes a first rebate group, a second rebate group, a customer code, a start date, an end date, a supplier manufacturer code, a brand, a series, a major category, A medium classification, a product code, a type of compensation, a cash compensation rate, and a product compensation rate are associated with each other and stored.

FIG. 4 is a diagram showing an example of a compensation condition master table in the compensation condition master 106c. In the first row of the compensation condition master table T3 shown in FIG. 00000000", start date "2000/01/01", end date "2099/12/31", supplier manufacturer code "001", major category "001", compensation type "0: target outside", the cash replenishment rate of "0.00%", and the product replenishment rate of "0.00%" are associated and stored.

The basic information master 106d stores accounting months. FIG. 5 is a diagram showing an example of a basic information master table in the basic information master 106d. The basic information master table T4 shown in FIG. 5 stores the accounting month "2021/10" which is the reference of the calculation target month.

The product master 106e manages and stores product codes, product names, brands, series, large categories, medium categories, purchasing unit prices, and supplier manufacturer codes in association with each other.

FIG. 6 is a diagram showing an example of a product master table in the product master 106e. The first row of the product master table T5 shown in FIG. Classification "11", purchase unit price "200", and supplier manufacturer code "001" are associated and stored.

The customer sales record data 106f includes customer code, at least accounting month, product code, supplier manufacturer, brand, series, major category, middle category, number of sales, sales unit price, It stores sales performance data for each customer in which purchase unit prices are associated with each other.

FIG. 7 is a diagram showing an example of a customer sales performance data table in the customer sales performance data 106f. FIG. 8 is a diagram showing an example of a customer sales performance data table in the customer sales performance data 106f. 7 shows an example of a sales performance data table with a customer code of "10001085", and FIG. 8 shows an example of a sales performance data table with a customer code of "10001086".

The first line of the customer sales record data table T6 in FIG. Brand "1", series "11", major category "001", middle category "11", number of sales "1", unit sales price "1,000", purchase unit price "200", are associated with each other and stored.

Further, in the first row of the customer sales record data table T7 in FIG. , brand "1", series "11", major category "001", middle category "11", sales quantity "1", sales unit price "1,000", purchase unit price "200" and are stored in association with each other.

The actual sales data 106g stores, for each product code, a processing month, a supplier manufacturer code, a product code, the number of actual sales, and a sales amount in association with each other.

FIG. 9 is a diagram showing an example of the actual sales data table in the actual sales data 106g. In the first row of the actual sales data table T8 shown in FIG. 9, the processing month "2021/09", the vendor manufacturer code "001", the product code "333333", the actual sales number "300", The sales amount "3,000" is stored in association with the sales amount.

The purchase record data 106h stores, for each product code, a processing month, a supplier manufacturer code, a product code, a sales record, and a purchase amount in association with each other.

FIG. 10 is a diagram showing an example of a purchase record data table in the purchase record data 106h. In the first row of the purchase record data table T9 shown in FIG. 10, the processing month "2021/09", the supplier manufacturer code "001", the product code "333333", and the sales record number "500" are displayed. , and the purchase amount "600,000" are stored in association with each other.

Returning to FIG. 1, the description of the configuration of the supplier replenishment management device 100 is continued.
The control unit 102 is a CPU or the like that controls the supplier replenishment 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. Execute. The control unit 102 includes an acquisition unit 102a, a compensation performance calculation unit 102b, a linking unit 102c, a compensation product generation unit 102d, and a display control unit 102e.

The acquisition unit 102a acquires the customer sales data 106f corresponding to the calculation target month from the storage unit 106 for each customer based on the calculation target month selected in the cell K1 of the calculation target month screen P1.

The replenishment record calculation unit 102b refers to the replenishment salon list master 106b, the replenishment condition master 106c, the product master 106e, and the customer sales record data 106f, and calculates replenishment record schedule data. In addition, the replenishment result calculation unit 102b calculates reimbursement for each supplier based on the reimbursement result schedule data, the calculation target month input to the reimbursement total result calculation target month screen P2, and the supplier manufacturer code. Actual performance schedule data is generated, and compensation performance schedule data for each supplier maker is output to each supplier maker.

The linking unit 102c links the actual sales data 106g, the actual purchase data 106h, and the product code to generate and output the actual sales base data and the actual purchase base data for reference for reviewing the supplementary product. Execute the linking process. In addition, the linking unit 102c outputs at least one of the sales record base data and the purchase record base data to the monitor 114. FIG.

The compensation product generation unit 102d generates compensation product data in which the number of compensation requests for compensation products is determined for each supplier manufacturer and product code based on the planned compensation performance data generated by the compensation performance calculation unit 102b.

The display control unit 102e refers to the basic information master 106d and causes the monitor 114 to display the calculation target monthly screen. Further, the display control unit 102e causes the monitor 114 to display a screen for each month to be calculated for compensating total results.

[2. Overview of Compensation Product Request Using Vendor Compensation Management Device 100]
Next, an outline of a compensation product request using the supplier compensation management device 100 will be described. 11A and 11B are diagrams schematically illustrating an outline of a supplementary product request using the supplier supplementary management device 100. FIG.

As shown in FIG. 11A, first, the company that manages the supplier replenishment management device 100 purchases product A from the supplier manufacturer (step S1), delivers it to the customer salon, and sells it. (step S2).

Subsequently, as shown in FIG. 11B, the supplier replenishment management device 100 acquires the customer sales performance data 106f from the customer salon (step S3), and uses the customer sales performance data 106f. Compensation performance schedule data including the cash compensation amount and the product compensation amount is generated (step S4). In addition, the detail of the production|generation method of compensation track record schedule data is mentioned later.

After that, as shown in FIG. 11B, the supplier reimbursement management device 100 transmits reimbursement performance schedule data including the cash reimbursement amount and the commodity reimbursement amount to the supplier/manufacturer (step S5). As a result, it is possible to respond promptly to inquiries regarding the content of compensation from supplier manufacturers. In this case, the supplier maker checks the replenishment performance schedule data sent from the supplier replenishment management device 100, and, if approved, notifies the supplier maker that the replenishment performance schedule data is approved.

Subsequently, as shown in (C) of FIG. 11, the supplier replenishment management device 100 determines the products to be replenished and the number of products based on the product reimbursement amount in the actual reimbursement schedule data. (Step S6), and sends the product replenishment schedule data to the supplier/manufacturer to make a product replenishment request (Step S7).

After that, as shown in (D) of FIG. 11, the company managing the supplier replenishment management device 100 receives the replenishment product from the supplier manufacturer (step S8).

[3. Processing executed by supplier compensation management device 100]
Next, processing executed by the supplier replenishment management device 100 will be described. FIG. 12 is a flow chart showing an outline of processing executed by the supplier compensation management device 100. As shown in FIG.

As shown in FIG. 12, first, the display control unit 102e refers to the basic information master 106d and causes the monitor 114 to display the calculation target monthly screen (step S101). FIG. 13 is a diagram showing an example of the calculation target month screen. The calculation target month screen P1 includes a cell K1 for selecting a calculation target month and an execution button B1 for instructing execution. Although "2021/09" is entered in the cell K1 in FIG. 13, the initial display displays the accounting month of the basic information master 106d, for example, "2021/10". Also, the calculation target month can be changed from the accounting month in the basic information master 106d to the last month (-January).

Subsequently, the acquiring unit 102a acquires the customer sales performance data 106f corresponding to the calculation target month from the storage unit 106 for each customer based on the calculation target month selected in the cell K1 of the calculation target month screen P1. (Step S102). For example, the customer sales performance data table T6 of FIG. 7 and the customer sales performance data table T7 of FIG.

Thereafter, the replenishment record calculation unit 102b refers to the replenishment salon list master 106b, the replenishment condition master 106c, the product master 106e, and the customer sales record data 106f, and calculates replenishment record schedule data (step S103).

FIG. 14 is a diagram schematically illustrating an outline of a replenishment schedule calculation method by the replenishment performance calculation unit 102b. In addition, in FIG. 14, first, the calculation contents of the compensation amount for the customer "10001085" will be explained, and then the calculation contents of the compensation amount for the customer "10001086" will be explained.

[3-1. Customer "10001085"]
First, a case where the customer is "10001085" will be described. As shown in FIG. 14, the replenishment record calculation unit 102b refers to the replenishment salon list master table T2, the replenishment condition master table T3, the product master table T5, and the customer sales record data table T6, and calculates the customer sales record data table T6. Calculate the compensation amount calculation of.

Specifically, since the brand, series, middle category, and product code in the compensation condition master table T3 are not specified, and only the major category is specified, the compensation result calculation unit 102b Although the second line (2) and the third line (3) meet the conditions, it is determined that the type of compensation is excluded.

On the other hand, the replenishment record calculation unit 102b does not specify the brand, series, middle category, and product code in the replenishment condition master table T3, and only the major category is specified. Only the fourth line (4) determines that the supplier meets the condition (B).

Therefore, the reimbursement result calculation unit 102b calculates the planned cash reimbursement amount and the planned product reimbursement amount only for the fourth line (4). For example, the replenishment record calculation unit 102b refers to the replenishment salon list master table T2, the replenishment condition master table T3, the product master table T5, and the customer sales record data table T6, and performs cash replenishment according to the following (1) and (2). Calculate the planned amount and the planned product replenishment amount.
Scheduled cash compensation amount = (3 x 2000) x 0.10 = 600 (1)
Planned product reimbursement amount = (3 x 2000) x 0.15 = 900 (2)

[3-2. Customer "10001086"]
Next, the case of customer "10001086" will be described. As shown in FIG. 14, the replenishment record calculation unit 102b refers to the replenishment salon list master table T2, the replenishment condition master table T3, the product master table T5, and the customer sales record data table T6, and calculates the customer sales record data table T7. Calculate the compensation amount calculation of.

Specifically, since the brand, series, middle category, and product code in the compensation condition master table T3 are not specified, and only the major category is specified, the compensation result calculation unit 102b Although the second line (2) and the third line (3) meet the conditions, it is determined that the type of compensation is excluded.

On the other hand, the replenishment record calculation unit 102b determines that the supplier on the fourth line (4) in the customer sales record data table T7 meets the condition (E). Therefore, the replenishment track record calculation unit 102b calculates the scheduled cash replenishment amount in line 4 (4) using the following equation (3).
Scheduled cash compensation amount = (3 x 2000) x 0.10 = 600 (3)

Further, as shown in FIG. 14, the replenishment record calculation unit 102b determines that the fifth line (5) in the customer sales record data table T7 meets the condition (C). Therefore, the reimbursement result calculation unit 102b calculates the scheduled cash reimbursement amount and the scheduled product reimbursement amount in line 5 (5) using the following equations (4) and (5).
Scheduled cash compensation amount = (4 x 2000) x 0.08 = 640 (4)
Planned product compensation amount = (4 x 2000) x 0.25 = 2000 (5)

In this manner, the reimbursement result calculation unit 102b calculates the scheduled cash reimbursement amount and the scheduled product reimbursement amount for each supplier for each customer, and calculates the scheduled cash reimbursement amount and product reimbursement amount for each supplier. To generate replenishment performance schedule data in which the replenishment scheduled amount and the replenishment scheduled amount are associated with each other.

FIG. 15 is a diagram showing an example of a scheduled replenishment performance data table in the scheduled replenishment performance data generated by the replenishment performance calculation unit 102b. As shown in FIG. 15, in the reimbursement performance schedule data table T10, each supplier corresponds to a processing month, a vendor manufacturer code, a customer code, a cash reimbursement amount, and a product reimbursement amount. It is stored with Specifically, in the first row of the reimbursement schedule data table T10, the processing month "2021/09", the vendor manufacturer code "001", the customer code "10001085", and the cash reimbursement amount "1 , 200” and the product reimbursement amount of money “900” are stored in association with each other. This allows the user to quickly respond based on the scheduled reimbursement record data table T10 even when there is an inquiry about the content of reimbursement from the supplier/manufacturer.

Returning to FIG. 12, the description after step S104 is continued.
In step S104, the display control unit 102e causes the monitor 114 to display the screen of the month to be calculated for the total compensation results. FIG. 16 is a diagram showing an example of a monthly screen for calculation of compensation total results. On the calculation target month screen P2 of the replenishment summary results, there are cell K11 for selecting the calculation target month, supplier code cells K12 and K13 for entering the supplier manufacturer code, and output destination input cells. and an execution button B1 for instructing execution. Although "2021/09" is entered in the cell K11 in FIG. 16, the initial display shows the accounting month of the basic information master 106d, for example, "2021/10". Also, the calculation target month can be changed from the accounting month in the basic information master 106d to the last month (-January).

Subsequently, the replenishment result calculation unit 102b calculates the supplier manufacturer and Compensation performance schedule data is generated by determining the number of compensation requests for compensation products for each product code (step S105), and compensation performance schedule data for each supplier manufacturer is output to each supplier manufacturer (step S106).

FIG. 17 is a diagram showing an example of replenishment performance schedule data of a supplier. FIG. 18 is a diagram showing an example of replenishment performance schedule data of another supplier. As shown in FIGS. 17 and 18, the reimbursement performance calculation unit 102b is based on the scheduled reimbursement performance data, the calculation target month input to the reimbursement total performance calculation target month screen P2, and the supplier manufacturer code. 17 and at least one of the scheduled replenishment record data table T12 of FIG. 18 is generated and transmitted to each supplier/manufacturer. As a result, each supplier/manufacturer can confirm the compensation amount.

After that, the linking unit 102c links the actual sales data 106g, the actual purchase data 106h, and the product code to generate the actual sales base data and the actual purchase base data to be referenced for reviewing the supplementary product. (Step S107), and outputs at least one of the sales record base data and the purchase record base data to the monitor 114 (Step S108).

FIG. 19 is a diagram schematically explaining the outline of the tying process by the tying unit 102c. As shown in FIG. 19, the linking unit 102c refers to the sales performance data table T8 and the purchase performance data table T9 of the designated institution, and associates the purchase performance data table T9 with the product code to obtain the sales performance base data. A table T21 and a purchase record base data table T22 are generated.

In the sales performance base data table T21, the products with the highest sales performance in the past are linked with the purchase performance data table T9 by product code, and the sales performance is integrated with the purchase performance data 106h by product code on the basis of quantity sales. data table.

In addition, the purchase record base data table T22 associates the past purchase records for consideration of compensation with the sales record and the product code, and the purchase record is based on the quantity order and the sales record with the product code. Data table integrated with data 106g.

Accordingly, the user can grasp the top-selling products for compensation by confirming at least one of the sales record base data table T21 and the purchase record base data table T22.

Returning to FIG. 12, the description after step S109 is continued.
In step S109, the compensation product generation unit 102d generates compensation product data based on the scheduled compensation performance data generated by the compensation performance calculation unit 102b.

FIG. 20 is a diagram schematically illustrating a method of calculating compensation product data by the compensation product generation unit 102d. FIG. 21 is a diagram showing an example of a compensation product data table calculated by the compensation product generation unit 102d.

As shown in FIGS. 20 and 21, the compensation product generation unit 102d generates a compensation product data table T31 by calculating the current compensation target based on the product compensation amount D1 in the compensation performance schedule data table T10. . In this case, the compensating product generation unit 102d refers to the sales performance base data table T21, the purchase performance base data table T22, and the product master table T5 generated by the linking unit 102c, and selects hot-selling products or priority sales products. Compensation product data table T31 is generated by calculating so that the product is the product to be compensated for this time.

Subsequently, the compensation product generation unit 102d outputs the compensation product data to each supplier manufacturer (step S110). After step S110, the supplier compensation management device 100 terminates this process.

According to the embodiment described above, the compensation product generation unit 102d determines the number of compensation requests for compensation products for each supplier manufacturer and product code based on the planned compensation performance data generated by the compensation performance calculation unit 102b. Since compensation product data is generated, the compensation status for each product can be easily confirmed.

In addition, according to the embodiment, since the reimbursement record calculation unit 102b generates the reimbursement record schedule data for each supplier manufacturer, it is possible to quickly reply the cash reimbursement amount and the product reimbursement amount for each supplier manufacturer. , product and cash replenishment delays and omissions can be prevented.

Further, according to the embodiment, since the compensating product generation unit 102d generates compensating product data for each supplier marker, it is possible to promptly request compensation products for each supplier maker.

Further, according to the embodiment, since the reimbursement record calculation unit 102b generates the reimbursement record schedule data for each supplier manufacturer, it is possible to calculate the cash reimbursement amount and the product reimbursement amount in detail.

Further, according to the embodiment, since the linking unit 102c generates at least one of the sales performance base data and the purchase performance base data, it is possible to check the top sales performance for consideration of compensation or the top purchase performance for consideration of compensation. can be done.

Further, according to the embodiment, based on at least one of the sales performance base data and purchase performance base data generated by the compensation product generation unit 102d by the linking unit 102c and the planned compensation performance data by the compensation performance calculation unit 102b In order to generate supplementary product data in consideration of the sales performance base data and the purchase performance base data, the products to be supplemented this time are supplemented with hot-selling products or priority sales products. As a result, the supplier/manufacturer can treat the product as a sales expense like a sample product and use it for market trend analysis and adjustment.

[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.

Also, with respect to the supplier replenishment management device 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions of the supplier compensation management device 100, especially the processing functions performed by the control unit, are implemented in whole or in part by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware by wired logic. Note that 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 the present embodiment. It is mechanically read by the replenishment 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 supplier replenishment 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 Blu-ray (registered trademark) Disc, etc. 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 structure, but is distributed as a plurality of 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 embodiments, the installation procedure after reading, and the like.

The various databases stored in the storage 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. It stores programs, tables, databases, files for web pages, and so on.

Further, the supplier replenishment 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 any peripheral device is connected. . Further, the supplier replenishment management device 100 may be realized by installing software (including programs, data, etc.) for realizing the processing described in the present 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 beauty industry and the like that replenish products.

100 supplier compensation management device 102 control unit 102a acquisition unit 102b compensation result calculation unit 102c linking unit 102d compensation product generation unit 102e display control unit 104 communication interface unit 106 storage unit 106a application condition master 106b compensation salon list master 106c compensation condition master 106d basic information master 106e merchandise master 106f customer sales performance data 106g sales performance data 106h purchase performance data 108 input/output interface unit 112 input device 114 output device 200 server 300 network

Claims (8)

A supplier replenishment management device comprising a control unit,
customer sales performance data for each customer in which at least the accounting month, product code, supplier manufacturer, sales volume, sales unit price, and purchase unit price are associated with the customer code;
Compensation salon list master in which the customer code is associated with the first rebate group, the second rebate group, and the applicable conditions;
At least a first rebate group, a second rebate group, a customer code, a vendor manufacturer, a product code, a compensation type, a cash compensation rate, and a product compensation rate are associated with each other. a compensating condition master;
A product master in which at least a product code, a purchase unit price, and a supplier/manufacturer are associated with each other;
is accessible to
The control unit
Compensation performance calculation unit for generating compensation performance schedule data including calculation results of cash compensation amount and product compensation amount by referring to the compensation salon list master, the compensation condition master, the product master and the customer sales performance data. and,
a supplementary product generation unit that generates supplementary product data in which the number of supplementary product requests for supplementary products is determined for each supplier manufacturer and product code based on the scheduled supplementary record data;
to provide
A supplier replenishment management device characterized by: The supplier replenishment management device according to claim 1,
The replenishment performance calculation unit,
generating the scheduled replenishment performance data for each supplier manufacturer;
A supplier replenishment management device characterized by: The supplier replenishment management device according to claim 1 or 2,
The compensation product generation unit
generating the compensation product data for each supplier manufacturer;
A supplier replenishment management device characterized by: The supplier replenishment management device according to any one of claims 1 to 3,
sales performance data in which the product code, the number of sales performance, and the sales amount are associated with each supplier manufacturer;
Purchasing record data in which the product code, the number of purchase records, and the purchase amount are associated with each supplier manufacturer;
is further accessible to
Based on the sales performance data and the purchase performance data, linked to the product code and linked to the sales performance base data and the product code that integrate the sales performance data and the purchase performance data in order of sales quantity further comprising a linking unit that generates at least one of purchase record base data obtained by integrating the purchase record data and the sales record data in order of purchase quantity;
A supplier replenishment management device characterized by: The supplier replenishment management device according to claim 4,
The compensation product generation unit
generating the replenishment product data based on at least one of the sales performance base data and the purchase performance base data and the scheduled replenishment performance data;
A supplier replenishment management device characterized by: The supplier replenishment management device according to any one of claims 1 to 5,
Further comprising a display control unit for displaying on a monitor a calculation target month screen for accepting input of a calculation target month when the replenishment result calculation unit performs calculation,
The replenishment performance calculation unit,
generating the scheduled replenishment performance data according to the calculation target month input on the calculation target month screen;
A supplier replenishment management device characterized by: A supplier compensation management method executed by a supplier compensation management device comprising a control unit,
customer sales performance data for each customer in which at least the accounting month, product code, supplier manufacturer, sales volume, sales unit price, and purchase unit price are associated with the customer code;
Compensation salon list master in which the customer code is associated with the first rebate group, the second rebate group, and the applicable conditions;
At least a first rebate group, a second rebate group, a customer code, a vendor manufacturer, a product code, a compensation type, a cash compensation rate, and a product compensation rate are associated with each other. a compensating condition master;
A product master in which at least a product code, product name, middle classification, purchase unit price, and supplier/manufacturer are associated with each other;
is accessible to
executed by the control unit;
A reimbursement performance calculation step of generating reimbursement performance schedule data including calculation results of calculating the cash reimbursement amount and the product reimbursement amount by referring to the reimbursement salon list master, the reimbursement condition master, the product master and the customer sales performance data. and,
a compensation product generation step of generating compensation product data in which the number of compensation requests for compensation products is determined for each supplier manufacturer and product code based on the scheduled compensation performance data;
including
A supplier replenishment management method characterized by: A supplier compensation management program to be executed by a supplier compensation management device comprising a control unit,
customer sales performance data for each customer in which at least the accounting month, product code, supplier manufacturer, sales volume, sales unit price, and purchase unit price are associated with the customer code;
Compensation salon list master in which the customer code is associated with the first rebate group, the second rebate group, and the applicable conditions;
At least a first rebate group, a second rebate group, a customer code, a vendor manufacturer, a product code, a compensation type, a cash compensation rate, and a product compensation rate are associated with each other. a compensating condition master;
a product master in which at least a product code, product name, middle classification, purchase unit price, and supplier/manufacturer are associated;
is accessible to
for causing the control unit to execute
A reimbursement performance calculation step of generating reimbursement performance schedule data including a calculation result of calculating a cash reimbursement amount and a product reimbursement amount by referring to the reimbursement salon list master, the reimbursement condition master, the product master and the customer sales performance data. and,
a compensation product generation step of generating compensation product data in which the number of compensation requests for compensation products is determined for each supplier manufacturer and product code based on the compensation performance schedule data;
including
A vendor compensation management program characterized by:

Images