自动计算表格.xls

《自动计算表格.xls》由会员分享，可在线阅读，更多相关《自动计算表格.xls（6页珍藏版）》请在得力文库 - 分享文档赚钱的网站上搜索。

1、*项目费用分析表总建筑面积302968.52占地面积185659.2住宅面积245928.52 商业面积57040销售收入646238484646238484利润编码工程项目（费用）名称计量单位工程量单价或费率1.一一、征征地地、拆拆迁迁补补偿偿费费001-1-1征地费（拍卖价）亩278.495500001-1-2土地出让金亩278.4902.二二、斟斟察察设设计计和和前前期期费费002-1-1地形图测绘费平方米185659.23510.142-1-2总体规划设计费（定点费）平方米185659.235122-2-1地质勘察费点3007002-2-2建筑设计费平方米302968.52102-3-

2、1城市建设配套费平方米302968.521002-11-1 招标费元、285748363.8012-13-1 监理费元、285748363.8022-14-1 预结算审计费元、285748363.8032-15-1 消防配套费平方米302968.5232-16-1 施工合同鉴证费元、285748363.8012-17-1 噪音费月10016002-19-1 避雷安装检测费支500552-22-1 人防费平方米302968.52342-26-2 墙改费平方米302968.5272-17-0 文物钻探费平方米69135.39111102-17-2 垃圾处理费立方米10000062-28-1 散装水

3、泥专项基金平方米302968.521.052-27-1 建筑方案评审费平方米302968.520.23.三三、建建筑筑安安装装工工程程费费003-1-3土建工程平方米302968.525503-1-4外墙保温工程平方米302968.52303-2-1室内水电、线路安装工程平方米302968.52354.四四、配配套套建建设设费费004-1-1道路工程平方米600001004-1-2室外排污排水工程米65002004-1-3室外供水工程米50005004-1-4供暖工程平方米302968.52554-2-1围墙工程项1500004-3-1室外供电安装工程项302968.52224-4-1绿化工程

4、平方米6600504-5-1路灯安装工程盏600200ZJF直直接接费费005.五五、管管理理费费005-1-1建设管理费（5%）元、%523667308.9155-2-1销售管理费元、%64623848416.六六、税税费费006-2-1营业税及附加（10%）元、%646238484106-5-1建筑面积测量费平方米302968.522.56-4-3房屋竣工总登记费元、51504648417.七七、利利息息007-1-1利息（按年利率均衡投入）元、%523667308.9198.八八、不不可可预预见见费费008-1-1不可预见费（按直接费计）元、%523667308.915JJF间间接接费费

5、00ZZJ总总成成本本00基底面积69135.39 住宅均价1700公建面积0.00商业均价4000-49284314.62-49284314.62造价或费用(元)楼面造价(元/M2)百分比(%)计算公式或说明153168103.12505.5622.02%153168103.12505.5622.02%55万元/亩0.000.000.00%万元/亩51122265.95168.747.35%25992.290.090.00%按土地面积0.14元/平方米371318.471.230.05%土地面积2元/平方米210000.000.690.03%按经验值钻点700元/个3029685.2010.

6、000.44%按10元/平米（建筑面积）30296852.00100.004.36%各地区根据实际情况确定285748.360.940.04%按土建工程造价的1计算571496.731.890.08%按土建工程造价的2计算857245.092.830.12%按土建工程造价的3计算908905.563.000.13%按3元/平方米计算285748.360.940.04%按土建工程造价的1计算160000.000.530.02%1600元/月.幢 估算27500.000.090.00%检测避雷针55元/支10300929.6834.001.48%新价防字（2003）37号2120779.647.0

7、00.30%7元/平方米691353.912.280.10%按基底面积600000.001.980.09%按处理量计算318116.951.050.05%综合砖混0.8元和框架1.2元60593.700.200.01%0.2元/平方米285748363.80943.1641.08%266055410.00878.1638.25%多层按550，高层按11509089055.6030.001.31%按新乡地区估算10603898.2035.001.52%按概算造价33628576.04111.004.84%6000000.0019.800.86%按概算造价1300000.004.290.19%按概

8、算造价2500000.008.250.36%按概算造价16663268.6055.002.40%按新乡地区估算，仅含室外部分50000.000.170.01%按概算造价6665307.4422.000.96%按概算造价330000.001.090.05%按概算造价120000.000.400.02%按概算造价*项目费用分析表523667308.911728.4575.29%1.+2.+3.+4.共4项的和32645750.29107.754.69%26183365.4586.423.76%直接费的5%6462384.8421.330.93%按1600元/平方均价估算65896316.18217

9、.509.47%64623848.40213.309.29%按出售房屋总价款的10%757421.302.500.11%按住宅1.36商业3.6元折合515046.481.700.07%按评估价的147130057.80155.566.78%47130057.80155.566.78%按直接费，年利5.85%26183365.4586.423.76%26183365.4586.423.76%171855489.72567.2424.71%5.+6.+7.+8.共4项的和695522798.622295.69100.00%2295.692295.692295.692295.692295.6922

10、95.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.692295.69