BBQ catering planner! - BBQ Central

Go Back   BBQ Central > General > Catering Corner
Click Here to Login
Reply
 
Thread Tools Display Modes
 
Old 02-13-2007, 03:42 AM   #1
Pork Butt
 
SoEzzy's Avatar


 
Join Date: Dec 2006
Location: SLC
Posts: 178
BBQ catering planner!

I have created a catering planner for bbq food items, that you can download for free or you can open with Internet Explorer directly.

It is available either as an Excel file (.xls) or as a Zip file (.zip) you can download either, (by clicking the links in blue), and use them on your own computer for free!

You can change anything in the cells with the green backgrounds: -

The number of guests.
The number of meats.
The number of servings per lb.
The number of sides.
The servings of sides per lb.
The local sales tax %.

You can then input: -

The real costs / lb to buy the meat, etc.
The cost you want to charge your clients / lb of meat.

You can also input: -

The number of ribs / portion.
The weight of steaks / portion.

All the green background cells are available for your customization.

The Yields, in the cells with gray backgrounds can also be adjusted *, but the figures that are in these cells have been carefully considered, and work well as an average yield for each item covered. * If you adjust them please make sure that the figure is expressed as a "%", and make sure that there is a "%" in the cell or the calculations will not work out as they are designed to!

If you have details you think should be added, (or questions you need answering), you can email me directly from the .xls, just click the link that says Email Me.

Follow the links above or the one in my signature, (go onto the forum, then to Miscellaneous, then onto the thread about the Catering Planner), please use it for free and if you like it or even dislike it, let me know what you think!
__________________

__________________
"There's no such thing as a little garlic" A. Baer


http://www.soezzy.com/

KCBS certified barbecue judge.
SoEzzy is offline   Reply With Quote
Old 02-13-2007, 06:11 AM   #2
Moderator
 
Join Date: Jan 2005
Location: Myrtle Beach
Posts: 14,162
Sweet! Thanks, I'll download it when I get home.
__________________

__________________
The trouble with quotes on the internet is that it difficult to determine whether or not they are genuine - Abraham Lincoln
Captain Morgan is offline   Reply With Quote
Old 02-13-2007, 07:07 AM   #3
Official BBQ Central Mark
 
Bill The Grill Guy's Avatar


 
Join Date: Jan 2005
Location: Virginia
Posts: 5,449
Works great. Thanks.
__________________
Bill The Grill Guy
www.billthegrillguy.com
"Life, it's what you do between meals."

http://img76.imageshack.us/img76/3674/platezi0.png
Bill The Grill Guy is offline   Reply With Quote
Old 02-13-2007, 07:54 AM   #4
Pork Butt
 
SoEzzy's Avatar


 
Join Date: Dec 2006
Location: SLC
Posts: 178
For me the yield on chopped pork is higher as I tend to remove less fat and connective tissue than when pulling, my pulled pork has little in the way of either fat or connective tissue, and is meat and bark only,(with some fat because I am always a little looser with my pulling or a little tighter on time to do the job than I want to admit). On chopped pork I don't take it down quite as clean, there is some fat and connective tissue still in the meat when I start to chop, so it will yield the extra ten percent by weight.

Some folks say they only get 50% by weight with pulled pork, they must pull it even "cleaner" than I do, that is why you can customize the yields to suit your own methods, (and experiences), just remember to leave the % on those figures or the math won’t work correctly!
__________________
"There's no such thing as a little garlic" A. Baer


http://www.soezzy.com/

KCBS certified barbecue judge.
SoEzzy is offline   Reply With Quote
Old 02-13-2007, 08:17 AM   #5
Moderator
 
Join Date: Jan 2005
Location: Myrtle Beach
Posts: 14,162
I agree...when chopping, I leave a good bit of fat in there
to keep the meat moist....it drys out quickly when chopped.
__________________
The trouble with quotes on the internet is that it difficult to determine whether or not they are genuine - Abraham Lincoln
Captain Morgan is offline   Reply With Quote
Old 02-13-2007, 09:21 AM   #6
BBQ Central Pro


 
Join Date: Oct 2005
Location: Lindenhurst, NY
Posts: 994
Very well thought out process, and professionly presented.. Nice job

I have a question on the rib part though .... per pound vs, per piece, and yield.. My initial thinking is that a rack is a rack... and a piece is a piece, no matter how much it wieghs... not sold as a poundage item...so the percentage would always be 100% yield... Maybe I'm not looking at it the right way.. I'll get back to you.. just wanted to thank you very much for taking the time to do that.. Great job..
__________________
Aim for Sucess, not perfection
Good Country, This America
Bobberqer is offline   Reply With Quote
Old 02-13-2007, 09:49 AM   #7
Pork Butt
 
SoEzzy's Avatar


 
Join Date: Dec 2006
Location: SLC
Posts: 178
Quote:
Originally Posted by Bobberqer
Very well thought out process, and professionly presented.. Nice job

I have a question on the rib part though .... per pound vs, per piece, and yield.. My initial thinking is that a rack is a rack... and a piece is a piece, no matter how much it wieghs... not sold as a poundage item...so the percentage would always be 100% yield... Maybe I'm not looking at it the right way.. I'll get back to you.. just wanted to thank you very much for taking the time to do that.. Great job..
Thanks for pointing that one out, check it out again, I think I have it sorted now, I had that one recalculated, but I had posted the old version by mistake.

Now as the number of ribs goes up the number of portions goes down / rack of ribs, the rib calculator is based on portioning Spare Ribs at 3.5 lbs / rack, 12 ribs to the rack, so if you portion as 2 ribs there will be 6 servings / rack and they will average upto 7.93 Oz / serving, (cooked weight). If you went with 6 ribs / serving you get 2 servings / rack and 23.80 Oz / serving (cooked weight).
__________________
"There's no such thing as a little garlic" A. Baer


http://www.soezzy.com/

KCBS certified barbecue judge.
SoEzzy is offline   Reply With Quote
Old 02-14-2007, 11:47 AM   #8
BBQ Central Pro


 
Join Date: Oct 2005
Location: Lindenhurst, NY
Posts: 994
just a note on turkeys, and the shrinkage... According to Cooks Illustrated, unbrined Turkey loses 28% of weight... Brined Turkey, only 18%.. can add up if you're doing a sizable catering job..
__________________
Aim for Sucess, not perfection
Good Country, This America
Bobberqer is offline   Reply With Quote
Old 02-14-2007, 04:42 PM   #9
Pork Butt
 
SoEzzy's Avatar


 
Join Date: Dec 2006
Location: SLC
Posts: 178
Quote:
Originally Posted by Bobberqer
just a note on turkeys, and the shrinkage... According to Cooks Illustrated, unbrined Turkey loses 28% of weight... Brined Turkey, only 18%.. can add up if you're doing a sizable catering job..
Don't forget that brining is therefore good for the profit margin, not just because you don't shrink them as much, but you added water at almost no cost and get to charge turkey prices for it!
__________________
"There's no such thing as a little garlic" A. Baer


http://www.soezzy.com/

KCBS certified barbecue judge.
SoEzzy is offline   Reply With Quote
Old 02-25-2007, 11:16 PM   #10
Pork Butt
 
SoEzzy's Avatar


 
Join Date: Dec 2006
Location: SLC
Posts: 178
Up dated version with better explanations and comments on the important boxes, greater detail to help understand what is going on all round. For those who are interested, go download the new and improved version.
__________________
"There's no such thing as a little garlic" A. Baer


http://www.soezzy.com/

KCBS certified barbecue judge.
SoEzzy is offline   Reply With Quote
Old 02-26-2007, 06:00 AM   #11
Moderator
 
Join Date: Jan 2005
Location: Myrtle Beach
Posts: 14,162
Thanks again!
__________________
The trouble with quotes on the internet is that it difficult to determine whether or not they are genuine - Abraham Lincoln
Captain Morgan is offline   Reply With Quote
Old 03-05-2007, 07:48 AM   #12
Pork Butt
 
SoEzzy's Avatar


 
Join Date: Dec 2006
Location: SLC
Posts: 178
Thanks to Steve Baum for pointing out an error on line 16, tax was not being added, now it is calculating correctly.

For any who want to go back and get the next version, they were updated again today, 03/05/07.
__________________
"There's no such thing as a little garlic" A. Baer


http://www.soezzy.com/

KCBS certified barbecue judge.
SoEzzy is offline   Reply With Quote
Old 05-01-2007, 05:49 PM   #13
Pork Butt
 
SoEzzy's Avatar


 
Join Date: Dec 2006
Location: SLC
Posts: 178
Minor Change

There is a newer version with a few minor changes to the chicken area, for those that would like the new version, please download it and overwrite your existing versions.
__________________
"There's no such thing as a little garlic" A. Baer


http://www.soezzy.com/

KCBS certified barbecue judge.
SoEzzy is offline   Reply With Quote
Old 05-01-2007, 07:17 PM   #14
BBQ Centralite
 
Diva Q's Avatar


 
Join Date: Nov 2006
Location: Barrie, Ontario
Posts: 3,379
Very kind of you to continually share the updates and planner with everyone.

Kudos to you.
__________________
________________________________________

www.DivaQ.ca

Life is too short for bad BBQ

Generously sponsored by:

Traeger Canada
Hovey's Gourmet Meats
Big Rock Brewery
Basques Hardwood Lump Charcoal
Alcan
Diva Q is offline   Reply With Quote
Old 09-12-2007, 07:36 PM   #15
Pork Butt
 
SoEzzy's Avatar


 
Join Date: Dec 2006
Location: SLC
Posts: 178
http://www.bbq-review.com/forum/viewtopic.php?t=10 The latest version of my catering planner is up and about, a couple of corrections and I have made it even more customizeable on some of the sections.

This is version 3.01 issued 09/11/07.

There is going to be an additional version with an executable file that will allow you to pick selections and print a page with those selections on it, in the not too distant future.

Still free to download and free to use. Enjoy!
__________________
"There's no such thing as a little garlic" A. Baer


http://www.soezzy.com/

KCBS certified barbecue judge.
SoEzzy is offline   Reply With Quote
Old 09-13-2007, 07:53 AM   #16
Official BBQ Central Mark
 
Bill The Grill Guy's Avatar


 
Join Date: Jan 2005
Location: Virginia
Posts: 5,449
Thank you SoEzzy. I used the old one so I will deffantly use the new one.
__________________
Bill The Grill Guy
www.billthegrillguy.com
"Life, it's what you do between meals."

http://img76.imageshack.us/img76/3674/platezi0.png
Bill The Grill Guy is offline   Reply With Quote
Old 09-14-2007, 08:04 PM   #17
Pork Butt
 
SoEzzy's Avatar


 
Join Date: Dec 2006
Location: SLC
Posts: 178
Thanks to Steve Brandon for spotting that B76 was protected and should be changeable.

Now corrected, New New version 3.02 online thanks also to Ray Lesko for asking me to put a version number on the spreadsheet, from now on the version number will be on the title Barbecue Review catering planner V xxx.

This is the latest, latest version!
__________________
"There's no such thing as a little garlic" A. Baer


http://www.soezzy.com/

KCBS certified barbecue judge.
SoEzzy is offline   Reply With Quote
Old 11-29-2007, 03:46 PM   #18
Pork Butt
 
SoEzzy's Avatar


 
Join Date: Dec 2006
Location: SLC
Posts: 178
Catering planner version 3.03 available now from http://www.bbq-review.com/forum/viewtopic.php?t=10 in the top post on this thread are the new versions of the Excel spreadsheet (.xls) and a Zipped version of the spreadsheet (.zip).

Now using the number of meats and the number of sides with an algorithm to calculate multiple meat / side figures.
__________________
"There's no such thing as a little garlic" A. Baer


http://www.soezzy.com/

KCBS certified barbecue judge.
SoEzzy is offline   Reply With Quote
Old 03-22-2008, 01:48 PM   #19
Pork Butt
 
SoEzzy's Avatar


 
Join Date: Dec 2006
Location: SLC
Posts: 178
New Updates!

1) Minor changes to the Math on some sections, now rounds up to next unit value so you should always have enough, even if it is just enough.

2) Addition of Loin Back ribs to pork section.

3) Minor corrections to some rib math on weights.

All the figures are "real" so if you have big or small eaters adjust accordingly with your portion size.

It is available either as an Excel file (catering304.xls) or as a Zip file (catering304.zip) you can download either, (by clicking the links), and use them on your own computer for free!

It is also now available for Canada, (new version of this one too), with GST and PST instead of Local Sales Tax, (catering305CA.xls).
__________________
"There's no such thing as a little garlic" A. Baer


http://www.soezzy.com/

KCBS certified barbecue judge.
SoEzzy is offline   Reply With Quote
Old 09-19-2008, 04:07 PM   #20
Pork Butt
 
SoEzzy's Avatar


 
Join Date: Dec 2006
Location: SLC
Posts: 178
Latest versions 3.06.xls and 3.06CA.xls are now available, http://www.bbq-review.com/forum/viewtopic.php?t=10 the first for those with only one tax to worry about the second for the Canadians with GST and PST to think on.

Changes to Chicken breasts, thighs, drum sticks, wings and tenders, now calculates from Tyson sizes in their 7lb packs.
Breasts 12 in 7lb.
Thighs 16 in 7lb.
Drum Sticks 21 in 7lb.
Wings 24 in 7lb.
Chicken Tenders 13 portions, (2 tenders / portion) / 2.5 lb bag.
__________________

__________________
"There's no such thing as a little garlic" A. Baer


http://www.soezzy.com/

KCBS certified barbecue judge.
SoEzzy is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off







Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 03:49 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
×