1 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Review and Post Inventory Quick Start Guide Document Details Document #: 161_QS1000_230406 Release Version: 10.00.00.00 Version Release Date: July 2022 Overview Once inventory counts are entered, users will review a summary of all transactions from the period and compare the expected on hand value of their inventory to what was just counted. Reviewing inventory lowers food costs by identifying opportunities for operational improvement. Once inventory is reviewed, it can then be finalized by “posting” the period. System Requirements • CES Version 10.00.00 or higher Be sure to grab the latest version of this document here: https://links.crunchtime.com/NCQS-ReviewAndPostInventory OR by scanning the QR code to the left. Watch the tutorials on MainCourse: https://links.crunchtime.com/NCI105nsnb Related User Group Permissions % Screen Name Control Name Description 96 NC-Inventory Physical Inventory Controls whether the “Create/Review Inventories” option is available on the menu and the “Count Sheet” link is available for an Inventory event. [178][376] 97 NC-Inventory Review Controls whether the “Review” link is available for an Inventory event and whether the “Save and Review” button is available from the Data Entry screen. [178][379] 77 NC-Other Store Tasks Post Current Period Inventory Enables the “Post Inventory” option on the Administration menu. [135][252] 41 NC-Inventory Override Variance Alerts Controls whether the “Review” user can Save & Close with variances that exceed parameters defined by Inventory preferences. [178][554] 5 Overdue Post Transactions Override Restricted Post Enables the Continue button in the Overdue Post Transactions pop-up, which will allow the user to override the restriction and post the period. [278][632]
2 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Review Inventory Why Review Counts? Reviewing inventory counts and related inventory transactions for accuracy is the first step to lowering food costs and identifying operational issues. This gives you the opportunity to: 1. Correct any issues such as miscounts, incorrectly received orders, and other factors that could result in inaccurate inventory reporting. 2. Identify operational issues that negatively impact your business, such as incorrect portioning or theft. Key Concepts • Book – The amount of product that should be on hand, based on sales, vendor orders, adjustments, and other transactions recorded by the application. • Physical – The amount of product on hand during an inventory count. • Variance – The difference between the expected (Book) and actual (Physical) quantities or values. Explained Variances Unexplained Variances An explained variance is one that can be traced back to a cause in the system. For example: • Incorrect Inventory Counts • Missing Adjustments • Inaccurate Daily Prep • Setup Issues You can typically correct these variances by adding or updating transactions in Net -Chef. Correcting these variances will lower costs and improve reporting. An unexplained variance is one that cannot be traced back to a cause in the system. For example: • Over-Portioning • Under-Portioning • Incorrect Sales Transactions • Waste • Theft These variances cannot be corrected by editing transactions in Net-Chef. Identifying these variances will allow you to identify opportunities to improve your operation. You’ll always have some variances. The goal when reviewing variances is to correct explained variances and prevent future unexplained variances. You do NOT need to make all variances zero. Remember: You should NEVER enter incorrect inventory counts! (Continued)
3 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Review Inventory (Continued) Screen Overview • The Product Number and Product Name indicate which product you are reviewing. The Inventory Unit indicates how this product is measured. • The Unit Price for each product is displayed. Selecting this hyperlink opens a pop-up showing the cost changes for this product for the current period. • The Quantity columns show the activity of this product throughout the period. These numbers are reported in each product’s Inventory Unit. • The Value columns show the monetary value of the product based on its inventory value throughout the period. • You can adjust this report to see inventory transactions summarized by the Quantity or Value of the product. By default, you will see a combination of these two views on the Analysis tab. • Select the Printer (Export) icon to print out a copy of the tab you are currently viewing , allowing you to reference this report while recounting products. (Continued) Net-Chef > Inventory: Create/Review Inventories > Review
4 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Review Inventory (Continued) Inventory Review Basic Steps 1. Once counts have been entered for all products, select Save & Review from the Data Entry screen. Tip: We recommend reviewing your counts right after entering them, however if you need to review counts later, just select the Review link from the Create/Review Inventories screen. 2. Select Summarize By Product to see one row per product (checked by default but can be unchecked). 3. Review the Quantity and Value Variances to identify any inventory issues and operational opportunities. If your corporate team hasn’t provided you with specific guidelines for reviewing inventory, continue reading to learn about our recommended review process. 4. If necessary, select Edit to adjust counts on the Data Entry screen. Note: Always re-select Save and Review after editing inventory counts. 5. When finished reviewing, select Save and Close. Net-Chef > Inventory: Create/Review Inventories > Review
5 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Recommended Review Process Crunchtime Recommended Process Our process will help you quickly review th e products that are costing you the most money , making inventory faster, more consistent, and super accurate. Top 10 High Value Products 1. Select the Physical Value column header twice to bring (sort) the highest value products to the top. 2. Confirm that counts for the top 10 products are accurate. a. This high Quantity Variance suggests that the count was entered incorrectly, causing the Physical Value of this product to be overstated. 3. Select Edit to correct counts as necessary. Tip: Your top 1 0 valued products are typically the same from week -to-week. If you notice a product is missing, or one has appeared unexpectedly, this is a sign that a count may have been entered incorrectly. Already a Pro? Here’s the Short Version: 1. Review the top 10 highest value products (largest positive Physical Value). 2. Review the top 10 products with the largest positive and negative Variance Value. 3. Review the products with the highest and lowest Unit Price. Net-Chef > Inventory: Create/Review Inventories > Review
6 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Recommended Review Process (Continued) Top 10 Negative Variances Checking negative variances allows you to identify receiving issues, missed counts, and recipe setup issues. 1. Select the Value Variance column to bring the largest negative variances to the top of the screen, then review the top 10 products for accuracy: • The Beginning Quantity is too high compared to the Physical Quantity, suggesting that too much product was counted at the end of last period. • The Received Quantity is too high based on normal receiving. ▪ Use the Booking Journal to determine if too much product was received on an order. • The Sold Quantity is too low based on normal sales. ▪ Use the Actual/Theoretical Cost report to determine if a recipe is using too little of this product. Contact your corporate team for assistance correcting recipes. • The Adjusted Quantity is too low based on normal operations. ▪ Use the Adjustment Summary to identify any missing waste (Inventory and Recipe Adjustments) or Daily Prep transactions. • The Physical Quantity is much lower than the Beginning Quantity. ▪ Recount this product to ensure no counts are missing or incorrect. • The Quantity Variance is low and the Value Variance is high. ▪ Check the Unit Price link to see if there was a large price increase. Net-Chef > Inventory: Create/Review Inventories > Review
7 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Recommended Review Process (Continued) Top 10 Positive Variances Checking positive variances allows you to identify receiving issues, incorrect counts, and setup issues. 2. Select the Value Variance column again to bring the largest positive variances to the top of the screen, then review the top 10 products for accuracy: • The Beginning Quantity is too low compared to the Physical Quantity, suggesting that too little product was counted at the end of last period. • The Received Quantity is too low based on normal receiving. ▪ Confirm that all orders for this product were reconciled correctly. • The Sold Quantity is too high based on normal sales. ▪ Use the Actual/Theoretical Cost report to determine if a recipe is using too much of this product. Contact your corporate team for assistance correcting recipes. • The Adjusted Quantity is too high based on normal operations. ▪ Use the Adjustment Summary to identify incorrect waste adjustments. Review Daily Prep transactions to verify the correct recipe setup. • The Physical Quantity is much higher than the Beginning Quantity, ▪ Recount this product to ensure no counts are missing or incorrect. Tip: You can use the Physical Inventory Summary report to see what your normal receiving, sales, and adjustments are for a particular product. Net-Chef > Inventory: Create/Review Inventories > Review
8 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Recommended Review Process (Continued) Check the Unit Price Checking for 0.0000 prices allows you to identify receiving mistakes or pricing issues that need to be corrected by your corporate team. 1. Select the Unit Price column to bring the lowest price s to the top of the screen , then check for any products with a unit price of ‘0.000’. • Here is an example of a produced recipe that has a 0.0000 value, which doesn’t make sense. To correct the price, ensure all orders with this product (or sub-products) have been reconciled correctly. (Continued) Net-Chef > Inventory: Create/Review Inventories > Review
9 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Recommended Review Process (Continued) Check the Unit Price (Continued) Checking for high prices allows you to identify receiving mistakes or pricing issues that need to be corrected by your corporate team. 2. Select the Unit Price column again bring the highest prices to the top of the screen, then check for any products with incorrect pricing. • Here is an example of a product with a unit price that is too high. To correct the price, ensure all orders with this product (or sub-products) have been reconciled correctly. Note: If you need further assistance correcting a Unit Price, contact your Crunchtime admin. Net-Chef > Inventory: Create/Review Inventories > Review
10 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Physical Inventory Alert Overview Some companies will establish variance thresholds to help ensure accurate inventory counts. If these thresholds are exceeded, you will receive an alert when selecting Save and Close from the Review screen . The variances for these products must be corrected to complete the review. Setup: These thresholds are configured on the Inventory Preferences screen in Enterprise Manager, and enforced only when the Inventory Variance Post Restriction is enabled in the Location settings. • In this example, t he total Negative Variance Values are more than 20% of the total Book + In Transit Values (for these products). Note: Users with the “NC-Inventory > Override Variance Alerts” permission enabled will have the options to Continue past this alert or Cancel to return to the Review screen. Net-Chef > Inventory: Create/Review Inventories > Review
11 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Physical Inventory Alert (Continued) Identify Alert Products 1. Select the Filter icon. 2. Choose the Filter for Positive Value Variance Alert Products or Filter for Negative Value Variance Alert Products options to see the products that are causing you to receive this alert. 3. Select Apply. Super User Note: The Physical Inventory Alert will not include the following products: • Products whose counts were entered using By Exception. • Products with the Set Theoretical Equal to Actual setting enabled in Enterprise Manager. These products will also be excluded when either of the Alert Product filters are selected. (Continued) Net-Chef > Inventory: Create/Review Inventories > Review
12 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Physical Inventory Alert (Continued) Identify Alert Products (continued) 4. Review the narrowed list of products to correct counts and related inventory transactions. 5. Once all necessary changes have been made, select Save and Close. Pro Tip: To resolve this alert, the sum Variance Value for the relevant alert products must be less than X% of the Book + In Transit Value of those same products. With the filter applied from the previous steps, it’s easy to see these sum values ( as indicated in the screenshot above ). The percentage X is the threshold defined by your corporate team and seen in the alert message. In this example, the sum Variance Value of the negative variance products must be less than 20% of the sum Book + In Transit Value for those same products. To determine what Variance Value is needed to continue, we take 20% of 1,766.58 to get 353.35 (1,766.58 x 0.2 = 353.35). Because we are looking at negative variances, the total Variance Value of these products must be -$353.35 or less (closer to zero) to continue. Net-Chef > Inventory: Create/Review Inventories > Review
13 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Post Inventory Post a Period Once inventory counts have been entered and reviewed, the period is ready to be posted. Posting inventory will finalize all transactions for the period. Warning: Do NOT post incorrect inventory counts as an attempt to resolve variances! 1. From the Administration menu, select Post Inventory. 2. Select Post to finalize inventory for the period. Note: A user must select Save & Close from the inventory Review screen before they can post. If the counts have not been saved prior to posting, the user will be directed to the Review screen. Attention: Depending on your corporate setting, overdue transactions may prevent you from posting. Users with the “Overdue Post Transactions > Override Restricted Post” permission enabled will have the option to continue past this alert. In the case that there are no post restrictions defined in Enterprise Manager, then all users will have the option to bypass this alert, whether this permission is enabled or not. Net-Chef > Administration