Injection Force Receiving Device, Injection Force Receiving Method, and Injection Force Receiving Program

Abstract

To provide an order reception input apparatus, an order reception input method, and an order reception input program which can confirm a profit including logistics-related costs upon order reception.SOLUTION: An order reception input apparatus according to an embodiment of the present invention includes order reception input means for acquiring a delivery destination area from a first master using a delivery destination as a key when an inventory, an article, the number of ordered articles, a lot number, a shipment date, the delivery destination, and a delivery service are designated in order reception, acquiring a fare from a second master using the delivery service and the acquired delivery destination area as a key, acquiring a storage fee obtained by a unit price per day acquired from a third master using the inventory and the article as a key × (a difference between the shipment date and a reception date acquired from inventory data using the article and the lot number as a key), and calculating a profit including logistic costs based on the acquired fare and the acquired storage fee.SELECTED DRAWING: Figure 1

Description

Technical Field

[0001] The present invention relates to an order receiving input device, an order receiving input method, and an order receiving input program.

Background Art

[0002] For example, in the food industry with low profit margins and high sales volume, it is important to reduce logistics-related costs. If the profit including logistics-related costs is not visible at the time of order reception, for example, there are cases where discounts are made without being aware of the profit due to a long storage period in the warehouse, which compresses the profit. Conventionally, as a system for calculating gross profit, for example, there is Patent Document 1.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] However, Patent Document 1 does not describe anything regarding confirming the profit including logistics-related costs at the time of order reception.

[0005] The present invention has been made in view of the above, and an object thereof is to provide an order receiving input device, an order receiving input method, and an order receiving input program capable of confirming the profit including logistics-related costs at the time of order reception.

Means for Solving the Problems

[0006] In order to solve the above-described problems and achieve the object, the present invention provides an order-receiving input device including a control unit. The control unit is configured to be able to access a first master in which a delivery destination and a delivery destination area are registered in association with each other, a second master in which a delivery service, a delivery destination area, and a freight are registered in association with each other, a third master in which a warehouse and a daily storage fee are registered in association with each other for each product, and inventory data including a warehouse, a product, a lot number, and a receipt date. When an order is received and a warehouse, a product, an order quantity, a lot number, a shipping date, a delivery destination, and a delivery service are specified, the delivery destination area is acquired from the first master using the delivery destination as a key, the freight is acquired from the second master using the delivery service and the acquired delivery destination area as keys, and the storage fee is acquired by multiplying the daily storage fee acquired from the third master using the warehouse and the product as keys by (the shipping date - the receipt date acquired from the inventory data using the product and the lot number as keys). The order-receiving input device is characterized by including order-receiving input means for calculating the gross profit including the logistics cost based on the acquired freight and storage fee.

[0007] Further, according to one aspect of the present invention, the gross profit including the logistics cost may be calculated as the sales amount - the cost amount - the freight - the storage fee.

[0008] Further, according to one aspect of the present invention, the third master may include a product master in which a product and a temperature range for storage in a warehouse are registered in association with each other, and a storage fee unit price master in which a warehouse, a temperature range for storage in the warehouse, and a daily storage fee are registered in association with each other. The order-receiving input means may acquire the temperature range from the product master using the product as a key, and acquire the daily unit price acquired from the storage fee unit price master using the warehouse and the acquired temperature range as keys.

[0009] Further, according to one aspect of the present invention, the delivery service may include a regular service or an air service.

[0010] Also, according to one aspect of the present invention, the order receiving input means registers order receiving data including an order number, an order line number, a product, the order quantity, a lot number, a shipping date, a delivery destination, a shipping method, freight, storage fees, and gross profit including logistics costs in a storage unit, and the control unit further includes order receiving result inquiry means for extracting and displaying the order receiving data registered in the storage unit for a specified delivery destination on an inquiry screen displayed on a display unit.

[0011] Further, in order to solve the above-described problems and achieve the object, the present invention is an order receiving input method executed by an information processing apparatus including a control unit, wherein the control unit is configured to be able to access a first master in which a delivery destination and a delivery destination area are registered in association with each other, a second master in which a shipping method, a delivery destination area, and freight are registered in association with each other, a third master in which a warehouse and a daily storage fee are registered in association with each other for each product, and inventory data including a warehouse, a product, a lot number, and a receipt date. When a warehouse, a product, an order quantity, a lot number, a shipping date, a delivery destination, and a shipping method are specified at the time of order receiving, which is executed in the control unit, the delivery destination area is acquired from the first master using the delivery destination as a key, the freight is acquired from the second master using the shipping method and the acquired delivery destination area as keys, and the storage fee is acquired by multiplying the daily storage fee acquired from the third master using the warehouse and the product as keys by (the shipping date - the receipt date acquired from the inventory data using the product and the lot number as keys). The order receiving input process includes calculating the gross profit including logistics costs based on the acquired freight and storage fees.

[0012] Also, in order to solve the above-described problems and achieve the object, the present invention is an order reception input program for execution by an information processing apparatus including a control unit, wherein the control unit includes a first master in which a delivery destination and a delivery destination area are registered in association with each other, a second master in which a delivery service, a delivery destination area, and a freight are registered in association with each other, a third master in which a warehouse and a daily storage fee are registered in association with each other for each product, and inventory data including a warehouse, a product, a lot number, and a receipt date, and is configured to be accessible to the above. In the control unit, when an order is received and a warehouse, a product, an order quantity, a lot number, a shipment date, a delivery destination, and a delivery service are specified, the delivery destination area is acquired from the first master using the delivery destination as a key, the freight is acquired from the second master using the delivery service and the acquired delivery destination area as keys, and the daily storage fee acquired from the third master using the warehouse and the product as keys × (the shipment date - the receipt date acquired from the inventory data using the product and the lot number as keys) is used to acquire the storage fee, and an order reception input process for calculating the gross profit including the logistics cost is executed based on the acquired freight and storage fee. The order reception input program is characterized by this.

Effect of the Invention

[0013] According to the present invention, there is an effect that it becomes possible to confirm the profit including the logistics-related cost at the time of order reception.

Brief Description of the Drawings

[0014]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Figure 9

Figure 10

Figure 11

[0015] Embodiments of the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to the present embodiments.

[0016] [1. Overview] For example, in the food industry with low profit margins and high sales volume, it is important to reduce logistics-related costs. If the profit including logistics-related costs is not visible at the time of order reception, for example, there are cases where discounts are made without being aware of the profit due to a long stay period in the warehouse, which squeezes the profit.

[0017] Therefore, in the present embodiment, by enabling the confirmation (visualization) of the profit including logistics-related costs at the time of order reception, it is possible to utilize it as a reference for improvement when the same order is received in the future.

[0018] Specifically, identify products and customers with a declining gross profit rate, and change the delivery method after the next time, or utilize it for pricing (do not arbitrarily discount old products), etc.

[0019] In the order input device of the present embodiment, in order input, it is possible to hold logistics-related costs such as freight and storage fees in detail units. For freight, the freight master is used as a tariff. For storage fees, the storage period is calculated from the inventory data, and the storage fee unit price master unit price is multiplied by the storage period for calculation.

[0020] In the following description, food is taken as an example of a product for explanation, but the present invention is applicable not only to the food industry but also to other industries such as machinery and steel.

[0021] [2. Configuration] An example of the configuration of the order input device according to the present embodiment will be described with reference to FIG. 1. FIG. 1 is a block diagram showing an example of the configuration of the order input device according to the present embodiment.

[0022] The order input device 100 is a commercially available desktop personal computer. Note that the order input device 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, or tablet personal computer.

[0023] The order input device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part included in the order input device 100 is communicably connected via an arbitrary communication path.

[0024] The communication interface unit 104 communicably connects the receiving and input 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 via a communication line with other devices. Here, the network 300 has a function of communicably connecting the receiving and input device 100 and the server 200 to each other, and is, for example, the Internet or a LAN (Local Area Network).

[0025] An input / output interface unit 108 has an input device 112 and an output device 114 connected thereto. As the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. In the following, 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.

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

[0027] Further, the storage unit 106 includes a freight master 106a, a delivery destination master 106b, a product master 106c, a storage fee unit price master 106d, a data table 106e, and a work table 106f. FIG. 2 is a diagram showing an example of the data structure and the relationship among the freight master 106a, the delivery destination master 106b, the product master 106c, the storage fee unit price master 106d, the inventory data, the order receiving data, and the storage fee work.

[0028] The freight master 106a (second master) can be composed of a table or the like that registers by associating a delivery service (code and / or name) including regular or air freight, a delivery destination area (code and / or name), freight, etc.

[0029] The delivery destination master 106b (first master) can be composed of a table or the like that registers by associating a delivery destination (code and / or name) and a delivery destination area (code and / or name).

[0030] The product master 106c can be composed of a table or the like that registers by associating a product (code and / or name) and a temperature range (code and / or name) when stored in a warehouse.

[0031] The storage fee unit price master 106d can be composed of a table or the like that registers by associating a warehouse (code and / or name), a temperature range (code and / or name), and a unit price per day.

[0032] The product master 106c and the storage fee unit price master 106d constitute the third master. The product master 106c and the storage fee unit price master 106d may be configured separately, integrated, or may not have a "temperature range" configuration.

[0033] The data table 106e is a table for storing various data such as inventory data and order data.

[0034] The inventory data may include a warehouse (code and / or name), a product (code and / or name), a lot number, and a receipt date.

[0035] The order data may include an order number, an order line number, a delivery destination code, a delivery service code, a product code, a lot number, a shipment date, an order quantity, a sales amount, a cost amount, freight, storage fee, and gross profit.

[0036] The work table 106f is a table for use as the work area of the control unit 102. Work data (intermediate data) and the like are generated, and it includes, for example, a storage fee work for calculating storage fees.

[0037] The storage fee work may be configured to temporarily hold the unit price per day, the shipping date, the receiving date, the storage fee, and the like.

[0038] Returning to FIG. 1, the control unit 102 is a CPU or the like that comprehensively controls the order input device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs defining various processing procedures, and required data, and executes various information processes based on these stored programs.

[0039] The control unit 102 is configured to be able to access the freight master 106a, the delivery destination master 106b, the product master 106c, the storage fee unit price master 106d, the data table 106e, and the work table 106f stored in the storage unit 106. Note that the freight master 106a, the delivery destination master 106b, the product master 106c, the storage fee unit price master 106d, the data table 106e, and the work table 106f may be provided in another location (for example, the server 200) as long as the control unit 102 can access them.

[0040] Functionally conceptually, the control unit 102 includes a master maintenance unit 102a, an inventory management unit 102b, an order input unit 102c, an order performance inquiry unit 102d, and a screen display control unit 102e.

[0041] The master maintenance unit 102a performs settings such as data input, addition, deletion, and editing on the freight master 106a, the delivery destination master 106b, the product master 106c, and the storage fee unit price master 106d in response to operations of an operator on a master maintenance screen (not shown) displayed on the monitor 114, for example.

[0042] The inventory management department 102b updates the inventory data in the data table 106e according to the incoming and outgoing of products in the warehouse.

[0043] When placing an order, for example, according to the operator's operation on the order input screen (see Figure 10) displayed on the monitor 114, when the warehouse, product, order quantity, lot number, shipping date, delivery destination, and shipping method are specified, the receiving order input department 102c obtains the delivery area from the first master (for example, the delivery destination master 106b) using the delivery destination as the key, obtains the freight from the second master (for example, the freight master 106a) using the shipping method and the obtained delivery area as the keys, and obtains the storage fee by multiplying the unit price per day obtained from the third master (for example, the product master 106c and the storage fee unit price master 106d) using the warehouse and the product as the keys by (the shipping date - the incoming date obtained from the inventory data using the product and the lot number as the keys). Based on the obtained freight and storage fee, the gross profit including logistics-related costs is calculated, and order data including the order number, order line number, product, order quantity, lot number, shipping date, delivery destination, shipping method, freight, storage fee, and gross profit including logistics costs is registered in the data table 106e.

[0044] The receiving order input department 102c may calculate the gross profit including logistics costs as sales amount - cost amount - freight - storage fee.

[0045] The third master may be composed of the product master 106c and the storage fee unit price master 106d. The receiving order input department 102c may obtain the temperature zone from the product master 106c using the product as the key, and obtain the unit price per day from the storage fee unit price master 106d using the warehouse and the obtained temperature zone as the keys.

[0046] The order fulfillment inquiry department 102d extracts and displays the order data registered in the data table 106e for the delivery destination specified by the operator on the order fulfillment inquiry screen displayed on the monitor 114.

[0047] The screen display control unit 102e controls the display of various screens (e.g., master maintenance screen, order reception input screen, order reception performance inquiry screen, etc.) to be displayed on the monitor 114 and their input.

[0048] [3. Specific Example] With reference to FIGS. 1 to 11, a specific example of the processing of the order reception input device 100 in the present embodiment will be described. FIGS. 3 to 11 are diagrams for explaining a specific example of the processing of the order reception input device 100 in the present embodiment.

[0049] (3-1. Overall Processing) With reference to FIG. 3, an example of the overall processing of the control unit of the order reception input device 100 in the present embodiment will be described. FIG. 5 is a diagram for explaining an example of the overall processing of the control unit of the order reception input device 100 in the present embodiment.

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

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

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

[0053] The master maintenance unit 102a executes a storage fee unit price master maintenance process (step S4). Specifically, in the storage fee unit price master maintenance process, the master maintenance unit 102a sets data for the storage fee unit price master 106d, for example, according to the operator's operation on a master maintenance screen (not shown) displayed on the monitor 114.

[0054] The order input unit 102c executes an order input process (step S5). In the order input process, when inputting an order, the freight is calculated based on the delivery destination master 106b and the freight master 106a, and the storage fee is calculated using the storage fee work in the data table 106e based on the product master 106c, the storage fee unit price master 106d, and the inventory data. By calculating the gross profit including logistics-related costs based on the freight and the storage fee, a simulation of the profit and loss is performed.

[0055] Specifically, in the order input process, when the operator operates on the order input screen (see Fig. 10) displayed on the monitor 114 during order input, and when the warehouse, product, order quantity, lot number, shipping date, delivery destination, and delivery method are specified, the delivery destination area is obtained from the delivery destination master 106b using the delivery destination as the key, the freight is obtained from the freight master 106a using the delivery method and the obtained delivery destination area as the key, the storage fee is obtained by multiplying the unit price per day obtained from the storage fee unit price master 106d using the temperature zone obtained from the product master 106c with the warehouse as the key by (shipping date - receipt date obtained from the inventory data using the product and lot number as the key), and based on the obtained freight and storage fee, the gross profit (= sales amount - cost amount - freight - storage fee) including logistics-related costs (= freight + storage fee) is calculated, and order data including the order number, order line number, product, order quantity, lot number, shipping date, delivery destination, delivery method, freight, storage fee, and gross profit including logistics-related costs is registered in the data table 106e.

[0056] (3-2. Sample Data) Figures 4 to 11 are diagrams showing sample data for explaining specific examples of the processing of the control unit 102 of the receiving input device 100 according to the present embodiment. With reference to Figures 4 to 11, specific examples of the processing of the control unit 102 of the receiving input device 100 according to the present embodiment will be described. In the following description, all units of amount of money are "yen", and their notations are omitted.

[0057] (Premise data) Figure 4 shows an example of the data of the freight master 106a. The freight master 106a includes items such as a delivery service code, a delivery destination area, and freight. In the example shown in the figure, the first line has a delivery service code "HA001: Regular service", a delivery destination area "Kanto area", and freight "800"; the second line has a delivery service code "HA001: Regular service", a delivery destination area "Okinawa area", and freight "900"; the third line has a delivery service code "HA002: Using air freight", a delivery destination area "Okinawa area", and freight "2500".

[0058] Since the freight master 106a is not used for actual freight payment (for the purpose of income and expenditure simulation), it deliberately does not have detailed information such as weight, departure place, arrival place, and unloading fees, and emphasizes maintainability. The temperature zone is managed by dividing the delivery service code. Regarding freight, by having a freight master for each physical distance of the delivery destination and each delivery means, it is possible to calculate the accurate transportation cost for each transaction.

[0059] Figure 5 shows an example of the data of the delivery destination master 106b. The delivery destination master 106b includes items such as a delivery destination code and a delivery destination area. In the example shown in the figure, the first line has a delivery destination code "N001 (Chiba Co., Ltd.)" and a delivery destination area "Kanto area"; the second line has a delivery destination code "N002 (Okinawa Co., Ltd.)" and a delivery destination area "Okinawa area".

[0060] Figure 6 is a diagram showing an example of the data of the product master 106c. The product master 106c includes items such as a product code and a temperature zone. In the example shown in the figure, the product code is "12345 Purchased Product A" and the temperature zone is "C001 Normal temperature".

[0061] FIG. 7 is a diagram showing a data example of the storage fee unit price master 106d. The storage fee unit price master 106d includes items such as a warehouse code, a temperature zone, and a unit price per day. In the example shown in the figure, the first row shows the warehouse code "SO001 Kyobashi Warehouse", the temperature zone "C001 Normal Temperature", the unit price per day "10", the second row shows the warehouse code "SO001 Kyobashi Warehouse", the temperature zone "C002 Refrigerated", the unit price per day "15", and the third row shows the warehouse code "SO001 Kyobashi Warehouse", the temperature zone "C003 Frozen", the unit price per day "20".

[0062] FIG. 8 is a diagram showing a data example of the inventory data. The inventory data includes items such as a warehouse code, a product code, a lot number, and a receipt date. In the example shown in the figure, the first row shows the warehouse code "SO001 Kyobashi Warehouse", the product code "12345 Purchased Product A", the lot number "lot1234", the receipt date "2021 / 12 / 14", the second row shows the warehouse code "SO001 Kyobashi Warehouse", the product code "12345 Purchased Product A", the lot number "lot1235", the receipt date "2022 / 1 / 13", and the third row shows the warehouse code "SO001 Kyobashi Warehouse", the product code "12345 Purchased Product A", the lot number "lot1236", the receipt date "2021 / 8 / 31".

[0063] FIG. 9 is a diagram showing a data example (part) of the order receiving data. The order receiving data includes items such as an order receiving number, an order receiving line number, a delivery destination code, a delivery method code, a product code, a lot number, a shipping date, an order receiving quantity, a sales amount, a cost amount, freight, storage fee, and gross profit. The order receiving number, the order receiving line number, the delivery destination code, the delivery method code, the product code, the lot number, the shipping date, the order receiving quantity, the sales amount, and the cost amount are input by an operator on, for example, the order receiving input screen. The freight, the storage fee, and the gross profit are calculated by the order receiving input unit 102c at the time of order receiving.

[0064] In the example shown in the figure, the first line shows the product code "12345 Purchased Product A", the supplier code "N001 Chiba Co., Ltd.", the lot number "lot1234", the shipping date "2022 / 2 / 14". The second line shows the product code "12345 Purchased Product A", the supplier code "N002 Okinawa Co., Ltd.", the lot number "lot1235", the shipping date "2022 / 2 / 13". The third line shows the product code "12345 Purchased Product A", the supplier code "N002 Okinawa Co., Ltd.", the lot number "lot1236", the shipping date "2022 / 1 / 31".

[0065] (S5: Order Input Processing) Referring to FIGS. 10 and 11, a specific example of the order input process will be described. When, for example, the order input unit 102c designates (inputs) the warehouse, product, order quantity, lot number, shipping date, supplier, and shipping method on the order input screen (see FIG. 10) displayed on the monitor 114 in response to an operator's operation during an order, the delivery area is acquired from the supplier master 106b using the supplier as a key, the freight is acquired from the freight master 106a using the shipping method and the acquired delivery area as keys, the temperature range acquired from the product master 106c using the product as a key and the storage fee per unit per day acquired from the storage fee unit price master 106d using the warehouse as a key × (the shipping date - the arrival date acquired from the inventory data using the product and the lot number as keys) is used to acquire the storage fee, and based on the acquired freight and storage fee, the gross profit ( = sales amount - cost amount - freight - storage fee) including logistics-related costs ( = freight + storage fee) is calculated, and order data including the order number, order line number, product, order quantity, lot number, shipping date, supplier, shipping method, freight, storage fee, and gross profit including logistics-related costs is registered in the data table 106e.

[0066] FIG. 10 is a diagram showing an example image of the order input screen. The order input screen includes a header section, a detail section, and a footer section. In the header section, the operator designates (inputs), for example, the order number, business office, order date, shipping date, customer, person in charge, warehouse, etc. The detail section includes items such as product, order quantity, freight, selling unit price, sales amount, sales consumption tax, supplier, storage fee, consumption tax classification, external tax, cost amount, gross profit, lot number, shipping method, regular shipping, and logistics cost for each line number.

[0067] The product, order quantity, unit selling price, sales amount, sales consumption tax, delivery destination, consumption tax classification, external tax, cost amount, lot number, and delivery method are specified by an operator, for example. When an execution button (not shown) is pressed, the order input section 102c acquires a delivery destination area from the delivery destination master 106b using the delivery destination as a key, acquires the freight from the freight master 106a using the delivery method and the acquired delivery destination area as keys, acquires the temperature zone from the product master 106c using the product as a key, and acquires the storage fee from the storage fee unit price master 106d using the warehouse as a key by multiplying the unit price per day by (shipment date - receipt date acquired from the inventory data using the product and lot number as keys). Based on the acquired freight and storage fee, the logistics cost (= freight + storage fee) and the gross profit including the logistics cost (sales amount - cost amount - logistics cost) are calculated, and the freight, storage fee, logistics cost, and gross profit are displayed.

[0068] In the footer section, the total amount of the details (total amount per order number) is displayed by the order input section 102c, and the cost amount, gross profit, logistics cost (= total of freight and storage fee in the details), and gross profit including the logistics cost (gross profit in the footer section - logistics cost in the footer section) are displayed.

[0069] When a registration button (not shown) is pressed, order data corresponding to the screen content is displayed in the data table 106e.

[0070] In the example shown in the figure, in the header section, the order number "J001", business office "100 Tokyo Head Office", order date "2022 / 2 / 13", shipment date "2022 / 2 / 14", customer "A001 △△ Industries", and warehouse "SO001 Kyobashi Warehouse" are specified.

[0071] Also, for the line number "1" in the details section, the product is "12345 Purchased Product A", the order quantity is "10 pieces", the selling unit price is "1,000", the sales amount is "10,000", the sales consumption tax is "200", the delivery destination is "N001 Chiba Co., Ltd.", the consumption tax classification is "outside tax", the cost amount is "8,000", the lot number is "lot1234", and the delivery service is "HA001 Regular Delivery". When an execution button (not shown) is pressed, the order input section 102c acquires the delivery area "Kanto Area" from the delivery destination master 106b using the delivery destination "N001 Chiba Co., Ltd." as the key, and acquires the freight "800" from the freight master 106a using the delivery service "HA001 Regular Delivery" and the acquired delivery area "Kanto Area" as the keys.

[0072] Also, the temperature zone "C001 Normal Temperature" is acquired from the product master 106c using the product "12345 Purchased Product A" as the key, and the unit price per day "10" is acquired from the storage fee unit price master 106d using the temperature zone "C001 Normal Temperature" and the warehouse "SO001 Kyobashi Warehouse" as the keys. Then, the storage fee "620" is calculated by multiplying the acquired unit price per day "10" by (the shipping date "2022 / 2 / 14" - the arrival date "2021 / 12 / 14" acquired from the inventory data using the product "12345 Purchased Product A" and the lot number "lot1234" as the keys). And the logistics cost "1,420 (=800 + 620)" is calculated. Furthermore, the gross profit including the logistics cost "580 (=sales amount "10,000 - cost amount "8,000 - logistics cost "1,420)" is calculated. Then, the calculated freight "800", storage fee "620", logistics cost "1,420", and gross profit "580" are displayed.

[0073] The line numbers "2" and "3" in the details section are processed in the same way. In the example shown in the figure, for example, for the delivery destination "N002 Okinawa" and the delivery service "HA002 Using Air Delivery" in line number "3", it can be known at the time of order that the gross profit is in the red " - 2,030", so unit price negotiation can be carried out.

[0074] In the example shown in Figure 10, when a registration button (not shown) is pressed, the order data as shown in Figures 11(A) to (C) is registered in the data table 106e.

[0075] Fig. 11(A) shows the case of ordinary mail delivery to a nearby delivery destination (Chiba), Fig. 11(B) shows the case of ordinary mail delivery to a delivery destination in a remote area (Okinawa), and Fig. 11(C) shows the case of airmail delivery to a delivery destination in a remote area (Okinawa).

[0076] Although it seems that profit is generated from the gross profit of only the goods, it is possible to grasp how much profit is generated including freight and storage fees at the time of order receipt. If the profit including logistics costs is not visible at the time of order receipt, there are cases where discounts are made without being aware of the profit due to the long detention period, resulting in squeezing the profit. By enabling the confirmation of the profit including logistics costs at the time of order receipt, it is possible to reasonably make decisions on price discounts for goods and selection of delivery methods during negotiations in future transactions.

[0077] The order receipt performance inquiry unit 102d extracts and displays the order receipt data registered in the data table 106e for the delivery destination specified by the operator on the order receipt performance inquiry screen displayed on the monitor 114.

[0078] Fig. 11(D) shows an output example of order receipt performance inquiry. In the figure, an output example is shown when the delivery destination "N002 (Co., Ltd.) Okinawa" is specified.

[0079] By checking the order receipt performance by delivery destination from the order receipt performance inquiry, it is possible to find abnormal values of gross profit from the order receipt performance to the same delivery destination and utilize them as a trigger for cause investigation and improvement. In this example, it is assumed that the gross profit deteriorated due to the use of airmail for the order receipt performance in the second row, which can be utilized for negotiations to increase the unit price or not use airmail when using airmail in the future.

[0080] As described above, according to the present embodiment, a first master in which a delivery destination and a delivery destination area are registered in association with each other, a second master in which a delivery service, a delivery destination area, and a freight are registered in association with each other, and for each product, a third master in which a warehouse and a daily storage fee are registered in association with each other. When a warehouse, a product, an order quantity, a lot number, a shipping date, a delivery destination, and a delivery service are specified at the time of order reception, the delivery destination area is acquired from the first master using the delivery destination as a key, the freight is acquired from the second master using the delivery service and the acquired delivery destination area as keys, and the storage fee is acquired by multiplying the unit price per day acquired from the third master using the warehouse and the product as keys by (shipping date - receipt date acquired from the inventory data using the product and the lot number as keys). Since the order input unit 102c calculates the gross profit including the logistics cost based on the acquired freight and storage fee, It becomes possible to confirm the profit including the logistics-related cost at the time of order reception.

[0081] [4. Contribution to the Sustainable Development Goals (SDGs) Led by the United Nations] According to the present embodiment, since it can contribute to promoting business efficiency and appropriate business judgment of the company, it becomes possible to contribute to Goals 8 and 9 of the SDGs.

[0082] In addition, according to the present embodiment, since it can contribute to reducing waste loss and promoting paperless and digitization, it becomes possible to contribute to Goals 12, 13, and 15 of the SDGs.

[0083] In addition, according to the present embodiment, since it can contribute to strengthening control and governance, it becomes possible to contribute to Goal 16 of the SDGs.

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

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

[0086] In addition, regarding 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 the drawings, they can be arbitrarily changed unless otherwise specified.

[0087] Regarding the order receiving input device 100, each of the illustrated components is a functional concept, and it is not necessarily physically configured as shown in the drawings.

[0088] For example, regarding the processing functions provided by the order receiving input device 100, particularly each processing function performed by the control unit, all or any part of them may be realized by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware by wired logic. Note that the program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing an information processing device to execute the processes described in this embodiment, and is mechanically read by the order receiving input device 100 as necessary. That is, in a storage unit such as a ROM or an HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS to perform various processes is recorded. This computer program is executed by being loaded into the RAM and constitutes the control unit in cooperation with the CPU.

[0089] In addition, this computer program may be stored in an application program server connected to the order receiving input device 100 via an arbitrary network, and all or part of it can be downloaded as necessary.

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

[0091] Also, the "program" is a data processing method described in any 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 being configured singly, and also includes those that are distributedly configured as a plurality of modules or libraries, or those that achieve their functions in cooperation with other separate programs represented by an OS. Regarding the specific configuration, reading procedure, and installation procedure after reading for reading the recording medium in each device shown in the embodiment, well-known configurations and procedures can be used.

[0092] The various databases and the like stored in the storage unit are storage means such as a memory device such as a RAM or a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0093] Further, the receiving input 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 any peripheral device is connected. Further, the receiving input device 100 may be realized by installing software (including programs or data, etc.) for realizing the processing described in this embodiment in the device.

[0094] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the figures, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or according to the functional load. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

Explanation of Reference Numerals

[0095] 100 Receiving input device 102 Control unit 102a Master maintenance unit 102b Inventory management unit 102c Receiving input unit 102d Order receipt result inquiry unit 102e Screen display control unit 104 Communication interface unit 106 Storage unit 106a Freight master 106b Supplier master 106c Product master 106d Storage fee unit price master 106e Data table 106f Work table 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims

1. An order receiving input device comprising a control unit, wherein the control unit has a first master in which a delivery destination and a delivery destination area are registered in association with each other, a second master in which a delivery service, a delivery destination area, and a freight are registered in association with each other, a third master in which, for each product, a warehouse and a daily storage fee are registered in association with each other, is configured to be accessible to inventory data including a warehouse, a product, a lot number, and a receipt date, and when a warehouse, a product, an order quantity, a lot number, a shipment date, a delivery destination, and a delivery service are specified at the time of receiving an order, the control unit acquires a delivery destination area from the first master using the delivery destination as a key, acquires a freight from the second master using the delivery service and the acquired delivery destination area as keys, and acquires a daily storage fee × (the shipment date - the receipt date acquired from the inventory data using the product and the lot number as keys) obtained from the third master using the warehouse and the product as keys, and includes order receiving input means for calculating a gross profit including logistics costs based on the acquired freight and storage fee, the third master includes a product master in which a product and a temperature range for storage in a warehouse are registered in association with each other, and a storage fee unit price master in which a warehouse, a temperature range for storage in the warehouse, and a daily storage fee are registered in association with each other, and the order receiving input means is characterized by acquiring a temperature range from the product master using the product as a key, and acquiring a daily storage fee obtained from the storage fee unit price master using the warehouse and the acquired temperature range as keys. An order receiving input device.

2. The order receiving input device according to claim 1, wherein the gross profit including the logistics cost is calculated as sales amount - cost amount - freight - storage fee.

3. The order receiving input device according to claim 1, wherein the delivery service includes a regular service or an air service.

4. The order receiving input means registers order receiving data including an order receiving number, an order receiving line number, a product, an order quantity, a lot number, a shipment date, a delivery destination, a delivery service, a freight, a storage fee, and a gross profit including logistics costs in a storage unit, and the control unit further includes order receiving performance inquiry means for extracting and displaying output the order receiving data registered in the storage unit for a specified delivery destination on an inquiry screen displayed on a display unit, according to any one of claims 1 to 3. The order receiving input device described.

5. An order receiving input method executed by an information processing device comprising a control unit, wherein the control unit ​ A first master that registers by associating a delivery destination and a delivery destination area; A second master that registers by associating a delivery service, a delivery destination area, and a freight charge; For each product, a third master that registers by associating a warehouse and a daily storage fee; Inventory data including a warehouse, a product, a lot number, and a receipt date; It is configured to be accessible to; Executed by the control unit; When placing an order, when a warehouse, a product, the order quantity, a lot number, a shipping date, a delivery destination, and a delivery service are specified, the delivery destination area is acquired from the first master using the delivery destination as a key, the freight charge is acquired from the second master using the delivery service and the acquired delivery destination area as keys, and the daily storage fee obtained from the third master using the warehouse and the product as keys × (the shipping date - the receipt date obtained from the inventory data using the product and the lot number as keys) is used to obtain the storage fee. An order input process for calculating the gross profit including the logistics cost is included. The third master includes a product master that registers by associating a product and a temperature range for storage in a warehouse, and a storage fee unit price master that registers by associating a warehouse, a temperature range for storage in the warehouse, and a daily storage fee. In the order input process, the temperature range is acquired from the product master using the product as a key, and the daily storage fee obtained from the storage fee unit price master using the warehouse and the acquired temperature range as keys is acquired. The order input method is characterized by this.

6. An order input program for causing an information processing apparatus provided with a control unit to execute, The control unit is, A first master that registers by associating a delivery destination and a delivery destination area; A second master that registers by associating a delivery service, a delivery destination area, and a freight charge; For each product, a third master that registers by associating a warehouse and a daily storage fee; Inventory data including a warehouse, a product, a lot number, and a receipt date; It is configured to be accessible to; To the control unit, When a warehouse, product, order quantity, lot number, shipping date, delivery destination, and shipping method are specified at the time of order reception, the delivery area is obtained from the first master using the delivery destination as a key, the freight is obtained from the second master using the shipping method and the obtained delivery area as keys, and the storage fee is obtained by multiplying the daily storage fee obtained from the third master using the warehouse and the product as keys by (the shipping date - the receipt date obtained from the inventory data using the product and the lot number as keys). It is an order input program for executing an order input process for calculating the gross profit including logistics costs based on the obtained freight and storage fee. The third master includes a product master registered by associating a product with a temperature zone when stored in a warehouse, and a storage fee unit price master registered by associating a warehouse, a temperature zone when stored in the warehouse, and a daily storage fee. In the order input process, the order input program is characterized in that the temperature zone is obtained from the product master using the product as a key, and the daily storage fee obtained from the storage fee unit price master using the warehouse and the obtained temperature zone as keys is obtained.

Images