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