基于excelvba的存货成本自动计算程序设计（Automatic calculation program design of inventory cost based on ExcelVBA）.doc

基于excelvba的存货成本自动计算程序设计（Automatic calculation program design of inventory cost based on ExcelVBA） This article is contributed by shuitong2009 Pdf documents may experience poor browsing on the WAP side. It is recommended that you first select TXT, or download the source file to the local view. April 2008 volume eighth, issue eleventh China management informatization ChinaManagementInformationization Apr., 2008Vol.11, No.8 Automatic calculation program design of inventory cost based on ExcelVBA Xue Wu He (Hunan Vocational College of Engineering Department of electricity, Changsha 410114) Abstract: in this paper, the use of the inventory cost calculation of moving average method in larger workload as an example, discusses how to use VBA programming function embedded in Excel to solve the accounting manual calculation is a complex problem, let the financial personnel understand the accounting treatment methods for more data, but is not limited to financial software. Key words: Excel; VBA; inventory cost; calculation of classification procedures that on F232 document code A, the number of(2008)Inventory usually holds a large proportion of the assets or all of the assets, calculate stock quantity and value, directly affect the authenticity of the assets, has a great influence on the cost of inventory and cost of goods sold, directly affect the current and future periods of financial results. According to the current enterprise accounting system, the enterprise inventories shall be accounted for at the actual cost, and the actual cost shall be determined by the first in first out method, the weighted average method, the moving average method, or the individual pricing method. The average unit moving average method to calculate the cost and issued andbalances inventory cost objective, timely understand the balance of inventory management authorities, is conducive to the daily control of the quantity and the amount of inventory. But this method, because e