JP2023072782A - Procurement destination selection support device, procurement destination selection support method, and procurement destination selection support program - Google Patents

Abstract

To provide a procurement destination selection support device, a procurement destination selection support method, and a procurement destination selection support program for supporting selection of a procurement destination that can prevent excess procurement and an excess stock and the like, while ensuring demanded items necessary for products.SOLUTION: A procurement destination selection support device 10 comprises: a supply source information acquisition unit 151 that acquires supply number unit information indicating a supply number unit that is the number of demanded items that are necessary for production of products and can be delivered in one delivery; a demanded item number information acquisition unit 153 that acquires demanded item number information indicating a demanded item number that is the number of demanded items necessary in a unit period; and a procurement destination candidate selection unit 154 that acquires a first order number prediction value in the unit period when the demanded items are procured from a first supply source from among supply sources on the basis of the demanded item number and the supply number unit and a second order number prediction value in the unit period when the demanded items are procured from a second supply source different from the first supply source from among the supply sources, and selects the first supply source in which the first order number prediction value becomes less than the second order number prediction value as a candidate for a procurement destination.SELECTED DRAWING: Figure 3

Description

The present disclosure relates to a supplier selection support device, a supplier selection support method, and a supplier selection support program.

It is necessary to select suppliers of demand items such as parts and materials used to produce products. For example, Patent Document 1 discloses a supplier decision support device that evaluates candidate suppliers from multiple perspectives such as quality, cost, delivery date, transaction status, and items handled, and extracts the highest-rated supplier as a candidate. disclosed.

JP 2019-149109 A

In general, suppliers that supply demanded goods set limits on the minimum quantity of demanded goods that can be delivered in one delivery. For this reason, each base orders more demand items than necessary for one delivery. As a result, there is a risk that the same demanded product will be over-procured or overstocked throughout the company.

The present disclosure has been made in view of the above problems, and aims to support the selection of suppliers that can suppress over-procurement, excess inventory, etc. while securing demand products necessary for products.

In order to achieve the above object, the supplier selection support device of the present disclosure includes a supplier information acquisition unit, a demanded item quantity information acquisition unit, and a candidate supplier selection unit. The supply source information acquisition unit acquires supply quantity unit information indicating a supply quantity unit that is the quantity of the demanded product that can be delivered in one delivery from each of a plurality of supply sources that can supply the demanded product necessary for the production of the product. to get The demanded product quantity information acquisition unit acquires demanded product quantity information indicating the demanded product quantity, which is the quantity of demanded products required for a unit period. A supplier candidate selection unit selects a first order quantity forecast value in a unit period when the demanded product is procured from the first supply source out of the supply sources based on the demanded product quantity and the supply quantity unit, and the supply source candidate Acquire the second forecasted order quantity in the unit period when the demanded goods are procured from a second supply source different from the first supply source, and the first Select suppliers as candidates for procurement.

According to the present disclosure, a supplier whose first order quantity forecast in a unit period when procuring demand items is less than the second order quantity forecast value in a unit period when procuring demand items from another supply source is Selected as a candidate for procurement. Therefore, it is possible to support the selection of a supplier that can suppress over-procurement, excess inventory, etc. while securing the demanded products necessary for the production of the product.

The figure which shows the outline|summary of the supplier selection support system which concerns on Embodiment 1. Block diagram showing configuration of supplier selection support device according to Embodiment 1 Block diagram showing functions of the supplier selection support device according to the first embodiment A diagram showing an example of a supplier information storage unit according to the first embodiment. A diagram showing an example of a demand item information storage unit according to the first embodiment. A diagram showing an example of a product production quantity information storage unit according to the first embodiment. A diagram showing an example of an order quantity forecast information storage unit according to the first embodiment A diagram showing an example of an initial screen according to the first embodiment A diagram showing an example of a supplier information input screen according to the first embodiment A diagram showing an example of a demand item information input screen according to the first embodiment A diagram showing an example of a condition designation screen according to the first embodiment. A diagram showing an example of a candidate presentation screen according to Embodiment 1 A diagram showing another example of the candidate presentation screen according to the first embodiment Flowchart showing supplier selection support processing according to the first embodiment Flowchart showing the first half of candidate selection processing according to Embodiment 1 Flowchart showing second half of candidate selection process according to Embodiment 1 Block diagram showing functions of a supplier selection support device according to the second embodiment A diagram showing an example of a supplier information input screen according to the second embodiment The figure which shows an example of the supplier information storage part which concerns on Embodiment 2. Flowchart showing the second half of the candidate selection process according to the second embodiment Flowchart showing adjustment processing according to Embodiment 2 Block diagram showing functions of supplier selection support device according to Embodiment 3 A diagram showing an example of a scenario information storage unit according to the third embodiment A diagram showing an example of a product production quantity information storage unit according to the third embodiment A diagram showing an example of an order quantity prediction information storage unit according to the third embodiment A diagram showing an example of a candidate presentation screen according to the third embodiment

Embodiments of a supplier selection support device, a supplier selection support method, and a supplier support program according to the present disclosure will be described below with reference to the drawings.

[Embodiment 1]
With reference to FIG. 1, an overview of a supplier support system 1 for supporting the selection of suppliers of demand items necessary for production of products will be described.

The supplier support system 1 includes a supplier selection support device 10 for supporting the selection of a supplier of demand goods. Demand items are, for example, parts, materials, etc. that are necessary for production of products at a plurality of production bases owned by a certain company. Demand items are procured from multiple supply sources that handle demand items. In the following, the embodiment will be described assuming that the product is a product such as a home appliance manufactured from a certain raw material, and the demand item is a part that constitutes the product.

A product manufactured at a production base consists of multiple parts. In the present embodiment, at least one of a plurality of parts constituting products manufactured at different production bases is the same. Identical parts refer to parts of the same type and with the same model number. The products produced at each production base may be of the same type or may be of different types.

The production base has a production base server Sv that stores production plan information J. FIG. The production plan information J is information on a production plan for products to be produced at the production base. The production plan information J includes information such as product production dates and product production quantities. The production plan information J, for example, is registered in the production base server Sv by the production manager of the production base.

The supplier selection support device 10 selects candidates for new parts suppliers based on the production plan information J from the production base server Sv and presents them to the user. Hereinafter, the new supplier will be referred to as "new supplier".

Next, a method of presenting candidates for new suppliers will be described with reference to the configuration of the supplier selection support device 10. FIG.

As shown in FIG. 2, the supplier selection support device 10 includes an operation unit 11 that receives user operations, a display unit 12 that displays images, a communication unit 13 that transmits and receives various data, and executes various processes. a processor 15, a main storage device 16 used as a work area for the processor 15, and an auxiliary storage device 17 for storing various data such as programs.

The operation unit 11 receives an operation by a user and outputs a signal according to the operation to the processor 15 . The operation unit 11 includes a touch sensor, keyboard, mouse, and the like.

The display unit 12 displays an image based on the signal output from the processor 15 . The display unit 12 includes, for example, a liquid crystal display, an organic EL (Organic Electro Luminescence) display, and the like.

The communication unit 13 transmits and receives data under the control of the processor 15 . The communication unit 13 includes a communication device that performs communication conforming to communication standards such as Ethernet (registered trademark) and USB (Universal Serial Bus).

The processor 15 includes an MPU (Micro Processing Unit), a CPU (Central Processing Unit), and the like.

The main memory device 16 includes a RAM (Random Access Memory).

The auxiliary storage device 17 includes non-volatile memory such as flash memory, HDD (Hard Disk Drive), and SDD (Solid State Drive).

As shown in FIG. 3, the auxiliary storage device 17 includes a storage unit 170 that stores information necessary for presenting candidates for new suppliers.

The storage unit 170 includes a supplier information storage unit 171 that stores supplier information, a demand product information storage unit 172 that stores demand product information, a product production quantity information storage unit 173 that stores product production quantity information, and an order processing unit. and an order quantity prediction information storage unit 174 for storing quantity prediction information.

As shown in FIG. 4, the supplier information storage unit 171 stores supplier information including information indicating a supply quantity unit, a so-called lot, which is the minimum quantity of parts that can be delivered in one delivery from the supplier. More specifically, the supplier information storage unit 171 stores supplier code information 171a indicating the identification information of the supplier of the parts, part code information 171b indicating the identification information of the parts supplied from the supplier, and the parts of the supplier. The delivery frequency information 171c indicating the delivery frequency and the supply quantity unit information 171d indicating the supply quantity unit are associated and stored.

In the example shown in FIG. 4, the parts delivery capability is shown for each supply source. For example, the supplier with the supplier code "S001" can deliver the part with the part code "B001" once every seven days, and the minimum quantity of parts that can be delivered in one delivery is 1000 pieces.

In addition, the example shown in FIG. 4 indicates that the same parts can be procured from a plurality of suppliers. For example, the part with the part code "B001" can be procured from the suppliers with the supplier codes "S001", "S002" and "S003".

As shown in FIG. 5, the demanded product information storage unit 172 stores demanded product information including information indicating the quantity of demanded products required for products to be produced at the production base. Specifically, the demanded product information storage unit 172 stores base code information 172a indicating identification information of a production base, product code information 172b indicating identification information of a product to be produced at the production base, and Part code information 172c indicating part identification information, part multiplier information 172d indicating the quantity of parts used in the production of one product, that is, the required quantity of parts for the product, and part supplier identification information. Stored in association with supplier code information 172e.

In the example shown in FIG. 5, the quantity of parts required to produce one product for each production base and the suppliers of the parts are shown. For example, one part with the part code "B001" is required to produce one product with the product code "P001" that is produced in the base code "K001", and the part has the supplier code "S001". sourced from

In addition, the example shown in FIG. 5 shows that even the same parts are supplied from different sources depending on the production base. For example, the supplier of the part with the part code "B001" differs between the site codes "K001" and "K002."

As shown in FIG. 6, the product production quantity information storage unit 173 stores product production quantity information indicating the planned quantity of products to be produced at the production base. More specifically, the product production quantity information storage unit 173 stores base code information 173a indicating the identification information of the production base, product code information 173b indicating the identification information of the product to be produced at the production base, and the plan to produce the product at the production base. Production plan date information 173c indicating the date and production quantity information 173d indicating the planned quantity of products to be produced on the production plan date are stored in association with each other.

The example shown in FIG. 6 shows a production plan for each production base. For example, the production site with the site code "K001" is scheduled to produce "100" units of the product with the product code "P001" on "December 1, 2021."

The product production quantity information can be obtained for each production site by totaling the information stored in the product production quantity information storage unit 173, for example, using the site code information 173a and the product code information 173b. For example, during the unit period from December 1, 2021 to December 30, 2021, the scheduled production quantity of product code "P001" produced at base code "K001", that is, the product production quantity information will be The value of the production quantity information 173d from December 1 to December 30, 2021 can be obtained by aggregating the base code "K001" and the product code "P001".

As shown in FIG. 7, the order quantity prediction information storage unit 174 stores part order quantity prediction information that is a prediction value of the order quantity of parts to be used at the production base. Specifically, the order quantity prediction information storage unit 174 stores ID information 174a that identifies information, calculation date information 174b that indicates the date on which the calculation for obtaining the predicted value of the order quantity of parts was executed, and identification of parts to be selected. part code information 174c indicating information, base code information 174d indicating identification information of the production base using the part to be selected, and identification information of the current supplier who is the current supplier of the part to be selected. Current supplier code information 174e, new supplier code information 174f indicating the identification information of the supply source selected as a candidate for the new supplier, and the predicted value of the order quantity in the unit period when parts are procured from the current supplier. and new order quantity prediction information 174h indicating the predicted value of the order quantity in the unit period when parts are procured from the new supplier are stored in association with each other. The current supplier is the supplier stored in the supplier code information 172e of the demanded product information storage unit 172 described with reference to FIG. 5 as of the calculation date. It should be noted that the ID information 174a is a sequence number added to the execution of the calculation, and the same number is given to the result obtained by one calculation.

The predicted value of the order quantity when procuring parts from the current supplier in the unit period and the predicted value of the order quantity when procuring parts from the new supplier in the unit period are the supply quantity explained with reference to FIG. It is increased or decreased by procuring from different sources of unit, ie, the minimum quantity of demanded products that can be delivered in one delivery.

Hereinafter, the predicted value of the order quantity when procuring parts from the current supplier in the unit period is called the "current order quantity predicted value", and the predicted value of the order quantity when procuring parts from the new supplier in the unit period is It is called "new order quantity forecast value". In this embodiment, the unit period is arbitrary, such as one month, one week, half a year, etc., but hereinafter, it is assumed to be one month. A supplier selected as a candidate for a new supplier corresponds to the "first supplier", and the current supplier corresponds to the "second supplier". Further, the new order quantity forecast value corresponds to the "first order forecast quantity forecast value", and the current order quantity forecast value corresponds to the "second order forecast quantity forecast value".

The current order quantity prediction value and the new order quantity prediction value are the supply quantity unit information 171d described with reference to FIG. 4, the part multiplier information 172d described with reference to FIG. 5, and the description with reference to FIG. It is acquired based on the product production quantity information per unit period.

By executing the supplier support program PG stored in the storage unit 170, the processor 15 shown in FIG. 2, as shown in FIG. An information acquisition unit 151, a demand product information acquisition unit 152 that acquires demand product information, a demand product quantity information acquisition unit 153 that acquires demand product quantity information, a supplier candidate selection unit 154 that selects candidates for new suppliers, and a new It functions as a supplier determination unit 155 that determines a supplier. The processor 15 uses the operation unit 11, the display unit 12, the communication unit 13, the main storage device 16, and the auxiliary storage device 17 shown in FIG. 2 as resources.

The activation unit 150 executes initial screen display processing for causing the display unit 12 to display an initial screen 120 shown in FIG.

The initial screen 120 is a screen displayed first when the supplier support program PG is executed. The initial screen 120 includes a supply source information acquisition button 120a for acquiring supply source information described with reference to FIG. 4 and a demand product information acquisition button for acquiring demand product information described with reference to FIG. 120b, a demanded product quantity information acquisition button 120c for obtaining demanded product quantity information described with reference to FIG. 6, and a new supplier candidate selection button 120d for selecting new supplier candidates.

The supplier information acquisition unit 151 shown in FIG. 3 executes supplier information acquisition processing for acquiring supplier information. After executing the supplier information acquisition process, the supplier information acquisition unit 151 causes the display unit 12 to display, for example, a supplier information input screen 121 shown in FIG.

The supplier information input screen 121 is a screen for accepting input of basic information on the supplier. The supplier information input screen 121 includes a supplier code input field 121a for receiving input of information indicating the supplier code, a part code input field 121b for receiving input of information indicating the part code, and information indicating the delivery frequency of parts. The delivery frequency input field 121c for accepting input, the supply quantity unit input field 121d for receiving input of information indicating the supply quantity unit of parts, and the information entered in each of the input fields 121a to 121d will be described with reference to FIG. and a registration button 121e for registering in the supplier information storage unit 171.

When the registration button 121e is pressed, the supplier information acquisition unit 151 registers the information entered in the input fields 121a to 121d in the supplier information storage unit 171. FIG.

The demand item information acquisition unit 152 shown in FIG. 3 executes demand item information acquisition processing for acquiring demand item information. After executing the demanded product information acquisition process, the demanded product information acquisition unit 152 causes the display unit 12 to display, for example, a demanded product information input screen 122 shown in FIG. 10 .

The demand item information input screen 122 is a screen for accepting input of basic information on demand items. The demand item information input screen 122 includes a site code input field 122a for receiving input of information indicating a site code, a product code input field 122b for receiving input of information indicating a product code, and a part code input field 122b for receiving input of information indicating a part code. A code input field 122c, a parts multiplier input field 122d for receiving input of information indicating a part multiplier, a supplier code input field 122e for receiving input of information indicating a supplier code, and input fields 122a to 122e and a registration button 122f for registering information in the demand product information storage unit 172 described with reference to FIG.

When the registration button 122f is pressed, the demand item information acquisition unit 152 registers the information input in the input fields 122a to 122e in the demand item information storage unit 172. FIG.

The demanded product quantity information acquisition unit 153 shown in FIG. 3 executes demanded product quantity information acquisition processing for acquiring demanded product quantity information indicating the quantity of parts required in a certain production base for a unit period. When the demanded product quantity information acquisition unit 153 executes the demanded product quantity information acquisition process, the production plan information J stored in the production base server Sv of each production base described with reference to FIG. The quantity of products in demand is stored in the product production quantity information storage unit 173 described above, and based on the product production quantity information obtained by aggregating the stored information and the part multiplier information 172d described with reference to FIG. Get information.

The supplier candidate selection unit 154 shown in FIG. 3 executes candidate selection processing for selecting new supplier candidates. The supplier candidate selection unit 154 selects suppliers whose new order quantity prediction value is less than the current order quantity prediction value as new supplier candidates.

The supplier candidate selection unit 154 includes a condition reception unit 154a that accepts specification of conditions such as parts to be selected as new supplier candidates, production bases to be selected as new supplier candidates, and the like. A handling supply source extraction unit 154b that extracts a supply source that handles parts, a current order quantity acquisition unit 154c that acquires the current order quantity prediction value, a new order quantity acquisition unit 154d that acquires the new order quantity prediction value, and a current order quantity acquisition unit 154d. It includes an order quantity comparison unit 154e that compares the quantity prediction value and the new order quantity prediction value, and a candidate presenting unit 154f that presents candidates for new suppliers to the user. The current order quantity acquisition unit 154c corresponds to the "second order quantity prediction value acquisition unit", and the new order quantity acquisition unit 154d corresponds to the "first order quantity prediction value acquisition unit".

The condition receiving unit 154a executes condition receiving processing for receiving conditions for selecting candidates for new suppliers. After executing the condition reception process, the condition reception unit 154a causes the display unit 12 to display, for example, a condition designation screen 123 shown in FIG.

The condition specifying screen 123 is a screen for specifying conditions for selecting candidates for new suppliers. The condition specifying screen 123 includes a part code input field 123a for receiving input of information indicating a part code, a base code input field 123b for receiving input of information indicating a base code, and input of information indicating the start of the production planning period. It includes a production plan start input field 123c for receiving, a production plan end input field 123d for receiving input of information indicating the end of the production plan period, and an execution button 123e for executing selection of new supplier candidates.

The handling supply source extraction unit 154b executes a handling supply source extraction process for extracting information indicating a supply source that handles the parts specified as the condition. When the handling supply source extraction unit 154b executes the handling supply source extraction process, the handling supply source extraction unit 154b extracts the handling of parts specified as a condition from the information stored in the supply source information storage unit 171 described with reference to FIG. Extract information that indicates a source.

For example, when the part code of the part specified as the condition is "B001", the handling supplier extraction unit 154b selects The supplier codes "S001", "S002" and "S003" are extracted as information indicating suppliers that handle the parts specified as the conditions. Hereinafter, the supplier who handles the parts specified as the condition is referred to as the "first supplier".

The current order quantity acquisition unit 154c shown in FIG. 3 executes a current order quantity acquisition process for acquiring current order quantity forecast values of all parts required at all production bases. When the current order quantity acquisition process is executed, the current order quantity acquisition unit 154c acquires the current order quantity based on the quantity of each part required at each production base in the unit period and the supply quantity unit of the current supplier of the part. Get the quantity forecast value. A specific method of obtaining the current order quantity forecast value will be described later.

The new order quantity acquisition unit 154d executes a new order quantity acquisition process for acquiring predicted new order quantity values of all parts required at all production bases. When the new order quantity acquisition process is executed, the new order quantity acquisition unit 154d generates a new order based on the quantity of each part required at each production base in the unit period and the supply quantity unit of the new supplier of the part. Get the quantity forecast value. A specific method of obtaining the new order quantity prediction value will be described later.

The order quantity comparison unit 154e executes order quantity comparison to determine whether or not the new order quantity prediction value of the part specified as the condition is less than the current order quantity prediction value.

The candidate presenting unit 154f executes a candidate presenting process of presenting to the user candidates of new suppliers of parts required for production of the product at the production site. More specifically, when the order quantity comparison unit 154e determines that the new order quantity prediction value of the part specified as the condition is less than the current order quantity prediction value, the candidate presentation unit 154f selects the candidate for the new supplier as the first handling candidate. Present the source to the user. On the other hand, the candidate presenting unit 154f uses the current supplier as a candidate for the new supplier when the order quantity comparison unit 154e determines that the predicted new order quantity for the part designated as the condition is greater than or equal to the current predicted quantity of orders. presented to the person.

After executing the candidate presentation process, the candidate presentation unit 154f causes the display unit 12 to display a candidate presentation screen 124 shown in FIG. 12, for example.

As shown in FIG. 12, the candidate presentation screen 124 displays a list of information stored in the order quantity prediction information storage unit 174 described with reference to FIG. Candidate presentation screen 124 includes item column 124a indicating the content of information, information display column 124b displaying information corresponding to item column 124a, and check column 124c for designating determination of a new supplier.

When the user operates the operation unit 11 to specify items such as the part code and the current supplier code displayed in the item column 124a, the candidate presentation screen 124 displays the specified item and the order quantity forecast. The information stored in the information storage unit 174 is totaled and displayed. For example, in the example shown in FIG. 12, when the user designates a part code as an item to be tabulated, the candidate presentation screen 124 displays the predicted current order quantity and the new order quantity tabulated for each part code, as shown in FIG. Display predicted values in a list. This makes it easy for the user to compare the current order quantity prediction value and the new order quantity prediction value, and to easily determine whether or not to decide the supply source presented as a candidate as a new procurement source.

The supplier determination unit 155 shown in FIG. 3 executes supplier determination processing for determining a supplier specified by the user as a new supplier. In the supplier determination process, the supplier determination unit 155 notifies the relevant parties including the production manager, the person in charge of parts procurement, etc. of the supplier designated by the user as the new supplier. The determined new procurement source is notified to the relevant parties by e-mail, for example. Note that the e-mail addresses of the parties concerned to be notified by e-mail are pre-stored in the storage unit 170 . Storing of the e-mail address in the storage unit 170 is performed by, for example, a system administrator.

The supplier selection support process executed by the supplier selection support device 10 will be described below with reference to FIG.

The supplier selection support process is executed by the user operating the operation unit 11 . The user, for example, adds a new part supplier, adds a new part, and executes the supplier selection support process.

When the supplier selection support process is started, the activation unit 150 causes the display unit 12 to display the initial screen 120 described with reference to FIG. 8 (step S101).

The activation unit 150 determines whether or not an operation for any button included in the initial screen 120 has been accepted (step S102), and waits until an operation for any button is accepted (step S102; No).

When determining that an operation on any button has been received (step S102; Yes), the activation unit 150 determines whether or not the supplier information acquisition button 120a has been pressed (step S103).

When the activation unit 150 determines that the supplier information acquisition button 120a has been pressed (step S103; Yes), the supplier information acquisition unit 151 executes supplier information acquisition processing (step S104). Specifically, the supplier information acquisition unit 151 causes the display unit 12 to display the supplier information input screen 121 described with reference to FIG.

The user operates the operation unit 11 to input information indicating the supplier code, parts code, delivery frequency, and supply quantity unit into the corresponding input fields 121a to 121d, and presses the registration button 121e. As a result, the supplier information acquisition unit 151 acquires information on the supplier code, parts code, delivery frequency, and supply quantity unit as supplier information, and stores the information in the supplier information storage unit 171 described with reference to FIG. register.

On the other hand, when determining that the supply source information acquisition button 120a has not been pressed (step S103 in FIG. 14; No), the activation unit 150 determines whether the demand product information acquisition button 120b has been pressed (step S105).

When the activation unit 150 determines that the demand item information acquisition button 120b has been pressed (step S105; Yes), the demand item information acquisition unit 152 executes demand item information acquisition processing (step S106). Specifically, the demanded product information acquisition unit 152 causes the display unit 12 to display the demanded product information input screen 122 described with reference to FIG.

The user operates the operation unit 11 to input information indicating the base code, product code, parts code, parts multiplier, and supplier code into the corresponding input fields 122a to 122e, and presses the registration button 122f. As a result, the demanded product information acquisition unit 152 acquires the information of the base code, product code, parts code, parts multiplier, and supplier code as demanded product information, and stores the demanded product information storage unit described with reference to FIG. Register with 172.

When the activation unit 150 determines that the demand item information acquisition button 120b has not been pressed (step S105 in FIG. 14; No), it determines whether or not the demand item quantity information acquisition button 120c has been pressed (step S107). ).

When the starting unit 150 determines that the demanded product quantity information acquisition button 120c has been pressed (step S107; Yes), the demanded product quantity information acquisition unit 153 executes demanded product quantity information acquisition processing (step S108). When the demanded product quantity information acquisition unit 153 executes the demanded product quantity information acquisition process, it acquires the production plan information J stored in the production base server Sv of each production base described with reference to FIG. is stored in the product production quantity information storage unit 173 described with reference to . Then, the demanded product quantity information acquisition unit 153 acquires product production quantity information for each production base in a unit period by totalizing the stored information with the base code information 173a and the product code information 173b. Further, the demanded product quantity information acquisition unit 153 multiplies the value indicated by the product production quantity information by the value indicated by the part multiplier information to obtain the quantity of selection target parts required for the unit period at the production site. Hereinafter, the quantity of selection target parts required for a unit period at a production base is referred to as a "demand item quantity".

As a result of aggregating the production volume of the product with the product code "P001" produced by the production base with the base code "K001" for one month from December 1, 2021 to December 31, 2021, the production quantity is In the case of "1500", as shown in FIG. ”. Therefore, the current order quantity acquisition unit 154c acquires the quantity of the parts with the part code “B001” required for the unit period, that is, “1500” which is the result of “1500”ד1” as the demanded product quantity.

When the activation unit 150 determines that the demand item quantity information acquisition button 120c has not been pressed (step S107 in FIG. 14; No), the activation unit 150 determines that the new supplier candidate selection button 120d has been pressed. For example, the user presses the new supplier candidate selection button 120d at the timing of reviewing the parts supplier.

When the activation unit 150 determines that the new supplier candidate selection button 120d has been pressed, the supplier candidate selection unit 154 executes the candidate selection process shown in FIG. 15 (step S109).

When the candidate selection process is started, the condition reception unit 154a causes the display unit 12 to display the condition designation screen 123 described with reference to FIG. 11 (step S201).

The condition accepting unit 154a determines whether or not the specification of the condition is accepted (step S202), and waits until the specification of the condition is accepted (step S202; No).

The user operates the operation unit 11 to input information indicating the parts code, the site code, and the period of the production plan of the parts for which candidates for new suppliers are to be selected in the corresponding input fields 123a to 123d. . For example, the user inputs information indicating one month of part code "B001", base code "K001", and production planning period "December 1, 2021" to "December 31, 2021". Fill in each of the columns 123a to 123d.

Hereinafter, the parts designated as targets for selecting new supplier candidates are referred to as "selected target parts", and the production bases designated as targets for selecting new supplier candidates are referred to as "selected target bases". Note that the selection target base corresponds to the "first production base".

When the user presses the execution button 123e after entering the conditions in the corresponding input fields 123a to 123d, the condition reception unit 154a determines that the condition designation has been received (step S202 in FIG. 15; Yes).

Next, the current order quantity acquisition unit 154c acquires the current order quantity prediction value (step S203). Specifically, the current order quantity acquisition unit 154c acquires the current order quantity forecast value based on the quantity of demanded products and the supply quantity unit of the selection target parts of the current supplier. More specifically, when the remainder obtained by dividing the quantity of demanded products by the supply quantity unit of the parts to be selected by the current supplier is other than "0", the current order quantity obtaining unit 154c adds " 1” is multiplied by the supply quantity unit of the part to be selected from the current supplier, and the value obtained is acquired as the current order quantity forecast value.

For example, when the demanded product quantity is "1500" as obtained by the above calculation, the current supplier of the part with the part code "B001" shown in FIG. 4, the supply quantity unit of the parts with the parts code "B001" of the supplier with the supplier code "S001" is "1000", as shown in FIG. In this case, the quotient obtained by dividing the demanded product quantity "1500" by the supply quantity unit "1000" of the part code "B001" with the supply source code "S001" that can be currently procured is "1", and the remainder is "1". It becomes "500". Since the remainder obtained by the division is other than "0", the current order quantity acquisition unit 154c obtains "2" obtained by adding "1" to the quotient obtained by the division, "1", and the current supplier's "2000" obtained by multiplying the supply quantity unit "1000" of the part to be selected is obtained as the current order quantity prediction value.

On the other hand, if the remainder obtained by the division is "0", the current order quantity acquisition unit 154c multiplies the quotient obtained by the division by the value of the supply quantity unit of the current supplier, and obtains the current value. Obtained as an order quantity forecast value.

For example, if the quantity of demanded goods is "1500" and the unit of quantity supplied by the current supplier of the parts to be selected is "500", the quantity of demanded goods of "1500" is The quotient obtained by dividing by the part supply quantity unit "500" is "3" and the remainder is "0". Since the remainder obtained by the division is "0", the current order quantity acquisition unit 154c multiplies the supply quantity unit of the parts to be selected from the current supplier "500" by the quotient "3". A certain "1500" is acquired as the current order quantity forecast value.

The current order quantity acquisition unit 154c registers the acquired current order quantity prediction value in the current order quantity prediction information 174g described with reference to FIG.

Next, as shown in FIG. 16, the handling supply source extracting unit 154b stores information indicating the first handling supply source, which is a supplier that handles the selection target parts, from the supply source information storage unit described with reference to FIG. 171 is extracted (step S204).

As described above, when the part to be selected is a part with the part code "B001", the handling supplier extraction unit 154b extracts the supplier codes "S001" and "S002" from the supplier information storage unit 171 in FIG. , and “S003” are extracted as information indicating candidates for the first supplier.

Next, the new order quantity acquisition unit 154d acquires the new order quantity prediction value of the selection target parts to be procured from the candidate of the first supply source (step S205 in FIG. 16).

More specifically, the new order quantity acquisition unit 154d acquires the quotient obtained by division when the remainder obtained by division is “0” in the same manner as the current order quantity acquisition unit 154c obtains the current order quantity prediction value. is multiplied by the value of the unit of supply of the parts to be selected from the first supply source, and the value obtained is acquired as the new order quantity prediction value. In addition, when the remainder obtained by division is other than "0", the new order quantity acquisition unit 154d adds "1" to the quotient obtained by division and supply Obtain the value obtained by multiplying by the unit of measure as the new order quantity forecast value.

When a plurality of suppliers are extracted as candidates for the first supply source, the handling supply source extraction unit 154b selects a supply source smaller than the new order quantity prediction value of each of the extracted plurality of supply sources as the first handling supply source. Select and extract. On the other hand, when the candidate for the first handling supply source is one supply source, the handling supply source extraction unit 154b selects that supply source as the first handling supply source (step S206).

Next, the handling supply source extracting unit 154b registers the selected supply source code indicating the first handling supply source as the value of the new supplier code information 174f shown in FIG. The predicted new order quantity of the selected parts of the first supplier is registered as the value of the new order quantity prediction information 174h described with reference to FIG. 7 (step S207).

Next, the order quantity comparison unit 154e compares the new order quantity prediction value of the selection target part with the current order quantity prediction value of the selection target part, and the new order quantity prediction value of the selection target part It is determined whether or not the quantity is less than the predicted quantity (step S208). Hereinafter, the current predicted order quantity of parts to be selected may be referred to as "current predicted value", and the new predicted order quantity of parts to be selected may be referred to as "new predicted value".

When the order quantity comparison unit 154e determines that the new predicted order quantity of the selection target part is less than the current predicted order quantity of the selection target part, that is, the current predicted value > the new predicted value (Step S208; Yes). , the candidate selection process proceeds to step S210.

On the other hand, when the order quantity comparison unit 154e determines that the new predicted order quantity value of the selection target part is greater than or equal to the current predicted order quantity value of the selection target part, that is, the current predicted value = < the new predicted value (step S208; No ), and the candidate of the new supplier of the part to be selected at the base to be selected is returned to the current supplier (step S209). Specifically, the order quantity comparison unit 154e changes the value of the new supplier code information 174f described with reference to FIG. The value of the prediction information 174h is changed to the value of the current order quantity prediction information 174g, and the candidate selection process proceeds to step S210.

In step S210, the candidate presentation unit 154f presents the supplier indicated by the value of the new supplier code information 174f shown in FIG. 7 to the user as a candidate for the new supplier (step S210). The candidate presentation unit 154f causes the display unit 12 to display the candidate presentation screen 124 described with reference to FIG. 12, for example.

The user designates a supplier to be determined as a new supplier by operating the operation unit 11 and checking the check box 124c. For example, the user selects a supplier to be determined as a new supplier by checking the check box 124c in the same row as the row displaying the supplier presented as a candidate for the new supplier explained with reference to FIG. can be specified. If the user does not perform an operation to instruct determination of a new supplier, the supplier presented as a candidate for the new supplier is not determined as the new supplier.

When the user designates a supplier to be determined as a new supplier, the supplier determination unit 155 determines the supplier designated by the user as a new supplier and notifies the parties involved (step S211). This completes the candidate selection process, and returns to step S110 of the supplier selection support process shown in FIG.

In step S110 shown in FIG. 14, candidate selection processing (step S109), supply source information acquisition processing (step S104), demand product information acquisition processing (step S106), and demand product quantity information acquisition processing (step S108) When one of the processes ends, the 150 determines whether or not an operation for instructing the end of the initial screen 120 has been received (step S110).

If the 150 determines that the operation instructing the termination of the initial screen 120 has not been received (step S110; No), the supplier selection support process returns to step S102.

On the other hand, when 150 determines that an operation instructing to end the initial screen 120 has been received (step S110; Yes), the supplier selection support process ends.

As described above, according to the supplier selection support device 10 according to the first embodiment, a supply source for which the new order quantity prediction value of the selection target part is less than the current order quantity prediction value of the selection target part is the new supplier. is selected as a candidate for and presented to the user. As a result, it is possible to support the selection of a supplier that can suppress over-procurement, excess inventory, etc., while securing demand items necessary for the product.

The order of the flowcharts described with reference to FIGS. 14 to 16 is not limited to the order described in the first embodiment. For example, the order of steps S103 to S107 described with reference to FIG. 14 can be interchanged. Also, for example, as long as step S203 described with reference to FIG. 15 is performed after step S202 and before step S206, the order of execution is not particularly limited.

[Embodiment 2]
A supplier selection support device 10 according to the second embodiment will be described with reference to FIGS. 17 to 21. FIG. The basic configuration and basic operation of the supplier selection support device 10 according to the second embodiment are the same as the basic configuration and basic operation of the supplier selection support device 10 according to the first embodiment. However, the supply source information further includes supply capacity information indicating the supply capacity of the parts to be selected by the supplier, and the new suppliers are adjusted among multiple production bases according to the supply capacity of the new suppliers of the parts to be selected. It is different from the first embodiment in that the candidate supplier selection unit 154 further includes a supplier adjustment unit 154g.

The supplier adjustment unit 154g shown in FIG. 17 determines whether or not the total value of the new order quantity prediction values of selection target parts required at a plurality of production bases exceeds the supply capacity of the new supplier. As described in the first embodiment, the selection target part indicates a part specified by the user as a condition.

If the supplier adjustment unit 154g determines that the total value of the new order quantity prediction values of the selection target parts exceeds the supply capacity of the new supplier, it adjusts the supplier among the production bases. Specifically, when the supplier adjustment unit 154g determines that the total value of the new order quantity prediction values of the selection target parts exceeds the supply capacity of the new supplier, Change the supplier to a supplier other than the first handling supplier. If the supplier adjustment unit 154g determines that the total value of the new order quantity prediction values of the selection target parts does not exceed the supply capacity of the new supplier, Do not change suppliers.

The supplier information acquisition unit 151 further acquires supplier information indicating the supply capability of the parts at the supplier. Specifically, when the supplier information acquisition process is executed, the supplier information acquisition unit 151 causes the display unit 12 to display the supplier information input screen 121 shown in FIG. 18 .

As shown in FIG. 18, the supplier information input screen 121 further includes a supply capacity input field 121f for receiving input of information indicating the supply capacity of parts.

The user operates the operation unit 11 to input information indicating the supply capacity in addition to the information indicating the supplier code, the part code, the frequency of delivery, and the unit of supply quantity in the corresponding input fields 121a to 121d and 121f. Then, press the registration button 121e. As a result, the supplier information acquisition unit 151 acquires information indicating the supplier code, parts code, supply capability, delivery frequency, and supply quantity unit as supplier information, and stores the information in the supplier information storage unit 171 shown in FIG. register.

The supplier information storage unit 171 stores supplier code information 171a, parts code information 171b, delivery frequency information 171c, and supply quantity unit information 171d, as well as supply capability information 171e that indicates the supply capability of parts of the supplier. They are further associated and stored. The supply capacity indicates the quantity of parts that the supplier can supply in a unit period. For example, if the supplier is a parts manufacturer, the supply capacity is the parts production capacity of the supplier.

The second half of the candidate presentation process according to the second embodiment will be described below. As shown in FIG. 20, the order quantity comparison unit 154e determines that the new order quantity prediction value when the new supplier of the selection target parts is the first handling supply source is less than the current order quantity prediction value of the selection target parts. Then (step S208; Yes), the supplier adjustment unit 154g executes adjustment processing for adjusting the supplier of the selection target part at a certain production base (step S301).

As shown in FIG. 21, when the adjustment process is started, the supplier adjustment unit 154g determines that the total value of the new order quantity forecast values of the selection target parts to be procured from the first handling supplier in all production bases It is determined whether or not the supply capacity of the selection target parts of one handling supply source is exceeded (step S401).

When the supplier adjustment unit 154g determines that the total value of the new order quantity prediction values of the selection target parts to be procured from the first supplier does not exceed the supply capacity of the first supplier (step S401 in FIG. 21; No), the adjustment process is terminated.

For example, when the part code of the part to be selected is "B001" and the supplier code of the first handling supplier is "S002", in the example shown in FIG. The production bases that procure the part code "B001" of the parts to be selected from the supplier are the production bases with the base codes "K001", "K002" and "K003", and the new order quantity forecast value of these production bases is They are "1500", "5000" and "700" respectively. Therefore, the total value of new order quantity forecast values for all production bases is "7200".

As shown in FIG. 19, the supply capacity of parts with parts code "B001" from the supplier with source code "S002", that is, the number of parts that can be produced in one month, which is a unit period, is "6000". In this case, the supplier adjustment unit 154g determines that the total value of the new order quantity prediction values of the selection target parts to be procured from the first supplier exceeds the supply capacity of the first supplier. When the supplier adjustment unit 154g determines that the total value of the new order quantity prediction values of the selection target parts to be procured from the first supplier exceeds the supply capacity of the first supplier, the supplier adjustment unit 154g Adjust the supplier of the selected parts of the production base other than the selected target base to another supplier.

When the supplier adjustment unit 154g determines that the total value of the new order quantity prediction values of the selection target parts to be procured from the first supplier exceeds the supply capacity of the first supplier (step S401 in FIG. 21; Yes ), select a production base that can change the new supplier to another supplier from among the production bases that procure the selection target parts from the first handling supplier, other than the selection target base ( step S402). Hereinafter, a production base that can change the current supplier to another supplier will be referred to as an "adjustment target base".

For example, the supplier adjustment unit 154g selects the base code " Either of the production bases with the base code "K002" and "K003" is selected as the adjustment target base other than "K001".

The supplier adjustment unit 154g, for example, refers to the value of the new order quantity prediction information 174h in FIG. Select as a base.

In the example shown in FIG. 7, the predicted new order quantity values of production bases with base codes "K002" and "K003" are respectively "5000" and "700". It is the production base of code "K002". Therefore, the supplier coordinating unit 154g selects the production base with the base code "K002" as an adjustment target base.

Next, the supplier coordinating unit 154g extracts the change destination of the supplier of the selection target parts at the adjustment target base (step S403 in FIG. 21). Specifically, the supplier coordinating unit 154g extracts suppliers other than the new supplier of the adjustment target base, that is, suppliers other than the first handling supplier, from the suppliers that handle the selection target parts. Hereinafter, of the supply sources that handle selection target parts, a supply source other than the first handling supply source will be referred to as a "second handling supply source."

For example, in the example shown in FIG. 7, the supplier coordinating unit 154g is a supplier other than the supplier with the supplier code "S002", which is the new supplier for the production base with the base code "K002". is extracted from the information stored in the supplier information storage unit 171 shown in FIG. In the example shown in FIG. 4, the supplier other than the supplier with the supplier code "S002" and who handles the part with the part code "B001" is the supplier with the supplier code "S001" and "S003". be.

When a plurality of supply sources are extracted as candidates for the second handling supply source, the supplier adjustment unit 154g selects a supply source with a smaller new order quantity prediction value for each of the extracted plurality of supply sources as the second handling supply source. Select and extract. Specifically, similarly to the new order quantity acquisition unit 154d, the supplier adjustment unit 154g acquires the new order quantity prediction value of the selection target parts to be procured from the second handling supply source candidate (step S404), , the supply source with the smaller new order quantity prediction value is selected as the second handling supply source (step S405). On the other hand, if the second handling supply source candidate is one supply source, the supplier adjustment unit 154g selects that supply source as the second handling supply source (step S405).

For example, if the demanded item quantity of the base code "K002" is "2000", as shown in FIG. 1000", the new order quantity prediction value is "2000" when the production site with the site code "K002" procures the part with the part code "B001" from the supplier with the supply source code "S001". On the other hand, in the supply source code "S003", the supply quantity unit of the part code "B001", which is the part to be selected, is "700". When the parts with the part code "B001" are procured from the supplier, the new order quantity prediction value is "2100". In this case, the supplier adjustment unit 154g selects the supply source with the supply source code "S001" having the smaller new order quantity prediction value as the second handling supply source.

When the second handling supplier is selected, the supplier adjustment unit 154g changes the value of the new supplier code information 174f of the selection target parts of the adjustment target base shown in FIG. 7 to the supplier code indicating the second handling supplier. do. In addition, the supplier adjustment unit 154g changes the value of the new order quantity prediction information 174h of the selection target parts of the adjustment target base shown in FIG. 7 to the new order quantity prediction value of the selection target parts of the second handling supply source ( step S406).

In the above example, the new supplier code of the part code "B001" of the production base with the base code "K002" shown in FIG. 7 is changed from "S002" to "S001".

Next, the supplier adjustment unit 154g compares the current predicted order quantity of the selection target parts with the new predicted order quantity of the selection target parts, and the new predicted order quantity of the selection target parts is the current predicted value of the selection target parts. It is determined whether or not the order quantity is less than the predicted order quantity (step S407 in FIG. 21).

If the supplier adjustment unit 154g determines that the new predicted order quantity of the selection target part is less than the current predicted order quantity of the selection target part, that is, the current predicted value > the new predicted value (step S407; Yes ), the supplier adjustment unit 154g determines whether or not the total value of the new order quantity forecast values of the selection target parts to be procured from the second supplier exceeds the supply capacity of the second supplier (step S408). ).

When the supplier adjustment unit 154g determines that the total value of the new order quantity prediction values of the selection target parts to be procured from the second supplier does not exceed the supply capacity of the second supplier (Step S408; No), The adjustment process is ended, and the process returns to step S302 shown in FIG.

On the other hand, if the supplier candidate selection unit 154 determines that the current predicted order quantity value of the part to be selected is greater than or equal to the new predicted order quantity value, that is, the current predicted value = < the new predicted value (step S407; No ), or if it is determined that the total value of the new order quantity forecast value of the selection target parts to be procured from the second handling supply source exceeds the supply capacity of the second handling supply source (step S408; Yes), the adjustment target base can be changed (step S409). In the above step S402, for example, if there are multiple production sites other than the selection target sites among the production sites that procure the selection target parts from the first handling supplier, the supplier adjustment unit 154g changes the adjustment target sites. Determine that it is possible.

In the above example, the supplier coordinating unit 154g selects the site code "K001", which is the selection target site, among the production sites that procure the part with the part code "B001" from the supplier code "S002", which is the first supplier. There are multiple production bases other than Therefore, the supplier coordinating unit 154g selects a production base that has not been selected as a base to be adjusted, that is, a production base with base code "K003" that is different from the production base with base code "K002" selected in step S402 above. It is determined that the adjustment target base can be changed.

When the supplier coordinating unit 154g determines that the adjustment target base can be changed (step S409; Yes), the adjustment process returns to step S402, selects an unselected production base as the adjustment target base, and proceeds to step S403. proceed to

On the other hand, if the supplier coordinator 154g determines that it is not possible to change the adjustment target base because there is no production base that has not been selected as the adjustment target base (step S409; No), it turns on the change prohibition flag (step S410). ), ending the adjustment process. The information indicating the unchangeable flag is stored in the storage unit 170, and is initialized to OFF each time the adjustment process is started.

When the adjustment process ends, the process returns to step S302 of the candidate selection process shown in FIG. In step S302, the order quantity comparison unit 154e determines whether or not the unchangeable flag is ON (step S302). When the order quantity comparison unit 154e determines that the change-impossible flag is ON (step S302; Yes), the candidate of the new supplier of the selection target part of the selection target site is returned to the current supplier (step S209), and the candidate selection process is performed. goes to step S210. On the other hand, if the order quantity comparison unit 154e determines that the change prohibition flag is off (step S302; No), the candidate selection process proceeds to step S210. Thereafter, candidate selection processing is executed in the same manner as in the first embodiment.

The second embodiment has been described above. In companies with multiple production bases, although the same demanded products are used at multiple production bases, the same demanded products are not coordinated among the production bases, so each production base orders more demanded products than necessary. There is a risk of it happening. However, according to Embodiment 2, since the procurement source of the same demand item is adjusted between the production bases, it is possible to suppress over-procurement, excess inventory, etc. while securing the demand item necessary for the product.

Further, according to the second embodiment, the supplier of the production base is procured according to the supply capacity of the new supplier. In this way, it is possible to avoid a situation in which the procurement quantity is insufficient.

[Embodiment 3]
A supplier selection support device 10 according to the third embodiment will be described with reference to FIGS. 22 to 26. FIG. The basic configuration and basic operation of the supplier selection support device 10 according to the third embodiment are the same as the basic configuration and basic operation of the supplier selection support device 10 according to the first and second embodiments. However, it differs from the first and second embodiments in that the production plan information J further includes scenario information indicating a plurality of scenarios.

A scenario is a path to realize a production plan. Scenarios are set when users such as production planners and production managers make production plans. Scenarios are set to identify each production plan when making a plurality of production plans for different types of products to be produced on a production day at a production base. Alternatively, when making a plurality of production plans with different quantities of a certain product to be produced on a certain production day, it is set to identify each production plan. Hereinafter, the points different from the first and second embodiments will be mainly described.

As shown in FIG. 22, the storage unit 170 further includes a scenario information storage unit 175 that stores scenario information.

As shown in FIG. 23, the scenario information storage unit 175 stores basic information of scenario information. The scenario information storage unit 175 stores scenario ID information 175a, which is scenario identification information, and scenario name information 175b, which is information indicating the name of the scenario, in association with each other. The name of the scenario is determined, for example, by the production manager.

As shown in FIG. 24, the product production quantity information storage unit 173 further includes scenario ID information 173e, which is scenario identification information. The demanded product quantity information acquisition unit 153 acquires scenario identification information included in the production plan information J. FIG. The demanded product quantity information acquisition unit 153 registers the acquired scenario identification information as the value of the scenario ID information 173e, and obtains the scenario ID information 173e stored in the product production quantity information storage unit 173 described with reference to FIG. Get the demand quantity for each value.

As shown in FIG. 25, the order quantity prediction information storage unit 174 further includes scenario ID information 174j and pattern ID information 174k, which is pattern identification information. A pattern is identification information for identifying a combination of a part indicated by the part code information 174c and a scenario indicated by the scenario ID information 174j.

The supplier candidate selection unit 154 shown in FIG. 22 selects new supplier candidates for each scenario. Specifically, the current order quantity acquisition unit 154c acquires the current order quantity prediction value based on the result of dividing the quantity of demanded products by the supply quantity unit of the selection target parts of the current supplier. Similarly, the new order quantity acquisition unit 154d shown in FIG. Obtain a new order quantity forecast value based on the result of division by the supply quantity unit of the parts to be selected.

The candidate presenting unit 154f presents the current supplier and new supplier candidates of the production base to the user for each scenario. The candidate presentation unit 154f causes the display unit 12 to display a candidate presentation screen 124 shown in FIG. 26, for example.

As shown in FIG. 26, the candidate presentation screen 124 displays a list of information stored in the order quantity prediction information storage unit 174 described with reference to FIG. Candidate presentation screen 124 shown in FIG. 26 further includes information indicating scenario IDs and information indicating pattern IDs, as compared with candidate presentation screen 124 described in the first embodiment.

When the user refers to the information indicating the scenario ID and the information indicating the pattern ID and operates the operation unit 11 to designate a supplier to be determined as a new supplier, the supplier determination unit 155 causes the user determines the specified supply source as the new procurement source and notifies the relevant parties.

As described above, according to the supplier selection support device 10 of the third embodiment, new suppliers of production bases are presented to the user in correspondence with the scenario. The user can grasp candidates for new suppliers for each scenario of production plans of multiple production bases, and can simulate new suppliers according to multiple scenarios. This improves convenience for the user.

Note that in the present disclosure, parts have been described as an example of a demanded item, but the object to be procured is not particularly limited, and the demanded item may be a material, a raw material, or the like, as described above. That is, the present disclosure is also applicable to selection of supply destinations of materials, raw materials, and the like. In this case, the supply quantity unit is specified by mass, volume, or the like.

The method of calculating the current order quantity prediction value and the new order quantity prediction value is not limited to the above method. For example, the value obtained by multiplying the value of the supply quantity unit by an integer is compared with the required quantity of parts. It may be obtained as a quantity forecast value or a new order quantity forecast value.

The information stored in the supplier information storage unit 171, the demanded product information storage unit 172, the product production quantity information storage unit 173, the order quantity forecast information storage unit 174, and the scenario information storage unit 175 are the contents explained in the embodiment. and may include contents other than those described in the embodiment. For example, the supplier information storage unit 171 may include the address, name, etc. of the supplier, and the demand product information storage unit 172 may include the name of the production base.

The screen configurations of the supplier information input screen 121, the demand item information input screen 122, the condition designation screen 123, and the candidate presentation screen 124 are not limited to the configurations described in the embodiments. For example, the condition specifying screen 123 may include at least the part code input field 123a, and the base code input field 123b, the production plan start input field 123c, and the production plan end input field 123d may be omitted. If the site code input field 123b is not included in the condition designation screen 123, all production sites are set as conditions. In addition, when the production planning start input field 123c and the production planning end input field 123d are not included in the condition designation screen 123, the latest one month may be set as the condition of the production planning period.

Although the candidate presenting unit 154f displays the candidate presenting screen 124 on the display unit 12 to present the candidate of the new supplier to the user, the candidate presenting unit 154f only needs to present the new supplier to the user. It is not limited to displaying the presentation screen 124 on the display unit 12 . For example, the supplier selection support device 10 may further include a speaker that outputs sound, and the candidate presenting unit 154f may notify the user of the new supplier candidate by sound, for example.

The method by which the user designates the determination of the new procurement source is not particularly limited. For example, the supplier selection support device 10 may further include a microphone that receives input of user's voice, and a voice analysis unit that analyzes the voice input to the microphone. In this case, when the user specifies by voice a supplier to be determined as a new supplier, the supplier determination unit 155 may determine the supplier specified by the user by voice as the new supplier.

The method of notifying the parties concerned of the determined new supplier is not particularly limited. For example, the new supplier may be notified to the parties concerned by posting the new supplier on an internal bulletin board.

Although the present disclosure describes the case where the second supplier is the current supplier, the second supplier may be a supplier selected by the user from among multiple suppliers.

This disclosure was applied when adjusting the supplier based on the current order quantity forecast value and the new order quantity forecast value. When adjusting the supplier based on the current inventory quantity forecast value that indicates the forecasted quantity and the new inventory quantity forecast value that indicates the estimated inventory quantity at the production base when the parts to be selected are procured from the new supplier is also applicable. In this case, the supplier candidate selection unit 154 selects the supplier with the minimum new stock quantity prediction value as the new supplier based on the delivery frequency, supply quantity unit, and supply capacity described with reference to FIG. selected as a candidate for The supplier candidate selection unit 154 selects a supply source with a high frequency of delivery as the supply source with the minimum new inventory quantity prediction value. The supplier candidate selection unit 154 obtains the current inventory quantity forecast value and the new inventory quantity forecast value by dividing the demand product quantity from the quantity of parts to be procured from the supply source in the unit period.

In the present disclosure, the supplier information acquisition unit 151 may acquire supplier information stored in a device different from the supplier selection support device 10 via the communication unit 13 .

Similarly, the demand item information acquisition unit 152 may acquire demand item information stored in a device other than the supplier selection support device 10 via the communication unit 13 .

Computer-readable recording media including magnetic disks, optical disks, magneto-optical disks, flash memories, semiconductor memories, and magnetic tapes can be used as recording media for recording the supplier support program PG.

The supplier information acquisition process corresponds to the supplier information acquisition step, the demanded product quantity information acquisition process corresponds to the demanded product quantity information acquisition step, and the candidate selection process corresponds to the supplier candidate selection step.

Candidates obtained in Embodiments 1 to 3, that is, suppliers selected mainly for inventory control, may be selected in consideration of conditions other than the conditions described in the embodiments, such as price, quality, etc. good. For example, based on Embodiments 1 and 2, the supplier selection support device 10 may extract a plurality of supply sources, and select one or a plurality of supply sources in consideration of price, quality, delivery date, etc. good.

Also, the items described in the first to third embodiments can be combined as appropriate. For example, the supplier selection support device 10 includes the product production quantity information storage unit 173, the order quantity prediction information storage unit 174, and the scenario information storage unit 175, which are configured as described in the third embodiment, and described in the second embodiment. The supplier adjustment unit 154g determines whether or not the total value of the new order quantity prediction values of the selection target parts required at the production base exceeds the supply capacity of the selection target parts for each series ID or pattern ID. good. In this case, the candidate presenting unit 154f determines whether or not the total value of the predicted new order quantities of the selection target parts required at the production base for each series ID or pattern ID exceeds the supply capacity of the selection target parts. may present candidates for new suppliers of each production base to the user for each scenario.

Although the case where this disclosure is applied to the manufacturing industry has been explained as an example, this disclosure applies to the entire production industry that orders demand items such as agriculture and fisheries in a certain quantity and uses them for the production of products. Applicable. Furthermore, the present disclosure is not limited to the manufacturing industry, but is applicable to all industries that order demanded goods in units of quantity.

1 supplier support system 10 supplier selection support device 11 operation unit 12 display unit 13 communication unit 15 processor 16 main storage device 17 auxiliary storage device 120 initial screen 120a supplier information acquisition button 120b Demand item information acquisition button 120c Demand item quantity information acquisition button 120d New supplier candidate selection button 121 Supplier information input screen 121a Supplier code input field 121b Parts code input field 121c Delivery frequency input field 121d Supply Quantity unit input field, 121e Registration button, 121f Supply capacity input field, 122 Demand product information input screen, 122a Base code input field, 122b Product code input field, 122c Part code input field, 122d Parts multiplier input field, 122e Supplier code Input column 122f Register button 123 Condition specification screen 123a Parts code input column 123b Base code input column 123c Production plan start input column 123d Production plan end input column 123e Execution button 124 Candidate presentation screen 124a Item column , 124b information display column, 124c check column, 150 activation unit, 151 supply source information acquisition unit, 152 demand product information acquisition unit, 153 demand product quantity information acquisition unit, 154 supplier candidate selection unit, 154a condition reception unit, 154b handling Supply source extraction unit 154c Current order quantity acquisition unit 154d New order quantity acquisition unit 154e Order quantity comparison unit 154f Candidate presentation unit 154g Supplier adjustment unit 155 Supplier determination unit 170 Storage unit 171 Supplier information Storage unit 171a Supplier code information 171b Parts code information 171c Delivery frequency information 171d Supply quantity unit information 171e Supply capacity information 172 Demand product information storage unit 172a Location code information 172b Product code information 172c Parts code Information, 172d Part multiplier information (demand product multiplier information), 172e Supplier code information, 173 Product production quantity information storage unit, 173a Base code information, 173b Product code information, 173c Production plan date information, 173d Production quantity information, 173e Scenario ID information 174 Order quantity forecast information storage unit 174a ID information 174b Calculation date information 174c Part code information 174d Base code information 174e Current supplier code information 174f New supplier code information 174g Current order quantity forecast information 174h New order quantity forecast information 174j Scenario ID information 174k Pattern ID information 175 Scenario information storage unit 175a Scenario ID information 175b Scenario name information J Production plan information PG Supplier support program Sv Production base server.

Claims (9)

Supply source information for acquiring supply quantity unit information indicating a supply quantity unit that is the quantity of the demanded product that can be delivered in one delivery from each of a plurality of supply sources that can supply the demanded product necessary for the production of the product an acquisition unit;
a demanded product quantity information acquisition unit that acquires demanded product quantity information indicating a demanded product quantity that is the quantity of the demanded product required for a unit period;
A first order quantity forecast value and said one of said supply sources in said unit period when said demanded product is procured from said first supply source of said supply sources based on said quantity of said demanded product and said supply quantity unit Obtaining a second predicted order quantity value for the unit period when the demanded product is procured from a second supply source different from the first supply source, wherein the first predicted order quantity value is less than the second predicted order quantity value a supplier candidate selection unit that selects the first supplier as a supplier candidate,
A supplier selection support device. The procurement candidate selection unit,
If the remainder obtained by dividing the quantity of the demanded product by the supply quantity unit of the demanded product of the first supply source is other than 0, the value obtained by adding 1 to the quotient obtained by the division, and the quantity of the demanded product The value obtained by multiplying the supply quantity unit is obtained as the first order quantity forecast value, and the demanded product quantity is obtained by dividing the demanded product quantity by the supply quantity unit of the demanded product of the first supply source. When the remainder is 0, a first order quantity forecast value acquisition unit that acquires a value obtained by multiplying the quotient obtained by division by the supply quantity unit of the demand item as the first order quantity forecast value. and,
If the remainder obtained by dividing the quantity of the demanded product by the supply quantity unit of the demanded product of the second supply source is other than 0, the value obtained by adding 1 to the quotient obtained by the division, and the quantity of the demanded product The value obtained by multiplying the supply quantity unit is obtained as the second order quantity forecast value, and the quantity of the demanded product is divided by the supply quantity unit of the demanded product of the second supply source. When the remainder is 0, a second order quantity forecast value acquiring unit for acquiring, as the second order quantity forecast value, a value obtained by multiplying the quotient obtained by division by the supply quantity unit of the demanded item. and,
The supplier selection support device according to claim 1, comprising: The procurement candidate selection unit,
a handling supply source extracting unit for extracting a first handling supply source handling the demanded product;
an order quantity comparison unit that determines whether the first predicted order quantity value is less than the second predicted order quantity value;
When the order quantity comparing unit determines that the first predicted order quantity is less than the second predicted order quantity, the first handling supply source is presented to the user as a candidate for the procurement source, and the first a candidate presenting unit for presenting the second supply source to the user as a candidate for the procurement source when the order quantity comparison unit determines that one order quantity prediction value is equal to or greater than the second order quantity prediction value;
3. The supplier selection support device according to claim 1, further comprising: When a plurality of supply sources are extracted as candidates for the first supply source, the handling supply source extracting unit extracts the supply source with the smaller first order quantity prediction value as the first handling supply source. 4. The supplier selection support device according to claim 3. The product is produced at a plurality of production bases,
The plurality of production bases includes a first production base designated as a condition for changing the supplier of the demanded item and a second production base other than the first production base,
The supply source information acquisition unit further acquires supply capacity information indicating the supply capacity of the demanded product at the supply source,
The procurement candidate selection unit,
determining whether or not the total value of the first order quantity forecast values of the demanded product of the plurality of production bases exceeds the supply capacity of the demanded product, and placing the first order of the demanded product of the plurality of production bases; When it is determined that the total value of the quantity forecast values exceeds the supply capacity of the demanded item, the procurement source of the demanded item at the second production base is selected from supply sources handling the demanded item other than the first handling supply source. 5. The supplier selection support device according to claim 4, further comprising a supplier adjustment unit for changing to the second handling supplier. 6. The supplier according to any one of claims 1 to 5, wherein the supplier candidate selection unit selects the supplier candidate for each scenario that is a route to realizing the production plan of the product. Selection support device. 7. The supplier selection support device according to any one of claims 1 to 6, wherein said second supplier is a current supplier of said demanded product. Supply quantity unit information indicating a supply quantity unit that is the quantity of the demanded product that can be delivered in one delivery from each of a plurality of supply sources that can supply the demanded product necessary for the production of the product. a supply source information acquisition step to be acquired by
a demanded product quantity information obtaining step for causing a supplier selection support device to obtain demanded product quantity information indicating a demanded product quantity that is the quantity of the demanded product required for a unit period;
A first order quantity forecast value and said one of said supply sources in said unit period when said demanded product is procured from said first supply source of said supply sources based on said quantity of said demanded product and said supply quantity unit causing a supplier selection support device to acquire a second predicted order quantity in the unit period when the demanded product is procured from a second supply source different from the first supply source, a supplier candidate selection step of causing the supplier selection support device to select the first supply source that is less than the 2 order quantity forecast value as a supplier candidate;
A supplier selection support method. to the computer,
Acquire supply quantity unit information indicating a supply quantity unit that is the quantity of the demanded product that can be delivered in one delivery from each of a plurality of supply sources that can supply the demanded product necessary for the production of the product,
Acquire demanded product quantity information indicating a demanded product quantity that is the quantity of the demanded product required for a unit period,
A first order quantity forecast value and said one of said supply sources in said unit period when said demanded product is procured from said first supply source of said supply sources based on said quantity of said demanded product and said supply quantity unit Acquire a second order quantity forecast value in the unit period when the demanded product is procured from a second supply source different from the first supply source,
A supplier selection support program for selecting, as a supplier candidate, the first supply source whose first predicted order quantity value is less than the second predicted order quantity value.

Images