单店盈利模型1(1)

单店盈利模型科目条件扣点店扣点店扣点店扣点店123456789101112TAL平均月销售2011年2012年2013年89101112123456789101112TAL平均月销售2012年2013年2014年预估销售额元100,000110,00070,00075,00080,00060,00070,00050,00060,00080,000100,00090,000945,00078,7501,228,5001,474,2001,621,62080,00090,000100,00090,00090,000100,000100,00080,000100,000100,000100,000100,000100,000100,000120,000100,000100,0001,200,00090,000450,0001,200,0001,440,000销售成本72,61585,46540,76351,15941,55035,11453,24839,63433,56852,21670,62268,290644,24442,750666,900800,280880,30847,05950,00055,55650,00052,94155,55655,55647,05958,82455,55655,55658,82462,50055,55666,66758,82455,556686,02951,136255,682674,157800,000项目单价总价格公司承担比例公司承担分公司承担比例分公司承担客户承担比例客户承担金额销售折扣60%50%65%70%75%70%65%65%70%70%75%70%70%70%70%70%70%85%90%90%90%85%90%90%85%85%90%90%85%80%90%90%85%90%89%88%88%89%90%供货折扣44%39%38%48%39%41%49%52%39%46%53%53%48%38%38%38%38%50%50%50%50%50%50%50%50%50%50%50%50%50%50%50%50%50%50%50%50%50%50%销售毛利8165374009.74003645822.341768.422,48325,50519,61221,86537,99659,09957,747527,59636,000561,600673,920741,31232,94140,00044,44440,00037,05944,44444,44432,94141,17644,44444,44441,17637,50044,44453,33341,17644,444513,97138,864194,318525,843640,000家具1200180000100%1800000%00%0销售毛利率46%46%46%46%43%43%44%44%灯具25037500100%375000%00%0地板15022500100%225000%00%0经营费用装修500750000%00%0100%75000商场扣率35%35%35%35%35%35%35%35%35%35%35%35%35%32%32%32%32%合计21002730002400000%075000商场扣额35,00038,50024,50026,25028,00021,00024,50017,50021,00028,00035,00031,500330,75025,200393,120471,744518,918月分摊003125店铺面积平方1508383838383838383838383838383838383150150150150150150150150150150150150150150150150150150150150150店铺租金平方/天/元2.72.72.72.72.72.72.72.72.72.72.72.72.72.72.72.72.72.72.72.72.72.7合计35,00038,50024,50026,25028,00021,00024,50017,50021,00028,00035,00031,500330,75025,200393,120471,744518,91812,50012,50012,50012,50012,50012,50012,50012,50012,50012,50012,50012,50012,50012,50012,50012,50012,50012,50012,50012,50012,50012,500店铺费用工资社保销售额10%12,04717,05011,83712,46212,0247,92214,59314,59313,7757,74212,32225,130161,49713,458169,572186,529205,18210,40010,40010,40010,40010,40010,40010,40010,40010,40010,40010,40010,40010,40010,40010,40010,40010,400124,80010,40040,000124,800149,760水电费销售额1,9815,8771,9881,7281,9551,0001,0001,3122,8883,970856024,5562,04628,23932,47537,3461,4001,4001,4001,4001,4001,4001,4001,4001,4001,4001,4001,4001,4001,4001,4001,4001,40016,8001,4007,00016,80020,160货架与装修按右表1,0991,0991,0991,0991,0991,1003,9113,9113,9113,9113,911-3,82922,3210003,1253,1253,1253,1253,1253,1253,1253,1253,1253,1253,1253,1253,1253,1253,1253,1253,12537,5003,12515,62537,50021,875修理费销售额2,1033,2112,6562,6882,0375,8073,279(213)8672,7741,1812,00228,3922,36631,23234,35537,7901001001001001001001001001001001001001001001001001001,2001005001,2001,440工服费7007007007007002,1001171,4002,1002,520包装费00000通讯费3003003003003003003003003003003003003003003003003003,6003001,5003,6003,600物业费00000清洁费00000办公费00000运费3005007004009003007006007005,1001809005,1006,120宣促费1001001001001001001001001001001001001001001001001001,2001005001,2001,440奖金销售额1%80090010009009001000100080010001000100010001000100012001000100011,3009004,50011,30013,560其他日常费用3003003003003003003003003003003003003003003003003003,6003005001,2001,200营业税金附加定额税/月1.0%15001000100010001000100010001000100010001000100012,5001,04212,28514,74216,2164004004004004004004004004004004004004004004004004004,8004002,0004,8005,760合计18,912241,327268,100296,53417,92517,52517,82517,02518,12518,02517,42516,92518,52517,12517,12517,12517,82517,72518,02517,12517,825210,70017,32274,425209,600227,435费用合计44,112634,447739,844815,45230,42530,02530,32529,52530,62530,52529,92529,42531,02529,62529,62529,62530,32530,22530,52529,62530,325223,20029,82286,925222,100239,935营业利润-8,112-72,847-65,924-74,1402,5169,97514,11910,4756,43413,91914,5193,51610,15114,81914,81911,5517,17514,21922,80811,55114,119290,7719,042107,393303,743400,065利润率-10%-6%-4%-5%10%24%25%28%分公司道具支持金额000000000000000000000分公司利润210332112656268820375806.553278.86-212.5577339005867.14490036332774.24283353721181.042002.048,550133,380160,056176,0629,41210,00011,11110,00010,58811,11111,1119,41211,76511,11111,11111,76512,50011,11113,33311,76511,111137,20610,22751,136134,831160,000