- LTWBootstrap

Description	Total	Average	Per Unit	Selected Vehicle	Count	Penetration

Base Gross

HoldBack

Bonus

PD/Lot

Vehicle Gross

Finance

Insurance

Warranty

Aftermarket

Total Gross

Estimate

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

Actual

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

Variance

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

Totals

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

StockNo	-	RegNo	-	Inventory$	-
Make	-	RegExpiry	-	List Price	-
Family	-	Delivered Date	-	Sales Cost	-
Body	-	Status	-	Sales Price	-
Description	-			CostPack	-
Build Year	-	DIS	-	Holdback	-
Compliance	-	Age	-	Bonus	-
Transmission	-	NOU	-	Floorplan	-
Exterior Colour	-	Location	-	Floorplan Payout	-
Fuel	-	Odometer	-
No Cyl	-	Key No's	-	Memo1	-
Engine No	-	ApprBy	-	Memo2	-
VIN	-

Worksheet Details				DMS Delivery		BTW Delivery
StockNo	-	Order Date	-	DMS Estimated Delivery Date	-	BTW Estimated Delivery Date
Make		AccPrefix	-	DMS Estimated Gross	-	BTW Estimated Gross
Family		Dept	-	DMS Estimated Holdback	-	BTW Estimated Holdback
Body Sytle		Deal Number	-	DMS Estimated Bonus	-	BTW Estimated Bonus
Rego No		QuoteNo	-	DMS Estimated Cost Pack	-	BTW Estimated Cost Pack
Model		DealStatus	-	DMS Deal Date	-	BTW Deal Date
ExtClr		Delivered	-			BTW Arrival Date (EDA)
Name		SalesPrice	-	Total Gross	-
SaleType
Salesman				Exclude Reason		BTW Expected Deal No
slmName



BaseDealKey	-

CustomerNbr	-
Salutation	-	HomePhone	-	Attention	-
Title	-	WorkPhone	-	CompanyName	-
Name	-	Mobile	-
FirstName	-	Email	-	ContactType	-
MiddleName	-	BusinessEmail	-	PrivacyCode	-
Surname	-	DOB	-	PrivacyDesc	-
		Gender	-
Address1	-
Address2	-
Suburb	-
State	-
PostCode	-

	Supplier	Work to carry out	Details	Date Required	Expected Completion	Date Completed


DealNo	-	Terms	-	Finance Income	-
Cust Name	-	Base Rate	-	Commission	-
Sales Person	-	Actual Rate	-	Volume Bonus	-
Financier	-	Payment	-
Finance Type	-	Residual	-	Total Finance	-
Settled	-	NAF	-
FinPaymentType	-
DealerFinance	-


Sales Person		Terms		Finance Income		Floorplan Offset
Financier		Base Rate		Origination Fee		Documentation Fee
Finance Type		Actual Rate				Variance
Settled		Payment				Prime
Cust Name		Residual
Lost Reason		NAF		Total Finance	-

	Sales Person	Product	Supplier	Settled	Details	Premium	Income	Commission

	Sales Person	Product	Supplier	Settled	Details	Sale	Cost	Income

	Sales Person	Product	Supplier	Settled	Details	Sale	Cost	Income


DealNo	-	Insurance Commission	-
Cust Name	-	Insurance Company	-
		Insurance Premium	-


DealNo	-	Warranty Commission	-
Cust Name	-	Warranty Company	-
		Warranty Premium	-


DealNo
Name
		Aftermarket	-

PD Stats		PD Approved		PD Updated		Details
PD Completed	-	PD Approved Date	-	PD Updated Date	-	Year	-
PD Confirmed	-	PD Approved Time	-	PD Updated Time	-	Make	-
PD Method	-	PD Approved By	-	PD Updated By	-	Family	-
PD Time	-
PD Status	-					Deal Status	-
PD Scheduled Time	-					Dept	-
Actual Onsite Date	-
Estimated Onsite Date	-
Scheduled Delivery	-
Customer Delivery	-