AI Matrx Logo

Coffee roaster

Gannet Wharf Roasters · Coffee roaster · Portland, ME

Owen Mbeki roasts for twenty wholesale cafés at Gannet Wharf Roasters in Portland, Maine, and he uses this to track every lot of green coffee, each roast batch and the weekly standing orders so he never runs out of a coffee a café depends on.

Food and hospitalityInventoryDimensions5 tables · 6 views · 1 form · 2 dimension sets · 1 dashboard · 1 drill-down · 1 digest · 1 agent
Use this template

Lot board

Green coffee
Incoming4
Embu PeaberryGL-2618Kenya
Naranjo NaturalGL-2619Costa Rica
Cerrado DulceGL-2620Brazil
Aricha WashedGL-2621Ethiopia
In stock20
Cerrado Fazenda AlvoradaGL-2515Brazil
Tarrazu La PastoraGL-2516Costa Rica
Cajamarca Cooperative Lot 4GL-2518Peru
Gakenke HillsGL-2601Rwanda
Decaf Sugarcane ColombiaGL-2602Colombia
15 more
Low2
Nyeri Gatomboya AAGL-2514Kenya
Mandheling LintongGL-2519Sumatra
Finished4
Huila Pink BourbonGL-2511Colombia
Yirgacheffe KongaGL-2512Ethiopia
Antigua Santa ClaraGL-2513Guatemala
Sidama Bensa NaturalGL-2517Ethiopia

Tables

Green coffee

30 sample rows · 15 columns

Every lot of green coffee from the day it is bought to the day the last bag is roasted, with the count on the rack.

CoffeeLot codeOriginProcessImporterArrivedKg received
Aricha WashedGL-2621EthiopiaWashedQuillfeather Coffee TradingNov 13, 2026276
Cerrado DulceGL-2620BrazilNaturalMosswood Direct ImportsNov 6, 2026690
Naranjo NaturalGL-2619Costa RicaNaturalFenwick Bay Green CoffeeOct 30, 2026414
Embu PeaberryGL-2618KenyaWashedTidewater Green ImportersOct 24, 2026276
Cauca PopayanGL-2617ColombiaWashedCobalt Ridge Cooperative ExchangeOct 4, 2026552
Chelba WashedGL-2616EthiopiaWashedQuillfeather Coffee TradingSep 22, 2026138
Mogiana Sul de MinasGL-2615BrazilNaturalMosswood Direct ImportsSep 10, 2026690
Nyamasheke NaturalGL-2614RwandaNaturalFenwick Bay Green CoffeeAug 29, 2026276
Tolima PlanadasGL-2613ColombiaNaturalTidewater Green ImportersAug 15, 2026414
Atitlan Volcanic SlopesGL-2612GuatemalaHoneyRedcliff Origin PartnersAug 3, 2026552
Kochere WashedGL-2611EthiopiaWashedQuillfeather Coffee TradingJul 20, 2026276
Gayo HighlandsGL-2610SumatraWet-hulledMosswood Direct ImportsJul 10, 2026690

18 more rows

Importers

6 sample rows · 9 columns

The green coffee importers Owen buys from: the rep to call, terms and how long a shipment takes.

ImporterRepRep's cellRep's emailTermsLead daysOur account no.
Cobalt Ridge Cooperative ExchangeHenrik Salazar-Boyd(207) 555-0126henrik@cobaltridgeexchange.orgNet 1518CRC-9047
Fenwick Bay Green CoffeeOttoline Brennagh(207) 555-0125ottoline@fenwickbaygreen.comNet 308FBG-3356
Mosswood Direct ImportsEvander Thackeray(207) 555-0124evander@mosswooddirect.comPrepaid16MDI-5502
Quillfeather Coffee TradingAnselm Brodsky(207) 555-0122anselm@quillfeathertrading.comNet 1514QCT-7731
Redcliff Origin PartnersZephyrine Calloway(207) 555-0123zephyrine@redcliffoptn.comNet 3011ROP-1190
Tidewater Green ImportersPerpetua Haldorsen(207) 555-0121perpetua@tidewatergreen.netNet 309TGI-40218

Roast log

69 sample rows · 7 columns

Each batch off the drum, with the green weight in and the roasted weight out.

BatchGreen lotRoastedProfileGreen kg inRoasted kg outRoasted by
RB-4169Cauca PopayanOct 15, 2026Espresso6051Callum Teague
RB-4168Chelba WashedOct 7, 2026Filter light3630.2Priya Ostrander
RB-4167Mogiana Sul de MinasOct 6, 2026Medium6050.4Priya Ostrander
RB-4162Atitlan Volcanic SlopesSep 28, 2026Medium5043Owen Mbeki
RB-4164Tolima PlanadasSep 27, 2026Medium3530.1Owen Mbeki
RB-4166Mogiana Sul de MinasSep 27, 2026Medium6052.2Priya Ostrander
RB-4165Nyamasheke NaturalSep 25, 2026Medium4034.4Owen Mbeki
RB-4158Gayo HighlandsSep 22, 2026Espresso6050.4Priya Ostrander
RB-4141Huehuetenango IxbalamSep 21, 2026Filter light6050.4Priya Ostrander
RB-4145Minas Gerais Pulped NaturalSep 18, 2026Medium6050.4Priya Ostrander
RB-4153Chanchamayo SelectSep 18, 2026Filter light5043Owen Mbeki
RB-4150Narino BuesacoSep 16, 2026Filter light6051Callum Teague

57 more rows

Standing orders

20 sample rows · 12 columns

The weekly coffee each café has on standing order: how many kilos, which coffee, which day.

Standing orderCaféContactContact's phoneCoffeeKg per weekPrice per kg
Bridle Path Books & Brew — Breakfast BlendBridle Path Books & BrewLeopold Nakamura-Cole(207) 555-0140Breakfast Blend7$18
Cormorant Coffee Cart — House EspressoCormorant Coffee CartYvette Lindgren-Banda(207) 555-0145House Espresso5$20
Corner Mug Café — House EspressoCorner Mug CaféHestia Quarrington(207) 555-0130House Espresso12$19.50
Driftwood Bagel Works — Breakfast BlendDriftwood Bagel WorksCormac Iyengar(207) 555-0144Breakfast Blend13$17.50
Fernwick Espresso — House EspressoFernwick EspressoSoledad Marchetti-Wu(207) 555-0135House Espresso16$19
Foxglove Breakfast Club — House EspressoFoxglove Breakfast ClubAmbrose Fitzwilliam(207) 555-0148House Espresso8$19
Gable & Grain Bakery Café — Breakfast BlendGable & Grain Bakery CaféLucan Mortensen(207) 555-0134Breakfast Blend14$17.50
Halcyon Diner — Dark RoastHalcyon DinerMirabel Santangelo(207) 555-0141Dark Roast15$16.50
Ironbark Climbing Gym Café — Dark RoastIronbark Climbing Gym CaféLeander Pruitt(207) 555-0146Dark Roast6$17
Lanternfish Café — Single-origin FilterLanternfish CaféWendeline Okafor-Reyes(207) 555-0133Single-origin Filter6$23.50
Linnet Lane Tea & Coffee — Single-origin FilterLinnet Lane Tea & CoffeeAnneliese Cardoso(207) 555-0147Single-origin Filter4$23.50
Marrow & Bean — Single-origin FilterMarrow & BeanPhilippa Dlamini(207) 555-0137Single-origin Filter8$23

8 more rows

Also included

  • Green coffee by origin and statusDrill-down
  • Lots running lowDigest

Related templates