Income and expenditure simulation device, income and expenditure simulation method, and income and expenditure simulation program

Abstract

To provide an income and expenditure simulation device, a method and a program that generates information for selecting a supplier so as to maximize profit of a purchaser.SOLUTION: An income and expenditure simulation device, which can access supplier-specific unit price information where a product code, a supplier code, and a product unit price are associated with each other, includes a display unit and a control unit that simulates a balance of income and expenditure when an ordered product is procured from each of a plurality of suppliers. The control unit generates income / expense simulation information for each supplier, including a supplier code, a product code, and a purchase unit price, by performing a simulation on the basis of supplier-specific unit price information, and executes unit price priority display processing for displaying a generated simulation image including the income and expenditure simulation information for each supplier on the display unit in a list in order of priority, so that a supplier with a lowest unit price is given a higher priority for display and a supplier with the highest unit price is given a lower priority for display.SELECTED DRAWING: Figure 2

Description

[Technical Field]

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

[0002] Conventionally, there is known a unit price management device for managing different sales prices and purchase prices for each supplier (see, for example, Patent Document 1). The unit price management device of Patent Document 1 acquires a set unit price from multiple input items based on a general-purpose unit price master that associates multiple items with set unit prices, in accordance with a condition specification master that associates unit price categories that indicate the type of unit price with the priorities of multiple items related to the unit price. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Application Publication No. 2020-106996 Summary of the Invention [Problem to be solved by the invention]

[0004] However, suppliers are currently selecting suppliers based on human judgment. Since there are no selection criteria for suppliers when selecting from multiple suppliers, it has been difficult to determine which supplier will maximize the supplier's profits.

[0005] The present invention has been made in consideration of the above-mentioned problems, and aims to provide an income / expense simulation device, an income / expense simulation method, and an income / expense simulation program that can provide information for selecting suppliers so as to maximize the supplier's profits. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the income and expenditure simulation device of the present invention comprises a display unit and a control unit that executes a simulation process of income and expenditure when products ordered by an ordering party are procured from each of a plurality of suppliers, and is capable of accessing supplier-specific unit price information in which product codes for identifying the products, supplier codes for identifying the suppliers, and unit purchase prices of the products are respectively associated with each other, and the control unit executes the simulation process based on the supplier-specific unit price information to generate income and expenditure simulation information for each supplier, including the supplier code, product code, and unit purchase price, and displays a simulation image on the display unit that includes the generated income and expenditure simulation information for each supplier, and executes a unit purchase price priority display process in which the income and expenditure simulation information for each supplier is displayed in a list in order on the simulation image, so that suppliers with lower unit purchase prices are given higher display priority and suppliers with higher unit purchase prices are given lower display priority.

[0007] In addition, in the income and expenditure simulation device of the present invention, the supplier-specific unit price information further includes a supplier code for identifying the supplier of the orderer and a lead time for delivery of the product, and is capable of accessing priority information for each supplier in which the supplier code is associated with a priority flag for selecting whether to prioritize display based on the supplier unit price or display based on the lead time, and when the control unit determines based on the supplier-specific priority information that priority is to be given to display based on the supplier unit price, it executes the supplier unit price priority display process, and when it determines based on the supplier-specific priority information that priority is to be given to display based on the lead time, it executes lead time priority display process in which the income and expenditure simulation information for each supplier is displayed in a list in order on the simulation image so that suppliers with shorter lead times have higher display priority and suppliers with longer lead times have lower display priority.

[0008] In the income and expenditure simulation device according to the present invention, the income and expenditure simulation information may include at least one of a scheduled date of purchase from the supplier, a scheduled date of collection from the ordering party, and a scheduled date of payment to the supplier.

[0009] Furthermore, the income and expenditure simulation method of the present invention is a method for executing an income and expenditure simulation process for procuring products ordered by an ordering party from multiple suppliers, in which supplier-specific unit price information is used, in which a product code for identifying the product, a supplier code for identifying the supplier, and the product unit price are respectively associated with each other, and the simulation process is executed based on the supplier-specific unit price information to generate income and expenditure simulation information for each supplier, including the supplier code, the product code, and the unit price, and a simulation image including the generated income and expenditure simulation information for each supplier is displayed on a display unit, and a purchase price priority display process is executed by an income and expenditure simulation device equipped with a control unit to display the income and expenditure simulation information for each supplier in a list in order on the simulation image, so that suppliers with lower purchase unit prices are given higher display priority and suppliers with higher purchase unit prices are given lower display priority.

[0010] Furthermore, the income and expenditure simulation program of the present invention is an income and expenditure simulation program that causes an income and expenditure simulation device having a display unit and a control unit to execute an income and expenditure simulation method that performs an income and expenditure simulation process when products ordered by an ordering party are procured from each of a plurality of suppliers, and uses supplier-specific unit price information in which a product code for identifying the product, a supplier code for identifying the supplier, and the product unit price are respectively associated with each other, and causes the income and expenditure simulation device to execute the following steps: generate income and expenditure simulation information for each supplier including the supplier code, the product code, and the unit price by executing the simulation process based on the supplier-specific unit price information; display a simulation image on the display unit that includes the generated income and expenditure simulation information for each supplier; and execute a purchase price priority display process in which the income and expenditure simulation information for each supplier is displayed in a list in order on the simulation image, so that the supplier with the lowest purchase unit price has a higher display priority and the supplier with the highest purchase unit price has a lower display priority. [Effects of the Invention]

[0011] The present invention has an effect of being able to provide information for selecting a supplier so as to maximize the supplier's profits. [Brief explanation of the drawings]

[0012] [Figure 1] FIG. 1 is a diagram showing the flow of an order placement and receipt process for product procurement at a supplier. [Figure 2] FIG. 2 is a diagram illustrating an example of the configuration of the income and expenditure simulation device. [Figure 3] FIG. 3 is a diagram showing an example of various data. [Figure 4] FIG. 4 is a diagram illustrating an example of the income and expenditure simulation data. [Figure 5] FIG. 5 is a diagram showing reference data for each item of the income and expenditure simulation data. [Figure 6] FIG. 6 is a diagram showing an example of a simulation image. [Figure 7] FIG. 7 is a diagram showing an example of a simulation image. [Figure 8] FIG. 8 is a diagram relating to updating of received order data and order data. [Figure 9] FIG. 9 is a diagram showing an example of the received order data and the order data after updating. DETAILED DESCRIPTION OF THE INVENTION

[0013] Hereinafter, embodiments of a balance simulation device, a balance simulation method, and a balance simulation 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.

[0014] [1. Configuration] An example of the configuration of the income and expenditure simulation device 100 according to this embodiment will be described with reference to FIG. 2 etc. Prior to describing the income and expenditure simulation device 100, an order placement and receiving operation related to product procurement at a supplier, in which the income and expenditure simulation device 100 is used, will be described. FIG. 1 is a diagram showing a flow of the order placement and receiving operation related to product procurement at a supplier. FIG. 2 is a diagram showing an example of the configuration of the income and expenditure simulation device.

[0015] As shown in Fig. 1, in an order placement and receipt business, the ordering party issues an order form and sends the issued order form to the order recipient, thereby placing an order for a product from the ordering party to the order recipient (step S1). When the order recipient receives the order form, it uses the order receiving terminal 10 to input the order based on the order form, and order data and order data are generated (step S2). Therefore, the order receiving terminal 10 generates the order data and order data as generated data (step S3). The order data and order data generated by the order receiving terminal 10 can be generated as temporary data.

[0016] When the order data and order placement data are generated in step S2, a simulation process is executed using the income and expenditure simulation device 100 based on the generated order data and order placement data, and order placement data and order placement data are generated as simulation results (step S4). The simulation results are shared between the order placement department and the accounting department of the order originator. The income and expenditure simulation device 100 generates order placement data and order placement data as generated data (step S5), and updates (replaces) the order placement data and order placement data generated in step S3. After step S4 is executed, a purchase order is issued based on the generated order placement data, and the issued purchase order is sent to the supplier (step S6).

[0017] Next, the income and expenditure simulation device 100 will be described. The income and expenditure simulation device 100 executes a simulation process of income and expenditure when products ordered by an ordering party are procured from a plurality of suppliers. The income and expenditure simulation device 100 is constructed based on a commercially available desktop personal computer. Note that the income and expenditure simulation 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.

[0018] The balance simulation 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 balance simulation device 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0019] The communication interface unit 104 communicably connects the balance simulation 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 balance simulation device 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). The data stored in the storage unit 106 may also be stored in the server 200, for example.

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

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

[0022] The storage unit 106 stores order data 106a, order data 106b, customer / billing destination master 106c, supplier / payment destination master 106d, supplier-specific unit price lead time master 106e, delivery destination master 106f, and supplier-specific balance simulation data (balance simulation data) 106g.

[0023] FIG. 3 is a diagram showing an example of various types of data. The order data 106a includes items such as order number, order line number, shipping date, delivery date, expected sales date, customer, delivery destination, product, quantity, sales price, sales amount, gross profit amount, and expected collection date, and these pieces of information are associated with each other. The order number is an identification number for the order transaction. The order line number is a number attached to the beginning of a line, and is, for example, a number indicating a predetermined label. The shipping date is the date on which the product is shipped. The delivery date is the date on which the product is delivered. The expected sales date is the date on which sales are scheduled to be recorded. The customer is the identification code of the customer who placed the order. The delivery destination is the identification code (delivery destination code) of the customer's delivery destination. The product is the identification code (product code) of the product. The quantity is the quantity of the product. The sales price is the unit price of the product at the time of sale. The sales amount is the amount obtained by multiplying the sales price by the quantity. The gross profit amount is the amount obtained by subtracting the purchase price from the sales amount. The scheduled collection date is the date on which the sales amount is scheduled to be collected from the order source.

[0024] The order data 106b includes the following fields: order number, order line number, planned purchase date, supplier, product, quantity, purchase price, purchase amount, provisional unit price flag, and planned payment date, and these pieces of information are associated with each other. The order number is an identification number for the order transaction. The order line number is a number attached to the beginning of a line, and is, for example, a number indicating a specified label. The planned purchase date is the date on which the product is planned to be purchased. The supplier is the supplier's identification code (supplier code). The product and quantity are the same as those in the order data 106a. The purchase price is the unit price at the time of purchase of the product. The purchase amount is the amount obtained by multiplying the purchase price by the quantity. The provisional unit price flag is a flag that identifies whether the order data is subject to the execution of an income / expense simulation process. If an income / expense simulation is to be executed, it is set to "TRUE," and if an income / expense simulation is not to be executed, it is set to "FALSE." The planned payment date is the date on which payment to the supplier is planned.

[0025] The customer / billing destination master 106c includes the fields of customer, sales accounting standard, billing destination, closing date, collection month, and collection date, and these pieces of information are associated with each other. The customer is the same as the order data 106a. The sales accounting standard is the standard by which the order recipient records the sales amount. The billing destination is a code that identifies the billing destination for the order originator. The closing date is the closing date for billing the sales amount set by the order originator, for example, the end of the month. The collection month is the month in which the sales amount is scheduled to be collected from the order originator. The collection date is the day in which the sales amount is scheduled to be collected from the order originator.

[0026] The supplier / payment destination master 106d includes the fields of supplier, purchase accounting standard, billing destination, closing date, payment month, and payment date, and these pieces of information are associated with each other. The supplier is the same as the order data 106b. The purchase accounting standard is the standard by which the supplier accounts for the purchase amount. The billing destination is a code that identifies the billing destination for the supplier. The closing date is the closing date for billing the purchase amount set by the supplier, for example, the end of the month. The payment month is the month in which the purchase amount is scheduled to be paid to the supplier. The payment date is the day in which the purchase amount is scheduled to be paid to the supplier.

[0027] The supplier-specific unit price lead time master 106e includes the following items: customer code, delivery destination code, product code, supplier code, unit purchase price, and delivery lead time, and these items are associated with each other. The customer code, delivery destination code, product code, supplier code, and unit purchase price are the same as the customer, delivery destination, product, supplier, and unit purchase price in the order data 106a and the order data 106b. The delivery lead time is the number of days it takes for the product to arrive from the supplier to the orderer.

[0028] The delivery destination master 106f includes items for delivery destination code and priority flag, and these pieces of information are associated with each other. The delivery destination code is the same as in the supplier-specific unit price lead time master 106e. The priority flag is a flag that selects whether to prioritize the purchase unit price or the delivery lead time when executing the simulation process in the income / expense simulation. Specifically, if the priority flag is "0," the simulation process prioritizes the purchase unit price, and if the priority flag is "1," the simulation process prioritizes the delivery lead time.

[0029] FIG. 4 is a diagram showing an example of supplier-specific balance simulation data. The supplier-specific balance simulation data 106g is data generated by executing a simulation process based on the various data shown in FIG. 3. The supplier-specific balance simulation data 106g includes items such as order number, order line number, purchase order number, purchase line number, supplier, customer, delivery destination, shipping date, delivery lead time, scheduled delivery date, scheduled sales date, and scheduled purchase date, and these pieces of information are associated with each other. The supplier-specific balance simulation data 106g also includes items such as product, quantity, unit sales price, sales amount, unit purchase price, purchase amount, gross profit amount, gross profit rate, scheduled collection date, and scheduled payment date, and these pieces of information are associated with each other.

[0030] FIG. 5 shows the reference data for each item in the income / expense simulation data. As shown in the reference data in FIG. 5, each item in the supplier-specific income / expense simulation data 106g is obtained based on the various data shown in FIG. 3. The order number, order line number, purchase order number, order line number, order line number, purchase order number, order line number, supplier, customer, delivery destination, shipping date, and delivery lead time are obtained from the order data 106a, order data 106b, and supplier-specific unit price lead time master data 106e. The scheduled delivery date is generated by adding the delivery lead time in the supplier-specific unit price lead time master data 106e to the shipping date in the order data 106a. The scheduled sales date is calculated based on the shipping date, delivery date (scheduled delivery date), etc. in the order data 106a, based on the sales accounting criteria in the customer / billing destination master data 106c. The scheduled purchase date is calculated from the shipping date, delivery date (scheduled delivery date), etc., based on the purchase accounting standards in the supplier / payment destination master 106d. The product, quantity, unit sales price, sales amount, unit purchase price, purchase amount, and gross profit amount are obtained from the respective items in the order data 106a, order data 106b, and supplier-specific unit price lead time master 106e. The gross profit rate is the gross profit amount divided by the sales amount, expressed as a percentage, and is rounded off. The scheduled collection date is calculated from the scheduled sales date in the order data 106a, with reference to the closing date, collection month, and collection date in the customer / billing destination master 106c. The scheduled payment date is calculated from the scheduled purchase date in the order data 106b, with reference to the closing date, payment month, and payment date in the supplier / payment destination master 106d.

[0031] Next, the control unit 102 will be described with reference to Fig. 2 again. The control unit 102 is a CPU or the like that performs overall control of the balance simulation 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 processes based on these stored programs.

[0032] As information processing, the control unit 102 executes a simulation process of income and expenditure for each supplier based on various data stored in the storage unit 106.

[0033] A specific example of the processing executed by the control unit 102 will be described in detail below in [2. Specific Example of Processing].

[0034] [2. Specific examples of processing] Here, specific examples of processing executed by the balance simulation device 100 will be described with reference to Figs. 4 to 8. Figs. 6 and 7 are diagrams showing examples of simulation images. Fig. 8 is a diagram relating to updating of order data and purchase order data. The balance simulation device 100 executes a balance simulation process.

[0035] In the simulation process, the control unit 102 generates the income and expenditure simulation data shown in FIG. 5 based on the various data in FIG. 3, and displays the income and expenditure simulation data on the output device (hereinafter also referred to as the display unit) 500. Specifically, the control unit 102 acquires the provisional unit price flag item of the order data 106b and determines whether or not to execute the simulation process. If the provisional unit price flag of the order data 106b is "TRUE," the control unit 102 executes the simulation process. On the other hand, if the provisional unit price flag of the order data 106b is "FALSE," the control unit 102 does not execute the simulation process.

[0036] When the control unit 102 determines to execute the simulation process, it executes the data processing shown in FIG. 5 based on the order data 106a, the order data 106b, the customer / billing destination master 106c, the supplier / payment destination master 106d, the supplier-specific unit price lead time master 106e, and the delivery destination master 106f, thereby generating the supplier-specific income / expense simulation data 106g shown in FIG. 4.

[0037] Thereafter, the control unit 102 causes the display unit 500 to display simulation images D1 and D2 containing the supplier-specific balance simulation data 106g, as shown in FIGS. 6 and 7. The simulation image D1 shown in FIG. 6 and the simulation image D2 shown in FIG. 7 display the supplier-specific balance simulation data 106g side by side. The supplier-specific balance simulation data 106g are displayed side by side in correspondence with the order number. The control unit 102 then arranges the display order of the supplier-specific balance simulation data 106g based on the delivery destination master 106f. When the priority flag is "0," the control unit 102 executes a purchase price priority display process to display the supplier-specific balance simulation data 106g in a list in order on the simulation images D1 and D2, so that suppliers with lower unit prices are displayed at higher priority (upper side of the figure) and suppliers with higher unit prices are displayed at lower priority (lower side of the figure). On the other hand, when the priority flag is "1", the control unit 102 executes a lead time priority display process in which the supplier-specific income / expense simulation data 106g for each supplier is displayed in a list in order on the simulation images D1 and D2 so that suppliers with shorter delivery lead times are given higher display priority and suppliers with longer delivery lead times are given lower display priority.

[0038] In addition to displaying according to the delivery destination master 106f, the control unit 102 can also execute purchase price priority display processing and lead time priority display processing for all order numbers. As shown in Figures 6 and 7, the control unit 102 displays, in simulation images D1 and D2, an operation button 121a for executing display processing according to the delivery destination master 106f, an operation button 121b for executing purchase price priority display processing for all order numbers, and an operation button 121c for executing lead time priority display processing for all order numbers. In response to the operation button 121a, 121b, or 121c that has been operated, the control unit 102 executes display processing corresponding to the operation button 121a, 121b, or 121c.

[0039] 8 is a diagram related to updating of the order data and the order placement data. After the simulation images D1 and D2 are displayed and a predetermined supplier is selected, the control unit 102 updates the order data 106a and the order placement data 106b based on the selected supplier (step S5 in FIG. 1).

[0040] As shown in Figure 8, the information updated in the order data 106a is the delivery date, expected sales date, gross profit amount, and expected collection date. The information updated in the order data 106b is the expected purchase date, supplier, purchase price, purchase amount, provisional price flag, and expected payment date. The provisional price flag is updated to "FALSE" so that the updated order data 106b is not subject to a balance sheet simulation.

[0041] 9 is a diagram showing an example of updated received order data and order placement data. The control unit 102 arranges updated received order data 106a corresponding to multiple order numbers and displays a list on the display unit 500. The control unit 102 also arranges updated order placement data 106b corresponding to multiple order numbers and displays a list on the display unit 500. In this way, the control unit 102 provides information related to the updated received order data 106a and order placement data 106b.

[0042] As described above, according to this embodiment, the control unit 102 can execute a purchase price priority display process based on the purchase price and display the simulation images D1 and D2 on the display unit 500. This makes it possible to provide information for selecting a supplier so that the supplier's profits can be maximized.

[0043] Furthermore, according to this embodiment, the control unit 102 can execute a lead time priority display process based on the delivery lead time and display the simulation images D1 and D2 on the display unit 500. This makes it possible to provide information for selecting a supplier so that the delivery of the product to the order destination (delivery destination) can be achieved taking the delivery lead time into consideration.

[0044] Furthermore, according to this embodiment, the supplier-specific income / expense simulation data 106g includes at least one of the planned purchase date, planned collection date, and planned payment date, which makes it easier for the accounting department of the supplier to predict income / expenses, thereby contributing to the stability of the supplier's management.

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

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

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

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

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

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

[0051] Furthermore, with regard to the income and expenditure simulation 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.

[0052] For example, all or any part of the processing functions of the balance simulation 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 balance simulation device 100 as needed. That is, a computer program for providing instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with the CPU to form the control unit.

[0053] This computer program may also be stored in an application program server connected to the income and expenditure simulation device 100 via any network, and all or part of it may be downloaded as needed.

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

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

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

[0057] The income and expenditure simulation 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 income and expenditure simulation device 100 may be realized by installing software (including programs, data, etc.) that causes the device to perform the processing described in this embodiment.

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

[0059] The present invention is useful in industries that trade goods, such as chemicals, trading companies, and distribution retailers. [Explanation of symbols]

[0060] 100 Income and Expenditure Simulation Device 102 Control section 104 Communication interface unit 106 Storage section 106a Order Data 106b Order Data 106c Customer / Billing Master 106d Supplier / Payment Master 106e Supplier-specific unit price lead time master 106f Delivery destination master 106g Supplier-specific income / expense simulation data 108 Input / Output Interface Section 400 Input Device 500 output devices 200 servers 300 Network

Claims

1. A display unit; a control unit that executes a simulation process of income and expenditure when products ordered by an order source are procured from a plurality of suppliers, supplier-specific unit price information in which a product code for identifying the product, a supplier code for identifying the supplier, and a purchase unit price of the product are associated with each other; order data in which an order number, which is an identification number of an order to be placed with the supplier, and a purchase price of the product are associated with each other; The system is capable of accessing order data in which an order number, which is an identification number of an order received from the order source, a sales amount of the product, and a gross profit amount obtained by subtracting the purchase amount from the sales amount are associated with each other, The control unit executing the simulation process based on the supplier-specific unit price information, the order data, and the order receipt data, to generate income and expenditure simulation information for each supplier, including the supplier code, the product code, the purchase price, the gross profit amount, and a gross profit rate calculated from the gross profit amount; displaying a simulation image including the generated balance simulation information for each supplier on the display unit; An income / expense simulation device that executes a purchase unit price priority display process that displays the income / expense simulation information for each supplier in a list in order so that on the simulation image, the supplier with the lowest purchase unit price is given a higher display priority and the supplier with the highest purchase unit price is given a lower display priority.

2. The income and expenditure simulation information includes the order number, The control unit 2. The income and expenditure simulation device according to claim 1, wherein a plurality of pieces of the income and expenditure simulation information are displayed on the simulation image in a line corresponding to the order numbers.

3. The supplier-specific unit price information further includes a delivery destination code for identifying the delivery destination of the order source and a delivery lead time of the product, The system is capable of accessing priority information by delivery destination in which the delivery destination code and a priority flag for selecting whether to prioritize the display based on the purchase unit price or the display based on the lead time are associated with each other, The control unit When it is determined that the display based on the purchase unit price is to be prioritized based on the priority information by delivery destination, the purchase unit price priority display process is executed; 2. The income / expense simulation device according to claim 1, wherein when it is determined based on the priority information by delivery destination that display based on the lead time is to be prioritized, a lead time priority display process is executed to display the income / expense simulation information for each supplier in a list in order so that the supplier with the shortest lead time is given a higher display priority and the supplier with the longest lead time is given a lower display priority on the simulation image.

4. 2. The income and expenditure simulation device according to claim 1, wherein the income and expenditure simulation information includes a scheduled date of purchase from the supplier, a scheduled date of collection from the ordering party, and a scheduled date of payment to the supplier.

5. A balance simulation method for executing a balance simulation process when products ordered by an ordering party are procured from a plurality of suppliers, the method comprising: supplier-specific unit price information in which a product code for identifying the product, a supplier code for identifying the supplier, and a purchase unit price of the product are associated with each other; order data in which an order number, which is an identification number of an order to be placed with the supplier, and a purchase price of the product are associated with each other; order data in which an order number, which is an identification number of an order received from the order source, a sales amount of the product, and a gross profit amount obtained by subtracting the purchase amount from the sales amount are associated with each other are used; executing the simulation process based on the supplier-specific unit price information, the order data, and the order receipt data, to generate income and expenditure simulation information for each supplier, including the supplier code, the product code, the purchase price, the gross profit amount, and a gross profit rate calculated from the gross profit amount; displaying a simulation image including the generated balance simulation information for each supplier on a display unit; An income / expense simulation method in which an income / expense simulation device having a control unit executes a purchase price priority display process to display the income / expense simulation information for each supplier in a list in order so that on the simulation image, the supplier with the lowest purchase price is given a higher display priority and the supplier with the highest purchase price is given a lower display priority.

6. A balance simulation program that causes a balance simulation device having a display unit and a control unit to execute a balance simulation method for executing a balance simulation process when products ordered by an orderer are procured from a plurality of suppliers, the program comprising: supplier-specific unit price information in which a product code for identifying the product, a supplier code for identifying the supplier, and a purchase unit price of the product are associated with each other; order data in which an order number, which is an identification number of an order to be placed with the supplier, and a purchase price of the product are associated with each other; order data in which an order number, which is an identification number of an order received from the order source, a sales amount of the product, and a gross profit amount obtained by subtracting the purchase amount from the sales amount are associated with each other are used; executing the simulation process based on the supplier-specific unit price information, the order data, and the order receipt data, to generate income and expenditure simulation information for each supplier, including the supplier code, the product code, the purchase price, the gross profit amount, and a gross profit rate calculated from the gross profit amount; displaying a simulation image including the generated balance simulation information for each supplier on a display unit; The income and expenditure simulation program causes the income and expenditure simulation device to execute a purchase price priority display process that displays the income and expenditure simulation information for each supplier in a list in order so that on the simulation image, the supplier with the lowest purchase price is given a higher display priority and the supplier with the highest purchase price is given a lower display priority.

Images