JP2016194900A - Production schedule automatic planning device, production schedule automatic planning method and production schedule automatic planning program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a production schedule automatic planning device, production schedule automatic planning method, and production schedule automatic planning program that can attain standardization of a production load even when demand varies.SOLUTION: A production schedule automatic planning device according to the present invention comprises a control unit. The control unit comprises: preparation means; update means; and determination means. The preparation means is configured to use term-end safety inventory quantity data about an inventory schedule quantity at a term-end in a first period to plurally prepare short period reference safety inventory quantity data about an inventory schedule quantity in a second period. The update means is configured to use data on an increment/decrement in quantity in the first period to allocate an increment/decrement in product corresponding to the data on the increment/decrement in quantity to each of the inventory schedule quantity corresponding to a plurality of short period reference safety inventory quantity data. The determination means is configured to use the short period reference safety inventory quantity data and allocation quantity data about the allocation quantity of the product in the first period to determine a schedule quantity of the product to be produced in the second period.SELECTED DRAWING: Figure 5

Description

  The present invention relates to a production plan automatic planning apparatus, a production plan automatic planning method, and a production plan automatic planning program.

  In Patent Document 1, because of yield fluctuations and the like, the accumulated amount of production requirement amount is larger than the stock amount for assembly products including in-house device products for which it is difficult to create a production plan that can follow demand fluctuations. In this case, that is, when production increase is necessary, the value obtained by subtracting the inventory amount from the cumulative amount of production requirement is calculated as the production amount. On the other hand, if the cumulative amount of production requirement is less than the inventory amount, That is, a production planning system is disclosed in which production is reduced to 0 when production reduction is necessary (see paragraph [0020] etc.). According to the production planning system disclosed in Patent Document 1, it is possible to determine the production amount of a process component while securing an inventory amount that can cope with demand fluctuation.

  Patent Document 2 discloses calculating the number of days of inventory using a stock number and actual number of sales, which are real numbers, and basic data such as shipment results of managed objects, as an inventory management method. (See paragraphs [0010] to [0011] etc.). Patent Document 2 also discloses that the calculated inventory days data is applied to production control. Specifically, in the case of an increase in production, the increased production plan is updated to the latest production plan data. On the other hand, in the case of a decrease in production, it is disclosed that the production plan of the corresponding product that is earliest after the production plan fixed period is reduced (see paragraphs [0010] to [0011], etc.).

JP 2004-178037 A JP 2001-229319 A

  However, although the techniques described in Patent Documents 1 and 2 can cope with demand fluctuations, the increase in the case where an increase in production is necessary cannot be controlled. For example, the increase is excessive for the production capacity. However, there is a production load corresponding to the increase, and on the other hand, it is impossible to control the decrease when production reduction is necessary. May have to be zero. As described above, in the conventional technology, the production plan or the update thereof has been made without considering the operating state of the production facility and the production system. Therefore, the production capacity set according to the maximum production volume is sufficiently increased. There is a problem that it cannot be demonstrated. The same problem occurs not only in the production management scene as described above, but also in the inventory management and sales management scenes where inventory quantity management is required.

  The present invention has been made in view of the above-mentioned problems, and is an automatic production plan planning device, a production plan automatic planning method, and a production plan automatic that can standardize a production load even when demand varies. The purpose is to provide a planning program.

  In order to solve the above-described problems and achieve the object, the production plan automatic planning apparatus according to the present invention is a production plan automatic planning apparatus having a control unit for planning the number of plans for producing a product. The control unit uses the end-of-period safety stock quantity data related to the end-of-period inventory plan number in the first period, which is determined in consideration of the demand forecast for the product, and is included in the first period and the first period. Using creation means for creating a plurality of short cycle reference safety stock number data relating to the number of planned stocks in the second cycle, which is relatively shorter than one cycle, and increase / decrease data relating to the increase / decrease of the product in the first cycle And creating by the creation means by allocating the increase / decrease of the product corresponding to the increase / decrease number data to each of the inventory plan numbers corresponding to the plurality of short cycle reference safety inventory number data Update means for updating the short cycle reference safety stock number data, short cycle reference safety stock number data obtained by the update means, and allocation number data relating to the number of products to be allocated in the first period. And determining means for determining a planned number of products to be produced in the second period.

  Moreover, the production plan automatic planning apparatus according to the present invention is the production plan automatic planning apparatus described above, wherein the control unit should allocate to each of the number of inventory plans corresponding to the plurality of short cycle reference safety inventory number data. The apparatus further includes a calculation unit that calculates an allocation of the increase / decrease of the product using the number of days belonging to the first period.

  Furthermore, the production plan automatic planning apparatus according to the present invention is the above-described production plan automatic planning apparatus, wherein the number of days belonging to the first period is the number of working days on which the product can be produced. The calculation means includes coefficient setting means for setting a coefficient corresponding to the order in the first cycle for each working day, and the coefficient set by the coefficient setting means For the corresponding working day, a value obtained by dividing the increase / decrease of the product by the number of working days is multiplied by a coefficient set for the working day.

  The automatic production plan planning apparatus according to the present invention is the production plan automatic planning apparatus described above, wherein the first cycle is a period in units of months, and the second cycle is a day. The control unit includes reference date setting means for setting a reference date for an application period to be a target of planning the number of plans for producing the product, and the creating means includes the reference Using the end-of-period safety stock data regarding the planned number of stocks at the end of the next month of the month including the base date set by the date setting means, to create the short cycle base safety stock data for each day belonging to the next month Features.

  Moreover, the production plan automatic planning apparatus according to the present invention is the above-described production plan automatic planning apparatus, wherein the control unit includes a summary unit that performs a summary process on the number of plans of a plurality of types of products determined by the determination unit. It is further characterized by including.

  The production plan automatic planning method according to the present invention is a production plan automatic planning method for planning the number of plans for producing a product, which is executed in a production plan automatic planning apparatus having a control unit, wherein the control unit Using the end-of-period safety stock quantity data relating to the end-of-period inventory plan number in the first period, which is determined in consideration of the demand forecast for the product, which is included in the first period and Using a creation step of creating a plurality of short cycle reference safety stock number data relating to the number of planned stocks in the second cycle, which is relatively shorter than one cycle, and increase / decrease data relating to the increase / decrease of the product in the first cycle By assigning the increase / decrease amount of the product corresponding to the increase / decrease number data to each of the inventory plan numbers corresponding to the plurality of short cycle reference safety inventory number data, An update step for updating the short-cycle reference safety stock number data created in the creation step, a short-cycle reference safety stock number data obtained in the update step, and a provision number relating to the provision number of the product in the first cycle And a determination step of determining a planned number of products to be produced in the second period using the data.

  An automatic production plan planning program according to the present invention is a production plan automatic planning program for planning the number of plans to produce a product to be executed by a production plan automatic planning apparatus having a control unit. Using the end-of-period safety stock quantity data relating to the end-of-period inventory plan number in the first period, which is determined in consideration of the demand forecast for the product to be executed in the section, and included in the first period and A creation step of creating a plurality of short cycle reference safety stock number data related to the planned number of stocks in the second cycle, which is relatively shorter than the first cycle, and increase / decrease data related to the increase / decrease of the product in the first cycle Is used to divide the product increase / decrease corresponding to the increase / decrease data to each of the planned inventory numbers corresponding to the plurality of short cycle reference safety inventory data. The update step of updating the short cycle reference safety stock number data created in the creation step, the short cycle reference safety stock number data obtained in the update step, and the product in the first cycle And a determination step of determining a planned number of products to be produced in the second period using the allocation number data relating to the allocation number.

  The present invention can also be applied to inventory management. In this case, in order to solve the above-described problem, the inventory management apparatus according to the present invention is an inventory management apparatus having a control unit for managing the number of articles in stock. It is included in the first cycle and is relatively shorter than the first cycle, using the end-of-period safety stock quantity data relating to the number of inventory plans at the end of the first cycle, which is determined in advance in consideration of the prediction. A plurality of short cycles using creation means for creating a plurality of short cycle reference safety stock data relating to the planned number of stocks in the second cycle, and increase / decrease data relating to the increase / decrease in the number of articles in the first cycle The short cycle reference safety stock number created by the creating means by allocating the increase / decrease amount of the article corresponding to the increase / decrease number data to each of the inventory plan numbers corresponding to the reference safety inventory number data Characterized by comprising a updating means for updating the over data.

  According to the present invention, it is possible to standardize the production load even if the demand varies.

FIG. 1 is a diagram showing a reference example of an extra inventory when nothing is done to increase demand. FIG. 2 is a diagram showing an example of a planned stock increase when the number of safety stocks is increased or decreased by a conventional mechanism. FIG. 3 is a diagram illustrating an example of a planned stock increase when the daily safety stock number is set in the embodiment of the present invention. FIG. 4 is a block diagram showing an example of the configuration of a production plan automatic planning system including a production plan automatic planning apparatus according to an embodiment of the present invention. FIG. 5 is a diagram schematically showing a processing procedure of processing executed by the production plan automatic planning apparatus 100 in FIG. FIG. 6 is a diagram schematically showing a data flow in the end-of-month inventory plan data fetching process and the daily allocation process in step SA1 shown in FIG. FIG. 7 is a diagram showing an example of records stored in the work table 01 shown in FIG. FIG. 8 is a diagram showing an example of records stored in the work table 02 shown in FIG. FIG. 9 is a diagram illustrating an example of data stored in the work table 03 illustrated in FIG. FIG. 10 is a diagram showing an example of records stored in the work table 04 shown in FIG. FIG. 11 is a diagram illustrating an example of a month-end inventory plan number data capture screen displayed when the month-end inventory plan number data capture process is performed in step SA1 of FIG. FIG. 12 is a diagram illustrating an example of a layout of a CSV record stored in the CSV data master 106d. FIG. 13 is a flowchart showing the processing procedure of the end-of-month inventory plan data fetching process and the daily rate process executed in step SA1 of FIG. FIG. 14 is a diagram used to describe terms used in the description of steps SB4 to SB10 in FIG. FIG. 15 is a diagram used for explaining the process of setting an empty record in the work table 04 in step SB8 of FIG. FIG. 16 is a diagram illustrating an example of a relationship between a numerical value indicating the working day rank illustrated in FIG. 15 and the working day. FIG. 17 is a diagram used for explaining the process of setting the number of inventory plans for the working day in step SB10 of FIG. FIG. 18 is a diagram used for explaining the process of setting the number of inventory plans in the end-of-month date record in step SB10 of FIG. FIG. 19 is a diagram used for explaining the process of setting the number of inventory plans for a non-working day in step SB10 of FIG. FIG. 20 is a diagram used for explaining the update process performed on the daily inventory plan master 106a in FIG. FIG. 21 is a flowchart showing a processing procedure of the production plan automatic planning process executed in step SA2 of FIG. FIG. 22 is a diagram used for explaining the process of outputting information regarding the item code and the shipping date to work D in step SC1 of FIG. FIG. 23 is a diagram used for explaining the process of outputting the record to be planned in step SC1 of FIG. 21 from the order file to work A. FIG. 24 is a diagram used for explaining the process of outputting the planning target record from the unlisted file to the work A in step SC1 of FIG. FIG. 25 is a diagram used for explaining the update process performed in the order reservation file re-generation process in step SC2 of FIG. FIG. 26 is a diagram used for explaining the order file initialization process performed in the order reservation file regeneration process in step SC2 of FIG. FIG. 27 is a diagram used for explaining the initialization process of the production plan file performed in the order allocation file regeneration process in step SC2 of FIG. FIG. 28 is a diagram used for explaining the plan allocation file initialization process performed in the order allocation file regeneration process in step SC2 of FIG. FIG. 29 is a diagram used for explaining the production plan file re-allocation process performed in the production number plan file creation process in step SC4a of FIG. FIG. 30 is a diagram used for explaining the first plan allocation file update process performed in the production plan file creation process in step SC4a of FIG. FIG. 31 is a diagram used for explaining the order file re-allocation process performed in the production plan file creation process of step SC4a of FIG. FIG. 32 is a diagram used for explaining the first addition process of the production plan file performed in the production number plan file creation process of step SC4a of FIG. FIG. 33 is a diagram used for explaining the first addition process of the plan allocation file performed in the production plan file creation process of step SC4a of FIG. FIG. 34 is a diagram used for explaining the second re-allocation process of the production plan file performed in the production number plan file creation process of step SC4a of FIG. FIG. 35 is a diagram used for explaining the second addition process of the plan allocation file performed in the production number plan file creation process of step SC4a of FIG. FIG. 36 is a diagram used to describe the process of adding one record to work F performed in the MRP-like plan file creation process of step SC4b of FIG. FIG. 37 is a diagram used for explaining the process of setting items relating to the arrangement delivery date in the arrangement file performed in the MRP-like plan file creation process in step SC4b of FIG. FIG. 38 is a diagram used for explaining the process of setting items related to delivery date in the production plan file performed in the MRP-like plan file creation process of step SC4b of FIG. FIG. 39 is a diagram used for explaining processing for setting items relating to the necessary number for work D, which is performed in the MRP-like plan file creation processing in step SC4b of FIG. FIG. 40 is a diagram used for explaining the second addition process of the production plan file performed in the MRP-like plan file creation process of step SC4b of FIG. FIG. 41 is a diagram used for explaining the second addition process of the plan allocation file performed in the MRP-like plan file creation process in step SC4b of FIG.

  Embodiments of the present invention will be described in detail with reference to the drawings. In addition, this invention is not limited by this embodiment.

[1. Overview]
When no increase is made in the demand increase despite the expected increase in product demand (see FIG. 1), the stable inventory number remains set constant. In this case, there are problems such as an increase in production load and an increased risk of breaking the number of safety stocks. Therefore, in the past, in preparation for the expected increase in demand in production management (management computer), the daily stable inventory value is set to a high value corresponding to the increase in demand in the month prior to the month in which the demand increase is expected. The setting is changed (see FIG. 2).

  However, in the prior art (example shown in FIG. 2), on the management computer, the setting of the safety stock number is a unique setting for each product number. As a result of calculating the required amount (required production amount) of the product on the date of, a production instruction indicating that a large amount of product should be produced occurs as production management information. In particular, when the demand increase is significant, the possibility that a production instruction exceeding the production capacity is generated as production management information cannot be denied. On the other hand, if a change is made on the management computer to reduce the set value of the safety stock number, or a change is made to return to the original date after the change to increase the set value, the product on the date immediately after the change will be displayed. As a result of calculating the required amount, production instruction information indicating that there is no product to be produced is generated (that is, no production instruction is generated). And if it responds to such a production instruction | indication, there exists a problem that a production facility will become non-operation.

  The present embodiment relates to the daily setting of the number of safety stocks in the production plan, and the calculation of the required amount in consideration of the setting. Specifically, in the present embodiment, by setting the future safety stock number, the function of automatically calculating the daily safety stock number by the daily distribution for the safety stock number and the daily safety stock number are added. A function for calculating the required amount is included as a technical idea, and in this embodiment, the increase / decrease of the future safety stock number is allocated to the safety stock numbers of a plurality of previous days by these functions, The assigned safety stock number is used for automatic production planning.

  According to the present embodiment, it is possible to systematically increase product inventory for the future increase in demand (that is, in stages), so that it is possible to reduce the production load during the busy season. Therefore, it is possible to reduce the maximum production capacity of the production facility or use a production facility having a low maximum production capacity. In addition, according to the present embodiment, it is possible to reduce the number of excess product inventory while performing production adjustment step by step according to the number of safety stocks set to be small in order to reduce future demand. Therefore, not only a sudden outage of the equipment is avoided, but also the production capacity of the production equipment can be utilized even in a quiet period. In summary, according to the present embodiment, it is possible to reduce the production load during the busy season and to utilize the production capacity even during the quiet season. Even if there are fluctuations, the production load can be standardized (see FIG. 3).

  Note that the present embodiment is not limited to production management in the manufacturing industry (production work in factories or the like), but can be applied to, for example, inventory management or sales management of products in the retail industry. In this case, inventory management is possible. Can be standardized (for example, the load for ordering goods).

[2. Constitution]
An example of a configuration of a production plan automatic planning system including the production plan automatic planning apparatus according to the present embodiment will be described with reference to FIG. FIG. 4 is a block diagram showing an example of the configuration of a production plan automatic planning system including a production plan automatic planning apparatus according to an embodiment of the present invention.

  4 includes a production plan automatic planning apparatus 100 as an information processing apparatus, a server 200, and a network 300 that connects the production plan automatic planning apparatus 100 and the server 200 so that they can communicate with each other. It is out.

  The production plan automatic planning device 100 is a commercially available desktop personal computer, and is an information processing device for planning the number of products to be produced. The production planning automatic planning apparatus 100 is not limited to a stationary information processing apparatus such as a desktop personal computer, but is a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, tablet personal computer, or the like. It may be a portable information processing apparatus.

  The production plan automatic planning apparatus 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the production plan automatic planning apparatus 100 are communicably connected via an arbitrary communication path.

  The communication interface unit 104 communicatively connects the production plan automatic planning apparatus 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of connecting the production plan automatic planning apparatus 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet, an intranet, or a LAN (Local Area Network). Accordingly, the communication interface unit 104 is configured to be able to accept input information from an information processing apparatus not shown in FIG. 4 via the network 300 or via the network 300 and the server 200. The predetermined information is output to a predetermined information processing apparatus.

  The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records a computer program (including a production plan automatic planning program of the present invention) for performing various processes by giving instructions to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). The As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) and a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, and an optical disk can be used. The storage unit 106 stores various masters (databases or tables) used for executing the production plan automatic planning program of the present invention in a readable / writable manner. Various masters will be described later.

  An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker (including a home television), a speaker, and a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that realizes a pointing device function in cooperation with the mouse can be used. In the following description, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

  The control unit 102 is a CPU or the like that comprehensively controls the production plan automatic planning apparatus 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, and necessary data, and performs various information processing based on these stored programs. Run.

  Further, the configuration of the storage unit 106 and the configuration of the control unit 102 will be described in detail with reference to FIG.

  In the example shown in FIG. 4, the storage unit 106 includes a daily inventory plan master 106a, an arrangement condition master 106b, an item master 106c, a CSV data master 106d, an order data master 106e, an unannounced data master 106f, An inventory data master 106g and a plan data master 106h are stored.

  The daily inventory plan master 106a is a master for storing daily reference safety stock quantity data described later. This daily standard safety stock data is a record that includes information on planned stock, item code, date (year and month), safety stock (upper limit), safety stock (lower limit), order point, order review period, etc. is there.

  The arrangement condition master 106b is a master for storing conditions necessary for product production or inventory management as set values. Examples of set values include the number of safety stocks (upper limit) and the number of safety stocks (lower limit). , Order point, order review period, base code, item code, route, and arrangement pattern.

  The item master 106c is a master for storing information for identifying or specifying a product. This master includes, for each product, for example, production base code, item classification, unlisted order plan classification, plan allocation classification, planning draft classification, unlisted order plan classification, plan summary classification, minimum plan number, incremental plan number, maximum plan. Number, item name, inventory unit code, and shipping location code are registered.

  The CSV data master 106d is a master for storing end-of-period safety stock quantity data, which will be described later. This end-of-life safety stock data is record data in which information on the planned product inventory at the end of the month (the number of planned stock at the end of the month) is recorded for a number of months. There may be. The end-of-month inventory plan number is a preset value determined in consideration of demand forecast.

  The order data master 106e is a master for storing information related to product orders. In this master, for example, customer code, item code, production plan requirement category, complete delivery category, inventory management shipment quantity, inventory allocation quantity, production completion quantity, delivery date, production shipment date, order classification, order number , Item name, Delivery date, Scheduled shipment date, Production shipment date, Inventory management order quantity, Inventory management shipment quantity, Inventory unit code, Inventory unit name, Inventory allocation location code, Inventory allocation number, Production instruction number, Manufacturing completion number, Production Stored is a record in which information relating to a necessary plan category, a production plan date, the number of plans, and a product number are recorded.

  The inside data master 106f is a master for storing information relating to the inside data. In this master, for example, a record in which information relating to a customer code, an item code, an inside date, a planned shipping date, an inside number, an item number, an inside date, and the number of indications is recorded for each product.

  The inventory data master 106g is a master for storing information related to product inventory for each product. This master stores a record in which information about the current inventory quantity is recorded for each product.

  The plan data master 106h is a master for storing information related to a production plan for a product to be described later.

  Moreover, as shown in FIG. 4, the control part 102 is provided with the daily process part 102a and the planning part 102b on the functional concept.

  The daily processing unit 102a functions as a means for executing an inventory management method of an automatic production plan making method described later. This means includes a creating means for creating short cycle reference safety stock quantity data and an updating means for assigning the increase / decrease of the product corresponding to the increase / decrease number data.

  The planning unit 102b functions as a means for executing a production management method of a production plan automatic planning method described later. This means includes determining means for determining the planned number of products to be produced.

[3. First Embodiment]
Subsequently, a first embodiment of the present invention will be described. Specifically, the processing procedure of the production plan automatic planning method according to the first embodiment executed in the production plan automatic planning system including the production plan automatic planning apparatus 100 shown in FIG. 4 will be described. Most of this processing is executed by the control unit 102 of the production plan automatic planning apparatus 100 in FIG. The production plan automatic planning method according to the first embodiment generally includes an inventory management method for determining the safety stock number of a product, and a product based on the safety stock number determined by the inventory management method. This method includes a production management method for determining the number of productions to be produced. When there are a plurality of types of products, this processing is performed for each product.

  First, the processing procedure of the inventory management method will be described. Most of the processing relating to this inventory management method is executed by the daily processing unit 102a of the control unit 102. In order to execute these processes, it is preferable to form a predetermined work area (work) in the storage unit 102 and create save data on the work.

  First, in the first step of the inventory management method, a reference date for an application period to be subject to inventory management is determined (reference date setting means). The application period that is the target of inventory management also corresponds to the application period that is the target of planning the number of products to be produced in the production management method described later. This reference date may be the current date or a date later than the current date. Then, the month following the month including the reference date is set as the application period. The last day of the application period can be set by default or arbitrarily, and is set, for example, at the last day of the month after next (that is, for three months).

  In the subsequent second step, a series of data relating to the predetermined number of inventory plans is read in units of months.

  Here, the planned number of stocks means the number planned as the number of stocks of products that has been determined in consideration of demand forecasts for products, and is usually scheduled at the end of the cycle every predetermined cycle. Inventory quantity (hereinafter also referred to as “the planned inventory quantity at the end of the term”). The demand forecast may have been made with reference to past manufacturing results, or may have been obtained through market research, or may take into account both past manufacturing results and market research results. It may be. In general, the planned number of stocks is set to a value that sufficiently exceeds the number of products estimated from the demand forecast so as not to run out of stock. Data on the planned number of stocks at the end of the period over a plurality of consecutive periods set in this way (hereinafter also referred to as “term-end safety stock quantity data”) is stored in advance in the storage unit 106 or the external storage device. Is preferred.

  Next, in the third step, from the series of end-of-period safety stock data read out in the second step, one-month end-of-life safety stock data (for example, end-of-life safety stock data for the month following the month including the reference date) ), And the value of the planned number of inventory at the end of the month corresponding to the extracted end-of-period safety stock data is read, and the value of the planned inventory at the end of the last month of the month corresponding to the extracted end-of-period safety stock data Reading and calculating the difference between them (that is, the increase / decrease in the number of inventory plans after one month) and obtaining the calculation result as increase / decrease data (calculation means). In the increase / decrease number data, the increase is represented by a positive integer, the decrease is represented by a negative integer, and zero when there is no increase / decrease. Note that this increase / decrease number data preferably also includes information on irregular movement of the product (for example, lending / borrowing to other manufacturing bases, acceptance of return or cancellation, and direct shipment).

  Subsequently, in the fourth process, for the month corresponding to the end-of-period safety stock data extracted in the third process, the daily data (hereinafter referred to as “daily standard safety stock data”) for the number of days in the corresponding month. Prepare) (creating means). The initial value of the daily standard safety stock quantity data is zero or null, and when this process has already been performed, the value set as the daily standard safety stock quantity data prepared at that time is used. .

  Next, in the fifth process, for each of the plurality of daily standard safety stock data prepared in the fourth process, the daily standard safety stock data is related to the working days on which the product can be produced. If it is an operating day, set the coefficient according to the date order in the month (coefficient setting means), and if it is not an operating day, The same coefficient is set (coefficient setting means). The determination about the working day is performed according to the calendar of the site where the product is produced.

  In the sixth step, out of the daily standard safety stock number data prepared in the fourth step, the daily standard safety stock number data determined as the working day in the fifth step is The increase / decrease amount of the product corresponding to the increase / decrease number data acquired in the three steps is assigned. As a result, the daily reference safety stock quantity data is updated (update means). That is, by this process, a value related to the increase / decrease allocated to the daily reference safety stock quantity data is set.

  Here, an example of a method for assigning the increase / decrease in the sixth step will be described. This example relates to the case where an integer indicating the date order in the month is set as the coefficient set in the fifth process.

  In order to allocate the increase / decrease, first, the value of the planned inventory number on the last day of the previous month of the month corresponding to the period-end safety inventory data extracted in the third process is used as the reference value for allocation, and this value corresponds to the working day. Assigned to each of the daily standard safety stock data. Next, the slope distribution using the coefficient is performed on the daily reference safety stock quantity data corresponding to the working day. Specifically, the increase / decrease in the product corresponding to the increase / decrease data is divided by the number of working days to obtain the daily increase / decrease data related to the daily increase / decrease, and then the daily increase / decrease data corresponding to the acquired increase / decrease data is obtained. The increase / decrease is multiplied by an integer as a coefficient set on the working day, and the obtained value is assigned to the daily standard safety stock data for the working day. That is, the daily reference safety stock data corresponding to the working day is assigned a value obtained by adding the result of multiplying the daily increase / decrease and the coefficient set on the working day to the reference value of the planned number of stocks. As a result, when there is an increase / decrease (that is, unless there is an increase / decrease), the value of the planned number of inventory allocated to the daily basic safety inventory data is gradually increased or decreased as the working day date advances. On the other hand, even when there is no increase / decrease, the reference value of the planned number of inventory can be assigned to the daily reference safety inventory number data regardless of the coefficient set on the working day. In addition, the same value as the value of the number of planned stocks assigned on the previous day is assigned to the daily standard safety stock number data corresponding to the non-working day (working stop day). Furthermore, the value of the planned inventory number on the last day of the last month of the month corresponding to the period-end safety inventory number data extracted in the third step is updated with the above reference value.

  Next, in the seventh step, it is determined whether or not to set the number of inventory plans for the next month. This determination is performed by determining whether or not there is end-of-period safety stock data corresponding to the next month of the month corresponding to the end-of-period safety stock data extracted in the third step in the application period determined in the first step. Done. When setting the number of inventory plans for the next month, the process returns to the first process, the reference date is updated to the next month, and the processes from the second process to the sixth process are performed. If the number of inventory plans for the next month is not set, all processes of the inventory management method are completed. Thereby, the number of inventory plans is set for each day belonging to the application period determined in the first step. The set stock plan number is stored in the daily stock plan master 106a as the daily standard safety stock number data.

  Second, the processing procedure of the production management method will be described. Most of the processing relating to this production management method is executed by the planning unit 102b of the control unit 102. In order to execute these processes, it is preferable to form a predetermined work area (work) in the storage unit 102 and create save data on the work.

  First, in the first step of the production management method, the reference date is determined in the same manner as in the first step of the inventory management method. Read. The read order file and plan allocation file are initialized or deleted unnecessary data on the work as necessary.

  Subsequently, in the second step, for each target product, a production plan file related to the product production plan is created daily for each production base. Specifically, the number of plans for producing the target product is set in the production plan file (decision means). The number of plans to produce the target product includes the number of stocks on the relevant date, the data on the number of orders received and the delivery date in the order file read in the first step, the data on the number of provisions in the plan allocation file, It is set based on the number of inventory plans set in the daily data created by the processing related to the inventory management method. Here, the number of stocks on the relevant date also takes into account the number of finished products indicating the number of products that have already been produced and shipped on the relevant date, and lead time before shipment. Schematically, the number of plans for producing a target product is determined by subtracting the number of allocations and the number of completed products from the number of inventory plans. More preferably, the planned number for producing the target product is determined in consideration of the number included in one lot. If the production plan file cannot be created due to lack of data to be used, etc., the order conditions read from the order condition master 106b, for example, the upper limit value, lower limit value, or predetermined order point of the safety stock number It is preferable to set the target product as the planned number to be produced.

  And in a 3rd process, the process of the 1st process-the 2nd process mentioned above is performed also about another production base. Here, the planned number of products for all production bases may be totaled as necessary. Furthermore, in the fourth step, when production management is performed for other products, the above-described first to third steps are performed. In addition, instead of the third step and the fourth step, or in parallel, the total number (planning process) of the planned number of plural types of products may be performed for each production base (summarizing means). Then, all processes related to the production management method are completed.

  According to the production plan automatic planning method according to the first embodiment described above, at the time of inventory management, the end-of-period safety stock quantity data related to the end-of-term inventory plan number in a predetermined month that is determined in consideration of the demand forecast for products is obtained. The daily standard safety stock data relating to the planned number of stocks on the day belonging to the predetermined month is created for the number of days belonging to the month (the fourth step of the inventory management method), and the above predetermined Increase / decrease in the number of products corresponding to the increase / decrease data using the increase / decrease data related to the increase / decrease of the product in the month (third step of the inventory management method) By allocating the minutes, the daily standard safety inventory number data is updated (6th step of the inventory management method), so it fluctuates to the planned number of inventory at the end of the specified month (product demand) Even while ensuring safety stock quantity, it is possible to allocate the increment or decrement of inventory planning number of end of the predetermined month daily. That is, the increase / decrease in the number of inventory plans at the end of the predetermined month can be standardized uniformly over the predetermined month. Further, by updating the reference date (seventh step of the inventory management method), it is possible to determine the number of inventory plans ahead.

  Further, in the above-described inventory management, an increase / decrease amount of the product corresponding to the increase / decrease number data is assigned to each of the daily standard safety inventory number data determined to be the working day (sixth step of the inventory management method). Therefore, it is possible to perform inventory management by selecting an operating day, that is, a day on which the number of inventory can be adjusted, and it is possible to eliminate the need to allocate a non-operating day to product production from the viewpoint of production management. Further, in the sixth step of the inventory management method, in order to allocate the increase / decrease, the slope allocation is performed using the coefficient set on the working day, and the inventory plan number allocated to the daily basic safety inventory number data is determined. Since the value is gradually increased or decreased as the working day progresses, it is possible to increase or decrease the production amount on a daily basis considering the production equipment and production system, thereby rapidly increasing the product production load. Or it is possible to avoid a sudden decrease.

  Further, according to the production plan automatic planning method according to the present embodiment, the daily standard safety inventory number data obtained by using the inventory management method and the provision relating to the number of provisions of the product in the predetermined month in the production management. Using the numerical data, the planned number of products to be produced on the day belonging to the predetermined month is determined (the second step of the production management method), so the production plan from the month following the month including the reference date is automatically performed. Will be planned. As a result, even if there is a change in the planned number of inventory at the end of the specified month (product demand), the amount of product increased or decreased according to the planned number of stock at the end of the period while securing the number of safety stock Can be averaged over the predetermined month, thereby increasing or decreasing production in stages toward the end of the period, that is, standardizing the production load. Further, a further production plan can be made by changing or updating the reference date.

  Note that the “number of days belonging to the month” is preferably the number of working days on which a product is produced, as described above, in consideration of the production management method. However, the production management method is not considered. When focusing on inventory management only, the number of days belonging to the relevant month may be simply used. In this case, the necessary number of inventory is calculated in consideration of the number of inventory and ordered to the production site. Alternatively, it is preferable to devise a production plan that takes into account operating days in production management.

  In the first embodiment described above, data (period-by-day) for a period (cycle) in units of days using data (period-end safety stock quantity data) for periods (cycles) in units of months. However, the unit of the period is not limited to the month and day, and data for a relatively short period is created using data for a relatively long period. This can provide the same effects as those described above.

[4. Specific example of the first embodiment]
Next, a specific example of the production plan automatic planning method according to the first embodiment described above will be described with reference to FIGS.

[4-1. Outline of processing]
The outline of the process of the production plan automatic planning for the end-of-month safety stock quantity executed in this specific example will be described with reference to FIGS. FIG. 5 is a diagram schematically showing a processing procedure of processing executed by the production plan automatic planning apparatus 100 in FIG.

[Step SA1: Data acquisition at the end of the month and daily processing]
The daily processing unit 102a refers to the CSV data master 106d and takes in the month-end safety stock quantity as text data (CSV file) (see FIG. 6). Then, the daily processing unit 102a processes the captured data (period-end safety stock number data) with various work tables to create daily safety stock data (daily reference safety stock data) by daily processing. The set data is set (stored) in the daily inventory plan master 106a (see FIG. 6).

  Here, the work table 01 (name: “WF _” + JOBID + “01”) shown in FIG. 6 stores a record (see FIG. 7) that records the error check result of the CSV file read data (character string state). The In the work table 02 (name: “WF _” + JOBID + “02”) shown in FIG. 6, a CSV record (see FIG. 8) in which the error check result is OK is stored. Further, error list data (see FIG. 9) is stored in the work table 03 (name: “WF _” + JOBID + “03”) shown in FIG. Further, the work table 04 (name: “WF _” + JOBID + “04”) shown in FIG. 6 stores a record (see FIG. 10) after the daily processing.

  FIG. 11 is a diagram illustrating an example of a month-end inventory plan number data capture screen displayed when the month-end inventory plan number data capture process is performed in step SA1 of FIG.

  As shown in Fig. 11, this month-end inventory plan number data capture screen selects the area for selecting the file to be imported and that the first line of the file to be imported is the title (check) Area to select, processing to select the process when there is the same data (code) as the data to be updated from now on, area to enter the acquisition start date, and acquisition target year and month And an area for inputting. Here, regarding the data to be captured, if it is known in advance that the data is stored from the first row, the area for selecting that the first row is a title may be fixed as “no check”. Alternatively, an area for selecting that the first line is a title may be hidden, or the area may not be provided. Moreover, it is preferable that the initial display of the area for inputting the acquisition start date is the current date (year / month) in order to save the user's trouble. In addition, based on the input value of the area for entering the start date of capture, the area for entering the target year / month is “input year / month”, “next month”, and “next month” Is displayed.

  FIG. 12 is a diagram illustrating an example of a layout of a CSV record stored in the CSV data master 106d. As shown in FIG. 12, the number of month-end inventory plans for a plurality of months (three months in the example shown in FIG. 12) is recorded in the CSV record. The “data name” may be recorded on the first line of the record. In this case, the data line starts from the second line. In addition, the numerical item may include “¥”, “−”, “,”, “.”. In addition, data that is not entered in the data No column is ignored at the time of reading and may be used as a memo at the time of input. In addition, when a blank line is found in the middle, it may be skipped.

[Step SA2: Automatic production planning]
The planning unit 102b determines the number of production management plans based on the daily safety stock data created in step SA1. For products (items) for which daily safety stock is not set, the number of safety stocks set in the arrangement condition master 106b is adopted as the planned number in production management.

  The above [4-1. [Processing Overview] ends.

[4-2. Details of end-of-month inventory plan data import processing and prorated processing]
The end-of-month inventory plan data fetching and daily allocation processing executed in this example will be described in detail with reference to FIGS. FIG. 13 is a flowchart showing the processing procedure of the end-of-month inventory plan data fetching process and the daily rate process executed in step SA1 of FIG.

  Here, in this description, a CSV record of check OK (“the number of next month's stock plan”, “the number of next month's stock plan” and “the number of next month's stock plan”) is stored in the work table 02 (work 02). It shall be. In this description, “@” added to the data name is a symbol indicating a variable. In this description, it is assumed that a client name (client No.) is specified.

[Step SB1: Create cursor]
The daily processing unit 102a extracts the data of the work 02 in accordance with the extraction conditions shown below, and creates a cursor (hereinafter referred to as “cursor A”) (specifies a data area). The cursor A is created (data area moved) in the following sort order. Specifically, the processes in steps SB1 to SB10 are executed as a loop process. That is, the processing of steps SB1 to SB10 is performed for each row No. As a result, cursor creation is performed for all row Nos.
<Extraction conditions>
Work 02. Client No = Client name <Sort order>
Work 02. Line No

[Step SB2: Deletion Process]
The daily processing unit 102a checks whether or not the same data as the cursor A to be updated already exists in the work table 04 (work 04) in accordance with the following extraction conditions.
<Extraction conditions>
Work 04. Client No. = Client name & Work 02. Client No. = Client name & Work 04. Item code = cursor A. Item code

As a result of the check, if there is no data that matches the extraction condition, the daily processing unit 102a executes a process of step SB3 described later. If there is data corresponding to the extraction condition as a result of the check, the daily processing unit 102a performs the processing described below. In addition, screen. Depending on the selected value of the same code (area for selecting the process when there is the same data (code) on the end-of-month inventory plan data import screen shown in FIG. 11), the daily processing unit 102a branches the process. .
(Screen: Same code = Overwrite)
The daily processing unit 102a deletes all the records of the workpiece 04 that match the extraction condition, and proceeds to the process of step SB3 as it is.
(Screen: Same code = skipping)
The daily processing unit 102a skips the subsequent processing for the cursor A created in step SB1, and returns to the processing in step SB1. That is, the process proceeds to the next line of the cursor A.

[Step SB3: Acquisition of safety stock number lower limit value]
The daily processing unit 102a reads (refers to) the arrangement condition master 106b with the following extraction conditions, and acquires the lower limit value (@safety stock number lower limit) of the safety stock number. Here, the lower limit value of the number of safety stocks is set for each standard pattern CD in the standard order pattern M, or is set according to the pattern CD of the basic information M. Therefore, the daily processing unit 102a searches the standard arrangement pattern M using the item M “production base code” and the cursor A “item code” as KEY, and specifies the standard pattern CD.
<Extraction conditions>
Base code = Item M “Manufacturing base code”
Item code = cursor A "item code"
Route = 999
Pattern CD = standard arrangement pattern Standard pattern CD (basic information M. pattern CD if not)

  Next, the daily rate processing unit 102a performs the steps described below in relation to the three items of the “number of next month's stock plan”, “the number of next month's stock plan” and “the number of next month's last month's stock plan” of the work 02. The processes of SB4 to SB10 are executed in order. For this reason, as shown in FIG. 14, item names <reference date>, <calculation target> for each case of “number of next month inventory plan”, “number of next month end stock plan” and “number of next month end month stock plan”. Loop processing is performed while rereading “date>” and “monthly inventory plan number”. Further, if each value of <monthly stock plan number> is smaller than the lower limit of the safety stock number, <monthly stock plan number> is read as @safety stock number lower limit.

[Step SB4: Initialization of each variable]
The daily allocation processing unit 102a initializes each variable as described below.
@ Number of planned stocks at the end of the month = 0
@ Number of changes = 0
@ Next year month = NULL
@ Total working days = 0
@ Number of daily changes = 0

[Step SB5: Acquisition of the number of base plan at the end of the standard]
The daily allocation processing unit 102a uses the following extraction conditions to determine the daily inventory plan M.M. The number of inventory plans (@base month-end inventory plan number) is acquired (step SB5).
<Extraction conditions>
Daily inventory plan Item code = cursor A. Item code daily inventory plan Date (year / month) = <reference date> (year / month)
Here, among the records that can be acquired under the above extraction conditions, the number of inventory plans of the “maximum date” record is acquired as the @reference month-end inventory plan number.

[Step SB6: Acquisition of increase / decrease number]
The daily processing unit 102a acquires a value (@ increase / decrease number) of “cursor A. <number of month-end inventory plan> − @ number of standard month-end inventory plan”.

[Step SB7: Acquisition of calculation target date]
The daily processing unit 102a acquires the value of “<calculation target date>” (@next year / month).

[Step SB8: Acquisition of total operating days]
The daily rate processing unit 102a sets empty records from the first day to the last day of @the following year in the work 04 (see FIG. 15).

The operation classification shown in FIG. 15 is acquired by referring to the calendar M according to the following extraction conditions (* 1 shown in FIG. 15). Here, the value indicating the operation classification is “1” on the operation day and “0” on the non-operation day (operation suspension date).
<Extraction conditions>
Calendar M. Site code = Item M. Manufacturing base code (cursor A. Item M lead with item code) → In the unlikely event of invalid, lead & calendar M. Date = @ Next year (1st-last day)

In addition, the numerical value indicating the working day order shown in FIG. 15 (* 2 shown in FIG. 15) is incremented every time a working day (working division = 1) appears in order of date as in the example shown in FIG. Get by doing.
Then, the daily processing unit 102a acquires the total number of working days (@total number of working days) for the next year and month. Since the value of the total working days is the same as the maximum value of the numerical values indicating the working day rank, it can be easily obtained.

[Step SB9: Acquisition of daily increase / decrease number]
The daily processing unit 102a acquires the value of “@ increase / decrease number ÷ @ total working days” (@ daily increase / decrease number). This value is, for example, a numerical value with three decimal places obtained by rounding off the fourth decimal place.

[Step SB10: Update planned stock quantity]
The daily allocation processing unit 102a sets the number of inventory plans as shown in FIG. 17 for the working days that meet the following conditions for the records from the first day to the last day of the following year. In the example shown in FIG. 17, it is possible to increase the production amount (gradual increase) or adjust the reduction amount (gradual decrease) for each record by using a value corresponding to the working day rank.
<Conditions>
Work 04. Client No. = Client name work 04. Item code = cursor A. Item code work 04. Date (year / month) = @ next year / month work 04. Operation classification = 1 (operation)

Furthermore, the daily processing unit 102a, among records that meet the following conditions, works 04. Get the value of the inventory plan number of the one with the largest date (that is, the record corresponding to the last day of the working day of the month), and use the @standard month-end inventory plan number as the value of the inventory plan number in the month end date record The same value is set (see FIG. 18). As a result, the @reference month-end inventory plan number is set in the month-end date record.
<Conditions>
Work 04. Client No. = Client name work 04. Item code = cursor A. Item code work 04. Operation classification = 1
Work 04. Date (year / month) = @ Next year / month

On the other hand, as shown in FIG. 19, the daily rate processing unit 102a sets the number of inventory plans for the “non-working day (working stop date)” record that meets the following conditions. As a result, the record from the first day to the last day of the following year is updated.
<Conditions>
Work 04. Client No. = Client name work 04. Item code = cursor A. Item code work 04. Date (year / month) = @ next year / month work 04. Operation classification = 0 (pause)
In addition, regarding the inventory plan number set in the non-working days shown in FIG. 19 (* 1 shown in FIG. 19), when “work 04. date-1 day” corresponds to the previous month date (that is, the last day of the previous month) @Set the value of the number of planned stocks at the end of the month as the number of planned stocks.

  Then, when further processing is performed for the next month, etc., the processing returns to step SB4. When processing for the next row No is performed, the processing returns to step SB1, and all row Nos are processed. When the process is finished, the process is completed.

By the way, when performing the daily inventory plan master update process at a predetermined timing or at an arbitrary timing, the daily processing unit 102a deletes the record of the daily inventory plan M that meets the following conditions, and the work table 04 Is added (registered) to the daily inventory plan M (see FIG. 20). Thereby, the record in the daily inventory plan master is updated. When the record is invalid in the corresponding master, NULL is set as the safety stock quantity.
<Conditions>
Daily inventory plan Item code = work 04. Item code daily inventory plan Date (year / month) = work 04. Date (year and month)
Work 04. Client No = client name

  With the above, [4-2. [Details of Monthly Stock Plan Number Data Capture Processing and Daily Processing] is finished.

[4-3. Details of automatic production planning process]
The production plan automatic planning process executed in this specific example will be described in detail with reference to FIGS. FIG. 21 is a flowchart showing a processing procedure of the production plan automatic planning process executed in step SA2 of FIG.

  Prior to executing the processing shown in FIG. 21, necessary information such as customer CD (customer code), item CD (item code), item classification, manufacturing base code, order delivery date, production delivery date, and planned date Is preliminarily input via a predetermined data input screen. In the following description, “order data master 106e” is “order F”, “item master 106c” is “item M”, “inside data master 106f” is “inside F”, and “arrangement condition master” 106b "may also be referred to as" arrangement condition M ".

[Step SC1: Order file and unlisted file extraction]
The planning unit 102b performs the following processes (10) to (11).

(10) The planning unit 102b performs the following processes (10a) to (10c) to extract the planning target record from the order F and outputs it to the work table A (work A).

(10a) The planning unit 102b extracts, from the order F, a record for the item for which the final order date is fixed (ie, a record with the maximum value indicating the planned shipment date) as a record that meets the following conditions. Then, the information regarding the item code and the shipping date is output to the work table D (work D) (see FIG. 22).
<Conditions>
Order F. Customer code = screen. Customer code (screen. When customer CD = NULL, it is not included in the condition)
Order F. Item code = screen. Within the range of the item code (screen. Item CDMin, when Max = NULL is not included in the condition)
screen. When the item CDMin = NULL, the order F. Item code ≤ screen. Item code Max
screen. When item CDMax = NULL, order F. Item code ≧ screen. Item code Min

(10b) The planning unit 102b extracts, from the order F, a record for planning that meets the following conditions.
<Conditions>
Order F "Item category" = 0 (general)
& Item M “Manufacturing site code” = Screen “Manufacturing site CD”
& Order F "Production plan required category" ≠ 0
& Item M “Item classification” ≠ 99
& Order F “Complete delivery category” ≠ 1 or {Order F “Complete delivery category” = 1 & “Inventory management shipment number”> “Inventory allocation number” + “Production completion number”}
& Order F "Delivery date" ≤ Screen "Order delivery date" (When screen "Order delivery date" = NULL, it is not included in the condition)
& Order F "Manufacturing Ship Date" ≤ Screen "Manufacturing Delivery Date"
& Order category ≠ 2 (Unlisted order) or {Order category = 2 (Unlisted order) & Item M “Unlisted order plan category” ≠ 0 (No planning)}
& Order F. Customer code = screen. Customer code (screen. When customer CD = NULL, it is not included in the condition)
& Order F. Item code = screen. Within the range of the item code (screen. Item CDMin, when Max = NULL is not included in the condition)
screen. When the item CDMin = NULL, the order F. Item code ≤ screen. Item code Max
screen. When item CDMax = NULL, order F. Item code ≧ screen. Item code Min

(10c) The planning unit 102b outputs the planning target record extracted in (10b) to the work A (see FIG. 23). Note that the values of the safety stock quantity, the order point, and the order review period (note 1 in FIG. 23) shown in FIG. 23 are obtained by performing the following processes i) to iii) in this order.
i) Set 0 as the initial value.
ii) Lead the arrangement condition M by manufacturing base code + item code + work order [999] + pattern [1]. However, if each item is NULL and the arrangement condition M invalid is 0. On the other hand, at the time of validating, each item is set (set) as follows using the value acquired as a result of the lead.
Work A. Number of safety stock (upper limit) ← Arrangement conditions Number of safety stock (upper limit)
Work A. Number of safety stock (lower limit) ← Arrangement conditions Number of safety stocks (lower limit)
Work A. Order point ← Arrangement conditions Reorder point work A. Order review period ← Arrangement conditions Order review period iii) Lead daily inventory plan M by item code + planned delivery date, and at the time of valid, use the values obtained as a result of the lead for the upper limit of the safety stock number and the order point as follows Overwrite to.
Work A. Number of safety stock (upper limit) ← Daily inventory plan Stock Plan Number Work A. Reorder point ← Daily inventory plan Number of planned stocks Note that the lower limit of the number of safety stocks is only a set from the arrangement condition M.

(11) The planning unit 102b extracts the records from the planning target indication F by performing the following processes (11a) to (11c), and additionally outputs them to the work A.

(11a) The planning unit 102b extracts, from the order F, a record for planning that meets the following conditions. Thereby, the record regarding the unordered order is extracted.
<Conditions>
Item M. Manufacturing base code = screen. Manufacturing base code & announcement F. Customer code = screen. Customer code (screen. When customer CD = NULL, it is not included in the condition)
& Indication F. Item code = screen. Within the range of the item code (screen. Item CDMin, when Max = NULL is not included in the condition)
screen. When the item CDMin = NULL, the indication F. Item code ≤ screen. Item code Max
screen. When the item CDMax = NULL, the indication F. Item code ≧ screen. Item code Min
& Indication F. Indication date ≤ screen. Order delivery date (screen. When order delivery date = NULL, it is not included in the condition)
& Indication F. Indication date ≤ screen. Production delivery date (screen. When production delivery date = NULL, it is not included in the conditions)
& Indication F. Indication date ≥ screen. Planned date However, records that match the following conditions will not be output in the following (11b) even if they are extracted in (11a), or they will not be overwritten if they are already output. Is set to
<Conditions>
Indication F. Item code = work A. Item code & indication F. Scheduled shipping date = Work A. Scheduled Ship Date & Work A. Complete payment category ≠ 11

(11b) The planning unit 102b outputs the record extracted in (11a) to the work A (see FIG. 24).
Here, the value of the manufacturing shipment date shown in FIG. 24 (note 1 in FIG. 24) is obtained and set as shown below. In addition, the term used etc. is based on the term used by the working day calculation process which is a common specification. That is, the production shipment date (reference date) is determined in consideration of the warehouse entry lead time on the scheduled shipment date.
Reference date: Estimated shipping date-Kurairi LT
LT: 0
Base code: Manufacturing base code increase / decrease classification: 2 (past)
As the value of the above-mentioned Kurairi LT, the value of “Kurairi LT” which is read as KEY in the shipping location code + the manufacturing base code in the Kurairi LTM (master) is used. However, at the time of INV (allocation), the value of “Kurairi LT” in the basic information M is used.

Further, the values of the safety stock number, the order point, and the order review period (note 2 in FIG. 24) shown in FIG. 24 are obtained by performing the following processes i) to iii) in this order.
i) Set 0 as the initial value.
ii) Lead the arrangement condition M by manufacturing base code + item code + work order [999] + pattern [1]. However, if each item is NULL and the arrangement condition M invalid is 0. On the other hand, at the time of validating, each item is set (set) as follows using the value acquired as a result of the lead.
Work A. Number of safety stock (upper limit) ← Arrangement conditions Number of safety stock (upper limit)
Work A. Number of safety stock (lower limit) ← Arrangement conditions Number of safety stocks (lower limit)
Work A. Order point ← Arrangement conditions Reorder point work A. Order review period ← Arrangement conditions Order review period iii) Lead daily inventory plan M by item code + planned delivery date, and at the time of valid, use the values obtained as a result of the lead for the upper limit of the safety stock number and the order point as follows Overwrite to.
Work A. Number of safety stock (upper limit) ← Daily inventory plan Stock Plan Number Work A. Reorder point ← Daily inventory plan Number of planned stocks Note that the lower limit of the number of safety stocks is only a set from the arrangement condition M.

(11c) The planning unit 102b regenerates an order allocation file (hereinafter also referred to as “order allocation inventory F” or “order allocation inventory F”) for the record output to the work A in (11b). In this order allocation F regeneration process, inventory allocation for the remaining order is made for the current inventory quantity, and thereby the inventory quantity that is not the target of the order becomes more apparent. The order allocation file is updated when there is a new setting or a change to the inventory allocation number.

  Here, with reference to FIG. 25 and the like, the order reservation F regeneration process will be described. The planning unit 102b performs the order reservation F regeneration process according to the following procedures (1) to (5).

(1) The planning unit 102b sorts the plurality of records in the work A in the order of “item code”> “shipment base code”> “shipment location code”> “scheduled shipping date”> “order number”. Thus, the next record is read in the sort order every time the processes (2) to (4) shown below are completed. However, records that meet the condition of complete payment category = 11 (cancel) are skipped.

(2) The current stock F is read by item code + “999” + shipping base code + shipping location code, and the current number of warehouses is acquired as “current number of warehouses”. However, the current number of warehouses is acquired only for the records of asset category = 1 (own asset), status category = 0 (normal) or 1 (unchecked).

(3) Lead order reserve inventory F is read with item code + “999” + shipping base code + shipping place code, and updating (added at INV) as shown in FIG. 25 is performed.

(4) Work A. The order F is read by the order number, and (4-1) or (4-2) shown below is updated according to the current number of workpieces.
(4-1) In the case of “current number of workpieces” ≧ (work A. inventory management order quantity−work A. inventory management shipment quantity). Number of inventory reservations ← Order received Inventory management orders received. Number of manufacturing instructions ← 0
・ Order reserve inventory Orders reserved ← Orders received F. Add inventory management orders / work A. Number of plans required ← 0
Subtract “Work A. Inventory Management Order Number-Work A. Inventory Management Shipment Number” (4-2) “Work Current Stock Number” <(Work A. Inventory Management Order Number-Work A) .Inventory management shipment number) ・ Orders received only when the indicated data category = 0 (order received). Number of inventory reservations ← Order received Inventory management shipment number + "Current number of workpieces"
Order F. Number of production instructions ← (Work A. Inventory management orders-Work A. Inventory management shipments)-"Current number of workpieces"
・ Order reserve inventory Number of orders reserved ← Add “Number of current workpieces” ・ Work A. Necessary number of plans ← After the above calculation. Number of manufacturing instructions / “Current number of workpieces” ← 0

(5) The update process of (4) above is performed by the work A. This process is repeated until the item code + shipping base code + shipping location code breaks. If a break occurs, the process returns to the above (1) and the above-described processing is performed for other records.

[Step SC2: Initialization and deletion processing]
The planning unit 102b performs the following processes (20) to (24).

(20) The planning unit 102b initializes the order F for the record output to the work A. Details of this processing are shown in FIG. As a result, the order file is updated.

(21) The planning unit 102b performs an initialization process for the production plan F for records that meet the following conditions. Details of this processing are shown in FIG. Thereby, the production plan file is updated.
<Conditions>
Production plan F “Manufacturing site code” = Screen “Manufacturing site CD”
& Item M. Manufacturer code = screen. Customer code (screen. When customer CD = NULL, it is not included in the condition)
& Plan allocation Item code = screen. Within the range of the item code (screen. Item CDMin, when Max = NULL is not included in the condition)
screen. When the item CDMin = NULL, the planned allocation F. Item code ≤ screen. Item code Max
screen. When the item CDMax = NULL, the planned allocation F. Item code ≧ screen. Item code Min

(22) The planning unit 102b deletes a record that meets the following conditions from the plan allocation F as unnecessary data. Further, the production plan file associated with the record to be deleted from the plan allocation file, which matches the condition of production plan F “required amount calculation date” = NULL, is also deleted.
<Conditions>
Production plan F “Manufacturing site code” = Screen “Manufacturing site CD”
& Item M. Manufacturer code = screen. Customer code (screen. When customer CD = NULL, it is not included in the condition)
& Plan allocation Item code = screen. Within the range of the item code (screen. Item CDMin, when Max = NULL is not included in the condition)
screen. When the item CDMin = NULL, the planned allocation F. Item code ≤ screen. Item code Max
screen. When the item CDMax = NULL, the planned allocation F. Item code ≧ screen. Item code Min
& Plan Reserve F “Acceptance Number” = 0
& Plan Reserve F “Transfer Plan Number” = 0
& Plan Allocation F “Production Plan Category” ≠ 11 (Automatic Planning Plan)
or plan allocation F “production plan category” = 11 (automatic planning) & plan allocation F “plan allocation category” = 1 (split allocation)
or plan allocation F “production plan category” = 11 (automatic planning) & plan allocation F “plan summary category” = 1 (summarize)
or plan allocation F “production plan category” = 11 (automatic planning) & item M “plan allocation category” = 1 (partition allocation)
or plan allocation F “production plan category” = 11 (automatic planning) & item M “plan summary category” = 1 (summarize)
However, for records where the order number, the production plan number, and the receipt number are not “0”, it is checked whether or not the corresponding record exists in the order F, the production plan F, and the receipt result F. Records that are not valid are also deleted.

(23) The planning unit 102b deletes a record that meets the following conditions from the production plan F as unnecessary data.
<Conditions>
Production plan F “Manufacturing site code” = Screen “Manufacturing site CD” & Production plan F “Production plan category” = 12 (Indicated automatic planning plan)
& Item M. Manufacturer code = screen. Customer code (screen. When customer CD = NULL, it is not included in the condition)
& Production Plan F. Item code = screen. Within the range of the item code (screen. Item CDMin, when Max = NULL is not included in the condition)
screen. When the item CDMin = NULL, the production plan F. Item code ≤ screen. Item code Max
screen. When the item CDMax = NULL, the production plan F. Item code ≧ screen. Item code Min

(24) The planning unit 102b performs an initialization process for the plan allocation F for records that meet the following conditions. Details of this processing are shown in FIG. Thereby, the plan allocation file is updated.
<Conditions>
Production plan F “Manufacturing site code” = Screen “Manufacturing site CD”
& Plan Reserve F “Acceptance Number” = 0
& Item M. Manufacturer code = screen. Customer code (screen. When customer CD = NULL, it is not included in the condition)
& Production Plan F. Item code = screen. Within the range of the item code (screen. Item CDMin, when Max = NULL is not included in the condition)
screen. When the item CDMin = NULL, the production plan F. Item code ≤ screen. Item code Max
screen. When the item CDMax = NULL, the production plan F. Item code ≧ screen. Item code Min

[Step SC3: Preparation for creating a new plan]
The planning unit 102b targets all records of the work A as a preparation for creating a new production plan record (hereinafter also simply referred to as “new plan”) in the production plan F. Each is output to a predetermined output destination (work) according to the value of the plan summary section. Specifically, work A.1. When the plan summary category = 0 (not), the corresponding record is output to the work C which is a work area for performing a production number plan F creation process described later. In addition, Work A. When the plan summary category = 1 (Yes), the corresponding record is output to the work D, which is a work area for performing the MRP-like plan F creation process described later. The plan summary classification is an identification flag indicating whether or not there is a plan to collect (aggregate) a plurality of production plan records for the purpose of material requirements planning (MRP) and the like, and is set in each record. Yes.

[Step SC4: Plan file creation process]
The planning unit 102b determines whether the work C has a record or the work D has a record, and changes the plan file creation process according to the determination result. Specifically, if there is a record in work C, the production plan F creation process is performed as the plan file creation process (step SC4a). On the other hand, if there is a record in work D, the plan file creation is performed. As processing, MRP-like plan F creation processing is performed (step SC4b).

[Step SC4a: Production plan F creation process]
First, the production plan F creation process will be described.

  When there is a record in the work C, the planning unit 102b performs a production number plan F creation process in the following procedures (1) to (4).

(1) A plurality of records in the work C are subjected to sort processing using the following sort key.
Sort key: Item code> Scheduled shipment date> Internal data classification> Order number

(2) Among the plurality of records of work C, the unrecorded record and the top record in the sort order of (1) above are read, and the “planning required number” in the program is set as follows: Set.
“Required number of plans” ← Work C. Number required for planning

(3) Read the plan allocation file and extract records that meet the following conditions.
<Conditions>
Plan allocation F "Order number" = Work C "Order number"
& Plan Reserve F “Acceptance Number” = 0
& Plan Reserve F “Transfer Plan Number” = 0
Here, at the time of valid, the re-allocation process is executed in the production plan file, the first update process is executed in the plan allocation file, and the process returns to the above (2) to make the serial number for the next record in the work C. The target plan F creation process is performed. The details of the re-allocation process in the production plan file are shown in FIG. 29, and the details of the first update process in the plan allocation file are shown in FIG. As a result, the production plan file and the plan allocation file are updated.

(4) The record of the production plan F is read from the workpiece C, the value of the “planned allocation category” in the workpiece C is determined, and the following processing (4-1) or (4-2) is performed according to the determination result. Do.

(4-1) When “planned allocation category” in work C = 0 (not divided allocation), firstly, a record that satisfies the following conditions is extracted from the production plan F.
<Conditions>
Work C “Manufacturing Ship Date” ≧ Production Plan F “Delivery Date”
& Production Plan F “Manufacturing Base Code” = Screen “Manufacturing Base CD”
& Production Plan F “Item Code” = Work C “Item CD”
& Production Plan F “Number of Plans”-“Number of Planned Provisions”-“Number of Completed” ≧ “Number of Necessary for Planning” in Program
& Production Plan F “Production Plan Category” = 1,11
& Production Plan F “Complete Payment” = 0
As a result of the above extraction, if a plurality of records have the same delivery date, the record with the higher priority of the production plan F “production plan category” (priority decreases in the order of 1 → 11) is used.

Subsequently, the extracted records are processed by the following procedures A) to E).
A) The “number of necessary plans” in the program is defined as “the number of work plans” in the program, “the number of work plans” in the program, and “the number of work plans allocated” in the program.
B) Re-allocation processing is performed in the order file. Details of the re-allocation process in the order file are shown in FIG. As a result, the order file is updated.
C) The re-allocation process shown in FIG. 29 is performed in the production plan file. Thereby, the production plan file is updated.
D) When work C “complete payment category” ≠ 11 (cancel), the first update process shown in FIG. 30 is performed in the plan allocation file. Thereby, the plan allocation file is updated.
E) The above-described processing is performed on the next record in the work C.

If there is no record that satisfies the above condition as a result of the extraction process (4-1), the process is performed in the following procedures A) to F).
A) The “number of necessary plans” in the program is defined as “the number of work plans” in the program, “the number of work plans” in the program, and “the number of work plans allocated” in the program.
B) When work C “planning category” ≠ 1 (automatic planning), the above-described processing is performed on the next record in work C.
C) The re-allocation process shown in FIG. 31 is performed in the order file. As a result, the order file is updated.
D) Perform the first additional processing in the production plan file. Details of the first addition process in the production plan file performed at this time are shown in FIG. Thereby, the production plan file is updated.
E) The first additional processing is performed in the plan allocation file. Details of the first addition processing in the plan allocation file performed at this time are shown in FIG. Thereby, the plan allocation file is updated.
F) The above-described processing is performed on the next record in the work C.

(4-2) When “planned allocation category” in work C = 1 (divided allocation), firstly, a record that satisfies the following conditions is extracted from the production plan F.
<Conditions>
Work C “Manufacturing Ship Date” ≧ Production Plan F “Delivery Date”
& Production Plan F “Manufacturing Base Code” = Screen “Manufacturing Base CD”
& Production Plan F “Item Code” = Work C “Item CD”
& Production Plan F "Number of Plans"-"Number of Planned Provisions"-"Number of Completed"> 0
& Production Plan F “Production Plan Category” = 1 or 11
& Production Plan F “Complete Payment” = 0
As a result of the above extraction, if a plurality of records have the same delivery date, the record with the higher priority of the production plan F “production plan category” (priority decreases in the order of 1 → 11) is used.

Subsequently, in the extracted record, the operation result of the production plan F “plan number” − “plan allocation number” − “completed number” is acquired, and depending on the acquired operation result, the following processing (A) or Process (B) is performed.
(A) When the production plan F “number of plans” − “number of planned allocations” − “number of completed” ≧ “number of required plans” in the program, processing is performed in the following procedures a) to e).
a) The “number of necessary plans” in the program is defined as “the number of work plans” in the program, “the number of work plans” in the program, and “the number of work plans allocated” in the program.
b) In the order file, the re-allocation process shown in FIG. 31 is performed. As a result, the order file is updated.
c) A second re-allocation process is performed in the production plan file. The details of the second re-allocation process in the production plan file are shown in FIG. As a result, the production plan file is updated.
d) When the order F “complete payment category” ≠ 11 (cancel), the first update process shown in FIG. 30 is performed in the plan allocation file. Thereby, the plan allocation file is updated.
e) The above-described processing is performed on the next record in the work C.
(B) In the case of production plan F “number of plans” − “number of planned allocations” − “number of completed” <number of “planning required” in the program, processing is performed in the following procedures a) to f).
a) Production Plan F “Number of Plans” — “Number of Planned Provisions” — “Number of Completed” is defined as “Number of Work Plans” in Program, “Number of Work Plans” in Program, “Number of Work Plans Provisioned” in Program To do.
b) In the order file, the re-allocation process shown in FIG. 31 is performed. As a result, the order file is updated.
c) The second re-allocation process shown in FIG. 34 is performed in the production plan file. As a result, the production plan file is updated.
d) When the order F “complete payment category” ≠ 11 (cancel), the first update process shown in FIG. 30 is performed in the plan allocation file. Thereby, the plan allocation file is updated.
e) The “plan required number” in the program− (production plan F “number of plans” − “number of planned allocations” − “number of completed”) is set as the “number of required plans” in the program.
f) The above-described processing is performed on the next production plan data.

As a result of the extraction process of (4-2) above, even if all of the production plan data has been read, the case where “planning required number”> 0 in the program, and the result of the extraction process of (4-2) above If there is no record that meets the above conditions, the following procedures A) to F) are performed.
A) The “number of necessary plans” in the program is defined as “the number of work plans” in the program, “the number of work plans” in the program, and “the number of work plans allocated” in the program.
B) When work C “planning category” ≠ 1 (automatic planning), the above-described processing is performed on the next record in work C.
C) The re-allocation process shown in FIG. 31 is performed in the order file. As a result, the order file is updated.
D) In the production plan file, the first addition process shown in FIG. 32 is performed. As a result, the production plan file is updated.
E) Perform a second additional process in the plan allocation file. Details of the second addition process in the plan allocation file are shown in FIG. Further, the first update process shown in FIG. 30 is performed in the plan allocation file. As a result, the plan allocation file is updated.
F) The above-described processing is performed on the next record in the work C.

  As described above, the production number plan F creation processing in step SC4a is performed.

[Step SC4b: MRP-like plan F creation process]
Next, the MRP plan F creation process will be described.

  When there is a record in the work D, the planning unit 102b performs MRP-like plan F creation processing in the following procedures (1) to (6).

(1) A plurality of records in the work D are sorted by the following sort key.
Sort key: Item code> Scheduled shipment date> Internal data classification> Order number

(2) Create work F, initialize it to an empty file. This work F functions as a planned stock work for MRP.

(3) The following processes (3-1) to (3-5) are performed at the first time every time a plurality of records in the work D are read and the work D “manufacturing base code” / “item code” breaks.

(3-1) The work F (MRP scheduled stock work F) is cleared (initialized), and one record is added. FIG. 36 shows a process for adding one record to the work F.
(3-2) “0” is set in “W plan required number” in the program.

(3-3) The value of “current stock quantity” in the program is calculated according to the following procedures (A) to (C).
(A) Extracts records that match the following extraction conditions from the current inventory file, totals the values of “current number of warehouses” acquired from all the extracted records, and displays the total result as “current number of workpieces” Get as.
<Extraction conditions>
Current stock F “item code” = work D. Item Code & Current Stock F “Routing” = “999”
& Current inventory F "Location code" = screen. Base code & current inventory F "Asset classification" = "1" (own asset)
& Current Stock F “Inventory Status” = “0” (Normal) or “1” (Unchecked)
& Current Stock F “Current Number” ≠ “0”

(B) Records that match the following extraction conditions are extracted from the order reservation inventory file, the number of “orders reserved” obtained from all the extracted records is totaled, and the total result is “number of work order reservations” get.
<Extraction conditions>
Order reserve inventory F “item code” = work D. Item Code & Order Reserve Inventory F “Routing” = “999”
& Order reservation inventory F “Location code” = screen. Base Code & Order Reserve Inventory F “Number of Order Reserves” ≠ “0”

(C) The value of “current number of workpieces” − “number of work order reservations” is set as “current number of warehouses” in the program.
(3-4) First, a record that matches the following extraction condition is extracted from the arrangement file.
<Extraction conditions>
Arrangement F “Arrangement occurrence category” ≠ “4” (direct delivery order), “12” (unplanned addition), “13” (unplanned division)
& Arrangement F "Manufacturing base code" = Work D "Manufacturing base code"
& Arrangement F "Item code" = Work D "Item code"
& Arrangement F “Processing Order” = “999”
& Arrangement F "Complete payment category" = "0"
& Arrangement F ("Number of arrangements-Number of receipts")>"0"
& (Arrangement F “Indication division” ≠ 1 or Arrangement F “Arrangement method division” ≠ 1)
Subsequently, the work F is led by “arrangement delivery date” from the extracted record of the arrangement F, and when valid, the value of the arrangement F “number of arrangements” − “number of receipts” is added to the “number of arrangements” and updated. . During invalidation, items as shown in FIG. 37 are set and additionally output is performed.

(3-5) First, a record that matches the following extraction condition is extracted from the production plan file.
<Extraction conditions>
Plan F “Production plan category” ≠ “1” (expected plan), “11” (automatic plan)
& Plan F “Manufacturing base code” = Work D “Manufacturing base code”
& Plan F "Item code" = Work D "Item code"
& Plan F “Work order” = “999”
& Plan F "Complete payment category" = "0"
& Plan F (“Number of Plans”-“Number of Completed”)> “0”
& Plan F “Requirement Calculation Date” = NULL
Subsequently, from the extracted record of the production plan F, the work F is led by “delivery date”, and when valid, the value of the plan F “number of plans” − “number of completed” is added to the “number of orders” and updated. . Note that, at the time of invalidation, items as shown in FIG. 38 are set and output additionally.

(4) As a result of the processing in (3) above, when there are a plurality of records having the same work D “production base code”, “item code”, and “route”, first, the work D “scheduled shipping date” Then, the record of the work F is read, and when valid, the value of the work D “necessary number of planning” is added to the “necessary number” and updated. Note that at the time of invalidation, items as shown in FIG. 39 are set and additionally output. Subsequently, the record content of the work D is saved in an item in the program (hereinafter also referred to as “evacuation work D”). However, when the “minimum plan number” is “0” and the “incremental plan number” is “0”, the minimum value is obtained by the decimal significant digits of the inventory unit code. When these processes are completed, the process returns to the process (3) and the next record in the work D is processed.

(5) Each time a plurality of records in work D are read and work D “manufacturing base code”, “item code”, “route” breaks, the following processing (5-1) to (5-2) I do.

(5-1) The value of “current stock quantity” in the program is set to “scheduled stock quantity” in the program. At this time, in the “current stock quantity” in the program, as described for the order reservation F regeneration process, the current stock quantity after the stock reservation is recorded.

(5-2) The record of the workpiece F is read and the following processing (A) to (E) is performed.

(A) The value of “scheduled inventory quantity” in the program−work F “necessary quantity” + work F “arranged quantity” is set in the “scheduled inventory quantity” in the program.

(B) When “planned stock quantity” in the program ≧ evacuated work D “order point”, the “scheduled stock quantity” in the program is set to the work F “scheduled stock quantity”, and the processing returns to (A). Process the next record.

(C) The maximum “planned stock quantity” within the range is acquired from the “date” of the read record. At this time, the order review period is considered. Specifically, first, the date (year / month / day) obtained by adding the number of days corresponding to the evacuation work D “order review period” (the number of days on an operating day basis) to the “year / month / day” of the lead record. ) Is calculated (GetLeadDay), and then the “planned inventory quantity” that takes the maximum value within the calculated date range is acquired.

(D) In accordance with the acquired value of “planned stock quantity”, the necessary number of arrangements is obtained as follows. When “planned stock quantity” ≧ evacuation work D “order point”, first, the value of “scheduled stock quantity” in the program is checked, and “scheduled stock quantity” in the program ≧ evacuation work D “safety stock quantity (lower limit) ) ”, The value of“ scheduled stock quantity ”in the program is set to the work F“ scheduled stock quantity ”, the process returns to the process of (A), and the next record is processed. When “planned stock quantity” <evacuation work D “safety stock quantity (lower limit)”, the value of “evacuation work D“ safety stock quantity (upper limit) ”−“ planned stock quantity ”in the program is set as“ necessary number of arrangements ”in the program. And On the other hand, in the case of “planned stock quantity” <evacuation work D “order point”, the value of “evacuation work D“ safety stock quantity (upper limit) ”−“ planned stock quantity ”in the program is set to“ required quantity to be arranged ”in the program. "

(E) The quantity is summarized by the following processes (E-1) to (E-3). By this process, it is possible to set the necessary number of arrangements considering the number of lots.

(E-1) The following processes (a) to (e) are performed when “required number of arrangements” ≦ saving work D “minimum lot number” in the program.
(A) The value of the evacuation workpiece D “minimum lot number” is set in the “number of W arrangements” in the program.
(B) A second additional process is performed in the production plan file. Details of the second addition process in the production plan file performed at this time are shown in FIG. Further, a second addition process is performed in the plan allocation file. Details of the second addition process in the plan allocation file performed at this time are shown in FIG. As a result, the production plan file and the plan allocation file are updated.
(C) The value of the “number of W arrangements” in the program is added to the “planned stock quantity” in the program.
(D) The value of “scheduled stock quantity” in the program is set to work F “scheduled stock quantity” and updated.
(E) Returning to the processing of (A), processing for the next record is performed.

(E-2) When the evacuation workpiece D “maximum number of lots” = “0”, the following processes (a) to (f) are performed.
(A) The calculation result (rounded up) of “the number of arrangements required in the program” −evacuation work D “minimum lot number”) ÷ evacuation work D “increment lot number” is “WKA”. <"WKA": 9 (9)>
(B) The value of “WKA” × evacuation workpiece D “incremental lot number” + evacuation workpiece D “minimum lot number” is set in “W arrangement number” in the program.
(C) In the production plan file, the second addition process shown in FIG. 40 is performed. Furthermore, the second addition process shown in FIG. 41 is performed in the plan allocation file. As a result, the production plan file and the plan allocation file are updated.
(D) The value of “number of W arrangements” in the program is added to “planned stock quantity” in the program.
(E) The value of “scheduled stock quantity” in the program is set to work F “scheduled stock quantity” and updated.
(F) Returning to the processing of (A), processing for the next record is performed.

(E-3) When the evacuation workpiece D “maximum number of lots” ≠ “0”, the following processes (a) to (d) are performed.

(A) The calculation result of “required number of arrangements” ÷ evacuation work D “maximum number of lots” in the program is “WKN” remainder “WKM”.

(B) The following processes (b-1) to (b-3) are repeated for the value of “WKN”.
(B-1) The value of the evacuation workpiece D “maximum number of lots” is set in the “number of W arrangements” in the program.
(B-2) In the production plan file, the second addition process shown in FIG. 40 is performed. Furthermore, the second addition process shown in FIG. 41 is performed in the plan allocation file. As a result, the production plan file and the plan allocation file are updated.
(B-3) The value of “W arrangement number” in the program is added to “scheduled stock quantity” in the program.
(B-4) The value of “scheduled stock quantity” in the program is set to work F “scheduled stock quantity” and updated.

(C) When “WKM” ≦ saving work D “minimum lot number”, the following processes (c-1) to (c-4) are performed.
(C-1) The value of the evacuation work D “minimum lot number” is set in the “number of W arrangements” in the program.
(C-2) In the production plan file, the second addition process shown in FIG. 40 is performed. Furthermore, the second addition process shown in FIG. 41 is performed in the plan allocation file. As a result, the production plan file and the plan allocation file are updated.
(C-3) The value of “number of W arrangements” in the program is added to “planned stock quantity” in the program.
(C-4) The value of “scheduled stock quantity” in the program is set to work F “scheduled stock quantity” and updated.

(D) When “WKM”> evacuation workpiece D “minimum number of lots”, the following processes (d-1) to (d-5) are performed.
(D-1) The calculation result (rounded up) of {(“WKM” −evacuation work D “minimum lot number”) ÷ evacuation work D “increment lot number”} is “WKA”. <"WKA": 9 (9)>
(D-2) The value of the saved work D “minimum lot number” + saved work D “incremental lot number” × “WKA” is set in the “number of W arrangements” in the program.
(D-3) In the production plan file, the second addition process shown in FIG. 40 is performed. Furthermore, the second addition process shown in FIG. 41 is performed in the plan allocation file. As a result, the production plan file and the plan allocation file are updated.
(D-4) The value of “number of W arrangements” in the program is added to “planned stock quantity” in the program.
(D-5) The value of “scheduled stock quantity” in the program is set to work F “scheduled stock quantity” and updated.

(F) Returning to the process (A) described above, the process for the next record is performed.

(6) Returning to the process of (3) described above, the process for the next record in the work D is performed. When the processing for all the records is completed, this processing is completed.

  As described above, the MRP-like plan F creation process in step SC4b is performed.

  In the above-described production plan F creation process in step SC4a and MRP plan F creation process in step SC4b, predetermined output and necessary update processing are performed for the determined number of plans.

  With the above, [4-3. [Details of Details of Automatic Production Planning Process] is finished.

[5. Second Embodiment]
Next, a second embodiment of the present invention will be described.

  In the first embodiment described above, the production plan automatic planning method is used to execute the process related to the inventory management method and the process related to the production management method to determine the number of plans for producing the product. In the present embodiment, the planned number of inventory is determined by noting the planned number of products to be produced but focusing only on inventory management of articles.

  The inventory management method according to the present embodiment can be executed in the same manner as the inventory management method included in the production plan automatic planning method according to the first embodiment described above. However, in the present embodiment, it is not necessary to consider the working day for the purpose of production management, and therefore the processing related to these may be omitted or skipped. For this reason, the production plan automatic planning apparatus 100 described in the first embodiment can also function as an inventory management apparatus.

  In the present embodiment, an increase / decrease number related to the number of goods in and out of inventory of goods may be used as the increase / decrease data. Here, the increase / decrease in inventory takes into consideration the number of arrivals and shipments of goods according to orders, and more preferably, irregular movements of goods (for example, lending / borrowing to other bases, returns / cancellations) It is preferable to take into account the amount received and the portion directly sent. In the present embodiment, the planned number of inventory is determined by executing the process described in the first embodiment using these increase / decrease number data.

  In the present embodiment, more preferably, the apparatus may be configured to place an order for the shortage of goods (necessary number) from the production site or a wholesaler in accordance with the determined planned number of inventory (ordering means). In this case, it is more preferable to place an order in consideration of the working day or the delivery date of the production site or the wholesaler. Similarly, the necessary number (excess) of goods is configured so that it can be wholesaled or sold to customers, submitted to purchasers, and stored at other locations. May be.

[6. Third Embodiment]
Next, a third embodiment of the present invention will be described.

  In the second embodiment described above, the inventory management of articles has been described. However, in the present embodiment, information on the required number of articles determined in the second embodiment is received, and based on the received information, The required number required for production is determined as the planned number. In order to realize this, the production plan automatic planning apparatus 100 described in the first embodiment may be used. Specifically, the process related to the production management method included in the production plan automatic planning method according to the first embodiment may be executed.

[7. Fourth Embodiment]
Next, a fourth embodiment of the present invention will be described.

  In the first to third embodiments described above, the necessary number is determined as the planned number for the inventory management of products and the production management of products, but in this embodiment, a program corresponding to these is determined in the past. Used for verification or simulation of inventory results and product production results. Specifically, since multiple calculation results can be obtained by changing the application date (base date) and application period, whether or not the past inventory performance was appropriate or from what point in the past is adjusted. It is possible to obtain verification materials on whether or not it was appropriate, etc., thereby examining the extent of inventory space or the production capacity of production equipment or the production system (production equipment operation time, increase in personnel, etc.) It is also possible to make use of it for examination.

[8. Other Embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

  For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed can be performed manually, or all of the processes described as being performed manually are all performed. Alternatively, a part can be automatically performed by a known method.

  In addition, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and database configurations shown in the present specification and drawings, unless otherwise specified. Can be changed arbitrarily.

  In addition, regarding the production plan automatic planning apparatus 100 and the production plan automatic planning system, each illustrated component is functionally conceptual and does not necessarily need to be physically configured as illustrated.

  For example, all or some of the processing functions provided in the production plan automatic planning apparatus 100, particularly the processing functions performed by the control unit 102, are realized by the CPU and a program interpreted and executed by the CPU. Alternatively, it may be realized as hardware by wired logic. The program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing the information processing apparatus to execute the processing described in the present embodiment. It is mechanically read by the planning device 100. In other words, in a storage unit such as a ROM or a HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU.

  The computer program may be stored in an application program server (for example, a server 200 connected via the network 300) connected to the production plan automatic planning apparatus 100 via an arbitrary network. It is also possible to download all or part of it if necessary.

  In addition, a program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the “recording medium” refers to a memory card, USB (Universal Serial Bus) memory, SD (Secure Digital) card, flexible disk, magneto-optical disk, ROM, EPROM (Erasable Programmable Read Only Memory), EEPROM (registration). Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk, etc.), DVD (Digital Digital, Trademark) Any "portable physical medium" It is intended to include. Therefore, a recording medium storing a program for executing processing as described in this specification also constitutes the present invention.

  The “program” is a data processing method described in an arbitrary language or description method, and may be in any form such as source code or binary code. Note that the “program” is not necessarily limited to a single configuration, and functions are achieved in cooperation with a separate configuration such as a plurality of modules and libraries or a separate program represented by the OS. Including things. In addition, a well-known structure and procedure can be used about the specific structure and reading procedure for reading a recording medium in each apparatus shown to embodiment, the installation procedure after reading, etc.

  Various databases and the like stored in the storage unit 106 are storage means such as a memory device such as a RAM and a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk. Programs, tables, databases, web page files, and the like.

  Further, the production plan automatic planning apparatus 100 may be configured as an information processing apparatus such as a known personal computer or workstation, or may be configured as the information processing apparatus to which an arbitrary peripheral device is connected. Further, the production plan automatic planning apparatus 100 may be realized by mounting software (including a program or data) for realizing the processing described in the present embodiment in the apparatus.

  Furthermore, the specific form of distribution / integration of the devices is not limited to that shown in the figure, and all or a part of them may be functionally or physically in arbitrary units according to various additions or according to functional loads. It can be configured to be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and may be selectively implemented.

  The present invention is particularly useful in production management in the manufacturing industry, and is also useful in inventory management and sales management in any industry.

DESCRIPTION OF SYMBOLS 100 Production plan automatic planning apparatus 102 Control part 102a Daily processing part 102b Planning part 104 Communication interface part 106 Storage part 106a Daily stock plan master 106b Arrangement condition master 106c Item master 106d CSV data master 106e Order received data master 106f Indication data master 106g Inventory Data master 106h Plan data master 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (7)

In the production plan automatic planning device equipped with a control unit for planning the number of products to be produced,
The controller is
Using the end-of-period safety stock quantity data relating to the planned inventory quantity at the end of the first period, which is determined in consideration of the demand forecast for the product, it is included in the first period and is more than the first period. Creating means for creating a plurality of short cycle reference safety stock quantity data relating to the number of inventory plans in the relatively short second cycle;
Using the increase / decrease data related to the increase / decrease in the product in the first cycle, the increase / decrease in the product corresponding to the increase / decrease number data is added to each of the planned inventory numbers corresponding to the plurality of short cycle reference safety inventory number data. Updating means for updating the short cycle reference safety stock quantity data created by the creating means by allocating minutes;
The planned number of products to be produced in the second cycle by using the short cycle reference safety stock data obtained by the updating means and the allocation number data relating to the number of products to be allocated in the first cycle A production plan automatic planning apparatus comprising: a determination means for determining The controller is
A calculating means for calculating, using the number of days belonging to the first period, an allocation of the increase / decrease of the product to be allocated to each of the inventory plan numbers corresponding to the plurality of short cycle reference safety inventory number data The production planning automatic planning apparatus according to claim 1, comprising: The number of days belonging to the first cycle is the number of working days on which the product can be produced,
The calculating means includes
Each of the working days includes coefficient setting means for setting a coefficient according to the order in the first cycle of the working day, and
For the working day corresponding to the coefficient set by the coefficient setting means, the value obtained by dividing the increase / decrease of the product by the number of working days is multiplied by the coefficient set for the working day as the allocated amount. 3. The production planning automatic planning apparatus according to claim 2, wherein a value is used. The first period is a period in units of months, and
The second cycle is a period in days.
The controller is
Including a reference date setting means for setting a reference date for an application period to be planned for the number of plans for producing the product, and
The creating means includes
Using the end-of-period safety stock quantity data relating to the inventory plan quantity at the end of the month following the month including the base date set by the base date setting means, the short cycle reference safety stock quantity data is created for each day belonging to the next month The production plan automatic planning apparatus according to any one of claims 1 to 3, wherein The control means includes
The production plan automatic planning apparatus according to any one of claims 1 to 4, further comprising a summarizing unit that performs summarization processing on the planned number of products of a plurality of types determined by the determining unit. A production plan automatic planning method for planning the number of plans to produce a product, which is executed in a production plan automatic planning apparatus having a control unit,
Executed in the control unit,
Using the end-of-period safety stock quantity data relating to the planned inventory quantity at the end of the first period, which is determined in consideration of the demand forecast for the product, it is included in the first period and is more than the first period. A creation step for creating a plurality of short cycle-based safety stock quantity data related to the number of inventory plans in a relatively short second cycle;
Using the increase / decrease data related to the increase / decrease in the product in the first cycle, the increase / decrease in the product corresponding to the increase / decrease number data is added to each of the planned inventory numbers corresponding to the plurality of short cycle reference safety inventory number data. An update step of updating the short cycle reference safety stock number data created in the creation step by assigning minutes;
The planned number of products to be produced in the second cycle by using the short cycle reference safety stock data obtained in the updating step and the allocation data regarding the number of products allocated in the first cycle. And a determination step for determining the production plan. A production plan automatic planning program for planning the number of products to be produced for execution in a production plan automatic planning device having a control unit,
For executing in the control unit,
Using the end-of-period safety stock quantity data relating to the planned inventory quantity at the end of the first period, which is determined in consideration of the demand forecast for the product, it is included in the first period and is more than the first period. A creation step for creating a plurality of short cycle-based safety stock quantity data related to the number of inventory plans in a relatively short second cycle;
Using the increase / decrease data related to the increase / decrease in the product in the first cycle, the increase / decrease in the product corresponding to the increase / decrease number data is added to each of the planned inventory numbers corresponding to the plurality of short cycle reference safety inventory number data. An update step of updating the short cycle reference safety stock number data created in the creation step by assigning minutes;
The planned number of products to be produced in the second cycle by using the short cycle reference safety stock data obtained in the updating step and the allocation data regarding the number of products allocated in the first cycle. A production planning automatic planning program comprising: a decision step for determining the production plan.

Images