Cost worksheet

Author
Blissful Bite
Hamburger
  • Total Posts : 55
  • Joined: 2010/12/18 21:18:00
  • Location: Lawrence/KC area, KS
  • Status: offline
2012/03/09 01:23:55 (permalink)

Cost worksheet

Hey gang, up too late here putting together a cost worksheet for events.  It looks pretty slick to me so I thought I'd share.  You need some basic proficiency with ms excel and I'm not inclined to coach but enjoy and let me know what you think.
 
I quickly created a file area on my webpage...

#1

15 Replies Related Threads

    Blissful Bite
    Hamburger
    • Total Posts : 55
    • Joined: 2010/12/18 21:18:00
    • Location: Lawrence/KC area, KS
    • Status: offline
    Re:Cost worksheet 2012/03/09 01:24:46 (permalink)
    That was my last link-restricted post!
     

    #2
    Blissful Bite
    Hamburger
    • Total Posts : 55
    • Joined: 2010/12/18 21:18:00
    • Location: Lawrence/KC area, KS
    • Status: offline
    Re:Cost worksheet 2012/03/09 01:25:13 (permalink)
    maybe not...
     
    http://theblissfulbite.com/file-area.html
    post edited by Blissful Bite - 2012/03/09 01:27:57
    #3
    mofood
    Cheeseburger
    • Total Posts : 117
    • Joined: 2011/10/12 16:29:00
    • Location: SLC, UT
    • Status: offline
    Re:Cost worksheet 2012/03/09 10:19:20 (permalink)
    Excel is a wonderful thing!
    Worksheet bookmarked for future reference.
    Nice work
    #4
    marco226
    Cheeseburger
    • Total Posts : 177
    • Joined: 2011/11/28 22:31:00
    • Location: HAWLEY, PA
    • Status: offline
    Re:Cost worksheet 2012/03/09 18:11:10 (permalink)
    nice i will use it/
    #5
    Blissful Bite
    Hamburger
    • Total Posts : 55
    • Joined: 2010/12/18 21:18:00
    • Location: Lawrence/KC area, KS
    • Status: offline
    Re:Cost worksheet 2012/03/09 20:43:58 (permalink)
    Cool, I hope it helps.
     
    It's simple calculations but I like that it's easy to change cost, pricing, sales volume, staff hours, and other costs for a quick look at the numbers. 
    #6
    Dr of BBQ
    Filet Mignon
    • Total Posts : 3716
    • Joined: 2004/10/11 20:16:00
    • Location: Springfield, IL
    • Status: offline
    Re:Cost worksheet 2012/03/10 00:14:53 (permalink)
    I have to add that it is a great idea,if you figure your cost correctly.
     
    But I have yet after several years to be able to figure the number of folks that I will feed at an event. I know the number of sandwiches that I can serve in an hour if I have a steady line, but no one knows the weather, how many people will show up, how many vendors will be between you and the entertainment, how close your spot will be to the bathrooms, and the list of variables goes on and on. By the way exactly 90 feet from the porta potty's and 30 feet from the beer truck is tooooo coooool!
     
    If I could answer all those variables I would never run short of buns or have any left over at the end of the day. Well maybe a package of 8 buns left but that's all. In my mind it's always a crap shoot. You pay your money and bet on what you hope is the winner. That said I love a gamble. LOL
     
    And I have to add figuring your cost (often) is paramount. And never let what another vendor is selling a comparable item for bother you. If your food is good really good it doesn't take long for word to travel through out an event or community. So if you are 50 cents or even a dollar higher don't worry just smile offer samples and if you can and put on a hell of a show while your at it. Give them fire and smoke.
    jack
    post edited by Dr of BBQ - 2012/03/10 00:31:23
    #7
    Bistro a go-go
    Cheeseburger
    • Total Posts : 171
    • Joined: 2012/02/22 11:23:00
    • Location: Columbus, GA
    • Status: offline
    Re:Cost worksheet 2012/03/10 11:11:53 (permalink)
    ultimately, i wanna put a 8 x 16 walkin cooler/freezer with a big onan gen to offset what we all dont know. this plus a good relationship with your sysco or us foods rep will bring the big truck to you. Ive even heard of sysco putting one of their reefer trucks on sight for big deals to get the sales and to get the exposure of seeing their trucks at big gaterings. hope everyone gets that busy one day.
    also i might be talkin smack to build post count but its all good.
     
    thanks for the spread sheet, ill definate use it to start
    #8
    Blissful Bite
    Hamburger
    • Total Posts : 55
    • Joined: 2010/12/18 21:18:00
    • Location: Lawrence/KC area, KS
    • Status: offline
    Re:Cost worksheet 2012/03/10 16:16:59 (permalink)
    Yep it's definitely a gamble, but I'm working out ways to figure out how much it costs to show up.  I'll probably create a new version with projected cost vs. actual cost so that I realize quickly if I won 3 nickels for every quarter I spent.  I'll also make sure to track how far we were from the brews and poos...
     
    Sysco is cozying up nicely to big festivals...and locking them down.  One event I was about to apply for, requires their vendors to use Sysco.  That negates the point of what I'm doing...fresh, local, organic...real food from real farmers.  Beware the hidden cost of convenience....
    #9
    Dr of BBQ
    Filet Mignon
    • Total Posts : 3716
    • Joined: 2004/10/11 20:16:00
    • Location: Springfield, IL
    • Status: offline
    Re:Cost worksheet 2012/03/10 17:31:00 (permalink)
    Blissful Bite Sysco is cozying up nicely to big festivals...and locking them down.  One event I was about to apply for, requires their vendors to use Sysco. 

     
    That is BS, if I understand you correctly.  Your saying I have to buy all of my food products from Sysco in-order to vend the event right?
    Do they have trucks on hand to supply what ever you wanted? What if you sell something they don't stock?
    More importantly that is against the law, however it's going to take awhile for some vendor with deep pockets to take them to court. That is outrageous. Really outrageous.
     
    Pepsi started this and locally it's not making them any money. I was surprised they did it the second year. We will see if they do the third year in a row at the Route 66 car show here in town. Does Pepsi own Sysco ???? You know they may try this with BBQ contest and if they do those guys (I know many) will go nuts. LOL
    #10
    Blissful Bite
    Hamburger
    • Total Posts : 55
    • Joined: 2010/12/18 21:18:00
    • Location: Lawrence/KC area, KS
    • Status: offline
    Re:Cost worksheet 2012/03/10 18:30:11 (permalink)
    Yup, Telluride Blues and Brews.  Here's how it reads on their site:
     
    "Sysco is our official food sponsor for the Festival. All food vendors will be required to use Sysco whenever possible as their primary food provider."
     
    I guess there's a bit of a loophole in there but I didn't feel like trying to navigate it.
     
    Next line on the site:
     
    "20lb bags of ice will be available for purchase behind the beer booth for $5 per bag (price may change)."  
     
    Outrageous.
     
    post edited by Blissful Bite - 2012/03/10 18:35:42
    #11
    Dr of BBQ
    Filet Mignon
    • Total Posts : 3716
    • Joined: 2004/10/11 20:16:00
    • Location: Springfield, IL
    • Status: offline
    Re:Cost worksheet 2012/03/10 22:26:36 (permalink)
    Well the line "All food vendors will be required to use Sysco whenever possible as their primary food provider."
     
    That is ok the other is against the law.
    #12
    chefbuba
    Double Chili Cheeseburger
    • Total Posts : 1986
    • Joined: 2009/06/22 16:31:00
    • Location: Near You, WA
    • Status: offline
    Re:Cost worksheet 2012/03/10 22:59:40 (permalink)
    Pepsi tried strong arming me at an event last summer, Tried to get me to buy 16oz bottles for around a buck and sell for $1.50
    I got cases, 12oz cans for $5, sold for $1.50....
    #13
    Blissful Bite
    Hamburger
    • Total Posts : 55
    • Joined: 2010/12/18 21:18:00
    • Location: Lawrence/KC area, KS
    • Status: offline
    Re:Cost worksheet 2012/03/13 01:05:14 (permalink)
    Well...i guess there will always be obstacles to avoid (or knock over 
    #14
    Blissful Bite
    Hamburger
    • Total Posts : 55
    • Joined: 2010/12/18 21:18:00
    • Location: Lawrence/KC area, KS
    • Status: offline
    Re:Cost worksheet 2012/03/13 01:09:34 (permalink)
    dang that last post fell apart...
     
    ...
     
    Here's to events worth remembering because they were great!
     
    BTW, I posted a new version of the worksheet with projected numbers on one worksheet, actual on another, and a separate chart showing actual and projected side by side.  You'll have to make sure to make the same changes (row and column additions) on both worksheets in order to expand your menu, labor pool, or event length.  To shrink the menu, labor pool, or event length just zero out the proper cells, i.e. menu item x cost 0 and sold for zero, worker 4 had 0 hours....
     
    Good luck!
     
    #15
    kingofcreams
    Cheeseburger
    • Total Posts : 111
    • Joined: 2012/01/03 13:43:00
    • Location: Duluth, MN
    • Status: offline
    Re:Cost worksheet 2012/03/13 14:19:56 (permalink)
    Pepsi does that around here too. They pay $5k to be the beverage sponser then the event coordinators require vendors to purchase from Pepsi for $1.25 per bottle. I know they loose money but they want the name to be seen more
    #16
    Jump to:
    © 2014 APG vNext Commercial Version 5.1