The server is under maintenance between 08:00 to 12:00 (GMT+08:00), and please visit later.
We apologize for any inconvenience caused
Login  | Sign Up  |  Oriprobe Inc. Feed
China/Asia On Demand
Journal Articles
Laws/Policies/Regulations
Companies/Products
Bookmark and Share
yun yong excel zhi zuo xian jin xian chu fa yi dong jia quan ping jun fa cun huo zi dong ji jia mo xing
Author(s): 
Pages: 54-56
Year: Issue:  31
Journal: Finance and Accounting Monthly

Keyword:  存货Excel先进先出法移动加权平均法;
Abstract: 企业采用先进先出法及移动加权平均法进行存货成本核算繁琐且工作量大。本文针对这两种方法,介绍了利用Excel2007制作存货发出自动计价模型的方法。该方法借用函数与工具,在输入各批进货数量、单价及出库数量的条件下,就能自动计算出存货的出库成本及结存成本,使存货成本核算的效率大为提高。
Related Articles
No related articles found