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 TradingOct 31, 2026276
Cerrado DulceGL-2620BrazilNaturalMosswood Direct ImportsOct 24, 2026690
Naranjo NaturalGL-2619Costa RicaNaturalFenwick Bay Green CoffeeOct 17, 2026414
Embu PeaberryGL-2618KenyaWashedTidewater Green ImportersOct 11, 2026276
Cauca PopayanGL-2617ColombiaWashedCobalt Ridge Cooperative ExchangeSep 21, 2026552
Chelba WashedGL-2616EthiopiaWashedQuillfeather Coffee TradingSep 9, 2026138
Mogiana Sul de MinasGL-2615BrazilNaturalMosswood Direct ImportsAug 28, 2026690
Nyamasheke NaturalGL-2614RwandaNaturalFenwick Bay Green CoffeeAug 16, 2026276
Tolima PlanadasGL-2613ColombiaNaturalTidewater Green ImportersAug 2, 2026414
Atitlan Volcanic SlopesGL-2612GuatemalaHoneyRedcliff Origin PartnersJul 21, 2026552
Kochere WashedGL-2611EthiopiaWashedQuillfeather Coffee TradingJul 7, 2026276
Gayo HighlandsGL-2610SumatraWet-hulledMosswood Direct ImportsJun 27, 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 2, 2026Espresso6051Callum Teague
RB-4168Chelba WashedSep 24, 2026Filter light3630.2Priya Ostrander
RB-4167Mogiana Sul de MinasSep 23, 2026Medium6050.4Priya Ostrander
RB-4162Atitlan Volcanic SlopesSep 15, 2026Medium5043Owen Mbeki
RB-4164Tolima PlanadasSep 14, 2026Medium3530.1Owen Mbeki
RB-4166Mogiana Sul de MinasSep 14, 2026Medium6052.2Priya Ostrander
RB-4165Nyamasheke NaturalSep 12, 2026Medium4034.4Owen Mbeki
RB-4158Gayo HighlandsSep 9, 2026Espresso6050.4Priya Ostrander
RB-4141Huehuetenango IxbalamSep 8, 2026Filter light6050.4Priya Ostrander
RB-4145Minas Gerais Pulped NaturalSep 5, 2026Medium6050.4Priya Ostrander
RB-4153Chanchamayo SelectSep 5, 2026Filter light5043Owen Mbeki
RB-4150Narino BuesacoSep 3, 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

Forms and booking

Receive a green lot

Form
Receive a green lotWhat Priya fills in at the dock when a pallet of green coffee arrives.
What is the coffee called on the bag tag? *
Which lot code goes on it? *GL- and four digits.
Which country is it from? *ColombiaEthiopiaGuatemalaKenyaBrazilCosta RicaPeruSumatra
How was it processed?WashedNaturalHoneyWet-hulled
Which importer shipped it?
How many kilos came in? *
What did it cost per kilo landed?
What day did it arrive?
Log the lot

Dashboards

Green room

Green coffee
Lots by status
  • Finished4
  • Low2
  • In stock20
  • Incoming4
Kg on hand by origin
  • Colombia1,290
  • Ethiopia739
  • Guatemala672
  • Kenya467
  • Brazil1,750
  • Costa Rica753
  • Peru436
  • Sumatra575
Kg weekly on standing order0

Also included

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

Related templates