Northern New England Region — Last Tactical Mile

Sample data. The five region parameters below are illustrative, chosen for today's discussion. Real values load from Thunderbolt shelter requirements, fleet records, RIM, and DAT historicals — the worksheet then recomputes automatically.

Region Parameters

Five Inputs Drive the Entire Worksheet

Shelter Sites

Set by Thunderbolt requirements

ERVs Assigned

Emergency Response Vehicles

Chapters

Within the region

DAT Events / Month

Average monthly target

Smoke Alarm Allocation

4,000

Annual

Derived Planning Bases

Computed From the Program Standards

Shelter Population

4,000

Sites × 100 (Thunderbolt standard)

Shelter Meals

16,000

Population × 2 Meals × 2 Days

DES Households

Per program standard

DAT Clients / Month

Events × 4 clients

Food & Drink Carriers

230

Plausible reading — 96,030 as written ⚠

Needs confirmation before PAR values are real. The worksheet computes exactly what the draft outline says; these readings need an NHQ decision:

Shelter Meals formula carries a "?" in the source outline (population × 2 meals × 2 days). Confirm.
DES households: source says "75 households served (assumes half the Region's chapters are active)" — worksheet uses a flat 75. If it means 75 per active chapter, quantities scale by chapters ÷ 2. Confirm.
Source reads "3 per Shelter Meals (25% of inventory)" — a per-meal factor of 3 cannot be right; likely per-carrier capacity. Confirm.
Source reads "3 per Shelter Meals (75% of inventory)" — same concern as F-8. Confirm.
Basis "Cambro" = computed carrier count (F-6+F-7+F-8+F-9); inherits the F-8/F-9 concern.
Road to Recovery is "per case"; worksheet assumes 1 case = 1 DAT event. Confirm.

Mass Care — Sheltering

Baseline Factors From the Draft Worksheet

Code	Material Item	Factor	Basis	Baseline Quantity
S-1	BANQUET PACK CS/250	1	Sites	40
S-2	BLANKET	2	Population	8,000
S-3	CLAMSHELLS	1	Sites	40
S-4	COMFORT KIT, NATIONAL STANDARD	1.3	Population	5,200
S-5	COT, MEDICAL (450 lb)	0.1	Population	400
S-6	COT, STANDARD (350 lb)	1	Population	4,000
S-7	External Shelter Signs Kit	1	Sites	40
S-8	Tarps for Floor Covering	1	Sites	40
S-9	GLOVES, NEOPRENE, NO POWDER, CS/12	5	Sites	200
S-10	Internal shelter signage kit	1	Sites	40
S-11	RED CROSS VESTS	2	Sites	80

Mass Care — Feeding

ERV, Meal, and Carrier-Based Items

Code	Material Item	Factor	Basis	Baseline Quantity (as Written)	Plausible Reading
F-1	BANQUET PACKS, CS/250	1	ERV	6
F-2	BEARD COVER, POLYPROPYLENE, WHITE, LATEX FREE (100/box)	1	ERV	6
F-3	CLAMSHELLS, CS/200	0.02	Shelter Meals	320
F-4	COOLERS	1	ERV	6
F-5	CUP, CO-BRANDED FOAM, 8-OZ, CS/1000	0.001	Shelter Meals	16
F-6	DRINK CAMBROS - CARRIER, DRINK/BEVERAGE	2	ERV	12
F-7	FOOD CAMBROS - CARRIER, FOOD, LARGE (100 meals)	3	ERV	18
F-8	FOOD CAMBROS - CARRIER, FOOD, SMALL (50 meals) - 25% of inventory ⚠	3	Shelter Meals	48,000	80
F-9	FOOD CAMBROS - CARRIER, FOOD, LARGE (100 meals) - 75% of inventory ⚠	3	Shelter Meals	48,000	120
F-10	FOOD CAMBROS LINERS, 100 EA	0.01	Shelter Meals	160
F-11	GASKET, LID, LARGE, FOR LARGE FOOD CARRIER KF-D43 ⚠	1	Cambro	96,030	230
F-12	GASKET, LID, SMALL, FOR LARGE FOOD CARRIER KF-D43 ⚠	1	Cambro	96,030	230
F-13	GLOVE, FOOD SERVICE, LATEX FREE, LARGE (100/pkg)	1	ERV	6
F-14	GLOVES, NEOPRENE, NO POWDER, CS/12	1	ERV	6
F-15	HAIR NET, NYLON, LIGHTWEIGHT (144/pkg)	1	ERV	6
F-16	SPOODLE, PERFORATED, 4 OZ ⚠	0.33	Cambro	31,690	76
F-17	SPOODLE, PERFORATED, 6 OZ ⚠	0.33	Cambro	31,690	76
F-18	SPOODLE, PERFORATED, 8 OZ ⚠	0.33	Cambro	31,690	76
F-19	SPOODLE, SOLID 8 OZ ⚠	0.33	Cambro	31,690	76
F-20	SPOODLE, SOLID, 4 OZ ⚠	0.33	Cambro	31,690	76
F-21	SPOODLE, SOLID, 6 OZ ⚠	0.33	Cambro	31,690	76
F-22	Step stool	1	ERV	6
F-23	Tong ⚠	0.33	Cambro	31,690	76
F-24	Hand Sanitizer, 12oz	2	ERV	12
F-25	Food Thermometer ⚠	0.33	Cambro	31,690	76

Mass Care — Distribution of Emergency Supplies

Household-Served Basis

Code	Material Item	Factor	Basis	Baseline Quantity
D-1	CLEAN-UP KITS	1	Per DES HH Served	75
D-2	WORK GLOVES	2	Per DES HH Served	150
D-3	MASK, KN95 RATED RESPIRATORS	2	Per DES HH Served	150
D-4	TARP	0.5	Per DES HH Served	38
D-5	TRASH BAG Boxes - LARGE sized bags	1	Per DES HH Served	75
D-6	TRUCK DECAL KIT	2	Number of Chapters	6

Disaster Action Team

Standard: 1 Event = 4 Clients = 2 Responders = 8 Items

Material Item	Factor	Basis	Baseline Quantity
Blanket	1	per client	88
Client Assistance Cards (CAC) National average EFT/CAC 50% split; inventory tracked through CIMS	0.5	per client	44
Comfort Kit	1	per client	88
Plush Toy National average children under 11	0.14	per client	13
Reflective Vests Average monthly target	2	per DAT event	44
Road to Recovery Booklet ⚠	1	per case	22
Water	JIT	Just-in-Time Purchase	JIT
Snacks	JIT	Just-in-Time Purchase	JIT

Preparedness

Home Fire Campaign Support

Material Item	Factor	Basis	Baseline Quantity
Smoke Alarm, 10 year	0.15	of annual smoke alarm allocation	600
Home Fire Campaign Kit - Unopened	1	per region	1

Pre-Read Data — Coming Next

The engagement dashboard adds these panels as NHQ shares flat-file exports (the biggest external dependency):

Current RIM inventory vs the baseline worksheet
Trailer footprint and specialty vehicle footprint
DRO historicals; DAT clients and events historicals
Map: region and chapter boundaries, DFSC and NHQ staging locations with distance and drive time, storage sites, trailer locations

Northern New England RegionDemo · Sample Parameters

Region Parameters

Derived Planning Bases

Mass Care — Sheltering

Mass Care — Feeding

Mass Care — Distribution of Emergency Supplies

Disaster Action Team

Preparedness

Pre-Read Data — Coming Next