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.
Thursday, May 27, 2010
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.
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, 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.
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).
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
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.
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.
Subscribe to:
Posts (Atom)
Restaurant Data Pros
