最佳容積率測(cè)算模板

1、最佳容積率測(cè)算模板（此計(jì)算模板僅能計(jì)算4變量。受參數(shù)影響，結(jié)果不一定準(zhǔn)確，但指明了方向，優(yōu)化方案還需經(jīng)過(guò)建筑總平面規(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序號(hào)項(xiàng)目名稱(chē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 紅線(xiàn)內(nèi)市政費(fèi)150.00180.00210.00230.004.3 小區(qū)配套費(fèi)150.00180.00210.00230.005不可預(yù)見(jiàn)費(fèi)75.0090.00105.00115.006專(zhuān)業(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銷(xiāo)售費(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的的情情況況，會(huì)會(huì)超超出出了了EXCELEXCEL最最大大行行的的限限制制。系系統(tǒng)統(tǒng)自自動(dòng)動(dòng)以以增增幅幅為為2 2計(jì)計(jì)算算。序號(hào)比例綜合容積率業(yè)態(tài)1業(yè)態(tài)2業(yè)態(tài)3業(yè)態(tài)4最優(yōu)方案0100002可能方案10861042088841.984094421.992096221.976098021.9601000022841041.99290621.998

4、292421.982294221.966296021.95298001.994801241.996488621.988490421.972492221.956494021.94494201.996496001.986781241.986684821.994686621.978688421.962690221.946692021.93692201.986計(jì)算最優(yōu)方案694001.978741441.9928801022882821.984884621.968886421.952888221.936888401.992890201.976892001.9610701641.99810781021.

5、991080821.9741082621.9581084421.9421084601.9981086401.9821088201.9661090001.9512741221.99612761021.981278821.9641280621.9481282601.9881284401.9721286201.9561288001.9414641841.99414721221.98614741021.971476821.9541478621.9381478801.9941480601.9781482401.9621484201.9461486001.931660204216681421.992167

6、01221.97616721021.961674821.944167410021676801.9841678601.9681680401.9521682201.9361684001.9218641621.99818661421.98218681221.96618701021.9518721001.991874801.9741876601.9581878401.9421880201.9261882001.9120621621.98820641421.97220661221.95620681201.99620701001.982072801.9642074601.9482076401.932207

7、8201.9162080001.922581821.99422601621.97822621421.96222641221.94622661201.98622681001.972270801.9542272601.9382274401.9222276201.9062278001.892454202224561821.98424581621.96824601421.95224621401.99224641201.97624661001.962468801.9442470601.9282472401.9122474201.89626522021.9926541821.97426561621.958

8、26581601.99826601401.98226621201.96626641001.952666801.9342668601.9182670401.90228482221.99628502021.9828521821.96428561601.98828581401.97228601201.95628621001.942864801.9242866601.9082868401.89230462221.98630482021.9730501821.95430521801.99430541601.97830561401.96230581201.94630601001.933062801.914

9、3064601.89832422421.99232442221.97632462021.963248200232501801.98432521601.96832541401.95232561201.93632581001.923260801.90434382621.99834402421.98234422221.96634462001.9934481801.97434501601.95834521401.94234541201.92634561001.9136362621.98836382421.97236422201.99636442001.9836461801.96436481601.94

10、836501401.93236521201.91636541001.938322821.99438342621.97838362421.96238402201.98638422001.9738441801.95438461601.93838481401.92238501201.9064028302240302821.98440322621.96840362401.99240382201.97640402001.9640421801.94440441601.92840461401.91242263021.9942282821.97442322601.99842342401.98242362201

11、.96642382001.9542401801.93442421601.91844223221.99644243021.9844302601.98844322401.97244342201.95644362001.9444381801.92446203221.98646223021.9746262801.99446282601.97846302401.96246322201.94646342001.9346361801.91448163421.99248183221.9764822300248242801.98448262601.96848282401.95248302201.93648322

12、001.9250123621.99850143421.98250203001.9950222801.97450242601.95850262401.94250282201.92652103621.98852163201.99652183001.9852202801.96452222601.94852242401.9325463821.9945483621.97854143201.98654163001.9754182801.95454202601.93854222401.92256240225643821.98456103401.99256123201.97656143001.96561628

13、01.94456182601.9285804021.995863601.9985883401.98258103201.96658123001.9558142801.9346043601.9886063401.9726083201.95660103001.946203801.9946223601.9786243401.9626263201.9466283001.936403601.9686423401.9526443201.9366603401.942456154.22備注含土建、安裝和部分裝修建安費(fèi)用的810%建安費(fèi)用的810%建安費(fèi)用的510%建造費(fèi)用的510%建造費(fèi)用、不可預(yù)見(jiàn)費(fèi)專(zhuān)業(yè)人士費(fèi)

14、的35%綜合建安成本（上四項(xiàng)之和）*（1+貸款利率）計(jì)息期1）兩銳一費(fèi)5.5%，銷(xiāo)售費(fèi)用23%按占地面積按占地面積按占地面積綜合建筑規(guī)模（萬(wàn)平方米）土地增值額(萬(wàn)元）36.35207432.489336.35200424.935836.06199440.061936.20203436.275635.91202451.401835.62201466.527936.35207432.489336.16199684.257736.31203680.471436.02202695.597635.73201710.723735.44200725.849936.16206691.811236.273539

15、54199928.453536.13202939.793435.84201954.919535.55200970.045735.26199985.171836.27206936.00735.98205951.133236.09199187.775536.24203183.989135.95202199.115335.66201214.241535.36200229.367635.07199244.493836.09206195.329最佳容積率測(cè)算模板（此計(jì)算模板僅能計(jì)算4變量。受參數(shù)影響，結(jié)果不一定準(zhǔn)確，但指明了方向，優(yōu)化方案還需經(jīng)過(guò)建筑總平面規(guī)劃才能確定）下一行表格中的數(shù)據(jù)全部為待求部分的

16、數(shù)值，如果有固定比例的部分，應(yīng)根據(jù)情況先計(jì)算出下表。注注意意：如如果果是是四四種種業(yè)業(yè)態(tài)態(tài)，選選擇擇增增幅幅為為1 1的的情情況況，會(huì)會(huì)超超出出了了EXCELEXCEL最最大大行行的的限限制制。系系統(tǒng)統(tǒng)自自動(dòng)動(dòng)以以增增幅幅為為2 2計(jì)計(jì)算算。35.80205210.455136.20199431.971336.35203428.184936.06202443.311135.76201458.437235.47200473.563435.18199488.689536.20206439.524835.91205454.650935.62204469.777136.31199676.16736.1

17、6202687.506935.87201702.63335.58200717.759235.29199732.885336.31206683.720636.02205698.846735.73204713.972935.44203729.09936.27202931.702735.98201946.828835.69200961.95535.40199977.081136.13205943.042535.84204958.168735.55203973.294835.26202988.42136.24199179.684836.09202191.024635.80201206.150835.5

18、1200221.276935.22199236.403136.24206187.238335.95205202.364535.66204217.490635.36203232.616835.07411388202247.742936.35199423.880636.20202435.220435.91201450.346635.62200465.472735.33199480.598936.35206431.434136.06205446.560335.76204461.686435.47203476.812635.18202491.938734.89201507.064936.3120267

19、9.416236.02201694.542435.72834606200709.668535.4375762199724.794736.16205690.756135.87204705.882235.58203721.008435.29202736.134535.00201751.260734.71200766.386836.13201938.738235.83738475200953.864335.5466149199968.990536.27205934.951935.98204950.07835.69203965.204235.40202980.330335.11201995.45653

20、4.82201010.582634.53200025.708836.24202182.93435.95201198.060135.66200213.186335.36199228.312436.09205194.273835.80204209.399935.51203224.526135.22202239.652334.93201254.778434.64200269.904634.35199285.030736.35202427.129836.05546214201442.255935.76200457.382135.47199472.508236.20205438.469635.91204

21、453.595735.62203468.721935.33202483.84835.04201498.974234.75200514.100334.46199529.226536.16201686.451735.87200701.577835.58199716.70436.31205682.665436.02204697.791535.73203712.917735.44202728.043835.15201743.1734.86200758.296134.57199773.422336.27201930.647535.98276968200945.773635.69199960.899836

22、.13204941.987335.84203957.113535.5466149202972.239635.26201987.365834.97201002.491934.67200017.618134.38199032.744236.09201189.969435.80200205.095635.51199220.221736.24205186.183135.95204201.309335.66203216.435435.36202231.561635.07201246.687734.78200261.813934.49199276.9436.20084707201434.165235.91

23、200449.291435.62199464.417536.35205430.378936.06204445.505135.76203460.631235.47202475.757435.18201490.883534.89200506.009734.60199521.135836.31201678.36136.02200693.487235.73199708.613336.16204689.700935.87203704.82735.58202719.953235.29201735.079335.00200750.205534.71199765.331636.13200937.68335.8

24、4199952.809136.27204933.896735.98203949.022835.69202964.14935.40201979.275135.11200994.401334.82200009.527434.53199024.653636.24201181.878835.95200197.004935.66199212.131136.09204193.218635.80203208.344835.51202223.470935.22201238.597134.93200253.723234.64199268.849436.35201426.074636.06200441.20073

25、5.76199456.326936.20204437.414435.91203452.540635.62202467.666735.33201482.792935.03776765200497.91934.75199513.045236.16200685.396535.87199700.522736.31204681.610236.02203696.736335.73202711.862535.44201726.988735.15200742.114834.86199757.24136.27353954200929.592335.98199944.718536.13203940.932135.

26、84202956.058335.55201971.184435.26200986.310634.97200001.436736.09200188.914235.80199204.040436.24204185.127935.95203200.254135.66202215.380235.36201230.506435.07200245.632534.78199260.758736.20200433.1135.91007722199448.236236.35204429.323736.06203444.449935.76202459.57635.47201474.702235.18200489.

27、828334.89199504.954536.31200677.305836.01911591199692.43236.16203688.645735.87202703.771835.58201718.89835.29200734.024135.00199749.150336.12815461199936.627836.27203932.841535.98276968202947.967635.69199982201963.093835.40200978.219935.11199993.346136.24200180.823635.95199195.949736.09203192.163435

28、.80202207.289635.51201222.415735.21949881200237.541934.93199252.66836.35200425.019436.06199440.145536.20203436.359235.91202451.485435.62201466.611535.33200481.737735.04199496.863836.16199684.341336.31203680.55536.01911591202695.681235.73201710.807335.44200725.933535.15199741.059636.13202939.87735.84

29、201955.003135.55200970.129335.26199985.255436.24203184.072735.95202199.198935.66201214.32535.36200229.451235.07199244.577435.76201458.520835.47200473.64735.18199488.773135.29199732.96890010001.54571174.4009821.50845.2470985.874009641.51645.4870797.348209801.47844.3470633.764009461.52445.7270608.8222

30、09621.48644.5870445.238009281.53245.9670420.296209441.49444.8270256.7120090101.5446.2070231.77029801.4944.7070084.764209261.50245.0670068.1860088121.54846.4470043.244029621.49844.9469896.238209081.5145.3069879.660086141.55646.6869854.718029441.50645.1869707.7122088101.51845.5469691.1340084161.56446.

31、9269666.192229601.46844.0469544.128029261.51445.4269519.1862086121.52645.7869502.6080082181.57247.1669477.666229421.47644.2869355.602029081.52245.6669330.662084141.53446.0269314.0820080201.5847.4069289.14229241.48444.5269167.0760288101.5345.9069142.1342082161.54246.2669125.5560078221.58847.6469100.6

32、14049601.4844.4068995.128229061.49244.7668978.550286121.53846.1468953.6082080181.5546.5068937.030076241.59647.8868912.088049421.48844.6468806.602228881.54568790.0240284141.54646.3868765.0822078201.55846.7468748.504049241.49644.8868618.0762286101.50845.2468601.4980282161.55446.6268576.5562076221.5664

33、6.9868559.978249401.45843.7468454.492049061.50445.1268429.552284121.51645.4868412.9720280181.56246.8668388.032074241.57447.2268371.452249221.46643.9868265.966048881.51245.3668241.0242282141.52445.7268224.4460278201.5747.1068199.5042072261.58247.4668182.926249041.47444.2268077.440486101.5245.6068052.

34、4982280161.53245.9668035.920276221.57847.3468010.9782070281.5947.7067994.4069401.4744.1067905.492248861.48244.4667888.9140484121.52845.8467863.9722278181.5446.2067847.3940274241.58647.5867822.4522068301.59847.9467805.874069221.47844.3467716.966248681.4944.7067700.3880482141.53646.0867675.4462276201.

35、54846.4467658.8680272261.59447.8267633.926069041.48644.5867528.442484101.49844.9467511.8620480161.54446.3267486.922274221.55646.6867470.342068861.49444.8267339.9142482121.50645.1867323.3360478181.55246.5667298.3942272241.56446.9267281.816068681.50245.0667151.3882480141.51445.4267134.810476201.5646.8

36、067109.8682270261.57247.1667093.290684101.5145.3066962.8622478161.52245.6666946.2840474221.56847.0466921.3422268281.5847.466904.764089201.4643.866815.8560682121.51845.5466774.3362476181.5345.9066757.7580472241.57647.2866732.8162266301.58847.6466716.238089021.46844.0466627.330680141.52645.7866585.812

37、474201.53846.1466569.2320470261.58447.5266544.292264321.59647.8866527.712088841.47644.2866438.8042682101.48844.6466422.2260678161.53446.0266397.2842472221.54646.3866380.7060468281.59247.7666355.764088661.48444.5266250.2782680121.49644.8866233.70676181.54246.2666208.7582470241.55446.6266192.180466301

38、.648.0066167.238088481.49244.7666061.7522678141.50445.1266045.1740674201.5546.5066020.2322468261.56246.8666003.6540882101.545.0065873.2262676161.51245.3665856.6480672221.55846.7465831.7062466281.5747.1065815.1280109001.4543.5065726.220880121.50845.2465684.72674181.5245.6065668.1220670241.56646.98656

39、43.182464301.57847.3465626.6020108821.45843.7465537.6940878141.51645.4865496.1742672201.52845.8465479.5960668261.57447.2265454.6542462321.58647.5865438.0760108641.46643.9865349.1680876161.52445.7265307.6482670221.53646.0865291.070666281.58247.4665266.1282460341.59447.8265249.550108461.47444.2265160.

40、6420874181.53245.9665119.1222668241.54446.3265102.5440664301.5947.7065077.6020108281.48244.4664972.1160872201.5446.2064930.5962666261.55246.5664914.0180662321.59847.9464889.07601080101.4944.7064783.590870221.54846.4464742.072664281.5646.8064725.4920128801.4443.2064636.58401078121.49844.9464595.06408

41、68241.55646.6864553.5442662301.56847.0464536.9660128621.44843.4464448.05801076141.50645.1864406.5380866261.56446.9264365.0182660321.57647.2864348.440128441.45643.6864259.53201074161.51445.4264218.0120864281.57247.1664176.4922658341.58447.5264159.9140128261.46443.9264071.00601072181.52245.6664029.486

42、0862301.5847.463987.9662656361.59247.7663971.3880128081.47244.1663882.4801070201.5345.963840.960860321.58847.6463799.442654381.648.0063782.86201278101.4844.4063693.95401068221.53846.1463652.4340858341.59647.8863610.9140148601.4342.9063546.94801276121.48844.6463505.42801066241.54646.3863463.908014842

43、1.43843.1463358.42201274141.49644.8863316.90201064261.55446.6263275.3820148241.44643.3863169.89601272161.50445.1263128.37601062281.56246.8663086.8560148061.45443.6262981.3701270181.51245.3662939.8501060301.5747.1062898.330147881.46243.8662792.84401268201.5245.6062751.32401058321.57847.3462709.804014

44、76101.4744.1062604.31801266221.52845.8462562.79801056341.58647.5862521.2780168401.4242.6062457.31201474121.47844.3462415.79201264241.53646.0862374.27201054361.59447.8262332.7520168221.42842.8462268.78601472141.48644.5862227.26601262261.54446.3262185.7460168041.43643.0862080.2601470161.49444.8262038.

45、7401260281.55246.5661997.220167861.44443.3261891.73401468181.50245.0661850.21401258301.5646.8061808.6940167681.45243.5661703.20801466201.5145.3061661.68801256321.56847.0461620.16801674101.4643.8061514.68201464221.51845.5461473.16201254341.57647.2861431.6420188201.4142.3061367.67601672121.46844.04613

46、2652645.7861284.63601252361.58447.5261243.1160188021.41842.5461179.1501670141.47644.2861137.6301460261.53446.0261096.1101250381.59247.7661054.590187841.42642.7860990.62401668161.48444.5260949.10401458281.54246.2660907.58401248401.648.0060866.0640187661.43443.0260802.09801666181.49244.76

47、60760.57801456301.5546.5060719.0580187481.44243.2660613.57201664201.545.0060572.05201454321.55846.7460530.53201872101.4543.5060425.04601662221.50845.2460383.52601452341.56646.9860342.0060208001.442.0060278.0401870121.45843.7460236.5201660241.51645.486019501450361.57447.2260153.480207821.40842.246008

48、9.51401868141.46643.9860047.99401658261.52445.7260006.47401448381.58247.4659964.9540207641.41642.4859900.98801866161.47444.2259859.46801656281.53245.9659817.94801446401.5947.7059776.4280207461.42442.7259712.46201864181.48244.4659670.94201654301.5446.2059629.42201444421.59847.9459587.9020207281.43242

49、.9659523.93601862201.4944.7059482.41601652321.54846.4459440.89602070101.4443.2059335.4101860221.49844.9459293.8901650341.55646.6859252.370227801.3941.7059188.40402068121.44843.4459146.88401858241.50645.1859105.36401648361.56446.9259063.8440227621.39841.9458999.87802066141.45643.6858958.35801856261.5

50、1445.4258916.83801646381.57247.1658875.3180227441.40642.1858811.35202064161.46443.9258769.83201854281.52245.6658728.31201644401.5847.4058686.7920227261.41442.4258622.82602062181.47244.1658581.30601852301.5345.9058539.78601642421.58847.6458498.2660227081.42242.6658434.302060201.4844.4058392.780185032

51、1.53846.1458351.2601640441.59647.8858309.7402268101.4342.9058245.77402058221.48844.6458204.25401848341.54646.3858162.7340247601.3841.4058098.76802266121.43843.1458057.24802056241.49644.8858015.72801846361.55446.6257974.2080247421.38841.6457910.24202264141.44643.3857868.72202054261.50445.1257827.2020

52、1844381.56246.8657785.6820247241.39641.8857721.71602262161.45443.6257680.19602052281.51245.3657638.67601842401.5747.1057597.1560247061.40442.1257533.1902260181.46243.8657491.6702050301.5245.6057450.1501840421.57847.3457408.630246881.41242.3657344.66402258201.4744.105730352845.8457261.62

53、401838441.58647.5857220.10402466101.4242.605715647844.3457114.61802046341.53646.0857073.09801836461.59447.8257031.5780267401.3741.105700942842.8456967.61202254241.48644.5856926.09202044361.54446.3256884.5720267221.37841.3456820.60602462141.43643.0856779.08602252261.49444.82

54、56737.56602042381.55246.5656696.0460267041.38641.5856632.0802460161.44443.3256590.5602250281.50245.0656549.0402040401.5646.8056507.520266861.39441.8256443.55402458181.45243.5656402.03402248301.5145.356360.51402038421.56847.0456318.9940266681.40242.0656255.02802456201.4643.8056213.50802246321.51845.5

55、456171.98802036441.57647.2856130.46802664101.4142.3056066.50202454221.46844.0456024.98202244341.52645.7855983.46202034461.58447.5255941.9420287201.3640.8055919.49602662121.41842.5455877.97602452241.47644.2855836.45602242361.53446.0255794.93602032481.59247.7655753.4160287021.36841.0455730.9702660141.

56、42642.7855689.4502450261.48444.5255647.9302240381.54246.2655606.4102030501.648.0055564.890286841.37641.2855542.44402658161.43443.0255500.92402448281.49244.7655459.40402238401.5546.5055417.8840286661.38441.5255353.91802656181.44243.2655312.39802446301.54555270.87802236421.55846.7455229.3580286481.392

57、41.7655165.39202654201.4543.5055123.87202444321.50845.2455082.35202234441.56646.9855040.83202862101.442.0054976.86602652221.45843.7454935.34602442341.51645.4854893.82602232461.57447.2254852.3060307001.3540.5054829.8602860121.40842.2454788.3402650241.46643.9854746.8202440361.52445.7254705.302230481.5

58、8247.4654663.780306821.35840.7454641.33402858141.41642.4854599.81402648261.47444.2254558.29402438381.53245.9654516.77402228501.5947.7054475.2540306641.36640.9854452.80802856161.42442.7254411.28802646281.48244.4654369.76802436401.5446.2054328.24802226521.59847.9454286.7280306461.37441.2254264.2820285

59、4181.43242.9654222.76202644301.4944.7054181.24202434421.54846.4454139.7220306281.38241.4654075.75602852201.4443.254034.23602642321.49844.9453992.71602432441.55646.6853951.19603060101.3941.7053887.2302850221.44843.4453845.7102640341.50645.1853804.1902430461.56446.9253762.670326801.3440.2053740.224030

60、58121.39841.9453698.70402848241.45643.685365751445.4253615.66402428481.57247.1653574.1440326621.34840.4453551.69803056141.40642.185351046443.9253468.65802636381.52245.66534275847.4053385.6180326441.35640.685336341442.4253321.65202844281.47244.16532