Food manufacturer

Drumlin Row Foods · Food manufacturer · Eau Claire, WI

Bram Lorenzetti is the plant manager at Drumlin Row Foods, a small food manufacturer in Eau Claire, and he uses it to hold every license, lot check and supplier approval in one place so an inspector's request never sends him digging through binders.

Manufacturing ComplianceGoverned columns6 tables · 7 views · 1 form · 2 dimension sets · 1 dashboard · 1 digest · 1 notification · 1 agent

Use this template

Check log

Quality checks

Check number	Lot	Check	Checked	Checked by	Reading	Lowest allowed
QC-26-001	LOT-2640	Cook temperature	Oct 16, 6:00 PM	Marisol Tennant-Ruiz	178	165
QC-26-002	LOT-2640	Metal detector	Oct 16, 2:10 PM	Marisol Tennant-Ruiz	0	—
QC-26-004	LOT-2639	Cook temperature	Oct 15, 7:20 PM	Cassius Eberhardt-Lau	161	185
QC-26-003	LOT-2639	pH	Oct 15, 2:30 PM	Odalric Sjoberg-Pike	4.4	—
QC-26-006	LOT-2638	Allergen swab	Oct 14, 3:00 PM	Marisol Tennant-Ruiz	15	—
QC-26-005	LOT-2638	Metal detector	Oct 14, 2:00 PM	Cassius Eberhardt-Lau	0	—
QC-26-007	LOT-2637	Cook temperature	Oct 12, 3:40 PM	Cassius Eberhardt-Lau	171	165
QC-26-008	LOT-2637	Cooling temperature	Oct 12, 2:30 PM	Odalric Sjoberg-Pike	63	—
QC-26-009	LOT-2636	Metal detector	Oct 9, 6:00 PM	Marisol Tennant-Ruiz	0	—
QC-26-010	LOT-2636	Allergen swab	Oct 9, 3:30 PM	Marisol Tennant-Ruiz	12	—
QC-26-011	LOT-2635	pH	Oct 8, 6:10 PM	Marisol Tennant-Ruiz	4.2	—
QC-26-012	LOT-2634	Cook temperature	Oct 6, 7:10 PM	Marisol Tennant-Ruiz	178	165

25 more rows

Tables

Quality checks

37 sample rows · 11 columns

Every temperature, pH, metal-detector and allergen check taken on a lot, with the limit it was held to.

Check number	Lot	Check	Checked	Checked by	Reading	Lowest allowed
QC-26-001	LOT-2640	Cook temperature	Oct 16, 6:00 PM	Marisol Tennant-Ruiz	178	165
QC-26-002	LOT-2640	Metal detector	Oct 16, 2:10 PM	Marisol Tennant-Ruiz	0	—
QC-26-004	LOT-2639	Cook temperature	Oct 15, 7:20 PM	Cassius Eberhardt-Lau	161	185
QC-26-003	LOT-2639	pH	Oct 15, 2:30 PM	Odalric Sjoberg-Pike	4.4	—
QC-26-006	LOT-2638	Allergen swab	Oct 14, 3:00 PM	Marisol Tennant-Ruiz	15	—
QC-26-005	LOT-2638	Metal detector	Oct 14, 2:00 PM	Cassius Eberhardt-Lau	0	—
QC-26-007	LOT-2637	Cook temperature	Oct 12, 3:40 PM	Cassius Eberhardt-Lau	171	165
QC-26-008	LOT-2637	Cooling temperature	Oct 12, 2:30 PM	Odalric Sjoberg-Pike	63	—
QC-26-009	LOT-2636	Metal detector	Oct 9, 6:00 PM	Marisol Tennant-Ruiz	0	—
QC-26-010	LOT-2636	Allergen swab	Oct 9, 3:30 PM	Marisol Tennant-Ruiz	12	—
QC-26-011	LOT-2635	pH	Oct 8, 6:10 PM	Marisol Tennant-Ruiz	4.2	—
QC-26-012	LOT-2634	Cook temperature	Oct 6, 7:10 PM	Marisol Tennant-Ruiz	178	165

25 more rows

Production lots

20 sample rows · 9 columns

Each batch the plant made, what it was, and whether it can ship.

Lot code	Product	Produced	Units made	Lot status	Key ingredient from	Quality checks
LOT-2640	Smoked chicken pot pie filling	Oct 16, 2026	1,200	Awaiting release	Meadowlark Poultry Cooperative	QC-26-001, QC-26-002
LOT-2639	Fire-roasted tomato salsa	Oct 15, 2026	540	On hold	Rivergate Produce Growers	QC-26-003, QC-26-004
LOT-2638	Oat and honey granola bars	Oct 14, 2026	720	Released	Foxtail Mill and Grain	QC-26-005, QC-26-006
LOT-2637	Chilled red lentil soup	Oct 12, 2026	480	Released	Foxtail Mill and Grain	QC-26-007, QC-26-008
LOT-2636	Maple walnut granola clusters	Oct 9, 2026	480	Released	Northwoods Maple Collective	QC-26-009, QC-26-010
LOT-2635	Pickled golden beets	Oct 8, 2026	600	On hold	Sandhill Beet Farm	QC-26-011
LOT-2634	Smoked chicken pot pie filling	Oct 6, 2026	600	Released	Meadowlark Poultry Cooperative	QC-26-012, QC-26-013
LOT-2633	Chilled red lentil soup	Oct 5, 2026	540	Released	Foxtail Mill and Grain	QC-26-014, QC-26-015
LOT-2632	Oat and honey granola bars	Oct 2, 2026	800	On hold	Foxtail Mill and Grain	QC-26-016, QC-26-017
LOT-2631	Fire-roasted tomato salsa	Sep 30, 2026	960	Released	Rivergate Produce Growers	QC-26-018, QC-26-019
LOT-2630	Pickled golden beets	Sep 29, 2026	540	Released	Sandhill Beet Farm	QC-26-020
LOT-2629	Maple walnut granola clusters	Sep 28, 2026	720	Released	Northwoods Maple Collective	QC-26-021, QC-26-022

8 more rows

Products

6 sample rows · 4 columns

What the plant makes, what each product contains and how it is made.

Product	Contains	Recipe card	Shelf life (days)
Chilled red lentil soup	—	Simmer 40 minutes; 1.2 percent cumin blend; blast chill within 2 hours.	9
Fire-roasted tomato salsa	—	Roast tomatoes 11 minutes, 2.1 percent vinegar to reach pH 4.2; hot fill at 190F.	18
Maple walnut granola clusters	Tree nut	Maple glaze 18 percent; toast walnuts 8 minutes; cool before packing.	45
Oat and honey granola bars	WheatTree nut	Bind at 22 percent honey syrup; bake 22 minutes at 325F; cut after 40 minutes.	30
Pickled golden beets	—	Brine 5 percent vinegar, 3 percent sugar; fill cold, pasteurize 25 minutes.	40
Smoked chicken pot pie filling	MilkWheat	Hold 40 percent stock, 14 percent smoked chicken, roux at 6 percent; fill hot at 190F.	24

Suppliers

8 sample rows · 8 columns

The vendors approved to sell the plant ingredients and packaging.

Supplier	Supplies	Contact	Phone	Approval	Pricing terms	Last audited
Foxtail Mill and Grain	Rolled oats and wheat flour	Barnabas Quigley-Tan	(715) 555-0115	Approved	Net 15; bulk tote discount of 4 percent over six totes.	Jun 20, 2026
Kettle Bay Spice Traders	Cumin, paprika and spice blends	Ingeborg Salvatierra-Moen	(715) 555-0116	Under review	Spot pricing; quote requested after the missed certificate.	Sep 28, 2026
Lakeshore Jar and Closure	Glass jars and lids	Torvald Oyelaran-Beck	(715) 555-0117	Approved	Pallet price with freight included; one reprice per year.	Feb 20, 2026
Meadowlark Poultry Cooperative	Chicken thighs and breast	Wolfram Quillfeather	(715) 555-0111	Approved	Delivered price per pound fixed through March; 2 percent for payment in 10 days.	Mar 22, 2026
Northwoods Maple Collective	Maple syrup, bulk	Philomena Ardagh-Nunez	(715) 555-0114	Approved	Annual volume tiers; the second tier starts at 400 gallons.	Dec 22, 2025
Pinecone Corrugated Packaging	Shipping cartons	Zephyrine Haldane-Okoro	(715) 555-0118	Approved	Net 30; carton run minimum of 2,000.	Apr 21, 2026
Rivergate Produce Growers	Field tomatoes	Anselm Harkonnen-Doyle	(715) 555-0112	Approved	Seasonal contract at a fixed price per bushel; no minimum off season.	May 21, 2026
Sandhill Beet Farm	Golden beets	Emmerich Soltani	(715) 555-0113	Conditional	Net 30; price reset each October after harvest report.	Aug 19, 2026

Licenses and certificates

10 sample rows · 9 columns

Every license, permit and certificate an inspector would ask to see, with when it ends.

License or certificate	Issued by	Number	Issued	Expires	Status	Renewal fee
Backflow prevention test certificate	Municipal water utility	BF-77-3306	Nov 9, 2025	Nov 9, 2026	Renewal due	$120
Scale calibration certificate	Licensed scale service company	SC-0912-4	Nov 20, 2025	Nov 20, 2026	Renewal due	$210
Food processing plant license	Wisconsin food safety licensing office	FP-48-21173	Nov 28, 2025	Nov 28, 2026	Renewal due	$880
Organic handler certificate	Accredited organic certifier	OH-3380-12	Dec 12, 2025	Dec 12, 2026	Renewal due	$1,250
Fire inspection certificate	Eau Claire fire prevention bureau	FI-26-0418	Jan 21, 2026	Jan 21, 2027	Current	$150
Metal detector verification certificate	Equipment maker field service	MD-6641	Feb 15, 2026	Feb 15, 2027	Current	$275
HACCP plan annual review sign-off	Outside food safety consultant	HP-26-0051	Apr 16, 2026	Apr 16, 2027	Current	$950
Retail food establishment permit	Eau Claire city health department	RF-2209-07	May 16, 2026	May 16, 2027	Current	$345
Pest control service certificate	Licensed pest control contractor	PC-8821-3	Jul 14, 2026	Jul 15, 2027	Current	$180
Wastewater discharge permit	Regional sanitary district	WD-19-5528	Aug 14, 2026	Aug 14, 2027	Current	$640

Also included

License coming dueNotificationTells the person responsible a month before a license ends.
Renewals due each MondayDigest

Freight brokeragePinecrest Junction Freight4 tables · 5 views · 2 forms · 2 dimension sets · 2 drill-downs · 1 digest · 1 notification · 1 stage rule set · 1 agentDimensions

Quality labVerrowick Surgical Components6 tables · 9 views · 1 form · 2 dimension sets · 1 dashboard · 1 document · 1 notification · 1 stage rule set · 1 agentGoverned columns

Apparel makerTidewell Way Apparel4 tables · 6 views · 1 form · 1 dimension set · 1 booking page · 1 portal · 1 dashboard · 1 digest · 1 notification · 1 stage rule set · 1 agentCalendar

Brewery productionCindervale Row Brewworks4 tables · 6 views · 1 form · 1 dashboard · 1 digest · 1 notification · 1 agentImports

DS-1414 pre-trip, 06:02	—	93,418
DS-1439 pre-trip, 05:55	—	134,005
DS-1506 pre-trip, 05:26	—	48,756
DS-1499 pre-trip, 06:43	—	129,509

Broker operating authority, Pinecrest Junction Freight	PJ-1001	Broker operating authority
Surety bond (BMC-84), Pinecrest Junction Freight	PJ-1002	Surety bond (BMC-84)
Contingent cargo policy, Pinecrest Junction Freight	PJ-1003	Contingent cargo policy
Carrier insurance certificate, Tallgrass Hauling Company	PJ-1004	Carrier insurance certificate

Halyard: harbor tee, fall restock	TW-4200	Isaura Venkataraman-Cole
Tern: ropewalk hoodie, winter pre-order	TW-4201	Brodie Achterberg
Gullwing: market tote, holiday giveaway	TW-4202	Nkechi Halloran-Dube
Skerry: cove crewneck sweatshirt, first order	TW-4203	Philomena Eastwick

Hazy Lantern is back on tap	CP-26-601	Beer release post
October at the taproom: new pours and a retirement party	CP-26-602	Taproom newsletter
Smokestack Porter returns for the cold months	CP-26-603	Beer release post
What goes into a pilsner that takes six weeks	CP-26-604	Brewing blog

DC-2401 Fleece pullover hoodie	240	—
DC-2402 Heavy cotton tee	400	—
DC-2403 Kids' organic cotton pajama set	180	—
DC-2404 Baby bodysuit with snaps	300	—

RL-26-0493	—	40
RL-26-0491	—	24
RL-26-0499	—	150
RL-26-0487	—	5,000

Check log

Tables

Quality checks

Production lots

Products

Suppliers

Licenses and certificates

Also included

Related templates