WO2023095714A1 - Construction ledger creation system and construction ledger creation method - Google Patents

Construction ledger creation system and construction ledger creation method Download PDF

Info

Publication number
WO2023095714A1
WO2023095714A1 PCT/JP2022/042737 JP2022042737W WO2023095714A1 WO 2023095714 A1 WO2023095714 A1 WO 2023095714A1 JP 2022042737 W JP2022042737 W JP 2022042737W WO 2023095714 A1 WO2023095714 A1 WO 2023095714A1
Authority
WO
WIPO (PCT)
Prior art keywords
construction
data
cost
unit
cost data
Prior art date
Application number
PCT/JP2022/042737
Other languages
French (fr)
Japanese (ja)
Inventor
信行 平塚
Original Assignee
野原ホールディングス株式会社
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 野原ホールディングス株式会社 filed Critical 野原ホールディングス株式会社
Publication of WO2023095714A1 publication Critical patent/WO2023095714A1/en

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/10—Office automation; Time management
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/10—Office automation; Time management
    • G06Q10/109—Time management, e.g. calendars, reminders, meetings or time accounting
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/12—Accounting

Definitions

  • This disclosure relates to a construction ledger creation system and a construction ledger creation method.
  • Patent Document 1 describes a construction ledger creation system that creates a construction ledger based on input invoice data.
  • a construction ledger creation system includes a first storage unit that stores cost data for each construction, and daily report data input by a plurality of workers assigned to one construction.
  • a calculation unit that generates cost data of labor costs and registers the cost data of labor costs in the first storage unit, and a calculation unit that acquires the cost data of construction work from the first storage unit and creates a construction ledger based on the acquired cost data. and a creating unit for creating.
  • a construction ledger creation method includes steps of generating cost data of labor costs for construction work based on daily report data input by a plurality of workers assigned to the construction work; It includes steps of registering cost data in a storage unit, and acquiring cost data of construction work from the storage unit and creating a construction ledger based on the acquired cost data.
  • labor cost cost data for construction work is generated based on the daily report data of workers assigned to the construction work, and the labor cost cost data is stored in the first storage unit ( memory). Therefore, it is possible to omit the clerical work of registering the cost data of labor costs, so that the time required for the clerical work can be reduced.
  • Labor costs may include at least one of the wages of workers with employment relationships (employees) and expenses paid to workers without employment relationships (subcontractors).
  • the calculation unit may record the daily unit price of the worker as the labor cost on the working day.
  • the labor cost is calculated according to the number of days the worker has to work. Therefore, the labor cost can be calculated without calculating the actual working hours, so the calculation of the labor cost can be simplified.
  • the daily report data may include the start time, end time, and break time.
  • the calculation unit may calculate the actual working hours of each of the plurality of workers from the daily report data, and calculate labor costs based on the unit price per hour and the actual working hours of each worker. In this case, labor costs are calculated according to the hours the worker actually worked. Therefore, it is possible to improve the calculation accuracy of labor costs.
  • the unit price may be preset for each construction work.
  • the unit price of the worker can be freely set for each construction. Therefore, it is possible to set an appropriate unit price according to the content of the construction, and to optimize labor costs.
  • the unit price may be changed according to the difficulty of construction.
  • a worker's unit price may be set low for simple construction, and a worker's unit price may be set high for complex construction. Therefore, it is possible to set an appropriate unit price according to the content of the construction, and to optimize labor costs.
  • a construction ledger creation system includes: an acquisition unit that acquires order data for materials used in construction from a second storage unit that stores order data for materials used in each construction; A generating unit that generates cost data of material costs from the data and registers the cost data of material costs in the first storage unit.
  • the cost data of the material cost is generated from the order data, and the cost data of the material cost is registered in the first storage unit. Therefore, it is possible to omit the clerical work of registering the cost data of the material cost, so that it is possible to further reduce the time required for the clerical work.
  • FIG. 1 is a schematic configuration diagram of an information processing system including a construction ledger creation system according to one embodiment.
  • FIG. 2 is a diagram showing an example of a daily report application.
  • FIG. 3 is a diagram showing an example of daily report data.
  • FIG. 4 is a diagram showing an example of order reception/placement data stored in an order reception/placement DB (database).
  • FIG. 5 is a diagram showing an example of a construction ledger application.
  • FIG. 6 is a diagram showing an example of the hardware configuration of a computer that constitutes the construction ledger creation system shown in FIG.
  • FIG. 7 is a block diagram showing an example of the functional configuration of the construction ledger creating system shown in FIG.
  • FIG. 8 is a diagram showing an example of unit price data stored in the unit price DB.
  • FIG. 1 is a schematic configuration diagram of an information processing system including a construction ledger creation system according to one embodiment.
  • FIG. 2 is a diagram showing an example of a daily report application.
  • FIG. 3
  • FIG. 9 is a flowchart of a construction ledger creation method performed by the construction ledger creation system shown in FIG.
  • FIG. 10 is a diagram showing an example of cost data of material costs.
  • FIG. 11 is a diagram showing an example of cost data of labor costs.
  • FIG. 12 is a diagram showing an example of a construction ledger.
  • FIG. 1 is a schematic configuration diagram of an information processing system including a construction ledger creation system according to one embodiment.
  • FIG. 2 is a diagram showing an example of a daily report application.
  • FIG. 3 is a diagram showing an example of daily report data.
  • FIG. 4 is a diagram showing an example of order reception/placement data stored in an order reception/placement DB (database).
  • FIG. 5 is a diagram showing an example of a construction ledger application.
  • An information processing system 1 shown in FIG. 1 is a system for creating a construction ledger.
  • the construction ledger is a ledger that tallies the cost of each construction.
  • the costs entered in the construction ledger include material costs, labor costs, subcontracting costs, and expenses.
  • the material cost is the cost of materials (building materials) required for construction. Material costs may include the cost of the materials and the costs incurred in trading the materials.
  • Labor costs are the wages of workers assigned to the construction work. Wages of workers (employees) who have an employment relationship and expenses paid to workers (subcontractors) who do not have an employment relationship can both be expressed as labor costs.
  • the wages of workers (employees) with an employment relationship are referred to as labor costs
  • the costs paid to workers (subcontractors) with no employment relationship are referred to as outsourcing costs.
  • the intersection of costs and subcontracting costs may be expressed as labor costs. Expenses are other expenses that do not fall under the above expenses. Examples of expenses include usage fees for equipment used in construction and utility costs.
  • the information processing system 1 includes a worker terminal 2, an order receiving/ordering DB 3 (second storage unit), an office terminal 4, and a construction ledger creation system 10.
  • the worker terminal 2, the order receiving/ordering DB 3, and the office terminal 4 are communicably connected to the construction ledger creation system 10 via a communication network.
  • Communication networks may be wired or wireless. Examples of communication networks include the Internet, WAN (Wide Area Network), and mobile communication networks.
  • the worker terminal 2 is a terminal used by workers. Examples of the worker terminal 2 include smart phones, tablet terminals, and wearable terminals. Although one worker terminal 2 is shown in FIG. 1 , the information processing system 1 may include two or more worker terminals 2 . Each worker may own one worker terminal 2 . The worker terminal 2 may be shared by several workers. In this case, a desktop PC (Personal Computer) and a notebook PC may be used as the worker terminal 2 .
  • a daily report application is installed in the worker terminal 2 . The daily report application is an application for creating a daily work report. The worker creates a daily work report and submits the daily work report using the daily report application.
  • the daily report application displays on the worker terminal 2 a screen including widgets for inputting each item related to the daily work report.
  • Items related to the daily work report include, for example, date of work, job site name, start time, end time, break time, overtime hours, and work content.
  • the site name is configured to be selectable from a drop-down list.
  • Other items are configured so that workers can directly enter them in text boxes.
  • the worker submits the daily work report by clicking the daily report submission button after inputting the work performance (working performance).
  • the worker terminal 2 When the worker clicks the daily report submission button, the worker terminal 2 generates daily report data including the information entered in each item and the worker ID of the worker, and transmits the daily report data to the construction ledger creation system 10. do.
  • the daily report data includes a site code, work date, worker ID, work start time, work end time, break time, overtime work time, and work details.
  • a site code is identification information that can uniquely identify a construction site.
  • a worker ID is identification information that can uniquely identify a worker.
  • the ordering DB 3 is a database that stores ordering data for materials used for each construction. Ordering/ordering data is information relating to the ordering and receiving of materials.
  • the order receiving/placement DB 3 may be composed of one storage, or may be composed of a plurality of storages on a communication network such as cloud storage.
  • the order receiving/ordering DB 3 is a dedicated database for one vendor (supplier). Therefore, the order receiving/ordering DB 3 stores only one supplier's order/ordering data.
  • each order data includes a customer code, a site code, a shipping date, a detailed item, a quantity, a unit, a unit price, and an amount.
  • the customer code is identification information that can uniquely identify the customer who purchased (ordered) the material.
  • the shipping date is the shipping date of the material.
  • the detail item indicates the name (or abbreviation) of the material sold to the customer.
  • Quantity indicates the quantity of the material indicated by the line item sold to the customer.
  • a unit is a unit of quantity.
  • the unit price indicates the unit price of the material indicated by the detail item.
  • Amount indicates the total amount sold to the customer for the material indicated by the line item. The amount is obtained by multiplying the unit price and the quantity. Yen may be used as the unit of the unit price and the amount of money.
  • the office terminal 4 is a device used by a construction shop clerk.
  • the office terminal 4 may be used by the clerk of the construction shop. Examples of the office terminal 4 include desktop PCs, notebook PCs, tablet terminals, and smart phones.
  • a construction ledger application is installed in the office terminal 4 .
  • the construction ledger application is an application for managing the construction ledger.
  • the clerk (clerk) uses the construction ledger application to confirm and register the cost.
  • the construction ledger application displays on the office terminal 4 a screen for registering the cost for the selected construction (site).
  • the screen includes widgets for entering items related to costs. Items related to cost include, for example, cost category, accounting date, supplier, statement of delivery number, and detailed information.
  • a cost category is a type of cost. The cost categories are, for example, selectable from material costs, labor costs, subcontract costs, and expenses.
  • the recording date is the date on which the cost is recorded. In the material cost, the shipping date may be used as the accounting date.
  • a supplier is a business partner from whom a product such as a building material is purchased. Suppliers are configured to be selectable from, for example, pre-registered traders.
  • the detailed information is information indicating the details of the cost, and includes an ID, item, quantity, unit, unit price, and amount.
  • the ID is identification information that can uniquely identify the itemized items included in the same statement of delivery.
  • the detail item indicates the purchased product.
  • the quantity indicates the quantity of the product indicated by the detail item.
  • a unit is a unit of quantity.
  • the unit price indicates the unit price of the product indicated by the detail item.
  • the amount indicates the total amount of the product indicated by the item. The amount is obtained by multiplying the unit price and the quantity. Yen may be used as the unit of the unit price and the amount of money.
  • material cost is selected as the cost category, and detailed information for each material is entered.
  • the clerk registers the cost by clicking the "register cost” button (registration button).
  • registration button When the registration button is clicked by the clerk, the office terminal 4 generates cost data including the information entered in each item, and transmits the cost data to the construction ledger creation system 10 .
  • the office terminal 4 for example, generates cost data for each detailed item.
  • the cost data includes the site code, cost category, accounting date, supplier, detail item, quantity, unit, unit price, and amount (see FIGS. 10 and 11).
  • the clerk can also use the construction ledger application to display the cost data stored in the construction ledger creation system 10 (construction ledger DB 19 described later) on the office terminal 4 and confirm the contents.
  • the clerk can also update the cost data by correcting the content displayed on the office terminal 4 and clicking the registration button.
  • the construction ledger creation system 10 is a system that creates a construction ledger.
  • the construction ledger creation system 10 may be configured by one computer.
  • the construction ledger creation system 10 may be composed of a plurality of computers like cloud computing. In this case, the plurality of computers logically function as one construction ledger creation system 10 by being communicably connected to each other via a communication network.
  • FIG. 6 is a diagram showing an example of the hardware configuration of a computer that constitutes the construction ledger creation system shown in FIG.
  • computer 100 includes processor 101 , main memory device 102 , auxiliary memory device 103 , communication device 104 , input device 105 and output device 106 .
  • An example of the processor 101 is a CPU (Central Processing Unit).
  • the main storage device 102 is composed of a RAM (Random Access Memory), a ROM (Read Only Memory), and the like.
  • Examples of the auxiliary storage device 103 include a semiconductor memory and a hard disk device.
  • Examples of communication devices 104 include network cards and wireless communication modules.
  • Examples of input device 105 include a keyboard and mouse.
  • An example of output device 106 is a display.
  • the worker terminal 2 and office terminal 4 are also configured by similar computers.
  • Each functional element of the construction ledger creation system 10 is realized by causing hardware such as the processor 101 or the main storage device 102 to read a predetermined computer program and causing the processor 101 to execute the computer program.
  • the processor 101 operates each piece of hardware according to a computer program, and reads and writes data in the main storage device 102 and the auxiliary storage device 103 .
  • FIG. 7 is a block diagram showing an example of the functional configuration of the construction ledger creating system shown in FIG.
  • FIG. 8 is a diagram showing an example of unit price data stored in the unit price DB.
  • the construction ledger creation system 10 includes, as functional elements, an acquisition unit 11, a generation unit 12, a calculation unit 13, a creation unit 14, a daily report DB 16, a unit price DB 17, and a site DB 18.
  • construction ledger DB 19 first storage unit, storage unit. Since the function (operation) of each functional element will be described in detail in the description of the construction ledger creation method that will be described later, the function of each functional element will be briefly described here.
  • the daily report DB 16 is a database that stores daily report data.
  • the daily report DB 16 stores daily report data submitted by workers assigned to each construction (site).
  • the unit price DB 17 is a database that stores unit price data.
  • the unit price data is data indicating the unit price of the worker. As shown in FIG. 8, the unit price data includes worker ID, worker name, category, and cost per day.
  • the division indicates the affiliation of the worker. The classification indicates, for example, whether the worker is an employee (employee) or an outsourcer (subcontractor).
  • the cost per day indicates the cost per worker (unit price) per day.
  • Unit price data is created in advance for each worker and registered in the unit price DB 17 .
  • the site DB 18 is a database that stores site data.
  • the site data includes a site code and a site name. Site data is created in advance for each site and registered in the site DB 18 .
  • the construction ledger DB 19 is a database that stores cost data for each construction.
  • the construction ledger DB 19 stores the cost data generated by the generation unit 12, the cost data generated by the calculation unit 13, and the cost data acquired from the office terminal 4 by the acquisition unit 11.
  • the acquisition unit 11 is a functional element that acquires various data.
  • the acquisition unit 11 acquires, for example, daily report data, order data, and cost data. Specifically, when acquiring the daily report data from the worker terminal 2 , the acquisition unit 11 registers (adds) the daily report data as one record in the daily report DB 16 . After acquiring the cost data from the office terminal 4 , the acquisition unit 11 registers (adds) the cost data as one record in the construction ledger DB 19 .
  • the acquiring unit 11 outputs the order receiving/ordering data to the generating unit 12 after acquiring the order receiving/ordering data from the order receiving/ordering DB 3 .
  • the generation unit 12 is a functional element that generates cost data of material costs from order data and registers the cost data of material costs in the construction ledger DB 19 .
  • the generation unit 12 When receiving the order data from the acquisition unit 11 , the generation unit 12 generates cost data of material costs from the order data, and registers (adds) the cost data as one record in the construction ledger DB 19 .
  • the calculation unit 13 is a functional element that calculates labor costs and outsourcing costs and registers the cost data of the labor costs and outsourcing costs in the construction ledger DB 19 .
  • the calculation unit 13 calculates labor costs and subcontracting costs for one construction work based on daily report data input by a plurality of workers assigned to one construction work.
  • the calculation unit 13 generates cost data of labor costs and outsourcing costs, and registers (adds) the cost data as one record in the construction ledger DB 19 .
  • the creation unit 14 is a functional element that creates a construction ledger from the cost data stored in the construction ledger DB 19 . Upon receiving a command for creating a construction ledger (construction ledger creation command) from the office terminal 4 , the creation unit 14 creates a construction ledger and transmits the construction ledger to the office terminal 4 .
  • FIG. 9 is a flowchart of a construction ledger creation method performed by the construction ledger creation system shown in FIG.
  • FIG. 10 is a diagram showing an example of cost data of material costs.
  • FIG. 11 is a diagram showing an example of cost data of labor costs.
  • FIG. 12 is a diagram showing an example of a construction ledger. A series of processes shown in FIG. 9 are started each time a predetermined period of time elapses.
  • the acquisition unit 11 determines whether or not the timing for registering cost data of material costs has arrived (step S1). Registration of cost data of material costs is performed, for example, at a predetermined cycle. A cycle is, for example, one day.
  • the acquiring unit 11 determines that the timing for registering the cost data of material costs has arrived (step S1: YES)
  • it acquires the order receiving/ordering data from the order receiving/ordering DB 3 (step S2).
  • the acquisition unit 11 receives the customer code of the construction shop using the construction ledger creation system 10.
  • Order data is obtained from the order receiving/ordering DB3.
  • the acquiring unit 11 acquires the order receiving/ordering data including the customer codes of not only the construction shops that use the construction ledger creation system 10 but also the construction shops that do not use the construction ledger creation system 10 from the order receiving/ordering DB 3. good. For example, the obtaining unit 11 obtains only the order reception/placement data newly registered in the order reception/placement DB 3 after the previous order reception/placement data was obtained from the order reception/placement DB 3 . The acquisition unit 11 then outputs the acquired order data to the generation unit 12 .
  • the generation unit 12 receives the order data from the acquisition unit 11, it generates cost data of material costs from the order data (step S3). More specifically, the generation unit 12 extracts items (site code, detail item, quantity, unit, unit price, and amount) included in the cost data from among the items included in the order data. , to generate cost data that includes the extracted items. At this time, the generation unit 12 sets the shipping date included in the order data as the recording date of the cost data, and sets "material cost" as the cost classification of the cost data. Furthermore, the generation unit 12 sets the supplier of the order receiving/ordering data stored in the order receiving/ordering DB 3 as the supplier of the cost data.
  • the cost data shown in FIG. 10 is generated from the order data shown in FIG.
  • step S4 the generation unit 12 registers (adds) the cost data as one record in the construction ledger DB 19 (step S4). If it is determined in step S1 that the timing for registering the cost data of material costs has not arrived (step S1: NO), steps S2 to S4 are not executed.
  • the calculation unit 13 determines whether or not it is time to register the cost data of labor costs (step S5).
  • the cost data of labor costs and the cost data of outsourcing costs are generated by substantially the same process. Therefore, in the following explanation, when there is no need to distinguish between labor costs and subcontracting costs, both labor costs and subcontracting costs are simply referred to as "labor costs.”
  • Registration of cost data of labor costs is performed, for example, at a predetermined cycle. A cycle is, for example, one day.
  • the calculation unit 13 determines that the timing for registering the cost data of labor costs has arrived (step S5: YES)
  • the calculation unit 13 generates cost data of labor costs (step S6).
  • step S ⁇ b>6 when each of the workers assigned to the construction (site) goes to work, the calculation unit 13 records the unit price per day of the worker as the labor cost for the working day.
  • the calculation unit 13 acquires daily report data from the daily report DB 16 .
  • the calculation unit 13 acquires only the daily report data newly registered in the daily report DB 16 after the previous acquisition of the daily report data from the daily report DB 16 .
  • the calculation unit 13 extracts an item (site code) included in the cost data among the items included in the daily report data, and generates cost data including the extracted item.
  • the calculation unit 13 sets the working date included in the daily report data as the recording date of the cost data.
  • the calculation unit 13 uses the worker ID included in the daily report data as a key to acquire unit price data including the worker ID from the unit price DB 17 .
  • the calculation unit 13 sets the name of the worker included in the unit price data as the detail item of the cost data, and sets the cost per day included in the unit price data as the unit price of the cost data. At this time, the calculation unit 13 sets "1" as the quantity of the cost data and "day” as the unit of the cost data.
  • the calculation unit 13 sets "labor cost” as the cost category of the cost data and sets the name of the company as the supplier of the cost data. Further, the calculation unit 13 calculates the cost per day included in the unit price data as the labor cost, and sets the labor cost as the amount of the cost data.
  • the cost data shown in FIG. 11 is generated from the daily report data shown in FIG.
  • the calculation unit 13 sets "outsourcing cost” as the cost category of the cost data, and sets the name of the subcontractor as the supplier of the cost data. . Further, the calculation unit 13 calculates the cost per day included in the unit price data as the outsourcing cost, and sets the outsourcing cost as the amount of the cost data.
  • step S7 the calculation unit 13 registers (adds) the cost data as one record in the construction ledger DB 19 (step S7). If it is determined in step S5 that the timing for registering labor cost cost data has not come (step S5: NO), steps S6 and S7 are not executed.
  • the creation unit 14 determines whether or not the construction ledger creation system 10 has received a construction ledger creation command from the office terminal 4 (step S8).
  • the creation unit 14 determines that the construction ledger creating system 10 has received the construction ledger creating command (step S8: YES)
  • it creates a construction ledger (step S9).
  • the creating unit 14 uses the site code included in the construction ledger creation command as a key to acquire cost data including the site code from the construction ledger DB 19, and refers to the site DB 18 to associate the cost data with the site code. Gets the name of the site specified.
  • the creation unit 14 creates a construction ledger in a predetermined format based on the acquired data, and transmits the construction ledger to the office terminal 4 .
  • the construction ledger DB 19 stores cost data registered using the construction ledger application on the office terminal 4.
  • step S9 is not executed.
  • steps S1 to S4 the processes of steps S5 to S7, and the processes of steps S8 and S9 may be executed in any order, and two or more processes may be executed in parallel.
  • labor cost cost data for the construction is generated based on the daily report data of the worker assigned to the construction, and the labor cost cost data is stored in the construction ledger DB 19. registered with Therefore, it is possible to omit the clerical work of registering the cost data of labor costs, so that the time required for the clerical work can be reduced.
  • cost data of material costs is generated from the order data, and the cost data of material costs is registered in the construction ledger DB 19 . Therefore, it is possible to omit the clerical work of registering the cost data of the material cost, so that it is possible to further reduce the time required for the clerical work.
  • the calculation unit 13 records the daily unit price of the worker as the labor cost on the working day. According to this configuration, labor costs are calculated according to the number of working days of the worker. Therefore, the labor cost can be calculated without calculating the actual working hours, so the calculation of the labor cost can be simplified.
  • cost data for labor costs, outsourcing costs, and material costs are generated and registered in the construction ledger creation system 10, inadequacies and omissions in registration of these cost data can be avoided.
  • construction ledger creation system and construction ledger creation method according to the present disclosure are not limited to the above embodiments.
  • the order receiving/ordering DB 3 is a database dedicated to one supplier (supplier), but it may be a database shared by multiple suppliers. In other words, the order receiving/ordering DB 3 may store the order receiving/ordering data of a plurality of suppliers. In this case, cost data of materials purchased from a plurality of suppliers is registered in the construction ledger DB 19 . Therefore, it is possible to further omit the clerical work of registering the cost data of the material costs, so that the time required for the clerical work can be further reduced.
  • the unit price data includes the cost per day of the worker, but it may also include the cost per hour (unit price) of the worker.
  • the calculation unit 13 may calculate the actual working hours of each of the plurality of workers from the daily report data, and calculate labor costs based on the cost per hour and the actual working hours of each worker. Specifically, the calculation unit 13 calculates the actual working hours from the start time, end time, and break time included in the daily report data. For example, the calculation unit 13 calculates the actual working hours (working hours) by subtracting the starting time from the finishing time and further subtracting the break time from the result of the subtraction. Then, the calculation unit 13 calculates the labor cost of the worker by multiplying the actual working hours by the cost per hour. The calculation unit 13 may calculate the labor cost further based on the overtime hours included in the daily report data. The calculation unit 13 may calculate outsourcing costs in the same manner as labor costs.
  • one unit price data is set for one worker. That is, the unit price (cost per day) of each worker is fixed. The unit price (cost per day) of each worker may be changed.
  • a unit price may be set in advance for each construction (site) for one worker. That is, the unit price data may further include a site code, and the unit price data for each worker may be stored in the unit price DB 17 for each construction. According to this configuration, the unit price of the worker can be freely set for each construction. Therefore, it is possible to set an appropriate unit price according to the content of the construction, and to optimize labor costs (outsourcing costs).
  • the worker's unit price may be changed according to the difficulty of the construction.
  • each field data may further include a difficulty level.
  • the difficulty level indicates the difficulty level of construction at the site identified by the site code.
  • the calculation unit 13 changes the unit price of the worker using a preset adjustment coefficient according to the degree of difficulty. For example, the calculation unit 13 sets the value obtained by multiplying the unit price (cost per day) of the worker included in the unit price data by the adjustment coefficient as the unit price (cost per day) of the worker. In this case, the adjustment coefficient is set to a larger value, for example, as the difficulty level increases. According to this configuration, a worker's unit price can be set low for simple construction, and a worker's unit price can be set high for complicated construction. Therefore, it is possible to set an appropriate unit price according to the content of the construction, and to optimize labor costs (outsourcing costs).
  • the cost data of labor costs, outsourcing costs, and material costs are automatically generated by the construction ledger creation system 10, but only the cost data of labor costs and outsourcing costs may be automatically generated.
  • the construction ledger creation system 10 may not include the acquisition unit 11 and the generation unit 12 .
  • the construction ledger creation system 10 does not have to include one or more of the daily report DB 16, the unit price DB 17, and the site DB 18.
  • the daily report DB 16 , the unit price DB 17 , and the site DB 18 may be provided outside the construction ledger creation system 10 .
  • Ordering DB (second storage unit) 4 Office terminal 10 Construction ledger creation system 11 Acquisition unit 12 Generation unit 13 Calculation unit 14 Creation unit 16... Daily report DB, 17... Unit price DB, 18... Site DB, 19... Construction ledger DB (first storage unit, storage unit).

Abstract

This construction ledger creation system 10 comprises: a construction ledger DB 19 that stores cost data for each construction project; a calculation unit 13 that generates cost data on labor costs for construction on the basis of daily report data input by a plurality of workers assigned to a single construction project, and registers the cost data on labor costs in the construction ledger DB 19; and a creation unit 14 that acquires construction cost data from the construction ledger DB 19 and creates a construction ledger on the basis of the acquired cost data.

Description

工事台帳作成システム及び工事台帳作成方法Construction ledger creation system and construction ledger creation method
　本開示は、工事台帳作成システム及び工事台帳作成方法に関する。 This disclosure relates to a construction ledger creation system and a construction ledger creation method.
　特許文献１には、入力された請求書のデータに基づいて、工事台帳を作成する工事台帳作成システムが記載されている。 Patent Document 1 describes a construction ledger creation system that creates a construction ledger based on input invoice data.
特開２０００－１２３０７５号公報JP-A-2000-123075
　特許文献１に記載の工事台帳作成システムでは、会計の担当者（事務員）が入力インターフェースを用いて請求書のデータを入力している。このため、事務作業に多くの時間を要する。 In the construction ledger creation system described in Patent Document 1, the person in charge of accounting (clerk) uses an input interface to input invoice data. Therefore, a lot of time is required for office work.
　本技術分野では、事務作業に要する時間を削減することが望まれている。 In this technical field, it is desired to reduce the time required for clerical work.
　本開示の一側面に係る工事台帳作成システムは、工事ごとの原価データを格納する第１記憶部と、１つの工事に割り当てられている複数の作業員によって入力された日報データに基づいて、工事の労務費の原価データを生成し、労務費の原価データを第１記憶部に登録する算出部と、第１記憶部から工事の原価データを取得し、取得した原価データに基づいて工事台帳を作成する作成部と、を備える。 A construction ledger creation system according to one aspect of the present disclosure includes a first storage unit that stores cost data for each construction, and daily report data input by a plurality of workers assigned to one construction. A calculation unit that generates cost data of labor costs and registers the cost data of labor costs in the first storage unit, and a calculation unit that acquires the cost data of construction work from the first storage unit and creates a construction ledger based on the acquired cost data. and a creating unit for creating.
　本開示の別の側面に係る工事台帳作成方法は、工事に割り当てられている複数の作業員によって入力された日報データに基づいて、工事の労務費の原価データを生成するステップと、労務費の原価データを記憶部に登録するステップと、記憶部から工事の原価データを取得し、取得した原価データに基づいて工事台帳を作成するステップと、を含む。 A construction ledger creation method according to another aspect of the present disclosure includes steps of generating cost data of labor costs for construction work based on daily report data input by a plurality of workers assigned to the construction work; It includes steps of registering cost data in a storage unit, and acquiring cost data of construction work from the storage unit and creating a construction ledger based on the acquired cost data.
　これらの工事台帳作成システム及び工事台帳作成方法では、工事に割り当てられている作業員の日報データに基づいて、工事の労務費の原価データが生成され、労務費の原価データが第１記憶部（記憶部）に登録される。したがって、労務費の原価データを登録する事務作業を省略することができるので、事務作業に要する時間を削減することが可能となる。なお、労務費は、雇用関係を有する作業員（従業員）の賃金と、雇用関係が無い作業員（下請業者）に支払う費用と、の少なくとも一方を含み得る。 In these construction ledger creation system and construction ledger creation method, labor cost cost data for construction work is generated based on the daily report data of workers assigned to the construction work, and the labor cost cost data is stored in the first storage unit ( memory). Therefore, it is possible to omit the clerical work of registering the cost data of labor costs, so that the time required for the clerical work can be reduced. Labor costs may include at least one of the wages of workers with employment relationships (employees) and expenses paid to workers without employment relationships (subcontractors).
　いくつかの実施形態では、算出部は、複数の作業員のそれぞれが出勤日に出勤した場合に、当該作業員の１日当たりの単価を出勤日の労務費として計上してもよい。この場合、作業員の出勤日数に応じて労務費が算出される。したがって、実働時間を算出することなく労務費を算出することができるので、労務費の算出を簡易化することが可能となる。 In some embodiments, when each of a plurality of workers comes to work on the working day, the calculation unit may record the daily unit price of the worker as the labor cost on the working day. In this case, the labor cost is calculated according to the number of days the worker has to work. Therefore, the labor cost can be calculated without calculating the actual working hours, so the calculation of the labor cost can be simplified.
　いくつかの実施形態では、日報データは、始業時刻、終業時刻、及び休憩時間を含んでもよい。算出部は、日報データから複数の作業員のそれぞれの実働時間を算出し、各作業員の１時間当たりの単価と実働時間とに基づいて、労務費を算出してもよい。この場合、作業員が実際に働いていた時間に応じて労務費が算出される。したがって、労務費の算出精度を向上させることが可能となる。 In some embodiments, the daily report data may include the start time, end time, and break time. The calculation unit may calculate the actual working hours of each of the plurality of workers from the daily report data, and calculate labor costs based on the unit price per hour and the actual working hours of each worker. In this case, labor costs are calculated according to the hours the worker actually worked. Therefore, it is possible to improve the calculation accuracy of labor costs.
　いくつかの実施形態では、単価は、工事ごとに予め設定されてもよい。この場合、工事ごとに、作業員の単価を自由に設定することができる。したがって、工事の内容に応じた適切な単価を設定することができ、労務費の適正化を図ることが可能となる。 In some embodiments, the unit price may be preset for each construction work. In this case, the unit price of the worker can be freely set for each construction. Therefore, it is possible to set an appropriate unit price according to the content of the construction, and to optimize labor costs.
　いくつかの実施形態では、単価は、工事の難易度に応じて変更されてもよい。この場合、例えば、簡単な工事では、作業員の単価が低く設定され、複雑な工事では、作業員の単価が高く設定され得る。したがって、工事の内容に応じた適切な単価を設定することができ、労務費の適正化を図ることが可能となる。 In some embodiments, the unit price may be changed according to the difficulty of construction. In this case, for example, a worker's unit price may be set low for simple construction, and a worker's unit price may be set high for complex construction. Therefore, it is possible to set an appropriate unit price according to the content of the construction, and to optimize labor costs.
　いくつかの実施形態では、工事台帳作成システムは、工事ごとに用いられる材料の受発注データを格納する第２記憶部から、工事に用いられる材料の受発注データを取得する取得部と、受発注データから材料の材料費の原価データを生成し、材料費の原価データを第１記憶部に登録する生成部と、を更に備えてもよい。この場合、受発注データから材料費の原価データが生成され、材料費の原価データが第１記憶部に登録される。したがって、材料費の原価データを登録する事務作業を省略することができるので、事務作業に要する時間を更に削減することが可能となる。 In some embodiments, a construction ledger creation system includes: an acquisition unit that acquires order data for materials used in construction from a second storage unit that stores order data for materials used in each construction; A generating unit that generates cost data of material costs from the data and registers the cost data of material costs in the first storage unit. In this case, the cost data of the material cost is generated from the order data, and the cost data of the material cost is registered in the first storage unit. Therefore, it is possible to omit the clerical work of registering the cost data of the material cost, so that it is possible to further reduce the time required for the clerical work.
　本開示によれば、事務作業に要する時間を削減することができる。 According to this disclosure, it is possible to reduce the time required for clerical work.
図１は、一実施形態に係る工事台帳作成システムを含む情報処理システムの概略構成図である。FIG. 1 is a schematic configuration diagram of an information processing system including a construction ledger creation system according to one embodiment. 図２は、日報アプリケーションの一例を示す図である。FIG. 2 is a diagram showing an example of a daily report application. 図３は、日報データの一例を示す図である。FIG. 3 is a diagram showing an example of daily report data. 図４は、受発注ＤＢ（database）に格納されている受発注データの一例を示す図である。FIG. 4 is a diagram showing an example of order reception/placement data stored in an order reception/placement DB (database). 図５は、工事台帳アプリケーションの一例を示す図である。FIG. 5 is a diagram showing an example of a construction ledger application. 図６は、図１に示される工事台帳作成システムを構成するコンピュータのハードウェア構成の一例を示す図である。FIG. 6 is a diagram showing an example of the hardware configuration of a computer that constitutes the construction ledger creation system shown in FIG. 図７は、図１に示される工事台帳作成システムの機能構成の一例を示すブロック図である。FIG. 7 is a block diagram showing an example of the functional configuration of the construction ledger creating system shown in FIG. 図８は、単価ＤＢに格納されている単価データの一例を示す図である。FIG. 8 is a diagram showing an example of unit price data stored in the unit price DB. 図９は、図１に示される工事台帳作成システムが行う工事台帳作成方法のフローチャートである。FIG. 9 is a flowchart of a construction ledger creation method performed by the construction ledger creation system shown in FIG. 図１０は、材料費の原価データの一例を示す図である。FIG. 10 is a diagram showing an example of cost data of material costs. 図１１は、労務費の原価データの一例を示す図である。FIG. 11 is a diagram showing an example of cost data of labor costs. 図１２は、工事台帳の一例を示す図である。FIG. 12 is a diagram showing an example of a construction ledger.
　以下、図面を参照しながら本開示の実施形態が詳細に説明される。なお、図面の説明において同一要素には同一符号が付され、重複する説明は省略される。 Hereinafter, embodiments of the present disclosure will be described in detail with reference to the drawings. In the description of the drawings, the same elements are denoted by the same reference numerals, and overlapping descriptions are omitted.
　まず、図１～図５を参照して、一実施形態に係る工事台帳作成システムを含む情報処理システムを説明する。図１は、一実施形態に係る工事台帳作成システムを含む情報処理システムの概略構成図である。図２は、日報アプリケーションの一例を示す図である。図３は、日報データの一例を示す図である。図４は、受発注ＤＢ（database）に格納されている受発注データの一例を示す図である。図５は、工事台帳アプリケーションの一例を示す図である。図１に示される情報処理システム１は、工事台帳を作成するためのシステムである。 First, an information processing system including a construction ledger creation system according to one embodiment will be described with reference to FIGS. FIG. 1 is a schematic configuration diagram of an information processing system including a construction ledger creation system according to one embodiment. FIG. 2 is a diagram showing an example of a daily report application. FIG. 3 is a diagram showing an example of daily report data. FIG. 4 is a diagram showing an example of order reception/placement data stored in an order reception/placement DB (database). FIG. 5 is a diagram showing an example of a construction ledger application. An information processing system 1 shown in FIG. 1 is a system for creating a construction ledger.
　工事台帳は、工事ごとの原価を集計する台帳である。工事台帳に記入される費用は、材料費、労務費、外注費、及び経費を含む。材料費は、工事に必要な材料（建材）の費用である。材料費は、材料の原価、及び材料の取引に要した費用を含み得る。労務費は、工事に割り当てられている作業員の賃金である。なお、雇用関係を有する作業員（従業員）の賃金と、雇用関係が無い作業員（下請業者）に支払う費用とは、いずれも労務費として表現され得る。本実施形態では、雇用関係を有する作業員（従業員）の賃金を労務費と称し、雇用関係が無い作業員（下請業者）に支払う費用を外注費と称し、これらを区別しているが、労務費と外注費との共通部分は労務費として表現される場合がある。経費は、上記費用に該当しないその他の費用である。経費の例としては、工事に用いられた機材の使用料、及び光熱費が挙げられる。 The construction ledger is a ledger that tallies the cost of each construction. The costs entered in the construction ledger include material costs, labor costs, subcontracting costs, and expenses. The material cost is the cost of materials (building materials) required for construction. Material costs may include the cost of the materials and the costs incurred in trading the materials. Labor costs are the wages of workers assigned to the construction work. Wages of workers (employees) who have an employment relationship and expenses paid to workers (subcontractors) who do not have an employment relationship can both be expressed as labor costs. In this embodiment, the wages of workers (employees) with an employment relationship are referred to as labor costs, and the costs paid to workers (subcontractors) with no employment relationship are referred to as outsourcing costs. The intersection of costs and subcontracting costs may be expressed as labor costs. Expenses are other expenses that do not fall under the above expenses. Examples of expenses include usage fees for equipment used in construction and utility costs.
　情報処理システム１は、作業員端末２と、受発注ＤＢ３（第２記憶部）と、事務端末４と、工事台帳作成システム１０と、を含む。作業員端末２、受発注ＤＢ３、及び事務端末４は、通信ネットワークを介して工事台帳作成システム１０に通信可能に接続されている。通信ネットワークは、有線及び無線のいずれで構成されてもよい。通信ネットワークの例としては、インターネット、ＷＡＮ（Wide　Area　Network）、及び移動体通信網が挙げられる。 The information processing system 1 includes a worker terminal 2, an order receiving/ordering DB 3 (second storage unit), an office terminal 4, and a construction ledger creation system 10. The worker terminal 2, the order receiving/ordering DB 3, and the office terminal 4 are communicably connected to the construction ledger creation system 10 via a communication network. Communication networks may be wired or wireless. Examples of communication networks include the Internet, WAN (Wide Area Network), and mobile communication networks.
　作業員端末２は、作業員が使用する端末である。作業員端末２の例としては、スマートフォン、タブレット端末、及びウェアラブル端末が挙げられる。図１には、１つの作業員端末２が示されているが、情報処理システム１は、２以上の作業員端末２を含んでもよい。各作業員が１台ずつ作業員端末２を所有してもよい。作業員端末２が何人かの作業員に共有されてもよい。この場合、作業員端末２として、デスクトップＰＣ（Personal　Computer）及びノートＰＣが用いられてもよい。作業員端末２には、日報アプリケーションがインストールされている。日報アプリケーションは、作業日報を作成するためのアプリケーションである。作業員は、日報アプリケーションを用いて、作業日報を作成し、作業日報を提出する。 The worker terminal 2 is a terminal used by workers. Examples of the worker terminal 2 include smart phones, tablet terminals, and wearable terminals. Although one worker terminal 2 is shown in FIG. 1 , the information processing system 1 may include two or more worker terminals 2 . Each worker may own one worker terminal 2 . The worker terminal 2 may be shared by several workers. In this case, a desktop PC (Personal Computer) and a notebook PC may be used as the worker terminal 2 . A daily report application is installed in the worker terminal 2 . The daily report application is an application for creating a daily work report. The worker creates a daily work report and submits the daily work report using the daily report application.
　図２に示されるように、日報アプリケーションは、作業日報に関する各項目を入力するためのウィジェットを含む画面を作業員端末２に表示する。作業日報に関する項目は、例えば、出勤日、現場名、始業時刻、終業時刻、休憩時間、残業時間、及び作業内容を含む。図２に示される例では、現場名は、ドロップダウンリストから選択可能に構成されている。その他の項目は、テキストボックスに作業員が直接入力可能に構成されている。作業員は、作業実績（勤務実績）を入力した後、日報提出ボタンをクリックすることによって、作業日報を提出する。作業員によって日報提出ボタンがクリックされると、作業員端末２は、各項目に入力された情報及び作業員の作業員ＩＤを含む日報データを生成し、日報データを工事台帳作成システム１０に送信する。 As shown in FIG. 2, the daily report application displays on the worker terminal 2 a screen including widgets for inputting each item related to the daily work report. Items related to the daily work report include, for example, date of work, job site name, start time, end time, break time, overtime hours, and work content. In the example shown in FIG. 2, the site name is configured to be selectable from a drop-down list. Other items are configured so that workers can directly enter them in text boxes. The worker submits the daily work report by clicking the daily report submission button after inputting the work performance (working performance). When the worker clicks the daily report submission button, the worker terminal 2 generates daily report data including the information entered in each item and the worker ID of the worker, and transmits the daily report data to the construction ledger creation system 10. do.
　図３に示されるように、日報データは、現場コード、出勤日、作業員ＩＤ、始業時刻、終業時刻、休憩時間、残業時間、及び作業内容を含む。現場コードは、工事現場を一意に識別可能な識別情報である。作業員ＩＤは、作業員を一意に識別可能な識別情報である。 As shown in FIG. 3, the daily report data includes a site code, work date, worker ID, work start time, work end time, break time, overtime work time, and work details. A site code is identification information that can uniquely identify a construction site. A worker ID is identification information that can uniquely identify a worker.
　受発注ＤＢ３は、工事ごとに用いられる材料の受発注データを格納するデータベースである。受発注データは、材料の受発注に関する情報である。受発注ＤＢ３は、１台のストレージによって構成されてもよく、クラウドストレージのように通信ネットワーク上の複数台のストレージによって構成されてもよい。なお、本実施形態では、受発注ＤＢ３は、１つの仕入先（サプライヤ）の専用のデータベースである。したがって、受発注ＤＢ３は、１つの仕入先の受発注データのみを格納している。 The ordering DB 3 is a database that stores ordering data for materials used for each construction. Ordering/ordering data is information relating to the ordering and receiving of materials. The order receiving/placement DB 3 may be composed of one storage, or may be composed of a plurality of storages on a communication network such as cloud storage. In this embodiment, the order receiving/ordering DB 3 is a dedicated database for one vendor (supplier). Therefore, the order receiving/ordering DB 3 stores only one supplier's order/ordering data.
　図４に示されるように、各受発注データは、顧客コードと、現場コードと、出荷日と、明細項目と、数量と、単位と、単価と、金額と、を含む。顧客コードは、材料を購入（発注）した顧客を一意に識別可能な識別情報である。出荷日は、材料の出荷日である。明細項目は、顧客に販売された材料の名称（又は略称）を示す。数量は、明細項目によって示される材料の、顧客に販売された数量を示す。単位は、数量の単位である。単価は、明細項目によって示される材料の単価を示す。金額は、明細項目によって示される材料の、顧客に販売された総額を示す。金額は、単価と数量とを乗算することによって得られる。単価及び金額の単位としては、円が用いられてもよい。顧客から材料の発注を受けるごとに、受発注データが生成され、受発注ＤＢ３に格納される。 　As shown in Fig. 4, each order data includes a customer code, a site code, a shipping date, a detailed item, a quantity, a unit, a unit price, and an amount. The customer code is identification information that can uniquely identify the customer who purchased (ordered) the material. The shipping date is the shipping date of the material. The detail item indicates the name (or abbreviation) of the material sold to the customer. Quantity indicates the quantity of the material indicated by the line item sold to the customer. A unit is a unit of quantity. The unit price indicates the unit price of the material indicated by the detail item. Amount indicates the total amount sold to the customer for the material indicated by the line item. The amount is obtained by multiplying the unit price and the quantity. Yen may be used as the unit of the unit price and the amount of money. Each time an order for materials is received from a customer, order receipt/placement data is generated and stored in the order receipt/placement DB 3 .
　事務端末４は、工事店の事務員が用いる装置である。事務端末４は、工事店の番頭によって用いられてもよい。事務端末４の例としては、デスクトップＰＣ、ノートＰＣ、タブレット端末、及びスマートフォンが挙げられる。事務端末４には、工事台帳アプリケーションがインストールされている。工事台帳アプリケーションは、工事台帳を管理するためのアプリケーションである。事務員（番頭）は、工事台帳アプリケーションを用いて、原価の確認及び登録を行う。 The office terminal 4 is a device used by a construction shop clerk. The office terminal 4 may be used by the clerk of the construction shop. Examples of the office terminal 4 include desktop PCs, notebook PCs, tablet terminals, and smart phones. A construction ledger application is installed in the office terminal 4 . The construction ledger application is an application for managing the construction ledger. The clerk (clerk) uses the construction ledger application to confirm and register the cost.
　図５に示されるように、工事台帳アプリケーションは、選択された工事（現場）に対して原価の登録を行うための画面を事務端末４に表示する。画面は、原価に関する各項目を入力するためのウィジェットを含む。原価に関する項目は、例えば、原価区分、計上年月日、仕入先、納品書番号、及び詳細情報を含む。原価区分は、原価の種類である。原価区分は、例えば、材料費、労務費、外注費、及び経費から選択可能に構成されている。計上年月日は、原価を計上する日付である。材料費では、計上年月日として出荷日が用いられてもよい。仕入先は、建材等の商品を購入する相手となる取引先である。仕入先は、例えば、予め登録されている業者から選択可能に構成されている。 As shown in FIG. 5, the construction ledger application displays on the office terminal 4 a screen for registering the cost for the selected construction (site). The screen includes widgets for entering items related to costs. Items related to cost include, for example, cost category, accounting date, supplier, statement of delivery number, and detailed information. A cost category is a type of cost. The cost categories are, for example, selectable from material costs, labor costs, subcontract costs, and expenses. The recording date is the date on which the cost is recorded. In the material cost, the shipping date may be used as the accounting date. A supplier is a business partner from whom a product such as a building material is purchased. Suppliers are configured to be selectable from, for example, pre-registered traders.
　詳細情報は、原価の詳細を示す情報であり、ＩＤと、明細項目と、数量と、単位と、単価と、金額と、を含む。ＩＤは、同一の納品書に含まれる明細項目を一意に識別可能な識別情報である。明細項目は、購入した商品を示す。数量は、明細項目によって示される商品の数量を示す。単位は、数量の単位である。単価は、明細項目によって示される商品の単価を示す。金額は、明細項目によって示される商品の総額を示す。金額は、単価と数量とを乗算することによって得られる。単価及び金額の単位としては、円が用いられてもよい。 The detailed information is information indicating the details of the cost, and includes an ID, item, quantity, unit, unit price, and amount. The ID is identification information that can uniquely identify the itemized items included in the same statement of delivery. The detail item indicates the purchased product. The quantity indicates the quantity of the product indicated by the detail item. A unit is a unit of quantity. The unit price indicates the unit price of the product indicated by the detail item. The amount indicates the total amount of the product indicated by the item. The amount is obtained by multiplying the unit price and the quantity. Yen may be used as the unit of the unit price and the amount of money.
　図５に示される例では、原価区分として材料費が選択され、各材料の詳細情報が入力されている。事務員は、事務端末４を用いて手動で各項目を入力した後、「原価を登録する」ボタン（登録ボタン）をクリックすることによって、原価を登録する。事務員によって登録ボタンがクリックされると、事務端末４は、各項目に入力された情報を含む原価データを生成し、原価データを工事台帳作成システム１０に送信する。事務端末４は、例えば、明細項目ごとに原価データを生成する。原価データは、現場コード、原価区分、計上年月日、仕入先、明細項目、数量、単位、単価、及び金額を含む（図１０及び図１１参照）。 In the example shown in Fig. 5, material cost is selected as the cost category, and detailed information for each material is entered. After manually inputting each item using the office terminal 4, the clerk registers the cost by clicking the "register cost" button (registration button). When the registration button is clicked by the clerk, the office terminal 4 generates cost data including the information entered in each item, and transmits the cost data to the construction ledger creation system 10 . The office terminal 4, for example, generates cost data for each detailed item. The cost data includes the site code, cost category, accounting date, supplier, detail item, quantity, unit, unit price, and amount (see FIGS. 10 and 11).
　なお、事務員は、工事台帳アプリケーションを用いて、工事台帳作成システム１０（後述の工事台帳ＤＢ１９）に格納されている原価データを事務端末４に表示させ、その内容を確認することもできる。事務員は、事務端末４に表示された内容を修正し、登録ボタンをクリックすることによって、原価データを更新することもできる。 The clerk can also use the construction ledger application to display the cost data stored in the construction ledger creation system 10 (construction ledger DB 19 described later) on the office terminal 4 and confirm the contents. The clerk can also update the cost data by correcting the content displayed on the office terminal 4 and clicking the registration button.
　工事台帳作成システム１０は、工事台帳を作成するシステムである。工事台帳作成システム１０は、１台のコンピュータによって構成されてもよい。工事台帳作成システム１０は、クラウドコンピューティングのように複数台のコンピュータによって構成されてもよい。この場合、複数台のコンピュータは、通信ネットワークによって互いに通信可能に接続されることで、論理的に１つの工事台帳作成システム１０として機能する。 The construction ledger creation system 10 is a system that creates a construction ledger. The construction ledger creation system 10 may be configured by one computer. The construction ledger creation system 10 may be composed of a plurality of computers like cloud computing. In this case, the plurality of computers logically function as one construction ledger creation system 10 by being communicably connected to each other via a communication network.
　図６は、図１に示される工事台帳作成システムを構成するコンピュータのハードウェア構成の一例を示す図である。図６に示されるように、コンピュータ１００は、プロセッサ１０１、主記憶装置１０２、補助記憶装置１０３、通信装置１０４、入力装置１０５、及び出力装置１０６を含む。プロセッサ１０１の例としては、ＣＰＵ（Central　Processing　Unit）が挙げられる。主記憶装置１０２は、ＲＡＭ（Random　Access　Memory）及びＲＯＭ（Read　Only　Memory）等で構成される。補助記憶装置１０３の例としては、半導体メモリ及びハードディスク装置が挙げられる。通信装置１０４の例としては、ネットワークカード及び無線通信モジュールが挙げられる。入力装置１０５の例としては、キーボード及びマウスが挙げられる。出力装置１０６の例としては、ディスプレイが挙げられる。なお、作業員端末２及び事務端末４も同様のコンピュータによって構成される。 FIG. 6 is a diagram showing an example of the hardware configuration of a computer that constitutes the construction ledger creation system shown in FIG. As shown in FIG. 6, computer 100 includes processor 101 , main memory device 102 , auxiliary memory device 103 , communication device 104 , input device 105 and output device 106 . An example of the processor 101 is a CPU (Central Processing Unit). The main storage device 102 is composed of a RAM (Random Access Memory), a ROM (Read Only Memory), and the like. Examples of the auxiliary storage device 103 include a semiconductor memory and a hard disk device. Examples of communication devices 104 include network cards and wireless communication modules. Examples of input device 105 include a keyboard and mouse. An example of output device 106 is a display. The worker terminal 2 and office terminal 4 are also configured by similar computers.
　工事台帳作成システム１０の各機能要素は、プロセッサ１０１又は主記憶装置１０２等のハードウェアに所定のコンピュータプログラムを読み込ませ、プロセッサ１０１にそのコンピュータプログラムを実行させることによって実現される。プロセッサ１０１は、コンピュータプログラムに従って、各ハードウェアを動作させるとともに、主記憶装置１０２及び補助記憶装置１０３におけるデータの読み出し及び書き込みを行う。 Each functional element of the construction ledger creation system 10 is realized by causing hardware such as the processor 101 or the main storage device 102 to read a predetermined computer program and causing the processor 101 to execute the computer program. The processor 101 operates each piece of hardware according to a computer program, and reads and writes data in the main storage device 102 and the auxiliary storage device 103 .
　続いて、図７及び図８を参照して、工事台帳作成システム１０の機能構成を説明する。図７は、図１に示される工事台帳作成システムの機能構成の一例を示すブロック図である。図８は、単価ＤＢに格納されている単価データの一例を示す図である。図７に示されるように、工事台帳作成システム１０は、機能要素として、取得部１１と、生成部１２と、算出部１３と、作成部１４と、日報ＤＢ１６と、単価ＤＢ１７と、現場ＤＢ１８と、工事台帳ＤＢ１９（第１記憶部、記憶部）と、を含む。後述の工事台帳作成方法の説明において、各機能要素の機能（動作）を詳細に説明するので、ここでは各機能要素の機能を簡単に説明する。 Next, the functional configuration of the construction ledger creation system 10 will be described with reference to FIGS. 7 and 8. FIG. FIG. 7 is a block diagram showing an example of the functional configuration of the construction ledger creating system shown in FIG. FIG. 8 is a diagram showing an example of unit price data stored in the unit price DB. As shown in FIG. 7, the construction ledger creation system 10 includes, as functional elements, an acquisition unit 11, a generation unit 12, a calculation unit 13, a creation unit 14, a daily report DB 16, a unit price DB 17, and a site DB 18. , construction ledger DB 19 (first storage unit, storage unit). Since the function (operation) of each functional element will be described in detail in the description of the construction ledger creation method that will be described later, the function of each functional element will be briefly described here.
　日報ＤＢ１６は、日報データを格納するデータベースである。日報ＤＢ１６は、各工事（現場）に割り当てられた作業員によって提出された日報データを格納している。 The daily report DB 16 is a database that stores daily report data. The daily report DB 16 stores daily report data submitted by workers assigned to each construction (site).
　単価ＤＢ１７は、単価データを格納するデータベースである。単価データは、作業員の単価を示すデータである。図８に示されるように、単価データは、作業員ＩＤと、作業員氏名と、区分と、１日当たりの原価と、を含む。区分は、作業員の所属を示す。区分は、例えば、作業員が社員（従業員）であるか外注（下請業者）であるかを示す。１日当たりの原価は、作業員の１日当たりの原価（単価）を示す。単価データは、作業員ごとに予め作成され、単価ＤＢ１７に登録されている。 The unit price DB 17 is a database that stores unit price data. The unit price data is data indicating the unit price of the worker. As shown in FIG. 8, the unit price data includes worker ID, worker name, category, and cost per day. The division indicates the affiliation of the worker. The classification indicates, for example, whether the worker is an employee (employee) or an outsourcer (subcontractor). The cost per day indicates the cost per worker (unit price) per day. Unit price data is created in advance for each worker and registered in the unit price DB 17 .
　現場ＤＢ１８は、現場データを格納するデータベースである。現場データは、現場コードと、現場名と、を含む。現場データは、現場ごとに予め作成され、現場ＤＢ１８に登録されている。 The site DB 18 is a database that stores site data. The site data includes a site code and a site name. Site data is created in advance for each site and registered in the site DB 18 .
　工事台帳ＤＢ１９は、工事ごとの原価データを格納するデータベースである。工事台帳ＤＢ１９は、生成部１２によって生成された原価データ、算出部１３によって生成された原価データ、及び取得部１１によって事務端末４から取得された原価データを格納している。 The construction ledger DB 19 is a database that stores cost data for each construction. The construction ledger DB 19 stores the cost data generated by the generation unit 12, the cost data generated by the calculation unit 13, and the cost data acquired from the office terminal 4 by the acquisition unit 11.
　取得部１１は、各種データを取得する機能要素である。取得部１１は、例えば、日報データ、受発注データ、及び原価データを取得する。具体的には、取得部１１は、作業員端末２から日報データを取得すると、日報データを１つのレコードとして日報ＤＢ１６に登録（追加）する。取得部１１は、事務端末４から原価データを取得すると、原価データを１つのレコードとして工事台帳ＤＢ１９に登録（追加）する。取得部１１は、受発注ＤＢ３から受発注データを取得すると、受発注データを生成部１２に出力する。 The acquisition unit 11 is a functional element that acquires various data. The acquisition unit 11 acquires, for example, daily report data, order data, and cost data. Specifically, when acquiring the daily report data from the worker terminal 2 , the acquisition unit 11 registers (adds) the daily report data as one record in the daily report DB 16 . After acquiring the cost data from the office terminal 4 , the acquisition unit 11 registers (adds) the cost data as one record in the construction ledger DB 19 . The acquiring unit 11 outputs the order receiving/ordering data to the generating unit 12 after acquiring the order receiving/ordering data from the order receiving/ordering DB 3 .
　生成部１２は、受発注データから材料費の原価データを生成し、材料費の原価データを工事台帳ＤＢ１９に登録する機能要素である。生成部１２は、取得部１１から受発注データを受け取ると、受発注データから材料費の原価データを生成し、原価データを１つのレコードとして工事台帳ＤＢ１９に登録（追加）する。 The generation unit 12 is a functional element that generates cost data of material costs from order data and registers the cost data of material costs in the construction ledger DB 19 . When receiving the order data from the acquisition unit 11 , the generation unit 12 generates cost data of material costs from the order data, and registers (adds) the cost data as one record in the construction ledger DB 19 .
　算出部１３は、労務費及び外注費を算出し、労務費及び外注費の原価データを工事台帳ＤＢ１９に登録する機能要素である。算出部１３は、１つの工事に割り当てられている複数の作業員によって入力された日報データに基づいて、当該工事の労務費及び外注費を算出する。算出部１３は、労務費及び外注費の原価データを生成し、原価データを１つのレコードとして工事台帳ＤＢ１９に登録（追加）する。 The calculation unit 13 is a functional element that calculates labor costs and outsourcing costs and registers the cost data of the labor costs and outsourcing costs in the construction ledger DB 19 . The calculation unit 13 calculates labor costs and subcontracting costs for one construction work based on daily report data input by a plurality of workers assigned to one construction work. The calculation unit 13 generates cost data of labor costs and outsourcing costs, and registers (adds) the cost data as one record in the construction ledger DB 19 .
　作成部１４は、工事台帳ＤＢ１９に格納されている原価データから工事台帳を作成する機能要素である。作成部１４は、事務端末４から工事台帳を作成するための指令（工事台帳作成指令）を受信すると、工事台帳を作成し、工事台帳を事務端末４に送信する。 The creation unit 14 is a functional element that creates a construction ledger from the cost data stored in the construction ledger DB 19 . Upon receiving a command for creating a construction ledger (construction ledger creation command) from the office terminal 4 , the creation unit 14 creates a construction ledger and transmits the construction ledger to the office terminal 4 .
　次に、図９～図１２を参照して、工事台帳作成システム１０が行う工事台帳作成方法を説明する。図９は、図１に示される工事台帳作成システムが行う工事台帳作成方法のフローチャートである。図１０は、材料費の原価データの一例を示す図である。図１１は、労務費の原価データの一例を示す図である。図１２は、工事台帳の一例を示す図である。図９に示される一連の処理は、所定時間が経過するごとに開始される。 Next, a construction ledger creation method performed by the construction ledger creation system 10 will be described with reference to FIGS. FIG. 9 is a flowchart of a construction ledger creation method performed by the construction ledger creation system shown in FIG. FIG. 10 is a diagram showing an example of cost data of material costs. FIG. 11 is a diagram showing an example of cost data of labor costs. FIG. 12 is a diagram showing an example of a construction ledger. A series of processes shown in FIG. 9 are started each time a predetermined period of time elapses.
　まず、取得部１１は、材料費の原価データの登録タイミングが到来したか否かを判定する（ステップＳ１）。材料費の原価データの登録は、例えば、予め定められた周期で実行される。周期は、例えば、１日である。取得部１１は、材料費の原価データの登録タイミングが到来したと判定すると（ステップＳ１：ＹＥＳ）、受発注ＤＢ３から受発注データを取得する（ステップＳ２）。このとき、すべての顧客（工事店）が工事台帳作成システム１０を利用しているとは限らないので、取得部１１は、工事台帳作成システム１０を利用している工事店の顧客コードを含む受発注データを受発注ＤＢ３から取得する。取得部１１は、工事台帳作成システム１０を利用している工事店だけでなく、工事台帳作成システム１０を利用していない工事店の顧客コードを含む受発注データを受発注ＤＢ３から取得してもよい。例えば、取得部１１は、受発注ＤＢ３から受発注データを前回取得してから新たに受発注ＤＢ３に登録された受発注データのみを取得する。そして、取得部１１は、取得した受発注データを生成部１２に出力する。 First, the acquisition unit 11 determines whether or not the timing for registering cost data of material costs has arrived (step S1). Registration of cost data of material costs is performed, for example, at a predetermined cycle. A cycle is, for example, one day. When the acquiring unit 11 determines that the timing for registering the cost data of material costs has arrived (step S1: YES), it acquires the order receiving/ordering data from the order receiving/ordering DB 3 (step S2). At this time, since not all customers (construction shops) use the construction ledger creation system 10, the acquisition unit 11 receives the customer code of the construction shop using the construction ledger creation system 10. Order data is obtained from the order receiving/ordering DB3. The acquiring unit 11 acquires the order receiving/ordering data including the customer codes of not only the construction shops that use the construction ledger creation system 10 but also the construction shops that do not use the construction ledger creation system 10 from the order receiving/ordering DB 3. good. For example, the obtaining unit 11 obtains only the order reception/placement data newly registered in the order reception/placement DB 3 after the previous order reception/placement data was obtained from the order reception/placement DB 3 . The acquisition unit 11 then outputs the acquired order data to the generation unit 12 .
　続いて、生成部１２は、取得部１１から受発注データを受け取ると、受発注データから材料費の原価データを生成する（ステップＳ３）。具体的に説明すると、生成部１２は、受発注データに含まれる項目のうちの原価データに含まれる項目（現場コード、明細項目、数量、単位、単価、及び金額）を受発注データから抽出し、抽出した項目を含む原価データを生成する。このとき、生成部１２は、受発注データに含まれる出荷日を原価データの計上年月日として設定し、原価データの原価区分として「材料費」を設定する。さらに、生成部１２は、受発注ＤＢ３が格納している受発注データの仕入先を、原価データの仕入先として設定する。以上の処理により、例えば、図４に示される受発注データから図１０に示される原価データが生成される。 Subsequently, when the generation unit 12 receives the order data from the acquisition unit 11, it generates cost data of material costs from the order data (step S3). More specifically, the generation unit 12 extracts items (site code, detail item, quantity, unit, unit price, and amount) included in the cost data from among the items included in the order data. , to generate cost data that includes the extracted items. At this time, the generation unit 12 sets the shipping date included in the order data as the recording date of the cost data, and sets "material cost" as the cost classification of the cost data. Furthermore, the generation unit 12 sets the supplier of the order receiving/ordering data stored in the order receiving/ordering DB 3 as the supplier of the cost data. By the above processing, for example, the cost data shown in FIG. 10 is generated from the order data shown in FIG.
　続いて、生成部１２は、原価データを１つのレコードとして工事台帳ＤＢ１９に登録（追加）する（ステップＳ４）。ステップＳ１において、材料費の原価データの登録タイミングが到来していないと判定された場合（ステップＳ１：ＮＯ）、ステップＳ２～Ｓ４は実行されない。 Subsequently, the generation unit 12 registers (adds) the cost data as one record in the construction ledger DB 19 (step S4). If it is determined in step S1 that the timing for registering the cost data of material costs has not arrived (step S1: NO), steps S2 to S4 are not executed.
　続いて、算出部１３は、労務費の原価データの登録タイミングが到来したか否かを判定する（ステップＳ５）。なお、労務費の原価データと外注費の原価データとは、実質的に同じ処理によって生成される。したがって、以下の説明では、労務費と外注費とを区別する必要が無い場合には、労務費及び外注費を含めて単に「労務費」と称している。労務費の原価データの登録は、例えば、予め定められた周期で実行される。周期は、例えば、１日である。算出部１３は、労務費の原価データの登録タイミングが到来したと判定すると（ステップＳ５：ＹＥＳ）、労務費の原価データを生成する（ステップＳ６）。ステップＳ６では、算出部１３は、工事（現場）に割り当てられた複数の作業員のそれぞれが出勤した場合に、当該作業員の１日当たりの単価を出勤日の労務費として計上する。 Subsequently, the calculation unit 13 determines whether or not it is time to register the cost data of labor costs (step S5). The cost data of labor costs and the cost data of outsourcing costs are generated by substantially the same process. Therefore, in the following explanation, when there is no need to distinguish between labor costs and subcontracting costs, both labor costs and subcontracting costs are simply referred to as "labor costs." Registration of cost data of labor costs is performed, for example, at a predetermined cycle. A cycle is, for example, one day. When the calculation unit 13 determines that the timing for registering the cost data of labor costs has arrived (step S5: YES), the calculation unit 13 generates cost data of labor costs (step S6). In step S<b>6 , when each of the workers assigned to the construction (site) goes to work, the calculation unit 13 records the unit price per day of the worker as the labor cost for the working day.
　具体的に説明すると、まず、算出部１３は、日報ＤＢ１６から日報データを取得する。例えば、算出部１３は、日報ＤＢ１６から日報データを前回取得してから新たに日報ＤＢ１６に登録された日報データのみを取得する。そして、算出部１３は、日報データに含まれる項目のうちの原価データに含まれる項目（現場コード）を日報データから抽出し、抽出した項目を含む原価データを生成する。そして、算出部１３は、日報データに含まれる出勤日を原価データの計上年月日として設定する。さらに、算出部１３は、日報データに含まれる作業員ＩＤをキーとして、単価ＤＢ１７から当該作業員ＩＤを含む単価データを取得する。そして、算出部１３は、単価データに含まれる作業員氏名を原価データの明細項目として設定し、単価データに含まれる１日当たりの原価を原価データの単価として設定する。このとき、算出部１３は、原価データの数量として「１」を設定するとともに、原価データの単位として「日」を設定する。 Specifically, first, the calculation unit 13 acquires daily report data from the daily report DB 16 . For example, the calculation unit 13 acquires only the daily report data newly registered in the daily report DB 16 after the previous acquisition of the daily report data from the daily report DB 16 . Then, the calculation unit 13 extracts an item (site code) included in the cost data among the items included in the daily report data, and generates cost data including the extracted item. Then, the calculation unit 13 sets the working date included in the daily report data as the recording date of the cost data. Further, the calculation unit 13 uses the worker ID included in the daily report data as a key to acquire unit price data including the worker ID from the unit price DB 17 . Then, the calculation unit 13 sets the name of the worker included in the unit price data as the detail item of the cost data, and sets the cost per day included in the unit price data as the unit price of the cost data. At this time, the calculation unit 13 sets "1" as the quantity of the cost data and "day" as the unit of the cost data.
　算出部１３は、単価データに含まれる区分が「社員」である場合には、原価データの原価区分として「労務費」を設定するとともに、原価データの仕入先として自社の名称を設定する。さらに、算出部１３は、単価データに含まれる１日当たりの原価を労務費として算出し、労務費を原価データの金額として設定する。以上の処理により、例えば、図３に示される日報データから図１１に示される原価データが生成される。 When the category included in the unit price data is "employee", the calculation unit 13 sets "labor cost" as the cost category of the cost data and sets the name of the company as the supplier of the cost data. Further, the calculation unit 13 calculates the cost per day included in the unit price data as the labor cost, and sets the labor cost as the amount of the cost data. By the above processing, for example, the cost data shown in FIG. 11 is generated from the daily report data shown in FIG.
　算出部１３は、単価データに含まれる区分が「外注」である場合には、原価データの原価区分として「外注費」を設定するとともに、原価データの仕入先として下請業者の名称を設定する。さらに、算出部１３は、単価データに含まれる１日当たりの原価を外注費として算出し、外注費を原価データの金額として設定する。 When the category included in the unit price data is "subcontracting", the calculation unit 13 sets "outsourcing cost" as the cost category of the cost data, and sets the name of the subcontractor as the supplier of the cost data. . Further, the calculation unit 13 calculates the cost per day included in the unit price data as the outsourcing cost, and sets the outsourcing cost as the amount of the cost data.
　続いて、算出部１３は、原価データを１つのレコードとして工事台帳ＤＢ１９に登録（追加）する（ステップＳ７）。ステップＳ５において、労務費の原価データの登録タイミングが到来していないと判定された場合（ステップＳ５：ＮＯ）、ステップＳ６及びステップＳ７は実行されない。 Subsequently, the calculation unit 13 registers (adds) the cost data as one record in the construction ledger DB 19 (step S7). If it is determined in step S5 that the timing for registering labor cost cost data has not come (step S5: NO), steps S6 and S7 are not executed.
　続いて、作成部１４は、工事台帳作成システム１０が事務端末４から工事台帳作成指令を受信したか否かを判定する（ステップＳ８）。作成部１４は、工事台帳作成システム１０が工事台帳作成指令を受信したと判定すると（ステップＳ８：ＹＥＳ）、工事台帳を作成する（ステップＳ９）。ステップＳ９では、作成部１４は、工事台帳作成指令に含まれる現場コードをキーとして、工事台帳ＤＢ１９から当該現場コードを含む原価データを取得するとともに、現場ＤＢ１８を参照して、現場コードに対応付けられた現場名を取得する。そして、作成部１４は、取得したデータを元に所定のフォーマットで工事台帳を作成し、工事台帳を事務端末４に送信する。 Next, the creation unit 14 determines whether or not the construction ledger creation system 10 has received a construction ledger creation command from the office terminal 4 (step S8). When the creation unit 14 determines that the construction ledger creating system 10 has received the construction ledger creating command (step S8: YES), it creates a construction ledger (step S9). In step S9, the creating unit 14 uses the site code included in the construction ledger creation command as a key to acquire cost data including the site code from the construction ledger DB 19, and refers to the site DB 18 to associate the cost data with the site code. Gets the name of the site specified. Then, the creation unit 14 creates a construction ledger in a predetermined format based on the acquired data, and transmits the construction ledger to the office terminal 4 .
　なお、工事台帳ＤＢ１９には、ステップＳ４及びステップＳ７において登録された原価データの他、事務端末４において工事台帳アプリケーションを用いて登録された原価データが格納されている。 In addition to the cost data registered in steps S4 and S7, the construction ledger DB 19 stores cost data registered using the construction ledger application on the office terminal 4.
　ステップＳ８において、工事台帳作成システム１０が工事台帳作成指令を受信していないと判定されると（ステップＳ８：ＮＯ）、ステップＳ９は実行されない。 If it is determined in step S8 that the construction ledger creation system 10 has not received the construction ledger creation command (step S8: NO), step S9 is not executed.
　以上により、工事台帳作成方法の一連の処理が終了する。なお、ステップＳ１～Ｓ４の処理とステップＳ５～Ｓ７の処理とステップＳ８，Ｓ９の処理とは、どのような順で実行されてもよく、２以上の処理が並行して実行されてもよい。 With the above, the series of processes of the construction ledger creation method is completed. The processes of steps S1 to S4, the processes of steps S5 to S7, and the processes of steps S8 and S9 may be executed in any order, and two or more processes may be executed in parallel.
　以上説明した工事台帳作成システム１０及び工事台帳作成方法では、工事に割り当てられている作業員の日報データに基づいて、工事の労務費の原価データが生成され、労務費の原価データが工事台帳ＤＢ１９に登録される。したがって、労務費の原価データを登録する事務作業を省略することができるので、事務作業に要する時間を削減することが可能となる。 In the construction ledger creation system 10 and the construction ledger creation method described above, labor cost cost data for the construction is generated based on the daily report data of the worker assigned to the construction, and the labor cost cost data is stored in the construction ledger DB 19. registered with Therefore, it is possible to omit the clerical work of registering the cost data of labor costs, so that the time required for the clerical work can be reduced.
　工事台帳作成システム１０及び工事台帳作成方法では、受発注データから材料費の原価データが生成され、材料費の原価データが工事台帳ＤＢ１９に登録される。したがって、材料費の原価データを登録する事務作業を省略することができるので、事務作業に要する時間を更に削減することが可能となる。 In the construction ledger creation system 10 and the construction ledger creation method, cost data of material costs is generated from the order data, and the cost data of material costs is registered in the construction ledger DB 19 . Therefore, it is possible to omit the clerical work of registering the cost data of the material cost, so that it is possible to further reduce the time required for the clerical work.
　算出部１３は、複数の作業員のそれぞれが出勤日に出勤した場合に、当該作業員の１日当たりの単価を出勤日の労務費として計上する。この構成によれば、作業員の出勤日数に応じて労務費が算出される。したがって、実働時間を算出することなく労務費を算出することができるので、労務費の算出を簡易化することが可能となる。 When each of a plurality of workers comes to work on the working day, the calculation unit 13 records the daily unit price of the worker as the labor cost on the working day. According to this configuration, labor costs are calculated according to the number of working days of the worker. Therefore, the labor cost can be calculated without calculating the actual working hours, so the calculation of the labor cost can be simplified.
　工事台帳作成システム１０において、労務費、外注費、及び材料費の原価データが生成され、登録されるので、これらの原価データの不備及び登録漏れを回避することができる。 Since cost data for labor costs, outsourcing costs, and material costs are generated and registered in the construction ledger creation system 10, inadequacies and omissions in registration of these cost data can be avoided.
　なお、本開示に係る工事台帳作成システム及び工事台帳作成方法は上記実施形態に限定されない。 The construction ledger creation system and construction ledger creation method according to the present disclosure are not limited to the above embodiments.
　上記実施形態では、受発注ＤＢ３は、１つの仕入先（サプライヤ）の専用のデータベースであるが、複数の仕入先の共有のデータベースであってもよい。つまり、受発注ＤＢ３は、複数の仕入先の受発注データを格納してもよい。この場合、複数の仕入先から購入した材料の材料費の原価データが工事台帳ＤＢ１９に登録される。したがって、材料費の原価データを登録する事務作業を更に省略することができるので、事務作業に要する時間をより一層削減することが可能となる。 In the above embodiment, the order receiving/ordering DB 3 is a database dedicated to one supplier (supplier), but it may be a database shared by multiple suppliers. In other words, the order receiving/ordering DB 3 may store the order receiving/ordering data of a plurality of suppliers. In this case, cost data of materials purchased from a plurality of suppliers is registered in the construction ledger DB 19 . Therefore, it is possible to further omit the clerical work of registering the cost data of the material costs, so that the time required for the clerical work can be further reduced.
　上記実施形態では、単価データは、作業員の１日当たりの原価を含んでいるが、作業員の１時間当たりの原価（単価）を含んでもよい。この場合、算出部１３は、日報データから複数の作業員のそれぞれの実働時間を算出し、各作業員の１時間当たりの原価と実働時間とに基づいて、労務費を算出してもよい。具体的には、算出部１３は、日報データに含まれる始業時刻、終業時刻、及び休憩時間から実働時間を算出する。例えば、算出部１３は、終業時刻から始業時刻を減算し、減算結果から更に休憩時間を減算することによって実働時間（勤務時間）を算出する。そして、算出部１３は、実働時間と１時間当たりの原価とを乗算することによって、当該作業員の労務費を算出する。算出部１３は、日報データに含まれる残業時間に更に基づいて、労務費を算出してもよい。算出部１３は、労務費と同様にして外注費を算出してもよい。 In the above embodiment, the unit price data includes the cost per day of the worker, but it may also include the cost per hour (unit price) of the worker. In this case, the calculation unit 13 may calculate the actual working hours of each of the plurality of workers from the daily report data, and calculate labor costs based on the cost per hour and the actual working hours of each worker. Specifically, the calculation unit 13 calculates the actual working hours from the start time, end time, and break time included in the daily report data. For example, the calculation unit 13 calculates the actual working hours (working hours) by subtracting the starting time from the finishing time and further subtracting the break time from the result of the subtraction. Then, the calculation unit 13 calculates the labor cost of the worker by multiplying the actual working hours by the cost per hour. The calculation unit 13 may calculate the labor cost further based on the overtime hours included in the daily report data. The calculation unit 13 may calculate outsourcing costs in the same manner as labor costs.
　この構成によれば、作業員が実際に働いていた時間に応じて労務費が算出される。したがって、労務費の算出精度を向上させることが可能となる。 According to this configuration, labor costs are calculated according to the hours the worker actually worked. Therefore, it is possible to improve the calculation accuracy of labor costs.
　上記実施形態では、１人の作業員に対して１つの単価データが設定されている。つまり、各作業員の単価（１日当たりの原価）は固定である。各作業員の単価（１日当たりの原価）は変更されてもよい。 In the above embodiment, one unit price data is set for one worker. That is, the unit price (cost per day) of each worker is fixed. The unit price (cost per day) of each worker may be changed.
　例えば、１人の作業員に対して工事（現場）ごとに単価が予め設定されてもよい。つまり、単価データは、更に現場コードを含み、単価ＤＢ１７には、各作業員の単価データが工事ごとに格納されてもよい。この構成によれば、工事ごとに、作業員の単価を自由に設定することができる。したがって、工事の内容に応じた適切な単価を設定することができ、労務費（外注費）の適正化を図ることが可能となる。 For example, a unit price may be set in advance for each construction (site) for one worker. That is, the unit price data may further include a site code, and the unit price data for each worker may be stored in the unit price DB 17 for each construction. According to this configuration, the unit price of the worker can be freely set for each construction. Therefore, it is possible to set an appropriate unit price according to the content of the construction, and to optimize labor costs (outsourcing costs).
　作業員の単価は、工事の難易度に応じて変更されてもよい。例えば、各現場データは、更に難易度を含んでもよい。難易度は、現場コードによって識別される現場の工事の難易度を示す。算出部１３は、難易度に応じて予め設定された調整係数を用いて、作業員の単価を変更する。例えば、算出部１３は、単価データに含まれる作業員の単価（１日当たりの原価）と調整係数とを乗算することによって得られた値を、作業員の単価（１日当たりの原価）とする。この場合、調整係数は、例えば、難易度が高いほど大きい値に設定される。この構成によれば、簡単な工事では、作業員の単価が低く設定され、複雑な工事では、作業員の単価が高く設定され得る。したがって、工事の内容に応じた適切な単価を設定することができ、労務費（外注費）の適正化を図ることが可能となる。 The worker's unit price may be changed according to the difficulty of the construction. For example, each field data may further include a difficulty level. The difficulty level indicates the difficulty level of construction at the site identified by the site code. The calculation unit 13 changes the unit price of the worker using a preset adjustment coefficient according to the degree of difficulty. For example, the calculation unit 13 sets the value obtained by multiplying the unit price (cost per day) of the worker included in the unit price data by the adjustment coefficient as the unit price (cost per day) of the worker. In this case, the adjustment coefficient is set to a larger value, for example, as the difficulty level increases. According to this configuration, a worker's unit price can be set low for simple construction, and a worker's unit price can be set high for complicated construction. Therefore, it is possible to set an appropriate unit price according to the content of the construction, and to optimize labor costs (outsourcing costs).
　上記実施形態では、工事台帳作成システム１０によって、労務費、外注費、及び材料費の原価データが自動生成されているが、労務費及び外注費の原価データだけが自動生成されてもよい。この場合、工事台帳作成システム１０は、取得部１１及び生成部１２を含まなくてもよい。 In the above embodiment, the cost data of labor costs, outsourcing costs, and material costs are automatically generated by the construction ledger creation system 10, but only the cost data of labor costs and outsourcing costs may be automatically generated. In this case, the construction ledger creation system 10 may not include the acquisition unit 11 and the generation unit 12 .
　工事台帳作成システム１０は、日報ＤＢ１６、単価ＤＢ１７、及び現場ＤＢ１８の１つ以上を含まなくてもよい。この場合、日報ＤＢ１６、単価ＤＢ１７、及び現場ＤＢ１８は、工事台帳作成システム１０の外部に設けられてもよい。 The construction ledger creation system 10 does not have to include one or more of the daily report DB 16, the unit price DB 17, and the site DB 18. In this case, the daily report DB 16 , the unit price DB 17 , and the site DB 18 may be provided outside the construction ledger creation system 10 .
　２…作業員端末、３…受発注ＤＢ（第２記憶部）、４…事務端末、１０…工事台帳作成システム、１１…取得部、１２…生成部、１３…算出部、１４…作成部、１６…日報ＤＢ、１７…単価ＤＢ、１８…現場ＤＢ、１９…工事台帳ＤＢ（第１記憶部、記憶部）。 2 Worker terminal 3 Ordering DB (second storage unit) 4 Office terminal 10 Construction ledger creation system 11 Acquisition unit 12 Generation unit 13 Calculation unit 14 Creation unit 16... Daily report DB, 17... Unit price DB, 18... Site DB, 19... Construction ledger DB (first storage unit, storage unit).

Claims (7)

  1. 　工事ごとの原価データを格納する第１記憶部と、
    　１つの工事に割り当てられている複数の作業員によって入力された日報データに基づいて、前記工事の労務費の原価データを生成し、前記労務費の原価データを前記第１記憶部に登録する算出部と、
    　前記第１記憶部から前記工事の原価データを取得し、取得した前記原価データに基づいて工事台帳を作成する作成部と、
    を備える、工事台帳作成システム。     a first storage unit that stores cost data for each construction;
    Calculation for generating cost data of labor costs for said construction work based on daily report data input by a plurality of workers assigned to one construction work, and registering said cost data for said labor costs in said first storage unit Department and
    a creation unit that acquires the cost data of the construction work from the first storage unit and creates a construction ledger based on the acquired cost data;
    A construction ledger creation system.
  2. 　前記算出部は、前記複数の作業員のそれぞれが出勤日に出勤した場合に、当該作業員の１日当たりの単価を前記出勤日の前記労務費として計上する、請求項１に記載の工事台帳作成システム。 2. The construction ledger preparation according to claim 1, wherein, when each of the plurality of workers comes to work on the working day, the calculation unit records a unit price per day of the worker as the labor cost on the working day. system.
  3. 　前記日報データは、始業時刻、終業時刻、及び休憩時間を含み、
    　前記算出部は、前記日報データから前記複数の作業員のそれぞれの実働時間を算出し、各作業員の１時間当たりの単価と実働時間とに基づいて、前記労務費を算出する、請求項１に記載の工事台帳作成システム。     The daily report data includes start time, end time, and break time,
    2. The calculation unit calculates the actual working hours of each of the plurality of workers from the daily report data, and calculates the labor costs based on the unit price per hour and the actual working hours of each worker. Construction ledger creation system described in.
  4. 　前記単価は、工事ごとに予め設定される、請求項２又は請求項３に記載の工事台帳作成システム。 The construction ledger creation system according to claim 2 or claim 3, wherein the unit price is set in advance for each construction work.
  5. 　前記単価は、前記工事の難易度に応じて変更される、請求項２又は請求項３に記載の工事台帳作成システム。 The construction ledger creation system according to claim 2 or claim 3, wherein the unit price is changed according to the degree of difficulty of the construction.
  6. 　工事ごとに用いられる材料の受発注データを格納する第２記憶部から、前記工事に用いられる材料の受発注データを取得する取得部と、
    　前記受発注データから前記材料の材料費の原価データを生成し、前記材料費の原価データを前記第１記憶部に登録する生成部と、を更に備える、請求項１～請求項５のいずれか一項に記載の工事台帳作成システム。     an acquisition unit that acquires order data for materials used in construction from a second storage unit that stores order data for materials used in each construction;
    6. The method according to any one of claims 1 to 5, further comprising a generating unit that generates cost data of the material cost of the material from the order data and registers the cost data of the material cost in the first storage unit. The construction ledger creation system according to item 1.
  7. 　工事に割り当てられている複数の作業員によって入力された日報データに基づいて、前記工事の労務費の原価データを生成するステップと、
    　前記労務費の原価データを記憶部に登録するステップと、
    　前記記憶部から前記工事の原価データを取得し、取得した前記原価データに基づいて工事台帳を作成するステップと、
    を含む、工事台帳作成方法。     generating labor cost cost data for the construction work based on daily report data entered by a plurality of workers assigned to the construction work;
    a step of registering the labor cost cost data in a storage unit;
    a step of acquiring cost data of the construction from the storage unit and creating a construction ledger based on the acquired cost data;
    Construction ledger creation method including.
PCT/JP2022/042737 2021-11-26 2022-11-17 Construction ledger creation system and construction ledger creation method WO2023095714A1 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
JP2021192016A JP2023078750A (en) 2021-11-26 2021-11-26 Construction ledger creation system and construction ledger creation method
JP2021-192016 2021-11-26

Publications (1)

Publication Number Publication Date
WO2023095714A1 true WO2023095714A1 (en) 2023-06-01

Family

ID=86539674

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/JP2022/042737 WO2023095714A1 (en) 2021-11-26 2022-11-17 Construction ledger creation system and construction ledger creation method

Country Status (2)

Country Link
JP (1) JP2023078750A (en)
WO (1) WO2023095714A1 (en)

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH0793423A (en) * 1993-09-27 1995-04-07 Fujita Corp Information inputting method for daily operation report
JP2005216013A (en) * 2004-01-29 2005-08-11 Applicore Corp Integrated job management system
JP2009245140A (en) * 2008-03-31 2009-10-22 Hirotaka Kato Work ledger and fund management system based on business management system
JP2018081637A (en) * 2016-11-18 2018-05-24 和彦 大崎 Workplace management system

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP5361836B2 (en) * 2009-10-02 2013-12-04 株式会社経営サービスセンター Management information system

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH0793423A (en) * 1993-09-27 1995-04-07 Fujita Corp Information inputting method for daily operation report
JP2005216013A (en) * 2004-01-29 2005-08-11 Applicore Corp Integrated job management system
JP2009245140A (en) * 2008-03-31 2009-10-22 Hirotaka Kato Work ledger and fund management system based on business management system
JP2018081637A (en) * 2016-11-18 2018-05-24 和彦 大崎 Workplace management system

Also Published As

Publication number Publication date
JP2023078750A (en) 2023-06-07

Similar Documents

Publication Publication Date Title
US10713732B2 (en) System and method for implementing unified billing and unified rating operations
JP2002109325A (en) System and method for buying merchandise, storage medium recorded with program for performing merchandise buying method and server used for the same
US20130318009A1 (en) Property Sale Application and Tracking System
US11062293B2 (en) Method and system for negotiating, generating, documenting, and fulfilling vendor financing opportunities
WO2023095714A1 (en) Construction ledger creation system and construction ledger creation method
JP2007279811A (en) Transaction system, transaction information providing method, and transaction information providing program in online trading
JP7245707B2 (en) SOLUTION PROPOSAL SUPPORT SYSTEM AND SOLUTION PROPOSAL SUPPORT METHOD
US11295395B1 (en) Community influenced approval cycle times in a software-as-a-service system
KR101046602B1 (en) System for managing distribution process among entrepreneurs
JP2006301874A (en) Sales price simulation system and sales price simulation program
JP5971883B1 (en) POS system for nominated entertainment restaurants
JP5665157B1 (en) Credit screening system
JP2002298227A (en) Market research system and market research method
JP2020102005A (en) Business operation management system
KR20190084739A (en) Apparatus and method for synthetically managing resource for cost accounting
JP2000123075A (en) Construction ledger preparation system
US20070244803A1 (en) Auction device and auction program
JP7036459B2 (en) Purchase amount burden determination program
TWI679591B (en) Commercial collection system
JP2012128602A (en) Sales management device, sales management system, control method and program
JP2024060890A (en) Trade Management System
KR20050114598A (en) Real estate transaction information management method, system therefor, main server therefor, group server therefor and user terminal therefor
JP2003115023A (en) Settlement agency system and its method
Llabres Auto Parts Inventory Management System
JP2021152818A (en) Automatic commission accounting device, automatic commission accounting method, and automatic commission accounting program

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 22898498

Country of ref document: EP

Kind code of ref document: A1