Spreadsheet for those big Q's

  • 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.
SMF is reader-supported. When you buy through links on our site, we may earn an affiliate commission.

dadwith4daughters

Meat Mopper
Original poster
Jul 21, 2007
225
11
Orlando, FL
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
 
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%.
 
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.
 
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.
 
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.
 
i cant see it
icon_sad.gif
 
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
 
    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
confused.gif
. It make sense when you think about it;just my$.02 worth.
biggrin.gif


     Have fun and....................
 
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..
 
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.
 
SmokingMeatForums.com is reader supported and as an Amazon Associate, we may earn commissions from qualifying purchases.

Latest posts

Clicky