JP2022154317A - Sales simulation device, sales simulation method, and sales simulation program - Google Patents

Abstract

To facilitate grasping of sales plan ahead even when progress-based sales is adopted.SOLUTION: A storage unit for a sales simulation device of an embodiment stores received order data managing received order amount which is subject of a contract agreement to which construction progress standard is applied by received order, a progress ratio data for managing planned progress ratio by received order and by sales planned month, and budget data for managing a budget amount for the contract agreement subject by received order, a control unit includes a first creation means for creating the first data stored with planned progress sales amount according to planned progress ratio by received order and by sales planned month based on the received order data and progress ratio data, a second creation means for creating second data stored with planned progress ratio, planned progress sales amount, budget amount taking into account the planned progress ratio, an amount subtracting the budget amount from the planned progress sales amount, and an amount having the amount divided by the planned progress sales amount, and an output control means for outputting the second data to the output device.SELECTED DRAWING: Figure 1

Description

TECHNICAL FIELD Embodiments of the present invention relate to a sales simulation device, a sales simulation method, and a sales simulation program.

Conventionally, in plant manufacturing and construction work, there are known cases of adopting percentage-of-completion sales in the case of contract contracts.

JP-A-2006-72547

In the case of progress-based sales, sales are determined by the ratio of incurred costs to the budget (progress rate), so there is a problem that it is difficult to grasp future sales plans.

The present invention has been made in view of the above problems, and a sales simulation device and a sales simulation method capable of facilitating grasping of a future sales schedule even in the case of adopting progress-based sales. and to provide a sales simulation program.

In order to solve the above-described problems and achieve the object, the sales simulation device of the embodiment is a sales simulation device that includes a control unit and a storage unit, and the storage unit is applied with a percentage-of-completion standard for each order received. order data for managing the order amount of the contract object, progress rate data for managing the progress rate of the schedule for each order and for each sales month, and budget data for managing the budget amount for the contract object for each order. , and the control unit stores first data in which planned progress sales according to the planned progress rate are stored for each order received and for each planned sales month, based on the order data and the progress rate data. and a budget amount that takes into account the planned progress rate, the planned progress sales amount, and the planned progress rate for each order and for each month of planned sales, based on the budget data and the first data. , a second creating means for creating second data storing an amount obtained by subtracting the budgeted amount from the planned progress sales and an amount obtained by dividing the said amount by the planned progress sales; and output control means for outputting the data of to the output device.

Further, in the sales simulation device of the embodiment, the order amount is denominated in a first currency, and an allocation rate calculating means is provided for calculating an allocation rate for each order received and for each scheduled sales month, and the first creating means further includes: The method is characterized in that the first data denominated in the second currency is created in consideration of the reserve rate.

Further, in the sales simulation device of the embodiment, the storage unit stores fixed order exchange data for each order, and the allocation rate calculation means, based on the order exchange data, stores information on allocation for the corresponding order. The relevant allocation rate shall be treated as fixed, and for unallocated information, simulated exchange data shall be obtained from the rate master, and the average exchange rate corresponding to the aforementioned scheduled sales month shall be calculated and used as the relevant allocation rate. Characterized by

Further, in the sales simulation device of the embodiment, the control unit calculates the final sales from the progress sales calculated using the average rate for the order amount, from the final scheduled sales month. It is characterized in that it is recorded after deducting the previously recorded sales.

In addition, the sales simulation method of the embodiment is a sales simulation method executed by a sales simulation device, and includes order data for managing the order amount of a contract subject to which the progress of completion standard is applied for each order, sales schedule for each order, and sales forecast for each order. a step of creating first data in which planned progress sales according to the progress rate of the plan are stored for each order received and for each month of planned sales, based on progress rate data for managing the progress rate of the plan for each month; Based on the budget data for managing the budget amount for the contract object for each order and the first data, the planned progress rate, the planned progress sales, and the planned progress rate are added for each order and for each month of planned sales. creating second data storing a budget amount, an amount obtained by subtracting the budget amount from the planned progress sales, and an amount obtained by dividing the budget by the planned progress sales; and a step of outputting the data to an output device.

In addition, the sales simulation program of the embodiment includes order data for managing the amount of orders received for a contract subject to which the construction progress standard is applied, for each order, and a progress rate for managing the progress rate of the schedule for each order and for each month of scheduled sales. A sales simulation program for controlling a sales simulation device by a computer, comprising a storage unit for storing data and budget data for managing the budget amount for the contract object for each order, wherein the computer is the above a first creating means for creating first data storing planned progress sales according to the progress rate of the plan for each order and for each month of planned sales, based on the order data and the progress rate data; and the budget. Based on the data and the first data, for each order and for each month of scheduled sales, the planned progress rate, the planned progress sales, the budget amount considering the planned progress rate, and the budget amount from the planned progress sales and an amount obtained by dividing the said amount by the scheduled progress sales is stored; and an output control means for outputting said second data to an output device. It is characterized by functioning as

ADVANTAGE OF THE INVENTION According to this invention, it is effective in the ability to grasp a future sales schedule easily, even if it is a case which adopts progress-based sales.

FIG. 1 is a schematic configuration block diagram of a sales simulation device. FIG. 2 is an explanatory diagram of a configuration example of an order reception database. FIG. 3 is an explanatory diagram of a configuration example of a budget database. FIG. 4 is an explanatory diagram of a configuration example of a progress rate database. FIG. 5 is an explanatory diagram of a configuration example of an order exchange rate database. FIG. 6 is an explanatory diagram of a configuration example of an exchange rate master. FIG. 7 is a processing flowchart of sales simulation processing according to the first embodiment. FIG. 8 is an explanatory diagram of the foreign currency sales calculation process. FIG. 9 is an explanatory diagram of the exchange rate calculation process, the Japanese currency sales amount calculation process, and the planned sales amount calculation process for June 2020. FIG. 10 is an explanatory diagram of the exchange rate in September 2020, the Japanese currency sales amount calculation process, and the planned sales amount calculation process. FIG. 11 is an explanatory diagram for calculating the average rate. FIG. 12 is an explanatory diagram of the calculation processing of the final sales (progress rate 100%) in May 2021. FIG. FIG. 13 is a processing flowchart of sales simulation processing according to the second embodiment.

Next, embodiments will be described in detail based on the drawings. In addition, this invention is not limited by this embodiment.

[1] First Embodiment FIG. 1 is a schematic configuration block diagram of a sales simulation device.
The sales simulation device 10 is an application (for example, a web application) that supports sales simulation processing (foreign currency sales calculation processing, exchange rate calculation processing, Japanese currency sales calculation processing, planned sales calculation processing, planned sales data output processing, etc.). is installed as a stationary or portable information processing device (for example, a desktop personal computer, a notebook personal computer, a PDA (Personal Digital Assistant), a smart phone, a tablet personal computer, etc.).

The sales simulation device 10 is communicably connected to an external server 40 (for example, a web server) via a communication network 30 (for example, the Internet, an intranet, a LAN (Local Area Network), etc.).

The sales simulation device 10 includes a control section 11 , a communication interface section 12 , a storage section 13 and an input/output interface section 14 . These units are communicably connected via an arbitrary communication path such as a communication bus.

The control unit 11 is configured as an MPU or the like that controls the sales simulation device 10 in an integrated manner. The control unit 11 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run.

In this case, the control unit 11 functions as a sales simulation means (first creation means) M1, and based on the order data and the progress rate data described later, the control unit 11 calculates the progress rate according to the planned progress rate for each order and for each scheduled sales month. Create sales simulation data (first data) in which planned progress sales are stored.

In addition, the control unit 11 functions as sales schedule data creation means (second creation means) M2, and based on budget data and sales simulation data described later, the progress rate of the schedule, Proceed sales, budget amount considering the planned progress rate (= planned cost), the amount obtained by subtracting the budgeted amount from the planned progress sales (= gross profit), and that amount as the planned progress sales Create sales forecast data (second data) in which the divided amount (=profit rate) is stored.

Further, the control unit 11 functions as an output control means M3 and outputs sales schedule data to the output device 16. FIG.

In addition, the control unit 11 functions as an allocation rate calculation means M4, and calculates an allocation rate for converting a foreign currency-denominated (first currency) order amount into a Japanese currency (second currency-denominated) order amount for each order and for sales. Calculated by scheduled month.
Then, the control unit 11 stores the calculated sales schedule data in the storage unit 13 .

The communication interface unit 12 communicably connects the sales simulation device 10 to the communication network 30 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 12 has a function of communicating data with other devices such as the external server 40 via the communication network 30 .

An input device 15 and an output device 16 are connected to the input/output interface section 14 .
Examples of the input device 15 include a keyboard, a mouse, a microphone, and a touch panel (so-called touch panel display) that realizes a pointing device function for inputting in cooperation with a display.
Examples of the output device 16 include a monitor display (including a home television), a speaker, a printer, and the like.

The storage unit 13 stores various databases, tables, files, and the like. The storage unit 13 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 13, for example, a memory device such as a RAM (Random Access Memory), a ROM (Read Only Memory), an SSD (Solid State Disk), etc., a fixed disk device such as a hard disk, an optical disk, or the like can be used.

The storage unit 13 includes an order database (DB) 13A, a budget database (DB) 13B, a progress rate database (DB) 13C, an order exchange rate database (DB) 13D, and an exchange rate master 13E. .

Specific examples of information stored in the databases 13A to 13D and the exchange rate master 13E will now be described.
In the following explanation, when a contract is made in a foreign currency (US dollar), sales in Japanese currency are recorded on a (construction) percentage-of-completion basis.

First, information stored in the order database 13A will be described.
FIG. 2 is an explanatory diagram of a configuration example of an order reception database.
Information stored in the order database 13A includes order number, order line, date of order, customer, item, currency, order amount in foreign currency, order (exchange) rate, order amount in Japanese currency, and the like.
The order number stores a code for specifying an order item.
The order entry row stores index data for data management indicating the storage location of order entry data.
The order date stores the date of the order received for the corresponding order item.
The customer name stores the name of the customer who placed the order for the relevant order item.
Item stores item information for allowing the person in charge and the customer to easily grasp the contents of the corresponding order item.
As the currency, the name of the currency corresponding to the order amount of the corresponding order item is stored.
The foreign currency order amount stores the amount of the order amount of the corresponding order item denominated in a foreign currency (first currency).
The order rate stores the exchange rate of the corresponding foreign currency at the time of order acceptance.
The Japanese currency order amount stores the order amount denominated in Japanese currency (second currency) calculated by calculating the foreign currency order amount at the exchange rate at the time of the order.

More specifically, as shown in FIG. 2, order number = "J00001", order line = "1", order date = "2020/4/1", customer = "sales destination A", item = " ○○ plant manufacturing/construction", currency = "USD", foreign currency order amount = "$1,000,000.00", order (exchange) rate = "105.00", Japanese order amount = "105,000. 00 (yen)”.

Next, information stored in the budget database (DB) 13B will be described.
FIG. 3 is an explanatory diagram of a configuration example of a budget database.
The information stored in the budget database 13B includes order number, order line, material cost, subcontracting cost, labor cost, expenses, total budget, and the like.
The order number stores a code for specifying an order item.
The order entry row stores index data for data management indicating the storage location of order entry data.
The material cost stores the amount of material cost required to complete the order.
The subcontracting cost stores the amount of the subcontracting cost required to complete the order.
The labor cost stores the amount of labor management costs required to complete the order.
The expense stores the amount of miscellaneous expenses required to complete the order.
The total budget stores the total amount of material costs, subcontract costs, labor costs, and expenses.

More specifically, as shown in FIG. 3, order number=“J00001”, order line=“1”, material cost=“30,000,000 (yen)”, subcontracting cost=“10,000,000” (yen)”, labor cost=“5,000,000 (yen)”, expense=“5,000,000 (yen)”, total budget=“50,000,000 (yen)”.

Next, information stored in the progress rate database (DB) 13C will be described.
FIG. 4 is an explanatory diagram of a configuration example of a progress rate database.
The information stored in the progress rate database 13C includes information used for recording the planned progress sales, such as order number, order line, planned sales month, and planned progress rate.
The order number stores a code for specifying an order item.
The order entry row stores index data for data management indicating the storage location of order entry data.
The scheduled sales month stores information about the month and year when sales are scheduled to be posted on a (construction) progress basis.
The scheduled progress rate stores information on the scheduled progress rate in the scheduled sales month.

More specifically, as shown in the second line (line number=2) of FIG. )”, and the scheduled progress=“40%”.

Next, information stored in the order exchange rate database (DB) 13D will be described.
Data on the hedged rate is stored in this order exchange rate database 13D, and this data is used to calculate the time of sales. The unallocated amount is calculated based on data stored in the exchange rate master 13E, which will be described later.

FIG. 5 is an explanatory diagram of a configuration example of an order exchange rate database.
Information stored in the order exchange rate database 13D includes order number, order line, allocation classification, allocation date, foreign currency allocation amount, allocation (exchange) rate, Japanese currency order amount, and the like.
The order number stores a code for specifying an order item.
The order entry row stores index data for data management indicating the storage location of order entry data.
The allocation classification stores information on the classification of allocation (including information on whether or not allocation has been completed), for example, the allocation status of advance receipt, exchange contract, etc. is stored.
In the date of delivery, information on the date of the date of delivery is stored.
The foreign currency reserve amount stores the planned foreign currency reserve amount on the day of the reserve.
The exchange rate on the date of allocation is stored in the allocation rate.
As the order amount in Japanese currency, the order amount in Japanese currency obtained by converting the foreign currency reserve amount on the date of delivery by the reserve rate and the order amount in foreign currency on the date of delivery is stored.

More specifically, as shown in the second line (line number=2) of FIG. /5/1", foreign currency reserve amount = "$200,000.00", reserve (exchange) rate = "106.00", Japanese currency order amount = "21,200,000 (yen)".

Next, information stored in the exchange rate master 13E will be described.
FIG. 6 is an explanatory diagram of a configuration example of an exchange rate master.
Information stored in the exchange rate master 13E includes currency, (exchange) rate category, application date, (exchange) rate, and the like.
As for currency, types of currency such as Japanese yen and US dollar (USD) are stored.

The rate category stores information indicating whether the exchange rate is a normal exchange rate or a simulated exchange rate based on an exchange rate fluctuation forecast.
The application date stores the date (year and month) when the corresponding exchange rate is applied.
The rate stores normal or simulated exchange rates.

More specifically, as shown in the second line of FIG. )”.

Also, as shown in the fifth line of FIG. 6, currency = "USD", rate category = "1: simulation", application date = "2020/05", rate = "105.00 (yen)". there is

Next, sales simulation processing of the first embodiment will be described.
FIG. 7 is a processing flowchart of sales simulation processing according to the first embodiment.
First, the control unit 11 performs a foreign currency sales calculation process (step S11).

FIG. 8 is an explanatory diagram of the foreign currency sales calculation process.
In this case, the control unit 11 calculates the foreign currency sales amount using the following equation.
Foreign currency sales = Foreign currency order amount x (planned) progress rate - Cumulative foreign currency sales up to the month

For example, in the case of the expected sales month=“2020/06”, the control unit 11 functioning as the sales simulation means M2 refers to the order database 13A, and the foreign currency order amount corresponding to the order number=“J0001”=“$ 1,000,000.00", and with reference to the progress rate database 13C, read out the planned progress rate="20%" corresponding to the expected sales month="2020/06".

As a result of these
Foreign currency sales = $1,000,000.00 x 20% - $0.00
=$200,000.00
becomes.

Similarly, the foreign currency sales amount corresponding to the scheduled sales month=“2020/09” is as follows, as shown in FIG.
Foreign currency sales = $1,000,000.00 x 40% - $200,000.00
=$200,000.00
becomes.

Also, the foreign currency sales amount corresponding to the scheduled sales month=“2020/12” is as follows, as shown in FIG.
Foreign currency sales = $1,000,000.00 x 70% - $400,000.00
= $300,000.00
becomes.

Also, the foreign currency sales amount corresponding to the scheduled sales month=“2021/03” is as follows, as shown in FIG.
Foreign currency sales = $1,000,000.00 x 95% - $700,000.00
=$250,000.00
becomes.

Furthermore, the foreign currency sales amount corresponding to the scheduled sales month=“2021/05” is as follows, as shown in FIG.
Foreign currency sales = $1,000,000.00 x 100% - $950,000.00
= $50,000.00
becomes.

Next, when the foreign currency sales amount calculation process is completed, the control unit 11 refers to the exchange rate master 13E and performs the exchange rate calculation process and the Japanese currency sales amount calculation process (step S12).
Further, when the exchange rate calculation process and the Japanese currency sales amount calculation process are completed, the control unit 11 functions as the sales schedule data creation means M3 and performs the sales schedule calculation process (step S13).

Next, the exchange rate calculation process, the Japanese currency sales amount calculation process, and the planned sales amount calculation process will be described.
FIG. 9 is an explanatory diagram of the exchange rate calculation process, the Japanese currency sales amount calculation process, and the planned sales amount calculation process for June 2020.

In this case, the control unit 11 functions as an allocation rate calculation means, and based on the order exchange data, treats the allocation rate as fixed for information that has been allocated for the corresponding order, and treats information that has not been allocated for the order. , simulated exchange data is obtained from the exchange rate master 13E, and the average (exchange) rate corresponding to the scheduled sales month is calculated as the corresponding allocation rate.

For example, since the information for June 2020 is unallocated, as shown in FIG. Calculate the (exchange) rate and use it as the corresponding reserve rate.

More specifically, as shown in the scheduled sales data 13X1 in FIG. 1,000,000.00".
Here, the average rate is represented by the following equation.
Average rate = Japanese currency reserve amount / Foreign currency reserve amount

Therefore, the average rate for June 2020 is as follows.
Average rate = 105,400,000/1,000,000.00
= 105.40

FIG. 10 is an explanatory diagram of the exchange rate in September 2020, the Japanese currency sales amount calculation process, and the planned sales amount calculation process.
For example, the information for September 2020 is unallocated, so as shown in FIG. Calculate the average (exchange) rate and use it as the appropriate reserve rate.

More specifically, as shown in the sales schedule data 13X2 in FIG. 10, the cumulative amount of the Japanese currency allowance for September 2020 = "106,600,000 (yen)" and the cumulative foreign currency allowance = "$ 1,000,000.00”, the average rate for June 2020 is as follows.
Average rate = 106,600,000/1,000,000.00
= 106.6

Similarly, the average rates for December 2020 and March 2021 are calculated.
FIG. 11 is an explanatory diagram for calculating the average rate.
As shown in FIG. 11, the average rate in December 2020=“103.40” and the average rate in December 2020 and March 2021=“102.60”.

FIG. 12 is an explanatory diagram of the calculation processing of the final sales (progress rate 100%) in May 2021. FIG.
For the final sales (progress rate 100%), from the foreign currency order amount (total amount) calculated using the average rate, recorded until now (recorded before the final sales month) The amount of sales in Japanese currency (June 2020 to March 2021) will be deducted and recorded.

Specifically, as shown in sales schedule data 12X3 in FIG. Cumulative = "$1,000,000.00", so the average rate for May 2021 is as follows.
Average rate = 104,600,000/1,000,000.00
= 104.6

Also, since the initial order amount = "$1,000,000.00" and the average (exchange) rate = 104.60, the final accumulated total is as follows.
Final Cumulative Total = $1,000,000.00 x 104.60
= 104,600,000 (yen)

Therefore, the amount of final sales recorded in May 2021 is as follows: Cumulative total of final sales = "$1,000,000.00" and yen amount recorded so far (recorded before the month of final sales) = "99 , 070,000 (yen)” by the following equation.
Recorded amount of final sales = 104,600,000 (yen) - 99,070,000 (yen)
= 5,530,000 yen

As a result, the control section 11 functions as the output control means M3, and outputs the data shown in the upper part of FIG. 12 from the output device 16 as sales schedule data 12X3 (step S14).

As described above, according to the first embodiment, even when the progress-based sales are adopted for projects received in foreign currency, the future sales schedule can be grasped using the simulated exchange rate. can be made easier.

[2] Second Embodiment In the above first embodiment, sales simulation data denominated in Japanese currency is created for orders denominated in foreign currencies. It is an embodiment for creating sales simulation data.

FIG. 13 is a processing flowchart of sales simulation processing according to the second embodiment.
Since the processing of the second embodiment is like a simplified version of the processing of the first embodiment, only the outline will be described.

First, the control unit 11 performs a Japanese currency sales amount calculation process in the same manner as the foreign currency sales amount calculation process shown in step S11 (step S21).
Next, when the Japanese currency sales amount calculation processing is completed, the control unit 11 functions as sales schedule data creation means M3, and performs the sales schedule calculation processing in the same manner as the procedure shown in step S13 (step S22). ).

As a result, the control unit 11 functions as the output control means M3, and outputs the sales schedule data 12X3 shown in the upper part of the sales schedule data FIG. 12 from the output device 16 (step S23).
As described above, according to the second embodiment, it is possible to easily comprehend the future sales schedule even in cases where progress-based sales are used for orders received in Japanese currency.

[3. Contribution to the Sustainable Development Goals (SDGs) led by the United Nations]
The above-described embodiment can contribute to improving operational efficiency and promoting appropriate management decisions of companies, and thus can contribute to Goals 8 and 9 of the SDGs.

In addition, the above-described embodiment can contribute to the reduction of disposal loss and the promotion of paperless/electronic use, so it is possible to contribute to goals 12, 13, and 15 of the SDGs.

In addition, the above-described embodiment can contribute to the strengthening of control and governance, so it is possible to contribute to Goal 16 of the SDGs.

In addition, although the embodiments have been described above, various other embodiments may be implemented within the scope of the technical ideas described in the claims, other than the embodiments described above.

For example, in the above-described first embodiment, the sales forecast was performed in Japanese currency, which is the second currency, for orders received in foreign currency, which is the first currency. The same can be applied to the case where both are in foreign currency.

Further, among the processes described in the above-described embodiments, all or part of the processes described as being performed automatically can be performed manually, or the processes described as being performed manually can be performed manually. can also be performed 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 the above documents and drawings can be changed arbitrarily.

Also, with respect to the sales simulation device 10, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions of the sales simulation device 10, particularly the processing functions performed in the control unit 11, may be realized in whole or in part by an MPU and a program interpreted and executed by the MP. , or may be implemented as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing a so-called information processing device to execute the revenue recognition method according to the present invention, and if necessary, the sales simulation device. 10 mechanically read. That is, the storage unit 13 or the like such as ROM or HDD (Hard Disk Drive) stores computer programs for giving commands to the CPU in cooperation with the OS and performing various processes. This computer program is executed by being loaded into the RAM, and cooperates with the MPU to configure the control section.

Further, this computer program may be stored in an external server 40 connected to the sales simulation apparatus 10 via the communication network 30, and all or part of it can be downloaded as necessary. be.

Further, the sales simulation program according to the present invention may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" includes memory cards, USB (Universal Serial Bus) memories, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and any Blu-ray (registered trademark) "Disc physical media for transportation”.

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

The various databases and the like stored in the storage unit 13 are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks. programs, tables, databases, and files for web pages. Similarly, it is also possible to configure the external server 40 to have the function of the storage unit 13 .

The sales simulation device 10 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. Moreover, the sales simulation device 10 may be realized by installing software (including programs or data, etc.) for realizing the product information management method of the present invention in the information processing device.

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

INDUSTRIAL APPLICABILITY The present invention is useful in business types and industries that employ the progress-based sales system as a sales recording method.

10 sales simulation device 11 control unit 12 communication interface unit 13 storage unit 13A order database 13B budget database 13C progress rate database 13D order exchange rate database 13E exchange rate master 13X1 to 13X3 sales schedule data 14 input/output interface unit 15 input device 16 output device 30 communication network 40 external server M1 sales simulation means (first creation means)
M2 Sales schedule data creation means (second creation means)
M3 Output control means M4 Allocation rate calculation means

Claims (6)

A sales simulation device comprising a control unit and a storage unit,
The storage unit
Order data for managing the amount of orders received for each contract to which the percentage-of-completion method is applied;
Progress rate data for managing the progress rate of the schedule for each order and for each month of scheduled sales;
budget data for managing the budget amount for the contract target for each order;
and store
The control unit
a first creation means for creating first data storing planned progress sales according to the progress rate of the plan for each order and for each month of planned sales, based on the order data and the progress rate data;
Based on the budget data and the first data, for each order and for each month of scheduled sales, the following a second creation means for creating second data storing the amount obtained by subtracting the budget amount and the amount obtained by dividing the amount by the scheduled progress sales;
output control means for outputting the second data to an output device;
to provide
A sales simulation device characterized by: the order amount is denominated in a first currency;
Equipped with an allocation rate calculation means for calculating an allocation rate for each order and for each scheduled sales month,
The first creation means further creates the first data denominated in a second currency in consideration of the reserve rate.
The sales simulation device according to claim 1, characterized by: The storage unit stores fixed order exchange data for each order,
The allocation rate calculation means treats the allocation rate as a fixed amount for the information that has been allocated for the corresponding order based on the fixed order exchange data,
For unallocated information, obtain simulated exchange data from the rate master, calculate the average exchange rate corresponding to the scheduled sales month, and use it as the corresponding allocation rate.
3. The sales simulation device according to claim 2, characterized by: For the final sales, the control unit subtracts the sales recorded before the final sales scheduled month from the progress sales calculated using the average rate for the order amount. account for
4. The sales simulation device according to any one of claims 1 to 3, characterized in that: A sales simulation method executed in a sales simulation device, comprising:
Based on the order data that manages the order amount of the contract subject to which the construction progress standard is applied for each order and the progress rate data that manages the scheduled progress rate by order and sales month, a step of creating first data in which a planned progress sales amount according to a planned progress rate is stored;
Based on the budget data for managing the budget amount for the contract object for each order and the first data, the planned progress rate, the planned progress sales, and the planned progress rate are added for each order and for each month of planned sales. creating second data storing a budget amount, an amount obtained by subtracting the budgeted amount from the planned progress sales, and an amount obtained by dividing the budget by the planned progress sales;
outputting the second data to an output device;
A sales simulation method comprising: Order data for managing the order amount of the contract target to which the construction progress standard is applied for each order, progress rate data for managing the scheduled progress rate for each order and for each month of scheduled sales, and for each order received A sales simulation program for controlling, by a computer, a sales simulation device comprising a storage unit for storing budget data for managing the budget amount for
said computer,
a first creating means for creating first data storing planned progress sales according to the planned progress rate for each order received and for each planned sales month, based on the order data and the progress rate data;
Based on the budget data and the first data, for each order and for each month of scheduled sales, the following a second creation means for creating second data storing the amount obtained by subtracting the budget amount and the amount obtained by dividing the amount by the scheduled progress sales;
output control means for outputting the second data to an output device;
A sales simulation program characterized by functioning as

Images