Templates

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 temperatureNov 17, 7:00 PMMarisol Tennant-Ruiz178165
QC-26-002LOT-2640Metal detectorNov 17, 3:10 PMMarisol Tennant-Ruiz0—
QC-26-004LOT-2639Cook temperatureNov 16, 8:20 PMCassius Eberhardt-Lau161185
QC-26-003LOT-2639pHNov 16, 3:30 PMOdalric Sjoberg-Pike4.4—
QC-26-006LOT-2638Allergen swabNov 13, 4:00 PMMarisol Tennant-Ruiz15—
QC-26-005LOT-2638Metal detectorNov 13, 3:00 PMCassius Eberhardt-Lau0—
QC-26-007LOT-2637Cook temperatureNov 11, 4:40 PMCassius Eberhardt-Lau171165
QC-26-008LOT-2637Cooling temperatureNov 11, 3:30 PMOdalric Sjoberg-Pike63—
QC-26-009LOT-2636Metal detectorNov 10, 7:00 PMMarisol Tennant-Ruiz0—
QC-26-010LOT-2636Allergen swabNov 10, 4:30 PMMarisol Tennant-Ruiz12—
QC-26-011LOT-2635pHNov 9, 7:10 PMMarisol Tennant-Ruiz4.2—
QC-26-012LOT-2634Cook temperatureNov 5, 8: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 temperatureNov 17, 7:00 PMMarisol Tennant-Ruiz178165
QC-26-002LOT-2640Metal detectorNov 17, 3:10 PMMarisol Tennant-Ruiz0—
QC-26-004LOT-2639Cook temperatureNov 16, 8:20 PMCassius Eberhardt-Lau161185
QC-26-003LOT-2639pHNov 16, 3:30 PMOdalric Sjoberg-Pike4.4—
QC-26-006LOT-2638Allergen swabNov 13, 4:00 PMMarisol Tennant-Ruiz15—
QC-26-005LOT-2638Metal detectorNov 13, 3:00 PMCassius Eberhardt-Lau0—
QC-26-007LOT-2637Cook temperatureNov 11, 4:40 PMCassius Eberhardt-Lau171165
QC-26-008LOT-2637Cooling temperatureNov 11, 3:30 PMOdalric Sjoberg-Pike63—
QC-26-009LOT-2636Metal detectorNov 10, 7:00 PMMarisol Tennant-Ruiz0—
QC-26-010LOT-2636Allergen swabNov 10, 4:30 PMMarisol Tennant-Ruiz12—
QC-26-011LOT-2635pHNov 9, 7:10 PMMarisol Tennant-Ruiz4.2—
QC-26-012LOT-2634Cook temperatureNov 5, 8: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 fillingNov 17, 20261,200Awaiting releaseMeadowlark Poultry CooperativeQC-26-001, QC-26-002
LOT-2639Fire-roasted tomato salsaNov 16, 2026540On holdRivergate Produce GrowersQC-26-003, QC-26-004
LOT-2638Oat and honey granola barsNov 13, 2026720ReleasedFoxtail Mill and GrainQC-26-005, QC-26-006
LOT-2637Chilled red lentil soupNov 11, 2026480ReleasedFoxtail Mill and GrainQC-26-007, QC-26-008
LOT-2636Maple walnut granola clustersNov 10, 2026480ReleasedNorthwoods Maple CollectiveQC-26-009, QC-26-010
LOT-2635Pickled golden beetsNov 9, 2026600On holdSandhill Beet FarmQC-26-011
LOT-2634Smoked chicken pot pie fillingNov 5, 2026600ReleasedMeadowlark Poultry CooperativeQC-26-012, QC-26-013
LOT-2633Chilled red lentil soupNov 4, 2026540ReleasedFoxtail Mill and GrainQC-26-014, QC-26-015
LOT-2632Oat and honey granola barsNov 3, 2026800On holdFoxtail Mill and GrainQC-26-016, QC-26-017
LOT-2631Fire-roasted tomato salsaOct 30, 2026960ReleasedRivergate Produce GrowersQC-26-018, QC-26-019
LOT-2630Pickled golden beetsOct 29, 2026540ReleasedSandhill Beet FarmQC-26-020
LOT-2629Maple walnut granola clustersOct 28, 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.Jul 21, 2026
Kettle Bay Spice TradersCumin, paprika and spice blendsIngeborg Salvatierra-Moen(715) 555-0116Under reviewSpot pricing; quote requested after the missed certificate.Oct 29, 2026
Lakeshore Jar and ClosureGlass jars and lidsTorvald Oyelaran-Beck(715) 555-0117ApprovedPallet price with freight included; one reprice per year.Mar 23, 2026
Meadowlark Poultry CooperativeChicken thighs and breastWolfram Quillfeather(715) 555-0111ApprovedDelivered price per pound fixed through March; 2 percent for payment in 10 days.Apr 22, 2026
Northwoods Maple CollectiveMaple syrup, bulkPhilomena Ardagh-Nunez(715) 555-0114ApprovedAnnual volume tiers; the second tier starts at 400 gallons.Jan 22, 2026
Pinecone Corrugated PackagingShipping cartonsZephyrine Haldane-Okoro(715) 555-0118ApprovedNet 30; carton run minimum of 2,000.May 22, 2026
Rivergate Produce GrowersField tomatoesAnselm Harkonnen-Doyle(715) 555-0112ApprovedSeasonal contract at a fixed price per bushel; no minimum off season.Jun 21, 2026
Sandhill Beet FarmGolden beetsEmmerich Soltani(715) 555-0113ConditionalNet 30; price reset each October after harvest report.Sep 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 certificateIssued byNumberIssuedExpiresStatusRenewal fee
Backflow prevention test certificateMunicipal water utilityBF-77-3306Dec 10, 2025Dec 10, 2026Renewal due$120
Scale calibration certificateLicensed scale service companySC-0912-4Dec 21, 2025Dec 21, 2026Renewal due$210
Food processing plant licenseWisconsin food safety licensing officeFP-48-21173Dec 29, 2025Dec 29, 2026Renewal due$880
Organic handler certificateAccredited organic certifierOH-3380-12Jan 12, 2026Jan 12, 2027Renewal due$1,250
Fire inspection certificateEau Claire fire prevention bureauFI-26-0418Feb 21, 2026Feb 21, 2027Current$150
Metal detector verification certificateEquipment maker field serviceMD-6641Mar 18, 2026Mar 18, 2027Current$275
HACCP plan annual review sign-offOutside food safety consultantHP-26-0051May 17, 2026May 17, 2027Current$950
Retail food establishment permitEau Claire city health departmentRF-2209-07Jun 16, 2026Jun 16, 2027Current$345
Pest control service certificateLicensed pest control contractorPC-8821-3Aug 14, 2026Aug 15, 2027Current$180
Wastewater discharge permitRegional sanitary districtWD-19-5528Sep 14, 2026Sep 14, 2027Current$640

Also included

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

Questions

What is included in the Food manufacturer: Drumlin Row Foods template?
5 tables (Quality checks, Production lots, Products, Suppliers and Licenses and certificates), filled with 81 sample rows so every view opens with realistic data.
Is the Food manufacturer: Drumlin Row Foods template free?
Yes. Sign up free, press Use this template, and a full copy is added to your workspace.
Can I change the template after I use it?
Yes. Every page, table, column and view in your copy is yours to rename, edit or delete, and the sample rows can be cleared.