Delwood Motor Group

Delwood Motor Group is a fictional multi-rooftop auto dealer group built for BI teams that want a believable retail-automotive dataset spanning the front end (new and used vehicle sales, F&I, and financing) and the back end (service repair orders, parts, and inventory) without exposing any real customers, employees, lenders, or vehicle identification numbers. Every brand, model, lender, and customer in the kit is invented. The group is shaped like a mid-to-large metro dealer group so analysts can model deal gross, F&I penetration, fixed-operations throughput, and used-inventory aging in one coherent operating story.

Operating Profile

• Runs nine dealership rooftops across several metros, each franchising one primary fictional brand and also retailing used vehicles.
• Sells new and used vehicles through retail, lease, and fleet deals, attaches F&I products, and arranges retail financing through a panel of fictional lenders.
• Runs fixed operations at every rooftop, with service writing repair orders and parts selling counter, wholesale, and internal.
• Keeps the scope on dealership retail and fixed operations rather than incentive accounting, ledger depth, or warranty adjudication.

Recent Business Events

• 1The F&I office moved to per-product administrator pricing, so product margin now runs from about 37% on prepaid maintenance to 78% on GAP.
• 2Used-vehicle accounting moved used stock off new-vehicle money to segment residual value, cutting reported inventory value about 11%.
• 3The finance desk now books reserve as rate participation, from about 0.7% of the amount financed at credit unions to 2.7% at subprime specialists.
• 4The group tightened aging targets, drawing stock down about 3% and pulling average days in inventory down through the second year.
• 5The parts department repriced by category instead of one blanket markup, so margin now runs from about 11% on tires to 45% on filters.