• Some of the links on this forum allow SMF, at no cost to you, to earn a small commission when you click through and make a purchase. Let me know if you have any questions about this.

Spreadsheet for those big Q's

dadwith4daughters

Meat Mopper
225
11
Joined Jul 21, 2007
So I've got my first catering job, cooking for my neighborhood July 4th party. 120 adults/80 kids. I put this excel doc together to help me figure it all out. Here are the details (step-by-step is on the spreadsheet)

1. Accounts for 3 different meats and two types of ppl (adults/kids)
2. You can allocate % of which meat each type of person will eat (kids won't eat lots of pork, but they will eat chicken)
3. Amount of meat per type of person (I checked with our banquet chef who told me he budgets 8oz of meat per adult).
4. Price per lb of each meat
5. Prices for the extras to include # of bags of charcoal, buns, etc
6. A place to put you profit or fee.
7. Lastly it calculates a per person price.

If there's a better mouse trap out there, I couldn't find it in SMF. Plz revise as necessary and repost any improvements.

Mike
 

supervman

Smoking Fanatic
926
11
Joined May 25, 2008
That's an EXCELLENT job and thanks for sharing!
It all looks pretty darn organized and well thought out.
The one thing that stuck out to me was that there was not readily available a way to put in Side Dishes if'n you were to do Baked Beans, Tater Salad, Slaw, etc. Although, I'm no expert on Excel so it can probably be a few lines that are easily added.

But again, thanks and good job.
SKOL
Vman

P.S. and one other thing. Do folks here "generally" agree with the shrinkage numbers? I've seen as high as 50%.
 

fatback joe

Master of the Pit
OTBS Member
2,769
14
Joined Jun 13, 2007
Here is one that has made the rounds a time or two before with sides added.

Don't know if it is a better mousetrap as much as just a different one.

On edit: I did not design it, I just pass it around as people have an interest or question.......so don't aske me if you have problems with it. LOL I am just the middleman.
 

downstatesmoker

Smoking Fanatic
586
12
Joined Apr 14, 2008
That's great. I was starting to think about maybe offering my services as a smoker for parties. This will help if I do end up going that route.
 

dadwith4daughters

Meat Mopper
225
11
Joined Jul 21, 2007
Not only is it a better mousetrap, but it's got moving parts that I haven't seen before. Very nice. And definitely looks like the shrinkage on the butt is off. That spreadsheet has it at 45%.

Thanks for sharing.
 

richtee

Epic Pitmaster
OTBS Member
10,686
20
Joined Aug 12, 2007
Butt will go 45%- considering the fat removal and the shrinkage. Not all of them, but I have seen it plenty.
 

crockadale

Smoking Fanatic
493
11
Joined Jun 13, 2006
Are you planning on making a living at this?? Cause $4.00 a head isn’t going cut it. Please enlighten me or are you basically doing this as a neighborly thing.
 

dadwith4daughters

Meat Mopper
225
11
Joined Jul 21, 2007
Crock...neighborly thing for sure. Wanted to get my feet wet first and no better place than with your friends...i think? :)
 

timbre

Newbie
27
10
Joined Aug 20, 2008
I know this is bringing up something from the way past.

Does anyone still have a link to these spreadsheets? It would be way easier than trying to recreate from scratch.

thanks

timbre
 

oldschoolbbq

Legendary Pitmaster
OTBS Member
9,362
199
Joined Jul 16, 2008
    May I add;Oh,Why Thank You. I do a lot of fairly big cooks for the Family and Friends, and each one of my cooks I have kept at Journal on so I could go back and refference each mistake and revise the action.Every cook is a learning experience, and the record keeping helps every cook
. It make sense when you think about it;just my$.02 worth.


     Have fun and....................
 

diesel

Smoking Fanatic
594
27
Joined Apr 29, 2008
seriously...  where is the spreadsheet?  I would love to use it.  or at least check it out.  on you post there is a missing image that is all.

thanks..
 

grande

Fire Starter
51
10
Joined Jan 21, 2008
I have just been asked to cater a friend's Wedding Shower & a tool like this would be extremely helpful.

I have always appreciated the help that I have received here at SMF & this is just another example of how neighborly this joint can be.
 

Hot Threads

Top Bottom
  AdBlock Detected

We noticed that you're using an ad-blocker, which could block some critical website features. For the best possible site experience please take a moment to disable your AdBlocker.