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.

ManufacturingComplianceGoverned 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 numberLotCheckCheckedChecked byReadingLowest allowed
QC-26-001LOT-2640Cook temperatureOct 2, 6:00 PMMarisol Tennant-Ruiz178165
QC-26-002LOT-2640Metal detectorOct 2, 2:10 PMMarisol Tennant-Ruiz0—
QC-26-004LOT-2639Cook temperatureOct 1, 7:20 PMCassius Eberhardt-Lau161185
QC-26-003LOT-2639pHOct 1, 2:30 PMOdalric Sjoberg-Pike4.4—
QC-26-006LOT-2638Allergen swabSep 30, 3:00 PMMarisol Tennant-Ruiz15—
QC-26-005LOT-2638Metal detectorSep 30, 2:00 PMCassius Eberhardt-Lau0—
QC-26-007LOT-2637Cook temperatureSep 28, 3:40 PMCassius Eberhardt-Lau171165
QC-26-008LOT-2637Cooling temperatureSep 28, 2:30 PMOdalric Sjoberg-Pike63—
QC-26-009LOT-2636Metal detectorSep 25, 6:00 PMMarisol Tennant-Ruiz0—
QC-26-010LOT-2636Allergen swabSep 25, 3:30 PMMarisol Tennant-Ruiz12—
QC-26-011LOT-2635pHSep 24, 6:10 PMMarisol Tennant-Ruiz4.2—
QC-26-012LOT-2634Cook temperatureSep 22, 7:10 PMMarisol Tennant-Ruiz178165

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 numberLotCheckCheckedChecked byReadingLowest allowed
QC-26-001LOT-2640Cook temperatureOct 2, 6:00 PMMarisol Tennant-Ruiz178165
QC-26-002LOT-2640Metal detectorOct 2, 2:10 PMMarisol Tennant-Ruiz0—
QC-26-004LOT-2639Cook temperatureOct 1, 7:20 PMCassius Eberhardt-Lau161185
QC-26-003LOT-2639pHOct 1, 2:30 PMOdalric Sjoberg-Pike4.4—
QC-26-006LOT-2638Allergen swabSep 30, 3:00 PMMarisol Tennant-Ruiz15—
QC-26-005LOT-2638Metal detectorSep 30, 2:00 PMCassius Eberhardt-Lau0—
QC-26-007LOT-2637Cook temperatureSep 28, 3:40 PMCassius Eberhardt-Lau171165
QC-26-008LOT-2637Cooling temperatureSep 28, 2:30 PMOdalric Sjoberg-Pike63—
QC-26-009LOT-2636Metal detectorSep 25, 6:00 PMMarisol Tennant-Ruiz0—
QC-26-010LOT-2636Allergen swabSep 25, 3:30 PMMarisol Tennant-Ruiz12—
QC-26-011LOT-2635pHSep 24, 6:10 PMMarisol Tennant-Ruiz4.2—
QC-26-012LOT-2634Cook temperatureSep 22, 7:10 PMMarisol Tennant-Ruiz178165

25 more rows

Production lots

20 sample rows · 9 columns

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

Lot codeProductProducedUnits madeLot statusKey ingredient fromQuality checks
LOT-2640Smoked chicken pot pie fillingOct 2, 20261,200Awaiting releaseMeadowlark Poultry CooperativeQC-26-001, QC-26-002
LOT-2639Fire-roasted tomato salsaOct 1, 2026540On holdRivergate Produce GrowersQC-26-003, QC-26-004
LOT-2638Oat and honey granola barsSep 30, 2026720ReleasedFoxtail Mill and GrainQC-26-005, QC-26-006
LOT-2637Chilled red lentil soupSep 28, 2026480ReleasedFoxtail Mill and GrainQC-26-007, QC-26-008
LOT-2636Maple walnut granola clustersSep 25, 2026480ReleasedNorthwoods Maple CollectiveQC-26-009, QC-26-010
LOT-2635Pickled golden beetsSep 24, 2026600On holdSandhill Beet FarmQC-26-011
LOT-2634Smoked chicken pot pie fillingSep 22, 2026600ReleasedMeadowlark Poultry CooperativeQC-26-012, QC-26-013
LOT-2633Chilled red lentil soupSep 21, 2026540ReleasedFoxtail Mill and GrainQC-26-014, QC-26-015
LOT-2632Oat and honey granola barsSep 18, 2026800On holdFoxtail Mill and GrainQC-26-016, QC-26-017
LOT-2631Fire-roasted tomato salsaSep 16, 2026960ReleasedRivergate Produce GrowersQC-26-018, QC-26-019
LOT-2630Pickled golden beetsSep 15, 2026540ReleasedSandhill Beet FarmQC-26-020
LOT-2629Maple walnut granola clustersSep 14, 2026720ReleasedNorthwoods Maple CollectiveQC-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.

ProductContainsRecipe cardShelf 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 clustersTree nutMaple glaze 18 percent; toast walnuts 8 minutes; cool before packing.45
Oat and honey granola barsWheatTree nutBind 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 fillingMilkWheatHold 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.

SupplierSuppliesContactPhoneApprovalPricing termsLast audited
Foxtail Mill and GrainRolled oats and wheat flourBarnabas Quigley-Tan(715) 555-0115ApprovedNet 15; bulk tote discount of 4 percent over six totes.Jun 7, 2026
Kettle Bay Spice TradersCumin, paprika and spice blendsIngeborg Salvatierra-Moen(715) 555-0116Under reviewSpot pricing; quote requested after the missed certificate.Sep 15, 2026
Lakeshore Jar and ClosureGlass jars and lidsTorvald Oyelaran-Beck(715) 555-0117ApprovedPallet price with freight included; one reprice per year.Feb 7, 2026
Meadowlark Poultry CooperativeChicken thighs and breastWolfram Quillfeather(715) 555-0111ApprovedDelivered price per pound fixed through March; 2 percent for payment in 10 days.Mar 9, 2026
Northwoods Maple CollectiveMaple syrup, bulkPhilomena Ardagh-Nunez(715) 555-0114ApprovedAnnual volume tiers; the second tier starts at 400 gallons.Dec 9, 2025
Pinecone Corrugated PackagingShipping cartonsZephyrine Haldane-Okoro(715) 555-0118ApprovedNet 30; carton run minimum of 2,000.Apr 8, 2026
Rivergate Produce GrowersField tomatoesAnselm Harkonnen-Doyle(715) 555-0112ApprovedSeasonal contract at a fixed price per bushel; no minimum off season.May 8, 2026
Sandhill Beet FarmGolden beetsEmmerich Soltani(715) 555-0113ConditionalNet 30; price reset each October after harvest report.Aug 6, 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 certificateIssued byNumberIssuedExpiresStatusRenewal fee
Backflow prevention test certificateMunicipal water utilityBF-77-3306Oct 27, 2025Oct 27, 2026Renewal due$120
Scale calibration certificateLicensed scale service companySC-0912-4Nov 7, 2025Nov 7, 2026Renewal due$210
Food processing plant licenseWisconsin food safety licensing officeFP-48-21173Nov 15, 2025Nov 15, 2026Renewal due$880
Organic handler certificateAccredited organic certifierOH-3380-12Nov 29, 2025Nov 29, 2026Renewal due$1,250
Fire inspection certificateEau Claire fire prevention bureauFI-26-0418Jan 8, 2026Jan 8, 2027Current$150
Metal detector verification certificateEquipment maker field serviceMD-6641Feb 2, 2026Feb 2, 2027Current$275
HACCP plan annual review sign-offOutside food safety consultantHP-26-0051Apr 3, 2026Apr 3, 2027Current$950
Retail food establishment permitEau Claire city health departmentRF-2209-07May 3, 2026May 3, 2027Current$345
Pest control service certificateLicensed pest control contractorPC-8821-3Jul 1, 2026Jul 2, 2027Current$180
Wastewater discharge permitRegional sanitary districtWD-19-5528Aug 1, 2026Aug 1, 2027Current$640

Views

Lot board

Production lots
Awaiting release1
LOT-2640Smoked chicken pot pie fillingOct 2, 2026
Released16
LOT-2638Oat and honey granola barsSep 30, 2026
LOT-2637Chilled red lentil soupSep 28, 2026
LOT-2636Maple walnut granola clustersSep 25, 2026
LOT-2634Smoked chicken pot pie fillingSep 22, 2026
LOT-2633Chilled red lentil soupSep 21, 2026
11 more
On hold3
LOT-2639Fire-roasted tomato salsaOct 1, 2026
LOT-2635Pickled golden beetsSep 24, 2026
LOT-2632Oat and honey granola barsSep 18, 2026

Forms and booking

Log a quality check

Form
Log a quality checkThe sheet the line lead fills in at the kettle, the filler or the packing table.
Which number is printed on this log sheet? *
Which lot is being checked?
What kind of check is this? *Cook temperatureCooling temperaturepHMetal detectorAllergen swab
Who took the reading?
What did the instrument read? *
Did the reading stay inside the limit? *PassFail
If it failed, what was done about it?Written for the inspector; kept from the AI.
Save check

Dashboards

Quality and compliance

Quality checks
Checks by result
  • Pass36
  • Fail1
Checks by kind
  • Cook temperature10
  • Metal detector11
  • pH6
  • Allergen swab7
  • Cooling temperature3
Checks per week
  • Aug 23, 20262
  • Aug 30, 20267
  • Sep 6, 20266
  • Sep 13, 20267
  • Sep 20, 20267
  • Sep 27, 20268

Also included

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