JP2012232841A - Portable delivery system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a delivery system for a liquefied petroleum gas container, which designates delivery timely and appropriately and guarantees efficient delivery in a wide area.SOLUTION: The delivery system generates daily delivery data at each depot, that is, the total of data on the kind and number of gas cylinders delivered toward each depot from a charging place and data on the kind and number of remaining gas cylinders not delivered at each depot on the previous day, and generates delivery data classified by delivery persons in which the delivery data is assigned to each delivery person who is in charge of the delivery from the depot. The delivery system responds to access from a cellular phone of the delivery person and transmits the delivery data for the delivery person, and updates database in the delivery system based on work data at a customer home to which the gas cylinder has been actually delivered on that day and the data on the remaining gas cylinders not delivered. The delivery data downloaded by the delivery person is transmitted to a car navigation system, whereby the location of a customer home to which the gas cylinder is scheduled to be delivered on that day is displayed on a map. Thus, the delivery data is used as data that supports the delivery by the delivery person.

Description

  The present invention relates to a liquefied petroleum (LP) gas container delivery system. More specifically, the present invention sorts the daily delivery data of a predetermined area that is sorted and grouped based on the zip code associated with the customer as daily delivery data for each delivery person according to the delivery ability of the delivery person. The present invention relates to an LP gas delivery system that delivers via a delivery person's mobile phone and receives delivery result data.

  Conventionally, many mechanisms for improving the efficiency of delivery of LP gas containers have been proposed (see Patent Document 1). In addition, LP gas was delivered to each customer's home after filling the gas cylinders in various containers at each filling plant with the gas delivered from the primary base to various filling factories at each filling plant. In addition, each delivery person in charge of delivery has a fixed delivery area in charge (fixed area system). Under this mechanism, conventionally, the center system predicts the remaining amount of gas cylinders at each customer's house based on the past gas consumption record, meter reading data, container delivery record, etc. at each customer's house, and schedules the next delivery. Was calculated. Then, based on the calculated delivery schedule, the center system issues a delivery slip (container management slip) for one week after the reference date with 10 days ahead as the reference date, and sends the delivery slip to the filling factory as each delivery base. Was sent.

  At each delivery base, the delivery person receives the delivery slip for each delivery person sorted by the delivery manager, and based on the received delivery slip, the delivery schedule such as from which customer to go is determined by himself. At the time of actual delivery, after delivery of the LP gas container, the delivery person hand-writes the delivery date, meter pointer for the day, container company number, and security check items on the delivery slip and submits it to the delivery manager. The amount per person was also very large. The returned delivery slip was checked by the delivery manager for omissions and then entered into the system by a key puncher at the calculation center. The next scheduled delivery date is determined based on the data of the delivery slip input in this way.

  In addition, the fixed area system has a feeling of unfairness due to the occurrence of a gas shortage (zero gas cylinder remaining) due to an increase in the load on delivery personnel due to an increase in customers in the area in charge, and the proximity of the distance from the filling station in the delivery area. However, problems such as difficulty in obtaining holidays due to fixed areas in charge and inefficiencies such as delivery of substitutes due to delivery leave and vacancy while looking at the map occurred.

  In addition, when delivering a delivery slip for one week 10 days ahead, the delivery person delivers the same day to the customers who are adjacent in his fixed area, ignoring the scheduled delivery date calculated by the center system. There was a risk of personal information leaking when a delivery slip containing personal information was lost.

  In order to change the mechanism of such work, in recent years, filling operations at gas cylinder filling stations in various places are collectively performed at the primary base, thereby making the filling factories in each place into container storages (hereinafter referred to as “depots”). At the same time, several areas of conventional delivery personnel are gathered and set as one area, and a transition to an area rotation system in which a plurality of delivery personnel form a team and take charge of the delivery area sequentially by rotation is performed. I came.

  Some attempts have been made to use the handy terminal to save labor, but the handy terminal itself is an expensive device, and at the time of loss, there was a risk of losing a large amount of customer data. Moreover, the handy terminal had to actually come to the sales office to update the data, and lacked real-time information.

  On the other hand, a barcode that provides information about a product, and a two-dimensional code of a pattern composed of white and black dots that can provide more information than a barcode are read, and the barcode or two-dimensional code is read. In recent years, mobile phones having a function of displaying information specified by a code have become popular.

JP-A-8-329159

  Under the area rotation system, each delivery person's delivery area changes day by day, so it was necessary to provide a system that provides delivery instructions in a timely and appropriate manner and ensures efficient delivery in a wide area. In addition, even if containers are transported from the primary base to the depot by trailer and are delivered individually from the depot to the customer's home, if a planned individual delivery is difficult, a considerable number of spare containers must be placed in the depot. As a result, there was a risk of over-spec, as the workers had to be always manned depots. Furthermore, when a delivery instruction is issued using a mobile phone, it is necessary to be able to process all operations performed by each delivery person from the mobile phone. In order to solve these needs and problems, the portable delivery system according to the present invention performs the processing described below.

  The center system predicts the remaining amount of gas cylinders of each customer based on the gas consumption results of each customer acquired by monthly gas meter reading, information on installed equipment, and the previous container delivery results, etc. Calculate the customer's next scheduled delivery date. The center system transmits only the delivery data whose calculated delivery date is the next day to the mobile phone in response to access from each delivery person's mobile phone after a predetermined time (for example, evening). On the other hand, the number of deliveries for the next day to be prepared for each depot is calculated by the center system after taking into account the number of remaining deliveries for the day ascertained by the center system. The center system notifies the hub base filling station that the number obtained by subtracting the number of delivery balances for the day from the number to be prepared for each depot is the number of data to be transported to the depot. As a result, the number of gas cylinders to be transported to each depot is loaded onto the trailer and transported to each depot at midnight.

  The delivery data sent to each delivery person's mobile phone is sorted by the system based on the postal code in the area in charge of each depot, and then according to the delivery ability of the delivery person (hereinafter referred to as "rank") It is automatically assigned to each delivery person. In order to secure the above-described area rotation system, the order of allocation to delivery personnel is updated daily.

  Since the system according to the present invention has data indicating the distance from the depot in charge of delivery, the delivery data transmitted to the delivery personnel is sorted in the order from the starting depot as the initial state. Yes. In addition, when the gas cylinders to be delivered on the day cannot be loaded into the delivery car at a time, the delivery data includes a standard way of delivering in the first car and the second car (for example, one car Customer's home in the area close to the depot in the eyes, customer home in the area far from the depot in the second car, etc.). Then, the delivery data received by the delivery person's mobile phone is transferred to the car navigation system (hereinafter referred to as “car navigation”), and displayed on the car navigation map including the route around the delivery point. This allows the delivery person to load the required LP gas container in the first car shown in the delivery data every morning at the depot and start the delivery according to the efficient route shown by the system according to the present invention. It becomes.

  Each time the exchange of the gas cylinder delivered at each customer's home is completed, the delivery person transmits an operation end input including a gas meter pointer and a security check result to be performed when the container is exchanged to the center system via the mobile phone. Since the container number of the replaced container can be obtained by reading the barcode attached to the container using the code reader function of the mobile phone, the system according to the present invention can perform container management of the gas cylinder. When the first car is over, the delivery person returns to the depot, unloads the empty container, loads the necessary container in the second car indicated by the delivery data, and continues the delivery operation.

  As described above, since the delivery status of each delivery person is sent to the center system in real time every time delivery to the customer's home is completed, the customer who did not send delivery completion by the predetermined time of the day Is automatically carried over tomorrow's delivery schedule data. In addition, since the system can automatically determine the number of unreserved gas cylinders in the depot from the delivery status transmitted from each delivery person's mobile phone, the remaining number is calculated from the number of containers scheduled for delivery the next day. The system automatically subtracts and instructs the hub base filling station. Thereafter, containers are transported from the filling station to each depot, but the trailer takes home empty containers at each depot as return flights to the filling station.

  According to the present invention, a delivery data generation and delivery system that supports an area rotation system can be provided. Under the area rotation system, since the delivery area of the delivery person expands, the present invention provides a system function that supports delivery, that is, allocation of delivery data sorted by zip code to the delivery person, first car / 2 Provides clear loading data, automatic setting of standard delivery routes and efficient delivery by linking delivery data and car navigation, etc. As a result, efficient delivery under the area rotation system Can be realized. In addition, the present invention makes it possible to carry out all operations on the delivery person's site (security inspection at the time of container replacement, reading of the meter pointer / container number of the exchange container, etc.) with a mobile phone, and to the rank of the delivery person. There is also an effect that the remaining delivery can be reduced as a result of the appropriate delivery allocation based on it. Furthermore, accurate container management in the depot can be realized by the system by grasping the planned delivery and the remaining delivery in real time.

  In addition, as another effect of the present invention, (1) the unfairness of the delivery area of each delivery person due to the distance from the depot can be resolved, (2) a plurality of delivery persons are arranged in the delivery area, Be able to respond quickly to vacations and vacancies, (3) Be able to respond to the sudden increase in customers in the delivery area by adding only delivery personnel, and (4) Only the delivery data for the next day is delivered to the delivery personnel. Arbitrary container management can be prevented, and as a result, the remaining rate of containers can be reduced and delivery costs can be reduced. (5) Rain can be achieved by using a mobile phone for all operations without using paper slips. Improved work efficiency and quality at the time, and (6) Delivery personnel can input directly at the site, so there is no exchange of delivery management slips (paper), confirmation by delivery manager and input by key puncher No work required As a result, labor costs can be greatly reduced. (7) Data related to delivery and delivery personnel can be grasped in real time, and appropriate delivery personnel management can be facilitated. (8) All operations can be used for all purposes. Because it can be done with a mobile phone, the capital investment is low, and since the delivery person inputs data directly from the site via the network, there is almost no increase in fixed costs even as the number of customers increases. (9) Since the delivery plan can be generated on the previous day after the number of deliveries in each area is calculated, the container transportation to the depot is also made efficient. (10) In the conventional delivery base, the place for the filled gas cylinders Since each delivery person had to transport the containers necessary for their delivery to the vehicle, the trailer platform will be used as a container place in the depot. It was alongside a delivery vehicle capable of loading can be directly effects etc. Also obtained.

It is a figure showing the outline of the center system concerning the present invention. It is a flowchart which shows the outline | summary of the process performed in relation to a delivery system. It is a detailed flowchart of a delivery data generation process. It is a figure which shows an example of a customer master. It is a figure which shows an example of an area master. It is a figure which shows an example of a gas consumption performance amount table. It is a figure which shows an example of delivery data. It is a detailed flowchart of a delivery data allocation process. It is a figure which shows an example of a person in charge master. It is a detailed flowchart of a delivery data download process. It is a figure which shows an example of the downloaded delivery data. It is a figure which shows the detailed flow of a delivery completed data transmission process. It is an example of the screen displayed on the display of a mobile telephone. It is a figure explaining a system configuration.

  Hereinafter, exemplary embodiments of the present invention will be described in detail. It should be noted that the embodiments described in the present specification are merely examples, and the present invention is not limited to the embodiments, and various modifications are possible. In addition, the method, function, and means described in the embodiment can be implemented as a computer-executable program, or can be implemented as a computer-readable recording medium that stores the program. .

<Center system>
FIG. 1 is a diagram showing a center system (basic system) 100, a mobile phone 110 of each delivery person, and a car navigation system 120 of a delivery vehicle included in the mobile delivery system according to the present invention. The center system 100 is connected to a plurality of mobile phones 110 via a network 130, and the mobile phone 110 can communicate with the car navigation system 120 using a short-range wireless communication technology (for example, Bluetooth). The mobile phone 110 can be a well-known mobile phone having a barcode and two-dimensional code reading function. The car navigation system 120 receives the address data of the delivery address (including GPS information such as the latitude and longitude of the customer's house acquired in advance) from the mobile phone 110 and clearly indicates the address on the map displayed on the display ( For example, a flag is set). The network 130 may be a well-known network such as a local area network (LAN), the Internet, and a cellular network.

  The center system 100 includes a delivery system 101, a meter reading / billing system 102, and a security system 103. FIG. 1 shows that the center system 100 includes three systems 101 to 103 inside, but the three systems 101 to 103 exist independently, and each system 101 to 103 is centered via a network. A configuration connected to the system 100 may be used.

  Hereinafter, after an outline of the delivery system 101, the meter reading / billing system 102, and the security system 103, the delivery system 101 according to the present invention will be described in detail.

<Delivery system>
The delivery system 101 is a daily delivery for each depot that is the sum of the data of the type and number of gas cylinders delivered from the filling station to each depot and the data of the type and number of remaining gas cylinders in each depot the previous day. Data is generated, and delivery data for each delivery person assigned to each delivery person in charge of delivery from the depot is generated.

  In addition, the delivery system 101 transmits delivery data for the delivery person in response to the access from each delivery person's mobile phone, and the work data and delivery residuals of the customer's home that was actually delivered on that day. A database (DB) in the delivery system 101 is updated based on the data. The delivery data downloaded by each delivery person is transmitted to the car navigation system 120 so that the location of the customer's home scheduled to be delivered on the day is displayed on the map and is also used as data for supporting delivery of the delivery person.

  Hereinafter, processing executed by the delivery system 101, the mobile phone 110, and the car navigation system 120 will be described with reference to FIG. FIG. 2 is a flowchart showing an outline of processing performed in relation to the delivery system 101. This processing flow is performed every day.

  In step S201, the delivery system 101 records data of customer premises under the jurisdiction of each depot (for example, history information of gas usage acquired by monthly gas meter reading, installed equipment information, past container delivery results, And the schedule data input by the person in charge of the depot), the remaining amount of gas cylinders of each customer is predicted, and the next delivery date for each customer is calculated. The delivery system 101 totals the data of the customer's home whose first delivery date is the next day (first delivery data) and the remaining delivery data of the previous day (second delivery data) in each depot, and the next day of each depot. Generate delivery schedule data. In other words, the delivery schedule data is composed of the first delivery data and the second delivery data of each depot, and includes only the data of the customer's home that is to be delivered the next day. Further, the type and number of gas cylinders indicated by the first delivery data are actually delivered by trailer from the filling station to each depot.

  In step S <b> 202, the delivery system 101 performs delivery data assignment processing for assigning delivery schedule data (first delivery data and second delivery data) of each depot to a delivery person who actually works. The delivery system 101 first performs a process of rearranging customer homes that are close in distance by sorting based on the zip code data of each customer home included in the delivery schedule data. Next, the delivery system 101 acquires the data of the delivery person who is scheduled to work the next day among the delivery persons of each depot from the person-in-charge master 900, and the delivery schedule data of each delivery person according to the rank of the acquired delivery person. The process of assigning as (third delivery data) is performed. In addition, in order to ensure the area rotation system mentioned above, the allocation order to a delivery person is updated every day.

  In addition, the delivery system 101 sorts the third delivery data in the order from the depot by using data indicating the distance from the depot for each customer house. Further, when the gas cylinders to be delivered on the day cannot be loaded at the same time with the loading capacity of the delivery vehicle used by the delivery person, the delivery system 101 divides the third delivery data into the first and second vehicles. The first car and second car are classified according to the standard way of delivery (for example, the customer car in the area near the depot in the first car and the customer in the area far from the depot in the second car). Home, etc.).

  In step S <b> 203, the delivery system 101 performs processing for identifying the accessed delivery person for access from each mobile phone 110, and carries only the delivery schedule data (third delivery data) of the identified delivery person. Deliver to phone 110. The third delivery data downloaded to the mobile phone 110 is used as a delivery plan for the delivery person on that day.

  In step S204, the delivery schedule data of each delivery person can be transmitted to the car navigation system 120 of the delivery vehicle using the short-range wireless communication technology. The car navigation system 120 uses the customer house address data (postal code, address, and GPS information such as the latitude and longitude of the customer house, etc.) included in the received delivery schedule data on the map displayed on the display. Display the location of the customer's home, including the route around the landmarks such as flags. As described above, since the customer premises are sorted according to the postal code information, the area handled by each individual delivery person is a geographically gathered area, and therefore, a standard and efficient delivery route via the car navigation system 120. Provision is possible.

  When delivery to the customer's home is actually performed in step S205, the delivery person performs predetermined actions such as replacement of gas cylinders, confirmation of gas meter guidelines, and security work such as confirmation of equipment. In step S <b> 206, the delivery person selects the delivery data of the customer's home on the mobile phone 110 and transmits the result of the predetermined action to the delivery system 100 via the mobile phone 110. In addition, the container number of the replaced container can be read using the barcode reader function of the mobile phone 110 from the barcode attached to the container, and efficient and error-free container management can be performed. it can.

  In step S207, the delivery system 100 updates the database based on the delivery data to the customer's home received from each mobile phone 110, the meter guideline value, and the data of the security work result.

<Measuring and billing system>
The meter-reading / billing system 102 receives the gas usage (numerical information) indicated on the meter at the customer's home via the cellular phone 110 of the meter-reader, and receives the received gas usage and the previous meter reading at the customer's home. Billing data is generated based on the gas usage. The meter reading / billing system 102 accumulates the amount of gas used in the current month together with information on the date of meter reading. The gas usage amount and meter reading date information of the current month are used when the delivery system 101 generates a delivery schedule. It should be noted that “meter reading” in the present specification is for confirming the amount of gas used every month by a meter and making a bill, and is noted that the above-described delivery of the gas cylinder is performed separately.

<Security system>
The security system 103 stores information such as facility information of the customer's home, maturity information of the facility, predetermined survey items determined for each region, and security performed at the customer's home from the mobile phone 110 of the security officer. The work information is received and the information is updated. The security work information includes at least the gas use amount indicated on the meter at the customer's house and information on the mechanical equipment such as the installed fan heater. In addition, the security system 103 provides given information to the mobile phone 110 of the security officer, and supports work at the customer's home of the security officer. In this specification, “security” refers to inspection work of equipment and equipment installed at customer's homes, and its implementation is statutory, and is performed separately from the delivery of the gas cylinder described above. Please note that.

  The security system 103 has machine facility information of each customer's house, gas usage, and information on the date of reception of the gas usage. These data are used when the delivery system 101 generates a delivery schedule. At the time of security work, GPS information (latitude / longitude) of the customer's house is acquired and stored in the security system 103.

  Hereinafter, details of processing performed in each flow described with reference to FIG. 2 will be described.

<Delivery data generation process>
FIG. 3 is a detailed flowchart of the delivery data generation process described in step S201, and is a diagram illustrating a process for generating delivery schedule data on the next day of each depot.

  In step S301, the delivery system 101 generates customer data 400 (FIG. 4), area master 500 (FIG. 5), and gas consumption record table 600 (FIG. 6) in order to generate delivery data as illustrated in FIG. ). Here, the database to be read will be described with reference to FIGS.

  FIG. 4 illustrates the customer master 400. Customer master 400 includes customer ID, name, zip code, block, address, contact information, GPS information, meter identification number, previous delivery date, scheduled delivery date, schedule guideline, installation container type, number of installation containers, sales office code ( Area code), group code, special notes, and delivery person memo. The block is a value indicating the distance from the depot, and is information that can be used when specifying the first and second vehicles in the order of delivery, and a plurality of predetermined levels are set according to each area. Can do. The GPS information is information measured when the gas meter is installed at the customer's home, and is acquired via the security system 103. The meter identification number is a number for identifying a meter installed in each customer's house. The previous delivery date indicates the date of delivery to the customer's home most recently. The next scheduled delivery date is stored as the scheduled delivery date. Usually, date information is registered in the customer data to be delivered the next day in the daily delivery data generation process. However, if there is a data update from the deliverer to change to another schedule due to various circumstances, the designated date information is registered. The schedule guideline is an expected value of the meter at the time of delivery. The type of installed container and the number of installed containers indicate the type of container at the customer's house (50 kg, 30 kg, 20 kg, etc.) and the number of gas cylinders. The sales office code and the group code indicate a group of sales offices (that is, areas) and delivery persons to which the delivery persons in charge of the customer's home belong. The sales office and the group may coincide with each other, and in the case of a sales office having a relatively large area, there may be a plurality of groups in the sales office.

  FIG. 5 illustrates an area master 500. The area master 500 includes a zip code, a group in charge, an allocation priority order, and an area name, and indicates which group the area indicated by the zip code is in charge of. The assignment priority order is information that can be used when assigning the first car or the second car. The block of customer master 400 can be used to show details of distance from a depot in the area, and the allocation priority order only shows the distance from the depot in the area for each zip code. Used when good. In other words, the allocation of the first car and the second car at the time of delivery can be used either in the block of the customer master 400 or in the priority order of the area master 500 allocation, and can be properly used according to the circumstances of the area.

  FIG. 6 illustrates a gas consumption performance amount table 600. The actual gas consumption amount table 600 includes a customer ID, an information source, a meter identification number, a date, a guideline, and a consumption amount. The customer ID and meter identification number are the same as the customer ID and meter identification number of the customer master 400, and the information source is information indicating in which of the operations of delivery / meter reading / security is registered. And the information of the gas meter guideline at that time and the information of consumption that is a difference from the latest data are included for each date when the information is acquired.

  Returning to the flowchart of FIG. In step S <b> 302, the delivery system 101 sequentially reads customer data one by one from the customer master 400, and searches the previous gas delivery data table 600 from the customer's gas consumption record table 600. In the example of FIG. 6, there is data at the time of delivery on December 27, 2010 for the customer ID: A111-1111, and the guideline at that time is 59.2. Next, the delivery system 101 identifies the type and number of containers installed at the customer's home from the customer master 400, calculates the gas consumption actual amount after delivery from the gas consumption actual amount table 600, and the previous year. Identify actual gas consumption at the same time. Further, the delivery system 101 identifies the rate of increase / decrease (for example, an increase of 3%, a decrease of 5%, etc.) in the same month of the previous year and the following month for the identified gas consumption amount in the same period of the previous year. As a result, when the predetermined standard is satisfied, the delivery system 101 specifies that delivery to the customer's home should be performed on the next day.

  For example, if the container installed at the customer's home is 50 kg and there is only one container, the total value of the actual gas consumption after delivery is within a predetermined reference value range (for example, the remaining gas in the container). When the volume ratio is 12% to 7%, etc., and the remaining amount of gas in the container is less than the standard value range from the actual gas consumption volume in the same period of the previous year and the above increase / decrease rate It is determined that delivery to the customer should be performed.

  As will be described later, since the delivery system 101 can obtain the actual meter guideline information from the mobile phone 110 at the time of delivery to each customer's home, the generated delivery schedule data and the actual guideline information In contrast, the range of the reference value such as the gas remaining rate in the container can be automatically changed based on a certain number of samples or more. For example, if it is determined that replacement is required at the time of delivery schedule generation, but there are actually many samples with a high gas remaining rate, the reference value is automatically set to 11.5% to 6.9%, etc. It is also possible to change to. In such a case, the delivery system 101 can also set different fluctuation rates for the upper limit value and the lower limit value of the reference value from the viewpoint of preventing the gas cylinder from running out of gas.

  In another embodiment, it is also possible to calculate the scheduled delivery date based on the equipment information of the customer's home acquired by the security system 103 in addition to the actual gas consumption amount. For example, if a heater or fan heater is newly installed after the previous delivery date, information on the net amount of gas used by the heater or fan heater (for example, 5% increase over conventional devices) is known. It is also possible to use this information when calculating the estimated delivery date.

  In step S303, the delivery system 101 sets the customer master 400, the area master 500, and the actual gas consumption amount as data items excluding the person-in-charge code among the items of the delivery data 700 shown in FIG. Data acquired from the table 600 is set. The person-in-charge code is set in the process described with reference to the flowchart of FIG. The delivery data generated in this step corresponds to the first delivery data described above. Here, the delivery data 700 of FIG. 7 will be described.

  As illustrated in FIG. 7, the delivery data 700 includes a slip ID, a sales office code, a group code, a person in charge code, a delivery order, a customer ID, a postal code, a block, an address, a name, a contact information, GPS information, and the latest information. Scheduled date, schedule guideline, delivery guideline, previous meter reading date, previous meter reading guideline, previous delivery date, previous delivery guideline, meter identification number, replacement container type, number of replacement containers, special notes, deliveryman memo, delivered flag , And other data items. Since the delivery data 700 is generated by setting data obtained from another database, it is possible to include data items other than those illustrated in FIG. The slip ID is an identification code of delivery data. The block is a value indicating the distance from the depot. The delivery order is a delivery order determined by the delivery system 101 based on a zip code or a block. The delivery completion flag is a flag indicating that delivery by the delivery person has been completed.

  As will be described in this specification, a schedule once generated cannot be arbitrarily changed depending on the convenience of a depot administrator or a delivery person. If the delivery system 101 can identify that the delivery has not been completed on the day, the delivery system 101 can recognize that the delivery has not been completed, based on the value of the delivered flag. In other words, if the date can be changed to an arbitrary date for the convenience of the administrator or the delivery person, there is a risk of delivery on a date significantly delayed from the scheduled delivery date predicted by the delivery system 101, in which case the customer This is because a gas shortage may occur at home.

  In step S304, the delivery system 101, among the delivery data shown in FIG. 7, is the delivery target data for the day and the delivery residual data for the day (ie, the above-described second data) that is data indicating that the delivery flag is incomplete. Data).

  In step S305, the delivery system 101 combines the delivery data of steps S303 and S304, and then sorts the data based on the sales office code, group code, and postal code.

  As described above, the delivery schedule data generated in the flow chart of FIG. 3 is composed of the first delivery data and the second delivery data of each depot, and includes only the data of the customer premises that are to be delivered the next day. It is.

<Delivery data allocation process>
FIG. 8 is a detailed flowchart of the delivery data assignment process described in step S202, and is a diagram for explaining a process for generating delivery schedule data for the next day for each person in charge. In the following explanation, the remaining gas cylinder of the previous day will be described in the embodiment assigned to the delivery person in charge of the customer's home on the day instead of the person in charge of the previous day. This is because the person in charge of delivery in the area may change.

  In such a case, the delivery system 101 can also generate a list of remaining delivery data for each delivery person in charge on the day and use it for reviewing the rank of the person in charge or reviewing the delivery route. For example, when a large number of undelivered items occur in the same area, it is considered that there is some kind of failure rather than a problem for each individual delivery person. In addition, when the number of deliveries on the next day significantly exceeds the delivery capability of each group and the delivery is impossible, it is uniquely assigned to the manager of the group. In such a case, the priority of delivery may be determined based on the judgment of the administrator, but those that cannot actually be delivered are processed as undelivered data.

  In step S801, the delivery system 101 reads a person-in-charge master 900 as illustrated in FIG. 9 and specifies a person in charge who is scheduled to work after excluding a person in charge of taking a vacation the next day. The person-in-charge master 900 includes a company ID, person-in-charge ID, name, password, login date, last DL date, sales office code, group code, distribution order, rank, excess allocation coefficient, delivery vehicle, vacation period FROM, vacation period TO Including items such as

  Here, the last DL date and time indicates the date and time when each delivery person downloaded his / her delivery schedule data to the mobile phone 110. The sales office code indicates the sales office having jurisdiction over the depot, and the group code can specify a group in the sales office. The allocation order is used when allocating the area in charge of the delivery person in the group under the area rotation system. The rank is the number of deliverables per day for the person in charge, and the excess allocation coefficient is the number of deliveries for each carrier when the number of deliveries assigned to that depot and group exceeds the rank total of the group's carriers. This is a coefficient used when calculating excess allocation.

  The delivery vehicle indicates the vehicle used by the delivery person, and this information sets the data classification such as the first and second cars when an amount of gas cylinder that cannot be loaded at one time is allocated to the delivery person depending on the type of delivery car. It becomes information to do. When the delivery system 101 actually divides the delivery data of the person in charge into the first car and the second car, the delivery distance from the depot to the customer's home is sorted by sorting the data based on the blocks described above. This is done after identifying the perspective.

  The vacation period FROM and the vacation period TO are information set by acquiring the latest holiday information from the attendance management data of another system. Based on the data of the vacation period FROM and the vacation period TO, it is determined whether or not the delivery data is assigned to the delivery person. As another embodiment, for half-day vacation, when holiday information is acquired from the attendance management data of another system, the vacation period FROM / vacation period TO is not set, and the rank value is temporarily set only for the corresponding day. It is also possible to deal with it by halving it.

  In step S802, the delivery system 101 calculates the number of deliveries for each group using the delivery schedule data generated in the flowchart of FIG. Since the delivery schedule data includes a sales office code and a group code, the delivery number for each sales office and group can be calculated by performing a summing process using these codes as keys. The delivery number includes information on the container type and the number.

  In step S803, the delivery system 101 adds up the ranks of each person who is scheduled to work from the person-in-charge master 900 that has been read, and calculates the number of deliverables for each group.

  In step S804, the delivery system 101 compares the delivery number of each group with the deliverable number of each group. If the actual delivery number is less than the deliverable number, the process proceeds to step S805. Otherwise, the process proceeds to step S806. Proceed with the process.

In step S805, the delivery system 101 assigns the number of deliveries to each person in charge according to the following calculation formula (first assignment process).
Allocated number = Total number of deliveries ÷ Total number of deliverables × Rank of person in charge Formula 1
According to Equation 1, the number of assignments to each person in charge is the number below the rank. The delivery system 101 performs allocation processing in order from the person with the highest allocation order of the person-in-charge master 900, but when the number of allocations calculated by Equation 1 does not become an integer value, rounds-up processing is performed. Make it numeric. As described above, since the delivery schedule data is sorted based on the zip code, the distribution schedule data is assigned to the person with the first distribution order in order from the first delivery schedule data assigned to the group. It is possible to assign customer houses that are close together to each person in charge. If two containers are delivered to the customer's home, and if the assignment to the person in charge is only one according to the rank, both are assigned.

  In step S <b> 806, the delivery system 101 calculates the total number that can be exceeded in the group based on the rank of the person in charge who is scheduled to work in the group and the excess allocation coefficient. For example, when the rank is 60 in the person-in-charge master 900 in FIG. 9 and the excess allocation coefficient is 1.2, the delivery system 101 can deliver 60 × 1.2 = 72 bottles. Therefore, it is determined that the number that can be exceeded is 72−60 = 12. The total number of excesses for each person in charge is calculated as the total number of excesses for the group.

In step S807, the delivery system 101 assigns the number of deliveries to each person in charge according to the following calculation formula (second assignment process).
Allocation number = (Total number of delivery-Total number of deliverables) / Total number that can be exceeded x Number of people in charge that can be exceeded + Rank of person in charge Formula 2
According to Equation 2, the person in charge is assigned a number equal to or less than the number of deliverables (rank) plus the maximum number that can be exceeded. Next, as described above, the delivery system 101 performs the allocation process in order from the person with the highest distribution order of the person-in-charge master 900.

  Note that if the number of delivery schedules assigned to the group is larger even if the excess possibility coefficient is used, it is assigned to the manager as described above.

  In step S808, the delivery system 101 adds the information of the person in charge to the delivery data 700, and further sorts based on the information of the person in charge and the block information indicating the distance from the depot, and completes delivery data generation for the next day. To do. In addition, the delivery system 101 updates the distribution order of the person-in-charge master 900 for the delivery data allocation process on the next day. For example, the person who has the highest distribution order may be the last person, and other persons in charge may be moved up one by one, or the distribution order may be changed by another algorithm.

<Delivery data download process>
FIG. 10 is a detailed flowchart of the delivery data download process described in step S203, in which only the scheduled delivery data for the next day of the person in charge who has accessed the delivery system 101 is transmitted (downloaded) to the person in charge. FIG.

  In step S <b> 1001, when the person in charge selects a delivery data reception menu from the menu screen displayed on the screen of the mobile phone 110, the mobile phone 110 accesses the delivery system 101 via the network 130. At the time of such access, the person in charge inputs the person in charge ID and password.

  In the mobile delivery system according to the present invention, the machine number uniquely assigned to the mobile phone 110 may be automatically transmitted at the time of access. You may combine numbers. When the machine number is used, the machine number information is added to the person-in-charge master 900. The machine number indicates mobile specific information (unique identification information assigned to each mobile phone) and may be called a terminal manufacturing number, a subscriber ID, or a terminal serial number. This mobile unique information can also be used for authentication processing as a login ID when accessing a predetermined site.

  In step S1002, the delivery system 101 performs an authentication process on the person in charge who has accessed based on information stored in the person-in-charge master 900. As a result, if it is determined that the user is a legitimate user, the process proceeds to step S1003. If it is determined that the user is an unauthorized user, an error message is transmitted to the mobile phone 110, and the process ends.

  In step S <b> 1003, the delivery system 101 transmits only the data of the authorized person in charge (third delivery data) among the scheduled delivery data for the next day to the mobile phone 110 via the network 130. The reason for downloading only the data of the person in charge is to minimize the risk of losing data by downloading extra data. In step S <b> 1004, the mobile phone 110 stores the downloaded delivery schedule data in a storage medium in the mobile phone 110.

  As another embodiment, the delivery system 101 urges the mobile phone 110 of the person in charge who has not downloaded the delivery data every predetermined time based on the last DL date and time of the person-in-charge master 900 to download. You may make it perform the mail notification to the effect.

  An example of the downloaded delivery data 700 is shown in FIG. FIG. 11 shows a list of data that the person in charge delivers on the day. In this example, it is shown that the person in charge has 20 delivery destinations and delivers 45 50 kg containers and 15 30 kg containers. It also shows how many cars should be carried in the first and second cars. In the example of FIG. 11, when a first car is selected by pressing a predetermined key of the mobile phone 110, a customer list of delivery destinations is displayed. Further, it is possible to change the color or display an explicit identifier so that the customer who has performed the delivery data transmission process described below can be identified on the screen.

<Distributed data transmission processing>
FIG. 12 is a diagram showing a detailed flow of the delivered data transmission process described in step S206. After delivery to the customer's home and a predetermined action such as a security check such as meter check and equipment check, the delivery person can use the mobile phone 110 to display the customer home shown in FIG. Is selected and the predetermined key is pressed (step S1201). The mobile phone 110 displays a screen as shown in FIG.

  The screen displayed in FIG. 13 displays a meter pointer at the time of delivery, a container number of the replaced gas cylinder, a predetermined security item, and the like, but these are merely examples. For example, the security items differ depending on the prefecture where the customer's home is located, and also differ depending on the installed equipment. However, the data items displayed on the screen of FIG. 13 are determined by the information stored in the customer master and the delivery data and related databases, and which data item is displayed is determined in advance by the delivery system 101.

  The delivery person inputs a predetermined data item on the display screen (step S1202), and when the predetermined button on the mobile phone 110 is pressed, the input data is transmitted to the delivery system 101 (step S1203). In addition, the container number of the replaced container can be read using the barcode reader function of the mobile phone 110 from the barcode attached to the container, and efficient and error-free container management can be performed. it can.

<Database update>
When the delivery system 101 receives the delivery completion data of the customer's house described with reference to FIG. 12, the customer master 400 in FIG. 4, the gas consumption record table 600 in FIG. 6, the delivery data 700 in FIG. 7, and the security system 103. Update related databases such as databases in real time. By performing the update in this way, the delivery system 101 can perform the next day's delivery schedule based on the latest data, and the other systems 102 and 103 can also perform processing based on the latest data. It becomes.

<System configuration>
Hereinafter, the system configuration of the delivery system 101 according to the present invention will be described with reference to FIG. The delivery system 101 includes a control unit 1401, a main storage unit 1402, an auxiliary storage unit 1403, an interface (I / F) unit 1404, an input unit 1405, an output unit 1406, a customer master 400, an area master 500, and a gas consumption performance amount table 600. , Delivery data 700 and person-in-charge master 900.

  The control unit 1401 is also called a central processing unit (CPU), controls the above-described components and calculates data, and reads various programs stored in the auxiliary storage unit 1403 to the main storage unit 1402 and executes them. To do. The main storage unit 1402 is also called a main memory, and stores various data received by the delivery system 101, computer-executable instructions, data after arithmetic processing by the instructions, and the like.

  The auxiliary storage unit 1403 is a storage device represented by a hard disk (HDD) or the like, and is used when data and programs are stored for a long period of time. Since the main storage unit 1402 has a relatively smaller storage capacity than the auxiliary storage unit 1403, it is used for temporary data storage and arithmetic processing, while the auxiliary storage unit 1403 has necessary data and information. Used for long-term storage and storage. In other words, when the control unit 1401 executes a program to perform data calculation, the necessary data and program are read from the auxiliary storage unit 1403 to the main storage unit 1402, and the calculation result data is stored and stored for a long time. The control unit 1401 writes calculation result data in the auxiliary storage unit 1403.

  The interface (I / F) unit 1404 plays a role of an interface when data is transmitted / received between the computer apparatus outside the delivery system 101 and the mobile phone 110. Data received from the outside is temporarily stored in the main storage unit 1402. The interface unit 1404 also provides an interface for receiving various commands and input data (such as various masters and tables) input via the input unit 1405. The output unit 1406 outputs the output (screen, form, etc.) of the delivery system 101.

  The customer master 400, the area master 500, the actual gas consumption amount table 600, the delivery data 700, and the person in charge master 900 are as described above with reference to FIGS. 4, 5, 6, 7, and 9, respectively. Data items. These databases are updated according to data input via the input unit 1405 and updated according to data transmitted from the mobile phone 110. In particular, the delivery data 700 is used as delivery data that has been delivered daily after delivery schedule data is generated and actual delivery is completed. Of course, it is possible to generate and store data of predetermined items in time series using data extracted from these databases.

100 Center system (core system)
DESCRIPTION OF SYMBOLS 101 Delivery system 102 Meter-reading / billing system 103 Security system 110 Mobile phone 120 Car navigation system 130 Network 400 Customer master 500 Area master 600 Gas consumption performance amount table 700 Delivery data 900 Person in charge master

Claims (7)

A liquefied petroleum gas container delivery system in which first, second and third computer systems and a plurality of mobile phones are connected via a network,
The first computer system includes:
A first DB that is customer information including at least a customer identifier, first area identification information, last delivery date, and installation container information;
A second DB including time-series gas consumption record data associated with the customer identifier;
A third DB including second area identification information and delivery person data;
A data generation means for calculating a delivery date of the liquefied petroleum gas container for each customer and generating only delivery data of a customer whose delivery date is the next day, wherein the delivery date is the first DB Installed container information, gas consumption actual amount data at the previous delivery derived from the second DB, gas consumption actual amount data generated after the previous delivery, and a plurality of gas consumptions in the same period of the previous year Calculated based on the actual amount data, and the delivery data includes a customer identifier, first region identification information, and installation container information included in the first DB, and based on the first region identification information Data generating means that is sorted and the delivery data is stored in a fourth DB;
Based on the first area identification information included in the generated delivery data and the second area identification information in the third DB, information on a person in charge of delivery included in the third DB is obtained as the delivery data. In addition to the above, data allocation means for generating delivery data for each delivery person, the delivery person is a person working on the scheduled delivery date, and adding the information of the delivery person is: Data allocating means, which is performed on the basis of the delivery capability and data allocation order of the delivery person indicated by the delivery person data of the third DB;
In response to communication access from the mobile phone, data transmission means for transmitting only the delivery person-specific delivery data of the delivery person associated with the mobile phone to the mobile phone;
Data receiving means for receiving data associated with completion of delivery of the container from the mobile phone;
Data updating means for updating the first DB and the second DB based on the received data related to the delivery completion of the container, wherein the delivery person-specific delivery data indicates delivery completion. Data updating means updated and stored in the fourth DB,
The second DB stores the data transmitted from the second computer system that generates a bill based on the gas consumption actual amount of the customer, and the security result of the installation container information of the customer. The liquefied petroleum gas container delivery system is further updated based on data transmitted from the computer system. The data allocating unit calculates a first amount by adding the delivery amount included in the delivery data generated by the data generating unit for each sales office code and group code included in the first region identification information. And a second quantity is calculated by adding together the delivery capabilities of delivery personnel working for the scheduled delivery date for each sales office code and group code,
If the first amount is less than or equal to the second amount, the first equation,
The delivery data for each delivery person is generated by the first quantity / the second quantity × the delivery person's delivery capacity,
If the first amount is greater than the second amount, the second equation,
(1st quantity-2nd quantity) ÷ total number of excess persons x number of persons in charge in excess of the person in charge + delivery capacity of the person in charge of delivery The delivery person-specific delivery data is generated, where the person in charge can be exceeded. The number indicates the number that can be delivered by the person in charge exceeding the delivery ability of the person in charge of delivery, and the total number that can be exceeded is the total value for the sales office code and group code of the number that can be exceeded by the person in charge The liquefied petroleum gas container delivery system according to claim 1. The third DB further includes vehicle information used by the delivery person,
The mobile phone can be connected to a car navigation system mounted on a delivery vehicle via a network,
The car navigation system indicates a delivery location based on the first area identification information of the delivery person-specific delivery data transmitted from the mobile phone,
The delivery data for each person in charge of delivery indicates an area that is relatively near and far from the delivery start point of the liquefied petroleum gas container, and the distinction between the near area and the far area is the first area. The liquefied petroleum gas container delivery system according to claim 1, wherein the delivery system is determined based on area identification information and the vehicle information.   2. The delivery data for each delivery person, which has not been updated to indicate delivery completion, is incorporated into delivery data for the next day generated by the data generation means. Liquefied petroleum gas container delivery system.   The first area identification information includes a postal code, an address, GPS information, a block, a sales office code, and a group code, and the second area identification information includes a sales office code and a group code. The liquefied petroleum gas container delivery system according to claim 1.   The liquefied petroleum gas container delivery system according to claim 1, wherein the installation container information of the first DB includes a capacity and the number of liquefied petroleum gas containers. A method executed in a liquefied petroleum gas container delivery system in which a first, second and third computer system and a plurality of mobile phones are connected via a network,
The first computer system includes:
A first DB that is customer information including at least a customer identifier, first area identification information, last delivery date, and installation container information;
A second DB including time-series gas consumption record data associated with the customer identifier;
A third DB including second area identification information and delivery person data;
A fourth DB for storing delivery data; and
The method
Calculating a scheduled delivery date of the liquefied petroleum gas container for each customer, and generating only the delivery data of the customer whose scheduled delivery date is the next day, wherein the scheduled delivery date is: Installation container information included in the first DB, actual gas consumption amount data at the previous delivery derived from the second DB, actual gas consumption amount data generated after the previous delivery, and the same period of the previous year The delivery data includes a customer identifier, first area identification information, and installation container information included in the first DB, and the first area. Steps sorted based on identification information; and
Based on the first area identification information included in the generated delivery data and the second area identification information in the third DB, information on a person in charge of delivery included in the third DB is obtained as the delivery data. In addition, the first computer system generates delivery data for each person in charge of delivery, wherein the person in charge of delivery is a person working on the scheduled delivery date, and information on the person in charge of delivery is obtained. Adding is performed based on the delivery person's delivery capability and data allocation order indicated by the delivery person's data in the third DB;
In response to communication access from the mobile phone, the first computer system transmits only the delivery person-specific delivery data of the delivery person associated with the mobile phone to the mobile phone;
The first computer system receiving data from the mobile phone associated with delivery completion of the container;
The first computer system updates the first DB and the second DB based on the received data related to the delivery completion of the container, and the delivery data for each person in charge of delivery is delivered. Updated to indicate completion and stored in the fourth DB; and
The second DB stores the data transmitted from the second computer system that generates a bill based on the gas consumption actual amount of the customer, and the security result of the installation container information of the customer. And further updating based on data transmitted from the computer system.

Images