《材料核算-2011.xls》由会员分享,可在线阅读,更多相关《材料核算-2011.xls(20页珍藏版)》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、No.品品番番品名单价(不含税)1F7411-75901排気管131.382F7411-78901排気管124.143F7421-75901排気管12.174F7421-78901排気管13.835F7421-78902排気管8.586F7422-58902排気管74.087F7422-58909排気管49.748F7422-58910排気管58.099F7431-75901排気管65.8610F7431-78901排気管127.0411F7432-75901排気管155.9212F7461-75901排気管40.813F7462-75901排気管46.211490179-06007螺栓0.2
2、51594185-61000螺栓0.681690105-06081螺栓0.211731481-36901-SCZ直管21.011831482-36901-SCZ直管7.611931482-36905-SCZ直管9.22031488-36908-SCZ-A直管23.22131488-36909-SCZ-A直管24.682231489-36901-SCZ直管18.012331489-36904-SCZ直管24.482447311-36903-SCZ直管12.682547313-36903-SCZ直管20.62647318-36901-SCZ直管9.332747321-36903-SCZ直管16.3
3、22847322-36903-SCZ直管23.092947325-36901-SCZ直管10.753047327-36901-SCZ直管7.393147328-36901-SCZ直管7.93247331-36900-SCZ直管7.233347332-36900-SCZ直管13.093447333-36900-SCZ直管15.083547334-36900-SCZ直管12.643647361-36900-SCZ直管11.063747362-36900-SCZ直管5.813847363-36901-SCZ直管15.173947364-36900-SCZ直管16.744047365-36901-SC
4、Z直管9.424147371-28030-SC管夹2.584247371-35130-SC管夹1.564347371-36100-SC管夹3.164447378-36010-SC管夹0.484547381-36160-SC管夹0.724647381-36180-SC管夹2.124777251-0S010-SCZ直管27.50104877251-36901-SCZ直管9.454977251-36902-SCZ直管22.885077252-36901-SCZ直管24.195177253-36905-SCZ直管20.775277253-36906-SCZ直管25.155377253-36907-SC
5、Z直管16.25477254-36901-SCZ直管14.975577254-36902-SCZ直管23.675677255-0S010-SCZ直管14.75885777255-36906-SCZ直管8.835877255-36907-SCZ直管125977256-36901-SCZ直管9.996077257-36905-SCZ直管17.526177257-36906-SCZ直管10.856277257-36907-SCZ直管7.336377258-36901-SCZ直管9.136477258-36902-SCZ直管9.326577261-36902-SCZ直管9.856677263-3690
6、1-SCZ直管14.676777264-36900-SCZ直管8.646877281-36020-SC管夹3.696977285-36070-SC管夹2.957077285-36090-SC管夹5.77177285-36100-SC管夹5.077277285-36110-SC管夹4.857377285-36140-SC管夹3.487477285-36190-SC管夹6.867577285-36200-SC管夹6.167677285-36220-SC管夹5.047777285-37270-SC管夹6.187877295-36010-SC管夹1.767977295-36020-SC管夹1.0980
7、77295-36030-SC管夹1.648177295-36040-SC管夹1.418277298-60060-SC管夹2.488390464-00519-SC管夹0.468490464-00778-SC管夹1.238590464-00874-SC管夹3.478690480-01422-SC管夹1.188790480-01555-SC管夹0.828890949-01249-SC管夹3.678990949-01536-SC管夹2.49090949-01B98-SC管夹2.819190467-06192卡子0.389294223-80500螺母0.1793WSR35K焊丝82.799494223-
8、60500螺母0.45999594223-60600螺母0.59549694223-60800螺母0.68579794223-61000螺母1.03749894223-80800螺母0.86849994223-81000螺母1.1855100 90174-12011螺母3.5931101 17421-0U010直管105.5448102 17422-0U010直管33.9769103 77197-21020-SC管夹1.2825104 90467-18002-SC架子2.4454105 96132-41300-SC软管0.8859106 23271-78690胶套32.3287107 2327
9、3-78660胶套28.22961080.5x15x15无纺布0.70109 0.5x10 x585无纺布1.94110 0.5x10 x70无纺布0.68111 0.5x10 x32无纺布0.46112 0.5x10 x30无纺布0.46113 2x10 x20无纺布0.98114 2x5x170无纺布1.01115 2x20 x40无纺布0.88116 0.5x10 x76无纺布0.681171.6*20*40双面胶2.83118 5-35-88海绵垫0.60119 6-40-88.5海绵垫0.80120 0.5x5x339双面胶1.88单柴/高1111411车柴/豪1111411用汽/高
10、111111411量汽/豪111111411品番86274-0G01086274-0G02086285-0G01086286-0G01051136-0S01051941-0S01057055-0S01057165-0S01057165-0S0200.17 613L94223-8050022210.4599 995L94223-605000.59535 995L94223-60600110.68565 995L94223-60800111.0374 995L94223-6100021.18545 995L94223-8100043.5931 995L90174-1201120.340.340.3
11、40.17-0.600.60-0.690.69-2.07-4.74-7.19-0.340.340.340.177.194.742.071.281.281111111111111111111157175-0S01057176-0S01058173-0S01086285-0S01086286-0S010個711231410226242-0.460.461.790.602.38-1.371.37-1.791.973.750.460.46SFTM審定995L品名A量產品番原材料价格117420-0U010PIPE ASSY,EXHAUST CTR40.88251136-0S010PLATE,FRAME
12、 SIDE RAIL0.42351145-0S010STIFFENER,FRAME SIDE RAIL0.55451145-0S020STIFFENER,FRAME SIDE RAIL0.98551311-0S010GUSSET,FRAME FR CROSSMEMBER2.36651569-0S010GUARD,PROPELLER SHAFT 4.76751569-0S020GUARD,PROPELLER SHAFT 5.47851753-0S010BRACKET,BODY SUPPORT,NO.214.92951758-0S010BRACKET,BODY SUPPORT,NO.4 LH8.8
13、11051941-0S010BRACKET,SPARE WHEEL CARRIER 5.521155425-0S010BRACKET,METER HOOD SET,NO.11.371255759-0S010COVER,HEATER AIR DUCT 7.731357055-0S010REINF SUB-ASSY,C/MEMBER FLR,NO.5 6.141457163-0S010REINFORCEMENT,FR CROSSMEMBER,NO.1 4.541557165-0S010GUSSET,FLOOR MEMBER,RH 7.701657165-0S020GUSSET,FLOOR MEMB
14、ER,LH 7.701757175-0S010BRACKET,FR CROSSMEMBER LWR BRACE,RH 5.171857176-0S010BRACKET,FR CROSSMEMBER LWR BRACE,LH 7.611958173-0S0107.102058574-0S010PLATE,RR FLOOR MAT SUPPORT,RR 10.782158577-0S010PLATE,RR FLOOR MAT SUPPORT SIDE,NO.1 3.482258615-0S0101.702358616-0S0101.702458617-0S010PLATE,RR WHEEL HOU
15、SE MAT 2.572558625-0S010PLATE,RR WHEEL HOUSE MAT,NO.1 3.972658626-0S010PLATE,RR WHEEL HOUSE MAT,NO.2 5.872758627-0S010PLATE,RR WHEEL HOUSE MAT,LH 3.502858644-0S010PLATE,ENGINE SERVICE HOLE MAT,LH 3.252958671-0S010PLATE,CTR DOOR STEP MAT,FR 3.493058671-0S0202.333158672-0S010PLATE,CTR DOOR STEP MAT,RR
16、 3.213258672-0S020PLATE,CTR DOOR STEP MAT,RR 3.573358673-0S010PLATE,CTR DOOR STEP MAT SIDE 5.553461098-0S010STIFFENER SUB-ASSY,PILLAR NO.10 INN,RH10.103561099-0S010STIFFENER SUB-ASSY,PILLAR,NO.10 INN LH10.103667087-0S010PLATE SUB-ASSY,CTR DOOR DUST SEAL,FR 1.663767088-0S010PLATE SUB-ASSY,CTR DOOR DU
17、ST SEAL,RR 1.663874453-0S010BAR,BATTERY SET PLATE 3.103977205-0S010TUBE SUB-ASSY,FUEL MAIN-4086285-0S010BRACKET,AMPLIFIER,NO.11.524186285-0S020BRACKET,AMPLIFIER,NO.11.544286286-0S010BRACKET,AMPLIFIER,NO.23.354386286-0S020BRACKET,AMPLIFIER,NO.21.54229.28188.40BCDEFHIJK部品费加工费小计一般管理利润部品单价包装费运输费部品合计D=A+
18、B+C销售费H=D+E+FK=H+I+J165.9240.59247.3919.7918.70285.880.30-286.180.602.883.890.310.294.500.05-4.55-0.811.360.110.101.570.05-1.62-0.811.790.140.142.070.05-2.12-1.483.840.310.294.440.05-4.490.506.1211.390.910.8613.160.20-13.360.507.2213.191.061.0015.240.20-15.44-5.9720.891.671.5824.140.05-24.19-4.8913.
19、701.101.0415.830.05-15.882.005.8913.401.071.0115.490.20-15.69-5.396.750.540.517.810.20-8.01-20.1427.872.232.1132.200.20-32.40-7.7113.861.111.0516.010.20-16.21-2.316.860.550.527.930.20-8.131.507.3516.551.321.2519.120.20-19.321.507.3516.551.321.2519.120.20-19.320.721.767.650.610.588.840.20-9.043.002.2
20、312.831.030.9714.830.20-15.034.8021.9333.822.712.5639.090.10-39.19-2.5913.371.071.0115.450.20-15.65-2.876.350.510.487.330.20-7.53-3.865.560.440.426.420.20-6.62-3.865.560.440.426.420.20-6.62-3.135.700.460.436.590.20-6.79-2.536.510.520.497.520.20-7.72-2.318.180.650.629.460.20-9.66-2.746.250.500.477.22
21、0.20-7.42-2.455.700.460.436.580.20-6.78-2.866.340.510.487.330.20-7.53-3.075.400.430.416.240.20-6.44-3.947.150.570.548.260.20-8.46-2.566.130.490.467.090.20-7.29-2.908.450.680.649.760.20-9.960.607.6418.331.471.3921.190.20-21.390.607.6418.331.471.3921.190.20-21.390.502.975.130.410.395.930.20-6.130.502.
22、975.130.410.395.930.20-6.13-5.278.380.670.639.680.20-9.88134.355.03139.3811.1510.54161.060.20-161.26-8.279.790.780.7411.310.20-11.51SFTM審定-2.774.320.350.334.990.20-5.19-7.1410.500.840.7912.130.20-12.33-2.774.320.350.334.990.20-5.19317.59246.95793.8163.5160.01917.337.70-925.03工模夹具检具费ABCDEFHIJ总投原材料价格部
23、品费加工费小计一般管理利润部品单价包装费运输费资额D=A+B+C销售费H=D+E+F194,190.33-139.526,798.960.527.1913,798.920.94-13,798.921.18-15,796.993.69-42,578.943.47-68,630.653.47-84,194.9521.24-55,392.877.71-33,599.885.794.7473,634.951.71-33,227.986.20-88,337.324.362.0734,563.393.66-38,569.455.171.2838,569.455.171.2824,499.837.751.7
24、942,889.117.751.97135,994.984.563.7549,258.126.85-45,919.402.13-43,577.980.70-43,577.980.70-35,999.312.03-34,998.012.80-35,899.692.80-23,998.093.67-32,997.721.66-32,559.062.86-23,997.992.51-75,144.863.02-40,909.193.67-31,888.956.56-24,331.237.08-24,331.237.08-74,977.741.351.8874,977.741.321.8819,533
25、.722.49-154,835.17-134.35138,771.941.230.4652,195.981.02-138,764.960.880.4652,195.981.02-2,344,709.91159.78302.6269.5014.97K工模夹具检具费部品合计总投K=H+I+J资额以材料為基準以產品為基準牌格材規單張單車用量品番排樣KgKgKg單價元元元元tLW質量高豪高豪ASSY構成品個數/元/號mmmmmmKg柴柴汽汽張件品番臺套噸品番臺套品番臺套SPHC1.61250250039.2502222 51569-0S010小件25330.0740.1470.2957110.001.
26、052.093.473.476.946.94SPHC1.61250250039.2501111 51569-0S020小件25330.0740.1470.1477110.001.051.053.473.473.473.47SPHC1.61250250039.2501111 55759-0S0101450.8720.8720.8727110.006.206.206.206.20SPHC1.61250250039.2504444 57055-0S01057155-0S0101640.6130.6132.4537110.004.364.3617.4417.444.3604317.44172SPHC1
27、.61250250039.2504444 57055-0S01057228-0S01020.0000.0007110.00-SPHC1.61250250039.2501111 57165-0S0101540.7270.7270.7277110.005.175.175.175.17SPHC1.61250250039.2501111 57165-0S0201540.7270.7270.7277110.005.175.175.175.17SPHC1.61250250039.2501111 57175-0S0101361.0901.0901.0907110.007.757.757.757.75SPHC
28、1.61250250039.2501111 57176-0S0101361.0901.0901.0907110.007.757.757.757.75SPHC2.01500203047.8071111 51136-0S01016450.0740.0740.0747050.000.520.520.520.52SPHC2.01500203047.8076666 51145-0S01013600.1330.1330.7977050.000.940.945.625.62SPHC2.01500203047.8078888 51145-0S02012850.1680.1681.3427050.001.181
29、.189.469.46SPHC2.31250216048.7494444 57055-0S01057229-0S01020.0000.0006600.00-SPHC2.31250216048.7492222 57163-0S0101880.5540.5541.1086600.003.663.667.317.31SPHC2.61440200058.7812222 51569-0S010大件11600.3670.3670.7356600.002.424.85SPHC2.61440200058.7811111 51569-0S020大件11600.3670.3670.3676600.002.422.
30、42SPHC3.21250200062.8002222 51311-0S01011100.5710.5711.1426460.003.693.697.387.38SPHC3.21250162050.86811 74453-0S01011320.3850.3850.3856460.002.492.492.492.49SPHC3.81500162572.7114444 51758-0S010大件1601.2121.2124.8476360.007.7130.837.717.7130.8330.83SPHC3.80.0004444 51758-0S010小件10.0000.0006360.00-SP
31、HC4.01100137047.3202222 51753-0S010大件1162.9572.9575.9156350.0018.7837.5621.2421.2442.4842.48SPHC4.515002100111.2742222 51753-0S010小件115510.2020.2020.4047800.001.583.15SPHC4.515002100111.2742222 51753-0S010小件219800.1140.1140.2277800.000.891.77SPHC4.515002100111.2741111 51941-0S01011500.7420.7420.7427
32、800.005.795.795.795.79-DC53D+ZF0.81080250016.9561111 55425-0S0101980.1730.1730.17399001.711.711.711.71DC53D+ZF1.01250192018.8401111 58173-0S0101350.5380.5380.5388470.004.564.564.564.56DC53D+ZF1.01250192018.8401111 86285-0S010大件11300.1450.1450.1458470.001.231.231.231.231.231.23DC53D+ZF1.01250192018.8
33、401111 86285-0S010小件10.0000.0000.0008470.00-DC53D+ZF1.01250192018.8401111 86285-0S02011560.1210.1210.1218470.001.021.021.021.02DC53D+ZF1.01250192018.8401111 86286-0S010大件11820.1040.1040.1048470.000.880.880.8767850.876785DC53D+ZF1.01250192018.8401111 86286-0S010小件10.0000.0000.0008470.00-DC53D+ZF1.012
34、50192018.8401111 86286-0S02011560.1210.1210.1218470.001.021.021.021.02DC53D+ZF1.2125090010.5981111 61098/9-0S01061815/25-0S0101210.5050.5050.5058370.004.224.227.087.087.087.08DC53D+ZF1.2125087010.2441111 61098/9-0S01061819/29-0S0101300.3410.3410.3418370.002.862.86-SUS4300.71220226215.1641167087-0S01
35、067897-0S01011860.0820.0820.08216500.001.351.351.351.35SUS4300.71220226215.1641167088-0S01067898-0S01011890.0800.0800.08016500.001.321.321.321.32-SUS4300.81220244018.6941111 58574-0S0101450.4150.4150.41516500.006.856.856.856.85SUS4300.81220244018.6941111 58577-0S01011450.1290.1290.12916500.002.132.1
36、3SUS4300.81220244018.6941111 58615-0S01014420.0420.0420.04216500.000.700.700.700.70SUS4300.81220244018.6942222 58616-0S01014420.0420.0420.08516500.000.700.701.401.40SUS4300.81220244018.6942222 58617-0S01011520.1230.1230.24616500.002.032.034.064.06SUS4300.81220244018.694222258625-0S01011100.1700.1700
37、.34016500.002.802.805.615.61SUS4300.81220244018.6941111 58626-0S01011100.1700.1700.17016500.002.802.802.802.80SUS4300.81220244018.6941111 58627-0S0101840.2230.2230.22316500.003.673.673.673.67SUS4300.81220244018.6941111 58644-0S01011860.1010.1010.10116500.001.661.661.661.66SUS4300.81220244018.6941158
38、671-0S01011080.1730.1730.17316500.002.862.862.862.86SUS4300.81220244018.69411 58671-0S02011230.1520.1520.15216500.002.512.512.512.51SUS4300.81220244018.6941158672-0S01011020.1830.1830.18316500.003.023.023.023.02SUS4300.81220244018.69411 58672-0S0201840.2230.2230.22316500.003.673.673.673.67SUS4300.81
39、220244018.6941111 58673-0S0101470.3980.3980.39816500.006.566.566.566.56SAPH4403.23.2141014102379237984.2621 72731-6001012470.3410.3410.3418200.002.802.802.802.80SAPH4403.23.2141014102379237984.2621 72732-6001012470.3410.3410.3418200.002.802.802.802.80牌格材規單張單車用量品番排樣KgKgKg單價元元元元tLW質量高豪高豪ASSY構成品個數/元/號m
40、mmmmmKg柴柴汽汽張件品番臺套噸品番臺套品番臺套09fde8d2b2cf8ab495ff807a3ca2db3e.xls-板材-15/20品番長寬厚度材毛料重LWt质Kg51136-0S010165352 SPHC0.09151145-0S010140702 SPHC0.15451145-0S020140852 SPHC0.18751311-0S0102101203.2 SPHC0.63351569-0S010大件720402.6 SPHC0.58851569-0S020小件190301.6 SPHC0.07251753-0S010大件4452654 SPHC3.70351753-0S01
41、0小件1110604.5 SPHC0.23351753-0S010小件260604.5 SPHC0.12751758-0S010大件4301353.8 SPHC1.73251758-0S010小件55153.8 SPHC0.02551941-0S0102101104.5 SPHC0.81655425-0S0103551500.8 DC53D+ZF0.33455759-0S0102852501.6 SPHC0.89557055-0S01057155-0S0103001601.6 SPHC0.60357055-0S01057228-0S010110501.6 SPHC0.06957055-0S01
42、057229-0S01045452.3 SPHC0.03757163-0S0102701302.3 SPHC0.63457165-0S0102752251.6 SPHC0.77757165-0S0202752251.6 SPHC0.77757175-0S0104102051.6 SPHC1.05657176-0S0104102051.6 SPHC1.05658173-0S0106201251 DC53D+ZF0.60858574-0S0109105050.8 SUS4302.88658577-0S010500500.8 SUS4300.15758615-0S010200700.8 SUS430
43、0.08858616-0S010200700.8 SUS4300.08858617-0S010575400.8 SUS4300.14458625-0S0104601250.8 SUS4300.36158626-0S0104601250.8 SUS4300.36158627-0S0105501300.8 SUS4300.44958644-0S0104601250.8 SUS4300.36158671-0S010405800.8 SUS4300.20358671-0S020445700.8 SUS4300.19658672-0S010400850.8 SUS4300.21458672-0S0204
44、45850.8 SUS4300.23858673-0S010835750.8 SUS4300.39361098-0S0103002101.2 DC53D+ZF0.59361099-0S0102901401.2 DC53D+ZF0.38267087-0S01067897-0S010380500.7 SUS4300.10467088-0S01067898-0S010355500.7 SUS4300.09874453-0S010405453.2 SPHC0.45886285-0S010大件1501451 DC53D+ZF0.17186285-0S010小件55351 DC53D+ZF0.015862
45、85-0S0201651101 DC53D+ZF0.14286286-0S010大件1501001 DC53D+ZF0.11809fde8d2b2cf8ab495ff807a3ca2db3e.xls-板材-16/2086286-0S010小件55351 DC53D+ZF0.01586286-0S0201651101 DC53D+ZF0.14209fde8d2b2cf8ab495ff807a3ca2db3e.xls-冲压件排样-17/20品番長寬厚度材毛料重排样品番長寬厚度材毛料重排样LWt质KgLWt质Kg51569-0S010小件190301.6 SPHC0.07267087-0S01067
46、897-0S010380500.7 SUS4300.10455759-0S0102852501.6 SPHC0.89567088-0S01067898-0S010355500.7 SUS4300.09857055-0S01057155-0S0103001601.6 SPHC0.60358574-0S0109105050.8 SUS4302.88657055-0S01057228-0S010110501.6 SPHC0.06958577-0S010500500.8 SUS4300.15757165-0S0102752251.6 SPHC0.77758615-0S010200700.8 SUS43
47、00.08857165-0S0202752251.6 SPHC0.77758616-0S010200700.8 SUS4300.08857175-0S0104102051.6 SPHC1.05658617-0S010575400.8 SUS4300.14457176-0S0104102051.6 SPHC1.05658625-0S0104601250.8 SUS4300.36151136-0S010165352 SPHC0.09158626-0S0104601250.8 SUS4300.36151145-0S010140702 SPHC0.15458627-0S0105501300.8 SUS
48、4300.44951145-0S020140852 SPHC0.18758644-0S0104601250.8 SUS4300.36157055-0S01057229-0S01045452.3 SPHC0.03758671-0S010405800.8 SUS4300.20357163-0S0102701302.3 SPHC0.63458671-0S020445700.8 SUS4300.19651569-0S020大件720402.6 SPHC0.58858672-0S010400850.8 SUS4300.21451311-0S0102101203.2 SPHC0.63358672-0S02
49、0445850.8 SUS4300.23874453-0S010405453.2 SPHC0.45858673-0S010835750.8 SUS4300.39351758-0S010大件4301353.8 SPHC1.73251758-0S010小件55153.8 SPHC0.025品番長寬厚度材毛料重51753-0S010大件4452654 SPHC3.703LWt质Kg51753-0S010小件1110604.5 SPHC0.23355425-0S0103551500.8 DC53D+ZF0.33451753-0S010小件260604.5 SPHC0.12758173-0S010620
50、1251 DC53D+ZF0.60851941-0S0102101104.5 SPHC0.81686285-0S010大件1501451 DC53D+ZF0.17186285-0S010小件55351 DC53D+ZF0.01586285-0S0201651101 DC53D+ZF0.14286286-0S010大件1501001 DC53D+ZF0.11886286-0S010小件55351 DC53D+ZF0.01586286-0S0201651101 DC53D+ZF0.14261098-0S0103002101.2 DC53D+ZF0.59361099-0S0102901401.2 D