度4S店預算報表模版(3季度)

,,,,,,三季度售后臺次及毛利預算,,,,,,,,,,,,,,,,

,編制單位：,長春市嘉輝商貿(mào)有限公司,,,,,,,,,,,,,,,,,,,,

,因子,,歷史數(shù)據(jù),,,2011年預算,,,,,,,,,,,,,,,,

,,,10年,,,11年,,,一季度,,二季度,,三季度,,四季度,,,,,,,

,,,臺數(shù),臺次,頻次,臺數(shù),臺次,頻次,臺數(shù),臺次,臺數(shù),臺次,臺數(shù),臺次,臺數(shù),臺次,,,,,,

,基盤客戶數(shù),,,,,,,,,,,,,,,,,,,,,

,新增客戶數(shù),,,,,,,,,,,,,,,,,,,,,

,新車投保數(shù),,,,,,,,,,,,,,,,,,,,,

,在?？蛻魯?shù),,,,,,,,,,,,,,,,,,,,,

,流失客戶數(shù),,,,,,,,,,,,,,,,,,,,,

,說明：,,,,,,,,,,,,,,,,,,,,,

,1、11年預算入廠總臺數(shù)=10年基盤客戶數(shù)-11年預算流失客戶數(shù)+10年新增客戶數(shù)；（此數(shù)據(jù)為-機電入廠臺數(shù)）,,,,,,,,,,,,,,,,,,,,,

,2、11年預算入廠臺次=（10年基盤客戶數(shù)-11年預算流失客戶數(shù)）*回廠頻次+10年新增客戶數(shù)*回廠頻次+在保客戶數(shù)*鈑噴回廠頻次；（11年新車銷售數(shù)為首保入廠臺數(shù)-臺次）,,,,,,,,,,,,,,,,,,,,,

,3、11年機電維修入廠臺次=（10年基盤客戶數(shù)-11年預算流失客戶數(shù)）*回廠頻次+10年新增客戶數(shù)*回廠頻次；,,,,,,,,,,,,,,,,,,,,,

,4、11年鈑噴入廠臺次=在保客戶數(shù)*回廠頻次；（在?？蛻魯?shù)為-鈑噴入廠臺數(shù)）,,,,,,,,,,,,,,,,,,,,,

,5、通過對基盤客戶的數(shù)量、流失、增長的分析以及歷史入場臺次的分析數(shù)據(jù)，對11年的入場臺數(shù)、臺次進行預算。并分配到四個季度。,,,,,,,,,,,,,,,,,,,,,

,二季度預算,,,,,2011年預算（三年度）,,,,,,,,,,,,,,,,

,,,,,,臺次,收入,,,,,成本,,毛利,,,毛利率,,,單臺毛利,,

,,,,,,臺次,工時收入,,零件收入,,收入合計,維修成本,零件成本,維修毛利,零件毛利,毛利合計,維修毛利率,零件毛利率,總毛利率,單臺工時毛利,單臺零件毛利,單臺總毛利

,,,,,,,單臺工時收入,工時總收入,單臺零件收入,零件總收入,,,,,,,,,,,,

,主營,機修,保養(yǎng),索賠,首保,150,68,"10,192.25",186.48,"27,971.65","38,163.90",,"22,377.32","10,192.25","5,594.33","15,786.58",100.00%,20.00%,41.37%,67.94836147,37.29553128,105.2438928

,,,,,二保,0,0,-,-,-,-,,-,-,-,-,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,,,,PDI,0,,-,-,-,-,,-,-,-,-,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,,,,保修,432,123,"53,015.44",810.00,"349,920.00","402,935.44",,"279,936.00","53,015.44","69,984.00","122,999.44",100.00%,20.00%,30.53%,122.7209302,162,284.7209302

,,,,客戶自費保養(yǎng),,2850,111,"315,701.82",514.64,"1,466,733.60","1,782,435.42","6,670.72","1,047,666.86","309,031.10","419,066.74","728,097.84",97.89%,28.57%,40.85%,108.4319657,147.0409622,255.4729279

,,,一般機修,非保險公司付費的機修,,1233,353,"435,249.00",768.00,"946,944.00","1,382,193.00","7,756.98","676,388.57","427,492.02","270,555.43","698,047.45",98.22%,28.57%,50.50%,346.7088564,219.4285714,566.1374279

,,,,保險公司付費的機修,,185,487,"90,028.45","1,058.00","195,730.00","285,758.45","3,270.22","139,807.14","86,758.23","55,922.86","142,681.08",96.37%,28.57%,49.93%,468.9633836,302.2857143,771.2490979

,,,免費機修,,,648,0.00,-,-,-,-,,-,-,-,-,#DIV/0!,#DIV/0!,#DIV/0!,0,0,0

,,鈑噴,非保險公司付費的鈑噴,,,410,820,"336,200.00",785.00,"321,850.00","658,050.00","41,774.90","257,480.00","294,425.10","64,370.00","358,795.10",87.57%,20.00%,54.52%,718.11,157,875.11

,,,保險公司付費的鈑噴,,,516,780,"402,480.00","1,075.00","554,700.00","957,180.00","88,545.60","493,066.67","313,934.40","61,633.33","375,567.73",78.00%,11.11%,39.24%,608.4,119.4444444,727.8444444

,,主營業(yè)務小計,,,,6424,256,"1,642,866.96",601.47,"3,863,849.25","5,506,716.21","148,018.42","2,916,722.56","1,494,848.54","947,126.69","2,441,975.24",90.99%,24.51%,44.35%,232.6974695,147.4356617,380.1331313

,非主營,養(yǎng)護產(chǎn)品,,,,1710,536,"916,560.00",-,,"916,560.00","347,343.30",,"569,216.70",,,62.10%,,,332.8752632,,

,,精品工時,,,,,,-,,,-,,,-,,,#DIV/0!,,,#DIV/0!,,

,,非主營業(yè)務小計,,,,1710,,916560,,,"916,560.00","347,343.30",,"569,216.70",,,62.10%,,,332.8752632,,

,有償合計,,,,,5776,443.11,"2,559,426.96",668.95,"3,863,849.25","6,423,276.21","495,361.72","2,916,722.56","2,064,065.24","947,126.69","3,011,191.94",80.65%,24.51%,46.88%,357.35,163.98,521.33

,合計（含免費、PDI-PDS）,,,,,6424,398.42,"2,559,426.96",601.47,"3,863,849.25","6,423,276.21","495,361.72","2,916,722.56","2,064,065.24","947,126.69","3,011,191.94",80.65%,24.51%,46.88%,321.31,147.44,468.74

,1.主營業(yè)務工時收入與零件收入占比：,,,,,42.52%,,"2,187,544.41",,"3,302,435.25",,"423,386.09","2,492,925.26",-,-,,,,,,,

,2.非主營業(yè)務收入與主營業(yè)務收入占比,,,,,16.64%,,,,,,,,,,,,,,,,

,工時、毛利預計表填寫,,,,,,,,,,,,,,,,,,,,,

,1、業(yè)務分類：按照單據(jù)進行分類，分為鈑噴和機修，機修分為保養(yǎng)和一般維修；,,,,,,,,,,,,,,,,,,,,,

,2、按照預計出的四個季度的來廠臺次，分季度進行毛利和毛利率的預算；,,,,,,,,,,,,,,,,,,,,,

,3、黃色部分為10年的歷史數(shù)據(jù)，以該數(shù)據(jù)為預測基礎，對11年的數(shù)據(jù)進行預算；,,,,,,,,,,,,,,,,,,,,,

,4、所有標有“-”/有顏色的格子，不用填寫。,,,,,,,,,,,,,,,,,,,,,

,5、養(yǎng)護產(chǎn)品填寫中，在工時成本折扣率列填寫?zhàn)B護成品平均成本率。,,,,,,,,,,,,,,,,,,,,,

,預估標準請?zhí)顚懛道A估表,,,,,,,,,,,,,,,,,,,,,

,返利分為客戶滿意度（CSI）返利，及售后其它考核返利，請大家根據(jù)以往實際進行填寫；如果返利基數(shù)是整車提車額，則該數(shù)據(jù)需要問銷售經(jīng)理要明年各季度的整車提車額,,,,,,,,,,,,,,,,,,,,,

,季度,滿意度返利預計,,其它考核獎勵預計,,,,,,,,,,,,,,,,,,

,,計提比例,返利金額,獎勵名稱,獎勵金額,,,,,,,,,,,,,,,,,

,一季度,,,,,,,,,,,,,,,,,,,,,

,二季度,,,,,,,,,,,,,,,,,,,,,

,三季度,,,,,,,,,,,,,,,,,,,,,

,四季度,,,,,,,,,,,,,,,,,,,,,

,全年合計,,0,,0,,,,,,,,,,,,,,,,,

,歷史數(shù)據(jù),一季度,,,,,,,,,,,,,,,,,,,,

,一季度預算,,,,,2010年預算（三年度）,,,,,,,,,,,,,,,,

,,,,,,臺次,收入,,,,,成本,,毛利,,,毛利率,,,單臺毛利,,

,,,,,,臺次,工時收入,,零件收入,,收入合計,維修成本,零件成本,維修毛利,零件毛利,毛利合計,維修毛利率,零件毛利率,總毛利率,單臺工時毛利,單臺零件毛利,單臺總毛利

,,,,,,,單臺工時收入,工時總收入,單臺零件收入,零件總收入,,,,,,,,,,,,

,主營,機修,保養(yǎng),索賠,首保,,,-,,-,-,,-,-,-,-,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,,,,二保,,,-,,-,-,,-,-,-,-,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,,,,PDI,,,-,,-,-,,-,-,-,-,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,,,,保修,,,-,,-,-,,-,-,-,-,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,,,客戶自費保養(yǎng),,,,-,,-,-,,-,-,-,-,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,,一般機修,非保險公司付費的機修,,,,-,,-,-,,-,-,-,-,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,,,保險公司付費的機修,,,,-,,-,-,,-,-,-,-,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,,免費機修,,,,,-,,-,-,,-,-,-,-,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,鈑噴,非保險公司付費的鈑噴,,,,,-,,-,-,,-,-,-,-,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,,保險公司付費的鈑噴,,,,,-,,-,-,,-,-,-,-,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,主營業(yè)務小計,,,,0,#DIV/0!,-,