营销预算表.xlsx

《营销预算表.xlsx》由会员分享，可在线阅读，更多相关《营销预算表.xlsx（43页珍藏版）》请在得力文库 - 分享文档赚钱的网站上搜索。

1、填表说明1、此套表格使用部门为营销管理中心，主要目的用于年度经营预算编制取数2、填制要求：1）盘点房源资料清单，请照实填写，作为房源资料表格支持文件2）房源资料表格根据房源清单分项目/分楼栋/分开发进度填写，并分类填写销售方式：现楼/预售；预售部份需提供竣工日期。3）盘点核实12年实际销售情况(第四季度数以12年预算或者调整预算(重新预测)数为准)，得出13年可售房源，并根据市场情况填列预测均价4）月度销售预测计划填写预计销售数量，销售金额参照预计单套价格计算。5）收入现金流入预算表需提供12年应收未收房款清单及预计资金回笼措施作为现金流的计算依据，如：30%，60%，10%6）销售费用按计划

2、列支3）盘点核实12年实际销售情况(第四季度数以12年预算或者调整预算(重新预测)数为准)，得出13年可售房源，并根据市场情况填列预测均价5）收入现金流入预算表需提供12年应收未收房款清单及预计资金回笼措施作为现金流的计算依据，如：30%，60%，10%序序号号项项目目房房源源类类别别竣竣工工日日期期组组团团栋栋房房号号类类型型建建筑筑面面积积218 四期洋房58-65预售217 四期洋房58-65预售216 四期洋房58-65预售215 四期洋房58-65预售214 四期洋房58-65预售开开盘盘单单价价开开盘盘总总价价当当前前单单价价当当前前总总价价预预计计成成效效单单价价预预计计成成交交

3、总总价价实实际际折折扣扣比比率率实实际际折折扣扣金金额额备备注注0000000000房房源源汇汇总总表表值值行行标标签签求求和和项项: :建建筑筑面面积积求求和和项项: :开开盘盘总总价价求求和和项项: :当当前前总总价价三三期期9485.959485.95113541826113541826115916729115916729三期车位7984.55100916729100916729三期公寓1501.41262509715000000四四期期47513.9447513.9473244698473244698485100000085100000056-57213.328668303000000

4、58-651066.5143341501500000066-7010197.06970613539800000071-72213.32866830300000071栋213.32866830300000072栋213.328668303000000三区叠加1804.262252901227000000四期车位213.328668303000000一、二区叠加16562230534650264500000一、二区联排14606.67293169233356500000一、二区双拼2210.956048443675000000一一二二期期11845.8511845.8513326784713326

5、7847144514217144514217一二期车位5869.565608600056086000一二期楼王4174.815637832567624695一二期商铺1801.482080352220803522( (空空白白) )(空白)总总计计68845.7468845.7497925665797925665711114309461111430946预预计计销销售售套套数数假假设设签签约约率率计计数数项项: :预预计计成成交交总总价价预测均价11月 12月1月 2月 3月 4月 5月 6月 7月 8月 9月 10月80002190002312000521800011800032300002

6、1250001195552285001125000110020140000000011月 12月00序号项目房源类别 竣工日期组团栋 房号 建筑面积开盘单价开盘总价1一二期车位一二期车位00 5869.569,55556,086,0002一二期洋房一二期楼王00 4174.8113,50456,378,3253一二期商铺一二期商铺00 1801.4811,54820,803,5224三期车位三期车位00 7984.5512,639100,916,7295三期洋房三期公寓730460.328,307501,0596三期洋房三期公寓730560.328,307501,0597三期洋房三期公寓740

7、460.328,327502,2628三期洋房三期公寓740560.328,327502,2629三期洋房三期公寓750460.328,347503,46610三期洋房三期公寓750560.328,347503,46611三期洋房三期公寓770460.328,386505,87312三期洋房三期公寓770560.328,386505,87313三期洋房三期公寓820160.188,460509,13914三期洋房三期公寓830460.328,315501,54015三期洋房三期公寓830560.328,315501,54016三期洋房三期公寓840460.328,335502,74417三期洋

8、房三期公寓840560.328,335502,74418三期洋房三期公寓850460.328,355503,94719三期洋房三期公寓850560.328,355503,94720三期洋房三期公寓860460.328,375505,15121三期洋房三期公寓860560.328,375505,15122三期洋房三期公寓870460.328,394506,35523三期洋房三期公寓880460.328,414507,55824三期洋房三期公寓880560.328,414507,55825三期洋房三期公寓8110560.328,494512,37326三期洋房三期公寓8110860.188,552

9、514,66327三期洋房三期公寓8180160.188,758527,07728三期洋房三期公寓8180354.288,594466,50229三期洋房三期公寓8180860.188,670521,78830四期叠加一、二区叠加5101275.7118,1625,007,43231四期叠加一、二区叠加5102251.8916,7614,221,84332四期叠加一、二区叠加5103251.8916,9614,272,22933四期叠加一、二区叠加5104275.7119,1625,283,20234四期叠加一、二区叠加5301234.4117,1594,022,17835四期叠加一、二区叠加

10、5302228.8416,4593,766,41336四期叠加一、二区叠加5303228.8416,5593,789,29837四期叠加一、二区叠加5304234.4117,7594,162,83038四期叠加一、二区叠加19106275.1812,7963,521,20339四期叠加一、二区叠加42103252.1915,6193,939,01340四期叠加一、二区叠加42104252.1915,6193,939,01341四期叠加一、二区叠加42105251.3915,6193,926,51742四期叠加一、二区叠加42302228.3616,3453,732,57643四期叠加一、二区叠

11、加42303218.216,3453,566,50944四期叠加一、二区叠加42304229.0816,3453,744,34445四期叠加一、二区叠加42305228.3616,3453,732,57646四期叠加一、二区叠加43102251.3915,6033,922,53647四期叠加一、二区叠加43103252.1915,6033,935,01848四期叠加一、二区叠加43104252.1915,6033,935,01849四期叠加一、二区叠加43105251.3915,6033,922,53650四期叠加一、二区叠加43302228.3616,3293,728,95951四期叠加一、

12、二区叠加43303218.216,3293,563,05352四期叠加一、二区叠加43304229.0816,3293,740,71653四期叠加一、二区叠加43305228.3616,3293,728,95954四期叠加一、二区叠加44101252.1910,4752,641,72655四期叠加一、二区叠加44102252.1910,4752,641,72656四期叠加一、二区叠加44103252.1910,4752,641,72657四期叠加一、二区叠加44104252.1910,4752,641,72658四期叠加一、二区叠加44105252.1910,4752,641,72659四期叠

13、加一、二区叠加44106252.1910,4752,641,72660四期叠加一、二区叠加44301252.1910,4752,641,72661四期叠加一、二区叠加44302252.1910,4752,641,72662四期叠加一、二区叠加44303252.1910,4752,641,72663四期叠加一、二区叠加44304252.1910,4752,641,72664四期叠加一、二区叠加44305252.1910,4752,641,72665四期叠加一、二区叠加44306252.1910,4752,641,72666四期叠加一、二区叠加47103252.1910,4752,641,7266

14、7四期叠加一、二区叠加47104252.1910,4752,641,72668四期叠加一、二区叠加47105251.3910,4422,625,05169四期叠加一、二区叠加47303218.213,1382,866,69570四期叠加一、二区叠加47304229.0813,1383,009,63671四期叠加一、二区叠加47306233.9114,5573,404,97072四期叠加一、二区叠加49102251.8910,5432,655,62873四期叠加一、二区叠加49103251.8910,5432,655,62874四期叠加一、二区叠加50103251.9310,4092,622,3

15、7775四期叠加一、二区叠加50301234.4214,5243,404,65976四期叠加一、二区叠加50302228.8513,0722,991,51177四期叠加一、二区叠加50303228.8513,0722,991,51178四期叠加一、二区叠加50304234.4214,5243,404,65979四期叠加一、二区叠加51304229.0813,2043,024,75380四期叠加一、二区叠加52102251.8910,3712,612,40281四期叠加一、二区叠加52103251.8910,3712,612,40282四期叠加一、二区叠加52301234.4114,4853,3

16、95,37783四期叠加一、二区叠加52302228.8413,0332,982,45084四期叠加一、二区叠加52303228.8413,0332,982,45085四期叠加一、二区叠加52304234.4114,4853,395,37786四期叠加一、二区叠加53101275.1815,8114,350,76287四期叠加一、二区叠加53102251.3914,9693,763,10888四期叠加一、二区叠加53103252.1914,6233,687,71089四期叠加一、二区叠加53104252.1914,5073,658,58690四期叠加一、二区叠加53105251.3914,39

17、23,617,94891四期叠加一、二区叠加53106275.1815,0024,128,30592四期叠加一、二区叠加53301233.9116,5303,866,51393四期叠加一、二区叠加53302228.3615,3753,511,04894四期叠加一、二区叠加53303218.215,3093,340,43895四期叠加一、二区叠加53304229.0815,3093,507,00096四期叠加一、二区叠加53305228.3615,3753,511,04897四期叠加一、二区叠加53306233.9116,5303,866,51398四期联排一、二区联排4101331.3619,

18、1716,352,53499四期联排一、二区联排4104320.7425,3558,132,500100 四期联排一、二区联排6105292.6913,4183,927,314101 四期联排一、二区联排15106321.5117,4615,613,845102 四期联排一、二区联排16104325.0917,2095,594,391103 四期联排一、二区联排30104296.2716,2124,803,061104 四期联排一、二区联排30106336.4718,7766,317,408105 四期联排一、二区联排31101335.5817,0885,734,413106 四期联排一、二区

19、联排32102295.217,0065,020,061107 四期联排一、二区联排32104335.5918,7256,283,847108 四期联排一、二区联排34101335.5918,7256,283,847109 四期联排一、二区联排34102335.5918,7256,283,847110 四期联排一、二区联排34103335.5918,7256,283,847111 四期联排一、二区联排34104335.5918,7256,283,847112 四期联排一、二区联排34105335.5918,7256,283,847113 四期联排一、二区联排34106335.5918,7256,

20、283,847114 四期联排一、二区联排35101335.5919,9826,705,820115 四期联排一、二区联排35102295.2018,1605,360,949116 四期联排一、二区联排35103295.2018,1605,360,949117 四期联排一、二区联排35104335.5919,8546,662,761118 四期联排一、二区联排38101335.5918,7256,283,847119 四期联排一、二区联排38102335.5918,7256,283,847120 四期联排一、二区联排38103335.5918,7256,283,847121 四期联排一、二区联

21、排38104335.5918,7256,283,847122 四期联排一、二区联排39103295.3123,4606,927,829123 四期联排一、二区联排40102292.6223,3676,837,713124 四期联排一、二区联排40103295.8522,6146,690,310125 四期联排一、二区联排40104295.5522,8816,762,356126 四期联排一、二区联排41101335.5918,7256,283,847127 四期联排一、二区联排41102335.5918,7256,283,847128 四期联排一、二区联排41103335.5918,7256,

22、283,847129 四期联排一、二区联排41104335.5918,7256,283,847130 四期联排一、二区联排41105335.5918,7256,283,847131 四期联排一、二区联排41106335.5918,7256,283,847132 四期联排一、二区联排54102297.5624,1567,187,998133 四期联排一、二区联排54103297.6823,3866,961,690134 四期联排一、二区联排54104297.6823,6437,038,092135 四期联排一、二区联排54105297.6823,6437,038,092136 四期联排一、二区联

23、排54106298.1422,9376,838,537137 四期联排一、二区联排54107298.0522,5526,721,727138 四期联排一、二区联排54108297.6822,4886,694,282139 四期联排一、二区联排54109297.6822,4246,675,181140 四期联排一、二区联排54110297.6822,2326,617,879141 四期联排一、二区联排54111296.8922,5526,695,566142 四期联排一、二区联排54112296.2622,9376,795,415143 四期联排一、二区联排54113332.8424,8628,

24、275,161144 四期联排一、二区双拼26101442.1923,50410,393,321145 四期联排一、二区双拼26102442.1925,53111,289,441146 四期联排一、二区双拼27101442.1924,11210,662,281147 四期联排一、二区双拼28102442.1931,20813,800,068148 四期联排一、二区双拼29102442.1932,42814,339,325149 四期叠加三区叠加83102175.512,5432,201,320150 四期叠加三区叠加83103175.512,7282,233,813151 四期叠加三区叠加83

25、105175.513,1062,300,048152 四期叠加三区叠加83301213.311,7742,511,411153 四期叠加三区叠加83302212.7811,9592,544,683154 四期叠加三区叠加83303212.812,1442,584,321155 四期叠加三区叠加83304212.812,3302,623,719156 四期叠加三区叠加83305212.7812,5152,662,867157 四期叠加三区叠加83306213.313,4402,866,830158 四期洋房56-57213.313,4402,866,830159 四期洋房71-72213.313

26、,4402,866,830160 四期洋房71栋213.313,4402,866,830161 四期洋房72栋213.313,4402,866,830162 四期车位四期车位213.313,4402,866,830163 四期洋房66-7066602170.228,9201,518,369164 四期洋房66-7066702169.339,0251,528,140165 四期洋房66-7066902169.339,0871,538,766166 四期洋房66-7066 1102169.339,1501,549,392167 四期洋房66-7066 1302169.339,2131,560,01

27、7168 四期洋房66-7066 1402170.229,2441,573,558169 四期洋房66-7066 1502169.339,2441,565,330170 四期洋房66-7066 1702169.339,3071,575,956171 四期洋房66-7067302169.338,2741,401,022172 四期洋房66-7067303155.868,2021,278,414173 四期洋房66-7067602170.229,0061,533,007174 四期洋房66-7068602170.229,1181,551,997175 四期洋房66-7068802170.229,2

28、541,575,141176 四期洋房66-7068 1001172.169,2011,584,090177 四期洋房66-7068 1402170.229,4421,607,186178 四期洋房66-7069202170.228,4491,438,210179 四期洋房66-7069302169.338,6491,464,556180 四期洋房66-7069602170.228,8491,506,298181 四期洋房66-7069 1402170.229,4291,605,025182 四期洋房66-7069 1802170.229,2191,569,279183 四期洋房66-7070

29、201 233.798,5782,005,502184 四期洋房66-7070202 233.808,2281,923,758185 四期洋房66-7070203 190.318,5281,623,006186 四期洋房66-7070301 233.898,9282,088,221187 四期洋房66-7070302 233.908,3281,947,971188 四期洋房66-7070303 189.928,8281,676,656189 四期洋房66-7070402 233.808,3281,947,138190 四期洋房66-7070502 233.908,4281,971,361191

30、 四期洋房66-7070503 189.929,1281,733,632192 四期洋房66-7070601 233.799,9282,321,119193 四期洋房66-7070602 233.808,5281,993,898194 四期洋房66-7070603 190.319,3281,775,254195 四期洋房66-7070702 233.908,5882,008,785196 四期洋房66-7070803190.319,4081,790,478197 四期洋房66-7070902233.908,7082,036,853198 四期洋房66-70701002233.808,7882,

31、054,686199 四期洋房66-70701402233.809,0282,110,798200 四期洋房66-70701501233.8910,7282,509,223201 四期洋房66-70701602233.809,3082,176,262202 四期洋房66-70701802233.809,3882,194,966203 四期洋房66-70701803190.3110,2881,957,951204 四期洋房66-70701902233.9011,0882,593,535205 四期洋房66-70702002233.8011,2882,639,186206 四期洋房66-70702

32、003190.3111,1882,129,230207 四期洋房66-70702102233.9011,4882,687,095208 四期洋房66-70702103189.9211,3882,162,851209 四期洋房66-70702202233.8011,6882,732,706210 四期洋房66-70702302233.9011,8882,780,655211 四期洋房66-70702303189.9211,7882,238,819212 四期洋房66-70702402233.8011,1882,615,806213 四期洋房66-70702403190.3111,0882,110

33、,199214 四期洋房58-65213.313,4402,866,830215 四期洋房58-65213.313,4402,866,830216 四期洋房58-65213.313,4402,866,830217 四期洋房58-65213.313,4402,866,830218 四期洋房58-65213.313,4402,866,830当前单价当前总价预计成效单价预计成交总价实际折扣比率实际折扣金额备注9,55556,086,00016,19867,624,69511,54820,803,52212,639100,916,7299,947600,0009,947600,0009,947600,

34、0009,947600,0009,947600,0009,947600,0009,947600,0009,947600,0009,970600,0009,947600,0009,947600,0009,947600,0009,947600,0009,947600,0009,947600,0009,947600,0009,947600,0009,947600,0009,947600,0009,947600,0009,947600,0009,970600,0009,970600,00011,054600,0009,970600,00018,1355,000,000.0019,8505,000,00

35、0.0019,8505,000,000.0018,1355,000,000.0021,3305,000,000.0021,8495,000,000.0021,8495,000,000.0021,3305,000,000.0018,1705,000,000.0019,8265,000,000.0019,8265,000,000.0019,8895,000,000.0021,8955,000,000.0022,9155,000,000.0021,8265,000,000.0021,8955,000,000.0019,8895,000,000.0019,8265,000,000.0019,8265,

36、000,000.0019,8895,000,000.0021,8955,000,000.0022,9155,000,000.0021,8265,000,000.0021,8955,000,000.0011,8963,000,000.0011,8963,000,000.0011,8963,000,000.0011,8963,000,000.0011,8963,000,000.0011,8963,000,000.0011,8963,000,000.0011,8963,000,000.0011,8963,000,000.0011,8963,000,000.0011,8963,000,000.0011

37、,8963,000,000.0011,8963,000,000.0011,8963,000,000.0011,9343,000,000.0013,7493,000,000.0013,0963,000,000.0012,8253,000,000.0011,9103,000,000.0011,9103,000,000.0011,9083,000,000.0012,7983,000,000.0013,1093,000,000.0013,1093,000,000.0012,7983,000,000.0013,0963,000,000.0011,9103,000,000.0011,9103,000,00

38、0.0012,7983,000,000.0013,1103,000,000.0013,1103,000,000.0012,7983,000,000.0018,1705,000,000.0011,9343,000,000.0011,8963,000,000.0011,8963,000,000.0011,9343,000,000.0016,3534,500,000.0019,2384,500,000.0019,7064,500,000.0020,6234,500,000.0019,6444,500,000.0019,7064,500,000.0019,2384,500,000.0013,5804,

39、500,000.0014,0304,500,000.0015,3754,500,000.0024,8838,000,000.0030,76110,000,000.0016,8765,000,000.0023,7768,000,000.0023,8398,000,000.0027,1008,000,000.0023,8398,000,000.0023,8398,000,000.0023,8398,000,000.0023,8398,000,000.0023,8398,000,000.0023,8398,000,000.0023,8398,000,000.0023,8398,000,000.002

40、7,1008,000,000.0027,1008,000,000.0023,8398,000,000.0023,8398,000,000.0023,8398,000,000.0023,8398,000,000.0023,8398,000,000.0027,0908,000,000.0027,3398,000,000.0027,0418,000,000.0027,0688,000,000.0023,8398,000,000.0023,8398,000,000.0023,8398,000,000.0023,8398,000,000.0023,8398,000,000.0023,8398,000,0

41、00.0026,8858,000,000.0026,8748,000,000.0026,8748,000,000.0026,8748,000,000.0026,8338,000,000.0026,8418,000,000.0026,8748,000,000.0026,8748,000,000.0026,8748,000,000.0026,9468,000,000.0027,0038,000,000.0024,0368,000,000.0033,92215,000,000.0033,92215,000,000.0033,92215,000,000.0033,92215,000,000.0033,

42、92215,000,000.0017,0943,000,000.0017,0943,000,000.0017,0943,000,000.0014,0653,000,000.0014,0993,000,000.0014,0983,000,000.0014,0983,000,000.0014,0993,000,000.0014,0653,000,000.0014,0653,000,000.0014,0653,000,000.0014,0653,000,000.0014,0653,000,000.0014,0653,000,000.0010,5751,800,000.0010,6301,800,00

43、0.0010,6301,800,000.0010,6301,800,000.0010,6301,800,000.0010,5751,800,000.0010,6301,800,000.0010,6301,800,000.0010,6301,800,000.0011,5491,800,000.0010,5751,800,000.0010,5751,800,000.0010,5751,800,000.0010,4551,800,000.0010,5751,800,000.0010,5751,800,000.0010,6301,800,000.0010,5751,800,000.0010,5751,

44、800,000.0010,5751,800,000.008,5552,000,000.008,5542,000,000.0010,5092,000,000.008,5512,000,000.008,5512,000,000.0010,5312,000,000.008,5542,000,000.008,5512,000,000.0010,5312,000,000.008,5552,000,000.008,5542,000,000.0010,5092,000,000.008,5512,000,000.0010,5092,000,000.008,5512,000,000.008,5542,000,0

45、00.008,5542,000,000.008,5512,000,000.008,5542,000,000.008,5542,000,000.0010,5092,000,000.008,5512,000,000.008,5542,000,000.0010,5092,000,000.008,5512,000,000.0010,5312,000,000.008,5542,000,000.008,5512,000,000.0010,5312,000,000.008,5542,000,000.0010,5092,000,000.0014,0653,000,000.0014,0653,000,000.0

46、014,0653,000,000.0014,0653,000,000.0014,0653,000,000.00未未售售房房源源清清单单序号项目项目房源情况12年10月份及之前已售面积套数均价金额面积套数1 1三三期期-1,380326,000,0002 2三三期期车车位位1,200200,000,0003 3三三期期公公寓寓180126,000,0004 4四四期期5 556-5756-57128384,000,0006 658-6558-656801,360,000,0007 766-7066-70420630,000,0008 871-7271-7296288,000,0009 97171

47、栋栋48144,000,00010107272栋栋48144,000,0001111三三区区叠叠加加2501,000,000,0001212四四期期车车位位2,000300,000,0001313一一、二二区区叠叠加加150600,000,0001414一一、二二区区联联排排1501,500,000,0001515一一、二二区区双双拼拼2001,600,000,0001616一一二二期期1717一一二二期期车车位位1,500180,000,0001818一一二二期期楼楼王王72216,000,0001919一一二二期期商商铺铺160350,000,0002020( (空空白白) )( (空空白

48、白) )合合计计- -1,3801,380326,000,000326,000,000- - -备注：1、此表以未售完的房源资料填写2、类型有现楼及预售区分，填表时，预售部份请注明竣工日期，用于及时转为营业收入3、13年销售情况请提供销售计划、开盘计划作为相关支持文件4、未售部份可售均价以市场预测相关文件为支持文件可售房源销售计划（金额）均价金额面积套数预测均价金额1111月月1212月月9,485.951,38071,860,950-7,984.551,2009,00071,860,950-1,501.40180-47,513.944,170882,503,550-213.30128-1,0

49、66.5068012,00012,798,000-10,197.06420-213.3096-213.3048-213.304818,0003,839,400-1,804.26250-213.302,00018,0003,839,400-16,562.0015030,000496,860,000-14,606.6715025,000365,166,750-2,210.95200-11,845.851,732.00154,261,510.00-5,869.561,5008,50049,891,260-4,174.817225,000104,370,250-1,801.48160- -68,845

50、.7468,845.747,2827,2821,108,626,0101,108,626,010未未售售房房源源清清单单12年10月份及之前已售1季度1 1月月2 2月月3 3月月2季季度度4 4月月5 5月月299,420119768179652-299,420119768179652-20,958,812122047918754021-131,7449410337641-79,98879988-9,59857593839-9,937,20066248003312400-4,868,89024344452434445-5,931,39229656962965696-2,965,6961482