JP7170435B2 - Information processing device, information processing method and information processing program - Google Patents

Description

The present invention relates to an information processing device, an information processing method, and an information processing program.

In some cases, it is required to grasp daily expenses and balances for management decisions and business responses. For example, Japanese Laid-Open Patent Publication No. 2002-200003 discloses creating a daily income and expenditure table consisting of daily actual amounts related to account items. Further, Japanese Patent Laid-Open No. 2002-200001 discloses that the daily income and expenditure table incorporates items such as expenses related to account items that are selected in advance according to the user's purpose.

JP 2009-223682 A

However, in order to grasp the daily income and expenditure based on the actual amount as in Patent Document 1, it is a prerequisite that the actually incurred expenses have been calculated. For example, in the transportation industry, etc., there was a need to quickly grasp the amount of expenses, especially those that are costs, on a daily basis. In some cases, the timing was at the end of the month or the next month. For this reason, in the conventional technology, it was sometimes difficult for users in the transportation industry, etc., to quickly grasp the cost amount.

SUMMARY OF THE INVENTION It is an object of the present invention to provide an information processing apparatus, an information processing method, and an information processing program that enable a user to quickly grasp the daily cost amount. .

In order to solve the above-described problems and achieve the object, an information processing apparatus according to the present invention is an information processing apparatus including a control unit, wherein the control unit is associated with a predetermined expense item and has a predetermined Acquisition means for acquiring a standard cost and a unit price classification type classification indicating a calculation method for each of the expense items predetermined for each of the expense items ; The cost of repair expenses is calculated by multiplying the cost by the mileage included in the daily report on transportation, and based on the acquired unit price classification type classification, the standard cost of the labor cost is added to the daily report. By multiplying the included constraint time to calculate the cost of the labor cost item, and based on the unit price classification type division, by multiplying the fuel supply amount included in the daily report by the standard cost of the fuel cost Calculate the cost of the fuel cost item, and calculate the repair cost, the labor cost, and the fuel cost, the predetermined vehicle cost indicated by the unit price classification type division, and the daily report and calculating means for calculating the total amount of daily costs by adding the included tolls .

Further, in the information processing apparatus according to the present invention , when transporting a plurality of packages, the acquisition means acquires the apportionment method classification indicating the apportionment method for each of the expense items, and the calculation means Based on the acquired apportionment method classification, the cost of repair costs, the cost of labor costs, the cost of fuel costs, the vehicle costs, and the tolls are apportioned for each transportation item number of each of the packages. wherein the calculating means calculates the cost of the repair costs, the cost of the labor costs, the cost of the fuel costs, the vehicle costs, and the tolls for each of the transport item numbers that have been proportionally divided. It is characterized by calculating the total amount of the cost for each of the transportation detail numbers by adding each of them .

Further, an information processing method according to the present invention is an information processing method executed by an information processing apparatus having a control unit, wherein the control unit executes a predetermined standard associated with a predetermined expense item. an acquisition step of acquiring a cost and a unit price category type division indicating a calculation method for each of the expense items predetermined for each of the expense items; and a standard cost of the repair expenses based on the acquired unit price category type division. In addition, the cost of repair expenses is calculated by multiplying the mileage included in the daily report on transportation, and based on the acquired unit price classification type classification, the standard cost of labor costs is included in the daily report. The cost of the labor cost is calculated by multiplying the binding time, and based on the unit price classification type division, the standard cost of the fuel cost is multiplied by the refueling amount included in the daily report. The cost of the item of expenses is calculated, and the calculated repair cost, labor cost, and fuel cost are added to the predetermined vehicle cost indicated by the unit price classification type division, and included in the daily report. and a calculation step of calculating the total amount of daily costs by adding the tolls charged .

Further, an information processing program according to the present invention is an information processing program to be executed by an information processing apparatus having a control unit, and is predetermined in association with a predetermined expense item for execution by the control unit. An acquisition step of acquiring a standard cost and a unit price classification type classification indicating a calculation method for each of the expense items predetermined for each of the expense items, and based on the acquired unit price classification type classification, the repair expenses Calculate the cost of repair expenses by multiplying the standard cost by the mileage included in the daily report on transportation, and add the standard cost of the labor cost to the daily report based on the acquired unit price classification type classification Calculate the cost of labor cost by multiplying the constraint time included in the above, and multiply the standard cost of the fuel cost by the fuel supply amount included in the daily report based on the unit price classification type division. to calculate the cost of the fuel cost item, and add the calculated repair cost cost, the labor cost cost, and the fuel cost cost to the predetermined vehicle cost indicated by the unit price classification type division, and the daily report and a calculation step of calculating the total amount of daily costs by adding the tolls included in the calculation .

ADVANTAGE OF THE INVENTION According to this invention, there exists an effect that a user can grasp|ascertain a daily cost rapidly.

1 is a block diagram illustrating an example of a configuration of an information processing apparatus according to an embodiment; FIG. FIG. 2 is a diagram illustrating an example of an expense item setting database according to the embodiment; FIG. 3 is a diagram illustrating an example of a unit price classification type database according to the embodiment; FIG. 4 is a diagram illustrating an example of a standard cost database according to the embodiment; FIG. 5 is a diagram illustrating an example of a crew-specific cost database according to the embodiment; FIG. 6 is a diagram illustrating an example of a vehicle-specific cost database according to the embodiment; FIG. 7 is a diagram illustrating an example of an itemized apportionment method database according to the embodiment; FIG. 8 is a diagram illustrating an example of the apportionment method division database according to the embodiment; FIG. 9 is a flowchart illustrating an example of a procedure of cost calculation processing according to the embodiment; FIG. 10 is a diagram illustrating an example of a daily report header database according to the embodiment; FIG. 11 is a diagram illustrating an example of a daily toll detail database according to the embodiment; FIG. 12 is a diagram illustrating an example of a daily refueling detail database according to the embodiment; FIG. 13 is a diagram of an example of a daily transportation details database according to the embodiment; FIG. 14 is a diagram illustrating an example of costs calculated based on daily report information according to the embodiment; FIG. 15 is a diagram illustrating an example of a transportation detail cost database according to the embodiment; FIG. 16 is a diagram illustrating an example of calculation results of daily balance for each item according to the embodiment; FIG. 17 is a diagram illustrating an example of calculation results of daily balance for each customer according to the embodiment; FIG. 18 is a diagram illustrating an example of calculation results of daily balance for each delivery destination according to the embodiment;

Embodiments of an information processing apparatus, an information processing method, and an information processing program according to the present invention will be described in detail below with reference to the drawings. In addition, this invention is not limited by this embodiment.

In the transportation industry, predetermined expenses related to transportation are treated as costs (cost of sales). For example, in the present embodiment, vehicle costs, repair costs, labor costs, fuel costs, and transportation costs are used as costs related to delivery. In the present embodiment, for such expense items included in the cost, the amount per predetermined unit of each expense item is predetermined as the standard cost.

Then, the information processing apparatus of the present embodiment calculates the total amount of cost for each expense item on a daily basis based on the standard cost and the data of the daily report generated for each operation unit. Here, the daily report is a daily record of transportation. Information contained in the daily report will be described later. Specific configurations and operations will be described below.

The configuration of the information processing apparatus 100 according to this embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of an information processing apparatus 100. As shown in FIG.

The information processing device 100 is a commercially available desktop personal computer. Note that the information processing apparatus 100 is not limited to a stationary information processing apparatus such as a desktop personal computer, and may be a portable type such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), a smart phone, or a tablet personal computer. It may be an information processing device.

The information processing apparatus 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input/output interface unit 108, as shown in FIG. Each unit included in the information processing apparatus 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the information processing device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the information processing apparatus 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that data stored in the storage unit 106 to be described later may be stored in the server 200 .

An input device 112 and an output device 114 are connected to the input/output interface section 108 . The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that cooperates with the mouse to provide a pointing device function. Note that, hereinafter, the output device 114 may be referred to as the monitor 114 and the input device 112 may be referred to as the keyboard 112 or the mouse 112 .

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for performing various processes by giving commands to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.

The storage unit 106 includes a cost item setting database (DB) 106a, a unit price classification type database (DB) 106b, a standard cost database (DB) 106c, a cost database (DB) 106d for each crew, and a cost database (DB) for each vehicle. 106e, apportionment method database (DB) 106f by expense item, apportionment method classification database (DB) 106g, daily report header database (DB) 106h, daily report toll details database (DB) 106i, daily report fueling details database (DB) ) 106j, a daily transportation detail database (DB) 106k, and a transportation detail cost database (DB) 106l.

The expense item setting database 106a is a database in which expense items for which standard costs are set for each predetermined unit, unit price classifications, and unit price classification types among the expense items to be included in the cost are stored in association with each other.

FIG. 2 is a diagram showing an example of the expense item setting database 106a according to this embodiment. As shown in FIG. 2, unit price classification codes, unit price classification names, expense item codes, expense item names, unit price classification type classifications, and unit price classification type names are associated and registered in the expense item setting database 106a. be.

The unit price classification is a unit for classifying the standard cost for each predetermined unit described later. The unit price classification code is identification information that identifies the unit price classification. Also, the unit price classification name is a name associated with the unit price classification code.

The expense item code is identification information that identifies each expense item. The expense item name is a name associated with the expense item code. In the present embodiment, as an example, standard costs are set for vehicle costs, repair costs, labor costs, and fuel costs among vehicle costs, repair costs, labor costs, fuel costs, and transportation costs that are included in the costs. shall be Therefore, vehicle expenses, repair expenses, labor expenses, and fuel expenses are registered in the expense item setting database 106a.

The unit price category type is a category that indicates the unit of unit price (standard cost) that belongs to each unit price category. The unit price category type is the total cost (cost) for the relevant expense item from the unit price (standard cost) associated with the expense item belonging to each unit price category in the process of calculating the total amount of expenses (cost) for each expense item described later. is used to specify the method for calculating The unit price classification type section is identification information that specifies the unit price classification type. The unit price classification type name is a name associated with the unit price classification type division. The unit price classification type classifications and unit price classification type names registered in the expense item setting database 106a are selected from the unit price classification type classifications and unit price classification type names registered in advance in the unit price classification type database 106b.

Returning to FIG. 1, the unit price classification type database 106b is a database in which unit price classification type classifications that can be registered in the expense item setting database 106a and unit price classification type names are registered in association with each other.

FIG. 3 is a diagram showing an example of the unit price classification type database 106b according to this embodiment. In this embodiment, it is assumed that the unit price classification type categories "0" to "4" are registered in advance in the unit price classification type database 106b.

The unit price classification type classification "0" (unit price classification type name "fixed") indicates that the unit price (standard cost) included in the unit price classification for which the relevant unit price classification type is set is "the expense incurred regardless of whether there is a daily report". indicates that Further, the unit price classification type division "1" (unit price classification type name "mileage unit price") indicates that the unit price (standard cost S) is "cost calculated by multiplying the mileage included in the daily report". . The unit price classification type division "2" (unit price classification type name "fueling amount unit price") indicates that the unit price (standard cost) is "expense calculated by multiplying the fueling amount included in the daily report". The unit price classification type section "3" (unit price classification type name "hourly unit price") indicates that the unit price (standard cost) is "expense calculated by multiplying the time limit included in the daily report". The unit price classification type section "4" (unit price classification type name "operating unit price") indicates that the unit price (standard cost) is "expense calculated by multiplying the number of days for which the daily report exists".

Returning to FIG. 1, the standard cost database 106c is a database in which individual unit prices associated with cost items, which are costs for transportation, are registered as standard costs.

FIG. 4 is a diagram showing an example of the standard cost database 106c according to this embodiment. As shown in FIG. 4, unit price classification codes, unit price classification names, branch numbers, unit price names (standard cost names), and unit prices (standard costs) are associated and registered in the standard cost database 106c. be. Each unit price classification is associated with one or more unit price names (standard cost names) and unit prices (standard costs). The branch number is a detail number for specifying each unit price (standard cost) when there are multiple unit prices (standard costs) belonging to each unit price category. In this embodiment, as shown in FIGS. 2 and 4, standard costs, expense items, and unit price classification types are associated via unit price classifications, but these may be registered in one database. In the following, unless otherwise specified, the amounts of costs, etc. are in units of yen.

Returning to FIG. 1, the cost database for each crew member 106d corresponds to each crew member who rides a vehicle such as a truck used for transportation, and the unit price classification and standard cost related to the expenses incurred by each crew member for the transportation work. It is a database that is attached and registered.

FIG. 5 is a diagram showing an example of the crew-specific cost database 106d according to this embodiment. As shown in FIG. 5, the crew-specific cost database 106d contains a crew code, a crew name, a unit price classification code, a unit price classification name, a branch number, a unit price name (standard cost name), and a unit price (standard cost name). ) and revision date are registered.

A crew member code is identification information that identifies a crew member who rides a vehicle such as a truck used for transportation. A crew member is, for example, a driver, a fellow passenger who loads and unloads luggage, and the like. The branch number is a branch number registered in the standard cost database 106c shown in FIG. The revision date is the revision date of the unit price name (standard cost name) and the unit price (standard cost) standard cost associated with the crew code. Unit price name (standard cost name) and unit price (standard cost) whose revision date is before the current date when multiple unit price names (standard cost name) and unit price (standard cost) standard costs are associated with a crew code Standard cost is used in the cost calculation process.

Returning to FIG. 1, the vehicle-by-vehicle cost database 106e is a database in which vehicles used for transportation and unit price classifications and standard costs related to the costs incurred in relation to each vehicle are registered in association with each other.

FIG. 6 is a diagram showing an example of the vehicle-by-vehicle cost database 106e according to the present embodiment. As shown in FIG. 6, the vehicle-by-vehicle cost database 106e contains a vehicle number for identifying each vehicle, a vehicle number, a unit price classification code, a unit price classification name, a branch number, and a unit price name (standard cost name). , unit price (standard cost), and revision date are registered.

Returning to FIG. 1, the expense item apportionment method database 106f is a database in which the apportionment method for each expense item is registered. FIG. 7 is a diagram showing an example of the expense item-by-item apportionment method database 106f according to the present embodiment. As shown in FIG. 7, expense item codes, expense item names, apportionment method classifications, and apportionment method classification names are associated and registered in the expense item apportionment method database 106f.

In this embodiment, when one daily report includes a plurality of details for each transportation, the apportionment unit 102c, which will be described later, apportions the total cost for each item of expense for each transportation. The apportionment method classification is a classification specifying the calculation method for apportionment. The same apportionment method classification may be set for all expense items, or a different apportionment method classification may be set for each expense item. The apportionment method classification is an example of apportionment criteria in this embodiment.

Returning to FIG. 1, the apportionment method division database 106g is a database in which apportionment method divisions and apportionment method division names that can be registered in the expense item apportionment method database 106f shown in FIG. 7 are registered. FIG. 8 is a diagram showing an example of the apportionment method division database 106g according to this embodiment. In this embodiment, as an example, it is assumed that apportionment method classes "0" to "5" are registered in advance in the apportionment method class database 106g.

The apportionment method classification "0" (apportionment method classification name "not applicable") indicates that the expense items for which the relevant classification is set are not subject to apportionment. Also, the apportionment method classification "1" (apportionment method classification name "equally apportionment") indicates that the cost (cost) is evenly divided by the number of daily report details (transportation details number). The apportionment method classification "2" (apportionment method classification name "vehicle allocation equivalent") indicates that the cost (cost) is apportioned according to the vehicle allocation equivalent for each daily report detail (transportation detail number). In this embodiment, it is assumed that the vehicle allocation conversion amount is the weight of the package for each transportation detail number. The apportionment method classification “3” (apportionment method classification name “sales main amount”) indicates that expenses (costs) are apportioned according to the freight (sales) amount for each daily report detail (transportation detail number). The apportionment method classification "4" (apportionment method classification name "actual vehicle distance") indicates that the cost (cost) is apportioned according to the length of the actual vehicle distance for each daily report detail (transportation detail number). In this embodiment, the actual vehicle distance is the traveled distance (km) between the origin and the destination for each transportation item number. Apportionment method classification "5" (apportionment method classification name "Daily report item standard value") indicates that expenses (costs) are apportioned according to the size of the standard value set for each daily report item (transportation item number). show.

Returning to FIG. 1, the daily report header database 106h, the daily toll detail database 106i, the daily refueling detail database 106j, and the daily transportation detail database 106k are databases in which daily report data generated for each operation are registered. . Daily report data input from the input screen or the like is registered in each of these databases. Details of the data registered in these databases will be described later.

The transportation detail cost database 106l is a database that stores the amount of cost for each expense item, which is apportioned for each transportation (for each transportation detail number) by the apportioning unit 102c, which will be described later. The details of the data registered in the shipping details cost database 106l will be described later.

Also, the control unit 102 is a CPU or the like that controls the information processing apparatus 100 in an integrated manner. The control unit 102 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run.

As shown in FIG. 1, the control unit 102 includes an acquisition unit (acquisition means) 102a, a calculation unit (calculation means) 102b, a proportional division unit (proportional division means) 102c, an aggregation unit (aggregation means) 102d, and a display control unit. a unit (display control means) 102e as a function.

The acquisition unit 102a acquires a predetermined standard cost associated with a predetermined expense item. More specifically, the acquisition unit 102a acquires the standard cost associated with the expense item code registered in the expense item setting database 106a and the standard cost database 106c, and the unit price classification type classification indicating the unit of addition of the standard cost. . In addition, the acquisition unit 102a acquires the apportionment method classification from the expense item apportionment method database 106f.

Acquisition unit 102a also acquires daily report data relating to transportation from daily report header database 106h, daily toll detail database 106i, daily refueling detail database 106j, and daily transportation detail database 106k. In addition, based on the driver code, fellow passenger code, and vehicle number included in the daily report, the acquisition unit 102a obtains the driver code, the passenger code, and the vehicle number from the driver-specific cost database 106d and the vehicle-specific cost database 106e, respectively. Get various standard costs.

The calculation unit 102b calculates the total amount of daily costs for each predetermined expense item based on the standard cost and the daily report on transportation acquired by the acquisition unit 102a.

When the daily report includes a plurality of details for each transportation, the proportional division unit 102c proportionally divides the total amount of the cost for each predetermined expense item calculated by the calculation unit 102b to each transportation according to the proportional division standard associated with the predetermined expense item.

The tabulation unit 102d tabulates the amount of the cost for each expense item proportionally divided for each transportation, using a predetermined item. Items used as units of aggregation are, for example, item names, customer names, destinations (delivery destinations), and the like.

The display control unit 102e displays the result corrected by the counting unit 102d on the monitor 114 as a daily balance sheet.

A specific example of the processing according to this embodiment will be described in detail below. FIG. 9 is a flowchart showing an example of the procedure of cost calculation processing according to the present embodiment. The processing of this flowchart is assumed to be executed once a day, for example, as daily processing. Before executing the processing of this flowchart, various setting data (expense item setting database 106a, unit price classification type database 106b, standard cost database 106c, crew cost database 106d, vehicle cost database 106e, expense item apportionment method database 106f) , apportionment method division database 106g) and daily report data (daily report header database 106h, daily toll detail database 106i, daily fueling detail database 106j, daily transportation detail database 106k) are registered.

First, the acquiring unit 102a acquires daily report data generated for each operation from the daily report header database 106h, the daily toll detail database 106i, the daily fueling detail database 106j, and the daily transportation detail database 106k (S1).

Here, the daily report data according to the present embodiment will be described with reference to the drawings. FIG. 10 is a diagram showing an example of the daily report header database 106h according to this embodiment. The daily report header database 106h is a database in which summary data of daily reports is stored. As shown in FIG. 10, the daily report header database 106h contains the daily driving report number, daily report date, vehicle number, driver code, fellow passenger code, departure date, return date, departure meter, return A meter, a travel distance, a driver's restraint time, a driver's overtime work, a fellow passenger's restraint time, and a fellow passenger's overtime work are registered in association with each other.

The daily driving report number is a number assigned to each daily report, and is identification information that identifies each daily report. In this embodiment, as an example, the daily report shall be created for each operation. The daily report date is the creation date of the daily report. The driver code and fellow passenger code are codes of the same code system as the crew code registered in the crew-specific cost database 106d shown in FIG. When a crew member gets on the vehicle as a driver, a crew code identifying the crew member is registered in the daily report header database 106h as a driver code. Also, when a crew member gets on the vehicle as a fellow passenger, a crew code identifying the crew member is registered as a fellow passenger code in the daily report header database 106h.

FIG. 11 is a diagram showing an example of the daily toll detail database 106i according to this embodiment. When a toll is charged during transportation, as shown in FIG. 11, the daily driving report number is associated with the toll, the item code of the toll, and the item name of the toll, and a daily report is generated. It is registered in the toll detail database 106i. In this embodiment, the detailed expense item code is a sub-classification of the expense item code, and is an item that specifies the details of the expense more specifically than the expense item code. The detailed expense item code "TU01" (detailed expense item name "expressway toll") and the detailed expense item code "TU02" (detailed expense item name "ferry fare") are the expense item "toll" (expense item code "H031") to be included in the cost. ) is the item code included in the item code.

FIG. 12 is a diagram showing an example of the daily refueling detail database 106j according to this embodiment. When the driver refuels the vehicle during transportation, as shown in FIG. 12, the daily driving report number is associated with the refueling amount, item code and item name indicating the type of fuel that was refueled. is registered in the daily report toll details database 106i. The amount of oil supplied shown in FIG. 12 is in liter units.

FIG. 13 is a diagram showing an example of the daily transportation details database 106k according to this embodiment. When a single operation of one vehicle includes a plurality of transportations, as shown in FIG. Destination name, place of departure, destination, item name, quantity, weight of package (kg), fare, actual vehicle distance, and item reference value are registered.

In this embodiment, transportation refers to individual transportation operations with different customers (shippers), departure and arrival locations, or different items. For example, when multiple customers' packages are mixed on one truck, one operation includes multiple transportations for different customers. In the example of Fig. 13, a transport detail number is assigned to each customer (shipper), but even if the customer is the same, different transport detail numbers are assigned if the departure and arrival places, items, etc. are different. It is good as

In addition, the actual vehicle distance is the traveled distance from the origin to the destination for each transportation detail number. The detail reference value is a value used for apportionment of expenses (costs) for which apportionment method classification "5" (distribution method classification name "daily report detail reference value") is set. The detailed reference value may be set by the user when registering the daily report, or may be determined based on the weight or actual vehicle distance, for example.

Next, the acquiring unit 102a acquires the standard cost for each expense item and the unit price classification type from the expense item setting database 106a and the standard cost database 106c (S2).

Then, the calculation unit 102b identifies the vehicle mileage, crew restraint time, fuel supply amount, and toll for each driving daily report number included in the daily report data acquired by the acquisition unit 102a (S3). .

For example, as indicated by a bold frame in the daily report header database 106h in FIG. ” (time). In addition, as indicated by a bold frame in the daily refueling detail database 106j in FIG. 12, the refueling amount for one operation specified by the daily driving report number "01UN00000001" is "250" (liters). Also, as indicated by a bold frame in the daily report toll detail database 106i in FIG. 11, the toll for one operation specified by the daily driving report number "01UN00000001" is "5650"+"25550"="31200". (yen).

Next, the calculation unit 102b calculates the unit price classification type classification for each expense item set in the expense item setting database 106a, the standard cost registered in the standard cost database 106c, and the standard Calculate the total cost for each expense item (vehicle cost, repair cost, labor cost, fuel cost, transportation cost) based on the cost and the standard cost by car number registered in the cost database by vehicle 106e ( S4).

FIG. 14 is a diagram showing an example of costs calculated based on information in daily reports according to the present embodiment. FIG. 14 shows, as an example, the cost amount for one operation specified by the daily driving report number "01UN00000001". Since the unit price classification type division of the vehicle cost is "0" (fixed), the vehicle cost is an expense regardless of whether there is a daily report. Further, as shown in FIG. 2, the vehicle cost is associated with the unit price classification code "Tank001" (compulsory automobile liability insurance). In the standard cost database 106c shown in FIG. 4, the unit price classification code "Tank001" (compulsory vehicle liability insurance) is associated with "400" (yen), which is the "4t vehicle liability insurance premium". Therefore, the calculation unit 102b calculates the vehicle cost per day as "400".

Also, since the unit price classification type division of the repair cost is "1" (mileage unit price), the repair cost is a cost calculated by multiplying the mileage included in the daily report. In the daily report header database 106h, the vehicle number "47-53" associated with the daily driving report number "01UN00000001" has the standard cost of "4t vehicle inspection fee" as shown in the vehicle-by-vehicle cost database 106e of FIG. "4" (yen) is associated. Therefore, the calculation unit 102b multiplies the standard cost “4” (yen) by the mileage “500” (km) associated with the driving daily report number “01UN00000001”, resulting in a calculation result of “2000” (yen). is calculated as the total amount of repair expenses per daily report.

Also, since the unit price classification type division of labor costs is "3" (hourly unit price), the labor costs are the costs calculated by multiplying the on-duty time included in the daily report. Further, in the daily report header database 106h, the daily driving report number "01UN00000001" is associated with the driver code "4081". In the crew-specific cost database 106d, the standard cost for the "driver's wage" associated with the crew with the crew code "4081" is "1400" (yen). Therefore, the calculation unit 102b multiplies the standard cost "1400" (yen) by the driver restraint time "8" (hours) associated with the daily driving report number "01UN00000001" in the daily report header database 106h. The result "11200" (yen) is calculated as the total amount of labor costs for each daily report. Note that the calculation unit 102b may calculate the total amount of labor costs based on the driver's restraint time and the driver's wage registered in the standard cost database 106c.

Further, since the fuel cost unit price classification type division is "2" (refueling amount unit price), the fuel cost is a cost calculated by multiplying the refueling amount included in the daily report. Further, as shown in the vehicle-by-vehicle cost database 106e of FIG. 6, the car number "47-53" is associated with the standard cost "100" (yen) for "light oil". Therefore, the calculation unit 102b multiplies the standard cost “100” (yen) by the refueling amount “250” (liters) associated with the daily driving report number “01UN00000001” and calculates the result “25000” (yen). is calculated as the total fuel cost for each daily report.

In addition, in this embodiment, the actual payment amount is used instead of the standard cost for the toll. (yen) is specified as the total amount of travel expenses for the daily driving report number "01UN00000001".

Next, the apportioning unit 102c refers to the daily report header database 106h and determines whether or not the daily operation report number "01UN00000001" is associated with a plurality of transportation detail numbers (S5).

In the daily report header database 106h, if there are a plurality of transportation item numbers associated with the daily operation report number "01UN00000001" (S5 "Yes"), the apportioning unit 102c apportions the cost of each expense item for each transportation item number ( S6).

In the present embodiment, as shown in FIG. 7, in the cost item-by-cost apportionment method database 106f, all cost items are associated with the apportionment method classification “2” (vehicle allocation conversion amount). In addition, in this embodiment, the dispatch equivalent amount is the weight of the package for each transportation detail number, so the proportional division unit 102c divides each expense item according to the weight for each transportation detail number registered in the daily transportation detail database 106k. Prorate the cost of As indicated by the bold frame in FIG. 13, the weights associated with the transportation detail numbers "01UM00000101", "01UM00000102", and "01UM00000103" included in the daily driving report number "01UN00000001" are "1000" (kg) and "1000" (kg), respectively. 2000" (kg) and "1000" (kg). Therefore, the apportionment unit 102c apportions the amount of each expense item in a ratio of 1:2:1.

FIG. 15 is a diagram showing an example of the shipping details cost database 106l according to this embodiment. As shown in FIG. 15, the transportation detail cost database 106l stores vehicle numbers, transportation detail numbers, expense item codes, expense item names, and cost amounts for each expense item in association with each other. As shown in FIG. 15, the apportioning unit 102c, for example, divides the total vehicle cost "400" (yen) for the daily driving report number "01UN00000001" into "100" (yen), "200" (yen), "100" ” (yen), and associated with the transportation item numbers “01UM00000101”, “01UM00000102”, and “01UM00000103”, respectively, and stored in the transportation item cost database 106l.

The proportional division unit 102c proportionally divides the vehicle cost, repair cost, labor cost, fuel cost, and toll cost, thereby identifying the total cost for each transportation detail number. As shown in FIG. 14, the total cost for each transportation detail number is "17450" (yen), "34900" (yen), and "17450" (yen).

Also, in the daily report header database 106h, if there is only one transportation item number associated with the daily operation report number "01UN00000001" (S5 "No"), the apportioning unit 102c does not apportion the cost amount of each expense item. , it is stored in the expense item-by-item apportionment method database 106f.

Next, the tabulation unit 102d tabulates the amount of cost (cost amount) for each expense item proportionally divided for each transportation detail number, using predetermined items (S7). Predetermined items, which are aggregate units, are determined in advance, and include item names, customer names, destinations (delivery destinations), and the like, for example.

FIG. 16 is a diagram showing an example of calculation results of daily balance for each item according to the present embodiment. As shown in FIG. 16, the tabulation unit 102d associates the daily transportation detail database 106k and the transportation detail cost database 106l with the transportation detail number, and aggregates (aggregates) the cost amount of each expense item for each item name. In addition, the aggregating unit 102d aggregates the freight charges (profits) registered in the daily transportation detail database 106k for each item name, and further, by subtracting the total cost value from the freight charges, totals the income and expenditure for each item.

FIG. 17 is a diagram showing an example of calculation results of daily balance for each customer according to this embodiment. FIG. 18 is a diagram showing an example of calculation results of daily balance for each delivery destination according to this embodiment. As shown in FIGS. 17 and 18, the tabulation unit 102d tabulates the cost amount and balance of each expense item for each customer name and delivery destination (arrival).

Next, the display control unit 102e displays the result corrected by the counting unit 102d as a daily balance sheet on the monitor 114 (S8). For example, as shown in FIGS. 16 to 18, the display control unit 102e creates a table showing the freight for each item, customer, and delivery destination, the cost amount for each expense, the total cost amount, and the balance. Each is displayed on the monitor 114 . Here, the processing of this flowchart ends.

In this way, the information processing apparatus 100 of the present embodiment acquires a predetermined standard cost associated with a predetermined expense item, and based on the standard cost and the daily report on transportation, daily Calculate the total cost amount. Therefore, according to the information processing apparatus 100 of the present embodiment, a manager or the like (user) of the transportation industry can quickly grasp the daily cost amount.

Conventionally, it may take time to grasp the actual cost based on the actual expenditure, and it may be difficult for the user to grasp the daily cost. On the other hand, according to the information processing apparatus 100 of the present embodiment, since the standard cost is used, the cost can be calculated daily without waiting until the actual cost is calculated. Further, according to the information processing apparatus 100 of the present embodiment, the daily cost can be calculated without the user calculating the cost on a per-diem basis, so the user's work load can be reduced.

In addition, when the daily report includes a plurality of details for each transportation, the information processing apparatus 100 of the present embodiment calculates the total amount of the cost for each predetermined expense item according to the proportional division standard (proportional division method classification) associated with the predetermined expense item. Prorate to each shipment. Therefore, according to the information processing apparatus 100 of the present embodiment, the user can easily grasp the daily cost for each transportation.

In this embodiment, the calculation unit 102b calculates the cost of the toll based on the toll actually paid. good. Further, although calculation unit 102b uses the actual fuel supply amount as the basis for calculating the fuel cost, the fuel cost may be calculated according to the travel distance.

Further, in the present embodiment, the tabulation unit 102d tabulates the cost amount and income/expenditure for each predetermined item, but the user can arbitrarily select an item as a tabulation unit on the screen. It is also possible to assume that

The present invention may be implemented in various different embodiments other than the embodiments described above within the scope of the technical idea described in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed can be manually performed, or all of the processes described as being manually performed Alternatively, some can be done automatically by known methods.

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

Also, with respect to the information processing apparatus 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions of the information processing apparatus 100, particularly the processing functions performed by the control unit 102, may be implemented in whole or in part by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing apparatus to execute the processing described in this embodiment, and the information processing apparatus as necessary. 100 mechanically read. That is, a storage unit such as a ROM or HDD (Hard Disk Drive) stores a computer program for giving commands to the CPU in cooperation with the OS to perform various processes. This computer program is executed by being loaded into the RAM and constitutes a control section in cooperation with the CPU.

Further, this computer program may be stored in an application program server connected to the information processing apparatus 100 via any network, and all or part of it can be downloaded as necessary. be.

Also, the program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" refers to memory cards, USB (Universal Serial Bus) memories, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (registered (trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Disc (registered trademark) such as Blu- shall include any "portable physical medium". Therefore, a recording medium storing a program for executing the processing or processing method described in this specification also constitutes the present invention.

A "program" is a data processing method written in any language or writing method, regardless of the format such as source code or binary code. In addition, the "program" is not necessarily limited to a single configuration, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, the installation procedure after reading, and the like.

The various databases and the like stored in the storage unit 106 are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and are used for various processes and website provision. programs, tables, databases, and files for web pages.

Further, the information processing apparatus 100 may be configured as an information processing apparatus such as a known personal computer or workstation, or may be configured as the information processing apparatus to which arbitrary peripheral devices are connected. Further, the information processing apparatus 100 may be implemented by installing software (including programs, data, etc.) that causes the apparatus to implement the processes described in the present embodiment.

Furthermore, the specific forms of distribution and integration of devices are not limited to those shown in the figures, and all or part of them can be functionally or physically arranged in arbitrary units according to various additions or functional loads. It can be distributed and integrated. That is, the embodiments described above may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

The invention is particularly useful in the transportation industry.

100 information processing device
102 control unit
102a Acquisition unit
102b calculator
102c Proportioning part
102d counting unit
102e display control unit
104 communication interface unit
106 storage unit
106a Expense item setting database
106b Unit price classification type database
106c Standard Cost Database
106d Cost Database by Crew
106e Cost Database by Vehicle
106f Apportionment Method Database by Expense Item
106g Apportionment method classification database
106h Daily report header database
106i Daily Toll Details Database
106j Daily refueling details database
106k Daily transportation details database
106l Freight detail cost database
108 input/output interface
112 input device
114 output device 200 server 300 network

Claims (4)

An information processing device comprising a control unit,
The control unit
Acquisition means for acquiring a standard price predetermined in association with a predetermined expense item and a unit price classification type classification indicating a calculation method for each expense item predetermined for each expense item;
Based on the acquired unit price classification type classification, the cost of repair expenses is calculated by multiplying the standard cost of repair expenses by the mileage included in the daily report on transportation, and the acquired unit price classification type Based on the classification, calculate the cost of labor cost by multiplying the standard cost of labor cost by the constraint time included in the daily report, and calculate the standard cost of fuel cost based on the unit price classification type classification , the fuel cost item cost is calculated by multiplying the refueling amount included in the daily report, and the calculated repair cost cost, labor cost cost, and fuel cost cost are added to the unit price classification type calculation means for calculating the total amount of daily costs by adding predetermined vehicle costs indicated by categories and tolls included in the daily report;
An information processing device comprising: When transporting a plurality of packages, the control unit
The acquiring means acquires an apportionment method classification indicating an apportionment method for each of the expense items,
The calculation means calculates the cost of the repair cost, the cost of the labor cost, the cost of the fuel cost, the vehicle cost, and the toll based on the obtained apportionment method classification. It is further equipped with an apportionment method that apportions each item number,
The calculation means adds the cost of the repair cost, the cost of the labor cost, the cost of the fuel cost, the vehicle cost, and the toll for each of the proportionally divided transportation item numbers, Calculating the total amount of the cost for each shipping line number,
The information processing apparatus according to claim 1, characterized by: An information processing method executed by an information processing device having a control unit,
executed by the control unit;
an acquisition step of acquiring a unit price classification type classification indicating a method of calculating each expense item, which is predetermined for each expense item, and a predetermined standard cost associated with a predetermined expense item;
Based on the acquired unit price classification type classification, the cost of repair expenses is calculated by multiplying the standard cost of repair expenses by the mileage included in the daily report on transportation, and the acquired unit price classification type Based on the classification, calculate the cost of labor cost by multiplying the standard cost of labor cost by the constraint time included in the daily report, and calculate the standard cost of fuel cost based on the unit price classification type classification , the fuel cost item cost is calculated by multiplying the refueling amount included in the daily report, and the calculated repair cost cost, labor cost cost, and fuel cost cost are added to the unit price classification type a calculation step of calculating the total amount of daily costs by adding predetermined vehicle costs indicated by categories and tolls included in the daily report;
including
An information processing method characterized by: An information processing program to be executed by an information processing apparatus having a control unit,
for causing the control unit to execute
an acquisition step of acquiring a unit price classification type classification indicating a method of calculating each expense item, which is predetermined for each expense item, and a predetermined standard cost associated with a predetermined expense item;
Based on the acquired unit price classification type classification, the cost of repair expenses is calculated by multiplying the standard cost of repair expenses by the mileage included in the daily report on transportation, and the acquired unit price classification type Based on the classification, calculate the cost of labor cost by multiplying the standard cost of labor cost by the constraint time included in the daily report, and calculate the standard cost of fuel cost based on the unit price classification type classification , the fuel cost item cost is calculated by multiplying the refueling amount included in the daily report, and the calculated repair cost cost, labor cost cost, and fuel cost cost are added to the unit price classification type a calculation step of calculating the total amount of daily costs by adding predetermined vehicle costs indicated by categories and tolls included in the daily report;
including
An information processing program characterized by

Images