114財務(wù)指標(biāo)預(yù)算分析表excel模板

2013年三項費用預(yù)算表,,,,,,,,,,,,,

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

預(yù)算年度,,2013,,,,制表時間,,2012/11/1,,,,,

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

管理費用,"6,594","6,595",6595,6595,6595,6595,6595,6595,6595,6595,6595,6595,"79,139"

營業(yè)費用,2853.5,2816,2816,2816,2816,2816,2816,2816,2816,2816,2816,2816,33829.5

財務(wù)費用,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

三項費用合計:,9665.99,9629.49,9629.49,9628.49,9628.49,9628.49,9679.98,9691.98,9693.98,9693.98,9682.98,9670.98,115924.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

工會經(jīng)費,0,0,0,0,0,0,0,0,0,0,0,0,0

職工教育經(jīng)費,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"

業(yè)務(wù)招待費,"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

資產(chǎn)占用費,,,,,,,,,,,,,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

研究與開發(fā)費,,,,,,,,,,,,,0

存貨盤盈盤虧,,,,,,,,,,,,,0

提取壞帳準(zhǔn)備,20,21,21,21,21,21,21,21,21,21,21,21,251

提取存貨跌價準(zhǔn)備,8,8,8,8,8,8,8,8,8,8,8,8,96

無形資產(chǎn)攤銷,,,,,,,,,,,,,0

中介機(jī)構(gòu)費,,,,,,,,,,,,,0

檢驗費,,,,,,,,,,,,,0

會務(wù)費,,,,,,,,,,,,,0

報損費,,,,,,,,,,,,,0

咨詢費,,,,,,,,,,,,,0

訴訟費,,,,,,,,,,,,,0

殘聯(lián)基金,208,208,208,208,208,208,208,208,208,208,208,208,"2,496"

內(nèi)部培訓(xùn)費,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

管理費用合計,"6,594","6,595","6,595","6,595","6,595","6,595","6,595","6,595","6,595","6,595","6,595","6,595","79,139"

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

營業(yè)費用:,,,,,,,,,,,,,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"

會務(wù)費,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"

產(chǎn)品檢驗費,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"

中介機(jī)構(gòu)費,0,0,0,0,0,0,0,0,0,0,0,0,0

內(nèi)部培訓(xùn)費,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

合計營業(yè)費用,"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

財務(wù)費用:,,,,,,,,,,,,,0

金融手續(xù)費,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

貼現(xiàn)利息,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,94.