UFPrn20070520214814Page1存货明细账记账日期：月日凭证摘要数量单价金额期初结存2007-05-0105019,999.0010.00000099,990.002007-05-0105012007-05-0305032007-05-0505052007-05-0805082007-05-1005102007-05-1405142007-05-1705172007-05-2005209,999.0099,990.00本年累计9,999.0099,990.00商品周转率分析分析开始期间5/1/2007分析结束期间5/20/2007存货名称规格型号日平均库存量周转数量分析期间天数周转次数周转天数原料一002000原料二002000产品一41.5510002024.070.83产品二002000合计41.5510008024.070.83以产品一为例记账日期每日库存距离分析开始日期天数各日库存数量合计期初结存502010002007-05-019998002007-05-03-12-22007-05-05-14-42007-05-08-27-142007-05-10-29-182007-05-14-213-262007-05-17-316-482007-05-20-319-57各日库存合计831日平均库存量41.55周转数量20天1000/41.55=24.0720/24.07=0.8324.07/20*30=36.15月合计日平均库存量计算公式如下：按照记账日期进行汇总，将存货明细账中的每一个记账日期的（入库-出库）*距离分析开始日期的天数汇总+期初结存的数量*期初结存在明细账的记账日期到分析结束日期天数的总合计除以分析天数，具体见下面背景色为浅黄色的分析表1.查询的时候选择是发货周转率，周转数量来自分析期间内发货单的数量合计2.查询的时候选择是销售周转率，周转数量来自分析期间内没有作废发票的数量合计分析天数等于分析结束日期-分析开始日期天数+1周转次数=周转数量/日平均库存周转天数=分析期间天数/周转次数月周转次数=周转次数/分析期间天数*30UFPrn20070520214814Page20.0050.005.000000250.0099,990.000.0010,049.009.975122100,240.001.005.0000005.000.0010,048.009.975617100,235.001.005.0000005.000.0010,047.009.976112100,230.001.005.0000005.000.0010,046.009.976608100,225.002.005.00000010.000.0010,044.009.977599100,215.002.005.00000010.000.0010,042.009.978590100,205.002.005.00000010.000.0010,040.009.979582100,195.003.005.00000015.000.0010,037.009.981070100,180.003.005.00000015.0010,034.009.982559100,165.000.0015.0075.0010,034.009.982559100,165.000.0015.0075.00月周转次数0036.1036.1件数_数量_单价_金额_件数__数量__单价__金额__
