JPH11208794A - Oil delivery instruction system and recording medium with oil delivery instruction system program recorded - Google Patents

Abstract

PROBLEM TO BE SOLVED: To realize efficient delivery, by performing scheduled delivery of oil by estimating a stock based on consumption calculation corresponding to an oil stock container for preserving kerosine for each home, and also by estimating oil consumption and stock with past data preserved for comparative analysis of the data. SOLUTION: A delivery instruction system for delivering kerosine or the like to each home includes an input device 2 for inputting data such as capacity data, feed date data, fed amount data for specifying an amount of fed oil on the feed date and residual amount data corresponding to each of a plurality of stock containers placed at customers. A central processing unit 1 calculates an interval of oil feeding from a final feed date and its immediate date, and calculates a value where the fed amount on the final feed date is divided by the interval as a consumption amount per day of the container. In addition, an accumulated value of the consumption amount up to the present day is subtracted from the capacity data to specify a container to be fed on the day, and obtained data is stored in a main memory device 3.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an oil delivery instruction system for delivering oil to a gas station and households, and a recording medium storing an oil delivery instruction system program.

[0002]

2. Description of the Related Art Japanese Patent Application Laid-Open No. 03-226491 discloses a system for efficiently delivering oils such as kerosene, which can automatically set a preset value which is an order quantity of oils based on a delivery order from a customer. As a means for improving the efficiency of oil delivery, a refueling system using POS is disclosed.
This system arranges order data from customers and utilizes a delivery schedule extracted to allow a refueling worker to deliver by district.

[0003] Japanese Patent Application Laid-Open No. 03-275496 discloses a refueling station system which promotes a sales strategy by managing various refueling information including vehicle data and customer identification data of a customer and achieves rationalization of refueling station management. Is disclosed.

[0004] In this system, a refueling operator inputs customer identification data and the like to a POS and stores it in a memory as refueling management information, so that the refueling station can grasp the customer's trends.

[0005] Japanese Patent Application Laid-Open No. 06-001399 discloses that data is exchanged between a vehicle-mounted computer and a host computer so that refueling workers do not need to input through a POS, and a card reader simply reads a customer card to perform a tallying operation. A system for performing the above is also disclosed.

[0006]

However, since it is not possible to predict the amount of oil consumed per day, the current amount of residual oil of a customer must be managed by using a storage container provided at the customer's site. It was only done by weighing. Even in the case of a delivery instruction, it is not possible to predict the amount of residual oil in real time and issue the delivery instruction. Therefore, there is a large physical, human, and cost burden such as attaching a measuring device to a container to be stored by a customer. However, there is a problem in that the delivery cannot be planned because the assignment of the delivery person and the delivery vehicle, the number of rotations of the delivery vehicle, and the like must be depended on even if the information is output.

[0007] The present invention has been devised to solve the above-mentioned problems. The present invention predicts inventory by calculating a consumption amount corresponding to each oil storage container and performs planned oil distribution. By providing past data and comparing and analyzing these data, it is possible to predict oil consumption and inventory, and to provide an oil delivery instruction system and a recording medium storing an oil delivery instruction system program. Subject.

[0008]

The present invention employs the following means to solve the above-mentioned problems.

A first feature of the present system is directed to an oil delivery instruction system that issues an oil delivery instruction using a programmed computing device, and is adapted to correspond to a plurality of oil storage containers installed at a customer. Capacity data indicating the maximum amount of oil that can be refilled in the container, refueling date data specifying the date of refueling the container, refueling amount data specifying the amount of refueling on the refueling day, and a minimum remaining amount preset in the container. Refueling data input means for inputting refueling data including remaining amount data indicating the amount (first residual oil amount), and calculating the number of days of refueling intervals from the last refueling date and the most recent refueling date, and refueling on the last refueling day Consumption calculating means for calculating a value obtained by dividing the amount by the number of days of the refueling interval as the daily consumption of the container; and subtracting the accumulated value of the consumption up to the current day from the input capacity data. To calculate the residual oil amount on the day (second residual oil amount), select a container having the second residual oil amount equal to or less than the first residual oil amount from the plurality of containers, and perform refueling on the day. On-the-day refueling container specifying means for specifying a container to be held, holding means for holding the refueling data and the data on the consumption and the on-the-day refueling container, display means for displaying the content held by the holding means, Output means for outputting the contents held by the holding means.

According to the present invention, the oil storage containers held by the customer are individually addressed and specified, and the capacities, refueling dates, refueling amounts, and set minimum residual oil amounts (first residual oil amounts) of these containers are specified. Is stored in the memory in advance. The refueling interval days for each container are calculated from the last refueling date and the most recent refueling date according to a calendar, and the daily consumption of the container is calculated by (final refueling amount / refueling interval days). The container that needs oil refueling on the day of delivery is calculated by (volume− (consumption × accumulated number of days)) = residual oil amount (second residual oil amount) on the day. It is specified by extracting containers with a residual oil amount of 1 or less.

As a second feature of the present system, when there is a day when the customer does not use the oils, the consumption calculation means subtracts the day from the refueling interval days to obtain the refueling interval days, and the consumption amount is calculated. Is included.

As a third feature of the present system, the refueling data input means includes means for inputting a refueling required ratio (%) as a criterion for determining whether or not the next refueling is required in each of the containers. , The consumption calculation means,
A means for calculating a value obtained by dividing the residual oil amount (second residual oil amount) on the day by the capacity of each of the containers as a residual oil ratio (%); (%)
Includes means for selecting the container having the required ratio (%) or less.

As a fourth feature of the present system, the refueling data includes delivery area data for dividing a delivery destination into an area of a required size, delivery vehicle data for specifying a delivery vehicle, and a delivery person for specifying a delivery person. Including at least one of the customer data, the day-of-the-day refueling container specifying means, means for totalizing the amount of oil delivered for each area, means for allocating the delivery vehicles for each area, and the delivery charge for each area At least one of means for assigning a person.

Further, the sales data input means may include a terminal device for transmitting the refueling data via a communication line and receiving the contents held by the holding means.

The first feature of the recording medium on which the system program is recorded is a readable recording medium on which a program for instructing oil delivery by a computing device is recorded. Corresponding to each of the oil storage containers, capacity data indicating the maximum amount that can be refueled to the container, refueling date data specifying the day of refueling the container, refueling amount data specifying the amount of refueling on the refueling day and The minimum residual oil amount preset in the vessel (first
Refueling data input means for inputting refueling data comprising remaining amount data indicating the amount of residual oil), and calculating the number of days between refueling intervals based on the last refueling date and the most recent refueling date. A consumption calculating means for calculating a value obtained by dividing the number of days by the interval as a daily consumption of the container, and subtracting a cumulative value of the consumption up to the day from the input capacity data to obtain a residual oil amount of the day ( The second refueling amount) is calculated, and the container in which the second residual oil amount is equal to or less than the first residual oil amount is selected from the plurality of containers, and the refueling on the day specifying the container to be refueled on the same day is specified. Container specifying means, holding means for holding the refueling data and the data regarding the consumption amount and the refueling container on the day, display means for displaying the contents held by the holding means, and holding means for holding Output means for outputting the contents To be executed.

A second feature of the recording medium is that when the customer has a day when the oil is not used, the day is subtracted from the refueling interval days to obtain the refueling interval days, and the consumption amount is calculated. The calculation means is executed.

A third feature of the present recording medium is that the refueling data input means for inputting a refueling required ratio (%) as a criterion for determining whether or not the next refueling is required in each of the containers; The consumption calculating means for calculating a value obtained by dividing a residual oil amount (a second residual oil amount) by the capacity of each of the containers as a residual oil ratio (%), and the residual oil ratio (%) being the required ratio (%) The same day refueling container specifying means for selecting the container as described below is executed.

A fourth feature of the recording medium is that the delivery area data for dividing the delivery destination into areas of a required area, the delivery vehicle data for specifying the delivery vehicle, and the delivery clerk data for specifying the delivery clerk. The refueling data input means for inputting at least one, and the refueling container specifying means for the day, means for counting the amount of oils delivered for each area, means for allocating the delivery vehicles for each area, and means for each area And executing the same day refueling container specifying means for specifying at least one of the means for assigning a delivery person.

[0019]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An oil delivery instruction system according to the present embodiment will be specifically described with reference to the accompanying drawings. FIG.
FIG. 2 is a block diagram showing an apparatus for executing the oil delivery instruction system. FIGS. 2 to 9 are flowcharts showing the operation principle of the oil delivery instruction system program.

The oil delivery instruction system includes an input device 2,
A computer main body formed of a main storage device 3 (hereinafter, referred to as a memory) and a central processing unit 1 (hereinafter, referred to as a CPU), an auxiliary storage device 4, a terminal device 6 connected via a communication control device 5, And an output device 7.
These devices are interconnected by an input / output interface 8 or a communication line. The input device 2 includes a keyboard, a mouse, an OCR, a barcode reader, and the like. The communication control device 5 converts the data stored in the memory 3 into a predetermined mode using terminal software, transmits the converted data to the terminal device 6 through the communication line, and receives the data from the terminal device 6. The terminal device 6 that transmits data to the communication control device 5 using the communication means has a general name of a handy terminal (hereinafter, HT).
). The output device 7 includes a display device (display), a printing device (printer), and the like.

The CPU 1 is an arithmetic unit 1A that performs four arithmetic operations, logical operations, and magnitude comparisons on given data.
From the memory 3 based on the address of the instruction to be executed.
The control device 1B fetches an instruction into the PU1, decodes the content of the instruction, and outputs necessary operation instructions to another device.

The control device 1B issues an input control command to the input device 2, issues a memory control command to the memory 3, and issues an output control command to the output device 7.
The command input from the input device 2 is first stored in the memory 3
In the memory 3, the data and the command are selected from the given command, and the selected data and the command are transferred to the control device 1B of the CPU 1.

The control unit 1B decodes the data and instructions transferred from the memory 3 and gives necessary operation instructions to the arithmetic unit 1A. The arithmetic device 1A performs arithmetic processing on the given data and instructions. The data and the command processed by the CPU 1 are fed back to the memory 3 again, and the result is transferred to the output device 7. In the output device 7,
The transferred result is displayed via a display or the like.

When the CPU 1 performs fetching of instructions of a program stored in the memory 3 and exchange of data,
This is performed through the input / output interface 8, and is performed by an address indicating a stored location or a storage location. The instructions and data extracted from the memory 3 are stored in a dedicated register of the CPU 1 and the instructions and data are exchanged based on the contents.

The CPU 1 starts a program cached in the memory 3 under the control of the OS (operation system) and executes a predetermined task (process). The CPU 1 can perform a multitask that executes a plurality of tasks virtually simultaneously in parallel. CP
Some of the functions of U1 include the function of a memory management device. The memory management device has a function of converting a logical address on the memory 3 designated by a process for reading or writing into a physical address indicating the address of a physical page to be actually read from or written to the memory 3.

The oil delivery instruction system program executed by the CPU 1 according to the OS is started when a process activation request is issued from a process. Although not shown, at first, the activation request identification information such as the program name is converted into an initial setting screen and displayed on the display device.

On the initial setting screen, "telephone order" for inputting a telephone order, "operation" used in daily business, "totaling process", and "accounting" formed by invoicing, balance update, and depositing process The icons of "process" and "end" are displayed. In the “operation”, icons of “preparation for delivery” which is a task to be performed before the delivery business, “post-delivery processing” and “system management” which are tasks to be performed after the delivery are displayed as the next window.

The “preparation for delivery” includes “weather / temperature input” for inputting the weather and temperature of the day as the next window, and “stock ratio setting” of the storage container for storing oils corresponding to each customer. "Delivery vehicles and delivery personnel are assigned to each area, and the delivery instruction data is printed.
"Print", a data file (hereinafter, referred to as a master file) input to the input device 2 and addressed in the relevant data and stored in the memory 3 to the HT "Transfer the master file to the HT", and a delivery instruction H
Each icon of “Transfer delivery instruction to HT” to be transferred to T is displayed.

The “post-delivery processing” includes “read data from HT” as the next window, “daily sales (input / correction)” for correcting the read data and inputting data from a keyboard or the like. The icons “change delivery conditions” for changing the delivery order and delivery conditions, “update forecast inventory”, and “data backup” for performing consumption calculation and inventory forecast are displayed.

The “system management” includes the following windows as containers, members, products, unit prices, areas, vehicles, persons in charge,
Icons for “master file management” for managing master files corresponding to gas stations, messages, consumption tax and light oil tax, “setting for holidays” for setting holidays for delivery, and “accumulated data correction” are displayed.

The container master file is formed from a plurality of data corresponding to each customer, and includes a member code for identifying a member, a container number which is a serial number of the container corresponding to the member, a unit price rank registered in the unit price master file, and an area. Area name registered in the master file, delivery order indicating the order of delivery, and automatic delivery of delivery instructions when the amount of residual oil in the container falls below a preset value Planned delivery ・ Output delivery instructions at specified interval days The delivery category that specifies each delivery mode of spot delivery that outputs delivery instructions by interval delivery / telephone order input, the interval specification that specifies the refueling interval when the delivery category is registered by interval delivery, and the delivery category that is registered by interval delivery The day of the week to specify the refueling day of the case, the container classification to specify the container from the home tank, drum, polycan, etc., registered in the product file Product name, capacity to specify the capacity of the container, final delivery date with the last lubrication date held by the computer as the final delivery date, container residual oil amount to specify the estimated residual oil amount and percentage of the container, and days of container Respective data on the number of remaining days for specifying a few moments and the amount of consumption per day are retained. The final delivery date, the amount of residual oil in the container, the number of remaining days, and the amount of consumption per day are automatically calculated.

The member master file is formed from a plurality of data for each member, and includes a member code for specifying the member,
Name, postal code, address, telephone number, sales category (cash, accounts receivable, ticket) for oil sales, closing date, payment date,
Holds data on payment methods, financial institutions, etc.

The product master file includes a product name, a product category (high-octane / regular / light oil / kerosene / heavy oil / others) for specifying a product to be sold corresponding to each customer, a cash unit price, a credit unit price, and a standard unit price. And data such as purchase unit price.

The unit price master file holds data such as unit price rank, oil type code, cash unit price, and credit unit price corresponding to the type of oil.

The area master file holds data such as an area code, an area name, a code for a person in charge of the area, and a delivery vehicle code for specifying an area into which the delivery area is subdivided.

The vehicle master file holds data such as a vehicle code for specifying a delivery vehicle and a load amount, a vehicle name, a load amount, and the like.

The person in charge master file holds data such as a person in charge code specifying the person in charge and the name of the person in charge.

The gas station master file holds data such as a gas station code and a gas station name for specifying a gas station.

The message master file holds text data of a message to be displayed on the display device.

The consumption tax / light oil tax master file holds the data of the consumption tax rate, the light oil tax amount, and the application date of these taxes. The data held in each of these master files is
You can add, modify, change, delete, and edit them individually. <Description of First Feature> The first feature of this system is shown in FIGS.
This will be described based on the flowchart shown in FIG. Click the operation icon from the initial setting screen → click the post-delivery processing icon → click the forecast inventory update icon.

Then, the initial setting of the predicted stock update is performed (S-1), and the refueling data for each customer (hereinafter referred to as sales) is input from the input device 2 or the HT to the computer main body and stored in the sales table file in the memory 3. (Referred to as data) (S-2). From the input device 2 or the HT, the sales slip number corresponding to each customer as sales data, the number of sales slips issued, the amount of refueling, the refueling date, the refueling time, the discount amount, the number of tickets for payment, and the amount excluding tax -The deposit flag and the like are read.

Next, it is determined whether the sales data from the HT is actually read in the sales table file (S-
3). If the sales data has been read, a data check of the read sales data is performed (S-
4). The sales data is checked by collating with the data stored in the member master file, the container master file, and the product master file. As shown in FIG. 3, sales data to be subjected to data check is searched from the sales table file (S-4-1), and between the customer information included in the sales data and the customer information stored in the member master file. If there is no identity, or if there is an error such as a change in the customer information, the error data is output and then the customer data is deleted (S-4-2). Next, if there is an error between the container information of the sales data and the container information stored in the container master file, the error data is output and then the container data is deleted (S-4-3). If there is an error between the product information of the sales data and the product information stored in the product master file, the error data is output and then the product data is deleted (S-4-4). After these error checks, all the checked data is written from the sales table file to the sales data accumulation table file (S-4-5). When the writing is completed, the data of the customer / container / commodity that has been delivered a plurality of times on the same day is searched, the quantity of refueling is summed up, and the processing is completed with one data (S-4-6). The processing performed in S-4-6 is, for example, in the case where the same customer is refueled twice or more on the same day, the sum of these refueling amounts is set as the refueling amount of the day. is there.

When the check of the sales data is completed, a consumption amount calculation process is performed next (S-5). In the consumption calculation process,
The following processing is performed as shown in FIG. First, sales data to be subjected to consumption calculation is selected from the sales table file (S-5-1), and the selected sales data is set as head data to be processed (S-5-2). Next, it is determined whether the sales data is the end data (S-5-3). If the sales data is not the end data, the sales data is compared with the container master file (S-5-4). Returning to S-5-3, if the processing target data is the end data, the processing ends.
Next, it is determined whether or not the two match by comparing the sales data with the container master file (S-5-5). If the two match, the sales date already stored in the container master file is replaced with the previous sales date. (S-5-6). Then, the final sales date and the sales (refueling amount) quantity are written in the container master file (S-5-7). These final sales dates and sales (fuel refueling) quantities are shown in “Post-delivery”
The data is already stored in the memory 3 by “read data from HT” or “daily sales (input / correction)” displayed as a window next to “.

Next, the daily consumption (B) of the container is calculated. The processing procedure is as follows. The number of days between refueling intervals (A) is calculated from the previous sales date moved in S-5-6 and the current sales date, and this interval days (A) is written into the container master file (S -5-8). Interval days (A)
Is calculated by subtracting a preset customer holiday. The consumption amount is calculated by dividing the sales (refueling amount) quantity (C) refueled this time and input as sales data by the number of interval days (A) ((B) = (C) ÷ (A)) (S −5-
9). When the calculation of the consumption amount is completed, the remaining oil amount (hereinafter, referred to as the stock amount) of the calculated container is set to be full (stock amount = capacity) (S-5-10). When these processes are completed, the process target is set as the next sales data (S-5-11), and the daily consumption is calculated for all containers corresponding to the searched sales data.

When the consumption of all the containers is calculated, all the data of the sales table file so far is cleared (S
-6). If all the data in the sales table is cleared, or the process returns to S-3 and a predetermined message is displayed without the sales data to be processed (S-7), the inventory update process is performed (S-7). S-8).

In the stock updating process, the following two types of selectable processes are performed as shown in FIGS. In the first process shown in FIG. 5, first, a container master file to be subjected to inventory update processing is selected (S-8-A1), and the current delivery date is set to the calendar date for the selected container master file. It is matched (S-8-A2).

Next, for this container master file,
It is determined whether the inventory update processing of the day has already been performed (S-
8-A3). If the inventory update processing has not been performed, the operating container is searched for among the containers registered in the container master file (S-8-A4). Update is performed by subtracting the daily consumption corresponding to these containers already calculated from the inventory amount of all the searched containers (S-8-A).
5). Next, the residual oil ratio (%) of all searched containers
(Hereinafter referred to as a stock ratio (%)) is calculated and updated (S-8-A6). The calculation of the stock ratio (%) is a value obtained by dividing the updated current stock amount (the second residual oil amount) by the capacity corresponding to each container. (Stock ratio (%) = (stock amount / capacity)) ×
100). When the calculation of the stock ratio (%) is completed, an updated flag is set on the calendar (S-8-A).
7). Then, it is determined whether the next day is a holiday (S-8-A).
8) If the next day is not a holiday, after displaying a processing end message (S-8-A9) or S-8-A
3 and if the inventory update process has already been performed, after displaying the processed message (S-8-A1)
1), end the process.

If the next day is a closed day, the delivery is not performed on the next day, so the container master is updated for the closed day. The calendar date is set to the next day for date addition processing (S-8-
A10), returning to S-8-A3 and repeating the processing.

In the second process shown in FIG. 6, first, a container master file to be subjected to inventory update processing is selected (S-
8-B1), it is determined whether the next day is a holiday on the holiday calendar file (S-8-B2). If the next day is a holiday, it is determined whether the holiday is a consecutive holiday (S-8-B).
3) If it is a consecutive holiday, the stock update date is set as the last holiday of the consecutive holiday (S-8-B4).

Returning to S-8-B2, if the next day is not a holiday, the stock update date is set to today (S-8-B5).
Also, returning to S-8-B3, if the holiday is not a consecutive holiday, the stock update date is set to the next day (S-8-B6).

When these inventory update dates are specified, the inventory update dates are written to all data in the container master file (S-8-B7). Next, the container data to be processed first is set as the head data (S-8-B8). It is determined whether the processing target is the end data (S-8-B9), and if it is the end data, the process returns to end the inventory update processing.

If it is not the end data, the subtraction interval days (D) are calculated from the sales date and the stock update date (S-8-).
B10) The pause period (E) in the container subtraction interval period is calculated (S-8-B11). When these calculations are completed, the amount of oil subtraction (F) is calculated as (F = consumption per day (B)
× ((D)-(E) +1)) (S-8-
B12). Next, the current stock amount (second residual oil amount) is calculated by (stock amount = container capacity−subtraction amount (F)) (S-8-B).
13) The stock ratio (%) is calculated (S-8-B14).
The calculation of the stock ratio (%) is a value obtained by dividing the updated current stock amount by the capacity corresponding to each container. (Stock ratio (%) =
(Stock amount / capacity × 100). When the calculation of the stock ratio (%) is completed, the processing target is set to the next data, and S-8-
Returning to B9, the process is repeated. The inventory update processing is completed for all the container data by the first and second processing procedures, and the task (process) ends when the processing result is stored in the memory 3.

<Description of Second Feature> The second feature of the present system will be described with reference to the flowcharts shown in FIGS. Click the operation icon from the initial setting screen → click the delivery preparation icon → click the stock ratio setting icon.

Then, as shown in FIG. 7, the initial setting of the stock ratio is performed (S-10), and a stock ratio setting screen (not shown) is displayed on the display.

First, the delivery date is manually input on the initial screen for setting the stock ratio (S-11). For this delivery date, enter the day of the same day delivery according to the calendar. When the delivery date is input, the planned delivery data is extracted (S-1).
2). As shown in FIG. 8, the extraction of the planned delivery data is performed as shown in FIG. 8 on the initial screen for setting the stock ratio (%). ) Is input (S-12).
-1). The required ratio (%) refers to the minimum parameter (judgment standard) required for refueling corresponding to each container.
It can be set between 100%. Required ratio (%)
Is set, the program accesses the container master file (S-12-2) and selects a plurality of container data targeted for the planned delivery specified in the delivery section (S-12).
-12-3).

The current stock ratio (%) calculated from the above-mentioned (stock ratio (%) = stock amount / capacity × 100) is equal to or less than the set necessary ratio (%) from the plurality of selected container data. Is extracted (S-12-4).

Next, it is determined in S-12-4 whether container data corresponding to a stock ratio (%) lower than the required ratio (%) actually exists (S-13). If there is container data, the delivery quantity is totaled and output for each delivery area (hereinafter referred to as an area) where the delivery destination is divided into areas of a required size (S-14), and the delivery vehicle and the delivery vehicle are identified for each area. A delivery person is assigned (S-15). When these processes are completed, an output control command for outputting a delivery instruction from the output device 7 is output (S-16). When the output of the output control command is completed and the process returns to S-13, if there is no container corresponding to the same day delivery, a message to that effect is displayed on the display device, and the task (process) ends.

Also, unlike the required ratio (%), the stock amount (first residual oil amount) necessary for refueling is set in advance, and the day is calculated by (stock amount = container capacity−subtraction amount). It is also possible to extract container data whose stock amount (second residual oil amount) is equal to or less than the set first residual oil amount.

Although not shown, the delivery instruction output from the output device 7 includes a delivery date, an area code, an area name, a product code, a product name, an estimated refueling amount, a delivery vehicle code, a delivery vehicle name, and delivery. The person in charge code, the name of the person in charge of delivery, the member code, the member name, the estimated quantity, the location guide, and the comment are printed. Shipping instructions are printed out for each area, and if one member has multiple containers,
Displayed by container. In addition, they are printed out in the order of delivery.

Next, in this program, another planned delivery instruction output shown in FIG. 9 is also performed in setting the stock ratio (%). Click the operation icon from the initial setting screen → click the delivery preparation icon → click the stock ratio (%) setting icon.

Then, initial setting of the stock ratio (%) is performed (S-20), and a screen for setting the stock ratio (%) is displayed on the display. The delivery date is manually input on the initial screen for setting the stock ratio (%) (S-21). When the delivery date is input, the order data of the container scheduled to be delivered on the same day (spot delivery) ordered by telephone is extracted (S-2).
2). In parallel with the telephone order, the interval delivery container is automatically calculated, and the interval delivery data to be delivered is extracted from the container master file (S-23). The interval delivery containers are registered in the container master file in advance, and are extracted based on an interval delivery instruction for delivering at a predetermined interval date.

When the process of extracting the order data and the interval delivery data is completed, the planned delivery data that specifies the planned delivery in the delivery category is extracted (S-24). The extraction of the planned delivery data is performed according to the processing procedure shown in FIG.
Next, it is determined whether the order data, interval delivery data, and planned delivery data actually exist (S-25). If such data exists, the delivery quantity is totaled and output for each delivery area (S-27), and a delivery vehicle and a delivery person are assigned to each area (S-28). When these processes are completed, an output control command for outputting a delivery instruction from the output device 7 is output (S-29). When the output of the output control command is completed and the process returns to step S-25, and there is no container corresponding to the same-day delivery, a message to that effect is displayed on the display device (S-26), and the task (process) ends.

In this system, although not shown, in the totaling process, the sales results are totaled by the whole company, totaled by delivery vehicle, totaled by delivery person, totaled by area, totaled by gas station, totalized by member, totaled by product.・ It can be divided into totals by sales representatives. These totaled results can also be displayed in a graph. For example, the correlation between the temperature on the delivery day and the delivery amount, the correlation between the delivery amount and the delivery vehicle, and the correlation between the delivery amount and the delivery staff can be represented in a graph.

[0064]

According to the present invention, the daily consumption of containers held by a customer and corresponding to each customer can be calculated in the course of performing daily sales processing, so that inventory management for the customer can be performed in real time. Can be. By performing inventory management, information such as the amount of refueling required for refueling at the time of delivery can be obtained.

By performing delivery based on the output delivery instruction, physical, human, and costly waste can be reduced, the availability of the delivery staff and delivery vehicles can be improved, and efficient delivery can be performed. Can be. In addition, since a delivery plan can be made in advance, a significant cost reduction of the delivery operation can be realized.

[Brief description of the drawings]

FIG. 1 is a block diagram showing an apparatus for executing an oil delivery instruction system.

FIG. 2 is a flowchart showing the operation principle when the present program performs an inventory calculation process.

FIG. 3 is a flowchart showing the operation principle when the present program performs data check.

FIG. 4 is a flowchart showing the principle of operation when the present program performs a consumption calculation process.

FIG. 5 is a flowchart illustrating the principle of operation when the program performs an inventory update process.

FIG. 6 is a flowchart illustrating another operation principle when the program performs an inventory update process.

FIG. 7 is a flowchart showing the principle of operation when the program outputs a planned delivery instruction.

FIG. 8 is a flowchart showing the principle of operation when the present program extracts planned delivery data.

FIG. 9 is a flowchart illustrating an operation principle when the present program outputs a delivery instruction.

[Explanation of symbols]

 Reference Signs List 1 central processing unit 2 input device 3 main storage device 4 auxiliary storage device 5 communication control device 6 terminal device 7 output device 8 input / output interface

Claims (9)

[Claims] 1. An oil delivery instruction system for issuing an oil delivery instruction by a programmed computing device, the system comprising: a plurality of oil storage containers installed at a customer; Capacity data indicating a large amount, refueling date data specifying the date of refueling the container, refueling amount data specifying the refueling amount on the refueling day, and a minimum residual oil amount (first residual oil amount) preset in the container Refueling data input means for inputting refueling data consisting of remaining amount data indicating the last refueling date and the most recent refueling date, and calculating the number of days between refueling, and dividing the amount of refueling on the last refueling day by the number of refueling days. Consumption calculation means for calculating the calculated value as the daily consumption of the container, and subtracting the accumulated value of the consumption up to the day from the input capacity data to obtain a residual oil amount (second residue) on the day. Oil amount), a container having the second residual oil amount equal to or less than the first residual oil amount is selected from the plurality of containers, and a refueling container specifying means for specifying a container to be refueled on the day is specified. Holding means for holding the refueling data and the data on the consumption amount and the refueling container on the day; display means for displaying the contents held by the holding means; and contents held by the holding means. An oil delivery instruction system, comprising: an output unit for outputting. 2. The method according to claim 1, wherein the consumption calculating means includes means for calculating the consumption amount by subtracting the day from the refueling interval days when the customer does not use the oil when there is a day when the customer does not use the oils. Item 8. The oil delivery instruction system according to Item 1. 3. The refueling data input means includes means for inputting a refueling requirement ratio (%) as a criterion for determining whether or not the next refueling is required in each of the containers. A means for calculating a value obtained by dividing the residual oil amount (second residual oil amount) on the day by the capacity of each of the containers as a residual oil ratio (%); 3. The oil delivery instruction system according to claim 1, further comprising means for selecting the container whose ratio (%) is equal to or less than the required ratio (%). 4. The refueling data is at least one of delivery area data for dividing a delivery destination into an area of a required area, delivery vehicle data for specifying a delivery vehicle, and delivery clerk data for specifying a delivery clerk. The day-of-the-day refueling container specifying means includes at least one of a means for totalizing a delivery amount of oil for each area, a means for allocating the delivery vehicle for each area, and a means for allocating the delivery person for each area. The oil delivery instruction system according to any one of claims 1 to 3, including one. 5. The refueling data input means includes a terminal device for transmitting the refueling data via a communication line and receiving the contents held by the holding means. The oil delivery instruction system according to any of the above. 6. A readable recording medium on which a program for instructing oil delivery by a computing device is recorded, wherein the container is provided with a plurality of oil storage containers installed at the customer. Capacity data indicating the maximum possible amount, refueling date data specifying the day of refueling the container, refueling amount data specifying the refueling amount on the refueling day, and a minimum residual oil amount preset in the container (first residual amount) Refueling data input means for inputting refueling data comprising remaining amount data indicating the amount of oil remaining), calculating the number of days of refueling intervals from the last refueling date and the most recent refueling date, and calculating the amount of refueling on the last refueling day by the refueling interval. Consumption amount calculating means for calculating a value obtained by dividing the number of days as a daily consumption amount of the container; and a residual oil amount of the day by subtracting a cumulative value of the consumption amount from the input capacity data until the day. (A second residual oil amount) is calculated, and a container in which the second residual oil amount is equal to or less than the first residual oil amount is selected from the plurality of containers to specify a container to be refueled on the same day. Refueling container specifying means, holding means for holding the refueling data, the consumption amount, and data relating to the refueling container on the day, display means for displaying the contents held by the holding means, and holding means for holding And a readable recording medium that records a program for executing an output unit that outputs the contents. 7. When the customer has a day when the oil is not used, a program for executing the consumption calculation means for subtracting the day from the refueling interval days and calculating the consumption amount as the refueling interval days is recorded. A readable recording medium according to claim 6. 8. The refueling data input means for inputting a required refueling ratio (%) as a criterion for determining whether or not the next refueling is required in each of the containers; The consumption amount calculating means for calculating a value obtained by dividing the oil amount) by the capacity of each container as a residual oil ratio (%); and the container in which the residual oil ratio (%) is equal to or less than the required ratio (%). 8. The readable recording medium according to claim 6, wherein a program for executing the day-of-the-day refueling container specifying means for selecting a program is recorded. 9. The refueling data for inputting at least one of delivery area data for dividing delivery destinations into areas of a required area, delivery vehicle data for specifying delivery vehicles, and delivery clerk data for specifying delivery personnel. Input means, the day-of-the-day refueling container specifying means, the means for totalizing the delivery amount of oils for each area, the means for allocating the delivery vehicle for each area, and the means for allocating the delivery person for each area 7. A program for executing at least one refueling container specifying means for specifying at least one refueling container is recorded.
A readable recording medium according to claim 8.