JP6824022B2 - Storage fee calculation device, storage fee calculation method and storage fee calculation program - Google Patents

Description

The present invention relates to a storage fee calculation device, a storage fee calculation method, and a storage fee calculation program.

Patent Document 1 discloses a custody tire management system that manages the custody of automobile tires, stores them, and then returns them (see paragraph 0001, etc.).

Japanese Unexamined Patent Publication No. 2013-003871

In the field of inventory storage as described above, the inventory storage fee is the storage fee per inventory to the maximum number of stocks stored in the warehouse within a certain period (hereinafter referred to as "maximum inventory quantity"). It is generally calculated by multiplying the unit price.

For example, as shown in the example of inventory movement on the right side of FIG. 2, when one month is divided into the first period, the second period, and the third period, the maximum inventory quantity in the first period is 10 pieces, 2 Assuming that the maximum number of stocks in the period is 15 and the maximum number of stocks in the third period is 22, the storage fee is obtained by multiplying the total number of maximum stocks in each period, 47, by the unit price of the storage fee per period. calculate.

However, in the past, it has not been possible to systematize the grasp of the maximum inventory quantity, and the person who deposits the inventory calculates the reference value (estimated value) of the storage fee before the formal request from the warehouse company comes. It was difficult. For this reason, the person who deposits the inventory makes the payment by assuming that the request from the inventory storage company is correct, but there is a need to confirm in advance whether or not this request is really correct.

Under the above circumstances, there is a need for a method that can automatically detect the number of inventories that meet the predetermined numerical conditions (typically, the conditions for the maximum number of inventories) set by the person who deposits the inventories and calculate the storage fee. Was being done.

The present invention has been made in view of the above, and is a storage charge calculation device, a storage charge calculation method, and a storage charge that can calculate a storage charge for inventory according to a numerical condition set by an operator regarding the number of stocks. Provide a calculation program.

In order to solve the above-mentioned problems and achieve the object, the storage fee calculation device according to the present invention is a storage fee calculation device including a control unit and a storage unit, and the storage unit includes storage location identification information and storage location identification information. A storage charge unit price master including a storage charge unit price corresponding to this is stored, and the control unit sets a predetermined numerical condition for a certain period from the data set including the input stock quantity and storage location identification information. The storage charge unit price for detecting the storage charge unit price corresponding to the storage location identification information included in the detected data set by referring to the data set detecting means for detecting the data set including the number of stocks to be satisfied and the storage charge unit price master. It is characterized by including a detection means, a storage fee calculation means for calculating a storage fee by multiplying the number of stocks included in the detected data set and the detected storage fee unit price.

Further, in the storage fee calculation device according to the present invention, the predetermined numerical condition is a condition that the number of stocks is the maximum value.

Further, in the storage fee calculation device according to the present invention, the storage unit further stores the storage location identification information and a division number master including the corresponding division number for a certain period, and the data. The set detecting means detects the data set for the number of divisions by detecting the data set for each period after the division for the fixed period, and the storage charge calculation means has the data for the detected number of divisions. The storage fee is calculated by calculating the total number of stocks included in the set and multiplying the total number by the value obtained by dividing the detected storage fee unit price by the number of divisions.

Further, the storage charge calculation device according to the present invention is characterized in that the control unit further includes a storage charge display means for displaying the calculated storage charge.

Further, the storage fee calculation method according to the present invention is a storage fee calculation method executed by an information processing apparatus including a control unit and a storage unit, and the storage location identification information and the corresponding storage are stored in the storage unit. A storage charge unit price master including a charge unit price is stored, and an inventory that satisfies a predetermined numerical value condition for a certain period from the data set including the input number of stocks and the storage location identification information executed by the control unit. A data set detection step for detecting a data set including a number, and a storage charge unit price detection step for detecting a storage charge unit price corresponding to the storage location identification information included in the detected data set by referring to the storage charge unit price master. It is characterized by including a storage fee calculation step of calculating a storage fee by multiplying the number of stocks included in the detected data set and the detected storage fee unit price.

Further, the storage fee calculation program according to the present invention is a storage fee calculation program for being executed by an information processing device including a control unit and a storage unit, and the storage unit includes storage location identification information and corresponding information thereof. A storage charge unit price master including a storage charge unit price is stored, and a predetermined numerical condition is set for a certain period from the data set including the input stock quantity and storage location identification information to be executed by the control unit. The storage charge unit price for detecting the storage charge unit price corresponding to the storage location identification information included in the detected data set by referring to the data set detection step for detecting the data set including the number of stocks to be satisfied and the storage charge unit price master. It is characterized by including a detection step, a storage fee calculation step of calculating a storage fee by multiplying the number of stocks included in the detected data set and the detected storage fee unit price.

According to the present invention, there is an effect that the inventory storage fee can be calculated according to the numerical condition set by the operator regarding the inventory quantity.

FIG. 1 is a block diagram showing an example of the configuration of the storage fee calculation device. FIG. 2 is a diagram showing the relationship between each master and data, and an example of inventory movement. FIG. 3 is a diagram showing an example of a processing flow by the storage fee calculation device. FIG. 4 is a diagram showing an example of a data set relating to D arrival details, D shipment details, inventory quantity, and a detected data set. FIG. 5 is a diagram showing an example of an input screen of the warehouse master. FIG. 6 is a diagram showing an example of an input screen of the product number master. FIG. 7 is a diagram showing an example of an input screen of the warehouse storage fee master. FIG. 8 is a diagram showing an example of a data input screen. FIG. 9 is a diagram showing an example of a screen during the calculation process of the storage fee. FIG. 10 is a diagram showing an example of the calculated storage fee display screen.

Hereinafter, embodiments of a storage fee calculation device, a storage fee calculation method, and a storage fee calculation program according to the present invention will be described in detail with reference to the drawings. The present invention is not limited to this embodiment.

[1. Overview]
In fields such as the food industry where inventory is often managed in consignment warehouses, it is necessary to calculate a reference value for inventory storage charges during a certain period (the period for which storage charges are calculated).

However, in the conventional sales management system, it is not possible to manage the calculation target period that differs for each contract, and as a result, it is not possible to calculate the inventory storage fee for each contract. Further, in the conventional sales management system, it is not possible to calculate the inventory storage fee based on the maximum inventory quantity (so-called maximum inventory quantity) stored in the warehouse during the calculation target period.

For this reason, in many cases, the inventory storage fee was paid with the correct bill from the consignment warehouse vendor.

Therefore, in the present embodiment, by registering the calculation method of the inventory storage fee and the storage fee unit price per inventory in advance for each consignment warehouse, the above-mentioned is obtained from the receipt / payment status of the inventory in the sales management system. We provide a storage fee calculation device, a storage fee calculation method, and a storage fee calculation program that can grasp the maximum number of stocks in the calculation target period and, as a result, calculate a reference value (estimated value) of the inventory storage fee. Hereinafter, a specific configuration and operation will be described.

[2. Constitution]
The configuration of the storage fee calculation device 100 according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the storage fee calculation device 100.

The storage fee calculation device 100 is a commercially available desktop personal computer. The storage fee calculation device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a portable notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, a tablet personal computer, or the like on the market. It may be a type information processing device.

As shown in FIG. 1, the storage charge calculation device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the storage charge calculation device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the storage charge calculation device 100 to the network 300 so as to be communicable via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the storage fee calculation device 100 and the server 200 so as to be able to communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). The data stored in the storage unit 106, which will be described later, may be stored in the server 200.

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

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving a command to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used.

The storage unit 106 includes D arrival details 106a, D shipment details 106b, D movement details 106c, D transfer details 106d, D inventory 106e, a warehouse master 106f as a division number master, and a storage fee unit price master. It includes a warehouse storage fee master 106g and a product number master 106h. Of these masters, except for the warehouse storage fee master 106 g, it is an arbitrary component, but it is preferably included in the storage unit 106.

The contents of each master and the items included in each data will be described in detail with reference to FIGS. 2 to 8. FIG. 2 is a diagram showing the relationship between each master and data, and an example of inventory movement. FIG. 3 is a diagram showing an example of a processing flow by the storage fee calculation device. FIG. 4 is a diagram showing an example of a data set relating to D arrival details, D shipment details, inventory quantity, and a detected data set. FIG. 5 is a diagram showing an example of an input screen of the warehouse master. FIG. 6 is a diagram showing an example of an input screen of the product number master. FIG. 7 is a diagram showing an example of an input screen of the warehouse storage fee master. FIG. 8 is a diagram showing an example of a data input screen.

In the following description, the notation in parentheses after each item is a specific example of each item, and the drawings show a specific example of each item. For example, when the storage location identification information (warehouse code) is described, it means that the warehouse code can be given as a specific example of the storage location identification information.

D arrival details 106a include information on inventory that arrives at the storage location. Specifically, as shown in the arrival data table of FIG. 4, D arrival details 106a contains information such as, for example, arrival number, storage fee start date, storage location identification information (warehouse code), product code, and number of arrivals. including. The storage fee start date is the date when inventory storage starts. The storage location identification information is information for identifying the storage location. The storage location identification information may be a specific name or a code such as an alphabet or a number. These pieces of information can be entered through the data entry screen of FIG.

D Shipment details 106b includes information on inventory to be shipped from the storage location. Specifically, as shown in the shipping data table of FIG. 4, the D shipping detail 106b contains information such as, for example, a shipping number, a storage fee end date, a storage location identification information (warehouse code), a product code, and the number of shipments. including. The storage fee end date is the date when the stored inventory is delivered. These pieces of information can be entered through the data entry screen of FIG.

From D arrival details 106a and D shipment details 106b, a table of temporary work for calculating storage charges in FIG. 4 is created. The horizontal row in this table is referred to as a data set in the following. In the data set, the current day unstocked quantity and the previous day unstocked quantity mean the final stock quantity existing in the warehouse at the end of the current day and the final stock quantity existing in the warehouse at the end of the previous day, respectively. Therefore, the number of unstocked items on the current day in a certain data set and the number of unstocked items on the previous day in the data set one row below are equal values. For example, as shown in the table of temporary work for calculating storage charges in FIG. If the number of unstocked items on the day in the dataset with the start date of 2016/04/02 is 5, the number of unstocked items on the previous day in the dataset with the storage fee start date of 2016/04/05 is also 5 pieces. Become. Further, in the data set, the number of goods received on the day and the number of goods issued on the day mean the number of stocks received on the day and the number of stocks issued at that time, respectively. Then, in the data set, the maximum inventory quantity on the day means the maximum inventory quantity on the day, and the maximum inventory quantity on the day is the detection target of the data set detection unit 102a. The maximum number of stocks on the day can be calculated by the number of stocks not in stock on the previous day + the number of goods received on the day. For example, as shown in the table of the temporary work for calculating the storage charge in FIG. In the set, the number of unstocked items on the previous day (5 pieces) + the number of items received on the day (10 pieces) = the maximum number of items in stock on the day (15 pieces).

The data set detection unit 102a detects a data set including the number of stocks satisfying a predetermined numerical condition in a certain period, and the certain period is the temporary storage fee calculation in FIG. 4 in the present embodiment. Refers to the period from 2016/04/01 to 2016/04/30 in the leftmost column of the work table.

The D movement detail 106c includes, for example, information such as a product code, a movement date, and the number of movements of goods that have been received / delivered by the warehouse movement.

The D transfer details 106d include, for example, information such as the product code of the product received / delivered by changing the product code or processing, the transfer date, and the number of goods received / delivered.

The D inventory 106e includes, for example, information such as a product code, an inventory date, and the number of receipts and withdrawals of products that have been received and delivered by the inventory processing.

As shown in FIG. 2, the warehouse master 106f includes storage location identification information (warehouse code) and the corresponding number of divisions for a certain period (storage fee calculation period system). The number of divisions is a numerical value indicating how many divisions the fixed period is to be divided. For example, in the case of the present embodiment, when the three-period system (that is, the number of divisions is 3) is selected on the input screen of the warehouse master of FIG. 5, the data set detection unit 102a performs the fixed period (2016/04/01). From 2016/04/30 to 2016/04/30), 2016/04/01 to 2016/04/10, 2016/04/11 to 2016/04/20, 2016/04/21 to 2016/04 By detecting the data set every three periods up to / 30, a total of three data sets are detected. Each information included in the warehouse master 106f can be input through the input screen of the warehouse master of FIG.

As shown in FIG. 2, the warehouse storage fee master 106 g includes storage location identification information (warehouse code) and a corresponding storage fee unit price. The storage fee unit price is set according to the storage location identification information, and during the certain period (from 2016/04/01 to 2016/04/30 in this embodiment), one inventory is charged. This is the unit price for storage. For example, in the warehouse code A, when the inventory is stored during the certain period, the storage fee unit price can be set to 30,000 yen.

When the fixed number of divisions is 2 or more, the value obtained by dividing the storage charge unit price by the division number becomes the storage charge unit price per period, which is the value used for calculating the inventory storage charge. For example, when the storage fee unit price is 30,000 yen and the number of divisions in the fixed period is 3, 30,000 yen ÷ 3 = 10,000 yen is the storage fee unit price per period. Based on this storage fee unit price of 10,000 yen per period, for example, in the example of inventory movement on the right in Fig. 2, the total number of maximum inventory on the day in each of the three periods x storage fee unit price per period = 47 pieces x It is calculated as 10,000 yen = 470,000 yen.

The warehouse storage fee master 106g may further include information on the storage fee classification, as shown in FIG. The storage fee category is a category that is set for each product and serves as a reference for setting the storage fee unit price. For example, there are categories such as normal temperature, low temperature, frozen, and dangerous goods. Each information included in the warehouse storage fee master 106g can be input through the input screen of the warehouse storage fee master of FIG. 7.

As described above, at least the storage location identification information is required to set the storage fee unit price, but in addition to this, the storage fee unit price may be set in consideration of the storage fee classification. For example, the storage fee unit price corresponding to warehouse code A is 30,000 yen, but when the storage fee classification is dangerous goods, the storage fee unit price is increased because special qualifications are required to handle inventory. It can be set to 40,000 yen.

As shown in FIG. 2, the product number master 106h includes, for example, information such as a product code and a storage fee classification. If the product number master 106h exists, the product number master 106h and the warehouse storage charge master g are linked through the storage charge classification included in both masters, whereby the storage charge is linked according to the combination of the product code and the storage location identification information. The unit price can be set. For example, the product number master 106h includes S1 as the product code and normal temperature as the storage charge category, while the warehouse storage charge master g includes A as the warehouse code, normal temperature as the storage charge category, and 10,000 yen as the storage charge unit price. Suppose to include. In this case, the storage fee unit price corresponding to the combination of the product code S1 and the warehouse code A is 10,000 yen. Each information included in the product number master 106h can be input through the input screen of the product number master of FIG.

The control unit 102 is a CPU or the like that comprehensively controls the storage charge calculation device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Execute.

Functionally, the control unit 102 functionally conceptually detects (1) data including a data set including a stock quantity satisfying a predetermined numerical condition in a certain period from the data set including the input stock quantity and storage location identification information. Storage charge unit price detection that detects the storage charge unit price corresponding to the storage location identification information included in the detected data set by referring to the data set detection unit 102a as the set detection means and (2) the storage charge unit price master. As a storage fee calculation means for calculating a storage fee by multiplying the storage fee unit price detection unit 102b as a means, (3) the number of stocks included in the detected data set, and the detected storage fee unit price. It includes a storage charge calculation unit 102c, and (4) a storage charge display unit 102d as a storage charge display means for displaying the calculated storage charge. Of these, the storage fee display unit 102d is an arbitrary component, but the following [3. Specific example of processing], it is preferable that the control unit 102 is included for the reason described in detail. For details of the processing executed by each part, see [3. Specific example of processing] will be described in detail.

[3. Specific example of processing]
Hereinafter, specific examples of the processing according to the present embodiment will be described in detail with reference to FIGS. 3, 4, 9, and 10. FIG. 3 is a diagram showing an example of a processing flow by the storage fee calculation device. FIG. 4 is a diagram showing an example of a data set relating to D arrival details, D shipment details, inventory quantity, and a detected data set. FIG. 9 is a diagram showing an example of a screen during the calculation process of the storage fee. FIG. 10 is a diagram showing an example of the calculated storage fee display screen. The outline of the process is as follows: [2. From each data and each master described in [Structure], a warehouse storage fee list showing inventory storage fees is created as shown in the processing flow of FIG.

Here, in the present embodiment, whether the fixed period to be detected by the data set detection unit 102a is not divided (that is, one-term system) or is divided (that is, two-term system or more). The content of the process differs depending on the type. Therefore, first, the case of the one-term system will be described, and then the case of the two-term system or more will be described.

[In the case of 3-1.1 period system]
First, the case of the one-term system will be described. That is, as shown in the table of the storage fee calculation temporary work of FIG. 4, the case where the fixed period is one period from 2016/04/01 to 2016/04/30 will be described.

(Data set detection process)
As shown in the table of the storage charge calculation temporary work of FIG. 4, the data set detection unit 102a has the data set including the input maximum number of stocks on the day and the warehouse code from 2016/04/01 to 2016/04/30. Performs a data set detection process for detecting a data set including the number of stocks satisfying a predetermined numerical condition in the period up to.

Here, the predetermined numerical conditions include a condition that the maximum number of stocks on the day is the maximum value, a condition that the maximum value is the minimum value, a condition that the average value (or a moving average value) in a certain period, and the like. Can be given. In the present embodiment, the case where the predetermined numerical condition is the condition that the maximum number of stocks on the day is the maximum value will be described.

With reference to the table of temporary work for calculating storage charges in FIG. 4, the maximum number of stocks on the day is 35 in the period from 2016/04/01 to 2016/04/30. It can be seen that the data set is the first line from the bottom (the storage fee starts on 2016/04/30).

From the above, the data set detection unit 102a detects the data set (storage fee start is 2016/04/30) in the first row from the bottom, in which the maximum number of stocks on the day is 35.

The detected data set may be shown as a table as shown in the table of “Warehouse storage fee data 1-term system” in FIG. In the above table, the maximum inventory quantity during one period is the maximum inventory quantity on the day during the period from 2016/04/01 to 2016/04/30, and as shown in the table of temporary work for calculating storage charges in FIG. There are 35 pieces, and the number of stocks at the end of the first period is the number of stocks not in stock on the last day of the period from 2016/04/01 to 2016/04/30, as shown in the table of temporary work for calculating storage charges in FIG. , 25 pieces. Further, since this embodiment is a case of a one-term system, the items of the maximum inventory number during the second term, the maximum inventory number during the second term, the maximum inventory number during the third term, and the inventory number at the third term are 0 in the above table. In the above table, the number of warehousing in the current month is the total number of warehousing on the day in April 2016, and is calculated as 10 + 0 + 10 + 0 + 15 + 0 + 20 + 0 + 10 + 0 + 20 = 85. In the above table, the number of goods issued in the current month is the total number of goods issued on the day in April 2016, and is calculated as 0 + 5 + 0 + 10 + 0 + 10 + 0 + 20 + 0 + 5 + 10 = 60. In the above table, the number of unstocked 25 in the current month is the data set at the end of the current month in the temporary work for calculating the storage fee in FIG. 4, that is, the data set in the first row from the bottom (the storage fee starts on 2016/04/30). It is the same value as the number of stocks 25.

(Storage fee unit price detection processing)
Subsequently, the storage fee unit price detection unit 102b refers to the warehouse storage fee master 106g and sets the warehouse code A included in the data set (storage fee start is 2016/04/30) in the first line from the bottom of the detection. Performs storage charge unit price detection processing to detect the corresponding storage charge unit price.

Although not shown, the storage fee unit price corresponding to the warehouse code A is assumed to be 30,000 yen / period.

(Storage fee calculation process)
Subsequently, the storage fee calculation unit 102c calculates the storage fee by multiplying the maximum number of stocks on the day (35 pieces) included in the detected data set and the detected storage fee unit price (30,000 yen). , 35 pieces x 30,000 yen = 1,050,000 yen The storage fee calculation process is performed. FIG. 9 shows an example of the screen during the storage fee calculation process. In the processing progress column of FIG. 9, the completed processing is displayed at any time.

(Storage fee display processing)
Finally, the storage fee display unit 102d performs a display process for displaying the calculated storage fee of 1,050,000 yen. Although the storage fee display unit 102d is an arbitrary component, the operator can quickly grasp the calculated storage fee by including the storage fee display unit 102d in the storage fee calculation device 100 according to the present embodiment.

[For 3-2.2 period or higher]
Next, the case of two-term system or more will be described. Here, in the case of the three-term system, that is, the number of divisions of the fixed period (from 2016/04/01 to 2016/04/30) is 3, and the fixed period is 2016/04/01. To 2016/04/10, 1st period, 2016/04/11 to 2016/04/20, 2nd period, 2016/04/21 to 2016/04/30, 3 periods will be described. ..

Also in this embodiment, the predetermined numerical condition is a condition that the maximum number of stocks on the day is the maximum value.

(Data set detection process)
The data set detection unit 102a detects the data set for the number of divisions (three) by detecting the data set for each period after the division of the fixed period.

Specifically, as shown in the table of the storage charge calculation temporary work of FIG. 4, the data set detection unit 102a starts from 2016/04/01 from the data set including the input maximum stock quantity on the day and the warehouse code. As the data set with the maximum number of stocks on the day in the period until 2016/04/10, the data set on the fifth line from the top with the maximum number of stocks on the day is 20 (the storage fee starts on 2016/04/10) ) Detects the dataset.

The data set detection unit 102a performs the same processing as this, and as shown in the table of the storage charge calculation temporary work of FIG. 4, the maximum data set on the day is as a data set in the period from 2016/04/11 to 2016/04/20. From 2016/04/21 to 2016/04/30, the data set on the 7th or 8th line (storage fee start is 2016/04/15 or 2016/04/16) with 30 pieces in stock As the data set in the period of, the data set of the first row from the bottom (the storage fee start is 2016/04/30) in which the maximum number of stocks on the day is 35 is detected.

By the above processing, the data set detection unit 102a has detected three data sets having a maximum inventory quantity of 20, 30, and 35.

The detected data set may be shown as a table as shown in the table of “Warehouse storage fee data in the case of the three-term system” in FIG. The meaning of each item in the table is the same as the description in the item [3-1].

(Storage fee unit price detection processing)
Subsequently, the storage charge unit price detection unit 102b refers to the warehouse storage charge master 106g in the same manner as in the item [3-1], and the storage charge unit price corresponding to the warehouse code A included in the detected data set. As a result, 30,000 yen is detected.

(Storage fee calculation process)
Subsequently, the storage fee calculation unit 102c calculates the total number of inventories (20 + 30 + 35 = 85) included in the three detected data sets, and the total (85) and the detection. By multiplying the storage fee unit price (30,000 yen) divided by the number of divisions (3) in the fixed period (30,000 yen ÷ 3 = 10,000 yen), the storage fee is 85. The storage fee calculation process is performed to calculate the number of pieces x 10,000 yen = 850,000 yen. The value of 10,000 yen is the so-called per-period storage fee unit price described above.

(Storage fee display processing)
Finally, the storage fee display unit 102d performs a display process for displaying the calculated storage fee of 850,000 yen by the same process as in the item [3-1]. An example of the calculated storage fee display screen is shown in FIG. As for the effect of this processing, the explanation in the above item [3-1] can be referred to.

In the case of the two-term system, that is, the number of divisions in the fixed period (from 2016/04/01 to 2016/04/30) is 2, and the fixed period is from 2016/04/01 to 2016/ In the case of being divided into one period until 04/15 and two periods from 2016/04/16 to 2016/04/30, the inventory storage fee can be calculated by the same method as in the case of the three period system. it can. That is, the data set detection unit 102a has the data set on the seventh row from the top (the storage fee starts on 2016/04/15) and the maximum inventory on the day of 35, which is 1 from the bottom. The data set of the line (storage fee start is 2016/04/30) is detected. Subsequently, the storage fee unit price detection unit 102b detects 30,000 yen as the storage fee unit price corresponding to the warehouse code A. Subsequently, the storage fee calculation unit 102c calculates the storage fee as (30 pieces + 35 pieces) × (30,000 yen ÷ 2) = 65 pieces × 15,000 yen = 975,000 yen.

As described above, according to the storage charge calculation device 100 according to the present embodiment, the storage charge for inventory can be calculated according to the numerical condition set by the operator regarding the number of stocks.

Further, according to the storage fee calculation device 100 according to the present embodiment, for example, even when the fixed period is divided, the numerical conditions set by the operator are satisfied for each period after the division of the fixed period. It is possible to detect the number of stocks to be stored and calculate the stock storage fee. As a result, the storage fee calculation device 100 according to the present embodiment, for example, divides one month into the first period, the second period, and the third period, and calculates the maximum inventory quantity in each period. It is also possible to deal with the transaction form that is carried out.

Then, according to the storage fee calculation device 100 according to the present embodiment, for example, even if the storage fee unit price is different because the storage fee is stored in different warehouses in each of the above periods, the inventory storage fee is as follows. Can be calculated in. For example, the number of stocks in the first period is 10, the storage fee unit price of warehouse A is 30,000 yen, the number of stocks in the second period is 20, and the storage fee unit price of warehouse B is 330,000 yen, the third period. If the number of stocks in the eye is 30 and the storage fee unit price of warehouse C is 36,000 yen, the storage fee calculation unit 102c sets the stock storage fee to 10 pieces x (30,000 yen / 3) + 20 pieces. It can be calculated as × (33,000 yen ÷ 3) + 30 pieces × (36,000 yen ÷ 3) = 100,000 + 220,000 yen + 360,000 yen = 680,000 yen.

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

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

In addition, the processing procedure, control procedure, specific name, information including parameters such as registration data and search conditions of each processing, screen examples, and database configuration shown in the present specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the storage fee calculation device 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

For example, with respect to the processing functions included in the storage charge calculation device 100, particularly each processing function performed by the control unit 102, all or any part thereof is realized by the CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the process described in the present embodiment, and a storage fee is calculated as necessary. It is read mechanically by the device 100. That is, in a storage unit such as a ROM or an HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into RAM, and constitutes a control unit in cooperation with a CPU.

Further, this computer program may be stored in the application program server connected to the storage charge calculation device 100 via an arbitrary network, and all or a part thereof can be downloaded as needed. Is.

Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EPROM (registered). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disk), MO (Magnet-Optical Disk), Digital Disk, DVD (Digi), DVD (Digital) It shall include any "portable physical medium". Therefore, a recording medium containing a program for executing a process or a process method as described in the present specification also constitutes the present invention.

Further, the "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as a plurality of modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. A well-known configuration and procedure can be used for a specific configuration and reading procedure for reading the recording medium in each device shown in the embodiment, an installation procedure after reading, and the like.

Various databases and the like stored in the storage unit 106 are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

Further, the storage fee calculation device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the storage fee calculation device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the device.

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

The present invention is particularly useful in fields such as the food industry where inventory is often managed in consignment warehouses.

100 Storage fee calculation device
102 Control unit
102a Data set detector
102b Storage fee unit price detector
102c Storage fee calculation unit
102d Storage fee display
104 Communication interface section
106 Storage
106a D arrival details
106b D shipping details
106c D movement details
106d D transfer details
106e D inventory
106f Warehouse master
106g Warehouse storage fee master
106h Part number master
108 Input / output interface
112 Input device
114 Output device 200 Server 300 Network

Claims (5)

A storage fee calculation device equipped with a control unit and a storage unit.
In the storage unit
A storage fee unit price master that includes storage location identification information and the corresponding storage fee unit price ,
A division number master including the storage location identification information and the corresponding division number for a certain period,
Is stored,
The control unit
From the data set including the input stock quantity and storage location identification information, the stock quantity that satisfies a predetermined numerical value condition in the split period after the split for the fixed period in the split master. A data set detecting means for detecting a number of data sets corresponding to the number of divisions in the number of divisions master by detecting the including data sets.
With reference to the storage charge unit price master, a storage charge unit price detecting means for detecting the storage charge unit price corresponding to the storage location identification information included in the detected data set, and
The included in the number of data sets corresponding to the division number of the detected said in division number master was calculated sum in stock, and the sum value and the storage charges bid that the detected divided by the number of divisions , by multiplying the a storage fee calculation means for calculating a storage fee,
To prepare
A storage fee calculation device characterized by. The predetermined numerical condition is that the number of stocks is the maximum value.
The storage fee calculation device according to claim 1. The control unit further includes a storage charge display means for displaying the calculated storage charge.
The storage fee calculation device according to claim 1 or 2 . A storage fee calculation method executed by an information processing device including a control unit and a storage unit.
In the storage unit
A storage fee unit price master that includes storage location identification information and the corresponding storage fee unit price ,
A division number master including the storage location identification information and the corresponding division number for a certain period,
Is stored,
Executed by the control unit,
From the data set including the input stock quantity and storage location identification information, the stock quantity that satisfies a predetermined numerical value condition in the split period after the split for the fixed period in the split master. A data set detection step of detecting a number of data sets corresponding to the number of divisions in the division number master by detecting the including data set, and
A storage fee unit price detection step for detecting a storage fee unit price corresponding to the storage location identification information included in the detected data set with reference to the storage fee unit price master, and a storage fee unit price detection step.
The included in the number of data sets corresponding to the division number of the detected said in division number master was calculated sum in stock, and the sum value and the storage charges bid that the detected divided by the number of divisions The storage fee calculation step to calculate the storage fee by multiplying by
Including,
A storage fee calculation method characterized by. It is a storage fee calculation program to be executed by an information processing device including a control unit and a storage unit.
In the storage unit
A storage fee unit price master that includes storage location identification information and the corresponding storage fee unit price ,
A division number master including the storage location identification information and the corresponding division number for a certain period,
Is stored,
To make the control unit execute
From the data set including the input stock quantity and storage location identification information, the stock quantity that satisfies a predetermined numerical value condition in the split period after the split for the fixed period in the split master. A data set detection step of detecting a number of data sets corresponding to the number of divisions in the division number master by detecting the including data set, and
A storage fee unit price detection step for detecting a storage fee unit price corresponding to the storage location identification information included in the detected data set with reference to the storage fee unit price master, and a storage fee unit price detection step.
The included in the number of data sets corresponding to the division number of the detected said in division number master was calculated sum in stock, and the sum value and the storage charges bid that the detected divided by the number of divisions The storage fee calculation step to calculate the storage fee by multiplying by
Including,
A storage fee calculation program characterized by.

Images