Sales calculation apparatus, sales calculation method, and sales calculation program

Abstract

To provide a sales calculation device, a sales calculation method, and a sales calculation program capable of appropriately pricing a commodity in consideration of an exchange difference amount generated by exchange fluctuation and costs such as a storage fee and a transportation cost of the commodity in import wholesale.SOLUTION: The control unit includes an addition unit price calculation unit that calculates an addition foreign currency unit price and an addition yen unit price to be added to a sales unit price by referring to the purchase data and the expense master when a sales contract of a purchased commodity is made, and a sales calculation unit that calculates a sales foreign currency unit price obtained by adding the addition foreign currency unit price to an input commodity foreign currency unit price, a sales unit price obtained by adding the addition yen unit price to a commodity yen unit price, a sales foreign currency amount obtained by multiplying the sales foreign currency unit price and a sales quantity, and a sales yen amount obtained by multiplying the sales yen unit price and the sales quantity.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to a sales calculation device, a sales calculation method, and a sales calculation program. [Background technology]

[0002] In the import wholesale business, when selling imported goods, it is necessary to price the goods taking into consideration the exchange rate difference that arises due to exchange rate fluctuations, as well as expenses such as storage fees and transportation costs. However, in recent years, there have been large exchange rate fluctuations, and when converting to yen after the final exchange rate has been determined, there have been cases where the initially expected gross profit has not been secured, or where the profit margin has not been secured correctly due to the omission of adding various expenses related to sales.

[0003] Patent Document 1 describes a sales forecast simulation device that has a memory unit and a control unit and predicts the price of a product at the time of delivery, in which the memory unit stores a material price master including the material code, application start date, and price at each time point, and a product master including the product's item code, material code, and material composition ratio, and the control unit includes: material code acquisition means that acquires the material code of the material that makes up the product and its composition ratio from the product master based on order data including the item code, order date, delivery date, and order amount of the product at the time of order; price acquisition means that acquires the expected price at the time of delivery from the material price master based on the acquired material code, its composition ratio, and the delivery date included in the order data; and slide calculation processing means that performs a slide calculation taking into account the expected price at the time of delivery based on the order amount included in the order data, and calculates the expected sales amount of the product at the time of delivery. [Prior art documents] [Patent documents]

[0004] [Patent Document 1] Japanese Patent Application Publication No. 2019-159719 Summary of the Invention [Problem to be solved by the invention]

[0005] The technology of Patent Document 1 is capable of predicting the price of a product at the time of delivery from the price of the product at the time of order even if the market price of the materials that make up the product or the exchange rate fluctuates, but it does not price the product taking into account expenses such as storage fees and transportation costs.

[0006] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a sales calculation device, a sales calculation method, and a sales calculation program that can appropriately price products in import and wholesale sales, taking into account exchange differences arising from exchange rate fluctuations, and other expenses such as product storage fees and transportation costs. [Means for solving the problem]

[0007] In order to solve the above-mentioned problems and achieve the object, the sales calculation device of the present invention is a sales calculation device equipped with a control unit, and is capable of accessing purchase data that stores information including the lot number, quantity, currency, and exchange rate of purchased goods, inventory cost data that stores information including the inventory valuation unit price of purchased goods, and an expense master that stores expense items of purchased goods linked to whether the expense items are fixed or optional, and the control unit is characterized by having an additional unit price calculation unit that calculates an additional foreign currency unit price and an additional yen unit price to be added to the sales unit price by referring to the purchase data and the expense master when a sales contract for the purchased goods is concluded, and a sales calculation unit that calculates a foreign currency unit price by adding the additional foreign currency unit price to an inputted foreign currency unit price of goods, a sales unit price by adding the additional yen unit price to the yen unit price of goods, a foreign currency amount by multiplying the foreign currency unit price and the sales quantity, and a yen amount by multiplying the yen unit price and the sales quantity.

[0008] In addition, the sales calculation device according to the present invention is characterized in that the sales calculation unit calculates gross profit by subtracting the cost amount from the yen sales amount.

[0009] In addition, the sales calculation device according to the present invention is characterized by comprising an estimate data creation unit that creates estimate data for a sales contract with a customer, an estimate detail data creation unit that creates detail data for the estimate contract, and an estimate addition breakdown data creation unit that creates estimate addition breakdown data, which is breakdown data for the additional unit price.

[0010] Furthermore, the sales calculation method according to the present invention is a sales calculation method executed by a sales calculation device equipped with a control unit, wherein the sales calculation device has access to purchase data storing information including the lot number, quantity, currency, and exchange rate of purchased goods, inventory cost data storing information including the inventory valuation unit price of the purchased goods, and an expense master storing expense items of purchased goods linked to whether the expense items are fixed or optional, and is characterized by including an additional unit price calculation step executed by the control unit to calculate an additional foreign currency unit price and an additional yen unit price to be added to the unit sales price by referring to the purchase data and the expense master when a sales contract for the purchased goods is concluded, and a sales calculation step to calculate a foreign currency unit price by adding the additional foreign currency unit price to an inputted foreign currency unit price of goods, a unit sales price by adding the additional yen unit price to the yen unit price of goods, a foreign currency amount by multiplying the foreign currency unit price and the sales quantity, and a yen unit price by multiplying the yen unit price and the sales quantity.

[0011] Furthermore, the sales calculation program according to the present invention is a sales calculation program to be executed by a sales calculation device having a control unit, wherein the sales calculation device is capable of accessing purchase data storing information including the lot number, quantity, currency, and exchange rate of purchased goods, inventory cost data storing information including the inventory valuation unit price of the purchased goods, and an expense master storing expense items of purchased goods linked to whether the expense items are fixed or optional, and causes the control unit to execute an additional unit price calculation step of calculating an additional foreign currency unit price and an additional yen unit price to be added to the unit sales price by referring to the purchase data and the expense master when a sales contract for the purchased goods is concluded, and a sales calculation step of calculating a foreign currency unit price by adding the additional foreign currency unit price to an inputted foreign currency unit price of goods, a unit sales price by adding the additional yen unit price to the yen unit price of goods, a foreign currency amount by multiplying the foreign currency unit price and the sales quantity, and a yen amount by multiplying the yen unit price and the sales quantity. [Effects of the Invention]

[0012] According to the present invention, it is possible to appropriately price products in import wholesale sales. [Brief explanation of the drawings]

[0013] [Figure 1] FIG. 1 is a diagram showing an example of the configuration of a sales calculation device according to this embodiment. [Figure 2] FIG. 2 is a diagram illustrating an example of purchase data. [Figure 3] FIG. 3 is a diagram illustrating an example of inventory cost data. [Figure 4] FIG. 4 is a diagram illustrating an example of expense data. [Figure 5] FIG. 5 is a diagram showing an example of the main information registration screen. [Figure 6] FIG. 6 is a diagram showing an example of the detailed information registration screen. [Figure 7] FIG. 7 is a diagram showing an example of the additional information registration screen. [Figure 8] FIG. 8 is a diagram showing an example of the detailed information registration screen. [Figure 9] FIG. 9 is a diagram showing an example of the main information registration screen. [Figure 10] FIG. 10 is a diagram illustrating an example of the quotation data. [Figure 11] FIG. 11 is a diagram illustrating an example of the quotation specification data. [Figure 12] FIG. 12 is a diagram illustrating an example of the estimated addition breakdown data. DETAILED DESCRIPTION OF THE INVENTION

[0014] Hereinafter, embodiments of a sales calculation device, a sales calculation method, and a sales calculation program according to the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to these embodiments.

[0015] [1. Configuration] An example of the configuration of a sales calculation device according to this embodiment will be described with reference to Fig. 1 etc. Fig. 1 is a diagram showing an example of the configuration of a sales calculation device 100 according to this embodiment.

[0016] The sales calculation device 100 is constructed based on a commercially available desktop personal computer. Note that the sales calculation device 100 is not limited to being constructed based on a stationary information processing device such as a desktop personal computer, but may also be constructed based on a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

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

[0018] The communication interface unit 104 communicably connects the sales calculation device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the sales calculation device 100 and the server device 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 memory unit 106 may also be stored in the server device 200, for example.

[0019] An input device 400 and an output device 500 are connected to the input / output interface unit 108. The output device 500 may be a monitor (including a home television), a speaker, or a printer. The input device 400 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 500 may be referred to as the monitor 500, and the input device 400 may be referred to as the keyboard 400 or the mouse 400.

[0020] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs that work in conjunction with the OS (Operating System) to issue commands to the 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 RAM (Random Access Memory) or ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc.

[0021] The storage unit 106 stores, for example, purchase data 106a, inventory cost data 106b, expense master 106c, estimate data 106d, estimate detail data 106e, estimate addition breakdown data 106f, and the like.

[0022] The purchase data 106a is data related to purchased products. As shown in Fig. 2, the purchase data 106a stores information such as the purchase number, purchase date, business establishment, name of warehouse where the purchased product is stored, supplier, transaction currency of the product, product name, lot number of the purchased product, quantity, purchase price, purchase amount, and exchange rate.

[0023] The inventory cost data 106b is data related to the inventory evaluation unit price of purchased goods. As shown in an example in Fig. 3, the inventory cost data 106b stores information such as the business establishment, the name of the warehouse where the purchased goods are stored, the product name, the lot number of the purchased goods, the quantity, the inventory amount, and the inventory evaluation unit price.

[0024] The expense master 106c stores the expense items of purchased goods, and associates them with whether the expense items are fixed or optional. As shown in an example in Fig. 4, the expense master 106c stores expense items such as warehouse storage fees, transportation fees, packing fees, and insurance fees, along with a fixed or optional flag.

[0025] The quotation data 106d is quotation data for a sales contract with a customer. As shown in an example in Fig. 10, the quotation data 106d stores the quotation number, business establishment, product storage warehouse, quotation date, customer, sales amount, cost amount, gross profit, etc.

[0026] The quotation detail data 106e is detail data of the quotation contract. As shown in an example in Fig. 11, the quotation detail data 106e stores the quotation number, product, quantity, exchange rate, foreign currency unit price of the product, Japanese yen unit price of the product, additional foreign currency unit price, additional Japanese yen unit price, foreign currency unit price of sales, sales unit price, foreign currency amount of sales, sales amount, gross profit, etc.

[0027] The estimate addition breakdown data 106f is breakdown data of the addition unit price. As shown in an example in Fig. 12, the estimate number, breakdown number, expense item, additional foreign currency unit price, additional yen unit price, etc. are stored.

[0028] The control unit 102 is a CPU or the like that performs overall control of the sales calculation 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.

[0029] The control unit 102 conceptually includes an additional unit price calculation unit 102a, a sales calculation unit 102b, an estimate data creation unit 102c, an estimate specification data creation unit 102d, an estimate additional breakdown data creation unit 102e, and the like.

[0030] The additional foreign currency calculation unit 102a calculates the additional foreign currency unit price and additional yen unit price to be added to the sales price by referring to the purchase data 106a and the expense master 106c when a sales contract for purchased merchandise is made.

[0031] The sales calculation unit 102b calculates the foreign currency sales price by adding the additional foreign currency unit price to the input product foreign currency unit price, the sales price by adding the additional yen unit price to the product yen unit price, the foreign currency sales amount by multiplying the foreign currency sales price and the sales quantity, and the yen sales amount by multiplying the yen sales price and the sales quantity.

[0032] The quotation data creation unit 102c creates quotation data 106d for each transaction, including the sales amount calculated by the sales calculation unit 102b.

[0033] The quotation detail data creating unit 102d creates quotation detail data 106e for each product, including the additional foreign currency unit price calculated by the sales calculation unit 102b.

[0034] The estimate addition breakdown data creation unit 102e creates estimate addition breakdown data 106f including the additional foreign currency unit price for each product and expense.

[0035] [2. Processing] Here, a specific example of the processing executed by the sales calculation device 100 will be described with reference to FIGS.

[0036] 5 is a diagram showing an example of a main information registration screen MA of the sales calculation device 100 according to the present embodiment. Before entering into a sales contract with a business partner for purchased goods, a user inputs data into the main information registration screen MA to calculate the sales amount.

[0037] First, as shown in Figure 5, information about the business partner with whom a sales contract will be made is entered in the business establishment, warehouse, quotation date, and customer fields on the main information registration screen MA. On the main information registration screen MA, an estimate for a transaction with customer "Y (XX Store)" for products stored in warehouse "10001 (Higashi-Ogishima Logistics Center)" at business establishment "100 (Tokyo Head Office)" is entered for May 5, 2024.

[0038] After entering information about the business partner with whom you will enter a sales contract in the fields for business establishment, warehouse, estimate date, and customer, pressing the "Detailed Information" button on the main information registration screen MA will take you to the detailed information registration screen MB.

[0039] FIG. 6 is a diagram showing an example of the detailed information registration screen MB. The user inputs the lot number, transaction quantity, and foreign currency unit price of the commodity for each commodity involved in the transaction. When the commodity and lot number are input, the currency and exchange rate are obtained from the purchase data 106a, and the exchange rate, currency, and Japanese yen unit price of the commodity are automatically input into the detailed information registration screen MB. The Japanese yen unit price of the commodity is calculated by multiplying the foreign currency unit price of the commodity by the exchange rate. FIG. 6 shows the state in which the lot number, transaction quantity, and foreign currency unit price of the commodity involved in the transaction, "S: Pepper," are input, and the exchange rate, currency, and Japanese yen unit price of the commodity are automatically input. After inputting the above items, the user presses the "Additional Information" button to transition to the additional information registration screen MC.

[0040] 7 is a diagram showing an example of the additional information registration screen MC. When transitioning to the additional information registration screen MC, the product, lot number, quantity, exchange rate, and currency are carried over and entered from the entry on the detailed information registration screen MB. For the expense category, the fixed display flag item ("1: Fixed") is automatically entered by referring to the expense master 102c.

[0041] The user inputs additional foreign currency unit prices for fixed-category expense items. In FIG. 7, "0.3," "0.9," "0.1," and "0.1" are input as the additional foreign currency unit prices for the fixed expense categories "warehouse storage fees," "transportation costs," "packing costs," and "insurance premiums," respectively. If necessary, the user may also input optional expense categories and their additional foreign currency unit prices by referring to the expense master 106c. In FIG. 7, "0.1" is input as the additional foreign currency unit prices for the optional expense categories "△△ expenses" and "○○ expenses." When the expense categories and additional foreign currency unit prices are input on the additional information registration screen MC, the additional unit price calculation unit 102a calculates the additional yen unit price by multiplying the product exchange rate by the input additional foreign currency unit price. The additional foreign currency unit price and the additional yen unit price for each expense category are then added together. The calculated additional yen unit price and the summed additional foreign currency unit price and additional yen unit price are automatically input to the additional information registration screen MC. In this embodiment, an additional foreign currency unit price and an additional yen unit price are acquired, and the additional foreign currency unit price is used in the case of a currency transaction other than yen, and the additional yen unit price can be used in the case of a yen transaction.

[0042] After inputting the additional information, the user presses the "Addition Registration" button, which transitions to the detailed information registration screen MB. Figure 8 is a diagram showing an example of the detailed information registration screen MB after transitioning from the additional information registration screen MC. The detailed information registration screen MB in Figure 8 automatically inputs the additional foreign currency unit price and additional yen unit price acquired and calculated on the additional information registration screen MC. Meanwhile, the sales calculation unit 102b calculates the foreign currency sales unit price obtained by summing the foreign currency unit price of the product and the additional foreign currency unit price, the sales unit price obtained by summing the yen unit price of the product and the additional yen unit price, the foreign currency sales amount obtained by multiplying the foreign currency sales unit price and the sales quantity, and the sales amount obtained by multiplying the sales unit price and the sales quantity. The calculated foreign currency sales unit price, yen sales unit price, foreign currency sales amount, and yen sales amount are automatically input to the detailed information registration screen MB.

[0043] The sales calculation unit 102b also obtains the unit cost price of the product from the inventory unit price data 106b, calculates the cost amount by multiplying the sales quantity by the unit cost price, and calculates the gross profit by subtracting the cost amount from the yen sales amount. The obtained and calculated unit cost price, cost amount, and gross profit are also automatically entered into the detailed information registration screen MB.

[0044] After the foreign currency sales price, yen sales price, foreign currency sales amount, yen sales amount, cost price, cost amount, gross profit, etc. acquired and calculated by the sales calculation unit 102b are automatically entered into the detail information registration screen MB, when the user presses the "Register Detail" button, the screen transitions to the main information registration screen MA.

[0045] Figure 9 is a diagram showing an example of the main information registration screen MA displayed after transitioning from the detailed information registration screen MB. The main information registration screen in Figure 9 contains the quantity, exchange rate, product foreign currency / yen unit price, additional foreign currency / yen unit price, sales foreign currency / yen unit price, and sales foreign currency / yen amount obtained on the detailed information registration screen MB and the additional information registration screen MC for the products "A: Pepper" and "B: Worcestershire Sauce" in a transaction with customer "Y (XX Store)." The sales calculation unit 102b adds up the sales yen amount and cost price of the two products and then calculates gross profit. The calculated sales yen amount, cost price, and gross profit are entered into the main information registration screen MA.

[0046] Figure 9 shows two products, but if there are other products being traded, you can press the "Details Information" button and enter information on the Details Information Registration Screen MB and the Additional Information Registration Screen MC to obtain the quantity of the entered product, exchange rate, product foreign currency / yen unit price, additional foreign currency / yen unit price, sales foreign currency / yen unit price, and sales foreign currency / yen amount.

[0047] After obtaining the sales amounts for all items included in the transaction, when the user presses the "Register voucher" button, the detail data creation unit 102c, the estimate detail data creation unit 102d, and the estimate addition breakdown data creation unit 102 create detail data 106d, estimate detail data 106e, and estimate addition breakdown data 106f, respectively, and store them in the memory unit 106.

[0048] As described above, the sales calculation device 100 according to this embodiment can appropriately price products by taking into consideration exchange rate differences arising from exchange rate fluctuations and expenses such as product storage fees, shipping costs, etc. Furthermore, since the quotation data 106d, quotation detail data 106e, and quotation addition itemized data 106f relating to a product transaction are stored in the storage unit 106, it becomes possible for a third party to easily perform an internal check of the product transaction by referring to the quotation data 106d, quotation detail data 106e, and quotation addition itemized data 106f.

[0049] [3. 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.

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

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

[0052] 4. 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.

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

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

[0055] Furthermore, with regard to the sales calculation device 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0056] For example, all or any part of the processing functions of the sales calculation 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 sales calculation 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. This computer program is executed by being loaded into RAM and cooperates with the CPU to form the control unit.

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

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

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

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

[0061] The sales calculation device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. The sales calculation device 100 may also be realized by installing software (including programs or data) that causes the device to perform the processes described in this embodiment.

[0062] 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. [Industrial Applicability]

[0063] The present invention is particularly useful for import and wholesale businesses. [Explanation of symbols]

[0064] 100 Sales Calculation Device 102 Control section 102a Additional unit price calculation section 102b Sales Calculation Department 102c Estimate Data Creation Department 102d Quote Detail Data Creation Department 102e Estimated Addition Breakdown Data Creation Department 104 Communication interface unit 106 Storage section 106a Purchase Data 106b Inventory Cost Data 106c Expense Master 106d Estimate Data 106e Quote detail data 106f Estimated additional breakdown data 108 Input / Output Interface Section 200 servers 300 Network 400 Input Device 500 output devices

Claims

1. A sales calculation device including a control unit, Purchase data that stores information including the lot number, quantity, currency, and exchange rate of purchased goods; Inventory cost data that stores information including the inventory valuation unit price of purchased products; An expense master that stores the expense items of purchased goods and whether the expense items are fixed or optional; is accessible to The control unit an additional unit price calculation unit that calculates an additional foreign currency unit price and an additional yen unit price to be added to the sales price by referring to the purchase data and the expense master when making a sales contract for the purchased goods; a sales calculation unit that calculates a foreign currency sales unit price obtained by adding the additional foreign currency unit price to the input product foreign currency unit price, a sales unit price obtained by adding the additional yen unit price to the product yen unit price, a foreign currency sales amount obtained by multiplying the foreign currency sales unit price and the sales quantity, and a yen sales amount obtained by multiplying the yen sales unit price and the sales quantity; A sales calculation device comprising:

2. The sales calculation device according to claim 1 , wherein the sales calculation unit calculates gross profit by subtracting a cost amount from the yen sales amount.

3. an estimate data creation unit that creates estimate data for sales contracts with customers; an estimate detail data creation unit that creates detail data for an estimate contract; an estimate addition breakdown data creation unit that creates estimate addition breakdown data, which is breakdown data of the additional unit price; The sales calculation device according to claim 1, further comprising:

4. A sales calculation method executed by a sales calculation device including a control unit, The sales calculation device Purchase data that stores information including the lot number, quantity, currency, and exchange rate of purchased goods; Inventory cost data that stores information including the inventory valuation unit price of purchased products; An expense master that stores the expense items of purchased goods and whether the expense items are fixed or optional; is accessible to causing the control unit to execute an additional unit price calculation step of calculating an additional foreign currency unit price and an additional yen unit price to be added to the sales price by referring to the purchase data and the expense master when making a sales contract for the purchased goods; a sales calculation step of calculating a foreign currency sales unit price obtained by adding the additional foreign currency unit price to the input product foreign currency unit price, a sales unit price obtained by adding the additional yen unit price to the product yen unit price, a foreign currency sales amount obtained by multiplying the foreign currency sales unit price and the sales quantity, and a yen sales amount obtained by multiplying the yen sales unit price and the sales quantity; A sales calculation method comprising:

5. A sales calculation program to be executed by a sales calculation device having a control unit, The sales calculation device Purchase data that stores information including the lot number, quantity, currency, and exchange rate of purchased goods; Inventory cost data that stores information including the inventory valuation unit price of purchased products; An expense master that stores the expense items of purchased goods and whether the expense items are fixed or optional; is accessible to The control unit an additional unit price calculation step of calculating an additional foreign currency unit price and an additional yen unit price to be added to the sales price by referring to the purchase data and the expense master when making a sales contract for the purchased goods; a sales calculation step of calculating a foreign currency sales unit price obtained by adding the additional foreign currency unit price to the input product foreign currency unit price, a sales unit price obtained by adding the additional yen unit price to the product yen unit price, a foreign currency sales amount obtained by multiplying the foreign currency sales unit price and the sales quantity, and a yen sales amount obtained by multiplying the yen sales unit price and the sales quantity; A sales calculation program for executing the above.

Images