JP2004102890A - Information processing system for scheduling procurement of raw material from a plurality of companies - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To efficiently procure raw material of a specified amount such as lots which is determined by the unit of sale and transportation means and allow the actual result of the procured amount of the raw material from a plurality of procured companies based on a short term plan to meet the requirement of a long term plan. <P>SOLUTION: Procured company data is allocated to a scheduled procurement date based on the distribution ratio for the plurality of procured companies based on the long term plan and procured company allocation conditions specifying the allocation order of the procured companies. Based on the carry-over stock amount of the raw material, working lead time, storable upper limit amount, scheduled use amount on business days, procured companies, and lot unit procured amount determined between production departments, a processing in which the scheduled procurement date is carried over and a processing in which the scheduled procurement date is pushed ahead according to conditions are repeated. In the period of the plan, the scheduled procurement date is allocated so that a predicted stock amount obtained as a stock amount at the end of business or in holiday is over the stock lower limit amount and below the storable upper limit amount and the scheduled procurement date does not overlap the holiday. <P>COPYRIGHT: (C)2004,JPO

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to an information processing system for scheduling raw material procurement from a plurality of companies.
[0002]
[Prior art]
In general, manufacturers such as manufacturers, in their production activities, make a production plan in order to respond to demands from customers as well as to improve the efficiency of production, and to supply necessary materials such as raw materials according to this production plan. Have procured. On the other hand, holding unnecessary inventory is a wasteful expense for businesses, so inventory management is performed to reduce inventory as much as possible.However, raw materials procured for use in production activities are not used. Until it is completed, the storage space will be occupied as inventory. Therefore, it is necessary to efficiently procure such raw materials.
On the other hand, when procuring raw materials, it is necessary to secure a work lead time for performing quality inspection, pre-production preparation work, and the like in order to produce products of good quality. Ideally, raw materials should be able to be procured in the required quantity when needed.In practice, however, raw materials are sold in predetermined lot units, or the relationship between transportation means such as tank trucks and trucks or the supplier and purchaser. In general, the quantity is delivered in a certain unit because of the equipment.
[0003]
In addition, in large companies with large business scale, there are generally multiple suppliers, even if they are the same raw materials. Negotiate with the purchase price to determine the price and other conditions. At this time, the planned purchase amount presented by the purchaser is an expected numerical value, so that a contract is made to approach the numerical value presented in a certain period, or the actual order amount is 70,000 to 80. For example, a contract is made for 20,000, 80,000 to 90,000, and 90,000 to 90,000.
In planning a production plan and a material procurement plan for a certain period, the production planner considers the conditions related to the price of raw materials based on the above contract, geographical restrictions, restrictions due to transportation means and facilities, etc. The planned procurement amount is allocated to a plurality of suppliers that procure raw materials (see FIG. 19). Then, a delivery instruction plan is created so that this distribution ratio is satisfied, and raw material costs are paid as planned.
[0004]
[Patent Document 1]
Japanese Patent Application No. 2002-162773
[0005]
[Problems to be solved by the invention]
Conventionally, as described above, there has been a demand for a mechanism that can efficiently procure raw materials in a unit amount and that can reliably secure the work lead time.
In addition, when raw materials are ordered to multiple suppliers, the order quantity is allocated to each supplier as described above, but for raw materials, etc., there is an error or fluctuation in the delivery, Due to purchase transaction units, transportation restrictions, and restrictions on storage of raw materials, the actual delivery volume is not always as planned. Therefore, the cumulative result of the delivery amount (purchase amount) of the raw materials delivered from each supplier in a predetermined period (short term: for example, January) is determined as a result in the long term plan period (for example, half a year). There was a problem that the ratio of the allocation was not the same. Further, when there are a plurality of suppliers, the lot units of raw materials traded between the suppliers and the production department may be different from each other, and it is required to be able to cope with this.
The invention described in the specification attached to the application for Japanese Patent Application No. 2002-162773, which is a prior application filed by the present applicant, solves the above-mentioned problems and solves the problems described above, such as lots, etc. While it is possible to efficiently procure a large amount of raw materials and to ensure the work lead time, it has been desired to cope with the case where there are multiple suppliers as described above.
[0006]
The present invention has been made in view of the above points, and it is possible to efficiently procure a large amount of raw materials such as lots, which are determined by the relationship between purchasing units and transportation means, and to ensure the work lead time. In addition, the actual amount of raw materials procured from multiple suppliers will be close to the ratio of distribution determined for each supplier based on the long-term plan at the end of the long-term plan Another object of the present invention is to provide an information processing system for scheduling raw material procurement from a plurality of companies.
[0007]
[Means for Solving the Problems]
An information processing system according to the present invention is an information processing system that schedules the procurement of raw materials to be purchased from a plurality of suppliers within a predetermined planning period. After allocating the data indicating each supplier to the scheduled procurement date of the raw materials based on the supplier allocation conditions that define the allocation order when allocating the procurement, the amount of raw materials carried forward, the work lead time, the maximum available stock and the inventory Repeat the process of advancing and advancing the scheduled procurement date of raw materials according to the lower limit amount, the planned usage amount on each business day, and the lot unit procurement amount determined between each supplier and the relevant production department. If the estimated inventory amount calculated as the inventory amount at the end of each business day or as a holiday is not less than the lower Short-term plan creation means for creating a short-term plan to which the scheduled procurement date is assigned so that the scheduled procurement date does not overlap with the holidays, and the purchase results of all suppliers up to the current term based on the short-term plan created by the short-term plan creation means From the total procurement volume for each supplier obtained from the total volume of the procurement volume, the total volume of the planned usage amount on each business day in the next fiscal year, the allocation ratio to each supplier based on the long-term plan, and the purchase results of each supplier up to the current term Calculating the corrected next-period allocation ratio and setting the corrected next-period distribution ratio in place of the allocation ratio based on the long-term plan used by the short-term plan creation means when creating the next short-term plan Correction means.
Note that the distribution ratio correction means receives the input of the data of the purchase results after the results of the purchase in the current period based on the created short-term plan are determined, and adjusts the distribution ratio to each supplier in the next period as described above. calculate.
[0008]
Further, according to the present invention, in the information processing system according to claim 1, the short-term plan creating means assigns data indicating each supplier based on the allocation ratio and the supplier assignment condition to a business day when raw materials are to be used. Thereafter, as a first process, the data indicating the respective suppliers and the lot unit procured amount allocated to the scheduled use business day, which satisfies the planned use amount of the raw material, are used for each raw material use scheduled business day. The allocation and the procurement date of the raw material to which the lot unit procurement amount is allocated are advanced by the number of days of the work lead time, respectively.If any of the advanced procurement dates falls on a holiday, the procurement date corresponding to this holiday is set to the holiday. It is further advanced so as not to overlap with the above, and the data indicating the respective suppliers is allocated on each scheduled procurement date, and the lot unit procurement amount is Allocated as the scheduled procurement quantity on the scheduled delivery date, the previous day's value of the estimated stock quantity (provided that the estimated stock quantity on the first day before the scheduled procurement date within the plan period is the carry-over stock quantity), And a process of obtaining an estimated stock amount of the day from the planned use amount and, as a second process, after the first process, when there is a day on which the estimated stock amount exceeds the stockable upper limit amount or a procurement schedule. If the day is a holiday, the procurement dates after this date are moved forward one day at a time, and the data indicating each supplier is assigned on each procurement date, and the lot unit procurement amount is procured on each procurement date. If there is a day in which the estimated stock amount is less than the lower limit of inventory due to the deferral process of re-calculating the estimated stock amount, The schedule dates are advanced one day at a time, the data indicating the respective suppliers are allocated on each schedule date, the lot unit procurement amount is allocated as the schedule procurement date on each schedule date, and the estimated inventory amount is recalculated. It is characterized by executing a process of repeating the process.
[0009]
In addition, a procedure for allocating data indicating each supplier based on the distribution ratio and the supplier allocation condition, which is executed by the information processing system, on a business day when the raw material is to be used, and as a first processing procedure, a schedule for using the raw material The lot unit procurement amount assigned to the scheduled business day, which satisfies the scheduled business day usage amount, is assigned for each raw material scheduled business day, and the scheduled procurement date of the raw material assigned the lot unit procurement amount is assigned to each of the work. If one of the procured scheduled procurement dates falls on a holiday, the data will be further advanced so that the procured scheduled date corresponding to this holiday does not overlap with the holiday, and the respective procurement source data is shown on each scheduled procurement date. And the lot unit procurement amount is allocated as the procurement amount on each planned procurement date, and the A procedure for obtaining an estimated inventory amount on the day from the value and the estimated inventory amount on the day based on the estimated inventory amount on the day (the estimated inventory amount on the first day before the scheduled procurement date within the planning period is the aforementioned carry-over inventory amount), As a second processing procedure, after the execution of the first processing procedure, if there is a day when the estimated stock amount exceeds the upper limit of the stockable amount or when the scheduled procurement date is a holiday, The scheduled procurement dates are moved forward by one day each, the data indicating the respective procurement sources are allocated on each scheduled procurement date, the lot unit procurement amount is allocated as the planned procurement date on each procurement date, and the estimated stock amount is recalculated. If there is a day in which the estimated stock amount becomes less than the lower limit of inventory due to the deferral processing and the deferment of the scheduled procurement date, the scheduled procurement dates subsequent to this day are advanced one day at a time. A program for executing a process of allocating the data indicating each supplier on a day, allocating the lot unit procurement amount as the procurement amount of each procurement day, and repeating the advance process of recalculating the estimated stock amount. Alternatively, a computer-readable recording medium on which the program is recorded may be separately prepared, and the program may be installed and executed on the computer to schedule the procurement of raw materials on each business day in the planning period. .
[0010]
BEST MODE FOR CARRYING OUT THE INVENTION
Hereinafter, embodiments of the present invention will be described with reference to the drawings.
FIG. 1 is a block diagram illustrating a configuration of an information processing system according to an embodiment of the present invention.
[0011]
Reference numeral 1 denotes an information processing system according to the present embodiment, which will be described later, with regard to raw material to be scheduled for raw material procurement, supplier information, each supplier (in the present embodiment, a plurality of sources), and production. Multi-company purchase ratio (distribution ratio) Rl, which is the ratio of the procurement amount to be allocated to each supplier determined in the long-term plan, the work lead time, the maximum available stock, and the stock The lower limit amount is stored in a multi-company purchasing master, an equipment master, and a work lead by raw material, which are stored for each raw material (for each product name code) and / or for each production department (for each production department code) as described below. The storage unit 2 further includes a storage unit 2 for storing information such as a departmental calendar and a multi-company purchase logic, and a processing unit 3 for executing a processing procedure described later.
The product name code is defined for each raw material to be scheduled, and the production department code is defined for identifying each production department such as a factory. Hereinafter, a raw material code obtained by combining the product name code and the production department code will be used.
[0012]
Here, the supplier information is information indicating a business relationship between a business entity that is a supplier (a plurality) of a certain raw material and each production department that performs production using the raw material.
The lot unit procurement amount is the procurement amount rounded to the unit of purchase of the raw material or the unit (lot) determined by the relation of transportation means and equipment for each supplier and production department. A description will be given on the assumption that the raw material for one lot is a lot unit procured amount, and that the amount is equal to or more than the daily use amount, that is, the raw material satisfies the planned use amount of the raw material on the expected business day. Of course, if one lot is less than the daily scheduled use amount, a plurality of lots that satisfy the same condition may be processed as the lot unit procurement amount.
[0013]
The work lead time is provided as the number of days necessary to perform the acceptance inspection or the like when the acceptance inspection or the like is required before the raw material is actually used after the acceptance of the raw material. In addition, the upper limit amount of stock is an upper limit amount that can be stocked in a tank or a storage place where the raw material is stored, and the lower limit amount of stock is the minimum stock amount at all times (in the following description, , The lower limit of the inventory is set to 0 (zero)). In addition, the estimated stock amount is calculated as (planned procurement amount) + (estimated stock amount of the previous day (however, the estimated stock amount before the first day of the planned procurement day in the plan period is the carry-over stock amount) − (planned use amount). It is.
[0014]
Further, the section-specific calendar records a calendar indicating business days and holidays for each production section.
The multi-company purchasing logic regulates the order of allocation when allocating suppliers. For example, if the companies that will procure a certain raw material in the relevant production department are P and Q, the P , And the rest is assigned to company Q, or company P and company Q are assigned alternately.
[0015]
The above supplier information and the lot unit procurement amount for each supplier and production department are stored in the multi-company purchasing master using raw material codes for each product name code and production department code of the raw material to be scheduled. I have. The work lead time is stored in the work lead time master for each raw material for each product name code of the raw material. The upper limit of stockable amount and the lower limit of stock amount are stored in the device master using raw material codes for each product name code and production department code of the target raw material.
[0016]
The processing unit 3 includes a short-term plan creation unit 3a that executes a raw material procurement scheduling process for a predetermined period (a short period defined by a month, a week, and the like, and the same applies hereinafter). It includes a multi-company purchase ratio correction unit 3b for correcting the multi-company purchase ratio (allocation ratio) to be used. Hereinafter, the contents of the processing executed by these will be described, but before that, the preprocessing for calculating the required material amount according to the production request will be described. The following processing can be performed using conventional MRP (Material Requirements Planning) software (hereinafter, referred to as MRP calculation).
[0017]
In this MRP calculation, the following processing is performed from separately managed departmental calendars, raw material composition tables, and carry-over stock data consisting of carry-over stock amounts managed as performance information. As described above, a calendar indicating business days and holidays for each production section is recorded in the section-specific calendar. The raw material composition table is composed of information indicating the composition ratio of the raw materials necessary for producing the final product. Further, the carry-over stock amount is the stock amount of the raw material before the start of the plan period, that is, the carry-over stock amount from the previous plan period (the previous period: the plan period of the previous month when the plan period is a monthly unit) ( For example, when the plan period is in units of one month, the carry-over stock amount from the previous month). In addition, the amount to be used on each of the following business days is a necessary amount of the raw material that is to be used on that day in the production plan. The planned usage amount on each business day is determined based on the production request amount for the planning period and predetermined conditions.
[0018]
In the MRP calculation, first, an input of a production request for a predetermined period (the planned period) is received from a sales department or the like (FIG. 2: step S21).
Then, the required material amount for each production department for producing the requested product and its quantity (production request quantity) is calculated based on the given production request with reference to the carried-in stock data and the raw material composition table ( (FIG. 2: Step S22). For example, when it is requested to produce A product 1000 tons, to produce this A product 1000 tons, from the raw material composition table, the raw material a1 needs 150.5 tons, and how much else is needed. For example, when production is possible at the X factory, the Y factory, and the Z factory, the required amount of each raw material (material required amount) used for producing the product A, which is required at each factory (production department), is obtained. The conditions for allocating the production amount of the product to each production department are separately determined.
[0019]
Here, when the necessary material territory is determined for each production section, a raw material code (described above) indicating each raw material and each production section is generated. Further, the production amount (production plan amount) and the scheduled use amount are allocated to each business day of the production section for each production section based on the calendar of each production section with reference to the calendar for each section. Rough procurement plan (1) Generate data. Then, the generated rough procurement plan (1) data and carry-over stock amount are associated with the raw material code and recorded in the next procurement plan data temporary file (FIG. 2: step S23).
[0020]
When the rough procurement plan (1) data is created by the above MRP calculation, the short-term plan creation unit 3a performs the following processing for each raw material and each production department (that is, for each raw material code). The process described below is a scheduling process for a certain production department that procures one type of raw material. The information processing system 1 performs the following process for each raw material and each production department, Create a plan (short-term plan).
[0021]
First, from the information of the raw material suppliers (plurality) determined previously and stored in the multi-company purchasing master, the multi-company purchasing ratio Rl under this long-term plan is determined based on the separately prepared long-term plan. It is set (FIG. 3: step S31). The double company purchase ratio Rl is separately determined based on the result of price negotiations with the raw material maker or the like as the supplier. For example, the procurement amount from Company P is 6, and the procurement amount from Company Q is 4, so that the purchasing ratio of the two companies (P.6: Q.4) determined under the long-term plan is Set.
[0022]
Next, a double company purchase ratio (distribution ratio) Rs for setting a production plan for a predetermined period is set (FIG. 3: step S32). The multi-company purchase ratio Rs set at this stage uses the multi-company purchase ratio Rl under the long-term plan as an initial value, and thereafter, a procurement plan for a predetermined period (short-term plan) obtained by the following processing. Based on the results of raw material procurement (purchase results) executed based on the above, it will be corrected when making the next procurement plan. This correction is performed by the multi-company purchase ratio correction unit 3b so as to maintain the multi-company purchase ratio Rl for each supplier based on the long-term plan and the total purchase amount up to the current period and the planned usage amount on each business day in the next period. The short-term plan creator 3a calculates the multi-company purchase ratio Rs for each supplier in the next period from the sum total of the total amounts, and calculates the corrected multi-company purchase ratio Rs in the procurement plan for the next period. This ratio is set instead of the allocation ratio Rl based on the long-term plan to be used. A specific example will be described in an embodiment described later.
[0023]
Next, a rough procurement plan (1) is created (FIG. 3: step S33; see FIGS. 5, 9, and 14). At this stage, the rough procurement plan (1) data of the relevant production department is read from the next procurement plan data temporary file generated by the MRP calculation, and the read rough procurement plan (1) data is set as the rough procurement plan (1). I do.
Next, the number of procurement is determined (FIG. 3: step S34). Here, in the rough procurement plan (1), it is assumed that the raw materials will be procured on the business day on which the raw materials are to be used (the planned business day on which the raw materials will be used), and the number of business days on which the raw materials will be used is procured. Number of times.
[0024]
Next, based on the business partner information of the multi-company purchasing master, the supplier of raw materials for each production department is determined from the business relationship between the company that handles the necessary raw materials and the production department that produces the product. . If the companies that handle the necessary raw materials are, for example, companies P and Q, and the companies P and Q are the suppliers of the raw materials for the relevant production division, the procurement from the companies P and Q (Of course, the conditions for deciding the supplier are determined separately.) Further, each of the previously determined suppliers (supplier data) is determined based on the multiple-company purchase ratio Rs when making a production plan for a predetermined period and the multiple-company purchase logic (supplier allocation conditions) described later. For example, the raw material use scheduled business days of the rough procurement plan (2) shown in FIGS. 5, 9, and 14 are allocated (FIG. 3: step S35). Details will be described in an embodiment described later.
[0025]
Next, FIG. 3: A rough procurement plan (2) of step S36 is created. Here, based on the above-mentioned raw material code from the next procurement plan data temporary file, read the raw material and the carry-over stock amount corresponding to the production department, and further refer to the multi-company purchasing master to determine the supplier determined in the above step. The lot procurement amount corresponding to each supplier and the relevant production department is read from the (plurality), and the lot unit procurement amount for each supplier is read and the procurement schedule (2) (FIG. 4: Step S41).
[0026]
Further, the work lead time corresponding to the raw material is read from the work lead time master, and the day on which the lot unit procurement amount is allocated (this day is the planned raw material procurement date) is advanced by the number of days of the work lead time. Then, a process (lead time adjustment) of reallocating the supplier data corresponding to each of the advanced procurement dates and assigning the lot unit procurement amount corresponding to the supplier as the procurement schedule amount of each procurement date is performed (FIG. 4). : Step S42). However, by performing the advance processing, the day on which the scheduled procurement amount is set may overlap with a holiday (which is not a business day in the present embodiment). If any of the advanced procurement dates falls on a holiday in the calendar of the relevant production department that has been read, the procurement schedule date corresponding to this holiday is further advanced so that it does not overlap with the holiday, and the corresponding procurement schedule dates correspond. A process (holiday adjustment) of reallocating the supplier data and allocating the lot unit procurement amount as the procurement amount on each planned procurement date is performed (FIG. 4: step S43).
[0027]
Next, the estimated stock (initial value) of each business day is obtained (FIG. 4: step S44).
Here, as described above, the previous day's value of the estimated inventory amount calculated as the inventory amount at the end of each business day (at the end of production activity) or a holiday in the relevant production department (however, The estimated stock amount on the day is obtained from the estimated stock amount before the first day of the day is the carry-over stock amount), the scheduled procurement amount and the planned use amount on the day.
Steps S41 to S44 described above are the first processes executed by the short-term plan creator 3a.
[0028]
Next, the upper limit of stock and the lower limit of stock corresponding to the raw material and the production department are read from the device master, and if there is a day when the estimated stock exceeds this upper limit or if the scheduled procurement date is a holiday, Means that the scheduled procurement dates after this date will be decremented by one day each, the supplier data corresponding to each of the deferred procurement dates will be reallocated, and the lot unit procurement amount corresponding to this supplier will be procured on each procurement date. A deferral process (FIG. 4: step S45a) for allocating as an amount and further recalculating the estimated inventory amount, and when there is a day when the estimated inventory amount becomes less than the inventory lower limit amount due to this procurement date reduction, there is a day. The procurement dates following the next day are advanced by one day each, the supplier data corresponding to each advanced procurement date is reallocated, and the The unit procurement amount is allocated as the procurement amount on each planned procurement day, and the advance processing (FIG. 4: step S45b) for recalculating the estimated stock amount is performed at the end of each business day or on the holidays within the plan period. Until the estimated stock amount obtained as the quantity is equal to or more than the lower limit of the stock and equal to or less than the upper limit of the stockable amount, and furthermore, the scheduled procurement date does not overlap with the holiday (this condition is an end condition), Are repeated (FIG. 4: step S45).
Step S45 (S45a, S45b) described above is the second process executed by the short-term plan creation unit 3a.
[0029]
As a result of the above processing, information on the finally determined procurement plan (short-term plan) is output separately.
Then, based on the prepared procurement plan, the raw materials are procured, the purchase results are determined, and the data is input (FIG. 3: Step S38), as described above, the double-company purchase ratio correction unit 3b Is based on the long-term plan for each supplier based on the total purchase results of all suppliers up to the current fiscal year, the sum of all planned usage amounts for each business day in the next fiscal year, and the purchase results of each supplier up to the current fiscal year. Is calculated so as to maintain the multi-company purchase ratio Rl for the next period. Then, the corrected double-company purchasing ratio Rs is set in place of the distribution ratio Rl based on the long-term plan used by the short-term plan creator 3a when preparing the next-term procurement plan (FIG. 3: step S39). Thereafter, the processing steps of steps S32 to S39 are repeated over the period of the long-term plan.
[0030]
In this way, the procurement of the raw materials used in a certain production department is scheduled. As described above, the raw materials and / or the raw material and / or the work master by the multi-company purchasing master, the department-specific calendar, the equipment master, and the raw material. Alternatively, since there is required data for each production department, the information processing system 1 can centrally execute the scheduling of raw material procurement in all the production departments under management.
[0031]
The storage unit 2 is configured by a non-volatile recording device such as a hard disk or a magneto-optical disk.
The processing unit 3 includes a memory, a CPU (Central Processing Unit), and the like. A program (not shown) for realizing each function of the processing unit 3 is loaded into the memory and executed to execute the function. Shall be realized.
It is assumed that an input device, a display device, and the like (neither is shown) are connected to the information processing system 1 as peripheral devices. Here, the input device refers to an input device such as a keyboard and a mouse. The display device refers to a CRT (Cathode Ray Tube), a liquid crystal display device, or the like.
[0032]
Next, the operation of the information processing system 1 according to the present embodiment thus configured will be described with a specific example.
[0033]
[Example 1]
The example shown in FIGS. 5 to 8 is an example in the case of procuring raw material A using a tank. Generally, since the raw material stored in the tank is inspected before receiving, the work lead time is 0 (zero) days. In this embodiment, the upper limit of the stockable amount is 300, the procurement amount per lot of each supplier (in this example, company P and company Q) is 200, the carry-over stock amount is 20, and the planning period is 1 to 22 days. Days, and Saturdays and Sundays are holidays. The delivery of the raw material A is performed before the production activity is started in the production department.
[0034]
In FIG. 5, the production amount of the product in the production plan is 1000 on each of the business days from 3 to 15 (see the column denoted by reference numeral 5-1), and is used for producing the product. Assuming that the ratio of the raw material A to the production amount of the product is 0.1505, the scheduled use amount of the raw material A on each business day is 150.5 (see the column indicated by reference numeral 5-2). This setting is performed in the process of creating the rough procurement plan (1) described above.
[0035]
On the other hand, the number of procurements for the current period is calculated (in this embodiment, nine times), and each procurement source is assigned based on the multi-company purchasing logic. The multi-company purchasing logic in this embodiment is defined as allocating suppliers in an order cycle of placing an order for company P first and then ordering company Q. The initial value of the multi-company purchase ratio Rs (that is, the multi-company purchase ratio Rl) is assumed to be 6: 4 with respect to the P and Q companies. Under these conditions, the number of procurements for Company P is 5 times rounded from 9 × (6/10) = 5.4, and the number of procurements for Company Q is 9-5 = 4 times. From now on, the first five business days (the scheduled business days of using raw materials) in which the use of the raw material A is to be used, company P is allocated (company P is allocated first from the above-mentioned double company purchasing logic), and A supplier is assigned to assign company Q to each day (initial setting: see the column indicated by reference numeral 5-3).
[0036]
Then, a lot unit procurement amount of 200 corresponding to the production department and each supplier is allocated corresponding to the raw material use scheduled business day (initial setting: see the column indicated by reference numeral 5-4). In the present embodiment, the work lead time is 0 days, and in the above-mentioned initial setting, the scheduled procurement date does not overlap with the holiday, so that the lead-time adjustment and the advance processing by the holiday adjustment are not substantially performed. The assigned lot unit procurement amount of 200 for each supplier is allocated as the planned procurement amount (holiday adjustment) corresponding to each of the raw material use scheduled business days (see the column denoted by reference numeral 5-6). In FIGS. 5 to 8, blanks in the figures are 0 (zero).
[0037]
Then, during the planning period, the estimated stock amount of the current day is calculated from the planned use amount of the raw material, the planned procurement amount, and the estimated stock amount of the previous day, and the estimated stock amount corresponds to each day within the planning period. (See the column indicated by reference numeral 5-7). For example, in the case of Friday 3rd, the estimated use amount of the raw material is 150.5, the planned procurement amount is 200, and the estimated stock amount of the previous day (here, the carry-over stock amount) is 20, so the estimated stock amount of that day is Is 200 + 20−150.5 = 69.5.
[0038]
In this state, on Friday, the 10th, the estimated stock amount is 317, which exceeds the stockable upper limit amount of 300. In this case, by the processing of the above-described step S45a, the procurement schedule amount after Friday, 10th is reduced by one day, and the estimated stock amount is recalculated, as shown in FIG. 6A.
Then, on the 11th and Saturday and the 12th and Sunday, the estimated stock amount becomes 317, which exceeds the stockable upper limit amount. Therefore, the process of step S45a is performed twice again, and the result is as shown in FIG. In this way, the estimated inventory amounts on the 11th and Saturday and on the 12th and Sunday are both 117, which is less than the maximum possible inventory amount.
[0039]
However, at this stage, the estimated stock amount on Wednesday 15 is -134.5, which is less than the stock lower limit amount (here, 0). Therefore, by the processing in step S45b, the scheduled procurement dates on and after Thursday 16th, which is the next day after Wednesday 15th, are moved forward by one day, and the estimated stock amount is recalculated. As a result, the result is as shown in FIG. As a result, the estimated stock amount on Wednesday, 15th, becomes 65.5 or more, which is equal to or larger than the stock lower limit amount.
At this stage, the estimated inventory amount on Friday, 17th, is 465.5, exceeding the upper limit of the inventoryable amount of 300. Accordingly, in step S45a, the scheduled procurement dates on and after Friday, the 17th, are respectively moved forward by one day, and the estimated stock amount is recalculated, as shown in FIG. 7D.
[0040]
Even at this stage, the estimated inventory amount on Saturday, 18th is still 465.5, exceeding the maximum available inventory amount. Therefore, the scheduled procurement date is moved down in step S45a, but the raw materials are not used during the planning period after Saturday on the 18th, and the estimated stock amount remains at 465.5. Is repeated, and the scheduled procurement amount on Saturday 18 is deferred to outside the planned period, as shown in FIG. 7 (e). In this way, the estimated inventory amount after Saturday, 18th, is 265.5, which is 300 or less of the maximum available inventory amount, and finally, the estimated inventory amount within the planning period is a value within the maximum available inventory amount. Become.
Through the above processing, the scheduling of the raw material procurement for the current term is completed, and the contents of the columns of the planned procurement date, the allocation of the supplier, the planned procurement amount, and the estimated stock amount are determined as shown in FIG. In the example shown in FIG. 5, 265.5 of the estimated stock amount on the last day is the carry-over stock amount in the next planning period.
[0041]
In the material procurement plan obtained in this way, five orders are placed for Company P, and three orders are placed for Company Q to procure raw material A. Therefore, the planned procurement amount from Company P is 200 × 5 = 1000, and the planned procurement amount from Company Q is 200 × 3 = 600. In this case, the actual multi-company purchase ratio is 1000: 600 = 62.5: 37.5, which is 6: 4 of the multi-company purchase ratio Rl (= initial value of the multi-company purchase ratio Rs) based on the long-term plan. Although different, raw material A is procured based on the current term plan (short-term plan) obtained as described above.
[0042]
Then, when the actual production is performed, the ratio (62.5: 37.5) is not obtained again. This is because, as described above, a large amount of raw materials are delivered from a supplier, or production may not proceed as planned at a production site. Further, production may progress earlier than planned, or a trouble may occur at a supplier, and the supplier may be procured while changing the supplier, or the plan may be changed midway. If the plan changes, request a material procurement plan again.
[0043]
As a result of the raw material procurement based on the requested material procurement plan for the current term, the purchase results of each supplier up to the current term and the purchase results of all the suppliers up to the current term are determined. When these purchase results are determined, the multi-company purchase ratio Rs for calculating the next material procurement plan is calculated. Here, as illustrated in FIG. 9, the total purchase results of all the suppliers up to the current term are 1750, the production volume based on the production request in the next term is 2000, and the purchase result from the P company until this term is 1100 (planned). Assuming that the purchase performance from Company Q up to the current term is 650 (600 in the plan), the total amount of procurement planned for Company P in the next term is (Total procurement planned quantity for the next term (planned quantity) ) + The sum of the total purchase results up to the current term) × the multi-company purchase ratio R1 to the P company−the sum of the purchase results of the P company up to the current term = (2000 + 1750) × 0.60-1100 = 1150.
[0044]
Similarly, the total amount of procurement planned for Company Q in the next term is (total amount of total procurement planned for the next term + total purchase results up to the current term) x multi-company purchase ratio R1 to Company Q-Company Q up to the current term Total purchase results = (2000 + 1750) × 0.40−650 = 850. From these, the compound company purchase ratio Rs for the company P and the company Q in the next term is 1150: 850 = 57.5: 42.5. The short-term plan creator 3a executes the above-described processing to create the next-term material procurement plan based on the next-term double-company purchase ratio Rs thus obtained.
In this way, by repeating the multi-company purchase ratio Rs from the actual purchase results at the end of the short-term material procurement plan and creating the next plan, the long-term Raw materials can be procured from each supplier at a ratio close to the purchase ratio Rl.
[0045]
[Example 2]
The example shown in FIGS. 10 to 14 is an example in the case of procuring a raw material B that does not use a tank. In this case, after the procurement of the raw material B and before using the raw material B, a work lead time for performing an acceptance inspection (quality inspection), a melting operation of the raw material, and the like is usually required. In this embodiment, the work lead time is two days. Also, the upper limit of stockable amount is 500, the procurement amount per lot of each supplier (Company P and Company Q) is 200, the carry-over stock amount is 20, the planning period is 1 to 22 days, and Saturday and Sunday are holidays. I have. This embodiment is different from the above-described first embodiment in that two days are set as the work lead time and that the upper limit of the stockable amount is 500.
[0046]
In the example illustrated in FIG. 10, as in the first embodiment, the assignment is performed as illustrated in the columns indicated by reference numerals 10-1 to 10-4.
In this embodiment, since the work lead time is two days, the procurement scheduled date for the work lead time of two days is advanced by the advance processing in step S42 described above (reference numerals 10-5 and 10-6). Column). As a result of this advance, the scheduled holidays of 4 (Sat) and 5 (Sun) and 11 (Sat) and 12 (Sun) will be the procurement dates. Therefore, in the process of step S43, these procurement dates coincide with the holidays. The carry-over is performed so as not to occur, and the columns shown by reference numerals 10-6 and 10-7 are formed. At this stage, the estimated stock amount of each day in the planning period is as shown in a column indicated by reference numeral 10-9. In FIGS. 10 to 14, blanks in the figures are 0 (zero).
[0047]
At this time, the estimated stock amount on the 6th and Monday is 519, which exceeds the stockable upper limit amount. Therefore, the process of step S45a is performed, and the result is as shown in FIG. In this way, the estimated stock amount on the 6th and Monday is 319, which is equal to or less than the stockable upper limit amount.
However, the estimated stock amount on the 10th and Friday is 517, which exceeds the stockable upper limit amount. Therefore, the process of step S45a is executed again, and the result is as shown in FIG. In this way, the estimated stock amount on the 10th and Friday is 317, which is equal to or less than the stockable upper limit amount.
[0048]
At this stage, the estimated inventory amount on the 11th / Saturday is still 517, which exceeds the maximum available inventory amount. Therefore, the process of step S45a is executed again, and the result is as shown in FIG. Thus, the estimated stock amount on the 11th and Saturday is 317, which is less than the stockable upper limit amount. However, the estimated stock amount on the 12th and Sunday is 517, which exceeds the stockable upper limit amount. Therefore, the process of step S45a is executed again, and the result is as shown in FIG. Thus, the estimated stock amount on the 12th and Sunday is 317, which is less than the stockable upper limit amount. At this time, the remaining amount is equal to or less than the upper limit of the stockable amount even after 13 days.
At this stage, the scheduling of the raw material procurement is completed, and the contents of the columns of the planned procurement date, supplier allocation, planned procurement amount, and estimated stock amount are determined as shown in FIG. In the example shown in FIG. 13, 465.5 of the estimated stock amount on the last day is the carry-over stock amount in the next planning period.
[0049]
FIG. 14 shows that in this embodiment, the procured material lot (arrival lot) can secure two days of the work lead time before it is actually used. This work lead time can be secured by adjusting the lot unit procurement amount or the stockable upper limit amount. Normally, a work lead time can be secured by providing a sufficient stockable upper limit amount.
[0050]
As described above, the material procurement plan for the current term is created, and thereafter, the raw material B is procured based on this plan, and the purchase results for the current term are determined. When the purchase results are determined, as in the case of the first embodiment, the multi-company purchase ratio Rs for calculating the next material procurement plan is calculated, and the material procurement for the next period is calculated using the calculated multi-company purchase ratio Rs. Repeat the process of creating a plan.
[0051]
[Example 3]
The present embodiment shown in FIGS. 15 to 18 is an example in the case of procuring a raw material A ′ using a tank, and the basic conditions are the same as those in the first embodiment. This is an example in which the procurement amounts are different (Company P is 200 units, Company Q is 220 units), and the multi-company purchasing logic is different from the first embodiment.
The multi-company purchasing logic in the present embodiment specifies that suppliers are assigned in an order cycle in which orders are alternately placed with Company P and Company Q. Other conditions are the same as in the first embodiment, that the work lead time is 0 (zero) days, the maximum stockable amount is 300, the carry-over stock amount is 20, the planning period is 1 to 22 days, and Saturday and Sunday are holidays. I have.
[0052]
In the example illustrated in FIG. 15, as in the first embodiment, allocation is performed as illustrated in columns indicated by reference numerals 15-1 to 15-2 (creation of a rough procurement plan (1)). On the other hand, the number of procurements for the current term is obtained (in this embodiment, nine times).
The number of times of procurement to each supplier is five for P and four for Q as in the first embodiment. Based on the number of procurements, a supplier is allocated as shown in a column 15-3 (initial setting: procedure 1).
[0053]
At this stage of the initial setting, as in the case of the first embodiment, the company P is allocated first, and the company Q is allocated thereafter. Thereafter, the supplier assignment is reset according to the multi-company purchasing logic of this embodiment (procedure 2). Here, the character strings composed of the initially set columns of the supplier data are replaced with the character strings based on the preceding multi-company purchasing logic, for example, as follows.
PPPPPQQQQ → PQPQPQPQP
From the character string (data string) composed of the supplier data obtained in this way, the supplier data is set again in the supplier assignment column shown in the column 15-4.
[0054]
Then, the lot unit procurement amount corresponding to the production department and each supplier (Company P: 200, Company Q: 220) is allocated to each assigned business day when the raw material is to be used. (Initial setting: see the column denoted by reference numeral 15-5). In the present embodiment, the work lead time is 0 days, and in the above-mentioned initial setting, the scheduled procurement date does not overlap with the holidays. Not substantially performed, and 200 or 220 of the lot unit procurement amount of each supplier allocated above is allocated as the planned procurement amount corresponding to each supplier allocated on the raw material use scheduled business day (reference numeral 15-). 7). In FIGS. 15 to 18, blanks in the figures are 0 (zero).
[0055]
Then, in the plan period, the estimated stock amount of the day is calculated, and the estimated stock amount is allocated to each day in the plan period (see the column indicated by reference numeral 15-8). For example, in the case of Monday, 6th, the planned use amount of the raw material is 150.5, the planned procurement amount from Company Q is 220, and the estimated stock amount of the previous day is 69.5. 220 + 69.5-150.5 = 139.
[0056]
In this state, on the 9th and Thursday, the estimated stock amount is 307.5, which exceeds the stockable upper limit amount of 300, and after this date, exceeds the stockable upper limit amount of 300. In this case, the scheduled procurement amount on and after Thursday, 9th is reduced by one day and the estimated stock amount is recalculated by the processing in step S45a described above, and the result is as shown in FIG.
Then, on the 11th and Saturday and the 12th and Sunday, the estimated stock amount becomes 377, which exceeds the stockable upper limit amount. Therefore, the process of step S45a is executed twice again, and the result is as shown in FIG. In this way, the estimated stock amounts on the 11th and Saturday and on the 12th and Sunday are both 157, which is less than the maximum available stock.
[0057]
However, at this stage, the estimated stock amount on Wednesday 15th is -74.5, which is less than the stock lower limit amount (here, 0). Therefore, by the processing in step S45b, the scheduled procurement dates on and after Thursday 16th, which is the next day after Wednesday 15th, are moved forward by one day, and the estimated stock amount is recalculated. As a result, the result is as shown in FIG. As a result, the estimated stock amount on Wednesday, 15th, becomes 125.5, which is equal to or larger than the stock lower limit amount.
At this stage, the estimated stock amount on Thursday 16th is 345.5, which exceeds the stockable upper limit amount of 300. Therefore, in step S45a, the scheduled procurement dates on and after Thursday 16 are each moved back one day, and the estimated stock amount is recalculated, as shown in FIG. 17D. As a result, the estimated stock amount on Thursday 16th becomes 125.5, which is equal to or less than the stockable upper limit amount.
[0058]
Even at this stage, the estimated stock amount on Friday the 17th is still 345.5, which exceeds the available stock amount. Therefore, although the scheduled procurement date is moved down in step S45a, the raw materials are not used during the planning period after Friday, the 17th, and the estimated stock amount remains above the maximum possible stock amount. Step S45a is repeated, and the procured procurement amounts on Friday the 17th and Saturday the 18th in FIG. 17 are deferred to outside the planned period, as shown in FIG. 18 (e). In this manner, the estimated inventory amount after Friday, 17th, is 125.5, which is 300 or less of the maximum available inventory amount, and finally, the estimated inventory amount within the planned period is a value within the maximum available inventory amount. Become.
[0059]
Through the above processing, the scheduling of the raw material procurement for the current term is completed, and the contents of the columns of the planned procurement date, supplier allocation, planned procurement amount and estimated stock amount are determined as shown in FIG. Complete. Thereafter, based on this material procurement plan, the raw material A 'is procured, and the purchase results are determined. When the purchase results are determined, the multi-company purchase ratio Rs is calculated from the purchase results up to the current term, and a material procurement plan for the next term is created. This processing is as described in the first embodiment.
[0060]
As shown in the present embodiment, even if the lot unit procurement amount of each supplier for the production department is different, the material procurement plan can be similarly created by the processing procedure in the present embodiment. Then, by correcting the multi-company purchase ratio Rs based on the purchase result, the purchase result is achieved at a rate close to the double-company purchase ratio Rl determined in the long-term plan as a result during the long-term plan. be able to.
[0061]
The details of the information processing system 1 according to the embodiment of the present invention have been described above.
In the above description, the information processing system 1 has been described as performing scheduling processing of raw material procurement on a daily basis. The same processing may be performed in units of time, and other amounts (planned use amount, planned procurement amount, and the like) may be replaced with time units. In this way, it is possible to execute precise scheduling in units of time.
[0062]
Further, a program for realizing the function of the processing unit 3 in FIG. 1 is recorded on a computer-readable recording medium, and the program recorded on this recording medium is read into a computer system and executed, thereby allowing a plurality of companies to execute the program. Raw material procurement may be scheduled. Here, the “computer system” includes an OS and hardware such as peripheral devices.
[0063]
The “computer system” also includes a homepage providing environment (or a display environment) if a WWW system is used.
The “computer-readable recording medium” refers to a portable medium such as a flexible disk, a magneto-optical disk, a ROM, and a CD-ROM, and a storage device such as a hard disk built in a computer system. Further, the “computer-readable recording medium” refers to a volatile memory (RAM) inside a computer system that becomes a server or a client when a program is transmitted via a network such as the Internet or a communication line such as a telephone line. In addition, programs that hold programs for a certain period of time are also included.
[0064]
Further, the above program may be transmitted from a computer system storing the program in a storage device or the like to another computer system via a transmission medium or by a transmission wave in the transmission medium. Here, the “transmission medium” for transmitting a program refers to a medium having a function of transmitting information, such as a network (communication network) such as the Internet or a communication line (communication line) such as a telephone line.
Further, the program may be for realizing a part of the functions described above. Furthermore, what can implement | achieve the function mentioned above in combination with the program already recorded on the computer system, and what is called a difference file (difference program) may be sufficient.
[0065]
The embodiment of the present invention has been described in detail with reference to the drawings. However, the specific configuration is not limited to this embodiment, and includes a configuration and the like without departing from the gist of the present invention. The present invention aims at scheduling raw material procurement from a plurality of companies. One of the objects of the present invention is to procure raw materials from a plurality of companies. In each of the above-described embodiments in which raw materials are procured from two companies, P and Q, for example, when raw materials are procured only from P, Q = P in the allocation process of the supplier (Q By replacing the company with the company P), a procurement plan can be created in the same manner.
[0066]
【The invention's effect】
As described above in detail, according to the information processing system of the present invention, the scheduling of raw material procurement can be automatically performed. Also, by scheduling raw material procurement by the information processing system of the present invention, it is possible to ensure the work lead time and to efficiently procure a large amount of raw materials such as lots, which are determined by the relationship between purchase units and transportation means. You will be able to do well.
In addition, the actual amount of raw materials procured from multiple suppliers over a given period of time will be close to the ratio specified for each supplier at the end of the long-term plan, based on the long-term plan. It is possible to schedule procurement.
[Brief description of the drawings]
FIG. 1 is a block diagram illustrating a schematic configuration of an information processing system according to an embodiment of the present invention.
FIG. 2 is a part of an operation flowchart (schematic) of the information processing system of the embodiment.
FIG. 3 is a part of an operation flowchart (schematic) of the information processing system of the embodiment.
FIG. 4 is an operation flowchart (schematic) further illustrating steps S36 and S37 in FIG. 3;
FIG. 5 is a diagram illustrating Example 1 of the information processing system according to the embodiment.
FIG. 6 is a diagram for describing Example 1 of the information processing system of the embodiment.
FIG. 7 is a diagram (continuation of FIG. 6) for describing Example 1 of the information processing system of the embodiment.
FIG. 8 is a diagram illustrating Example 1 of the information processing system according to the embodiment.
FIG. 9 is a diagram illustrating a process of correcting a double company purchase ratio Rs based on purchase results.
FIG. 10 is a diagram for explaining Example 2 of the information processing system of the embodiment.
FIG. 11 is a diagram for describing Example 2 of the information processing system of the embodiment.
FIG. 12 is a diagram (continuation of FIG. 11) for describing Example 2 of the information processing system of the embodiment.
FIG. 13 is a diagram for explaining Example 2 of the information processing system of the embodiment.
FIG. 14 is a diagram for explaining Example 2 of the information processing system of the embodiment.
FIG. 15 is a diagram for explaining Example 3 of the information processing system of the embodiment.
FIG. 16 is a diagram for describing Example 3 of the information processing system of the embodiment.
FIG. 17 is a diagram (continuation of FIG. 16) illustrating Example 3 of the information processing system of the embodiment.
FIG. 18 is a diagram for explaining Example 3 of the information processing system of the embodiment.
FIG. 19 is a diagram showing an example of distribution of a planned amount (planned procurement amount) to each production department and each supplier.
[Explanation of symbols]
1. Information processing system
2… Storage unit
3. Processing unit
3a: Short-term plan creation section (short-term plan creation means)
3b: Double company purchase ratio correction unit (distribution ratio correction means)

Claims (2)

In an information processing system that schedules procurement of raw materials to be purchased from a plurality of suppliers within a predetermined planning period,
After allocating the data indicating each supplier based on the scheduled procurement date of the raw materials based on the allocation ratio of the planned procurement amount to each supplier based on the long-term plan and the supplier allocation conditions that specify the allocation order when allocating the suppliers, Procurement of raw materials according to the carry-over stock amount, work lead time, upper limit of stockable amount, lower limit of stock amount, planned use amount on each business day, and lot unit procurement amount determined between each supplier and the relevant production department The process of moving the date forward and the process of raising the date are repeated, and within the plan period, the estimated inventory amount calculated as the inventory amount at the end of each business day or on a holiday is equal to or more than the minimum inventory amount and equal to or less than the maximum available inventory amount, and A short-term plan creating means for creating a short-term plan that assigns a planned procurement date so that the planned procurement date does not overlap with a holiday;
The total amount of purchase results of all suppliers up to the current period based on the short-term plan created by the short-term plan creation means, the total amount of planned usage on each business day of the next fiscal year, and the distribution ratio to each supplier based on the long-term plan Based on the procurement results for each supplier up to the current term and the expected procurement amount for each supplier obtained from the procurement amount for each supplier, calculate the corrected distribution ratio for the next term, and when creating a short-term plan for the next term, the short-term plan creation means An information processing system, comprising: a distribution ratio correction unit that sets the corrected distribution ratio for the next term in place of the distribution ratio based on the long-term plan to be used. The short-term plan creation means,
After allocating data indicating each supplier based on the allocation ratio and supplier allocation conditions on the scheduled business day of the raw material,
As the first process,
Satisfies the planned use amount of the raw material scheduled business day, allocates the data indicating the respective suppliers allocated to the planned use business day and the lot unit procured amount for each raw material planned business day,
Advance the scheduled procurement date of the raw material to which the lot unit procurement amount is assigned by the number of days of the work lead time, respectively.
If any of the procured scheduled procurement dates falls on a holiday, the procured procurement date corresponding to this holiday is further advanced so as not to overlap with the holiday. Is allocated as the planned procurement amount on each planned procurement date,
From the previous day's value of the estimated stock amount, (the estimated stock amount before the first day of the scheduled procurement day within the planning period is the carry-over stock amount), and the estimated procurement amount and planned use amount of the day, Execute the process to find the inventory amount,
As a second process,
After the first processing, when there is a day when the estimated stock amount exceeds the upper limit of the available stock or when the procurement date is a holiday, the procurement dates after this date are decremented by one day. A deferral process of allocating the data indicating each of the suppliers on the scheduled date and allocating the lot unit procured amount as the planned procured amount on each scheduled procurement date, and further recalculating the estimated stock amount;
If there is a day on which the estimated stock amount becomes less than the lower limit of inventory due to the deferment of the scheduled procurement date, the scheduled procurement dates subsequent to this day are advanced by one day each, and the 2. The process according to claim 1, further comprising: allocating the indicated data, allocating the lot unit procurement amount as the planned procurement amount on each planned procurement date, and further repeating the advance process of recalculating the estimated stock amount. Information processing system.

Images