全部
搜索
稻壳儿首页 >

表格模板

 >当前作品

财务管理系统-预算管理

收藏
  • 财务管理系统-预算管理-表格模板,,2020年利润预算表,8620.985454878237.7000989312922.286567629780.972121410464.319453910826.532914312309.360358933600.212727112317.333882712955.022195412322.0629337594.419008110467.776679111953.433072512071.12218434492.3319356135467.935792,8509.458692588144.7676057629418.41433720.98782585797710697.605213533186.88890110.98769877353537076.92716050.98623487578211791.67847411913.242169634037.83477030.986823240419133720.0651690.987097532616,111.5267622992.9324931666158.098528746362.5577842020.0121741420234131.405327176128.927700749152.990798108413.3238260330.0123012264651160.964321847190.834156556165.693369144517.4918475470.0137651242179134.862552411161.754598453157.880014431454.4971652950.01317675958070.0129024673836,0.9733961852740.9732709572190.9718284433620.9724082134590.972678498931,124.301973692118.974746248429.729680480.0144296727027156.265338356484.7776974010.0144278163159541.6014568030.0144064324198172.247020688174.022763169497.207894770.01441502696011953.316729450.0144190336852,23.4123.5772.880.0024472001687126.0425.7224.9276.680.0022821284086175.90.0020189166903625.6447.598.140.00284527007867323.60.00238875714838,53.0448.0552.96154.050.0051727659987753.0752.88159.960.0047606841450453.2154.37161.590.0042982443741253.8853.4366.36173.670.00503503214349649.270.00479279466542,8464.096718898097.2528595112654.265078329215.61465670.98101615144110261.086015810621.069875212056.595312732938.75120370.98031376977312057.005312712658.005078312057.805312736772.81570370.97814560442710261.496015811697.861453311853.079406433812.43687560.980288515681132739.618440.979860050745,0.01819846893420.01704932659950.02074102658860.01942156286270.01897773190470.0205343770.02113513950810.0229267933790.02144589090130.01970625373910.02138060401490.0180631737693,0.81.23.50.0001175247062360.0001428562384110.0001276785258732.05.30.00015365734070718.40.000135825499166,38.833.637.41109.810.0036872537119437.9441.4638.96118.360.0035225967454838.3343.03120.690.0032103169349239.1663.51142.00.00411685705289490.860.00362344046308,30.943610021829.344169592330.810415032791.09819464670.0030589395898630.937656169331.137252598837.365014316899.43992308490.0029595027832931.545014316832.830415032731.298014316895.67344366630.0025448842192731.570812169330.838573887343.8250540305106.2344400870.00307994368967392.4460014850.00289696598084,9.06619162394e-068.03566341061e-067.18191708035e-067.82782679072e-061.087.97236625541e-06,87.855125960578.9130698229200.911074252367.6792700350.0123461137714136.065781919134.275786506177.850031923448.1916003490.0133389512736191.863555662222.566702062195.339602959609.7698606830.0162196910279136.959851154187.113045254112.61772357436.6906199770.012660513091862.331351040.0137473959439,21.963781490119.728267455750.227768562991.91981750880.0030865284428634.016445479833.568946626644.4625079808112.0479000870.0033347378183947.965888915455.641675515648.8349007398152.4424651710.0040549227569734.239962788446.778261313528.1544308925109.1726549940.00316512827251465.5828377610.00343684898598,65.891344470459.1848023671150.683305689275.759452526102.049336439100.70683988133.387523942336.143700261143.897666746166.925026547146.504702219457.327395512102.719888365140.3347839484.4632926774327.5179649831396.74851328,0.007643133701510.007184626977970.01166073085440.00975212357470.009301855051570.010836267690.01168253358370.01288496646540.01188962457440.009812961387490.01174012378620.00699713675246,制表人:审核人:,备注:,2020年利润预算表——不锈钢,8620.985454878237.7000989312922.286567629780.972121410464.319453910826.532914312309.360358933600.212727112317.333882712955.022195412322.0629337594.419008110467.776679111953.433072512071.12218434492.3319356135467.935792,8509.458692588144.7676057629418.41433720.98782585797710697.605213533186.88890110.98769877353537076.92716050.98623487578211791.67847411913.242169634037.83477030.986823240419133720.0651690.987097532616-1747.87062308,111.5267622992.9324931666158.098528746362.5577842020.0121741420234131.405327176128.927700749152.990798108413.3238260330.0123012264651160.964321847190.834156556165.693369144517.4918475470.0137651242179134.862552411161.754598453157.880014431454.4971652950.01317675958070.0129024673836,0.9733961852740.9732709572190.9718284433620.9724082134590.972678498931,124.301973692118.974746248429.729680480.0144296727027156.265338356484.7776974010.0144278163159541.6014568030.0144064324198172.247020688174.022763169497.207894770.01441502696011953.316729450.0144190336852,23.4123.5772.880.0024472001687126.0425.7224.9276.680.0022821284086175.90.0020189166903625.6447.598.140.00284527007867323.60.00238875714838,53.0448.0552.96154.050.0051727659987753.0752.88159.960.0047606841450453.2154.37161.590.0042982443741253.8853.4366.36173.670.00503503214349649.270.00479279466542,8464.096718898097.2528595112654.265078329215.61465670.98101615144110261.086015810621.069875212056.595312732938.75120370.98031376977312057.005312712658.005078312057.805312736772.81570370.97814560442710261.496015811697.861453311853.079406433812.43687560.980288515681132739.618440.979860050745,0.01819846893420.01704932659950.02074102658860.01942156286270.01897773190470.0205343770.02113513950810.0229267933790.02144589090130.01970625373910.02138060401490.0180631737693,0.81.23.50.0001175247062360.0001428562384110.0001276785258732.05.30.00015365734070718.40.000135825499166,38.833.637.41109.810.0036872537119437.9441.4638.96118.360.0035225967454838.3343.03120.690.0032103169349239.1663.51142.00.00411685705289490.860.00362344046308,30.943610021829.344169592330.810415032791.09819464670.0030589395898630.937656169331.137252598837.365014316899.43992308490.0029595027832931.545014316832.830415032731.298014316895.67344366630.0025448842192731.570812169330.838573887343.8250540305106.2344400870.00307994368967392.4460014850.00289696598084,9.06619162394e-068.03566341061e-067.18191708035e-067.82782679072e-061.087.97236625541e-06,87.855125960578.9130698229200.911074252367.6792700350.0123461137714136.065781919134.275786506177.850031923448.1916003490.0133389512736191.863555662222.566702062195.339602959609.7698606830.0162196910279136.959851154187.113045254112.61772357436.6906199770.012660513091862.331351040.0137473959439,21.963781490119.728267455750.227768562991.91981750880.0030865284428634.016445479833.568946626644.4625079808112.0479000870.0033347378183947.965888915455.641675515648.8349007398152.4424651710.0040549227569734.239962788446.778261313528.1544308925109.1726549940.00316512827251465.5828377610.00343684898598,65.891344470459.1848023671150.683305689275.759452526102.049336439100.70683988133.387523942336.143700261143.897666746166.925026547146.504702219457.327395512102.719888365140.3347839484.4632926774327.5179649831396.74851328,0.007643133701510.007184626977970.01166073085440.00975212357470.009301855051570.010836267690.01168253358370.01288496646540.01188962457440.009812961387490.01174012378620.00699713675246,2020年利润预算表——碳钢,15,,2020年直接人工预算表,144.72932114.4729321,16.6949.63208.66,16.0566.0,2.16,3.681.416.662.641.526.485.72.245.4424.28,23.4123.5772.8826.0425.7224.9276.6875.925.6447.598.14323.6,2020年直接人工预算表——不锈钢,144.72932114.4729321,16.6949.63208.66,16.0566.0,2.16,3.681.416.662.641.526.485.72.245.4424.28,23.4123.5772.8826.0425.7224.9276.6875.925.6447.598.14323.6,2020年直接人工预算表——碳钢,2020年制造费用预算,32.7502692.72918908333150.6566115.0656618.0523.125.2599.55,0.1857560.01547966666670.9009250.09009250.280.241.22,1.222290.10185751.731240.173124,1.7063330.1706333,8.5840.71533333333321.5218622.15218629.3227.8110.96,2.084050.20840531.08,2.76,4.6255970.46255971.670.660.733.061.161.031.532.970.9911.34,36.750563.6750565.419.577.3,5.142520.42854333333343.4435234.344352352.553.4213.9,0.0280.0028检测费 ,,3.1296260.3129626,0.1773450.0177345,13.8018031.38018034.818.520.279.7委外加工费 ,0.1295130.0129513,销售运输费 ,,0.3337710.027814250.0650.0065,48.2186064.01821716667280.75198728.075198753.0448.0552.96154.0553.0752.88159.9653.2154.37161.5953.8853.4366.36173.67649.27,2020年制造费用预算——不锈钢,32.7502692.72918908333150.6566115.0656618.0523.125.2599.55,0.1857560.01547966666670.9009250.09009250.280.241.22,1.222290.10185751.731240.173124,1.7063330.1706333,8.5840.71533333333321.5218622.15218629.3227.8110.96,2.084050.20840531.08,2.76,4.6255970.46255971.670.660.733.061.161.031.532.970.9911.34,36.750563.6750565.419.577.3,5.142520.42854333333343.4435234.344352352.553.4213.9,0.0280.0028,3.1296260.3129626,0.1773450.0177345,13.8018031.38018034.818.520.279.7,0.1295130.0129513,0.3337710.027814250.0650.0065,48.2186064.01821716667280.75198728.075198753.0448.0552.96154.0553.0752.88159.9653.2154.37161.5953.8853.4366.36173.67649.27,2020年制造费用预算——碳钢,2020年销售费用预算表,2.6219890.2383626363641.8988560.1582384.9420420.49420421.75.9,0.53760.04887272727271.24940.1041166666672.0848620.2084862,6.610750.60097727272711.175890.9313241666677.4948310.74948313.0514.15,6.924630.6295118181829.596710.79972583333315.3015821.5301582,32.3085852.93714409091129.33254510.7777120833153.13427715.313427717.2751.5153.36213.59,4.0162470.36511336363613.8248011.1520667522.8725942.287259411.8211.7246.88,3.48,0.22910.02082727272733.4173790.34173792.31.114.311.741.611.014.365.041.713.8717.58,0.8065840.07332581818187.1797280.59831066666710.7623611.0762361,1.718840.1718841.14.3,2.2684580.2268458广告费,佣金 ,,26.3873582.3988507272742.4129163.5344096666793.6313029.36313028.624.9113.4销售运输费 ,,0.2833330.02575754545450.1334910.011124250.1183960.0118396检测费 ,,进口相关费用 ,,0.3605650.03004708333330.5916560.0591656,0.37780.03434545454550.4206970.03505808333330.050560.005056,81.1039767.37308872727218.78559918.23213325318.3891431.83891438.833.637.41109.8137.9441.4638.96118.3638.3343.03120.6939.1663.51142.0490.86,2020年销售费用预算表——不锈钢,2.6219890.2383626363641.8988560.1582384.9420420.49420421.75.9,0.53760.04887272727271.24940.1041166666672.0848620.2084862,6.610750.60097727272711.175890.9313241666677.4948310.74948313.0514.15,6.924630.6295118181829.596710.79972583333315.3015821.5301582,32.3085852.93714409091129.33254510.7777120833153.13427715.313427717.2751.5153.36213.59,4.0162470.36511336363613.8248011.1520667522.8725942.287259411.8211.7246.88,3.48,0.22910.02082727272733.4173790.34173792.31.114.311.741.611.014.365.041.713.8717.58,0.8065840.07332581818187.1797280.59831066666710.7623611.0762361,1.718840.1718841.14.3,2.2684580.2268458,26.3873582.3988507272742.4129163.5344096666793.6313029.36313028.624.9113.4,0.2833330.02575754545450.1334910.011124250.1183960.0118396,0.3605650.03004708333330.5916560.0591656,0.37780.03434545454550.4206970.03505808333330.050560.005056,81.1039767.37308872727218.78559918.23213325318.3891431.83891438.833.637.41109.8137.9441.4638.96118.3638.3343.03120.6939.1663.51142.0490.86,2020年销售费用预算表——碳钢,2020年管理费用预算表,2.4905030.2264093636363.0106070.25088391666711.443221.144322,2.6937680.2448886.6333910.5527825833336.0119780.60119787.8,0.865890.07871727272737.300190.6083491666672.1096140.2109614,19.4651321.7695574545568.0724535.6727044166764.4428136.4442813102.0,0.25520.02324.2136830.351140252.7848460.27848464.4,5.4689620.49717836363698.6838058.22365041667102.93814210.29381429.4428.1828.51115.31,0.8311410.075558272727310.2876420.857303515.7021451.57021456.967.0728.61,4.56,1.168680.1062436363643.7765980.31471657.6870790.76870790.582.691.020.910.642.572.911.042.3810.55,1.2843310.1167573636361.7652360.1471032.1210.21214.2,2.773810.25216454545516.584821.382068333338.2178010.8217801,0.4545454545455.2408790.4367399166670.1904860.0190486,0.0430.0043,0.11250.01022727272731.6205810.1350484166670.4360.0436,0.8027910.0802791,0.550.4465090.03720908333330.005咨询顾问费 ,,1.14430.11443,30.0,0.3784270.03440245454552.1555290.1796274166670.071,4.435260.40320545454516.634271.3861891666722.839452.2839452.553610021782.444169592288.828194646733.097656169313.207252598819.949923084953.6480143168311.12344366633.100812169313.538573887323.5750540304910.214440087140.1160014851,11.2770211.12770213.916.5,2.6427740.2402521818185.9958850.4996570833332.6851160.2685116,50.4163784.58330709091252.42207821.0351731667263.63680226.363680230.943610021829.344169592330.810415032791.098194646730.937656169331.137252598837.365014316899.439923084931.545014316832.830415032731.298014316895.673443666331.570812169330.838573887343.8250540305106.234440087392.446001485,2020年管理费用预算表——不锈钢,2.4905030.2264093636363.0106070.25088391666711.443221.144322,2.6937680.2448886.6333910.5527825833336.0119780.60119787.8,0.865890.07871727272737.300190.6083491666672.1096140.2109614,19.4651321.7695574545568.0724535.6727044166764.4428136.4442813102.0,0.25520.02324.2136830.351140252.7848460.27848464.4,5.4689620.49717836363698.6838058.22365041667102.93814210.29381429.4428.1828.51115.31,0.8311410.075558272727310.2876420.857303515.7021451.57021456.967.0728.61,4.56,1.168680.1062436363643.7765980.31471657.6870790.76870790.582.691.020.910.642.572.911.042.3810.55,1.2843310.1167573636361.7652360.1471032.1210.21214.2,2.773810.25216454545516.584821.382068333338.2178010.8217801,0.4545454545455.2408790.4367399166670.1904860.0190486,0.0430.0043,0.11250.01022727272731.6205810.1350484166670.4360.0436,0.8027910.0802791,0.550.4465090.03720908333330.005,1.14430.11443,30.0,0.3784270.03440245454552.1555290.1796274166670.071,4.435260.40320545454516.634271.3861891666722.839452.2839452.553610021782.444169592288.828194646733.097656169313.207252598819.949923084953.6480143168311.12344366633.100812169313.538573887323.5750540304910.214440087140.1160014851,11.2770211.12770213.916.5,2.6427740.2402521818185.9958850.4996570833332.6851160.2685116,50.4163784.58330709091252.42207821.0351731667263.63680226.363680230.943610021829.344169592330.810415032791.098194646730.937656169331.137252598837.365014316899.439923084931.545014316832.830415032731.298014316895.673443666331.570812169330.838573887343.8250540305106.234440087392.446001485,2020年管理费用预算表——碳钢,2020年财务费用预算表,0.6831370.06210336363641.5183020.1265251666670.9424440.0942444,-0.16436-0.0149418181818-0.186822-0.0155685-0.112371-0.0112371-0.12,0.5187770.04716154545451.331480.1109566666670.8300730.0830073,2020年财务费用预算表——不锈钢,0.6831370.06210336363641.5183020.1265251666670.9424440.0942444,-0.16436-0.0149418181818-0.186822-0.0155685-0.112371-0.0112371-0.12,0.5187770.04716154545451.331480.1109566666670.8300730.0830073,2020年财务费用预算表——碳钢, 2020年营业税金及附加预算表 , 2020年营业税金及附加预算表——不锈钢 , 2020年营业税金及附加预算表——碳钢 ,非现金流项目58.0558.9559.5559.55236.1,,2020年其他业务收入预算表,2020年其他业务收入预算表——不锈钢,2020年其他业务收入预算表——碳钢,2020年其他业务支出预算表,2020年其他业务支出预算表——不锈钢,2020年其他业务支出预算表——碳钢,审核人:,备注：,,2020年销售收入预算（第三方销售）2020年销售收入预算（关联方销售）,编制单位：金额：万元（含税）编制单位：金额：万元（含税）,序号材质2020年预算序号材质2020年预算,1月2月3月一季度4月份5月份6月份二季度7月份8月份9月份三季度10月份11月份12月份四季度合计备注1月2月3月一季度4月份5月份6月份二季度7月份8月份9月份三季度10月份11月份12月份四季度合计备注,201.0546.534545455523.111636364819.8018181821889.448663.649090909687.0722131.48472727819.8018181822381.32909091663.649090909757.340727273765.1483636362186.138181828588.4201.0,热轧热轧,304J1冷热轧200.706672727192.104958182301.060009091693.87164243.715245455252.31696782.756023636301.060009091874.507645455243.715245455278.122103636280.989341818802.8266909093153.962304J1冷热轧,304.02912.803078182787.968660554369.2046172710069.9763563536.975166363661.80958411359.93200494369.2046172712691.49912643536.975166364036.312836914077.9243094511651.212312745772.6198304.0,3058.170153582927.105718434587.2552303810572.53110243713.492329353844.5567645111926.8635994587.2552303813324.88424063713.492329354237.750069974281.4382150212232.680614348056.9595563,162.225636364155.273109091243.338454545560.8372196.988272727203.9408632.679981818243.338454545706.840272727196.988272727224.798381818227.115890909648.9025454552549.26,304L4.057772727273.883868181826.0866590909114.02834.927295454555.101215.82531363646.0866590909117.68029545454.927295454555.622913636365.6808818181816.231090909163.765304L,87.849564090684.0845827725131.774346136303.708492999106.674470681110.439452342.613299953131.774346136382.773100681106.674470681121.734395954122.989389727351.3982563631380.49315,7.599681855747.2739812047811.399522783626.27318584419.228185110549.553885761529.638759237411.399522783633.11289951439.2281851105410.530987714410.63955459830.398727423119.423572019,316L246.189113509235.638151501369.283670263851.110935273298.943923546309.494885554960.137542684369.2836702631072.68113743298.943923546341.147771576344.664758912984.7564540353868.68606942316L,715.297620675684.642008361072.946431012472.88606005868.575682248899.2312945632789.660720631072.946431013116.65391865868.575682248991.1981315071001.416668942861.190482711240.391182,157.553788607150.801483381236.330682911544.6859549191.315314738198.067619964614.459775569236.330682911686.484364646191.315314738218.324535642220.57530405630.2151544292475.84524954,321.06.945549041036.6478826535610.418323561524.01175525618.43388097848.7315473658727.0876412610.418323561530.26274939318.43388097849.624546528299.7237686574527.7821961641109.144342073321.0,64.489063842461.725246820696.7335957636222.94790642778.308148951581.0719659733251.50734898596.7335957636280.98806388578.308148951589.363417038790.2846893793257.956255371013.39957467,21.808636845720.873980980932.712955268575.395573095126.481916169727.416572034685.053683698132.712955268595.023346256226.481916169730.22053962930.532091583987.2345473827342.707150432,430.048.277218181846.208194545572.4158272727166.9012458.622336363660.69136188.28115090972.4158272727210.35073636458.622336363666.898430909167.5881054545193.108872727758.642430.0,409L4.055590717363.881779686626.0833860760414.020756484.924645871085.0984569018215.81680379776.0833860760417.67078812564.924645871085.619889994065.677827004316.222362869463.7307112728409L,超纯铁素体443超纯铁素体443,超纯铁素体436L48.326727272746.255581818272.4900909091167.072458.682454545560.7536188.47423636472.4900909091210.56645454558.682454545566.967036363667.6574181818193.306909091759.42超纯铁素体436L,耐热钢4.32114266174.135950833346.4817139925614.93880748765.24710180355.4322936318616.85245638066.4817139925618.82783588315.24710180355.987869116936.0495997263917.284570646867.9036703982耐热钢,热轧3.0以上192.304155092184.062548445288.456232638664.822936176233.512188326241.753794973749.98620486288.456232638837.896675759233.512188326266.478614914269.225817129769.2166203693021.92243716热轧3.0以上,双相钢19.141409478118.321063357628.712114217266.17458705323.243140080624.063486201174.651496964728.712114217283.401855583323.243140080626.524524562526.797973269476.5656379125300.793577513双相钢,镍基合金镍基合金,其他钢种0.8015716762770.7672186044371.202357514422.771147795130.973337035481.007690107323.126129537481.202357514423.492562303780.973337035481.110749322841.122200346793.2062867051112.5961263415其他钢种,碳钢普碳钢碳钢普碳钢,低合金低合金,容器板容器板,高强钢高强钢,耐磨钢耐磨钢,其他热轧其他热轧,碳钢材料销售收入小计碳钢材料销售收入小计,不锈钢材料销售收入小计8509.458692588144.7676057629418.414337210697.605213533186.888901137076.927160511791.67847411913.242169634037.8347703133720.065169不锈钢材料销售收入小计,碳钢、不锈钢材料销售收入小计8509.458692588144.7676057629418.414337210697.605213533186.888901137076.927160511791.67847411913.242169634037.8347703133720.065169碳钢、不锈钢材料销售收入小计,73.792846659370.7610103739110.884269989255.43812702292.062028086293.7494705417106.281209513292.092708141106.751209513112.034269989105.841209513324.62668901592.0720280862103.359373228104.876230647300.3076319611172.46515614,25.44,10.510.0515.7536.312.7513.240.9515.7545.7512.7514.5514.742.0165.0,0.53580.48550.60151.62280.76740.82193.27284.86213.04031.87781.7710796.6891791.29531.51.354.145317.319379,1.230.992.3814.6012.7622.245.389310.39133.70265.4265.014.12864.82094.85.214.820943.9418,19.31063063067.1527927927917.056756756843.520180180218.090090090110.767207207210.594594594639.451891891921.823333333323.067567567618.383630630663.274531531520.324324324320.225225225218.783783783859.3333333333205.579936937,4.0374851.373199.30500214.7156772.8538096.02912310.33289419.2158268.52687930.55851917.5774556.6628481.4815.210.8527.53118.124351,不锈钢加工费小计111.5267622992.9324931666158.098528746362.557784202131.405327176128.927700749152.990798108413.323826033160.964321847190.834156556165.693369144517.491847547134.862552411161.754598453157.880014431454.4971652951747.87062308不锈钢加工费小计,碳钢加工费小计碳钢加工费小计,碳钢、不锈钢加工费收入小计111.5267622992.9324931666158.098528746362.557784202131.405327176128.927700749152.990798108413.323826033160.964321847190.834156556165.693369144517.491847547134.862552411161.754598453157.880014431454.4971652951747.87062308碳钢、不锈钢加工费收入小计,销售收入合计8620.985454878237.7000989312922.286567629780.972121410464.319453910826.532914312309.360358933600.212727112317.333882712955.022195412322.0629337594.419008110467.776679111953.433072512071.12218434492.3319356135467.935792销售收入合计,不锈钢数据可取自“2017不锈钢收入成本预算表”中“5取数表”工作簿中表3不锈钢数据可取自“2017不锈钢收入成本预算表”中“5取数表”工作簿中表4,,2020年销售成本预算（第三方销售）2020年销售成本预算（关联方销售）,编制单位：金额：万元（含税）编制单位：金额：万元（含税）,序号材质2020年预算序号材质2020年预算,1月2月3月一季度4月份5月份6月份二季度7月份8月份9月份三季度10月份11月份12月份四季度合计备注1月2月3月一季度4月份5月份6月份二季度7月份8月份9月份三季度10月份11月份12月份四季度合计备注,201.0534.545454545511.636363636801.8181818181848.0649.090909091672.02084.72727273801.8181818182329.09090909649.090909091740.727272727748.3636363642138.181818188400.0201.0,热轧热轧,304J1冷热轧199.741818182191.181454545299.612727273690.536242.543636364251.104778.993090909299.612727273870.303636364242.543636364276.785090909279.638545455798.9672727273138.8304J1冷热轧,304.02872.591272732749.480218184308.886909099930.95843488.146545453611.257611203.10596364308.8869090912516.29054553488.146545453980.590763644021.6277818211490.365090945140.72304.0,3006.555497672877.70311924509.8332465110394.09186343650.817390033779.669768511725.56644094509.8332465113099.99181133650.817390034166.226903924209.1776967412026.221990747245.8721063,159.822727273152.973181818239.734090909552.53194.070454545200.92623.308636364239.734090909696.370454545194.070454545221.468636364223.751818182639.2909090912511.5,304L4.024363636363.851890909096.0365454545513.91284.886727272735.059215.69501818186.0365454545517.53472727274.886727272735.576618181825.6341090909116.097454545563.24304L,87.217668122683.4797680602130.826502184301.523938367105.907168435109.645068497340.148905678130.826502184380.019839677105.907168435120.858768684122.104735372348.8706724911370.56335621,7.496860677257.1755666482311.245291015925.91771834149.103330822389.4246248514129.237756641311.245291015932.66489295099.1033308223810.388506938510.495604948229.987442709117.807810643,316L243.844219249233.39375271365.766328874843.004300833296.096551945306.547018485950.992455072365.7663288741062.46409816296.096551945337.898418103341.381906949975.3768769973831.83773106316L,707.769886442677.4368913091061.654829662446.86160742859.434862109889.7678572422760.302557131061.654829663083.85450521859.434862109980.766842642990.8778410192831.0795457711122.0982155,155.849595276149.170326907233.774392914538.794315097189.245937121195.92520549607.813421576233.774392914679.058950845189.245937121215.963010597218.189433386623.3983811042449.06506862,321.06.892944559846.5975326501310.339416839823.82989404978.370004108388.6654160180926.882483783410.339416839830.03354415368.370004108389.551651747219.6501223837827.5717782394108.317700226321.0,63.817767283361.08272011495.726650925220.62713832277.493003129780.228050299248.88929240595.726650925278.06312887777.493003129788.433191806989.3448741966255.2710691331002.85062874,21.703097862720.772965097232.554646794175.03070975426.353761690527.28389445684.642081664632.554646794194.563497830526.353761690530.074292752630.384337007886.8123914509341.0486807,430.047.218181818245.194545454570.8272727273163.2457.336363636459.36184.15090909170.8272727273205.73636363657.336363636465.430909090966.1054545455188.872727273742.0430.0,409L3.9653643123.79542012725.94804646813.70883090724.8150852364.985029420815.46492081685.94804646817.2776587884.8150852365.49486197525.551510036815.86145724862.31286776409L,超纯铁素体443超纯铁素体443,超纯铁素体436L47.727272727345.681818181871.5909090909165.057.954545454560.0186.13636363671.5909090909207.95454545557.954545454566.136363636466.8181818182190.909090909750.0超纯铁素体436L,耐热钢4.312039467274.127237775826.4680592009114.9073364445.236047924555.42084961616.81695392246.4680592009118.78817196455.236047924555.975254690366.0368552541817.248157869167.7606202耐热钢,热轧3.0以上190.288793385182.133559383285.433190078657.855542847231.064963397239.220197399742.126294203285.433190078829.115456893231.064963397263.685899405266.40431074761.1551735412990.25246748热轧3.0以上,双相钢18.983277826518.169708776828.474916739765.627903342923.05112307523.864692124774.034783523228.474916739782.712853386823.05112307526.305399273826.576588957175.9331113059298.308651559双相钢,镍基合金镍基合金,其他钢种0.7886158445450.7548180226361.182923766822.7263576340.9576049540910.9914027763.075601793731.182923766823.436111894090.9576049540911.092796241731.104062182363.1544633781812.3925347其他钢种,碳钢普碳钢碳钢普碳钢,低合金低合金,容器板容器板,高强钢高强钢,耐磨钢耐磨钢,其他热轧其他热轧,碳钢材料销售成本小计碳钢材料销售成本小计,不锈钢材料销售成本小计8385.156718898025.7928595128988.684656710541.339875232702.111203736535.325703711619.431453311739.219406433540.6268756131766.74844不锈钢材料销售成本小计,碳钢、不锈钢材料销售成本合计8385.156718898025.7928595128988.684656710541.339875232702.111203736535.325703711619.431453311739.219406433540.6268756131766.74844碳钢、不锈钢材料销售成本合计,不锈钢数据可取自“2017不锈钢收入成本预算表”中“5取数表”工作簿中表5不锈钢数据可取自“2017不锈钢收入成本预算表”中“5取数表”工作簿中表6,,2020年直接人工预算表,编制单位：淄博大明通顺不锈钢有限公司单位:万元,2014年2014年2015年2015年2016年2016年,生产部门：1月2月3月一季度4月5月6月二季度7月8月9月三季度10月11月12月四季度合计,生产一部144.7314.4716.69,生产二部,生产三部,生产四部,精工部,焊接部,应发工资144.7314.4716.6949.63208.66,奖金,五险一金22.42.2416.0566.0,年金2.16,福利费3.681.411.576.662.642.321.526.482.55.72.245.4424.28,总人数,人均人工成本0.4397368421050.6815789473680.6160526315790.6202631578950.6510.6430.6230.64750.6411.1875,总工资167.1316.7125.923.4123.5772.8826.0425.7224.9276.6825.975.925.6447.598.14323.6,制表人:审核人:,注：生产部门根据实际，名称可以修改。 ,, 2020年间接人工预算,编制单位：单位:万元,部门2014年2014年2015年2015年2016年2016年,1月2月3月一季度4月5月6月二季度7月8月9月三季度10月11月12月四季度合计,生产一部21.52,生产二部,生产三部,生产四部,精工部,焊接部,设备部,仓储部5.31,品管部,工艺部,工程服务部,21.529.3227.8110.96,2.080.231.08,2.76,4.630.461.670.660.733.061.161.032.881.532.970.9911.34,1.04.0,0.70250.8123529411760.7482352941180.7523529411760.7776470588240.770.750.7994117647060.7676470588241.47588235294,总工资（与制造费用相关）28.232.8113.8112.7212.7939.3213.2213.0912.7539.0613.5939.1513.0525.0950.92168.45,总裁办,供应部,采购部,管理部5.06,资金部,会计部98.689.86102.944.38,审计部,安保部,项目部,宣传部,信息部,98.689.86102.949.4428.1828.5129.3129.31115.31,1.0315.721.576.967.077.297.2928.61,4.56,3.787.690.771.40.580.712.691.020.910.642.571.572.911.042.3810.55,24.0,0.4695833333330.4510714285710.9026666666670.8433333333330.8520.8726666666670.8653333333330.826250.8843750.851251.615625,总工资（与管理费用相关）112.7511.27126.3512.6313.5412.6538.9713.0912.9813.2239.2914.1540.6513.6225.8552.72171.63,销售部(不分部门）,129.3312.93153.1315.1317.2751.5153.3654.3654.36213.59,13.831.3822.872.2911.8211.7211.6711.6746.88,3.48,3.420.342.30.91.114.311.741.611.014.362.881.713.8717.58,0.8943750.6342857142860.850.7946428571430.8021428571430.8246428571430.7970.7770.8393333333330.8003333333331.622,总工资（与销售费用相关）143.1614.31179.4217.7623.822.2522.4668.5123.0923.9123.3170.3125.1871.9424.0148.6696.05306.81,制表人:审核人:,备注：部门按实际，可修改。,,2020年新增固定资产预算表,编制单位：金额：万元人民币,折旧使用原值,项目种类1月2月3月4月5月6月7月8月9月10月11月12月年限1月2月3月4月5月6月7月8月9月10月11月12月,生产设备 ,办公设备,电脑,打印机,1.0,运输设备,房屋建筑物,其他,合计1.0,按所属成本费用划分,制造费用,销售费用,管理费用,备注：,1、此表反映的是预计本年度转固的固定资产以及新购入不需安装的固定资产，如本年度预计需报废及年度中间提足折旧的固定资产用负数表示,2、所有新增折旧费用按使用部门在成本费用中划分,制表人:审核人:,,2020年资金预算表,编制单位：单位：人民币万元,项 目1月2月3月一季度4月份5月份6月份二季度7月份8月份9月份三季度10月份11月份12月份四季度合计备注check,一、资金收入合计8625.68433768240.9512746312928.024880929794.660493110458.915801410820.954089612304.203926333584.073817312313.412611312961.421697912327.763291337602.597600510473.138792411959.225664312076.79299934509.1574557135490.489367, 销售收入（第三方）8625.68433768240.9512746312928.024880929794.660493110458.915801410820.954089612304.203926333584.073817312313.412611312961.421697912327.763291337602.597600510473.138792411959.225664312076.79299934509.1574557135490.489367-19664.0987268, 销售收入（关联方）, 税费返还收入, 其他收入,二、资金支出合计77.0571.03144.29292.3775.4475.774.2225.3478.82227.6476.32225.14970.49,原材料采购（第三方）,原材料采购（关联方）,生产及运营支出小计77.0571.03144.29292.3775.4475.774.2225.3478.82227.6476.32225.14970.49,胶膜,木架及其他包装材料,备品备件,其他五金辅材,水电费73.0434782609,工资52.7252.252.2157.1253.454.4162.6164.4164.4648.52,奖金,五险一金42.614.414.3543.2143.3843.38172.57,年金12.96,福利费9.053.554.1216.726.565.873.8616.298.4816.625.9814.1263.75,办公费9.52,邮电费10.7547169811,交通费及差旅费18.15,租赁费97.1428571429,交际费26.7,广告费2.83018867925,佣金 ,,宣传费0.943396226415,检测费 ,0.2,委外加工费 68.1196581197,采购运输费 ,,销售运输费 ,102.162162162,进口相关费用 ,,出口相关费用,审计费5.18867924528,培训费1.03773584906,保险费,咨询顾问费 ,,修理费3.07692307692,会务费,其他 ,20.65,采暖费,财务费用支出,金融手续费-1.2,票据贴现支出,利息支出,利息收入（用负数）0.12,税费项目支出,增值税,城建税,教育费附加,企业所得税-465.582837761,房产税-40.1160014851,土地使用税,印花税,职教统筹经费,残疾人保障基金,其他经费支出,工会会费30.0,投资项目支出,办公设备,运输设备,其他设备（不需安装的非生产设备）,已经签订合同，在2020年付设备款,正在谈判，准备签订合同并付设备款,在建及新建厂房等在建工程项目付款,设备基础付款,其他项目投资支付,净收支合计8169.9212746312783.734880910383.475801410745.254089612230.003926333358.733817312239.002611312882.601697912253.353291337374.957600510396.818792411884.815664312002.38299934284.0174557134519.999367,期初货币资金16718.555612239885.766294650631.020384162861.024310475100.026921787982.6286196100235.981911110632.800703122517.616368,期初银行贷款,期初应付票据,本期偿还银行贷款,本期偿还应付票据,本期增加银行贷款,本期增加应付票据,期末货币资金16718.555612239885.766294650631.020384162861.024310475100.026921787982.6286196100235.981911110632.800703122517.616368134519.99936734284.0174557,注：第79行的数据不能为负，B72、B73、B74各分子公司填，75行至79行资金部填。,净现金流核对(本行需等于0）-93.9358061065-101.387996713-223.817500852-419.141303672-131.463946781-136.195023727-150.433799452-418.09276996-150.807243196-136.839875745-136.978457131-424.625576071-14.20503090617.896131387252.39399411497-3.9149054039-1265.77455511,净利润65.891344470459.1848023671150.683305689275.759452526102.049336439100.70683988133.387523942336.143700261143.897666746166.925026547146.504702219457.3273955121069.2305483,原材料采购,直接材料销售成本（含税）9810.63336119390.1776456314715.950041733916.761048411912.911938512333.36765438261.470108314715.950041742746.331073411912.911938513594.734800413734.886705539242.5334444154167.095674,非现金流费用支出 58.0558.9559.5559.55236.1,税费返还及其他收入,增值税税差1253.304561871197.403176661878.43096564329.138704131519.67152671572.275380541787.790314074879.737221321789.128328131883.283494571791.213469675463.625292371521.738115141737.665267461754.74770075014.1510833119686.6523011,资本项目支出,净现金流8642.57014378271.3092713413007.552381729921.431796810514.939748210881.449113312380.437725733776.826587312389.809854513019.441573612390.331748437799.583176510411.023823311876.919532911999.989004834287.9323611135785.773922,制表人：审核人：,备注：,1、销售收入按第三方及关联方分别填列,2、其他收入指收到资本金收入（关联公司除外）等。,3、工资保险及福利指公司为员工支付的应发工资、五险一金、饭贴、旅游费、体检费、高温费、节日礼品费,4、本表不涉及期初银行借款及其他期初债务的偿还,5、所有的收入及支付所收付资金均以货币资金为准,6、净收支合计=资金收入项目合计-资金支出项目合计,7、本表中的相关数据需与综合预算中相关栏目数据勾稽一致,,2020年销售额预算（第三方销售）2020年销售额预算（关联方销售）,金额：万元（含税）金额：万元（含税）,546.534545455523.111636364819.8018181821889.448663.649090909687.0722131.48472727819.8018181822381.32909091663.649090909757.340727273765.1483636362186.138181828588.4,199.741818182191.181454545299.612727273690.536242.543636364251.104778.993090909299.612727273870.303636364242.543636364276.785090909279.638545455798.9672727273138.8,2912.803078182787.968660554369.2046172710069.9763563526.975166363651.8095844151.1472545511329.93200494151.147254554369.204617274161.1472545512681.49912643536.975166364036.312836914077.9243094511651.212312745732.6198,3058.170153582927.105718434587.2552303810572.53110243713.492329353844.5567645111926.8635994587.2552303813324.88424063713.492329354237.750069974281.4382150212232.680614348056.9595563,162.2075155.25575243.31125560.7745196.96625203.918632.60925243.31125706.76125196.96625224.77325227.0905648.832548.975,4.048341818183.874841454556.0725127272713.9956964.915843636365.08934415.78853309096.0725127272717.63920363644.915843636365.609845090915.6676785454516.193367272763.6168,87.543509328883.7916446433131.315263993302.650417965106.302832756110.054697442341.419686382131.315263993381.439576361106.302832756121.310291498122.56091306350.1740373151375.68371802,7.599681855747.2739812047811.399522783626.27318584419.228185110549.553885761529.638759237411.399522783633.11289951439.2281851105410.530987714410.63955459830.398727423119.423572019,245.951855613235.411061801368.927783419850.290700833298.135824673309.196618485958.69223689368.9277834191071.64737088298.655824673340.818999921344.332597858983.8074224513864.43773106,715.29751216684.6419044961072.946268242472.8856849868.57555048899.2311581442789.660297431072.946268243116.65344584868.57555048991.1979811371001.416517022861.1900486411240.3894768,157.480143458150.730994452236.220215187544.431353097191.225888484197.97503749614.172559485236.220215187686.163482209191.225888484218.222484506220.472200841629.9205738312474.68796862,11.348906382310.862524680217.023359573539.23479063613.780814892814.267196594944.260734891117.023359573549.448806380113.780814892815.726341701215.888468935245.3956255293178.339957436,64.477837226361.714501345296.7167558394222.90909441178.294516631981.0578525131251.46356518396.7167558394280.93914791578.294516631989.347860156490.2689721168257.9113489051013.22315641,21.745207020320.813269576632.617810530575.176287127526.40489423927.336831682784.806307379432.617810530594.746973445826.40489423930.132644013930.443289828586.9808280814341.710396034,48.277218181846.208194545572.4158272727166.9012458.622336363660.69136188.28115090972.4158272727210.35073636458.622336363666.898430909167.5881054545193.108872727758.642,4.055590717363.881779686626.0833860760414.020756484.924645871085.0984569018215.81680379776.0833860760417.67078812564.924645871085.619889994065.677827004316.222362869463.7307112728,48.326727272746.255581818272.4900909091167.072458.682454545560.7536188.47423636472.4900909091210.56645454558.682454545566.967036363667.6574181818193.306909091759.42,4.312039467274.127237775826.4680592009114.9073364445.236047924555.42084961616.81695392246.4680592009118.78817196455.236047924555.975254690366.0368552541817.248157869167.7606202,192.206484166183.969063416288.309726249664.485273831233.393587916241.631008666749.605288247288.309726249837.47110958233.393587916266.343270916269.089077832768.8259366643020.38760832,19.103684190118.284954867728.655526285266.044165342923.197330802324.016060124774.504368341428.655526285283.23748111423.197330802326.47224809226.745157866176.4147367604300.200751559,0.8015716762770.7672186044371.202357514422.771147795130.973337035481.007690107323.126129537481.202357514423.492562303780.973337035481.110749322841.122200346793.2062867051112.5961263415,碳钢材料销售额小计碳钢材料销售额小计,不锈钢材料销售额小计8512.033405948147.2319742529427.315489110325.520564410690.84199633166.410283212160.047722837078.145554410336.040564411795.246291111916.846768334048.1336237133720.00495不锈钢材料销售额小计,碳钢、不锈钢材料销售额小计8512.033405948147.2319742529427.315489110325.520564410690.84199633166.410283212160.047722837078.145554410336.040564411795.246291111916.846768334048.1336237133720.00495碳钢、不锈钢材料销售额小计,73.792846659370.7610103739110.884269989255.43812702292.062028086293.7494705417106.281209513292.092708141106.751209513112.034269989105.841209513324.62668901592.0720280862103.359373228104.876230647300.3076319611172.46515614,25.44,10.510.0515.7536.312.7513.240.9515.7545.7512.7514.5514.742.0165.0,0.53580.48550.60151.62280.76740.82193.27284.86213.04031.87781.7710796.6891791.29531.51.354.145317.319379,1.230.992.3814.6012.7622.245.389310.39133.70265.4265.014.12864.82094.85.214.820943.9418,21.43487.939618.93348.307420.0811.951611.7643.791624.223925.60520.4058370.2347322.5622.4520.8565.86228.19373,4.0374851.373199.30500214.7156772.8538096.02912310.33289419.2158268.52687930.55851917.5774556.6628481.4815.210.8527.53118.124351,不锈钢加工费小计113.65093165993.7193003739159.974771989367.345004022133.395237086130.112093542154.156203513417.663534141163.364888513193.371588989167.715568513524.452046015137.098228086163.979373228159.946230647461.0238319611770.48441614不锈钢加工费小计,碳钢加工费小计碳钢加工费小计,碳钢、不锈钢加工费收入小计113.65093165993.7193003739159.974771989367.345004022133.395237086130.112093542154.156203513417.663534141163.364888513193.371588989167.715568513524.452046015137.098228086163.979373228159.946230647461.0238319611770.48441614碳钢、不锈钢加工费收入小计,销售收入合计8625.68433768240.9512746312928.024880929794.660493110458.915801410820.954089612304.203926333584.073817312313.412611312961.421697912327.763291337602.597600510473.138792411959.225664312076.79299934509.1574557135490.489367销售收入合计,不锈钢数据可取自“2017不锈钢收入成本预算表”中“5取数表”工作簿中表1不锈钢数据可取自“2017不锈钢收入成本预算表”中“5取数表”工作簿中表2,2020年销售量预算（第三方销售）2020年销售量预算（关联方销售）,数量：吨数量：吨,碳钢材料销售量小计碳钢材料销售量小计,不锈钢材料销售量小计不锈钢材料销售量小计,碳钢、不锈钢材料销售量小计碳钢、不锈钢材料销售量小计,其中：不锈钢其中：不锈钢,其中：碳钢其中：碳钢,不锈钢数据可取自“2017不锈钢收入成本预算表”中“5取数表”工作簿中表7不锈钢数据可取自“2017不锈钢收入成本预算表”中“5取数表”工作簿中表8,,2020年采购额预算（第三方采购）2020年采购额预算（关联方采购）,金额：万元（含税）金额：万元（含税）,不锈钢数据可取自“2017不锈钢收入成本预算表”中“5取数表”工作簿中表9不锈钢数据可取自“2017不锈钢收入成本预算表”中“5取数表”工作簿中表10,2020年采购量预算（第三方采购）2020年采购量预算（关联方采购）,数量：吨数量：吨,不锈钢数据可取自“2017不锈钢收入成本预算表”中“5取数表”工作簿中表11不锈钢数据可取自“2017不锈钢收入成本预算表”中“5取数表”工作簿中表12,,2020年部门费用预算表,编制部门：单位：人民币万元,2014年2014年2015年2015年2016年2016年2016预算,项 目1月2月3月一季度4月份5月份6月份二季度7月份8月份9月份三季度10月份11月份12月份四季度合计备注,胶膜,木架及其他包装材料,备品备件,其他五金辅材,水电费,办公费,邮电费,交通费及差旅费,租赁费,交际费,广告费,佣金 ,,宣传费,检测费 ,,委外加工费 ,采购运输费 ,,销售运输费 ,,进口相关费用 ,,出口相关费用,审计费,培训费,保险费,咨询顾问费 ,,修理费,会务费,其他 ,,采暖费,合计,制表人：审核人：,注：本表由各公司各部门分别填列后，各公司财务汇总作为编制资金预算及利润预算的依据。,,管理部 2020年 工资及相关费用预算表金额：人民币万元,1月份2月份3月份一季度合计4月份5月份6月份二季度合计7月份8月份9月份三季度合计10月份11月份12月份四季度合计全年合计,部门期初人数其他福利期初人数年终奖年初人数本年净增减人数年末人数年终奖合计,管理部5.060.767.196.7915.1420.736.950.490.356.761.3820.610.817.2220.766.8820.4260.514.2889.42,财务部4.386.355.95.9913.041.2118.246.146.086.4613.393.518.680.766.9314.193.721.3819.890.576.7414.193.7219.754.8114.334.9782.21,……,与管理费用有关总计9.441.413.5412.650.7128.186.962.6938.9713.0912.9813.2228.517.072.5739.2914.1529.317.292.9140.651.0413.6229.317.2940.1212.6115.3112.628.614.5610.55171.63,生技部主管以上人员2.447.212.410.117.192.480.397.260.117.182.2522.322.254.081.3631.09,生产一线员工16.693.681.4123.4123.5749.6316.056.6672.882.6426.0425.721.5224.9276.682.575.92.2425.645.4475.64208.6666.024.28323.6,仓储组5.318.427.587.6315.792.0823.630.87.967.860.447.61.9423.428.0723.317.831.5923.077.562.957.521.967.44100.93,设备组2.152.952.766.438.482.850.222.830.628.450.433.040.758.580.212.820.538.362.5625.692.562.5436.43,与直接人工有关合计16.693.681.4123.4123.5749.6316.056.6672.882.6426.0425.721.5224.9276.682.575.92.2425.645.4475.64208.6666.024.28323.6,与制造费用有关合计9.321.6713.810.6612.720.7312.7927.83.0639.3213.221.0313.0912.752.8839.0613.592.9739.150.9913.0538.6112.31110.9612.3131.082.7611.34168.45,销售管理组4.816.786.340.356.3914.351.3519.516.586.246.082.831.3418.96.6318.810.616.371.2718.5557.2811.3282.52,冷轧组3.323.093.137.119.543.214.514.399.080.7412.114.7610.082.370.9613.5610.082.3713.336.358.56,热轧组2.623.553.337.8210.233.450.213.420.133.3410.210.413.6210.323.4110.113.7531.223.756.722.3344.62,市场组4.435.815.480.2513.2316.845.665.610.8616.765.7716.775.616.65.452.835.410.23.3472.37,开发组1.581.473.44.531.511.474.514.531.514.4713.5719.84,深加工组1.231.122.351.181.123.461.223.421.281.28,计划组1.091.423.254.381.461.424.360.251.610.394.471.464.3212.971.219.33,与销售费用有关合计17.272.323.80.922.2522.4651.5111.824.3168.511.7423.091.6123.911.0123.3153.3611.724.3670.312.8825.1854.3611.6771.941.7124.0154.3611.673.8770.7725.28213.5925.2846.8817.58306.81,总计52.729.0577.0552.23.5571.0352.24.1271.6157.1242.616.72219.68100.053.414.46.5675.44102.054.414.355.8775.73.8674.25.0162.643.2116.29225.348.4878.82164.443.3816.62227.645.9876.32164.443.3814.12225.1472.695.0648.5272.69172.5712.9663.75970.49,制表人：审核人：,备注：,（1）人员净增加以正数表示，净减少用负数表示。,（2）2020年度加薪幅度预计 %，实施月份 月 ,（3）2020年终奖单独列示，见CXW列,（4）部门以各公司实际部门架构为准,本表中未列的请添加，已列不需要的请删除。,（5）提醒：编制综合预算中的直接人工、间接人工时需把年终奖平均分配至各月；做资金预算表时年终奖放至3月份。本表中的累计数需与资金预算表、综合预算表中的人工及福利费累计数一致。,check,check,,土地投资预算表-总裁办,金额：万元,具体项目2020年预算,1月2月3月1季度4月5月6月2季度7月8月9月3季度10月11月12月4季度年度合计备注,合计,,办公设备、运输设备及其他不需安装设备,金额：万元,设备类别2020年预算,1月2月3月1季度4月5月6月2季度7月8月9月3季度10月11月12月4季度年度合计备注,合计,,资金支出预算表-设备项目汇率 美元 欧元 日元 .,金额：万元,具体项目设备采购公司币种原币折人民币截止2016年,已付款预计到货时间设备基础立项时间2020年预算（人民币）,1月2月3月1季度4月5月6月2季度7月8月9月3季度10月11月12月4季度年度合计备注,已签合同,预签合同,资金支出合计,注：行数不够可自行添加,,资金支出预算表-建筑工程项目,编制单位：金额：万元,具体项目建设单位合同总价截止2016,已支付,金额未支付,金额施工期间2020年预算,开工时间完工时间1月2月3月1季度4月5月6月2季度7月8月9月3季度10月11月12月4季度年度合计备注,土建项目,设备基础,已立项,预立项,资金支出合计,注：行数不够可自行添加,,2020年加工收入预算表-不锈钢自有材料（第三方）2020年加工收入预算表-不锈钢自有材料（关联方）,759.2874697879.11144963744726.7465782258.72095893871138.9312046813.66717445622624.9652526931.4995830323921.99192759911.0639031312955.011.462961.6883130135.54025975611138.9312046813.66717445623308.323975539.699887706921.99192759911.06390313121052.1554938512.62586592621063.002457712.75602949243037.1498791536.445798549811932.1274204143.185529044,2978.8722294729.78872229472851.2062767828.51206276784468.308344244.68308344210298.3868504102.9838685043617.2019929336.17201992933744.8679456237.448679456211617.6016949116.1760169494468.308344244.68308344212979.371857129.793718573617.2019929336.17201992934127.8658036941.27865803694170.4211212641.704211212611915.4889179119.15488917946810.8493202468.108493202,448.2527895796.27553905411429.041955746.00658738036672.3791843699.413308581161549.6739296921.6954350156544.3069587757.62029742285563.5177926147.889249096591748.1858793624.474602311672.3791843699.413308581161953.1014403127.3434201643544.3069587757.62029742285621.1502941318.69610411783628.08.7921793.4572529125.10840154077044.4185022698.6218590317,1640.811745789.84487047471570.491242399.422947454362461.2176186714.7673057125672.5206068534.03512364111992.4142627411.95448557642062.7347661312.37640859686399.1658085538.39499485132461.2176186714.7673057127149.2511780642.89550706831992.4142627411.95448557642273.696276313.64217765782297.136444113.78281866466563.2469831339.379481898825784.1845766154.70510746,436.0680381314.36068038131417.3794079254.17379407925654.1020571966.541020571961507.5495032515.0754950325529.5111891595.29511189159548.1998193655.481998193651700.6653487117.0066534871654.1020571966.541020571961900.0107375719.0001073757529.5111891595.29511189159604.2657099816.04265709981610.4952533836.104952533831744.2721525217.44272152526852.4977420668.5249774206,590.8054890523.54483293431565.4852538073.39291152284886.2082335795.317249401472042.4989764412.2549938586717.4066652784.30443999167742.7269005234.456361403142304.141407313.8248484438886.2082335795.317249401472574.2239165915.4453434995717.4066652784.30443999167818.6876062584.91212563755827.1276846734.962766108042363.2219562114.17933173739284.0862565455.7045175392,冷轧干磨145.8375941352.9167518827139.5874115292.79174823058218.7563912024.37512782404504.18139686610.0836279373177.0885071643.54177014327183.3386897693.66677379539568.76661712611.3753323425218.7563912024.37512782404635.43523158712.7087046317177.0885071643.54177014327202.0892375874.04178475174204.1726317894.08345263577583.35037653911.66700753082291.7336221245.8346724424冷轧干磨,卷磨油磨卷磨油磨,冷轧单张油磨冷轧单张油磨,热轧单张油磨热轧单张油磨,压花压花,耐指纹耐指纹,8K8K,6999.9353559465.84284665936699.938126463.021010373998.764269988924199.7765162227.62812702279.95202808628800.3859140282.779470541727300.215069256.79270814198.764269988930499.7183366286.88668901579.95202808629699.910421891.23937322789800.355592992.186230647228000.1875183263.377631961109999.897441034.68515614,1.030.411.310.441.41.37,1.771.726.182.442.727.852.822.952.628.392.828.230.62,1.181.154.121.621.815.221.881.971.745.591.885.4620.39,1.030.411.310.441.41.37,0.710.692.480.971.093.141.131.181.053.361.133.2912.27,0.350.341.231.570.560.590.521.670.561.646.11,3.363.2611.744.635.1614.95.365.64.9715.935.3615.658.17,7.957.7427.8112.1110.9712.2235.312.6913.2711.7837.7412.6936.93137.78,6999.9353559473.79284665936699.938126470.7610103739110.88426998924199.7765162255.43812702292.06202808628800.3859140293.7494705417106.28120951327300.215069292.092708141106.751209513112.034269989105.84120951330499.7183366324.62668901592.07202808629699.9104218103.3593732289800.3555929104.87623064728000.1875183300.307631961109999.897441172.46515614, 3、本表的全年加工成本合计+加工费收入自有材料加工表中（即BC40单元格）的数据之和加上综合预算表中制造费用中的折旧以及生产部门及辅助生产部门发生的办公费用应等于综合预算表中的制造费用全年累计数 3、本表的全年加工成本合计+加工费收入自有材料加工表中（即BC36单元格）的数据之和加上综合预算表中制造费用中的折旧以及生产部门及辅助生产部门发生的办公费用应等于综合预算表中的制造费用全年累计数,2020年加工收入预算表-碳钢自有材料（第三方）2020年加工收入预算表-碳钢自有材料（关联方）,裁剪加工, 3、本表的全年加工成本合计+加工费收入自有材料加工表中（即BC82单元格）的数据之和加上综合预算表中制造费用中的折旧以及生产部门及辅助生产部门发生的办公费用应等于综合预算表中的制造费用全年累计数,,2020年加工收入预算表-不锈钢来料,报送时间：加工量 ：吨加工收入：万元（含税）,加工平台1月2月3月一季度4月5月6月二季度7月8月9月三季度10月11月12月四季度全年合计2020年每月2016实际,固定加工费每月固定加工费吨当变动加工费,简单加工横剪加工冷轧开平420.05.04,冷轧小开平,热轧开平,圆片,纵剪加工冷轧分条240.03.36,冷轧飞边,冷轧小分条,热轧分条1200.0,热轧飞边180.01.08,热轧小分条,表面加工冷轧干磨48.00.96,卷磨油磨,冷轧单张油磨,热轧单张油磨,压花,耐指纹,8K,简单加工小计2388.025.44,深加工切割加工火焰,等离子,激光,水切割,锯床,冲床,成型加工剪板,折弯,圈圆,刨边,矫平,喷砂/喷漆,其它,机加工,焊接,深加工小计,自有材料加工收入小计2388.025.44,注：1、2016年实际数请参考各公司每月车间加工利润预测表中的相关数据，不含土地摊销及其他应计入管理费用或销售费用中的数据。, 2、变动加工成本仅指机物料消耗、水电等费用，不含工资、保险及福利，亦不含办公费、交际应酬费等车间办公费用、, 3、本表的全年加工成本合计+加工费收入来料加工表中（即BC41单元格）的数据之和加上综合预算表中制造费用中的折旧以及生产部门及辅助生产部门发生的办公费用应等于综合预算表中的制造费用全年累计数,2020年加工收入预算表-碳钢来料,报送时间：加工量 ：吨加工收入：万元（含税）,加工平台1月2月3月一季度4月5月6月二季度7月8月9月三季度10月11月12月四季度全年合计2020年每月2016实际,固定加工费每月固定加工费吨当变动加工费,简单加工横剪加工冷轧开平,冷轧小开平,热轧开平,圆片,纵剪加工冷轧分条,冷轧飞边,冷轧小分条,热轧分条,热轧飞边,热轧小分条,简单加工小计,深加工切割加工火焰,等离子,激光,水切割,锯床,冲床,成型加工剪板,折弯,圈圆,刨边,矫平,喷砂/喷漆,其它,机加工,焊接,深加工小计,自有材料加工收入小计,注：1、2016年实际数请参考各公司每月车间加工利润预测表中的相关数据，不含土地摊销及其他应计入管理费用或销售费用中的数据。, 2、变动加工成本仅指机物料消耗、水电等费用，不含工资、保险及福利，亦不含办公费、交际应酬费等车间办公费用、, 3、本表的全年加工成本合计+加工费收入来料加工表中（即BC82单元格）的数据之和加上综合预算表中制造费用中的折旧以及生产部门及辅助生产部门发生的办公费用应等于综合预算表中的制造费用全年累计数,,
模板介绍：
这个模板还没有相关介绍

关注稻壳领福利

相关推荐 查看更多
财务收支管理系统.xls
财务收支管理系统.xls

财务收支管理系统

财务出纳管理系统-财务报表.xls
财务出纳管理系统-财务报表.xls

财务出纳管理系统-财务报表

财务系统-收入支出管理.xlsx
财务系统-收入支出管理.xlsx

财务系统-收入支出管理

财务收支预算管理系统.xlsx
财务收支预算管理系统.xlsx

财务收支预算管理系统

财务系统（个人财务收支管理）.xlsx
财务系统（个人财务收支管理）.xlsx

财务系统（个人财务收支管理）

财务账簿管理系统.xls
财务账簿管理系统.xls

财务账簿管理系统

财务管理系统（生活理财）.xlsx
财务管理系统（生活理财）.xlsx

财务管理系统（生活理财）

财务管理系统-会计记账报表.xlsx
财务管理系统-会计记账报表.xlsx

财务管理系统-会计记账报表

财务管理系统-账务处理.xls
财务管理系统-账务处理.xls

财务管理系统-账务处理

财务收支管理系统-月统计每日明细.xls
财务收支管理系统-月统计每日明细.xls

财务收支管理系统-月统计每日明细

财务记账管理系统-自动统计.xlsx
财务记账管理系统-自动统计.xlsx

财务记账管理系统-自动统计

财务收支利润管理系统.xlsx
财务收支利润管理系统.xlsx

财务收支利润管理系统

模板单价：￥29.99
开通会员可免费下载任意模板与19项权益包
登录后使用
以29.99元购买此模板
  • 页数：19页
  • 时间：2020-04-15
  • 编号：20376905
  • 类型：VIP模板
  • 格式：et
  • 提示：数字产品不支持退货
    数字产品本身（包括但不限于文字模板、表格模板、演示模板等）及其包含的全部素材 （包括但不限于字体、图片、图标、文本框、艺术字等）均不支持商用，仅能为个人学习、研究或欣赏目的使用。

Office办公之家

设计作品1462 独家高品质原创文档

举报

猜你在找

    我的

    关注稻壳领福利

    福利

    反馈

    微信咨询在线客服

    客服