Bushwick Daily · Playbook/Phase 3

Grocery Price Index

Phase 3 · Methodology & Field Plan

Methodology & Field Plan

The rulebook that makes the comparison trustworthy. Lock it before fieldwork; both of you follow it identically. Verify the seeded basket and stores — don't inherit them blindly.

Prepared by *
Date

A. Research question & index definition

Restate the question your index answers
Define "the index" precisely

A price table isn't an index until you define the comparison. A common shape: (1) the total basket cost per store, and (2) each store scored against the cheapest = 100, so 130 means 30% dearer. Add per-category sub-indexes if they earn their place. Decide it deliberately — this definition is load-bearing.

B. Basket of goods

Seeded from the 2017 and 2021 baskets so the 2026 numbers stay comparable. Verify every row, set a brand rule and a size/unit so it's the same thing at every store, and add anything the neighborhood shops now that the old baskets missed. Keep an item unless you have a written reason to drop it.
Beer row: you may be under 21 — photograph the shelf tag only, never purchase, or drop the item and say why.
Lock a spec for every included item
ItemCat.Incl?Brand ruleSize / unit + basisPrice typeNotesSrc
ApplesProduce2017
BananasProduce2021
CarrotsProduce2017
TomatoesProduce2017
KaleProduce2017/21
SpinachProduce2021
BreadPantry2017
Peanut butterPantry2017/21
HoneyPantry2017
RicePantry2017
CoffeePantry2017/21
Canned black beansPantry2017
MilkDairy2021
Half & halfDairy2017
ButterDairy2017
Cheddar cheeseDairy2021
Greek yogurtDairy2017
EggsDairy2017/21
TofuProtein2017
Chicken breastProtein2017/21
Beer — Six Point Sweet ActionOther2017
Justify anything you dropped or added versus the prior baskets

C. Store list & map

Seeded from the prior pieces — but some may have closed since 2021, so verify each one. Add at least two bodegas, decide on delivery apps, assign every store to one of you, set a visit date, and plot them on a Google My Map.
Verify, assign, and schedule each store
StoreAddressType / tier$Open?AssignedVisit
Food BazaarLarge discount chain$
Key FoodMid supermarket (Urban Meadow)$$
City Fresh MarketMid supermarket$$
Associated SupermarketMid / affordable chain$$
Shop FairMid supermarket$$
Met FreshSmall family-owned$$
Billy's Marketplace (C-Town)Mid supermarket$$
Mr. Kiwi's (Mr. Fruit)Produce-focused mini grocery$$
Mr. Lemon (Mr. Fruit)Produce-focused mini grocery$$
Food Story Natural MarketPremium / natural$$$
Hana NaturalPremium / organic$$$
Whole FoodsNational premium (Amazon)$$$
Brooklyn's NaturalPremium / natural — may be closed?
Bodega #1 (you choose)Bodega$$
Bodega #2 (you choose)Bodega$$
Delivery app (if in scope)Delivery appn/a
Store-selection rationale — how you cover the economic range

Span cheap to premium: discount chain, mid supermarket, produce specialist, premium/natural, bodega, national chain, and — if in scope — delivery.

Bodegas: which two, and why those
Delivery apps: in or out? If in, which, and how priced?

If in scope, price the same basket and record fees, markups, and delivery minimums separately so they don't skew the in-store index.

Link to your Google My Map

D. Your collection protocol — decide the rules, then both follow them

These are the rules that make the data comparable. Write them yourselves — don't wait to improvise in a store aisle. Both collectors follow the identical protocol, or the comparison breaks.
Date window

How few days can you collect the whole basket across, and how will you record the date and time of every price?

Which price you record

When a shelf shows a regular price, a sale, a loyalty price, and a unit price — which is your primary basket number, and how do you log the others so they don't distort it?

Substitution rule

Write it once, both follow it: when the exact spec isn't stocked, what exactly do you do? (e.g., cheapest comparable brand at the same size, clearly flagged — or mark N/A.)

Photo protocol & fallback

How many photos per item and of what? What's the plan if a store won't allow photos?

Anything else your method needs to stay honest

What did the prior pieces trip on that you'll handle up front? (Per-lb weighing, one price row per item per store, etc.)

E. Roles, route & logistics

Who takes which stores, when, and how they get there
StoreAssigned toPlanned dateRoute / transit notes
Safety & logistics notes

Buddy up for fieldwork where you can, plan routes, keep phones charged, upload photos the same day.

Coordinator review

The Coordinator (who also edits) records the decision here. You don't start the next phase until this reads Approve.

Decision
Notes / what to fix
Reviewed by
Date
Your work autosaves in this browser.