zk库存、成本核算表.xls
《zk库存、成本核算表.xls》由会员分享,可在线阅读,更多相关《zk库存、成本核算表.xls(203页珍藏版)》请在得力文库 - 分享文档赚钱的网站上搜索。
1、品名期初数量 期初金额 入库数量 入库金额 总数量总金额销售数量 销售金额1000升塑料包装桶 55256.4155256.4110号焊丝101692.31101692.31203384.623M底涂2 277.40542 277.40543号产品箱00003米勾环绳000045#钢00.003900.003946号抗磨液压油11709.411709.49号箱0000A2箱0000AB胶 0-0.00020-0.0002C02气表 00.000700.0007C9发动机进出水管 20803.520803.520854.8CR12钢板61038.5261038.52HM681179.491179
2、.49HR5-400/30开关13151315OSG M3丝锥22782278OSG M4丝锥22742274OSG M5丝锥22762276OSG M6丝锥22862286OSG M8丝锥59355935O型圈43032.1653032.165PVC硬板257944.53257944.53RT16-2 400A 保险 420420R规 0-0.001830-0.00183SC315冷却液00.0007100.00071T型螺栓 40478.630.1188.0340.1666.66V型抱箍231062.16231062.16231154.52YP60箱0000安全带 0000安全绳 2205
3、8.9722058.9744117.94安全鞋0000安装工具 11305.511305.511317.69按钮 218.87218.87220.51按钮盒10117.9510117.9510128.21巴固皮鞋3297.443297.44白玻璃500162.3920020.32700182.71白刚玉砂轮5341.885341.88百分表座 134.19134.19268.38百洁布 20943.5920943.59201025.64扳手0-0.003310-0.00331板牙架 00.000300.0003板子 0-0.004980-0.00498钣金剪刀 0000半面具201322.74
4、201322.74半圆头螺丝40.5540.55包装材料费18.5518.55包装膜 0 0.0033560 0.003356保险块91158.122307.69111465.81抱箍250875.341514.1265889.44255930.3杯形垫圈20.8220.82杯形砂轮1000 76923.081000 76923.082000 153846.2变色硅胶430.77430.77变压器1454.71454.7变压器1454.71454.7标签纸351764350.44351764350.44245903258.98表面 00.00100.001表面处理超纤维擦拭布4923.0849
5、23.08表面皿351.28351.28玻璃钢双侧梯11327.3511327.35玻璃钢双侧梯 11327.3511327.35玻纤滤漆毡642 130597.5642 130597.5640 125747.2不干胶16 1.28436916 1.284369不锈钢管22628.3422628.3422682.98布手套29504034.1829504034.18擦拭布 56667390.7856667390.78336422362.1擦拭布(抽取)220 21623.93220 21623.93擦拭布(大卷)132 53589.74132 53589.74擦拭布(小卷)86 22755.5
6、686 22755.56擦拭纸 1123955.91123955.911032190.6擦拭纸架 15 1787.18315 1787.183测菌片51273.545102.36501375.86501495.5插头 4 7.197315759.8311 67.02731插座 10117.9510117.9510128.21柴油管60589.5460589.5460640.8产品箱2000 36645.292000 36645.29长电极帽20323.0820323.08长螺杆0 0.0007420 0.000742长拖把13 259.365513 259.3655超能型擦拭布(大卷)1552
7、30.77155230.77车刀16149.13594.0221243.15沉头螺丝53.7653.76齿轮箱111.62111.62充电器3203.07167.694270.76充电式起子电钻0 0.0019280 0.001928冲床踏板开关1149.571149.572299.14冲击钻42088.8942088.89抽油枪111.11111.11触摸显示屏 229324.2229324.22 29230.77吹尘枪 2 33.07546217.094 50.16546磁铁50175.2150175.21磁铁钳 551311.19551311.19磁铁圆型5064.15064.1撮箕0-
8、0.003160-0.00316锉刀423.93423.93打包带2701051.2830717.953001769.233001923.08打包扣110056.41110056.41打包膜0-0.00480-0.0048打印纸 506153.85506153.8510012307.7大力锉0000大西洋电焊条2239.322239.32大西洋电焊条 530.02530.02大西洋焊丝6104789.56104789.56104853.84呆扳手 9283.574414.5313298.104袋式初效过滤器1743 125038.51743 125038.5324828.48袋式初效过滤器 5
9、 682.29685 682.2968袋式过滤器0000袋式中效过滤器9 1169.6849 1169.684袋式中效过滤器1575 126294.91575 126294.9284781.84弹簧 11286.32300435.9311722.2211329.06挡护架4153.164153.16导板2039.662039.66导电咀 53 287.343520101.5473 388.8835导规173.85173.85导轮 0-0.003680-0.00368导套 00.004600.0046导柱280.34280.34灯管 0000灯泡 0 0.0033580 0.003358灯头0-
10、0.00340-0.0034低压封圈修理包 32289.532289.532388.46底板487.52487.52底涂剂 0-0.00390-0.0039底座 242.74242.74485.48地板胶 60400.7560400.7560435.6地脚螺栓00.003700.0037地坪漆 0000电柄 00.0042600.00426电池121600.01121600.01电池组件201347201347电磁阀门1354.71354.7电动套丝机11752.1411752.14电风扇0 0.0042120 0.004212电工保险带 0000电工刀432.48432.48电工胶2 8.9
11、739732 8.973973电机2 2174.2942 2174.294电机机壳128.03128.03电机机壳组件2147.692147.69电机维修9 766.15319 766.1531电极夹套46405.3246405.32电极帽202430.77202430.77203726.5电缆1.31367.521.31367.52电缆线1002393.161002393.16501055.69电烙铁 2102.572111.114213.68电磨机1209.41209.4电容 1034.191034.192068.38电筒 0-0.000340-0.00034电线102713.681027
12、13.68电线插板19 397.640519 397.6405电子秤 0000电阻 3258.883258.883264电钻0-0.00430-0.0043垫圈 0000垫铁100589.75100589.75100641.03顶杆15228.6315228.63定位销 00.0047400.00474定子 235.56117.78353.34定子组件753183.45753183.45端盖11047.0111047.01耳塞00.002700.0027耳罩0-0.00490-0.0049发动机进出水管 351179.49351179.49351282.05阀座 2601.542601.542
13、653.85帆布手套300471.79300471.79300512.82帆布手套12601657.5712601657.5712601801.71反光背心13 225.026113 225.0261方钢0 0.0021050 0.002105方管1.846589.741.846589.74方管9.041 30136.759.041 30136.75方矩管8.63 29541.778.63 29541.77方矩管 8.63 29541.778.63 29541.77方砂19000 17863.2519000 17863.25防爆代柄榔头1106.841106.84防爆钢丝钳1220.79122
14、0.79防爆管子钳1340.981340.98防爆活动扳手2574.322574.32防爆榔头 0000防爆螺丝刀 0000防爆十字罗丝批164.96164.96防爆一字改刀164.96164.96防尘垫00.0047400.00474防冻液0-0.002380-0.00238防毒面具00.00500.005防飞溅剂 20307.6920307.6940615.38防护服 00.00500.005防护手套133423421.5133423421.51334 22443.28防护眼镜 921650.94921650.94902625防滑垫 0000防锈油 12281.792405641.0325
15、25922.821202571.35飞溅膏7 196.23917 196.2391非标螺栓 1.06543.591.06543.592.121087.18分支器 568.38568.3810136.76风管 00.004400.0044风机1200.851200.85封口胶1800 15076.921800 15076.92蜂窝状活性炭过滤网704 102290.6704 102290.6辅助键 11732.511732.511153.85改刀13.4213.42改刀 39.439.4干燥颗粒 0000干燥器0000钢板 228 826.79522301049.06458 1875.855钢卷
16、尺14.2714.27钢丝钳 52 1651.37318.5553 1659.923杠杠1026.671026.67高压封圈修理包34972.2534972.2535404.62搞磨液压油1179.491179.49割咀518.8518.8工具箱1001367.521001367.52工业擦拭纸 0000工作灯 0000工作键33184.6233184.6233461.54固定轮4123.084123.08固体电器17701.0817701.08挂锁15 85.9034915 85.90349112.82管钳177.06177.06183.76管子1047.011047.01滚道连接件3210
17、9.432109.4滚筒75256.4175256.41过滤棉 0000焊管41.24 140427.46.43 21452.9947.67 161880.3焊剂 00.000200.0002焊接面罩0 0.0046140 0.004614焊钳 0-0.003560-0.00356焊枪 1984.621984.6221969.24焊丝 3295 23783.913002076.923595 25860.83532.51焊条14024514024520153.85合金铰刀0000合金铣铰刀0000合金旋转锉20256.4120256.41合金锥铰刀204444.44204444.44合金钻头33
18、5.9335.9黑玻璃350358.97350358.97黑胶皮 0000黑镜 23.4223.4246.84滑动导向件10504.2710504.27环套筒10.5610.56活动板手 0000活动轮8328.218328.21活性碳过滤网0000货架12.8 41608.5512.8 41608.55机床灯头 114.53114.53229.06机架1132.561132.56机壳551.28551.28机用打包带23550.4323550.43461100.86机油 5973851.285973851.28机油杆 0000机油壶 0-0.001830-0.00183机油压力传感器传输管1
19、0136.0710136.0710147.9积架0000集尘袋总成110.26110.26记数器 1 162.17971294.872 457.0497继电器 0-0.00360-0.0036夹钳 112.82112.82225.64夹头 6391063.753107.696421171.44尖咀钳558.97558.97减压器 2205.132205.134410.26检漏液00.000900.0009交流接触器 183759.5661420.51245180.07胶板1001068.381001068.38胶带48394.27 55360.04 65263.16 52991.46 1136
20、57.4 108351.526553451.88胶管 0-0.00360-0.0036胶脚 3212030.0750307.693712337.76胶水 0000角钢0000角磨机19 6631.02819 6631.028角磨片0000绞刀17.6917.69脚轮 1853060.66815736.322668796.984143.56脚轮夹板32109.432109.4脚轮连接件410.36410.36411.26铰刀 110.25220.51330.76接近开关254.7254.7接头 320529.9120273.5340803.41金佰利胶手套0000金伯利纸架2 277.78462
21、 277.7846金刚石什锦锉 33.0833.0866.16金钢笔 5179.4810358.9715538.452119.66进气管121462.58121462.58121589.76进气管直角弯管 24471.8524471.8524512.88矩管 1.3394406.841.3394406.842.6788813.68锯弓123.93123.93锯片夹总成 5170.94134.196205.13聚氨脂胶棒7.2153.857.2153.85卷尺00.002200.0022绝缘垫 0000绝缘手套 236.7724768.696805.462绝缘橡胶垫 4434.194434.19
22、8868.38绝缘靴271.79271.79卡尺1136.751136.75卡簧钳 0000卡盘砂布轮 20290.620290.640581.2开关 42 501.015926327.5268 828.53595213.7开关206C1077.92551077.9255开关阀修理包55201.5455201.5455653.85开口夹套 30313.8550653.8580967.7抗高温手套41159.241159.241260空开7608.84229.0611837.865405.98快速夹钳 00.0047400.00474垃圾桶 0000拉铆钉223.08223.08拉铆枪127.3
23、5127.35拉伸油 0-0.004620-0.00462兰玻 104.27104.27208.54榔头 361.54361.546123.08劳保鞋 0-0.004650-0.00465冷冻式干燥机1 12378.211 12378.211 12478.63冷却液 2204965.812204965.814409931.62424 14314.53滤毒盒 0000滤盒48449.2348449.23绿碳砂轮 5149.575149.5710299.14螺钉518.18295673.8300691.98300752.15螺帽 00.000300.0003螺母98358.97234.191003
24、93.16100427.35螺栓 12201602.0912201602.0912201741.4螺栓螺母 10021.1610021.1610023螺丝刀253.3075253.3075螺纹胶 0000螺旋伞齿轮217.636617.6366马达 00.000300.0003码钉枪6 1969.2326 1969.232铆钉0 0.0004950 0.000495铆头 104598.294529.911081128.2梅花扳手 8264.958264.9516529.9梅花起子0-0.000210-0.00021煤油 00.004300.0043密封垫 0000密封圈 2108.362108
25、.362117.78棉纱3002948.723002948.72秒表288.89288.89摩擦片 0000磨头0000钼丝 19320.77911.931538.46 19321.771450.39内导柱258.97258.97内导柱 258.97258.97内六角4.31747.864.31747.86内六角 723155.92723155.92内六角扳手112.82112.82内六角板手11.7111.71内六角板手25.1325.13内六角板手28.5528.55内六角板手635.9635.9内六角螺栓64.308564.3085耐高温折叠式过滤器122666.67122666.67耐
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- zk 库存 成本核算
限制150内