度4S店預(yù)算報(bào)表模版(3季度)

,,,,,,三季度售后臺(tái)次及毛利預(yù)算,,,,,,,,,,,,,,,,

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

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

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

,,,臺(tái)數(shù),臺(tái)次,頻次,臺(tái)數(shù),臺(tái)次,頻次,臺(tái)數(shù),臺(tái)次,臺(tái)數(shù),臺(tái)次,臺(tái)數(shù),臺(tái)次,臺(tái)數(shù),臺(tái)次,,,,,,

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

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

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

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

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

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

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

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

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

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

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

,二季度預(yù)算,,,,,2011年預(yù)算（三年度）,,,,,,,,,,,,,,,,

,,,,,,臺(tái)次,收入,,,,,成本,,毛利,,,毛利率,,,單臺(tái)毛利,,

,,,,,,臺(tái)次,工時(shí)收入,,零件收入,,收入合計(jì),維修成本,零件成本,維修毛利,零件毛利,毛利合計(jì),維修毛利率,零件毛利率,總毛利率,單臺(tái)工時(shí)毛利,單臺(tái)零件毛利,單臺(tái)總毛利

,,,,,,,單臺(tái)工時(shí)收入,工時(shí)總收入,單臺(tái)零件收入,零件總收入,,,,,,,,,,,,

,主營,機(jī)修,保養(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

,,,,客戶自費(fèi)保養(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

,,,一般機(jī)修,非保險(xiǎn)公司付費(fèi)的機(jī)修,,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

,,,,保險(xiǎn)公司付費(fèi)的機(jī)修,,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

,,,免費(fèi)機(jī)修,,,648,0.00,-,-,-,-,,-,-,-,-,#DIV/0!,#DIV/0!,#DIV/0!,0,0,0

,,鈑噴,非保險(xiǎn)公司付費(fèi)的鈑噴,,,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

,,,保險(xiǎn)公司付費(fèi)的鈑噴,,,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è)務(wù)小計(jì),,,,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)護(hù)產(chǎn)品,,,,1710,536,"916,560.00",-,,"916,560.00","347,343.30",,"569,216.70",,,62.10%,,,332.8752632,,

,,精品工時(shí),,,,,,-,,,-,,,-,,,#DIV/0!,,,#DIV/0!,,

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

,有償合計(jì),,,,,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

,合計(jì)（含免費(fèi)、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è)務(wù)工時(shí)收入與零件收入占比：,,,,,42.52%,,"2,187,544.41",,"3,302,435.25",,"423,386.09","2,492,925.26",-,-,,,,,,,

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

,工時(shí)、毛利預(yù)計(jì)表填寫,,,,,,,,,,,,,,,,,,,,,

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

,2、按照預(yù)計(jì)出的四個(gè)季度的來廠臺(tái)次，分季度進(jìn)行毛利和毛利率的預(yù)算；,,,,,,,,,,,,,,,,,,,,,

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

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

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

,預(yù)估標(biāo)準(zhǔn)請?zhí)顚懛道A(yù)估表,,,,,,,,,,,,,,,,,,,,,

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

,季度,滿意度返利預(yù)計(jì),,其它考核獎(jiǎng)勵(lì)預(yù)計(jì),,,,,,,,,,,,,,,,,,

,,計(jì)提比例,返利金額,獎(jiǎng)勵(lì)名稱,獎(jiǎng)勵(lì)金額,,,,,,,,,,,,,,,,,

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

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

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

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

,全年合計(jì),,0,,0,,,,,,,,,,,,,,,,,

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

,一季度預(yù)算,,,,,2010年預(yù)算（三年度）,,,,,,,,,,,,,,,,

,,,,,,臺(tái)次,收入,,,,,成本,,毛利,,,毛利率,,,單臺(tái)毛利,,

,,,,,,臺(tái)次,工時(shí)收入,,零件收入,,收入合計(jì),維修成本,零件成本,維修毛利,零件毛利,毛利合計(jì),維修毛利率,零件毛利率,總毛利率,單臺(tái)工時(shí)毛利,單臺(tái)零件毛利,單臺(tái)總毛利

,,,,,,,單臺(tái)工時(shí)收入,工時(shí)總收入,單臺(tái)零件收入,零件總收入,,,,,,,,,,,,

,主營,機(jī)修,保養(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!

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

,,,一般機(jī)修,非保險(xiǎn)公司付費(fèi)的機(jī)修,,,,-,,-,-,,-,-,-,-,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,,,保險(xiǎn)公司付費(fèi)的機(jī)修,,,,-,,-,-,,-,-,-,-,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,,免費(fèi)機(jī)修,,,,,-,,-,-,,-,-,-,-,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,鈑噴,非保險(xiǎn)公司付費(fèi)的鈑噴,,,,,-,,-,-,,-,-,-,-,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,,保險(xiǎn)公司付費(fèi)的鈑噴,,,,,-,,-,-,,-,-,-,-,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

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