97国产精品视频|欧美国产偷国产精品三区|在线欧美成人网站网址|亚洲在线色情日本无码视频网|高潮喷水在线日韩精品操|真真操逼视频国产免费啪啪片|超大波少妇欧美亚洲精品日韩一区|久久视频精品91午夜视频|亚洲无码成人动漫精品一区二区|中文字幕久久成人

表2待報廢的殘次破損及呆滯材料資產(chǎn)清查評估明細表評估基準(zhǔn)日：2024年12月16日資產(chǎn)占有單位名稱：瀏陽金源市政工程有限公司金額單位:人民幣元序物料長代碼設(shè)備規(guī)格存放計量物料狀態(tài)處理數(shù)量盤點數(shù)量材質(zhì)重量（公斤）賬面金額評估價值備號名稱型號地點單位單位重量總重量鋼鐵重量銅重量PE塑料重量廢鋼評估單價（元/噸）廢銅評估單價（元/噸）塑料評估單價（元/噸）廢鋼評估價值廢銅評估價值塑料評估價值評估價值注10106007PPR活接球閥Φ20材料倉庫個呆滯9292008=SUM(L7:N7)=I7*J7*0640002950=L7*P7/1000=M7*Q7/1000=N7*R7/1000=S7+T7+U720107007PPR堵帽Φ75材料倉庫個呆滯88014=SUM(L8:N8)=I8*J846722000640002950=L8*P8/1000=M8*Q8/1000=N8*R8/1000=S8+T8+U830110003PPR法蘭片Φ75材料倉庫個呆滯636314=SUM(L9:N9)=I9*J93*0002950=L9*P9/1000=M9*Q9/1000=N9*R9/1000=S9+T9+U940110005PPR法蘭片Φ110材料倉庫個呆滯1111216=SUM(L10:N10)=I10*J1068*02950=L10*P10/1000=M10*Q10/1000=N10*R10/1000=S10+T10+U1050113004PPR管卡Φ40材料倉庫個呆滯9999002=SUM(L11:N11)=I11*J1112082952000640002950=L11*P11/1000=M11*Q11/1000=N11*R11/1000=S11+T11+U1160116004PPR法蘭頭Φ90材料倉庫個呆滯424202=SUM(L12:N12)=I12*J1239482000640002950=L12*P12/1000=M12*Q12/1000=N12*R12/1000=S12+T12+U1270116005PPR法蘭頭Φ110材料倉庫個呆滯4848034=SUM(L13:N13)=I13*J*00640002950=L13*P13/1000=M13*Q13/1000=N13*R13/1000=S13+T13+U1380116006PPR法蘭頭Φ63材料倉庫個呆滯2828012=SUM(L14:N14)=I14*J*640002950=L14*P14/1000=M14*Q14/1000=N14*R14/1000=S14+T14+U1490116007ppr法蘭頭φ75材料倉庫個呆滯2626014=SUM(L15:N15)=I15*J*40002950=L15*P15/1000=M15*Q15/1000=N15*R15/1000=S15+T15+U*-APE法蘭頭-對接Φ63材料倉庫個呆滯8801=SUM(L16:N16)=I16*J*40002950=L16*P16/1000=M16*Q16/1000=N16*R16/1000=S16+T16+U*-APE法蘭頭-對接Φ90材料倉庫個呆滯33018=SUM(L17:N17)=I17*J*0640002950=L17*P17/1000=M17*Q17/1000=N17*R17/1000=S17+T17+U*-APE法蘭頭-對接Φ110材料倉庫個呆滯1103=SUM(L18:N18)=I18*J*40002950=L18*P18/1000=M18*Q18/1000=N18*R18/1000=S18+T18+U*PE抱箍Φ75材料倉庫套呆滯171703=SUM(L19:N19)=I19*J19*40002950=L19*P19/1000=M19*Q19/1000=N19*R19/1000=S19+T19+U19140211002PE抱箍Φ90材料倉庫套呆滯161609=SUM(L20:N20)=I20*J20*640002950=L20*P20/1000=M20*Q20/1000=N20*R20/1000=S20+T20+U20150211004PE抱箍Φ160材料倉庫套呆滯1515356=SUM(L21:N21)=I21*J2*00640002950=L21*P21/1000=M21*Q21/1000=N21*R21/1000=S21+T21+U21160211005PE抱箍Φ200材料倉庫套呆滯1010456=SUM(L22:N22)=I22*J2226*0002950=L22*P22/1000=M22*Q22/1000=N22*R22/1000=S22+T22+U22170503014競達有線水表DN40材料倉庫個呆滯44436=SUM(L23:N23)=J23*04*4=J23*06*4*40002950=L23*P23/1000=M23*Q23/1000=N23*R23/1000=S23+T23+U23180601002防盜閥DN20材料倉庫個呆滯22054=SUM(L24:N24)=I24*J24424072000640002950=L24*P24/1000=M24*Q24/1000=N24*R24/1000=S24+T24+U24190601003防盜閥DN25材料倉庫個呆滯5454086=SUM(L25:N25)=I25*J25*0640002950=L25*P25/1000=M25*Q25/1000=N25*R25/1000=S25+T25+U25200601006防盜閥DN50材料倉庫個呆滯66284=SUM(L26:N26)=I26*J26466742000640002950=L26*P26/1000=M26*Q26/1000=N26*R26/1000=S26+T26+U26210601007防盜閥DN65材料倉庫個呆滯1131131422=SUM(L27:N27)=I27*J2752652*002950=L27*P27/1000=M27*Q27/1000=N27*R27/1000=S27+T27+U27220601010防盜閥DN150材料倉庫個殘次品553886=SUM(L28:N28)=I28*J28264*002950=L28*P28/1000=M28*Q28/1000=N28*R28/1000=S28+T28+U28230601011防盜閥DN200材料倉庫個殘次品1150=SUM(L29:N29)=I29*J2986106112000640002950=L29*P29/1000=M29*Q29/1000=N29*R29/1000=S29+T29+U29240607006過濾器DN150材料倉庫個殘次品2247=SUM(L30:N30)=I30*J3075779542000640002950=L30*P30/1000=M30*Q30/1000=N30*R30/1000=S30+T30+U30250607007過濾器DN200材料倉庫個殘次品32647=SUM(L31:N31)=I31*J31*0640002950=L31*P31/1000=M31*Q31/1000=N31*R31/1000=S31+T31+U31260610008排氣閥DN65材料倉庫個呆滯661404=SUM(L32:N32)=I32*J322920382000640002950=L32*P32/1000=M32*Q32/1000=N32*R32/1000=S32+T32+U32270613004軟密封閘閥DN200材料倉庫個殘次品2280=SUM(L33:N33)=I33*J33*40002950=L33*P33/1000=M33*Q33/1000=N33*R33/1000=S33+T33+U33280613005軟密封閘閥DN65材料倉庫個呆滯11934=SUM(L34:N34)=I34*J34*640002950=L34*P34/1000=M34*Q34/1000=N34*R34/1000=S34+T34+U34290701022螺母M20材料倉庫個呆滯450450=SUM(L35:N35)=36*05244712000640002950=L35*P35/1000=M35*Q35/1000=N35*R35/1000=S35+T35+U35300701023螺母M30材料倉庫個呆滯1414=SUM(L36:N36)=5*051947122000640002950=L36*P36/1000=M36*Q36/1000=N36*R36/1000=S36+T36+U36310701026螺母M22材料倉庫個呆滯12501250=SUM(L37:N37)=(64+34+27)*056826252000640002950=L37*P37/1000=M37*Q37/1000=N37*R37/1000=S37+T37+U37320702002法蘭片DN65材料倉庫個呆滯6460208=SUM(L38:N38)=I38*J388819522000640002950=L38*P38/1000=M38*Q38/1000=N38*R38/1000=S38+T38+U38330702017內(nèi)絲法蘭片DN50材料倉庫個殘次品22054=SUM(L39:N39)=I39*J39259292000640002950=L39*P39/1000=M39*Q39/1000=N39*R39/1000=S39+T39+U39340706001金屬墊DN65材料倉庫個呆滯323201=SUM(L40:N40)=I40*J40*640002950=L40*P40/1000=M40*Q40/1000=N40*R40/1000=S40+T40+U40350706003金屬墊DN150材料倉庫個呆滯2424032=SUM(L41:N41)=I41*J4*0640002950=L41*P41/1000=M41*Q41/1000=N41*R41/1000=S41+T41+U41360706004金屬墊DN200材料倉庫個呆滯1212052=SUM(L42:N42)=I42*J422*40002950=L42*P42/1000=M42*Q42/1000=N42*R42/1000=S42+T42+U42370801008球鐵全框雨水Φ750*450材料倉庫個呆滯6425=SUM(L43:N43)=I43*J43*0640002950=L43*P43/1000=M43*Q43/1000=N43*R43/1000=S43+T43+U43380806005焊彎DN150材料倉庫個殘次品111232=SUM(L44:N44)=I44*J4466*002950=L44*P44/1000=M44*Q44/1000=N44*R44/1000=S44+T44+U44390901001球墨管DN100材料倉庫根呆滯292995=SUM(L45:N45)=I45*J45*640002950=L45*P45/1000=M45*Q45/1000=N45*R45/1000=S45+T45+U45400901002球墨管DN150材料倉庫根呆滯9999144=SUM(L46:N46)=I46*J4665602352000640002950=L46*P46/1000=M46*Q46/1000=N46*R46/1000=S46+T46+U46410901005球墨管DN400材料倉庫根殘次品33482=SUM(L47:N47)=I47*J476462212000640002950=L47*P47/1000=M47*Q47/1000=N47*R47/1000=S47+T47+U47420902001盤承短管DN100材料倉庫個呆滯9991=SUM(L48:N48)=I48*J4887958*2950=L48*P48/1000=M48*Q48/1000=N48*R48/1000=S48+T48+U48430902002盤承短管DN150材料倉庫個呆滯11142=SUM(L49:N49)=I49*J49*0002950=L49*P49/1000=M49*Q49/1000=N49*R49/1000=S49+T49+U49440903001盤插短管DN100材料倉庫個呆滯8896=SUM(L50:N50)=I50*J5076605042000640002950=L50*P50/1000=M50*Q50/1000=N50*R50/1000=S50+T50+U50450903002盤插短管DN150材料倉庫個呆滯1414156=SUM(L51:N51)=I51*J51*40002950=L51*P51/1000=M51*Q51/1000=N51*R51/1000=S51+T51+U51460903005盤插短管DN400材料倉庫個殘次品11704=SUM(L52:N52)=I52*J52535232000640002950=L52*P52/1000=M52*Q52/1000=N52*R52/1000=S52+T52+U52470903007盤插短管DN600材料倉庫個廢品11159=SUM(L53:N53)=I53*J531082832000640002950=L53*P53/1000=M53*Q53/1000=N53*R53/1000=S53+T53+U53480903008盤插短管DN800材料倉庫個廢品22245=SUM(L54:N54)=I54*J5437802000640002950=L54*P54/1000=M54*Q54/1000=N54*R54/1000=S54+T54+U54490903010承插漸縮管600*400材料倉庫個殘次品11142=SUM(L55:N55)=I55*J551020532000640002950=L55*P55/1000=M55*Q55/1000=N55*R55/1000=S55+T55+U55500904001承插盤三通DN150*100材料倉庫個呆滯1010235=SUM(L56:N56)=I56*J56*002950=L56*P56/1000=M56*Q56/1000=N56*R56/1000=S56+T56+U56510904002承插盤三通DN200*100材料倉庫個廢品1132=SUM(L57:N57)=I57*J572838*2950=L57*P57/1000=M57*Q57/1000=N57*R57/1000=S57+T57+U57520904003承插盤三通DN200*150材料倉庫個殘次品1137=SUM(L58:N58)=I58*J5833573382000640002950=L58*P58/1000=M58*Q58/1000=N58*R58/1000=S58+T58+U58530904007承插盤三通DN400*100材料倉庫個廢品11822=SUM(L59:N59)=I59*J59704*02950=L59*P59/1000=M59*Q59/1000=N59*R59/1000=S59+T59+U59540904008承插盤三通DN400*150材料倉庫個廢品44967=SUM(L60:N60)=I60*J60*40002950=L60*P60/1000=M60*Q60/1000=N60*R60/1000=S60+T60+U60550904011承插盤三通DN500*100材料倉庫個廢品及殘次品44115=SUM(L61:N61)=I61*J6*640002950=L61*P61/1000=M61*Q61/1000=N61*R61/1000=S61+T61+U61560904012承插盤三通DN500*150材料倉庫個殘次品11137=SUM(L62:N62)=I62*J621*0002950=L62*P62/1000=M62*Q62/1000=N62*R62/1000=S62+T62+U62570904016承插盤三通DN600*100材料倉庫個廢品11169=SUM(L63:N63)=I63*J63*40002950=L63*P63/1000=M63*Q63/1000=N63*R63/1000=S63+T63+U63580904017承插盤三通DN600*200材料倉庫個廢品44188=SUM(L64:N64)=I64*J646*640002950=L64*P64/1000=M64*Q64/1000=N64*R64/1000=S64+T64+U64590904019承插盤三通DN600*400材料倉庫個廢品66258=SUM(L65:N65)=I65*J659086042000640002950=L65*P65/1000=M65*Q65/1000=N65*R65/1000=S65+T65+U65600904022承插盤三通DN800*200材料倉庫個廢品及殘次品44330=SUM(L66:N66)=I66*J6610*640002950=L66*P66/1000=M66*Q66/1000=N66*R66/1000=S66+T66+U66610904023承插盤三通DN800*300材料倉庫個廢品11374=SUM(L67:N67)=I67*J6729*40002950=L67*P67/1000=M67*Q67/1000=N67*R67/1000=S67+T67+U67620904031承插盤三通DN100*100材料倉庫個呆滯品1010161=SUM(L68:N68)=I68*J68*40002950=L68*P68/1000=M68*Q68/1000=N68*R68/1000=S68+T68+U68630904032承插盤三通DN150*150材料倉庫個殘次品及呆滯品262628=SUM(L69:N69)=I69*J69552087122000640002950=L69*P69/1000=M69*Q69/1000=N69*R69/1000=S69+T69+U69640904033承插盤三通DN150*80材料倉庫個呆滯66215=SUM(L70:N70)=I70*J70*40002950=L70*P70/1000=M70*Q70/1000=N70*R70/1000=S70+T70+U70650904040承插盤三通DN200*200材料倉庫個廢品1148=SUM(L71:N71)=I71*J7*0640002950=L71*P71/1000=M71*Q71/1000=N71*R71/1000=S71+T71+U71660904041承插盤三通DN200*50材料倉庫個殘次品及呆滯品5525=SUM(L72:N72)=I72*J721275652000640002950=L72*P72/1000=M72*Q72/1000=N72*R72/1000=S72+T72+U72670904042承插盤三通DN150*50材料倉庫個殘次品及呆滯品8816=SUM(L73:N73)=I73*J73*40002950=L73*P73/1000=M73*Q73/1000=N73*R73/1000=S73+T73+U73680904043承插盤三通DN400*400材料倉庫個廢品11150=SUM(L74:N74)=I74*J741271*2950=L74*P74/1000=M74*Q74/1000=N74*R74/1000=S74+T74+U74690904046承插盤三通DN1000*300材料倉庫個廢品11564=SUM(L75:N75)=I75*J754663582000640002950=L75*P75/1000=M75*Q75/1000=N75*R75/1000=S75+T75+U75700904048承插盤三通DN250*100材料倉庫個廢品33428=SUM(L76:N76)=I76*J761192052000640002950=L76*P76/1000=M76*Q76/1000=N76*R76/1000=S76+T76+U76710904050承插盤三通DN250*250材料倉庫個廢品11641=SUM(L77:N77)=I77*J7758*02950=L77*P77/1000=M77*Q77/1000=N77*R77/1000=S77+T77+U77720906004盤插彎管90°DN300材料倉庫個呆滯4470=SUM(L78:N78)=I78*J782*02950=L78*P78/1000=M78*Q78/1000=N78*R78/1000=S78+T78+U78730906007盤插彎管90°DN600材料倉庫個廢品11325=SUM(L79:N79)=I79*J792477262000640002950=L79*P79/1000=M79*Q79/1000=N79*R79/1000=S79+T79+U79740906016承插彎管200*1125°200*1125°材料倉庫個殘次品11232=SUM(L80:N80)=I80*J80190942000640002950=L80*P80/1000=M80*Q80/1000=N80*R80/1000=S80+T80+U80750906017承插彎管200*225°材料倉庫個殘次品及呆滯品33252=SUM(L81:N81)=I81*J8*0002950=L81*P81/1000=M81*Q81/1000=N81*R81/1000=S81+T81+U81760906018承插彎管200*45°材料倉庫個殘次品及呆滯品1212282=SUM(L82:N82)=I82*J82279793682000640002950=L82*P82/1000=M82*Q82/1000=N82*R82/1000=S82+T82+U82770906019承插彎管150*45°150*45°材料倉庫個殘次品及呆滯品2424182=SUM(L83:N83)=I83*J833594962000640002950=L83*P83/1000=M83*Q83/1000=N83*R83/1000=S83+T83+U83780906020承插彎管150*90°150*90°材料倉庫個殘次及呆滯品4040214=SUM(L84:N84)=I84*J84704482000640002950=L84*P84/1000=M84*Q84/1000=N84*R84/1000=S84+T84+U84790906021承插彎管250*90°250*90°材料倉庫個呆滯1010541=SUM(L85:N85)=I85*J85478762000640002950=L85*P85/1000=M85*Q85/1000=N85*R85/1000=S85+T85+U85800906022承插彎管250*45°250*45°材料倉庫個呆滯1010402=SUM(L86:N86)=I86*J86355752000640002950=L86*P86/1000=M86*Q86/1000=N86*R86/1000=S86+T86+U86810906023承插彎管90°DN200材料倉庫個呆滯1414342=SUM(L87:N87)=I87*J874004*2950=L87*P87/1000=M87*Q87/1000=N87*R87/1000=S87+T87+U87821207002psp法蘭片DN63材料倉庫個呆滯2828142=SUM(L88:N88)=I88*J881256432000640002950=L88*P88/1000=M88*Q88/1000=N88*R88/1000=S88+T88+U88831207003psp法蘭片DN75材料倉庫個呆滯252521=SUM(L89:N89)=I89*J89972*002950=L89*P89/1000=M89*Q89/1000=N89*R89/1000=S89+T89+U89841207007psp法蘭片DN200材料倉庫個呆滯2525486=SUM(L90:N90)=I90*J9022211252000640002950=L90*P90/1000=M90*Q90/1000=N90*R90/1000=S90+T90+U90851207009psp法蘭片DN300材料倉庫個呆滯44608=SUM(L91:N91)=I91*J9*40002950=L91*P91/1000=M91*Q91/1000=N91*R91/1000=S91+T91+U9186140201襯塑鋼管150材料倉庫米殘次品78781781=SUM(L92:N92)=I92*J929628322000640002950=L92*P92/1000=M92*Q92/1000=N92*R92/1000=S92+T92+U92871403006襯塑90度彎頭DN65材料倉庫個呆滯5050118=SUM(L93:N93)=I93*J93*002950=L93*P93/1000=M93*Q93/1000=N93*R93/1000=S93+T93+U93881505002給水鋼卡DN80材料倉庫個廢品22074=SUM(L94:N94)=I94*J9430462000640002950=L94*P94/1000=M94*Q94/1000=N94*R94/1000=S94+T94+U94891606015涂塑三通DN80*50材料倉庫個殘次品2727166=SUM(L95:N95)=I95*J95412325912000640002950=L95*P95/1000=M95*Q95/1000=N95*R95/1000=S95+T95+U9590PE外絲直接Φ25*1/2材料倉庫個呆滯709709006=SUM(L96:N96)=I96*J962665842000640002950=L96*P96/1000=M96*Q96/1000=N96*R96/1000=S96+T96+U9691襯塑三通φ50*40材料倉庫個呆滯44076=SUM(L97:N97)=I97*J97*02950=L97*P97/1000=M97*Q97/1000=N97*R97/1000=S97+T97+U9792溝槽三通φ65*40材料倉庫個呆滯99118=SUM(L98:N98)=I98*J98526592000640002950=L98*P98/1000=M98*Q98/1000=N98*R98/1000=S98+T98+U9893襯塑大小頭φ100*65材料倉庫個呆滯55098=SUM(L99:N99)=I99*J99*0002950=L99*P99/1000=M99*Q99/1000=N99*R99/1000=S99+T99+U9994PPR法蘭片φ90材料倉庫個呆滯282816=SUM(L100:N100)=I100*J1001*0002950=L100*P100/1000=M100*Q100/1000=N100*R100/1000=S100+T100+U10095襯塑大小頭50*40材料倉庫個呆滯5252034=SUM(L101:N101)=I101*J10*40002950=L101*P101/1000=M101*Q101/1000=N101*R101/1000=S101+T101+U10196絲接法蘭片φ80材料倉庫個呆滯4747286=SUM(L102:N102)=I102*J102292812000640002950=L102*P102/1000=M102*Q102/1000=N102*R102/1000=S102+T102+U10297焊接法蘭片φ50材料倉庫個廢品22054=SUM(L103:N103)=I103*J10356842000640002950=L103*P103/1000=M103*Q103/1000=N103*R103/1000=S103+T103+U10398絲接法蘭片φ65材料倉庫個呆滯33216=SUM(L104:N104)=I104*J104*0002950=L104*P104/1000=M104*Q104/1000=N104*R104/1000=S104+T104+U10499溝槽外絲φ100材料倉庫個廢品33=L105/(I105+I106)=1364*3=1364*379652000640002950=L105*P105/1000=M105*Q105/1000=N105*R105/1000=S105+T105+U105100溝槽內(nèi)絲φ100材料倉庫個廢品22=1364*2=1364*25312000640002950=L106*P106/1000=M106*Q106/1000=N106*R106/1000=S106+T106+U106101伸縮節(jié)φ50材料倉庫個呆滯1313088=SUM(L107:N107)=I107*J107437192000640002950=L107*P107/1000=M107*Q107/1000=N107*R107/1000=S107+T107+U107102涂塑三通Φ80*40材料倉庫個呆滯2121148=SUM(L108:N108)=I108*J1081096412000640002950=L108*P108/1000=M108*Q108/1000=N108*R108/1000=S108+T108+U108103襯塑三通50*20材料倉庫個呆滯7171058=SUM(L109:N109)=I109*J1091067842000640002950=L109*P109/1000=M109*Q109/1000=N109*R109/1000=S109+T109+U109104襯塑三通40*32材料倉庫個呆滯4343046=SUM(L110:N110)=I110*J110519012000640002950=L110*P110/1000=M110*Q110/1000=N110*R110/1000=S110+T110+U110105涂塑大小頭80*65材料倉庫個殘次品66056=SUM(L111:N111)=I111*J111102962000640002950=L111*P111/1000=M111*Q111/1000=N111*R111/1000=S111+T111+U111106涂塑彎頭100材料倉庫個廢品33178=SUM(L112:N112)=I112*J112*0002950=L112*P112/1000=M112*Q112/1000=N112*R112/1000=S112+T112+U112107給水鋼卡DN100材料倉庫個廢品99096=SUM(L113:N113)=I113*J1*640002950=L113*P113/1000=M113*Q113/1000=N113*R113/1000=S113+T113+U113108襯塑三通80*40材料倉庫個殘次品2826148=SUM(L114:N114)=I114*J1*0640002950=L114*P114/1000=M114*Q114/1000=N114*R114/1000=S114+T114+U114109襯塑三通50*32材料倉庫個呆滯2206=SUM(L115:N115)=I115*J1*002950=L115*P115/1000=M115*Q115/1000=N115*R115/1000=S115+T115+U115110襯塑大小頭40*25材料倉庫個呆滯2828026=SUM(L116:N116)=I116*J1*40002950=L116*P116/1000=M116*Q116/1000=N116*R116/1000=S116+T116+U116111襯塑大小頭65*50材料倉庫個呆滯232305=SUM(L117:N117)=I117*J1*640002950=L117*P117/1000=M117*Q117/1000=N117*R117/1000=S117+T117+U117112鋼制大小頭Φ250*100材料倉庫個呆滯11606=SUM(L118:N118)=I118*J1*40002950=L118*P118/1000=M118*Q118/1000=N118*R118/1000=S118+T118+U118113鋼制大小頭Φ200*150材料倉庫個呆滯5519=SUM(L119:N119)=I119*J1194502000640002950=L119*P119/1000=M119*Q119/1000=N119*R119/1000=S119+T119+U119114鋼制大小頭Φ100*80材料倉庫個呆滯22044=SUM(L120:N120)=I120*J120532000640002950=L120*P120/1000=M120*Q120/1000=N120*R120/1000=S120+T120+U120115鋼制大小頭Φ80*65材料倉庫個呆滯99026=SUM(L121:N121)=I121*J121*02950=L121*P121/1000=M121*Q121/1000=N121*R121/1000=S121+T121+U121116鋼制大小頭Φ80*50材料倉庫個呆滯3304=SUM(L122:N122)=I122*J122602000640002950=L122*P122/1000=M122*Q122/1000=N122*R122/1000=S122+T122+U122117涂塑三通Φ80*65材料倉庫個呆滯131214=SUM(L123:N123)=I123*J123403562000640002950=L123*P123/1000=M123*Q123/1000=N123*R123/1000=S123+T123+U123118焊彎Φ50材料倉庫個呆滯1717048=SUM(L124:N124)=I124*J124*0002950=L124*P124/1000=M124*Q124/1000=N124*R124/1000=S124+T124+U124119涂塑三通Φ100*65材料倉庫個殘次品2727198=SUM(L125:N125)=I125*J1251*0002950=L125*P125/1000=M125*Q125/1000=N125*R125/1000=S125+T125+U125120涂塑90度彎頭Φ80材料倉庫個呆滯484812=SUM(L126:N126)=I126*J126*40002950=L126*P126/1000=M126*Q126/1000=N126*R126/1000=S126+T126+U126121PE抱箍Φ110材料倉庫套呆滯55074=SUM(L127:N127)=I127*J12751282000640002950=L127*P127/1000=M127*Q127/1000=N127*R127/1000=S127+T127+U127122鐵抱箍Φ250*300材料倉庫套廢品11=ROUND(2*314*125*03*785,2)=SUM(L128:N128)=I128*J1288852000640002950=L128*P128/1000=M128*Q128/1000=N128*R128/1000=S128+T128+U128123抱箍Φ500*500材料倉庫套呆滯44=ROUND(2*314*25*05*785,2)=SUM(L129:N129)=I129*J1294302642000640002950=L129*P129/1000=M129*Q129/1000=N129*R129/1000=S129+T129+U129124抱箍Φ400*500材料倉庫套呆滯33=ROUND(2*314*2*05*785,2)=SUM(L130:N130)=I130*J*00640002950=L130*P130/1000=M130*Q130/1000=N130*R130/1000=S130+T130+U130125廢抱箍Φ500*500材料倉庫套呆滯44=ROUND(2*314*25*05*785,2)=SUM(L131:N131)=I131*J*0640002950=L131*P131/1000=M131*Q131/1000=N131*R131/1000=S131+T131+U131126廢彎頭DN150材料倉庫套呆滯111232=SUM(L132:N132)=I132*J*0640002950=L132*P132/1000=M132*Q132/1000=N132*R132/1000=S132+T132+U132127抱箍Φ160材料倉庫套呆滯11145=SUM(L133:N133)=I133*J*40002950=L133*P133/1000=M133*Q133/1000=N133*R133/1000=S133+T133+U133128抱箍Φ500材料倉庫套呆滯22=ROUND(2*314*25*033*785,2)=SUM(L134:N134)=I134*J*00640002950=L134*P134/1000=M134*Q134/1000=N134*R134/1000=S134+T134+U134129抱箍Φ600材料倉庫套呆滯11=ROUND(2*314*3*033*785,2)=SUM(L135:N135)=I135*J*00640002950=L135*P135/1000=M135*Q135/1000=N135*R135/1000=S135+T135+U135130抱箍Φ600*500材料倉庫套呆滯22=ROUND(2*314*3*05*785,2)=SUM(L136:N136)=I136*J*0640002950=L136*P136/1000=M136*Q136/1000=N136*R136/1000=S136+T136+U136131螺桿24*150材料倉庫斤呆滯452452=SUM(L137:N137)4522382042000640002950=L137*P137/1000=M137*Q137/1000=N137*R137/1000=S137+T137+U137132螺桿16*120材料倉庫斤呆滯242242=SUM(L138:N138)24239932000640002950=L138*P138/1000=M138*Q138/1000=N138*R138/1000=S138+T138+U138133螺桿22*100~120材料倉庫斤呆滯300300=SUM(L139:N139)3007682000640002950=L139*P139/1000=M139*Q139/1000=N139*R139/1000=S139+T139+U139134螺桿12*70材料倉庫斤呆滯6262=SUM(L140:N140)6232862000640002950=L140*P140/1000=M140*Q140/1000=N140*R140/1000=S140+T140+U140135膨脹螺絲16*180材料倉庫斤呆滯8282=SUM(L141:N141)822*02950=L141*P141/1000=M141*Q141/1000=N141*R141/1000=S141+T141+U141136彈簧墊片24材料倉庫斤呆滯7474=SUM(L142:N142)7423682000640002950=L142*P142/1000=M142*Q142/1000=N142*R142/1000=S142+T142+U142137彈簧墊片22材料倉庫斤呆滯88=SUM(L143:N143)8*02950=L143*P143/1000=M143*Q143/1000=N143*R143/1000=S143+T143+U143138彈簧墊片16材料倉庫斤呆滯1414=SUM(L144:N144)*0002950=L144*P144/1000=M144*Q144/1000=N144*R144/1000=S144+T144+U144139平板墊片22材料倉庫斤呆滯7676=SUM(L145:N145)76*002950=L145*P145/1000=M145*Q145/1000=N145*R145/1000=S145+T145+U145140平板墊片20材料倉庫斤呆滯2626=SUM(L146:N146)264682000640002950=L146*P146/1000=M146*Q146/1000=N146*R146/1000=S146+T146+U146141平板墊片16材料倉庫斤呆滯1212=SUM(L147:N147)120962000640002950=L147*P147/1000=M147*Q147/1000=N147*R147/1000=S147+T147+U147142閘閥Φ50材料倉庫呆滯99284=SUM(L148:N148)=I148*J*640002950=L148*P148/1000=M148*Q148/1000=N148*R148/1000=S148+T148+U148143堵板材料倉庫呆滯661023=SUM(L149:N149)=I149*J*0640002950=L149*P149/1000=M149*Q149/1000=N149*R149/1000=S149+T149+U149合計=SUM(H7:H149)=SUM(I7:I149)=SUM(K7:K149)=SUM(L7:L149)=SUM(M7:M149)=SUM(N7:N149)=SUM(O7:O149)=SUM(S7:S149)=SUM(T7:T149)=SUM(U7:U149)=SUM(V7:V149)