115三项费用预算及分析财务报表excel图表模板

2013年三项费用预算表,,,,,,,,,,,,,

公司名称,xxxx信息有限公司,,,,,,,,,,,,

预算年度,,2013,,,,制表时间,,2012/11/1,,,,,

月份:,1,2,3,4,5,6,7,8,9,10,11,12,合计

管理费用,"21,160","21,261",21271,22262,22315,22315,22315,22315,22315,23320,23320,23320,267489

营业费用,2853.5,2816,2816,2816,2816,2816,2816,2816,2816,2816,2816,2816,33829.5

财务费用,218.49,218.49,218.49,217.49,217.49,217.49,268.98,280.98,282.98,282.98,271.98,259.98,2955.82

三项费用合计:,24231.99,24295.49,24305.49,25295.49,25348.49,25348.49,25399.98,25411.98,25413.98,26418.98,26407.98,26395.98,304274.32

管理费用:,,,,,,,,,,,,,

工资,14566,14666,14676,15667,15720,15720,15720,15720,15720,16725,16725,16725,"188,350"

职工福利基金,80,80,80,80,80,80,80,80,80,80,80,80,960

工会经费,0,0,0,0,0,0,0,0,0,0,0,0,0

职工教育经费,524,524,524,524,524,524,524,524,524,524,524,524,"6,288"

社会保险基金,850,850,850,850,850,850,850,850,850,850,850,850,"10,200"

保险费,200,200,200,200,200,200,200,200,200,200,200,200,"2,400"

业务招待费,"2,500","2,500","2,500","2,500","2,500","2,500","2,500","2,500","2,500","2,500","2,500","2,500","30,000"

差旅费,"1,500","1,500","1,500","1,500","1,500","1,500","1,500","1,500","1,500","1,500","1,500","1,500","18,000"

办公费,300,300,300,300,300,300,300,300,300,300,300,300,"3,600"

通讯费,,,,,,,,,,,,,0

小车费,,,,,,,,,,,,,0

税金,,,,,,,,,,,,,0

租赁费,,,,,,,,,,,,,0

资产占用费,,,,,,,,,,,,,0

修理费,,,,,,,,,,,,,0

低值易耗品摊销,80,80,80,80,80,80,80,80,80,80,80,80,960

折旧费,75,75,75,75,75,75,75,75,75,75,75,75,900

排污费,,,,,,,,,,,,,0

董事会会费,,,,,,,,,,,,,0

研究与开发费,,,,,,,,,,,,,0

存货盘盈盘亏,,,,,,,,,,,,,0

提取坏帐准备,20,21,21,21,21,21,21,21,21,21,21,21,251

提取存货跌价准备,8,8,8,8,8,8,8,8,8,8,8,8,96

无形资产摊销,,,,,,,,,,,,,0

中介机构费,,,,,,,,,,,,,0

检验费,,,,,,,,,,,,,0

会务费,,,,,,,,,,,,,0

报损费,,,,,,,,,,,,,0

咨询费,,,,,,,,,,,,,0

诉讼费,,,,,,,,,,,,,0

残联基金,208,208,208,208,208,208,208,208,208,208,208,208,"2,496"

内部培训费,208,208,208,208,208,208,208,208,208,208,208,208,"2,496"

招聘费,0,0,0,0,0,0,0,0,0,0,0,0,0

上交管理费,0,0,0,0,0,0,0,0,0,0,0,0,0

收取管理费,41,41,41,41,41,41,41,41,41,41,41,41,492

其他,0,0,0,0,0,0,0,0,0,0,0,0,0

管理费用合计,"21,160","21,261","21,271","22,262","22,315","22,315","22,315","22,315","22,315","23,320","23,320","23,320","267,489"

,,,,,,,,,,,,,0

营业费用:,,,,,,,,,,,,,0

通讯费,180,180,180,180,180,180,180,180,180,180,180,180,"2,160"

运输费,360,360,360,360,360,360,360,360,360,360,360,360,"4,320"

会务费,500,500,500,500,500,500,500,500,500,500,500,500,"6,000"

租赁费,0,0,0,0,0,0,0,0,0,0,0,0,0

折旧费,87.50,50,50,50,50,50,50,50,50,50,50,50,638

存货毁损,85,85,85,85,85,85,85,85,85,85,85,85,"1,020"

产品检验费,41,41,41,41,41,41,41,41,41,41,41,41,492

运费,640,640,640,640,640,640,640,640,640,640,640,640,"7,680"

返利,0,0,0,0,0,0,0,0,0,0,0,0,0

广告费,800,800,800,800,800,800,800,800,800,800,800,800,"9,600"

促销费,160,160,160,160,160,160,160,160,160,160,160,160,"1,920"

中介机构费,0,0,0,0,0,0,0,0,0,0,0,0,0

内部培训费,0,0,0,0,0,0,0,0,0,0,0,0,0

招聘费,0,0,0,0,0,0,0,0,0,0,0,0,0

其他,0,0,0,0,0,0,0,0,0,0,0,0,0

合计营业费用,"2,854","2,816","2,816","2,816","2,816","2,816","2,816","2,816","2,816","2,816","2,816","2,816","33,830"

,,,,,,,,,,,,,0

财务费用:,,,,,,,,,,,,,0

金融手续费,80,80,80,80,80,80,80,80,80,80,80,80,960

汇兑损益,0,0,0,0,0,0,0,0,0,0,0,0,0

贴现利息,0,0,0,0,0,0,0,0,0,0,0,0,0

折扣与折让,0,0,0,0,0,0,0,0,0,0,0,0,0

利息支出-USD,48.99,48.99,48.99,48.99,48.99,48.99,97.98,97.98,97.98,97.98,97.98,97.98,882

利息支出-RMB,94.50,94.50,94.50,94.50,9