JP2021149926A - Cost budget/actual management device, cost budget/actual management method, and cost budget/actual management program - Google Patents

Cost budget/actual management device, cost budget/actual management method, and cost budget/actual management program Download PDF

Info

Publication number
JP2021149926A
JP2021149926A JP2020173587A JP2020173587A JP2021149926A JP 2021149926 A JP2021149926 A JP 2021149926A JP 2020173587 A JP2020173587 A JP 2020173587A JP 2020173587 A JP2020173587 A JP 2020173587A JP 2021149926 A JP2021149926 A JP 2021149926A
Authority
JP
Japan
Prior art keywords
cost
serial number
classification
data
actual
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.)
Granted
Application number
JP2020173587A
Other languages
Japanese (ja)
Other versions
JP7404215B2 (en
Inventor
誠太郎 木村
Seitaro Kimura
誠太郎 木村
正陽 薄井
Masaharu Usui
正陽 薄井
剛光 上野
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
Publication of JP2021149926A publication Critical patent/JP2021149926A/en
Priority to JP2023208907A priority Critical patent/JP2024015351A/en
Application granted granted Critical
Publication of JP7404215B2 publication Critical patent/JP7404215B2/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Landscapes

  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

To highly accurately perform cost budget/actual management by subdividing and recording indirect costs.SOLUTION: A cost budget/actual management device according to the present embodiment includes: a master in which an indirect cost rate is set up for every product number classification, product number management department, and product number cost item; input means for inputting direct cost data including the product number, product number classification, product number management department, product number cost item, and cost of respective types of data; cost accounting processing means for aggregating costs of the direct cost data for every product number classification, product number management department, and product number cost item, and multiplying the aggregated cost by the indirect cost rate acquired from the master, with the product number classification, product number management department, and product number cost item used as keys to calculate indirect cost data; journal creation means for creating a prescribed-classification journal of planned cost data including the direct cost data and the indirect cost data; and cost difference totaling means for acquiring an actual incurred cost and creating a prescribed-classification cost difference spread sheet of the planned cost data and the acquired actual incurred cost.SELECTED DRAWING: Figure 1

Description

本発明は、原価予実管理装置、原価予実管理方法、及び原価予実管理プログラムに関する。 The present invention relates to a cost accounting and actual management device, a cost accounting and actual management method, and a cost accounting and actual management program.

例えば、大型機械の製造を行う業界では個別原価管理を行う企業が多く、発生する直接費に対して間接費を計算して予定原価を算出し、実際発生原価と対比して原価の予実を管理している。原価の予実管理を行うシステムとして、例えば、特許文献1がある。 For example, in the industry that manufactures large machines, there are many companies that manage individual costs, and the indirect costs are calculated for the direct costs incurred to calculate the planned costs, and the actual costs are managed in comparison with the actual costs incurred. doing. As a system for managing cost forecasts and actual costs, for example, there is Patent Document 1.

特開2020−4439号公報Japanese Unexamined Patent Publication No. 2020-4439

しかしながら、上記特許文献1では、間接費を細分化して計上することで原価予実管理を高精度に行うことに関して何等記載されていない。 However, Patent Document 1 does not describe anything about performing cost forecasting and actual management with high accuracy by subdividing and recording overhead costs.

本発明は、上記に鑑みてなされたものであって、間接費を細分化して計上することで原価予実管理を高精度に行うことが可能な原価予実管理装置、原価予実管理方法、及び原価予実管理プログラムを提供することを目的とする。 The present invention has been made in view of the above, and is a cost accounting and actual management device, a cost accounting and actual management method, and a cost accounting and actual management that can perform cost accounting and actual management with high accuracy by subdividing and recording indirect costs. The purpose is to provide a management program.

上述した課題を解決し、目的を達成するために、本発明は、記憶部及び制御部を備えた原価予実管理装置であって、前記記憶部には、製番分類、製番管理部門、及び製番原価科目毎に、間接費率を設定したマスタが格納されており、前記制御部は、各種データについて、製番、製番分類、製番管理部門、製番原価科目、及び原価を含む直接費データを入力する入力手段と、前記直接費データを製番分類、製番管理部門、製番原価科目毎に原価を集約し、集約した原価に、前記マスタから製番分類、製番管理部門、及び製番原価科目をキーとして取得した間接費率を乗算して間接費データを算出する原価計算処理手段と、前記直接費データ及び前記間接費データを含む予定原価データについて、所定分類の仕訳を作成する仕訳作成手段と、実際発生原価を取得し、前記予定原価データと取得した実際発生原価について、前記所定分類の原価差額集計表を作成する原価差額集計手段と、を備えている。 In order to solve the above-mentioned problems and achieve the object, the present invention is a cost accounting and actual management device including a storage unit and a control unit, and the storage unit includes a serial number classification, a serial number management department, and a serial number management department. A master in which an indirect cost rate is set is stored for each serial number cost item, and the control unit includes the serial number, serial number classification, serial number management department, serial number cost item, and cost for various data. An input means for inputting direct cost data, and the direct cost data is aggregated by serial number classification, serial number management department, and serial number cost item, and the aggregated costs are classified by serial number classification and serial number management from the master. The cost accounting processing means for calculating indirect cost data by multiplying the indirect cost rate acquired by using the department and the serial number cost item as a key, and the planned cost data including the direct cost data and the indirect cost data are classified into predetermined categories. It is provided with a journal creation means for creating a journal and a cost difference totaling means for acquiring the actual incurred cost and creating the cost difference totaling table of the predetermined classification with respect to the planned cost data and the acquired actual incurred cost.

また、本発明の一態様によれば、前記製番分類は、製品製番、試作製番、修理製番、経費製番、及び工事製番を含むことにしてもよい。 Further, according to one aspect of the present invention, the serial number classification may include a product serial number, a trial production number, a repair serial number, an expense serial number, and a construction serial number.

また、本発明の一態様によれば、製番管理部門は、製造部と設計部を含むことにしてもよい。 Further, according to one aspect of the present invention, the production number management department may include a manufacturing department and a design department.

また、本発明の一態様によれば、前記製番原価科目は、直接労務費、材料費、及び外注加工費を含むことにしてもよい。 Further, according to one aspect of the present invention, the serial number cost item may include a direct labor cost, a material cost, and an outsourced processing cost.

また、本発明の一態様によれば、前記所定分類は、製番管理部門、製番、及び製番分類を含むことにしてもよい。 Further, according to one aspect of the present invention, the predetermined classification may include a production number management department, a production number, and a production number classification.

また、本発明の一態様によれば、前記各種データは、仕入、出庫、及び作業実績のデータを含むことにしてもよい。 Further, according to one aspect of the present invention, the various data may include data on purchase, delivery, and work results.

また、上述した課題を解決し、目的を達成するために、本発明は、記憶部及び制御部を備えた情報処理装置で実行される原価予実管理方法であって、前記記憶部には、製番分類、製番管理部門、及び製番原価科目毎に、間接費率を設定したマスタが格納されており、前記制御部において実行される、各種データについて、製番、製番分類、製番管理部門、製番原価科目、及び原価を含む直接費データを入力する入力工程と、前記直接費データを製番分類、製番管理部門、製番原価科目毎に原価を集約し、集約した原価に、前記マスタから製番分類、製番管理部門、及び製番原価科目をキーとして取得した間接費率を乗算して間接費データを算出する原価計算処理工程と、前記直接費データ及び前記間接費データを含む予定原価データについて、所定分類の仕訳を作成する仕訳作成工程と、実際発生原価を取得し、前記予定原価データと取得した実際発生原価について、前記所定分類の原価差額集計表を作成する原価差額集計工程と、を含むことを特徴とする。 Further, in order to solve the above-mentioned problems and achieve the object, the present invention is a cost accounting management method executed by an information processing apparatus including a storage unit and a control unit. A master in which an indirect cost rate is set is stored for each number classification, serial number management department, and serial number cost item, and various data executed in the control unit are subject to serial number, serial number classification, and serial number. An input process for inputting management department, serial number cost item, and direct cost data including cost, and the aggregated cost by aggregating the direct cost data for each serial number classification, serial number management department, and serial number cost item. In addition, a cost calculation processing process for calculating indirect cost data by multiplying the indirect cost rate acquired from the master using the serial number classification, serial number management department, and serial number cost item as a key, and the direct cost data and the indirect For the planned cost data including the cost data, the journal creation process for creating the journal of the predetermined classification and the actual incurred cost are acquired, and for the planned cost data and the acquired actual incurred cost, the cost difference summary table of the predetermined classification is created. It is characterized by including a cost difference totaling process.

また、上述した課題を解決し、目的を達成するために、本発明は、制御部及び記憶部を備えた情報処理装置に実行させるための原価予実管理プログラムであって、前記記憶部には、製番分類、製番管理部門、及び製番原価科目毎に、間接費率を設定したマスタが格納されており、前記制御部において、各種データについて、製番、製番分類、製番管理部門、製番原価科目、及び原価を含む直接費データを入力する入力工程と、前記直接費データを製番分類、製番管理部門、製番原価科目毎に原価を集約し、集約した原価に、前記マスタから製番分類、製番管理部門、及び製番原価科目をキーとして取得した間接費率を乗算して間接費データを算出する原価計算処理工程と、前記直接費データ及び前記間接費データを含む予定原価データについて、所定分類の仕訳を作成する仕訳作成工程と、実際発生原価を取得し、前記予定原価データと取得した実際発生原価について、前記所定分類の原価差額集計表を作成する原価差額集計工程と、を実行するための原価予実管理プログラムであることを特徴とする。 Further, in order to solve the above-mentioned problems and achieve the object, the present invention is a cost accounting management program for causing an information processing apparatus including a control unit and a storage unit to execute the cost accounting and actual management program. A master in which an indirect cost rate is set is stored for each serial number classification, serial number management department, and serial number cost item, and in the control unit, the serial number, serial number classification, and serial number management department are used for various data. , Production number cost item, and input process to input direct cost data including cost, and the direct cost data is aggregated by production number classification, production number management department, production number cost item, and aggregated cost. A cost accounting process that calculates indirect cost data by multiplying the indirect cost rate acquired from the master using the serial number classification, serial number management department, and serial number cost item as keys, and the direct cost data and the indirect cost data. For the planned cost data including It is characterized by being a cost accounting management program for executing the difference totaling process.

本発明によれば、間接費を細分化して計上することで原価予実管理を高精度に行うことが可能になるという効果を奏する。 According to the present invention, it is possible to carry out cost forecasting and actual management with high accuracy by subdividing and recording overhead costs.

図1は、本実施の形態に係る原価予実管理装置の構成の一例を示すブロック図である。FIG. 1 is a block diagram showing an example of the configuration of the cost accounting and actual management device according to the present embodiment. 図2は、本実施の形態に係る原価予実管理装置の制御部の処理の具体例を説明するための図である。FIG. 2 is a diagram for explaining a specific example of processing of the control unit of the cost accounting and actual management device according to the present embodiment. 図3は、本実施の形態に係る原価予実管理装置の制御部の処理の具体例を説明するための図である。FIG. 3 is a diagram for explaining a specific example of processing of the control unit of the cost accounting and actual management device according to the present embodiment. 図4は、本実施の形態に係る原価予実管理装置の制御部の処理の具体例を説明するための図である。FIG. 4 is a diagram for explaining a specific example of processing of the control unit of the cost accounting and actual management device according to the present embodiment.

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

[1:概要]
例えば、大型機械の製造を行う業界では個別原価管理を行う企業が多く、発生する直接費に対して間接費を計算して予定原価を算出し、実際発生原価と対比して原価の予実を管理している。
[1: Overview]
For example, in the industry that manufactures large machines, there are many companies that manage individual costs, and the indirect costs are calculated for the direct costs incurred to calculate the planned costs, and the actual costs are managed in comparison with the actual costs incurred. doing.

しかしながら、従来、予定原価の計算において、部門毎の一定比率であったため、会計システム側で手仕訳を行う必要があり、担当者の作業負担が大きかった。また、予定原価の精度が低いため、予実の差が大きく乖離していた。 However, in the past, in the calculation of the planned cost, since it was a fixed ratio for each department, it was necessary to make a manual journal entry on the accounting system side, and the work burden on the person in charge was heavy. In addition, because the accuracy of the planned cost was low, the difference between the forecast and the actual cost was large.

そこで、本実施の形態では、間接費を細分化して計上することで原価予実管理を高精度に行う。具体的には、直接費に対して、予めマスタ設定した間接費比率(例えば、製番分類、製番原価科目、及び製番管理部門毎に設定した間接費率)を掛けて、間接費の予定原価を計算し、計算した予定原価を会計システムと連携し、実際発生原価と対比して原価の予実管理を実現する。 Therefore, in the present embodiment, the cost forecast and actual management is performed with high accuracy by subdividing and recording the overhead costs. Specifically, the direct cost is multiplied by the indirect cost ratio set in advance as a master (for example, the production number classification, the production number cost item, and the indirect cost rate set for each production number management department) to obtain the indirect cost. Calculate the planned cost, link the calculated planned cost with the accounting system, and realize the forecast and actual management of the cost by comparing it with the actual incurred cost.

これにより、製番分類、製番管理部門、及び製番原価科目毎に間接費を計上し、予定原価と実際発生原価の予実管理をより高い精度で行うことが可能となる。また、手作業による間接費の計上が不要となり、担当者の負担を軽減することが可能となる。 As a result, indirect costs can be recorded for each production number classification, production number management department, and production number cost item, and it becomes possible to perform forecast and actual management of planned costs and actual costs incurred with higher accuracy. In addition, it is not necessary to manually record indirect costs, and it is possible to reduce the burden on the person in charge.

本発明は、例えば、個別原価管理を行う大型機械製造など個別受注製造の業界などにおいて有用である。 The present invention is useful in, for example, the industry of individual build-to-order manufacturing such as manufacturing of large machines for which individual cost control is performed.

[2.構成]
本実施形態に係る原価予実管理装置の構成の一例について、図1を参照して説明する。図1は、原価予実管理装置の構成の一例を示すブロック図である。
[2. composition]
An example of the configuration of the cost accounting and actual management device according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the cost accounting and actual management device.

原価予実管理装置100は、市販のデスクトップ型パーソナルコンピュータである。なお、原価予実管理装置100は、デスクトップ型パーソナルコンピュータのような据置型情報処理装置に限らず、市販されているノート型パーソナルコンピュータ、PDA(Personal Digital Assistants)、スマートフォン、タブレット型パーソナルコンピュータなどの携帯型情報処理装置であってもよい。 The cost accounting and actual management device 100 is a commercially available desktop personal computer. The cost forecast / actual management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a portable personal computer such as a commercially available notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, or a tablet personal computer. It may be a type information processing device.

原価予実管理装置100は、制御部102と通信インターフェース部104と記憶部106と入出力インターフェース部108と、を備えている。原価予実管理装置100が備えている各部は、任意の通信路を介して通信可能に接続されている。 The cost accounting and actual management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the cost accounting and actual management device 100 is communicably connected via an arbitrary communication path.

通信インターフェース部104は、ルータ等の通信装置及び専用線等の有線又は無線の通信回線を介して、原価予実管理装置100をネットワーク300に通信可能に接続する。通信インターフェース部104は、他の装置と通信回線を介してデータを通信する機能を有する。ここで、ネットワーク300は、原価予実管理装置100と、サーバ200や端末400・・・とを相互に通信可能に接続する機能を有し、例えばインターネットやLAN(Local Area Network)等である。端末400・・・は、経理担当者、購買担当者、及び製造担当者等が使用する端末装置である。経理担当者、購買担当者、及び製造担当者等は、端末400・・・を使用して、原価予実管理装置100とデータ通信を行うことができ、例えば、原価予実管理装置100にデータの入力(マスタの設定、仕入入力、出庫入力、作業実績入力、実際発生原価入力等)等が可能になっている。 The communication interface unit 104 connects the cost estimation / actual management device 100 to the network 300 so as to be communicable via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the cost accounting management device 100 and the server 200, the terminal 400, and the like so as to be able to communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). The terminal 400 ... Is a terminal device used by an accounting person, a purchasing person, a manufacturing person, and the like. The accounting staff, the purchasing staff, the manufacturing staff, and the like can perform data communication with the cost forecast / actual management device 100 by using the terminal 400 .... For example, data is input to the cost forecast / actual management device 100. (Master setting, purchase input, goods issue input, work record input, actual incurred cost input, etc.) are possible.

入出力インターフェース部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. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a home television). As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. In the following, the output device 114 may be referred to as a monitor 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112.

記憶部106には、各種のデータベース、テーブル、及びファイルなどが格納される。記憶部106には、OS(Operating System)と協働してCPU(Central Processing Unit)に命令を与えて各種処理を行うためのコンピュータプログラムが記録される。記憶部106として、例えば、RAM(Random Access Memory)・ROM(Read Only Memory)等のメモリ装置、ハードディスクのような固定ディスク装置、フレキシブルディスク、及び光ディスク等を用いることができる。 Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving an instruction to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used.

また、記憶部106は、間接費率マスタ106aと、製番分類マスタ106bと、データファイル106cとを備えている。 Further, the storage unit 106 includes an overhead rate master 106a, a serial number classification master 106b, and a data file 106c.

間接費率マスタ106aは、製番分類、製番管理部門、及び製番原価科目(直接費の種類)毎に、間接費の種類とその間接費率を設定するためのマスタであり、すなわち、間接費を細分化して設定するためのマスタである。間接費率マスタ106aは、製番分類、製番管理部門、対象の製番原価科目(直接費の種類)、製番原価科目(間接費の種類)、及び間接費率を関連づけて登録したテーブル等で構成されている(図2参照)。 The overhead rate master 106a is a master for setting the type of overhead cost and its overhead rate for each serial number classification, serial number management department, and serial number cost item (type of direct cost), that is, It is a master for subdividing and setting overhead costs. The indirect cost rate master 106a is a table in which the serial number classification, the serial number management department, the target serial number cost item (type of direct cost), the serial number cost item (type of overhead cost), and the indirect cost rate are registered in association with each other. Etc. (see FIG. 2).

製番分類マスタ106bは、製番を分類したマスタであり、例えば、試作製番、修理製番、経費製番、工事製番が登録されている(図2参照)。 The serial number classification master 106b is a master that classifies serial numbers, and for example, a trial production number, a repair serial number, an expense serial number, and a construction serial number are registered (see FIG. 2).

データファイル106cは、仕入入力データ、出庫入力データ、作業実績入力データ等の直接費データ(予定直接費)、間接費データ(予定間接費)、仕訳データ、原価差異額集計表等の各種データを格納するためのファイルである。 The data file 106c contains various data such as direct cost data (planned direct cost), indirect cost data (planned indirect cost), journal data, cost difference summary table, etc., such as purchase input data, issue input data, work record input data, etc. It is a file for storing.

制御部102は、原価予実管理装置100を統括的に制御するCPU等である。制御部102は、OS等の制御プログラム・各種の処理手順等を規定したプログラム・所要データなどを格納するための内部メモリを有し、格納されているこれらのプログラムに基づいて種々の情報処理を実行する。制御部102は、機能概念的に、マスタメンテ部102aと、仕入入力部102bと、出庫入力部102cと、作業実績入力部102dと、原価計算処理部102eと、仕訳連携処理部102fと、会計システム(原価差額集計部)102gと、を備えている。 The control unit 102 is a CPU or the like that comprehensively controls the cost accounting / actual management device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run. The control unit 102 is functionally conceptually composed of a master maintenance unit 102a, a purchase input unit 102b, a goods issue input unit 102c, a work record input unit 102d, a cost accounting processing unit 102e, a journal linkage processing unit 102f, and the like. It is equipped with an accounting system (cost difference totaling unit) of 102 g.

マスタメンテ部102aは、間接費率マスタ106a及び製番分類マスタ106bのデータの追加・削除・変更等の編集を行うためのものである。 The master maintenance unit 102a is for editing the data of the overhead rate master 106a and the serial number classification master 106b, such as addition / deletion / change.

仕入入力部102bは、データ種類「仕入」、製番、製番分類、製番原価科目、製番管理部門、及び原価を含む仕入入力データを入力してデータファイル106cに格納する。 The purchase input unit 102b inputs purchase input data including the data type "purchase", serial number, serial number classification, serial number cost item, serial number management department, and cost, and stores the purchase input data in the data file 106c.

出庫入力部102cは、データ種類「出庫」、製番、製番分類、製番原価科目、製番管理部門、及び原価を含む出庫入力データを入力してデータファイル106cに格納する。 The issuing input unit 102c inputs the issuing input data including the data type "delivery", the serial number, the serial number classification, the serial number cost item, the serial number management department, and the cost, and stores the data file 106c.

作業実績入力部102dは、データ種類「作業実績」、製番、製番分類、製番原価科目、製番管理部門、原価を含む作業実績入力データを入力してデータファイル106cに格納する。 The work record input unit 102d inputs the work record input data including the data type "work record", the serial number, the serial number classification, the serial number cost item, the serial number management department, and the cost, and stores it in the data file 106c.

仕入入力データ、出庫入力データ、及び作業実績入力データを総称して直接費データと称し、仕入入力部102b、出庫入力部102c、及び作業実績入力部102dは、直接費データを入力する入力手段を構成する。 The purchase input data, the goods issue input data, and the work record input data are collectively referred to as direct cost data, and the purchase input unit 102b, the goods issue input unit 102c, and the work record input unit 102d are inputs for directly inputting the cost data. Configure means.

原価計算処理部102eは、直接費データについて、製番分類、製番管理部門、製番原価科目毎に原価を集約(集計)し、集約した原価に、間接費率マスタ106aから製番分類、製番管理部門、及び製番原価科目をキーとして取得した間接費率を乗算して間接費データを算出して、データファイル106cに格納する。 The cost accounting processing unit 102e aggregates (aggregates) the costs for each of the serial number classification, the serial number management department, and the serial number cost item for the direct cost data, and classifies the direct cost data into the aggregated costs from the overhead rate master 106a. The overhead cost data is calculated by multiplying the overhead cost rate acquired by the serial number management department and the serial number cost item as a key, and stored in the data file 106c.

仕訳連携処理部102fは、会計システム(原価差額集計部)102gと連携して、直接費データ及び間接費データを含む予定原価データについて、所定分類の仕訳を作成して、データファイル106cに格納する。 The journal linkage processing unit 102f cooperates with the accounting system (cost difference totaling unit) 102g to create journals of a predetermined classification for planned cost data including direct cost data and indirect cost data, and stores them in the data file 106c. ..

会計システム(原価差額集計部)102gは、実際発生原価を取得し、予定原価データと取得した実際発生原価について、所定分類の原価差額集計表を作成して、データファイル106cに格納する。 The accounting system (cost difference totaling unit) 102g acquires the actual incurred costs, creates a cost difference totaling table of a predetermined category for the planned cost data and the acquired actual incurred costs, and stores them in the data file 106c.

製番分類は、製品製番、試作製番、修理製番、経費製番、及び工事製番を含んでいてもよい。製番管理部門は、製造部と設計部を含んでいてもよい。製番原価科目(直接費の種類)は、直接労務費、材料費、及び外注加工費を含んでいてもよい。製番原価科目(間接費の種類)は、間接労務費、間接経費、間接材料費を含んでいてもよい。所定分類は、製番管理部門、製番、及び製番分類を含んでいてもよい。 The serial number classification may include a product serial number, a trial production number, a repair serial number, an expense serial number, and a construction serial number. The production number management department may include a manufacturing department and a design department. The production number cost item (type of direct cost) may include direct labor cost, material cost, and outsourced processing cost. The production number cost item (type of overhead cost) may include indirect labor cost, indirect cost, and indirect material cost. The predetermined classification may include a production number management department, a production number, and a production number classification.

[3.具体例]
図1〜図4を参照して、本実施の形態における原価予実管理装置100の処理の具体例を説明する。まず、図2〜図4は、本実施の形態における原価予実管理装置100の制御部102の処理の具体例を説明するための図である。以下の説明では、金額の単位は全て「千円」とし、その表記を省略する。
[3. Concrete example]
A specific example of the processing of the cost forecast / actual management device 100 in the present embodiment will be described with reference to FIGS. 1 to 4. First, FIGS. 2 to 4 are diagrams for explaining a specific example of processing of the control unit 102 of the cost forecast / actual management device 100 in the present embodiment. In the following explanation, the unit of the amount of money is "thousand yen", and the notation is omitted.

(マスタメンテ処理)
図2において、マスタメンテ部102aは、マスタメンテ処理を実行する(ステップS1)。具体的には、マスタメンテ処理では、マスタメンテ部102aは、例えば、経理担当者の端末400のリクエストに応じて端末400にマスタメンテ画面を提供し、マスタメンテ画面上での経理担当者の端末400の操作等に応じて、間接費率マスタ106aや製番分類マスタ106bのデータの設定を行う。
(Master maintenance processing)
In FIG. 2, the master maintenance unit 102a executes the master maintenance process (step S1). Specifically, in the master maintenance process, the master maintenance unit 102a provides, for example, a master maintenance screen to the terminal 400 in response to a request from the terminal 400 of the accounting staff, and the terminal of the accounting staff on the master maintenance screen. The data of the indirect cost rate master 106a and the serial number classification master 106b are set according to the operation of 400 and the like.

図2(A)は、間接費率マスタ106aの登録例を示す図である。図2(A)に示す間接費率マスタ106aの例では、1行目は、製番分類「製品製番」、製番管理部門「製造部」、製番原価科目「間接労務費」、対象製番原価科目「直接労務費」、間接費率「2.0%」、2行目は、製番分類「製品製番」、製番管理部門「製造部」、製番原価科目「間接経費」、対象製番原価科目「材料費、外注加工費」、間接費率「3.0%」が登録されている。 FIG. 2A is a diagram showing a registration example of the overhead rate master 106a. In the example of the indirect cost rate master 106a shown in FIG. 2 (A), the first line is the serial number classification "product serial number", the serial number management department "manufacturing department", the serial number cost item "indirect labor cost", and the target. Production number cost item "Direct labor cost", indirect cost rate "2.0%", the second line is the production number classification "Product production number", production number management department "Manufacturing department", production number cost item "Indirect cost" , The target production number cost item "material cost, outsourced processing cost", and the indirect cost rate "3.0%" are registered.

3行目は、製番分類「試作製番」、製番管理部門「設計部」、製番原価科目「間接労務費」、対象製番原価科目「直接労務費」、間接費率「2.0%」、4行目は、製番分類「試作製番」、製番管理部門「設計部」、製番原価科目「間接経費」、対象製番原価科目「材料費、外注加工費」、間接費率「4.0%」が登録されている。 The third line is the serial number classification "prototype production number", the serial number management department "design department", the serial number cost item "indirect labor cost", the target serial number cost item "direct labor cost", and the indirect cost rate "2. "0%", the 4th line is the serial number classification "prototype production number", serial number management department "design department", serial number cost item "indirect cost", target serial number cost item "material cost, outsourced processing cost", The overhead rate "4.0%" is registered.

図2(B)は、製番分類マスタ106bの登録例を示す図である。図2(B)に示す製番分類マスタ106bの例では、試作製番、修理製番、経費製番、工事製番が登録されている。 FIG. 2B is a diagram showing a registration example of the serial number classification master 106b. In the example of the serial number classification master 106b shown in FIG. 2B, the trial production number, the repair serial number, the expense serial number, and the construction serial number are registered.

(直接費データ入力処理(仕入入力処理、出庫入力処理、作業実績入力処理)
図3において、仕入入力部102bは、仕入入力処理を実行する(ステップS2)。具体的には、仕入入力処理では、例えば、仕入入力部102bは、購買担当者の端末400のリクエストに応じて端末400に仕入入力画面を提供し、仕入入力画面上での購買担当者の端末400の操作等に応じて、仕入入力データを入力してデータファイル106cに格納する。
(Direct cost data input processing (purchasing input processing, shipping input processing, work record input processing)
In FIG. 3, the purchase input unit 102b executes the purchase input process (step S2). Specifically, in the purchase input process, for example, the purchase input unit 102b provides the terminal 400 with a purchase input screen in response to a request from the purchaser's terminal 400, and purchases on the purchase input screen. Purchase input data is input and stored in the data file 106c according to the operation of the terminal 400 of the person in charge.

出庫入力部102cは、出庫入力処理を実行する(ステップS3)。具体的には、出庫入力処理では、出庫入力部102cは、例えば、購買担当者の端末400のリクエストに応じて端末400に出荷入力画面を提供し、出荷入力画面上での購買担当者の端末400の操作等に応じて、出庫入力データを入力してデータファイル106cに格納する。 The issue input unit 102c executes the issue input process (step S3). Specifically, in the issue input process, the issue input unit 102c provides the terminal 400 with a shipment input screen in response to a request from the purchaser's terminal 400, for example, and the purchaser's terminal on the shipment input screen. In response to the operation of 400 or the like, the delivery input data is input and stored in the data file 106c.

作業実績入力部102dは、作業実績入力処理を実行する(ステップS4)。具体的には、作業実績入力処理では、作業実績入力部102dは、例えば、製造担当者の端末400のリクエストに応じて端末400に製造実績入力画面を提供し、製造実績入力画面上での製造担当者の端末400の操作等に応じて、作業実績入力データを入力してデータファイル106cに格納する。 The work result input unit 102d executes the work result input process (step S4). Specifically, in the work record input process, the work record input unit 102d provides, for example, a manufacturing record input screen to the terminal 400 in response to a request from the terminal 400 of the person in charge of manufacturing, and manufactures on the manufacturing record input screen. According to the operation of the terminal 400 of the person in charge, the work result input data is input and stored in the data file 106c.

図3(A)は、各入力処理より計上される直接費データ(原価明細)の一例を示す図である。図3(A)において、1行目は、データ種類「仕入」、製番「F1010095」、製番分類「製品製番」、製番原価科目「材料費」、製番管理部門「製造部」、原価「1,000」、2行目は、データ種類「仕入」、製番「F9010002」、製番分類「試作製番」、製番原価科目「外注加工費」、製番管理部門「設計部」、原価「1,500」、3行目は、データ種類「仕入」、製番「F9010002」、製番分類「試作製番」、製番原価科目「材料費」、製番管理部門「設計部」、原価「2,000」、4行目は、データ種類「出庫」、製番「F1010095」、製番分類「製品製番」、製番原価科目「材料費」製番管理部門「製造部」、原価「1,000」となっている。 FIG. 3A is a diagram showing an example of direct cost data (cost details) recorded from each input process. In FIG. 3 (A), the first line shows the data type "purchase", the serial number "F1010095", the serial number classification "product serial number", the serial number cost item "material cost", and the serial number management department "manufacturing department". , Cost "1,000", the second line is the data type "purchase", serial number "F901002", serial number classification "trial production number", serial number cost item "outsourced processing cost", serial number management department "Design department", cost "1,500", 3rd line is data type "purchase", serial number "F901002", serial number classification "trial production number", serial number cost item "material cost", serial number Management department "design department", cost "2,000", 4th line is data type "delivery", serial number "F101095", serial number classification "product serial number", serial number cost item "material cost" serial number The management department is "Manufacturing Department" and the cost is "1,000".

5行目は、データ種類「出庫」、製番「F9010002」、製番分類「試作製番」、製番原価科目「材料費」、製番管理部門「設計部」、原価「1,000」、6行目は、データ種類「出庫」、製番「F9010002」、製番分類「試作製番」、製番原価科目「材料費」、製番管理部門「設計部」、原価「1,500」、7行目は、データ種類「作業実績」、製番「F9010002」、製番分類「試作製番」、製番原価科目「直接労務費」、製番管理部門「設計部」、原価「5,000」となっている。 The fifth line is the data type "delivery", serial number "F901002", serial number classification "prototype production number", serial number cost item "material cost", serial number management department "design department", cost "1,000". , 6th line is data type "delivery", serial number "F901002", serial number classification "prototype production number", serial number cost item "material cost", serial number management department "design department", cost "1,500" , 7th line, data type "work record", serial number "F901002", serial number classification "prototype production number", serial number cost item "direct labor cost", serial number management department "design department", cost " It is "5,000".

(原価計算処理)
原価計算処理部102eは、原価計算処理を実行する(ステップS5)。具体的には、原価計算処理では、原価計算処理部102eは、直接費データ(仕入入力データ、出庫入力データ、作業実績入力データ)について、製番、製番分類、製番管理部門、及び製番原価科目(直接費の種類)毎に原価を集計し、製番分類、製番管理部門、及び製番原価科目(直接費の種類)をキーとして間接費率マスタ106aから間接費率を取得して直接費の原価に乗算することで、間接費を算出する。
(Cost accounting)
The cost accounting processing unit 102e executes the cost accounting processing (step S5). Specifically, in the cost accounting process, the cost accounting processing unit 102e uses the serial number, serial number classification, serial number management department, and the serial number management department for the direct cost data (purchase input data, goods issue input data, work record input data). The costs are totaled for each production number cost item (type of direct cost), and the indirect cost rate is calculated from the overhead rate master 106a using the production number classification, production number management department, and production number cost item (type of direct cost) as keys. Overhead costs are calculated by acquiring and multiplying the costs of direct costs.

図3(B)は、原価計算過程を示しており、直接費の原価に間接費率を乗算したものを示している。図3(B)において、1行目は、図3(A)の1行目と4行目を集計し、製番分類「製品製番」、製番原価科目「材料費」、製番管理部門「製造部」をキーとして、図2(A)の間接費率マスタ106aから間接費率「3.0%」を取得し、製番「F1010095」、製番分類「製品製番」、製番原価科目「材料費」、製番管理部門「製造部」、原価「2,000」×間接費率「3.0%」となっている。 FIG. 3B shows the costing process, which is the cost of direct costs multiplied by the overhead rate. In FIG. 3 (B), the first line aggregates the first and fourth lines of FIG. 3 (A), and the serial number classification "product serial number", serial number cost item "material cost", serial number management. Obtaining the overhead rate "3.0%" from the overhead rate master 106a in Fig. 2 (A) with the department "Manufacturing Department" as the key, the serial number "F101095", the serial number classification "product serial number", and the manufacturing The cost item "material cost", the production number management department "manufacturing department", the cost "2,000" x the indirect cost rate "3.0%".

2行目は、図3(A)の2行目に対応しており、製番分類「試作製番」、製番原価科目「外注加工費」、製番管理部門「設計部」をキーとして、図2(A)の0間接費率マスタ106aから間接費率「4.0%」を取得し、製番「F9010002」、製番分類「試作製番」、製番原価科目「外注加工費」、製番管理部門「設計部」、原価「1,500」×間接費率「4.0%」となっている。 The second line corresponds to the second line in Fig. 3 (A), with the serial number classification "trial production number", the serial number cost item "overhead processing cost", and the serial number management department "design department" as keys. , Obtain the overhead rate "4.0%" from the 0 overhead rate master 106a in Fig. 2 (A), the serial number "F901002", the serial number classification "prototype production number", and the serial number cost item "outsourced processing cost". , The production number management department "Design Department", cost price "1,500" x overhead rate "4.0%".

3行目は、図3(A)の3行目、5行目、6行目を集計し、製番分類「試作製番」、製番原価科目「材料費」、製番管理部門「設計部」をキーとして、図2(A)の間接費率マスタ106aから間接費率「4.0%」を取得し、製番「F9010002」、製番分類「試作製番」、製番原価科目「材料費」、製番管理部門「設計部」、原価「4,500」×間接費率「4.0%」となっている。 The 3rd line aggregates the 3rd, 5th, and 6th lines of Fig. 3 (A), and the serial number classification "trial production number", serial number cost item "material cost", and serial number management department "design". Obtaining the overhead rate "4.0%" from the overhead rate master 106a in FIG. 2 (A) with the "part" as the key, the serial number "F901002", the serial number classification "prototype production number", and the serial number cost item. "Material cost", production number management department "design department", cost "4,500" x indirect cost rate "4.0%".

4行目は、図3(A)の7行目に対応しており、製番分類「試作製番」、製番原価科目「直接労務費」、製番管理部門「設計部」をキーとして、図2(A)の間接費率マスタ106aから間接費率「2.0%」を取得し、製番「F9010002」、製番分類「試作製番」、製番原価科目「直接労務費」、製番管理部門「設計部」、原価「5,000」×間接費率「2.0%」となっている。 The 4th line corresponds to the 7th line in Fig. 3 (A), with the serial number classification "trial production number", serial number cost item "direct labor cost", and serial number management department "design department" as keys. , Obtain the overhead rate "2.0%" from the overhead rate master 106a in Fig. 2 (A), serial number "F901002", serial number classification "prototype production number", serial number cost item "direct labor cost" , Production number management department "design department", cost "5,000" x overhead rate "2.0%".

図4(C)は、間接費の原価計算結果を示しており、間接費率マスタ106aを参照して、製番及び製番原価科目(間接費の種類)毎に、間接費を集計した結果を示している。1行目は、製番「F1010095」、製番原価科目「間接経費」、製造間接費「60」、2行目は、製番「F9010002」、製番原価科目「間接経費」、製造間接費「240」、3行目は、製番「F9010002」、製番原価科目「間接労務費」、製造間接費「100」となっている。 FIG. 4C shows the cost calculation result of the indirect cost, and the result of totaling the indirect cost for each production number and the production number cost item (type of indirect cost) with reference to the indirect cost rate master 106a. Is shown. The first line is the serial number "F1010095", the serial number cost item "indirect cost", the manufacturing overhead cost "60", and the second line is the serial number "F901002", the serial number cost item "indirect cost", the manufacturing overhead cost. "240", the third line is the serial number "F901002", the serial number cost item "indirect labor cost", and the manufacturing overhead cost "100".

図4(D)は、図3(A)と図4(C)を纏めたもので、製番毎の直接費と間接費の内訳を示している。 FIG. 4 (D) summarizes FIGS. 3 (A) and 4 (C), and shows the breakdown of direct costs and indirect costs for each production number.

(仕訳連携処理)
仕訳連携処理部102fは、仕訳連携処理を実行する(ステップS6)。具体的には、仕訳連携処理では、仕訳連携処理部102fは、会計システム(原価差額集計部)102gと連携して、予定原価データ(直接費データと間接費データ)について、所定分類(例えば、部門毎)の仕訳を作成して、データファイル106cに格納する。
(Journal linkage processing)
The journal linkage processing unit 102f executes the journal linkage processing (step S6). Specifically, in the journal linkage processing, the journal linkage processing unit 102f cooperates with the accounting system (cost difference totaling unit) 102g to classify the planned cost data (direct cost data and indirect cost data) into predetermined categories (for example,). Create a journal for each department) and store it in the data file 106c.

図4(E)は、製造部と設計部の仕訳の例を示している。製造部については、材料費「2,000」/仮勘定(直接材料費予定額)「2,000」、外注加工費「0」/仮勘定(直接経費予定額)「0」、間接経費「60」/仮勘定(間接経費予定額)「60」、直接労務費「0」/仮勘定(直接労務費予定額)「0」、間接労務費「0」/仮勘定(間接労務費予定額)「0」となっている。 FIG. 4 (E) shows an example of journal entries in the manufacturing department and the design department. For the manufacturing department, material cost "2,000" / temporary account (planned direct material cost) "2,000", outsourced processing cost "0" / temporary account (planned direct cost) "0", indirect cost " 60 "/ Temporary account (planned indirect cost)" 60 ", Direct labor cost" 0 "/ Temporary account (planned direct labor cost)" 0 ", Indirect labor cost" 0 "/ Temporary account (planned indirect labor cost) ) It is "0".

設計部については、材料費「4,500」/仮勘定(直接材料費予定額)「4,500」、外注加工費「1,500」/仮勘定(直接経費予定額)「1,500」、間接経費「240」/仮勘定(間接経費予定額)「240」、直接労務費「5,000」/仮勘定(直接労務費予定額)「5,000」、間接労務費「100」/仮勘定(間接労務費予定額)「100」となっている。 For the design department, material cost "4,500" / temporary account (planned direct material cost) "4,500", outsourced processing cost "1,500" / temporary account (planned direct cost) "1,500" , Indirect cost "240" / Temporary account (planned indirect cost) "240", Direct labor cost "5,000" / Temporary account (planned direct labor cost) "5,000", Indirect labor cost "100" / The suspense account (planned indirect labor cost) is "100".

(原価差額集計処理)
会計システム(原価差額集計部)102gは、原価差額集計処理を実行する(ステップS7)。具体的には、原価差額集計処理では、会計システム(原価差額集計部)102gは、実際発生原価(例えば、材料費実際発生額、労務費実際発生額、経費実際発生額)を取得し、予定原価と実際発生原価に基づいて、所定分類毎(例えば、部門毎)の原価差額集計表を作成して、データファイル106cに格納する。なお、会計システム(原価差額集計部)102gでは、例えば、経理担当者の端末400のリクエストに応じて端末400に実際発生原価入力画面を提供し、実際発生原価入力画面上での経理担当者の端末400の操作等に応じて、実際発生原価を入力してもよい。
(Cost difference total processing)
The accounting system (cost difference totaling unit) 102g executes the cost difference totaling process (step S7). Specifically, in the cost difference totaling process, the accounting system (cost difference totaling unit) 102g acquires the actual costs incurred (for example, the actual amount of material costs incurred, the actual amount of labor costs incurred, and the actual amount of expenses incurred). Based on the cost and the actual cost incurred, a cost difference summary table for each predetermined category (for example, for each department) is created and stored in the data file 106c. In addition, in the accounting system (cost difference totaling unit) 102g, for example, the actual incurred cost input screen is provided to the terminal 400 in response to the request of the terminal 400 of the accounting person, and the accounting person in charge on the actually incurred cost input screen. The actual cost incurred may be input according to the operation of the terminal 400 or the like.

図4(F)は、部門別の原価差額集計表の一例を示す図である。材料費原価差異=材料費実際発生額−(直接材料費予定額+間接材料費予定額)、労務費原価差異=労務費実際発生額−(直接労務費予定額+間接労務費予定額)、経費原価差異=経費実際発生額−(直接経費予定額+間接経費予定額)で算出することができる。 FIG. 4F is a diagram showing an example of a cost difference summary table for each department. Material cost difference = actual material cost incurred- (planned direct material cost + planned indirect material cost), labor cost difference = actual labor cost incurred- (planned direct labor cost + planned indirect labor cost), Expense cost difference = actual expense incurred- (planned direct expense + planned indirect expense).

製番管理部門「製造部」については、材料費実際発生額「2,000」、直接材料費予定額「2,000」、間接材料費予定額「0」、材料費原価差異「0」、労務費実際発生額「0」、直接労務費予定額「0」、間接労務費予定額「0」、労務費原価差異「0」、経費実際発生額「50」、直接経費予定額「0」、間接経費予定額「60」、経費原価差異「−10」となっている。 For the production number management department "Manufacturing Department", the actual material cost actual amount "2,000", the direct material cost planned amount "2,000", the indirect material cost planned amount "0", the material cost cost difference "0", Actual labor cost incurred amount "0", direct labor cost planned amount "0", indirect labor cost planned amount "0", labor cost cost difference "0", actual cost incurred amount "50", direct cost planned amount "0" , The planned indirect cost amount is "60", and the cost cost difference is "-10".

製番管理部門「設計部」については、材料費実際発生額「4,600」、直接材料費予定額「4,500」、間接材料費予定額「0」、材料費原価差異「100」、労務費実際発生額「5,000」、直接労務費予定額「5,000」、間接労務費予定額「100」、労務費原価差異「−100」、経費実際発生額「1,740」、直接経費予定額「1,500」、間接経費予定額「240」、経費原価差異「0」となっている。なお、ここでは、部門別で集計しているが、製番別や製番分類別に集計してもよい。 For the production number management department "Design Department", the actual material cost actual amount "4,600", the direct material cost planned amount "4,500", the indirect material cost planned amount "0", the material cost cost difference "100", Actual labor cost "5,000", planned direct labor cost "5,000", planned indirect labor cost "100", labor cost difference "-100", actual cost difference "1,740", The planned direct cost amount is "1,500", the planned indirect cost amount is "240", and the cost difference is "0". In addition, although the total is calculated by department here, it may be totaled by product number or by product number classification.

以上説明したように、本実施の形態によれば、製番分類、製番管理部門、及び製番原価科目毎に、間接費率を設定した間接費率マスタ106aと、各種データについて、製番、製番分類、製番管理部門、製番原価科目、及び原価を含む直接費データを入力する入力手段(仕入入力部102b、出庫入力部102c、作業実績入力部102d)と、前記直接費データについて、製番分類、製番管理部門、製番原価科目毎に原価を集約し、集約した原価に、間接費率マスタ106aから製番分類、製番管理部門、及び製番原価科目をキーとして取得した間接費率を乗算して間接費データを算出する原価計算処理部102eと、前記直接費データ及び前記間接費データを含む予定原価データについて、所定分類の仕訳を作成する仕訳連携処理部102fと、実際発生原価を取得し、前記予定原価データと取得した実際発生原価について、前記所定分類の原価差額集計表を作成する会計システム(原価差額集計部)102gと、を備えているので、間接費を細分化して計上することで原価予実管理を高精度に行うことが可能となる。 As described above, according to the present embodiment, the indirect cost rate master 106a in which the indirect cost rate is set for each serial number classification, serial number management department, and serial number cost item, and various data are serialized. , Production number classification, production number management department, production number cost item, and input means for inputting direct cost data including cost (purchase input unit 102b, goods issue input unit 102c, work record input unit 102d), and the direct cost. For data, the costs are aggregated for each serial number classification, serial number management department, and serial number cost item, and the serial number classification, serial number management department, and serial number cost item are keyed from the indirect cost rate master 106a to the aggregated costs. The cost calculation processing unit 102e that calculates the indirect cost data by multiplying the indirect cost rate acquired as Since it is equipped with 102f and an accounting system (cost difference totaling unit) 102g that acquires the actual incurred cost and creates the cost difference totaling table of the predetermined classification for the planned cost data and the acquired actual incurred cost. By subdividing and recording indirect costs, it is possible to perform cost forecasting and actual management with high accuracy.

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

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

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

また、原価予実管理装置100に関して、図示の各構成要素は機能概念的なものであり、必ずしも物理的に図示の如く構成されていることを要しない。 Further, with respect to the cost accounting and actual management device 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

例えば、原価予実管理装置100が備える処理機能、特に制御部にて行われる各処理機能については、その全部または任意の一部を、CPUおよび当該CPUにて解釈実行されるプログラムにて実現してもよく、また、ワイヤードロジックによるハードウェアとして実現してもよい。尚、プログラムは、本実施形態で説明した処理を情報処理装置に実行させるためのプログラム化された命令を含む一時的でないコンピュータ読み取り可能な記録媒体に記録されており、必要に応じて原価予実管理装置100に機械的に読み取られる。すなわち、ROMまたはHDD(Hard Disk Drive)などの記憶部などには、OSと協働してCPUに命令を与え、各種処理を行うためのコンピュータプログラムが記録されている。このコンピュータプログラムは、RAMにロードされることによって実行され、CPUと協働して制御部を構成する。 For example, with respect to the processing functions included in the cost accounting and actual management device 100, particularly each processing function performed by the control unit, all or any part thereof is realized by the CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the process described in the present embodiment, and cost estimation and actual management is performed as necessary. It is read mechanically by the 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 an HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with a CPU to form a control unit.

また、このコンピュータプログラムは、原価予実管理装置100に対して任意のネットワークを介して接続されたアプリケーションプログラムサーバに記憶されていてもよく、必要に応じてその全部または一部をダウンロードすることも可能である。 Further, this computer program may be stored in an application program server connected to the cost accounting management device 100 via an arbitrary network, and all or a part thereof can be downloaded as needed. Is.

また、本実施形態で説明した処理を実行するためのプログラムを、一時的でないコンピュータ読み取り可能な記録媒体に格納してもよく、また、プログラム製品として構成することもできる。ここで、この「記録媒体」とは、メモリーカード、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 process 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" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPROM (registration). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disk), MO (Magnet-Optical Disk), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

また、「プログラム」とは、任意の言語または記述方法にて記述されたデータ処理方法であり、ソースコードまたはバイナリコード等の形式を問わない。なお、「プログラム」は必ずしも単一的に構成されるものに限られず、複数のモジュールやライブラリとして分散構成されるものや、OSに代表される別個のプログラムと協働してその機能を達成するものをも含む。なお、実施形態に示した各装置において記録媒体を読み取るための具体的な構成および読み取り手順ならびに読み取り後のインストール手順等については、周知の構成や手順を用いることができる。 The "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as a plurality of modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. A well-known configuration or procedure can be used for 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.

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

また、原価予実管理装置100は、既知のパーソナルコンピュータまたはワークステーション等の情報処理装置として構成してもよく、また、任意の周辺装置が接続された当該情報処理装置として構成してもよい。また、原価予実管理装置100は、当該装置に本実施形態で説明した処理を実現させるソフトウェア(プログラムまたはデータ等を含む)を実装することにより実現してもよい。 Further, the cost forecast / actual management device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the cost accounting and actual management device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the device.

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

100 原価予実管理装置
102 制御部
102a マスタメンテ部
102b 仕入入力部
102c 出庫入力部
102d 作業実績入力部
102e 原価計算処理部
102f 仕訳連携処理部
102g 会計システム(原価差額集計部)
104 通信インターフェース部
106 記憶部
106a 間接費率マスタ
106b 製番分類マスタ
106c データファイル
108 入出力インターフェース部
112 入力装置
114 出力装置
200 サーバ
300 ネットワーク
400 端末
100 Cost forecast and actual management device 102 Control unit 102a Master maintenance unit 102b Purchase input unit 102c Goods issue input unit 102d Work record input unit 102e Cost calculation processing unit 102f Journal linkage processing unit 102g Accounting system (cost difference totaling unit)
104 Communication interface unit 106 Storage unit 106a Overhead cost rate master 106b Serial number classification master 106c Data file 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network 400 Terminal

Claims (8)

記憶部及び制御部を備えた原価予実管理装置であって、
前記記憶部には、
製番分類、製番管理部門、及び製番原価科目毎に、間接費率を設定したマスタが格納されており、
前記制御部は、
各種データについて、製番、製番分類、製番管理部門、製番原価科目、及び原価を含む直接費データを入力する入力手段と、
前記直接費データを製番分類、製番管理部門、製番原価科目毎に原価を集約し、集約した原価に、前記マスタから製番分類、製番管理部門、及び製番原価科目をキーとして取得した間接費率を乗算して間接費データを算出する原価計算処理手段と、
前記直接費データ及び前記間接費データを含む予定原価データについて、所定分類の仕訳を作成する仕訳作成手段と、
実際発生原価を取得し、前記予定原価データと取得した実際発生原価について、前記所定分類の原価差額集計表を作成する原価差額集計手段と、
を備えたことを特徴とする原価予実管理装置。
It is a cost accounting and actual management device equipped with a storage unit and a control unit.
In the storage unit
A master that sets the overhead rate is stored for each serial number classification, serial number management department, and serial number cost item.
The control unit
For various data, input means for inputting direct cost data including serial number, serial number classification, serial number management department, serial number cost item, and cost,
The direct cost data is aggregated for each serial number classification, serial number management department, and serial number cost item, and the aggregated cost is based on the serial number classification, serial number management department, and serial number cost item from the master. A cost accounting method that calculates indirect cost data by multiplying the acquired overhead rate,
Journal creation means for creating journals of a predetermined classification for the planned cost data including the direct cost data and the indirect cost data, and
A cost difference totaling means for acquiring the actual incurred cost and creating a cost difference totaling table of the predetermined classification for the planned cost data and the acquired actual incurred cost.
A cost accounting and actual management device characterized by being equipped with.
前記製番分類は、製品製番、試作製番、修理製番、経費製番、及び工事製番を含むことを特徴とする請求項1に記載の原価予実管理装置。 The cost accounting and actual management device according to claim 1, wherein the production number classification includes a product production number, a trial production number, a repair production number, an expense production number, and a construction production number. 製番管理部門は、製造部と設計部を含むことを特徴とする請求項1又は2に記載の原価予実管理装置。 The cost accounting management device according to claim 1 or 2, wherein the production number management department includes a manufacturing department and a design department. 前記製番原価科目は、直接労務費、材料費、及び外注加工費を含むことを特徴とする請求項1〜3のいずれか1つに記載の原価予実管理装置。 The cost forecasting and actual management device according to any one of claims 1 to 3, wherein the production number cost item includes a direct labor cost, a material cost, and an outsourced processing cost. 前記所定分類は、製番管理部門、製番、及び製番分類を含むことを特徴とする請求項1〜4のいずれか1つに記載の原価予実管理装置。 The cost accounting and actual management device according to any one of claims 1 to 4, wherein the predetermined classification includes a production number management department, a production number, and a production number classification. 前記各種データは、仕入、出庫、及び作業実績のデータを含むことを特徴とする請求項1〜5のいずれか1つに記載の原価予実管理装置。 The cost accounting management device according to any one of claims 1 to 5, wherein the various data includes data of purchase, delivery, and work performance. 記憶部及び制御部を備えた情報処理装置で実行される原価予実管理方法であって、
前記記憶部には、
製番分類、製番管理部門、及び製番原価科目毎に、間接費率を設定したマスタが格納されており、
前記制御部において実行される、
各種データについて、製番、製番分類、製番管理部門、製番原価科目、及び原価を含む直接費データを入力する入力工程と、
前記直接費データを製番分類、製番管理部門、製番原価科目毎に原価を集約し、集約した原価に、前記マスタから製番分類、製番管理部門、及び製番原価科目をキーとして取得した間接費率を乗算して間接費データを算出する原価計算処理工程と、
前記直接費データ及び前記間接費データを含む予定原価データについて、所定分類の仕訳を作成する仕訳作成工程と、
実際発生原価を取得し、前記予定原価データと取得した実際発生原価について、前記所定分類の原価差額集計表を作成する原価差額集計工程と、
を含むことを特徴とする原価予実管理方法。
It is a cost accounting management method executed by an information processing device equipped with a storage unit and a control unit.
In the storage unit
A master that sets the overhead rate is stored for each serial number classification, serial number management department, and serial number cost item.
Executed in the control unit,
For various data, input process for inputting direct cost data including serial number, serial number classification, serial number management department, serial number cost item, and cost,
The direct cost data is aggregated for each serial number classification, serial number management department, and serial number cost item, and the aggregated cost is based on the serial number classification, serial number management department, and serial number cost item from the master. A cost accounting process that calculates indirect cost data by multiplying the acquired overhead rate,
A journal creation process for creating journals of a predetermined classification for the planned cost data including the direct cost data and the indirect cost data, and
A cost difference totaling process that acquires the actual incurred costs and creates the cost difference totaling table of the predetermined classification for the planned cost data and the acquired actual incurred costs.
A cost accounting management method characterized by including.
制御部及び記憶部を備えた情報処理装置に実行させるための原価予実管理プログラムであって、
前記記憶部には、
製番分類、製番管理部門、及び製番原価科目毎に、間接費率を設定したマスタが格納されており、
前記制御部において、
各種データについて、製番、製番分類、製番管理部門、製番原価科目、及び原価を含む直接費データを入力する入力工程と、
前記直接費データを製番分類、製番管理部門、製番原価科目毎に原価を集約し、集約した原価に、前記マスタから製番分類、製番管理部門、及び製番原価科目をキーとして取得した間接費率を乗算して間接費データを算出する原価計算処理工程と、
前記直接費データ及び前記間接費データを含む予定原価データについて、所定分類の仕訳を作成する仕訳作成工程と、
実際発生原価を取得し、前記予定原価データと取得した実際発生原価について、前記所定分類の原価差額集計表を作成する原価差額集計工程と、
を実行するための原価予実管理プログラム。
It is a cost accounting management program to be executed by an information processing device equipped with a control unit and a storage unit.
In the storage unit
A master that sets the overhead rate is stored for each serial number classification, serial number management department, and serial number cost item.
In the control unit
For various data, input process for inputting direct cost data including serial number, serial number classification, serial number management department, serial number cost item, and cost,
The direct cost data is aggregated for each serial number classification, serial number management department, and serial number cost item, and the aggregated cost is based on the serial number classification, serial number management department, and serial number cost item from the master. A cost accounting process that calculates indirect cost data by multiplying the acquired overhead rate,
A journal creation process for creating journals of a predetermined classification for the planned cost data including the direct cost data and the indirect cost data, and
A cost difference totaling process that acquires the actual incurred costs and creates the cost difference totaling table of the predetermined classification for the planned cost data and the acquired actual incurred costs.
Cost accounting and actual management program for executing.
JP2020173587A 2020-03-17 2020-10-14 Cost budget and actual management device, cost budget and actual management method, and cost budget and actual management program Active JP7404215B2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
JP2023208907A JP2024015351A (en) 2020-03-17 2023-12-12 Cost budget/actual management device, cost budget/actual management method, and cost budget/actual management program

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
JP2020046420 2020-03-17
JP2020046420 2020-03-17

Related Child Applications (1)

Application Number Title Priority Date Filing Date
JP2023208907A Division JP2024015351A (en) 2020-03-17 2023-12-12 Cost budget/actual management device, cost budget/actual management method, and cost budget/actual management program

Publications (2)

Publication Number Publication Date
JP2021149926A true JP2021149926A (en) 2021-09-27
JP7404215B2 JP7404215B2 (en) 2023-12-25

Family

ID=77849170

Family Applications (2)

Application Number Title Priority Date Filing Date
JP2020173587A Active JP7404215B2 (en) 2020-03-17 2020-10-14 Cost budget and actual management device, cost budget and actual management method, and cost budget and actual management program
JP2023208907A Pending JP2024015351A (en) 2020-03-17 2023-12-12 Cost budget/actual management device, cost budget/actual management method, and cost budget/actual management program

Family Applications After (1)

Application Number Title Priority Date Filing Date
JP2023208907A Pending JP2024015351A (en) 2020-03-17 2023-12-12 Cost budget/actual management device, cost budget/actual management method, and cost budget/actual management program

Country Status (1)

Country Link
JP (2) JP7404215B2 (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP7296510B1 (en) 2022-07-27 2023-06-22 株式会社オービック Business support device, business support method, and business support program
JP7507932B2 (en) 2023-05-29 2024-06-28 株式会社オービック Business support device, business support method, and business support program

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2004213236A (en) 2002-12-27 2004-07-29 Hitachi Ltd Cost accounting method in medical institution, business form of cost accounting result, cost accounting program, and output method of business form
JP2004258717A (en) 2003-02-24 2004-09-16 Toyo Business Engineering Corp Cost management system and method
JP6881930B2 (en) 2015-11-05 2021-06-02 株式会社オービック Project accounting management device, project accounting management method, and project accounting management program

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP7296510B1 (en) 2022-07-27 2023-06-22 株式会社オービック Business support device, business support method, and business support program
JP2024017370A (en) * 2022-07-27 2024-02-08 株式会社オービック Business support device, business support method and business support program
JP7507932B2 (en) 2023-05-29 2024-06-28 株式会社オービック Business support device, business support method, and business support program

Also Published As

Publication number Publication date
JP7404215B2 (en) 2023-12-25
JP2024015351A (en) 2024-02-01

Similar Documents

Publication Publication Date Title
JP2024015351A (en) Cost budget/actual management device, cost budget/actual management method, and cost budget/actual management program
JP7085304B2 (en) Cost calculator, cost calculation method and cost calculation program
JP7046153B2 (en) Work completion control device, work completion control method, and work completion control program
JP6798856B2 (en) Amount calculation device, amount calculation method and amount calculation program
JP7197989B2 (en) Progress rate calculation device, progress rate calculation method, and progress rate calculation program
JP7011470B2 (en) Work-in-process automatic transfer device, work-in-process automatic transfer method, and work-in-process automatic transfer program
JP7025854B2 (en) Gross profit calculator, gross profit calculation method and gross profit calculation program
JP2020194397A (en) Journal approval work support device, journal approval work support method and journal approval work support program
JP7093267B2 (en) Data generator, data generation method and data generation program
JP2021051475A (en) Information generation apparatus, information generation program, and information generation method
JP6853705B2 (en) Usage content management device, usage content management method, and usage content management program
JP7104817B2 (en) Voucher registration control device, voucher registration control method, and voucher registration control program
JP2018112988A (en) Journaling preparation device, journaling preparation method, and journaling preparation program
JP7361162B2 (en) Unit price calculation device, unit price calculation method, and unit price calculation program
JP7194063B2 (en) Journal writing device, journal writing method and journal writing program
JP7075289B2 (en) Journal creation device, journal creation method and journal creation program
JP2021144692A (en) Sales recording apparatus, sales recording method and sales recording program
JP2021157777A (en) Article journal generation device, article journal generation method, and article journal generation program
JP2021144344A (en) Cost output device, cost output method, and cost output program
JP6947507B2 (en) Profit management equipment, profit management methods, and profit management programs
JP2021149914A (en) Forecast/actual management device, forecast/actual management method and forecast/actual management program
JP2022059934A (en) Productivity index calculation device, productivity index calculation method, and productivity index calculation program
JP2020160964A (en) Data generation device, data generation program, and data generation method
JP2021144690A (en) Business support device, business support method and business support program
JP2020166538A (en) Cost accounting device for each base material, cost accounting method for each base material, and cost accounting program for each base material

Legal Events

Date Code Title Description
A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20221215

A977 Report on retrieval

Free format text: JAPANESE INTERMEDIATE CODE: A971007

Effective date: 20231006

TRDD Decision of grant or rejection written
A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

Effective date: 20231114

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20231213

R150 Certificate of patent or registration of utility model

Ref document number: 7404215

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150