JP4451139B2 - Picking work amount management system, picking work amount management method, and picking work amount management program - Google Patents

Description

  The present invention relates to a picking work amount management system, a picking work amount management method, and a picking work amount management program, and in particular, manages a series of operations from storage / picking / conveyance / assortment / shipping in a distribution center to It relates to a system that stabilizes the quantity.

  In a conventional distribution center, a series of shipping operations from picking up products to arranging loads is performed at the timing when product sorting information for each delivery destination is obtained based on the shipping order (product order information) on a specific day. It has been done every time.

  With regard to shipping operations, for example, a package management method using a package management server that manages package delivery, a collection information input stage in which information on the collected packages is input to the package management server, and the package A management server generates package information by delivery destination for generating package information by delivery destination in which the collection information is collected for each delivery destination, and when the package is delivered to the delivery destination of the package, the package by delivery destination There has been proposed a package management method (see Patent Document 1) including an inspection result input stage in which an inspection result inspected based on information is input to the package management server.

Also, a distribution system for distributing products between a business partner, a distribution center, and a store floor, wherein the business partner is based on order information of the product, at least the product name, quantity, Recording medium issuing means for issuing a recording medium on which product information including a temperature zone and a delivery destination is recorded for each shipping form, and attaching the recording medium issued by the recording medium issuing means for each shipping form Shipped to the center, the distribution center, the product information reading means for reading the product information of the recording medium attached to the product received from the supplier, and among the product information read by the product information reading means, A wireless tag that sorts products by temperature zone, reloads the sorted products into individual transport containers, and issues wireless tags that record product information in the transport containers A wireless tag issued by the wireless tag issuing means is attached to a transport container and shipped to the store, and the store reads the product information of the wireless tag of the transport container received from the distribution center. There has also been proposed a logistics system (Patent Document 2) that includes tag reading means and manages products received based on the product information read by the wireless tag reading means.
JP 2003-292164 A JP 2003-118842 A

  However, in the conventional method, only the picking work or the like is performed according to the instruction of the picking work whose shipping date corresponding to the shipping order is scheduled to be executed. Therefore, for example, if there is a vacancy in the working hours of a picking worker with respect to the total shipment amount of a day (or a predetermined period) that fluctuates from day to day, the worker must be in a standby state to effectively use human resources. I couldn't. On the other hand, if an excessive work load is applied to the picking worker and the predetermined processing target cannot be achieved, the worker is overworked or increased, resulting in an increase in personnel costs. SUMMARY OF THE INVENTION Accordingly, an object of the present invention is to provide a picking work amount management system, a picking work amount management method, and a picking work amount management program that can reliably correspond to a shipping order and level the picking work amount.

The picking work amount management system of the present invention that solves the above problems is a system for managing the picking work amount in a distribution center, and is a picking instruction database that stores picking instruction records including information on picking products and quantities based on shipping orders. A master database that stores the unit picking work time for each product to be picked, a time management database that stores the working status of the picking worker, and a corresponding picking instruction record and shipment for the shipment corresponding to the shipment order From the shipping product database that stores the shipping status including information on the date and picking date, and the attendance management database, the number of workers and the operating time of the workers at the target time of picking work volume management are extracted, and the work at the target time OK A workable time calculation unit to calculate the time to search the picking instruction records of scheduled shipping amount in the subject period on which eliminated the additional picking operation content that has already been picked before the target time at the shipment database, the A picking work time calculating unit that calculates the picking work time by multiplying the quantity of picking products included in the picking instruction record extracted from the picking instruction database by the unit picking work time of the corresponding picking product in the master database, and the work possible If the available work time is large by comparing the time with the picking work time, the picking instruction record for the scheduled shipment after the target time is searched as an additional picking instruction record in the shipping product database, and the picking instruction data base is searched. An additional picking work time calculating unit that calculates the additional picking work time by multiplying the quantity of picking products included in the additional picking instruction record extracted from the product by the unit picking work time of the corresponding picking product in the master database, and the work It is determined whether or not the total time of the picking work time and the additional picking work time falls within the possible time, and if it is determined that it falls within, the picking time of the additional picking instruction record in the shipping product database is set as the target time A time update unit for performing the update process, and an output unit for outputting the content of the update process to an output interface.

The picking work amount management method of the present invention includes a picking instruction database that stores picking instruction records including picking goods and quantity information based on a shipping order, and a master that stores a unit picking work time for each article to be picked. A database, a time management database that stores the work status of picking workers, and a shipment database that stores the shipment status including information on the corresponding picking instruction record, shipment date, and picking date for shipments corresponding to shipment orders The computer system that manages the picking work amount in the distribution center extracts the number of workers and the working time at the target time of picking work amount management from the attendance management database, and can work at the target time Calculated between the search the picking instruction records of scheduled shipping amount in the subject period in shipment database on which eliminated the additional picking operation content that has already been picked before the target time, and extracted from the picking instruction database The number of picking products included in the picking instruction record is multiplied by the unit picking work time of the picking product in the master database to calculate the picking work time, and the workable time and the picking work time are compared to allow work. When the time is large, the picking instruction record for the planned shipment after the target time is searched as an additional picking instruction record in the shipping product database, and the additional picking instruction record extracted from the picking instruction database is included. The additional picking work time is calculated by multiplying the quantity of picking products by the unit picking work time of the corresponding picking product in the master database, and the total time of the picking work time and the additional picking work time is calculated as the available work time. If it is determined whether or not it fits, update processing is performed with the picking time of the additional picking instruction record as the target time in the shipping product database, and the contents of the update processing are output to the output interface It is characterized by that.

The picking work amount management program of the present invention includes a picking instruction database for storing picking instruction records including picking goods based on a shipping order and quantity information, and a master for storing a unit picking work time for each article to be picked. A database, a time management database that stores the work status of picking workers, and a shipment database that stores the shipment status including information on the corresponding picking instruction record, shipment date, and picking date for shipments corresponding to shipment orders And a computer system that manages the amount of picking work at the distribution center, and extracts the number of workers and the working time at the target time of picking work amount management from the attendance management database. Possible time step to calculate the searches the picking instruction records of scheduled shipping amount in the subject period on which eliminated the additional picking operation content that has already been picked before the target time at the shipment database, the picking instruction database The step of calculating the picking work time by multiplying the quantity of picking products included in the picking instruction record extracted by the unit picking work time of the picking product in the master database, and the workable time and the picking work time. If the available work time is long, a picking instruction record for the planned shipment after the target time is searched as an additional picking instruction record in the shipping product database, and the additional information extracted from the picking instruction database is searched. Multiplying the quantity of picking products included in the picking instruction record by the unit picking work time of the corresponding picking product in the master database to calculate an additional picking work time, and adding the picking work time and the additional picking to the workable time It is determined whether or not the total time with the work time is within the range, and when it is determined that the total time is within, the update processing with the picking time of the additional picking instruction record as the target time in the shipping product database, and the update processing And a step of outputting the contents to the output interface.

  In addition, the problems disclosed by the present application and the solutions thereof will be clarified by the embodiments of the present invention and the drawings.

  According to the present invention, it is possible to reliably cope with a shipping order and level the picking work amount.

  Embodiments of the present invention will be described below in detail with reference to the drawings. FIG. 1 is a network configuration diagram including a picking work amount management system 100 (hereinafter, system 100) in the present embodiment, and FIG. 2 is a system configuration diagram and a schematic diagram of a distribution center in the present embodiment.

  In the present embodiment, it is assumed that the picking work amount management system 100 is included in the entire system 10 provided in the physical distribution facility where the picking work is performed. The system 10 is formed by connecting and controlling various devices via a network 120 around a WMS server 101 operating integrally with the system 100 of the present invention.

  For example, an example in which the system 100 is incorporated in the WMS server 101 as described above can be assumed, or the host computer 110 is located between the host computer 110 that receives a shipping order from a delivery destination and the WMS server 101. There is also an example in which a shipment order is acquired from the server, the workload management according to the picking workload management method of the present invention is executed, and the execution results (eg, shipping schedule information, picking work list, etc.) are provided to the WMS server 101. Can be assumed.

  The WMS server 101 includes an automatic warehouse (not shown) for storing commodities, a DPS (Digital Picking System) device 130 such as a barcode reader and a lamp display device, a conveyor line 140, a simple automatic inspection device 145, and a simple automatic While monitoring the operation status of devices related to picking work such as a barcode reader 146 (BCR in the figure: BCR) attached to the inspection device 145 or a DAS150 (Digital Asort System) including a secondary sorting control device and an assortment control device, A control command is issued to the control device 103 or the like composed of a control circuit and a control mechanism of each device to be monitored, and the operation state thereof is controlled.

  Also, the information processing result of the user is output through the printer 104. Further, a label on which the content of the shipping request is printed or a label on which the stored item attribute for each container to be stored in the automatic warehouse is printed can be output through the barcode label printer 105. The WMS server 101 includes a WMS terminal 102 (for receiving user instructions).

  In addition, an access point 160 installed at the site of picking work is connected to the system 10 in the distribution center. The picking operator reads the bar code label attached to the folding container for picking work using the handy terminal 165 or inputs information such as a picking result. The information held by the handy terminal 165 is sent to the network 120 through the access point 160, and the WMS server 101 acquires it for picking status management.

  In such a system 10, the system 100 of the present invention stores a program 50 that realizes the function of the picking work amount management system of the present invention in the memory 51, and appropriately reads and executes it by the arithmetic device 30.

  Note that the system 100 is not limited to the example of providing the picking work amount management information to the WMS server 101, but also the control device 103, the DAS device 150, and the like via the network 120, the direct dedicated path 121, and the like. Information may be provided directly. In this case, the system 100 can adopt not only the form arranged between the host computer 110 and the WMS server 101 but also the form arranged on the network between the WMS server 101 and the control device 103, for example. .

  Further, the system 100 may include the following components as the program 50. The system 100 includes a picking instruction database 84 that stores picking instruction records including information on picking products and quantities based on a shipping order, a master database 82 that stores unit picking work time for each product to be picked, and picking. An attendance management database 81 for storing the work status of workers and a shipment product database 83 for storing a shipment status including information on a corresponding picking instruction record, shipment date and picking date for a shipment corresponding to the shipment order. Shall be provided. The data structure of each database will be described later.

  The system 100 extracts from the attendance management database 81 the number of working workers and working hours at the target time of picking work amount management, and calculates the workable time calculating unit 52 (FIG. 2) for calculating the workable time at the target time. Medium: Displayed as possible time part). Further, a picking instruction record for the scheduled shipment at the target time is searched in the shipping product database 83, and the picking product quantity included in the picking instruction record extracted from the picking instruction database 84 corresponds to the corresponding picking in the master database 82. A picking work time calculation unit 53 (in FIG. 2, indicated as a work time part) that calculates the picking work time by multiplying the unit picking work time of the product is provided. When the picking operation time calculation unit 53 searches the shipment product database 83 for a picking instruction record for the planned shipment at the target time, the picking work time calculation unit 53 excludes additional picking work already picked before the target time. And can.

  The system 100 also compares the workable time with the picking work time. If the workable time is large, the picking instruction record for the planned shipment after the target time in the shipping product database 83 is used as an additional picking instruction record. Additional picking that calculates the additional picking work time by searching and multiplying the quantity of picking products included in the additional picking instruction record extracted from the picking instruction database 84 by the unit picking work time of the picking product in the master database 82 An operation time calculation unit 54 (in FIG. 2, indicated as an additional time unit) is provided. When the additional picking work time calculation unit 54 searches the shipment product database 83 for picking instruction records for the shipment scheduled after the target time as additional picking instruction records, the picking work time is calculated after the target time. A predetermined time that exceeds the possible time or approximates within a predetermined range is specified, and a picking instruction record for a shipping schedule included in the predetermined time can be searched as an additional picking instruction record.

  Further, it is determined whether or not the total time of the picking work time and the additional picking work time falls within the workable time. If it is determined that the time is within the pickable work time, the picking time of the additional picking instruction record in the shipping product database 83 is determined. Is provided with a time update unit 55 for performing update processing with the target time as the target time.

  Further, an output unit 56 for outputting the contents of the update process to the output interface is provided. The output unit 56 functions as an input / output interface for the system 100 to connect to an external device such as the WMS server 101 via a network 120 such as a LAN or the Internet to exchange data or to input / output data. It can be.

  Such a system 100 further includes a storage device 80. FIG. 3 is a diagram showing an example of (a) the attendance management database 81 and (b) the master database 82 in the present embodiment. In the present embodiment, the attendance management database 81 is a database that stores a work situation of a picking worker. This database, for example, uses the shipping date (working day) as a key and the employee number. In this structure, a record is stored for each staff member associated with information such as actual work hours, work start time, and work end time.

  The master database 82 is a database that stores a unit picking work time for each product to be picked. This database has a structure in which, for example, a record for each product associated with information such as a product name and a unit work time (minute / piece) is stored using a product ID as a key.

  FIG. 4 is a diagram showing an example of (a) a shipment product database 83 and (b) a picking instruction database 84 in the present embodiment. The shipment product database 83 in the present embodiment is a database that stores a shipment status including information on a picking instruction record, a shipment date, and a picking date for a shipment corresponding to a shipment order. This database is, for example, shipping no. As a key, shipping date, picking statement No. It has a structure storing a record in which information such as (ID of picking instruction record), picking date, and shipping destination is associated.

  The picking instruction database 84 is a database that stores picking instruction records including information on picking products and quantities based on shipping orders. This database is, for example, a picking specification No. As a key, a record in which information such as a product name and picking quantity is associated is stored.

  Next, as an execution background of the picking work amount management method according to the present embodiment, an outline of an example of the shipping work from the start of the shipping instruction and the start of the shipping work to the packaging in accordance with FIG. 2 will be described. Keep it. The distribution center is composed of a system 100 and a distribution apparatus 2 as shown in FIG. The data constituted by the shipment data in the shipment product database 83, the picking data in the picking instruction database 84, and the like are data that serve as a basis for determining the picking date and whether to ship or temporarily store. It is created by the arithmetic unit 30.

  Based on the information, each physical distribution facility causes the shipping box to flow from the storage warehouse 25 to the picking yard 21 by means of conveyance, or the product configured by the picking yard 21 to flow to the shipping yard 23 or the pseudo-shipped product storage warehouse 24. To do. In the present embodiment, the pseudo-shipped product storage warehouse 24 is used for storing products picked in advance based on additional picking instruction records for shipping scheduled after the shipping date (target time) until the actual shipping date. It is a warehouse. It should be noted that the means for transporting goods and the like are not particularly limited, such as conveyor transport, cart transport, and personal transport.

  The picked product is replenished from the storage warehouse 25 to the picking yard 21 as needed. The “pseudo-shipped product” refers to a semi-finished product that has been picked in advance before the shipment date and immediately before the packing, up to the shipment date entered in the record of the shipment product database 83 in FIG. These are stored in the pseudo shipment storage warehouse 24. The shipping box has a shipping No. shown in FIG. And picking specification No. And are sequentially delivered from the storage warehouse 25 on the date of shipment.

  It should be noted that each of the components 52 to 56 described so far may be realized as a program stored in an appropriate storage device such as the memory 51 or the storage device 80 as described above, or realized as hardware in the system 100. Also good.

  Moreover, although the system 100 in this embodiment assumed the example with which the memory | storage device 80 and each structure part 52-56 were all equipped in the system 100, it is not limited to this form. For example, a part or combination of the configuration units, or any one or combination of the databases 81 to 84 is arranged in a separate device on the network, and an appropriate management server or the arithmetic device 30 performs operation management of the configuration units. Thus, an example of realizing the present invention can be assumed.

  In addition to the LAN and the Internet, various networks such as a dedicated line, a WAN (Wide Area Network), a power line network, a wireless network, a public line network, and a mobile phone network can be adopted as the network 120. Further, if a virtual private network technology such as VPN is used, communication with improved security is established when the Internet is adopted. Alternatively, when each functional unit is arranged in the same system 100, the bus wiring in the system 100 can be assumed as a network.

  Next, an actual procedure of the picking work amount management method of the present embodiment will be described with reference to the drawings. FIG. 5 is a flowchart showing an actual procedure of the picking work amount management method in the present embodiment, and FIG. 6 is a conceptual diagram of pseudo shipment in the present embodiment. Various operations corresponding to the picking work amount management method described below are realized by a program provided in the storage unit such as the memory 51 and the storage device 80 in the system 100 to realize the functions of the respective components 52 to 56. Is done. And this program is comprised from the code | cord | chord for performing various operation | movement demonstrated below, and mounts the function of each part of the said structure.

  The system 100 according to the present embodiment generates picking instruction information such as a picking work list before starting the work on the day of picking work, and notifies the WMS server 101 or the control device 103 of the information. For this purpose, as an example, the arithmetic unit 30 of the system 100 sets the calculation date (target time for picking work amount management) of the picking work amount management program in this embodiment (sl000).

  Then, data associated with the calculation date in each of the attendance management database 81, the master database 82, the shipping product database 83, and the picking instruction database 84 is read into the memory 51 (s1001). The calculation device 30 calculates the workable time on the calculation date based on the number of workers and the operation time on the calculation date (target time for picking work amount management) extracted from the attendance management database 81 (s1002). ). Specifically, Σ [(number of working personnel) × (number of working hours)]) is calculated as the workable time.

  Further, regarding the picking instruction record for the scheduled shipment date on the calculation date searched from the shipping product database 83, the picking product in the master database 82 is included in the quantity of the picking product included in the picking instruction record extracted from the picking instruction database 84. The picking work time is calculated by multiplying the unit picking work time (S1030).

  It should be noted that, when searching for the picking instruction record for the scheduled shipment date on the calculation date in the shipping product database 83, the pseudo-shipped portion (for urgent picking work) already picked before the target time is excluded.

  Then, the workable time and the picking work time are compared (s1004), and if the workable time is small (s1004: YES), it is determined that the work capacity of the distribution center on the calculation date has already been exceeded, and the calculation date is set. For example, the next day (s1007). On the other hand, if the available work time is long (s1004: NO), the shipping product database 83 is searched for a picking instruction record for shipping scheduled after the calculation date as a pseudo-shipping (additional picking instruction record).

  Further, for the pseudo-shipment searched here, the quantity of picking products included in the pseudo-shipping (additional picking instruction record) extracted from the picking instruction database 84 is multiplied by the unit picking work time of the picking goods in the master database 82. Then, the urgent picking work time is calculated (s1005).

  It should be noted that when searching for a picking instruction record for the planned shipment after the calculation date in the shipment database 83 as a pseudo shipment, the picking work time after the calculation date exceeds the workable time or approximates within a predetermined range. It is possible to specify a predetermined time, and search for a picking instruction record for a shipping schedule included in the predetermined time as a pseudo-shipment. The conceptual diagram 600 shown in FIG. 6 shows a time 601 when the picking work time exceeds the workable time after the calculation date, and a work where the picking work time exceeds the workable time, that is, a pseudo shipment 602.

  The arithmetic unit 30 determines whether or not the total time of the picking work time and the additional picking work time is within the workable time (s1006). If it is determined that it is within the workable time (s1006: NO), the pseudo shipment is performed. For example, as shown in FIG. 4A, the corresponding record is updated in the shipping product database 83 so that the picking date is earlier than the shipping date. Here, the determination (s1006) and the process of updating the corresponding record are repeated until the total time of the picking work time and the additional picking work time is equal to the workable time, for example.

  Based on the record updated in this way, information related to the picking work and the shipping work related to the shipment amount and the pseudo shipment amount on the calculation date is output to the WMS server 101 and the control device 103 (sl008), and the processing ends. The information output here is, for example, a picking work list, which is information instructed to the picking worker via a device such as a wireless handy terminal, a cart picking terminal, or a DPS on the picking day.

  On the other hand, when it is determined in step s1006 that it does not fit (including the case where the workable time is equal to the total time of the picking work time and the pressing picking work time) (s1006: YES), the pseudo shipment is calculated as the calculation. The calculation date itself is, for example, the next day (sl007), and the process returns to step s1002 to be performed on another day after the date.

  As described above, the picked product based on the information regarding the picking work generated by the system 100 is transported by the transport means in the distribution center. For example, even if the shipping date of the corresponding record in the shipping product database 83 is the same day, the corresponding product is shipped after being matched with other products in the shipping area 23 (FIG. 2), inspected, packed, and sorted by shipping direction. . When sorting by shipping direction, the shipping destination information in the shipping product database 83 is output to the distribution facility, and an instruction is given to the operator.

  On the other hand, if the product corresponds to the pseudo shipment whose shipment date is after the picking date, the product is temporarily stored in the pseudo shipment storage warehouse 24 after picking. Then, on the shipping date in the corresponding record in the shipping product database 83, the product is transported to the shipping area 23 by appropriate transporting means in the distribution center and shipped in the same manner as described above.

According to the present invention, the shipping work capacity per unit time can be brought close to the maximum shipping capacity, and human resources can be effectively used. Also, by pre-picking and storing the pseudo-shipped product in advance, even if the actual shipping amount at the time of actual shipping exceeds the maximum shipping capacity, it is possible to add the pre-picked portion for the pseudo-shipping. It will be possible to respond and realize the shipping work that corresponds to the shipping order reliably.
Therefore, it is possible to reliably cope with the shipping order and level the picking work amount.

  As mentioned above, although embodiment of this invention was described concretely based on the embodiment, it is not limited to this and can be variously changed in the range which does not deviate from the summary.

It is a network block diagram including the picking work amount management system in this embodiment. It is the system block diagram in this embodiment, and the schematic diagram of a distribution center. It is a figure which shows the example of (a) attendance management database and (b) master database in this embodiment. It is a figure which shows the example of (a) shipment goods database and (b) picking instruction | indication database in this embodiment. It is a flowchart which shows the actual procedure of the picking work amount management method in this embodiment. It is a conceptual diagram of the pseudo shipment in this embodiment.

Explanation of symbols

30 computing device 50 program 51 memory 52 workable time calculation unit 53 picking work time calculation unit 54 additional picking work time calculation unit 55 timing update unit 56 output unit 80 storage device 100 picking work amount management system, system 101 WMS server 102 WMS Terminal 103 Control device 110 Host computer 120 Network

Claims (4)

A system for managing the amount of picking work in a distribution center,
A picking instruction database that stores picking instruction records containing picking product and quantity information based on the shipping order;
A master database that stores unit picking work time for each product to be picked,
A time management database that stores the work status of picking workers,
For a shipment corresponding to a shipment order, a shipment database that stores the shipment status including information on the corresponding picking instruction record and shipment date and picking date;
From the attendance management database, extract the number of working workers and working hours at the target time of picking work volume management, and a workable time calculating unit for calculating workable time at the target time;
The picking instruction record for the planned shipment at the target time is searched after eliminating the additional picking work already picked before the target time in the shipping product database, and the picking instruction record extracted from the picking instruction database is searched. A picking work time calculating unit for calculating the picking work time by multiplying the quantity of picking products including the unit picking work time of the corresponding picking product in the master database;
When the workable time and the picking work time are compared, and the workable time is large, the picking instruction record for the scheduled shipment after the target time is searched as an additional picking instruction record in the shipping product database, and the picking instruction database An additional picking work time calculation unit that calculates the additional picking work time by multiplying the quantity of picking products included in the additional picking instruction record extracted from the unit picking work time of the picking product in the master database;
It is determined whether or not the total time of the picking work time and the additional picking work time falls within the workable time, and if it is determined that it is within the workable time, the picking time of the additional picking instruction record in the shipping product database is the target A time update unit for performing update processing as time, and
An output unit for outputting the contents of the update process to an output interface;
A picking work amount management system comprising: The additional picking work time calculation unit according to claim 1,
When searching for the picking instruction record for the scheduled shipment after the target time in the shipping product database as an additional picking instruction record, the picking work time after the target time exceeds the workable time or approximated within a predetermined range A picking work amount management system characterized in that a predetermined time period is specified and a picking instruction record for a shipping schedule included in the predetermined time period is searched as an additional picking instruction record. Picking instruction database that stores picking instruction records including information on picking products and quantities based on shipment orders, a master database that stores unit picking work time for each product to be picked, and the work status of picking workers A time management database and a shipment database that stores the shipment status including information on the corresponding picking instruction record and shipment date and picking date for the shipment corresponding to the shipment order. The computer system to manage
From the attendance management database, extract the number of working workers and working hours at the target time of picking work amount management, calculate the workable time at the target time,
The picking instruction record for the planned shipment at the target time is searched after eliminating the additional picking work already picked before the target time in the shipping product database, and the picking instruction record extracted from the picking instruction database is searched. The picking work time is calculated by multiplying the quantity of picking goods inclusive by the unit picking work time of the picking product in the master database,
When the workable time and the picking work time are compared, and the workable time is large, the picking instruction record for the scheduled shipment after the target time is searched as an additional picking instruction record in the shipping product database, and the picking instruction database The additional picking work time is calculated by multiplying the quantity of picking products included in the additional picking instruction record extracted from the unit picking work time of the corresponding picking product in the master database,
It is determined whether or not the total time of the picking work time and the additional picking work time falls within the workable time, and if it is determined that it is within the workable time, the picking time of the additional picking instruction record in the shipping product database is the target We perform update processing to assume time,
Output the contents of the update process to the output interface.
Picking work amount management method characterized by the above. Picking instruction database that stores picking instruction records including information on picking products and quantities based on shipment orders, a master database that stores unit picking work time for each product to be picked, and the work status of picking workers A time management database and a shipment database that stores the shipment status including information on the corresponding picking instruction record and shipment date and picking date for the shipment corresponding to the shipment order. To the computer system to manage,
From the attendance management database, extracting the number of workers working hours and working hours in the target time of picking work amount management, calculating the work possible time in the target time,
The picking instruction record for the planned shipment at the target time is searched after eliminating the additional picking work already picked before the target time in the shipping product database, and the picking instruction record extracted from the picking instruction database is searched. Multiplying the quantity of picking products including the unit picking work time of the corresponding picking product in the master database to calculate the picking work time;
When the workable time and the picking work time are compared, and the workable time is large, the picking instruction record for the scheduled shipment after the target time is searched as an additional picking instruction record in the shipping product database, and the picking instruction database Calculating the additional picking work time by multiplying the quantity of picking products included in the additional picking instruction record extracted from the unit picking work time of the corresponding picking product in the master database;
It is determined whether or not the total time of the picking work time and the additional picking work time falls within the workable time, and if it is determined that it is within the workable time, the picking time of the additional picking instruction record in the shipping product database is the target A step of performing an update process to be timed, and
Outputting the contents of the update process to an output interface;
Picking work amount management program characterized by causing

Images