JP5653797B2 - Oil product customer information management system - Google Patents

Description

The present invention centrally manages and shares information on oil products such as engine oil and lubricating oil and customers who use the oil products, and only costs merits such as cost reduction for existing customers and new customers. In particular, the present invention relates to an oil product customer information management system that can easily propose environmental benefits such as CO ₂ reduction.

Conventionally, information on products to be sold and customers is managed using a database and the like, information is extracted as necessary, and used for sales activities for existing customers and new customers.
For example, in Patent Document 1 (Japanese Patent Laid-Open No. 2006-11979), a sales promotion information storage unit that stores customer information related to sales promotion activities, a product shipment information storage unit that stores customer information related to product shipment, A customer information management device that generates and outputs customer interest feature information based on customer information registered in a database using a customer information management database including a maintenance service information storage unit that stores customer information related to product maintenance services Is disclosed.

  With this customer information management device, the customer's event interest level based on participation in product exhibitions and technical seminars, product interest level based on questionnaire results, etc., actual purchase results based on customer purchases, etc. By expressing the degree of interest and the degree of maintenance-dependent interest based on the status of the maintenance request from the customer as points according to the degree of interest, it is possible to output the degree of interest of the customer with respect to the company.

  Patent Document 2 (Japanese Patent Application Laid-Open No. 2004-185598) uses a database including customer attribute information indicating attributes such as a customer's name, sex, and address, and purchase information indicating products purchased by the customer. A one-to-one business support system that narrows down target customers by analyzing customer information registered in a database and generates a sales action plan for each target customer is disclosed.

  In this one-to-one business support system, customers can be analyzed using information about customers registered in a database, and an appropriate sales action plan can be automatically generated for each customer using the analysis results.

  Patent Document 3 (Japanese Patent Application Laid-Open No. 2006-11817) discloses a unified database by linking customer information, device information, sales information, and the like using a database including customer information, device information, and sales information. Management system capable of effectively managing the registered information and effectively using the registered information is disclosed.

JP 2006-11979 A JP 2004-185598 A JP 2006-11817 A

Such a customer management system is simply a system configured for sales based on marketing such as customer interest and sales performance.
However, in terms of sales and sales of oil products such as engine oils and lubricating oils, aspects based on marketing are required, but in recent years, aspects based on environmental protection, which are of particular interest, are also required.

Engine oil used in automobile engines and lubricating oil used in machine tools affect the performance and fuel efficiency of engines and machine tools. Depending on the type of engine oil and lubricating oil, CO ₂ emissions The amount may vary greatly.

In the past, there has been no customer management system configured to easily determine environmental loads such as CO ₂ emissions and fuel consumption, taking into account the special characteristics of oil products such as engine oil and lubricating oil.

In consideration of such environmental loads such as CO ₂ emissions and fuel consumption, selection of oil products to be proposed to customers has hitherto been made based on the knowledge and experience of sales staff.
In the present invention, in view of such a current situation, it is possible to easily determine the environmental load such as CO ₂ emission and fuel consumption after considering the special characteristics of oil products such as engine oil and lubricating oil, Select oil products such as engine oil and lubricating oil suitable for automobile engines and machine tools used by customers, and present information that can be used effectively for sales and sales of oil products. Provide a customer information management system that uses oil products.

The present invention was invented in order to achieve the problems and objects in the prior art as described above, and the oil product use customer information management system of the present invention includes:
At least an information database in which information about customers, information about actual vehicles and machines, and information about oil products are registered,
A server computer configured so that the client computer can be connected via a network, and
By sending the information about the actual vehicle / actual machine owned by the client and the oil product used in the actual car / actual machine owned by the client from the client computer to the server computer,
In the server computer, information on the actual vehicle / actual machine registered in the information database, information on the oil product, information on an actual vehicle / actual machine held by the customer transmitted from the client computer, and the customer Calculates the amount of oil reduction based on the information on the oil products used in actual vehicles and machines owned by , and calculates at least one of the annual cost reduction amount and the annual CO ₂ reduction amount from the oil reduction amount Then, the oil product registered in the information database is selected from the oil products with the largest annual cost reduction or the annual CO ₂ reduction amount, and the selected oil product is selected as the client. It is configured to be displayed on a computer.

  In addition, the oil product customer information management system of the present invention is configured such that the client computer can browse, register / update, or browse and register / update at least one of the information included in the information database. It is characterized by being.

An oil product use customer information management system of the present invention, the wherein the information database, the information about the customer and the vehicle-actual information on said information about the oil product is associated with al will be registered To do.

  In the oil product utilization customer information management system according to the present invention, information related to actual vehicles / actual machines owned by customers and information related to oil products used in actual vehicles / actual machines owned by customers are registered in the information database. It is characterized by.

Also, the oil product customer information management system of the present invention is used in the server computer in the information about the actual vehicle / actual machine owned by the customer registered in the information database and the actual vehicle / actual machine owned by the customer. The fuel consumption rate in the combination of the actual vehicle / actual machine and the oil product is estimated based on the information on the oil product .

According to the present invention, merit calculation such as cost reduction amount and CO ₂ reduction amount of actual machine and actual vehicle can be performed based on other cases registered in the information database, so it is very close to the actual usage situation. Cost calculation and CO ₂ emission calculation can be performed.

For this reason, even if the salesperson has little knowledge and experience, it is possible to present persuasive information to the customer, and it becomes possible to conduct appropriate and persuasive sales and sales.
In addition, it is possible to automatically calculate based on the input information or information registered in the information database, and to present appropriate suggested products, cost reduction amount, CO ₂ reduction amount, etc. Even if you have little knowledge or experience, you can conduct appropriate sales and sales.

  In addition, by appropriately updating and registering data of actual machines / vehicles of existing customers, it is possible to present oil products more suitable for the actual machines / vehicles owned by existing customers, together with persuasive information.

FIG. 1 is a system configuration diagram for explaining the outline of the oil product utilization customer management system of the present invention. FIG. 2 is an example of a screen displayed on the client computer 14 when the server computer 12 is accessed from the client computer 14 using a web browser and the oil product customer management system 10 of the present invention is used. FIG. 3 is an example of a screen displayed on the client computer 14 when the server computer 12 is accessed from the client computer 14 using a web browser and the oil product customer management system 10 of the present invention is used. FIG. 4 is an example of a screen displayed on the client computer 14 when the server computer 12 is accessed from the client computer 14 using a web browser and the oil product customer management system 10 of the present invention is used. FIG. 5 is an example of a screen displayed on the client computer 14 when the server computer 12 is accessed from the client computer 14 using a web browser and the oil product customer management system 10 of the present invention is used. FIG. 6 is an example of a screen displayed on the client computer 14 when the server computer 12 is accessed from the client computer 14 using a web browser and the oil product customer management system 10 of the present invention is used. FIG. 7 is an example of a screen displayed on the client computer 14 when the server computer 12 is accessed from the client computer 14 using a web browser and the oil product customer management system 10 of the present invention is used. FIG. 8 is an example of a screen displayed on the client computer 14 when the server computer 12 is accessed from the client computer 14 using a web browser and the oil product customer management system 10 of the present invention is used. FIG. 9 shows an example of a screen displayed on the client computer 14 when the server computer 12 is accessed from the client computer 14 using a web browser and the oil product customer management system 10 of the present invention is used. FIG. 10 shows an example of a screen displayed on the client computer 14 when the server computer 12 is accessed from the client computer 14 using a web browser and the oil product customer management system 10 of the present invention is used. FIG. 11 is an example of a screen displayed on the client computer 14 when the server computer 12 is accessed from the client computer 14 using a web browser and the oil product customer management system 10 of the present invention is used. FIG. 12 is an example of a screen displayed on the client computer 14 when performing merit calculation for an actual machine. FIG. 13 is an example of a screen displayed on the client computer 14 when calculating a merit for an actual vehicle. FIG. 14 is a screen displayed on the client computer 14 when managing schedules such as tests for oil change and merit calculation for existing customers.

Hereinafter, embodiments (examples) of the present invention will be described in more detail with reference to the drawings.
FIG. 1 is a system configuration diagram for explaining the outline of the oil product utilization customer management system of the present invention.

In FIG. 1, the code | symbol 10 has shown the oil product utilization customer management system of this invention on the whole.
As shown in FIG. 1, an oil product customer management system 10 in this embodiment includes a server computer 12 having a database as described later, and a client computer 14 for a user to use the oil product customer management system. Are connected via a network 16.

The configuration of the server computer 12 is not particularly limited. For example, an existing general-purpose computer equipped with a storage device, an arithmetic device, and the like can be used.
Further, the configuration of the client computer 14 is not particularly limited, and for example, a commercially available personal computer can be used.

  The network 16 is not particularly limited as long as it can transmit and receive data between the server computer 12 and the client computer 14, and may be a wide area network such as the Internet, for example. A network covering a relatively narrow range such as a LAN (Local Area Network) may be used, and a wireless ad hoc network or the like may be used.

  In the oil product customer management system 10 of this embodiment configured as described above, the server computer 12 has at least a customer information database 18 in which customer information is registered, and information on actual vehicles and actual machines such as automobiles and machine tools. An actual vehicle / actual machine information database 20 to be registered and an oil product information database 22 to register information about oil products such as engine oil and lubricating oil are provided.

  Here, in the customer information database 18, for example, as customer basic information, the customer's name, address, contact information, type of business, person in charge, etc. The name, manufacturer, model, fuel consumption, etc. of the oil product used by the customer, such as the name of the car or machine tool used, the product name, replacement time, replacement cycle, and past use of the oil product for each vehicle / machine The actual results and the next replacement date are registered.

  In the actual vehicle / actual machine information database 20, for example, names of automobiles and machine tools, manufacturers, models, weights, operation times, test start dates, and the like are registered as actual vehicle / actual machine information.

In the oil product information database 22, analysis results such as kinematic viscosity, acid value, and residual carbon of the oil product are registered as information on the oil product introduced into the actual vehicle / actual machine.
In this specification, the customer information database 18, the actual vehicle / actual machine information database 20, and the oil product information database 22 are collectively referred to as an information database 24.

  In this embodiment, the customer information database 18, the actual vehicle / machine information database 20, and the oil product information database 22 are stored as separate databases in the server computer 12, but the information contained in these databases is stored in the server computer. 12 can be configured by creating a plurality of tables in one database, and the database structure is not particularly limited.

  In addition, the method for accessing the server computer 12 from the client computer 14 and transmitting / receiving data is not particularly limited. For example, dedicated software may be installed in the client computer 14, and As described above, the server computer 12 may be accessed using a web browser.

Below, the operation | movement at the time of using the oil product utilization customer management system 10 of this invention using the client computer 14 is demonstrated.
2 to 11 are screens displayed on the client computer 14 when the server computer 12 is accessed from the client computer 14 using a web browser and the oil product customer management system 10 of the present invention is used. is there.

  The browsing and new registration of customer information can be performed from the customer information screen as shown in FIG. When browsing customer information, a search condition is set, and a search button 26 is clicked to transmit a command for selectively extracting information that matches the search condition from the information database 24 to the server computer 12. .

  Then, in accordance with this instruction, the server computer 12 selectively extracts information that meets the search condition from the information database 24 and transmits the selected and extracted data to the client computer 14. In the client computer 14, as shown in FIG. 3, customer information is displayed as a list in the selected and extracted data received.

  By clicking the download button 28, a list of customer information displayed as shown in FIG. 3 (that is, selected and extracted data) can be stored in the client computer 14 as a text file, for example. It is.

  In addition, when a new customer is registered, a new customer information registration screen is displayed by clicking the new registration button 30 as shown in FIG. On the customer information detail registration screen, necessary information is input and the registration button 32 is clicked, whereby the input data is transmitted to the server computer 12.

  The server computer 12 registers the received data in the information database 24 and transmits data indicating that customer information has been registered in the information database 24 to the client computer 14.

  When the client computer 14 receives the data indicating the registration, the client computer 14 notifies the user that the registration is completed, for example, by displaying a message or displaying the registered information. Can do.

  Next, browsing of actual machine information can be performed from an actual machine information screen as shown in FIG. When browsing actual machine information, by setting a search condition and clicking the search button 34, a command for selectively extracting information that matches the search condition is transmitted from the information database 24 to the server computer 12. .

  Then, in accordance with this instruction, the server computer 12 selectively extracts information that meets the search condition from the information database 24 and transmits the selected and extracted data to the client computer 14. In the client computer 14, as shown in FIG. 6, the actual machine information is displayed as a list of the selected and extracted data received.

  By clicking the detail button, the detailed information of the actual machine can be browsed as shown in FIG. In the detailed information of the actual machine, the power consumption of the actual machine for the oil product that was used before can be displayed side by side with the power of the actual machine for the oil product that is currently being used. It can also be seen.

  In addition, in order to clarify the effect of the actual machine for the oil product currently in use, the actual machine power for the oil product that has been used before and the power of the actual machine for the oil product currently used By displaying, for example, the amount of power that can be reduced annually, the electricity bill, the power saving effect, etc., the cost merit can be easily presented to the customer.

  In addition, information such as the operating status of the actual machine, tank capacity, operating pressure, and work piece is also displayed. By using these pieces of information, merit calculation as described later can be performed.

  In the present embodiment, the detailed information of the actual machine is configured to be browseable only. However, by appropriately preparing an information input screen, an information update command or a new registration command can be obtained from the client computer 14. May be registered and updated in the information database 24 by transmitting to the server computer 12.

  Next, the browsing of the actual vehicle information can be performed from the actual vehicle information screen as shown in FIG. When browsing the actual vehicle information, by setting a search condition and clicking the search button 36, a command is transmitted to the server computer 12 to selectively extract information that matches the search condition from the information database 24. .

  Then, in accordance with this instruction, the server computer 12 selectively extracts information that meets the search condition from the information database 24 and transmits the selected and extracted data to the client computer 14. In the client computer 14, as shown in FIG. 9, actual vehicle information is displayed as a list of the received data that has been selected and extracted.

  By clicking the detail button, the detailed information of the actual vehicle can be browsed as shown in FIG. In the detailed information of the actual vehicle, information on the engine oil such as the travel distance and the kinematic viscosity and acid value of the engine oil used at that time is displayed at every engine oil replacement timing.

  Further, as shown in FIG. 11, the travel distance and engine oil information such as the kinematic viscosity and acid value of the engine oil used at that time may be visualized and displayed as a graph.

  In addition, information such as the actual vehicle travel pattern, monthly travel distance, engine oil update distance, fuel consumption, and load is also displayed. By using these pieces of information, merit calculation as described later can be performed.

  In the present embodiment, the detailed information of the actual vehicle is configured so that it can only be browsed. However, by appropriately preparing an information input screen, an information update command or a new registration command can be obtained from the client computer 14. May be registered and updated in the information database 24 by transmitting to the server computer 12.

  By accessing the server computer 12 from the client computer 14, customer information, actual machine information, and actual vehicle information can be viewed, registered, and updated. Therefore, if there is a client computer 14 that can access the server computer 12, Customer information, actual machine information, and actual vehicle information can be viewed, registered, and updated from anywhere, and customer information, actual machine information, and actual vehicle information, which are information necessary for sales, can be shared among a plurality of users.

Further, by using the information database 24 registered in this way, the merit calculation can be performed as follows.
FIG. 12 is a screen displayed on the client computer 14 when calculating the merit for an actual machine.

When calculating the merit, information on the actual machine owned by the customer, information on the oil product used, information on the oil product proposed to the customer, etc. are entered and the calculation button 38 is clicked. As a result, information on the actual machine owned by the customer and information on the oil product used are transmitted to the server computer 12, and based on these information and information registered in the information database 24, The annual CO ₂ reduction amount is calculated by the server computer 12 and displayed on the client computer 14.

Specifically, the annual cost reduction amount and the annual CO ₂ reduction amount can be calculated as follows.
First, the power consumption reduction amount (kWh) is calculated as shown in Equation 1.

Next, the oil saving amount (kL) is calculated as shown in Equation 2.

Next, the electricity cost reduction amount (yen) is calculated as shown in Equation 3.

Next, the oil savings (yen) is calculated as in Equation 4.

Then, the amount of waste oil treatment cost reduction (yen) is calculated as in Equation 5.

The annual cost reduction as shown in the following equations 6 and 7 from the power consumption reduction, oil savings, electricity cost reductions, oil reductions, and waste oil treatment cost savings calculated based on Equations 1 to 5. The amount and annual CO ₂ reduction can be calculated.

In Equations (1) to (7), the efficiency is the ratio of output work to the electric power input to the motor, and the operation rate is the time ratio during which the machine is operating in one year. Moreover, the value measured beforehand can be used for the power saving effect at the time of use of proposal oil, for example. Further, the annual oil usage can be obtained as shown in Equation 8.

The unit of CO ₂ emissions is based on “Guidelines for calculating greenhouse gas emissions from businesses” published by the Ministry of the Environment. In this example, the power is 0.00041t / kWh, oil The product is 2.9 t / KL.

  In this embodiment, it is configured to input information of the oil product proposed to the customer. However, the server computer 12 is configured to automatically select a suitable oil product from the oil product information database 22. You can also

In other words, when only the information on the actual machine owned by the customer and the information on the oil product being used are entered, clicking the calculation button allows the information on the actual machine owned by the customer and the oil product being used to be Information is transmitted to the server computer 12, and based on these information and oil product information registered in the oil product information database 22, for example, the annual cost reduction amount is maximized or the annual CO ₂ reduction amount is maximized. An appropriate oil product is automatically selected and the annual cost reduction amount and the annual CO ₂ reduction amount may be displayed on the client computer 14 as described above.

The annual electricity consumption and the power saving effect are not uniquely determined from the oil product, but are estimated from the combination of the actual machine and the oil product held by the customer.
That is, in the present invention, since information is shared so that a plurality of users can browse, register, and update customer information, actual machine information, and the like from the client computer 14, they are used in the same combination with the input actual machine and oil product. From other cases, the amount of electricity used annually and the power saving effect are estimated.

FIG. 13 is a screen displayed on the client computer 14 when calculating a merit for an actual vehicle.
Merit calculation for the actual vehicle is basically the same as the merit calculation for the actual machine, including information on the actual vehicle owned by the customer, information on the oil product used, information on the oil product proposed to the customer, etc. Input and click the calculation button 40.

As a result, similar to the merit calculation for the actual machine, the annual cost reduction amount, the annual CO ₂ reduction amount, and the like are displayed on the client computer 14.
In addition, in the merit calculation for actual vehicles, as well as the merit calculation for actual vehicles, information on the oil products proposed to the customer, the information on the actual vehicles owned by the customer, the information on the oil products used, and the oil product information An appropriate oil product can be automatically selected based on the information of the oil product registered in the database 22.

Specifically, the annual cost reduction amount and the annual CO ₂ reduction amount can be calculated as follows.
First, the light oil saving amount (L) is calculated as shown in Equation 9.

Next, the oil saving amount (L) is calculated as shown in Equation 10.

Next, the light oil saving (yen) is calculated as shown in Equation 11.

Next, the oil saving amount (yen) is calculated as in Expression 12.

Then, a reduction in waste oil processing costs (yen), an oil element savings (yen), and a labor cost savings (yen) are calculated as shown in equations 13, 14, and 15, respectively.

From the light oil savings, oil savings, light oil savings, oil savings, waste oil treatment cost savings, oil element savings, and labor cost savings calculated based on Equations 9 to 15, As shown in FIG. 17, the annual cost reduction amount and the annual CO ₂ reduction amount can be obtained.

In Equations 9 to 17, the number of annual exchanges is the annual travel distance divided by the exchange distance. Further, the fuel consumption with the proposed oil can be obtained as shown in Equation 18.

Here, for the fuel saving rate, for example, a value measured in advance can be used.

The CO ₂ emission unit is based on “Guidelines for calculating greenhouse gas emissions from businesses” published by the Ministry of the Environment. In this example, diesel oil is 2.6 t / kWh, oil The product is 2.9 t / KL.

The fuel saving rate is not uniquely determined from the oil product, but is estimated from the combination of the actual vehicle and the oil product held by the customer.
That is, in the present invention, since information is shared so that a plurality of users can browse, register, and update customer information, actual vehicle information, and the like from the client computer 14, they are used in the same combination with the input actual vehicle and oil product. From other examples, the fuel economy rate is estimated.

As described above, since the merit calculation of the actual machine and the actual vehicle can be performed based on other cases registered in the information database 24, the cost calculation and the CO ₂ emission calculation extremely close to the actual use situation can be performed. Is possible.

For this reason, it is possible to present persuasive information to the customer, and therefore it is possible to conduct persuasive sales and sales even if the salesperson has little knowledge or experience.
Further, the merit calculation of the actual machine and the actual vehicle is automatically calculated by the server computer 12 based on the input information and the information registered in the information database 24, and the appropriate proposed product, cost reduction amount, CO ₂ is calculated. Since the amount of reduction can be presented, appropriate sales and sales can be performed even if the salesperson has little knowledge or experience.

FIG. 14 is a screen displayed on the client computer 14 when managing schedules such as tests for oil change and merit calculation for existing customers.
By performing schedule management in this way, for example, existing customers whose oil replacement timing is approaching can be contacted by contact means such as e-mail or telephone, thereby enclosing the existing customers.

Also, for example, at the time of oil change, the existing customer's actual machine and vehicle running pattern and load, engine usage years, analysis data of the oil product currently used, etc. are updated to the oil product customer management system of the present invention. By registering and performing the above-mentioned merit calculation, it is possible to present the annual cost reduction amount and annual CO ₂ reduction amount determined from the latest data to the existing customer. It is also possible to present oil products that are more suitable for actual machines and vehicles.

  The preferred embodiment of the present invention has been described above, but the present invention is not limited to this. For example, the oil database replacement time is registered in the information database 24 for each actual machine / vehicle, and the replacement time When a message approaches or passes, a message is displayed on the client computer 14 or the customer's contact information registered in the customer information database 18 is contacted, for example, by automatically sending an e-mail or the like. You may comprise as follows.

  In addition, for example, a known information sharing system such as a glossary, an electronic bulletin board, or FAQ (Frequently Asked Questions) may be included for the purpose of sharing information among a plurality of users.

  Further, for each user, for example, by setting a password, an electronic certificate, etc., it is possible to ensure the security of the information and to prevent the shared information from being viewed by a third party. Various modifications can be made without departing from the object.

10 Oil Product Use Customer Management System 12 Server Computer 14 Client Computer 16 Network 18 Customer Information Database 20 Actual Car / Real Machine Information Database 22 Oil Product Information Database 24 Information Database 26 Search Button 28 Download Button 30 New Registration Button 32 Registration Button 34 Search Button 36 Search button 38 Calculate button 40 Calculate button

Claims (5)

At least an information database in which information about customers, information about actual vehicles and machines, and information about oil products are registered,
A server computer configured so that the client computer can be connected via a network, and
By sending the information about the actual vehicle / actual machine owned by the client and the oil product used in the actual car / actual machine owned by the client from the client computer to the server computer,
In the server computer, information on the actual vehicle / actual machine registered in the information database, information on the oil product, information on an actual vehicle / actual machine held by the customer transmitted from the client computer, and the customer Calculate the amount of oil reduction based on the information on oil products used in actual vehicles and machines owned by , and calculate at least one of annual cost reduction and annual CO ₂ reduction from the oil reduction amount From among the oil products registered in the information database, an oil product that maximizes either the annual cost reduction amount or the annual CO ₂ reduction amount is selected, and the selected oil product is selected as the client computer. Oil characterized by being displayed or stored on Product usage customer information management system.   The at least one information contained in the information database can be browsed, registered / updated, or browsed, registered / updated by the client computer. Oil product customer information management system. The information database, oil products use customer information according to claim 1 or 2, characterized in that said customer related information and said vehicle-actual information about the the oil information about the product is associated with al will be registered Management system.   4. The information database includes information on actual vehicles / actual machines held by customers and information on oil products used in actual vehicles / actual machines owned by customers. Oil product customer information management system described in Crab. In the server computer, based on the information about the actual vehicle / actual machine owned by the customer registered in the information database and the information about the oil product used in the actual car / actual machine owned by the customer, the actual vehicle / actual machine And estimate the fuel economy rate in combination with the oil product,
  5. The oil product customer information management system according to claim 4, wherein the oil reduction amount is calculated using the fuel saving rate.