JP7618498B2 - Fuel oil sales unit price management device, fuel oil sales unit price management method, and fuel oil sales unit price management program - Google Patents

Description

The present invention relates to a fuel oil sales price management device, a fuel oil sales price management method, and a fuel oil sales price management program.

Patent Document 1 discloses a configuration in which, when leasing or renting an automobile for a price that includes the price of gasoline, a monthly fuel supply price is calculated by multiplying the fuel price held by the Agency for Natural Resources and Energy at the time the contract begins by the monthly fuel supply amount, and the difference between the monthly fuel supply price and the estimated monthly fuel cost is refunded to the fuel wholesaler or fuel retailer.

JP 2017-188042 A

However, the invention described in the above Patent Document 1 uses a monthly fuel unit price and calculates the fuel supply price for that month, which means that it is not possible to set a sales price that corresponds to fluctuations in market unit prices in fuel oil trading that occur each time due to fluctuations in crude oil prices.

The present invention has been made in consideration of the above problems, and aims to provide a fuel oil sales unit price management device, a fuel oil sales unit price management method, and a fuel oil sales unit price management program that can automatically calculate customer sales unit prices by registering unit price increases and decreases for each customer using the market unit price for each region announced weekly by the Agency for Natural Resources and Energy as the base unit price.

In order to solve the above-mentioned problems and achieve the object, the fuel oil sales unit price management device of the present invention is a fuel oil sales unit price management device equipped with a memory unit and a control unit, the memory unit is equipped with a business partner memory means for storing a business partner master set by linking the business partner's region and the week of the month in which the unit price of fuel oil trading is adopted, a market unit price means for storing a market unit price master set by linking the fuel oil product type, the region, the market unit price of the fuel oil, and the week, and a sales memory means for storing sales data set by linking the business partner, sales date, sold product, and sales quantity, and the control unit is equipped with a unit price difference acquisition means for acquiring a unit price difference, which is the difference between the sales unit price of the product sold to the business partner and the market unit price, and a sales unit price acquisition means for acquiring the sales unit price of the product sold for each business partner based on the business partner master, the market unit price master, the sales data, and the unit price difference.

In the fuel oil sales price management device according to the present invention, the control unit is further characterized by having a sales amount acquisition means for acquiring the sales amount of the product sold to the business partner based on the sales data and the sales price.

In addition, in the fuel oil sales price management device according to the present invention, the sales amount acquisition means is further characterized in that it displays sales price simulation table data in which the sales department, the business partner, the sales date, the sold product, the sales quantity, and the sales amount are set.

In addition, in the fuel oil sales price management device according to the present invention, the sales amount acquisition means is further characterized in that it displays the monthly total sales quantity and monthly total sales amount of each of the sales products for each sales department based on the sales price simulation table data.

In addition, in the fuel oil sales unit price management device according to the present invention, the unit price difference acquisition means is further characterized in that, when the unit price difference of the product sold to the business partner is input, the unit price difference and a record that sets the approval status of unapproved are set in the unit price application approval master.

In addition, in the fuel oil sales price management device according to the present invention, the unit price difference acquisition means is further characterized in that, when an approval instruction for the unit price difference is input, the approval status of the record set in the unit price application approval master is updated from unapproved to approved.

In addition, in the fuel oil sales price management device according to the present invention, the sales price acquisition means acquires the sales price of the sold product for each supplier by adding the unit price difference to the market unit price for the supplier's region in the week set in the supplier master for the month including the sales date, based on the supplier master, the market unit price master, the sales data, and the unit price difference.

The fuel oil sales unit price management method according to the present invention is a fuel oil sales unit price management method to be executed by a fuel oil sales unit price management device having a memory unit and a control unit, the memory unit being equipped with a customer memory means for storing a customer master set by linking the customer's region and the week of the month in which the unit price of fuel oil trading is adopted, a market price unit means for storing a market price master set by linking the fuel oil product type, the region, the market price of the fuel oil, and the week, and a sales memory means for storing sales data set by linking the customer, the sales date, the sold product, and the sales quantity, and is characterized by including a unit price difference acquisition step executed by the control unit to acquire a unit price difference, which is the difference between the sales unit price of the product sold to the customer and the market price, and a sales unit price acquisition step for acquiring the sales unit price of the product sold for each customer based on the customer master, the market price master, the sales data, and the unit price difference.

The fuel oil sales unit price management program according to the present invention is a fuel oil sales unit price management program to be executed by a fuel oil sales unit price management device having a storage unit and a control unit, the storage unit being provided with a customer storage means for storing a customer master set by linking the customer's region and the week of the month in which the unit price of fuel oil trading is adopted, a market price means for storing a market price master set by linking the fuel oil product type, the region, the market price of the fuel oil, and the week, and a sales storage means for storing sales data set by linking the customer, the sales date, the sold product, and the sales quantity, and is characterized in that the control unit executes a unit price difference acquisition step for acquiring a unit price difference, which is the difference between the sales unit price of the product sold to the customer and the market price, and a sales unit price acquisition step for acquiring the sales unit price of the product sold for each customer based on the customer master, the market price master, the sales data, and the unit price difference.

According to the present invention, the automatic calculation of unit prices can improve the efficiency of the work involved in the decision-making process, shorten the time required, and confirm the sales results in real time after the unit price is decided. In addition, according to the present invention, the department manager can set a unit price strategy for the following month, which was previously only possible based on the sales results, and instructions can be given to sales staff one month earlier, which enables management decisions to be made earlier. In addition, according to the present invention, the sales results can be calculated on a report by multiplying the sales quantity by the latest unit price in the master and displayed by department. In addition, according to the present invention, a mechanism can be provided that can reflect predicted unit prices in addition to the unit prices announced by the Agency for Natural Resources and Energy. In addition, in businesses that are dependent on market unit prices such as fuel oil, it was only possible to track the results by quantity until the closing date, but according to the present invention, the market unit price can be reflected in the sales results in a timely manner, which allows the results to be grasped early on a monetary basis. In addition, according to the present invention, it is possible to grasp sales performance using the latest sales unit price, which is the latest market unit price plus the increase or decrease in the wholesale unit price determined by the sales department relative to the market unit price, based on the latest market unit price information and the increase or decrease in the wholesale unit price relative to the market unit price.

FIG. 1 is a diagram showing an example of conventional fuel oil sales management. FIG. 2 is a diagram showing an example of fuel oil sales management in this embodiment. FIG. 3 is a block diagram showing an example of the configuration of a fuel oil sales price management device in this embodiment. FIG. 4 is a diagram showing an example of supplier master settings in this embodiment. FIG. 5 is a diagram showing an example of sales registration in this embodiment. FIG. 6 is a flowchart showing an example of processing of the fuel oil sales price management device in this embodiment. FIG. 7 is a diagram showing an example of fuel oil sales price management processing in this embodiment. FIG. 8 is a diagram showing an example of fuel oil sales price management processing in this embodiment. FIG. 9 is a diagram showing an example of fuel oil sales price management processing in this embodiment. FIG. 10 is a diagram showing an example of fuel oil sales price management processing in this embodiment.

An embodiment of the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to this embodiment.

[1. Overview]
First, an overview of the present invention will be described with reference to Figures 1 and 2. Figure 1 is a diagram showing an example of conventional fuel oil sales management. Figure 2 is a diagram showing an example of fuel oil sales management in this embodiment.

In the oil industry, fluctuations in crude oil prices cause unit prices for fuel oil transactions to change on a regular basis. Previously, in credit sales transactions, unit prices were often determined after the transaction had been completed, and when registering sales data, provisional registration was made at the previous unit price, and sales were recalculated at the latest unit price after the unit price was determined. As a result, in the past, sales results could not be captured as accurate figures until the recalculation.

For example, as shown in Figure 1, in the past, when the unit price was not yet determined, provisional sales amounts (sales data) calculated using the previous month's unit price were registered, and the final sales recalculation was performed at the beginning of the following month. Therefore, during the period until the sales recalculation, actual sales results could only be captured using provisional sales amounts calculated using the previous month's unit price.

Therefore, in this embodiment, the system provides a mechanism that registers the unit price increase or decrease managed on a base date for each customer in the master, imports the market unit price for each region announced weekly by the Agency for Natural Resources and Energy as the base unit price, automatically calculates the sales unit price from the base unit price and the unit price increase or decrease, and multiplies the sales volume by the latest unit price to display sales results by department.

For example, as shown in FIG. 2, in this embodiment, the process of determining unit prices is automated, which makes work more efficient and reduces time, and makes it possible to check actual sales on a report without waiting for sales to be recalculated. In this way, in this embodiment, unit price calculation is automated, and even before sales are recalculated, actual sales based on the latest calculated unit price are output on a report, making it possible to quickly check accurate actual sales.

2. Configuration
An example of the configuration of the fuel oil unit sales price management device 100 according to this embodiment will be described with reference to Fig. 3 to Fig. 5. Fig. 3 is a block diagram showing an example of the configuration of the fuel oil unit sales price management device 100 according to this embodiment.

As shown in FIG. 3, the fuel oil sales price management device 100 is a commercially available desktop personal computer. Note that the fuel oil sales price management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

The fuel oil sales price management device 100 includes a control unit 102, a communication interface unit 104, a memory unit 106, and an input/output interface unit 108. Each unit of the fuel oil sales price management device 100 is connected to each other so that they can communicate with each other via any communication path.

The communication interface unit 104 communicatively connects the fuel oil sales price management 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 a communication line. Here, the network 300 has a function of connecting the fuel oil sales price management 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).

An input device 112 and an output device 114 are connected to the input/output interface unit 108. The output device 114 may be a monitor (including a touch panel), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that works with a mouse to provide a pointing device function. In the following, the output device 114 may be referred to as the monitor 114 or the printer 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

The memory unit 106 stores various databases, tables, files, and the like. The memory unit 106 records computer programs that work with the OS (Operating System) to give commands to the CPU (Central Processing Unit) to perform various processes. The memory unit 106 can be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. The memory unit 106 includes a supplier master 106a, a market unit price master 106b, a unit price application approval master 106c, a sales database 106d, and a supplier unit price master 106e.

The business partner master 106a is a master that is set by linking the region of the business partner (customer) and the week of the month in which the unit price of fuel oil trading is adopted. Here, the business partner master 106a may be set by linking the business partner (customer), region, and/or week number indicating the week of the month in which the unit price of fuel oil trading is adopted.

The market price master 106b is a master that is set by linking the fuel oil product type, region, market price of fuel oil, and the week of the month in which the unit price of fuel oil trading is adopted. Here, the market price master 106b may be set by linking the product, application start date, region, market price, and/or week number indicating the week of the month in which the unit price of fuel oil trading is adopted.

The unit price application approval master 106c is a master that is set by linking the unit price difference, which is the difference between the sales unit price of a product sold to a business partner and the market unit price, and the approval status. Here, the unit price application approval master 106c may be set by linking the business partner (customer), application start date, product, unit price difference, and/or approval status.

The sales database 106d stores sales data. Here, the sales database 106d may store sales data that is set by linking a business partner, a sales date, a sold product, and a sales quantity. The sales database 106d may also store sales data that is set by linking a sales department, a business partner (customer), a sales date, a sold product, a sales quantity, a sales price, and/or a sales amount.

The supplier unit price master 106e is a master that links the supplier (customer), product, application start date, sales price, region, week number, market price, and/or unit price difference.

The control unit 102 is a CPU or the like that performs overall control of the fuel oil sales unit price management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing based on these stored programs. In terms of functional concept, the control unit 102 includes a master setting unit 102a, a unit price difference acquisition unit 102b, a sales unit price acquisition unit 102c, and a sales amount acquisition unit 102d.

The master setting unit 102a sets the master. When data that sets the region and week number of a client is input, the master setting unit 102a may set a record corresponding to the data in the client master 106a. In addition, when the master setting unit 102a downloads the results of a petroleum product price survey from the Agency for Natural Resources and Energy, it may set a record corresponding to the survey results in the market unit price master 106b. In addition, the master setting unit 102a may register sales data in the sales database 106d based on sales registrations from each department.

Here, an example of the customer master settings in this embodiment will be described with reference to FIG. 4. FIG. 4 is a diagram showing an example of the customer master settings in this embodiment.

As shown in FIG. 4, the master setting unit 102a may set a record in the supplier master (client master) 106a that sets the region and the week number for which the unit price is to be adopted.

Furthermore, an example of sales registration in this embodiment will be described with reference to FIG. 5. FIG. 5 is a diagram showing an example of sales registration in this embodiment.

As shown in FIG. 5, the master setting unit 102a may register sales data for each product for each business partner (client) based on sales registration from each department during daily business operations. Here, the unit sales price and sales amount in the sales data in this embodiment may be the unit sales price and sales amount existing at the time of registration.

Returning to FIG. 3, the unit price difference acquisition unit 102b acquires the unit price difference, which is the difference between the sales unit price of the product sold to the business partner and the market unit price. Here, when the unit price difference of the product sold to the business partner is input, the unit price difference acquisition unit 102b may set the unit price difference and a record in which an approval status of "unapproved" is set in the unit price application approval master 106c. Furthermore, when an approval instruction for the unit price difference is input, the unit price difference acquisition unit 102b may update the approval status of the record set in the unit price application approval master 106c from "unapproved" to "approved."

The sales unit price acquisition unit 102c acquires the sales unit price of the sales product for each supplier based on the supplier master 106a, the market unit price master 106b, the sales data, and the unit price difference. Here, the sales unit price acquisition unit 102c may acquire the sales unit price of the sales product for each supplier based on the supplier master 106a, the market unit price master 106b, the sales data, and the unit price difference. In addition, the sales unit price acquisition unit 102c may acquire the sales unit price of the sales product for each supplier by adding the unit price difference to the market unit price of the supplier's region in the week set in the supplier master 106a for the month (or month) including the sales date based on the supplier master 106a, the market unit price master 106b, the sales data, and the unit price difference. In addition, the sales unit price acquisition unit 102c may update the sales data stored in the sales database 106d with the acquired sales unit price of the sales product.

The sales amount acquisition unit 102d acquires the sales amount of the product sold to the business partner based on the sales data and the sales unit price. Here, the sales amount acquisition unit 102d may acquire the sales amount of the product sold to the business partner based on the sales data and the sales unit price. The sales amount acquisition unit 102d may also display sales unit price simulation table data in which the sales department, business partner, sales date, product sold, sales quantity, and sales amount are set. The sales amount acquisition unit 102d may also display the monthly total sales quantity and monthly total sales amount of each product sold for each sales department based on the sales unit price simulation table data. The sales amount acquisition unit 102d may also update the sales data stored in the sales database 106d with the acquired sales amount of the product sold.

3. Specific Examples
A specific example of this embodiment will be described with reference to FIGS.

[Fuel oil sales unit price management processing]
Here, an example of fuel oil sales unit price management processing in this embodiment will be described with reference to Fig. 6. Fig. 6 is a flowchart showing an example of processing of the fuel oil sales unit price management device 100 in this embodiment.

As shown in FIG. 6, when sales are registered in each field department, the master setting unit 102a registers the sales data in the sales database 106d by linking the sales department, the client, the sales date, the sold product, and the sales quantity (step SA-1). For example, in this embodiment, sales data may be registered in each department.

Then, when a sales representative inputs a unit price difference, which is the difference between the sales unit price of the product sold to a business partner and the market unit price, via the input device 112, the unit price difference acquisition unit 102b sets a record in which the unit price difference and an approval status of "unapproved" are set in the unit price application approval master 106c (step SA-2). For example, in this embodiment, a sales representative may register and apply for a unit price difference, which is the difference from the market unit price, for each customer.

Then, when the sales manager inputs an approval instruction for the unit price difference via the input device 112, the unit price difference acquisition unit 102b updates the approval status of the record set in the unit price application approval master 106c from unapproved to approved (step SA-3). For example, in this embodiment, the application contents may be approved by the sales manager.

Then, when the master setting unit 102a downloads the survey results of the petroleum product price survey published weekly by the Agency for Natural Resources and Energy, it sets a record corresponding to the survey results in the market unit price master 106b (step SA-4). For example, in this embodiment, a list of survey results of the petroleum product price survey published weekly by the Agency for Natural Resources and Energy may be downloaded, and the market unit prices may be imported.

Then, the sales unit price acquisition unit 102c acquires the sales unit price of the sold item for each customer by adding the unit price difference to the market unit price for the customer's region for the week with the week number set in the customer master 106a for the month including the sales date, based on the sales data stored in the customer master 106a, the market unit price master 106b, and the sales database 106d, and the unit price difference (step SA-5). For example, in this embodiment, the unit price for each customer may be calculated from the unit price difference and the market unit price in the customer unit price calculation process.

Then, the sales amount acquisition unit 102d acquires the sales amount of the product sold to the business partner based on the sales quantity stored in the sales database 106d and the sales price of the product acquired by the sales price acquisition unit 102c (step SA-6).

Then, the sales amount acquisition unit 102d causes the output device 114 to display the sales price simulation table data, which sets the sales department, customer, sales date, sales item, sales quantity, and sales amount, and further causes the output device 114 to display the monthly sales performance data, which sets the sales department, sales month, sales item, monthly total sales quantity and monthly total sales amount of each sales item for each sales department, based on the sales price simulation table data (step SA-7), and ends the process. For example, in this embodiment, the sales performance for each department may be confirmed by multiplying the sales quantity by the latest unit price.

Now, an example of the fuel oil sales price management process in this embodiment will be described with reference to Figures 7 to 10. Figures 7 to 10 are diagrams showing an example of the fuel oil sales price management process in this embodiment.

As shown in FIG. 7, in this embodiment, when a sales representative registers the unit price difference (unit price increase or decrease) for a product for each customer, the unit price difference and the approval status of "unapproved" are set in the unit price application approval master 106c (step SB-1).

As shown in FIG. 7, in this embodiment, if the superior checks and approves the application, the approval status set in the unit price application approval master 106c is updated from unapproved to approved (step SB-2).

As shown in FIG. 8, in this embodiment, the market unit price import process imports Excel (registered trademark) data of the list of survey results of the petroleum product price survey downloaded from the website of the Agency for Natural Resources and Energy, and updates the market unit price master 106b (step SB-3).

As shown in FIG. 9, in this embodiment, the customer unit price (sales price) is calculated based on the conditions in the supplier master 106a and the unit price difference in the market price master 106b (step SB-4).

As shown in FIG. 10, in this embodiment, the sales amount is calculated from the latest unit price in the unit price simulation table and is compiled by department, and a sales performance report at the latest unit price is output (step SB-5). That is, in this embodiment, in the sales price simulation spreadsheet step (1), the market unit price is reacquired from the master and the sales amount is recalculated, and in the sales price simulation spreadsheet step (2), the details calculated in the sales price simulation spreadsheet step (1) may be compiled by month, by department, and by product.

[4. 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 making it possible to contribute to goals 8 and 9 of the SDGs.

In addition, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, which can contribute to the achievement of SDGs goals 12, 13, and 15.

In addition, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

5. Other embodiments
The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

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 a known method.

In addition, the processing procedures, control procedures, specific names, registered data for each process, information including parameters such as search conditions, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.

Furthermore, with regard to the fuel oil sales price management device 100, each component shown in the figure is a functional concept, and does not necessarily have to be physically configured as shown in the figure.

For example, the processing functions of the fuel oil sales price management device 100, particularly the processing functions performed by the control unit 102, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded on a non-transient computer-readable recording medium that contains programmed instructions for causing the information processing device to execute the processing described in this embodiment, and is mechanically read by the fuel oil sales price management device 100 as necessary. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to give instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM, and works with the CPU to form the control unit.

This computer program may also be stored in an application program server connected to the fuel oil sales price management device 100 via any network, and all or part of it may be downloaded as needed.

In addition, the program for executing the processing described in this embodiment may be stored on a non-transitory computer-readable recording medium, and may also be configured as a program product. Here, the term "recording medium" refers to a memory card, a USB (Universal Serial Bus) memory, a SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical disk), a DVD (Digital Versatile This includes any "portable physical media" such as a Blu-ray (registered trademark) Disc, and a Blu-ray (registered trademark) Disc.

A "program" is a data processing method written in any language or description method, and may be in any format, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration consisting of multiple modules or libraries, and a program that works in conjunction with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in this embodiment, as well as the installation procedure after reading, can use well-known configurations and procedures.

The various databases stored in the memory unit 106 are storage devices 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 website provision.

The fuel oil sales price management 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 fuel oil sales price management device 100 may be realized by implementing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the figures, and all or part of them can be functionally or physically distributed and integrated in any unit depending on various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively.

This invention is useful in the petroleum industry, which handles fuel oil.

REFERENCE SIGNS LIST 100 Fuel oil sales unit price management device 102 Control unit 102a Master setting unit 102b Unit price difference acquisition unit 102c Sales unit price acquisition unit 102d Sales amount acquisition unit 104 Communication interface unit 106 Storage unit 106a Supplier master 106b Market unit price master 106c Unit price application approval master 106d Sales database 106e Supplier unit price master 108 Input/output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (8)

A fuel oil sales price management device having a memory unit and a control unit,
The storage unit is
A supplier storage means for storing a supplier master set by linking the supplier's region with the week in the month in which the unit price of fuel oil transactions is adopted;
a market unit price means for storing a market unit price master set by linking the product type of fuel oil, the region, the market unit price of the fuel oil, and the week;
a sales storage means for storing sales data that is set by linking the business partner, the sales date, the sold product, and the sales quantity;
Equipped with
The control unit is
a unit price difference acquisition means for acquiring a unit price difference when a unit price difference between the sales unit price of the product sold to the trading partner and the market unit price is input;
a sales unit price acquisition means for acquiring the sales unit price of the sold item for each of the suppliers by adding the unit price difference to the market unit price of the region of the supplier for the week set in the supplier master for the month including the sales date, based on the supplier master, the market unit price master, the sales data, and the unit price difference;
A fuel oil sales price management device comprising: The control unit is
a sales amount acquisition means for acquiring the sales amount of the product to the business partner based on the sales data and the unit price of the product;
The fuel oil sales price management device according to claim 1, further comprising: The sales amount acquisition means is
The fuel oil sales price management device as described in claim 2, characterized in that the sales amount is calculated by multiplying the sales quantity by the sales price which is the latest unit price, and displays sales price simulation table data which sets the sales department, the client, the sales date, the sold product, the sales quantity, and the sales amount. The sales amount acquisition means is
The fuel oil sales price management device as described in claim 3, further characterized in that it displays the monthly total sales quantity and monthly total sales amount of each sales product for each sales department based on the sales price simulation table data. The unit price difference acquisition means
A fuel oil sales unit price management device as described in any one of claims 1 to 4, further characterized in that when the unit price difference of the product sold to the trading partner is input, a record setting the unit price difference and an approval status of unapproved is set in the unit price application approval master. The unit price difference acquisition means
The fuel oil sales unit price management device as described in claim 5, further characterized in that when an approval instruction for the unit price difference is input, the approval status of the record set in the unit price application approval master is updated from unapproved to approved. A fuel oil sales unit price management method to be executed by a fuel oil sales unit price management device having a memory unit and a control unit,
The storage unit is
A supplier storage means for storing a supplier master set by linking the supplier's region with the week in the month in which the unit price of fuel oil transactions is adopted;
a market unit price means for storing a market unit price master set by linking the product type of fuel oil, the region, the market unit price of the fuel oil, and the week;
a sales storage means for storing sales data that is set by linking the business partner, the sales date, the sold product, and the sales quantity;
Equipped with
The control unit executes
a unit price difference acquisition step of acquiring a unit price difference when a unit price difference between the sales unit price of the product sold to the trading partner and the market unit price is input;
a sales unit price acquisition step of acquiring the sales unit price of the sold product for each of the suppliers by adding the unit price difference to the market unit price of the region of the supplier for the week set in the supplier master for the month including the sales date, based on the supplier master, the market unit price master, the sales data, and the unit price difference;
A method for managing fuel oil sales prices, comprising: A fuel oil sales unit price management program to be executed by a fuel oil sales unit price management device having a memory unit and a control unit,
The storage unit is
A supplier storage means for storing a supplier master set by linking the supplier's region with the week in the month in which the unit price of fuel oil transactions is adopted;
a market unit price means for storing a market unit price master set by linking the product type of fuel oil, the region, the market unit price of the fuel oil, and the week;
a sales storage means for storing sales data that is set by linking the business partner, the sales date, the sold product, and the sales quantity;
Equipped with
In the control unit,
a unit price difference acquisition step of acquiring a unit price difference when a unit price difference between the sales unit price of the product sold to the trading partner and the market unit price is input;
a sales unit price acquisition step of acquiring the sales unit price of the sold product for each of the suppliers by adding the unit price difference to the market unit price of the region of the supplier for the week set in the supplier master for the month including the sales date, based on the supplier master, the market unit price master, the sales data, and the unit price difference;
A fuel oil sales price management program to implement the above.

Images