351 : Pro Tips for Using Spreadsheets w/ Maxwell Mooney, Narrative Coffee

In order to have a profitable and consistent coffee shop you need to track and keep your data in order. Whether is labor, expenses, or COGs- spreadsheets are an essential tools to help you build a stable business.  On today's episode we sit down with frequent guest of the KTTS podcast, Maxwell Mooney of Narrative Coffee to talk about his top pieces of advice for using making and using spreadsheets.  Maxwell has been in coffee for well over a decade as a barista, manager, and competitor who then turned entrepreneur with the launch of Narrative Coffee. First he had a cart, then a wonderful brick and mortar, and now a second location. In these five years of operating, growing, and refining Narrative, Maxwell has been guided by his values for quality, hospitality, and community, all supported by systems.  In this conversation we cover:  Is a spreadsheet right for the job? Tracking costs COGs, Labor, expresses, and rent Accounting for waste and labor in cost Appropriate sample size for data Projections Taking the first step with spreadsheets   Links: Maxwell's Spreadsheet UpFlip Interview www.narrative.coffee IG: @narrative.coffee   011 : Founder Friday w/ Maxwell Mooney, Narrative Coffee : hospitality / building relationships / coffee quality 038 : Founder Friday / Narrative Coffee Part 2 w/ Maxwell Mooney : His experience after opening his first brick and mortar COVID-19 Focus w/ Maxwell Mooney, Narrative Coffee, Everette, WA   Related episodes:  302 : Data’s Roll in the Success of your Shop w/ Mark Calhoun and Jim Strarcev of Perfect Cube 009 : How to Approach Data and Metrics w/ Simon Ouderkirk :  330 : Establishing Systems in Your Coffee Shop 057 : SOP’s FTW! Success through Standard Operating Procedures   Visit our amazing Sponsors! www.groundcontrol.coffee www.pacficfoodservice.com www.coffeefest.com