JP2010003202A - Arrangement instruction planning program, arrangement instruction planning device, and arrangement instruction planning method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To draw up an arrangement instruction plan in which the amount of arrangements is adjusted so as to come close to a determined distribution ratio as much as possible while satisfying a delivery condition for each ordering destination. <P>SOLUTION: A priority determining means 3 determines respective priorities of ordering destinations so as to give a higher priority to an ordering destination in which the total period of an arrangement cycle and a lead time is longer. Next, a number of distributions determining means 4 determines the number of distributions of each of the ordering destinations according to a distribution ratio of each of the ordering destinations. Further, the number of arrangements determining means 5 selects the ordering destinations in the order of a higher priority, and sequentially determines an arrangement instruction date in an arrangements cycle interval within a planning period of the selected ordering destinations. The number of arrangements determining means 5 determines a number needed to satisfy a required number in a delivery date as the number of arrangements in the arrangements instruction date within the range where the total of the numbers of arrangements does not exceed the number of distributions. <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention relates to an arrangement instruction planning program, an arrangement instruction planning apparatus, and an arrangement instruction planning method for formulating an arrangement instruction plan for parts, and in particular, an arrangement instruction plan for parts to a plurality of suppliers who can order parts of the same specification. The present invention relates to an arrangement instruction planning program, an arrangement instruction planning device, and an arrangement instruction planning method.

  When mass-producing industrial products composed of a large number of parts, the same kind of parts are often procured from a plurality of suppliers. For example, in the case of a memory chip built in a computer, a plurality of companies produce memory chips that conform to a predetermined standard. Therefore, a company that manufactures a computer purchases memory chips from a plurality of vendors, thereby securing memory chips necessary for manufacturing the computer. Hereinafter, parts that can be procured from a plurality of suppliers will be referred to as multi-vendor parts.

In order to procure multi-vendor parts, it is necessary to place an order of an appropriate quantity at an appropriate time for each vendor (seller). When there are a large number of multi-vendor parts, it is difficult to manually manage which parts should be ordered to which vendor when. In view of this, a technique for managing order using a computer system has been considered (see, for example, Patent Documents 1-4).
JP 2001-265418 A JP 2002-73750 A JP 2004-102890 A JP 2006-39869 A

  By the way, the price of parts delivered from a vendor is determined by negotiation between the purchaser and the vendor. If the price is negotiated every time a part is ordered from the vendor, the daily ordering becomes unstable. Therefore, the unit price is usually negotiated with the vendor in advance. In addition, the discount rate etc. of the purchase price of parts changes by price negotiation based on the total number of purchases in a month. For this reason, the orderer determines the planned quantity to be ordered from each vendor in advance and negotiates the price with the vendor.

  When the purchase price of multi-vendor parts from each vendor is determined, the orderer needs to place an order so that the total amount negotiated in advance is reached. Therefore, every time the orderer orders multi-vendor parts, the orderer determines the number of arrangements to each vendor according to the delivery distribution ratio among the multi-vendors and places an order. Conventionally, the number of these arrangements has been determined by a human being entering a data table such as a table of spreadsheet software.

  However, while satisfying conditions such as procurement conditions, required quantity (daily required quantity), delivery lot units, delivery distribution ratio, etc., which vary from vendor to vendor, a predetermined amount of parts is used every day so that the planned allocation is achieved. Arranging is a difficult task.

  The present invention has been made in view of such points, and an arrangement instruction plan that can devise an arrangement instruction plan in which the arrangement quantity is adjusted so as to be as close as possible to the distribution rate while satisfying the delivery conditions for each supplier. An object is to provide a program, an arrangement instruction planning device, and an arrangement instruction planning method.

  In order to solve the above-described problems, an order instruction plan program is provided that causes a computer to execute a part order instruction plan formulation process for a plurality of suppliers who can order parts of the same specification. This arrangement instruction planning program causes the computer to function as the following means.

  The delivery condition storage means associates with each supplier to which the parts are delivered, arranges an arrangement cycle indicating an interval at which the parts can be ordered, a lead time indicating a period from when an order is placed to the supplier to delivery, and Stores a distribution ratio indicating a ratio to be ordered from the ordering party out of the number of orders of the entire part. The required number storage means stores a required number indicating the number of parts required for the corresponding day for each date. The priority order determining means refers to the delivery condition storage means, and determines the priority order of each ordering party so that the ordering order becomes higher in the ordering party that has a longer total period of arrangement cycle and lead time. The distribution number determining means refers to the required number storage means and totals the required numbers for each date within the planning period specified in advance to obtain the total required number. Refers to the delivery condition storage means and distributes to each supplier. The number obtained by proportionally distributing the total required number according to the rate is set as the distribution number of each supplier. The order quantity determination means selects an ordering party in order from the highest priority, determines an ordering date for an ordering cycle interval within the plan period of the selected ordering party, and indicates the quantity of parts to be ordered to the selected ordering party. As long as the total number of arrangements does not exceed the number of distributions, the number required to satisfy the required number on the delivery date after the lead time from the arrangement instruction date is determined as the number of arrangements on each arrangement instruction date for the selected supplier To do.

  According to such a computer that executes the order instruction planning program, the priority order determining means sets the priority order of each ordering party so that the ordering order becomes higher in the ordering party with a longer total period of arrangement cycle and lead time. It is determined. Next, the required number for each date within the plan period is totaled by the distribution number determining means to obtain the total required number, and the total number required is proportionally distributed according to the distribution ratio of each supplier. It is said. Then, the ordering number determination means selects the ordering party in order from the highest priority, determines the ordering date for the selected ordering party, and the required number on the delivery date within the range where the total number of ordering does not exceed the distribution number The number necessary to satisfy the requirement is determined as the number of arrangements on each arrangement instruction date for the selected supplier.

  In addition, an arrangement instruction apparatus having the same function as a computer that executes the arrangement instruction planning program is provided. Furthermore, an arrangement instruction planning method for performing the same processing as that of the computer executing the arrangement instruction planning program is provided.

  The computer that executes the arrangement instruction planning program can control the arrangement quantity so as to be as close as possible to the determined distribution ratio while satisfying the parts arrangement conditions for each vendor.

Hereinafter, embodiments of the present invention will be described with reference to the drawings.
FIG. 1 is a diagram showing an outline of the embodiment. In the present embodiment, a delivery condition storage unit 1, a required number storage unit 2, a priority order determination unit 3, a distribution number are prepared in order to formulate an arrangement instruction plan 6 for a plurality of suppliers who can order parts of the same specification. Each function of the determination means 4 and the arrangement number determination means 5 is provided.

  The delivery condition storage means 1 is associated with each supplier to which the parts are delivered, an arrangement cycle indicating an interval at which the parts can be ordered, a lead time indicating a period from when the order is placed to delivery, In addition, a distribution ratio indicating a ratio to be ordered from the ordering party out of the total number of parts ordered is stored. The arrangement cycle and the lead time are the number of days designated in advance by the ordering party. The distribution rate is a value determined by the ordering party based on the contractual relationship with the ordering party, and is shown as a percentage, for example. The delivery condition storage means 1 can also store the number of deliverables per order for each part of the ordering party.

  The required number storage means 2 stores a required number indicating the number of parts required for the corresponding day for each date. The required number is a value set in advance by the orderer based on a production plan of a product using each part.

  The priority order determining means 3 refers to the delivery condition storage means 1 and determines the priority order of each ordering party so that the ordering order becomes higher in the ordering party having a longer total period of arrangement cycle and lead time. That is, a higher priority is set for an ordering party that requires a long-term plan for delivery on a target date.

  The distribution number determining means 4 refers to the required number storage means 2 and sums the required numbers for each date within the planning period specified in advance to obtain the total required number. The number obtained by proportionally allocating the total required number according to each distribution ratio is set as the distribution number of each supplier. For example, if the distribution rate is indicated by a percentage, the total required number is multiplied by the distribution rate of the ordering party and divided by 100 is the distribution number of the ordering party. The planning period is set in accordance with the parts arrangement conditions for the supplier with the highest priority. For example, the plan period is the total period of the arrangement cycle and lead time of the supplier with the highest priority.

  The number-of-arrangements determination means 5 selects an ordering party in order from the highest priority. Next, the arrangement number determination means 5 determines an arrangement instruction date for an arrangement cycle interval within the planned period of the selected supplier. Furthermore, the order quantity determination means 5 satisfies the required quantity on the delivery date after the lead time from the order instructed date, so long as the total order quantity indicating the quantity of parts ordered to the selected supplier does not exceed the distribution number. Is determined as the number of arrangements on each arrangement instruction date for the selected supplier. The order quantity determination means 5 determines the number of deliverables per order of the ordering party for the selected ordering party when the delivery condition storage means 1 specifies the number of deliverable parts per order. The upper limit of the number of orders placed on the order date.

  Based on such a configuration, first, the priority order determining means 3 determines the priority order of each ordering party so that the ordering order becomes higher in the ordering party having a longer total period of arrangement cycle and lead time. In the example of FIG. 1, company A and company B are registered in the delivery condition storage means 1 as orders. The arrangement cycle of Company A is 7 days, the lead time is 3 days, and the total period is 10 days. On the other hand, the arrangement cycle of company B is 1 day, the lead time is 2 days, and the total period is 3 days. Accordingly, Company A has a higher priority than Company B.

  Next, the required number for each date within the plan period is totaled by the distribution number determining means 4 to obtain the total required number. Further, the distribution number determining means 4 sets the distribution number of each ordering party as a number obtained by proportionally distributing the total required number according to the distribution rate of each ordering party. In the example of FIG. 1, it is assumed that the planning period is 10 days from January 1, 2007. In the required number storage means 2, a value of “20” is registered as the required number every day. Then, the total required number is “200” (20 × 10). Further, the delivery condition storage means 1 is set with a distribution ratio “20%” for company A and a distribution ratio “80%” for company B. Then, the distribution number of company A is “40” (20% of 200), and the distribution number of company B is “160” (80% of 200).

  Further, the order number determination means 5 selects the ordering destinations in order from the highest priority. The arrangement number determination means 5 determines an arrangement instruction date at an arrangement cycle interval within the planned period of the selected ordering party, with the distribution number of the selected ordering party as an upper limit. Then, the number of parts required to satisfy the required number of parts on the delivery date after the lead time from the arrangement instruction date by the arrangement quantity determination means 5 is the quantity of the parts to be ordered to the selected supplier on the arrangement instruction date. Determined as the number of arrangements shown.

  In the example of FIG. 1, company A is selected first. And the arrangement | positioning instruction | indication date with respect to A company is determined based on the arrangement cycle of A company. For example, since the arrangement cycle of Company A is 7 days, it can be ordered only once a week. In the example of FIG. 1, the case where the next order date is January 5, 2007 is shown. Then, only one day on January 5, 2007 can be ordered from Company A within the planned period. Therefore, the number of arrangements “40” with the upper limit of the number of distributions is determined for Company A on January 5, 2007.

  Next, Company B is selected. And the arrangement | positioning instruction | indication day with respect to B company is determined based on the arrangement cycle of B company. For example, since the arrangement cycle of company B is one day, it can be ordered every day. Here, the distribution number of company B is 160, but the number of deliverables per order is “20”. Therefore, the number of daily arrangements from January 1, 2007 to January 5, 2007 for Company B and the daily arrangements for Company B from January 8, 2007 to January 10, 2007 are as follows. It is determined to be “20”.

  The number of arrangements for Company B on January 6, 2007 and January 7, 2007 is “0”. This is because the required number of delivery dates is satisfied in the arrangement instruction of company A previously determined. That is, the lead time of Company A is 3 days, and 40 parts ordered on January 5, 2007 are delivered on January 8, 2007. Since the daily required number is 20, delivery from Company A on January 8, 2007 satisfies the required number for two days. Therefore, delivery from Company B is unnecessary on January 8, 2007 and January 9, 2007. Company B ’s lead time is 2 days, so the delivery date for Company B will be January 8, 2007 and January 9, 2007, January 6, 2007 and January 7, 2007. It is. As a result, the number of arrangements to Company B on these two days is “0”.

If parts are ordered from the ordering party in accordance with the arrangement instruction plan 6 created as described above, the parts can be ordered so that a predetermined distribution rate is obtained.
By the way, generally, when ordering parts, the minimum unit quantity that can be ordered by one order is determined. This is because it is more efficient to manufacture parts in batches. Accordingly, assuming that there is a limit on the number of delivery lot units as delivery conditions, the details of the present embodiment will be described below.

  FIG. 2 is a diagram illustrating a system configuration example of the present embodiment. An operator terminal 21 is connected to the parts arrangement management server 100. The operator terminal 21 is a computer operated by an operator in charge of parts procurement of a manufacturer who procures parts and manufactures products. Further, the parts arrangement management server 100 is connected to the vendor terminals 31, 32,. Vendor terminals 31, 32,... Are computers installed in manufacturers that deliver multi-vendor parts.

  The parts arrangement management server 100 determines the number of parts to be procured from each vendor (arrangement number) in accordance with the parts procurement conditions input from the operator terminal 21 and supplies the parts to the vendor terminals 31, 32,. Send order information. For example, the parts arrangement management server 100 transmits part order information by e-mail to each vendor when an arrangement instruction date is reached. Then, each vendor obtains an electronic mail using the vendor terminals 31, 32,... And recognizes the order contents.

  FIG. 3 is a diagram illustrating a hardware configuration example of a parts arrangement management server used in the present embodiment. The parts arrangement management server 100 is entirely controlled by a CPU (Central Processing Unit) 101. A random access memory (RAM) 102, a hard disk drive (HDD) 103, a graphic processing device 104, an input interface 105, and a communication interface 106 are connected to the CPU 101 via a bus 107.

  The RAM 102 is used as a main storage device of the parts arrangement management server 100. The RAM 102 temporarily stores at least part of an OS (Operating System) program and application programs to be executed by the CPU 101. The RAM 102 stores various data necessary for processing by the CPU 101. The HDD 103 is used as a secondary storage device of the parts arrangement management server 100. The HDD 103 stores an OS program, application programs, and various data. Note that a semiconductor storage device such as a flash memory can also be used as the secondary storage device.

  A monitor 11 is connected to the graphic processing device 104. The graphic processing device 104 displays an image on the screen of the monitor 11 in accordance with a command from the CPU 101. Examples of the monitor 11 include a display device using a CRT (Cathode Ray Tube) and a liquid crystal display device.

  A keyboard 12 and a mouse 13 are connected to the input interface 105. The input interface 105 transmits a signal transmitted from the keyboard 12 or the mouse 13 to the CPU 101 via the bus 107. The mouse 13 is an example of a pointing device, and other pointing devices can also be used. Examples of other pointing devices include a touch panel, a tablet, a touch pad, and a trackball.

  The communication interface 106 is connected to the network 10. The communication interface 106 transmits / receives data to / from another computer via the network 10.

  With the hardware configuration as described above, the processing functions of the present embodiment can be realized. 3 shows the hardware configuration of the parts arrangement management server 100, the operator terminal 21 and the vendor terminals 31, 32,... Can also be realized with the same hardware configuration.

  FIG. 4 is a block diagram showing functions of the parts arrangement management server. The parts arrangement management server 100 includes a parts arrangement condition setting unit 110, a delivery condition storage unit 120, an inventory balance value storage unit 130, a multi-vendor arrangement number determination unit 140, an arrangement instruction plan storage unit 150, and an arrangement instruction unit 160. ing.

  In response to an input from the operator terminal 21, the parts arrangement condition setting unit 110 sets information necessary for parts arrangement in the delivery condition storage unit 120 and the inventory balance value storage unit 130. Specifically, the part arrangement condition setting unit 110 stores the delivery conditions of each vendor in the delivery condition setting table in the delivery condition storage unit 120 for each vendor (vendor) of the multi-vendor part. Delivery conditions include arrangement cycle and lead time. In addition, the parts arrangement condition setting unit 110 sets the required number of each part for each day in the inventory balance evaluation table 131.

  The delivery condition storage unit 120 is a storage function that stores a delivery condition setting table in which delivery conditions for each vendor are registered. For example, a part of the storage area of the HDD 103 is used as the delivery condition storage unit 120.

  The inventory balance value storage unit 130 is a storage function that stores an inventory balance evaluation table in which the required number of parts for each day and the inventory balance are registered. For example, a part of the storage area of the HDD 103 is used as the inventory balance value storage unit 130.

  The multi-vendor arrangement number determination unit 140 refers to the delivery condition storage unit 120 and the inventory balance value storage unit 130, and determines the date when parts are arranged for each vendor and the number of parts arranged on that day. Then, the multi-vendor arrangement number determination unit 140 stores the determined arrangement number in the arrangement instruction plan storage unit 150. 1 is included in the multi-vendor arrangement number determination unit 140.

  The arrangement instruction plan storage unit 150 is a storage function for storing an arrangement instruction plan table in which the arrangement date and the number of arrangements for each vendor are registered. For example, a part of the storage area of the HDD 103 is used as the arrangement instruction plan storage unit 150.

  The arrangement instruction unit 160 refers to the arrangement instruction plan storage unit 150 and transmits part order information to the vendor terminals 31, 32,. Specifically, the arrangement instruction unit 160 extracts an arrangement instruction plan in which the current day in the arrangement instruction plan storage unit 150 is an arrangement designation date at a predetermined time every day. Then, the arrangement instruction unit 160 transmits information for ordering the parts indicated in the extracted instruction plan to the corresponding vendor.

  Next, the contents of each storage unit shown in FIG. 4 will be specifically described. In the following example, it is assumed that the current date is January 1, 2007. Further, in order to make it easy to distinguish between the already determined order instruction plan and the newly determined order instruction plan, only the past order instruction plan (until December 31, 2006) is determined.

  FIG. 5 is a diagram illustrating a data structure example of the delivery condition storage unit. The delivery condition storage unit 120 stores a delivery condition setting table 121. The delivery condition setting table 121 includes columns for a figure, an ordering party, an arrangement cycle, a lead time, a deliverable number per order, a delivered lot unit number, and a distribution rate. Information arranged in the horizontal direction in the table is associated with each other to form one record indicating delivery conditions.

  The identifier of the multi-vendor part (illustration) is set in the illustration column. Even if parts of the same specification are supplied from different vendors, they have different identifiers. The illustrations “CP-2” and “CP-3” are parts having the same specifications.

The name of the vendor that is the supplier of the parts shown in the corresponding figure is set in the supplier column.
In the column for the arrangement cycle, a cycle (arrangement cycle) in which the parts of the corresponding illustration can be ordered from the supplier is set on a daily basis. For example, if an order can be placed only once a week, “7” is set in the arrangement cycle. If an order can be made every day, “1” is set in the arrangement cycle.

  In the lead time column, a period (lead time) from when a part of the corresponding illustration is ordered until it is delivered is set in units of days. For example, if the order is delivered three days after the order is placed, “3” is set as the lead time.

  In the column for the number of deliverables per order, the maximum number of deliverable parts of the corresponding illustration per order (number of deliverables per order) is set. That is, when placing an order for the corresponding illustration, it is necessary to place an order with a number equal to or less than the number of deliverables per order.

  In the delivery lot unit number field, a unit quantity (delivery lot unit number) when delivering the corresponding part of the illustration is set. In other words, when placing an order for the corresponding illustration, it is necessary to place an order in a number that is a multiple of the number of delivered lot units.

In the distribution ratio column, the ratio (distribution ratio) of the parts shown in the illustration to the total order quantity within the predetermined period of the parts having the same specifications as the corresponding illustration is set as a percentage.
Such delivery conditions for each illustration are determined in advance based on negotiations with each vendor. Then, when the operator inputs the determined content to the operator terminal 21, the input delivery conditions are sent from the operator terminal 21 to the parts arrangement management server 100. Then, the part arrangement condition setting unit 110 of the part arrangement management server 100 registers the delivery condition as a new record in the delivery condition setting table 121.

  FIG. 6 is a diagram illustrating a data structure example of the inventory balance value storage unit. The inventory balance value storage unit 130 stores an inventory balance evaluation table 131. The inventory balance evaluation table 131 includes columns for date, required number, CP-2 scheduled delivery number, CP-3 scheduled delivery number, cumulative required number, cumulative scheduled delivery number, and inventory balance value.

In the date column, a date for evaluating the inventory balance is set. As the date, at least the business day of the orderer is set.
In the required number column, the number of parts required for the day indicated by the date is set.

Based on the number of orders set in the order instruction plan table 151, the scheduled number of parts delivered for the “CP-2” part of the figure “CP-2” is set in the CP-2 scheduled delivery number field.
Based on the number of orders set in the order instruction plan table 151, the scheduled number of parts delivered for the “CP-3” part of the figure “CP-3” is set in the CP-3 scheduled delivery number field.

  In the total required number column, the figure “CP-2” required from the date when the required number starts to be counted (January 1, 2007 in the example of FIG. 6) to the date indicated in the date column. , “CP-3” total number of parts (cumulative required number) is set.

  In the column of the scheduled delivery number, the illustration “CP-” which is scheduled to be delivered from the date when the required number is started (January 1, 2007 in the example of FIG. 6) to the date indicated in the date column. 2 ”,“ CP-3 ”total number of parts (cumulative delivery schedule number) is set.

  In the column of inventory balance value, the total number of parts (stock balance value) of the illustrations “CP-2” and “CP-3” remaining as inventory at the end of the corresponding date is set. The inventory balance value is obtained by the difference between the cumulative delivery scheduled number and the cumulative required number.

  Of the information in the inventory balance evaluation table 131, the value input by the operator to the operator terminal 21 is set for the required number. That is, when the operator designates a date on the operator terminal 21 and inputs a required number of values, the input delivery conditions are sent from the operator terminal 21 to the parts arrangement management server 100. Then, the parts arrangement condition setting unit 110 of the parts arrangement management server 100 registers the acquired value in the required number column corresponding to the specified date in the inventory balance evaluation table 131. As other information in the inventory balance evaluation table 131, results calculated by the multi-vendor arrangement number determination unit 140 are appropriately registered.

  FIG. 7 is a diagram illustrating an example of the data structure of the arrangement instruction plan storage unit. The order instruction plan table 151 stores an order instruction plan table 151. The order instruction plan table 151 has columns of an instruction number, a drawing, an order date, and the number of orders. Information arranged in the horizontal direction in the table is associated with each other to form one record indicating an arrangement instruction.

  An identification number for each arrangement instruction is set in the instruction number column. In the illustration column, illustrations of parts to be ordered in the arrangement instruction are set. In the arrangement instruction date column, a date for placing an order according to the arrangement instruction is set. In the order quantity column, the quantity of parts to be ordered by the order instruction is set.

Next, the internal configuration of the multi-vendor arrangement number determination unit 140 will be described in detail.
FIG. 8 is a block diagram showing an internal configuration of the multi-vendor arrangement number determination unit. The multi-vendor arrangement number determination unit 140 includes a priority order determination unit 141, a priority order storage unit 142, a plan period determination unit 143, a plan period storage unit 144, a total planned arrangement number determination unit 145, a provisional total arrangement number storage unit 146, a plan An in-period arrangement number storage unit 147, an arrangement number determination unit 148, and a temporary arrangement instruction plan storage unit 149 are provided.

  The priority order determination part 141 determines the priority order for making it an arrangement destination about several components of the same specification. As for the priority order, priority is given to the parts of the figure that cannot be finely adjusted. Specifically, the priority order determination unit 141 increases the priority order of the corresponding illustrations as the total value of the arrangement cycle and the lead time of each illustration shown in the delivery condition setting table 121 increases. The priority order determination unit 141 stores the determined priority order in the priority order storage unit 142.

  The priority order storage unit 142 is a storage function that stores a priority order table in which priorities between a plurality of parts having the same specification are set. For example, a part of the storage area of the RAM 102 is used as the priority order storage unit 142.

  The planning period determining unit 143 determines a period (planning period) for planning the number of orders. Specifically, the planning period determination unit 143 refers to the priority order storage unit 142 and determines the plate with the highest priority order. Then, the planning period determination unit 143 refers to the delivery condition setting table 121 in the delivery condition storage unit 120, and sets the period obtained by summing up the arrangement cycle and lead time of the plate with the highest priority as the planning period. The plan period determining unit 143 stores the determined plan period in the plan period storage unit 144.

The plan period storage unit 144 is a storage function that stores information indicating the plan period. For example, a part of the storage area of the RAM 102 is used as the planned period storage unit 144.
The total planned planned number determination unit 145 determines the total quantity (total planned planned number) to be ordered within the planning period for each illustration. Specifically, the total planned planned number determination unit 145 refers to the delivery condition setting table 121 in the delivery condition storage unit 120 and acquires the distribution ratio of each of a plurality of parts having the same specification. Next, the total planned planned number determination unit 145 refers to the inventory balance evaluation table 131 in the inventory balance evaluation table 131 and the plan period in the plan period storage unit 144 to determine the cumulative required number in the plan period. Furthermore, the total planned planned number determination unit 145 distributes the cumulative required number within the planning period to each of the plates according to the distribution ratio, and temporarily determines the total planned planned number of the corresponding plates. The total planned planned number determining unit 145 stores the temporarily determined total planned planned number in the temporary total ordered number storage unit 146. Next, the total planned planned number determination unit 145 refers to the delivery condition setting table 121 in the delivery condition storage unit 120, and determines the deliverable number of the ordering party within the planning period for each plate. Then, the total planned planned number determining unit 145 determines a maximum value less than or equal to the temporarily determined total planned planned number as the total planned planned number within a range not exceeding the deliverable number. The total planned planned number determining unit 145 stores the determined total planned planned number in the planned number arranged number storage unit 147.

  The provisional total arrangement number storage unit 146 is a storage function for storing a provisional total arrangement number table in which the provisionally determined total arrangement planned number is registered. For example, a part of the storage area of the RAM 102 is used as the temporary total arrangement number storage unit 146.

  The planned order quantity storage unit 147 is a storage function for storing a planned period order quantity table in which the officially determined total order quantity is registered. For example, a part of the storage area of the RAM 102 is used as the planned number arrangement number storage unit 147.

  The arrangement number determination unit 148 determines the number of arrangements for each illustration per day within the planning period. Specifically, the arrangement number determining unit 148 refers to the priority order table in the priority order storage unit 142 and determines the priority order of each illustration. Next, the number-of-arrangements determination unit 148 refers to the confirmed number of orders stored in the order instruction plan storage unit 150, and in order from the highest priority order, within the range of the total number of planned orders for each figure, The number of provisional arrangements for each arrangement instruction date is determined by the shortage on the delivery date. Further, the arrangement number determination unit 148 refers to the inventory balance evaluation table 131 in the inventory balance value storage unit 130, judges the daily inventory status, adjusts the provisional arrangement number so that the inventory does not become excessive, and adjusts the adjustment. The later value is confirmed as the number of orders. The arrangement number determination unit 148 stores the determined arrangement number in the arrangement instruction plan table 151 in the arrangement instruction plan storage unit 150.

Next, details of the data table held internally by the multi-vendor arrangement number determination unit 140 will be described.
FIG. 9 is a diagram illustrating an example of a data structure of the priority order storage unit. The priority order storage unit 142 stores a priority order table 142a. The priority table 142a has columns for illustrations and priority. In the illustration, the illustration for which the number of arrangements is determined is set. The priority order of the corresponding illustration is set in the priority order column. The priority indicates that the smaller the value is, the higher the priority is.

  FIG. 10 is a diagram illustrating an example of a data structure of the provisional total arrangement number storage unit. The temporary total arrangement number storage unit 146 stores a temporary total arrangement number table 146a. The provisional total arrangement number table 146a is provided with a column for a figure and a provisional total arrangement number.

In the illustration column, the illustration for which the number of arrangements is determined is set. The provisional total number of orders provisionally determined for the corresponding illustration is set in the provisional total number of orders column.
FIG. 11 is a diagram illustrating an example of a data structure of the planned number of arrangements within the planned period. The planned number of orders arranged in the planned period 147 stores a planned number of orders arranged in the planned period 147a. In the planned number of arrangements table 147a, columns of illustrations, distribution numbers, possible arrangement numbers, and total planned arrangement numbers are provided. In the illustration column, the illustration for which the number of arrangements is determined is set. In the column for the number of distributions, of the cumulative required number of parts having the same specifications as the corresponding illustration within the planning period, the quantity assigned to the illustration part is set. The maximum number that can be delivered for an order during the planning period is set in the column for the quantity that can be arranged. In the column of the total number of planned arrangements, the quantity scheduled to be ordered within the planning period for the corresponding parts of the illustration is set.

  FIG. 12 is a diagram illustrating a data structure example of the provisional order instruction plan storage unit. The temporary order instruction plan storage unit 149 stores a temporary order instruction plan table 149a. The provisional order instruction plan table 149a has columns of instruction number, illustration, order instruction date, and number of provisional orders. The information arranged in the horizontal direction in the provisional order instruction plan table 149a is associated with each other to form one record indicating the provisional order instruction.

  The identification number of the provisional arrangement instruction is set in the instruction number column. In the illustration column, the illustration of the part to be ordered in the provisional arrangement instruction is set. In the order instruction date column, a date on which a provisional order instruction is scheduled is set. The provisionally determined number of arrangements is set in the provisional arrangement number column.

Next, the processing of the multi-vendor arrangement number determination unit will be described in detail.
FIG. 13 is the first half of the flowchart showing the procedure of the multi-vendor arrangement number determination process. In the following, the process illustrated in FIG. 13 will be described in order of step number. The following processing is started when an operator inputs an arrangement number determination instruction via the operator terminal 21. In the present embodiment, it is assumed that the operator inputs an operation for determining the number of arrangements at the start of morning work.

  [Step S <b> 11] The priority order determination unit 141 reads delivery conditions from the delivery condition setting table 121. Specifically, the priority determining unit 141 refers to the delivery condition setting table 121 and reads the values of the arrangement cycle and the lead time of each plate.

  [Step S12] The priority order determination unit 141 determines the priority order for each picture. Specifically, the priority order determination unit 141 calculates the total number of days of “arrangement cycle” + “lead time” for each plate. Next, the priority order determination unit 141 sorts the illustrations in descending order by the total number of days of the illustrations. Then, the priority order determination unit 141 assigns numerical values indicating the priority order in order from the top of the sorted plates, and sets them in the priority order table 142a.

[Step S13] The planning period determining unit 143 extracts a plate with the highest priority in the priority table 142a.
[Step S14] The planning period determining unit 143 determines a planning period in which the arrangement instruction plan is to be executed. Specifically, the plan period determining unit 143 refers to the delivery condition setting table 121 and extracts the arrangement cycle and lead time of the plate with the highest priority. Next, the planning period determination unit 143 calculates the total number of days of “arrangement cycle” + “lead time” based on the extracted value. Then, the period of the day after the total number of days calculated from the current date (including the current day) is set as the plan period. If the arrangement instruction plan is executed on January 1, 2007 and the total number of arrangement cycles and lead times is 10 days, the period from January 1, 2007 to January 10, 2007 is the plan period. Become. The plan period determining unit 143 stores the determined plan period in the plan period storage unit 144.

  [Step S15] The total planned planned number determination unit 145 calculates the total required number within the planned period. Specifically, the total planned planned number determining unit 145 refers to the inventory balance evaluation table 131 and extracts the required number set for each date within the planned period. Next, the total planned number-of-arrangements determination unit 145 sums the required numbers from the planning period start date to each date in the planning period to obtain the cumulative required number for each date. The total planned planned number determination unit 145 registers the calculated cumulative required number in association with each date of the planned period in the inventory balance evaluation table 131. The total planned planned number determination unit 145 recognizes the cumulative required number on the last day of the planning period as the total required number in the planning period. For example, in the inventory balance evaluation table 131 shown in FIG. 6, the daily required number is “20”. Then, if the planning period is 10 days, the total required number is “200”.

[Step S16] The total planned planned number determining unit 145 calculates the possible number of planned arrangements for each figure within the planned period. Specifically, the total planned planned number determination unit 145 obtains “arrangement cycle” and “number of deliverables per order” for each drawing from the delivery condition setting table 121. Next, the total planned planned number determining unit 145 obtains a quotient (integer part) of division of (planned period days / arrangement cycle) for each figure by the following calculation formula. Then, the total planned planned number determination unit 145 multiplies the calculated quotient by the number of deliverables per order, and obtains the number that can be arranged within the planned period. These calculations are expressed as follows.
Number of items that can be arranged in the planning period =
{(Quotient of (planned period days / arrangement cycle))} x (number of deliverables per order)
The total planned planned number determination unit 145 stores the number of possible arrangements within the planned period calculated for each illustration in the planned number of arrangements table 147a in association with the illustration. For example, according to the delivery condition setting table 121 shown in FIG. 5, the arrangement cycle of the illustration “CP-2” is 7 days. If the plan period is 10 days from January 1, 2007 to January 10, 2007, the quotient (integer part) of (plan period days / arrangement cycle) is “1”. Further, according to the delivery condition setting table 121 shown in FIG. 5, the “number of deliverables per order” of the illustration “CP-2” is “30”. Accordingly, the possible number of illustrations “CP-2” that can be arranged within the planned period is “30 (1 × 30)”. Similarly, the possible number of illustrations “CP-3” within the planned period is “200 (10 × 20)”.

  [Step S17] The total planned number determination unit 145 determines the number of distributions. Specifically, the total planned planned number determination unit 145 extracts the “distribution rate” for each drawing from the delivery condition setting table 121. Next, the total arrangement planned number determination unit 145 multiplies the total required number of each illustration by the distribution rate. The result of multiplication for each picture is the number of distributions for each picture. The total planned planned number determination unit 145 stores the number of distributions for each figure in the planned number of arranged orders table 147a in association with the figure.

  [Step S18] The total planned number-of-arrangements determination unit 145 selects one of the plates registered in the delivery condition setting table 121 that has not been processed in steps S19 to S22.

  [Step S19] The total planned planned number determination unit 145 confirms whether the distribution number is divisible by the number of delivered lot units for the selected illustration. In other words, it is confirmed whether or not the distribution number is a multiple of the delivery lot unit number. Specifically, the total planned planned number determination unit 145 extracts the “delivery lot unit number” of the selected plate from the delivery condition setting table 121. Next, the total planned planned number determination unit 145 determines whether the “distribution number” of the selected illustration is divisible by the “delivery lot unit number” of the illustration.

  [Step S20] The total planned planned number determining unit 145 proceeds to step S21 if the result of the determination in step S19 is divisible, and proceeds to step S22 if not possible.

  [Step S21] When the distribution number is divisible by the number of delivery lot units, the total arrangement planned number determination unit 145 sets the distribution number of the selected illustration as the provisional total arrangement number of the illustration. Then, the total planned planned number determining unit 145 registers the temporary total ordered number in the temporary total ordered number table 146a in association with the illustration. Thereafter, the process proceeds to step S23.

  [Step S22] If the distribution number is not divisible by the number of delivered lot units, the total planned planned number determining unit 145 sets the value corrected to a multiple of the delivered lot unit number as the provisional total ordered number. In other words, the total planned planned number determination unit 145 sets the minimum value that is a multiple of the number of delivered lot units and larger than the distribution number as the provisional total ordered number. Specifically, the total planned planned number determination unit 145 adds 1 to the quotient (integer part) of the result obtained by dividing the “distribution number” of the selected illustration by the “delivery lot unit number” to obtain the delivery lot unit number. The result of multiplication is the provisional total number of orders for the illustration. Then, the total planned arrangement number determination unit 145 registers the temporary total arrangement number in the temporary total arrangement number table 146a in association with the illustration.

  [Step S23] The total planned planned number determination unit 145 determines whether or not there is a plate that has not undergone the processing of steps S19 to S22. If there is an unprocessed plate, the process proceeds to step S18. When the calculation of the provisional total number of arrangements for all the plates is completed, the process proceeds to step S31 (see FIG. 14).

FIG. 14 is the second half of the flowchart showing the procedure of the multi-vendor arrangement number determination process. In the following, the process illustrated in FIG. 14 will be described in order of step number.
[Step S31] The total planned planned number determination unit 145 selects one of the plates that have not been processed in steps S32 to S35 from the plates registered in the delivery condition setting table 121.

  [Step S32] The total planned planned number determining unit 145 compares the provisional total ordered number of the selected illustration with the deliverable number. Specifically, the total planned planned number determination unit 145 refers to the planned number of scheduled orders table 147a, and acquires the number of possible orders for the selected illustration. Also, the total planned planned number determining unit 145 refers to the temporary total ordered number table 146a and acquires the temporary total ordered number of the selected illustration. Then, the total planned planned number determination unit 145 compares the numerical values of the acquired orderable number and the provisional total number of orders.

  [Step S33] If the result of the comparison indicates that the provisional total number of arrangements is less than or equal to the orderable number, the total arrangement planned number determination unit 145 advances the process to step S34. If the provisional total number of arrangements is larger than the orderable number, the total arrangement planned number determination unit 145 proceeds to step S35.

  [Step S34] When the provisional total number of arrangements is equal to or less than the orderable arrangement number, the total arrangement quantity determination unit 145 sets the provisional total arrangement number as the total arrangement number. Then, the total planned planned number determination unit 145 registers the total planned planned number of the selected illustrations in the planned number of scheduled orders table 147a. Thereafter, the process proceeds to step S36.

  [Step S35] When the provisional total number of arrangements is larger than the orderable number, the total number of planned arrangements determining unit 145 sets the orderable number as the total number of planned arrangements. Then, the total planned planned number determination unit 145 registers the total planned planned number of the selected illustrations in the planned number of scheduled orders table 147a.

  [Step S36] The total planned planned number determination unit 145 determines whether or not there is a plate that has not been processed in steps S32 to S35. If there is an unprocessed plate, the process proceeds to step S31. If the total number of planned arrangements has been determined for all the plates, the process proceeds to step S37.

[Step S37] The arrangement number determination unit 148 refers to the priority order table 142a, and selects, in order from the top of the priority order, one illustration that has not been processed for the arrangement number determination process.
[Step S38] The number-of-arrangements determination unit 148 refers to the plan period storage unit 144, and selects a date for one day within a plan period for which the number-of-arrangements determination process has not been processed for the selected illustration.

[Step S39] The arrangement number determination unit 148 performs an arrangement number determination process for the selected date on the selected date. Details of this processing will be described later (see FIGS. 15 and 16).
[Step S40] The number-of-arrangements determination unit 148 determines whether there is a date for which the number-of-arrangements determination process has not been processed for the selected illustration. If there is an unprocessed date, the process proceeds to step S38. If the arrangement number determination process has been completed for all dates within the planned period for the selected illustration, the process proceeds to step S41.

  [Step S41] The arrangement number determination unit 148 determines whether there is a plate for which the arrangement number determination process has not been processed. If there is an unprocessed plate, the process proceeds to step S37. If there is no unprocessed picture, the process ends.

Next, details of the arrangement number determination process will be described.
FIG. 15 is the first half of a flowchart showing the procedure of the arrangement number determination process. In the following, the process illustrated in FIG. 15 will be described in order of step number. The arrangement number determination process is executed by using the illustration selected in step S37 and the date selected in step S38 as arguments (values passed when the process is called).

  [Step S51] The arrangement number determination unit 148 confirms the next arrangement cycle of the confirmed arrangement instruction. Specifically, the arrangement number determination unit 148 extracts the latest arrangement instruction date (date is the latest) corresponding to the selected plate from the arrangement instruction plan table 151. For example, in the arrangement instruction plan table 151 shown in FIG. 7, the latest arrangement instruction date of the illustration “CP-2” is December 29, 2006. In addition, the arrangement number determination unit 148 acquires an arrangement cycle corresponding to the selected illustration from the delivery condition setting table 121. For example, in the delivery condition setting table 121 shown in FIG. 5, the arrangement cycle of the illustration “CP-2” is 7 days. Further, the arrangement number determination unit 148 obtains the date after the arrangement cycle of the selected plate from the most recent arrangement instruction date of the selected plate. That is, the date corresponding to the latest “arrangement instruction date” + “arrangement cycle” is obtained. This date corresponds to the next arrangement instruction date for the selected illustration. Then, the arrangement number determination unit 148 compares the selected date with the next arrangement instruction date.

  [Step S52] The arrangement number determination unit 148 determines whether or not the next arrangement instruction date is equal to the selected date. If equal, the process proceeds to step S53. If they are not equal, the selected date is not the next arrangement instruction date. That is, since it is not possible to make an arrangement instruction for the selected illustration on the selected date, the arrangement number determination process for the selected date of the selected illustration ends.

  [Step S53] The arranged number determination unit 148 calculates the arranged number. Specifically, the arrangement number determination unit 148 refers to the arrangement instruction plan table 151, extracts records within the planning period corresponding to the selected illustration, and calculates the total number of arrangements.

  [Step S54] The arrangement number determination unit 148 compares the calculated arrangement number with the total arrangement number. Specifically, the number-of-arrangements determination unit 148 refers to the number-of-arrangements-arranged-number table 147a and acquires the total number of planned arrangements corresponding to the selected illustration. Next, the arranged number determination unit 148 subtracts the arranged number from the acquired total arranged planned number. That is, “total planned number of arrangements” − “arranged number of arrangements” (shortage number) is calculated.

  [Step S55] The number-of-arrangements determination unit 148 determines whether the number of arrangements has reached the total planned number of arrangements as a result of the comparison in step S54. That is, if the result of the subtraction in step S54 is a positive value, it is determined that the arranged number is less than the total planned number (there is a shortage). If there is a shortage, the process proceeds to step S57. If there is no shortage, the process proceeds to step S56.

  If the currently selected illustration has the lowest priority among the illustrations that can be delivered on the delivery date when the selected illustration is arranged on the date of selection, the following points are determined in step S55. It is necessary to judge additionally.

  If the arranged number has reached the total planned number, the arranged number determination unit 148 determines whether or not the cumulative required number on the delivery date is satisfied by the delivery of the other illustrations. That is, it is determined whether or not the inventory balance value in the inventory balance evaluation table 131 is 0 or more even if the number of temporary arrangements of the selected illustration is 0. When the stock balance value becomes less than 0 (negative number), the arrangement number determination unit 148 sets the absolute value of the stock balance value as the shortage number and advances the process to step S57.

  [Step S56] If the arranged number has already reached the total planned number, the arranged number determining unit 148 sets the number of provisional arrangements on the selected date of the selected illustration to “0”. Thereafter, the process proceeds to step S61 (see FIG. 16).

  [Step S57] When the arranged number is less than the total planned number, the arranged number determining unit 148 determines whether or not the shortage number is equal to or greater than the deliverable number per order. Specifically, the arrangement number determination unit 148 refers to the delivery condition setting table 121 and acquires the deliverable number per order of the selected drawing. Next, the arrangement number determination unit 148 subtracts the calculation result in step S54 from the acquired deliverable number per order. If the subtraction result is a value of 0 or more, it is determined that there is a shortage of more than the deliverable number per order. If there is a shortage of deliverable number per order, the process proceeds to step S58. If the shortage is less than the deliverable number per order, the process proceeds to step S59.

  [Step S58] The order quantity determination unit 148 determines the number of deliverables per order as the provisional order quantity on the selected date of the selected illustration. The arrangement number determination unit 148 stores the determined number of provisional arrangements in the provisional arrangement instruction plan table 149a in association with the selected illustration and the selected date. Thereafter, the process proceeds to step S61 (see FIG. 16).

  [Step S59] The arrangement number determination unit 148 determines the shortage number as the provisional arrangement number on the selected date of the selected illustration. Specifically, the arrangement number determination unit 148 sets the provisional arrangement number as a result of subtracting the arranged number from the total planned arrangement number. The arrangement number determination unit 148 stores the determined number of provisional arrangements in the provisional arrangement instruction plan table 149a in association with the selected illustration and the selected date.

  Of the illustrations that can be delivered on the delivery date when making arrangements on the selected date, the currently selected edition has the lowest priority (can be delivered on the delivery date) If there are no other unprocessed plates), the following points need to be additionally determined in step S59.

  The arrangement number determination unit 148 determines whether or not the cumulative required number of delivery dates is satisfied by the insufficient number of deliveries. That is, it is determined whether or not the stock balance value in the stock balance evaluation table 131 is 0 or more when the shortage number is the provisional order number of the selected plate. When the inventory balance value becomes less than 0 (a negative number), the arrangement number determination unit 148 adds the absolute value of the inventory balance value to the provisional arrangement number.

  For example, consider a case where the figure “CP-3” is selected and the date “January 10, 2007” is selected. In this case, as shown in FIG. 18 to be described later, the number of arranged “CP-3” from January 1, 2007 to January 9, 2007 is “150”. Here, since the total planned number of illustrations “CP-3” is “160” (see FIG. 11), the number of provisional arrangements is “10” (160-150) in the normal process of step S59. Here, the delivery date when the illustration “CP-3” is arranged on “January 10, 2007” is “January 12, 2007”. As can be seen by referring to the inventory balance evaluation table 131 (showing the state after the multi-vendor arrangement number determination process) shown in FIG. 17 described later, the part of the illustration “CP-3” is displayed on “January 12, 2007”. If only “10” is delivered, the value of “cumulative delivery”-“total required number” (inventory balance value) will be negative (−10). End up). Therefore, the value “20” obtained by adding the absolute value “10” of the inventory balance value is set as the provisional order number. As a result, the occurrence of a shortage is prevented. If the number of provisional orders after correction exceeds the number of deliverables per order of the corresponding illustration, the arrangement number determination unit 148 displays an error message on the operator terminal 21.

Thereafter, the process proceeds to step S61 (see FIG. 16).
FIG. 16 is the second half of the flowchart showing the procedure of the arrangement number determination process. In the following, the process illustrated in FIG. 16 will be described in order of step number.

  [Step S61] The arrangement number determination unit 148 calculates a delivery date. Specifically, the arrangement number determination unit 148 refers to the delivery condition setting table 121 and obtains the lead time corresponding to the selected illustration. Next, the arrangement number determination unit 148 adds the acquired lead time to the selected date. The result of the addition is the delivery date.

  [Step S62] The arrangement number determination unit 148 confirms the inventory balance. Specifically, the arrangement number determination unit 148 refers to the inventory balance evaluation table 131, and determines in one of steps S56, S58, and S59 in the column of the scheduled number of deliveries for the selected illustration with the date corresponding to the delivery date. Register the number of provisional orders. Next, the arrangement number determination unit 148 calculates the cumulative required number of delivery dates and registers it in the inventory balance evaluation table 131. The cumulative required number is the total value of the planned delivery number of each illustration from the start date of the planning period to the delivery date (including the delivery date). Furthermore, the arrangement number determination unit 148 calculates an inventory balance value. Specifically, the arrangement number determining unit 148 subtracts the cumulative required number of delivery dates from the cumulative delivery number of delivery dates. The subtraction result is the inventory balance value. The arrangement number determination unit 148 registers the calculated inventory balance value in association with the delivery date of the inventory balance evaluation table 131.

  [Step S63] The arrangement number determination unit 148 determines whether or not the inventory balance value is greater than zero. If the stock balance value is larger than 0, it means that extra stock is generated when an order is instructed according to the provisional order. If the inventory balance value is greater than 0, the process proceeds to step S65. If the inventory balance value is 0 or less, the process proceeds to step S64.

  [Step S64] If the inventory balance value is 0 or less, the arrangement number determination unit 148 determines the provisional arrangement number as the arrangement number. Then, the arrangement number determination unit 148 sets the selected date as the arrangement instruction date, associates the selected instruction with the arrangement instruction date and the number of arrangements, and creates a new record indicating the arrangement instruction in the arrangement instruction plan table 151. Register additional. Thereafter, the process proceeds to step S69.

  [Step S65] When the inventory balance value is greater than 0, the arrangement number determination unit 148 determines whether or not the scheduled delivery number is greater than the inventory balance value. The case where the scheduled delivery number is larger than the inventory balance value is a case where the inventory balance value is larger than 0 because the number of provisional arrangements on the selected date of the selected illustration is too large. If the scheduled delivery number is greater than the inventory balance value, the process proceeds to step S68. If the scheduled delivery number is less than or equal to the inventory balance value, the process proceeds to step S66.

  [Step S66] When the planned delivery quantity is equal to or less than the inventory balance value, the arrangement quantity determination unit 148 determines the arrangement quantity to be “0”. Then, the arrangement number determination unit 148 uses the selected date as the arrangement instruction date, associates the arrangement instruction date and the arrangement number with the selected illustration, and creates a new record indicating the arrangement instruction in the arrangement instruction plan table 151. Register additional.

  [Step S <b> 67] The arrangement number determination unit 148 stores the number of deliveries in the inventory balance evaluation table 131. Specifically, the arrangement number determination unit 148 registers “0” in the scheduled number of deliveries of the selected plate related to the date record corresponding to the delivery date calculated in step S61. At this time, the arrangement number determination unit 148 updates the cumulative number of scheduled deliveries and the inventory balance value of the corresponding record. Thereafter, the arrangement number determination process for the selected date of the selected illustration is completed.

[Step S68] When the planned delivery quantity is larger than the inventory balance value, the arrangement quantity determination unit 148 sets the arrangement quantity to be the shortage of the accumulated required quantity that occurs when the selected illustration is not delivered. Specifically, the arrangement number determination unit 148 refers to the delivery condition setting table 121 and acquires the delivery lot unit number of the selected illustration. Next, the arrangement number determination unit 148 subtracts the inventory balance value from the provisional arrangement number. Further, the arrangement number determining unit 148 divides the subtraction result by the number of delivered lot units to obtain a quotient (integer part). Next, the arrangement number determination unit 148 multiplies the division quotient by the delivery lot unit number. The result of multiplication is the number of arrangements. This calculation is expressed as follows.
Number of arrangements =
[[Quotient of [(temporary order quantity-inventory balance value) / delivery lot unit number]] × delivery lot unit number Here, the stock balance value is obtained when the provisional order quantity is arranged as described in step S62. As a result, the cumulative required number of delivery dates is subtracted from the scheduled delivery date. When the inventory balance value is positive, it indicates that if the number of provisional arrangements is made, the inventory to be carried over the next day is generated by the amount of the inventory balance value. Therefore, if the inventory balance value is subtracted from the number of temporary arrangements, the shortage of the cumulative required number that occurs when the selected illustration is not delivered (appropriate value for reducing the inventory to 0).

  In the calculation formula for the number of arrangements, the number of arrangements is set to be a multiple of the number of delivered lot units. Therefore, even if the determined number of parts are delivered on the delivery date, the cumulative delivery schedule may not reach the cumulative required quantity. In this case, the shortage is compensated for by the parts of the plate having a lower priority than the currently selected plate. However, if there is no illustration with a low priority order to deliver on the delivery date when the shortage occurs, the order quantity determination unit 148 will add a value one lot more than the formula for calculating the order quantity (the number of delivery lot units). The added value) can be the number of arrangements. As a result, the cumulative number of daily deliveries is always greater than or equal to the cumulative required number of the day.

  The arrangement number determination unit 148 additionally registers a new record indicating the arrangement instruction in the arrangement instruction plan table 151 by using the selected date as the arrangement instruction date and associating the selected instruction with the arrangement instruction date and the number of arrangements. To do.

  [Step S <b> 69] The arrangement number determination unit 148 stores the number of deliveries in the inventory balance evaluation table 131. Specifically, the arrangement number determining unit 148 registers the number of arrangements determined in step S64 or step S68 in the scheduled delivery number of the selected plate related to the record corresponding to the delivery date calculated in step S61. At this time, the arrangement number determination unit 148 updates the cumulative number of scheduled deliveries and the inventory balance value of the corresponding record. Thereafter, the arrangement number determination process for the selected date of the selected illustration is completed.

In this way, a record indicating an arrangement instruction for the planned period is added to the arrangement instruction plan table 151.
FIG. 17 is a diagram illustrating an inventory balance evaluation table after the multi-vendor arrangement number determination process is executed. Compared with the provisional order instruction plan table 149a shown in FIG. 12, records of each date corresponding to the order instructions after January 1, 2007 are added. Here, the numbers in parentheses shown in “CP-3 scheduled delivery quantity”, cumulative delivery schedule quantity, and inventory balance are values calculated on the left side based on the provisional order quantity, and the right side is determined It is a value after being updated based on the number of arrangements. For example, the provisional number of the illustration “CP-3” on January 6, 2007 is “20” (see FIG. 12). The planned CP-3 delivery number in the inventory balance evaluation table 131 on January 8, 2007, to which parts are delivered when this provisional arrangement is executed, is “20”. At this time, the cumulative number of scheduled deliveries is 190, exceeding the cumulative required number of 160, and the inventory balance value is “+30”. This indicates an overstock. Therefore, when the planned CP-3 delivery number “20” is compared with the inventory balance value “30”, the inventory balance value is larger. Therefore, the number of arrangements is adjusted to “0”. As a result, the planned delivery number of CP-3 is changed from “20” to “0”, the cumulative delivery number is changed from “190” to “170”, and the inventory balance value is changed from “30” to “10”. The

  Further, the provisional number of “CP-3” on January 7, 2007 is “20” (see FIG. 12). The planned CP-3 delivery number in the inventory balance evaluation table on January 9, 2007, when parts are delivered when this temporary arrangement is executed, is set to “20”. At this time, the cumulative number of scheduled deliveries is “190”, which exceeds the total required number of 180, and the inventory balance value is “+10”. This indicates an overstock. Therefore, when the planned CP-3 delivery number “20” is compared with the inventory balance value “30”, the inventory balance value is larger. Therefore, the number of arrangements is adjusted to “10”. As a result, the CP-3 scheduled delivery quantity is changed from “20” to “10”, the cumulative delivery schedule quantity is changed from “190” to “180”, and the inventory balance value is changed from “10” to “0”. The

  FIG. 18 is a diagram illustrating an arrangement instruction plan table after execution of the multi-vendor arrangement number determination process. The arrangement instruction plan table 151 shown in FIG. 18 shows the arrangement instruction within the corresponding period by executing the multi-vendor arrangement number determination process with the period from January 1, 2007 to January 10, 2007 as the planning period. An additional record is registered.

  Here, when the number of arrangements for each illustration during the planning period (January 1, 2007 to January 10, 2007) is summed, the illustration “CP-2” is “30” and the illustration “CP-3” is “170”. It is. Note that the total number of planned distributions in the planned number of arrangements in the planned period 147a is “30” for the illustration “CP-2” and “160” for the illustration “CP-3” (see FIG. 11). Therefore, it can be seen that orders of more than the planned number of distributions are made in any of the illustrations. In other words, since the total planned number of arrangements is determined before the number of arrangements is determined, and only high-priority plates are ordered up to the total number of planned arrangements. I'm sorry.

  Further, when the number of provisional arrangements set in the provisional arrangement instruction plan table 149a shown in FIG. 12 is compared with the number of arrangements in the arrangement instruction table shown in FIG. 18, the arrangement instruction date “2007 1 The number of orders for “Month 6” has been adjusted from “20” to “0”, and the number of orders for the order designation date “January 7, 2007” for the illustration “CP-3” has been adjusted from “20” to “10”. Has been adjusted. By such adjustment, generation of useless inventory is prevented.

  By the way, in the above example, in order to make it easy to understand how the arrangement instruction plan is newly established, the arrangement instruction after January 1, 2007 is not arranged yet and the arrangement instruction after January 1, 2007 is not yet planned. Have a plan in place. However, in practice, the daily required number is changed at any time according to the sales situation of products using the procured parts. In addition, the delivery conditions of the ordering party may be changed depending on the manufacturing status of the ordering party. The operator updates the contents of the delivery condition setting table 121 and the inventory balance evaluation table 131 by an operation input if there is a change in the required number or delivery conditions. Then, when the operator inputs an instruction to formulate an arrangement instruction plan to the parts arrangement management server 100, an arrangement instruction plan after that date is newly established. In addition, the parts arrangement management server 100 can formulate an arrangement instruction plan as a batch process at a predetermined time every day. If an arrangement instruction plan for a date after that date has already been established when the arrangement instruction plan is formulated, the arrangement instruction plan is canceled and newly formulated.

  The above processing functions can be realized by a computer. In that case, a program describing the processing contents of the functions that the parts arrangement management server 100 should have is provided. By executing the program on a computer, the above processing functions are realized on the computer. The program describing the processing contents can be recorded on a computer-readable recording medium. Examples of the computer-readable recording medium include a magnetic recording device, an optical disk, a magneto-optical recording medium, and a semiconductor memory. Examples of the magnetic recording device include a hard disk device (HDD), a flexible disk (FD), and a magnetic tape. Optical disks include DVD (Digital Versatile Disc), DVD-RAM, CD-ROM (Compact Disc Read Only Memory), CD-R (Recordable) / RW (ReWritable), and the like. Magneto-optical recording media include MO (Magneto-Optical disc).

  When distributing the program, for example, a portable recording medium such as a DVD or a CD-ROM in which the program is recorded is sold. It is also possible to store the program in a storage device of a server computer and transfer the program from the server computer to another computer via a network.

  The computer that executes the program stores, for example, the program recorded on the portable recording medium or the program transferred from the server computer in its own storage device. Then, the computer reads the program from its own storage device and executes processing according to the program. The computer can also read the program directly from the portable recording medium and execute processing according to the program. Further, each time the program is transferred from the server computer, the computer can sequentially execute processing according to the received program.

The present invention is not limited to the above-described embodiment, and various modifications can be made without departing from the gist of the present invention.
The main technical features of the embodiment described above are as follows.

(Appendix 1) An arrangement instruction plan program for causing a computer to execute a process for formulating an arrangement instruction plan for the parts to a plurality of suppliers who can order parts of the same specification,
The computer,
Corresponding to each of the suppliers to which the parts are delivered, an arrangement cycle indicating an interval at which the supplier can place an order, a lead time indicating a period from when an order is placed to the supplier, and delivery, and the component A delivery condition storage means for storing a distribution ratio indicating a ratio to be ordered from the ordering party out of the total number of orders;
Required number storage means for storing a required number indicating the number of parts required for the corresponding day for each date,
Priority order determining means for determining the priority order of each of the ordering parties so that the ordering priority is higher for the ordering party that has a longer period of the total of the arrangement cycle and the lead time, with reference to the delivery condition storage means;
The required number for each date within the planning period specified in advance with reference to the required number storage means is totaled to obtain a total required number, and the distribution rate of each of the ordering parties is referred to with reference to the delivery condition storage means A distribution number determining means that uses the number of proportional distributions of the total required number according to
The ordering party is selected in order from the top of the priority order, the ordering date for the ordering cycle interval in the planning period of the selected ordering party is determined, and the quantity of the parts to be ordered to the selected ordering party is determined. In the range where the total number of arrangements shown does not exceed the number of distributions, the arrangement instruction for the selected supplier is selected as the number necessary to satisfy the required number on the delivery date after the lead time from the arrangement instruction date. Arrangement number determining means for determining the number of arrangements for each day,
Arrangement instruction planning program to function as.

(Supplementary Note 2) The delivery condition storage means stores the number of deliverables per order of the parts of each of the ordering parties,
Said computer further
With reference to the delivery condition storage means, the parts can be ordered to each of the ordering parties within the planning period from the number of deliverables per ordering for each ordering party and the ordering cycle for each ordering party. It can function as an order quantity calculation means that calculates the maximum quantity and makes the order quantity available.
The order quantity determining means orders the distributable number to the selected ordering party within the planning period when the distributable number is smaller than the distribution number of the selected ordering party. The arrangement instruction planning program according to supplementary note 1, wherein the arrangement instruction planning program is an upper limit of the quantity of parts.

  (Additional remark 3) The said arrangement number determination means makes the number of deliverables per order of the said part the upper limit of the said arrangement number ordered on the said arrangement | positioning instruction | indication day with respect to the selected said ordering party. Arrangement instruction planning program described in Appendix 2.

(Supplementary Note 4) The delivery condition storage means stores the number of delivery lot units of each of the ordering parties,
The number-of-arrangements determination means places an order necessary for satisfying the required number of parts on the delivery date among multiples of the delivery lot unit number with respect to the selected ordering party on the order date. 2. The arrangement instruction planning program according to appendix 1, wherein the arrangement instruction plan is determined as the number of arrangements to be made.

  (Additional remark 5) The said arrangement number determination means makes the total delivery schedule which shows the total number of the said parts delivered by the said delivery date by making the total of the said required number until the delivery date into stock for every date. Necessary to calculate the surplus of inventory for each date based on the difference between the cumulative number of scheduled deliveries and the cumulative required number, and replenish the quantity obtained by subtracting the surplus of inventory from the required number on the delivery date to the previous day. The arrangement instruction planning program according to appendix 1, wherein a minimum number is determined as the number of arrangements to be ordered to the selected supplier on the arrangement instruction date.

(Supplementary note 6)
Referring to the delivery condition storage means, and functioning as a planning period determining means for determining a total period of the arrangement cycle and the lead time of the ordering party having the highest priority as the planning period. To arrange instruction planning program.

(Supplementary note 7) An arrangement instruction planning device for formulating an arrangement instruction plan for the parts to a plurality of suppliers who can order parts of the same specification,
Corresponding to each of the suppliers to which the parts are delivered, an arrangement cycle indicating an interval at which the supplier can place an order, a lead time indicating a period from when an order is placed to the supplier, and delivery, and the component A delivery condition storage means for storing a distribution ratio indicating a ratio to be ordered from the ordering party out of the total number of orders;
For each date, required number storage means for storing a required number indicating the number of parts required for the corresponding day;
Referencing the delivery condition storage means, priority order determining means for determining the priority order of each of the ordering destinations, so that the ordering priority is higher for the ordering party having a longer total period of the arrangement cycle and the lead time;
The required number for each date within the planning period specified in advance with reference to the required number storage means is totaled to obtain a total required number, and the distribution rate of each of the ordering parties is referred to with reference to the delivery condition storage means A distribution number determining means for proportionally distributing the total required number according to
The ordering party is selected in order from the top of the priority order, the ordering date for the ordering cycle interval in the planning period of the selected ordering party is determined, and the quantity of the parts to be ordered to the selected ordering party is determined. In the range where the total number of arrangements shown does not exceed the number of distributions, the arrangement instruction for the selected supplier is selected as the number necessary to satisfy the required number on the delivery date after the lead time from the arrangement instruction date. Arrangement number determining means for determining the number of arrangements for each day;
Arrangement instruction planning device having.

(Supplementary note 8) An arrangement instruction planning method for executing, on a computer, the preparation of an arrangement instruction plan for the parts for a plurality of suppliers who can order parts of the same specification,
The computer is
Corresponding to each of the suppliers to which the parts are delivered, an arrangement cycle indicating an interval at which the supplier can place an order, a lead time indicating a period from when an order is placed to the supplier, and delivery, and the component Delivery condition storage means for storing a distribution ratio indicating a ratio to be ordered from the ordering party out of the total number of orders, and a required number indicating a required number indicating the number of parts required for the corresponding day for each date Storage means is provided in advance,
Referring to the delivery condition storage means, determine the priority order of each of the ordering parties so that the ordering priority is higher for the ordering party having a longer total period of the arrangement cycle and the lead time,
The required number for each date within the planning period specified in advance with reference to the required number storage means is totaled to obtain a total required number, and the distribution rate of each of the ordering parties is referred to with reference to the delivery condition storage means The number of the total required number according to the proportional distribution as the distribution number of each supplier,
The ordering party is selected in order from the top of the priority order, the ordering date for the ordering cycle interval in the planning period of the selected ordering party is determined, and the quantity of the parts to be ordered to the selected ordering party is determined. In the range where the total number of arrangements shown does not exceed the number of distributions, the arrangement instruction for the selected supplier is selected as the number necessary to satisfy the required number on the delivery date after the lead time from the arrangement instruction date. Determined as the number of arrangements in each day,
An arrangement instruction planning method characterized by that.

It is a figure which shows the outline | summary of embodiment. It is a figure which shows the system configuration example of this Embodiment. It is a figure which shows the hardware structural example of the parts arrangement management server used for this Embodiment. It is a block diagram which shows the function of a parts arrangement management server. It is a figure which shows the example of a data structure of a delivery condition memory | storage part. It is a figure which shows the example of a data structure of an inventory balance value memory | storage part. It is a figure which shows the example of a data structure of the arrangement | positioning instruction | indication plan memory | storage part. It is a block diagram which shows the internal structure of a multi-vendor arrangement number determination part. It is a figure which shows the example of a data structure of a priority memory | storage part. It is a figure which shows the example of a data structure of a temporary total arrangement number memory | storage part. It is a figure which shows the example of a data structure of the arrangement number storage part in a plan period. It is a figure which shows the example of a data structure of a temporary arrangement instruction | indication plan memory | storage part. It is the first half of the flowchart which shows the procedure of the multi-vendor arrangement number determination process. It is the second half of the flowchart which shows the procedure of the multi-vendor arrangement number determination process. It is the first half of the flowchart which shows the procedure of arrangement number determination processing. It is the second half of the flowchart which shows the procedure of arrangement number determination processing. It is a figure which shows the inventory balance evaluation table after execution of multivendor arrangement number determination processing. It is a figure which shows the arrangement | positioning instruction | indication plan table after multi-vendor arrangement number determination processing execution.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Delivery condition storage means 2 Required number storage means 3 Priority order determination means 4 Distribution number determination means 5 Arrangement number determination means 6 Arrangement instruction plan

Claims (5)

An arrangement instruction planning program for causing a computer to execute a process for formulating an arrangement instruction plan for the parts for a plurality of suppliers who can order parts of the same specification,
The computer,
Corresponding to each supplier who delivers the part, an arrangement cycle indicating an interval at which the supplier can place an order, a lead time indicating a period from when an order is placed to the supplier, and delivery, and the part A delivery condition storage means for storing a distribution ratio indicating a ratio to be ordered from the ordering party out of the total number of orders;
Required number storage means for storing a required number indicating the number of parts required for the corresponding day for each date,
Priority order determining means for determining the priority order of each of the ordering parties so that the ordering priority is higher for the ordering party that has a longer period of the total of the arrangement cycle and the lead time, with reference to the delivery condition storage means;
The required number for each date within the planning period specified in advance with reference to the required number storage means is totaled to obtain a total required number, and the distribution rate of each of the ordering parties is referred to with reference to the delivery condition storage means A distribution number determining means that uses the number of proportional distributions of the total required number according to
The ordering party is selected in order from the top of the priority order, the ordering date for the ordering cycle interval in the planning period of the selected ordering party is determined, and the quantity of the parts to be ordered to the selected ordering party is determined. In the range where the total number of arrangements shown does not exceed the number of distributions, the arrangement instruction for the selected supplier is selected as the number necessary to satisfy the required number on the delivery date after the lead time from the arrangement instruction date. Arrangement number determining means for determining the number of arrangements for each day,
Arrangement instruction planning program to function as. The delivery condition storage means stores the number of deliverables per order of the parts of each of the ordering parties,
Said computer further
With reference to the delivery condition storage means, the parts can be ordered to each of the ordering parties within the planning period from the number of deliverables per ordering for each ordering party and the ordering cycle for each ordering party. It can function as an order quantity calculation means that calculates the maximum quantity and makes the order quantity available.
The order quantity determining means orders the distributable number to the selected ordering party within the planning period when the distributable number is smaller than the distribution number of the selected ordering party. 2. The arrangement instruction planning program according to claim 1, wherein an upper limit of the quantity of parts is set.   The arrangement number determining means sets the total required number of stocks up to the delivery date for each date as the cumulative required number, and sets the cumulative delivery planned number indicating the total number of parts delivered by the delivery date, Calculate the inventory surplus for each date based on the difference between the cumulative delivery schedule number and the cumulative required quantity, and the minimum necessary to replenish the quantity obtained by subtracting the inventory surplus from the required quantity on the delivery date to the previous day. 2. The arrangement instruction planning program according to claim 1, wherein a number is determined as the number of arrangements to be placed on the arrangement instruction date for the selected supplier. An arrangement instruction planning apparatus for formulating an arrangement instruction plan for the parts to a plurality of suppliers who can order parts of the same specification,
Corresponding to each of the suppliers to which the parts are delivered, an arrangement cycle indicating an interval at which the supplier can place an order, a lead time indicating a period from when an order is placed to the supplier, and delivery, and the component A delivery condition storage means for storing a distribution ratio indicating a ratio to be ordered from the ordering party out of the total number of orders;
For each date, required number storage means for storing a required number indicating the number of parts required for the corresponding day;
Referencing the delivery condition storage means, priority order determining means for determining the priority order of each of the ordering destinations, so that the ordering priority is higher for the ordering party having a longer total period of the arrangement cycle and the lead time;
The required number for each date within the planning period specified in advance with reference to the required number storage means is totaled to obtain a total required number, and the distribution rate of each of the ordering parties is referred to with reference to the delivery condition storage means A distribution number determining means for proportionally distributing the total required number according to
The ordering party is selected in order from the top of the priority order, the ordering date for the ordering cycle interval in the planning period of the selected ordering party is determined, and the quantity of the parts to be ordered to the selected ordering party is determined. In the range where the total number of arrangements shown does not exceed the number of distributions, the arrangement instruction for the selected supplier is selected as the number necessary to satisfy the required number on the delivery date after the lead time from the arrangement instruction date. Arrangement number determining means for determining the number of arrangements for each day;
Arrangement instruction planning device having. An arrangement instruction planning method for executing, on a computer, formulation of an arrangement instruction plan for the parts to a plurality of suppliers who can order parts of the same specification,
The computer is
Corresponding to each of the suppliers to which the parts are delivered, an arrangement cycle indicating an interval at which the supplier can place an order, a lead time indicating a period from when an order is placed to the supplier, and delivery, and the component Delivery condition storage means for storing a distribution ratio indicating a ratio to be ordered from the ordering party out of the total number of orders, and a required number indicating a required number indicating the number of parts required for the corresponding day for each date Storage means is provided in advance,
Referring to the delivery condition storage means, determine the priority order of each of the ordering parties so that the ordering priority is higher for the ordering party having a longer total period of the arrangement cycle and the lead time,
The required number for each date within the planning period specified in advance with reference to the required number storage means is totaled to obtain a total required number, and the distribution rate of each of the ordering parties is referred to with reference to the delivery condition storage means The number of the total required number according to the proportional distribution as the distribution number of each supplier,
The ordering party is selected in order from the top of the priority order, the ordering date for the ordering cycle interval in the planning period of the selected ordering party is determined, and the quantity of the parts to be ordered to the selected ordering party is determined. In the range where the total number of arrangements shown does not exceed the number of distributions, the arrangement instruction for the selected supplier is selected as the number necessary to satisfy the required number on the delivery date after the lead time from the arrangement instruction date. Determined as the number of arrangements in each day,
An arrangement instruction planning method characterized by that.

Images