《(专业财务模板)材料预算表.xlsx》由会员分享,可在线阅读,更多相关《(专业财务模板)材料预算表.xlsx(4页珍藏版)》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、20132013年年销销售售收收入入预预算算表表公司名称华云信息有限公司预算年度2013年制表时间销销售售收收入入预预算算月月份份1 12 23 34 45 56 67 7销销售售总总收收入入单位:元54250542505383353833511255112549762.149762.1 44986.344986.3 42577.142577.1 51183.451183.4销销量量A 产品单位:件100125130135130136155B 产品单位:件15012010086684868定定价价策策略略价价格格变变动动A 产品-3%-3%B 产品-2%-2%1%1%1%1%单单价价定价A 产
2、品单位:元250.00242.5242.5242.5242.5242.5242.5242.5B 产品单位:元200.00200196196197.96197.96199.9396 199.9396销销售售收收入入A 产品单位:元24250.030312.531525.032737.531525.032980.037587.5B 产品单位:元30000.023520.019600.017024.613461.39597.113595.9销销售售收收入入合合计计54250.053832.551125.049762.144986.342577.151183.4收收入入结结构构当月销售/年销售收入()
3、8.2%8.1%7.7%7.5%6.8%6.4%7.7%2012/11/18 89 9101011111212合合计计6852068520654276542764880648806133461334 54301.754301.7 662177.76662177.76200180170160134175588981081009811325%5%3%3%254.625254.625 254.625254.625254.625199.9396199.94199.94205.938 205.937850925.045832.5 43286.340740.034119.8435821.017594.71
4、9594.1 21593.520593.820181.9226356.868519.765426.6 64879.761333.854301.7662177.810.3%9.9%9.8%9.3%8.2%100.0%100.0%20132013年年销销售售收收入入预预算算表表价价格格变变动动20132013年年材材料料预预算算表表公司名称华云信息有限公司预算年度2013年制表时间材材料料预预算算月月份份1 12 23 34 45 56 6合计物料标准成本14250.014250.0 23028.023028.023366.823366.824640.324640.324035.124035.12
5、3520.023520.0标准物料成本#23028.00 23366.75 24640.26 24035.13 23520.05销售收入比例26%43%46%50%53%55%物料成本差异(人工输入)0-8341388.58000占合计物料标准成本比例0%-4%6%0%0%0%共计物料成本#22194.00 24755.33 24640.26 24035.13 23520.05占销售收入比例26%41%48%50%53%55%物物料料成成本本变变动动国内物料成本1%1%3%3%-1%-1%单单位位物物料料成成本本A产品75.0075.7575.7578.0278.0277.2477.24B产品
6、45.0045.4545.4546.8146.8146.3546.35共共计计物物料料成成本本A产品7500.017574.018821.820614.320851.821295.5B产品6750.05454.04545.04026.03183.32224.6合计14250.023028.023366.824640.324035.123520.02012/11/17 78 89 9101011111212全全年年合合计计29031.429031.433721.833721.837666.337666.338129.638129.637759.037759.037666.337666.33468
7、14.5346814.529031.40 33721.7537666.3238129.5837758.9737666.32346814.5357%49%58%59%62%69%52%1321.540-1023.52000852.65%0%-3%0%0%0%0%30352.94 33721.7536642.8038129.5837758.9737666.32347667.1359%49%56%59%62%69%53%-2%-2%2%2%75.7077.2177.2177.2177.2177.2145.4246.3346.3346.3346.3346.3325879.929724.933126.333126.333126.333126.33151.53996.84540.05003.34632.74540.029031.433721.837666.338129.637759.037666.320132013年年材材料料预预算算表表