產(chǎn)品出入庫月報表（月末加權(quán)法）

倉儲物流管理工具——物品出入庫管理,,,,,,,,,,,,,,,,

產(chǎn)品出入庫月報表（加權(quán)平均法計算庫存金額）,,,,,,,,,,,,月份,2016年5月,,,

說明：本表格主要用于每月對本企業(yè)產(chǎn)品的出入庫情況及庫存進行統(tǒng)計。具體包括數(shù)量、價格、金額等數(shù)據(jù)，其中出庫單價（成本價）、結(jié)存單價以及金額數(shù)據(jù)為自動計算（入庫金額、報廢金額需要手動輸入）。注：本工具采取的是加權(quán)平均法（出庫單價及結(jié)存單價為加權(quán)計算結(jié)果），相對而言比較適合前后進價有些波動但相差幅度不大、每月購進與銷售頻繁、月末定期計算和結(jié)算產(chǎn)品成本的商品。,,,,,,,,,,,,,,,,

單位：倉管負責人：制表人：文件編號No：,,,,,,,,,,,,,,,,

編號,品名,規(guī)格,單位,期初庫存,,,本月入庫,,本月報廢,,本月出庫,,,本月結(jié)存,,

,,,,數(shù)量,單價,金額,數(shù)量,金額,數(shù)量,金額,數(shù)量,單價,金額,數(shù)量,單價,金額

,,,,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"

核準人：