JP2022134653A - Unit price calculation device, unit price calculation method, and unit price calculation program - Google Patents

Abstract

To provide a unit price calculation device, a unit price calculation method and a unit price calculation program capable of realizing unit price calculation corresponding to detailed requirements related to agreement of transaction unit price unique to the steel industry.SOLUTION: A sales management device including a unit price calculation device refers to a base unit price master based on information on a client, a type of product to be traded, and whether the product is a standard product or a processed product, to acquire a base unit price to be applied; refers to an extra unit price master based on numerical values related to the client, the product to be traded and the processing details of the product, to acquire an extra unit price to be applied; and calculates a unit price of product transaction based on the obtained base unit price and extra unit price.SELECTED DRAWING: Figure 1

Description

The present invention relates to a unit price calculation device, a unit price calculation method, and a unit price calculation program.

Regarding the commercial distribution of the steel industry, it is common to order manufacturers, primary wholesalers, secondary wholesalers/processers/direct sales, and consumers in order from the upstream.

In addition, in Patent Document 1, when designing a design object in the field of architecture and civil engineering, the designer inputs basic data that can be known at the pre-design stage, so that the construction cost can be calculated in advance as a reference. It describes a construction cost calculation support method in architectural and civil engineering design that enables

JP-A-9-305644

Here, in the steel industry, the transaction unit price of products is periodically changed due to changes in raw material supply, economic conditions, and the like. In addition, in the steel industry, it is necessary for distributors to determine the transaction unit price (specifically, the In many cases, detailed requirements are set for the arrangement of sales unit price or purchasing unit price.

The present invention has been made in view of the above circumstances, and provides a unit price calculation device, a unit price calculation method, and a unit price calculation program that can realize unit price calculation corresponding to detailed requirements related to the arrangement of transaction unit prices, which are unique to the steel industry. intended to provide

In order to solve the above-described problems and achieve the object, a unit price calculation device according to the present invention is a unit price calculation device that is used by a steel distributor and includes a control unit, It is possible to access a base unit price master that manages two types of base unit prices, one for standard-sized products and one for processed products, and an extra unit price master that manages extra unit prices for each customer, product, and processing content. The control unit acquires the base unit price to be applied by referring to the base unit price master based on the information on the customer, the type of product to be traded, and whether the product is a standard product or a processed product. means, a second acquisition means for acquiring an extra unit price to be applied by referring to the extra unit price master based on numerical values relating to business partners, products to be traded, and details of processing of the product; and the acquired base unit price. and calculating means for calculating a transaction unit price of the product based on the extra unit price.

In addition, the unit price calculation method according to the present invention includes a base unit price master that manages two types of base unit prices, one for standard-sized products and one for processed products, for each supplier and for each product type, and , an extra unit price master for managing an extra unit price, and a unit price calculation method executed by an information processing apparatus having a control unit, which is used in a steel distributor and is accessible to the control unit. , a first obtaining step of obtaining a base unit price to be applied by referring to the base unit price master based on information such as the business partner, the type of product to be traded, and whether the product is a standard-size product or a processed product; a second acquisition step of acquiring an extra unit price to be applied by referring to the extra unit price master based on numerical values relating to business partners, traded products, and details of processing of the product; and the acquired base unit price and extra unit price. and a calculating step of calculating the unit price of the transaction of the product based on the above.

In addition, the unit price calculation program according to the present invention includes a base unit price master that manages two types of base unit prices for standard-size products and processed products for each customer and product type, and a base unit price master for each customer, product, and processing content. , an extra unit price master for managing an extra unit price, and a unit price calculation program for being executed by an information processing apparatus having a control unit, which is used in a steel distributor and is accessible to the control unit. A first acquisition step for acquiring a base unit price to be applied by referring to the base unit price master based on information on the customer, the type of product to be traded, and whether the product is a standard-sized product or a processed product. a second acquisition step of acquiring the extra unit price to be applied by referring to the extra unit price master based on numerical values related to the business partner, the product to be traded, and the processing details of the product; and a calculating step of calculating a transaction unit price of the product based on the extra unit price.

ADVANTAGE OF THE INVENTION This invention is effective in the ability to implement|achieve unit price calculation corresponding to the detailed requirement regarding the agreement of the transaction unit price peculiar to the steel industry.

FIG. 1 is a diagram showing an example of the configuration of the sales management device 100. As shown in FIG. FIG. 2 is a diagram showing an example of the sales-based unit price master 106a. FIG. 3 is a diagram showing an example of the sales extra unit price master 106b. FIG. 4 is a diagram showing an example of the purchase base unit price master 106c. FIG. 5 is a diagram showing an example of the purchased extra unit price master 106d. FIG. 6 is a diagram showing an example of the product master 106e. FIG. 7 is a diagram showing an example of calculation of unit sales price. FIG. 8 is a diagram showing an example of calculation of purchase unit price.

Embodiments of a unit price calculation device, a unit price calculation method, and a unit price calculation program according to the present invention will be described in detail below with reference to the drawings. It should be noted that the present invention is not limited by this embodiment.

[1. Constitution]
An example of the configuration of the sales management device 100 (including the unit price calculation device according to the present invention) according to this embodiment will be described with reference to FIG. 1 and the like. FIG. 1 is a block diagram showing an example of the configuration of the sales management device 100. As shown in FIG.

The sales management device 100 is constructed based on a commercially available desktop personal computer. Note that the sales management device 100 is not limited to those constructed based on a stationary information processing device such as a desktop personal computer, and may be a commercially available notebook personal computer, PDA (Personal Digital Assistants), smart phone or tablet personal computer. It may also be constructed based on a portable information processing device such as.

The sales management device 100 includes a control section 102 , a communication interface section 104 , a storage section 106 and an input/output interface section 108 . Each unit included in sales management apparatus 100 is communicably connected via an arbitrary communication path.

Communication interface unit 104 communicably connects sales management apparatus 100 to network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the sales management apparatus 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that the data stored in the storage unit 106 may be stored in the server 200, for example.

An input device 112 and an output device 114 (corresponding to the output section of the present invention) are connected to the input/output interface section 108 . The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that realizes a pointing device function in cooperation with a mouse. Note that, hereinafter, 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 .

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

The storage unit 106 stores a sales-based unit price master 106a, a sales extra unit price master 106b, a purchase-based unit price master 106c, a purchase extra unit price master 106d, a product master 106e, and the like.

Here, the sales-based unit price master 106a and the purchase-based unit price master 106c are conceptually included in the base unit price master of the present invention. The sales extra unit price master 106b and the purchase extra unit price master 106d are conceptually included in the extra unit price master of the present invention.

See FIGS. 2-6 for specific examples of each of the masters described above. The "base unit price" in the sales-based unit price master 106a and purchase-based unit price master 106c corresponds to the base unit price for standard-size products of the present invention. Also, the "processing base unit price" and "cutting base unit price" in the sales base unit price master 106a and the purchase base unit price master 106c correspond to the base unit price for processed products of the present invention. In addition, in the sales extra unit price master 106b and the purchase extra unit price master 106d, the conditional expression "length ≥ set value" defined by "length or more" and set value of length (eg 0, 6000) Realizes management of extra unit price by contents. The "numerical value relating to the processing details of the product" of the present invention corresponds to the length that is applied to the conditional expression and compared with the set value.

Returning to FIG. 1 , the control unit 102 is a CPU or the like that controls the sales management device 100 in an integrated manner. The control unit 102 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run.

The control unit 102 functionally and conceptually includes an order input unit 102a, a purchase input unit 102b, a first acquisition unit 102c, a second acquisition unit 102d, a calculation unit 102e, and the like.

The order entry input unit 102a inputs information on product orders from customers on a screen (not shown), and stores the entered information as order information in a predetermined storage area in the storage unit 106, for example. It is a means. The order input unit 102a operates the first acquisition unit 102c, the second acquisition unit 102d, and the calculation unit e to calculate the unit price based on the input information, and the first acquisition unit 102c, the second acquisition unit Numerical values obtained by the processing of the unit 102d and the calculation unit e may be displayed on the screen.

The purchase input unit 102b inputs information on product purchase from a supplier on a screen (not shown), and stores the input information as purchase information in a predetermined storage area in the storage unit 106, for example. Information processing means for storing. The purchase input unit 102b operates the first acquisition unit 102c, the second acquisition unit 102d, and the calculation unit e to calculate the unit price based on the input information. Numerical values obtained by the processing of the acquisition unit 102d and the calculation unit e may be displayed on the screen.

The first acquisition unit 102c corresponds to the first acquisition means of the present invention. The first acquisition unit 102c refers to the sales-based unit price master 106a or the purchase-based unit price master 106c based on the information on the supplier, the type of product to be traded, and whether the product is a standard product or a processed product. , is an information processing means for acquiring a base unit price to be applied. A specific example of the processing executed by the first acquisition unit 102c will be described in detail in "2. Specific example of processing".

The second obtaining section 102d corresponds to the second obtaining means of the present invention. The second acquisition unit 102d acquires the applicable extra unit price by referring to the sales extra unit price master 106b or the purchase extra unit price master 106d based on the numerical values related to the business partner, the product to be traded, and the details of processing of the product. It is information processing means for A specific example of the processing executed by the second acquisition unit 102d will be described in detail in "2. Specific example of processing".

The calculator 102e corresponds to the calculator of the present invention. The calculation unit 102e is information processing means for calculating the unit price of the transaction of the product based on the base unit price acquired by the first acquisition unit 102c and the extra unit price acquired by the second acquisition unit 102d. A specific example of the processing executed by the calculation unit 102e will be described in detail in "2. Specific example of processing".

[2. Specific example of processing]
Here, a specific example of processing executed by the sales management apparatus 100 will be described with reference to FIGS.

[2-1. Unit price calculation example 1 (see Fig. 7)]
For example, the Osaka head office (equivalent to an internal organization in a company that uses the sales management device 100) assigns a customer “●● steel pipe” (customer code “1116432”) to a standard product (product name “SUS304△△△ 6×50×” (product code “213406050500”), length “4000” (mm/piece)) will be described in detail assuming a case where two pieces are sold. Since the unit of sales is assumed to be "book", the unit of transaction (presentation unit) is "book". Here, it is assumed that the order input unit 102a operates the first acquisition unit 102c, the second acquisition unit 102d, and the calculation unit 102e.

First, the first acquisition unit 102c refers to the product master 106e, and obtains the product name “SUS304××××××” linked to the product name “SUS304ΔΔΔ6×50×” (product code “213406050500”). (variety code "8400101") and M single weight "2.38" (kg/m) are obtained.

Next, the first acquisition unit 102c refers to the sales-based unit price master 106a and obtains the product name “SUS304××××××” (product code “8400101”), the presentation unit “book”, and the customer “ ●● steel pipe” (customer code “1116432”) or customer “Osaka head office common (1)” (customer code “11011”) or customer “Osaka head office common (2)” (customer code “11012”) , a base unit price of "710.0" (yen/kg), a discount rate of "0.10", and a commission of "0.020" are acquired.

Next, the second acquisition unit 102d refers to the sales extra unit price master 106b, and obtains the product name "SUS304△△△6×50×" (product code "213406050500") and the customer "●● steel pipe" (customer (customer code "1116432") or customer "Osaka head office common (1)" (customer code "11011") and the conditional expression "length ≥ 0" that the length "4000" satisfies, extra unit price "12.0" (yen/kg) is acquired.

Next, the calculation unit 102e calculates the base unit price “710.0”, the extra unit price “12.0”, and the discount rate “0.10” using the calculation formula “subtotal unit price (yen/kg)=(base unit price (yen /kg) + extra unit price (yen/kg)) × (1-discount rate)” to calculate the unit price subtotal “649.8”.

Next, the calculation unit 102e calculates the unit price subtotal "649.8" and the further second discount rate value input on the screen (*not input in this description, that is, "0"). Substitute into the formula "total unit selling price (yen/kg)=unit price subtotal (yen/kg)×(1-discount rate)" to calculate the total selling price "649.8". In addition, since "9.52" (kg/piece) is obtained from the length "4000" and the M unit weight "2.38", the total sales unit price "649.8" (yen/kg) x "9. A total sales unit price of "6186.1" (yen/piece) may be calculated from "52" (kg/piece). That is, the unit of the total sales unit price may be changed from yen/kg to yen/piece.

Next, the calculation unit 102e calculates the total sales unit price of "649.8", the length of "4000", the M unit quantity of "2.38", and the number of units of "2" using the calculation formula "amount (yen) = total sales unit price (yen/kg)×length (m/piece)×M unit weight (kg/m)×number of pieces (pieces)” to calculate the amount “12,372” (rounding down decimal places).

Next, the calculation unit 102e substitutes the amount "12,372" and the commission "0.020" into the calculation formula "commission amount (yen) = amount (yen) x commission", and calculates the commission amount "247". Calculate (rounded to the nearest whole number).

Next, the calculation unit 102e calculates the amount "12,372", the commission amount "247", the separate processing fee input on the screen (*not input in this description, that is, "0"), and the number "2". is substituted into the formula "sales amount (yen) = amount (yen) - commission amount (yen) + separate processing fee (yen/piece) x number (pieces)" to calculate the sales amount "12,125". do.

[2-2. Sales unit price calculation example 2 (see Fig. 7)]
For example, the head office in Osaka (equivalent to an internal organization in a company that uses the sales management device 100) requests a customer “●● steel pipe” (customer code “1116432”) to cut a product (product name “SUS304△△△4 50×” (product code “213404050900”), length “110” (mm/piece)), and assuming a case where 10 pieces are sold, the processing for calculating the sales unit price will be described in detail. Since the unit of sales is assumed to be "book", the unit of transaction (presentation unit) is "book". Here, it is assumed that the order input unit 102a operates the first acquisition unit 102c, the second acquisition unit 102d, and the calculation unit 102e.

First, the first acquisition unit 102c refers to the product master 106e and obtains the product name “SUS304××××××” linked to the product name “SUS304ΔΔΔ4×50×” (product code “213404050900”). (variety code "8400101") and M single weight "1.77" (kg/m) are obtained.

Next, the first acquisition unit 102c refers to the sales-based unit price master 106a and obtains the product name “SUS304××××××” (product code “8400101”), the presentation unit “book”, and the customer “ ●● steel pipe” (customer code “1116432”) or customer “Osaka head office common (1)” (customer code “11011”) or customer “Osaka head office common (2)” (customer code “11012”) , the base unit price for processed goods "810.0" (yen / kg), the processing fee threshold "300.0" (mm), the discount rate "0.10", and the commission "0.020" to get

Next, the second acquisition unit 102d refers to the sales extra unit price master 106b, and obtains the product name "SUS304△△△4×50×" (product code "213404050900") and the customer "●● steel pipe" (customer Customer code "1116432") or customer "Osaka head office common (1)" (customer code "11011") and conditional expression "length ≥ 0" that length "110" satisfies Extra unit price Obtain "10.0" (yen/kg) and processing fee "50" (yen/piece).

Next, since the length "110" is less than the processing fee threshold "300.0", the calculation unit 102e determines that the base unit price is "810.0", the extra unit price is "10.0", the processing fee is "50", and the M unit weight "1.77", the length "110", the discount rate "0.10", and the additional length "3" (mm) set in advance in consideration of the yield, the calculation formula "unit price subtotal (yen/ book) = {(base unit price (yen/kg) + extra unit price (yen/kg)) x M unit weight (kg/m) x added length (m/piece) + processing fee (yen/piece)} x (1-discount rate)” to calculate the unit price subtotal “192.6”.

Next, the calculation unit 102e calculates the unit price subtotal "192.6" and the value of the further second discount rate input on the screen (*assuming that "0.05" is input in this description) as follows: Calculate the total unit sales price of "182.97" (yen/piece) by substituting into the formula "total unit selling price (yen/piece) = unit price subtotal (yen/piece) x (1 - second discount rate)" do.

Next, the calculation unit 102e substitutes the total unit sales price “182.97” and the number “10” into the calculation formula “amount (yen)=total unit sales price (yen/piece)×number (pieces)”, Calculate the amount "1,829" (truncated after the decimal point).

Next, the calculation unit 102e substitutes the amount "1,829" and the commission "0.020" into the calculation formula "commission amount (yen) = amount (yen) x commission", and calculates the commission amount "37". Calculate (rounded to the nearest whole number).

Next, the calculation unit 102e calculates the amount "1,829", the commission amount "37", the separate processing fee input on the screen (*in this explanation, assume that "200" is input), and the number "10". , Substitute into the formula "sales amount (yen) = amount (yen) - commission amount (yen) + separate processing fee (yen/unit) x number (units)", sales amount "3,792" (yen) Calculate

[2-3. Purchase unit price calculation example 1 (see Fig. 8)]
For example, the Osaka head office (equivalent to an internal organization in a company that uses the sales management device 100) selects a standard product (product name: SUS304△ Assuming that two pieces of ΔΔ6×50×” (product code “213406050500”), length “4000” (mm/piece)) are purchased, the purchase unit price calculation process will be described in detail. Since the unit of purchase is assumed to be "book", the unit of transaction (presentation unit) is "book". Here, it is assumed that the purchase input unit 102b has operated the first acquisition unit 102c, the second acquisition unit 102d, and the calculation unit 102e.

First, the first acquisition unit 102c refers to the product master 106e, and obtains the product name “SUS304××××××” linked to the product name “SUS304ΔΔΔ6×50×” (product code “213406050500”). (variety code "8400101") and M single weight "2.38" (kg/m) are obtained.

Next, the first acquisition unit 102c refers to the purchase base unit price master 106c, and obtains the product name “SUS304××××××” (product code “8400101”), the presentation unit “book”, and the purchase unit price The base unit price for standard-length products is "470.0", which is linked to the destination "△△ Kogyo" (supplier code "1114100") or the supplier "Osaka Head Office Common" (supplier code "11011"). ” (yen/kg).

Next, the second acquisition unit 102d refers to the purchase extra unit price master 106d to obtain the product name "SUS304△△△6×50×" (product code "213406050500") and the supplier "△△ Kogyo". (supplier code "1114100") or the supplier "Osaka head office common" (supplier code "11011") and the conditional expression "length ≥ 0" that the length "4000" satisfies, Acquire the extra unit price "20.0" (yen/kg).

Next, the calculation unit 102e calculates the base unit price "470.0" and the extra unit price "20.0" by calculating the formula "unit price subtotal (yen/kg) = base unit price (yen/kg) + extra unit price (yen/kg). )” to calculate the unit price subtotal “490.0”.

Next, the calculation unit 102e calculates the unit price subtotal "490.0", the length "4000", the M unit weight "2.38", and the discount rate value (*in this description, "0" is input), the calculation formula "total purchase unit price (yen/piece) = unit price subtotal (yen/kg) x length (m/piece) x M unit weight (kg/m) x (1-value rate)” to calculate the total purchase unit price of “4,664.8”.

Next, the calculation unit 102e converts the total purchase unit price "4,664.8" and the number "2" into the calculation formula "amount (yen) = total purchase unit price (yen/piece) x number (piece)". Substitute to calculate the amount "9,330" (rounded to the nearest whole number).

Next, the calculation unit 102e converts the amount “9,330” and the commission value input on the screen (*in this description, “0.020” is assumed to be input) into the calculation formula “commission amount (yen ) = amount (yen) x commission” to calculate the commission amount “187” (rounded to the nearest whole number).

Next, the calculation unit 102e calculates the amount "9,330", the commission amount "187", the value of the separate processing fee input on the screen (*not input in this description, that is, "0"), and the number " 2” into the formula “purchase amount (yen) = amount (yen) - commission amount (yen) + separate processing fee (yen/piece) x number of pieces (pieces)” to obtain the purchase amount “9, 143” is calculated.

[2-4. Purchase unit price calculation example 2 (see Fig. 8)]
For example, the Osaka head office (equivalent to an internal organization of a company that uses the sales management device 100) cuts a product (product name: SUS304△ Assuming that 10 units of ΔΔ4×50×” (product code “213404050900”), length “110” (mm/piece)) are purchased, the purchase unit price calculation process will be described in detail. Since the unit of purchase is assumed to be "book", the unit of transaction (presentation unit) is "book". Here, it is assumed that the purchase input unit 102b has operated the first acquisition unit 102c, the second acquisition unit 102d, and the calculation unit 102e.

First, the first acquisition unit 102c refers to the product master 106e and obtains the product name “SUS304××××××” linked to the product name “SUS304ΔΔΔ4×50×” (product code “213404050900”). (variety code "8400101") and M single weight "1.77" (kg/m) are acquired.

Next, the first acquisition unit 102c refers to the purchase base unit price master 106c, and obtains the product name “SUS304××××××” (product code “8400101”), the presentation unit “book”, and the purchase unit price Base unit price for processed goods "695.0" linked to the destination "XX machining" (supplier code "1113446") or the supplier "Osaka head office common" (supplier code "11011") " (yen/kg), processing fee threshold "200.0" (mm), and special BS "-30.0" (yen/kg).

Next, the second acquisition unit 102d refers to the purchase extra unit price master 106d to obtain the product name “SUS304ΔΔΔ4×50×” (product code “213404050900”) and the supplier “XX machining ” (supplier code “1113446”) or the supplier “Osaka head office common” (supplier code “11011”) and the conditional expression “length ≥ 0” that the length “110” satisfies , an extra unit price of "10.0" (yen/kg) and a processing fee of "30" (yen/piece) are obtained.

Next, since the length "110" is less than the processing charge threshold "200.0", the calculation unit 102e determines that the base unit price is "695.0", the special BS is "-30.0", the extra unit price is "10.0", The processing fee "30", the M unit weight "1.77", the length "110", and the additional length "3" (mm) set in advance considering the yield, are calculated by the formula "unit price subtotal (yen /piece) = (base unit price (yen/kg) + special BS (yen/kg) + extra unit price (yen/kg)) x M unit weight (kg/m) x added length (m/piece) + processing Subtotal of the unit price "165.0" (yen/book) is calculated by substituting it into "Rent (yen/book)". When the length is less than the processing charge threshold, the unit price subtotal is calculated without adding the special BS.

Next, the calculation unit 102e calculates the unit price subtotal “165.0” and the value of the discount rate input on the screen (*assuming that “0.05” is input in this description), using the calculation formula “total Purchase unit price (yen/piece) = unit price subtotal (yen/piece) x (1-discount rate)” to calculate the total purchase unit price “156.8”.

Next, the calculation unit 102e substitutes the total purchase unit price "156.8" and the number "10" into the calculation formula "amount (yen) = total purchase unit price (yen/piece) x number (piece)". to calculate the amount "1,568" (truncated after the decimal point).

Next, the calculation unit 102e calculates the amount "1,568" and the value of the commission input on the screen (*assuming that "0" is input in this description) by using the calculation formula "commission amount (yen) = Amount of money (yen) x commission” to calculate the commission amount of “0” (rounded to the nearest whole number).

Next, the calculation unit 102e calculates the amount "1,568", the commission amount "0", the separate processing fee input on the screen (*not input, that is, "0" in this description), and the number "10". is substituted into the formula "purchase amount (yen) = amount (yen) - commission amount (yen) + separate processing fee (yen/piece) x number (pieces)", and the purchase amount is "1,568". Calculate

[3. Summary of this embodiment]
In the iron and steel industry, the general flow of commercial flow is "manufacturer" → "primary wholesaler" → "processing shop, secondary wholesaler, direct sales" → "consumer". In addition, the price bargaining power is stronger in the upstream of the commercial flow, and the unit price of transactions is regularly changed due to changes in the supply of raw materials and economic conditions. Since it is a key industry in Japan that has existed for a long time, there are few new entrants in the upstream of the commercial flow, and there are many tied businesses that regularly do business with specific companies. In addition, with regard to price arrangements, detailed requirements are often set according to the items to be handled, delivery locations, transit points (because the items are heavy and costly to move), and relationships with business partners.

Therefore, in this embodiment, in addition to 1) realizing a unit price calculation mechanism that satisfies the main requirements of the steel industry, such as base unit price and extra unit price, 2) unit price according to processing content for companies involved in processing 3) Transactions based on weight and quantity (this is also an essential requirement in the steel industry, and it is necessary to manage multiple units in terms of number and weight). Unit information is automatically converted to calculate the unit price. We have also implemented a mechanism for Further, in this embodiment, by designing a scheme in which such detailed mechanisms are managed by a master, it is intended to realize business control within a company. Specifically, the points of this embodiment are: 1) managing the base unit price and extra unit price for each supplier on the master; 3) By automatically converting from quantity to weight, it is possible to calculate the unit price on a weight basis. That is the point.

[4. Contribution to the Sustainable Development Goals (SDGs) led by the United Nations]
Since this embodiment can contribute to improving operational efficiency and promoting appropriate management decisions of companies, it is possible to contribute to Goals 8 and 9 of the SDGs.

In addition, the present embodiment can contribute to the reduction of disposal loss and the promotion of paperless and computerization.

In addition, since this embodiment can contribute to strengthening control and governance, it is possible to contribute to Goal 16 of the SDGs.

[5. Other embodiments]
The present invention may be implemented in various different embodiments other than the embodiments described above within the scope of the technical idea described in the claims.

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

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

Also, with respect to the sales management apparatus 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions of the sales management apparatus 100, particularly the processing functions performed by the control unit, may be implemented in whole or in part by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processing described in this embodiment, and the sales management device can be used as necessary. 100 mechanically read. That is, a storage unit such as a ROM or HDD (Hard Disk Drive) stores a computer program for giving commands to the CPU in cooperation with the OS to perform various processes. This computer program is executed by being loaded into the RAM and constitutes a control section in cooperation with the CPU.

Also, this computer program may be stored in an application program server connected to sales management apparatus 100 via any network, and all or part of it can be downloaded as necessary. be.

Also, the program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" refers to memory cards, USB (Universal Serial Bus) memories, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (registered (trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Disc (registered trademark) such as Blu- shall include any "portable physical medium".

A "program" is a data processing method written in any language or writing method, regardless of the format such as source code or binary code. In addition, the "program" is not necessarily limited to a single configuration, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, the installation procedure after reading, and the like.

The various databases stored in the storage 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. It stores programs, tables, databases, files for web pages, and so on.

Sales management apparatus 100 may be configured as an information processing apparatus such as a known personal computer or workstation, or may be configured as the information processing apparatus to which any peripheral device is connected. Moreover, the sales management apparatus 100 may be realized by installing software (including programs, data, etc.) that causes the apparatus to realize the processing described in the present embodiment.

Furthermore, the specific forms of distribution and integration of devices are not limited to those shown in the figures, and all or part of them can be functionally or physically arranged in arbitrary units according to various additions or functional loads. It can be distributed and integrated. In other words, the embodiments described above may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

The present invention is particularly useful in the steel and building material industries.

100 sales management device (including unit price calculation device according to the present invention)
102 control unit
102a Order input unit
102b Order input unit
102c first acquisition unit
102d second acquisition unit
102e calculation unit 104 communication interface unit 106 storage unit
106a Sales-based unit price master
106b Sales extra unit price master
106c Purchasing base unit price master
106d Purchasing extra unit price master
106e Product master 108 Input/output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (3)

A unit price calculation device comprising a control unit and used in a steel distributor,
A base unit price master that manages two types of base unit prices, one for standard-sized products and one for processed products, for each customer and product type;
An extra unit price master that manages the extra unit price by customer, by product, and by processing content,
is accessible to
The control unit
a first acquisition means for acquiring a base unit price to be applied by referring to the base unit price master based on information on a business partner, a product type to be traded, and whether the product is a standard product or a processed product;
a second acquiring means for acquiring an applicable extra unit price by referring to the extra unit price master based on numerical values relating to business partners, products to be traded, and details of processing of the product;
a calculation means for calculating a unit price of the transaction of the product based on the acquired base unit price and extra unit price;
to provide
A unit price calculation device characterized by: A base unit price master that manages two types of base unit prices, one for standard-sized products and one for processed products, for each business partner and product type, and an extra unit price master that manages extra unit prices for each business partner, product, and processing content, A unit price calculation method executed by an information processing device having a control unit, which is used by a steel distributor and is accessible to
executed by the control unit;
a first obtaining step of obtaining a base unit price to be applied by referring to the base unit price master based on the information about the business partner, the product type to be traded, and whether the product is a standard product or a processed product;
a second obtaining step of obtaining an extra unit price to be applied by referring to the extra unit price master based on numerical values relating to business partners, products to be traded, and details of processing of the product;
a calculation step of calculating a transaction unit price of the product based on the acquired base unit price and extra unit price;
including
A unit price calculation method characterized by: A base unit price master that manages two types of base unit prices, one for standard-sized products and one for processed products, for each business partner and product type, and an extra unit price master that manages extra unit prices for each business partner, product, and processing content, A unit price calculation program to be executed by an information processing device having a control unit, which is used by a steel distributor and is accessible to
for causing the control unit to execute
a first obtaining step of obtaining a base unit price to be applied by referring to the base unit price master based on the information about the business partner, the product type to be traded, and whether the product is a standard product or a processed product;
a second obtaining step of obtaining an extra unit price to be applied by referring to the extra unit price master based on numerical values relating to business partners, products to be traded, and details of processing of the product;
a calculation step of calculating a transaction unit price of the product based on the acquired base unit price and extra unit price;
including
A unit price calculation program characterized by

Images