Storage fee handling system, storage fee handling method, and storage fee handling program

Abstract

To provide a storage fee processing system, a storage fee processing method, and a storage fee processing program for confirming the staying state of the stock of merchandise for each month.SOLUTION: The storage fee processing system according to the present embodiment includes: storage fee calculation processing means for creating storage fee data including a fiscal year, a warehouse, a commodity, an end-of-month inventory quantity, a maximum inventory quantity that is a quantity when the largest quantity in the warehouse at the time of the current month is the largest, an inventory quantity in the current month, a warehousing quantity in the current month, a shipping quantity in the current month, and a difference between the maximum inventory quantity and the end-of-month inventory quantity; and a deemed storage fee list output means for outputting a deemed storage fee list including the fiscal year, warehouse, commodity, the end-of-month inventory quantity, the cumulative deemed inventory quantity up to the current month, and the cumulative deemed storage fee difference that is the difference between the cumulative deemed inventory quantity and the current month.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to a storage fee processing system, a storage fee processing method, and a storage fee processing program. [Background technology]

[0002] For example, in the food industry, there is a need to minimize remaining inventory, as it leads to large-scale disposal and increased storage fees. Patent Document 1, for example, is an example of a system for managing warehouse storage fees. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Application Publication No. 2018-101278 Summary of the Invention [Problem to be solved by the invention]

[0004] However, in Patent Document 1, it is not possible to check the degree of inventory backlog for each month.

[0005] The present invention has been made in consideration of the above, and aims to provide a storage fee processing system, a storage fee processing method, and a storage fee processing program that make it possible to check the inventory status of products on a monthly basis. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides a storage fee processing system equipped with a control unit, wherein the control unit stores a storage fee master in which warehouses, products, temperature zones including chilled or frozen, and storage fee unit prices are associated and registered; shipping data including shipping dates, shipping numbers, warehouses, products, and shipment quantities; receiving data including arrival dates, arrival numbers, warehouses, products, and arrival quantities; and movement data including transfer departure dates, transfer numbers, issuing warehouses, products, transfer arrival dates, receiving warehouses, and movement quantities. and inventory information including the fiscal year and month, warehouse, product, inventory quantity at the end of the previous month, inventory quantity at the end of the current month, inventory value at the end of the current month, and inventory valuation unit price at the end of the current month. The storage fee calculation processing means is configured to be able to access inventory information including the fiscal year and month, warehouse, product, inventory quantity at the end of the previous month, inventory quantity at the end of the current month, inventory value at the end of the current month, and inventory valuation unit price at the end of the current month, and is characterized by comprising: a storage fee calculation processing means that, based on the shipping data, the receiving data, the movement data, and the inventory information, refers to the storage fee master and creates storage fee data including the fiscal year and month, warehouse, product, inventory quantity at the end of the previous month, maximum inventory quantity which is the quantity at the warehouse when the largest quantity was in the warehouse in the current month, inventory quantity in the current month, inventory quantity out of the current month, inventory quantity at the end of the current month, and storage fee amount calculated by multiplying the maximum inventory quantity by the storage fee unit price; and a deemed storage fee list output means that, based on the storage fee data, outputs a deemed storage fee list including the fiscal year and month, warehouse, product, deemed storage fee amount for the current month which is the storage fee amount, accumulated deemed storage fee amount which is the amount obtained by adding the deemed storage fee amount for the current month to the accumulated deemed storage fee amount up to the previous month, and a current month_cumulative deemed storage fee difference which is the difference between the accumulated deemed storage fee amount and the deemed storage fee amount for the current month.

[0007] According to another aspect of the present invention, the control unit may be configured to be able to access a product master that associates and registers, for each product, a temperature range including chilled or frozen, a recommended storage period, and a product classification.

[0008] In addition, according to one aspect of the present invention, the deemed storage fee list output means may be configured to display a warning of expiration of the period in the deemed storage fee list if the recommended storage period in the product master - storage period is less than or equal to 0 for the product.

[0009] Furthermore, according to one aspect of the present invention, the deemed storage fee list output means may display a warning that the expiration date is approaching in the deemed storage fee list if, for the product, 0 < recommended storage period in the product master - storage period ≦ predetermined value (where the predetermined value > 0).

[0010] Furthermore, according to one aspect of the present invention, the deemed storage fee list output means may be configured to aggregate the products for the deemed storage fee list by corresponding product classification in the product master, and output the current month's cumulative deemed storage fee difference divided by the current month's out-of-stock quantity for each product classification.

[0011] According to another aspect of the present invention, the merchandise may include food products or chemical products.

[0012] Furthermore, in order to solve the above-mentioned problems and achieve the object, the present invention provides a storage fee processing method executed by an information processing device having a control unit, wherein the control unit is configured to be able to access a storage fee master in which warehouses, products, temperature zones including chilled or frozen, and storage fee unit prices are associated and registered; shipping data including shipping dates, shipping numbers, warehouses, products, and shipment quantities; receiving data including arrival dates, arrival numbers, warehouses, products, and arrival quantities; movement data including transfer departure dates, transfer numbers, issuing warehouses, products, transfer arrival dates, receiving warehouses, and movement quantities; and inventory information including accounting year and month, warehouses, products, inventory quantities at the end of the previous month, inventory quantities at the end of the current month, inventory amounts at the end of the current month, and inventory valuation unit prices at the end of the current month; and The method includes a storage fee calculation process for creating storage fee data based on warehouse information, by referring to the storage fee master, including the fiscal year and month, warehouse, product, inventory at the end of the previous month, maximum inventory which is the largest quantity in the warehouse in the current month, inventory in the current month, inventory out the current month, inventory at the end of the current month, and storage fee calculated by multiplying the maximum inventory by the storage fee unit price; and a deemed storage fee list output process for outputting, based on the storage fee data, a deemed storage fee list including the fiscal year and month, warehouse, product, deemed storage fee for the current month which is the storage fee amount, accumulated deemed storage fee which is the sum of the accumulated deemed storage fee up to the previous month and the deemed storage fee for the current month, and current month_cumulative deemed storage fee difference which is the difference between the accumulated deemed storage fee and the deemed storage fee for the current month.

[0013] Furthermore, in order to solve the above-mentioned problems and achieve the object, the present invention provides a storage fee processing program to be executed by an information processing device having a control unit, wherein the control unit is configured to be able to access a storage fee master in which warehouses, products, temperature zones including chilled or frozen, and storage fee unit prices are registered in association with each other; shipping data including shipping date, shipping number, warehouse, product, and number of shipments; receiving data including arrival date, arrival number, warehouse, product, and number of arrivals; movement data including transfer departure date, transfer number, issuing warehouse, product, transfer arrival date, receiving warehouse, and number of movements; and inventory information including accounting year and month, warehouse, product, inventory quantity at the end of the previous month, inventory quantity at the end of the current month, inventory amount at the end of the current month, and inventory valuation unit price at the end of the current month, and the control unit executes a storage fee processing program to be executed by an information processing device having a control unit, wherein the control unit is configured to be able to access a storage fee master in which warehouses, products, temperature zones including chilled or frozen, and storage fee unit prices are registered in association with each other; shipping data including shipping date, shipping number, warehouse, product, and number of shipments; receiving data including arrival date, arrival number, warehouse, product, and number of arrivals; and a deemed storage fee list output process for outputting, based on the storage fee data, a deemed storage fee list including the fiscal year and month, warehouse, product, inventory quantity at the end of the previous month, maximum inventory quantity which is the quantity at the warehouse when the quantity was greatest in the current month, inventory quantity for the current month, inventory quantity at the end of the current month, and storage fee amount calculated by multiplying the maximum inventory quantity by the storage fee unit price. [Effects of the Invention]

[0014] According to the present invention, it is possible to check the inventory status of products on a monthly basis. [Brief explanation of the drawings]

[0015] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a storage fee processing system according to this embodiment. [Figure 2]FIG. 2 is a diagram showing examples of data structures and relationships of the warehouse master, product master, storage fee master, product classification master, storage fee data in the data table, inventory information, shipping data, arrival data, and movement data. [Figure 3] FIG. 3 is a diagram showing an example of the overall processing flow of the control unit of the storage fee processing system according to the present embodiment. [Figure 4] FIG. 4 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the storage fee processing system according to this embodiment. [Figure 5] FIG. 5 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the storage fee processing system according to the present embodiment. [Figure 6] FIG. 6 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the storage fee processing system according to this embodiment. [Figure 7] FIG. 7 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the storage fee processing system according to this embodiment. [Figure 8] FIG. 8 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the storage fee processing system according to this embodiment. [Figure 9] FIG. 9 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the storage fee processing system according to the present embodiment. [Figure 10] FIG. 10 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the storage fee processing system according to this embodiment. [Figure 11] FIG. 11 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the storage fee processing system according to this embodiment. [Figure 12] FIG. 12 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the storage fee processing system according to this embodiment. [Figure 13] FIG. 13 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the storage fee processing system according to this embodiment. [Figure 14] FIG. 14 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the storage fee processing system according to this embodiment. [Figure 15] FIG. 15 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the storage fee processing system according to this embodiment. [Figure 16] FIG. 16 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the storage fee processing system according to this embodiment. [Figure 17] FIG. 17 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the storage fee processing system according to this embodiment. DETAILED DESCRIPTION OF THE INVENTION

[0016] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to this embodiment.

[0017] [1. Overview] For example, in the food industry, there is a challenge to reduce remaining inventory as much as possible because it leads to large-scale waste and increased storage costs.

[0018] However, in the past, they only checked how much storage fee was being charged for each product each month, but they were unable to check the extent of the product's inventory. As a result, they were unable to grasp the amount of inventory being held up, and a lot of the product was discarded due to expiration. Also, since storage fees were often not included in the cost price, sales staff decided the selling price without taking storage fees into account. This sometimes resulted in selling prices that did not generate profits.

[0019] Therefore, in this embodiment, the deemed storage fee amount is calculated using the storage fee unit price and the inventory quantity at the end of the month, and the storage fee amount for each product or product group is visualized each month. Specifically, the difference between the cumulative storage fee amount and the storage fee amount for the current month is displayed for inventory, allowing the extent of inventory backlog to be confirmed. For products with a large difference, meaning a large amount of backlogged inventory, this can be checked when planning purchases, allowing for plans to curb excess orders or focus on selling items with approaching expiration dates. In addition, by displaying the "inventory unit price including deemed storage fee," which is usually difficult to confirm because storage fees are not included in the cost price, it can be used as an indicator of how much the selling price can be reduced when selling backlogged inventory.

[0020] In this specification, the term "deemed storage fee" is used, but the reason for using the word "deemed" is that the actual storage fee can only be determined by looking at the invoice, but in order to know the storage fee in advance, an approximate amount is calculated as the deemed storage fee based on master and actual data.

[0021] The storage fee processing system of the present invention can be widely applied to products that have expiration dates or expiration dates, such as food and chemical products.

[0022] [2. Configuration] An example of the configuration of a storage fee processing system according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of a storage fee processing system according to this embodiment.

[0023] The storage fee processing system 100 is a commercially available desktop personal computer. Note that the storage fee processing system 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

[0024] The storage fee processing system 100 comprises a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. Each unit of the storage fee processing system 100 is connected to each other so as to be able to communicate with each other via any communication path.

[0025] The communication interface unit 104 communicatively connects the storage fee processing system 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 the communication line. Here, the network 300 has a function of communicatively connecting the storage fee processing system 100 and the server 200 to each other, and is, for example, the Internet or a LAN (Local Area Network).

[0026] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that functions as a pointing device in cooperation with a mouse. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0027] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs that work in conjunction with an OS (Operating System) to issue commands to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. The storage unit 106 can be, 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, etc.

[0028] The storage unit 106 also includes a warehouse master 106a, a product master 106b, a storage fee master 106c, a product classification master 106d, and a data table 106e. Fig. 2 is a diagram showing examples of data structures and relationships of the storage fee data, inventory information, shipping data, arrival data, and movement data in the warehouse master 106a, the product master 106b, the storage fee master 106c, the product classification master 106d, and the data table 106e.

[0029] The warehouse master 106a can be configured as a table or the like in which warehouses (warehouse codes and / or warehouse names) and shelf numbers (shelf number codes and / or shelf number names) are registered in association with each other.

[0030] The product master 106b can be configured as a table or the like in which products (product codes and / or product names), temperature zones (chilled, frozen, etc.), recommended storage periods (days), and product classifications (product classification codes and / or product names) are associated and registered. The product classification names in the product classification master 106d may be integrated into the product master 106b.

[0031] The storage fee master 106c can be configured as a table or the like in which warehouses (warehouse codes and / or warehouse names), products (product codes and / or product names), temperature zones, and storage fee unit prices are registered in association with each other.

[0032] The product category master 106d can be configured as a table in which product category codes and product category names are registered in association with each other.

[0033] The data table 106e is a table for storing various data such as storage fee data, inventory information, shipping data, receiving data, and movement data.

[0034] The shipping data may include shipping date, shipping number, warehouse, product, lot number, and number of shipments.

[0035] The arrival data may include arrival date, arrival number, warehouse, product, lot number, and arrival quantity.

[0036] The transfer data may include the transfer shipment date, transfer number, shipping warehouse, product, transfer arrival date, lot number, and transfer quantity.

[0037] The inventory information may include the accounting year and month, warehouse, product, lot number, inventory quantity at the end of the previous month, inventory quantity at the end of the current month, inventory value at the end of the current month, and inventory valuation unit price at the end of the current month.

[0038] The storage fee data may include the fiscal year and month, warehouse, product, lot number, inventory at the end of the previous month, maximum inventory, inventory in the current month, inventory out of the current month, inventory at the end of the current month, and storage fee amount.

[0039] Returning to Fig. 1, the control unit 102 is a CPU or the like that performs overall control of the storage fee processing system 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing operations based on these stored programs.

[0040] The control unit 102 is configured to be able to access the warehouse master 106a, the product master 106b, the storage fee master 106c, the product classification master 106d, and the data table 106e stored in the memory unit 106. Note that the warehouse master 106a, the product master 106b, the storage fee master 106c, the product classification master 106d, and the data table 106e may be provided in another location (for example, the server 200) as long as the control unit 102 is able to access them.

[0041] The control unit 102 conceptually includes a master maintenance unit 102a, a data management unit 102b, a storage fee calculation processing unit 102c, a deemed storage fee list output unit 102d, and a screen display control unit 102e.

[0042] The master maintenance unit 102a performs settings such as inputting, adding, deleting, and editing data for the warehouse master 106a, the product master 106b, the storage fee master 106c, and the product classification master 106d, in response to, for example, an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114.

[0043] The data management unit 102b inputs receiving data in response to, for example, an operator's operation on a receiving input screen (not shown) displayed on the monitor 114, and registers the data in the data table 106e. The data management unit 102b also inputs shipping data in response to, for example, an operator's operation on a shipping input screen (not shown) displayed on the monitor 114, and registers the data in the data table 106e. The data management unit 102b inputs inventory movement data in response to an operator's operation on a movement input screen (not shown) displayed on the monitor 114, and registers the data in the data table 106e. The data management unit 102b also updates the inventory information in the data table 106e in response to the receiving data, shipping data, and movement data.

[0044] The storage fee calculation processing unit 102c refers to the storage fee master 106c based on the shipping data, receiving data, movement data, and inventory information, and creates storage fee data including the accounting year and month, warehouse, product, inventory quantity at the end of the previous month, maximum inventory quantity which is the quantity at the warehouse when the largest quantity was in the warehouse in the current month, quantity received in the current month, quantity shipped out in the current month, inventory quantity at the end of the current month, and the storage fee amount calculated by multiplying the maximum inventory quantity by the storage fee unit price, and registers this data in the data table 106e.

[0045] The deemed storage fee list output unit 102d, for example, in response to an operator's operation on the deemed storage fee list output screen displayed on the monitor 114, displays and outputs a deemed storage fee list based on the storage fee data, including the fiscal year and month, warehouse, product, the deemed storage fee amount for the current month which is the storage fee amount, the cumulative deemed storage fee amount which is the sum of the cumulative deemed storage fee amount up to the previous month and the deemed storage fee amount for the current month, and the cumulative deemed storage fee difference for the current month which is the difference between the cumulative deemed storage fee amount and the deemed storage fee amount for the current month.

[0046] The deemed storage fee list output unit 102d may display a warning of the expiration of the period in the deemed storage fee list when the recommended storage period in the product master 106b--the storage period≦0 for the product.

[0047] The deemed storage fee list output unit 102d may display a warning in the deemed storage fee list that the expiration date is approaching for the product in question if 0<recommended storage period in product master 106b-storage period≦predetermined value (however, the predetermined value > 0).

[0048] The deemed storage fee list output unit 102d may aggregate the products for the deemed storage fee list by corresponding product classification in the product master 106b, and output the current month_cumulative deemed storage fee difference divided by the current month's out-of-stock quantity for each product classification.

[0049] The screen display control unit 102e controls the display and input of various screens displayed on the monitor 114 (for example, a master maintenance screen, a shipping input screen, a receiving input screen, a movement input screen, a deemed storage fee list output screen, etc.).

[0050] [3. Specific Examples] A specific example of the processing of the storage fee processing system 100 in this embodiment will be described with reference to Figures 1 to 17. Figures 4 to 17 are diagrams for explaining a specific example of the processing of the storage fee processing system 100 in this embodiment.

[0051] (3-1. Overall processing) An example of the overall processing of the control unit of the storage fee processing system 100 in this embodiment will be described with reference to Fig. 3. Fig. 3 is a diagram for explaining an example of the overall processing of the control unit of the storage fee processing system 100 in this embodiment.

[0052] 3, the master maintenance unit 102a executes a warehouse master maintenance process (step S1). Specifically, in the warehouse master maintenance process, the master maintenance unit 102a sets data in the warehouse master 106a in response to an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114, for example.

[0053] The master maintenance unit 102a executes a product master maintenance process (step S2). Specifically, in the product master maintenance process, the master maintenance unit 102a sets data in the product master 106b in response to an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114, for example.

[0054] The master maintenance unit 102a executes storage fee master maintenance processing (step S3). Specifically, in the storage fee master maintenance processing, the master maintenance unit 102a sets data in the storage fee master 106c in response to, for example, an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114.

[0055] The storage fee calculation processing unit 102c executes the storage fee calculation process (step S4). Specifically, in the storage fee calculation process, the storage fee calculation processing unit 102c refers to the storage fee master based on the shipping data, receiving data, movement data, and inventory information, and creates storage fee data including the accounting year and month, warehouse, product, inventory quantity at the end of the previous month, maximum inventory quantity which is the quantity at the warehouse when the quantity was the largest in the current month, inventory quantity in the current month, inventory quantity out of the current month, inventory quantity at the end of the current month, and the storage fee amount calculated by multiplying the maximum inventory quantity by the storage fee unit price, and registers the data in the data table 106e.

[0056] The deemed storage fee list output unit 102d executes a deemed storage fee list output process (step S5). Specifically, in the deemed storage fee list output process, the deemed storage fee list output unit 102d, for example, in response to an operator's operation on a deemed storage fee list output screen displayed on the monitor 114, displays and outputs a deemed storage fee list based on the storage fee data, including the fiscal year and month, warehouse, product, the current month deemed storage fee amount which is the storage fee amount, the accumulated deemed storage fee amount which is the sum of the accumulated deemed storage fee amount up to the previous month and the current month deemed storage fee amount, and the current month_accumulated deemed storage fee difference which is the difference between the accumulated deemed storage fee amount and the current month deemed storage fee amount.

[0057] The deemed storage fee list output unit 102d may display a warning of the expiration of the period in the deemed storage fee list when the recommended storage period in the product master 106b--the storage period≦0 for the product.

[0058] The deemed storage fee list output unit 102d may display a warning that the expiration date is approaching in the deemed storage fee list if, for the product, 0 < recommended storage period in product master 106b - storage period ≦ specified value (however, specified value > 0).

[0059] The deemed storage fee list output unit 102d may aggregate the products for the deemed storage fee list by corresponding product classification in the product master 106b, and output the current month_cumulative deemed storage fee difference divided by the current month's out-of-stock quantity for each product classification.

[0060] (3-2. Sample data) 4 to 17 are diagrams showing sample data for explaining a specific example of the processing by the control unit 102 of the storage fee processing system 100 according to this embodiment. A specific example of the processing by the control unit 102 of the storage fee processing system 100 according to this embodiment will be explained with reference to FIGS. 4 to 17. In the following explanation, all monetary amounts will be expressed in yen, and the unit of yen will be omitted.

[0061] (Prerequisite data) 4 is a diagram showing an example of data in the warehouse master 106a. The warehouse master 106a has fields for warehouse code and shelf number code. In the example shown in the figure, the first line has the warehouse code "10101 Tochigi Refrigerated Warehouse" and shelf number code "T211001", and the second line has the warehouse code "10102 Gunma Freezer Warehouse" and shelf number code "T211001".

[0062] 5 is a diagram showing an example of data in the product master 106b. The product master 106b has fields for product code, temperature range, recommended storage period, and product classification code. In the example shown in the figure, the first line has product code "12345 Prosciutto," temperature range "chilled," recommended storage period "60," and product classification code "A1." The second line has product code "23456 Frozen Orange," temperature range "frozen," recommended storage period "360," and product classification code "A1." The third line has product code "34567 Bacon," temperature range "chilled," recommended storage period "100," and product classification code "B1."

[0063] 6 is a diagram showing an example of data in the storage fee master 106c. The storage fee master 106c has fields for warehouse code, product code, temperature zone, and storage fee unit price. In the example shown in the figure, the first line contains warehouse code "10101," product code "12345 prosciutto," temperature zone "chilled," and storage fee unit price "10." The second line contains warehouse code "10102," product code "23456 frozen orange," temperature zone "frozen," and storage fee unit price "35." The third line contains warehouse code "10101," product code "34567 bacon," temperature zone "chilled," and storage fee unit price "15."

[0064] 7 is a diagram showing an example of data in the product classification master 106d. The product classification master 106d has fields for product classification code and product classification name. In the example shown in the figure, the first line has the product classification code "A1" and the product classification name "meat," and the second line has the product classification code "B1" and the product classification name "frozen fruit."

[0065] Figure 8 is a diagram showing an example of shipping data. The shipping data includes the following fields: shipping date, shipping number, warehouse, product, lot number, and number of shipments. In the example shown in the figure, the first line contains the shipping date "2022 / 01 / 11", shipping number "SH00001", warehouse "10101 Tochigi Refrigeration", product "12345 Prosciutto", lot number "20220302", and number of shipments "40".

[0066] Figure 9 is a diagram showing an example of arrival data. Arrival data includes the following fields: arrival date, arrival number, warehouse, product, lot number, and quantity of arrival. In the example shown in the figure, the first line contains the arrival date "2022 / 01 / 6", arrival number "SH00001", warehouse "10101 Tochigi Refrigeration", product "12345 Prosciutto", lot number "20220302", and quantity of arrival "100".

[0067] FIG. 10 is a diagram showing an example of transfer data. The transfer data includes the following fields: transfer departure date, transfer number, issuing warehouse, product, transfer arrival date, receiving warehouse, lot number, and number of transfers. In the example shown in the figure, the first line contains the transfer departure date "2022 / 01 / 12", transfer number "SH00001", issuing warehouse "10101 Tochigi Refrigeration", product "12345 Prosciutto", transfer arrival date "2022 / 01 / 13", receiving warehouse "10110 Osaka Refrigeration", lot number "20220302", and number of transfers "10".

[0068] Figure 11 is a diagram showing an example of inventory information data. The inventory information includes the following fields: accounting year and month, warehouse, product, lot number, inventory quantity at the end of the previous month, inventory quantity at the end of the current month, inventory value at the end of the current month, and inventory valuation unit price at the end of the current month. In the example shown in the figure, the first line contains the accounting year and month "202201," warehouse "10101 Tochigi Refrigeration," product "12345 Prosciutto," lot number "20220302," inventory quantity at the end of the previous month "50," inventory quantity at the end of the current month "100," inventory value at the end of the current month "21,300," and inventory valuation unit price at the end of the current month "213."

[0069] (S4: Storage fee calculation process) A specific example of the storage fee calculation process will be described with reference to Figures 12 and 13. The storage fee calculation processing unit 102c refers to the storage fee master 106c based on the shipping data, receiving data, movement data, and inventory information, and creates storage fee data including the accounting year and month, warehouse, product, inventory quantity at the end of the previous month, maximum inventory quantity which is the quantity at the warehouse when the largest quantity was in the warehouse in the current month, inventory quantity in the current month, inventory quantity out of the current month, inventory quantity at the end of the current month, and the storage fee amount calculated by multiplying the maximum inventory quantity by the storage fee unit price, and registers this data in the data table 106e.

[0070] Figure 12 is a diagram showing an example of storage fee data. The storage fee data is a compilation of the inventory quantity at the end of the previous month, maximum inventory quantity, inventory quantity in the current month, inventory quantity out of the current month, inventory quantity at the end of the current month, and storage fee amount for each fiscal year / month, warehouse, shelf number, product, and lot number. The storage fee data may also include the fiscal year / month, warehouse, product, lot number, inventory quantity at the end of the previous month, maximum inventory quantity, inventory quantity in the current month, inventory quantity out of the current month, inventory quantity at the end of the current month, and storage fee amount.

[0071] "Number of items received this month" is the number of items received in the receiving data and the number of items received in the transfer data. "Number of items shipped out this month" is the number of items received in the shipping data and the number of items shipped out in the transfer data. "Maximum inventory quantity" is the quantity at the highest level in the warehouse during the month, and the maximum value is obtained by adding up the receipt and payment history.

[0072] The "storage fee amount" is the amount obtained by multiplying the storage fee unit price linked to the product, warehouse, and temperature zone classification from the storage fee master 106c by the maximum inventory quantity.

[0073] In the example shown in the figure, the third line contains the accounting year and month "202201," warehouse "10102 Gunma Frozen," product "23456 Frozen Orange," lot number "20230101," inventory at the end of the previous month "110," maximum inventory "160," inventory in the current month "80," inventory out of the current month "40," inventory at the end of the current month "150," and storage fee "5,600 (= 160 x 35)."

[0074] Here, the maximum inventory quantity of "160" for the product "frozen oranges" is calculated as follows. Figure 13 is a diagram for explaining how to calculate the maximum inventory quantity for frozen oranges. The diagram shows the date, transaction details (arrival, shipment, etc.), received and paid quantities, and cumulative quantities in chronological order. As shown in the diagram, in January, the highest quantity in the warehouse was "160 units," so the maximum inventory quantity used to calculate storage fees is "160."

[0075] (S5: Deemed storage fee list output process) 14 to 17, a specific example of the deemed storage fee list output process will be described. For example, in response to an operator's operation on the deemed storage fee list output screen displayed on the monitor 114, the deemed storage fee list output unit 102d displays and outputs a deemed storage fee list based on storage fee data, etc., including the fiscal year and month, warehouse, product, the current month's deemed storage fee amount, which is the storage fee amount, the accumulated deemed storage fee amount, which is the sum of the accumulated deemed storage fee amount up to the previous month and the current month's deemed storage fee amount, and the current month_accumulated deemed storage fee difference, which is the difference between the accumulated deemed storage fee amount and the current month's deemed storage fee amount. Furthermore, for a given product, if the recommended storage period in the product master 106b - storage period ≦ 0, a warning that the period is over may be displayed in the deemed storage fee list. Furthermore, if 0 < recommended storage period in the product master 106b - storage period ≦ predetermined value (where predetermined value > 0), a warning that the period is approaching may be displayed in the deemed storage fee list. Furthermore, for the deemed storage fee list, the products may be totaled for each product category in the product master 106b, and the current month's cumulative deemed storage fee difference divided by the number of products not in stock for the current month may be output for each product category.

[0076] Figure 14 is a diagram showing an example of the deemed storage fee list output screen. On the deemed storage fee list output screen, conditions can be specified for items such as the base date, business location, fiscal year and month, warehouse, storage period warning category (no warning, expiry date approaching, overdue), and product classification. For the specified conditions, the storage fee data is referenced and a deemed storage fee list is output. Items for which no conditions are specified are considered to be all specified. Note that if no specification is made for the storage period warning category, it is assumed that expiry date approaching and overdue date are selected, and if no warning is to be issued, no warning is specified. In the example shown in the figure, the base date "2022 / 2 / 28" and fiscal year and month "2022 / 01" are specified, and all other items are specified.

[0077] 15 is a diagram showing an example of an output of a deemed storage fee list. The deemed storage fee list includes the following items: accounting year and month, warehouse code, product, product classification name of product classification master 106d using the product classification code of product master 106b corresponding to the product as a key, shelf number name, storage fee category name, expiration date, inventory quantity at the end of previous month, previous month's deemed storage fee amount, maximum inventory quantity, current month's inventory in stock, current month's inventory out stock, inventory quantity at the end of this month, deemed storage fee unit price, current month's deemed storage fee amount, cumulative deemed storage fee amount, end-of-month inventory amount, end-of-month inventory value, end-of-month inventory valuation unit price, end-of-month inventory value, simulated end-of-month inventory valuation unit price, storage period, recommended storage period, storage period warning, and current month's cumulative deemed storage fee difference.

[0078] "Current month's deemed storage fee" is the storage fee amount (storage fee data) calculated in the storage fee calculation process. "Cumulative deemed storage fee" is the sum of the cumulative deemed storage fee amount up to the previous month and the deemed storage fee amount for the current month, in order to see the amount of storage fees incurred so far. For products incurred from this month onwards, the amount will be the same as the deemed storage fee amount for the current month.

[0079] The "Simulated end-of-month inventory valuation unit price" is the unit price calculated by adding the deemed storage fee for the current month and the inventory amount for the current month, and dividing the result by the inventory quantity at the end of the current month. The "storage period" is the period from the date of first entry into the warehouse (the arrival date in the arrival data) to the specified accounting month (for example, 2022 / 01, 2022 / 01 / 01). The "Current month's cumulative deemed storage fee difference" is the difference between the cumulative deemed storage fee and the deemed storage fee for the current month; the larger this amount, the more likely it is that the item is stagnating.

[0080] "Storage Period Warning" displays a list of items that have exceeded the storage period and an alert for items that will exceed the storage period next month. Storage period warnings are determined using the following logic.

[0081] (1) If the recommended storage period in the product master 106b - the storage period in the deemed storage fee list is ≦0, "Exceeding the period" is displayed to indicate that the recommended storage period has been exceeded.

[0082] (2) If 0<recommended storage period in product master 106b-storage period in deemed storage fee list≦predetermined value (for example, 30), then "expire soon" is displayed to indicate that the recommended storage period will soon expire.

[0083] In the example shown in the figure, the second line contains the accounting year and month "202201", warehouse code "10101", product "12345 Prosciutto", product category name "Meat", shelf number name "T211001", storage fee category name "Chilled", expiration date "2022 / 4 / 1", inventory at the end of previous month "150", previous month's deemed storage fee amount "0", maximum inventory amount "300", current month's inventory amount "150", current month's inventory amount "100", current month's deemed storage fee amount "200", deemed storage fee unit price "10", current month's deemed storage fee amount "3,000", cumulative deemed storage fee amount "4,000". , inventory amount at the end of the month "42,000", inventory valuation unit price at the end of the month "210", inventory amount at the end of the month "42,000", simulated inventory valuation unit price at the end of the month "225", storage period "35", recommended storage period "60", storage period warning "period approaching (recommended storage period in product master 106b "60" - storage period "35" ≦ 30)", current month_cumulative deemed storage fee difference "1,000 (= 4,000 - 3,000)".

[0084] Next, application examples (1) to (3) will be explained.

[0085] Usage example (1) The larger the "Current Month Cumulative Deemed Storage Fee Difference," which is the difference between the cumulative deemed storage fee amount in the deemed storage fee list and the deemed storage fee amount for the current month, the greater the cost of storage. Products with a small difference are likely to have a high inventory turnover rate because they have been stored for a short period of time. By listing such products, you can check the list of products that are likely to lead to profits.

[0086] Usage example (2) Since the retention period can be viewed for each product category, the system can show this to the procurement department so that orders for product categories with long retention periods can be refrained from and product categories with short retention periods can be procured.

[0087] FIG. 16 is a diagram showing an example of output for use example (2). FIG. 16(A) is a diagram showing example data of a deemed storage fee list (part). FIG. 16(B) shows example data in which products are aggregated by product classification in the product master 106b and the product classification master 106d based on the deemed storage fee list of FIG. 16(A), and the current month's cumulative deemed storage fee difference is calculated for each product classification by dividing the number of items not in stock for the current month. The deemed storage fee list output unit 102d may output data such as that shown in FIG. 16(B).

[0088] In the example shown in Figure 16 (B), the first line contains the product category name "meat," the inventory at the end of the month "300 (= 100 + 200)," the current month's cumulative deemed storage fee difference "1,000 (= 0 + 1,000)," and the current month's cumulative deemed storage fee difference / inventory at the end of the month "3.333333333 (= 1,000 ÷ 300)."

[0089] By checking the total of the cumulative deemed storage fee difference for the current month divided by the total inventory at the end of the month for each product category, you can see which product categories are being charged storage fees.

[0090] Usage example (3) You can display a list of items that have exceeded their storage period, as well as an alert for items that will exceed their storage period next month (storage period warning). By selecting the status of the storage fee warning category in the extraction conditions, you can focus on products that have triggered an alert and conduct sales activities to reduce the amount of inventory that is being held up. Also, when negotiating how low the price can be reduced at the time of sale, you can set a profitable sales price by looking at the "simulated unit price," which is the inventory unit price that takes storage fees into account.

[0091] Figure 17 is a diagram showing an example of output from Use Case 3 (example of data for a partial deemed storage fee list). The example shown in this figure shows the case where "Expiry Soon" is specified in the storage period warning category on the deemed storage fee list output screen in Figure 14. By focusing on the "Expiry Soon" product list during sales operations, waste can be reduced. Also, by checking the simulated unit price, it is possible to determine the selling price while taking into account the cost price including storage fees.

[0092] As described above, according to this embodiment, the storage fee master 106c is registered in which the warehouse, the product, the temperature zone including chilled or frozen, and the storage fee unit price are associated with each other, and the storage fee master 106c is referenced based on the shipping data, the receiving data, the movement data, and the inventory information to create storage fee data including the accounting year and month, the warehouse, the product, the inventory quantity at the end of the previous month, the maximum inventory quantity which is the quantity when the quantity in the warehouse was the largest in the current month, the inventory quantity for the current month, the inventory quantity for the current month, the inventory quantity at the end of the current month, and the storage fee amount calculated by multiplying the maximum inventory quantity by the storage fee unit price. The system is equipped with a management fee calculation processing unit 102c and a deemed storage fee list output unit 102d which outputs, based on storage fee data, a deemed storage fee list including the fiscal year and month, warehouse, product, the deemed storage fee amount for the current month which is the storage fee amount, the cumulative deemed storage fee amount which is the sum of the cumulative deemed storage fee amount up to the previous month and the deemed storage fee amount for the current month, and the current month_cumulative deemed storage fee difference which is the difference between the cumulative deemed storage fee amount and the deemed storage fee amount for the current month, thereby making it possible to check the inventory status of products on a monthly basis.

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

[0094] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0095] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to Goal 16 of the SDGs.

[0096] 5. Other Embodiments The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

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

[0098] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings can be changed as desired unless otherwise specified.

[0099] Furthermore, with regard to the storage fee processing system 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0100] For example, all or any part of the processing functions of the storage fee processing system 100, particularly the processing functions performed by the control unit, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the storage fee processing system 100 as needed. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to issue instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM and works with the CPU to form the control unit.

[0101] In addition, this computer program may be stored in an application program server connected to the storage fee processing system 100 via any network, and all or part of it may be downloaded as needed.

[0102] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) disc.

[0103] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.

[0104] The various databases stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.

[0105] The storage fee processing system 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 any peripheral device is connected. The storage fee processing system 100 may also be realized by installing software (including programs or data) that causes the device to perform the processing described in this embodiment.

[0106] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Explanation of symbols]

[0107] 100 Storage Fee Processing System 102 Control section 102a Master Maintenance Department 102b Data Management Department 102c Storage fee calculation processing unit 102d Deemed storage fee list output section 102e Screen display control unit 104 Communication interface unit 106 Storage section 106a Warehouse Master 106b Product Master 106c Storage Fee Master 106d Product Classification Master 106e Data Table 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network

Claims

1. A storage material processing system equipped with a control unit, The control unit, A storage fee master database is registered that associates warehouses, products, temperature zone classifications including chilled or frozen, and storage fee unit prices. Shipping data including shipping date, shipping number, warehouse, product, lot number, and quantity shipped, Incoming data including arrival date, arrival number, warehouse, product, lot number, and quantity received, Movement data including the date of departure, movement number, departure warehouse, product, lot number, date of arrival, arrival warehouse, and number of movements, Inventory information including accounting year and month, warehouse, product, lot number, inventory quantity at the end of the previous month, inventory quantity at the end of the current month, inventory value at the end of the current month, and inventory valuation cost at the end of the current month. It is configured to be accessible, A storage fee calculation processing means creates storage fee data that includes accounting year and month, warehouse, product, lot number, inventory quantity at the end of the previous month, maximum inventory quantity which is the quantity that was at its highest in the warehouse during the current month, quantity received during the current month, quantity shipped out during the current month, inventory quantity at the end of the current month, and storage fee amount calculated by multiplying the maximum inventory quantity by the storage fee unit price, based on the aforementioned shipping data, the aforementioned receiving data, the aforementioned movement data, and the aforementioned inventory information, by referring to the aforementioned storage fee master. A deemed storage fee list output means outputs a deemed storage fee list that includes the accounting year and month, warehouse, product, inventory quantity at the end of the previous month, deemed storage fee amount for the previous month, inventory quantity at the end of the current month, deemed storage fee amount for the current month which is the aforementioned storage fee amount, cumulative deemed storage fee amount which is the sum of the cumulative deemed storage fee amount up to the previous month and the deemed storage fee amount for the current month, and the difference between the cumulative deemed storage fee amount and the deemed storage fee amount for the current month which is the current month's cumulative deemed storage fee difference, based on the aforementioned storage fee data. A storage material processing system characterized by being equipped with the following features.

2. The control unit, The storage fee processing system according to claim 1, characterized in that it is configured to allow access to a product master in which each product is registered with associated temperature zone classification (including chilled or frozen), recommended storage period, and product classification.

3. The storage fee processing system according to claim 2, wherein the deemed storage fee list output means displays a warning of exceeding the storage period in the deemed storage fee list for the product if the recommended storage period in the product master - storage period ≤ 0.

4. The storage fee processing system according to claim 2, wherein the deemed storage fee list output means displays a warning in the deemed storage fee list for the product if 0 < recommended storage period in the product master - storage period ≤ predetermined value (however, predetermined value > 0).

5. The storage fee processing system according to claim 2, characterized in that the deemed storage fee list output means aggregates the products in the deemed storage fee list for each corresponding product category in the product master and outputs the current month's cumulative deemed storage fee difference ÷ current month's unsold inventory for each product category.

6. The storage material processing system according to any one of claims 1 to 5, characterized in that the aforementioned product includes food products or chemical products.

7. A storage fee processing method performed by an information processing device equipped with a control unit, The control unit, A storage fee master database is registered that associates warehouses, products, temperature zone classifications including chilled or frozen, and storage fee unit prices. Shipping data including shipping date, shipping number, warehouse, product, lot number, and quantity shipped, Incoming data including arrival date, arrival number, warehouse, product, lot number, and quantity received, Movement data including the date of departure, movement number, departure warehouse, product, lot number, date of arrival, arrival warehouse, and number of movements, Inventory information including accounting year and month, warehouse, product, lot number, inventory quantity at the end of the previous month, inventory quantity at the end of the current month, inventory value at the end of the current month, and inventory valuation cost at the end of the current month. It is configured to be accessible, The control unit executes: A storage fee calculation process that creates storage fee data, including accounting year and month, warehouse, product, lot number, inventory quantity at the end of the previous month, maximum inventory quantity which is the quantity that was at its highest in the warehouse during the current month, quantity received during the current month, quantity shipped out during the current month, inventory quantity at the end of the current month, and storage fee amount calculated by multiplying the maximum inventory quantity by the storage fee unit price, based on the aforementioned shipping data, the aforementioned receiving data, the aforementioned movement data, and the aforementioned inventory information, by referring to the aforementioned storage fee master. Based on the aforementioned storage fee data, the process outputs a deemed storage fee list that includes the accounting year and month, warehouse, product, inventory quantity at the end of the previous month, deemed storage fee amount for the previous month, inventory quantity at the end of the current month, deemed storage fee amount for the current month (which is the aforementioned storage fee amount), cumulative deemed storage fee amount (which is the sum of the cumulative deemed storage fee amount up to the previous month and the deemed storage fee amount for the current month), and the difference between the cumulative deemed storage fee amount and the deemed storage fee amount for the current month (which is the difference between the cumulative deemed storage fee amount and the deemed storage fee amount for the current month). A method for processing storage materials, characterized by including the following:

8. A storage fee processing program to be executed by an information processing device equipped with a control unit, The control unit, A storage fee master database is registered that associates warehouses, products, temperature zone classifications including chilled or frozen, and storage fee unit prices. Shipping data including shipping date, shipping number, warehouse, product, lot number, and quantity shipped, Incoming data including arrival date, arrival number, warehouse, product, lot number, and quantity received, Movement data including the date of departure, movement number, departure warehouse, product, lot number, date of arrival, arrival warehouse, and number of movements, Inventory information including accounting year and month, warehouse, product, lot number, inventory quantity at the end of the previous month, inventory quantity at the end of the current month, inventory value at the end of the current month, and inventory valuation cost at the end of the current month. It is configured to be accessible, The control unit, A storage fee calculation process that creates storage fee data, including accounting year and month, warehouse, product, lot number, inventory quantity at the end of the previous month, maximum inventory quantity which is the quantity that was at its highest in the warehouse during the current month, quantity received during the current month, quantity shipped out during the current month, inventory quantity at the end of the current month, and storage fee amount calculated by multiplying the maximum inventory quantity by the storage fee unit price, based on the aforementioned shipping data, the aforementioned receiving data, the aforementioned movement data, and the aforementioned inventory information, by referring to the aforementioned storage fee master. Based on the aforementioned storage fee data, the process outputs a deemed storage fee list that includes the accounting year and month, warehouse, product, inventory quantity at the end of the previous month, deemed storage fee amount for the previous month, inventory quantity at the end of the current month, deemed storage fee amount for the current month (which is the aforementioned storage fee amount), cumulative deemed storage fee amount (which is the sum of the cumulative deemed storage fee amount up to the previous month and the deemed storage fee amount for the current month), and the difference between the cumulative deemed storage fee amount and the deemed storage fee amount for the current month (which is the difference between the cumulative deemed storage fee amount and the deemed storage fee amount for the current month). A storage fee processing program to execute this process.

Images