《营销预算表.xlsx》由会员分享，可在线阅读，更多相关《营销预算表.xlsx（39页珍藏版）》请在三一文库上搜索。
1、填表说明 1、此套表格使用部门为营销管理中心，主要目的用于年度经营预算编制取数 2、填制要求： 1）盘点房源资料清单，请照实填写，作为房源资料表格支持文件 2）房源资料表格根据房源清单分项目/分楼栋/分开发进度填写，并分类填写销售方式： 现楼/预售；预售部份需提供竣工日期。 3）盘点核实12年实际销售情况(第四季度数以12年预算或者调整预算(重新预测)数为准)，得出13年可售房源，并根据市场情况填列预测均价 4）月度销售预测计划填写预计销售数量，销售金额参照预计单套价格计算。 5）收入现金流入预算表需提供12年应收未收房款清单及预计资金回笼措施作为现金流的计算依据，如：30%，60%，10%
2、6）销售费用按计划列支 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、计计 成成效效单单价价预预计计 成成交交总总价价实实际际 折折扣扣比比率率实实际际 折折扣扣金金额额备备注注 00 00 00 00 00 房房源源汇汇总总表表 值值 行行标标签签求求和和项项: :建建筑筑面面积积求求和和项项: :开开盘盘总总价价求求和和项项: :当当前前总总价价 三三期期9 94 48 85 5. .9 95 51 11 13 35 54 41 18 82 26 61 11 15 59 91 16 67 72 29 9 三期车位7984.55100916729100916729 三期公寓1501.41262509715000000 四四期期4 47 75 51 13 3.
4、.9 94 47 73 32 24 44 46 69 98 84 48 85 51 10 00 00 00 00 00 0 56-57213.328668303000000 58-651066.51433415015000000 66-7010197.069706135398000000 71-72213.328668303000000 71栋213.328668303000000 72栋213.328668303000000 三区叠加1804.262252901227000000 四期车位213.328668303000000 一、二区叠加16562230534650264500000 一、
5、二区联排14606.67293169233356500000 一、二区双拼2210.956048443675000000 一一二二期期1 11 18 84 45 5. .8 85 51 13 33 32 26 67 78 84 47 71 14 44 45 51 14 42 21 17 7 一二期车位5869.565608600056086000 一二期楼王4174.815637832567624695 一二期商铺1801.482080352220803522 ( (空空白白) ) (空白) 总总计计6 68 88 84 45 5. .7 74 49 97 79 92 25 56 66 65
6、57 71 11 11 11 14 43 30 09 94 46 6 预预计计销销售售套套数数 假假设设签签约约率率 计计数数项项: :预预计计 成成交交总总价价预测均价11月12月1月2月3月4月5月6月7月8月9月10月 800021 900023 1200052 180001 1800032 3000021 2500011 955522 850011 2500011 00201400000000 房房源源汇汇总总表表 11月12月 00 预预计计销销售售套套数数 序号项目房源类别竣工日期组团栋房号 建筑面积开盘单价开盘总价 1一二期车位一二期车位00 5869.569,55556,086
7、,000 2一二期洋房一二期楼王00 4174.8113,50456,378,325 3一二期商铺一二期商铺00 1801.4811,54820,803,522 4三期车位三期车位00 7984.5512,639100,916,729 5三期洋房三期公寓730460.328,307501,059 6三期洋房三期公寓730560.328,307501,059 7三期洋房三期公寓740460.328,327502,262 8三期洋房三期公寓740560.328,327502,262 9三期洋房三期公寓750460.328,347503,466 10三期洋房三期公寓750560.328,347503
8、,466 11三期洋房三期公寓770460.328,386505,873 12三期洋房三期公寓770560.328,386505,873 13三期洋房三期公寓820160.188,460509,139 14三期洋房三期公寓830460.328,315501,540 15三期洋房三期公寓830560.328,315501,540 16三期洋房三期公寓840460.328,335502,744 17三期洋房三期公寓840560.328,335502,744 18三期洋房三期公寓850460.328,355503,947 19三期洋房三期公寓850560.328,355503,947 20三期洋房三
9、期公寓860460.328,375505,151 21三期洋房三期公寓860560.328,375505,151 22三期洋房三期公寓870460.328,394506,355 23三期洋房三期公寓880460.328,414507,558 24三期洋房三期公寓880560.328,414507,558 25三期洋房三期公寓8110560.328,494512,373 26三期洋房三期公寓8110860.188,552514,663 27三期洋房三期公寓8180160.188,758527,077 28三期洋房三期公寓8180354.288,594466,502 29三期洋房三期公寓81808
10、60.188,670521,788 30四期叠加一、二区叠加5101275.7118,1625,007,432 31四期叠加一、二区叠加5102251.8916,7614,221,843 32四期叠加一、二区叠加5103251.8916,9614,272,229 33四期叠加一、二区叠加5104275.7119,1625,283,202 34四期叠加一、二区叠加5301234.4117,1594,022,178 35四期叠加一、二区叠加5302228.8416,4593,766,413 36四期叠加一、二区叠加5303228.8416,5593,789,298 37四期叠加一、二区叠加5304
11、234.4117,7594,162,830 38四期叠加一、二区叠加19106275.1812,7963,521,203 39四期叠加一、二区叠加42103252.1915,6193,939,013 40四期叠加一、二区叠加42104252.1915,6193,939,013 41四期叠加一、二区叠加42105251.3915,6193,926,517 42四期叠加一、二区叠加42302228.3616,3453,732,576 43四期叠加一、二区叠加42303218.216,3453,566,509 44四期叠加一、二区叠加42304229.0816,3453,744,344 45四期叠加
12、一、二区叠加42305228.3616,3453,732,576 46四期叠加一、二区叠加43102251.3915,6033,922,536 47四期叠加一、二区叠加43103252.1915,6033,935,018 48四期叠加一、二区叠加43104252.1915,6033,935,018 49四期叠加一、二区叠加43105251.3915,6033,922,536 50四期叠加一、二区叠加43302228.3616,3293,728,959 51四期叠加一、二区叠加43303218.216,3293,563,053 52四期叠加一、二区叠加43304229.0816,3293,740
13、,716 53四期叠加一、二区叠加43305228.3616,3293,728,959 54四期叠加一、二区叠加44101252.1910,4752,641,726 55四期叠加一、二区叠加44102252.1910,4752,641,726 56四期叠加一、二区叠加44103252.1910,4752,641,726 57四期叠加一、二区叠加44104252.1910,4752,641,726 58四期叠加一、二区叠加44105252.1910,4752,641,726 59四期叠加一、二区叠加44106252.1910,4752,641,726 60四期叠加一、二区叠加44301252.1
14、910,4752,641,726 61四期叠加一、二区叠加44302252.1910,4752,641,726 62四期叠加一、二区叠加44303252.1910,4752,641,726 63四期叠加一、二区叠加44304252.1910,4752,641,726 64四期叠加一、二区叠加44305252.1910,4752,641,726 65四期叠加一、二区叠加44306252.1910,4752,641,726 66四期叠加一、二区叠加47103252.1910,4752,641,726 67四期叠加一、二区叠加47104252.1910,4752,641,726 68四期叠加一、二区
15、叠加47105251.3910,4422,625,051 69四期叠加一、二区叠加47303218.213,1382,866,695 70四期叠加一、二区叠加47304229.0813,1383,009,636 71四期叠加一、二区叠加47306233.9114,5573,404,970 72四期叠加一、二区叠加49102251.8910,5432,655,628 73四期叠加一、二区叠加49103251.8910,5432,655,628 74四期叠加一、二区叠加50103251.9310,4092,622,377 75四期叠加一、二区叠加50301234.4214,5243,404,659
16、 76四期叠加一、二区叠加50302228.8513,0722,991,511 77四期叠加一、二区叠加50303228.8513,0722,991,511 78四期叠加一、二区叠加50304234.4214,5243,404,659 79四期叠加一、二区叠加51304229.0813,2043,024,753 80四期叠加一、二区叠加52102251.8910,3712,612,402 81四期叠加一、二区叠加52103251.8910,3712,612,402 82四期叠加一、二区叠加52301234.4114,4853,395,377 83四期叠加一、二区叠加52302228.8413,
17、0332,982,450 84四期叠加一、二区叠加52303228.8413,0332,982,450 85四期叠加一、二区叠加52304234.4114,4853,395,377 86四期叠加一、二区叠加53101275.1815,8114,350,762 87四期叠加一、二区叠加53102251.3914,9693,763,108 88四期叠加一、二区叠加53103252.1914,6233,687,710 89四期叠加一、二区叠加53104252.1914,5073,658,586 90四期叠加一、二区叠加53105251.3914,3923,617,948 91四期叠加一、二区叠加53
18、106275.1815,0024,128,305 92四期叠加一、二区叠加53301233.9116,5303,866,513 93四期叠加一、二区叠加53302228.3615,3753,511,048 94四期叠加一、二区叠加53303218.215,3093,340,438 95四期叠加一、二区叠加53304229.0815,3093,507,000 96四期叠加一、二区叠加53305228.3615,3753,511,048 97四期叠加一、二区叠加53306233.9116,5303,866,513 98四期联排一、二区联排4101331.3619,1716,352,534 99四期
19、联排一、二区联排4104320.7425,3558,132,500 100四期联排一、二区联排6105292.6913,4183,927,314 101四期联排一、二区联排15106321.5117,4615,613,845 102四期联排一、二区联排16104325.0917,2095,594,391 103四期联排一、二区联排30104296.2716,2124,803,061 104四期联排一、二区联排30106336.4718,7766,317,408 105四期联排一、二区联排31101335.5817,0885,734,413 106四期联排一、二区联排32102295.217,0
20、065,020,061 107四期联排一、二区联排32104335.5918,7256,283,847 108四期联排一、二区联排34101335.5918,7256,283,847 109四期联排一、二区联排34102335.5918,7256,283,847 110四期联排一、二区联排34103335.5918,7256,283,847 111四期联排一、二区联排34104335.5918,7256,283,847 112四期联排一、二区联排34105335.5918,7256,283,847 113四期联排一、二区联排34106335.5918,7256,283,847 114四期联排一
21、、二区联排35101335.5919,9826,705,820 115四期联排一、二区联排35102295.2018,1605,360,949 116四期联排一、二区联排35103295.2018,1605,360,949 117四期联排一、二区联排35104335.5919,8546,662,761 118四期联排一、二区联排38101335.5918,7256,283,847 119四期联排一、二区联排38102335.5918,7256,283,847 120四期联排一、二区联排38103335.5918,7256,283,847 121四期联排一、二区联排38104335.5918,7
22、256,283,847 122四期联排一、二区联排39103295.3123,4606,927,829 123四期联排一、二区联排40102292.6223,3676,837,713 124四期联排一、二区联排40103295.8522,6146,690,310 125四期联排一、二区联排40104295.5522,8816,762,356 126四期联排一、二区联排41101335.5918,7256,283,847 127四期联排一、二区联排41102335.5918,7256,283,847 128四期联排一、二区联排41103335.5918,7256,283,847 129四期联排一
23、、二区联排41104335.5918,7256,283,847 130四期联排一、二区联排41105335.5918,7256,283,847 131四期联排一、二区联排41106335.5918,7256,283,847 132四期联排一、二区联排54102297.5624,1567,187,998 133四期联排一、二区联排54103297.6823,3866,961,690 134四期联排一、二区联排54104297.6823,6437,038,092 135四期联排一、二区联排54105297.6823,6437,038,092 136四期联排一、二区联排54106298.1422,9
24、376,838,537 137四期联排一、二区联排54107298.0522,5526,721,727 138四期联排一、二区联排54108297.6822,4886,694,282 139四期联排一、二区联排54109297.6822,4246,675,181 140四期联排一、二区联排54110297.6822,2326,617,879 141四期联排一、二区联排54111296.8922,5526,695,566 142四期联排一、二区联排54112296.2622,9376,795,415 143四期联排一、二区联排54113332.8424,8628,275,161 144四期联排一
25、、二区双拼26101442.1923,50410,393,321 145四期联排一、二区双拼26102442.1925,53111,289,441 146四期联排一、二区双拼27101442.1924,11210,662,281 147四期联排一、二区双拼28102442.1931,20813,800,068 148四期联排一、二区双拼29102442.1932,42814,339,325 149四期叠加三区叠加83102175.512,5432,201,320 150四期叠加三区叠加83103175.512,7282,233,813 151四期叠加三区叠加83105175.513,1062,
26、300,048 152四期叠加三区叠加83301213.311,7742,511,411 153四期叠加三区叠加83302212.7811,9592,544,683 154四期叠加三区叠加83303212.812,1442,584,321 155四期叠加三区叠加83304212.812,3302,623,719 156四期叠加三区叠加83305212.7812,5152,662,867 157四期叠加三区叠加83306213.313,4402,866,830 158四期洋房 56-57213.313,4402,866,830 159四期洋房 71-72213.313,4402,866,830
27、160四期洋房 71栋213.313,4402,866,830 161四期洋房 72栋213.313,4402,866,830 162四期车位四期车位213.313,4402,866,830 163四期洋房 66-7066602170.228,9201,518,369 164四期洋房 66-7066702169.339,0251,528,140 165四期洋房 66-7066902169.339,0871,538,766 166四期洋房 66-70661102169.339,1501,549,392 167四期洋房 66-70661302169.339,2131,560,017 168四期洋房
28、 66-70661402170.229,2441,573,558 169四期洋房 66-70661502169.339,2441,565,330 170四期洋房 66-70661702169.339,3071,575,956 171四期洋房 66-7067302169.338,2741,401,022 172四期洋房 66-7067303155.868,2021,278,414 173四期洋房 66-7067602170.229,0061,533,007 174四期洋房 66-7068602170.229,1181,551,997 175四期洋房 66-7068802170.229,2541,
29、575,141 176四期洋房 66-70681001172.169,2011,584,090 177四期洋房 66-70681402170.229,4421,607,186 178四期洋房 66-7069202170.228,4491,438,210 179四期洋房 66-7069302169.338,6491,464,556 180四期洋房 66-7069602170.228,8491,506,298 181四期洋房 66-70691402170.229,4291,605,025 182四期洋房 66-70691802170.229,2191,569,279 183四期洋房 66-7070
30、201 233.798,5782,005,502 184四期洋房 66-7070202 233.808,2281,923,758 185四期洋房 66-7070203 190.318,5281,623,006 186四期洋房 66-7070301 233.898,9282,088,221 187四期洋房 66-7070302 233.908,3281,947,971 188四期洋房 66-7070303 189.928,8281,676,656 189四期洋房 66-7070402 233.808,3281,947,138 190四期洋房 66-7070502 233.908,4281,971
31、,361 191四期洋房 66-7070503 189.929,1281,733,632 192四期洋房 66-7070601 233.799,9282,321,119 193四期洋房 66-7070602 233.808,5281,993,898 194四期洋房 66-7070603 190.319,3281,775,254 195四期洋房 66-7070702 233.908,5882,008,785 196四期洋房 66-7070803190.319,4081,790,478 197四期洋房 66-7070902233.908,7082,036,853 198四期洋房 66-707010
32、02233.808,7882,054,686 199四期洋房 66-70701402233.809,0282,110,798 200四期洋房 66-70701501233.8910,7282,509,223 201四期洋房 66-70701602233.809,3082,176,262 202四期洋房 66-70701802233.809,3882,194,966 203四期洋房 66-70701803190.3110,2881,957,951 204四期洋房 66-70701902233.9011,0882,593,535 205四期洋房 66-70702002233.8011,2882,6
33、39,186 206四期洋房 66-70702003190.3111,1882,129,230 207四期洋房 66-70702102233.9011,4882,687,095 208四期洋房 66-70702103189.9211,3882,162,851 209四期洋房 66-70702202233.8011,6882,732,706 210四期洋房 66-70702302233.9011,8882,780,655 211四期洋房 66-70702303189.9211,7882,238,819 212四期洋房 66-70702402233.8011,1882,615,806 213四期洋
34、房 66-70702403190.3111,0882,110,199 214四期洋房 58-65213.313,4402,866,830 215四期洋房 58-65213.313,4402,866,830 216四期洋房 58-65213.313,4402,866,830 217四期洋房 58-65213.313,4402,866,830 218四期洋房 58-65213.313,4402,866,830 当前单价当前总价 预计 成效单价 预计 成交总价 实际 折扣比率 实际 折扣金额 备注 9,55556,086,000 16,19867,624,695 11,54820,803,522 1
35、2,639100,916,729 9,947600,000 9,947600,000 9,947600,000 9,947600,000 9,947600,000 9,947600,000 9,947600,000 9,947600,000 9,970600,000 9,947600,000 9,947600,000 9,947600,000 9,947600,000 9,947600,000 9,947600,000 9,947600,000 9,947600,000 9,947600,000 9,947600,000 9,947600,000 9,947600,000 9,970600,0
36、00 9,970600,000 11,054600,000 9,970600,000 18,1355,000,000.00 19,8505,000,000.00 19,8505,000,000.00 18,1355,000,000.00 21,3305,000,000.00 21,8495,000,000.00 21,8495,000,000.00 21,3305,000,000.00 18,1705,000,000.00 19,8265,000,000.00 19,8265,000,000.00 19,8895,000,000.00 21,8955,000,000.00 22,9155,00
37、0,000.00 21,8265,000,000.00 21,8955,000,000.00 19,8895,000,000.00 19,8265,000,000.00 19,8265,000,000.00 19,8895,000,000.00 21,8955,000,000.00 22,9155,000,000.00 21,8265,000,000.00 21,8955,000,000.00 11,8963,000,000.00 11,8963,000,000.00 11,8963,000,000.00 11,8963,000,000.00 11,8963,000,000.00 11,896
38、3,000,000.00 11,8963,000,000.00 11,8963,000,000.00 11,8963,000,000.00 11,8963,000,000.00 11,8963,000,000.00 11,8963,000,000.00 11,8963,000,000.00 11,8963,000,000.00 11,9343,000,000.00 13,7493,000,000.00 13,0963,000,000.00 12,8253,000,000.00 11,9103,000,000.00 11,9103,000,000.00 11,9083,000,000.00 12
39、,7983,000,000.00 13,1093,000,000.00 13,1093,000,000.00 12,7983,000,000.00 13,0963,000,000.00 11,9103,000,000.00 11,9103,000,000.00 12,7983,000,000.00 13,1103,000,000.00 13,1103,000,000.00 12,7983,000,000.00 18,1705,000,000.00 11,9343,000,000.00 11,8963,000,000.00 11,8963,000,000.00 11,9343,000,000.0
40、0 16,3534,500,000.00 19,2384,500,000.00 19,7064,500,000.00 20,6234,500,000.00 19,6444,500,000.00 19,7064,500,000.00 19,2384,500,000.00 13,5804,500,000.00 14,0304,500,000.00 15,3754,500,000.00 24,8838,000,000.00 30,76110,000,000.00 16,8765,000,000.00 23,7768,000,000.00 23,8398,000,000.00 27,1008,000,
41、000.00 23,8398,000,000.00 23,8398,000,000.00 23,8398,000,000.00 23,8398,000,000.00 23,8398,000,000.00 23,8398,000,000.00 23,8398,000,000.00 23,8398,000,000.00 27,1008,000,000.00 27,1008,000,000.00 23,8398,000,000.00 23,8398,000,000.00 23,8398,000,000.00 23,8398,000,000.00 23,8398,000,000.00 27,0908,
42、000,000.00 27,3398,000,000.00 27,0418,000,000.00 27,0688,000,000.00 23,8398,000,000.00 23,8398,000,000.00 23,8398,000,000.00 23,8398,000,000.00 23,8398,000,000.00 23,8398,000,000.00 26,8858,000,000.00 26,8748,000,000.00 26,8748,000,000.00 26,8748,000,000.00 26,8338,000,000.00 26,8418,000,000.00 26,8
43、748,000,000.00 26,8748,000,000.00 26,8748,000,000.00 26,9468,000,000.00 27,0038,000,000.00 24,0368,000,000.00 33,92215,000,000.00 33,92215,000,000.00 33,92215,000,000.00 33,92215,000,000.00 33,92215,000,000.00 17,0943,000,000.00 17,0943,000,000.00 17,0943,000,000.00 14,0653,000,000.00 14,0993,000,00
44、0.00 14,0983,000,000.00 14,0983,000,000.00 14,0993,000,000.00 14,0653,000,000.00 14,0653,000,000.00 14,0653,000,000.00 14,0653,000,000.00 14,0653,000,000.00 14,0653,000,000.00 10,5751,800,000.00 10,6301,800,000.00 10,6301,800,000.00 10,6301,800,000.00 10,6301,800,000.00 10,5751,800,000.00 10,6301,80
45、0,000.00 10,6301,800,000.00 10,6301,800,000.00 11,5491,800,000.00 10,5751,800,000.00 10,5751,800,000.00 10,5751,800,000.00 10,4551,800,000.00 10,5751,800,000.00 10,5751,800,000.00 10,6301,800,000.00 10,5751,800,000.00 10,5751,800,000.00 10,5751,800,000.00 8,5552,000,000.00 8,5542,000,000.00 10,5092,
46、000,000.00 8,5512,000,000.00 8,5512,000,000.00 10,5312,000,000.00 8,5542,000,000.00 8,5512,000,000.00 10,5312,000,000.00 8,5552,000,000.00 8,5542,000,000.00 10,5092,000,000.00 8,5512,000,000.00 10,5092,000,000.00 8,5512,000,000.00 8,5542,000,000.00 8,5542,000,000.00 8,5512,000,000.00 8,5542,000,000.
47、00 8,5542,000,000.00 10,5092,000,000.00 8,5512,000,000.00 8,5542,000,000.00 10,5092,000,000.00 8,5512,000,000.00 10,5312,000,000.00 8,5542,000,000.00 8,5512,000,000.00 10,5312,000,000.00 8,5542,000,000.00 10,5092,000,000.00 14,0653,000,000.00 14,0653,000,000.00 14,0653,000,000.00 14,0653,000,000.00
48、14,0653,000,000.00 未未售售房房源源清清单单 序号项目 项目房源情况12年10月份及之前已售 面积套数均价金额面积套数 1 1三三期期1,380326,000,000 2 2三三期期车车位位1,200200,000,000 3 3三三期期公公寓寓180126,000,000 4 4四四期期 5 556-5756-57128384,000,000 6 658-6558-656801,360,000,000 7 766-7066-70420630,000,000 8 871-7271-7296288,000,000 9 97171栋栋48144,000,000 10107272栋
49、栋48144,000,000 1111三三区区叠叠加加2501,000,000,000 1212四四期期车车位位2,000300,000,000 1313一一、二二区区叠叠加加150600,000,000 1414一一、二二区区联联排排1501,500,000,000 1515一一、二二区区双双拼拼2001,600,000,000 1616一一二二期期 1717一一二二期期车车位位1,500180,000,000 1818一一二二期期楼楼王王72216,000,000 1919一一二二期期商商铺铺160350,000,000 2020( (空空白白) ) ( (空空白白) ) 合合计计1 1, ,3 38 80 03 32 26 6, ,0 00 00 0, ,0 00 00 0 备注： 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.30