Supplier compensation management device, supplier compensation management method, and supplier compensation management program

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

[Technical field]

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

[0002] Patent Document 1 discloses a technology for calculating the rebate amount for each supplier and target product by introducing actual sales data for each supplier and target product registered in a sales data file or actual purchase data for each supplier and target product registered in a purchase data file into a calculation formula obtained based on the rebate conditions for each supplier and target product. [Prior art documents] [Patent documents]

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

[0004] In the beauty industry, there is a business practice whereby, upon shipment of a product, a manufacturer provides a rebate in the form of compensation in the form of goods or cash equivalent to a percentage of the shipment price.

[0005] However, in the above-mentioned Patent Document 1, no consideration was given to the compensation situation for products equivalent to the shipping amount ratio, and only the rebate amount for each manufacturer was calculated from the shipping amount, making it difficult to confirm which products had been compensated.

[0006] The present invention has been made in consideration of the above, and aims to provide a supplier reimbursement management device, a supplier reimbursement management method, and a supplier reimbursement management program that allow easy checking of the reimbursement status for each product. [Means for solving the problem]

[0007] In order to solve the above-mentioned problems and achieve the object, the supplier compensation management device of the present invention is a supplier compensation management device having a control unit, and includes customer sales performance data for each customer in which a customer code is associated with at least an accounting month, a product code, a supplier manufacturer, a sales volume, a sales price, and a purchase price, a compensation salon list master in which a customer code is associated with a first rebate group, a second rebate group, and application conditions, and at least the first rebate group, the second rebate group, the customer code, the supplier manufacturer, the product code, the compensation type, and a cash compensation rate. The control unit is capable of accessing a compensation condition master which corresponds to a product compensation rate and a product master which corresponds at least to a product code, a purchase price, and a supplier manufacturer, and the control unit is equipped with a compensation actual result calculation unit which refers to the compensation salon list master, the compensation condition master, the product master, and the customer sales actual data, and generates compensation actual result plan data including calculation results of cash compensation amounts and product compensation amounts, and a compensation product generation unit which generates compensation product data that determines the number of compensation requests for compensation products for each supplier manufacturer and product code based on the compensation actual result planned data.

[0008] Furthermore, the 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, and includes customer sales performance data for each customer in which a customer code is associated with at least an accounting month, a product code, a supplier manufacturer, a sales volume, a sales price, and a purchase price; a compensation salon list master in which a customer code is associated with a first rebate group, a second rebate group, and application conditions; and at least the first rebate group, the second rebate group, the customer code, the supplier manufacturer, the product code, the compensation type, a cash compensation rate, and a product compensation rate. and a product master which corresponds at least a product code, a purchase price, and a supplier manufacturer, and includes a compensation actual result calculation step executed by the control unit, which refers to the compensation salon list master, the compensation condition master, the product master, and the customer sales actual data, and generates compensation actual result plan data including calculation results of a cash compensation amount and a product compensation amount, and a compensation product generation step which generates compensation product data which determines the number of compensation requests for compensation products for each supplier manufacturer and product code based on the compensation actual result planned data.

[0009] 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, and includes customer sales performance data for each customer in which at least an accounting month, a product code, a supplier manufacturer, a sales volume, a sales unit price, and a purchase unit price are associated with a customer code, a compensation salon list master in which a first rebate group, a second rebate group, and application conditions are associated with a customer code, and at least the first rebate group, the second rebate group, the customer code, the supplier manufacturer, the product code, a compensation type, a cash compensation rate, and a product compensation rate. The system is capable of accessing a compensation condition master which corresponds a rate with a product master which corresponds at least a product code, a purchase price, and a supplier manufacturer, and includes a compensation actual result calculation step for generating compensation actual result plan data including a calculation result of calculating a cash compensation amount and a product compensation amount by referring to the compensation salon list master, the compensation condition master, the product master, and the customer sales actual data to be executed by the control unit, and a compensation product generation step for generating compensation product data which determines the number of compensation requests for compensation products for each supplier manufacturer and product code based on the compensation actual result planned data. Effect of the Invention

[0010] According to the present invention, it is possible to easily check the replenishment status for each product. [Brief description of the drawings]

[0011] [Figure 1] FIG. 1 is a schematic diagram showing an overview in a block diagram of an example of the configuration of a supplier compensation management device according to an embodiment. [Diagram 2] FIG. 2 is a diagram illustrating an example of an application condition master table in the application condition master of the supplier compensation management device according to the embodiment. [Diagram 3] FIG. 3 is a diagram illustrating an example of a compensation salon list master table in the compensation salon list master of the supplier compensation management device according to the embodiment. [Figure 4]FIG. 4 is a diagram illustrating an example of a compensation condition master table in the compensation condition master of the supplier compensation management device according to the embodiment. [Diagram 5] FIG. 5 is a diagram illustrating an example of a basic information master table in the basic information master of the supplier replenishment management device according to the embodiment. [Figure 6] FIG. 6 is a diagram illustrating an example of a product master table in the product master of the supplier replenishment management device according to the embodiment. [Figure 7] FIG. 7 is a diagram illustrating 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. [Figure 8] FIG. 8 is a diagram illustrating 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. [Figure 9] FIG. 9 is a diagram illustrating an example of a sales performance data table in the sales performance data of the supplier replenishment management device according to the embodiment. [Figure 10] FIG. 10 is a diagram illustrating an example of a purchase record data table in the purchase record data of the supplier replenishment management device according to the embodiment. [Figure 11] FIG. 11 is a diagram for explaining an outline of a replenishment product request using the supplier replenishment management device according to the embodiment. [Figure 12] FIG. 12 is a flowchart showing an outline of the process executed by the supplier compensation management device of the embodiment. [Figure 13] FIG. 13 is a diagram showing an example of the calculation target month screen. [Figure 14] FIG. 14 is a diagram for explaining an outline of a compensation schedule calculation method by the compensation record calculation unit of the supplier compensation management device according to the embodiment. [Figure 15] FIG. 15 is a diagram illustrating an example of a compensation actual result schedule data table in compensation actual result schedule data generated by the compensation actual result calculation unit of the supplier compensation management device according to the embodiment. [Figure 16] FIG. 16 is a diagram showing an example of a calculation target month screen for the compensation tally results. [Figure 17] FIG. 17 is a diagram illustrating an example of the supplier's compensation performance plan data. [Figure 18] FIG. 18 is a diagram showing an example of compensation performance schedule data of another supplier. [Figure 19] FIG. 19 is a diagram for explaining an outline of the linking process by the linking unit of the supplier replenishment management device according to the embodiment. [Figure 20] FIG. 20 is a diagram for explaining a method for calculating the replenishment product data by the replenishment product generating unit of the supplier replenishment management device according to the embodiment. [Figure 21] FIG. 21 is a diagram illustrating an example of a replenishment product data table calculated by the replenishment product generation unit of the supplier replenishment management device according to the embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0012] Hereinafter, 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 in detail with reference to the drawings. Note that the present invention is not limited to the embodiment.

[0013] [1. Configuration] An example of the configuration of a supplier compensation management device according to this embodiment will be described with reference to Fig. 1 etc. Fig. 1 is a schematic diagram showing an overview in a block diagram of an example of the configuration of a supplier compensation management device.

[0014] 1 is a commercially available desktop personal computer. The supplier replenishment management 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.

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

[0016] The communication interface unit 104 communicatively connects the supplier replenishment 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 other devices via the 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). The data stored in the memory unit 106 may be stored in the server 200, for example.

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

[0018] The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used as the storage unit 106. The storage unit 106 stores an application condition master 106a, a compensation salon list master 106b, a compensation condition master 106c, a basic information master 106d, a product master 106e, customer sales performance data 106f, sales performance data 106g, and purchase performance data 106h.

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

[0020] 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, an applicable condition code "0" is associated with an applicable condition name "common to group 2" and stored.

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

[0022] FIG. 3 is a diagram showing an example of a compensation salon list master table in the compensation salon list master 106b. As shown in FIG. 3, the first row of the compensation salon list master table T2 stores a rebate group 2 (second rebate group) "00100020", a rebate group 1 (first rebate group) "00100025", a customer code "10001085", and an application condition "1: common to group 1" in association with each other. Note that the application condition can be selected from any of the application conditions in the application condition master table T1 of the application condition master 106a. Specifically, the first to third rows and the eighth to tenth rows in the compensation salon list master table T2 store the settings of the rebate group 1 and the rebate group 2. For this reason, in the first to third rows and the eighth to tenth rows in the compensation salon list master table T2, the applicable conditions are selected from group 2 common, group 1 common, and customer specific, and are stored and stored.

[0023] Also, as shown in Figure 3, in the fourth row of the compensation salon list master table T2, there is no setting for rebate group 1, so "Group 1 common" cannot be selected as the application condition, and "0: Group 2 common" is selected, stored, and memorized.

[0024] 3, the fifth and sixth rows in the compensation salon list master table T2 do not have a setting for rebate group 2. For this reason, the fifth and sixth rows in the compensation salon list master table T2 do not allow the selection of "group 2 common" as an application condition, and 1: group 1 common and 2: recipient specific are selected and stored.

[0025] 3, in the 6th and 7th rows in the compensation salon list master table T2, there is no setting for rebate group 2. Therefore, in the 6th and 7th rows in the compensation salon list master table T2, 2: Destination specific is selected and stored as the application condition.

[0026] The compensation condition master 106c stores in association with each other the first rebate group, the second rebate group, the customer code, the start date, the end date, the supplier manufacturer code, the brand, the series, the major category, the medium category, the product code, the type of compensation, the cash compensation rate, and the product compensation rate.

[0027] 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. 4, rebate group 2 (second rebate group) "00100020", rebate group 1 (first rebate group) "001000025", customer code "00000000", start date "2000 / 01 / 01", end date "2099 / 12 / 31", supplier manufacturer code "001", major category "001", compensation type "0: not applicable", cash compensation rate "0.00%", and product compensation rate "0.00%" are stored in association with each other.

[0028] The basic information master 106d stores the accounting month. 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" that is the basis of the calculation target month.

[0029] The product master 106e stores and manages product codes, product names, brands, series, major categories, intermediate categories, purchase prices, and supplier manufacturer codes in association with each other.

[0030] Fig. 6 is a diagram showing an example of a product master table in the product master 106e. In the first row of the product master table T5 shown in Fig. 6, a product code "111111", a product name "product name A", a brand "1", a series "11", a major category "001", a middle category "11", a purchase price "200", and a supplier manufacturer code "001" are stored in association with each other.

[0031] The customer sales performance data 106f stores sales performance data for each customer, in which a customer code is associated with at least the accounting month, product code, supplier manufacturer, brand, series, major category, medium category, sales volume, sales price, and purchase price.

[0032] Fig. 7 is a diagram showing an example of a customer sales performance data table in customer sales performance data 106f. Fig. 8 is a diagram showing an example of a customer sales performance data table in customer sales performance data 106f. Fig. 7 shows an example of a sales performance data table for customer code "10001085", and Fig. 8 shows an example of a sales performance data table for customer code "10001086".

[0033] The first row of customer sales performance data table T6 in Figure 7 stores the customer code "10001085" in association with the accounting month "2021 / 08", product code "111111", supplier manufacturer "001", brand "1", series "11", major category "001", medium category "11", sales quantity "1", sales price "1,000", and purchase price "200".

[0034] In addition, the first row of the customer sales performance data table T7 in Figure 8 stores the customer code "10001086" in association with the accounting month "2021 / 08", product code "111111", supplier manufacturer "001", brand "1", series "11", major category "001", medium category "11", sales quantity "1", sales price "1,000", and purchase price "200".

[0035] The sales performance data 106g stores, for each product code, a processing month, a supplier manufacturer code, a product code, a sales performance number, and a sales amount in association with each other.

[0036] 9 is a diagram showing an example of a sales performance data table in the sales performance data 106g. In the first row of the sales performance data table T8 shown in FIG. 9, the processing month "2021 / 09", the supplier manufacturer code "001", the product code "333333", the sales performance number "300", and the sales amount "3,000" are stored in association with each other.

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

[0038] 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", the sales amount "500", and the purchase amount "600,000" are stored in association with each other.

[0039] Returning to FIG. 1, the description of the configuration of the supplier replenishment management apparatus 100 will be continued. The control unit 102 is a CPU or the like that performs overall control of the supplier replenishment management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, and the like, and executes various information processing based on these stored programs. The control unit 102 includes an acquisition unit 102a, a replenishment performance calculation unit 102b, a linking unit 102c, a replenishment product generation unit 102d, and a display control unit 102e.

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

[0041] The compensation actual result calculation unit 102b calculates compensation actual result schedule data by referring to the compensation salon list master 106b, the compensation condition master 106c, the product master 106e, and the customer sales actual result data 106f. The compensation actual result calculation unit 102b also generates compensation actual result schedule data for each supplier based on the compensation actual result schedule data, the calculation target month inputted to the calculation target month screen P2 of the compensation total result, and the supplier manufacturer code, and outputs the compensation actual result schedule data for each supplier manufacturer to each supplier manufacturer.

[0042] The linking unit 102c executes a linking process to generate and output sales record base data and purchase record base data for reference in consideration of compensation products by linking the sales record data 106g, the purchase record data 106h, and the product code. The linking unit 102c also outputs at least one of the sales record base data and the purchase record base data to the monitor 114.

[0043] The compensation product generating unit 102d generates compensation product data in which the compensation request quantity of compensation products is determined for each supplier manufacturer and product code, based on the compensation actual result schedule data generated by the compensation actual result calculating unit 102b.

[0044] The display control unit 102e refers to the basic information master 106d, and causes the monitor 114 to display a calculation target month screen. Furthermore, the display control unit 102e causes the monitor 114 to display a calculation target month screen for the compensation tally results.

[0045] [2. Overview of replenishment product request using supplier replenishment management device 100] Next, an outline of a replenishment product request using the supplier replenishment management device 100 will be described. FIG. 11 is a diagram for explaining a schematic outline of a replenishment product request using the supplier replenishment management device 100.

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

[0047] 11B, the supplier replenishment management device 100 acquires customer sales record data 106f from the customer salon (step S3), and generates replenishment record plan data including the cash replenishment amount and the product replenishment amount using the customer sales record data 106f (step S4). The method of generating the replenishment record plan data will be described later in detail.

[0048] Thereafter, as shown in FIG. 11B, the supplier replenishment management device 100 transmits the compensation performance plan data including the cash replenishment amount and the merchandise replenishment amount to the supplier manufacturer (step S5). This allows a prompt reply to inquiries from the supplier manufacturer regarding the compensation content. In this case, the supplier manufacturer checks the compensation performance plan data sent from the supplier replenishment management device 100, and if it is approved, contacts the supplier manufacturer to indicate that it approves the compensation performance plan data.

[0049] Next, as shown in (C) of FIG. 11, the supplier replenishment management device 100 determines the products and numbers of products to be replenished based on the product replenishment amount in the replenishment actual plan data, and generates product replenishment plan data for requesting product replenishment from the supplier manufacturer (step S6), and makes a product replenishment request by sending the product replenishment plan data to the supplier manufacturer (step S7).

[0050] Thereafter, as shown in FIG. 11(D), the company that manages the supplier replenishment management device 100 receives the replenishment goods from the purchasing manufacturer (step S8).

[0051] 3. Processing Executed by Supplier Replenishment Management Device 100 Next, a description will be given of the processing executed by the supplier replenishment management apparatus 100. FIG 12 is a flowchart showing an outline of the processing executed by the supplier replenishment management apparatus 100.

[0052] As shown in FIG. 12, first, the display control unit 102e refers to the basic information master 106d and displays the calculation target month screen on the monitor 114 (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 the calculation target month and an execution button B1 for instructing execution. In FIG. 13, "2021 / 09" is entered in cell K1, but the accounting month of the basic information master 106d, for example, "2021 / 10", is displayed in the initial display. In addition, the calculation target month can be changed from the accounting month in the basic information master 106d to the previous month (-1 month).

[0053] Next, the acquisition unit 102a acquires customer sales performance data 106f corresponding to the calculation target month for each customer based on the calculation target month selected in cell K1 on the calculation target month screen P1 from the storage unit 106 (step S102). For example, the customer sales performance data table T6 of FIG. 7 and the customer sales performance data table T7 of FIG. 8 are acquired from the storage unit 106.

[0054] Thereafter, the compensation actual result calculation unit 102b refers to the compensation salon list master 106b, the compensation condition master 106c, the product master 106e, and the customer sales actual result data 106f, and calculates the compensation actual result schedule data (step S103).

[0055] Fig. 14 is a diagram for explaining the outline of the compensation schedule calculation method by the compensation achievement calculation unit 102b. In Fig. 14, the compensation amount calculation content for the customer "10001085" is explained first, and then the compensation amount calculation content for the customer "10001086" is explained.

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

[0057] Specifically, the compensation actual calculation unit 102b determines that the second row (2) and the third row (3) in the customer sales actual data table T6 meet the conditions but the compensation type is not applicable because the brand, series, subcategory, and product code are not specified in the compensation condition master table T3 and only the major category is specified.

[0058] In response to this, the compensation performance calculation unit 102b determines that only the supplier in the fourth row (4) in the customer sales performance data table T6 meets condition (B) because the brand, series, subcategory, and product code are not specified in the compensation condition master table T3, and only the major category is specified.

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

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

[0061] Specifically, the compensation actual calculation unit 102b determines that the second row (2) and the third row (3) in the customer sales actual data table T7 meet the conditions but the compensation type is not applicable because the brand, series, subcategory, and product code are not specified in the compensation condition master table T3 and only the major category is specified.

[0062] In response to this, the compensation history calculation unit 102b determines that the supplier in the fourth row (4) in the customer sales history data table T7 meets the condition (E). Therefore, the compensation history calculation unit 102b calculates the planned cash compensation amount in the fourth row (4) using the following formula (3). Expected cash compensation amount = (3 × 2000) × 0.10 = 600 (3)

[0063] 14, the compensation history calculation unit 102b determines that the fifth row (5) in the customer sales actual data table T7 matches the condition (C). Therefore, the compensation history calculation unit 102b calculates the planned cash compensation amount and the planned product compensation amount in the fifth row (5) using the following formulas (4) and (5). Expected cash compensation amount = (4 × 2000) × 0.08 = 640 (4) Expected product reimbursement amount = (4 × 2000) × 0.25 = 2000 (5)

[0064] In this way, the reimbursement actual result calculation unit 102b calculates the planned cash reimbursement amount and the planned merchandise reimbursement amount for each customer and each supplier, and generates planned reimbursement actual result data that corresponds, for each supplier, the processing month, the planned cash reimbursement amount, and the planned merchandise reimbursement amount.

[0065] FIG. 15 is a diagram showing an example of a compensation performance planned data table in the compensation performance planned data generated by the compensation performance calculation unit 102b. As shown in FIG. 15, the compensation performance planned data table T10 stores, for each supplier, a processing month, a supplier manufacturer code, a customer code, a cash compensation amount, and a product compensation amount in association with each other. Specifically, the first row of the compensation performance planned data table T10 stores the processing month "2021 / 09", the supplier manufacturer code "001", the customer code "10001085", the cash compensation amount "1,200", and the product compensation amount "900" in association with each other. This allows the user to quickly respond based on the compensation performance planned data table T10 even if the supplier manufacturer makes an inquiry about the compensation content.

[0066] Returning to FIG. 12, the description of step S104 and subsequent steps will be continued. In step S104, the display control unit 102e displays the calculation target month screen of the compensation tally actual results on the monitor 114. FIG. 16 is a diagram showing an example of the calculation target month screen of the compensation tally actual results. The calculation target month screen P2 of the compensation tally actual results includes a cell K11 for selecting the calculation target month, supplier code cells K12 and K13 for inputting the supplier manufacturer code, an output destination cell K14 for inputting the output destination, and an execution button B1 for instructing execution. In FIG. 16, "2021 / 09" is input in the cell K11, but in the initial display, the accounting month of the basic information master 106d, for example, "2021 / 10", is displayed. In addition, the calculation target month can be changed from the accounting month in the basic information master 106d to the previous month (-1 month).

[0067] Next, the compensation actual results calculation unit 102b generates compensation actual results plan data that determines the number of compensation requests for compensation products for each supplier manufacturer and product code based on the compensation actual results plan data, the calculation month entered in the calculation month screen P2 for the compensation summary actual results, and the supplier manufacturer code (step S105), and outputs the compensation actual results plan data for each supplier manufacturer to each supplier manufacturer (step S106).

[0068] FIG. 17 is a diagram showing an example of compensation actual result schedule data of a supplier. FIG. 18 is a diagram showing an example of compensation actual result schedule data of another supplier. As shown in FIG. 17 and FIG. 18, the compensation actual result calculation unit 102b generates at least one of the compensation actual result schedule data table T11 of FIG. 17 and the compensation actual result schedule data table T12 of FIG. 18 based on the compensation actual result schedule data, the calculation target month inputted to the calculation target month screen P2 of the compensation total result, and the supplier manufacturer code, and transmits it to each supplier manufacturer. This allows each supplier manufacturer to confirm the compensation amount.

[0069] Thereafter, the linking unit 102c executes a linking process to link the sales record data 106g, the purchase record data 106h, and the product code to generate and output sales record base data and purchase record base data to be referenced for considering replacement products (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).

[0070] Fig. 19 is a diagram for explaining the outline of the linking process by the linking unit 102c. As shown in Fig. 19, the linking unit 102c refers to the sales record data table T8 and the purchase record data table T9 of the designated institution, and generates the sales record base data table T21 and the purchase record base data table T22 by linking with the purchase record data table T9 by the product code.

[0071] The sales record-based data table T21 is a data table in which the top-selling products in the past sales records are linked to the purchase record data table T9 by product code, and the sales records are integrated with the purchase record data 106h by product code in order of sales quantity.

[0072] In addition, the purchase record base data table T22 is a data table in which the top-ranked products in past purchase records for compensation consideration are linked to sales records by product code, and the purchase records are integrated with the sales record data 106g by product code in sequential order of quantity.

[0073] This allows the user to know the best-selling compensation items by checking at least one of the sales record-based data table T21 and the purchase record-based data table T22.

[0074] Returning to FIG. 12, the description of step S109 and subsequent steps will be continued. In step S109, the compensation product generating unit 102d generates compensation product data based on the compensation achievement plan data generated by the compensation achievement calculation unit 102b.

[0075] Fig. 20 is a diagram for explaining a method for calculating the compensation product data by the compensation product generating unit 102d Fig. 21 is a diagram showing an example of a compensation product data table calculated by the compensation product generating unit 102d.

[0076] 20 and 21, the compensation product generation unit 102d generates the compensation product data table T31 by calculating the compensation target this time based on the product compensation amount D1 in the compensation result schedule data table T10. In this case, the compensation product generation unit 102d references the sales result base data table T21, the purchase result base data table T22, and the product master table T5 generated by the above-mentioned linking unit 102c, and calculates the best-selling products or priority sales products to be the products to be compensated this time, and generates the compensation product data table T31.

[0077] Next, the replenishment product generating unit 102d outputs the replenishment product data to each supplier manufacturer (step S110). After step S110, the supplier replenishment management device 100 ends this process.

[0078] According to the embodiment described above, the compensation product generation unit 102d generates compensation product data that determines the number of compensation products requested for each supplier manufacturer and product code based on the compensation actual result planned data generated by the compensation actual result calculation unit 102b, so that the compensation status for each product can be easily confirmed.

[0079] In addition, according to the embodiment, since the compensation actual amount calculation unit 102b generates compensation actual amount plan data for each supplier manufacturer, it is possible to promptly respond with the cash compensation amount and the merchandise compensation amount for each supplier manufacturer, thereby preventing delays in merchandise and cash compensation and missed requests.

[0080] Furthermore, according to the embodiment, the compensation product generating unit 102d generates compensation product data for each supplier marker, so that compensation product requests can be promptly made for each supplier manufacturer.

[0081] Furthermore, according to the embodiment, since the compensation calculation unit 102b generates compensation plan data for each supplier manufacturer, it is possible to calculate a detailed cash compensation amount and a merchandise compensation amount.

[0082] Furthermore, according to the embodiment, since the linking unit 102c generates at least one of sales record-based data and purchase record-based data, it is possible to confirm the top sales record for compensation consideration or the top purchase record for compensation consideration.

[0083] According to the embodiment, the compensation product generating unit 102d generates compensation product data based on at least one of the sales performance base data and purchase performance base data generated by the linking unit 102c and the compensation performance plan data by the compensation performance calculation unit 102b, and generates compensation product data that takes into account the sales performance base data and purchase performance base data, so that best-selling products or priority selling products are used to compensate for the products to be compensated this time. This allows the supplier manufacturer to treat them as sales expenses like sample products, and can be used for market trend analysis and adjustment.

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

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

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

[0087] 5. 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.

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

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

[0090] Moreover, with regard to the supplier replenishment management device 100, the components shown in the figures are merely conceptual in function, and do not necessarily have to be physically configured as shown in the figures.

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

[0092] In addition, this computer program may be stored in an application program server connected to the supplier replenishment management device 100 via any network, and it is also possible to download all or part of it as needed.

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

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

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

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

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

[0098] The present invention is useful in the beauty industry and the like for replenishing products. [Explanation of symbols]

[0099] 100 Supplier Replenishment Management Device 102 Control section 102a Acquisition Department 102b Compensation Performance Calculation Department 102c String section 102d Compensation Product Generation Department 102e Display control unit 104 Communication interface section 106 Storage section 106a Application Condition Master 106b Compensation Salon List Master 106c Compensation Condition Master 106d Basic Information Master 106e Product Master 106f Customer sales performance data 106g Sales performance data 106h Purchase performance data 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

1. A supplier replenishment management device including a control unit, Customer sales performance data for each customer, in which at least the accounting month, product code, supplier manufacturer, sales volume, sales price, and purchase price are associated with the customer code; a compensation salon list master in which a first rebate group, a second rebate group, and application conditions are associated with a customer code; A compensation condition master in which at least a first rebate group, a second rebate group, a customer code, a supplier manufacturer, a product code, a compensation type, a cash compensation rate, and a product compensation rate are associated with each other; A product master that associates at least a product code, a purchase price, and a supplier manufacturer; Sales performance data in which product codes, sales performance numbers, and sales amounts are associated with each other for each supplier manufacturer; Purchase record data in which product codes, purchase record quantities, and purchase amounts are associated with each other for each supplier manufacturer; a memory unit that stores the The control unit is a display control unit that displays on a monitor a calculation target month screen that accepts input of a calculation target month; an acquisition unit that acquires, from the storage unit, customer sales performance data for each customer according to the calculation target month input on the calculation target month screen; a compensation actual calculation unit that generates compensation actual plan data including a calculation result of calculating a cash compensation amount and a product compensation amount by referring to the compensation salon list master, the compensation condition master, the product master, and the customer sales actual data; a compensation product generating unit that generates compensation product data in which a compensation request number of compensation products is determined for each supplier manufacturer and product code based on the compensation performance plan data; Equipped with The compensation achievement calculation unit is Refer to the compensation type and the supplier manufacturer in the compensation condition master, and determine whether or not at least one of the compensation type and the supplier manufacturer matches each of the customer sales performance data for each customer according to the calculation target month; Refer to the cash compensation rate and the merchandise compensation rate in the compensation condition master, and multiply the amount obtained by multiplying the sales price and the sales volume in the customer sales actual data for each customer for which at least one of the compensation type and the supplier matches by the cash compensation rate and the merchandise compensation rate, thereby generating the compensation actual plan data in which the cash correction planned amount and the merchandise compensation planned amount are calculated for each target month and for each customer for each supplier, The compensation product generation unit: generating the compensation product data in which the number of compensation requests to be compensated this time is determined based on the product compensation amount in the compensation actual result plan data, the sales actual number in the sales actual result data, and the purchase actual number in the purchase actual result data, with reference to the product master, the sales actual data, and the purchase actual number in the purchase actual result data; A supplier replenishment management device characterized by the above.

2. The supplier replenishment management device according to claim 1, a linking unit that generates at least one of sales record base data in which the sales record number of the sales record data and the purchase record number of the purchase record data are linked to a product code and arranged in order of sales volume, the sales record base data being integrated with the purchase record data, and purchase record base data in which the purchase record data and the sales record data are linked to a product code and arranged in order of purchase volume, the purchase record base data being integrated with the sales record data; A supplier replenishment management device characterized by the above.

3. The supplier replenishment management device according to claim 2, The compensation product generation unit, generating the compensation product data based on at least one of the sales record base data and the purchase record base data and the compensation record plan data; A supplier replenishment management device characterized by the above.

4. The supplier replenishment management device according to claim 3, The compensation achievement calculation unit is generating the compensation achievement plan data corresponding to the calculation target month inputted on the calculation target month screen; A supplier replenishment management device characterized by the above.

5. A supplier replenishment management method executed by a supplier replenishment management device having a control unit, Customer sales performance data for each customer, in which at least the accounting month, product code, supplier manufacturer, sales volume, sales price, and purchase price are associated with the customer code; a compensation salon list master in which a first rebate group, a second rebate group, and application conditions are associated with a customer code; A compensation condition master in which at least a first rebate group, a second rebate group, a customer code, a supplier manufacturer, a product code, a compensation type, a cash compensation rate, and a product compensation rate are associated with each other; A product master that associates at least a product code, a product name, a subcategory, a purchase price, and a supplier manufacturer; Sales performance data in which product codes, sales performance numbers, and sales amounts are associated with each other for each supplier manufacturer; Purchase record data in which product codes, purchase record quantities, and purchase amounts are associated with each other for each supplier manufacturer; a memory unit that stores the Executed by the control unit, a display control step of displaying on a monitor a calculation target month screen for receiving an input of a calculation target month; an acquisition step of acquiring, from the storage unit, customer sales performance data for each customer corresponding to the calculation target month inputted on the calculation target month screen; a compensation actual calculation step of generating compensation actual plan data including a calculation result of calculating a cash compensation amount and a product compensation amount by referring to the compensation salon list master, the compensation condition master, the product master, and the customer sales actual data; a compensation product generating step of generating compensation product data in which a compensation request number of compensation products is determined for each supplier manufacturer and product code based on the compensation performance plan data; Including, The compensation achievement calculation step includes: Refer to the compensation type and the supplier manufacturer in the compensation condition master, and determine whether or not at least one of the compensation type and the supplier manufacturer matches each of the customer sales performance data for each customer according to the calculation target month; Refer to the cash compensation rate and the merchandise compensation rate in the compensation condition master, and multiply the amount obtained by multiplying the sales price and the sales volume in the customer sales actual data for each customer for which at least one of the compensation type and the supplier matches by the cash compensation rate and the merchandise compensation rate, thereby generating the compensation actual plan data in which the cash correction planned amount and the merchandise compensation planned amount are calculated for each target month and for each customer for each supplier, The compensation product generation step is as follows: generating the compensation product data in which the number of compensation requests to be compensated this time is determined based on the product compensation amount in the compensation actual result plan data, the sales actual number in the sales actual result data, and the purchase actual number in the purchase actual result data, with reference to the product master, the sales actual data, and the purchase actual number in the purchase actual result data; A supplier replenishment management method characterized by the above.

6. A supplier replenishment management program to be executed by a supplier replenishment management device having a control unit, Customer sales performance data for each customer, in which at least the accounting month, product code, supplier manufacturer, sales volume, sales price, and purchase price are associated with the customer code; a compensation salon list master in which a first rebate group, a second rebate group, and application conditions are associated with a customer code; A compensation condition master in which at least a first rebate group, a second rebate group, a customer code, a supplier manufacturer, a product code, a compensation type, a cash compensation rate, and a product compensation rate are associated with each other; A product master that associates at least a product code, a product name, a subcategory, a purchase price, and a supplier manufacturer; Sales performance data in which product codes, sales performance numbers, and sales amounts are associated with each other for each supplier manufacturer; Purchase record data in which product codes, purchase record quantities, and purchase amounts are associated with each other for each supplier manufacturer; a memory unit that stores the To cause the control unit to execute a display control step of displaying on a monitor a calculation target month screen for receiving an input of a calculation target month; an acquisition step of acquiring, from the storage unit, customer sales performance data for each customer corresponding to the calculation target month inputted on the calculation target month screen; a compensation actual calculation step of generating compensation actual plan data including a calculation result of calculating a cash compensation amount and a product compensation amount by referring to the compensation salon list master, the compensation condition master, the product master, and the customer sales actual data; a compensation product generating step of generating compensation product data in which a compensation request number of compensation products is determined for each supplier manufacturer and product code based on the compensation performance plan data; Including, The compensation achievement calculation step includes: Refer to the compensation type and the supplier manufacturer in the compensation condition master, and determine whether or not at least one of the compensation type and the supplier manufacturer matches each of the customer sales performance data for each customer according to the calculation target month; Refer to the cash compensation rate and the merchandise compensation rate in the compensation condition master, and multiply the amount obtained by multiplying the sales price and the sales volume in the customer sales actual data for each customer for which at least one of the compensation type and the supplier matches by the cash compensation rate and the merchandise compensation rate, thereby generating the compensation actual plan data in which the cash correction planned amount and the merchandise compensation planned amount are calculated for each target month and for each customer for each supplier, The compensation product generation step is as follows: generating the compensation product data in which the number of compensation requests to be compensated this time is determined based on the product compensation amount in the compensation actual result plan data, the sales actual number in the sales actual result data, and the purchase actual number in the purchase actual result data, with reference to the product master, the sales actual data, and the purchase actual number in the purchase actual result data; A supplier compensation management program featuring:

Images