I haven't disappeared.
but maybe I have.
it depends on how you look at it.
many people will tell you I'm more present than ever.
many of these last days have not been spent in the kitchen.
but soon that's the only place I'll be.
These days I'm shaking hands with a lot of guys who sell big machines.
They say things to me like, "Why are you being so fucking polite?! We don't trust you if you're too nice..." {Not gonna lie-- It's a strange acclamation to go from London to NYC.}
Excel has become a great friend of mine.
I've built a database in fact.
One wouldn't think a pastry chef could do such a thing.
The database does all sorts of mathematical tricks.
And all the pages talk to each other.
VLOOKUP and Dropdown Menus, yo.
So few restaurants, and less chefs {who are not hotel/corporate trained, which I am not} understand the power of internal, back-end organization.
The Excel document is a list of all raw product, a compilation of recipes, a break down of all product to show price per gram, a relay of price per gram embedded in each recipe to cost out each recipe, and, as we move through costing out each product, we can add these "working products" to our "list of ingredients."
So if you want to know the cost of butterscotch ice cream you take the cost of ice cream as a recipe and add to it the cost of butterscotch, a working product, by the gram amount you need.
If this sounds too nerdy for you, or if this doesn't sound like cheffing as you know it, think about it this way: for every skill you add to your resume you become that much more valuable, can garner a higher wage and you might even be able to keep your job when the economy tanks.
This is the second restaurant database I've written, and if we all use it to its potential it will also help us with inventory, ordering, wholesale/catering, and price tracking.
Or think about it this way: It's easier to work in your business than on it.
When you think, "I want to be a chef when I grow up," remember that just being a great cook is not enough.
What else am I doing?
Test baking,
measuring my station and the equipment I've ordered,
having lots and lots and lots of menu meetings,
talking to future staff about the possibility of working with me, with us,
visiting the future home of the restaurant in all its stages: raw, midrare etc. {we are going to inhabit a building that basically needed to be gutted & rebuilt from the inside-out},
tracking down an ice cream machine,
attempting to navigate the farmers market and taking notes on which farmers have what produce during which weeks/months/seasons,
organizing recipes & recipe notes,
finding hard to find product through available purveyors and looking under rocks for the rest,
going on field trips to places I won't be able to once we open the doors to the public,
and spending as much time with my family and friends as I and they can and have time for.
Opening a restaurant is like nothing else. Joanne Chang of Boston's incredible, incomparible Flour bakery put it best,
"There's a lot of 'hurry up and wait.' You have all this time to organize yourself, your time and the project. But you wait. A lot. And then when the restaurant is going to open any minute you have a thousand things to do and no time to do them!"
I know you want to know more about the project. Where it is, who its with, what my menu will be like, when we'll open. I promise you'll know, as soon as I can tell.
Until then, eggbeater is taking suggestions for posts &/or 'bids' for guest authoring. Know anyone?
Shuna
Would love to guest author, but filling those big literature and eloquent shoes might be a challenge but I'd offer to try.
Posted by: robert wemischner | 03 June 2010 at 12:41 AM
So happy you posted this. Making data bases was one thing that saved me so many inventory and purchasing headaches. Not to mention that it helped the ex. chef a lot when I had to miss work because of flu or what not.
Thinking about you and can't wait to read the menu when it's ready!
Posted by: Helene | 03 June 2010 at 12:48 AM
Good luck with it all! Just getting my head around all the spread sheet stuff myself. Makes you feel so good when it works.
By the way thanks for the baking powder recipe have been using it for my muffins ever since you posted the recipe.
Posted by: alice | 03 June 2010 at 12:52 AM
Awesome Shuna. Glad the vlookups etc. make sense.
Hope to eat @yours sometime
Posted by: Jon Savage | 03 June 2010 at 12:53 AM
Can't wait to hear more! g
Posted by: Guy Arnone | 03 June 2010 at 01:03 AM
Good luck for your restaurant!
Posted by: Médaille gourmande | 03 June 2010 at 02:52 AM
I've been using a couple of linked Excel spreadsheets to do the same thing for a couple of years with moderate success.
I've just bought Filemaker and am about to start making the transition because I can do invoicing and stock control with it - all linked (I hope)
Posted by: Peter Whiting | 03 June 2010 at 04:17 AM
Sounds exciting - and exhausting, but thrilling nonetheless. Your database sounds wild.
So this is what "June Is" for you this year.
Good luck. I can't wait to walk through your door.
Posted by: Victoria | 03 June 2010 at 06:00 AM
Congrats! Seems to me that you are absolutely going about it in the right way. I think the reason people get in trouble opening any business is that they don't have a plan and they don't take care of the back end of the business.
Posted by: Janis Tester | 03 June 2010 at 07:40 AM
How about Melvis doing a biscuit tutorial? I would love to read that...and congrats on all this!!!! xoxo
Posted by: rachel | 03 June 2010 at 08:30 AM
Congrats Shuna! What a wonderful, exciting adventure!
Posted by: s.h. | 03 June 2010 at 08:35 AM
vlookup is a friend of mine, too.
it's fascinating reading the backlog of posts, knowing that you are in NYC now. it's like an enormous mystery novel to see how you arrived there.
Posted by: seth | 03 June 2010 at 01:55 PM
Your spreadsheet sounds great. Make sure to save it in two locations. It would be a shame to have to rebuild it. Good luck with your restaurant opening.
Posted by: Megan | 03 June 2010 at 02:24 PM
That spreadsheet sounds frickin' awesome! I don't know why every pastry chef doesn't have that. If you do your front end work, it makes it easier to keep track of where you are.
Posted by: Scooter | 03 June 2010 at 03:06 PM
Shuna, i am so excited for you and cannot wait to come to your next venture. The excel sheet, especially the VLOOKUP stuff is just fantastic. Excel is REALLY powerful and awesome and I know, being a nerd, that most people roll their eyes at this, but I think you get it too!! Very excited for you!
Posted by: radish | 03 June 2010 at 03:47 PM
I think my husband could actually fall in love with you..not only can you bake BUT you can do a restaurant business plan on EXCEL...you are an accountant and a bankers' dream client...
Posted by: Natalie Sztern | 03 June 2010 at 04:43 PM
OMG.
More power to you!
Posted by: Brenner | 03 June 2010 at 05:05 PM
Well, all of this seems pretty damn exciting. It will be interesting to see it all evolve, if you have time to share some bits with us here. Enjoy those field trips while you can.
Posted by: Denise | 03 June 2010 at 05:43 PM
Oh wow, that excel stuff sounds super cool and is so important. At some point I need to incorporate all that stuff into a business plan before I embark on anything bigger than a dream.
I cant wait to hear more about your new venture! Good luck!
Posted by: jenny | 03 June 2010 at 06:13 PM
Congrats! I can't wait to hear more about your venture.
Posted by: Jeni | 03 June 2010 at 06:31 PM
Shuna, just thinking about you and how inspiring you are to me. I hope to be able to experience your trade again really soon! I am trying to bring your theories of guilds to fruition here in Houston. wish you the best!
Posted by: Greenway Barista | 03 June 2010 at 11:37 PM
Opening a restaurant is an endeavor that both thrills and scares the living daylights out of anyone. I may have a piece that might interest your refined readers. Having opened a few restaurants, I have gathered a few feathers that needs a bit of ruffling.Perhaps I can invite you to spill over your adventures my way as well.
Posted by: Ivan Maminta | 04 June 2010 at 05:44 AM
I feel it! Film making is like that, too-- hurry up and wait. And any little human frailty can bring it to an expensive, screaming halt.
But it's exhilarating, an all-engrossing thrill ride. And like opening a restaurant, you can swing loose better during the hairy times if you have done your prep to an excessively high degree. If only every poor dreamer knew that before they put put their soul into the mixing bowl...
In the last year, I've seen over a dozen different restaurants in my small corner of WNY fail-- all kinds, but mostly new-- started on a shoestring with no real idea of what the running costs would be. I know of three little pizza/sub/pasta joints right now that are unlikely to last the year. And two upscale "bistros" that are in their death rolls as I write.
I think what they all have in common is that the dreamers who opened them expected talent alone to carry them through. And it's sad, because there was talent. But not enough financial prep work. It's just another type of mise en place, but they couldn't see it.
I'm glad to see a talented cook embracing the technologies of business, too. In a time when an institution like Gourmet magazine can suddenly fail, much less Tavern on the Green, every drop of forethought counts, just as much as the drops of vanilla. Best luck and energy to you and all your crew.
Mari, I want to give you a big, wide THANK YOU for this comment you took time to write! And I really hope you don't mind-- but I have made bold the lines I think are especially brilliant. thank you for stopping by and leaving your words & experiences. ~ shuna
Posted by: Mari | 04 June 2010 at 10:31 AM
Shuna I was wondering if you had incorporated costing into the spreadsheet and if so how do you calculate the cost of each ingredient since those vary depending on when acquired.
Hello Jon-- man of knowing!!
I have one Master document. In that one we have one price for an item. We can do one of 2 things when that number changes: round up or down to give us an approximate or change the purveyor name so we know which purveyors give us what price. The hope is that with two restaurants under these owners' belts we chefs will be able to have better buying power. And the ability to "lock in" certain prices for products we are guaranteed to buy a lot of :} ~ shuna
Posted by: Jon Savage | 04 June 2010 at 08:48 PM
I hope that all goes well for you in your endeavors. Congratulations on your journey into uncharted waters...(excel land!) lol
Posted by: Jessica | 05 June 2010 at 11:54 AM
Congrats on your new restaurant.
I have really enjoyed reading and learning from your blog.
I am curious about your excel speadsheet. I work in a kitchen and we have been trying to use an already assembled spreadsheet system but it's not working very well for us. Your post above has given me pause to think that maybe I should create a new database from scratch.
Good luck and best wishes!
Posted by: Stacy | 06 June 2010 at 01:33 PM
Shuna,
So excited for your new restaurant. I cannot wait to hear more about it. I fell in love with Excel myself when I decided to use it to catalog my cookbook collection. Love Flour and I can't wait to add Joanne's new book to my ever growing collection.
P.S. If you ever decide to come out with a book it will definitely be something I would purchase and I'm sure use.
Posted by: Vivian | 07 June 2010 at 02:18 PM
congrats on the new post. Looking forward to hearing about the new menu/restaurant. Tom
Posted by: Tom Lydon | 08 June 2010 at 03:50 AM
Cheering you! Just keep channeling your inner Foxy Brown (Pam Grier...not the Hip Hop artist)
Oh I got a new blog called eat drink divorce.
I am adding you to the blog roll. Oh and add some type of non-dairy (milk, cheese, butter, whey) dish to the menu so I can eat there from time to time...
hello lovebabz, I see you are the same you-- vever slowing down! always positive! I'm sorry I can't always keep up with you. Yes on the non-dairy foods. Do you consider lard to be dairy? The food is going to be American but I'm trying to push the envelope & include all of America, not just the obvious cliched junky stuff!
p.s. I've created a hyperlink for your new blog. I wrote the code in and you can too, next time, if you want people reading the comments to be able to click on it. I wrote a post about it many moons ago-- it's called How To Create Links In Your Comments. xo shuna
Posted by: lovebabz | 09 June 2010 at 09:52 AM
Shuna, you are fantastic.
Mari's eloquent words of wisdom -- financial prep work is just another type of mise en place -- these are words to live by, and ones that could prevent a lot of food businesses from meeting an ill fate. Brava!
Posted by: Jennie Schacht | 24 June 2010 at 01:32 AM
when you have a business, you should know how to use the excel because it is really a powerful program which is mainly utilize as a database. simple yet powerful.
Posted by: adriane | 25 June 2010 at 07:09 AM
as always you are profoundly correct in that "DUH!" kind of way. now how about some date tags in your DB to keep track of fluctuating prices? (this is what I payed on this date, etc.) any chance of getting my hands on your .xls files? (minus important intellectual property, of course) I have been trying to do some of the same things and don't have time to read help files. a hands on playbook would blow my mind. anyway, you rock.
Posted by: Jeremy Conner | 27 June 2010 at 03:31 PM
I would back up the spreadsheets/database in THREE places *and* print a periodic hard copy. I've found that it is wonderful to be able to look back a year to see what I was paying for something and how much we used. A lot of that historical data gets lost in the ever-flowing living database.
In computer programming, it is important to track changes, so I also have an extra spreadsheet in every Excel file that is simply a chronological list of changes made. For instance, if you change butter sources, type 07/07/10 in the date column, butter in the subject column, and Changed butter source from Sad-Late-Salty Dairy to Happy-Prompt-Yummy Dairy. Yes, A/P will show to whom and when the checks were written, but it won't say why. If SLS Dairy tries to cut a new deal to win you back, having that note in your file will help in the decision making process.
Good luck with your new venture!
Hello Sylvia,
I would like to state for the record: i heart you.Or, you fuckin' rock. Thank you a lot lot. Wow! I am floored and humbled and excited by this advice. This comment is what keeps me and eggbeater buoyed on this flailing sea of epic proportions. If we ever meet I hope I am working somewhere where you'll accept a baked good of my affections & gratitude! ~ shuna
Posted by: Sylvia | 08 July 2010 at 03:33 PM
Shuna, glad to help. Periodically you can copy the notes worksheet contents into a word doc and that makes it easier to search for keywords. Never copy something from word into excel -- it's like introducing walnut moths to a cupboard. Word is *always* corrupt.
My daughter used to go into SF to eat your pastries. Keep writing, please, whether it's about spreadsheets or kitchen attitude or doughnuts (nutmeg!). Your prose and poetry are a gift.
Posted by: Sylvia | 12 July 2010 at 12:58 PM