JP2000040110A - Shipping and production management system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To allocate stock in the order of received orders and to allocate the stock successively from the order of an early delivery date. SOLUTION: This system is composed of a shipping management device 1 and a production instruction device. In this case, the production instruction device is provided with a preceding order extraction means 23 for extracting a preceding order whose delivery date is in a production instruction object period stored in a production instruction object period master 21 based on the information of the preceding order obtained from the shipping management device 1, an effective stock amount calculation means 24 for calculating an effective stock amount for each item number by subtracting an order amount for which an allocation processing is performed and an extracted preceding order amount from a stock amount included in stock information obtained from the shipping management device 1 and a production instruction preparation means 25 for comparing the calculated effective stock amount with an ordering point stock amount stored in a stock reference value file 22 for each item number and preparing a production instruction for producing an ordering amount set beforehand in the case that the effective stock amount is lower than the ordering point stock amount.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a system for managing the shipment and production of products that employ a prospective production system.

[0002]

2. Description of the Related Art The conventional prospective production system is a shipping management system in which products that have been produced in advance are kept in stock, and when an order is received, products are shipped from the stock. In this case, when all orders are required to be delivered immediately, that is, when delivery is required as soon as possible, inventory is allocated in the order of the orders received, and shipment is performed sequentially.

On the other hand, when arranging inventory, the actual inventory is deducted from the order confirmation information, and when the inventory amount falls below a preset order point, an order point management such as arranging a preset order amount is performed. There is a method.

[0004]

By the way, from the viewpoint of shipping management, there is a demand for carrying out inventory allocation in the order of orders received and shipping the products. There is a request that we want to allocate inventory and ship it.

[0005] However, in the conventional prospective production system described above, if the delivery dates of the ordered orders are different, if the inventory is reserved in the order of the received orders, the order with the late delivery date will be reserved first depending on the situation of the orders. For this reason, there is a problem that a stock-out occurs at the time of inventory allocation for an order received early and for which delivery date is early. Conversely, if inventory is allocated in the order of early delivery, inventory with late delivery will not be allocated until just before the delivery date. There was a problem of doing it.

SUMMARY OF THE INVENTION The present invention has been made to solve the above-mentioned problems. The purpose of the present invention is to meet the demands for carrying out inventory allocation and shipping in the order of orders received and, if possible, to have a short delivery time (nearly). It is an object of the present invention to provide a shipping and production management system that can satisfy conflicting demands for carrying out inventory allocation in order and shipping.

[0007]

In order to solve the above-mentioned problems, a shipping and production management system according to the present invention comprises: a stock file for storing stock information of a shipping warehouse; an order file for storing received order information; A shipping management device that has a parameter file that stores the period and performs inventory allocation processing for orders that fall within the allocation target period, and acquires inventory information, order information, and allocation target period information from this shipping management device, and allocates A production instruction device for creating a production instruction of a preceding order which is not included in the target period, wherein the production instruction device includes a production instruction target period master storing a production instruction target period for each product number, and An inventory reference value file storing the ordering point inventory amount indicating the inventory amount of the warehouse for each product number, and the information of the preceding order acquired from the shipping management device. And prior order extraction means based extracts a preceding order delivery time is in the production instruction period stored in said production instruction period master,
From the stock amount included in the stock information acquired from the shipping management device, subtract the order amount subjected to the allocation process and the preceding order amount extracted by the preceding order extracting means,
Means for calculating the effective stock amount for each part number; comparing the calculated available stock amount with the ordering point stock amount stored in the stock reference value file for each part number; A production instruction creating means for creating a production instruction for producing a preset order quantity when the point inventory quantity falls below a predetermined value.

That is, the present invention is characterized in that inventory allocation processing for delivery by the shipping management device and inventory allocation processing for production instructions by the production instruction device are performed separately. Inventory allocation processing is performed by the shipping management device for orders, and inventory allocation processing for production instructions is performed by the production instruction device for advanced orders, so stock is out of stock even if immediate orders and advanced orders are mixed in the orders received. This is a system that does not have to worry.

[0009]

Embodiments of the present invention will be described below with reference to the drawings.

FIG. 1 is a block diagram showing the overall configuration of a shipping and production management system according to the present invention.

This shipping and production management system can be roughly classified into a shipping management apparatus 1 for performing inventory allocation processing for an order included in an allocation target period, and inventory information, order information, and allocation target period from the shipping management apparatus 1. Get the information,
And a production instruction device 2 that creates a production instruction for a preceding order that has not yet entered the allocation target period.

The shipping management apparatus 1 includes a stock file 11 for storing stock information of a storage warehouse (not shown), an order file 12 for storing received order information, and a parameter file 13 for storing a period to be allocated. Shipment result data (that is, receipt result data) from a management device that manages a factory shipment process is input.

As shown in FIG. 2A, the inventory file 11 includes items such as a product number, an inventory quantity, and an allocated quantity. The inventory quantity field contains the current inventory quantity including the assigned order. The stored and allocated quantity field stores the quantity allocated to the order among the stock quantities.

The order file 12 includes, as shown in FIG. 2B, items of an order number, a product number, a quantity, a delivery date, an allocation processing flag, and an allocation result. The allocation processing flag indicates whether or not inventory allocation processing has been performed. This is a flag for identifying whether or not the stock allocation processing result is stored in the allocation result.

The parameter file 13 stores allocation target periods as shown in FIG. 2 (c). here,
In the present embodiment, the allocation target period is set to an average value (average number of days) of days required from shipment to delivery to a customer. However, this average number of days is slightly extra (1 to 2 days).
Day) may be set as the allocation target period.

The production instruction device 2 includes a production instruction target period master 21 storing a production instruction target period for each product number, and an order point inventory amount indicating the inventory amount of the shipping warehouse at the time of production order. Prior order extracting means 23 for extracting a preceding order whose delivery date falls within the production instruction target period stored in the production instruction target period master 21 based on the value file 22 and the information on the advance order acquired from the shipping management device 1. Then, the available stock amount for each product number is obtained by subtracting the allocated order amount and the preceding order amount extracted by the preceding order extracting means 23 from the stock amount included in the stock information acquired from the shipping management device 1. The available stock quantity calculating means 24 to be calculated is compared with the calculated available stock quantity and the stock quantity at the order point stored in the stock reference value file 22 for each product number. When the quantity is less than the stock quantity at the order point, a production instruction creating means 25 for creating a production instruction for producing a preset order quantity, and a production instruction file 26 for storing the created production instruction are provided. ing.

The production instruction target period master 21 is shown in FIG.
As shown in (a), each item includes a product number and production instruction target days (production instruction target period). In this embodiment, the number of production instruction target days is set to the average value (average number of days) required for each product number from the time the standard order quantity of the product number is issued to the production instruction until the product can be shipped. ing. However, the number of days with some margin (1 to 2 days) may be set as the number of production instruction target days.

As shown in FIG. 3B, the stock reference value file 22 includes items such as a product number, an order point, and an order quantity.
Here, the ordering point is the stock amount of the shipping warehouse (ordering point stock amount) which is a reference for causing the ordering action.

The production instruction file 26 includes items such as a product number, a quantity, and a delivery date, as shown in FIG.

Next, the operation of the shipping management apparatus in the shipping and production management system having the above configuration will be described with reference to the flowchart shown in FIG.

The shipping management apparatus performs the following processing when receiving an order. That is, the delivery date of the received order is checked (step S1), and it is confirmed whether or not it is within the allocation target period (for example, three days from today) (step S2). As a result of the confirmation, if the period is not within the allocation target period (No in step S2), the order file 1
The allocation process flag of No. 2 (see FIG. 2A) is set to “not allocated” (step S7), and the process ends.

On the other hand, as a result of the confirmation in step S2, if the period is within the allocation target period (Yes in step S2), it is confirmed whether there is stock in the storage warehouse (step S3). Whether or not stock is present is determined based on whether "(stock quantity-allocated quantity-order quantity)>0". That is, it is determined whether or not the stock can be allocated.
Then, if the inventory allocation processing is possible, the inventory allocation processing is performed (step S4), and the allocated quantity (see FIG. 2A) of the inventory file 11 is calculated by (allocated quantity + order quantity). To set the allocation processing flag (see FIG. 2 (b)) of the order file 12 to "allocation processing completed" and update the allocation result to "allocation completed" (step S5).

On the other hand, if it is determined in step S3 that inventory allocation processing is not possible (step S3
In the case of No, the allocated quantity of the inventory file 11 is updated by (allocated quantity + order quantity), the allocation processing flag of the order file 12 is set to “not allocated”, and the allocation result cannot be allocated. (Step S
6). In this case, the allocation process is performed again when the stocking result is counted and the stock increases, or when the order is canceled and the stock increases.

Next, the operation of the production instruction device will be described with reference to FIG.
This will be described with reference to the flowchart shown in FIG.

The production instruction device 2 obtains the above-mentioned stock information (information of the stock file 11), order information (information of the order file 12), and allocation target period information (information of the parameter file 13) from the shipping management device 1. I do.

Then, based on the acquired order information, the advance order extracting means 23 determines that the delivery date does not fall within the allocation target period, but falls within the production instruction target period for each product number stored in the production instruction target period master 21. Extract all contained orders (preceding orders) (step S1)
1). Here, the allocation target period T1 and the production instruction target period T
FIG. 6 shows the relationship with 2. That is, assuming that the allocation target period T1 is, for example, three days and the production instruction target period T2 of a certain product number A is, for example, seven days, the preceding order whose delivery date falls within the production instruction target period T2 is four days from today. After 10 days (3 days +7 days)
The order of the part number A set within the day).

Therefore, the extraction processing in step S11
It looks like this: That is, of the unshipped orders, the orders for which inventory allocation has not been performed by the shipping management device 1 (confirmed by the allocation processing flag of the order file 12) are extracted, and the delivery date is set for each product number in the orders. The order that satisfies the condition of the present production instruction target period T2 [that is, the order that satisfies the condition of (today's date + allocation target period <delivery date ≤ today's date + allocation target period + production instruction target period])

The effective stock quantity calculating means 24 subtracts the order quantity subjected to the allocation processing and the preceding order quantity extracted by the preceding order extracting means 23 from the stock information (stock quantity) acquired from the shipping management apparatus 1. Then, the effective stock amount for each product number is calculated by the following equation (1) (step S1).
2).

Effective stock quantity = Stock quantity−Allocated quantity−Total quantity of preceding order = Available stock quantity−Total quantity of preceding order (1) The production instruction creating means 25 calculates in this way. The available stock amount is compared with the reordering stock amount stored in the stock reference value file 22 for each product number (step S1).
3). If the effective stock quantity is less than the order point stock quantity, a production instruction for producing a preset order quantity of the corresponding part number is created (step S14) and stored in the production instruction file 26 (step S15). ). In addition, in the determination in step S13, if the available stock exceeds the ordering stock, no production instruction is created. When the production instruction creating means 25 performs the processing of steps S13 to S15 for all the part numbers included in the extracted preceding order (step S15), the processing ends.

By such a process, by the time the preceding order enters the allocation target period T1, the production of the ordered quantity is completed for the part numbers (part numbers below the ordering point) that may be out of stock. Therefore, even if the preceding order enters the allocation target period T1 and the shipping management apparatus 1 actually performs the inventory allocation processing, the situation that the inventory runs out does not occur.

FIG. 7 is a graph showing a change in the stock quantity of a certain product number A and the timing of the production instruction due to the above-described processing operation of the production instruction device 2.

[0032] The order of the ordered part number A is the allocation target period T.
If the number is 1, the allocation process of the inventory is performed, so that the available inventory volume of the product number A (the inventory volume—the cumulative total of the order volume in the allocation target period) gradually decreases (reference numeral 51). ). On the other hand, when it is determined that the reservable stock quantity is less than the ordering point as a result of performing the allocation of the preceding order that is not in the allocation target period T1 but is in the production instruction target period T2 (indicated by reference numeral 52). Then, at the time of this determination, a production instruction of a preset order quantity (that is, an amount reaching the replenishment point of the part number A) L is created. As a result, for product number A,
When the preceding order enters the allocation target period T1 and the allocation process is actually performed, it means that sufficient inventory replenishment has already been performed.

As described above, according to the present invention, the inventory allocation process for delivery by the shipping management device and the inventory allocation process for production instruction by the production instruction device are separated. By using the production ordering device to perform inventory reservation processing for production orders using the production ordering device, the inventory ordering process can be performed so that there is no fear of running out of stock even if both the immediate delivery order and the advance order are mixed in the order received. It can be managed.

[0034]

The shipping and production management system of the present invention
The production instruction device includes a shipment management device and a production instruction device, and the production instruction device has a delivery date included in the production instruction target period stored in the production instruction target period master based on the information of the preceding order obtained from the shipment management device. The preceding order extracting means for extracting the order and the stock quantity included in the stock information acquired from the shipping management device, subtract the order quantity subjected to the allocation processing and the preceding order quantity extracted by the preceding order extracting means, and ATP calculation means for calculating the ATP for each product, and the calculated ATP and the reorder quantity stored in the stock reference value file are compared for each part number. When the quantity is less than the quantity, a production instruction creating means for creating a production instruction for producing a preset order quantity is provided. That is, the inventory allocation process for delivery by the shipping management device and the inventory allocation process for production instructions by the production instruction device are separated, and the inventory allocation process is performed by the shipping management device for immediate delivery orders, and for the preceding orders. The production instruction device performs inventory allocation processing for production instructions. As a result, even if the immediate delivery order and the advance order are mixed in the order, the production instruction for the advance order is issued in advance by the production instruction device, so that the inventory can be reliably replenished by the delivery date. Out of stock of the order can be reliably prevented.

[Brief description of the drawings]

FIG. 1 is a block diagram showing an overall configuration of a shipping and production management system of the present invention.

FIG. 2A is a data configuration diagram of an inventory file, and FIG.
Is a data configuration diagram of an order file, and (c) is a data configuration diagram of a parameter file.

3A is a data configuration diagram of a production instruction target period master, FIG. 3B is a data configuration diagram of an inventory reference value file,
(C) is a data configuration diagram of a production instruction file.

FIG. 4 is a flowchart for explaining the operation of the shipping management device in the shipping and production management system of the present invention.

FIG. 5 is a flowchart for explaining the operation of the production instruction device in the shipping and production management system of the present invention.

FIG. 6 is an explanatory diagram showing a relationship between an allocation target period and a production instruction target period.

FIG. 7 is a graph showing a change in the stock amount of a certain product number and a timing of a production instruction by a processing operation of the production instruction device.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Shipment management apparatus 2 Production instruction apparatus 11 Inventory file 12 Order file 13 Parameter file 21 Production instruction target period master 22 Inventory reference value file 23 Advance order extraction means 24 Effective stock quantity calculation means 25 Production instruction creation means 26 Production instruction file

Claims (1)

[Claims] 1. An inventory file for storing inventory information of a shipping warehouse, an order file for storing received order information,
And a parameter file storing the allocation target period, and a shipment management device that performs inventory allocation processing for orders included in the allocation target period, and obtains inventory information, order information, and allocation target period information from the shipment management device. A production instruction device that creates a production instruction for a preceding order that has not yet entered the allocation target period. The production instruction device includes a production instruction target period master storing the production instruction target period for each product number, and a production order Based on the stock reference value file storing the stock quantity of the reorder point indicating the stock quantity of the shipping warehouse for each product number, and the information of the preceding order obtained from the shipping management device, the delivery date is stored in the production instruction target period master. Preceding order extracting means for extracting the preceding order included in the production instruction target period, and the inventory information acquired from the shipping management device. From inventory amount, minus the leading order value extracted by the order quantity subjected to processing for allocating a said preceding order extraction means,
Means for calculating the effective stock amount for each product number; comparing the calculated available stock amount with the reordering stock amount stored in the stock reference value file for each product number; A shipping and production management system, comprising: a production instruction creating means for creating a production instruction for producing a preset order quantity when the point inventory quantity falls below a predetermined quantity.