zk库存、成本核算表.xls

品名期初数量 期初金额 入库数量 入库金额 总数量总金额销售数量 销售金额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.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安全绳 22058.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.74201322.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.084923.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.5686 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超能型擦拭布(大卷)155230.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-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 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-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.9739732 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.68102713.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.542653.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.791220.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.032525922.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钢卷尺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滚道连接件32109.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合金钻头335.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机油压力传感器传输管10136.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 113657.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 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.198868.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.35127.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.19100393.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.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耐压管50196.4250196.4250213.5尼龙板14.2303.4214.2303.42尼龙塑料板0-0.0040-0.004镊子0000扭力板手维修0-0.00320-0.0032诺顿砂轮 61324.1761324.1761439.31排笔1012.821012.82排笔2070.772070.772076.92排笔 60146.8360146.83盘头螺丝M3.5X7 405.47405.47抛光轮0 0.0043250 0.004325抛光片 501494.02501494.02501623.93抛光绒布 60448.2160448.2160487.18喷咀82 1008.11682 1008.116喷咀接头50884.6250884.62喷漆枪147.01147.01喷嘴体 14760.8114760.8115174.79膨胀螺钉100141.54100141.54100153.85膨胀螺栓0-0.004690-0.00469皮带511123.91511123.91皮带6-330235.56235.56皮鞋2230.772230.77皮鞋 2230.772230.77平板开关 5196.65196.65213.7平挫 545.22545.22549.15平垫圈2645.2645.26平垫圈735.0835.08平衡块4308.384308.38平面轴承23.1523.15气表2222.222222.22气撑 00.0003800.00038气动调压阀 10377.4410377.4410410.26气动工具0-0.000150-0.00015气动精磨机1 10610.261 10610.26气动精磨机 2 18033.342 18033.34气动手扳阀 5110.095110.095119.66气缸10401.7110401.71气缸 10 11696.1410 11696.14气管 0-0.001040-0.00104气接头 00.000100.0001气接头 2086.52086.52094.02气泡袋 0000气泡膜260234448.33260234448.33气直接5064.15064.1千斤顶0-0.002950-0.00295堑子1059.831059.83强力吸油擦拭布(抽取)202529.91202529.91切割机0000切割片50367.5250367.52切割片 10125 19170.9310125 19170.93切割器10 58.3333310 58.33333切削液0-0.003550-0.00355清洁剂 18692.62518692.625清洗剂1403350.41403350.4清洗剂 130490013049001305000球碗144.44144.44球碗144.44144.44全身式安全带31668.7231668.72全身式安全带 31668.7231668.72热继电器2119.662119.66热继电器 2119.662119.66容器 0000软化水 0-0.003470-0.00347润滑油5470.085470.08润滑油2283.072283.072307.69塞尺17.6917.69三和液态密封胶 300754.87300754.87300820.51三角刮刀430.77430.77三芯电源线 100460100460100500三爪拉马0000扫把10 29.9106610 29.91066扫把1027.351027.35刹车带 0 0.0008180 0.000818砂碟 5045.855045.85砂碟 9200 14906.259200 14906.259200 15333.33砂轮67 14118.8367 14118.83砂纸50000 39230.7850000 39230.78砂纸 114983.9 147682.5114983.9 147682.5生料带 0-0.001510-0.00151时间继电器0-0.000360-0.00036手柄右117.78117.78手柄左119.83119.83手电筒 0-0.004030-0.00403手动阀5149.575149.57手动阀5230.775230.77手动阀 10380.3410380.34手动机油杆2367.522367.52手套12 36.9235212 36.92352手提电焊机0000手推车37803780手用丝攻113.68113.68手用丝攻 1364.961364.96数显游标卡尺61747.8761747.87刷子0 0.0011360 0.001136双层胶板车6282062820双头切刀335.9335.9水泵1816.241816.24水冷电缆0000水龙头1033.07561033.0756水银灯20512.8320512.83丝锥224.79224.79丝锥566.84566.84572.65丝锥 0-0.00010-0.0001四芯电源线 502305023050250送丝轮3221.543221.54送丝轮 0000送丝软管 0000塑封机 1275.221275.221299.15塑料板0-0.00110-0.0011塑料包装膜1000 11538.461000 11538.46塑料包装膜 999 11526.92999 11526.92塑料端盖 102.3102.3102.5塑料焊枪149.57149.57塑料箱2990 111639.22990 111639.2塑料箱0000塑料箱500 24444.45500 24444.45塑料箱 28025387.528025387.5280 26324.79踏板开关0-0.003060-0.00306台式钻床0000碳带1502179.491502179.49碳刷2801723.082801723.08碳刷50376.0750376.07碳刷 2711 16589.142711 16589.14碳刷CB-100A220.68220.68碳刷CB-641300800013008000陶瓷保护咀 00.003500.0035套丝机0000套筒头子129.91129.91套筒头子 0000梯子 0 0.0015550 0.001555铁网1034841.881034841.88铜管0 0.0024440 0.002444铜焊粉117.09117.09铜焊条 0000铜接头00.000800.0008铜接头20149.420149.420162.39透明管20149.4120149.4120162.4凸轮2393.162393.16凸轮 2393.162393.16凸型簧200512.82200512.82涂层合金铰刀103662.39103662.39推车 0000托盘1005963.241005963.24托盘1207548.721207548.721208205.13拖把261.54261.54脱膜剂0000脱水 0-0.00350-0.0035脱水棉 00.000600.0006外导套2107.692107.69外导套 2107.692107.69外导柱2198.292198.29外导柱 2198.292198.29弯刃电工刀 0000弯头镊子23182.323182.3万能角尺1290.61290.6万用表0000维修费11 1504.27211 1504.272钨极40666.6740666.67吸料器单头1059.831059.83吸料器双头10128.2110128.21吸铁器1064.11064.1吸铁器10196.5810196.58吸铁器 20260.6820260.68稀释剂143677.8143677.8线棒60589.7460589.74线棒 60495.1460495.1460538.2线棒连接件 00.00400.004线棒连接件 5666.945666.945672.76线棒正挂钩0000线圈9 242.31159 242.3115线手套 0-0.00190-0.0019香蕉水6917.956917.95香蕉水4573.54573.51277.78橡胶套381.79381.79消声器 2527.782527.785055.56硝酸4110.094110.094119.66销子 30066.6730066.67600133.34斜齿轮17.5217.52斜齿轮 17.5217.52新9#筐0000行程开关1085.471085.47型材切割机33076.9233076.92修理组件 56535.2356535.2356769.23蓄电池标准液 0-0.00360-0.0036旋转锉 00.0042600.00426旋转接头修理包 55024.1655024.1655147.44旋转开关 10393.2110393.2110427.4压力表 2121.372121.374242.74压缩气管160601.77160601.77160654.1厌氧胶1 6.8389541 6.838954氧气表 71091.39147.0181138.4液压三爪拉马41316.2441316.24液压油 00.001400.0014溢流阀 1290.61290.62581.2硬质合金锯片 4 282.9103134.385 317.2903油管4 403.599956185.9460 589.539960640.8油漆91670.8991670.893405.98油漆笔 2022.222022.224044.44油漆刷145264.95145264.953038.46油水分离器 00.0011800.00118油雾器0000游标卡尺 0000元板牙838.45838.45圆挫 547.18547.18551.28圆底板1235191.455191.45圆钢0 0.0028810 0.002881圆柱销 0000运输包装费 1243.591243.592487.18錾子323.08323.08皂化油0-0.000910-0.00091扎带598.29598.295106.84支脚4456.894456.89直柄焊枪99337.6899337.68直柄钻花 32428.6332428.6364857.26直角尺 0 0.0021330 0.002133直流马达 119.83119.83239.66直销290179.48290179.48中间继电器6198.156198.156215.38中冷直管 627432.5627432.5627026.2中冷直角弯管 141139.38141139.38141238.46中平锉 237.61237.61475.22中型货架(成套)30 38333.3330 38333.33周转箱 100046581.22000 68376.073000 114957.3轴承1195.421195.42轴承 12166.712166.712181.2轴承保持架18.4618.46轴承室15.0615.06主轴193.08193.08助力油0 0.0024490 0.002449铸铁焊条3461.541153.854615.39转动键3641.033641.03转子 91448.14268.38111516.52转子22V134.19134.19转子组件 1117572.79533541.88164 11114.67302615.38锥形套筒110.26110.26紫色丁腈*泡沫涂层手套50 37606.8550 37606.85自封袋400623.94400623.94自攻螺丝30.5630.56自攻螺丝CT4X1671.3271.32自喷漆4642379.484642379.4860384.62自锁螺母12598.2912598.29棕刚玉砂轮 10213.6810213.6820427.36棕扫把70388.8870388.881055.56钻柄套 338.89338.89677.78钻花 40239.8340239.8340260.69钻头3107.693107.69座子0 0.0006560 0.000656销售成本额 结存数量 结存金额55256.41203384.622 277.4054000000.003911709.400000-0.000200.0007803.50061038.521179.491315227822742276228659353032.165257944.534200-0.0018300.0007140.1666.661062.15800.0016000044117.94001305.50018.869200.0008117.95320-0.00323297.44700182.715341.88268.38943.588800.00120-0.0033100.00030-0.0049800201322.7440.5518.550 0.003356111465.81855.8761033.56420.822000 153846.2430.771454.71454.73041.2105861309.2400.0014923.08351.2811327.3511327.35130190.62406.8516 1.284369628.34160-0.001629504034.184388.0323023002.75220 21623.93132 53589.7486 22755.56938.882017.0215 1787.1831375.860011 67.02731117.95320-0.0032589.53600.0042000 36645.2920323.080 0.00074213 259.3655155230.7721243.1553.76111.624270.760 0.0019282299.1442088.89111.1129324.2004 50.1654650175.21551311.195064.10-0.00316423.931769.2340-0.0036110056.410-0.004810012307.7002239.32530.024789.50013298.1042295.61711 122742.95 682.2968009 1169.6842245.241547 124049.625.55300696.674153.162039.6673 388.8835173.850-0.0036800.0046280.34000 0.0033580-0.00342289.500487.520-0.0039485.48400.7520-0.00200.00370000.00426121600.012013471354.711752.140 0.00421200432.482 8.9739732 2174.294128.032147.699 766.153146405.322430.77001.31367.521196.58501196.584213.681209.42068.380-0.00034102713.6819 397.64050058.88000-0.004300589.747600.002415228.6300.00474353.34753183.4511047.0100.00270-0.00491179.48600.004601.5420-0.002471.79440-0.00441657.5730-0.003213 225.02610 0.0021051.846589.749.041 30136.758.63 29541.778.63 29541.7719000 17863.251106.841220.791340.982574.320000164.96164.9600.004740-0.0023800.00540615.3800.00523421.5001615.05235.89002820.391323102.437 196.23912.121087.1810136.7600.00441200.851800 15076.92704 102290.61732.50013.4239.40000458 1875.85514.2753 1659.9231026.674972.250-0.00041179.49518.81001367.5200003184.61700.00324123.0817701.085.7314 80.1734977.059200.00081047.0132109.475256.410047.67 161880.300.00020 0.0046140-0.0035621969.2435.973590 25824.8635120210000020256.41204444.44335.9350358.970046.8410504.2710.56008328.210012.8 41608.55229.061132.56551.28461100.865973851.28000-0.00183136.06800.00200110.262 457.04970-0.0036225.646421171.44558.974410.2600.0009245180.071001068.382531.06 111002.4 105820.40-0.00363712337.76000019 6631.0280017.69132.282628664.732109.410.359200.0008330.76254.7340803.41002 277.784666.1671.813466.651462.57900.0008471.849600.00042.6788813.68123.936205.137.2153.8500.0022006805.4628868.38271.791136.750040581.260