汽车4S店销售日报表---2

序号日期合同编号客户销售顾问车型颜色车架号销售指导价销售折让销售价格销售成本厂家返利整车毛利整车毛利率保险收入保险成本保险佣金收入保险毛利保险毛利率15924A3外金内黑276,800.0040000236,800.00232,800.000.004,000.001.45%7264.277264.27858.86858.8611.82%29R3TG4外金内黑171,800.0030800141,000.00141,800.000.00(800.00)-0.47%7000.007000.00824.50824.5011.78%30.00#DIV/0!0.0040.00#DIV/0!0.0050.00#DIV/0!0.0060.00#DIV/0!0.0070.00#DIV/0!0.0080.00#DIV/0!0.0090.00#DIV/0!0.00100.00#DIV/0!0.00110.00#DIV/0!0.00120.00#DIV/0!0.00130.00#DIV/0!0.00140.00#DIV/0!0.00150.00#DIV/0!0.00160.00#DIV/0!0.00170.00#DIV/0!0.00180.00#DIV/0!0.00190.00#DIV/0!0.00200.00#DIV/0!0.00210.00#DIV/0!0.00220.00#DIV/0!0.00230.00#DIV/0!0.00240.00#DIV/0!0.00250.00#DIV/0!0.00448,600.00374,600.003,200.000.71%14,264.2714,264.271,683.3611.80%车型批售任务当月批售（完成）开票任务当月开票（完成）批售达成率开票达成率月毛利任务毛利率任务当月毛利达成率期初未到返利本月已到返利本月新增返利途观515120.00%20.00%10000.000.013200.0032.00%途安515120.00%20.00%桑塔纳20200.00%0.00%月毛利任务毛利率任务当月毛利达成率朗逸50500.00%0.00%50000.001683.363.37%期初库存新入库存已出库存实际库存库存系数凌渡10100.00%0.00%POLO10100.00%0.00%月毛利任务毛利率任务当月毛利达成率新帕萨特10100.00%0.00%70000.00650.000.93%新途安L10100.00%0.00%起初未交订单本月新增订单退单已交付订单未交付订单#DIV/0!#DIV/0!月毛利任务毛利率任务当月毛利达成率合计2122129.52%9.52%40000.000.000.00%月毛利任务当月毛利达成率期初融资金额本期新增融资本期已还金额期末融资金额融资敞口170000.005533.363.25%翔世行汽车销售明细表单位：万元车辆信息合计整车销售保险销售销售台数装潢毛利边际毛利保险毛利整车毛利综合毛利返利到帐情况期末返利库存情况未交车订单融资情况装潢收入装潢成本装潢毛利装潢毛利率上牌收入上牌成本上牌毛利上牌毛利率贷款服务收入贷款佣金收入贷款服务成本贷款毛利贷款毛利率其他服务收入其他服务成本其他毛利其他毛利率毛利合计0.001,150.00(1,150.00)#DIV/0!1,000.00350.00650.0065.00%0.000.000.000.00#DIV/0!1,500.000.001,500.00100.00%5,858.862.38%4,000.002,200.001,800.0045.00%2,000.00350.001,650.0082.50%0.000.000.000.00#DIV/0!0.000.000.00#DIV/0!3,474.502.26%0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!4,000.003,350.00650.0016.25%0.000.000.000.00#DIV/0!1,500.000.001,500.009,333.362.00%翔世行汽车销售明细表单位：万元装潢销售上牌服务贷款服务其他服务综合毛利率备注