The most memorable local eateries along the highways and back roads of America
Sign In | Register for Free!
Restaurants Recipes Forums EatingTours Merchandise FAQ Maps Insider

 Cost worksheet

Author Message
Blissful Bite

  • Total Posts: 55
  • Joined: 12/18/2010
  • Location: Lawrence/KC area, KS
Cost worksheet Fri, 03/9/12 1:23 AM (permalink)
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
    Blissful Bite

    • Total Posts: 55
    • Joined: 12/18/2010
    • Location: Lawrence/KC area, KS
    Re:Cost worksheet Fri, 03/9/12 1:24 AM (permalink)
    That was my last link-restricted post!
     

     
    #2
      Blissful Bite

      • Total Posts: 55
      • Joined: 12/18/2010
      • Location: Lawrence/KC area, KS
      Re:Cost worksheet Fri, 03/9/12 1:25 AM (permalink)
      maybe not...
       
      http://theblissfulbite.com/file-area.html
      <message edited by Blissful Bite on Fri, 03/9/12 1:27 AM>
       
      #3
        mofood

        • Total Posts: 117
        • Joined: 10/12/2011
        • Location: SLC, UT
        Re:Cost worksheet Fri, 03/9/12 10:19 AM (permalink)
        Excel is a wonderful thing!
        Worksheet bookmarked for future reference.
        Nice work
         
        #4
          marco226

          • Total Posts: 177
          • Joined: 11/28/2011
          • Location: HAWLEY, PA
          Re:Cost worksheet Fri, 03/9/12 6:11 PM (permalink)
          nice i will use it/
           
          #5
            Blissful Bite

            • Total Posts: 55
            • Joined: 12/18/2010
            • Location: Lawrence/KC area, KS
            Re:Cost worksheet Fri, 03/9/12 8:43 PM (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

              • Total Posts: 3716
              • Joined: 10/11/2004
              • Location: Springfield, IL
              • Roadfood Insider
              Re:Cost worksheet Sat, 03/10/12 12:14 AM (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
              <message edited by Dr of BBQ on Sat, 03/10/12 12:31 AM>
               
              #7
                Bistro a go-go

                • Total Posts: 171
                • Joined: 2/22/2012
                • Location: Columbus, GA
                Re:Cost worksheet Sat, 03/10/12 11:11 AM (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

                  • Total Posts: 55
                  • Joined: 12/18/2010
                  • Location: Lawrence/KC area, KS
                  Re:Cost worksheet Sat, 03/10/12 4:16 PM (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

                    • Total Posts: 3716
                    • Joined: 10/11/2004
                    • Location: Springfield, IL
                    • Roadfood Insider
                    Re:Cost worksheet Sat, 03/10/12 5:31 PM (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

                      • Total Posts: 55
                      • Joined: 12/18/2010
                      • Location: Lawrence/KC area, KS
                      Re:Cost worksheet Sat, 03/10/12 6:30 PM (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.
                       
                      <message edited by Blissful Bite on Sat, 03/10/12 6:35 PM>
                       
                      #11
                        Dr of BBQ

                        • Total Posts: 3716
                        • Joined: 10/11/2004
                        • Location: Springfield, IL
                        • Roadfood Insider
                        Re:Cost worksheet Sat, 03/10/12 10:26 PM (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

                          • Total Posts: 1952
                          • Joined: 6/22/2009
                          • Location: Near You, WA
                          Re:Cost worksheet Sat, 03/10/12 10:59 PM (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

                            • Total Posts: 55
                            • Joined: 12/18/2010
                            • Location: Lawrence/KC area, KS
                            Re:Cost worksheet Tue, 03/13/12 1:05 AM (permalink)
                            Well...i guess there will always be obstacles to avoid (or knock over 
                             
                            #14
                              Blissful Bite

                              • Total Posts: 55
                              • Joined: 12/18/2010
                              • Location: Lawrence/KC area, KS
                              Re:Cost worksheet Tue, 03/13/12 1:09 AM (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

                                • Total Posts: 111
                                • Joined: 1/3/2012
                                • Location: Duluth, MN
                                Re:Cost worksheet Tue, 03/13/12 2:19 PM (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
                                  Online Bookmarks Sharing: Share/Bookmark

                                  Jump to:

                                  Current active users

                                  There are 0 members and 2 guests.

                                  Icon Legend and Permission

                                  • New Messages
                                  • No New Messages
                                  • Hot Topic w/ New Messages
                                  • Hot Topic w/o New Messages
                                  • Locked w/ New Messages
                                  • Locked w/o New Messages
                                  • Read Message
                                  • Post New Thread
                                  • Reply to message
                                  • Post New Poll
                                  • Submit Vote
                                  • Post reward post
                                  • Delete my own posts
                                  • Delete my own threads
                                  • Rate post

                                  2000-2014 ASPPlayground.NET Forum Version 3.9
                                  What is Roadfood?  |   Privacy Policy  |   Contact Roadfood.com   Copyright 2011 - Roadfood.com