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


Taco Bell takes on fast casual with U.S. Taco Co.

Taco Bell will test a new fast-casual concept called U.S. Taco Co.  -More

Avocados From Mexico: All New Recipe Brochure
Looking for the sweet spot between indulgence and fresh appeal? Say yes to fresh Avocados from Mexico, all year long. So rich and creamy, use them as a substitute for mayo to create a craveable crab salad sandwich that will make others green with envy. Discover more culinary inspirations and recipes here!

Ronald McDonald gets a makeover for social media debut

Ronald McDonald is giving off less of a clown vibe with a makeover that keeps the color scheme but adds a blazer, a yellow ve -More

Animal fats ramp up flavor

Chicago hot spots are serving up savory dishes flavored with animal fats such as Stephanie Izard's confit goat belly at Girl  -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

Dunkin' Brands Reports First Quarter 2014 Results

Dunkin' Donuts U.S. comparable store sales growth of 1.2% - Added 96 net new restaurants worldwide including 69 net new Dunkin' Donuts in the U.S. - Revenue increased 6.2%

Hurricane Grill & Wings Signs Franchise And Multi-Unit Development Agreements For Additional 22 Units

Hurricane Grill & Wings, a restaurant franchise known for its never-frozen jumbo wings and more than 35 signature flavors, announced today the signing of five multi-unit development agreements, representing 22 new locations. The Florida-based brand opened two locations in early 2014, with plans for a total of 14 new units by the end of the year.

Dunkin' Donuts Announces Plans For 20 New Restaurants In South Orange County And The San Fernando Valley

Dunkin' Donuts announced today the signing of multi-unit store development agreements with two new franchise groups to develop 20 new restaurants in South Orange County and the San Fernando Valley area over the next several years.

Brinker International Reports Increases In Third Quarter Fiscal 2014 EPS And Comparable Restaurant Sales

Earnings per diluted share, excluding special items, increased 16.7 percent to $0.84 compared to $0.72 for the third quarter of fiscal 2013

Togo's Inks Deals In Idaho And Utah To Develop 13 New Restaurants

Togo's Eateries, Inc. announced it has signed franchise agreements to develop five restaurants in Eastern Idaho and eight locations in Salt Lake City, Utah. In 2014, the brand will also mark its entry into Colorado, Idaho, and Utah with restaurant openings planned over the next few months.


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: James Patten: The best computer interface? Maybe ... your hands - James Patten (2013)

"The computer is an incredibly powerful means of creative expression," says designer and TED Fellow James Patten. But right now, we interact with computers, mainly, by typing and tapping. In this nifty talk and demo, Patten imagines a more visceral, physical way to bring your thoughts and ideas to life in the digital world, taking the computer interface off the screen and putting it into your hands.

TED: Hamish Jolly: A shark-deterrent wetsuit (and it's not what you think) - Hamish Jolly (2013)

Hamish Jolly, an ocean swimmer in Australia, wanted a wetsuit that would deter a curious shark from mistaking him for a potential source of nourishment. (Which, statistically, is rare, but certainly a fate worth avoiding.) Working with a team of scientists, he and his friends came up with a fresh approach — not a shark cage, not a suit of chain-mail, but a sleek suit that taps our growing understanding of shark vision.

TED: Michel Laberge: How synchronized hammer strikes could generate nuclear fusion - Michel Laberge (2014)

Our energy future depends on nuclear fusion, says Michel Laberge. The plasma physicist runs a small company with a big idea for a new type of nuclear reactor that could produce clean, cheap energy. His secret recipe? High speeds, scorching temperatures and crushing pressure. In this hopeful talk, he explains how nuclear fusion might be just around the corner.

TED: Sarah Lewis: Embrace the near win - Sarah Lewis (2014)

At her first museum job, art historian Sarah Lewis noticed something important about an artist she was studying: Not every artwork was a total masterpiece. She asks us to consider the role of the almost-failure, the near win, in our own lives. In our pursuit of success and mastery, is it actually our near wins that push us forward?

© 2014   Created by FohBoh.

Badges  |  Report an Issue  |  Terms of Service