JP7328827B2 - Sales/Estimated Cost Calculation Device, Sales/Estimated Cost Calculation Method, and Sales/Estimated Cost Calculation Program - Google Patents

Description

The present invention relates to a sales amount/approximate cost calculation apparatus, a sales amount/approximate cost calculation method, and a sales amount/approximate cost calculation program.

Patent Document 1 describes a solution negotiation that enables the user to easily grasp the essential information that is lacking when proceeding with solution negotiations, to easily select solution information that matches customer value, and to perform appropriate analysis and evaluation of the solution information. A support device, a control method for a solution negotiation support device, a control program, and a recording medium are disclosed (see paragraph 0014 of Patent Document 1), and an expected replacement time calculated from a lease/rental period, and budget preparation for the customer. It is disclosed to store timing and profit information (initially 0) in RAM as a temporary file (see paragraph 0227 of Patent Document 1, etc.).

JP 2009-163374 A

However, with the method described in Patent Literature 1, it was not possible to ascertain the cost at the same timing as sales are recorded.

For example, as shown in the relationship diagram of FIG. 2, when a rental company lends a product borrowed from a borrower to a lender, the sales amount to the lender can be grasped at the timing of the lending. On the other hand, the bill issued by the borrower is not always issued in the month in which the loan is made, but is often issued in the following month. In this case, the rental company cannot ascertain the cost of borrowing the product at the same timing as the sale of the product is recorded, which poses a problem from the viewpoint of expediting the settlement of accounts.

The present invention has been made in view of the above problems. An object of the present invention is to provide an approximate cost calculation method and a sales/approximate cost calculation program.

In order to solve the above-described problems and achieve the object, the sales amount/approximate cost calculation device according to the present invention includes a control unit, and when a rental company rents out a product borrowed from a borrower to a lender, A sales amount and approximate cost calculation device for calculating an approximate borrowing cost, which is an approximate amount of the sales amount to the lending destination and the cost amount required for the borrowing, wherein the control unit calculates the borrowing input for each product and the quantity of said product that has been lent, the period of said borrowing and said lending of said product entered for each said product, and per product and per day for said lending destination set for each said product and a sales amount calculation means for calculating the sales amount for each product to the lending destination based on the sales unit price that is the sales amount and is input or automatically set, and the sales amount input for each product The amount of the borrowed and lent products, the borrowing and lending period of the products entered for each product, and the borrowing time required for the borrowing set for each combination of the borrower and the product Calculating an approximate cost for each product related to the borrowing from the borrower based on the borrowing unit price, which is the cost amount per product and per day and is input or automatically set. Calculating the sales amount for the lending destination by totalizing the sales amount for each of the products for the lending destination calculated by the approximate cost calculating means and the sales amount calculating means for all the leasing products for the lending destination and calculating the approximate cost for each product related to the borrowing from the borrower calculated by the approximate cost calculation means for all the products borrowed from the borrower and a tallying means for calculating a borrowing approximate cost.

Further, the sales amount/approximate cost calculation apparatus according to the present invention is characterized in that the period is a period from the first day of the month to the last day of the month, and the means calculates the monthly amount.

Further, in the sales amount/approximate cost calculation apparatus according to the present invention, the control unit performs the borrowing related to the borrowing from the borrower calculated by the totalizing means from the sales amount for the lending destination calculated by the totalizing means. It is characterized by further comprising an approximate gross profit calculating means for calculating an approximate gross profit by subtracting the approximate cost.

Further, in the sales amount/approximate cost calculation apparatus according to the present invention, the control unit calculates the approximate journal entry including the borrowing approximate cost calculated by the totalizing means in the month in which the sales to the lending destination are recorded. It is characterized by further comprising journal creation means for creating things.

Further, in the sales amount/approximate cost calculation apparatus according to the present invention, the journal creation means further includes a cancellation journal containing an amount equal to the borrowing approximate cost for canceling the borrowing approximate cost, and the sales are recorded. Create a formal journal including the official cost of borrowing, which is the official cost amount related to the borrowing notified by the borrower in the following month, and is recorded in the following month. characterized by

Further, in the sales amount/approximate cost calculation device according to the present invention, the control unit calculates a difference obtained by subtracting the borrowing approximate cost calculated by the totalizing unit from the notified formal borrowing cost. characterized by further comprising

Further, the sales amount/approximate cost calculation apparatus according to the present invention is characterized in that the goods are traffic safety goods.

Further, the sales amount/approximate cost calculation method according to the present invention is executed by an information processing device having a control unit, and when a rental company rents out a product borrowed from a borrower to the lender, the sales amount to the lender is calculated. A sales amount/approximate cost calculation method for calculating an approximate borrowing cost that is an approximate amount of the amount and the cost amount required for the borrowing, wherein the borrowing and the borrowing input for each product and the The quantity of said product lent out, said borrowing and said lending period of said product entered for each said product, and said per product and per day for said lending destination set for each said product a sales amount calculation step of calculating the sales amount for each product to the lending destination based on the sales unit price which is the sales amount and which is input or automatically set; and the borrowing input for each product. and the quantity of the product that has been lent, the period of borrowing and lending the product entered for each product, and the product required for the borrowing that is set for each combination of the borrower and the product. Approximate cost for calculating the approximate cost for each product related to the borrowing from the borrower based on the borrowing unit price, which is the cost amount per piece and per day and is input or automatically set calculating the sales amount for the lending destination by totalizing the sales amount for each product for the lending destination calculated in the calculating step and the sales amount calculating step for all the products lent to the lending destination; said borrowing estimate relating to said borrowing from said borrower by aggregating the approximate cost for each of said products relating to said borrowing from said borrower calculated in said approximate cost calculation step for all said products borrowed from said borrower; and an aggregation step of calculating the cost.

In addition, a sales amount/approximate cost calculation program according to the present invention is a program to be executed by an information processing apparatus having a control unit. A sales amount/approximate cost calculation program for calculating a borrowing approximate cost that is an approximate amount of the sales amount and the cost amount required for the borrowing, wherein the borrowing input for each product is executed by the control unit and the quantity of said product that has been lent, the period of said borrowing and said lending of said product entered for each said product, and per product and per day for said lending destination set for each said product A sales amount calculation step of calculating the sales amount of each product for the rental destination based on the unit sales price that is the sales amount of the product that is input or automatically set; The amount of the borrowed and lent products, the borrowing and lending period of the products entered for each product, and the borrowing time required for the borrowing set for each combination of the borrower and the product Calculating an approximate cost for each product related to the borrowing from the borrower based on the borrowing unit price, which is the cost amount per product and per day and is input or automatically set. The sales amount for the lending destination is calculated by aggregating the sales amount for each product for the lending destination calculated in the approximate cost calculation step and the sales amount calculation step for all the products lent to the lending destination. and calculating the estimated cost for each product related to the borrowing from the borrower calculated in the approximate cost calculation step for all the products borrowed from the borrower and an aggregating step of calculating an estimated borrowing cost.

According to the present invention, it is possible to calculate together the sales amount of the product and the approximate cost amount required for borrowing the product.

FIG. 1 is a block diagram showing an example of the configuration of a sales amount/approximate cost calculation apparatus. FIG. 2 is a diagram showing an example of a relationship diagram among borrowers, rental companies, and lenders. FIG. 3 is a diagram showing an example of rough journal entries, cancellation journal entries, and formal journal entries. FIG. 4 is a diagram showing an example of sales detail history data before billing amounts and estimated costs are set. FIG. 5 is a diagram showing an example of sales detail history data after setting the billing amount and estimated cost. FIG. 6 is a diagram showing an example of purchase detail history data.

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of a sales amount/approximate cost calculation apparatus, a sales amount/approximate cost calculation method, and a sales amount/approximate cost 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. Specific configurations and operations will be described below.

[1. composition]
An example of the configuration of the sales amount/approximate cost calculation apparatus 100 according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of a sales amount/approximate cost calculation apparatus 100. As shown in FIG.

The sales amount/approximate cost calculation apparatus 100 is a commercially available desktop personal computer. Note that the sales/approximate cost calculation device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a commercially available notebook personal computer, PDA (Personal Digital Assistants), a smart phone, or a tablet personal computer. and other portable information processing devices.

The sales amount/approximate cost calculation apparatus 100 includes a control unit 102 , a communication interface unit 104 , a storage unit 106 and an input/output interface unit 108 . Each unit included in the sales amount/approximate cost calculation apparatus 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the sales amount/estimated cost calculation apparatus 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 another device via a communication line. Here, the network 300 has a function of connecting the sales amount/approximate cost calculation 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). Data such as various masters described later may be stored in the server 200, for example.

An input device 112 and an output device 114 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 includes, for example, sales detail history data 106a and purchase detail history data 106b.

Here, according to the sales amount/approximate cost calculation device 100 according to the present embodiment, as shown in the relationship diagram of FIG. It is possible to calculate an approximate borrowing cost, which is an approximate amount of the sales amount to the destination and the cost amount required for the borrowing. The user of the sales amount/approximate cost calculation apparatus 100 according to the present embodiment is, for example, the rental company. The goods may be anything that can be rented, such as traffic safety goods and construction equipment.

The sales detail history data 106a is history data of sales details. As shown in FIGS. 4 and 5, the sales detail history data 106a includes, for example, rental company identification data (office) for identifying the rental company and borrower identification data for identifying the borrower. (supplier), product identification data (product name) for identifying the product, the quantity (quantity) of the borrowed and lent products entered for each product, and input for each product It includes the borrowing and lending period (billing period), the number of days (number of days) of the period, the billing unit price, the billing amount, the purchasing unit price, the approximate cost, and the like.

The billing period may be the period from the first day of the month to the last day of the month as shown in FIGS. 4 and 5, or may be any other period. The billing period "10/01 to 10/31" shown in FIGS. 4 and 5 corresponds to the period in the former case, and it is said that the loan has been lent to the lending party since September and throughout October. Assuming a period of time.

The billing unit price is a sales unit price, which is the amount of sales per product per day to the lending destination, which is set for each product, and is input or automatically set. In the case of automatic setting, for example, if the product identification data and the billing unit price are linked and set in the billing unit price master, the billing data can be set by inputting the product identification data into the sales detail history data 106a. By obtaining the billing unit price associated with the input product identification data from the unit price master, it is possible to automatically set the obtained billing unit price in the sales detail history data 106a.

The billed amount is the sales amount for each product to the lending destination calculated by the sales amount calculation unit 102a described later.

The purchase unit price is a borrowing unit price, which is the cost amount per day per product required for the borrowing, set for each combination of the borrower and the product, and is input or automatically set. It is a thing. In the case of automatic setting, for example, if the borrower identification data, the product identification data, and the purchase unit price are linked and set in the purchase unit price master, the borrower identification data and the product identification data is entered into the sales detail history data 106a to acquire the purchase unit price linked to the input borrower identification data and product identification data from the purchase unit price master, and the acquired purchase unit price is displayed in the sales details It is possible to automatically set to the history data 106a.

The approximate cost is an approximate cost for each product related to the borrowing from the borrower, which is calculated by an approximate cost calculation unit 102b, which will be described later.

The purchase detail history data 106b is purchase detail history data. As shown in FIG. 6, the purchase detail history data 106b includes, for example, the rental company identification data (office), the borrower identification data (supplier), and the classification of the purchase details (purchase details: other company's rental), the purchase quantity (quantity), the official cost amount (purchase amount) regarding the borrowing notified from the borrower, and the like.

As the information linking the sales detailed history data 106a and the purchase detailed history data 106b, for example, the rental company identification data (office) and the borrower identification data (supplier) can be used.

The control unit 102 is a CPU or the like that controls the sales amount/approximate cost calculation apparatus 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. Execute.

The control unit 102 functionally conceptually functions, for example, as follows: (1) the quantity of the borrowed and lent products input for each product; and a sales unit price, which is the sales amount per product per day to the lending destination set for each product, and is input or automatically set. (2) the quantity of the borrowed and lent products entered for each product; Borrowing, which is the cost amount per day per product required for the borrowing, which is set for each combination of the borrowing and lending period of the input product and the borrowing party and the product (3) an approximate cost calculation unit 102b as an approximate cost calculation means for calculating an approximate cost for each product related to the borrowing from the borrower based on the unit price that is input or automatically set; calculating the sales amount to the lending destination by summing the sales amount for each of the products to the lending destination calculated by the sales amount calculating means for all the leasing products to the lending destination; and calculating the approximate cost. calculating the estimated borrowing cost related to the borrowing from the borrower by aggregating the estimated cost for each of the products related to the borrowing from the borrower calculated by means for all the products borrowed from the borrower and (4) a totaling unit 102c as totalizing means, and (4) subtracting the estimated borrowing cost related to the borrowing from the borrower calculated by the totalizing means from the sales amount for the lending destination calculated by the totalizing means. and (5) an approximate journal entry including the approximate cost of borrowing calculated by the aggregation means, in which sales to the lending destination are recorded. and (6) a cost difference for calculating the difference obtained by subtracting the estimated borrowing cost calculated by the totalizing means from the notified formal borrowing cost. and a cost difference calculation unit 102f as calculation means.

The sales amount calculation unit 102a calculates the amount of the borrowed and lent products input for each product (quantity in the sales detail history data 106a) and the borrowed and rented products input for each product. Enter or Based on the automatically set value (billed unit price in the sales detail history data 106a), the sales amount (billing amount in the sales detail history data 106a) for each product to the lending destination is calculated.

The estimated cost calculation unit 102b calculates the quantity of the borrowed and lent products input for each product (the quantity in the sales detail history data 106a) and the borrowed and rented products input for each product. The rental period (the billing period in the sales detail history data 106a) and the cost amount per day per product required for the borrowing set for each combination of the borrower and the product. Based on the borrowing unit price input or automatically set (purchase unit price in the sales detail history data 106a), the estimated cost for each product related to the borrowing from the borrower (sales detail history data 106a Calculate the estimated cost in the middle).

The counting unit 102c calculates the sales amount for the lending destination by summing up the sales amount for each product for the lending destination calculated by the sales amount calculating unit 102a for all the leasing products for the lending destination. , the borrowing related to the borrowing from the borrower by totalizing the approximate cost for each product related to the borrowing from the borrower calculated by the approximate cost calculation unit 102b for all the products borrowed from the borrower Calculate the approximate cost. As a result, for example, it is possible to grasp the costs required for borrowing the product at the same timing as the sales of the product are recorded, which leads to early settlement of accounts.

The estimated gross profit calculation unit 102d calculates an approximate gross profit by subtracting the estimated borrowing cost related to the borrowing from the borrower calculated by the totalizing unit 102c from the sales amount for the lending destination calculated by the totalizing unit 102c. calculate. As a result, for example, an approximate gross profit can be accurately and quickly grasped.

The journal creation unit 102e creates an approximate journal including the approximate borrowing cost calculated by the tabulating unit 102c and recorded in the month in which the sales to the lending destination are recorded. As a result, for example, it is possible to close the P/L at an early stage, even though it is an approximate cost amount.

The journal creation unit 102e further provides a cancellation journal containing an amount equal to the estimated borrowing cost for canceling the estimated borrowing cost, which is recorded in the month following the month in which the sales are recorded, and the A formal journal including the formal cost of borrowing, which is the formal cost amount related to the borrowing notified in the next month, may be prepared and recorded in the following month. This makes it possible, for example, to adjust (correct) the approximate cost amount based on the official cost amount.

The cost difference calculation unit 102f calculates a difference (cost difference) by subtracting the estimated borrowing cost calculated by the aggregation unit 102c from the notified formal borrowing cost. The cost difference can be ascertained by recording the formal journal entry, but if the cost difference calculation unit 102f automatically calculates the cost difference, it becomes possible to accurately and quickly ascertain the cost difference. .

[2. Specific example of processing]
In this section, a specific example of processing according to this embodiment will be described.

In this item, the processing for calculating the sales amount and the approximate borrowing cost based on the sales detail history data 106a in FIG. 4, which records the borrowing and lending history in October 2018, will be described in [2-1] below. do. Next, the following [2- 2].

[2-1: Calculation processing of sales amount and borrowing approximate cost]
The sales amount calculation unit 102a calculates the sales amount for each product to the lending destination based on the sales detail history data 106a of FIG. Specifically, the sales amount calculation unit 102a calculates the sales amount of the product name “Framework 1217” in FIG. In addition, the sales amount of the product name "Framework 1227" in Fig. 4 is calculated as: quantity 100 x billing period 10/01 to 10/31 (31 days) x billing unit price 270 yen = 837,000 yen, Then, the sales amount of the product name "frame frame 1237" in FIG. FIG. 5 shows the sales detail history data 106a in which the calculated sales amount for each product is set as the billing amount.

Subsequently, the aggregation unit 102c aggregates the sales amount for each product for the lending destination calculated by the sales amount calculating unit 102a, and the sales amount for the lending destination is 527,000 yen + 837,000 yen + 1,147,000 yen = 2,511,000 yen. to calculate.

On the other hand, the estimated cost calculation unit 102b calculates the estimated cost for each product related to borrowing from the borrower “XX Rental Co., Ltd.” based on the detailed sales history data 106a of FIG. Specifically, the estimated cost calculation unit 102b calculates the estimated cost of the product name “Framework 1217” in FIG. Calculated as 310,000 yen, and calculated the approximate cost of the product name "Framework 1227" in Fig. 4 as: quantity 100 x billing period 10/01 to 10/31 (31 days) x purchase unit price 120 yen = 372,000 yen Then, the estimated cost of the product name "framework 1237" in FIG. FIG. 5 shows sales detail history data 106a in which the calculated approximate cost for each product is set.

Subsequently, the aggregation unit 102c aggregates the approximate cost for each product related to the borrowing from the borrower “XX Rental Co., Ltd.” calculated by the approximate cost calculation unit 102b, Estimated borrowing cost for borrowing is calculated as 310,000 yen + 372,000 yen + 465,000 yen = 1,147,000 yen.

Thus, according to the sales amount/approximate cost calculation apparatus 100 according to the present embodiment, the sales amount (2,511,000 yen) and the borrowing approximate cost (1,147,000 yen) can be calculated together. As a result, the "xx branch" of the rental company can grasp the cost required for borrowing the product at the same timing as sales are recorded.

Here, the sales office of the rental company can grasp the approximate gross profit by obtaining the difference between the sales amount and the borrowing approximate cost. can be calculated, the sales office staff can grasp the gross profit more quickly and accurately.

Specifically, the estimated gross profit calculation unit 102d calculates the borrowing estimate for the borrowing from the borrower "○○ Rental Co., Ltd." By deducting the cost of 1,147,000 yen, an approximate gross profit of 1,364,000 yen is calculated.

[2-2: Journal creation process]
Next, in the following month, November 2018, it is assumed that the borrower "○○ Rental Co., Ltd." notified the official borrowing cost of 1,150,000 yen, which is the official cost amount for the borrowing of the three borrowed products. In this case, the sales work, etc. of the rental company “XX Branch” will be the estimated cost of borrowing from If there is no problem after comparing the cost of 1,150,000 yen, the notified formal borrowing cost of 1,150,000 yen is registered in the purchase detail history data 106b. In other words, if the cost difference, which is the difference between the estimated purchase amount (borrowing approximate cost) and the official purchase amount (borrowing official cost), is not so large, the sales office, etc. A payment amount of 1,150,000 yen is registered in the purchase detail history data 106b. In this example, the difference between the estimated purchase amount and the formal purchase amount is only 3,000 yen. It is assumed to be registered in the payment history data 106b.

The calculation of the cost difference may be automatically performed by the cost difference calculation unit 102f as follows. That is, the cost difference calculation unit 102f can calculate 3,000 yen as the cost difference by subtracting the estimated borrowing cost of 1,147,000 yen calculated by the counting unit 102c from the notified formal borrowing cost of 1,150,000 yen.

Below, the three journal entries created based on the estimated borrowing cost of 1,147,000 yen calculated in [2-1] or the official borrowing cost of 1,150,000 yen registered in the purchase detail history data 106b are described in (1) below. (3) will explain.

As an overview, the journal entry creation unit 102e posts the estimated rental cost of other companies, which was used when calculating the gross profit at the time of recording sales, as a preliminary report in the current month, and records the same negative amount as a cancellation journal entry in the following month.

(1) Creating an Estimated Journal create journal entries; The estimated journal entry is a journal entry containing the estimated borrowing cost related to borrowing from the borrower "○○ Rental Co., Ltd.", and is recorded in October 2018, which is the month in which sales to the lender are recorded.

As a specific process for creating an approximate journal entry, the journal creation unit 102e performs the following as shown in FIG.
・Including rental cost as a debit item,
・The debit amount includes the rental sales cost of 1,147,000 yen in the sales detail history data 106a of FIG.
・As a credit item, including headquarters,
・The credit amount includes 1,147,000 yen, which is the same amount as the debit amount.
Create approximate journal entries.

The 1,147,000 yen in the approximate journal entry is a rough estimate and not a fixed purchase, but it is linked as a journal entry in order to close the P/L at an early stage in accounting.

(2) Creation of Cancellation Journal Next, the journal creation unit 102e creates the cancellation journal shown in FIG. 3 based on the created rough journal. The cancellation journal entry is a journal entry for canceling the estimated borrowing cost related to the borrowing from the lender "○○ Rental Co., Ltd.", and is recorded in November 2018, the month following the month in which sales are recorded (October 2018). be done.

As a specific process of creating a cancellation journal entry, the journal entry creation unit 102e performs the following as shown in FIG.
・As a debit item, including the headquarters, which is the credit item of the rough journal entry in Figure 3,
・The debit amount includes 1,147,000 yen, which is the same amount as the credit amount of the rough journal entry in Figure 3.
・As a credit item, including the rental cost, which is a debit item in the rough journal entry in Figure 3,
・The credit amount includes 1,147,000 yen, which is the same amount as the debit amount of the rough journal entry in Figure 3.
Create a reversal journal entry.

(3) Creation of formal journal entries Finally, the journal entry creation unit 102e creates the Create a formal journal entry shown in 3. The official journal entries include the official borrowing cost, which is the official cost amount notified by the borrower “○○ Rental Co., Ltd.” Accounted for in November.

As a specific process of formal journal creation, the journal creation unit 102e performs the following as shown in FIG.
・Including rental cost as a debit item,
・The debit amount includes the rental purchase amount of 1,150,000 yen in the purchase detail history data 106b of FIG.
・Including accounts payable as a credit item,
・The credit amount includes 1,150,000 yen, which is the same amount as the debit amount.
Create a formal journal entry.

In the formal journal entry, the difference between the official purchase amount and the official purchase amount is additionally recorded in November (October's cost difference is recorded in November). In other words, the difference between the rental cost and the rental cost is adjusted for the current month as the last month's cost difference.

[3. Summary of this embodiment]
As described above, according to the sales amount/approximate cost calculation apparatus 100 according to the present embodiment, as described in [2-1], the sales amount of the product and the approximate cost amount required for borrowing the product are calculated. can be calculated together. As a result, for example, it is possible to grasp the costs required for borrowing the product at the same timing as the sales of the product are recorded, which leads to early settlement of accounts.

Here, in the past, there was a problem that the arrival of the bill of the other company's rental company (loaner) was delayed, and if the arrival of the bill was delayed, the P/L could not be closed early. Also, even if the estimated cost is recorded, the work of calculating the amount (approximate cost) was not easy. Therefore, in this embodiment, for example, the following three things are made possible.

First, in the present embodiment, for example, the cost can be grasped at the same timing as sales are recorded. In the past, in order to grasp the gross profit for each site at each other company's rental destination, it was impossible to grasp it without entering the details of the invoice from the other company's rental destination, but in this embodiment, sales are recorded and At the same time, by calculating the cost roughly, it became possible to grasp the gross profit without entering the contents of the invoice.

Secondly, in the present embodiment, for example, at the time of formal accounting of purchases, it is not necessary to input detailed purchase details, and all that is necessary is to input the total amount of the invoice. In this embodiment, since information for grasping gross profit is separately stored (in the sales detail history data 106a), it is sufficient to input the minimum information required for making payment when inputting purchases. Ta.

Thirdly, in the present embodiment, for example, it is made easy to check invoices from other companies' rental companies. In the past, it was difficult to scrutinize the invoice received from the borrower because there were many cases where there was no material to check the invoice. You can now check your invoices for comparison. And if there is a large discrepancy, it has become possible to point out the billing mistakes of other companies' rentals.

[4. 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 amount/approximate cost calculation apparatus 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, all or any part of the processing functions provided in the sales amount/approximate cost calculation apparatus 100, particularly each processing function performed by the control unit, is performed by a CPU and a program interpreted and executed by the CPU. It may be implemented as hardware by wired logic. In addition, the program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing apparatus to execute the processing described in this embodiment. It is mechanically read by the approximate cost calculation device 100 . 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.

In addition, this computer program may be stored in an application program server connected to the sales amount/approximate cost calculation apparatus 100 via any network, and all or part of it may be downloaded as necessary. is also possible.

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 Blu-ray (registered trademark) Disc, etc. 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 structure, but is distributed as a plurality of 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.

Further, the sales amount/approximate cost 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. good. Further, the sales amount/approximate cost calculation device 100 may be realized by installing software (including programs, data, etc.) for realizing the processing described in the present embodiment in the device.

Furthermore, the specific form of distribution and integration of devices is not limited to the one shown in the figure, 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 implemented selectively.

INDUSTRIAL APPLICABILITY The present invention is useful, for example, in an industry that rents products.

100 sales amount/approximate cost calculation device 102 control unit
102a sales calculation unit
102b Approximate cost calculator
102c tally unit
102d Approximate Gross Profit Calculation Unit
102e Journal Creation Department
102f cost difference calculation unit 104 communication interface unit 106 storage unit
106a Sales detail history data
106b purchase detail history data 108 input/output interface unit 112 input device 114 output device 200 server 300 network

Claims (9)

A sales amount for calculating an estimated borrowing cost, which is an approximate amount of the sales amount to the lending destination and the cost amount required for the borrowing, when the rental company rents the product borrowed from the borrowing destination to the lending destination. - An approximate cost calculation device,
The control unit
The amount of the borrowed and lent products entered for each product, the borrowing and lending period for the products entered for each product, and the lending destination set for each product Sales amount calculation means for calculating the sales amount of each product to the lending destination based on the unit sales price, which is the sales amount per product and per day and is input or automatically set. and,
The quantity of the borrowed and lent products entered for each product, the borrowing and lending period of the products entered for each product, and the borrowing and lending periods are set for each combination of the borrower and the product. In addition, based on the borrowing unit price, which is the cost per product per day required for the borrowing and is input or automatically set, the product related to the borrowing from the borrower an approximate cost calculation means for calculating an approximate cost for each
calculating the sales amount to the lending destination by summing the sales amount for each of the products to the lending destination calculated by the sales amount calculating means for all the leasing products to the lending destination; and calculating the approximate cost. calculating the estimated borrowing cost related to the borrowing from the borrower by aggregating the estimated cost for each of the products related to the borrowing from the borrower calculated by means for all the products borrowed from the borrower aggregating means;
to provide
A sales amount / approximate cost calculation device characterized by The period is a period from the first day of the month to the last day of the month,
the sales amount calculation means, the approximate cost calculation means, and the aggregation means calculate monthly amounts;
The sales amount/approximate cost calculation device according to claim 1, characterized by: The control unit
an approximate gross profit calculation means for calculating an approximate gross profit by subtracting the estimated borrowing cost related to the borrowing from the borrower calculated by the aggregation means from the sales amount for the lending destination calculated by the aggregation means; be more prepared,
3. The sales amount/approximate cost calculation device according to claim 2 , characterized by: The control unit
further comprising journal creation means for creating an approximate journal including the approximate borrowing cost calculated by the aggregation means and recorded in the month in which sales to the lending destination are recorded;
4. The sales amount/approximate cost calculation device according to claim 2 or 3, characterized by: The journal creation means further
A cancellation journal containing an amount equal to the estimated borrowing cost for canceling the said estimated borrowing cost, which is recorded in the month following the month in which the sales are recorded, and concerning the borrowing notified by the borrower in the following month Preparing a formal journal including the borrowing formal cost, which is the formal cost amount, to be recorded in the following month;
5. The sales amount/approximate cost calculation device according to claim 4, characterized by: The control unit
further comprising cost difference calculation means for calculating a difference obtained by subtracting the estimated borrowing cost calculated by the totalizing means from the notified formal borrowing cost;
6. The sales amount/approximate cost calculation device according to claim 5, characterized by: the goods are traffic safety goods;
The sales amount/approximate cost calculation apparatus according to any one of claims 1 to 6, characterized by: Borrowing, which is an estimated amount of the sales amount to the lending destination and the cost amount required for the borrowing, when the rental company rents the product borrowed from the borrowing destination to the lending destination, executed by an information processing device having a control unit. A sales amount/approximate cost calculation method for calculating an approximate cost,
executed by the control unit;
The amount of the borrowed and lent products entered for each product, the borrowing and lending period for the products entered for each product, and the lending destination set for each product A sales amount calculation step of calculating the sales amount of each product to the lending destination based on the unit sales price, which is the sales amount per product and per day and is input or automatically set. and,
The quantity of the borrowed and lent products entered for each product, the borrowing and lending period of the products entered for each product, and the borrowing and lending periods are set for each combination of the borrower and the product. In addition, based on the borrowing unit price, which is the cost per product per day required for the borrowing and is input or automatically set, the product related to the borrowing from the borrower an approximate cost calculation step for calculating an approximate cost for each
calculating the sales amount for the lending destination by aggregating the sales amount for each product for the lending destination calculated in the sales amount calculating step for all the leasing products for the lending destination, and calculating the approximate cost; Calculating the estimated borrowing cost related to the borrowing from the borrower by summing the estimated cost for each product related to the borrowing from the borrower calculated in the step for all the products borrowed from the borrower. an aggregation step;
including
A method for calculating sales amount and approximate cost, characterized by Estimated amount of sales to the borrower and cost amount required for the borrowing when the rental company rents the product borrowed from the borrower to the lender, for execution by the information processing device having the control unit. A sales amount/approximate cost calculation program for calculating an approximate borrowing cost,
for causing the control unit to execute
The amount of the borrowed and lent products entered for each product, the borrowing and lending period for the products entered for each product, and the lending destination set for each product A sales amount calculation step of calculating the sales amount of each product to the lending destination based on the unit sales price, which is the sales amount per product and per day and is input or automatically set. and,
The quantity of the borrowed and lent products entered for each product, the borrowing and lending period of the products entered for each product, and the borrowing and lending periods are set for each combination of the borrower and the product. In addition, based on the borrowing unit price, which is the cost per product per day required for the borrowing and is input or automatically set, the product related to the borrowing from the borrower an approximate cost calculation step for calculating an approximate cost for each
calculating the sales amount for the lending destination by aggregating the sales amount for each product for the lending destination calculated in the sales amount calculating step for all the leasing products for the lending destination, and calculating the approximate cost; Calculating the estimated borrowing cost related to the borrowing from the borrower by summing the estimated cost for each product related to the borrowing from the borrower calculated in the step for all the products borrowed from the borrower. an aggregation step;
including
Sales amount / approximate cost calculation program characterized by.

Images