物料出入库月报表（月末加权法）

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

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

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

公司：仓管负责人：制表人：文件编号No：,,,,,,,,,,,,,,,,,,,,,,,

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

,,,,数量,上月加权单价,金额,采购数量,金额,退仓数量,退仓金额,累计入库数量,累计入库金额,数量,金额,生产一部,生产二部,生产三部,调拨数量,累计出库数量,累计出库金额,数量,加权单价,金额

,,,,100,￥18.00,"￥1,800.00",450,"￥9,000.00",25,￥500.00,475,"￥9,500.00",30,￥200.00,90,110,120,50,370,"￥7,535.78",175,￥20.37,"￥3,564.22"

,,,,100,￥19.00,"￥1,900.00",451,"￥9,020.00",25,￥500.00,476,"￥9,520.00",30,￥200.00,91,112,125,50,378,"￥7,767.69",168,￥20.55,"￥3,452.31"

,,,,100,￥20.00,"￥2,000.00",452,"￥9,040.00",25,￥500.00,477,"￥9,540.00",0,￥0.00,92,114,130,50,386,"￥7,720.00",191,￥20.00,"￥3,820.00"

,,,,100,￥21.00,"￥2,100.00",453,"￥9,060.00",25,￥500.00,478,"￥9,560.00",0,￥0.00,93,116,135,50,394,"￥7,948.17",184,￥20.17,"￥3,711.83"

,,,,100,￥22.00,"￥2,200.00",454,"￥9,080.00",25,￥500.00,479,"￥9,580.00",30,￥200.00,94,118,140,50,402,"￥8,479.34",147,￥21.09,"￥3,100.66"

,,,,100,￥23.00,"￥2,300.00",455,"￥9,100.00",25,￥500.00,480,"￥9,600.00",30,￥200.00,95,120,145,50,410,"￥8,721.82",140,￥21.27,"￥2,978.18"

,,,,100,￥24.00,"￥2,400.00",456,"￥9,000.00",25,￥500.00,481,"￥9,500.00",0,￥0.00,96,122,150,50,418,"￥8,561.45",163,￥20.48,"￥3,338.55"

,,,,100,￥25.00,"￥2,500.00",457,"￥9,020.00",25,￥500.00,482,"￥9,520.00",0,￥0.00,97,124,155,50,426,"￥8,798.14",156,￥20.65,"￥3,221.86"

,,,,100,￥26.00,"￥2,600.00",458,"￥9,040.00",25,￥500.00,483,"￥9,540.00",30,￥600.00,98,126,160,50,434,"￥9,056.71",119,￥20.87,"￥2,483.29"

,,,,100,￥27.00,"￥2,700.00",459,"￥9,060.00",25,￥500.00,484,"￥9,560.00",30,￥600.00,99,128,165,50,442,"￥9,302.74",112,￥21.05,"￥2,357.26"

,,,,100,￥28.00,"￥2,800.00",460,"￥9,080.00",25,￥500.00,485,"￥9,580.00",0,￥0.00,100,130,170,50,450,"￥9,523.08",135,￥21.16,"￥2,856.92"

,,,,100,￥29.00,"￥2,900.00",461,"￥9,100.00",25,￥500.00,486,"￥9,600.00",0,￥0.00,101,132,175,50,458,"￥9,769.62",128,￥21.33,"￥2,730.38"

,,,,100,￥30.00,"￥3,000.00",462,"￥9,120.00",25,￥500.00,487,"￥9,620.00",30,￥600.00,102,134,180,50,466,"￥10,056.23",91,￥21.58,"￥1,963.77"

,,,,100,￥31.00,"￥3,100.00",463,"￥9,140.00",25,￥500.00,488,"￥9,640.00",30,￥600.00,103,136,185,50,474,"￥10,312.47",84,￥21.76,"￥1,827.53"

,,,,100,￥32.00,"￥3,200.00",464,"￥9,160.00",25,￥500.00,489,"￥9,660.00",0,￥0.00,104,138,190,50,482,"￥10,523.80",107,￥21.83,"￥2,336.20"

,,,,100,￥33.00,"￥3,300.00",465,"￥9,180.00",25,￥500.00,490,"￥9,680.00",0,￥0.00,105,140,195,50,490,"￥10,780.00",100,￥22.00,"￥2,200.00"

,,,,100,￥34.00,"￥3,400.00",466,"￥9,200.00",25,￥500.00,491,"￥9,700.00",30,￥600.00,106,142,200,50,498,"￥11,096.26",63,￥22.28,"￥1,403.74"

,,,,100,￥35.00,"￥3,500.00",467,"￥9,220.00",25,￥500.00,492,"￥9,720.00",30,￥600.00,107,144,205,50,506,"￥11,362.49",56,￥22.46,"￥1,257.51"

,,,,100,￥36.00,"￥3,600.00",468,"￥9,240.00",25,￥500.00,493,"￥9,740.00",0,￥0.00,108,146,210,50,514,"￥11,562.83",79,￥22.50,"￥1,777.17"

,,,,100,￥37.00,"￥3,700.00",469,"￥9,260.00",25,￥500.00,494,"￥9,760.00",0,￥0.00,109,148,215,50,522,"￥11,828.48",72,￥22.66,"￥1,631.52"

,,,,100,￥38.00,"￥3,800.00",470,"￥9,280.00",25,￥500.00,495,"￥9,780.00",30,￥600.00,110,150,220,50,530,"￥12,175.93",35,￥22.97,￥804.07

,,,,100,￥39.00,"￥3,900.00",471,"￥9,300.00",25,￥500.00,496,"￥9,800.00",30,￥600.00,111,152,225,50,538,"￥12,451.94",28,￥23.14,￥648.06

,,,,100,￥40.00,"￥4,000.00",472,"￥9,320.00",25,￥500.00,497,"￥9,820.00",0,￥0.00,112,154,230,50,546,"￥12,639.40",51,￥23.15,"￥1,180.60"

,,,,100,￥41.00,"￥4,100.00",473,"￥9,340.00",25,￥500.00,498,"￥9,840.00",0,￥0.00,113,156,235,50,554,"￥12,914.31",44,￥23.31,"￥1,025.69"

,,,,100,￥42.00,"￥4,200.00",474,"￥9,360.00",25,￥500.00,499,"￥9,860.00",0,￥0.00,114,158,240,50,562,"￥13,191.52",37,￥23.47,￥868.48

合计,,,,2500,,"￥75,000.00",11550,"￥228,720.00",625,"￥12,500.00",12175,"￥241,220.00",360,"￥5,600.00",2550,3350,4500,1250,11650,"￥254,080.22",2665,,"￥56,539.78"

核准人：审批人：制表人：,,,,,