# Affected population and safety-risk analysis workbook

NHTSA manufacturer safety recall reporting and execution | Blank worksheet

Step: Reproduce the affected population and risk assessment
Owner: Quality engineering + Vehicle or equipment data + Manufacturing + Supplier quality + Safety counsel
When: In parallel with investigation; review assumptions daily until the first report is filed

## Gather first
- Production and VIN or serial master
- Supplier lots
- Warranty and repair records
- Field reports
- Test data
- Product engineering definitions

## How to prepare it
1. Define a population query and version it. Record joins, exclusions, duplicates, missing identifiers, source dates and accountable data owners.
2. Calculate total potentially involved products separately from the estimated percentage actually containing the defect. Show the numerator, denominator, assumptions, uncertainty and validation sample.
3. Test in-scope and out-of-scope samples, compare sibling models and production changes, then have a second engineer independently reproduce the result.

## Fill in

### Fictional population row
[Add details here]

### Fictional calculation
[Add details here]

## Review
A reviewer can rerun the population logic and explain why nearby products are included or excluded.

## Handoff
Give the approved count, basis and risk analysis to the Part 573 filing owner.

Official reference: NHTSA Manufacturer Recalls Portal population and product guidance
https://www.nhtsa.gov/document/manufacturer-recalls-portal-mrp-user-guidance

Use the current rules and any prescribed forms for your engagement.
