© 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Analyze Costs with the Cost Analysis Report Quick Start Guide Document Details Document #: 160_QS1000_230310 Release Version: 10.00.00.00 Version Release Date: October 2022 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-AnalyzeCostsWithCostAnalysisReport OR by scanning the QR code to the left. Related User Group Permissions % Screen Name Control Name Description 92 NC-View Reports Cost Analysis Report Enables this report on the Inventory Reports menu. [141][267]

2 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Analyze Costs with the Cost Analysis Report How to Use the Cost Analysis Report Every great coach reviews last week’s game to see what went right, and what needs to be fixed. The Cost Analysis report is like a highlight reel for your location, showing you what happened during the week just passed – or any other post period you choose. We recommend that your review it each week as part of your end-of-week process. Tip: The Cost Analysis report is best used to compare a selected week’s performance to your typical weekly performance. 1. Open the Reports menu. 2. Select Inventory. 3. Then select Cost Analysis. (Continued) Net-Chef > Reports: Inventory > Cost Analysis

3 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Analyze Costs with the Cost Analysis Report (Continued) How to Use the Cost Analysis Report (Continued) 1. Choose the From Date & To Date for the Post period you want to review. 2. Then select Retrieve. (Continued) Net-Chef > Reports: Inventory > Cost Analysis

4 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Analyze Costs with the Cost Analysis Report (Continued) How to Use the Cost Analysis Report (Continued) The report has three main parts: • At the top, Net Sales are broken out into the GL categories your company has chosen. • In the middle are Cost of Goods Sold by GL category, and your Gross Profit. (Continued) Net-Chef > Reports: Inventory > Cost Analysis

5 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Analyze Costs with the Cost Analysis Report (Continued) How to Use the Cost Analysis Report (Continued) • At the bottom are any GLs that your company has chosen to include as Operating Expenses for your location. • Finally, there’s the proverbial bottom line: your Total Operating Profit. Tip: You can use the Expand (>) and Collapse (v) controls to show or hide the report sections, so you can focus your attention on whichever section(s) you want. (Continued) Net-Chef > Reports: Inventory > Cost Analysis

6 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Analyze Costs with the Cost Analysis Report (Continued) How to Use the Cost Analysis Report (Continued) Collapsing the GL Categories allows you to view a summary of your revenue and expenses, making it easy to determine if you're more or less profitable than usual. Right away you can see the value. At a glance, you can see your: • Total Net Sales • Total Cost of Goods Sold • Total Operating Expenses • Total Operating Profit (Continued) Net-Chef > Reports: Inventory > Cost Analysis

7 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Analyze Costs with the Cost Analysis Report (Continued) How to Use the Cost Analysis Report (Continued) Companies may break their Net Sales into a few key categories. In this example, the company tracks their sales in the following categories: • Retail Sales • Food Promo(tions) • Food Sales (Continued) Net-Chef > Reports: Inventory > Cost Analysis

8 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Analyze Costs with the Cost Analysis Report (Continued) How to Use the Cost Analysis Report (Continued) Some companies will break out their Net Sales into even more specific GL categories. For example, food sales are broken down into: • Bakery Sales (Taxable & Non-Taxable) • Food & Beverage Sales • You can also see the GL Code and Description for each account that’s been broken out. Setup Note: Your company can choose how these percentages are calculated. See the note on page 10 for more details. (Continued) Net-Chef > Reports: Inventory > Cost Analysis

9 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Analyze Costs with the Cost Analysis Report (Continued) How to Use the Cost Analysis Report (Continued) The Cost % column shows the percentage of sales that each GL category/account represents. For example, if your company tracks Bakery Sales, CrunchTime could tell you that: • “Bakery Sales are 26.74% of Total Net Sales,” which includes all Food Sales, Food Promo and Retail Sales. (Continued) Net-Chef > Reports: Inventory > Cost Analysis

10 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Analyze Costs with the Cost Analysis Report (Continued) How to Use the Cost Analysis Report (Continued) OR, it could tell you that: • “Bakery Sales are 41.31% of (just) Food Sales.” Setup Note: The Cost % is calculated as a percentage of either the P&L Substructure OR of Total Net Sales. This is determined by corporate headquarters when defining your budgets. (Continued) Net-Chef > Reports: Inventory > Cost Analysis

11 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Analyze Costs with the Cost Analysis Report (Continued) How to Use the Cost Analysis Report (Continued) Let’s go back to our previous example. Here, we can see: • Retail Sales, Food Promo and Food Sales accounts are all figured as a percentage of Total Net Sales. No matter how you calculate the Cost %, it’s a useful tool. For example, if you were the GM at this location: • You’d be able to use the Cost % to see at a glance if your Bakery Sales were much lower or higher than they usually are, and you’d know to dig in to find out why. (Continued) Net-Chef > Reports: Inventory > Cost Analysis

12 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Analyze Costs with the Cost Analysis Report (Continued) How to Use the Cost Analysis Report (Continued) The same applies to the Cost of Goods Sold section in the middle of the report. • You can easily see your actual Cost Of Goods for each GL account, like Bakery, Dairy, Grocery, Meat, Produce, and Beverage. This will summarize how much you spent in each of these categories. • You can also see the Cost % (of Sales) they represent. • And you can see the cost of Purchases for every GL. Tip: The Cost of Goods you see in this report are the same as the Actual Costs displayed in the Actual/Theoretical Cost report. (Continued) Net-Chef > Reports: Inventory > Cost Analysis

13 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Analyze Costs with the Cost Analysis Report (Continued) How to Use the Cost Analysis Report (Continued) Finally, at the bottom or the report: • You can see the GLs of any Operating Expenses your company has chosen to include. Tip: If any of your Purchases costs are too high or too low compared to how your business normally runs, you can look at the Purchases by GL report to see the transactions for that GL. In short, the Cost Analysis report lets you see at a glance your sales performance and your cost performance by GL. It’s best used to spot sales and cost irregularities compared to how your business normally operates. Net-Chef > Reports: Inventory > Cost Analysis