Business support device, business support method, and business support program

Abstract

This reduces the burden of ordering by dividing the same procurement item among multiple suppliers. [Solution] The detection unit refers to an order condition master table in which, for each item to be purchased, the supplier, the priority of the supplier, an order method classification indicating whether the order for the item to be purchased is placed with a single supplier or divided into multiple suppliers, and purchase ratio information indicating the purchase ratio for each supplier corresponding to the divided order method, and detects the supplier, the priority of the supplier, the order method classification, and the purchase ratio information corresponding to the item to be purchased. If the undivided method is detected, the data generation unit generates planned order data in which the supplier for the total number of items to be purchased is the supplier set in the order condition master table associated with the item to be purchased. If the divided order method is detected, the data generation unit generates planned order data for each supplier in which the total number of items to be purchased is divided into purchase quantities according to the purchase ratio indicated by the purchase ratio information, in order of priority for each supplier.

Description

Technical Field

[0001] The present invention relates to a business support device, a business support method, and a business support program.

Background Art

[0002] Patent Document 1 (Japanese Patent Application Laid-Open No. 2023-007105) discloses a split order support server that enables ordering of an accurate quantity of products when placing split orders.

[0003] When there is a search request including search conditions with the quotation number or search information from the member terminal as the search conditions, this split order support server's arithmetic processing unit searches the quotation database. The arithmetic processing unit 17 transmits at least the products and the quotation quantities of various products among the quotation information of the quotations that match the search conditions to the member terminal via the communication unit. When the arithmetic processing unit receives the split order quantity of the selected product from the member terminal, it stores a split order history associating the split order quantity of the product and the identification information in the order receipt history database. Thereby, it enables ordering of an accurate quantity of products when placing split orders.

Prior Art Documents

Patent Documents

[0004]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0005] Here, when placing an order for a procurement target with a supplier, even for the same procurement target, there are cases where the procurement is divided among multiple suppliers and placed. In this case, it is necessary to consider the procurement quantity for each supplier and create order data, which poses a problem of burden on the person in charge.

[0006] This invention has been made in view of the above-mentioned problems, and aims to provide a business support device, a business support method, and a business support program that can reduce the burden of creating order data when ordering the same item from multiple suppliers. [Means for solving the problem]

[0007] To solve the above-mentioned problems and achieve the objective, the business support device according to the present invention includes: a detection unit that detects a supplier, supplier priority, order method classification and purchase ratio information corresponding to a purchase item by referring to an order condition master table, which has, for each purchase item, set a supplier, a priority of the supplier, an order method classification indicating an undivided method in which orders for the purchase item are placed with a single supplier, or a divided order method in which orders are divided and placed with multiple suppliers, and purchase ratio information indicating the purchase ratio of each supplier corresponding to the divided order method, based on the purchase item; a data generation unit that generates planned order data for each supplier, which, if the detected order method classification is an undivided method, sets the supplier for the total number of purchase items to the supplier set in the order condition master table associated with the purchase item; and if the detected order method classification is a divided order method, generates planned order data for each supplier, which divides the total number of purchase items for the purchase item into purchase quantities according to the purchase ratio indicated by the purchase ratio information in order of priority of each supplier; and an output control unit that outputs the generated planned order data to an output target device.

[0008] Furthermore, in order to solve the above-mentioned problems and achieve the objective, the business support method according to the present invention includes a detection step in which a detection unit, based on the purchase item, refers to an order condition master table in which, for each purchase item, the supplier, the priority of the supplier, an order method classification indicating whether the order for the purchase item is placed with a single supplier or a divided order method indicating whether the order is divided and placed with multiple suppliers, and purchase ratio information indicating the purchase ratio of each supplier corresponding to the divided order method, thereby detecting the supplier, the priority of the supplier, the order method classification and purchase ratio information corresponding to the purchase item, and a data generation unit, The system includes a data generation step in which, if the order method classification detected in the detection step is a non-divided order method, order plan data is generated with the suppliers of the total number of purchases set in the order condition master table associated with the purchase items; and a data generation step in which, if the order method classification detected in the detection step is a divided order method, order plan data is generated for each supplier, with the total number of purchases divided according to the purchase ratio indicated in the purchase ratio information, in order of priority for each supplier; and an output control step in which the output control unit outputs the generated order plan data to the output target device.

[0009] Furthermore, in order to solve the above-mentioned problems and achieve the objectives, the business support program according to the present invention functions as a detection unit that detects suppliers, supplier priorities, ordering method classifications and purchase ratio information corresponding to a purchase item by referring to an ordering condition master table, which for each purchase item has been set up, based on the purchase item, and which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, which has been set up, when the detected ordering method classification is the undivided method, and the suppliers of the purchase item for the total number of purchases has been set up as suppliers associated with the purchase item and set up in the ordering condition master table. and the business support program according to the present invention functions as an output control unit that outputs the generated order schedule data to an output target device. [Effects of the Invention]

[0010] This invention reduces the burden of creating order data when ordering the same item from multiple suppliers. [Brief explanation of the drawing]

[0011] [Figure 1] Figure 1 is a block diagram showing the hardware configuration of the business support device according to the embodiment. [Figure 2] Figure 2 shows an example of an order condition master table. [Figure 3] Figure 3 shows an example of a product master table. [Figure 4] Figure 4 shows an example of a manufacturing configuration master table. [Figure 5] Figure 5 is a diagram illustrating the process of generating order planning data. [Figure 6] Figure 6 shows an example of planning data. [Figure 7] Figure 7 shows an example of manufacturing instruction data. [Figure 8] Figure 8 is a diagram illustrating the split order configuration provided by the business support device 1 in this embodiment. [Figure 9] Figure 9 shows an example of planned order data. [Figure 10] Figure 10 is a diagram illustrating the non-divisible method. [Figure 11] Figure 11 is a diagram illustrating the maximum order quantity method. [Figure 12] Figure 12 is a diagram illustrating the apportionment method. [Modes for carrying out the invention]

[0012] The following describes in detail, with reference to the drawings, a business support device that is an embodiment to which the present invention is applied. However, the present invention is not limited to the following embodiments.

[0013] (Summary) Today, if parts supply to a factory of an automobile manufacturer, for example, is delayed due to defects or non-conformities from suppliers, the factory line stops, hindering the production of automobiles. Therefore, in parts procurement in the automobile parts industry, compliance with delivery dates is required. Also, from the perspective of the limit of the supply volume of suppliers or the response during disasters, it is preferable to enable orders to multiple suppliers and stabilize the receipt of parts or materials, etc. to be procured.

[0014] For this reason, in the business support device of the embodiment, for example, in the automobile industry, the internal indication plan to suppliers, which is essential, can be ordered by calculating the order quantity by dividing the procurement target of one part number among multiple suppliers. Also, such split order operations reduce the burden on the person in charge.

[0015] (Hardware Configuration) FIG. 1 shows the hardware configuration of the business support device 1 of the embodiment. This business support device 1 is a business support device 1 for a parts manufacturing enterprise centered on machinery or automobiles, and is used for internal indication orders of materials or purchased items for the next month or the month after next to suppliers of parts or materials, etc. to be procured.

[0016] As shown in FIG. 1, this business support device 1 includes a storage unit 2, a control unit 3, a communication interface unit 4, and an input / output interface unit 5. An input device 6 and an output device 7 are connected to the input / output interface unit 5. As the output device 7, a display unit such as a monitor device (including a home TV), a printing device, or a speaker device, etc. corresponds. As the input device 6, in addition to a keyboard device, a mouse device, and a microphone device, etc., a monitor device that realizes a pointing device function in cooperation with the mouse device can also be used.

[0017] The communication interface unit 4 is connected to a network 50, such as a wide-area network like the Internet or a private network like a LAN (Local Area Network). Each supplier's terminal device 51, used for order taking, is connected to the network 50. The business support device 1 of this embodiment transmits order data to each supplier's terminal device 51 to place orders for desired parts or materials.

[0018] For the memory unit 2, a storage device such as ROM (Read Only Memory), RAM (Random Access Memory), HDD (Hard Disk Drive), or SSD (Solid State Drive) can be used. The memory unit 2 stores a business support program that reduces the burden of creating order data when ordering the same item from multiple suppliers.

[0019] Furthermore, this memory unit 2 is equipped with the following memory areas: an order condition master table 11, a product master table 12, a manufacturing configuration master table 13, a planning data storage unit 14, a manufacturing instruction data storage unit 15, and an order schedule data storage unit 16.

[0020] As shown in Figure 2, the order conditions master table 11 stores the product code (process), supplier code, priority, order method category, maximum order quantity, and order ratio, each associated with the others.

[0021] The product code (process) is a product code assigned to each component (each purchased item) or material that is purchased, and the same component (each purchased item) or material is assigned the same product code.

[0022] A supplier code is a unique identification number assigned to each supplier. In this example, each supplier is assigned a different supplier code, such as A001, S002, S003, etc.

[0023] The priority indicates the priority of each supplier that handles the same purchased item. In the example in Figure 2, for example, purchased item D is ordered from suppliers with supplier codes S005, S006, and S007, but the supplier with supplier code S005 is set as the 1st priority supplier, the supplier with supplier code S006 is set as the 2nd priority supplier, and the supplier with supplier code S007 is set as the 3rd priority supplier.

[0024] Similarly, the example in Figure 2 shows a setting in which, for example, material E is ordered from suppliers with supplier codes S011, S012, and S013, with the supplier with supplier code S011 being the first priority supplier, the supplier with supplier code S012 being the second priority supplier, and the supplier with supplier code S013 being the third priority supplier.

[0025] The ordering method classification indicates the ordering method set for each purchased item. For example, the ordering methods set for each purchased item are "0: Undivided method," "1: Maximum ordering method," and "2: Pro-rata method."

[0026] The "0: Undivided Method" is an ordering method in which an order for a purchased item is placed with a single supplier. In the example in Figure 2, purchased item C is an item ordered using the "0: Undivided Method". In other words, this example in Figure 2 shows that when ordering purchased item C, the order is placed only with the supplier with supplier code S002, and no order for purchased item C is placed with the supplier with supplier code S001. Furthermore, the maximum order quantity for the supplier with supplier code S002 is set to "1000 units", and orders of "1001 units" or more cannot be placed at once.

[0027] "1: Maximum Order Method" is an ordering method in which, when ordering the same item from multiple suppliers, the order quantity (purchase quantity) to each supplier is divided and ordered based on the maximum order quantity set for each supplier. The example in Figure 2 shows a setting in which, when ordering purchased item D, the order is divided and placed with supplier 005 with priority 1, supplier 006 with priority 2, and supplier 007 with priority 3.

[0028] Additionally, the maximum order quantity for suppliers with priority 1 and supplier code 005 is set to "1500 units", for suppliers with priority 2 and supplier code 006 it is set to "0 units", and for suppliers with priority 3 and supplier code 007 it is set to "500 units".

[0029] In this "1: Maximum Order Method," the maximum order quantity of "0 units" set for a supplier with priority 2 and supplier code 006 indicates that all remaining orders that could not be allocated to the supplier with priority 1 will be allocated to that supplier. For example, when ordering 1800 units of item D, the maximum order quantity for the supplier with priority 1 and supplier code 005 is "1500 units," so the remaining 300 units need to be allocated to other suppliers. In this case, all of the remaining 300 units will be allocated to the supplier with priority 2 and supplier code 006, which has a maximum order quantity of "0 units." The maximum order quantity of "0 units" indicates this.

[0030] "2: Pro-rata allocation method" is an ordering method in which, when ordering the same item from multiple suppliers, the order quantity (number of items purchased) to each supplier is divided and ordered based on the order ratio set for each supplier. The example in Figure 2 shows a setting in which, when ordering material E, the order is divided and ordered to supplier 011 with priority 1, supplier 012 with priority 2, and supplier 013 with priority 3.

[0031] Additionally, the order ratio for suppliers with priority 1 and supplier code 011 is set to "60%", the order ratio for suppliers with priority 2 and supplier code 012 is set to "50%", and the maximum order quantity for suppliers with priority 3 and supplier code 013 is set to "90%".

[0032] As will be explained later, the number of orders (purchases) relative to this order ratio is calculated by dividing each supplier's order ratio by the sum of the order ratios set for each supplier for a single purchase target, and then multiplying each of the division values ​​for each supplier by the total number of orders (total purchases).

[0033] Order quantity (purchase quantity) = (set order ratio ÷ total order ratio) × total purchase quantity

[0034] Next, the product master table 12 stores the product code and asset classification of each purchased item, as shown in Figure 3. In this example in Figure 3, product A is classified as "finished goods," intermediate product B is classified as "work in progress," and purchased items C, D, and E are each classified as "materials."

[0035] The manufacturing configuration master table 13 stores the parent product code, serial number, child product code, and constituent numerator / denominator, each associated with the others. The example in Figure 4 shows that one bag of product A, which is the parent product, is composed of 100 purchased items C, which are the child products. The example in Figure 4 also shows that one unit of product A, which is the parent product, is composed of one unit of intermediate product B, which is the child product. The example in Figure 4 also shows that one unit of intermediate product B, which is the parent product, is composed of 10 purchased items D, which are the child products. The example in Figure 4 also shows that one unit of intermediate product B, which is the parent product, is composed of two units of material E, which are the child products.

[0036] (Functional configuration of business support equipment) Next, the control unit 3 executes the business support program stored in the memory unit 2, and functions as the detection unit 21, data generation unit 22, and output control unit, as shown in Figure 1. In this example, the detection unit 21 to the output control unit 23 are described as being implemented in software based on the business support program, but all or part of the detection unit 21 to the output control unit 23 may be implemented in hardware. In either case, the same effects as described later can be obtained.

[0037] The detection unit 21 refers to an order condition master table 11 (see Figure 2) based on the item to be purchased. This master table contains, for each item to be purchased, the supplier, the priority of the supplier, an order method classification indicating whether the order for the item to be purchased is placed with a single supplier (non-divided method) or divided order methods (maximum order quantity method and proportional allocation method) where the order is divided among multiple suppliers (maximum order quantity method and order ratio method), and purchase ratio information (maximum order quantity and order ratio) indicating the purchase ratio of each supplier corresponding to the divided order method. The detection unit 21 then detects the supplier, the priority of the supplier, the order method classification, and the purchase ratio information corresponding to the item to be purchased.

[0038] If the order method classification detected by the detection unit 21 is an undivided method, the data generation unit 22 generates order plan data (see Figure 9) in which the suppliers for the total number of purchases are the suppliers set in the order condition master table 11 that are associated with the purchase targets.

[0039] Furthermore, if the order method classification detected by the detection unit 21 is a split order method, the data generation unit 22 generates order plan data for each supplier (see Figure 9), which is obtained by dividing the total number of purchases to be procured by the purchase ratio indicated by the purchase ratio information (maximum order quantity and order ratio) in order of priority for each supplier.

[0040] The output control unit 23 outputs the order planning data generated by the data generation unit 22 to the output target device. The output target device corresponds to, for example, the output device 7, and can be a display device, a printing device, or a speaker device. The output control unit 24 converts the order planning data into display information, print information, or audio information and supplies it to the corresponding device. This makes it possible to obtain display output, print output, or audio output of the order planning data. In addition, the output target device can be the storage unit 2, an external storage device, or a server device on a network, and the order planning data may be output to or transmitted to these devices for storage.

[0041] Furthermore, the system includes a maximum order method in which the maximum order quantity is set as a purchase ratio for each supplier according to their respective priority levels, and the total number of purchases is divided and allocated to each supplier based on the maximum order quantity for each supplier, and a proportional allocation method in which the total number of purchases is divided and allocated to each supplier based on the order ratio set according to the priority level of each supplier.

[0042] When the data generation unit 22 detects a split order method from the order condition master table 11, it generates order plan data corresponding to the number of purchases for each supplier assigned using the maximum order method or the proportional allocation method.

[0043] Furthermore, the data generation unit 22 is configured with an apportionment method as the split order method. When the total number of purchases is apportioned based on the order ratio set for each supplier of priority, and a fractional part of the purchase quantity occurs, the unit generates order data for the supplier with the fractional part removed as the order data for the supplier with the lower priority that has the fractional part, and generates order data for the supplier with the fractional part added by one as the order data for the supplier with the higher priority that has the fractional part.

[0044] (Generation of planned order data) Next, the operation of generating order schedule data in the business support device 1 of this embodiment will be described.

[0045] Figure 5 shows the flow of the order planning data generation operation in the business support device 1 of the embodiment. As shown in Figure 5, the business support device 1 of the embodiment detects whether or not there are split orders for each procurement item and the split order method based on the planning data stored in the planning data storage unit 14 shown in Figure 6, the product data stored in the product master table 12 shown in Figure 3, the manufacturing configuration data stored in the manufacturing configuration master table 13 shown in Figure 4, and the order condition data stored in the order condition master table 11 shown in Figure 2.

[0046] When ordering using the non-divided ordering method, the data generation unit 22 generates planned order data for ordering all purchased items from a single supplier as part of the "required quantity calculation process." In contrast, when ordering using the maximum order quantity method or the proportional allocation method, the data generation unit 22 generates planned order data for the number of items corresponding to the maximum order quantity or order ratio set for each of the multiple suppliers as part of the "required quantity calculation process."

[0047] Figure 6 shows an example of manufacturing plan data for producing 200 units of product A in-house using process 999. Based on this plan data, the production of the specified number of units (200 units) of product is instructed. Based on such manufacturing plan data, the manufacturing instruction data exemplified in Figure 7 is generated and stored in the manufacturing instruction data storage unit 15.

[0048] To give a specific example using the manufacturing of product A as illustrated in Figure 8, first, when the manufacturing of product A is instructed, the detection unit 21 refers to the manufacturing configuration master table 13 shown in Figure 4 and detects the numerator and denominator of purchased item C and intermediate product B, which are necessary for the manufacturing of product A. The detection unit 21 also refers to the manufacturing configuration master table 13 and detects the numerator and denominator of purchased item D and material E, which are necessary for the manufacturing of intermediate product B.

[0049] Next, the detection unit 21 refers to the order condition master table 11 shown in Figure 2 and detects the supplier code, priority, and order method classification for purchased item C. In the example in Figure 2, the order method classification for purchased item C is "0: Undivided method". Therefore, the detection unit 21 detects the maximum order quantity corresponding to each supplier from the order condition master table 11.

[0050] Figure 10 shows the order condition data for the portion of the order condition master table 11 corresponding to purchased item C. As shown in Figure 10, the order method classification for purchased item C is "0: Undivided method," which means ordering from a single supplier. Also, the supplier priority for supplier code "S001" is set to 1st place.

[0051] In the "0: Undivided Ordering Method," the entire order quantity is allocated to the supplier with the highest priority, while no order quantity is allocated to suppliers with a priority of 2nd place or lower.

[0052] Furthermore, in the "0: Undivided Ordering Method," a maximum order quantity of "0" means that the entire order quantity will be allocated to suppliers for whom this maximum order quantity of "0" is set.

[0053] Therefore, as shown in Figures 8 and 9, the data generation unit 22 generates planned order data to place an order for the total number of purchased items C (total number of manufacturing instructions: 2 bags in this example) with the supplier code "S001" set in the order condition master table 11. This planned order data consists of a planned order number, product code, number of manufacturing instructions before splitting, number of manufacturing instructions after splitting, supplier code, and remarks (ordering method classification), as shown in Figure 9, and is stored in the planned order data storage unit 16.

[0054] Next, the detection unit 21 refers to the order condition master table 11 shown in Figure 2 and detects the supplier code, priority, and order method classification of purchased item D used in the manufacture of intermediate product B shown in Figure 8. In the example in Figure 2, the order method classification for purchased item D is "1: Maximum Order Quantity Method," which is one of the split order methods. Therefore, the detection unit 21 detects the maximum order quantity corresponding to each supplier from the order condition master table 11.

[0055] Figure 11 shows the order condition data for the portion of the order condition master table 11 corresponding to purchased item D. As shown in Figure 11, the order method classification for purchased item D is the "1: Maximum Order Quantity Method," which divides the order among three suppliers with supplier codes "S005" to "S007". Furthermore, the priority of the suppliers with supplier codes "S005" to "S007" is as follows: supplier code "S005" is ranked "1st", supplier code "S006" is ranked "2nd", and supplier code "S007" is ranked "3rd".

[0056] In the "1: Maximum Order Quantity Method" ordering method, for suppliers with a maximum order quantity of "0," the entire order quantity is allocated to that supplier.

[0057] Furthermore, in the "1: Maximum Order Quantity Method" ordering method, for suppliers with a maximum order quantity set to "other than 0", the allocation of purchase quantities is limited to that maximum order quantity.

[0058] Furthermore, in the "1: Maximum Order Quantity Method" ordering method, if there is an unallocated quantity after allocating the purchase quantity to suppliers with higher priority, the remaining quantity is allocated to suppliers with lower priority.

[0059] In addition, under the "1: Maximum Order Quantity Method" ordering method, if it is not possible to allocate all the purchase quantities, the process of generating the planned order data will be stopped as an "error".

[0060] In the case of the "1: Maximum Order Quantity Method" ordering method, the data generation unit 22 loops through the suppliers detected from the order condition master table 11, in order of priority, until all purchase quantities have been allocated.

[0061] In other words, for example, if the total number of purchased items D is "2800 units", the data generation unit 22 will allocate the maximum order quantity of "1500 units" to the supplier with supplier code "S005", which has the highest priority.

[0062] Next, the data generation unit 22 determines that the maximum order quantity for the supplier with supplier code "S006", which has a priority of "2nd", is "0", and therefore allocates the remaining "1300" units to the supplier with supplier code "S006", as described above.

[0063] As a result, the purchase quantity of "2800 units" is divided and allocated to the supplier with supplier code "S005" and the supplier with supplier code "S006". As shown in Figure 9, the data generation unit 22 generates order plan data indicating that the purchase quantity of purchased item D will be divided and ordered to the suppliers with supplier codes "S005" and "S006" using the maximum order quantity method. Note that the example of order plan data in Figure 9 is an example in which the purchase quantity of 4800 units of purchased item D is divided and ordered to the suppliers with supplier codes "S005" and "S006".

[0064] To illustrate with another example, if the total number of purchased items D is "1400," the data generation unit 22 will allocate the number of purchases to the supplier with supplier code "S005," which has the highest priority.

[0065] As mentioned above, the maximum order quantity for supplier code "S005," which has the highest priority of "1," is "1500 units." Therefore, by allocating the purchase quantity to supplier code "S005," the allocation of the total purchase quantity of item D, "1400 units," is completed. In this case, the purchase quantity for suppliers with a priority of 2 or lower will be "0 units."

[0066] Next, the detection unit 21 refers to the order condition master table 11 shown in Figure 2 and detects the supplier code, priority, and order method classification of material E used in the manufacture of intermediate product B shown in Figure 8. In the example in Figure 2, the order method classification for material E is "2: apportionment method," which is one of the split order methods. Therefore, the detection unit 21 detects the order ratio corresponding to each supplier from the order condition master table 11.

[0067] Figure 12 shows the order condition data for the portion of the order condition master table 11 corresponding to material E. As shown in Figure 12, the order method classification for material E is the "2: apportionment method," where orders are divided and placed with three suppliers whose supplier codes are "S011" to "S013." Furthermore, the priority of the suppliers for supplier codes "S011" to "S013" is as follows: supplier code "S011" is ranked "1st," supplier code "S012" is ranked "2nd," and supplier code "S013" is ranked "3rd."

[0068] In this "2: apportionment method" ordering method, the data generation unit 22 calculates the number of purchases to be allocated to each supplier by performing the calculation "total number of orders × order ratio of the relevant supplier / sum of order ratios of all suppliers in the order condition master table" for each supplier of material E.

[0069] Specifically, for example, if the planned order quantity for material E is "2800 units", the data generation unit 22 calculates "840 units" as the order quantity for supplier S011 by performing the calculation "total order quantity of 2800 units × order ratio of supplier S011 of 60% ÷ total order ratio of all suppliers in order condition master table 11 of 200".

[0070] Furthermore, the data generation unit 22 calculates "700 units" as the number of units purchased by the supplier of S012 by performing the calculation "total number of orders 2800 units × order ratio of supplier S012 50% ÷ total order ratio of all suppliers in order condition master table 11 200".

[0071] Furthermore, the data generation unit 22 calculates "1260 units" as the number of units purchased by supplier S013 by performing the calculation "total number of orders 2800 units × order ratio of supplier S013 90% ÷ total order ratio of all suppliers in order condition master table 11 200".

[0072] The data generation unit 22 then generates order schedule data, as shown in Figure 9, indicating that the number of materials E to be purchased will be divided and ordered from suppliers with supplier codes "S011" to "S013" using a pro-rata method. The example of order schedule data in Figure 9 is an example where the number of materials E to be purchased (960 units) will be divided and ordered from suppliers with supplier codes "S011" to "S013".

[0073] In this case, if "2: Pro-rata allocation method" is set as the order method category in the order condition master table 11, performing the above calculation may result in decimal numbers in the quantity purchased for each supplier.

[0074] For example, consider an instance where 2775 units of material E are ordered and split between a supplier with supplier code "S011" (priority 1st) and a supplier with supplier code "S012" (priority 2nd). Furthermore, assume that a 60% order ratio is set for supplier code "S011" and a 50% order ratio is set for supplier code "S012".

[0075] In this case, the data generation unit 22 performs the calculation "Total order quantity 2775 units × Order ratio of supplier S011 60% ÷ Total of all suppliers' order ratios in the order condition master table 11 = 110". In this case, the number of purchases for supplier S011, which has the highest priority of "1st place", is calculated as "1513.6 units", resulting in a decimal number.

[0076] Furthermore, the data generation unit 22 performs the calculation "Total order quantity 2775 units × Order ratio of supplier S012 50% ÷ Total order ratio of all suppliers in order condition master table 11 = 110". In this case, the number of items purchased by supplier S012 is calculated as "1261.3 units", resulting in a decimal number.

[0077] If the calculation result contains decimal numbers, the data generation unit 22 removes the decimal number from the quantity of the supplier with lower priority and adds "1" to the quantity of the supplier with higher priority (increases the quantity of purchases by 1).

[0078] In this example, since supplier S012 has the "2nd" priority, the data generation unit 22 removes the decimal part from the number of items to be purchased from supplier S012 ("1261.3") to get "1261", and generates the planned order data for supplier S012.

[0079] In addition, the data generation unit 22 determines that supplier S011 has the highest priority, and therefore removes the decimal part from the number of items to be purchased from supplier S011 ("1513.6"), resulting in a purchase quantity of "1513 + 1" and generates the planned order data for supplier S012.

[0080] This allows for the generation of order planning data that balances the total number of purchases, ensuring that there are no shortages even if the number of purchases has a decimal point.

[0081] (Effects of the embodiment) As is clear from the above description, the business support device 1 of the embodiment can generate planned order data by calculating the number of orders for a single product number divided among multiple suppliers in the preliminary order planning to suppliers.

[0082] Therefore, when ordering the same item from multiple suppliers, the burden on the person in charge of creating order data can be reduced.

[0083] [Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This invention can contribute to improving operational efficiency and promoting appropriate management decisions by companies, and therefore can contribute to SDGs Goals 8 and 9.

[0084] Furthermore, this invention can contribute to reducing waste and promoting paperless and electronic processes, thereby contributing to SDGs Goals 12, 13, and 15.

[0085] Furthermore, this invention can contribute to strengthening control and governance, and therefore can contribute to achieving the 16th goal of the SDGs.

[0086] [Other embodiments] The present invention can be implemented in various different forms within the scope of the technical idea described in the claims, even in embodiments other than those described above.

[0087] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically may be performed manually. Alternatively, all or part of the processes described as being performed manually may be performed automatically by known methods or the like.

[0088] Furthermore, unless otherwise specified, the processing procedures, control procedures, specific names, registration data for each process, information including search conditions and other parameters, screen examples, and database configuration shown in the specification or drawings can be changed at will.

[0089] Furthermore, with respect to the business support device 1, each component shown in the diagram is a functional concept and does not necessarily have to have the physical configuration shown. For example, the processing functions of the business support device 1, particularly the processing functions performed by the control unit 3, may be implemented in whole or in any part by a program interpreted and executed by the control unit 3 (CPU: Central Processing Unit), or by hardware using wired logic.

[0090] The program is recorded on a non-temporary, computer-readable recording medium containing programmed instructions for the information processing device to execute the processes described in the embodiment, and is mechanically read by the business support device 1 as needed. In other words, the storage unit 2, such as ROM or HDD, records a computer program that works in cooperation with the OS (Operating System) to give instructions to the control unit 3 (CPU) and perform various processes. This computer program is loaded into RAM, unpacked, and executed by the control unit 3 as appropriate.

[0091] Furthermore, the business support program for this business support device 1 may be stored on another server device connected to the business support device 1 via any network, and all or part of it may be downloaded and executed as needed.

[0092] Furthermore, the business support program for executing the processes described in the embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program product.

[0093] Here, any "portable physical medium" can be used as the "recording medium," such as memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical Disks), DVDs (Digital Versatile Disks), and Blu-ray (Registered Trademark) Discs.

[0094] Furthermore, "program" refers to a data processing method written in any language or writing method, regardless of whether it is source code or binary code.

[0095] Furthermore, the term "program" is not necessarily limited to a single, monolithic entity, but also includes those that are distributed as multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions.

[0096] Furthermore, for the specific configuration, reading procedure, and post-reading installation procedure for the business support device 1 of the embodiment, well-known configurations or procedures can be used.

[0097] The storage unit 2 is a storage means such as a memory device like RAM or ROM, a fixed disk device like a hard disk, a flexible disk, and an optical disk, and stores various programs, tables, databases, and web page files used for various processing or website provision.

[0098] Furthermore, the business support device 1 may be composed of a known personal computer device or an information processing device such as a workstation, or it may be composed of an information processing device to which any peripheral devices are connected. In addition, the information processing device may be implemented by implementing software (including programs or data, etc.) that realizes the processing described in the embodiment.

[0099] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the figures, and all or part of them can be configured by functionally or physically distributing or integrating them in any unit according to various additions or functional loads. In other words, the embodiments described above can be selectively implemented by arbitrarily combining the embodiments described above. [Industrial applicability]

[0100] This invention is particularly suitable for application to ordering operations for purchased goods, and is especially effective when ordering the same purchased goods by dividing the orders among multiple suppliers. [Explanation of Symbols]

[0101] 1 Business support equipment 2 Storage section 3. Control Unit 4. Communication Interface Section 5 Input / Output Interface Section 6 Input devices 7 Output device 11 Order Conditions Master Table 12. Product Master Table 13. Manufacturing Configuration Master Table 14. Planning Data Storage Unit 15 Manufacturing instruction data storage unit 16. Order Schedule Data Storage Unit 21 Detection unit 22 Data Generation Unit 23 Output Control Unit 50 Networks 51 Supplier terminal equipment

Claims

1. A detection unit detects the supplier, the supplier's priority, the order method classification, and the purchase ratio information corresponding to the purchased item by referring to an order condition master table, which for each purchased item has a supplier, the priority of the supplier, an order method classification indicating whether the order for the purchased item is placed with a single supplier or a split order method indicating whether the order is divided and placed with multiple suppliers, and purchase ratio information indicating the purchase ratio of each supplier corresponding to the split order method, based on the purchased item. If the detected ordering method is the non-divided method, the data generation unit generates planned ordering data in which the supplier of the total number of purchases is the supplier associated with the purchase item and set in the ordering condition master table; if the detected ordering method is the divided ordering method, the data generation unit generates planned ordering data for each supplier, in which the total number of purchases of the purchase item is divided according to the purchase ratio indicated in the purchase ratio information, in the order of priority of each supplier; An output control unit that outputs the generated order schedule data to the output target device, A business support device having the following features.

2. The aforementioned split order method includes a maximum order method in which the maximum order quantity for each supplier is set as the purchase ratio according to the respective priority, and the total number of purchases is divided and allocated to each supplier based on the maximum order quantity for each supplier and orders are placed accordingly, and an apportionment method in which the total number of purchases is divided and allocated to each supplier based on the order ratio set according to the respective priority for each supplier and orders are placed accordingly. When the data generation unit detects a split order method from the order condition master table, it generates the planned order data corresponding to the number of purchases for each supplier allocated by the maximum order method or the apportionment method. The business support device according to claim 1, characterized by the following:

3. The data generation unit, when the apportionment method is set as the split order method, and the total number of purchases is apportioned based on the order ratio set for each supplier of the priority, if a fractional part of the number of purchases occurs, it generates order data for the supplier with the fractional part removed as the order data for the supplier with the lower priority that has the fractional part, and generates order data for the supplier with the fractional part added by one as the order data for the supplier with the higher priority that has the fractional part. The business support device according to claim 2, characterized by the following:

4. A detection step in which the detection unit, based on the purchased item, refers to an order condition master table which has, for each purchased item, a supplier, the priority of the supplier, an order method classification indicating whether the order for the purchased item is placed with a single supplier or divided into multiple suppliers, and purchase ratio information indicating the purchase ratio of each supplier corresponding to the divided order method, thereby detecting the supplier, the priority of the supplier, the order method classification, and the purchase ratio information corresponding to the purchased item. If the order method classification detected in the detection step is the non-divided method, the data generation unit generates order plan data in which the supplier of the total number of purchases is the supplier associated with the purchase item and set in the order condition master table; if the order method classification detected in the detection step is the divided order method, the data generation unit generates order plan data for each supplier in which the total number of purchases of the purchase item is divided according to the purchase ratio indicated in the purchase ratio information, in the order of priority of each supplier; The output control unit performs an output control step in which it outputs the generated order schedule data to the output target device, A business support method that has the following characteristics.

5. Computers, A detection unit detects the supplier, the supplier's priority, the order method classification, and the purchase ratio information corresponding to the purchased item by referring to an order condition master table, which for each purchased item has a supplier, the priority of the supplier, an order method classification indicating whether the order for the purchased item is placed with a single supplier or a split order method indicating whether the order is divided and placed with multiple suppliers, and purchase ratio information indicating the purchase ratio of each supplier corresponding to the split order method, based on the purchased item. If the detected ordering method is the non-divided method, the data generation unit generates planned ordering data in which the supplier of the total number of purchases is the supplier associated with the purchase item and set in the ordering condition master table; if the detected ordering method is the divided ordering method, the data generation unit generates planned ordering data for each supplier, in which the total number of purchases of the purchase item is divided according to the purchase ratio indicated in the purchase ratio information, in the order of priority of each supplier; Output control unit outputs the generated order schedule data to the output target device. A business support program designed to function as such.

Images