《（专业财务模板）材料进出库存月报表.xlsx》由会员分享，可在线阅读，更多相关《（专业财务模板）材料进出库存月报表.xlsx（11页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、基础数据表供供应应商商编编号号供供应应商商名名称称材材料料编编码码材材料料类类别别规规格格型型号号单单位位单单价价YQJ-0001新为电子DZ0001电阻25支0.25YQJ-0002新为电子DZ0002电阻32支0.33YQJ-0003三河集团DZ0003电阻100支0.58YQJ-0004元丰今日DZ0004电阻320支0.89JCK-0001金元电器DZ0005电阻29支0.21JCK-0002金元电器DZ0006电阻30支0.36JCK-0003盛华DR0001电容10F支0.78JCK-0004恒杰电子DR0002电容18F支0.65JCK-0005华声集团DR0003电容50F支0
2、.75XSQ-0001海域电子DR0004电容100F支0.85XSQ-0002海域电子DR0005电容25F支0.9XSQ-0003创维科技DR0006电容0.5F支0.55XSQ-0004宏图三胞JCK001集成块AEu8139支58.5XSQ-0005罗利亚JCK002集成块AEu8120支75.6SRQ-0001克罗保JCK003集成块AEu8141支124.85TX-0001志邦JCK004集成块AEu8152支320YZB-0001佳缘电器JCK005集成块AEu8143支70YZB-0002时代电子JCK006集成块AEu9144支185YZB-0003思创科技JCK007集成块
3、AEu8145支412.5材材料料入入库库明明细细表表月月日日供供货货商商编编号号供供货货商商名名称称凭凭证证号号材材料料编编码码类类别别规规格格型型号号 单单位位65XSQ-0001海域电子2012060001DR0004电容100F支65XSQ-0002海域电子2012060001DR0005电容25F支66XSQ-0001海域电子2012060001DR0004电容100F支67XSQ-0003创维科技2012060001DR0006电容0.5F支610XSQ-0004宏图三胞2012060001JCK001集成块AEu8139支615XSQ-0002海域电子2012060001DR00
4、05电容25F支622XSQ-0001海域电子2012060001DR0004电容100F支623XSQ-0002海域电子2012060001DR0005电容25F支625XSQ-0001海域电子2012060001DR0004电容100F支61JCK-0005华声集团2012060001DR0003电容50F支63JCK-0005华声集团2012060001DR0003电容50F支65JCK-0005华声集团2012060001DR0003电容50F支67JCK-0005华声集团2012060001DR0003电容50F支611XSQ-0003创维科技2012060001DR0006电容0.
5、5F支615JCK-0003盛华2012060001DR0001电容10F支620JCK-0003盛华2012060001DR0001电容10F支625JCK-0003盛华2012060001DR0001电容10F支625JCK-0003盛华2012060001DR0001电容10F支627JCK-0003盛华2012060001DR0001电容10F支615XSQ-0003创维科技2012060001DR0006电容0.5F支624XSQ-0003创维科技2012060001DR0006电容0.5F支63JCK-0004恒杰电子2012060001DR0002电容18F支65JCK-0004
6、恒杰电子2012060001DR0002电容18F支67JCK-0004恒杰电子2012060001DR0002电容18F支67JCK-0004恒杰电子2012060001DR0002电容18F支68XSQ-0002海域电子2012060001DR0005电容25F支68XSQ-0002海域电子2012060001DR0005电容25F支68XSQ-0002海域电子2012060001DR0005电容25F支610XSQ-0002海域电子2012060001DR0005电容25F支615XSQ-0005罗利亚2012060001JCK002集成块AEu8120支621XSQ-0005罗利亚20
7、12060001JCK002集成块AEu8120支627XSQ-0002海域电子2012060001DR0005电容25F支65YZB-0001佳缘电器2012060001JCK005集成块AEu8143支66YZB-0001佳缘电器2012060001JCK005集成块AEu8143支618YZB-0001佳缘电器2012060001JCK005集成块AEu8143支625YZB-0001佳缘电器2012060001JCK005集成块AEu8143支61JCK-0002金元电器2012060001DZ0006电阻30支61JCK-0002金元电器2012060001DZ0006电阻30支62
8、JCK-0004恒杰电子2012060001DR0002电容18F支62JCK-0003盛华2012060001DR0001电容10F支63JCK-0003盛华2012060001DR0001电容10F支63JCK-0001金元电器2012060001DZ0005电阻29支65JCK-0002金元电器2012060001DZ0006电阻30支612JCK-0003盛华2012060001DR0001电容10F支615JCK-0001金元电器2012060001DZ0005电阻29支615JCK-0002金元电器2012060001DZ0006电阻30支618JCK-0001金元电器201206
9、0001DZ0005电阻29支618JCK-0002金元电器2012060001DZ0006电阻30支620JCK-0001金元电器2012060001DZ0005电阻29支620JCK-0002金元电器2012060001DZ0006电阻30支626JCK-0001金元电器2012060001DZ0005电阻29支628JCK-0002金元电器2012060001DZ0006电阻30支615SRQ-0001克罗保2012060001JCK003集成块AEu8141支627SRQ-0001克罗保2012060001JCK003集成块AEu8141支618XSQ-0004宏图三胞20120600
10、01JCK001集成块AEu8139支625XSQ-0005罗利亚2012060001JCK002集成块AEu8120支66YZB-0002时代电子2012060001JCK006集成块AEu9144支618YZB-0002时代电子2012060001JCK006集成块AEu9144支625YZB-0002时代电子2012060001JCK006集成块AEu9144支625YZB-0002时代电子2012060001JCK006集成块AEu9144支630YZB-0002时代电子2012060001JCK006集成块AEu9144支66YZB-0003思创科技2012060001JCK007集
11、成块AEu8145支618YZB-0003思创科技2012060001JCK007集成块AEu8145支618YZB-0003思创科技2012060001JCK007集成块AEu8145支625YZB-0003思创科技2012060001JCK007集成块AEu8145支61YQJ-0004元丰今日2012060001DZ0004电阻320支65YQJ-0004元丰今日2012060001DZ0004电阻320支610YQJ-0004元丰今日2012060001DZ0004电阻320支612YQJ-0001新为电子2012060001DZ0001电阻25支618YQJ-0001新为电子2012
12、060001DZ0001电阻25支618YQJ-0002新为电子2012060001DZ0002电阻32支68YQJ-0003三河集团2012060001DZ0003电阻100支613YQJ-0003三河集团2012060001DZ0003电阻100支618YQJ-0003三河集团2012060001DZ0003电阻100支625YQJ-0003三河集团2012060001DZ0003电阻100支67YQJ-0002新为电子2012060001DZ0002电阻32支618TX-0001志邦2012060001JCK004集成块AEu8152支625TX-0001志邦2012060001JCK0
13、04集成块AEu8152支625TX-0001志邦2012060001JCK004集成块AEu8152支627TX-0001志邦2012060001JCK004集成块AEu8152支入入库库数数量量单单价价金金额额1000.85857520.9676.88000.856801000.55552000058.511700006000.95403200.852724100.93695000.854257820.75586.51000.75752000.751504510.75338.2550000.55275045000.7835105200.78405.66000.784684000.78312
14、1000.78788500.55467.52000.551101000.65657100.65461.52000.651306000.653901000.99050000.9450015000.9135050000.94500780075.658968056075.6423362000.9180200701400052070364001000707000040070280005400.36194.44560.36164.162150.65139.7520000.78156030000.7823402000.21422010.3672.3650000.78390030000.216306000.
15、362168500.21178.57800.36280.89600.21201.66500.362345000.2110512000.36432500124.8562425500124.856242590058.55265030075.622680520185962001000185185000500185925009001851665001500185277500520412.52145001000412.5412500500412.5206250800412.53300006300.89560.76500.89578.578000.89694210000.2525012000.253004
16、500.33148.535000.58203012000.586966200.58359.660200.583491.65000.331651000320320000200320640005600320179200010032032000本月领取情况记录表月月日日 部部门门编编码码 部部门门名名称称凭凭证证号号材材料料编编码码材材料料类类别别 规规格格型型号号单单位位申申领领数数量量61KB001一车间2012060001DZ0001电阻25支200061KB001一车间2012060001DZ0002电阻32支750061KB001一车间2012060001DZ0003电阻100支80061
17、KB001一车间2012060001DZ0004电阻320支120061KB001一车间2012060001DZ0005电阻29支50061KB001一车间2012060001DZ0006电阻30支30065KB002二车间2012060001DR0001电容10F支20065KB003三车间2012060001DR0002电容18F支100610KB002二车间2012060001DR0003电容50F支520610KB003三车间2012060001DR0004电容100F支620610KB002二车间2012060001DR0005电容25F支400610KB003三车间20120600
18、01DR0006电容0.5F支500610KB004四车间2012060001JCK001集成块AEu8139支300610KB004四车间2012060001JCK002集成块AEu8120支200610KB004四车间2012060001JCK003集成块AEu8141支200610KB004四车间2012060001JCK004集成块AEu8152支50612KB004四车间2012060001JCK005集成块AEu8143支15612KB004四车间2012060001JCK006集成块AEu9144支20615KB004四车间2012060001JCK007集成块AEu8145支6
19、6615KB004四车间2012060001DZ0001电阻25支200615KB004四车间2012060001DZ0002电阻32支300615KB004四车间2012060001DZ0003电阻100支40615KB004四车间2012060001DZ0004电阻320支80619KB005五车间2012060001DZ0005电阻29支95619KB006维修部2012060001DZ0006电阻30支20619KB007综合部2012060001DR0001电容10F支10619KB005五车间2012060001DR0002电容18F支20619KB006维修部2012060001
20、DR0003电容50F支14619KB007综合部2012060001DR0004电容100F支253619KB001一车间2012060001DR0005电容25F支241619KB002二车间2012060001DR0006电容0.5F支263623KB003三车间2012060001JCK001集成块AEu8139支55623KB004四车间2012060001JCK002集成块AEu8120支78625KB005五车间2012060001JCK003集成块AEu8141支98625KB006维修部2012060001JCK004集成块AEu8152支56625KB007综合部20120
21、60001JCK005集成块AEu8143支25625KB001一车间2012060001JCK006集成块AEu9144支45625KB002二车间2012060001JCK007集成块AEu8145支65625KB003三车间2012060001DZ0001电阻25支78626KB004四车间2012060001DZ0002电阻32支52628KB005五车间2012060001DZ0003电阻100支52628KB006维修部2012060001DZ0004电阻320支10628KB007综合部2012060001DZ0001电阻25支55628KB003三车间2012060001DZ0
22、002电阻32支12628KB004四车间2012060001DZ0003电阻100支10金额合计：189242.78实实发发数数量量数数量量 单单位位成成本本金金额额20000.25500.075000.332475.08000.58464.012000.891068.05000.21105.03000.36108.02000.78156.01000.6565.05200.75390.06200.85527.04000.9360.05000.55275.030058.517550.020075.615120.0200124.8524970.05032016000.015701050.0201
23、853700.066412.527225.02000.2550.03000.3399.0400.5823.2800.8971.2950.2120.0200.367.2100.787.8200.6513.0140.7510.52530.85215.12410.9216.92630.55144.75558.53217.57875.65896.898124.8512235.35632017920.025701750.0451858325.065412.526812.5780.2519.5520.3317.2520.5830.2100.898.9550.2513.8120.334.0100.585.8
24、材材料料进进出出库库存存月月报报表表公司名称华云信息有限公司制表部门品管部合合 计计 金金 额额156,737.356,389,778.62材材料料材材料料名名 称称单单上上 月月 结结 存存本本 月月 进进 货货编编码码类类别别及及规规格格型型号号位位单单价价数数量量金金额额单单价价数数量量金金额额DZ0001电阻25支0.25500.00125.000.252200550DZ0002电阻32支0.3310000.003300.000.33950313.5DZ0003电阻100支0.58820.00475.600.58113406577.2DZ0004电阻320支0.891580.00140
25、6.200.8990808081.2DZ0005电阻29支0.21700.00147.000.2155101157.1DZ0006电阻30支0.36980.00352.800.3644271593.72DR0001电容10F支0.78700.00546.000.781612012573.6DR0002电容18F支0.65850.00552.500.6518251186.25DR0003电容50F支0.75456.00342.000.7515331149.75DR0004电容100F支0.851470.001249.500.8517201462DR0005电容25F支0.90840.00756.
26、000.91356212205.8DR0006电容0.5F支0.55521.00286.550.5561503382.5JCK001集成块AEu8139支58.50146.008541.0058.5209001222650JCK002集成块AEu8120支75.60300.0022680.0075.68660654696JCK003集成块AEu8141支124.85452.0056432.20124.851000124850JCK004集成块AEu8152支320.00125.0040000.0032069002208000JCK005集成块AEu8143支70.0041.002870.007
27、02120148400JCK006集成块AEu9144支185.0050.009250.001854420817700JCK007集成块AEu8145支412.5018.007425.00412.528201163250制表时间2012/6/30单位元189,242.786,357,273.19唯唯一一性性本本 月月 出出 货货本本 月月 结结 存存单单价价数数量量金金额额单单价价数数量量金金额额0.252333.00583.250.2536791.7510.337864.002595.120.3330861018.3810.58902.00523.160.58112586529.6410.8
28、91290.001148.100.8993708339.3010.21595.00124.950.2156151179.1510.36320.00115.200.3650871831.3210.78210.00163.800.781661012955.8010.65120.0078.000.6525551660.7510.75534.00400.500.7514551091.2510.85873.00742.050.8523171969.4510.9641.00576.900.91376112384.9010.55763.00419.650.5559083249.40158.5355.0020767.5058.5206911210423.50175.6278.0021016.8075.68682656359.201124.85298.0037205.30124.851154144076.901320106.0033920.0032069192214080.0017040.002800.00702121148470.00118565.0012025.001854405814925.001412.5131.0054037.50412.527071116637.501材材料料进进出出库库存存月月报报表表