产品出入库月报表（月末加权法）

仓储物流管理工具——物品出入库管理,,,,,,,,,,,,,,,,

产品出入库月报表（加权平均法计算库存金额）,,,,,,,,,,,,月份,2016年5月,,,

说明：本表格主要用于每月对本企业产品的出入库情况及库存进行统计。具体包括数量、价格、金额等数据，其中出库单价（成本价）、结存单价以及金额数据为自动计算（入库金额、报废金额需要手动输入）。注：本工具采取的是加权平均法（出库单价及结存单价为加权计算结果），相对而言比较适合前后进价有些波动但相差幅度不大、每月购进与销售频繁、月末定期计算和结算产品成本的商品。,,,,,,,,,,,,,,,,

单位：仓管负责人：制表人：文件编号No：,,,,,,,,,,,,,,,,

编号,品名,规格,单位,期初库存,,,本月入库,,本月报废,,本月出库,,,本月结存,,

,,,,数量,单价,金额,数量,金额,数量,金额,数量,单价,金额,数量,单价,金额

,,,,100,￥18.00,"￥1,800.00",450,"￥9,000.00",30,￥200.00,380,￥20.38,"￥7,746.15",140,￥20.38,"￥2,853.85"

,,,,100,￥19.00,"￥1,900.00",451,"￥9,000.00",30,￥200.00,381,￥20.54,"￥7,824.76",140,￥20.54,"￥2,875.24"

,,,,100,￥20.00,"￥2,000.00",452,"￥9,000.00",0,￥0.00,382,￥19.93,"￥7,612.32",170,￥19.93,"￥3,387.68"

,,,,100,￥21.00,"￥2,100.00",453,"￥9,000.00",0,￥0.00,383,￥20.07,"￥7,687.70",170,￥20.07,"￥3,412.30"

,,,,100,￥22.00,"￥2,200.00",454,"￥9,000.00",30,￥200.00,384,￥20.99,"￥8,061.07",140,￥20.99,"￥2,938.93"

,,,,100,￥23.00,"￥2,300.00",455,"￥9,000.00",30,￥200.00,385,￥21.14,"￥8,140.00",140,￥21.14,"￥2,960.00"

,,,,100,￥24.00,"￥2,400.00",456,"￥9,000.00",0,￥0.00,386,￥20.50,"￥7,914.39",170,￥20.50,"￥3,485.61"

,,,,100,￥25.00,"￥2,500.00",457,"￥9,000.00",0,￥0.00,387,￥20.65,"￥7,990.13",170,￥20.65,"￥3,509.87"

,,,,100,￥26.00,"￥2,600.00",458,"￥9,000.00",30,￥600.00,388,￥20.83,"￥8,083.33",140,￥20.83,"￥2,916.67"

,,,,100,￥27.00,"￥2,700.00",459,"￥9,000.00",30,￥600.00,389,￥20.98,"￥8,162.38",140,￥20.98,"￥2,937.62"

,,,,100,￥28.00,"￥2,800.00",460,"￥9,000.00",0,￥0.00,390,￥21.07,"￥8,217.86",170,￥21.07,"￥3,582.14"

,,,,100,￥29.00,"￥2,900.00",461,"￥9,000.00",0,￥0.00,391,￥21.21,"￥8,293.94",170,￥21.21,"￥3,606.06"

,,,,100,￥30.00,"￥3,000.00",462,"￥9,000.00",30,￥600.00,392,￥21.43,"￥8,400.00",140,￥21.43,"￥3,000.00"

,,,,100,￥31.00,"￥3,100.00",463,"￥9,000.00",30,￥600.00,393,￥21.58,"￥8,479.36",140,￥21.58,"￥3,020.64"

,,,,100,￥32.00,"￥3,200.00",464,"￥9,000.00",0,￥0.00,394,￥21.63,"￥8,522.70",170,￥21.63,"￥3,677.30"

,,,,100,￥33.00,"￥3,300.00",465,"￥9,000.00",0,￥0.00,395,￥21.77,"￥8,599.12",170,￥21.77,"￥3,700.88"

,,,,100,￥34.00,"￥3,400.00",466,"￥9,000.00",30,￥600.00,396,￥22.01,"￥8,717.91",140,￥22.01,"￥3,082.09"

,,,,100,￥35.00,"￥3,500.00",467,"￥9,000.00",30,￥600.00,397,￥22.16,"￥8,797.58",140,￥22.16,"￥3,102.42"

,,,,100,￥36.00,"￥3,600.00",468,"￥9,000.00",0,￥0.00,398,￥22.18,"￥8,828.87",170,￥22.18,"￥3,771.13"

,,,,100,￥37.00,"￥3,700.00",469,"￥9,000.00",0,￥0.00,399,￥22.32,"￥8,905.62",170,￥22.32,"￥3,794.38"

,,,,100,￥38.00,"￥3,800.00",470,"￥9,000.00",30,￥600.00,400,￥22.59,"￥9,037.04",140,￥22.59,"￥3,162.96"

,,,,100,￥39.00,"￥3,900.00",471,"￥9,000.00",30,￥600.00,401,￥22.74,"￥9,117.01",140,￥22.74,"￥3,182.99"

,,,,100,￥40.00,"￥4,000.00",472,"￥9,000.00",0,￥0.00,402,￥22.73,"￥9,136.36",170,￥22.73,"￥3,863.64"

,,,,100,￥41.00,"￥4,100.00",473,"￥9,000.00",0,￥0.00,403,￥22.86,"￥9,213.44",170,￥22.86,"￥3,886.56"

,,,,100,￥42.00,"￥4,200.00",474,"￥9,000.00",0,￥0.00,404,￥23.00,"￥9,290.59",170,￥23.00,"￥3,909.41"

合计,,,,2500,,"￥75,000.00",11550,"￥225,000.00",360,"￥5,600.00",9800,,"￥210,779.63",3890,,"￥83,620.37"

核准人：