Pallets per Item, Square Feet per Pallet, Dollars per Square Foot — Adjustable by the Person Who Knows
Jim's tool. Every material converted to pallet positions and
square feet (13.3 sq ft per position). Three factors are confirmed (Jim Coughlan's worksheet — badged
CONFIRMED); the other 47 are seeded best-guess
estimates awaiting his judgment. 32 items now also carry
WAREHOUSE packout data from the Standard Items pallet
sheet (7/22/2026) — units per skid, double-stack, weight, and dimensions, shown under the item name.
Where the sheet disagrees with the working factor it is flagged
REVIEW — the factor itself changes only on Jim's call.
Numbers recompute instantly as factors change. Edits stay in this
browser and export as a proposal file — the official factor set changes only through the project
repository after review.
Editing is on. Change any Units / Pallet number (and the square-feet-per-pallet
constant below) — totals recompute instantly. Nothing is sent anywhere automatically: when the numbers
look right, click Download Proposal for Jeff — it saves a spreadsheet that opens in
Excel — and email it to Jeff. He updates the official factors in the project records, with your name on
the change. Target and On-Hand columns are locked: targets come from the National Headquarters
worksheet and on-hand counts from the August 28; NCCR corrected September 30 field inventory.
Square feet per pallet position:
· Custom cost rate: $ / sq ft / year (overrides the dropdown when set)
Review Notes & Open Questions
What the Standard Items pallet sheet (7/22/2026) changed, and the calls only Jim can make. Everything here is also in the proposal export.
Three Calls Only Jim Can Make
Comfort Kits — the big one. The confirmed working factor is 720 per pallet; the sheet observed 480 per skid and says they do not double-stack. If the sheet is right, comfort-kit storage needs about 50% more floor space. Which number stands?
The 2,421 lb blanket pallet. That exact weight appears three times in the sheet — blankets, towels, and zip ties — which reads like a copied cell. If it is real, a 53-foot trailer is weight-capped at about 9 blanket positions instead of 30. What does a blanket skid actually weigh?
Double-stacking standard cots. The sheet says cots double-stack (48 per skid, 96 per position). Our planning assumption is now double-stack — that halves the cot storage footprint and the excess-trailer count. Does that match how cots are really stored and shipped?
Where the Sheet Disagrees With the Working Factor (14 Items)
These rows carry the yellow REVIEW flag in the main table. Nothing changes until Jim rules on each — then Jeff updates the official factors.
Code
Material Item
Working Factor
Sheet per Skid
Sheet per Position
S-1
Banquet Pack CS/250
40
75
150 (2 Skids)
S-4
Comfort Kit, National Standard
720
480
480
S-5
Cot, Medical (450 lb.)
40
6
12 (2 Skids)
S-7
External Shelter Signs Kit
60
80
80
F-1
Banquet Packs, CS/250
40
75
150 (2 Skids)
F-4
Coolers
24
48
48
F-6
Drink Cambros - Carrier, Drink/Beverage
12
25
50 (2 Skids)
F-8
Food Cambros - Carrier, Food, Small (50 Meals) - 25% of Inventory
12
20
20
F-10
Food Cambros Liners, 100 Ea
48
20
40 (2 Skids)
F-11
Gasket, Lid, Large, for Large Food Carrier KF-D43
1,000
51
51
D-5
Trash Bag Boxes - Large Sized Bags
60
200
400 (2 Skids)
DAT - 1
Comfort Kits
720
480
480
F-36
Food Cambros Liners, 100 Ea
48
20
40 (2 Skids)
F-34
Gasket, Lid, Large, for Large Food Carrier KF-D43
1,000
51
51
Trailers: Weight Now Binds Before Space for Some Items
A 53-foot trailer fits 30 pallet positions by cube, but the planning payload is 45,000 lb. For these items the weight limit is reached first (double-stack positions count two skids):
Code
Material Item
Lb per Skid
Weight-Capped Positions
Cube Positions
S-1
Banquet Pack CS/250
960
23
30
S-2
Blanket
2,421
9
30
S-6
Cot, Standard (350 lb.)
840
26
30
F-1
Banquet Packs, CS/250
960
23
30
F-4
Coolers
3,500
12
30
DAT - 3
Blankets
2,421
9
30
SKU Near Misses — Not Applied Until Confirmed
These PAR items look like sheet rows but the codes differ. If Jim confirms a pair, Jeff adds it to the extractor's alias table.
Code
Material Item
Our SKU
Looks Like Sheet Row
S-3
CLAMSHELLS, CS/200
KF-D192
KF-D196
S-9
GLOVES, NEOPRENE, NO POWDER, CS/12
BD-KD066
BD-D306
F-3
CLAMSHELLS, CS/200
KF-D192
KF-D196
F-5
CUP, CO-BRANDED FOAM, 8-OZ, CS/1000
KF-KD212
KF-D211
F-7
FOOD CAMBROS - CARRIER, FOOD, LARGE (100 meals)
KF-D42
KF-D43G2
F-9
FOOD CAMBROS - CARRIER, FOOD, LARGE (100 meals) - 75% of Inventory
KF-D42
KF-D43G2
F-14
GLOVES, NEOPRENE, NO POWDER, CS/12
BD-KD066
BD-D306
F-16
SPOODLE, PERFORATED, 4 OZ
KF-D105
KF-D210
F-17
SPOODLE, PERFORATED, 6 OZ
KF-D103
KF-D210
F-20
SPOODLE, SOLID, 4 OZ
KF-D104
KF-D210
F-26
SPOODLE, PERFORATED, 4 OZ
KF-D105
KF-D210
F-27
SPOODLE, PERFORATED, 6 OZ
KF-D103
KF-D210
F-30
SPOODLE, SOLID, 4 OZ
KF-D104
KF-D210
D-1
CLEAN-UP KITS
BD-D12
BD-D312
D-2
WORK GLOVES
BD-D136
BD-D306
D-3
MASK, KN95 RATED RESPIRATORS
BD-D323
BD-D312
D-4
TARP
BD-269
BD-D269
DAT - 2
Plush Toy
BD-D1151
BD-D1154
What Happens to the Headline When These Land
Regional excess, all materials: 516 trailer-equivalents today →
about 407 if the observed packouts are adopted → about 485 once trailer
weight caps are applied on top. The biggest single mover is cots double-stacked (their excess halves);
the biggest credibility win is banquet packs, where the observed 75-per-skid replaces a guessed 40.
The published graphics stay frozen until Jim's calls are in.
Code
Material Item
Units / Pallet
Basis
Target Units
On Hand
Pallets Needed
Pallets Used
Sq Ft Excess
$ / Year Excess
Square feet are net pallet positions —
real warehouses need roughly double once aisles and circulation are counted. On-hand counts are the
August 28; NCCR corrected September 30 field inventory, standard items only; items without a clean field match show a dash and are
excluded from totals. WAREHOUSE lines are the Standard Items pallet sheet (7/22/2026): observed packout,
double-stack, approximate weight, and dimensions. Trailer weight caps compare that weight against a
45,000 lb planning payload — the
30-position cube benchmark no longer binds first when they appear.