Excel表格模板:预算表企业KPI预算表&损益表.xlsx
2018年KPI预算表业务KPI项目升降趋势1月2月3月4月日活数1000000105000011325001227625流水11500000115750001170375011836438微博粉丝数100000125000140250153088公众号粉丝数200080001020011500收入升降趋势零售收入 2,070,000 2,083,500 2,106,675 2,130,559会员收入 1,150,000 1,157,500 1,170,375 1,183,644定制收入 1,380,000 1,389,000 1,404,450 1,420,373广告收入 6,900,000 6,945,000 7,022,250 7,101,863总收入11,500,000 11,575,000 11,703,750 11,836,438销售成本渠道成本57,50057,87558,51959,182分成成本 5,750,000 5,787,500 5,851,875 5,918,219券成本23,00057,87523,40823,673礼品成本20,00030,00020,00020,000增值税690,000694,500702,225710,186总成本 6,540,500 6,627,750 6,656,026 6,731,260总利润 4,959,500 4,947,250 5,047,724 5,105,1775月6月7月8月9月10月11月1355060128281215004961607100167745520513281758895123532591201442212100143121806511226618312606992123933421809012011362313062660023059023727884045562362530088407815417263258100887125330 2,223,587 2,162,596 2,178,026 2,192,517 2,207,9132,269,2592,230,802 1,235,326 1,201,442 1,210,014 1,218,065 1,226,6181,260,6991,239,334 1,482,391 1,441,731 1,452,017 1,461,678 1,471,9421,512,8391,487,201 7,411,956 7,208,653 7,260,086 7,308,390 7,359,7107,564,1957,436,00512,353,259 12,014,422 12,100,143 12,180,651 12,266,183 12,606,99212,393,34261,76660,07260,50160,90361,33163,03561,967 6,176,630 6,007,211 6,050,072 6,090,325 6,133,0926,303,4966,196,671123,53324,02924,20024,36124,532126,07024,78730,00020,00020,00020,00020,00030,00020,000741,196720,865726,009730,839735,971756,420743,601 7,133,124 6,832,177 6,880,781 6,926,429 6,974,9267,279,0217,047,025 5,220,135 5,182,245 5,219,362 5,254,222 5,291,2575,327,9725,346,317在此写下公司名称12月总计2000339176436111258550914511569046523929461671529956228352,265,39226,120,8241,258,55114,511,5691,510,26117,413,8837,551,30587,069,41412,585,509145,115,69062,928725,5786,292,75572,557,84525,171524,63820,000270,000755,1318,706,9417,155,98482,785,0035,429,52562,330,687