INFORMATION

Phone: (413) 727-8897 email: foodcostwiz@gmail.com

Wednesday, December 29, 2010

Tepid Jobs Recovery and Higher Grain Prices as Year Ends

The unemployment statistics are published monthly on the website run by the Bureau of Labor Statistics and there are many analysis reports supporting the published rate data.

The persistently high unemployment rate is broken down by segment in a occupation based table with every segment showing a very flat 2010. Statistics are for November 2010 vs. November 2009. On January 7, 2011, we can see December's numbers.

Will the recovery begin to add 100,000 jobs a month on average any time soon?

We are finishing the year with gas prices above $3 in most regions. This is high for this time of year. We are far from the high $4 to $5 a gallon we lived through during the summer of 2008.

The folks on AgWeb have a 17 minute audio clip focusing on high prices for grains. The clip is produced mainly for the farming industry. The industry benefits from high prices they can sell their grains for in the short run.

The worldwide demand for both food and fuel will have a major impact on the 2011 economy.

A Review of the Outlook for 2010

Around this time of year, many people give their outlook for the coming year. In my blog post Outlook for 2010 I made several predictions. All but one of the forecast items proved true:

We can expect the Federal Reserve to leave rates low until the job market turns the corner.

The overnight rate stayed between 0 and 1/4% for the entire year.

Increases in government spending at the federal level will be partially offset by cuts in local and state government budgets.

State and local governments were definitely in cut mode. The federal government spending was huge as the stimulus money was spent in many areas. Here in Northern Virginia, we see the new Metro link from Tysons Corner to Dulles Airport project dominating the landscape.

Somewhere in the later half of 2010, I expect the job market to reverse course as employers slowly start adding people to their payrolls.

Unemployment remained stubbornly high with no relief the entire year.

Stocks should continue the up and down motion as the Dow Jones seeks higher ground.

Wall Street is in the green for 2010. All key indexes are up for the year and we are currently enjoying a year end rally.

Any increase in consumer confidence will translate into profit since companies have reigned in their fixed costs. Will restaurants start filling their dining rooms mid-week?

Despite lots of restaurants seeking Chapter 11 bankruptcy protection early in the year, the industry is flat to up and creditors are allowing most reorganization plans to gain approval.

Look to travel indicators for signs of increased mid-week business. When airlines and hotels begin to see increased volumes, restaurants will find business travelers in their seats. Don't expect many $100 bottles of wine on business expense accounts this year. Frugal is in vogue.

Hotel occupancy rates have improved and the year end party news from downtown Manhattan had a frugal flavor.

I expect oil to remain below $100 per barrel.

I'm still accurate with this prediction but the markets are unseasonably high as 2010 comes to a close.

Overall, 2010 will be better than 2009 as the long slow recovery takes root.

Overall, 2010 was a big improvement over 2009 for most Americans. The big group experiencing persistent unemployment is a notable exception.

Sunday, December 05, 2010

Morningstar Perspectives Features a Knowledge@Wharton Study

Warming up for my Outlook 2011 post, I discovered the excellent Perspectives column on Morningstar.com. This week, they clipped a study by Knowledge@Wharton on Post-Recession America. The study uses information from the recent census.

A startling statistic is the number of Americans living below the poverty level. One in seven people are living on incomes deemed below the poverty level. This is the highest rate of poverty since they made these statistics available in the 1960s.

Friday's unemployment rate increase to 9.8% is another reminder of the very slow pace of the recovery.

Back to the Knowledge@Wharton article, they cite falling incomes and birth rates. The drops were measured using 2009 vs. 2008.

I would characterize the mood of the article as somber but they had a hopeful ending for the poor. They expect the poverty rate to decline quickly as the employment picture brightens.

Monday, November 29, 2010

Q&A Recipe Costing and Cost Accounting

rey said...

Hi Joe.
I hope I'm posting this in the correct blog.

In order to cover our waste, free bread, staff food, and complimentaries, we are planning to add a plate cost to our new recipes to cover these costs. We understand that this will push our selling prices up.

My question is as follows:
Do we add the plate cost to the recipe or do we simply raise the selling price by the respective plate cost?
Ray


Kurt_Woloch said...

@Rey:

I know I'm not Joe, but I wanted to chime in on this...

I would look at this differently. Let's look at each of the items you named:

Waste... should be attributed to the item that gets wasted. For instance, if you buy 5 potatoes, but regularly throw away one of them, the purchase price of the 5 potatoes has to be divided by the 4 potatoes that actually get used.

Free bread... free with what? Does every customer get this, even if only drinks are consumed? Or does the bread come with meals, or even only with some meals, but not all? In that case I would try to determine how much bread in average gets used for each meal on the menu and add the price of that average bread consumption to the recipe of that dish, respectively.

Staff food... should correctly be attributed to staff costs like wages. I would factor the cost of staff food into the wages, so the more time gets used on an item, the more staff food cost gets factored in.

Complimentaries... here I would ask myself what exactly causes them. There can be various reasons, and I don't know yours, but if the ordering of certain items typically leads to complimentaries being issued, I would factor the cost of complimentaries into those items that causes them.

Kurt has made several excellent points. On the terminology angle, I consider the "waste" example describes standard yield. Using the 4 usable potatoes out of 5 purchased example, we would expect to use 50 pounds of potatoes for each 40 pounds called by a standard recipe. Some people prefer to assume 100% usage and treat normal loss of weight to trim as shrinkage. The deli business uses the term shrinkage to describe all weight losses.

If they receive revenue for 20# of product they used 25# of product, we could say their shrinkage was 20%. They include standard yield, spoilage and other loss of weight in their calculation.

Should you charge for this "waste", "shrinkage", "standard yield", etc.?

I recommend allowing for expected trim loss in your recipe costing and menu item pricing formulas. The allowance for an acceptable level of spoilage may be added if your menu varies and your customers expect to pay a higher price. It is not as easy to pass along the cost of spoilage in this economy. Value conscious guests may look elsewhere if they feel your prices are too high.

Employee meals are related to direct labor costs and the food consumed is a component of your cost of goods sold. There are two ways to manage this activity. You can budget a cost of one meal per employee shift ($3.00 is used by many companies). Alternately, you can calculate the true cost of the food served to employees and deduct this from your overall food cost.

I have no strong opinion regarding the best way to handle employee meals cost. I strongly recommend setting a policy and adhering to the method in a consistent manner. Say you have no credit for employee meals today. You implement a new policy of charging $3 per shift. Any comparisons to previous food cost performance are erroneous. Don't go around patting yourself on the back because you began crediting employee meals.

Regarding free bread, I had a conversation with a friend the other day about a "best restaurants" cover in a local magazine. A prominent local TV celebrity was photographed with his wife dining at a popular restaurant. The table included a completely untouched bread basket, his burger plate and her salad plate. We were discussing why too many restaurants offer free bread at lunch to patrons who may be ordering a sandwich. Do you ask your guests if they would like some bread with their lunch?

I see lots of untouched bread baskets during the lunch service.

Some restaurants try to up-sell the freebies placed on the table before any orders are taken by the wait staff. Chips and salsa may be upgraded to guacamole and chips. Garlic bread may appeal to some of the free bread lovers. Some of your guests may make a meal of the preliminary course. You need to be careful.

A friend of mine milks the preliminary offerings to the max. If the restaurant serves olive oil, he'll ask for extra and sometimes they bring a bottle. One place we enjoy serves bruschetta. He requests extra topping and the servers always return with a generous amount in a small bowl.

You absolutely should charge for the complimentary items somewhere in your menu prices. One of my favorite Upstate New York restaurants offers access to a small salad bar along with a mini loaf of fresh baked bread once you place your order (half chicken is the most popular choice). If they didn't build the cost of the salad bar and bread in their prices, they would be in deep trouble. On my last visit, I paid below $10 for the meal.

Tuesday, November 23, 2010

Forecasts For Better Food Cost Results

Most restaurants have an automated ordering system (POS) which can be queried for menu item counts for any given data range. This data is quite helpful for the forecasting team in restaurants using a limited menu or a menu with a central focus (either by cuisine or main ingredient). Unwieldy menus do not allow a quick menu item count forecast (using historic POS data) to effectively buy most key items.

At the core, most forecasts begin with the cover count or number of guests expected to arrive in a given time period. Adding the check average to this cover forecast will provide the people designing a shift schedule with a target. Simply take the covers times the check average times the target labor percentage. This is the budget for the period.

Food cost control is not a percentage game in the planning phase. Although most use food cost percentage to measure results, the number won't help you predict what food to order, store, prep and bring to the line for any given period. Cover counts and check averages will provide a broad target. Making the target work is a tougher task.

For many raw ingredients, the ability to use unsold product in future meal periods has a significant impact on your food cost results. Limited menus put a short list of ingredients in play every single day. They don't need to worry how to use any leftover cheese at Domino's Pizza. Pizza is on the menu tomorrow. In contrast, operators using menus relying on daily specials for a major share of sales will have a much more demanding job to use up leftover stock.

The purchasing forecast depends on par stock targets for many shelf stable items. In a typical kitchen, a much greater share of the food cost dollar is spent on perishable meat, fish and produce. The error penalty for over ordering a shelf stable condiment is minimal when compared to fresh white fleshed fish. You will often see seafood specialists with chalkboards. Late in the dinner shift on a busy night, they want to run out of fish if the next day's forecast is for a slow Sunday or Monday.

My favorite Italian restaurant in New York does not offer fish on days when the fish market is closed (Saturday and Sunday). Some chefs pay air freight to get fresh fish in the door as fresh as possible. You want to avoid over buying any highly perishable raw ingredient. Just ask your self a simple question: "If I order more than I can use today, will I be able to sell the leftovers tomorrow?"

Once you move away from fresh fish and poultry, dairy and produce are highly perishable and are frequently purchased by specialists. If your operation doesn't justify hiring a specialist, tracking produce waste can help you adjust your pars quickly. I favor either a two-tier or three-tier par stock model. Order more before busy days and less on slow days.

I believe using sophisticated software (with menu item counts, standard recipes, standard yields and other recipe model factors) are most useful for companies who have never explored these tools. Often, my clients tell me they wish they had analyzed their menu item costs years ago.

The knowledge gained from yield analysis really improves future forecast accuracy. If you learn to translate purchase units of measure into the number of standard portions, you will have a competitive advantage. Your forecast model can now go well beyond covers, check averages and percentages. Take your top 25 items and buy more precisely. The impact is huge.

Tuesday, November 02, 2010

Essential Food Cost Control - All You Can Eat Operations

Dear Sir,

I have recently joined as trainee accountant and been assigned to conduct an audit of a catering project. However, I am clueless on how to arrive at a food cost. Below are the three targets I was provided and while I was looking over internet I found your blogs to be helpful. Can you please provide me any formula or a table that can be of help?

Check cost per man day and whether it has been under control as foreseen in the costing.

Check the menu and cost whether it complies according to the contractual stipulations.

Fix budget for cost centers and follow up in the subsequent months whether the expenditures are under control or not.

Thanks in advance sir.

Regards,
R

The key to success for your operation is in a complete understanding of the cycle menu. Certain weeks will run higher food costs. You will find certain days of the week run high and other days much lower. Once you get a feel for your menu and the patron preferences, your cost data will help you track the actual results vs. the plan.

Cost center analysis is best accomplished through head counts by meal period. Track the number of patrons for each meal period and for each dining area.

A cost per man day is a composite number which depends on the total cost of all food consumed. Slicing and dicing the total cost requires tracking patron attendance and food production. You'll get on top of the formula quickly by tracking details of the patron attendance and the traditional food cost formula:

FOOD COST = BEGINNING INVENTORY + PURCHASES - ENDING INVENTORY

Count data should be gathered by day in the cycle, meal period, dining room and any special event details. Really, there is no specific pattern to follow. Your contract will have details which will guide your selection.

Quantity Food Production Skills

Hi Mr Dunbar,
How are you. Sorry to barge in like this but as a new entrant I need your help. I was a kitchen manager in an a-la-carte restaurant with my staff cooking for small tables.

I recently got a new job as production manager for banquets at [a major sports venue]. The issue here is that there is a sudden transition from line cooking to volume/bulk cooking. My Director of Operations asked me today if I can to make a changeover from line cooking to volume cooking. I am supposed to instruct and lead the cooks in what they do.

No more a la carte but 4 buffets serving 125 to 150 people who come to see the [sports events]. What do you think the issue is? I suddenly can’t cook bulk as a demi-chef since I don't have the experience. Are there any books which cater to this situation? How do you transition from a la carte cooking to bulk cooking, when you have the theory but no knowledge of volume cooking? Any help will be really appreciated.

Chef

Buffet food production in a sports arena requires accurate forecasts. The teams may go on the road and leave you with a walk-in cooler loaded with leftovers. On the other hand, you don't want to stock out on game day.

Unlike an a la carte menu, a buffet deals with a set layout. You know what to produce but you don't know exactly what will be most popular. Once you get some data, the puzzle will be easier to solve.

I prefer a matrix for tracking buffet results. The rows are the buffet components and the columns track the activity. The first column is my forecast and I try to relate the PRODUCTION forecast to the service line. For example, if an item is served in a pan I would forecast the number of pans. The next column SERVED is the number of pans consumed by guests. I finish the simple table with a WASTE column.

You may be able to use some of the food in a future event but be careful. Recently, I was sickened by a meal I had at a football game. The service style was buffet and the food was not uniformly hot. Bringing the temperature of full pans down below the danger zone for bacteria, reheating days later and sending the pan back on a serving line is risky business.

Imagine you are serving 100 people. Take the buffet layout and take each menu item separately. Guess how many ounces each patron will consume. Don't use 12 ounces or 8 ounces as you would in an a la carte operation. Try 3 or 4 ounces for popular items. Use a lower figure for less popular items. This is your forecast base.

Thursday, October 28, 2010

Using Mark Ups Instead of Food Cost Percentage

Hi Joe,
I like your site, excellent information.

I am looking for a resource that explains why operators would use ‘mark-ups’ of factors over FC%.

I teach food costing to our chef students and always use FC% to get a selling price, but now I have to explain the other options but can’t seem to find good definitions of why you would use the other options of obtaining selling price.

Could you offer any advice?

Kind regards

Mark Caves
Culinary Arts Tutor
School of Tourism and Hospitality
Faculty of Arts and Social Sciences
Eastern Institute of Technology
Hawkes Bay
New Zealand

Thanks for the question Mark.

During my corporate years, we never used food cost % since our billing method was per man per day. To get more current, it helps to use a destination resort for an illustration. Many resorts located in the mountains offer a complete package including room based on double occupancy, all meals and snacks, and optional activities.

We were big fans of these hotels and inns when we lived in Quebec. You can get a fantastic price for mid-week visits. Any operator who wants to offer a competitive all-inclusive price needs to know their costs to the penny.

Caterers should not use food cost percentage to control their costs if they offer packages. In my July 2008 post Profitable Special Events , there is a chart designed to show the impact of raising $200,000 of additional revenue. I included the % analysis to be complete but the focus was on the cost per guest for each cost component (including profit).

Many caterers and hotels negotiate a final price in a competitive environment. If the sales team does not have a hard deck figure, you may find yourself working very hard for free.

Why do percentages fail in these operations?

One of my early catering clients was barely breaking even. He was an attorney with a major investment in a catering hall. When we met the first time, he was shocked he couldn't break even although his 25% food cost number was well below the 32 or 33% figures mentioned in the book he used to put together his business plan.

I asked him what he used for the divisor.

He was dividing his net food purchases by total sales. Many of the events were cocktail receptions held in the evening hours. Guests were treated to a full bar with several stations and hors d'oeuvres served by wait staff. I asked him what his bar cost % was for the same period of time. Due to his belief in serving top shelf liquor and premium beers and wines, his bar cost percentage was 14% of total sales.

The combined cost of goods sold was almost 40%. I explained what he needed to do to cover his costs and produce a reasonable profit. He had 2 options: raise prices or reduce costs (or a combination).

Food cost percentage analysis is also mediocre for buffet management. Any all-you-can-eat buffet operation would get a better view by tracking layouts and components. There are strategies for controlling high cost proteins and promoting low cost desserts. A simple food cost % tells you very little about this type of meal service.

Monday, October 25, 2010

Purchasing and Food Cost Results

Hi Joe,

Your site is the best thing I've ever found on food cost.

I have a question and was hoping you could help me clarify something:

Is my food cost percentage affected by high purchase amounts? I understand that my Food Cost will be high as the value of my inventory will be high, but in terms of % versus sales does it really affect it?

Let's say theoretically, I do over purchase, but none of what is purchased spoils and I don't waste anything except for my usual amount of waste in production. Essentially my food cost should stay near to where it usually is correct?

Thanks,

Steve
Operations Manager

Yes. Just don't make it a habit. Chronic over ordering will certainly impact your food cost results in a highly unfavorable manner.

Your food cost always equals net purchases. The percentage simply relates the net purchases to your sales volume. In fact, most operators do over purchase food. Their #1 concern is running out of stock. Most ordering models have a safety factor built into the formula.

Problems often show up in an indirect way. I have seen employees served crab cakes and roast filet mignon for lunch. Freezers packed with protein items originally purchased fresh and stored in the refrigerator show a high ending inventory total. "Blowout specials" are used to "burn off" perishable items lowering sales and increasing the food cost percentage.

Like any industry, we suffer from a lack of flexibility anytime our ending inventory is inflated. Simply stated, your chef won't be able to take advantage of future opportunities if he becomes concerned with proper use of the current stock. In fact, this focus can really produce catastrophic results when you start to look at rehashing protein items.

I will offer an extreme example. This example happens to be a true, real-life story. A chef gets a call from a seafood salesman in Alaska. The salesman knows the chef enjoys working with fresh caught Alaskan salmon and halibut. The deal involves an order of 25# of fish with free air shipment.

On the delivery day, the UPS driver was sick and his replacement went to the restaurant at the wrong hour (they are a dinner house). The fish made the complete route tour before landing back in the UPS warehouse.

The chef had a person try to locate the driver on his route most of the afternoon. This employee drove over 30 miles in Friday rush hour traffic. Eventually, he went to the warehouse and waited for the fish. At 6 PM, he got his hands on the box and the chef had the salmon at 7 PM. Of course, he was compensated for his time and gas used.

The wait staff began pushing the salmon special later in the dinner shift since the fish needed to be prepped and the manager needed to add this special to the POS system. The special was not included on the original printed specials page. It was immediately added to the chalkboard. Menu pages were reprinted.

They sold 75% of the fish over the weekend despite the problems. By Monday, the remaining salmon was frozen. Did the chef get a good deal?

To his credit, he did not offer a "blowout special" on the slow Monday. Alaskan salmon changes dramatically in taste and texture once you freeze and thaw the fish. The frozen product was eventually used in a fish soup.

The story illustrates some of the issues you need to consider. A small amount over purchased in your low point of the week will be consumed in a special during the busy times. However, a large buy for the busy days will not be consumed on a slow night. When the salmon was eventually used in the soup, there were plenty of local fish species available for a fraction of the price paid for the air shipment.

As you increase the number of protein options on your menu, the likelihood of waste and spoilage does increase. Your assumptions may not jive with reality once the number of protein options hits 10. If you serve a diverse menu, you expect to live with a manageable level of spoilage and waste. When this level becomes too high, the food cost percentage will suffer.

Wednesday, October 20, 2010

Food Cost Formula Illustrated

I have been active using email with HT this week. His company does not track food cost using a percentage target. This is the way we were trained in my role as operations auditor with Sodexo on remote site feeding projects.

HT works on a drilling rig. Although most North American remote sites from my days in the 1980s are now cities and towns with airports, shopping centers and good roads, drilling rigs will always need support services.

We have emailed each other in order to clarify the billing policies on his contract. Unlike our contracts which allowed billing for a full manday as long as a resident attended at least one meal, on HT's jobs they only bill for the meals attended. The clarifications and a revised spreadsheet follow.

Clarifications:
Q. So 1.5 is 15% of 10. We expect breakfast to be 15% of food consumed. This is what I call a target (a goal).
A. OK

Q. The count for each meal just explains how many showed up for the meal. What if someone only came to a single meal but ate like a horse, do we get a complete manday? or only the 1.5 divided by 10 if breakfast?
A. He will be calculated at the times he would eat.

If he attends breakfast only then YES 1.5 divided by 10 for the numbers who have attended the breakfast then the number of those attending lunch and so on then we add up all and this would be the MEN ON BOARD count since there is a price for each of the meals.

Q. On our jobs, if they ate even one meal we billed the entire day. This is one part I do not understand for your project.
A. You see, that's why the lunch is the most expensive cause we would have low numbers and even near to steady numbers on all meals except for the lunch where there will be visitors.

The resulting control model carefully tracks the budget per meal applying the correct target cost per meal. This analysis shows the maximum food cost total which will meet our budget target. The actual food cost is determined by the traditional formula [Beginning Inventory + Purchases - Ending Inventory = Food Cost].

Returning to our previous example, I have added the actual cost data and a variance field.


For those of you who live and die by the FC%, you may find the meal method helpful. I like the meal method to test the impact of dayparts on the food cost results. The focus is on dollars (or your local currency) vs. percentage. Your percentage results will improve by adding this tool to your kit.

When you track your costs by meal, you will develop a food cost system which will produce a true variable cost. Fluctuations caused by seasonal issues and busy day/slow day issues will be eliminated. You may need to track your employee meals more carefully. We treated each employee meal the same as a billable meal. The idea is to track your food used based on a budgeted cost per meal.

Most POS systems will have a report which recaps the check average by meal period. These check averages will help you develop a per meal budget. Changes in customer habits (like a shift from soft drinks to complimentary tap water) are easier to track. Customer profiles will help you think through the menu pricing decisions in a strategic manner. The QSR operations have done a great job developing value meals. I have always been a fan of the table d'hote option for dinner houses.

Try tracking your costs by the meal or guest and you will see your food cost in a new light.

Monday, October 18, 2010

Calculation of Food Cost Per Man Per Day (Man-Day)

Hi Joe,

I am really grateful for your prompt answer and the time you dedicated to answer my query. I apologize for not presenting full information as I had serious doubts I would receive an answer!

Allow me to present these facts:

1-My objective is to calculate the cost per man/ day ( breakfast, lunch, dinner and midnight)

2-The known facts every day are :
a) the number of meals presented to the client which you have inserted in the first matrix
b) the total cost of the food ingredients for all meals together.

3-If the 4 meals presented every day cost = 10 then the Company base its calculation on the following ratio: Breakfast = 1.5, Lunch = 3.5, dinner = 2.5 and midnight = 2.5

Once again, I thank you dearly and look forward receiving your feed back.

Best regards
HT

I worked in the remote site feeding and support services division of Sodexo for 9 years. We tracked all of our costs per man-day. If you carefully track your cost of all ingredients each day and divide this sum by your manday count, you'll arrive at an actual cost per man-day.

The other meal level information is your standard cost data. You need to hit 10 per man-day and you have targets for each meal period. I would recommend you divide the day into two parts - Midnight/Breakfast (target is 4) and Lunch/Dinner (target is 6). You can isolate most operational problems and focus on a solution if you get closer to the actual variance.

You may find the 1.5 breakfast target is too low but the lunch target of 2.5 is too high. Of course, you could look at each meal independently each day.

On our camps, we served large beefsteaks twice a week. Workers (our customers) consumed over 5,000 calories per day. They were working hard in the frigid regions of Northern Canada and Alaska. Steak Nights were a major component of our food cost results. We knew the cost of the steaks served and the average number of steaks consumed since the impact was high.

We served buffet style meals in an all-you-can-eat format. Our guests were served the entree and sides by one of the chefs or cooks. All salads, desserts, rolls, etc. were self-serve. Beverages were self-serve.

Our team knew the cost of the salad bar, the dessert station, the beverage station and average condiment usage. The cost of the items served by our main line varied based on a cycle menu.

If your operation is similar to the one I described, I recommend using a week as your report period. Most cycle menus will begin to track a tight cost range for each week of the cycle. You will find great variations on the dinner meal period based on the day in the cycle and the cost of the protein and produce items.

Calculating Average Food Cost for Multiple Meal Periods

Hi,

Thank you for your article "Food cost basics" which is published in foodservice resources.

I have an inquiry related to food costing and I hope you could help me figure it out:

If I am serving 20 Breakfast, 30 lunch, 50 Dinner and 10 midnight meals for the same customer , how could I calculate the average food cost per person knowing that the cost of the meals are as follows : breakfast =1.50, lunch and dinner = 3.00 and midnight meal is 2.50?

I hope you can help me on that.

Thank you and best regards,

Hesham

Let's take a look at the information you supplied. This information is essential to answering your question. To illustrate my first view, I have created a quick spreadsheet:


We have enough information to calculate the average cost per meal. The spreadsheet shows the process which involves 3 steps:
A. Multiply the cost of a meal by the meal count for each meal period.
B. Add the total meals and total costs.
C. Divide the total costs by the total meals to find your average cost per meal.

Food cost percentage involves relating the average cost per meal to a sales per meal. Since I don't have this data, I have used sales prices which would produce a food cost equal to one third (1/3) of my costs (33.3%). If I had the actual sales prices, I would have constructed a second spreadsheet:


Your food cost percentage depends on your sales and your costs. For each meal period, you need to multiply the price times the count to get your sales for each period. Add the sales and divide your total costs by your total sales.

Thursday, September 30, 2010

Lower Food Costs Provide Edge

In an article written by Jeremiah McWilliams in Tuesday's Atlanta Journal Constitution, Sara Senatore, an analyst with Sanford C. Bernstein, is quoted regarding the impact of rising corn prices. She said "eventually that's going to trickle into protein..." in a discussion about poor crop conditions and rising demand for corn.

The article also mentions the ability of major chains to dampen the impact of rapid price increases through use of future contracts. However, many of these long term contracts will be expiring in the months ahead.

There is some speculation regarding the expected reaction on the part of major chains. Will they be able to continue to win the futures game? Will they pass along the impact of rising prices to their customers through higher menu prices? Will they simply eat the higher prices they will pay for food?

Most likely, we will experience all three reactions. The industry leaders will continue to sign long term contracts with farmers and food producers. Menu prices will likely increase and companies may need to absorb the market price spikes on their second tier food items.

Companies with tight cost controls will enjoy a major advantage. They will benefit from clear reports which will help them manage the inflationary environment. By measuring the impact on their specific operations, higher protein and grain prices can be managed effectively.

You may find less customer resistance to higher menu prices as the chains react to the higher corn prices. If you successfully raise prices, retain customers and control your food cost, you will gain a huge edge over your competition.

Sunday, September 19, 2010

Production Food Cost

Most restaurants purchase raw ingredients and produce and sell finished menu items. Our management accounting should be structured in a manner similar to a manufacturing operation. The wait staff should be considered the sales force. They meet the customers and help them order a delicious meal.

We find a beehive of activity on or near the production line in most restaurants. The wait staff wants to rapidly fill orders and the production staff handles orders as efficiently as possible given the equipment constraints and staff levels.

Unlike most manufacturers, a majority of food service managers do not track work in progress and finished goods inventory. Our finished goods are immediately delivered to the dining room.

The terms batch recipe, sub-recipe or prep recipe are used to describe the items produced ahead of the meal period. These items are available to the line cooks and are used to produce more complex menu items. Common prep items are sauces, dressings, stocks, casseroles and other items which take longer than the typical meal cycle to produce. Butchering, produce cleaning and other prep activities convert raw ingredients into portioned items and salad mixes.

Food service operators need clear policies to handle these inventory valuation issues. Inventory valuation is important since the cost of goods sold depends on consistent treatment to determine beginning and ending inventory values.

There are many different accounting policies employed by major food service companies. One of the largest hotel management companies in the world does not use food inventory in their balance sheet and income statements. Food cost reflects all food received from their suppliers each period. Other companies do not value any work in progress inventory. These operators use a prep cooler and management's goal is to minimize the amount of food in this zone.

Due to the increase in report complexity, we often miss the opportunity to evaluate the true cost of batch recipe production. The key reason for tracking batch recipe production, including the cost of direct labor, is the ability to compare the total cost with the available packaged goods.

Salad mixes using romaine lettuce are very popular. For many companies, the value added by cleaning and trimming the vegetables and heads of lettuce does not justify the cost increase. The packaged salad mixes offer a high quality alternative with very low labor costs.

Operators are trying to manage relatively high production costs. Salad production involves many hidden costs: transportation of unusable trim, water used to clean vegetables (often left running during the prep), garbage removal to discard the unusual trim, and higher volatility in market costs. The direct labor is not completely hidden but may be cloudy when the workers handling prep also work in other stations.

So what? Why should anyone care about these issues?

The cost of meat and seafood requiring butchering and vegetables requiring prep may be over 50% of your cost of goods sold. You may have significant hidden profit buried in your operation. The amount of hidden profit may justify a quarterly study comparing prep vs. direct purchase on several key items. If you have a policy of producing everything from scratch, you need reports which allow you to monitor production.

Friday, August 27, 2010

Menu Engineering Using Excel

During the month, three fellow restaurant consultants have contacted me about menu engineering and recipe costing with specific questions regarding Excel. Excel charts do not automatically create the popular four quadrant chart with Stars, Plowhorses, Puzzles and Dogs (or any of the other 4 quadrant variations). I have accomplished this task using a few third party utilities. In my analysis, recipe costing is accomplished using software specifically designed for this purpose.

I consider the POS system Product Mix report the source of the key data. Since menu engineering is concerned with selling price fluctuations, the PMIX report has all essential data (number sold and selling price) except the cost to produce each item. Most POS systems have Excel file export capability. If you are adept at the table look-up formula, you can place the exported data exactly where you need it in your model.

Generally, I use good old data entry to update the recipe costs using the numbers from the software. Once I have the number sold, selling price and recipe cost, the sophisticated menu engineering and analysis reports flow from Excel. The four quadrant chart is not the only report produced. You can use sorts and filters to generate a tremendous amount of valuable information.

Anyone who wants an all-in-one solution for inventory, recipe costing, purchasing, menu engineering and requisitions really needs to invest in a proper solution. Excel tables are famous for errors in formulas and there is no audit trail for your purchases (which feed all cost calculations).

Many people have asked me for a recommendation. I do not own a restaurant and I do not have a laboratory in my office with 20 different recipe costing programs loaded and ready to test. In fact, many of the popular software solutions come out with substantial improvements each year. It would be a full-time effort for anyone to honestly provide this type of service.

Many of the popular solutions target a segment and do a terrific job. FoodTrak moved from a restaurant model to a hotel/resort model around 2000. They added transfers and requisitions to the essential restaurant reports already in the program. The reasons I tend to work mostly with FoodTrak: longevity and optional cost methods. They have been around since 1980 and I started my company in 1990. If you need FIFO cost numbers, you won't find a better solution for the investment. There are other programs in the six figures range which have true FIFO but I am assuming very few of my readers would invest $100,000 plus for a solution.

There are many programs capable of decent reporting using the last cost method. I encourage anyone on a tight budget to start with one of these solutions for recipe costing needs.

Sunday, August 22, 2010

Putting Excel to Use in Food Cost Control

I mentioned my love of Excel in last week's post about software. Excel is ideal for 3 aspects of the food cost control environment: organization, complex calculations, and custom reports.

ORGANIZATION:
Most of the food cost control software assumes you have your entire database conceptualized and you simply need to tap enough keys to create the ideal starting point.

Newbies will find plenty of challenges ahead.

Inventory locations, vendors, item categories and inventory sequence are database requirements for phase one. You initially build the item database to aid you in purchase order and invoice entry (the areas requiring 80% of the time once you go live). At the same time, inventory count sheets need to flow from the item database (along with any batch recipe production items).

Excel is a great tool for getting organized. Build columns for the item description, primary vendor, vendor codes, bar codes, category (produce, meat, fish, etc.), storage method (frozen, refrigerated, dry), primary inventory location (where you look to decide when and how much to order), unit of measure data with conversion factors to allow purchases, storage and recipe usage, par levels, alternate item codes (the vendor code for the item you would purchase if there was a stock out).

COMPLEX CALCULATIONS:
Food cost control involves using scalable recipes to forecast production requirements, purchase requirements, and line setup requirements. In addition, plate recipes help you forecast profits, calculate usage variances, and price menu items. The top software will provide plenty of excellent information. Excel can provide you with customer profiles, sensitivity analysis (what-if?), and many other advanced concepts.

CUSTOM REPORTS:
I use a data mining tool to create custom reports for my clients. Typically, the client will send me their favorite report and ask a question: "Can we get all this exactly the way it is AND add a column on the end which....?"

The data mining software creates the calculation field missing in the source report. Mining software always offers several output options including text, CSV, PDF and Excel formats. I often choose Excel since the analyst can take the analysis further if necessary. Excel offers all of the formats mentioned for the final presentation.

Tuesday, August 17, 2010

Food Cost Control and Excel

Question:
Joe,
I'm looking into buying a menu costing program/software are there any you recommend?

Answer:
I can recommend 2 or 3 solutions. It depends on your long term objectives. Please email me at joe@joedunbar.com so we can pick your ideal solution.

Response from Erik:
From what i have come across, Excel should be the go-to costing program and you should use your own data.


Good point Erik!

I can't think of food cost control without Excel in the picture. The only issue I have is the term "Excel user" has a tremendous variation.

There are people who could model the Big Bang using Excel and other people who haven't discovered the SUM formula (use + sign).

Importing history into Excel is a pain if the files change (for example, a new menu item) for anyone who hasn't mastered Excel's terrific data functions.

Once the power users get everything done conceptually, many migrate the model over to Access so database updates go smoother.

Somewhere along this curve, the benefit of purchasing a software tool specifically designed to handle recipe costing, menu analysis and cost control turns positive.

Many of my clients had terrific Excel based recipe costing models which helped us in building a solution. They often find additional savings of 10% (i.e. if their current Excel control food cost was 30% they would find the new food cost would drop to 27%).

Overall, I believe Excel is the logical starting point for anyone who is serious about getting on top of their food cost. My advanced menu analysis tool - The Menu Map - is 100% Excel based. Since the model focuses on only 3 data points (selling price, food cost and number sold) at the core, Excel is ideal.

Once you want to filter purchase data, Excel loses the power a serious food cost controller needs for investigating problems.

For example, FoodTrak lets you filter invoices by date range, vendor, report group, invoice number, and specific items. There are exception reports to bring many issues to your attention and the terrific data entry alerts show major price variations in real time.

Resorts may need transfer cost reports. This report is a major pain in Excel. Cost updates from purchase data provide freshly costed transfer reports by profit center. Of course, many operations do not have this need. The answer really depends on the operation.

[This post is from comments on the Basic Recipe Costing post.]

Tuesday, July 27, 2010

Question on Food Cost Basics

Joe,

My name is Steve and I am starting a new job as a Sous Chef but haven't learned anything about food costs or labor costs and I am afraid to not be able to be a team player on this important situation, that I am final realizing that its part of my job. Can you please teach me how to do all of this or point me in the right direction. I have read your basics on food cost but still I am having trouble understanding it all. Thank you for your time.

Sincerely
Steve


The goal of food purchasing is to place the food in inventory as close to actual production as possible. People who are pros know delivery dates and times, par stock levels, minimum drops, shelf life, and most important, the forecast for the order period.

The food cost formula is really a report card on how well you forecasted for the orders. Most food service companies have several backup suppliers they can use if they experience sales far beyond the forecast. Typically, these last minute purchases are made at cash and carry stores with much higher prices.

The heart of the food cost formula is purchases. You simply divide net purchases by sales. If you forecast your sales carefully, you will make better purchase decisions.

As a learning tool, you may want to take a look at 4 or 5 weeks of invoices to see past purchases. You can discuss spoilage and waste with the chef. Ordering is most important before busy periods. You need to have adequate supply without creating excessive waste. If you keep score, you will rapidly improve.

Friday, July 23, 2010

Question on Batch Recipe Costing

Hello Joe

My name is Tay. I just purchased a bakery in Minnesota and I would like to know if you can teach me how to estimate the cost of a croissant. Without knowing the formula, I'm afraid not to place the right price. Please give a example. Is there any software on the market?

Thank you very much!

Tay


Thanks for the question Tay.

Gather all the ingredients you need to make a batch of croissants. Write down the amounts of each ingredient required for the batch. This is your recipe.

Using purchase data (use invoices or go to a store if necessary), calculate the cost of each ingredient. You need the cost of the amount used in the recipe not the cost of the entire purchase unit (for example, pound vs. case). Add all the costs to find the batch cost. Once you complete this analysis, you are done with the cost of the batch.

[NOTE: The step above is the trickiest and the most important. For each ingredient, you are asking yourself how many batches you could produce from the common purchase unit of measure (for example, a bag of flour). In the long run, this data is used the most. Prices will change over time but the ingredient quantities will remain the same. Don't rush this exercise. Most recipe software programs call the answer to this question the "Conversion Factor" and it is very important.]

Carefully portion the croissants. Count the croissants. You now have the recipe yield. The formula follows:

Portion Cost = Batch Cost divided by Batch Yield. For example, if you had a batch cost of $45 and you were able to produce 100 croissants, your cost per croissant is $0.45. If you charge $1.50 per croissant, your cost % is 30%.

Thursday, July 22, 2010

Mid-Year Look Back - Outlook 2010

My most popular blog post this year is by far the Outlook 2010 which was published in early January 2010. I thought it would be interesting to see how well my predictions have fared during the first half of 2010.

We can expect the Federal Reserve to leave rates low until the job market turns the corner.


The Federal Reserve Board has cooperated with business borrowers leaving the over night federal funds rate at record low rates (zero to 1/4%).

I expect oil to remain below $100 per barrel.


Despite the BP debacle, the crude oil markets have remained in check and well below the $100 per barrel threshold.



Source: ino.com

Stocks should continue the up and down motion as the Dow Jones seeks higher ground. Any increase in consumer confidence will translate into profit since companies have reigned in their fixed costs.


Both the Dow Jones Industrial average and the broader S&P 500 index have seesawed back and forth in the search for direction. Corporate profits are definitely higher than 2009.



Source: finance.yahoo.com

Look to travel indicators for signs of increased mid-week business. When airlines and hotels begin to see increased volumes, restaurants will find business travelers in their seats. Don't expect many $100 bottles of wine on business expense accounts this year. Frugal is in vogue.


There was a short clip on CNBC today regarding higher occupancy rates at the Starwood Hotels group. Many of my clients who have a significant business expense account clientele report a gradually improving climate. Guests are reviewing check totals quite carefully.

Sunday, June 27, 2010

Optimal Order Size Question

When creating a build to for food orders, what is the exact formula
used? I know it's units used divided by how many days and something to
do with how many deliveries a week.

James


Thanks for the question, James.

Use of the formula described depends on the shelf life of the product. For example, fresh picked raspberries have a rapid spoilage rate when compared to frozen raspberries. The average daily usage/number of deliveries per week model works well for high volume items with a shelf life of 7 days or more.

A twist on this method you may find interesting is to multiply your expected sales (in dollars) by the average consumption per dollar of sales. If you used 1 case for every $1,000 in sales and your sales forecast is for $20,000, you would require 20 cases. Simply check to see what the in stock level is and order the net amount. In our example, we would order 18 cases if we had 2 cases on hand.

Should we order extra in case our sales forecast is off? I think the answer depends on your number of deliveries per week, the day of the order, and your ability to adjust to actual sales volume.

If you are placing a Thursday order for a Friday delivery to handle a busy weekend and you can't get the next delivery until Monday, you would want to provide for a small cushion. On the other hand, a Monday order to replenish your inventory should not be inflated with a safety factor. Your suppliers are most likely in your area all week for any adjustments.

To utilize this method, ask your distributor for a quarterly tracking report. Next you should run a sales recap for the same quarter on your POS system. Divide the number of cases on the tracking report by the total food sales for the quarter. The result is the average usage in terms of sales.

Thursday, June 10, 2010

Should You Cherry Pick Spot Prices?

The quotes come in via fax and the internet. You load them into your recipe costing/inventory software. Next, you feed a shopping list to the program and you print the suggested orders. After some minor changes, you send the orders out to as many as 10 vendors. Is this a smart way to buy?

Yesterday, my client and I were on a conference call with a sales rep from Gordon Food Service in Michigan. Our objective is to eliminate waste in the restaurants. I have always recommended weekly inventories but the salesman's advice was twice a week. He wanted us to feed the online ordering system with the inventory counts on Monday and Thursday. Rather than going through the storage areas with a shopping list and jotting down order quantities for under-stocked items, he encouraged my client to take a full inventory.

If you have never been good at inventory control, the journey to tight control absolutely requires a tremendous change in the normal routine.

You may be unwilling to take twice a week inventories for the entire restaurant. Consider phasing in inventories by category starting with protein. In addition, carefully monitor all waste due to spoilage. If you have a sophisticated database loaded with over 100 count values per year, your entire purchasing history and details of your waste, par values will stare you in the face (with seasonal variations).

More importantly, we want to eliminate waste. Ordering too much of a perishable item with a high cost per pound and a major change in taste and texture profile when frozen has to be avoided. As you begin to order the appropriate quantities, your supplier can work with you on the proper pack/size for each item in the non-perishable goods section. They can help you find labor saving alternatives.

I believe it is highly advisable to stay aware of market trends. Whether I would go the cherry picking route in today's marketplace is the question. It's typically a mistake.

As far back as 1981, Tom Noble from Denver (eventually sold his business to Sysco) sent his rep out to our construction site in Parachute Creek. We setup a ordering guide for our comprehensive 4-week cycle menu. Scott, our Noble rep, went through the stockrooms, walk-ins and outside freezer. He designed a storage sequence for each room. We bought almost everything from this company. Our contract allowed us quarterly audit access and we had a Denver office. Once in a great while we would complain about meat yields. Overall, we enjoyed a very low cost per man per day and waste was non-existent.

Until you work with a competent supplier armed with an excellent database, it's tough to see the way to single source. Go ahead and take the plunge. The potential is huge.

Sunday, June 06, 2010

Historic Costs vs. Future Costs

The role of a food cost controller is much different from the menu analyst. Cost control relies entirely on historic data to prepare reports which quantify results and alert management to possible problems or opportunities. On the other hand, the menu analyst needs to look to the future.

When a menu price revision takes place, the prices need to cover the future costs and provide a reasonable profit. Knowledge of commodity trends, economic forecasts, unique events in the coming year and other future oriented information is helpful. The costs used to arrive at theoretical menu item costs should use these expected prices.

The food cost controller studies purchase data to understand the previous period. Use of theoretical food cost data may help the controller discover a usage problem. Usage problems involve units rather than dollars. There is concern regarding missing steaks or shrimp or perhaps an entire case is gone. Purchase costs are important only when there is a big swing in price on one or more high volume items.

Using the same price data for both menu planning and food cost control is a mistake. The portion sizes for all key items should be 100% exact. It is the prices which need to vary. Many operators simply take an educated guess on overall inflation and raise menu prices across the board with the same % increase.

Ideally, the menu analyst benefits from the ongoing work of the food cost controller. Portion control tests, relative price volatility and other information the controller has at their fingertips is valuable to their counterpart. They should work together to discover how the current menu has performed.

In a highly collaborative organization, the cost control team could utilize information from the menu analysis team (e.g. future menu price revision strategy) to create better budgets.

Thursday, May 27, 2010

Spotting A Problem Early

We had a rather difficult winter here in the Washington, DC metro area. With a mild winter snow removal budget, we got hit with a severe winter snow fall during the key month of February. Just as the New Year's resolutions relaxed for Super Bowl Sunday, the snow took away the weekend. Local super markets were out-of-stock on milk, bread, orange juice, bacon, ground beef, and many other staples. Restaurant parking lots were empty.

This rough weekend repeated itself for Valentine's Day and President's Day weekends. I spoke with one operator who said his February food cost percentage hit 45%. This is a common trend - high cost of goods sold % in a low volume month.

I like to chart a month like this vs. a high volume month. The key to using this type of analysis is dollars vs. percentages. If you have a bad month with $200,000 in sales and $90,000 in cost of sales, you'll be close to the person I spoke with in February. Contrast this poor performance with a busy month's $800,000 sales figure and a cost of sales equal to $240,000 or 30%.

The change in sales volume is $600,000 ($800,000 - $200,000). Cost of goods sold had a change of $150,000 ($240,000 - $90,000). The slope is 25%. This is the variable component of the food cost. The fixed component is $40,000.

We'd expect a food cost of 29% if we hit $1,000,000 in monthly sales. On the other hand, we would expect to see a $65,000 cost of goods sold if we only manage a sales figure of $100,000. That's 65%!

If these numbers seem completely off the wall, they are not at all unusual for out-of-control operations. The bad months are explained away with stories of blizzards, rainy days, traffic jams, competitor discounts, etc.

Your cost of sales should be almost completely variable. Food should not be consumed if there is no sale. Why do you use more food when you're slow?

Employee meals have a bigger impact. The fixed staff eats the same meal whether you are slow or busy. This should be minimal and measurable. Chronic waste due to over-ordering is a bigger cause. Reduce your "safety factor" when ordering during slower periods. Sometimes the weekday counts are too low to absorb food left from the busy weekend. If the weekend is a complete bust, freeze everything you can and value any perishables which can't be saved.

You may have a major theft problem. If you're not finding many dollars in the research above, you may have discovered a persistent loss due to theft. If the 45% month had $10,000 in theft and you eliminated this problem, the result would be 40% in an otherwise terrible month. The bad month would have allowed you a chance to discover a $120,000 annual loss.

Saturday, May 22, 2010

Accounting Impact on Cost Control

There are significant differences between financial accounting and management accounting goals. Financial accounting depends on accurate and consistent inventory valuations. Both methods require perfect purchase cutoffs. I consider the cutoff of purchasing activity to be the highest priority.

I am amused at operators who go to great lengths in valuing inventory items (3 places to the right of the decimal point) and also allow deliveries during the inventory count. My early career inventory work involved an inventory count during an active delivery time of day. The food cost percentage was sky high. An entire shipment of meat was included in purchases and excluded in the inventory counts.

Since the operation had shifted into meal service, the recently received meat was being consumed in meal production. The solution used by management involved adding the meat purchases to the inventory counts on the sheets. OK So why bother with increased accuracy on the average purchase price of a case or pound when you are careless with the actual count you use in your valuation? This is more common than many people realize.

A liquor thief used to begin his counts early in his shift while the dinner meal was in progress. All he had left at the end of the meal was the partial bottles in the main bar area. His Excel sheets were a complete joke. He had a count of 30 bottles on an item. I asked where the cases were and he said he meant to put 3 bottles. Since the company paid no attention to specific bottles, an error like this would allow him to steal 2 full cases undetected by the "inventory control" report.

At some time, usually once a year at year end, the higher ranking accountants enter the inventory fray and beat up the team on average purchase costs and a selection of inventory counts. They recommend 2 people on every month end count and careful price look-ups for average purchase prices.

Most theft occurs in central storage and in the top consumption areas: kitchen and main bar. In operations where the menu items are placed in service area storage for self-service, late shift over production is a often undetected form of theft. Good managers should take a count one hour before closing and a second count 10 minutes before closing time. If your count went up, you have a possible theft problem.

If your operation takes a truly accurate inventory only once a year, you are possibly burning 3 to 5 percent of sales in theft and waste (conservative estimate).

Some people purchase software systems to track perpetual inventory. Accurate beginning inventory counts are required in any perpetual calculation. Purchases must be entered immediately upon receipt if you need shift based reports.

A powerful cost accounting report may be produced weekly. Accurate counts taken during periods when deliveries are prohibited and the kitchen is closed are the key. Valuing these accurate counts should be consistent. If you use the last price paid, look up this cost. Software solutions may automatically use the last cost. Some of the more sophisticated solutions use average cost or FIFO.

If you follow this straight forward approach, your annual financial inventory valuation will be a snap.

Friday, May 14, 2010

Accounting Question

Hi Joe,

I've been reading your FoodCostWhiz blog and have to say I really enjoy and find it very informative, particularly as the bulk of my experience is in QSR. I'm hoping you can settle a disagreement I am having.
A back of house software vendor that I have been dealing with for a long time has decided to rename their "Food Cost" calculations and reports as "Cost of Goods". They tell me that the two names are interchangeable, but I am not sure if I agree.
In my experience, Food Cost is based on working out the cost of a recipe, whereas Cost of Goods is simply the value of purchases. They go hand in hand, but are not the same. Am I off base here?

How would define the terms Food Cost and Cost of Goods?

Regards,

Brett


Thanks for the question Brett. Simply stated, Food Cost is part of Cost of Goods Sold. I consider the Cost of Goods Sold category as all items which go into the production of menu items and beverages. In a QSR operation, the Cost of Goods Sold would logically include paper used to wrap the menu items. All items on the table in a sit down restaurant would be included in Cost of Goods Sold.

To recap Cost of Goods Sold, I would include food, beverages, table supplies and packaging supplies for take out and delivery. I would exclude linen, cleaning supplies, and other supplies which do not vary directly with sales. The proper category for these items would be Direct Operating Expenses.

Food Cost is a part of Cost of Goods Sold but it is NOT the same as Cost of Goods Sold.

Friday, April 23, 2010

A Bigger Divisor Helps Your FC %

Don't overlook sales when reviewing your food cost results. There are several important reasons to scrutinize the divisor in the formula as much as the net purchases total. Your sales figure depends on covers, check average, promotions, coupons, discounts and lost revenue.

Lost revenue is related to menu items your service staff can serve a guest with no order entered in your POS system. Typical examples include slices of cake or pie, small pastries, coffee, tea, cocoa, soup, rolls and ice cream. Less common items include modifiers normally ordered through the POS system which have a small charge to the guest.

A second source of lost revenue involves unauthorized voids and price adjustments. I remember working with a family restaurant with a special price for ice cream sundaes for dinner patrons. Anyone visiting the restaurant for dinner was offered a sundae for 99 cents. After reviewing several POS data tables, I noticed late shift changes on many $3.99 items to $0.99. These patrons did not have dinner. They all paid cash. Their orders were changed from the full charge for the sundae to the dinner special price.

My annual estimate for this activity was $10,000. As you can imagine, these changes had to be made by a manager. The wait staff did not have the authority to amend closed checks. If the managers on shift were pocketing cash, you can be 100% confident the wait staff felt comfortable serving items not ordered through the POS system.

Chronic lost revenue won't show up in check averages. If this theft has been going on for years, the check averages will be consistent.

Wednesday, April 21, 2010

How Much Do We Need To Charge?

I received an email from a company with a large buyer of their tamales. The buyer pays $1.50 and they want to price the tamales to have a 30% cost of sales. Currently, they charge less than $3.00 for the tamales.

At $3.00, the cost of sales is 50%. If they could sell the $1.50 tamales for $5.00, they would hit their target. This is a 67% increase in selling price.

The tamale manufacturer could re-engineer the tamale at a $1.20 price point. If the seller raised the price to $3.60, they would be close to the target 30%. Do you think the customers would stand for 20% decrease in portion size and a 20% price increase?

The tamale manufacturer could offer a volume incentive. If the buyer hits a volume target, they could offer a discount. This discount could be paid monthly or quarterly. They could continue selling the tamales at $3.00. If the manufacturer produces the smaller portion for $1.20, they would have a 40% cost of sales.

Let's use a 20 cents incentive as an example. The buyer would achieve a 33% cost of sales if they hit the volume target ($1.20 minus $0.20).

Thursday, April 01, 2010

Understanding Menu Categories

How many of your dinner guests order a starter? Let's use 50% as a guess. Same question for dessert. We'll use 25% of guests for our dessert guess. Do all of your dinner guests order an entree? Maybe you see 90% due to substituting a starter for the entree course. Do you offer side dishes? How many guests pay extra for a side? We'll use 25% as a guess.

Our customer profile looks something like this table:
Starters 50%
Entrees 90%
Sides 25%
Desserts 25%

We would expect this profile to run a higher food cost than a restaurant with similar prices and menu choices with the following profile:
Starters 25%
Entrees 90%
Sides 25%
Desserts 50%

Restaurants with relatively higher dessert sales tend to run lower ideal food cost percentages. Think of the elaborate pastry displays when you visit a hotel for Sunday Brunch. They want you thinking about dessert before you take your first bite.


Click on the banner above for information about our next Menu Analysis Webinar.

If you specialize in huge portion sizes and high volume, you may not wish to push dessert sales. You'll run a higher food cost %, lower check average and the increase in covers will make up the difference.

If your customer base is in a rush, you can offer a full meal option with smaller portions of all 3 courses for an attractive price. This is common in entertainment areas near theaters and stadiums. You'll effectively change the profile as follows:
Starters 100%
Entrees 100%
Desserts 100%

You could manage the choices for the 3 courses and create a full meal profit which is higher than the current average per cover.

Impact of Beverages

Most of my clients love to see the cost of their entrees, appetizers and sides come to light as we build the database. After completing the entrees, it is common to hear the managers state: "So our food cost % is in line."

The ideal cost of the entrees tend to be equal or slightly higher than the actual food cost %. Actual food cost % should be higher than ideal food cost % since no operation is perfect. If your actual food cost is below your ideal cost, your recipes need work.

Before answering the benchmark question, I like to ask whether non-alcoholic beverages are included in food sales or beverage sales. If the coffee, tea and soft drinks are included in the calculation of food cost %, the ideal food cost % will be much lower. As an example, a steak house with an overall food cost of 38% actually had an ideal entree food cost of 41%. The wait staff did a terrific job selling a low cost dessert course with pastries and hot beverages.

The overall ideal food cost was 35%.

Entrees tend to have a much higher ideal food cost % since they bear the cost of complimentary items like rolls and butter and they use large portions of the expensive protein items. Non-alcoholic beverages typically produce a favorable impact on food cost % when they are included in the calculation.

The answer to the "in line" question in the example was NO. Their 38% actual was lower than the 41% ideal entree cost. They should have been closer to the overall 35% target. Any number above 36.4% would mean a 4% variance or higher.

Should you eliminate non-alcoholic beverage sales from the calculation of food cost % each period? This will require some extra time evaluating use of milk, cream, sweeteners, lemons, etc. I find it is worth the effort. There are 2 benefits. You'll find some lost revenue in the non-alcoholic beverages category due to unauthorized comps. Food cost variances in the critical entrees won't be hidden by the impact of non-alcoholic beverages.

Saturday, March 20, 2010

Accurate Food Costs Enable Menu Analysis

As many readers have noted over the years, we are working to put dollars in the bank. Frequent and consistent percentage analysis will help you identify consistency issues. Beyond percentage analysis, the ideal cost vs. actual cost report highlights specific ingredients ranked by dollars of variance. This analysis involves production and sales data, standard recipes and detailed purchase records.

If you are late to the theoretical cost movement, I urge you to start with the center of the plate ingredients. Get a handle on your high volume, perishable protein items first. Eventually, you will build a more comprehensive standard recipe file. When this day comes, I expect you will find most of the major variances will be center of the plate ingredients. My confidence comes from experience. Perishable, high volume protein items typically make up the major share of your controllable stock.

As you begin building your center of the plate recipe model, focus on entrees. Go ahead and carefully cost the portion for each protein item used in your entrees. If you have time, calculate the cost of your most popular accompaniments for these entrees. Include all complimentary items like rolls, butter, condiments, garnish, salads, etc. These complimentary items account for as much as $3 per dinner cover.


Click on the banner above for information about our next Menu Analysis Webinar.

Use the cost of the center of the plate ingredient along with your cost of complimentary items to find the gross margin for each entree. Simply subtract these costs from the selling price. This gross margin figure is the core of any useful menu analysis.

Menu analysis will take you beyond the food cost % report. You may currently use food cost % to trigger menu item price changes. Menu analysis techniques offer a different point of view. In the absence of menu price changes, purchasing results dominate your gross profit scorecard (as much as 80% of potential gross profit improvement vs. 20% due to tight portion control).

The portion cost data is much more useful when employed in menu analysis.

Wednesday, February 24, 2010

Menu Analysis: Quick Checklist

Do you keep your old menus? If you have a stack somewhere in your office, try to locate the menu from 2004. I would suggest you put your current menu side-by-side and perform the following checklist:

1. Count the number of choices in each major category for both menus. Fewer is better in this environment. If your current menu has more selections in the appetizer and entree zones, make a list of the items added in the last 5 years.

2. How do the prices compare between the two menus? Normal inflation over the 5 year period was low but food commodity markets had tremendous volatility during the oil price boom and bust. Perhaps you have cut menu prices to encourage more customers. Look for the highest and lowest priced entrees and put this information in perspective.

In 2004, proper pricing of the highest priced entree was very important. Diners were spending more 5 years ago. Today, the lowest priced entree is quite important. Many diners are searching for value. You may not be charging enough for your budget selections.

3. Try to remember your previous pricing strategy. Look back 5 years ago and think of your game plan. Were you raising menu prices 10% each year? Maybe 5%. A 10% annual increase will add up to 60% over 5 years. The 5% annual increases amount to 28% over the same 5 years.

If your current prices are looking similar to 5 years ago, your average increase for the 10 year period is about half of the number from the 2004 strategy. Should you bring your costs in line with this new reality? In the short run, most companies have been forced to make drastic cuts. Take a long term view and decide what the future holds for the next 5 years.

In summary, this is a great time to review your most recent 5 years. Sometimes people look at the future through an optimistic lens. Other times (like now), the pessimistic lens is used. By looking at the complete picture, you will see things as a realist.

Thursday, February 18, 2010

Is Your Ideal Food Cost Number Real?

A veteran restaurateur asked me to check out his numbers to see if I could see a problem. Initially, he assumed the program he purchased was defective. As I started asking questions, my focus turned to yield data from his butchering department.

In addition to a very ambitious menu, this restaurant offers a top cuts of beef in a small retail shop. Along with T-Shirts and ball caps, customers can take home a filet mignon or porterhouse steak. The butchering department produces cuts of meat for both the restaurant and the retail shop.

The retail shop has a consistent cost of goods sold percentage.

After tracing the food cost percentage backwards, it became clear the restaurant suffered from butchering yield volatility. The accounting method utilized by the owner treats the butchering operation as part of the restaurant. Steaks are "sold" to the retail shop at cost. This cost is determined using a formula which has a standard yield and only varies with market price fluctuations.

The main issue is the normal volatility in yield (i.e. edible pounds as a function of as purchased pounds) is borne by the restaurant. The owner is using ideal cost data which assumes the yield is constant. One of the most popular large cuts has a "typical" yield of 61%. The actual results vary between 57% and 64%. The 61% standard occurs about 18% of the time. The rest of the time (82%), the butchering operation has a variance from the standard.


Click on the banner above for information about our next Menu Analysis Webinar.

When the yield is on the high side, the restaurant has a good week. The rest of the time, the restaurateur is scratching his head. The number one point to take from this story: he keeps tremendous records. I would never be able to explain this situation with clarity without his butchering archive. He keeps a three ring binder with a butcher yield sheet for each batch.

After I helped him tie the butchering yield data to his ideal usage model, the variance due to butcher yield declined and the problem was solved. Should we be happy with the virtual elimination of the variance? Probably not.

The previous uncertainty produced plenty of heated discussions between the production team members. These interactions produced a decent number of innovations over time. Now the calm waters have caused a level of indifference which never existed before the model was tweaked.

I personally enjoy variances. Many operators hate any variance from the ideal. They build recipe models which are designed to hide normal variances. When deciding on a yield, these people imagine the worst case scenario (57% in the operation above). By the time a variance is recognized using these reports, there is a huge problem.

The range between 57% and 64% is 7%. When expressed as a function of the low yield figure, this range is nearly one eighth. If the butcher was crooked, he could grab a box of meat for every eight when the yields are good. His theft would go completely undetected. The same restaurant may never get on the phone with the meat supplier and complain about the substandard yields. Inconsistent portion sizes would stay hidden as well.

So what is the best way to approach this situation? The restaurant needs to treat the butchering operation as a separate entity. In this entity, yield variances need to be front page news. Daily variance should be dealt with decisively and quickly. This butcher should "sell" portions to both the restaurant and the retail shop. These portions should be closely monitored using a POS system.

Friday, February 12, 2010

Menu Price Trends

Histograms profile the number of data points for each class using a standard bar chart format. In constructing a menu map, I like to see the action in terms of popularity and dollars of sales produced. For this analysis, the data points per bin is the starting point. Knowing the number of menu items offered at each price point helps you later in the analysis.

The chart below shows the additional information in columns. Almost 3/4 of sales are produced by menu items priced between $23 and $40.



Should this restaurant eliminate the high priced items which are seldom ordered?

Menu psychology suggests the very high priced items help make the popular item's prices look attractive. Given the current economy, this philosophy may not work as well as in 2008 (source year for the test data). In fact, the operator is currently pushing pasta entrees during mid-week dinner periods.

I'd like to get my hands on the data from last year and make a comparison. In a side by side comparison, I'd expect a shift to lower priced menu items.

Here in the Mid-Atlantic, crab cake dinners are very popular. Although jumbo lump crab meat is pricey, diners expect to pay below $30 for two cakes with a salad and sides. The cakes with minimal filler are recommended in the local press and by word of mouth. This means a competitive dinner house serving Maryland jumbo lump meat needs to use about $10 of crab for the entree.

Last week, I had a conversation with a neighbor who loves to dine out. He and his wife ordered crab cakes at one of the most well known restaurants in the area. The two cake dinners sold for $28.95.

He said the cakes were loaded with bread crumbs. He was quite disappointed due to the treatment he received when he told the manager. He was offered an apology and a free appetizer card. This free card was good for a future meal. They lost a loyal patron and fan.

Tuesday, February 09, 2010

Three Classic Menu Engineering Approaches

There are 3 classic menu engineering models taught in hotel/restaurant management courses. These models produce much different results when applied to a restaurant with a large number of entree choices.

Many people are familiar with the Star, Plowhorses, Puzzles, and Dogs approach which was developed by Kasavana and Smith. This model uses popularity as a function of gross contribution to split entrees into 4 quadrants. The popularity cutoff is 70% of the average number sold. If you sold 1,000 entrees and had 10 choices, any entree with over 70 sold is either a Star or a Plowhorse. The contribution test uses the mean. If the average contribution per plate is $12, items with higher profit would be labeled as a Star or a Puzzle (depending on popularity).

The second popular method was developed by Miller. He uses a similar popularity test but focuses on food cost % instead of gross margin. His Winners are popular menu items with a low food cost %.

Finally, Pavesic's menu engineering approach uses weighted statistics and looks at profitability as a function of food cost %. There is no 70% applied to his figures since the numbers are weighted by their overall impact on results.

I used the 3 methods to evaluate the menu at a seafood and steak dinner house with 41 entree choices. Comparing the ratings to my initial recommendations to the owner, I find myself most in sync with the Pavesic method. I tend to focus on profitability improvement through tighter food cost control. Someone employing the Pavesic method with reliable recipe cost data would come to many of the same conclusions I reached without running the statistics.



Miller rated a block of popular menu items as Winners when the Kasavana/Smith approach rating was Plowhorse and the Pavesic rating was Standard. Although I like the Miller approach for the current recession, entrees with lower gross margins may not rate a Winner class unless they achieve a low food cost % figure.

[My test data came from work I did in 2008 and the recession was mostly an autumn event in this seashore restaurant. The summer figures were in line with previous boom years and this season dominates the annual sales volume results.]

If I were advising the same operator today, the Miller approach would factor heavily in my recommendations. Since there is a ceiling on menu item prices imposed by the thrifty diners of 2010, restaurants need to rely more heavily on tight food cost control to achieve profits. I would expect to see fewer sales of high ticket menu items with high gross margins and high food cost % figures since the high selling prices which would support this profile have declined in popularity. Fewer diners are trying to impress with their choices. More diners are looking for a lower check at the end of the meal.

Tuesday, January 26, 2010

Get the Facts Straight Before Taking Action

I'm not exactly sure when this recession will hit bottom. Most likely, the bottom will not be remarkably different (economically speaking) than today. The rate of job losses has dropped dramatically from the peak but we are still shedding jobs. Many employers have frozen wages and some have asked employees to take more days off without pay.

All of this belt tightening has made the American consumer afraid to spend money. This is not a completely negative fact of life. When Americans do not spend as much money on non-essential goods and services, the loss of demand drives prices down in the short run. If you were waiting to purchase replacement equipment, furniture, china, glassware, silverware, and kitchen utensils, you should consider making a small investment in the future now.

If you never started a customer loyalty program in the past, you are probably looking at your base clientele in your dining room this month. Patrons who have shunned the bad economy, their New Year's resolutions, volatile weather patterns and the new frugal approach to life here in the states are your fans. Get out in the dining room and say: "Hi! Thanks for joining us tonight. Would you like to join our new frequent dining club?"

January in a recession will often produce a low sales number. If you take the sales figure at the end of January and multiply by 12, you will have an excellent figure for forecasts, budgets and business plans. Could you break even if every month this year looked like this January? If you answer yes, you will make money this year and beyond. If you answer no, you have work to do.

Pretend it is never going to get better than this month. What would you do differently?

By forcing your company to confront the possibility of 2010 staying at the current levels, you will drive your team to innovate. These innovations will provide the path to the future and will create positive cash flow now.

If you are swimming in excess cash, should you open a new location? Like any recession, the market will over correct on the downside. Better days are in the future. If you wanted to open a new location in 2006 and decided to wait, today may be your lucky day. Construction costs have dropped, existing restaurant space is everywhere and experienced professionals are looking for employment.

Another Restaurant Chain Goes Chapter 11 Route

Fast Casual Magazine just issued an article Taco Del Mar files for Chapter 11 highlighting the continued woes of chain operators. In the recent 10 days, Daphne's, Pizzeria Uno and now Taco Del Mar have decided to seek protection under Chapter 11 bankruptcy rules.

Sunday, January 24, 2010

Alternative Food Cost Benchmarks

Certainly, most restaurants use food cost as a % of sales as a key performance indicator. This week, an anonymous reader asked about tracking food cost in a different environment - a health care facility. He asked if it was advisable to use cost per patient per day in lieu of a percentage. I strongly recommend using the cost per patient day over a percentage benchmark.

In the remote site feeding segment, we tracked all costs per person per day. The advantages to management are greater in labor cost analysis using this method. Food cost generally is variable while labor has both a fixed and a variable component. With long term sales prospects dampened by the recession, tight control has helped many companies survive and prosper.

Is it possible to effectively use per cover cost analysis in a restaurant environment? Many chefs prefer to track menu item performance using gross margin per plate. Since the aim is to make more dollars vs. a higher percentage, they need to take care when analyzing other costs. Direct labor, direct operating expenses and overhead costs should follow suit. If the operation sells higher priced items with relatively high food cost %, the use of cost per cover for non-food expenses is necessary.

Operators should not mix the percentage method with the cost per cover approach.

Consistent use of the per cover method would require a reasonable profit per cover. Use a forecast of covers for the entire year to spread all fixed overhead and profit. In tight economic conditions, it pays to track fixed cost coverage and profit by cover. In addition to cost control, you need to review menu item pricing policy. The popular factor method may not provide you with the edge needed to survive a price war.

The entrees are the best menu items to use for cost coverage. Your entree cost should cover the recipe cost of the item, per cover amounts for direct labor and operating expenses, fixed overhead and profit. If a competitor price war forced you to adjust prices, you would have a clear number for pricing decisions. You could calculate precisely the impact of a penny, dime or dollar move in entree prices.

Monday, January 11, 2010

Morningstar Article on Casual Restaurants

In their January 8th article The Casual Restaurant Bankruptcy Epidemic, Morningstar analyst R.J. Hottovy takes a look at the shaky casual dining segment. The article focuses on the primary risk factors and the tight credit markets. Examples of fallen chains and potential failures highlight the need to remain vigilant with cost control.

This is a sober financial analysis of this industry segment. Like any other Wall Street analysis, the analyst provides his insight into the direction of restaurant stocks publicly traded on major markets. I drilled into the data on Darden (DRI) and found the stock price has increased less than 20% in the most recent 5 year period. This is better than a loss but the 3.7% average annual appreciation probably won't go too far in attracting major investors. Mr. Hottovy expects Darden to weather the storm. He is more negative regarding the chances of Dine Equity (parent company of IHOP and Applebees). Although he would like to see Dine Equity refinance some of their debt, Morningstar rates DIN as a 3 star stock (about average return expectation for the risk level).

Wednesday, January 06, 2010

Great Advice For Any Economy

Chef Jason Sandeman is a blogger working in Montreal (my favorite city). In a recent blog post he summarizes the 7 laws of Italian Cooking which if followed will help you eat well for less.

Sunday, January 03, 2010

Outlook for 2010

Many people are pleased to see 2009 come to an end. Wall Street posted a solid 20% gain and oil prices were well below $100 per barrel. The bad news involved jobs. Month after month, companies shed employees in droves. We can expect the Federal Reserve to leave rates low until the job market turns the corner.

Increases in government spending at the federal level will be partially offset by cuts in local and state government budgets. Somewhere in the later half of 2010, I expect the job market to reverse course as employers slowly start adding people to their payrolls.

Stocks should continue the up and down motion as the Dow Jones seeks higher ground. Any increase in consumer confidence will translate into profit since companies have reigned in their fixed costs. Will restaurants start filling their dining rooms mid-week?

Look to travel indicators for signs of increased mid-week business. When airlines and hotels begin to see increased volumes, restaurants will find business travelers in their seats. Don't expect many $100 bottles of wine on business expense accounts this year. Frugal is in vogue.

I expect oil to remain below $100 per barrel.

Overall, 2010 will be better than 2009 as the long slow recovery takes root.

Restaurant Data Pros

 
web counter