Inventory Forecasting: You Can't Manage If You Don't Measure

Last week I kicked off a series of articles on controlling food costs.

I had the opportunity to work for one of the most respected CEO's in the restaurant industry who mastered the art of controlling costs. He was always saying, "You can't manage what you don't measure". It is an old management adage that is accurate today. Unless you measure something, you don't know if it is getting better or worse. You can't manage for improvement if you don't measure to see what is getting better and what isn't.

With inventory, you need to manage the uncertainties, the constraints, and complexities on a continuous basis. By doing this you will improve your inventory forecasting ability and accurately set inventory targets and pars.

The first thing to measure is your usage. Keep it simple and just look at a week and see how much you started with, add what was delivered, and then subtract what you have left. That's how much you use in a week. (Next week we'll talk about ways to dig a little deeper into what you should be using vs. what you are using.)

Now that we know how much we use, we can start to look at how much we need. One of the problems is the repetitive orders of the same products; you have undoubtedly asked yourself at what stock level you need to replenish your inventory. The goal is to reduce inventory levels without affecting you guests. The three main factors to consider when forecasting:

* The Lead Time - how long does it take for my delivery to come once it's ordered?
* Reorder Point - what's the level of inventory for each item, when I know I should order more?
* The Reorder Amount - how much should I get?

If you don't have a background in forecasting don't worry you can still learn to forecast. Keep track of the important factors, such as special events or the weather, holidays, advertising specials, etc. You need to track these by the day of week. Any special events in your surrounding area could impact business and should be noted.

The next step involves analyzing the variances. Highlight very low variances and very high variances. You want to improve the overall performance. Identify weaknesses and make adjustments in future forecasts. Try to imitate accurate forecasts. Find out what you did right on low variance predictions.

The key to building strong forecasts is a creating and keeping strong records, reviewing these records, which will enable you to improve your forecast. I never said this is going to be easy but don't stop, keep the process going and you will reap the rewards.

There are many tools available to help you forecast inventory, they can be as simple as an Excel spreadsheet or more sophisticated software solutions that master the art of inventory forecasting and ordering. You need to ask yourself which solution works best for you. But remember, the better tool will enable you to ensure you have enough product on hand at all times while reducing your inventory costs.

--from WhenToManage's Restaurant Biz Blog

Views: 5

Tags: cost, food, inventory, tips


You need to be a member of FohBoh to add comments!

Join FohBoh

Comment by Robert Sloop on February 18, 2011 at 3:23pm


All tools are not created equal.

Why is the restaurant industry subjected to multiple best of breed, custom integrations when the talent pool to maintain them is scarce.

Where is the Full enterprise solution? (to date there is none)

Why be forced into multiple data base configurations, (GM likes Micros, Chef likes Cheftec,bookkeeper likes Quickbooks) that require custom hookups and reconciliations.

All have their strengths and weaknesses!

Compeat is the only low cost 3rd generation solution available (POS+Compeat) that has ease of use and provide an end to end solution with little customization



Comment by Jim McGinty on February 18, 2011 at 2:46pm
There are several tools available on the market place to help, WhenToManage, Compeat, ChefTec, Restaurant Magic, CTuit to name a few. All have their strengths you should take a look at 2 or 3 of these to see which one best meets your needs.

Comment by Robert Sloop on February 18, 2011 at 11:56am

Spot on Jim

It's not the tool, it's how you use it

In my history as CFO of four multi-concept groups Compeat was my tool of choice.

It was the only fully integrated system that gave me everything I needed in one package

Comment by Miguel A Barrera Rodriguez on February 16, 2011 at 7:17pm

I completely agree with what you wrote, I am having trouble selecting a time series method for forecasting the demand for every menu item, which would you suggest??, for casual dining




Social Wine Club for Craft Wineries


Eateries turn to rationing as lime prices soar

Unrest caused by Mexico's drug cartels, along with floods in Mexico and a drought in California, are taking a toll on this ye -More

25% Usage Reduction, Guaranteed!
Reduce waste and cut cost. Impress your customers and express your brand. Every single Tork Xpressnap napkin dispenser performs double-duty for your business. Find out more about our 25% usage reduction guarantee or get a free trial.

Burger King to upgrade wireless with Whopper Wi-Fi

Burger King has teamed with AT&T to replace existing in-store wireless Internet with an upgraded system dubbed Whopper Wi-Fi  -More

Late-night indulgence pays off for Jack in the Box

Jack in the Box saw its profits rise sharply in the first quarter, a few months after introducing its $6 Munchie Meal menu of -More


Posting a job or finding a job starts here at FohBoh. Call us about special $25 posting packages to syndicate across all major jobs boards.

National News

Wahlburgers Announces Expansion Plans Including Franchise Agreement in Philadelphia

Wahlburgers has signed a franchise agreement with Hingham Associates, LLC that will bring five Wahlburgers to the metropolitan Philadelphia area over the next several years. The franchise group is actively looking at sites and is targeting a late 2014-early 2015 opening for its first restaurant.

Chipotle Mexican Grill, Inc. First Quarter 2014 Revenue Up 24.4%

Comparable restaurant sales increased 13.4% - Restaurant level operating margin was 25.9%, a decrease of 40 basis points

Jamba Juice Announces Grand Opening of New St. Louis, MO Location

Jamba Juice Company announced the brand’s continued expansion in the St. Louis market with the opening of a Jamba Juice® store at 11477 Olive Blvd. on April 16, 2014.

Expert in Real Estate Analytics Joins Luna Grill

Luna Grill, the San Diego-based Mediterranean restaurant chain, is welcoming retail real estate industry veteran Greg Thorburn to its leadership team. Thorburn has been brought on board to fill the newly created position of Vice-President of Real Estate.

Rita's Italian Ice Awards Area Development Agreement for Kansas

Rita's Italian Ice has awarded franchise and area development agreements for Kansas and the Kansas City area, which extends to the Missouri side of the city, to franchisees and local residents Jay Miller, Jeff Miller and Pat Reilly.


If you are looking for capital to start or grow your restaurant, create the next 501c3, develop and launch the next app for the restaurant industry,or want to help your peers in some meaningful way, we want to know about it.


TED: Jeremy Kasdin: The flower-shaped starshade that might help us detect Earth-like planets - Jeremy Kasdin (2014)

Astronomers believe that every star in the galaxy has a planet, one fifth of which might harbor life. Only we haven't seen any of them -- yet. Jeremy Kasdin and his team are looking to change that with the design and engineering of an extraordinary piece of equipment: a flower petal-shaped "starshade" that allows a telescope to photograph planets from 50,000 kilometers away. It is, he says, the "coolest possible science."

TED: Norman Spack: How I help transgender teens become who they want to be - Norman Spack (2013)

Puberty is an awkward time for just about everybody, but for transgender teens it can be a nightmare, as they grow overnight into bodies they aren't comfortable with. In a heartfelt talk, endocrinologist Norman Spack tells a personal story of how he became one of the few doctors in the US to treat minors with hormone replacement therapy. By staving off the effects of puberty, Spack gives trans teens the time they need. (Filmed at TEDxBeaconStreet.)

TED: Jennifer Senior: For parents, happiness is a very high bar - Jennifer Senior (2014)

The parenting section of the bookstore is overwhelming—it's "a giant, candy-colored monument to our collective panic," as writer Jennifer Senior puts it. Why is parenthood filled with so much anxiety? Because the goal of modern, middle-class parents—to raise happy children—is so elusive. In this honest talk, she offers some kinder and more achievable aims.

TED: David Brooks: Should you live for your résumé ... or your eulogy? - David Brooks (2014)

Within each of us are two selves, suggests David Brooks in this meditative short talk: the self who craves success, who builds a résumé, and the self who seeks connection, community, love -- the values that make for a great eulogy. (Joseph Soloveitchik has called these selves "Adam I" and "Adam II.") Brooks asks: Can we balance these two selves?

© 2014   Created by FohBoh.

Badges  |  Report an Issue  |  Terms of Service