• DigitalDealer-horizontal-Logo
  • ATTEND LAS VEGAS
    • Attendee
      • Registration & Pricing
      • Agenda At-A-Glance
      • Exhibitor List/Floor Plan
      • Sponsor List
      • Hotel & Travel
      • Hosted Dealer Program
      • FAQ
      • Mobile App
    • Exhibitor
      • Exhibit/Sponsor
      • Advertising Opportunities
      • Exhibitor Resources
      • Exhibitor Tips
    • Education
      • Overview
      • Show Schedule
  • ABOUT
    • Conference Overview
    • Best Of Awards
    • Become a Speaker
    • Press Inquiries
    • Partnership Programs
    • Health & Safety
    • Contact Us
    • Get Updates
  • RESOURCES
    • Webinars
    • Downloads
  • NEWS
    • Auto Retail News
    • Digital Editions
    • Press Releases
    • Submit Editorial
    • Subscribe
  • .
  • ATTEND LAS VEGAS
    • Attendee
      • Registration & Pricing
      • Agenda At-A-Glance
      • Exhibitor List/Floor Plan
      • Sponsor List
      • Hotel & Travel
      • Hosted Dealer Program
      • FAQ
      • Mobile App
    • Exhibitor
      • Exhibit/Sponsor
      • Advertising Opportunities
      • Exhibitor Resources
      • Exhibitor Tips
    • Education
      • Overview
      • Show Schedule
  • ABOUT
    • Conference Overview
    • Best Of Awards
    • Become a Speaker
    • Press Inquiries
    • Partnership Programs
    • Health & Safety
    • Get Updates
  • RESOURCES
    • Webinars
    • Downloads
  • NEWS
    • Auto Retail News
    • Digital Editions
    • Press Releases
    • Submit Editorial
    • Subscribe

DealerPoint: May 21-23, 2024
Conference & Expo:
October 8-10, 2024

REGISTER NOW EXHIBIT / INQUIRE
Q

NEWS:

Dealer/GM News | Digital Dealer | Finance & Insurance News | Technology
January 14, 2011

Using Technology for the ‘Why’

Posts:
Dealer/GM News | Digital Dealer | Finance & Insurance News | Technology
January 14, 2011

Using Technology for the ‘Why’

One of my favorite dealer clients once said to me, “All I get is ‘What,’ stuff all day; I’d like to see some ‘Why’!”  He went on to explain that he only gets reports of what is wrong: expenses are high, we’re out of cash, we’re losing money, accounts are past due, paperwork is missing, overtime is high or the inventory is over aged – but what he needs are the reasons why. Then if he knows the “why” he will be better prepared to know what changes to make.

Look at the reports that you’re creating every day. Are they truly “what” reports, or do they also provide dealers and operational managers the reason “why?”

An example of a “what” report is one that lists out in descending order every vehicle in a used vehicle inventory that is over 45 days old. A reaction to this report is to circle the oldest units and tell a manager to get rid of them.  This completes the never ending cycle of obtaining used inventory, trying to sell it and then dumping it later at a loss.

A better “why” report would offer data explaining why those vehicles have became over aged.  Instead of the typical listing for a used vehicle in your inventory, why not provide more information about where they came from. Did you buy them from the same auction, or wholesaler?  Did they came from new vehicle trade-ins or used?  Were they appraised by the same manager or purchased by the same buyer?   Are they the same makes and models of vehicles that you’ve never been able to successfully sell before and maybe should have wholesaled on day one? Do they have high miles or did they get too much reconditioning done?

This type of report provides value instead of just killing more trees with pages of data.  It also brings value to your DMS system that has been faithfully storing this data.  Most systems have a field that indicates where a vehicle came from and who appraised it.   You might be creative or use some of the features of Excel like Vlookup.

Let’s say that your system shows where the vehicle came from, but not who appraised it.  If all your new vehicle deals are appraised by the desk manager which is common in small and medium sized dealerships, then you’d use a Vlookup to the car deals file, looking up the buyer name and populating the sales manager on the deal.  You’d use an IF statement to populate your buyer’s name if it came from an auction.  It would be also be a lot easier if you’d just have someone enter that information when vehicles are added into stock by looking at the appraisal report.

Another example of a “what” report is our trending of expenses.  We are quick to highlight an account that is higher than last month, but what if it was already high last month?  This is probably the most dangerous method of analyzing expenses.  Instead you need to provide the reason why the expense is that amount. This may mean detailing, regrouping and then investigating the expense.

Jack Ross (my Excel guru friend) developed a way to regroup expenses by base account and vendor.  For example if you pay R+R or ADP each month $9,000, this might be broken down between five departments and four accounts: data processing, other supplies, office supplies, and advertising.  Departmental accounting is the biggest enemy of expense control! That means 20 entries for one bill in your detail.  By regrouping by vendor, you can see the total amount paid to a vendor and then investigate it.  The investigating comes from my Item Expense method of expense research.

If you’d like more information on either of these methods, just send me an e-mail.

What are some of the other “why” reports?  Here are a few to work on:

  • Why do you have comebacks in the shop?
  • Why do we miss sublet getting charged out on repair orders?
  • Why do we write off warranty claims and obsolete parts?
  • Why are there charge backs on car deals from last month?

Make sure you’re getting more “why” reports with answers that will help enable you to make the changes you need to increase profit.  Stop creating negative “what” reports, you’ll save paper and time.

Dealer/GM News•Digital Dealer•Finance & Insurance News•Technology

SHARE

Share on Email
Share on Linkedin
Share on Facebook
Share on Pinterest
Share on Twitter
← Previous Article Next Article →
Posts Dealer/GM News

Ciocca Agrees to Purchase 10 More Pennsylvania Dealerships

The Ciocca Dealership group is growing its holdings in Pennsylvania. The agreement has Ciocca purchasing Apple Automotive, the automotive division of York County, Pa- based Stewart Companies. Terms of the deal was not disclosed, with the final transa
Posts Dealer/GM News

Mercedes Launches First Charging Hub in U.S.

Mercedes-Benz is offering a change to the way Americans charge their vehicles in the same way Starbucks altered the routine of getting a cup of coffee. Mercedes, in a joint venture with MN8 Energy to launch a network of premium electric vehicle (EV)
Posts Dealer/GM News

Ciocca Agrees to Purchase 10 More Pennsylvania Dealerships

The Ciocca Dealership group is growing its holdings in Pennsylvania. The agreement has Ciocca purchasing Apple Automotive, the automotive division of York County, Pa- based Stewart Companies. Terms of the deal was not disclosed, with the final transa
Posts Digital DealerEveryone

Digital Dealer Unveils New Branding & Announces Launch of DealerPoint, Offering Targeted Networking and Driving Innovation

Digital Dealer has revealed its new branding and announced the launch of DealerPoint, a dynamic addition to its event portfolio.   This unveiling of the refreshed logos marks a symbolic step forward for Digital Dealer, aligning with its commitment
Posts Dealer/GM News

Hyundai Dealers Will Be the First to Sell Cars Through Amazon Platforms

Amazon is getting into the (virtual) car dealership business. At the Los Angeles Auto Show Nov. 16, the Seattle-based online behemoth announced auto dealers for the first time will be able to sell vehicles on Amazon’s U.S. store in 2024—with Hyun
Posts General

GM Workers Approve Union Contract; Ford, Stellantis on Pace to Pass

Despite concerns that resulted in a closer than expected vote, General Motors (GM) union workers approved the deal negotiated by United Auto Workers (UAW) union. The deal was supported by roughly 54% of the more than 34,700 autoworkers at GM who vot
Posts Search Engine MarketingTechnology

A Third of Dealers Still Lost Concerning Key Components of Safeguards Law Compliance

There has been plenty of chatter leading up to the new Safeguards law that went into effect earlier this year. Among many other components to the legislation and new requirements, the law requires auto dealerships to obtain clear and informed consent
Posts Dealer/GM News

CarGurus Agrees to Fully Acquire CarOffer, Will Buy Back $250M in Stocks

By James Hickey Managing Editor, DigitalDealer.com CarGurus will acquire the remaining minority equity interests in CarOffer for $75 million through an all-cash transaction, a deal expected to close next month. CarGurus acquired a 51% stake in CarOff

NEWSLETTER

SUBSCRIBE

DEALER MAGAZINE

Dealer Magazine March/April 2023 Issue Featuring an Interview with NADA 2023 Chairman
MAGAZINE

Explore All Our Brands

FOLLOW US ON

  • Follow
  • Follow
  • Follow
  • Follow
  • Follow
© 2023 Emerald X, LLC. All Rights Reserved.

ABOUT    CAREERS    AUTHORIZED SERVICE PROVIDERS   DO NOT SELL MY PERSONAL INFORMATION   TERMS OF USE   PRIVACY POLICY