Docstoc

Acura Statistical Data Sheet

Document Sample
Acura Statistical Data Sheet Powered By Docstoc
					                           2008 ACURA STATISTICAL DATA
Page 1                                                             Page 1
         BALANCE SHEET-MEMO UNIT COUNT                                      MONTHLY UNIT SALES SECTION
                                             Memo                                                        Memo
Ln    Description                            Acct#      UNITS      Ln   Description                      Acct#     UNITS
15 DEMOS-CARS-ACURA                           $_________ 50 Jan
                                             150A                             NEW     UNITS SOLD-ACURA   125     #_________
16 DEMOS-CARS-OTHER                           $_________ 51 Feb
                                             150B                             NEW     UNITS SOLD-ACURA   125A    #_________
                                                         52 March             NEW     UNITS SOLD-ACURA   125B    #_________
17 TOTAL CAR UNITS                      150E $_________ 53 April              NEW     UNITS SOLD-ACURA   125C    #_________
17 TAXES PAYABLE-INCOME (PRIOR YEAR) 153      $_________ 54 May               NEW     UNITS SOLD-ACURA   125D    #_________
18 TOTAL SUV UNITS                      150F $_________ 55 June               NEW     UNITS SOLD-ACURA   125E    #_________
20 NEW CARS-OTHER                       150Z $_________ 56 July               NEW     UNITS SOLD-ACURA   125F    #_________
                                                         57 Aug               NEW     UNITS SOLD-ACURA   125G    #_________
23 USED ACURA NON-CERTIFIED             151   #_________ 58 Sep               NEW     UNITS SOLD-ACURA   125H    #_________
23 USED ACURA CERTIFIED                 151F #_________ 59 Oct                NEW     UNITS SOLD-ACURA   125Z    #_________
24 MEMO: 30 + DAYS ACURA                151A #_________ 60 Nov                NEW     UNITS SOLD-ACURA   126     #_________
24 MEMO:30 + DAYS-$ AMT ACURA           151B $_________ 61 Dec                NEW     UNITS SOLD-ACURA   126A    #_________
25 USED OTHER THAN ACURA                151C #_________
26 MEMO:30 + DAYS USED OTHER            152A #_________ 50 Jan                NEW     UNITS SOLD-OTHER   127     #_________
26 MEMO:30 + DAYS-$ AMT OTHER           152B $_________ 51 Feb                NEW     UNITS SOLD-OTHER   127A    #_________
                                                         52 March             NEW     UNITS SOLD-OTHER   127B    #_________
46 LEASE & RENTAL VEHICLES              151G #_________ 53 April              NEW     UNITS SOLD-OTHER   127C    #_________
                                                         54 May               NEW     UNITS SOLD-OTHER   127D    #_________
28 ACURA PARTS-CORES                    151H $_________ 55 June               NEW     UNITS SOLD-OTHER   127E    #_________
28 ACURA PARTS-OBSOLESCENCE             151D $_________ 56 July               NEW     UNITS SOLD-OTHER   127F    #_________
29 ACURA ACCESS.-OBSOLESCENCE           151E $_________ 57 Aug                NEW     UNITS SOLD-OTHER   127G    #_________
                                                         58 Sep               NEW     UNITS SOLD-OTHER   127H    #_________
                                                         59 Oct               NEW     UNITS SOLD-OTHER   127Z    #_________
Page 1                                                   60 Nov               NEW     UNITS SOLD-OTHER   128     #_________
          BALANCE SHEET-MEMO DOLLAR INFORMATION          61 Dec               NEW     UNITS SOLD-OTHER   128A    #_________
                                             Memo
Ln    Description                            Acct#      AMOUNT   50 Jan       USED UNITS SOLD-RTL        123     #_________
36 NET WORKING CAPITAL REQD                  153A     $_________ 51 Feb       USED UNITS SOLD-RTL        123A    #_________
36 EFF NET WORTH REQD                        153B     $_________ 52 March     USED UNITS SOLD-RTL        123B    #_________
                                                                 53 April     USED UNITS SOLD-RTL        123C    #_________
                                                                 54 May       USED UNITS SOLD-RTL        123D    #_________
Page 1                                                           55 June      USED UNITS SOLD-RTL        123E    #_________
                 NET WORTH SECTION OF BALANCE SHEET              56 July      USED UNITS SOLD-RTL        123F    #_________
                                             Memo                57 Aug       USED UNITS SOLD-RTL        123G    #_________
Ln Description                               Acct#      AMOUNT   58 Sep       USED UNITS SOLD-RTL        123H    #_________
50   Jan               Profit or Loss        101      $_________ 59 Oct       USED UNITS SOLD-RTL        123Z    #_________
51   Feb               Profit or Loss        102      $_________ 60 Nov       USED UNITS SOLD-RTL        124     #_________
52   March             Profit or Loss        103      $_________ 61 Dec       USED UNITS SOLD-RTL        124A    #_________
53   April             Profit or Loss        104      $_________
54   May               Profit or Loss        105      $_________ 50 Jan       USED UNITS SOLD-WHL        129     #_________
55   June              Profit or Loss        106      $_________ 51 Feb       USED UNITS SOLD-WHL        129A    #_________
56   July              Profit or Loss        107      $_________ 52 March     USED UNITS SOLD-WHL        129B    #_________
57   Aug               Profit or Loss        108      $_________ 53 April     USED UNITS SOLD-WHL        129C    #_________
58   Sep               Profit or Loss        109      $_________ 54 May       USED UNITS SOLD-WHL        129D    #_________
59   Oct               Profit or Loss        110      $_________ 55 June      USED UNITS SOLD-WHL        129E    #_________
60   Nov               Profit or Loss        111      $_________ 56 July      USED UNITS SOLD-WHL        129F    #_________
61   Dec               Profit or Loss        112      $_________ 57 Aug       USED UNITS SOLD-WHL        129G    #_________
                                                                 58 Sep       USED UNITS SOLD-WHL        129H    #_________
                                                                 59 Oct       USED UNITS SOLD-WHL        129Z    #_________
                                                                 60 Nov       USED UNITS SOLD-WHL        137     #_________
                                                                 61 Dec       USED UNITS SOLD-WHL        137A    #_________




acstat.xls                                                Page 1 of 3                                              4/12/2010
                            2008 ACURA STATISTICAL DATA
Page 1                                                                Page 2
                    RECEIVABLES ANALYSIS SECTION                                               PERSONNEL SECTION
                                                 Memo                              Enter count at the beginning of the accounting year.
Ln Description                                   Acct#    AMOUNT               Adjustments to count, enter only net change to YTD memos.
71   210       VEHICLE-31-60                     140B    $_________                                 Memo
71   210       VEHICLE-61-90                     140C    $_________ Ln Description                  Acct#                            UNITS
71   210       VEHICLE-OVER 90                   140D    $_________ 71 OWNERS-NEW VEH. DEPT. ACURA  114A                        #_________
71   210       VEHICLE DOUBTFUL ACCT             140E    $_________ 71 OWNERS-NEW VEH. DEPT. OTHER  114B                        #_________
                                                                    71 OWNERS-USED VEHICLE DEPT. 114C                           #_________
72   220       SERV.,PARTS,BS-31-60              141B    $_________ 71 OWNERS-SERVICE DEPT.         114D                        #_________
72   220       SERV.,PARTS,BS-61-90              141C    $_________ 71 OWNERS-BODY SHOP DEPT.       114E                        #_________
72   220       SERV.,PARTS,BS-OVER 90            141D    $_________ 71 OWNERS-PARTS&ACCESS DEPT.114F                            #_________
72   220       SERV.,PARTS,BS DOUBT ACCT         141E    $_________
                                                                    72 SUPER.-NEW VEH. DEPT ACURA 115A                          #_________
73   221/222   OTHER FACTORY REC.-31-60          143B    $_________ 72 SUPER.-NEW VEH. DEPT OTHER 115B                          #_________
73   221/222   OTHER FACTORY REC.-61-90          143C    $_________ 72 SUPERVISORS-USED VEH. DEPT 115C                          #_________
73   221/222   OTHER FAC REC.-OVER 90            143D    $_________ 72 SUPERVISORS-SERVICE DEPT. 115D                           #_________
73   221/222 OTHER FACTORY REC.-DOUBT            143E    $_________ 72 SUPERVISORS-BODY SHOP DEPT.  115E                        #_________
                                                                    72 SUPERVISORS-P&A DEPT.        115F                        #_________
74   223/224   WARR. REC.-31-60                  142B    $_________
74   223/224   WARR. REC.-61-90                  142C    $_________ 73 SLSPERS/SER. ADV.-NEW ACURA  116A                        #_________
74   223/224   WARR. REC.-OVER 90                142D    $_________ 73 SLSPERS/SER. ADV.-NEW OTHER  116B                        #_________
74   223/224 WARR. REC. DOUBTFUL ACCT            142E    $_________ 73 SLSPERS/SER. ADV. -USED VEH. 116C                        #_________
                                                                                                    1
                                                                    73 SLSPERS/SER. ADV -SERV. DEPT. 16D                        #_________
75   226/227   HOLDBACK-31-60                    144B    $_________ 73 SLSPERS/SER. ADV -BODY SHOP116E                          #_________
75   226/227   HOLDBACK-61-90                    144C    $_________ 73 SLSPERS/SER. ADV -P&A DEP    116F                        #_________
75   226/227   HOLDBACK-OVER 90                  144D    $_________
75   226/227   HOLDBACK DOUBTFUL ACCT            144E    $_________ 74 TECHNICIANS-SERVICE DEPT. 117D                           #_________
                                                                    74 TECHNICIANS-BODY SHOP DEPT.117E                          #_________

Page 3                                                       75            CLERICAL-NEW VEH DEP-ACURA118A                       #_________
                    HOURLY LABOR RATES CHARGED               75            CLERICAL-NEW VEH DEP-OTHER118B                       #_________
                 ENTER HHHMM (H=HOURS, M=MINUTES)            75            CLERICAL-USED VEHICLE DEPT 118C                      #_________
                                            Memo             75            CLERICAL-SERVICE DEPT.     118D                      #_________
Ln   Description                            Acct#   AMOUNT   75            CLERICAL-BODY SHOP DEPT.   118E                      #_________
7           CUSTOMER MECH                    175A $_________ 75            CLERICAL-PARTS&ACCESS DEPT 118F                      #_________
8           CUSTOMER BODY                    175B $_________
7           WARRANTY MECH.                   176A $_________ 76            OTHER-NEW VEH DEPT-ACURA                   119A      #_________
8           WARRANTY BODY                    176B $_________ 76            OTHER-NEW VEH DEPT-OTHER                   119B      #_________
7           INTERNAL MECH.                   177A $_________ 76            OTHER-USED VEHICLE DEPT.                   119C      #_________
8           INTERNAL BODY                    177B $_________ 76            OTHER-SERVICE DEPT                         119D      #_________
                 ACTUAL EFFECTIVE CUST LABOR RATE            76            OTHER-BODY SHOP DEPT.                      119E      #_________
                                                             76            OTHER-PARTS&ACCESS DEPT.                   119F      #_________
7           (780) MECH                       180  $_________
8           (781) BODY                       181  $_________ 78            HIRED YTD-NEW VEH DEP-ACURA 121A                     #_________
                       ACCELERATED SERVICE                   78            HIRED YTD-NEW VEH DEP-OTHER 121B                     #_________
                                                             78            HIRED YTD-USED VEHICLE DEPT.121C                     #_________
11 (783) TTL ACCELERATED SVC & PARTS EXP.    183  $_________ 78            HIRED YTD-SERVICE DEPT.     121D                     #_________
                  TOTAL WEEKLY OPERATING HOURS               78            HIRED YTD-BODY SHOP DEPT. 121E                       #_________
                ENTER DDDCC (D=DOLLAR, C=CENTS)              78                                        1
                                                                           HIRED YTD-PARTS&ACCESS DEPT21F                       #_________

5              SERVICE                           145                                             122A
                                                         #_________ 79 TERM. YTD-NEW VEH DEP-ACURA                              #_________
5              BODY                              145A                                            122B
                                                         #_________ 79 TERM. YTD-NEW VEH DEP-OTHER                              #_________
                            P&A DEPARTMENT                          79 TERM. YTD-USED VEH. DEP   122C                           #_________
                                                                    79 TERM. YTD-SERVICE DEPT.   122D                           #_________
19 LOST SALES                                    178     $_________ 79 TERM. YTD-BODY SHOP DEPT. 122E                           #_________
22 EMERGENCY PURCHASES                           179     $_________ 79 TERM. YTD-P&A DEPT.       122F                           #_________
                         FLOOR PLAN ASSISTANCE


17 ACURA                                         197     $_________
20 OTHER                                         198     $_________


acstat.xls                                                   Page 2 of 3                                                            4/12/2010
                             2008 ACURA STATISTICAL DATA
Page 4                                                               Page 3
               NEW VEHICLE DEPT.-UNIT SALES                                             FINANCE AND INSURANCE RECAP
                       Current Month Memo                                                     Current Month Memo
                                                Memo                                                                   Memo
Ln    Description                               Acct#      UNITS     Ln   Description                                  Acct#             UNITS
1    (403) NEW CARS-RTL-TL                      130C    #_________   70         LEASES NEW-#                           165       #_________
2    (405) NEW CARS-RTL-RL                      130E    #_________   70         LEASES NEW-%                           166       %_________
3    (411) NEW CARS-RTL-MDX                     130J    #_________
4    (412) NEW CARS-RTL-TSX                     130K    #_________   71         LEASES USED-#                          165A      #_________
5    (413) NEW CARS-RTL-RDX                     130D    #_________   71         LEASES USED-%                          166A      %_________
18   (410) ACURA-FLEET                          130G    #_________
                                                                   70           FIN CTR NEW-#                          167       #_________
22 (420) NEW CARS-OTHER MAKES                   131     #_________ 70           FIN CTR NEW-%                          168       %_________

                                                                     71         FIN CTR USED-#                         167A      #_________
Page 4                                                               71         FIN CTR USED-%                         168A      %_________
               USED VEHICLE DEPT-UNIT SALES
                       Current Month Memo                            70         GAP INS NEW-#                          173       #_________
                                                Memo                 70         GAP INS NEW-%                          174       %_________
Ln    Description                               Acct#      UNITS
24   (440) ACURA CERTIFIED PREOWNED RTL     133         #_________ 71           GAP INS USED-#                         173A      #_________
26   (444) ACURA NON-CERTIFIED PRE-OWNED RTL133C        #_________ 71           GAP INS USED-%                         174A      %_________
28   (445) USED VEHICLES-RTL-OTHER          133B        #_________
31   (442) USED VEHICLES-WHOLESALE 133A                 #_________ 70           ACURA CARE CTR NEW-# 169                         #_________
                                                                   70           ACURA CARE CTR NEW-% 170                         %_________

Page 4                                                               71         ACURA CARE USED-#                      169A      #_________
                    SERVICE DEPT-UNIT SALES                          71         ACURA CARE USED-%                      170A      %_________
                       Current Month Memo
                                                Memo                 70         OTHER SVC CTR NEW-# 171                          #_________
Ln    Description                               Acct#      UNITS     70         OTHER SVC CTR NEW-% 172                          %_________
35   (450) MECH LABOR-CUST.-ACURA               135     #_________
36   (458) ACCELERATED SVC LABOR                135H    #_________ 71           OTHER SVC CTR USED-# 171A                        #_________
37   (452) MECH LAB-WARR-ACURA                  135B    #_________ 71           OTHER SVC CTR USED-% 172A                        %_________
38   (454) MECH. LABOR-INT. ACURA               135D    #_________
39   (455) INT LABOR ACCESSORIES                135E    #_________
41   (451) OTHER SERVICE LABOR                  135A    #_________ Page 4
                                                                                PARTS & ACCESS. DEPT-# TICKETS WRITTEN
                                                                                              Current Month Memo
Page 4                                                                                                                 Memo
             BODY SHOP DEPT-# OF RO'S WRITTEN                        Ln   Description                                  Acct#             UNITS
                       Current Month Memo                          59     (474) PTS COUNTER-RTL-ACURA 137D                          #_________
                                                Memo               60     (475) PTS COUNTER-WHLE-ACURA 137E                         #_________
Ln    Description                               Acct#      UNITS   61     (485) PTS COUNTER-WHLE-MECH. 137H                         #_________
46 (460) BODY SHOP-CUSTOMER                     136     #_________ 68     (494) CNTR-RTL-ACURA ACCESS 137F                          #_________
47 (462) BODY SHOP-WARRANTY                     136B    #_________ 69     (495) CNTR-WHL-ACURA ACCESS137G                           #_________
48 (462) BODY SHOP-INTERNAL                     136D    #_________ 75     (482) TIRES                  137I                         #_________
                                                                   76     (483) ACCLERATED SVC - TIRES 137J                         #_________


                                                                                             MEMO SERIES OFFSET
                                                                               Debit or credit this account with the total of all memo
                                                                                   account entries in order to balance the entry.
                                                                                                                       Memo
                                                                     Ln   Description                                  Acct#             UNITS
                                                                     ZERO BALANCE AMOUNT                               199          #_________




acstat.xls                                                  Page 3 of 3                                                                  4/12/2010

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:13
posted:4/12/2010
language:English
pages:3