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.