JP2019046168A - Construction progress basis accounting system, construction progress basis accounting method and construction progress basis accounting program - Google Patents

Construction progress basis accounting system, construction progress basis accounting method and construction progress basis accounting program Download PDF

Info

Publication number
JP2019046168A
JP2019046168A JP2017168755A JP2017168755A JP2019046168A JP 2019046168 A JP2019046168 A JP 2019046168A JP 2017168755 A JP2017168755 A JP 2017168755A JP 2017168755 A JP2017168755 A JP 2017168755A JP 2019046168 A JP2019046168 A JP 2019046168A
Authority
JP
Japan
Prior art keywords
indirect
cost
construction progress
sales
ratio
Prior art date
Legal status (The legal status 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 status listed.)
Pending
Application number
JP2017168755A
Other languages
Japanese (ja)
Inventor
直記 横尾
Naoki Yokoo
直記 横尾
剛光 上野
Takemitsu Ueno
剛光 上野
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Obic Co Ltd
Original Assignee
Obic Co Ltd
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 Obic Co Ltd filed Critical Obic Co Ltd
Priority to JP2017168755A priority Critical patent/JP2019046168A/en
Publication of JP2019046168A publication Critical patent/JP2019046168A/en
Pending legal-status Critical Current

Links

Images

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

To reduce errors and loads caused by manual input and enable accurate calculation of operating income by calculating an indirect cost and an indirect labor cost included in a contract amount based on a ratio according to a work content at time of creating a budget to multiply a cost progress rate by them to calculate cost prices of completion and incompletion.SOLUTION: A construction progress standard accounting device 100 has a control unit 102 and creates a complete transfer journal of an indirect cost in a construction progress basis. The control unit 102 includes: an indirect ratio creation unit 102a that creates an indirect ratio table indicating a ratio of indirect cost to a sales amount based on past actual data for each construction content; an indirect cost/indirect labor cost creation unit 102b that creates a budget for an indirect cost and an indirect labor cost included in a contract amount based on an indirect ratio according to the work content of the indirect ratio table at time of execution budget registration; and a progress basis sales accounting unit 102c that calculates and books the cost price of the completion using the sales amount, the contract amount, the indirect cost or the indirect labor cost at time of the sales under construction progress basis.SELECTED DRAWING: Figure 1

Description

本発明は、工事進行基準計上装置、工事進行基準計上方法および工事進行基準計上プログラムに関する。   The present invention relates to a construction progress standard accruing device, a construction progress standard accruing method, and a construction progress standard accruing program.

従来、工事契約に関する収益認識としては、工事の完成引渡完了を待って売上計上する工事完成基準と、工事の進行度合いによって収益を計上する工事進行基準とがある。特に、長期的な工事プロジェクトでは、工事進行基準を原則適用することにより不採算案件を迅速に発見して、企業会計の透明性を確保している。   Conventionally, there are two types of revenue recognition for construction contracts: a construction completion standard that records sales after completion of delivery and completion of construction, and a construction progress standard that records revenue according to the degree of construction progress. In particular, in long-term construction projects, by applying the construction progress standard in principle, unprofitable projects are quickly identified to ensure the transparency of corporate accounting.

例えば、特許文献1では、工事進行基準を用いて実務会計に適用可能な利益図を作成することにより、固定費としての製造間接費を配賦する手法を用いている(0006、0014、0063、0064段落参照)。また、従来は、外部で進捗率に応じた完成振替額を手計算することで完成振替仕訳を手入力していたが、間接費を進捗率に応じて計上することなく、契約時にグロスで見積もった金額を登録していた。   For example, in Patent Document 1, a method of allocating manufacturing indirect costs as fixed costs is used by creating a profit chart applicable to practical accounting using the construction progress standard (0006, 0014, 0063, See paragraph 0064). Also, in the past, manual completion journal entries were manually input by manually calculating the finalized transfer amount according to the progress rate, but indirect costs are not estimated according to the progress rate, but are estimated at the time of contract. The amount of money was registered.

特許第5722307号公報Patent No. 5722307 gazette

しかしながら、このような特許文献1にあっては、1会社当たり、または、1事業部門当たりの標準原価計算限界利益図を用いて、製造間接費等の配賦額を計算しているが、工事内容や工事時期によって契約金額に占める間接費の比率が異なるため、正確に採算性を確認することは困難であった。   However, in such Patent Document 1, the allocation amount such as manufacturing overhead is calculated using a standard costing marginal profit chart per company or per business division Since the ratio of overhead expenses to the contract amount differs depending on the content and construction time, it was difficult to accurately confirm profitability.

また、上記したように、間接費を進捗率に応じて計上することなく、契約時にグロスで見積もった金額を登録して完成振替を行うと、初回の進行基準売上計上時に全額完成振替されるため、正確に採算性を確認することは困難であった。   In addition, as mentioned above, if you register the amount estimated at the time of the contract and complete the transfer without recording the indirect cost according to the progress rate, the complete transfer will be made at the first progress-based sales accrual. It was difficult to confirm the profitability accurately.

本発明は、上記課題に鑑みてなされたものであって、実行予算作成時に工事内容に応じた比率に基づいて請負金額に含まれる間接経費と間接人件費を求め、原価進捗率を掛けて完成分と未成分の原価を算出することにより、手入力によるミスや負荷を軽減し、正確な営業利益を算出することができる工事進行基準計上装置、工事進行基準計上方法および工事進行基準計上プログラムを提供することを目的とする。   This invention is made in view of the said subject, Comprising: Based on the ratio according to the contents of construction at the time of execution budget preparation, the overhead expenses and the indirect labor cost included in the contract amount are calculated | required, and it is completed by multiplying the cost progress rate. Calculation of construction progress standard accounting equipment, construction progress standard accounting method, and construction progress standard accounting program that can reduce errors and loads due to manual input and calculate accurate operating profit by calculating the cost of minutes and uncomponents Intended to be provided.

上述した課題を解決し、目的を達成するために、本発明に係る工事進行基準計上装置は、制御部を備え、工事進行基準における間接費の完成振替仕訳を作成する工事進行基準計上装置であって、前記制御部は、工事内容毎の過去の実績データに基づいて売上高に占める間接費の割合を示す間接比率テーブルを作成する間接比率作成手段と、実行予算登録時に、前記間接比率テーブルの工事内容に応じた間接比率に基づいて請負金額に含まれる間接経費と間接人件費の予算を作成する予算作成手段と、工事進行基準における売上時に、前記売上高と前記請負金額と前記間接経費あるいは前記間接人件費とを用いて完成分の原価を計算して計上する進行基準売上計上手段と、を備えていること、を特徴とする。   In order to solve the problems described above and to achieve the object, the construction progress standard accounting device according to the present invention is a construction progress standard accounting device that includes a control unit and creates a complete transfer journal of indirect costs in the construction progression standard. The control unit generates an indirect ratio table indicating a ratio of indirect cost to sales based on past actual data for each construction content, and an indirect ratio table of the indirect ratio table at the time of execution budget registration. Budget creation means for creating a budget for indirect expenses and indirect labor expenses included in the contract amount based on the indirect ratio according to the work content, and the sales, the contract amount, the indirect expenses or The method is characterized by comprising: a progress-based sales accruing means for calculating and recording the cost of a completed part using the above-mentioned indirect labor cost.

また、本発明に係る工事進行基準計上装置は、前記進行基準売上計上手段は、完成分と未完成分の原価をそれぞれ別表に作成することを特徴とする。   Further, the construction progress standard accounting device according to the present invention is characterized in that the progress standard sales accounting means prepares the cost of the completed portion and the incomplete portion in separate tables.

また、本発明に係る工事進行基準計上装置は、前記進行基準売上計上手段は、工事進行基準における完成分の間接費の原価を次式(1)により求めることを特徴とする。
進行基準売上高÷請負総額×間接費(間接経費・間接人件費)……(1)
Further, the construction progress standard accounting device according to the present invention is characterized in that the progress basis sales accounting means obtains the cost of the overhead cost for the completion on the construction progression standard by the following equation (1).
Progress-based sales ÷ total contract × overhead expenses (overhead expenses · indirect labor costs) ... (1)

また、本発明に係る工事進行基準計上方法は、制御部を備え、工事進行基準における間接費の完成振替仕訳を作成する工事進行基準計上装置で実行される工事進行基準計上方法であって、前記制御部で実行される、工事内容毎の過去の実績データに基づいて売上高に占める間接費の割合を示す間接比率テーブルを作成する間接比率作成ステップと、実行予算登録時に、前記間接比率テーブルの工事内容に応じた間接比率に基づいて請負金額に含まれる間接経費と間接人件費の予算を作成する予算作成ステップと、工事進行基準における売上時に、前記売上高と前記請負金額と前記間接経費あるいは前記間接人件費とを用いて完成分の原価を計算して計上する進行基準売上計上ステップと、を含むこと、を特徴とする。   The construction progress standard accounting method according to the present invention is a construction progress standard accounting method executed by a construction progress standard accounting device that includes a control unit and creates a complete transfer journal of indirect costs in the construction progress standard, An indirect ratio creation step of creating an indirect ratio table indicating the ratio of indirect expenses to sales based on past actual data for each construction content, which is executed by the control unit, and when the execution budget is registered, The budget creation step of creating a budget for indirect expenses and indirect labor expenses included in the contract amount based on the indirect ratio according to the work content, the sales, the contract amount, the indirect expenses or And (c) calculating and recording the cost of the completed part using the above-mentioned indirect labor cost, and including the step of recording on a basis of sales.

また、本発明に係る工事進行基準計上プログラムは、制御部を備え、工事進行基準における間接費の完成振替仕訳を作成する工事進行基準計上装置で実行させるための工事進行基準計上プログラムであって、前記制御部で実行させるための、工事内容毎の過去の実績データに基づいて売上高に占める間接費の割合を示す間接比率テーブルを作成する間接比率作成ステップと、実行予算登録時に、前記間接比率テーブルの工事内容に応じた間接比率に基づいて請負金額に含まれる間接経費と間接人件費の予算を作成する予算作成ステップと、工事進行基準における売上時に、前記売上高と前記請負金額と前記間接経費あるいは前記間接人件費とを用いて完成分の原価を計算して計上する進行基準売上計上ステップと、を含むこと、を特徴とする。   The construction progress standard accrual program according to the present invention is a construction progress basis accrual program to be executed by a construction progress standard accreditation device that includes a control unit and prepares a complete transfer journal of indirect costs in the construction progress standard, An indirect ratio creation step of creating an indirect ratio table indicating a ratio of indirect cost to sales based on past actual data for each construction content to be executed by the control unit; and the indirect ratio at the time of execution budget registration The budget creation step of creating a budget for indirect expenses and indirect labor expenses included in the contract amount based on the indirect ratio according to the work content of the table, and the sales, the contract amount and the indirect amount at the time of sales according to the construction progress standard And (c) including a progress-based sales accruing step of calculating and recording the cost of the completed part using the expenses or the indirect labor cost.

本発明によれば、実行予算作成時に工事内容に応じた比率に基づいて請負金額に含まれる間接経費と間接人件費を求め、原価進捗率を掛けて完成分と未成分の原価を算出することにより、手入力によるミスや負荷を軽減し、正確な営業利益を算出することができるという効果を奏する。   According to the present invention, the overhead cost and the indirect labor cost included in the contract amount are obtained based on the ratio according to the construction content at the time of preparation of the execution budget, and the cost progress rate is multiplied to calculate the completed and uncomponentd cost. Thus, it is possible to reduce errors and loads caused by manual input and to calculate accurate operating profit.

図1は、本実施形態に係る工事進行基準計上装置の構成の一例を示すブロック図である。FIG. 1 is a block diagram showing an example of the configuration of a construction progress standard accounting device according to the present embodiment. 図2は、受注区分別間接比率テーブルの一例を説明する図である。FIG. 2 is a diagram for explaining an example of the order ratio-classified indirect ratio table. 図3は、原価進捗に応じたプロジェクトの完成分と未成分の算出結果の一例を示す図である。FIG. 3 is a diagram showing an example of the calculation of the completion of the project and the non-component according to the cost progress. 図4は、本実施形態に係る工事進行基準計上装置の処理の流れを示すフローチャートである。FIG. 4 is a flow chart showing a process flow of the construction progress standard accounting device according to the present embodiment. 図5は、未成分のプロジェクト一覧表の一例を示す図である。FIG. 5 is a diagram showing an example of a non-component project list. 図6は、完成分のプロジェクト一覧表の一例を示す図である。FIG. 6 is a diagram showing an example of a completed project list.

本発明の実施形態を図面に基づいて詳細に説明する。なお、本発明は本実施形態により限定されるものではない。   Embodiments of the present invention will be described in detail based on the drawings. The present invention is not limited by this embodiment.

[1.概要]
従来の工事進行基準における間接費の完成振替仕訳の作成は、外部で進捗率に応じて完成振替額を手計算することにより完成振替仕訳を手入力していた。その場合の間接費は、進捗率に応じて計上していくのではなく、契約時にグロスで見積もって、その金額を登録するため、普通に完成振替すると、初回の進行基準売上計上時に全額完成振替されてしまい、進捗率に応じた間接費の完成振替仕訳を作成することができなかった。このように、従来の完成振替仕訳の作成は、手計算や手入力による負荷が掛かり、ミスが発生し易く、進捗率に応じて正確に営業利益を算出することが困難であった。
[1. Overview]
In preparation of the completion transfer journal of indirect cost in the conventional construction progress standard, the completion transfer journal was manually input by manually calculating the completion transfer amount according to the progress rate outside. In this case, the indirect costs are not recorded according to the progress rate, but the gross amount at the time of the contract is estimated, and the amount is registered. It was not possible to create a complete transfer journal of overhead according to the progress rate. As described above, conventional creation of a complete transfer journal entry is burdened by manual calculation and manual input, errors are likely to occur, and it is difficult to accurately calculate the operating profit according to the progress rate.

そこで、本実施形態では、工事内容毎に前年度の実績に応じて、受注区分別間接比率テーブルを自動作成する。そして、実行予算登録時は、請負金額登録時に受注区分別間接比率テーブルを参照し、製造間接経費と間接製造人件費の予算を自動作成する。また、工事進行基準での売上時には、次式(1)により、完成分の間接費の原価を計算する。
完成分の間接費の原価=進行基準売上高÷請負総額×間接費(間接経費・間接人件費)…(1)
算出した完成分の原価から未成分の原価を求め、プロジェクト一覧表として、完成分と未成分をそれぞれ別表で作表する。これにより、手計算や手入力によるミスや負荷を軽減しつつ、より正確に営業利益を算出できるようになった。
So, in this embodiment, according to the performance of last year for every construction content, the indirect ratio table according to order acceptance division is created automatically. And at the time of execution budget registration, a budget for manufacturing overhead expenses and indirect manufacturing personnel expenses is automatically created with reference to the indirect ratio table for each order category at the time of contract value registration. In addition, at the time of sales on a construction progress basis, the cost of overhead for the completed part is calculated by the following equation (1).
Cost of completed overhead costs = Progression-based sales ÷ Total contract cost × Indirect costs (overhead costs / indirect labor costs) ... (1)
From the calculated costs of completed components, the cost of the non-components is obtained, and as a project list, the completed components and the non-components are separately tabulated. As a result, it has become possible to calculate operating income more accurately while reducing errors and loads due to manual calculation and manual input.

[2.構成]
本実施形態に係る工事進行基準計上装置の構成の一例について、図1〜図3を参照して説明する。図1は、本実施形態に係る工事進行基準計上装置の構成の一例を示すブロック図である。図2は、受注区分別間接比率テーブルの一例を説明する図である。図3は、原価進捗に応じたプロジェクトの完成分と未成分の算出結果の一例を示す図である。
[2. Constitution]
An example of the configuration of the construction progress standard accounting device according to the present embodiment will be described with reference to FIGS. 1 to 3. FIG. 1 is a block diagram showing an example of the configuration of a construction progress standard accounting device according to the present embodiment. FIG. 2 is a diagram for explaining an example of the order ratio-classified indirect ratio table. FIG. 3 is a diagram showing an example of the calculation of the completion of the project and the non-component according to the cost progress.

工事進行基準計上装置100は、市販のデスクトップ型パーソナルコンピュータである。なお、工事進行基準計上装置100は、デスクトップ型パーソナルコンピュータのような据置型情報処理装置に限らず、市販されているノート型パーソナルコンピュータ、PDA(Personal Digital Assistants)、スマートフォン、タブレット型パーソナルコンピュータなどの携帯型情報処理装置であってもよい。   The construction progress standard accounting device 100 is a commercially available desktop personal computer. The construction progress standard accounting device 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a commercially available notebook personal computer, PDA (Personal Digital Assistants), a smartphone, a tablet personal computer, etc. It may be a portable information processing apparatus.

工事進行基準計上装置100は、制御部102と通信インターフェース部104と記憶部106と入出力インターフェース部108と、を備えている。工事進行基準計上装置100が備えている各部は、任意の通信路を介して通信可能に接続されている。   The construction progress standard accounting device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the construction progress standard accounting device 100 are communicably connected via any communication path.

通信インターフェース部104は、ルータ等の通信装置および専用線等の有線又は無線の通信回線を介して、工事進行基準計上装置100をネットワーク300に通信可能に接続する。通信インターフェース部104は、他の装置と通信回線を介してデータを通信する機能を有する。ここで、ネットワーク300は、工事進行基準計上装置100とサーバ200とを相互に通信可能に接続する機能を有し、例えばインターネットやLAN(Local Area Network)等である。   The communication interface unit 104 communicably connects the construction progress reference accounting device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of communicably connecting the construction progress standard accounting device 100 and the server 200, and is, for example, the Internet, a local area network (LAN), or the like.

記憶部106には、各種のデータベース、テーブル、およびファイルなどが格納される。記憶部106には、OS(Operating System)と協働してCPU(Central Processing Unit)に命令を与えて各種処理を行うためのコンピュータプログラムが記録される。記憶部106として、例えば、RAM(Random Access Memory)・ROM(Read Only Memory)等のメモリ装置、ハードディスクのような固定ディスク装置、フレキシブルディスク、および光ディスク等を用いることができる。ここで、記憶部106は、受注区分別データ106a、受注区分別間接比率テーブル106b等を備えている。   The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for giving instructions to a central processing unit (CPU) in cooperation with an operating system (OS) to perform various processes. As the storage unit 106, for example, a memory device such as a random access memory (RAM) or a read only memory (ROM), a fixed disk device such as a hard disk, a flexible disk, an optical disk or the like can be used. Here, the storage unit 106 is provided with data 106a classified by order category, an indirect ratio table 106b classified by order category, and the like.

受注区分別データ106aは、過去の工事内容に応じた受注区分別のデータを記憶するデータベースである。工事内容別の受注区分例としては、図2に示すように、官庁土木工事、官庁配水管移設工事(単契)、官庁下水道設備工事(単契)、官庁上下水道復旧工事、官庁建設工事、民間土木工事、民間建設工事、民間土壌汚染、民間販売設計、民間ガス復旧工事、民間鋼管工事などがあり、過去の受注区分毎の実績データを記憶している。本実施形態では、受注区分別データ106aに記憶されている前年度の実績データに基づいて、受注区分別の間接製造人件費や製造間接経費などの間接比率を算出する。   The order-sorted data 106a is a database for storing data classified by order-sorted according to the contents of construction in the past. As an example of the order category according to the contents of construction, as shown in Figure 2, the civil engineering work, the government distribution pipe transfer construction work (single contract), the government sewerage construction work (single contract), the government water and sewage restoration construction, the government construction work, There are civil engineering work, private construction work, private soil contamination, private sales design, private gas restoration work, private steel pipe construction, etc., and the actual data for each order acceptance category in the past is stored. In the present embodiment, based on the actual data of the previous year stored in the order-sorted data 106a, an indirect ratio such as indirect manufacturing personnel cost and manufacturing overhead cost by order-sorted is calculated.

受注区分別間接比率テーブル106bは、受注区分別の過去の実績データに基づいて売上高に占める間接費の割合を示す間接比率の算出結果を記憶するテーブルである。本実施形態では、図2に示すように、受注区分別の前年度の実績データを集計し、請負金額に対して間接製造人件費や製造間接経費がどの位の比率(%)を占めていたかを算出し、テーブルデータとして記憶している。本実施形態では、間接比率の算出に当たって、直近である前年度の実績データに基づいて算出しているが、必ずしもこれに限定されず、過去の一定期間の実績データを用いて算出しても良い。   The order ratio-based indirect ratio table 106b is a table for storing the calculation result of the indirect ratio indicating the ratio of the indirect cost to the sales based on the past actual data by the order-related condition. In the present embodiment, as shown in FIG. 2, the actual data of the previous year by order category is totaled, and what proportion (%) of indirect manufacturing labor cost and manufacturing overhead cost accounted for the contract value Is calculated and stored as table data. In this embodiment, calculation of the indirect ratio is performed based on the latest actual data of the previous year, but the present invention is not necessarily limited to this, and may be calculated using actual data of a past fixed period .

入出力インターフェース部108には、入力装置112および出力装置114が接続されている。出力装置114には、モニタ(家庭用テレビを含む)の他、スピーカやプリンタを用いることができる。入力装置112には、キーボード、マウス、およびマイクの他、マウスと協働してポインティングデバイス機能を実現するモニタを用いることができる。なお、以下では、出力装置114をモニタ114とし、入力装置112をキーボード112またはマウス112として記載する場合がある。   An input device 112 and an output device 114 are connected to the input / output interface unit 108. For the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. The input device 112 can be a keyboard, a mouse, a microphone, and a monitor that cooperates with the mouse to realize a pointing device function. Hereinafter, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

制御部102は、工事進行基準計上装置100を統括的に制御するCPU等である。制御部102は、OS等の制御プログラム・各種の処理手順等を規定したプログラム・所要データなどを格納するための内部メモリを有し、格納されているこれらのプログラムに基づいて種々の情報処理を実行する。ここで、制御部102は、機能概念的に、間接比率作成手段としての間接比率作成部102a、予算作成手段としての間接経費・間接人件費作成部102b、進行基準売上計上手段としての進行基準売上計上部102c等を備えている。   The control unit 102 is a CPU or the like that controls the construction progress standard accounting device 100 in an integrated manner. The control unit 102 has an internal memory for storing control programs such as the OS, programs defining various processing procedures, required data, etc., and performs various information processing based on the stored programs. Run. Here, the control unit 102 functionally conceptually includes an indirect ratio creation unit 102a as an indirect ratio creation unit, an indirect expense / indirect labor cost creation unit 102b as a budget creation unit, and a progress-based sales as a progress-based sales accounting unit The accounting unit 102c is provided.

間接比率作成部102aは、過去の工事内容に応じた受注区分別データ106aの中から前年度の実績データに基づいて売上高に占める間接経費や間接人件費の割合を示す間接比率を算出して作成する。このように作成した前年度実績の間接比率は、具体的には受注区分別の間接人件費比率(%)と間接経費比率(%)として、図2に示す受注区分別間接比率テーブル106bを作成する。本実施形態では、前年度の実績データに基づいて間接比率を算出しているが、過去の一定期間の実績データを用いて算出しても良い。例えば、通常であれば、直近のデータを用いることが今年度の実行予算を作成する上で望ましいが、経済状況が類似している過去の一定期間の実績データを用いた方が良い場合もあるため、過去の何れの期間のデータを用いるかは適宜選択可能である。   The indirect ratio creation unit 102a calculates an indirect ratio indicating the ratio of indirect expenses and indirect labor expenses to sales based on actual data of the previous year from data 106a by order category according to the contents of construction in the past create. The indirect ratio of the results of the previous fiscal year created in this way is specifically created as an indirect ratio table 106b by order category shown in FIG. 2 as an indirect labor cost ratio (%) by order category and an indirect expense ratio (%). Do. In the present embodiment, the indirect ratio is calculated based on the actual data of the previous year, but may be calculated using actual data of a past fixed period. For example, although it is usually desirable to use the latest data to create the budget for the current fiscal year, it may be better to use historical data for a certain period in the past when economic conditions are similar Therefore, it is possible to select as appropriate which of past periods of data is used.

間接経費・間接人件費作成部102bは、実行予算作成時に該当する工事内容(受注区分)に応じた受注区分別間接比率テーブル106bの間接人件費比率(%)と間接経費比率(%)とを用い、請負金額に対する間接製造人件費と製造間接経費とを自動作成する。例えば、受注区分が民間土木工事で、請負金額が¥4,800,000の場合は、図2の受注区分別間接比率テーブル106bの間接人件費比率(%)=2.3、間接経費比率(%)=0.9であるので、下記式により間接製造人件費と製造間接経費とを求める。
間接製造人件費=請負金額×間接人件費比率÷100=4,800,000×2.3÷100=110,400
製造間接経費=請負金額×間接経費比率÷100=4,800,000×0.9÷100=43,200
The indirect expense / indirect labor cost preparation unit 102b calculates the indirect labor cost ratio (%) and the overhead cost ratio (%) of the indirect ratio table 106b by order category according to the construction content (order acceptance category) that corresponds to the execution budget creation time Automatically create indirect manufacturing personnel expenses and manufacturing overhead expenses for the contract value. For example, when the order category is private civil engineering and the contract price is ¥ 4,800,000, the indirect labor cost ratio (%) = 2.3, the indirect expense ratio (indirect ratio table 106b by order category in FIG. 2) = 2.3 Since%) = 0.9, the indirect manufacturing labor cost and the manufacturing overhead cost are calculated by the following formula.
Indirect manufacturing cost = Contract price × Indirect labor cost ratio, 100 = 4,800,000 × 2.3 ÷ 100 = 110,400
Manufacturing overhead cost = contract price × overhead cost ratio ÷ 100 = 4,800,000 × 0.9 ÷ 100 = 43,200

進行基準売上計上部102cは、原価進捗に応じた売上計上を行う。具体的には、原価進捗率を求め、この原価進捗率を上記算出した間接製造人件費や製造間接経費にそれぞれ掛けることにより、完成分の間接費の原価を計上することができる。   The progress-based sales recording unit 102c records sales according to the cost progress. Specifically, the cost progress rate can be calculated, and the cost progress rate can be multiplied by the indirect manufacturing personnel cost and the manufacturing overhead cost calculated above to calculate the cost of the completed overhead cost.

例えば、下記工事を請け負った場合を例にあげて図3を説明する。
<実行予算作成>
プロジェクト番号 PK00000010
プロジェクト名 ○○病院地下通路撤去に伴う下水道入替工事
受注区分 民間 土木工事
請負金額 ¥4,800,000

(実行予算)
外注費 ¥3,870,000
直接人件費 ¥484,000
計 ¥4,354,000

間接製造人件費 ¥110,400
製造間接経費 ¥43,200

(原価進捗)
外注費 ¥1,277,640
直接人件費 ¥66,000
現場経費 ¥7,560
計 ¥1,351,200
For example, FIG. 3 will be described with reference to the case where the following construction is contracted.
<Execution budget creation>
Project number PK00000010
Project name ○ ○ Sewer replacement work with removal of the underground passage in the hospital
Order classification Private civil engineering work
Contract price ¥ 4,800,000

(Working budget)
Outsourcing expenses ¥ 3,870,000
Direct labor cost ¥ 484,000
Total ¥ 4,354,000

Indirect manufacturing cost: ¥ 110,400
Manufacturing overhead costs ¥ 43,200

(Cost progress)
Outsourcing expenses ¥ 1,277,640
Direct labor cost ¥ 66,000
Site expenses ¥ 7,560
Total ¥ 1,351,200

<進行基準売上>
原価進捗に応じた売上計上を行う場合は、上記値を用いて次式により原価進捗率を求める。
原価進捗率=(間接費を除いた発生原価)÷(間接費を除いた実行予算)×100
=(原価進捗の外注費+直接人件費+現場経費)÷(実行予算の外注費+直接人件費)×100
=(1,277,640+66,000+7,560)÷(3,870,000+484,000)×100
=1,351,200÷4,354,000×100
=31.0335323840147
≒31.03(%)
<Progress on sales>
When sales are recorded according to the cost progress, the cost progress rate is calculated by the following equation using the above values.
Cost progress rate = (Accurred cost excluding overhead) / (Running budget excluding overhead) × 100
= (Cost progress outsourcing cost + direct labor cost + site cost) ÷ (execution budget outsourcing cost + direct labor cost) × 100
= (1, 277, 640 + 66,000 + 7, 560) / (3, 870, 000 + 484,000) x 100
= 1,351,200 ÷ 4,354,000 × 100
= 3.1035323840147
3 31.03 (%)

また、原価進捗に応じた計上可能額(売上可能額)も次式より求めることができる。
計上可能額=請負金額×原価進捗率÷100
=4,800,000×31.0335323840147÷100
≒1,489610
In addition, the accommodable amount (sales possible amount) according to the cost progress can be obtained from the following equation.
Recordable amount = contract amount × cost progress rate ÷ 100
= 4,800,000 × 3 1.0 33 532 384 ÷ 100
1,4 1,489610

そして、プロジェクトの進捗率に応じた完成分と未成分の間接製造人件費と製造間接経費の原価を計算すると図3のようになる。
間接製造人件費の完成分の原価=間接製造人件費×原価進捗率÷100
=110,400×31.0335323840147÷100
≒34,261
製造間接経費の完成分の原価=製造間接経費×原価進捗率÷100
=43,200×31.0335323840147÷100
≒13,406
Then, the costs of the completed and unconsolidated indirect manufacturing labor costs and manufacturing overhead costs according to the progress rate of the project are calculated as shown in FIG.
Cost of completed indirect manufacturing cost = indirect manufacturing cost × cost progress rate ÷ 100
= 110, 400 x 3 1.0 33 532 384 ÷ 100
34 34, 261
Finished cost of production overhead = production overhead × cost progress rate ÷ 100
= 43, 200 x 3 1.0 33 532 384 ÷ 100
13 13,406

また、プロジェクトの進捗率に応じた未成分の間接製造人件費と製造間接経費の原価は、完成分の原価を引いた残りとなる。
間接製造人件費の未成分の原価=間接製造人件費−間接製造人件費の完成分の原価
=110,400−34,261
=76,139
製造間接経費の未成分の原価=製造間接経費−製造間接経費の完成分の原価
=43,200−13,406
=29,794
In addition, the costs of unconsolidated indirect manufacturing labor costs and manufacturing overhead costs according to the percentage of progress of the project will be the remainder after subtracting the cost of completed parts.
Raw cost of indirect manufacturing cost = indirect manufacturing cost-cost of completion of indirect manufacturing cost
= 110, 400-34, 261
= 76, 139
Unconsumed cost of manufacturing overhead cost = manufacturing overhead cost-cost of completion of manufacturing overhead cost
= 43, 200-13, 406
= 29, 794

[3.具体例]
本実施形態の具体例について、図4〜図6を参照して、本実施形態に係る工事進行基準計上装置100の処理の一例について説明する。図4は、本実施形態に係る工事進行基準計上装置の処理の流れを示すフローチャートである。図5は、未成分のプロジェクト一覧表の一例を示す図である。図6は、完成分のプロジェクト一覧表の一例を示す図である。
[3. Concrete example]
About a specific example of this embodiment, an example of processing of construction progress standard accounting device 100 concerning this embodiment is explained with reference to Drawings 4-6. FIG. 4 is a flow chart showing a process flow of the construction progress standard accounting device according to the present embodiment. FIG. 5 is a diagram showing an example of a non-component project list. FIG. 6 is a diagram showing an example of a completed project list.

本実施形態に係る工事進行基準計上装置100では、間接比率作成部102aが過去の工事内容に応じた受注区分別のデータを記憶している受注区分別データ106aの中から前年度の実績データに基づいて売上高に占める間接経費や間接人件費の割合を示す間接比率を作成する(図4のステップSA−1)。作成した間接経費や間接人件費は、図2に示すように、受注区分に対応した間接比率(%)を格納して受注区分別間接比率テーブル106bを作成する。   In the construction progress standard accounting device 100 according to the present embodiment, the actual data of the previous year is selected from the data 106a classified by order category in which the indirect ratio creation unit 102a stores data classified by order category according to the content of construction in the past. Based on the above, an indirect ratio indicating the ratio of indirect expenses and indirect labor expenses to sales is created (step SA-1 in FIG. 4). As the overhead expenses and the indirect labor expenses thus created, as shown in FIG. 2, the indirect ratio (%) corresponding to the order category is stored to create the indirect ratio table 106b by order category.

そして、間接経費・間接人件費作成部102bは、実行予算作成時に工事内容(受注区分)に応じた受注区分別間接比率テーブル106bの間接経費比率(%)と間接人件費比率(%)とを用い、請負金額から間接経費と間接人件費とを作成する(ステップSA−2)。   Then, the indirect expenses / indirect labor cost preparation unit 102b calculates the indirect cost ratio (%) and the indirect labor cost ratio (%) of the indirect ratio table 106b by order category according to the work content (order receiving category) at the time of creating the execution budget. Indirect expenses and indirect labor expenses are created from the contract amount (step SA-2).

また、進行基準売上計上部102cは、工事進捗率である原価進捗率を算出して売上計上を行う(ステップSA−3)。例えば、請負金額に原価進捗率を掛けることで完成分の受注額を計上し、間接経費に原価進捗率を掛けることで完成分の間接経費を計上し、間接人件費に原価進捗率を掛けることで完成分の間接人件費を計上して、工事進行基準における完成分の原価を計算することができる。   Further, the progress-based sales accounting unit 102c calculates the cost progress rate, which is the construction progress rate, and records the sales (step SA-3). For example, the contract amount is multiplied by the cost progress rate, the completed order amount is recorded, the overhead cost is multiplied by the cost progress rate, the completed overhead cost is recorded, and the indirect labor cost is multiplied by the cost progress rate The indirect labor cost of the completed part can be recorded and the cost of the completed part on the construction progress standard can be calculated.

更に、進行基準売上計上部102cは、プロジェクトの完成分の間接経費と間接人件費を自動分配し、これに基づいて未成分の間接経費と間接人件費を計上する(ステップSA−4)。これにより、プロジェクト全体の採算性を確認することができる。   Further, the progress-based sales accounting unit 102c automatically distributes the overhead cost and the indirect labor cost for the completion of the project, and based on this, records the indirect overhead cost and the indirect labor cost which are not components (step SA-4). This makes it possible to confirm the profitability of the entire project.

[プロジェクト一覧表の具体例]
実行予算作成時には、以下の計算を行って完成分と未成分の原価を表したプロジェクト一覧表を別表(図5、図6参照)で作成する。具体的には、本実施形態に係る工事進行基準計上装置100は、間接比率作成部102aにより工事内容(受注区分)毎に前年度の実績に応じて作成した受注区分別間接比率テーブル106bの間接人件費比率(%)と間接経費比率(%)とを用いて、請負金額(総受注金額)¥4,800,000に対する間接製造人件費と製造間接経費とを自動作成する。受注区分が民間土木工事である場合、間接経費・間接人件費作成部102bは、図2の受注区分別間接比率テーブルの間接人件費比率(%)=2.3と、間接経費比率(%)=0.9とを用いて、間接製造人件費と製造間接経費とを自動算出する。
間接製造人件費=請負金額×間接人件費比率÷100=4,800,000×2.3÷100=110,400
製造間接経費=請負金額×間接経費比率÷100=4,800,000×0.9÷100=43,200
[Example of project list]
At the time of preparation of the execution budget, the following calculation is performed to create a project list representing the cost of the completed part and the non-component with a separate table (see FIGS. 5 and 6). Specifically, the construction progress standard accounting device 100 according to the present embodiment is an indirect ratio-by-order category indirect ratio table 106b created by the indirect ratio creation unit 102a according to the results of the previous year for each work content (order category) Using the labor cost ratio (%) and the overhead cost ratio (%), automatically create an indirect manufacturing labor cost and a manufacturing overhead cost for the contract amount (total order value) ¥ 4,800,000. When the order classification is private civil engineering work, the indirect cost ratio (%) = 2.3 and the indirect cost ratio (%) of the indirect ratio table of the indirect ratio table by order type shown in FIG. The indirect manufacturing labor cost and the manufacturing overhead cost are automatically calculated using = 0.9.
Indirect manufacturing cost = Contract price × Indirect labor cost ratio, 100 = 4,800,000 × 2.3 ÷ 100 = 110,400
Manufacturing overhead cost = contract price × overhead cost ratio ÷ 100 = 4,800,000 × 0.9 ÷ 100 = 43,200

(完成分のプロジェクト一覧表)
続いて、進行基準売上計上部102cは、図6に示すように、原価進捗に応じた間接費の完成分の売上計上を行うため、原価進捗率を求め、この原価進捗率に間接製造人件費や製造間接経費を掛けることで、完成分の間接費の原価を計上する。
原価進捗率=31.0335323840147
≒31.03(%)
(List of completed projects)
Subsequently, as shown in FIG. 6, the progress-based sales accounting unit 102c calculates the cost progress rate in order to account for the completion of the indirect cost according to the cost progress, and determines the cost progress rate as the indirect manufacturing labor cost. And the cost of overhead costs for completed components by multiplying production overhead costs.
Cost progress rate = 31.0335323840147
3 31.03 (%)

工事進捗率に応じた完成分の間接製造人件費と製造間接経費の原価計算は、
間接製造人件費の完成分の原価=間接製造人件費×原価進捗率÷100
=110,400×31.0335323840147÷100
≒34,261
製造間接経費の完成分の原価=製造間接経費×原価進捗率÷100
=43,200×31.0335323840147÷100
≒13,406
となり、図6の一点鎖線の枠に示したように、プロジェクトの進捗率に応じた完成分の間接製造人件費や製造間接経費の原価が表示されたプロジェクト一覧表を作表できる。
The costing of indirect manufacturing personnel expenses and manufacturing overhead expenses according to the construction progress rate is
Cost of completed indirect manufacturing cost = indirect manufacturing cost × cost progress rate ÷ 100
= 110, 400 x 3 1.0 33 532 384 ÷ 100
34 34, 261
Finished cost of production overhead = production overhead × cost progress rate ÷ 100
= 43, 200 x 3 1.0 33 532 384 ÷ 100
13 13,406
Thus, as shown in the frame of one-dot chain line in FIG. 6, it is possible to tabulate a project list in which the costs of indirect manufacturing costs and overhead costs for completion are displayed according to the progress rate of the project.

(未成分のプロジェクト一覧表)
また、進行基準売上計上部102cは、図5に示すように、上記算出した完成分の間接製造人件費と製造間接経費とに基づいて、未成分の間接費の原価を計上することができる。つまり、プロジェクトの未成分の間接製造人件費と製造間接経費の原価は、完成分の原価を引いた残りとなる。
間接製造人件費の未成分の原価=間接製造人件費−間接製造人件費の完成分の原価
=110,400−34,261
=76,139
製造間接経費の未成分の原価=製造間接経費−製造間接経費の完成分の原価
=43,200−13,406
=29,794
となり、図5の一点鎖線の枠内に示すように、プロジェクトの進捗率に応じた未成分の間接製造人件費や製造間接経費の原価を表示することができる。
(List of projects without ingredients)
Further, as shown in FIG. 5, the progress-based sales accounting unit 102c can account for the cost of the unconsolidated indirect expenses based on the calculated indirect manufacturing personnel expenses and the manufacturing indirect expenses calculated as described above. In other words, the cost of the project's unconsolidated indirect manufacturing labor costs and manufacturing overhead costs is the remainder after subtracting the cost of completion.
Raw cost of indirect manufacturing cost = indirect manufacturing cost-cost of completion of indirect manufacturing cost
= 110, 400-34, 261
= 76, 139
Unconsumed cost of manufacturing overhead cost = manufacturing overhead cost-cost of completion of manufacturing overhead cost
= 43, 200-13, 406
= 29, 794
As a result, as shown in the dashed-dotted line frame of FIG. 5, the cost of the uncompleted indirect manufacturing labor cost and the manufacturing overhead cost according to the progress rate of the project can be displayed.

以上述べたように、本実施形態に係る工事進行基準計上装置100は、実行予算作成時に工事内容(受注区分)に応じた比率に基づいて総受注金額に含まれる製造間接経費と間接製造人件費を求め、原価進捗率を掛けて完成分と未成分の原価を自動算出することで、手入力によるミスや負荷を軽減した実行予算に適した原価計算を行い、全体の採算性を確認することで、正確な営業利益の算出が可能となる。   As described above, the construction progress standard accounting device 100 according to the present embodiment is based on the ratio according to the contents of the work (order division) at the time of creation of the execution budget, and the manufacturing indirect expenses and indirect manufacturing personnel expenses included in the total order amount By calculating the cost progress rate and multiplying the cost progress rate to automatically calculate the cost of completed and uncomponented components, perform cost calculation suitable for the execution budget with reduced mistakes and loads by manual input, and check the overall profitability. Therefore, accurate calculation of operating income becomes possible.

なお、本実施形態に係る工事進行基準計上装置100は、次式に示すように、請負金額に原価進捗率を掛けて計上可能額(売上可能額)を求めることにより、売上可能額を自動算出することができる。
計上可能額=請負金額×原価進捗率÷100
=4,800,000×31.0335323840147÷100
≒1,489610
In addition, the construction progress standard accounting device 100 according to the present embodiment automatically calculates the possible sales amount by multiplying the contract amount by the cost progress rate to obtain the possible recording amount (the possible sales amount) as shown in the following equation. can do.
Recordable amount = contract amount × cost progress rate ÷ 100
= 4,800,000 × 3 1.0 33 532 384 ÷ 100
1,4 1,489610

[4.他の実施形態]
本発明は、上述した実施形態以外にも、特許請求の範囲に記載した技術的思想の範囲内において種々の異なる実施形態にて実施されてよいものである。
[4. Other embodiments]
The present invention may be practiced in various different embodiments within the scope of the technical idea described in the claims in addition to the embodiments described above.

例えば、実施形態において説明した各処理のうち、自動的に行われるものとして説明した処理の全部または一部を手動的に行うこともでき、あるいは、手動的に行われるものとして説明した処理の全部または一部を公知の方法で自動的に行うこともできる。   For example, among the processes described in the embodiment, all or part of the process described as being automatically performed may be manually performed, or all the processes described as being manually performed. Alternatively, some of them can be performed automatically by known methods.

また、本明細書中や図面中で示した処理手順、制御手順、具体的名称、各処理の登録データや検索条件等のパラメータを含む情報、画面例、データベース構成については、特記する場合を除いて任意に変更することができる。   In addition, information including processing procedures, control procedures, specific names, registered data of each processing, parameters such as search conditions, screen examples, and database configurations shown in the present specification and the drawings are described unless otherwise specified. Can be changed arbitrarily.

また、工事進行基準計上装置100に関して、図示の各構成要素は機能概念的なものであり、必ずしも物理的に図示の如く構成されていることを要しない。   Further, with regard to the construction progress standard accounting device 100, each component shown in the drawings is functionally conceptual and does not necessarily have to be physically configured as shown.

例えば、工事進行基準計上装置100が備える処理機能、特に制御部102にて行われる各処理機能については、その全部または任意の一部を、CPUおよび当該CPUにて解釈実行されるプログラムにて実現してもよく、また、ワイヤードロジックによるハードウェアとして実現してもよい。尚、プログラムは、本実施形態で説明した処理を情報処理装置に実行させるためのプログラム化された命令を含む一時的でないコンピュータ読み取り可能な記録媒体に記録されており、必要に応じて工事進行基準計上装置100に機械的に読み取られる。すなわち、ROMまたはHDD(Hard Disk Drive)などの記憶部などには、OSと協働してCPUに命令を与え、各種処理を行うためのコンピュータプログラムが記録されている。このコンピュータプログラムは、RAMにロードされることによって実行され、CPUと協働して制御部102を構成する。   For example, all or any part of the processing functions provided in the construction progress standard accounting device 100, in particular each processing function performed by the control unit 102, are realized by the CPU and a program executed by the CPU It may be realized as hardware by wired logic. The program is stored in a non-temporary computer-readable recording medium that includes a programmed instruction for causing the information processing apparatus to execute the processing described in the present embodiment, and the work progress standard as necessary. It is mechanically read by the accounting device 100. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). The computer program is executed by being loaded into the RAM, and configures the control unit 102 in cooperation with the CPU.

また、このコンピュータプログラムは、工事進行基準計上装置100に対して任意のネットワークを介して接続されたアプリケーションプログラムサーバに記憶されていてもよく、必要に応じてその全部または一部をダウンロードすることも可能である。   In addition, this computer program may be stored in an application program server connected to the construction progress standard accounting device 100 via an arbitrary network, and all or part of the computer program may be downloaded as necessary. It is possible.

また、本実施形態で説明した処理を実行するためのプログラムを、一時的でないコンピュータ読み取り可能な記録媒体に格納してもよく、また、プログラム製品として構成することもできる。ここで、この「記録媒体」とは、メモリーカード、USB(Universal Serial Bus)メモリ、SD(Secure Digital)カード、フレキシブルディスク、光磁気ディスク、ROM、EPROM(Erasable Programmable Read Only Memory)、EEPROM(登録商標)(Electrically Erasable and Programmable Read Only Memory)、CD−ROM(Compact Disk Read Only Memory)、MO(Magneto−Optical disk)、DVD(Digital Versatile Disk)、および、Blu−ray(登録商標) Disc等の任意の「可搬用の物理媒体」を含むものとする。   Further, the program for executing the processing described in the present embodiment may be stored in a non-temporary computer readable recording medium, or may be configured as a program product. Here, the "recording medium" means a memory card, a universal serial bus (USB) memory, a secure digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an erasable programmable read only memory (EPROM), and an EEPROM (registration). Trademarks (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Blu-ray (registered trademark) Disc etc. Any "portable physical media It is intended to include.

また、「プログラム」とは、任意の言語または記述方法にて記述されたデータ処理方法であり、ソースコードまたはバイナリコード等の形式を問わない。なお、「プログラム」は必ずしも単一的に構成されるものに限られず、複数のモジュールやライブラリとして分散構成されるものや、OSに代表される別個のプログラムと協働してその機能を達成するものをも含む。なお、実施形態に示した各装置において記録媒体を読み取るための具体的な構成および読み取り手順ならびに読み取り後のインストール手順等については、周知の構成や手順を用いることができる。   The “program” is a data processing method described in any language or description method, and may be in any format such as source code or binary code. Note that the “program” is not necessarily limited to one that is configured in a single way, and achieves its function in cooperation with a separate program represented by a plurality of modules or libraries or a separate program represented by the OS. Including things. In addition, as a specific configuration and reading procedure for reading the recording medium in each device shown in the embodiment, an installation procedure after reading, and the like, a known configuration and procedure can be used.

記憶部106に格納される各種のデータベース等は、RAM、ROM等のメモリ装置、ハードディスク等の固定ディスク装置、フレキシブルディスク、および、光ディスク等のストレージ手段であり、各種処理やウェブサイト提供に用いる各種のプログラム、テーブル、データベース、および、ウェブページ用ファイル等を格納する。   The various databases and the like stored in the storage unit 106 are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, storage means such as optical disks, etc. Stores programs, tables, databases, files for web pages, etc.

また、工事進行基準計上装置100は、既知のパーソナルコンピュータまたはワークステーション等の情報処理装置として構成してもよく、また、任意の周辺装置が接続された当該情報処理装置として構成してもよい。また、工事進行基準計上装置100は、当該情報処理装置に本実施形態で説明した処理を実現させるソフトウェア(プログラムまたはデータ等を含む)を実装することにより実現してもよい。   In addition, the construction progress standard accounting device 100 may be configured as an information processing device such as a known personal computer or a work station, or may be configured as the information processing device to which any peripheral device is connected. In addition, the construction progress standard accounting device 100 may be realized by implementing software (including a program or data, etc.) that causes the information processing device to realize the processing described in the present embodiment.

更に、装置の分散・統合の具体的形態は図示するものに限られず、その全部または一部を、各種の付加等に応じてまたは機能付加に応じて、任意の単位で機能的または物理的に分散・統合して構成することができる。すなわち、上述した実施形態を任意に組み合わせて実施してもよく、実施形態を選択的に実施してもよい。   Furthermore, the specific form of distribution and integration of the device is not limited to that shown in the drawings, and all or part thereof may be functionally or physically in any unit in accordance with various additions or in accordance with addition of functions. It can be distributed and integrated. That is, the embodiments described above may be implemented in any combination, and the embodiments may be implemented selectively.

本発明は、工事進行基準を用いて完成振替仕訳を行う工事業等において有用である。   INDUSTRIAL APPLICABILITY The present invention is useful in an engineering business etc. that performs complete transfer journalizing using a construction progress standard.

100 工事進行基準計上装置
102 制御部
102a 間接比率作成部
102b 間接経費・間接人件費作成部
102c 進行基準売上計上部
104 通信インターフェース部
106 記憶部
106a 受注区分別データ
106b 受注区分別間接比率テーブル
108 入出力インターフェース部
112 入力装置(キーボード)
114 出力装置(モニタ)
200 サーバ
300 ネットワーク
100 construction progress standard accounting device 102 control unit 102a indirect ratio preparation unit 102b indirect expenses / indirect labor cost preparation unit 102c progress basis sales accounting unit 104 communication interface unit 106 storage unit 106a data by order category 106b indirect ratio table by order category 108 Output interface unit 112 Input device (keyboard)
114 Output device (monitor)
200 server 300 network

Claims (5)

制御部を備え、工事進行基準における間接費の完成振替仕訳を作成する工事進行基準計上装置であって、
前記制御部は、
工事内容毎の過去の実績データに基づいて売上高に占める間接費の割合を示す間接比率テーブルを作成する間接比率作成手段と、
実行予算登録時に、前記間接比率テーブルの工事内容に応じた間接比率に基づいて請負金額に含まれる間接経費と間接人件費の予算を作成する予算作成手段と、
工事進行基準における売上時に、前記売上高と前記請負金額と前記間接経費あるいは前記間接人件費とを用いて完成分の原価を計算して計上する進行基準売上計上手段と、
を備えていること、
を特徴とする工事進行基準計上装置。
A construction progress standard accounting device that has a control unit and creates a complete transfer journal of indirect costs in the construction progress standard,
The control unit
Indirect ratio creation means for creating an indirect ratio table indicating the ratio of indirect expenses to sales based on past actual data for each construction content;
Budget creation means for creating a budget for overhead expenses and indirect labor expenses included in the contract amount based on the indirect ratio according to the work content of the indirect ratio table at the time of registering the active budget;
Progress-based sales accruing means for calculating and recording the cost of the completed part using the sales, the contract price, the indirect cost, or the indirect labor cost at the time of sales under the construction progress standard,
Be equipped with
Construction progress standard accounting device characterized by.
前記進行基準売上計上手段は、
完成分と未完成分の原価をそれぞれ別表に作成することを特徴とする請求項1に記載の
工事進行基準計上装置。
The above-mentioned progress-based sales accounting means is
The construction progress accounting apparatus according to claim 1, wherein the costs of the completed part and the uncompleted part are separately prepared in separate tables.
前記進行基準売上計上手段は、
工事進行基準における完成分の間接費の原価を次式(1)により求めることを特徴とする請求項1に記載の工事進行基準計上装置。
進行基準売上高÷請負総額×間接費(間接経費または間接人件費)……(1)
The above-mentioned progress-based sales accounting means is
2. The construction progress standard accounting device according to claim 1, wherein the cost of the indirect cost for the completion in the construction progress standard is obtained by the following equation (1).
Progress-based sales ÷ total contract cost × overhead cost (overhead cost or indirect labor cost) ... (1)
制御部を備え、工事進行基準における間接費の完成振替仕訳を作成する工事進行基準計上装置で実行される工事進行基準計上方法であって、
前記制御部で実行される、
工事内容毎の過去の実績データに基づいて売上高に占める間接費の割合を示す間接比率テーブルを作成する間接比率作成ステップと、
実行予算登録時に、前記間接比率テーブルの工事内容に応じた間接比率に基づいて請負金額に含まれる間接経費と間接人件費の予算を作成する予算作成ステップと、
工事進行基準における売上時に、前記売上高と前記請負金額と前記間接経費あるいは前記間接人件費とを用いて完成分の原価を計算して計上する進行基準売上計上ステップと、
を含むこと、
を特徴とする工事進行基準計上方法。
A construction progress standard accruing method implemented by a construction progress standard accommodating device that includes a control unit and creates a complete transfer journal of indirect costs in the construction progress standard,
Executed by the controller
An indirect ratio creation step of creating an indirect ratio table indicating a ratio of indirect cost to sales based on past actual data for each construction content;
A budget creation step of creating a budget for overhead expenses and indirect labor expenses included in the contract amount based on the indirect ratio according to the work content of the indirect ratio table at the time of registering the active budget;
A progress-based sales accounting step of calculating and recording the cost of the completed part using the sales, the contract price, the indirect expenses, or the indirect labor cost at the time of sales according to the construction progress standard;
Including
Construction progress standard accrual method characterized by
制御部を備え、工事進行基準における間接費の完成振替仕訳を作成する工事進行基準計上装置で実行させるための工事進行基準計上プログラムであって、
前記制御部で実行させるための、
工事内容毎の過去の実績データに基づいて売上高に占める間接費の割合を示す間接比率テーブルを作成する間接比率作成ステップと、
実行予算登録時に、前記間接比率テーブルの工事内容に応じた間接比率に基づいて請負金額に含まれる間接経費と間接人件費の予算を作成する予算作成ステップと、
工事進行基準における売上時に、前記売上高と前記請負金額と前記間接経費あるいは前記間接人件費とを用いて完成分の原価を計算して計上する進行基準売上計上ステップと、
を含むこと、
を特徴とする工事進行基準計上プログラム。
A construction progress standard accruing program to be executed by a construction progress standard accruing device that has a control unit and creates a complete transfer journal of indirect costs according to the construction progress standard,
To be executed by the control unit,
An indirect ratio creation step of creating an indirect ratio table indicating a ratio of indirect cost to sales based on past actual data for each construction content;
A budget creation step of creating a budget for overhead expenses and indirect labor expenses included in the contract amount based on the indirect ratio according to the work content of the indirect ratio table at the time of registering the active budget;
A progress-based sales accounting step of calculating and recording the cost of the completed part using the sales, the contract price, the indirect expenses, or the indirect labor cost at the time of sales according to the construction progress standard;
Including
Construction progress standard accrual program characterized by.
JP2017168755A 2017-09-01 2017-09-01 Construction progress basis accounting system, construction progress basis accounting method and construction progress basis accounting program Pending JP2019046168A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
JP2017168755A JP2019046168A (en) 2017-09-01 2017-09-01 Construction progress basis accounting system, construction progress basis accounting method and construction progress basis accounting program

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
JP2017168755A JP2019046168A (en) 2017-09-01 2017-09-01 Construction progress basis accounting system, construction progress basis accounting method and construction progress basis accounting program

Publications (1)

Publication Number Publication Date
JP2019046168A true JP2019046168A (en) 2019-03-22

Family

ID=65812828

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2017168755A Pending JP2019046168A (en) 2017-09-01 2017-09-01 Construction progress basis accounting system, construction progress basis accounting method and construction progress basis accounting program

Country Status (1)

Country Link
JP (1) JP2019046168A (en)

Cited By (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2020181343A (en) * 2019-04-24 2020-11-05 株式会社オービック Profit recognizing device, profit recognizing method, and profit recognizing program
JP2021056673A (en) * 2019-09-27 2021-04-08 株式会社オービック Safety cooperation membership fee breakdown management device, safety cooperation membership fee breakdown management method, and safety cooperation membership fee breakdown management program
JP2021093070A (en) * 2019-12-12 2021-06-17 株式会社オービック Device, method, and program for calculating estimated progress rate
JP2022019394A (en) * 2020-07-17 2022-01-27 株式会社オービック Project management apparatus, project management method, and project management program
JP2022027277A (en) * 2020-07-31 2022-02-10 株式会社オービック Indirect cost management device, indirect cost management method, and indirect cost management program
JP2022039638A (en) * 2020-08-28 2022-03-10 株式会社オービック Business support device, business support program, and business support method
JP7098126B1 (en) 2022-02-04 2022-07-11 株式会社大兼工務店 Accounting equipment, accounting methods, and accounting programs
CN117853027A (en) * 2023-11-08 2024-04-09 北京梦诚科技有限公司 Project engineering economic activity analysis method and device based on economic accounting
JP7505998B2 (en) 2021-01-29 2024-06-25 株式会社オービック Budget data generation device, budget data generation method, and budget data generation program
JP7535074B2 (en) 2022-03-24 2024-08-15 株式会社オービック Cost transfer device, cost transfer method, and cost transfer program

Cited By (16)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2020181343A (en) * 2019-04-24 2020-11-05 株式会社オービック Profit recognizing device, profit recognizing method, and profit recognizing program
JP7411338B2 (en) 2019-04-24 2024-01-11 株式会社オービック Revenue recognition device, revenue recognition method, and revenue recognition program
JP7360879B2 (en) 2019-09-27 2023-10-13 株式会社オービック Safety cooperation membership fee breakdown management device, safety cooperation membership fee breakdown management method, and safety cooperation membership fee breakdown management program
JP2021056673A (en) * 2019-09-27 2021-04-08 株式会社オービック Safety cooperation membership fee breakdown management device, safety cooperation membership fee breakdown management method, and safety cooperation membership fee breakdown management program
JP2021093070A (en) * 2019-12-12 2021-06-17 株式会社オービック Device, method, and program for calculating estimated progress rate
JP7406361B2 (en) 2019-12-12 2023-12-27 株式会社オービック Planned progress rate calculation device, planned progress rate calculation method, and planned progress rate calculation program
JP7462500B2 (en) 2020-07-17 2024-04-05 株式会社オービック Project management device, project management method, and project management program
JP2022019394A (en) * 2020-07-17 2022-01-27 株式会社オービック Project management apparatus, project management method, and project management program
JP2022027277A (en) * 2020-07-31 2022-02-10 株式会社オービック Indirect cost management device, indirect cost management method, and indirect cost management program
JP2022039638A (en) * 2020-08-28 2022-03-10 株式会社オービック Business support device, business support program, and business support method
JP7454470B2 (en) 2020-08-28 2024-03-22 株式会社オービック Business support device, business support program, and business support method
JP7505998B2 (en) 2021-01-29 2024-06-25 株式会社オービック Budget data generation device, budget data generation method, and budget data generation program
JP2023114173A (en) * 2022-02-04 2023-08-17 株式会社大兼工務店 Accounting processing device, accounting processing method, and accounting processing program
JP7098126B1 (en) 2022-02-04 2022-07-11 株式会社大兼工務店 Accounting equipment, accounting methods, and accounting programs
JP7535074B2 (en) 2022-03-24 2024-08-15 株式会社オービック Cost transfer device, cost transfer method, and cost transfer program
CN117853027A (en) * 2023-11-08 2024-04-09 北京梦诚科技有限公司 Project engineering economic activity analysis method and device based on economic accounting

Similar Documents

Publication Publication Date Title
JP2019046168A (en) Construction progress basis accounting system, construction progress basis accounting method and construction progress basis accounting program
JP7029929B2 (en) Cost accounting equipment, cost accounting method, and cost accounting program
JP2022182779A (en) Information processing device, information processing method, and program
JP2018206007A (en) Shared expense prorating device, shared expense prorating method, and shared expense prorating program
JP2024028605A (en) Project management device, project management method, and project management program
JP2017168090A (en) Credit management device per project, credit management method per project, and credit management program per project
JP2018073192A (en) Amount calculation apparatus, amount calculation method and amount calculation program
JP7389849B2 (en) Information processing device, information processing method, and information processing program
JP6923408B2 (en) Retroactive unit price correction device, retroactive unit price correction method, and retroactive unit price correction program
JP7240100B2 (en) Proportion calculation device, proportion calculation method, and proportion calculation program
JP2021093070A (en) Device, method, and program for calculating estimated progress rate
JP7505998B2 (en) Budget data generation device, budget data generation method, and budget data generation program
JP2024085099A (en) Data creation apparatus, data creation method, and data creation program
JP2023144967A (en) Earned value management device, earned value management method, and earned value management program
JP7462500B2 (en) Project management device, project management method, and project management program
JP7550712B2 (en) Planned start and end date calculation device, planned start and end date calculation method, and planned start and end date calculation program
JP7454470B2 (en) Business support device, business support program, and business support method
JP2019061619A (en) Balance management device, balance management method, and balance management program
JP7499171B2 (en) Apparatus for managing work results by job responsibilities, method for managing work results by job responsibilities, and program for managing work results by job responsibilities
JP2019125107A (en) Withholding tax related business support device, withholding tax related business supporting method, and withholding tax related business supporting program
JP2019113965A (en) Financing management device, financing management method, and financing management program
JP2024121559A (en) Performance management device, performance management method, and performance management program
Nelson et al. Lean Implementation in a Painter/Decorator Micro Enterprise: A Case Study
JP7065704B2 (en) Calculation device, calculation method and calculation program
JP2024015863A (en) Sales accounting device, sales accounting method and sales accounting program