Wednesday, May 12, 2010

A Restaurant Prep SpreadSheet Will Have You Laughing All The Way To The Bank!

A restaurant prep spreadsheet is pretty much a given in the restaurant business. Have no idea what I’m talking about? Well, if you’re an aspiring restaurateur, then you need to do your homework! A restaurant prep spreadsheet lets you know exactly how much of each dish is prepared. This helps ensure that wastage is minimized and also helps you ensure that you’re making a healthy profit from your business!

Too Much Or Too Less?

Are your kitchen personnel preparing too much food? Well, you can’t serve up the leftovers the next day, can you? As a result of which you either have to throw them away or let your staff feast on them! Now this is all good occasionally, but on a regular basis, every day? That’s every businessman’s nightmare! Can you imagine the amount of loss you’ll have to incur?

On the other hand, if you don’t make enough food, you’re not going to be able to serve up your customers’ favorites. That’s really not good for the business as it draws negative publicity for your restaurant. Moreover, you’ll have to disappoint your patrons and they might just decide to go to the restaurant on the next lane to fulfill their culinary fantasies! That doesn’t sound so good either!

A daily restaurant prep sheet is the answer to all your woes. This way, you can regulate the amount of food your kitchen staff makes on a daily basis and ensure that you benefit most from it since it cuts down on your losses considerably. But how do you know how much of which item to make on what day?

Menu Engineering

Mind boggling isn’t it? That is where menu engineering comes in. Yep, opening a restaurant is all about being clever with your math. And you thought it was just about food, didn’t you! Menu engineering is a field of study which enables you to asses the popularity of the food items or dishes on you menu.

This means that it is basically a tool for you to asses your profits, since it takes into account the basic market price of the ingredients and the price you sell them for. So menu engineering is essential if you want to make a restaurant prep spreadsheet.

A free restaurant prep spreadsheet it available on my site for aspiring restaurateurs, of course, seasoned veterans have already mastered the technique of formulating a proper restaurant prep spreadsheet, but you can take a look too, you may be surprised by the things that slip your mind sometimes!

Thursday, February 11, 2010

FREE Restaurant Liquor Inventory Spreadsheet The Most Accurate Way To Keep Track Of Stock


It's easy to make mistakes from time to time when trying to keep an accurate count of all your liquor inventory. Being able to easily punch in numbers at the end of the day, will make ordering time much less of a hassle. When using a spreadsheet to keep track of all these numbers, you will find out that this is the best way to keep from making too many mistakes. Having a restaurant to run involves wearing a lot of hats, so finding a way to eliminate some of the stress of tracking inventory is much needed. Using a free restaurant liquor inventory spreadsheet to monitor stocked quantities makes ordering time go much smoother. Below, we are going to tell you more about this...

An extremely user friendly site to use for spreadsheets is freerestaurantforms.com. This site has a fantastic selection of spreadsheets and the one for keeping track of liquor stock is very well set up.

The first column has the UPCS number listed, next to this is a column with the brand name of the product listed and these are sorted into different categories; liquor, wine, coolers, beer, draughts, domestic draft beer, and imported draft beer. To the right of this column is a blank one where quantities on hand can be entered, which then totals itself against the individual cost and provides a total for each brand at the far right.

Having an inventory sheet that will automatically total the costs of each product needed makes accounting much easier, as well as being able to follow a budget much closer. The sheet after the list of inventory is called the extension sheet.

This one provides the total cost for each individual category. This free restaurant liquor inventory spreadsheet is an amazingly easy way to keep track of all liquor in stock.