Order reception input apparatus, order reception input method, and order reception input 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 entry device, an order entry method, and an order entry program. [Background technology]

[0002] For example, in the food industry, where high volume is sold at low profit margins, it is important to reduce logistics-related costs. If profits including logistics-related costs are not known at the time of order acceptance, there are cases where discounts are given without consideration of profits, for example, because goods are stored in the warehouse for a long time, which puts pressure on profits. Conventional systems for calculating gross profits include, for example, Patent Document 1. [Prior art documents] [Patent documents]

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

[0004] However, Patent Document 1 does not state anything about confirming profits including logistics-related costs at the time of receiving an order.

[0005] The present invention has been made in consideration of the above, and aims to provide an order input device, an order input method, and an order input program that make it possible to confirm profits including logistics-related costs at the time of order receipt. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides an order input device equipped with a control unit, which is configured to be able to access a first master that registers delivery destinations and delivery areas in association with each other, a second master that registers delivery flights, delivery areas, and shipping charges in association with each other, a third master that registers, for each product, warehouses and daily storage fees in association with each other, and inventory data including warehouses, products, lot numbers, and entry dates.When an order is placed, and a warehouse, product, order quantity, lot number, shipping date, delivery destination, and delivery flight are specified, the order input means obtains the delivery area from the first master using the delivery destination as a key, obtains the shipping fee from the second master using the delivery flight and the obtained delivery area as keys, obtains the storage fee by multiplying the daily storage fee obtained from the third master using the warehouse and product as keys by (the shipping date - the arrival date obtained from the inventory data using the product and the lot number as keys), and calculates gross profit including logistics costs based on the obtained shipping and storage fees.

[0007] According to another 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] Furthermore, according to one aspect of the present invention, the third master includes a product master in which a product is registered in association with a temperature range when stored in a warehouse, and a storage fee unit price master in which a warehouse is registered in association with a temperature range when stored in the warehouse, and a storage fee per day, and the order input means may obtain the temperature range from the product master using the product as a key, and obtain the unit price per day from the storage fee unit price master using the warehouse and the obtained temperature range as keys.

[0009] According to another aspect of the present invention, the delivery service may include regular mail or air mail.

[0010] According to one aspect of the present invention, the order input means registers order data having an order number, order line number, product, order quantity, lot number, shipping date, delivery destination, delivery method, freight, storage fee, and gross profit including logistics costs in a memory unit, and the control unit may further include an order performance inquiry means for extracting and displaying the order data registered in the memory unit for a specified delivery destination on an inquiry screen displayed on the display unit.

[0011] In order to solve the above-mentioned problems and achieve the object, the present invention provides an order entry method executed by an information processing device having a control unit, wherein the control unit is configured to be able to access a first master in which delivery destinations and delivery destination areas are registered in association with each other, a second master in which delivery routes, delivery destination areas, and shipping fees are registered in association with each other, a third master in which warehouses and daily storage fees are registered in association with each other for each product, and inventory data including warehouses, products, lot numbers, and warehousing dates, and the order entry method executed by the control unit includes, when an order is received, a first master in which warehouses, products, order quantities, When the lot number, shipping date, delivery destination, and delivery service are specified, the system includes an order input process in which the delivery destination is used as a key to obtain the delivery area from the first master, the shipping fee is obtained from the second master using the delivery service and the obtained delivery area as keys, the storage fee is obtained from the third master using the warehouse and the product as keys by multiplying the daily storage fee by (the shipping date - the arrival date obtained from the inventory data using the product and the lot number as keys), and gross profit including logistics costs is calculated based on the obtained shipping fee and storage fee.

[0012] In order to solve the above-mentioned problems and achieve the object, the present invention provides an order entry program to be executed by an information processing device having a control unit, the control unit being configured to be able to access a first master in which delivery destinations and delivery destination areas are registered in association with each other, a second master in which delivery routes, delivery destination areas, and shipping fees are registered in association with each other, a third master in which warehouses and daily storage fees are registered in association with each other for each product, and inventory data including warehouses, products, lot numbers, and warehousing dates, and the control unit is configured to access a first master in which delivery destinations and delivery destination areas are registered in association with each other, a second master in which delivery routes, delivery destination areas, and shipping fees are registered in association with each other for each product, and inventory data including warehouses, products, lot numbers, and warehousing dates when an order is received. When a date, delivery destination, and delivery service are specified, the program executes an order entry process that obtains the delivery area from the first master using the delivery destination as a key, obtains the shipping fee from the second master using the delivery service and the obtained delivery area as keys, obtains the storage fee by multiplying the daily storage fee obtained from the third master using the warehouse and the product as keys by (the shipping date - the arrival date obtained from the inventory data using the product and lot number as keys), and calculates gross profit including logistics costs based on the obtained shipping fee and storage fee. [Effects of the Invention]

[0013] The present invention has the effect of making it possible to confirm profits including logistics-related costs at the time of order acceptance. [Brief explanation of the drawings]

[0014] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of an order input device according to this embodiment. [Figure 2] FIG. 2 is a diagram showing an example of the data structure and relationships of the freight master, delivery destination master, product master, storage fee unit price master, inventory data, order data, and storage fee work. [Figure 3] FIG. 3 is a diagram showing an example of the overall processing flow of the control unit of the order input device 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 order input device according to the present 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 order input device 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 order input device according to the present 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 order input device according to the present 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 order input device according to the present 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 order input device 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 order input device 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 order input device according to this embodiment. DETAILED DESCRIPTION OF THE INVENTION

[0015] 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.

[0016] [1. Overview] For example, in the food industry, where profits are high and profitable, it is important to reduce logistics costs. If profits, including logistics costs, are not visible at the time of order acceptance, there are cases where discounts are offered without considering profits, for example, because goods are stored in the warehouse for a long time, which puts pressure on profits.

[0017] Therefore, in this embodiment, by making it possible to confirm (visualize) profits including logistics-related costs at the time of order receipt, it is possible to use this as a guide for improvement the next time a similar order is received.

[0018] Specifically, we identify products and customers with declining gross profit margins and use this information to change delivery methods from next time onwards or in pricing (avoiding unnecessary discounts on old products).

[0019] The order entry device of this embodiment allows for the entry of orders to hold logistics-related costs such as freight and storage fees for each item. For freight, the freight master is used as the tariff. For storage fees, the storage period is calculated from inventory data, and the storage period is multiplied by the unit price in the storage fee unit price master.

[0020] In the following description, food products will be used as an example of products, but the present invention is not limited to the food industry and can also be applied to other industries such as machinery and steel.

[0021] [2. Configuration] An example of the configuration of an order input device 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 an order input device according to this 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, 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.

[0023] The order input device 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units comprised in the order input device 100 are connected to each other so as to be able to communicate with each other via any communication path.

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

[0025] 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.

[0026] 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.

[0027] The storage unit 106 also 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. Figure 2 shows an example of the data structure and relationships of the freight master 106a, the delivery destination master 106b, the product master 106c, the storage fee unit price master 106d, inventory data, order data, and storage fee work.

[0028] The freight master 106a (second master) can be composed of a table or the like that associates and registers delivery routes (codes and / or names) including regular and air freight, delivery areas (codes and / or names), freight charges, etc.

[0029] The delivery destination master 106b (first master) can be configured as a table or the like in which delivery destinations (codes and / or names) and delivery destination areas (codes and / or names) are registered in association with each other.

[0030] The product master 106c can be configured as a table or the like in which products (codes and / or names) and temperature ranges (codes and / or names) for storage in a warehouse are registered in association with each other.

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

[0032] The product master 106c and the storage fee unit price master 106d constitute a third master, and the product master 106c and the storage fee unit price master 106d may be configured separately or integrated, or may be configured without a ``temperature zone.''

[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 the warehouse (code and / or name), the product (code and / or name), the lot number, and the date of receipt.

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

[0036] The work table 106f is a table to be used as a work area of ​​the control unit 102, in which work data (intermediate data) and the like are generated, and which includes, for example, a storage fee work for calculating a storage fee.

[0037] The storage fee work may be configured to temporarily hold the daily unit price, shipping date, warehousing date, storage fee, etc.

[0038] Returning to Fig. 1, the control unit 102 is a CPU or the like that performs overall control of the order input device 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.

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

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

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

[0042] The inventory management unit 102b updates the inventory data in the data table 106e in response to the arrival and departure of products from the warehouse.

[0043] When the warehouse, product, order quantity, lot number, shipping date, delivery destination, and delivery service are specified at the time of order placement in response to an operator's operation on the order entry screen (see FIG. 10) displayed on the monitor 114, the order input unit 102c acquires the delivery destination area from a first master (e.g., delivery destination master 106b) using the delivery destination as a key, acquires the shipping fee from a second master (e.g., freight master 106a) using the delivery service and the acquired delivery destination area as keys, acquires the storage fee by multiplying the daily unit price acquired from a third master (e.g., product master 106c and storage fee unit price master 106d) using the warehouse and product as keys by (the shipping date - the arrival date acquired from inventory data using the product and lot number as keys), calculates gross profit including logistics-related costs based on the acquired shipping fee and storage fee, and registers the order data having the gross profit including the order number, order line number, product, order quantity, lot number, shipping date, delivery destination, delivery service, shipping fee, storage fee, and logistics costs in the data table 106e.

[0044] The order input unit 102c may calculate the gross profit including the logistics cost by subtracting the sales amount from the cost amount, the freight charge, and the storage charge.

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

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

[0047] The screen display control unit 102e controls the display of various screens (for example, a master maintenance screen, an order entry screen, an order record inquiry screen, etc.) displayed on the monitor 114 and the input therefor.

[0048] [3. Specific Examples] A specific example of the processing of order input device 100 in this embodiment will be described with reference to Figures 1 to 11. Figures 3 to 11 are diagrams for explaining a specific example of the processing of order input device 100 in this embodiment.

[0049] (3-1. Overall processing) An example of the overall processing of the control unit of order input device 100 in this embodiment will be described with reference to Fig. 3. Fig. 5 is a diagram for explaining an example of the overall processing of the control unit of order input device 100 in this embodiment.

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

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

[0052] The master maintenance unit 102a executes a product master maintenance process (step S3). Specifically, in the product master maintenance process, the master maintenance unit 102a sets data in the product master 106c 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 storage fee unit price master maintenance processing (step S4). Specifically, in the storage fee unit price master maintenance processing, the master maintenance unit 102a sets data in the storage fee unit price master 106d in response to an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114, for example.

[0054] The order input unit 102c executes the order input process (step S5). In the order input process, when an order is input, the shipping cost is calculated based on the delivery destination master 106b and the shipping cost 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, and a profit margin including logistics-related costs is calculated based on the shipping cost and the storage fee, thereby simulating the income and expenditure.

[0055] Specifically, in the order input process, when an operator operates the order input screen (see FIG. 10) displayed on the monitor 114 and specifies a warehouse, product, order quantity, lot number, shipping date, delivery destination, and delivery service at the time of order acceptance, the order input unit 102c acquires a delivery destination area from the delivery destination master 106b using the delivery service and the acquired delivery destination area as keys, acquires a shipping fee from the shipping fee master 106a using the product as keys, and acquires a temperature range and warehouse acquired from the product master 106c as keys. The storage fee is obtained by multiplying the daily unit price obtained from the storage fee unit price master 106d by (shipping date - arrival date obtained from the inventory data using the product and lot number as keys), 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 the order data including the order number, order line number, product, number of orders, lot number, shipping date, delivery destination, delivery service, freight, storage fee, and gross profit including logistics-related costs is registered in the data table 106e.

[0056] (3-2. Sample data) 4 to 11 are diagrams showing sample data for explaining a specific example of the processing performed by the control unit 102 of the order input device 100 according to this embodiment. A specific example of the processing performed by the control unit 102 of the order input device 100 according to this embodiment will be described with reference to FIGS. 4 to 11. In the following explanation, all monetary amounts are expressed in units of "yen," and the unit of "yen" will be omitted.

[0057] (Prerequisite data) 4 shows an example of data in the shipping master 106a. The shipping master 106a includes items such as delivery code, delivery area, and shipping fee. In the example shown in the figure, the first line has the delivery code "HA001: regular delivery," delivery area "Kanto area," and shipping fee "800," the second line has the delivery code "HA001: regular delivery," delivery area "Okinawa area," and shipping fee "900," and the third line has the delivery code "HA002: airmail," delivery area "Okinawa area," and shipping fee "2500."

[0058] Since the freight master 106a is not used for actual freight payments (it is used for income / expense simulation), it does not include detailed information such as weight, departure point, arrival point, and unloading fees, emphasizing maintainability. Temperature ranges are managed by separating delivery codes. By storing freight master data for each physical distance to the delivery destination and each delivery method, it is possible to accurately calculate transportation costs for each transaction.

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

[0060] 6 is a diagram showing an example of data in the product master 106c. The product master 106c has fields for product code and temperature range. In the example shown in the figure, the product code is "12345 Purchased Product A" and the temperature range is "C001 Room Temperature."

[0061] 7 is a diagram showing an example of data in the storage fee unit price master 106d. The storage fee unit price master 106d includes items such as warehouse code, temperature range, and daily unit price. In the example shown in the figure, the first line has the warehouse code "SO001 Kyobashi Warehouse," the temperature range "C001 Room Temperature," and the daily unit price "10," the second line has the warehouse code "SO001 Kyobashi Warehouse," the temperature range "C002 Refrigerated," and the daily unit price "15," and the third line has the warehouse code "SO001 Kyobashi Warehouse," the temperature range "C003 Frozen," and the daily unit price "20."

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

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

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

[0065] (S5: Order entry processing) 10 and 11, a specific example of order input processing will be described. For example, when an operator operates an order input screen (see FIG. 10) displayed on the monitor 114 and a warehouse, product, order quantity, lot number, shipping date, delivery destination, and delivery service are specified at the time of order entry, the order input unit 102c acquires a delivery destination area from the delivery destination master 106b using the delivery service and the acquired delivery destination area as keys, acquires a freight charge from the freight charge master 106a using the temperature range and warehouse acquired from the product master 106c as keys, and acquires a storage fee unit price matrix using the product as a key. The storage fee is obtained by multiplying the daily unit price obtained from the data table 106d by (the shipping date - the arrival date obtained from the inventory data using the product and lot number as keys), and based on the obtained shipping and storage fees, the gross profit (= sales amount - cost amount - shipping - storage fees) including logistics-related costs (= shipping + storage fees) is calculated, and the order data including the order number, order line number, product, order quantity, lot number, shipping date, delivery destination, delivery service, shipping, storage fees, and gross profit including logistics-related costs is registered in the data table 106e.

[0066] Figure 10 is a diagram showing an example of an order entry screen. The order entry screen has a header section, a detail section, and a footer section. In the header section, an operator, for example, specifies (inputs) the order number, business establishment, order date, shipping date, customer, person in charge, warehouse, etc. The detail section has the following items for each line number: product, order quantity, shipping fee, sales price, sales amount, sales consumption tax, delivery destination, storage fee, consumption tax classification, tax excluded, cost amount, gross profit, lot number, delivery method, regular delivery, and logistics cost.

[0067] The product, order quantity, sales price, sales amount, sales consumption tax, delivery destination, consumption tax category, tax exclusive, cost amount, lot number, and delivery service are specified, for example, by the operator. When an execute button (not shown) is pressed, the order input unit 102c acquires the delivery destination area from the delivery destination master 106b using the delivery destination as a key, acquires the shipping fee from the shipping fee master 106a using the delivery service and the acquired delivery destination area as keys, acquires the storage fee from the storage fee unit price master 106d using the temperature range and warehouse acquired from the product master 106c as keys, as the daily unit price x (shipping date - arrival date acquired from inventory data using the product and lot number as keys), and calculates the logistics cost (= shipping fee + storage fee) and gross profit including the logistics cost (sales amount - cost amount - logistics cost) based on the acquired shipping fee and storage fee, and displays the shipping fee, storage fee, logistics cost, and gross profit.

[0068] In the footer section, the order input section 102c displays the total amount for the details (total amount per order number), as well as the cost amount, gross profit, logistics cost (= total freight and storage fee for the details), and gross profit including logistics cost (gross profit in the footer section - logistics cost in the footer section).

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

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

[0071] Furthermore, for line number "1" in the detail section, the following are specified: product "12345 Purchased Product A," order quantity "10 units," unit sales price "1,000," sales amount "10,000," sales consumption tax "200," delivery destination "N001 Chiba Co., Ltd.", consumption tax category "tax excluded," cost amount "8,000," lot number "lot1234," and delivery method "HA001 Regular Delivery." When the execute button (not shown) is pressed, the order input unit 102c retrieves the delivery destination area "Kanto Area" from the delivery destination master 106b using the delivery destination "N001 Chiba Co., Ltd." as a key, and retrieves the shipping fee "800" from the shipping fee master 106a using the shipping method "HA001 Regular Delivery" and the retrieved delivery destination area "Kanto Area" as keys.

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

[0073] The same method is used for line numbers "2" and "3" in the detail section. In the example shown in the figure, for example, for line number "3" with delivery destination "N002 Okinawa" and delivery method "HA002 Airmail", it is clear at the time of order placement that the gross profit is in the red "-2,030", so price negotiations can be carried out.

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

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

[0076] Although it may appear that a profit is being made based on the gross profit of the product alone, it is possible to understand how much profit is being made when shipping and storage fees are included at the time of receiving an order. If the profit including logistics costs is not visible at the time of receiving an order, there are cases where discounts are given without considering profit due to the long retention period, which ends up squeezing profits. By being able to confirm the profit including logistics costs at the time of receiving an order, it becomes possible to rationally decide on discounts for products and select delivery methods when negotiating future transactions.

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

[0078] FIG. 11(D) shows an example of an output of an inquiry about order performance, in which the delivery destination "N002 Okinawa Co., Ltd." is specified.

[0079] By checking the order results by delivery destination from the order results inquiry, you can find abnormal gross profit values ​​from the order results to the same delivery destination and use them as an opportunity to investigate the cause and make improvements. In this example, it is assumed that the gross profit of the order results in the second line has worsened because they were delivered by air freight, This can be used to negotiate a higher unit price the next time you use air freight, or to negotiate not to use air freight at all.

[0080] As described above, according to this embodiment, there is provided an order input unit 102c which includes a first master in which delivery destinations and delivery destination areas are registered in association with each other, a second master in which delivery services, delivery destination areas, and shipping charges are registered in association with each other, a third master in which warehouses and daily storage charges are registered in association with each other for each product, and which, when an order is placed, specifies the warehouse, product, order quantity, lot number, shipping date, delivery destination, and delivery service, obtains the delivery destination area from the first master using the delivery destination as a key, obtains the shipping charge from the second master using the delivery service and the obtained delivery destination area as keys, obtains the storage charge by multiplying the daily unit price obtained from the third master using the warehouse and product as keys by (shipping date - arrival date obtained from inventory data using the product and lot number as keys), and calculates gross profit including logistics costs based on the obtained shipping charge and storage charge. It is possible to confirm profits including logistics-related costs when placing an order.

[0081] [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.

[0082] 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.

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

[0084] 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.

[0085] 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.

[0086] 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.

[0087] Furthermore, with regard to the order input device 100, the components shown in the drawings are functional concepts, and do not necessarily have to be physically configured as shown in the drawings.

[0088] For example, all or any part of the processing functions of the order input device 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 order input device 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. The computer program is executed by being loaded into RAM, and works with the CPU to form the control unit.

[0089] This computer program may also be stored in an application program server connected to the order input device 100 via any network, and all or part of it may be downloaded as needed.

[0090] 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.

[0091] 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.

[0092] 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.

[0093] The order input device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as an information processing device connected to any peripheral device. The order input device 100 may also be implemented by installing software (including programs, data, etc.) that causes the device to perform the processes described in this embodiment.

[0094] 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]

[0095] 100 Order entry device 102 Control section 102a Master Maintenance Department 102b Inventory Control Department 102c Order entry section 102d Order History Inquiry Department 102e Screen display control unit 104 Communication interface unit 106 Storage section 106a Freight Master 106b Delivery destination master 106c Product Master 106d Storage Fee Unit Price Master 106e Data Table 106f Work Table 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network

Claims

[Claim 1] An order input device having a control unit, The control unit a first master in which delivery destinations and delivery destination areas are registered in association with each other; a second master in which delivery services, delivery destination areas, and shipping fees are registered in association with each other; a third master in which a warehouse and a storage fee per day are associated and registered for each product; Inventory data including warehouse, item, lot number, and receipt date; It is configured to be accessible to When an order is placed, when a warehouse, product, order quantity, lot number, shipping date, delivery destination, and delivery service are specified, an order input means is provided which acquires a delivery destination area from the first master using the delivery destination as a key, acquires a shipping fee from the second master using the delivery service and the acquired delivery destination area as keys, acquires a storage fee by multiplying the daily storage fee acquired from the third master using the warehouse and product as keys by (the shipping date - the arrival date acquired from the inventory data using the product and lot number as keys), and calculates gross profit including logistics costs based on the acquired shipping fee and storage fee; The third master includes a product master in which products and temperature ranges when stored in a warehouse are registered in association with each other, and a storage fee unit price master in which warehouses, temperature ranges when stored in the warehouse, and storage fees per day are registered in association with each other, The order input device is characterized in that the order input means obtains the temperature zone from the product master using the product as a key, and obtains the storage fee per day from the storage fee unit price master using the warehouse and the obtained temperature zone as keys.

Images