10 Things an Internet Manager has always wanted

10 Things an Internet Manager has always wanted to ask…. Sandi Jerome editor, Digital Dealer www. Dealer. Star. com 2852 WILLAMETTE ST #502 EUGENE, OR 97405 sandi@dealerstar. com

Why aren’t Internet Managers treated like other managers? Ø Pay plan vs. commission voucher Ø Either attend manager meetings or provide reports Pay Plan – Internet Manager Salary $2500 Month Plus 15% of the gross profit of the Internet department less Internet lead expense Plus $500 bonus for a closing ratio over 15% $750 bonus for 85% CSI on department deals

How is gross profit calculated in car deals? Ø Get in writing the salesperson pay plan (pack, holdback) Ø Know how to find your accounting cost (vc) Ø Learn how the gross profit screen works Dlr Gross

Why are there chargebacks? l l l Open ROs – make friends with the cashier Due bills – they are often missed Purchase orders Ø What about the pack? l l How much is your pack? Does it cover chargebacks?

How does the R+R/ADP/UCS system work? Ø Getting a login Ø R+R Query to PC Process Ø ADP- RPG to RPX

DMS Download to Excel Ø Ø Ø Ø ADP – Reflection, function RXR, RPX. Files: FI-WIP, CAR-Inv, Vehicles, History, GL. ACCT. LDGR R+R – Era. Link, Run. Query. FIMAST, NVInventory, UVInventory, ROJournal, Customer, Ser. Index, GL, SCHEDULE 4, etc. EDS/ADP ARG – Executive Assistant, SLDELHPF, VMVEHMPF, SVSOHDL 1 UCS –Run reports in modules, then PRT blank, ERM (Power Workstation – or FTW). 269 -01 thru 269 -04, 358/359, 410 -01 thru 410 -03. Autosoft – DAT files like asro, aasacm, asc – need to import with position of field. PBS – Microsoft Access files – link, import, unlink. PBSf&I. mdb, PBSinvn. mdb, PBSserv. mdb ADAM – dbf files can be imported or linked ACS , DPC, Auto/Mate, Arkona, Dealer. Star – export to Excel

Getting the Data – Two Sources on your DMS System Ø Transaction files l l Ø Car deals, range of dates, finalized Repair orders, range of dates, customer and warranty Database files – snapshot as of today l l Vehicle inventory, New/Used, with GL balance GT $1000 Customers, Last service date > 03/01/06 and Make = Toyota

What kind of reports can I run and how? l Customer File – it is in service; • • • l R+R - SERINDEX ADP - VEHICLES UCS – SIN database Inventory File • • • R+R – NVINVENTORY, UVINVENTORY (INV$$) ADP – CAR-INV (BALANCE) UCS – SIN database

Auto. Filter Ø New Inventory Report –Data, Filter, Auto. Filter l l Custom – is greater than 90 Top 10 Auto. Filter

Pivot Table Ø Data, Pivot table, Next, Layout l Balance, 3 time • • • l Units Total Value Average Cost Add Days in Stock, Right click, Wizard, Layout

How can I measure the profitability of my Internet department? l l Find out how your department is “accounted for” – measured Expenses “allocated” to your department A - New B - Used E- Parts D- Service F - Body Shop ? ? ? Sales Gross Profit Direct Expenses Commissions Leads Advertising Semi Fixed, Fixed

How can I “F&I” my own deals? - – Learn your DMS system’s F&I module Ø l l Ø www. reyrey. com www. dealersuite. com Volunteer!

Buy Rates – Get the chart! 35% — punctuality of payment in the past (only includes payments later than 30 days past due) 30% — the amount of debt, expressed as the ratio of current revolving debt (credit card balances, etc. ) to total available revolving credit (credit limits) 15% — length of credit history 10% — types of credit used (installment, revolving, consumer finance) 10% — recent search for credit and/or amount of credit obtained recently

What is a good pay plan for an Internet Manager? Salary, maintaining the website Ø Commissions, % of gross profit Ø Bonus, CSI, closing ratios Ø

Step 1 – How much Salary?

Step 2 – Commission Rate

Step 3 -Leftovers is the Bonus

www. sandijerome. com Free Downloads, Spreadsheet, DMS jobs to run Pay Plan Wizard Email- sandi@dealerstar. com Power ERALink/Power Reflection Ultimate Campaign Guide Data Miner! Campaign Manager for ADP, RR, EDS, UCS, Auto. Soft