NFSQ Forecast by Year模板.xls

NFSQ Forecast by Year ItemUnit-AnalysisAnalysisPurchasing price(excluding VAT)Ex-factory Price(excluding VAT)-EncouragementProfit Of good sold-Sales FeeKAExclude VATExclude VATDiscount*%#VALUE!#VALUE!Coverage Service Fee#DIV/0!Overdue product0.02%-Brand development Funding#DIV/0!Subtotal#VALUE!#VALUE!Gross Profit#VALUE!#VALUE!CSF+BDF-营运费用仓租元/平方米/月客户运费元/月商品残损储运残损%#VALUE!样品残损%#VALUE!财务成本资金成本率(利息)%(年息)-保险费每月存货货值 X%X%-邮寄费(EMS)RMBrmb/份(市内)坏帐准备%(以销售额为计算标准)-税金 VAT附加税(增值税销项税-增值税进项税)X%防洪费销售收入*-印花税(销售收入+进货成本)X%-Subtotal#VALUE!-Other IncomeNet Profit#VALUE!#VALUE!Net Profit%#VALUE!#VALUE!注：打*号为根据销售额计算，不打*号为根据进货额计算。营运费用根据物流部门运作经验，同时根据实际各产品占用库存面积,运费金额计算折扣尚需根据实际情况调整。CSF用于DSR/TSM工资奖金,通讯,交通,社会保险等费用支出BDF用于商店的价格折让促销,促销员工资奖金，