Bulk cargo allocation processing device, bulk cargo allocation processing method, and bulk cargo allocation processing program

Abstract

To allow for recognizing and managing an actual quantity to a scheduled quantity for each consignor even in a state where warehousing of the whole quantity of bulk cargo is not completed.SOLUTION: A comparison unit compares a scheduled warehousing quantity of bulk cargo which is dry cargo or liquid cargo to be loaded and transported without being wrapped or packed, with an actual same-day warehousing quantity being a quantity of actually warehoused bulk cargo. When a comparison result indicating that the actual same-day warehousing quantity is less than the scheduled warehousing quantity is obtained, a calculation unit calculates an actual prorated quantity being a quantity for each consignor corresponding to the actual same-day warehousing quantity by multiplying the actual same-day warehousing quantity by a proration coefficient corresponding to a scheduled quantity for each consignor, which is a value obtained by dividing the scheduled quantity for each consignor by the scheduled warehousing quantity. A data generation unit generates inventory data by consignor which includes the calculated actual prorated quantity for each consignor as an actual quantity for each consignor.SELECTED DRAWING: Figure 1

Description

Technical Field

[0001] The present invention relates to a bulk cargo apportionment processing device, a bulk cargo apportionment processing method, and a bulk cargo apportionment processing program.

Background Art

[0002] Today, for example, as a type of imported goods, bulk cargo is known. This bulk cargo is dry or liquid cargo that is loaded and transported without being packaged or bundled, such as wheat, coal, and oil.

[0003] Patent Document 1 (Japanese Unexamined Patent Application Publication No. 2007-334725) discloses a cargo transport vehicle that can facilitate the grasping and management of loading and unloading during transportation for each piece of cargo, and can measure the actual transport volume and actual fuel consumption for each piece of cargo in real time.

[0004] This cargo transport vehicle attaches an IC tag to each individual piece of cargo, and when loading or unloading, writes to or reads from the IC tag using an IC tag writer provided on the vehicle, and grasps the time and transport distance of loading and unloading during transportation for each piece of cargo. For those with a large weight, the weight of each piece of cargo is measured with a loading weight meter installed on the vehicle, and for those with a light weight, the weight of each piece of cargo is accurately measured with a hand-held small weight meter. Then, the transport distance for each piece of cargo is obtained by a digital tachometer installed on the vehicle, and from this and the measurement results of the weight of each piece of cargo, the processing device 7 automatically calculates the transport volume for each piece of cargo (= weight of each piece of cargo × transport distance of each piece of cargo).

[0005] Also, this cargo transport vehicle grasps the total fuel consumption in the loading and unloading sections based on the amount of fuel measured by a fuel gauge, and the processing device apportions the weight for each piece of loaded cargo in the transport section of the cargo, and calculates the fuel consumption required for the transport of the cargo. Thereby, it is possible to facilitate the grasping and management of loading and unloading during transportation for each piece of cargo, and it is also possible to measure the actual transport volume and actual fuel consumption for each piece of cargo in real time.

Prior Art Documents

[0006] [Patent Document 1] Japanese Patent Publication No. 2007-334725 [Overview of the project] [Problems that the invention aims to solve]

[0007] However, since bulk cargo is stored in tanks in the same condition as when it was unloaded, it is difficult to track the actual quantity for each shipper during the process. Furthermore, because bulk cargo is transported in large quantities at once, it can take several days for all the cargo to be stored, making it difficult to track the actual quantity compared to the planned quantity for each shipper until all the cargo has been stored.

[0008] This invention has been made in view of the above-mentioned problems, and aims to provide a bulk cargo allocation processing device, a bulk cargo allocation processing method, and a bulk cargo allocation processing program that enable the determination of the actual quantity compared to the planned quantity for each shipper, even when the entire amount of bulk cargo has not yet been received into storage. [Means for solving the problem]

[0009] To solve the above-mentioned problems and achieve the objective, the bulk cargo allocation processing device according to the present invention provides a bulk cargo that is loaded and transported without packaging or wrapping, whether it is dry or liquid cargo. The planned incoming quantity is determined by referring to the shipper-specific inventory table, which is set for each bulk cargo transporter and each shipper, and the planned incoming quantity for each shipper is determined. , and a comparison section that compares the actual amount of bulk cargo received on the day, which is the actual amount of bulk cargo received on the day, and the actual amount of bulk cargo received on the day However, each shipper The system includes a calculation unit that calculates the actual allocated quantity for each shipper corresponding to the actual daily incoming quantity by multiplying the actual daily incoming quantity by an allocation coefficient corresponding to each shipper's planned quantity, which is the value obtained by dividing each shipper's planned quantity by the planned incoming quantity, when the comparison unit obtains a comparison result that is less than the planned incoming quantity. and a data generation unit that generates shipper-specific inventory data that includes the calculated actual allocated quantity for each shipper as the actual quantity for each shipper.

[0010] Furthermore, in order to solve the above-mentioned problems and achieve the objectives, the present invention Bulk cargo sorting and processing equipment The bulk cargo allocation method is such that the comparison part is bulk cargo that is dry or liquid cargo that is loaded and transported without packaging or wrapping. The planned incoming quantity is determined by referring to the shipper-specific inventory table, which is set for each bulk cargo transporter and each shipper, and the planned incoming quantity for each shipper is determined. The comparison step involves comparing the actual daily incoming quantity, which is the quantity of bulk cargo actually received, with the calculation unit, which calculates the actual daily incoming quantity. However, each shipper The system includes a calculation step in which, when the comparison step yields a result that falls short of the planned incoming quantity, the actual daily incoming quantity is multiplied by an allocation coefficient corresponding to each shipper's planned quantity, which is the value obtained by dividing each shipper's planned quantity by the planned incoming quantity, to calculate the actual allocated quantity for each shipper corresponding to the actual daily incoming quantity; and a data generation step in which the data generation unit generates shipper-specific inventory data that includes the calculated actual allocated quantity for each shipper as the actual quantity for each shipper.

[0011] Furthermore, in order to solve the above-mentioned problems and achieve the objective, the bulk cargo allocation processing program according to the present invention provides a computer for bulk cargo, which is dry or liquid cargo that is loaded and transported without packaging or wrapping. The planned incoming quantity is determined by referring to the shipper-specific inventory table, which is set for each bulk cargo transporter and each shipper, and the planned incoming quantity for each shipper is determined. , and a comparison section that compares the actual amount of bulk cargo received on the day, which is the actual amount of bulk cargo received on the day, and the actual amount of bulk cargo received on the day However, each shipper When the comparison unit obtains a comparison result that falls short of the planned incoming quantity, the calculation unit calculates the actual allocated quantity, which is the quantity for each shipper corresponding to the actual incoming quantity for the day, by multiplying the actual incoming quantity for the day by an allocation coefficient corresponding to each shipper's planned quantity, which is obtained by dividing each shipper's planned quantity by the planned incoming quantity. The data generation unit then generates shipper-specific inventory data that includes the calculated actual allocated quantity for each shipper as the actual quantity for each shipper. [Effects of the Invention]

[0012] This invention makes it possible to grasp and manage the actual quantity compared to the planned quantity for each shipper, even when the entire amount of bulk cargo has not yet been received. [Brief explanation of the drawing]

[0013] [Figure 1] Figure 1 is a block diagram showing the hardware configuration of the bulk cargo apportionment processing device according to the embodiment. [Figure 2] Figure 2 is a diagram showing an example of the ship-by-ship warehousing table. [Figure 3] Figure 3 is a diagram showing an example of the shipper-by-shipper inventory table. [Figure 4] Figure 4 is a diagram showing an example of the apportionment table. [Figure 5] Figure 5 is a diagram showing an example of the warehousing input screen. [Figure 6] Figure 6 is a diagram showing an example of the ship-by-ship warehousing table in a state where the actual warehousing quantity for the first time has been input. [Figure 7] Figure 7 is a diagram showing the apportionment table in a state where the apportioned quantity for each shipper has been input based on the actual warehousing quantity for the first time and the planned quantity for each shipper. [Figure 8] Figure 8 is a diagram showing the shipper-by-shipper inventory table in a state where the actual quantity for each shipper has been input based on the actual warehousing quantity for the first time and the planned quantity for each shipper. [Figure 9] Figure 9 is a diagram showing the warehousing input screen in a state where the actual quantity for each shipper corresponding to the actual warehousing quantity for the first time and the planned quantity for each shipper has been input. [Figure 10] Figure 10 is a diagram showing the apportionment screen for each shipper. [Figure 11] Figure 11 is a diagram showing an example of the ship-by-ship warehousing table in a state where the excess quantity has been input on the second day. [Figure 12] Figure 12 is a diagram showing the apportionment table in a state where the apportioned quantity for each shipper has been input based on the actual warehousing quantity on the second day and the planned quantity for each shipper. [Figure 13] Figure 13 is a diagram for explaining the process of setting the excess quantity after the apportionment process based on the actual warehousing quantity on the second day as the actual quantity of the representative shipper. [Figure 14] Figure 14 is a diagram for explaining the activation operation of the apportionment screen, which is the detailed screen for each shipper. [Figure 15]FIG. 15 is a diagram showing an example of the apportionment screen. [Figure 16] FIG. 16 is a diagram showing the ship-by-ship warehousing table corresponding to the final warehousing result. [Figure 17] FIG. 17 is a diagram showing the shipper-by-shipper inventory table corresponding to the final warehousing result. [Figure 18] FIG. 18 is a diagram showing the apportionment table corresponding to the final warehousing result. [Figure 19] FIG. 19 is a diagram showing another example of the ship-by-ship warehousing table in a state where the actual warehousing quantity for the first time has been input. [Figure 20] FIG. 20 is another diagram showing the apportionment table in a state where the apportionment quantity for each shipper has been input based on the actual warehousing quantity for the first time and the planned quantity for each shipper. [Figure 21] FIG. 21 is another diagram showing the shipper-by-shipper inventory table in a state where the actual quantity for each shipper has been input based on the actual warehousing quantity for the first time and the planned quantity for each shipper. [Figure 22] FIG. 22 is another diagram showing the warehousing input screen in a state where the actual quantity for each shipper corresponding to the actual warehousing quantity for the first time and the planned quantity for each shipper has been input. [Figure 23] FIG. 23 is another diagram showing the apportionment screen which is the detailed screen for each shipper. [Figure 24] FIG. 24 is another diagram showing another example of the ship-by-ship warehousing table in a state where the excess quantity has been input on the second day. [Figure 25] FIG. 25 is another diagram showing the apportionment table in a state where the apportionment quantity for each shipper has been input based on the actual warehousing quantity on the second day and the planned quantity for each shipper. [Figure 26] FIG. 26 is another diagram for explaining the process of setting the excess quantity after the apportionment process based on the actual warehousing quantity on the second day as the actual quantity of the representative shipper. [Figure 27] FIG. 27 is another diagram showing the warehousing input screen in a state where the actual quantity for each shipper corresponding to the actual warehousing quantity on the second day and the planned quantity for each shipper has been input. [Figure 28] FIG. 28 is another diagram showing the apportionment screen. [Figure 29]Figure 29 shows another example of a vessel-specific inventory table with the actual inventory quantities for the second day entered. [Figure 30] Figure 30 shows an allocation table in which the allocated quantities for each shipper have been entered based on the actual incoming goods quantity on the second day. [Figure 31] Figure 31 is another diagram showing the allocation table with the allocated quantities for each shipper entered based on the actual incoming quantities on the second day and the planned quantities for each shipper. [Modes for carrying out the invention]

[0014] The following will describe in detail, based on the drawings, a bulk cargo allocation processing device that is an embodiment of the present invention. The following description will proceed assuming that the bulk cargo allocation processing device in this embodiment allocates bulk cargo loaded onto a ship to each shipper. Furthermore, the present invention may also be used to allocate bulk cargo loaded onto, for example, trucks, freight trains, or airplanes to each shipper, and is not limited to the following embodiment.

[0015] (Hardware configuration) As shown in Figure 1, the bulk cargo allocation processing device 1 of this embodiment includes a storage unit 2, a control unit 3, a communication interface unit 4, and an input / output interface unit 5. An input device 6 and an output device 7 are connected to the input / output interface unit 5. The output device 7 may be a display unit such as a monitor device (including a household television), a speaker device, etc. The input device 6 may be a keyboard device, a mouse device, a microphone device, etc., or a monitor device that works in cooperation with a mouse device to realize a pointing device function. The communication interface unit 4 is connected to a network such as a wide-area network such as the Internet or a private network such as a LAN (Local Area Network).

[0016] For the memory unit 2, a storage device such as ROM (Read Only Memory), RAM (Random Access Memory), HDD (Hard Disk Drive), or SSD (Solid State Drive) can be used. The memory unit 2 stores a bulk cargo allocation processing program that allocates bulk cargo, such as wheat, coal, and petroleum, which are dry or liquid cargo loaded and transported without packaging, based on the planned quantities of each shipper. The memory unit 2 also includes a vessel-specific warehousing table 11, a shipper-specific inventory table 12, and an allocation table 13.

[0017] As shown in Figure 2, the vessel-specific warehousing table 11 stores and stores information such as the vessel CD, which is the identification code of the vessel transporting the bulk cargo; the name of the bulk cargo; the quantity of bulk cargo scheduled to be received (scheduled quantity = scheduled warehousing quantity); and the actual quantity of bulk cargo received on the day (= actual quantity). The example in Figure 2 is a case where "wheat" of "M01" is transported by a cargo ship with vessel CD "102", and the scheduled warehousing quantity of bulk cargo is "600 kg".

[0018] The shipper-specific inventory table 12 stores and stores information such as the vessel code (CD), shipper code (Identification Code) for each shipper, the planned quantity for each shipper (the order quantity for bulk cargo from each shipper), and a shipper flag assigned to the representative shipper among the shippers. The example in Figure 3 shows an example where three shippers with shipper code "A", "B", and "C" order bulk cargo in quantities of "300 kg", "100 kg", and "200 kg" respectively (order quantity). The example in Figure 3 also shows that shipper with shipper code "A" is the representative shipper among the three shippers (representative shipper flag = TRUE).

[0019] The allocation table 13 stores the allocation number automatically assigned by the control unit 3, the date the bulk cargo was received, the shipper code, and the actual quantity of bulk cargo received, which is the actual quantity of bulk cargo received. The allocation quantity is calculated by applying this allocation process to each shipper's order quantity. The example in Figure 4 shows that, through the allocation process, on the receiving date of November 1st, bulk cargo of "240 kg," "80 kg," and "160 kg" was provided to shippers "A," "B," and "C," respectively, with shipper CDs.

[0020] (Functional configuration of bulk cargo sorting and processing equipment) Next, the control unit 3 executes the bulk cargo allocation processing program stored in the storage unit 2, and functions as a comparison unit 21, calculation unit 22, data generation unit 23, display control unit 24, and storage control unit 25, as shown in Figure 1.

[0021] The comparison unit 21 compares the planned quantity of bulk cargo (= planned incoming quantity) with the actual quantity of bulk cargo actually received (= actual incoming quantity for the day). When the comparison unit 21 provides a comparison result showing that the actual incoming quantity for the day is less than the planned incoming quantity, the calculation unit 22 multiplies the actual incoming quantity for the day by an allocation coefficient corresponding to each shipper's planned quantity, which is obtained by dividing each shipper's planned quantity by the planned incoming quantity. As a result, the calculation unit 22 calculates the actual allocated quantity for each shipper, which is the quantity for each shipper corresponding to the actual incoming quantity for the day. The data generation unit 23 generates shipper-specific inventory data that includes the calculated actual allocated quantity for each shipper as the actual quantity for each shipper.

[0022] Furthermore, if the calculated actual allocated quantity for each shipper is less than the planned quantity for each shipper, the comparison unit 21 compares the added quantity, obtained by adding the actual re-inbound quantity for the day and the actual inbound quantity for the day corresponding to the re-inbound bulk cargo when it is received again, with the planned inbound quantity. If the comparison unit 21 provides a comparison result indicating that the added quantity obtained by adding the actual re-inbound quantity for the day and the actual inbound quantity for the day is greater than the planned inbound quantity, the calculation unit 22 calculates the planned supplementary quantity for each shipper, which is the difference between the planned quantity and the actual allocated quantity. The calculation unit 22 also calculates the actual quantity equivalent to the planned quantity for each shipper by adding the calculated planned supplementary quantity and the actual allocated quantity for each shipper. The data generation unit 23 generates shipper-specific inventory data, which includes the actual quantity equivalent to the planned quantity as the actual quantity.

[0023] The data stored in the consignor-specific inventory table 12 shown in Figure 3, and / or the allocation table 13 shown in Figure 4, are examples of consignor-specific inventory data.

[0024] Furthermore, the calculation unit 22 calculates the excess quantity, which is the difference between the added quantity (the sum of the actual re-inventory quantity for the day and the actual inventory quantity for the day) and the planned inventory quantity. The data generation unit 23 detects the representative shipper from among the various shippers by referring to the shipper-specific inventory table 12 (see Figure 3: an example of the storage unit), which stores information indicating the representative shipper. The data generation unit 23 then generates shipper-specific inventory data that includes the actual quantity obtained by adding the excess quantity to the actual quantity of the representative shipper from among the actual quantities of each shipper.

[0025] Furthermore, if the actual allocated quantity for each shipper calculated by the calculation unit 22 is less than the planned quantity for each shipper, the comparison unit 21 compares the planned quantity with the added quantity obtained by adding the actual re-inbound quantity for the day and the actual re-inbound quantity for the day corresponding to the re-inbound bulk cargo when it is received again. If the comparison unit 21 provides a comparison result indicating that the planned quantity is greater than the added quantity obtained by adding the actual re-inbound quantity for the day and the actual re-inbound quantity for the day, the calculation unit 22 calculates the actual re-allocated quantity for each shipper by multiplying each shipper's allocation coefficient by the actual re-inbound quantity for the day. The calculation unit 22 also calculates the actual quantity for each shipper by adding the calculated actual re-allocated quantity for each shipper to each shipper's actual allocated quantity. The data generation unit 23 generates shipper-specific inventory data including the calculated actual quantities for each shipper.

[0026] Furthermore, the data generation unit 23 generates allocation screen data for the allocation screen, which includes the date of arrival of bulk cargo and the actual allocation quantity for each arrival date. Based on the generated allocation screen data, the display control unit 24 displays the allocation screen, which includes the date of arrival of bulk cargo and the actual allocation quantity for each arrival date, on the output device 7 (an example of a display unit).

[0027] (Proportional processing operation) In this embodiment of the bulk cargo allocation processing device 1, the control unit 3 performs the following steps based on the bulk cargo allocation processing program stored in the storage unit 2, thereby allocating the received bulk cargo to each shipper based on the order quantity (=planned quantity) from each shipper.

[0028] Step S1 → Display the receiving input screen based on the vessel-specific receiving table 11 and the shipper-specific inventory table 12. Step S2 → After the vessel arrives, the actual daily inventory quantity entered based on the weighing results is entered into the vessel-specific inventory table 11. Step S3 → Check for exceeding schedule Step S4 → The automatic allocation calculation process is performed and the actual daily incoming quantity (actual quantity) and actual allocated quantity (allocated quantity) are entered into the consignor-specific inventory table 12 and the allocation table 13. Step S5 → If the "Activate Proportional Distribution Screen" button is pressed, the proportional distribution screen will be displayed, showing the proportional distribution information for the specified shipper. Step S6 → Check for exceeding the planned quantity based on the actual re-entry quantity on the day. Step S7 → If the quantity obtained by subtracting the actual quantity re-invented on the day from the planned remaining inventory quantity is negative, the shortfall in each shipper's planned quantity will be supplemented based on the actual quantity re-invented on the day (planned supplement quantity). Step S8 → If the quantity obtained by subtracting the actual quantity re-entered on the day from the planned remaining inventory quantity is a positive quantity, the automatic allocation calculation process is performed again, and the actual quantity and allocated quantity are entered into each table.

[0029] The following will explain this apportionment process in detail.

[0030] (Proportional allocation process based on the quantity received in the first shipment) First, the operations operator specifies the display of the inbound input screen via the input device 6. The data generation unit 23 then refers to the vessel-specific inbound table 11 shown in Figure 2 and the shipper-specific inventory table 12 shown in Figure 3, and generates screen data for the inbound input screen, as illustrated in Figure 5, which includes the planned inbound quantity, the name of the bulk cargo to be inbound, the planned quantity (ordered quantity) for each shipper, and the representative shipper flag. Based on this screen data, the display control unit 24 displays the inbound input screen shown in Figure 5 via the output device 7 (step S1).

[0031] This receiving entry screen indicates that a bulk cargo of "MO01: Wheat" weighing "600 kg" is scheduled to be received, and that this bulk cargo will be allocated among shippers A, B, and C. Furthermore, this receiving entry screen shows that the planned quantity ordered by shipper A is "300 kg", the planned quantity ordered by shipper B is "100 kg", and the planned quantity allocated by shipper C is "200 kg". Additionally, this receiving entry screen indicates that among shippers A, B, and C, shipper A, which has the representative shipper FLG designation, is the representative shipper.

[0032] Next, after the vessel arrives, based on the weighing results of the bulk cargo, the operations operator enters the actual daily inventory quantity (actual quantity) into the vessel-specific inventory table 11, as shown in Figure 6 (step S2). Figure 6 shows that although 600 kg of bulk cargo was initially scheduled to be received, only 480 kg of bulk cargo was actually received. Once the vessel-specific inventory table 11 is updated in this way, the display control unit 24 displays the actual daily inventory quantity (actual quantity received) of 480 kg in this example on the inventory input screen, as shown in Figure 9.

[0033] Next, the comparison unit 21 performs an over-scheduled check process (step S3). Specifically, the comparison unit 21 subtracts the actual amount received on the day, "480 kg," from the planned amount received in the vessel-specific storage table 11, "600 kg," and determines whether the result of this subtraction is a positive or negative quantity (over-scheduled check process).

[0034] In this example, the actual amount received on the day (480 kg) does not exceed the initially planned amount received (600 kg), so the subtraction result is a positive subtraction result. Therefore, the calculation unit 22 performs an automatic apportionment calculation (step S4). The data generation unit 23 inputs the actual amount received on the day (actual quantity) and the actual apportionment quantity (apportionment quantity) calculated by the automatic apportionment calculation into the consignor inventory table 12 and the apportionment table 13.

[0035] When performing automatic apportionment calculation, the calculation unit 22 calculates an apportionment coefficient corresponding to each shipper's planned quantity by dividing each shipper's planned quantity by the planned quantity received. Then, the calculation unit 22 calculates the apportionment quantity corresponding to the quantity received this time for each shipper by multiplying each apportionment coefficient by the actual quantity received on the day (actual quantity).

[0036] Specifically, in the example described above, the calculation unit 22 calculates the allocated quantity for each shipper by performing the following calculations.

[0037] The allocated quantity for consignor A = 480kg × (300kg / 600kg) = 240kg Portion allocated to consignor A = 480kg × (100kg / 600kg) = 80kg Portion allocated to consignor A = 480kg × (200kg / 600kg) = 160kg

[0038] Once the allocated quantities for each shipper are calculated in this way, the data generation unit 23 automatically assigns allocation numbers to the allocation table 13, as shown in Figure 7, and inputs the allocated quantities of "240kg", "80kg", and "160kg" for shippers A to C, respectively, along with the current day's receiving date.

[0039] In addition, as shown in Figure 8, the data generation unit 23 inputs the apportioned quantities of "240kg", "80kg", and "160kg" as the actual daily incoming quantities (actual quantities) for each shipper in the shipper inventory table 12.

[0040] Furthermore, the display control unit 24 displays the allocated quantities of "240kg", "80kg", and "160kg" for each shipper on the receiving input screen shown in Figure 9 as the actual daily receiving quantity (actual quantity) on the receiving input screen.

[0041] This allows the actual quantity received on a given day to be allocated proportionally to the quantity ordered by each consignor.

[0042] Next, the display control unit 24 displays an allocation screen activation button 50 adjacent to the display fields for the planned quantity and actual quantity of each shipper on the receiving input screen. This allocation screen activation button 50 is a button that is operated when the allocation information for each shipper is displayed individually. When this allocation screen activation button 50 is operated, the display control unit 24 displays the allocation screen illustrated in Figure 10 on the output device 7 (step S5). On this allocation screen, the display control unit 24 displays the shipper code and planned quantity of the shipper specified via the allocation screen activation button 50, along with the receiving date, allocated quantity, and the total allocated quantity for each receiving date as allocation information.

[0043] (Complementary processing based on the second shipment) The above explanation describes the apportionment process based on the first incoming quantity. However, in the embodiment, if the second incoming quantity exceeds the planned quantity and the resulting quantity is positive, the bulk cargo apportionment processing device 1 performs the same apportionment process as described above again. If the second incoming quantity exceeds the planned quantity and the resulting quantity is negative, the device performs the following compensation process.

[0044] In other words, if there is another incoming shipment after the allocation process for the first incoming shipment as described above, the excess check process is performed again based on the actual quantity of the re-incoming shipment on that day (step S6).

[0045] For example, suppose that 600 kg of bulk cargo was received in the first shipment, and 420 kg of bulk cargo was received in the second shipment. In this case, the calculation unit 22 calculates a remaining planned inventory quantity of 120 kg by subtracting the previously received 480 kg from the planned inventory quantity of 600 kg. This remaining planned inventory quantity represents the deficit from the planned inventory quantity caused by the previous inventory quantity. The comparison unit 21 determines whether the quantity obtained by subtracting the actual inventory quantity of the day (420 kg), which is the second inventory quantity, from this remaining planned inventory quantity of 120 kg is a positive or negative quantity.

[0046] In this case, the quantity becomes negative. Therefore, the calculation unit 22 does not perform the above-mentioned apportionment process, but instead compensates for the shortfall in each shipper's planned quantity based on the actual re-in quantity on the day (planned compensation quantity) (step S7).

[0047] To explain in more detail, in this example, there was a 480kg inbound shipment the first time and a 420kg inbound shipment the second time, so the actual quantity is a total of 900kg. Therefore, as shown in Figure 11, the data generation unit 23 updates the actual quantity in the vessel-specific inbound table 11 by entering a quantity of 900kg.

[0048] In this example, the quantity obtained by subtracting the actual re-inbound quantity of the day (420 kg), which is the second inbound quantity, from the planned remaining inbound quantity of 120 kg results in a negative quantity. Therefore, the calculation unit 22 does not perform proportional allocation and instead supplements the shortfall in each shipper's planned quantity (planned quantity - proportional allocation quantity) with the actual re-inbound quantity of the day, which is the second inbound quantity.

[0049] In other words, in this example, the planned quantity for shipper A is "300 kg", and the allocated quantity is "240 kg". Therefore, the calculation unit 22 performs the calculation "300 kg - 240 kg = 60 kg" and calculates a supplementary quantity of "60 kg" for shipper A.

[0050] Similarly, the planned quantity for shipper B is "100 kg," and the allocated quantity is "80 kg." Therefore, the calculation unit 22 performs the calculation "100 kg - 80 kg = 20 kg" and calculates a supplementary quantity of "20 kg" for shipper B.

[0051] Similarly, the planned quantity for shipper C is "200 kg," and the allocated quantity is "160 kg." Therefore, the calculation unit 22 performs the calculation "200 kg - 160 kg = 40 kg" and calculates a supplementary quantity of "40 kg" for shipper C.

[0052] The data generation unit 23 inputs the calculated supplementary quantities for each shipper as the allocated quantities for each shipper in the allocation table 13 shown in Figure 12. Furthermore, since these supplementary quantities meet the planned quantities for each shipper, the data generation unit 23 updates the shipper-specific inventory table 12 by adding the supplementary quantities to each shipper's previous actual quantities, as shown in Figure 13. As a result, each shipper's planned quantity and actual quantity become the same.

[0053] (Allocation of excess amount to the representative shipper) In this example, the actual quantity received on the day, which is the second inbound quantity, is "420 kg". Therefore, even if supplementary processing of "60 kg", "20 kg", and "40 kg" is performed for each shipper, there will be a surplus (excess amount) of "420 kg - (60 kg + 20 kg + 40 kg) = 300 kg" of inbound quantity.

[0054] It is customary practice to allocate such excess inventory to the representative shipper. Therefore, the data generation unit 23 detects the representative shipper (representative shipper FLG is TRUE) by referring to the shipper-specific inventory table shown in Figure 3, and allocates the excess quantity of "300 kg" to shipper A, who is the representative shipper. As a result, as shown in Figure 12, the allocated quantity for shipper A in the allocation table 13 is updated to a total of "360 kg," which is the sum of the supplementary quantity of "60 kg" and the excess quantity of "300 kg."

[0055] Furthermore, the data generation unit 23 updates the actual quantity for shipper A in the shipper-specific inventory table 12 shown in Figure 13 with a total of "600 kg," which is the previous actual quantity of "300 kg" plus the excess of "300 kg."

[0056] Furthermore, the display control unit 24 updates and displays the actual incoming quantity (480 kg for the first incoming shipment + 420 kg for the second incoming shipment = 900 kg), the planned quantity for each shipper, the total planned quantity, the actual quantity, and the total actual quantity on the incoming shipment input screen, as shown in Figure 14, based on the updated shipper-specific inventory table 12.

[0057] Furthermore, when the allocation screen activation button 50 is operated, the display control unit 24 displays the allocation screen for the shipper corresponding to the operated allocation screen activation button 50, as shown in Figure 15. The example in Figure 15 is the allocation screen for shipper C, showing that 160 kg of bulk cargo was allocated on November 1st, the first receiving date, and 40 kg of bulk cargo was allocated on November 2nd, the second receiving date.

[0058] (Reflection of final inventory results) Next, in this example, the final inventory result will be as follows:

[0059] Planned inventory quantity: 600kg Planned allocation quantities: Shipper A: 300kg, Shipper B: 100kg, Shipper C: 200kg

[0060] Actual received quantity: 900kg Actual allocation quantities: Shipper A: 600kg, Shipper B: 100kg, Shipper C: 200kg

[0061] Based on these final receiving results, the data generation unit 23 updates the actual quantities in the vessel-specific receiving table 11, as shown in Figure 16. The data generation unit 23 also updates the actual quantities for each shipper in the shipper-specific inventory table 12, as shown in Figure 17, based on the final receiving results. Furthermore, based on the final receiving results, the data generation unit 23 updates the allocated quantities in the allocation table 13 for each shipper and receiving date, as shown in Figure 18.

[0062] (Proportional allocation process based on the second inbound shipment) Next, the above explanation described the compensation process when the quantity becomes negative during the second inventory check for exceeding the planned quantity. In contrast, when the quantity becomes negative during the second inventory check for exceeding the planned quantity, the bulk cargo allocation processing device 1 of the embodiment performs automatic allocation calculation processing again based on the second inventory quantity, similar to the first allocation processing, and performs allocation processing to input the actual quantity and allocated quantity into each table (step S8).

[0063] In other words, to explain again the apportionment process based on the actual daily inventory quantity for the first time, let's assume that the planned inventory quantity is "600 kg", while the actual daily inventory quantity for the first time is "300 kg". In this case, after the vessel arrives, the operations operator inputs "300 kg" as the actual daily inventory quantity (actual quantity) based on the weighing results of the bulk cargo. As a result, the data generation unit 23 inputs "300 kg" into the actual quantity in the vessel-specific inventory table 11 and updates it, as shown in Figure 19.

[0064] Next, in this example, the planned quantity to be received is "600 kg," while the actual quantity received on the day is "300 kg." Therefore, "planned quantity 600 kg - actual quantity received on the day 300 kg = +300 kg," and the result of the excess check process is positive. For this reason, the calculation unit 22 performs the automatic apportionment calculation process as described above and apportions the actual quantity received on the day of "300 kg" to each shipper.

[0065] In other words, for example, suppose the planned quantities for shippers A, B, and C are "300kg," "100kg," and "200kg," respectively. The calculation unit 22 calculates the apportionment coefficients corresponding to each shipper's planned quantity by performing calculations of "300kg / 600kg," "100kg / 600kg," and "200kg / 600kg." Then, the calculation unit 22 calculates the actual apportionment quantity for each shipper by multiplying each of the calculated apportionment coefficients by the actual daily receiving quantity of "300kg" for the first time.

[0066] The actual allocated quantity for consignor A = Actual daily incoming quantity 300kg × (Planned quantity 300kg / Planned incoming quantity 600kg) = 150kg The actual allocated quantity for consignor B = Actual daily incoming quantity 300kg × (Planned quantity 100kg / Planned incoming quantity 600kg) = 50kg The actual allocated quantity for consignor A = Actual daily incoming quantity 300kg × (Planned quantity 200kg / Planned incoming quantity 600kg) = 100kg

[0067] Based on the actual allocation quantities calculated in this way, the data generation unit 23 updates the allocation quantities for each shipper in the allocation table 13 as shown in Figure 20, and also updates the actual quantities for each shipper in the shipper-specific inventory table 12 as shown in Figure 21.

[0068] Furthermore, the display control unit 24 displays the actual quantity for each shipper on the receiving input screen, as shown in Figure 22, based on the calculated actual allocation quantity. Also, as described above, when the allocation screen activation button 50 is operated, the display control unit 24 displays the allocation screen for the specified shipper, as shown in Figure 23.

[0069] (Action taken when the schedule overrun check result is positive) Next, let's assume that, for example, 200 kg of bulk cargo is received in the second shipment. In this case, after the vessel arrives, the operations operator inputs 200 kg as the actual quantity received on that day (actual quantity) based on the weighing results of the bulk cargo. As a result, the data generation unit 23 adds the 200 kg received in the second shipment to the 300 kg received in the first shipment, resulting in a total of 500 kg, and updates the actual quantity in the vessel-specific receiving table 11, as shown in Figure 24.

[0070] Next, the planned incoming quantity is "600kg," while the actual incoming quantity for the first time on the day is "300kg," and the actual re-incoming quantity for the second time on the same day is "200kg." Therefore, "planned incoming quantity 600kg - actual incoming quantity 300kg - actual re-incoming quantity 200kg = +100kg," resulting in a positive result for the over-plan check. For this reason, the calculation unit 22 performs the automatic apportionment calculation process as described above and apportions the actual re-incoming quantity of "200kg" to each shipper.

[0071] In other words, in this example, the planned quantities for shippers A, B, and C are "300kg," "100kg," and "200kg," respectively. Therefore, the calculation unit 22 calculates the apportionment coefficients corresponding to each shipper's planned quantity by performing calculations of "300kg / 600kg," "100kg / 600kg," and "200kg / 600kg." Then, the calculation unit 22 calculates the actual apportionment quantity for each shipper by multiplying each of the calculated apportionment coefficients by the actual re-inventory quantity of "200kg" for the second time.

[0072] The actual allocated quantity for consignor A = Actual re-inventory quantity for the day 200kg × (Planned quantity 300kg / Planned re-inventory quantity 600kg) = 100kg The actual allocated quantity for consignor B = Actual re-inbound quantity on the day 200kg × (Planned quantity 100kg / Planned inbound quantity 600kg) = 33kg Shipper A's actual allocated quantity = Actual re-inventory quantity for the day 200kg × (Planned quantity 200kg / Planned inventory quantity 600kg) = 67kg

[0073] The data generation unit 23 inputs the calculated actual allocation quantities as the allocation quantities corresponding to the second receiving date for each shipper in the allocation table 13, as shown in Figure 25. The data generation unit 23 also updates the actual quantities for each shipper in the shipper-specific inventory table 12 by adding the second actual quantity to the first actual quantity, as shown in Figure 26.

[0074] Furthermore, the display control unit 24 displays the actual quantities for each shipper, calculated based on the actual allocation quantities, by adding the actual quantities for the first and second transactions, on the receiving input screen, as shown in Figure 27. In addition, as described above, when the allocation screen activation button 50 is operated, the display control unit 24 displays the allocation screen for the specified shipper, as shown in Figure 28.

[0075] (Reflection of final inventory results) Next, in this example, the final inventory result will be as follows:

[0076] Planned inventory quantity: 600kg Planned allocation quantities: Shipper A: 300kg, Shipper B: 100kg, Shipper C: 200kg

[0077] Actual received quantity: 500kg Actual allocation quantities: Shipper A: 250kg, Shipper B: 83kg, Shipper C: 167kg

[0078] Based on these final receiving results, the data generation unit 23 updates the actual quantities in the vessel-specific receiving table 11, as shown in Figure 29. The data generation unit 23 also updates the actual quantities for each shipper in the shipper-specific inventory table 12, as shown in Figure 30, based on the final receiving results. Furthermore, based on the final receiving results, the data generation unit 23 updates the allocated quantities in the allocation table 13 for each shipper and receiving date, as shown in Figure 31.

[0079] (Effects of the embodiment) The process for receiving bulk cargo is as follows:

[0080] 1. Determine the estimated allocation quantity for each consignor based on the estimated incoming quantity stated on the arrival notification.

[0081] 2. Upon arrival of the vessel, the quantity of bulk cargo will be measured by a weighing company to determine the actual quantity received.

[0082] 3. Based on the confirmed actual quantity of goods received, the allocated quantity for each consignor is determined and the goods are received.

[0083] Furthermore, the receiving operations for bulk cargo have the following characteristics:

[0084] 1. Planned quantities and actual quantities will not be the same, and quantity input after the actual quantities are confirmed is required. This is because it may not be possible to collect all bulk cargo, resulting in some remaining on board, as well as some being blown away by the wind. Therefore, it is necessary to determine the allocated quantity for each shipper based on the confirmed actual quantities received.

[0085] 2. It is necessary to allocate the storage fees evenly to each shipper based on the date of arrival. In other words, since bulk cargo is received in large quantities at one time, it often takes several days from unloading to completion of storage. Furthermore, if storage fees are allocated to a specific shipper first, that shipper will have a longer period of being billed for storage fees. For this reason, it is necessary to allocate the quantity evenly to each shipper.

[0086] 3. Any excess volume of goods received will be adjusted by the representative shipper. In other words, it is customary practice to allocate any actual quantity exceeding the planned amount as the representative shipper's share. For shippers other than the representative shipper, the bulk cargo received will be allocated proportionally, up to the planned quantity of the other shippers.

[0087] For these reasons, the bulk cargo allocation processing device 1 of this embodiment automatically allocates the actual quantity based on the planned quantity for each day of receiving cargo. This makes it possible to grasp and manage the actual quantity of cargo received by each shipper without waiting for the entire amount to be received.

[0088] [Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving operational efficiency and promoting appropriate management decisions by companies, thereby contributing to SDG Goals 8 and 9.

[0089] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.

[0090] Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.

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

[0092] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically by known methods.

[0093] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configuration shown in this specification and in the drawings may be changed at will unless otherwise specified.

[0094] Furthermore, with respect to the bulk cargo allocation processing device 1, each component shown in the diagram is a functional concept and does not necessarily need to be physically configured as shown.

[0095] For example, the processing functions of the bulk cargo allocation processing device 1, particularly the control unit 3 and each processing function performed by the control unit 3, may be implemented in whole or in part by a CPU (Central Processing Unit) and a program interpreted and executed by the CPU, or they may be implemented as wired logic hardware. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for the information processing device to execute the processing described in this embodiment, and is mechanically read by the bulk cargo allocation processing device 1 as needed. That is, a storage unit such as ROM or HDD records a computer program that works in cooperation with the OS to give instructions to the CPU and perform various processing. This computer program is executed by being loaded into RAM and works in cooperation with the CPU to constitute the control unit 3.

[0096] Furthermore, the bulk cargo allocation processing program of the bulk cargo allocation processing device 1 may be stored on another server device connected to the bulk cargo allocation processing device 1 via any network, and it is possible to download all or part of it as needed.

[0097] Furthermore, the bulk cargo allocation processing program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program product. Here, "recording medium" includes any "portable physical medium" such as memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical Disks), DVDs (Digital Versatile Disks), and Blu-ray (Registered Trademark) Discs.

[0098] Furthermore, "program" refers to a data processing method described in any language or writing method, regardless of its format, such as source code or binary code. Note that "program" is not necessarily limited to a single, monolithic structure; it also includes distributed structures consisting of multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions. Regarding the specific configuration and reading procedure for reading the recording medium in the bulk cargo allocation processing device 1 shown in the embodiment, as well as the installation procedure after reading, well-known configurations and procedures can be used.

[0099] The storage unit 2 is a storage means such as memory devices like RAM and ROM, fixed disk devices like hard disks, flexible disks, and optical disks, and stores various programs, tables, databases, and web page files used for various processes and website provision.

[0100] Furthermore, the bulk cargo allocation processing device 1 may be configured as a known personal computer device or workstation or other information processing device, or as an information processing device to which any peripheral devices are connected. In addition, the information processing device may be implemented by implementing software (including programs or data, etc.) that realizes the processing described in this embodiment.

[0101] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the illustration, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit according to various additions or functional loads. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Industrial applicability]

[0102] The present invention is particularly suitable for industries that handle goods that are difficult to manage on an owner-by-owner basis, such as raw materials (iron ore, etc.) or paper (roll paper, etc.). [Explanation of Symbols]

[0103] 1. Bulk cargo sorting and processing equipment 2 Storage section 3. Control Unit 4. Communication Interface Section 5 Input / Output Interface Section 6 Input devices 7 Output device 11. Vessel-specific warehousing table 12. Inventory Table by Shipper 13 Pro-rata Table 21 Comparison Section 22 Calculation Section 23 Data Generation Unit 24 Display Control Unit 25 Memory Control Unit

Claims

1. A comparison unit compares the planned inbound quantity of bulk cargo, which is dry or liquid cargo loaded and transported without packaging, with the actual inbound quantity for the day, which is the quantity of bulk cargo actually received, by referring to a shipper-specific inventory table set for each cargo transporter and each shipper for the bulk cargo, When the comparison unit obtains a comparison result showing that the actual daily incoming quantity is less than the planned incoming quantity for each shipper, the calculation unit calculates the actual allocated quantity, which is the quantity for each shipper corresponding to the actual daily incoming quantity, by multiplying the actual daily incoming quantity by an allocation coefficient corresponding to the planned quantity for each shipper, which is the value obtained by dividing the planned quantity for each shipper by the planned incoming quantity. A data generation unit generates inventory data for each shipper, which includes the calculated actual allocation quantity for each shipper as the actual quantity for each shipper. A bulk cargo sorting and processing device.

2. If the calculated actual allocated quantity for each shipper is less than the planned quantity for each shipper, the comparison unit, upon receiving bulk cargo again, compares the added quantity (calculated by adding the actual quantity received on the same day and the actual quantity received on the same day) with the planned quantity received. If the comparison unit obtains a comparison result from the comparison unit indicating that the added quantity obtained by adding the actual daily re-inbound quantity and the actual daily inbound quantity is greater than the planned inbound quantity, the calculation unit calculates a planned supplementary quantity which is the difference between the planned quantity and the actual allocated quantity for each shipper, and then calculates the actual quantity corresponding to the planned quantity for each shipper by adding the calculated planned supplementary quantity and the actual allocated quantity for each shipper. The data generation unit generates the inventory data by consignor, which includes the actual quantity corresponding to the planned quantity as the actual quantity. A bulk cargo sorting apparatus according to claim 1, characterized by the above.

3. The calculation unit calculates the excess quantity, which is the difference between the added quantity obtained by adding the actual daily re-in quantity and the actual daily in-in quantity, and the planned in-in quantity. The data generation unit, by referring to a storage unit that stores information indicating the representative shipper, detects the representative shipper among the respective shippers and generates the shipper-specific inventory data, which includes the actual quantity obtained by adding the excess quantity to the actual quantity of the representative shipper from the actual quantities of each shipper. A bulk cargo sorting apparatus according to claim 2, characterized by the above.

4. If the calculated actual allocated quantity for each shipper is less than the planned quantity for each shipper, the comparison unit, upon receiving bulk cargo again, compares the added quantity (calculated by adding the actual quantity received on the same day and the actual quantity received on the same day) with the planned quantity received. If the calculation unit obtains a comparison result from the comparison unit indicating that the planned incoming quantity is greater than the actual incoming quantity for the day and the sum of the actual incoming quantity for the day, it calculates the actual re-allocated quantity for each shipper by multiplying each shipper's respective allocation coefficient by the actual incoming quantity for the day, and then calculates the actual quantity for each shipper by adding the calculated actual re-allocated quantity for each shipper to each shipper's actual allocated quantity. The data generation unit generates the inventory data for each shipper, including the calculated actual quantity for each shipper. A bulk cargo sorting apparatus according to claim 1, characterized by the above.

5. The data generation unit generates allocation screen data for the allocation screen, which includes the date of receipt of the bulk cargo and the actual allocation quantity for each receipt date. The system further includes a display control unit that, based on the aforementioned allocation screen data, displays the allocation screen on the display unit, which includes the date of receipt of the bulk cargo and the actual allocation quantity for each receipt date. A bulk cargo sorting apparatus according to any one of claims 1 to 4, characterized by the above.

6. The comparison unit performs a comparison step in which it refers to a shipper-specific inventory table, which is set for each cargo transporter and each shipper, that shows the planned incoming quantity of bulk cargo, which is dry or liquid cargo loaded and transported without packaging or wrapping, and compares the planned incoming quantity for each shipper with the actual incoming quantity of bulk cargo on the day. The calculation unit, when the comparison step shows that the actual daily incoming quantity is less than the planned incoming quantity for each shipper, calculates the actual allocated quantity, which is the quantity for each shipper corresponding to the actual daily incoming quantity, by multiplying the actual daily incoming quantity by an allocation coefficient corresponding to the planned quantity for each shipper, which is the value obtained by dividing the planned quantity for each shipper by the planned incoming quantity. The data generation unit generates inventory data for each shipper, which includes the calculated actual allocation quantity for each shipper as the actual quantity for each shipper. A bulk cargo allocation processing device having a bulk cargo allocation processing device and a bulk cargo allocation processing method.

7. Computers, A comparison unit compares the planned inbound quantity of bulk cargo, which is dry or liquid cargo loaded and transported without packaging, with the actual inbound quantity for the day, which is the quantity of bulk cargo actually received, by referring to a shipper-specific inventory table set for each cargo transporter and each shipper for the bulk cargo, When the comparison unit obtains a comparison result showing that the actual daily incoming quantity is less than the planned incoming quantity for each shipper, the calculation unit calculates the actual allocated quantity, which is the quantity for each shipper corresponding to the actual daily incoming quantity, by multiplying the actual daily incoming quantity by an allocation coefficient corresponding to the planned quantity for each shipper, which is the value obtained by dividing the planned quantity for each shipper by the planned incoming quantity. To function as a data generation unit that generates inventory data for each shipper, including the calculated actual allocation quantity for each shipper as the actual quantity for each shipper. A bulk cargo allocation processing program characterized by the following.

Images