Excel Spreadsheet ~ Technician Time Management Vehicle Sales Department - 2016 Forecasting
Excel® Workbook for Projecting Vehicle Sales,
Gross Profit, Finance Income and Department Expenses

Spreadsheet Solutions for Auto Dealers
 
Forecasting Software for the New and Used Vehicle Sales Department

This simple to use Excel® workbook addresses what we believe to be the three most important combination of numbers when compiling a Sales Forecast that projects Sales Gross, Expenses and Net Dealership Profit.

Number of Units Sold per Month and Average Gross Profit PVR
Finance Department Penetration Percentages and Average Income per Product Type
Expenses as a Percentage of Gross Profit including Dealership Fixed Operating Expenses

Complete 12 Monthly Vehicle Sales Forecasts in less than an hour

Dealership Spreadsheets
Projecting New and Used Car Sales, Gross Profit, Finance Income and Expenses just couldn't be any easier
Solve the Puzzle Today !
 
 
Auto Dealership Vehicle Sales Gross Profit and Net Income Forecasting

View PDF Samples of Automotive Sales Forecasting Spreadsheet Reports

Unit Sales Count and PVR Finance Income and Penetration Variable Sales Expenses
  Sample Monthly Sales Forecast  

Excel® Workbook 3 Step Forecasting Process ...

Step 1
On the Unit Sales Count and PVR Forecast worksheet, within "Yellow" cells enter Model Types Sold by dealership and projected PVR per model type sold including Used Cars and Trucks retail and wholesale. Then enter projected number of New, Used and Wholesaled units sold per month
Shortcut: Enter average retail PVR for all models combined on one line and total monthly units sold
Step 2
On the Finance Income and Penetration % worksheet, enter within "Yellow" cells projected Penetration % levels and Average Gross Profit per income revenue type for both New and Used vehicles. Also enter an expense % for each income revenue type which may have expenses directly applied against income. Commonly know as Cost-of-Sales general ledger entries.
Shortcut: Enter Average Penetrate % and Gross Profit in income type for both New and Used units
Step 3
On the Variable Sales Department Expenses worksheet, in the "Yellow" cells enter the dealerships Average Monthly Expenses for the Variable Sales Department only. The % of Gross Profit value is commonly entered for all expense categories except for the Fixed Dealership Expenses which usually require an average monthly expense dollar value. Enter either a Percentage value or a Dollar value. But, not both or a calculation message error will be displayed.
Shortcut: Use the year-to-date % of Gross Profit values on your current years financial statement
Blank worksheets are available for hand-out to department managers to complete within this workbook. These worksheets should take no longer than 15 minutes for the New and Used Sales Manager, Finance Manager and Business Accounting Manager to complete for the initial dealership forecast.
Want to complete a 2016 Sales Forecast in less than 15 Minutes? - Follow the Shortcuts
Forecasting Software Program Notes
1) Only Cells "Yellow" in color allow data entry, the rest are calculated for you ...
2) Microsoft Excel® Macro's must be enabled for this forecasting workbook to function properly
3) View Monthly & Year-to-Date Reports by clicking the forms button on the Unit Sales Count worksheet

Program Code: VS-VSF13
Need More Help?
Call Now!
Call: 716-445-9721

Download 3 Day Trial Copy
Release Date; December 2013

 
Auto Sales Commission
Pay Plan Excel Worksheets

Spreadsheets that Calculate Sales Commissions and Motivates to Sell

View Program Code: PSCW-2011
 
 
Recruiting Sales Personnel
Explore our Affiliate Website offering a unique online referral service

Recruiting Auto Dealership Personnel
 
Excel Workbooks
 
 

Please Call Before Ordering
Paypal payment method is for
convenience proposes only.
Fully functional, One-time End-User License with support, Only $ 39.95
This is not a monthly fee, it's a one-time purchase price for an Excel workbook that required 100+ hours of programming and testing for you to use for years to come within your automotive dealership.

Interested, but have questions, Call 716-445-9721
It's simple, just call, no sales pitch, we let the Excel® workbook sell itself.
Trial are free of charge, no charge card, no catches, no hassle, just download it to your desktop and try it.
 
 
IntactAuto.com © 2009 - 2016 All Rights Reserved - IntactAuto Holdings, LLC
IntactAuto.com Home Page  |  Privacy & Legal Notice  |  Common Terms of Use  |  OnLine Support
Phone Contact: 716-445-9721   |   E-mail Support: Services@IntactAuto-Resources.com
IntactAuto Holdings, LLC is an independent service provider and is not affiliated with, nor has it been authorized, sponsored, or otherwise approved by Microsoft Corporation.
IntactAuto® is a registered trademark of IntactAuto Holdings, LLC. All pricing subject to change without notice and all prior sales excluded.