JP2000090152A - Price calculating method and recording medium recorded with program thereof - Google Patents

Abstract

PROBLEM TO BE SOLVED: To eliminate the need to register initial data and to decrease the operation man-hours at the time of price calculation when a price calculating process for an article wherein the price is determined by the volume or weight is performed by using a computer. SOLUTION: When the price is to be calculated, a screen (1a, 1b) prompting the input of shape and size of the object article is displayed on a display device 1 (by an input/output operation process part 3a) and on the basis of the input values, a calculation expression for volume by shapes of articles is selected (by a calculation process part 3b) (from a volume calculation function table 4c), and the input size value is applied to the calculation expression to calculate the volume of the article. Then this volume is multiplied by a price (unit price) per volume for each shape to obtain the total price.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a technique for calculating prices of goods and the like using a computer, and in particular, to efficiently calculate prices of articles such as wood and metal whose volume and weight are factors in price determination. The present invention relates to a price calculation method suitable for performing the method and a recording medium on which the program is recorded.

[0002]

2. Description of the Related Art As a method of determining a price at the time of selling a general product, a method of obtaining a quantity by multiplying a quantity such as a quantity or a case by a price per unit (unit price), or a method of determining a weight such as a gram or a ton. Multiplied by the amount per unit of weight (unit price), or by multiplying the volume or area such as cubic meters or square meters by the amount per unit volume or area (unit price).

[0003] In particular, when obtaining the weight and volume, there is a method of actually measuring the weight and volume of the product in question. However, when the article such as wood and metal is bulky and measurement is difficult, There is also a method of obtaining the weight or volume per piece and then multiplying by the quantity.

Conventionally, when calculating the price of an article whose volume or weight is a factor in determining a price by computer processing, (a) the total weight and the total volume of the article to be sold are collectively measured and measured. Technology that calculates the value by multiplying the unit price,
(B) Measure the weight and volume of the product to be sold by itself,
A technology that calculates the sales weight or sales volume by multiplying the actual measurement value by the sales quantity and then multiplies by the unit price, or
(C) A unique product code is assigned to each product, and the weight and volume per product of the product corresponding to this product code are registered in a ledger in advance, and sold to the registered values (unit weight, unit volume). Multiply the quantity to calculate the sales weight and sales volume,
A technique of multiplying this by a unit price is used.

However, in the techniques (a) and (b),
It is necessary to actually measure or calculate the weight or volume in advance, and a great deal of labor is required before inputting.
In addition, an erroneous input due to a calculation error is induced. (C)
In the technology of, a unique product code is assigned to each product, so for products such as wood and metal, a unique product code is required for each combination of material, shape, and dimensions, and the number of product codes is enormous . A great deal of time and effort is required to initially register and maintain this vast number of product codes.

[0006] Further, for articles that are easy to cut, such as metal and wood, the combinations of dimensions are nearly infinite, and combinations of materials, shapes, and dimensions are often not used repeatedly. As the operation of (1), there is a waste that one product code is allocated to input one slip.

[0007]

The problem to be solved is that, in the prior art, when the price calculation processing of an article whose price is determined by its volume or weight is performed by using a computer, it takes a lot of time to register the initial data. And the need for man-hours for price calculation. An object of the present invention is to solve these problems of the prior art, and record a price calculation method and a program for enabling a computer system to efficiently calculate the price of an article whose price is determined by volume or weight. It is to provide a recording medium.

[0008]

In order to achieve the above object, the price calculation method of the present invention displays a screen prompting the user to input the shape and dimensions of a target article at the start of price calculation.
Based on the input value, a formula for calculating the volume of each shape of the article registered in advance is selected, and the input dimension value is substituted into this formula to calculate the volume of the article. The total price is calculated by multiplying the price per unit volume (unit price) for each shape.

Further, the specific gravity of each material of the article is registered in advance, a screen for inputting the type of the material is displayed, the specific gravity of the input material is specified, and the calculated volume is multiplied. Then, the weight of the article is obtained and multiplied by the price (unit price) per unit weight of each material to calculate the total price.

[0010]

Embodiments of the present invention will be described below in detail with reference to the drawings. FIG. 1 is a flowchart showing an embodiment of a price calculation method according to the present invention. FIG. 2 is a block diagram showing an embodiment of a configuration according to the present invention of a computer system for executing the price calculation method according to the present invention. is there. FIG.
Is specifically for calculating the price of an item whose price is specified by volume.

In FIG. 2, reference numeral 1 denotes a CRT (Cathode Ray).
Tube, etc., 2 is an input device such as a keyboard and a mouse, and 3 is a CPU (Central Processing Unit).
int), an information processing apparatus having a main memory, etc., for performing computer processing according to a storage program method.
(Hard Disk Drive) etc., 5 is F
D (Flexible Disk) and CD-ROM (Compact Disk-Re
ad Only Memory) and 6 is a recording medium 5
This is a driving device for reading data from the device.

A program describing the procedure of the price calculation method of the present invention and data used for the program are recorded on the recording medium 5. The information processing device 3 transmits the program and data to the external device via the drive device 6. By reading the data into the storage device 4 and the main memory, each function of the input / output operation processing unit 3a and the calculation processing unit 3b, etc., and a table used in each processing unit are configured.

In this embodiment, the display device 1 is stored in the external storage device 4.
Display information 4a of a shape input screen having an input field of the shape of the article displayed in the table, and display information 4b of a dimension input screen having an input field of each dimension used for calculating the volume of the article in each shape
And a volume calculation function table 4c in which a volume calculation formula using each dimension in each shape of the article is defined.

In such a configuration, the information processing device 3
When the calculation of the price of the article is started, the input / output operation processing unit 3a reads the display information 4a of the shape input screen from the external storage device 4, and displays the shape input screen 1a on the display device 1. Then, when the operator inputs the shape of the product into the input field of the shape input screen 1a via the input device 2, the input / output operation processing unit 3a outputs the volume calculation function table 4 corresponding to the shape.
The calculation formula of c and the display information 4b of the dimension input screen corresponding to this shape are read from the external storage device 4, the calculation formula is stored in the main memory, and the dimension input screen 1b based on the display information 4b is displayed on the display device. 1 is displayed.

When the operator inputs each dimension in the input field of the dimension input screen 1b via the input device 2, the information processing apparatus 3 causes the calculation processing unit 3b to input each input into the calculation formula held in the main memory. Calculate the volume of the article by substituting the dimension values. Then, the calculated volume is multiplied by the unit price input by the operator from the input device 2 to calculate the total price of the article. In this way, the computer system of the present example calculates the price of an article specified by its shape and volume.

FIG. 3 is an explanatory diagram showing an example of the configuration of an input screen displayed on the display device in FIG. 2, and FIG.
FIG. 4 is an explanatory diagram showing a configuration example of a table in which dimension information used for displaying an input screen in FIG.

The dimension ledger 40 in FIG. 4 defines the shape of the article and the meaning (location) of the dimension required for calculating the volume, and is initially registered in the external storage device 4 in FIG. 2 in advance. In the input screen 30 of FIG. 3, the items of the calculation section 31, the meaning 32a of the dimension A to the meaning 32e of the dimension E, the input number 33, the number of bundles 34, and the case 35 on the first line are the headings of the input items. .

In this header row, the meaning of the dimension A 32
For each part of the meaning 32e of a to E, the length is automatically read out from the dimension ledger 40 shown in FIG. 4 corresponding to the calculation section 31 input by the operator, for example, "length (m)", "width ( c
m) ”,“ thickness (cm) ”, and the meaning (location and unit) of the dimension are displayed.

For example, the second line of the input screen 30 is an input area for each data item, and the operator assigns a code (see FIG. 4) assigned to the input area corresponding to the calculation section 31 for each type of shape. "3", "2", "I",
When "M", "G", "X", etc.) are input, the display of the portion of the meaning 32a of the dimension A to the meaning 32e of the dimension E in the first line changes to the content corresponding to the code.

That is, the input screen 30 before the operator inputs to the calculation section 31 corresponds to the shape input screen 1a in FIG. 2, and the input screen 30 after the operator inputs to the calculation section 31 is the dimension in FIG. Corresponds to the input screen 1b. In accordance with the displayed contents, the operator inputs the respective dimension values into the respective input areas of the meaning 32a of the dimension A to the meaning 32e of the dimension E.

When the operator enters the calculation section 31 with the cursor positioned at the heading of the calculation section 31 and clicks on it, the calculation section ("3", "3") is referred to with reference to the dimension ledger 40 of FIG. , "X") and shapes ("cube", "plane", ..., "2x4 material (so-called two-by-four)") are displayed. This facilitates input to the calculation section 31 by an operator who is not used to the operation.

Each of the number of pieces 33, the number of bundles 34, and the case 35 is a case indicating the number of pieces per bundle, the number of bundles per case, and the number of packages to be traded. Then, input each numerical value into each input area.

The volume 3 on the third line of the operation screen 30
6, the quantity 37 and the size 38 are heading items for explaining values calculated based on the input data or values referred to from the ledger, and the respective values are displayed on the next fourth line. After the value displayed on the fourth line is displayed, it can be corrected and input by the operator.

FIG. 5 is an explanatory diagram showing an example of the configuration of the volume calculation function table in FIG. Volume calculation function table 50 of this example
Is defined by the shape of the article, that is, the formula for calculating the volume for each calculation section shown in FIG. 4, and is initially registered in the external storage device 4 in FIG. 2 in advance.

For example, the volume calculation formula corresponding to calculation section “3” is {dimension A (length (m))} × {dimension B (width (c
m)) / 100} × {Dimension C (thickness (cm)) / 100}
X {number of entries (rounded to five decimal places)} x {number of bundles} x {case}.

In the volume calculation formula corresponding to the calculation category "X", conversion from "feet" and "inch" to "millimeter" and "measurement conversion" is performed.
This “conversion” is for “2 × 4 material” whose dimensions are in inches and feet, as shown by the calculation section “X” in the dimension ledger 40 of FIG. Performed based on the table.

FIG. 6 is an explanatory diagram showing an example of the configuration of a conversion table used for unit conversion of input dimensions in the calculation processing section in FIG. The conversion tables 61 to 63 of this example are 2 × 4
A table for converting the input dimensions of wood into units, that is, converting feet and inches to millimeters (mm),
The conversion tables 61 to 63 are also initially registered in the external storage device 4 of FIG. 2 in advance. Hereinafter, a processing operation of the price calculation method of the present invention by the computer system in FIG. 2 using FIGS. 3 to 6 will be described with reference to FIG.

At the start, the input screen 3 shown in FIG.
0 is displayed on the display device 1 of FIG. In this input screen 30, when a calculation section representing a shape is input from the operator via the input device 2 of FIG. 2 (step 10).
1) Check whether the input calculation section is registered in the dimension ledger 40 shown in FIG. 4 (step 10).
2).

If not registered, the user is again prompted to enter a calculation section. If registered, the meaning of each required dimension corresponding to the calculation section, for example, "length (m)",
The “width (cm)” and the “thickness (cm)” are displayed above the dimensions of the input screen 30 (step 103). The operator
On the input screen 30, when the values (A to E are metric), the number of pieces, the number of bundles, and the case of each dimension are input via the input device 2 (step 104), the calculation processing unit 3b of FIG. The volume is calculated according to the function registered in the volume calculation function table 50 shown in FIG. 5 (step 107).

However, only when the calculation category = X, that is, when the shape is “2 × 4 material” (step 105), the input dimension values are converted according to the conversion tables 61 to 63 shown in FIG. Is performed (step 106), the volume is calculated (step 107), and the result is displayed (step 108). The volume is multiplied by the unit price input by the operator (step 109) to calculate and display the price (step 110).

As described above, according to the price calculation method of the present embodiment, at the start of price calculation, an input screen is displayed to allow the operator to input the shape and dimensions of the wood, and to register the wood in advance based on the input values. The volume of the wood is automatically calculated by selecting the calculation formula of the volume for each shape of the put wood and substituting the input dimension value into this calculation formula, so the volume of the wood is actually measured, Alternatively, it is not necessary to calculate and obtain in advance, so that a large amount of labor until input is not required, and erroneous input due to a calculation error can be avoided.

Further, it is not necessary to provide a unique product code for each combination of shapes and dimensions of each piece of wood, so that the number of product (wood) codes can be reduced, and initial registration and maintenance of the product code become easy. Therefore, the time and effort for that can be reduced.

Next, another embodiment of the price calculation method by the computer system of FIG. 2 will be described in detail with reference to FIGS. FIG. 7 is a flowchart showing another embodiment of the price calculation method of the present invention. FIG. 8 is an explanatory diagram showing an example of the configuration of an input screen used in the price calculation method.
Is an explanatory diagram showing a configuration example of a shape ledger used in the price calculation method, FIG. 10 is an explanatory diagram showing a configuration example of a material ledger used in the price calculation method, and FIG. 11 is a coefficient ledger used in the price calculation method. FIG. 3 is an explanatory diagram showing an example of the configuration.

In this example, the price calculation method based on weight in the computer system shown in FIG. 2 is described by taking a metal part as an example. Of the data items input on the input screen 80 in the format shown in FIG. Input items are
“Material code”, “shape code”, “size name”, and “quantity”, and “coefficient” and “unit price” can be input as needed.

The shape ledger 90 in FIG. 9 defines a “shape code”, a “shape name”, and a “volume calculation formula” corresponding to each shape, and is initially registered in the external storage device 4 in FIG. 2 in advance. You. For example, if the shape code is “P”, “4”,
The metal parts of “F” have shape names of “plate”, “square bar”, and “rectangular bar”, respectively, and the volume calculation formula is “coefficient 1 * coefficient 2 * coefficient 3 * 0.001”. Commonly applied.

The material ledger 100 in FIG. 10 defines "material code", "material name", "material specific gravity", "weight sales unit price", and "weight purchase unit price".
The material ledger 100 created for each material is also initially registered in the external storage device 4 in advance. The “weight sales unit price” is a standard sales unit price determined by the company, and the “weight purchase unit price” is a standard purchase unit price agreed with the supplier.

The coefficient ledger 110 in FIG. 11 defines “shape code”, “size name”, and “coefficients 1 to 4” corresponding to the combination, and is stored in the external storage device 4 in FIG. Initial registration. In addition, arbitrary numerical values are applied as “coefficients 1 to 4”.

The input screen shown in FIG.
A price calculation method according to the present invention using the ledgers of FIGS. 9 to 11 will be described with reference to FIG. This example is a price calculation method for a metal part whose price is specified by weight. When an operator inputs a material code via the input device 2 of FIG. 2 on the input screen 80 of FIG. 8 (step 701). 2), the input / output operation processing unit 3a checks whether this material code is registered in the material ledger 100 shown in FIG. 10 (step 702).

If registered, the material name, specific gravity,
The unit price is displayed and set on each corresponding input section of the input screen 80 (step 703). If not registered,
The operator is inquired on the screen or the like as to whether or not the material code is newly registered in the material ledger (step 704). If registration is required, an input screen for registering the material ledger is displayed and registration processing is performed (step 705). If registration is not required, the process returns to step 701 and the material code is again displayed on the input screen 80. Prompt for input.

After the material name, specific gravity, and unit price are displayed in step 703, when an operator inputs a shape code on the input screen 80 (step 706), the input shape code is changed to the shape ledger shown in FIG. A check is made to see if the data has been registered in step 90 (step 707). If registered, the shape name corresponding to the input shape code is displayed and set on the input screen (step 708). If the shape code has not been registered, the input user is inquired as to whether or not the shape code is newly registered in the shape ledger (step 70).
9). If registration is required, an input screen for registering a shape ledger is displayed and registration processing is performed (step 710). If registration is not required, the process returns to step 706, and the input screen 80 is again displayed.
Prompts you to enter the shape code.

After the material name, specific gravity, and unit price are displayed on the input screen 80 at step 708, when the operator inputs a size name on the input screen 80 (step 711), the size name is shown in FIG. It is checked whether or not it is registered in the coefficient ledger 110 (step 712). If registered, "coefficient 1 to coefficient 4" corresponding to the input size name is read from the coefficient ledger 110, and displayed and set in the coefficient input portion of the input screen 80 (step 713).

If the operator needs to correct the dimensions (coefficients 1 to 4), specific gravity, unit price, etc. set and displayed in the processing up to this point, this is displayed on the input screen 80 here. Each data item is corrected and input (at this time, the coefficients up to the "number of coefficients" of the shape ledger 90 in FIG. 9 can be input) and the quantity is input (step 71).
4).

Then, in step 715, a volume is calculated by the volume calculation formula defined in the shape ledger 90 shown in FIG. Is multiplied by the specific gravity to obtain the weight per unit, the input quantity is multiplied to obtain the transaction weight (total weight), the weight is multiplied by the unit price to obtain the price, and the calculation result is displayed.

As described above, in the price calculation method of this embodiment, the weight is obtained by further multiplying the obtained volume by the specific gravity.
Even for articles whose prices are determined by their weight, such as metal parts, when the price is processed and managed by a computer, the volume of the metal parts is actually measured,
Alternatively, it is not necessary to calculate and obtain in advance, so a great deal of labor is not required until input, erroneous input due to calculation errors can be avoided, and a unique product code is provided for each combination of shapes and dimensions of each metal part. This eliminates the need and reduces the number of product (metal part) codes, thereby reducing the time and effort required for initial registration and maintenance of product codes.

As described above with reference to FIGS. 1 to 11, in the price calculation method of the present embodiment, the volume required for calculating the price of wood or metal parts is automatically calculated. Is previously prepared for each shape as a model. Then, by substituting the actual size of the article for price calculation input by the operator into the formula, the volume is automatically calculated. By adopting such a processing mode, for example, the product to be handled can be uniquely identified based on a combination of the material and shape of the product to be handled and the dimension value of each part, and the management by the product ledger as in the related art is not required. .

Further, the operator only needs to sequentially designate each component in accordance with the input screen, and erroneous data due to an input error or a calculation error is extremely reduced. In addition, the price calculation method of this example can be commonly used as a calculation module in various processes, thereby minimizing the additional man-hours of the system function accompanying the increase in the product shape, and further reducing the sales data. For evening and inventory data, record the value of each component, and calculate the module (the price calculation method in this example)
Can be used in common from sales input processing, inventory evaluation processing, and the like.

The present invention is not limited to the embodiment described with reference to FIGS. 1 to 11, and can be variously modified without departing from the gist thereof. For example, in this example, a program for calculating a price determined by the volume of timber,
And a program for calculating the price determined by the weight of the metal parts are both recorded on a recording medium such as a CD-RM with necessary ledger data, and the contents of the recording medium are stored in the information processing device 3 of the computer system. Although each function is realized by reading and executing the program, the program may be downloaded to the information processing device 3 via a network.

In the examples shown in FIGS. 7 to 11, the unit price is input by reading the value registered in advance in the material register 100 shown in FIG. 10, but in FIGS. 1, 3 to 6, FIG. As in the example shown, the operator may input a unit price via the input device 2. Conversely, in the example shown in FIGS. 1, 3 to 6, the dimension ledger 40 shown in FIG.
May be prepared in advance for each unit price so that the unit price can be automatically input.

[0049]

According to the present invention, when a price calculation process for an article whose price is determined by its volume or weight is performed by using a computer, a large amount of time and labor required for registering the initial data and the time required for the price calculation, which have been conventionally required. No need for man-hours,
In addition, erroneous data due to input mistakes and calculation mistakes is extremely reduced, and since it can be used in common as a calculation module, the number of man-hours for adding system functions due to the increase in product shape can be minimized. It is possible to efficiently use the computer in the price calculation processing of the article whose price is determined.

[Brief description of the drawings]

FIG. 1 is a flowchart showing one embodiment of a price calculation method according to the present invention.

FIG. 2 is a block diagram showing one embodiment of a configuration according to the present invention of a computer system that executes a price calculation method of the present invention.

FIG. 3 is an explanatory diagram showing a configuration example of an input screen displayed on the display device in FIG. 2;

FIG. 4 is an explanatory diagram showing a configuration example of a table in which dimension information used for displaying an input screen in FIG. 3 is registered in association with each other.

FIG. 5 is an explanatory diagram showing a configuration example of a volume calculation formula in FIG. 2;

FIG. 6 is an explanatory diagram showing a configuration example of a conversion table used for unit conversion of input dimensions in a calculation processing unit in FIG. 2;

FIG. 7 is a flowchart showing another embodiment of the price calculation method of the present invention.

8 is an explanatory diagram showing a configuration example of an input screen used in the price calculation method in FIG.

9 is an explanatory diagram showing a configuration example of a shape ledger used in the price calculation method in FIG. 7;

FIG. 10 is an explanatory diagram showing a configuration example of a material ledger used in the price calculation method in FIG. 7;

11 is an explanatory diagram showing a configuration example of a coefficient ledger used in the price calculation method in FIG. 7;

[Explanation of symbols]

1: display device, 1a: shape input screen, 1b: dimension input screen, 2: input device, 3: information processing device, 3a: input / output operation processing unit, 3b: calculation processing unit, 4: external storage device, 4
a: display information on the shape input screen, 4b: display information on the dimension input screen, 4c: volume calculation function table, 5: recording medium, 6: drive device, 30: input screen, 31: calculation section, 32a to 3a
2e: Meaning of dimensions A to E, 33: Quantity, 34: Number of bundles, 35: Case, 36: Volume, 37: Quantity, 38: Size, 40: Dimension ledger, 50: Volume calculation function table, 61 to 61
63: conversion table, 80: input screen, 90: shape ledger, 10
0: material ledger, 110: coefficient ledger.

Claims (4)

[Claims] 1. A central processing unit using a storage device, an input device, and a display device connected to the central processing unit,
A price calculation method for calculating a price of an article specified by a shape and a volume, wherein a shape input screen having an input field for the shape of the article displayed on the display device, and a calculation of the volume of the article in each shape Each display information of the dimension input screen having an input column of each dimension used for, and a formula for calculating the volume using each dimension in each shape of the article are stored in the storage device in advance, and the central processing unit A first step of reading display information of the shape input screen from the storage device and displaying the shape input screen on the display device at the time of starting the calculation of the price of the article; and the shape input screen via the input device. A second procedure for reading the above-mentioned calculation formula corresponding to the shape input to the input field of the shape input screen from the storage device, and display information of the dimension input screen corresponding to the shape input to the input field of the shape input screen A third procedure of reading from the storage device and displaying the dimension input screen on the display device, and calculating the volume of the article at each dimension value input to the input field of the dimension input screen via the input device. A fourth step of calculating based on the calculation formula read in the second step, and multiplying the volume calculated in the fourth step by the price (unit price) per unit volume of the article to obtain the price of the article. And a fifth step of calculating. 2. A central processing unit using a storage device, an input device, and a display device connected to the central processing device,
A price calculation method for calculating a price of an article specified by a shape and a weight, wherein a material input screen having an input field for a material of the article displayed on the display device, a shape having an input field for a shape of the article Input screen, each display information of the dimension input screen having an input column of each dimension used for calculating the volume of the article in each shape, the specific gravity of each material and the volume using each dimension in each shape of the article Is stored in the storage device in advance, and the central processing unit reads the display information of the material input screen from the storage device at the time of starting the calculation of the price of the article, and reads the material input screen to the display device. A first procedure for displaying; a second procedure for reading, from the storage device, a specific gravity of the material input to the input field of the material input screen via the input device; A third step of reading the shape input screen from the storage device and displaying the shape input screen on the display device; and calculating the calculation formula corresponding to the shape input to the input field of the shape input screen via the input device from the storage device. 4th to read
A fifth step of reading display information of the dimension input screen corresponding to the shape input in the input field of the shape input screen from the storage device and displaying the dimension input screen on the display device; A sixth procedure of calculating the volume of the article at each dimension value input in the input field of the dimension input screen via the input device based on the calculation formula read in the fourth procedure; and A seventh procedure of calculating the weight of the article by multiplying the volume calculated in the procedure by the specific gravity read in the second procedure; and a weight of the article calculated in the seventh procedure, An eighth procedure of multiplying a price per unit weight (unit price) to calculate the price of the article. 3. The price calculating method according to claim 2, wherein a price (unit price) per unit weight of the material of the article is stored in advance in the storage device together with a specific gravity of the material, and in the second procedure, Reading the unit price together with the specific gravity of the material, and calculating the price of the article by multiplying the weight of the article calculated in the seventh procedure by the unit price read in the second procedure in the eighth procedure. Characteristic price calculation method. 4. A recording medium for recording a computer-readable program and data, the program and data for causing a computer to execute each procedure in the price calculation method according to claim 1. A recording medium on which is recorded.