成本核算实例 (3).xls
型号弯管(分)焊接(分)成型(分)配件(分)合计(分)合计(小时)编织(小时)FA0110349.9134.963.624.3272.74.545FA011253230613.20351.25.853FA0312556.5758.829.60.3845.214.087FA0412330.4268.212.403115.183FA0605414.9169.410.50194.83.247FA0810032.1250.934.340.3357.65.960FA090577.73103.69.70121.032.017FA0910023.318124.835264.14.402FA1004784.7282.18320.7470.57.842FA1004960.9193.26112.8327.95.465FA1009514.785.325.18133.12.218FA1009616.8117.231.28.7173.92.898FA1009815.7109.427.38.7161.12.685FA1009916.8125.832.88.7184.13.068FA1010027.9206.626.5352964.933FA1010152.7320.329.653.7456.37.605FA101045.9135.644.946.1232.53.875FA2004533.2374.931.30439.47.323FA2006937.8178.552.394.3362.96.048FT0110840.299.332.12173.62.893FT0111050.4122.712.51.7187.33.122FT0111165.7177.824.15.3272.94.548FT0115962.4133.327.419.3242.44.040FT0207317.6132.344.117.3211.33.522FT02073A17.6132.329.117.3196.33.272FT0415010.656.233.918.1118.81.980FT20049115.1258.550.934.3458.87.647FW0415518.356.522.9097.71.628FW060011.73427.3631.050FW090683.758.921.5084.11.402FW1004313.113929181.13.018FW1007222.5168.647.93.3242.34.038FW1007816.8131.427.35.3180.83.013FW1008215.9100.650.5101772.950FW1008319.31136410206.33.438FW1010920.81294916214.83.580FW1011021.6128.744.216210.53.508FW1011116.397.837.616167.72.795FW1011217.3103.138.516174.92.915FA0188741.5123.53555208.667FA0410459.5148.6208.13.468FA0588753.4143.8375572.29.537FA0120132.8106.551.2190.53.1754.7FA0120316.971.541.2129.62.1604FA0120412.3102446.30.7723.5FA0120551.412316.1190.53.1754.5FA0403511.434.518.2064.11.06810FP011129.574.215.999.61.66017FP0112015.534.712.462.61.04321FP0112115.234.712.462.31.03823FP011365.851.91168.71.14515FP0114225.9109.319.1154.32.57223FP0114627.510028.8156.32.60514FP0114710.468.715.494.51.57543FP0115020.674.723.67.7126.62.11016FP0115215.661.842.3119.71.99540FP0116220.674.723.6118.91.98212FP0181519.6114.317.11512.51742FP0185233.474.725.91342.23365FP01861B49.799.345.30194.33.23878FP01861C14.68241.428.3166.32.77232FP0189435.994.514.2144.62.41060FP0189520.486.519.423.71502.50040FP0285245.3102.140.8188.23.13785FP0289441.7127.218.9187.83.13082FP0289524.4115.726.2166.32.77265FP0381528.4158.628.5215.53.59280FP0385252.5123.856.1232.43.87395FP0389527.8130.530.1188.43.14074FP0403310.946.514.571.91.1983.5FP0413315.251.28.975.31.25510FP0413519.281.218.423.7142.52.37540FP0413613.869.219.6102.61.71032FP0413714.459.214.612.7100.91.68230FP041388.948.713.90.371.81.19713FP0414214.866.219.6100.61.67740FP0415316.477.514.92.7111.51.85813.5FP051523889.542.20.31702.83360FP0585244.7105.248.9198.83.31365FP0605315.375.813.4104.51.74226FP0605810.558.514.183.11.38522FP060608.860.938.2107.91.79820FP0608926.854.516.7981.63339FP080568.291.530.929.3159.92.66538FP08089A11.356.815.1588.21.47023FP08089B7.939.54.2556.60.94316FP090567.779.425.129.3141.52.35828FP090648.450.712.371.41.19015FP090676.648.414.269.21.15315FP09089A9.554.514.2583.21.38710FP09089B8.437.213.45641.06713FP1005612.895.530.929.3168.52.80845FP10056A10.27425.418.7128.32.13833FP10056B454.519.410.788.61.47712FP1005714.2115.441.629.3200.53.34270FP10089A10.757.217.9590.81.51323FP10089B9.44719.40.776.51.27518FP10090B9.447.321.30.778.71.31220FP14089A15.781.120.55122.32.03836FP14089B10.743.215.1691.15020FP2004431.9173.223.92293.81753FP2004733.3142.430.266.7272.64.54345FP2005345230.249.4324.65.41040FP2006140.8171.311438364.16.06880FP2006821.9105.346.413.3186.93.11527FP2008930.364.637.716.41492.483105FP2205217.364.713.495.41.59045FP4000535.783.435.91552.58361FP4015236.4113.656.57.7214.23.57065FP5300122.882.531.17143.42.39040FP5300226.410949.57191.93.19860FP53003880.2114.7103.91.73220FP5306144.51466620276.54.60855FP5505236.7170.121.116.4244.34.07255FV0109820.837.225.483.41.3907.5FV011491898.522.812.71522.53313FV0115582136.455.8274.24.5709FV011569118962.45.3347.75.79511FV01157966.215.4696.61.61029FV0115887.7145.473.519.3325.95.4329FV0207476.83923320.25228.70090FV0414812.871.211.9095.91.5989FV060747.454.219.920.2101.71.69524FV0614913.95218.20.784.81.4137FV1015761.6188.214045.7435.57.25869FV2005832163.746.414.7256.84.28068FV20060132.4273.7100.966.3573.39.55522FV2014929.1171.563.551.3315.45.25726FV7605757.6302.790.170520.48.673151类别FEILOOMFEILOOMFEILOOM2.921333FEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMFEILOOMLOOMLOOMLOOMSUMLOOM472.5SUMLOOM369.6SUMLOOM256.3SUMLOOM460.5SUMLOOM664.1SUMLOOM1119.6SUMLOOM1322.6SUMLOOM1442.3SUMLOOM968.7SUMLOOM1534.3SUMLOOM996.3SUMLOOM2674.5SUMLOOM1086.6SUMLOOM2519.7SUMLOOM838.9SUMLOOM2671SUMLOOM4034SUMLOOM4874.3SUMLOOM2086.3SUMLOOM3744.6SUMLOOM25500.80%SUMLOOM5288.20.86%SUMLOOM5107.80.82%SUMLOOM4066.3SUMLOOM5015.5SUMLOOM5932.4SUMLOOM4628.4SUMLOOM281.9SUMLOOM675.3SUMLOOM2542.5SUMLOOM2022.6SUMLOOM1900.9SUMLOOM851.8SUMLOOM2500.6SUMLOOM921.5SUMLOOM3770SUMLOOM4098.8SUMLOOM1664.5SUMLOOM1403.1SUMLOOM1307.9SUMLOOM2438SUMLOOM2439.9SUMLOOM1468.2SUMLOOM1016.6SUMLOOM1821.5SUMLOOM971.4SUMLOOM969.2SUMLOOM683.2SUMLOOM844SUMLOOM2868.5SUMLOOM2108.3SUMLOOM808.6SUMLOOM4400.5SUMLOOM1470.8SUMLOOM1156.5SUMLOOM1278.7SUMLOOM2282.3SUMLOOM1269SUMLOOM3409SUMLOOM2972.6SUMLOOM2724.6SUMLOOM5164.1SUMLOOM1806.9SUMLOOM6449SUMLOOM2795.4SUMLOOM3815SUMLOOM4114.2SUMLOOM2543.4SUMLOOM3791.9SUMLOOM1303.9SUMLOOM3576.5SUMLOOM3544.3SUMLOOM533.4SUMLOOM932SUMLOOM814.2SUMLOOM1007.7SUMLOOM1836.6SUMLOOM865.9SUMLOOM5922SUMLOOM635.9SUMLOOM1541.7SUMLOOM504.8SUMLOOM4575.5SUMLOOM4336.8SUMLOOM1893.3SUMLOOM1875.4SUMLOOM9580.4成品编码 汇总类别FA01103168715.8 FA01103FEILOOMFA0112533637.58 FA01125FEILOOMFA0120157231.88 FA01201SUMLOOMFA0120328100.93 FA01203SUMLOOMFA01204-105.08 FA01204SUMLOOMFA0120526636.68 FA01205SUMLOOMFA0188773.18 FA01887LOOMFA0312528195.17 FA03125FEILOOMFA040351860.61 FA04035SUMLOOMFA04123256409.2 FA04123FEILOOMFA0588773.18 FA05887LOOMFA060549358.08 FA06054FEILOOMFA081007969.99 FA08100FEILOOMFA090578261.42 FA09057FEILOOMFA091003551.46 FA09100FEILOOMFA100476985.07 FA10047FEILOOMFA10049510.95 FA10049FEILOOMFA101009385.38 FA10100FEILOOMFA1010139924.19 FA10101FEILOOMFA1010420261.38 FA10104FEILOOMFA2004567626.58 FA20045FEILOOMFP0113636323 FP01136SUMLOOMFP0114616342.61 FP01146SUMLOOMFP0114729167.94 FP01147SUMLOOMFP0115212280.71 FP01152SUMLOOMFP0116214688.03 FP01162SUMLOOMFP018151930.02 FP01815SUMLOOMFP01861B 39365.58 FP01861B SUMLOOMFP01861C39412.6 FP01861C SUMLOOMFP0189439634.18 FP01894SUMLOOMFP0189593425.05 FP01895SUMLOOMFP0285215799.81 FP02852SUMLOOMFP0289412473.06 FP02894SUMLOOMFP0289529197.65 FP02895SUMLOOMFP038151759.73 FP03815SUMLOOMFP0385215375.5 FP03852SUMLOOMFP038952876.43 FP03895SUMLOOMFP040338261.45 FP04033SUMLOOMFP04135109794.1 FP04135SUMLOOMFP0413638289.19 FP04136SUMLOOMFP0413760618.49 FP04137SUMLOOMFP0413816589.37 FP04138SUMLOOMFP0515213953.43 FP05152SUMLOOMFP0585220277.65 FP05852SUMLOOMFP060532880.64 FP06053SUMLOOMFP06058425.83 FP06058SUMLOOMFP06060299.97 FP06060SUMLOOMFP060894996.4 FP06089SUMLOOMFP0805611782.77 FP08056SUMLOOMFP08089A2192.01 FP08089A SUMLOOMFP08089B3649.36 FP08089B SUMLOOMFP090569066.49 FP09056SUMLOOMFP09064656.89 FP09064SUMLOOMFP09067834.16 FP09067SUMLOOMFP09089A5117.11 FP09089A SUMLOOMFP09089B 12886.76 FP09089B SUMLOOMFP100569123.49 FP10056SUMLOOMFP10056B1108.64 FP10056B SUMLOOMFP10057768.52 FP10057SUMLOOMFP10089A1124.27 FP10089A SUMLOOMFP10089B6922.44 FP10089B SUMLOOMFP2004410046.44 FP20044SUMLOOMFP20047119371.3 FP20047SUMLOOMFP2006143870.72 FP20061SUMLOOMFP200689377.29 FP20068SUMLOOMFP2008910574.16 FP20089SUMLOOMFP220523991.59 FP22052SUMLOOMFP400055491.26 FP40005SUMLOOMFP4015211770.83 FP40152SUMLOOMFP530012497.73 FP53001SUMLOOMFP530027452.21 FP53002SUMLOOMFP5300326047.54 FP53003SUMLOOMFP5306127695.16 FP53061SUMLOOMFP55052354.01 FP55052SUMLOOMFT011087839.76 FT01108FEILOOMFT0111020673.62 FT01110FEILOOMFT01111-3191.96 FT01111FEILOOMFT0115933692.78 FT01159FEILOOMFT0415014469 FT04150FEILOOMFV01098358850.4 FV01098SUMLOOMFV0115529434.08 FV01155SUMLOOMFV0115624992 FV01156SUMLOOMFV011574476.16 FV01157SUMLOOMFV0115821951.22 FV01158SUMLOOMFV020745050.14 FV02074SUMLOOMFV0414843171 FV04148SUMLOOMFV06074246.05 FV06074SUMLOOMFV101573223.16 FV10157SUMLOOMFV2005817303.22 FV20058SUMLOOMFV2014965715.13 FV20149SUMLOOMFV760575111.44 FV76057SUMLOOMFW060017916.19 FW06001FEILOOMFW090686177.72 FW09068FEILOOMFW10072245626.7 FW10072FEILOOMFW100788285.78 FW10078FEILOOMFW100827309.26 FW10082FEILOOMFW1008322973.13 FW10083FEILOOMFW101095737.13 FW10109FEILOOMFW1011028.73 FW10110FEILOOMFW1011119.09 FW10111FEILOOMFW10112-53.68 FW10112FEILOOM#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A27519023099451成品编码 汇总FA0110344066.09 FA01103FA0112510362.85 FA01125FA012012553.04 FA01201FA01203659.74 FA01203FA031254926.68 FA03125FA0412332682.17 FA04123FA06054404.89 FA06054FA09057694.72 FA09057FA1004710633.66 FA10047FA10049587.5 FA10049FA10095250.2 FA10095FA10096429 FA10096FA10098783.8 FA10098FA10099208.4 FA10099FA101002091.87 FA10100FA101016334.1 FA10101FA101046001.28 FA10104FA2004516032.29 FA20045FP011463691.82 FP01146FP011478288.3 FP01147FP01152409.09 FP01152FP011621508.63 FP01162FP01815510.01 FP01815FP01861B9443.26 FP01861BFP01861C 11196.19 FP01861CFP01894979.02 FP01894FP018954468.69 FP01895FP02852662.66 FP02852FP028945 FP02894FP02895772.09 FP02895FP03815368.72 FP03815FP03852570.15 FP03852FP0389582 FP03895FP041351058.4 FP04135FP04136748.1 FP04136FP04137688.1 FP04137FP041387498.13 FP04138FP0415311759.16 FP04153FP05152918.94 FP05152FP05852394.19 FP05852FP06058353.47 FP06058FP06060675.48 FP06060FP06089147.63 FP06089FP08056565.75 FP08056FP08089A166.26 FP08089AFP09056595.77 FP09056FP09064267.1 FP09064FP090671710.07 FP09067FP09089A370.07 FP09089AFP09089B914.47 FP09089BFP10089B243.43 FP10089BFP20044717.11 FP20044FP2006111986.01 FP20061FP200683365.75 FP20068FP22052208.99 FP22052FP40005516.72 FP40005FP40152442.87 FP40152FP5300124.86 FP53001FP5300284.06 FP53002FP530031790.52 FP53003FP530617553.43 FP53061FT0110810591.48 FT01108FT01110737 FT01110FT0111110418.62 FT01111FT011592446 FT01159FT041501816.37 FT04150FV0109817628.09 FV01098FV011551261.57 FV01155FV011561692.83 FV01156FV01157372.05 FV01157FV011581072.42 FV01158FV020742485.1 FV02074FV0414819290.56 FV04148FV060743008.68 FV06074FV200582499.53 FV20058FV2014914677.84 FV20149FV76057419.66 FV76057FW060019869.23 FW06001FW090681268.69 FW09068FW100724532.15 FW10072FW10082498.09 FW10082FW10083945.97 FW10083FW10109599.21 FW10109FW10110494.15 FW10110FW10111238.3 FW10111FW10112262.6 FW10112#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A347548.9实发1月计件工资1月计提成品名称 数量单价金额成品名称 数量单价FP0111230501500 FP0111250FP0111210050FP0114212891068 FP0114289FP011421295FP0114720516834440 FP01147168FP0115072574104 FP0115057FP01152301474410 FP01152147FP0115230147FP0116280614880 FP0116261FP018526124715067 FP01852247FP0185260247FP01861C4194776 FP01861C194FP028525131516065 FP02852315FP0285242315FP03852103943940 FP03852394FP0385210394FP04138160528320 FP0413852FP0413816052FP041426152912 FP04142152FP0414250152FP0415315858 FP0415358FP05152202204400 FP05152220FP0515220220FP05852392479633 FP05852247FP0585239247FP060607100700 FP06060100FP06089561427952 FP06089142FP0608942142FP08089A311424402 FP08089A142FP08089A30142FP08089B301103300 FP08089B110FP08089B30110FP09089A90534770 FP09089A53FP09089A9053FP09089B90585220 FP09089B58FP09089B9058FP10089A211523192 FP10089A152FP10089A20152FP10089B311213751 FP10089B121FP10089B30121FP14089A102302300 FP14089A230FP14089A10230FP200534120480 FP20053120FP2005343120FP2006133681104 FP20061368FP22052101631630 FP22052163FP2205210163FP55052252907250 FP55052290FP5505210290FV0109820282448672 FV0109824FV010981,95324FV0115733112541375 FV01157125FV01157508125FV101578213511070 FV10157135FV10157125250FV20058286405115830 FV20058405FV20058286405FV201496778054160 FV2014980FV2014967680FV760576683354978 FV76057833FV7605767833#N/A0#N/A06102#N/A6102#N/A0#N/A0#N/A0#N/A0#N/A0#N/A0#N/A0#N/A0#N/A0#N/A0#N/A0合计4659481709金额5,0001,1404,41014,82013,2303,9408,3207,6004,4009,6335,9644,2603,3004,7705,2203,0403,6302,3005,1601,6302,90046,87263,50031,250115,83054,08055,811482,010型号单价FA0105527FA0120120FA0120220FA0120320FA0120413FA0120620FA0188165FA0288195FA03881125FA0401965FA0403527FA0404458FA0407135FA0407753FA0588165FA0603530FA060412FA060422FA0604675FA0803465FA080415FA0904430FA090492FA0905230FA1002770FA10034140FA1107230FA1108130FA1109165FA1109280FA1109395FA1109580FA1402830FA189190FA2002685FA2891125FA6300218FA6300212FN4100165FP0111250FP0112068FP0112179FP0112263FP0112374FP0113558FP0113661FP0113870FP01140160FP0114160FP0114295FP014099185FP01890A220FP01890B100FP01890C150FP01890套320FP01894273FP01895163FP01896170FP01897230FP02890A420FP02890B200FP02890C150FP02890620FP02894415FP02895273FP02897310FP03895336FP03896320FP03897430FP04132110FP04132扶手30FP04132无扶手80FP04135163FP04136147FP04137110FP0413852FP0414060FP04142152FP04143178FP04144180FP0605135FP06052160FP06053130FP0605645FP08054110FP0805695FP0905470FP0905679FP10056152FP10056桌面90FP10057189FP10058140FP10077190FP10080210FP11099190FP14099185FP20038125FP20039135FP2004255FP2004340FP20044336FP20047252FP20052138FP20052128FP20053120FP2005455FP2005535FP20890A155FP20890B215FP20890C85FP20890D50FP20890套505FP31013220FP40005304FP40132120FP40132A30FP53001262FP53002378FP5300389FV0109824FV0109925FV0110070扶手布4FV0412645FP01815180FP02815270FP03815360FP0605885FP08060110FP0906480FP01152147FP01852247FP05152220FP05852247FP08089265FP08089A142FP08089B110FP55052290FP04152220FP06089142FP09089132FP09089A53FP09089B58FP10089285FP10089A152FP10089B121FP14089415FP14089A230FP14089B168FP20089383FP03852394FP40152231FP02852315FP10090350FP10090A205FP10090B136FP22052163FP0114365FP0114455FP01147168FV02891125FP0114655FP0415358FP20056105FP11111136FP11112199FP01148173FP0315095FV0114968FV0614940FV2014980FP400058FV10157250FV0414847FV01157125FP11113215FP01160200FP20059105FV10157395FV10157A260FV10157B135FV20058405FV76057833FV76057A220FV76057B315FV76057C298成品入库成品出库FA011031525 FA01103FA01103#REF!05-372500FA01125285 FA01125FA01125#REF!FA011031560FA0312548 FA03125FA03125#REF!FA01125285FA04123776 FA04123FA04123#REF!FA0312548FA0605410 FA06054FA06054#REF!FA04123970FA09057106 FA09057FA09057#REF!FA0605415FA1004725 FA10047FA10047#REF!FA09057159FA1010035 FA10100FA10100#REF!FA1004725FA10101124 FA10101FA10101#REF!FA1010035FA10104175 FA10104FA10104#REF!FA10101124FA20045216 FA20045FA20045#REF!FA101040FP01146604 FP01146FP01146#REF!FA20045216FP01147204 FP01147FP01147#REF!FP01146316FP0181512 FP01815FP01815#REF!FP01147204FP01861B192 FP01861B FP01861B#REF!FP0181512FP01861C312 FP01861C FP01861C#REF!FP0185230FP01894112 FP01894FP01894#REF!FP01861B192FP028528 FP02852FP02852#REF!FP01861C310FP0289414 FP02894FP02894#REF!FP01894104FP038156 FP03815FP03815#REF!FP0285224FP04136136 FP04136FP04136#REF!FP0289414FP0413868 FP04138FP04138#REF!FP038156FP060536 FP06053FP06053#REF!FP04136126FP060586 FP06058FP06058#REF!FP0413868FP0606050 FP06060FP06060#REF!FP0515214FP0608913 FP06089FP06089#REF!FP060536FP0805634 FP08056FP08056#REF!FP060586FP0905614 FP09056FP09056#REF!FP0606046FP090649 FP09064FP09064#REF!FP0608935FP0906793 FP09067FP09067#REF!FP0805634F
