最佳容積率測算模板

1、最佳容積率測算模板（此計(jì)算模板僅能計(jì)算4變量。受參數(shù)影響，結(jié)果不一定準(zhǔn)確，但指明了方向，優(yōu)化方案還需經(jīng)過建筑總平面規(guī)劃才能確定）下一行表格中的數(shù)據(jù)全部為待求部分的數(shù)值，如果有固定比例的部分，應(yīng)根據(jù)情況先計(jì)算出下表。業(yè)態(tài)最高容積率2業(yè)態(tài)占地面積181731.16業(yè)態(tài)建筑面積業(yè)態(tài)數(shù)量4序號項(xiàng)目名稱取值業(yè)態(tài)1業(yè)態(tài)2業(yè)態(tài)3業(yè)態(tài)41用地比例(基本方案）12%70%13%0%2參考容積率1.502.002.800.00基本方案綜合容積率1.94基本方案建筑面積353285.383售價(jià)13000.0012000.0011000.0010000.004建造費(fèi)用1800.002160.002520.002760

2、.004.1 建安費(fèi)1500.001800.002100.002300.004.2 紅線內(nèi)市政費(fèi)150.00180.00210.00230.004.3 小區(qū)配套費(fèi)150.00180.00210.00230.005不可預(yù)見費(fèi)75.0090.00105.00115.006專業(yè)人士費(fèi)90.00108.00126.00138.007管理費(fèi)用58.9570.7482.5390.398財(cái)務(wù)費(fèi)用（建設(shè)期2年）286.78344.13401.49439.739銷售費(fèi)用1105.001020.00935.00850.0010土地取得價(jià)格5000.005000.005000.005000.0011土地增值（扣土地

3、費(fèi)用）9376.4111414.2514123.95-5000.0012土地增值（不扣土地費(fèi)用）14376.4116414.2519123.950.00計(jì)算增幅（：1%，：5%，:10%）1注注意意：如如果果是是四四種種業(yè)業(yè)態(tài)態(tài)，選選擇擇增增幅幅為為1 1的的情情況況，會會超超出出了了EXCELEXCEL最最大大行行的的限限制制。系系統(tǒng)統(tǒng)自自動動以以增增幅幅為為2 2計(jì)計(jì)算算。序號比例綜合容積率業(yè)態(tài)1業(yè)態(tài)2業(yè)態(tài)3業(yè)態(tài)4最優(yōu)方案009642.688可能方案1009641.828009821.8140010001.8029261.83029441.816029621.802029801.78804

4、9061.818049241.804049421.79049601.776068681.82068861.806069041.792069221.778069401.7640882101.822088481.808088661.794088841.78089021.766089201.75201078121.82401080101.810108281.7960108461.782計(jì)算最優(yōu)方案0108641.7680108821.7540109001.7401274141.82601276121.81201278101.7980128081.7840128261.770128441.756012

5、8621.7420128801.72801470161.82801472141.81401474121.801476101.7860147881.7720148061.7580148241.7440148421.730148601.71601666181.8301668161.81601670141.80201672121.78801674101.7740167681.760167861.7460168041.7320168221.7180168401.70401864181.81801866161.80401868141.7901870121.77601872101.7620187481.7

6、480187661.7340187841.720188021.7060188201.69202060201.8202062181.80602064161.79202066141.77802068121.76402070101.750207281.7360207461.7220207641.7080207821.6940208001.6802256221.82202258201.80802260181.79402262161.7802264141.76602266121.75202268101.7380227081.7240227261.710227441.6960227621.68202278

7、01.66802452241.82402454221.8102456201.79602458181.78202460161.76802462141.75402464121.7402466101.7260246881.7120247061.6980247241.6840247421.670247601.65602648261.82602650241.81202652221.79802654201.78402656181.7702658161.75602660141.74202662121.72802664101.7140266681.70266861.6860267041.6720267221.

8、65802844281.82802846261.81402848241.802850221.78602852201.77202854181.75802856161.74402858141.7302860121.71602862101.7020286481.6880286661.6740286841.6603040301.8303042281.81603044261.80203046241.78803048221.77403050201.7603052181.74603054161.73203056141.71803058121.70403060101.690306281.67603238301

9、.81803240281.80403242261.7903244241.77603246221.76203248201.74803250181.73403252161.7203254141.70603256121.69203258101.67803434321.8203436301.80603438281.79203440261.77803442241.76403444221.7503446201.73603448181.72203450161.70803452141.69403454121.6803630341.82203632321.80803634301.79403636281.7803

10、638261.76603640241.75203642221.73803644201.72403646181.7103648161.69603826361.82403828341.8103830321.79603832301.78203834281.76803836261.75403838241.7403840221.72603842201.71203844181.69804022381.82604024361.81204026341.79804028321.78404030301.7704032281.75604034261.74204036241.72804038221.714042184

11、01.82804220381.81404222361.804224341.78604226321.77204228301.75804230281.74404232261.7304234241.71604414421.8304416401.81604418381.80204420361.78804422341.77404424321.7604426301.74604428281.73204612421.81804614401.80404616381.7904618361.77604620341.76204622321.74804624301.7340488441.8204810421.80604

12、812401.79204814381.77804816361.76404818341.7504820321.7360504461.8220506441.8080508421.79405010401.7805012381.76605014361.7520520481.8240522461.810524441.7960526421.7820528401.76805210381.7540540461.7980542441.7840544421.770560441.772209261.818209441.804209621.79209801.776228881.82229061.806229241.7

13、92229421.778229601.7642484101.822248681.808248861.794249041.78249221.766249401.7522680121.8242682101.81268481.796268661.782268841.768269021.754269201.742876141.8262878121.8122880101.798288281.784288461.77288641.756288821.742289001.72821072161.82821074141.81421076121.821078101.7862108081.7722108261.7

14、582108441.7442108621.732108801.71621268181.8321270161.81621272141.80221274121.78821276101.7742127881.762128061.7462128241.7322128421.7182128601.70421466181.81821468161.80421470141.7921472121.77621474101.7622147681.7482147861.7342148041.722148221.7062148401.69221662201.8221664181.80621666161.79221668

15、141.77821670121.76421672101.752167481.7362167661.7222167841.7082168021.6942168201.6821858221.82221860201.80821862181.79421864161.7821866141.76621868121.75221870101.7382187281.7242187461.712187641.6962187821.6822188001.66822054241.82422056221.8122058201.79622060181.78222062161.76822064141.75422066121

16、.7422068101.7262207081.7122207261.6982207441.6842207621.672207801.65622250261.82622252241.81222254221.79822256201.78422258181.7722260161.75622262141.74222264121.72822266101.7142226881.72227061.6862227241.67222446281.82822448261.81422450241.822452221.78622454201.77222456181.75822458161.74422460141.73

17、22462121.71622464101.7022246681.6882246861.67422642301.8322644281.81622646261.80222648241.78822650221.77422652201.7622654181.74622656161.73222658141.71822660121.70422662101.6922840301.81822842281.80422844261.7922846241.77622848221.76222850201.74822852181.73422854161.7222856141.70622858121.6922303632

18、1.8223038301.80623040281.79223042261.77823044241.76423046221.7523048201.73623050181.72223052161.70823054141.69423232341.82223234321.80823236301.79423238281.7823240261.76623242241.75223244221.73823246201.72423248181.7123428361.82423430341.8123432321.79623434301.78223436281.76823438261.75423440241.742

19、3442221.72623444201.71223624381.82623626361.81223628341.79823630321.78423632301.7723634281.75623636261.74223638241.72823820401.82823822381.81423824361.823826341.78623828321.77223830301.75823832281.74423834261.7324016421.8324018401.81624020381.80224022361.78824024341.77424026321.7624028301.7462421442

20、1.81824216401.80424218381.7924220361.77624222341.76224224321.74824410441.8224412421.80624414401.79224416381.77824418361.76424420341.752466461.8222468441.80824610421.79424612401.7824614381.7662482481.8242484461.812486441.7962488421.78224810401.7682500481.8122502461.7982504441.7842520461.7864086101.82

21、2408881.808409061.794409241.78409421.766409601.7524282121.8244284101.81428681.796428861.782429041.768429221.754429401.744478141.8264480121.8124482101.798448481.784448661.77448841.756449021.742449201.7284674161.8284676141.8144678121.84680101.786468281.772468461.758468641.744468821.73469001.7164870181

22、.834872161.8164874141.8024876121.7884878101.774488081.76488261.746488441.732488621.718488801.70441068181.81841070161.80441072141.7941074121.77641076101.7624107881.7484108061.7344108241.724108421.7064108601.69241264201.8241266181.80641268161.79241270141.77841272121.76441274101.754127681.7364127861.72

23、24128041.7084128221.6944128401.6841460221.82241462201.80841464181.79441466161.7841468141.76641470121.75241472101.7384147481.7244147661.714147841.6964148021.6824148201.66841656241.82441658221.8141660201.79641662181.78241664161.76841666141.75441668121.7441670101.7264167281.7124167461.6984167641.684416

24、7821.6741852261.82641854241.81241856221.79841858201.78441860181.7741862161.75641864141.74241866121.72841868101.7144187081.74187261.68642048281.82842050261.81442052241.842054221.78642056201.77242058181.75842060161.74442062141.7342064121.71642066101.7024206881.68842244301.8342246281.81642248261.802422

25、50241.78842252221.77442254201.7642256181.74642258161.73242260141.71842262121.70442442301.81842444281.80442446261.7942448241.77642450221.76242452201.74842454181.73442456161.7242458141.70642638321.8242640301.80642642281.79242644261.77842646241.76442648221.7542650201.73642652181.72242654161.70842834341

26、.82242836321.80842838301.79442840281.7842842261.76642844241.75242846221.73842848201.72443030361.82443032341.8143034321.79643036301.78243038281.76843040261.75443042241.7443044221.72643226381.82643228361.81243230341.79843232321.78443234301.7743236281.75643238261.74243422401.82843424381.81443426361.843

27、428341.78643430321.77243432301.75843434281.74443618421.8343620401.81643622381.80243624361.78843626341.77443628321.7643630301.74643816421.81843818401.80443820381.7943822361.77643824341.76244012441.8244014421.80644016401.79244018381.77844020361.7644428461.82244210441.80844212421.79444214401.784444481.

28、8244446461.814448441.79644410421.7824460501.8264462481.8124464461.7984480481.86080141.8266082121.8126084101.798608681.784608861.77609041.756609221.742609401.7286276161.8286278141.8146280121.86282101.786628481.772628661.758628841.744629021.73629201.7166472181.836474161.8166476141.8026478121.788648010

29、1.774648281.76648461.746648641.732648821.718649001.7046670181.8186672161.8046674141.796676121.7766678101.762668081.748668261.734668441.72668621.706668801.6926866201.826868181.8066870161.7926872141.7786874121.7646876101.75687881.736688061.722688241.708688421.694688601.6861062221.82261064201.808610661

30、81.79461068161.7861070141.76661072121.75261074101.7386107681.7246107861.716108041.6966108221.68261258241.82461260221.8161262201.79661264181.78261266161.76861268141.75461270121.7461272101.7266127481.7126127661.6986127841.68461454261.82661456241.81261458221.79861460201.78461462181.7761464161.756614661

31、41.74261468121.72861470101.7146147281.761650281.82861652261.81461654241.861656221.78661658201.77261660181.75861662161.74461664141.7361666121.71661668101.70261846301.8361848281.81661850261.80261852241.78861854221.77461856201.7661858181.74661860161.73261862141.71861864121.70462044301.81862046281.80462

32、048261.7962050241.77662052221.76262054201.74862056181.73462058161.7262240321.8262242301.80662244281.79262246261.77862248241.76462250221.7562252201.73662254181.72262436341.82262438321.80862440301.79462442281.7862444261.76662446241.75262448221.73862632361.82462634341.8162636321.79662638301.78262640281

33、.76862642261.75462644241.7462828381.82662830361.81262832341.79862834321.78462836301.7762838281.75663024401.82863026381.81463028361.863030341.78663032321.77263034301.75863220421.8363222401.81663224381.80263226361.78863228341.77463230321.7663418421.81863420401.80463422381.7963424361.77663614441.826361

34、6421.80663618401.79263620381.77863810461.82263812441.80863814421.7946406481.8246408461.8164010441.7966422501.8266424481.8126440501.8148074181.838076161.8168078141.8028080121.7888082101.774808481.76808661.746808841.732809021.718809201.7048272181.8188274161.8048276141.798278121.7768280101.762828281.74

35、8828461.734828641.72828821.706829001.6928468201.828470181.8068472161.7928474141.7788476121.7648478101.75848081.736848261.722848441.708848621.694848801.688664221.8228666201.8088668181.7948670161.788672141.7668674121.7528676101.738867881.724868061.71868241.6968860241.8248862221.818864201.7968866181.78

36、28868161.7688870141.7548872121.748874101.726887681.712887861.69881056261.82681058241.81281060221.79881062201.78481064181.7781066161.75681068141.74281070121.72881072101.71481252281.82881254261.81481256241.881258221.78681260201.77281262181.75881264161.74481266141.7381268121.71681448301.8381450281.8168

37、1452261.80281454241.78881456221.77481458201.7681460181.74681462161.73281464141.71881646301.81881648281.80481650261.7981652241.77681654221.76281656201.74881658181.73481842321.8281844301.80681846281.79281848261.77881850241.76481852221.7581854201.73682038341.82282040321.80882042301.79482044281.78820462

38、61.76682048241.75282234361.82482236341.8182238321.79682240301.78282242281.76882244261.75482430381.82682432361.81282434341.79882436321.78482438301.7782626401.82882628381.81482630361.882632341.78682634321.77282822421.8382824401.81682826381.80282828361.78882830341.77483020421.81883022401.80483024381.79

39、83216441.8283218421.80683220401.79283412461.82283414441.8088368481.82483610461.818384501.8268386481.8128400521.82810070201.8210072181.80610074161.79210076141.77810078121.76410080101.751008281.7361008461.7221008641.7081008821.69410266221.82210268201.80810270181.79410272161.7810274141.76610276121.7521

40、0278101.7381028081.7241028261.7110462241.82410464221.8110466201.79610468181.78210470161.76810472141.75410474121.7410476101.7261047881.71210658261.82610660241.81210662221.79810664201.78410666181.7710668161.75610670141.74210672121.72810854281.82810856261.81410858241.810860221.78610862201.77210864181.7

41、5810866161.74410868141.73101050301.83101052281.816101054261.802101056241.788101058221.774101060201.76101062181.746101064161.732101248301.818101250281.804101252261.79101254241.776101256221.762101258201.748101444321.82101446301.806101448281.792101450261.778101452241.764101454221.75101640341.8221016423

42、21.808101644301.794101646281.78101648261.766101836361.824101838341.81101840321.796101842301.782101844281.768102032381.826102034361.812102036341.798102038321.784102040301.77102228401.828102230381.814102232361.8102234341.786102424421.83102426401.816102428381.802102430361.788102622421.818102624401.8041

43、02818441.82102820421.806103014461.822103210481.82410346501.82612064241.82412066221.8112068201.79612070181.78212072161.76812074141.75412076121.7412078101.72612260261.82612262241.81212264221.79812266201.78412268181.7712270161.75612272141.74212456281.82812458261.81412460241.812462221.78612464201.772124

44、66181.75812468161.74412652301.8312654281.81612656261.80212658241.78812660221.77412662201.7612664181.74612850301.81812852281.80412854261.7912856241.77612858221.762121046321.82121048301.806121050281.792121052261.778121054241.764121242341.822121244321.808121246301.794121248281.78121438361.824121440341.

45、81121442321.796121444301.782121634381.826121636361.812121638341.798121640321.784121830401.828121832381.814121834361.8122026421.83122028401.816122030381.802122224421.818122420441.8214058281.82814060261.81414062241.814064221.78614066201.77214068181.75814254301.8314256281.81614258261.80214260241.788142

46、62221.77414264201.7614452301.81814454281.80414456261.7914458241.77614648321.8214650301.80614652281.79214654261.77814844341.82214846321.80814848301.794141040361.824141042341.81141044321.796141236381.826141238361.812141240341.798141432401.828141434381.814141628421.83141630401.81616054301.81816056281.8

47、0416058261.7916250321.8216252301.80616254281.79216446341.82216448321.80816642361.82416644341.8116838381.82616840361.812161034401.828161230421.8318048341.82218050321.80818244361.82418440381.826456154.22備注含土建、安裝和部分裝修建安費(fèi)用的810%建安費(fèi)用的810%建安費(fèi)用的510%建造費(fèi)用的510%建造費(fèi)用、不可預(yù)見費(fèi)專業(yè)人士費(fèi)的35%綜合建安成本（上四項(xiàng)之和）*（1+貸款利率）計(jì)息期1）兩銳一費(fèi)

48、5.5%，銷售費(fèi)用23%按占地面積按占地面積按占地面積綜合建筑規(guī)模（萬平方米）土地增值額(萬元）48.85625846.466155.38625846.466154.19622916.958153.00619987.45155.55624618.76154.36621689.252153.17618759.744151.98615830.236154.53620461.546153.34617532.038152.15614602.53150.96611673.022154.70619233.84153.51616304.332152.32613374.824151.13610445.3161

49、49.94607515.808154.87618006.134153.68615076.626152.49612147.118151.30609217.61150.11606288.102148.92603358.594155.04616778.428153.85613848.92152.66610919.412151.47607989.904最佳容積率測算模板（此計(jì)算模板僅能計(jì)算4變量。受參數(shù)影響，結(jié)果不一定準(zhǔn)確，但指明了方向，優(yōu)化方案還需經(jīng)過建筑總平面規(guī)劃才能確定）下一行表格中的數(shù)據(jù)全部為待求部分的數(shù)值，如果有固定比例的部分，應(yīng)根據(jù)情況先計(jì)算出下表。注注意意：如如果果是是四四種種業(yè)業(yè)態(tài)態(tài)，

50、選選擇擇增增幅幅為為1 1的的情情況況，會會超超出出了了EXCELEXCEL最最大大行行的的限限制制。系系統(tǒng)統(tǒng)自自動動以以增增幅幅為為2 2計(jì)計(jì)算算。150.28605060.396149.09602130.888147.90599201.38155.21615550.722154.02612621.214152.83609691.706151.64606762.198150.45603832.69149.26600903.182148.07597973.674146.88595044.166155.38614323.016154.19611393.508153.00608464151.816

51、05534.492150.62602604.984149.43599675.476148.24596745.968147.05593816.46145.86590886.952155.55613095.31154.36610165.802153.17607236.294151.98604306.786150.79601377.278149.60598447.77148.41595518.262147.22592588.754146.03589659.246144.84586729.738154.53608938.096153.34606008.588152.15603079.08150.966

52、00149.572149.77597220.064148.58594290.556147.39591361.048146.20588431.54145.01585502.032143.82582572.524154.70607710.39153.51604780.882152.32601851.374151.13598921.866149.94595992.358148.75593062.85147.56590133.342146.37587203.834145.18584274.326143.99581344.818142.8578415.31154.87606482.684153.6860

53、3553.176152.49600623.668151.30597694.16150.11594764.652148.92591835.144147.73588905.636146.54585976.128145.35583046.62144.16580117.112142.97577187.604141.78574258.096155.04605254.978153.85602325.47152.66599395.962151.47596466.454150.28593536.946149.09590607.438147.90587677.93146.71584748.422145.5258

54、1818.914144.33578889.406143.14575959.898141.95573030.39140.76570100.882155.21604027.272154.02601097.764152.83598168.256151.64595238.748150.45592309.24149.26589379.732148.07586450.224146.88583520.716145.69580591.208144.50577661.7143.31574732.192142.12571802.684140.93568873.176155.38602799.566154.1959

55、9870.058153.00596940.55151.81594011.042150.62591081.534149.43588152.026148.24585222.518147.05582293.01145.86579363.502144.67576433.994143.48573504.486142.29570574.978141.1567645.47155.55601571.86154.36598642.352153.17595712.844151.98592783.336150.79589853.828149.60586924.32148.41583994.812147.225810

56、65.304146.03578135.796144.84575206.288143.65572276.78142.46569347.272154.53597414.646153.34594485.138152.15591555.63150.96588626.122149.77585696.614148.58582767.106147.39579837.598146.20576908.09145.01573978.582143.82571049.074142.63568119.566154.70596186.94153.51593257.432152.32590327.924151.135873

57、98.416149.94584468.908148.75581539.4147.56578609.892146.37575680.384145.18572750.876143.99569821.368142.80566891.86154.87594959.234153.68592029.726152.49589100.218151.30586170.71150.11583241.202148.92580311.694147.73577382.186146.54574452.678145.35571523.17144.16568593.662155.04593731.528153.8559080

58、2.02152.66587872.512151.47584943.004150.28582013.496149.09579083.988147.90576154.48146.71573224.972145.52570295.464144.33567365.956155.21592503.822154.02589574.314152.83586644.806151.64583715.298150.45580785.79149.26577856.282148.07574926.774146.88571997.266145.69569067.758155.38591276.116154.195883

59、46.608153.00585417.1151.81582487.592150.62579558.084149.43576628.576148.24573699.068147.05570769.56145.86567840.052155.55590048.41154.36587118.902153.17584189.394151.98581259.886150.79578330.378149.60575400.87148.41572471.362147.22569541.854154.53585891.196153.34582961.688152.15580032.18150.96577102

60、.672149.77574173.164148.58571243.656147.39568314.148154.70584663.49153.51581733.982152.32578804.474151.13575874.966149.94572945.458148.75570015.95147.56567086.442154.87583435.784153.68580506.276152.49577576.768151.30574647.26150.11571717.752148.92568788.244155.04582208.078153.85579278.57152.66576349