• 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.

Catering calculation sheet

Smokin stro

Newbie
10
3
Joined Aug 19, 2019
Does anyone know of an up to date spreadsheet use for catering and calculating pricing. with the current rise in meat products Just want to make sure I am going down the right path. I know alot of people state that the rule of thumb is 3 times the price of material .
Any thoughts?
TIA
 

chef jimmyj

Epic Pitmaster
Staff member
Moderator
OTBS Member
SMF Premier Member
★ Lifetime Premier ★
Group Lead
21,796
6,586
Joined May 12, 2011
Catering Spreadsheets, can help you figure How Much food needed for X number of people, but you have to add the Actual price and size/weight of the product you bought or will buy to determine cost.
Cost times 3 works. But, call other catering operations and see what they charge. Big difference in Price between dropping off a bunch of pans of food and having to set up and serve it. Getting info on other operations will give a better idea of what your Demographic will support. Cost X 3 may be Too Much of Too Little...JJ
 

krj

Smoking Fanatic
437
323
Joined Mar 23, 2009
Cost times 3 is a convenient rule of thumb, but has to be tempered with the knowledge that certain food costs are so high that it is somewhat unreasonable to use that. That said, a savvy restauranteur/caterer/vendor will tell you that you can still use that rule if you are offsetting the cost of the high price item by pairing it with low cost items.

When I cater I try and get to as close to cost times 3, because my time/labor and the small incidentals I forget about do add up and cut into my profits.
 

Wurstmeister

Smoking Fanatic
781
506
Joined Mar 21, 2018
In addition to the sheet above, here are a few spreadsheets from Chef Resources that I use which might help you out.

For each recipe - I make a basic and scaled recipe and plate cost template. File them in my library.
One thing that is different in my use, once I write the prep order in the event planner, I keep a copy it each recipe on a blank page in the scaling form. This way I just copy the instruction and paste them in the new event prep instructions updating the date/time group and responsible individual.
Then as an event comes up, I create planning template adding a recipe from the library as a individual worksheet, update the prep and load forms.
  • Event Planning Form - idea, menu, load plan, order, prep schedule, recipes with cost
  • Recipe Scaling Form that will help you adjust your recipe quantities. Also includes a prep direction sheet. I give this to my help, if any, to use.
  • Recipe per Plate Cost. This is a personal form for adjusting my costs and so my accountant (Mrs. Wurtz) can manage the money! LOL!!!
Hope these are some help. 🍻
John
 

Attachments

krj

Smoking Fanatic
437
323
Joined Mar 23, 2009
In addition to the sheet above, here are a few spreadsheets from Chef Resources that I use which might help you out.

For each recipe - I make a basic and scaled recipe and plate cost template. File them in my library.
One thing that is different in my use, once I write the prep order in the event planner, I keep a copy it each recipe on a blank page in the scaling form. This way I just copy the instruction and paste them in the new event prep instructions updating the date/time group and responsible individual.
Then as an event comes up, I create planning template adding a recipe from the library as a individual worksheet, update the prep and load forms.
  • Event Planning Form - idea, menu, load plan, order, prep schedule, recipes with cost
  • Recipe Scaling Form that will help you adjust your recipe quantities. Also includes a prep direction sheet. I give this to my help, if any, to use.
  • Recipe per Plate Cost. This is a personal form for adjusting my costs and so my accountant (Mrs. Wurtz) can manage the money! LOL!!!
Hope these are some help. 🍻
John
Wow!!! That's some amazing work right there. I'll have to give those sheets a try for my little vendor event for the 4th.
 

PPG1

Smoking Fanatic
412
314
Joined Aug 22, 2020
In addition to the sheet above, here are a few spreadsheets from Chef Resources that I use which might help you out.

For each recipe - I make a basic and scaled recipe and plate cost template. File them in my library.
One thing that is different in my use, once I write the prep order in the event planner, I keep a copy it each recipe on a blank page in the scaling form. This way I just copy the instruction and paste them in the new event prep instructions updating the date/time group and responsible individual.
Then as an event comes up, I create planning template adding a recipe from the library as a individual worksheet, update the prep and load forms.
  • Event Planning Form - idea, menu, load plan, order, prep schedule, recipes with cost
  • Recipe Scaling Form that will help you adjust your recipe quantities. Also includes a prep direction sheet. I give this to my help, if any, to use.
  • Recipe per Plate Cost. This is a personal form for adjusting my costs and so my accountant (Mrs. Wurtz) can manage the money! LOL!!!
Hope these are some help. 🍻
John
Great Post! Thanks
 

Wurstmeister

Smoking Fanatic
781
506
Joined Mar 21, 2018
Wow!!! That's some amazing work right there. I'll have to give those sheets a try for my little vendor event for the 4th.
Thanks krj for the complement. They also work nicely for family gatherings. With all of the small moving parts and distractions that come into play, if it's not written down, it won't or didn't happen. Keep in mind, there is nothing "little" about an event. They always grow exponentially beyond expectations/resources, and usually right at starting time!

You know that we will be watching for photos and a narrative on the outcome of your event. Good Luck! 🍻
John
 

Latest posts

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.