What are Yellow Dog's Best Practices for Physical Inventories for F&B Customers?

What are Yellow Dog's Best Practices for Physical Inventories for F&B Customers?

 

                                          

Best Practices

 

F&B Physical Inventory Best Practices

                                                                                                                                                                   

 

 The following are our teams’ best practices for taking a F&B physical inventory gathered over hundreds of implementations.  Following these guidelines will ensure your team has the most successful time completing your inventory.

 

Foundational Decisions and Approach

Before you start your first physical inventory, your business needs to decide how to best handle the following:

 

     Establish a culture of seriousness around physicals.  Even the smallest of establishments can have thousands of dollars in inventory.

     Counting is ideally done in pairs - one person counting, one person writing/entering counts

     Frequency – how often will you take inventory (weekly, monthly, quarterly) - weekly is recommended

     Day of the week you will take inventory - pick the least stressful day, change as needed - consider deliveries, sales, etc.

     Time of Day – It is recommended that you start after close of business or before open.

     Time Deadline – Done between end of day and the start of the next business day

     Establish your standard approach to Physical Inventory

    Kick Off Meeting

    Locations and Assignment

    Shelf tags, product UPCs or count sheets via Apps or paper?

    Problem Items – How to handle/notate, where do you take those items, who resolves?

     Determine your Variance Thresholds

    Depends on your ownership/accounting team

    What is your budget of acceptable variance - 3%, 2%?

    Does the time spent investigating a variance provide return?

     To UPC or Not UPC – Will you add UPC codes to items and allow them to be scanned?

     Handhelds or Apps – Get them.  1 Per Person.  They will justify their cost in 1 to 4 months

     Auditing high value items between physical inventories

     Reporting - What are the reports that need be generated after each physical

 

Physical Inventory Checklist:

·         We have included a Physical Inventory Checklist that we recommend be included in your process. Completing this checklist with every inventory, will guarantee your team has an efficient and productive inventory.

 

 

 

Physical Inventory Checklist

 

 

                                                                                                      Outlet(s)             _____________________________        Last Months Ending:                              __________

 

                                                                                                    Staff Member:     ____________________________         This Month Actual Revenue                    __________

 

                                                                                                                    This Month’s COGS Budget Amount/%    _______/___

                                                                                                   Physical EOM      _________________________            This Month’s Actual COGS Amount/%     ______/____

                                                                       

 

     Pre-Physical Checklist

  1.              Set time to start physically counting outside of business hours

            o    Date: ________ Time: ________

  1.             Confirmed all invoices/receipts entered in Yellow Dog (Committed)
  1.            Confirmed AP has also entered all of these in AP (3-Way match of Vendor Invoice stapled to YD Invoice stapled to AP Invoice)
  1.            All waste entered at least one day BEFORE your do physical
  1.            Handheld prep

      o    Ensure units, and any backup batteries are fully charged

      o    If 520s, or Docked version is being used confirm pre count sync happened

  1.              Paper Count Sheets printed and checked, all new items are included and in correct order. 

      o    Reporting Explained: All Items Not on any Count Sheet

  1.              Printed negative on-hand report day BEFORE physical.  Resolve negatives before taking physical.
  1.              Straighten up/tidy up inventory areas. Move product to where it should be.

 

Physical Checklist

  1.           Setup problem item table (or process to deal with items that won’t scan)
  1.           Printed Count Sheets, assigned to staff
  1.           Assigned Data Collectors

 

Review of Physical (Before Committing)

  1.           Print POS Sales Report for month to help audit
  1.          Have last month’s ending inventory and this month’s budget COGS amounts to validate actual COGS for this month before committing.
  2.         All counts added to Physical
  1.         Sort by “Variance Cost (Descending), Item”, review and recount as needed
  1.         Review and recount as needed all “zero counted” items
  2.         Sort by “Variance Quantity, Item.  Review and fix any positives
  1.       Once you’re within your threshold for COGS Variance, commit physical.

 

Post Physical Checklist

  1.         Print Detailed by Select Physical Report
  1.        Print COGS By Department Report
  1.       Hand in this sheet (per outlet and the above 2 reports) to your supervisor

    • Related Articles

    • Food & Beverage Resource Guide

      This document will provide resources for all primary functions in Yellow Dog System Navigation – The links below will provide detail on launching, logging in, and navigating around the system. Navigation Overview Launching & Logging in Left Hand ...
    • What are Yellow Dogs Best Practices for Physicals for Retail Customers?

                            Retail Physical Inventory Best Practices                       The following are our teams’ best practices for taking a Retail physical inventory gathered over hundreds of implementations.  Following these guidelines will ensure ...
    • F&B Physical Inventory Webinar Recording

      New to Physicals in Yellow Dog? Need a refresher before your next count? Then this free one-hour Webinar is for you! We will review:   Best practices for making sure your team is prepared ahead of time How to utilize the YDMobile application for ...
    • What are the best practices Operations Manuals for F&B?

      The Yellow Dog Inventory  F&B Operations Manuals contain checklists that provide the end-user with basic task information on what you need to accomplish over the course of a month to set yourself up for success with Yellow Dog Inventory. If you need ...
    • Reporting Explained: F&B :Food Cost: Actual By Item

      Business Need:  This report is helpful for users who want a report to show the cost of goods for items sold between two dates. How it Works:  A F&B>Food Cost>Actual By Item report shows the actual usage cost for items sold between two dates based on ...
    • Recent Articles

    • Send Saved Report Emailing

      You can configure saved reports to be automatically emailed to you and/or team members on a set schedule. How do I schedule daily email reporting? You can configure saved reports to be automatically emailed to you and/or team members on a set ...
    • Purchasing Flow for Food and Beverage

      The Yellow Dog Inventory purchasing flow ensures that all aspects of inventory management, from restocking to adjusting errors in transfers, are covered systematically. Each document type in the flow serves specific functions that collectively ...
    • Updating Count XL Application

      You may need to update your Count XL application on your handheld device to ensure it runs properly and smoothly. If you have received the following errors, your Count XL application may need to be updated: • “Invalid network error” • “API error” • ...
    • Removing Items with On-Hand Quantity (Decimal)

      You might encounter difficulty removing specific inventory items due to an error indicating that the item cannot be removed since its on-hand quantity is not zero, possibly because the decimal point is not properly adjusted. Changing the Decimal ...
    • ZD411 Printer Troubleshooting

      Labels Skipping When Printing When you are not able to print labels or labels are skipped when printing you will need to adjust the sensor inside the printer. If your labels are skipping when printing, make sure you have adjusted your sensor. To do ...