JP2021144687A - Next-month cost accounting device, next-month cost accounting method and next-month cost accounting program - Google Patents

Next-month cost accounting device, next-month cost accounting method and next-month cost accounting program Download PDF

Info

Publication number
JP2021144687A
JP2021144687A JP2020170780A JP2020170780A JP2021144687A JP 2021144687 A JP2021144687 A JP 2021144687A JP 2020170780 A JP2020170780 A JP 2020170780A JP 2020170780 A JP2020170780 A JP 2020170780A JP 2021144687 A JP2021144687 A JP 2021144687A
Authority
JP
Japan
Prior art keywords
month
inventory
data
amount
current month
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
JP2020170780A
Other languages
Japanese (ja)
Other versions
JP7412315B2 (en
Inventor
大介 伊藤
Daisuke Ito
大介 伊藤
敦史 志水
Atsushi Shimizu
敦史 志水
剛光 上野
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 JP2021144687A publication Critical patent/JP2021144687A/en
Priority to JP2023218805A priority Critical patent/JP2024023902A/en
Application granted granted Critical
Publication of JP7412315B2 publication Critical patent/JP7412315B2/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)

Abstract

To provide a next-month cost accounting device, a next-month cost accounting method and a next-month cost accounting program that can contribute to real-time grasping of prime costs and grasping of profit by referring to the latest data at the point of time before stock data of the current month is determined so as to account costs as advance report values.SOLUTION: In a next-month cost accounting device 100, an ordering acquisition part 102b acquires ordering data which have current-month ordered quantities of articles and current-month ordered amounts set, a purchase schedule acquisition part 102c acquires, based upon the ordering data, purchase schedule data which have current-month purchase quantities of the articles, current-month purchase amounts, and current-month sundry expenses set, and a stock acquisition part 102d acquires, before monthly totaling processing is completed, previous-month stock data with previous-month stock quantities of the articles and previous-month stock amounts of money set, and then calculates stock evaluation unit-price advance report values of the articles based upon the ordering data, purchase schedule data, and previous-month stock data.SELECTED DRAWING: Figure 2

Description

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

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

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

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

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

上述した課題を解決し、目的を達成するために、本発明に係る翌月原価計算装置は、記憶部と制御部とを備えた翌月原価計算装置であって、前記制御部は、商品の当月発注数および当月発注金額を設定した発注データを取得する発注取得手段と、前記発注データに基づいて、前記商品の当月仕入数、当月仕入金額、および、当月諸掛金額を設定した仕入予定データを取得する仕入予定取得手段と、月次締め処理の完了前において、前記商品の前月末在庫数、および、前月末在庫金額を設定した前月在庫データを取得する在庫取得手段と、前記発注データ、前記仕入予定データ、および、前記前月在庫データに基づいて、前記商品の在庫評価単価速報値を算出する在庫評価単価算出手段と、を備えたことを特徴とする。 In order to solve the above-mentioned problems and achieve the object, the next-month cost calculation device according to the present invention is a next-month cost calculation device including a storage unit and a control unit, and the control unit places an order for goods in the current month. An order acquisition means for acquiring order data for which the number and the order amount for the current month are set, and a purchase schedule for which the number of purchases for the product in the current month, the purchase amount for the current month, and the various charges for the current month are set based on the order data. The purchase schedule acquisition means for acquiring data, the inventory acquisition means for acquiring the previous month 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, and the ordering. It is characterized by including an inventory valuation unit price calculation means for calculating an inventory valuation unit price preliminary value of the product based on the data, the purchase schedule data, and the previous month inventory data.

また、本発明に係る翌月原価計算装置において、前記在庫評価単価算出手段は、前記前月末在庫金額と前記当月仕入金額と前記当月諸掛金額と前記当月発注金額との合計を被除数とし、前記前月末在庫数と前記当月仕入数と前記当月発注数との合計を除数とした場合の商を前記在庫評価単価速報値として算出することを特徴とする。 Further, in the next month cost accounting device according to the present invention, the inventory valuation unit price calculation means uses the sum of the inventory amount at the end of the previous month, the purchase amount for the current month, the various charges for the current month, and the order amount for the current month as the dividend. It is characterized in that the quotient when the sum of the number of stocks at the end of the previous month, the number of purchases in the current month, and the number of orders in the current month is a divisor is calculated as the preliminary inventory valuation unit price.

また、本発明に係る翌月原価計算装置において、前記制御部は、商品の当月受注数および当月受注金額を設定した受注データを取得する受注取得手段、を更に備え、前記在庫取得手段は、更に、前記前月在庫データ、前記仕入予定データ、前記受注データ、および、前記在庫評価単価速報値に基づいて、当月末在庫数、および、当月末在庫金額を設定した当月末在庫データを取得することを特徴とする。 Further, in the next month cost calculation device according to the present invention, the control unit further includes an order acquisition means for acquiring order data in which the number of orders received for the current month and the order amount for the current month are set, and the inventory acquisition means further includes. Based on the previous month's inventory data, the purchase schedule data, the order data, and the inventory valuation unit price preliminary value, the end-of-month inventory quantity and the end-of-month inventory data for which the end-of-month inventory amount is set can be acquired. It is a feature.

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

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

また、本発明に係る翌月原価計算装置において、前記在庫取得手段は、更に、前記月次締め処理が完了した場合、前月末在庫確定数、および、前月末在庫確定金額を設定した前月在庫確定データを取得し、前記在庫評価単価算出手段は、前記前月末在庫確定金額と前記当月仕入金額と前記当月諸掛金額との合計を被除数とし、前記前月末在庫確定数と前記当月仕入数との合計を除数とした場合の商を在庫評価単価として算出することを特徴とする。 Further, in the next-month cost calculation device according to the present invention, when the monthly closing process is completed, the inventory acquisition means further sets the last-month inventory confirmation number and the previous-month inventory confirmation amount. Is acquired, and the inventory valuation unit price calculation means uses the sum of the inventory fixed amount at the end of the previous month, the purchase amount for the current month, and the various contributions for the current month as the dividend, and the inventory fixed amount at the end of the previous month and the purchase number for the current month. It is characterized in that the quotient when the total of is used as a divisor is calculated as the inventory valuation unit price.

また、本発明に係る翌月原価計算方法は、記憶部と制御部とを備えた翌月原価計算装置に実行させるための翌月原価計算方法であって、前記制御部で実行させる、商品の当月発注数および当月発注金額を設定した発注データを取得する発注取得ステップと、前記発注データに基づいて、前記商品の当月仕入数、当月仕入金額、および、当月諸掛金額を設定した仕入予定データを取得する仕入予定取得ステップと、月次締め処理の完了前において、前記商品の前月末在庫数、および、前月末在庫金額を設定した前月在庫データを取得する在庫取得ステップと、前記発注データ、前記仕入予定データ、および、前記前月在庫データに基づいて、前記商品の在庫評価単価速報値を算出する在庫評価単価算出ステップと、を含むことを特徴とする。 Further, the next-month cost calculation method according to the present invention is a next-month cost calculation method for causing a next-month cost calculation device including a storage unit and a control unit to execute the next-month cost calculation method, and the number of products ordered in the current month to be executed by the control unit. And the order acquisition step to acquire the order data for which the order amount for the current month is set, and the purchase schedule data for which the number of purchases for the product in the current month, the purchase amount for the current month, and the various charges for the current month are set based on the order data. The purchase schedule acquisition step to acquire the purchase schedule, the inventory acquisition step to acquire the previous month 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, and the order data. , The inventory valuation unit price calculation step for calculating the inventory valuation unit price preliminary value of the product based on the purchase schedule data and the previous month inventory data.

また、本発明に係る翌月原価計算プログラムは、記憶部と制御部とを備えた翌月原価計算装置に実行させるための翌月原価計算プログラムであって、前記制御部において、商品の当月発注数および当月発注金額を設定した発注データを取得する発注取得ステップと、前記発注データに基づいて、前記商品の当月仕入数、当月仕入金額、および、当月諸掛金額を設定した仕入予定データを取得する仕入予定取得ステップと、月次締め処理の完了前において、前記商品の前月末在庫数、および、前月末在庫金額を設定した前月在庫データを取得する在庫取得ステップと、前記発注データ、前記仕入予定データ、および、前記前月在庫データに基づいて、前記商品の在庫評価単価速報値を算出する在庫評価単価算出ステップと、を実行させることを特徴とする。 Further, the next month cost calculation program according to the present invention is a next month cost calculation program for being executed by a next month cost calculation device including a storage unit and a control unit, and the control unit controls the number of orders for the current month and the current month. Acquire the order acquisition step to acquire the order data with the order amount set, and acquire the purchase schedule data with the current month purchase number, current month purchase amount, and current month various charges based on the order data. The purchase schedule acquisition step to be performed, the inventory acquisition step to 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 order data, and the above. It is characterized in that the inventory valuation unit price calculation step of calculating the inventory valuation unit price preliminary value of the product based on the purchase schedule data and the previous month's inventory data is executed.

本発明によれば、前月のシステム締処理が未実行の場合でも、当月の原価計算処理を実行できるという効果を奏する。また、本発明によれば、在庫評価単価を求めるための受払対象に、当月計上予定の受注データおよび発注データを含めることで、在庫評価単価の速報値を提示することができるという効果を奏する。また、本発明によれば、計算される在庫評価単価および在庫金額をその時点における登録データとして取得できるという効果を奏する。また、本発明によれば、前月の在庫データが確定する前であっても、その時点の最新の値およびデータを参照して、速報値としての原価計算を行うことで、よりリアルタイムな原価把握および利益把握に貢献することができるという効果を奏する。また、本発明によれば、従来、月次締めまで当月分の粗利の確認不可であったが、各取引の粗利を早期に把握可能となるという効果を奏する。また、本発明によれば、原価の見通しを早期に立てられることにより、営業・販売戦略や購買戦略を早期に見直すことを可能とするという効果を奏する。また、本発明によれば、対象データに受注データおよび発注データを含めることで、将来の着地予想、すなわち、原価シミュレーションを効率的に実現できるという効果を奏する。 According to the present invention, even if the system closing process of the previous month has not been executed, the cost accounting process of the current month can be executed. Further, according to the present invention, by including the order data and the order data scheduled to be recorded in the current month in the receipt / payment target for obtaining the inventory valuation unit price, it is possible to present the preliminary value of the inventory valuation unit price. Further, according to the present invention, there is an effect that the calculated inventory valuation unit price and inventory amount can be acquired as registration data at that time. Further, according to the present invention, even before the inventory data of the previous month is fixed, the cost is calculated as a preliminary value by referring to the latest value and data at that time, so that the cost can be grasped in more real time. And it has the effect of being able to contribute to grasping profits. Further, according to the present invention, conventionally, the gross profit for the current month cannot be confirmed until the monthly closing, but the gross profit for each transaction can be grasped at an early stage. Further, according to the present invention, it is possible to review the sales / sales strategy and the purchasing strategy at an early stage by making an early forecast of the cost price. Further, according to the present invention, by including the order data and the order data in the target data, it is possible to efficiently realize the future landing forecast, that is, the cost simulation.

図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 the next month cost accounting device according to the present embodiment. 図3は、本実施形態における翌月原価計算装置の処理の一例を示すフローチャートである。FIG. 3 is a flowchart showing an example of processing of the next month cost accounting device in the present embodiment. 図4は、本実施形態における原価計算処理の一例を示す図である。FIG. 4 is a diagram showing an example of cost accounting processing in the present embodiment. 図5は、本実施形態における原価計算処理の一例を示す図である。FIG. 5 is a diagram showing an example of cost accounting processing in 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を参照して、本発明の概要を説明する。図1は、従来の原価計算処理の一例を示す図である。
[1. Overview]
First, the outline of the present invention will be described with reference to FIG. FIG. 1 is a diagram showing an example of a conventional cost accounting process.

従来、商品の実際原価は、在庫データに基づいて、算出・管理されており、月次締めである月次確定処理後にシステム会計年月の更新が行われ、原価計算処理が日次処理として実行されていた。また、従来、商品の在庫評価単価は、原価計算処理を実行することで、システム会計年月の当月を対象に、最新の在庫受払データが集計・算出され、算出された在庫評価単価に基づいて、売上データの売上原価データを洗い替えることで、実際原価に基づく粗利の把握をしていた。 Conventionally, the actual cost of goods is calculated and managed based on inventory data, and the system accounting year and month are updated after the monthly finalization process, which is the monthly closing, and the cost calculation process is executed as a daily process. It had been. In addition, conventionally, the inventory valuation unit price of a product is calculated based on the calculated inventory valuation unit price by aggregating and calculating the latest inventory receipt / payment data for the current month of the system accounting date by executing cost calculation processing. By reviewing the cost of sales data in the sales data, the gross profit was grasped based on the actual cost.

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

例えば、従来、図1に示すように、当月の月次締業務、および、締処理が月末から5営業日で実施されており、実際の年月が2020年1月、且つ、システム上の会計年月が2019年12月の期間において、月末に仕入予定の商品が(海外取引などの影響で)月をまたいで仕入されることが多く発生するような場合でも、2019年12月の月次締業務が完了していないため、2019年12月末の在庫金額が確定しておらず、2020年1月予定の受発注残を加味した2020年1月の原価計算が実行されないため(図中の黒丸)、経営指標としての日次での取引の売買実績および売上総利益が確認できず、取引の着地予想もできなかった。 For example, as shown in Fig. 1, the monthly closing work and closing process of the current month have been carried out within 5 business days from the end of the month, the actual date is January 2020, and the accounting on the system. In the period of December 2019, even if the products scheduled to be purchased at the end of the month are often purchased across months (due to the influence of overseas transactions, etc.), in December 2019 Since the monthly closing work has not been completed, the inventory amount at the end of December 2019 has not been finalized, and the cost calculation for January 2020, which takes into account the order backlog scheduled for January 2020, is not executed (Fig.). (Black circle in the middle), I could not confirm the trading record and total sales profit of the daily transaction as a management index, and I could not predict the landing of the transaction.

そこで、本実施形態において、前月の在庫データが確定する前であっても、その時点の最新データを参照して、原価計算を行うことで、速報性をもった原価把握および利益把握を可能とする仕組みを提供している。 Therefore, in the present embodiment, even before the inventory data of the previous month is finalized, it is possible to grasp the cost and the profit with breaking news by performing the cost calculation with reference to the latest data at that time. It provides a mechanism to do.

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

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

翌月原価計算装置100は、制御部102と通信インターフェース部104と記憶部106と入出力インターフェース部108と、を備えている。翌月原価計算装置100が備えている各部は、任意の通信路を介して通信可能に接続されている。 The next month cost accounting 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 device 100 for the next month is communicably connected via an arbitrary communication path.

通信インターフェース部104は、ルータ等の通信装置および専用線等の有線または無線の通信回線を介して、翌月原価計算装置100をネットワーク300に通信可能に接続する。通信インターフェース部104は、他の装置と通信回線を介してデータを通信する機能を有する。ここで、ネットワーク300は、翌月原価計算装置100とサーバ200とを相互に通信可能に接続する機能を有し、例えばインターネットやLAN(Local Area Network)等である。 The communication interface unit 104 connects the cost accounting device 100 to the network 300 in a communicable manner the following month 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 device 100 and the server 200 to each other so as to be able to communicate with each other in the next month, 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を備えている。 Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving a command 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. The storage unit 106 includes a transaction database 106a.

取引データベース106aは、取引データを記憶する。ここで、取引データは、商品の発注データ、受注データ、仕入予定データ、前月在庫データ、当月末在庫データ、月別在庫データ、月別在庫評価単価データ、および/または、前月在庫確定データ等を含んでいてもよい。ここで、発注データは、会計年月、商品名、発注日、仕入予定日、発注数、および/または、発注金額等が設定されていてもよい。また、受注データは、会計年月、商品名、受注日、売上予定日、受注数、および/または、受注金額等が設定されていてもよい。また、月別在庫データは、会計年月、商品名、前月末在庫数、前月末在庫金額、当月仕入数、当月仕入金額、当月諸掛金額、当月売上数、当月末在庫数、および/または、当月末在庫金額等が設定されていてもよい。また、月別在庫評価単価データは、会計年月、商品名、および/または、在庫評価単価等が設定されていてもよい。 The transaction database 106a stores transaction data. Here, the transaction data includes product order data, order data, purchase schedule data, previous month inventory data, end-of-month inventory data, monthly inventory data, monthly inventory valuation unit price data, and / or previous month inventory confirmation data, etc. You may be. Here, in the order data, the fiscal year / month, the product name, the order date, the scheduled purchase date, the number of orders, and / or the order amount may be set. Further, in the order data, the accounting date, the product name, the order date, the planned sales date, the number of orders, and / or the order amount may be set. In addition, monthly inventory data includes accounting year / month, product name, number of items in stock at the end of the previous month, amount of inventory at the end of the previous month, number of purchases in the current month, amount of purchases in the current month, amount of expenses in the current month, number of sales in the current month, number of items in stock at the end of the month, and / Alternatively, the inventory amount at the end of the month may be set. Further, in the monthly inventory valuation unit price data, the fiscal year and month, the product name, and / or the inventory valuation unit price and the like may be set.

入出力インターフェース部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. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a touch panel). 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 or a printer 114, and the input device 112 may be referred to as a keyboard 112 or a 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 comprehensively controls the cost accounting device 100 for the next month. 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 conceptually includes an order acquisition unit 102a, an order acquisition unit 102b, a purchase schedule acquisition unit 102c, an inventory acquisition unit 102d, an inventory valuation unit price calculation unit 102e, and a monthly inventory registration unit 102f.

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

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

仕入予定取得部102cは、商品の仕入予定データを取得する。ここで、仕入予定取得部102cは、発注データに基づいて、商品の当月仕入数、当月仕入金額、および、当月諸掛金額を設定した仕入予定データを取得してもよい。また、仕入予定取得部102cは、仕入予定データを取引データベース106aに登録してもよい。 The purchase schedule acquisition unit 102c acquires the purchase schedule data of the product. Here, the purchase schedule acquisition unit 102c may acquire the purchase schedule data in which the number of products purchased in the current month, the purchase amount in the current month, and the various charges in the current month are set based on the order data. Further, 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 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. In addition, the inventory acquisition unit 102d sets the end-of-month inventory quantity and the end-of-month inventory amount of the product based on the previous month inventory data, purchase schedule data, order data, and inventory valuation unit price preliminary value. Data may be acquired. In addition, the inventory acquisition unit 102d sets a value obtained by subtracting the number of orders received in the current month from the total of the number of stocks of the product at the end of the previous month and the number of purchases in the current month as the number of stocks of the product at the end of the current month, and sets the inventory evaluation unit price preliminary value. You may acquire the inventory data at the end of the month in which the product with the inventory quantity at the end of the month is set as the inventory amount at the end of the month. Further, when the monthly closing process is completed, the inventory acquisition unit 102d acquires the inventory confirmation number of the product at the end of the previous month and the inventory confirmation data of the previous month in which the inventory confirmation amount at the end of the previous month is set, and the inventory acquisition unit 102d obtains the inventory confirmation data of the previous month. , Inventory data and the like may be registered 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 preliminary value of the product. Here, the inventory valuation unit price calculation unit 102e may calculate the inventory valuation unit price preliminary value of the product based on the order data, the purchase schedule data, and the previous month's inventory data. In addition, the inventory valuation unit price calculation unit 102e uses the sum of the inventory amount at the end of the previous month, the purchase amount at the current month, the various charges for the current month, and the order amount at the current month as the division number, and the inventory quantity at the end of the previous month, the purchase quantity at the current month, and the order quantity at the current month. The quotient when the sum of and is a divisor may be calculated as an inventory valuation unit price preliminary value. In addition, the inventory valuation unit price calculation unit 102e uses the sum of the inventory fixed amount at the end of the previous month, the purchase amount of the current month, and the various contributions of the current month as the divisor, and the sum of the inventory confirmed number at the end of the previous month and the purchase number of the current month as the divisor. The quotient in the case of the above may be calculated as the inventory valuation unit price. Further, the inventory valuation unit price calculation unit 102e may register the inventory valuation unit price preliminary value and / or the inventory valuation unit price in the transaction database 106a.

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

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

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

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

そして、発注取得部102bは、月次締め処理の完了前において、商品の当月発注数および当月発注金額を設定した発注データを取得し、発注データを取引データベース106aに登録する(ステップSA−2)。 Then, the order acquisition unit 102b acquires the order data in which the number of orders for the current month and the order amount for the current month are set before the completion of the monthly closing process, 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 the purchase schedule data in which the number of products purchased in the current month, the purchase amount in the current month, and the various charges in the current month are set based on the order data, and obtains the purchase schedule data. Register in the transaction database 106a (step SA-3).

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

そして、在庫評価単価算出部102eは、商品の前月末在庫金額と当月仕入金額と当月諸掛金額と当月発注金額との合計を被除数とし、前月末在庫数と当月仕入数と当月発注数との合計を除数とした場合の商を在庫評価単価速報値として算出し、在庫評価単価速報値を取引データベース106aに登録する(ステップSA−5)。 Then, the inventory valuation unit price calculation unit 102e uses the sum of the inventory amount at the end of the previous month, the purchase amount at the current month, the various charges for the current month, and the order amount for the current month as the dividends, and 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. The quotient when the sum of and is a divisor is calculated as the inventory valuation unit price preliminary value, and the inventory valuation unit price preliminary value is registered in the transaction database 106a (step SA-5).

そして、在庫取得部102dは、商品の前月末在庫数と当月仕入数との合計から、商品の当月受注数を差し引いた値を商品の当月末在庫数として設定し、在庫評価単価速報値と当月末在庫数との積を当月末在庫金額として設定した当月末在庫データを取得し、当月末在庫データを取引データベース106aに登録する(ステップSA−6)。 Then, the inventory acquisition unit 102d sets a value obtained by subtracting the number of orders received in the current month from the total of the number of stocks of the product at the end of the previous month and the number of purchases in the current month as the number of stocks of the product at the end of the current month, and sets the inventory evaluation unit price preliminary value. The inventory data at the end of the month, in which the product with the number of inventories at the end of the month is set as the inventory amount at the end of the month, is acquired, and the inventory data at the end of the month is registered 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 inventory confirmation data in which the previous month end-of-month inventory confirmation number and the previous month end-of-month inventory confirmation amount are set, and the previous month inventory confirmation data is stored in the transaction database. Register with 106a (step SA-7).

そして、在庫評価単価算出部102eは、商品の前月末在庫確定金額と当月仕入金額と当月諸掛金額との合計を被除数とし、前月末在庫確定数と当月仕入数との合計を除数とした場合の商を在庫評価単価として算出し、在庫評価単価を取引データベース106aに登録し(ステップSA−8)、処理を終了する。 Then, the inventory valuation unit price calculation unit 102e sets the sum of the inventory fixed amount at the end of the previous month, the purchase amount of the current month, and the various contributions of the current month as the dividend, and the total of the inventory fixed amount at the end of the previous month and the purchase number of the current month as the divisor. The quotient in the case of the above is calculated as the inventory valuation unit price, the inventory valuation unit price is registered in the transaction database 106a (step SA-8), and the process is terminated.

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

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

更に、図5に示すように、本実施形態においては、2020年1月初頭(2019年12月の月次締め処理の完了前)において、会計システム当月(2019年12月)の当月末在庫数および当月末在庫金額が速報値として取得され、2020年1月の前月末在庫数および前月末在庫金額の速報値として月別在庫テーブルに登録される。そして、図5に示すように、本実施形態においては、発注テーブルから2020年1月中の仕入予定となる当月発注数および当月発注金額が取得され、「在庫評価単価速報値=(前月末在庫金額+当月仕入金額+当月諸掛金額+当月発注金額)÷(前月末在庫数+当月仕入数+当月発注数)」と計算され、受注テーブルから2020年1月中の売上予定となる当月受注数が取得され、「当月末在庫数=前月末在庫数+当月仕入数−当月売上数」と計算され、「当月末在庫金額=在庫評価単価速報値×当月末在庫数」と計算されることで、月別在庫テーブルに当月末在庫数および当月末在庫金額が速報値として反映される。このように、本実施形態においては、発注テーブルの仕入予定日が実際の年月(2020年1月)に含まれるデータ(当月発注金額および当月発注数)を在庫評価単価速報値の計算に含めてもよい。 Further, as shown in FIG. 5, in the present embodiment, at the beginning of January 2020 (before the completion of the monthly closing process in December 2019), the number of inventories at the end of the current month of the accounting system (December 2019). And the inventory value at the end of the current month is acquired as a preliminary value, and is registered in the monthly inventory table as the preliminary value of the inventory quantity at the end of the previous month and the inventory value at the end of the previous month in January 2020. Then, as shown in FIG. 5, in the present embodiment, the number of orders placed in the current month and the order amount in the current month scheduled to be purchased in January 2020 are acquired from the ordering table, and "inventory evaluation unit price preliminary value = (end of the previous month)". "Inventory amount + current month purchase amount + current month various charges + current month order amount) / (inventory quantity at the end of the previous month + current month purchase quantity + current month order quantity)" The number of orders received this month is acquired, and it is calculated as "Inventory at the end of the month = Inventory at the end of the previous month + Purchases at the end of the month-Sales at the end of the month" By being calculated, the number of stocks at the end of the month and the amount of stock at the end of the month are reflected as preliminary values in the monthly inventory table. As described above, in the present embodiment, the data (order amount for the current month and the number of orders for the current month) in which the planned purchase date of the order table is included in the actual date (January 2020) is used for calculating the inventory valuation unit price preliminary value. May be included.

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

[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 device 100 for the next month, 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, with respect to the processing functions included in the cost accounting device 100 for the next month, particularly each processing function performed by the control unit 102, 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 the cost is calculated the following month 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 the application program server connected to the cost accounting device 100 via an arbitrary network the next month, 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. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the present embodiment, the installation procedure after reading, and the like.

記憶部106に格納される各種のデータベース等は、RAM、ROM等のメモリ装置、ハードディスク等の固定ディスク装置、フレキシブルディスク、および、光ディスク等のストレージ手段であり、各種処理やウェブサイト提供に用いる各種のプログラム、テーブル、データベース、および、ウェブページ用ファイル等を格納する。 Various databases and the like stored in the storage unit 106 are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, 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 next month 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 an arbitrary peripheral device is connected. Further, the next month cost accounting 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.

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

100 翌月原価計算装置
102 制御部
102a 受注取得部
102b 発注取得部
102c 仕入予定取得部
102d 在庫取得部
102e 在庫評価単価算出部
102f 月別在庫登録部
104 通信インターフェース部
106 記憶部
106a 取引データベース
108 入出力インターフェース部
112 入力装置
114 出力装置
200 サーバ
300 ネットワーク
100 Next month 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 valuation 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)

記憶部と制御部とを備えた翌月原価計算装置であって、
前記制御部は、
商品の当月発注数および当月発注金額を設定した発注データを取得する発注取得手段と、
前記発注データに基づいて、前記商品の当月仕入数、当月仕入金額、および、当月諸掛金額を設定した仕入予定データを取得する仕入予定取得手段と、
月次締め処理の完了前において、前記商品の前月末在庫数、および、前月末在庫金額を設定した前月在庫データを取得する在庫取得手段と、
前記発注データ、前記仕入予定データ、および、前記前月在庫データに基づいて、前記商品の在庫評価単価速報値を算出する在庫評価単価算出手段と、
を備えたことを特徴とする翌月原価計算装置。
It is a cost accounting device for the next month equipped with a storage unit and a control unit.
The control unit
An order acquisition method for acquiring order data that sets the number of orders for the current month and the order amount for the current month,
Based on the order data, the purchase schedule acquisition means for acquiring the purchase schedule data in which the current month purchase number, the current month purchase amount, and the current month various charges amount of the product are set, and
Before the completion of the monthly closing process, the inventory acquisition means for acquiring the inventory quantity of the product at the end of the previous month and the inventory data of the previous month for which the inventory amount at the end of the previous month is set, and
An inventory valuation unit price calculation means for calculating an inventory valuation unit price preliminary value of the product based on the order data, the purchase schedule data, and the previous month inventory data.
Next month cost accounting device featuring.
前記在庫評価単価算出手段は、
前記前月末在庫金額と前記当月仕入金額と前記当月諸掛金額と前記当月発注金額との合計を被除数とし、前記前月末在庫数と前記当月仕入数と前記当月発注数との合計を除数とした場合の商を前記在庫評価単価速報値として算出することを特徴とする請求項1に記載の翌月原価計算装置。
The inventory valuation unit price calculation means is
The sum of the inventory amount at the end of the previous month, the purchase amount for the current month, the various charges for the current month, and the order amount for the current month is used as the dividend, and the total of the inventory amount at the end of the previous month, the purchase amount for the current month, and the order quantity for the current month is the divisor. The next month cost accounting device according to claim 1, wherein the quotient in the case of is calculated as the inventory valuation unit price preliminary value.
前記制御部は、
商品の当月受注数および当月受注金額を設定した受注データを取得する受注取得手段、
を更に備え、
前記在庫取得手段は、
更に、前記前月在庫データ、前記仕入予定データ、前記受注データ、および、前記在庫評価単価速報値に基づいて、当月末在庫数、および、当月末在庫金額を設定した当月末在庫データを取得することを特徴とする請求項1または2に記載の翌月原価計算装置。
The control unit
Order acquisition means for acquiring order data that sets the number of orders received for the current month and the order amount for the current month,
Further prepare
The inventory acquisition means is
Further, based on the previous month's inventory data, the purchase schedule data, the order data, and the inventory valuation unit price preliminary value, the inventory quantity at the end of the current month and the inventory data at the end of the current month in which the inventory amount at the end of the current month is set are acquired. The next month costing apparatus according to claim 1 or 2.
前記在庫取得手段は、
前記前月末在庫数と前記当月仕入数との合計から、前記当月受注数を差し引いた値を前記当月末在庫数として設定し、前記在庫評価単価速報値と前記当月末在庫数との積を前記当月末在庫金額として設定した前記当月末在庫データを取得することを特徴とする請求項3に記載の翌月原価計算装置。
The inventory acquisition means is
The value obtained by subtracting the number of orders received in the current month from the total of the number of stocks at the end of the previous month and the number of purchases in the current month is set as the number of stocks at the end of the current month, and the product of the preliminary inventory valuation unit price and the number of stocks at the end of the month is calculated. The next month cost calculation device according to claim 3, wherein the inventory data at the end of the current month, which is set as the inventory amount at the end of the current month, is acquired.
前記制御部は、
売上予定となる前記当月受注数を当月売上数として取得し、前記前月末在庫数、前記前月末在庫金額、前記当月仕入数、前記当月仕入金額、前記当月売上数、前記当月末在庫数、および、前記当月末在庫金額を設定した月別在庫データを前記記憶部に登録する月別在庫登録手段、
を更に備えたことを特徴とする請求項4に記載の翌月原価計算装置。
The control unit
The number of orders received in the current month, which is scheduled to be sold, is acquired as the number of sales in the current month, and the number of inventories at the end of the previous month, the amount of inventory at the end of the previous month, the number of purchases in the current month, the amount of purchases in the current month, the number of sales in the current month, and the number of inventories at the end of the current month. , And the monthly inventory registration means for registering the monthly inventory data for which the inventory amount at the end of the current month is set in the storage unit.
The next month cost accounting device according to claim 4, further comprising.
前記在庫取得手段は、
更に、前記月次締め処理が完了した場合、前月末在庫確定数、および、前月末在庫確定金額を設定した前月在庫確定データを取得し、
前記在庫評価単価算出手段は、
前記前月末在庫確定金額と前記当月仕入金額と前記当月諸掛金額との合計を被除数とし、前記前月末在庫確定数と前記当月仕入数との合計を除数とした場合の商を在庫評価単価として算出することを特徴とする請求項1から5のいずれか一つに記載の翌月原価計算装置。
The inventory acquisition means is
Furthermore, when the monthly closing process is completed, the previous month's inventory confirmation data in which the number of confirmed inventory at the end of the previous month and the fixed amount of inventory at the end of the previous month are set is acquired.
The inventory valuation unit price calculation means is
Inventory valuation is the quotient when the sum of the final inventory amount at the end of the previous month, the purchase amount for the current month, and the various contributions for the current month is the divisor, and the sum of the fixed inventory amount at the end of the previous month and the purchase amount for the current month is the divisor. The next month costing apparatus according to any one of claims 1 to 5, wherein the unit price is calculated.
記憶部と制御部とを備えた翌月原価計算装置に実行させるための翌月原価計算方法であって、
前記制御部で実行させる、
商品の当月発注数および当月発注金額を設定した発注データを取得する発注取得ステップと、
前記発注データに基づいて、前記商品の当月仕入数、当月仕入金額、および、当月諸掛金額を設定した仕入予定データを取得する仕入予定取得ステップと、
月次締め処理の完了前において、前記商品の前月末在庫数、および、前月末在庫金額を設定した前月在庫データを取得する在庫取得ステップと、
前記発注データ、前記仕入予定データ、および、前記前月在庫データに基づいて、前記商品の在庫評価単価速報値を算出する在庫評価単価算出ステップと、
を含むことを特徴とする翌月原価計算方法。
It is a next-month cost accounting method for executing the next-month cost accounting device having a storage unit and a control unit.
It is executed by the control unit.
The order acquisition step to acquire the order data that sets the number of orders for the current month and the order amount for the current month,
Based on the order data, the purchase schedule acquisition step for acquiring the purchase schedule data for which the current month purchase quantity, the current month purchase amount, and the current month various charges amount of the product are set, and the purchase schedule acquisition step.
Before the completion of the monthly closing process, the inventory acquisition step of acquiring 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, and
An inventory valuation unit price calculation step for calculating an inventory valuation unit price preliminary value of the product based on the order data, the purchase schedule data, and the previous month inventory data.
Next month costing method characterized by including.
記憶部と制御部とを備えた翌月原価計算装置に実行させるための翌月原価計算プログラムであって、
前記制御部において、
商品の当月発注数および当月発注金額を設定した発注データを取得する発注取得ステップと、
前記発注データに基づいて、前記商品の当月仕入数、当月仕入金額、および、当月諸掛金額を設定した仕入予定データを取得する仕入予定取得ステップと、
月次締め処理の完了前において、前記商品の前月末在庫数、および、前月末在庫金額を設定した前月在庫データを取得する在庫取得ステップと、
前記発注データ、前記仕入予定データ、および、前記前月在庫データに基づいて、前記商品の在庫評価単価速報値を算出する在庫評価単価算出ステップと、
を実行させるための翌月原価計算プログラム。
It is a next-month costing program to be executed by a next-month costing device equipped with a storage unit and a control unit.
In the control unit
The order acquisition step to acquire the order data that sets the number of orders for the current month and the order amount for the current month,
Based on the order data, the purchase schedule acquisition step for acquiring the purchase schedule data for which the current month purchase quantity, the current month purchase amount, and the current month various charges amount of the product are set, and the purchase schedule acquisition step.
Before the completion of the monthly closing process, the inventory acquisition step of acquiring 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, and
An inventory valuation unit price calculation step for calculating an inventory valuation unit price preliminary value of the product based on the order data, the purchase schedule data, and the previous month inventory data.
Next month costing program to run.
JP2020170780A 2020-03-12 2020-10-08 Cost accounting device, cost accounting method, and cost accounting program Active JP7412315B2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
JP2023218805A JP2024023902A (en) 2020-03-12 2023-12-26 Cost price calculation device, cost price calculation method and cost price calculation program

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
JP2020043387 2020-03-12
JP2020043387 2020-03-12

Related Child Applications (1)

Application Number Title Priority Date Filing Date
JP2023218805A Division JP2024023902A (en) 2020-03-12 2023-12-26 Cost price calculation device, cost price calculation method and cost price calculation program

Publications (2)

Publication Number Publication Date
JP2021144687A true JP2021144687A (en) 2021-09-24
JP7412315B2 JP7412315B2 (en) 2024-01-12

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 Pending JP2024023902A (en) 2020-03-12 2023-12-26 Cost price calculation device, cost price calculation method and cost price calculation program

Family Applications After (1)

Application Number Title Priority Date Filing Date
JP2023218805A Pending JP2024023902A (en) 2020-03-12 2023-12-26 Cost price calculation device, cost price calculation method and cost price calculation program

Country Status (1)

Country Link
JP (2) JP7412315B2 (en)

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2009277333A (en) * 2008-05-12 2009-11-26 Headway Technologies Inc Method of manufacturing magnetic head for perpendicular magnetic recording
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

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2009277333A (en) * 2008-05-12 2009-11-26 Headway Technologies Inc Method of manufacturing magnetic head for perpendicular magnetic recording
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

Also Published As

Publication number Publication date
JP7412315B2 (en) 2024-01-12
JP2024023902A (en) 2024-02-21

Similar Documents

Publication Publication Date Title
JP7093434B2 (en) Accounting equipment, accounting methods, and accounting programs
JP7068940B2 (en) Journal creation device, journal creation method and journal creation program
JP7197989B2 (en) Progress rate calculation device, progress rate calculation method, and progress rate calculation program
JP7389875B2 (en) Inventory value adjustment device, inventory value adjustment method, and inventory value adjustment program
JP7060951B2 (en) Rebate management device, rebate management method, and rebate management program
JP6850160B2 (en) Payroll processing device, payroll correction processing method, and payroll correction processing program
JP7025854B2 (en) Gross profit calculator, gross profit calculation method and gross profit calculation program
JP6872368B2 (en) Amount calculation device, amount calculation method and amount calculation program
JP2021144687A (en) Next-month cost accounting device, next-month cost accounting method and next-month cost accounting program
JP7406361B2 (en) Planned progress rate calculation device, planned progress rate calculation method, and planned progress rate calculation program
JP7028577B2 (en) Construction price processing equipment, construction price processing method, and construction price processing program
JP2021077284A (en) Device, method, and program for transferring generated cost
JP2021152818A (en) Automatic commission accounting device, automatic commission accounting method, and automatic commission accounting program
JP7280931B2 (en) Information processing device, information processing method, and information processing program
JP7410808B2 (en) Journal switching device, journal switching method, and journal switching program
JP7291088B2 (en) Slip Closing Support Device, Slip Closing Support Method, and Slip Closing Support Program
JP7303762B2 (en) ACCOUNTING PROCESSING DEVICE, ACCOUNTING PROCESSING METHOD, AND ACCOUNTING PROCESSING PROGRAM
JP7157563B2 (en) Amount calculation device, amount calculation method, and amount calculation program
JP2022084284A (en) Fee allocation data generation device, fee allocation data generation method and fee allocation data generation program
JP2024017968A (en) Business support device, business support method and business support program
JP2023144758A (en) Industrial accident compensation insurance renewal apparatus, industrial accident compensation insurance renewal method, and industrial accident compensation insurance renewal program
JP2022155478A (en) Cost management device, cost management method, and cost management program
JP2021157469A (en) Device, method, and program for managing gross profit
JP2022072460A (en) Credit/debt linkage device, credit/debt linkage method, and credit/debt linkage program
JP2020154490A (en) Amount tabulation device, amount tabulation method and amount tabulation program

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

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20231024

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20231201

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

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20231226

R150 Certificate of patent or registration of utility model

Ref document number: 7412315

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150