Deprecated: The each() function is deprecated. This message will be suppressed on further calls in /home/zhenxiangba/zhenxiangba.com/public_html/phproxy-improved-master/index.php on line 456
JP7602000B2 - Cost accounting device, cost accounting method, and cost accounting program - Google Patents
[go: Go Back, main page]

JP7602000B2 - Cost accounting device, cost accounting method, and cost accounting program - Google Patents

Cost accounting device, cost accounting method, and cost accounting program Download PDF

Info

Publication number
JP7602000B2
JP7602000B2 JP2023218805A JP2023218805A JP7602000B2 JP 7602000 B2 JP7602000 B2 JP 7602000B2 JP 2023218805 A JP2023218805 A JP 2023218805A JP 2023218805 A JP2023218805 A JP 2023218805A JP 7602000 B2 JP7602000 B2 JP 7602000B2
Authority
JP
Japan
Prior art keywords
inventory
month
data
current month
amount
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.)
Active
Application number
JP2023218805A
Other languages
Japanese (ja)
Other versions
JP2024023902A (en
Inventor
大介 伊藤
敦史 志水
剛光 上野
Original Assignee
株式会社オービック
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 株式会社オービック filed Critical 株式会社オービック
Publication of JP2024023902A publication Critical patent/JP2024023902A/en
Application granted granted Critical
Publication of JP7602000B2 publication Critical patent/JP7602000B2/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)

Description

本発明は、原価計算装置、原価計算方法、および、原価計算プログラムに関する。 The present invention relates to a cost accounting device, a cost accounting method, and a cost accounting program.

特許文献1には、締め処理が完了した期首の在庫金額および在庫数、ならびに、当期の仕入金額および仕入数を用いて、在庫評価単価を算出する構成が開示されている。 Patent document 1 discloses a configuration for calculating the inventory valuation unit price using the inventory amount and inventory quantity at the beginning of the period when closing processing has been completed, and the purchase amount and purchase quantity for the current period.

特開2019-219924号公報JP 2019-219924 A

しかしながら、上記特許文献1記載の発明においては、月次締め業務が完了するまで、システム会計年月と実際の年月とが異なるため、その期間の原価データが算出できないという課題があった。 However, in the invention described in Patent Document 1, the system accounting date and the actual date differ until the monthly closing process is completed, so there is a problem in that cost data for that period cannot be calculated.

本発明は、上記問題点に鑑みてなされたものであって、当月の在庫データが確定する前において、その時点の最新データを参照し、速報値としての原価計算を行うことで、リアルタイムの原価把握、および、利益把握に貢献することができる原価計算装置、原価計算方法、および、原価計算プログラムを提供することを目的とする。 The present invention has been made in consideration of the above problems, and aims to provide a cost calculation device, cost calculation method, and cost calculation program that can contribute to understanding costs and profits in real time by referring to the latest data at that time and performing preliminary cost calculations before the current month's inventory data is finalized.

上述した課題を解決し、目的を達成するために、本発明に係る原価計算装置は、記憶部と制御部とを備えた原価計算装置であって、前記制御部は、商品の当月発注数および当月発注金額を設定した発注データを取得する発注取得手段と、前記発注データに基づいて、前記商品の当月仕入数、当月仕入金額、および、当月諸掛金額を設定した仕入予定データを取得する仕入予定取得手段と、月次締め処理の完了前において、前記商品の前月末在庫数、および、前月末在庫金額を設定した前月在庫データを取得する在庫取得手段と、前記発注データ、前記仕入予定データ、および、前記前月在庫データに基づいて、前記商品の在庫評価単価速報値を算出する在庫評価単価算出手段と、を備えたことを特徴とする。 In order to solve the above-mentioned problems and achieve the object, the cost accounting device according to the present invention is a cost accounting device equipped with a storage unit and a control unit, and the control unit is characterized by comprising: an order acquisition means for acquiring order data that sets the current month's order quantity and current month's order amount for the product; a purchase schedule acquisition means for acquiring purchase schedule data that sets the current month's purchase quantity, current month's purchase amount, and current month's expenses amount for the product based on the order data; an inventory acquisition means for acquiring previous month's inventory data that sets the previous month's inventory quantity and previous month's inventory amount for the product before the monthly closing process is completed; and an inventory valuation unit price calculation means for calculating a preliminary inventory valuation unit price value for the product based on the order data, the purchase schedule data, and the previous month's inventory data.

また、本発明に係る原価計算装置において、前記在庫評価単価算出手段は、前記前月末在庫金額と前記当月仕入金額と前記当月諸掛金額と前記当月発注金額との合計を被除数とし、前記前月末在庫数と前記当月仕入数と前記当月発注数との合計を除数とした場合の商を前記在庫評価単価速報値として算出することを特徴とする。 In the cost calculation device according to the present invention, the inventory valuation unit price calculation means calculates the inventory valuation unit price flash value as the quotient obtained by using the sum of the inventory amount at the end of the previous month, the purchase amount for the current month, the expenses amount for the current month, and the order amount for the current month as the dividend and the sum of the inventory quantity at the end of the previous month, the purchase quantity for the current month, and the order quantity for the current month as the divisor.

また、本発明に係る原価計算装置において、前記制御部は、商品の当月受注数および当月受注金額を設定した受注データを取得する受注取得手段、を更に備え、前記在庫取得手段は、更に、前記前月在庫データ、前記仕入予定データ、前記受注データ、および、前記在庫評価単価速報値に基づいて、当月末在庫数、および、当月末在庫金額を設定した当月末在庫データを取得することを特徴とする。 In the cost calculation device according to the present invention, the control unit further comprises an order acquisition means for acquiring order data that sets the current month's order quantity and the current month's order amount for the product, and the inventory acquisition means further acquires end-of-month inventory data that sets the current month's end inventory quantity and the current month's end inventory amount based on the previous month's inventory data, the purchase plan data, the order data, and the inventory valuation unit price flash value.

また、本発明に係る原価計算装置において、前記在庫取得手段は、前記前月末在庫数と前記当月仕入数との合計から、前記当月受注数を差し引いた値を前記当月末在庫数として設定し、前記在庫評価単価速報値と前記当月末在庫数との積を前記当月末在庫金額として設定した前記当月末在庫データを取得することを特徴とする。 In the cost calculation device according to the present invention, the inventory acquisition means sets the inventory at the end of the current month as the sum of the inventory at the end of the previous month and the purchase quantity at the end of the current month minus the order quantity at the end of the current month, and acquires the inventory data at the end of the current month by setting the product of the inventory valuation unit price flash report value and the inventory at the end of the current month as the inventory amount at the end of the current month.

また、本発明に係る原価計算装置において、前記制御部は、売上予定となる前記当月受注数を当月売上数として取得し、前記前月末在庫数、前記前月末在庫金額、前記当月仕入数、前記当月仕入金額、前記当月売上数、前記当月末在庫数、および、前記当月末在庫金額を設定した月別在庫データを前記記憶部に登録する月別在庫登録手段、を更に備えたことを特徴とする。 In the cost calculation device according to the present invention, the control unit further includes a monthly inventory registration means for acquiring the current month's order quantity, which is to be sold, as the current month's sales quantity, and registering monthly inventory data in the storage unit, the monthly inventory quantity at the end of the previous month, the monthly inventory value at the end of the previous month, the current month's purchase quantity, the current month's purchase value, the current month's sales quantity, the current month's inventory quantity at the end of the current month, and the current month's inventory value.

また、本発明に係る原価計算装置において、前記在庫取得手段は、更に、前記月次締め処理が完了した場合、前月末在庫確定数、および、前月末在庫確定金額を設定した前月在庫確定データを取得し、前記在庫評価単価算出手段は、前記前月末在庫確定金額と前記当月仕入金額と前記当月諸掛金額との合計を被除数とし、前記前月末在庫確定数と前記当月仕入数との合計を除数とした場合の商を在庫評価単価として算出することを特徴とする。 In the cost calculation device according to the present invention, the inventory acquisition means further acquires previous month's inventory confirmation data, which sets the previous month's end inventory confirmation quantity and the previous month's end inventory confirmation amount, when the monthly closing process is completed, and the inventory valuation unit price calculation means calculates the inventory valuation unit price as the quotient obtained by using the sum of the previous month's end inventory confirmation amount, the current month's purchase amount, and the current month's expense amount as the dividend and the sum of the previous month's end inventory confirmation quantity and the current month's purchase quantity as the divisor.

また、本発明に係る原価計算方法は、記憶部と制御部とを備えた原価計算装置に実行させるための原価計算方法であって、前記制御部で実行させる、商品の当月発注数および当月発注金額を設定した発注データを取得する発注取得ステップと、前記発注データに基づいて、前記商品の当月仕入数、当月仕入金額、および、当月諸掛金額を設定した仕入予定データを取得する仕入予定取得ステップと、月次締め処理の完了前において、前記商品の前月末在庫数、および、前月末在庫金額を設定した前月在庫データを取得する在庫取得ステップと、前記発注データ、前記仕入予定データ、および、前記前月在庫データに基づいて、前記商品の在庫評価単価速報値を算出する在庫評価単価算出ステップと、を含むことを特徴とする。 The cost calculation method according to the present invention is a cost calculation method to be executed by a cost calculation device having a storage unit and a control unit, and is characterized by including an order acquisition step executed by the control unit to acquire order data in which the current month's order quantity and current month's order amount of the product are set, a purchase schedule acquisition step to acquire purchase schedule data in which the current month's purchase quantity, current month's purchase amount, and current month's expenses amount of the product are set based on the order data, an inventory acquisition step to acquire previous month's inventory data in which the previous month's inventory quantity and previous month's inventory amount of the product are set before the monthly closing process is completed, and an inventory valuation unit price calculation step to calculate a preliminary inventory valuation unit price value of the product based on the order data, the purchase schedule data, and the previous month's inventory data.

また、本発明に係る原価計算プログラムは、記憶部と制御部とを備えた原価計算装置に実行させるための原価計算プログラムであって、前記制御部において、商品の当月発注数および当月発注金額を設定した発注データを取得する発注取得ステップと、前記発注データに基づいて、前記商品の当月仕入数、当月仕入金額、および、当月諸掛金額を設定した仕入予定データを取得する仕入予定取得ステップと、月次締め処理の完了前において、前記商品の前月末在庫数、および、前月末在庫金額を設定した前月在庫データを取得する在庫取得ステップと、前記発注データ、前記仕入予定データ、および、前記前月在庫データに基づいて、前記商品の在庫評価単価速報値を算出する在庫評価単価算出ステップと、を実行させることを特徴とする。 The cost accounting program according to the present invention is a cost accounting program to be executed by a cost accounting device having a storage unit and a control unit, and is characterized in that the control unit executes an order acquisition step of acquiring order data in which the current month's order quantity and current month's order amount of the product are set, a purchase schedule acquisition step of acquiring purchase schedule data in which the current month's purchase quantity, current month's purchase amount, and current month's expenses amount of the product are set based on the order data, an inventory acquisition step of acquiring previous month's inventory data in which the previous month's end inventory quantity and previous month's end inventory amount of the product are set before the monthly closing process is completed, and an inventory valuation unit price calculation step of calculating a preliminary inventory valuation unit price value of the product based on the order data, the purchase schedule data, and the previous month's inventory data.

本発明によれば、前月のシステム締処理が未実行の場合でも、当月の原価計算処理を実行できるという効果を奏する。また、本発明によれば、在庫評価単価を求めるための受払対象に、当月計上予定の受注データおよび発注データを含めることで、在庫評価単価の速報値を提示することができるという効果を奏する。また、本発明によれば、計算される在庫評価単価および在庫金額をその時点における登録データとして取得できるという効果を奏する。また、本発明によれば、前月の在庫データが確定する前であっても、その時点の最新の値およびデータを参照して、速報値としての原価計算を行うことで、よりリアルタイムな原価把握および利益把握に貢献することができるという効果を奏する。また、本発明によれば、従来、月次締めまで当月分の粗利の確認不可であったが、各取引の粗利を早期に把握可能となるという効果を奏する。また、本発明によれば、原価の見通しを早期に立てられることにより、営業・販売戦略や購買戦略を早期に見直すことを可能とするという効果を奏する。また、本発明によれば、対象データに受注データおよび発注データを含めることで、将来の着地予想、すなわち、原価シミュレーションを効率的に実現できるという効果を奏する。 According to the present invention, even if the system closing process for the previous month has not been executed, the cost calculation process for the current month can be executed. In addition, according to the present invention, the receipt and payment objects for calculating the inventory valuation unit price include the order data and order data to be recorded in the current month, so that the preliminary value of the inventory valuation unit price can be presented. In addition, according to the present invention, the calculated inventory valuation unit price and inventory amount can be obtained as registered data at that time. In addition, according to the present invention, even before the inventory data for the previous month is finalized, the latest values and data at that time can be referenced to perform cost calculation as a preliminary value, which contributes to more real-time understanding of costs and profits. In addition, according to the present invention, although it was previously impossible to confirm the gross profit for the current month until the monthly closing, the gross profit for each transaction can be grasped at an early stage. In addition, according to the present invention, the cost can be forecasted at an early stage, so that sales and purchasing strategies can be reviewed at an early stage. Furthermore, according to the present invention, by including order data and purchase order data in the target data, it is possible to efficiently realize future cost predictions, i.e., cost simulations.

図1は、従来の原価計算処理の一例を示す図である。FIG. 1 is a diagram showing an example of a conventional cost accounting process. 図2は、本実施形態における原価計算装置の構成の一例を示すブロック図である。FIG. 2 is a block diagram showing an example of the configuration of a cost calculation device in this embodiment. 図3は、本実施形態における原価計算装置の処理の一例を示すフローチャートである。FIG. 3 is a flowchart showing an example of the process of the cost calculation device in this embodiment. 図4は、本実施形態における原価計算処理の一例を示す図である。FIG. 4 is a diagram showing an example of a cost calculation process in this embodiment. 図5は、本実施形態における原価計算処理の一例を示す図である。FIG. 5 is a diagram showing an example of a cost calculation process in this embodiment.

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

[1.概要]
まず、図1を参照して、本発明の概要を説明する。図1は、従来の原価計算処理の一例を示す図である。
[1. Overview]
First, an overview of the present invention will be described with reference to Fig. 1. Fig. 1 is a diagram showing an example of a conventional cost accounting process.

従来、商品の実際原価は、在庫データに基づいて、算出・管理されており、月次締めである月次確定処理後にシステム会計年月の更新が行われ、原価計算処理が日次処理として実行されていた。また、従来、商品の在庫評価単価は、原価計算処理を実行することで、システム会計年月の当月を対象に、最新の在庫受払データが集計・算出され、算出された在庫評価単価に基づいて、売上データの売上原価データを洗い替えることで、実際原価に基づく粗利の把握をしていた。 Previously, the actual cost of a product was calculated and managed based on inventory data, and the system accounting year and month was updated after the monthly closing process, and cost accounting processing was performed as a daily process. Also, previously, the inventory valuation unit price of a product was calculated by running the cost accounting process, which tallied and calculated the latest inventory receipt and payment data for the current month of the system accounting year and month, and the sales cost data of the sales data was updated based on the calculated inventory valuation unit price, allowing gross profit to be determined based on actual costs.

このように、従来、在庫評価単価は、前月の確定した在庫データと当月の受払データとに基づいて算出されるため、運用上、月次締業務が完了するまで、システム会計年月と実際の年月とが異なるため、その期間の原価が算出できず、その結果、原価が異なるまたは原価が求められないため、日次の売上総利益の確認ができなかった。更に、従来は、当月の受発注残が多くある場合、売上および仕入が確定するまで、最終的な在庫評価単価、および、在庫金額がわからないため、着地予想にデータ加工の手作業が発生していた。 As such, traditionally, inventory valuation unit prices were calculated based on the confirmed inventory data from the previous month and the receipt and payment data for the current month, and so operationally, until monthly closing operations were completed, the system accounting year and month differed from the actual year and month, and so the cost for that period could not be calculated. As a result, the cost was different or could not be obtained, and so daily gross profit could not be confirmed. Furthermore, traditionally, if there was a large amount of backlog in the current month, the final inventory valuation unit price and inventory amount were not known until sales and purchases were confirmed, and so manual data processing was required to forecast the final amount.

例えば、従来、図1に示すように、当月の月次締業務、および、締処理が月末から5営業日で実施されており、実際の年月が2020年1月、且つ、システム上の会計年月が2019年12月の期間において、月末に仕入予定の商品が(海外取引などの影響で)月をまたいで仕入されることが多く発生するような場合でも、2019年12月の月次締業務が完了していないため、2019年12月末の在庫金額が確定しておらず、2020年1月予定の受発注残を加味した2020年1月の原価計算が実行されないため(図中の黒丸)、経営指標としての日次での取引の売買実績および売上総利益が確認できず、取引の着地予想もできなかった。 For example, as shown in Figure 1, previously, monthly closing operations and closing processing for the current month were performed within five business days from the end of the month, and even if the actual year and month was January 2020 and the accounting year and month in the system was December 2019, and products scheduled to be purchased at the end of the month were often purchased across months (due to the influence of overseas transactions, etc.), the monthly closing operations for December 2019 had not been completed, so the inventory amount at the end of December 2019 had not been determined, and cost calculations for January 2020 that take into account the backlog of orders scheduled for January 2020 were not performed (black circles in the figure), so daily trading results and gross profits as management indicators could not be confirmed, and it was not possible to predict the outcome of transactions.

そこで、本実施形態において、前月の在庫データが確定する前であっても、その時点の最新データを参照して、原価計算を行うことで、速報性をもった原価把握および利益把握を可能とする仕組みを提供している。 Therefore, in this embodiment, a system is provided that allows for timely understanding of costs and profits by performing cost calculations by referring to the latest data at that time, even before the previous month's inventory data is finalized.

[2.構成]
本実施形態に係る原価計算装置100の構成の一例について、図2を参照して説明する。図2は、本実施形態における原価計算装置100の構成の一例を示すブロック図である。
2. Configuration
An example of the configuration of the cost calculation device 100 according to this embodiment will be described with reference to Fig. 2. Fig. 2 is a block diagram showing an example of the configuration of the cost calculation device 100 according to this embodiment.

図2に示すように、原価計算装置100は、市販のデスクトップ型パーソナルコンピュータである。なお、原価計算装置100は、デスクトップ型パーソナルコンピュータのような据置型情報処理装置に限らず、市販されているノート型パーソナルコンピュータ、PDA(Personal Digital Assistants)、スマートフォン、タブレット型パーソナルコンピュータなどの携帯型情報処理装置であってもよい。 As shown in FIG. 2, the cost accounting device 100 is a commercially available desktop personal computer. Note that the cost accounting device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

原価計算装置100は、制御部102と通信インターフェース部104と記憶部106と入出力インターフェース部108と、を備えている。原価計算装置100が備えている各部は、任意の通信路を介して通信可能に接続されている。 The cost calculation device 100 comprises a control unit 102, a communication interface unit 104, a memory unit 106, and an input/output interface unit 108. Each unit of the cost calculation device 100 is connected to each other so as to be able to communicate with each other via any communication path.

通信インターフェース部104は、ルータ等の通信装置および専用線等の有線または無線の通信回線を介して、原価計算装置100をネットワーク300に通信可能に接続する。通信インターフェース部104は、他の装置と通信回線を介してデータを通信する機能を有する。ここで、ネットワーク300は、原価計算装置100とサーバ200とを相互に通信可能に接続する機能を有し、例えばインターネットやLAN(Local Area Network)等である。 The communication interface unit 104 communicatively connects the cost 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 other devices via the communication line. Here, the network 300 has a function of connecting the cost accounting device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

記憶部106には、各種のデータベース、テーブル、およびファイルなどが格納される。記憶部106には、OS(Operating System)と協働してCPU(Central Processing Unit)に命令を与えて各種処理を行うためのコンピュータプログラムが記録される。記憶部106として、例えば、RAM(Random Access Memory)・ROM(Read Only Memory)等のメモリ装置、ハードディスクのような固定ディスク装置、フレキシブルディスク、および光ディスク等を用いることができる。記憶部106は、取引データベース106aを備えている。 The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs that work with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. The storage unit 106 can be, 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, or an optical disk. The storage unit 106 includes a transaction database 106a.

取引データベース106aは、取引データを記憶する。ここで、取引データは、商品の発注データ、受注データ、仕入予定データ、前月在庫データ、当月末在庫データ、月別在庫データ、月別在庫評価単価データ、および/または、前月在庫確定データ等を含んでいてもよい。ここで、発注データは、会計年月、商品名、発注日、仕入予定日、発注数、および/または、発注金額等が設定されていてもよい。また、受注データは、会計年月、商品名、受注日、売上予定日、受注数、および/または、受注金額等が設定されていてもよい。また、月別在庫データは、会計年月、商品名、前月末在庫数、前月末在庫金額、当月仕入数、当月仕入金額、当月諸掛金額、当月売上数、当月末在庫数、および/または、当月末在庫金額等が設定されていてもよい。また、月別在庫評価単価データは、会計年月、商品名、および/または、在庫評価単価等が設定されていてもよい。 The transaction database 106a stores transaction data. Here, the transaction data may include product order data, order data, planned purchase data, previous month inventory data, month-end inventory data, monthly inventory data, monthly inventory evaluation unit price data, and/or previous month inventory confirmation data. Here, the order data may be set with the accounting year and month, product name, order date, planned purchase date, order quantity, and/or order amount. The order data may be set with the accounting year and month, product name, order date, planned sales date, order quantity, and/or order amount. The monthly inventory data may be set with the accounting year and month, product name, previous month end inventory quantity, previous month end inventory amount, current month purchase quantity, current month purchase amount, current month expense amount, current month sales quantity, current month end inventory quantity, and/or current month end inventory amount. The monthly inventory evaluation unit price data may be set with the accounting year and month, product name, and/or inventory evaluation unit price.

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

制御部102は、原価計算装置100を統括的に制御するCPU等である。制御部102は、OS等の制御プログラム・各種の処理手順等を規定したプログラム・所要データなどを格納するための内部メモリを有し、格納されているこれらのプログラムに基づいて種々の情報処理を実行する。制御部102は、機能概念的に、受注取得部102aと発注取得部102bと仕入予定取得部102cと在庫取得部102dと在庫評価単価算出部102eと月別在庫登録部102fとを備えている。 The control unit 102 is a CPU or the like that performs overall control of the cost accounting device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing based on these stored programs. In terms of function and concept, the control unit 102 includes an order acquisition unit 102a, an order acquisition unit 102b, a purchase schedule acquisition unit 102c, an inventory acquisition unit 102d, an inventory evaluation unit price calculation unit 102e, and a monthly inventory registration unit 102f.

受注取得部102aは、商品の受注データを取得する。ここで、受注取得部102aは、商品の当月受注数および当月受注金額を設定した受注データを取得してもよい。また、受注取得部102aは、受注データを取引データベース106aに登録してもよい。 The order acquisition unit 102a acquires order data for the product. Here, the order acquisition unit 102a may acquire order data that sets the number of orders for the product for the current month and the order amount for the current month. The order acquisition unit 102a may also register the order data in the transaction database 106a.

発注取得部102bは、商品の発注データを取得する。ここで、発注取得部102bは、商品の当月発注数および当月発注金額を設定した発注データを取得してもよい。また、発注取得部102bは、発注データを取引データベース106aに登録してもよい。 The order acquisition unit 102b acquires product order data. Here, the order acquisition unit 102b may acquire order data that sets the current month's order quantity and current month's order amount for the product. The order acquisition unit 102b may also register the order data in the transaction database 106a.

仕入予定取得部102cは、商品の仕入予定データを取得する。ここで、仕入予定取得部102cは、発注データに基づいて、商品の当月仕入数、当月仕入金額、および、当月諸掛金額を設定した仕入予定データを取得してもよい。また、仕入予定取得部102cは、仕入予定データを取引データベース106aに登録してもよい。 The purchase schedule acquisition unit 102c acquires product purchase schedule data. Here, the purchase schedule acquisition unit 102c may acquire purchase schedule data that sets the current month's purchase quantity of the product, the current month's purchase amount, and the current month's expenses amount based on the order data. In addition, the purchase schedule acquisition unit 102c may register the purchase schedule data in the transaction database 106a.

在庫取得部102dは、商品の在庫データを取得する。ここで、在庫取得部102dは、月次締め処理の完了前において、商品の前月末在庫数、および、前月末在庫金額を設定した前月在庫データを取得してもよい。また、在庫取得部102dは、前月在庫データ、仕入予定データ、受注データ、および、在庫評価単価速報値に基づいて、商品の当月末在庫数、および、当月末在庫金額を設定した当月末在庫データを取得してもよい。また、在庫取得部102dは、商品の前月末在庫数と当月仕入数との合計から、商品の当月受注数を差し引いた値を商品の当月末在庫数として設定し、在庫評価単価速報値と当月末在庫数との積を当月末在庫金額として設定した当月末在庫データを取得してもよい。また、在庫取得部102dは、月次締め処理が完了した場合、商品の前月末在庫確定数、および、前月末在庫確定金額を設定した前月在庫確定データを取得し、また、在庫取得部102dは、在庫データ等を取引データベース106aに登録してもよい。 The inventory acquisition unit 102d acquires inventory data of the product. Here, the inventory acquisition unit 102d may acquire the previous month's inventory data in which the inventory quantity at the end of the previous month and the inventory amount at the end of the previous month are set before the completion of the monthly closing process. The inventory acquisition unit 102d may also acquire the end-of-month inventory data in which the inventory quantity at the end of the current month and the inventory amount at the end of the current month are set based on the previous month's inventory data, purchase schedule data, order data, and the inventory evaluation unit price flash value. The inventory acquisition unit 102d may also acquire the end-of-month inventory data in which the inventory quantity at the end of the current month and the inventory amount at the end of the current month are set as the inventory quantity at the end of the current month, and the product of the inventory evaluation unit price flash value and the inventory quantity at the end of the current month is set as the inventory amount at the end of the current month. In addition, when the monthly closing process is completed, the inventory acquisition unit 102d acquires previous month's inventory confirmation data that sets the previous month's end inventory confirmation quantity and previous month's end inventory confirmation amount of the product, and the inventory acquisition unit 102d may also register the inventory data, etc. in the transaction database 106a.

在庫評価単価算出部102eは、商品の在庫評価単価速報値を算出する。ここで、在庫評価単価算出部102eは、発注データ、仕入予定データ、および、前月在庫データに基づいて、商品の在庫評価単価速報値を算出してもよい。また、在庫評価単価算出部102eは、商品の前月末在庫金額と当月仕入金額と当月諸掛金額と当月発注金額との合計を被除数とし、前月末在庫数と当月仕入数と当月発注数との合計を除数とした場合の商を在庫評価単価速報値として算出してもよい。また、在庫評価単価算出部102eは、商品の前月末在庫確定金額と当月仕入金額と当月諸掛金額との合計を被除数とし、前月末在庫確定数と当月仕入数との合計を除数とした場合の商を在庫評価単価として算出してもよい。また、在庫評価単価算出部102eは、在庫評価単価速報値および/または在庫評価単価を取引データベース106aに登録してもよい。 The inventory valuation unit price calculation unit 102e calculates the inventory valuation unit price prompt value of the product. Here, the inventory valuation unit price calculation unit 102e may calculate the inventory valuation unit price prompt value of the product based on the order data, the purchase schedule data, and the previous month's inventory data. The inventory valuation unit price calculation unit 102e may also calculate the quotient as the inventory valuation unit price prompt value when the sum of the inventory amount at the end of the previous month, the purchase amount for this month, the miscellaneous expenses amount for this month, and the order amount for this month is used as the dividend, and the sum of the inventory number at the end of the previous month, the purchase amount for this month, and the order number for this month is used as the divisor. The inventory valuation unit price calculation unit 102e may also calculate the quotient as the inventory valuation unit price when the sum of the confirmed inventory amount at the end of the previous month, the purchase amount for this month, and the miscellaneous expenses amount for this month is used as the dividend, and the sum of the confirmed inventory number at the end of the previous month and the purchase amount for this month is used as the divisor. In addition, the inventory valuation unit price calculation unit 102e may register the inventory valuation unit price flash value and/or the inventory valuation unit price in the transaction database 106a.

月別在庫登録部102fは、商品の月別在庫データを記憶部106に登録する。ここで、月別在庫登録部102fは、商品の売上予定となる当月受注数を当月売上数として取得し、前月末在庫数、前月末在庫金額、当月仕入数、当月仕入金額、当月売上数、当月末在庫数、および/または、当月末在庫金額を設定した月別在庫データを取引データベース106aに登録してもよい。 The monthly inventory registration unit 102f registers monthly inventory data of the product in the storage unit 106. Here, the monthly inventory registration unit 102f may obtain the current month's order quantity, which is the planned sales quantity of the product, as the current month's sales quantity, and may register monthly inventory data in which the inventory quantity at the end of the previous month, the inventory value at the end of the previous month, the current month's purchase quantity, the current month's purchase value, the current month's sales quantity, the current month's inventory quantity at the end of the current month, and/or the current month's inventory value are set in the transaction database 106a.

[3.具体例]
本実施形態の具体例について、図3から図5を参照して説明する。
3. Specific Examples
A specific example of this embodiment will be described with reference to FIGS.

[原価計算処理]
ここで、図3を参照して、本実施形態における翌月原価計算処理の一例について説明する。図3は、本実施形態における原価計算装置100の処理の一例を示すフローチャートである。
[Cost accounting process]
An example of the next month's cost calculation process in this embodiment will now be described with reference to Fig. 3. Fig. 3 is a flow chart showing an example of the process of the cost calculation device 100 in this embodiment.

図3に示すように、受注取得部102aは、月次締め処理の完了前において、商品の当月受注数および当月受注金額を設定した受注データを取得し、受注データを取引データベース106aに登録する(ステップSA-1)。 As shown in FIG. 3, before the monthly closing process is completed, the order acquisition unit 102a acquires order data that sets the number of products ordered for the current month and the order amount for the current month, and registers the order data in the transaction database 106a (step SA-1).

そして、発注取得部102bは、月次締め処理の完了前において、商品の当月発注数および当月発注金額を設定した発注データを取得し、発注データを取引データベース106aに登録する(ステップSA-2)。 Then, before the monthly closing process is completed, the order acquisition unit 102b acquires order data that sets the number of products ordered for the current month and the order amount for the current month, and registers the order data in the transaction database 106a (step SA-2).

そして、仕入予定取得部102cは、発注データに基づいて、商品の当月仕入数、当月仕入金額、および、当月諸掛金額を設定した仕入予定データを取得し、仕入予定データを取引データベース106aに登録する(ステップSA-3)。 Then, the purchase schedule acquisition unit 102c acquires purchase schedule data that sets the current month's purchase quantity of the product, the current month's purchase amount, and the current month's expenses amount based on the order data, and registers the purchase schedule data in the transaction database 106a (step SA-3).

そして、在庫取得部102dは、月次締め処理の完了前において、商品の前月末在庫数、および、前月末在庫金額を設定した前月在庫データを速報値として取得し、前月在庫データを取引データベース106aに登録する(ステップSA-4)。 Then, before the monthly closing process is completed, the inventory acquisition unit 102d acquires the previous month's inventory data, which includes the inventory quantity and inventory value of the product at the end of the previous month, as preliminary values, and registers the previous month's inventory data in the transaction database 106a (step SA-4).

そして、在庫評価単価算出部102eは、商品の前月末在庫金額と当月仕入金額と当月諸掛金額と当月発注金額との合計を被除数とし、前月末在庫数と当月仕入数と当月発注数との合計を除数とした場合の商を在庫評価単価速報値として算出し、在庫評価単価速報値を取引データベース106aに登録する(ステップSA-5)。 Then, the inventory valuation unit price calculation unit 102e calculates the quotient by using the sum of the inventory amount at the end of the previous month, the purchase amount for this month, the expenses amount for this month, and the order amount for this month as the dividend and the sum of the inventory quantity at the end of the previous month, the purchase quantity for this month, and the order quantity for this month as the divisor as the preliminary inventory valuation unit price, and registers the preliminary inventory valuation unit price in the transaction database 106a (step SA-5).

そして、在庫取得部102dは、商品の前月末在庫数と当月仕入数との合計から、商品の当月受注数を差し引いた値を商品の当月末在庫数として設定し、在庫評価単価速報値と当月末在庫数との積を当月末在庫金額として設定した当月末在庫データを取得し、当月末在庫データを取引データベース106aに登録する(ステップSA-6)。 Then, the inventory acquisition unit 102d sets the inventory quantity at the end of the current month for the product as the sum of the inventory quantity at the end of the previous month and the purchase quantity for the current month minus the number of orders for the product for the current month, acquires inventory data at the end of the current month in which the product of the inventory valuation unit price flash value and the inventory quantity at the end of the current month is set as the inventory amount at the end of the current month, and registers the inventory data at the end of the current month in the transaction database 106a (step SA-6).

そして、在庫取得部102dは、月次締め処理が完了した場合、商品の前月末在庫確定数、および、前月末在庫確定金額を設定した前月在庫確定データを取得し、前月在庫確定データを取引データベース106aに登録する(ステップSA-7)。 Then, when the monthly closing process is completed, the inventory acquisition unit 102d acquires the previous month's inventory confirmation data, which sets the previous month's end inventory confirmation quantity and previous month's end inventory confirmation amount of the product, and registers the previous month's inventory confirmation data in the transaction database 106a (step SA-7).

そして、在庫評価単価算出部102eは、商品の前月末在庫確定金額と当月仕入金額と当月諸掛金額との合計を被除数とし、前月末在庫確定数と当月仕入数との合計を除数とした場合の商を在庫評価単価として算出し、在庫評価単価を取引データベース106aに登録し(ステップSA-8)、処理を終了する。 Then, the inventory valuation unit price calculation unit 102e calculates the inventory valuation unit price by using the sum of the confirmed inventory amount at the end of the previous month, the purchase amount for the current month, and the expenses for the current month as the dividend and the sum of the confirmed inventory quantity at the end of the previous month and the purchase quantity for the current month as the divisor, and registers the inventory valuation unit price in the transaction database 106a (step SA-8), and ends the process.

ここで、図4および図5を参照して、本実施形態における原価計算処理の一例について説明する。図4および図5は、本実施形態における原価計算処理の一例を示す図である。 Here, an example of the cost calculation process in this embodiment will be described with reference to Figures 4 and 5. Figures 4 and 5 are diagrams showing an example of the cost calculation process in this embodiment.

図4に示すように、本実施形態においては、前月の月次締め処理を月末から5営業日で実施している企業にて、2020年1月初頭(2019年12月の月次締め処理の完了前)において、「在庫評価単価=(前月末在庫確定金額+当月仕入金額+当月諸掛金額)÷(前月末在庫確定数+当月仕入数)」と計算され、「当月末在庫数=前月末在庫数+当月仕入数-当月売上数」と計算され、「当月末在庫金額=在庫評価単価×当月末在庫数」と計算されることで、会計システム当月(2019年12月)末時点での原価計算処理が実行される。ここで、図4に示すように、本実施形態においては、当月仕入数、当月仕入金額、当月諸掛金額および当月売上数について、各入力処理(仕入入力、仕入諸掛入力および売上入力等)を行ったタイミングで月別在庫テーブルに都度反映されてもよい。 As shown in FIG. 4, in this embodiment, in a company that performs monthly closing processing for the previous month within five business days from the end of the month, in early January 2020 (before the completion of monthly closing processing for December 2019), the calculation is performed as follows: "Inventory valuation unit price = (last month end inventory confirmed amount + current month purchase amount + current month's overhead amount) ÷ (last month end inventory confirmed number + current month purchase number)", "last month end inventory number = last month end inventory number + current month purchase number - current month sales number", and "last month end inventory amount = inventory valuation unit price x current month end inventory number", thereby performing cost calculation processing at the end of the current month (December 2019) in the accounting system. Here, as shown in FIG. 4, in this embodiment, the current month purchase number, current month purchase amount, current month overhead amount, and current month sales number may be reflected in the monthly inventory table each time each input process (purchase input, purchase overhead input, sales input, etc.) is performed.

更に、図5に示すように、本実施形態においては、2020年1月初頭(2019年12月の月次締め処理の完了前)において、会計システム当月(2019年12月)の当月末在庫数および当月末在庫金額が速報値として取得され、2020年1月の前月末在庫数および前月末在庫金額の速報値として月別在庫テーブルに登録される。そして、図5に示すように、本実施形態においては、発注テーブルから2020年1月中の仕入予定となる当月発注数および当月発注金額が取得され、「在庫評価単価速報値=(前月末在庫金額+当月仕入金額+当月諸掛金額+当月発注金額)÷(前月末在庫数+当月仕入数+当月発注数)」と計算され、受注テーブルから2020年1月中の売上予定となる当月受注数が取得され、「当月末在庫数=前月末在庫数+当月仕入数-当月売上数」と計算され、「当月末在庫金額=在庫評価単価速報値×当月末在庫数」と計算されることで、月別在庫テーブルに当月末在庫数および当月末在庫金額が速報値として反映される。このように、本実施形態においては、発注テーブルの仕入予定日が実際の年月(2020年1月)に含まれるデータ(当月発注金額および当月発注数)を在庫評価単価速報値の計算に含めてもよい。 Furthermore, as shown in FIG. 5, in this embodiment, at the beginning of January 2020 (before the monthly closing process for December 2019 is completed), the accounting system obtains the end-of-month inventory quantity and end-of-month inventory amount for the current month (December 2019) as preliminary values, and these are registered in the monthly inventory table as preliminary values for the end-of-month inventory quantity and end-of-month inventory amount for January 2020. As shown in FIG. 5, in this embodiment, the order quantity and order amount for this month that are scheduled to be purchased in January 2020 are obtained from the order table, and the calculation is "Inventory valuation unit price preliminary value = (inventory amount at the end of the previous month + purchase amount for this month + expenses for this month + order amount for this month) ÷ (inventory quantity at the end of the previous month + purchase quantity for this month + order quantity for this month)". The order quantity for this month that is scheduled to be sold in January 2020 is obtained from the order table, and the calculation is "inventory quantity at the end of this month = inventory quantity at the end of the previous month + purchase quantity for this month - sales quantity for this month". The inventory quantity and inventory amount at the end of this month are reflected as preliminary values in the monthly inventory table. In this way, in this embodiment, the data (order amount and order quantity for this month) included in the actual year and month (January 2020) of the planned purchase date in the order table may be included in the calculation of the inventory valuation unit price preliminary value.

そして、本実施形態においては、2020年1月8日に、月次締め処理が完了し、会計システム年月(会計年月)が実際の年月である2020年1月となることで、前月(2019年12月)の月別在庫データが確定するため、商品の前月末在庫確定金額および前月末在庫確定数を用いて、随時、原価計算処理が行われる。 In this embodiment, the monthly closing process is completed on January 8, 2020, and the accounting system year and month (accounting year and month) becomes the actual year and month, January 2020, and the monthly inventory data for the previous month (December 2019) is finalized. Therefore, cost calculation processing is performed as needed using the finalized inventory amount and finalized inventory quantity for the product at the end of the previous month.

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

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

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

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

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

また、本実施形態で説明した処理を実行するためのプログラムを、一時的でないコンピュータ読み取り可能な記録媒体に格納してもよく、また、プログラム製品として構成することもできる。ここで、この「記録媒体」とは、メモリーカード、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等の任意の「可搬用の物理媒体」を含むものとする。 In addition, the program for executing the processing described in this embodiment may be stored on a non-transitory computer-readable recording medium, and may also be configured as a program product. Here, the term "recording medium" refers to a memory card, a USB (Universal Serial Bus) memory, a SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical disk), a DVD (Digital Versatile This includes any "portable physical media" such as a Blu-ray (registered trademark) Disc, and a Blu-ray (registered trademark) Disc.

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

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

また、原価計算装置100は、既知のパーソナルコンピュータまたはワークステーション等の情報処理装置として構成してもよく、また、任意の周辺装置が接続された当該情報処理装置として構成してもよい。また、原価計算装置100は、当該装置に本実施形態で説明した処理を実現させるソフトウェア(プログラムまたはデータ等を含む)を実装することにより実現してもよい。 The cost accounting 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 any peripheral device is connected. The cost accounting device 100 may be realized by implementing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

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

本発明は、各取引の粗利を早期に把握する必要がある商社等の業界において有用である。 This invention is useful in industries such as trading companies, where it is necessary to know the gross profit of each transaction early on.

100 原価計算装置
102 制御部
102a 受注取得部
102b 発注取得部
102c 仕入予定取得部
102d 在庫取得部
102e 在庫評価単価算出部
102f 月別在庫登録部
104 通信インターフェース部
106 記憶部
106a 取引データベース
108 入出力インターフェース部
112 入力装置
114 出力装置
200 サーバ
300 ネットワーク
REFERENCE SIGNS LIST 100 Cost calculation device 102 Control unit 102a Order acquisition unit 102b Order acquisition unit 102c Purchase schedule acquisition unit 102d Inventory acquisition unit 102e Inventory evaluation unit price calculation unit 102f Monthly inventory registration unit 104 Communication interface unit 106 Storage unit 106a Transaction database 108 Input/output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (8)

記憶部と制御部とを備えた原価計算装置であって、前月の月次締めが当月に行われ、且つ、月次締め処理の完了前に、前記当月の原価計算を行う場合、
前記制御部は、
商品の当月発注数および当月発注金額を設定した発注データを取得する発注取得手段と、
前記発注データに基づいて、前記商品の当月仕入数、および、当月仕入金額を設定した仕入予定データを取得する仕入予定取得手段と、
前記月次締め処理の完了前において、前記商品の前月末在庫数、および、前月末在庫金額を設定した前月在庫データを取得する在庫取得手段と、
前記発注データ、前記仕入予定データ、および、前記前月在庫データに基づいて、前記商品の在庫評価単価速報値を算出する在庫評価単価算出手段と、
を備えたことを特徴とする原価計算装置。
A cost accounting device having a storage unit and a control unit, in which a monthly closing process for a previous month is performed in a current month, and cost accounting for the current month is performed before the monthly closing process is completed,
The control unit is
an order acquisition means for acquiring order data that sets the number of products to be ordered in the current month and the order amount in the current month;
a purchase schedule acquisition means for acquiring purchase schedule data in which the purchase quantity and purchase amount of the product for the current month are set based on the order data;
an inventory acquisition means for acquiring, before the completion of the monthly closing process, previous month inventory data in which the inventory quantity and the inventory amount at the end of the previous month of the product are set;
an inventory evaluation unit price calculation means for calculating a quick inventory evaluation unit price value of the commodity based on the order data, the purchase schedule data, and the previous month's inventory data;
A cost accounting device comprising:
前記在庫評価単価算出手段は、
前記前月末在庫金額と前記当月仕入金額と前記当月発注金額との合計を被除数とし、前記前月末在庫数と前記当月仕入数と前記当月発注数との合計を除数とした場合の商を前記在庫評価単価速報値として算出することを特徴とする請求項1に記載の原価計算装置。
The inventory evaluation unit price calculation means
2. The cost calculation device according to claim 1, wherein the sum of the inventory amount at the end of the previous month, the purchase amount for the current month, and the order amount for the current month is used as the dividend, and the sum of the inventory quantity at the end of the previous month, the purchase quantity for the current month, and the order quantity for the current month is used as the divisor, and the quotient is calculated as the preliminary inventory valuation unit price value.
前記制御部は、
前記商品の当月受注数および当月受注金額を設定した受注データを取得する受注取得手段、
を更に備え、
前記在庫取得手段は、
更に、前記前月在庫データ、前記仕入予定データ、前記受注データ、および、前記在庫評価単価速報値に基づいて、当月末在庫数、および、当月末在庫金額を設定した当月末在庫データを取得することを特徴とする請求項1または2に記載の原価計算装置。
The control unit is
an order acquisition means for acquiring order data that sets the number of orders received for the product in the current month and the order amount for the product in the current month;
Further comprising:
The inventory acquisition means includes:
The cost calculation device according to claim 1 or 2, further comprising: acquiring end-of-month inventory data, which sets the inventory quantity at the end of the month and the inventory amount at the end of the month, based on the previous month's inventory data, the purchase plan data, the order data, and the inventory valuation unit price flash report value.
前記在庫取得手段は、
前記前月末在庫数と前記当月仕入数との合計から、前記当月受注数を差し引いた値を前記当月末在庫数として設定し、前記在庫評価単価速報値と前記当月末在庫数との積を前記当月末在庫金額として設定した前記当月末在庫データを取得することを特徴とする請求項3に記載の原価計算装置。
The inventory acquisition means includes:
The cost calculation device according to claim 3, characterized in that the end-of-month inventory data is acquired by setting the end-of-month inventory quantity as the sum of the inventory quantity at the end of the previous month and the purchase quantity for the current month minus the order quantity for the current month, and by setting the product of the inventory valuation unit price flash report value and the inventory quantity at the end of the current month as the inventory amount at the end of the current month.
前記制御部は、
売上予定となる前記当月受注数を当月売上数として取得し、前記前月末在庫数、前記前月末在庫金額、前記当月仕入数、前記当月仕入金額、前記当月売上数、前記当月末在庫数、および、前記当月末在庫金額を設定した月別在庫データを前記記憶部に登録する月別在庫登録手段、
を更に備えたことを特徴とする請求項4に記載の原価計算装置。
The control unit is
a monthly inventory registration means for registering in the storage unit monthly inventory data including the number of orders received for the current month, which is to be sold, as the number of sales for the current month, and the number of stocks at the end of the previous month, the amount of stock at the end of the previous month, the number of purchases for the current month, the amount of purchases for the current month, the number of sales for the current month, the number of stocks at the end of the current month, and the amount of stock at the end of the current month;
5. The cost calculation device according to claim 4, further comprising:
前記在庫取得手段は、
更に、前記月次締め処理が完了した場合、前月末在庫確定数、および、前月末在庫確定金額を設定した前月在庫確定データを取得し、
前記在庫評価単価算出手段は、
前記前月末在庫確定金額と前記当月仕入金額との合計を被除数とし、前記前月末在庫確定数と前記当月仕入数との合計を除数とした場合の商を在庫評価単価として算出することを特徴とする請求項1または2に記載の原価計算装置。
The inventory acquisition means includes:
Furthermore, when the monthly closing process is completed, the previous month's inventory confirmation data is obtained, which sets the previous month's end inventory confirmation quantity and the previous month's end inventory confirmation amount,
The inventory evaluation unit price calculation means
3. The cost calculation device according to claim 1, wherein the sum of the inventory final amount at the end of the previous month and the purchase amount for the current month is used as the dividend and the sum of the inventory final amount at the end of the previous month and the purchase amount for the current month is used as the divisor, and the quotient is calculated as the inventory valuation unit price.
記憶部と制御部とを備えた原価計算装置に実行させるための原価計算方法であって、前月の月次締めが当月に行われ、且つ、月次締め処理の完了前に、前記当月の原価計算を行う場合、
前記制御部で実行される、
商品の当月発注数および当月発注金額を設定した発注データを取得する発注取得ステップと、
前記発注データに基づいて、前記商品の当月仕入数、および、当月仕入金額を設定した仕入予定データを取得する仕入予定取得ステップと、
前記月次締め処理の完了前において、前記商品の前月末在庫数、および、前月末在庫金額を設定した前月在庫データを取得する在庫取得ステップと、
前記発注データ、前記仕入予定データ、および、前記前月在庫データに基づいて、前記商品の在庫評価単価速報値を算出する在庫評価単価算出ステップと、
を含むことを特徴とする原価計算方法。
A cost calculation method to be executed by a cost calculation device having a storage unit and a control unit, in which, when a monthly closing process for a previous month is performed in a current month, and the cost calculation for the current month is performed before the completion of the monthly closing process,
Executed by the control unit,
an order acquisition step for acquiring order data that sets the number of products ordered in the current month and the order amount in the current month;
a purchase schedule acquisition step of acquiring purchase schedule data in which a purchase quantity and a purchase amount of the product for the current month are set based on the order data;
an inventory acquisition step of acquiring, before the completion of the monthly closing process, inventory data for the previous month in which the inventory quantity and the inventory amount at the end of the previous month of the product are set;
an inventory valuation unit price calculation step of calculating a quick inventory valuation unit price value of the commodity based on the order data, the purchase schedule data, and the previous month's inventory data;
A cost calculation method comprising:
記憶部と制御部とを備えた原価計算装置に実行させるための原価計算プログラムであって、前月の月次締めが当月に行われ、且つ、月次締め処理の完了前に、前記当月の原価計算を行う場合、
前記制御部において、
商品の当月発注数および当月発注金額を設定した発注データを取得する発注取得ステップと、
前記発注データに基づいて、前記商品の当月仕入数、および、当月仕入金額を設定した仕入予定データを取得する仕入予定取得ステップと、
前記月次締め処理の完了前において、前記商品の前月末在庫数、および、前月末在庫金額を設定した前月在庫データを取得する在庫取得ステップと、
前記発注データ、前記仕入予定データ、および、前記前月在庫データに基づいて、前記商品の在庫評価単価速報値を算出する在庫評価単価算出ステップと、
を実行させるための原価計算プログラム。
A cost calculation program to be executed by a cost calculation device having a storage unit and a control unit, in which when monthly closing for a previous month is performed in a current month and the cost calculation for the current month is performed before the completion of the monthly closing process,
In the control unit,
an order acquisition step for acquiring order data that sets the number of products ordered in the current month and the order amount in the current month;
a purchase schedule acquisition step of acquiring purchase schedule data in which a purchase quantity and a purchase amount of the product for the current month are set based on the order data;
an inventory acquisition step of acquiring, before the completion of the monthly closing process, inventory data for the previous month in which the inventory quantity and the inventory amount at the end of the previous month of the product are set;
an inventory valuation unit price calculation step of calculating a quick inventory valuation unit price value of the commodity based on the order data, the purchase schedule data, and the previous month's inventory data;
A cost accounting program for executing the above.
JP2023218805A 2020-03-12 2023-12-26 Cost accounting device, cost accounting method, and cost accounting program Active JP7602000B2 (en)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
JP2020043387 2020-03-12
JP2020043387 2020-03-12
JP2020170780A JP7412315B2 (en) 2020-03-12 2020-10-08 Cost accounting device, cost accounting method, and cost accounting program

Related Parent Applications (1)

Application Number Title Priority Date Filing Date
JP2020170780A Division JP7412315B2 (en) 2020-03-12 2020-10-08 Cost accounting device, cost accounting method, and cost accounting program

Publications (2)

Publication Number Publication Date
JP2024023902A JP2024023902A (en) 2024-02-21
JP7602000B2 true JP7602000B2 (en) 2024-12-17

Family

ID=77766909

Family Applications (2)

Application Number Title Priority Date Filing Date
JP2020170780A Active JP7412315B2 (en) 2020-03-12 2020-10-08 Cost accounting device, cost accounting method, and cost accounting program
JP2023218805A Active JP7602000B2 (en) 2020-03-12 2023-12-26 Cost accounting device, cost accounting method, and cost accounting program

Family Applications Before (1)

Application Number Title Priority Date Filing Date
JP2020170780A Active JP7412315B2 (en) 2020-03-12 2020-10-08 Cost accounting device, cost accounting method, and cost accounting program

Country Status (1)

Country Link
JP (2) JP7412315B2 (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2024179335A (en) * 2023-06-14 2024-12-26 株式会社オービック Royalty management device, royalty management method, and royalty management program

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2016126393A (en) 2014-12-26 2016-07-11 株式会社タツノ Gas station management system
JP2017182782A (en) 2016-03-25 2017-10-05 株式会社オービック Journal entry creation device, journal entry creation method, and journal entry creation program
WO2018150646A1 (en) 2017-02-20 2018-08-23 三菱電機株式会社 Consolidated management control apparatus, consolidated management control assistance system, consolidated management control assistance method, and program
JP2019021053A (en) 2017-07-18 2019-02-07 株式会社オービック Gross profit calculating apparatus, gross profit calculating method, and gross profit calculating program
JP2019219924A (en) 2018-06-20 2019-12-26 株式会社オービック Journal creation device, journal creation method, and journal creation program

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8221636B2 (en) * 2008-05-12 2012-07-17 Headway Technologies, Inc. Method of manufacturing magnetic head for perpendicular magnetic recording

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2016126393A (en) 2014-12-26 2016-07-11 株式会社タツノ Gas station management system
JP2017182782A (en) 2016-03-25 2017-10-05 株式会社オービック Journal entry creation device, journal entry creation method, and journal entry creation program
WO2018150646A1 (en) 2017-02-20 2018-08-23 三菱電機株式会社 Consolidated management control apparatus, consolidated management control assistance system, consolidated management control assistance method, and program
US20190378064A1 (en) 2017-02-20 2019-12-12 Mitsubishi Electric Corporation Consolidated management control apparatus, consolidated management control assistance system, consolidated management control assistance method, and non-transitory computer-readable recording medium
JP2019021053A (en) 2017-07-18 2019-02-07 株式会社オービック Gross profit calculating apparatus, gross profit calculating method, and gross profit calculating program
JP2019219924A (en) 2018-06-20 2019-12-26 株式会社オービック Journal creation device, journal creation method, and journal creation program

Also Published As

Publication number Publication date
JP7412315B2 (en) 2024-01-12
JP2021144687A (en) 2021-09-24
JP2024023902A (en) 2024-02-21

Similar Documents

Publication Publication Date Title
JP7093434B2 (en) Accounting equipment, accounting methods, and accounting programs
JP7389875B2 (en) Inventory value adjustment device, inventory value adjustment method, and inventory value adjustment program
JP7406361B2 (en) Planned progress rate calculation device, planned progress rate calculation method, and planned progress rate calculation program
JP2024018999A (en) Business support device, business support method, and business support program
JP7602000B2 (en) Cost accounting device, cost accounting method, and cost accounting program
JP7538823B2 (en) Sales management device, sales management program, and sales management method
JP7530329B2 (en) Workers' Accident Insurance Premium Management Device, Workers' Accident Insurance Premium Management Method, and Workers' Accident Insurance Premium Management Program
JP2022155478A (en) Cost management device, cost management method, and cost management program
JP2021152818A (en) Automatic commission accounting device, automatic commission accounting method, and automatic commission accounting program
JP7733043B2 (en) Project management system, project management method, and project management program
JP7764330B2 (en) Ordering plan formulation device, ordering plan formulation method, and ordering plan formulation program
JP7614315B2 (en) Installment sales management device, installment sales management method, and installment sales management program
JP7693062B2 (en) Budget data generation device, budget data generation method, and budget data generation program
JP7618498B2 (en) Fuel oil sales unit price management device, fuel oil sales unit price management method, and fuel oil sales unit price management program
JP7614127B2 (en) Residual value setting claim management device, residual value setting claim management method, and residual value setting claim management program
JP7590366B2 (en) CREDIT MANAGEMENT DEVICE, CREDIT MANAGEMENT METHOD, AND CREDIT MANAGEMENT PROGRAM
JP7812815B2 (en) Accounting management device, accounting management method, and accounting management program
JP7557495B2 (en) Workers' Accident Insurance Renewal Device, Workers' Accident Insurance Renewal Method, and Workers' Accident Insurance Renewal Program
JP7550280B2 (en) Purchase order issuance management device, purchase order issuance management method, and purchase order issuance management program
JP7764420B2 (en) Project income and expenditure management device, project income and expenditure management method, and project income and expenditure 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
JP7837897B2 (en) Planned recovery equipment, planned recovery method, and planned recovery program
JP7280931B2 (en) Information processing device, information processing method, and information processing program
JP7597749B2 (en) Fee calculation device, fee calculation method, and fee calculation program
JP7514783B2 (en) Billing reservation device, billing reservation method, and billing reservation program

Legal Events

Date Code Title Description
A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20240123

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20240123

A977 Report on retrieval

Free format text: JAPANESE INTERMEDIATE CODE: A971007

Effective date: 20241106

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: 20241112

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20241205

R150 Certificate of patent or registration of utility model

Ref document number: 7602000

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150