JP2018101278A - Storage fee calculation apparatus, storage fee calculation method, and storage fee calculation program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a storage fee calculation apparatus, a storage fee calculation method and a storage fee calculation program that are capable of calculating a storage fee of stock in accordance with a numerical condition which an operator has set with regard to quantity of stock.SOLUTION: In the present embodiment, a storage fee calculation apparatus (1) detects a data set including quantity of stock that satisfies a predetermined numerical condition in a certain period from among a data set including inputted quantity of stock and storage place identification information, (2) refers to a storage fee master including storage place identification information and a storage fee unit price that corresponds to the storage place identification information, and detects a storage fee unit price that corresponds to storage place identification information included in the detected data set, and (3) calculates a storage fee by multiplying the quantity of stock included in the detected data set and the detected storage fee unit price together.SELECTED DRAWING: Figure 4

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 car tires that are stored and returned after being stored (see paragraph 0001, etc.).

JP 2013-003871 A

  In the field of stock storage as described above, the stock storage fee is the maximum stock number stored in the warehouse within a certain period of time (hereinafter referred to as “the maximum stock number”), and the storage fee per stock. Generally, it is 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 number of inventory in the first period is 10 2 Assuming that the maximum inventory quantity in the period is 15 and the maximum inventory quantity in the third period is 22, the storage fee is calculated by multiplying the total inventory quantity of 47 in each period by the storage unit price 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 operator comes. It was difficult. For this reason, the person who keeps the inventory pays the bill from the inventory storage company as correct, but there is a need to confirm in advance whether or not the request is really correct.

  Due to the circumstances as described above, a method for automatically detecting the number of stocks satisfying a predetermined numerical condition (typically, the condition of the maximum stock quantity) set by a person who deposits stock and calculating a storage fee is required. It was done.

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

  In order to solve the above-described problems and achieve the object, a 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 A storage fee unit price master including a storage fee unit price corresponding to this is stored, and the control unit sets a predetermined numerical condition in a certain period from the data set including the input stock quantity and storage location identification information. A storage set unit for detecting a storage unit price corresponding to the storage location identification information included in the detected data set by referring to the storage unit unit price master and a data set detection unit that detects a data set including a stock quantity to be satisfied. A storage means calculating means for calculating a storage fee by multiplying the detection means and the number of stocks included in the detected data set and the detected storage fee unit price. It features a.

  In the storage fee calculation apparatus according to the present invention, the predetermined numerical condition is a condition that the stock quantity is a maximum value.

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

  Moreover, the storage fee calculation apparatus according to the present invention is characterized in that the control unit further includes storage fee display means for displaying the calculated storage fee.

  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. The storage unit stores storage location identification information and storage corresponding to the storage location identification information. A storage fee unit price master including a charge unit price is stored, and a stock satisfying a predetermined numerical condition for a certain period from a data set including the input inventory number and storage location identification information executed by the control unit. A data set detecting step for detecting a data set including a number, and a storage fee unit price detecting 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 calculation step of calculating a storage fee by multiplying the number of stocks included in the detected data set by the detected storage fee unit price, and Include, characterized.

  The storage fee calculation program according to the present invention is a storage fee calculation program for causing an information processing apparatus including a control unit and a storage unit to execute, and the storage unit corresponds to storage location identification information and the storage location identification information. A storage fee unit price master including a storage fee unit price is stored, and a predetermined numerical condition is set for a certain period from a data set including the input inventory quantity and storage location identification information to be executed by the control unit. A data set detection step for detecting a data set including a stock quantity to be satisfied, and a storage fee unit price 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. The storage fee is calculated by multiplying the detection step, the number of stocks included in the detected data set, and the detected storage fee unit price. It includes a storage fee calculation step that the features a.

  According to the present invention, the stock storage fee can be calculated according to the numerical condition set by the operator regarding the number of stocks.

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

  Hereinafter, embodiments of a storage fee calculation apparatus, 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. In addition, this invention is not limited by this embodiment.

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

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

  For this reason, in many cases, the stock storage fee is paid based on the correct billing from the consignment warehouse.

  Therefore, in the present embodiment, for each consigned warehouse, the inventory storage fee calculation method and the storage fee unit price per inventory are registered in advance, so that the inventory receipt / payment status in the sales management system can be The present invention provides a storage fee calculation device, a storage fee calculation method, and a storage fee calculation program capable of grasping the maximum number of inventory in a calculation target period and, as a result, calculating a reference value (estimated value) of the inventory storage fee. Hereinafter, a specific configuration and operation will be described.

[2. Constitution]
A configuration of the storage fee calculation apparatus 100 according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram illustrating an example of the configuration of the storage fee calculation apparatus 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 personal computer such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer. It may be a type information processing apparatus.

  As shown in FIG. 1, the storage fee calculation apparatus 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the storage fee calculation apparatus 100 is connected to be communicable via an arbitrary communication path.

  The communication interface unit 104 connects the storage fee calculation device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of connecting the storage fee calculation device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that data stored in the storage unit 106 to 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 (including a home television), a speaker, and a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that realizes a pointing device function in cooperation with the mouse can be used. In the following description, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

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

  The storage unit 106 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. A warehouse storage fee master 106g and a product number master 106h are provided. Of these masters, components other than the warehouse storage fee master 106g are optional components, but are preferably included in the storage unit 106.

  The contents of items included in each master and each data will be described in detail with reference to FIGS. FIG. 2 is a diagram illustrating a relationship between each master and data, and an example of inventory movement. FIG. 3 is a diagram illustrating an example of a processing flow by the storage fee calculation apparatus. FIG. 4 is a diagram illustrating an example of a data set related to D arrival details, D shipment details, the number of stocks, and a detected data set. FIG. 5 is a diagram illustrating an example of an input screen of the warehouse master. FIG. 6 is a diagram illustrating an example of the input screen of the product number master. FIG. 7 is a diagram illustrating an example of an input screen for a warehouse storage fee master. FIG. 8 is a diagram illustrating 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 in the drawings, a specific example of each item is shown. For example, when the storage location identification information (warehouse code) is described, it means that a warehouse code is given as a specific example of the storage location identification information.

  The D arrival details 106a includes information on stocks that arrive at the storage location. Specifically, as shown in the arrival data table of FIG. 4, the D arrival details 106 a includes information such as an arrival number, a storage fee start date, storage location identification information (warehouse code), a product code, and the number of arrivals, for example. including. The storage fee start date is the date on which stock 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 may be a code such as alphabet or numeral. Such information can be input through the data input screen of FIG.

  The D shipment details 106b include information on the inventory shipped from the storage location. Specifically, as shown in the shipment data table of FIG. 4, the D shipment details 106b include information such as a shipment number, a storage fee end date, 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 stock is issued. Such information can be input through the data input screen of FIG.

  The storage fee calculation temporary work table of FIG. 4 is created from the D arrival details 106a and the D shipment details 106b. The horizontal line in this table is hereinafter referred to as a data set. In the data set, the number of unstocked items on the current day and the number of unstocked items on the previous day mean the final stock number existing in the warehouse at the end of the current day and the final inventory number existing in the warehouse at the previous end. For this reason, the number of unstocked items on the current day in a certain data set and the number of unstocked items in the previous day in the data set below that line are the same value. For example, as shown in the table of storage fee calculation temporary work in FIG. If the number of unstocked items on the current day in the dataset whose start date is 2016/04/02 is 5, the number of unstocked items on the previous day in the dataset whose storage fee start date is 2016/04/05 is 5 Become. 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 on that day, respectively. In the data set, the maximum stock quantity on the current day means the maximum stock quantity on the current day, and the maximum stock quantity on the current day is a detection target of the data set detection unit 102a. The maximum stock quantity on the day can be calculated by the number of unstocked the previous day + the number of goods received on the day. For example, as shown in the table of temporary storage charge calculation work in FIG. 4, data with a storage charge start date of 2016/04/05 is shown. In the set, the number of unstocked the previous day (5) + the number of goods received on the day (10) = the maximum number of inventory on the day (15).

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

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

  The D transfer details 106d include, for example, information such as a product code, a transfer date, and the number of warehouses / warehouses of products that are received and delivered by product code change and processing.

  The D inventory 106e includes, for example, information such as a product code, an inventory date, and the number of receipts and receipts of the goods that are received and delivered by the inventory process.

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

  As shown in FIG. 2, the warehouse storage fee master 106g includes storage location identification information (warehouse code) and the storage fee unit price corresponding thereto. The unit price of the storage fee is set according to the storage location identification information. During the predetermined period (in the present embodiment, from 2016/04/01 to 2016/04/30), the storage fee unit price The unit price for storage. For example, when stock is stored in the warehouse code A for the certain period, the storage unit price can be set to 30,000 yen.

  When the predetermined number of divisions is 2 or more, a value obtained by dividing the storage fee unit price by the number of divisions is a storage fee unit price per period, which is a value used for calculating the stock storage fee. For example, if the storage fee unit price is 30,000 yen and the number of divisions in the certain period is 3, 30,000 yen ÷ 3 = 10,000 yen is the storage fee unit price per period. Based on the storage fee unit price per 10,000 yen period, for example, in the example of inventory movement on the right in FIG. 2, the total of the maximum number of inventory on the day in each of the three periods × storage charge unit price per period = 47 × Calculated as 10,000 yen = 470,000 yen.

  The warehouse storage fee master 106g may further include information on storage fee categories 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 unit price of the storage fee. For example, there are categories such as room temperature, low temperature, freezing, 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 in FIG.

  As described above, at least the storage location identification information is required for setting the storage fee unit price. In addition to this, the storage fee unit price may be set in consideration of the storage fee category. For example, the storage fee unit price corresponding to the warehouse code A is 30,000 yen, but when the storage fee category is dangerous goods, the storage fee unit price should be increased due to the necessity of special qualification for inventory handling. It can be set to 40,000 yen.

  As shown in FIG. 2, the product number master 106h includes information such as product codes and storage fee categories. If the product number master 106h exists, the product number master 106h and the warehouse storage fee master g are linked through the storage fee classification included in both masters, whereby the storage fee is determined according to the combination of the product code and the storage location identification information. Unit price can be set. For example, the product number master 106h includes S1 as the product code and normal temperature as the storage fee category, while the warehouse storage fee master g has A as the warehouse code, normal temperature as the storage fee category, and 10,000 yen as the storage fee unit price. 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 in FIG.

  The control unit 102 is a CPU or the like that controls the storage fee calculation apparatus 100 in an integrated manner. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, and necessary data, and performs various information processing based on these stored programs. Run.

  The control unit 102 is functionally conceptually (1) Data for detecting a data set including a stock quantity satisfying a predetermined numerical condition in a certain period from a data set including the input stock quantity and storage location identification information. A data set detection unit 102a as a set detection means; and (2) storage fee unit price detection for detecting a storage fee unit price corresponding to storage location identification information included in the detected data set with reference to the storage fee 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, and (3) the number of stocks included in the detected data set and the detected storage fee unit price. A storage fee calculation unit 102c, and (4) a storage fee display unit 102d as storage fee display means for displaying the calculated storage fee. Among these, the storage fee display part 102d is an arbitrary component, but the following [3. It is preferably included in the control unit 102 for the reason described in detail in the specific example of processing]. The details of the processing executed by each unit are described in [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 illustrating an example of a processing flow by the storage fee calculation apparatus. FIG. 4 is a diagram illustrating an example of a data set related to D arrival details, D shipment details, the number of stocks, and a detected data set. FIG. 9 is a diagram illustrating an example of a screen during storage fee calculation processing. FIG. 10 is a diagram illustrating an example of a display screen for the calculated storage fee. As an outline of processing, [2. As shown in the processing flow of FIG. 3, a warehouse storage fee list indicating stock storage fees is created from each data and each master described in [Configuration].

  Here, in the present embodiment, whether a certain period to be detected by the data set detection unit 102a is not divided (that is, one period system) or is divided (that is, two period system or more). Depending on the process, the contents of the process differ. For this reason, first, the case of the one-period system will be described, and then the case of the two-period system or more will be described.

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

(Data set detection processing)
As shown in the table of storage fee calculation temporary work in FIG. 4, the data set detection unit 102a selects from the data sets including the inputted maximum stock quantity on the day and the warehouse code from 2016/04/01 to 2016/04/30. Data set detection processing for detecting a data set including the number of stocks satisfying a predetermined numerical condition in the period up to is performed.

  Here, the predetermined numerical condition is a condition that the maximum stock quantity on the day is the maximum value, a condition that it is the minimum value, a condition that it is an average value (or moving average value) in a certain period, etc. Can be given. In the present embodiment, the case where the predetermined numerical condition is a condition that the maximum stock quantity on the day is the maximum value will be described.

  Referring to the table of temporary storage fee calculation work in FIG. 4, the maximum stock number on the day is the maximum value during the period from 2016/04/01 to 2016/04/30. It can be seen that this is the data set in the first row from the bottom (the storage fee start is 2016/04/30).

  As described above, the data set detection unit 102a detects the data set in the first row from the bottom (the storage fee start is 2016/04/30) having a maximum stock quantity of 35 on the day.

  The detected data set may be shown as a table, as shown in the table of “warehouse storage fee data 1-period system” in FIG. In the table, the maximum inventory quantity during one period is the maximum inventory quantity on the day in the period from 2016/04/01 to 2016/04/30. As shown in the table of temporary storage fee calculation work in FIG. The number of stocks at the end of 1st period is 35, which is the number of unstocked items on the last day of the period from 2016/04/01 to 2016/04/30. As shown in the table of temporary storage fee calculation work in FIG. , 25. In addition, since the present embodiment is based on the one-period system, the items of the maximum inventory quantity in the second period, the inventory quantity at the end of the second period, the maximum inventory quantity in the third period, and the inventory quantity at the end of the period are 0 in the table. In the above table, the number of goods received in the current month is the total number of goods received on the current 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 items issued in the current month is the total number of items issued on that 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 items for the current month 25 is the data set at the end of the current month in the temporary storage fee calculation work in FIG. 4, that is, the data set for the first row from the bottom (storage fee start is 2016/04/30) It becomes the same numerical value as the stock quantity 25.

(Storage charge unit price detection process)
Subsequently, the storage fee unit price detection unit 102b refers to the warehouse storage fee master 106g, and stores the warehouse code A included in the detected data set (storage fee start is 2016/04/30) from the bottom. The storage fee unit price detection process for detecting the corresponding storage fee unit price is performed.

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

(Storage fee calculation process)
Subsequently, the storage fee calculation unit 102c multiplies the maximum stock quantity on the day (35 pieces) included in the detected data set by the detected storage fee unit price (30,000 yen) to calculate the storage fee. , 35 × 30,000 yen = 1,050,000 yen is calculated. An example of the screen during the storage fee calculation process is shown in FIG. In the processing progress column of FIG. 9, the completed processing is displayed as needed.

(Storage fee display processing)
Finally, the storage fee display unit 102d performs a display process for displaying the calculated storage fee 1,050,000 yen. The storage fee display unit 102d is an optional component, but by being included in the storage fee calculation apparatus 100 according to the present embodiment, the operator can quickly grasp the calculated storage fee.

[In case of 3-2.2 period or more]
Next, the case of two or more periods will be described. Here, in the case of a three-period system, that is, the number of divisions of the certain period (from 2016/04/01 to 2016/04/30) is 3, and the certain period is 2016/04/01. Will be divided into 1 period from 1 to 2016/04/10, 2 periods from 2016/04/11 to 2016/04/20, and 3 periods from 2016/04/21 to 2016/04/30. .

  Also in the present embodiment, the predetermined numerical condition is a condition that the maximum stock quantity on the day is the maximum value.

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

  Specifically, as shown in the table of storage fee calculation temporary work in FIG. 4, the data set detection unit 102a starts from 2016/04/01 from among the data sets including the inputted maximum stock quantity on the day and the warehouse code. In the period up to 2016/04/10, as the data set whose maximum stock quantity on the day is the maximum value, the data set on the fifth line from the top having the maximum stock quantity on the day (the storage fee start is 2016/04/10 ) Data set.

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

  Through the above processing, the data set detection unit 102a detects three data sets having a maximum stock quantity of 20, 30, and 35.

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

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

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

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

  In the case of the two-period system, that is, the number of divisions in the certain period (from 2016/04/01 to 2016/04/30) is 2, and the certain period is from 2016/04/01 to 2016 / In the case of division into one period from 04/15 and two periods from 2016/04/16 to 2016/04/30, inventory storage fees can be calculated in the same manner as in the case of the three-period system. it can. That is, the data set detection unit 102a has a data set on the seventh row from the top having a maximum stock quantity of 30 on the day (storage charge start is 2016/04/15) and a maximum of 1 stock on the day is 35 from the bottom. The data set of the line (the 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 fee calculation apparatus 100 according to the present embodiment, the inventory storage fee can be calculated according to the numerical condition set by the operator regarding the number of inventory.

  Further, according to the storage fee calculation apparatus 100 according to the present embodiment, for example, even when the certain period is divided, the numerical condition set by the operator is met for each period after the certain period is divided. The number of stocks to be detected can be detected, and the stock storage fee can be calculated. Thereby, the storage fee calculation apparatus 100 according to the present embodiment actually calculates the maximum stock quantity in each period by dividing one month into the first period, the second period, and the third period, for example. It is also possible to deal with the form of transaction performed.

  According to the storage fee calculation apparatus 100 according to the present embodiment, for example, since the storage fee is stored in different warehouses in each period, even when the storage fee unit price is different, the inventory storage fee is as follows. Can be calculated. For example, the stock quantity in the first period is 10 and the storage charge unit price of the warehouse A is 30,000 yen, the stock quantity in the second period is 20 pieces, and the storage charge unit price of the warehouse B is 330,000 yen, the third period When the stock quantity at the eye is 30 and the storage fee unit price of the warehouse C is 36,000 yen, the storage charge calculation unit 102c sets the stock storage charge to 10 pieces × (30,000 yen ÷ 3) +20 pieces. × (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 idea described in the claims.

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

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

  In addition, regarding the storage fee calculation apparatus 100, each illustrated component is functionally conceptual and does not necessarily need to be physically configured as illustrated.

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

  The computer program may be stored in an application program server connected to the storage fee calculation apparatus 100 via an arbitrary network, and may be downloaded in whole or in part as necessary. It is.

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

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

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

  Further, the 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 apparatus 100 may be realized by installing software (including a program or data) that realizes the processing described in the present embodiment in the apparatus.

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

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

100 Storage fee calculation device
102 Control unit
102a Data set detection unit
102b Storage unit price detector
102c Storage fee calculation department
102d Storage fee display section
104 Communication interface
106 Storage unit
106a D arrival details
106b D shipping details
106c D movement details
106d D transfer details
106e D Stocktaking
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 (6)

A storage fee calculation 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 is stored.
The controller is
A data set detection means for detecting a data set including a stock quantity satisfying a predetermined numerical condition in a predetermined period from among the data set including the input stock quantity and storage location identification information;
A storage fee unit price detecting means 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;
A storage fee calculating 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;
Providing
A storage fee calculation device. The predetermined numerical condition is a condition that the stock quantity is a maximum value;
The storage fee calculation apparatus according to claim 1, wherein: In the storage unit,
A division number master including the storage location identification information and the division number of the certain period corresponding to the storage location identification information;
The data set detection means detects data sets for the number of divisions by detecting data sets for each period after the division of the certain period,
The storage fee calculation means calculates the total number of stocks included in the data set for the detected number of divisions, and multiplies the total by the value obtained by dividing the detected storage fee unit price by the number of divisions. To calculate the storage fee,
The storage fee calculation apparatus according to claim 1 or 2, characterized in that: The control unit further comprises storage fee display means for displaying the calculated storage fee;
The storage fee calculation device according to claim 1, wherein the storage fee calculation device is a storage fee calculation device. A storage fee calculation method executed by an information processing apparatus 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 is stored.
Executed by the control unit,
A data set detection step for detecting a data set including a stock quantity satisfying a predetermined numerical value condition in a certain period from the data set including the input stock quantity and storage location identification information;
A storage fee unit price detecting 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;
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;
Including,
A storage fee calculation method characterized by A storage fee calculation program for causing an information processing apparatus including a control unit and a storage unit to execute,
In the storage unit,
A storage fee unit price master that includes storage location identification information and the corresponding storage fee unit price is stored.
For causing the control unit to execute,
A data set detection step for detecting a data set including a stock quantity satisfying a predetermined numerical value condition in a certain period from the data set including the input stock quantity and storage location identification information;
A storage fee unit price detecting 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;
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;
Including,
Storage fee calculation program characterized by

Images