AI Matrx Logo

Used car dealer

Moorfield Valley Motors · Used car dealer · Hagerstown, MD

Elif Tamarind is the sales manager at Moorfield Valley Motors, a used car dealership in Hagerstown, Maryland, and she keeps every license, safety finding and frontline check here so the file is ready the day an inspector walks in.

AutomotiveComplianceChecklists4 tables · 8 views · 1 form · 1 digest · 2 checklists · 1 notification · 1 stage rule set · 1 agent
Use this template

Inventory board

Inventory
Intake3
2017 Kia Sorento LXMV-44282,017
2020 Hyundai Kona SEMV-44292,020
2016 Buick Encore PreferredMV-44302,016
Inspection4
2018 Nissan Rogue SVMV-44242,018
2016 Honda Accord EXMV-44252,016
2019 Mazda Mazda3 SportMV-44262,019
2015 Jeep Cherokee LatitudeMV-44272,015
Reconditioning4
2014 Toyota Sienna LEMV-44202,014
2016 Hyundai Santa Fe SportMV-44212,016
2015 Ford Edge SELMV-44222,015
2017 Chevrolet Malibu LTMV-44232,017
Frontline9
2019 Honda CR-V EXMV-44112,019
2016 Ford Escape SEMV-44122,016
2020 Toyota Corolla LEMV-44132,020
2015 Dodge Grand Caravan SXTMV-44142,015
2018 Chevrolet Equinox LTMV-44152,018
4 more
Sold10
2016 Honda Civic LXMV-44012,016
2018 Toyota Camry SEMV-44022,018
2015 Ford F-150 XLTMV-44032,015
2017 Subaru Outback 2.5iMV-44042,017
2019 Hyundai Elantra SELMV-44052,019
5 more

Tables

Inventory

30 sample rows · 23 columns

Every car from the day it is bought to the day it is sold, with the records an inspector asks for.

VehicleStock numberYearMakeModelVINMileage
2016 Buick Encore PreferredMV-44302,016BuickEncore PreferredFYLFGP3NECGT9YTU172,000
2017 Kia Sorento LXMV-44282,017KiaSorento LX1H6129N80Y2CVHCDL66,000
2020 Hyundai Kona SEMV-44292,020HyundaiKona SE8RD89GWF759K2RKLU29,000
2015 Jeep Cherokee LatitudeMV-44272,015JeepCherokee LatitudeUAZUV2F1TRV5MA56D92,000
2019 Mazda Mazda3 SportMV-44262,019MazdaMazda3 SportL3SLMV8UKHMYE3YZ638,000
2016 Honda Accord EXMV-44252,016HondaAccord EXDWJDEM1LCAER7WRSZ79,000
2018 Nissan Rogue SVMV-44242,018NissanRogue SV6NB67EUD537H0NHJS51,000
2017 Chevrolet Malibu LTMV-44232,017ChevroletMalibu LTZF4Z07L6YW0ATFABJ74,000
2015 Ford Edge SELMV-44222,015FordEdge SELS8XST0DZRNT3K834B97,000
2016 Hyundai Santa Fe SportMV-44212,016HyundaiSanta Fe SportJ1PJKT6SHFKWC1WX490,000
2014 Toyota Sienna LEMV-44202,014ToyotaSienna LEBUGBCKZJA8CN5UNPX123,000
2018 Ford Fusion SEMV-44192,018FordFusion SE4L945CSB315FYLFGP59,000

18 more rows

Inspection findings

40 sample rows · 8 columns

What the safety inspection found on each car and whether it has been fixed.

FindingVehicleAreaSeverityFoundFixedRepair cost
MV-4420: door ding and paint chip2014 Toyota Sienna LEBodyCosmeticSep 25, 2026—$220
MV-4420: cracked dash trim2014 Toyota Sienna LEInteriorCosmeticSep 25, 2026—$70
MV-4421: front brake pads below spec2016 Hyundai Santa Fe SportBrakesSafetySep 26, 2026—$320
MV-4421: two tires under 4/32 tread2016 Hyundai Santa Fe SportTiresSafetySep 26, 2026—$320
MV-4422: worn tie rod end2015 Ford Edge SELSteeringSafetySep 27, 2026—$260
MV-4422: check engine light on, sensor fault2015 Ford Edge SELEmissionsQualitySep 27, 2026—$140
MV-4423: cracked dash trim2017 Chevrolet Malibu LTInteriorCosmeticSep 28, 2026—$150
MV-4423: coolant leak at a hose2017 Chevrolet Malibu LTFluidsQualitySep 28, 2026—$90

Licenses and permits

14 sample rows · 9 columns

The licenses, bonds, permits and policies the dealership has to keep current.

NameKindIssued byNumberIssuedExpiresRenewal cost
Workers compensation policyInsuranceWorkers comp carrierWC-60-2217Oct 15, 2025Oct 15, 2026$3,900
Hazardous waste generator noticePermitState environment officeHW-4432Oct 30, 2025Oct 29, 2026$110
Fire marshal inspectionInspectionCounty fire marshalFM-2026-318Oct 30, 2025Oct 30, 2026$60
Dealer open lot liability policyInsuranceGarage insurance carrierGL-72-40618Nov 9, 2025Nov 9, 2026$5,200
Garagekeepers legal liability policyInsuranceGarage insurance carrierGK-41-77310Nov 9, 2025Nov 9, 2026$1,850
Used oil handling registrationPermitState environment officeUO-882-14Nov 29, 2025Nov 19, 2026$70

Views

Expiry calendar

Licenses and permits
October 2026
Sun
Mon
Tue
Wed
Thu
Fri
Sat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15Workers compensation policy
16
17
18
19
20
21
22
23
24
25
26
27
28
29Hazardous waste generator notice
30Fire marshal inspection
31

Forms and booking

Add a car

Form
Add a carWhat the sales manager fills in when a car is bought and comes onto the books.
What is the stock number? *
What is the car? *Year, make and model.
What model year is it?
Who makes it?
Which model is it?
What does the odometer read?
Where did it come from?AuctionTrade-inPrivate purchaseLease return
What did it cost us?
Add to inventory

Also included

  • Frontline stepsChecklist
  • Renewal stepsChecklist
  • Inventory boardStage rules
  • License coming dueNotificationWarns the sales manager a month before a license or policy expires.
  • Monday renewalsDigest

Related templates