5 Key Indicators That Spreadsheets Aren't Cutting it For COGS Tracking in Your Restaurant

Share Article

Spreadsheets can be utilized in areas ranging from purchasing to inventory to recipe costing. Ctuit's Jeremiah Anzelc provides 5 tips that indicate when it may be time to move on.

Are spreadsheets enough for COGS tracking?

Are spreadsheets enough for COGS tracking?

Be sure to find something that fits the needs of the company to provide the best Return on Investment.

Restaurants use spreadsheets for at least some function of cost of goods control. Spreadsheets can be utilized in areas ranging from purchasing to inventory to recipe costing. At some point, it becomes time for a more advanced solution.

Here are 5 indicators that it might be time to move on.

1. AMOUNT OF TIME SPENT. Any manual process takes time to complete. Even a simple concept can take a few hours to calculate cost of goods on inventory day. If the time spent utilizing the spreadsheets can be better spent elsewhere, an advanced solution can free up some time.

2. CONSISTENT/ACCURATE DATA. With different departments or different locations utilizing spreadsheets, each may have their own process or interpretation of what is required. When one location counts wine by quantity of cases, but another counts wine by quantity of bottles, it can lead to inconsistent data and cost of goods issues. Advanced solutions can be configured with standards that all are required to follow.

3. INITIAL CONFIGURATION. Spreadsheets are great because they can be configured to suit a restaurant’s needs. To get there, it requires time and effort to create templates and formulas that will calculate cost of goods correctly. Advanced solutions have these templates and formulas already in place, and many times offer custom solutions to even further suit the needs of a restaurant.

4. UNCONTROLLABLE COST OF GOODS SOLD. Sure, high cost of goods are an indicator that something may need to be addressed; however, what do you do with a high food cost percentage? If all options are exhausted and but costs still aren’t down to a manageable level, an advanced solution can give a better vantage into levels of data that spreadsheets just can’t provide.

5. DYNAMIC MENU. A static menu allows for minimal manipulation to spreadsheets. While there will be some new items here and there, it’s essentially set it and forget it. With a changing menu, spreadsheets require more frequent manual updating to get into alignment with those menu changes. An advanced solution can offer less time consuming ways to make those changes.

Moving to an advanced solution is not a decision to be taken lightly. Considering the above 5 indicators, along with what that transition means to a business, will help to determine if it’s time for something new. While something with all the bells and whistles sounds good, be sure to find something that fits the needs of the company to provide the best Return on Investment.

Share article on social media or email:

View article via:

Pdf Print

Contact Author

Megan McIntyre
Ctuit Software
+1 (415) 884-4888 Ext: 108
Email >

Megan McIntyre
@CtuitSoftware
Follow >
Ctuit Software
Like >
Ctuit Software

Follow us on
Visit website