预算损益表.xlsx

20332033年年销销售售收收入入预预算算表表销销售售收收入入预预算算月月份份1 12 23 34 45 56 67 7销销售售总总收收入入单位：元52840528405187551875489524895247049.647049.6 41876.341876.3 38999.638999.6 47211.347211.3销销量量A 产品单位：件100125130135130136155B 产品单位：件15012010086684868定定价价策策略略价价格格变变动动A 产品-3%B 产品1%-2%单单价价定价A 产品单位：元220.00213.4213.4213.4213.4213.4213.4213.4B 产品单位：元210.00210210212.1212.1207.858207.858207.858销销售售收收入入A 产品单位：元21340.026675.027742.028809.027742.029022.433077.0B 产品单位：元31500.025200.021210.018240.614134.39977.214134.3销销售售收收入入合合计计52840.051875.048952.047049.641876.338999.647211.3收收入入结结构构当月销售/年销售收入（）8.5%8.3%7.9%7.6%6.7%6.3%7.6%8 89 9101011111212合合计计6310663106607036070360541605415726157261 51006.651006.6 621419.76621419.76200180170160134175588981081009811325%3%224.07224.07224.07224.07224.07207.858207.858207.858214.094214.093744814.040332.6 38091.935851.230025.4383522.518291.520370.1 22448.721409.420981.2237897.363105.560702.7 60540.657260.651006.6621419.810.2%9.8%9.7%9.2%8.2%100.0%100.0%20332033年年销销售售收收入入预预算算表表价价格格变变动动20332033年年材材料料预预算算表表材材料料预预算算月月份份1 12 23 34 45 56 6合计物料标准成本39075.039075.0 37026.637026.635032.335032.334973.634973.632205.632205.629229.829229.8标准物料成本#37026.60 35032.25 34973.56 32205.65 29229.80销售收入比例74%71%72%74%77%75%物料成本差异（人工输入）0-8341388.58000占合计物料标准成本比例0%-2%4%0%0%0%共计物料成本#36192.60 36420.83 34973.56 32205.65 29229.80占销售收入比例74%70%74%74%77%75%物物料料成成本本变变动动国内物料成本1%3%-1%单单位位物物料料成成本本A产品150.00151.50151.50156.05156.05154.48154.48B产品160.50162.11162.11166.97166.97165.30165.30共共计计物物料料成成本本A产品15000.017574.018821.820614.320851.821295.5B产品24075.019452.616210.514359.311353.87934.3合计39075.037026.635032.334973.632205.629229.87 78 89 9101011111212全全年年合合计计37120.237120.243980.343980.349319.149319.150971.450971.449649.549649.549319.149319.1487902.35487902.3537120.21 43980.2749319.0650971.3849649.5249319.06487902.3579%70%81%84%87%97%79%1321.540-1023.52000852.64%0%-2%0%0%0%0%38441.75 43980.2748295.5450971.3849649.5249319.06488754.9581%70%80%84%87%97%79%-2%2%151.39154.42154.42154.42154.42154.42161.99165.23165.23165.23165.23165.2325879.929724.933126.333126.333126.333126.311240.314255.316192.817845.116523.216192.837120.243980.349319.150971.449649.549319.120332033年年材材料料预预算算表表2033年年人人工工预预算算表表材材料料预预算算月月份份1 12 23 34 45 56 67 7人工成本合计3535.403535.403535.403535.403535.403535.403535.403535.403692.503692.503692.503692.503692.503692.50直接人工1850.121850.121850.121850.121850.121850.121850.12间接人工1258.031258.031258.031258.031361.331361.331361.33管理人员427.25427.25427.25427.25481.05481.05481.058 89 9101011111212全全年年合合计计3692.503692.503692.503692.503692.503692.503692.503692.503692.503692.5043681.631850.121850.121850.121850.121850.1222201.441361.331361.331361.331361.331361.3315922.77481.05481.05481.05481.05481.055557.422033年年人人工工预预算算表表2033年年制制造造费费用用预预算算表表月月份份1 12 23 34 45 56 67 78 8制制造造费费用用4,1914,1914,2284,2284,2284,2284,2784,2784,3744,3744,4894,4894,5454,5454,5454,545工资663663663663726726726726职工福利基金88888888保险费00000000社会保险基金417417417417417417417417差旅费833833833833833833833833通讯费44444444办公费2,0002,0002,0002,0002,0002,0002,0002,000水33333333电22222222汽00000000空调暖气00000000维修费00000000机物料消耗00000000清洗费00000000折旧214251251301334449505505低耗摊销88888888场所租赁费00000000制版费44444444运费00000000质检费00000000内部培训费00000000招聘费2121212121212121会务费88888888其他100000000其他277777777合计4,1914,2284,2284,2784,3744,4894,5454,5459 9101011111212合合计计4,5454,5454,5454,5454,5454,5454,5454,54553,05953,0597267267267268,4598,459888810010000000 04174174174175,0005,00083383383383310,00010,000444445452,0002,0002,0002,00024,00024,000333330302222202000000 000000 000000 000000 000000 05055055055054,8304,8308888909000000 04444505000000 000000 000000 021212121250250888810010000000 0777785854,5454,5454,5454,54553,0592033年年制制造造费费用用预预算算表表20332033年年预预算算损损益益表表公司名称华云信息有限公司预算年度预算损益表20332033年年1 12 23 34 45 56 67 7收入A产品100,00021,34026,67527,74228,80927,74229,02233,077D产品75,00031,50025,20021,21018,24114,1349,97714,134收收入入合合计计175,00052,84051,87548,95247,05041,87639,00047,211销售成本直接材料107,22139,07537,02735,03234,97432,20629,23037,120直接人工9,8733,5353,5353,5353,5353,6933,6933,693制造费用21,927663663663663726726726销销售售成成本本合合计计139,02143,27341,22539,23139,17236,62433,64841,539材料/销售收入（%）61%74%71%72%74%77%75%79%人工/销售收入（%）6%7%7%7%8%9%9%8%毛利（%）21%18%21%20%17%13%14%12%主主营营业业务务利利润润35,9879,56710,6509,7217,8785,2525,3515,673%销售收入21%18%21%20%17%13%14%12%管理费用25,40221,16021,26121,27122,26222,31522,31522,315营业费用2,4322,8542,8162,8162,8162,8162,8162,816财务费用2,723218218218217217217269营营业业利利润润5,430-14,665-13,645-14,584-17,418-20,096-19,997-19,727所得税-净净利利润润5,430-%销售收入3%0%0%0%0%0%0%0%制表时间8 89 910101111121220332033年年44,81440,33338,09235,85130,025383,52218,29220,37022,44921,40920,981237,89763,10660,70360,54157,26151,007621,42043,98049,31950,97149,65049,319487,9023,6933,6933,6933,6933,69343,6827267267267267268,45948,39953,73855,39054,06853,738540,04370%81%84%87%97%79%6%6%6%6%7%7%23%11%9%6%-5%13%14,7076,9655,1513,193-2,73181,37623%11%9%6%-5%13%22,31522,31523,32023,32023,320267,4892,8162,8162,8162,8162,81633,8302812832832722602,956-10,705-18,449-21,268-23,215-29,127-222,898-0%0%0%0%0%0%20332033年年预预算算损损益益表表